daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
300 rows where confirmed = 2536 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Michigan | Baraga | 26013 | 2536 | 58 | 0 | 46.6720582 | -88.36363591 | 2022-12-30 04:21:04 | Baraga, Michigan, US | |
2022-12-28 | US | Michigan | Baraga | 26013 | 2536 | 58 | 0 | 46.6720582 | -88.36363591 | 2022-12-29 04:21:01 | Baraga, Michigan, US | |
2022-12-27 | US | Michigan | Baraga | 26013 | 2536 | 58 | 0 | 46.6720582 | -88.36363591 | 2022-12-28 04:21:04 | Baraga, Michigan, US | |
2022-12-06 | US | Kansas | Cloud | 20029 | 2536 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-07 04:20:58 | Cloud, Kansas, US | |
2022-12-05 | US | Kansas | Cloud | 20029 | 2536 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-06 04:21:03 | Cloud, Kansas, US | |
2022-12-04 | US | Kansas | Cloud | 20029 | 2536 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-05 04:20:58 | Cloud, Kansas, US | |
2022-12-03 | US | Kansas | Cloud | 20029 | 2536 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-04 04:20:56 | Cloud, Kansas, US | |
2022-12-02 | US | Kansas | Cloud | 20029 | 2536 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-03 04:21:02 | Cloud, Kansas, US | |
2022-12-01 | US | Kansas | Cloud | 20029 | 2536 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-02 04:21:07 | Cloud, Kansas, US | |
2022-11-30 | US | Kansas | Cloud | 20029 | 2536 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-01 04:21:03 | Cloud, Kansas, US | |
2022-10-31 | US | Virginia | Lexington | 51678 | 2536 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-11-01 04:22:36 | Lexington, Virginia, US | |
2022-10-26 | US | Virginia | Northumberland | 51133 | 2536 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-10-27 04:22:01 | Northumberland, Virginia, US | |
2022-10-25 | US | Texas | Franklin | 48159 | 2536 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-10-26 04:22:19 | Franklin, Texas, US | |
2022-10-24 | US | Texas | Franklin | 48159 | 2536 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-10-25 04:21:53 | Franklin, Texas, US | |
2022-10-23 | US | Texas | Franklin | 48159 | 2536 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-10-24 04:22:29 | Franklin, Texas, US | |
2022-10-22 | US | Texas | Franklin | 48159 | 2536 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-10-23 04:22:46 | Franklin, Texas, US | |
2022-10-21 | US | Texas | Franklin | 48159 | 2536 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-10-22 04:22:53 | Franklin, Texas, US | |
2022-10-20 | US | Texas | Franklin | 48159 | 2536 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-10-21 04:22:23 | Franklin, Texas, US | |
2022-10-19 | US | Texas | Franklin | 48159 | 2536 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-10-20 04:22:59 | Franklin, Texas, US | |
2022-10-18 | US | Texas | Franklin | 48159 | 2536 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-10-19 04:22:26 | Franklin, Texas, US | |
2022-10-17 | US | Texas | Franklin | 48159 | 2536 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-10-18 04:22:42 | Franklin, Texas, US | |
2022-09-28 | US | Oklahoma | Latimer | 40077 | 2536 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-29 04:22:34 | Latimer, Oklahoma, US | |
2022-09-27 | US | Oklahoma | Latimer | 40077 | 2536 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-28 04:23:01 | Latimer, Oklahoma, US | |
2022-09-26 | US | South Carolina | McCormick | 45065 | 2536 | 40 | 0 | 33.90161443 | -82.30794338 | 2022-09-27 04:23:01 | McCormick, South Carolina, US | |
2022-09-26 | US | Oklahoma | Latimer | 40077 | 2536 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-27 04:23:01 | Latimer, Oklahoma, US | |
2022-09-25 | US | Washington | Lincoln | 53043 | 2536 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-09-26 04:20:52 | Lincoln, Washington, US | |
2022-09-25 | US | South Carolina | McCormick | 45065 | 2536 | 40 | 0 | 33.90161443 | -82.30794338 | 2022-09-26 04:20:52 | McCormick, South Carolina, US | |
2022-09-25 | US | Oklahoma | Latimer | 40077 | 2536 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-26 04:20:52 | Latimer, Oklahoma, US | |
2022-09-24 | US | Washington | Lincoln | 53043 | 2536 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-09-25 04:23:31 | Lincoln, Washington, US | |
2022-09-24 | US | South Carolina | McCormick | 45065 | 2536 | 40 | 0 | 33.90161443 | -82.30794338 | 2022-09-25 04:23:31 | McCormick, South Carolina, US | |
2022-09-24 | US | Oklahoma | Latimer | 40077 | 2536 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-25 04:23:31 | Latimer, Oklahoma, US | |
2022-09-23 | US | Washington | Lincoln | 53043 | 2536 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-09-24 04:21:40 | Lincoln, Washington, US | |
2022-09-23 | US | South Carolina | McCormick | 45065 | 2536 | 40 | 0 | 33.90161443 | -82.30794338 | 2022-09-24 04:21:40 | McCormick, South Carolina, US | |
2022-09-23 | US | Oklahoma | Latimer | 40077 | 2536 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-24 04:21:40 | Latimer, Oklahoma, US | |
2022-09-22 | US | South Carolina | McCormick | 45065 | 2536 | 40 | 0 | 33.90161443 | -82.30794338 | 2022-09-23 04:23:13 | McCormick, South Carolina, US | |
2022-09-22 | US | Oklahoma | Latimer | 40077 | 2536 | 36 | 0 | 34.87844729 | -95.25215049 | 2022-09-23 04:23:13 | Latimer, Oklahoma, US | |
2022-09-21 | US | South Carolina | McCormick | 45065 | 2536 | 40 | 0 | 33.90161443 | -82.30794338 | 2022-09-22 04:22:56 | McCormick, South Carolina, US | |
2022-09-20 | US | South Carolina | McCormick | 45065 | 2536 | 40 | 0 | 33.90161443 | -82.30794338 | 2022-09-21 04:23:22 | McCormick, South Carolina, US | |
2022-09-20 | US | Arkansas | Cleveland | 5025 | 2536 | 39 | 0 | 33.89723187 | -92.18537045 | 2022-09-21 04:23:22 | Cleveland, Arkansas, US | |
2022-09-05 | US | Nebraska | Phelps | 31137 | 2536 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-09-06 04:21:02 | Phelps, Nebraska, US | |
2022-09-04 | US | Virginia | Essex | 51057 | 2536 | 36 | 0 | 37.93357639 | -76.94230311 | 2022-09-05 04:21:01 | Essex, Virginia, US | |
2022-09-04 | US | Tennessee | Moore | 47127 | 2536 | 40 | 0 | 35.27724699 | -86.36230578 | 2022-09-05 04:21:01 | Moore, Tennessee, US | |
2022-09-04 | US | Nebraska | Phelps | 31137 | 2536 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-09-05 04:21:01 | Phelps, Nebraska, US | |
2022-09-03 | US | Virginia | Essex | 51057 | 2536 | 36 | 0 | 37.93357639 | -76.94230311 | 2022-09-04 04:21:22 | Essex, Virginia, US | |
2022-09-03 | US | Tennessee | Moore | 47127 | 2536 | 40 | 0 | 35.27724699 | -86.36230578 | 2022-09-04 04:21:22 | Moore, Tennessee, US | |
2022-09-03 | US | Nebraska | Phelps | 31137 | 2536 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-09-04 04:21:22 | Phelps, Nebraska, US | |
2022-09-02 | US | Virginia | Essex | 51057 | 2536 | 36 | 0 | 37.93357639 | -76.94230311 | 2022-09-03 04:21:04 | Essex, Virginia, US | |
2022-09-02 | US | Nebraska | Phelps | 31137 | 2536 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-09-03 04:21:04 | Phelps, Nebraska, US | |
2022-09-01 | US | Nebraska | Phelps | 31137 | 2536 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-09-02 04:21:07 | Phelps, Nebraska, US | |
2022-08-31 | US | Texas | Castro | 48069 | 2536 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-09-01 04:21:03 | Castro, Texas, US | |
2022-08-31 | US | Nebraska | Phelps | 31137 | 2536 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-09-01 04:21:03 | Phelps, Nebraska, US | |
2022-08-30 | US | Texas | Parmer | 48369 | 2536 | 53 | 0 | 34.52993409 | -102.7844668 | 2022-08-31 04:20:57 | Parmer, Texas, US | |
2022-08-30 | US | Nebraska | Phelps | 31137 | 2536 | 14 | 0 | 40.51156033 | -99.41461667 | 2022-08-31 04:20:57 | Phelps, Nebraska, US | |
2022-08-29 | US | Texas | Parmer | 48369 | 2536 | 53 | 0 | 34.52993409 | -102.7844668 | 2022-08-30 04:21:03 | Parmer, Texas, US | |
2022-08-29 | US | Texas | La Salle | 48283 | 2536 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-08-30 04:21:03 | La Salle, Texas, US | |
2022-08-29 | US | Idaho | Washington | 16087 | 2536 | 58 | 0 | 44.45275475 | -116.7847688 | 2022-08-30 04:21:03 | Washington, Idaho, US | |
2022-08-23 | US | Iowa | Guthrie | 19077 | 2536 | 47 | 0 | 41.68378965 | -94.50111014 | 2022-08-24 04:20:46 | Guthrie, Iowa, US | |
2022-08-22 | US | Iowa | Guthrie | 19077 | 2536 | 47 | 0 | 41.68378965 | -94.50111014 | 2022-08-23 04:20:56 | Guthrie, Iowa, US | |
2022-08-21 | US | Iowa | Guthrie | 19077 | 2536 | 47 | 0 | 41.68378965 | -94.50111014 | 2022-08-22 04:20:38 | Guthrie, Iowa, US | |
2022-08-20 | US | Iowa | Guthrie | 19077 | 2536 | 47 | 0 | 41.68378965 | -94.50111014 | 2022-08-21 04:20:44 | Guthrie, Iowa, US | |
2022-08-19 | US | Iowa | Guthrie | 19077 | 2536 | 47 | 0 | 41.68378965 | -94.50111014 | 2022-08-20 04:21:01 | Guthrie, Iowa, US | |
2022-08-18 | US | Iowa | Guthrie | 19077 | 2536 | 47 | 0 | 41.68378965 | -94.50111014 | 2022-08-19 04:20:54 | Guthrie, Iowa, US | |
2022-08-18 | US | Idaho | Washington | 16087 | 2536 | 58 | 0 | 44.45275475 | -116.7847688 | 2022-08-19 04:20:54 | Washington, Idaho, US | |
2022-08-17 | US | Iowa | Guthrie | 19077 | 2536 | 47 | 0 | 41.68378965 | -94.50111014 | 2022-08-18 04:21:11 | Guthrie, Iowa, US | |
2022-08-17 | US | Idaho | Washington | 16087 | 2536 | 58 | 0 | 44.45275475 | -116.7847688 | 2022-08-18 04:21:11 | Washington, Idaho, US | |
2022-08-04 | US | Texas | Ochiltree | 48357 | 2536 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-08-05 04:20:52 | Ochiltree, Texas, US | |
2022-07-24 | US | Kentucky | Owen | 21187 | 2536 | 34 | 0 | 38.51679143 | -84.82404619 | 2022-07-25 04:20:51 | Owen, Kentucky, US | |
2022-07-23 | US | Kentucky | Owen | 21187 | 2536 | 34 | 0 | 38.51679143 | -84.82404619 | 2022-07-24 04:20:47 | Owen, Kentucky, US | |
2022-07-22 | US | Kentucky | Owen | 21187 | 2536 | 34 | 0 | 38.51679143 | -84.82404619 | 2022-07-23 04:20:53 | Owen, Kentucky, US | |
2022-07-21 | US | Kentucky | Owen | 21187 | 2536 | 34 | 0 | 38.51679143 | -84.82404619 | 2022-07-22 04:21:15 | Owen, Kentucky, US | |
2022-07-20 | US | Kentucky | Owen | 21187 | 2536 | 34 | 0 | 38.51679143 | -84.82404619 | 2022-07-21 04:21:10 | Owen, Kentucky, US | |
2022-07-19 | US | Kentucky | Owen | 21187 | 2536 | 34 | 0 | 38.51679143 | -84.82404619 | 2022-07-20 04:20:59 | Owen, Kentucky, US | |
2022-07-18 | US | Kentucky | Owen | 21187 | 2536 | 34 | 0 | 38.51679143 | -84.82404619 | 2022-07-19 04:20:58 | Owen, Kentucky, US | |
2022-07-13 | US | Alabama | Bullock | 1011 | 2536 | 54 | 0 | 32.10030533 | -85.71265535 | 2022-07-14 04:20:57 | Bullock, Alabama, US | |
2022-06-16 | US | Montana | Fergus | 30027 | 2536 | 57 | 0 | 47.26331584 | -109.2245206 | 2022-06-17 04:20:56 | Fergus, Montana, US | |
2022-06-15 | US | Montana | Fergus | 30027 | 2536 | 57 | 0 | 47.26331584 | -109.2245206 | 2022-06-16 04:20:55 | Fergus, Montana, US | |
2022-06-14 | US | Montana | Fergus | 30027 | 2536 | 57 | 0 | 47.26331584 | -109.2245206 | 2022-06-15 04:20:54 | Fergus, Montana, US | |
2022-06-13 | US | Montana | Fergus | 30027 | 2536 | 57 | 0 | 47.26331584 | -109.2245206 | 2022-06-14 04:20:52 | Fergus, Montana, US | |
2022-06-12 | US | Montana | Fergus | 30027 | 2536 | 57 | 0 | 47.26331584 | -109.2245206 | 2022-06-13 04:21:14 | Fergus, Montana, US | |
2022-06-11 | US | Montana | Fergus | 30027 | 2536 | 57 | 0 | 47.26331584 | -109.2245206 | 2022-06-12 04:20:53 | Fergus, Montana, US | |
2022-06-10 | US | Montana | Fergus | 30027 | 2536 | 57 | 0 | 47.26331584 | -109.2245206 | 2022-06-11 04:21:01 | Fergus, Montana, US | |
2022-06-09 | US | Washington | Pend Oreille | 53051 | 2536 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-06-10 04:20:55 | Pend Oreille, Washington, US | |
2022-06-08 | US | Washington | Pend Oreille | 53051 | 2536 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-06-09 04:20:54 | Pend Oreille, Washington, US | |
2022-06-07 | US | Washington | Pend Oreille | 53051 | 2536 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-06-08 04:20:55 | Pend Oreille, Washington, US | |
2022-06-06 | US | Washington | Pend Oreille | 53051 | 2536 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-06-07 04:21:08 | Pend Oreille, Washington, US | |
2022-06-05 | US | Washington | Pend Oreille | 53051 | 2536 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-06-06 04:20:57 | Pend Oreille, Washington, US | |
2022-06-04 | US | Washington | Pend Oreille | 53051 | 2536 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-06-05 04:20:55 | Pend Oreille, Washington, US | |
2022-06-03 | US | Washington | Pend Oreille | 53051 | 2536 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-06-04 04:20:58 | Pend Oreille, Washington, US | |
2022-06-01 | US | Texas | Morris | 48343 | 2536 | 73 | 0 | 33.11304005 | -94.73255695 | 2022-06-02 05:20:39 | Morris, Texas, US | |
2022-06-01 | US | Arkansas | Perry | 5105 | 2536 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-06-02 05:20:39 | Perry, Arkansas, US | |
2022-05-31 | US | Iowa | Franklin | 19069 | 2536 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-06-01 04:20:55 | Franklin, Iowa, US | |
2022-05-30 | US | Iowa | Franklin | 19069 | 2536 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-05-31 04:20:51 | Franklin, Iowa, US | |
2022-05-29 | US | Iowa | Franklin | 19069 | 2536 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-05-30 04:20:50 | Franklin, Iowa, US | |
2022-05-29 | US | Arkansas | Perry | 5105 | 2536 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-05-30 04:20:50 | Perry, Arkansas, US | |
2022-05-28 | US | Iowa | Franklin | 19069 | 2536 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-05-29 04:20:53 | Franklin, Iowa, US | |
2022-05-27 | US | Iowa | Franklin | 19069 | 2536 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-05-28 04:21:07 | Franklin, Iowa, US | |
2022-05-26 | US | Iowa | Franklin | 19069 | 2536 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-05-27 04:20:56 | Franklin, Iowa, US | |
2022-05-25 | US | Iowa | Franklin | 19069 | 2536 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-05-26 04:20:50 | Franklin, Iowa, US | |
2022-05-22 | US | Iowa | Franklin | 19069 | 2536 | 42 | 0 | 42.73270384 | -93.26256925 | 2022-05-26 04:20:50 | Franklin, Iowa, US | |
2022-04-25 | US | Minnesota | Yellow Medicine | 27173 | 2536 | 29 | 0 | 44.71710183 | -95.86842453 | 2022-04-26 04:20:51 | Yellow Medicine, Minnesota, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;