photos_with_apple_metadata (view)

30 rows where panorama = 0, persons contains "_UNKNOWN_" and screenshot = 0

View and edit SQL

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

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 704.398ms · About: dogsheep/dogsheep-photos