photos_with_apple_metadata (view)

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

✎ 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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