photos_with_apple_metadata (view)

19 rows where ZHIGHLIGHTVISIBILITYSCORE = "0.05801526718694745" and place_state_province = "CA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, ext, longitude, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, ZINTRUSIVEOBJECTPRESENCESCORE, ZLOWLIGHT, ZPLEASANTPERSPECTIVESCORE, date (date), albums (array)

place_state_province ✖

place_country ✖

ZHIGHLIGHTVISIBILITYSCORE ✖

  • 0.05801526718694745 · 19 ✖
rowid photo 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
322 AEFB3049-40B6-41FD-81AA-571B369B79DB 2020-01-25T19:12:52+00:00 
[
    "Public"
]
 
[]
 heic 9d24f646179a5110b384061d7911acf849957530304e5ac141b86edab4b7b3a0 3931472 37.11494717 -122.32808 1 0 0 0 0 0 0 0 Pescadero CA United States AEFB3049-40B6-41FD-81AA-571B369B79DB 0.57421875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0116424560546875 -0.0101776123046875 0.0015544891357421875 0.009999999776482582 -0.122314453125 -0.060638427734375 0.0396728515625 0.01312255859375 -0.190673828125 -0.05352783203125 -0.320556640625 -0.4072265625 0.078369140625 -0.11199951171875 -0.00426483154296875 -0.020172119140625 0.0020503997802734375 0.005706787109375 -0.09417724609375 -0.496337890625 -0.0115966796875 -0.14990234375
177 22ADB1EE-854B-43F0-96D1-32CB598C0738 2020-01-25T18:37:22+00:00 
[
    "Public"
]
 
[]
 heic 59340b9b577670a6302885117a05ce7103e612748d3de0908dcc7dd3abb232c9 2491863 37.11635832999999 -122.33049667 1 0 0 0 0 0 0 0 Pescadero CA United States 22ADB1EE-854B-43F0-96D1-32CB598C0738 0.51220703125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0011739730834960938 0.01096343994140625 0.0024814605712890625 0.009999999776482582 -0.0811767578125 -0.0809326171875 0.170654296875 0.0035648345947265625 -0.015777587890625 -0.05615234375 -0.2587890625 -0.0595703125 0.10723876953125 -0.0213623046875 0.0020751953125 -0.01378631591796875 0.004100799560546875 0.042236328125 0.01824951171875 -0.154296875 0.2166748046875 -0.0029296875
7 5BD1D973-19F4-48F1-AB13-A214B0B98452 2020-01-25T18:18:00+00:00 
[
    "Public"
]
 
[]
 heic 03bd641c31961be01b3f491a7414ccacb2c57dece64fd6fd8e4be6384643ef8e 2939606 37.11606667000001 -122.330475 1 0 0 0 0 0 0 0 Pescadero CA United States 5BD1D973-19F4-48F1-AB13-A214B0B98452 0.4609375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00885009765625 0.0035858154296875 0.01512908935546875 0.019999999552965164 -0.51416015625 -0.0567626953125 0.0233154296875 0.029815673828125 -0.047515869140625 -0.06463623046875 -0.453369140625 -0.25146484375 0.134033203125 -0.031097412109375 0.00135040283203125 -0.0153350830078125 0.00577545166015625 0.004383087158203125 -0.039459228515625 -0.0838623046875 -0.360107421875 -0.022308349609375
216 8482D147-E926-4B79-9264-533A31F5DF2D 2020-01-25T18:14:27+00:00 
[
    "Public"
]
 
[]
 heic 6b8ef6a1de38c5e897e740c407caa88bbe307b561dac970ccd9b58f870a1f85e 4030633 37.11621117 -122.32977999999999 1 0 0 0 0 0 0 0 Pescadero CA United States 8482D147-E926-4B79-9264-533A31F5DF2D 0.5576171875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.003749847412109375 0.00057220458984375 0.0013990402221679688 0.009999999776482582 -0.48095703125 -0.0635986328125 -0.033203125 0.02685546875 -0.08740234375 -0.08880615234375 -0.287841796875 -0.361572265625 0.049224853515625 -0.068603515625 -0.0012836456298828125 -0.0191650390625 0.005321502685546875 0.0258636474609375 -0.032928466796875 -0.10052490234375 0.369873046875 -0.0089263916015625
252 0BE49C93-2ACC-4628-9C12-99566921EE00 2020-01-25T18:11:18+00:00 
[
    "Public"
]
 
