daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
385 rows where confirmed = 1658 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 | Idaho | Caribou | 16029 | 1658 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-30 04:21:04 | Caribou, Idaho, US | |
2022-12-28 | US | Idaho | Caribou | 16029 | 1658 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-12-29 04:21:01 | Caribou, Idaho, US | |
2022-12-27 | US | Kansas | Phillips | 20147 | 1658 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-28 04:21:04 | Phillips, Kansas, US | |
2022-12-26 | US | Kansas | Phillips | 20147 | 1658 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-27 04:21:07 | Phillips, Kansas, US | |
2022-12-25 | US | Kansas | Phillips | 20147 | 1658 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-26 04:21:06 | Phillips, Kansas, US | |
2022-12-24 | US | Kansas | Phillips | 20147 | 1658 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-25 04:21:04 | Phillips, Kansas, US | |
2022-12-23 | US | Kansas | Phillips | 20147 | 1658 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-24 04:21:02 | Phillips, Kansas, US | |
2022-12-22 | US | Kansas | Phillips | 20147 | 1658 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-23 04:21:04 | Phillips, Kansas, US | |
2022-12-21 | US | Kansas | Phillips | 20147 | 1658 | 32 | 0 | 39.78465501 | -99.34668865 | 2022-12-22 04:20:56 | Phillips, Kansas, US | |
2022-12-20 | US | South Dakota | Tripp | 46123 | 1658 | 28 | 0 | 43.34459388 | -99.8854891 | 2022-12-21 04:21:03 | Tripp, South Dakota, US | |
2022-12-19 | US | South Dakota | Tripp | 46123 | 1658 | 28 | 0 | 43.34459388 | -99.8854891 | 2022-12-20 04:21:04 | Tripp, South Dakota, US | |
2022-12-18 | US | South Dakota | Tripp | 46123 | 1658 | 28 | 0 | 43.34459388 | -99.8854891 | 2022-12-19 04:21:03 | Tripp, South Dakota, US | |
2022-12-17 | US | South Dakota | Tripp | 46123 | 1658 | 28 | 0 | 43.34459388 | -99.8854891 | 2022-12-18 04:21:03 | Tripp, South Dakota, US | |
2022-12-16 | US | South Dakota | Tripp | 46123 | 1658 | 28 | 0 | 43.34459388 | -99.8854891 | 2022-12-17 04:21:04 | Tripp, South Dakota, US | |
2022-12-15 | US | South Dakota | Tripp | 46123 | 1658 | 28 | 0 | 43.34459388 | -99.8854891 | 2022-12-16 04:21:01 | Tripp, South Dakota, US | |
2022-12-14 | US | South Dakota | Tripp | 46123 | 1658 | 28 | 0 | 43.34459388 | -99.8854891 | 2022-12-15 04:20:58 | Tripp, South Dakota, US | |
2022-10-25 | US | Indiana | Ohio | 18115 | 1658 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-26 04:22:19 | Ohio, Indiana, US | |
2022-10-24 | US | Indiana | Ohio | 18115 | 1658 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-25 04:21:53 | Ohio, Indiana, US | |
2022-10-23 | US | Indiana | Ohio | 18115 | 1658 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-24 04:22:29 | Ohio, Indiana, US | |
2022-10-22 | US | Indiana | Ohio | 18115 | 1658 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-23 04:22:46 | Ohio, Indiana, US | |
2022-10-21 | US | Indiana | Ohio | 18115 | 1658 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-22 04:22:53 | Ohio, Indiana, US | |
2022-10-20 | US | Indiana | Ohio | 18115 | 1658 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-21 04:22:23 | Ohio, Indiana, US | |
2022-10-19 | US | Indiana | Ohio | 18115 | 1658 | 19 | 0 | 38.955305 | -84.96515993 | 2022-10-20 04:22:59 | Ohio, Indiana, US | |
2022-10-16 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-17 04:20:31 | Carson, Texas, US | |
2022-10-16 | US | Kentucky | Ballard | 21007 | 1658 | 36 | 0 | 37.05842757 | -88.99427697 | 2022-10-17 04:20:31 | Ballard, Kentucky, US | |
2022-10-15 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-16 04:22:39 | Carson, Texas, US | |
2022-10-15 | US | Kentucky | Ballard | 21007 | 1658 | 36 | 0 | 37.05842757 | -88.99427697 | 2022-10-16 04:22:39 | Ballard, Kentucky, US | |
2022-10-14 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-15 04:22:00 | Carson, Texas, US | |
2022-10-14 | US | Kentucky | Ballard | 21007 | 1658 | 36 | 0 | 37.05842757 | -88.99427697 | 2022-10-15 04:22:00 | Ballard, Kentucky, US | |
2022-10-13 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-14 04:22:28 | Carson, Texas, US | |
2022-10-13 | US | Kentucky | Ballard | 21007 | 1658 | 36 | 0 | 37.05842757 | -88.99427697 | 2022-10-14 04:22:28 | Ballard, Kentucky, US | |
2022-10-12 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-13 04:22:39 | Carson, Texas, US | |
2022-10-12 | US | Kentucky | Ballard | 21007 | 1658 | 36 | 0 | 37.05842757 | -88.99427697 | 2022-10-13 04:22:39 | Ballard, Kentucky, US | |
2022-10-11 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-12 04:22:51 | Carson, Texas, US | |
2022-10-11 | US | Kentucky | Ballard | 21007 | 1658 | 36 | 0 | 37.05842757 | -88.99427697 | 2022-10-12 04:22:51 | Ballard, Kentucky, US | |
2022-10-10 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-11 04:23:05 | Carson, Texas, US | |
2022-10-10 | US | Kentucky | Ballard | 21007 | 1658 | 36 | 0 | 37.05842757 | -88.99427697 | 2022-10-11 04:23:05 | Ballard, Kentucky, US | |
2022-10-09 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-10 04:22:32 | Carson, Texas, US | |
2022-10-08 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-09 04:21:16 | Carson, Texas, US | |
2022-10-07 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-08 04:22:56 | Carson, Texas, US | |
2022-10-06 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-07 04:23:08 | Carson, Texas, US | |
2022-10-06 | US | Missouri | Dade | 29057 | 1658 | 43 | 0 | 37.431814 | -93.8503345 | 2022-10-07 04:23:08 | Dade, Missouri, US | |
2022-10-05 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-06 04:21:22 | Carson, Texas, US | |
2022-10-05 | US | Missouri | Dade | 29057 | 1658 | 43 | 0 | 37.431814 | -93.8503345 | 2022-10-06 04:21:22 | Dade, Missouri, US | |
2022-10-04 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-05 04:23:06 | Carson, Texas, US | |
2022-10-04 | US | Missouri | Dade | 29057 | 1658 | 43 | 0 | 37.431814 | -93.8503345 | 2022-10-05 04:23:06 | Dade, Missouri, US | |
2022-10-04 | US | Idaho | Lemhi | 16059 | 1658 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-10-05 04:23:06 | Lemhi, Idaho, US | |
2022-10-03 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-04 04:22:55 | Carson, Texas, US | |
2022-10-03 | US | Missouri | Dade | 29057 | 1658 | 43 | 0 | 37.431814 | -93.8503345 | 2022-10-04 04:22:55 | Dade, Missouri, US | |
2022-10-03 | US | Idaho | Lemhi | 16059 | 1658 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-10-04 04:22:55 | Lemhi, Idaho, US | |
2022-10-02 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-03 04:23:11 | Carson, Texas, US | |
2022-10-02 | US | Missouri | Dade | 29057 | 1658 | 43 | 0 | 37.431814 | -93.8503345 | 2022-10-03 04:23:11 | Dade, Missouri, US | |
2022-10-02 | US | Idaho | Lemhi | 16059 | 1658 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-10-03 04:23:11 | Lemhi, Idaho, US | |
2022-10-01 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-02 04:21:23 | Carson, Texas, US | |
2022-10-01 | US | Missouri | Dade | 29057 | 1658 | 43 | 0 | 37.431814 | -93.8503345 | 2022-10-02 04:21:23 | Dade, Missouri, US | |
2022-10-01 | US | Idaho | Lemhi | 16059 | 1658 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-10-02 04:21:23 | Lemhi, Idaho, US | |
2022-09-30 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-10-01 04:23:01 | Carson, Texas, US | |
2022-09-30 | US | Missouri | Dade | 29057 | 1658 | 43 | 0 | 37.431814 | -93.8503345 | 2022-10-01 04:23:01 | Dade, Missouri, US | |
2022-09-30 | US | Idaho | Lemhi | 16059 | 1658 | 28 | 0 | 44.9438088 | -113.9309747 | 2022-10-01 04:23:01 | Lemhi, Idaho, US | |
2022-09-29 | US | Texas | Carson | 48065 | 1658 | 37 | 0 | 35.40365929 | -101.3542669 | 2022-09-30 04:23:09 | Carson, Texas, US | |
2022-09-27 | US | Virginia | Cumberland | 51049 | 1658 | 29 | 0 | 37.51328851 | -78.24398086 | 2022-09-28 04:23:01 | Cumberland, Virginia, US | |
2022-09-12 | US | Colorado | Huerfano | 8055 | 1658 | 38 | 0 | 37.68473101 | -104.9612585 | 2022-09-13 04:20:57 | Huerfano, Colorado, US | |
2022-08-23 | US | South Dakota | Hamlin | 46057 | 1658 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-08-24 04:20:46 | Hamlin, South Dakota, US | |
2022-08-23 | US | Illinois | Gallatin | 17059 | 1658 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-08-24 04:20:46 | Gallatin, Illinois, US | |
2022-08-22 | US | South Dakota | Hamlin | 46057 | 1658 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-08-23 04:20:56 | Hamlin, South Dakota, US | |
2022-08-21 | US | South Dakota | Hamlin | 46057 | 1658 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-08-22 04:20:38 | Hamlin, South Dakota, US | |
2022-08-20 | US | South Dakota | Hamlin | 46057 | 1658 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-08-21 04:20:44 | Hamlin, South Dakota, US | |
2022-08-19 | US | South Dakota | Hamlin | 46057 | 1658 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-08-20 04:21:01 | Hamlin, South Dakota, US | |
2022-08-18 | US | South Dakota | Hamlin | 46057 | 1658 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-08-19 04:20:54 | Hamlin, South Dakota, US | |
2022-08-17 | US | South Dakota | Hamlin | 46057 | 1658 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-08-18 04:21:11 | Hamlin, South Dakota, US | |
2022-08-08 | US | Arkansas | Montgomery | 5097 | 1658 | 56 | 0 | 34.53704874 | -93.65824478 | 2022-08-09 04:20:34 | Montgomery, Arkansas, US | |
2022-07-26 | US | Texas | Bailey | 48017 | 1658 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-07-27 04:21:04 | Bailey, Texas, US | |
2022-07-25 | US | Texas | Bailey | 48017 | 1658 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-07-26 04:20:58 | Bailey, Texas, US | |
2022-07-24 | US | Texas | Bailey | 48017 | 1658 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-07-25 04:20:51 | Bailey, Texas, US | |
2022-07-16 | China | Guangxi | 1658 | 2 | 0 | 23.8298 | 108.7881 | 2022-07-17 04:21:15 | Guangxi, China | |||
2022-06-28 | US | Washington | San Juan | 53055 | 1658 | 2 | 0 | 48.60182783 | -122.96745 | 2022-06-29 04:20:59 | San Juan, Washington, US | |
2022-06-27 | US | Washington | San Juan | 53055 | 1658 | 2 | 0 | 48.60182783 | -122.96745 | 2022-06-28 04:20:58 | San Juan, Washington, US | |
2022-06-24 | US | North Dakota | Bottineau | 38009 | 1658 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-06-25 04:20:57 | Bottineau, North Dakota, US | |
2022-05-09 | China | Liaoning | 1658 | 2 | 0 | 41.2956 | 122.6085 | 2022-05-10 04:20:50 | Liaoning, China | |||
2022-05-01 | US | Minnesota | Wilkin | 27167 | 1658 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-05-02 04:21:10 | Wilkin, Minnesota, US | |
2022-04-30 | US | Minnesota | Wilkin | 27167 | 1658 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-05-01 04:20:57 | Wilkin, Minnesota, US | |
2022-04-29 | US | Minnesota | Wilkin | 27167 | 1658 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-04-30 04:21:05 | Wilkin, Minnesota, US | |
2022-03-24 | US | Oregon | Grant | 41023 | 1658 | 20 | 0 | 44.49024544 | -119.0068631 | 2022-03-25 04:20:46 | Grant, Oregon, US | |
2022-03-13 | China | Hebei | 1658 | 7 | 0 | 37.8957 | 114.9042 | 2022-03-14 04:20:46 | Hebei, China | |||
2022-03-10 | US | Puerto Rico | Arroyo | 72015 | 1658 | 0 | 0 | 17.998457000000005 | -66.056546 | 2022-03-11 04:20:50 | Arroyo, Puerto Rico, US | |
2022-03-08 | US | Texas | Marion | 48315 | 1658 | 59 | 0 | 32.79868409 | -94.35661230000001 | 2022-03-09 04:20:59 | Marion, Texas, US | |
2022-02-08 | US | Missouri | Sullivan | 29211 | 1658 | 19 | 0 | 40.2099105 | -93.11150106 | 2022-02-09 04:21:04 | Sullivan, Missouri, US | |
2022-01-16 | US | Wisconsin | Pepin | 55091 | 1658 | 16 | 0 | 44.58307413 | -91.99949611 | 2022-01-17 04:21:08 | Pepin, Wisconsin, US | |
2022-01-15 | US | Wisconsin | Pepin | 55091 | 1658 | 16 | 0 | 44.58307413 | -91.99949611 | 2022-01-16 04:21:12 | Pepin, Wisconsin, US | |
2022-01-14 | US | Wisconsin | Pepin | 55091 | 1658 | 16 | 0 | 44.58307413 | -91.99949611 | 2022-01-15 04:21:07 | Pepin, Wisconsin, US | |
2022-01-13 | US | Texas | Archer | 48009 | 1658 | 24 | 0 | 33.61569967 | -98.68754589 | 2022-01-14 04:21:54 | Archer, Texas, US | |
2022-01-05 | US | Indiana | Martin | 18101 | 1658 | 20 | 0 | 38.7099921 | -86.80373186 | 2022-01-06 04:22:09 | Martin, Indiana, US | |
2022-01-04 | US | Iowa | Howard | 19089 | 1658 | 24 | 0 | 43.35671042 | -92.31702714 | 2022-01-05 04:21:59 | Howard, Iowa, US | |
2022-01-03 | US | Missouri | Howard | 29089 | 1658 | 19 | 0 | 39.1435761 | -92.69756691 | 2022-01-04 04:22:17 | Howard, Missouri, US | |
2022-01-03 | US | Iowa | Howard | 19089 | 1658 | 24 | 0 | 43.35671042 | -92.31702714 | 2022-01-04 04:22:17 | Howard, Iowa, US | |
2022-01-02 | US | Missouri | Howard | 29089 | 1658 | 19 | 0 | 39.1435761 | -92.69756691 | 2022-01-03 02:22:25 | Howard, Missouri, US | |
2022-01-02 | US | Iowa | Howard | 19089 | 1658 | 24 | 0 | 43.35671042 | -92.31702714 | 2022-01-03 02:22:25 | Howard, Iowa, US | |
2022-01-01 | US | Missouri | Howard | 29089 | 1658 | 19 | 0 | 39.1435761 | -92.69756691 | 2022-01-02 04:20:52 | Howard, Missouri, US | |
2022-01-01 | US | Iowa | Howard | 19089 | 1658 | 24 | 0 | 43.35671042 | -92.31702714 | 2022-01-02 04:20:52 | Howard, Iowa, US | |
2021-12-31 | US | Missouri | Howard | 29089 | 1658 | 19 | 0 | 39.1435761 | -92.69756691 | 2022-01-01 04:22:14 | Howard, Missouri, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;