photos_with_apple_metadata (view)

8 rows where ZHIGHLIGHTVISIBILITYSCORE = "0.038931297721298594", albums contains "Museums" and place_city = "San Francisco"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: persons, ext, ZBEHAVIORALSCORE, ZIMMERSIVENESSSCORE, 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
312 C2CA0ADD-619E-4955-B88D-B5C7CB3005EB 2018-03-25T23:57:33+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 978eaabc0e123d079004bd4c698fc270eb2f9809bede347ae862d7c1cebe68fd 1546916 37.73271166666667 -122.46839166666666 0 0 0 0 0 0 0 0 San Francisco CA United States C2CA0ADD-619E-4955-B88D-B5C7CB3005EB 0.386962890625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.007965087890625 0.041656494140625 0.0216522216796875 0.009999999776482582 -0.0947265625 -0.0699462890625 -0.07989501953125 0.046905517578125 -0.01971435546875 -0.039886474609375 0.04833984375 -0.2398681640625 0.018402099609375 0.1732177734375 0.007965087890625 0.0758056640625 0.006565093994140625 0.00494384765625 -0.03369140625 0.00649261474609375 -0.0401611328125 0.244384765625
267 A91633D1-A015-4857-AFD6-C27279445751 2018-03-25T23:57:19+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 814e5de6c8f35a62f5dacc6749fd74aa11f0ba3c80704f3f929b0d1e03895c23 1996328 37.73272 -122.4684 0 0 0 0 0 0 0 0 San Francisco CA United States A91633D1-A015-4857-AFD6-C27279445751 0.363037109375 0.5 0.0 0.038931297721298594 0.5035036206245422 -0.0007352828979492188 0.0462646484375 0.0279083251953125 0.009999999776482582 0.416015625 -0.05706787109375 -0.11419677734375 0.024993896484375 -0.00586700439453125 -0.00908660888671875 0.41357421875 0.03125 0.0203704833984375 0.34326171875 0.0140380859375 0.00809478759765625 0.020965576171875 0.020721435546875 0.00106048583984375 0.01141357421875 0.102783203125 0.078369140625
121 76336F73-88DA-4E89-8E57-4A38FEA2986B 2017-10-27T20:53:21+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 39fd5df732f4fb55c94fc2d90bbe3abcf8e5a748d6b5800817d063c4f1a5e0c5 1735752 37.80936166666667 -122.42176166666667 0 0 0 0 0 0 0 0 San Francisco CA United States 76336F73-88DA-4E89-8E57-4A38FEA2986B 0.413818359375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0007381439208984375 0.0229949951171875 0.0022258758544921875 0.009999999776482582 -0.254638671875 -0.0230255126953125 0.07403564453125 0.00905609130859375 -0.01450347900390625 0.0073089599609375 0.19091796875 0.10369873046875 0.03436279296875 0.240478515625 0.0076141357421875 -0.003936767578125 0.0083160400390625 0.33203125 0.13232421875 0.221435546875 0.76416015625 0.01605224609375
181 3E20BE4D-619A-42EC-9CAA-6F67508892E4 2017-10-27T20:41:30+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 5a3a4b0ffc8de931dd6dd0c977df4b444421a404c820c795346c8faffc984ffa 1744396 37.809145 -122.42119666666666 0 0 0 0 0 0 0 0 San Francisco CA United States 3E20BE4D-619A-42EC-9CAA-6F67508892E4 0.49169921875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0024929046630859375 -0.006275177001953125 0.003692626953125 0.009999999776482582 -0.309814453125 -0.0948486328125 0.2303466796875 0.0018968582153320312 -0.022247314453125 -0.13623046875 -0.5966796875 -0.132568359375 0.188232421875 -0.1619873046875 -0.0025348663330078125 -0.020538330078125 0.0019044876098632812 0.004505157470703125 -0.01824951171875 -0.40283203125 -0.51416015625 -0.1053466796875
396 AC4419FA-ED22-473F-8FB0-15B647BB2FBD 2017-10-27T20:35:55+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic c5e23798acf2cbff48fd65696d94e1326f128cf3e60230b7023fece6bebafa87 1777363 37.81 -122.422325 0 0 0 0 0 0 0 0 San Francisco CA United States AC4419FA-ED22-473F-8FB0-15B647BB2FBD 0.4951171875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.01016998291015625 -0.0117034912109375 0.004364013671875 0.009999999776482582 -0.28955078125 -0.061431884765625 0.0799560546875 0.017181396484375 -0.1041259765625 -0.07489013671875 -0.485107421875 -0.324462890625 0.2017822265625 -0.0938720703125 -0.0036525726318359375 -0.0207061767578125 0.003063201904296875 0.00263214111328125 -0.061798095703125 -0.392822265625 -0.4423828125 -0.12066650390625
393 9FAD352B-5A8E-4A93-B84D-5EB5D0A6C409 2017-10-27T20:27:34+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic c57c252d8bb404e1de2a5015c6ac7b6a99e131d72a9ce002dd65564b4f8b10fd 1638873 37.80999666666666 -122.42220333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 9FAD352B-5A8E-4A93-B84D-5EB5D0A6C409 0.459228515625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004791259765625 0.033355712890625 0.00323486328125 0.009999999776482582 -0.90087890625 -0.0262603759765625 0.24462890625 0.01953125 -0.0194549560546875 -0.021209716796875 -0.134521484375 -0.09967041015625 0.0704345703125 0.013671875 -0.0697021484375 -0.011474609375 0.003040313720703125 0.038330078125 0.0077056884765625 0.04486083984375 0.0809326171875 -0.00347137451171875
188 F19B5D7D-EFD0-4BE6-B335-CBE309FABB41 2017-06-16T01:28:19+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 5dd80ab326459d68c5d9acc8f7094aa4761b9f98ff7f774a3c8b1c25cbf49f83 4286630 37.772616666666664 -122.45991333333333 0 0 0 0 0 0 0 0 San Francisco CA United States F19B5D7D-EFD0-4BE6-B335-CBE309FABB41 0.453857421875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0008759498596191406 0.00547027587890625 0.004665374755859375 0.009999999776482582 0.0380859375 -0.0469970703125 0.416259765625 0.0010776519775390625 -0.01242828369140625 -0.03662109375 -0.201904296875 -0.02239990234375 0.16748046875 -0.04937744140625 -0.00043487548828125 -0.0169219970703125 0.0029354095458984375 0.0142822265625 0.00278472900390625 -0.38525390625 -0.0262451171875 -0.069580078125
211 E4D43462-07AB-4803-9DCB-02B8321D8D94 2016-01-13T20:30:46+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 692e3b73c2d9297f354c7b9827d05cd697fd4b83885747a869b2478ec44632c5 2259762 37.78168 -122.411025 0 0 0 0 0 0 0 0 San Francisco CA United States E4D43462-07AB-4803-9DCB-02B8321D8D94 0.22265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0007615089416503906 0.0242156982421875 0.0022258758544921875 0.009999999776482582 -0.11474609375 -0.08343505859375 0.0714111328125 0.0144500732421875 -0.01009368896484375 -0.0028076171875 -0.100341796875 0.0386962890625 0.07476806640625 0.2037353515625 0.00543975830078125 -0.00792694091796875 0.008575439453125 0.1524658203125 0.10986328125 -0.04443359375 0.56005859375 0.039520263671875

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