photos_with_apple_metadata (view)

13 rows where ZINTERACTIONSCORE = "0.05999999865889549" and persons = "[]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, ext, favorite, place_country, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZPLEASANTCAMERATILTSCORE, 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
151 43A4A851-4821-4125-A673-C1E9FCF2F9AC 2019-06-03T21:20:05+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 487c1ddfc65c37e0d20b4eb88864fd696fa68f5af025a4597115a7870d4a9e53 1917644 38.576375 -121.49330833333333 1 0 0 0 0 0 0 0 Sacramento CA United States 43A4A851-4821-4125-A673-C1E9FCF2F9AC 0.39794921875 0.75 0.0 0.05801526718694745 0.9074695706367493 -0.00034737586975097656 0.05255126953125 0.0016679763793945312 0.05999999865889549 0.7802734375 -0.03985595703125 0.09161376953125 0.01009368896484375 -0.002620697021484375 0.0107879638671875 0.4326171875 0.42333984375 0.0135345458984375 0.255615234375 0.0230560302734375 0.0037899017333984375 0.004329681396484375 0.73388671875 0.84716796875 0.241455078125 0.90087890625 0.541015625
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
445 7E21418A-1A30-43AB-B025-4D6576EA29CE 2019-03-22T22:51:03+00:00 
[
    "Super bloom 2019",
    "Public"
]
 
[]
 jpeg e2545bfd95a2eeda1f7954786d30c987dcedf4f46b4138334b81a4b70d546fa1 9499051     1 0 0 0 0 0 0 0       7E21418A-1A30-43AB-B025-4D6576EA29CE 0.6044921875 0.75 0.0 0.06108839002274375 0.5067153573036194 -0.000720977783203125 0.05499267578125 0.0169219970703125 0.05999999865889549 0.2783203125 -0.059967041015625 0.048614501953125 0.007785797119140625 -0.00763702392578125 -0.038543701171875 0.0819091796875 0.0599365234375 0.04534912109375 0.256103515625 0.0198974609375 0.002166748046875 0.00844573974609375 0.0153045654296875 -0.000885009765625 0.0233612060546875 0.0638427734375 0.095703125
329 D2E8BA79-361D-4888-BCE6-80E7DEE2D5D8 2018-02-13T18:53:48+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg a02327731c68afc82e3f442932167fd2a273ea95c0fa968b0199a73141dd99f4 5960871 25.737367127877967 -111.09099263484735 0 0 0 0 0 0 0 0     Mexico D2E8BA79-361D-4888-BCE6-80E7DEE2D5D8 0.76025390625 0.5 0.0 0.04353076629056275 0.10111922025680542 -0.00070953369140625 0.08514404296875 0.003692626953125 0.05999999865889549 0.16162109375 -0.01812744140625 0.403076171875 0.00274658203125 -0.0069580078125 0.005615234375 0.1458740234375 0.09783935546875 0.054290771484375 0.1104736328125 0.02960205078125 -0.00168609619140625 0.00441741943359375 0.157958984375 0.078125 0.41064453125 0.6162109375 0.0361328125
380 D735F0CE-A3D7-49CB-B83E-594604415A1C 2017-06-16T00:55:34+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg be2e31a4d8ecf12e6631c7fbd0a093a446a7d23ef5dbeb412c41c14907357d16 5296680 37.76930333333333 -122.46441666666666 0 0 0 0 0 0 0 0 San Francisco CA United States D735F0CE-A3D7-49CB-B83E-594604415A1C 0.498291015625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.003063201904296875 -0.00627899169921875 0.0009851455688476562 0.05999999865889549 -0.296875 -0.03656005859375 0.28271484375 0.002140045166015625 -0.06622314453125 -0.07977294921875 -0.1859130859375 -0.1502685546875 0.1431884765625 -0.178466796875 -0.00289154052734375 -0.0833740234375 0.002590179443359375 0.0217742919921875 -0.00293731689453125 -0.33740234375 0.17333984375 -0.05267333984375

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