ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,248 rows where "date" is on date 2021-08-09 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 254
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 105
- Illinois 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Nebraska 94
- Indiana 92
- Ohio 89
- Minnesota 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
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1598954 | 1598954 | 2021-08-09 | Autauga | Alabama | 1001 | 7788 | 114 |
1598955 | 1598955 | 2021-08-09 | Baldwin | Alabama | 1003 | 27477 | 330 |
1598956 | 1598956 | 2021-08-09 | Barbour | Alabama | 1005 | 2629 | 63 |
1598957 | 1598957 | 2021-08-09 | Bibb | Alabama | 1007 | 3016 | 66 |
1598958 | 1598958 | 2021-08-09 | Blount | Alabama | 1009 | 7603 | 140 |
1598959 | 1598959 | 2021-08-09 | Bullock | Alabama | 1011 | 1273 | 41 |
1598960 | 1598960 | 2021-08-09 | Butler | Alabama | 1013 | 2506 | 72 |
1598961 | 1598961 | 2021-08-09 | Calhoun | Alabama | 1015 | 15842 | 336 |
1598962 | 1598962 | 2021-08-09 | Chambers | Alabama | 1017 | 4119 | 125 |
1598963 | 1598963 | 2021-08-09 | Cherokee | Alabama | 1019 | 2074 | 48 |
1598964 | 1598964 | 2021-08-09 | Chilton | Alabama | 1021 | 4917 | 117 |
1598965 | 1598965 | 2021-08-09 | Choctaw | Alabama | 1023 | 646 | 25 |
1598966 | 1598966 | 2021-08-09 | Clarke | Alabama | 1025 | 3854 | 63 |
1598967 | 1598967 | 2021-08-09 | Clay | Alabama | 1027 | 1704 | 59 |
1598968 | 1598968 | 2021-08-09 | Cleburne | Alabama | 1029 | 1642 | 45 |
1598969 | 1598969 | 2021-08-09 | Coffee | Alabama | 1031 | 6849 | 132 |
1598970 | 1598970 | 2021-08-09 | Colbert | Alabama | 1033 | 6931 | 142 |
1598971 | 1598971 | 2021-08-09 | Conecuh | Alabama | 1035 | 1273 | 33 |
1598972 | 1598972 | 2021-08-09 | Coosa | Alabama | 1037 | 1216 | 29 |
1598973 | 1598973 | 2021-08-09 | Covington | Alabama | 1039 | 5036 | 126 |
1598974 | 1598974 | 2021-08-09 | Crenshaw | Alabama | 1041 | 1765 | 59 |
1598975 | 1598975 | 2021-08-09 | Cullman | Alabama | 1043 | 10874 | 209 |
1598976 | 1598976 | 2021-08-09 | Dale | Alabama | 1045 | 6078 | 121 |
1598977 | 1598977 | 2021-08-09 | Dallas | Alabama | 1047 | 3821 | 164 |
1598978 | 1598978 | 2021-08-09 | DeKalb | Alabama | 1049 | 9788 | 195 |
1598979 | 1598979 | 2021-08-09 | Elmore | Alabama | 1051 | 11275 | 220 |
1598980 | 1598980 | 2021-08-09 | Escambia | Alabama | 1053 | 4778 | 83 |
1598981 | 1598981 | 2021-08-09 | Etowah | Alabama | 1055 | 15427 | 372 |
1598982 | 1598982 | 2021-08-09 | Fayette | Alabama | 1057 | 2306 | 65 |
1598983 | 1598983 | 2021-08-09 | Franklin | Alabama | 1059 | 4752 | 81 |
1598984 | 1598984 | 2021-08-09 | Geneva | Alabama | 1061 | 3044 | 85 |
1598985 | 1598985 | 2021-08-09 | Greene | Alabama | 1063 | 1004 | 38 |
1598986 | 1598986 | 2021-08-09 | Hale | Alabama | 1065 | 2413 | 79 |
1598987 | 1598987 | 2021-08-09 | Henry | Alabama | 1067 | 2298 | 45 |
1598988 | 1598988 | 2021-08-09 | Houston | Alabama | 1069 | 12782 | 294 |
1598989 | 1598989 | 2021-08-09 | Jackson | Alabama | 1071 | 7539 | 119 |
1598990 | 1598990 | 2021-08-09 | Jefferson | Alabama | 1073 | 88521 | 1598 |
1598991 | 1598991 | 2021-08-09 | Lamar | Alabama | 1075 | 1549 | 38 |
1598992 | 1598992 | 2021-08-09 | Lauderdale | Alabama | 1077 | 10614 | 255 |
1598993 | 1598993 | 2021-08-09 | Lawrence | Alabama | 1079 | 3321 | 100 |
1598994 | 1598994 | 2021-08-09 | Lee | Alabama | 1081 | 17797 | 184 |
1598995 | 1598995 | 2021-08-09 | Limestone | Alabama | 1083 | 11095 | 161 |
1598996 | 1598996 | 2021-08-09 | Lowndes | Alabama | 1085 | 1476 | 55 |
1598997 | 1598997 | 2021-08-09 | Macon | Alabama | 1087 | 1756 | 52 |
1598998 | 1598998 | 2021-08-09 | Madison | Alabama | 1089 | 38537 | 535 |
1598999 | 1598999 | 2021-08-09 | Marengo | Alabama | 1091 | 2688 | 67 |
1599000 | 1599000 | 2021-08-09 | Marion | Alabama | 1093 | 3591 | 107 |
1599001 | 1599001 | 2021-08-09 | Marshall | Alabama | 1095 | 13582 | 238 |
1599002 | 1599002 | 2021-08-09 | Mobile | Alabama | 1097 | 53527 | 889 |
1599003 | 1599003 | 2021-08-09 | Monroe | Alabama | 1099 | 2161 | 42 |
1599004 | 1599004 | 2021-08-09 | Montgomery | Alabama | 1101 | 26953 | 628 |
1599005 | 1599005 | 2021-08-09 | Morgan | Alabama | 1103 | 15516 | 291 |
1599006 | 1599006 | 2021-08-09 | Perry | Alabama | 1105 | 1128 | 28 |
1599007 | 1599007 | 2021-08-09 | Pickens | Alabama | 1107 | 2516 | 62 |
1599008 | 1599008 | 2021-08-09 | Pike | Alabama | 1109 | 3470 | 79 |
1599009 | 1599009 | 2021-08-09 | Randolph | Alabama | 1111 | 2097 | 44 |
1599010 | 1599010 | 2021-08-09 | Russell | Alabama | 1113 | 4940 | 43 |
1599011 | 1599011 | 2021-08-09 | Shelby | Alabama | 1117 | 28336 | 263 |
1599012 | 1599012 | 2021-08-09 | St. Clair | Alabama | 1115 | 11205 | 252 |
1599013 | 1599013 | 2021-08-09 | Sumter | Alabama | 1119 | 1119 | 34 |
1599014 | 1599014 | 2021-08-09 | Talladega | Alabama | 1121 | 9200 | 188 |
1599015 | 1599015 | 2021-08-09 | Tallapoosa | Alabama | 1123 | 4734 | 157 |
1599016 | 1599016 | 2021-08-09 | Tuscaloosa | Alabama | 1125 | 27853 | 466 |
1599017 | 1599017 | 2021-08-09 | Walker | Alabama | 1127 | 8053 | 291 |
1599018 | 1599018 | 2021-08-09 | Washington | Alabama | 1129 | 1978 | 39 |
1599019 | 1599019 | 2021-08-09 | Wilcox | Alabama | 1131 | 1341 | 31 |
1599020 | 1599020 | 2021-08-09 | Winston | Alabama | 1133 | 3093 | 73 |
1599021 | 1599021 | 2021-08-09 | Aleutians East Borough | Alaska | 2013 | 386 | 3 |
1599022 | 1599022 | 2021-08-09 | Aleutians West Census Area | Alaska | 2016 | 785 | 0 |
1599023 | 1599023 | 2021-08-09 | Anchorage | Alaska | 2020 | 34057 | 190 |
1599024 | 1599024 | 2021-08-09 | Bethel Census Area | Alaska | 2050 | 4067 | 22 |
1599025 | 1599025 | 2021-08-09 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 212 | 0 |
1599026 | 1599026 | 2021-08-09 | Denali Borough | Alaska | 2068 | 128 | 0 |
1599027 | 1599027 | 2021-08-09 | Dillingham Census Area | Alaska | 2070 | 260 | 2 |
1599028 | 1599028 | 2021-08-09 | Fairbanks North Star Borough | Alaska | 2090 | 8332 | 45 |
1599029 | 1599029 | 2021-08-09 | Haines Borough | Alaska | 2100 | 28 | 0 |
1599030 | 1599030 | 2021-08-09 | Juneau City and Borough | Alaska | 2110 | 1750 | 3 |
1599031 | 1599031 | 2021-08-09 | Kenai Peninsula Borough | Alaska | 2122 | 5514 | 20 |
1599032 | 1599032 | 2021-08-09 | Ketchikan Gateway Borough | Alaska | 2130 | 774 | 1 |
1599033 | 1599033 | 2021-08-09 | Kodiak Island Borough | Alaska | 2150 | 1314 | 6 |
1599034 | 1599034 | 2021-08-09 | Kusilvak Census Area | Alaska | 2158 | 1503 | 4 |
1599035 | 1599035 | 2021-08-09 | Matanuska-Susitna Borough | Alaska | 2170 | 12425 | 61 |
1599036 | 1599036 | 2021-08-09 | Nome Census Area | Alaska | 2180 | 495 | 0 |
1599037 | 1599037 | 2021-08-09 | North Slope Borough | Alaska | 2185 | 1125 | 4 |
1599038 | 1599038 | 2021-08-09 | Northwest Arctic Borough | Alaska | 2188 | 689 | 2 |
1599039 | 1599039 | 2021-08-09 | Petersburg Borough | Alaska | 2195 | 183 | 1 |
1599040 | 1599040 | 2021-08-09 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 242 | 4 |
1599041 | 1599041 | 2021-08-09 | Sitka City and Borough | Alaska | 2220 | 839 | 1 |
1599042 | 1599042 | 2021-08-09 | Skagway Municipality | Alaska | 2230 | 34 | 0 |
1599043 | 1599043 | 2021-08-09 | Southeast Fairbanks Census Area | Alaska | 2240 | 800 | 5 |
1599044 | 1599044 | 2021-08-09 | Unknown | Alaska | 356 | 0 | |
1599045 | 1599045 | 2021-08-09 | Valdez-Cordova Census Area | Alaska | 2261 | 940 | 2 |
1599046 | 1599046 | 2021-08-09 | Wrangell City and Borough | Alaska | 2275 | 75 | 0 |
1599047 | 1599047 | 2021-08-09 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 86 | 2 |
1599048 | 1599048 | 2021-08-09 | Yukon-Koyukuk Census Area | Alaska | 2290 | 387 | 4 |
1599049 | 1599049 | 2021-08-09 | Apache | Arizona | 4001 | 11871 | 441 |
1599050 | 1599050 | 2021-08-09 | Cochise | Arizona | 4003 | 12530 | 299 |
1599051 | 1599051 | 2021-08-09 | Coconino | Arizona | 4005 | 18893 | 334 |
1599052 | 1599052 | 2021-08-09 | Gila | Arizona | 4007 | 7495 | 239 |
1599053 | 1599053 | 2021-08-09 | Graham | Arizona | 4009 | 5740 | 88 |
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);