proj_20816

14 rows where group_id = "test1", picture_agency = "Sun (1964-1969)" and problematic_language = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: folder, condition, item, photographer, #Other Number

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
39 39 90433243 SMG00443683_(0001).jpeg SMG00443683_(0002).jpeg SMG00443683 test1 94074 "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 1 none 1 - Good PHOTOGRAPH Sun (1964-1969)   0 0   0      
44 44 90433248 SMG00443689_(0001).jpeg SMG00443689_(0002).jpeg SMG00443689 test1 94080 West Indies | Anguilla - British Forces "Invasion" - 1969 none 2 - Fair PHOTOGRAPH Sun (1964-1969)   0 0   0   1969-677  
51 51 90433255 SMG00443697_(0001).jpeg SMG00443697_(0002).jpeg SMG00443697 test1 15871 "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 1 none 1 - Good PHOTOGRAPH Sun (1964-1969)   0 0   0      
55 55 90433259 SMG00443701_(0001).jpeg SMG00443701_(0002).jpeg SMG00443701 test1 94092 "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 1 none 1 - Good PHOTOGRAPH Sun (1964-1969)   0 0   0   1983-5326/19731  
58 58 90433262 SMG00443704_(0001).jpeg SMG00443704_(0002).jpeg SMG00443704 test1 94095 "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 1 none 1 - Good PHOTOGRAPH Sun (1964-1969) Kaye, Maurice 0 0   0      
65 65 90433269 SMG00443714_(0001).jpeg SMG00443714_(0002).jpeg SMG00443714 test1 94105 "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 1 none 1 - Good PHOTOGRAPH Sun (1964-1969) Young, [Robert] 0 0   0      
77 77 90433281 SMG00443728_(0001).jpeg SMG00443728_(0002).jpeg SMG00443728 test1 94119 "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 1 none 1 - Good PHOTOGRAPH Sun (1964-1969) Kaye, Maurice 0 0   0      
78 78 90433282 SMG00443729_(0001).jpeg SMG00443729_(0002).jpeg SMG00443729 test1 94120 West Indies | Anguilla - British Forces "Invasion" - 1969 none 1 - Good DOCUMENT Sun (1964-1969)   0 0   0      
79 79 90433283 SMG00443733_(0001).jpeg SMG00443733_(0002).jpeg SMG00443733 test1 94124 West Indies | Anguilla - British Forces "Invasion" - 1969 none 1 - Good PHOTOGRAPH Sun (1964-1969)   0 0   0      
80 80 90433284 SMG00443734_(0001).jpeg SMG00443734_(0002).jpeg SMG00443734 test1 94125 West Indies | Anguilla - British Forces "Invasion" - 1969 none 1 - Good PHOTOGRAPH Sun (1964-1969)   0 0   0      
96 96 90433300 SMG00443754_(0001).jpeg SMG00443754_(0002).jpeg SMG00443754 test1 94145 "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 2 none 1 - Good NEGATIVE Sun (1964-1969)   0 0   0      
101 101 90433305 SMG00443770_(0001).jpeg SMG00443770_(0002).jpeg SMG00443770 test1 94161 "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 1 none 1 - Good PHOTOGRAPH Sun (1964-1969)   0 0   0      
109 109 90433313 SMG00443784_(0001).jpeg SMG00443784_(0002).jpeg SMG00443784 test1 94175 "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 3 none 2 - Fair PHOTOGRAPH Sun (1964-1969) Murphy, 0 0   0      
111 111 90433315 SMG00443786_(0001).jpeg SMG00443786_(0002).jpeg SMG00443786 test1 94177 "Coloured People" in Britain | Riots and Demonstrations (Including Notting Hill 1958) | Folder 3 none 1 - Good PHOTOGRAPH Sun (1964-1969) Steel, Arthur 0 0   0      

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);