photos_with_apple_metadata (view)

64 rows where albums = "["Public"]", ext = "heic" and hdr = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: persons, favorite, panorama, place_city, place_state_province, place_country, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, 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
217 B21AA170-9F4B-49A4-A3B4-F77AB2E3CDFA 2019-12-29T10:40:51+00:00 
[
    "Public"
]
 
[]
 heic 6c260ecb0219bf7808f1a8ebf5e35aaaa15d395592a2ca050bebc42c703f7217 1711662 51.49035 -0.6723333300000001 1 0 0 0 0 0 0 0 Windsor England United Kingdom B21AA170-9F4B-49A4-A3B4-F77AB2E3CDFA 0.472900390625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0006313323974609375 0.019256591796875 0.0034961700439453125 0.009999999776482582 -0.31689453125 -0.03521728515625 0.08013916015625 0.0169830322265625 -0.011688232421875 0.007171630859375 0.0731201171875 0.10430908203125 0.150390625 0.1519775390625 0.00537872314453125 -0.01264190673828125 0.0199432373046875 0.16650390625 0.100830078125 0.037353515625 0.6376953125 0.01389312744140625
487 BA5C0E8F-0086-47CD-9E8E-DAD96A494C5A 2019-12-28T10:55:13+00:00 
[
    "Public"
]
 
[]
 heic faec04a4c5576d2de8af17460c22c79fd1926e889e3d0073ea188994c82507ac 3569228 50.697155 -3.19187 1 0 0 0 0 0 0 0 Sidmouth England United Kingdom BA5C0E8F-0086-47CD-9E8E-DAD96A494C5A 0.49267578125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0008935928344726562 0.024658203125 0.0289764404296875 0.009999999776482582 -0.22119140625 -0.033905029296875 0.13232421875 0.00392913818359375 -0.00916290283203125 -0.0421142578125 -0.09619140625 0.0260009765625 0.2198486328125 0.092041015625 0.010162353515625 -0.0087127685546875 0.0165863037109375 0.0103302001953125 -0.000217437744140625 -0.0215911865234375 -0.09661865234375 0.00095367431640625
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
99 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A 2019-12-21T10:01:09+00:00 
[
    "Public"
]
 
[]
 heic 2f6b03abdcfe2f4c21f60485ddd9206bc4313e77f9b06e72eb38050d9978685b 7211598 51.17876333 -1.8266950000000002 1 0 0 0 0 0 0 1 Salisbury England United Kingdom 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A 0.638671875 0.75 0.0 0.06109879080575841 0.10000000149011612 -0.0005421638488769531 0.03216552734375 0.00217437744140625 0.009999999776482582 0.0615234375 -0.049041748046875 0.1693115234375 0.006389617919921875 -0.0068511962890625 0.0143280029296875 0.0623779296875 0.139404296875 0.044769287109375 0.1705322265625 0.008758544921875 -0.00537872314453125 0.005260467529296875 0.2900390625 0.2193603515625 0.0245361328125 0.66064453125 0.036163330078125
11 28933E0F-FEFC-498F-9F5D-873E0E48B1B9 2019-12-18T15:43:35+00:00 
[
    "Public"
]
 
[
    "Natalie Downe"
]
 heic 046f22422fccd4bbe560f85ad3520e2ab4e9e315f0d1748ce62f87de7ae4b046 2795935 51.514491670000005 -0.08766383 1 0 0 0 0 0 0 0 London England United Kingdom 28933E0F-FEFC-498F-9F5D-873E0E48B1B9 0.362548828125 0.893326692134142 0.0 0.06895623605214912 0.10000000149011612 -0.0053863525390625 0.00749969482421875 0.012481689453125 0.009999999776482582 -0.4404296875 -0.0560302734375 -0.04473876953125 0.01061248779296875 -0.03515625 -0.084228515625 -0.2481689453125 -0.312744140625 0.1070556640625 0.02276611328125 0.0029468536376953125 -0.0121612548828125 0.00971221923828125 0.00490570068359375 -0.032135009765625 -0.004638671875 -0.0966796875 -3.814697265625e-05
93 45CD64EE-9C93-48EA-89F8-8F9C849543F6 2019-12-18T15:26:39+00:00 
[
    "Public"
]
 
