This data as json, CSV (advanced)
Suggested facets: ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, date (date), albums (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
279 | A8949702-A151-4ACD-8F3C-D5957F481E5A | 2018-02-13T18:55:13+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | 85d802ffe4def2a666fed10fe1da638ef804d8e499a8899c23471705df60163c | 5342238 | 25.736453769238338 | -111.09069569453112 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | A8949702-A151-4ACD-8F3C-D5957F481E5A | 0.72412109375 | 0.5 | 0.0 | 0.04353076629056275 | 0.10000000149011612 | -0.0010480880737304688 | 0.025848388671875 | 0.0018033981323242188 | 0.009999999776482582 | -0.166748046875 | -0.020172119140625 | 0.36181640625 | 0.0021991729736328125 | -0.016845703125 | 0.00335693359375 | 0.013946533203125 | 0.0294189453125 | 0.1356201171875 | 0.03472900390625 | 0.0109405517578125 | -0.019073486328125 | 0.00391387939453125 | 0.1959228515625 | 0.1380615234375 | 0.236572265625 | 0.525390625 | -0.006011962890625 | |||
400 | 2B30643F-7BEC-4E40-8C9F-BF0994C38197 | 2018-02-13T18:55:11+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | c737f0db8b99bd2bff7581902d55319005ce8f7557654af7d985e66e91bfdb85 | 5545619 | 25.73648106575451 | -111.09070456885036 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | 2B30643F-7BEC-4E40-8C9F-BF0994C38197 | 0.5947265625 | 0.5 | 0.0 | 0.042004234918201246 | 0.10000000149011612 | -0.0022602081298828125 | -0.00171661376953125 | 0.00908660888671875 | 0.009999999776482582 | -0.2548828125 | -0.059112548828125 | 0.2274169921875 | 0.0010442733764648438 | -0.01751708984375 | -0.12164306640625 | -0.4638671875 | -0.110595703125 | 0.2010498046875 | -0.132080078125 | 0.0008869171142578125 | -0.0180816650390625 | 0.00266265869140625 | 0.002521514892578125 | -0.0098876953125 | -0.1746826171875 | -0.50390625 | -0.057098388671875 | |||
358 | 3E327FD2-CC19-4BF0-9D1B-9833A3D2F6B4 | 2018-02-13T18:53:52+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | adc26d4f5ae813f2a5a6281653f515dc245ff351973f99c342bb23015a175d48 | 5176004 | 25.737328762300947 | -111.09098016188648 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | 3E327FD2-CC19-4BF0-9D1B-9833A3D2F6B4 | 0.78125 | 0.5 | 0.0 | 0.04353485262120953 | 0.10000000149011612 | -0.0012254714965820312 | 0.042755126953125 | 0.00279998779296875 | 0.019999999552965164 | -0.191650390625 | -0.05987548828125 | 0.419189453125 | 0.00734710693359375 | -0.013427734375 | -0.05120849609375 | -0.2137451171875 | 0.0130615234375 | 0.5712890625 | 0.00146484375 | 0.0055694580078125 | -0.016815185546875 | 0.0070953369140625 | 0.0709228515625 | 0.15087890625 | -0.163330078125 | 0.04150390625 | -0.0222625732421875 | |||
270 | 801ECB04-F7C1-4D36-8B07-6B52B80E74A0 | 2018-02-13T18:53:51+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | 822075bc99101363c0c066542717adc5187c66b924e4a7e353e33f8e186614e6 | 4974082 | 25.73733306096472 | -111.090981559417 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | 801ECB04-F7C1-4D36-8B07-6B52B80E74A0 | 0.8330078125 | 0.75 | 0.0 | 0.06261723005134641 | 0.7075669169425964 | -0.0026416778564453125 | 0.0203857421875 | 0.0023136138916015625 | 0.03999999910593033 | 0.49658203125 | -0.09173583984375 | -0.0142822265625 | 0.024993896484375 | -0.0110321044921875 | 0.0013427734375 | 0.094482421875 | 0.013671875 | 0.0121002197265625 | 0.1624755859375 | 0.007904052734375 | 0.0004119873046875 | 0.0034427642822265625 | 0.149169921875 | 0.28857421875 | 0.085205078125 | 0.65380859375 | 0.52685546875 | |||
329 | D2E8BA79-361D-4888-BCE6-80E7DEE2D5D8 | 2018-02-13T18:53:48+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | a02327731c68afc82e3f442932167fd2a273ea95c0fa968b0199a73141dd99f4 | 5960871 | 25.737367127877967 | -111.09099263484735 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | D2E8BA79-361D-4888-BCE6-80E7DEE2D5D8 | 0.76025390625 | 0.5 | 0.0 | 0.04353076629056275 | 0.10111922025680542 | -0.00070953369140625 | 0.08514404296875 | 0.003692626953125 | 0.05999999865889549 | 0.16162109375 | -0.01812744140625 | 0.403076171875 | 0.00274658203125 | -0.0069580078125 | 0.005615234375 | 0.1458740234375 | 0.09783935546875 | 0.054290771484375 | 0.1104736328125 | 0.02960205078125 | -0.00168609619140625 | 0.00441741943359375 | 0.157958984375 | 0.078125 | 0.41064453125 | 0.6162109375 | 0.0361328125 | |||
115 | 0CE448B6-E909-49F0-B97C-1F2408D08970 | 2018-02-13T18:53:30+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | 38ac35357f78510ec06848a345c246078c7b34b6c8e5d7e948abd47972191bee | 4216224 | 25.737556161627715 | -111.0910540912556 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | 0CE448B6-E909-49F0-B97C-1F2408D08970 | 0.75390625 | 0.5 | 0.0 | 0.04355379734330505 | 0.10000000149011612 | -0.001964569091796875 | 0.007537841796875 | 0.0024929046630859375 | 0.009999999776482582 | -0.51953125 | -0.08526611328125 | 0.1845703125 | 0.0068511962890625 | -0.015777587890625 | -0.04339599609375 | -0.45849609375 | -0.04498291015625 | 0.060211181640625 | -0.04827880859375 | -0.00525665283203125 | -0.01410675048828125 | 0.0017681121826171875 | 0.0394287109375 | 0.03216552734375 | -0.214599609375 | -0.0538330078125 | -0.0259857177734375 | |||
84 | D034D20E-18D9-4AD1-9769-370479278F00 | 2018-02-13T18:53:30+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | 24eeded69d88226a99379f511471520babc37d185ec0f5ab3eea64a665c9e2eb | 4634606 | 25.737564651490043 | -111.09105685137882 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | D034D20E-18D9-4AD1-9769-370479278F00 | 0.73828125 | 0.5 | 0.0 | 0.04355491163166425 | 0.10000000149011612 | -0.0007762908935546875 | 0.028778076171875 | 0.005889892578125 | 0.009999999776482582 | -0.0697021484375 | -0.10302734375 | 0.28955078125 | 0.004451751708984375 | -0.004848480224609375 | -0.032440185546875 | -0.448486328125 | 0.0633544921875 | 0.0836181640625 | 0.00860595703125 | -0.00177764892578125 | -0.006500244140625 | 0.0023326873779296875 | 0.0192718505859375 | 0.0137786865234375 | -0.27978515625 | -0.2005615234375 | 0.02301025390625 | |||
386 | B0B115AB-2687-46D9-96F5-AC20AFCC2DE3 | 2018-02-13T18:53:29+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | c13ac4447cee546dd7fa9849cff176203e61e63473dcf4244f305cefd49f1e1a | 5277926 | 25.737572066684827 | -111.09105926211892 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | B0B115AB-2687-46D9-96F5-AC20AFCC2DE3 | 0.69580078125 | 0.5 | 0.0 | 0.0420047918348822 | 0.10000000149011612 | -0.003124237060546875 | 0.015869140625 | 0.0058441162109375 | 0.009999999776482582 | -0.9169921875 | -0.035736083984375 | 0.1015625 | 0.0050811767578125 | -0.0092315673828125 | -0.016448974609375 | -0.2066650390625 | -0.03790283203125 | 0.03704833984375 | 0.0347900390625 | -0.017333984375 | -0.008209228515625 | 0.0029354095458984375 | 0.032958984375 | 0.0123291015625 | 0.0260772705078125 | -0.0037841796875 | -0.00052642822265625 | |||
89 | 12BFF8C2-D12C-48D7-B752-EFA7AB1B30AF | 2018-02-13T18:53:29+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | 269b74a5ba4d63efb5f540a0400269a41b28cc9faf16f199e9cfa0da95c29846 | 5296111 | 25.737576472815096 | -111.09106069458767 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | 12BFF8C2-D12C-48D7-B752-EFA7AB1B30AF | 0.72119140625 | 0.5 | 0.0 | 0.043530952384453696 | 0.10000000149011612 | -0.0031108856201171875 | 0.00571441650390625 | 0.004055023193359375 | 0.009999999776482582 | -0.904296875 | -0.02532958984375 | 0.07891845703125 | 0.0011157989501953125 | -0.0118255615234375 | -0.006046295166015625 | -0.01544189453125 | -0.06072998046875 | 0.01358795166015625 | 0.019683837890625 | -0.0296630859375 | -0.007640838623046875 | 0.002471923828125 | 0.058441162109375 | 0.0153961181640625 | 0.1890869140625 | 0.40625 | 0.000896453857421875 | |||
269 | 7705FF4E-2F25-45B9-B795-EA58244F3273 | 2018-02-13T18:53:28+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | 81f94d4de59b28e89df4ff8ac3a7250e624cbd261e7d93701e6a8cafeeeb971e | 5483241 | 25.737587971741938 | -111.09106443298224 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | 7705FF4E-2F25-45B9-B795-EA58244F3273 | 0.708984375 | 0.5 | 0.0 | 0.043553611249414106 | 0.10000000149011612 | -0.06915283203125 | -0.00589752197265625 | 0.00208282470703125 | 0.019999999552965164 | -0.390869140625 | -0.14306640625 | -0.1083984375 | 0.0775146484375 | -0.12322998046875 | -0.06463623046875 | -0.58837890625 | -0.66650390625 | 0.024566650390625 | -0.1026611328125 | -0.0028285980224609375 | -0.06109619140625 | 0.0018100738525390625 | 0.00464630126953125 | -0.52734375 | -0.286376953125 | -0.095458984375 | -0.10565185546875 | |||
8 | DBF7A6F2-B2FF-40F5-9F28-0341ED45C1A6 | 2018-02-13T18:53:28+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | 040edf81a4877738fba679c0928af0a7c3f55b12c8ff6a934d38c713ababacb0 | 5763520 | 25.73758141627914 | -111.09106230174801 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | DBF7A6F2-B2FF-40F5-9F28-0341ED45C1A6 | 0.7177734375 | 0.5 | 0.0 | 0.043530951929456406 | 0.10000000149011612 | -0.0030040740966796875 | 0.0210113525390625 | 0.00714874267578125 | 0.009999999776482582 | -0.95703125 | -0.019989013671875 | 0.10723876953125 | 0.0011968612670898438 | -0.00482940673828125 | -0.0050811767578125 | 0.07281494140625 | -0.00738525390625 | 0.0224609375 | 0.050537109375 | -0.05157470703125 | -0.0038967132568359375 | 0.00392913818359375 | 0.06109619140625 | 0.0204315185546875 | 0.1607666015625 | 0.280029296875 | 0.0031585693359375 | |||
182 | A945D44B-B701-4FD6-B264-0D4F5683EA2A | 2018-02-13T18:50:16+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | 5a4551e5ca2f11c04091506d7454fdea1fd75ec3a783b301a61ad8497dacf2b9 | 5964575 | 25.739937867807853 | -111.09487104411251 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | A945D44B-B701-4FD6-B264-0D4F5683EA2A | 0.67919921875 | 0.5 | 0.0 | 0.04200776342217249 | 0.10000000149011612 | -0.0014438629150390625 | 0.00983428955078125 | 0.00391387939453125 | 0.009999999776482582 | -0.029541015625 | -0.07275390625 | 0.218505859375 | 0.0018968582153320312 | -0.01560211181640625 | -0.080078125 | -0.311279296875 | -0.05316162109375 | 0.06256103515625 | -0.064697265625 | 0.00180816650390625 | -0.010772705078125 | 0.001941680908203125 | 0.01242828369140625 | -0.0088043212890625 | -0.174072265625 | -0.0482177734375 | 0.0013427734375 | |||
209 | 232FAC16-A5A7-4CF0-9E01-2B6DAE88795D | 2018-02-13T18:49:54+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | 6849da4d977ea226af6a5b5a42a58ab0fc73cf7bfc35a1e908e74bf75164802a | 5283780 | 25.740267905197804 | -111.09597236338337 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | 232FAC16-A5A7-4CF0-9E01-2B6DAE88795D | 0.54345703125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0011339187622070312 | -0.002838134765625 | 0.0015010833740234375 | 0.009999999776482582 | 0.001220703125 | -0.050140380859375 | 0.372802734375 | 0.0007886886596679688 | -0.025665283203125 | -0.055389404296875 | -0.199951171875 | -0.07366943359375 | 0.1143798828125 | -0.1328125 | -0.0012760162353515625 | -0.0303955078125 | 0.0018672943115234375 | 0.018646240234375 | 0.00119781494140625 | -0.470947265625 | 0.1363525390625 | -0.092041015625 |
JSON shape: default, array, newline-delimited
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;