johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
169 rows where confirmed = 4014 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954355 | 2954355 | 2022-12-20 | US | Tennessee | Lewis | 47101 | 4014 | 67 | 0 | 35.52853208 | -87.49022694 | 2022-12-21 04:21:03 | Lewis, Tennessee, US | |
2489533 | 2489533 | 2022-11-16 | US | Wisconsin | Ashland | 55003 | 4014 | 42 | 0 | 46.31956891 | -90.67837132 | 2022-11-17 04:21:11 | Ashland, Wisconsin, US | |
1561849 | 1561849 | 2022-09-28 | US | Minnesota | Pennington | 27113 | 4014 | 43 | 0 | 48.06642577 | -96.0370814 | 2022-09-29 04:22:34 | Pennington, Minnesota, US | |
3996392 | 3996392 | 2022-09-27 | US | Minnesota | Pennington | 27113 | 4014 | 43 | 0 | 48.06642577 | -96.0370814 | 2022-09-28 04:23:01 | Pennington, Minnesota, US | |
2770720 | 2770720 | 2022-09-26 | US | Minnesota | Pennington | 27113 | 4014 | 43 | 0 | 48.06642577 | -96.0370814 | 2022-09-27 04:23:01 | Pennington, Minnesota, US | |
1978373 | 1978373 | 2022-09-25 | US | Minnesota | Pennington | 27113 | 4014 | 43 | 0 | 48.06642577 | -96.0370814 | 2022-09-26 04:20:52 | Pennington, Minnesota, US | |
2651540 | 2651540 | 2022-09-24 | US | Minnesota | Pennington | 27113 | 4014 | 43 | 0 | 48.06642577 | -96.0370814 | 2022-09-25 04:23:31 | Pennington, Minnesota, US | |
385980 | 385980 | 2022-09-23 | US | Minnesota | Pennington | 27113 | 4014 | 43 | 0 | 48.06642577 | -96.0370814 | 2022-09-24 04:21:40 | Pennington, Minnesota, US | |
1626046 | 1626046 | 2022-09-22 | US | Minnesota | Pennington | 27113 | 4014 | 43 | 0 | 48.06642577 | -96.0370814 | 2022-09-23 04:23:13 | Pennington, Minnesota, US | |
3768301 | 3768301 | 2022-09-11 | US | North Dakota | Ramsey | 38071 | 4014 | 57 | 0 | 48.26886249 | -98.72223879 | 2022-09-12 04:20:58 | Ramsey, North Dakota, US | |
965196 | 965196 | 2022-09-09 | US | New York | Yates | 36123 | 4014 | 40 | 0 | 42.63505484 | -77.10369919 | 2022-09-10 04:21:10 | Yates, New York, US | |
1490679 | 1490679 | 2022-07-26 | US | Texas | Freestone | 48161 | 4014 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-07-27 04:21:04 | Freestone, Texas, US | |
1213214 | 1213214 | 2022-07-11 | US | Michigan | Manistee | 26101 | 4014 | 94 | 0 | 44.33352407 | -86.05626916 | 2022-07-12 04:20:51 | Manistee, Michigan, US | |
2790696 | 2790696 | 2022-07-10 | US | Michigan | Manistee | 26101 | 4014 | 94 | 0 | 44.33352407 | -86.05626916 | 2022-07-11 04:20:46 | Manistee, Michigan, US | |
143649 | 143649 | 2022-07-09 | US | Michigan | Manistee | 26101 | 4014 | 94 | 0 | 44.33352407 | -86.05626916 | 2022-07-10 04:20:54 | Manistee, Michigan, US | |
1418749 | 1418749 | 2022-07-08 | US | Michigan | Manistee | 26101 | 4014 | 94 | 0 | 44.33352407 | -86.05626916 | 2022-07-09 04:20:59 | Manistee, Michigan, US | |
2742674 | 2742674 | 2022-07-07 | US | Michigan | Manistee | 26101 | 4014 | 94 | 0 | 44.33352407 | -86.05626916 | 2022-07-08 04:20:56 | Manistee, Michigan, US | |
1201469 | 1201469 | 2022-07-06 | US | Michigan | Manistee | 26101 | 4014 | 94 | 0 | 44.33352407 | -86.05626916 | 2022-07-07 04:20:55 | Manistee, Michigan, US | |
3968212 | 3968212 | 2022-07-05 | US | Michigan | Manistee | 26101 | 4014 | 94 | 0 | 44.33352407 | -86.05626916 | 2022-07-06 04:20:58 | Manistee, Michigan, US | |
939313 | 939313 | 2022-06-25 | US | Arkansas | Izard | 5065 | 4014 | 70 | 0 | 36.09604046 | -91.90847954 | 2022-06-26 04:21:02 | Izard, Arkansas, US | |
3986174 | 3986174 | 2022-06-15 | US | Wisconsin | Marquette | 55077 | 4014 | 62 | 0 | 43.81911946 | -89.40073763 | 2022-06-16 04:20:55 | Marquette, Wisconsin, US | |
948105 | 948105 | 2022-06-14 | US | Iowa | Winneshiek | 19191 | 4014 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-06-15 04:20:54 | Winneshiek, Iowa, US | |
2980513 | 2980513 | 2022-06-13 | US | Iowa | Winneshiek | 19191 | 4014 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-06-14 04:20:52 | Winneshiek, Iowa, US | |
2236639 | 2236639 | 2022-06-12 | US | Iowa | Winneshiek | 19191 | 4014 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-06-13 04:21:14 | Winneshiek, Iowa, US | |
3142837 | 3142837 | 2022-06-11 | US | Iowa | Winneshiek | 19191 | 4014 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-06-12 04:20:53 | Winneshiek, Iowa, US | |
1945753 | 1945753 | 2022-06-10 | US | Iowa | Winneshiek | 19191 | 4014 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-06-11 04:21:01 | Winneshiek, Iowa, US | |
3158892 | 3158892 | 2022-06-09 | US | Iowa | Winneshiek | 19191 | 4014 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-06-10 04:20:55 | Winneshiek, Iowa, US | |
1422359 | 1422359 | 2022-06-08 | US | Iowa | Winneshiek | 19191 | 4014 | 50 | 0 | 43.29094334 | -91.84422722 | 2022-06-09 04:20:54 | Winneshiek, Iowa, US | |
3527972 | 3527972 | 2022-06-04 | US | Arkansas | Madison | 5087 | 4014 | 63 | 0 | 36.01038185 | -93.72524943 | 2022-06-05 04:20:55 | Madison, Arkansas, US | |
466929 | 466929 | 2022-05-02 | US | Wisconsin | Burnett | 55013 | 4014 | 43 | 0 | 45.86303537 | -92.36711412 | 2022-05-03 04:21:00 | Burnett, Wisconsin, US | |
2308313 | 2308313 | 2022-04-20 | US | Illinois | Mercer | 17131 | 4014 | 47 | 0 | 41.20596782 | -90.74290052 | 2022-04-21 04:20:46 | Mercer, Illinois, US | |
1948943 | 1948943 | 2022-04-12 | US | Alaska | Kusilvak | 2158 | 4014 | 12 | 0 | 62.15429159999999 | -163.39678830000003 | 2022-04-13 04:21:03 | Kusilvak, Alaska, US | |
3206696 | 3206696 | 2022-04-11 | US | Alaska | Kusilvak | 2158 | 4014 | 12 | 0 | 62.15429159999999 | -163.39678830000003 | 2022-04-12 04:20:49 | Kusilvak, Alaska, US | |
1576582 | 1576582 | 2022-04-10 | US | Alaska | Kusilvak | 2158 | 4014 | 12 | 0 | 62.15429159999999 | -163.39678830000003 | 2022-04-11 04:21:02 | Kusilvak, Alaska, US | |
1652824 | 1652824 | 2022-04-09 | US | Alaska | Kusilvak | 2158 | 4014 | 12 | 0 | 62.15429159999999 | -163.39678830000003 | 2022-04-10 04:20:52 | Kusilvak, Alaska, US | |
2116146 | 2116146 | 2022-04-08 | US | Alaska | Kusilvak | 2158 | 4014 | 12 | 0 | 62.15429159999999 | -163.39678830000003 | 2022-04-09 04:20:42 | Kusilvak, Alaska, US | |
3320670 | 3320670 | 2022-04-07 | US | Alaska | Kusilvak | 2158 | 4014 | 12 | 0 | 62.15429159999999 | -163.39678830000003 | 2022-04-08 04:20:48 | Kusilvak, Alaska, US | |
2801206 | 2801206 | 2022-04-06 | US | Alaska | Kusilvak | 2158 | 4014 | 12 | 0 | 62.15429159999999 | -163.39678830000003 | 2022-04-07 04:20:53 | Kusilvak, Alaska, US | |
158163 | 158163 | 2022-03-29 | Palau | 4014 | 6 | 0 | 7.515 | 134.5825 | 2022-03-30 04:20:45 | Palau | ||||
1436734 | 1436734 | 2022-03-28 | Palau | 4014 | 6 | 0 | 7.515 | 134.5825 | 2022-03-29 04:20:46 | Palau | ||||
3024213 | 3024213 | 2022-03-23 | US | Missouri | Morgan | 29141 | 4014 | 109 | 0 | 38.4181765 | -92.88791859 | 2022-03-24 04:20:43 | Morgan, Missouri, US | |
3023278 | 3023278 | 2022-03-23 | US | Illinois | Jo Daviess | 17085 | 4014 | 35 | 0 | 42.36542373 | -90.21094405 | 2022-03-24 04:20:43 | Jo Daviess, Illinois, US | |
2267239 | 2267239 | 2022-03-14 | US | Virginia | Grayson | 51077 | 4014 | 79 | 0 | 36.65677234 | -81.23215889 | 2022-03-15 04:20:47 | Grayson, Virginia, US | |
2143518 | 2143518 | 2022-03-09 | US | Virginia | Giles | 51071 | 4014 | 44 | 0 | 37.31234791 | -80.70636931 | 2022-03-10 04:20:48 | Giles, Virginia, US | |
923029 | 923029 | 2022-03-08 | US | Virginia | Giles | 51071 | 4014 | 44 | 0 | 37.31234791 | -80.70636931 | 2022-03-09 04:20:59 | Giles, Virginia, US | |
1551316 | 1551316 | 2022-03-07 | US | Virginia | Giles | 51071 | 4014 | 44 | 0 | 37.31234791 | -80.70636931 | 2022-03-08 04:20:54 | Giles, Virginia, US | |
1647102 | 1647102 | 2022-03-03 | US | Puerto Rico | Fajardo | 72053 | 4014 | 0 | 0 | 18.318373 | -65.666866 | 2022-03-04 04:21:09 | Fajardo, Puerto Rico, US | |
1995925 | 1995925 | 2022-03-01 | US | Texas | Zavala | 48507 | 4014 | 66 | 0 | 28.86617238 | -99.76050829 | 2022-03-02 04:21:07 | Zavala, Texas, US | |
1297551 | 1297551 | 2022-02-05 | US | West Virginia | Taylor | 54091 | 4014 | 59 | 0 | 39.33602617 | -80.0421439 | 2022-02-06 04:21:00 | Taylor, West Virginia, US | |
2658546 | 2658546 | 2022-01-31 | US | Georgia | Ben Hill | 13017 | 4014 | 114 | 0 | 31.76095874 | -83.22145359 | 2022-02-01 04:21:11 | Ben Hill, Georgia, US | |
3466616 | 3466616 | 2022-01-18 | US | Northern Mariana Islands | 69 | 4014 | 21 | 0 | 15.0979 | 145.6739 | 2022-01-19 04:21:23 | Northern Mariana Islands, US | ||
1287225 | 1287225 | 2022-01-04 | US | Iowa | Mahaska | 19123 | 4014 | 69 | 0 | 41.33521503 | -92.64083907 | 2022-01-05 04:21:59 | Mahaska, Iowa, US | |
1701569 | 1701569 | 2022-01-03 | US | Iowa | Mahaska | 19123 | 4014 | 69 | 0 | 41.33521503 | -92.64083907 | 2022-01-04 04:22:17 | Mahaska, Iowa, US | |
3520652 | 3520652 | 2022-01-02 | US | Iowa | Mahaska | 19123 | 4014 | 69 | 0 | 41.33521503 | -92.64083907 | 2022-01-03 02:22:25 | Mahaska, Iowa, US | |
2168782 | 2168782 | 2022-01-01 | US | Iowa | Mahaska | 19123 | 4014 | 69 | 0 | 41.33521503 | -92.64083907 | 2022-01-02 04:20:52 | Mahaska, Iowa, US | |
2778213 | 2778213 | 2021-12-31 | US | Iowa | Mahaska | 19123 | 4014 | 69 | 0 | 41.33521503 | -92.64083907 | 2022-01-01 04:22:14 | Mahaska, Iowa, US | |
3999870 | 3999870 | 2021-12-30 | US | Iowa | Mahaska | 19123 | 4014 | 69 | 0 | 41.33521503 | -92.64083907 | 2021-12-31 04:21:50 | Mahaska, Iowa, US | |
1669677 | 1669677 | 2021-12-29 | US | Iowa | Mahaska | 19123 | 4014 | 69 | 0 | 41.33521503 | -92.64083907 | 2021-12-30 04:21:25 | Mahaska, Iowa, US | |
732362 | 732362 | 2021-12-27 | US | Mississippi | Newton | 28101 | 4014 | 83 | 0 | 32.40021118 | -89.11843336 | 2021-12-28 04:21:47 | Newton, Mississippi, US | |
3819461 | 3819461 | 2021-12-23 | US | Texas | Calhoun | 48057 | 4014 | 39 | 0 | 28.47048236 | -96.61633945 | 2021-12-24 04:21:34 | Calhoun, Texas, US | |
3499553 | 3499553 | 2021-12-15 | US | Virginia | Lee | 51105 | 4014 | 62 | 0 | 36.70586667 | -83.12606515 | 2021-12-16 04:22:11 | Lee, Virginia, US | |
3499167 | 3499167 | 2021-12-15 | US | Tennessee | Morgan | 47129 | 4014 | 51 | 0 | 36.13248031 | -84.64880098 | 2021-12-16 04:22:11 | Morgan, Tennessee, US | |
1741344 | 1741344 | 2021-12-05 | US | Georgia | Franklin | 13119 | 4014 | 84 | 0 | 34.37525597 | -83.23159927 | 2021-12-06 04:22:34 | Franklin, Georgia, US | |
138776 | 138776 | 2021-12-04 | US | Georgia | Franklin | 13119 | 4014 | 84 | 0 | 34.37525597 | -83.23159927 | 2021-12-05 04:22:25 | Franklin, Georgia, US | |
2196429 | 2196429 | 2021-12-03 | US | Georgia | Franklin | 13119 | 4014 | 84 | 0 | 34.37525597 | -83.23159927 | 2021-12-04 04:22:18 | Franklin, Georgia, US | |
1147841 | 1147841 | 2021-12-01 | US | South Dakota | Yankton | 46135 | 4014 | 42 | 0 | 43.00924485 | -97.39467635 | 2021-12-02 04:22:37 | Yankton, South Dakota, US | |
153329 | 153329 | 2021-11-29 | US | Virginia | Gloucester | 51073 | 4014 | 80 | 0 | 37.40809042 | -76.53524337 | 2021-11-30 04:22:53 | Gloucester, Virginia, US | |
152847 | 152847 | 2021-11-29 | US | South Dakota | Davison | 46035 | 4014 | 70 | 0 | 43.67490933 | -98.14458906 | 2021-11-30 04:22:53 | Davison, South Dakota, US | |
152460 | 152460 | 2021-11-29 | US | Ohio | Hocking | 39073 | 4014 | 95 | 0 | 39.49537927 | -82.47991446 | 2021-11-30 04:22:53 | Hocking, Ohio, US | |
3073625 | 3073625 | 2021-11-23 | US | Wisconsin | Waushara | 55137 | 4014 | 56 | 0 | 44.11324419 | -89.24317107 | 2021-11-24 04:22:14 | Waushara, Wisconsin, US | |
449682 | 449682 | 2021-11-17 | US | North Carolina | Dare | 37055 | 4014 | 14 | 0 | 35.66520691 | -75.71767334 | 2021-11-18 04:21:33 | Dare, North Carolina, US | |
89097 | 89097 | 2021-11-09 | US | Missouri | Stone | 29209 | 4014 | 86 | 0 | 36.75000327 | -93.45256475 | 2021-11-10 04:21:38 | Stone, Missouri, US | |
701721 | 701721 | 2021-11-04 | US | Virginia | Carroll | 51035 | 4014 | 96 | 0 | 36.73066666 | -80.73455942 | 2021-11-05 04:21:54 | Carroll, Virginia, US | |
291514 | 291514 | 2021-10-31 | US | West Virginia | Upshur | 54097 | 4014 | 65 | 0 | 38.89285061 | -80.23689136 | 2021-11-01 04:22:01 | Upshur, West Virginia, US | |
3008419 | 3008419 | 2021-10-11 | US | Indiana | Fayette | 18041 | 4014 | 86 | 0 | 39.63684962 | -85.17797541 | 2021-10-12 04:21:09 | Fayette, Indiana, US | |
988058 | 988058 | 2021-10-04 | US | Indiana | Decatur | 18031 | 4014 | 100 | 0 | 39.30712658 | -85.50087166 | 2021-10-05 04:21:27 | Decatur, Indiana, US | |
2077263 | 2077263 | 2021-09-26 | US | Kansas | Miami | 20121 | 4014 | 57 | 0 | 38.56383358 | -94.83832189 | 2021-09-27 04:21:16 | Miami, Kansas, US | |
1725815 | 1725815 | 2021-09-25 | US | Kansas | Miami | 20121 | 4014 | 57 | 0 | 38.56383358 | -94.83832189 | 2021-09-26 04:21:29 | Miami, Kansas, US | |
1922535 | 1922535 | 2021-09-24 | US | Kansas | Miami | 20121 | 4014 | 57 | 0 | 38.56383358 | -94.83832189 | 2021-09-25 04:21:31 | Miami, Kansas, US | |
3012739 | 3012739 | 2021-09-22 | US | Kentucky | Grayson | 21085 | 4014 | 71 | 0 | 37.46231118 | -86.34248968 | 2021-09-23 04:21:43 | Grayson, Kentucky, US | |
2808883 | 2808883 | 2021-09-16 | New Zealand | 4014 | 29 | 0 | -40.9006 | 174.886 | 2021-09-17 04:21:46 | New Zealand | ||||
2069702 | 2069702 | 2021-08-31 | US | Mississippi | George | 28039 | 4014 | 60 | 0 | 30.86259065 | -88.64436789 | 2021-09-01 04:21:38 | George, Mississippi, US | |
1777331 | 1777331 | 2021-08-30 | US | Missouri | Warren | 29219 | 4014 | 32 | 0 | 38.76529479 | -91.16124662 | 2021-08-31 04:21:46 | Warren, Missouri, US | |
33378 | 33378 | 2021-08-25 | US | Illinois | Bureau | 17011 | 4014 | 86 | 0 | 41.40385234 | -89.5283051 | 2021-08-26 04:21:28 | Bureau, Illinois, US | |
513519 | 513519 | 2021-08-19 | US | Mississippi | Leflore | 28083 | 4014 | 127 | 0 | 33.55545125 | -90.29900733 | 2021-08-20 04:21:33 | Leflore, Mississippi, US | |
248273 | 248273 | 2021-08-17 | US | Tennessee | White | 47185 | 4014 | 75 | 0 | 35.92929884 | -85.45591799 | 2021-08-18 04:21:35 | White, Tennessee, US | |
104668 | 104668 | 2021-08-15 | US | Kansas | Seward | 20175 | 4014 | 42 | 0 | 37.19324632 | -100.85072009999999 | 2021-08-16 04:21:31 | Seward, Kansas, US | |
510602 | 510602 | 2021-08-14 | US | Tennessee | Carroll | 47017 | 4014 | 81 | 0 | 35.97366108 | -88.45189331 | 2021-08-15 04:21:41 | Carroll, Tennessee, US | |
509026 | 509026 | 2021-08-14 | US | Kansas | Seward | 20175 | 4014 | 42 | 0 | 37.19324632 | -100.85072009999999 | 2021-08-15 04:21:41 | Seward, Kansas, US | |
1484898 | 1484898 | 2021-08-13 | US | Kansas | Seward | 20175 | 4014 | 42 | 0 | 37.19324632 | -100.85072009999999 | 2021-08-14 04:21:25 | Seward, Kansas, US | |
1345904 | 1345904 | 2021-08-11 | US | Wyoming | Teton | 56039 | 4014 | 11 | 0 | 43.93522482 | -110.5890801 | 2021-08-12 04:21:25 | Teton, Wyoming, US | |
2353725 | 2353725 | 2021-08-10 | US | North Carolina | Bladen | 37017 | 4014 | 61 | 0 | 34.61296243 | -78.56180059 | 2021-08-11 04:21:58 | Bladen, North Carolina, US | |
1307920 | 1307920 | 2021-07-27 | US | Minnesota | Steele | 27147 | 4014 | 19 | 0 | 44.02240351 | -93.22627088 | 2021-07-28 04:21:39 | Steele, Minnesota, US | |
1330113 | 1330113 | 2021-07-24 | Comoros | 4014 | 147 | 3849 | 18 | -11.6455 | 43.3333 | 2021-07-25 04:22:12 | Comoros | |||
3137417 | 3137417 | 2021-07-23 | Comoros | 4014 | 147 | 3849 | 18 | -11.6455 | 43.3333 | 2021-07-24 00:21:36 | Comoros | |||
3476177 | 3476177 | 2021-07-22 | Comoros | 4014 | 147 | 3849 | 18 | -11.6455 | 43.3333 | 2021-07-23 04:21:29 | Comoros | |||
3708041 | 3708041 | 2021-07-17 | US | Missouri | Laclede | 29105 | 4014 | 79 | 0 | 37.65896829 | -92.5888493 | 2021-07-18 04:22:07 | Laclede, Missouri, US | |
778674 | 778674 | 2021-07-08 | Sweden | Gotland | 4014 | 52 | 0 | 3962 | 57.4684 | 18.4867 | 2021-07-09 04:21:21 | Gotland, Sweden | ||
2719412 | 2719412 | 2021-06-10 | US | Ohio | Brown | 39015 | 4014 | 61 | 0 | 38.93416837 | -83.86788395 | 2021-06-11 04:23:20 | Brown, Ohio, US | |
3148270 | 3148270 | 2021-06-07 | US | Pennsylvania | Pike | 42103 | 4014 | 54 | 0 | 41.33155042 | -75.03208106 | 2021-06-08 04:22:35 | Pike, Pennsylvania, 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]);