ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,254 rows where date = "2022-02-09" 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 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 32
- 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 |
---|---|---|---|---|---|---|---|
2196964 | 2196964 | 2022-02-09 | Autauga | Alabama | 1001 | 15121 | 173 |
2196965 | 2196965 | 2022-02-09 | Baldwin | Alabama | 1003 | 54095 | 626 |
2196966 | 2196966 | 2022-02-09 | Barbour | Alabama | 1005 | 5380 | 85 |
2196967 | 2196967 | 2022-02-09 | Bibb | Alabama | 1007 | 6267 | 96 |
2196968 | 2196968 | 2022-02-09 | Blount | Alabama | 1009 | 14447 | 212 |
2196969 | 2196969 | 2022-02-09 | Bullock | Alabama | 1011 | 2261 | 49 |
2196970 | 2196970 | 2022-02-09 | Butler | Alabama | 1013 | 4962 | 110 |
2196971 | 2196971 | 2022-02-09 | Calhoun | Alabama | 1015 | 30989 | 565 |
2196972 | 2196972 | 2022-02-09 | Chambers | Alabama | 1017 | 8332 | 149 |
2196973 | 2196973 | 2022-02-09 | Cherokee | Alabama | 1019 | 4969 | 70 |
2196974 | 2196974 | 2022-02-09 | Chilton | Alabama | 1021 | 10280 | 184 |
2196975 | 2196975 | 2022-02-09 | Choctaw | Alabama | 1023 | 1904 | 33 |
2196976 | 2196976 | 2022-02-09 | Clarke | Alabama | 1025 | 6921 | 93 |
2196977 | 2196977 | 2022-02-09 | Clay | Alabama | 1027 | 4012 | 73 |
2196978 | 2196978 | 2022-02-09 | Cleburne | Alabama | 1029 | 3488 | 65 |
2196979 | 2196979 | 2022-02-09 | Coffee | Alabama | 1031 | 13141 | 212 |
2196980 | 2196980 | 2022-02-09 | Colbert | Alabama | 1033 | 15805 | 222 |
2196981 | 2196981 | 2022-02-09 | Conecuh | Alabama | 1035 | 2805 | 63 |
2196982 | 2196982 | 2022-02-09 | Coosa | Alabama | 1037 | 2848 | 53 |
2196983 | 2196983 | 2022-02-09 | Covington | Alabama | 1039 | 9087 | 212 |
2196984 | 2196984 | 2022-02-09 | Crenshaw | Alabama | 1041 | 3712 | 84 |
2196985 | 2196985 | 2022-02-09 | Cullman | Alabama | 1043 | 23848 | 331 |
2196986 | 2196986 | 2022-02-09 | Dale | Alabama | 1045 | 12226 | 207 |
2196987 | 2196987 | 2022-02-09 | Dallas | Alabama | 1047 | 8118 | 226 |
2196988 | 2196988 | 2022-02-09 | DeKalb | Alabama | 1049 | 18214 | 296 |
2196989 | 2196989 | 2022-02-09 | Elmore | Alabama | 1051 | 22591 | 315 |
2196990 | 2196990 | 2022-02-09 | Escambia | Alabama | 1053 | 9845 | 153 |
2196991 | 2196991 | 2022-02-09 | Etowah | Alabama | 1055 | 28009 | 556 |
2196992 | 2196992 | 2022-02-09 | Fayette | Alabama | 1057 | 4505 | 87 |
2196993 | 2196993 | 2022-02-09 | Franklin | Alabama | 1059 | 9607 | 123 |
2196994 | 2196994 | 2022-02-09 | Geneva | Alabama | 1061 | 6032 | 146 |
2196995 | 2196995 | 2022-02-09 | Greene | Alabama | 1063 | 1772 | 48 |
2196996 | 2196996 | 2022-02-09 | Hale | Alabama | 1065 | 4484 | 96 |
2196997 | 2196997 | 2022-02-09 | Henry | Alabama | 1067 | 4355 | 67 |
2196998 | 2196998 | 2022-02-09 | Houston | Alabama | 1069 | 24432 | 457 |
2196999 | 2196999 | 2022-02-09 | Jackson | Alabama | 1071 | 14640 | 214 |
2197000 | 2197000 | 2022-02-09 | Jefferson | Alabama | 1073 | 179326 | 2122 |
2197001 | 2197001 | 2022-02-09 | Lamar | Alabama | 1075 | 3514 | 62 |
2197002 | 2197002 | 2022-02-09 | Lauderdale | Alabama | 1077 | 23366 | 343 |
2197003 | 2197003 | 2022-02-09 | Lawrence | Alabama | 1079 | 7327 | 144 |
2197004 | 2197004 | 2022-02-09 | Lee | Alabama | 1081 | 37018 | 289 |
2197005 | 2197005 | 2022-02-09 | Limestone | Alabama | 1083 | 24085 | 248 |
2197006 | 2197006 | 2022-02-09 | Lowndes | Alabama | 1085 | 2577 | 69 |
2197007 | 2197007 | 2022-02-09 | Macon | Alabama | 1087 | 3782 | 71 |
2197008 | 2197008 | 2022-02-09 | Madison | Alabama | 1089 | 85863 | 834 |
2197009 | 2197009 | 2022-02-09 | Marengo | Alabama | 1091 | 4632 | 97 |
2197010 | 2197010 | 2022-02-09 | Marion | Alabama | 1093 | 7796 | 139 |
2197011 | 2197011 | 2022-02-09 | Marshall | Alabama | 1095 | 26789 | 346 |
2197012 | 2197012 | 2022-02-09 | Mobile | Alabama | 1097 | 110014 | 1504 |
2197013 | 2197013 | 2022-02-09 | Monroe | Alabama | 1099 | 5182 | 71 |
2197014 | 2197014 | 2022-02-09 | Montgomery | Alabama | 1101 | 53528 | 827 |
2197015 | 2197015 | 2022-02-09 | Morgan | Alabama | 1103 | 34951 | 456 |
2197016 | 2197016 | 2022-02-09 | Perry | Alabama | 1105 | 2000 | 41 |
2197017 | 2197017 | 2022-02-09 | Pickens | Alabama | 1107 | 4980 | 95 |
2197018 | 2197018 | 2022-02-09 | Pike | Alabama | 1109 | 7242 | 119 |
2197019 | 2197019 | 2022-02-09 | Randolph | Alabama | 1111 | 4983 | 71 |
2197020 | 2197020 | 2022-02-09 | Russell | Alabama | 1113 | 9691 | 75 |
2197021 | 2197021 | 2022-02-09 | Shelby | Alabama | 1117 | 57763 | 404 |
2197022 | 2197022 | 2022-02-09 | St. Clair | Alabama | 1115 | 24514 | 382 |
2197023 | 2197023 | 2022-02-09 | Sumter | Alabama | 1119 | 2337 | 43 |
2197024 | 2197024 | 2022-02-09 | Talladega | Alabama | 1121 | 21480 | 330 |
2197025 | 2197025 | 2022-02-09 | Tallapoosa | Alabama | 1123 | 11126 | 213 |
2197026 | 2197026 | 2022-02-09 | Tuscaloosa | Alabama | 1125 | 53002 | 697 |
2197027 | 2197027 | 2022-02-09 | Walker | Alabama | 1127 | 18014 | 400 |
2197028 | 2197028 | 2022-02-09 | Washington | Alabama | 1129 | 3574 | 53 |
2197029 | 2197029 | 2022-02-09 | Wilcox | Alabama | 1131 | 2786 | 40 |
2197030 | 2197030 | 2022-02-09 | Winston | Alabama | 1133 | 7286 | 116 |
2197031 | 2197031 | 2022-02-09 | Aleutians East Borough | Alaska | 2013 | 997 | 3 |
2197032 | 2197032 | 2022-02-09 | Aleutians West Census Area | Alaska | 2016 | 1657 | 1 |
2197033 | 2197033 | 2022-02-09 | Anchorage | Alaska | 2020 | 96917 | 469 |
2197034 | 2197034 | 2022-02-09 | Bethel Census Area | Alaska | 2050 | 8633 | 37 |
2197035 | 2197035 | 2022-02-09 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 772 | 1 |
2197036 | 2197036 | 2022-02-09 | Denali Borough | Alaska | 2068 | 365 | 1 |
2197037 | 2197037 | 2022-02-09 | Dillingham Census Area | Alaska | 2070 | 1445 | 11 |
2197038 | 2197038 | 2022-02-09 | Fairbanks North Star Borough | Alaska | 2090 | 26040 | 124 |
2197039 | 2197039 | 2022-02-09 | Haines Borough | Alaska | 2100 | 450 | 1 |
2197040 | 2197040 | 2022-02-09 | Juneau City and Borough | Alaska | 2110 | 7447 | 16 |
2197041 | 2197041 | 2022-02-09 | Kenai Peninsula Borough | Alaska | 2122 | 16044 | 90 |
2197042 | 2197042 | 2022-02-09 | Ketchikan Gateway Borough | Alaska | 2130 | 3605 | 16 |
2197043 | 2197043 | 2022-02-09 | Kodiak Island Borough | Alaska | 2150 | 4587 | 10 |
2197044 | 2197044 | 2022-02-09 | Kusilvak Census Area | Alaska | 2158 | 3472 | 9 |
2197045 | 2197045 | 2022-02-09 | Matanuska-Susitna Borough | Alaska | 2170 | 32669 | 207 |
2197046 | 2197046 | 2022-02-09 | Nome Census Area | Alaska | 2180 | 4566 | 5 |
2197047 | 2197047 | 2022-02-09 | North Slope Borough | Alaska | 2185 | 4045 | 10 |
2197048 | 2197048 | 2022-02-09 | Northwest Arctic Borough | Alaska | 2188 | 3687 | 11 |
2197049 | 2197049 | 2022-02-09 | Petersburg Borough | Alaska | 2195 | 638 | 2 |
2197050 | 2197050 | 2022-02-09 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1178 | 6 |
2197051 | 2197051 | 2022-02-09 | Sitka City and Borough | Alaska | 2220 | 2099 | 5 |
2197052 | 2197052 | 2022-02-09 | Skagway Municipality | Alaska | 2230 | 117 | 0 |
2197053 | 2197053 | 2022-02-09 | Southeast Fairbanks Census Area | Alaska | 2240 | 1900 | 16 |
2197054 | 2197054 | 2022-02-09 | Unknown | Alaska | 815 | 1 | |
2197055 | 2197055 | 2022-02-09 | Valdez-Cordova Census Area | Alaska | 2261 | 2566 | 16 |
2197056 | 2197056 | 2022-02-09 | Wrangell City and Borough | Alaska | 2275 | 432 | 1 |
2197057 | 2197057 | 2022-02-09 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 452 | 5 |
2197058 | 2197058 | 2022-02-09 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1257 | 8 |
2197059 | 2197059 | 2022-02-09 | Unknown | American Samoa | 18 | 0 | |
2197060 | 2197060 | 2022-02-09 | Apache | Arizona | 4001 | 21151 | 575 |
2197061 | 2197061 | 2022-02-09 | Cochise | Arizona | 4003 | 29781 | 522 |
2197062 | 2197062 | 2022-02-09 | Coconino | Arizona | 4005 | 42007 | 445 |
2197063 | 2197063 | 2022-02-09 | Gila | Arizona | 4007 | 16464 | 346 |
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);