daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
347 rows where confirmed = 1972 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-11-30 | US | Arkansas | Newton | 5101 | 1972 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-12-01 04:21:03 | Newton, Arkansas, US | |
2022-11-29 | US | Texas | Coleman | 48083 | 1972 | 74 | 0 | 31.76736834 | -99.45240766 | 2022-11-30 04:21:07 | Coleman, Texas, US | |
2022-11-29 | US | Arkansas | Newton | 5101 | 1972 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-11-30 04:21:07 | Newton, Arkansas, US | |
2022-11-28 | US | Texas | Coleman | 48083 | 1972 | 74 | 0 | 31.76736834 | -99.45240766 | 2022-11-29 04:21:05 | Coleman, Texas, US | |
2022-11-15 | US | Illinois | Pulaski | 17153 | 1972 | 24 | 0 | 37.22631423 | -89.13085001 | 2022-11-16 04:21:09 | Pulaski, Illinois, US | |
2022-11-09 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-10 04:21:16 | Coal, Oklahoma, US | |
2022-11-08 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-09 04:21:22 | Coal, Oklahoma, US | |
2022-11-07 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-08 04:21:21 | Coal, Oklahoma, US | |
2022-11-06 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-07 04:21:26 | Coal, Oklahoma, US | |
2022-11-05 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-06 04:21:24 | Coal, Oklahoma, US | |
2022-11-04 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-05 04:21:52 | Coal, Oklahoma, US | |
2022-11-03 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-04 04:22:11 | Coal, Oklahoma, US | |
2022-11-02 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-03 04:22:05 | Coal, Oklahoma, US | |
2022-11-01 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-02 04:22:09 | Coal, Oklahoma, US | |
2022-10-31 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-11-01 04:22:36 | Coal, Oklahoma, US | |
2022-10-30 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-10-31 04:21:36 | Coal, Oklahoma, US | |
2022-10-29 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-10-30 04:22:14 | Coal, Oklahoma, US | |
2022-10-28 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-10-29 04:21:13 | Coal, Oklahoma, US | |
2022-10-27 | US | Oklahoma | Coal | 40029 | 1972 | 25 | 0 | 34.58840127 | -96.29798747 | 2022-10-28 04:22:31 | Coal, Oklahoma, US | |
2022-08-15 | US | Colorado | Rio Blanco | 8103 | 1972 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-08-16 04:20:58 | Rio Blanco, Colorado, US | |
2022-07-22 | US | Texas | Crosby | 48107 | 1972 | 45 | 0 | 33.61431553 | -101.3000364 | 2022-07-23 04:20:53 | Crosby, Texas, US | |
2022-07-04 | US | Alabama | Greene | 1063 | 1972 | 51 | 0 | 32.85504247 | -87.95684022 | 2022-07-05 04:20:45 | Greene, Alabama, US | |
2022-06-23 | US | Louisiana | St. Helena | 22091 | 1972 | 24 | 0 | 30.82210324 | -90.71013176 | 2022-06-24 04:20:58 | St. Helena, Louisiana, US | |
2022-06-15 | US | Texas | Floyd | 48153 | 1972 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-06-16 04:20:55 | Floyd, Texas, US | |
2022-06-14 | US | Texas | Floyd | 48153 | 1972 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-06-15 04:20:54 | Floyd, Texas, US | |
2022-06-14 | US | Colorado | Lake | 8065 | 1972 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-06-15 04:20:54 | Lake, Colorado, US | |
2022-06-13 | US | Texas | Floyd | 48153 | 1972 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-06-14 04:20:52 | Floyd, Texas, US | |
2022-06-12 | US | Texas | Floyd | 48153 | 1972 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-06-13 04:21:14 | Floyd, Texas, US | |
2022-06-04 | US | Arkansas | Prairie | 5117 | 1972 | 41 | 0 | 34.83624419 | -91.55162157 | 2022-06-05 04:20:55 | Prairie, Arkansas, US | |
2022-06-03 | US | Arkansas | Prairie | 5117 | 1972 | 41 | 0 | 34.83624419 | -91.55162157 | 2022-06-04 04:20:58 | Prairie, Arkansas, US | |
2022-05-19 | US | Texas | Hamilton | 48193 | 1972 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-05-20 04:20:57 | Hamilton, Texas, US | |
2022-05-18 | US | Texas | Hamilton | 48193 | 1972 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-05-19 04:20:54 | Hamilton, Texas, US | |
2022-05-17 | US | Texas | Hamilton | 48193 | 1972 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-05-18 04:20:50 | Hamilton, Texas, US | |
2022-05-16 | US | Texas | Hamilton | 48193 | 1972 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-05-17 04:20:59 | Hamilton, Texas, US | |
2022-05-15 | US | Texas | Hamilton | 48193 | 1972 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-05-16 04:20:47 | Hamilton, Texas, US | |
2022-05-14 | US | Texas | Hamilton | 48193 | 1972 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-05-15 04:20:53 | Hamilton, Texas, US | |
2022-05-13 | US | Texas | Hamilton | 48193 | 1972 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-05-14 04:20:48 | Hamilton, Texas, US | |
2022-05-10 | US | North Dakota | Benson | 38005 | 1972 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-05-11 04:20:48 | Benson, North Dakota, US | |
2022-05-01 | US | West Virginia | Pendleton | 54071 | 1972 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-05-02 04:21:10 | Pendleton, West Virginia, US | |
2022-04-30 | US | West Virginia | Pendleton | 54071 | 1972 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-05-01 04:20:57 | Pendleton, West Virginia, US | |
2022-04-29 | US | West Virginia | Pendleton | 54071 | 1972 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-04-30 04:21:05 | Pendleton, West Virginia, US | |
2022-04-26 | US | Wisconsin | Pepin | 55091 | 1972 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-04-27 04:20:52 | Pepin, Wisconsin, US | |
2022-04-25 | US | Wisconsin | Pepin | 55091 | 1972 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-04-26 04:20:51 | Pepin, Wisconsin, US | |
2022-04-21 | US | Kansas | Clay | 20027 | 1972 | 35 | 0 | 39.34948772 | -97.16518128 | 2022-04-22 04:20:45 | Clay, Kansas, US | |
2022-04-20 | US | Kansas | Clay | 20027 | 1972 | 35 | 0 | 39.34948772 | -97.16518128 | 2022-04-21 04:20:46 | Clay, Kansas, US | |
2022-04-19 | US | Kansas | Clay | 20027 | 1972 | 35 | 0 | 39.34948772 | -97.16518128 | 2022-04-20 04:20:45 | Clay, Kansas, US | |
2022-04-18 | US | Kansas | Clay | 20027 | 1972 | 35 | 0 | 39.34948772 | -97.16518128 | 2022-04-19 04:21:00 | Clay, Kansas, US | |
2022-04-17 | US | Kansas | Clay | 20027 | 1972 | 35 | 0 | 39.34948772 | -97.16518128 | 2022-04-18 04:21:12 | Clay, Kansas, US | |
2022-04-16 | US | Kansas | Clay | 20027 | 1972 | 35 | 0 | 39.34948772 | -97.16518128 | 2022-04-17 04:20:59 | Clay, Kansas, US | |
2022-04-15 | US | Kansas | Clay | 20027 | 1972 | 35 | 0 | 39.34948772 | -97.16518128 | 2022-04-16 04:20:48 | Clay, Kansas, US | |
2022-04-07 | US | North Dakota | Pembina | 38067 | 1972 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-04-08 04:20:48 | Pembina, North Dakota, US | |
2022-04-05 | China | Hebei | 1972 | 7 | 0 | 37.8957 | 114.9042 | 2022-04-06 04:20:49 | Hebei, China | |||
2022-04-03 | US | Georgia | Taylor | 13269 | 1972 | 53 | 0 | 32.55792548 | -84.25077141 | 2022-04-04 04:20:51 | Taylor, Georgia, US | |
2022-04-02 | US | Georgia | Taylor | 13269 | 1972 | 53 | 0 | 32.55792548 | -84.25077141 | 2022-04-03 04:20:48 | Taylor, Georgia, US | |
2022-04-01 | US | Georgia | Taylor | 13269 | 1972 | 53 | 0 | 32.55792548 | -84.25077141 | 2022-04-02 04:20:47 | Taylor, Georgia, US | |
2022-03-31 | US | Georgia | Taylor | 13269 | 1972 | 53 | 0 | 32.55792548 | -84.25077141 | 2022-04-01 04:20:28 | Taylor, Georgia, US | |
2022-03-05 | China | Yunnan | 1972 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-06 04:20:49 | Yunnan, China | |||
2022-03-02 | US | New Mexico | Quay | 35037 | 1972 | 48 | 0 | 35.10403332 | -103.54817270000001 | 2022-03-03 04:21:01 | Quay, New Mexico, US | |
2022-03-01 | US | New Mexico | Quay | 35037 | 1972 | 48 | 0 | 35.10403332 | -103.54817270000001 | 2022-03-02 04:21:07 | Quay, New Mexico, US | |
2022-02-27 | US | Minnesota | Pipestone | 27117 | 1972 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-02-28 04:21:05 | Pipestone, Minnesota, US | |
2022-02-26 | US | Minnesota | Pipestone | 27117 | 1972 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-02-27 04:21:04 | Pipestone, Minnesota, US | |
2022-02-25 | US | Minnesota | Pipestone | 27117 | 1972 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-02-26 04:21:12 | Pipestone, Minnesota, US | |
2022-02-25 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-26 04:21:12 | Glades, Florida, US | |
2022-02-24 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-25 04:21:11 | Glades, Florida, US | |
2022-02-23 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-24 04:21:14 | Glades, Florida, US | |
2022-02-22 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-23 04:21:09 | Glades, Florida, US | |
2022-02-21 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-22 04:21:01 | Glades, Florida, US | |
2022-02-20 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-21 04:21:05 | Glades, Florida, US | |
2022-02-19 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-20 04:21:00 | Glades, Florida, US | |
2022-02-18 | US | Florida | Glades | 12043 | 1972 | 35 | 0 | 26.95635849 | -81.18996211 | 2022-02-19 04:21:11 | Glades, Florida, US | |
2022-02-16 | US | Kentucky | Crittenden | 21055 | 1972 | 41 | 0 | 37.35839237 | -88.08826090000002 | 2022-02-17 04:20:56 | Crittenden, Kentucky, US | |
2022-02-14 | US | Minnesota | Lake | 27075 | 1972 | 27 | 0 | 47.64270764 | -91.44557998 | 2022-02-15 04:21:09 | Lake, Minnesota, US | |
2022-02-13 | US | Montana | Carbon | 30009 | 1972 | 27 | 0 | 45.22850116 | -109.0274047 | 2022-02-14 04:20:51 | Carbon, Montana, US | |
2022-02-12 | US | Montana | Carbon | 30009 | 1972 | 27 | 0 | 45.22850116 | -109.0274047 | 2022-02-13 04:21:00 | Carbon, Montana, US | |
2022-02-11 | US | Montana | Carbon | 30009 | 1972 | 27 | 0 | 45.22850116 | -109.0274047 | 2022-02-12 04:21:06 | Carbon, Montana, US | |
2022-02-11 | US | Idaho | Boundary | 16021 | 1972 | 56 | 0 | 48.76684761 | -116.4630179 | 2022-02-12 04:21:06 | Boundary, Idaho, US | |
2022-02-09 | US | Virginia | Madison | 51113 | 1972 | 30 | 0 | 38.41531222 | -78.28220331 | 2022-02-10 04:21:14 | Madison, Virginia, US | |
2022-02-08 | US | Iowa | Howard | 19089 | 1972 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-09 04:21:04 | Howard, Iowa, US | |
2022-02-07 | US | Iowa | Howard | 19089 | 1972 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-08 04:21:15 | Howard, Iowa, US | |
2022-02-06 | US | Iowa | Howard | 19089 | 1972 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-07 04:21:05 | Howard, Iowa, US | |
2022-02-05 | US | Iowa | Howard | 19089 | 1972 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-06 04:21:00 | Howard, Iowa, US | |
2022-02-05 | US | Arkansas | Searcy | 5129 | 1972 | 38 | 0 | 35.9109364 | -92.69936482 | 2022-02-06 04:21:00 | Searcy, Arkansas, US | |
2022-02-04 | US | Iowa | Howard | 19089 | 1972 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-05 04:21:05 | Howard, Iowa, US | |
2022-02-03 | US | Kentucky | Wolfe | 21237 | 1972 | 17 | 0 | 37.73941626 | -83.49303612 | 2022-02-04 04:21:10 | Wolfe, Kentucky, US | |
2022-02-03 | US | Iowa | Howard | 19089 | 1972 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-04 04:21:10 | Howard, Iowa, US | |
2022-02-02 | US | Iowa | Howard | 19089 | 1972 | 30 | 0 | 43.35671042 | -92.31702714 | 2022-02-03 04:21:21 | Howard, Iowa, US | |
2022-01-25 | US | Georgia | Seminole | 13253 | 1972 | 27 | 0 | 30.93464824 | -84.86823924 | 2022-01-26 04:21:07 | Seminole, Georgia, US | |
2022-01-24 | US | Missouri | DeKalb | 29063 | 1972 | 40 | 0 | 39.89201062 | -94.40476508 | 2022-01-25 04:21:05 | DeKalb, Missouri, US | |
2022-01-13 | US | Virginia | Lexington | 51678 | 1972 | 38 | 0 | 37.78258621 | -79.44262866 | 2022-01-14 04:21:54 | Lexington, Virginia, US | |
2022-01-13 | US | Georgia | Dooly | 13093 | 1972 | 62 | 0 | 32.15630737 | -83.79746561 | 2022-01-14 04:21:54 | Dooly, Georgia, US | |
2022-01-12 | US | Georgia | Towns | 13281 | 1972 | 90 | 0 | 34.91369188 | -83.74107459999998 | 2022-01-13 08:00:09 | Towns, Georgia, US | |
2022-01-02 | US | Kansas | Marshall | 20117 | 1972 | 36 | 0 | 39.78359669 | -96.52278974 | 2022-01-03 02:22:25 | Marshall, Kansas, US | |
2022-01-01 | US | Kansas | Marshall | 20117 | 1972 | 36 | 0 | 39.78359669 | -96.52278974 | 2022-01-02 04:20:52 | Marshall, Kansas, US | |
2021-12-31 | US | Kansas | Marshall | 20117 | 1972 | 36 | 0 | 39.78359669 | -96.52278974 | 2022-01-01 04:22:14 | Marshall, Kansas, US | |
2021-12-30 | US | Kansas | Marshall | 20117 | 1972 | 36 | 0 | 39.78359669 | -96.52278974 | 2021-12-31 04:21:50 | Marshall, Kansas, US | |
2021-12-30 | US | Colorado | Bent | 8011 | 1972 | 44 | 0 | 37.95474293 | -103.0720195 | 2021-12-31 04:21:50 | Bent, Colorado, US | |
2021-12-29 | US | Kansas | Marshall | 20117 | 1972 | 36 | 0 | 39.78359669 | -96.52278974 | 2021-12-30 04:21:25 | Marshall, Kansas, US | |
2021-12-26 | US | Colorado | Park | 8093 | 1972 | 16 | 0 | 39.120926000000004 | -105.7182065 | 2021-12-27 04:21:58 | Park, Colorado, US | |
2021-12-20 | US | Kentucky | Bath | 21011 | 1972 | 34 | 0 | 38.14735938 | -83.74588932 | 2021-12-21 03:21:27 | Bath, Kentucky, US | |
2021-12-18 | US | Missouri | Bollinger | 29017 | 1972 | 34 | 0 | 37.32449052 | -90.02725304 | 2021-12-19 04:21:11 | Bollinger, Missouri, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;