photos_with_apple_metadata (view)

213 rows where ZCURATIONSCORE = "0.5"

✎ View and edit SQL

This data as json, CSV (advanced)

place_state_province ✖

ZCURATIONSCORE ✖

  • 0.5 · 213 ✖
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
395 82B5CEE0-0DCB-4E73-84BC-2536F0676B06 2016-04-19T22:24:36+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg c5da768a066d3ed8487b4cf7520c8960f46510357e13edb68729cd3b0565fcbb 2044936 37.863186666666664 -122.49463666666666 0 0 0 0 0 0 0 0 Sausalito CA United States 82B5CEE0-0DCB-4E73-84BC-2536F0676B06 0.331298828125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0018033981323242188 0.00077056884765625 0.0028667449951171875 0.009999999776482582 -0.32421875 -0.03790283203125 0.44921875 0.0005192756652832031 -0.016845703125 -0.1064453125 -0.2491455078125 -0.05010986328125 0.149169921875 -0.19384765625 0.000110626220703125 -0.04498291015625 0.0019044876098632812 0.0162811279296875 0.00072479248046875 -0.204833984375 -0.1358642578125 -0.047576904296875
110 BF295F44-7050-4EF5-9D2D-597144A55C46 2016-04-17T20:01:45+00:00 
[
    "Public"
]
 
[]
 jpeg 365135c4f3997964b978de088f7a21599630a500aa7881331e6f4f7107ea2cb4 4661564 37.779955 -122.41871666666667 0 0 0 0 0 0 0 0 San Francisco CA United States BF295F44-7050-4EF5-9D2D-597144A55C46 0.49853515625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0006566047668457031 0.0270233154296875 0.004486083984375 0.009999999776482582 -0.2177734375 -0.056549072265625 0.248779296875 0.0025806427001953125 -0.0069580078125 -0.04290771484375 -0.18701171875 0.0396728515625 0.10052490234375 0.05615234375 0.011260986328125 -0.0211639404296875 0.005039215087890625 0.0457763671875 0.0168304443359375 -0.03985595703125 0.1614990234375 -0.00495147705078125
