This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21 | 1B036D9A-1FF2-48C2-94CF-2D78AA0A294B | 2019-03-24T16:22:44+00:00 | [ "Super bloom 2019", "Public" ] |
[] |
jpeg | 0c10051ea2faecba0981d6d96108dc3d36a02c641bdc21c12c77ab01fdef7f4c | 6391209 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1B036D9A-1FF2-48C2-94CF-2D78AA0A294B | 0.5966796875 | 0.75 | 0.0 | 0.06109619049625542 | 0.10000000149011612 | -0.0021915435791015625 | 0.07763671875 | 0.0099334716796875 | 0.009999999776482582 | -0.197265625 | -0.02886962890625 | 0.310302734375 | 0.007175445556640625 | -0.006931304931640625 | -0.01361083984375 | -0.0181884765625 | 0.05474853515625 | 0.453857421875 | 0.11376953125 | 0.022857666015625 | -0.003154754638671875 | 0.0089874267578125 | 0.06915283203125 | 0.2330322265625 | 0.0185089111328125 | -0.00677490234375 | -0.0005950927734375 | ||||||
143 | 090F6409-3525-4789-A369-CB5290CA68E0 | 2019-03-23T22:59:53+00:00 | [ "Super bloom 2019", "Public" ] |
[] |
heic | 43b53dbbae15a9c322fc74b76f2b646e3e2e04339fcd42a876fb3dc048423467 | 2816810 | 34.506328333333336 | -117.82743 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Llano | CA | United States | 090F6409-3525-4789-A369-CB5290CA68E0 | 0.6689453125 | 0.75 | 0.0 | 0.06110473443533628 | 0.5036253333091736 | -0.0009584426879882812 | 0.0760498046875 | 0.07574462890625 | 0.009999999776482582 | 0.0804443359375 | -0.021209716796875 | 0.0628662109375 | 0.00577545166015625 | -0.0059814453125 | -0.00937652587890625 | 0.323486328125 | 0.159423828125 | 0.029876708984375 | 0.2138671875 | 0.0303192138671875 | 0.00656890869140625 | 0.01056671142578125 | 0.014556884765625 | 0.00193023681640625 | 0.033294677734375 | 0.0126953125 | 0.02459716796875 | |
461 | CE0B0837-963E-4427-8C83-23D6DC01DFEC | 2019-03-23T17:56:08+00:00 | [ "Super bloom 2019", "Public" ] |
[] |
heic | e9600c56afe37e32ec148695c3dc40a5539235ac4b656c78d516d7665aa9be74 | 2040240 | 33.92010833333333 | -116.77295 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Cabazon | CA | United States | CE0B0837-963E-4427-8C83-23D6DC01DFEC | 0.591796875 | 0.75 | 0.0 | 0.06112145012571611 | 0.10000000149011612 | -0.0006237030029296875 | 0.021240234375 | 0.0018033981323242188 | 0.009999999776482582 | -0.149658203125 | -0.059539794921875 | 0.117431640625 | 0.005279541015625 | -0.01016998291015625 | 0.00030517578125 | -0.0347900390625 | 0.05010986328125 | 0.052520751953125 | 0.1978759765625 | 0.006084442138671875 | -0.0106201171875 | 0.006191253662109375 | 0.183349609375 | 0.08062744140625 | 0.0382080078125 | 0.61279296875 | 0.0202484130859375 | |
365 | 2C4C0C9B-AF5C-4F0F-BE45-9C70E7A4A898 | 2019-03-23T17:53:07+00:00 | [ "Super bloom 2019", "Public" ] |
[] |
heic | b2eaa44367a25992bdd26676048e70221cbf9b6c858c38d274cb8c75956341c8 | 1557937 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2C4C0C9B-AF5C-4F0F-BE45-9C70E7A4A898 | 0.414794921875 | 0.75 | 0.0 | 0.05801526718694745 | 0.10065693408250809 | -0.0018177032470703125 | 0.04876708984375 | 0.0016546249389648438 | 0.009999999776482582 | 0.2822265625 | -0.037261962890625 | 0.288330078125 | 0.00482940673828125 | -0.0108184814453125 | 0.01113128662109375 | 0.07794189453125 | 0.097900390625 | 0.0283355712890625 | 0.0557861328125 | 0.04193115234375 | -0.0036468505859375 | 0.0011339187622070312 | 0.410888671875 | 0.7607421875 | 0.5146484375 | 0.6669921875 | 0.03277587890625 | ||||||
153 | 277A0A26-444D-4384-8C97-794E66861E96 | 2019-03-23T17:49:38+00:00 | [ "Super bloom 2019", "Public" ] |
[] |
heic | 49d5950465c58d12cdf4a1d8ebb444154166e209ff3da59fd386c6d3a8455273 | 1719719 | 33.92028333333333 | -116.77268333333333 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Cabazon | CA | United States | 277A0A26-444D-4384-8C97-794E66861E96 | 0.7216796875 | 0.75 | 0.0 | 0.06418695750127312 | 0.10000000149011612 | -0.006191253662109375 | 0.010955810546875 | 0.0015735626220703125 | 0.009999999776482582 | -0.306640625 | -0.107421875 | 0.11260986328125 | 0.01090240478515625 | -0.0177764892578125 | -0.01666259765625 | -0.23291015625 | -0.11114501953125 | 0.0472412109375 | -0.01611328125 | -0.002410888671875 | -0.07281494140625 | 0.001972198486328125 | 0.11474609375 | 0.406982421875 | -0.0384521484375 | 0.34521484375 | -0.01123046875 | |
445 | 7E21418A-1A30-43AB-B025-4D6576EA29CE | 2019-03-22T22:51:03+00:00 | [ "Super bloom 2019", "Public" ] |
[] |
jpeg | e2545bfd95a2eeda1f7954786d30c987dcedf4f46b4138334b81a4b70d546fa1 | 9499051 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7E21418A-1A30-43AB-B025-4D6576EA29CE | 0.6044921875 | 0.75 | 0.0 | 0.06108839002274375 | 0.5067153573036194 | -0.000720977783203125 | 0.05499267578125 | 0.0169219970703125 | 0.05999999865889549 | 0.2783203125 | -0.059967041015625 | 0.048614501953125 | 0.007785797119140625 | -0.00763702392578125 | -0.038543701171875 | 0.0819091796875 | 0.0599365234375 | 0.04534912109375 | 0.256103515625 | 0.0198974609375 | 0.002166748046875 | 0.00844573974609375 | 0.0153045654296875 | -0.000885009765625 | 0.0233612060546875 | 0.0638427734375 | 0.095703125 | ||||||
5 | A421A342-2706-4A6E-B993-38426E52421B | 2018-12-24T20:06:03+00:00 | [ "Museums", "Public" ] |
[] |
heic | 02e54839ec51f00bd8e4eaed08112c24b77cfedad2a2ea6563e421fcada75a44 | 1521065 | 45.20411333333333 | -123.14530833333333 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | McMinnville | OR | United States | A421A342-2706-4A6E-B993-38426E52421B | 0.47509765625 | 0.75 | 0.0 | 0.058016162621610946 | 0.10000000149011612 | -0.0010728836059570312 | 0.0234527587890625 | 0.001720428466796875 | 0.009999999776482582 | -0.172119140625 | -0.04046630859375 | 0.2279052734375 | 0.0035381317138671875 | -0.01519012451171875 | 0.004852294921875 | -0.03466796875 | 0.05120849609375 | 0.0616455078125 | 0.08056640625 | 0.0070037841796875 | -0.0078887939453125 | 0.0027790069580078125 | 0.23388671875 | 0.19970703125 | 0.09521484375 | 0.51953125 | 0.004180908203125 | |
233 | 8B27D87D-8FB6-4251-9E6A-68540AC7532B | 2018-12-24T01:08:03+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | 72dcc3993cdcaf43104031d23c42c5824186fbaa07b9bc5065422be1062b210d | 2738037 | 45.646233333333335 | -122.65947 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Vancouver | WA | United States | 8B27D87D-8FB6-4251-9E6A-68540AC7532B | 0.47265625 | 0.75 | 0.0 | 0.05802243066425542 | 0.10000000149011612 | -0.004573822021484375 | 0.025115966796875 | 0.0055999755859375 | 0.009999999776482582 | -0.9287109375 | -0.0258026123046875 | 0.014892578125 | 0.0028228759765625 | -0.00453948974609375 | -0.0038509368896484375 | 0.1556396484375 | -0.06219482421875 | 0.01467132568359375 | 0.0863037109375 | -0.021942138671875 | -0.0030155181884765625 | 0.00547027587890625 | 0.09124755859375 | 0.0240478515625 | 0.2088623046875 | 0.483642578125 | 0.00794219970703125 | |
316 | 1CCB0CD8-DDD9-40A5-AEBC-015C873A2A09 | 2018-09-04T15:40:35+00:00 | [ "Museums", "Public" ] |
[] |
heic | 9ab8a8f8d0d8d62ecf5411bdb5ed26b1e5b7fa9df793f0ff21f7080e0163eb64 | 1813574 | 50.656758333333336 | -4.251725 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Lifton | England | United Kingdom | 1CCB0CD8-DDD9-40A5-AEBC-015C873A2A09 | 0.390380859375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.07696533203125 | -0.000335693359375 | 0.004608154296875 | 0.009999999776482582 | -0.849609375 | -0.08062744140625 | -0.108642578125 | 0.049407958984375 | -0.07196044921875 | -0.044647216796875 | -0.5185546875 | -0.53076171875 | 0.0211639404296875 | -0.06842041015625 | -0.00606536865234375 | -0.01552581787109375 | 0.001483917236328125 | 0.007122039794921875 | -0.378173828125 | -0.017852783203125 | -0.19140625 | -0.0211181640625 | |
383 | 8A9FED20-BDE8-46E0-8583-C8FF1C7D3BFC | 2018-09-04T14:39:55+00:00 | [ "Museums", "Public" ] |
[] |
heic | bf353867bc1597a9f89dbc4de8af7d755095da20198147e47c69c35f6ebf0b36 | 1758797 | 50.656525 | -4.251916666666666 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Lifton | England | United Kingdom | 8A9FED20-BDE8-46E0-8583-C8FF1C7D3BFC | 0.403564453125 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.00555419921875 | 0.0181884765625 | 0.0021991729736328125 | 0.009999999776482582 | -0.20703125 | -0.05340576171875 | -0.00537109375 | 0.05780029296875 | -0.03240966796875 | -0.006561279296875 | -0.0440673828125 | -0.14306640625 | 0.0265045166015625 | 0.084228515625 | 0.00756072998046875 | -0.00572967529296875 | 0.00392913818359375 | 0.1265869140625 | 0.167724609375 | 0.06036376953125 | 0.489013671875 | 0.0262451171875 | |
419 | 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C | 2018-05-18T20:39:03+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | d4d2ad853a4bbb3b4ffd93c582b6567943b3edbc0daf7400754740b61b09a755 | 1884793 | 37.04161116666667 | -122.07271666666666 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Felton | CA | United States | 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C | 0.385009765625 | 0.75 | 0.0 | 0.05802466925091416 | 0.10000000149011612 | -0.0021572113037109375 | -0.0006103515625 | 0.0034160614013671875 | 0.009999999776482582 | -0.064208984375 | -0.09930419921875 | 0.287109375 | 0.004180908203125 | -0.016845703125 | -0.0426025390625 | -0.50341796875 | -0.06573486328125 | 0.1298828125 | -0.06414794921875 | -0.007534027099609375 | -0.0122222900390625 | 0.0013456344604492188 | 0.01177978515625 | 0.0101470947265625 | -0.53271484375 | -0.367919921875 | -0.1138916015625 | |
414 | FE1BAAE9-C33D-4933-88F0-9BCDA86F2D5B | 2018-05-10T23:39:54+00:00 | [ "Museums", "Public" ] |
[] |
heic | d0e381a36f050e4eaeb9530446058ff47fbbd42fe36d4c5bbfcea882000112e9 | 1255921 | -32.893811666666664 | -68.856545 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mendoza | Mendoza | Argentina | FE1BAAE9-C33D-4933-88F0-9BCDA86F2D5B | 0.3359375 | 0.75 | 0.0 | 0.05801526718694745 | 0.5042335987091064 | -0.0003669261932373047 | 0.13916015625 | 0.005641937255859375 | 0.009999999776482582 | 0.247314453125 | -0.006072998046875 | 0.31982421875 | 0.004150390625 | -0.006313323974609375 | 0.007152557373046875 | 0.3681640625 | 0.2174072265625 | 0.05499267578125 | 0.243896484375 | 0.059234619140625 | 0.004730224609375 | 0.0103302001953125 | 0.26171875 | 0.056427001953125 | 0.67626953125 | 0.77685546875 | 0.06890869140625 | |
429 | 3BE3193F-45AF-4787-B445-A6260393657C | 2018-02-20T23:18:32+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[] |
heic | d95f2e03676af786d523f3c360046daade8b99f2e3a69bdaa24c27b7467512ad | 5038686 | 37.742305 | -122.44933333333333 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | San Francisco | CA | United States | 3BE3193F-45AF-4787-B445-A6260393657C | 0.4404296875 | 0.75 | 0.0 | 0.05801952050159906 | 0.10000000149011612 | -0.0016937255859375 | 0.025726318359375 | 0.005161285400390625 | 0.009999999776482582 | 0.0986328125 | -0.134033203125 | -0.08038330078125 | 0.054901123046875 | -0.00971221923828125 | -0.021026611328125 | -0.12890625 | -0.1240234375 | 0.0153656005859375 | 0.198974609375 | 0.009490966796875 | -0.000732421875 | 0.00731658935546875 | 0.02880859375 | -0.0065765380859375 | -0.01116943359375 | 0.2578125 | 0.1834716796875 | |
491 | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 2018-02-20T23:04:00+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[] |
heic | fdc3052b1eb0fc7ebf3511145fa1744be8a22de793c74f9d89f98ffca730df5b | 1690162 | 37.74257166666666 | -122.44921166666667 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 0.529296875 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.001129150390625 | 0.0247955322265625 | 0.0087432861328125 | 0.009999999776482582 | 0.038818359375 | -0.07354736328125 | -0.028564453125 | 0.0169830322265625 | -0.01085662841796875 | -0.02056884765625 | 0.00927734375 | 0.0140380859375 | 0.0294189453125 | 0.26611328125 | 0.00890350341796875 | -0.00035858154296875 | 0.00916290283203125 | 0.02691650390625 | -0.004119873046875 | 0.0243988037109375 | 0.219970703125 | 0.1761474609375 | |
80 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 2018-02-20T22:52:16+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[] |
heic | 232c6b6414de60758ae544a8323123a9d651d32c0769f5ad9aa8533b8635051b | 1628032 | 37.742355 | -122.44944666666666 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 0.4873046875 | 0.75 | 0.0 | 0.05802354995758479 | 0.10000000149011612 | -0.0007977485656738281 | 0.04168701171875 | 0.0129241943359375 | 0.009999999776482582 | -0.1112060546875 | -0.0271759033203125 | 0.07489013671875 | 0.00844573974609375 | -0.00844573974609375 | -0.0066680908203125 | 0.165771484375 | 0.1026611328125 | 0.054290771484375 | 0.19189453125 | 0.0194854736328125 | -0.001277923583984375 | 0.012725830078125 | 0.046905517578125 | 0.00926971435546875 | 0.125244140625 | 0.337158203125 | 0.0272674560546875 | |
175 | 978E05B3-A903-4F27-A219-92603A4880B5 | 2018-02-20T22:37:35+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[] |
heic | 58aaabde35000d8e8e205450afb85f50f7aa66fcfe7ccd67fa873f6a1f32e60f | 1770398 | 37.742308333333334 | -122.44956166666667 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 978E05B3-A903-4F27-A219-92603A4880B5 | 0.470458984375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0018892288208007812 | 0.009368896484375 | 0.0017414093017578125 | 0.009999999776482582 | -0.03662109375 | -0.103759765625 | 0.056243896484375 | 0.0068511962890625 | -0.015899658203125 | -0.037567138671875 | -0.27294921875 | -0.12939453125 | 0.02947998046875 | 0.02142333984375 | 0.001251220703125 | -0.0097808837890625 | 0.002620697021484375 | 0.03656005859375 | -0.001678466796875 | -0.088623046875 | 0.303466796875 | 0.0738525390625 | |
413 | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 2018-02-20T22:16:37+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[] |
heic | d0d20aaa9ea3d8f1f7a5ceee5548a5545a35a00ba7503f80168dd5f65a903783 | 1481901 | 37.74236666666667 | -122.44930333333333 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 0.36376953125 | 0.75 | 0.0 | 0.05801526718694745 | 0.5043308734893799 | -0.0011920928955078125 | 0.028045654296875 | 0.00394439697265625 | 0.009999999776482582 | 0.51904296875 | -0.039642333984375 | -0.0184326171875 | 0.0164031982421875 | -0.0162811279296875 | -0.0003814697265625 | 0.305419921875 | 0.0206298828125 | 0.0170440673828125 | 0.26611328125 | 0.00893402099609375 | 0.001964569091796875 | 0.00948333740234375 | 0.09234619140625 | 0.0183258056640625 | 0.170654296875 | 0.6982421875 | 0.43212890625 | |
17 | AE5BD628-AB44-4D2F-A03F-88422F509482 | 2018-02-20T22:10:36+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[] |
heic | 097370f3405ad0e8a22a859ef107130273fd5fe2138128ffd6e7fc18c39fa000 | 1644874 | 37.742225 | -122.44941666666666 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | AE5BD628-AB44-4D2F-A03F-88422F509482 | 0.461669921875 | 0.75 | 0.0 | 0.05801526718694745 | 0.504501223564148 | -0.0012645721435546875 | 0.047088623046875 | 0.005279541015625 | 0.009999999776482582 | 0.197021484375 | -0.07904052734375 | 0.021148681640625 | 0.014007568359375 | -0.004451751708984375 | 0.0032806396484375 | 0.183837890625 | 0.1884765625 | 0.0261077880859375 | 0.34716796875 | 0.019775390625 | 0.0006866455078125 | 0.006168365478515625 | 0.1915283203125 | 0.32861328125 | 0.09649658203125 | 0.496826171875 | 0.1983642578125 | |
16 | C1858E6C-13BB-4C1B-A8AB-1A5B2129C19A | 2018-02-20T22:10:33+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[] |
heic | 087562510b302c2c3e8095b7e5ed455ff4b178e909ec46bde09d50c8500ec26d | 1743702 | 37.74223666666666 | -122.44941666666666 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | C1858E6C-13BB-4C1B-A8AB-1A5B2129C19A | 0.353759765625 | 0.75 | 0.0 | 0.05801526718694745 | 0.5041119456291199 | -0.0015249252319335938 | 0.0284576416015625 | 0.005062103271484375 | 0.009999999776482582 | 0.384765625 | -0.07489013671875 | -0.036285400390625 | 0.025909423828125 | -0.00908660888671875 | -0.00229644775390625 | 0.187744140625 | 0.02294921875 | 0.0174407958984375 | 0.23681640625 | 0.01068115234375 | 0.001995086669921875 | 0.00760650634765625 | 0.08404541015625 | 0.0736083984375 | 0.04827880859375 | 0.458984375 | 0.26806640625 | |
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
173 | 4E152F37-5FF2-43B0-BB98-FE9B6802BF55 | 2017-12-16T11:51:14+00:00 | [ "Public" ] |
[] |
heic | 57da25cee1c32557167b6d5458ac3ea56f683150c2611d6d8ad6a9b6dbb27276 | 2072848 | 51.503303333333335 | -0.1321805 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | London | England | United Kingdom | 4E152F37-5FF2-43B0-BB98-FE9B6802BF55 | 0.5703125 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0008358955383300781 | 0.032989501953125 | 0.00313568115234375 | 0.009999999776482582 | -0.45654296875 | -0.043121337890625 | 0.239501953125 | 0.0038547515869140625 | -0.00919342041015625 | -0.02197265625 | -0.1068115234375 | 0.0599365234375 | 0.09857177734375 | 0.10504150390625 | 0.00670623779296875 | -0.011199951171875 | 0.004467010498046875 | 0.097900390625 | 0.051239013671875 | 0.05975341796875 | 0.29052734375 | -8.392333984375e-05 | |
351 | 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 | 2017-12-03T22:40:16+00:00 | [ "Museums", "Public" ] |
[] |
heic | a99406f355b55e1d8c5bf18f8d85761ef703d75b862e715f9e9751c5e0a8bacd | 1734045 | 37.333511666666666 | -121.92306333333333 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Jose | CA | United States | 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 | 0.477294921875 | 0.75 | 0.0 | 0.058022878381587165 | 0.10000000149011612 | -0.0005526542663574219 | 0.027008056640625 | 0.0082855224609375 | 0.019999999552965164 | -0.37451171875 | -0.041778564453125 | 0.27587890625 | 0.004364013671875 | -0.006565093994140625 | -0.048553466796875 | -0.1864013671875 | -0.00262451171875 | 0.31640625 | 0.05841064453125 | 0.00191497802734375 | -0.0159454345703125 | 0.0174407958984375 | 0.0215301513671875 | 0.001140594482421875 | -0.11749267578125 | 0.0311279296875 | -0.0047607421875 | |
349 | 1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB | 2017-03-31T00:53:36+00:00 | [ "Stolen monasteries", "Public" ] |
[] |
jpeg | a93401fea4842b551132a24a707ae8e30d646d4830c5c32c3ce7c1ddcdd61bbc | 4502080 | 37.76918 | -122.46453833333334 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB | 0.5263671875 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.006122589111328125 | -0.00547027587890625 | 0.0029125213623046875 | 0.009999999776482582 | -0.5576171875 | -0.057373046875 | 0.273681640625 | 0.001956939697265625 | -0.0379638671875 | -0.159912109375 | -0.435791015625 | -0.146240234375 | 0.11676025390625 | -0.2406005859375 | -0.0036716461181640625 | -0.045989990234375 | 0.0017681121826171875 | 0.00930023193359375 | -0.03497314453125 | -0.2568359375 | -0.277587890625 | -0.07403564453125 | |
475 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 2015-12-18T13:39:58+00:00 | [ "Novelty Automation", "Museums", "Public" ] |
[] |
jpeg | f35f5580cec4289b90eb9ceebec27f017a5b5911a0b087d7e25efbf86a13b2d0 | 2073560 | 51.51998 | -0.11689166666666666 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | London | England | United Kingdom | 062B182C-CD24-4EC8-8E27-420EECB14688 | 0.33544921875 | 0.75 | 0.0 | 0.05801862506693556 | 0.50620436668396 | -0.00033283233642578125 | 0.044891357421875 | 0.0087432861328125 | 0.009999999776482582 | 0.45703125 | -0.047698974609375 | 0.134521484375 | 0.005344390869140625 | -0.004100799560546875 | 0.001739501953125 | 0.175048828125 | 0.1627197265625 | 0.04742431640625 | 0.1656494140625 | 0.015380859375 | 0.02105712890625 | 0.0125274658203125 | 0.043701171875 | 0.010101318359375 | -0.0157470703125 | 0.335693359375 | 0.1339111328125 |
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;