This data as json, CSV (advanced)
Suggested facets: date (date)
date | latitude ▲ | longitude | sha256 | ext | popup |
---|---|---|---|---|---|
2020-01-25T16:57:07+00:00 | 37.11899167 | -122.307175 | e02df647bbc0ccc62c05a275c54edeb0529fc7032b182ec91a69556b70a7fa8e | heic | { "title": "Taken on 2020-01-25T16:57:07+00:00", "image": "https://photos.simonwillison.net/i/e02df647bbc0ccc62c05a275c54edeb0529fc7032b182ec91a69556b70a7fa8e.heic?w=400", "link": "https://photos.simonwillison.net/i/e02df647bbc0ccc62c05a275c54edeb0529fc7032b182ec91a69556b70a7fa8e.heic?w=1200" } |
2020-01-25T16:58:40+00:00 | 37.118902829999996 | -122.30718833 | 63caca87e01761366f47b8c7e1a68dadb7b10d983c10a7df91e1ec945df987ac | heic | { "title": "Taken on 2020-01-25T16:58:40+00:00", "image": "https://photos.simonwillison.net/i/63caca87e01761366f47b8c7e1a68dadb7b10d983c10a7df91e1ec945df987ac.heic?w=400", "link": "https://photos.simonwillison.net/i/63caca87e01761366f47b8c7e1a68dadb7b10d983c10a7df91e1ec945df987ac.heic?w=1200" } |
2020-01-25T18:37:22+00:00 | 37.11635832999999 | -122.33049667 | 59340b9b577670a6302885117a05ce7103e612748d3de0908dcc7dd3abb232c9 | heic | { "title": "Taken on 2020-01-25T18:37:22+00:00", "image": "https://photos.simonwillison.net/i/59340b9b577670a6302885117a05ce7103e612748d3de0908dcc7dd3abb232c9.heic?w=400", "link": "https://photos.simonwillison.net/i/59340b9b577670a6302885117a05ce7103e612748d3de0908dcc7dd3abb232c9.heic?w=1200" } |
2020-01-25T18:16:15+00:00 | 37.11623049999999 | -122.33001667 | 14620230b833ea022fdbed283eae903ae8e82fe27e943d5fc1fe0f502f6e9e6e | heic | { "title": "Taken on 2020-01-25T18:16:15+00:00", "image": "https://photos.simonwillison.net/i/14620230b833ea022fdbed283eae903ae8e82fe27e943d5fc1fe0f502f6e9e6e.heic?w=400", "link": "https://photos.simonwillison.net/i/14620230b833ea022fdbed283eae903ae8e82fe27e943d5fc1fe0f502f6e9e6e.heic?w=1200" } |
2020-01-25T18:14:27+00:00 | 37.11621117 | -122.32977999999999 | 6b8ef6a1de38c5e897e740c407caa88bbe307b561dac970ccd9b58f870a1f85e | heic | { "title": "Taken on 2020-01-25T18:14:27+00:00", "image": "https://photos.simonwillison.net/i/6b8ef6a1de38c5e897e740c407caa88bbe307b561dac970ccd9b58f870a1f85e.heic?w=400", "link": "https://photos.simonwillison.net/i/6b8ef6a1de38c5e897e740c407caa88bbe307b561dac970ccd9b58f870a1f85e.heic?w=1200" } |
2020-01-25T18:18:00+00:00 | 37.11606667000001 | -122.330475 | 03bd641c31961be01b3f491a7414ccacb2c57dece64fd6fd8e4be6384643ef8e | heic | { "title": "Taken on 2020-01-25T18:18:00+00:00", "image": "https://photos.simonwillison.net/i/03bd641c31961be01b3f491a7414ccacb2c57dece64fd6fd8e4be6384643ef8e.heic?w=400", "link": "https://photos.simonwillison.net/i/03bd641c31961be01b3f491a7414ccacb2c57dece64fd6fd8e4be6384643ef8e.heic?w=1200" } |
2020-01-25T18:11:18+00:00 | 37.115291670000005 | -122.32810333 | 7ad35f068121f446574a8c950f35017b34cbc4e6dd25c72be8a71b9234bb1e7a | heic | { "title": "Taken on 2020-01-25T18:11:18+00:00", "image": "https://photos.simonwillison.net/i/7ad35f068121f446574a8c950f35017b34cbc4e6dd25c72be8a71b9234bb1e7a.heic?w=400", "link": "https://photos.simonwillison.net/i/7ad35f068121f446574a8c950f35017b34cbc4e6dd25c72be8a71b9234bb1e7a.heic?w=1200" } |
2020-01-25T18:10:45+00:00 | 37.11521117 | -122.32787167 | 4a622a5c958ecba31c02dfdeff721c261c59b7d3d08124e50d4add1e85f5e5d4 | heic | { "title": "Taken on 2020-01-25T18:10:45+00:00", "image": "https://photos.simonwillison.net/i/4a622a5c958ecba31c02dfdeff721c261c59b7d3d08124e50d4add1e85f5e5d4.heic?w=400", "link": "https://photos.simonwillison.net/i/4a622a5c958ecba31c02dfdeff721c261c59b7d3d08124e50d4add1e85f5e5d4.heic?w=1200" } |
2020-01-25T18:09:33+00:00 | 37.115119500000006 | -122.32771333000001 | 1307ecb271a8f7357b7151de2cd5cbec2e7232d91a2404daa5a716c0d96b4fc9 | heic | { "title": "Taken on 2020-01-25T18:09:33+00:00", "image": "https://photos.simonwillison.net/i/1307ecb271a8f7357b7151de2cd5cbec2e7232d91a2404daa5a716c0d96b4fc9.heic?w=400", "link": "https://photos.simonwillison.net/i/1307ecb271a8f7357b7151de2cd5cbec2e7232d91a2404daa5a716c0d96b4fc9.heic?w=1200" } |
2020-01-25T17:38:42+00:00 | 37.114983329999994 | -122.32553833000001 | 5f5bcb376b8fea54df152f57917140d8d71ea6528cb2582259967a6614077048 | heic | { "title": "Taken on 2020-01-25T17:38:42+00:00", "image": "https://photos.simonwillison.net/i/5f5bcb376b8fea54df152f57917140d8d71ea6528cb2582259967a6614077048.heic?w=400", "link": "https://photos.simonwillison.net/i/5f5bcb376b8fea54df152f57917140d8d71ea6528cb2582259967a6614077048.heic?w=1200" } |
2020-01-25T19:12:52+00:00 | 37.11494717 | -122.32808 | 9d24f646179a5110b384061d7911acf849957530304e5ac141b86edab4b7b3a0 | heic | { "title": "Taken on 2020-01-25T19:12:52+00:00", "image": "https://photos.simonwillison.net/i/9d24f646179a5110b384061d7911acf849957530304e5ac141b86edab4b7b3a0.heic?w=400", "link": "https://photos.simonwillison.net/i/9d24f646179a5110b384061d7911acf849957530304e5ac141b86edab4b7b3a0.heic?w=1200" } |
2020-01-25T18:07:06+00:00 | 37.1148555 | -122.32795000000002 | 5d27b85ff783a2fa1c9e9533157ffd680c06cb957206054aa25ee5786e49ba84 | heic | { "title": "Taken on 2020-01-25T18:07:06+00:00", "image": "https://photos.simonwillison.net/i/5d27b85ff783a2fa1c9e9533157ffd680c06cb957206054aa25ee5786e49ba84.heic?w=400", "link": "https://photos.simonwillison.net/i/5d27b85ff783a2fa1c9e9533157ffd680c06cb957206054aa25ee5786e49ba84.heic?w=1200" } |
2020-01-25T18:05:50+00:00 | 37.11481117 | -122.32784167 | 8a2c43b2888b0777a9ffa4679f13011b3bd91cd57c4fe34a5b612c1bc4ceb147 | heic | { "title": "Taken on 2020-01-25T18:05:50+00:00", "image": "https://photos.simonwillison.net/i/8a2c43b2888b0777a9ffa4679f13011b3bd91cd57c4fe34a5b612c1bc4ceb147.heic?w=400", "link": "https://photos.simonwillison.net/i/8a2c43b2888b0777a9ffa4679f13011b3bd91cd57c4fe34a5b612c1bc4ceb147.heic?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;