daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
321 rows where confirmed = 2581 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-26 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-27 04:21:07 | Iron, Missouri, US | |
2022-12-25 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-26 04:21:06 | Iron, Missouri, US | |
2022-12-24 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-25 04:21:04 | Iron, Missouri, US | |
2022-12-23 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-24 04:21:02 | Iron, Missouri, US | |
2022-12-22 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-23 04:21:04 | Iron, Missouri, US | |
2022-12-21 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-22 04:20:56 | Iron, Missouri, US | |
2022-12-20 | US | Missouri | Iron | 29093 | 2581 | 48 | 0 | 37.55487945 | -90.7735296 | 2022-12-21 04:21:03 | Iron, Missouri, US | |
2022-12-20 | US | Kansas | Cloud | 20029 | 2581 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-21 04:21:03 | Cloud, Kansas, US | |
2022-12-19 | US | Kansas | Cloud | 20029 | 2581 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-20 04:21:04 | Cloud, Kansas, US | |
2022-12-18 | US | Kansas | Cloud | 20029 | 2581 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-19 04:21:03 | Cloud, Kansas, US | |
2022-12-17 | US | Kansas | Cloud | 20029 | 2581 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-18 04:21:03 | Cloud, Kansas, US | |
2022-12-16 | US | Kansas | Cloud | 20029 | 2581 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-17 04:21:04 | Cloud, Kansas, US | |
2022-12-15 | US | Kansas | Cloud | 20029 | 2581 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-16 04:21:01 | Cloud, Kansas, US | |
2022-12-14 | US | Kansas | Cloud | 20029 | 2581 | 48 | 0 | 39.48028352 | -97.64925343 | 2022-12-15 04:20:58 | Cloud, Kansas, US | |
2022-12-13 | US | Texas | Swisher | 48437 | 2581 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-14 04:21:04 | Swisher, Texas, US | |
2022-12-12 | US | Texas | Swisher | 48437 | 2581 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-13 04:21:01 | Swisher, Texas, US | |
2022-12-11 | US | Texas | Swisher | 48437 | 2581 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-12 04:21:01 | Swisher, Texas, US | |
2022-12-10 | US | Texas | Swisher | 48437 | 2581 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-11 04:20:50 | Swisher, Texas, US | |
2022-12-09 | US | Texas | Swisher | 48437 | 2581 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-10 04:21:02 | Swisher, Texas, US | |
2022-12-08 | US | Virginia | Northumberland | 51133 | 2581 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-12-09 04:21:05 | Northumberland, Virginia, US | |
2022-12-08 | US | Texas | Swisher | 48437 | 2581 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-09 04:21:05 | Swisher, Texas, US | |
2022-12-07 | US | Texas | Swisher | 48437 | 2581 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-08 04:21:07 | Swisher, Texas, US | |
2022-12-07 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-08 04:21:07 | Macon, Georgia, US | |
2022-12-06 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-07 04:20:58 | Macon, Georgia, US | |
2022-12-05 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-06 04:21:03 | Macon, Georgia, US | |
2022-12-04 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-05 04:20:58 | Macon, Georgia, US | |
2022-12-03 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-04 04:20:56 | Macon, Georgia, US | |
2022-12-02 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-03 04:21:02 | Macon, Georgia, US | |
2022-12-01 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-02 04:21:07 | Macon, Georgia, US | |
2022-11-30 | US | Georgia | Macon | 13193 | 2581 | 53 | 0 | 32.35207048 | -84.04234127 | 2022-12-01 04:21:03 | Macon, Georgia, US | |
2022-11-16 | US | Arkansas | Cleveland | 5025 | 2581 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-17 04:21:11 | Cleveland, Arkansas, US | |
2022-11-15 | US | Arkansas | Cleveland | 5025 | 2581 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-16 04:21:09 | Cleveland, Arkansas, US | |
2022-11-14 | US | Arkansas | Cleveland | 5025 | 2581 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-15 04:21:16 | Cleveland, Arkansas, US | |
2022-11-13 | US | Arkansas | Cleveland | 5025 | 2581 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-11-14 04:21:09 | Cleveland, Arkansas, US | |
2022-10-18 | US | West Virginia | Tyler | 54095 | 2581 | 33 | 0 | 39.46811972 | -80.88772676 | 2022-10-19 04:22:26 | Tyler, West Virginia, US | |
2022-10-17 | US | West Virginia | Tyler | 54095 | 2581 | 33 | 0 | 39.46811972 | -80.88772676 | 2022-10-18 04:22:42 | Tyler, West Virginia, US | |
2022-10-16 | US | Tennessee | Moore | 47127 | 2581 | 41 | 0 | 35.27724699 | -86.36230578 | 2022-10-17 04:20:31 | Moore, Tennessee, US | |
2022-10-15 | US | Tennessee | Moore | 47127 | 2581 | 41 | 0 | 35.27724699 | -86.36230578 | 2022-10-16 04:22:39 | Moore, Tennessee, US | |
2022-10-14 | US | Tennessee | Moore | 47127 | 2581 | 41 | 0 | 35.27724699 | -86.36230578 | 2022-10-15 04:22:00 | Moore, Tennessee, US | |
2022-10-13 | US | Tennessee | Moore | 47127 | 2581 | 41 | 0 | 35.27724699 | -86.36230578 | 2022-10-14 04:22:28 | Moore, Tennessee, US | |
2022-10-09 | US | Washington | Lincoln | 53043 | 2581 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-10-10 04:22:32 | Lincoln, Washington, US | |
2022-10-08 | US | Washington | Lincoln | 53043 | 2581 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-10-09 04:21:16 | Lincoln, Washington, US | |
2022-10-08 | US | Arkansas | Nevada | 5099 | 2581 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-10-09 04:21:16 | Nevada, Arkansas, US | |
2022-10-07 | US | Washington | Lincoln | 53043 | 2581 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-10-08 04:22:56 | Lincoln, Washington, US | |
2022-10-07 | US | Arkansas | Nevada | 5099 | 2581 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-10-08 04:22:56 | Nevada, Arkansas, US | |
2022-10-06 | US | Arkansas | Nevada | 5099 | 2581 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-10-07 04:23:08 | Nevada, Arkansas, US | |
2022-09-22 | US | Montana | Dawson | 30021 | 2581 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-09-23 04:23:13 | Dawson, Montana, US | |
2022-09-21 | US | Montana | Dawson | 30021 | 2581 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-09-22 04:22:56 | Dawson, Montana, US | |
2022-09-20 | US | Montana | Dawson | 30021 | 2581 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-09-21 04:23:22 | Dawson, Montana, US | |
2022-09-19 | US | Montana | Dawson | 30021 | 2581 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-09-20 04:22:48 | Dawson, Montana, US | |
2022-09-18 | US | Montana | Dawson | 30021 | 2581 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-09-19 04:21:49 | Dawson, Montana, US | |
2022-09-17 | US | Montana | Dawson | 30021 | 2581 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-09-18 04:22:50 | Dawson, Montana, US | |
2022-09-16 | US | Montana | Dawson | 30021 | 2581 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-09-17 04:20:19 | Dawson, Montana, US | |
2022-08-25 | US | Tennessee | Perry | 47135 | 2581 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-08-26 04:21:02 | Perry, Tennessee, US | |
2022-08-19 | US | Puerto Rico | Maunabo | 72095 | 2581 | 0 | 0 | 18.017889 | -65.922235 | 2022-08-20 04:21:01 | Maunabo, Puerto Rico, US | |
2022-08-11 | US | Missouri | Wayne | 29223 | 2581 | 54 | 0 | 37.11303869 | -90.46001416 | 2022-08-12 04:20:54 | Wayne, Missouri, US | |
2022-08-10 | US | Missouri | Wayne | 29223 | 2581 | 54 | 0 | 37.11303869 | -90.46001416 | 2022-08-11 04:20:49 | Wayne, Missouri, US | |
2022-08-10 | US | Illinois | Brown | 17009 | 2581 | 16 | 0 | 39.96209138 | -90.75068024 | 2022-08-11 04:20:49 | Brown, Illinois, US | |
2022-08-09 | US | Missouri | Wayne | 29223 | 2581 | 54 | 0 | 37.11303869 | -90.46001416 | 2022-08-10 04:20:57 | Wayne, Missouri, US | |
2022-08-08 | US | Missouri | Wayne | 29223 | 2581 | 54 | 0 | 37.11303869 | -90.46001416 | 2022-08-09 04:20:34 | Wayne, Missouri, US | |
2022-08-07 | US | Missouri | Wayne | 29223 | 2581 | 54 | 0 | 37.11303869 | -90.46001416 | 2022-08-08 04:21:08 | Wayne, Missouri, US | |
2022-08-06 | US | Missouri | Wayne | 29223 | 2581 | 54 | 0 | 37.11303869 | -90.46001416 | 2022-08-07 04:20:54 | Wayne, Missouri, US | |
2022-08-05 | US | Missouri | Wayne | 29223 | 2581 | 54 | 0 | 37.11303869 | -90.46001416 | 2022-08-06 04:20:56 | Wayne, Missouri, US | |
2022-08-03 | US | Arkansas | Scott | 5127 | 2581 | 44 | 0 | 34.85588887 | -94.0632176 | 2022-08-04 04:20:58 | Scott, Arkansas, US | |
2022-07-19 | US | Virginia | Poquoson | 51735 | 2581 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-07-20 04:20:59 | Poquoson, Virginia, US | |
2022-07-12 | US | Iowa | Mitchell | 19131 | 2581 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-07-13 04:20:58 | Mitchell, Iowa, US | |
2022-07-11 | US | Iowa | Mitchell | 19131 | 2581 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-07-12 04:20:51 | Mitchell, Iowa, US | |
2022-07-10 | US | Iowa | Mitchell | 19131 | 2581 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-07-11 04:20:46 | Mitchell, Iowa, US | |
2022-07-09 | US | Iowa | Mitchell | 19131 | 2581 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-07-10 04:20:54 | Mitchell, Iowa, US | |
2022-07-08 | US | Iowa | Mitchell | 19131 | 2581 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-07-09 04:20:59 | Mitchell, Iowa, US | |
2022-07-07 | US | Iowa | Mitchell | 19131 | 2581 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-07-08 04:20:56 | Mitchell, Iowa, US | |
2022-07-06 | US | Iowa | Mitchell | 19131 | 2581 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-07-07 04:20:55 | Mitchell, Iowa, US | |
2022-07-05 | US | Texas | Morris | 48343 | 2581 | 73 | 0 | 33.11304005 | -94.73255695 | 2022-07-06 04:20:58 | Morris, Texas, US | |
2022-06-27 | US | Louisiana | East Carroll | 22035 | 2581 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-06-28 04:20:58 | East Carroll, Louisiana, US | |
2022-06-26 | US | Arkansas | Perry | 5105 | 2581 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-06-27 04:21:00 | Perry, Arkansas, US | |
2022-06-14 | US | Kansas | Marshall | 20117 | 2581 | 44 | 0 | 39.78359669 | -96.52278974 | 2022-06-15 04:20:54 | Marshall, Kansas, US | |
2022-06-13 | US | Kansas | Marshall | 20117 | 2581 | 44 | 0 | 39.78359669 | -96.52278974 | 2022-06-14 04:20:52 | Marshall, Kansas, US | |
2022-06-12 | US | Kansas | Marshall | 20117 | 2581 | 44 | 0 | 39.78359669 | -96.52278974 | 2022-06-13 04:21:14 | Marshall, Kansas, US | |
2022-06-11 | US | Kansas | Marshall | 20117 | 2581 | 44 | 0 | 39.78359669 | -96.52278974 | 2022-06-12 04:20:53 | Marshall, Kansas, US | |
2022-06-10 | US | Kansas | Marshall | 20117 | 2581 | 44 | 0 | 39.78359669 | -96.52278974 | 2022-06-11 04:21:01 | Marshall, Kansas, US | |
2022-06-09 | US | Kansas | Marshall | 20117 | 2581 | 44 | 0 | 39.78359669 | -96.52278974 | 2022-06-10 04:20:55 | Marshall, Kansas, US | |
2022-06-08 | US | Kansas | Marshall | 20117 | 2581 | 44 | 0 | 39.78359669 | -96.52278974 | 2022-06-09 04:20:54 | Marshall, Kansas, US | |
2022-05-23 | US | Virginia | Galax | 51640 | 2581 | 78 | 0 | 36.66601852 | -80.91703124 | 2022-05-24 04:20:57 | Galax, Virginia, US | |
2022-05-20 | US | Colorado | Bent | 8011 | 2581 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-05-21 04:20:58 | Bent, Colorado, US | |
2022-05-16 | US | Minnesota | Yellow Medicine | 27173 | 2581 | 29 | 0 | 44.71710183 | -95.86842453 | 2022-05-17 04:20:59 | Yellow Medicine, Minnesota, US | |
2022-05-12 | US | Puerto Rico | Florida | 72054 | 2581 | 0 | 0 | 18.373715 | -66.560488 | 2022-05-13 04:20:51 | Florida, Puerto Rico, US | |
2022-05-05 | US | Indiana | Newton | 18111 | 2581 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-05-06 04:21:00 | Newton, Indiana, US | |
2022-05-04 | US | Indiana | Newton | 18111 | 2581 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-05-05 04:20:55 | Newton, Indiana, US | |
2022-04-24 | US | Alabama | Sumter | 1119 | 2581 | 51 | 0 | 32.59117397 | -88.19916205 | 2022-04-25 04:20:56 | Sumter, Alabama, US | |
2022-04-23 | US | Alabama | Sumter | 1119 | 2581 | 51 | 0 | 32.59117397 | -88.19916205 | 2022-04-24 04:20:56 | Sumter, Alabama, US | |
2022-04-22 | US | Alabama | Sumter | 1119 | 2581 | 51 | 0 | 32.59117397 | -88.19916205 | 2022-04-23 04:20:50 | Sumter, Alabama, US | |
2022-04-21 | US | Alabama | Sumter | 1119 | 2581 | 51 | 0 | 32.59117397 | -88.19916205 | 2022-04-22 04:20:45 | Sumter, Alabama, US | |
2022-04-20 | US | Oklahoma | Hughes | 40063 | 2581 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-04-21 04:20:46 | Hughes, Oklahoma, US | |
2022-04-19 | US | Oklahoma | Hughes | 40063 | 2581 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-04-20 04:20:45 | Hughes, Oklahoma, US | |
2022-04-18 | US | Oklahoma | Hughes | 40063 | 2581 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-04-19 04:21:00 | Hughes, Oklahoma, US | |
2022-04-17 | US | Oklahoma | Hughes | 40063 | 2581 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-04-18 04:21:12 | Hughes, Oklahoma, US | |
2022-04-16 | US | Oklahoma | Hughes | 40063 | 2581 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-04-17 04:20:59 | Hughes, Oklahoma, US | |
2022-04-15 | US | Oklahoma | Hughes | 40063 | 2581 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-04-16 04:20:48 | Hughes, Oklahoma, US | |
2022-04-14 | US | Oklahoma | Hughes | 40063 | 2581 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-04-15 04:20:57 | Hughes, Oklahoma, US | |
2022-03-18 | US | Puerto Rico | Comerio | 72045 | 2581 | 0 | 0 | 18.224687 | -66.221622 | 2022-03-19 04:20:47 | Comerio, Puerto Rico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;