[]
 heic 2914d77166bd3d96058e8c4994e7840b61fc4f42a2be6c67cf2f6dbba96861fb 1517951 51.51231333 -0.09033617000000002 1 0 0 0 0 0 0 0 London England United Kingdom 45CD64EE-9C93-48EA-89F8-8F9C849543F6 0.6953125 0.75 0.0 0.058028268450089085 0.7025303840637207 -0.0003597736358642578 0.112548828125 0.005344390869140625 0.019999999552965164 0.80517578125 -0.0253753662109375 0.1171875 0.0162811279296875 -0.004314422607421875 0.01824951171875 0.52001953125 0.43359375 0.043121337890625 0.350341796875 0.045166015625 0.056427001953125 0.01332855224609375 0.2529296875 0.1829833984375 0.2476806640625 0.771484375 0.8681640625
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
364 A8B386D0-B156-4594-886A-44207E4C0EA8 2019-12-17T09:42:50+00:00 
[
    "Public"
]
 
[]
 heic b2d13d18e9e15e0e46a652a11638f694266743089b04ae8e1ceec144f9d261f3 1969856 51.52411667 -0.11119167 1 0 0 0 0 0 0 0 London England United Kingdom A8B386D0-B156-4594-886A-44207E4C0EA8 0.62353515625 0.75 0.0 0.05801763419659083 0.10000000149011612 -0.004848480224609375 0.0092010498046875 0.00591278076171875 0.009999999776482582 -0.8974609375 -0.035400390625 -0.048828125 0.0164642333984375 -0.018646240234375 -0.022186279296875 -0.0755615234375 -0.249267578125 0.23974609375 0.0693359375 -0.018585205078125 -0.01361083984375 0.0272674560546875 0.0257110595703125 -0.049652099609375 0.04541015625 0.2568359375 0.002201080322265625
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
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
309 A34D9C15-11C6-488C-9E3C-910401A65132 2019-09-15T15:16:37+00:00 
[
    "Public"
]
 
[]
 heic 95e2658b31ac920ea73e962755503af66a5a04ceade3f3c91313f8808380f753 3537285 30.243796666666668 -89.68113 1 0 0 0 0 0 0 0 Slidell LA United States A34D9C15-11C6-488C-9E3C-910401A65132 0.47021484375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0036792755126953125 -0.00623321533203125 0.004573822021484375 0.009999999776482582 -0.17138671875 -0.05450439453125 0.2073974609375 0.0028896331787109375 -0.039794921875 -0.1051025390625 -0.3232421875 -0.1912841796875 0.39306640625 -0.091552734375 -0.002368927001953125 -0.1004638671875 0.0066680908203125 0.0038089752197265625 -0.022735595703125 -0.396484375 -0.28955078125 -0.07501220703125
442 1EC4C590-FBD5-4D44-9FF8-0FAC3F1600D5 2019-09-15T15:15:38+00:00 
[
    "Public"
]
 
[]
 heic e0418d31b3a2b842b3514b954ac271355a51ba93194dc39cfadb7ee9ecb1acac 3794075 30.243286666666666 -89.68092166666666 1 0 0 0 0 0 0 0 Slidell LA United States 1EC4C590-FBD5-4D44-9FF8-0FAC3F1600D5 0.6689453125 0.75 0.0 0.061091547248927694 0.10000000149011612 -0.0002913475036621094 0.0178985595703125 0.0090179443359375 0.009999999776482582 0.0235595703125 -0.039947509765625 0.11279296875 0.0070953369140625 -0.006641387939453125 -0.013092041015625 0.019287109375 0.0228271484375 0.275390625 0.11358642578125 0.0069427490234375 -0.0308074951171875 0.04949951171875 0.0284423828125 0.0028171539306640625 -0.1083984375 0.3466796875 0.00666046142578125
423 9B0C0741-55E0-4BB2-BC6B-BAB6804EE1A0 2019-09-15T14:38:47+00:00 
[
    "Public"
]
 
