proj_20816
1 row where sensitive_image_note = "Shows man with "blacked up face""
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
137 | 137 | 90770134 | SMG00443815_(0001).jpeg | SMG00443815_(0002).jpeg | SMG00443815 | launch | 94206 | "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 2 | none | 1 - Good | PHOTOGRAPH | Sun (1964-1969) | 0 | 1 | Shows man with "blacked up face" | 1 |
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 );