johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
404 rows where confirmed = 1606 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756225 | 2756225 | 2022-12-29 | US | Virginia | Charles City | 51036 | 1606 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-12-30 04:21:04 | Charles City, Virginia, US | |
1077231 | 1077231 | 2022-12-28 | US | Virginia | Charles City | 51036 | 1606 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-12-29 04:21:01 | Charles City, Virginia, US | |
350728 | 350728 | 2022-12-14 | US | North Dakota | Sioux | 38085 | 1606 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-12-15 04:20:58 | Sioux, North Dakota, US | |
310316 | 310316 | 2022-12-13 | US | North Dakota | Sioux | 38085 | 1606 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-12-14 04:21:04 | Sioux, North Dakota, US | |
3997429 | 3997429 | 2022-09-27 | US | Puerto Rico | Vieques | 72147 | 1606 | 0 | 0 | 18.123276 | -65.440971 | 2022-09-28 04:23:01 | Vieques, Puerto Rico, US | |
2771757 | 2771757 | 2022-09-26 | US | Puerto Rico | Vieques | 72147 | 1606 | 0 | 0 | 18.123276 | -65.440971 | 2022-09-27 04:23:01 | Vieques, Puerto Rico, US | |
1979410 | 1979410 | 2022-09-25 | US | Puerto Rico | Vieques | 72147 | 1606 | 0 | 0 | 18.123276 | -65.440971 | 2022-09-26 04:20:52 | Vieques, Puerto Rico, US | |
2652577 | 2652577 | 2022-09-24 | US | Puerto Rico | Vieques | 72147 | 1606 | 0 | 0 | 18.123276 | -65.440971 | 2022-09-25 04:23:31 | Vieques, Puerto Rico, US | |
375585 | 375585 | 2022-09-13 | US | Virginia | Norton | 51720 | 1606 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-09-14 04:20:44 | Norton, Virginia, US | |
2398187 | 2398187 | 2022-09-12 | US | Virginia | Norton | 51720 | 1606 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-09-13 04:20:57 | Norton, Virginia, US | |
1682562 | 1682562 | 2022-08-29 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-30 04:21:03 | Clay, Nebraska, US | |
1879046 | 1879046 | 2022-08-28 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-29 04:21:06 | Clay, Nebraska, US | |
2098173 | 2098173 | 2022-08-27 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-28 04:21:02 | Clay, Nebraska, US | |
1533988 | 1533988 | 2022-08-26 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-27 04:20:57 | Clay, Nebraska, US | |
2830875 | 2830875 | 2022-08-25 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-26 04:21:02 | Clay, Nebraska, US | |
2325408 | 2325408 | 2022-08-24 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-25 04:21:13 | Clay, Nebraska, US | |
1252817 | 1252817 | 2022-08-23 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-24 04:20:46 | Clay, Nebraska, US | |
1252080 | 1252080 | 2022-08-23 | US | Kansas | Morris | 20127 | 1606 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-08-24 04:20:46 | Morris, Kansas, US | |
2856049 | 2856049 | 2022-08-22 | US | Texas | Newton | 48351 | 1606 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-08-23 04:20:56 | Newton, Texas, US | |
2854921 | 2854921 | 2022-08-22 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-23 04:20:56 | Clay, Nebraska, US | |
2854184 | 2854184 | 2022-08-22 | US | Kansas | Morris | 20127 | 1606 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-08-23 04:20:56 | Morris, Kansas, US | |
2404893 | 2404893 | 2022-08-21 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-22 04:20:38 | Clay, Nebraska, US | |
2404156 | 2404156 | 2022-08-21 | US | Kansas | Morris | 20127 | 1606 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-08-22 04:20:38 | Morris, Kansas, US | |
3799971 | 3799971 | 2022-08-20 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-21 04:20:44 | Clay, Nebraska, US | |
3799234 | 3799234 | 2022-08-20 | US | Kansas | Morris | 20127 | 1606 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-08-21 04:20:44 | Morris, Kansas, US | |
2365557 | 2365557 | 2022-08-19 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-20 04:21:01 | Clay, Nebraska, US | |
2364820 | 2364820 | 2022-08-19 | US | Kansas | Morris | 20127 | 1606 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-08-20 04:21:01 | Morris, Kansas, US | |
1164299 | 1164299 | 2022-08-18 | US | Texas | Jack | 48237 | 1606 | 30 | 0 | 33.23377248 | -98.17283469 | 2022-08-19 04:20:54 | Jack, Texas, US | |
1163228 | 1163228 | 2022-08-18 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-19 04:20:54 | Clay, Nebraska, US | |
1162491 | 1162491 | 2022-08-18 | US | Kansas | Morris | 20127 | 1606 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-08-19 04:20:54 | Morris, Kansas, US | |
3952552 | 3952552 | 2022-08-17 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-18 04:21:11 | Clay, Nebraska, US | |
3951815 | 3951815 | 2022-08-17 | US | Kansas | Morris | 20127 | 1606 | 30 | 0 | 38.68827511 | -96.65128437 | 2022-08-18 04:21:11 | Morris, Kansas, US | |
994320 | 994320 | 2022-08-16 | US | Virginia | Covington | 51580 | 1606 | 28 | 0 | 37.7824656 | -79.98631446 | 2022-08-17 04:20:59 | Covington, Virginia, US | |
993054 | 993054 | 2022-08-16 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-17 04:20:59 | Clay, Nebraska, US | |
2496093 | 2496093 | 2022-08-15 | US | Nebraska | Clay | 31035 | 1606 | 25 | 0 | 40.52439441 | -98.05126296 | 2022-08-16 04:20:58 | Clay, Nebraska, US | |
3648575 | 3648575 | 2022-08-14 | US | Illinois | Gallatin | 17059 | 1606 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-08-15 04:20:59 | Gallatin, Illinois, US | |
1969581 | 1969581 | 2022-08-13 | US | Illinois | Gallatin | 17059 | 1606 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-08-14 04:20:55 | Gallatin, Illinois, US | |
2889390 | 2889390 | 2022-08-12 | US | Illinois | Gallatin | 17059 | 1606 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-08-13 04:20:52 | Gallatin, Illinois, US | |
3619478 | 3619478 | 2022-08-01 | US | North Dakota | Dickey | 38021 | 1606 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-08-02 04:20:53 | Dickey, North Dakota, US | |
960250 | 960250 | 2022-07-19 | US | Kansas | Stevens | 20189 | 1606 | 23 | 0 | 37.1923008 | -101.3118967 | 2022-07-20 04:20:59 | Stevens, Kansas, US | |
3211637 | 3211637 | 2022-07-18 | US | Kansas | Stevens | 20189 | 1606 | 23 | 0 | 37.1923008 | -101.3118967 | 2022-07-19 04:20:58 | Stevens, Kansas, US | |
3406918 | 3406918 | 2022-07-17 | US | Kentucky | Owsley | 21189 | 1606 | 30 | 0 | 37.42823949 | -83.68811419 | 2022-07-18 04:20:59 | Owsley, Kentucky, US | |
3406812 | 3406812 | 2022-07-17 | US | Kansas | Stevens | 20189 | 1606 | 23 | 0 | 37.1923008 | -101.3118967 | 2022-07-18 04:20:59 | Stevens, Kansas, US | |
2153118 | 2153118 | 2022-07-16 | US | Kentucky | Owsley | 21189 | 1606 | 30 | 0 | 37.42823949 | -83.68811419 | 2022-07-17 04:21:15 | Owsley, Kentucky, US | |
2153012 | 2153012 | 2022-07-16 | US | Kansas | Stevens | 20189 | 1606 | 23 | 0 | 37.1923008 | -101.3118967 | 2022-07-17 04:21:15 | Stevens, Kansas, US | |
2420351 | 2420351 | 2022-07-15 | US | Kentucky | Owsley | 21189 | 1606 | 30 | 0 | 37.42823949 | -83.68811419 | 2022-07-16 04:21:05 | Owsley, Kentucky, US | |
2420245 | 2420245 | 2022-07-15 | US | Kansas | Stevens | 20189 | 1606 | 23 | 0 | 37.1923008 | -101.3118967 | 2022-07-16 04:21:05 | Stevens, Kansas, US | |
3430426 | 3430426 | 2022-07-14 | US | Kentucky | Owsley | 21189 | 1606 | 30 | 0 | 37.42823949 | -83.68811419 | 2022-07-15 04:20:53 | Owsley, Kentucky, US | |
3430320 | 3430320 | 2022-07-14 | US | Kansas | Stevens | 20189 | 1606 | 23 | 0 | 37.1923008 | -101.3118967 | 2022-07-15 04:20:53 | Stevens, Kansas, US | |
3110946 | 3110946 | 2022-07-13 | US | Kentucky | Owsley | 21189 | 1606 | 30 | 0 | 37.42823949 | -83.68811419 | 2022-07-14 04:20:57 | Owsley, Kentucky, US | |
3110840 | 3110840 | 2022-07-13 | US | Kansas | Stevens | 20189 | 1606 | 23 | 0 | 37.1923008 | -101.3118967 | 2022-07-14 04:20:57 | Stevens, Kansas, US | |
631369 | 631369 | 2022-07-12 | US | Kentucky | Owsley | 21189 | 1606 | 30 | 0 | 37.42823949 | -83.68811419 | 2022-07-13 04:20:58 | Owsley, Kentucky, US | |
1213013 | 1213013 | 2022-07-11 | US | Kentucky | Owsley | 21189 | 1606 | 30 | 0 | 37.42823949 | -83.68811419 | 2022-07-12 04:20:51 | Owsley, Kentucky, US | |
2242775 | 2242775 | 2022-06-28 | US | Virginia | Mathews | 51115 | 1606 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-06-29 04:20:59 | Mathews, Virginia, US | |
3000490 | 3000490 | 2022-05-24 | US | Iowa | Davis | 19051 | 1606 | 33 | 0 | 40.74773536 | -92.41005468 | 2022-05-25 04:20:56 | Davis, Iowa, US | |
3595417 | 3595417 | 2022-05-23 | US | North Dakota | Bottineau | 38009 | 1606 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-05-24 04:20:57 | Bottineau, North Dakota, US | |
3594211 | 3594211 | 2022-05-23 | US | Iowa | Davis | 19051 | 1606 | 33 | 0 | 40.74773536 | -92.41005468 | 2022-05-24 04:20:57 | Davis, Iowa, US | |
1110759 | 1110759 | 2022-05-21 | US | Iowa | Davis | 19051 | 1606 | 33 | 0 | 40.74773536 | -92.41005468 | 2022-05-22 04:20:52 | Davis, Iowa, US | |
1170383 | 1170383 | 2022-05-20 | US | Iowa | Davis | 19051 | 1606 | 33 | 0 | 40.74773536 | -92.41005468 | 2022-05-21 04:20:58 | Davis, Iowa, US | |
3897892 | 3897892 | 2022-05-19 | US | Missouri | Maries | 29125 | 1606 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-05-20 04:20:57 | Maries, Missouri, US | |
3897146 | 3897146 | 2022-05-19 | US | Iowa | Davis | 19051 | 1606 | 33 | 0 | 40.74773536 | -92.41005468 | 2022-05-20 04:20:57 | Davis, Iowa, US | |
1186676 | 1186676 | 2022-05-18 | US | Missouri | Maries | 29125 | 1606 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-05-19 04:20:54 | Maries, Missouri, US | |
1185930 | 1185930 | 2022-05-18 | US | Iowa | Davis | 19051 | 1606 | 33 | 0 | 40.74773536 | -92.41005468 | 2022-05-19 04:20:54 | Davis, Iowa, US | |
3584573 | 3584573 | 2022-05-17 | US | Missouri | Maries | 29125 | 1606 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-05-18 04:20:50 | Maries, Missouri, US | |
1505530 | 1505530 | 2022-05-16 | US | Missouri | Maries | 29125 | 1606 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-05-17 04:20:59 | Maries, Missouri, US | |
2085889 | 2085889 | 2022-05-15 | US | Missouri | Maries | 29125 | 1606 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-05-16 04:20:47 | Maries, Missouri, US | |
3356599 | 3356599 | 2022-05-14 | US | Missouri | Maries | 29125 | 1606 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-05-15 04:20:53 | Maries, Missouri, US | |
660244 | 660244 | 2022-05-13 | US | Missouri | Maries | 29125 | 1606 | 39 | 0 | 38.16193985 | -91.92249662 | 2022-05-14 04:20:48 | Maries, Missouri, US | |
1573370 | 1573370 | 2022-05-03 | US | Iowa | Pocahontas | 19151 | 1606 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-05-04 04:20:59 | Pocahontas, Iowa, US | |
466017 | 466017 | 2022-05-02 | US | Oregon | Harney | 41025 | 1606 | 38 | 0 | 43.06422669 | -118.9666306 | 2022-05-03 04:21:00 | Harney, Oregon, US | |
464630 | 464630 | 2022-05-02 | US | Iowa | Pocahontas | 19151 | 1606 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-05-03 04:21:00 | Pocahontas, Iowa, US | |
3918656 | 3918656 | 2022-05-01 | US | Oregon | Harney | 41025 | 1606 | 38 | 0 | 43.06422669 | -118.9666306 | 2022-05-02 04:21:10 | Harney, Oregon, US | |
3917269 | 3917269 | 2022-05-01 | US | Iowa | Pocahontas | 19151 | 1606 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-05-02 04:21:10 | Pocahontas, Iowa, US | |
2843460 | 2843460 | 2022-04-30 | US | Oregon | Harney | 41025 | 1606 | 38 | 0 | 43.06422669 | -118.9666306 | 2022-05-01 04:20:57 | Harney, Oregon, US | |
2842073 | 2842073 | 2022-04-30 | US | Iowa | Pocahontas | 19151 | 1606 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-05-01 04:20:57 | Pocahontas, Iowa, US | |
1159773 | 1159773 | 2022-04-29 | US | Oregon | Harney | 41025 | 1606 | 38 | 0 | 43.06422669 | -118.9666306 | 2022-04-30 04:21:05 | Harney, Oregon, US | |
1158386 | 1158386 | 2022-04-29 | US | Iowa | Pocahontas | 19151 | 1606 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-04-30 04:21:05 | Pocahontas, Iowa, US | |
1698955 | 1698955 | 2022-04-28 | US | Oregon | Harney | 41025 | 1606 | 38 | 0 | 43.06422669 | -118.9666306 | 2022-04-29 04:20:59 | Harney, Oregon, US | |
1697568 | 1697568 | 2022-04-28 | US | Iowa | Pocahontas | 19151 | 1606 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-04-29 04:20:59 | Pocahontas, Iowa, US | |
3854438 | 3854438 | 2022-04-27 | US | Oregon | Harney | 41025 | 1606 | 38 | 0 | 43.06422669 | -118.9666306 | 2022-04-28 04:20:47 | Harney, Oregon, US | |
3853051 | 3853051 | 2022-04-27 | US | Iowa | Pocahontas | 19151 | 1606 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-04-28 04:20:47 | Pocahontas, Iowa, US | |
3206068 | 3206068 | 2022-04-11 | China | Liaoning | 1606 | 2 | 0 | 41.2956 | 122.6085 | 2022-04-12 04:20:49 | Liaoning, China | |||
2479935 | 2479935 | 2022-03-30 | US | Missouri | Shannon | 29203 | 1606 | 38 | 0 | 37.15772072 | -91.40190382 | 2022-03-31 04:20:56 | Shannon, Missouri, US | |
159976 | 159976 | 2022-03-29 | US | Missouri | Shannon | 29203 | 1606 | 38 | 0 | 37.15772072 | -91.40190382 | 2022-03-30 04:20:45 | Shannon, Missouri, US | |
1905006 | 1905006 | 2022-03-22 | China | Sichuan | 1606 | 3 | 0 | 30.6171 | 102.7103 | 2022-03-23 04:20:48 | Sichuan, China | |||
359361 | 359361 | 2022-03-11 | US | Texas | Brooks | 48047 | 1606 | 51 | 0 | 27.03103197 | -98.21808402 | 2022-03-12 04:20:50 | Brooks, Texas, US | |
1868513 | 1868513 | 2022-03-10 | US | Texas | Brooks | 48047 | 1606 | 51 | 0 | 27.03103197 | -98.21808402 | 2022-03-11 04:20:50 | Brooks, Texas, US | |
2143208 | 2143208 | 2022-03-09 | US | Texas | Brooks | 48047 | 1606 | 51 | 0 | 27.03103197 | -98.21808402 | 2022-03-10 04:20:48 | Brooks, Texas, US | |
922719 | 922719 | 2022-03-08 | US | Texas | Brooks | 48047 | 1606 | 51 | 0 | 27.03103197 | -98.21808402 | 2022-03-09 04:20:59 | Brooks, Texas, US | |
1551006 | 1551006 | 2022-03-07 | US | Texas | Brooks | 48047 | 1606 | 51 | 0 | 27.03103197 | -98.21808402 | 2022-03-08 04:20:54 | Brooks, Texas, US | |
1548580 | 1548580 | 2022-03-07 | US | Colorado | Clear Creek | 8019 | 1606 | 11 | 0 | 39.68864463 | -105.6463118 | 2022-03-08 04:20:54 | Clear Creek, Colorado, US | |
2200249 | 2200249 | 2022-03-06 | US | Colorado | Clear Creek | 8019 | 1606 | 11 | 0 | 39.68864463 | -105.6463118 | 2022-03-07 04:20:47 | Clear Creek, Colorado, US | |
2092706 | 2092706 | 2022-03-05 | US | Colorado | Clear Creek | 8019 | 1606 | 11 | 0 | 39.68864463 | -105.6463118 | 2022-03-06 04:20:49 | Clear Creek, Colorado, US | |
2666406 | 2666406 | 2022-03-04 | US | Colorado | Clear Creek | 8019 | 1606 | 11 | 0 | 39.68864463 | -105.6463118 | 2022-03-05 04:21:10 | Clear Creek, Colorado, US | |
1644971 | 1644971 | 2022-03-03 | US | Colorado | Clear Creek | 8019 | 1606 | 11 | 0 | 39.68864463 | -105.6463118 | 2022-03-04 04:21:09 | Clear Creek, Colorado, US | |
1995712 | 1995712 | 2022-03-01 | US | Texas | Coleman | 48083 | 1606 | 69 | 0 | 31.76736834 | -99.45240766 | 2022-03-02 04:21:07 | Coleman, Texas, US | |
2447660 | 2447660 | 2022-02-22 | US | Georgia | Treutlen | 13283 | 1606 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-02-23 04:21:09 | Treutlen, Georgia, US | |
3719073 | 3719073 | 2022-02-21 | US | Georgia | Treutlen | 13283 | 1606 | 59 | 0 | 32.40422134 | -82.56904553 | 2022-02-22 04:21:01 | Treutlen, Georgia, US | |
1299411 | 1299411 | 2022-02-17 | US | Kansas | Wabaunsee | 20197 | 1606 | 22 | 0 | 38.95471985 | -96.20350509 | 2022-02-18 04:21:04 | Wabaunsee, Kansas, US | |
3821797 | 3821797 | 2022-02-16 | US | Kansas | Wabaunsee | 20197 | 1606 | 22 | 0 | 38.95471985 | -96.20350509 | 2022-02-17 04:20:56 | Wabaunsee, Kansas, 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]);