apple_photos

233 rows where live_photo = 1 sorted by place_country

✎ View and edit SQL

This data as json, CSV (advanced)

live_photo ✖

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
EDD0562E-B010-44B3-9AA8-509F494351E1 55a68d0f58176b06688b769b6be687ac460615526ed1d52affde448f153bba50   EDD0562E-B010-44B3-9AA8-509F494351E1.heic IMG_4236.HEIC   2018-04-22T00:12:02+00:00 2020-04-20T23:18:24+00:00   
[]
 
[
    "Museums",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/E/EDD0562E-B010-44B3-9AA8-509F494351E1.heic 0 0 0 0 0 37.57923666666667 -122.34407   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/E/EDD0562E-B010-44B3-9AA8-509F494351E1_3.mov 1 1 0 0 0 0 0 0 0 0     218 California Dr Downtown Burlingame Burlingame San Mateo CA 94010 United States US
EECDD2BE-E93F-4830-8435-68681476E833 7c8518ac608ee1cec1d652018536ba1e77fd2434536d5016ef825e0990b80bb6   EECDD2BE-E93F-4830-8435-68681476E833.jpeg IMG_1254.JPG   2016-11-05T20:47:12+00:00 2020-04-21T02:37:00+00:00   
[]
 
[
    "Museums",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/E/EECDD2BE-E93F-4830-8435-68681476E833.jpeg 0 0 0 0 0 37.82842 -122.527275   0 1 0 public.jpeg 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/E/EECDD2BE-E93F-4830-8435-68681476E833_3.mov 1 1 0 0 0 0 1 0 0 0         Sausalito Marin CA 94965 United States US
EF60300F-550E-4921-BA04-EA972EEFF269 5d27b85ff783a2fa1c9e9533157ffd680c06cb957206054aa25ee5786e49ba84   EF60300F-550E-4921-BA04-EA972EEFF269.heic IMG_3097.HEIC   2020-01-25T18:07:06+00:00 2020-04-20T21:58:19+00:00   
[]
 
[
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/E/EF60300F-550E-4921-BA04-EA972EEFF269.heic 0 0 0 1 0 37.1148555 -122.32795000000002   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/E/EF60300F-550E-4921-BA04-EA972EEFF269_3.mov 1 1 0 0 0 0 0 0 0 0         Pescadero San Mateo CA 94060 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
F19B5D7D-EFD0-4BE6-B335-CBE309FABB41 5dd80ab326459d68c5d9acc8f7094aa4761b9f98ff7f774a3c8b1c25cbf49f83   F19B5D7D-EFD0-4BE6-B335-CBE309FABB41.jpeg IMG_3488.JPG   2017-06-16T01:28:19+00:00 2020-04-21T05:49:07+00:00   
[]
 
[
    "Museums",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F19B5D7D-EFD0-4BE6-B335-CBE309FABB41.jpeg 0 0 0 0 0 37.772616666666664 -122.45991333333333   0 1 0 public.jpeg 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F19B5D7D-EFD0-4BE6-B335-CBE309FABB41_3.mov 1 1 0 0 0 0 0 0 0 0     100 John F Kennedy Dr   San Francisco San Francisco CA 94118 United States US
F3DAB898-0907-410B-B796-9999D8E773A7 ad9ef159b032c9390823705c5c527212864618c1f40128d3684b850dd5a27f96   F3DAB898-0907-410B-B796-9999D8E773A7.heic IMG_4242.HEIC   2018-04-22T00:15:46+00:00 2020-04-20T23:18:24+00:00   
[]
 
[
    "Museums",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F3DAB898-0907-410B-B796-9999D8E773A7.heic 0 0 0 0 0 37.57923666666667 -122.34424666666666   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F3DAB898-0907-410B-B796-9999D8E773A7_3.mov 1 1 0 0 0 0 0 0 0 0     218 California Dr Downtown Burlingame Burlingame San Mateo CA 94010 United States US
F55C40DC-FF30-40F0-92BD-FBD1BD14B68B ccd368e8a772e5ac1a2ebf1ddebf143dbd84c871ebaaedc39c24b4266ee08e7a   F55C40DC-FF30-40F0-92BD-FBD1BD14B68B.heic IMG_4245.HEIC   2018-04-22T00:18:11+00:00 2020-04-20T23:18:24+00:00   
[]
 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F55C40DC-FF30-40F0-92BD-FBD1BD14B68B.heic 0 0 0 0 0 37.57904666666667 -122.34413833333333   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F55C40DC-FF30-40F0-92BD-FBD1BD14B68B_3.mov 1 1 0 0 0 0 0 0 0 0     218 California Dr Downtown Burlingame Burlingame San Mateo CA 94010 United States US
F5B3B67A-BE7F-4138-847F-A985B790A1D8 ee05096b1dc7fa7fd6edc60c359f64e39652dff2b649169295cd2851fd1534f4   F5B3B67A-BE7F-4138-847F-A985B790A1D8.heic IMG_4228.HEIC   2018-04-22T00:09:26+00:00 2020-04-20T23:18:24+00:00   
[]
 
[
    "Museums",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F5B3B67A-BE7F-4138-847F-A985B790A1D8.heic 0 0 0 0 0 37.57923 -122.34417833333333   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F5B3B67A-BE7F-4138-847F-A985B790A1D8_3.mov 1 1 0 0 0 0 0 0 0 0     218 California Dr Downtown Burlingame Burlingame San Mateo CA 94010 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
F6D98A32-C5E8-4C04-A876-8D316F22B319 e87890aa6bf96b9fe25aa9790468ab58bac4bc079132344ea1482bfc09426062   F6D98A32-C5E8-4C04-A876-8D316F22B319.heic IMG_3164.HEIC   2018-02-20T22:40:35+00:00 2020-04-20T23:19:40+00:00   
[]
 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F6D98A32-C5E8-4C04-A876-8D316F22B319.heic 0 0 0 0 0 37.742641666666664 -122.44940833333334   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F6D98A32-C5E8-4C04-A876-8D316F22B319_3.mov 1 1 0 0 0 0 0 0 0 0     250 Evelyn Way Miraloma Park San Francisco San Francisco CA 94127 United States US
F78D8339-34E9-4A9A-9BF8-6A73F52566EE 00485aa2f328e85a25275dbdbf97af63c36e869f012302206b4c8d1f1e60c26d   F78D8339-34E9-4A9A-9BF8-6A73F52566EE.jpeg IMG_0212.JPG   2017-10-21T18:11:34+00:00 2020-04-21T02:30:56+00:00   
[]
 
[
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F78D8339-34E9-4A9A-9BF8-6A73F52566EE.jpeg 0 0 0 0 0 37.77535 -122.51298666666666   0 1 0 public.jpeg 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F78D8339-34E9-4A9A-9BF8-6A73F52566EE_3.mov 1 1 0 0 0 0 0 0 0 0       Outer Richmond San Francisco San Francisco CA   United States US
F9F1DAD8-0DEC-4272-A0E5-39517811AF71 c7640974717fa2e3c211179191b9b2b34d3515e5cd487593d411ac399889bcbf   F9F1DAD8-0DEC-4272-A0E5-39517811AF71.heic IMG_7216.HEIC   2019-09-14T16:55:41+00:00 2020-04-21T23:57:36+00:00   
[]
 
[
    "Public"
]
 
[
    "Natalie Downe"
]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F9F1DAD8-0DEC-4272-A0E5-39517811AF71.heic 0 0 0 1 0 29.940825 -90.07910833333334   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F9F1DAD8-0DEC-4272-A0E5-39517811AF71_3.mov 1 1 0 0 0 0 0 0 0 0     1504 Oretha Castle Haley Blvd Central City New Orleans Orleans LA 70113 United States US
FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 fd1e5110743f0f83d37a120ca10b81f73f01b3858f7cd569bb16b2686ef329ca   FCC0BF2E-D8AB-4A77-AAF5-427E15978F82.heic IMG_3085.HEIC   2018-02-20T22:06:28+00:00 2020-04-20T23:19:40+00:00   
[]
 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FCC0BF2E-D8AB-4A77-AAF5-427E15978F82.heic 0 0 0 0 0 37.74218 -122.449455   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FCC0BF2E-D8AB-4A77-AAF5-427E15978F82_3.mov 1 1 0 0 0 0 0 0 0 0     250 Evelyn Way Miraloma Park San Francisco San Francisco CA 94127 United States US
FFD294F1-59BE-4B75-9180-B6318671CDEC f1a8c47ca43ab24da4754290585aa10c74478d419b46faf2b232dbb086250d43   FFD294F1-59BE-4B75-9180-B6318671CDEC.heic IMG_3075.HEIC   2018-02-20T22:04:47+00:00 2020-04-20T23:19:40+00:00   
[]
 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FFD294F1-59BE-4B75-9180-B6318671CDEC.heic 0 0 0 0 0 37.742145 -122.44979666666667   0 1 0 public.heic 0 1 /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FFD294F1-59BE-4B75-9180-B6318671CDEC_3.mov 1 1 0 0 0 0 0 0 0 0     250 Evelyn Way Miraloma Park San Francisco San Francisco CA 94127 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 6.854ms · About: dogsheep/dogsheep-photos