[]
 heic 7ad35f068121f446574a8c950f35017b34cbc4e6dd25c72be8a71b9234bb1e7a 3541580 37.115291670000005 -122.32810333 1 0 0 0 0 0 0 0 Pescadero CA United States 0BE49C93-2ACC-4628-9C12-99566921EE00 0.499267578125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00359344482421875 0.0284423828125 0.0020751953125 0.019999999552965164 0.091552734375 -0.055206298828125 0.0228271484375 0.1646728515625 -0.0496826171875 -0.010345458984375 -0.0771484375 -0.1522216796875 0.047515869140625 0.07708740234375 0.0098876953125 -0.006160736083984375 0.006072998046875 0.0849609375 0.03167724609375 -0.0933837890625 0.5546875 0.07440185546875
190 20B906EB-2A5F-4660-AEF7-6E64D1C9D727 2020-01-25T17:38:42+00:00 
[
    "Public"
]
 
[]
 heic 5f5bcb376b8fea54df152f57917140d8d71ea6528cb2582259967a6614077048 2742993 37.114983329999994 -122.32553833000001 1 0 0 0 0 0 0 0 Pescadero CA United States 20B906EB-2A5F-4660-AEF7-6E64D1C9D727 0.4208984375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0012493133544921875 0.0186309814453125 0.0016107559204101562 0.009999999776482582 0.235107421875 -0.0975341796875 0.1732177734375 0.0165252685546875 -0.0266571044921875 -0.0413818359375 -0.244384765625 -0.07073974609375 0.09234619140625 -0.02294921875 0.00799560546875 -0.012939453125 0.0030879974365234375 0.048309326171875 0.033538818359375 -0.25537109375 0.279541015625 0.024658203125
441 BCAEC510-5871-42B9-9A19-C5FB587F61FA 2020-01-25T16:57:07+00:00 
[
    "Public"
]
 
[]
 heic e02df647bbc0ccc62c05a275c54edeb0529fc7032b182ec91a69556b70a7fa8e 1304263 37.11899167 -122.307175 1 0 0 0 0 0 0 0 Pescadero CA United States BCAEC510-5871-42B9-9A19-C5FB587F61FA 0.46435546875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0182342529296875 0.000316619873046875 0.0025310516357421875 0.009999999776482582 -0.9462890625 -0.08282470703125 -0.208740234375 0.009857177734375 -0.0316162109375 -0.032440185546875 -0.36083984375 -0.591796875 0.01029205322265625 0.003509521484375 -0.006435394287109375 -0.0160064697265625 0.0036067962646484375 0.01024627685546875 -0.20556640625 0.047607421875 0.187744140625 -0.0001983642578125
49 5F1D5E64-6DEB-4F8B-8A93-F57514B2EDDD 2020-01-21T01:14:26+00:00 
[
    "Public"
]
 
[]
 heic 18c0aa96d3614e986218af43cfd9a9cb3ae1806270091d1c8d4ea7f7f0b736d6 2215697 37.38205333 -122.193895 1 0 0 0 0 0 0 0 Portola Valley CA United States 5F1D5E64-6DEB-4F8B-8A93-F57514B2EDDD 0.53076171875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0163421630859375 -0.0016937255859375 0.0035381317138671875 0.009999999776482582 -0.1805419921875 -0.1402587890625 -0.05560302734375 0.0472412109375 -0.06829833984375 -0.10205078125 -0.60107421875 -0.4970703125 0.058349609375 -0.0872802734375 -0.0017242431640625 -0.0164794921875 0.002216339111328125 0.002704620361328125 -0.192626953125 -0.203857421875 -0.286376953125 -0.0118408203125
118 973F76C4-33A5-4ADD-A896-8E9744AB177E 2020-01-14T05:40:24+00:00 
[
    "Public"
]
 
[]
 heic 38ed150fe0aaf4dfded5f144abecab5de247760a6bb2d41526b2dd8de0b11397 1391787 37.45085333 -122.18125833000002 1 0 0 0 0 0 0 0 Menlo Park CA United States 973F76C4-33A5-4ADD-A896-8E9744AB177E 0.43603515625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.001674652099609375 0.00955963134765625 0.0020275115966796875 0.009999999776482582 -0.219970703125 -0.03985595703125 0.158935546875 0.02685546875 -0.037689208984375 -0.018951416015625 -0.11468505859375 -0.1063232421875 0.1466064453125 0.00421142578125 0.000213623046875 -0.04766845703125 0.0087432861328125 0.060302734375 0.0248260498046875 -0.19091796875 0.416748046875 -0.009124755859375
234 4989D148-E809-4B16-850E-E996339D7224 2020-01-14T05:38:46+00:00 
[
    "Public"
]
 
