proj_21084

1 row where Notes = "Article on back about Steel Drums. Stamped 'Daily Herald 28 July 1951'." and picture_agency = "Associated Press"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ subject_id Item Notes folder image1 image2 #Hazard Oversize group_id Condition internal_id part_number Photographer #Other Number picture_agency Sensitive_Image Problematic_Language Notes on Problematic Language
2 2 87892452 Photograph Article on back about Steel Drums. Stamped 'Daily Herald 28 July 1951'. West Indies|Misc SMG00443623_0001.jpg SMG00443623_0002.jpg None N test1 1 - Good SMG00443623 94014     Associated Press N N  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "proj_21084" (
   [subject_id] INTEGER,
   [Item] TEXT,
   [Notes] TEXT,
   [folder] TEXT,
   [image1] TEXT,
   [image2] TEXT,
   [#Hazard] TEXT,
   [Oversize] TEXT,
   [group_id] TEXT,
   [Condition] TEXT,
   [internal_id] TEXT,
   [part_number] INTEGER,
   [Photographer] TEXT,
   [#Other Number] TEXT,
   [picture_agency] TEXT,
   [Sensitive_Image] TEXT,
   [Problematic_Language] TEXT,
   [Notes on Problematic Language] TEXT
);