photos_with_apple_metadata (view)

39 rows where albums = "["Public"]" and place_state_province = "CA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: persons, ext, favorite, hdr, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, date (date), albums (array), persons (array)

place_state_province ✖

place_country ✖

albums ✖

  • ["Public"] · 39 ✖
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
157 4BCA66D4-BF92-4060-BF82-85FAEF3033C9 2017-10-21T19:31:24+00:00 
[
    "Public"
]
 
[]
 jpeg 4b7a039dc64647efadfb959fdf8fedc82c753e590a5dc5f3a0caebc150706b1b 4252995 37.77567166666667 -122.51278666666667 0 0 0 0 0 0 0 0 San Francisco CA United States 4BCA66D4-BF92-4060-BF82-85FAEF3033C9 0.50732421875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0038089752197265625 -0.00676727294921875 0.0021076202392578125 0.009999999776482582 0.10498046875 -0.060760498046875 0.019775390625 0.0230712890625 -0.1339111328125 -0.04217529296875 -0.253662109375 -0.3642578125 0.1802978515625 -0.0487060546875 -0.004413604736328125 -0.02642822265625 0.00800323486328125 0.00806427001953125 -0.045440673828125 -0.55615234375 0.2083740234375 -0.0648193359375
1 F78D8339-34E9-4A9A-9BF8-6A73F52566EE 2017-10-21T18:11:34+00:00 
[
    "Public"
]
 
[]
 jpeg 00485aa2f328e85a25275dbdbf97af63c36e869f012302206b4c8d1f1e60c26d 5184871 37.77535 -122.51298666666666 0 0 0 0 0 0 0 0 San Francisco CA United States F78D8339-34E9-4A9A-9BF8-6A73F52566EE 0.53271484375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00037550926208496094 0.03216552734375 0.01073455810546875 0.009999999776482582 -0.34033203125 -0.0699462890625 0.1435546875 0.00524139404296875 -0.00469970703125 -0.0418701171875 -0.28076171875 0.1400146484375 0.11181640625 0.1612548828125 0.0097198486328125 -0.0096893310546875 0.0101318359375 0.026763916015625 0.0047454833984375 -0.07196044921875 -0.0020751953125 0.010009765625
187 A3621F93-93FE-4025-8C7A-ECC62CA9F326 2017-10-21T18:11:33+00:00 
[
    "Public"
]
 
[]
 jpeg 5dbba9e4d6c335f966573806fbdc841ee4fa917e1b13427e1bb6a5ff61420c44 5474835 37.77533666666667 -122.51297833333334 0 0 0 0 0 0 0 0 San Francisco CA United States A3621F93-93FE-4025-8C7A-ECC62CA9F326 0.45751953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.005428314208984375 0.00844573974609375 0.0136871337890625 0.009999999776482582 -0.230712890625 -0.06549072265625 0.0655517578125 0.0208892822265625 -0.0268096923828125 -0.061126708984375 -0.352294921875 -0.170166015625 0.386962890625 -0.00115966796875 0.005817413330078125 -0.0172271728515625 0.012969970703125 0.00867462158203125 -0.0306396484375 -0.1173095703125 -0.221435546875 -0.022216796875
260 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B 2017-09-29T01:17:17+00:00 
[
    "Public"
]
 
[]
 jpeg 7ef1fc100a8feb54edec02b3dda0255d5fd0e8260c015c1b4feeb8be39bcabca 4772665 37.77751666666666 -122.42583333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B 0.4208984375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004665374755859375 -0.000202178955078125 0.0026416778564453125 0.009999999776482582 0.003662109375 -0.10797119140625 0.034637451171875 0.009857177734375 -0.038238525390625 -0.07037353515625 -0.394775390625 -0.30859375 0.07366943359375 -0.051483154296875 -0.0014400482177734375 -0.02740478515625 0.0038700103759765625 0.0070648193359375 -0.0821533203125 -0.29833984375 0.0435791015625 0.01141357421875
198 B1FADEF4-2284-4D74-B306-1ADB41409035 2016-06-26T03:00:36+00:00 
[
    "Public"
]
 
[]
 jpeg 63ecdd738ea57a07688300501485b22be6b193e852f6af7404295da8e5a6bcee 2091348 37.784641666666666 -122.43603666666667 0 0 0 0 0 0 0 0 San Francisco CA United States B1FADEF4-2284-4D74-B306-1ADB41409035 0.1707763671875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0018243789672851562 0.017547607421875 0.005535125732421875 0.009999999776482582 -0.0880126953125 -0.044586181640625 0.0906982421875 0.01262664794921875 -0.021453857421875 -0.017578125 -0.0570068359375 -0.0455322265625 0.2359619140625 0.08258056640625 0.00566864013671875 -0.00803375244140625 0.0125274658203125 0.043701171875 0.041717529296875 -0.0128173828125 0.256103515625 0.0222320556640625
405 11C638ED-4C47-4D12-BF4C-4DF75D1508D2 2016-06-26T03:00:34+00:00 
[
    "Public"
]
 
[]
 jpeg c9364c1faae70f2d66c2e6511d612a75cf53d3a5c06da311206ac8eff3b7eab9 2104203 37.784595 -122.43608833333333 0 0 0 0 0 0 0 0 San Francisco CA United States 11C638ED-4C47-4D12-BF4C-4DF75D1508D2 0.2841796875 0.6 0.0 0.8099236641335124 0.10000000149011612 -0.0007791519165039062 0.06878662109375 0.06231689453125 0.009999999776482582 -0.0009765625 -0.0229339599609375 0.310302734375 0.0006265640258789062 -0.0035114288330078125 -0.03521728515625 0.0626220703125 0.063232421875 0.06292724609375 0.09722900390625 0.0171356201171875 -0.000911712646484375 0.00595855712890625 0.0089874267578125 -8.58306884765625e-05 0.01532745361328125 -0.065185546875 0.000820159912109375
