photos_with_apple_metadata (view)

13 rows where panorama = 0, place_country = "Mexico" and screenshot = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, 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
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
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
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
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
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
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
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
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
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
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
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
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

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