daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where active = 4470 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-05-05 | Sudan | 34082 | 2365 | 27247 | 4470 | 12.8628 | 30.2176 | 2021-05-06 04:20:38 | Sudan | |||
2021-04-28 | Syria | 22513 | 1572 | 16471 | 4470 | 34.802075 | 38.99681500000001 | 2021-04-29 04:20:55 | Syria | |||
2021-03-21 | Italy | Basilicata | 18358 | 412 | 13476 | 4470 | 40.63947052 | 15.80514834 | 2021-03-22 05:25:43 | Basilicata, Italy | ||
2021-03-12 | Russia | Saratov Oblast | 51698 | 707 | 46521 | 4470 | 51.6520555 | 46.86319520000001 | 2021-03-13 05:25:15 | Saratov Oblast, Russia | ||
2021-03-09 | Canada | Alberta | 136374 | 1926 | 129978 | 4470 | 53.9333 | -116.5765 | 2021-03-10 05:24:35 | Alberta, Canada | ||
2021-03-04 | US | Pennsylvania | Mifflin | 42087 | 4640 | 170 | 0 | 4470 | 40.61116939 | -77.61070738 | 2021-03-05 05:26:29 | Mifflin, Pennsylvania, US |
2021-02-18 | US | Vermont | Chittenden | 50007 | 4553 | 83 | 0 | 4470 | 44.46322849 | -73.08359212 | 2021-02-19 05:24:16 | Chittenden, Vermont, US |
2021-02-16 | US | West Virginia | Raleigh | 54081 | 4524 | 54 | 0 | 4470 | 37.76936795 | -81.2456041 | 2021-02-17 05:23:10 | Raleigh, West Virginia, US |
2021-02-11 | US | Illinois | Jackson | 17077 | 4530 | 60 | 0 | 4470 | 37.78595185 | -89.38232563 | 2021-02-12 05:23:29 | Jackson, Illinois, US |
2021-02-10 | US | Nebraska | Dodge | 31053 | 4522 | 52 | 0 | 4470 | 41.58071748 | -96.65598179 | 2021-02-11 05:23:55 | Dodge, Nebraska, US |
2021-02-05 | US | Wyoming | Fremont | 56013 | 4549 | 79 | 0 | 4470 | 43.04183996 | -108.6296893 | 2021-02-06 05:23:55 | Fremont, Wyoming, US |
2021-02-01 | US | Michigan | Lapeer | 26087 | 4584 | 114 | 0 | 4470 | 43.09052506 | -83.22153148 | 2021-02-02 05:22:49 | Lapeer, Michigan, US |
2021-01-17 | US | Georgia | Laurens | 13175 | 4596 | 126 | 0 | 4470 | 32.46325233 | -82.92221316 | 2021-01-18 05:22:34 | Laurens, Georgia, US |
2021-01-17 | Colombia | Atlantico | 105386 | 3640 | 97276 | 4470 | 10.6966 | -74.8741 | 2021-01-18 05:22:34 | Atlantico, Colombia | ||
2021-01-16 | US | Minnesota | Otter Tail | 27111 | 4534 | 64 | 0 | 4470 | 46.40846929 | -95.70835255 | 2021-01-17 05:22:17 | Otter Tail, Minnesota, US |
2021-01-13 | US | South Carolina | Kershaw | 45055 | 4553 | 83 | 0 | 4470 | 34.33988254 | -80.58763164 | 2021-01-14 05:22:32 | Kershaw, South Carolina, US |
2021-01-13 | Italy | Umbria | 31467 | 676 | 26321 | 4470 | 43.10675841 | 12.38824698 | 2021-01-14 05:22:32 | Umbria, Italy | ||
2021-01-05 | Russia | Tver Oblast | 23416 | 462 | 18484 | 4470 | 57.1134475 | 35.174442799999994 | 2021-01-06 05:22:16 | Tver Oblast, Russia | ||
2021-01-04 | US | Virginia | Harrisonburg | 51660 | 4514 | 44 | 0 | 4470 | 38.43542574 | -78.87536254 | 2021-01-05 05:21:49 | Harrisonburg, Virginia, US |
2021-01-01 | US | Indiana | Boone | 18011 | 4541 | 71 | 0 | 4470 | 40.0509304 | -86.46841646 | 2021-01-02 05:22:33 | Boone, Indiana, US |
2020-12-08 | US | Oregon | Jackson | 41029 | 4514 | 44 | 0 | 4470 | 42.43201126 | -122.7289309 | 2020-12-09 05:28:01 | Jackson, Oregon, US |
2020-12-01 | US | Wisconsin | Wood | 55141 | 4503 | 33 | 0 | 4470 | 44.45537896 | -90.04158336 | 2020-12-02 05:27:41 | Wood, Wisconsin, US |
2020-11-27 | US | Tennessee | Unassigned | 90047 | 3483 | 22 | 0 | 4470 | 36.55606529 | 0.0 | 2020-11-28 05:25:50 | Unassigned, Tennessee, US |
2020-11-25 | US | Texas | Walker | 48471 | 5545 | 69 | 0 | 4470 | 30.73872995 | -95.57440968 | 2020-11-26 05:27:44 | Walker, Texas, US |
2020-11-10 | US | Tennessee | Washington | 47179 | 4535 | 83 | 0 | 4470 | 36.29472368 | -82.49454720000001 | 2020-11-11 05:25:30 | Washington, Tennessee, US |
2020-10-25 | US | Wisconsin | Sheboygan | 55117 | 4494 | 24 | 0 | 4470 | 43.72099677 | -87.94579284 | 2020-10-26 04:25:02 | Sheboygan, Wisconsin, US |
2020-10-22 | US | Louisiana | Rapides | 22079 | 4624 | 154 | 0 | 4470 | 31.19778499 | -92.52997303 | 2020-10-23 04:24:46 | Rapides, Louisiana, US |
2020-10-12 | Ukraine | Donetsk Oblast | 5699 | 66 | 1163 | 4470 | 48.0159 | 37.8028 | 2020-10-13 04:24:02 | Donetsk Oblast, Ukraine | ||
2020-09-18 | Bulgaria | 18733 | 753 | 13510 | 4470 | 42.7339 | 25.4858 | 2020-09-19 04:22:00 | Bulgaria | |||
2020-09-01 | Colombia | Cesar | 11211 | 313 | 6428 | 4470 | 9.3373 | -73.6536 | 2020-09-02 04:28:25 | Cesar, Colombia | ||
2020-08-04 | Russia | Chelyabinsk Oblast | 11628 | 94 | 7064 | 4470 | 54.4223954 | 61.1865846 | 2020-08-05 04:34:43 | Chelyabinsk Oblast, Russia | ||
2020-07-29 | US | Alabama | Madison | 1089 | 4495 | 25 | 0 | 4470 | 34.76327133 | -86.55069633 | 2020-07-30 04:35:05 | Madison, Alabama, US |
2020-04-25 | US | Indiana | Marion | 18097 | 4727 | 257 | 0 | 4470 | 39.78163624 | -86.13826325 | 2020-04-26 02:30:51 | Marion, Indiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;