photos_with_apple_metadata (view)

10 rows where panorama = 0, place_city = "Sausalito" and place_country = "United States"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: persons, latitude, longitude, hdr, ZHIGHLIGHTVISIBILITYSCORE, 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
191 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 2016-11-05T21:21:05+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 5f9968989d0aad8a9dd9c6aabd5e495444a44a8714a1fa3296a96132b67de178 2555246 37.82716333333333 -122.52745833333333 0 0 0 0 0 0 0 0 Sausalito CA United States 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 0.50244140625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0023326873779296875 0.005535125732421875 0.004665374755859375 0.019999999552965164 -0.384033203125 -0.036773681640625 0.181396484375 0.0038852691650390625 -0.02947998046875 -0.0823974609375 -0.1904296875 -0.1136474609375 0.1702880859375 -0.056884765625 0.001659393310546875 -0.056396484375 0.006587982177734375 0.01467132568359375 -0.00415802001953125 -0.0748291015625 0.009765625 -0.01593017578125
432 69C46054-1D8F-4FD6-ABC7-2369C79921F4 2016-11-05T20:55:46+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 jpeg d966b699790953594f2be6cc03c5e5b3d478ebf27122037a7dc022db7642411e 2299000 37.828136666666666 -122.52736666666667 0 0 0 0 0 0 0 0 Sausalito CA United States 69C46054-1D8F-4FD6-ABC7-2369C79921F4 0.4814453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0009508132934570312 0.047760009765625 0.05499267578125 0.009999999776482582 -0.06640625 -0.043701171875 0.10211181640625 0.0026111602783203125 -0.004505157470703125 -0.045806884765625 0.0196533203125 0.0323486328125 0.05194091796875 0.1417236328125 0.0133056640625 0.00213623046875 0.00971221923828125 0.00661468505859375 -0.0017147064208984375 -0.00029754638671875 -0.0811767578125 0.0098724365234375
302 2DA58E9D-038C-49B2-ABCB-2185E57E8F68 2016-11-05T20:55:42+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 90f7eaebeafeb0eeb14cdc064d541761d82d969c173687df7d0bd3551f1ae240 2520930 37.827938333333336 -122.52742 0 0 0 0 0 0 0 0 Sausalito CA United States 2DA58E9D-038C-49B2-ABCB-2185E57E8F68 0.31591796875 0.5 0.0 0.038931297721298594 0.503017008304596 -0.001956939697265625 0.0648193359375 0.0282745361328125 0.009999999776482582 0.2083740234375 -0.04913330078125 -0.018768310546875 0.05291748046875 -0.01306915283203125 -0.023773193359375 0.1820068359375 0.0557861328125 0.120849609375 0.4013671875 0.07073974609375 0.00934600830078125 0.0231475830078125 0.0257568359375 0.020965576171875 0.044036865234375 0.0660400390625 0.041961669921875
206 07509762-A841-4CEB-AA42-B65439E9C3DD 2016-11-05T20:50:06+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 679f1f8f0d139dba297bf0d5ecadcaed7259d6c812e6a825e2d3999cc301d5b3 3572478 37.82793 -122.52746666666667 0 0 0 0 0 0 0 0 Sausalito CA United States 07509762-A841-4CEB-AA42-B65439E9C3DD 0.6259765625 0.5 0.0 0.8053737856049574 0.10000000149011612 -0.0006985664367675781 0.037078857421875 0.00669097900390625 0.009999999776482582 0.080078125 -0.0257110595703125 0.2083740234375 0.0021152496337890625 -0.009674072265625 -0.003387451171875 0.104736328125 0.0789794921875 0.060516357421875 0.1619873046875 0.01324462890625 -0.003513336181640625 0.0063629150390625 0.08209228515625 0.025970458984375 0.15087890625 0.417236328125 0.03619384765625
255 EECDD2BE-E93F-4830-8435-68681476E833 2016-11-05T20:47:12+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 7c8518ac608ee1cec1d652018536ba1e77fd2434536d5016ef825e0990b80bb6 1551766 37.82842 -122.527275 0 0 0 0 0 1 0 0 Sausalito CA United States EECDD2BE-E93F-4830-8435-68681476E833 0.432861328125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0020198822021484375 0.009552001953125 0.00595855712890625 0.009999999776482582 -0.31591796875 -0.06304931640625 0.0941162109375 0.01016998291015625 -0.0251312255859375 -0.0953369140625 -0.33154296875 -0.14111328125 0.1279296875 -0.02105712890625 0.0037994384765625 -0.0222930908203125 0.00626373291015625 0.01073455810546875 -0.00830078125 -0.09222412109375 -0.0933837890625 -0.0088958740234375
304 40CFDB12-709C-4A22-BB3B-C17A6672C1E7 2016-04-19T22:25:45+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 923523f764375c334e0a6e2337ae2d97d43f5d4a351c27e71aa5b531b56c6719 2419091 37.863213333333334 -122.49489666666666 0 0 0 0 0 0 0 0 Sausalito CA United States 40CFDB12-709C-4A22-BB3B-C17A6672C1E7 0.317626953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0020751953125 -0.004993438720703125 0.0036792755126953125 0.009999999776482582 -0.30029296875 -0.0723876953125 0.1903076171875 0.002811431884765625 -0.021209716796875 -0.0906982421875 -0.456787109375 -0.178466796875 0.153076171875 -0.08172607421875 -0.0020656585693359375 -0.053619384765625 0.004100799560546875 0.005161285400390625 -0.0158538818359375 -0.394287109375 -0.25048828125 -0.05572509765625
101 5EEC9ED6-BD95-4B4F-B364-DCCB49144A9B 2016-04-19T22:25:25+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 303e5a7d0a3d1c3f5d5429bafb9ff301b9b5b333714db85a6b4fcd750600a7da 2650748 37.863236666666666 -122.49486666666667 0 0 0 0 0 0 0 0 Sausalito CA United States 5EEC9ED6-BD95-4B4F-B364-DCCB49144A9B 0.328369140625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0005011558532714844 0.004261016845703125 0.002452850341796875 0.009999999776482582 0.1724853515625 -0.08978271484375 0.260986328125 0.0016813278198242188 -0.0083160400390625 -0.033538818359375 -0.302734375 -0.04412841796875 0.09844970703125 -0.038177490234375 6.4849853515625e-05 -0.026275634765625 0.003551483154296875 0.0202484130859375 0.0052032470703125 -0.46142578125 0.1236572265625 -0.02587890625
412 A9A5BE5B-A2FA-4224-A26D-6CE3A1AC02C7 2016-04-19T22:24:58+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg d0645484f8416d699b4c9bb4a33ce66030db5ce8dbaf7a6145e16cbec845369c 2369867 37.863236666666666 -122.49486666666667 0 0 0 0 0 0 0 0 Sausalito CA United States A9A5BE5B-A2FA-4224-A26D-6CE3A1AC02C7 0.31884765625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0002613067626953125 0.040557861328125 0.02203369140625 0.009999999776482582 -0.0977783203125 -0.038238525390625 0.161865234375 0.0029582977294921875 -0.0029354095458984375 -0.005157470703125 0.0755615234375 0.1986083984375 0.126708984375 0.1787109375 0.0121917724609375 -0.003826141357421875 0.021697998046875 0.042083740234375 0.00931549072265625 -0.01641845703125 0.2021484375 0.012298583984375
144 D3AECF29-CF9B-4CA0-8A6D-39D21CFA3D54 2016-04-19T22:24:47+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 44458ddd988ba5866c6a1e5db026a57add085c80d64a6f0f52fffacd816e52ad 2181535 37.86320833333333 -122.49472 0 0 0 0 0 0 0 0 Sausalito CA United States D3AECF29-CF9B-4CA0-8A6D-39D21CFA3D54 0.35009765625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.033966064453125 0.005153656005859375 0.006824493408203125 0.009999999776482582 -0.6083984375 -0.09271240234375 -0.2470703125 0.2117919921875 -0.1104736328125 -0.038299560546875 -0.44970703125 -0.623046875 0.0164642333984375 0.0101318359375 0.0024871826171875 -0.005985260009765625 0.0029582977294921875 0.004398345947265625 -0.1490478515625 -0.0050201416015625 -0.127197265625 0.0197906494140625
395 82B5CEE0-0DCB-4E73-84BC-2536F0676B06 2016-04-19T22:24:36+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg c5da768a066d3ed8487b4cf7520c8960f46510357e13edb68729cd3b0565fcbb 2044936 37.863186666666664 -122.49463666666666 0 0 0 0 0 0 0 0 Sausalito CA United States 82B5CEE0-0DCB-4E73-84BC-2536F0676B06 0.331298828125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0018033981323242188 0.00077056884765625 0.0028667449951171875 0.009999999776482582 -0.32421875 -0.03790283203125 0.44921875 0.0005192756652832031 -0.016845703125 -0.1064453125 -0.2491455078125 -0.05010986328125 0.149169921875 -0.19384765625 0.000110626220703125 -0.04498291015625 0.0019044876098632812 0.0162811279296875 0.00072479248046875 -0.204833984375 -0.1358642578125 -0.047576904296875

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