photos_with_apple_metadata (view)

128 rows where ext = "heic", favorite = 0 and hdr = 0

✎ View and edit SQL

This data as json, CSV (advanced)

panorama ✖

  • 0 127
  • 1 1

hdr ✖

favorite ✖

ext ✖

  • heic · 128 ✖
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
133 1C4D17B1-29D7-42D3-BB59-DBBFA42AA9D0 2018-02-20T22:05:11+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 3cb0c61cacd8c727a5faa98a5ad09f5356d85a069a57e001e0cb016cd0355f81 1652414 37.74209666666667 -122.44973 0 0 0 0 0 0 0 0 San Francisco CA United States 1C4D17B1-29D7-42D3-BB59-DBBFA42AA9D0 0.375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0018463134765625 0.0224456787109375 0.0029926300048828125 0.009999999776482582 -0.027099609375 -0.053009033203125 0.00555419921875 0.0261993408203125 -0.00905609130859375 0.003292083740234375 0.1695556640625 0.0897216796875 0.02508544921875 0.171142578125 0.0092010498046875 -0.00160980224609375 0.00690460205078125 0.303955078125 0.486572265625 0.1103515625 0.6923828125 0.06658935546875
473 FFD294F1-59BE-4B75-9180-B6318671CDEC 2018-02-20T22:04:47+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic f1a8c47ca43ab24da4754290585aa10c74478d419b46faf2b232dbb086250d43 1162677 37.742145 -122.44979666666667 0 0 0 0 0 0 0 0 San Francisco CA United States FFD294F1-59BE-4B75-9180-B6318671CDEC 0.463134765625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0136871337890625 0.0124969482421875 0.005641937255859375 0.009999999776482582 -0.440673828125 -0.2271728515625 -0.118408203125 0.0216522216796875 -0.01262664794921875 -0.07830810546875 -0.51513671875 -0.475830078125 0.0117340087890625 0.0494384765625 0.001789093017578125 -0.0160064697265625 0.0021572113037109375 0.006072998046875 -0.148681640625 -0.00510406494140625 -0.097412109375 0.07403564453125
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
88 3545F3EF-615B-4178-A146-9121E629DE90 2018-02-20T22:02:41+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 26182a120397f6155813253973ad3175e5e2e2643ccb5031114e48444c1c0825 1494211 37.74209666666667 -122.4495 0 0 0 0 0 0 0 0 San Francisco CA United States 3545F3EF-615B-4178-A146-9121E629DE90 0.349853515625 0.5 0.0 0.038931297721298594 0.504501223564148 -0.0006852149963378906 0.05523681640625 0.006587982177734375 0.009999999776482582 0.59423828125 -0.048126220703125 0.008148193359375 0.0143890380859375 -0.00518035888671875 0.002593994140625 0.395751953125 0.2236328125 0.018402099609375 0.327880859375 0.017364501953125 0.004184722900390625 0.00821685791015625 0.11798095703125 0.0850830078125 0.09222412109375 0.499267578125 0.44140625
450 C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 2018-02-20T22:00:16+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic e44b486d52db2e217048ed0d74423b7097f6165d700e845286db00a3993df8e2 1465931 37.742266666666666 -122.44943833333333 0 0 0 0 0 0 0 0 San Francisco CA United States C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 0.395263671875 0.5 0.0 0.038931297721298594 0.5044769048690796 -0.00127410888671875 0.033477783203125 0.0022525787353515625 0.009999999776482582 0.59814453125 -0.06890869140625 0.02435302734375 0.01262664794921875 -0.00841522216796875 0.00350189208984375 0.2041015625 0.0726318359375 0.01525115966796875 0.22119140625 0.00998687744140625 0.00150299072265625 0.00441741943359375 0.164794921875 0.1859130859375 0.1431884765625 0.7177734375 0.55810546875
26 B19BB608-7B37-4094-AE9B-504B13660278 2018-01-14T23:22:43+00:00 
[
    "Public"
]
 
