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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
F5F65BC1-8BD3-40A2-B283-EBA2E7657A20 | 85c32ecbb8b5b4e75514799212c4bdd8c51469269e931a1fb6aa53f87dc92676 | F5F65BC1-8BD3-40A2-B283-EBA2E7657A20.jpeg | IMG_3479.JPG | 2017-06-16T00:54:59+00:00 | 2020-04-21T05:49:08+00:00 | [] |
[ "Stolen monasteries", "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F5F65BC1-8BD3-40A2-B283-EBA2E7657A20.jpeg | 0 | 0 | 0 | 0 | 0 | 37.76912 | -122.46459166666666 | 0 | 1 | 0 | public.jpeg | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F5F65BC1-8BD3-40A2-B283-EBA2E7657A20_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Nancy Pelosi Dr | San Francisco | San Francisco | CA | 94117 | United States | US | |||||||
F6D98A32-C5E8-4C04-A876-8D316F22B319 | e87890aa6bf96b9fe25aa9790468ab58bac4bc079132344ea1482bfc09426062 | F6D98A32-C5E8-4C04-A876-8D316F22B319.heic | IMG_3164.HEIC | 2018-02-20T22:40:35+00:00 | 2020-04-20T23:19:40+00:00 | [] |
[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F6D98A32-C5E8-4C04-A876-8D316F22B319.heic | 0 | 0 | 0 | 0 | 0 | 37.742641666666664 | -122.44940833333334 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F6D98A32-C5E8-4C04-A876-8D316F22B319_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 250 Evelyn Way | Miraloma Park | San Francisco | San Francisco | CA | 94127 | United States | US | ||||||
F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 00485aa2f328e85a25275dbdbf97af63c36e869f012302206b4c8d1f1e60c26d | F78D8339-34E9-4A9A-9BF8-6A73F52566EE.jpeg | IMG_0212.JPG | 2017-10-21T18:11:34+00:00 | 2020-04-21T02:30:56+00:00 | [] |
[ "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F78D8339-34E9-4A9A-9BF8-6A73F52566EE.jpeg | 0 | 0 | 0 | 0 | 0 | 37.77535 | -122.51298666666666 | 0 | 1 | 0 | public.jpeg | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F78D8339-34E9-4A9A-9BF8-6A73F52566EE_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Outer Richmond | San Francisco | San Francisco | CA | United States | US | ||||||||
F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | c7640974717fa2e3c211179191b9b2b34d3515e5cd487593d411ac399889bcbf | F9F1DAD8-0DEC-4272-A0E5-39517811AF71.heic | IMG_7216.HEIC | 2019-09-14T16:55:41+00:00 | 2020-04-21T23:57:36+00:00 | [] |
[ "Public" ] |
[ "Natalie Downe" ] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F9F1DAD8-0DEC-4272-A0E5-39517811AF71.heic | 0 | 0 | 0 | 1 | 0 | 29.940825 | -90.07910833333334 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/F9F1DAD8-0DEC-4272-A0E5-39517811AF71_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1504 Oretha Castle Haley Blvd | Central City | New Orleans | Orleans | LA | 70113 | United States | US | ||||||
FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 | fd1e5110743f0f83d37a120ca10b81f73f01b3858f7cd569bb16b2686ef329ca | FCC0BF2E-D8AB-4A77-AAF5-427E15978F82.heic | IMG_3085.HEIC | 2018-02-20T22:06:28+00:00 | 2020-04-20T23:19:40+00:00 | [] |
[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FCC0BF2E-D8AB-4A77-AAF5-427E15978F82.heic | 0 | 0 | 0 | 0 | 0 | 37.74218 | -122.449455 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FCC0BF2E-D8AB-4A77-AAF5-427E15978F82_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 250 Evelyn Way | Miraloma Park | San Francisco | San Francisco | CA | 94127 | United States | US | ||||||
FFD294F1-59BE-4B75-9180-B6318671CDEC | f1a8c47ca43ab24da4754290585aa10c74478d419b46faf2b232dbb086250d43 | FFD294F1-59BE-4B75-9180-B6318671CDEC.heic | IMG_3075.HEIC | 2018-02-20T22:04:47+00:00 | 2020-04-20T23:19:40+00:00 | [] |
[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[] |
/Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FFD294F1-59BE-4B75-9180-B6318671CDEC.heic | 0 | 0 | 0 | 0 | 0 | 37.742145 | -122.44979666666667 | 0 | 1 | 0 | public.heic | 0 | 1 | /Users/simon/Pictures/Photos Library.photoslibrary/originals/F/FFD294F1-59BE-4B75-9180-B6318671CDEC_3.mov | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 250 Evelyn Way | Miraloma Park | San Francisco | San Francisco | CA | 94127 | United States | US |
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]);