daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
396 rows where confirmed = 1728 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-22 | US | Puerto Rico | Vieques | 72147 | 1728 | 0 | 0 | 18.123276 | -65.440971 | 2022-12-23 04:21:04 | Vieques, Puerto Rico, US | |
2022-12-05 | US | Wisconsin | Iron | 55051 | 1728 | 49 | 0 | 46.26302338 | -90.24295041 | 2022-12-06 04:21:03 | Iron, Wisconsin, US | |
2022-12-05 | US | Missouri | Atchison | 29005 | 1728 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-12-06 04:21:03 | Atchison, Missouri, US | |
2022-12-05 | US | Colorado | Huerfano | 8055 | 1728 | 40 | 0 | 37.68473101 | -104.9612585 | 2022-12-06 04:21:03 | Huerfano, Colorado, US | |
2022-12-04 | US | Missouri | Atchison | 29005 | 1728 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-12-05 04:20:58 | Atchison, Missouri, US | |
2022-12-03 | US | Missouri | Atchison | 29005 | 1728 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-12-04 04:20:56 | Atchison, Missouri, US | |
2022-12-02 | US | Missouri | Atchison | 29005 | 1728 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-12-03 04:21:02 | Atchison, Missouri, US | |
2022-12-01 | US | Missouri | Atchison | 29005 | 1728 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-12-02 04:21:07 | Atchison, Missouri, US | |
2022-11-30 | US | Missouri | Atchison | 29005 | 1728 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-12-01 04:21:03 | Atchison, Missouri, US | |
2022-11-29 | US | Missouri | Atchison | 29005 | 1728 | 24 | 0 | 40.43238737 | -95.42970639 | 2022-11-30 04:21:07 | Atchison, Missouri, US | |
2022-10-27 | US | Arkansas | Montgomery | 5097 | 1728 | 63 | 0 | 34.53704874 | -93.65824478 | 2022-10-28 04:22:31 | Montgomery, Arkansas, US | |
2022-10-25 | US | Nevada | White Pine | 32033 | 1728 | 23 | 0 | 39.44157041 | -114.899966 | 2022-10-26 04:22:19 | White Pine, Nevada, US | |
2022-10-24 | US | Nevada | White Pine | 32033 | 1728 | 23 | 0 | 39.44157041 | -114.899966 | 2022-10-25 04:21:53 | White Pine, Nevada, US | |
2022-10-23 | US | Nevada | White Pine | 32033 | 1728 | 23 | 0 | 39.44157041 | -114.899966 | 2022-10-24 04:22:29 | White Pine, Nevada, US | |
2022-10-22 | US | Nevada | White Pine | 32033 | 1728 | 23 | 0 | 39.44157041 | -114.899966 | 2022-10-23 04:22:46 | White Pine, Nevada, US | |
2022-10-21 | US | Nevada | White Pine | 32033 | 1728 | 23 | 0 | 39.44157041 | -114.899966 | 2022-10-22 04:22:53 | White Pine, Nevada, US | |
2022-10-20 | US | Washington | Skamania | 53059 | 1728 | 15 | 0 | 46.02408726 | -121.9164403 | 2022-10-21 04:22:23 | Skamania, Washington, US | |
2022-10-20 | US | Nevada | White Pine | 32033 | 1728 | 23 | 0 | 39.44157041 | -114.899966 | 2022-10-21 04:22:23 | White Pine, Nevada, US | |
2022-10-19 | US | Washington | Skamania | 53059 | 1728 | 15 | 0 | 46.02408726 | -121.9164403 | 2022-10-20 04:22:59 | Skamania, Washington, US | |
2022-10-19 | US | Nevada | White Pine | 32033 | 1728 | 23 | 0 | 39.44157041 | -114.899966 | 2022-10-20 04:22:59 | White Pine, Nevada, US | |
2022-10-16 | US | Virginia | Covington | 51580 | 1728 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-10-17 04:20:31 | Covington, Virginia, US | |
2022-10-15 | US | Virginia | Covington | 51580 | 1728 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-10-16 04:22:39 | Covington, Virginia, US | |
2022-10-14 | US | Virginia | Covington | 51580 | 1728 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-10-15 04:22:00 | Covington, Virginia, US | |
2022-10-13 | US | Virginia | Covington | 51580 | 1728 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-10-14 04:22:28 | Covington, Virginia, US | |
2022-10-12 | US | Virginia | Covington | 51580 | 1728 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-10-13 04:22:39 | Covington, Virginia, US | |
2022-10-12 | US | Illinois | Gallatin | 17059 | 1728 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-10-13 04:22:39 | Gallatin, Illinois, US | |
2022-10-11 | US | Virginia | Covington | 51580 | 1728 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-10-12 04:22:51 | Covington, Virginia, US | |
2022-10-09 | US | Virginia | Covington | 51580 | 1728 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-10-10 04:22:32 | Covington, Virginia, US | |
2022-10-08 | US | Virginia | Covington | 51580 | 1728 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-10-09 04:21:16 | Covington, Virginia, US | |
2022-10-07 | US | Virginia | Covington | 51580 | 1728 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-10-08 04:22:56 | Covington, Virginia, US | |
2022-09-26 | US | Illinois | Stark | 17175 | 1728 | 39 | 0 | 41.09309773 | -89.79745866 | 2022-09-27 04:23:01 | Stark, Illinois, US | |
2022-08-29 | US | Illinois | Calhoun | 17013 | 1728 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-08-30 04:21:03 | Calhoun, Illinois, US | |
2022-08-06 | US | North Dakota | Bottineau | 38009 | 1728 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-08-07 04:20:54 | Bottineau, North Dakota, US | |
2022-07-20 | US | Minnesota | Wilkin | 27167 | 1728 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-07-21 04:21:10 | Wilkin, Minnesota, US | |
2022-07-19 | US | Minnesota | Wilkin | 27167 | 1728 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-07-20 04:20:59 | Wilkin, Minnesota, US | |
2022-07-18 | US | Minnesota | Wilkin | 27167 | 1728 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-07-19 04:20:58 | Wilkin, Minnesota, US | |
2022-07-17 | US | Minnesota | Wilkin | 27167 | 1728 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-07-18 04:20:59 | Wilkin, Minnesota, US | |
2022-07-16 | US | Minnesota | Wilkin | 27167 | 1728 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-07-17 04:21:15 | Wilkin, Minnesota, US | |
2022-07-16 | China | Liaoning | 1728 | 2 | 0 | 41.2956 | 122.6085 | 2022-07-17 04:21:15 | Liaoning, China | |||
2022-07-15 | US | Minnesota | Wilkin | 27167 | 1728 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-07-16 04:21:05 | Wilkin, Minnesota, US | |
2022-07-14 | US | Minnesota | Wilkin | 27167 | 1728 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-07-15 04:20:53 | Wilkin, Minnesota, US | |
2022-07-13 | US | Oklahoma | Alfalfa | 40003 | 1728 | 16 | 0 | 36.73090616 | -98.32408495 | 2022-07-14 04:20:57 | Alfalfa, Oklahoma, US | |
2022-07-12 | US | Oklahoma | Alfalfa | 40003 | 1728 | 16 | 0 | 36.73090616 | -98.32408495 | 2022-07-13 04:20:58 | Alfalfa, Oklahoma, US | |
2022-07-11 | US | Oklahoma | Alfalfa | 40003 | 1728 | 16 | 0 | 36.73090616 | -98.32408495 | 2022-07-12 04:20:51 | Alfalfa, Oklahoma, US | |
2022-07-10 | US | Oklahoma | Alfalfa | 40003 | 1728 | 16 | 0 | 36.73090616 | -98.32408495 | 2022-07-11 04:20:46 | Alfalfa, Oklahoma, US | |
2022-07-09 | US | Oklahoma | Alfalfa | 40003 | 1728 | 16 | 0 | 36.73090616 | -98.32408495 | 2022-07-10 04:20:54 | Alfalfa, Oklahoma, US | |
2022-07-08 | US | Oklahoma | Alfalfa | 40003 | 1728 | 16 | 0 | 36.73090616 | -98.32408495 | 2022-07-09 04:20:59 | Alfalfa, Oklahoma, US | |
2022-07-07 | US | Texas | Brooks | 48047 | 1728 | 52 | 0 | 27.03103197 | -98.21808402 | 2022-07-08 04:20:56 | Brooks, Texas, US | |
2022-07-07 | US | Oklahoma | Alfalfa | 40003 | 1728 | 16 | 0 | 36.73090616 | -98.32408495 | 2022-07-08 04:20:56 | Alfalfa, Oklahoma, US | |
2022-06-09 | US | Missouri | Chariton | 29041 | 1728 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-06-10 04:20:55 | Chariton, Missouri, US | |
2022-06-08 | US | Missouri | Chariton | 29041 | 1728 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-06-09 04:20:54 | Chariton, Missouri, US | |
2022-06-07 | US | Missouri | Chariton | 29041 | 1728 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-06-08 04:20:55 | Chariton, Missouri, US | |
2022-06-06 | US | Missouri | Chariton | 29041 | 1728 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-06-07 04:21:08 | Chariton, Missouri, US | |
2022-06-05 | US | Nebraska | Merrick | 31121 | 1728 | 16 | 0 | 41.16624273 | -98.0374887 | 2022-06-06 04:20:57 | Merrick, Nebraska, US | |
2022-06-05 | US | Missouri | Chariton | 29041 | 1728 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-06-06 04:20:57 | Chariton, Missouri, US | |
2022-06-04 | US | Puerto Rico | Las Marias | 72083 | 1728 | 0 | 0 | 18.23679 | -66.98362 | 2022-06-05 04:20:55 | Las Marias, Puerto Rico, US | |
2022-06-04 | US | Nebraska | Merrick | 31121 | 1728 | 16 | 0 | 41.16624273 | -98.0374887 | 2022-06-05 04:20:55 | Merrick, Nebraska, US | |
2022-06-04 | US | Missouri | Chariton | 29041 | 1728 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-06-05 04:20:55 | Chariton, Missouri, US | |
2022-06-04 | US | Arkansas | Newton | 5101 | 1728 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-06-05 04:20:55 | Newton, Arkansas, US | |
2022-06-03 | US | Missouri | Chariton | 29041 | 1728 | 38 | 0 | 39.51499357 | -92.9629191 | 2022-06-04 04:20:58 | Chariton, Missouri, US | |
2022-06-03 | US | Arkansas | Newton | 5101 | 1728 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-06-04 04:20:58 | Newton, Arkansas, US | |
2022-06-02 | US | Arkansas | Newton | 5101 | 1728 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-06-03 04:20:58 | Newton, Arkansas, US | |
2022-06-01 | US | Oregon | Grant | 41023 | 1728 | 22 | 0 | 44.49024544 | -119.0068631 | 2022-06-02 05:20:39 | Grant, Oregon, US | |
2022-05-15 | US | Colorado | Rio Blanco | 8103 | 1728 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-05-16 04:20:47 | Rio Blanco, Colorado, US | |
2022-05-11 | US | Illinois | Pulaski | 17153 | 1728 | 19 | 0 | 37.22631423 | -89.13085001 | 2022-05-12 04:20:54 | Pulaski, Illinois, US | |
2022-04-27 | US | Arkansas | Woodruff | 5147 | 1728 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-04-28 04:20:47 | Woodruff, Arkansas, US | |
2022-04-26 | US | Arkansas | Woodruff | 5147 | 1728 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-04-27 04:20:52 | Woodruff, Arkansas, US | |
2022-04-17 | US | Puerto Rico | Arroyo | 72015 | 1728 | 0 | 0 | 17.998457000000005 | -66.056546 | 2022-04-18 04:21:12 | Arroyo, Puerto Rico, US | |
2022-04-17 | US | Arkansas | Woodruff | 5147 | 1728 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-04-18 04:21:12 | Woodruff, Arkansas, US | |
2022-04-16 | US | Arkansas | Woodruff | 5147 | 1728 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-04-17 04:20:59 | Woodruff, Arkansas, US | |
2022-04-15 | US | Arkansas | Woodruff | 5147 | 1728 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-04-16 04:20:48 | Woodruff, Arkansas, US | |
2022-04-14 | US | Arkansas | Woodruff | 5147 | 1728 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-04-15 04:20:57 | Woodruff, Arkansas, US | |
2022-04-13 | US | Arkansas | Woodruff | 5147 | 1728 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-04-13 23:21:06 | Woodruff, Arkansas, US | |
2022-04-05 | US | Puerto Rico | Hormigueros | 72067 | 1728 | 0 | 0 | 18.134532 | -67.113972 | 2022-04-06 04:20:49 | Hormigueros, Puerto Rico, US | |
2022-04-04 | US | Puerto Rico | Hormigueros | 72067 | 1728 | 0 | 0 | 18.134532 | -67.113972 | 2022-04-05 04:20:48 | Hormigueros, Puerto Rico, US | |
2022-03-29 | US | South Dakota | Hutchinson | 46067 | 1728 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-03-30 04:20:45 | Hutchinson, South Dakota, US | |
2022-03-28 | US | South Dakota | Hutchinson | 46067 | 1728 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-03-29 04:20:46 | Hutchinson, South Dakota, US | |
2022-03-27 | US | South Dakota | Hutchinson | 46067 | 1728 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-03-28 04:20:33 | Hutchinson, South Dakota, US | |
2022-03-26 | US | South Dakota | Hutchinson | 46067 | 1728 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-03-27 04:20:47 | Hutchinson, South Dakota, US | |
2022-03-25 | US | South Dakota | Hutchinson | 46067 | 1728 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-03-26 04:20:23 | Hutchinson, South Dakota, US | |
2022-03-24 | US | South Dakota | Hutchinson | 46067 | 1728 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-03-25 04:20:46 | Hutchinson, South Dakota, US | |
2022-03-23 | US | South Dakota | Hutchinson | 46067 | 1728 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-03-24 04:20:43 | Hutchinson, South Dakota, US | |
2022-03-17 | US | North Carolina | Camden | 37029 | 1728 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-03-18 04:20:55 | Camden, North Carolina, US | |
2022-03-16 | US | South Dakota | Hutchinson | 46067 | 1728 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-03-17 04:20:56 | Hutchinson, South Dakota, US | |
2022-03-15 | US | South Dakota | Hutchinson | 46067 | 1728 | 36 | 0 | 43.33449012 | -97.75536441 | 2022-03-16 04:20:50 | Hutchinson, South Dakota, US | |
2022-03-10 | US | Minnesota | Lac qui Parle | 27073 | 1728 | 28 | 0 | 44.9973857 | -96.17488219 | 2022-03-11 04:20:50 | Lac qui Parle, Minnesota, US | |
2022-03-03 | US | Arkansas | Dallas | 5039 | 1728 | 29 | 0 | 33.97042763 | -92.65167437 | 2022-03-04 04:21:09 | Dallas, Arkansas, US | |
2022-03-02 | US | Arkansas | Dallas | 5039 | 1728 | 29 | 0 | 33.97042763 | -92.65167437 | 2022-03-03 04:21:01 | Dallas, Arkansas, US | |
2022-03-01 | US | Arkansas | Dallas | 5039 | 1728 | 29 | 0 | 33.97042763 | -92.65167437 | 2022-03-02 04:21:07 | Dallas, Arkansas, US | |
2022-02-28 | US | Arkansas | Dallas | 5039 | 1728 | 29 | 0 | 33.97042763 | -92.65167437 | 2022-03-01 04:21:09 | Dallas, Arkansas, US | |
2022-02-27 | US | Arkansas | Dallas | 5039 | 1728 | 29 | 0 | 33.97042763 | -92.65167437 | 2022-02-28 04:21:05 | Dallas, Arkansas, US | |
2022-02-26 | US | Arkansas | Dallas | 5039 | 1728 | 28 | 0 | 33.97042763 | -92.65167437 | 2022-02-27 04:21:04 | Dallas, Arkansas, US | |
2022-02-20 | US | Colorado | Conejos | 8021 | 1728 | 51 | 0 | 37.201606 | -106.19174879999998 | 2022-02-21 04:21:05 | Conejos, Colorado, US | |
2022-02-17 | US | Texas | Refugio | 48391 | 1728 | 31 | 0 | 28.323897600000002 | -97.15766311 | 2022-02-18 04:21:04 | Refugio, Texas, US | |
2022-02-16 | US | Texas | Refugio | 48391 | 1728 | 31 | 0 | 28.323897600000002 | -97.15766311 | 2022-02-17 04:20:56 | Refugio, Texas, US | |
2022-02-15 | US | Texas | Refugio | 48391 | 1728 | 31 | 0 | 28.323897600000002 | -97.15766311 | 2022-02-16 04:21:10 | Refugio, Texas, US | |
2022-02-10 | US | Virginia | Lancaster | 51103 | 1728 | 26 | 0 | 37.71889653 | -76.46400482 | 2022-02-11 04:21:09 | Lancaster, Virginia, US | |
2022-02-10 | US | Nebraska | Richardson | 31147 | 1728 | 19 | 0 | 40.1247415 | -95.71755036 | 2022-02-11 04:21:09 | Richardson, Nebraska, US | |
2022-02-07 | US | Georgia | Crawford | 13079 | 1728 | 50 | 0 | 32.71391813 | -83.98061238 | 2022-02-08 04:21:15 | Crawford, Georgia, US | |
2022-02-02 | US | Kentucky | Nicholas | 21181 | 1728 | 29 | 0 | 38.33342292 | -84.01889177 | 2022-02-03 04:21:21 | Nicholas, Kentucky, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;