photos_with_apple_metadata (view)

26 rows where ZBEHAVIORALSCORE = "0.10000000149011612" and albums contains "Ray Bandar for Niche Museums" sorted by ZPROMOTIONSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: persons, latitude, longitude, favorite, panorama, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZINTERACTIONSCORE, ZNOISESCORE, ZPLEASANTSYMMETRYSCORE, date (date), persons (array)

albums (array) ✖

ZBEHAVIORALSCORE ✖

  • 0.10000000149011612 · 26 ✖
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
236 DA6D5F58-3726-4C96-9E0B-9C6097A56582 2018-02-20T23:22:25+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 7459ab505c76600867aaa2c9bc23a84a32723096f88b33018847e62a35204c5e 1635301 37.74253 -122.44937833333333 0 0 0 0 0 0 0 0 San Francisco CA United States DA6D5F58-3726-4C96-9E0B-9C6097A56582 0.483154296875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.019561767578125 0.015533447265625 0.00555419921875 0.009999999776482582 -0.70947265625 -0.06683349609375 -0.000732421875 0.0189361572265625 -0.016845703125 -0.014556884765625 -0.2294921875 -0.169677734375 0.024383544921875 0.05059814453125 6.103515625e-05 -0.00496673583984375 0.0023975372314453125 0.05975341796875 0.068359375 0.038604736328125 0.1207275390625 0.008453369140625
429 3BE3193F-45AF-4787-B445-A6260393657C 2018-02-20T23:18:32+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic d95f2e03676af786d523f3c360046daade8b99f2e3a69bdaa24c27b7467512ad 5038686 37.742305 -122.44933333333333 1 0 0 0 0 0 0 1 San Francisco CA United States 3BE3193F-45AF-4787-B445-A6260393657C 0.4404296875 0.75 0.0 0.05801952050159906 0.10000000149011612 -0.0016937255859375 0.025726318359375 0.005161285400390625 0.009999999776482582 0.0986328125 -0.134033203125 -0.08038330078125 0.054901123046875 -0.00971221923828125 -0.021026611328125 -0.12890625 -0.1240234375 0.0153656005859375 0.198974609375 0.009490966796875 -0.000732421875 0.00731658935546875 0.02880859375 -0.0065765380859375 -0.01116943359375 0.2578125 0.1834716796875
354 A6C2C9FE-D032-450F-B0FC-AF6191226FA9 2018-02-20T23:15:38+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic abb62ed287656b13ebdd9963dcb71d17831ccb5501f9523c0bfa2e556e8805c2 1898626 37.74283833333333 -122.44926333333333 0 0 0 0 0 0 0 0 San Francisco CA United States A6C2C9FE-D032-450F-B0FC-AF6191226FA9 0.50341796875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0165863037109375 0.020751953125 0.00646209716796875 0.009999999776482582 -0.52392578125 -0.09600830078125 -0.0655517578125 0.039276123046875 -0.01322174072265625 -0.01092529296875 -0.2071533203125 -0.216064453125 0.0210113525390625 0.0928955078125 0.00466156005859375 -0.0024623870849609375 0.0027904510498046875 0.049224853515625 0.1353759765625 0.01953125 0.07037353515625 0.038360595703125
428 05F7112C-C7CE-4866-8964-29C94481B135 2018-02-20T23:09:24+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic d90e8cca2a6f253308587f2bd7ab6cf24f0d738e507f8d0ad07bb7786c8ef904 1912383 37.742795 -122.44927166666666 0 0 0 0 0 0 0 0 San Francisco CA United States 05F7112C-C7CE-4866-8964-29C94481B135 0.26025390625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00128936767578125 0.0255279541015625 0.0110321044921875 0.009999999776482582 -0.42333984375 -0.1190185546875 -0.07818603515625 0.015838623046875 -0.005001068115234375 -0.032623291015625 -0.159912109375 -0.042236328125 0.0240936279296875 0.31396484375 0.005462646484375 -0.001247406005859375 0.00948333740234375 0.0197906494140625 -0.0095977783203125 0.0058441162109375 0.0643310546875 0.07342529296875
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
491 2489642F-D29D-47EC-918A-63D1E2CEDF98 2018-02-20T23:04:00+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic fdc3052b1eb0fc7ebf3511145fa1744be8a22de793c74f9d89f98ffca730df5b 1690162 37.74257166666666 -122.44921166666667 1 0 0 0 0 0 0 0 San Francisco CA United States 2489642F-D29D-47EC-918A-63D1E2CEDF98 0.529296875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.001129150390625 0.0247955322265625 0.0087432861328125 0.009999999776482582 0.038818359375 -0.07354736328125 -0.028564453125 0.0169830322265625 -0.01085662841796875 -0.02056884765625 0.00927734375 0.0140380859375 0.0294189453125 0.26611328125 0.00890350341796875 -0.00035858154296875 0.00916290283203125 0.02691650390625 -0.004119873046875 0.0243988037109375 0.219970703125 0.1761474609375
166 A9E26555-0DE9-4416-8C3E-54992AF7AB10 2018-02-20T23:02:11+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 54525e90a3fda130db87d551bb7a10208980d0d1960ca9b83bac61d2499a67d8 1535168 37.74260833333334 -122.44934166666667 0 0 0 0 0 0 0 0 San Francisco CA United States A9E26555-0DE9-4416-8C3E-54992AF7AB10 0.37646484375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0025501251220703125 0.01739501953125 0.00669097900390625 0.009999999776482582 0.058837890625 -0.08062744140625 0.12646484375 0.003692626953125 -0.013427734375 -0.08441162109375 -0.201171875 -0.169189453125 0.0401611328125 -0.0177001953125 0.004955291748046875 -0.036102294921875 0.003482818603515625 0.007724761962890625 -0.0174560546875 -0.05755615234375 0.0003662109375 0.0176849365234375
460 9AC32575-E912-415A-B8B4-337F609BE59D 2018-02-20T23:01:10+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic e92d09fedafddb9d403e1ce9988dfb7f19edd1602f86971472d73aeaa9ec6ab9 845436 37.74271666666667 -122.44912833333333 0 0 0 0 0 0 0 0 San Francisco CA United States 9AC32575-E912-415A-B8B4-337F609BE59D 0.3896484375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.005405426025390625 0.1490478515625 0.00981903076171875 0.009999999776482582 0.079345703125 -0.032958984375 0.0771484375 0.09552001953125 -0.01177978515625 -0.00511932373046875 0.1884765625 0.018798828125 0.11578369140625 0.1590576171875 0.0197601318359375 0.006481170654296875 0.00919342041015625 0.0604248046875 0.12469482421875 0.030181884765625 0.14599609375 0.1885986328125
332 8D9702F9-ACED-47C4-B09C-19F9F72F17D4 2018-02-20T22:59:09+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic a1c242e31c11211b88364db77fd8fb313aa9cdd5bbc4136c84731685c0763ecc 1632132 37.742763333333336 -122.44917166666667 0 0 0 0 0 0 0 0 San Francisco CA United States 8D9702F9-ACED-47C4-B09C-19F9F72F17D4 0.414306640625 0.5 0.0 0.8022900763472528 0.10000000149011612 -0.00323486328125 0.0179290771484375 0.00926971435546875 0.009999999776482582 -0.119873046875 -0.08538818359375 -0.0933837890625 0.020843505859375 -0.015899658203125 -0.0323486328125 -0.0849609375 -0.21923828125 0.024658203125 0.19921875 0.005413055419921875 -0.001407623291015625 0.00800323486328125 0.0139007568359375 -0.0426025390625 0.01751708984375 0.11553955078125 0.1260986328125
296 D5731038-247C-482A-942D-CD75A0824FA6 2018-02-20T22:58:48+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 8e7c781f6a3025039c94cf032dd6a4bdfa9b9640f2fa9549f4ece6560befb592 1177074 37.74221166666667 -122.44931666666666 0 0 0 0 0 0 0 0 San Francisco CA United States D5731038-247C-482A-942D-CD75A0824FA6 0.268798828125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0011119842529296875 0.0445556640625 0.0125732421875 0.009999999776482582 0.287353515625 -0.05889892578125 -0.009368896484375 0.01519012451171875 -0.0087127685546875 -0.0183258056640625 0.16455078125 0.06982421875 0.046478271484375 0.305419921875 0.011993408203125 0.00443267822265625 0.01132965087890625 0.0199432373046875 -0.00567626953125 0.029632568359375 0.1522216796875 0.378173828125
373 55679037-0DCE-469C-A1B2-1ADD537FA1A6 2018-02-20T22:56:52+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic b6dde111630ca1bf56bf3c85f76cbdd0135b5bfe07f635045eaac6cb438c0e8a 1834797 37.742828333333335 -122.44926333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 55679037-0DCE-469C-A1B2-1ADD537FA1A6 0.324951171875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0018310546875 0.0701904296875 0.04840087890625 0.009999999776482582 -0.1580810546875 -0.0245208740234375 0.1226806640625 0.004886627197265625 -0.006145477294921875 -0.0156707763671875 0.1221923828125 0.07342529296875 0.053497314453125 0.145751953125 0.021331787109375 0.00202178955078125 0.007518768310546875 0.014617919921875 0.0022735595703125 0.0261688232421875 -0.02593994140625 0.01435089111328125
195 EA45776D-2CCA-41EB-A0C4-CCF0D416720C 2018-02-20T22:54:54+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 6323ea1c6096703eaa318d5c5974adca7b8e1c19285f157536b8b881927c7b6e 1610865 37.742803333333335 -122.44925 0 0 0 0 0 0 0 0 San Francisco CA United States EA45776D-2CCA-41EB-A0C4-CCF0D416720C 0.35693359375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0006513595581054688 0.00927734375 0.0058441162109375 0.009999999776482582 -0.681640625 -0.1776123046875 -0.022125244140625 0.0087432861328125 -0.00394439697265625 -0.05389404296875 -0.58837890625 -0.05224609375 0.029083251953125 0.135498046875 0.0011005401611328125 -0.01287841796875 0.007259368896484375 0.0189361572265625 -0.00377655029296875 -0.06549072265625 -0.0274658203125 0.01439666748046875
80 3A952955-7B08-4DEE-809D-C08685BDC3BF 2018-02-20T22:52:16+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 232c6b6414de60758ae544a8323123a9d651d32c0769f5ad9aa8533b8635051b 1628032 37.742355 -122.44944666666666 1 0 0 0 0 0 0 0 San Francisco CA United States 3A952955-7B08-4DEE-809D-C08685BDC3BF 0.4873046875 0.75 0.0 0.05802354995758479 0.10000000149011612 -0.0007977485656738281 0.04168701171875 0.0129241943359375 0.009999999776482582 -0.1112060546875 -0.0271759033203125 0.07489013671875 0.00844573974609375 -0.00844573974609375 -0.0066680908203125 0.165771484375 0.1026611328125 0.054290771484375 0.19189453125 0.0194854736328125 -0.001277923583984375 0.012725830078125 0.046905517578125 0.00926971435546875 0.125244140625 0.337158203125 0.0272674560546875
235 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 2018-02-20T22:44:29+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 74183483f655417535a43a9079a67c53ff2acbbc6b37777f85eb86ac69004e86 1442760 37.74223666666666 -122.44938666666667 0 0 0 0 0 0 0 0 San Francisco CA United States 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 0.478515625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00046372413635253906 0.0435791015625 0.01016998291015625 0.009999999776482582 0.0477294921875 -0.03656005859375 0.470703125 0.0010118484497070312 -0.005062103271484375 -0.025604248046875 -0.10418701171875 0.076904296875 0.10504150390625 0.01800537109375 0.0142822265625 -0.007579803466796875 0.00345611572265625 0.02215576171875 0.00563812255859375 -0.0889892578125 0.0272216796875 -0.0110015869140625
69 9468663F-697C-4833-BBEA-9756226529DB 2018-02-20T22:44:21+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 1f3ad6ae50efd04f7fd3ff5861414c5f236b8556499303316f3966b3163b6986 1753623 37.74221333333333 -122.44943333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 9468663F-697C-4833-BBEA-9756226529DB 0.53857421875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0032596588134765625 0.0238037109375 0.006290435791015625 0.009999999776482582 0.02099609375 -0.1414794921875 -0.0567626953125 0.039703369140625 -0.00881195068359375 -0.01458740234375 -0.142822265625 -0.05810546875 0.0296478271484375 0.236083984375 0.01053619384765625 0.000308990478515625 0.00609588623046875 0.042388916015625 0.07867431640625 0.0105133056640625 0.1658935546875 0.257568359375
140 7A98496A-6D5F-4DE6-AD5D-E39097D7596D 2018-02-20T22:42:22+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 429b9d26c7410b850f0f3ae97746ff6c389904d37ef4237e49c78b73f497f796 1358539 37.74255 -122.44921166666667 0 0 0 0 0 0 0 0 San Francisco CA United States 7A98496A-6D5F-4DE6-AD5D-E39097D7596D 0.295166015625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.022796630859375 0.0528564453125 0.007518768310546875 0.009999999776482582 -0.677734375 -0.05340576171875 -0.1739501953125 0.2073974609375 -0.0401611328125 -0.02410888671875 -0.2125244140625 -0.413330078125 0.0299224853515625 0.047027587890625 -0.00475311279296875 -0.00228118896484375 0.003482818603515625 0.013427734375 -0.10382080078125 0.0002288818359375 -0.049591064453125 0.016357421875
170 D382083C-7911-43C1-92C6-851050CD2A85 2018-02-20T22:40:44+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 561df5b88b9b2f15322135b94a627a3d87fd42b112ebe28ea48d8f0eaa55f583 805481 37.742428333333336 -122.449425 0 0 0 0 0 0 0 0 San Francisco CA United States D382083C-7911-43C1-92C6-851050CD2A85 0.53759765625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0030517578125 0.032196044921875 0.02752685546875 0.009999999776482582 -0.15478515625 -0.0809326171875 -0.0926513671875 0.023773193359375 -0.0120086669921875 -0.0382080078125 0.04833984375 -0.1563720703125 0.01678466796875 0.24853515625 0.0092926025390625 0.01267242431640625 0.00841522216796875 0.006717681884765625 -0.0152740478515625 0.008392333984375 -0.022735595703125 0.1077880859375
175 978E05B3-A903-4F27-A219-92603A4880B5 2018-02-20T22:37:35+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 58aaabde35000d8e8e205450afb85f50f7aa66fcfe7ccd67fa873f6a1f32e60f 1770398 37.742308333333334 -122.44956166666667 1 0 0 0 0 0 0 0 San Francisco CA United States 978E05B3-A903-4F27-A219-92603A4880B5 0.470458984375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0018892288208007812 0.009368896484375 0.0017414093017578125 0.009999999776482582 -0.03662109375 -0.103759765625 0.056243896484375 0.0068511962890625 -0.015899658203125 -0.037567138671875 -0.27294921875 -0.12939453125 0.02947998046875 0.02142333984375 0.001251220703125 -0.0097808837890625 0.002620697021484375 0.03656005859375 -0.001678466796875 -0.088623046875 0.303466796875 0.0738525390625
58 62F1FD9A-238A-48F0-A160-D8161D869C62 2018-02-20T22:35:02+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 1bbd2919e25cc7db0ea143d403e2aa89b5bcec3753bffed9c243392c70eb9a7a 1713566 37.742533333333334 -122.44920333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 62F1FD9A-238A-48F0-A160-D8161D869C62 0.4814453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004230499267578125 0.0221710205078125 0.006931304931640625 0.009999999776482582 0.262451171875 -0.0784912109375 -0.10540771484375 0.0256195068359375 -0.0205230712890625 -0.017425537109375 0.132568359375 -0.220947265625 0.0139007568359375 0.2242431640625 0.00710296630859375 0.000904083251953125 0.007518768310546875 0.028167724609375 -0.0750732421875 0.0860595703125 0.386474609375 0.369384765625
477 C27C5D9A-2461-411A-BB8B-E26B50B84EED 2018-02-20T22:32:43+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic f4024447b47d525ee5f7931f3655f798d5555ebaaca068afd123b8304986ac36 1569856 37.742375 -122.44946333333333 0 0 0 0 0 0 0 0 San Francisco CA United States C27C5D9A-2461-411A-BB8B-E26B50B84EED 0.41748046875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004039764404296875 0.037567138671875 0.0070953369140625 0.009999999776482582 -0.0341796875 -0.11614990234375 0.00164794921875 0.0582275390625 -0.01107025146484375 -0.0121002197265625 -0.1986083984375 0.051025390625 0.03985595703125 0.190185546875 0.023345947265625 0.00031280517578125 0.0041351318359375 0.054290771484375 0.174560546875 0.006622314453125 0.11181640625 0.220947265625
108 499ABED7-CDCD-4A72-B9FD-21DD54B6008F 2018-02-20T22:21:26+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 35466149067766d36bc97080600b0a469758eeab0b3eb1db2faf12a080486102 1814157 37.74257166666666 -122.44925 0 0 0 0 0 0 0 0 San Francisco CA United States 499ABED7-CDCD-4A72-B9FD-21DD54B6008F 0.2783203125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00130462646484375 0.03997802734375 0.01049041748046875 0.009999999776482582 0.36865234375 -0.07586669921875 -0.04473876953125 0.01142120361328125 -0.0103302001953125 -0.03631591796875 0.1702880859375 -0.0628662109375 0.0207977294921875 0.326171875 0.01084136962890625 0.00504302978515625 0.00864410400390625 0.016845703125 -0.0132598876953125 0.038330078125 0.1710205078125 0.299560546875
200 6BC8E43D-D175-4C2C-9811-620B706BA25C 2018-02-20T22:19:23+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 64a2e91c1797aa9d321bc03cd37cea5196eab51f8fbc71d1756a94fc445de228 1718131 37.742295 -122.44936333333334 0 0 0 0 0 0 0 0 San Francisco CA United States 6BC8E43D-D175-4C2C-9811-620B706BA25C 0.343017578125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.001461029052734375 0.0309600830078125 0.003635406494140625 0.009999999776482582 0.36328125 -0.0439453125 0.01763916015625 0.0143890380859375 -0.0125732421875 0.00060272216796875 0.223876953125 0.037109375 0.015838623046875 0.1849365234375 0.0128173828125 0.00079345703125 0.0059814453125 0.12359619140625 0.0787353515625 0.2156982421875 0.68115234375 0.236083984375
100 8E749F41-CDCA-439E-835F-14053B963103 2018-02-20T22:12:04+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 301d0b2735e3a4e7d05bf3993349a8186e62ca0bcd04adb6279ccd9a1f6ddd28 1497339 37.74223333333333 -122.449395 0 0 0 0 0 0 0 0 San Francisco CA United States 8E749F41-CDCA-439E-835F-14053B963103 0.404052734375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.001789093017578125 0.028564453125 0.005001068115234375 0.009999999776482582 0.5234375 -0.06451416015625 -0.06884765625 0.02288818359375 -0.01450347900390625 -0.00882720947265625 0.246337890625 -0.0582275390625 0.0154876708984375 0.29833984375 0.0076904296875 0.0025615692138671875 0.00861358642578125 0.039276123046875 -0.0272064208984375 0.0843505859375 0.496826171875 0.64306640625
4 A5F7470B-9015-4627-B3D1-3CD07B8A4587 2018-02-20T22:11:41+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 02cef561a7959e4f67b4e8502ce0d6cddaed2a11a1c6c819a66fee309422db0f 1931278 37.742216666666664 -122.44947 0 0 0 0 0 0 0 0 San Francisco CA United States A5F7470B-9015-4627-B3D1-3CD07B8A4587 0.4326171875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0034160614013671875 0.026031494140625 0.0215301513671875 0.009999999776482582 0.034423828125 -0.0469970703125 -0.07958984375 0.01490020751953125 -0.0182647705078125 -0.0205078125 0.13037109375 -0.2037353515625 0.019500732421875 0.14794921875 0.00936126708984375 0.001232147216796875 0.00885009765625 0.0101318359375 -0.0224456787109375 0.037567138671875 0.0838623046875 0.063720703125
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

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