This data as json, CSV (advanced)
Suggested facets: date_modified, albums, persons, hasadjustments, uti, place_city, place_sub_administrative_area, place_state_province, place_postal_code, place_country, place_iso_country_code, date (date), date_modified (date), 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 062B182C-CD24-4EC8-8E27-420EECB14688 | f35f5580cec4289b90eb9ceebec27f017a5b5911a0b087d7e25efbf86a13b2d0 | 062B182C-CD24-4EC8-8E27-420EECB14688.jpeg | IMG_1114.JPG | 2015-12-18T13:39:58+00:00 | 2020-04-21T02:39:59+00:00 | [] |
[
"Novelty Automation",
"Museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/0/062B182C-CD24-4EC8-8E27-420EECB14688.jpeg | 0 | 0 | 0 | 1 | 0 | 51.51998 | -0.11689166666666666 | 0 | 1 | 0 | public.jpeg | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/0/062B182C-CD24-4EC8-8E27-420EECB14688_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2–10 Princeton Street | Bloomsbury | London | London | England | WC1R 4BH | United Kingdom | GB | ||||||
| 1CCB0CD8-DDD9-40A5-AEBC-015C873A2A09 | 9ab8a8f8d0d8d62ecf5411bdb5ed26b1e5b7fa9df793f0ff21f7080e0163eb64 | 1CCB0CD8-DDD9-40A5-AEBC-015C873A2A09.heic | IMG_6884.HEIC | 2018-09-04T15:40:35+00:00 | 2020-04-20T22:36:08+00:00 | [] |
[
"Museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/1/1CCB0CD8-DDD9-40A5-AEBC-015C873A2A09.heic | 0 | 0 | 0 | 1 | 0 | 50.656758333333336 | -4.251725 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/1/1CCB0CD8-DDD9-40A5-AEBC-015C873A2A09_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Lifton | Devon | England | PL16 | United Kingdom | GB | ||||||||
| 43A4A851-4821-4125-A673-C1E9FCF2F9AC | 487c1ddfc65c37e0d20b4eb88864fd696fa68f5af025a4597115a7870d4a9e53 | 43A4A851-4821-4125-A673-C1E9FCF2F9AC.heic | IMG_4173.HEIC | 2019-06-03T21:20:05+00:00 | 2020-04-20T22:25:29+00:00 | [] |
[
"Museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/4/43A4A851-4821-4125-A673-C1E9FCF2F9AC.heic | 0 | 0 | 0 | 1 | 0 | 38.576375 | -121.49330833333333 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/4/43A4A851-4821-4125-A673-C1E9FCF2F9AC_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1010 L St | Downtown | Sacramento | Sacramento | CA | 95814 | United States | US | ||||||
| 46BAA089-F20D-40E3-8161-5C0FA28FAA90 | 6952898f95114d886494ec5e9df99510a745a0d1ef1fef61d7d924234284f687 | 46BAA089-F20D-40E3-8161-5C0FA28FAA90.heic | IMG_7075.HEIC | 2019-09-11T16:31:25+00:00 | 2020-04-20T22:06:45+00:00 | [] |
[
"Museums",
"Public"
] |
[
"_UNKNOWN_"
] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/4/46BAA089-F20D-40E3-8161-5C0FA28FAA90.heic | 0 | 0 | 0 | 1 | 0 | 29.934663333333333 | -90.06162216666667 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/4/46BAA089-F20D-40E3-8161-5C0FA28FAA90_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1380 Port Of New Orleans Pl | Lower Garden District | New Orleans | Orleans | LA | 70130 | United States | US | ||||||
| 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C | d4d2ad853a4bbb3b4ffd93c582b6567943b3edbc0daf7400754740b61b09a755 | 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C.heic | IMG_4921.HEIC | 2018-05-18T20:39:03+00:00 | 2020-04-20T22:38:31+00:00 | [] |
[
"Museums",
"Public"
] |
[
"_UNKNOWN_"
] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/4/4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C.heic | 0 | 0 | 0 | 1 | 0 | 37.04161116666667 | -122.07271666666666 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/4/4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5497 CA-9 | South Felton | Felton | Santa Cruz | CA | 95018 | United States | US | ||||||
| 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 | a99406f355b55e1d8c5bf18f8d85761ef703d75b862e715f9e9751c5e0a8bacd | 47AC9BA3-C29C-46BA-855E-829C0EC59FF5.heic | IMG_0890.HEIC | 2017-12-03T22:40:16+00:00 | 2020-04-21T02:30:51+00:00 | [] |
[
"Museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/4/47AC9BA3-C29C-46BA-855E-829C0EC59FF5.heic | 0 | 0 | 0 | 1 | 0 | 37.333511666666666 | -121.92306333333333 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/4/47AC9BA3-C29C-46BA-855E-829C0EC59FF5_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1342 Naglee Ave | Shasta Hanchett Park | San Jose | Santa Clara | CA | 95126 | United States | US | ||||||
| 8A9FED20-BDE8-46E0-8583-C8FF1C7D3BFC | bf353867bc1597a9f89dbc4de8af7d755095da20198147e47c69c35f6ebf0b36 | 8A9FED20-BDE8-46E0-8583-C8FF1C7D3BFC.heic | IMG_6873.HEIC | 2018-09-04T14:39:55+00:00 | 2020-04-20T22:36:08+00:00 | [] |
[
"Museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/8/8A9FED20-BDE8-46E0-8583-C8FF1C7D3BFC.heic | 0 | 0 | 0 | 1 | 0 | 50.656525 | -4.251916666666666 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/8/8A9FED20-BDE8-46E0-8583-C8FF1C7D3BFC_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Lifton | Devon | England | PL16 | United Kingdom | GB | ||||||||
| 8B27D87D-8FB6-4251-9E6A-68540AC7532B | 72dcc3993cdcaf43104031d23c42c5824186fbaa07b9bc5065422be1062b210d | 8B27D87D-8FB6-4251-9E6A-68540AC7532B.heic | IMG_2050.HEIC | 2018-12-24T01:08:03+00:00 | 2020-04-20T22:32:09+00:00 | [] |
[
"Museums",
"Public"
] |
[
"_UNKNOWN_",
"_UNKNOWN_"
] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/8/8B27D87D-8FB6-4251-9E6A-68540AC7532B.heic | 0 | 0 | 0 | 1 | 0 | 45.646233333333335 | -122.65947 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/8/8B27D87D-8FB6-4251-9E6A-68540AC7532B_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3409 L St | Columbia Orchard | Vancouver | Clark | WA | 98663 | United States | US | ||||||
| A06B7B8E-4BF6-4906-A1E6-0CA4CF0E28E8 | 1698c710dab87f0f6aeee3f3ef95a0c7f1296abc949dc5d602cdff89c6ec63c5 | A06B7B8E-4BF6-4906-A1E6-0CA4CF0E28E8.heic | IMG_5667.HEIC | 2019-08-07T06:22:37+00:00 | 2020-04-20T22:20:59+00:00 | [] |
[
"Museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A06B7B8E-4BF6-4906-A1E6-0CA4CF0E28E8.heic | 0 | 1 | 0 | 1 | 0 | -18.907088333333334 | 47.518475 | /Users/simon/Pictures/Photos Library.photoslibrary/resources/renders/A/A06B7B8E-4BF6-4906-A1E6-0CA4CF0E28E8_1_201_a.jpeg | 0 | 1 | 0 | public.jpeg | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A06B7B8E-4BF6-4906-A1E6-0CA4CF0E28E8_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Rue de Liège | Antananarivo | Antananarivo | Madagascar | MG | ||||||||
| A421A342-2706-4A6E-B993-38426E52421B | 02e54839ec51f00bd8e4eaed08112c24b77cfedad2a2ea6563e421fcada75a44 | A421A342-2706-4A6E-B993-38426E52421B.heic | IMG_2076.HEIC | 2018-12-24T20:06:03+00:00 | 2020-04-20T22:32:06+00:00 | [] |
[
"Museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A421A342-2706-4A6E-B993-38426E52421B.heic | 0 | 0 | 0 | 1 | 0 | 45.20411333333333 | -123.14530833333333 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A421A342-2706-4A6E-B993-38426E52421B_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 460 NE Captain Michael King Smith Way | McMinnville | Yamhill | OR | 97128 | United States | US | |||||||
| FE1BAAE9-C33D-4933-88F0-9BCDA86F2D5B | d0e381a36f050e4eaeb9530446058ff47fbbd42fe36d4c5bbfcea882000112e9 | FE1BAAE9-C33D-4933-88F0-9BCDA86F2D5B.heic | IMG_4610.HEIC | 2018-05-10T23:39:54+00:00 | 2020-04-20T23:17:29+00:00 | [] |
[
"Museums",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FE1BAAE9-C33D-4933-88F0-9BCDA86F2D5B.heic | 0 | 0 | 0 | 1 | 0 | -32.893811666666664 | -68.856545 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FE1BAAE9-C33D-4933-88F0-9BCDA86F2D5B_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Manuel Antonio Sáez 301–399 | Mendoza City | Mendoza | Mendoza | M5502 | Argentina | AR |
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]);