This data as json, CSV (advanced)
Suggested facets: longitude
latitude ✖
date | latitude | longitude | sha256 | ext ▼ | popup |
---|---|---|---|---|---|
2016-04-09T20:12:10+00:00 | 37.78550333333333 | -122.43043666666667 | a7e181d3b3705db1b852705de9a92e0449fbb1b98b70e366bab316b554dafd6e | jpeg | { "title": "Taken on 2016-04-09T20:12:10+00:00", "image": "https://photos.simonwillison.net/i/a7e181d3b3705db1b852705de9a92e0449fbb1b98b70e366bab316b554dafd6e.jpeg?w=400", "link": "https://photos.simonwillison.net/i/a7e181d3b3705db1b852705de9a92e0449fbb1b98b70e366bab316b554dafd6e.jpeg?w=1200" } |
2016-04-09T20:12:10+00:00 | 37.78550333333333 | -122.43043666666667 | 75d306a807f0c9b8a89eb726ca2ea4e226812e347ad1b70a0d7806ca2c9111c8 | jpeg | { "title": "Taken on 2016-04-09T20:12:10+00:00", "image": "https://photos.simonwillison.net/i/75d306a807f0c9b8a89eb726ca2ea4e226812e347ad1b70a0d7806ca2c9111c8.jpeg?w=400", "link": "https://photos.simonwillison.net/i/75d306a807f0c9b8a89eb726ca2ea4e226812e347ad1b70a0d7806ca2c9111c8.jpeg?w=1200" } |
2016-04-09T20:10:29+00:00 | 37.78546166666667 | -122.43050333333333 | 8a3115b8c82c630e48b0ac70eb94d8201721937c4697a667916e1632a5063001 | jpeg | { "title": "Taken on 2016-04-09T20:10:29+00:00", "image": "https://photos.simonwillison.net/i/8a3115b8c82c630e48b0ac70eb94d8201721937c4697a667916e1632a5063001.jpeg?w=400", "link": "https://photos.simonwillison.net/i/8a3115b8c82c630e48b0ac70eb94d8201721937c4697a667916e1632a5063001.jpeg?w=1200" } |
2016-04-09T20:10:28+00:00 | 37.78546166666667 | -122.43050333333333 | 7f16bd84f8301f158a2a512549c0f1594ce92b7bfa05d2787e28a9d890b63419 | jpeg | { "title": "Taken on 2016-04-09T20:10:28+00:00", "image": "https://photos.simonwillison.net/i/7f16bd84f8301f158a2a512549c0f1594ce92b7bfa05d2787e28a9d890b63419.jpeg?w=400", "link": "https://photos.simonwillison.net/i/7f16bd84f8301f158a2a512549c0f1594ce92b7bfa05d2787e28a9d890b63419.jpeg?w=1200" } |
JSON shape: default, array, newline-delimited
CREATE VIEW photos_on_a_map AS select date, latitude, longitude, apple_photos.sha256, uploads.ext, json_object( 'title', 'Taken on ' || date, 'image', 'https://photos.simonwillison.net/i/' || uploads.sha256 || '.' || uploads.ext || '?w=400', 'link', 'https://photos.simonwillison.net/i/' || uploads.sha256 || '.' || uploads.ext || '?w=1200' ) as popup from apple_photos join uploads on apple_photos.sha256 = uploads.sha256 where latitude is not null order by date desc;