photos_with_apple_metadata (view)

21 rows where ZINTERACTIONSCORE = "0.019999999552965164" and place_state_province = "CA" sorted by ZFAILURESCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, persons, ext, latitude, longitude, favorite, place_city, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZNOISESCORE, ZPLEASANTSYMMETRYSCORE, date (date), albums (array), persons (array)

place_state_province ✖

ZINTERACTIONSCORE ✖

  • 0.019999999552965164 · 21 ✖
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
7 5BD1D973-19F4-48F1-AB13-A214B0B98452 2020-01-25T18:18:00+00:00 
[
    "Public"
]
 
[]
 heic 03bd641c31961be01b3f491a7414ccacb2c57dece64fd6fd8e4be6384643ef8e 2939606 37.11606667000001 -122.330475 1 0 0 0 0 0 0 0 Pescadero CA United States 5BD1D973-19F4-48F1-AB13-A214B0B98452 0.4609375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00885009765625 0.0035858154296875 0.01512908935546875 0.019999999552965164 -0.51416015625 -0.0567626953125 0.0233154296875 0.029815673828125 -0.047515869140625 -0.06463623046875 -0.453369140625 -0.25146484375 0.134033203125 -0.031097412109375 0.00135040283203125 -0.0153350830078125 0.00577545166015625 0.004383087158203125 -0.039459228515625 -0.0838623046875 -0.360107421875 -0.022308349609375
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
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
249 DAEEB402-23FC-4CFB-9C40-75DF9B7C0E8F 2018-04-21T23:55:29+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 798436ad6175c55c8785bfbc10c8ffe60913b521a52312735f138f37e3cb4d81 1173698 37.579053333333334 -122.34420833333333 0 0 0 0 0 0 0 0 Burlingame CA United States DAEEB402-23FC-4CFB-9C40-75DF9B7C0E8F 0.27099609375 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.005279541015625 0.00095367431640625 0.00243377685546875 0.019999999552965164 -0.41845703125 -0.12200927734375 0.01702880859375 0.0144500732421875 -0.038970947265625 -0.09381103515625 -0.54541015625 -0.300048828125 0.050048828125 -0.0985107421875 -0.00109100341796875 -0.01496124267578125 0.0021915435791015625 0.012237548828125 -0.0482177734375 -0.16259765625 -0.0987548828125 -0.0265350341796875
288 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 2016-04-09T20:10:29+00:00 
[
    "Public"
]
 
[]
 jpeg 8a3115b8c82c630e48b0ac70eb94d8201721937c4697a667916e1632a5063001 3046776 37.78546166666667 -122.43050333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 0.41064453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.005138397216796875 0.0030517578125 0.0012159347534179688 0.019999999552965164 0.17138671875 -0.06451416015625 0.043548583984375 0.00955963134765625 -0.0836181640625 -0.022918701171875 -0.1002197265625 -0.2410888671875 0.0150146484375 -0.057891845703125 -0.0015716552734375 -0.009979248046875 0.0015850067138671875 0.051177978515625 -0.016876220703125 -0.0430908203125 0.5712890625 0.01898193359375
252 0BE49C93-2ACC-4628-9C12-99566921EE00 2020-01-25T18:11:18+00:00 
[
    "Public"
]
 
[]
 heic 7ad35f068121f446574a8c950f35017b34cbc4e6dd25c72be8a71b9234bb1e7a 3541580 37.115291670000005 -122.32810333 1 0 0 0 0 0 0 0 Pescadero CA United States 0BE49C93-2ACC-4628-9C12-99566921EE00 0.499267578125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00359344482421875 0.0284423828125 0.0020751953125 0.019999999552965164 0.091552734375 -0.055206298828125 0.0228271484375 0.1646728515625 -0.0496826171875 -0.010345458984375 -0.0771484375 -0.1522216796875 0.047515869140625 0.07708740234375 0.0098876953125 -0.006160736083984375 0.006072998046875 0.0849609375 0.03167724609375 -0.0933837890625 0.5546875 0.07440185546875