[]
 heic 0ecd701f9983b7f759eab2d53911b05de86cf0dfcde086d85c480c70cc8b8f43 3510677 37.76555333333334 -122.440025 0 0 0 0 0 0 0 0 San Francisco CA United States B19BB608-7B37-4094-AE9B-504B13660278 0.3291015625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0016231536865234375 0.041717529296875 0.0011377334594726562 0.03999999910593033 -0.0711669921875 -0.0386962890625 0.30029296875 0.005199432373046875 -0.0154266357421875 0.0089111328125 0.0123291015625 0.0244140625 0.0794677734375 0.08740234375 0.020721435546875 -0.0150146484375 0.00274658203125 0.324462890625 0.397705078125 0.28076171875 0.62158203125 0.00057220458984375
480 E1468521-C7AB-4BA9-B4A9-D136FC9D4958 2017-12-16T11:52:26+00:00 
[
    "Public"
]
 
[]
 heic f574eaa689ab82870f62f702593725ed4a8e7a9f6c67a1ba31c79d57089f9e62 2274468 51.5034 -0.13202216666666666 0 0 0 0 0 0 0 0 London England United Kingdom E1468521-C7AB-4BA9-B4A9-D136FC9D4958 0.6083984375 0.5 0.0 0.04200813515495708 0.10000000149011612 -0.00974273681640625 0.00029754638671875 0.0013513565063476562 0.019999999552965164 -0.35498046875 -0.07879638671875 0.183349609375 0.004486083984375 -0.08526611328125 -0.072021484375 -0.189697265625 -0.219970703125 0.0309600830078125 -0.11846923828125 -0.09161376953125 -0.03326416015625 0.0009851455688476562 0.0284881591796875 -0.07403564453125 -0.1715087890625 0.30859375 -0.041015625
317 0D23847A-0863-4F18-938A-9839C8E28B91 2017-12-16T11:52:19+00:00 
[
    "Public"
]
 
[]
 heic 9ae44af9c6d663d44e03539a41fed0bb4679519f542ba99439f00a44a22d262c 2126432 51.5034 -0.132025 0 0 0 0 0 0 0 0 London England United Kingdom 0D23847A-0863-4F18-938A-9839C8E28B91 0.65576171875 0.5 0.0 0.04200813515495708 0.5031630396842957 -0.0005359649658203125 0.145263671875 0.0312042236328125 0.009999999776482582 0.46923828125 -0.038604736328125 0.1214599609375 0.0169219970703125 -0.0041351318359375 -0.0017242431640625 0.31689453125 0.330810546875 0.0548095703125 0.306884765625 0.0665283203125 0.01551055908203125 0.01262664794921875 0.034759521484375 0.0131072998046875 0.050567626953125 0.1435546875 0.239990234375
489 B78C4087-CE43-411C-AEAF-16C585DF6D67 2017-12-16T11:52:17+00:00 
[
    "Public"
]
 
[]
 heic fb7c3040191817d74897ed937836a9993cf3759f84a3bd4662f474c3635ec19a 2091779 51.5034 -0.13202783333333332 0 0 0 0 0 0 0 0 London England United Kingdom B78C4087-CE43-411C-AEAF-16C585DF6D67 0.71337890625 0.5 0.0 0.8068936312471637 0.10000000149011612 -0.005344390869140625 0.017913818359375 0.01094818115234375 0.009999999776482582 -0.55078125 -0.05865478515625 -0.06689453125 0.01129150390625 -0.01666259765625 -0.03057861328125 -0.1268310546875 -0.252197265625 0.020172119140625 0.0902099609375 0.0024738311767578125 -0.00368499755859375 0.00455474853515625 0.0104522705078125 -0.033721923828125 0.0194854736328125 0.00994873046875 0.019500732421875
238 C6E6907A-2118-47E3-A696-CFF7F0B4CC3F 2017-12-16T11:52:15+00:00 
[
    "Public"
]
 
