This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DBF7A6F2-B2FF-40F5-9F28-0341ED45C1A6 | 040edf81a4877738fba679c0928af0a7c3f55b12c8ff6a934d38c713ababacb0 | DBF7A6F2-B2FF-40F5-9F28-0341ED45C1A6.jpeg | 7DB4E745-77F4-495C-8317-1DCBA8B7EC4C-7318-000005F705CA054C_photo.jpg | 2018-02-13T18:53:28+00:00 | 2020-04-20T23:20:33+00:00 | [] |
[
"Geotaggable Photos geotagged",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/D/DBF7A6F2-B2FF-40F5-9F28-0341ED45C1A6.jpeg | 0 | 0 | 0 | 0 | 0 | 25.73758141627914 | -111.09106230174801 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | MX | |||||||||||||
| DD6E4630-85BD-41BF-A7B3-524C02942A65 | 8f49702a9cdd8ab729df55e30f2394524312f7f972c3e6c1615fe457b6bac72c | DD6E4630-85BD-41BF-A7B3-524C02942A65.heic | IMG_3379.HEIC | 2019-03-24T17:53:38+00:00 | 2020-04-20T22:28:34+00:00 | [] |
[
"Super bloom 2019",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/D/DD6E4630-85BD-41BF-A7B3-524C02942A65.heic | 0 | 0 | 0 | 0 | 0 | 34.738725 | -118.38710833333333 | 0 | 1 | 0 | public.heic | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 15101 Lancaster Rd | Lancaster | Los Angeles | CA | 93536 | United States | US | ||||||||
| E50B8F10-65AB-4938-AC6C-C8C35EB1C08C | 8433d50000ebdf053b128c12d529091ee99a847d47e0d6317c002969b5406fed | E50B8F10-65AB-4938-AC6C-C8C35EB1C08C.heic | IMG_4230.HEIC | 2018-04-22T00:10:07+00:00 | 2020-04-20T23:18:24+00:00 | [] |
[
"Museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/E/E50B8F10-65AB-4938-AC6C-C8C35EB1C08C.heic | 0 | 0 | 0 | 0 | 0 | 37.57922 | -122.34410833333334 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/E/E50B8F10-65AB-4938-AC6C-C8C35EB1C08C_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 | ||||||
| E59AB8B3-7305-4E25-85C9-820169986138 | 37d16117b4039b57f821accb98b610bdeb7cb18e733098a93f08ed111d1c76a4 | E59AB8B3-7305-4E25-85C9-820169986138.heic | IMG_3183.HEIC | 2018-02-20T22:43:19+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/E/E59AB8B3-7305-4E25-85C9-820169986138.heic | 0 | 0 | 0 | 0 | 0 | 37.74229666666667 | -122.44947 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/E/E59AB8B3-7305-4E25-85C9-820169986138_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 | ||||||
| E5CE20F5-1129-4B42-B765-D847EE083715 | a5e2d73b2ecb3c659734df6f3a73247ee4630cda0e44eade13e964894de7a03e | E5CE20F5-1129-4B42-B765-D847EE083715.heic | IMG_4240.HEIC | 2018-04-22T00:15:27+00:00 | 2020-04-20T23:18:24+00:00 | [] |
[
"Museums",
"Public"
] |
[
"_UNKNOWN_"
] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/E/E5CE20F5-1129-4B42-B765-D847EE083715.heic | 0 | 0 | 0 | 0 | 0 | 37.57915 | -122.3441 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/E/E5CE20F5-1129-4B42-B765-D847EE083715_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 | ||||||
| E7C46C63-F84B-4535-86A7-A5028CC63E4B | 15b45da65030853a16ffc5e9a54b126d8e1929e82845475fd96f7cf4459758b6 | E7C46C63-F84B-4535-86A7-A5028CC63E4B.heic | IMG_4218.HEIC | 2018-04-22T00:03:12+00:00 | 2020-04-20T23:18:24+00:00 | [] |
[
"Museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/E/E7C46C63-F84B-4535-86A7-A5028CC63E4B.heic | 0 | 0 | 0 | 0 | 0 | 37.57927 | -122.34416166666666 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/E/E7C46C63-F84B-4535-86A7-A5028CC63E4B_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 | ||||||
| EA45776D-2CCA-41EB-A0C4-CCF0D416720C | 6323ea1c6096703eaa318d5c5974adca7b8e1c19285f157536b8b881927c7b6e | EA45776D-2CCA-41EB-A0C4-CCF0D416720C.heic | IMG_3219.HEIC | 2018-02-20T22:54:54+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/E/EA45776D-2CCA-41EB-A0C4-CCF0D416720C.heic | 0 | 0 | 0 | 0 | 0 | 37.742803333333335 | -122.44925 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/E/EA45776D-2CCA-41EB-A0C4-CCF0D416720C_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 | ||||||
| EAA0FF98-970A-42AA-9938-75D632855967 | 4b71652896076d2275b7de1855133d12f0e83e72e3f2df5eebccd312ee7801b2 | EAA0FF98-970A-42AA-9938-75D632855967.heic | IMG_4237.HEIC | 2018-04-22T00:13:03+00:00 | 2020-04-20T23:18:24+00:00 | [] |
[
"Museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/E/EAA0FF98-970A-42AA-9938-75D632855967.heic | 0 | 0 | 0 | 0 | 0 | 37.5793 | -122.34407833333333 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/E/EAA0FF98-970A-42AA-9938-75D632855967_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 | ||||||
| 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 | ||||||
| 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 | ||||||||
| F38B3C90-9701-4460-A9D7-EDCFFAD8CFB2 | 03546cdc3eb2bd9bb65aa3004efbb8e1ca942ba52a6e860582f7c7f725f7a624 | F38B3C90-9701-4460-A9D7-EDCFFAD8CFB2.heic | IMG_6871.HEIC | 2018-09-04T14:29:33+00:00 | 2020-04-20T22:36:08+00:00 | [] |
[
"Museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F38B3C90-9701-4460-A9D7-EDCFFAD8CFB2.heic | 0 | 0 | 0 | 0 | 0 | 50.65674666666666 | -4.251666666666667 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F38B3C90-9701-4460-A9D7-EDCFFAD8CFB2_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Lifton | Devon | England | PL16 | United Kingdom | GB | ||||||||
| 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 | ||||||
| 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 | ||||||
| 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 | ||||||
| FE1BAAE9-C33D-4933-88F0-9BCDA86F2D5B | d0e381a36f050e4eaeb9530446058ff47fbbd42fe36d4c5bbfcea882000112e9 | FE1BAAE9-C33D-4933-88F0-9BCDA86F2D5B.heic | IMG_4610.HEIC | 2018-05-10T23:39:54+00:00 | 2020-04-20T23:17:29+00:00 | [] |
[
"Museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FE1BAAE9-C33D-4933-88F0-9BCDA86F2D5B.heic | 0 | 0 | 0 | 1 | 0 | -32.893811666666664 | -68.856545 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FE1BAAE9-C33D-4933-88F0-9BCDA86F2D5B_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Manuel Antonio Sáez 301–399 | Mendoza City | Mendoza | Mendoza | M5502 | Argentina | AR | |||||||
| 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 |
JSON shape: default, array, newline-delimited, object
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]);