420 60198E20-708E-4125-B793-4466A87B2DDA 2017-06-16T00:56:17+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg d553261ef8ec0fc2d81eb04e584491dfcba6d4d58b8455cc741c362ec21eea22 5956608 37.76925 -122.46415 0 0 0 0 0 0 0 0 San Francisco CA United States 60198E20-708E-4125-B793-4466A87B2DDA 0.392578125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00307464599609375 0.0094757080078125 0.001220703125 0.019999999552965164 0.1380615234375 -0.056854248046875 0.2802734375 0.00313568115234375 -0.04559326171875 -0.04010009765625 -0.107666015625 -0.0838623046875 0.048492431640625 -0.160400390625 0.00628662109375 -0.0150909423828125 0.0010166168212890625 0.060760498046875 0.06494140625 -0.0399169921875 0.345947265625 -0.05755615234375
191 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 2016-11-05T21:21:05+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 5f9968989d0aad8a9dd9c6aabd5e495444a44a8714a1fa3296a96132b67de178 2555246 37.82716333333333 -122.52745833333333 0 0 0 0 0 0 0 0 Sausalito CA United States 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 0.50244140625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0023326873779296875 0.005535125732421875 0.004665374755859375 0.019999999552965164 -0.384033203125 -0.036773681640625 0.181396484375 0.0038852691650390625 -0.02947998046875 -0.0823974609375 -0.1904296875 -0.1136474609375 0.1702880859375 -0.056884765625 0.001659393310546875 -0.056396484375 0.006587982177734375 0.01467132568359375 -0.00415802001953125 -0.0748291015625 0.009765625 -0.01593017578125
438 57650917-1883-4D73-AD2B-B45C6A661534 2017-03-31T00:53:31+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg ddea960de035d2fc5726dd94a94692f90f7dc60c7e28e19b45fcc765e2d0813c 4243346 37.769146666666664 -122.46449166666666 0 0 0 0 0 0 0 0 San Francisco CA United States 57650917-1883-4D73-AD2B-B45C6A661534 0.3447265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0022525787353515625 0.00321197509765625 0.004627227783203125 0.019999999552965164 -0.00634765625 -0.1229248046875 0.0634765625 0.00844573974609375 -0.0203704833984375 -0.053375244140625 -0.448974609375 -0.152587890625 0.0966796875 -0.019805908203125 -0.00054168701171875 -0.01448822021484375 0.00441741943359375 0.0119171142578125 -0.027587890625 -0.298583984375 -0.009033203125 0.0059814453125
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
492 D3CF77DA-B6DD-47F1-A69C-3E01122F133E 2017-03-31T00:48:54+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg fe7c5489ffa8c070183fe2c559c00b6d5880a6b9a9c53f807962166ec96c4375 4984812 37.7692 -122.46450833333333 0 0 0 0 0 0 0 0 San Francisco CA United States D3CF77DA-B6DD-47F1-A69C-3E01122F133E 0.497314453125 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.002002716064453125 0.0117950439453125 0.002010345458984375 0.019999999552965164 -0.28369140625 -0.018341064453125 0.296630859375 0.002132415771484375 -0.038604736328125 -0.031494140625 -0.022735595703125 -0.041351318359375 0.188232421875 -0.038330078125 0.0035552978515625 -0.016143798828125 0.00455474853515625 0.07452392578125 0.034332275390625 0.2244873046875 0.4072265625 -0.01230621337890625
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
62 ADE494D7-0048-491A-B410-D04C5C58B0DD 2017-07-23T22:20:34+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 1cfb72be21bffca1c026c49845045769dc2791f7844d85d14e74257325d83b23 1988831 37.84245 -122.27783333333333 0 0 0 0 0 0 0 0 Oakland CA United States ADE494D7-0048-491A-B410-D04C5C58B0DD 0.501953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0014553070068359375 0.0223541259765625 0.0022430419921875 0.019999999552965164 -0.1689453125 -0.0207672119140625 0.274169921875 0.0016107559204101562 -0.023284912109375 -0.021148681640625 0.013336181640625 -0.008758544921875 0.0755615234375 0.031982421875 0.0097198486328125 -0.0099945068359375 0.0033512115478515625 0.11163330078125 0.041748046875 0.31640625 0.488037109375 -0.00374603271484375
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
37 A5DFB6E5-9DA4-4724-8439-AE9A800AD9EC 2018-02-20T23:05:22+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 1410392329d163954b764fbf466079c543add302f7fccd5eb9158c132ca093d4 1570524 37.742808333333336 -122.449255 0 0 0 0 0 0 0 0 San Francisco CA United States A5DFB6E5-9DA4-4724-8439-AE9A800AD9EC 0.34521484375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0012254714965820312 0.0301361083984375 0.00919342041015625 0.019999999552965164 0.2430419921875 -0.0616455078125 -0.0184326171875 0.0119171142578125 -0.0135345458984375 -0.0247650146484375 0.134033203125 -0.022705078125 0.02532958984375 0.2529296875 0.0094757080078125 0.00237274169921875 0.0082855224609375 0.0211181640625 -0.0068359375 0.052947998046875 0.224609375 0.245361328125
141 ADE9C25D-18D3-42C0-8BE9-CE2A30781B43 2018-02-20T23:28:04+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 4343b8b78aceac81aafddb11d751033ab74b55a41ed0b075e238d272fcfd100c 1495974 37.74249666666667 -122.44919666666667 0 0 0 0 0 0 0 0 San Francisco CA United States ADE9C25D-18D3-42C0-8BE9-CE2A30781B43 0.49755859375 0.5 0.0 0.038931297721298594 0.5044282078742981 -0.0012111663818359375 0.1588134765625 0.03533935546875 0.019999999552965164 0.2685546875 -0.026702880859375 0.157470703125 0.02484130859375 -0.007755279541015625 -0.00732421875 0.225341796875 0.22412109375 0.04132080078125 0.22412109375 0.09417724609375 0.01018524169921875 0.006511688232421875 0.0301055908203125 0.01500701904296875 0.05633544921875 0.040435791015625 0.058685302734375
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
298 3C3089C2-BA72-45E8-90B9-2974D8D2DB36 2019-12-13T23:52:03+00:00 
[
    "Public"
]
 
