ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,254 rows where date = "2022-01-19" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 255
- 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
- …
fips >30
county >30
- Unknown 33
- Washington 31
- Jefferson 26
- Franklin 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 |
---|---|---|---|---|---|---|---|
2128641 | 2128641 | 2022-01-19 | Autauga | Alabama | 1001 | 12833 | 163 |
2128642 | 2128642 | 2022-01-19 | Baldwin | Alabama | 1003 | 47662 | 605 |
2128643 | 2128643 | 2022-01-19 | Barbour | Alabama | 1005 | 4800 | 83 |
2128644 | 2128644 | 2022-01-19 | Bibb | Alabama | 1007 | 5486 | 95 |
2128645 | 2128645 | 2022-01-19 | Blount | Alabama | 1009 | 12825 | 203 |
2128646 | 2128646 | 2022-01-19 | Bullock | Alabama | 1011 | 2039 | 46 |
2128647 | 2128647 | 2022-01-19 | Butler | Alabama | 1013 | 4319 | 103 |
2128648 | 2128648 | 2022-01-19 | Calhoun | Alabama | 1015 | 27065 | 539 |
2128649 | 2128649 | 2022-01-19 | Chambers | Alabama | 1017 | 7540 | 147 |
2128650 | 2128650 | 2022-01-19 | Cherokee | Alabama | 1019 | 4196 | 67 |
2128651 | 2128651 | 2022-01-19 | Chilton | Alabama | 1021 | 8874 | 178 |
2128652 | 2128652 | 2022-01-19 | Choctaw | Alabama | 1023 | 1390 | 31 |
2128653 | 2128653 | 2022-01-19 | Clarke | Alabama | 1025 | 6057 | 89 |
2128654 | 2128654 | 2022-01-19 | Clay | Alabama | 1027 | 3358 | 70 |
2128655 | 2128655 | 2022-01-19 | Cleburne | Alabama | 1029 | 2988 | 62 |
2128656 | 2128656 | 2022-01-19 | Coffee | Alabama | 1031 | 11465 | 201 |
2128657 | 2128657 | 2022-01-19 | Colbert | Alabama | 1033 | 12922 | 217 |
2128658 | 2128658 | 2022-01-19 | Conecuh | Alabama | 1035 | 2453 | 63 |
2128659 | 2128659 | 2022-01-19 | Coosa | Alabama | 1037 | 2424 | 48 |
2128660 | 2128660 | 2022-01-19 | Covington | Alabama | 1039 | 8183 | 203 |
2128661 | 2128661 | 2022-01-19 | Crenshaw | Alabama | 1041 | 3245 | 80 |
2128662 | 2128662 | 2022-01-19 | Cullman | Alabama | 1043 | 20187 | 319 |
2128663 | 2128663 | 2022-01-19 | Dale | Alabama | 1045 | 10892 | 198 |
2128664 | 2128664 | 2022-01-19 | Dallas | Alabama | 1047 | 6865 | 216 |
2128665 | 2128665 | 2022-01-19 | DeKalb | Alabama | 1049 | 15551 | 286 |
2128666 | 2128666 | 2022-01-19 | Elmore | Alabama | 1051 | 19456 | 302 |
2128667 | 2128667 | 2022-01-19 | Escambia | Alabama | 1053 | 8818 | 150 |
2128668 | 2128668 | 2022-01-19 | Etowah | Alabama | 1055 | 24230 | 533 |
2128669 | 2128669 | 2022-01-19 | Fayette | Alabama | 1057 | 3905 | 86 |
2128670 | 2128670 | 2022-01-19 | Franklin | Alabama | 1059 | 7836 | 116 |
2128671 | 2128671 | 2022-01-19 | Geneva | Alabama | 1061 | 5217 | 140 |
2128672 | 2128672 | 2022-01-19 | Greene | Alabama | 1063 | 1593 | 47 |
2128673 | 2128673 | 2022-01-19 | Hale | Alabama | 1065 | 4032 | 94 |
2128674 | 2128674 | 2022-01-19 | Henry | Alabama | 1067 | 3830 | 67 |
2128675 | 2128675 | 2022-01-19 | Houston | Alabama | 1069 | 21672 | 443 |
2128676 | 2128676 | 2022-01-19 | Jackson | Alabama | 1071 | 12176 | 207 |
2128677 | 2128677 | 2022-01-19 | Jefferson | Alabama | 1073 | 157776 | 2037 |
2128678 | 2128678 | 2022-01-19 | Lamar | Alabama | 1075 | 2933 | 60 |
2128679 | 2128679 | 2022-01-19 | Lauderdale | Alabama | 1077 | 19702 | 327 |
2128680 | 2128680 | 2022-01-19 | Lawrence | Alabama | 1079 | 6103 | 140 |
2128681 | 2128681 | 2022-01-19 | Lee | Alabama | 1081 | 32940 | 273 |
2128682 | 2128682 | 2022-01-19 | Limestone | Alabama | 1083 | 20682 | 234 |
2128683 | 2128683 | 2022-01-19 | Lowndes | Alabama | 1085 | 2298 | 68 |
2128684 | 2128684 | 2022-01-19 | Macon | Alabama | 1087 | 3313 | 69 |
2128685 | 2128685 | 2022-01-19 | Madison | Alabama | 1089 | 71990 | 787 |
2128686 | 2128686 | 2022-01-19 | Marengo | Alabama | 1091 | 4130 | 93 |
2128687 | 2128687 | 2022-01-19 | Marion | Alabama | 1093 | 6615 | 134 |
2128688 | 2128688 | 2022-01-19 | Marshall | Alabama | 1095 | 22555 | 332 |
2128689 | 2128689 | 2022-01-19 | Mobile | Alabama | 1097 | 98462 | 1418 |
2128690 | 2128690 | 2022-01-19 | Monroe | Alabama | 1099 | 4393 | 66 |
2128691 | 2128691 | 2022-01-19 | Montgomery | Alabama | 1101 | 47132 | 808 |
2128692 | 2128692 | 2022-01-19 | Morgan | Alabama | 1103 | 29469 | 437 |
2128693 | 2128693 | 2022-01-19 | Perry | Alabama | 1105 | 1751 | 40 |
2128694 | 2128694 | 2022-01-19 | Pickens | Alabama | 1107 | 4293 | 92 |
2128695 | 2128695 | 2022-01-19 | Pike | Alabama | 1109 | 6300 | 115 |
2128696 | 2128696 | 2022-01-19 | Randolph | Alabama | 1111 | 4401 | 69 |
2128697 | 2128697 | 2022-01-19 | Russell | Alabama | 1113 | 8738 | 69 |
2128698 | 2128698 | 2022-01-19 | Shelby | Alabama | 1117 | 50124 | 389 |
2128699 | 2128699 | 2022-01-19 | St. Clair | Alabama | 1115 | 21730 | 371 |
2128700 | 2128700 | 2022-01-19 | Sumter | Alabama | 1119 | 1862 | 42 |
2128701 | 2128701 | 2022-01-19 | Talladega | Alabama | 1121 | 18334 | 313 |
2128702 | 2128702 | 2022-01-19 | Tallapoosa | Alabama | 1123 | 9688 | 208 |
2128703 | 2128703 | 2022-01-19 | Tuscaloosa | Alabama | 1125 | 46371 | 672 |
2128704 | 2128704 | 2022-01-19 | Walker | Alabama | 1127 | 14726 | 392 |
2128705 | 2128705 | 2022-01-19 | Washington | Alabama | 1129 | 3055 | 52 |
2128706 | 2128706 | 2022-01-19 | Wilcox | Alabama | 1131 | 2356 | 38 |
2128707 | 2128707 | 2022-01-19 | Winston | Alabama | 1133 | 5764 | 114 |
2128708 | 2128708 | 2022-01-19 | Aleutians East Borough | Alaska | 2013 | 551 | 3 |
2128709 | 2128709 | 2022-01-19 | Aleutians West Census Area | Alaska | 2016 | 1348 | 1 |
2128710 | 2128710 | 2022-01-19 | Anchorage | Alaska | 2020 | 80757 | 444 |
2128711 | 2128711 | 2022-01-19 | Bethel Census Area | Alaska | 2050 | 7481 | 37 |
2128712 | 2128712 | 2022-01-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 630 | 1 |
2128713 | 2128713 | 2022-01-19 | Denali Borough | Alaska | 2068 | 312 | 1 |
2128714 | 2128714 | 2022-01-19 | Dillingham Census Area | Alaska | 2070 | 1119 | 11 |
2128715 | 2128715 | 2022-01-19 | Fairbanks North Star Borough | Alaska | 2090 | 20681 | 122 |
2128716 | 2128716 | 2022-01-19 | Haines Borough | Alaska | 2100 | 349 | 1 |
2128717 | 2128717 | 2022-01-19 | Juneau City and Borough | Alaska | 2110 | 6103 | 16 |
2128718 | 2128718 | 2022-01-19 | Kenai Peninsula Borough | Alaska | 2122 | 13409 | 85 |
2128719 | 2128719 | 2022-01-19 | Ketchikan Gateway Borough | Alaska | 2130 | 2763 | 13 |
2128720 | 2128720 | 2022-01-19 | Kodiak Island Borough | Alaska | 2150 | 3701 | 10 |
2128721 | 2128721 | 2022-01-19 | Kusilvak Census Area | Alaska | 2158 | 2816 | 9 |
2128722 | 2128722 | 2022-01-19 | Matanuska-Susitna Borough | Alaska | 2170 | 27470 | 192 |
2128723 | 2128723 | 2022-01-19 | Nome Census Area | Alaska | 2180 | 2918 | 3 |
2128724 | 2128724 | 2022-01-19 | North Slope Borough | Alaska | 2185 | 3222 | 10 |
2128725 | 2128725 | 2022-01-19 | Northwest Arctic Borough | Alaska | 2188 | 2771 | 10 |
2128726 | 2128726 | 2022-01-19 | Petersburg Borough | Alaska | 2195 | 577 | 2 |
2128727 | 2128727 | 2022-01-19 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 852 | 6 |
2128728 | 2128728 | 2022-01-19 | Sitka City and Borough | Alaska | 2220 | 1711 | 5 |
2128729 | 2128729 | 2022-01-19 | Skagway Municipality | Alaska | 2230 | 96 | 0 |
2128730 | 2128730 | 2022-01-19 | Southeast Fairbanks Census Area | Alaska | 2240 | 1532 | 16 |
2128731 | 2128731 | 2022-01-19 | Unknown | Alaska | 635 | 1 | |
2128732 | 2128732 | 2022-01-19 | Valdez-Cordova Census Area | Alaska | 2261 | 2172 | 14 |
2128733 | 2128733 | 2022-01-19 | Wrangell City and Borough | Alaska | 2275 | 332 | 1 |
2128734 | 2128734 | 2022-01-19 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 391 | 5 |
2128735 | 2128735 | 2022-01-19 | Yukon-Koyukuk Census Area | Alaska | 2290 | 956 | 8 |
2128736 | 2128736 | 2022-01-19 | Unknown | American Samoa | 18 | 0 | |
2128737 | 2128737 | 2022-01-19 | Apache | Arizona | 4001 | 18323 | 560 |
2128738 | 2128738 | 2022-01-19 | Cochise | Arizona | 4003 | 23932 | 490 |
2128739 | 2128739 | 2022-01-19 | Coconino | Arizona | 4005 | 35545 | 428 |
2128740 | 2128740 | 2022-01-19 | Gila | Arizona | 4007 | 13971 | 326 |
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);