This data as json, CSV (advanced)
Suggested facets: favorite, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, albums (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
381 | ![]() |
7A352102-8F91-43F5-9DCF-683E8C791770 | 2018-02-09T17:41:49+00:00 | [ "Public" ] |
[] |
jpeg | be4aca64fad3eb60b3f84489e945095e76f3765ea7cf293b408edbae0746a252 | 4322453 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7A352102-8F91-43F5-9DCF-683E8C791770 | 0.828125 | 0.75 | 0.0 | 0.06263840062017659 | 0.10000000149011612 | -0.0007295608520507812 | 0.02154541015625 | 0.0028781890869140625 | 0.009999999776482582 | 0.0172119140625 | -0.034759521484375 | 0.355712890625 | 0.002216339111328125 | -0.00714874267578125 | -0.002471923828125 | -0.01806640625 | 0.0067138671875 | 0.12158203125 | 0.011474609375 | 0.014862060546875 | -0.18603515625 | 0.007785797119140625 | 0.0704345703125 | 0.03546142578125 | -0.0577392578125 | 0.45947265625 | -0.0081939697265625 | |||||
408 | ![]() |
32EAACCC-CDA4-4922-96FE-417F7F77F79E | 2018-02-09T17:41:47+00:00 | [ "Public" ] |
[] |
jpeg | cbfe463f1a67e37a1d36c5db44f0159ef6f86a0d64a987b129b63b52e555f1af | 4486603 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 32EAACCC-CDA4-4922-96FE-417F7F77F79E | 0.8564453125 | 0.75 | 0.0 | 0.06263820133136429 | 0.10000000149011612 | -0.0009326934814453125 | 0.042755126953125 | 0.00453948974609375 | 0.009999999776482582 | -0.57568359375 | -0.0283355712890625 | 0.2100830078125 | 0.0027790069580078125 | -0.0059356689453125 | -0.0073089599609375 | 0.05865478515625 | 0.0704345703125 | 0.0247955322265625 | 0.11260986328125 | 0.0017547607421875 | -0.00522613525390625 | 0.003692626953125 | 0.11199951171875 | 0.034393310546875 | 0.1650390625 | 0.42724609375 | 0.00579833984375 | |||||
14 | ![]() |
521AC274-EDCB-4A51-BB46-96FE8A4D839F | 2018-02-09T17:41:47+00:00 | [ "Public" ] |
[] |
jpeg | 079eeabe823ae591e3038e2ba1b57cc3be2869376723af323806b6f67043f891 | 4267520 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 521AC274-EDCB-4A51-BB46-96FE8A4D839F | 0.826171875 | 0.75 | 0.0 | 0.06263778182386442 | 0.10000000149011612 | -0.00157928466796875 | 0.033843994140625 | 0.00679779052734375 | 0.009999999776482582 | -0.9248046875 | -0.0141143798828125 | 0.13134765625 | 0.001926422119140625 | -0.0038394927978515625 | -0.0030193328857421875 | 0.18359375 | 0.05108642578125 | 0.059661865234375 | 0.09136962890625 | -0.02587890625 | -0.003108978271484375 | 0.00974273681640625 | 0.10504150390625 | 0.0477294921875 | 0.2042236328125 | 0.431396484375 | 0.003818511962890625 | |||||
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 | |||||
214 | ![]() |
E2A17559-5121-45E2-9FAB-6CF7C38F3F50 | 2018-02-09T17:37:37+00:00 | [ "Public" ] |
[] |
jpeg | 69e98fd0fb8cb4a36d9feb83957fb0415c54a63bcef3c27720300496bfb8267c | 4877381 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | E2A17559-5121-45E2-9FAB-6CF7C38F3F50 | 0.76171875 | 0.75 | 0.0 | 0.06261473575621161 | 0.10000000149011612 | -0.000720977783203125 | -0.004779815673828125 | 0.0038242340087890625 | 0.009999999776482582 | 0.07135009765625 | -0.047515869140625 | 0.39404296875 | 0.0005726814270019531 | -0.0162811279296875 | -0.06329345703125 | -0.25390625 | -0.0662841796875 | 0.2359619140625 | -0.07958984375 | -0.0005092620849609375 | -0.0269012451171875 | 0.0033893585205078125 | 0.005138397216796875 | -0.0037364959716796875 | -0.5478515625 | -0.17724609375 | -0.1026611328125 | |||||
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 | |||||
232 | ![]() |
E2378A42-70B5-42A2-B8D8-CFE99DBCE627 | 2018-02-09T17:37:26+00:00 | [ "Public" ] |
[] |
jpeg | 723a6e638a563a37ff666683b28f4190a29777475aca5428660fa22d5cff5a07 | 5948701 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | E2378A42-70B5-42A2-B8D8-CFE99DBCE627 | 0.66845703125 | 0.75 | 0.0 | 0.06111104934270145 | 0.10000000149011612 | -0.0024051666259765625 | 0.013336181640625 | 0.005619049072265625 | 0.009999999776482582 | -0.91796875 | -0.020965576171875 | 0.1314697265625 | 0.0007791519165039062 | -0.00600433349609375 | -0.007549285888671875 | 0.01007080078125 | -0.02764892578125 | 0.0210418701171875 | 0.03363037109375 | -0.0223388671875 | -0.005645751953125 | 0.00313568115234375 | 0.044769287109375 | 0.005462646484375 | 0.16259765625 | 0.283935546875 | 0.00146484375 | |||||
336 | ![]() |
B70635AD-65F3-462C-993A-C13F0CA868D3 | 2018-02-09T17:35:32+00:00 | [ "Public" ] |
[] |
jpeg | a3dbd04c291b7218a634d6b0c960a80cb44a3fab625fbd7129547e61ee61dd72 | 4293844 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | B70635AD-65F3-462C-993A-C13F0CA868D3 | 0.7548828125 | 0.75 | 0.0 | 0.06261863644796474 | 0.10000000149011612 | -0.006587982177734375 | 0.00927734375 | 0.02386474609375 | 0.009999999776482582 | -0.357421875 | -0.03594970703125 | -0.0675048828125 | 0.0537109375 | -0.06671142578125 | -0.08197021484375 | -0.20751953125 | -0.3515625 | 0.27001953125 | 0.02850341796875 | 0.005828857421875 | -0.01332855224609375 | 0.023956298828125 | 0.0029811859130859375 | -0.0265045166015625 | -0.02191162109375 | -0.1678466796875 | -0.0030670166015625 | |||||
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 | |||||
306 | ![]() |
BE3BA24B-AB7E-4F85-A6E9-AC1F229E634A | 2018-02-09T17:34:41+00:00 | [ "Public" ] |
[] |
jpeg | 945618e1454a17db6e8f66f5a72266b3e47c4c14f99a38c9792e9b10133e55bd | 5522490 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BE3BA24B-AB7E-4F85-A6E9-AC1F229E634A | 0.65625 | 0.75 | 0.0 | 0.06109191898171228 | 0.10000000149011612 | -0.0017137527465820312 | 0.021484375 | 0.0060272216796875 | 0.009999999776482582 | -0.91748046875 | -0.021331787109375 | 0.2049560546875 | 0.0011119842529296875 | -0.0050201416015625 | -0.0079498291015625 | -0.02685546875 | 0.02593994140625 | 0.0287628173828125 | 0.036224365234375 | -0.029022216796875 | -0.0055999755859375 | 0.0026836395263671875 | 0.050811767578125 | 0.01702880859375 | 0.08807373046875 | 0.1494140625 | 0.0010223388671875 | |||||
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 | |||||
451 | ![]() |
B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB | 2018-02-09T17:34:17+00:00 | [ "Public" ] |
[] |
jpeg | e45462e175fd04ec7b1f37d8c3e8ebe7fd783d07a6e2c4895bd67e594d5f2693 | 4663245 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB | 0.76953125 | 0.75 | 0.0 | 0.06261473575621161 | 0.10000000149011612 | -0.0027370452880859375 | 0.0142059326171875 | 0.010986328125 | 0.009999999776482582 | -0.451171875 | -0.072265625 | 0.030364990234375 | 0.016021728515625 | -0.018096923828125 | -0.13037109375 | -0.3876953125 | -0.20703125 | 0.1900634765625 | 0.0311279296875 | 0.00605010986328125 | -0.039947509765625 | 0.0119171142578125 | 0.005199432373046875 | -0.0121917724609375 | -0.03753662109375 | -0.2171630859375 | -0.001007080078125 | |||||
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 | |||||
337 | ![]() |
365D28C9-AF11-425E-A648-3C3479A5CDE4 | 2018-02-09T17:31:04+00:00 | [ "Public" ] |
[] |
jpeg | a444857c4ac71ceae6af5192c8acc5ac35934ed589259136df0ed11295dbb085 | 4738644 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 365D28C9-AF11-425E-A648-3C3479A5CDE4 | 0.8291015625 | 0.75 | 0.0 | 0.06263034170820513 | 0.504890501499176 | -0.0005297660827636719 | 0.1136474609375 | 0.005641937255859375 | 0.009999999776482582 | 0.0384521484375 | -0.005428314208984375 | 0.36669921875 | 0.0032482147216796875 | -0.00841522216796875 | 0.00429534912109375 | 0.256591796875 | 0.1605224609375 | 0.056121826171875 | 0.144775390625 | 0.046630859375 | 0.00334930419921875 | 0.006877899169921875 | 0.1749267578125 | 0.0360107421875 | 0.68701171875 | 0.6845703125 | 0.037322998046875 | |||||
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 | |||||
95 | ![]() |
A4CA92F3-A131-498E-8205-62E1BF5A4EF4 | 2018-02-09T17:12:24+00:00 | [ "Public" ] |
[] |
jpeg | 2bb66fd402f278b2d94fe7858cc0433d75c10ae4b7dad602fea6f6d8c3cdb57f | 6153631 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | A4CA92F3-A131-498E-8205-62E1BF5A4EF4 | 0.60595703125 | 0.75 | 0.0 | 0.06109619049625542 | 0.10000000149011612 | -0.0016813278198242188 | -0.0042266845703125 | 0.002834320068359375 | 0.019999999552965164 | -0.5615234375 | -0.033599853515625 | 0.300048828125 | 0.001220703125 | -0.0206451416015625 | -0.06109619140625 | -0.2479248046875 | -0.1029052734375 | 0.1707763671875 | -0.0718994140625 | -0.003936767578125 | -0.048583984375 | 0.004070281982421875 | 0.0121917724609375 | -0.003787994384765625 | -0.199462890625 | -0.051025390625 | -0.02569580078125 | |||||
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 | |||||
31 | ![]() |
620F538F-0190-4AD6-8EAA-9E274EC04BD7 | 2018-02-09T17:09:13+00:00 | [ "Public" ] |
[] |
jpeg | 12f9020c547f61512034092d35272e60e2c076da78016ef8ae7b229e04dbc479 | 5772763 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 620F538F-0190-4AD6-8EAA-9E274EC04BD7 | 0.73876953125 | 0.75 | 0.0 | 0.06261715042682095 | 0.10000000149011612 | -0.0023059844970703125 | 0.0190277099609375 | 0.006072998046875 | 0.009999999776482582 | -0.93701171875 | -0.0162200927734375 | 0.12213134765625 | 0.0006799697875976562 | -0.004055023193359375 | -0.00333404541015625 | 0.11285400390625 | 0.0120849609375 | 0.0164031982421875 | 0.052642822265625 | -0.0272674560546875 | -0.003326416015625 | 0.00359344482421875 | 0.08477783203125 | 0.0305023193359375 | 0.2288818359375 | 0.40283203125 | 0.0032062530517578125 | |||||
338 | ![]() |
9C0E4F98-A2A8-45F8-8078-792720435621 | 2018-02-09T17:09:09+00:00 | [ "Public" ] |
[] |
jpeg | a4613c06f65f7d13e8c36a1c59025b23caf787d4775a44945e6ae2f5e7fd3929 | 5496634 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9C0E4F98-A2A8-45F8-8078-792720435621 | 0.74267578125 | 0.75 | 0.0 | 0.06261882208685839 | 0.10000000149011612 | -0.001964569091796875 | 0.00035858154296875 | 0.0014209747314453125 | 0.009999999776482582 | -0.379638671875 | -0.055511474609375 | 0.37548828125 | 0.001094818115234375 | -0.01751708984375 | -0.0670166015625 | -0.27587890625 | -0.0677490234375 | 0.0838623046875 | -0.1505126953125 | -0.00411224365234375 | -0.0555419921875 | 0.0017614364624023438 | 0.040679931640625 | 0.0148162841796875 | -0.3125 | 0.1396484375 | -0.047760009765625 | |||||
325 | ![]() |
51BEC73B-C230-4B0F-8174-7EFD498DBC9B | 2018-02-09T17:09:05+00:00 | [ "Public" ] |
[] |
jpeg | 9decc7b3b382c0f79961f2d54c6928822549d21c10d503811ea31ce39ce28e45 | 4940822 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 51BEC73B-C230-4B0F-8174-7EFD498DBC9B | 0.8017578125 | 0.75 | 0.0 | 0.0626148303956476 | 0.10000000149011612 | -0.0026836395263671875 | 0.02777099609375 | 0.007205963134765625 | 0.009999999776482582 | -0.9072265625 | -0.01861572265625 | 0.1287841796875 | 0.001956939697265625 | -0.00530242919921875 | -0.005096435546875 | 0.09722900390625 | 0.00592041015625 | 0.042388916015625 | 0.06536865234375 | -0.02935791015625 | -0.0037250518798828125 | 0.00591278076171875 | 0.06927490234375 | 0.0316162109375 | 0.158935546875 | 0.318115234375 | 0.0050048828125 | |||||
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 | |||||
239 | ![]() |
11D38304-FE06-43AD-B3F0-18FCB7697365 | 2018-02-09T17:08:15+00:00 | [ "Public" ] |
[] |
jpeg | 75acbbcbf1e97c8a33742aff62ac0255ed9eb67de35bcae0d51d9176a4f6ffe7 | 4604119 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11D38304-FE06-43AD-B3F0-18FCB7697365 | 0.7958984375 | 0.75 | 0.0 | 0.06264114652881185 | 0.10000000149011612 | -0.0010042190551757812 | 0.0269622802734375 | 0.001483917236328125 | 0.009999999776482582 | -0.148681640625 | -0.04345703125 | 0.1900634765625 | 0.005405426025390625 | -0.00974273681640625 | 0.0116119384765625 | 0.0089111328125 | 0.07745361328125 | 0.054901123046875 | 0.1292724609375 | 0.01070404052734375 | -0.00806427001953125 | 0.0035381317138671875 | 0.342041015625 | 0.37939453125 | 0.143798828125 | 0.662109375 | 0.0079345703125 | |||||
455 | ![]() |
5EAEC101-FEF6-40C8-A727-EB2C7B2EFD1E | 2018-02-09T17:08:14+00:00 | [ "Public" ] |
[] |
jpeg | e740c4271b7e85d680e53c1d4ea48662b8636d0586027b866de11f5532eb4250 | 4467400 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5EAEC101-FEF6-40C8-A727-EB2C7B2EFD1E | 0.82470703125 | 0.75 | 0.0 | 0.06263840062017659 | 0.10000000149011612 | -0.00391387939453125 | 0.0081329345703125 | 0.006439208984375 | 0.009999999776482582 | -0.93212890625 | -0.037689208984375 | 0.02410888671875 | 0.0015363693237304688 | -0.007549285888671875 | -0.0147247314453125 | -0.1170654296875 | -0.140625 | 0.018341064453125 | 0.036651611328125 | -0.01104736328125 | -0.00743865966796875 | 0.00391387939453125 | 0.0247039794921875 | -0.02410888671875 | 0.0745849609375 | 0.177001953125 | 0.0007457733154296875 | |||||
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 | |||||
326 | ![]() |
5E551A21-53F1-450B-BCEE-7A2C7CCB3C11 | 2018-02-09T17:07:59+00:00 | [ "Public" ] |
[] |
jpeg | 9e06275e7fa0e4f84d6a1e7a8ae97c27a59eebc6f3769f5b0129e492bf9c40c1 | 5328743 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5E551A21-53F1-450B-BCEE-7A2C7CCB3C11 | 0.6591796875 | 0.75 | 0.0 | 0.06111104934270145 | 0.10000000149011612 | -0.0221099853515625 | -0.0023956298828125 | 0.00266265869140625 | 0.009999999776482582 | -0.417236328125 | -0.0574951171875 | 0.162353515625 | 0.003185272216796875 | -0.055206298828125 | -0.064208984375 | -0.300048828125 | -0.2000732421875 | 0.036712646484375 | -0.1666259765625 | -0.0035400390625 | -0.01611328125 | 0.0010690689086914062 | 0.017303466796875 | -0.206787109375 | -0.138916015625 | 0.03955078125 | -0.0994873046875 | |||||
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 |
JSON shape: default, array, newline-delimited
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;