johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
377 rows where confirmed = 1670 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
453575 | 453575 | 2022-12-21 | US | New Jersey | Unassigned | 90034 | 1670 | 0 | 0 | 41.13891592 | 0.0 | 2022-12-22 04:20:56 | Unassigned, New Jersey, US | |
3716357 | 3716357 | 2022-12-06 | US | New Jersey | Unassigned | 90034 | 1670 | 0 | 0 | 41.13891592 | 0.0 | 2022-12-07 04:20:58 | Unassigned, New Jersey, US | |
2416763 | 2416763 | 2022-12-05 | US | Missouri | Carter | 29035 | 1670 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-12-06 04:21:03 | Carter, Missouri, US | |
720371 | 720371 | 2022-12-04 | US | Missouri | Carter | 29035 | 1670 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-12-05 04:20:58 | Carter, Missouri, US | |
2818660 | 2818660 | 2022-12-03 | US | Missouri | Carter | 29035 | 1670 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-12-04 04:20:56 | Carter, Missouri, US | |
835516 | 835516 | 2022-12-02 | US | Missouri | Carter | 29035 | 1670 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-12-03 04:21:02 | Carter, Missouri, US | |
2138046 | 2138046 | 2022-12-01 | US | Missouri | Carter | 29035 | 1670 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-12-02 04:21:07 | Carter, Missouri, US | |
1966462 | 1966462 | 2022-11-30 | US | Missouri | Carter | 29035 | 1670 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-12-01 04:21:03 | Carter, Missouri, US | |
2558476 | 2558476 | 2022-11-29 | US | Missouri | Carter | 29035 | 1670 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-11-30 04:21:07 | Carter, Missouri, US | |
1242455 | 1242455 | 2022-11-28 | US | Puerto Rico | Vieques | 72147 | 1670 | 0 | 0 | 18.123276 | -65.440971 | 2022-11-29 04:21:05 | Vieques, Puerto Rico, US | |
3554443 | 3554443 | 2022-11-27 | US | Puerto Rico | Vieques | 72147 | 1670 | 0 | 0 | 18.123276 | -65.440971 | 2022-11-28 04:21:02 | Vieques, Puerto Rico, US | |
319729 | 319729 | 2022-10-30 | China | Hunan | 1670 | 4 | 0 | 27.6104 | 111.7088 | 2022-10-31 04:21:36 | Hunan, China | |||
2162975 | 2162975 | 2022-10-16 | US | Washington | Ferry | 53019 | 1670 | 30 | 0 | 48.4711431 | -118.5154041 | 2022-10-17 04:20:31 | Ferry, Washington, US | |
519172 | 519172 | 2022-10-15 | US | Washington | Ferry | 53019 | 1670 | 30 | 0 | 48.4711431 | -118.5154041 | 2022-10-16 04:22:39 | Ferry, Washington, US | |
2036229 | 2036229 | 2022-10-14 | US | Washington | Ferry | 53019 | 1670 | 30 | 0 | 48.4711431 | -118.5154041 | 2022-10-15 04:22:00 | Ferry, Washington, US | |
3217854 | 3217854 | 2022-10-12 | US | Wisconsin | Iron | 55051 | 1670 | 49 | 0 | 46.26302338 | -90.24295041 | 2022-10-13 04:22:39 | Iron, Wisconsin, US | |
3253703 | 3253703 | 2022-10-11 | US | Wisconsin | Iron | 55051 | 1670 | 49 | 0 | 46.26302338 | -90.24295041 | 2022-10-12 04:22:51 | Iron, Wisconsin, US | |
1563283 | 1563283 | 2022-09-28 | US | Texas | Newton | 48351 | 1670 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-09-29 04:22:34 | Newton, Texas, US | |
3997826 | 3997826 | 2022-09-27 | US | Texas | Newton | 48351 | 1670 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-09-28 04:23:01 | Newton, Texas, US | |
3995083 | 3995083 | 2022-09-27 | US | Alaska | Yukon-Koyukuk | 2290 | 1670 | 11 | 0 | 65.50815459 | -151.3907387 | 2022-09-28 04:23:01 | Yukon-Koyukuk, Alaska, US | |
2772154 | 2772154 | 2022-09-26 | US | Texas | Newton | 48351 | 1670 | 63 | 0 | 30.78548982 | -93.74408813 | 2022-09-27 04:23:01 | Newton, Texas, US | |
2769411 | 2769411 | 2022-09-26 | US | Alaska | Yukon-Koyukuk | 2290 | 1670 | 11 | 0 | 65.50815459 | -151.3907387 | 2022-09-27 04:23:01 | Yukon-Koyukuk, Alaska, US | |
1977064 | 1977064 | 2022-09-25 | US | Alaska | Yukon-Koyukuk | 2290 | 1670 | 11 | 0 | 65.50815459 | -151.3907387 | 2022-09-26 04:20:52 | Yukon-Koyukuk, Alaska, US | |
2650231 | 2650231 | 2022-09-24 | US | Alaska | Yukon-Koyukuk | 2290 | 1670 | 11 | 0 | 65.50815459 | -151.3907387 | 2022-09-25 04:23:31 | Yukon-Koyukuk, Alaska, US | |
384671 | 384671 | 2022-09-23 | US | Alaska | Yukon-Koyukuk | 2290 | 1670 | 11 | 0 | 65.50815459 | -151.3907387 | 2022-09-24 04:21:40 | Yukon-Koyukuk, Alaska, US | |
1624737 | 1624737 | 2022-09-22 | US | Alaska | Yukon-Koyukuk | 2290 | 1670 | 11 | 0 | 65.50815459 | -151.3907387 | 2022-09-23 04:23:13 | Yukon-Koyukuk, Alaska, US | |
1370941 | 1370941 | 2022-09-21 | US | Alaska | Yukon-Koyukuk | 2290 | 1670 | 11 | 0 | 65.50815459 | -151.3907387 | 2022-09-22 04:22:56 | Yukon-Koyukuk, Alaska, US | |
3769205 | 3769205 | 2022-09-11 | US | Virginia | Covington | 51580 | 1670 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-09-12 04:20:58 | Covington, Virginia, US | |
3768276 | 3768276 | 2022-09-11 | US | North Dakota | Dickey | 38021 | 1670 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-09-12 04:20:58 | Dickey, North Dakota, US | |
3827780 | 3827780 | 2022-09-10 | US | Virginia | Covington | 51580 | 1670 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-09-11 04:20:50 | Covington, Virginia, US | |
3826851 | 3826851 | 2022-09-10 | US | North Dakota | Dickey | 38021 | 1670 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-09-11 04:20:50 | Dickey, North Dakota, US | |
966237 | 966237 | 2022-09-09 | US | Virginia | Covington | 51580 | 1670 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-09-10 04:21:10 | Covington, Virginia, US | |
965308 | 965308 | 2022-09-09 | US | North Dakota | Dickey | 38021 | 1670 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-09-10 04:21:10 | Dickey, North Dakota, US | |
2365920 | 2365920 | 2022-08-19 | US | North Dakota | Ransom | 38073 | 1670 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-08-20 04:21:01 | Ransom, North Dakota, US | |
3650604 | 3650604 | 2022-08-14 | US | Texas | Bailey | 48017 | 1670 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-08-15 04:20:59 | Bailey, Texas, US | |
1971610 | 1971610 | 2022-08-13 | US | Texas | Bailey | 48017 | 1670 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-08-14 04:20:55 | Bailey, Texas, US | |
2891419 | 2891419 | 2022-08-12 | US | Texas | Bailey | 48017 | 1670 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-08-13 04:20:52 | Bailey, Texas, US | |
3911024 | 3911024 | 2022-08-11 | US | Texas | Bailey | 48017 | 1670 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-08-12 04:20:54 | Bailey, Texas, US | |
1405881 | 1405881 | 2022-08-02 | US | Georgia | Lincoln | 13181 | 1670 | 35 | 0 | 33.79201475 | -82.45024131 | 2022-08-03 04:20:59 | Lincoln, Georgia, US | |
3617919 | 3617919 | 2022-08-01 | US | Georgia | Lincoln | 13181 | 1670 | 35 | 0 | 33.79201475 | -82.45024131 | 2022-08-02 04:20:53 | Lincoln, Georgia, US | |
3872399 | 3872399 | 2022-07-31 | US | Georgia | Lincoln | 13181 | 1670 | 35 | 0 | 33.79201475 | -82.45024131 | 2022-08-01 04:21:03 | Lincoln, Georgia, US | |
675153 | 675153 | 2022-07-30 | US | Georgia | Lincoln | 13181 | 1670 | 35 | 0 | 33.79201475 | -82.45024131 | 2022-07-31 04:21:02 | Lincoln, Georgia, US | |
1784352 | 1784352 | 2022-07-29 | US | Georgia | Lincoln | 13181 | 1670 | 35 | 0 | 33.79201475 | -82.45024131 | 2022-07-30 04:20:42 | Lincoln, Georgia, US | |
1066715 | 1066715 | 2022-07-28 | US | Georgia | Lincoln | 13181 | 1670 | 35 | 0 | 33.79201475 | -82.45024131 | 2022-07-29 04:20:45 | Lincoln, Georgia, US | |
2336234 | 2336234 | 2022-07-27 | US | Georgia | Lincoln | 13181 | 1670 | 35 | 0 | 33.79201475 | -82.45024131 | 2022-07-28 04:20:56 | Lincoln, Georgia, US | |
3080452 | 3080452 | 2022-07-04 | US | North Dakota | Bottineau | 38009 | 1670 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-07-05 04:20:45 | Bottineau, North Dakota, US | |
1769734 | 1769734 | 2022-07-03 | US | North Dakota | Bottineau | 38009 | 1670 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-07-04 04:20:54 | Bottineau, North Dakota, US | |
168666 | 168666 | 2022-06-21 | US | Oregon | Harney | 41025 | 1670 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-06-22 04:20:54 | Harney, Oregon, US | |
1765949 | 1765949 | 2022-06-20 | US | Oregon | Harney | 41025 | 1670 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-06-21 04:20:56 | Harney, Oregon, US | |
3272135 | 3272135 | 2022-06-19 | US | Oregon | Harney | 41025 | 1670 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-06-20 04:21:01 | Harney, Oregon, US | |
3400047 | 3400047 | 2022-06-18 | US | Oregon | Harney | 41025 | 1670 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-06-19 04:20:51 | Harney, Oregon, US | |
2313924 | 2313924 | 2022-06-17 | US | Oregon | Harney | 41025 | 1670 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-06-18 04:21:10 | Harney, Oregon, US | |
2236015 | 2236015 | 2022-06-12 | US | Colorado | Kit Carson | 8063 | 1670 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-06-13 04:21:14 | Kit Carson, Colorado, US | |
1851773 | 1851773 | 2022-05-26 | US | Minnesota | Wilkin | 27167 | 1670 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-05-27 04:20:56 | Wilkin, Minnesota, US | |
2049649 | 2049649 | 2022-05-25 | US | Minnesota | Wilkin | 27167 | 1670 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-05-26 04:20:50 | Wilkin, Minnesota, US | |
3001087 | 3001087 | 2022-05-24 | US | Minnesota | Wilkin | 27167 | 1670 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-05-25 04:20:56 | Wilkin, Minnesota, US | |
623660 | 623660 | 2022-05-22 | US | Minnesota | Wilkin | 27167 | 1670 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-05-26 04:20:50 | Wilkin, Minnesota, US | |
1184547 | 1184547 | 2022-05-18 | China | Liaoning | 1670 | 2 | 0 | 41.2956 | 122.6085 | 2022-05-19 04:20:54 | Liaoning, China | |||
3582444 | 3582444 | 2022-05-17 | China | Liaoning | 1670 | 2 | 0 | 41.2956 | 122.6085 | 2022-05-18 04:20:50 | Liaoning, China | |||
1503401 | 1503401 | 2022-05-16 | China | Liaoning | 1670 | 2 | 0 | 41.2956 | 122.6085 | 2022-05-17 04:20:59 | Liaoning, China | |||
2084568 | 2084568 | 2022-05-15 | US | Colorado | Clear Creek | 8019 | 1670 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-05-16 04:20:47 | Clear Creek, Colorado, US | |
2083760 | 2083760 | 2022-05-15 | China | Liaoning | 1670 | 2 | 0 | 41.2956 | 122.6085 | 2022-05-16 04:20:47 | Liaoning, China | |||
3268041 | 3268041 | 2022-05-04 | US | Oklahoma | Coal | 40029 | 1670 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-05-05 04:20:55 | Coal, Oklahoma, US | |
1574680 | 1574680 | 2022-05-03 | US | Oklahoma | Coal | 40029 | 1670 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-05-04 04:20:59 | Coal, Oklahoma, US | |
465940 | 465940 | 2022-05-02 | US | Oklahoma | Coal | 40029 | 1670 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-05-03 04:21:00 | Coal, Oklahoma, US | |
3918579 | 3918579 | 2022-05-01 | US | Oklahoma | Coal | 40029 | 1670 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-05-02 04:21:10 | Coal, Oklahoma, US | |
2843383 | 2843383 | 2022-04-30 | US | Oklahoma | Coal | 40029 | 1670 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-05-01 04:20:57 | Coal, Oklahoma, US | |
1159696 | 1159696 | 2022-04-29 | US | Oklahoma | Coal | 40029 | 1670 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-04-30 04:21:05 | Coal, Oklahoma, US | |
1698878 | 1698878 | 2022-04-28 | US | Oklahoma | Coal | 40029 | 1670 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-04-29 04:20:59 | Coal, Oklahoma, US | |
3854361 | 3854361 | 2022-04-27 | US | Oklahoma | Coal | 40029 | 1670 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-04-28 04:20:47 | Coal, Oklahoma, US | |
1328791 | 1328791 | 2022-04-26 | US | Oklahoma | Coal | 40029 | 1670 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-04-27 04:20:52 | Coal, Oklahoma, US | |
3724745 | 3724745 | 2022-04-25 | US | Oklahoma | Coal | 40029 | 1670 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-04-26 04:20:51 | Coal, Oklahoma, US | |
2031313 | 2031313 | 2022-04-24 | US | Oklahoma | Coal | 40029 | 1670 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-04-25 04:20:56 | Coal, Oklahoma, US | |
748888 | 748888 | 2022-04-23 | US | Oklahoma | Coal | 40029 | 1670 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-04-24 04:20:56 | Coal, Oklahoma, US | |
3439373 | 3439373 | 2022-04-22 | US | Oklahoma | Coal | 40029 | 1670 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-04-23 04:20:50 | Coal, Oklahoma, US | |
2894958 | 2894958 | 2022-04-21 | US | Oklahoma | Coal | 40029 | 1670 | 24 | 0 | 34.58840127 | -96.29798747 | 2022-04-22 04:20:45 | Coal, Oklahoma, US | |
2442936 | 2442936 | 2022-04-13 | Peru | Unknown | 1670 | 61 | 0 | 2022-04-13 23:21:06 | Unknown, Peru | |||||
3870165 | 3870165 | 2022-04-05 | US | Oregon | Grant | 41023 | 1670 | 20 | 0 | 44.49024544 | -119.0068631 | 2022-04-06 04:20:49 | Grant, Oregon, US | |
2751507 | 2751507 | 2022-04-04 | US | Oregon | Grant | 41023 | 1670 | 20 | 0 | 44.49024544 | -119.0068631 | 2022-04-05 04:20:48 | Grant, Oregon, US | |
3732853 | 3732853 | 2022-04-03 | US | Oregon | Grant | 41023 | 1670 | 20 | 0 | 44.49024544 | -119.0068631 | 2022-04-04 04:20:51 | Grant, Oregon, US | |
502288 | 502288 | 2022-04-02 | US | Oregon | Grant | 41023 | 1670 | 20 | 0 | 44.49024544 | -119.0068631 | 2022-04-03 04:20:48 | Grant, Oregon, US | |
3353273 | 3353273 | 2022-04-01 | US | Oregon | Grant | 41023 | 1670 | 20 | 0 | 44.49024544 | -119.0068631 | 2022-04-02 04:20:47 | Grant, Oregon, US | |
1513147 | 1513147 | 2022-02-24 | US | Minnesota | Mahnomen | 27087 | 1670 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-02-25 04:21:11 | Mahnomen, Minnesota, US | |
233779 | 233779 | 2022-02-11 | US | Arkansas | Woodruff | 5147 | 1670 | 24 | 0 | 35.18902527 | -91.2439489 | 2022-02-12 04:21:06 | Woodruff, Arkansas, US | |
3074697 | 3074697 | 2022-02-09 | US | Colorado | Rio Blanco | 8103 | 1670 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-02-10 04:21:14 | Rio Blanco, Colorado, US | |
1362834 | 1362834 | 2022-02-08 | US | Arkansas | Dallas | 5039 | 1670 | 23 | 0 | 33.97042763 | -92.65167437 | 2022-02-09 04:21:04 | Dallas, Arkansas, US | |
981932 | 981932 | 2022-02-01 | US | Tennessee | Pickett | 47137 | 1670 | 30 | 0 | 36.55606529 | -85.07763299999998 | 2022-02-02 04:21:09 | Pickett, Tennessee, US | |
980243 | 980243 | 2022-02-01 | US | Kansas | Greenwood | 20073 | 1670 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-02-02 04:21:09 | Greenwood, Kansas, US | |
2661154 | 2661154 | 2022-01-31 | US | Virginia | Lancaster | 51103 | 1670 | 24 | 0 | 37.71889653 | -76.46400482 | 2022-02-01 04:21:11 | Lancaster, Virginia, US | |
2659085 | 2659085 | 2022-01-31 | US | Kansas | Greenwood | 20073 | 1670 | 20 | 0 | 37.8774388 | -96.23250453 | 2022-02-01 04:21:11 | Greenwood, Kansas, US | |
3812676 | 3812676 | 2022-01-28 | US | Puerto Rico | Guayanilla | 72059 | 1670 | 0 | 0 | 18.039942 | -66.79186 | 2022-01-29 04:21:10 | Guayanilla, Puerto Rico, US | |
1320201 | 1320201 | 2022-01-26 | US | Montana | Blaine | 30005 | 1670 | 28 | 0 | 48.43175214 | -108.9582723 | 2022-01-27 04:21:19 | Blaine, Montana, US | |
1144138 | 1144138 | 2022-01-23 | US | Texas | Stephens | 48429 | 1670 | 39 | 0 | 32.73553157 | -98.83631615 | 2022-01-24 04:21:12 | Stephens, Texas, US | |
3688259 | 3688259 | 2022-01-13 | US | Georgia | Clinch | 13065 | 1670 | 36 | 0 | 30.91395822 | -82.70432472 | 2022-01-14 04:21:54 | Clinch, Georgia, US | |
3688006 | 3688006 | 2022-01-13 | US | Arkansas | Searcy | 5129 | 1670 | 33 | 0 | 35.9109364 | -92.69936482 | 2022-01-14 04:21:54 | Searcy, Arkansas, US | |
1115574 | 1115574 | 2022-01-11 | US | Montana | Beaverhead | 30001 | 1670 | 23 | 0 | 45.13434354 | -112.89846940000001 | 2022-01-12 04:21:44 | Beaverhead, Montana, US | |
127562 | 127562 | 2022-01-09 | US | Georgia | Johnson | 13167 | 1670 | 64 | 0 | 32.70211082 | -82.66166794 | 2022-01-10 04:22:07 | Johnson, Georgia, US | |
1218772 | 1218772 | 2022-01-08 | US | Texas | Red River | 48387 | 1670 | 58 | 0 | 33.61886692 | -95.04841765 | 2022-01-09 04:21:46 | Red River, Texas, US | |
1216397 | 1216397 | 2022-01-08 | US | Georgia | Johnson | 13167 | 1670 | 64 | 0 | 32.70211082 | -82.66166794 | 2022-01-09 04:21:46 | Johnson, Georgia, US | |
1390490 | 1390490 | 2022-01-07 | US | Georgia | Johnson | 13167 | 1670 | 64 | 0 | 32.70211082 | -82.66166794 | 2022-01-08 04:21:53 | Johnson, Georgia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);