photos_with_apple_metadata (view)

23 rows where ZCURATIONSCORE = "0.5" and "date" is on date 2018-02-09 sorted by ZWELLFRAMEDSUBJECTSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZFAILURESCORE, ZINTERACTIONSCORE, albums (array)

date (date) ✖

  • 2018-02-09 · 23 ✖

ZCURATIONSCORE ✖

  • 0.5 · 23 ✖
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
402 F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E 2018-02-09T17:27:30+00:00 
[
    "Public"
]
 
[]
 jpeg c7f136a2c859e0cf4683e9c496fb21501ba2d22b326f91ee68a61b048d3cf75d 6152857     0 0 0 0 0 0 0 0       F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E 0.52978515625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0015249252319335938 -0.0049591064453125 0.004039764404296875 0.009999999776482582 -0.37744140625 -0.07696533203125 0.2646484375 0.0016355514526367188 -0.01751708984375 -0.0535888671875 -0.484130859375 -0.067626953125 0.138916015625 -0.064453125 -0.0138397216796875 -0.0174102783203125 0.001926422119140625 0.00930023193359375 -0.00273895263671875 -0.4765625 -0.3681640625 -0.083740234375
248 E6BE07D8-2034-485F-9362-F9E0EC53453A 2018-02-09T17:25:46+00:00 
[
    "Public"
]
 
[]
 jpeg 793d55151710ba958b585f1956ba22787bcd2ec91882beeb20ff432bb287ce52 5996815     0 0 0 0 0 0 0 0       E6BE07D8-2034-485F-9362-F9E0EC53453A 0.525390625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.05792236328125 -0.006591796875 0.0074310302734375 0.009999999776482582 -0.513671875 -0.09503173828125 -0.1875 0.07080078125 -0.16259765625 -0.070556640625 -0.57177734375 -0.6787109375 0.093994140625 -0.0762939453125 -0.002361297607421875 -0.0206298828125 0.005535125732421875 0.0016679763793945312 -0.44384765625 -0.1187744140625 -0.3017578125 -0.049591064453125
20 89820B37-8A27-49A7-BDDF-B64253FD23FA 2018-02-09T17:34:42+00:00 
[
    "Public"
]
 
[]
 jpeg 0be986eb6ca9a9770d1c8fceecaa6d30f1c7b7514ac226b22ca2acff432e096b 5741137     0 0 0 0 0 0 0 0       89820B37-8A27-49A7-BDDF-B64253FD23FA 0.74267578125 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0011692047119140625 0.02850341796875 0.0276336669921875 0.009999999776482582 -0.180419921875 -0.037261962890625 0.343017578125 0.0012445449829101562 -0.00714874267578125 -0.06915283203125 -0.2344970703125 -0.00421142578125 0.1766357421875 -0.0137939453125 0.005542755126953125 -0.00787353515625 0.005039215087890625 0.004962921142578125 -0.0036334991455078125 -0.069580078125 -0.296630859375 -0.0173797607421875
215 C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 2018-02-09T17:07:45+00:00 
[
    "Public"
]
 
[]
 jpeg 6b5b1aca3fb2810239c1f3003ce4a0c538c9aa9ac9a9eaf0549ad24ab255ad49 5800574     0 0 0 0 0 0 0 0       C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 0.63037109375 0.5 0.0 0.04202726551594625 0.10000000149011612 -0.0227203369140625 -0.009124755859375 0.00536346435546875 0.009999999776482582 -0.3115234375 -0.061309814453125 -0.0322265625 0.0345458984375 -0.1669921875 -0.059539794921875 -0.443359375 -0.478515625 0.1287841796875 -0.07940673828125 -0.0029850006103515625 -0.0196990966796875 0.004180908203125 0.00243377685546875 -0.163330078125 -0.285400390625 -0.2890625 -0.097900390625
117 E1D818E2-89E8-4AA6-9D53-BA54F32F332B 2018-02-09T17:09:57+00:00 
[
    "Public"
]
 
