ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,169 rows where date = "2020-07-07" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 246
- Georgia 160
- Virginia 132
- Kentucky 120
- Missouri 116
- Illinois 103
- Iowa 100
- North Carolina 100
- Kansas 98
- Tennessee 96
- Indiana 92
- Ohio 88
- Minnesota 87
- Michigan 84
- Mississippi 82
- Nebraska 79
- Puerto Rico 79
- Arkansas 76
- Oklahoma 76
- Wisconsin 73
- Florida 68
- Alabama 67
- Pennsylvania 67
- Louisiana 65
- Colorado 61
- South Dakota 61
- New York 58
- California 57
- West Virginia 54
- North Dakota 51
- …
fips >30
county >30
- Washington 31
- Jefferson 26
- Franklin 25
- Unknown 25
- Jackson 24
- Lincoln 23
- Madison 20
- Clay 18
- Montgomery 18
- Union 18
- Marion 17
- Monroe 17
- Wayne 15
- Grant 14
- Greene 14
- Warren 14
- Carroll 13
- Douglas 12
- Johnson 12
- Lake 12
- Lee 12
- Marshall 12
- Polk 12
- Adams 11
- Calhoun 11
- Clark 11
- Crawford 11
- Fayette 11
- Lawrence 11
- Morgan 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
309197 | 309197 | 2020-07-07 | Autauga | Alabama | 1001 | 644 | 13 |
309198 | 309198 | 2020-07-07 | Baldwin | Alabama | 1003 | 997 | 10 |
309199 | 309199 | 2020-07-07 | Barbour | Alabama | 1005 | 360 | 2 |
309200 | 309200 | 2020-07-07 | Bibb | Alabama | 1007 | 199 | 1 |
309201 | 309201 | 2020-07-07 | Blount | Alabama | 1009 | 255 | 1 |
309202 | 309202 | 2020-07-07 | Bullock | Alabama | 1011 | 373 | 11 |
309203 | 309203 | 2020-07-07 | Butler | Alabama | 1013 | 634 | 28 |
309204 | 309204 | 2020-07-07 | Calhoun | Alabama | 1015 | 395 | 5 |
309205 | 309205 | 2020-07-07 | Chambers | Alabama | 1017 | 656 | 27 |
309206 | 309206 | 2020-07-07 | Cherokee | Alabama | 1019 | 106 | 7 |
309207 | 309207 | 2020-07-07 | Chilton | Alabama | 1021 | 270 | 3 |
309208 | 309208 | 2020-07-07 | Choctaw | Alabama | 1023 | 198 | 12 |
309209 | 309209 | 2020-07-07 | Clarke | Alabama | 1025 | 284 | 6 |
309210 | 309210 | 2020-07-07 | Clay | Alabama | 1027 | 69 | 2 |
309211 | 309211 | 2020-07-07 | Cleburne | Alabama | 1029 | 39 | 1 |
309212 | 309212 | 2020-07-07 | Coffee | Alabama | 1031 | 391 | 3 |
309213 | 309213 | 2020-07-07 | Colbert | Alabama | 1033 | 435 | 6 |
309214 | 309214 | 2020-07-07 | Conecuh | Alabama | 1035 | 219 | 7 |
309215 | 309215 | 2020-07-07 | Coosa | Alabama | 1037 | 59 | 1 |
309216 | 309216 | 2020-07-07 | Covington | Alabama | 1039 | 380 | 8 |
309217 | 309217 | 2020-07-07 | Crenshaw | Alabama | 1041 | 129 | 3 |
309218 | 309218 | 2020-07-07 | Cullman | Alabama | 1043 | 478 | 5 |
309219 | 309219 | 2020-07-07 | Dale | Alabama | 1045 | 305 | 0 |
309220 | 309220 | 2020-07-07 | Dallas | Alabama | 1047 | 918 | 9 |
309221 | 309221 | 2020-07-07 | DeKalb | Alabama | 1049 | 770 | 5 |
309222 | 309222 | 2020-07-07 | Elmore | Alabama | 1051 | 975 | 15 |
309223 | 309223 | 2020-07-07 | Escambia | Alabama | 1053 | 411 | 8 |
309224 | 309224 | 2020-07-07 | Etowah | Alabama | 1055 | 801 | 13 |
309225 | 309225 | 2020-07-07 | Fayette | Alabama | 1057 | 75 | 1 |
309226 | 309226 | 2020-07-07 | Franklin | Alabama | 1059 | 907 | 16 |
309227 | 309227 | 2020-07-07 | Geneva | Alabama | 1061 | 84 | 0 |
309228 | 309228 | 2020-07-07 | Greene | Alabama | 1063 | 186 | 8 |
309229 | 309229 | 2020-07-07 | Hale | Alabama | 1065 | 320 | 21 |
309230 | 309230 | 2020-07-07 | Henry | Alabama | 1067 | 137 | 4 |
309231 | 309231 | 2020-07-07 | Houston | Alabama | 1069 | 525 | 8 |
309232 | 309232 | 2020-07-07 | Jackson | Alabama | 1071 | 306 | 3 |
309233 | 309233 | 2020-07-07 | Jefferson | Alabama | 1073 | 5538 | 157 |
309234 | 309234 | 2020-07-07 | Lamar | Alabama | 1075 | 81 | 1 |
309235 | 309235 | 2020-07-07 | Lauderdale | Alabama | 1077 | 503 | 6 |
309236 | 309236 | 2020-07-07 | Lawrence | Alabama | 1079 | 112 | 0 |
309237 | 309237 | 2020-07-07 | Lee | Alabama | 1081 | 1459 | 38 |
309238 | 309238 | 2020-07-07 | Limestone | Alabama | 1083 | 523 | 1 |
309239 | 309239 | 2020-07-07 | Lowndes | Alabama | 1085 | 482 | 23 |
309240 | 309240 | 2020-07-07 | Macon | Alabama | 1087 | 203 | 9 |
309241 | 309241 | 2020-07-07 | Madison | Alabama | 1089 | 1579 | 9 |
309242 | 309242 | 2020-07-07 | Marengo | Alabama | 1091 | 319 | 11 |
309243 | 309243 | 2020-07-07 | Marion | Alabama | 1093 | 240 | 13 |
309244 | 309244 | 2020-07-07 | Marshall | Alabama | 1095 | 1781 | 11 |
309245 | 309245 | 2020-07-07 | Mobile | Alabama | 1097 | 4243 | 140 |
309246 | 309246 | 2020-07-07 | Monroe | Alabama | 1099 | 243 | 3 |
309247 | 309247 | 2020-07-07 | Montgomery | Alabama | 1101 | 4293 | 107 |
309248 | 309248 | 2020-07-07 | Morgan | Alabama | 1103 | 1142 | 5 |
309249 | 309249 | 2020-07-07 | Perry | Alabama | 1105 | 179 | 1 |
309250 | 309250 | 2020-07-07 | Pickens | Alabama | 1107 | 241 | 6 |
309251 | 309251 | 2020-07-07 | Pike | Alabama | 1109 | 459 | 5 |
309252 | 309252 | 2020-07-07 | Randolph | Alabama | 1111 | 218 | 9 |
309253 | 309253 | 2020-07-07 | Russell | Alabama | 1113 | 574 | 0 |
309254 | 309254 | 2020-07-07 | Shelby | Alabama | 1117 | 1376 | 24 |
309255 | 309255 | 2020-07-07 | St. Clair | Alabama | 1115 | 426 | 2 |
309256 | 309256 | 2020-07-07 | Sumter | Alabama | 1119 | 286 | 12 |
309257 | 309257 | 2020-07-07 | Talladega | Alabama | 1121 | 331 | 8 |
309258 | 309258 | 2020-07-07 | Tallapoosa | Alabama | 1123 | 612 | 70 |
309259 | 309259 | 2020-07-07 | Tuscaloosa | Alabama | 1125 | 2368 | 46 |
309260 | 309260 | 2020-07-07 | Walker | Alabama | 1127 | 998 | 25 |
309261 | 309261 | 2020-07-07 | Washington | Alabama | 1129 | 121 | 7 |
309262 | 309262 | 2020-07-07 | Wilcox | Alabama | 1131 | 296 | 8 |
309263 | 309263 | 2020-07-07 | Winston | Alabama | 1133 | 269 | 3 |
309264 | 309264 | 2020-07-07 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
309265 | 309265 | 2020-07-07 | Aleutians West Census Area | Alaska | 2016 | 5 | 0 |
309266 | 309266 | 2020-07-07 | Anchorage | Alaska | 2020 | 633 | 8 |
309267 | 309267 | 2020-07-07 | Bethel Census Area | Alaska | 2050 | 13 | 0 |
309268 | 309268 | 2020-07-07 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 52 | 0 |
309269 | 309269 | 2020-07-07 | Denali Borough | Alaska | 2068 | 1 | 0 |
309270 | 309270 | 2020-07-07 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
309271 | 309271 | 2020-07-07 | Fairbanks North Star Borough | Alaska | 2090 | 189 | 2 |
309272 | 309272 | 2020-07-07 | Haines Borough | Alaska | 2100 | 6 | 0 |
309273 | 309273 | 2020-07-07 | Juneau City and Borough | Alaska | 2110 | 51 | 2 |
309274 | 309274 | 2020-07-07 | Kenai Peninsula Borough | Alaska | 2122 | 185 | 1 |
309275 | 309275 | 2020-07-07 | Ketchikan Gateway Borough | Alaska | 2130 | 31 | 0 |
309276 | 309276 | 2020-07-07 | Kodiak Island Borough | Alaska | 2150 | 9 | 0 |
309277 | 309277 | 2020-07-07 | Kusilvak Census Area | Alaska | 2158 | 1 | 0 |
309278 | 309278 | 2020-07-07 | Matanuska-Susitna Borough | Alaska | 2170 | 121 | 2 |
309279 | 309279 | 2020-07-07 | Nome Census Area | Alaska | 2180 | 11 | 0 |
309280 | 309280 | 2020-07-07 | North Slope Borough | Alaska | 2185 | 4 | 0 |
309281 | 309281 | 2020-07-07 | Northwest Arctic Borough | Alaska | 2188 | 5 | 0 |
309282 | 309282 | 2020-07-07 | Petersburg Borough | Alaska | 2195 | 7 | 0 |
309283 | 309283 | 2020-07-07 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 3 | 0 |
309284 | 309284 | 2020-07-07 | Sitka City and Borough | Alaska | 2220 | 18 | 0 |
309285 | 309285 | 2020-07-07 | Southeast Fairbanks Census Area | Alaska | 2240 | 16 | 0 |
309286 | 309286 | 2020-07-07 | Valdez-Cordova Census Area | Alaska | 2261 | 26 | 0 |
309287 | 309287 | 2020-07-07 | Wrangell City and Borough | Alaska | 2275 | 8 | 0 |
309288 | 309288 | 2020-07-07 | Yukon-Koyukuk Census Area | Alaska | 2290 | 5 | 0 |
309289 | 309289 | 2020-07-07 | Apache | Arizona | 4001 | 2471 | 99 |
309290 | 309290 | 2020-07-07 | Cochise | Arizona | 4003 | 870 | 17 |
309291 | 309291 | 2020-07-07 | Coconino | Arizona | 4005 | 2237 | 97 |
309292 | 309292 | 2020-07-07 | Gila | Arizona | 4007 | 361 | 6 |
309293 | 309293 | 2020-07-07 | Graham | Arizona | 4009 | 172 | 3 |
309294 | 309294 | 2020-07-07 | Greenlee | Arizona | 4011 | 26 | 1 |
309295 | 309295 | 2020-07-07 | La Paz | Arizona | 4012 | 374 | 7 |
309296 | 309296 | 2020-07-07 | Maricopa | Arizona | 4013 | 67543 | 933 |
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);