photos_with_apple_metadata (view)

35 rows where "date" is on date 2018-04-22

View and edit SQL

Suggested facets: persons, latitude, longitude, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, 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
85 AB43E9CF-7846-4218-AB2E-191D1BA9844E 2018-04-22T00:28:56+00:00
[
    "Museums",
    "Public"
]
[]
heic 2505fedb3a6c4adda57f5fafeeb29bbbe3447a7da7bf09c014addd6f79ba756e 1200228 37.57899666666667 -122.344155 0 0 0 0 0 0 0 0 Burlingame CA United States AB43E9CF-7846-4218-AB2E-191D1BA9844E 0.2392578125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0087432861328125 -0.003875732421875 0.0011968612670898438 0.009999999776482582 -0.47119140625 -0.08758544921875 0.234130859375 0.0017957687377929688 -0.04638671875 -0.11126708984375 -0.45068359375 -0.13720703125 0.04486083984375 -0.26708984375 -0.00777435302734375 -0.0256500244140625 0.0005702972412109375 0.02215576171875 -0.038177490234375 -0.321533203125 -0.126708984375 -0.12396240234375
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
83 59FDAA51-7EF2-4D97-A110-7A42FA8AC018 2018-04-22T00:19:14+00:00
[
    "Museums",
    "Public"
]
[]
heic 246821387b2f48b22aa5207af43e16cf8ce0745ae5c68b969804449ebdb0b410 1382543 37.57926666666667 -122.344155 0 0 0 0 0 0 0 0 Burlingame CA United States 59FDAA51-7EF2-4D97-A110-7A42FA8AC018 0.44775390625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00217437744140625 0.007617950439453125 0.00279998779296875 0.019999999552965164 0.0296630859375 -0.06707763671875 0.161865234375 0.005039215087890625 -0.02947998046875 -0.06591796875 -0.220458984375 -0.12347412109375 0.06634521484375 -0.047119140625 0.000492095947265625 -0.016754150390625 0.0034027099609375 0.0193023681640625 -0.02313232421875 -0.205810546875 0.237060546875 0.01519775390625
183 2B9169E5-91EE-4E3C-8B1D-DAFF93D38079 2018-04-22T00:19:03+00:00
[
    "Museums",
    "Public"
]
[]
heic 5a49d99dca4b4f1b4838d83ab1b8544b00c59242fda2d05092208ba0fb0fce77 649257 37.579258333333335 -122.34417833333333 0 0 0 0 0 0 0 0 Burlingame CA United States 2B9169E5-91EE-4E3C-8B1D-DAFF93D38079 0.443359375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00128936767578125 0.01422882080078125 0.0014896392822265625 0.009999999776482582 -0.364990234375 -0.06549072265625 0.05987548828125 0.010009765625 -0.0121917724609375 -0.009185791015625 -0.06787109375 -0.0714111328125 0.03948974609375 0.119384765625 0.00177764892578125 -0.017974853515625 0.007175445556640625 0.17041015625 0.0899658203125 0.02398681640625 0.697265625 0.01007843017578125
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
289 277756C5-6924-4E30-877D-CD2CE30630FD 2018-04-22T00:17:52+00:00
[
    "Museums",
    "Public"
]
[]
heic 8badd750c2e09ba7e96fe2d48833f66990b14e348cda9269ebd0444d6694b2af 1177569 37.579096666666665 -122.34413833333333 0 0 0 0 0 0 0 0 Burlingame CA United States 277756C5-6924-4E30-877D-CD2CE30630FD 0.266357421875 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.003795623779296875 -0.0030517578125 0.0010366439819335938 0.009999999776482582 -0.449951171875 -0.03875732421875 0.1923828125 0.00323486328125 -0.07781982421875 -0.06396484375 -0.1732177734375 -0.1572265625 0.07476806640625 -0.1436767578125 -0.00726318359375 -0.03466796875 0.0022602081298828125 0.035736083984375 -0.0068206787109375 -0.1612548828125 0.345703125 -0.03826904296875
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
356 F3DAB898-0907-410B-B796-9999D8E773A7 2018-04-22T00:15:46+00:00
[
    "Museums",
    "Public"
]
[]
heic ad9ef159b032c9390823705c5c527212864618c1f40128d3684b850dd5a27f96 857241 37.57923666666667 -122.34424666666666 0 0 0 0 0 0 0 0 Burlingame CA United States F3DAB898-0907-410B-B796-9999D8E773A7 0.322998046875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0035114288330078125 0.01099395751953125 0.0016546249389648438 0.009999999776482582 0.367431640625 -0.06573486328125 0.036834716796875 0.0202178955078125 -0.0823974609375 -0.026947021484375 -0.09014892578125 -0.134521484375 0.0221099853515625 0.0318603515625 0.001338958740234375 -0.00354766845703125 0.001934051513671875 0.037811279296875 -0.01739501953125 -0.032958984375 0.427734375 0.456298828125
387 7A635293-467F-4C79-A04D-68A1C0250EB7 2018-04-22T00:15:41+00:00
[
    "Museums",
    "Public"
]
[]
heic c2d8185df63eb139b856d3af911ee0006353b369ca2c37fc5983b4bfd073e700 821992 37.579195 -122.34418666666667 0 0 0 0 0 0 0 0 Burlingame CA United States 7A635293-467F-4C79-A04D-68A1C0250EB7 0.38720703125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0255584716796875 -0.002437591552734375 0.0027675628662109375 0.009999999776482582 -0.60009765625 -0.060089111328125 -0.1300048828125 0.034942626953125 -0.1910400390625 -0.08111572265625 -0.3076171875 -0.5458984375 0.03265380859375 -0.103759765625 -0.002201080322265625 -0.0175628662109375 0.004886627197265625 0.012054443359375 -0.27099609375 -0.03704833984375 0.268310546875 -0.0233612060546875
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
156 EAA0FF98-970A-42AA-9938-75D632855967 2018-04-22T00:13:03+00:00
[
    "Museums",
    "Public"
]
[]
heic 4b71652896076d2275b7de1855133d12f0e83e72e3f2df5eebccd312ee7801b2 1878279 37.5793 -122.34407833333333 0 0 0 0 0 0 0 0 Burlingame CA United States EAA0FF98-970A-42AA-9938-75D632855967 0.22021484375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0008726119995117188 0.0216522216796875 0.004665374755859375 0.009999999776482582 -0.7421875 -0.0177764892578125 0.07159423828125 0.002704620361328125 -0.00577545166015625 -0.000347137451171875 0.2333984375 0.09246826171875 0.0205230712890625 0.12335205078125 -0.00478363037109375 -0.0034275054931640625 0.008575439453125 0.1749267578125 0.048919677734375 0.32470703125 0.72216796875 0.01009368896484375
169 EDD0562E-B010-44B3-9AA8-509F494351E1 2018-04-22T00:12:02+00:00
[
    "Museums",
    "Public"
]
[]
heic 55a68d0f58176b06688b769b6be687ac460615526ed1d52affde448f153bba50 1024968 37.57923666666667 -122.34407 0 0 0 0 0 0 0 0 Burlingame CA United States EDD0562E-B010-44B3-9AA8-509F494351E1 0.272216796875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00806427001953125 -0.00696563720703125 0.0023136138916015625 0.009999999776482582 -0.1865234375 -0.09136962890625 0.036529541015625 0.0190582275390625 -0.0872802734375 -0.07037353515625 -0.467529296875 -0.372314453125 0.133544921875 -0.09869384765625 -0.002712249755859375 -0.031402587890625 0.00323486328125 0.0060272216796875 -0.0687255859375 -0.426513671875 -0.1707763671875 -0.10101318359375
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
474 8800AD7C-B9A7-4EC9-B543-8CC8892258F1 2018-04-22T00:11:22+00:00
[
    "Museums",
    "Public"
]
[]
heic f2c7ee07ea7696e0578ff14d4b87dd76508999d46d251effe98dd0fa2093f429 1483372 37.57924166666667 -122.34420833333333 0 0 0 0 0 0 0 0 Burlingame CA United States 8800AD7C-B9A7-4EC9-B543-8CC8892258F1 0.327392578125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.002414703369140625 -0.00057220458984375 0.0016546249389648438 0.009999999776482582 -0.30322265625 -0.090576171875 0.1556396484375 0.004573822021484375 -0.0360107421875 -0.1617431640625 -0.436767578125 -0.183349609375 0.146728515625 -0.2203369140625 -0.0005512237548828125 -0.0244903564453125 0.0032863616943359375 0.018585205078125 -0.017364501953125 -0.263916015625 -0.011474609375 -0.04461669921875
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
125 CC3EF420-EAC4-4661-8D68-C2009F892C04 2018-04-22T00:11:12+00:00
[
    "Museums",
    "Public"
]
[]
heic 3b435a93ced7320d53ff8a654508641529d82949253df7256c3baeb6a919385d 1565205 37.57926666666667 -122.34417 0 0 0 0 0 0 0 0 Burlingame CA United States CC3EF420-EAC4-4661-8D68-C2009F892C04 0.23974609375 0.5 0.0 0.038931297721298594 0.5029440522193909 -0.0008831024169921875 0.11505126953125 0.00395965576171875 0.019999999552965164 0.0281982421875 -0.0225067138671875 0.27880859375 0.01009368896484375 -0.0069580078125 0.039337158203125 0.1673583984375 0.260498046875 0.1424560546875 0.36865234375 0.142822265625 -0.00147247314453125 0.00600433349609375 0.501953125 0.66943359375 0.48828125 0.607421875 0.0160064697265625
392 2072695E-48EC-4C6E-9AFE-61F6590F67D5 2018-04-22T00:10:18+00:00
[
    "Museums",
    "Public"
]
[]
heic c51fccdae579f930cf5e5523b5dd56c5e35900718a323b2451014d6c6b01ba42 1310899 37.57915 -122.3441 0 0 0 0 0 0 0 0 Burlingame CA United States 2072695E-48EC-4C6E-9AFE-61F6590F67D5 0.340576171875 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.00443267822265625 -0.00213623046875 0.0015916824340820312 0.009999999776482582 -0.85986328125 -0.03253173828125 0.2386474609375 0.0009365081787109375 -0.022247314453125 -0.043243408203125 -0.1949462890625 -0.1187744140625 0.07342529296875 -0.06146240234375 -0.0161895751953125 -0.0694580078125 0.001956939697265625 0.02508544921875 0.0008697509765625 0.0228271484375 0.1063232421875 -0.014068603515625
274 E50B8F10-65AB-4938-AC6C-C8C35EB1C08C 2018-04-22T00:10:07+00:00
[
    "Museums",
    "Public"
]
[]
heic 8433d50000ebdf053b128c12d529091ee99a847d47e0d6317c002969b5406fed 2209010 37.57922 -122.34410833333334 0 0 0 0 0 0 0 0 Burlingame CA United States E50B8F10-65AB-4938-AC6C-C8C35EB1C08C 0.382080078125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004364013671875 -0.00274658203125 0.0011339187622070312 0.009999999776482582 -0.724609375 -0.03436279296875 0.255615234375 0.0015430450439453125 -0.04595947265625 -0.07611083984375 -0.2100830078125 -0.1217041015625 0.07965087890625 -0.164306640625 -0.0077056884765625 -0.035980224609375 0.0015430450439453125 0.03314208984375 0.0018310546875 -0.0218505859375 0.1365966796875 -0.025054931640625
3 625815AF-B061-4180-BFC5-CAC29E4C6C00 2018-04-22T00:09:55+00:00
[
    "Museums",
    "Public"
]
[]
heic 026d54092af52aaf23fc7e1ed1c3c8077e7216791f262bbd80bf3d088dff4189 1858021 37.57933333333333 -122.34430833333333 0 0 0 0 0 0 0 0 Burlingame CA United States 625815AF-B061-4180-BFC5-CAC29E4C6C00 0.26025390625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0023975372314453125 0.019317626953125 0.006877899169921875 0.009999999776482582 -0.95849609375 -0.013427734375 0.1240234375 0.0006093978881835938 -0.00399017333984375 -0.0031070709228515625 0.12335205078125 0.0186767578125 0.01678466796875 0.05133056640625 -0.034423828125 -0.003108978271484375 0.003650665283203125 0.0794677734375 0.0251922607421875 0.23486328125 0.36328125 0.002391815185546875
471 F5B3B67A-BE7F-4138-847F-A985B790A1D8 2018-04-22T00:09:26+00:00
[
    "Museums",
    "Public"
]
[]
heic ee05096b1dc7fa7fd6edc60c359f64e39652dff2b649169295cd2851fd1534f4 1519197 37.57923 -122.34417833333333 0 0 0 0 0 0 0 0 Burlingame CA United States F5B3B67A-BE7F-4138-847F-A985B790A1D8 0.37353515625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.002132415771484375 0.0230255126953125 0.006565093994140625 0.009999999776482582 -0.95654296875 -0.01490020751953125 0.1636962890625 0.0006070137023925781 -0.003376007080078125 -0.0041961669921875 0.087890625 0.0185546875 0.0226287841796875 0.050140380859375 -0.03076171875 -0.003383636474609375 0.0035648345947265625 0.0706787109375 0.022705078125 0.1737060546875 0.287353515625 0.0017080307006835938
319 2FBB5984-3AAC-4565-9233-9B05EF887714 2018-04-22T00:09:19+00:00
[
    "Museums",
    "Public"
]
[]
heic 9bfa1e978780e33d9a9f007e41b3a57f6b57f2cfe5c9a5dff2486a1ccbd1d68d 1272884 37.579208333333334 -122.34419166666666 0 0 0 0 0 0 0 0 Burlingame CA United States 2FBB5984-3AAC-4565-9233-9B05EF887714 0.4208984375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.10968017578125 -0.01126861572265625 0.0083770751953125 0.009999999776482582 -0.4384765625 -0.077392578125 -0.07342529296875 0.03912353515625 -0.236572265625 -0.06561279296875 -0.578125 -0.57568359375 0.07489013671875 -0.11090087890625 -0.004486083984375 -0.012664794921875 0.002208709716796875 0.0013303756713867188 -0.6240234375 -0.270751953125 -0.458740234375 -0.2105712890625
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
333 74FF69CF-A6F6-42CA-A2C1-1FBBB4F22EEC 2018-04-22T00:09:10+00:00
[
    "Museums",
    "Public"
]
[]
heic a1c2d7f8756e2101b0239087ebb5d55c79665b49f2e5800fd492e41afa56e8ba 1348018 37.579005 -122.344155 0 0 0 0 0 0 0 0 Burlingame CA United States 74FF69CF-A6F6-42CA-A2C1-1FBBB4F22EEC 0.336181640625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0013408660888671875 0.0460205078125 0.00714874267578125 0.009999999776482582 -0.91552734375 -0.01094818115234375 0.233154296875 0.0013990402221679688 -0.0037212371826171875 -0.003269195556640625 0.16455078125 0.0635986328125 0.07611083984375 0.074462890625 -0.036651611328125 -0.0025501251220703125 0.007724761962890625 0.0885009765625 0.035003662109375 0.19482421875 0.328857421875 0.0035648345947265625
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
311 01FA701A-92D3-4818-934F-50FA0562366C 2018-04-22T00:05:51+00:00
[
    "Museums",
    "Public"
]
[]
heic 96fb0f6d09e9f87f06302d22cf26737a25371c0c18822ca26c593820c668a15e 1098048 37.57925 -122.34414666666666 0 0 0 0 0 0 0 0 Burlingame CA United States 01FA701A-92D3-4818-934F-50FA0562366C 0.2005615234375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0199127197265625 -0.001682281494140625 0.0020198822021484375 0.009999999776482582 -0.62646484375 -0.093017578125 -0.0875244140625 0.03533935546875 -0.09088134765625 -0.07763671875 -0.431640625 -0.4853515625 0.045196533203125 -0.1025390625 -0.002063751220703125 -0.023529052734375 0.00428009033203125 0.02215576171875 -0.2459716796875 -0.09869384765625 0.213134765625 -0.024993896484375
263 0EC5864B-16CC-4B6C-B890-330ADF4998BD 2018-04-22T00:05:41+00:00
[
    "Museums",
    "Public"
]
[]
heic 7f541fc393d29c06197b005642f20cbc519a3b2eedb36eb33aeedb64fec2a9a4 1547943 37.57927166666666 -122.34417 0 0 0 0 0 0 0 0 Burlingame CA United States 0EC5864B-16CC-4B6C-B890-330ADF4998BD 0.12451171875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.003765106201171875 0.008758544921875 0.0016422271728515625 0.009999999776482582 -0.1055908203125 -0.080078125 0.202392578125 0.00679779052734375 -0.0211181640625 -0.021209716796875 -0.2249755859375 -0.0849609375 0.0831298828125 -0.0423583984375 -0.0029449462890625 -0.016387939453125 0.0023975372314453125 0.08416748046875 0.1640625 -0.219482421875 0.373046875 -0.02490234375
292 9FA3546D-056E-4B3F-BBAC-AD74DEA303C4 2018-04-22T00:04:35+00:00
[
    "Museums",
    "Public"
]
[]
heic 8d672867493a2635c0ce87db82e6bb9558101a21240edf4046975c067f2c7ccf 977952 37.57924666666667 -122.344155 0 0 0 0 0 0 0 0 Burlingame CA United States 9FA3546D-056E-4B3F-BBAC-AD74DEA303C4 0.321533203125 0.5 0.0 0.038931297721298594 0.5035279989242554 -0.0008831024169921875 0.027801513671875 0.0017070770263671875 0.009999999776482582 0.28515625 -0.0247039794921875 0.1964111328125 0.00605010986328125 -0.0131683349609375 0.01238250732421875 0.126220703125 0.086181640625 0.06793212890625 0.0987548828125 0.015655517578125 -0.003993988037109375 0.004924774169921875 0.382080078125 0.468017578125 0.25732421875 0.76025390625 0.03424072265625
265 B95E6DC5-8DFC-4B5B-86DC-68D7616C8C0E 2018-04-22T00:04:28+00:00
[
    "Museums",
    "Public"
]
[]
heic 7ff235acd3b220a7af4ba71085813dcdce87ec322760ed6582ce5e4b4fb3230c 816374 37.57928 -122.34413833333333 0 0 0 0 0 0 0 0 Burlingame CA United States B95E6DC5-8DFC-4B5B-86DC-68D7616C8C0E 0.312255859375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0012998580932617188 0.0130767822265625 0.0015974044799804688 0.009999999776482582 -0.0648193359375 -0.0279083251953125 0.3154296875 0.0017547607421875 -0.0207672119140625 -0.0150146484375 -0.02239990234375 -0.03936767578125 0.07696533203125 -0.02813720703125 0.003704071044921875 -0.0173797607421875 0.003223419189453125 0.09466552734375 0.042572021484375 0.090087890625 0.52490234375 -0.01253509521484375
71 545CBF13-E5F7-4578-91E5-9CA7B023C4C5 2018-04-22T00:03:54+00:00
[
    "Museums",
    "Public"
]
[]
heic 20691171064e414f4bfd70079cbf95f8e0fd8e2ab16607a9e42cf54dfe9ef556 1917741 37.579186666666665 -122.34416166666666 0 0 0 0 0 0 0 0 Burlingame CA United States 545CBF13-E5F7-4578-91E5-9CA7B023C4C5 0.27587890625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0015850067138671875 0.0015106201171875 0.0026416778564453125 0.009999999776482582 0.0125732421875 -0.049224853515625 0.2352294921875 0.00524139404296875 -0.0283355712890625 -0.026763916015625 -0.180908203125 -0.09490966796875 0.1695556640625 -0.0295867919921875 -0.003448486328125 -0.0282135009765625 0.004791259765625 0.019561767578125 0.0013427734375 -0.396728515625 0.2037353515625 -0.0394287109375
42 E7C46C63-F84B-4535-86A7-A5028CC63E4B 2018-04-22T00:03:12+00:00
[
    "Museums",
    "Public"
]
[]
heic 15b45da65030853a16ffc5e9a54b126d8e1929e82845475fd96f7cf4459758b6 2320879 37.57927 -122.34416166666666 0 0 0 0 0 0 0 0 Burlingame CA United States E7C46C63-F84B-4535-86A7-A5028CC63E4B 0.36865234375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00518035888671875 0.01081085205078125 0.004924774169921875 0.009999999776482582 -0.9609375 -0.0221099853515625 0.053680419921875 0.0009508132934570312 -0.0069580078125 -0.00634002685546875 0.0328369140625 -0.09417724609375 0.012969970703125 0.037017822265625 -0.029510498046875 -0.00531768798828125 0.003223419189453125 0.051177978515625 -0.01397705078125 0.2305908203125 0.384765625 0.0015316009521484375
484 75D227E6-3F2B-41A8-9977-E9B55255C861 2018-04-22T00:03:04+00:00
[
    "Museums",
    "Public"
]
[]
heic f8daca217ac8cad995c653260c325158ac80e59e5379ab8be5c339a304cd3378 1924547 37.57926166666667 -122.34416166666666 0 0 0 0 0 0 0 0 Burlingame CA United States 75D227E6-3F2B-41A8-9977-E9B55255C861 0.17236328125 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.00536346435546875 0.003108978271484375 0.004718780517578125 0.009999999776482582 -0.2900390625 -0.139892578125 -0.10870361328125 0.0699462890625 -0.03338623046875 -0.060302734375 -0.52392578125 -0.42333984375 0.15771484375 0.0250244140625 0.0015716552734375 -0.01311492919921875 0.0117340087890625 0.009521484375 -0.08758544921875 -0.118408203125 -0.0535888671875 0.0139007568359375
486 5A10AEF0-50DA-41BE-80F2-79E3367C343E 2018-04-22T00:02:59+00:00
[
    "Museums",
    "Public"
]
[]
heic fa48b9304c0a1de7f0cc8a3512c76452dc458964ea0394ea346740ed8b71eee9 1657904 37.579253333333334 -122.34418666666667 0 0 0 0 0 0 0 0 Burlingame CA United States 5A10AEF0-50DA-41BE-80F2-79E3367C343E 0.364501953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.005428314208984375 -0.009002685546875 0.0024242401123046875 0.019999999552965164 -0.136962890625 -0.06658935546875 0.1895751953125 0.00661468505859375 -0.07861328125 -0.124267578125 -0.375244140625 -0.223388671875 0.31005859375 -0.18896484375 -0.0026531219482421875 -0.03070068359375 0.0036067962646484375 0.007518768310546875 -0.0423583984375 -0.465576171875 -0.2138671875 -0.1270751953125
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

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