photos_with_apple_metadata (view)

9 rows where ZINTERACTIONSCORE = "0.05999999865889549" and albums = "["Public"]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ext, favorite, ZCURATIONSCORE, ZBEHAVIORALSCORE, 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
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
111 7C21930F-62A8-4540-91C4-E080707A4CC5 2019-11-02T20:31:20+00:00 
[
    "Public"
]
 
[]
 jpeg 36e9d2b9e79747b29aba0606d0b8a6a563111ad6a8213a36e618b33d5ee41b51 4685234     0 0 0 0 0 0 0 0       7C21930F-62A8-4540-91C4-E080707A4CC5 0.779296875 0.5 0.0 0.043530951929456406 0.1007542610168457 -0.0011835098266601562 0.025787353515625 0.0009326934814453125 0.05999999865889549 0.278076171875 -0.04083251953125 0.369140625 0.0016613006591796875 -0.0106964111328125 0.01271820068359375 0.024322509765625 0.04644775390625 0.0217742919921875 0.004058837890625 0.014617919921875 -0.00887298583984375 0.0007381439208984375 0.381103515625 0.61376953125 0.31591796875 0.67724609375 -0.0018157958984375
421 6DD60E1B-A93F-431C-BEE5-E7B2AEF430BE 2019-11-02T20:23:27+00:00 
[
    "Public"
]
 
[]
 jpeg d597f6879722f4f91e3558f509a859171132b60d7df319ba3fea358fa175d704 4948411     0 0 0 0 0 0 0 0       6DD60E1B-A93F-431C-BEE5-E7B2AEF430BE 0.599609375 0.25 0.0 0.02292342267873633 0.10000000149011612 -0.0014667510986328125 0.0130157470703125 0.00669097900390625 0.05999999865889549 -0.1693115234375 -0.10723876953125 0.125732421875 0.0100555419921875 -0.01029205322265625 -0.053619384765625 -0.46923828125 -0.0592041015625 0.12359619140625 0.00830078125 0.00091552734375 -0.0198974609375 0.005260467529296875 0.01262664794921875 -0.0024566650390625 -0.2452392578125 -0.17578125 0.0079345703125
114 4E45EBA2-F531-4076-8741-A6D18656D677 2019-11-02T20:23:08+00:00 
[
    "Public"
]
 
[]
 jpeg 37f9819e71d4e2ae622f37fb8f1ad0c4d03c6fbe5653f79a5e14ce551ad9a818 5085402     0 0 0 0 0 0 0 0       4E45EBA2-F531-4076-8741-A6D18656D677 0.5927734375 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0017414093017578125 -0.00809478759765625 0.0035247802734375 0.05999999865889549 -0.463134765625 -0.041839599609375 0.4140625 0.0005507469177246094 -0.016845703125 -0.0992431640625 -0.37353515625 -0.07208251953125 0.2237548828125 -0.1409912109375 -0.0031261444091796875 -0.0285491943359375 0.0023136138916015625 0.007232666015625 -0.00624847412109375 -0.316162109375 -0.35888671875 -0.059173583984375
246 1CE89584-DE92-4290-91D3-EDDFD28FEC5D 2019-09-15T12:51:42+00:00 
[
    "Public"
]
 
[]
 jpeg 78e814db89cff24f2189151f2b080c7aba9dcaa1b05e0d0444ca8b8111b46966 5301232     1 0 0 0 0 0 0 0       1CE89584-DE92-4290-91D3-EDDFD28FEC5D 0.703125 0.75 0.0 0.06262847985930116 0.5045985579490662 -0.0006413459777832031 0.021331787109375 0.0020351409912109375 0.05999999865889549 0.6328125 -0.061309814453125 0.012725830078125 0.037109375 -0.008544921875 0.0101776123046875 0.285888671875 0.2958984375 0.01242828369140625 0.1907958984375 0.0125732421875 0.001712799072265625 0.006122589111328125 0.441650390625 0.5263671875 0.0867919921875 0.86328125 0.423095703125
