proj_21084

2 rows where picture_agency = "None"

✎ 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
6 6 87892461 Photograph   "Coloured" People in Britain|Pro and Anti "Colour" Orgns; Leagues, etc. SMG00444111_0001.jpg SMG00444111_0002.jpg None N test1 1 - Good SMG00444111 94502     None N Y Outdated racist language and swastika symbol
7 7 87892462 Photograph   "Coloured" People in Britain|Folder 1 SMG00443828_0001.jpg SMG00443828_0002.jpg None N test1 1 - Good SMG00443828 94219     None 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
);