This data as json, CSV (advanced)
Suggested facets: albums, persons, favorite, panorama, place_city, place_state_province, place_country, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
339 | ![]() |
DEA5349B-F370-47FA-97E1-5ABAEED723AD | 2020-04-15T17:04:12+00:00 | [ "Photography Homework April 16 2020", "Public" ] |
[] |
jpeg | a46d88c4fd16f02e47b319814f895096eafa231c6844565851d5071bdadddd37 | 4466223 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DEA5349B-F370-47FA-97E1-5ABAEED723AD | 0.81689453125 | 0.75 | 0.0 | 0.0626261907679434 | 0.5067639946937561 | -0.0010900497436523438 | 0.0285491943359375 | 0.0036067962646484375 | 0.03999999910593033 | 0.5546875 | -0.036285400390625 | 0.007415771484375 | 0.023773193359375 | -0.021453857421875 | 0.0043182373046875 | 0.25830078125 | 0.052490234375 | 0.021087646484375 | 0.2227783203125 | 0.0179290771484375 | 0.0009918212890625 | 0.0090179443359375 | 0.1263427734375 | 0.0472412109375 | 0.2783203125 | 0.77734375 | 0.314453125 | |||||
53 | ![]() |
9AEC59F0-3F75-4204-B714-152B697AD6F0 | 2020-01-25T19:20:41+00:00 | [ "Public" ] |
[] |
jpeg | 1a002a90928b3ebf1cfc5e4a2e274f9e8a14345a634cb05751ad1ce3da6b7c52 | 5012912 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9AEC59F0-3F75-4204-B714-152B697AD6F0 | 0.62548828125 | 0.75 | 0.0 | 0.06110454879644263 | 0.10000000149011612 | -0.00263214111328125 | -0.005542755126953125 | 0.0029010772705078125 | 0.03999999910593033 | -0.005126953125 | -0.08978271484375 | 0.12939453125 | 0.00646209716796875 | -0.04327392578125 | -0.09356689453125 | -0.4306640625 | -0.2392578125 | 0.1856689453125 | -0.10101318359375 | -0.0021648406982421875 | -0.0205535888671875 | 0.0036220550537109375 | 0.0050201416015625 | -0.02783203125 | -0.452880859375 | -0.1956787109375 | -0.0889892578125 | |||||
9 | ![]() |
6FDA5781-8D5F-4369-9F26-C605FF4ECFE4 | 2019-12-28T10:29:00+00:00 | [ "Public" ] |
[] |
heic | 041612eaccc0c5724b4613995a12106e7dd7e1f68555c7db4924523c8d6bcde1 | 3060174 | 50.69708833 | -3.18944667 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Sidmouth | England | United Kingdom | 6FDA5781-8D5F-4369-9F26-C605FF4ECFE4 | 0.55859375 | 0.75 | 0.0 | 0.8213740458129016 | 0.10000000149011612 | -0.01358795166015625 | -0.0102996826171875 | 0.0026836395263671875 | 0.03999999910593033 | -0.194091796875 | -0.09136962890625 | 0.0579833984375 | 0.01302337646484375 | -0.09771728515625 | -0.11468505859375 | -0.486328125 | -0.419189453125 | 0.2086181640625 | -0.1304931640625 | -0.003662109375 | -0.0751953125 | 0.0038852691650390625 | 0.0029239654541015625 | -0.1339111328125 | -0.477783203125 | -0.30859375 | -0.1309814453125 |
164 | ![]() |
659F6A3E-8547-476F-B2AA-883117C53253 | 2019-12-17T10:05:40+00:00 | [ "Public" ] |
[] |
heic | 51f4b1c7d3691bd32170d7f1f343c25e4ce687a3474675501e5295fb8de1e233 | 2625105 | 51.52467832999999 | -0.11347499999999999 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | London | England | United Kingdom | 659F6A3E-8547-476F-B2AA-883117C53253 | 0.33251953125 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.006488800048828125 | -0.0045318603515625 | 0.0008692741394042969 | 0.03999999910593033 | 0.53564453125 | -0.09771728515625 | -0.21630859375 | 0.0849609375 | -0.233154296875 | -0.0269775390625 | -0.2191162109375 | -0.67626953125 | 0.0322265625 | -0.0523681640625 | -0.0008630752563476562 | -0.0160675048828125 | 0.0057525634765625 | 0.01142120361328125 | -0.115234375 | -0.48876953125 | 0.54541015625 | -0.01934814453125 |
50 | ![]() |
B0F72802-C713-43D3-899A-81C4AED347DC | 2019-11-02T20:32:07+00:00 | [ "Public" ] |
[] |
jpeg | 18e73d3bafa71dfc897bb8f8059380c9895372347b59199a31c464bca7fba1d9 | 4949434 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | B0F72802-C713-43D3-899A-81C4AED347DC | 0.79150390625 | 0.75 | 0.0 | 0.06261464384675935 | 0.10000000149011612 | -0.0027790069580078125 | -0.003040313720703125 | 0.0018463134765625 | 0.03999999910593033 | 0.2215576171875 | -0.05780029296875 | 0.063232421875 | 0.00916290283203125 | -0.085693359375 | -0.040863037109375 | -0.1737060546875 | -0.291259765625 | 0.11456298828125 | -0.05914306640625 | -0.00067138671875 | -0.021148681640625 | 0.00473785400390625 | 0.00933837890625 | -0.023468017578125 | -0.37060546875 | 0.235595703125 | -0.053070068359375 | |||||
422 | ![]() |
BA1C8565-7D1C-49E3-93BA-183B8D6B1270 | 2019-11-02T20:31:29+00:00 | [ "Public" ] |
[] |
jpeg | d687723405fc71baa66683d64212af08b36f0db1cb5caa9e01c61c262d02cfc3 | 4246410 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BA1C8565-7D1C-49E3-93BA-183B8D6B1270 | 0.84228515625 | 0.75 | 0.0 | 0.06261613123289501 | 0.10000000149011612 | -0.0006117820739746094 | 0.0157012939453125 | 0.0020351409912109375 | 0.03999999910593033 | 0.599609375 | -0.06622314453125 | 0.10491943359375 | 0.01009368896484375 | -0.015838623046875 | 0.00726318359375 | 0.02276611328125 | -0.0177001953125 | 0.07318115234375 | 0.0751953125 | 0.00572967529296875 | -0.008392333984375 | 0.00867462158203125 | 0.0836181640625 | 0.047119140625 | -0.158203125 | 0.68798828125 | 0.1689453125 | |||||
152 | ![]() |
A40BDBBE-2DC6-4385-8108-8C15F37610B4 | 2019-11-02T20:30:59+00:00 | [ "Public" ] |
[] |
jpeg | 48e96bb66208e6f03b85428cde82ab3ae651d3134a078ef4ea1b4f32d1b4c02c | 4629001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | A40BDBBE-2DC6-4385-8108-8C15F37610B4 | 0.54931640625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.001918792724609375 | -0.00484466552734375 | 0.002834320068359375 | 0.03999999910593033 | 0.165283203125 | -0.04052734375 | 0.24755859375 | 0.0024623870849609375 | -0.04595947265625 | -0.04052734375 | -0.1414794921875 | -0.1551513671875 | 0.20751953125 | -0.065673828125 | -0.00061798095703125 | -0.0300750732421875 | 0.005161285400390625 | 0.00844573974609375 | -0.01395416259765625 | -0.49267578125 | 0.1368408203125 | -0.09515380859375 | |||||
161 | ![]() |
0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A | 2019-11-02T20:23:51+00:00 | [ "Public" ] |
[] |
jpeg | 4f164a611976a9ab84deac5a5aeb875bac3cfdbcb21852a8e4bcbdf8e38e7e90 | 5127846 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A | 0.6171875 | 0.5 | 0.0 | 0.0420040488243103 | 0.10000000149011612 | -0.0006799697875976562 | 0.0157928466796875 | 0.01085662841796875 | 0.03999999910593033 | 0.0447998046875 | -0.04351806640625 | 0.267578125 | 0.0020503997802734375 | -0.00844573974609375 | -0.02105712890625 | -0.161376953125 | 0.03826904296875 | 0.12213134765625 | 0.011474609375 | 0.0068359375 | -0.0125885009765625 | 0.005706787109375 | 0.0153045654296875 | 0.002277374267578125 | -0.194580078125 | 0.0333251953125 | -0.00848388671875 | |||||
277 | ![]() |
0C7F8BD3-7996-4FBD-A886-2D885AC7F618 | 2019-09-15T15:36:30+00:00 | [ "Public" ] |
[] |
heic | 847b6ce3e30394f5485d356528eea16a644e0a2b54d1a7727c03011f8c54b554 | 1716536 | 30.24152 | -89.67729166666666 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Slidell | LA | United States | 0C7F8BD3-7996-4FBD-A886-2D885AC7F618 | 0.5712890625 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0014781951904296875 | 0.016510009765625 | 0.008575439453125 | 0.03999999910593033 | -0.235107421875 | -0.05291748046875 | 0.2169189453125 | 0.00669097900390625 | -0.01214599609375 | -0.043487548828125 | -0.1904296875 | -0.03326416015625 | 0.430908203125 | 0.0216064453125 | 0.00054931640625 | -0.0718994140625 | 0.0169830322265625 | 0.0224609375 | 0.0220794677734375 | -0.1822509765625 | -0.0218505859375 | -0.0104827880859375 |
184 | ![]() |
36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E | 2019-09-15T12:44:16+00:00 | [ "Public" ] |
[] |
jpeg | 5b2f88615086a37d0dcf66c5e60375212ed0f3927e8e720159524729f873bd41 | 5313920 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E | 0.48486328125 | 0.75 | 0.0 | 0.05801526718694745 | 0.5043065547943115 | -0.0008559226989746094 | 0.022125244140625 | 0.0018825531005859375 | 0.03999999910593033 | 0.58203125 | -0.05633544921875 | 0.005279541015625 | 0.06903076171875 | -0.01267242431640625 | 0.0079498291015625 | 0.2421875 | 0.242919921875 | 0.011505126953125 | 0.1534423828125 | 0.0126800537109375 | 0.001617431640625 | 0.005535125732421875 | 0.373291015625 | 0.41796875 | 0.06787109375 | 0.84716796875 | 0.3896484375 | |||||
159 | ![]() |
BF9CEE04-8E45-4586-BC61-7E5921483763 | 2019-09-15T12:32:01+00:00 | [ "Public" ] |
[] |
jpeg | 4d716099e85d3ba064b1cfbc236fc58381dc15b17ce4368141d10a39747b7998 | 4386363 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BF9CEE04-8E45-4586-BC61-7E5921483763 | 0.712890625 | 0.75 | 0.0 | 0.06263033715823224 | 0.5045985579490662 | -0.0006413459777832031 | 0.0499267578125 | 0.0026721954345703125 | 0.03999999910593033 | 0.54931640625 | -0.041473388671875 | 0.035003662109375 | 0.0394287109375 | -0.0082550048828125 | 0.00948333740234375 | 0.360107421875 | 0.301025390625 | 0.0127716064453125 | 0.260986328125 | 0.0268707275390625 | 0.00336456298828125 | 0.00653839111328125 | 0.37060546875 | 0.29248046875 | 0.223876953125 | 0.8359375 | 0.3427734375 | |||||
437 | ![]() |
23F1ACC2-DF35-42BD-9332-A3C51B9AA8C6 | 2019-08-21T16:05:25+00:00 | [ "Public" ] |
[] |
jpeg | dcf001e183e3e0ed9142c734eb751eb0992e7b14651845c9c3df40a491322b6d | 7003984 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23F1ACC2-DF35-42BD-9332-A3C51B9AA8C6 | 0.68896484375 | 0.75 | 0.0 | 0.061103805785870734 | 0.7047201991081238 | -0.000583648681640625 | 0.0305023193359375 | 0.0018606185913085938 | 0.03999999910593033 | 0.79833984375 | -0.047943115234375 | 0.031646728515625 | 0.0161590576171875 | -0.0041351318359375 | 0.00727081298828125 | 0.41015625 | 0.318359375 | 0.01507568359375 | 0.22802734375 | 0.01171112060546875 | 0.00311279296875 | 0.006313323974609375 | 0.5595703125 | 0.74560546875 | 0.13330078125 | 0.8798828125 | 0.66357421875 | |||||
299 | ![]() |
DD6E4630-85BD-41BF-A7B3-524C02942A65 | 2019-03-24T17:53:38+00:00 | [ "Super bloom 2019", "Public" ] |
[] |
heic | 8f49702a9cdd8ab729df55e30f2394524312f7f972c3e6c1615fe457b6bac72c | 9765384 | 34.738725 | -118.38710833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | Lancaster | CA | United States | DD6E4630-85BD-41BF-A7B3-524C02942A65 | 0.61279296875 | 0.5 | 0.0 | 0.04201835029907809 | 0.503333330154419 | -0.0020904541015625 | 0.115478515625 | 0.00547027587890625 | 0.03999999910593033 | -0.006591796875 | -0.040313720703125 | 0.2203369140625 | 0.0150146484375 | -0.00392913818359375 | 0.002899169921875 | 0.1368408203125 | 0.185791015625 | 0.10894775390625 | 0.177490234375 | 0.031951904296875 | 0.001537322998046875 | 0.00453948974609375 | 0.251953125 | 0.67138671875 | 0.09588623046875 | 0.296142578125 | 0.0736083984375 |
41 | ![]() |
5392047B-DF94-46CF-BA61-06ECE4D8CD9E | 2018-05-18T19:45:49+00:00 | [ "Museums", "Public" ] |
[] |
heic | 14efd697b9572b24b1853d1a3effab60609c0fcb477ad4739e85194c32afe8ba | 1849449 | 37.0415695 | -122.0726305 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Felton | CA | United States | 5392047B-DF94-46CF-BA61-06ECE4D8CD9E | 0.43701171875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0020503997802734375 | 0.0012054443359375 | 0.00266265869140625 | 0.03999999910593033 | -0.0677490234375 | -0.093505859375 | 0.361328125 | 0.0033111572265625 | -0.01525115966796875 | -0.0430908203125 | -0.4287109375 | -0.0633544921875 | 0.1295166015625 | -0.07568359375 | -0.00975799560546875 | -0.01381683349609375 | 0.0014162063598632812 | 0.01934814453125 | 0.02264404296875 | -0.5283203125 | -0.20849609375 | -0.10821533203125 |
291 | ![]() |
C8CCC8EE-382E-4265-8236-E2F30764A55C | 2018-04-21T23:55:50+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | 8d0760a255defeab12023c2ad8704cab6b5bd9d20c69bd325ea242a6b22402a9 | 1719608 | 37.57926666666667 | -122.3442 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | C8CCC8EE-382E-4265-8236-E2F30764A55C | 0.2325439453125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0028228759765625 | -0.00146484375 | 0.0015306472778320312 | 0.03999999910593033 | 0.1011962890625 | -0.07305908203125 | 0.1485595703125 | 0.006511688232421875 | -0.046722412109375 | -0.03564453125 | -0.249755859375 | -0.18994140625 | 0.0582275390625 | -0.07696533203125 | -0.0020275115966796875 | -0.0162353515625 | 0.0019044876098632812 | 0.0194244384765625 | -0.01031494140625 | -0.405029296875 | 0.190185546875 | -0.0648193359375 |
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 | ||
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 |
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 |
220 | ![]() |
BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 | 2015-10-05T14:55:32+00:00 | [ "Museums", "Niche museums", "Public" ] |
[] |
jpeg | 6f0558a227b6c1acc2259af4e4d3d6aac4ce7148cda96ad212c4a6fd45ef36a1 | 2840560 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 | 0.3583984375 | 0.5 | 0.0 | 0.038931297721298594 | 0.5039172768592834 | -0.0008168220520019531 | 0.03851318359375 | 0.001949310302734375 | 0.03999999910593033 | 0.2958984375 | -0.03314208984375 | 0.058319091796875 | 0.0271759033203125 | -0.007038116455078125 | 0.0072479248046875 | 0.328125 | 0.2447509765625 | 0.01450347900390625 | 0.1962890625 | 0.0167236328125 | 0.000606536865234375 | 0.006488800048828125 | 0.58203125 | 0.58935546875 | 0.2381591796875 | 0.88427734375 | 0.1051025390625 |
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;