apple_photos

17 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: latitude, date (date), albums (array)

live_photo 2 ✖

  • 1 16
  • 0 1
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
04E97C62-3AC1-41CE-99F0-4AE64BD454F2 29ec889c46fe77dfea09b821c9c274228dc35a88d669aaaa662ffd4ed69a4b58   04E97C62-3AC1-41CE-99F0-4AE64BD454F2.heic IMG_9733.HEIC   2021-09-09T07:37:31+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/0/04E97C62-3AC1-41CE-99F0-4AE64BD454F2.heic 0 0 0 0 0 48.71060332999999 -3.80473833   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/0/04E97C62-3AC1-41CE-99F0-4AE64BD454F2_3.mov 1 1 0 0 0 0 0 0 0 0     1405 Route de Rhun Izella   Plougasnou Finistere Brittany 29630 France FR
0950C9A4-D36C-4E14-9C6A-EA9C354AFBE8 52ca9c5887ab32f31190c1e3e3718f7fb78baed7ba1b49b81ce314e13e34aa05   0950C9A4-D36C-4E14-9C6A-EA9C354AFBE8.heic IMG_9792.HEIC   2021-09-11T05:38:55+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/0/0950C9A4-D36C-4E14-9C6A-EA9C354AFBE8.heic 0 0 0 0 0 48.71056333 -3.8048   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/0/0950C9A4-D36C-4E14-9C6A-EA9C354AFBE8_3.mov 1 1 0 0 0 0 0 0 0 0     1405 Route de Rhun Izella   Plougasnou Finistere Brittany 29630 France FR
0AB1D9D3-70FA-4472-A968-770BF57389C6 16703eb0fda063858cc728dd9cc06a356ed99e419dede2f120c2075163b6f740   0AB1D9D3-70FA-4472-A968-770BF57389C6.heic IMG_9198.HEIC   2021-08-28T17:01:09+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/0/0AB1D9D3-70FA-4472-A968-770BF57389C6.heic 0 0 0 0 0 48.710605 -3.8047199999999997   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/0/0AB1D9D3-70FA-4472-A968-770BF57389C6_3.mov 1 1 0 0 0 0 0 0 0 0     1405 Route de Rhun Izella   Plougasnou Finistere Brittany 29630 France FR
1A153107-F311-49FA-A902-8C6DBF0DF58E a0f0b0e75021c2853d6e11eefbb14ca73cc8dacda67e3af6dc2f88fd8a2c1b05   1A153107-F311-49FA-A902-8C6DBF0DF58E.heic IMG_9790.HEIC   2021-09-11T04:50:30+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/1/1A153107-F311-49FA-A902-8C6DBF0DF58E.heic 0 0 0 0 0 48.71063333 -3.80471333   0 1 0 public.heic 0 0   1 1 0 0 0 0 0 0 0 0     1405 Route de Rhun Izella   Plougasnou Finistere Brittany 29630 France FR
229AAF91-2CAB-417B-B608-76FAA63E54F0 d497c22ccb2269287180dfd1fa8c451919511512c97c8e7bf89ac1fb6fc5356c   229AAF91-2CAB-417B-B608-76FAA63E54F0.heic IMG_9298.HEIC   2021-08-31T06:38:32+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/2/229AAF91-2CAB-417B-B608-76FAA63E54F0.heic 0 0 0 0 0 48.71062832999999 -3.80465   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/2/229AAF91-2CAB-417B-B608-76FAA63E54F0_3.mov 1 1 0 0 0 0 0 0 0 0     1405 Route de Rhun Izella   Plougasnou Finistere Brittany 29630 France FR
2EE60689-C03B-4F03-B89C-8B903A6F5894 4c4c6eb35eadc33e992d9c9a78ec46d58f65e78ec103944bb14530da0b47aefe   2EE60689-C03B-4F03-B89C-8B903A6F5894.heic IMG_9437.HEIC   2021-09-03T06:33:07+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/2/2EE60689-C03B-4F03-B89C-8B903A6F5894.heic 0 0 0 0 0 48.71056333 -3.80477   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/2/2EE60689-C03B-4F03-B89C-8B903A6F5894_3.mov 1 1 0 0 0 0 0 0 0 0     1405 Route de Rhun Izella   Plougasnou Finistere Brittany 29630 France FR
5C4176F5-D2A3-42CC-8209-B1B3FD1AFA2A 3aa6c9cd3dcc0abd2a26bc0e7c90f67c96cb31df3479b9331438df67ccab1127   5C4176F5-D2A3-42CC-8209-B1B3FD1AFA2A.heic IMG_9222.HEIC   2021-08-29T07:03:32+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/5/5C4176F5-D2A3-42CC-8209-B1B3FD1AFA2A.heic 0 0 0 0 0 48.71063667 -3.80465333   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/5/5C4176F5-D2A3-42CC-8209-B1B3FD1AFA2A_3.mov 1 1 0 0 0 0 0 0 0 0     1405 Route de Rhun Izella   Plougasnou Finistere Brittany 29630 France FR
6C104A13-410A-4877-BB5D-EABAA88D5B38 dc531f8de5479c57d79106828b71a938dc67211889e1105d17d3f65dd1a2f285   6C104A13-410A-4877-BB5D-EABAA88D5B38.heic IMG_9282.HEIC   2021-08-30T06:16:37+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/6/6C104A13-410A-4877-BB5D-EABAA88D5B38.heic 0 0 0 0 0 48.71062832999999 -3.8047166700000004   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/6/6C104A13-410A-4877-BB5D-EABAA88D5B38_3.mov 1 1 0 0 0 0 0 0 0 0     1405 Route de Rhun Izella   Plougasnou Finistere Brittany 29630 France FR
71A690D6-C06C-4B38-A1D2-7D5AA758326C 035f5a6a32ff458941c75774eaa6bd1bbbb83bd3ebee7592380d6ec561ce8a48   71A690D6-C06C-4B38-A1D2-7D5AA758326C.heic IMG_9637.HEIC   2021-09-07T07:14:52+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/7/71A690D6-C06C-4B38-A1D2-7D5AA758326C.heic 0 0 0 0 0 48.710591670000014 -3.80475833   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/7/71A690D6-C06C-4B38-A1D2-7D5AA758326C_3.mov 1 1 0 0 0 0 0 0 0 0         Plougasnou Finistere Brittany   France FR
761EB6E0-C3E1-47B3-8FE0-510776E53B68 e1e188249c560aa281f7c67e3babe6572a01cef2ccfaa2cd741991a3f25ae93e   761EB6E0-C3E1-47B3-8FE0-510776E53B68.heic IMG_9281.HEIC   2021-08-30T06:15:20+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/7/761EB6E0-C3E1-47B3-8FE0-510776E53B68.heic 0 0 0 0 0 48.710586670000005 -3.804755   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/7/761EB6E0-C3E1-47B3-8FE0-510776E53B68_3.mov 1 1 0 0 0 0 0 0 0 0     1405 Route de Rhun Izella   Plougasnou Finistere Brittany 29630 France FR
76402922-D795-4DE2-8996-E689D6CCE697 283a200314ff50d0c1087db1e915d533160cdf622dd5ce53b8253c2c4c798b4b   76402922-D795-4DE2-8996-E689D6CCE697.heic IMG_9511.HEIC   2021-09-05T07:44:14+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/7/76402922-D795-4DE2-8996-E689D6CCE697.heic 0 0 0 0 0 48.71062167000001 -3.804705   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/7/76402922-D795-4DE2-8996-E689D6CCE697_3.mov 1 1 0 0 0 0 0 0 0 0     1405 Route de Rhun Izella   Plougasnou Finistere Brittany 29630 France FR
9B431468-7959-4694-93EA-84A88FA7F190 6a0e35060a4e105093f1b9b61338638214d94e5df398574d554424a022fdda8b   9B431468-7959-4694-93EA-84A88FA7F190.heic IMG_9353.HEIC   2021-09-02T06:34:03+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/9/9B431468-7959-4694-93EA-84A88FA7F190.heic 0 0 0 0 0 48.71068 -3.8049800000000005   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/9/9B431468-7959-4694-93EA-84A88FA7F190_3.mov 1 1 0 0 0 0 0 0 0 0         Plougasnou Finistere Brittany   France FR
A1858523-EC13-446B-BCF4-14F0349C8A6B aa98a351acc5f215f5997abf9551790f9dcbb9e26c51677a48a6b34031c84c07   A1858523-EC13-446B-BCF4-14F0349C8A6B.heic IMG_9459.HEIC   2021-09-04T06:32:24+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/A/A1858523-EC13-446B-BCF4-14F0349C8A6B.heic 0 0 0 0 0 48.71056333 -3.80476333   0 1 0 public.heic 0 1   1 1 0 0 0 0 0 0 0 0     1405 Route de Rhun Izella   Plougasnou Finistere Brittany 29630 France FR
A9BD685D-1B39-4DE2-BCA4-BE4DF0156FF5 309d16a44d0d1a3b8d1a78db48bb4f28a3fb3f9d26cd2fa112d67bbfddf3e676   A9BD685D-1B39-4DE2-BCA4-BE4DF0156FF5.heic IMG_9674.HEIC   2021-09-08T07:25:43+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/A/A9BD685D-1B39-4DE2-BCA4-BE4DF0156FF5.heic 0 0 0 0 0 48.710605 -3.804746670000001   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/A/A9BD685D-1B39-4DE2-BCA4-BE4DF0156FF5_3.mov 1 1 0 0 0 0 0 0 0 0     1405 Route de Rhun Izella   Plougasnou Finistere Brittany 29630 France FR
AFF711C2-A179-41A1-BDD1-DE0E0388E666 56203f63888b8cb29581a2b19e160d4ea4558be362b0314b3f11fcb8b3f92248   AFF711C2-A179-41A1-BDD1-DE0E0388E666.heic IMG_9755.HEIC   2021-09-10T07:19:12+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/A/AFF711C2-A179-41A1-BDD1-DE0E0388E666.heic 0 0 0 0 0 48.71062832999999 -3.8046633300000003   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/A/AFF711C2-A179-41A1-BDD1-DE0E0388E666_3.mov 1 1 0 0 0 0 0 0 0 0     1405 Route de Rhun Izella   Plougasnou Finistere Brittany 29630 France FR
BB0EE802-BF7C-4C8A-A0B3-0EBFD785D977 5abf2345d3ee1e760d1179361861c1c9363b057ad6e41b9ba5cf74f4a410f231   BB0EE802-BF7C-4C8A-A0B3-0EBFD785D977.heic IMG_9339.HEIC   2021-09-01T06:22:20+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/B/BB0EE802-BF7C-4C8A-A0B3-0EBFD785D977.heic 0 0 0 0 0 48.710561670000004 -3.8048083299999993   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/B/BB0EE802-BF7C-4C8A-A0B3-0EBFD785D977_3.mov 1 1 0 0 0 0 0 0 0 0     1405 Route de Rhun Izella   Plougasnou Finistere Brittany 29630 France FR
CCB57486-EFC5-4E1D-828E-34FB644EF018 e4d5a4bc0ce000e1a6486f7207c9f1990ee87ecce721773cf21d960687fe2a85   CCB57486-EFC5-4E1D-828E-34FB644EF018.heic IMG_9562.HEIC   2021-09-06T07:27:46+00:00     [] ["Frankreich - Balkon"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/C/CCB57486-EFC5-4E1D-828E-34FB644EF018.heic 0 0 0 0 0 48.71060833 -3.80472167   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/C/CCB57486-EFC5-4E1D-828E-34FB644EF018_3.mov 1 1 0 0 0 0 0 0 0 0         Plougasnou Finistere Brittany   France FR

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [apple_photos] (
   [sha256] TEXT,
   [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]);