ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 21,426
- Georgia 16,249
- Virginia 12,817
- Kentucky 11,092
- Missouri 10,160
- North Carolina 9,908
- Illinois 9,649
- Tennessee 9,562
- Indiana 9,418
- Iowa 9,173
- Ohio 8,913
- Mississippi 8,407
- Michigan 8,166
- Minnesota 8,152
- Kansas 7,917
- Arkansas 7,428
- Florida 7,190
- Oklahoma 7,012
- Wisconsin 6,994
- Pennsylvania 6,948
- Alabama 6,819
- Louisiana 6,768
- California 6,328
- New York 6,310
- Nebraska 6,208
- Colorado 6,176
- West Virginia 4,914
- South Carolina 4,854
- South Dakota 4,812
- Puerto Rico 4,756
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
296538 | 296538 | 2020-07-03 | Autauga | Alabama | 1001 | 568 | 13 |
296539 | 296539 | 2020-07-03 | Baldwin | Alabama | 1003 | 845 | 10 |
296540 | 296540 | 2020-07-03 | Barbour | Alabama | 1005 | 348 | 2 |
296541 | 296541 | 2020-07-03 | Bibb | Alabama | 1007 | 189 | 1 |
296542 | 296542 | 2020-07-03 | Blount | Alabama | 1009 | 230 | 1 |
296543 | 296543 | 2020-07-03 | Bullock | Alabama | 1011 | 372 | 10 |
296544 | 296544 | 2020-07-03 | Butler | Alabama | 1013 | 625 | 28 |
296545 | 296545 | 2020-07-03 | Calhoun | Alabama | 1015 | 330 | 5 |
296546 | 296546 | 2020-07-03 | Chambers | Alabama | 1017 | 625 | 27 |
296547 | 296547 | 2020-07-03 | Cherokee | Alabama | 1019 | 88 | 7 |
296548 | 296548 | 2020-07-03 | Chilton | Alabama | 1021 | 235 | 3 |
296549 | 296549 | 2020-07-03 | Choctaw | Alabama | 1023 | 196 | 12 |
296550 | 296550 | 2020-07-03 | Clarke | Alabama | 1025 | 273 | 6 |
296551 | 296551 | 2020-07-03 | Clay | Alabama | 1027 | 62 | 2 |
296552 | 296552 | 2020-07-03 | Cleburne | Alabama | 1029 | 36 | 1 |
296553 | 296553 | 2020-07-03 | Coffee | Alabama | 1031 | 375 | 2 |
296554 | 296554 | 2020-07-03 | Colbert | Alabama | 1033 | 392 | 6 |
296555 | 296555 | 2020-07-03 | Conecuh | Alabama | 1035 | 199 | 7 |
296556 | 296556 | 2020-07-03 | Coosa | Alabama | 1037 | 58 | 1 |
296557 | 296557 | 2020-07-03 | Covington | Alabama | 1039 | 351 | 8 |
296558 | 296558 | 2020-07-03 | Crenshaw | Alabama | 1041 | 129 | 3 |
296559 | 296559 | 2020-07-03 | Cullman | Alabama | 1043 | 443 | 4 |
296560 | 296560 | 2020-07-03 | Dale | Alabama | 1045 | 271 | 0 |
296561 | 296561 | 2020-07-03 | Dallas | Alabama | 1047 | 875 | 9 |
296562 | 296562 | 2020-07-03 | DeKalb | Alabama | 1049 | 703 | 5 |
296563 | 296563 | 2020-07-03 | Elmore | Alabama | 1051 | 876 | 14 |
296564 | 296564 | 2020-07-03 | Escambia | Alabama | 1053 | 332 | 6 |
296565 | 296565 | 2020-07-03 | Etowah | Alabama | 1055 | 717 | 13 |
296566 | 296566 | 2020-07-03 | Fayette | Alabama | 1057 | 70 | 1 |
296567 | 296567 | 2020-07-03 | Franklin | Alabama | 1059 | 883 | 14 |
296568 | 296568 | 2020-07-03 | Geneva | Alabama | 1061 | 78 | 0 |
296569 | 296569 | 2020-07-03 | Greene | Alabama | 1063 | 183 | 8 |
296570 | 296570 | 2020-07-03 | Hale | Alabama | 1065 | 311 | 21 |
296571 | 296571 | 2020-07-03 | Henry | Alabama | 1067 | 132 | 4 |
296572 | 296572 | 2020-07-03 | Houston | Alabama | 1069 | 476 | 6 |
296573 | 296573 | 2020-07-03 | Jackson | Alabama | 1071 | 267 | 3 |
296574 | 296574 | 2020-07-03 | Jefferson | Alabama | 1073 | 4853 | 154 |
296575 | 296575 | 2020-07-03 | Lamar | Alabama | 1075 | 76 | 1 |
296576 | 296576 | 2020-07-03 | Lauderdale | Alabama | 1077 | 475 | 6 |
296577 | 296577 | 2020-07-03 | Lawrence | Alabama | 1079 | 108 | 0 |
296578 | 296578 | 2020-07-03 | Lee | Alabama | 1081 | 1326 | 38 |
296579 | 296579 | 2020-07-03 | Limestone | Alabama | 1083 | 471 | 0 |
296580 | 296580 | 2020-07-03 | Lowndes | Alabama | 1085 | 465 | 21 |
296581 | 296581 | 2020-07-03 | Macon | Alabama | 1087 | 185 | 9 |
296582 | 296582 | 2020-07-03 | Madison | Alabama | 1089 | 1296 | 8 |
296583 | 296583 | 2020-07-03 | Marengo | Alabama | 1091 | 302 | 11 |
296584 | 296584 | 2020-07-03 | Marion | Alabama | 1093 | 218 | 13 |
296585 | 296585 | 2020-07-03 | Marshall | Alabama | 1095 | 1688 | 10 |
296586 | 296586 | 2020-07-03 | Mobile | Alabama | 1097 | 3928 | 138 |
296587 | 296587 | 2020-07-03 | Monroe | Alabama | 1099 | 232 | 2 |
296588 | 296588 | 2020-07-03 | Montgomery | Alabama | 1101 | 3994 | 105 |
296589 | 296589 | 2020-07-03 | Morgan | Alabama | 1103 | 1060 | 5 |
296590 | 296590 | 2020-07-03 | Perry | Alabama | 1105 | 162 | 1 |
296591 | 296591 | 2020-07-03 | Pickens | Alabama | 1107 | 223 | 6 |
296592 | 296592 | 2020-07-03 | Pike | Alabama | 1109 | 424 | 5 |
296593 | 296593 | 2020-07-03 | Randolph | Alabama | 1111 | 203 | 9 |
296594 | 296594 | 2020-07-03 | Russell | Alabama | 1113 | 524 | 0 |
296595 | 296595 | 2020-07-03 | Shelby | Alabama | 1117 | 1195 | 23 |
296596 | 296596 | 2020-07-03 | St. Clair | Alabama | 1115 | 357 | 2 |
296597 | 296597 | 2020-07-03 | Sumter | Alabama | 1119 | 285 | 12 |
296598 | 296598 | 2020-07-03 | Talladega | Alabama | 1121 | 308 | 8 |
296599 | 296599 | 2020-07-03 | Tallapoosa | Alabama | 1123 | 590 | 70 |
296600 | 296600 | 2020-07-03 | Tuscaloosa | Alabama | 1125 | 2209 | 44 |
296601 | 296601 | 2020-07-03 | Walker | Alabama | 1127 | 918 | 24 |
296602 | 296602 | 2020-07-03 | Washington | Alabama | 1129 | 107 | 7 |
296603 | 296603 | 2020-07-03 | Wilcox | Alabama | 1131 | 291 | 8 |
296604 | 296604 | 2020-07-03 | Winston | Alabama | 1133 | 249 | 3 |
296605 | 296605 | 2020-07-03 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
296606 | 296606 | 2020-07-03 | Aleutians West Census Area | Alaska | 2016 | 5 | 0 |
296607 | 296607 | 2020-07-03 | Anchorage | Alaska | 2020 | 541 | 7 |
296608 | 296608 | 2020-07-03 | Bethel Census Area | Alaska | 2050 | 12 | 0 |
296609 | 296609 | 2020-07-03 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 44 | 0 |
296610 | 296610 | 2020-07-03 | Denali Borough | Alaska | 2068 | 1 | 0 |
296611 | 296611 | 2020-07-03 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
296612 | 296612 | 2020-07-03 | Fairbanks North Star Borough | Alaska | 2090 | 174 | 2 |
296613 | 296613 | 2020-07-03 | Haines Borough | Alaska | 2100 | 6 | 0 |
296614 | 296614 | 2020-07-03 | Juneau City and Borough | Alaska | 2110 | 49 | 2 |
296615 | 296615 | 2020-07-03 | Kenai Peninsula Borough | Alaska | 2122 | 177 | 1 |
296616 | 296616 | 2020-07-03 | Ketchikan Gateway Borough | Alaska | 2130 | 30 | 0 |
296617 | 296617 | 2020-07-03 | Kodiak Island Borough | Alaska | 2150 | 9 | 0 |
296618 | 296618 | 2020-07-03 | Kusilvak Census Area | Alaska | 2158 | 1 | 0 |
296619 | 296619 | 2020-07-03 | Matanuska-Susitna Borough | Alaska | 2170 | 110 | 1 |
296620 | 296620 | 2020-07-03 | Nome Census Area | Alaska | 2180 | 11 | 0 |
296621 | 296621 | 2020-07-03 | North Slope Borough | Alaska | 2185 | 4 | 0 |
296622 | 296622 | 2020-07-03 | Northwest Arctic Borough | Alaska | 2188 | 5 | 0 |
296623 | 296623 | 2020-07-03 | Petersburg Borough | Alaska | 2195 | 5 | 0 |
296624 | 296624 | 2020-07-03 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 3 | 0 |
296625 | 296625 | 2020-07-03 | Sitka City and Borough | Alaska | 2220 | 18 | 0 |
296626 | 296626 | 2020-07-03 | Southeast Fairbanks Census Area | Alaska | 2240 | 16 | 0 |
296627 | 296627 | 2020-07-03 | Unknown | Alaska | 7 | 0 | |
296628 | 296628 | 2020-07-03 | Valdez-Cordova Census Area | Alaska | 2261 | 22 | 0 |
296629 | 296629 | 2020-07-03 | Wrangell City and Borough | Alaska | 2275 | 8 | 0 |
296630 | 296630 | 2020-07-03 | Yukon-Koyukuk Census Area | Alaska | 2290 | 3 | 0 |
296631 | 296631 | 2020-07-03 | Apache | Arizona | 4001 | 2418 | 91 |
296632 | 296632 | 2020-07-03 | Cochise | Arizona | 4003 | 723 | 14 |
296633 | 296633 | 2020-07-03 | Coconino | Arizona | 4005 | 2087 | 96 |
296634 | 296634 | 2020-07-03 | Gila | Arizona | 4007 | 325 | 6 |
296635 | 296635 | 2020-07-03 | Graham | Arizona | 4009 | 125 | 3 |
296636 | 296636 | 2020-07-03 | Greenlee | Arizona | 4011 | 19 | 1 |
296637 | 296637 | 2020-07-03 | La Paz | Arizona | 4012 | 351 | 5 |
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);