This data as json, CSV (advanced)
Suggested facets: date_modified, albums, persons, hasadjustments, date (date), date_modified (date), albums (array), persons (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17AF724E-5561-4DF0-877F-DE60DBBBA8B9 | 864ec4f46779b8892961f816730c9b2945989731f1506bc835f9a322e2f3e2ef | 17AF724E-5561-4DF0-877F-DE60DBBBA8B9.jpeg | IMG_1428.JPG | 2020-05-19T04:34:48+00:00 | 2020-05-19T10:17:18+00:00 | [] |
[
"Public"
] |
[
"Natalie Downe"
] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/1/17AF724E-5561-4DF0-877F-DE60DBBBA8B9.jpeg | 0 | 1 | 0 | 1 | 0 | /Users/simon/Pictures/Photos Library.photoslibrary/resources/renders/1/17AF724E-5561-4DF0-877F-DE60DBBBA8B9_1_201_a.jpeg | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | com.canon.cr2-raw-image | /Users/simon/Pictures/Photos Library.photoslibrary/originals/1/17AF724E-5561-4DF0-877F-DE60DBBBA8B9_4.cr2 | ||||||||||||||
| 1FADC083-2278-4D40-A8A0-45AF6D47458F | d8a8d9d590e25d16c5f1da8a29d2c4cc42d0c8028145f604a5f9292c294a9081 | 1FADC083-2278-4D40-A8A0-45AF6D47458F.jpeg | IMG_1387.JPG | 2020-05-16T22:15:20+00:00 | 2020-05-17T04:31:24+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/1/1FADC083-2278-4D40-A8A0-45AF6D47458F.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | com.canon.cr2-raw-image | /Users/simon/Pictures/Photos Library.photoslibrary/originals/1/1FADC083-2278-4D40-A8A0-45AF6D47458F_4.cr2 | |||||||||||||||
| 63ED2057-1E46-45AF-9F7D-1DE5F84BEBFD | 1eb3a357d57391efeec21aed767c395645bfa2bb882d75ce85c7dfa4e0b6fa4a | 63ED2057-1E46-45AF-9F7D-1DE5F84BEBFD.jpeg | IMG_1420.JPG | 2020-05-19T04:32:54+00:00 | 2020-05-19T10:17:18+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/6/63ED2057-1E46-45AF-9F7D-1DE5F84BEBFD.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | com.canon.cr2-raw-image | /Users/simon/Pictures/Photos Library.photoslibrary/originals/6/63ED2057-1E46-45AF-9F7D-1DE5F84BEBFD_4.cr2 | |||||||||||||||
| 6ABAD7FA-24CD-4ED7-BB76-6EECB1CCCACC | f3c765416273a026a566354bccde331bb60228cba6e23452aad503dd270c195d | 6ABAD7FA-24CD-4ED7-BB76-6EECB1CCCACC.jpeg | IMG_1301.JPG | 2020-05-07T16:52:48+00:00 | 2020-05-09T03:52:29+00:00 | [] |
[
"Photography photo essay",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/6/6ABAD7FA-24CD-4ED7-BB76-6EECB1CCCACC.jpeg | 0 | 1 | 0 | 1 | 0 | /Users/simon/Pictures/Photos Library.photoslibrary/resources/renders/6/6ABAD7FA-24CD-4ED7-BB76-6EECB1CCCACC_1_201_a.jpeg | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | com.canon.cr2-raw-image | /Users/simon/Pictures/Photos Library.photoslibrary/originals/6/6ABAD7FA-24CD-4ED7-BB76-6EECB1CCCACC_4.cr2 | ||||||||||||||
| C4D15F2D-8571-447F-B195-05FCDD09A6B5 | 2255b2c89fd53713fbe7619b0cf93798b616f09ec8f70bf4463571d95ff51456 | C4D15F2D-8571-447F-B195-05FCDD09A6B5.jpeg | IMG_1306.JPG | 2020-05-07T16:53:21+00:00 | 2020-05-18T03:39:24+00:00 | [] |
[
"Photography photo essay",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/C/C4D15F2D-8571-447F-B195-05FCDD09A6B5.jpeg | 0 | 1 | 0 | 1 | 0 | /Users/simon/Pictures/Photos Library.photoslibrary/resources/renders/C/C4D15F2D-8571-447F-B195-05FCDD09A6B5_1_201_a.jpeg | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | com.canon.cr2-raw-image | /Users/simon/Pictures/Photos Library.photoslibrary/originals/C/C4D15F2D-8571-447F-B195-05FCDD09A6B5_4.cr2 |
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]);