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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5BD1D973-19F4-48F1-AB13-A214B0B98452 | 03bd641c31961be01b3f491a7414ccacb2c57dece64fd6fd8e4be6384643ef8e | 5BD1D973-19F4-48F1-AB13-A214B0B98452.heic | IMG_3115.HEIC | 2020-01-25T18:18:00+00:00 | 2020-04-20T21:58:19+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/5/5BD1D973-19F4-48F1-AB13-A214B0B98452.heic | 0 | 0 | 0 | 1 | 0 | 37.11606667000001 | -122.330475 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/5/5BD1D973-19F4-48F1-AB13-A214B0B98452_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | San Mateo | CA | 94060 | United States | US | ||||||||
665B18F1-6E4A-436B-A415-11622E442B2C | 42819b1d0b26b476c552433396fecaf1be936248ced47197a9eed334600c24e1 | 665B18F1-6E4A-436B-A415-11622E442B2C.jpeg | IMG_0239.JPG | 2020-01-25T19:39:28+00:00 | 2020-01-25T19:24:25+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/6/665B18F1-6E4A-436B-A415-11622E442B2C.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
745C8ADF-08E9-48D1-98A7-01D16E49635C | 8a2c43b2888b0777a9ffa4679f13011b3bd91cd57c4fe34a5b612c1bc4ceb147 | 745C8ADF-08E9-48D1-98A7-01D16E49635C.heic | IMG_3094.HEIC | 2020-01-25T18:05:50+00:00 | 2020-04-20T21:58:31+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/7/745C8ADF-08E9-48D1-98A7-01D16E49635C.heic | 0 | 0 | 0 | 1 | 0 | 37.11481117 | -122.32784167 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/7/745C8ADF-08E9-48D1-98A7-01D16E49635C_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | San Mateo | CA | 94060 | United States | US | ||||||||
75769611-9E07-4AD8-B4E5-EADBB49A24B6 | 8e11c96572a7adaf0336e8c28efda0bd88625e1d52f599edf3ec18e8ef6c3e6a | 75769611-9E07-4AD8-B4E5-EADBB49A24B6.jpeg | IMG_0215.JPG | 2020-01-25T19:24:51+00:00 | 2020-01-25T19:24:19+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/7/75769611-9E07-4AD8-B4E5-EADBB49A24B6.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
82A06650-7B8E-4201-B971-3DE78335B82C | b95d5a4455b8a51754ee4967c137988efd1e2044ee15e2a5439b7efbde4de662 | 82A06650-7B8E-4201-B971-3DE78335B82C.jpeg | IMG_0199.JPG | 2020-01-25T19:22:02+00:00 | 2020-01-25T19:24:14+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/8/82A06650-7B8E-4201-B971-3DE78335B82C.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
8482D147-E926-4B79-9264-533A31F5DF2D | 6b8ef6a1de38c5e897e740c407caa88bbe307b561dac970ccd9b58f870a1f85e | 8482D147-E926-4B79-9264-533A31F5DF2D.heic | IMG_3112.HEIC | 2020-01-25T18:14:27+00:00 | 2020-04-20T21:58:19+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/8/8482D147-E926-4B79-9264-533A31F5DF2D.heic | 0 | 0 | 0 | 1 | 0 | 37.11621117 | -122.32977999999999 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/8/8482D147-E926-4B79-9264-533A31F5DF2D_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | San Mateo | CA | 94060 | United States | US | ||||||||
87585FA7-EF4D-4028-97D2-21631F66A32D | 04646192855eb795b440552ad953dd63ed7ef4adece0bb85d42b19586a6e2c59 | 87585FA7-EF4D-4028-97D2-21631F66A32D.jpeg | IMG_0190.JPG | 2020-01-25T19:17:10+00:00 | 2020-01-25T19:24:13+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/8/87585FA7-EF4D-4028-97D2-21631F66A32D.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
918F5128-ED51-4B1D-AA2C-2F14620312D9 | e2b0909125998e92b5706502750d803bc015626f46245dc6200485596ceaa9fd | 918F5128-ED51-4B1D-AA2C-2F14620312D9.jpeg | IMG_0227.JPG | 2020-01-25T19:33:14+00:00 | 2020-01-25T19:24:22+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/9/918F5128-ED51-4B1D-AA2C-2F14620312D9.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
92BCC6F0-0144-4501-A78D-778B3E48BF39 | 22772bd05c0d6e769ea86ebaa1b58ed1645b4eabc9dcc9fea052196954438fdc | 92BCC6F0-0144-4501-A78D-778B3E48BF39.jpeg | IMG_0277.JPG | 2020-01-25T20:09:19+00:00 | 2020-01-25T19:24:35+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/9/92BCC6F0-0144-4501-A78D-778B3E48BF39.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
9AEC59F0-3F75-4204-B714-152B697AD6F0 | 1a002a90928b3ebf1cfc5e4a2e274f9e8a14345a634cb05751ad1ce3da6b7c52 | 9AEC59F0-3F75-4204-B714-152B697AD6F0.jpeg | IMG_0196.JPG | 2020-01-25T19:20:41+00:00 | 2020-01-25T19:24:14+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/9/9AEC59F0-3F75-4204-B714-152B697AD6F0.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
9B1D1359-1267-42DE-BB2C-6DB3B885D3E0 | a29c3a38ab84cb5a9158d2d1f5047f614c3065bc852042909e5ac09a59988275 | 9B1D1359-1267-42DE-BB2C-6DB3B885D3E0.jpeg | IMG_0211.JPG | 2020-01-25T19:22:55+00:00 | 2020-01-25T19:24:18+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/9/9B1D1359-1267-42DE-BB2C-6DB3B885D3E0.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
A7B4A20F-E043-4229-A913-6EE1B2679D8C | 3bc6d33c08d4a70a442c7b1cee387f841108de0b8a242f6df8d13796c179051a | A7B4A20F-E043-4229-A913-6EE1B2679D8C.jpeg | IMG_0172.JPG | 2020-01-25T18:59:14+00:00 | 2020-01-25T19:24:07+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A7B4A20F-E043-4229-A913-6EE1B2679D8C.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
A8B85D87-3E69-402E-A1EA-3DD819270531 | 1307ecb271a8f7357b7151de2cd5cbec2e7232d91a2404daa5a716c0d96b4fc9 | A8B85D87-3E69-402E-A1EA-3DD819270531.heic | IMG_3101.HEIC | 2020-01-25T18:09:33+00:00 | 2020-04-20T21:58:19+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A8B85D87-3E69-402E-A1EA-3DD819270531.heic | 0 | 0 | 0 | 1 | 0 | 37.115119500000006 | -122.32771333000001 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A8B85D87-3E69-402E-A1EA-3DD819270531_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | San Mateo | CA | 94060 | United States | US | ||||||||
AEFB3049-40B6-41FD-81AA-571B369B79DB | 9d24f646179a5110b384061d7911acf849957530304e5ac141b86edab4b7b3a0 | AEFB3049-40B6-41FD-81AA-571B369B79DB.heic | IMG_3128.HEIC | 2020-01-25T19:12:52+00:00 | 2020-04-20T21:58:17+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/A/AEFB3049-40B6-41FD-81AA-571B369B79DB.heic | 0 | 0 | 0 | 1 | 0 | 37.11494717 | -122.32808 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/A/AEFB3049-40B6-41FD-81AA-571B369B79DB_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | San Mateo | CA | 94060 | United States | US | ||||||||
B29AB28B-D604-408A-923C-45D779BCB380 | 6f92ecbbc9835eedeb6c95e828fe99398a85ead6c52dd116bd953cf4a26dafb6 | B29AB28B-D604-408A-923C-45D779BCB380.jpeg | IMG_0268.JPG | 2020-01-25T19:57:50+00:00 | 2020-01-25T19:24:32+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/B/B29AB28B-D604-408A-923C-45D779BCB380.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
B2D7A748-4171-43EA-8561-917E3A1007D4 | a4e1151738c54fb914d1be6b4dbd1a9a73724b36e64024e2e9193257ea6aeeed | B2D7A748-4171-43EA-8561-917E3A1007D4.jpeg | IMG_0206.JPG | 2020-01-25T19:22:41+00:00 | 2020-01-25T19:24:17+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/B/B2D7A748-4171-43EA-8561-917E3A1007D4.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
B5AC8228-D496-43B3-9F69-69BFB2BFF177 | 14620230b833ea022fdbed283eae903ae8e82fe27e943d5fc1fe0f502f6e9e6e | B5AC8228-D496-43B3-9F69-69BFB2BFF177.heic | IMG_3114.HEIC | 2020-01-25T18:16:15+00:00 | 2020-04-20T21:58:19+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/B/B5AC8228-D496-43B3-9F69-69BFB2BFF177.heic | 0 | 0 | 0 | 1 | 0 | 37.11623049999999 | -122.33001667 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/B/B5AC8228-D496-43B3-9F69-69BFB2BFF177_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | San Mateo | CA | 94060 | United States | US | ||||||||
BA466D66-989B-4E8B-9553-85D91421A124 | 3bfaee669a60e68459cd2a6301cbd8f919a22c8aa8b16c9bcf922b00684bacca | BA466D66-989B-4E8B-9553-85D91421A124.jpeg | IMG_0220.JPG | 2020-01-25T19:29:49+00:00 | 2020-01-25T19:24:20+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/B/BA466D66-989B-4E8B-9553-85D91421A124.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
BB3FF61C-1AE0-4B7F-AD0E-822267EE277A | 19ced52283f89efaa5aa883ab9394006f5416650b6e68de75775e449886fffeb | BB3FF61C-1AE0-4B7F-AD0E-822267EE277A.jpeg | IMG_0282.JPG | 2020-01-25T20:15:08+00:00 | 2020-04-18T15:17:15+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/B/BB3FF61C-1AE0-4B7F-AD0E-822267EE277A.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
BCAEC510-5871-42B9-9A19-C5FB587F61FA | e02df647bbc0ccc62c05a275c54edeb0529fc7032b182ec91a69556b70a7fa8e | BCAEC510-5871-42B9-9A19-C5FB587F61FA.heic | IMG_3077.HEIC | 2020-01-25T16:57:07+00:00 | 2020-04-20T21:58:31+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/B/BCAEC510-5871-42B9-9A19-C5FB587F61FA.heic | 0 | 0 | 0 | 1 | 0 | 37.11899167 | -122.307175 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/B/BCAEC510-5871-42B9-9A19-C5FB587F61FA_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15 New Years Creek Rd | Pescadero | San Mateo | CA | 94060 | United States | US | |||||||
C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | db785fae4d60624d0a90c7fc24ec36f2b6b95f6d158b42d8973210f3cabba91a | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29.jpeg | IMG_0204.JPG | 2020-01-25T19:22:04+00:00 | 2020-01-25T19:24:14+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/C/C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
CDF1C18C-EAA3-4CEE-BEA5-2F772129E7EC | 9d89e3a7d469140bbf6ce7d5aa86fd38aa0e2c9040182ad6dae708950826bd77 | CDF1C18C-EAA3-4CEE-BEA5-2F772129E7EC.jpeg | IMG_0137.JPG | 2020-01-25T18:47:26+00:00 | 2020-01-25T19:24:49+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/C/CDF1C18C-EAA3-4CEE-BEA5-2F772129E7EC.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
E087C09F-9D37-4E2E-8E42-215F0C773369 | 719b12e1e7cef678ca95d941874adad4e0759d0fcdc4563ac3f40150e0a1813c | E087C09F-9D37-4E2E-8E42-215F0C773369.jpeg | IMG_0141.JPG | 2020-01-25T18:48:02+00:00 | 2020-01-25T19:24:50+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/E/E087C09F-9D37-4E2E-8E42-215F0C773369.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
EA3A8FC2-1DB9-4906-B822-6FF0EABF625F | d3f48a9446d71b64f463675a11cfab4ef085b6896b185b7120daa151b946bb79 | EA3A8FC2-1DB9-4906-B822-6FF0EABF625F.jpeg | IMG_0150.JPG | 2020-01-25T18:52:28+00:00 | 2020-01-25T19:24:53+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/E/EA3A8FC2-1DB9-4906-B822-6FF0EABF625F.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
ECCE503B-E993-4A85-B489-BC54DB8A3B40 | b1cd0517ea1ec79061b0bb36dc4edde23bc047fa51f4f9296094eb62998bb343 | ECCE503B-E993-4A85-B489-BC54DB8A3B40.jpeg | IMG_0170.JPG | 2020-01-25T18:59:11+00:00 | 2020-01-25T19:24:57+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/E/ECCE503B-E993-4A85-B489-BC54DB8A3B40.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
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 | ||||||||
F367069B-2C5A-4C2E-BFCE-29AE79C72E73 | 6f2595c2865301e8535ba3dee97fcb6ac321414e7989762856016992175c511f | F367069B-2C5A-4C2E-BFCE-29AE79C72E73.jpeg | IMG_0165.JPG | 2020-01-25T18:58:11+00:00 | 2020-01-25T19:24:56+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F367069B-2C5A-4C2E-BFCE-29AE79C72E73.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
F92B1415-1D5D-45A6-A736-54D988748BBF | 96bc3134c1bd2553c164f1eee6971a22ed15893dc5dabcc717fc1f72317e044a | F92B1415-1D5D-45A6-A736-54D988748BBF.jpeg | IMG_0224.JPG | 2020-01-25T19:32:06+00:00 | 2020-01-25T19:24:21+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F92B1415-1D5D-45A6-A736-54D988748BBF.jpeg | 0 | 0 | 0 | 1 | 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]);