johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by deaths
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2112218 | 2112218 | 2021-12-26 | US | Arkansas | Polk | 5113 | 3055 | 124 | 0 | 34.48254879 | -94.22728802 | 2021-12-27 04:21:58 | Polk, Arkansas, US | |
2112464 | 2112464 | 2021-12-26 | US | Georgia | Butts | 13035 | 4910 | 124 | 0 | 33.283094500000004 | -83.95435040000002 | 2021-12-27 04:21:58 | Butts, Georgia, US | |
2112559 | 2112559 | 2021-12-26 | US | Georgia | Pickens | 13227 | 5891 | 124 | 0 | 34.46589159 | -84.46406611 | 2021-12-27 04:21:58 | Pickens, Georgia, US | |
2112574 | 2112574 | 2021-12-26 | US | Georgia | Stephens | 13257 | 4937 | 124 | 0 | 34.55151201 | -83.29405315 | 2021-12-27 04:21:58 | Stephens, Georgia, US | |
2112598 | 2112598 | 2021-12-26 | US | Georgia | Washington | 13303 | 3263 | 124 | 0 | 32.96711864 | -82.79357039 | 2021-12-27 04:21:58 | Washington, Georgia, US | |
2114172 | 2114172 | 2021-12-26 | US | Ohio | Hardin | 39065 | 5350 | 124 | 0 | 40.66015414 | -83.65929931 | 2021-12-27 04:21:58 | Hardin, Ohio, US | |
2115184 | 2115184 | 2021-12-26 | US | West Virginia | Hancock | 54029 | 4911 | 124 | 0 | 40.51943859 | -80.57461608 | 2021-12-27 04:21:58 | Hancock, West Virginia, US | |
2116461 | 2116461 | 2022-04-08 | US | Florida | Wakulla | 12129 | 9945 | 124 | 0 | 30.16548905 | -84.39895211 | 2022-04-09 04:20:42 | Wakulla, Florida, US | |
2116464 | 2116464 | 2022-04-08 | US | Georgia | Appling | 13001 | 4763 | 124 | 0 | 31.74847232 | -82.28909114 | 2022-04-09 04:20:42 | Appling, Georgia, US | |
2117567 | 2117567 | 2022-04-08 | US | Mississippi | Sunflower | 28133 | 5764 | 124 | 0 | 33.60192578 | -90.58882684 | 2022-04-09 04:20:42 | Sunflower, Mississippi, US | |
2118068 | 2118068 | 2022-04-08 | US | North Carolina | Orange | 37135 | 26215 | 124 | 0 | 36.06092947 | -79.12167935 | 2022-04-09 04:20:42 | Orange, North Carolina, US | |
2118294 | 2118294 | 2022-04-08 | US | Oklahoma | McIntosh | 40091 | 4877 | 124 | 0 | 35.37235506 | -95.66599306 | 2022-04-09 04:20:42 | McIntosh, Oklahoma, US | |
2118303 | 2118303 | 2022-04-08 | US | Oklahoma | Ottawa | 40115 | 9123 | 124 | 0 | 36.83532655 | -94.81011909 | 2022-04-09 04:20:42 | Ottawa, Oklahoma, US | |
2118379 | 2118379 | 2022-04-08 | US | Pennsylvania | Clinton | 42035 | 9034 | 124 | 0 | 41.23255967 | -77.63785995 | 2022-04-09 04:20:42 | Clinton, Pennsylvania, US | |
2118817 | 2118817 | 2022-04-08 | US | Texas | Gray | 48179 | 6176 | 124 | 0 | 35.40081878 | -100.8129222 | 2022-04-09 04:20:42 | Gray, Texas, US | |
2118874 | 2118874 | 2022-04-08 | US | Texas | Limestone | 48293 | 5077 | 124 | 0 | 31.5454767 | -96.58095444 | 2022-04-09 04:20:42 | Limestone, Texas, US | |
2119334 | 2119334 | 2022-04-08 | US | Wyoming | Sweetwater | 56037 | 11065 | 124 | 0 | 41.65943896 | -108.8827882 | 2022-04-09 04:20:42 | Sweetwater, Wyoming, US | |
2119547 | 2119547 | 2020-12-20 | Colombia | Amazonas | 3196 | 124 | 3047 | 25 | -1.4429 | -71.5724 | 2020-12-21 05:27:58 | Amazonas, Colombia | ||
2119667 | 2119667 | 2020-12-20 | India | Ladakh | 9279 | 124 | 8801 | 354 | 34.1526 | 77.5771 | 2020-12-21 05:27:58 | Ladakh, India | ||
2119679 | 2119679 | 2020-12-20 | India | Sikkim | 5573 | 124 | 5075 | 374 | 27.571671 | 88.472712 | 2020-12-21 05:27:58 | Sikkim, India | ||
2119909 | 2119909 | 2020-12-20 | Russia | Ingushetia Republic | 11164 | 124 | 9319 | 1721 | 43.11542075 | 45.01713552 | 2020-12-21 05:27:58 | Ingushetia Republic, Russia | ||
2119993 | 2119993 | 2020-12-20 | Somalia | 4662 | 124 | 3566 | 972 | 5.152149 | 46.199616 | 2020-12-21 05:27:58 | Somalia | |||
2121998 | 2121998 | 2020-12-20 | US | North Carolina | Cabarrus | 37025 | 9684 | 124 | 0 | 9560 | 35.3877799 | -80.55267168 | 2020-12-21 05:27:58 | Cabarrus, North Carolina, US |
2122154 | 2122154 | 2020-12-20 | US | Ohio | Clermont | 39025 | 10326 | 124 | 0 | 10202 | 39.04847534 | -84.15375786 | 2020-12-21 05:27:58 | Clermont, Ohio, US |
2122360 | 2122360 | 2020-12-20 | US | Pennsylvania | Centre | 42027 | 8516 | 124 | 0 | 8392 | 40.92058903 | -77.82200624 | 2020-12-21 05:27:58 | Centre, Pennsylvania, US |
2123435 | 2123435 | 2021-10-21 | Barbados | 14326 | 124 | 0 | 13.1939 | -59.5432 | 2021-10-22 04:21:14 | Barbados | ||||
2124644 | 2124644 | 2021-10-21 | US | Georgia | White | 13311 | 4771 | 124 | 0 | 34.64624278 | -83.74905525 | 2021-10-22 04:21:14 | White, Georgia, US | |
2124717 | 2124717 | 2021-10-21 | US | Illinois | Coles | 17029 | 7895 | 124 | 0 | 39.51949084 | -88.22358557 | 2021-10-22 04:21:14 | Coles, Illinois, US | |
2125017 | 2125017 | 2021-10-21 | US | Kansas | Cowley | 20035 | 5552 | 124 | 0 | 37.23781842 | -96.83776647 | 2021-10-22 04:21:14 | Cowley, Kansas, US | |
2125251 | 2125251 | 2021-10-21 | US | Louisiana | Iberville | 22047 | 5796 | 124 | 0 | 30.25734305 | -91.3499598 | 2021-10-22 04:21:14 | Iberville, Louisiana, US | |
2125411 | 2125411 | 2021-10-21 | US | Michigan | Montcalm | 26117 | 8390 | 124 | 0 | 43.31082541 | -85.15252824 | 2021-10-22 04:21:14 | Montcalm, Michigan, US | |
2125516 | 2125516 | 2021-10-21 | US | Minnesota | Unassigned | 90027 | 529 | 124 | 0 | 48.77754106 | 0.0 | 2021-10-22 04:21:14 | Unassigned, Minnesota, US | |
2125895 | 2125895 | 2021-10-21 | US | New Hampshire | Belknap | 33001 | 6104 | 124 | 0 | 43.51637314 | -71.41684235 | 2021-10-22 04:21:14 | Belknap, New Hampshire, US | |
2126058 | 2126058 | 2021-10-21 | US | North Carolina | Edgecombe | 37065 | 7870 | 124 | 0 | 35.91230639 | -77.59436892 | 2021-10-22 04:21:14 | Edgecombe, North Carolina, US | |
2126084 | 2126084 | 2021-10-21 | US | North Carolina | McDowell | 37111 | 8541 | 124 | 0 | 35.67736232 | -82.0482425 | 2021-10-22 04:21:14 | McDowell, North Carolina, US | |
2126765 | 2126765 | 2021-10-21 | US | Texas | Bee | 48025 | 5961 | 124 | 0 | 28.41761668 | -97.74215593 | 2021-10-22 04:21:14 | Bee, Texas, US | |
2127826 | 2127826 | 2020-12-17 | Colombia | Amazonas | 3189 | 124 | 3043 | 22 | -1.4429 | -71.5724 | 2020-12-18 05:28:18 | Amazonas, Colombia | ||
2128272 | 2128272 | 2020-12-17 | Somalia | 4662 | 124 | 3566 | 972 | 5.152149 | 46.199616 | 2020-12-18 05:28:18 | Somalia | |||
2132020 | 2132020 | 2021-10-01 | Japan | Ishikawa | 7876 | 124 | 0 | 36.769464 | 136.771027 | 2021-10-02 04:21:25 | Ishikawa, Japan | |||
2132391 | 2132391 | 2021-10-01 | US | Alabama | Escambia | 1053 | 6632 | 124 | 0 | 31.1256789 | -87.15918694 | 2021-10-02 04:21:25 | Escambia, Alabama, US | |
2132411 | 2132411 | 2021-10-01 | US | Alabama | Marion | 1093 | 4861 | 124 | 0 | 34.13697363 | -87.88704173 | 2021-10-02 04:21:25 | Marion, Alabama, US | |
2133856 | 2133856 | 2021-10-01 | US | Mississippi | Oktibbeha | 28105 | 7034 | 124 | 0 | 33.42491685 | -88.87905132 | 2021-10-02 04:21:25 | Oktibbeha, Mississippi, US | |
2135167 | 2135167 | 2021-10-01 | US | Texas | Kleberg | 48273 | 4395 | 124 | 0 | 27.42435506 | -97.69894948 | 2021-10-02 04:21:25 | Kleberg, Texas, US | |
2135361 | 2135361 | 2021-10-01 | US | Virginia | Frederick | 51069 | 10657 | 124 | 0 | 39.20172582 | -78.25974949 | 2021-10-02 04:21:25 | Frederick, Virginia, US | |
2136179 | 2136179 | 2022-12-01 | Japan | Shimane | 106606 | 124 | 0 | 35.07076 | 132.554064 | 2022-12-02 04:21:07 | Shimane, Japan | |||
2136993 | 2136993 | 2022-12-01 | US | Georgia | Lamar | 13171 | 5591 | 124 | 0 | 33.07841647 | -84.14263877 | 2022-12-02 04:21:07 | Lamar, Georgia, US | |
2137302 | 2137302 | 2022-12-01 | US | Indiana | Steuben | 18151 | 11032 | 124 | 0 | 41.64423868 | -85.00101094 | 2022-12-02 04:21:07 | Steuben, Indiana, US | |
2137602 | 2137602 | 2022-12-01 | US | Kentucky | Marshall | 21157 | 9737 | 124 | 0 | 36.8800707 | -88.32803576 | 2022-12-02 04:21:07 | Marshall, Kentucky, US | |
2137786 | 2137786 | 2022-12-01 | US | Michigan | Cheboygan | 26031 | 5602 | 124 | 0 | 45.44787015 | -84.50122149 | 2022-12-02 04:21:07 | Cheboygan, Michigan, US | |
2137917 | 2137917 | 2022-12-01 | US | Minnesota | Polk | 27119 | 10302 | 124 | 0 | 47.77372465 | -96.40134647 | 2022-12-02 04:21:07 | Polk, Minnesota, US | |
2138792 | 2138792 | 2022-12-01 | US | Oregon | Malheur | 41045 | 9363 | 124 | 0 | 43.1937027 | -117.6227395 | 2022-12-02 04:21:07 | Malheur, Oregon, US | |
2139591 | 2139591 | 2022-12-01 | US | Virginia | York | 51199 | 12881 | 124 | 0 | 37.24374789 | -76.54412815 | 2022-12-02 04:21:07 | York, Virginia, US | |
2139736 | 2139736 | 2022-12-01 | US | Wisconsin | Polk | 55095 | 14615 | 124 | 0 | 45.46130348 | -92.44182875 | 2022-12-02 04:21:07 | Polk, Wisconsin, US | |
2140524 | 2140524 | 2022-03-09 | US | Alabama | Butler | 1013 | 5041 | 124 | 0 | 31.75300095 | -86.68057478 | 2022-03-10 04:20:48 | Butler, Alabama, US | |
2140734 | 2140734 | 2022-03-09 | US | California | Mendocino | 6045 | 15931 | 124 | 0 | 39.4381191 | -123.39113130000001 | 2022-03-10 04:20:48 | Mendocino, California, US | |
2141032 | 2141032 | 2022-03-09 | US | Georgia | Peach | 13225 | 6106 | 124 | 0 | 32.56934316 | -83.82937 | 2022-03-10 04:20:48 | Peach, Georgia, US | |
2141450 | 2141450 | 2022-03-09 | US | Kansas | Crawford | 20037 | 11844 | 124 | 0 | 37.50675523 | -94.85245778 | 2022-03-10 04:20:48 | Crawford, Kansas, US | |
2141490 | 2141490 | 2022-03-09 | US | Kansas | McPherson | 20113 | 7770 | 124 | 0 | 38.39184858 | -97.64769869 | 2022-03-10 04:20:48 | McPherson, Kansas, US | |
2141873 | 2141873 | 2022-03-09 | US | Minnesota | Beltrami | 27007 | 11450 | 124 | 0 | 47.97373527 | -94.93732139 | 2022-03-10 04:20:48 | Beltrami, Minnesota, US | |
2142095 | 2142095 | 2022-03-09 | US | Missouri | Lafayette | 29107 | 7724 | 124 | 0 | 39.06986886 | -93.78076396 | 2022-03-10 04:20:48 | Lafayette, Missouri, US | |
2142576 | 2142576 | 2022-03-09 | US | North Dakota | Grand Forks | 38035 | 21997 | 124 | 0 | 47.92093639 | -97.45450447 | 2022-03-10 04:20:48 | Grand Forks, North Dakota, US | |
2142836 | 2142836 | 2022-03-09 | US | Pennsylvania | Clinton | 42035 | 8995 | 124 | 0 | 41.23255967 | -77.63785995 | 2022-03-10 04:20:48 | Clinton, Pennsylvania, US | |
2143143 | 2143143 | 2022-03-09 | US | Tennessee | Marion | 47115 | 8821 | 124 | 0 | 35.12997174 | -85.62265895 | 2022-03-10 04:20:48 | Marion, Tennessee, US | |
2143710 | 2143710 | 2022-03-09 | US | Wisconsin | Columbia | 55021 | 15110 | 124 | 0 | 43.46492199 | -89.33589004 | 2022-03-10 04:20:48 | Columbia, Wisconsin, US | |
2148185 | 2148185 | 2022-06-27 | US | California | Calaveras | 6009 | 8216 | 124 | 0 | 38.20537103 | -120.552913 | 2022-06-28 04:20:58 | Calaveras, California, US | |
2148240 | 2148240 | 2022-06-27 | US | California | Yuba | 6115 | 18535 | 124 | 0 | 39.26255932 | -121.3535644 | 2022-06-28 04:20:58 | Yuba, California, US | |
2148956 | 2148956 | 2022-06-27 | US | Kansas | Lyon | 20111 | 10396 | 124 | 0 | 38.45576156 | -96.15275715 | 2022-06-28 04:20:58 | Lyon, Kansas, US | |
2149576 | 2149576 | 2022-06-27 | US | Missouri | Miller | 29131 | 6231 | 124 | 0 | 38.21450288 | -92.42610898 | 2022-06-28 04:20:58 | Miller, Missouri, US | |
2149871 | 2149871 | 2022-06-27 | US | New York | Chenango | 36017 | 10248 | 124 | 0 | 42.49430041 | -75.60887553 | 2022-06-28 04:20:58 | Chenango, New York, US | |
2150148 | 2150148 | 2022-06-27 | US | Ohio | Pike | 39131 | 7766 | 124 | 0 | 39.07634001 | -83.06769584 | 2022-06-28 04:20:58 | Pike, Ohio, US | |
2150725 | 2150725 | 2022-06-27 | US | Texas | Erath | 48143 | 8897 | 124 | 0 | 32.23602653 | -98.21773417 | 2022-06-28 04:20:58 | Erath, Texas, US | |
2150746 | 2150746 | 2022-06-27 | US | Texas | Grimes | 48185 | 8781 | 124 | 0 | 30.54579585 | -95.98902499 | 2022-06-28 04:20:58 | Grimes, Texas, US | |
2150800 | 2150800 | 2022-06-27 | US | Texas | Limestone | 48293 | 5226 | 124 | 0 | 31.5454767 | -96.58095444 | 2022-06-28 04:20:58 | Limestone, Texas, US | |
2150954 | 2150954 | 2022-06-27 | US | Virginia | Buchanan | 51027 | 5010 | 124 | 0 | 37.26818323 | -82.03749726 | 2022-06-28 04:20:58 | Buchanan, Virginia, US | |
2151016 | 2151016 | 2022-06-27 | US | Virginia | Martinsville | 51690 | 3614 | 124 | 0 | 36.68212094 | -79.86352771 | 2022-06-28 04:20:58 | Martinsville, Virginia, US | |
2151142 | 2151142 | 2022-06-27 | US | West Virginia | Mingo | 54059 | 8204 | 124 | 0 | 37.73048351 | -82.13338365 | 2022-06-28 04:20:58 | Mingo, West Virginia, US | |
2152256 | 2152256 | 2022-07-16 | US | California | Yuba | 6115 | 19081 | 124 | 0 | 39.26255932 | -121.3535644 | 2022-07-17 04:21:15 | Yuba, California, US | |
2152658 | 2152658 | 2022-07-16 | US | Illinois | Jackson | 17077 | 17272 | 124 | 0 | 37.78595185 | -89.38232563 | 2022-07-17 04:21:15 | Jackson, Illinois, US | |
2152783 | 2152783 | 2022-07-16 | US | Indiana | Owen | 18119 | 6204 | 124 | 0 | 39.31145587 | -86.83900724 | 2022-07-17 04:21:15 | Owen, Indiana, US | |
2153112 | 2153112 | 2022-07-16 | US | Kentucky | Muhlenberg | 21177 | 10850 | 124 | 0 | 37.21425819 | -87.14632053 | 2022-07-17 04:21:15 | Muhlenberg, Kentucky, US | |
2153589 | 2153589 | 2022-07-16 | US | Missouri | Marion | 29127 | 8505 | 124 | 0 | 39.80601912 | -91.62203062 | 2022-07-17 04:21:15 | Marion, Missouri, US | |
2153592 | 2153592 | 2022-07-16 | US | Missouri | Miller | 29131 | 6346 | 124 | 0 | 38.21450288 | -92.42610898 | 2022-07-17 04:21:15 | Miller, Missouri, US | |
2153887 | 2153887 | 2022-07-16 | US | New York | Chenango | 36017 | 10345 | 124 | 0 | 42.49430041 | -75.60887553 | 2022-07-17 04:21:15 | Chenango, New York, US | |
2153890 | 2153890 | 2022-07-16 | US | New York | Cortland | 36023 | 11740 | 124 | 0 | 42.59509207 | -76.07048931 | 2022-07-17 04:21:15 | Cortland, New York, US | |
2154164 | 2154164 | 2022-07-16 | US | Ohio | Pike | 39131 | 8005 | 124 | 0 | 39.07634001 | -83.06769584 | 2022-07-17 04:21:15 | Pike, Ohio, US | |
2154741 | 2154741 | 2022-07-16 | US | Texas | Erath | 48143 | 9011 | 124 | 0 | 32.23602653 | -98.21773417 | 2022-07-17 04:21:15 | Erath, Texas, US | |
2154816 | 2154816 | 2022-07-16 | US | Texas | Limestone | 48293 | 5331 | 124 | 0 | 31.5454767 | -96.58095444 | 2022-07-17 04:21:15 | Limestone, Texas, US | |
2155032 | 2155032 | 2022-07-16 | US | Virginia | Martinsville | 51690 | 3684 | 124 | 0 | 36.68212094 | -79.86352771 | 2022-07-17 04:21:15 | Martinsville, Virginia, US | |
2155158 | 2155158 | 2022-07-16 | US | West Virginia | Mingo | 54059 | 8379 | 124 | 0 | 37.73048351 | -82.13338365 | 2022-07-17 04:21:15 | Mingo, West Virginia, US | |
2155184 | 2155184 | 2022-07-16 | US | West Virginia | Wyoming | 54109 | 7609 | 124 | 0 | 37.612327 | -81.54511071 | 2022-07-17 04:21:15 | Wyoming, West Virginia, US | |
2155227 | 2155227 | 2022-07-16 | US | Wisconsin | Oconto | 55083 | 11942 | 124 | 0 | 45.02715345 | -88.26807503 | 2022-07-17 04:21:15 | Oconto, Wisconsin, US | |
2160367 | 2160367 | 2022-10-16 | US | Georgia | Lamar | 13171 | 5541 | 124 | 0 | 33.07841647 | -84.14263877 | 2022-10-17 04:20:31 | Lamar, Georgia, US | |
2160383 | 2160383 | 2022-10-16 | US | Georgia | Mitchell | 13205 | 5995 | 124 | 0 | 31.22483255 | -84.19381821 | 2022-10-17 04:20:31 | Mitchell, Georgia, US | |
2160443 | 2160443 | 2022-10-16 | US | Georgia | Worth | 13321 | 5268 | 124 | 0 | 31.55162306 | -83.85090513 | 2022-10-17 04:20:31 | Worth, Georgia, US | |
2160757 | 2160757 | 2022-10-16 | US | Iowa | Marshall | 19127 | 10751 | 124 | 0 | 42.03586837 | -92.9990819 | 2022-10-17 04:20:31 | Marshall, Iowa, US | |
2160976 | 2160976 | 2022-10-16 | US | Kentucky | Marshall | 21157 | 9472 | 124 | 0 | 36.8800707 | -88.32803576 | 2022-10-17 04:20:31 | Marshall, Kentucky, US | |
2161244 | 2161244 | 2022-10-16 | US | Minnesota | Chisago | 27025 | 16451 | 124 | 0 | 45.5021011 | -92.90861945 | 2022-10-17 04:20:31 | Chisago, Minnesota, US | |
2161252 | 2161252 | 2022-10-16 | US | Minnesota | Douglas | 27041 | 12454 | 124 | 0 | 45.93348491 | -95.45335469 | 2022-10-17 04:20:31 | Douglas, Minnesota, US | |
2161334 | 2161334 | 2022-10-16 | US | Mississippi | Copiah | 28029 | 8652 | 124 | 0 | 31.86977774 | -90.44565118 | 2022-10-17 04:20:31 | Copiah, Mississippi, US | |
2161359 | 2161359 | 2022-10-16 | US | Mississippi | Leake | 28079 | 7290 | 124 | 0 | 32.7536828 | -89.52402044 | 2022-10-17 04:20:31 | Leake, Mississippi, 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]);