proj_20816

5 rows where picture_agency = "Odhams Press" and sensitive_image = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: group_id, folder, item, photographer

Link rowid ▼ subject_id image1 image2 internal_id group_id part_number folder #Hazard condition item picture_agency photographer oversize sensitive_image sensitive_image_note problematic_language probelmatic_language_notes #Other Number notes
52 52 90433256 SMG00443698_(0001).jpeg SMG00443698_(0002).jpeg SMG00443698 test1 19730 "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 1 none 1 - Good PHOTOGRAPH Odhams Press   0 0   0      
143 143 90770140 SMG00443822_(0001).jpeg SMG00443822_(0002).jpeg SMG00443822 launch 94213 "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 2 none 1 - Good PHOTOGRAPH Odhams Press   0 0   0      
147 147 90770144 SMG00443826_(0001).jpeg SMG00443826_(0002).jpeg SMG00443826 launch 94217 "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 2 none 1 - Good PHOTOGRAPH Odhams Press   0 0   0      
148 148 90770145 SMG00443827_(0001).jpeg SMG00443827_(0002).jpeg SMG00443827 launch 94218 "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 2 none 1 - Good PHOTOGRAPH Odhams Press Giaccone, Fausto 0 0   0      
271 271 90770271 SMG00444115_(0001).jpeg SMG00444115_(0002).jpeg SMG00444115 launch 94506 "Coloured" People in Britain | Pro and Anti "Colour" Orgns; Leagues, etc. none 1 - Good DOCUMENT Odhams Press   0 0   0      

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "proj_20816" (
   [subject_id] INTEGER,
   [image1] TEXT,
   [image2] TEXT,
   [internal_id] TEXT,
   [group_id] TEXT,
   [part_number] INTEGER,
   [folder] TEXT,
   [#Hazard] TEXT,
   [condition] TEXT,
   [item] TEXT,
   [picture_agency] TEXT,
   [photographer] TEXT,
   [oversize] INTEGER,
   [sensitive_image] INTEGER,
   [sensitive_image_note] TEXT,
   [problematic_language] INTEGER,
   [probelmatic_language_notes] TEXT,
   [#Other Number] TEXT,
   [notes] TEXT
);