[]
 heic d6f260ebe038a495c75f0bbc1c00606f894676a9ce2098c3d5733530dc0e8ec2 2699124 30.234196666666666 -89.66815833333334 1 0 0 0 0 0 0 0 Slidell LA United States 9B0C0741-55E0-4BB2-BC6B-BAB6804EE1A0 0.6171875 0.75 0.0 0.06110566308480183 0.10000000149011612 -0.00473785400390625 -0.0020599365234375 0.002208709716796875 0.009999999776482582 -0.5263671875 -0.0616455078125 0.07708740234375 0.00482940673828125 -0.040679931640625 -0.0740966796875 -0.298095703125 -0.294677734375 0.0792236328125 -0.0595703125 -0.004840850830078125 -0.1695556640625 0.00464630126953125 0.00841522216796875 -0.0238189697265625 -0.1800537109375 0.0487060546875 -0.02069091796875
225 5896CD82-A625-4414-9D39-25EFE6E848C1 2019-09-15T14:37:30+00:00 
[
    "Public"
]
 
[]
 heic 7104ebd9287ca4e5d2556496eafd7d34ada9901997cbff1dbdd7c33281d65566 2529275 30.234196666666666 -89.66815833333334 1 0 0 0 0 0 0 0 Slidell LA United States 5896CD82-A625-4414-9D39-25EFE6E848C1 0.6513671875 0.75 0.0 0.8244531118232785 0.10000000149011612 -0.0008897781372070312 0.02996826171875 0.030792236328125 0.009999999776482582 0.0899658203125 -0.07708740234375 0.011474609375 0.00933837890625 -0.00847625732421875 -0.0897216796875 -0.1318359375 -0.0404052734375 0.316162109375 0.26220703125 0.013916015625 -0.0034942626953125 0.03228759765625 0.008880615234375 -0.00472259521484375 -0.01678466796875 -0.072998046875 0.016571044921875
401 F9F1DAD8-0DEC-4272-A0E5-39517811AF71 2019-09-14T16:55:41+00:00 
[
    "Public"
]
 
[
    "Natalie Downe"
]
 heic c7640974717fa2e3c211179191b9b2b34d3515e5cd487593d411ac399889bcbf 1617679 29.940825 -90.07910833333334 1 0 0 0 0 0 0 0 New Orleans LA United States F9F1DAD8-0DEC-4272-A0E5-39517811AF71 0.533203125 0.8985287165641784 0.0 0.06935333715367863 0.10000000149011612 -0.006717681884765625 0.0079803466796875 0.0032863616943359375 0.009999999776482582 0.140380859375 -0.0823974609375 -0.07086181640625 0.08197021484375 -0.03515625 -0.002685546875 -0.068603515625 -0.204833984375 0.0115509033203125 0.0712890625 0.0028228759765625 -0.002513885498046875 0.0045928955078125 0.0784912109375 0.043701171875 -0.00518798828125 0.5908203125 0.2303466796875
330 DA8753B5-BAFA-4A34-8DB6-7AC49AB86A6D 2019-09-14T16:44:03+00:00 
[
    "Public"
]
 
[]
 heic a04a292cdcb0f9d9d9eee14dfb970a93a5756355a7e51f6ed9cb78a128270f4d 2577777 29.940905 -90.07900283333333 1 0 0 0 0 0 0 0 New Orleans LA United States DA8753B5-BAFA-4A34-8DB6-7AC49AB86A6D 0.3427734375 0.75 0.0 0.05801763419659083 0.10000000149011612 -0.03204345703125 0.002948760986328125 0.0034694671630859375 0.009999999776482582 -0.5107421875 -0.10797119140625 -0.0640869140625 0.0966796875 -0.064208984375 -0.0257110595703125 -0.48876953125 -0.44287109375 0.0170440673828125 -0.032989501953125 7.62939453125e-05 -0.01108551025390625 0.0012350082397460938 0.013275146484375 -0.138671875 -0.06024169921875 -0.0908203125 -0.0241851806640625
389 4C86821D-5061-4FAC-8CF9-CBCCA1ED4D55 2019-09-14T16:34:54+00:00 
[
    "Public"
]
 