110 BF295F44-7050-4EF5-9D2D-597144A55C46 2016-04-17T20:01:45+00:00 
[
    "Public"
]
 
[]
 jpeg 365135c4f3997964b978de088f7a21599630a500aa7881331e6f4f7107ea2cb4 4661564 37.779955 -122.41871666666667 0 0 0 0 0 0 0 0 San Francisco CA United States BF295F44-7050-4EF5-9D2D-597144A55C46 0.49853515625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0006566047668457031 0.0270233154296875 0.004486083984375 0.009999999776482582 -0.2177734375 -0.056549072265625 0.248779296875 0.0025806427001953125 -0.0069580078125 -0.04290771484375 -0.18701171875 0.0396728515625 0.10052490234375 0.05615234375 0.011260986328125 -0.0211639404296875 0.005039215087890625 0.0457763671875 0.0168304443359375 -0.03985595703125 0.1614990234375 -0.00495147705078125
346 9B076964-9931-4790-AE2D-A06011B97CE7 2016-04-09T20:12:10+00:00 
[
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 jpeg a7e181d3b3705db1b852705de9a92e0449fbb1b98b70e366bab316b554dafd6e 2665460 37.78550333333333 -122.43043666666667 0 0 0 0 0 0 0 0 San Francisco CA United States 9B076964-9931-4790-AE2D-A06011B97CE7 0.434326171875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0014209747314453125 0.0190582275390625 0.0013408660888671875 0.009999999776482582 0.150634765625 -0.06256103515625 0.31884765625 0.0022869110107421875 -0.01666259765625 -0.009002685546875 -0.1044921875 -0.00030517578125 0.0293121337890625 -0.04010009765625 0.001861572265625 -0.00848388671875 0.0009546279907226562 0.10015869140625 0.10113525390625 -0.07080078125 0.4228515625 0.02374267578125
240 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 2016-04-09T20:12:10+00:00 
[
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 jpeg 75d306a807f0c9b8a89eb726ca2ea4e226812e347ad1b70a0d7806ca2c9111c8 2689457 37.78550333333333 -122.43043666666667 0 0 0 0 0 1 0 0 San Francisco CA United States 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 0.486572265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004314422607421875 -0.00701141357421875 0.002452850341796875 0.009999999776482582 -0.121826171875 -0.1026611328125 0.11175537109375 0.005619049072265625 -0.0521240234375 -0.133544921875 -0.4990234375 -0.270263671875 0.165283203125 -0.1573486328125 -0.0026302337646484375 -0.0262451171875 0.0035381317138671875 0.00557708740234375 -0.07470703125 -0.5068359375 -0.1641845703125 -0.1171875
288 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 2016-04-09T20:10:29+00:00 
[
    "Public"
]
 
[]
 jpeg 8a3115b8c82c630e48b0ac70eb94d8201721937c4697a667916e1632a5063001 3046776 37.78546166666667 -122.43050333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 0.41064453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.005138397216796875 0.0030517578125 0.0012159347534179688 0.019999999552965164 0.17138671875 -0.06451416015625 0.043548583984375 0.00955963134765625 -0.0836181640625 -0.022918701171875 -0.1002197265625 -0.2410888671875 0.0150146484375 -0.057891845703125 -0.0015716552734375 -0.009979248046875 0.0015850067138671875 0.051177978515625 -0.016876220703125 -0.0430908203125 0.5712890625 0.01898193359375
261 93C7D5C0-E78B-47A0-8953-9A143D65597D 2016-04-09T20:10:28+00:00 
[
    "Public"
]
 
[]
 jpeg 7f16bd84f8301f158a2a512549c0f1594ce92b7bfa05d2787e28a9d890b63419 3094751 37.78546166666667 -122.43050333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 93C7D5C0-E78B-47A0-8953-9A143D65597D 0.50537109375 0.5 0.0 0.038931297721298594 0.7079561948776245 -0.0005235671997070312 0.051239013671875 0.0180511474609375 0.009999999776482582 0.4306640625 -0.02447509765625 0.27685546875 0.0020503997802734375 -0.006587982177734375 -0.0058441162109375 0.11236572265625 0.08697509765625 0.10577392578125 0.07672119140625 0.022308349609375 0.0009765625 0.008575439453125 0.021575927734375 0.00565338134765625 0.06109619140625 0.185546875 0.0660400390625
134 CF759040-2FAD-4203-8C0F-88DF33C894BC 2016-03-21T00:20:29+00:00 
[
    "Public"
]
 
[]
 jpeg 3cb22fc3dc3413773a9a2d5a54948c5ffaafd400b09b6c327ff29360ad0d498d 2336745 37.80468333333334 -122.47161166666666 0 0 0 0 0 0 0 0 San Francisco CA United States CF759040-2FAD-4203-8C0F-88DF33C894BC 0.1688232421875 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.0005173683166503906 0.01345062255859375 0.004024505615234375 0.009999999776482582 0.29541015625 -0.0188751220703125 0.46044921875 0.0005035400390625 -0.01450347900390625 -0.011962890625 0.0089111328125 -0.0125732421875 0.1661376953125 -0.0172119140625 0.00833892822265625 -0.0139617919921875 0.004924774169921875 0.02288818359375 0.00434112548828125 0.0689697265625 0.395751953125 -0.023162841796875

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