photos_with_apple_metadata (view)

30 rows where persons contains "_UNKNOWN_" sorted by place_country

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, albums, persons, ext, latitude, longitude, favorite, place_city, place_state_province, place_country, ZOVERALLAESTHETICSCORE, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZFAILURESCORE, ZIMMERSIVENESSSCORE, ZINTERACTIONSCORE, ZINTRUSIVEOBJECTPRESENCESCORE, ZLIVELYCOLORSCORE, ZNOISESCORE, ZPLEASANTPERSPECTIVESCORE, ZPLEASANTSYMMETRYSCORE, date (date), albums (array)

hdr ✖

  • 0 29
  • 1 1

persons (array) ✖

  • _UNKNOWN_ · 46 ✖
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
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
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
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
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
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW photos_with_apple_metadata AS 
    select
        apple_photos.rowid,
        json_object(
            'img_src',
            'https://photos.simonwillison.net/i/' || uploads.sha256 || '.' || uploads.ext || '?w=600'
        ) as photo,
        apple_photos.uuid,
        apple_photos.date,
        apple_photos.albums,
        apple_photos.persons,
        uploads.ext,
        uploads.sha256,
        uploads.size,
        latitude,
        longitude,
        favorite,
        portrait,
        screenshot,
        slow_mo,
        time_lapse,
        hdr,
        selfie,
        panorama,
        place_city,
        place_state_province,
        place_country,
        apple_photos_scores.*
    from
        apple_photos
    join
        uploads on apple_photos.sha256 = uploads.sha256
    left join
        apple_photos_scores on apple_photos.uuid = apple_photos_scores.ZUUID
    order by
        apple_photos.date desc;
Powered by Datasette · Query took 792.044ms · About: dogsheep/dogsheep-photos