ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,253 rows where date = "2022-02-13" 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 31
- 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 |
---|---|---|---|---|---|---|---|
2209978 | 2209978 | 2022-02-13 | Autauga | Alabama | 1001 | 15307 | 176 |
2209979 | 2209979 | 2022-02-13 | Baldwin | Alabama | 1003 | 54444 | 626 |
2209980 | 2209980 | 2022-02-13 | Barbour | Alabama | 1005 | 5409 | 89 |
2209981 | 2209981 | 2022-02-13 | Bibb | Alabama | 1007 | 6314 | 97 |
2209982 | 2209982 | 2022-02-13 | Blount | Alabama | 1009 | 14556 | 213 |
2209983 | 2209983 | 2022-02-13 | Bullock | Alabama | 1011 | 2266 | 49 |
2209984 | 2209984 | 2022-02-13 | Butler | Alabama | 1013 | 4993 | 112 |
2209985 | 2209985 | 2022-02-13 | Calhoun | Alabama | 1015 | 31185 | 568 |
2209986 | 2209986 | 2022-02-13 | Chambers | Alabama | 1017 | 8373 | 149 |
2209987 | 2209987 | 2022-02-13 | Cherokee | Alabama | 1019 | 5005 | 74 |
2209988 | 2209988 | 2022-02-13 | Chilton | Alabama | 1021 | 10354 | 185 |
2209989 | 2209989 | 2022-02-13 | Choctaw | Alabama | 1023 | 1938 | 33 |
2209990 | 2209990 | 2022-02-13 | Clarke | Alabama | 1025 | 6959 | 93 |
2209991 | 2209991 | 2022-02-13 | Clay | Alabama | 1027 | 4035 | 73 |
2209992 | 2209992 | 2022-02-13 | Cleburne | Alabama | 1029 | 3504 | 65 |
2209993 | 2209993 | 2022-02-13 | Coffee | Alabama | 1031 | 13206 | 213 |
2209994 | 2209994 | 2022-02-13 | Colbert | Alabama | 1033 | 15922 | 224 |
2209995 | 2209995 | 2022-02-13 | Conecuh | Alabama | 1035 | 2816 | 63 |
2209996 | 2209996 | 2022-02-13 | Coosa | Alabama | 1037 | 2864 | 53 |
2209997 | 2209997 | 2022-02-13 | Covington | Alabama | 1039 | 9137 | 212 |
2209998 | 2209998 | 2022-02-13 | Crenshaw | Alabama | 1041 | 3741 | 84 |
2209999 | 2209999 | 2022-02-13 | Cullman | Alabama | 1043 | 24020 | 332 |
2210000 | 2210000 | 2022-02-13 | Dale | Alabama | 1045 | 12318 | 212 |
2210001 | 2210001 | 2022-02-13 | Dallas | Alabama | 1047 | 8173 | 226 |
2210002 | 2210002 | 2022-02-13 | DeKalb | Alabama | 1049 | 18338 | 300 |
2210003 | 2210003 | 2022-02-13 | Elmore | Alabama | 1051 | 22693 | 317 |
2210004 | 2210004 | 2022-02-13 | Escambia | Alabama | 1053 | 9887 | 153 |
2210005 | 2210005 | 2022-02-13 | Etowah | Alabama | 1055 | 28270 | 560 |
2210006 | 2210006 | 2022-02-13 | Fayette | Alabama | 1057 | 4524 | 89 |
2210007 | 2210007 | 2022-02-13 | Franklin | Alabama | 1059 | 9681 | 123 |
2210008 | 2210008 | 2022-02-13 | Geneva | Alabama | 1061 | 6102 | 146 |
2210009 | 2210009 | 2022-02-13 | Greene | Alabama | 1063 | 1787 | 48 |
2210010 | 2210010 | 2022-02-13 | Hale | Alabama | 1065 | 4515 | 96 |
2210011 | 2210011 | 2022-02-13 | Henry | Alabama | 1067 | 4385 | 68 |
2210012 | 2210012 | 2022-02-13 | Houston | Alabama | 1069 | 24594 | 458 |
2210013 | 2210013 | 2022-02-13 | Jackson | Alabama | 1071 | 14751 | 215 |
2210014 | 2210014 | 2022-02-13 | Jefferson | Alabama | 1073 | 180496 | 2147 |
2210015 | 2210015 | 2022-02-13 | Lamar | Alabama | 1075 | 3540 | 62 |
2210016 | 2210016 | 2022-02-13 | Lauderdale | Alabama | 1077 | 23583 | 349 |
2210017 | 2210017 | 2022-02-13 | Lawrence | Alabama | 1079 | 7417 | 145 |
2210018 | 2210018 | 2022-02-13 | Lee | Alabama | 1081 | 37267 | 290 |
2210019 | 2210019 | 2022-02-13 | Limestone | Alabama | 1083 | 24274 | 251 |
2210020 | 2210020 | 2022-02-13 | Lowndes | Alabama | 1085 | 2587 | 69 |
2210021 | 2210021 | 2022-02-13 | Macon | Alabama | 1087 | 3796 | 72 |
2210022 | 2210022 | 2022-02-13 | Madison | Alabama | 1089 | 86721 | 837 |
2210023 | 2210023 | 2022-02-13 | Marengo | Alabama | 1091 | 4693 | 97 |
2210024 | 2210024 | 2022-02-13 | Marion | Alabama | 1093 | 7846 | 139 |
2210025 | 2210025 | 2022-02-13 | Marshall | Alabama | 1095 | 26902 | 349 |
2210026 | 2210026 | 2022-02-13 | Mobile | Alabama | 1097 | 110593 | 1514 |
2210027 | 2210027 | 2022-02-13 | Monroe | Alabama | 1099 | 5217 | 71 |
2210028 | 2210028 | 2022-02-13 | Montgomery | Alabama | 1101 | 53853 | 832 |
2210029 | 2210029 | 2022-02-13 | Morgan | Alabama | 1103 | 35309 | 461 |
2210030 | 2210030 | 2022-02-13 | Perry | Alabama | 1105 | 2014 | 41 |
2210031 | 2210031 | 2022-02-13 | Pickens | Alabama | 1107 | 5001 | 95 |
2210032 | 2210032 | 2022-02-13 | Pike | Alabama | 1109 | 7338 | 119 |
2210033 | 2210033 | 2022-02-13 | Randolph | Alabama | 1111 | 5016 | 72 |
2210034 | 2210034 | 2022-02-13 | Russell | Alabama | 1113 | 9893 | 75 |
2210035 | 2210035 | 2022-02-13 | Shelby | Alabama | 1117 | 58120 | 404 |
2210036 | 2210036 | 2022-02-13 | St. Clair | Alabama | 1115 | 24676 | 384 |
2210037 | 2210037 | 2022-02-13 | Sumter | Alabama | 1119 | 2369 | 44 |
2210038 | 2210038 | 2022-02-13 | Talladega | Alabama | 1121 | 21621 | 331 |
2210039 | 2210039 | 2022-02-13 | Tallapoosa | Alabama | 1123 | 11188 | 216 |
2210040 | 2210040 | 2022-02-13 | Tuscaloosa | Alabama | 1125 | 53361 | 701 |
2210041 | 2210041 | 2022-02-13 | Walker | Alabama | 1127 | 18182 | 401 |
2210042 | 2210042 | 2022-02-13 | Washington | Alabama | 1129 | 3632 | 53 |
2210043 | 2210043 | 2022-02-13 | Wilcox | Alabama | 1131 | 2815 | 40 |
2210044 | 2210044 | 2022-02-13 | Winston | Alabama | 1133 | 7386 | 116 |
2210045 | 2210045 | 2022-02-13 | Aleutians East Borough | Alaska | 2013 | 998 | 3 |
2210046 | 2210046 | 2022-02-13 | Aleutians West Census Area | Alaska | 2016 | 1661 | 1 |
2210047 | 2210047 | 2022-02-13 | Anchorage | Alaska | 2020 | 97565 | 469 |
2210048 | 2210048 | 2022-02-13 | Bethel Census Area | Alaska | 2050 | 8680 | 37 |
2210049 | 2210049 | 2022-02-13 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 776 | 1 |
2210050 | 2210050 | 2022-02-13 | Denali Borough | Alaska | 2068 | 370 | 1 |
2210051 | 2210051 | 2022-02-13 | Dillingham Census Area | Alaska | 2070 | 1477 | 11 |
2210052 | 2210052 | 2022-02-13 | Fairbanks North Star Borough | Alaska | 2090 | 26199 | 124 |
2210053 | 2210053 | 2022-02-13 | Haines Borough | Alaska | 2100 | 476 | 1 |
2210054 | 2210054 | 2022-02-13 | Juneau City and Borough | Alaska | 2110 | 7518 | 16 |
2210055 | 2210055 | 2022-02-13 | Kenai Peninsula Borough | Alaska | 2122 | 16174 | 90 |
2210056 | 2210056 | 2022-02-13 | Ketchikan Gateway Borough | Alaska | 2130 | 3628 | 16 |
2210057 | 2210057 | 2022-02-13 | Kodiak Island Borough | Alaska | 2150 | 4626 | 10 |
2210058 | 2210058 | 2022-02-13 | Kusilvak Census Area | Alaska | 2158 | 3493 | 9 |
2210059 | 2210059 | 2022-02-13 | Matanuska-Susitna Borough | Alaska | 2170 | 32872 | 207 |
2210060 | 2210060 | 2022-02-13 | Nome Census Area | Alaska | 2180 | 4672 | 5 |
2210061 | 2210061 | 2022-02-13 | North Slope Borough | Alaska | 2185 | 4070 | 10 |
2210062 | 2210062 | 2022-02-13 | Northwest Arctic Borough | Alaska | 2188 | 3799 | 11 |
2210063 | 2210063 | 2022-02-13 | Petersburg Borough | Alaska | 2195 | 645 | 2 |
2210064 | 2210064 | 2022-02-13 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1220 | 6 |
2210065 | 2210065 | 2022-02-13 | Sitka City and Borough | Alaska | 2220 | 2127 | 5 |
2210066 | 2210066 | 2022-02-13 | Skagway Municipality | Alaska | 2230 | 119 | 0 |
2210067 | 2210067 | 2022-02-13 | Southeast Fairbanks Census Area | Alaska | 2240 | 1909 | 16 |
2210068 | 2210068 | 2022-02-13 | Unknown | Alaska | 818 | 1 | |
2210069 | 2210069 | 2022-02-13 | Valdez-Cordova Census Area | Alaska | 2261 | 2677 | 16 |
2210070 | 2210070 | 2022-02-13 | Wrangell City and Borough | Alaska | 2275 | 432 | 1 |
2210071 | 2210071 | 2022-02-13 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 453 | 5 |
2210072 | 2210072 | 2022-02-13 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1259 | 8 |
2210073 | 2210073 | 2022-02-13 | Unknown | American Samoa | 57 | 0 | |
2210074 | 2210074 | 2022-02-13 | Apache | Arizona | 4001 | 21421 | 576 |
2210075 | 2210075 | 2022-02-13 | Cochise | Arizona | 4003 | 30311 | 529 |
2210076 | 2210076 | 2022-02-13 | Coconino | Arizona | 4005 | 42515 | 448 |
2210077 | 2210077 | 2022-02-13 | Gila | Arizona | 4007 | 16597 | 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);