johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
338 rows where confirmed = 1779 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754257 | 2754257 | 2022-12-29 | US | Kansas | Sherman | 20181 | 1779 | 23 | 0 | 39.35147699 | -101.7197624 | 2022-12-30 04:21:04 | Sherman, Kansas, US | |
1075263 | 1075263 | 2022-12-28 | US | Kansas | Sherman | 20181 | 1779 | 23 | 0 | 39.35147699 | -101.7197624 | 2022-12-29 04:21:01 | Sherman, Kansas, US | |
331462 | 331462 | 2022-12-27 | US | Wisconsin | Iron | 55051 | 1779 | 49 | 0 | 46.26302338 | -90.24295041 | 2022-12-28 04:21:04 | Iron, Wisconsin, US | |
221535 | 221535 | 2022-12-26 | US | Wisconsin | Iron | 55051 | 1779 | 49 | 0 | 46.26302338 | -90.24295041 | 2022-12-27 04:21:07 | Iron, Wisconsin, US | |
3225992 | 3225992 | 2022-12-25 | US | Wisconsin | Iron | 55051 | 1779 | 49 | 0 | 46.26302338 | -90.24295041 | 2022-12-26 04:21:06 | Iron, Wisconsin, US | |
1021906 | 1021906 | 2022-12-24 | US | Wisconsin | Iron | 55051 | 1779 | 49 | 0 | 46.26302338 | -90.24295041 | 2022-12-25 04:21:04 | Iron, Wisconsin, US | |
693929 | 693929 | 2022-12-23 | US | Wisconsin | Iron | 55051 | 1779 | 49 | 0 | 46.26302338 | -90.24295041 | 2022-12-24 04:21:02 | Iron, Wisconsin, US | |
1049635 | 1049635 | 2022-11-06 | China | Hunan | 1779 | 4 | 0 | 27.6104 | 111.7088 | 2022-11-07 04:21:26 | Hunan, China | |||
2270301 | 2270301 | 2022-10-22 | US | North Dakota | Bottineau | 38009 | 1779 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-10-23 04:22:46 | Bottineau, North Dakota, US | |
3754445 | 3754445 | 2022-10-13 | US | Illinois | Calhoun | 17013 | 1779 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-10-14 04:22:28 | Calhoun, Illinois, US | |
1892520 | 1892520 | 2022-09-14 | US | Virginia | Mathews | 51115 | 1779 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-09-15 04:21:02 | Mathews, Virginia, US | |
3775141 | 3775141 | 2022-08-30 | US | Iowa | Pocahontas | 19151 | 1779 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-08-31 04:20:57 | Pocahontas, Iowa, US | |
1681737 | 1681737 | 2022-08-29 | US | Iowa | Pocahontas | 19151 | 1779 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-08-30 04:21:03 | Pocahontas, Iowa, US | |
1878221 | 1878221 | 2022-08-28 | US | Iowa | Pocahontas | 19151 | 1779 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-08-29 04:21:06 | Pocahontas, Iowa, US | |
2097348 | 2097348 | 2022-08-27 | US | Iowa | Pocahontas | 19151 | 1779 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-08-28 04:21:02 | Pocahontas, Iowa, US | |
1533163 | 1533163 | 2022-08-26 | US | Iowa | Pocahontas | 19151 | 1779 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-08-27 04:20:57 | Pocahontas, Iowa, US | |
2830050 | 2830050 | 2022-08-25 | US | Iowa | Pocahontas | 19151 | 1779 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-08-26 04:21:02 | Pocahontas, Iowa, US | |
2324583 | 2324583 | 2022-08-24 | US | Iowa | Pocahontas | 19151 | 1779 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-08-25 04:21:13 | Pocahontas, Iowa, US | |
1490753 | 1490753 | 2022-07-26 | US | Texas | Marion | 48315 | 1779 | 60 | 0 | 32.79868409 | -94.3566123 | 2022-07-27 04:21:04 | Marion, Texas, US | |
3110095 | 3110095 | 2022-07-13 | US | Colorado | Clear Creek | 8019 | 1779 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-07-14 04:20:57 | Clear Creek, Colorado, US | |
2239937 | 2239937 | 2022-06-28 | US | Arkansas | Woodruff | 5147 | 1779 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-06-29 04:20:59 | Woodruff, Arkansas, US | |
476891 | 476891 | 2022-06-26 | US | Kentucky | Menifee | 21165 | 1779 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-06-27 04:21:00 | Menifee, Kentucky, US | |
940266 | 940266 | 2022-06-25 | US | Kentucky | Menifee | 21165 | 1779 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-06-26 04:21:02 | Menifee, Kentucky, US | |
3348086 | 3348086 | 2022-06-24 | US | Kentucky | Menifee | 21165 | 1779 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-06-25 04:20:57 | Menifee, Kentucky, US | |
1649827 | 1649827 | 2022-06-23 | US | Kentucky | Menifee | 21165 | 1779 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-06-24 04:20:58 | Menifee, Kentucky, US | |
2189062 | 2189062 | 2022-06-22 | US | Kentucky | Menifee | 21165 | 1779 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-06-23 04:20:55 | Menifee, Kentucky, US | |
167493 | 167493 | 2022-06-21 | US | Kentucky | Menifee | 21165 | 1779 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-06-22 04:20:54 | Menifee, Kentucky, US | |
167030 | 167030 | 2022-06-21 | US | Illinois | Edwards | 17047 | 1779 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-06-22 04:20:54 | Edwards, Illinois, US | |
1765948 | 1765948 | 2022-06-20 | US | Oregon | Grant | 41023 | 1779 | 22 | 0 | 44.49024544 | -119.0068631 | 2022-06-21 04:20:56 | Grant, Oregon, US | |
1764776 | 1764776 | 2022-06-20 | US | Kentucky | Menifee | 21165 | 1779 | 32 | 0 | 37.94090733 | -83.59985712 | 2022-06-21 04:20:56 | Menifee, Kentucky, US | |
3272134 | 3272134 | 2022-06-19 | US | Oregon | Grant | 41023 | 1779 | 22 | 0 | 44.49024544 | -119.0068631 | 2022-06-20 04:21:01 | Grant, Oregon, US | |
3400046 | 3400046 | 2022-06-18 | US | Oregon | Grant | 41023 | 1779 | 22 | 0 | 44.49024544 | -119.0068631 | 2022-06-19 04:20:51 | Grant, Oregon, US | |
2313923 | 2313923 | 2022-06-17 | US | Oregon | Grant | 41023 | 1779 | 22 | 0 | 44.49024544 | -119.0068631 | 2022-06-18 04:21:10 | Grant, Oregon, US | |
561427 | 561427 | 2022-06-16 | US | Oregon | Grant | 41023 | 1779 | 22 | 0 | 44.49024544 | -119.0068631 | 2022-06-17 04:20:56 | Grant, Oregon, US | |
3135667 | 3135667 | 2022-06-03 | US | Nebraska | Richardson | 31147 | 1779 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-06-04 04:20:58 | Richardson, Nebraska, US | |
3580742 | 3580742 | 2022-06-02 | US | Nebraska | Richardson | 31147 | 1779 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-06-03 04:20:58 | Richardson, Nebraska, US | |
973035 | 973035 | 2022-06-01 | US | Nebraska | Richardson | 31147 | 1779 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-06-02 05:20:39 | Richardson, Nebraska, US | |
231342 | 231342 | 2022-05-31 | US | Nebraska | Richardson | 31147 | 1779 | 22 | 0 | 40.1247415 | -95.71755036 | 2022-06-01 04:20:55 | Richardson, Nebraska, US | |
1504210 | 1504210 | 2022-05-16 | US | Colorado | Conejos | 8021 | 1779 | 54 | 0 | 37.201606 | -106.1917488 | 2022-05-17 04:20:59 | Conejos, Colorado, US | |
2084569 | 2084569 | 2022-05-15 | US | Colorado | Conejos | 8021 | 1779 | 54 | 0 | 37.201606 | -106.1917488 | 2022-05-16 04:20:47 | Conejos, Colorado, US | |
3355279 | 3355279 | 2022-05-14 | US | Colorado | Conejos | 8021 | 1779 | 54 | 0 | 37.201606 | -106.1917488 | 2022-05-15 04:20:53 | Conejos, Colorado, US | |
658924 | 658924 | 2022-05-13 | US | Colorado | Conejos | 8021 | 1779 | 54 | 0 | 37.201606 | -106.1917488 | 2022-05-14 04:20:48 | Conejos, Colorado, US | |
2534007 | 2534007 | 2022-05-12 | US | Colorado | Conejos | 8021 | 1779 | 54 | 0 | 37.201606 | -106.1917488 | 2022-05-13 04:20:51 | Conejos, Colorado, US | |
2032077 | 2032077 | 2022-04-24 | US | Virginia | Bland | 51021 | 1779 | 23 | 0 | 37.13128068 | -81.13599391 | 2022-04-25 04:20:56 | Bland, Virginia, US | |
2031753 | 2031753 | 2022-04-24 | US | Tennessee | Pickett | 47137 | 1779 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-25 04:20:56 | Pickett, Tennessee, US | |
2030508 | 2030508 | 2022-04-24 | US | Minnesota | Mahnomen | 27087 | 1779 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-04-25 04:20:56 | Mahnomen, Minnesota, US | |
749652 | 749652 | 2022-04-23 | US | Virginia | Bland | 51021 | 1779 | 23 | 0 | 37.13128068 | -81.13599391 | 2022-04-24 04:20:56 | Bland, Virginia, US | |
749328 | 749328 | 2022-04-23 | US | Tennessee | Pickett | 47137 | 1779 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-24 04:20:56 | Pickett, Tennessee, US | |
748083 | 748083 | 2022-04-23 | US | Minnesota | Mahnomen | 27087 | 1779 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-04-24 04:20:56 | Mahnomen, Minnesota, US | |
3440137 | 3440137 | 2022-04-22 | US | Virginia | Bland | 51021 | 1779 | 23 | 0 | 37.13128068 | -81.13599391 | 2022-04-23 04:20:50 | Bland, Virginia, US | |
3439813 | 3439813 | 2022-04-22 | US | Tennessee | Pickett | 47137 | 1779 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-23 04:20:50 | Pickett, Tennessee, US | |
3438568 | 3438568 | 2022-04-22 | US | Minnesota | Mahnomen | 27087 | 1779 | 17 | 0 | 47.32557075 | -95.80921485 | 2022-04-23 04:20:50 | Mahnomen, Minnesota, US | |
2895398 | 2895398 | 2022-04-21 | US | Tennessee | Pickett | 47137 | 1779 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-22 04:20:45 | Pickett, Tennessee, US | |
2310712 | 2310712 | 2022-04-20 | US | Virginia | Williamsburg | 51830 | 1779 | 22 | 0 | 37.28131268 | -76.70905141 | 2022-04-21 04:20:46 | Williamsburg, Virginia, US | |
2310270 | 2310270 | 2022-04-20 | US | Tennessee | Pickett | 47137 | 1779 | 36 | 0 | 36.55606529 | -85.07763299999998 | 2022-04-21 04:20:46 | Pickett, Tennessee, US | |
878392 | 878392 | 2022-03-27 | US | Nebraska | Thurston | 31173 | 1779 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-03-28 04:20:33 | Thurston, Nebraska, US | |
2165675 | 2165675 | 2022-03-26 | US | Nebraska | Thurston | 31173 | 1779 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-03-27 04:20:47 | Thurston, Nebraska, US | |
1722611 | 1722611 | 2022-03-25 | US | Nebraska | Thurston | 31173 | 1779 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-03-26 04:20:23 | Thurston, Nebraska, US | |
1470228 | 1470228 | 2022-03-24 | US | Nebraska | Thurston | 31173 | 1779 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-03-25 04:20:46 | Thurston, Nebraska, US | |
3240455 | 3240455 | 2022-03-21 | US | Nebraska | Thurston | 31173 | 1779 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-03-22 04:20:54 | Thurston, Nebraska, US | |
26528 | 26528 | 2022-03-20 | US | Nebraska | Thurston | 31173 | 1779 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-03-21 04:20:50 | Thurston, Nebraska, US | |
1658538 | 1658538 | 2022-03-19 | US | Nebraska | Thurston | 31173 | 1779 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-03-20 04:20:45 | Thurston, Nebraska, US | |
338064 | 338064 | 2022-03-18 | US | Nebraska | Thurston | 31173 | 1779 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-03-19 04:20:47 | Thurston, Nebraska, US | |
263660 | 263660 | 2022-03-15 | US | Nebraska | Thurston | 31173 | 1779 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-03-16 04:20:50 | Thurston, Nebraska, US | |
1992458 | 1992458 | 2022-03-01 | China | Jiangsu | 1779 | 0 | 0 | 32.9711 | 119.455 | 2022-03-02 04:21:07 | Jiangsu, China | |||
942632 | 942632 | 2022-02-28 | China | Jiangsu | 1779 | 0 | 0 | 32.9711 | 119.455 | 2022-03-01 04:21:09 | Jiangsu, China | |||
2450149 | 2450149 | 2022-02-22 | US | Virginia | Middlesex | 51119 | 1779 | 42 | 0 | 37.63191998 | -76.55064617 | 2022-02-23 04:21:09 | Middlesex, Virginia, US | |
3674522 | 3674522 | 2022-02-15 | US | South Dakota | Fall River | 46047 | 1779 | 39 | 0 | 43.23929297 | -103.5275691 | 2022-02-16 04:21:10 | Fall River, South Dakota, US | |
3077246 | 3077246 | 2022-02-09 | US | Texas | Rains | 48379 | 1779 | 54 | 0 | 32.87109387 | -95.79232691 | 2022-02-10 04:21:14 | Rains, Texas, US | |
2015710 | 2015710 | 2022-02-06 | US | Tennessee | Van Buren | 47175 | 1779 | 44 | 0 | 35.69864497 | -85.45221699 | 2022-02-07 04:21:05 | Van Buren, Tennessee, US | |
2660855 | 2660855 | 2022-01-31 | US | Texas | Crosby | 48107 | 1779 | 44 | 0 | 33.61431553 | -101.30003640000001 | 2022-02-01 04:21:11 | Crosby, Texas, US | |
3303824 | 3303824 | 2022-01-30 | US | Wyoming | Sublette | 56035 | 1779 | 25 | 0 | 42.76558279 | -109.91309220000001 | 2022-01-31 04:21:09 | Sublette, Wyoming, US | |
3065615 | 3065615 | 2022-01-29 | US | Wyoming | Sublette | 56035 | 1779 | 25 | 0 | 42.76558279 | -109.91309220000001 | 2022-01-30 04:21:26 | Sublette, Wyoming, US | |
3813549 | 3813549 | 2022-01-28 | US | Wyoming | Sublette | 56035 | 1779 | 25 | 0 | 42.76558279 | -109.91309220000001 | 2022-01-29 04:21:10 | Sublette, Wyoming, US | |
1780779 | 1780779 | 2022-01-27 | US | Kentucky | Crittenden | 21055 | 1779 | 39 | 0 | 37.35839237 | -88.08826090000002 | 2022-01-28 04:21:09 | Crittenden, Kentucky, US | |
1321583 | 1321583 | 2022-01-26 | US | Virginia | Lunenburg | 51111 | 1779 | 23 | 0 | 36.94618528 | -78.24133319 | 2022-01-27 04:21:19 | Lunenburg, Virginia, US | |
2053693 | 2053693 | 2022-01-25 | US | Mississippi | Humphreys | 28053 | 1779 | 39 | 0 | 33.12825718 | -90.52252707 | 2022-01-26 04:21:07 | Humphreys, Mississippi, US | |
1473643 | 1473643 | 2022-01-17 | US | Louisiana | Red River | 22081 | 1779 | 49 | 0 | 32.09530039 | -93.34213308 | 2022-01-18 04:21:04 | Red River, Louisiana, US | |
558019 | 558019 | 2022-01-16 | US | Texas | Swisher | 48437 | 1779 | 27 | 0 | 34.53028891 | -101.73491740000001 | 2022-01-17 04:21:08 | Swisher, Texas, US | |
556317 | 556317 | 2022-01-16 | US | Louisiana | Red River | 22081 | 1779 | 49 | 0 | 32.09530039 | -93.34213308 | 2022-01-17 04:21:08 | Red River, Louisiana, US | |
3842038 | 3842038 | 2022-01-15 | US | Louisiana | Red River | 22081 | 1779 | 49 | 0 | 32.09530039 | -93.34213308 | 2022-01-16 04:21:12 | Red River, Louisiana, US | |
100853 | 100853 | 2022-01-14 | US | Louisiana | Red River | 22081 | 1779 | 49 | 0 | 32.09530039 | -93.34213308 | 2022-01-15 04:21:07 | Red River, Louisiana, US | |
1113616 | 1113616 | 2022-01-11 | Japan | Tottori | 1779 | 5 | 0 | 35.359069 | 133.863619 | 2022-01-12 04:21:44 | Tottori, Japan | |||
2612769 | 2612769 | 2022-01-06 | US | Puerto Rico | Barceloneta | 72017 | 1779 | 0 | 0 | 18.445532999999998 | -66.56053100000001 | 2022-01-07 04:22:09 | Barceloneta, Puerto Rico, US | |
1703693 | 1703693 | 2022-01-03 | US | Virginia | Galax | 51640 | 1779 | 69 | 0 | 36.66601852 | -80.91703124 | 2022-01-04 04:22:17 | Galax, Virginia, US | |
1670395 | 1670395 | 2021-12-29 | US | Missouri | Montgomery | 29139 | 1779 | 34 | 0 | 38.94022054 | -91.47000721 | 2021-12-30 04:21:25 | Montgomery, Missouri, US | |
1435777 | 1435777 | 2021-12-28 | US | Texas | Runnels | 48399 | 1779 | 56 | 0 | 31.8314342 | -99.97616148 | 2021-12-29 03:21:43 | Runnels, Texas, US | |
1433456 | 1433456 | 2021-12-28 | US | Georgia | Turner | 13287 | 1779 | 50 | 0 | 31.71612656 | -83.62069378 | 2021-12-29 03:21:43 | Turner, Georgia, US | |
3829489 | 3829489 | 2021-12-21 | US | Illinois | Marshall | 17123 | 1779 | 23 | 0 | 41.0327901 | -89.34510444 | 2021-12-22 04:21:54 | Marshall, Illinois, US | |
1717423 | 1717423 | 2021-12-16 | US | Indiana | Benton | 18007 | 1779 | 18 | 0 | 40.60626947 | -87.31093999 | 2021-12-17 04:22:14 | Benton, Indiana, US | |
1716169 | 1716169 | 2021-12-16 | China | Yunnan | 1779 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-12-17 04:22:14 | Yunnan, China | |||
3497980 | 3497980 | 2021-12-15 | US | Mississippi | Carroll | 28015 | 1779 | 41 | 0 | 33.44834567 | -89.91994479 | 2021-12-16 04:22:11 | Carroll, Mississippi, US | |
784743 | 784743 | 2021-12-13 | US | North Carolina | Pamlico | 37137 | 1779 | 26 | 0 | 35.15253315 | -76.66559823 | 2021-12-14 04:22:38 | Pamlico, North Carolina, US | |
1664966 | 1664966 | 2021-12-11 | US | Arkansas | Scott | 5127 | 1779 | 32 | 0 | 34.85588887 | -94.0632176 | 2021-12-12 04:22:12 | Scott, Arkansas, US | |
1079570 | 1079570 | 2021-12-09 | US | Michigan | Iron | 26071 | 1779 | 70 | 0 | 46.20974132 | -88.53136251 | 2021-12-10 04:22:28 | Iron, Michigan, US | |
553963 | 553963 | 2021-12-08 | US | Texas | Ochiltree | 48357 | 1779 | 38 | 0 | 36.27829105 | -100.8158184 | 2021-12-09 04:22:49 | Ochiltree, Texas, US | |
552419 | 552419 | 2021-12-08 | US | Michigan | Iron | 26071 | 1779 | 70 | 0 | 46.20974132 | -88.53136251 | 2021-12-09 04:22:49 | Iron, Michigan, US | |
1033047 | 1033047 | 2021-12-06 | US | Pennsylvania | Forest | 42053 | 1779 | 29 | 0 | 41.51095103 | -79.23229292 | 2021-12-07 04:22:34 | Forest, Pennsylvania, US | |
1743347 | 1743347 | 2021-12-05 | US | South Carolina | Calhoun | 45017 | 1779 | 53 | 0 | 33.66926881 | -80.77722168 | 2021-12-06 04:22:34 | Calhoun, South Carolina, US | |
140779 | 140779 | 2021-12-04 | US | South Carolina | Calhoun | 45017 | 1779 | 53 | 0 | 33.66926881 | -80.77722168 | 2021-12-05 04:22:25 | Calhoun, South Carolina, 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]);