public

Custom SQL query returning 5 rows (hide)

select sha256, uuid, burst_uuid, filename, original_filename, description, date, date_modified, title, keywords, albums, persons, path, ismissing, hasadjustments, external_edit, favorite, hidden, latitude, longitude, path_edited, shared, isphoto, ismovie, uti, burst, live_photo, path_live_photo, iscloudasset, incloud, portrait, screenshot, slow_mo, time_lapse, hdr, selfie, panorama, has_raw, uti_raw, path_raw, place_street, place_sub_locality, place_city, place_sub_administrative_area, place_state_province, place_postal_code, place_country, place_iso_country_code from apple_photos where "place_sub_administrative_area" = :p0 and (place_street is not null or (place_street is null and ((uuid > :p1)))) order by place_street, uuid limit 101

Query parameters

This data as json, CSV

sha256	uuid	filename	original_filename	date	date_modified	keywords	albums	persons	path	favorite	latitude	longitude	isphoto	uti	live_photo	path_live_photo	iscloudasset	incloud	place_street	place_sub_locality	place_city	place_sub_administrative_area	place_state_province	place_postal_code	place_country	place_iso_country_code
51f4b1c7d3691bd32170d7f1f343c25e4ce687a3474675501e5295fb8de1e233	659F6A3E-8547-476F-B2AA-883117C53253	659F6A3E-8547-476F-B2AA-883117C53253.heic	IMG_1414.HEIC	2019-12-17T10:05:40+00:00	2020-04-20T22:01:25+00:00	[]	[ "Public" ]	[]	/Users/simon/Pictures/Photos Library.photoslibrary/originals/6/659F6A3E-8547-476F-B2AA-883117C53253.heic	1	51.52467832999999	-0.11347499999999999	1	public.heic	1	/Users/simon/Pictures/Photos Library.photoslibrary/originals/6/659F6A3E-8547-476F-B2AA-883117C53253_3.mov	1	1	21 Phoenix Place	Grays Inn	London	London	England	WC1X	United Kingdom	GB
f35f5580cec4289b90eb9ceebec27f017a5b5911a0b087d7e25efbf86a13b2d0	062B182C-CD24-4EC8-8E27-420EECB14688	062B182C-CD24-4EC8-8E27-420EECB14688.jpeg	IMG_1114.JPG	2015-12-18T13:39:58+00:00	2020-04-21T02:39:59+00:00	[]	[ "Novelty Automation", "Museums", "Public" ]	[]	/Users/simon/Pictures/Photos Library.photoslibrary/originals/0/062B182C-CD24-4EC8-8E27-420EECB14688.jpeg	1	51.51998	-0.11689166666666666	1	public.jpeg	1	/Users/simon/Pictures/Photos Library.photoslibrary/originals/0/062B182C-CD24-4EC8-8E27-420EECB14688_3.mov	1	1	2–10 Princeton Street	Bloomsbury	London	London	England	WC1R 4BH	United Kingdom	GB
046f22422fccd4bbe560f85ad3520e2ab4e9e315f0d1748ce62f87de7ae4b046	28933E0F-FEFC-498F-9F5D-873E0E48B1B9	28933E0F-FEFC-498F-9F5D-873E0E48B1B9.heic	IMG_1568.HEIC	2019-12-18T15:43:35+00:00	2020-04-22T02:39:31+00:00	[]	[ "Public" ]	[ "Natalie Downe" ]	/Users/simon/Pictures/Photos Library.photoslibrary/originals/2/28933E0F-FEFC-498F-9F5D-873E0E48B1B9.heic	1	51.514491670000005	-0.08766383	1	public.heic	1	/Users/simon/Pictures/Photos Library.photoslibrary/originals/2/28933E0F-FEFC-498F-9F5D-873E0E48B1B9_3.mov	1	1	Bank Buildings, 8 Lothbury	Liverpool Street	London	London	England	EC2R 7HH	United Kingdom	GB
b2d13d18e9e15e0e46a652a11638f694266743089b04ae8e1ceec144f9d261f3	A8B386D0-B156-4594-886A-44207E4C0EA8	A8B386D0-B156-4594-886A-44207E4C0EA8.heic	IMG_1373.HEIC	2019-12-17T09:42:50+00:00	2020-04-20T22:01:37+00:00	[]	[ "Public" ]	[]	/Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A8B386D0-B156-4594-886A-44207E4C0EA8.heic	1	51.52411667	-0.11119167	1	public.heic	1	/Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A8B386D0-B156-4594-886A-44207E4C0EA8_3.mov	1	1	Bideford Mansions, Rosebery Avenue	Clerkenwell	London	London	England	EC1R 4SJ	United Kingdom	GB
2914d77166bd3d96058e8c4994e7840b61fc4f42a2be6c67cf2f6dbba96861fb	45CD64EE-9C93-48EA-89F8-8F9C849543F6	45CD64EE-9C93-48EA-89F8-8F9C849543F6.heic	IMG_1562.HEIC	2019-12-18T15:26:39+00:00	2020-04-20T22:01:06+00:00	[]	[ "Public" ]	[]	/Users/simon/Pictures/Photos Library.photoslibrary/originals/4/45CD64EE-9C93-48EA-89F8-8F9C849543F6.heic	1	51.51231333	-0.09033617000000002	1	public.heic	0		1	1	The Walbrook Building, 25 Walbrook	St. Pauls	London	London	England	EC4N 8AF	United Kingdom	GB