photos_with_apple_metadata (view)

8 rows where ZBEHAVIORALSCORE = "0.10000000149011612", ZCURATIONSCORE = "0.5" and place_state_province = "England"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: latitude, longitude, ZHIGHLIGHTVISIBILITYSCORE, ZINTERACTIONSCORE, date (date), albums (array)

place_state_province ✖

  • England · 8 ✖

panorama ✖

  • 0 8

ZCURATIONSCORE ✖

ZBEHAVIORALSCORE ✖

  • 0.10000000149011612 · 8 ✖
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
480 E1468521-C7AB-4BA9-B4A9-D136FC9D4958 2017-12-16T11:52:26+00:00 
[
    "Public"
]
 
[]
 heic f574eaa689ab82870f62f702593725ed4a8e7a9f6c67a1ba31c79d57089f9e62 2274468 51.5034 -0.13202216666666666 0 0 0 0 0 0 0 0 London England United Kingdom E1468521-C7AB-4BA9-B4A9-D136FC9D4958 0.6083984375 0.5 0.0 0.04200813515495708 0.10000000149011612 -0.00974273681640625 0.00029754638671875 0.0013513565063476562 0.019999999552965164 -0.35498046875 -0.07879638671875 0.183349609375 0.004486083984375 -0.08526611328125 -0.072021484375 -0.189697265625 -0.219970703125 0.0309600830078125 -0.11846923828125 -0.09161376953125 -0.03326416015625 0.0009851455688476562 0.0284881591796875 -0.07403564453125 -0.1715087890625 0.30859375 -0.041015625
489 B78C4087-CE43-411C-AEAF-16C585DF6D67 2017-12-16T11:52:17+00:00 
[
    "Public"
]
 
[]
 heic fb7c3040191817d74897ed937836a9993cf3759f84a3bd4662f474c3635ec19a 2091779 51.5034 -0.13202783333333332 0 0 0 0 0 0 0 0 London England United Kingdom B78C4087-CE43-411C-AEAF-16C585DF6D67 0.71337890625 0.5 0.0 0.8068936312471637 0.10000000149011612 -0.005344390869140625 0.017913818359375 0.01094818115234375 0.009999999776482582 -0.55078125 -0.05865478515625 -0.06689453125 0.01129150390625 -0.01666259765625 -0.03057861328125 -0.1268310546875 -0.252197265625 0.020172119140625 0.0902099609375 0.0024738311767578125 -0.00368499755859375 0.00455474853515625 0.0104522705078125 -0.033721923828125 0.0194854736328125 0.00994873046875 0.019500732421875
385 F6F45595-4033-4C79-A9F9-86DCA9088C37 2017-12-16T11:52:13+00:00 
[
    "Public"
]
 
[]
 heic bfe920659a1e209114e738c58fcc9e1df8cdd1eaed6ac7af4721f05865ba8935 2341576 51.50340333333333 -0.13203616666666668 0 0 0 0 0 0 0 0 London England United Kingdom F6F45595-4033-4C79-A9F9-86DCA9088C37 0.6103515625 0.5 0.0 0.8053669137809113 0.10000000149011612 -0.00572967529296875 -0.000789642333984375 0.0010814666748046875 0.019999999552965164 0.0447998046875 -0.095703125 0.048583984375 0.01238250732421875 -0.08880615234375 -0.05389404296875 -0.29736328125 -0.29248046875 0.0289306640625 -0.12152099609375 -0.001251220703125 -0.0276031494140625 0.0015192031860351562 0.022796630859375 -0.032806396484375 -0.325439453125 0.28076171875 -0.0489501953125
403 C75D24F7-AB72-4E8F-BBBB-A07E77CC5B91 2017-12-16T11:51:56+00:00 
[
    "Public"
]
 
[]
 heic c8b559b15a474986fdfb54b369eb86e9c5a65ec65c5fd1f6d37f3065953943d1 1699083 51.503391666666666 -0.13205283333333334 0 0 0 0 0 0 0 0 London England United Kingdom C75D24F7-AB72-4E8F-BBBB-A07E77CC5B91 0.6298828125 0.5 0.0 0.04200813515495708 0.10000000149011612 -0.001995086669921875 0.07391357421875 0.02069091796875 0.009999999776482582 -0.05419921875 -0.0638427734375 0.0679931640625 0.011962890625 -0.009521484375 -0.06158447265625 -0.0850830078125 0.0257568359375 0.0330810546875 0.201416015625 0.018402099609375 0.003326416015625 0.0038547515869140625 0.00971221923828125 -0.006549835205078125 0.006866455078125 -0.07818603515625 0.1031494140625