[]
 heic 73491bc0d6fe19177e620c11f66a2e70f417d5ed17210c64804f5362803946f4 1324680 37.450846670000004 -122.18125333 1 0 0 0 0 0 0 0 Menlo Park CA United States 4989D148-E809-4B16-850E-E996339D7224 0.40771484375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.006587982177734375 0.001239776611328125 0.0015249252319335938 0.05999999865889549 -0.5263671875 -0.08660888671875 -0.05682373046875 0.0310211181640625 -0.05224609375 -0.07977294921875 -0.3095703125 -0.477783203125 0.050323486328125 -0.04034423828125 -0.0011138916015625 -0.12060546875 0.00757598876953125 0.0194549560546875 -0.0555419921875 -0.09417724609375 0.325439453125 -0.0064544677734375
318 9ABD9958-31BE-4B9D-9480-7E3342B601FD 2019-10-30T20:34:50+00:00 
[
    "Public"
]
 
[]
 heic 9b4affb8f608930ee6f1b83fc86c66162c372a8e21ef4d2d4010fabaa627bec1 2376821 37.42704667 -122.167795 1 0 0 0 0 0 0 0 Stanford CA United States 9ABD9958-31BE-4B9D-9480-7E3342B601FD 0.377197265625 0.75 0.0 0.05801526718694745 0.7046471834182739 -0.0006589889526367188 0.09112548828125 0.00400543212890625 0.009999999776482582 0.572265625 -0.030670166015625 0.0860595703125 0.023651123046875 -0.006122589111328125 0.015655517578125 0.41943359375 0.34716796875 0.02691650390625 0.36865234375 0.0670166015625 0.014129638671875 0.0083465576171875 0.385986328125 0.37841796875 0.373779296875 0.78515625 0.341796875
36 5C91B5A8-1A4C-4406-B5E6-11883EFC714E 2019-09-16T16:26:37+00:00 
[
    "Public"
]
 
[]
 heic 14101f33adc465139279ae9a80118d2b388f4350c9b1b5ed06596282646d000b 2027028 37.44983333333333 -122.1864 1 0 0 0 0 0 0 0 Menlo Park CA United States 5C91B5A8-1A4C-4406-B5E6-11883EFC714E 0.300048828125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0008935928344726562 0.032806396484375 0.0007948875427246094 0.019999999552965164 -0.158447265625 -0.049957275390625 0.421630859375 0.0026721954345703125 -0.007904052734375 0.01885986328125 -0.05377197265625 0.057647705078125 0.08465576171875 0.02484130859375 0.0040283203125 -0.014495849609375 0.001934051513671875 0.43359375 0.56494140625 0.025390625 0.62744140625 -0.0088653564453125