240 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 2016-04-09T20:12:10+00:00 
[
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 jpeg 75d306a807f0c9b8a89eb726ca2ea4e226812e347ad1b70a0d7806ca2c9111c8 2689457 37.78550333333333 -122.43043666666667 0 0 0 0 0 1 0 0 San Francisco CA United States 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 0.486572265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004314422607421875 -0.00701141357421875 0.002452850341796875 0.009999999776482582 -0.121826171875 -0.1026611328125 0.11175537109375 0.005619049072265625 -0.0521240234375 -0.133544921875 -0.4990234375 -0.270263671875 0.165283203125 -0.1573486328125 -0.0026302337646484375 -0.0262451171875 0.0035381317138671875 0.00557708740234375 -0.07470703125 -0.5068359375 -0.1641845703125 -0.1171875
346 9B076964-9931-4790-AE2D-A06011B97CE7 2016-04-09T20:12:10+00:00 
[
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 jpeg a7e181d3b3705db1b852705de9a92e0449fbb1b98b70e366bab316b554dafd6e 2665460 37.78550333333333 -122.43043666666667 0 0 0 0 0 0 0 0 San Francisco CA United States 9B076964-9931-4790-AE2D-A06011B97CE7 0.434326171875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0014209747314453125 0.0190582275390625 0.0013408660888671875 0.009999999776482582 0.150634765625 -0.06256103515625 0.31884765625 0.0022869110107421875 -0.01666259765625 -0.009002685546875 -0.1044921875 -0.00030517578125 0.0293121337890625 -0.04010009765625 0.001861572265625 -0.00848388671875 0.0009546279907226562 0.10015869140625 0.10113525390625 -0.07080078125 0.4228515625 0.02374267578125
288 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 2016-04-09T20:10:29+00:00 
[
    "Public"
]
 
[]
 jpeg 8a3115b8c82c630e48b0ac70eb94d8201721937c4697a667916e1632a5063001 3046776 37.78546166666667 -122.43050333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 0.41064453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.005138397216796875 0.0030517578125 0.0012159347534179688 0.019999999552965164 0.17138671875 -0.06451416015625 0.043548583984375 0.00955963134765625 -0.0836181640625 -0.022918701171875 -0.1002197265625 -0.2410888671875 0.0150146484375 -0.057891845703125 -0.0015716552734375 -0.009979248046875 0.0015850067138671875 0.051177978515625 -0.016876220703125 -0.0430908203125 0.5712890625 0.01898193359375
261 93C7D5C0-E78B-47A0-8953-9A143D65597D 2016-04-09T20:10:28+00:00 
[
    "Public"
]
 
[]
 jpeg 7f16bd84f8301f158a2a512549c0f1594ce92b7bfa05d2787e28a9d890b63419 3094751 37.78546166666667 -122.43050333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 93C7D5C0-E78B-47A0-8953-9A143D65597D 0.50537109375 0.5 0.0 0.038931297721298594 0.7079561948776245 -0.0005235671997070312 0.051239013671875 0.0180511474609375 0.009999999776482582 0.4306640625 -0.02447509765625 0.27685546875 0.0020503997802734375 -0.006587982177734375 -0.0058441162109375 0.11236572265625 0.08697509765625 0.10577392578125 0.07672119140625 0.022308349609375 0.0009765625 0.008575439453125 0.021575927734375 0.00565338134765625 0.06109619140625 0.185546875 0.0660400390625
211 E4D43462-07AB-4803-9DCB-02B8321D8D94 2016-01-13T20:30:46+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 692e3b73c2d9297f354c7b9827d05cd697fd4b83885747a869b2478ec44632c5 2259762 37.78168 -122.411025 0 0 0 0 0 0 0 0 San Francisco CA United States E4D43462-07AB-4803-9DCB-02B8321D8D94 0.22265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0007615089416503906 0.0242156982421875 0.0022258758544921875 0.009999999776482582 -0.11474609375 -0.08343505859375 0.0714111328125 0.0144500732421875 -0.01009368896484375 -0.0028076171875 -0.100341796875 0.0386962890625 0.07476806640625 0.2037353515625 0.00543975830078125 -0.00792694091796875 0.008575439453125 0.1524658203125 0.10986328125 -0.04443359375 0.56005859375 0.039520263671875
219 3C683CF5-1644-412C-AA01-F6A2EAE58319 2015-10-05T15:01:36+00:00 
[
    "Museums",
    "Niche museums",
    "Public"
]
 
[]
 jpeg 6d2e02585f44104e7d40f2e1fc471bafe4fef77c91e130d09eb7fd2db8aba4b6 3487122 35.716544999999996 -83.50289333333333 0 0 0 0 0 0 0 0 Gatlinburg TN United States 3C683CF5-1644-412C-AA01-F6A2EAE58319 0.728515625 0.5 0.0 0.04353355223895939 0.10000000149011612 -0.00263214111328125 0.01399993896484375 0.001934051513671875 0.019999999552965164 0.07373046875 -0.137939453125 0.07965087890625 0.010406494140625 -0.01363372802734375 -0.016876220703125 -0.309814453125 -0.050537109375 0.0301513671875 0.03619384765625 0.0016632080078125 -0.00664520263671875 0.0018892288208007812 0.08282470703125 0.1552734375 -0.134521484375 0.359375 0.1292724609375
220 BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 2015-10-05T14:55:32+00:00 
[
    "Museums",
    "Niche museums",
    "Public"
]
 
[]
 jpeg 6f0558a227b6c1acc2259af4e4d3d6aac4ce7148cda96ad212c4a6fd45ef36a1 2840560     0 0 0 0 0 0 0 0       BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 0.3583984375 0.5 0.0 0.038931297721298594 0.5039172768592834 -0.0008168220520019531 0.03851318359375 0.001949310302734375 0.03999999910593033 0.2958984375 -0.03314208984375 0.058319091796875 0.0271759033203125 -0.007038116455078125 0.0072479248046875 0.328125 0.2447509765625 0.01450347900390625 0.1962890625 0.0167236328125 0.000606536865234375 0.006488800048828125 0.58203125 0.58935546875 0.2381591796875 0.88427734375 0.1051025390625
72 40AA745C-DB5B-47B8-A6A6-C8C941826009 2015-10-05T14:55:12+00:00 
[
    "Museums",
    "Niche museums",
    "Public"
]
 
[]
 jpeg 2071cfe9798e06cfa5873f217d3730d260f1c077dbcd7fec74a0cbe1fee26a99 2739005     0 0 0 0 0 0 0 0       40AA745C-DB5B-47B8-A6A6-C8C941826009 0.4677734375 0.5 0.0 0.03893487945995258 0.10000000149011612 -0.00128936767578125 0.0287322998046875 0.001926422119140625 0.11999999731779099 -0.044677734375 -0.042083740234375 0.066162109375 0.01337432861328125 -0.0041351318359375 0.005237579345703125 0.227294921875 0.2181396484375 0.0167236328125 0.15771484375 0.0079193115234375 -0.00101470947265625 0.00443267822265625 0.61474609375 0.80126953125 0.1617431640625 0.82421875 0.06573486328125
283 369683A6-C32A-4E2D-9492-25BD553B1B6E 2015-10-05T14:54:39+00:00 
[
    "Museums",
    "Niche museums",
    "Public"
]
 
[]
 jpeg 8761c02e415f940008d5feba68d55aad1706623d537a18f6cf51d59d7eee284f 3834055     0 0 0 0 0 0 0 0       369683A6-C32A-4E2D-9492-25BD553B1B6E 0.50244140625 0.5 0.0 0.038931297721298594 0.10065693408250809 -0.0005769729614257812 0.0262603759765625 0.0010280609130859375 0.009999999776482582 0.466064453125 -0.054107666015625 0.1572265625 0.00701141357421875 -0.00582122802734375 0.017608642578125 0.1396484375 0.184814453125 0.01473236083984375 0.09417724609375 0.016204833984375 -0.00644683837890625 0.0023975372314453125 0.59375 0.72412109375 0.156005859375 0.84423828125 0.058746337890625
86 B426930E-FED6-4916-BBB9-73934393B5C8 2015-10-05T14:48:06+00:00 
[
    "Museums",
    "Niche museums",
    "Public"
]
 
[]
 jpeg 2512ce4ad5e082d62744af9268e903dde304867ff95f8782c0da3925835ff1ac 3416230     0 0 0 0 0 0 0 0       B426930E-FED6-4916-BBB9-73934393B5C8 0.3740234375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0023326873779296875 0.0109710693359375 0.0017137527465820312 0.019999999552965164 0.400390625 -0.044525146484375 0.01666259765625 0.030792236328125 -0.0701904296875 -0.0020904541015625 0.03350830078125 -0.1026611328125 0.021820068359375 0.078369140625 0.003688812255859375 -0.0031890869140625 0.004024505615234375 0.08648681640625 0.02398681640625 0.042236328125 0.68115234375 0.265869140625
433 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 2008-10-12T11:08:24+00:00 
[
    "Museums",
    "Saved from Flickr",
    "Public"
]
 
[]
 jpeg d9f59c4c2c01c61648d6f674daf87ead919acf6c9590869ff095163f2458d70f 2842517     0 0 0 0 0 0 0 0       351DAFC9-ABE1-41B8-8613-E1A73CE951B0 0.47998046875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00243377685546875 0.01280975341796875 0.010650634765625 0.009999999776482582 -0.415771484375 -0.11578369140625 -0.0576171875 0.022674560546875 -0.0143890380859375 -0.07208251953125 -0.44140625 -0.229736328125 0.0592041015625 0.10528564453125 0.0046234130859375 -0.0079498291015625 0.00800323486328125 0.006771087646484375 -0.0199127197265625 -0.0235748291015625 -0.1326904296875 0.02508544921875

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