daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
331 rows where confirmed = 1581 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Iowa 33
- Missouri 31
- Georgia 24
- Texas 19
- Virginia 19
- Kansas 15
- Louisiana 15
- Minnesota 15
- Tennessee 13
- North Carolina 12
- Illinois 11
- Arkansas 10
- Puerto Rico 9
- Wisconsin 9
- Alabama 8
- Kentucky 8
- West Virginia 8
- Montana 7
- New York 7
- South Dakota 7
- Florida 6
- Colorado 5
- Idaho 5
- Michigan 5
- South Carolina 5
- Indiana 3
- Mississippi 3
- North Dakota 3
- Oklahoma 3
- New Hampshire 2
- …
country_or_region 1
- US · 331 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-08-31 | US | Puerto Rico | Vieques | 72147 | 1581 | 0 | 0 | 18.123276 | -65.440971 | 2022-09-01 04:21:03 | Vieques, Puerto Rico, US | |
2022-08-18 | US | Idaho | Caribou | 16029 | 1581 | 32 | 0 | 42.77149116 | -111.5597683 | 2022-08-19 04:20:54 | Caribou, Idaho, US | |
2022-08-17 | US | Idaho | Caribou | 16029 | 1581 | 32 | 0 | 42.77149116 | -111.5597683 | 2022-08-18 04:21:11 | Caribou, Idaho, US | |
2022-08-02 | US | Kansas | Morris | 20127 | 1581 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-08-03 04:20:59 | Morris, Kansas, US | |
2022-08-01 | US | Kansas | Morris | 20127 | 1581 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-08-02 04:20:53 | Morris, Kansas, US | |
2022-07-31 | US | Kansas | Morris | 20127 | 1581 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-08-01 04:21:03 | Morris, Kansas, US | |
2022-07-30 | US | Kansas | Morris | 20127 | 1581 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-31 04:21:02 | Morris, Kansas, US | |
2022-07-29 | US | Kansas | Morris | 20127 | 1581 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-30 04:20:42 | Morris, Kansas, US | |
2022-07-28 | US | Kansas | Morris | 20127 | 1581 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-29 04:20:45 | Morris, Kansas, US | |
2022-07-27 | US | Kansas | Morris | 20127 | 1581 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-07-28 04:20:56 | Morris, Kansas, US | |
2022-07-21 | US | Texas | Lynn | 48305 | 1581 | 38 | 0 | 33.17657705 | -101.8162849 | 2022-07-22 04:21:15 | Lynn, Texas, US | |
2022-07-12 | US | Iowa | Decatur | 19053 | 1581 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-07-13 04:20:58 | Decatur, Iowa, US | |
2022-07-11 | US | Iowa | Decatur | 19053 | 1581 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-07-12 04:20:51 | Decatur, Iowa, US | |
2022-07-10 | US | Iowa | Decatur | 19053 | 1581 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-07-11 04:20:46 | Decatur, Iowa, US | |
2022-07-09 | US | Iowa | Decatur | 19053 | 1581 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-07-10 04:20:54 | Decatur, Iowa, US | |
2022-07-08 | US | Iowa | Decatur | 19053 | 1581 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-07-09 04:20:59 | Decatur, Iowa, US | |
2022-07-07 | US | Iowa | Decatur | 19053 | 1581 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-07-08 04:20:56 | Decatur, Iowa, US | |
2022-07-06 | US | Iowa | Decatur | 19053 | 1581 | 26 | 0 | 40.73742757 | -93.78645949 | 2022-07-07 04:20:55 | Decatur, Iowa, US | |
2022-05-17 | US | Georgia | Hancock | 13141 | 1581 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-05-18 04:20:50 | Hancock, Georgia, US | |
2022-05-16 | US | Georgia | Hancock | 13141 | 1581 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-05-17 04:20:59 | Hancock, Georgia, US | |
2022-05-15 | US | Georgia | Hancock | 13141 | 1581 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-05-16 04:20:47 | Hancock, Georgia, US | |
2022-05-14 | US | Georgia | Hancock | 13141 | 1581 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-05-15 04:20:53 | Hancock, Georgia, US | |
2022-05-13 | US | Georgia | Hancock | 13141 | 1581 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-05-14 04:20:48 | Hancock, Georgia, US | |
2022-05-12 | US | Georgia | Hancock | 13141 | 1581 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-05-13 04:20:51 | Hancock, Georgia, US | |
2022-05-11 | US | Georgia | Hancock | 13141 | 1581 | 90 | 0 | 33.2721566 | -82.99766919 | 2022-05-12 04:20:54 | Hancock, Georgia, US | |
2022-03-22 | US | Missouri | Clark | 29045 | 1581 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-22 23:20:51 | Clark, Missouri, US | |
2022-03-20 | US | Missouri | Clark | 29045 | 1581 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-21 04:20:50 | Clark, Missouri, US | |
2022-03-19 | US | Missouri | Clark | 29045 | 1581 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-20 04:20:45 | Clark, Missouri, US | |
2022-03-18 | US | Missouri | Clark | 29045 | 1581 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-19 04:20:47 | Clark, Missouri, US | |
2022-03-17 | US | Missouri | Clark | 29045 | 1581 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-18 04:20:55 | Clark, Missouri, US | |
2022-03-16 | US | Missouri | Clark | 29045 | 1581 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-17 04:20:56 | Clark, Missouri, US | |
2022-03-15 | US | Iowa | Adair | 19001 | 1581 | 50 | 0 | 41.33075609 | -94.47105874 | 2022-03-16 04:20:50 | Adair, Iowa, US | |
2022-03-15 | US | Missouri | Clark | 29045 | 1581 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-16 04:20:50 | Clark, Missouri, US | |
2022-03-14 | US | Iowa | Adair | 19001 | 1581 | 50 | 0 | 41.33075609 | -94.47105874 | 2022-03-15 04:20:47 | Adair, Iowa, US | |
2022-03-14 | US | Missouri | Clark | 29045 | 1581 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-15 04:20:47 | Clark, Missouri, US | |
2022-03-13 | US | Iowa | Adair | 19001 | 1581 | 50 | 0 | 41.33075609 | -94.47105874 | 2022-03-14 04:20:46 | Adair, Iowa, US | |
2022-03-13 | US | Missouri | Clark | 29045 | 1581 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-14 04:20:46 | Clark, Missouri, US | |
2022-03-12 | US | Iowa | Adair | 19001 | 1581 | 50 | 0 | 41.33075609 | -94.47105874 | 2022-03-13 04:20:49 | Adair, Iowa, US | |
2022-03-12 | US | Missouri | Clark | 29045 | 1581 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-13 04:20:49 | Clark, Missouri, US | |
2022-03-11 | US | Iowa | Adair | 19001 | 1581 | 50 | 0 | 41.33075609 | -94.47105874 | 2022-03-12 04:20:50 | Adair, Iowa, US | |
2022-03-11 | US | Missouri | Clark | 29045 | 1581 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-12 04:20:50 | Clark, Missouri, US | |
2022-03-10 | US | Iowa | Adair | 19001 | 1581 | 50 | 0 | 41.33075609 | -94.47105874 | 2022-03-11 04:20:50 | Adair, Iowa, US | |
2022-03-10 | US | Missouri | Clark | 29045 | 1581 | 32 | 0 | 40.41040752 | -91.73661677 | 2022-03-11 04:20:50 | Clark, Missouri, US | |
2022-03-09 | US | Iowa | Adair | 19001 | 1581 | 50 | 0 | 41.33075609 | -94.47105874 | 2022-03-10 04:20:48 | Adair, Iowa, US | |
2022-02-27 | US | Missouri | Shannon | 29203 | 1581 | 35 | 0 | 37.15772072 | -91.40190382 | 2022-02-28 04:21:05 | Shannon, Missouri, US | |
2022-02-26 | US | Missouri | Shannon | 29203 | 1581 | 35 | 0 | 37.15772072 | -91.40190382 | 2022-02-27 04:21:04 | Shannon, Missouri, US | |
2022-02-25 | US | Missouri | Shannon | 29203 | 1581 | 35 | 0 | 37.15772072 | -91.40190382 | 2022-02-26 04:21:12 | Shannon, Missouri, US | |
2022-02-24 | US | Missouri | Maries | 29125 | 1581 | 33 | 0 | 38.16193985 | -91.92249662 | 2022-02-25 04:21:11 | Maries, Missouri, US | |
2022-02-24 | US | Missouri | Shannon | 29203 | 1581 | 35 | 0 | 37.15772072 | -91.40190382 | 2022-02-25 04:21:11 | Shannon, Missouri, US | |
2022-02-23 | US | Missouri | Shannon | 29203 | 1581 | 34 | 0 | 37.15772072 | -91.40190382 | 2022-02-24 04:21:14 | Shannon, Missouri, US | |
2022-02-16 | US | Georgia | Lincoln | 13181 | 1581 | 35 | 0 | 33.79201475 | -82.45024131 | 2022-02-17 04:20:56 | Lincoln, Georgia, US | |
2022-02-14 | US | Georgia | Lincoln | 13181 | 1581 | 35 | 0 | 33.79201475 | -82.45024131 | 2022-02-15 04:21:09 | Lincoln, Georgia, US | |
2022-02-14 | US | Kansas | Wabaunsee | 20197 | 1581 | 22 | 0 | 38.95471985 | -96.20350509 | 2022-02-15 04:21:09 | Wabaunsee, Kansas, US | |
2022-02-13 | US | Kansas | Wabaunsee | 20197 | 1581 | 22 | 0 | 38.95471985 | -96.20350509 | 2022-02-14 04:20:51 | Wabaunsee, Kansas, US | |
2022-02-12 | US | Kansas | Wabaunsee | 20197 | 1581 | 22 | 0 | 38.95471985 | -96.20350509 | 2022-02-13 04:21:00 | Wabaunsee, Kansas, US | |
2022-02-11 | US | Kansas | Wabaunsee | 20197 | 1581 | 22 | 0 | 38.95471985 | -96.20350509 | 2022-02-12 04:21:06 | Wabaunsee, Kansas, US | |
2022-02-10 | US | Kansas | Wabaunsee | 20197 | 1581 | 22 | 0 | 38.95471985 | -96.20350509 | 2022-02-11 04:21:09 | Wabaunsee, Kansas, US | |
2022-02-09 | US | Kansas | Wabaunsee | 20197 | 1581 | 22 | 0 | 38.95471985 | -96.20350509 | 2022-02-10 04:21:14 | Wabaunsee, Kansas, US | |
2022-02-08 | US | Kansas | Wabaunsee | 20197 | 1581 | 22 | 0 | 38.95471985 | -96.20350509 | 2022-02-09 04:21:04 | Wabaunsee, Kansas, US | |
2022-02-07 | US | Kansas | Wabaunsee | 20197 | 1581 | 22 | 0 | 38.95471985 | -96.20350509 | 2022-02-08 04:21:15 | Wabaunsee, Kansas, US | |
2022-02-02 | US | Virginia | Williamsburg | 51830 | 1581 | 13 | 0 | 37.28131268 | -76.70905141 | 2022-02-03 04:21:21 | Williamsburg, Virginia, US | |
2022-02-01 | US | Puerto Rico | Arroyo | 72015 | 1581 | 0 | 0 | 17.998457000000005 | -66.056546 | 2022-02-02 04:21:09 | Arroyo, Puerto Rico, US | |
2022-01-29 | US | Missouri | Ozark | 29153 | 1581 | 48 | 0 | 36.64916339 | -92.44459066 | 2022-01-30 04:21:26 | Ozark, Missouri, US | |
2022-01-20 | US | Nebraska | Wayne | 31179 | 1581 | 7 | 0 | 42.20934475 | -97.11926964 | 2022-01-21 04:21:09 | Wayne, Nebraska, US | |
2022-01-15 | US | Tennessee | Hancock | 47067 | 1581 | 29 | 0 | 36.52692871 | -83.22375847 | 2022-01-16 04:21:12 | Hancock, Tennessee, US | |
2022-01-14 | US | Missouri | St. Clair | 29185 | 1581 | 29 | 0 | 38.03699437 | -93.77631447 | 2022-01-15 04:21:07 | St. Clair, Missouri, US | |
2022-01-06 | US | South Carolina | McCormick | 45065 | 1581 | 31 | 0 | 33.90161443 | -82.30794338 | 2022-01-07 04:22:09 | McCormick, South Carolina, US | |
2022-01-06 | US | Washington | Lincoln | 53043 | 1581 | 26 | 0 | 47.57705241 | -118.41943880000001 | 2022-01-07 04:22:09 | Lincoln, Washington, US | |
2022-01-02 | US | Texas | Franklin | 48159 | 1581 | 37 | 0 | 33.17653242 | -95.21917243 | 2022-01-03 02:22:25 | Franklin, Texas, US | |
2021-12-26 | US | Georgia | Johnson | 13167 | 1581 | 64 | 0 | 32.70211082 | -82.66166794 | 2021-12-27 04:21:58 | Johnson, Georgia, US | |
2021-12-25 | US | Georgia | Johnson | 13167 | 1581 | 64 | 0 | 32.70211082 | -82.66166794 | 2021-12-26 04:21:50 | Johnson, Georgia, US | |
2021-12-24 | US | Georgia | Johnson | 13167 | 1581 | 64 | 0 | 32.70211082 | -82.66166794 | 2021-12-25 04:21:37 | Johnson, Georgia, US | |
2021-12-19 | US | Virginia | Nelson | 51125 | 1581 | 22 | 0 | 37.78790447 | -78.88498513 | 2021-12-20 04:21:43 | Nelson, Virginia, US | |
2021-12-18 | US | Virginia | Nelson | 51125 | 1581 | 22 | 0 | 37.78790447 | -78.88498513 | 2021-12-19 04:21:11 | Nelson, Virginia, US | |
2021-12-17 | US | Virginia | Nelson | 51125 | 1581 | 22 | 0 | 37.78790447 | -78.88498513 | 2021-12-18 02:22:20 | Nelson, Virginia, US | |
2021-12-10 | US | Kentucky | Owen | 21187 | 1581 | 28 | 0 | 38.51679143 | -84.82404619 | 2021-12-11 04:22:45 | Owen, Kentucky, US | |
2021-12-10 | US | Missouri | Gentry | 29075 | 1581 | 28 | 0 | 40.21097916 | -94.40944419 | 2021-12-11 04:22:45 | Gentry, Missouri, US | |
2021-12-05 | US | Virginia | Sussex | 51183 | 1581 | 29 | 0 | 36.92432914 | -77.25791182 | 2021-12-06 04:22:34 | Sussex, Virginia, US | |
2021-12-04 | US | Virginia | Sussex | 51183 | 1581 | 29 | 0 | 36.92432914 | -77.25791182 | 2021-12-05 04:22:25 | Sussex, Virginia, US | |
2021-12-03 | US | Puerto Rico | Camuy | 72027 | 1581 | 0 | 0 | 18.418578 | -66.860206 | 2021-12-04 04:22:18 | Camuy, Puerto Rico, US | |
2021-12-03 | US | Virginia | Sussex | 51183 | 1581 | 29 | 0 | 36.92432914 | -77.25791182 | 2021-12-04 04:22:18 | Sussex, Virginia, US | |
2021-12-02 | US | Montana | Beaverhead | 30001 | 1581 | 22 | 0 | 45.13434354 | -112.89846940000001 | 2021-12-03 04:23:05 | Beaverhead, Montana, US | |
2021-12-01 | US | Tennessee | Clay | 47027 | 1581 | 37 | 0 | 36.55151008 | -85.53930419 | 2021-12-02 04:22:37 | Clay, Tennessee, US | |
2021-11-27 | US | Arkansas | Perry | 5105 | 1581 | 22 | 0 | 34.945915299999996 | -92.94372564 | 2021-11-28 04:22:43 | Perry, Arkansas, US | |
2021-11-17 | US | Utah | Unassigned | 90049 | 1581 | 3 | 0 | 41.72330587 | 0.0 | 2021-11-18 04:21:33 | Unassigned, Utah, US | |
2021-11-15 | US | Georgia | Atkinson | 13003 | 1581 | 37 | 0 | 31.29633502 | -82.87545866 | 2021-11-16 04:21:10 | Atkinson, Georgia, US | |
2021-11-15 | US | Minnesota | Swift | 27151 | 1581 | 20 | 0 | 45.2829032 | -95.68264092 | 2021-11-16 04:21:10 | Swift, Minnesota, US | |
2021-11-08 | US | South Dakota | Roberts | 46109 | 1581 | 43 | 0 | 45.62975048 | -96.94672673 | 2021-11-09 04:21:36 | Roberts, South Dakota, US | |
2021-11-01 | US | Colorado | Archuleta | 8007 | 1581 | 5 | 0 | 37.19474156 | -107.04768670000001 | 2021-11-02 04:22:03 | Archuleta, Colorado, US | |
2021-11-01 | US | Colorado | Rio Grande | 8105 | 1581 | 25 | 0 | 37.5836865 | -106.3847838 | 2021-11-02 04:22:03 | Rio Grande, Colorado, US | |
2021-10-29 | US | Texas | Clay | 48077 | 1581 | 23 | 0 | 33.78686685 | -98.20771198 | 2021-10-30 04:22:03 | Clay, Texas, US | |
2021-10-28 | US | Texas | Clay | 48077 | 1581 | 23 | 0 | 33.78686685 | -98.20771198 | 2021-10-29 04:22:03 | Clay, Texas, US | |
2021-10-26 | US | Minnesota | Rock | 27133 | 1581 | 19 | 0 | 43.67482683 | -96.25296832 | 2021-10-27 04:22:32 | Rock, Minnesota, US | |
2021-10-25 | US | Missouri | Grundy | 29079 | 1581 | 47 | 0 | 40.11406587 | -93.56509276 | 2021-10-26 04:22:09 | Grundy, Missouri, US | |
2021-10-21 | US | Missouri | Wayne | 29223 | 1581 | 18 | 0 | 37.11303869 | -90.46001416 | 2021-10-22 04:21:14 | Wayne, Missouri, US | |
2021-10-14 | US | Louisiana | East Carroll | 22035 | 1581 | 30 | 0 | 32.73926954 | -91.23425694 | 2021-10-15 04:21:26 | East Carroll, Louisiana, US | |
2021-10-13 | US | Montana | Jefferson | 30043 | 1581 | 10 | 0 | 46.14907081 | -112.094396 | 2021-10-14 04:21:29 | Jefferson, Montana, US | |
2021-10-13 | US | Virginia | Franklin City | 51620 | 1581 | 40 | 0 | 36.6831435 | -76.93859681 | 2021-10-14 04:21:29 | Franklin City, Virginia, US | |
2021-10-12 | US | Montana | Rosebud | 30087 | 1581 | 55 | 0 | 46.23397237 | -106.72928799999998 | 2021-10-13 04:20:51 | Rosebud, Montana, US | |
2021-10-10 | US | Michigan | Manistee | 26101 | 1581 | 31 | 0 | 44.33352407 | -86.05626916 | 2021-10-11 04:21:31 | Manistee, Michigan, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;