apple_photos

12 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, longitude, live_photo, place_street, place_sub_locality, place_city, place_sub_administrative_area, place_postal_code, place_country, place_iso_country_code, date (date), albums (array)

place_state_province 3 ✖

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
0483D9A5-1462-434F-B3E5-FF569122061A 3e449940062e1c2e740351d912c587618b5d8126cd7cc79061e5e826d0a72ebd   0483D9A5-1462-434F-B3E5-FF569122061A.heic IMG_8780.HEIC   2021-07-20T16:48:16+00:00     [] ["2021 in pictures"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/0/0483D9A5-1462-434F-B3E5-FF569122061A.heic 0 0 0 0 0 52.518769999999996 13.37585833   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/0/0483D9A5-1462-434F-B3E5-FF569122061A_3.mov 1 1 0 0 0 0 0 0 0 0     Platz der Republik 1 Regierungsviertel Berlin Berlin Berlin 11011 Germany DE
48051C79-D67C-4218-B30B-0C1D901EE7B0 3905f6e755225129b71cab739ba52e830a0e4969a5604da0f5423d1f1d55526f   48051C79-D67C-4218-B30B-0C1D901EE7B0.heic IMG_7528.HEIC   2021-02-12T12:06:57+00:00     [] ["2021 in pictures"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/4/48051C79-D67C-4218-B30B-0C1D901EE7B0.heic 0 0 0 0 0 52.49947833 13.455220000000002   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/4/48051C79-D67C-4218-B30B-0C1D901EE7B0_3.mov 1 1 0 0 0 0 0 0 0 0     Stralauer Allee Friedrichshain Berlin Berlin Berlin 10245 Germany DE
582D091A-7EC1-48A5-ABF8-407D1A566861 c6f7309ff11938885c14c4b36e5e11508399e55f050d3c4cf02b820f4c6c897d   582D091A-7EC1-48A5-ABF8-407D1A566861.heic IMG_9789.HEIC   2021-09-10T19:06:48+00:00     [] ["2021 in pictures"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/5/582D091A-7EC1-48A5-ABF8-407D1A566861.heic 0 0 0 0 0 48.711358329999996 -3.8066333299999995   0 1 0 public.heic 0 0   1 1 0 0 0 0 0 0 0 0     22 Promenade de la Méloine   Plougasnou Finistere Brittany 29630 France FR
5AD2CE08-609F-47CB-91F3-15D4051F009F 2a61e08dcea8dd51a5941ab3e7878125841295ce6e01e255a38725dab401ba91   5AD2CE08-609F-47CB-91F3-15D4051F009F.heic IMG_7671.HEIC   2021-03-07T13:50:07+00:00     [] ["2021 in pictures"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/5/5AD2CE08-609F-47CB-91F3-15D4051F009F.heic 0 0 0 0 0 52.49956333 13.461336669999998   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/5/5AD2CE08-609F-47CB-91F3-15D4051F009F_3.mov 1 1 0 0 0 0 0 0 0 0     Bossestraße 6A Friedrichshain Berlin Berlin Berlin 10245 Germany DE
5C4176F5-D2A3-42CC-8209-B1B3FD1AFA2A 3aa6c9cd3dcc0abd2a26bc0e7c90f67c96cb31df3479b9331438df67ccab1127   5C4176F5-D2A3-42CC-8209-B1B3FD1AFA2A.heic IMG_9222.HEIC   2021-08-29T07:03:32+00:00     [] ["Frankreich - Balkon", "2021 in pictures"] [] /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
A22D1A8D-B448-4888-A0B2-1F3E66D9FCD5 8637e3598b48740f6b80f7f12cfc7ee8ced7444fcfe5e306cc0b8ed1da6c5617   A22D1A8D-B448-4888-A0B2-1F3E66D9FCD5.heic IMG_7946.HEIC   2021-04-17T16:37:18+00:00     [] ["2021 in pictures"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/A/A22D1A8D-B448-4888-A0B2-1F3E66D9FCD5.heic 0 0 0 0 0 52.49595333 13.462820000000002   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/A/A22D1A8D-B448-4888-A0B2-1F3E66D9FCD5_3.mov 1 1 0 0 0 0 0 0 0 0         Berlin Berlin Berlin   Germany DE
BD92A771-54FC-493B-B091-51B2E28BD4DF a26836fc703091b2f92301aa2ab1565490e89c0948025a8e743d43b4465ecf88   BD92A771-54FC-493B-B091-51B2E28BD4DF.heic IMG_7330.HEIC   2021-01-18T12:27:11+00:00     [] ["2021 in pictures"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/B/BD92A771-54FC-493B-B091-51B2E28BD4DF.heic 0 0 0 0 0 52.49784167 13.460325000000001   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/B/BD92A771-54FC-493B-B091-51B2E28BD4DF_3.mov 1 1 0 0 0 0 0 0 0 0     Stralauer Allee 12 Friedrichshain Berlin Berlin Berlin 10245 Germany DE
CDF9A542-7D46-4EF0-96AA-25674749C731 83601fb1a1a0b64ad9683c2fd1eebf7e4f6b5ef96ecb2c21e1062812b3ff95b4   CDF9A542-7D46-4EF0-96AA-25674749C731.heic IMG_7567.HEIC   2021-02-16T11:31:03+00:00     [] ["2021 in pictures"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/C/CDF9A542-7D46-4EF0-96AA-25674749C731.heic 0 0 0 0 0 52.498333329999994 13.45882833   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/C/CDF9A542-7D46-4EF0-96AA-25674749C731_3.mov 1 1 0 0 0 0 0 0 0 0     Stralauer Allee 10 Friedrichshain Berlin Berlin Berlin 10245 Germany DE
D17CDA85-5AF6-4C88-AB58-C998896EF05E c7b5bd358966f1e8523b2591460cd3acb4ae2e5b945c402d5d77d870bb449e93   D17CDA85-5AF6-4C88-AB58-C998896EF05E.heic IMG_0424.HEIC   2021-12-28T16:04:07+00:00     [] ["2021 in pictures"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/D/D17CDA85-5AF6-4C88-AB58-C998896EF05E.heic 0 0 0 0 0 51.567611666666664 7.614541666666667   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/D/D17CDA85-5AF6-4C88-AB58-C998896EF05E_3.mov 1 1 0 0 0 0 0 0 0 0     Kottenpfad 20   Kamen Unna North Rhine-Westphalia 59174 Germany DE
D1B958E3-2990-4F12-BE97-5C1C32830D2E 8b4cd18bdaf58d926273787ab6bab546b654224a6689e198f87a688647c7971e   D1B958E3-2990-4F12-BE97-5C1C32830D2E.heic IMG_0441.HEIC   2021-12-30T17:58:41+00:00     [] ["2021 in pictures"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/D/D1B958E3-2990-4F12-BE97-5C1C32830D2E.heic 0 0 0 0 0 52.499478333333336 13.461246666666666   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/D/D1B958E3-2990-4F12-BE97-5C1C32830D2E_3.mov 1 1 0 0 0 0 0 0 0 0     Bossestraße 6A Friedrichshain Berlin Berlin Berlin 10245 Germany DE
E07E1130-5B2F-4170-9B15-0C671658BC1F 34495368bab4f6da4fa225950d3a0c931e717dfbb4532675f49500ca48d2f7bc   E07E1130-5B2F-4170-9B15-0C671658BC1F.heic IMG_9451.HEIC   2021-09-03T18:47:26+00:00     [] ["2021 in pictures"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/E/E07E1130-5B2F-4170-9B15-0C671658BC1F.heic 0 0 0 0 0 48.71195332999999 -3.807203329999999   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/E/E07E1130-5B2F-4170-9B15-0C671658BC1F_3.mov 1 1 0 0 0 0 0 0 0 0     22 Promenade de la Méloine   Plougasnou Finistere Brittany 29630 France FR
F45CFBA3-B3BF-4435-A3C9-8C4EA628E128 7cf9cdc460fe7f62c219bee673a79299b7eafa4cf3559e8b0a9751f5209f00e1   F45CFBA3-B3BF-4435-A3C9-8C4EA628E128.heic IMG_0183.HEIC   2021-11-29T18:41:37+00:00     [] ["2021 in pictures"] [] /Users/jer/Pictures/Photos Library.photoslibrary/originals/F/F45CFBA3-B3BF-4435-A3C9-8C4EA628E128.heic 0 0 0 0 0 52.499471666666665 13.461246666666666   0 1 0 public.heic 0 1 /Users/jer/Pictures/Photos Library.photoslibrary/originals/F/F45CFBA3-B3BF-4435-A3C9-8C4EA628E128_3.mov 1 1 0 0 0 0 0 0 0 0     Bossestraße 6A Friedrichshain Berlin Berlin Berlin 10245 Germany DE

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]);