ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,246 rows where date = "2021-02-08" 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 103
- 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 |
---|---|---|---|---|---|---|---|
1008068 | 1008068 | 2021-02-08 | Autauga | Alabama | 1001 | 5881 | 77 |
1008069 | 1008069 | 2021-02-08 | Baldwin | Alabama | 1003 | 18763 | 227 |
1008070 | 1008070 | 2021-02-08 | Barbour | Alabama | 1005 | 2008 | 45 |
1008071 | 1008071 | 2021-02-08 | Bibb | Alabama | 1007 | 2346 | 53 |
1008072 | 1008072 | 2021-02-08 | Blount | Alabama | 1009 | 5920 | 112 |
1008073 | 1008073 | 2021-02-08 | Bullock | Alabama | 1011 | 1132 | 29 |
1008074 | 1008074 | 2021-02-08 | Butler | Alabama | 1013 | 1868 | 62 |
1008075 | 1008075 | 2021-02-08 | Calhoun | Alabama | 1015 | 12426 | 246 |
1008076 | 1008076 | 2021-02-08 | Chambers | Alabama | 1017 | 3266 | 81 |
1008077 | 1008077 | 2021-02-08 | Cherokee | Alabama | 1019 | 1731 | 36 |
1008078 | 1008078 | 2021-02-08 | Chilton | Alabama | 1021 | 3622 | 82 |
1008079 | 1008079 | 2021-02-08 | Choctaw | Alabama | 1023 | 540 | 23 |
1008080 | 1008080 | 2021-02-08 | Clarke | Alabama | 1025 | 3336 | 40 |
1008081 | 1008081 | 2021-02-08 | Clay | Alabama | 1027 | 1362 | 52 |
1008082 | 1008082 | 2021-02-08 | Cleburne | Alabama | 1029 | 1323 | 31 |
1008083 | 1008083 | 2021-02-08 | Coffee | Alabama | 1031 | 5091 | 78 |
1008084 | 1008084 | 2021-02-08 | Colbert | Alabama | 1033 | 5880 | 111 |
1008085 | 1008085 | 2021-02-08 | Conecuh | Alabama | 1035 | 1032 | 23 |
1008086 | 1008086 | 2021-02-08 | Coosa | Alabama | 1037 | 751 | 22 |
1008087 | 1008087 | 2021-02-08 | Covington | Alabama | 1039 | 3752 | 92 |
1008088 | 1008088 | 2021-02-08 | Crenshaw | Alabama | 1041 | 1355 | 49 |
1008089 | 1008089 | 2021-02-08 | Cullman | Alabama | 1043 | 8740 | 163 |
1008090 | 1008090 | 2021-02-08 | Dale | Alabama | 1045 | 4417 | 102 |
1008091 | 1008091 | 2021-02-08 | Dallas | Alabama | 1047 | 3265 | 122 |
1008092 | 1008092 | 2021-02-08 | DeKalb | Alabama | 1049 | 8276 | 149 |
1008093 | 1008093 | 2021-02-08 | Elmore | Alabama | 1051 | 8927 | 152 |
1008094 | 1008094 | 2021-02-08 | Escambia | Alabama | 1053 | 3639 | 55 |
1008095 | 1008095 | 2021-02-08 | Etowah | Alabama | 1055 | 12819 | 273 |
1008096 | 1008096 | 2021-02-08 | Fayette | Alabama | 1057 | 1921 | 46 |
1008097 | 1008097 | 2021-02-08 | Franklin | Alabama | 1059 | 3914 | 68 |
1008098 | 1008098 | 2021-02-08 | Geneva | Alabama | 1061 | 2321 | 58 |
1008099 | 1008099 | 2021-02-08 | Greene | Alabama | 1063 | 827 | 29 |
1008100 | 1008100 | 2021-02-08 | Hale | Alabama | 1065 | 2002 | 56 |
1008101 | 1008101 | 2021-02-08 | Henry | Alabama | 1067 | 1754 | 36 |
1008102 | 1008102 | 2021-02-08 | Houston | Alabama | 1069 | 9740 | 230 |
1008103 | 1008103 | 2021-02-08 | Jackson | Alabama | 1071 | 6370 | 78 |
1008104 | 1008104 | 2021-02-08 | Jefferson | Alabama | 1073 | 68577 | 1236 |
1008105 | 1008105 | 2021-02-08 | Lamar | Alabama | 1075 | 1272 | 30 |
1008106 | 1008106 | 2021-02-08 | Lauderdale | Alabama | 1077 | 8380 | 179 |
1008107 | 1008107 | 2021-02-08 | Lawrence | Alabama | 1079 | 2729 | 78 |
1008108 | 1008108 | 2021-02-08 | Lee | Alabama | 1081 | 14361 | 132 |
1008109 | 1008109 | 2021-02-08 | Limestone | Alabama | 1083 | 8958 | 117 |
1008110 | 1008110 | 2021-02-08 | Lowndes | Alabama | 1085 | 1271 | 42 |
1008111 | 1008111 | 2021-02-08 | Macon | Alabama | 1087 | 1343 | 39 |
1008112 | 1008112 | 2021-02-08 | Madison | Alabama | 1089 | 30840 | 363 |
1008113 | 1008113 | 2021-02-08 | Marengo | Alabama | 1091 | 2223 | 39 |
1008114 | 1008114 | 2021-02-08 | Marion | Alabama | 1093 | 2664 | 81 |
1008115 | 1008115 | 2021-02-08 | Marshall | Alabama | 1095 | 10989 | 178 |
1008116 | 1008116 | 2021-02-08 | Mobile | Alabama | 1097 | 34219 | 654 |
1008117 | 1008117 | 2021-02-08 | Monroe | Alabama | 1099 | 1627 | 29 |
1008118 | 1008118 | 2021-02-08 | Montgomery | Alabama | 1101 | 21514 | 422 |
1008119 | 1008119 | 2021-02-08 | Morgan | Alabama | 1103 | 13272 | 220 |
1008120 | 1008120 | 2021-02-08 | Perry | Alabama | 1105 | 1045 | 24 |
1008121 | 1008121 | 2021-02-08 | Pickens | Alabama | 1107 | 2149 | 43 |
1008122 | 1008122 | 2021-02-08 | Pike | Alabama | 1109 | 2828 | 56 |
1008123 | 1008123 | 2021-02-08 | Randolph | Alabama | 1111 | 1561 | 37 |
1008124 | 1008124 | 2021-02-08 | Russell | Alabama | 1113 | 3865 | 24 |
1008125 | 1008125 | 2021-02-08 | Shelby | Alabama | 1117 | 20907 | 187 |
1008126 | 1008126 | 2021-02-08 | St. Clair | Alabama | 1115 | 8458 | 186 |
1008127 | 1008127 | 2021-02-08 | Sumter | Alabama | 1119 | 955 | 28 |
1008128 | 1008128 | 2021-02-08 | Talladega | Alabama | 1121 | 7160 | 133 |
1008129 | 1008129 | 2021-02-08 | Tallapoosa | Alabama | 1123 | 3411 | 124 |
1008130 | 1008130 | 2021-02-08 | Tuscaloosa | Alabama | 1125 | 23123 | 342 |
1008131 | 1008131 | 2021-02-08 | Walker | Alabama | 1127 | 6259 | 209 |
1008132 | 1008132 | 2021-02-08 | Washington | Alabama | 1129 | 1501 | 29 |
1008133 | 1008133 | 2021-02-08 | Wilcox | Alabama | 1131 | 1171 | 22 |
1008134 | 1008134 | 2021-02-08 | Winston | Alabama | 1133 | 2399 | 52 |
1008135 | 1008135 | 2021-02-08 | Aleutians East Borough | Alaska | 2013 | 323 | 0 |
1008136 | 1008136 | 2021-02-08 | Aleutians West Census Area | Alaska | 2016 | 374 | 0 |
1008137 | 1008137 | 2021-02-08 | Anchorage | Alaska | 2020 | 25683 | 149 |
1008138 | 1008138 | 2021-02-08 | Bethel Census Area | Alaska | 2050 | 3445 | 17 |
1008139 | 1008139 | 2021-02-08 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 170 | 0 |
1008140 | 1008140 | 2021-02-08 | Denali Borough | Alaska | 2068 | 67 | 0 |
1008141 | 1008141 | 2021-02-08 | Dillingham Census Area | Alaska | 2070 | 187 | 1 |
1008142 | 1008142 | 2021-02-08 | Fairbanks North Star Borough | Alaska | 2090 | 5924 | 26 |
1008143 | 1008143 | 2021-02-08 | Haines Borough | Alaska | 2100 | 23 | 0 |
1008144 | 1008144 | 2021-02-08 | Juneau City and Borough | Alaska | 2110 | 1175 | 3 |
1008145 | 1008145 | 2021-02-08 | Kenai Peninsula Borough | Alaska | 2122 | 3904 | 19 |
1008146 | 1008146 | 2021-02-08 | Ketchikan Gateway Borough | Alaska | 2130 | 295 | 2 |
1008147 | 1008147 | 2021-02-08 | Kodiak Island Borough | Alaska | 2150 | 1040 | 5 |
1008148 | 1008148 | 2021-02-08 | Kusilvak Census Area | Alaska | 2158 | 1156 | 3 |
1008149 | 1008149 | 2021-02-08 | Matanuska-Susitna Borough | Alaska | 2170 | 7766 | 29 |
1008150 | 1008150 | 2021-02-08 | Nome Census Area | Alaska | 2180 | 318 | 0 |
1008151 | 1008151 | 2021-02-08 | North Slope Borough | Alaska | 2185 | 982 | 3 |
1008152 | 1008152 | 2021-02-08 | Northwest Arctic Borough | Alaska | 2188 | 573 | 1 |
1008153 | 1008153 | 2021-02-08 | Petersburg Borough | Alaska | 2195 | 45 | 0 |
1008154 | 1008154 | 2021-02-08 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 70 | 1 |
1008155 | 1008155 | 2021-02-08 | Sitka City and Borough | Alaska | 2220 | 299 | 0 |
1008156 | 1008156 | 2021-02-08 | Skagway Municipality | Alaska | 2230 | 15 | 0 |
1008157 | 1008157 | 2021-02-08 | Southeast Fairbanks Census Area | Alaska | 2240 | 441 | 3 |
1008158 | 1008158 | 2021-02-08 | Unknown | Alaska | 249 | 0 | |
1008159 | 1008159 | 2021-02-08 | Valdez-Cordova Census Area | Alaska | 2261 | 451 | 2 |
1008160 | 1008160 | 2021-02-08 | Wrangell City and Borough | Alaska | 2275 | 25 | 0 |
1008161 | 1008161 | 2021-02-08 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 63 | 1 |
1008162 | 1008162 | 2021-02-08 | Yukon-Koyukuk Census Area | Alaska | 2290 | 311 | 4 |
1008163 | 1008163 | 2021-02-08 | Apache | Arizona | 4001 | 9858 | 326 |
1008164 | 1008164 | 2021-02-08 | Cochise | Arizona | 4003 | 10611 | 237 |
1008165 | 1008165 | 2021-02-08 | Coconino | Arizona | 4005 | 15735 | 288 |
1008166 | 1008166 | 2021-02-08 | Gila | Arizona | 4007 | 6175 | 200 |
1008167 | 1008167 | 2021-02-08 | Graham | Arizona | 4009 | 5173 | 68 |
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);