This data as json, CSV (advanced)
Suggested facets: date, albums, date (date), albums (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 071DED2E-2D2A-4519-A47A-FC37916025F1 | b46e8e49eed203530d061274284253c2c95b1d7c6ea3a9aa7cac6d85f1afa813 | 071DED2E-2D2A-4519-A47A-FC37916025F1.jpeg | IMG_9712.JPG | 2019-08-21T16:03:37+00:00 | 2019-09-22T05:11:11+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/0/071DED2E-2D2A-4519-A47A-FC37916025F1.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 14CFCD9C-EBFE-4C4A-ABF8-299A57F5206D | 10fbcfa8d9bde9eea951ffd25147dfcca838591911ffa1c2b4b5ada2cc73bf7c | 14CFCD9C-EBFE-4C4A-ABF8-299A57F5206D.jpeg | IMG_9593.JPG | 2019-08-21T15:33:02+00:00 | 2019-09-22T05:13:58+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/1/14CFCD9C-EBFE-4C4A-ABF8-299A57F5206D.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 18939B2A-0A75-461C-B1D0-7ABD87282C2D | 77bff818519fbcb9928b5259e5865f7f16a90fca872e7372a6bb06be7ac89fd9 | 18939B2A-0A75-461C-B1D0-7ABD87282C2D.jpeg | IMG_7332.JPG | 2019-08-02T07:06:42+00:00 | 2019-09-22T06:05:08+00:00 | [] |
[
"To Instagram",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/1/18939B2A-0A75-461C-B1D0-7ABD87282C2D.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 23F1ACC2-DF35-42BD-9332-A3C51B9AA8C6 | dcf001e183e3e0ed9142c734eb751eb0992e7b14651845c9c3df40a491322b6d | 23F1ACC2-DF35-42BD-9332-A3C51B9AA8C6.jpeg | IMG_9723.JPG | 2019-08-21T16:05:25+00:00 | 2019-09-22T05:10:44+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/2/23F1ACC2-DF35-42BD-9332-A3C51B9AA8C6.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 2A621F4B-A826-437E-91A4-6A0597D08134 | 7f2931e3486143bc295f99a386810b08659dbdb8d5650e8ba4d729607902f383 | 2A621F4B-A826-437E-91A4-6A0597D08134.jpeg | IMG_9727.JPG | 2019-08-21T16:05:33+00:00 | 2019-09-22T05:10:45+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/2/2A621F4B-A826-437E-91A4-6A0597D08134.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 31E610B0-66E8-4C5E-9B9C-CE0EAAFDC3D8 | 1144f98ed47578c71f87da25e6e3876a734109666c4086e1de53ddfd03e620d6 | 31E610B0-66E8-4C5E-9B9C-CE0EAAFDC3D8.jpeg | IMG_9568.JPG | 2019-08-21T15:29:14+00:00 | 2019-09-22T05:15:11+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/3/31E610B0-66E8-4C5E-9B9C-CE0EAAFDC3D8.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 379BF280-6D24-43EF-9DB2-0E497D08DD34 | fa119150fd7f15dee753c4f9c609e7c0b84d349786b1ee52db4ba4b9b5508564 | 379BF280-6D24-43EF-9DB2-0E497D08DD34.jpeg | IMG_9739.JPG | 2019-08-21T16:08:21+00:00 | 2019-09-22T05:09:51+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/3/379BF280-6D24-43EF-9DB2-0E497D08DD34.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 3C46B23E-EDE6-4CE9-97F6-FED24AF41F91 | be83d91388b3a7f6df3475a9d0557e957e9aa49a7fc2690dd8942b52971b4af5 | 3C46B23E-EDE6-4CE9-97F6-FED24AF41F91.jpeg | IMG_9735.JPG | 2019-08-21T16:06:06+00:00 | 2019-09-22T05:10:14+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/3/3C46B23E-EDE6-4CE9-97F6-FED24AF41F91.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 411AAEA4-5064-4007-B18E-72D0E1111E59 | d95f7783f031052c8c2794c3054f46b6cfb042d58cec843cff63479ccbab4cc5 | 411AAEA4-5064-4007-B18E-72D0E1111E59.jpeg | IMG_9740.JPG | 2019-08-21T16:08:21+00:00 | 2019-09-22T05:09:29+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/4/411AAEA4-5064-4007-B18E-72D0E1111E59.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 4353C1BC-259D-4814-B113-8E5DBA65470D | 97c5b33f1ede95e3610b213858a47deb2d9b6e84edbc484348eb318234b1725e | 4353C1BC-259D-4814-B113-8E5DBA65470D.jpeg | IMG_7351.JPG | 2019-08-02T07:31:01+00:00 | 2019-09-22T06:04:37+00:00 | [] |
[
"To Instagram",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/4/4353C1BC-259D-4814-B113-8E5DBA65470D.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 538AC784-D7C1-4C11-8957-CFBAE86052DF | 05fdce0c4c029df59c64ec887dbb4bdd60cdf9189e136f6c9b869d3b5d390d27 | 538AC784-D7C1-4C11-8957-CFBAE86052DF.jpeg | IMG_9633.JPG | 2019-08-21T15:55:33+00:00 | 2019-09-22T05:13:29+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/5/538AC784-D7C1-4C11-8957-CFBAE86052DF.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 54F1F5C1-A8AF-4731-81C6-0F0ED204D8EE | 68070b02b60b38af0180db8311ecd10bf80a84ce18379978bf22029e6931f10d | 54F1F5C1-A8AF-4731-81C6-0F0ED204D8EE.jpeg | IMG_9733.JPG | 2019-08-21T16:06:05+00:00 | 2019-09-22T05:10:18+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/5/54F1F5C1-A8AF-4731-81C6-0F0ED204D8EE.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 563D4862-8FC2-4BD9-BAD0-E9B2DC5DB473 | 8fa3f67420480063a09ea4134c1dae4e8d67262f38433e3a41a2f6eb6aa47bf8 | 563D4862-8FC2-4BD9-BAD0-E9B2DC5DB473.jpeg | IMG_7357.JPG | 2019-08-02T07:32:43+00:00 | 2019-09-22T06:03:54+00:00 | [] |
[
"To Instagram",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/5/563D4862-8FC2-4BD9-BAD0-E9B2DC5DB473.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 7CB33AD0-0953-4440-93D1-E1E67A227D7B | 1821e43e6f6a45b1a9701f777256dec1f11af076631cdfed6a5d312726500ca9 | 7CB33AD0-0953-4440-93D1-E1E67A227D7B.jpeg | IMG_9582.JPG | 2019-08-21T15:32:05+00:00 | 2019-09-22T05:14:59+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/7/7CB33AD0-0953-4440-93D1-E1E67A227D7B.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| 8D169BB8-BF13-4FE9-8196-10DA495ABA01 | 1d8f6e62965eb678ed412a9eb03bf1bcfd25803814540e560b2f0b675b99f3f2 | 8D169BB8-BF13-4FE9-8196-10DA495ABA01.jpeg | IMG_9725.JPG | 2019-08-21T16:05:31+00:00 | 2019-09-22T05:10:56+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/8/8D169BB8-BF13-4FE9-8196-10DA495ABA01.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| A5CCE865-901A-4FF0-A0DA-5DECE6E7C3A3 | a284e8b493923f1e58d3f442ec2d9e436c7ccdda77208fa93b2442dab8307190 | A5CCE865-901A-4FF0-A0DA-5DECE6E7C3A3.jpeg | IMG_9721.JPG | 2019-08-21T16:05:23+00:00 | 2019-09-22T05:12:08+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/A/A5CCE865-901A-4FF0-A0DA-5DECE6E7C3A3.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| B2F26E79-7A85-497E-AD2F-D599633EA720 | 3bd461b7f1c5b8c4de844951f86168d510082ae55c2a23223b7cc5ada0ce29f5 | B2F26E79-7A85-497E-AD2F-D599633EA720.jpeg | IMG_9546.JPG | 2019-08-21T11:43:53+00:00 | 2019-09-22T05:15:58+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/B/B2F26E79-7A85-497E-AD2F-D599633EA720.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| B9265412-3353-4812-8BBA-E6FF72DC5718 | c2d88a3854c6bb06ebdedec26082e81bb4b47eaf629ae3c72a9a94550e715336 | B9265412-3353-4812-8BBA-E6FF72DC5718.jpeg | IMG_9728.JPG | 2019-08-21T16:05:33+00:00 | 2019-09-22T05:10:21+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/B/B9265412-3353-4812-8BBA-E6FF72DC5718.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| CBDD4423-FA49-434C-907E-A6B49EF038B3 | a7c3213d75b417835c81d3e7066598422f53691e933868f10c6ede9cb4a5f1b1 | CBDD4423-FA49-434C-907E-A6B49EF038B3.jpeg | IMG_8269.JPG | 2019-08-11T10:19:41+00:00 | 2019-09-22T05:47:46+00:00 | [] |
[
"To Instagram",
"Anja Community Reserve",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/C/CBDD4423-FA49-434C-907E-A6B49EF038B3.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F | bd939e829e1f2bc97273efcf9fae6e0a8ac27aca2d43c3f470b8b5c78142674d | E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F.jpeg | IMG_9565.JPG | 2019-08-21T15:27:59+00:00 | 2019-09-22T05:16:11+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/E/E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| EB0F670F-3DE5-4917-840A-1C84BE9C570D | 80c39df47ef66d49231ae15a6a0dcd036881b7310ebc344e9b8677da479ee070 | EB0F670F-3DE5-4917-840A-1C84BE9C570D.jpeg | IMG_7094.JPG | 2019-07-30T12:22:03+00:00 | 2019-09-22T22:50:01+00:00 | [] |
[
"To Instagram",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/E/EB0F670F-3DE5-4917-840A-1C84BE9C570D.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 | b3b8e4d655d448f18fc3d956a3c3b4e20f271fd3b322677398c463aaab074513 | FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8.jpeg | IMG_9742.JPG | 2019-08-21T16:08:36+00:00 | 2019-09-22T05:09:23+00:00 | [] |
[
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8.jpeg | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | public.jpeg | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
| FCBB3E33-8FF9-4811-B242-729555B01F28 | b59011c12dd96d5570d71fead8b84f1efa589beca989bdbad3f7ad36f6522c3a | FCBB3E33-8FF9-4811-B242-729555B01F28.jpeg | IMG_8495.JPG | 2019-08-12T08:14:34+00:00 | 2019-09-22T05:39:22+00:00 | [] |
[
"To Instagram",
"Public"
] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FCBB3E33-8FF9-4811-B242-729555B01F28.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]);