[]
 heic 7579f41e5a983976df725e86a94b7261d7dd42ce20b6fd1e1ac24157a5f423a6 2545737 51.5034 -0.1320305 0 0 0 0 0 0 0 0 London England United Kingdom C6E6907A-2118-47E3-A696-CFF7F0B4CC3F 0.6943359375 0.5 0.0 0.8053669137809113 0.5068126320838928 -0.00046372413635253906 0.07562255859375 0.00809478759765625 0.009999999776482582 0.449951171875 -0.027069091796875 0.2340087890625 0.0027675628662109375 -0.0068511962890625 -0.003997802734375 0.20849609375 0.1182861328125 0.036895751953125 0.19921875 0.0247955322265625 0.0036468505859375 0.006824493408203125 0.046905517578125 0.005023956298828125 0.21826171875 0.459228515625 0.18798828125
426 A5E3DEAF-E22B-454C-9543-CF68191F349A 2017-12-16T11:52:14+00:00 
[
    "Public"
]
 
[]
 heic d84a166371c9d0f249aa25afbac69ba5cd310a5392fddf2c113736b53f0c6d5e 2498824 51.5034 -0.1320305 0 0 0 0 0 0 0 0 London England United Kingdom A5E3DEAF-E22B-454C-9543-CF68191F349A 0.64990234375 0.5 0.0 0.8053667281420176 0.5036982893943787 -0.0003859996795654297 0.0845947265625 0.01322174072265625 0.009999999776482582 0.51171875 -0.04193115234375 0.064208984375 0.0112457275390625 -0.005321502685546875 0.00323486328125 0.36376953125 0.281494140625 0.02947998046875 0.3935546875 0.042724609375 0.0096282958984375 0.01312255859375 0.058349609375 0.00994110107421875 0.156005859375 0.45751953125 0.295166015625
385 F6F45595-4033-4C79-A9F9-86DCA9088C37 2017-12-16T11:52:13+00:00 
[
    "Public"
]
 
[]
 heic bfe920659a1e209114e738c58fcc9e1df8cdd1eaed6ac7af4721f05865ba8935 2341576 51.50340333333333 -0.13203616666666668 0 0 0 0 0 0 0 0 London England United Kingdom F6F45595-4033-4C79-A9F9-86DCA9088C37 0.6103515625 0.5 0.0 0.8053669137809113 0.10000000149011612 -0.00572967529296875 -0.000789642333984375 0.0010814666748046875 0.019999999552965164 0.0447998046875 -0.095703125 0.048583984375 0.01238250732421875 -0.08880615234375 -0.05389404296875 -0.29736328125 -0.29248046875 0.0289306640625 -0.12152099609375 -0.001251220703125 -0.0276031494140625 0.0015192031860351562 0.022796630859375 -0.032806396484375 -0.325439453125 0.28076171875 -0.0489501953125
403 C75D24F7-AB72-4E8F-BBBB-A07E77CC5B91 2017-12-16T11:51:56+00:00 
[
    "Public"
]
 
[]
 heic c8b559b15a474986fdfb54b369eb86e9c5a65ec65c5fd1f6d37f3065953943d1 1699083 51.503391666666666 -0.13205283333333334 0 0 0 0 0 0 0 0 London England United Kingdom C75D24F7-AB72-4E8F-BBBB-A07E77CC5B91 0.6298828125 0.5 0.0 0.04200813515495708 0.10000000149011612 -0.001995086669921875 0.07391357421875 0.02069091796875 0.009999999776482582 -0.05419921875 -0.0638427734375 0.0679931640625 0.011962890625 -0.009521484375 -0.06158447265625 -0.0850830078125 0.0257568359375 0.0330810546875 0.201416015625 0.018402099609375 0.003326416015625 0.0038547515869140625 0.00971221923828125 -0.006549835205078125 0.006866455078125 -0.07818603515625 0.1031494140625
355 6CE10468-228C-4110-AB0B-663558FCF258 2017-12-16T11:51:32+00:00 
[
    "Public"
]
 
[]
 heic ac2fa4d70ca17a1face556a46a10868917800a96e5c48d0322a7e8a6903b6ae9 2369444 51.50336166666666 -0.13211666666666666 0 0 0 0 0 0 0 0 London England United Kingdom 6CE10468-228C-4110-AB0B-663558FCF258 0.6875 0.5 0.0 0.04202670814426801 0.10000000149011612 -0.0016489028930664062 0.08026123046875 0.0219879150390625 0.009999999776482582 0.25732421875 -0.055938720703125 0.0203857421875 0.01363372802734375 -0.0082550048828125 -0.040130615234375 0.19677734375 0.017578125 0.023193359375 0.279296875 0.022216796875 0.03936767578125 0.00760650634765625 0.01116180419921875 -0.00557708740234375 0.022735595703125 0.031005859375 0.200927734375
