photos_with_apple_metadata (view)

3 rows where place_country = "Madagascar"

View and edit SQL

Suggested facets: albums, place_state_province, ZINTERACTIONSCORE, 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
43 A06B7B8E-4BF6-4906-A1E6-0CA4CF0E28E8 2019-08-07T06:22:37+00:00
[
    "Museums",
    "Public"
]
[]
heic 1698c710dab87f0f6aeee3f3ef95a0c7f1296abc949dc5d602cdff89c6ec63c5 2233828 -18.907088333333334 47.518475 1 0 0 0 0 0 0 0 Antananarivo Antananarivo Madagascar A06B7B8E-4BF6-4906-A1E6-0CA4CF0E28E8 0.32763671875 0.75 0.0 0.05801763419659083 0.7049635052680969 -0.0004305839538574219 0.07659912109375 0.002471923828125 0.019999999552965164 0.728515625 -0.0227203369140625 0.0977783203125 0.01422882080078125 -0.004398345947265625 0.0112457275390625 0.47314453125 0.401123046875 0.0261077880859375 0.326416015625 0.042083740234375 0.005859375 0.007038116455078125 0.63232421875 0.70458984375 0.4091796875 0.88330078125 0.5439453125
301 6560AE2B-6571-400C-AE36-5249A5F7940D 2019-08-02T09:58:38+00:00
[
    "To Instagram",
    "Public"
]
[]
heic 9038a30de690deff661d96a60e74dc4e02c13bdcc932240c32e57c0d92c55a54 1141832 -12.524263333333334 49.175421666666665 1 0 0 0 0 0 0 0   Antsiranana Madagascar 6560AE2B-6571-400C-AE36-5249A5F7940D 0.587890625 0.75 0.0 0.061096562229040016 0.5037956237792969 -0.0004107952117919922 0.069580078125 0.006771087646484375 0.009999999776482582 0.086181640625 -0.03436279296875 0.0643310546875 0.040374755859375 -0.006145477294921875 0.0169525146484375 0.32177734375 0.341796875 0.10992431640625 0.414306640625 0.04290771484375 0.00167083740234375 0.026702880859375 0.253662109375 0.1519775390625 0.1221923828125 0.65380859375 0.057403564453125
180 0F308AB5-4F16-4C67-A84E-310F85B63E4E 2019-08-02T09:31:50+00:00
[
    "To Instagram",
    "Public"
]
[]
heic 59acef10149934e3af1e1078d07b77cb367d6227ca00cf93d93d7576b5bf2525 1082591 -12.526836666666666 49.17201166666667 1 0 0 0 0 0 0 0   Antsiranana Madagascar 0F308AB5-4F16-4C67-A84E-310F85B63E4E 0.5078125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.004100799560546875 0.06683349609375 0.01395416259765625 0.009999999776482582 -0.1656494140625 -0.035400390625 0.06732177734375 0.048309326171875 -0.0202178955078125 -0.016998291015625 0.005615234375 0.0098876953125 0.06610107421875 0.1409912109375 0.04559326171875 0.00055694580078125 0.00555419921875 0.030914306640625 0.030181884765625 0.06134033203125 0.038818359375 0.02703857421875

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