ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,092 rows where date = "2020-06-08" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 235
- Georgia 160
- Virginia 130
- Kentucky 119
- Missouri 110
- Illinois 102
- Iowa 100
- North Carolina 100
- Tennessee 96
- Indiana 92
- Kansas 89
- Ohio 88
- Minnesota 86
- Michigan 81
- Mississippi 81
- Puerto Rico 79
- Arkansas 75
- Nebraska 74
- Oklahoma 74
- Wisconsin 72
- Florida 68
- Alabama 67
- Pennsylvania 67
- Louisiana 65
- Colorado 60
- New York 58
- California 57
- South Dakota 57
- West Virginia 53
- North Dakota 46
- …
fips >30
county >30
- Washington 30
- Jefferson 26
- Unknown 26
- Franklin 25
- Jackson 23
- Lincoln 23
- Madison 20
- Clay 18
- Montgomery 18
- Union 18
- Marion 17
- Monroe 17
- Grant 14
- Greene 14
- Warren 14
- Wayne 14
- Carroll 13
- Douglas 12
- Johnson 12
- Lake 12
- Lee 12
- Polk 12
- Adams 11
- Clark 11
- Crawford 11
- Fayette 11
- Lawrence 11
- Marshall 11
- Morgan 11
- Calhoun 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
218423 | 218423 | 2020-06-08 | Autauga | Alabama | 1001 | 273 | 5 |
218424 | 218424 | 2020-06-08 | Baldwin | Alabama | 1003 | 335 | 9 |
218425 | 218425 | 2020-06-08 | Barbour | Alabama | 1005 | 198 | 1 |
218426 | 218426 | 2020-06-08 | Bibb | Alabama | 1007 | 82 | 1 |
218427 | 218427 | 2020-06-08 | Blount | Alabama | 1009 | 75 | 1 |
218428 | 218428 | 2020-06-08 | Bullock | Alabama | 1011 | 240 | 9 |
218429 | 218429 | 2020-06-08 | Butler | Alabama | 1013 | 457 | 24 |
218430 | 218430 | 2020-06-08 | Calhoun | Alabama | 1015 | 186 | 3 |
218431 | 218431 | 2020-06-08 | Chambers | Alabama | 1017 | 395 | 26 |
218432 | 218432 | 2020-06-08 | Cherokee | Alabama | 1019 | 43 | 4 |
218433 | 218433 | 2020-06-08 | Chilton | Alabama | 1021 | 116 | 2 |
218434 | 218434 | 2020-06-08 | Choctaw | Alabama | 1023 | 157 | 10 |
218435 | 218435 | 2020-06-08 | Clarke | Alabama | 1025 | 159 | 3 |
218436 | 218436 | 2020-06-08 | Clay | Alabama | 1027 | 29 | 2 |
218437 | 218437 | 2020-06-08 | Cleburne | Alabama | 1029 | 19 | 1 |
218438 | 218438 | 2020-06-08 | Coffee | Alabama | 1031 | 251 | 1 |
218439 | 218439 | 2020-06-08 | Colbert | Alabama | 1033 | 217 | 4 |
218440 | 218440 | 2020-06-08 | Conecuh | Alabama | 1035 | 54 | 1 |
218441 | 218441 | 2020-06-08 | Coosa | Alabama | 1037 | 40 | 1 |
218442 | 218442 | 2020-06-08 | Covington | Alabama | 1039 | 93 | 1 |
218443 | 218443 | 2020-06-08 | Crenshaw | Alabama | 1041 | 91 | 3 |
218444 | 218444 | 2020-06-08 | Cullman | Alabama | 1043 | 204 | 1 |
218445 | 218445 | 2020-06-08 | Dale | Alabama | 1045 | 137 | 0 |
218446 | 218446 | 2020-06-08 | Dallas | Alabama | 1047 | 341 | 4 |
218447 | 218447 | 2020-06-08 | DeKalb | Alabama | 1049 | 276 | 3 |
218448 | 218448 | 2020-06-08 | Elmore | Alabama | 1051 | 438 | 10 |
218449 | 218449 | 2020-06-08 | Escambia | Alabama | 1053 | 88 | 3 |
218450 | 218450 | 2020-06-08 | Etowah | Alabama | 1055 | 280 | 12 |
218451 | 218451 | 2020-06-08 | Fayette | Alabama | 1057 | 21 | 0 |
218452 | 218452 | 2020-06-08 | Franklin | Alabama | 1059 | 628 | 10 |
218453 | 218453 | 2020-06-08 | Geneva | Alabama | 1061 | 46 | 0 |
218454 | 218454 | 2020-06-08 | Greene | Alabama | 1063 | 99 | 5 |
218455 | 218455 | 2020-06-08 | Hale | Alabama | 1065 | 211 | 11 |
218456 | 218456 | 2020-06-08 | Henry | Alabama | 1067 | 89 | 2 |
218457 | 218457 | 2020-06-08 | Houston | Alabama | 1069 | 256 | 5 |
218458 | 218458 | 2020-06-08 | Jackson | Alabama | 1071 | 97 | 3 |
218459 | 218459 | 2020-06-08 | Jefferson | Alabama | 1073 | 2109 | 110 |
218460 | 218460 | 2020-06-08 | Lamar | Alabama | 1075 | 30 | 0 |
218461 | 218461 | 2020-06-08 | Lauderdale | Alabama | 1077 | 189 | 3 |
218462 | 218462 | 2020-06-08 | Lawrence | Alabama | 1079 | 56 | 0 |
218463 | 218463 | 2020-06-08 | Lee | Alabama | 1081 | 610 | 34 |
218464 | 218464 | 2020-06-08 | Limestone | Alabama | 1083 | 137 | 0 |
218465 | 218465 | 2020-06-08 | Lowndes | Alabama | 1085 | 294 | 14 |
218466 | 218466 | 2020-06-08 | Macon | Alabama | 1087 | 101 | 5 |
218467 | 218467 | 2020-06-08 | Madison | Alabama | 1089 | 407 | 5 |
218468 | 218468 | 2020-06-08 | Marengo | Alabama | 1091 | 188 | 6 |
218469 | 218469 | 2020-06-08 | Marion | Alabama | 1093 | 130 | 11 |
218470 | 218470 | 2020-06-08 | Marshall | Alabama | 1095 | 748 | 9 |
218471 | 218471 | 2020-06-08 | Mobile | Alabama | 1097 | 2478 | 124 |
218472 | 218472 | 2020-06-08 | Monroe | Alabama | 1099 | 62 | 2 |
218473 | 218473 | 2020-06-08 | Montgomery | Alabama | 1101 | 2158 | 55 |
218474 | 218474 | 2020-06-08 | Morgan | Alabama | 1103 | 401 | 1 |
218475 | 218475 | 2020-06-08 | Perry | Alabama | 1105 | 50 | 0 |
218476 | 218476 | 2020-06-08 | Pickens | Alabama | 1107 | 125 | 6 |
218477 | 218477 | 2020-06-08 | Pike | Alabama | 1109 | 252 | 1 |
218478 | 218478 | 2020-06-08 | Randolph | Alabama | 1111 | 135 | 8 |
218479 | 218479 | 2020-06-08 | Russell | Alabama | 1113 | 214 | 0 |
218480 | 218480 | 2020-06-08 | Shelby | Alabama | 1117 | 573 | 19 |
218481 | 218481 | 2020-06-08 | St. Clair | Alabama | 1115 | 149 | 2 |
218482 | 218482 | 2020-06-08 | Sumter | Alabama | 1119 | 248 | 9 |
218483 | 218483 | 2020-06-08 | Talladega | Alabama | 1121 | 139 | 5 |
218484 | 218484 | 2020-06-08 | Tallapoosa | Alabama | 1123 | 451 | 67 |
218485 | 218485 | 2020-06-08 | Tuscaloosa | Alabama | 1125 | 948 | 23 |
218486 | 218486 | 2020-06-08 | Walker | Alabama | 1127 | 470 | 5 |
218487 | 218487 | 2020-06-08 | Washington | Alabama | 1129 | 81 | 6 |
218488 | 218488 | 2020-06-08 | Wilcox | Alabama | 1131 | 175 | 7 |
218489 | 218489 | 2020-06-08 | Winston | Alabama | 1133 | 96 | 0 |
218490 | 218490 | 2020-06-08 | Aleutians West Census Area | Alaska | 2016 | 3 | 0 |
218491 | 218491 | 2020-06-08 | Anchorage | Alaska | 2020 | 300 | 4 |
218492 | 218492 | 2020-06-08 | Bethel Census Area | Alaska | 2050 | 3 | 0 |
218493 | 218493 | 2020-06-08 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 3 | 0 |
218494 | 218494 | 2020-06-08 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
218495 | 218495 | 2020-06-08 | Fairbanks North Star Borough | Alaska | 2090 | 86 | 2 |
218496 | 218496 | 2020-06-08 | Juneau City and Borough | Alaska | 2110 | 35 | 0 |
218497 | 218497 | 2020-06-08 | Kenai Peninsula Borough | Alaska | 2122 | 88 | 1 |
218498 | 218498 | 2020-06-08 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
218499 | 218499 | 2020-06-08 | Kodiak Island Borough | Alaska | 2150 | 2 | 0 |
218500 | 218500 | 2020-06-08 | Matanuska-Susitna Borough | Alaska | 2170 | 37 | 1 |
218501 | 218501 | 2020-06-08 | Nome Census Area | Alaska | 2180 | 3 | 0 |
218502 | 218502 | 2020-06-08 | North Slope Borough | Alaska | 2185 | 1 | 0 |
218503 | 218503 | 2020-06-08 | Northwest Arctic Borough | Alaska | 2188 | 2 | 0 |
218504 | 218504 | 2020-06-08 | Petersburg Borough | Alaska | 2195 | 3 | 0 |
218505 | 218505 | 2020-06-08 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 2 | 0 |
218506 | 218506 | 2020-06-08 | Sitka City and Borough | Alaska | 2220 | 3 | 0 |
218507 | 218507 | 2020-06-08 | Southeast Fairbanks Census Area | Alaska | 2240 | 4 | 0 |
218508 | 218508 | 2020-06-08 | Valdez-Cordova Census Area | Alaska | 2261 | 13 | 0 |
218509 | 218509 | 2020-06-08 | Wrangell City and Borough | Alaska | 2275 | 1 | 0 |
218510 | 218510 | 2020-06-08 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1 | 0 |
218511 | 218511 | 2020-06-08 | Apache | Arizona | 4001 | 1732 | 49 |
218512 | 218512 | 2020-06-08 | Cochise | Arizona | 4003 | 149 | 5 |
218513 | 218513 | 2020-06-08 | Coconino | Arizona | 4005 | 1290 | 85 |
218514 | 218514 | 2020-06-08 | Gila | Arizona | 4007 | 46 | 3 |
218515 | 218515 | 2020-06-08 | Graham | Arizona | 4009 | 41 | 2 |
218516 | 218516 | 2020-06-08 | Greenlee | Arizona | 4011 | 10 | 1 |
218517 | 218517 | 2020-06-08 | La Paz | Arizona | 4012 | 183 | 2 |
218518 | 218518 | 2020-06-08 | Maricopa | Arizona | 4013 | 14003 | 491 |
218519 | 218519 | 2020-06-08 | Mohave | Arizona | 4015 | 512 | 58 |
218520 | 218520 | 2020-06-08 | Navajo | Arizona | 4017 | 2229 | 72 |
218521 | 218521 | 2020-06-08 | Pima | Arizona | 4019 | 3154 | 205 |
218522 | 218522 | 2020-06-08 | Pinal | Arizona | 4021 | 1127 | 41 |
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);