photos_with_apple_metadata (view)

19 rows

1 extra where clause

View and edit SQL

Suggested facets: date, persons, ext, latitude, longitude, hdr, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, date (date), albums (array), persons (array)

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
431 50572BE9-4D25-4D5E-8C39-9C413FEAB7FE 2020-04-21T21:51:03+00:00
[
    "Public"
]
[]
jpeg d9668136b02a64f8fd334852d774fa2532cc81b501276c9e1e12014c62be438f 6031319     0 0 0 0 0 0 0 0       50572BE9-4D25-4D5E-8C39-9C413FEAB7FE 0.70654296875 0.5 0.0 0.0450937015409688 0.10000000149011612 -0.043609619140625 0.00765228271484375 0.01337432861328125 0.009999999776482582 -0.491455078125 -0.05419921875 -0.0845947265625 0.1483154296875 -0.131103515625 -0.046844482421875 -0.35986328125 -0.45068359375 0.036163330078125 -0.025604248046875 0.0085906982421875 -0.00960540771484375 0.0027904510498046875 0.00395965576171875 -0.1129150390625 -0.0090179443359375 -0.234619140625 -0.007171630859375
376 C73AB37A-CB52-43B4-900C-C734303BFE72 2020-04-21T21:49:39+00:00
[
    "Public"
]
[]
jpeg b92f52fed50d8ead93f58838aeead00a673bcf8eb4800f471f94a3bc29cd2aab 4846535     0 0 0 0 0 0 0 0       C73AB37A-CB52-43B4-900C-C734303BFE72 0.74560546875 0.5 0.0 0.0450929585303969 0.10000000149011612 -0.0006985664367675781 0.060638427734375 0.004116058349609375 0.009999999776482582 -0.1702880859375 -0.050994873046875 0.1138916015625 0.0177764892578125 -0.00399017333984375 0.0175323486328125 0.114501953125 0.3115234375 0.1087646484375 0.3212890625 0.043914794921875 -0.00229644775390625 0.0087432861328125 0.408447265625 0.63037109375 0.126220703125 0.54833984375 0.02215576171875
371 90D9702F-4A1D-4862-B287-00EB15F3D276 2020-04-21T21:49:34+00:00
[
    "Public"
]
[]
jpeg b5a8e8bf1603e5a14584ff2bb629dc00f9c4660e27c9d99f433d1b46b58ef8a8 5811122     0 0 0 0 0 0 0 0       90D9702F-4A1D-4862-B287-00EB15F3D276 0.7431640625 0.5 0.0 0.0450937015409688 0.10000000149011612 -0.0009813308715820312 0.00185394287109375 0.0013885498046875 0.009999999776482582 -0.174072265625 -0.10931396484375 0.306396484375 0.0025119781494140625 -0.0104522705078125 -0.02569580078125 -0.451171875 -0.027099609375 0.056243896484375 -0.076416015625 -0.007293701171875 -0.0233612060546875 0.0016164779663085938 0.05975341796875 0.048095703125 -0.59765625 0.163330078125 -0.053741455078125
119 2BE0CB22-929B-463E-B20C-83A518787BB4 2019-05-25T23:27:50+00:00
[
    "Public"
]
[]
heic 3965927422e592de931edff7d6a2596c1b209c579b895e36d4e2bbbf1cd7da0d 1933650 37.77649666666667 -122.424995 0 0 0 0 0 0 0 0 San Francisco CA United States 2BE0CB22-929B-463E-B20C-83A518787BB4 0.5703125 0.5 0.0 0.038931297721298594 0.5037956237792969 -0.0010728836059570312 0.0623779296875 0.0048675537109375 0.009999999776482582 0.101318359375 -0.05889892578125 0.447021484375 0.004230499267578125 -0.00600433349609375 -0.00653076171875 -0.138427734375 0.0870361328125 0.177978515625 0.028076171875 0.0181884765625 -0.004589080810546875 0.0025310516357421875 0.07171630859375 0.1861572265625 -0.12115478515625 0.0556640625 -0.00311279296875
23 39333D7D-3020-4A1B-970D-44F2DD6D5C52 2019-05-19T23:50:19+00:00
[
    "Public"
]
[]
jpeg 0d2584a5003fb23424777e259d0c437f3bfc567318f8e4cd4298570bf8da6947 5078550     0 0 0 0 0 0 0 0       39333D7D-3020-4A1B-970D-44F2DD6D5C52 0.68408203125 0.5 0.0 0.04356772708528824 0.10000000149011612 -0.0016813278198242188 0.00276947021484375 0.00453948974609375 0.05999999865889549 -0.255859375 -0.09027099609375 0.2310791015625 0.004180908203125 -0.014007568359375 -0.055145263671875 -0.4873046875 -0.0653076171875 0.17822265625 -0.05279541015625 -0.005138397216796875 -0.0148162841796875 0.0026836395263671875 0.01267242431640625 0.0071868896484375 -0.35205078125 -0.310546875 -0.05792236328125
18 6D5FD270-8DB3-46AE-8B1E-99C575B2885C 2019-03-31T18:54:34+00:00
[
    "Public"
]
[]
jpeg 0a4cf96c0126d57760a1dbebe3d63d7afbbbc1f896fb3db11ae73c722225bb43 5222631     0 0 0 0 0 0 0 0       6D5FD270-8DB3-46AE-8B1E-99C575B2885C 0.61376953125 0.5 0.0 0.042032280041061285 0.9082725048065186 -0.000293731689453125 0.09539794921875 0.0034027099609375 0.05999999865889549 0.68017578125 -0.037384033203125 0.1748046875 0.0125732421875 -0.00397491455078125 0.03961181640625 0.33203125 0.4140625 0.1251220703125 0.374267578125 0.06988525390625 0.0091552734375 0.01073455810546875 0.47314453125 0.630859375 0.24658203125 0.77197265625 0.456298828125
26 B19BB608-7B37-4094-AE9B-504B13660278 2018-01-14T23:22:43+00:00
[
    "Public"
]
[]
heic 0ecd701f9983b7f759eab2d53911b05de86cf0dfcde086d85c480c70cc8b8f43 3510677 37.76555333333334 -122.440025 0 0 0 0 0 0 0 0 San Francisco CA United States B19BB608-7B37-4094-AE9B-504B13660278 0.3291015625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0016231536865234375 0.041717529296875 0.0011377334594726562 0.03999999910593033 -0.0711669921875 -0.0386962890625 0.30029296875 0.005199432373046875 -0.0154266357421875 0.0089111328125 0.0123291015625 0.0244140625 0.0794677734375 0.08740234375 0.020721435546875 -0.0150146484375 0.00274658203125 0.324462890625 0.397705078125 0.28076171875 0.62158203125 0.00057220458984375
157 4BCA66D4-BF92-4060-BF82-85FAEF3033C9 2017-10-21T19:31:24+00:00
[
    "Public"
]
[]
jpeg 4b7a039dc64647efadfb959fdf8fedc82c753e590a5dc5f3a0caebc150706b1b 4252995 37.77567166666667 -122.51278666666667 0 0 0 0 0 0 0 0 San Francisco CA United States 4BCA66D4-BF92-4060-BF82-85FAEF3033C9 0.50732421875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0038089752197265625 -0.00676727294921875 0.0021076202392578125 0.009999999776482582 0.10498046875 -0.060760498046875 0.019775390625 0.0230712890625 -0.1339111328125 -0.04217529296875 -0.253662109375 -0.3642578125 0.1802978515625 -0.0487060546875 -0.004413604736328125 -0.02642822265625 0.00800323486328125 0.00806427001953125 -0.045440673828125 -0.55615234375 0.2083740234375 -0.0648193359375
1 F78D8339-34E9-4A9A-9BF8-6A73F52566EE 2017-10-21T18:11:34+00:00
[
    "Public"
]
[]
jpeg 00485aa2f328e85a25275dbdbf97af63c36e869f012302206b4c8d1f1e60c26d 5184871 37.77535 -122.51298666666666 0 0 0 0 0 0 0 0 San Francisco CA United States F78D8339-34E9-4A9A-9BF8-6A73F52566EE 0.53271484375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00037550926208496094 0.03216552734375 0.01073455810546875 0.009999999776482582 -0.34033203125 -0.0699462890625 0.1435546875 0.00524139404296875 -0.00469970703125 -0.0418701171875 -0.28076171875 0.1400146484375 0.11181640625 0.1612548828125 0.0097198486328125 -0.0096893310546875 0.0101318359375 0.026763916015625 0.0047454833984375 -0.07196044921875 -0.0020751953125 0.010009765625
187 A3621F93-93FE-4025-8C7A-ECC62CA9F326 2017-10-21T18:11:33+00:00
[
    "Public"
]
[]
jpeg 5dbba9e4d6c335f966573806fbdc841ee4fa917e1b13427e1bb6a5ff61420c44 5474835 37.77533666666667 -122.51297833333334 0 0 0 0 0 0 0 0 San Francisco CA United States A3621F93-93FE-4025-8C7A-ECC62CA9F326 0.45751953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.005428314208984375 0.00844573974609375 0.0136871337890625 0.009999999776482582 -0.230712890625 -0.06549072265625 0.0655517578125 0.0208892822265625 -0.0268096923828125 -0.061126708984375 -0.352294921875 -0.170166015625 0.386962890625 -0.00115966796875 0.005817413330078125 -0.0172271728515625 0.012969970703125 0.00867462158203125 -0.0306396484375 -0.1173095703125 -0.221435546875 -0.022216796875
260 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B 2017-09-29T01:17:17+00:00
[
    "Public"
]
[]
jpeg 7ef1fc100a8feb54edec02b3dda0255d5fd0e8260c015c1b4feeb8be39bcabca 4772665 37.77751666666666 -122.42583333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B 0.4208984375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004665374755859375 -0.000202178955078125 0.0026416778564453125 0.009999999776482582 0.003662109375 -0.10797119140625 0.034637451171875 0.009857177734375 -0.038238525390625 -0.07037353515625 -0.394775390625 -0.30859375 0.07366943359375 -0.051483154296875 -0.0014400482177734375 -0.02740478515625 0.0038700103759765625 0.0070648193359375 -0.0821533203125 -0.29833984375 0.0435791015625 0.01141357421875
198 B1FADEF4-2284-4D74-B306-1ADB41409035 2016-06-26T03:00:36+00:00
[
    "Public"
]
[]
jpeg 63ecdd738ea57a07688300501485b22be6b193e852f6af7404295da8e5a6bcee 2091348 37.784641666666666 -122.43603666666667 0 0 0 0 0 0 0 0 San Francisco CA United States B1FADEF4-2284-4D74-B306-1ADB41409035 0.1707763671875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0018243789672851562 0.017547607421875 0.005535125732421875 0.009999999776482582 -0.0880126953125 -0.044586181640625 0.0906982421875 0.01262664794921875 -0.021453857421875 -0.017578125 -0.0570068359375 -0.0455322265625 0.2359619140625 0.08258056640625 0.00566864013671875 -0.00803375244140625 0.0125274658203125 0.043701171875 0.041717529296875 -0.0128173828125 0.256103515625 0.0222320556640625
405 11C638ED-4C47-4D12-BF4C-4DF75D1508D2 2016-06-26T03:00:34+00:00
[
    "Public"
]
[]
jpeg c9364c1faae70f2d66c2e6511d612a75cf53d3a5c06da311206ac8eff3b7eab9 2104203 37.784595 -122.43608833333333 0 0 0 0 0 0 0 0 San Francisco CA United States 11C638ED-4C47-4D12-BF4C-4DF75D1508D2 0.2841796875 0.6 0.0 0.8099236641335124 0.10000000149011612 -0.0007791519165039062 0.06878662109375 0.06231689453125 0.009999999776482582 -0.0009765625 -0.0229339599609375 0.310302734375 0.0006265640258789062 -0.0035114288330078125 -0.03521728515625 0.0626220703125 0.063232421875 0.06292724609375 0.09722900390625 0.0171356201171875 -0.000911712646484375 0.00595855712890625 0.0089874267578125 -8.58306884765625e-05 0.01532745361328125 -0.065185546875 0.000820159912109375
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
134 CF759040-2FAD-4203-8C0F-88DF33C894BC 2016-03-21T00:20:29+00:00
[
    "Public"
]
[]
jpeg 3cb22fc3dc3413773a9a2d5a54948c5ffaafd400b09b6c327ff29360ad0d498d 2336745 37.80468333333334 -122.47161166666666 0 0 0 0 0 0 0 0 San Francisco CA United States CF759040-2FAD-4203-8C0F-88DF33C894BC 0.1688232421875 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.0005173683166503906 0.01345062255859375 0.004024505615234375 0.009999999776482582 0.29541015625 -0.0188751220703125 0.46044921875 0.0005035400390625 -0.01450347900390625 -0.011962890625 0.0089111328125 -0.0125732421875 0.1661376953125 -0.0172119140625 0.00833892822265625 -0.0139617919921875 0.004924774169921875 0.02288818359375 0.00434112548828125 0.0689697265625 0.395751953125 -0.023162841796875

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