proj_20816
1 row where #Hazard = "none" and part_number = 94179
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
113 | 113 | 90770109 | SMG00443788_(0001).jpeg | SMG00443788_(0002).jpeg | SMG00443788 | launch | 94179 | "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 3 | none | 1 - Good | PHOTOGRAPH | Sun (1964-1969) | Young, [Robert] | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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 );