[]
 heic c37b828329e32f8451e9fedf83c1a8cba93ea3978257456dafecb3ab35d011dd 1843184 29.94091166666667 -90.07916383333334 1 0 0 0 0 0 0 0 New Orleans LA United States 4C86821D-5061-4FAC-8CF9-CBCCA1ED4D55 0.479736328125 0.75 0.0 0.05801763419659083 0.10000000149011612 -0.0147857666015625 0.019134521484375 0.0038394927978515625 0.009999999776482582 0.2144775390625 -0.06536865234375 -0.043548583984375 0.2130126953125 -0.06536865234375 -0.003936767578125 -0.056640625 -0.2001953125 0.0164031982421875 0.063232421875 0.025482177734375 -0.002048492431640625 0.0031604766845703125 0.0762939453125 0.0914306640625 0.1109619140625 0.53076171875 0.20556640625
282 7E07EFBF-1F63-4142-8856-7DCD9F906811 2019-09-14T16:27:56+00:00 
[
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 86e8a0932628c6450de3649297ab0295831bb3963b186b262d8ff4bfdf9cfef0 1699486 29.941283333333335 -90.07913883333333 1 0 0 0 0 0 0 0 New Orleans LA United States 7E07EFBF-1F63-4142-8856-7DCD9F906811 0.361328125 0.75 0.0 0.05801526718694745 0.5045255422592163 -0.0028228759765625 0.0236358642578125 0.002521514892578125 0.009999999776482582 0.42626953125 -0.0970458984375 -0.021026611328125 0.04168701171875 -0.00844573974609375 0.00287628173828125 0.1065673828125 0.0474853515625 0.01049041748046875 0.16552734375 0.0140838623046875 -7.2479248046875e-05 0.0039005279541015625 0.2330322265625 0.47900390625 0.10040283203125 0.71728515625 0.31689453125
493 43214F71-0B9A-4F8A-AA37-BD30EBF549AA 2019-09-14T16:22:47+00:00 
[
    "Public"
]
 
[]
 heic febc9309036eecd044283deed4492854256af6ad195f9c71165e60928633e57f 2389075 29.940883333333332 -90.07913883333333 1 0 0 0 0 0 0 0 New Orleans LA United States 43214F71-0B9A-4F8A-AA37-BD30EBF549AA 0.38916015625 0.75 0.0 0.05801526718694745 0.5048418641090393 -0.0014162063598632812 0.0150604248046875 0.0013723373413085938 0.009999999776482582 0.6552734375 -0.06805419921875 -0.011138916015625 0.07666015625 -0.019012451171875 0.007720947265625 0.179931640625 0.1343994140625 0.010650634765625 0.14306640625 0.01058197021484375 0.000843048095703125 0.00424957275390625 0.370849609375 0.54052734375 0.04827880859375 0.83251953125 0.434326171875
308 43E95407-6F45-460A-830E-079C0F149D67 2019-09-08T02:10:46+00:00 
[
    "Public"
]
 
[]
 heic 952749cd5456be2452b60fc372a814e81c62f4627a0e34b58983b575ca297be4 999594 29.950541666666666 -90.0704945 1 0 0 0 0 0 0 0 New Orleans LA United States 43E95407-6F45-460A-830E-079C0F149D67 0.1934814453125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.07598876953125 -0.00316619873046875 0.007232666015625 0.009999999776482582 -0.708984375 -0.033599853515625 0.02911376953125 0.006587982177734375 -0.15673828125 -0.042510986328125 -0.26220703125 -0.35888671875 0.0234222412109375 -0.09771728515625 -0.0074005126953125 -0.0184173583984375 0.0007762908935546875 0.0030994415283203125 -0.169189453125 0.00262451171875 -0.27099609375 -0.047454833984375
468 D15F85D9-D70A-4182-AC30-BCA0EA2AF542 2019-08-25T12:13:59+00:00 
[
    "Public"
]
 
[]
 heic ec3603bcb38d0cd7d2f90c7ba44de83f2f149c0a36a57cae9a5e7aff638327a8 1887278 48.84311666666667 2.3632866666666668 1 0 0 0 0 0 0 0 Paris Île-de-France France D15F85D9-D70A-4182-AC30-BCA0EA2AF542 0.53662109375 0.75 0.0 0.05801526718694745 0.10090024769306183 -0.00025725364685058594 0.05633544921875 0.0023326873779296875 0.009999999776482582 0.12109375 -0.0265045166015625 0.24267578125 0.00345611572265625 -0.004451751708984375 0.0234375 0.2171630859375 0.20166015625 0.062103271484375 0.302490234375 0.01715087890625 -0.00290679931640625 0.00841522216796875 0.40625 0.1768798828125 0.2003173828125 0.763671875 0.025787353515625
51 51F8F5EC-2C01-4C2C-A167-93BBF9244B92 2019-08-25T12:11:16+00:00 
[
    "Public"
]
 
[]
 heic 19c6fb53d4e0d62e743651ee7b4db539f58a7df17fe71dd144eadbe5267108d0 2177706 48.843205 2.3633866666666665 1 0 0 0 0 0 0 0 Paris Île-de-France France 51F8F5EC-2C01-4C2C-A167-93BBF9244B92 0.5732421875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0016231536865234375 0.0084075927734375 0.006488800048828125 0.009999999776482582 -0.1419677734375 -0.0634765625 0.18408203125 0.00530242919921875 -0.0189361572265625 -0.04681396484375 -0.325439453125 -0.05267333984375 0.10992431640625 -0.022247314453125 -0.00017547607421875 -0.01253509521484375 0.0037078857421875 0.013275146484375 -0.0039825439453125 -0.2388916015625 -0.103271484375 -0.020904541015625
407 A3697779-FE08-47A2-A0F1-F72E5F253A9A 2019-08-24T13:59:14+00:00 
[
    "Public"
]
 
[]
 heic cb68fc3efc0aea4f4b216de475ddeaacd084e89f4251821dda1021a96662e84e 1763966 48.866238333333335 2.3550033333333333 1 0 0 0 0 0 0 0 Paris Île-de-France France A3697779-FE08-47A2-A0F1-F72E5F253A9A 0.4736328125 0.75 0.0 0.05801526718694745 0.7040632367134094 -0.0008969306945800781 0.05682373046875 0.0017414093017578125 0.009999999776482582 0.6640625 -0.02880859375 0.1156005859375 0.00847625732421875 -0.005260467529296875 0.00762176513671875 0.33642578125 0.2490234375 0.0131683349609375 0.2069091796875 0.023590087890625 0.0031070709228515625 0.0030517578125 0.58935546875 0.74755859375 0.3955078125 0.8681640625 0.488525390625
61 910061FF-8B93-4DF6-8580-F61F3AF655AC 2019-08-24T12:37:43+00:00 
[
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 heic 1cbea14450726bc646e838673ea29b8223c53c5d312f0a111c3be48a4a7e7e5a 1385613 48.860908333333334 2.3425616666666667 1 0 0 0 0 0 0 0 Paris Île-de-France France 910061FF-8B93-4DF6-8580-F61F3AF655AC 0.3134765625 0.75 0.0 0.8213740458129016 0.7066909670829773 -0.0004093647003173828 0.09881591796875 0.002216339111328125 0.009999999776482582 0.8076171875 -0.0236053466796875 0.1300048828125 0.01242828369140625 -0.0027141571044921875 0.011077880859375 0.4990234375 0.466796875 0.0186920166015625 0.310302734375 0.064453125 0.0083770751953125 0.005062103271484375 0.78662109375 0.89404296875 0.48291015625 0.91259765625 0.58984375
137 903AEA63-4A86-4092-A52E-3DBAC94E1CBF 2019-08-24T12:33:18+00:00 
[
    "Public"
]
 
[]
 heic 3ef3e28be7d606d9972c1a4303285a75703ade48e48c138f3ca9936251811cab 2035365 48.860925 2.342713333333333 1 0 0 0 0 0 0 0 Paris Île-de-France France 903AEA63-4A86-4092-A52E-3DBAC94E1CBF 0.460205078125 0.75 0.0 0.05801526718694745 0.7073236107826233 -0.0009288787841796875 0.039306640625 0.0035114288330078125 0.009999999776482582 0.4736328125 -0.057586669921875 0.147216796875 0.004070281982421875 -0.0070648193359375 0.003509521484375 0.09234619140625 0.1043701171875 0.0207672119140625 0.1585693359375 0.00849151611328125 -0.00032806396484375 0.003337860107421875 0.11029052734375 0.07025146484375 0.09613037109375 0.6220703125 0.442626953125
253 410DD7AF-B97A-4508-9240-B2B0F55DC2FD 2019-08-24T12:32:07+00:00 
[
    "Public"
]
 
[]
 heic 7b98967bbbe92bf81cdc9adcee4fb623eb6691579bfc7b84636e9f4f172e9458 2400763 48.86095 2.342538333333333 1 0 0 0 0 0 0 0 Paris Île-de-France France 410DD7AF-B97A-4508-9240-B2B0F55DC2FD 0.3662109375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0092315673828125 0.02105712890625 0.00626373291015625 0.009999999776482582 -0.17333984375 -0.09271240234375 -0.000732421875 0.0139007568359375 -0.00609588623046875 -0.00481414794921875 -0.09033203125 -0.0902099609375 0.0135345458984375 0.09149169921875 0.00372314453125 -0.0022525787353515625 0.0035381317138671875 0.09466552734375 0.0888671875 0.042938232421875 0.44677734375 0.119384765625
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
480 E1468521-C7AB-4BA9-B4A9-D136FC9D4958 2017-12-16T11:52:26+00:00 
[
    "Public"
]
 
[]
 heic f574eaa689ab82870f62f702593725ed4a8e7a9f6c67a1ba31c79d57089f9e62 2274468 51.5034 -0.13202216666666666 0 0 0 0 0 0 0 0 London England United Kingdom E1468521-C7AB-4BA9-B4A9-D136FC9D4958 0.6083984375 0.5 0.0 0.04200813515495708 0.10000000149011612 -0.00974273681640625 0.00029754638671875 0.0013513565063476562 0.019999999552965164 -0.35498046875 -0.07879638671875 0.183349609375 0.004486083984375 -0.08526611328125 -0.072021484375 -0.189697265625 -0.219970703125 0.0309600830078125 -0.11846923828125 -0.09161376953125 -0.03326416015625 0.0009851455688476562 0.0284881591796875 -0.07403564453125 -0.1715087890625 0.30859375 -0.041015625
317 0D23847A-0863-4F18-938A-9839C8E28B91 2017-12-16T11:52:19+00:00 
[
    "Public"
]
 
[]
 heic 9ae44af9c6d663d44e03539a41fed0bb4679519f542ba99439f00a44a22d262c 2126432 51.5034 -0.132025 0 0 0 0 0 0 0 0 London England United Kingdom 0D23847A-0863-4F18-938A-9839C8E28B91 0.65576171875 0.5 0.0 0.04200813515495708 0.5031630396842957 -0.0005359649658203125 0.145263671875 0.0312042236328125 0.009999999776482582 0.46923828125 -0.038604736328125 0.1214599609375 0.0169219970703125 -0.0041351318359375 -0.0017242431640625 0.31689453125 0.330810546875 0.0548095703125 0.306884765625 0.0665283203125 0.01551055908203125 0.01262664794921875 0.034759521484375 0.0131072998046875 0.050567626953125 0.1435546875 0.239990234375
489 B78C4087-CE43-411C-AEAF-16C585DF6D67 2017-12-16T11:52:17+00:00 
[
    "Public"
]
 
[]
 heic fb7c3040191817d74897ed937836a9993cf3759f84a3bd4662f474c3635ec19a 2091779 51.5034 -0.13202783333333332 0 0 0 0 0 0 0 0 London England United Kingdom B78C4087-CE43-411C-AEAF-16C585DF6D67 0.71337890625 0.5 0.0 0.8068936312471637 0.10000000149011612 -0.005344390869140625 0.017913818359375 0.01094818115234375 0.009999999776482582 -0.55078125 -0.05865478515625 -0.06689453125 0.01129150390625 -0.01666259765625 -0.03057861328125 -0.1268310546875 -0.252197265625 0.020172119140625 0.0902099609375 0.0024738311767578125 -0.00368499755859375 0.00455474853515625 0.0104522705078125 -0.033721923828125 0.0194854736328125 0.00994873046875 0.019500732421875
238 C6E6907A-2118-47E3-A696-CFF7F0B4CC3F 2017-12-16T11:52:15+00:00 
[
    "Public"
]
 
[]
 heic 7579f41e5a983976df725e86a94b7261d7dd42ce20b6fd1e1ac24157a5f423a6 2545737 51.5034 -0.1320305 0 0 0 0 0 0 0 0 London England United Kingdom C6E6907A-2118-47E3-A696-CFF7F0B4CC3F 0.6943359375 0.5 0.0 0.8053669137809113 0.5068126320838928 -0.00046372413635253906 0.07562255859375 0.00809478759765625 0.009999999776482582 0.449951171875 -0.027069091796875 0.2340087890625 0.0027675628662109375 -0.0068511962890625 -0.003997802734375 0.20849609375 0.1182861328125 0.036895751953125 0.19921875 0.0247955322265625 0.0036468505859375 0.006824493408203125 0.046905517578125 0.005023956298828125 0.21826171875 0.459228515625 0.18798828125
426 A5E3DEAF-E22B-454C-9543-CF68191F349A 2017-12-16T11:52:14+00:00 
[
    "Public"
]
 
[]
 heic d84a166371c9d0f249aa25afbac69ba5cd310a5392fddf2c113736b53f0c6d5e 2498824 51.5034 -0.1320305 0 0 0 0 0 0 0 0 London England United Kingdom A5E3DEAF-E22B-454C-9543-CF68191F349A 0.64990234375 0.5 0.0 0.8053667281420176 0.5036982893943787 -0.0003859996795654297 0.0845947265625 0.01322174072265625 0.009999999776482582 0.51171875 -0.04193115234375 0.064208984375 0.0112457275390625 -0.005321502685546875 0.00323486328125 0.36376953125 0.281494140625 0.02947998046875 0.3935546875 0.042724609375 0.0096282958984375 0.01312255859375 0.058349609375 0.00994110107421875 0.156005859375 0.45751953125 0.295166015625
385 F6F45595-4033-4C79-A9F9-86DCA9088C37 2017-12-16T11:52:13+00:00 
[
    "Public"
]
 
[]
 heic bfe920659a1e209114e738c58fcc9e1df8cdd1eaed6ac7af4721f05865ba8935 2341576 51.50340333333333 -0.13203616666666668 0 0 0 0 0 0 0 0 London England United Kingdom F6F45595-4033-4C79-A9F9-86DCA9088C37 0.6103515625 0.5 0.0 0.8053669137809113 0.10000000149011612 -0.00572967529296875 -0.000789642333984375 0.0010814666748046875 0.019999999552965164 0.0447998046875 -0.095703125 0.048583984375 0.01238250732421875 -0.08880615234375 -0.05389404296875 -0.29736328125 -0.29248046875 0.0289306640625 -0.12152099609375 -0.001251220703125 -0.0276031494140625 0.0015192031860351562 0.022796630859375 -0.032806396484375 -0.325439453125 0.28076171875 -0.0489501953125
403 C75D24F7-AB72-4E8F-BBBB-A07E77CC5B91 2017-12-16T11:51:56+00:00 
[
    "Public"
]
 
[]
 heic c8b559b15a474986fdfb54b369eb86e9c5a65ec65c5fd1f6d37f3065953943d1 1699083 51.503391666666666 -0.13205283333333334 0 0 0 0 0 0 0 0 London England United Kingdom C75D24F7-AB72-4E8F-BBBB-A07E77CC5B91 0.6298828125 0.5 0.0 0.04200813515495708 0.10000000149011612 -0.001995086669921875 0.07391357421875 0.02069091796875 0.009999999776482582 -0.05419921875 -0.0638427734375 0.0679931640625 0.011962890625 -0.009521484375 -0.06158447265625 -0.0850830078125 0.0257568359375 0.0330810546875 0.201416015625 0.018402099609375 0.003326416015625 0.0038547515869140625 0.00971221923828125 -0.006549835205078125 0.006866455078125 -0.07818603515625 0.1031494140625
355 6CE10468-228C-4110-AB0B-663558FCF258 2017-12-16T11:51:32+00:00 
[
    "Public"
]
 
[]
 heic ac2fa4d70ca17a1face556a46a10868917800a96e5c48d0322a7e8a6903b6ae9 2369444 51.50336166666666 -0.13211666666666666 0 0 0 0 0 0 0 0 London England United Kingdom 6CE10468-228C-4110-AB0B-663558FCF258 0.6875 0.5 0.0 0.04202670814426801 0.10000000149011612 -0.0016489028930664062 0.08026123046875 0.0219879150390625 0.009999999776482582 0.25732421875 -0.055938720703125 0.0203857421875 0.01363372802734375 -0.0082550048828125 -0.040130615234375 0.19677734375 0.017578125 0.023193359375 0.279296875 0.022216796875 0.03936767578125 0.00760650634765625 0.01116180419921875 -0.00557708740234375 0.022735595703125 0.031005859375 0.200927734375
135 6274A881-9445-44D6-9E7C-776DAEF1C603 2017-12-16T11:51:31+00:00 
[
    "Public"
]
 
[]
 heic 3eb13ed43499313a2db919adf2b109b55dd49377096ac3edc35444b735a95b69 2120984 51.503355 -0.13211666666666666 0 0 0 0 0 0 0 0 London England United Kingdom 6274A881-9445-44D6-9E7C-776DAEF1C603 0.626953125 0.5 0.0 0.04200794951606343 0.10000000149011612 -0.002208709716796875 0.041107177734375 0.0035648345947265625 0.019999999552965164 0.14013671875 -0.07147216796875 0.12841796875 0.01009368896484375 -0.01061248779296875 -0.02294921875 0.0084228515625 -0.0406494140625 0.03143310546875 0.1263427734375 0.01114654541015625 -0.019287109375 0.005428314208984375 0.060211181640625 0.024200439453125 0.04046630859375 0.45068359375 0.143798828125
173 4E152F37-5FF2-43B0-BB98-FE9B6802BF55 2017-12-16T11:51:14+00:00 
[
    "Public"
]
 
[]
 heic 57da25cee1c32557167b6d5458ac3ea56f683150c2611d6d8ad6a9b6dbb27276 2072848 51.503303333333335 -0.1321805 1 0 0 0 0 0 0 0 London England United Kingdom 4E152F37-5FF2-43B0-BB98-FE9B6802BF55 0.5703125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0008358955383300781 0.032989501953125 0.00313568115234375 0.009999999776482582 -0.45654296875 -0.043121337890625 0.239501953125 0.0038547515869140625 -0.00919342041015625 -0.02197265625 -0.1068115234375 0.0599365234375 0.09857177734375 0.10504150390625 0.00670623779296875 -0.011199951171875 0.004467010498046875 0.097900390625 0.051239013671875 0.05975341796875 0.29052734375 -8.392333984375e-05
415 48EECE84-27A5-4AEC-9B09-6173F8700CEA 2017-12-16T11:51:09+00:00 
[
    "Public"
]
 
[]
 heic d1f5ff1dc55f467cc316d31897840e7ab50a1894823780b56c36e9ee6bda5c08 1806032 51.503303333333335 -0.1321805 0 0 0 0 0 0 0 0 London England United Kingdom 48EECE84-27A5-4AEC-9B09-6173F8700CEA 0.58349609375 0.5 0.0 0.04200794951606343 0.10000000149011612 -0.004520416259765625 0.0024871826171875 0.00269317626953125 0.019999999552965164 -0.498291015625 -0.06878662109375 0.1837158203125 0.006931304931640625 -0.023101806640625 -0.06317138671875 -0.370361328125 -0.158447265625 0.11920166015625 -0.0765380859375 -0.003047943115234375 -0.0631103515625 0.0030155181884765625 0.021575927734375 0.007659912109375 -0.190673828125 -0.0775146484375 -0.033233642578125
30 8876C417-C39E-453A-A865-2A997A6DAAF0 2017-12-16T11:51:05+00:00 
[
    "Public"
]
 
[]
 heic 11b66e49de0d6187d44d38601aefce96dfa29f419444d201b1e03422bd76dc14 1999722 51.503296666666664 -0.13221116666666666 0 0 0 0 0 0 0 0 London England United Kingdom 8876C417-C39E-453A-A865-2A997A6DAAF0 0.65673828125 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.01029205322265625 -0.0067291259765625 0.0014553070068359375 0.009999999776482582 -0.26220703125 -0.10125732421875 0.0670166015625 0.006984710693359375 -0.120361328125 -0.1640625 -0.50146484375 -0.361328125 0.06671142578125 -0.2410888671875 -0.0035266876220703125 -0.053955078125 0.0016489028930664062 0.005344390869140625 -0.1005859375 -0.46533203125 -0.158203125 -0.1329345703125

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