photos_with_apple_metadata (view)

8 rows where ZINTERACTIONSCORE = "0.05999999865889549" and favorite = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, persons, ext, place_country, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, 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
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
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
481 3CEC2620-AD7D-45EC-A746-FDCADB335D44 2018-04-22T00:17:38+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 heic f580d10cba72fc669695ff3085997ee5f65672ae53c3ef0af3d6fa9e6ce9f508 1111271 37.57918 -122.34427 0 0 0 0 0 0 0 0 Burlingame CA United States 3CEC2620-AD7D-45EC-A746-FDCADB335D44 0.10760498046875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0048675537109375 -0.0013580322265625 0.0026111602783203125 0.05999999865889549 0.0594482421875 -0.04840087890625 0.0380859375 0.025421142578125 -0.11553955078125 -0.04345703125 -0.164306640625 -0.293212890625 0.13671875 -0.05029296875 -7.2479248046875e-05 -0.016326904296875 0.007122039794921875 0.0154876708984375 -0.04864501953125 -0.261474609375 0.332275390625 -0.03924560546875
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 286.335ms · About: dogsheep/dogsheep-photos