ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,245 rows where date = "2021-01-17" 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 102
- 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
- Jackson 24
- Lincoln 24
- Unknown 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 |
---|---|---|---|---|---|---|---|
936664 | 936664 | 2021-01-17 | Autauga | Alabama | 1001 | 5184 | 55 |
936665 | 936665 | 2021-01-17 | Baldwin | Alabama | 1003 | 16251 | 182 |
936666 | 936666 | 2021-01-17 | Barbour | Alabama | 1005 | 1729 | 36 |
936667 | 936667 | 2021-01-17 | Bibb | Alabama | 1007 | 2151 | 47 |
936668 | 936668 | 2021-01-17 | Blount | Alabama | 1009 | 5304 | 83 |
936669 | 936669 | 2021-01-17 | Bullock | Alabama | 1011 | 990 | 28 |
936670 | 936670 | 2021-01-17 | Butler | Alabama | 1013 | 1696 | 58 |
936671 | 936671 | 2021-01-17 | Calhoun | Alabama | 1015 | 11122 | 200 |
936672 | 936672 | 2021-01-17 | Chambers | Alabama | 1017 | 2827 | 69 |
936673 | 936673 | 2021-01-17 | Cherokee | Alabama | 1019 | 1603 | 30 |
936674 | 936674 | 2021-01-17 | Chilton | Alabama | 1021 | 3361 | 65 |
936675 | 936675 | 2021-01-17 | Choctaw | Alabama | 1023 | 512 | 24 |
936676 | 936676 | 2021-01-17 | Clarke | Alabama | 1025 | 2814 | 33 |
936677 | 936677 | 2021-01-17 | Clay | Alabama | 1027 | 1261 | 45 |
936678 | 936678 | 2021-01-17 | Cleburne | Alabama | 1029 | 1174 | 23 |
936679 | 936679 | 2021-01-17 | Coffee | Alabama | 1031 | 4410 | 56 |
936680 | 936680 | 2021-01-17 | Colbert | Alabama | 1033 | 5320 | 73 |
936681 | 936681 | 2021-01-17 | Conecuh | Alabama | 1035 | 944 | 20 |
936682 | 936682 | 2021-01-17 | Coosa | Alabama | 1037 | 605 | 15 |
936683 | 936683 | 2021-01-17 | Covington | Alabama | 1039 | 3272 | 68 |
936684 | 936684 | 2021-01-17 | Crenshaw | Alabama | 1041 | 1187 | 44 |
936685 | 936685 | 2021-01-17 | Cullman | Alabama | 1043 | 8023 | 105 |
936686 | 936686 | 2021-01-17 | Dale | Alabama | 1045 | 3961 | 81 |
936687 | 936687 | 2021-01-17 | Dallas | Alabama | 1047 | 3031 | 96 |
936688 | 936688 | 2021-01-17 | DeKalb | Alabama | 1049 | 7683 | 97 |
936689 | 936689 | 2021-01-17 | Elmore | Alabama | 1051 | 7836 | 101 |
936690 | 936690 | 2021-01-17 | Escambia | Alabama | 1053 | 3168 | 42 |
936691 | 936691 | 2021-01-17 | Etowah | Alabama | 1055 | 11735 | 168 |
936692 | 936692 | 2021-01-17 | Fayette | Alabama | 1057 | 1682 | 26 |
936693 | 936693 | 2021-01-17 | Franklin | Alabama | 1059 | 3662 | 48 |
936694 | 936694 | 2021-01-17 | Geneva | Alabama | 1061 | 2014 | 35 |
936695 | 936695 | 2021-01-17 | Greene | Alabama | 1063 | 760 | 23 |
936696 | 936696 | 2021-01-17 | Hale | Alabama | 1065 | 1758 | 42 |
936697 | 936697 | 2021-01-17 | Henry | Alabama | 1067 | 1536 | 21 |
936698 | 936698 | 2021-01-17 | Houston | Alabama | 1069 | 8598 | 148 |
936699 | 936699 | 2021-01-17 | Jackson | Alabama | 1071 | 5803 | 41 |
936700 | 936700 | 2021-01-17 | Jefferson | Alabama | 1073 | 62039 | 921 |
936701 | 936701 | 2021-01-17 | Lamar | Alabama | 1075 | 1180 | 19 |
936702 | 936702 | 2021-01-17 | Lauderdale | Alabama | 1077 | 7546 | 83 |
936703 | 936703 | 2021-01-17 | Lawrence | Alabama | 1079 | 2436 | 47 |
936704 | 936704 | 2021-01-17 | Lee | Alabama | 1081 | 12465 | 101 |
936705 | 936705 | 2021-01-17 | Limestone | Alabama | 1083 | 8002 | 74 |
936706 | 936706 | 2021-01-17 | Lowndes | Alabama | 1085 | 1103 | 35 |
936707 | 936707 | 2021-01-17 | Macon | Alabama | 1087 | 1147 | 35 |
936708 | 936708 | 2021-01-17 | Madison | Alabama | 1089 | 27052 | 186 |
936709 | 936709 | 2021-01-17 | Marengo | Alabama | 1091 | 1990 | 29 |
936710 | 936710 | 2021-01-17 | Marion | Alabama | 1093 | 2456 | 50 |
936711 | 936711 | 2021-01-17 | Marshall | Alabama | 1095 | 10191 | 107 |
936712 | 936712 | 2021-01-17 | Mobile | Alabama | 1097 | 30225 | 548 |
936713 | 936713 | 2021-01-17 | Monroe | Alabama | 1099 | 1452 | 17 |
936714 | 936714 | 2021-01-17 | Montgomery | Alabama | 1101 | 18978 | 305 |
936715 | 936715 | 2021-01-17 | Morgan | Alabama | 1103 | 12233 | 113 |
936716 | 936716 | 2021-01-17 | Perry | Alabama | 1105 | 974 | 19 |
936717 | 936717 | 2021-01-17 | Pickens | Alabama | 1107 | 1965 | 31 |
936718 | 936718 | 2021-01-17 | Pike | Alabama | 1109 | 2487 | 29 |
936719 | 936719 | 2021-01-17 | Randolph | Alabama | 1111 | 1398 | 35 |
936720 | 936720 | 2021-01-17 | Russell | Alabama | 1113 | 3303 | 10 |
936721 | 936721 | 2021-01-17 | Shelby | Alabama | 1117 | 18504 | 114 |
936722 | 936722 | 2021-01-17 | St. Clair | Alabama | 1115 | 7535 | 120 |
936723 | 936723 | 2021-01-17 | Sumter | Alabama | 1119 | 890 | 26 |
936724 | 936724 | 2021-01-17 | Talladega | Alabama | 1121 | 6166 | 108 |
936725 | 936725 | 2021-01-17 | Tallapoosa | Alabama | 1123 | 2616 | 107 |
936726 | 936726 | 2021-01-17 | Tuscaloosa | Alabama | 1125 | 20728 | 267 |
936727 | 936727 | 2021-01-17 | Walker | Alabama | 1127 | 5897 | 174 |
936728 | 936728 | 2021-01-17 | Washington | Alabama | 1129 | 1376 | 26 |
936729 | 936729 | 2021-01-17 | Wilcox | Alabama | 1131 | 1031 | 21 |
936730 | 936730 | 2021-01-17 | Winston | Alabama | 1133 | 2266 | 35 |
936731 | 936731 | 2021-01-17 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
936732 | 936732 | 2021-01-17 | Aleutians West Census Area | Alaska | 2016 | 268 | 0 |
936733 | 936733 | 2021-01-17 | Anchorage | Alaska | 2020 | 24533 | 127 |
936734 | 936734 | 2021-01-17 | Bethel Census Area | Alaska | 2050 | 2983 | 12 |
936735 | 936735 | 2021-01-17 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 165 | 0 |
936736 | 936736 | 2021-01-17 | Denali Borough | Alaska | 2068 | 62 | 0 |
936737 | 936737 | 2021-01-17 | Dillingham Census Area | Alaska | 2070 | 153 | 1 |
936738 | 936738 | 2021-01-17 | Fairbanks North Star Borough | Alaska | 2090 | 5594 | 23 |
936739 | 936739 | 2021-01-17 | Haines Borough | Alaska | 2100 | 21 | 0 |
936740 | 936740 | 2021-01-17 | Juneau City and Borough | Alaska | 2110 | 1078 | 3 |
936741 | 936741 | 2021-01-17 | Kenai Peninsula Borough | Alaska | 2122 | 3799 | 16 |
936742 | 936742 | 2021-01-17 | Ketchikan Gateway Borough | Alaska | 2130 | 264 | 1 |
936743 | 936743 | 2021-01-17 | Kodiak Island Borough | Alaska | 2150 | 998 | 2 |
936744 | 936744 | 2021-01-17 | Kusilvak Census Area | Alaska | 2158 | 993 | 3 |
936745 | 936745 | 2021-01-17 | Matanuska-Susitna Borough | Alaska | 2170 | 7125 | 18 |
936746 | 936746 | 2021-01-17 | Nome Census Area | Alaska | 2180 | 296 | 0 |
936747 | 936747 | 2021-01-17 | North Slope Borough | Alaska | 2185 | 957 | 3 |
936748 | 936748 | 2021-01-17 | Northwest Arctic Borough | Alaska | 2188 | 518 | 0 |
936749 | 936749 | 2021-01-17 | Petersburg Borough | Alaska | 2195 | 42 | 0 |
936750 | 936750 | 2021-01-17 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 70 | 1 |
936751 | 936751 | 2021-01-17 | Sitka City and Borough | Alaska | 2220 | 289 | 0 |
936752 | 936752 | 2021-01-17 | Skagway Municipality | Alaska | 2230 | 15 | 0 |
936753 | 936753 | 2021-01-17 | Southeast Fairbanks Census Area | Alaska | 2240 | 409 | 3 |
936754 | 936754 | 2021-01-17 | Unknown | Alaska | 225 | 0 | |
936755 | 936755 | 2021-01-17 | Valdez-Cordova Census Area | Alaska | 2261 | 397 | 2 |
936756 | 936756 | 2021-01-17 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
936757 | 936757 | 2021-01-17 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 60 | 1 |
936758 | 936758 | 2021-01-17 | Yukon-Koyukuk Census Area | Alaska | 2290 | 253 | 4 |
936759 | 936759 | 2021-01-17 | Apache | Arizona | 4001 | 8634 | 278 |
936760 | 936760 | 2021-01-17 | Cochise | Arizona | 4003 | 9589 | 191 |
936761 | 936761 | 2021-01-17 | Coconino | Arizona | 4005 | 13943 | 245 |
936762 | 936762 | 2021-01-17 | Gila | Arizona | 4007 | 5389 | 167 |
936763 | 936763 | 2021-01-17 | Graham | Arizona | 4009 | 4361 | 58 |
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);