photos_with_apple_metadata (view)

13 rows where "date" is on date 2020-01-25 and place_country = "United States"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, date (date), albums (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
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

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