This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
52 | BB3FF61C-1AE0-4B7F-AD0E-822267EE277A | 2020-01-25T20:15:08+00:00 | [ "Public" ] |
[] |
jpeg | 19ced52283f89efaa5aa883ab9394006f5416650b6e68de75775e449886fffeb | 6758602 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BB3FF61C-1AE0-4B7F-AD0E-822267EE277A | 0.65625 | 0.75 | 0.0 | 0.06111754988896028 | 0.10000000149011612 | -0.0011653900146484375 | 0.03643798828125 | 0.004573822021484375 | 0.009999999776482582 | 0.135009765625 | -0.07904052734375 | 0.26708984375 | 0.0185394287109375 | -0.0115966796875 | -0.039031982421875 | -0.2294921875 | -0.0472412109375 | 0.18505859375 | 0.02667236328125 | -0.00054931640625 | -0.0209503173828125 | 0.00812530517578125 | 0.0225067138671875 | 0.0020751953125 | -0.340576171875 | 0.122802734375 | 0.04376220703125 | ||||||
328 | 270D8B7F-B413-477E-8B8A-E176CD4CFAAB | 2020-01-25T20:14:58+00:00 | [ "Public" ] |
[] |
jpeg | 9fd526078cb07a71f8c943f036ec2853498eb58be7aa1794a7a13b92e3cee893 | 7385215 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 270D8B7F-B413-477E-8B8A-E176CD4CFAAB | 0.6982421875 | 0.75 | 0.0 | 0.06111773552785393 | 0.10000000149011612 | -0.0006070137023925781 | 0.01513671875 | 0.0037078857421875 | 0.009999999776482582 | -0.47802734375 | -0.0216217041015625 | 0.1534423828125 | 0.00243377685546875 | -0.0120086669921875 | -0.0123443603515625 | 0.04833984375 | 0.00738525390625 | 0.0953369140625 | 0.0992431640625 | 0.002025604248046875 | -0.015899658203125 | 0.01229095458984375 | 0.0753173828125 | 0.009674072265625 | 0.1370849609375 | 0.5419921875 | 0.001552581787109375 | ||||||
78 | 92BCC6F0-0144-4501-A78D-778B3E48BF39 | 2020-01-25T20:09:19+00:00 | [ "Public" ] |
[] |
jpeg | 22772bd05c0d6e769ea86ebaa1b58ed1645b4eabc9dcc9fea052196954438fdc | 7751570 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 92BCC6F0-0144-4501-A78D-778B3E48BF39 | 0.46826171875 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0017681121826171875 | -0.00048828125 | 0.0016937255859375 | 0.07999999821186066 | 0.163818359375 | -0.08270263671875 | 0.21875 | 0.006412506103515625 | -0.0310821533203125 | -0.04290771484375 | -0.2724609375 | -0.14111328125 | 0.205078125 | -0.07684326171875 | -0.002254486083984375 | -0.0218658447265625 | 0.0035648345947265625 | 0.021820068359375 | 0.0149688720703125 | -0.49609375 | 0.0904541015625 | -0.0667724609375 | ||||||
147 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 2020-01-25T19:58:43+00:00 | [ "Public" ] |
[] |
jpeg | 4680cd4fb84a80defcdf6d6f65856a9b4a2e530096bfc0589f4a86c60ee56b2c | 7103284 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 0.6123046875 | 0.75 | 0.0 | 0.06111884981621313 | 0.5063990354537964 | -0.0011882781982421875 | 0.048492431640625 | 0.002620697021484375 | 0.009999999776482582 | 0.62109375 | -0.040985107421875 | 0.092041015625 | 0.06536865234375 | -0.0310211181640625 | 0.0171356201171875 | 0.1435546875 | 0.16357421875 | 0.03594970703125 | 0.1630859375 | 0.0496826171875 | 0.00411224365234375 | 0.00455474853515625 | 0.168212890625 | 0.1630859375 | 0.2236328125 | 0.705078125 | 0.43408203125 | ||||||
223 | B29AB28B-D604-408A-923C-45D779BCB380 | 2020-01-25T19:57:50+00:00 | [ "Public" ] |
[] |
jpeg | 6f92ecbbc9835eedeb6c95e828fe99398a85ead6c52dd116bd953cf4a26dafb6 | 5776484 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | B29AB28B-D604-408A-923C-45D779BCB380 | 0.599609375 | 0.75 | 0.0 | 0.06111792116674758 | 0.10000000149011612 | -0.0009255409240722656 | 0.0242462158203125 | 0.0034694671630859375 | 0.019999999552965164 | 0.38623046875 | -0.0982666015625 | 0.058197021484375 | 0.018096923828125 | -0.0121002197265625 | 0.000335693359375 | -0.111572265625 | 0.11328125 | 0.03155517578125 | 0.118896484375 | 0.00444793701171875 | -0.00079345703125 | 0.0035648345947265625 | 0.06500244140625 | 0.06536865234375 | -0.10003662109375 | 0.36474609375 | 0.423583984375 | ||||||
417 | 08E42F94-41A8-4205-995A-9877453FAF92 | 2020-01-25T19:56:23+00:00 | [ "Public" ] |
[] |
jpeg | d3e53a733fe399fa38178513d64414c8d65639d4191cefb94ec2b7f4741dd67c | 6550072 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 08E42F94-41A8-4205-995A-9877453FAF92 | 0.53515625 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0009889602661132812 | 0.0112152099609375 | 0.0030155181884765625 | 0.019999999552965164 | -0.4736328125 | -0.0181884765625 | 0.410888671875 | 0.0008263587951660156 | -0.01422882080078125 | -0.03338623046875 | -0.06829833984375 | -0.012237548828125 | 0.1614990234375 | -0.030914306640625 | -0.000240325927734375 | -0.0221405029296875 | 0.004039764404296875 | 0.040313720703125 | 0.0086822509765625 | 0.0670166015625 | 0.204833984375 | -0.01134490966796875 | ||||||
327 | 4ABA19BB-4FAA-4A65-A79E-BAEE455ACA00 | 2020-01-25T19:45:34+00:00 | [ "Public" ] |
[] |
jpeg | 9f498cd0be0d5dcd46726651f0a3124f26218483c8dea3749507a4867ab325bd | 5827512 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4ABA19BB-4FAA-4A65-A79E-BAEE455ACA00 | 0.6240234375 | 0.75 | 0.0 | 0.06109860516686476 | 0.10000000149011612 | -0.00034737586975097656 | 0.0128173828125 | 0.00395965576171875 | 0.009999999776482582 | -0.19140625 | -0.0374755859375 | 0.2568359375 | 0.0023784637451171875 | -0.007843017578125 | -0.013397216796875 | -0.09765625 | 0.03204345703125 | 0.2281494140625 | 0.043853759765625 | 0.000957489013671875 | -0.0231170654296875 | 0.01348114013671875 | 0.04534912109375 | 0.0098876953125 | -0.172607421875 | 0.347412109375 | -0.00164031982421875 | ||||||
465 | 4B150041-A82D-498B-9C21-A3664E3EE796 | 2020-01-25T19:42:30+00:00 | [ "Public" ] |
[] |
jpeg | eadaf1d75482cf7d03028aef7ddaf7e9586a0b5d45065ec002823411d525deb4 | 5951301 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4B150041-A82D-498B-9C21-A3664E3EE796 | 0.65625 | 0.75 | 0.0 | 0.061110306332129556 | 0.10000000149011612 | -0.001941680908203125 | 0.01409912109375 | 0.0059814453125 | 0.009999999776482582 | -0.35302734375 | -0.10284423828125 | 0.001708984375 | 0.02288818359375 | -0.0110321044921875 | -0.0158233642578125 | -0.2626953125 | -0.07421875 | 0.0318603515625 | 0.0841064453125 | 0.00275421142578125 | -0.01221466064453125 | 0.006389617919921875 | 0.044677734375 | 0.029083251953125 | -0.051971435546875 | 0.247802734375 | 0.024688720703125 | ||||||
139 | 665B18F1-6E4A-436B-A415-11622E442B2C | 2020-01-25T19:39:28+00:00 | [ "Public" ] |
[] |
jpeg | 42819b1d0b26b476c552433396fecaf1be936248ced47197a9eed334600c24e1 | 5033561 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 665B18F1-6E4A-436B-A415-11622E442B2C | 0.5908203125 | 0.75 | 0.0 | 0.06110454879644263 | 0.10000000149011612 | -0.0010690689086914062 | 0.0222320556640625 | 0.0021991729736328125 | 0.07999999821186066 | 0.3505859375 | -0.0982666015625 | 0.031463623046875 | 0.01016998291015625 | -0.00809478759765625 | -0.0009613037109375 | -0.026611328125 | 0.0654296875 | 0.0167236328125 | 0.1898193359375 | 0.01091766357421875 | -0.001750946044921875 | 0.0030040740966796875 | 0.1026611328125 | 0.107666015625 | 0.0660400390625 | 0.53173828125 | 0.270751953125 | ||||||
416 | 2E3925D6-FB1F-49E4-A256-7D25B38E5E77 | 2020-01-25T19:37:50+00:00 | [ "Public" ] |
[] |
jpeg | d23b781c34e27fe18532881ee293166328d8e1836ab6b50b1f70ea312b5e0aab | 5532065 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2E3925D6-FB1F-49E4-A256-7D25B38E5E77 | 0.5263671875 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0017681121826171875 | 0.003124237060546875 | 0.003376007080078125 | 0.009999999776482582 | -0.63232421875 | -0.03753662109375 | 0.183837890625 | 0.001972198486328125 | -0.0239105224609375 | -0.08551025390625 | -0.23046875 | -0.079833984375 | 0.1666259765625 | -0.06610107421875 | -0.001552581787109375 | -0.053802490234375 | 0.005344390869140625 | 0.02069091796875 | 0.00113677978515625 | -0.03753662109375 | 0.025390625 | -0.0134429931640625 | ||||||
446 | 918F5128-ED51-4B1D-AA2C-2F14620312D9 | 2020-01-25T19:33:14+00:00 | [ "Public" ] |
[] |
jpeg | e2b0909125998e92b5706502750d803bc015626f46245dc6200485596ceaa9fd | 6170843 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 918F5128-ED51-4B1D-AA2C-2F14620312D9 | 0.57861328125 | 0.75 | 0.0 | 0.061101019837474096 | 0.10000000149011612 | -0.004070281982421875 | 0.000705718994140625 | 0.00806427001953125 | 0.009999999776482582 | -0.56787109375 | -0.0638427734375 | 0.0030517578125 | 0.00989532470703125 | -0.042724609375 | -0.07275390625 | -0.401611328125 | -0.247314453125 | 0.1795654296875 | -0.01953125 | -0.0017490386962890625 | -0.0150146484375 | 0.00806427001953125 | 0.00579833984375 | -0.0257415771484375 | -0.0660400390625 | -0.209228515625 | -0.00969696044921875 | ||||||
310 | F92B1415-1D5D-45A6-A736-54D988748BBF | 2020-01-25T19:32:06+00:00 | [ "Public" ] |
[] |
jpeg | 96bc3134c1bd2553c164f1eee6971a22ed15893dc5dabcc717fc1f72317e044a | 5851617 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | F92B1415-1D5D-45A6-A736-54D988748BBF | 0.5068359375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.030731201171875 | 0.00522613525390625 | 0.00208282470703125 | 0.009999999776482582 | -0.45166015625 | -0.199951171875 | -0.006561279296875 | 0.033905029296875 | -0.04132080078125 | -0.09454345703125 | -0.6005859375 | -0.357666015625 | 0.0240936279296875 | -0.1298828125 | 0.002777099609375 | -0.021331787109375 | 0.0008692741394042969 | 0.020294189453125 | -0.1363525390625 | -0.057342529296875 | -0.0946044921875 | -0.033966064453125 | ||||||
130 | BA466D66-989B-4E8B-9553-85D91421A124 | 2020-01-25T19:29:49+00:00 | [ "Public" ] |
[] |
jpeg | 3bfaee669a60e68459cd2a6301cbd8f919a22c8aa8b16c9bcf922b00684bacca | 6274922 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BA466D66-989B-4E8B-9553-85D91421A124 | 0.70263671875 | 0.75 | 0.0 | 0.06262606564368911 | 0.10000000149011612 | -0.00208282470703125 | 0.003932952880859375 | 0.004962921142578125 | 0.009999999776482582 | -0.748046875 | -0.021697998046875 | 0.1973876953125 | 0.0006666183471679688 | -0.0141754150390625 | -0.015594482421875 | -0.07763671875 | -0.0440673828125 | 0.04986572265625 | -0.003753662109375 | -0.0113983154296875 | -0.0113372802734375 | 0.00307464599609375 | 0.0268096923828125 | 5.340576171875e-05 | 0.09686279296875 | 0.214599609375 | -0.007381439208984375 | ||||||
295 | 75769611-9E07-4AD8-B4E5-EADBB49A24B6 | 2020-01-25T19:24:51+00:00 | [ "Public" ] |
[] |
jpeg | 8e11c96572a7adaf0336e8c28efda0bd88625e1d52f599edf3ec18e8ef6c3e6a | 6477627 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 75769611-9E07-4AD8-B4E5-EADBB49A24B6 | 0.62890625 | 0.75 | 0.0 | 0.06112145012571611 | 0.5028467178344727 | -0.0005154609680175781 | 0.04217529296875 | 0.047698974609375 | 0.009999999776482582 | 0.0521240234375 | -0.0273284912109375 | 0.1328125 | 0.006168365478515625 | -0.006744384765625 | -0.007568359375 | 0.1033935546875 | 0.180908203125 | 0.2493896484375 | 0.1846923828125 | 0.030029296875 | -0.00054931640625 | 0.0313720703125 | 0.0229339599609375 | 0.007598876953125 | 0.000762939453125 | 0.05804443359375 | 0.01450347900390625 | ||||||
335 | 9B1D1359-1267-42DE-BB2C-6DB3B885D3E0 | 2020-01-25T19:22:55+00:00 | [ "Public" ] |
[] |
jpeg | a29c3a38ab84cb5a9158d2d1f5047f614c3065bc852042909e5ac09a59988275 | 5399639 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9B1D1359-1267-42DE-BB2C-6DB3B885D3E0 | 0.46875 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0006771087646484375 | 0.032440185546875 | 0.00464630126953125 | 0.009999999776482582 | -0.192138671875 | -0.0174407958984375 | 0.354248046875 | 0.001056671142578125 | -0.008544921875 | -0.00421142578125 | 0.0537109375 | 0.05224609375 | 0.07861328125 | 0.060516357421875 | 0.00852203369140625 | -0.0089111328125 | 0.00469970703125 | 0.08929443359375 | 0.027984619140625 | 0.271240234375 | 0.461181640625 | 0.0001983642578125 | ||||||
340 | B2D7A748-4171-43EA-8561-917E3A1007D4 | 2020-01-25T19:22:41+00:00 | [ "Public" ] |
[] |
jpeg | a4e1151738c54fb914d1be6b4dbd1a9a73724b36e64024e2e9193257ea6aeeed | 5058245 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | B2D7A748-4171-43EA-8561-917E3A1007D4 | 0.6318359375 | 0.75 | 0.0 | 0.06111624950671014 | 0.10000000149011612 | -0.0035381317138671875 | -0.002574920654296875 | 0.0014047622680664062 | 0.009999999776482582 | 0.32080078125 | -0.0775146484375 | 0.0428466796875 | 0.0234222412109375 | -0.06756591796875 | -0.0242462158203125 | -0.2017822265625 | -0.34521484375 | 0.061187744140625 | -0.03875732421875 | -0.002887725830078125 | -0.016510009765625 | 0.0034694671630859375 | 0.015960693359375 | -0.0357666015625 | -0.447265625 | 0.332763671875 | -0.0322265625 | ||||||
434 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 2020-01-25T19:22:04+00:00 | [ "Public" ] |
[] |
jpeg | db785fae4d60624d0a90c7fc24ec36f2b6b95f6d158b42d8973210f3cabba91a | 6428626 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 0.64501953125 | 0.75 | 0.0 | 0.06110269104251425 | 0.10000000149011612 | -0.001972198486328125 | 0.003810882568359375 | 0.00208282470703125 | 0.009999999776482582 | 0.3271484375 | -0.042022705078125 | 0.2122802734375 | 0.0031108856201171875 | -0.0309600830078125 | -0.0080718994140625 | -0.04730224609375 | -0.1087646484375 | 0.04803466796875 | -0.0256805419921875 | 2.288818359375e-05 | -0.01338958740234375 | 0.002704620361328125 | 0.039642333984375 | 0.016815185546875 | -0.213623046875 | 0.50048828125 | -0.026947021484375 | ||||||
377 | 82A06650-7B8E-4201-B971-3DE78335B82C | 2020-01-25T19:22:02+00:00 | [ "Public" ] |
[] |
jpeg | b95d5a4455b8a51754ee4967c137988efd1e2044ee15e2a5439b7efbde4de662 | 5892329 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82A06650-7B8E-4201-B971-3DE78335B82C | 0.6015625 | 0.75 | 0.0 | 0.06112200749739436 | 0.10000000149011612 | -0.0011119842529296875 | 0.0006866455078125 | 0.0025501251220703125 | 0.009999999776482582 | -0.0550537109375 | -0.09332275390625 | 0.181640625 | 0.00455474853515625 | -0.019195556640625 | -0.06591796875 | -0.392578125 | -0.126220703125 | 0.131103515625 | -0.0633544921875 | -0.0030670166015625 | -0.030914306640625 | 0.0038394927978515625 | 0.01322174072265625 | -0.00286865234375 | -0.4267578125 | -0.038818359375 | -0.038116455078125 | ||||||
53 | 9AEC59F0-3F75-4204-B714-152B697AD6F0 | 2020-01-25T19:20:41+00:00 | [ "Public" ] |
[] |
jpeg | 1a002a90928b3ebf1cfc5e4a2e274f9e8a14345a634cb05751ad1ce3da6b7c52 | 5012912 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9AEC59F0-3F75-4204-B714-152B697AD6F0 | 0.62548828125 | 0.75 | 0.0 | 0.06110454879644263 | 0.10000000149011612 | -0.00263214111328125 | -0.005542755126953125 | 0.0029010772705078125 | 0.03999999910593033 | -0.005126953125 | -0.08978271484375 | 0.12939453125 | 0.00646209716796875 | -0.04327392578125 | -0.09356689453125 | -0.4306640625 | -0.2392578125 | 0.1856689453125 | -0.10101318359375 | -0.0021648406982421875 | -0.0205535888671875 | 0.0036220550537109375 | 0.0050201416015625 | -0.02783203125 | -0.452880859375 | -0.1956787109375 | -0.0889892578125 | ||||||
47 | 40743ED8-8D41-4EF9-92A9-2194CFE8D5BA | 2020-01-25T19:17:45+00:00 | [ "Public" ] |
[] |
jpeg | 172d1ef80b625f543d4d1f38221735167d59f81d5d07bdaeca64d92dc916745d | 10907342 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40743ED8-8D41-4EF9-92A9-2194CFE8D5BA | 0.6494140625 | 0.75 | 0.0 | 0.061120150198463265 | 0.10000000149011612 | -0.005279541015625 | 0.01611328125 | 0.0020999908447265625 | 0.009999999776482582 | -0.60986328125 | -0.060089111328125 | -0.115478515625 | 0.1246337890625 | -0.05718994140625 | -0.0340576171875 | -0.120361328125 | -0.29638671875 | 0.0265045166015625 | 0.1781005859375 | 0.006404876708984375 | -0.00860595703125 | 0.0068511962890625 | 0.062225341796875 | -0.011566162109375 | 0.0928955078125 | 0.46533203125 | 0.02056884765625 | ||||||
10 | 87585FA7-EF4D-4028-97D2-21631F66A32D | 2020-01-25T19:17:10+00:00 | [ "Public" ] |
[] |
jpeg | 04646192855eb795b440552ad953dd63ed7ef4adece0bb85d42b19586a6e2c59 | 5296462 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 87585FA7-EF4D-4028-97D2-21631F66A32D | 0.5302734375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0020751953125 | -0.00121307373046875 | 0.0015010833740234375 | 0.009999999776482582 | 0.32666015625 | -0.06439208984375 | 0.1422119140625 | 0.012054443359375 | -0.056121826171875 | -0.03155517578125 | -0.16259765625 | -0.2366943359375 | 0.092041015625 | -0.05120849609375 | -0.0021514892578125 | -0.017608642578125 | 0.0036640167236328125 | 0.0169830322265625 | -0.0141448974609375 | -0.45458984375 | 0.3212890625 | -0.041168212890625 | ||||||
196 | 111A61B2-82D2-4D3D-8B38-7D6C4806C604 | 2020-01-25T19:07:18+00:00 | [ "Public" ] |
[] |
jpeg | 639ea88d6253c88b10ff8b131e1845d276be62531c8c520b791f34fe905796bf | 6193450 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 111A61B2-82D2-4D3D-8B38-7D6C4806C604 | 0.454345703125 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.00359344482421875 | -0.002674102783203125 | 0.0018243789672851562 | 0.009999999776482582 | 0.2333984375 | -0.062103271484375 | 0.07958984375 | 0.0154266357421875 | -0.09039306640625 | -0.044921875 | -0.182861328125 | -0.30029296875 | 0.105224609375 | -0.06201171875 | -0.0027313232421875 | -0.018280029296875 | 0.00424957275390625 | 0.0118255615234375 | -0.038177490234375 | -0.403076171875 | 0.25341796875 | -0.0418701171875 | ||||||
202 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 2020-01-25T19:03:32+00:00 | [ "Public" ] |
[] |
jpeg | 65b2d4d5f0693ef127465fad373af915e4db5df063dababcb0fb9a1b12e0a351 | 5218889 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 0.5869140625 | 0.75 | 0.0 | 0.06111996410457232 | 0.10000000149011612 | -0.0009965896606445312 | 0.03253173828125 | 0.007518768310546875 | 0.009999999776482582 | -0.417236328125 | -0.061981201171875 | 0.10888671875 | 0.0135345458984375 | -0.0104522705078125 | -0.09515380859375 | -0.2369384765625 | -0.03076171875 | 0.224365234375 | 0.1480712890625 | 0.0130462646484375 | -0.02838134765625 | 0.01525115966796875 | 0.0216217041015625 | 0.00318145751953125 | -0.028045654296875 | -0.00390625 | 0.00098419189453125 | ||||||
352 | 26FB982C-7AE2-44C4-8743-4611F9FA8EE8 | 2020-01-25T19:00:21+00:00 | [ "Public" ] |
[] |
jpeg | ab3b4adfb99b25cc51317bf712fff9c137adb06f2b3e7708b358c999dc2cad7d | 7746045 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26FB982C-7AE2-44C4-8743-4611F9FA8EE8 | 0.59130859375 | 0.75 | 0.0 | 0.06111754988896028 | 0.10000000149011612 | -0.0016231536865234375 | 0.019073486328125 | 0.00494384765625 | 0.009999999776482582 | -0.0460205078125 | -0.06744384765625 | 0.25634765625 | 0.00867462158203125 | -0.0177154541015625 | -0.03045654296875 | -0.246826171875 | -0.0267333984375 | 0.1591796875 | -0.001983642578125 | -0.013824462890625 | -0.009918212890625 | 0.0037364959716796875 | 0.022247314453125 | 0.0163421630859375 | -0.27490234375 | -0.0108642578125 | 0.011962890625 | ||||||
127 | A7B4A20F-E043-4229-A913-6EE1B2679D8C | 2020-01-25T18:59:14+00:00 | [ "Public" ] |
[] |
jpeg | 3bc6d33c08d4a70a442c7b1cee387f841108de0b8a242f6df8d13796c179051a | 5930965 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | A7B4A20F-E043-4229-A913-6EE1B2679D8C | 0.5947265625 | 0.75 | 0.0 | 0.06110269104251425 | 0.5034793019294739 | -0.0003936290740966797 | 0.054351806640625 | 0.0374755859375 | 0.009999999776482582 | 0.0087890625 | -0.02685546875 | 0.2066650390625 | 0.0034160614013671875 | -0.004573822021484375 | -0.012481689453125 | 0.110595703125 | 0.1519775390625 | 0.2254638671875 | 0.191650390625 | 0.0245208740234375 | -0.00310516357421875 | 0.0289764404296875 | 0.0272674560546875 | 0.00542449951171875 | 0.007781982421875 | 0.11492919921875 | 0.0066986083984375 | ||||||
27 | 2693563F-47A0-44FB-8AAA-5C550F793ACF | 2020-01-25T18:59:12+00:00 | [ "Public" ] |
[] |
jpeg | 10be54c63218a152006e95a6dd30016c39928fbf3bf7ae688bf4fc251a018e7b | 6476888 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2693563F-47A0-44FB-8AAA-5C550F793ACF | 0.58251953125 | 0.75 | 0.0 | 0.06111754988896028 | 0.5025790929794312 | -0.00014770030975341797 | 0.029327392578125 | 0.02423095703125 | 0.009999999776482582 | 0.461181640625 | -0.023956298828125 | 0.04034423828125 | 0.00864410400390625 | -0.00582122802734375 | 0.0140380859375 | 0.442626953125 | 0.154052734375 | 0.34912109375 | 0.380859375 | 0.01399993896484375 | -0.0012359619140625 | 0.2022705078125 | 0.06829833984375 | 0.00632476806640625 | 0.01263427734375 | 0.6279296875 | 0.01904296875 | ||||||
362 | ECCE503B-E993-4A85-B489-BC54DB8A3B40 | 2020-01-25T18:59:11+00:00 | [ "Public" ] |
[] |
jpeg | b1cd0517ea1ec79061b0bb36dc4edde23bc047fa51f4f9296094eb62998bb343 | 6220683 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ECCE503B-E993-4A85-B489-BC54DB8A3B40 | 0.6611328125 | 0.75 | 0.0 | 0.06112145012571611 | 0.10000000149011612 | -0.0010366439819335938 | 0.0161285400390625 | 0.00394439697265625 | 0.009999999776482582 | 0.1468505859375 | -0.06097412109375 | 0.2861328125 | 0.005279541015625 | -0.016021728515625 | -0.028533935546875 | -0.1756591796875 | -0.028564453125 | 0.2139892578125 | -0.005523681640625 | -0.0040130615234375 | -0.0117950439453125 | 0.004810333251953125 | 0.021453857421875 | 0.0137176513671875 | -0.29931640625 | 0.0784912109375 | 0.01190185546875 | ||||||
221 | F367069B-2C5A-4C2E-BFCE-29AE79C72E73 | 2020-01-25T18:58:11+00:00 | [ "Public" ] |
[] |
jpeg | 6f2595c2865301e8535ba3dee97fcb6ac321414e7989762856016992175c511f | 6005431 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | F367069B-2C5A-4C2E-BFCE-29AE79C72E73 | 0.5732421875 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.002521514892578125 | 0.002841949462890625 | 0.0012941360473632812 | 0.009999999776482582 | 0.147705078125 | -0.06756591796875 | 0.1873779296875 | 0.00473785400390625 | -0.037384033203125 | -0.025177001953125 | -0.1666259765625 | -0.1290283203125 | 0.04595947265625 | -0.0789794921875 | -0.00115203857421875 | -0.01421356201171875 | 0.0018749237060546875 | 0.049041748046875 | 0.020660400390625 | -0.311767578125 | 0.4150390625 | -0.03570556640625 | ||||||
15 | 4DC7BCE0-2E5D-49CC-8E53-7925D151C515 | 2020-01-25T18:52:36+00:00 | [ "Public" ] |
[] |
jpeg | 080ccfeebd505833d5594b97dcb6cc3a5150d21b67dfe52cd7dbd3107f42adb7 | 7302323 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4DC7BCE0-2E5D-49CC-8E53-7925D151C515 | 0.57666015625 | 0.75 | 0.0 | 0.06111699251728203 | 0.10051094740629196 | -0.00010973215103149414 | 0.051239013671875 | 0.05572509765625 | 0.009999999776482582 | 0.53125 | -0.0179901123046875 | 0.040679931640625 | 0.007205963134765625 | -0.00313568115234375 | 0.0148162841796875 | 0.59716796875 | 0.264892578125 | 0.55712890625 | 0.5400390625 | 0.02410888671875 | 0.00438690185546875 | 0.33642578125 | 0.0709228515625 | 0.01120758056640625 | 0.038970947265625 | 0.4921875 | 0.0167999267578125 | ||||||
418 | EA3A8FC2-1DB9-4906-B822-6FF0EABF625F | 2020-01-25T18:52:28+00:00 | [ "Public" ] |
[] |
jpeg | d3f48a9446d71b64f463675a11cfab4ef085b6896b185b7120daa151b946bb79 | 5676312 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | EA3A8FC2-1DB9-4906-B822-6FF0EABF625F | 0.5693359375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.001926422119140625 | 0.0110931396484375 | 0.00881195068359375 | 0.009999999776482582 | -0.0911865234375 | -0.039642333984375 | 0.021240234375 | 0.01302337646484375 | -0.0330810546875 | -0.01708984375 | -0.04541015625 | -0.11285400390625 | 0.0360107421875 | 0.04541015625 | 0.003551483154296875 | -0.00506591796875 | 0.006313323974609375 | 0.0164642333984375 | -0.00704193115234375 | 0.0286865234375 | 0.219970703125 | 0.03277587890625 | ||||||
227 | E087C09F-9D37-4E2E-8E42-215F0C773369 | 2020-01-25T18:48:02+00:00 | [ "Public" ] |
[] |
jpeg | 719b12e1e7cef678ca95d941874adad4e0759d0fcdc4563ac3f40150e0a1813c | 8366614 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | E087C09F-9D37-4E2E-8E42-215F0C773369 | 0.751953125 | 0.75 | 0.0 | 0.06264426735521272 | 0.10000000149011612 | -0.0008625984191894531 | 0.01242828369140625 | 0.002811431884765625 | 0.009999999776482582 | -0.403564453125 | -0.02838134765625 | 0.1259765625 | 0.0038394927978515625 | -0.01422882080078125 | -0.005523681640625 | 0.0184326171875 | -0.00054931640625 | 0.06866455078125 | 0.0753173828125 | 0.000644683837890625 | -0.01145172119140625 | 0.00809478759765625 | 0.1044921875 | 0.032470703125 | 0.108154296875 | 0.58837890625 | 0.003204345703125 | ||||||
323 | CDF1C18C-EAA3-4CEE-BEA5-2F772129E7EC | 2020-01-25T18:47:26+00:00 | [ "Public" ] |
[] |
jpeg | 9d89e3a7d469140bbf6ce7d5aa86fd38aa0e2c9040182ad6dae708950826bd77 | 9009661 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CDF1C18C-EAA3-4CEE-BEA5-2F772129E7EC | 0.607421875 | 0.75 | 0.0 | 0.06111792116674758 | 0.10000000149011612 | -0.0007948875427246094 | 0.0190582275390625 | 0.0035381317138671875 | 0.009999999776482582 | -0.314208984375 | -0.0230712890625 | 0.072021484375 | 0.01137542724609375 | -0.015777587890625 | -0.0007476806640625 | 0.154541015625 | -0.005859375 | 0.1446533203125 | 0.1470947265625 | 0.0025482177734375 | -0.00957489013671875 | 0.0276947021484375 | 0.1357421875 | 0.039886474609375 | 0.13623046875 | 0.7275390625 | 0.00957489013671875 |
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;