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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
713505 | 713505 | 2022-11-01 | US | Texas | Cochran | 48079 | 962 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-11-02 04:22:09 | Cochran, Texas, US | |
713708 | 713708 | 2022-11-01 | US | Texas | Wheeler | 48483 | 1274 | 23 | 0 | 35.40114335 | -100.2699514 | 2022-11-02 04:22:09 | Wheeler, Texas, US | |
713880 | 713880 | 2022-11-01 | US | Virginia | Williamsburg | 51830 | 2173 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-02 04:22:09 | Williamsburg, Virginia, US | |
713960 | 713960 | 2022-11-01 | US | West Virginia | Pendleton | 54071 | 2236 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-02 04:22:09 | Pendleton, West Virginia, US | |
715092 | 715092 | 2021-11-12 | US | Colorado | Huerfano | 8055 | 774 | 23 | 0 | 37.68473101 | -104.9612585 | 2021-11-13 04:21:38 | Huerfano, Colorado, US | |
715402 | 715402 | 2021-11-12 | US | Idaho | Franklin | 16041 | 1679 | 23 | 0 | 42.18332217 | -111.81496659999999 | 2021-11-13 04:21:38 | Franklin, Idaho, US | |
715412 | 715412 | 2021-11-12 | US | Idaho | Lewis | 16061 | 802 | 23 | 0 | 46.23315327 | -116.434146 | 2021-11-13 04:21:38 | Lewis, Idaho, US | |
715485 | 715485 | 2021-11-12 | US | Illinois | Marshall | 17123 | 1452 | 23 | 0 | 41.0327901 | -89.34510444 | 2021-11-13 04:21:38 | Marshall, Illinois, US | |
715668 | 715668 | 2021-11-12 | US | Iowa | Howard | 19089 | 1375 | 23 | 0 | 43.35671042 | -92.31702714 | 2021-11-13 04:21:38 | Howard, Iowa, US | |
715762 | 715762 | 2021-11-12 | US | Kansas | Harper | 20077 | 940 | 23 | 0 | 37.19175361 | -98.07578384 | 2021-11-13 04:21:38 | Harper, Kansas, US | |
715771 | 715771 | 2021-11-12 | US | Kansas | Kingman | 20095 | 1238 | 23 | 0 | 37.55909527 | -98.13638678 | 2021-11-13 04:21:38 | Kingman, Kansas, US | |
715787 | 715787 | 2021-11-12 | US | Kansas | Morris | 20127 | 802 | 23 | 0 | 38.68827511 | -96.65128437 | 2021-11-13 04:21:38 | Morris, Kansas, US | |
715904 | 715904 | 2021-11-12 | US | Kentucky | Magoffin | 21153 | 2267 | 23 | 0 | 37.70820545 | -83.0657714 | 2021-11-13 04:21:38 | Magoffin, Kentucky, US | |
715913 | 715913 | 2021-11-12 | US | Kentucky | Menifee | 21165 | 867 | 23 | 0 | 37.94090733 | -83.59985712 | 2021-11-13 04:21:38 | Menifee, Kentucky, US | |
715929 | 715929 | 2021-11-12 | US | Kentucky | Powell | 21197 | 2668 | 23 | 0 | 37.83218794 | -83.82553961 | 2021-11-13 04:21:38 | Powell, Kentucky, US | |
715941 | 715941 | 2021-11-12 | US | Kentucky | Trigg | 21221 | 2219 | 23 | 0 | 36.80767017 | -87.87333656 | 2021-11-13 04:21:38 | Trigg, Kentucky, US | |
716142 | 716142 | 2021-11-12 | US | Michigan | Ontonagon | 26131 | 660 | 23 | 0 | 46.665226200000006 | -89.31390481 | 2021-11-13 04:21:38 | Ontonagon, Michigan, US | |
716389 | 716389 | 2021-11-12 | US | Missouri | Lewis | 29111 | 1770 | 23 | 0 | 40.09673161 | -91.72070156 | 2021-11-13 04:21:38 | Lewis, Missouri, US | |
716409 | 716409 | 2021-11-12 | US | Missouri | Osage | 29151 | 2211 | 23 | 0 | 38.46036182 | -91.8613635 | 2021-11-13 04:21:38 | Osage, Missouri, US | |
716672 | 716672 | 2021-11-12 | US | New Mexico | Quay | 35037 | 1116 | 23 | 0 | 35.10403332 | -103.54817270000001 | 2021-11-13 04:21:38 | Quay, New Mexico, US | |
716875 | 716875 | 2021-11-12 | US | North Dakota | McHenry | 38049 | 976 | 23 | 0 | 48.23104458 | -100.6324822 | 2021-11-13 04:21:38 | McHenry, North Dakota, US | |
717011 | 717011 | 2021-11-12 | US | Oklahoma | Cotton | 40033 | 995 | 23 | 0 | 34.28845626 | -98.37053567 | 2021-11-13 04:21:38 | Cotton, Oklahoma, US | |
717033 | 717033 | 2021-11-12 | US | Oklahoma | Latimer | 40077 | 1496 | 23 | 0 | 34.87844729 | -95.25215049 | 2021-11-13 04:21:38 | Latimer, Oklahoma, US | |
717335 | 717335 | 2021-11-12 | US | South Dakota | Fall River | 46047 | 1067 | 23 | 0 | 43.23929297 | -103.5275691 | 2021-11-13 04:21:38 | Fall River, South Dakota, US | |
717481 | 717481 | 2021-11-12 | US | Texas | Archer | 48009 | 1311 | 23 | 0 | 33.61569967 | -98.68754589 | 2021-11-13 04:21:38 | Archer, Texas, US | |
717689 | 717689 | 2021-11-12 | US | Texas | Somervell | 48425 | 1510 | 23 | 0 | 32.22236802 | -97.77403489 | 2021-11-13 04:21:38 | Somervell, Texas, US | |
717826 | 717826 | 2021-11-12 | US | Virginia | King George | 51099 | 2722 | 23 | 0 | 38.26818502 | -77.15852768 | 2021-11-13 04:21:38 | King George, Virginia, US | |
717829 | 717829 | 2021-11-12 | US | Virginia | Lancaster | 51103 | 1074 | 23 | 0 | 37.71889653 | -76.46400482 | 2021-11-13 04:21:38 | Lancaster, Virginia, US | |
717836 | 717836 | 2021-11-12 | US | Virginia | Madison | 51113 | 1030 | 23 | 0 | 38.41531222 | -78.28220331 | 2021-11-13 04:21:38 | Madison, Virginia, US | |
717917 | 717917 | 2021-11-12 | US | Washington | Lincoln | 53043 | 1449 | 23 | 0 | 47.57705241 | -118.41943880000001 | 2021-11-13 04:21:38 | Lincoln, Washington, US | |
717921 | 717921 | 2021-11-12 | US | Washington | Pend Oreille | 53051 | 1604 | 23 | 0 | 48.53234021 | -117.2741804 | 2021-11-13 04:21:38 | Pend Oreille, Washington, US | |
718003 | 718003 | 2021-11-12 | US | Wisconsin | Crawford | 55023 | 2470 | 23 | 0 | 43.23870316 | -90.93073686 | 2021-11-13 04:21:38 | Crawford, Wisconsin, US | |
718076 | 718076 | 2021-11-12 | US | Wyoming | Lincoln | 56023 | 2891 | 23 | 0 | 42.26376367 | -110.6563997 | 2021-11-13 04:21:38 | Lincoln, Wyoming, US | |
718131 | 718131 | 2021-11-12 | United Kingdom | Turks and Caicos Islands | 3031 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-11-13 04:21:38 | Turks and Caicos Islands, United Kingdom | |||
718146 | 718146 | 2021-11-12 | United Kingdom | Guernsey | 2572 | 23 | 0 | 0 | 49.448196 | -2.58949 | 2021-11-13 04:21:38 | Guernsey, United Kingdom | ||
718276 | 718276 | 2022-12-04 | China | Henan | 7714 | 23 | 0 | 33.882 | 113.614 | 2022-12-05 04:20:58 | Henan, China | |||
719133 | 719133 | 2022-12-04 | US | Colorado | Park | 8093 | 3401 | 23 | 0 | 39.120926 | -105.7182065 | 2022-12-05 04:20:58 | Park, Colorado, US | |
719522 | 719522 | 2022-12-04 | US | Illinois | Piatt | 17147 | 5265 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-12-05 04:20:58 | Piatt, Illinois, US | |
719649 | 719649 | 2022-12-04 | US | Iowa | Audubon | 19009 | 1267 | 23 | 0 | 41.6844628 | -94.90581859 | 2022-12-05 04:20:58 | Audubon, Iowa, US | |
719776 | 719776 | 2022-12-04 | US | Kansas | Gove | 20063 | 902 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-12-05 04:20:58 | Gove, Kansas, US | |
719779 | 719779 | 2022-12-04 | US | Kansas | Gray | 20069 | 1344 | 23 | 0 | 37.73836671 | -100.4369088 | 2022-12-05 04:20:58 | Gray, Kansas, US | |
719836 | 719836 | 2022-12-04 | US | Kansas | Sherman | 20181 | 1749 | 23 | 0 | 39.35147699 | -101.7197624 | 2022-12-05 04:20:58 | Sherman, Kansas, US | |
719871 | 719871 | 2022-12-04 | US | Kentucky | Carlisle | 21039 | 1285 | 23 | 0 | 36.85372876 | -88.9669222 | 2022-12-05 04:20:58 | Carlisle, Kentucky, US | |
720085 | 720085 | 2022-12-04 | US | Massachusetts | Dukes and Nantucket | 8032 | 23 | 0 | 41.40674725 | -70.68763497 | 2022-12-05 04:20:58 | Dukes and Nantucket, Massachusetts, US | ||
720202 | 720202 | 2022-12-04 | US | Minnesota | Dodge | 27039 | 6547 | 23 | 0 | 44.02238415 | -92.86244324 | 2022-12-05 04:20:58 | Dodge, Minnesota, US | |
720267 | 720267 | 2022-12-04 | US | Minnesota | Wilkin | 27167 | 1869 | 23 | 0 | 46.35721532 | -96.4684375 | 2022-12-05 04:20:58 | Wilkin, Minnesota, US | |
720538 | 720538 | 2022-12-04 | US | Nebraska | Burt | 31021 | 1467 | 23 | 0 | 41.85056773 | -96.32605633 | 2022-12-05 04:20:58 | Burt, Nebraska, US | |
720600 | 720600 | 2022-12-04 | US | Nebraska | Red Willow | 31145 | 2566 | 23 | 0 | 40.1755688 | -100.476998 | 2022-12-05 04:20:58 | Red Willow, Nebraska, US | |
720639 | 720639 | 2022-12-04 | US | Nevada | White Pine | 32033 | 1751 | 23 | 0 | 39.44157041 | -114.899966 | 2022-12-05 04:20:58 | White Pine, Nevada, US | |
720874 | 720874 | 2022-12-04 | US | North Dakota | Benson | 38005 | 2227 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-12-05 04:20:58 | Benson, North Dakota, US | |
720887 | 720887 | 2022-12-04 | US | North Dakota | Foster | 38031 | 1115 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-12-05 04:20:58 | Foster, North Dakota, US | |
720910 | 720910 | 2022-12-04 | US | North Dakota | Richland | 38077 | 4627 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-12-05 04:20:58 | Richland, North Dakota, US | |
721127 | 721127 | 2022-12-04 | US | Oregon | Wallowa | 41063 | 1536 | 23 | 0 | 45.57894064 | -117.183538 | 2022-12-05 04:20:58 | Wallowa, Oregon, US | |
721537 | 721537 | 2022-12-04 | US | Texas | Cochran | 48079 | 977 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-12-05 04:20:58 | Cochran, Texas, US | |
721740 | 721740 | 2022-12-04 | US | Texas | Wheeler | 48483 | 1290 | 23 | 0 | 35.40114335 | -100.2699514 | 2022-12-05 04:20:58 | Wheeler, Texas, US | |
721967 | 721967 | 2022-12-04 | US | West Virginia | Gilmer | 54021 | 2511 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-05 04:20:58 | Gilmer, West Virginia, US | |
721992 | 721992 | 2022-12-04 | US | West Virginia | Pendleton | 54071 | 2267 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-05 04:20:58 | Pendleton, West Virginia, US | |
722695 | 722695 | 2021-11-20 | Russia | Chukotka Autonomous Okrug | 2752 | 23 | 0 | 66.0006475 | 169.4900869 | 2021-11-21 04:22:13 | Chukotka Autonomous Okrug, Russia | |||
723124 | 723124 | 2021-11-20 | US | Colorado | Huerfano | 8055 | 818 | 23 | 0 | 37.68473101 | -104.9612585 | 2021-11-21 04:22:13 | Huerfano, Colorado, US | |
723344 | 723344 | 2021-11-20 | US | Georgia | Miller | 13201 | 1235 | 23 | 0 | 31.16568912 | -84.73151117 | 2021-11-21 04:22:13 | Miller, Georgia, US | |
723434 | 723434 | 2021-11-20 | US | Idaho | Franklin | 16041 | 1709 | 23 | 0 | 42.18332217 | -111.81496659999999 | 2021-11-21 04:22:13 | Franklin, Idaho, US | |
723444 | 723444 | 2021-11-20 | US | Idaho | Lewis | 16061 | 816 | 23 | 0 | 46.23315327 | -116.434146 | 2021-11-21 04:22:13 | Lewis, Idaho, US | |
723491 | 723491 | 2021-11-20 | US | Illinois | Hamilton | 17065 | 1395 | 23 | 0 | 38.08163641 | -88.53883373 | 2021-11-21 04:22:13 | Hamilton, Illinois, US | |
723517 | 723517 | 2021-11-20 | US | Illinois | Marshall | 17123 | 1477 | 23 | 0 | 41.0327901 | -89.34510444 | 2021-11-21 04:22:13 | Marshall, Illinois, US | |
723790 | 723790 | 2021-11-20 | US | Kansas | Gray | 20069 | 932 | 23 | 0 | 37.73836671 | -100.4369088 | 2021-11-21 04:22:13 | Gray, Kansas, US | |
723794 | 723794 | 2021-11-20 | US | Kansas | Harper | 20077 | 961 | 23 | 0 | 37.19175361 | -98.07578384 | 2021-11-21 04:22:13 | Harper, Kansas, US | |
723945 | 723945 | 2021-11-20 | US | Kentucky | Menifee | 21165 | 879 | 23 | 0 | 37.94090733 | -83.59985712 | 2021-11-21 04:22:13 | Menifee, Kentucky, US | |
724174 | 724174 | 2021-11-20 | US | Michigan | Ontonagon | 26131 | 680 | 23 | 0 | 46.665226200000006 | -89.31390481 | 2021-11-21 04:22:13 | Ontonagon, Michigan, US | |
724373 | 724373 | 2021-11-20 | US | Missouri | Bollinger | 29017 | 1905 | 23 | 0 | 37.32449052 | -90.02725304 | 2021-11-21 04:22:13 | Bollinger, Missouri, US | |
724421 | 724421 | 2021-11-20 | US | Missouri | Lewis | 29111 | 1816 | 23 | 0 | 40.09673161 | -91.72070156 | 2021-11-21 04:22:13 | Lewis, Missouri, US | |
724441 | 724441 | 2021-11-20 | US | Missouri | Osage | 29151 | 2275 | 23 | 0 | 38.46036182 | -91.8613635 | 2021-11-21 04:22:13 | Osage, Missouri, US | |
725043 | 725043 | 2021-11-20 | US | Oklahoma | Cotton | 40033 | 1006 | 23 | 0 | 34.28845626 | -98.37053567 | 2021-11-21 04:22:13 | Cotton, Oklahoma, US | |
725065 | 725065 | 2021-11-20 | US | Oklahoma | Latimer | 40077 | 1524 | 23 | 0 | 34.87844729 | -95.25215049 | 2021-11-21 04:22:13 | Latimer, Oklahoma, US | |
725296 | 725296 | 2021-11-20 | US | Rhode Island | Unassigned | 90044 | 13606 | 23 | 0 | 41.87064746 | 0.0 | 2021-11-21 04:22:13 | Unassigned, Rhode Island, US | |
725513 | 725513 | 2021-11-20 | US | Texas | Archer | 48009 | 1321 | 23 | 0 | 33.61569967 | -98.68754589 | 2021-11-21 04:22:13 | Archer, Texas, US | |
725787 | 725787 | 2021-11-20 | US | Vermont | Orleans | 50019 | 3307 | 23 | 0 | 44.82964024 | -72.24562697 | 2021-11-21 04:22:13 | Orleans, Vermont, US | |
725861 | 725861 | 2021-11-20 | US | Virginia | Lancaster | 51103 | 1076 | 23 | 0 | 37.71889653 | -76.46400482 | 2021-11-21 04:22:13 | Lancaster, Virginia, US | |
725868 | 725868 | 2021-11-20 | US | Virginia | Madison | 51113 | 1066 | 23 | 0 | 38.41531222 | -78.28220331 | 2021-11-21 04:22:13 | Madison, Virginia, US | |
725971 | 725971 | 2021-11-20 | US | West Virginia | Braxton | 54007 | 2325 | 23 | 0 | 38.70036159 | -80.72011184 | 2021-11-21 04:22:13 | Braxton, West Virginia, US | |
726035 | 726035 | 2021-11-20 | US | Wisconsin | Crawford | 55023 | 2561 | 23 | 0 | 43.23870316 | -90.93073686 | 2021-11-21 04:22:13 | Crawford, Wisconsin, US | |
726163 | 726163 | 2021-11-20 | United Kingdom | Turks and Caicos Islands | 3076 | 23 | 0 | 21.69400000000001 | -71.7979 | 2021-11-21 04:22:13 | Turks and Caicos Islands, United Kingdom | |||
726178 | 726178 | 2021-11-20 | United Kingdom | Guernsey | 2997 | 23 | 0 | 0 | 49.448196 | -2.58949 | 2021-11-21 04:22:13 | Guernsey, United Kingdom | ||
726996 | 726996 | 2021-05-22 | US | Arkansas | Madison | 5087 | 1463 | 23 | 0 | 36.01038185 | -93.72524943 | 2021-05-23 04:20:51 | Madison, Arkansas, US | |
727024 | 727024 | 2021-05-22 | US | Arkansas | Van Buren | 5141 | 1322 | 23 | 0 | 35.58095779 | -92.51295036 | 2021-05-23 04:20:51 | Van Buren, Arkansas, US | |
727339 | 727339 | 2021-05-22 | US | Georgia | Montgomery | 13209 | 893 | 23 | 0 | 32.17201038 | -82.53527476 | 2021-05-23 04:20:51 | Montgomery, Georgia, US | |
727432 | 727432 | 2021-05-22 | US | Idaho | Jerome | 16053 | 2616 | 23 | 0 | 42.68891267 | -114.2655033 | 2021-05-23 04:20:51 | Jerome, Idaho, US | |
727663 | 727663 | 2021-05-22 | US | Iowa | Cedar | 19031 | 1911 | 23 | 0 | 41.77233777 | -91.13246684 | 2021-05-23 04:20:51 | Cedar, Iowa, US | |
727706 | 727706 | 2021-05-22 | US | Iowa | Lucas | 19117 | 776 | 23 | 0 | 41.02958964 | -93.32780803 | 2021-05-23 04:20:51 | Lucas, Iowa, US | |
727712 | 727712 | 2021-05-22 | US | Iowa | Mills | 19129 | 1627 | 23 | 0 | 41.03299766 | -95.61920963 | 2021-05-23 04:20:51 | Mills, Iowa, US | |
727721 | 727721 | 2021-05-22 | US | Iowa | Palo Alto | 19147 | 1135 | 23 | 0 | 43.08193849 | -94.67824621 | 2021-05-23 04:20:51 | Palo Alto, Iowa, US | |
727741 | 727741 | 2021-05-22 | US | Iowa | Wayne | 19185 | 542 | 23 | 0 | 40.73969028 | -93.32752197 | 2021-05-23 04:20:51 | Wayne, Iowa, US | |
727762 | 727762 | 2021-05-22 | US | Kansas | Cloud | 20029 | 986 | 23 | 0 | 39.48028352 | -97.64925343 | 2021-05-23 04:20:51 | Cloud, Kansas, US | |
727763 | 727763 | 2021-05-22 | US | Kansas | Coffey | 20031 | 739 | 23 | 0 | 38.2365018 | -95.73379515 | 2021-05-23 04:20:51 | Coffey, Kansas, US | |
727769 | 727769 | 2021-05-22 | US | Kansas | Doniphan | 20043 | 988 | 23 | 0 | 39.79067154 | -95.14056866 | 2021-05-23 04:20:51 | Doniphan, Kansas, US | |
727882 | 727882 | 2021-05-22 | US | Kentucky | Crittenden | 21055 | 669 | 23 | 0 | 37.35839237 | -88.08826090000002 | 2021-05-23 04:20:51 | Crittenden, Kentucky, US | |
727885 | 727885 | 2021-05-22 | US | Kentucky | Edmonson | 21061 | 916 | 23 | 0 | 37.21218923 | -86.23955613 | 2021-05-23 04:20:51 | Edmonson, Kentucky, US | |
727914 | 727914 | 2021-05-22 | US | Kentucky | Knott | 21119 | 1146 | 23 | 0 | 37.35388197 | -82.94981134 | 2021-05-23 04:20:51 | Knott, Kentucky, US | |
727956 | 727956 | 2021-05-22 | US | Kentucky | Rockcastle | 21203 | 1583 | 23 | 0 | 37.36642393 | -84.31176452 | 2021-05-23 04:20:51 | Rockcastle, Kentucky, US | |
728139 | 728139 | 2021-05-22 | US | Michigan | Kalkaska | 26079 | 1110 | 23 | 0 | 44.68512729 | -85.09085699 | 2021-05-23 04:20:51 | Kalkaska, Michigan, US | |
728202 | 728202 | 2021-05-22 | US | Minnesota | Cottonwood | 27033 | 1664 | 23 | 0 | 44.00715262 | -95.18138802 | 2021-05-23 04:20:51 | Cottonwood, Minnesota, 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]);