This data as json, CSV (advanced)
Suggested facets: albums, favorite, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 369683A6-C32A-4E2D-9492-25BD553B1B6E | 8761c02e415f940008d5feba68d55aad1706623d537a18f6cf51d59d7eee284f | 369683A6-C32A-4E2D-9492-25BD553B1B6E.jpeg | DSC_0232.JPG | 2015-10-05T14:54:39+00:00 | 2020-04-05T02:56:18+00:00 | [] |
[
"Museums",
"Niche museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/3/369683A6-C32A-4E2D-9492-25BD553B1B6E.jpeg | 0 | 1 | 0 | 0 | 0 | /Users/simon/Pictures/Photos Library.photoslibrary/resources/renders/3/369683A6-C32A-4E2D-9492-25BD553B1B6E_1_201_a.jpeg | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
| 40AA745C-DB5B-47B8-A6A6-C8C941826009 | 2071cfe9798e06cfa5873f217d3730d260f1c077dbcd7fec74a0cbe1fee26a99 | 40AA745C-DB5B-47B8-A6A6-C8C941826009.jpeg | DSC_0238.JPG | 2015-10-05T14:55:12+00:00 | 2020-04-05T02:46:57+00:00 | [] |
[
"Museums",
"Niche museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/4/40AA745C-DB5B-47B8-A6A6-C8C941826009.jpeg | 0 | 1 | 0 | 0 | 0 | /Users/simon/Pictures/Photos Library.photoslibrary/resources/renders/4/40AA745C-DB5B-47B8-A6A6-C8C941826009_1_201_a.jpeg | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
| 870ADED8-302A-4D9F-9A99-C0AB7E132703 | 65ce0a3532954a8ae4bb4a89a7db165e25e79ddec45202df906e5167e997dfd6 | 870ADED8-302A-4D9F-9A99-C0AB7E132703.jpeg | IMG_0354.JPG | 2020-02-22T22:49:08+00:00 | 2020-04-05T06:11:11+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/8/870ADED8-302A-4D9F-9A99-C0AB7E132703.jpeg | 0 | 1 | 0 | 1 | 0 | /Users/simon/Pictures/Photos Library.photoslibrary/resources/renders/8/870ADED8-302A-4D9F-9A99-C0AB7E132703_1_201_a.jpeg | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
| AF2D570F-C629-4894-BFC2-FB019F1DAF80 | f5b01d7ffd018e078bb6e197a4528ba5f030f7504124b9506fd91bbf3f6caa2c | AF2D570F-C629-4894-BFC2-FB019F1DAF80.jpeg | IMG_9856.JPG | 2019-09-15T12:42:31+00:00 | 2020-04-05T05:00:24+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/A/AF2D570F-C629-4894-BFC2-FB019F1DAF80.jpeg | 0 | 1 | 0 | 1 | 0 | /Users/simon/Pictures/Photos Library.photoslibrary/resources/renders/A/AF2D570F-C629-4894-BFC2-FB019F1DAF80_1_201_a.jpeg | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
| B426930E-FED6-4916-BBB9-73934393B5C8 | 2512ce4ad5e082d62744af9268e903dde304867ff95f8782c0da3925835ff1ac | B426930E-FED6-4916-BBB9-73934393B5C8.jpeg | DSC_0229.JPG | 2015-10-05T14:48:06+00:00 | 2020-04-05T05:30:38+00:00 | [] |
[
"Museums",
"Niche museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/B/B426930E-FED6-4916-BBB9-73934393B5C8.jpeg | 0 | 1 | 0 | 0 | 0 | /Users/simon/Pictures/Photos Library.photoslibrary/resources/renders/B/B426930E-FED6-4916-BBB9-73934393B5C8_1_201_a.jpeg | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
| BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 | 6f0558a227b6c1acc2259af4e4d3d6aac4ce7148cda96ad212c4a6fd45ef36a1 | BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2.jpeg | DSC_0240.JPG | 2015-10-05T14:55:32+00:00 | 2020-04-05T05:46:09+00:00 | [] |
[
"Museums",
"Niche museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/B/BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2.jpeg | 0 | 1 | 0 | 0 | 0 | /Users/simon/Pictures/Photos Library.photoslibrary/resources/renders/B/BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2_1_201_a.jpeg | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
| BF9CEE04-8E45-4586-BC61-7E5921483763 | 4d716099e85d3ba064b1cfbc236fc58381dc15b17ce4368141d10a39747b7998 | BF9CEE04-8E45-4586-BC61-7E5921483763.jpeg | IMG_9834.JPG | 2019-09-15T12:32:01+00:00 | 2020-04-05T03:16:57+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/B/BF9CEE04-8E45-4586-BC61-7E5921483763.jpeg | 0 | 1 | 0 | 1 | 0 | /Users/simon/Pictures/Photos Library.photoslibrary/resources/renders/B/BF9CEE04-8E45-4586-BC61-7E5921483763_1_201_a.jpeg | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
| D755ECF0-4954-461A-8523-2BCA917DA37C | 3bff710e021160610debf1cef0002dd77afc78694c1ad1373c2bc5a0c244658e | D755ECF0-4954-461A-8523-2BCA917DA37C.jpeg | IMG_9998.JPG | 2019-09-15T14:11:18+00:00 | 2020-04-05T05:41:06+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/D/D755ECF0-4954-461A-8523-2BCA917DA37C.jpeg | 0 | 1 | 0 | 1 | 0 | /Users/simon/Pictures/Photos Library.photoslibrary/resources/renders/D/D755ECF0-4954-461A-8523-2BCA917DA37C_1_201_a.jpeg | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
| FC80510B-1BFF-4750-9C67-DEB2E8605F0A | 58ae5c3c9e69215d3da0e32a4beb6cf8e1c9a76a98d2b522dee8cff9481a17b5 | FC80510B-1BFF-4750-9C67-DEB2E8605F0A.jpeg | IMG_0412.JPG | 2020-02-22T23:06:38+00:00 | 2020-04-05T06:10:57+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FC80510B-1BFF-4750-9C67-DEB2E8605F0A.jpeg | 0 | 1 | 0 | 1 | 0 | /Users/simon/Pictures/Photos Library.photoslibrary/resources/renders/F/FC80510B-1BFF-4750-9C67-DEB2E8605F0A_1_201_a.jpeg | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
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]);