photos_with_apple_metadata (view)

16 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, latitude, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZFAILURESCORE, ZIMMERSIVENESSSCORE, ZINTERACTIONSCORE, ZLOWLIGHT, ZNOISESCORE, ZPLEASANTPOSTPROCESSINGSCORE, ZPLEASANTREFLECTIONSSCORE, ZPLEASANTSYMMETRYSCORE, ZSHARPLYFOCUSEDSUBJECTSCORE, ZTASTEFULLYBLURREDSCORE, ZWELLCHOSENSUBJECTSCORE, 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
58428 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.64111328125 0.6 0.0 0.05119956358698488 0.7071428298950195 -0.000244140625 0.074462890625 0.0322265625 0.05999999865889549 0.080810546875 -0.025634765625 0.08349609375 0.01171875 -0.0048828125 -0.027587890625 0.32568359375 0.136962890625 0.43408203125 0.243408203125 0.017578125 0.0166015625 0.037109375 0.010498046875 0.001953125 0.018310546875 0.043212890625 0.02587890625
56077 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.60791015625 0.5 0.0 0.04201900595017062 0.5051785707473755 -0.00048828125 0.16943359375 0.02392578125 0.03999999910593033 0.37158203125 -0.024658203125 0.081298828125 0.036376953125 -0.007080078125 0.004150390625 0.4130859375 0.214111328125 0.399658203125 0.26416015625 0.017822265625 0.039794921875 0.04541015625 0.02587890625 0.01220703125 0.06298828125 0.178955078125 0.150634765625
63060 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.5058928728103638 -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
56858 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.5057142972946167 -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
52830 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.5057142972946167 -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
60936 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.5055357217788696 -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
56624 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.5055357217788696 -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
54762 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.7032142877578735 -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
54440 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.5048214197158813 -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
63553 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.5057142972946167 -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
51326 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.5062500238418579 -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
59693 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.04357142848822907 0.7078571319580078 -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
65173 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.5057142972946167 -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
64824 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.043570065316353136 0.7076785564422607 -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
51999 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.04966603071635006 0.5062500238418579 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
57447 5C4176F5-D2A3-42CC-8209-B1B3FD1AFA2A 2021-08-29T07:03:32+00:00 ["Frankreich - Balkon", "2021 in pictures"] [] 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.05121183213386827 0.7087500095367432 -0.000244140625 0.0732421875 0.022216796875 0.2199999988079071 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;