johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
309 rows where confirmed = 1822 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3379769 | 3379769 | 2022-12-08 | US | North Dakota | Bottineau | 38009 | 1822 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-12-09 04:21:05 | Bottineau, North Dakota, US | |
850234 | 850234 | 2022-11-02 | US | Colorado | Kit Carson | 8063 | 1822 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-11-03 04:22:05 | Kit Carson, Colorado, US | |
711085 | 711085 | 2022-11-01 | US | Colorado | Kit Carson | 8063 | 1822 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-11-02 04:22:09 | Kit Carson, Colorado, US | |
3285534 | 3285534 | 2022-10-31 | US | Colorado | Kit Carson | 8063 | 1822 | 33 | 0 | 39.30497777 | -102.6022199 | 2022-11-01 04:22:36 | Kit Carson, Colorado, US | |
2758157 | 2758157 | 2022-10-18 | US | Iowa | Pocahontas | 19151 | 1822 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-10-19 04:22:26 | Pocahontas, Iowa, US | |
2025991 | 2025991 | 2022-10-17 | US | Iowa | Pocahontas | 19151 | 1822 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-10-18 04:22:42 | Pocahontas, Iowa, US | |
2160769 | 2160769 | 2022-10-16 | US | Iowa | Pocahontas | 19151 | 1822 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-10-17 04:20:31 | Pocahontas, Iowa, US | |
516966 | 516966 | 2022-10-15 | US | Iowa | Pocahontas | 19151 | 1822 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-10-16 04:22:39 | Pocahontas, Iowa, US | |
2034023 | 2034023 | 2022-10-14 | US | Iowa | Pocahontas | 19151 | 1822 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-10-15 04:22:00 | Pocahontas, Iowa, US | |
3754711 | 3754711 | 2022-10-13 | US | Iowa | Pocahontas | 19151 | 1822 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-10-14 04:22:28 | Pocahontas, Iowa, US | |
3215536 | 3215536 | 2022-10-12 | US | Iowa | Pocahontas | 19151 | 1822 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-10-13 04:22:39 | Pocahontas, Iowa, US | |
3250591 | 3250591 | 2022-10-11 | US | Alaska | Unassigned | 90002 | 1822 | 0 | 0 | 69.31479216 | 0.0 | 2022-10-12 04:22:51 | Unassigned, Alaska, US | |
2967850 | 2967850 | 2022-10-10 | US | Alaska | Unassigned | 90002 | 1822 | 0 | 0 | 69.31479216 | 0.0 | 2022-10-11 04:23:05 | Unassigned, Alaska, US | |
3097886 | 3097886 | 2022-10-09 | US | Alaska | Unassigned | 90002 | 1822 | 0 | 0 | 69.31479216 | 0.0 | 2022-10-10 04:22:32 | Unassigned, Alaska, US | |
4003111 | 4003111 | 2022-10-08 | US | Alaska | Unassigned | 90002 | 1822 | 0 | 0 | 69.31479216 | 0.0 | 2022-10-09 04:21:16 | Unassigned, Alaska, US | |
396708 | 396708 | 2022-10-07 | US | Alaska | Unassigned | 90002 | 1822 | 0 | 0 | 69.31479216 | 0.0 | 2022-10-08 04:22:56 | Unassigned, Alaska, US | |
2529825 | 2529825 | 2022-10-06 | US | Alaska | Unassigned | 90002 | 1822 | 0 | 0 | 69.31479216 | 0.0 | 2022-10-07 04:23:08 | Unassigned, Alaska, US | |
1811219 | 1811219 | 2022-10-05 | US | Alaska | Unassigned | 90002 | 1822 | 0 | 0 | 69.31479216 | 0.0 | 2022-10-06 04:21:22 | Unassigned, Alaska, US | |
3747733 | 3747733 | 2022-09-07 | US | Oregon | Harney | 41025 | 1822 | 41 | 0 | 43.06422669 | -118.9666306 | 2022-09-08 04:21:02 | Harney, Oregon, US | |
1877596 | 1877596 | 2022-08-28 | US | Colorado | Clear Creek | 8019 | 1822 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-08-29 04:21:06 | Clear Creek, Colorado, US | |
2096723 | 2096723 | 2022-08-27 | US | Colorado | Clear Creek | 8019 | 1822 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-08-28 04:21:02 | Clear Creek, Colorado, US | |
1532538 | 1532538 | 2022-08-26 | US | Colorado | Clear Creek | 8019 | 1822 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-08-27 04:20:57 | Clear Creek, Colorado, US | |
2829425 | 2829425 | 2022-08-25 | US | Colorado | Clear Creek | 8019 | 1822 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-08-26 04:21:02 | Clear Creek, Colorado, US | |
2323958 | 2323958 | 2022-08-24 | US | Colorado | Clear Creek | 8019 | 1822 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-08-25 04:21:13 | Clear Creek, Colorado, US | |
3406906 | 3406906 | 2022-07-17 | US | Kentucky | Menifee | 21165 | 1822 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-07-18 04:20:59 | Menifee, Kentucky, US | |
2153106 | 2153106 | 2022-07-16 | US | Kentucky | Menifee | 21165 | 1822 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-07-17 04:21:15 | Menifee, Kentucky, US | |
2420339 | 2420339 | 2022-07-15 | US | Kentucky | Menifee | 21165 | 1822 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-07-16 04:21:05 | Menifee, Kentucky, US | |
3430414 | 3430414 | 2022-07-14 | US | Kentucky | Menifee | 21165 | 1822 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-07-15 04:20:53 | Menifee, Kentucky, US | |
3110934 | 3110934 | 2022-07-13 | US | Kentucky | Menifee | 21165 | 1822 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-07-14 04:20:57 | Menifee, Kentucky, US | |
631357 | 631357 | 2022-07-12 | US | Kentucky | Menifee | 21165 | 1822 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-07-13 04:20:58 | Menifee, Kentucky, US | |
1213001 | 1213001 | 2022-07-11 | US | Kentucky | Menifee | 21165 | 1822 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-07-12 04:20:51 | Menifee, Kentucky, US | |
2240617 | 2240617 | 2022-06-28 | US | Iowa | Lucas | 19117 | 1822 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-06-29 04:20:59 | Lucas, Iowa, US | |
2240052 | 2240052 | 2022-06-28 | US | Colorado | Rio Blanco | 8103 | 1822 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-06-29 04:20:59 | Rio Blanco, Colorado, US | |
2148859 | 2148859 | 2022-06-27 | US | Iowa | Lucas | 19117 | 1822 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-06-28 04:20:58 | Lucas, Iowa, US | |
476660 | 476660 | 2022-06-26 | US | Iowa | Lucas | 19117 | 1822 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-06-27 04:21:00 | Lucas, Iowa, US | |
940035 | 940035 | 2022-06-25 | US | Iowa | Lucas | 19117 | 1822 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-06-26 04:21:02 | Lucas, Iowa, US | |
3347855 | 3347855 | 2022-06-24 | US | Iowa | Lucas | 19117 | 1822 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-06-25 04:20:57 | Lucas, Iowa, US | |
1649596 | 1649596 | 2022-06-23 | US | Iowa | Lucas | 19117 | 1822 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-06-24 04:20:58 | Lucas, Iowa, US | |
2188831 | 2188831 | 2022-06-22 | US | Iowa | Lucas | 19117 | 1822 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-06-23 04:20:55 | Lucas, Iowa, US | |
3400410 | 3400410 | 2022-06-18 | US | Tennessee | Pickett | 47137 | 1822 | 36 | 0 | 36.55606529 | -85.077633 | 2022-06-19 04:20:51 | Pickett, Tennessee, US | |
3729526 | 3729526 | 2022-06-07 | US | Virginia | Bland | 51021 | 1822 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-06-08 04:20:55 | Bland, Virginia, US | |
3890928 | 3890928 | 2022-06-06 | US | Virginia | Bland | 51021 | 1822 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-06-07 04:21:08 | Bland, Virginia, US | |
1579529 | 1579529 | 2022-04-10 | US | Virginia | Middlesex | 51119 | 1822 | 46 | 0 | 37.63191998 | -76.55064617 | 2022-04-11 04:21:02 | Middlesex, Virginia, US | |
1575936 | 1575936 | 2022-04-10 | China | Beijing | 1822 | 9 | 0 | 40.1824 | 116.4142 | 2022-04-11 04:21:02 | Beijing, China | |||
1655771 | 1655771 | 2022-04-09 | US | Virginia | Middlesex | 51119 | 1822 | 46 | 0 | 37.63191998 | -76.55064617 | 2022-04-10 04:20:52 | Middlesex, Virginia, US | |
2119093 | 2119093 | 2022-04-08 | US | Virginia | Middlesex | 51119 | 1822 | 46 | 0 | 37.63191998 | -76.55064617 | 2022-04-09 04:20:42 | Middlesex, Virginia, US | |
3323617 | 3323617 | 2022-04-07 | US | Virginia | Middlesex | 51119 | 1822 | 46 | 0 | 37.63191998 | -76.55064617 | 2022-04-08 04:20:48 | Middlesex, Virginia, US | |
2804153 | 2804153 | 2022-04-06 | US | Virginia | Middlesex | 51119 | 1822 | 46 | 0 | 37.63191998 | -76.55064617 | 2022-04-07 04:20:53 | Middlesex, Virginia, US | |
1438715 | 1438715 | 2022-03-28 | US | Nebraska | Wayne | 31179 | 1822 | 7 | 0 | 42.20934475 | -97.11926964 | 2022-03-29 04:20:46 | Wayne, Nebraska, US | |
338680 | 338680 | 2022-03-18 | US | Puerto Rico | Guayanilla | 72059 | 1822 | 0 | 0 | 18.039942 | -66.79186 | 2022-03-19 04:20:47 | Guayanilla, Puerto Rico, US | |
697615 | 697615 | 2022-03-17 | US | Texas | Stephens | 48429 | 1822 | 45 | 0 | 32.73553157 | -98.83631615 | 2022-03-18 04:20:55 | Stephens, Texas, US | |
2322102 | 2322102 | 2022-03-16 | US | Puerto Rico | Patillas | 72109 | 1822 | 0 | 0 | 18.03174 | -66.012242 | 2022-03-17 04:20:56 | Patillas, Puerto Rico, US | |
2142305 | 2142305 | 2022-03-09 | US | Nebraska | Wayne | 31179 | 1822 | 7 | 0 | 42.20934475 | -97.11926964 | 2022-03-10 04:20:48 | Wayne, Nebraska, US | |
578033 | 578033 | 2022-02-25 | US | Texas | Rains | 48379 | 1822 | 56 | 0 | 32.87109387 | -95.79232691 | 2022-02-26 04:21:12 | Rains, Texas, US | |
2016223 | 2016223 | 2022-02-06 | US | West Virginia | Tucker | 54093 | 1822 | 33 | 0 | 39.11240885 | -79.57053576 | 2022-02-07 04:21:05 | Tucker, West Virginia, US | |
2477569 | 2477569 | 2022-02-03 | US | Wyoming | Platte | 56031 | 1822 | 38 | 0 | 42.13299116 | -104.96633100000001 | 2022-02-04 04:21:10 | Platte, Wyoming, US | |
2477462 | 2477462 | 2022-02-03 | US | West Virginia | Pocahontas | 54075 | 1822 | 25 | 0 | 38.32758728 | -80.00993811 | 2022-02-04 04:21:10 | Pocahontas, West Virginia, US | |
1782474 | 1782474 | 2022-01-27 | US | Texas | Floyd | 48153 | 1822 | 42 | 0 | 34.07227468 | -101.3031546 | 2022-01-28 04:21:09 | Floyd, Texas, US | |
1319097 | 1319097 | 2022-01-26 | US | Georgia | Terrell | 13273 | 1822 | 59 | 0 | 31.77527543 | -84.44069698 | 2022-01-27 04:21:19 | Terrell, Georgia, US | |
1475165 | 1475165 | 2022-01-17 | US | Texas | Clay | 48077 | 1822 | 26 | 0 | 33.78686685 | -98.20771198 | 2022-01-18 04:21:04 | Clay, Texas, US | |
3843744 | 3843744 | 2022-01-15 | US | Texas | Terry | 48445 | 1822 | 74 | 0 | 33.17402785 | -102.3354521 | 2022-01-16 04:21:12 | Terry, Texas, US | |
102352 | 102352 | 2022-01-14 | US | Texas | Blanco | 48031 | 1822 | 28 | 0 | 30.26640707 | -98.3999852 | 2022-01-15 04:21:07 | Blanco, Texas, US | |
127577 | 127577 | 2022-01-09 | US | Georgia | McIntosh | 13191 | 1822 | 33 | 0 | 31.49683595 | -81.40163426 | 2022-01-10 04:22:07 | McIntosh, Georgia, US | |
1216412 | 1216412 | 2022-01-08 | US | Georgia | McIntosh | 13191 | 1822 | 33 | 0 | 31.49683595 | -81.40163426 | 2022-01-09 04:21:46 | McIntosh, Georgia, US | |
1390505 | 1390505 | 2022-01-07 | US | Georgia | McIntosh | 13191 | 1822 | 33 | 0 | 31.49683595 | -81.40163426 | 2022-01-08 04:21:53 | McIntosh, Georgia, US | |
1389682 | 1389682 | 2022-01-07 | Japan | Shimane | 1822 | 5 | 0 | 35.07076 | 132.55406399999998 | 2022-01-08 04:21:53 | Shimane, Japan | |||
2610892 | 2610892 | 2022-01-06 | US | Georgia | McIntosh | 13191 | 1822 | 33 | 0 | 31.49683595 | -81.40163426 | 2022-01-07 04:22:09 | McIntosh, Georgia, US | |
1283435 | 1283435 | 2022-01-05 | US | Kentucky | McLean | 21149 | 1822 | 44 | 0 | 37.5301951 | -87.26803443 | 2022-01-06 04:22:09 | McLean, Kentucky, US | |
1282834 | 1282834 | 2022-01-05 | US | Georgia | McIntosh | 13191 | 1822 | 33 | 0 | 31.49683595 | -81.40163426 | 2022-01-06 04:22:09 | McIntosh, Georgia, US | |
1703690 | 1703690 | 2022-01-03 | US | Virginia | Franklin City | 51620 | 1822 | 44 | 0 | 36.6831435 | -76.93859681 | 2022-01-04 04:22:17 | Franklin City, Virginia, US | |
3520705 | 3520705 | 2022-01-02 | US | Kansas | Cloud | 20029 | 1822 | 33 | 0 | 39.48028352 | -97.64925343 | 2022-01-03 02:22:25 | Cloud, Kansas, US | |
2168835 | 2168835 | 2022-01-01 | US | Kansas | Cloud | 20029 | 1822 | 33 | 0 | 39.48028352 | -97.64925343 | 2022-01-02 04:20:52 | Cloud, Kansas, US | |
2778266 | 2778266 | 2021-12-31 | US | Kansas | Cloud | 20029 | 1822 | 33 | 0 | 39.48028352 | -97.64925343 | 2022-01-01 04:22:14 | Cloud, Kansas, US | |
4002051 | 4002051 | 2021-12-30 | US | Virginia | Richmond | 51159 | 1822 | 17 | 0 | 37.937575 | -76.72920628 | 2021-12-31 04:21:50 | Richmond, Virginia, US | |
3999923 | 3999923 | 2021-12-30 | US | Kansas | Cloud | 20029 | 1822 | 33 | 0 | 39.48028352 | -97.64925343 | 2021-12-31 04:21:50 | Cloud, Kansas, US | |
1669730 | 1669730 | 2021-12-29 | US | Kansas | Cloud | 20029 | 1822 | 33 | 0 | 39.48028352 | -97.64925343 | 2021-12-30 04:21:25 | Cloud, Kansas, US | |
1668869 | 1668869 | 2021-12-29 | US | Alabama | Wilcox | 1131 | 1822 | 38 | 0 | 31.98773215 | -87.30891118 | 2021-12-30 04:21:25 | Wilcox, Alabama, US | |
1432953 | 1432953 | 2021-12-28 | US | Alabama | Lowndes | 1085 | 1822 | 68 | 0 | 32.1597283 | -86.65158371 | 2021-12-29 03:21:43 | Lowndes, Alabama, US | |
732319 | 732319 | 2021-12-27 | US | Mississippi | Carroll | 28015 | 1822 | 41 | 0 | 33.44834567 | -89.91994479 | 2021-12-28 04:21:47 | Carroll, Mississippi, US | |
3817293 | 3817293 | 2021-12-23 | US | Georgia | Screven | 13251 | 1822 | 62 | 0 | 32.74976524 | -81.60779441 | 2021-12-24 04:21:34 | Screven, Georgia, US | |
801169 | 801169 | 2021-12-22 | US | Puerto Rico | Fajardo | 72053 | 1822 | 0 | 0 | 18.318373 | -65.666866 | 2021-12-23 04:21:21 | Fajardo, Puerto Rico, US | |
1256535 | 1256535 | 2021-12-20 | US | Minnesota | Rock | 27133 | 1822 | 32 | 0 | 43.67482683 | -96.25296832 | 2021-12-21 03:21:27 | Rock, Minnesota, US | |
2906446 | 2906446 | 2021-12-19 | US | Puerto Rico | Cayey | 72035 | 1822 | 0 | 0 | 18.102851 | -66.14914 | 2021-12-20 04:21:43 | Cayey, Puerto Rico, US | |
1718000 | 1718000 | 2021-12-16 | US | Michigan | Iron | 26071 | 1822 | 70 | 0 | 46.20974132 | -88.53136251 | 2021-12-17 04:22:14 | Iron, Michigan, US | |
3497834 | 3497834 | 2021-12-15 | US | Michigan | Iron | 26071 | 1822 | 70 | 0 | 46.20974132 | -88.53136251 | 2021-12-16 04:22:11 | Iron, Michigan, US | |
2089537 | 2089537 | 2021-12-14 | US | Maine | Piscataquis | 23021 | 1822 | 15 | 0 | 45.83839062 | -69.2860223 | 2021-12-15 03:22:16 | Piscataquis, Maine, US | |
783277 | 783277 | 2021-12-13 | US | Georgia | Towns | 13281 | 1822 | 84 | 0 | 34.91369188 | -83.74107459999998 | 2021-12-14 04:22:38 | Towns, Georgia, US | |
551420 | 551420 | 2021-12-08 | US | Colorado | Park | 8093 | 1822 | 15 | 0 | 39.120926000000004 | -105.7182065 | 2021-12-09 04:22:49 | Park, Colorado, US | |
3292244 | 3292244 | 2021-11-18 | US | Virginia | Dickenson | 51051 | 1822 | 29 | 0 | 37.12560977 | -82.35124171 | 2021-11-19 04:21:40 | Dickenson, Virginia, US | |
450992 | 450992 | 2021-11-17 | US | Wyoming | Washakie | 56043 | 1822 | 35 | 0 | 43.90451606 | -107.68018700000002 | 2021-11-18 04:21:33 | Washakie, Wyoming, US | |
3345214 | 3345214 | 2021-11-16 | US | Oklahoma | Pushmataha | 40127 | 1822 | 40 | 0 | 34.41635232 | -95.37603505 | 2021-11-17 04:21:48 | Pushmataha, Oklahoma, US | |
3342983 | 3342983 | 2021-11-16 | US | Alabama | Coosa | 1037 | 1822 | 43 | 0 | 32.93690146 | -86.24847739 | 2021-11-17 04:21:48 | Coosa, Alabama, US | |
2290050 | 2290050 | 2021-11-15 | US | Oklahoma | Pushmataha | 40127 | 1822 | 40 | 0 | 34.41635232 | -95.37603505 | 2021-11-16 04:21:10 | Pushmataha, Oklahoma, US | |
1324824 | 1324824 | 2021-11-14 | US | Oklahoma | Pushmataha | 40127 | 1822 | 40 | 0 | 34.41635232 | -95.37603505 | 2021-11-15 04:21:36 | Pushmataha, Oklahoma, US | |
688950 | 688950 | 2021-11-13 | US | Oklahoma | Pushmataha | 40127 | 1822 | 40 | 0 | 34.41635232 | -95.37603505 | 2021-11-14 04:21:31 | Pushmataha, Oklahoma, US | |
717059 | 717059 | 2021-11-12 | US | Oklahoma | Pushmataha | 40127 | 1822 | 40 | 0 | 34.41635232 | -95.37603505 | 2021-11-13 04:21:38 | Pushmataha, Oklahoma, US | |
29890 | 29890 | 2021-11-11 | US | Kentucky | Todd | 21219 | 1822 | 32 | 0 | 36.8381152 | -87.17878374 | 2021-11-12 04:22:01 | Todd, Kentucky, US | |
496014 | 496014 | 2021-11-06 | US | Alabama | Coosa | 1037 | 1822 | 43 | 0 | 32.93690146 | -86.24847739 | 2021-11-07 04:21:53 | Coosa, Alabama, US | |
698084 | 698084 | 2021-11-04 | Australia | Australian Capital Territory | 1822 | 14 | 0 | -35.4735 | 149.0124 | 2021-11-05 04:21:54 | Australian Capital Territory, Australia | |||
3514444 | 3514444 | 2021-11-01 | US | Texas | Callahan | 48059 | 1822 | 55 | 0 | 32.29760619 | -99.37326312 | 2021-11-02 04:22:03 | Callahan, Texas, 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]);