135 6274A881-9445-44D6-9E7C-776DAEF1C603 2017-12-16T11:51:31+00:00 
[
    "Public"
]
 
[]
 heic 3eb13ed43499313a2db919adf2b109b55dd49377096ac3edc35444b735a95b69 2120984 51.503355 -0.13211666666666666 0 0 0 0 0 0 0 0 London England United Kingdom 6274A881-9445-44D6-9E7C-776DAEF1C603 0.626953125 0.5 0.0 0.04200794951606343 0.10000000149011612 -0.002208709716796875 0.041107177734375 0.0035648345947265625 0.019999999552965164 0.14013671875 -0.07147216796875 0.12841796875 0.01009368896484375 -0.01061248779296875 -0.02294921875 0.0084228515625 -0.0406494140625 0.03143310546875 0.1263427734375 0.01114654541015625 -0.019287109375 0.005428314208984375 0.060211181640625 0.024200439453125 0.04046630859375 0.45068359375 0.143798828125
415 48EECE84-27A5-4AEC-9B09-6173F8700CEA 2017-12-16T11:51:09+00:00 
[
    "Public"
]
 
[]
 heic d1f5ff1dc55f467cc316d31897840e7ab50a1894823780b56c36e9ee6bda5c08 1806032 51.503303333333335 -0.1321805 0 0 0 0 0 0 0 0 London England United Kingdom 48EECE84-27A5-4AEC-9B09-6173F8700CEA 0.58349609375 0.5 0.0 0.04200794951606343 0.10000000149011612 -0.004520416259765625 0.0024871826171875 0.00269317626953125 0.019999999552965164 -0.498291015625 -0.06878662109375 0.1837158203125 0.006931304931640625 -0.023101806640625 -0.06317138671875 -0.370361328125 -0.158447265625 0.11920166015625 -0.0765380859375 -0.003047943115234375 -0.0631103515625 0.0030155181884765625 0.021575927734375 0.007659912109375 -0.190673828125 -0.0775146484375 -0.033233642578125
30 8876C417-C39E-453A-A865-2A997A6DAAF0 2017-12-16T11:51:05+00:00 
[
    "Public"
]
 
[]
 heic 11b66e49de0d6187d44d38601aefce96dfa29f419444d201b1e03422bd76dc14 1999722 51.503296666666664 -0.13221116666666666 0 0 0 0 0 0 0 0 London England United Kingdom 8876C417-C39E-453A-A865-2A997A6DAAF0 0.65673828125 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.01029205322265625 -0.0067291259765625 0.0014553070068359375 0.009999999776482582 -0.26220703125 -0.10125732421875 0.0670166015625 0.006984710693359375 -0.120361328125 -0.1640625 -0.50146484375 -0.361328125 0.06671142578125 -0.2410888671875 -0.0035266876220703125 -0.053955078125 0.0016489028930664062 0.005344390869140625 -0.1005859375 -0.46533203125 -0.158203125 -0.1329345703125
