photos_with_apple_metadata (view)

8 rows where albums = "["To Instagram", "Public"]" sorted by ZOVERALLAESTHETICSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ext, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, date (date), albums (array)

albums ✖

  • ["To Instagram", "Public"] · 8 ✖
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
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
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
313 4353C1BC-259D-4814-B113-8E5DBA65470D 2019-08-02T07:31:01+00:00 
[
    "To Instagram",
    "Public"
]
 
[]
 jpeg 97c5b33f1ede95e3610b213858a47deb2d9b6e84edbc484348eb318234b1725e 6764077     1 0 0 0 0 0 0 0       4353C1BC-259D-4814-B113-8E5DBA65470D 0.65869140625 0.75 0.0 0.061090990332246735 0.5033819675445557 -0.0008330345153808594 0.05767822265625 0.001918792724609375 0.009999999776482582 0.077880859375 -0.054107666015625 0.08892822265625 0.02947998046875 -0.005535125732421875 0.0120697021484375 0.1839599609375 0.213623046875 0.035888671875 0.275146484375 0.02435302734375 -0.001705169677734375 0.006824493408203125 0.44580078125 0.517578125 0.144287109375 0.7705078125 0.065185546875
300 563D4862-8FC2-4BD9-BAD0-E9B2DC5DB473 2019-08-02T07:32:43+00:00 
[
    "To Instagram",
    "Public"
]
 
[]
 jpeg 8fa3f67420480063a09ea4134c1dae4e8d67262f38433e3a41a2f6eb6aa47bf8 5402536     1 0 0 0 0 0 0 0       563D4862-8FC2-4BD9-BAD0-E9B2DC5DB473 0.68701171875 0.75 0.0 0.061090618599462146 0.10000000149011612 -0.0045928955078125 0.059783935546875 0.024139404296875 0.009999999776482582 -0.1326904296875 -0.041778564453125 0.0091552734375 0.01763916015625 -0.00948333740234375 -0.0116119384765625 0.140625 0.001708984375 0.047698974609375 0.205810546875 0.0234832763671875 0.00275421142578125 0.007122039794921875 0.03289794921875 0.05401611328125 0.03717041015625 0.03765869140625 0.039886474609375
369 FCBB3E33-8FF9-4811-B242-729555B01F28 2019-08-12T08:14:34+00:00 
[
    "To Instagram",
    "Public"
]
 
[]
 jpeg b59011c12dd96d5570d71fead8b84f1efa589beca989bdbad3f7ad36f6522c3a 5240506     1 0 0 0 0 0 0 0       FCBB3E33-8FF9-4811-B242-729555B01F28 0.71533203125 0.75 0.0 0.06263535213834456 0.7032116651535034 -0.000820159912109375 0.07196044921875 0.00243377685546875 0.009999999776482582 0.44921875 -0.03424072265625 0.103515625 0.01433563232421875 -0.003147125244140625 0.0105743408203125 0.374267578125 0.366455078125 0.026702880859375 0.30810546875 0.033294677734375 0.0036144256591796875 0.005100250244140625 0.6748046875 0.857421875 0.2802734375 0.82861328125 0.325439453125
243 18939B2A-0A75-461C-B1D0-7ABD87282C2D 2019-08-02T07:06:42+00:00 
[
    "To Instagram",
    "Public"
]
 
[]
 jpeg 77bff818519fbcb9928b5259e5865f7f16a90fca872e7372a6bb06be7ac89fd9 4601240     1 0 0 0 0 0 0 0       18939B2A-0A75-461C-B1D0-7ABD87282C2D 0.73486328125 0.75 0.0 0.06263108016880414 0.10000000149011612 -0.00131988525390625 0.0268707275390625 0.0013151168823242188 0.009999999776482582 -0.0050048828125 -0.04803466796875 0.258544921875 0.005138397216796875 -0.014617919921875 0.016845703125 -0.0245361328125 0.05230712890625 0.06939697265625 0.068603515625 0.00927734375 -0.009765625 0.002590179443359375 0.316650390625 0.431640625 0.0804443359375 0.6259765625 0.010986328125
74 3295CB6A-D459-45C2-8E45-9FBBDCF80266 2019-08-20T05:56:46+00:00 
[
    "To Instagram",
    "Public"
]
 
[]
 jpeg 21f932155ee348af51628849af6626b7a6f5ffafd5eda45b6196ada242ae647b 6094145     1 0 0 0 0 0 0 0       3295CB6A-D459-45C2-8E45-9FBBDCF80266 0.751953125 0.75 0.0 0.06263145190158872 0.5050121545791626 -0.0012111663818359375 0.043670654296875 0.00313568115234375 0.019999999552965164 0.640625 -0.046539306640625 0.0594482421875 0.0136871337890625 -0.0062408447265625 0.00662994384765625 0.28125 0.18310546875 0.03436279296875 0.207763671875 0.017669677734375 0.0028400421142578125 0.006145477294921875 0.2890625 0.537109375 0.179443359375 0.728515625 0.51416015625
266 EB0F670F-3DE5-4917-840A-1C84BE9C570D 2019-07-30T12:22:03+00:00 
[
    "To Instagram",
    "Public"
]
 
[]
 jpeg 80c39df47ef66d49231ae15a6a0dcd036881b7310ebc344e9b8677da479ee070 5096405     1 0 0 0 0 0 0 0       EB0F670F-3DE5-4917-840A-1C84BE9C570D 0.75927734375 0.75 0.0 0.06262309405639882 0.10000000149011612 -0.0026721954345703125 0.040374755859375 0.0038242340087890625 0.009999999776482582 -0.53515625 -0.0248870849609375 0.30224609375 0.00426483154296875 -0.0120086669921875 -0.01177978515625 -0.03497314453125 0.03985595703125 0.091064453125 0.054443359375 0.0120697021484375 -0.018310546875 0.0028781890869140625 0.12890625 0.1641845703125 0.1927490234375 0.2381591796875 -0.004730224609375

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