This data as json, CSV (advanced)
Suggested facets: date, date_modified, favorite, date (date), albums (array)
albums ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46ABC862-9837-404A-832B-4158270704FF | 169984801ec60631b48ca4acac75c2c745951a72024d7145f7803a2978e59267 | 46ABC862-9837-404A-832B-4158270704FF.jpeg | IMG_0089.JPG | 2019-11-02T20:32:16+00:00 | 2019-11-06T04:32:42+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/4/46ABC862-9837-404A-832B-4158270704FF.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 | |||||||||||||||||
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 | |||||||||||||||||
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 | |||||||||||||||||
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 | |||||||||||||||||
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 | |||||||||||||||||
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 | |||||||||||||||||
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 | |||||||||||||||||
8A1CFD4F-AF9F-4018-A451-4709416FAEA0 | 3345e08925ea68ce3808102dce8f4b4e08f6c65a77d405c8b7a4741c322e0c68 | 8A1CFD4F-AF9F-4018-A451-4709416FAEA0.jpeg | IMG_0092.JPG | 2019-11-02T20:39:44+00:00 | 2019-11-06T04:32:42+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/8/8A1CFD4F-AF9F-4018-A451-4709416FAEA0.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
7C21930F-62A8-4540-91C4-E080707A4CC5 | 36e9d2b9e79747b29aba0606d0b8a6a563111ad6a8213a36e618b33d5ee41b51 | 7C21930F-62A8-4540-91C4-E080707A4CC5.jpeg | IMG_0076.JPG | 2019-11-02T20:31:20+00:00 | 2019-11-06T04:32:40+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/7/7C21930F-62A8-4540-91C4-E080707A4CC5.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4E45EBA2-F531-4076-8741-A6D18656D677 | 37f9819e71d4e2ae622f37fb8f1ad0c4d03c6fbe5653f79a5e14ce551ad9a818 | 4E45EBA2-F531-4076-8741-A6D18656D677.jpeg | IMG_0056.JPG | 2019-11-02T20:23:08+00:00 | 2019-11-06T04:32:33+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/4/4E45EBA2-F531-4076-8741-A6D18656D677.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 | |||||||||||||||||
4EC865F7-E05C-42A0-B43A-4D46235F6F9C | 4835c1442d65d55dedd5ab611d33201c41f5501a905cdc7decf0ff4563f423d8 | 4EC865F7-E05C-42A0-B43A-4D46235F6F9C.jpeg | IMG_0081.JPG | 2019-11-02T20:31:34+00:00 | 2019-11-06T04:32:40+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/4/4EC865F7-E05C-42A0-B43A-4D46235F6F9C.jpeg | 0 | 0 | 0 | 0 | 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 | |||||||||||||||||
0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A | 4f164a611976a9ab84deac5a5aeb875bac3cfdbcb21852a8e4bcbdf8e38e7e90 | 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A.jpeg | IMG_0060.JPG | 2019-11-02T20:23:51+00:00 | 2019-11-06T04:32:39+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/0/0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
2B4AD4FE-BEB7-4E86-84B4-2BEBA79615F7 | 54c548a1c0f7e162558828db6bba845c2e9687cb148e877c58e975c9b2dfac61 | 2B4AD4FE-BEB7-4E86-84B4-2BEBA79615F7.jpeg | IMG_0057.JPG | 2019-11-02T20:23:10+00:00 | 2019-11-06T04:32:39+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/2/2B4AD4FE-BEB7-4E86-84B4-2BEBA79615F7.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
398058A8-F11E-4306-8272-05A438B6E523 | 5bad707a8d2196bdb37eaea0501f8745535af125cc5bf5725451258a6247847d | 398058A8-F11E-4306-8272-05A438B6E523.jpeg | IMG_0068.JPG | 2019-11-02T20:30:21+00:00 | 2019-11-06T04:32:34+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/3/398058A8-F11E-4306-8272-05A438B6E523.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
5FCADAE8-4708-4E56-B6B0-F718EE9446F7 | 64d4969938ae0359e40e8450801788ee372e29e5f755d3c5a1f671f2212bc809 | 5FCADAE8-4708-4E56-B6B0-F718EE9446F7.jpeg | IMG_0075.JPG | 2019-11-02T20:31:19+00:00 | 2019-11-06T04:32:35+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/5/5FCADAE8-4708-4E56-B6B0-F718EE9446F7.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 | |||||||||||||||||
2C40753A-80EB-4B9E-B0C4-678E61A06C55 | 79c147d029b433c3ef13a29afe060dfa4866b928c64f375788df5ecc2a2d0e65 | 2C40753A-80EB-4B9E-B0C4-678E61A06C55.jpeg | IMG_0082.JPG | 2019-11-02T20:31:46+00:00 | 2019-11-06T04:32:41+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/2/2C40753A-80EB-4B9E-B0C4-678E61A06C55.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
08D18A51-8004-4F00-B79E-4AA1628FB111 | 7e284f6fd7631015c32f82d4f57454941dc145fa608e510ccc84fea71b09cab1 | 08D18A51-8004-4F00-B79E-4AA1628FB111.jpeg | IMG_0067.JPG | 2019-11-02T20:30:15+00:00 | 2019-11-06T04:32:34+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/0/08D18A51-8004-4F00-B79E-4AA1628FB111.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
01CEBCA2-922B-407C-A726-95D9E0EAB31C | 83667863dcd289d0c96e5d3ed3eb5dfe7ea399203b6cf00bc3e9c3566e7ac705 | 01CEBCA2-922B-407C-A726-95D9E0EAB31C.jpeg | IMG_0070.JPG | 2019-11-02T20:30:31+00:00 | 2019-11-06T04:32:34+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/0/01CEBCA2-922B-407C-A726-95D9E0EAB31C.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
41CFBC2A-16F0-4F09-9A9F-5B83AA554B1D | 88cb2bf7299d65b53c69b24b13848fa2daeaeeeab75f98affaccf522c0dc7d42 | 41CFBC2A-16F0-4F09-9A9F-5B83AA554B1D.jpeg | IMG_0066.JPG | 2019-11-02T20:30:04+00:00 | 2019-11-06T04:32:33+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/4/41CFBC2A-16F0-4F09-9A9F-5B83AA554B1D.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
5C8A9E7C-62A9-4609-95C7-75826C03EF24 | 8bc56b3f8a20e0370f225bd7e9016c5435f837cbd37a640ac89bc6fab6c88983 | 5C8A9E7C-62A9-4609-95C7-75826C03EF24.jpeg | IMG_0088.JPG | 2019-11-02T20:32:13+00:00 | 2019-11-06T04:32:41+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/5/5C8A9E7C-62A9-4609-95C7-75826C03EF24.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
429A1239-744D-4A61-A33B-1BF261584128 | 9d0b55a181e5acc3dd658ac1c79c7000cde794058c3e93698d1337ca6d4e348a | 429A1239-744D-4A61-A33B-1BF261584128.jpeg | IMG_0084.JPG | 2019-11-02T20:32:07+00:00 | 2019-11-06T04:32:41+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/4/429A1239-744D-4A61-A33B-1BF261584128.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
1B6765D2-F281-48DB-A23A-C081FFAC69DC | a12312146b3a13e844481394def7506dbc27b794f150796b466c07c65e2d77b0 | 1B6765D2-F281-48DB-A23A-C081FFAC69DC.jpeg | IMG_0077.JPG | 2019-11-02T20:31:26+00:00 | 2019-11-06T04:32:40+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/1/1B6765D2-F281-48DB-A23A-C081FFAC69DC.jpeg | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
65600C73-CFBC-4FD9-AADE-9CA39F776FC2 | a50d3c5dc31188f36a8f2f6176c6469a5b62cb270962ba63737b3bfc5c9462f8 | 65600C73-CFBC-4FD9-AADE-9CA39F776FC2.jpeg | IMG_0071.JPG | 2019-11-02T20:30:31+00:00 | 2019-11-06T04:32:34+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/6/65600C73-CFBC-4FD9-AADE-9CA39F776FC2.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 | |||||||||||||||||
6DD60E1B-A93F-431C-BEE5-E7B2AEF430BE | d597f6879722f4f91e3558f509a859171132b60d7df319ba3fea358fa175d704 | 6DD60E1B-A93F-431C-BEE5-E7B2AEF430BE.jpeg | IMG_0059.JPG | 2019-11-02T20:23:27+00:00 | 2019-11-06T04:32:33+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/6/6DD60E1B-A93F-431C-BEE5-E7B2AEF430BE.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 | |||||||||||||||||
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]);