382 3C46B23E-EDE6-4CE9-97F6-FED24AF41F91 2019-08-21T16:06:06+00:00 
[
    "Public"
]
 
[]
 jpeg be83d91388b3a7f6df3475a9d0557e957e9aa49a7fc2690dd8942b52971b4af5 6115387     1 0 0 0 0 0 0 0       3C46B23E-EDE6-4CE9-97F6-FED24AF41F91 0.6962890625 0.75 0.0 0.06110547744590818 0.10000000149011612 -0.0008425712585449219 0.0278778076171875 0.003040313720703125 0.05999999865889549 0.2415771484375 -0.061767578125 0.2044677734375 0.0029125213623046875 -0.008880615234375 0.000732421875 -0.03826904296875 0.07666015625 0.0279083251953125 0.06536865234375 0.00994110107421875 -0.0045166015625 0.001949310302734375 0.09271240234375 0.0833740234375 0.048828125 0.43115234375 0.0914306640625
128 B2F26E79-7A85-497E-AD2F-D599633EA720 2019-08-21T11:43:53+00:00 
[
    "Public"
]
 
[]
 jpeg 3bd461b7f1c5b8c4de844951f86168d510082ae55c2a23223b7cc5ada0ce29f5 7020346     1 0 0 0 0 0 0 0       B2F26E79-7A85-497E-AD2F-D599633EA720 0.57568359375 0.75 0.0 0.061105291352017234 0.10000000149011612 -0.005889892578125 0.0174102783203125 0.0021572113037109375 0.05999999865889549 -0.1673583984375 -0.08465576171875 0.066162109375 0.01282501220703125 -0.0211181640625 -0.022796630859375 -0.159423828125 -0.1455078125 0.0416259765625 0.03692626953125 0.0023956298828125 -0.00726318359375 0.0027904510498046875 0.0987548828125 0.1475830078125 0.02117919921875 0.413818359375 0.025848388671875
23 39333D7D-3020-4A1B-970D-44F2DD6D5C52 2019-05-19T23:50:19+00:00 
[
    "Public"
]
 
[]
 jpeg 0d2584a5003fb23424777e259d0c437f3bfc567318f8e4cd4298570bf8da6947 5078550     0 0 0 0 0 0 0 0       39333D7D-3020-4A1B-970D-44F2DD6D5C52 0.68408203125 0.5 0.0 0.04356772708528824 0.10000000149011612 -0.0016813278198242188 0.00276947021484375 0.00453948974609375 0.05999999865889549 -0.255859375 -0.09027099609375 0.2310791015625 0.004180908203125 -0.014007568359375 -0.055145263671875 -0.4873046875 -0.0653076171875 0.17822265625 -0.05279541015625 -0.005138397216796875 -0.0148162841796875 0.0026836395263671875 0.01267242431640625 0.0071868896484375 -0.35205078125 -0.310546875 -0.05792236328125
18 6D5FD270-8DB3-46AE-8B1E-99C575B2885C 2019-03-31T18:54:34+00:00 
[
    "Public"
]
 
[]
 jpeg 0a4cf96c0126d57760a1dbebe3d63d7afbbbc1f896fb3db11ae73c722225bb43 5222631     0 0 0 0 0 0 0 0       6D5FD270-8DB3-46AE-8B1E-99C575B2885C 0.61376953125 0.5 0.0 0.042032280041061285 0.9082725048065186 -0.000293731689453125 0.09539794921875 0.0034027099609375 0.05999999865889549 0.68017578125 -0.037384033203125 0.1748046875 0.0125732421875 -0.00397491455078125 0.03961181640625 0.33203125 0.4140625 0.1251220703125 0.374267578125 0.06988525390625 0.0091552734375 0.01073455810546875 0.47314453125 0.630859375 0.24658203125 0.77197265625 0.456298828125

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