photos_with_apple_metadata (view)

12 rows where albums = "["Museums", "Public"]" and place_city = "San Francisco"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: persons, ext, latitude, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZIMMERSIVENESSSCORE, date (date), albums (array), persons (array)

place_state_province ✖

place_country ✖

place_city ✖

  • San Francisco · 12 ✖

albums ✖

  • ["Museums", "Public"] · 12 ✖
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
123 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 2019-06-11T21:41:06+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 3a6bbcb6f079e26dc3577577ee795523912c002627087c9cf658f757f690d989 2226634 37.78167 -122.40270333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 0.4443359375 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.001155853271484375 0.018402099609375 0.0016546249389648438 0.009999999776482582 -0.06689453125 -0.03125 0.2587890625 0.00257110595703125 -0.01678466796875 -0.00225830078125 -0.004638671875 0.0 0.0869140625 0.03759765625 0.006435394287109375 -0.011322021484375 0.004085540771484375 0.1719970703125 0.11846923828125 0.126953125 0.595703125 -0.00284576416015625
150 C72BFA8A-CE27-403A-B0C3-83D20CF6EB3C 2018-03-25T23:58:04+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 486a9d6bad60a510919292a3e18dd70e4ca8159162f601bbce169d6e1af9ff7c 1807589 37.73271666666667 -122.468375 0 0 0 0 0 0 0 0 San Francisco CA United States C72BFA8A-CE27-403A-B0C3-83D20CF6EB3C 0.404052734375 0.6 0.0 0.04656488550755814 0.7025547623634338 -0.0005035400390625 0.2156982421875 0.046295166015625 0.009999999776482582 0.42041015625 -0.0386962890625 0.1458740234375 0.0095977783203125 -0.0024623870849609375 -0.0104217529296875 0.35400390625 0.337890625 0.03265380859375 0.347900390625 0.052764892578125 0.0186767578125 0.00701141357421875 0.021331787109375 0.00738525390625 0.01324462890625 -0.004425048828125 0.153564453125
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
120 14B6764F-C911-4A53-8A56-28D1DE9F634A 2018-03-25T23:57:03+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 3987ed15effdd8611ae43e0dbfa66d69bf3f246de9ebcc481524d5b5b75a7b2c 1567970 37.73272 -122.46841333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 14B6764F-C911-4A53-8A56-28D1DE9F634A 0.453125 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.027069091796875 0.00571441650390625 0.01029205322265625 0.009999999776482582 -0.689453125 -0.0970458984375 -0.28955078125 0.05987548828125 -0.04949951171875 -0.03485107421875 -0.38720703125 -0.634765625 0.012237548828125 0.04443359375 0.0016651153564453125 -0.00444793701171875 0.0038547515869140625 0.0036640167236328125 -0.157470703125 0.002780914306640625 -0.08416748046875 0.01250457763671875
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
264 B3EDB403-A948-4ABA-BFE4-2C504A636F7A 2016-01-13T20:43:53+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 7fa46682650e464a6bd09bee294607900c198152b680393dc4f3f5666c0db695 2302070 37.78062833333333 -122.41036166666666 0 0 0 0 0 0 0 0 San Francisco CA United States B3EDB403-A948-4ABA-BFE4-2C504A636F7A 0.365478515625 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.0060272216796875 0.0101470947265625 0.0297088623046875 0.009999999776482582 -0.211669921875 -0.046722412109375 -0.1920166015625 0.11181640625 -0.053192138671875 -0.039581298828125 -0.1484375 -0.43408203125 0.22802734375 0.0792236328125 0.00518035888671875 -0.0051727294921875 0.043853759765625 0.004085540771484375 -0.05242919921875 -0.0291748046875 -0.06365966796875 0.00762176513671875
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 217.978ms · About: dogsheep/dogsheep-photos