[]
 jpeg 38d2cbc031e651476e9e6f76a9771e6fa9a50ca34841f6e4dab9ca5479932f11 5452392     0 0 0 0 0 0 0 0       E1D818E2-89E8-4AA6-9D53-BA54F32F332B 0.6748046875 0.5 0.0 0.042008692071638036 0.10000000149011612 -0.0063629150390625 0.00811004638671875 0.0115509033203125 0.009999999776482582 -0.20556640625 -0.03875732421875 0.03302001953125 0.0517578125 -0.062103271484375 -0.0701904296875 -0.25439453125 -0.26416015625 0.3876953125 -0.01654052734375 0.00994873046875 -0.02093505859375 0.01348114013671875 0.004314422607421875 -0.0185546875 -0.0633544921875 -0.2301025390625 -0.01535797119140625
96 628C1DF6-48DA-40FA-B6B7-BFB0AA99103B 2018-02-09T17:30:59+00:00 
[
    "Public"
]
 
[]
 jpeg 2be9ea6baf18726f34da4e447a5851b4c072fe24c12989f969d8d356009003eb 4475373     0 0 0 0 0 0 0 0       628C1DF6-48DA-40FA-B6B7-BFB0AA99103B 0.7734375 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0020580291748046875 0.00391387939453125 0.0029811859130859375 0.009999999776482582 -0.59130859375 -0.08465576171875 0.1370849609375 0.0033111572265625 -0.0184783935546875 -0.150390625 -0.458740234375 -0.140380859375 0.11199951171875 -0.11077880859375 -0.00164031982421875 -0.049957275390625 0.0035800933837890625 0.01312255859375 -0.007232666015625 -0.1181640625 -0.14794921875 -0.0172882080078125
307 CE82D764-5190-4817-8027-18562D6C4E44 2018-02-09T17:09:01+00:00 
[
    "Public"
]
 
[]
 jpeg 9482db6d0ad87c6629f59ad3a1952b14be4efe363fc7f6b7d52d9d63c6c5529b 4737344     0 0 0 0 0 0 0 0       CE82D764-5190-4817-8027-18562D6C4E44 0.7080078125 0.5 0.0 0.043530951929456406 0.10000000149011612 -0.00106048583984375 0.00131988525390625 0.0025310516357421875 0.009999999776482582 0.1129150390625 -0.0872802734375 0.288330078125 0.0020198822021484375 -0.0216217041015625 -0.09893798828125 -0.33544921875 -0.074951171875 0.2939453125 -0.1087646484375 -0.0019989013671875 -0.0322265625 0.0035381317138671875 0.01049041748046875 -0.00115203857421875 -0.4990234375 -0.13134765625 -0.06817626953125
284 A9CC4A89-22E0-42B3-8026-B07334120C45 2018-02-09T17:21:25+00:00 
[
    "Public"
]
 
[]
 jpeg 8887d5b42995cb3e6d0959d3cabca4a4b9a4ef9658de25a72ad232b282ca9f99 4911035     0 0 0 0 0 0 0 0       A9CC4A89-22E0-42B3-8026-B07334120C45 0.68212890625 0.5 0.0 0.04201816466018444 0.10000000149011612 -0.0282745361328125 -0.006748199462890625 0.0014162063598632812 0.009999999776482582 -0.4091796875 -0.08990478515625 -0.07373046875 0.057373046875 -0.342041015625 -0.06829833984375 -0.51513671875 -0.55810546875 0.0455322265625 -0.142822265625 -0.0050048828125 -0.01666259765625 0.0017747879028320312 0.00646209716796875 -0.19921875 -0.36328125 -0.099609375 -0.1099853515625
272 D034B554-9E55-4646-AE6D-D80CB5027AC5 2018-02-09T17:37:43+00:00 
[
    "Public"
]
 
[]
 jpeg 8377d9d938dd5f9a4b177099a3d97dcf7c44d14e221ca20cb2104b7f5651ea10 4534870     0 0 0 0 0 0 0 0       D034B554-9E55-4646-AE6D-D80CB5027AC5 0.697265625 0.5 0.0 0.042004234918201246 0.10000000149011612 -0.00669097900390625 0.0089111328125 0.004199981689453125 0.009999999776482582 -0.60546875 -0.0970458984375 0.046295166015625 0.0242767333984375 -0.0191192626953125 -0.0679931640625 -0.4130859375 -0.2392578125 0.148193359375 -0.00360107421875 0.00032806396484375 -0.127197265625 0.007259368896484375 0.0204925537109375 0.0147705078125 -0.0806884765625 -0.080322265625 -0.00780487060546875
