proj_21084

1 row where Condition = "1 - Good" and picture_agency = "PA Reuters (PAR)"

✎ 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
10 10 87892467 Photograph   Post War|Immigration_West Indies|Jamaica to England SMG00443870_0001.jpg SMG00443870_0002.jpg none N test1 1 - Good SMG00443870 94261   NMP1204/21 PA Reuters (PAR) 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
);