photos_with_apple_metadata (view)

13 rows where place_city = "Pescadero" sorted by ZOVERALLAESTHETICSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, date (date), albums (array)

place_state_province ✖

place_country ✖

place_city ✖

  • Pescadero · 13 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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