photos_with_apple_metadata (view)

16 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: latitude, ZOVERALLAESTHETICSCORE, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZFAILURESCORE, ZHARMONIOUSCOLORSCORE, ZIMMERSIVENESSSCORE, ZINTERACTIONSCORE, ZINTERESTINGSUBJECTSCORE, ZINTRUSIVEOBJECTPRESENCESCORE, ZLIVELYCOLORSCORE, ZLOWLIGHT, ZNOISESCORE, ZPLEASANTCAMERATILTSCORE, ZPLEASANTCOMPOSITIONSCORE, ZPLEASANTLIGHTINGSCORE, ZPLEASANTPATTERNSCORE, ZPLEASANTPERSPECTIVESCORE, ZPLEASANTPOSTPROCESSINGSCORE, ZPLEASANTREFLECTIONSSCORE, ZPLEASANTSYMMETRYSCORE, ZSHARPLYFOCUSEDSUBJECTSCORE, ZTASTEFULLYBLURREDSCORE, ZWELLCHOSENSUBJECTSCORE, ZWELLFRAMEDSUBJECTSCORE, ZWELLTIMEDSHOTSCORE, date (date), albums (array)

rowid uuid date albums persons ext sha256 size latitude longitude favorite portrait screenshot slow_mo time_lapse hdr selfie panorama place_city place_state_province place_country ZUUID ZOVERALLAESTHETICSCORE ZCURATIONSCORE ZPROMOTIONSCORE ZHIGHLIGHTVISIBILITYSCORE ZBEHAVIORALSCORE ZFAILURESCORE ZHARMONIOUSCOLORSCORE ZIMMERSIVENESSSCORE ZINTERACTIONSCORE ZINTERESTINGSUBJECTSCORE ZINTRUSIVEOBJECTPRESENCESCORE ZLIVELYCOLORSCORE ZLOWLIGHT ZNOISESCORE ZPLEASANTCAMERATILTSCORE ZPLEASANTCOMPOSITIONSCORE ZPLEASANTLIGHTINGSCORE ZPLEASANTPATTERNSCORE ZPLEASANTPERSPECTIVESCORE ZPLEASANTPOSTPROCESSINGSCORE ZPLEASANTREFLECTIONSSCORE ZPLEASANTSYMMETRYSCORE ZSHARPLYFOCUSEDSUBJECTSCORE ZTASTEFULLYBLURREDSCORE ZWELLCHOSENSUBJECTSCORE ZWELLFRAMEDSUBJECTSCORE ZWELLTIMEDSHOTSCORE
8 0950C9A4-D36C-4E14-9C6A-EA9C354AFBE8 2021-09-11T05:38:55+00:00 ["Frankreich - Balkon"] [] HEIC 52ca9c5887ab32f31190c1e3e3718f7fb78baed7ba1b49b81ce314e13e34aa05 1987539 48.71056333 -3.8048 0 0 0 0 0 0 0 0 Plougasnou Brittany France 0950C9A4-D36C-4E14-9C6A-EA9C354AFBE8 0.5 0.5 0.0 0.03816793893129771 0.0 0.0 0.0 0.0 0.019999999552965164 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
12 1A153107-F311-49FA-A902-8C6DBF0DF58E 2021-09-11T04:50:30+00:00 ["Frankreich - Balkon"] [] HEIC a0f0b0e75021c2853d6e11eefbb14ca73cc8dacda67e3af6dc2f88fd8a2c1b05 1700769 48.71063333 -3.80471333 0 0 0 0 0 0 0 0 Plougasnou Brittany France 1A153107-F311-49FA-A902-8C6DBF0DF58E 0.5 0.5 0.0 0.03816793893129771 0.0 0.0 0.0 0.0 0.03999999910593033 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
9 AFF711C2-A179-41A1-BDD1-DE0E0388E666 2021-09-10T07:19:12+00:00 ["Frankreich - Balkon"] [] HEIC 56203f63888b8cb29581a2b19e160d4ea4558be362b0314b3f11fcb8b3f92248 1825982 48.71062832999999 -3.8046633300000003 0 0 0 0 0 0 0 0 Plougasnou Brittany France AFF711C2-A179-41A1-BDD1-DE0E0388E666 0.58203125 0.5 0.0 0.04202523759303202 0.5053061246871948 -0.000244140625 0.02685546875 0.01904296875 0.019999999552965164 -0.0068359375 -0.01318359375 0.218017578125 0.00146484375 -0.008544921875 -0.022705078125 0.149658203125 0.045166015625 0.53515625 0.072509765625 0.00830078125 0.005859375 0.029296875 0.00927734375 0.0009765625 0.0400390625 0.108642578125 0.00048828125
4 04E97C62-3AC1-41CE-99F0-4AE64BD454F2 2021-09-09T07:37:31+00:00 ["Frankreich - Balkon"] [] HEIC 29ec889c46fe77dfea09b821c9c274228dc35a88d669aaaa662ffd4ed69a4b58 1643007 48.71060332999999 -3.80473833 0 0 0 0 0 0 0 0 Plougasnou Brittany France 04E97C62-3AC1-41CE-99F0-4AE64BD454F2 0.54931640625 0.5 0.0 0.04202523759303202 0.5053061246871948 -0.000244140625 0.024658203125 0.017333984375 0.03999999910593033 -0.04345703125 -0.0224609375 0.2041015625 0.002197265625 -0.007568359375 -0.04296875 0.12060546875 0.00927734375 0.43505859375 0.068359375 0.005126953125 0.001953125 0.025634765625 0.008056640625 0.00048828125 0.033447265625 0.10107421875 0.000732421875
5 A9BD685D-1B39-4DE2-BCA4-BE4DF0156FF5 2021-09-08T07:25:43+00:00 ["Frankreich - Balkon"] [] HEIC 309d16a44d0d1a3b8d1a78db48bb4f28a3fb3f9d26cd2fa112d67bbfddf3e676 1806308 48.710605 -3.804746670000001 0 0 0 0 0 0 0 0 Plougasnou Brittany France A9BD685D-1B39-4DE2-BCA4-BE4DF0156FF5 0.5859375 0.5 0.0 0.04202523759303202 0.5053061246871948 -0.000244140625 0.03564453125 0.014404296875 0.019999999552965164 0.0087890625 -0.036865234375 0.087646484375 0.008056640625 -0.0068359375 -0.038330078125 0.169677734375 0.059326171875 0.494140625 0.142333984375 0.01171875 0.011962890625 0.041259765625 0.0146484375 0.00244140625 0.034912109375 0.15869140625 0.0107421875
1 71A690D6-C06C-4B38-A1D2-7D5AA758326C 2021-09-07T07:14:52+00:00 ["Frankreich - Balkon"] [] HEIC 035f5a6a32ff458941c75774eaa6bd1bbbb83bd3ebee7592380d6ec561ce8a48 1813999 48.710591670000014 -3.80475833 0 0 0 0 0 0 0 0 Plougasnou Brittany France 71A690D6-C06C-4B38-A1D2-7D5AA758326C 0.58984375 0.5 0.0 0.04202212177160132 0.504897952079773 -0.000244140625 0.13134765625 0.0205078125 0.019999999552965164 0.080078125 -0.044189453125 0.167724609375 0.00634765625 -0.00390625 -0.052978515625 0.290283203125 0.19189453125 0.39501953125 0.224365234375 0.01318359375 0.018798828125 0.028564453125 0.013427734375 0.001220703125 0.033935546875 0.06640625 0.028076171875
17 CCB57486-EFC5-4E1D-828E-34FB644EF018 2021-09-06T07:27:46+00:00 ["Frankreich - Balkon"] [] HEIC e4d5a4bc0ce000e1a6486f7207c9f1990ee87ecce721773cf21d960687fe2a85 1844601 48.71060833 -3.80472167 0 0 0 0 0 0 0 0 Plougasnou Brittany France CCB57486-EFC5-4E1D-828E-34FB644EF018 0.56494140625 0.6 0.0 0.04965570955786086 0.504897952079773 -0.000244140625 0.078857421875 0.02587890625 0.05999999865889549 0.107666015625 -0.038330078125 0.21533203125 0.00244140625 -0.0048828125 -0.047119140625 0.24169921875 0.09375 0.40966796875 0.15966796875 0.00830078125 0.019775390625 0.032958984375 0.01123046875 0.001220703125 0.0498046875 0.103759765625 0.017822265625
3 76402922-D795-4DE2-8996-E689D6CCE697 2021-09-05T07:44:14+00:00 ["Frankreich - Balkon"] [] HEIC 283a200314ff50d0c1087db1e915d533160cdf622dd5ce53b8253c2c4c798b4b 1469310 48.71062167000001 -3.804705 0 0 0 0 0 0 0 0 Plougasnou Brittany France 76402922-D795-4DE2-8996-E689D6CCE697 0.68408203125 0.6 0.0 0.0511699641933878 0.7032653093338013 -0.000244140625 0.05712890625 0.030517578125 0.05999999865889549 0.10400390625 -0.01025390625 0.13623046875 0.00341796875 -0.011962890625 -0.000244140625 0.263427734375 0.118896484375 0.5888671875 0.17431640625 0.05810546875 0.018310546875 0.0546875 0.014404296875 0.0048828125 0.067626953125 0.124755859375 0.0068359375
13 A1858523-EC13-446B-BCF4-14F0349C8A6B 2021-09-04T06:32:24+00:00 ["Frankreich - Balkon"] [] HEIC aa98a351acc5f215f5997abf9551790f9dcbb9e26c51677a48a6b34031c84c07 1553764 48.71056333 -3.80476333 0 0 0 0 0 0 0 0 Plougasnou Brittany France A1858523-EC13-446B-BCF4-14F0349C8A6B 0.64453125 0.6 0.0 0.04965259373643016 0.5044897794723511 -0.000244140625 0.064697265625 0.025634765625 0.05999999865889549 0.118408203125 -0.0322265625 0.111572265625 0.0087890625 -0.005615234375 -0.035888671875 0.27099609375 0.1474609375 0.37939453125 0.19091796875 0.026123046875 0.04296875 0.036865234375 0.014404296875 0.00244140625 0.048583984375 0.1240234375 0.015625
7 2EE60689-C03B-4F03-B89C-8B903A6F5894 2021-09-03T06:33:07+00:00 ["Frankreich - Balkon"] [] HEIC 4c4c6eb35eadc33e992d9c9a78ec46d58f65e78ec103944bb14530da0b47aefe 1787890 48.71056333 -3.80477 0 0 0 0 0 0 0 0 Plougasnou Brittany France 2EE60689-C03B-4F03-B89C-8B903A6F5894 0.54833984375 0.5 0.0 0.04202523759303202 0.5053061246871948 -0.000244140625 0.025634765625 0.015869140625 0.05999999865889549 0.021240234375 -0.04833984375 0.0234375 0.005126953125 -0.00537109375 -0.059326171875 0.174072265625 0.00537109375 0.394775390625 0.147216796875 0.005615234375 0.006103515625 0.042236328125 0.010009765625 0.000244140625 0.033203125 0.13525390625 0.016845703125
11 9B431468-7959-4694-93EA-84A88FA7F190 2021-09-02T06:34:03+00:00 ["Frankreich - Balkon"] [] HEIC 6a0e35060a4e105093f1b9b61338638214d94e5df398574d554424a022fdda8b 1836892 48.71068 -3.8049800000000005 0 0 0 0 0 0 0 0 Plougasnou Brittany France 9B431468-7959-4694-93EA-84A88FA7F190 0.54150390625 0.6 0.0 0.04966038329000692 0.5055102109909058 -0.000244140625 0.03173828125 0.01611328125 0.03999999910593033 -0.017333984375 -0.067138671875 0.016357421875 0.004150390625 -0.00439453125 -0.13623046875 0.1435546875 0.052734375 0.370361328125 0.18896484375 0.00341796875 0.001220703125 0.029296875 0.009765625 0.00048828125 0.01318359375 0.094970703125 0.023681640625
10 BB0EE802-BF7C-4C8A-A0B3-0EBFD785D977 2021-09-01T06:22:20+00:00 ["Frankreich - Balkon"] [] HEIC 5abf2345d3ee1e760d1179361861c1c9363b057ad6e41b9ba5cf74f4a410f231 1674060 48.710561670000004 -3.8048083299999993 0 0 0 0 0 0 0 0 Plougasnou Brittany France BB0EE802-BF7C-4C8A-A0B3-0EBFD785D977 0.60009765625 0.5 0.0 0.04203770042375754 0.5069387555122375 -0.000244140625 0.052490234375 0.02880859375 0.07999999821186066 0.039794921875 -0.030517578125 0.05712890625 0.0048828125 -0.004638671875 -0.04736328125 0.31201171875 0.120849609375 0.52880859375 0.23388671875 0.01025390625 0.015869140625 0.05322265625 0.01318359375 0.001953125 0.021728515625 0.107421875 0.018798828125
14 229AAF91-2CAB-417B-B608-76FAA63E54F0 2021-08-31T06:38:32+00:00 ["Frankreich - Balkon"] [] HEIC d497c22ccb2269287180dfd1fa8c451919511512c97c8e7bf89ac1fb6fc5356c 2136742 48.71062832999999 -3.80465 0 0 0 0 0 0 0 0 Plougasnou Brittany France 229AAF91-2CAB-417B-B608-76FAA63E54F0 0.61572265625 0.5 0.0 0.042023748841904504 0.5053061246871948 -0.000244140625 0.0205078125 0.017822265625 0.03999999910593033 0.024169921875 -0.008544921875 0.33154296875 0.00048828125 -0.00732421875 -0.021240234375 0.134521484375 0.0361328125 0.6044921875 0.047607421875 0.007568359375 0.009033203125 0.026611328125 0.00927734375 0.0009765625 0.091552734375 0.17578125 -0.0029296875
15 6C104A13-410A-4877-BB5D-EABAA88D5B38 2021-08-30T06:16:37+00:00 ["Frankreich - Balkon"] [] HEIC dc531f8de5479c57d79106828b71a938dc67211889e1105d17d3f65dd1a2f285 1904284 48.71062832999999 -3.8047166700000004 0 0 0 0 0 0 0 0 Plougasnou Brittany France 6C104A13-410A-4877-BB5D-EABAA88D5B38 0.634765625 0.5 0.0 0.04203127904702689 0.5069387555122375 -0.000244140625 0.037841796875 0.02880859375 0.11999999731779099 0.058349609375 -0.0087890625 0.30859375 0.001220703125 -0.009033203125 -0.00732421875 0.199951171875 0.05517578125 0.52783203125 0.081298828125 0.016357421875 0.0205078125 0.034423828125 0.010986328125 0.001708984375 0.102783203125 0.15380859375 0.00146484375
16 761EB6E0-C3E1-47B3-8FE0-510776E53B68 2021-08-30T06:15:20+00:00 ["Frankreich - Balkon"] [] HEIC e1e188249c560aa281f7c67e3babe6572a01cef2ccfaa2cd741991a3f25ae93e 1645244 48.710586670000005 -3.804755 0 0 0 0 0 0 0 0 Plougasnou Brittany France 761EB6E0-C3E1-47B3-8FE0-510776E53B68 0.62353515625 0.6 0.0 0.04965555758876655 0.5059183835983276 0.0 0.04296875 0.066162109375 0.25999999046325684 0.126953125 -0.018798828125 0.121826171875 0.001220703125 -0.005615234375 -0.0068359375 0.372802734375 0.10205078125 0.455810546875 0.19873046875 0.009765625 0.01318359375 0.0849609375 0.012939453125 0.001708984375 0.033447265625 0.13720703125 0.011474609375
6 5C4176F5-D2A3-42CC-8209-B1B3FD1AFA2A 2021-08-29T07:03:32+00:00 ["Frankreich - Balkon"] [] HEIC 3aa6c9cd3dcc0abd2a26bc0e7c90f67c96cb31df3479b9331438df67ccab1127 2241928 48.71063667 -3.80465333 0 0 0 0 0 0 0 0 Plougasnou Brittany France 5C4176F5-D2A3-42CC-8209-B1B3FD1AFA2A 0.56201171875 0.6 0.0 0.051201017758318486 0.7075510025024414 -0.000244140625 0.0732421875 0.022216796875 0.18000000715255737 0.067626953125 -0.022705078125 0.256103515625 0.001708984375 -0.007080078125 -0.010009765625 0.24560546875 0.112548828125 0.5595703125 0.139892578125 0.009521484375 0.015869140625 0.04736328125 0.01806640625 0.00341796875 0.052490234375 0.1572265625 0.007568359375

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW photos_with_apple_metadata AS 
    select
        apple_photos.rowid,
        apple_photos.uuid,
        apple_photos.date,
        apple_photos.albums,
        apple_photos.persons,
        uploads.ext,
        uploads.sha256,
        uploads.size,
        latitude,
        longitude,
        favorite,
        portrait,
        screenshot,
        slow_mo,
        time_lapse,
        hdr,
        selfie,
        panorama,
        place_city,
        place_state_province,
        place_country,
        apple_photos_scores.*
    from
        apple_photos
    join
        uploads on apple_photos.sha256 = uploads.sha256
    left join
        apple_photos_scores on apple_photos.uuid = apple_photos_scores.ZUUID
    order by
        apple_photos.date desc;