photos_with_apple_metadata (view)

12 rows where albums = "["Photography homework composition April 2020", "Public"]" sorted by ZWELLFRAMEDSUBJECTSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

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

ext ✖

albums ✖

  • ["Photography homework composition April 2020", "Public"] · 12 ✖
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
207 52E83D4D-36AA-465B-818C-307DE872BF95 2020-04-23T19:25:14+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 679f4717f5d0fd9be0f0f39be3a1387b1ad828b30405f5a6f9acb3ffdc046911 8312828     1 0 0 0 0 0 0 0       52E83D4D-36AA-465B-818C-307DE872BF95 0.42724609375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.053192138671875 0.00365447998046875 0.0082855224609375 0.009999999776482582 -0.53271484375 -0.049407958984375 -0.058380126953125 0.0460205078125 -0.1201171875 -0.037750244140625 -0.2880859375 -0.47265625 0.017913818359375 -0.052459716796875 0.001800537109375 -0.016693115234375 0.0013885498046875 0.003780364990234375 -0.1241455078125 0.0040130615234375 -0.17236328125 -0.018096923828125
70 C0A58C86-B004-4413-855B-12A697F129D6 2020-04-23T19:19:34+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 1fb3b73785ed9eb8ed706f9a7714d46c5508fcc0cf36c8212c9f88dd07d8640c 5960171     1 0 0 0 0 0 0 0       C0A58C86-B004-4413-855B-12A697F129D6 0.384521484375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.1927490234375 -0.00449371337890625 0.00555419921875 0.009999999776482582 -0.49853515625 -0.0809326171875 -0.1781005859375 0.060638427734375 -0.2347412109375 -0.032470703125 -0.41845703125 -0.6962890625 0.01267242431640625 -0.06781005859375 -0.0036258697509765625 -0.01239776611328125 0.0015974044799804688 0.00313568115234375 -0.78173828125 -0.075439453125 -0.02978515625 -0.1043701171875
254 8B61EC59-ABEC-4C3A-BCB4-2F11D02CD3A0 2020-04-23T19:57:00+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 7c22edd556267a6ee4b7016590064b1575aaaeb430dcfa674acfa5934eae85d9 8164899     1 0 0 0 0 0 0 0       8B61EC59-ABEC-4C3A-BCB4-2F11D02CD3A0 0.443115234375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0014781951904296875 0.018951416015625 0.0059814453125 0.019999999552965164 -0.01611328125 -0.056549072265625 0.10302734375 0.011199951171875 -0.01525115966796875 -0.0132904052734375 -0.09503173828125 -0.0242919921875 0.06646728515625 0.053741455078125 0.005584716796875 -0.01021575927734375 0.00646209716796875 0.037689208984375 0.017913818359375 -0.04901123046875 0.292236328125 0.03363037109375
285 3BBBA8C5-62F9-4BFE-9DB6-CC38EAF11461 2020-04-23T23:18:02+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 888f348b246e038ce7f950f3e5aca8169910d6bf144219c1e0dc80cd8117a2dd 8485248     1 0 0 0 0 0 0 0       3BBBA8C5-62F9-4BFE-9DB6-CC38EAF11461 0.47900390625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.004718780517578125 0.0163421630859375 0.00473785400390625 0.009999999776482582 -0.95166015625 -0.0276336669921875 0.07867431640625 0.0016422271728515625 -0.00577545166015625 -0.00798797607421875 -0.0096435546875 -0.08978271484375 0.01934814453125 0.0404052734375 -0.0308837890625 -0.005924224853515625 0.0034027099609375 0.050994873046875 -0.00604248046875 0.1451416015625 0.304443359375 0.001800537109375
375 91CFD354-BAD6-4367-9146-B5E214F7AED7 2020-04-23T23:21:22+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg b8a2541f7d0a3a7ba42e82810ff7409a0c4bb2e62d1ed0350f35ce2d47f6eaba 8662294     1 0 0 0 0 0 0 0       91CFD354-BAD6-4367-9146-B5E214F7AED7 0.2109375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.001674652099609375 0.0701904296875 0.00586700439453125 0.009999999776482582 -0.2425537109375 -0.05291748046875 0.0955810546875 0.009674072265625 -0.0018825531005859375 0.002086639404296875 0.17578125 0.209716796875 0.07366943359375 0.24951171875 0.01739501953125 0.0 0.006717681884765625 0.33154296875 0.740234375 0.060089111328125 0.349853515625 0.033599853515625
314 0C9E4525-4A55-463C-ADC3-6A3A56113ABD 2020-04-23T19:17:34+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 9971057ac89f7bdaf9c714d5391e7b2abab2c6cc92640f7806088a593c713f80 6475710     1 0 0 0 0 0 0 0       0C9E4525-4A55-463C-ADC3-6A3A56113ABD 0.448974609375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0018463134765625 0.01727294921875 0.0021152496337890625 0.009999999776482582 -0.411376953125 -0.053497314453125 0.1123046875 0.0083770751953125 -0.0191650390625 -0.01861572265625 -0.139404296875 -0.0224609375 0.0299835205078125 0.05865478515625 0.0028533935546875 -0.0088653564453125 0.00254058837890625 0.09808349609375 0.055267333984375 0.04888916015625 0.394287109375 0.007568359375
357 8E150DC5-5E6A-4286-9110-44501EC99304 2020-04-23T23:20:00+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg ada4f24e3ed43ef25da0ae2be782edc1bd9330d15661a67614cbafccb3277d63 7711907     1 0 0 0 0 0 0 0       8E150DC5-5E6A-4286-9110-44501EC99304 0.50390625 0.75 0.0 0.05801526718694745 0.7075425386428833 -0.0005192756652832031 0.07769775390625 0.006824493408203125 0.009999999776482582 0.3955078125 -0.041839599609375 0.260009765625 0.0034694671630859375 -0.004791259765625 0.0063018798828125 0.1600341796875 0.209716796875 0.025177001953125 0.13916015625 0.0210418701171875 0.00106048583984375 0.003376007080078125 0.11297607421875 0.06793212890625 0.1895751953125 0.517578125 0.210205078125
467 DD2793EA-51C4-4196-AB34-12A665ACFF43 2020-04-23T23:25:49+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg eb9a25b29f51de5866383837f752a823eb39fcd7c6948af08970efbec9a117ee 9031772     1 0 0 0 0 0 0 0       DD2793EA-51C4-4196-AB34-12A665ACFF43 0.3916015625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0023975372314453125 0.040679931640625 0.004055023193359375 0.009999999776482582 0.01025390625 -0.07598876953125 0.065185546875 0.011688232421875 -0.004924774169921875 0.00323486328125 0.0611572265625 0.137451171875 0.0294189453125 0.222900390625 0.011871337890625 -0.0007877349853515625 0.00392913818359375 0.2490234375 0.5400390625 0.0853271484375 0.525390625 0.1787109375
436 920D2FF3-BB4B-458A-B4B7-42D961777959 2020-04-23T23:23:27+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg dcdeb1800b9dff39a7b9b898cf72194e497608be08a212ea5eb0c707c2111dc8 7961248     1 0 0 0 0 0 0 0       920D2FF3-BB4B-458A-B4B7-42D961777959 0.5087890625 0.75 0.0 0.05801526718694745 0.5029926896095276 -0.0018033981323242188 0.038604736328125 0.0033512115478515625 0.009999999776482582 0.19921875 -0.0640869140625 0.0626220703125 0.01214599609375 -0.005218505859375 0.00536346435546875 0.1387939453125 0.170166015625 0.028594970703125 0.214599609375 0.01074981689453125 0.00038909912109375 0.004085540771484375 0.28076171875 0.568359375 0.0885009765625 0.5859375 0.28515625
13 8FB56C6C-6557-43E8-AC87-EF6E54F7F346 2020-04-23T23:28:23+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 0762b5e844628b9e0b2a663a651df274d556c4f22705447e13546406cd779215 8341604     1 0 0 0 0 0 0 0       8FB56C6C-6557-43E8-AC87-EF6E54F7F346 0.378662109375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0014324188232421875 0.005527496337890625 0.0009217262268066406 0.009999999776482582 -0.455322265625 -0.1181640625 0.0677490234375 0.0192413330078125 -0.00981903076171875 -0.0017242431640625 -0.345703125 -0.0826416015625 0.0384521484375 0.024566650390625 -0.005931854248046875 -0.02398681640625 0.004024505615234375 0.2054443359375 0.29541015625 -0.298828125 0.59765625 -0.00146484375
444 0CEC9F87-56B8-4E82-885D-CE573A5A6733 2020-04-23T19:26:40+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg e19325bdaa3af04606d769494a62518ac08b5978677831eae415b73e4d05ae0a 8097615     1 0 0 0 0 0 0 0       0CEC9F87-56B8-4E82-885D-CE573A5A6733 0.2744140625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00217437744140625 0.031585693359375 0.001789093017578125 0.019999999552965164 0.165283203125 -0.072265625 0.1336669921875 0.00885009765625 -0.01142120361328125 0.0089263916015625 0.01983642578125 0.08697509765625 0.036346435546875 0.1024169921875 -0.00299072265625 -0.00263214111328125 0.001964569091796875 0.2469482421875 0.583984375 0.1607666015625 0.599609375 0.2371826171875
199 AC1D606E-185E-4B60-8213-782BE58B9DCE 2020-04-23T23:29:15+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 6416af8c3fbce9295cc68411b2710c23ed8736a4ff4e23dd59627b960839241d 8772563     1 0 0 0 0 0 0 0       AC1D606E-185E-4B60-8213-782BE58B9DCE 0.4287109375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0013885498046875 0.024078369140625 0.0015668869018554688 0.009999999776482582 -0.280517578125 -0.0966796875 0.0313720703125 0.01837158203125 -0.006389617919921875 0.0133056640625 -0.011474609375 0.121826171875 0.034027099609375 0.306640625 0.01020050048828125 -0.005748748779296875 0.0057525634765625 0.456298828125 0.650390625 0.0997314453125 0.7548828125 0.040557861328125

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