daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
244 rows where confirmed = 3232 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-22 | US | Virginia | Charlotte | 51037 | 3232 | 49 | 0 | 37.01909701 | -78.66314092 | 2022-12-23 04:21:04 | Charlotte, Virginia, US | |
2022-11-28 | US | Wisconsin | Forest | 55041 | 3232 | 53 | 0 | 45.66678019 | -88.77084892 | 2022-11-29 04:21:05 | Forest, Wisconsin, US | |
2022-10-16 | US | Virginia | Amelia | 51007 | 3232 | 60 | 0 | 37.34081025 | -77.98584649 | 2022-10-17 04:20:31 | Amelia, Virginia, US | |
2022-10-15 | US | Virginia | Amelia | 51007 | 3232 | 60 | 0 | 37.34081025 | -77.98584649 | 2022-10-16 04:22:39 | Amelia, Virginia, US | |
2022-10-14 | US | Virginia | Amelia | 51007 | 3232 | 60 | 0 | 37.34081025 | -77.98584649 | 2022-10-15 04:22:00 | Amelia, Virginia, US | |
2022-10-13 | US | Virginia | Amelia | 51007 | 3232 | 60 | 0 | 37.34081025 | -77.98584649 | 2022-10-14 04:22:28 | Amelia, Virginia, US | |
2022-09-29 | US | Illinois | Marshall | 17123 | 3232 | 33 | 0 | 41.0327901 | -89.34510444 | 2022-09-30 04:23:09 | Marshall, Illinois, US | |
2022-09-28 | US | Illinois | Marshall | 17123 | 3232 | 33 | 0 | 41.0327901 | -89.34510444 | 2022-09-29 04:22:34 | Marshall, Illinois, US | |
2022-09-27 | US | Illinois | Marshall | 17123 | 3232 | 33 | 0 | 41.0327901 | -89.34510444 | 2022-09-28 04:23:01 | Marshall, Illinois, US | |
2022-09-26 | US | Illinois | Marshall | 17123 | 3232 | 33 | 0 | 41.0327901 | -89.34510444 | 2022-09-27 04:23:01 | Marshall, Illinois, US | |
2022-09-20 | US | South Dakota | Charles Mix | 46023 | 3232 | 36 | 0 | 43.20660134 | -98.58856175 | 2022-09-21 04:23:22 | Charles Mix, South Dakota, US | |
2022-09-19 | US | South Dakota | Charles Mix | 46023 | 3232 | 36 | 0 | 43.20660134 | -98.58856175 | 2022-09-20 04:22:48 | Charles Mix, South Dakota, US | |
2022-09-18 | US | South Dakota | Charles Mix | 46023 | 3232 | 36 | 0 | 43.20660134 | -98.58856175 | 2022-09-19 04:21:49 | Charles Mix, South Dakota, US | |
2022-09-17 | US | South Dakota | Charles Mix | 46023 | 3232 | 36 | 0 | 43.20660134 | -98.58856175 | 2022-09-18 04:22:50 | Charles Mix, South Dakota, US | |
2022-09-16 | US | South Dakota | Charles Mix | 46023 | 3232 | 36 | 0 | 43.20660134 | -98.58856175 | 2022-09-17 04:20:19 | Charles Mix, South Dakota, US | |
2022-09-15 | US | South Dakota | Charles Mix | 46023 | 3232 | 36 | 0 | 43.20660134 | -98.58856175 | 2022-09-16 04:21:19 | Charles Mix, South Dakota, US | |
2022-09-14 | US | South Dakota | Charles Mix | 46023 | 3232 | 36 | 0 | 43.20660134 | -98.58856175 | 2022-09-15 04:21:02 | Charles Mix, South Dakota, US | |
2022-08-23 | US | South Dakota | Dewey | 46041 | 3232 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-08-24 04:20:46 | Dewey, South Dakota, US | |
2022-08-22 | US | South Dakota | Dewey | 46041 | 3232 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-08-23 04:20:56 | Dewey, South Dakota, US | |
2022-08-21 | US | South Dakota | Dewey | 46041 | 3232 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-08-22 04:20:38 | Dewey, South Dakota, US | |
2022-08-20 | US | South Dakota | Dewey | 46041 | 3232 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-08-21 04:20:44 | Dewey, South Dakota, US | |
2022-08-19 | US | South Dakota | Dewey | 46041 | 3232 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-08-20 04:21:01 | Dewey, South Dakota, US | |
2022-08-18 | US | South Dakota | Dewey | 46041 | 3232 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-08-19 04:20:54 | Dewey, South Dakota, US | |
2022-08-17 | US | South Dakota | Dewey | 46041 | 3232 | 44 | 0 | 45.15639647 | -100.8709139 | 2022-08-18 04:21:11 | Dewey, South Dakota, US | |
2022-08-14 | China | Henan | 3232 | 22 | 0 | 33.882 | 113.614 | 2022-08-15 04:20:59 | Henan, China | |||
2022-08-07 | US | Mississippi | Montgomery | 28097 | 3232 | 79 | 0 | 33.49419589 | -89.61729103 | 2022-08-08 04:21:08 | Montgomery, Mississippi, US | |
2022-08-07 | US | Indiana | Pulaski | 18131 | 3232 | 87 | 0 | 41.04166107 | -86.69890683 | 2022-08-08 04:21:08 | Pulaski, Indiana, US | |
2022-08-06 | US | Mississippi | Montgomery | 28097 | 3232 | 79 | 0 | 33.49419589 | -89.61729103 | 2022-08-07 04:20:54 | Montgomery, Mississippi, US | |
2022-08-06 | US | Indiana | Pulaski | 18131 | 3232 | 87 | 0 | 41.04166107 | -86.69890683 | 2022-08-07 04:20:54 | Pulaski, Indiana, US | |
2022-08-06 | China | Zhejiang | 3232 | 1 | 0 | 29.1832 | 120.0934 | 2022-08-07 04:20:54 | Zhejiang, China | |||
2022-08-05 | US | Mississippi | Montgomery | 28097 | 3232 | 79 | 0 | 33.49419589 | -89.61729103 | 2022-08-06 04:20:56 | Montgomery, Mississippi, US | |
2022-08-05 | US | Indiana | Pulaski | 18131 | 3232 | 87 | 0 | 41.04166107 | -86.69890683 | 2022-08-06 04:20:56 | Pulaski, Indiana, US | |
2022-08-04 | US | Mississippi | Montgomery | 28097 | 3232 | 79 | 0 | 33.49419589 | -89.61729103 | 2022-08-05 04:20:52 | Montgomery, Mississippi, US | |
2022-08-03 | US | Alabama | Coosa | 1037 | 3232 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-08-04 04:20:58 | Coosa, Alabama, US | |
2022-08-02 | US | Alabama | Coosa | 1037 | 3232 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-08-03 04:20:59 | Coosa, Alabama, US | |
2022-08-01 | US | Alabama | Coosa | 1037 | 3232 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-08-02 04:20:53 | Coosa, Alabama, US | |
2022-07-31 | US | Alabama | Coosa | 1037 | 3232 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-08-01 04:21:03 | Coosa, Alabama, US | |
2022-07-30 | US | Alabama | Coosa | 1037 | 3232 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-07-31 04:21:02 | Coosa, Alabama, US | |
2022-07-29 | US | Alabama | Coosa | 1037 | 3232 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-07-30 04:20:42 | Coosa, Alabama, US | |
2022-07-22 | US | Texas | Nolan | 48353 | 3232 | 99 | 0 | 32.30365282 | -100.4060208 | 2022-07-23 04:20:53 | Nolan, Texas, US | |
2022-06-29 | US | Puerto Rico | Florida | 72054 | 3232 | 0 | 0 | 18.373715 | -66.560488 | 2022-06-30 04:21:01 | Florida, Puerto Rico, US | |
2022-06-16 | US | Minnesota | Chippewa | 27023 | 3232 | 48 | 0 | 45.02343421 | -95.56403693 | 2022-06-17 04:20:56 | Chippewa, Minnesota, US | |
2022-06-14 | US | California | Mono | 6051 | 3232 | 6 | 0 | 37.93899289 | -118.8872409 | 2022-06-15 04:20:54 | Mono, California, US | |
2022-06-13 | US | California | Mono | 6051 | 3232 | 6 | 0 | 37.93899289 | -118.8872409 | 2022-06-14 04:20:52 | Mono, California, US | |
2022-06-03 | US | Puerto Rico | Luquillo | 72089 | 3232 | 0 | 0 | 18.342114 | -65.725097 | 2022-06-04 04:20:58 | Luquillo, Puerto Rico, US | |
2022-05-27 | China | Fujian | 3232 | 1 | 0 | 26.0789 | 117.9874 | 2022-05-28 04:21:07 | Fujian, China | |||
2022-05-17 | US | Oregon | Baker | 41001 | 3232 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-05-18 04:20:50 | Baker, Oregon, US | |
2022-05-16 | US | Oregon | Baker | 41001 | 3232 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-05-17 04:20:59 | Baker, Oregon, US | |
2022-05-02 | US | Minnesota | Cottonwood | 27033 | 3232 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-05-03 04:21:00 | Cottonwood, Minnesota, US | |
2022-04-20 | US | Ohio | Harrison | 39067 | 3232 | 74 | 0 | 40.29380509 | -81.09068544 | 2022-04-21 04:20:46 | Harrison, Ohio, US | |
2022-04-19 | US | Ohio | Harrison | 39067 | 3232 | 74 | 0 | 40.29380509 | -81.09068544 | 2022-04-20 04:20:45 | Harrison, Ohio, US | |
2022-04-18 | US | Ohio | Harrison | 39067 | 3232 | 74 | 0 | 40.29380509 | -81.09068544 | 2022-04-19 04:21:00 | Harrison, Ohio, US | |
2022-04-17 | US | Ohio | Harrison | 39067 | 3232 | 74 | 0 | 40.29380509 | -81.09068544 | 2022-04-18 04:21:12 | Harrison, Ohio, US | |
2022-04-16 | US | Ohio | Harrison | 39067 | 3232 | 74 | 0 | 40.29380509 | -81.09068544 | 2022-04-17 04:20:59 | Harrison, Ohio, US | |
2022-04-15 | US | Ohio | Harrison | 39067 | 3232 | 74 | 0 | 40.29380509 | -81.09068544 | 2022-04-16 04:20:48 | Harrison, Ohio, US | |
2022-04-14 | US | Ohio | Harrison | 39067 | 3232 | 74 | 0 | 40.29380509 | -81.09068544 | 2022-04-15 04:20:57 | Harrison, Ohio, US | |
2022-04-14 | US | Kansas | Nemaha | 20131 | 3232 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-04-13 23:21:06 | Nemaha, Kansas, US | |
2022-04-13 | US | Kansas | Nemaha | 20131 | 3232 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-04-13 23:21:06 | Nemaha, Kansas, US | |
2022-04-12 | US | Kansas | Nemaha | 20131 | 3232 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-04-13 04:21:03 | Nemaha, Kansas, US | |
2022-04-11 | US | Kansas | Nemaha | 20131 | 3232 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-04-12 04:20:49 | Nemaha, Kansas, US | |
2022-04-10 | US | Kansas | Nemaha | 20131 | 3232 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-04-11 04:21:02 | Nemaha, Kansas, US | |
2022-04-09 | US | Kansas | Nemaha | 20131 | 3232 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-04-10 04:20:52 | Nemaha, Kansas, US | |
2022-04-08 | US | Kansas | Nemaha | 20131 | 3232 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-04-09 04:20:42 | Nemaha, Kansas, US | |
2022-04-03 | US | Georgia | Dade | 13083 | 3232 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-04-04 04:20:51 | Dade, Georgia, US | |
2022-04-02 | US | Georgia | Dade | 13083 | 3232 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-04-03 04:20:48 | Dade, Georgia, US | |
2022-04-01 | US | Georgia | Dade | 13083 | 3232 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-04-02 04:20:47 | Dade, Georgia, US | |
2022-03-28 | US | North Dakota | Mountrail | 38061 | 3232 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-03-29 04:20:46 | Mountrail, North Dakota, US | |
2022-03-20 | Tonga | 3232 | 2 | 0 | -21.179000000000002 | -175.1982 | 2022-03-21 04:20:50 | Tonga | ||||
2022-03-13 | US | Kansas | Nemaha | 20131 | 3232 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-03-14 04:20:46 | Nemaha, Kansas, US | |
2022-03-12 | US | Kansas | Nemaha | 20131 | 3232 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-03-13 04:20:49 | Nemaha, Kansas, US | |
2022-03-11 | US | North Dakota | McKenzie | 38053 | 3232 | 25 | 0 | 47.74133370000001 | -103.395905 | 2022-03-12 04:20:50 | McKenzie, North Dakota, US | |
2022-03-11 | US | Kansas | Nemaha | 20131 | 3232 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-03-12 04:20:50 | Nemaha, Kansas, US | |
2022-03-10 | US | North Dakota | McKenzie | 38053 | 3232 | 25 | 0 | 47.74133370000001 | -103.395905 | 2022-03-11 04:20:50 | McKenzie, North Dakota, US | |
2022-03-07 | US | Arkansas | Little River | 5081 | 3232 | 89 | 0 | 33.70375665 | -94.23468591 | 2022-03-08 04:20:54 | Little River, Arkansas, US | |
2022-02-27 | US | Missouri | Mississippi | 29133 | 3232 | 55 | 0 | 36.82516239 | -89.29505753 | 2022-02-28 04:21:05 | Mississippi, Missouri, US | |
2022-02-26 | US | Missouri | Mississippi | 29133 | 3232 | 55 | 0 | 36.82516239 | -89.29505753 | 2022-02-27 04:21:04 | Mississippi, Missouri, US | |
2022-02-25 | US | Missouri | Mississippi | 29133 | 3232 | 55 | 0 | 36.82516239 | -89.29505753 | 2022-02-26 04:21:12 | Mississippi, Missouri, US | |
2022-02-23 | US | Ohio | Morgan | 39115 | 3232 | 56 | 0 | 39.62081738 | -81.85308173 | 2022-02-24 04:21:14 | Morgan, Ohio, US | |
2022-02-17 | US | Arkansas | Marion | 5089 | 3232 | 80 | 0 | 36.26844485 | -92.68451899 | 2022-02-18 04:21:04 | Marion, Arkansas, US | |
2022-02-16 | US | Puerto Rico | Anasco | 72011 | 3232 | 0 | 0 | 18.287985 | -67.120611 | 2022-02-17 04:20:56 | Anasco, Puerto Rico, US | |
2022-02-16 | US | Louisiana | Madison | 22065 | 3232 | 58 | 0 | 32.36918118 | -91.23973355 | 2022-02-17 04:20:56 | Madison, Louisiana, US | |
2022-02-01 | US | New York | Schuyler | 36097 | 3232 | 23 | 0 | 42.39184015 | -76.8773299 | 2022-02-02 04:21:09 | Schuyler, New York, US | |
2022-01-31 | US | Colorado | Crowley | 8025 | 3232 | 29 | 0 | 38.32608609 | -103.7844965 | 2022-02-01 04:21:11 | Crowley, Colorado, US | |
2022-01-29 | US | Texas | Tyler | 48457 | 3232 | 75 | 0 | 30.77031716 | -94.37690895 | 2022-01-30 04:21:26 | Tyler, Texas, US | |
2022-01-24 | US | Tennessee | Decatur | 47039 | 3232 | 52 | 0 | 35.60048904 | -88.11043779 | 2022-01-25 04:21:05 | Decatur, Tennessee, US | |
2022-01-20 | US | Alaska | North Slope | 2185 | 3232 | 10 | 0 | 69.31479216 | -153.4836093 | 2022-01-21 04:21:09 | North Slope, Alaska, US | |
2022-01-19 | US | Alaska | North Slope | 2185 | 3232 | 10 | 0 | 69.31479216 | -153.4836093 | 2022-01-20 04:21:07 | North Slope, Alaska, US | |
2022-01-13 | US | Virginia | Nottoway | 51135 | 3232 | 72 | 0 | 37.1435975 | -78.05065922 | 2022-01-14 04:21:54 | Nottoway, Virginia, US | |
2022-01-09 | US | Texas | Freestone | 48161 | 3232 | 75 | 0 | 31.70422788 | -96.15072516 | 2022-01-10 04:22:07 | Freestone, Texas, US | |
2022-01-04 | US | Maine | Knox | 23013 | 3232 | 20 | 0 | 44.11486325 | -69.10529169 | 2022-01-05 04:21:59 | Knox, Maine, US | |
2021-12-28 | US | Indiana | Franklin | 18047 | 3232 | 47 | 0 | 39.4142482 | -85.06062647 | 2021-12-29 03:21:43 | Franklin, Indiana, US | |
2021-12-26 | US | Georgia | Crisp | 13081 | 3232 | 119 | 0 | 31.92289565 | -83.76811843 | 2021-12-27 04:21:58 | Crisp, Georgia, US | |
2021-12-25 | US | Georgia | Crisp | 13081 | 3232 | 119 | 0 | 31.92289565 | -83.76811843 | 2021-12-26 04:21:50 | Crisp, Georgia, US | |
2021-12-24 | US | Georgia | Crisp | 13081 | 3232 | 119 | 0 | 31.92289565 | -83.76811843 | 2021-12-25 04:21:37 | Crisp, Georgia, US | |
2021-12-21 | US | Texas | Lavaca | 48285 | 3232 | 100 | 0 | 29.38508402 | -96.93186692 | 2021-12-22 04:21:54 | Lavaca, Texas, US | |
2021-12-20 | US | Texas | Lavaca | 48285 | 3232 | 100 | 0 | 29.38508402 | -96.93186692 | 2021-12-21 03:21:27 | Lavaca, Texas, US | |
2021-12-13 | US | Alabama | Cherokee | 1019 | 3232 | 64 | 0 | 34.17805983 | -85.60638968 | 2021-12-14 04:22:38 | Cherokee, Alabama, US | |
2021-12-12 | US | Alabama | Cherokee | 1019 | 3232 | 64 | 0 | 34.17805983 | -85.60638968 | 2021-12-13 04:22:02 | Cherokee, Alabama, US | |
2021-12-10 | US | Missouri | Andrew | 29003 | 3232 | 40 | 0 | 39.98492163 | -94.80163024 | 2021-12-11 04:22:45 | Andrew, Missouri, US | |
2021-12-09 | US | Texas | Montague | 48337 | 3232 | 98 | 0 | 33.67521893 | -97.72500958 | 2021-12-10 04:22:28 | Montague, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;