daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
361 rows where confirmed = 2080 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-13 | US | Texas | Hamilton | 48193 | 2080 | 36 | 0 | 31.70470573 | -98.11083887 | 2022-12-14 04:21:04 | Hamilton, Texas, US | |
2022-12-12 | US | Texas | Hamilton | 48193 | 2080 | 36 | 0 | 31.70470573 | -98.11083887 | 2022-12-13 04:21:01 | Hamilton, Texas, US | |
2022-12-12 | US | Illinois | Edwards | 17047 | 2080 | 29 | 0 | 38.41353228 | -88.05720863 | 2022-12-13 04:21:01 | Edwards, Illinois, US | |
2022-12-11 | US | Texas | Hamilton | 48193 | 2080 | 36 | 0 | 31.70470573 | -98.11083887 | 2022-12-12 04:21:01 | Hamilton, Texas, US | |
2022-12-10 | US | Texas | Hamilton | 48193 | 2080 | 36 | 0 | 31.70470573 | -98.11083887 | 2022-12-11 04:20:50 | Hamilton, Texas, US | |
2022-12-09 | US | Texas | Hamilton | 48193 | 2080 | 36 | 0 | 31.70470573 | -98.11083887 | 2022-12-10 04:21:02 | Hamilton, Texas, US | |
2022-12-08 | US | Texas | Hamilton | 48193 | 2080 | 36 | 0 | 31.70470573 | -98.11083887 | 2022-12-09 04:21:05 | Hamilton, Texas, US | |
2022-12-07 | US | Texas | Hamilton | 48193 | 2080 | 36 | 0 | 31.70470573 | -98.11083887 | 2022-12-08 04:21:07 | Hamilton, Texas, US | |
2022-11-29 | US | Kansas | Greenwood | 20073 | 2080 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-30 04:21:07 | Greenwood, Kansas, US | |
2022-11-28 | US | Kansas | Greenwood | 20073 | 2080 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-29 04:21:05 | Greenwood, Kansas, US | |
2022-11-27 | US | Kansas | Greenwood | 20073 | 2080 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-28 04:21:02 | Greenwood, Kansas, US | |
2022-11-26 | US | Kansas | Greenwood | 20073 | 2080 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-27 04:21:05 | Greenwood, Kansas, US | |
2022-11-25 | US | Kansas | Greenwood | 20073 | 2080 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-26 04:21:11 | Greenwood, Kansas, US | |
2022-11-24 | US | Kansas | Greenwood | 20073 | 2080 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-25 04:21:06 | Greenwood, Kansas, US | |
2022-11-23 | US | Kansas | Greenwood | 20073 | 2080 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-11-24 04:21:09 | Greenwood, Kansas, US | |
2022-11-22 | US | Minnesota | Mahnomen | 27087 | 2080 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-11-23 04:21:06 | Mahnomen, Minnesota, US | |
2022-11-22 | US | Iowa | Lucas | 19117 | 2080 | 33 | 0 | 41.02958964 | -93.32780803 | 2022-11-23 04:21:06 | Lucas, Iowa, US | |
2022-11-21 | US | New Hampshire | Unassigned | 90033 | 2080 | 5 | 0 | 44.69063265 | 0.0 | 2022-11-22 04:20:47 | Unassigned, New Hampshire, US | |
2022-11-21 | US | Minnesota | Mahnomen | 27087 | 2080 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-11-22 04:20:47 | Mahnomen, Minnesota, US | |
2022-11-21 | US | Iowa | Lucas | 19117 | 2080 | 33 | 0 | 41.02958964 | -93.32780803 | 2022-11-22 04:20:47 | Lucas, Iowa, US | |
2022-11-20 | US | Texas | Winkler | 48495 | 2080 | 35 | 0 | 31.85008651 | -103.0485163 | 2022-11-21 04:21:05 | Winkler, Texas, US | |
2022-11-20 | US | Minnesota | Mahnomen | 27087 | 2080 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-11-21 04:21:05 | Mahnomen, Minnesota, US | |
2022-11-20 | US | Iowa | Lucas | 19117 | 2080 | 33 | 0 | 41.02958964 | -93.32780803 | 2022-11-21 04:21:05 | Lucas, Iowa, US | |
2022-11-19 | US | Texas | Winkler | 48495 | 2080 | 35 | 0 | 31.85008651 | -103.0485163 | 2022-11-20 04:21:08 | Winkler, Texas, US | |
2022-11-19 | US | Minnesota | Mahnomen | 27087 | 2080 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-11-20 04:21:08 | Mahnomen, Minnesota, US | |
2022-11-19 | US | Iowa | Lucas | 19117 | 2080 | 33 | 0 | 41.02958964 | -93.32780803 | 2022-11-20 04:21:08 | Lucas, Iowa, US | |
2022-11-18 | US | Texas | Winkler | 48495 | 2080 | 35 | 0 | 31.85008651 | -103.0485163 | 2022-11-19 04:21:14 | Winkler, Texas, US | |
2022-11-18 | US | Minnesota | Mahnomen | 27087 | 2080 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-11-19 04:21:14 | Mahnomen, Minnesota, US | |
2022-11-18 | US | Iowa | Lucas | 19117 | 2080 | 33 | 0 | 41.02958964 | -93.32780803 | 2022-11-19 04:21:14 | Lucas, Iowa, US | |
2022-11-17 | US | Minnesota | Mahnomen | 27087 | 2080 | 18 | 0 | 47.32557075 | -95.80921485 | 2022-11-18 04:21:15 | Mahnomen, Minnesota, US | |
2022-11-17 | US | Iowa | Lucas | 19117 | 2080 | 33 | 0 | 41.02958964 | -93.32780803 | 2022-11-18 04:21:15 | Lucas, Iowa, US | |
2022-11-16 | US | Iowa | Lucas | 19117 | 2080 | 33 | 0 | 41.02958964 | -93.32780803 | 2022-11-17 04:21:11 | Lucas, Iowa, US | |
2022-11-14 | China | Liaoning | 2080 | 2 | 0 | 41.2956 | 122.6085 | 2022-11-15 04:21:16 | Liaoning, China | |||
2022-11-08 | US | Tennessee | Pickett | 47137 | 2080 | 38 | 0 | 36.55606529 | -85.077633 | 2022-11-09 04:21:22 | Pickett, Tennessee, US | |
2022-09-21 | US | Virginia | Williamsburg | 51830 | 2080 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-22 04:22:56 | Williamsburg, Virginia, US | |
2022-09-20 | US | Virginia | Williamsburg | 51830 | 2080 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-09-21 04:23:22 | Williamsburg, Virginia, US | |
2022-09-06 | US | Kansas | Pratt | 20151 | 2080 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-09-07 04:20:59 | Pratt, Kansas, US | |
2022-09-05 | US | Kansas | Pratt | 20151 | 2080 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-09-06 04:21:02 | Pratt, Kansas, US | |
2022-09-04 | US | Kansas | Pratt | 20151 | 2080 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-09-05 04:21:01 | Pratt, Kansas, US | |
2022-09-03 | US | Kansas | Pratt | 20151 | 2080 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-09-04 04:21:22 | Pratt, Kansas, US | |
2022-09-02 | US | Kansas | Pratt | 20151 | 2080 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-09-03 04:21:04 | Pratt, Kansas, US | |
2022-09-01 | US | Kansas | Pratt | 20151 | 2080 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-09-02 04:21:07 | Pratt, Kansas, US | |
2022-08-31 | US | Kansas | Pratt | 20151 | 2080 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-09-01 04:21:03 | Pratt, Kansas, US | |
2022-08-17 | US | Virginia | Lancaster | 51103 | 2080 | 35 | 0 | 37.71889653 | -76.46400482 | 2022-08-18 04:21:11 | Lancaster, Virginia, US | |
2022-08-14 | US | West Virginia | Calhoun | 54013 | 2080 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-08-15 04:20:59 | Calhoun, West Virginia, US | |
2022-08-13 | US | West Virginia | Calhoun | 54013 | 2080 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-08-14 04:20:55 | Calhoun, West Virginia, US | |
2022-08-12 | US | West Virginia | Calhoun | 54013 | 2080 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-08-13 04:20:52 | Calhoun, West Virginia, US | |
2022-08-02 | US | Kansas | Kingman | 20095 | 2080 | 28 | 0 | 37.55909527 | -98.13638678 | 2022-08-03 04:20:59 | Kingman, Kansas, US | |
2022-08-01 | US | Kansas | Kingman | 20095 | 2080 | 28 | 0 | 37.55909527 | -98.13638678 | 2022-08-02 04:20:53 | Kingman, Kansas, US | |
2022-07-31 | US | Kansas | Kingman | 20095 | 2080 | 28 | 0 | 37.55909527 | -98.13638678 | 2022-08-01 04:21:03 | Kingman, Kansas, US | |
2022-07-30 | US | Kansas | Kingman | 20095 | 2080 | 28 | 0 | 37.55909527 | -98.13638678 | 2022-07-31 04:21:02 | Kingman, Kansas, US | |
2022-07-29 | US | Kansas | Kingman | 20095 | 2080 | 28 | 0 | 37.55909527 | -98.13638678 | 2022-07-30 04:20:42 | Kingman, Kansas, US | |
2022-07-29 | China | Tianjin | 2080 | 3 | 0 | 39.3054 | 117.323 | 2022-07-30 04:20:42 | Tianjin, China | |||
2022-07-28 | US | Kansas | Kingman | 20095 | 2080 | 28 | 0 | 37.55909527 | -98.13638678 | 2022-07-29 04:20:45 | Kingman, Kansas, US | |
2022-07-28 | China | Tianjin | 2080 | 3 | 0 | 39.3054 | 117.323 | 2022-07-29 04:20:45 | Tianjin, China | |||
2022-07-27 | US | Kansas | Kingman | 20095 | 2080 | 28 | 0 | 37.55909527 | -98.13638678 | 2022-07-28 04:20:56 | Kingman, Kansas, US | |
2022-07-26 | US | West Virginia | Pendleton | 54071 | 2080 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-07-27 04:21:04 | Pendleton, West Virginia, US | |
2022-07-18 | US | Colorado | Yuma | 8125 | 2080 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-07-19 04:20:58 | Yuma, Colorado, US | |
2022-07-04 | US | Tennessee | Hancock | 47067 | 2080 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-07-05 04:20:45 | Hancock, Tennessee, US | |
2022-06-30 | US | West Virginia | Tucker | 54093 | 2080 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-07-01 04:21:10 | Tucker, West Virginia, US | |
2022-06-29 | US | West Virginia | Tucker | 54093 | 2080 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-06-30 04:21:01 | Tucker, West Virginia, US | |
2022-06-28 | US | West Virginia | Tucker | 54093 | 2080 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-06-29 04:20:59 | Tucker, West Virginia, US | |
2022-06-18 | US | Puerto Rico | Ceiba | 72037 | 2080 | 0 | 0 | 18.251818 | -65.666416 | 2022-06-19 04:20:51 | Ceiba, Puerto Rico, US | |
2022-06-13 | US | New Mexico | Quay | 35037 | 2080 | 58 | 0 | 35.10403332 | -103.5481727 | 2022-06-14 04:20:52 | Quay, New Mexico, US | |
2022-05-31 | US | Michigan | Baraga | 26013 | 2080 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-06-01 04:20:55 | Baraga, Michigan, US | |
2022-05-30 | US | Michigan | Baraga | 26013 | 2080 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-05-31 04:20:51 | Baraga, Michigan, US | |
2022-05-29 | US | Michigan | Baraga | 26013 | 2080 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-05-30 04:20:50 | Baraga, Michigan, US | |
2022-05-28 | US | Michigan | Baraga | 26013 | 2080 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-05-29 04:20:53 | Baraga, Michigan, US | |
2022-05-27 | US | Michigan | Baraga | 26013 | 2080 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-05-28 04:21:07 | Baraga, Michigan, US | |
2022-05-26 | US | Michigan | Baraga | 26013 | 2080 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-05-27 04:20:56 | Baraga, Michigan, US | |
2022-05-25 | US | Michigan | Baraga | 26013 | 2080 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-05-26 04:20:50 | Baraga, Michigan, US | |
2022-05-22 | US | Michigan | Baraga | 26013 | 2080 | 54 | 0 | 46.6720582 | -88.36363591 | 2022-05-26 04:20:50 | Baraga, Michigan, US | |
2022-05-21 | US | West Virginia | Pleasants | 54073 | 2080 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-05-22 04:20:52 | Pleasants, West Virginia, US | |
2022-05-20 | US | West Virginia | Pleasants | 54073 | 2080 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-05-21 04:20:58 | Pleasants, West Virginia, US | |
2022-05-19 | US | West Virginia | Pleasants | 54073 | 2080 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-05-20 04:20:57 | Pleasants, West Virginia, US | |
2022-05-19 | US | Montana | Carbon | 30009 | 2080 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-05-20 04:20:57 | Carbon, Montana, US | |
2022-05-18 | US | West Virginia | Pocahontas | 54075 | 2080 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-05-19 04:20:54 | Pocahontas, West Virginia, US | |
2022-05-18 | US | Montana | Carbon | 30009 | 2080 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-05-19 04:20:54 | Carbon, Montana, US | |
2022-05-17 | US | Montana | Carbon | 30009 | 2080 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-05-18 04:20:50 | Carbon, Montana, US | |
2022-05-16 | US | Montana | Carbon | 30009 | 2080 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-05-17 04:20:59 | Carbon, Montana, US | |
2022-05-15 | US | Montana | Carbon | 30009 | 2080 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-05-16 04:20:47 | Carbon, Montana, US | |
2022-05-14 | US | Montana | Carbon | 30009 | 2080 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-05-15 04:20:53 | Carbon, Montana, US | |
2022-05-13 | US | Montana | Carbon | 30009 | 2080 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-05-14 04:20:48 | Carbon, Montana, US | |
2022-05-03 | US | Iowa | Keokuk | 19107 | 2080 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-05-04 04:20:59 | Keokuk, Iowa, US | |
2022-05-02 | US | Iowa | Keokuk | 19107 | 2080 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-05-03 04:21:00 | Keokuk, Iowa, US | |
2022-05-01 | US | Iowa | Keokuk | 19107 | 2080 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-05-02 04:21:10 | Keokuk, Iowa, US | |
2022-04-30 | US | Texas | Clay | 48077 | 2080 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-05-01 04:20:57 | Clay, Texas, US | |
2022-04-30 | US | Iowa | Keokuk | 19107 | 2080 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-05-01 04:20:57 | Keokuk, Iowa, US | |
2022-04-29 | US | Texas | Clay | 48077 | 2080 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-04-30 04:21:05 | Clay, Texas, US | |
2022-04-29 | US | Iowa | Keokuk | 19107 | 2080 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-04-30 04:21:05 | Keokuk, Iowa, US | |
2022-04-28 | US | Texas | Clay | 48077 | 2080 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-04-29 04:20:59 | Clay, Texas, US | |
2022-04-28 | US | Iowa | Keokuk | 19107 | 2080 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-04-29 04:20:59 | Keokuk, Iowa, US | |
2022-04-27 | US | Texas | Clay | 48077 | 2080 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-04-28 04:20:47 | Clay, Texas, US | |
2022-04-27 | US | Iowa | Keokuk | 19107 | 2080 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-04-28 04:20:47 | Keokuk, Iowa, US | |
2022-04-26 | US | Texas | Clay | 48077 | 2080 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-04-27 04:20:52 | Clay, Texas, US | |
2022-04-21 | US | Minnesota | Lake | 27075 | 2080 | 28 | 0 | 47.64270764 | -91.44557998 | 2022-04-22 04:20:45 | Lake, Minnesota, US | |
2022-04-20 | US | Minnesota | Lake | 27075 | 2080 | 28 | 0 | 47.64270764 | -91.44557998 | 2022-04-21 04:20:46 | Lake, Minnesota, US | |
2022-04-18 | US | South Carolina | Allendale | 45005 | 2080 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-04-19 04:21:00 | Allendale, South Carolina, US | |
2022-04-17 | US | South Carolina | Allendale | 45005 | 2080 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-04-18 04:21:12 | Allendale, South Carolina, US | |
2022-04-16 | US | South Carolina | Allendale | 45005 | 2080 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-04-17 04:20:59 | Allendale, South Carolina, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;