355 6CE10468-228C-4110-AB0B-663558FCF258 2017-12-16T11:51:32+00:00 
[
    "Public"
]
 
[]
 heic ac2fa4d70ca17a1face556a46a10868917800a96e5c48d0322a7e8a6903b6ae9 2369444 51.50336166666666 -0.13211666666666666 0 0 0 0 0 0 0 0 London England United Kingdom 6CE10468-228C-4110-AB0B-663558FCF258 0.6875 0.5 0.0 0.04202670814426801 0.10000000149011612 -0.0016489028930664062 0.08026123046875 0.0219879150390625 0.009999999776482582 0.25732421875 -0.055938720703125 0.0203857421875 0.01363372802734375 -0.0082550048828125 -0.040130615234375 0.19677734375 0.017578125 0.023193359375 0.279296875 0.022216796875 0.03936767578125 0.00760650634765625 0.01116180419921875 -0.00557708740234375 0.022735595703125 0.031005859375 0.200927734375
135 6274A881-9445-44D6-9E7C-776DAEF1C603 2017-12-16T11:51:31+00:00 
[
    "Public"
]
 
[]
 heic 3eb13ed43499313a2db919adf2b109b55dd49377096ac3edc35444b735a95b69 2120984 51.503355 -0.13211666666666666 0 0 0 0 0 0 0 0 London England United Kingdom 6274A881-9445-44D6-9E7C-776DAEF1C603 0.626953125 0.5 0.0 0.04200794951606343 0.10000000149011612 -0.002208709716796875 0.041107177734375 0.0035648345947265625 0.019999999552965164 0.14013671875 -0.07147216796875 0.12841796875 0.01009368896484375 -0.01061248779296875 -0.02294921875 0.0084228515625 -0.0406494140625 0.03143310546875 0.1263427734375 0.01114654541015625 -0.019287109375 0.005428314208984375 0.060211181640625 0.024200439453125 0.04046630859375 0.45068359375 0.143798828125
415 48EECE84-27A5-4AEC-9B09-6173F8700CEA 2017-12-16T11:51:09+00:00 
[
    "Public"
]
 
[]
 heic d1f5ff1dc55f467cc316d31897840e7ab50a1894823780b56c36e9ee6bda5c08 1806032 51.503303333333335 -0.1321805 0 0 0 0 0 0 0 0 London England United Kingdom 48EECE84-27A5-4AEC-9B09-6173F8700CEA 0.58349609375 0.5 0.0 0.04200794951606343 0.10000000149011612 -0.004520416259765625 0.0024871826171875 0.00269317626953125 0.019999999552965164 -0.498291015625 -0.06878662109375 0.1837158203125 0.006931304931640625 -0.023101806640625 -0.06317138671875 -0.370361328125 -0.158447265625 0.11920166015625 -0.0765380859375 -0.003047943115234375 -0.0631103515625 0.0030155181884765625 0.021575927734375 0.007659912109375 -0.190673828125 -0.0775146484375 -0.033233642578125
30 8876C417-C39E-453A-A865-2A997A6DAAF0 2017-12-16T11:51:05+00:00 
[
    "Public"
]
 
[]
 heic 11b66e49de0d6187d44d38601aefce96dfa29f419444d201b1e03422bd76dc14 1999722 51.503296666666664 -0.13221116666666666 0 0 0 0 0 0 0 0 London England United Kingdom 8876C417-C39E-453A-A865-2A997A6DAAF0 0.65673828125 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.01029205322265625 -0.0067291259765625 0.0014553070068359375 0.009999999776482582 -0.26220703125 -0.10125732421875 0.0670166015625 0.006984710693359375 -0.120361328125 -0.1640625 -0.50146484375 -0.361328125 0.06671142578125 -0.2410888671875 -0.0035266876220703125 -0.053955078125 0.0016489028930664062 0.005344390869140625 -0.1005859375 -0.46533203125 -0.158203125 -0.1329345703125

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 213.296ms · About: dogsheep/dogsheep-photos