daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
110 rows where confirmed = 8227 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 8
- US 91
- Benin 7
- Sweden 6
- Russia 2
- Canada 1
- India 1
- Netherlands 1
- United Kingdom 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-12 | US | Mississippi | Simpson | 28127 | 8227 | 158 | 0 | 31.91282117 | -89.91716179 | 2022-12-13 04:21:01 | Simpson, Mississippi, US | |
2022-12-11 | US | Mississippi | Simpson | 28127 | 8227 | 158 | 0 | 31.91282117 | -89.91716179 | 2022-12-12 04:21:01 | Simpson, Mississippi, US | |
2022-12-10 | US | Mississippi | Simpson | 28127 | 8227 | 158 | 0 | 31.91282117 | -89.91716179 | 2022-12-11 04:20:50 | Simpson, Mississippi, US | |
2022-12-09 | US | Mississippi | Simpson | 28127 | 8227 | 158 | 0 | 31.91282117 | -89.91716179 | 2022-12-10 04:21:02 | Simpson, Mississippi, US | |
2022-12-08 | US | Mississippi | Simpson | 28127 | 8227 | 158 | 0 | 31.91282117 | -89.91716179 | 2022-12-09 04:21:05 | Simpson, Mississippi, US | |
2022-12-07 | US | Mississippi | Simpson | 28127 | 8227 | 158 | 0 | 31.91282117 | -89.91716179 | 2022-12-08 04:21:07 | Simpson, Mississippi, US | |
2022-12-06 | US | Mississippi | Simpson | 28127 | 8227 | 158 | 0 | 31.91282117 | -89.91716179 | 2022-12-07 04:20:58 | Simpson, Mississippi, US | |
2022-11-08 | US | Pennsylvania | Elk | 42047 | 8227 | 111 | 0 | 41.42822061 | -78.64524744 | 2022-11-09 04:21:22 | Elk, Pennsylvania, US | |
2022-11-07 | US | Pennsylvania | Elk | 42047 | 8227 | 111 | 0 | 41.42822061 | -78.64524744 | 2022-11-08 04:21:21 | Elk, Pennsylvania, US | |
2022-11-06 | US | Pennsylvania | Elk | 42047 | 8227 | 111 | 0 | 41.42822061 | -78.64524744 | 2022-11-07 04:21:26 | Elk, Pennsylvania, US | |
2022-11-05 | US | Pennsylvania | Elk | 42047 | 8227 | 111 | 0 | 41.42822061 | -78.64524744 | 2022-11-06 04:21:24 | Elk, Pennsylvania, US | |
2022-11-04 | US | Pennsylvania | Elk | 42047 | 8227 | 111 | 0 | 41.42822061 | -78.64524744 | 2022-11-05 04:21:52 | Elk, Pennsylvania, US | |
2022-11-03 | US | Pennsylvania | Elk | 42047 | 8227 | 111 | 0 | 41.42822061 | -78.64524744 | 2022-11-04 04:22:11 | Elk, Pennsylvania, US | |
2022-11-02 | US | Pennsylvania | Elk | 42047 | 8227 | 111 | 0 | 41.42822061 | -78.64524744 | 2022-11-03 04:22:05 | Elk, Pennsylvania, US | |
2022-10-09 | US | Virginia | Accomack | 51001 | 8227 | 112 | 0 | 37.76707161 | -75.63234615 | 2022-10-10 04:22:32 | Accomack, Virginia, US | |
2022-10-08 | US | Virginia | Accomack | 51001 | 8227 | 112 | 0 | 37.76707161 | -75.63234615 | 2022-10-09 04:21:16 | Accomack, Virginia, US | |
2022-10-07 | US | Virginia | Accomack | 51001 | 8227 | 112 | 0 | 37.76707161 | -75.63234615 | 2022-10-08 04:22:56 | Accomack, Virginia, US | |
2022-10-02 | US | Puerto Rico | Morovis | 72101 | 8227 | 0 | 0 | 18.316963 | -66.420383 | 2022-10-03 04:23:11 | Morovis, Puerto Rico, US | |
2022-09-27 | US | West Virginia | Jackson | 54035 | 8227 | 144 | 0 | 38.84263974 | -81.68148753 | 2022-09-28 04:23:01 | Jackson, West Virginia, US | |
2022-09-21 | US | Ohio | Adams | 39001 | 8227 | 156 | 0 | 38.84541072 | -83.4718964 | 2022-09-22 04:22:56 | Adams, Ohio, US | |
2022-09-20 | US | Ohio | Adams | 39001 | 8227 | 156 | 0 | 38.84541072 | -83.4718964 | 2022-09-21 04:23:22 | Adams, Ohio, US | |
2022-09-19 | US | Ohio | Adams | 39001 | 8227 | 156 | 0 | 38.84541072 | -83.4718964 | 2022-09-20 04:22:48 | Adams, Ohio, US | |
2022-09-18 | US | Ohio | Adams | 39001 | 8227 | 156 | 0 | 38.84541072 | -83.4718964 | 2022-09-19 04:21:49 | Adams, Ohio, US | |
2022-09-17 | US | Ohio | Adams | 39001 | 8227 | 156 | 0 | 38.84541072 | -83.4718964 | 2022-09-18 04:22:50 | Adams, Ohio, US | |
2022-09-16 | US | Ohio | Adams | 39001 | 8227 | 156 | 0 | 38.84541072 | -83.4718964 | 2022-09-17 04:20:19 | Adams, Ohio, US | |
2022-09-15 | US | Ohio | Adams | 39001 | 8227 | 156 | 0 | 38.84541072 | -83.4718964 | 2022-09-16 04:21:19 | Adams, Ohio, US | |
2022-09-06 | US | Indiana | Greene | 18055 | 8227 | 143 | 0 | 39.03630547 | -86.96223202 | 2022-09-07 04:20:59 | Greene, Indiana, US | |
2022-09-05 | US | Indiana | Greene | 18055 | 8227 | 143 | 0 | 39.03630547 | -86.96223202 | 2022-09-06 04:21:02 | Greene, Indiana, US | |
2022-09-04 | US | Indiana | Greene | 18055 | 8227 | 143 | 0 | 39.03630547 | -86.96223202 | 2022-09-05 04:21:01 | Greene, Indiana, US | |
2022-09-03 | US | Indiana | Greene | 18055 | 8227 | 143 | 0 | 39.03630547 | -86.96223202 | 2022-09-04 04:21:22 | Greene, Indiana, US | |
2022-09-02 | US | Indiana | Greene | 18055 | 8227 | 143 | 0 | 39.03630547 | -86.96223202 | 2022-09-03 04:21:04 | Greene, Indiana, US | |
2022-07-31 | US | Oregon | Lincoln | 41041 | 8227 | 95 | 0 | 44.64252874 | -123.869912 | 2022-08-01 04:21:03 | Lincoln, Oregon, US | |
2022-07-30 | US | Oregon | Lincoln | 41041 | 8227 | 95 | 0 | 44.64252874 | -123.869912 | 2022-07-31 04:21:02 | Lincoln, Oregon, US | |
2022-07-29 | US | Oregon | Lincoln | 41041 | 8227 | 95 | 0 | 44.64252874 | -123.869912 | 2022-07-30 04:20:42 | Lincoln, Oregon, US | |
2022-07-14 | US | Indiana | Scott | 18143 | 8227 | 108 | 0 | 38.68672078 | -85.74627859 | 2022-07-15 04:20:53 | Scott, Indiana, US | |
2022-07-13 | US | Indiana | Scott | 18143 | 8227 | 108 | 0 | 38.68672078 | -85.74627859 | 2022-07-14 04:20:57 | Scott, Indiana, US | |
2022-07-11 | US | Texas | Polk | 48373 | 8227 | 249 | 0 | 30.79472531 | -94.8276624 | 2022-07-12 04:20:51 | Polk, Texas, US | |
2022-06-27 | US | Illinois | Saline | 17165 | 8227 | 97 | 0 | 37.75332999 | -88.54119706 | 2022-06-28 04:20:58 | Saline, Illinois, US | |
2022-06-23 | US | Missouri | Marion | 29127 | 8227 | 121 | 0 | 39.80601912 | -91.62203062 | 2022-06-24 04:20:58 | Marion, Missouri, US | |
2022-06-22 | US | Missouri | Marion | 29127 | 8227 | 121 | 0 | 39.80601912 | -91.62203062 | 2022-06-23 04:20:55 | Marion, Missouri, US | |
2022-06-21 | US | Missouri | Marion | 29127 | 8227 | 121 | 0 | 39.80601912 | -91.62203062 | 2022-06-22 04:20:54 | Marion, Missouri, US | |
2022-06-20 | US | Missouri | Marion | 29127 | 8227 | 121 | 0 | 39.80601912 | -91.62203062 | 2022-06-21 04:20:56 | Marion, Missouri, US | |
2022-06-19 | US | Missouri | Marion | 29127 | 8227 | 121 | 0 | 39.80601912 | -91.62203062 | 2022-06-20 04:21:01 | Marion, Missouri, US | |
2022-06-18 | US | Missouri | Marion | 29127 | 8227 | 121 | 0 | 39.80601912 | -91.62203062 | 2022-06-19 04:20:51 | Marion, Missouri, US | |
2022-06-17 | US | Missouri | Marion | 29127 | 8227 | 121 | 0 | 39.80601912 | -91.62203062 | 2022-06-18 04:21:10 | Marion, Missouri, US | |
2022-04-07 | US | Pennsylvania | Clarion | 42031 | 8227 | 203 | 0 | 41.19265812 | -79.42413524 | 2022-04-08 04:20:48 | Clarion, Pennsylvania, US | |
2022-03-20 | US | Texas | Bee | 48025 | 8227 | 152 | 0 | 28.41761668 | -97.74215593 | 2022-03-21 04:20:50 | Bee, Texas, US | |
2022-03-19 | US | Texas | Bee | 48025 | 8227 | 152 | 0 | 28.41761668 | -97.74215593 | 2022-03-20 04:20:45 | Bee, Texas, US | |
2022-03-06 | US | Ohio | Perry | 39127 | 8227 | 125 | 0 | 39.73508655 | -82.23804971 | 2022-03-07 04:20:47 | Perry, Ohio, US | |
2022-03-04 | US | New York | Wyoming | 36121 | 8227 | 82 | 0 | 42.70145109 | -78.22199579 | 2022-03-05 04:21:10 | Wyoming, New York, US | |
2022-03-03 | US | Tennessee | White | 47185 | 8227 | 126 | 0 | 35.92929884 | -85.45591799 | 2022-03-04 04:21:09 | White, Tennessee, US | |
2022-03-03 | US | New York | Wyoming | 36121 | 8227 | 82 | 0 | 42.70145109 | -78.22199579 | 2022-03-04 04:21:09 | Wyoming, New York, US | |
2022-02-23 | US | Indiana | Ripley | 18137 | 8227 | 127 | 0 | 39.10235626 | -85.26212744 | 2022-02-24 04:21:14 | Ripley, Indiana, US | |
2022-01-18 | US | Maine | Oxford | 23017 | 8227 | 112 | 0 | 44.49952995 | -70.75682123 | 2022-01-19 04:21:23 | Oxford, Maine, US | |
2022-01-10 | US | Kentucky | Greenup | 21089 | 8227 | 110 | 0 | 38.54332505 | -82.9215658 | 2022-01-11 04:22:01 | Greenup, Kentucky, US | |
2022-01-06 | US | Kansas | Crawford | 20037 | 8227 | 107 | 0 | 37.50675523 | -94.85245778 | 2022-01-07 04:22:09 | Crawford, Kansas, US | |
2022-01-05 | US | Kansas | Crawford | 20037 | 8227 | 107 | 0 | 37.50675523 | -94.85245778 | 2022-01-06 04:22:09 | Crawford, Kansas, US | |
2021-12-27 | US | North Carolina | Halifax | 37083 | 8227 | 146 | 0 | 36.25669272 | -77.6556109 | 2021-12-28 04:21:47 | Halifax, North Carolina, US | |
2021-12-26 | US | North Carolina | Halifax | 37083 | 8227 | 146 | 0 | 36.25669272 | -77.6556109 | 2021-12-27 04:21:58 | Halifax, North Carolina, US | |
2021-12-26 | US | Illinois | Henry | 17073 | 8227 | 94 | 0 | 41.3533994 | -90.13296166 | 2021-12-27 04:21:58 | Henry, Illinois, US | |
2021-12-25 | US | North Carolina | Halifax | 37083 | 8227 | 146 | 0 | 36.25669272 | -77.6556109 | 2021-12-26 04:21:50 | Halifax, North Carolina, US | |
2021-12-25 | US | Illinois | Henry | 17073 | 8227 | 94 | 0 | 41.3533994 | -90.13296166 | 2021-12-26 04:21:50 | Henry, Illinois, US | |
2021-12-24 | US | North Carolina | Halifax | 37083 | 8227 | 146 | 0 | 36.25669272 | -77.6556109 | 2021-12-25 04:21:37 | Halifax, North Carolina, US | |
2021-12-24 | US | Illinois | Henry | 17073 | 8227 | 94 | 0 | 41.3533994 | -90.13296166 | 2021-12-25 04:21:37 | Henry, Illinois, US | |
2021-12-23 | US | North Carolina | Halifax | 37083 | 8227 | 146 | 0 | 36.25669272 | -77.6556109 | 2021-12-24 04:21:34 | Halifax, North Carolina, US | |
2021-12-23 | US | Illinois | Henry | 17073 | 8227 | 94 | 0 | 41.3533994 | -90.13296166 | 2021-12-24 04:21:34 | Henry, Illinois, US | |
2021-12-22 | US | North Carolina | Halifax | 37083 | 8227 | 146 | 0 | 36.25669272 | -77.6556109 | 2021-12-23 04:21:21 | Halifax, North Carolina, US | |
2021-12-19 | US | Missouri | Pettis | 29159 | 8227 | 128 | 0 | 38.72798918 | -93.28471706 | 2021-12-20 04:21:43 | Pettis, Missouri, US | |
2021-12-14 | US | Pennsylvania | Bedford | 42009 | 8227 | 202 | 0 | 40.00522157 | -78.48998442 | 2021-12-15 03:22:16 | Bedford, Pennsylvania, US | |
2021-12-14 | US | Illinois | Knox | 17095 | 8227 | 180 | 0 | 40.93148779 | -90.21330340000002 | 2021-12-15 03:22:16 | Knox, Illinois, US | |
2021-12-05 | US | Tennessee | Dyer | 47045 | 8227 | 155 | 0 | 36.05931946 | -89.41542855 | 2021-12-06 04:22:34 | Dyer, Tennessee, US | |
2021-12-04 | US | Pennsylvania | Venango | 42121 | 8227 | 174 | 0 | 41.40323442 | -79.75845449 | 2021-12-05 04:22:25 | Venango, Pennsylvania, US | |
2021-11-29 | Canada | Nova Scotia | 8227 | 110 | 0 | 44.681999999999995 | -63.7443 | 2021-11-30 04:22:53 | Nova Scotia, Canada | |||
2021-10-20 | US | Indiana | Henry | 18065 | 8227 | 152 | 0 | 39.93029017 | -85.39625719 | 2021-10-21 04:21:18 | Henry, Indiana, US | |
2021-10-18 | US | North Carolina | Carteret | 37031 | 8227 | 83 | 0 | 34.8932941 | -76.54120135 | 2021-10-19 04:20:54 | Carteret, North Carolina, US | |
2021-10-18 | US | Minnesota | Kandiyohi | 27067 | 8227 | 96 | 0 | 45.1526059 | -95.00586446 | 2021-10-19 04:20:54 | Kandiyohi, Minnesota, US | |
2021-08-21 | US | Tennessee | Gibson | 47053 | 8227 | 152 | 0 | 35.99438059 | -88.93358327 | 2021-08-22 04:21:29 | Gibson, Tennessee, US | |
2021-07-13 | Benin | 8227 | 105 | 8000 | 122 | 9.3077 | 2.3158 | 2021-07-14 04:21:35 | Benin | |||
2021-07-12 | Benin | 8227 | 105 | 8000 | 122 | 9.3077 | 2.3158 | 2021-07-13 04:21:18 | Benin | |||
2021-07-11 | Benin | 8227 | 105 | 8000 | 122 | 9.3077 | 2.3158 | 2021-07-12 04:21:34 | Benin | |||
2021-07-10 | Benin | 8227 | 105 | 8000 | 122 | 9.3077 | 2.3158 | 2021-07-11 04:21:43 | Benin | |||
2021-07-09 | Benin | 8227 | 105 | 8000 | 122 | 9.3077 | 2.3158 | 2021-07-10 04:21:25 | Benin | |||
2021-07-08 | Benin | 8227 | 105 | 8000 | 122 | 9.3077 | 2.3158 | 2021-07-09 04:21:21 | Benin | |||
2021-07-07 | Benin | 8227 | 105 | 8000 | 122 | 9.3077 | 2.3158 | 2021-07-08 04:21:26 | Benin | |||
2021-07-05 | US | Texas | Liberty | 48291 | 8227 | 197 | 0 | 30.15152688 | -94.81205615 | 2021-07-06 04:21:32 | Liberty, Texas, US | |
2021-05-11 | US | Alabama | Talladega | 1121 | 8227 | 176 | 0 | 33.37823223 | -86.16886178 | 2021-05-12 04:21:29 | Talladega, Alabama, US | |
2021-05-10 | US | Virginia | Roanoke | 51161 | 8227 | 143 | 0 | 37.26865804 | -80.06396753 | 2021-05-11 04:20:41 | Roanoke, Virginia, US | |
2021-04-13 | US | New York | Chautauqua | 36013 | 8227 | 132 | 0 | 42.22769210000001 | -79.36691763 | 2021-04-14 04:20:41 | Chautauqua, New York, US | |
2021-03-17 | US | Connecticut | Tolland | 9013 | 8227 | 174 | 0 | 41.85853803 | -72.3308481 | 2021-03-18 05:26:22 | Tolland, Connecticut, US | |
2021-03-16 | US | Minnesota | Carver | 27019 | 8227 | 41 | 0 | 44.82017001 | -93.8009918 | 2021-03-17 05:25:07 | Carver, Minnesota, US | |
2021-03-10 | US | West Virginia | Monongalia | 54061 | 8227 | 71 | 0 | 39.63218457 | -80.04766838 | 2021-03-11 05:25:48 | Monongalia, West Virginia, US | |
2021-03-10 | Netherlands | Aruba | 8227 | 77 | 7929 | 221 | 12.5211 | -69.9683 | 2021-03-11 05:25:48 | Aruba, Netherlands | ||
2021-03-09 | US | Florida | Sumter | 12119 | 8227 | 242 | 0 | 28.70181754 | -82.0794267 | 2021-03-10 05:24:35 | Sumter, Florida, US | |
2021-02-02 | US | Indiana | Kosciusko | 18085 | 8227 | 98 | 0 | 8129 | 41.24521668 | -85.86312322 | 2021-02-03 05:22:52 | Kosciusko, Indiana, US |
2021-01-24 | US | New York | Ulster | 36111 | 8227 | 202 | 0 | 8025 | 41.89027881 | -74.26252104 | 2021-01-25 05:22:16 | Ulster, New York, US |
2021-01-20 | US | West Virginia | Berkeley | 54003 | 8227 | 73 | 0 | 8154 | 39.46704621 | -78.02414609 | 2021-01-21 05:22:01 | Berkeley, West Virginia, US |
2020-12-28 | Sweden | Sormland | 8227 | 304 | 0 | 7923 | 59.0336 | 16.7519 | 2020-12-29 05:22:37 | Sormland, Sweden | ||
2020-12-27 | Sweden | Sormland | 8227 | 304 | 0 | 7923 | 59.0336 | 16.7519 | 2020-12-28 05:22:06 | Sormland, Sweden | ||
2020-12-26 | Sweden | Sormland | 8227 | 304 | 0 | 7923 | 59.0336 | 16.7519 | 2020-12-27 05:22:55 | Sormland, Sweden | ||
2020-12-25 | Sweden | Sormland | 8227 | 304 | 0 | 7923 | 59.0336 | 16.7519 | 2020-12-26 05:22:28 | Sormland, Sweden |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;