ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,245 rows where date = "2020-11-30" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 254
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 106
- Illinois 102
- Iowa 100
- North Carolina 100
- Tennessee 96
- Nebraska 93
- Indiana 92
- Minnesota 88
- Ohio 88
- Michigan 84
- Mississippi 82
- Puerto Rico 79
- Oklahoma 78
- Arkansas 76
- Wisconsin 72
- Florida 68
- Alabama 67
- Pennsylvania 67
- South Dakota 66
- Louisiana 65
- Colorado 64
- California 58
- New York 58
- Montana 56
- West Virginia 55
- …
fips >30
county >30
- Washington 31
- Jefferson 26
- Franklin 25
- Unknown 25
- Jackson 24
- Lincoln 24
- Madison 20
- Clay 18
- Montgomery 18
- Union 18
- Marion 17
- Monroe 17
- Wayne 16
- Grant 15
- Greene 14
- Warren 14
- Carroll 13
- Adams 12
- Clark 12
- Douglas 12
- Johnson 12
- Lake 12
- Lee 12
- Marshall 12
- Polk 12
- Calhoun 11
- Crawford 11
- Fayette 11
- Lawrence 11
- Morgan 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
780890 | 780890 | 2020-11-30 | Autauga | Alabama | 1001 | 2780 | 42 |
780891 | 780891 | 2020-11-30 | Baldwin | Alabama | 1003 | 8890 | 98 |
780892 | 780892 | 2020-11-30 | Barbour | Alabama | 1005 | 1178 | 11 |
780893 | 780893 | 2020-11-30 | Bibb | Alabama | 1007 | 1196 | 17 |
780894 | 780894 | 2020-11-30 | Blount | Alabama | 1009 | 2997 | 40 |
780895 | 780895 | 2020-11-30 | Bullock | Alabama | 1011 | 702 | 19 |
780896 | 780896 | 2020-11-30 | Butler | Alabama | 1013 | 1178 | 42 |
780897 | 780897 | 2020-11-30 | Calhoun | Alabama | 1015 | 6430 | 121 |
780898 | 780898 | 2020-11-30 | Chambers | Alabama | 1017 | 1779 | 50 |
780899 | 780899 | 2020-11-30 | Cherokee | Alabama | 1019 | 1034 | 24 |
780900 | 780900 | 2020-11-30 | Chilton | Alabama | 1021 | 2274 | 38 |
780901 | 780901 | 2020-11-30 | Choctaw | Alabama | 1023 | 427 | 13 |
780902 | 780902 | 2020-11-30 | Clarke | Alabama | 1025 | 1598 | 19 |
780903 | 780903 | 2020-11-30 | Clay | Alabama | 1027 | 920 | 24 |
780904 | 780904 | 2020-11-30 | Cleburne | Alabama | 1029 | 778 | 14 |
780905 | 780905 | 2020-11-30 | Coffee | Alabama | 1031 | 2483 | 15 |
780906 | 780906 | 2020-11-30 | Colbert | Alabama | 1033 | 3296 | 42 |
780907 | 780907 | 2020-11-30 | Conecuh | Alabama | 1035 | 688 | 14 |
780908 | 780908 | 2020-11-30 | Coosa | Alabama | 1037 | 354 | 4 |
780909 | 780909 | 2020-11-30 | Covington | Alabama | 1039 | 2204 | 34 |
780910 | 780910 | 2020-11-30 | Crenshaw | Alabama | 1041 | 720 | 30 |
780911 | 780911 | 2020-11-30 | Cullman | Alabama | 1043 | 4515 | 42 |
780912 | 780912 | 2020-11-30 | Dale | Alabama | 1045 | 2362 | 54 |
780913 | 780913 | 2020-11-30 | Dallas | Alabama | 1047 | 2268 | 32 |
780914 | 780914 | 2020-11-30 | DeKalb | Alabama | 1049 | 4922 | 36 |
780915 | 780915 | 2020-11-30 | Elmore | Alabama | 1051 | 4129 | 64 |
780916 | 780916 | 2020-11-30 | Escambia | Alabama | 1053 | 1989 | 31 |
780917 | 780917 | 2020-11-30 | Etowah | Alabama | 1055 | 6439 | 66 |
780918 | 780918 | 2020-11-30 | Fayette | Alabama | 1057 | 925 | 16 |
780919 | 780919 | 2020-11-30 | Franklin | Alabama | 1059 | 2564 | 34 |
780920 | 780920 | 2020-11-30 | Geneva | Alabama | 1061 | 1243 | 8 |
780921 | 780921 | 2020-11-30 | Greene | Alabama | 1063 | 428 | 18 |
780922 | 780922 | 2020-11-30 | Hale | Alabama | 1065 | 978 | 31 |
780923 | 780923 | 2020-11-30 | Henry | Alabama | 1067 | 875 | 6 |
780924 | 780924 | 2020-11-30 | Houston | Alabama | 1069 | 5377 | 38 |
780925 | 780925 | 2020-11-30 | Jackson | Alabama | 1071 | 3298 | 23 |
780926 | 780926 | 2020-11-30 | Jefferson | Alabama | 1073 | 33064 | 500 |
780927 | 780927 | 2020-11-30 | Lamar | Alabama | 1075 | 689 | 8 |
780928 | 780928 | 2020-11-30 | Lauderdale | Alabama | 1077 | 4223 | 54 |
780929 | 780929 | 2020-11-30 | Lawrence | Alabama | 1079 | 1316 | 36 |
780930 | 780930 | 2020-11-30 | Lee | Alabama | 1081 | 7814 | 66 |
780931 | 780931 | 2020-11-30 | Limestone | Alabama | 1083 | 4333 | 45 |
780932 | 780932 | 2020-11-30 | Lowndes | Alabama | 1085 | 802 | 29 |
780933 | 780933 | 2020-11-30 | Macon | Alabama | 1087 | 745 | 22 |
780934 | 780934 | 2020-11-30 | Madison | Alabama | 1089 | 13596 | 148 |
780935 | 780935 | 2020-11-30 | Marengo | Alabama | 1091 | 1231 | 24 |
780936 | 780936 | 2020-11-30 | Marion | Alabama | 1093 | 1436 | 36 |
780937 | 780937 | 2020-11-30 | Marshall | Alabama | 1095 | 6353 | 55 |
780938 | 780938 | 2020-11-30 | Mobile | Alabama | 1097 | 19951 | 362 |
780939 | 780939 | 2020-11-30 | Monroe | Alabama | 1099 | 790 | 11 |
780940 | 780940 | 2020-11-30 | Montgomery | Alabama | 1101 | 12435 | 236 |
780941 | 780941 | 2020-11-30 | Morgan | Alabama | 1103 | 6861 | 50 |
780942 | 780942 | 2020-11-30 | Perry | Alabama | 1105 | 690 | 6 |
780943 | 780943 | 2020-11-30 | Pickens | Alabama | 1107 | 1257 | 18 |
780944 | 780944 | 2020-11-30 | Pike | Alabama | 1109 | 1599 | 14 |
780945 | 780945 | 2020-11-30 | Randolph | Alabama | 1111 | 1049 | 21 |
780946 | 780946 | 2020-11-30 | Russell | Alabama | 1113 | 2238 | 3 |
780947 | 780947 | 2020-11-30 | Shelby | Alabama | 1117 | 10616 | 77 |
780948 | 780948 | 2020-11-30 | St. Clair | Alabama | 1115 | 4325 | 55 |
780949 | 780949 | 2020-11-30 | Sumter | Alabama | 1119 | 586 | 22 |
780950 | 780950 | 2020-11-30 | Talladega | Alabama | 1121 | 3593 | 54 |
780951 | 780951 | 2020-11-30 | Tallapoosa | Alabama | 1123 | 1843 | 91 |
780952 | 780952 | 2020-11-30 | Tuscaloosa | Alabama | 1125 | 13246 | 154 |
780953 | 780953 | 2020-11-30 | Walker | Alabama | 1127 | 3710 | 111 |
780954 | 780954 | 2020-11-30 | Washington | Alabama | 1129 | 922 | 19 |
780955 | 780955 | 2020-11-30 | Wilcox | Alabama | 1131 | 642 | 18 |
780956 | 780956 | 2020-11-30 | Winston | Alabama | 1133 | 1351 | 23 |
780957 | 780957 | 2020-11-30 | Aleutians East Borough | Alaska | 2013 | 37 | 0 |
780958 | 780958 | 2020-11-30 | Aleutians West Census Area | Alaska | 2016 | 108 | 0 |
780959 | 780959 | 2020-11-30 | Anchorage | Alaska | 2020 | 16781 | 67 |
780960 | 780960 | 2020-11-30 | Bethel Census Area | Alaska | 2050 | 1577 | 5 |
780961 | 780961 | 2020-11-30 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 144 | 0 |
780962 | 780962 | 2020-11-30 | Denali Borough | Alaska | 2068 | 43 | 0 |
780963 | 780963 | 2020-11-30 | Dillingham Census Area | Alaska | 2070 | 100 | 1 |
780964 | 780964 | 2020-11-30 | Fairbanks North Star Borough | Alaska | 2090 | 3467 | 17 |
780965 | 780965 | 2020-11-30 | Haines Borough | Alaska | 2100 | 16 | 0 |
780966 | 780966 | 2020-11-30 | Juneau City and Borough | Alaska | 2110 | 844 | 3 |
780967 | 780967 | 2020-11-30 | Kenai Peninsula Borough | Alaska | 2122 | 2584 | 7 |
780968 | 780968 | 2020-11-30 | Ketchikan Gateway Borough | Alaska | 2130 | 193 | 0 |
780969 | 780969 | 2020-11-30 | Kodiak Island Borough | Alaska | 2150 | 283 | 0 |
780970 | 780970 | 2020-11-30 | Kusilvak Census Area | Alaska | 2158 | 424 | 1 |
780971 | 780971 | 2020-11-30 | Matanuska-Susitna Borough | Alaska | 2170 | 3544 | 6 |
780972 | 780972 | 2020-11-30 | Nome Census Area | Alaska | 2180 | 229 | 0 |
780973 | 780973 | 2020-11-30 | North Slope Borough | Alaska | 2185 | 463 | 0 |
780974 | 780974 | 2020-11-30 | Northwest Arctic Borough | Alaska | 2188 | 359 | 0 |
780975 | 780975 | 2020-11-30 | Petersburg Borough | Alaska | 2195 | 22 | 0 |
780976 | 780976 | 2020-11-30 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 50 | 1 |
780977 | 780977 | 2020-11-30 | Sitka City and Borough | Alaska | 2220 | 195 | 0 |
780978 | 780978 | 2020-11-30 | Skagway Municipality | Alaska | 2230 | 10 | 0 |
780979 | 780979 | 2020-11-30 | Southeast Fairbanks Census Area | Alaska | 2240 | 283 | 2 |
780980 | 780980 | 2020-11-30 | Unknown | Alaska | 158 | 0 | |
780981 | 780981 | 2020-11-30 | Valdez-Cordova Census Area | Alaska | 2261 | 255 | 2 |
780982 | 780982 | 2020-11-30 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
780983 | 780983 | 2020-11-30 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 48 | 0 |
780984 | 780984 | 2020-11-30 | Yukon-Koyukuk Census Area | Alaska | 2290 | 171 | 3 |
780985 | 780985 | 2020-11-30 | Apache | Arizona | 4001 | 5392 | 196 |
780986 | 780986 | 2020-11-30 | Cochise | Arizona | 4003 | 3748 | 79 |
780987 | 780987 | 2020-11-30 | Coconino | Arizona | 4005 | 7520 | 171 |
780988 | 780988 | 2020-11-30 | Gila | Arizona | 4007 | 3003 | 92 |
780989 | 780989 | 2020-11-30 | Graham | Arizona | 4009 | 2215 | 35 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);