proj_20816

3 rows where group_id = "launch", item = "PHOTOGRAPH" and picture_agency = "PA Reuters (PAR)"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: folder, #Other Number

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
158 158 90770155 SMG00443838_(0001).jpeg SMG00443838_(0002).jpeg SMG00443838 launch 94229 "Coloured" People in Britain | Folder 1 none 1 - Good PHOTOGRAPH PA Reuters (PAR)   0 0   0      
161 161 90770158 SMG00443841_(0001).jpeg SMG00443841_(0002).jpeg SMG00443841 launch 94232 "Coloured" People in Britain | Folder 1 none 1 - Good PHOTOGRAPH PA Reuters (PAR)   0 0   0      
179 179 90770177 SMG00443870_(0001).jpeg SMG00443870_(0002).jpeg SMG00443870 launch 94261 Post War | Immigration _ West Indies | Jamaica to England none 1 - Good PHOTOGRAPH PA Reuters (PAR)   0 0   0   NMP1204/21  

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
);