photos_with_apple_metadata (view)

17 rows where albums = "["Museums", "Public"]" and ext = "jpeg"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: persons, latitude, longitude, hdr, place_city, ZOVERALLAESTHETICSCORE, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZIMMERSIVENESSSCORE, ZINTERACTIONSCORE, date (date), albums (array), persons (array)

ext ✖

  • jpeg · 17 ✖

albums ✖

  • ["Museums", "Public"] · 17 ✖
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
62 ADE494D7-0048-491A-B410-D04C5C58B0DD 2017-07-23T22:20:34+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 1cfb72be21bffca1c026c49845045769dc2791f7844d85d14e74257325d83b23 1988831 37.84245 -122.27783333333333 0 0 0 0 0 0 0 0 Oakland CA United States ADE494D7-0048-491A-B410-D04C5C58B0DD 0.501953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0014553070068359375 0.0223541259765625 0.0022430419921875 0.019999999552965164 -0.1689453125 -0.0207672119140625 0.274169921875 0.0016107559204101562 -0.023284912109375 -0.021148681640625 0.013336181640625 -0.008758544921875 0.0755615234375 0.031982421875 0.0097198486328125 -0.0099945068359375 0.0033512115478515625 0.11163330078125 0.041748046875 0.31640625 0.488037109375 -0.00374603271484375
470 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 2017-07-23T22:13:38+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 jpeg edcd504a5dc67013013c8de46adbc2f586d9d56e572d634d594390fd81b20a95 2233683 37.84250333333333 -122.27778666666667 0 0 0 0 0 0 0 0 Oakland CA United States 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 0.405517578125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0017681121826171875 -0.00296783447265625 0.0022258758544921875 0.009999999776482582 -0.478271484375 -0.06671142578125 0.252685546875 0.0009074211120605469 -0.0202178955078125 -0.118896484375 -0.44580078125 -0.0966796875 0.0823974609375 -0.167724609375 -0.0023097991943359375 -0.034423828125 0.0016355514526367188 0.01061248779296875 -0.007694244384765625 -0.294677734375 -0.1962890625 -0.0555419921875
303 97F0AC20-F45C-40F3-BA5F-66210B77A487 2017-07-23T22:11:35+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 91cd63d05fe337816cae4ca57e9882ccdc5d6f8b921236e703a55e50f116d08d 2629022 37.8424 -122.27777166666667 0 0 0 0 0 0 0 0 Oakland CA United States 97F0AC20-F45C-40F3-BA5F-66210B77A487 0.297119140625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0029354095458984375 0.0163421630859375 0.007232666015625 0.009999999776482582 -0.96923828125 -0.013427734375 0.134765625 0.0004189014434814453 -0.00426483154296875 -0.003582000732421875 0.0882568359375 0.003173828125 0.0131683349609375 0.037261962890625 -0.044189453125 -0.003276824951171875 0.0025806427001953125 0.063720703125 0.0175018310546875 0.2188720703125 0.2841796875 0.0013952255249023438
56 82A5EDE6-0455-46D5-82C4-0FF4E355D8FC 2017-07-23T22:07:25+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 1b68d008a6d555d3a21f96a9ea31e9c1c6513395b93d3349061a5cc8825080b1 2341575 37.842288333333336 -122.27801333333333 0 0 0 0 0 0 0 0 Oakland CA United States 82A5EDE6-0455-46D5-82C4-0FF4E355D8FC 0.35009765625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00399017333984375 0.00577545166015625 0.004100799560546875 0.009999999776482582 -0.92431640625 -0.02276611328125 0.242431640625 0.0013723373413085938 -0.0115509033203125 -0.0203857421875 -0.1290283203125 -0.090576171875 0.090087890625 -0.0042724609375 -0.0312347412109375 -0.01210784912109375 0.0033893585205078125 0.022796630859375 -0.008026123046875 0.05572509765625 0.0567626953125 -0.005092620849609375
188 F19B5D7D-EFD0-4BE6-B335-CBE309FABB41 2017-06-16T01:28:19+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 5dd80ab326459d68c5d9acc8f7094aa4761b9f98ff7f774a3c8b1c25cbf49f83 4286630 37.772616666666664 -122.45991333333333 0 0 0 0 0 0 0 0 San Francisco CA United States F19B5D7D-EFD0-4BE6-B335-CBE309FABB41 0.453857421875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0008759498596191406 0.00547027587890625 0.004665374755859375 0.009999999776482582 0.0380859375 -0.0469970703125 0.416259765625 0.0010776519775390625 -0.01242828369140625 -0.03662109375 -0.201904296875 -0.02239990234375 0.16748046875 -0.04937744140625 -0.00043487548828125 -0.0169219970703125 0.0029354095458984375 0.0142822265625 0.00278472900390625 -0.38525390625 -0.0262451171875 -0.069580078125
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
264 B3EDB403-A948-4ABA-BFE4-2C504A636F7A 2016-01-13T20:43:53+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 7fa46682650e464a6bd09bee294607900c198152b680393dc4f3f5666c0db695 2302070 37.78062833333333 -122.41036166666666 0 0 0 0 0 0 0 0 San Francisco CA United States B3EDB403-A948-4ABA-BFE4-2C504A636F7A 0.365478515625 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.0060272216796875 0.0101470947265625 0.0297088623046875 0.009999999776482582 -0.211669921875 -0.046722412109375 -0.1920166015625 0.11181640625 -0.053192138671875 -0.039581298828125 -0.1484375 -0.43408203125 0.22802734375 0.0792236328125 0.00518035888671875 -0.0051727294921875 0.043853759765625 0.004085540771484375 -0.05242919921875 -0.0291748046875 -0.06365966796875 0.00762176513671875
211 E4D43462-07AB-4803-9DCB-02B8321D8D94 2016-01-13T20:30:46+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 692e3b73c2d9297f354c7b9827d05cd697fd4b83885747a869b2478ec44632c5 2259762 37.78168 -122.411025 0 0 0 0 0 0 0 0 San Francisco CA United States E4D43462-07AB-4803-9DCB-02B8321D8D94 0.22265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0007615089416503906 0.0242156982421875 0.0022258758544921875 0.009999999776482582 -0.11474609375 -0.08343505859375 0.0714111328125 0.0144500732421875 -0.01009368896484375 -0.0028076171875 -0.100341796875 0.0386962890625 0.07476806640625 0.2037353515625 0.00543975830078125 -0.00792694091796875 0.008575439453125 0.1524658203125 0.10986328125 -0.04443359375 0.56005859375 0.039520263671875

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