[]
 heic 8e935af3c408ee0013c7d05f82ae8592f12aa341f455cc15534ae2db1ead05ef 2663392 34.11846667000001 -118.30060500000002 1 0 0 0 0 0 0 0 Los Angeles CA United States 3C3089C2-BA72-45E8-90B9-2974D8D2DB36 0.289794921875 0.75 0.0 0.05801763419659083 0.10000000149011612 -0.0009660720825195312 -0.00296783447265625 0.0020580291748046875 0.019999999552965164 0.148681640625 -0.0546875 0.416748046875 0.0016613006591796875 -0.0190887451171875 -0.022308349609375 -0.1881103515625 -0.056060791015625 0.286865234375 -0.05364990234375 -0.00543212890625 -0.0264129638671875 0.0034027099609375 0.0214080810546875 0.0212860107421875 -0.6259765625 0.081787109375 -0.1051025390625
36 5C91B5A8-1A4C-4406-B5E6-11883EFC714E 2019-09-16T16:26:37+00:00 
[
    "Public"
]
 
[]
 heic 14101f33adc465139279ae9a80118d2b388f4350c9b1b5ed06596282646d000b 2027028 37.44983333333333 -122.1864 1 0 0 0 0 0 0 0 Menlo Park CA United States 5C91B5A8-1A4C-4406-B5E6-11883EFC714E 0.300048828125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0008935928344726562 0.032806396484375 0.0007948875427246094 0.019999999552965164 -0.158447265625 -0.049957275390625 0.421630859375 0.0026721954345703125 -0.007904052734375 0.01885986328125 -0.05377197265625 0.057647705078125 0.08465576171875 0.02484130859375 0.0040283203125 -0.014495849609375 0.001934051513671875 0.43359375 0.56494140625 0.025390625 0.62744140625 -0.0088653564453125
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
351 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 2017-12-03T22:40:16+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic a99406f355b55e1d8c5bf18f8d85761ef703d75b862e715f9e9751c5e0a8bacd 1734045 37.333511666666666 -121.92306333333333 1 0 0 0 0 0 0 0 San Jose CA United States 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 0.477294921875 0.75 0.0 0.058022878381587165 0.10000000149011612 -0.0005526542663574219 0.027008056640625 0.0082855224609375 0.019999999552965164 -0.37451171875 -0.041778564453125 0.27587890625 0.004364013671875 -0.006565093994140625 -0.048553466796875 -0.1864013671875 -0.00262451171875 0.31640625 0.05841064453125 0.00191497802734375 -0.0159454345703125 0.0174407958984375 0.0215301513671875 0.001140594482421875 -0.11749267578125 0.0311279296875 -0.0047607421875

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