151 43A4A851-4821-4125-A673-C1E9FCF2F9AC 2019-06-03T21:20:05+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 487c1ddfc65c37e0d20b4eb88864fd696fa68f5af025a4597115a7870d4a9e53 1917644 38.576375 -121.49330833333333 1 0 0 0 0 0 0 0 Sacramento CA United States 43A4A851-4821-4125-A673-C1E9FCF2F9AC 0.39794921875 0.75 0.0 0.05801526718694745 0.9074695706367493 -0.00034737586975097656 0.05255126953125 0.0016679763793945312 0.05999999865889549 0.7802734375 -0.03985595703125 0.09161376953125 0.01009368896484375 -0.002620697021484375 0.0107879638671875 0.4326171875 0.42333984375 0.0135345458984375 0.255615234375 0.0230560302734375 0.0037899017333984375 0.004329681396484375 0.73388671875 0.84716796875 0.241455078125 0.90087890625 0.541015625
491 2489642F-D29D-47EC-918A-63D1E2CEDF98 2018-02-20T23:04:00+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic fdc3052b1eb0fc7ebf3511145fa1744be8a22de793c74f9d89f98ffca730df5b 1690162 37.74257166666666 -122.44921166666667 1 0 0 0 0 0 0 0 San Francisco CA United States 2489642F-D29D-47EC-918A-63D1E2CEDF98 0.529296875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.001129150390625 0.0247955322265625 0.0087432861328125 0.009999999776482582 0.038818359375 -0.07354736328125 -0.028564453125 0.0169830322265625 -0.01085662841796875 -0.02056884765625 0.00927734375 0.0140380859375 0.0294189453125 0.26611328125 0.00890350341796875 -0.00035858154296875 0.00916290283203125 0.02691650390625 -0.004119873046875 0.0243988037109375 0.219970703125 0.1761474609375
175 978E05B3-A903-4F27-A219-92603A4880B5 2018-02-20T22:37:35+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 58aaabde35000d8e8e205450afb85f50f7aa66fcfe7ccd67fa873f6a1f32e60f 1770398 37.742308333333334 -122.44956166666667 1 0 0 0 0 0 0 0 San Francisco CA United States 978E05B3-A903-4F27-A219-92603A4880B5 0.470458984375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0018892288208007812 0.009368896484375 0.0017414093017578125 0.009999999776482582 -0.03662109375 -0.103759765625 0.056243896484375 0.0068511962890625 -0.015899658203125 -0.037567138671875 -0.27294921875 -0.12939453125 0.02947998046875 0.02142333984375 0.001251220703125 -0.0097808837890625 0.002620697021484375 0.03656005859375 -0.001678466796875 -0.088623046875 0.303466796875 0.0738525390625
413 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C 2018-02-20T22:16:37+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic d0d20aaa9ea3d8f1f7a5ceee5548a5545a35a00ba7503f80168dd5f65a903783 1481901 37.74236666666667 -122.44930333333333 1 0 0 0 0 0 0 0 San Francisco CA United States 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C 0.36376953125 0.75 0.0 0.05801526718694745 0.5043308734893799 -0.0011920928955078125 0.028045654296875 0.00394439697265625 0.009999999776482582 0.51904296875 -0.039642333984375 -0.0184326171875 0.0164031982421875 -0.0162811279296875 -0.0003814697265625 0.305419921875 0.0206298828125 0.0170440673828125 0.26611328125 0.00893402099609375 0.001964569091796875 0.00948333740234375 0.09234619140625 0.0183258056640625 0.170654296875 0.6982421875 0.43212890625
17 AE5BD628-AB44-4D2F-A03F-88422F509482 2018-02-20T22:10:36+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 097370f3405ad0e8a22a859ef107130273fd5fe2138128ffd6e7fc18c39fa000 1644874 37.742225 -122.44941666666666 1 0 0 0 0 0 0 0 San Francisco CA United States AE5BD628-AB44-4D2F-A03F-88422F509482 0.461669921875 0.75 0.0 0.05801526718694745 0.504501223564148 -0.0012645721435546875 0.047088623046875 0.005279541015625 0.009999999776482582 0.197021484375 -0.07904052734375 0.021148681640625 0.014007568359375 -0.004451751708984375 0.0032806396484375 0.183837890625 0.1884765625 0.0261077880859375 0.34716796875 0.019775390625 0.0006866455078125 0.006168365478515625 0.1915283203125 0.32861328125 0.09649658203125 0.496826171875 0.1983642578125
16 C1858E6C-13BB-4C1B-A8AB-1A5B2129C19A 2018-02-20T22:10:33+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 087562510b302c2c3e8095b7e5ed455ff4b178e909ec46bde09d50c8500ec26d 1743702 37.74223666666666 -122.44941666666666 1 0 0 0 0 0 0 0 San Francisco CA United States C1858E6C-13BB-4C1B-A8AB-1A5B2129C19A 0.353759765625 0.75 0.0 0.05801526718694745 0.5041119456291199 -0.0015249252319335938 0.0284576416015625 0.005062103271484375 0.009999999776482582 0.384765625 -0.07489013671875 -0.036285400390625 0.025909423828125 -0.00908660888671875 -0.00229644775390625 0.187744140625 0.02294921875 0.0174407958984375 0.23681640625 0.01068115234375 0.001995086669921875 0.00760650634765625 0.08404541015625 0.0736083984375 0.04827880859375 0.458984375 0.26806640625
349 1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB 2017-03-31T00:53:36+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg a93401fea4842b551132a24a707ae8e30d646d4830c5c32c3ce7c1ddcdd61bbc 4502080 37.76918 -122.46453833333334 1 0 0 0 0 0 0 0 San Francisco CA United States 1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB 0.5263671875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.006122589111328125 -0.00547027587890625 0.0029125213623046875 0.009999999776482582 -0.5576171875 -0.057373046875 0.273681640625 0.001956939697265625 -0.0379638671875 -0.159912109375 -0.435791015625 -0.146240234375 0.11676025390625 -0.2406005859375 -0.0036716461181640625 -0.045989990234375 0.0017681121826171875 0.00930023193359375 -0.03497314453125 -0.2568359375 -0.277587890625 -0.07403564453125

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW photos_with_apple_metadata AS 
    select
        apple_photos.rowid,
        json_object(
            'img_src',
            'https://photos.simonwillison.net/i/' || uploads.sha256 || '.' || uploads.ext || '?w=600'
        ) as photo,
        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;
Powered by Datasette · Query took 292.395ms · About: dogsheep/dogsheep-photos