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 70,812
- Georgia 47,609
- Virginia 38,881
- Kentucky 34,612
- Missouri 33,088
- Illinois 29,767
- North Carolina 29,508
- Iowa 28,770
- Kansas 28,451
- Tennessee 28,351
- Indiana 27,450
- Ohio 26,162
- Minnesota 25,379
- Michigan 24,630
- Mississippi 24,484
- Nebraska 23,978
- Arkansas 22,324
- Oklahoma 22,250
- Wisconsin 21,217
- Florida 20,518
- Puerto Rico 20,240
- Pennsylvania 20,080
- Alabama 19,951
- Louisiana 19,508
- Colorado 18,615
- New York 17,678
- South Dakota 17,674
- California 17,671
- West Virginia 15,671
- North Dakota 14,417
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
936639 | 936639 | 2021-01-16 | Winnebago | Wisconsin | 55139 | 18277 | 183 |
936640 | 936640 | 2021-01-16 | Wood | Wisconsin | 55141 | 6473 | 74 |
936641 | 936641 | 2021-01-16 | Albany | Wyoming | 56001 | 3652 | 10 |
936642 | 936642 | 2021-01-16 | Big Horn | Wyoming | 56003 | 915 | 22 |
936643 | 936643 | 2021-01-16 | Campbell | Wyoming | 56005 | 4458 | 45 |
936644 | 936644 | 2021-01-16 | Carbon | Wyoming | 56007 | 1088 | 16 |
936645 | 936645 | 2021-01-16 | Converse | Wyoming | 56009 | 885 | 13 |
936646 | 936646 | 2021-01-16 | Crook | Wyoming | 56011 | 399 | 9 |
936647 | 936647 | 2021-01-16 | Fremont | Wyoming | 56013 | 4239 | 71 |
936648 | 936648 | 2021-01-16 | Goshen | Wyoming | 56015 | 1076 | 19 |
936649 | 936649 | 2021-01-16 | Hot Springs | Wyoming | 56017 | 315 | 2 |
936650 | 936650 | 2021-01-16 | Johnson | Wyoming | 56019 | 582 | 9 |
936651 | 936651 | 2021-01-16 | Laramie | Wyoming | 56021 | 7728 | 75 |
936652 | 936652 | 2021-01-16 | Lincoln | Wyoming | 56023 | 1052 | 11 |
936653 | 936653 | 2021-01-16 | Natrona | Wyoming | 56025 | 7071 | 103 |
936654 | 936654 | 2021-01-16 | Niobrara | Wyoming | 56027 | 145 | 2 |
936655 | 936655 | 2021-01-16 | Park | Wyoming | 56029 | 2400 | 16 |
936656 | 936656 | 2021-01-16 | Platte | Wyoming | 56031 | 516 | 9 |
936657 | 936657 | 2021-01-16 | Sheridan | Wyoming | 56033 | 2763 | 17 |
936658 | 936658 | 2021-01-16 | Sublette | Wyoming | 56035 | 634 | 7 |
936659 | 936659 | 2021-01-16 | Sweetwater | Wyoming | 56037 | 3280 | 26 |
936660 | 936660 | 2021-01-16 | Teton | Wyoming | 56039 | 2614 | 4 |
936661 | 936661 | 2021-01-16 | Uinta | Wyoming | 56041 | 1813 | 9 |
936662 | 936662 | 2021-01-16 | Washakie | Wyoming | 56043 | 841 | 23 |
936663 | 936663 | 2021-01-16 | Weston | Wyoming | 56045 | 602 | 4 |
930174 | 930174 | 2021-01-15 | Autauga | Alabama | 1001 | 5103 | 55 |
930175 | 930175 | 2021-01-15 | Baldwin | Alabama | 1003 | 16002 | 179 |
930176 | 930176 | 2021-01-15 | Barbour | Alabama | 1005 | 1712 | 36 |
930177 | 930177 | 2021-01-15 | Bibb | Alabama | 1007 | 2130 | 47 |
930178 | 930178 | 2021-01-15 | Blount | Alabama | 1009 | 5264 | 83 |
930179 | 930179 | 2021-01-15 | Bullock | Alabama | 1011 | 981 | 28 |
930180 | 930180 | 2021-01-15 | Butler | Alabama | 1013 | 1679 | 58 |
930181 | 930181 | 2021-01-15 | Calhoun | Alabama | 1015 | 10982 | 200 |
930182 | 930182 | 2021-01-15 | Chambers | Alabama | 1017 | 2778 | 69 |
930183 | 930183 | 2021-01-15 | Cherokee | Alabama | 1019 | 1596 | 30 |
930184 | 930184 | 2021-01-15 | Chilton | Alabama | 1021 | 3335 | 65 |
930185 | 930185 | 2021-01-15 | Choctaw | Alabama | 1023 | 512 | 24 |
930186 | 930186 | 2021-01-15 | Clarke | Alabama | 1025 | 2782 | 33 |
930187 | 930187 | 2021-01-15 | Clay | Alabama | 1027 | 1252 | 46 |
930188 | 930188 | 2021-01-15 | Cleburne | Alabama | 1029 | 1160 | 23 |
930189 | 930189 | 2021-01-15 | Coffee | Alabama | 1031 | 4342 | 56 |
930190 | 930190 | 2021-01-15 | Colbert | Alabama | 1033 | 5256 | 70 |
930191 | 930191 | 2021-01-15 | Conecuh | Alabama | 1035 | 929 | 20 |
930192 | 930192 | 2021-01-15 | Coosa | Alabama | 1037 | 604 | 14 |
930193 | 930193 | 2021-01-15 | Covington | Alabama | 1039 | 3261 | 67 |
930194 | 930194 | 2021-01-15 | Crenshaw | Alabama | 1041 | 1180 | 44 |
930195 | 930195 | 2021-01-15 | Cullman | Alabama | 1043 | 7960 | 104 |
930196 | 930196 | 2021-01-15 | Dale | Alabama | 1045 | 3910 | 81 |
930197 | 930197 | 2021-01-15 | Dallas | Alabama | 1047 | 3002 | 96 |
930198 | 930198 | 2021-01-15 | DeKalb | Alabama | 1049 | 7646 | 97 |
930199 | 930199 | 2021-01-15 | Elmore | Alabama | 1051 | 7723 | 101 |
930200 | 930200 | 2021-01-15 | Escambia | Alabama | 1053 | 3124 | 42 |
930201 | 930201 | 2021-01-15 | Etowah | Alabama | 1055 | 11604 | 157 |
930202 | 930202 | 2021-01-15 | Fayette | Alabama | 1057 | 1660 | 26 |
930203 | 930203 | 2021-01-15 | Franklin | Alabama | 1059 | 3634 | 45 |
930204 | 930204 | 2021-01-15 | Geneva | Alabama | 1061 | 1974 | 31 |
930205 | 930205 | 2021-01-15 | Greene | Alabama | 1063 | 753 | 23 |
930206 | 930206 | 2021-01-15 | Hale | Alabama | 1065 | 1737 | 42 |
930207 | 930207 | 2021-01-15 | Henry | Alabama | 1067 | 1511 | 19 |
930208 | 930208 | 2021-01-15 | Houston | Alabama | 1069 | 8474 | 129 |
930209 | 930209 | 2021-01-15 | Jackson | Alabama | 1071 | 5744 | 41 |
930210 | 930210 | 2021-01-15 | Jefferson | Alabama | 1073 | 61313 | 888 |
930211 | 930211 | 2021-01-15 | Lamar | Alabama | 1075 | 1166 | 19 |
930212 | 930212 | 2021-01-15 | Lauderdale | Alabama | 1077 | 7451 | 83 |
930213 | 930213 | 2021-01-15 | Lawrence | Alabama | 1079 | 2404 | 47 |
930214 | 930214 | 2021-01-15 | Lee | Alabama | 1081 | 12261 | 101 |
930215 | 930215 | 2021-01-15 | Limestone | Alabama | 1083 | 7901 | 74 |
930216 | 930216 | 2021-01-15 | Lowndes | Alabama | 1085 | 1087 | 35 |
930217 | 930217 | 2021-01-15 | Macon | Alabama | 1087 | 1133 | 35 |
930218 | 930218 | 2021-01-15 | Madison | Alabama | 1089 | 26637 | 185 |
930219 | 930219 | 2021-01-15 | Marengo | Alabama | 1091 | 1973 | 29 |
930220 | 930220 | 2021-01-15 | Marion | Alabama | 1093 | 2405 | 49 |
930221 | 930221 | 2021-01-15 | Marshall | Alabama | 1095 | 10108 | 107 |
930222 | 930222 | 2021-01-15 | Mobile | Alabama | 1097 | 29768 | 542 |
930223 | 930223 | 2021-01-15 | Monroe | Alabama | 1099 | 1444 | 17 |
930224 | 930224 | 2021-01-15 | Montgomery | Alabama | 1101 | 18696 | 304 |
930225 | 930225 | 2021-01-15 | Morgan | Alabama | 1103 | 12093 | 112 |
930226 | 930226 | 2021-01-15 | Perry | Alabama | 1105 | 954 | 19 |
930227 | 930227 | 2021-01-15 | Pickens | Alabama | 1107 | 1952 | 31 |
930228 | 930228 | 2021-01-15 | Pike | Alabama | 1109 | 2458 | 29 |
930229 | 930229 | 2021-01-15 | Randolph | Alabama | 1111 | 1385 | 35 |
930230 | 930230 | 2021-01-15 | Russell | Alabama | 1113 | 3238 | 10 |
930231 | 930231 | 2021-01-15 | Shelby | Alabama | 1117 | 18310 | 113 |
930232 | 930232 | 2021-01-15 | St. Clair | Alabama | 1115 | 7460 | 120 |
930233 | 930233 | 2021-01-15 | Sumter | Alabama | 1119 | 887 | 26 |
930234 | 930234 | 2021-01-15 | Talladega | Alabama | 1121 | 6102 | 108 |
930235 | 930235 | 2021-01-15 | Tallapoosa | Alabama | 1123 | 2599 | 107 |
930236 | 930236 | 2021-01-15 | Tuscaloosa | Alabama | 1125 | 20580 | 268 |
930237 | 930237 | 2021-01-15 | Walker | Alabama | 1127 | 5852 | 174 |
930238 | 930238 | 2021-01-15 | Washington | Alabama | 1129 | 1365 | 26 |
930239 | 930239 | 2021-01-15 | Wilcox | Alabama | 1131 | 1012 | 21 |
930240 | 930240 | 2021-01-15 | Winston | Alabama | 1133 | 2238 | 35 |
930241 | 930241 | 2021-01-15 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
930242 | 930242 | 2021-01-15 | Aleutians West Census Area | Alaska | 2016 | 241 | 0 |
930243 | 930243 | 2021-01-15 | Anchorage | Alaska | 2020 | 24408 | 127 |
930244 | 930244 | 2021-01-15 | Bethel Census Area | Alaska | 2050 | 2909 | 12 |
930245 | 930245 | 2021-01-15 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 161 | 0 |
930246 | 930246 | 2021-01-15 | Denali Borough | Alaska | 2068 | 62 | 0 |
930247 | 930247 | 2021-01-15 | Dillingham Census Area | Alaska | 2070 | 149 | 1 |
930248 | 930248 | 2021-01-15 | Fairbanks North Star Borough | Alaska | 2090 | 5538 | 23 |
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);