photos_with_apple_metadata (view)

11 rows where ZCURATIONSCORE = "0.25", panorama = 0 and screenshot = 0

View and edit SQL

Suggested facets: albums, persons, ext, latitude, longitude, place_city, ZHIGHLIGHTVISIBILITYSCORE, ZINTERACTIONSCORE, ZINTRUSIVEOBJECTPRESENCESCORE, 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
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
35 13A4ED05-8B7F-4F49-A613-3B916B11555E 2018-05-18T19:48:16+00:00
[
    "Museums",
    "Public"
]
[]
heic 13d35a66a9899bc4c0bcd7ddcefca2e1463713bf1eab69f358debaa67cce9316 1873236 37.041466666666665 -122.07261666666666 0 0 0 0 0 0 0 0 Felton CA United States 13A4ED05-8B7F-4F49-A613-3B916B11555E 0.28564453125 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.00473785400390625 -0.002880096435546875 0.0032482147216796875 0.009999999776482582 -0.56298828125 -0.05340576171875 0.09906005859375 0.008514404296875 -0.05023193359375 -0.08984375 -0.385498046875 -0.2186279296875 0.167724609375 -0.09698486328125 -0.0020904541015625 -0.048095703125 0.004627227783203125 0.00971221923828125 -0.01702880859375 -0.1688232421875 -0.16796875 -0.03009033203125
410 F55C40DC-FF30-40F0-92BD-FBD1BD14B68B 2018-04-22T00:18:11+00:00
[
    "Museums",
    "Public"
]
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
heic ccd368e8a772e5ac1a2ebf1ddebf143dbd84c871ebaaedc39c24b4266ee08e7a 1495272 37.57904666666667 -122.34413833333333 0 0 0 0 0 0 0 0 Burlingame CA United States F55C40DC-FF30-40F0-92BD-FBD1BD14B68B 0.1875 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.012054443359375 -0.01104736328125 0.0017414093017578125 0.009999999776482582 -0.1734619140625 -0.09124755859375 0.07891845703125 0.010986328125 -0.1014404296875 -0.08251953125 -0.462646484375 -0.359130859375 0.07611083984375 -0.150390625 -0.00496673583984375 -0.0238494873046875 0.0022335052490234375 0.007755279541015625 -0.208251953125 -0.61328125 0.0023193359375 -0.1900634765625
289 277756C5-6924-4E30-877D-CD2CE30630FD 2018-04-22T00:17:52+00:00
[
    "Museums",
    "Public"
]
[]
heic 8badd750c2e09ba7e96fe2d48833f66990b14e348cda9269ebd0444d6694b2af 1177569 37.579096666666665 -122.34413833333333 0 0 0 0 0 0 0 0 Burlingame CA United States 277756C5-6924-4E30-877D-CD2CE30630FD 0.266357421875 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.003795623779296875 -0.0030517578125 0.0010366439819335938 0.009999999776482582 -0.449951171875 -0.03875732421875 0.1923828125 0.00323486328125 -0.07781982421875 -0.06396484375 -0.1732177734375 -0.1572265625 0.07476806640625 -0.1436767578125 -0.00726318359375 -0.03466796875 0.0022602081298828125 0.035736083984375 -0.0068206787109375 -0.1612548828125 0.345703125 -0.03826904296875
392 2072695E-48EC-4C6E-9AFE-61F6590F67D5 2018-04-22T00:10:18+00:00
[
    "Museums",
    "Public"
]
[]
heic c51fccdae579f930cf5e5523b5dd56c5e35900718a323b2451014d6c6b01ba42 1310899 37.57915 -122.3441 0 0 0 0 0 0 0 0 Burlingame CA United States 2072695E-48EC-4C6E-9AFE-61F6590F67D5 0.340576171875 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.00443267822265625 -0.00213623046875 0.0015916824340820312 0.009999999776482582 -0.85986328125 -0.03253173828125 0.2386474609375 0.0009365081787109375 -0.022247314453125 -0.043243408203125 -0.1949462890625 -0.1187744140625 0.07342529296875 -0.06146240234375 -0.0161895751953125 -0.0694580078125 0.001956939697265625 0.02508544921875 0.0008697509765625 0.0228271484375 0.1063232421875 -0.014068603515625
484 75D227E6-3F2B-41A8-9977-E9B55255C861 2018-04-22T00:03:04+00:00
[
    "Museums",
    "Public"
]
[]
heic f8daca217ac8cad995c653260c325158ac80e59e5379ab8be5c339a304cd3378 1924547 37.57926166666667 -122.34416166666666 0 0 0 0 0 0 0 0 Burlingame CA United States 75D227E6-3F2B-41A8-9977-E9B55255C861 0.17236328125 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.00536346435546875 0.003108978271484375 0.004718780517578125 0.009999999776482582 -0.2900390625 -0.139892578125 -0.10870361328125 0.0699462890625 -0.03338623046875 -0.060302734375 -0.52392578125 -0.42333984375 0.15771484375 0.0250244140625 0.0015716552734375 -0.01311492919921875 0.0117340087890625 0.009521484375 -0.08758544921875 -0.118408203125 -0.0535888671875 0.0139007568359375
464 61A142C7-A526-4AE1-A1B5-C6FB3CE73EBC 2018-04-22T00:00:15+00:00
[
    "Museums",
    "Public"
]
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
heic e9ca2c634c5bd6c32b8b1eff0a8e907e16256a4245af095292831a5ba124ffa0 1480015 37.57921666666667 -122.34423833333334 0 0 0 0 0 0 0 0 Burlingame CA United States 61A142C7-A526-4AE1-A1B5-C6FB3CE73EBC 0.420166015625 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.0068511962890625 0.015228271484375 0.0059356689453125 0.009999999776482582 -0.2369384765625 -0.09124755859375 -0.0821533203125 0.04107666015625 -0.034027099609375 -0.052093505859375 -0.26123046875 -0.32080078125 0.0325927734375 0.0858154296875 0.006381988525390625 -0.004791259765625 0.004364013671875 0.01036834716796875 -0.05767822265625 0.0079803466796875 0.0189208984375 0.0738525390625
249 DAEEB402-23FC-4CFB-9C40-75DF9B7C0E8F 2018-04-21T23:55:29+00:00
[
    "Museums",
    "Public"
]
[]
heic 798436ad6175c55c8785bfbc10c8ffe60913b521a52312735f138f37e3cb4d81 1173698 37.579053333333334 -122.34420833333333 0 0 0 0 0 0 0 0 Burlingame CA United States DAEEB402-23FC-4CFB-9C40-75DF9B7C0E8F 0.27099609375 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.005279541015625 0.00095367431640625 0.00243377685546875 0.019999999552965164 -0.41845703125 -0.12200927734375 0.01702880859375 0.0144500732421875 -0.038970947265625 -0.09381103515625 -0.54541015625 -0.300048828125 0.050048828125 -0.0985107421875 -0.00109100341796875 -0.01496124267578125 0.0021915435791015625 0.012237548828125 -0.0482177734375 -0.16259765625 -0.0987548828125 -0.0265350341796875
210 B0DD56EB-03F6-4362-8DAA-DE8580838F78 2018-04-21T23:55:28+00:00
[
    "Museums",
    "Public"
]
[]
heic 68b5459d668a8a495c751e177b6c405f27b6e5506502fdd305a6eb0950230854 1265702 37.579053333333334 -122.34420833333333 0 0 0 0 0 0 0 0 Burlingame CA United States B0DD56EB-03F6-4362-8DAA-DE8580838F78 0.229736328125 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.0028553009033203125 0.0131378173828125 0.0029125213623046875 0.009999999776482582 -0.3740234375 -0.05340576171875 0.189697265625 0.00734710693359375 -0.0302734375 -0.09271240234375 -0.25390625 -0.08935546875 0.1517333984375 -0.0830078125 0.006061553955078125 -0.0220489501953125 0.0037212371826171875 0.035888671875 0.0182952880859375 -0.04473876953125 0.0482177734375 -0.020416259765625
134 CF759040-2FAD-4203-8C0F-88DF33C894BC 2016-03-21T00:20:29+00:00
[
    "Public"
]
[]
jpeg 3cb22fc3dc3413773a9a2d5a54948c5ffaafd400b09b6c327ff29360ad0d498d 2336745 37.80468333333334 -122.47161166666666 0 0 0 0 0 0 0 0 San Francisco CA United States CF759040-2FAD-4203-8C0F-88DF33C894BC 0.1688232421875 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.0005173683166503906 0.01345062255859375 0.004024505615234375 0.009999999776482582 0.29541015625 -0.0188751220703125 0.46044921875 0.0005035400390625 -0.01450347900390625 -0.011962890625 0.0089111328125 -0.0125732421875 0.1661376953125 -0.0172119140625 0.00833892822265625 -0.0139617919921875 0.004924774169921875 0.02288818359375 0.00434112548828125 0.0689697265625 0.395751953125 -0.023162841796875
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

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