photos_with_apple_metadata (view)

13 rows where albums contains "Geotaggable Photos geotagged" sorted by ZWELLTIMEDSHOTSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, date (date)

albums (array) ✖

  • Geotaggable Photos geotagged · 13 ✖
  • Public 13

screenshot ✖

  • 0 13
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 ▼
269 7705FF4E-2F25-45B9-B795-EA58244F3273 2018-02-13T18:53:28+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg 81f94d4de59b28e89df4ff8ac3a7250e624cbd261e7d93701e6a8cafeeeb971e 5483241 25.737587971741938 -111.09106443298224 0 0 0 0 0 0 0 0     Mexico 7705FF4E-2F25-45B9-B795-EA58244F3273 0.708984375 0.5 0.0 0.043553611249414106 0.10000000149011612 -0.06915283203125 -0.00589752197265625 0.00208282470703125 0.019999999552965164 -0.390869140625 -0.14306640625 -0.1083984375 0.0775146484375 -0.12322998046875 -0.06463623046875 -0.58837890625 -0.66650390625 0.024566650390625 -0.1026611328125 -0.0028285980224609375 -0.06109619140625 0.0018100738525390625 0.00464630126953125 -0.52734375 -0.286376953125 -0.095458984375 -0.10565185546875
209 232FAC16-A5A7-4CF0-9E01-2B6DAE88795D 2018-02-13T18:49:54+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg 6849da4d977ea226af6a5b5a42a58ab0fc73cf7bfc35a1e908e74bf75164802a 5283780 25.740267905197804 -111.09597236338337 0 0 0 0 0 0 0 0     Mexico 232FAC16-A5A7-4CF0-9E01-2B6DAE88795D 0.54345703125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0011339187622070312 -0.002838134765625 0.0015010833740234375 0.009999999776482582 0.001220703125 -0.050140380859375 0.372802734375 0.0007886886596679688 -0.025665283203125 -0.055389404296875 -0.199951171875 -0.07366943359375 0.1143798828125 -0.1328125 -0.0012760162353515625 -0.0303955078125 0.0018672943115234375 0.018646240234375 0.00119781494140625 -0.470947265625 0.1363525390625 -0.092041015625
400 2B30643F-7BEC-4E40-8C9F-BF0994C38197 2018-02-13T18:55:11+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg c737f0db8b99bd2bff7581902d55319005ce8f7557654af7d985e66e91bfdb85 5545619 25.73648106575451 -111.09070456885036 0 0 0 0 0 0 0 0     Mexico 2B30643F-7BEC-4E40-8C9F-BF0994C38197 0.5947265625 0.5 0.0 0.042004234918201246 0.10000000149011612 -0.0022602081298828125 -0.00171661376953125 0.00908660888671875 0.009999999776482582 -0.2548828125 -0.059112548828125 0.2274169921875 0.0010442733764648438 -0.01751708984375 -0.12164306640625 -0.4638671875 -0.110595703125 0.2010498046875 -0.132080078125 0.0008869171142578125 -0.0180816650390625 0.00266265869140625 0.002521514892578125 -0.0098876953125 -0.1746826171875 -0.50390625 -0.057098388671875
115 0CE448B6-E909-49F0-B97C-1F2408D08970 2018-02-13T18:53:30+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg 38ac35357f78510ec06848a345c246078c7b34b6c8e5d7e948abd47972191bee 4216224 25.737556161627715 -111.0910540912556 0 0 0 0 0 0 0 0     Mexico 0CE448B6-E909-49F0-B97C-1F2408D08970 0.75390625 0.5 0.0 0.04355379734330505 0.10000000149011612 -0.001964569091796875 0.007537841796875 0.0024929046630859375 0.009999999776482582 -0.51953125 -0.08526611328125 0.1845703125 0.0068511962890625 -0.015777587890625 -0.04339599609375 -0.45849609375 -0.04498291015625 0.060211181640625 -0.04827880859375 -0.00525665283203125 -0.01410675048828125 0.0017681121826171875 0.0394287109375 0.03216552734375 -0.214599609375 -0.0538330078125 -0.0259857177734375
358 3E327FD2-CC19-4BF0-9D1B-9833A3D2F6B4 2018-02-13T18:53:52+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg adc26d4f5ae813f2a5a6281653f515dc245ff351973f99c342bb23015a175d48 5176004 25.737328762300947 -111.09098016188648 0 0 0 0 0 0 0 0     Mexico 3E327FD2-CC19-4BF0-9D1B-9833A3D2F6B4 0.78125 0.5 0.0 0.04353485262120953 0.10000000149011612 -0.0012254714965820312 0.042755126953125 0.00279998779296875 0.019999999552965164 -0.191650390625 -0.05987548828125 0.419189453125 0.00734710693359375 -0.013427734375 -0.05120849609375 -0.2137451171875 0.0130615234375 0.5712890625 0.00146484375 0.0055694580078125 -0.016815185546875 0.0070953369140625 0.0709228515625 0.15087890625 -0.163330078125 0.04150390625 -0.0222625732421875
279 A8949702-A151-4ACD-8F3C-D5957F481E5A 2018-02-13T18:55:13+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg 85d802ffe4def2a666fed10fe1da638ef804d8e499a8899c23471705df60163c 5342238 25.736453769238338 -111.09069569453112 0 0 0 0 0 0 0 0     Mexico A8949702-A151-4ACD-8F3C-D5957F481E5A 0.72412109375 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0010480880737304688 0.025848388671875 0.0018033981323242188 0.009999999776482582 -0.166748046875 -0.020172119140625 0.36181640625 0.0021991729736328125 -0.016845703125 0.00335693359375 0.013946533203125 0.0294189453125 0.1356201171875 0.03472900390625 0.0109405517578125 -0.019073486328125 0.00391387939453125 0.1959228515625 0.1380615234375 0.236572265625 0.525390625 -0.006011962890625
386 B0B115AB-2687-46D9-96F5-AC20AFCC2DE3 2018-02-13T18:53:29+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg c13ac4447cee546dd7fa9849cff176203e61e63473dcf4244f305cefd49f1e1a 5277926 25.737572066684827 -111.09105926211892 0 0 0 0 0 0 0 0     Mexico B0B115AB-2687-46D9-96F5-AC20AFCC2DE3 0.69580078125 0.5 0.0 0.0420047918348822 0.10000000149011612 -0.003124237060546875 0.015869140625 0.0058441162109375 0.009999999776482582 -0.9169921875 -0.035736083984375 0.1015625 0.0050811767578125 -0.0092315673828125 -0.016448974609375 -0.2066650390625 -0.03790283203125 0.03704833984375 0.0347900390625 -0.017333984375 -0.008209228515625 0.0029354095458984375 0.032958984375 0.0123291015625 0.0260772705078125 -0.0037841796875 -0.00052642822265625
89 12BFF8C2-D12C-48D7-B752-EFA7AB1B30AF 2018-02-13T18:53:29+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg 269b74a5ba4d63efb5f540a0400269a41b28cc9faf16f199e9cfa0da95c29846 5296111 25.737576472815096 -111.09106069458767 0 0 0 0 0 0 0 0     Mexico 12BFF8C2-D12C-48D7-B752-EFA7AB1B30AF 0.72119140625 0.5 0.0 0.043530952384453696 0.10000000149011612 -0.0031108856201171875 0.00571441650390625 0.004055023193359375 0.009999999776482582 -0.904296875 -0.02532958984375 0.07891845703125 0.0011157989501953125 -0.0118255615234375 -0.006046295166015625 -0.01544189453125 -0.06072998046875 0.01358795166015625 0.019683837890625 -0.0296630859375 -0.007640838623046875 0.002471923828125 0.058441162109375 0.0153961181640625 0.1890869140625 0.40625 0.000896453857421875
182 A945D44B-B701-4FD6-B264-0D4F5683EA2A 2018-02-13T18:50:16+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg 5a4551e5ca2f11c04091506d7454fdea1fd75ec3a783b301a61ad8497dacf2b9 5964575 25.739937867807853 -111.09487104411251 0 0 0 0 0 0 0 0     Mexico A945D44B-B701-4FD6-B264-0D4F5683EA2A 0.67919921875 0.5 0.0 0.04200776342217249 0.10000000149011612 -0.0014438629150390625 0.00983428955078125 0.00391387939453125 0.009999999776482582 -0.029541015625 -0.07275390625 0.218505859375 0.0018968582153320312 -0.01560211181640625 -0.080078125 -0.311279296875 -0.05316162109375 0.06256103515625 -0.064697265625 0.00180816650390625 -0.010772705078125 0.001941680908203125 0.01242828369140625 -0.0088043212890625 -0.174072265625 -0.0482177734375 0.0013427734375
8 DBF7A6F2-B2FF-40F5-9F28-0341ED45C1A6 2018-02-13T18:53:28+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg 040edf81a4877738fba679c0928af0a7c3f55b12c8ff6a934d38c713ababacb0 5763520 25.73758141627914 -111.09106230174801 0 0 0 0 0 0 0 0     Mexico DBF7A6F2-B2FF-40F5-9F28-0341ED45C1A6 0.7177734375 0.5 0.0 0.043530951929456406 0.10000000149011612 -0.0030040740966796875 0.0210113525390625 0.00714874267578125 0.009999999776482582 -0.95703125 -0.019989013671875 0.10723876953125 0.0011968612670898438 -0.00482940673828125 -0.0050811767578125 0.07281494140625 -0.00738525390625 0.0224609375 0.050537109375 -0.05157470703125 -0.0038967132568359375 0.00392913818359375 0.06109619140625 0.0204315185546875 0.1607666015625 0.280029296875 0.0031585693359375
84 D034D20E-18D9-4AD1-9769-370479278F00 2018-02-13T18:53:30+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg 24eeded69d88226a99379f511471520babc37d185ec0f5ab3eea64a665c9e2eb 4634606 25.737564651490043 -111.09105685137882 0 0 0 0 0 0 0 0     Mexico D034D20E-18D9-4AD1-9769-370479278F00 0.73828125 0.5 0.0 0.04355491163166425 0.10000000149011612 -0.0007762908935546875 0.028778076171875 0.005889892578125 0.009999999776482582 -0.0697021484375 -0.10302734375 0.28955078125 0.004451751708984375 -0.004848480224609375 -0.032440185546875 -0.448486328125 0.0633544921875 0.0836181640625 0.00860595703125 -0.00177764892578125 -0.006500244140625 0.0023326873779296875 0.0192718505859375 0.0137786865234375 -0.27978515625 -0.2005615234375 0.02301025390625
329 D2E8BA79-361D-4888-BCE6-80E7DEE2D5D8 2018-02-13T18:53:48+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg a02327731c68afc82e3f442932167fd2a273ea95c0fa968b0199a73141dd99f4 5960871 25.737367127877967 -111.09099263484735 0 0 0 0 0 0 0 0     Mexico D2E8BA79-361D-4888-BCE6-80E7DEE2D5D8 0.76025390625 0.5 0.0 0.04353076629056275 0.10111922025680542 -0.00070953369140625 0.08514404296875 0.003692626953125 0.05999999865889549 0.16162109375 -0.01812744140625 0.403076171875 0.00274658203125 -0.0069580078125 0.005615234375 0.1458740234375 0.09783935546875 0.054290771484375 0.1104736328125 0.02960205078125 -0.00168609619140625 0.00441741943359375 0.157958984375 0.078125 0.41064453125 0.6162109375 0.0361328125
270 801ECB04-F7C1-4D36-8B07-6B52B80E74A0 2018-02-13T18:53:51+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg 822075bc99101363c0c066542717adc5187c66b924e4a7e353e33f8e186614e6 4974082 25.73733306096472 -111.090981559417 0 0 0 0 0 0 0 0     Mexico 801ECB04-F7C1-4D36-8B07-6B52B80E74A0 0.8330078125 0.75 0.0 0.06261723005134641 0.7075669169425964 -0.0026416778564453125 0.0203857421875 0.0023136138916015625 0.03999999910593033 0.49658203125 -0.09173583984375 -0.0142822265625 0.024993896484375 -0.0110321044921875 0.0013427734375 0.094482421875 0.013671875 0.0121002197265625 0.1624755859375 0.007904052734375 0.0004119873046875 0.0034427642822265625 0.149169921875 0.28857421875 0.085205078125 0.65380859375 0.52685546875

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