daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
37 rows where active = 4317 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-06-17 | Burundi | 5098 | 8 | 773 | 4317 | -3.3731 | 29.9189 | 2021-06-18 04:22:16 | Burundi | |||
2021-06-15 | Belarus | 406861 | 2995 | 399549 | 4317 | 53.7098 | 27.9534 | 2021-06-16 04:22:32 | Belarus | |||
2021-04-22 | Germany | Mecklenburg-Vorpommern | 37392 | 950 | 32610 | 4317 | 53.6127 | 12.4296 | 2021-04-23 04:20:52 | Mecklenburg-Vorpommern, Germany | ||
2021-03-18 | Italy | Basilicata | 17987 | 401 | 13269 | 4317 | 40.63947052 | 15.80514834 | 2021-03-19 05:26:09 | Basilicata, Italy | ||
2021-03-04 | US | Oklahoma | Delaware | 40041 | 4379 | 62 | 0 | 4317 | 36.40823634 | -94.80325046 | 2021-03-05 05:26:29 | Delaware, Oklahoma, US |
2021-03-03 | US | New York | Genesee | 36037 | 4435 | 118 | 0 | 4317 | 43.0022601 | -78.19135193 | 2021-03-04 05:24:24 | Genesee, New York, US |
2021-02-12 | US | Texas | Harrison | 48203 | 4923 | 88 | 0 | 4317 | 32.54935988 | -94.36934071 | 2021-02-13 05:22:12 | Harrison, Texas, US |
2021-02-07 | US | New York | Sullivan | 36105 | 4375 | 58 | 0 | 4317 | 41.71579493 | -74.76394559 | 2021-02-08 05:22:39 | Sullivan, New York, US |
2021-02-07 | US | Nevada | Elko | 32007 | 4365 | 48 | 0 | 4317 | 41.14531606 | -115.3577619 | 2021-02-08 05:22:39 | Elko, Nevada, US |
2021-01-31 | US | Iowa | Marshall | 19127 | 4385 | 68 | 0 | 4317 | 42.03586837 | -92.9990819 | 2021-02-01 05:22:53 | Marshall, Iowa, US |
2021-01-11 | US | Washington | Whatcom | 53073 | 4373 | 56 | 0 | 4317 | 48.82227976 | -121.7490018 | 2021-01-12 05:22:15 | Whatcom, Washington, US |
2021-01-11 | US | Iowa | Clinton | 19045 | 4378 | 61 | 0 | 4317 | 41.89981633 | -90.53275096 | 2021-01-12 05:22:15 | Clinton, Iowa, US |
2021-01-02 | US | Virginia | Lynchburg | 51680 | 4371 | 54 | 0 | 4317 | 37.40021399 | -79.19888138 | 2021-01-03 05:22:52 | Lynchburg, Virginia, US |
2020-12-29 | US | South Dakota | Brown | 46013 | 4374 | 57 | 0 | 4317 | 45.58994323 | -98.35165355 | 2020-12-30 05:22:34 | Brown, South Dakota, US |
2020-12-22 | US | Wisconsin | Grant | 55043 | 4399 | 82 | 0 | 4317 | 42.8671731 | -90.7063218 | 2020-12-23 05:22:03 | Grant, Wisconsin, US |
2020-12-18 | US | Illinois | Whiteside | 17195 | 4429 | 112 | 0 | 4317 | 41.75509713 | -89.91556058 | 2020-12-19 05:27:52 | Whiteside, Illinois, US |
2020-12-18 | US | Georgia | Walton | 13297 | 4405 | 88 | 0 | 4317 | 33.78017694 | -83.73552314 | 2020-12-19 05:27:52 | Walton, Georgia, US |
2020-11-29 | US | Washington | Grant | 53025 | 4351 | 34 | 0 | 4317 | 47.20753737 | -119.4500749 | 2020-11-30 05:26:13 | Grant, Washington, US |
2020-11-25 | US | Wisconsin | St. Croix | 55109 | 4337 | 20 | 0 | 4317 | 45.03437474 | -92.45000068 | 2020-11-26 05:27:44 | St. Croix, Wisconsin, US |
2020-11-08 | US | Tennessee | Washington | 47179 | 4429 | 78 | 0 | 4317 | 36.29472368 | -82.49454720000001 | 2020-11-09 05:25:45 | Washington, Tennessee, US |
2020-11-05 | US | New Jersey | Cumberland | 34011 | 4479 | 162 | 0 | 4317 | 39.37199394 | -75.10712559 | 2020-11-06 05:24:55 | Cumberland, New Jersey, US |
2020-11-04 | US | Virginia | Alexandria | 51510 | 4391 | 74 | 0 | 4317 | 38.814003 | -77.08183073 | 2020-11-05 06:05:03 | Alexandria, Virginia, US |
2020-10-22 | Australia | New South Wales | 4370 | 53 | 0 | 4317 | -33.8688 | 151.2093 | 2020-10-23 04:24:46 | New South Wales, Australia | ||
2020-10-18 | Botswana | 5242 | 20 | 905 | 4317 | -22.3285 | 24.6849 | 2020-10-19 04:24:16 | Botswana | |||
2020-10-17 | Botswana | 5242 | 20 | 905 | 4317 | -22.3285 | 24.6849 | 2020-10-18 04:24:25 | Botswana | |||
2020-10-16 | Jamaica | 8132 | 162 | 3653 | 4317 | 18.1096 | -77.2975 | 2020-10-17 04:24:12 | Jamaica | |||
2020-10-16 | Botswana | 5242 | 20 | 905 | 4317 | -22.3285 | 24.6849 | 2020-10-17 04:24:12 | Botswana | |||
2020-10-11 | US | Mississippi | Harrison | 28047 | 4396 | 79 | 0 | 4317 | 30.51359752 | -89.12467576 | 2020-10-12 04:23:45 | Harrison, Mississippi, US |
2020-09-29 | US | Colorado | Boulder | 8013 | 4680 | 74 | 0 | 4317 | 40.09313619 | -105.3546767 | 2020-09-30 04:23:33 | Boulder, Colorado, US |
2020-09-24 | US | Louisiana | Tangipahoa | 22105 | 4435 | 118 | 0 | 4317 | 30.62888673 | -90.40664996 | 2020-09-25 04:23:00 | Tangipahoa, Louisiana, US |
2020-09-06 | US | South Carolina | Florence | 45041 | 4483 | 166 | 0 | 4317 | 34.02361754 | -79.70189312 | 2020-09-07 04:28:30 | Florence, South Carolina, US |
2020-09-05 | US | North Carolina | Cumberland | 37051 | 4386 | 69 | 0 | 4317 | 35.04762133 | -78.82623165 | 2020-09-06 04:28:33 | Cumberland, North Carolina, US |
2020-08-28 | US | Virginia | Henrico | 51087 | 4510 | 193 | 0 | 4317 | 37.53460572 | -77.39326555 | 2020-08-29 04:28:19 | Henrico, Virginia, US |
2020-08-08 | US | Michigan | Michigan Department of Corrections (MDOC) | 4386 | 69 | 0 | 4317 | 47.63197653 | 0.0 | 2020-08-09 04:34:54 | Michigan Department of Corrections (MDOC), Michigan, US | |
2020-08-07 | US | Michigan | Michigan Department of Corrections (MDOC) | 4386 | 69 | 0 | 4317 | 47.63197653 | 0.0 | 2020-08-08 04:34:53 | Michigan Department of Corrections (MDOC), Michigan, US | |
2020-06-09 | Brazil | Parana | 7410 | 260 | 2744 | 4317 | -25.2521 | -52.0215 | 2020-06-10 04:07:00 | Parana, Brazil | ||
2020-03-24 | China | Hubei | 67801 | 3160 | 60324 | 4317 | 30.9756 | 112.2707 | 2020-03-24 13:02:57 | Hubei, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;