This data as json, CSV (advanced)
Suggested facets: date, albums, persons, ext, latitude, longitude, favorite, hdr, place_city, place_state_province, place_country, ZOVERALLAESTHETICSCORE, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZFAILURESCORE, ZIMMERSIVENESSSCORE, ZINTERACTIONSCORE, ZINTRUSIVEOBJECTPRESENCESCORE, ZLIVELYCOLORSCORE, ZNOISESCORE, ZPLEASANTPERSPECTIVESCORE, ZPLEASANTSYMMETRYSCORE, date (date), albums (array), persons (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
116 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 2019-09-16T16:27:24+00:00 | [ "Public" ] |
[ "_UNKNOWN_" ] |
heic | 38c5c9797285ca569d63a524a7a217b562c289e2b8068122e5dd7329348cfe4c | 1987600 | 37.449821666666665 | -122.18592 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Menlo Park | CA | United States | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 0.443115234375 | 0.75 | 0.0 | 0.9740458015380925 | 0.10000000149011612 | -0.000743865966796875 | 0.0360107421875 | 0.0125732421875 | 0.009999999776482582 | 0.1959228515625 | -0.08599853515625 | 0.06207275390625 | 0.020965576171875 | -0.00963592529296875 | -0.040130615234375 | -0.1871337890625 | 0.0689697265625 | 0.23583984375 | 0.19287109375 | 0.013458251953125 | -0.00125885009765625 | 0.0169219970703125 | 0.0169219970703125 | 0.00560760498046875 | -0.0806884765625 | -0.0244140625 | 0.116943359375 | |
282 | 7E07EFBF-1F63-4142-8856-7DCD9F906811 | 2019-09-14T16:27:56+00:00 | [ "Public" ] |
[ "_UNKNOWN_" ] |
heic | 86e8a0932628c6450de3649297ab0295831bb3963b186b262d8ff4bfdf9cfef0 | 1699486 | 29.941283333333335 | -90.07913883333333 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | New Orleans | LA | United States | 7E07EFBF-1F63-4142-8856-7DCD9F906811 | 0.361328125 | 0.75 | 0.0 | 0.05801526718694745 | 0.5045255422592163 | -0.0028228759765625 | 0.0236358642578125 | 0.002521514892578125 | 0.009999999776482582 | 0.42626953125 | -0.0970458984375 | -0.021026611328125 | 0.04168701171875 | -0.00844573974609375 | 0.00287628173828125 | 0.1065673828125 | 0.0474853515625 | 0.01049041748046875 | 0.16552734375 | 0.0140838623046875 | -7.2479248046875e-05 | 0.0039005279541015625 | 0.2330322265625 | 0.47900390625 | 0.10040283203125 | 0.71728515625 | 0.31689453125 | |
212 | 46BAA089-F20D-40E3-8161-5C0FA28FAA90 | 2019-09-11T16:31:25+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | 6952898f95114d886494ec5e9df99510a745a0d1ef1fef61d7d924234284f687 | 1910261 | 29.934663333333333 | -90.06162216666667 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | New Orleans | LA | United States | 46BAA089-F20D-40E3-8161-5C0FA28FAA90 | 0.57666015625 | 0.75 | 0.0 | 0.0580211847110559 | 0.10000000149011612 | -0.00044083595275878906 | 0.00860595703125 | 0.0017414093017578125 | 0.14000000059604645 | 0.34814453125 | -0.051177978515625 | 0.31787109375 | 0.0015125274658203125 | -0.01107025146484375 | 0.000823974609375 | -0.06640625 | -0.00482177734375 | 0.06878662109375 | -0.014892578125 | 0.00110626220703125 | -0.015899658203125 | 0.0032978057861328125 | 0.0634765625 | 0.028564453125 | -0.33447265625 | 0.505859375 | -0.003997802734375 | |
61 | 910061FF-8B93-4DF6-8580-F61F3AF655AC | 2019-08-24T12:37:43+00:00 | [ "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | 1cbea14450726bc646e838673ea29b8223c53c5d312f0a111c3be48a4a7e7e5a | 1385613 | 48.860908333333334 | 2.3425616666666667 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Paris | Île-de-France | France | 910061FF-8B93-4DF6-8580-F61F3AF655AC | 0.3134765625 | 0.75 | 0.0 | 0.8213740458129016 | 0.7066909670829773 | -0.0004093647003173828 | 0.09881591796875 | 0.002216339111328125 | 0.009999999776482582 | 0.8076171875 | -0.0236053466796875 | 0.1300048828125 | 0.01242828369140625 | -0.0027141571044921875 | 0.011077880859375 | 0.4990234375 | 0.466796875 | 0.0186920166015625 | 0.310302734375 | 0.064453125 | 0.0083770751953125 | 0.005062103271484375 | 0.78662109375 | 0.89404296875 | 0.48291015625 | 0.91259765625 | 0.58984375 | |
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 | |
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 | |
256 | 12AB4E54-7810-428D-A275-7CB631F2E33A | 2018-04-22T00:28:38+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_", "_UNKNOWN_" ] |
heic | 7d55d7d466216fbc80457ea3e500d95d876bd57e356d6cd1b286763c18830a3a | 1663615 | 37.579253333333334 | -122.34427833333334 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 12AB4E54-7810-428D-A275-7CB631F2E33A | 0.4423828125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.049224853515625 | 0.0011749267578125 | 0.00530242919921875 | 0.009999999776482582 | -0.5498046875 | -0.0706787109375 | -0.1641845703125 | 0.075439453125 | -0.18798828125 | -0.06243896484375 | -0.378173828125 | -0.595703125 | 0.022674560546875 | -0.04718017578125 | -0.002899169921875 | -0.0088348388671875 | 0.0022525787353515625 | 0.0029582977294921875 | -0.265625 | -0.010894775390625 | -0.1243896484375 | 0.035186767578125 | |
410 | F55C40DC-FF30-40F0-92BD-FBD1BD14B68B | 2018-04-22T00:18:11+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | ccd368e8a772e5ac1a2ebf1ddebf143dbd84c871ebaaedc39c24b4266ee08e7a | 1495272 | 37.57904666666667 | -122.34413833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | F55C40DC-FF30-40F0-92BD-FBD1BD14B68B | 0.1875 | 0.25 | 0.0 | 0.019847328255649742 | 0.10000000149011612 | -0.012054443359375 | -0.01104736328125 | 0.0017414093017578125 | 0.009999999776482582 | -0.1734619140625 | -0.09124755859375 | 0.07891845703125 | 0.010986328125 | -0.1014404296875 | -0.08251953125 | -0.462646484375 | -0.359130859375 | 0.07611083984375 | -0.150390625 | -0.00496673583984375 | -0.0238494873046875 | 0.0022335052490234375 | 0.007755279541015625 | -0.208251953125 | -0.61328125 | 0.0023193359375 | -0.1900634765625 | |
481 | 3CEC2620-AD7D-45EC-A746-FDCADB335D44 | 2018-04-22T00:17:38+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | f580d10cba72fc669695ff3085997ee5f65672ae53c3ef0af3d6fa9e6ce9f508 | 1111271 | 37.57918 | -122.34427 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 3CEC2620-AD7D-45EC-A746-FDCADB335D44 | 0.10760498046875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0048675537109375 | -0.0013580322265625 | 0.0026111602783203125 | 0.05999999865889549 | 0.0594482421875 | -0.04840087890625 | 0.0380859375 | 0.025421142578125 | -0.11553955078125 | -0.04345703125 | -0.164306640625 | -0.293212890625 | 0.13671875 | -0.05029296875 | -7.2479248046875e-05 | -0.016326904296875 | 0.007122039794921875 | 0.0154876708984375 | -0.04864501953125 | -0.261474609375 | 0.332275390625 | -0.03924560546875 | |
342 | E5CE20F5-1129-4B42-B765-D847EE083715 | 2018-04-22T00:15:27+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | a5e2d73b2ecb3c659734df6f3a73247ee4630cda0e44eade13e964894de7a03e | 695247 | 37.57915 | -122.3441 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | E5CE20F5-1129-4B42-B765-D847EE083715 | 0.354736328125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0029811859130859375 | -0.00356292724609375 | 0.003765106201171875 | 0.009999999776482582 | -0.5068359375 | -0.06512451171875 | 0.155029296875 | 0.0029239654541015625 | -0.027435302734375 | -0.134521484375 | -0.495849609375 | -0.180908203125 | 0.1697998046875 | -0.162353515625 | -0.0001468658447265625 | -0.0251922607421875 | 0.0031604766845703125 | 0.005889892578125 | -0.0141448974609375 | -0.1646728515625 | -0.341552734375 | -0.03619384765625 | |
315 | 9D1D2C1F-5BBF-4142-AABF-36F7DE028FA4 | 2018-04-22T00:15:18+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_", "_UNKNOWN_" ] |
heic | 99ce831cc3b5b6b9023d6175b29b6a234da11ec5f93beb38bc24d9d979f4d789 | 1660836 | 37.579175 | -122.34421666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 9D1D2C1F-5BBF-4142-AABF-36F7DE028FA4 | 0.370849609375 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0017681121826171875 | 0.00678253173828125 | 0.0013561248779296875 | 0.009999999776482582 | -0.24658203125 | -0.0560302734375 | 0.31787109375 | 0.0022258758544921875 | -0.0206451416015625 | -0.05078125 | -0.2069091796875 | -0.0521240234375 | 0.11614990234375 | -0.126220703125 | -0.00042724609375 | -0.046661376953125 | 0.0025806427001953125 | 0.072509765625 | 0.055511474609375 | -0.2056884765625 | 0.286376953125 | -0.03350830078125 | |
75 | C4953733-B5AE-4410-B654-834DABC67F07 | 2018-04-22T00:13:18+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | 2200c12e3a9702e7af07f66a41157f143b9441d5212bd6622b548c19064e3a6c | 1721928 | 37.579105 | -122.34422166666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | C4953733-B5AE-4410-B654-834DABC67F07 | 0.32861328125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.00621795654296875 | 0.000286102294921875 | 0.0015668869018554688 | 0.009999999776482582 | 0.0181884765625 | -0.0751953125 | 0.048980712890625 | 0.01363372802734375 | -0.130615234375 | -0.0806884765625 | -0.282958984375 | -0.25732421875 | 0.0384521484375 | -0.126220703125 | -0.0027008056640625 | -0.011932373046875 | 0.0015850067138671875 | 0.01422882080078125 | -0.0546875 | -0.243408203125 | 0.141357421875 | 0.03662109375 | |
94 | 11842992-CE7D-4301-9925-A29B440C9C0E | 2018-04-22T00:11:30+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_", "_UNKNOWN_" ] |
heic | 29d25816cf8e645abe0cc1d731d8ab025a67e89a5058a98452eb2247900b17b3 | 1607783 | 37.57924166666667 | -122.34418666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 11842992-CE7D-4301-9925-A29B440C9C0E | 0.414306640625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.006641387939453125 | 0.0281524658203125 | 0.0015306472778320312 | 0.009999999776482582 | 0.0723876953125 | -0.04803466796875 | 0.3828125 | 0.01132965087890625 | -0.0234222412109375 | -0.0240478515625 | -0.040771484375 | -0.181884765625 | 0.03125 | -0.04730224609375 | -0.005859375 | -0.13427734375 | 0.002323150634765625 | 0.06610107421875 | 0.042755126953125 | -0.17333984375 | 0.408935546875 | -0.0148162841796875 | |
439 | D6E497F5-7F93-4434-96D4-7927D358886A | 2018-04-22T00:11:18+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | decf63b8e7a30b93e080919d312b4d985736ca17678d96fa4fdd3ce81c84a721 | 1463975 | 37.57925 | -122.34418666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | D6E497F5-7F93-4434-96D4-7927D358886A | 0.331787109375 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0006289482116699219 | 0.033294677734375 | 0.0013942718505859375 | 0.009999999776482582 | 0.0574951171875 | -0.040771484375 | 0.29443359375 | 0.0038700103759765625 | -0.01107025146484375 | 0.030059814453125 | 0.014404296875 | 0.0875244140625 | 0.0965576171875 | 0.1214599609375 | 0.0136871337890625 | -0.009765625 | 0.0038394927978515625 | 0.333984375 | 0.30810546875 | 0.0755615234375 | 0.6279296875 | 0.008331298828125 | |
398 | 8338977E-56F0-4A7D-A6FD-33C2B27C9364 | 2018-04-22T00:09:15+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | c606432853e9ab78870a8e725fce86c80a79e443fa99313d69105bfe367a0ebb | 1643785 | 37.57917 | -122.344155 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 8338977E-56F0-4A7D-A6FD-33C2B27C9364 | 0.36279296875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0012941360473632812 | 0.027679443359375 | 0.0012941360473632812 | 0.019999999552965164 | -0.12005615234375 | -0.033203125 | 0.3701171875 | 0.0015306472778320312 | -0.00894927978515625 | 0.0038604736328125 | -0.0025634765625 | 0.030609130859375 | 0.054412841796875 | 0.017578125 | 0.00809478759765625 | -0.013641357421875 | 0.001628875732421875 | 0.26904296875 | 0.358642578125 | 0.220458984375 | 0.546875 | -0.00630950927734375 | |
324 | 63D46A8E-CB33-48E1-A6A6-662AF9AD922D | 2018-04-22T00:07:16+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | 9dbef4fb7519b183da13d3ce4beb757618271e8a3b5805186c71c661d8979557 | 1922748 | 37.57928 | -122.344095 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 63D46A8E-CB33-48E1-A6A6-662AF9AD922D | 0.343017578125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0009698867797851562 | 0.048065185546875 | 0.0038089752197265625 | 0.009999999776482582 | -0.1185302734375 | -0.0616455078125 | 0.208984375 | 0.01029205322265625 | -0.01132965087890625 | -0.01513671875 | -0.109130859375 | 0.07952880859375 | 0.1773681640625 | 0.173828125 | 0.0297088623046875 | -0.0113525390625 | 0.006565093994140625 | 0.1048583984375 | 0.1142578125 | 0.0379638671875 | 0.283447265625 | 0.007232666015625 | |
464 | 61A142C7-A526-4AE1-A1B5-C6FB3CE73EBC | 2018-04-22T00:00:15+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | e9ca2c634c5bd6c32b8b1eff0a8e907e16256a4245af095292831a5ba124ffa0 | 1480015 | 37.57921666666667 | -122.34423833333334 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 61A142C7-A526-4AE1-A1B5-C6FB3CE73EBC | 0.420166015625 | 0.25 | 0.0 | 0.019847328255649742 | 0.10000000149011612 | -0.0068511962890625 | 0.015228271484375 | 0.0059356689453125 | 0.009999999776482582 | -0.2369384765625 | -0.09124755859375 | -0.0821533203125 | 0.04107666015625 | -0.034027099609375 | -0.052093505859375 | -0.26123046875 | -0.32080078125 | 0.0325927734375 | 0.0858154296875 | 0.006381988525390625 | -0.004791259765625 | 0.004364013671875 | 0.01036834716796875 | -0.05767822265625 | 0.0079803466796875 | 0.0189208984375 | 0.0738525390625 | |
463 | 9C790AF0-D6F6-4CB6-8DB1-D74DF52754E5 | 2018-04-21T23:56:51+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | e9c9c3b5d9d960e1586c1d0751ef30220af107ae28de70ddc52c7da5b37e36db | 1870385 | 37.57906666666667 | -122.34423 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 9C790AF0-D6F6-4CB6-8DB1-D74DF52754E5 | 0.3544921875 | 0.6 | 0.0 | 0.04656488550755814 | 0.10000000149011612 | -0.0083770751953125 | 0.00119781494140625 | 0.004627227783203125 | 0.009999999776482582 | -0.49560546875 | -0.0994873046875 | -0.05328369140625 | 0.04742431640625 | -0.041534423828125 | -0.05999755859375 | -0.501953125 | -0.37744140625 | 0.18798828125 | -0.01983642578125 | 0.00074005126953125 | -0.01611328125 | 0.00815582275390625 | 0.01085662841796875 | -0.07183837890625 | -0.10101318359375 | -0.13720703125 | -0.015838623046875 | |
291 | C8CCC8EE-382E-4265-8236-E2F30764A55C | 2018-04-21T23:55:50+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | 8d0760a255defeab12023c2ad8704cab6b5bd9d20c69bd325ea242a6b22402a9 | 1719608 | 37.57926666666667 | -122.3442 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | C8CCC8EE-382E-4265-8236-E2F30764A55C | 0.2325439453125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0028228759765625 | -0.00146484375 | 0.0015306472778320312 | 0.03999999910593033 | 0.1011962890625 | -0.07305908203125 | 0.1485595703125 | 0.006511688232421875 | -0.046722412109375 | -0.03564453125 | -0.249755859375 | -0.18994140625 | 0.0582275390625 | -0.07696533203125 | -0.0020275115966796875 | -0.0162353515625 | 0.0019044876098632812 | 0.0194244384765625 | -0.01031494140625 | -0.405029296875 | 0.190185546875 | -0.0648193359375 | |
354 | A6C2C9FE-D032-450F-B0FC-AF6191226FA9 | 2018-02-20T23:15:38+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[ "_UNKNOWN_" ] |
heic | abb62ed287656b13ebdd9963dcb71d17831ccb5501f9523c0bfa2e556e8805c2 | 1898626 | 37.74283833333333 | -122.44926333333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | A6C2C9FE-D032-450F-B0FC-AF6191226FA9 | 0.50341796875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0165863037109375 | 0.020751953125 | 0.00646209716796875 | 0.009999999776482582 | -0.52392578125 | -0.09600830078125 | -0.0655517578125 | 0.039276123046875 | -0.01322174072265625 | -0.01092529296875 | -0.2071533203125 | -0.216064453125 | 0.0210113525390625 | 0.0928955078125 | 0.00466156005859375 | -0.0024623870849609375 | 0.0027904510498046875 | 0.049224853515625 | 0.1353759765625 | 0.01953125 | 0.07037353515625 | 0.038360595703125 | |
332 | 8D9702F9-ACED-47C4-B09C-19F9F72F17D4 | 2018-02-20T22:59:09+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[ "_UNKNOWN_" ] |
heic | a1c242e31c11211b88364db77fd8fb313aa9cdd5bbc4136c84731685c0763ecc | 1632132 | 37.742763333333336 | -122.44917166666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 8D9702F9-ACED-47C4-B09C-19F9F72F17D4 | 0.414306640625 | 0.5 | 0.0 | 0.8022900763472528 | 0.10000000149011612 | -0.00323486328125 | 0.0179290771484375 | 0.00926971435546875 | 0.009999999776482582 | -0.119873046875 | -0.08538818359375 | -0.0933837890625 | 0.020843505859375 | -0.015899658203125 | -0.0323486328125 | -0.0849609375 | -0.21923828125 | 0.024658203125 | 0.19921875 | 0.005413055419921875 | -0.001407623291015625 | 0.00800323486328125 | 0.0139007568359375 | -0.0426025390625 | 0.01751708984375 | 0.11553955078125 | 0.1260986328125 | |
108 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 2018-02-20T22:21:26+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[ "_UNKNOWN_" ] |
heic | 35466149067766d36bc97080600b0a469758eeab0b3eb1db2faf12a080486102 | 1814157 | 37.74257166666666 | -122.44925 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 0.2783203125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.00130462646484375 | 0.03997802734375 | 0.01049041748046875 | 0.009999999776482582 | 0.36865234375 | -0.07586669921875 | -0.04473876953125 | 0.01142120361328125 | -0.0103302001953125 | -0.03631591796875 | 0.1702880859375 | -0.0628662109375 | 0.0207977294921875 | 0.326171875 | 0.01084136962890625 | 0.00504302978515625 | 0.00864410400390625 | 0.016845703125 | -0.0132598876953125 | 0.038330078125 | 0.1710205078125 | 0.299560546875 | |
245 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 2018-02-20T22:07:06+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[ "_UNKNOWN_" ] |
heic | 78a1f825ca163f4213539e9b525ea2b144b36f0987592fde7ca24d3043d63fb5 | 1746321 | 37.742175 | -122.44953 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 0.4375 | 0.5 | 0.0 | 0.038931297721298594 | 0.704501211643219 | -0.0008625984191894531 | 0.0537109375 | 0.00243377685546875 | 0.009999999776482582 | 0.703125 | -0.030853271484375 | 0.0823974609375 | 0.011871337890625 | -0.0097808837890625 | 0.0075225830078125 | 0.32470703125 | 0.1927490234375 | 0.015899658203125 | 0.2098388671875 | 0.02374267578125 | 0.004673004150390625 | 0.00400543212890625 | 0.292724609375 | 0.306396484375 | 0.3408203125 | 0.78125 | 0.54736328125 | |
490 | FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 | 2018-02-20T22:06:28+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | fd1e5110743f0f83d37a120ca10b81f73f01b3858f7cd569bb16b2686ef329ca | 1544555 | 37.74218 | -122.449455 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 | 0.410400390625 | 0.5 | 0.0 | 0.038931297721298594 | 0.504355251789093 | -0.0009813308715820312 | 0.0352783203125 | 0.0033245086669921875 | 0.009999999776482582 | 0.5791015625 | -0.05072021484375 | 0.011474609375 | 0.01395416259765625 | -0.01090240478515625 | 0.0034027099609375 | 0.27734375 | 0.0919189453125 | 0.018768310546875 | 0.28759765625 | 0.01300048828125 | 0.001827239990234375 | 0.006984710693359375 | 0.1353759765625 | 0.0806884765625 | 0.176513671875 | 0.6982421875 | 0.464599609375 | |
478 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 2018-02-20T22:03:31+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[ "_UNKNOWN_" ] |
heic | f4a9910714b612db6be14d8250aaf6468e2baa81bbe7a3171ed5fe6e20bb5242 | 1580411 | 37.74218833333333 | -122.44960833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 0.4892578125 | 0.5 | 0.0 | 0.038931297721298594 | 0.5053771138191223 | -0.0009288787841796875 | 0.035919189453125 | 0.0027370452880859375 | 0.009999999776482582 | 0.380859375 | -0.0526123046875 | 0.118896484375 | 0.007232666015625 | -0.00937652587890625 | 0.009307861328125 | 0.09869384765625 | 0.156982421875 | 0.033721923828125 | 0.1531982421875 | 0.01126861572265625 | 0.000446319580078125 | 0.0031604766845703125 | 0.16015625 | 0.21435546875 | 0.137451171875 | 0.58447265625 | 0.38427734375 | |
121 | 76336F73-88DA-4E89-8E57-4A38FEA2986B | 2017-10-27T20:53:21+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | 39fd5df732f4fb55c94fc2d90bbe3abcf8e5a748d6b5800817d063c4f1a5e0c5 | 1735752 | 37.80936166666667 | -122.42176166666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 76336F73-88DA-4E89-8E57-4A38FEA2986B | 0.413818359375 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0007381439208984375 | 0.0229949951171875 | 0.0022258758544921875 | 0.009999999776482582 | -0.254638671875 | -0.0230255126953125 | 0.07403564453125 | 0.00905609130859375 | -0.01450347900390625 | 0.0073089599609375 | 0.19091796875 | 0.10369873046875 | 0.03436279296875 | 0.240478515625 | 0.0076141357421875 | -0.003936767578125 | 0.0083160400390625 | 0.33203125 | 0.13232421875 | 0.221435546875 | 0.76416015625 | 0.01605224609375 | |
470 | 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 | 2017-07-23T22:13:38+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
jpeg | edcd504a5dc67013013c8de46adbc2f586d9d56e572d634d594390fd81b20a95 | 2233683 | 37.84250333333333 | -122.27778666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Oakland | CA | United States | 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 | 0.405517578125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0017681121826171875 | -0.00296783447265625 | 0.0022258758544921875 | 0.009999999776482582 | -0.478271484375 | -0.06671142578125 | 0.252685546875 | 0.0009074211120605469 | -0.0202178955078125 | -0.118896484375 | -0.44580078125 | -0.0966796875 | 0.0823974609375 | -0.167724609375 | -0.0023097991943359375 | -0.034423828125 | 0.0016355514526367188 | 0.01061248779296875 | -0.007694244384765625 | -0.294677734375 | -0.1962890625 | -0.0555419921875 | |
432 | 69C46054-1D8F-4FD6-ABC7-2369C79921F4 | 2016-11-05T20:55:46+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
jpeg | d966b699790953594f2be6cc03c5e5b3d478ebf27122037a7dc022db7642411e | 2299000 | 37.828136666666666 | -122.52736666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Sausalito | CA | United States | 69C46054-1D8F-4FD6-ABC7-2369C79921F4 | 0.4814453125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0009508132934570312 | 0.047760009765625 | 0.05499267578125 | 0.009999999776482582 | -0.06640625 | -0.043701171875 | 0.10211181640625 | 0.0026111602783203125 | -0.004505157470703125 | -0.045806884765625 | 0.0196533203125 | 0.0323486328125 | 0.05194091796875 | 0.1417236328125 | 0.0133056640625 | 0.00213623046875 | 0.00971221923828125 | 0.00661468505859375 | -0.0017147064208984375 | -0.00029754638671875 | -0.0811767578125 | 0.0098724365234375 | |
240 | 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C | 2016-04-09T20:12:10+00:00 | [ "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
jpeg | 75d306a807f0c9b8a89eb726ca2ea4e226812e347ad1b70a0d7806ca2c9111c8 | 2689457 | 37.78550333333333 | -122.43043666666667 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | San Francisco | CA | United States | 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C | 0.486572265625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.004314422607421875 | -0.00701141357421875 | 0.002452850341796875 | 0.009999999776482582 | -0.121826171875 | -0.1026611328125 | 0.11175537109375 | 0.005619049072265625 | -0.0521240234375 | -0.133544921875 | -0.4990234375 | -0.270263671875 | 0.165283203125 | -0.1573486328125 | -0.0026302337646484375 | -0.0262451171875 | 0.0035381317138671875 | 0.00557708740234375 | -0.07470703125 | -0.5068359375 | -0.1641845703125 | -0.1171875 | |
346 | 9B076964-9931-4790-AE2D-A06011B97CE7 | 2016-04-09T20:12:10+00:00 | [ "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
jpeg | a7e181d3b3705db1b852705de9a92e0449fbb1b98b70e366bab316b554dafd6e | 2665460 | 37.78550333333333 | -122.43043666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 9B076964-9931-4790-AE2D-A06011B97CE7 | 0.434326171875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0014209747314453125 | 0.0190582275390625 | 0.0013408660888671875 | 0.009999999776482582 | 0.150634765625 | -0.06256103515625 | 0.31884765625 | 0.0022869110107421875 | -0.01666259765625 | -0.009002685546875 | -0.1044921875 | -0.00030517578125 | 0.0293121337890625 | -0.04010009765625 | 0.001861572265625 | -0.00848388671875 | 0.0009546279907226562 | 0.10015869140625 | 0.10113525390625 | -0.07080078125 | 0.4228515625 | 0.02374267578125 |
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;