293 F8A949C8-9034-4437-A685-765B42D87052 2018-02-09T17:09:29+00:00 
[
    "Public"
]
 
[]
 jpeg 8d72f82e8b04528c211dca24f9cb846e4b5f6aca72b7047714bd04eb5bdfed70 5236836     0 0 0 0 0 0 0 0       F8A949C8-9034-4437-A685-765B42D87052 0.76318359375 0.5 0.0 0.043549711012658275 0.10000000149011612 -0.002758026123046875 0.007160186767578125 0.0054473876953125 0.009999999776482582 -0.9423828125 -0.0203704833984375 0.2205810546875 0.0003936290740966797 -0.006511688232421875 -0.0133209228515625 -0.08416748046875 -0.04241943359375 0.036834716796875 0.005096435546875 -0.0263824462890625 -0.00873565673828125 0.00243377685546875 0.0274810791015625 -0.0011138916015625 0.096923828125 0.10662841796875 -0.0027599334716796875
22 E77313F1-D351-4F1C-85BA-7D88CCE26FE7 2018-02-09T17:08:14+00:00 
[
    "Public"
]
 
[]
 jpeg 0cbc72959305698cc602c5aa38a7b95b7cd3e3c7411273d63bfb3db481edffcd 4757357     0 0 0 0 0 0 0 0       E77313F1-D351-4F1C-85BA-7D88CCE26FE7 0.71875 0.5 0.0 0.043553611249414106 0.10000000149011612 -0.006290435791015625 0.02703857421875 0.006122589111328125 0.019999999552965164 -0.939453125 -0.03192138671875 0.076416015625 0.00609588623046875 -0.005706787109375 -0.00545501708984375 -0.0206298828125 -0.045166015625 0.044342041015625 0.05059814453125 -0.043212890625 -0.005584716796875 0.004215240478515625 0.073974609375 0.135498046875 0.067138671875 0.154052734375 0.00299835205078125
384 FF1D2E63-A1A2-4C67-A49B-090C603F8346 2018-02-09T17:35:20+00:00 
[
    "Public"
]
 
[]
 jpeg bf76ef31bcc06d65e439b74f09c7c7bfa3bfeaa4d463972520c658db7c59b061 4526609     0 0 0 0 0 0 0 0       FF1D2E63-A1A2-4C67-A49B-090C603F8346 0.7490234375 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0016937255859375 0.0145416259765625 0.006744384765625 0.009999999776482582 -0.91455078125 -0.021575927734375 0.235107421875 0.0006165504455566406 -0.004886627197265625 -0.01410675048828125 -0.0574951171875 -0.023193359375 0.051849365234375 0.025177001953125 -0.02044677734375 -0.007793426513671875 0.00443267822265625 0.0311431884765625 -0.0015411376953125 0.08612060546875 0.1700439453125 -0.0013217926025390625
66 8E27300C-9123-40E7-B4CF-E796FC0C5B35 2018-02-09T17:37:30+00:00 
[
    "Public"
]
 
[]
 jpeg 1e75e97d2e8a1ffe1ab3980856b20b05b648af8fb1c0ab19aa3a097597f39ae3 5924049     0 0 0 0 0 0 0 0       8E27300C-9123-40E7-B4CF-E796FC0C5B35 0.70849609375 0.5 0.0 0.04353485262120953 0.10000000149011612 -0.003780364990234375 0.0531005859375 0.00319671630859375 0.009999999776482582 -0.8896484375 -0.0182647705078125 0.3046875 0.026702880859375 -0.023468017578125 -0.014251708984375 -0.03143310546875 -0.0396728515625 0.094482421875 0.0289306640625 -0.1292724609375 -0.00994110107421875 0.0037364959716796875 0.062103271484375 0.02972412109375 0.12115478515625 0.18701171875 -0.0015716552734375
435 7A0D6ABC-4F33-4FEA-9660-2A8594C2B5F8 2018-02-09T17:34:45+00:00 
[
    "Public"
]
 
