This data as json, CSV (advanced)
Suggested facets: persons, favorite, place_city, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, ZLOWLIGHT, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
163 | 70B3C358-DA0D-469F-B667-F0045F445AC6 | 2020-05-19T04:31:43+00:00 | [ "Public" ] |
[] |
heic | 502fbb347dc72fbffbddb7b92326f6ddbeb6d27a77d9761fb5406bd5ab43d445 | 1070208 | 37.770916670000005 | -122.47696667 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | |||||||||||||||||||||||||||||
57 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 2020-05-15T21:57:58+00:00 | [ "Public" ] |
[] |
heic | 1bb184872fa6a61afc7e3629b45f57f161065b283d2005c2699242cade846055 | 4686204 | 37.61134667 | -122.49619167 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pacifica | CA | United States | |||||||||||||||||||||||||||||
241 | AA04E7D2-B517-4CA8-A331-7810A6902E2E | 2020-04-26T22:03:31+00:00 | [ "Public" ] |
[] |
heic | 76d0f468ebbc94845b6b2b23f44201b04f6dce627ae15f70f016c02be7336175 | 3842036 | 37.790321670000004 | -122.46161666999998 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | |||||||||||||||||||||||||||||
322 | AEFB3049-40B6-41FD-81AA-571B369B79DB | 2020-01-25T19:12:52+00:00 | [ "Public" ] |
[] |
heic | 9d24f646179a5110b384061d7911acf849957530304e5ac141b86edab4b7b3a0 | 3931472 | 37.11494717 | -122.32808 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | CA | United States | AEFB3049-40B6-41FD-81AA-571B369B79DB | 0.57421875 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0116424560546875 | -0.0101776123046875 | 0.0015544891357421875 | 0.009999999776482582 | -0.122314453125 | -0.060638427734375 | 0.0396728515625 | 0.01312255859375 | -0.190673828125 | -0.05352783203125 | -0.320556640625 | -0.4072265625 | 0.078369140625 | -0.11199951171875 | -0.00426483154296875 | -0.020172119140625 | 0.0020503997802734375 | 0.005706787109375 | -0.09417724609375 | -0.496337890625 | -0.0115966796875 | -0.14990234375 | |
177 | 22ADB1EE-854B-43F0-96D1-32CB598C0738 | 2020-01-25T18:37:22+00:00 | [ "Public" ] |
[] |
heic | 59340b9b577670a6302885117a05ce7103e612748d3de0908dcc7dd3abb232c9 | 2491863 | 37.11635832999999 | -122.33049667 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | CA | United States | 22ADB1EE-854B-43F0-96D1-32CB598C0738 | 0.51220703125 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0011739730834960938 | 0.01096343994140625 | 0.0024814605712890625 | 0.009999999776482582 | -0.0811767578125 | -0.0809326171875 | 0.170654296875 | 0.0035648345947265625 | -0.015777587890625 | -0.05615234375 | -0.2587890625 | -0.0595703125 | 0.10723876953125 | -0.0213623046875 | 0.0020751953125 | -0.01378631591796875 | 0.004100799560546875 | 0.042236328125 | 0.01824951171875 | -0.154296875 | 0.2166748046875 | -0.0029296875 | |
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 | |
39 | B5AC8228-D496-43B3-9F69-69BFB2BFF177 | 2020-01-25T18:16:15+00:00 | [ "Public" ] |
[] |
heic | 14620230b833ea022fdbed283eae903ae8e82fe27e943d5fc1fe0f502f6e9e6e | 3583698 | 37.11623049999999 | -122.33001667 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | CA | United States | B5AC8228-D496-43B3-9F69-69BFB2BFF177 | 0.62109375 | 0.75 | 0.0 | 0.061121264486822466 | 0.10000000149011612 | -0.0017480850219726562 | 0.048736572265625 | 0.0202484130859375 | 0.009999999776482582 | -0.248046875 | -0.0305633544921875 | 0.20751953125 | 0.00482940673828125 | -0.00885009765625 | -0.03643798828125 | -0.0546875 | 0.0264892578125 | 0.11395263671875 | 0.09771728515625 | 0.022735595703125 | -0.008148193359375 | 0.007373809814453125 | 0.0240478515625 | 0.01015472412109375 | 0.0221405029296875 | -0.02423095703125 | -0.0031585693359375 | |
216 | 8482D147-E926-4B79-9264-533A31F5DF2D | 2020-01-25T18:14:27+00:00 | [ "Public" ] |
[] |
heic | 6b8ef6a1de38c5e897e740c407caa88bbe307b561dac970ccd9b58f870a1f85e | 4030633 | 37.11621117 | -122.32977999999999 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | CA | United States | 8482D147-E926-4B79-9264-533A31F5DF2D | 0.5576171875 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.003749847412109375 | 0.00057220458984375 | 0.0013990402221679688 | 0.009999999776482582 | -0.48095703125 | -0.0635986328125 | -0.033203125 | 0.02685546875 | -0.08740234375 | -0.08880615234375 | -0.287841796875 | -0.361572265625 | 0.049224853515625 | -0.068603515625 | -0.0012836456298828125 | -0.0191650390625 | 0.005321502685546875 | 0.0258636474609375 | -0.032928466796875 | -0.10052490234375 | 0.369873046875 | -0.0089263916015625 | |
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 | |
154 | 5677D0CE-249B-4A35-BAF8-385BFC257924 | 2020-01-25T18:10:45+00:00 | [ "Public" ] |
[] |
heic | 4a622a5c958ecba31c02dfdeff721c261c59b7d3d08124e50d4add1e85f5e5d4 | 6296397 | 37.11521117 | -122.32787167 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | CA | United States | 5677D0CE-249B-4A35-BAF8-385BFC257924 | 0.7021484375 | 0.75 | 0.0 | 0.06264965361311235 | 0.10000000149011612 | -0.00263214111328125 | 0.04296875 | 0.007289886474609375 | 0.009999999776482582 | 0.060546875 | -0.0701904296875 | 0.12158203125 | 0.09771728515625 | -0.023651123046875 | -0.031158447265625 | -0.310791015625 | 0.005859375 | 0.15625 | 0.0482177734375 | 0.025909423828125 | -0.00234222412109375 | 0.004467010498046875 | 0.018768310546875 | 0.0256195068359375 | -0.12890625 | -0.16357421875 | 0.046478271484375 | |
32 | A8B85D87-3E69-402E-A1EA-3DD819270531 | 2020-01-25T18:09:33+00:00 | [ "Public" ] |
[] |
heic | 1307ecb271a8f7357b7151de2cd5cbec2e7232d91a2404daa5a716c0d96b4fc9 | 5610042 | 37.115119500000006 | -122.32771333000001 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | CA | United States | A8B85D87-3E69-402E-A1EA-3DD819270531 | 0.5947265625 | 0.75 | 0.0 | 0.06265151091204345 | 0.5026764273643494 | -0.00031256675720214844 | 0.032470703125 | 0.00885009765625 | 0.009999999776482582 | 0.29931640625 | -0.046112060546875 | 0.037750244140625 | 0.01751708984375 | -0.00701141357421875 | 0.006439208984375 | 0.2320556640625 | 0.2288818359375 | 0.0635986328125 | 0.2149658203125 | 0.01354217529296875 | 0.0011444091796875 | 0.0219879150390625 | 0.08123779296875 | 0.023406982421875 | 0.01483154296875 | 0.54931640625 | 0.11541748046875 | |
186 | EF60300F-550E-4921-BA04-EA972EEFF269 | 2020-01-25T18:07:06+00:00 | [ "Public" ] |
[] |
heic | 5d27b85ff783a2fa1c9e9533157ffd680c06cb957206054aa25ee5786e49ba84 | 3606179 | 37.1148555 | -122.32795000000002 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | CA | United States | EF60300F-550E-4921-BA04-EA972EEFF269 | 0.3896484375 | 0.75 | 0.0 | 0.8213740458129016 | 0.10000000149011612 | -0.0005860328674316406 | 0.007633209228515625 | 0.0016422271728515625 | 0.009999999776482582 | 0.35302734375 | -0.04132080078125 | 0.366943359375 | 0.0018825531005859375 | -0.0141143798828125 | -0.004425048828125 | -0.0386962890625 | -0.04632568359375 | 0.0894775390625 | -0.0194854736328125 | 0.0001678466796875 | -0.024871826171875 | 0.0039005279541015625 | 0.047088623046875 | 0.019256591796875 | -0.33984375 | 0.515625 | -0.01910400390625 | |
287 | 745C8ADF-08E9-48D1-98A7-01D16E49635C | 2020-01-25T18:05:50+00:00 | [ "Public" ] |
[] |
heic | 8a2c43b2888b0777a9ffa4679f13011b3bd91cd57c4fe34a5b612c1bc4ceb147 | 4185659 | 37.11481117 | -122.32784167 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | CA | United States | 745C8ADF-08E9-48D1-98A7-01D16E49635C | 0.59765625 | 0.75 | 0.0 | 0.06111754988896028 | 0.10000000149011612 | -0.0016870498657226562 | 0.003696441650390625 | 0.0010652542114257812 | 0.009999999776482582 | -0.16259765625 | -0.04876708984375 | 0.318115234375 | 0.0017547607421875 | -0.020294189453125 | -0.01739501953125 | -0.154541015625 | -0.04669189453125 | 0.061187744140625 | -0.082275390625 | -0.002925872802734375 | -0.0231170654296875 | 0.0016040802001953125 | 0.0889892578125 | 0.076416015625 | -0.24853515625 | 0.37939453125 | -0.03521728515625 | |
190 | 20B906EB-2A5F-4660-AEF7-6E64D1C9D727 | 2020-01-25T17:38:42+00:00 | [ "Public" ] |
[] |
heic | 5f5bcb376b8fea54df152f57917140d8d71ea6528cb2582259967a6614077048 | 2742993 | 37.114983329999994 | -122.32553833000001 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | CA | United States | 20B906EB-2A5F-4660-AEF7-6E64D1C9D727 | 0.4208984375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0012493133544921875 | 0.0186309814453125 | 0.0016107559204101562 | 0.009999999776482582 | 0.235107421875 | -0.0975341796875 | 0.1732177734375 | 0.0165252685546875 | -0.0266571044921875 | -0.0413818359375 | -0.244384765625 | -0.07073974609375 | 0.09234619140625 | -0.02294921875 | 0.00799560546875 | -0.012939453125 | 0.0030879974365234375 | 0.048309326171875 | 0.033538818359375 | -0.25537109375 | 0.279541015625 | 0.024658203125 | |
197 | 3A19DB48-E962-4B82-9E26-57BDA6F34B8C | 2020-01-25T16:58:40+00:00 | [ "Public" ] |
[] |
heic | 63caca87e01761366f47b8c7e1a68dadb7b10d983c10a7df91e1ec945df987ac | 877404 | 37.118902829999996 | -122.30718833 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | CA | United States | 3A19DB48-E962-4B82-9E26-57BDA6F34B8C | 0.2022705078125 | 0.75 | 0.0 | 0.0580211847110559 | 0.10000000149011612 | -0.0019044876098632812 | 0.0064697265625 | 0.0017271041870117188 | 0.009999999776482582 | -0.8447265625 | -0.050048828125 | 0.228759765625 | 0.0011692047119140625 | -0.00878143310546875 | -0.018585205078125 | -0.230224609375 | -0.0233154296875 | 0.042327880859375 | -0.012542724609375 | -0.0212860107421875 | -0.01364898681640625 | 0.0016231536865234375 | 0.09515380859375 | 0.086669921875 | 0.0186767578125 | 0.28076171875 | -0.0091094970703125 | |
441 | BCAEC510-5871-42B9-9A19-C5FB587F61FA | 2020-01-25T16:57:07+00:00 | [ "Public" ] |
[] |
heic | e02df647bbc0ccc62c05a275c54edeb0529fc7032b182ec91a69556b70a7fa8e | 1304263 | 37.11899167 | -122.307175 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Pescadero | CA | United States | BCAEC510-5871-42B9-9A19-C5FB587F61FA | 0.46435546875 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0182342529296875 | 0.000316619873046875 | 0.0025310516357421875 | 0.009999999776482582 | -0.9462890625 | -0.08282470703125 | -0.208740234375 | 0.009857177734375 | -0.0316162109375 | -0.032440185546875 | -0.36083984375 | -0.591796875 | 0.01029205322265625 | 0.003509521484375 | -0.006435394287109375 | -0.0160064697265625 | 0.0036067962646484375 | 0.01024627685546875 | -0.20556640625 | 0.047607421875 | 0.187744140625 | -0.0001983642578125 | |
49 | 5F1D5E64-6DEB-4F8B-8A93-F57514B2EDDD | 2020-01-21T01:14:26+00:00 | [ "Public" ] |
[] |
heic | 18c0aa96d3614e986218af43cfd9a9cb3ae1806270091d1c8d4ea7f7f0b736d6 | 2215697 | 37.38205333 | -122.193895 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Portola Valley | CA | United States | 5F1D5E64-6DEB-4F8B-8A93-F57514B2EDDD | 0.53076171875 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0163421630859375 | -0.0016937255859375 | 0.0035381317138671875 | 0.009999999776482582 | -0.1805419921875 | -0.1402587890625 | -0.05560302734375 | 0.0472412109375 | -0.06829833984375 | -0.10205078125 | -0.60107421875 | -0.4970703125 | 0.058349609375 | -0.0872802734375 | -0.0017242431640625 | -0.0164794921875 | 0.002216339111328125 | 0.002704620361328125 | -0.192626953125 | -0.203857421875 | -0.286376953125 | -0.0118408203125 | |
118 | 973F76C4-33A5-4ADD-A896-8E9744AB177E | 2020-01-14T05:40:24+00:00 | [ "Public" ] |
[] |
heic | 38ed150fe0aaf4dfded5f144abecab5de247760a6bb2d41526b2dd8de0b11397 | 1391787 | 37.45085333 | -122.18125833000002 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Menlo Park | CA | United States | 973F76C4-33A5-4ADD-A896-8E9744AB177E | 0.43603515625 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.001674652099609375 | 0.00955963134765625 | 0.0020275115966796875 | 0.009999999776482582 | -0.219970703125 | -0.03985595703125 | 0.158935546875 | 0.02685546875 | -0.037689208984375 | -0.018951416015625 | -0.11468505859375 | -0.1063232421875 | 0.1466064453125 | 0.00421142578125 | 0.000213623046875 | -0.04766845703125 | 0.0087432861328125 | 0.060302734375 | 0.0248260498046875 | -0.19091796875 | 0.416748046875 | -0.009124755859375 | |
234 | 4989D148-E809-4B16-850E-E996339D7224 | 2020-01-14T05:38:46+00:00 | [ "Public" ] |
[] |
heic | 73491bc0d6fe19177e620c11f66a2e70f417d5ed17210c64804f5362803946f4 | 1324680 | 37.450846670000004 | -122.18125333 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Menlo Park | CA | United States | 4989D148-E809-4B16-850E-E996339D7224 | 0.40771484375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.006587982177734375 | 0.001239776611328125 | 0.0015249252319335938 | 0.05999999865889549 | -0.5263671875 | -0.08660888671875 | -0.05682373046875 | 0.0310211181640625 | -0.05224609375 | -0.07977294921875 | -0.3095703125 | -0.477783203125 | 0.050323486328125 | -0.04034423828125 | -0.0011138916015625 | -0.12060546875 | 0.00757598876953125 | 0.0194549560546875 | -0.0555419921875 | -0.09417724609375 | 0.325439453125 | -0.0064544677734375 | |
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 | |
297 | 2D40FEB4-03ED-4C06-BEAF-F54E0523D909 | 2019-11-02T19:10:14+00:00 | [ "Public" ] |
[] |
heic | 8e863e558a9bcd65dbfe5add8c6bc8fc5150358449cc9036d6fa9c428e7ba8ee | 2239399 | 37.456428329999994 | -122.10851949999999 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Palo Alto | CA | United States | 2D40FEB4-03ED-4C06-BEAF-F54E0523D909 | 0.38037109375 | 0.75 | 0.0 | 0.05801763419659083 | 0.10000000149011612 | -0.002208709716796875 | 0.01380157470703125 | 0.0165252685546875 | 0.009999999776482582 | -0.21142578125 | -0.06890869140625 | 0.142333984375 | 0.006389617919921875 | -0.012481689453125 | -0.0638427734375 | -0.425537109375 | -0.05072021484375 | 0.202880859375 | -0.01123046875 | 0.0060272216796875 | -0.01305389404296875 | 0.004810333251953125 | 0.005062103271484375 | -0.00335693359375 | -0.10638427734375 | -0.413818359375 | -0.01690673828125 | |
318 | 9ABD9958-31BE-4B9D-9480-7E3342B601FD | 2019-10-30T20:34:50+00:00 | [ "Public" ] |
[] |
heic | 9b4affb8f608930ee6f1b83fc86c66162c372a8e21ef4d2d4010fabaa627bec1 | 2376821 | 37.42704667 | -122.167795 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Stanford | CA | United States | 9ABD9958-31BE-4B9D-9480-7E3342B601FD | 0.377197265625 | 0.75 | 0.0 | 0.05801526718694745 | 0.7046471834182739 | -0.0006589889526367188 | 0.09112548828125 | 0.00400543212890625 | 0.009999999776482582 | 0.572265625 | -0.030670166015625 | 0.0860595703125 | 0.023651123046875 | -0.006122589111328125 | 0.015655517578125 | 0.41943359375 | 0.34716796875 | 0.02691650390625 | 0.36865234375 | 0.0670166015625 | 0.014129638671875 | 0.0083465576171875 | 0.385986328125 | 0.37841796875 | 0.373779296875 | 0.78515625 | 0.341796875 | |
45 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 2019-09-21T23:04:44+00:00 | [ "Public" ] |
[ "Simon Willison" ] |
heic | 169d469221f7b3672924dad826b6e064adef8d2156cbac42694bf6574a6ee942 | 2127841 | 37.75691167 | -122.42811666999998 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 0.6005859375 | 0.900544417500496 | 0.0 | 0.06950898268295609 | 0.10000000149011612 | -0.0010814666748046875 | -0.004852294921875 | 0.0018529891967773438 | 0.009999999776482582 | 0.0074462890625 | -0.049041748046875 | 0.4072265625 | 0.0010652542114257812 | -0.021484375 | -0.060638427734375 | -0.2181396484375 | -0.08575439453125 | 0.2110595703125 | -0.1009521484375 | -0.0017833709716796875 | -0.05633544921875 | 0.00323486328125 | 0.01229095458984375 | -0.0018157958984375 | -0.56298828125 | 0.023193359375 | -0.08587646484375 | |
116 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 2019-09-16T16:27:24+00:00 | [ "Public" ] |
[ "_UNKNOWN_" ] |
heic | 38c5c9797285ca569d63a524a7a217b562c289e2b8068122e5dd7329348cfe4c | 1987600 | 37.449821666666665 | -122.18592 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Menlo Park | CA | United States | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 0.443115234375 | 0.75 | 0.0 | 0.9740458015380925 | 0.10000000149011612 | -0.000743865966796875 | 0.0360107421875 | 0.0125732421875 | 0.009999999776482582 | 0.1959228515625 | -0.08599853515625 | 0.06207275390625 | 0.020965576171875 | -0.00963592529296875 | -0.040130615234375 | -0.1871337890625 | 0.0689697265625 | 0.23583984375 | 0.19287109375 | 0.013458251953125 | -0.00125885009765625 | 0.0169219970703125 | 0.0169219970703125 | 0.00560760498046875 | -0.0806884765625 | -0.0244140625 | 0.116943359375 | |
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 | |
119 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 2019-05-25T23:27:50+00:00 | [ "Public" ] |
[] |
heic | 3965927422e592de931edff7d6a2596c1b209c579b895e36d4e2bbbf1cd7da0d | 1933650 | 37.77649666666667 | -122.424995 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 0.5703125 | 0.5 | 0.0 | 0.038931297721298594 | 0.5037956237792969 | -0.0010728836059570312 | 0.0623779296875 | 0.0048675537109375 | 0.009999999776482582 | 0.101318359375 | -0.05889892578125 | 0.447021484375 | 0.004230499267578125 | -0.00600433349609375 | -0.00653076171875 | -0.138427734375 | 0.0870361328125 | 0.177978515625 | 0.028076171875 | 0.0181884765625 | -0.004589080810546875 | 0.0025310516357421875 | 0.07171630859375 | 0.1861572265625 | -0.12115478515625 | 0.0556640625 | -0.00311279296875 | |
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 |
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;