photos_with_apple_metadata (view)

35 rows where "date" is on date 2018-04-22 sorted by ZIMMERSIVENESSSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: persons, latitude, longitude, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, albums (array), persons (array)

date (date) ✖

  • 2018-04-22 · 35 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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