daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
411 rows where confirmed = 1404 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 | Virginia | Craig | 51045 | 1404 | 24 | 0 | 37.48133648 | -80.21072274 | 2022-12-27 04:21:07 | Craig, Virginia, US | |
2022-12-25 | US | Virginia | Craig | 51045 | 1404 | 24 | 0 | 37.48133648 | -80.21072274 | 2022-12-26 04:21:06 | Craig, Virginia, US | |
2022-12-24 | US | Virginia | Craig | 51045 | 1404 | 24 | 0 | 37.48133648 | -80.21072274 | 2022-12-25 04:21:04 | Craig, Virginia, US | |
2022-12-23 | US | Virginia | Craig | 51045 | 1404 | 24 | 0 | 37.48133648 | -80.21072274 | 2022-12-24 04:21:02 | Craig, Virginia, US | |
2022-11-21 | US | Wyoming | Hot Springs | 56017 | 1404 | 19 | 0 | 43.71930657 | -108.4423174 | 2022-11-22 04:20:47 | Hot Springs, Wyoming, US | |
2022-11-20 | US | Wyoming | Hot Springs | 56017 | 1404 | 19 | 0 | 43.71930657 | -108.4423174 | 2022-11-21 04:21:05 | Hot Springs, Wyoming, US | |
2022-11-20 | US | Texas | San Saba | 48411 | 1404 | 38 | 0 | 31.1577796 | -98.81758731 | 2022-11-21 04:21:05 | San Saba, Texas, US | |
2022-11-19 | US | Wyoming | Hot Springs | 56017 | 1404 | 19 | 0 | 43.71930657 | -108.4423174 | 2022-11-20 04:21:08 | Hot Springs, Wyoming, US | |
2022-11-19 | US | Texas | San Saba | 48411 | 1404 | 38 | 0 | 31.1577796 | -98.81758731 | 2022-11-20 04:21:08 | San Saba, Texas, US | |
2022-11-18 | US | Wyoming | Hot Springs | 56017 | 1404 | 19 | 0 | 43.71930657 | -108.4423174 | 2022-11-19 04:21:14 | Hot Springs, Wyoming, US | |
2022-11-18 | US | Texas | San Saba | 48411 | 1404 | 38 | 0 | 31.1577796 | -98.81758731 | 2022-11-19 04:21:14 | San Saba, Texas, US | |
2022-11-17 | US | Wyoming | Hot Springs | 56017 | 1404 | 19 | 0 | 43.71930657 | -108.4423174 | 2022-11-18 04:21:15 | Hot Springs, Wyoming, US | |
2022-11-17 | US | Montana | Pondera | 30073 | 1404 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-11-18 04:21:15 | Pondera, Montana, US | |
2022-11-16 | US | Wyoming | Hot Springs | 56017 | 1404 | 19 | 0 | 43.71930657 | -108.4423174 | 2022-11-17 04:21:11 | Hot Springs, Wyoming, US | |
2022-11-16 | US | Montana | Pondera | 30073 | 1404 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-11-17 04:21:11 | Pondera, Montana, US | |
2022-11-15 | US | Wyoming | Hot Springs | 56017 | 1404 | 19 | 0 | 43.71930657 | -108.4423174 | 2022-11-16 04:21:09 | Hot Springs, Wyoming, US | |
2022-11-15 | US | Montana | Pondera | 30073 | 1404 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-11-16 04:21:09 | Pondera, Montana, US | |
2022-11-14 | US | Montana | Pondera | 30073 | 1404 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-11-15 04:21:16 | Pondera, Montana, US | |
2022-08-16 | US | South Dakota | McCook | 46087 | 1404 | 31 | 0 | 43.6742571 | -97.36863144 | 2022-08-17 04:20:59 | McCook, South Dakota, US | |
2022-08-15 | US | South Dakota | McCook | 46087 | 1404 | 31 | 0 | 43.6742571 | -97.36863144 | 2022-08-16 04:20:58 | McCook, South Dakota, US | |
2022-08-14 | US | South Dakota | McCook | 46087 | 1404 | 31 | 0 | 43.6742571 | -97.36863144 | 2022-08-15 04:20:59 | McCook, South Dakota, US | |
2022-08-13 | US | South Dakota | McCook | 46087 | 1404 | 31 | 0 | 43.6742571 | -97.36863144 | 2022-08-14 04:20:55 | McCook, South Dakota, US | |
2022-08-12 | US | South Dakota | McCook | 46087 | 1404 | 31 | 0 | 43.6742571 | -97.36863144 | 2022-08-13 04:20:52 | McCook, South Dakota, US | |
2022-08-11 | US | South Dakota | McCook | 46087 | 1404 | 31 | 0 | 43.6742571 | -97.36863144 | 2022-08-12 04:20:54 | McCook, South Dakota, US | |
2022-08-10 | US | South Dakota | McCook | 46087 | 1404 | 31 | 0 | 43.6742571 | -97.36863144 | 2022-08-11 04:20:49 | McCook, South Dakota, US | |
2022-08-04 | US | Texas | Yoakum | 48501 | 1404 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-08-05 04:20:52 | Yoakum, Texas, US | |
2022-08-03 | US | Texas | Yoakum | 48501 | 1404 | 42 | 0 | 33.17320212 | -102.8276433 | 2022-08-04 04:20:58 | Yoakum, Texas, US | |
2022-07-21 | US | Texas | McCulloch | 48307 | 1404 | 47 | 0 | 31.1925468 | -99.34682807 | 2022-07-22 04:21:15 | McCulloch, Texas, US | |
2022-07-21 | US | North Dakota | McHenry | 38049 | 1404 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-07-22 04:21:15 | McHenry, North Dakota, US | |
2022-07-10 | US | North Dakota | Sioux | 38085 | 1404 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-07-11 04:20:46 | Sioux, North Dakota, US | |
2022-07-05 | US | Kansas | Rooks | 20163 | 1404 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-07-06 04:20:58 | Rooks, Kansas, US | |
2022-07-04 | US | Kansas | Rooks | 20163 | 1404 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-07-05 04:20:45 | Rooks, Kansas, US | |
2022-07-03 | US | Kansas | Rooks | 20163 | 1404 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-07-04 04:20:54 | Rooks, Kansas, US | |
2022-07-02 | US | Kansas | Rooks | 20163 | 1404 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-07-03 04:20:59 | Rooks, Kansas, US | |
2022-07-01 | US | Kansas | Rooks | 20163 | 1404 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-07-02 04:21:16 | Rooks, Kansas, US | |
2022-06-30 | US | Kansas | Rooks | 20163 | 1404 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-07-01 04:21:10 | Rooks, Kansas, US | |
2022-06-29 | US | Kansas | Rooks | 20163 | 1404 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-06-30 04:21:01 | Rooks, Kansas, US | |
2022-06-16 | US | Missouri | Atchison | 29005 | 1404 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-06-17 04:20:56 | Atchison, Missouri, US | |
2022-06-15 | US | Missouri | Atchison | 29005 | 1404 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-06-16 04:20:55 | Atchison, Missouri, US | |
2022-06-14 | US | Missouri | Atchison | 29005 | 1404 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-06-15 04:20:54 | Atchison, Missouri, US | |
2022-06-13 | US | Missouri | Atchison | 29005 | 1404 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-06-14 04:20:52 | Atchison, Missouri, US | |
2022-06-12 | US | Missouri | Atchison | 29005 | 1404 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-06-13 04:21:14 | Atchison, Missouri, US | |
2022-06-11 | US | Missouri | Atchison | 29005 | 1404 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-06-12 04:20:53 | Atchison, Missouri, US | |
2022-06-10 | US | Missouri | Atchison | 29005 | 1404 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-06-11 04:21:01 | Atchison, Missouri, US | |
2022-06-05 | US | Virginia | Covington | 51580 | 1404 | 27 | 0 | 37.7824656 | -79.98631446 | 2022-06-06 04:20:57 | Covington, Virginia, US | |
2022-06-04 | US | Virginia | Covington | 51580 | 1404 | 27 | 0 | 37.7824656 | -79.98631446 | 2022-06-05 04:20:55 | Covington, Virginia, US | |
2022-06-03 | US | Virginia | Covington | 51580 | 1404 | 27 | 0 | 37.7824656 | -79.98631446 | 2022-06-04 04:20:58 | Covington, Virginia, US | |
2022-05-15 | US | Puerto Rico | Las Marias | 72083 | 1404 | 0 | 0 | 18.23679 | -66.98362 | 2022-05-16 04:20:47 | Las Marias, Puerto Rico, US | |
2022-04-28 | US | Minnesota | Big Stone | 27011 | 1404 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-04-29 04:20:59 | Big Stone, Minnesota, US | |
2022-04-07 | US | Oregon | Lake | 41037 | 1404 | 26 | 0 | 42.79246693 | -120.38501629999999 | 2022-04-08 04:20:48 | Lake, Oregon, US | |
2022-04-06 | US | Oregon | Lake | 41037 | 1404 | 26 | 0 | 42.79246693 | -120.38501629999999 | 2022-04-07 04:20:53 | Lake, Oregon, US | |
2022-03-31 | US | Washington | Ferry | 53019 | 1404 | 29 | 0 | 48.471143100000006 | -118.5154041 | 2022-04-01 04:20:28 | Ferry, Washington, US | |
2022-03-30 | US | Washington | Ferry | 53019 | 1404 | 29 | 0 | 48.471143100000006 | -118.5154041 | 2022-03-31 04:20:56 | Ferry, Washington, US | |
2022-03-20 | US | Alaska | Yukon-Koyukuk | 2290 | 1404 | 9 | 0 | 65.50815459 | -151.39073869999999 | 2022-03-21 04:20:50 | Yukon-Koyukuk, Alaska, US | |
2022-03-19 | US | Alaska | Yukon-Koyukuk | 2290 | 1404 | 9 | 0 | 65.50815459 | -151.39073869999999 | 2022-03-20 04:20:45 | Yukon-Koyukuk, Alaska, US | |
2022-03-18 | US | Alaska | Yukon-Koyukuk | 2290 | 1404 | 9 | 0 | 65.50815459 | -151.39073869999999 | 2022-03-19 04:20:47 | Yukon-Koyukuk, Alaska, US | |
2022-03-16 | US | Texas | Bailey | 48017 | 1404 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-03-17 04:20:56 | Bailey, Texas, US | |
2022-02-27 | US | South Dakota | Brule | 46015 | 1404 | 18 | 0 | 43.71756379 | -99.08118954 | 2022-02-28 04:21:05 | Brule, South Dakota, US | |
2022-02-26 | US | South Dakota | Brule | 46015 | 1404 | 18 | 0 | 43.71756379 | -99.08118954 | 2022-02-27 04:21:04 | Brule, South Dakota, US | |
2022-02-25 | US | South Dakota | Brule | 46015 | 1404 | 18 | 0 | 43.71756379 | -99.08118954 | 2022-02-26 04:21:12 | Brule, South Dakota, US | |
2022-02-09 | US | Minnesota | Grant | 27051 | 1404 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-02-10 04:21:14 | Grant, Minnesota, US | |
2022-02-02 | US | Idaho | Power | 16077 | 1404 | 18 | 0 | 42.69254894 | -112.83957420000002 | 2022-02-03 04:21:21 | Power, Idaho, US | |
2022-01-30 | US | Kansas | Morris | 20127 | 1404 | 24 | 0 | 38.68827511 | -96.65128437 | 2022-01-31 04:21:09 | Morris, Kansas, US | |
2022-01-29 | US | Texas | Jack | 48237 | 1404 | 23 | 0 | 33.23377248 | -98.17283469 | 2022-01-30 04:21:26 | Jack, Texas, US | |
2022-01-29 | US | Kansas | Morris | 20127 | 1404 | 24 | 0 | 38.68827511 | -96.65128437 | 2022-01-30 04:21:26 | Morris, Kansas, US | |
2022-01-29 | Palau | 1404 | 0 | 0 | 7.515 | 134.5825 | 2022-01-30 04:21:26 | Palau | ||||
2022-01-28 | US | Kansas | Morris | 20127 | 1404 | 24 | 0 | 38.68827511 | -96.65128437 | 2022-01-29 04:21:10 | Morris, Kansas, US | |
2022-01-27 | US | Missouri | Shelby | 29205 | 1404 | 13 | 0 | 39.79742518 | -92.07634971 | 2022-01-28 04:21:09 | Shelby, Missouri, US | |
2022-01-25 | US | South Dakota | Hamlin | 46057 | 1404 | 40 | 0 | 44.67385954 | -97.18829593 | 2022-01-26 04:21:07 | Hamlin, South Dakota, US | |
2022-01-18 | US | Puerto Rico | Guayanilla | 72059 | 1404 | 0 | 0 | 18.039942 | -66.79186 | 2022-01-19 04:21:23 | Guayanilla, Puerto Rico, US | |
2022-01-13 | US | Minnesota | Lac qui Parle | 27073 | 1404 | 26 | 0 | 44.9973857 | -96.17488219 | 2022-01-14 04:21:54 | Lac qui Parle, Minnesota, US | |
2022-01-05 | US | Texas | Delta | 48119 | 1404 | 22 | 0 | 33.38570922 | -95.66921122 | 2022-01-06 04:22:09 | Delta, Texas, US | |
2022-01-03 | US | Texas | Winkler | 48495 | 1404 | 32 | 0 | 31.85008651 | -103.04851629999999 | 2022-01-04 04:22:17 | Winkler, Texas, US | |
2022-01-02 | US | Texas | Winkler | 48495 | 1404 | 32 | 0 | 31.85008651 | -103.04851629999999 | 2022-01-03 02:22:25 | Winkler, Texas, US | |
2021-12-23 | US | Virginia | Essex | 51057 | 1404 | 20 | 0 | 37.93357639 | -76.94230311 | 2021-12-24 04:21:34 | Essex, Virginia, US | |
2021-12-22 | US | Puerto Rico | Naguabo | 72103 | 1404 | 0 | 0 | 18.230636999999998 | -65.753897 | 2021-12-23 04:21:21 | Naguabo, Puerto Rico, US | |
2021-12-18 | US | Texas | Blanco | 48031 | 1404 | 28 | 0 | 30.26640707 | -98.3999852 | 2021-12-19 04:21:11 | Blanco, Texas, US | |
2021-12-15 | US | Texas | Crosby | 48107 | 1404 | 39 | 0 | 33.61431553 | -101.30003640000001 | 2021-12-16 04:22:11 | Crosby, Texas, US | |
2021-12-15 | US | North Carolina | Graham | 37075 | 1404 | 28 | 0 | 35.3506925 | -83.83369267 | 2021-12-16 04:22:11 | Graham, North Carolina, US | |
2021-12-14 | US | Texas | Crosby | 48107 | 1404 | 39 | 0 | 33.61431553 | -101.30003640000001 | 2021-12-15 03:22:16 | Crosby, Texas, US | |
2021-12-02 | US | West Virginia | Webster | 54101 | 1404 | 26 | 0 | 38.49370949 | -80.4202023 | 2021-12-03 04:23:05 | Webster, West Virginia, US | |
2021-12-02 | US | West Virginia | Clay | 54015 | 1404 | 23 | 0 | 38.46231092 | -81.07652217 | 2021-12-03 04:23:05 | Clay, West Virginia, US | |
2021-12-02 | US | Michigan | Baraga | 26013 | 1404 | 46 | 0 | 46.6720582 | -88.36363591 | 2021-12-03 04:23:05 | Baraga, Michigan, US | |
2021-12-01 | US | Michigan | Baraga | 26013 | 1404 | 46 | 0 | 46.6720582 | -88.36363591 | 2021-12-02 04:22:37 | Baraga, Michigan, US | |
2021-11-29 | US | New Hampshire | Unassigned | 90033 | 1404 | 9 | 0 | 44.69063265 | 0.0 | 2021-11-30 04:22:53 | Unassigned, New Hampshire, US | |
2021-11-28 | US | Missouri | Monroe | 29137 | 1404 | 13 | 0 | 39.49593978 | -92.00043978 | 2021-11-29 04:22:30 | Monroe, Missouri, US | |
2021-11-27 | US | Missouri | Monroe | 29137 | 1404 | 13 | 0 | 39.49593978 | -92.00043978 | 2021-11-28 04:22:43 | Monroe, Missouri, US | |
2021-11-26 | US | Missouri | Monroe | 29137 | 1404 | 13 | 0 | 39.49593978 | -92.00043978 | 2021-11-27 04:22:45 | Monroe, Missouri, US | |
2021-11-25 | US | Montana | Blaine | 30005 | 1404 | 27 | 0 | 48.43175214 | -108.9582723 | 2021-11-26 04:22:33 | Blaine, Montana, US | |
2021-11-25 | US | Missouri | Monroe | 29137 | 1404 | 13 | 0 | 39.49593978 | -92.00043978 | 2021-11-26 04:22:33 | Monroe, Missouri, US | |
2021-11-24 | US | Montana | Blaine | 30005 | 1404 | 27 | 0 | 48.43175214 | -108.9582723 | 2021-11-25 04:22:33 | Blaine, Montana, US | |
2021-11-24 | US | Missouri | Monroe | 29137 | 1404 | 13 | 0 | 39.49593978 | -92.00043978 | 2021-11-25 04:22:33 | Monroe, Missouri, US | |
2021-11-24 | US | Arkansas | Nevada | 5099 | 1404 | 40 | 0 | 33.66340119 | -93.30632432 | 2021-11-25 04:22:33 | Nevada, Arkansas, US | |
2021-11-23 | US | Virginia | Buena Vista | 51530 | 1404 | 28 | 0 | 37.73484642 | -79.35296097 | 2021-11-24 04:22:14 | Buena Vista, Virginia, US | |
2021-11-23 | US | Nebraska | Holt | 31089 | 1404 | 16 | 0 | 42.45522056 | -98.78402558 | 2021-11-24 04:22:14 | Holt, Nebraska, US | |
2021-11-23 | US | Nebraska | Cheyenne | 31033 | 1404 | 16 | 0 | 41.21999357 | -102.9941693 | 2021-11-24 04:22:14 | Cheyenne, Nebraska, US | |
2021-11-17 | US | Texas | Gaines | 48165 | 1404 | 63 | 0 | 32.74055318 | -102.6353295 | 2021-11-18 04:21:33 | Gaines, Texas, US | |
2021-11-16 | US | Texas | Gaines | 48165 | 1404 | 63 | 0 | 32.74055318 | -102.6353295 | 2021-11-17 04:21:48 | Gaines, Texas, US | |
2021-11-15 | US | Texas | Gaines | 48165 | 1404 | 63 | 0 | 32.74055318 | -102.6353295 | 2021-11-16 04:21:10 | Gaines, Texas, US | |
2021-11-14 | US | Virginia | Nelson | 51125 | 1404 | 18 | 0 | 37.78790447 | -78.88498513 | 2021-11-15 04:21:36 | Nelson, Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;