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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9D0280F7-D619-4D2C-B323-B21CAEBA92EF | 277b4b361f6df02e423d1000b4d2a98c758f29a027c4bff347000b3ee93de2ed | 9D0280F7-D619-4D2C-B323-B21CAEBA92EF.jpeg | IMG_0080.JPG | 2019-11-02T20:31:31+00:00 | 2019-11-06T04:32:40+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/9/9D0280F7-D619-4D2C-B323-B21CAEBA92EF.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
A40BDBBE-2DC6-4385-8108-8C15F37610B4 | 48e96bb66208e6f03b85428cde82ab3ae651d3134a078ef4ea1b4f32d1b4c02c | A40BDBBE-2DC6-4385-8108-8C15F37610B4.jpeg | IMG_0073.JPG | 2019-11-02T20:30:59+00:00 | 2019-11-06T04:32:35+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A40BDBBE-2DC6-4385-8108-8C15F37610B4.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
A4F38147-CE20-41A8-8811-583623ABE085 | b35aff17400287b860379849efbfab739524ed040f0b5d59cebbe71021ac32f6 | A4F38147-CE20-41A8-8811-583623ABE085.jpeg | IMG_0090.JPG | 2019-11-02T20:32:27+00:00 | 2019-11-06T04:32:42+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A4F38147-CE20-41A8-8811-583623ABE085.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
A6FB150E-71C0-4524-8344-57CF59FE1B9E | 4360afbd37be230bf9fd6afcc48245e76bf9c81786713400653b2c81fb63f9e7 | A6FB150E-71C0-4524-8344-57CF59FE1B9E.jpeg | IMG_0072.JPG | 2019-11-02T20:30:45+00:00 | 2019-11-06T04:32:34+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A6FB150E-71C0-4524-8344-57CF59FE1B9E.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
A9DA3A99-BD48-48F2-9F5A-2328329D320E | 332ae7b6996628d3cf858e9bccf07d4bc9a2e710417d39f9dd6765a3ef3da0b9 | A9DA3A99-BD48-48F2-9F5A-2328329D320E.jpeg | IMG_0055.JPG | 2019-11-02T20:22:53+00:00 | 2019-11-06T04:32:33+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A9DA3A99-BD48-48F2-9F5A-2328329D320E.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
B0F72802-C713-43D3-899A-81C4AED347DC | 18e73d3bafa71dfc897bb8f8059380c9895372347b59199a31c464bca7fba1d9 | B0F72802-C713-43D3-899A-81C4AED347DC.jpeg | IMG_0085.JPG | 2019-11-02T20:32:07+00:00 | 2019-11-06T04:32:41+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/B/B0F72802-C713-43D3-899A-81C4AED347DC.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
B47D9214-ACC0-4A75-8837-8DCA2E7F0D28 | 27ae6d9cd414eca3aa086919a529fd63f550fefc6964ab92515be63b486de62e | B47D9214-ACC0-4A75-8837-8DCA2E7F0D28.jpeg | IMG_0054.JPG | 2019-11-02T20:22:51+00:00 | 2019-11-06T04:32:33+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/B/B47D9214-ACC0-4A75-8837-8DCA2E7F0D28.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
BA1C8565-7D1C-49E3-93BA-183B8D6B1270 | d687723405fc71baa66683d64212af08b36f0db1cb5caa9e01c61c262d02cfc3 | BA1C8565-7D1C-49E3-93BA-183B8D6B1270.jpeg | IMG_0078.JPG | 2019-11-02T20:31:29+00:00 | 2019-11-06T04:32:40+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/B/BA1C8565-7D1C-49E3-93BA-183B8D6B1270.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
D28ACD11-B3D5-43BE-96C5-9CE7D39E95E1 | 71e43f92a0ac99ed5fa838e65f58a6976c1d3e80908eb4b0427e104da7f4d2e3 | D28ACD11-B3D5-43BE-96C5-9CE7D39E95E1.jpeg | IMG_0079.JPG | 2019-11-02T20:31:30+00:00 | 2019-11-06T04:32:40+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/D/D28ACD11-B3D5-43BE-96C5-9CE7D39E95E1.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
E28B94C5-3FD9-4199-B291-5727F3D40053 | 1bf6f978059091efb89907071b2796f19db07ba2994d6826fc794dcb1ce3d38a | E28B94C5-3FD9-4199-B291-5727F3D40053.jpeg | IMG_0087.JPG | 2019-11-02T20:32:12+00:00 | 2019-11-06T04:32:41+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/E/E28B94C5-3FD9-4199-B291-5727F3D40053.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
E38B4879-580E-454E-A06C-65335EDEBEB1 | 1eb091d77226738cc72f75ec19792182635c5a0ecc5dc77cac70f36c17bb0a54 | E38B4879-580E-454E-A06C-65335EDEBEB1.jpeg | IMG_0058.JPG | 2019-11-02T20:23:18+00:00 | 2019-11-06T04:32:33+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/E/E38B4879-580E-454E-A06C-65335EDEBEB1.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
FC01AB36-9465-4F95-8DC9-618FBC1405A6 | 1da3b02a32b8235544f503965aa55528896aa637e79e12bdf6493c8541967cea | FC01AB36-9465-4F95-8DC9-618FBC1405A6.jpeg | IMG_0065.JPG | 2019-11-02T20:30:03+00:00 | 2019-11-06T04:32:40+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FC01AB36-9465-4F95-8DC9-618FBC1405A6.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
FF230430-EDD4-4E3F-83F9-C105A7EE7598 | f5540186893e81abf2b46cb2108caa981d5a1e063e184f7242709e6287437911 | FF230430-EDD4-4E3F-83F9-C105A7EE7598.jpeg | IMG_0074.JPG | 2019-11-02T20:31:02+00:00 | 2019-11-06T04:32:35+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FF230430-EDD4-4E3F-83F9-C105A7EE7598.jpeg | 0 | 0 | 0 | 0 | 0 | 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]);