photos_with_apple_metadata (view)

26 rows where ZBEHAVIORALSCORE = "0.10000000149011612" and albums = "["Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public"]"

✎ View and edit SQL

This data as json, CSV (advanced)

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

rowid photo uuid date albums persons ext sha256 size latitude longitude favorite portrait screenshot slow_mo time_lapse hdr selfie panorama place_city place_state_province place_country ZUUID ZOVERALLAESTHETICSCORE ZCURATIONSCORE ZPROMOTIONSCORE ZHIGHLIGHTVISIBILITYSCORE ZBEHAVIORALSCORE ZFAILURESCORE ZHARMONIOUSCOLORSCORE ZIMMERSIVENESSSCORE ZINTERACTIONSCORE ZINTERESTINGSUBJECTSCORE ZINTRUSIVEOBJECTPRESENCESCORE ZLIVELYCOLORSCORE ZLOWLIGHT ZNOISESCORE ZPLEASANTCAMERATILTSCORE ZPLEASANTCOMPOSITIONSCORE ZPLEASANTLIGHTINGSCORE ZPLEASANTPATTERNSCORE ZPLEASANTPERSPECTIVESCORE ZPLEASANTPOSTPROCESSINGSCORE ZPLEASANTREFLECTIONSSCORE ZPLEASANTSYMMETRYSCORE ZSHARPLYFOCUSEDSUBJECTSCORE ZTASTEFULLYBLURREDSCORE ZWELLCHOSENSUBJECTSCORE ZWELLFRAMEDSUBJECTSCORE ZWELLTIMEDSHOTSCORE
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 240.334ms · About: dogsheep/dogsheep-photos