[]
 jpeg dccff810ab672e497ad4c6cf850a9093a2b7caec871f3f8bd212af56bc935f40 6095738     0 0 0 0 0 0 0 0       7A0D6ABC-4F33-4FEA-9660-2A8594C2B5F8 0.76806640625 0.5 0.0 0.043546182053689736 0.10000000149011612 -0.0016613006591796875 0.02593994140625 0.00881195068359375 0.009999999776482582 -0.9111328125 -0.0190582275390625 0.1021728515625 0.002452850341796875 -0.00469970703125 -0.00550079345703125 0.1080322265625 0.03466796875 0.08251953125 0.08984375 -0.01934814453125 -0.00405120849609375 0.0110321044921875 0.06744384765625 0.03228759765625 0.1116943359375 0.28125 0.0033588409423828125
213 FC705948-B3D8-4B7A-90A6-E617B3ED80F6 2018-02-09T17:07:31+00:00 
[
    "Public"
]
 
[]
 jpeg 69c533c4c5bfc739e1eced0562e7a2945919176fa7e13a432e5a0ee5731a59ae 5878523     0 0 0 0 0 0 0 0       FC705948-B3D8-4B7A-90A6-E617B3ED80F6 0.58740234375 0.5 0.0 0.04203098011380844 0.10000000149011612 -0.00243377685546875 0.008056640625 0.0013408660888671875 0.009999999776482582 -0.2054443359375 -0.036285400390625 0.333740234375 0.0038547515869140625 -0.02337646484375 -0.02716064453125 -0.0999755859375 -0.0706787109375 0.161376953125 -0.068359375 0.001575469970703125 -0.10321044921875 0.003795623779296875 0.07476806640625 0.0780029296875 -0.124755859375 0.33203125 -0.0229339599609375
138 78EDF691-C593-4162-B20C-F96D5675DA46 2018-02-09T17:08:28+00:00 
[
    "Public"
]
 
[]
 jpeg 3f52e7508a28417a832fb8d369adc520002ad808bc8bf480e5fca9134d16d616 4432185     0 0 0 0 0 0 0 0       78EDF691-C593-4162-B20C-F96D5675DA46 0.74755859375 0.5 0.0 0.04354636769258339 0.10000000149011612 -0.0011119842529296875 0.03460693359375 0.0135345458984375 0.009999999776482582 -0.77978515625 -0.01467132568359375 0.1280517578125 0.004772186279296875 -0.006931304931640625 -0.00461578369140625 0.178955078125 0.076171875 0.1982421875 0.11798095703125 -0.01154327392578125 -0.003734588623046875 0.025421142578125 0.06451416015625 0.024993896484375 0.1263427734375 0.33251953125 0.00576019287109375
229 A1095B7D-7675-4585-BEAE-C9A072A793C7 2018-02-09T17:31:07+00:00 
[
    "Public"
]
 
[]
 jpeg 71e3566c31cd0e96cb2c336357d709242c5c1f87d8ef11934c0b49a558ca4604 4511956     0 0 0 0 0 0 0 0       A1095B7D-7675-4585-BEAE-C9A072A793C7 0.7509765625 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0017547607421875 0.03582763671875 0.00714874267578125 0.009999999776482582 -0.87255859375 -0.034820556640625 0.05584716796875 0.004116058349609375 -0.0030517578125 -0.004730224609375 0.11669921875 0.052490234375 0.0301055908203125 0.1285400390625 -0.0123748779296875 -0.0027141571044921875 0.0074615478515625 0.097412109375 0.06146240234375 0.08624267578125 0.35400390625 0.010589599609375
372 B2AF6A23-95AB-462A-9AF9-AA5792FE43A0 2018-02-09T17:22:44+00:00 
[
    "Public"
]
 
[]
 jpeg b693381f085f8eccc64d6d4a372870542ed55390621b48e7f0acdd878de466ee 4447612     0 0 0 0 0 0 0 0       B2AF6A23-95AB-462A-9AF9-AA5792FE43A0 0.71044921875 0.5 0.0 0.043530951929456406 0.10000000149011612 -0.0005679130554199219 0.01261138916015625 0.002521514892578125 0.009999999776482582 -0.0411376953125 -0.042388916015625 0.340087890625 0.00147247314453125 -0.007175445556640625 -0.0174560546875 -0.077880859375 -0.019287109375 0.1181640625 -0.009429931640625 0.0051727294921875 -0.160888671875 0.007488250732421875 0.049224853515625 0.01480865478515625 -0.186279296875 0.419921875 -0.0118408203125
276 16243B99-6AFB-4401-9E29-90CAFB201343 2018-02-09T17:08:34+00:00 
[
    "Public"
]
 
