daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
47 rows where active = 3692 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-05-27 | India | Arunachal Pradesh | 25820 | 109 | 22019 | 3692 | 27.768456 | 96.384277 | 2021-05-28 04:20:36 | Arunachal Pradesh, India | ||
2021-03-06 | US | West Virginia | Marion | 54049 | 3726 | 34 | 0 | 3692 | 39.50984542 | -80.24244659 | 2021-03-07 05:21:54 | Marion, West Virginia, US |
2021-03-03 | US | Georgia | Camden | 13039 | 3725 | 33 | 0 | 3692 | 30.92951916 | -81.66601818 | 2021-03-04 05:24:24 | Camden, Georgia, US |
2021-02-28 | US | Louisiana | St. Bernard | 22087 | 3738 | 46 | 0 | 3692 | 29.87761636 | -89.51887093 | 2021-03-01 05:23:01 | St. Bernard, Louisiana, US |
2021-02-27 | US | Pennsylvania | Bedford | 42009 | 3821 | 129 | 0 | 3692 | 40.00522157 | -78.48998442 | 2021-02-28 05:22:20 | Bedford, Pennsylvania, US |
2021-02-26 | US | South Carolina | Williamsburg | 45089 | 3780 | 88 | 0 | 3692 | 33.62190129 | -79.72767442 | 2021-02-27 05:22:28 | Williamsburg, South Carolina, US |
2021-02-23 | Italy | Basilicata | 15037 | 368 | 10977 | 3692 | 40.63947052 | 15.80514834 | 2021-02-24 05:29:16 | Basilicata, Italy | ||
2021-02-21 | US | Alabama | Chilton | 1021 | 3785 | 93 | 0 | 3692 | 32.85044126 | -86.7173256 | 2021-02-22 05:24:21 | Chilton, Alabama, US |
2021-02-19 | US | Oklahoma | McCurtain | 40089 | 3753 | 61 | 0 | 3692 | 34.11664328 | -94.77222373 | 2021-02-20 05:22:51 | McCurtain, Oklahoma, US |
2021-02-17 | US | Missouri | Scott | 29201 | 3766 | 74 | 0 | 3692 | 37.05588075 | -89.56474493 | 2021-02-18 05:22:58 | Scott, Missouri, US |
2021-02-16 | US | Indiana | DeKalb | 18033 | 3769 | 77 | 0 | 3692 | 41.39804622 | -84.99906934 | 2021-02-17 05:23:10 | DeKalb, Indiana, US |
2021-02-15 | US | North Carolina | Watauga | 37189 | 3718 | 26 | 0 | 3692 | 36.23103603 | -81.70033724 | 2021-02-16 05:24:38 | Watauga, North Carolina, US |
2021-02-10 | US | Kentucky | Barren | 21009 | 3746 | 54 | 0 | 3692 | 36.96469836 | -85.93338945 | 2021-02-11 05:23:55 | Barren, Kentucky, US |
2021-02-10 | US | Alabama | Covington | 1039 | 3787 | 95 | 0 | 3692 | 31.2477854 | -86.45050893 | 2021-02-11 05:23:55 | Covington, Alabama, US |
2021-02-08 | US | Tennessee | Cocke | 47029 | 3818 | 85 | 0 | 3692 | 35.9278914 | -83.11828725 | 2021-02-09 05:23:30 | Cocke, Tennessee, US |
2021-02-05 | US | Ohio | Madison | 39097 | 3745 | 53 | 0 | 3692 | 39.89381073 | -83.40178317 | 2021-02-06 05:23:55 | Madison, Ohio, US |
2021-02-03 | US | South Dakota | Codington | 46029 | 3766 | 74 | 0 | 3692 | 44.97788119 | -97.18827677 | 2021-02-04 05:22:26 | Codington, South Dakota, US |
2021-02-01 | US | Virginia | Manassas | 51683 | 3725 | 33 | 0 | 3692 | 38.7464321 | -77.48509905 | 2021-02-02 05:22:49 | Manassas, Virginia, US |
2021-02-01 | US | Texas | Brown | 48049 | 4022 | 89 | 0 | 3692 | 31.77430356 | -98.99907113 | 2021-02-02 05:22:49 | Brown, Texas, US |
2021-01-31 | US | Texas | Brown | 48049 | 4022 | 89 | 0 | 3692 | 31.77430356 | -98.99907113 | 2021-02-01 05:22:53 | Brown, Texas, US |
2021-01-30 | US | Texas | Brown | 48049 | 4022 | 89 | 0 | 3692 | 31.77430356 | -98.99907113 | 2021-01-31 05:22:42 | Brown, Texas, US |
2021-01-24 | US | Kentucky | Shelby | 21211 | 3723 | 31 | 0 | 3692 | 38.21476019 | -85.194223 | 2021-01-25 05:22:16 | Shelby, Kentucky, US |
2021-01-23 | US | Minnesota | Mower | 27099 | 3721 | 29 | 0 | 3692 | 43.67142874 | -92.75234549 | 2021-01-24 05:22:35 | Mower, Minnesota, US |
2021-01-15 | US | Ohio | Belmont | 39013 | 3821 | 129 | 0 | 3692 | 40.01625942 | -80.9924051 | 2021-01-16 05:22:40 | Belmont, Ohio, US |
2021-01-13 | US | North Carolina | McDowell | 37111 | 3731 | 39 | 0 | 3692 | 35.67736232 | -82.0482425 | 2021-01-14 05:22:32 | McDowell, North Carolina, US |
2021-01-11 | US | Ohio | Jefferson | 39081 | 3805 | 113 | 0 | 3692 | 40.38614126 | -80.76259514 | 2021-01-12 05:22:15 | Jefferson, Ohio, US |
2021-01-02 | US | North Carolina | Columbus | 37047 | 3775 | 83 | 0 | 3692 | 34.26744084 | -78.65801424 | 2021-01-03 05:22:52 | Columbus, North Carolina, US |
2021-01-01 | US | Georgia | Laurens | 13175 | 3814 | 122 | 0 | 3692 | 32.46325233 | -82.92221316 | 2021-01-02 05:22:33 | Laurens, Georgia, US |
2020-12-29 | US | Iowa | Warren | 19181 | 3725 | 33 | 0 | 3692 | 41.33559454 | -93.56007641 | 2020-12-30 05:22:34 | Warren, Iowa, US |
2020-12-25 | US | Virginia | Suffolk | 51800 | 3781 | 89 | 0 | 3692 | 36.70155394 | -76.63603554 | 2020-12-26 05:22:28 | Suffolk, Virginia, US |
2020-12-23 | El Salvador | 44328 | 1274 | 39362 | 3692 | 13.7942 | -88.8965 | 2020-12-24 05:23:04 | El Salvador | |||
2020-12-22 | US | Minnesota | Benton | 27009 | 3764 | 72 | 0 | 3692 | 45.69804958 | -93.99514135 | 2020-12-23 05:22:03 | Benton, Minnesota, US |
2020-12-17 | US | Tennessee | Carter | 47019 | 3918 | 76 | 0 | 3692 | 36.28969086 | -82.12588974 | 2020-12-18 05:28:18 | Carter, Tennessee, US |
2020-12-12 | US | Iowa | Marshall | 19127 | 3745 | 53 | 0 | 3692 | 42.03586837 | -92.9990819 | 2020-12-13 05:27:20 | Marshall, Iowa, US |
2020-11-04 | US | Florida | Hernando | 12053 | 3869 | 177 | 0 | 3692 | 28.55364461 | -82.42700204 | 2020-11-05 06:05:03 | Hernando, Florida, US |
2020-11-02 | US | Pennsylvania | Lackawanna | 42069 | 3911 | 219 | 0 | 3692 | 41.43564672 | -75.60379201 | 2020-11-03 06:00:16 | Lackawanna, Pennsylvania, US |
2020-10-21 | US | Puerto Rico | Carolina | 72031 | 3692 | 0 | 0 | 3692 | 18.374986 | -65.95683100000001 | 2020-10-22 04:24:27 | Carolina, Puerto Rico, US |
2020-10-03 | US | Texas | Walker | 48471 | 4691 | 57 | 0 | 3692 | 30.73872995 | -95.57440968 | 2020-10-04 04:23:44 | Walker, Texas, US |
2020-09-24 | US | Virginia | Alexandria | 51510 | 3761 | 69 | 0 | 3692 | 38.814003 | -77.08183073 | 2020-09-25 04:23:00 | Alexandria, Virginia, US |
2020-09-19 | US | Minnesota | Stearns | 27145 | 3715 | 23 | 0 | 3692 | 45.55192576 | -94.61078221 | 2020-09-20 04:22:00 | Stearns, Minnesota, US |
2020-09-05 | US | Utah | Southwest Utah | 3720 | 28 | 0 | 3692 | 37.85447192 | -111.4418764 | 2020-09-06 04:28:33 | Southwest Utah, Utah, US | |
2020-08-30 | US | Louisiana | Rapides | 22079 | 3827 | 135 | 0 | 3692 | 31.19778499 | -92.52997303 | 2020-08-31 04:28:27 | Rapides, Louisiana, US |
2020-08-17 | US | Florida | Okaloosa | 12091 | 3742 | 50 | 0 | 3692 | 30.69143028 | -86.59267105 | 2020-08-18 04:27:56 | Okaloosa, Florida, US |
2020-08-15 | Ukraine | Ivano-Frankivsk Oblast | 6468 | 167 | 2609 | 3692 | 48.9226 | 24.7111 | 2020-08-16 04:27:42 | Ivano-Frankivsk Oblast, Ukraine | ||
2020-08-04 | US | South Carolina | Beaufort | 45013 | 3742 | 50 | 0 | 3692 | 32.39226291 | -80.72619758 | 2020-08-05 04:34:43 | Beaufort, South Carolina, US |
2020-06-16 | Canada | Ontario | 32997 | 2538 | 27887 | 3692 | 51.2538 | -85.3232 | 2020-06-17 04:33:21 | Ontario, Canada | ||
2020-05-24 | US | Ohio | Cuyahoga | 39035 | 3927 | 235 | 0 | 3692 | 41.424119 | -81.65918339 | 2020-05-25 02:32:44 | Cuyahoga, Ohio, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;