343 0B9B2460-9D4D-421F-92C0-8F0921632AEC 2017-12-03T22:49:55+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic a6c77dd4fb9cd10a38e56b6d1d0962b03d79a57e4cad71921d4a583d8b86b298 748252 37.333663333333334 -121.92330833333334 0 0 0 0 0 0 0 0 San Jose CA United States 0B9B2460-9D4D-421F-92C0-8F0921632AEC 0.4404296875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0007915496826171875 0.0180816650390625 0.006824493408203125 0.009999999776482582 -0.1405029296875 -0.049407958984375 0.1383056640625 0.00284576416015625 -0.01312255859375 -0.04608154296875 -0.11279296875 0.01507568359375 0.10760498046875 0.0987548828125 0.0095062255859375 -0.0106201171875 0.007694244384765625 0.031494140625 0.00435638427734375 0.03155517578125 0.231689453125 0.008331298828125
459 03BA87C4-E783-44BC-9626-45983800AE72 2017-12-03T21:29:30+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic e8b97c85b48fe094964dd0e016e92f71f506e3d8586861f4bd8fe243365b9fe7 2062821 37.333938333333336 -121.92302 0 0 0 0 0 0 0 0 San Jose CA United States 03BA87C4-E783-44BC-9626-45983800AE72 0.50341796875 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.005889892578125 -0.0104827880859375 0.002811431884765625 0.019999999552965164 -0.4658203125 -0.043121337890625 0.2430419921875 0.0018100738525390625 -0.06573486328125 -0.1309814453125 -0.382568359375 -0.1617431640625 0.2509765625 -0.2269287109375 -0.002628326416015625 -0.031951904296875 0.0022869110107421875 0.006122589111328125 -0.02349853515625 -0.289306640625 -0.37255859375 -0.0804443359375
458 AC6610AB-FA5E-4B76-93B8-F91AC0ED2D8A 2017-11-05T23:07:13+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic e8984bb084f3dd58c57a1e2f8a1c8cdbb86c903cfc239f61916b3eb86f332655 3513964 37.769133333333336 -122.46440833333334 0 0 0 0 0 0 0 0 San Francisco CA United States AC6610AB-FA5E-4B76-93B8-F91AC0ED2D8A 0.463623046875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0016040802001953125 0.06597900390625 0.047515869140625 0.009999999776482582 -0.026611328125 -0.0313720703125 0.0909423828125 0.00443267822265625 -0.00595855712890625 -0.0275115966796875 0.1474609375 -0.005859375 0.033905029296875 0.120361328125 0.016143798828125 0.02667236328125 0.007122039794921875 0.00669097900390625 -0.0003986358642578125 0.007114410400390625 -0.04931640625 0.012451171875
350 A92AF32A-7C12-48CC-B1C3-5C83D05B76AA 2017-11-05T23:06:58+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic a981be272530aba690ff4d6e292c3dbfeb1fee4c9fcca39346043012cf486e49 3639642 37.76914166666667 -122.46450833333333 0 0 0 0 0 0 0 0 San Francisco CA United States A92AF32A-7C12-48CC-B1C3-5C83D05B76AA 0.4189453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0011157989501953125 0.06903076171875 0.00734710693359375 0.019999999552965164 -0.3623046875 -0.03521728515625 0.1944580078125 0.0282135009765625 -0.01137542724609375 -0.0245361328125 -0.04638671875 0.085205078125 0.2430419921875 0.192626953125 0.03240966796875 -0.01221466064453125 0.01450347900390625 0.060516357421875 0.03424072265625 0.024658203125 0.1572265625 0.00374603271484375
132 F142B8D1-24B8-4108-AFB7-0C454C72E625 2017-11-05T23:06:49+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic 3c189d4ca97d42b444c05d69f5f798f0ecb1c4066123d5f75d1d0d60e332a475 4231615 37.76921166666666 -122.46446166666666 0 0 0 0 0 0 0 0 San Francisco CA United States F142B8D1-24B8-4108-AFB7-0C454C72E625 0.468017578125 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.0019121170043945312 0.0162353515625 0.0016231536865234375 0.019999999552965164 -0.1405029296875 -0.0204925537109375 0.308349609375 0.0012693405151367188 -0.0310821533203125 -0.024505615234375 0.00177001953125 -0.03289794921875 0.05572509765625 -0.046142578125 0.0059814453125 -0.0129547119140625 0.0024623870849609375 0.11993408203125 0.04132080078125 0.31396484375 0.54833984375 -0.00934600830078125
218 3D7AE6D3-0FD4-4130-B713-44EB2C885A30 2017-11-05T23:05:51+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic 6cd24772dbd1f463325dba1e5ab734ceb559741953324b590eb89d3497cda1f4 2789234 37.768953333333336 -122.464425 0 0 0 0 0 0 0 0 San Francisco CA United States 3D7AE6D3-0FD4-4130-B713-44EB2C885A30 0.373779296875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0011920928955078125 0.0150299072265625 0.0024242401123046875 0.009999999776482582 0.0262451171875 -0.05340576171875 0.35107421875 0.0018529891967773438 -0.01525115966796875 -0.019927978515625 -0.121337890625 -0.013916015625 0.078369140625 -0.033782958984375 -0.0024566650390625 -0.01345062255859375 0.0018177032470703125 0.0472412109375 0.041656494140625 -0.119140625 0.26513671875 -0.02508544921875
38 1EAE7EE2-CBE6-491B-A8EF-337859628659 2017-11-05T23:05:44+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic 1423536b7567da6562cd1e842bd93be31d8ebe84d797afe4a81644bac2a2c9e3 2979362 37.768975 -122.46446166666666 0 0 0 0 0 0 0 0 San Francisco CA United States 1EAE7EE2-CBE6-491B-A8EF-337859628659 0.347900390625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0028896331787109375 0.01885986328125 0.004116058349609375 0.03999999910593033 0.1094970703125 -0.053192138671875 0.1767578125 0.00254058837890625 -0.019561767578125 -0.03076171875 -0.08697509765625 -0.03570556640625 0.029815673828125 0.0164794921875 0.00586700439453125 -0.00499725341796875 0.001926422119140625 0.037261962890625 -0.0113525390625 0.08465576171875 0.339599609375 0.105224609375
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
181 3E20BE4D-619A-42EC-9CAA-6F67508892E4 2017-10-27T20:41:30+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 5a3a4b0ffc8de931dd6dd0c977df4b444421a404c820c795346c8faffc984ffa 1744396 37.809145 -122.42119666666666 0 0 0 0 0 0 0 0 San Francisco CA United States 3E20BE4D-619A-42EC-9CAA-6F67508892E4 0.49169921875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0024929046630859375 -0.006275177001953125 0.003692626953125 0.009999999776482582 -0.309814453125 -0.0948486328125 0.2303466796875 0.0018968582153320312 -0.022247314453125 -0.13623046875 -0.5966796875 -0.132568359375 0.188232421875 -0.1619873046875 -0.0025348663330078125 -0.020538330078125 0.0019044876098632812 0.004505157470703125 -0.01824951171875 -0.40283203125 -0.51416015625 -0.1053466796875
396 AC4419FA-ED22-473F-8FB0-15B647BB2FBD 2017-10-27T20:35:55+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic c5e23798acf2cbff48fd65696d94e1326f128cf3e60230b7023fece6bebafa87 1777363 37.81 -122.422325 0 0 0 0 0 0 0 0 San Francisco CA United States AC4419FA-ED22-473F-8FB0-15B647BB2FBD 0.4951171875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.01016998291015625 -0.0117034912109375 0.004364013671875 0.009999999776482582 -0.28955078125 -0.061431884765625 0.0799560546875 0.017181396484375 -0.1041259765625 -0.07489013671875 -0.485107421875 -0.324462890625 0.2017822265625 -0.0938720703125 -0.0036525726318359375 -0.0207061767578125 0.003063201904296875 0.00263214111328125 -0.061798095703125 -0.392822265625 -0.4423828125 -0.12066650390625
393 9FAD352B-5A8E-4A93-B84D-5EB5D0A6C409 2017-10-27T20:27:34+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic c57c252d8bb404e1de2a5015c6ac7b6a99e131d72a9ce002dd65564b4f8b10fd 1638873 37.80999666666666 -122.42220333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 9FAD352B-5A8E-4A93-B84D-5EB5D0A6C409 0.459228515625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004791259765625 0.033355712890625 0.00323486328125 0.009999999776482582 -0.90087890625 -0.0262603759765625 0.24462890625 0.01953125 -0.0194549560546875 -0.021209716796875 -0.134521484375 -0.09967041015625 0.0704345703125 0.013671875 -0.0697021484375 -0.011474609375 0.003040313720703125 0.038330078125 0.0077056884765625 0.04486083984375 0.0809326171875 -0.00347137451171875

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