photos_with_apple_metadata (view)

6 rows where favorite = 1 and persons contains "_UNKNOWN_"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, persons, place_city, place_state_province, place_country, ZBEHAVIORALSCORE, 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
116 159FCAD3-7088-4AEB-929A-7BCDFF4A628A 2019-09-16T16:27:24+00:00 
[
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 38c5c9797285ca569d63a524a7a217b562c289e2b8068122e5dd7329348cfe4c 1987600 37.449821666666665 -122.18592 1 0 0 0 0 0 0 0 Menlo Park CA United States 159FCAD3-7088-4AEB-929A-7BCDFF4A628A 0.443115234375 0.75 0.0 0.9740458015380925 0.10000000149011612 -0.000743865966796875 0.0360107421875 0.0125732421875 0.009999999776482582 0.1959228515625 -0.08599853515625 0.06207275390625 0.020965576171875 -0.00963592529296875 -0.040130615234375 -0.1871337890625 0.0689697265625 0.23583984375 0.19287109375 0.013458251953125 -0.00125885009765625 0.0169219970703125 0.0169219970703125 0.00560760498046875 -0.0806884765625 -0.0244140625 0.116943359375
282 7E07EFBF-1F63-4142-8856-7DCD9F906811 2019-09-14T16:27:56+00:00 
[
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 86e8a0932628c6450de3649297ab0295831bb3963b186b262d8ff4bfdf9cfef0 1699486 29.941283333333335 -90.07913883333333 1 0 0 0 0 0 0 0 New Orleans LA United States 7E07EFBF-1F63-4142-8856-7DCD9F906811 0.361328125 0.75 0.0 0.05801526718694745 0.5045255422592163 -0.0028228759765625 0.0236358642578125 0.002521514892578125 0.009999999776482582 0.42626953125 -0.0970458984375 -0.021026611328125 0.04168701171875 -0.00844573974609375 0.00287628173828125 0.1065673828125 0.0474853515625 0.01049041748046875 0.16552734375 0.0140838623046875 -7.2479248046875e-05 0.0039005279541015625 0.2330322265625 0.47900390625 0.10040283203125 0.71728515625 0.31689453125
212 46BAA089-F20D-40E3-8161-5C0FA28FAA90 2019-09-11T16:31:25+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 6952898f95114d886494ec5e9df99510a745a0d1ef1fef61d7d924234284f687 1910261 29.934663333333333 -90.06162216666667 1 0 0 0 0 0 0 0 New Orleans LA United States 46BAA089-F20D-40E3-8161-5C0FA28FAA90 0.57666015625 0.75 0.0 0.0580211847110559 0.10000000149011612 -0.00044083595275878906 0.00860595703125 0.0017414093017578125 0.14000000059604645 0.34814453125 -0.051177978515625 0.31787109375 0.0015125274658203125 -0.01107025146484375 0.000823974609375 -0.06640625 -0.00482177734375 0.06878662109375 -0.014892578125 0.00110626220703125 -0.015899658203125 0.0032978057861328125 0.0634765625 0.028564453125 -0.33447265625 0.505859375 -0.003997802734375
61 910061FF-8B93-4DF6-8580-F61F3AF655AC 2019-08-24T12:37:43+00:00 
[
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 heic 1cbea14450726bc646e838673ea29b8223c53c5d312f0a111c3be48a4a7e7e5a 1385613 48.860908333333334 2.3425616666666667 1 0 0 0 0 0 0 0 Paris Île-de-France France 910061FF-8B93-4DF6-8580-F61F3AF655AC 0.3134765625 0.75 0.0 0.8213740458129016 0.7066909670829773 -0.0004093647003173828 0.09881591796875 0.002216339111328125 0.009999999776482582 0.8076171875 -0.0236053466796875 0.1300048828125 0.01242828369140625 -0.0027141571044921875 0.011077880859375 0.4990234375 0.466796875 0.0186920166015625 0.310302734375 0.064453125 0.0083770751953125 0.005062103271484375 0.78662109375 0.89404296875 0.48291015625 0.91259765625 0.58984375
233 8B27D87D-8FB6-4251-9E6A-68540AC7532B 2018-12-24T01:08:03+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 heic 72dcc3993cdcaf43104031d23c42c5824186fbaa07b9bc5065422be1062b210d 2738037 45.646233333333335 -122.65947 1 0 0 0 0 0 0 0 Vancouver WA United States 8B27D87D-8FB6-4251-9E6A-68540AC7532B 0.47265625 0.75 0.0 0.05802243066425542 0.10000000149011612 -0.004573822021484375 0.025115966796875 0.0055999755859375 0.009999999776482582 -0.9287109375 -0.0258026123046875 0.014892578125 0.0028228759765625 -0.00453948974609375 -0.0038509368896484375 0.1556396484375 -0.06219482421875 0.01467132568359375 0.0863037109375 -0.021942138671875 -0.0030155181884765625 0.00547027587890625 0.09124755859375 0.0240478515625 0.2088623046875 0.483642578125 0.00794219970703125
419 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C 2018-05-18T20:39:03+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic d4d2ad853a4bbb3b4ffd93c582b6567943b3edbc0daf7400754740b61b09a755 1884793 37.04161116666667 -122.07271666666666 1 0 0 0 0 0 0 0 Felton CA United States 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C 0.385009765625 0.75 0.0 0.05802466925091416 0.10000000149011612 -0.0021572113037109375 -0.0006103515625 0.0034160614013671875 0.009999999776482582 -0.064208984375 -0.09930419921875 0.287109375 0.004180908203125 -0.016845703125 -0.0426025390625 -0.50341796875 -0.06573486328125 0.1298828125 -0.06414794921875 -0.007534027099609375 -0.0122222900390625 0.0013456344604492188 0.01177978515625 0.0101470947265625 -0.53271484375 -0.367919921875 -0.1138916015625

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