apple_photos

16 rows where albums contains "Stolen monasteries"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date_modified, hasadjustments, favorite, longitude, uti, place_street, place_postal_code, date (date), date_modified (date)

albums (array) ✖

uuid ▼ sha256 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
1657E7D6-94E7-4344-BCFE-1F924546CE11 c5b53e0765f828354402aad8d9de6be1c70b4c78cc0db97d30f31697b01fb591   1657E7D6-94E7-4344-BCFE-1F924546CE11.jpeg IMG_2418.JPG   2017-03-31T00:48:44+00:00 2020-04-21T05:49:20+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/1/1657E7D6-94E7-4344-BCFE-1F924546CE11.jpeg 0 0 0 0 0 37.76913 -122.46448666666667   0 1 0 public.jpeg 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/1/1657E7D6-94E7-4344-BCFE-1F924546CE11_3.mov 1 1 0 0 0 0 0 0 0 0     Nancy Pelosi Dr   San Francisco San Francisco CA 94117 United States US
1EAE7EE2-CBE6-491B-A8EF-337859628659 1423536b7567da6562cd1e842bd93be31d8ebe84d797afe4a81644bac2a2c9e3   1EAE7EE2-CBE6-491B-A8EF-337859628659.heic IMG_0671.HEIC   2017-11-05T23:05:44+00:00 2020-04-21T02:30:52+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/1/1EAE7EE2-CBE6-491B-A8EF-337859628659.heic 0 0 0 0 0 37.768975 -122.46446166666666   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/1/1EAE7EE2-CBE6-491B-A8EF-337859628659_3.mov 1 1 0 0 0 0 0 0 0 0     Nancy Pelosi Dr   San Francisco San Francisco CA 94117 United States US
1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB a93401fea4842b551132a24a707ae8e30d646d4830c5c32c3ce7c1ddcdd61bbc   1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB.jpeg IMG_2422.JPG   2017-03-31T00:53:36+00:00 2020-04-21T05:49:20+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/1/1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB.jpeg 0 0 0 1 0 37.76918 -122.46453833333334   0 1 0 public.jpeg 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/1/1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB_3.mov 1 1 0 0 0 0 0 0 0 0     Nancy Pelosi Dr   San Francisco San Francisco CA 94117 United States US
3D7AE6D3-0FD4-4130-B713-44EB2C885A30 6cd24772dbd1f463325dba1e5ab734ceb559741953324b590eb89d3497cda1f4   3D7AE6D3-0FD4-4130-B713-44EB2C885A30.heic IMG_0672.HEIC   2017-11-05T23:05:51+00:00 2020-04-21T02:30:52+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/3/3D7AE6D3-0FD4-4130-B713-44EB2C885A30.heic 0 0 0 0 0 37.768953333333336 -122.464425   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/3/3D7AE6D3-0FD4-4130-B713-44EB2C885A30_3.mov 1 1 0 0 0 0 0 0 0 0     Nancy Pelosi Dr   San Francisco San Francisco CA 94117 United States US
40C65283-9CB3-4FAE-A390-4FDC22BCC29F 0daddeb8eb5e2b05b1b21bc51bf14355201de8303222502595c716f8e52b47fd   40C65283-9CB3-4FAE-A390-4FDC22BCC29F.heic IMG_4085.HEIC   2018-11-26T23:46:00+00:00 2020-04-20T22:32:44+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/4/40C65283-9CB3-4FAE-A390-4FDC22BCC29F.heic 0 0 0 0 0 37.767125 -122.46747   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/4/40C65283-9CB3-4FAE-A390-4FDC22BCC29F_3.mov 1 1 0 0 0 0 0 0 0 0     1199 9th Ave   San Francisco San Francisco CA 94122 United States US
57650917-1883-4D73-AD2B-B45C6A661534 ddea960de035d2fc5726dd94a94692f90f7dc60c7e28e19b45fcc765e2d0813c   57650917-1883-4D73-AD2B-B45C6A661534.jpeg IMG_2420.JPG   2017-03-31T00:53:31+00:00 2020-04-21T05:49:20+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/5/57650917-1883-4D73-AD2B-B45C6A661534.jpeg 0 0 0 0 0 37.769146666666664 -122.46449166666666   0 1 0 public.jpeg 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/5/57650917-1883-4D73-AD2B-B45C6A661534_3.mov 1 1 0 0 0 0 0 0 0 0     Nancy Pelosi Dr   San Francisco San Francisco CA 94117 United States US
60198E20-708E-4125-B793-4466A87B2DDA d553261ef8ec0fc2d81eb04e584491dfcba6d4d58b8455cc741c362ec21eea22   60198E20-708E-4125-B793-4466A87B2DDA.jpeg IMG_3481.JPG   2017-06-16T00:56:17+00:00 2020-04-21T05:49:08+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/6/60198E20-708E-4125-B793-4466A87B2DDA.jpeg 0 0 0 0 0 37.76925 -122.46415   0 1 0 public.jpeg 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/6/60198E20-708E-4125-B793-4466A87B2DDA_3.mov 1 1 0 0 0 0 0 0 0 0     Nancy Pelosi Dr   San Francisco San Francisco CA 94117 United States US
8DDE7452-CF7B-4EA0-AFB4-89A15001F19F 318022d1b2b2e9804d550276366c3b8ad3a61fe5efaf79af0c59d0ae647ff195   8DDE7452-CF7B-4EA0-AFB4-89A15001F19F.jpeg IMG_3478.JPG   2017-06-16T00:54:53+00:00 2020-04-21T05:49:08+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/8/8DDE7452-CF7B-4EA0-AFB4-89A15001F19F.jpeg 0 0 0 0 0 37.76909666666667 -122.46451666666667   0 1 0 public.jpeg 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/8/8DDE7452-CF7B-4EA0-AFB4-89A15001F19F_3.mov 1 1 0 0 0 0 0 0 0 0     Nancy Pelosi Dr   San Francisco San Francisco CA 94117 United States US
A92AF32A-7C12-48CC-B1C3-5C83D05B76AA a981be272530aba690ff4d6e292c3dbfeb1fee4c9fcca39346043012cf486e49   A92AF32A-7C12-48CC-B1C3-5C83D05B76AA.heic IMG_0674.HEIC   2017-11-05T23:06:58+00:00 2020-04-21T02:30:52+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A92AF32A-7C12-48CC-B1C3-5C83D05B76AA.heic 0 0 0 0 0 37.76914166666667 -122.46450833333333   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A92AF32A-7C12-48CC-B1C3-5C83D05B76AA_3.mov 1 1 0 0 0 0 0 0 0 0     Nancy Pelosi Dr   San Francisco San Francisco CA 94117 United States US
AC6610AB-FA5E-4B76-93B8-F91AC0ED2D8A e8984bb084f3dd58c57a1e2f8a1c8cdbb86c903cfc239f61916b3eb86f332655   AC6610AB-FA5E-4B76-93B8-F91AC0ED2D8A.heic IMG_0675.HEIC   2017-11-05T23:07:13+00:00 2020-04-21T02:30:52+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/A/AC6610AB-FA5E-4B76-93B8-F91AC0ED2D8A.heic 0 0 0 0 0 37.769133333333336 -122.46440833333334   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/A/AC6610AB-FA5E-4B76-93B8-F91AC0ED2D8A_3.mov 1 1 0 0 0 0 0 0 0 0     Nancy Pelosi Dr   San Francisco San Francisco CA 94117 United States US
C0BEA1F5-AAA4-4BCD-A9B0-1E4A91218800 c8f40ecddd5157c98a12110e1a9e11a97b72940d1ba4555f73eb17d229559031   C0BEA1F5-AAA4-4BCD-A9B0-1E4A91218800.heic IMG_4087.HEIC   2018-11-26T23:47:36+00:00 2020-04-20T22:32:44+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/C/C0BEA1F5-AAA4-4BCD-A9B0-1E4A91218800.heic 0 0 0 0 0 37.7672 -122.46752166666667   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/C/C0BEA1F5-AAA4-4BCD-A9B0-1E4A91218800_3.mov 1 1 0 0 0 0 0 0 0 0     1199 9th Ave   San Francisco San Francisco CA 94122 United States US
CECB8318-5241-46BB-AABF-8CF8A3B72890 4b6d5de8dc4967be44dc73b9c1e8a47dc0b247c0d08b0020ab69947f1441aada   CECB8318-5241-46BB-AABF-8CF8A3B72890.jpeg IMG_2421.JPG   2017-03-31T00:53:35+00:00 2020-04-21T05:49:20+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/C/CECB8318-5241-46BB-AABF-8CF8A3B72890.jpeg 0 0 0 0 0 37.76917 -122.46453   0 1 0 public.jpeg 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/C/CECB8318-5241-46BB-AABF-8CF8A3B72890_3.mov 1 1 0 0 0 0 0 0 0 0     Nancy Pelosi Dr   San Francisco San Francisco CA 94117 United States US
D3CF77DA-B6DD-47F1-A69C-3E01122F133E fe7c5489ffa8c070183fe2c559c00b6d5880a6b9a9c53f807962166ec96c4375   D3CF77DA-B6DD-47F1-A69C-3E01122F133E.jpeg IMG_2419.JPG   2017-03-31T00:48:54+00:00 2020-04-21T05:49:20+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/D/D3CF77DA-B6DD-47F1-A69C-3E01122F133E.jpeg 0 0 0 0 0 37.7692 -122.46450833333333   0 1 0 public.jpeg 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/D/D3CF77DA-B6DD-47F1-A69C-3E01122F133E_3.mov 1 1 0 0 0 0 0 0 0 0     Nancy Pelosi Dr   San Francisco San Francisco CA 94117 United States US
D735F0CE-A3D7-49CB-B83E-594604415A1C be2e31a4d8ecf12e6631c7fbd0a093a446a7d23ef5dbeb412c41c14907357d16   D735F0CE-A3D7-49CB-B83E-594604415A1C.jpeg IMG_3480.JPG   2017-06-16T00:55:34+00:00 2020-04-21T05:49:08+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/D/D735F0CE-A3D7-49CB-B83E-594604415A1C.jpeg 0 0 0 0 0 37.76930333333333 -122.46441666666666   0 1 0 public.jpeg 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/D/D735F0CE-A3D7-49CB-B83E-594604415A1C_3.mov 1 1 0 0 0 0 0 0 0 0     Nancy Pelosi Dr   San Francisco San Francisco CA 94117 United States US
F142B8D1-24B8-4108-AFB7-0C454C72E625 3c189d4ca97d42b444c05d69f5f798f0ecb1c4066123d5f75d1d0d60e332a475   F142B8D1-24B8-4108-AFB7-0C454C72E625.heic IMG_0673.HEIC   2017-11-05T23:06:49+00:00 2020-04-21T02:30:52+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F142B8D1-24B8-4108-AFB7-0C454C72E625.heic 0 1 0 0 0 37.76921166666666 -122.46446166666666 /Users/simon/Pictures/Photos Library.photoslibrary/resources/renders/F/F142B8D1-24B8-4108-AFB7-0C454C72E625_1_201_a.jpeg 0 1 0 public.jpeg 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F142B8D1-24B8-4108-AFB7-0C454C72E625_3.mov 1 1 0 0 0 0 0 0 0 0     Nancy Pelosi Dr   San Francisco San Francisco CA 94117 United States US
F5F65BC1-8BD3-40A2-B283-EBA2E7657A20 85c32ecbb8b5b4e75514799212c4bdd8c51469269e931a1fb6aa53f87dc92676   F5F65BC1-8BD3-40A2-B283-EBA2E7657A20.jpeg IMG_3479.JPG   2017-06-16T00:54:59+00:00 2020-04-21T05:49:08+00:00   
[]
 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F5F65BC1-8BD3-40A2-B283-EBA2E7657A20.jpeg 0 0 0 0 0 37.76912 -122.46459166666666   0 1 0 public.jpeg 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F5F65BC1-8BD3-40A2-B283-EBA2E7657A20_3.mov 1 1 0 0 0 0 0 0 0 0     Nancy Pelosi Dr   San Francisco San Francisco CA 94117 United States US

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [apple_photos] (
   [sha256] TEXT REFERENCES [uploads]([sha256]),
   [uuid] TEXT PRIMARY KEY,
   [burst_uuid] TEXT,
   [filename] TEXT,
   [original_filename] TEXT,
   [description] TEXT,
   [date] TEXT,
   [date_modified] TEXT,
   [title] TEXT,
   [keywords] TEXT,
   [albums] TEXT,
   [persons] TEXT,
   [path] TEXT,
   [ismissing] INTEGER,
   [hasadjustments] INTEGER,
   [external_edit] INTEGER,
   [favorite] INTEGER,
   [hidden] INTEGER,
   [latitude] FLOAT,
   [longitude] FLOAT,
   [path_edited] TEXT,
   [shared] INTEGER,
   [isphoto] INTEGER,
   [ismovie] INTEGER,
   [uti] TEXT,
   [burst] INTEGER,
   [live_photo] INTEGER,
   [path_live_photo] TEXT,
   [iscloudasset] INTEGER,
   [incloud] INTEGER,
   [portrait] INTEGER,
   [screenshot] INTEGER,
   [slow_mo] INTEGER,
   [time_lapse] INTEGER,
   [hdr] INTEGER,
   [selfie] INTEGER,
   [panorama] INTEGER,
   [has_raw] INTEGER,
   [uti_raw] TEXT,
   [path_raw] TEXT
, [place_street] TEXT, [place_sub_locality] TEXT, [place_city] TEXT, [place_sub_administrative_area] TEXT, [place_state_province] TEXT, [place_postal_code] TEXT, [place_country] TEXT, [place_iso_country_code] TEXT);
CREATE INDEX [idx_apple_photos_date]
                ON [apple_photos] ([date]);
CREATE INDEX [idx_apple_photos_sha256]
                ON [apple_photos] ([sha256]);
Powered by Datasette · Query took 222.781ms · About: dogsheep/dogsheep-photos