photos_with_apple_metadata (view)

4 rows where "date" is on date 2017-07-23

View and edit SQL

Suggested facets: persons, ZINTERACTIONSCORE, 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
62 ADE494D7-0048-491A-B410-D04C5C58B0DD 2017-07-23T22:20:34+00:00
[
    "Museums",
    "Public"
]
[]
jpeg 1cfb72be21bffca1c026c49845045769dc2791f7844d85d14e74257325d83b23 1988831 37.84245 -122.27783333333333 0 0 0 0 0 0 0 0 Oakland CA United States ADE494D7-0048-491A-B410-D04C5C58B0DD 0.501953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0014553070068359375 0.0223541259765625 0.0022430419921875 0.019999999552965164 -0.1689453125 -0.0207672119140625 0.274169921875 0.0016107559204101562 -0.023284912109375 -0.021148681640625 0.013336181640625 -0.008758544921875 0.0755615234375 0.031982421875 0.0097198486328125 -0.0099945068359375 0.0033512115478515625 0.11163330078125 0.041748046875 0.31640625 0.488037109375 -0.00374603271484375
470 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 2017-07-23T22:13:38+00:00
[
    "Museums",
    "Public"
]
[
    "_UNKNOWN_"
]
jpeg edcd504a5dc67013013c8de46adbc2f586d9d56e572d634d594390fd81b20a95 2233683 37.84250333333333 -122.27778666666667 0 0 0 0 0 0 0 0 Oakland CA United States 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 0.405517578125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0017681121826171875 -0.00296783447265625 0.0022258758544921875 0.009999999776482582 -0.478271484375 -0.06671142578125 0.252685546875 0.0009074211120605469 -0.0202178955078125 -0.118896484375 -0.44580078125 -0.0966796875 0.0823974609375 -0.167724609375 -0.0023097991943359375 -0.034423828125 0.0016355514526367188 0.01061248779296875 -0.007694244384765625 -0.294677734375 -0.1962890625 -0.0555419921875
303 97F0AC20-F45C-40F3-BA5F-66210B77A487 2017-07-23T22:11:35+00:00
[
    "Museums",
    "Public"
]
[]
jpeg 91cd63d05fe337816cae4ca57e9882ccdc5d6f8b921236e703a55e50f116d08d 2629022 37.8424 -122.27777166666667 0 0 0 0 0 0 0 0 Oakland CA United States 97F0AC20-F45C-40F3-BA5F-66210B77A487 0.297119140625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0029354095458984375 0.0163421630859375 0.007232666015625 0.009999999776482582 -0.96923828125 -0.013427734375 0.134765625 0.0004189014434814453 -0.00426483154296875 -0.003582000732421875 0.0882568359375 0.003173828125 0.0131683349609375 0.037261962890625 -0.044189453125 -0.003276824951171875 0.0025806427001953125 0.063720703125 0.0175018310546875 0.2188720703125 0.2841796875 0.0013952255249023438
56 82A5EDE6-0455-46D5-82C4-0FF4E355D8FC 2017-07-23T22:07:25+00:00
[
    "Museums",
    "Public"
]
[]
jpeg 1b68d008a6d555d3a21f96a9ea31e9c1c6513395b93d3349061a5cc8825080b1 2341575 37.842288333333336 -122.27801333333333 0 0 0 0 0 0 0 0 Oakland CA United States 82A5EDE6-0455-46D5-82C4-0FF4E355D8FC 0.35009765625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00399017333984375 0.00577545166015625 0.004100799560546875 0.009999999776482582 -0.92431640625 -0.02276611328125 0.242431640625 0.0013723373413085938 -0.0115509033203125 -0.0203857421875 -0.1290283203125 -0.090576171875 0.090087890625 -0.0042724609375 -0.0312347412109375 -0.01210784912109375 0.0033893585205078125 0.022796630859375 -0.008026123046875 0.05572509765625 0.0567626953125 -0.005092620849609375

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