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 69,542
- Georgia 46,809
- Virginia 38,216
- Kentucky 34,012
- Missouri 32,503
- Illinois 29,257
- North Carolina 29,008
- Iowa 28,270
- Kansas 27,921
- Tennessee 27,871
- Indiana 26,990
- Ohio 25,722
- Minnesota 24,939
- Michigan 24,210
- Mississippi 24,074
- Nebraska 23,513
- Arkansas 21,944
- Oklahoma 21,860
- Wisconsin 20,855
- Florida 20,178
- Puerto Rico 19,845
- Pennsylvania 19,745
- Alabama 19,583
- Louisiana 19,183
- Colorado 18,295
- New York 17,388
- California 17,381
- South Dakota 17,344
- West Virginia 15,396
- North Dakota 14,147
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
913981 | 913981 | 2021-01-10 | Henry | Alabama | 1067 | 1433 | 11 |
913982 | 913982 | 2021-01-10 | Houston | Alabama | 1069 | 8167 | 72 |
913983 | 913983 | 2021-01-10 | Jackson | Alabama | 1071 | 5611 | 34 |
913984 | 913984 | 2021-01-10 | Jefferson | Alabama | 1073 | 58896 | 784 |
913985 | 913985 | 2021-01-10 | Lamar | Alabama | 1075 | 1137 | 16 |
913986 | 913986 | 2021-01-10 | Lauderdale | Alabama | 1077 | 7191 | 72 |
913987 | 913987 | 2021-01-10 | Lawrence | Alabama | 1079 | 2324 | 44 |
913988 | 913988 | 2021-01-10 | Lee | Alabama | 1081 | 11565 | 79 |
913989 | 913989 | 2021-01-10 | Limestone | Alabama | 1083 | 7599 | 60 |
913990 | 913990 | 2021-01-10 | Lowndes | Alabama | 1085 | 1052 | 35 |
913991 | 913991 | 2021-01-10 | Macon | Alabama | 1087 | 1093 | 35 |
913992 | 913992 | 2021-01-10 | Madison | Alabama | 1089 | 25463 | 178 |
913993 | 913993 | 2021-01-10 | Marengo | Alabama | 1091 | 1946 | 27 |
913994 | 913994 | 2021-01-10 | Marion | Alabama | 1093 | 2320 | 46 |
913995 | 913995 | 2021-01-10 | Marshall | Alabama | 1095 | 9854 | 92 |
913996 | 913996 | 2021-01-10 | Mobile | Alabama | 1097 | 28584 | 523 |
913997 | 913997 | 2021-01-10 | Monroe | Alabama | 1099 | 1384 | 12 |
913998 | 913998 | 2021-01-10 | Montgomery | Alabama | 1101 | 18064 | 285 |
913999 | 913999 | 2021-01-10 | Morgan | Alabama | 1103 | 11727 | 104 |
914000 | 914000 | 2021-01-10 | Perry | Alabama | 1105 | 930 | 19 |
914001 | 914001 | 2021-01-10 | Pickens | Alabama | 1107 | 1888 | 31 |
914002 | 914002 | 2021-01-10 | Pike | Alabama | 1109 | 2338 | 23 |
914003 | 914003 | 2021-01-10 | Randolph | Alabama | 1111 | 1349 | 32 |
914004 | 914004 | 2021-01-10 | Russell | Alabama | 1113 | 3067 | 7 |
914005 | 914005 | 2021-01-10 | Shelby | Alabama | 1117 | 17562 | 106 |
914006 | 914006 | 2021-01-10 | St. Clair | Alabama | 1115 | 7213 | 115 |
914007 | 914007 | 2021-01-10 | Sumter | Alabama | 1119 | 889 | 26 |
914008 | 914008 | 2021-01-10 | Talladega | Alabama | 1121 | 5796 | 109 |
914009 | 914009 | 2021-01-10 | Tallapoosa | Alabama | 1123 | 2552 | 107 |
914010 | 914010 | 2021-01-10 | Tuscaloosa | Alabama | 1125 | 20142 | 267 |
914011 | 914011 | 2021-01-10 | Walker | Alabama | 1127 | 5734 | 170 |
914012 | 914012 | 2021-01-10 | Washington | Alabama | 1129 | 1320 | 26 |
914013 | 914013 | 2021-01-10 | Wilcox | Alabama | 1131 | 974 | 20 |
914014 | 914014 | 2021-01-10 | Winston | Alabama | 1133 | 2182 | 34 |
914015 | 914015 | 2021-01-10 | Aleutians East Borough | Alaska | 2013 | 38 | 0 |
914016 | 914016 | 2021-01-10 | Aleutians West Census Area | Alaska | 2016 | 223 | 0 |
914017 | 914017 | 2021-01-10 | Anchorage | Alaska | 2020 | 23980 | 124 |
914018 | 914018 | 2021-01-10 | Bethel Census Area | Alaska | 2050 | 2795 | 12 |
914019 | 914019 | 2021-01-10 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 159 | 0 |
914020 | 914020 | 2021-01-10 | Denali Borough | Alaska | 2068 | 60 | 0 |
914021 | 914021 | 2021-01-10 | Dillingham Census Area | Alaska | 2070 | 146 | 1 |
914022 | 914022 | 2021-01-10 | Fairbanks North Star Borough | Alaska | 2090 | 5328 | 21 |
914023 | 914023 | 2021-01-10 | Haines Borough | Alaska | 2100 | 20 | 0 |
914024 | 914024 | 2021-01-10 | Juneau City and Borough | Alaska | 2110 | 1050 | 3 |
914025 | 914025 | 2021-01-10 | Kenai Peninsula Borough | Alaska | 2122 | 3736 | 16 |
914026 | 914026 | 2021-01-10 | Ketchikan Gateway Borough | Alaska | 2130 | 254 | 1 |
914027 | 914027 | 2021-01-10 | Kodiak Island Borough | Alaska | 2150 | 967 | 2 |
914028 | 914028 | 2021-01-10 | Kusilvak Census Area | Alaska | 2158 | 921 | 3 |
914029 | 914029 | 2021-01-10 | Matanuska-Susitna Borough | Alaska | 2170 | 6880 | 18 |
914030 | 914030 | 2021-01-10 | Nome Census Area | Alaska | 2180 | 283 | 0 |
914031 | 914031 | 2021-01-10 | North Slope Borough | Alaska | 2185 | 862 | 3 |
914032 | 914032 | 2021-01-10 | Northwest Arctic Borough | Alaska | 2188 | 482 | 0 |
914033 | 914033 | 2021-01-10 | Petersburg Borough | Alaska | 2195 | 34 | 0 |
914034 | 914034 | 2021-01-10 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 69 | 1 |
914035 | 914035 | 2021-01-10 | Sitka City and Borough | Alaska | 2220 | 273 | 0 |
914036 | 914036 | 2021-01-10 | Skagway Municipality | Alaska | 2230 | 15 | 0 |
914037 | 914037 | 2021-01-10 | Southeast Fairbanks Census Area | Alaska | 2240 | 412 | 3 |
914038 | 914038 | 2021-01-10 | Unknown | Alaska | 253 | 0 | |
914039 | 914039 | 2021-01-10 | Valdez-Cordova Census Area | Alaska | 2261 | 376 | 2 |
914040 | 914040 | 2021-01-10 | Wrangell City and Borough | Alaska | 2275 | 24 | 0 |
914041 | 914041 | 2021-01-10 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 58 | 1 |
914042 | 914042 | 2021-01-10 | Yukon-Koyukuk Census Area | Alaska | 2290 | 237 | 4 |
914043 | 914043 | 2021-01-10 | Apache | Arizona | 4001 | 8244 | 259 |
914044 | 914044 | 2021-01-10 | Cochise | Arizona | 4003 | 8856 | 164 |
914045 | 914045 | 2021-01-10 | Coconino | Arizona | 4005 | 12836 | 233 |
914046 | 914046 | 2021-01-10 | Gila | Arizona | 4007 | 5060 | 155 |
914047 | 914047 | 2021-01-10 | Graham | Arizona | 4009 | 4045 | 56 |
914048 | 914048 | 2021-01-10 | Greenlee | Arizona | 4011 | 463 | 4 |
914049 | 914049 | 2021-01-10 | La Paz | Arizona | 4012 | 1860 | 39 |
914050 | 914050 | 2021-01-10 | Maricopa | Arizona | 4013 | 382409 | 5818 |
914051 | 914051 | 2021-01-10 | Mohave | Arizona | 4015 | 15346 | 390 |
914052 | 914052 | 2021-01-10 | Navajo | Arizona | 4017 | 12572 | 372 |
914053 | 914053 | 2021-01-10 | Pima | Arizona | 4019 | 82197 | 1263 |
914054 | 914054 | 2021-01-10 | Pinal | Arizona | 4021 | 33154 | 418 |
914055 | 914055 | 2021-01-10 | Santa Cruz | Arizona | 4023 | 6671 | 117 |
914056 | 914056 | 2021-01-10 | Yavapai | Arizona | 4025 | 13565 | 275 |
914057 | 914057 | 2021-01-10 | Yuma | Arizona | 4027 | 31268 | 578 |
914058 | 914058 | 2021-01-10 | Arkansas | Arkansas | 5001 | 1458 | 33 |
914059 | 914059 | 2021-01-10 | Ashley | Arkansas | 5003 | 1402 | 21 |
914060 | 914060 | 2021-01-10 | Baxter | Arkansas | 5005 | 2353 | 78 |
914061 | 914061 | 2021-01-10 | Benton | Arkansas | 5007 | 21521 | 295 |
914062 | 914062 | 2021-01-10 | Boone | Arkansas | 5009 | 2834 | 71 |
914063 | 914063 | 2021-01-10 | Bradley | Arkansas | 5011 | 1082 | 20 |
914064 | 914064 | 2021-01-10 | Calhoun | Arkansas | 5013 | 267 | 1 |
914065 | 914065 | 2021-01-10 | Carroll | Arkansas | 5015 | 2281 | 33 |
914066 | 914066 | 2021-01-10 | Chicot | Arkansas | 5017 | 1474 | 33 |
914067 | 914067 | 2021-01-10 | Clark | Arkansas | 5019 | 1523 | 26 |
914068 | 914068 | 2021-01-10 | Clay | Arkansas | 5021 | 1422 | 35 |
914069 | 914069 | 2021-01-10 | Cleburne | Arkansas | 5023 | 1507 | 42 |
914070 | 914070 | 2021-01-10 | Cleveland | Arkansas | 5025 | 628 | 21 |
914071 | 914071 | 2021-01-10 | Columbia | Arkansas | 5027 | 1702 | 45 |
914072 | 914072 | 2021-01-10 | Conway | Arkansas | 5029 | 1649 | 19 |
914073 | 914073 | 2021-01-10 | Craighead | Arkansas | 5031 | 10999 | 146 |
914074 | 914074 | 2021-01-10 | Crawford | Arkansas | 5033 | 5145 | 66 |
914075 | 914075 | 2021-01-10 | Crittenden | Arkansas | 5035 | 4730 | 78 |
914076 | 914076 | 2021-01-10 | Cross | Arkansas | 5037 | 1599 | 37 |
914077 | 914077 | 2021-01-10 | Dallas | Arkansas | 5039 | 546 | 12 |
914078 | 914078 | 2021-01-10 | Desha | Arkansas | 5041 | 1037 | 14 |
914079 | 914079 | 2021-01-10 | Drew | Arkansas | 5043 | 1609 | 23 |
914080 | 914080 | 2021-01-10 | Faulkner | Arkansas | 5045 | 8923 | 105 |
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);