[]
 jpeg 8476e9f946979ae2b0f1a8c1a06165e123b700464986ca846f91595a7825728a 4595280     0 0 0 0 0 0 0 0       16243B99-6AFB-4401-9E29-90CAFB201343 0.71142578125 0.5 0.0 0.04354488212643689 0.10000000149011612 -0.0030269622802734375 0.020294189453125 0.0089874267578125 0.009999999776482582 -0.92431640625 -0.0231475830078125 0.01873779296875 0.00243377685546875 -0.0050201416015625 -0.003948211669921875 0.1689453125 -0.0125732421875 0.015838623046875 0.093505859375 -0.0188446044921875 -0.002872467041015625 0.0068511962890625 0.07159423828125 0.012542724609375 0.1868896484375 0.427490234375 0.00797271728515625
149 8A4D8382-B56E-4B87-8185-3702FA3AC0CF 2018-02-09T17:30:50+00:00 
[
    "Public"
]
 
[]
 jpeg 4864ce041cb9789b351bee246199845dbd66866c44576a409c755995327bf070 4978336     0 0 0 0 0 0 0 0       8A4D8382-B56E-4B87-8185-3702FA3AC0CF 0.6328125 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0016613006591796875 0.0130462646484375 0.0018100738525390625 0.009999999776482582 -0.320556640625 -0.032470703125 0.2236328125 0.0037078857421875 -0.0207977294921875 -0.024261474609375 -0.063720703125 -0.041015625 0.10992431640625 -0.00274658203125 0.005218505859375 -0.05413818359375 0.00498199462890625 0.092529296875 0.05181884765625 0.07879638671875 0.434326171875 -0.007740020751953125
390 C721AC7F-4D2E-447B-A789-B605FA9B9D99 2018-02-09T17:33:32+00:00 
[
    "Public"
]
 
[]
 jpeg c3f1191b7ce8e4f4643e3ec3efb3040e0668e42bb966e6b90c5b4e7b36e8ecfd 5895146     0 0 0 0 0 0 0 0       C721AC7F-4D2E-447B-A789-B605FA9B9D99 0.734375 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.002704620361328125 0.00797271728515625 0.0014047622680664062 0.009999999776482582 -0.296875 -0.040252685546875 0.11865234375 0.00586700439453125 -0.060211181640625 -0.05859375 -0.097412109375 -0.121826171875 0.0604248046875 -0.057373046875 0.002368927001953125 -0.017059326171875 0.0032100677490234375 0.06634521484375 0.012908935546875 0.12347412109375 0.464111328125 -0.00754547119140625
92 C04ECCFD-2679-4E64-823F-290C47A16396 2018-02-09T17:31:04+00:00 
[
    "Public"
]
 
[]
 jpeg 28615e09f1a3d49a3392d0a8c61397d75d9dd1a6224389328565692def29b678 4471977     0 0 0 0 0 0 0 0       C04ECCFD-2679-4E64-823F-290C47A16396 0.7802734375 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0010280609130859375 0.040283203125 0.001949310302734375 0.009999999776482582 -0.0384521484375 -0.0369873046875 0.30859375 0.0029697418212890625 -0.0143890380859375 -0.0029296875 -0.00372314453125 0.03985595703125 0.10302734375 0.10400390625 0.02288818359375 -0.016357421875 0.003749847412109375 0.1630859375 0.1119384765625 0.253173828125 0.52294921875 0.0050048828125
112 558FFB4E-06B0-4782-962A-FA28C8F0B415 2018-02-09T17:34:26+00:00 
[
    "Public"
]
 
[]
 jpeg 370c4f936c1cb84f1bbeea091005103b5fa94d264733dc20d24371b1ea9fb27a 6150089     0 0 0 0 0 0 0 0       558FFB4E-06B0-4782-962A-FA28C8F0B415 0.576171875 0.5 0.0 0.04201630736125334 0.1015571802854538 -0.0010004043579101562 0.081298828125 0.002208709716796875 0.009999999776482582 0.1552734375 -0.026702880859375 0.27734375 0.011962890625 -0.00885009765625 0.02862548828125 0.1475830078125 0.19580078125 0.09979248046875 0.2252197265625 0.06927490234375 -0.00176239013671875 0.00482940673828125 0.493408203125 0.671875 0.397216796875 0.70751953125 0.040496826171875

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