daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
65 rows where deaths = 3246 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-08 | Chile | Maule | 333085 | 3246 | 0 | -35.5183 | -71.6885 | 2022-12-09 04:21:05 | Maule, Chile | |||
2022-12-05 | Russia | Komi Republic | 191301 | 3246 | 0 | 63.9881421 | 54.3326073 | 2022-12-06 04:21:03 | Komi Republic, Russia | |||
2022-12-04 | Russia | Komi Republic | 191235 | 3246 | 0 | 63.9881421 | 54.3326073 | 2022-12-05 04:20:58 | Komi Republic, Russia | |||
2022-12-03 | Russia | Komi Republic | 191175 | 3246 | 0 | 63.9881421 | 54.3326073 | 2022-12-04 04:20:56 | Komi Republic, Russia | |||
2022-12-02 | Russia | Komi Republic | 191114 | 3246 | 0 | 63.9881421 | 54.3326073 | 2022-12-03 04:21:02 | Komi Republic, Russia | |||
2022-11-21 | Mexico | Nayarit | 72197 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-22 04:20:47 | Nayarit, Mexico | |||
2022-11-20 | Mexico | Nayarit | 72197 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-21 04:21:05 | Nayarit, Mexico | |||
2022-11-19 | Mexico | Nayarit | 72197 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-20 04:21:08 | Nayarit, Mexico | |||
2022-11-18 | Mexico | Nayarit | 72197 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-19 04:21:14 | Nayarit, Mexico | |||
2022-11-17 | Mexico | Nayarit | 72197 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-18 04:21:15 | Nayarit, Mexico | |||
2022-11-16 | Mexico | Nayarit | 72197 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-17 04:21:11 | Nayarit, Mexico | |||
2022-11-15 | Mexico | Nayarit | 72197 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-16 04:21:09 | Nayarit, Mexico | |||
2022-11-14 | Mexico | Nayarit | 72197 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-15 04:21:16 | Nayarit, Mexico | |||
2022-11-13 | Mexico | Nayarit | 72182 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-14 04:21:09 | Nayarit, Mexico | |||
2022-11-12 | Mexico | Nayarit | 72182 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-13 04:21:14 | Nayarit, Mexico | |||
2022-11-11 | Mexico | Nayarit | 72182 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-12 04:20:41 | Nayarit, Mexico | |||
2022-11-10 | Mexico | Nayarit | 72182 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-11 04:21:22 | Nayarit, Mexico | |||
2022-11-09 | Mexico | Nayarit | 72180 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-10 04:21:16 | Nayarit, Mexico | |||
2022-11-08 | Mexico | Nayarit | 72171 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-09 04:21:22 | Nayarit, Mexico | |||
2022-11-07 | Mexico | Nayarit | 72171 | 3246 | 0 | 21.7514 | -104.8455 | 2022-11-08 04:21:21 | Nayarit, Mexico | |||
2022-10-25 | Mexico | Nayarit | 72159 | 3246 | 0 | 21.7514 | -104.8455 | 2022-10-26 04:22:19 | Nayarit, Mexico | |||
2022-10-24 | Mexico | Nayarit | 72159 | 3246 | 0 | 21.7514 | -104.8455 | 2022-10-25 04:21:53 | Nayarit, Mexico | |||
2022-10-23 | Mexico | Nayarit | 72159 | 3246 | 0 | 21.7514 | -104.8455 | 2022-10-24 04:22:29 | Nayarit, Mexico | |||
2022-10-22 | Mexico | Nayarit | 72153 | 3246 | 0 | 21.7514 | -104.8455 | 2022-10-23 04:22:46 | Nayarit, Mexico | |||
2022-10-21 | Mexico | Nayarit | 72153 | 3246 | 0 | 21.7514 | -104.8455 | 2022-10-22 04:22:53 | Nayarit, Mexico | |||
2022-10-20 | Mexico | Nayarit | 72140 | 3246 | 0 | 21.7514 | -104.8455 | 2022-10-21 04:22:23 | Nayarit, Mexico | |||
2022-05-07 | Italy | Abruzzo | 384863 | 3246 | 0 | 42.35122196 | 13.39843823 | 2022-05-08 04:20:49 | Abruzzo, Italy | |||
2022-04-18 | Peru | Ucayali | 39472 | 3246 | 0 | -9.621718 | -73.444929 | 2022-04-19 04:21:00 | Ucayali, Peru | |||
2022-04-17 | Peru | Ucayali | 39472 | 3246 | 0 | -9.621718 | -73.444929 | 2022-04-18 04:21:12 | Ucayali, Peru | |||
2022-04-16 | Peru | Ucayali | 39472 | 3246 | 0 | -9.621718 | -73.444929 | 2022-04-17 04:20:59 | Ucayali, Peru | |||
2022-04-15 | Peru | Ucayali | 39472 | 3246 | 0 | -9.621718 | -73.444929 | 2022-04-16 04:20:48 | Ucayali, Peru | |||
2022-04-14 | Peru | Ucayali | 39472 | 3246 | 0 | -9.621718 | -73.444929 | 2022-04-15 04:20:57 | Ucayali, Peru | |||
2022-04-13 | Peru | Ucayali | 39472 | 3246 | 0 | -9.621718 | -73.444929 | 2022-04-13 23:21:06 | Ucayali, Peru | |||
2022-04-12 | Peru | Ucayali | 39472 | 3246 | 0 | -9.621718 | -73.444929 | 2022-04-13 04:21:03 | Ucayali, Peru | |||
2022-04-11 | Peru | Ucayali | 39472 | 3246 | 0 | -9.621718 | -73.444929 | 2022-04-12 04:20:49 | Ucayali, Peru | |||
2022-03-31 | US | Tennessee | Shelby | 47157 | 235243 | 3246 | 0 | 35.1864775 | -89.89692423 | 2022-04-01 04:20:28 | Shelby, Tennessee, US | |
2021-12-31 | Ukraine | Zhytomyr Oblast | 140441 | 3246 | 0 | 50.2547 | 28.6587 | 2022-01-01 04:22:14 | Zhytomyr Oblast, Ukraine | |||
2021-11-08 | US | Puerto Rico | Unassigned | 72999 | 4200 | 3246 | 0 | 18.459681 | -67.336525 | 2021-11-09 04:21:36 | Unassigned, Puerto Rico, US | |
2021-10-20 | Russia | Volgograd Oblast | 99497 | 3246 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-21 04:21:18 | Volgograd Oblast, Russia | |||
2021-10-01 | Mexico | Zacatecas | 40583 | 3246 | 0 | 22.7709 | -102.5832 | 2021-10-02 04:21:25 | Zacatecas, Mexico | |||
2021-08-29 | United Kingdom | Northern Ireland | 198088 | 3246 | 0 | 54.7877 | -6.4923 | 2021-08-30 04:21:23 | Northern Ireland, United Kingdom | |||
2021-08-16 | Colombia | Magdalena | 90572 | 3246 | 0 | 10.4113 | -74.4057 | 2021-08-17 04:21:49 | Magdalena, Colombia | |||
2021-08-15 | Russia | Altai Krai | 66225 | 3246 | 0 | 52.693224300000004 | 82.69314240000001 | 2021-08-16 04:21:31 | Altai Krai, Russia | |||
2021-07-25 | Mexico | Quintana Roo | 41152 | 3246 | 0 | 37906 | 19.1817 | -88.4791 | 2021-07-26 04:21:28 | Quintana Roo, Mexico | ||
2021-04-29 | Ukraine | Lviv Oblast | 128998 | 3246 | 100933 | 24819 | 49.8397 | 24.0297 | 2021-04-30 04:21:03 | Lviv Oblast, Ukraine | ||
2021-04-29 | Nepal | 317530 | 3246 | 280167 | 34117 | 28.1667 | 84.25 | 2021-04-30 04:21:03 | Nepal | |||
2021-04-18 | Peru | Cusco | 49789 | 3246 | 0 | 46543 | -13.191068 | -72.153609 | 2021-04-19 04:20:57 | Cusco, Peru | ||
2021-04-08 | Russia | Krasnoyarsk Krai | 67760 | 3246 | 62689 | 1825 | 63.3233807 | 97.0979974 | 2021-04-09 04:21:13 | Krasnoyarsk Krai, Russia | ||
2021-04-02 | Mexico | Oaxaca | 43722 | 3246 | 0 | 40476 | 17.0732 | -96.7266 | 2021-04-03 04:20:44 | Oaxaca, Mexico | ||
2021-03-23 | Germany | Brandenburg | 83270 | 3246 | 75486 | 5177 | 52.4125 | 12.5316 | 2021-03-24 05:25:40 | Brandenburg, Germany | ||
2021-03-21 | US | Pennsylvania | Philadelphia | 42101 | 126409 | 3246 | 0 | 40.00338507 | -75.1379271 | 2021-03-22 05:25:43 | Philadelphia, Pennsylvania, US | |
2021-03-20 | US | Pennsylvania | Philadelphia | 42101 | 126073 | 3246 | 0 | 40.00338507 | -75.1379271 | 2021-03-21 05:25:44 | Philadelphia, Pennsylvania, US | |
2021-03-19 | US | Pennsylvania | Philadelphia | 42101 | 125680 | 3246 | 0 | 40.00338507 | -75.1379271 | 2021-03-20 05:25:46 | Philadelphia, Pennsylvania, US | |
2021-02-23 | Brazil | Mato Grosso do Sul | 178250 | 3246 | 166253 | 7664 | -20.7722 | -54.7852 | 2021-02-24 05:29:16 | Mato Grosso do Sul, Brazil | ||
2021-02-20 | Kazakhstan | 256388 | 3246 | 231667 | 21475 | 48.0196 | 66.9237 | 2021-02-21 05:24:33 | Kazakhstan | |||
2021-02-19 | Kazakhstan | 255584 | 3246 | 230946 | 21392 | 48.0196 | 66.9237 | 2021-02-20 05:22:51 | Kazakhstan | |||
2021-02-18 | Kazakhstan | 254712 | 3246 | 229851 | 21615 | 48.0196 | 66.9237 | 2021-02-19 05:24:16 | Kazakhstan | |||
2021-02-17 | Kazakhstan | 253751 | 3246 | 228479 | 22026 | 48.0196 | 66.9237 | 2021-02-18 05:22:58 | Kazakhstan | |||
2021-02-16 | Kazakhstan | 252821 | 3246 | 227258 | 22317 | 48.0196 | 66.9237 | 2021-02-17 05:23:10 | Kazakhstan | |||
2021-02-15 | Kazakhstan | 251959 | 3246 | 225972 | 22741 | 48.0196 | 66.9237 | 2021-02-16 05:24:38 | Kazakhstan | |||
2021-02-14 | Kazakhstan | 251267 | 3246 | 224479 | 23542 | 48.0196 | 66.9237 | 2021-02-15 05:24:49 | Kazakhstan | |||
2020-09-30 | Guatemala | 91746 | 3246 | 80256 | 8244 | 15.7835 | -90.2308 | 2020-10-01 04:23:42 | Guatemala | |||
2020-08-25 | Peru | Lambayeque | 21204 | 3246 | 0 | 17958 | -6.353049 | -79.824113 | 2020-08-26 04:28:11 | Lambayeque, Peru | ||
2020-07-29 | Brazil | Amazonas | 99093 | 3246 | 82512 | 13335 | -3.4168 | -65.8561 | 2020-07-30 04:35:05 | Amazonas, Brazil | ||
2020-05-23 | US | Illinois | Cook | 17031 | 70417 | 3246 | 0 | 67171 | 41.84144849 | -87.81658794 | 2020-05-24 02:32:43 | Cook, Illinois, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;