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 56
- Texas 168,112
- Georgia 108,889
- Virginia 89,825
- Kentucky 80,572
- Missouri 77,900
- Illinois 69,202
- Kansas 68,758
- North Carolina 67,809
- Iowa 67,070
- Tennessee 65,119
- Indiana 62,686
- Ohio 60,201
- Nebraska 59,855
- Minnesota 59,083
- Michigan 56,802
- Mississippi 55,890
- Oklahoma 52,123
- Arkansas 51,432
- Puerto Rico 50,497
- Wisconsin 48,805
- Florida 46,562
- Pennsylvania 45,741
- Alabama 45,612
- Louisiana 44,402
- Colorado 43,127
- South Dakota 42,952
- California 39,892
- New York 39,892
- West Virginia 36,738
- North Dakota 35,099
- Montana 35,056
- South Carolina 31,491
- Idaho 28,784
- Washington 26,983
- Oregon 24,183
- New Mexico 22,087
- Utah 19,919
- Alaska 17,770
- Maryland 17,145
- Wyoming 15,538
- New Jersey 15,217
- Maine 11,398
- Nevada 11,107
- Arizona 10,419
- Massachusetts 10,414
- Vermont 10,258
- New Hampshire 7,512
- Connecticut 6,191
- Rhode Island 4,104
- Hawaii 3,382
- Delaware 2,731
- Virgin Islands 2,181
- Northern Mariana Islands 1,437
- District of Columbia 698
- Guam 690
- American Samoa 139
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2180663 | 2180663 | 2022-02-03 | Taylor | Wisconsin | 55119 | 4698 | 65 |
2180664 | 2180664 | 2022-02-03 | Trempealeau | Wisconsin | 55121 | 8064 | 58 |
2180665 | 2180665 | 2022-02-03 | Vernon | Wisconsin | 55123 | 5586 | 83 |
2180666 | 2180666 | 2022-02-03 | Vilas | Wisconsin | 55125 | 5010 | 83 |
2180667 | 2180667 | 2022-02-03 | Walworth | Wisconsin | 55127 | 25999 | 258 |
2180668 | 2180668 | 2022-02-03 | Washburn | Wisconsin | 55129 | 3803 | 39 |
2180669 | 2180669 | 2022-02-03 | Washington | Wisconsin | 55131 | 37044 | 279 |
2180670 | 2180670 | 2022-02-03 | Waukesha | Wisconsin | 55133 | 108698 | 939 |
2180671 | 2180671 | 2022-02-03 | Waupaca | Wisconsin | 55135 | 13180 | 236 |
2180672 | 2180672 | 2022-02-03 | Waushara | Wisconsin | 55137 | 6160 | 78 |
2180673 | 2180673 | 2022-02-03 | Winnebago | Wisconsin | 55139 | 49687 | 333 |
2180674 | 2180674 | 2022-02-03 | Wood | Wisconsin | 55141 | 19924 | 200 |
2180675 | 2180675 | 2022-02-03 | Albany | Wyoming | 56001 | 9499 | 45 |
2180676 | 2180676 | 2022-02-03 | Big Horn | Wyoming | 56003 | 2466 | 60 |
2180677 | 2180677 | 2022-02-03 | Campbell | Wyoming | 56005 | 11571 | 135 |
2180678 | 2180678 | 2022-02-03 | Carbon | Wyoming | 56007 | 4356 | 50 |
2180679 | 2180679 | 2022-02-03 | Converse | Wyoming | 56009 | 3013 | 49 |
2180680 | 2180680 | 2022-02-03 | Crook | Wyoming | 56011 | 1281 | 24 |
2180681 | 2180681 | 2022-02-03 | Fremont | Wyoming | 56013 | 12935 | 170 |
2180682 | 2180682 | 2022-02-03 | Goshen | Wyoming | 56015 | 3404 | 53 |
2180683 | 2180683 | 2022-02-03 | Hot Springs | Wyoming | 56017 | 1070 | 14 |
2180684 | 2180684 | 2022-02-03 | Johnson | Wyoming | 56019 | 1815 | 18 |
2180685 | 2180685 | 2022-02-03 | Laramie | Wyoming | 56021 | 24813 | 256 |
2180686 | 2180686 | 2022-02-03 | Lincoln | Wyoming | 56023 | 3805 | 28 |
2180687 | 2180687 | 2022-02-03 | Natrona | Wyoming | 56025 | 21413 | 255 |
2180688 | 2180688 | 2022-02-03 | Niobrara | Wyoming | 56027 | 617 | 9 |
2180689 | 2180689 | 2022-02-03 | Park | Wyoming | 56029 | 6503 | 129 |
2180690 | 2180690 | 2022-02-03 | Platte | Wyoming | 56031 | 1822 | 38 |
2180691 | 2180691 | 2022-02-03 | Sheridan | Wyoming | 56033 | 7760 | 65 |
2180692 | 2180692 | 2022-02-03 | Sublette | Wyoming | 56035 | 1854 | 25 |
2180693 | 2180693 | 2022-02-03 | Sweetwater | Wyoming | 56037 | 10514 | 119 |
2180694 | 2180694 | 2022-02-03 | Teton | Wyoming | 56039 | 9414 | 15 |
2180695 | 2180695 | 2022-02-03 | Uinta | Wyoming | 56041 | 5481 | 35 |
2180696 | 2180696 | 2022-02-03 | Washakie | Wyoming | 56043 | 2229 | 41 |
2180697 | 2180697 | 2022-02-03 | Weston | Wyoming | 56045 | 1491 | 17 |
2174194 | 2174194 | 2022-02-02 | Autauga | Alabama | 1001 | 14826 | 168 |
2174195 | 2174195 | 2022-02-02 | Baldwin | Alabama | 1003 | 53083 | 616 |
2174196 | 2174196 | 2022-02-02 | Barbour | Alabama | 1005 | 5297 | 85 |
2174197 | 2174197 | 2022-02-02 | Bibb | Alabama | 1007 | 6158 | 96 |
2174198 | 2174198 | 2022-02-02 | Blount | Alabama | 1009 | 14158 | 208 |
2174199 | 2174199 | 2022-02-02 | Bullock | Alabama | 1011 | 2245 | 48 |
2174200 | 2174200 | 2022-02-02 | Butler | Alabama | 1013 | 4830 | 109 |
2174201 | 2174201 | 2022-02-02 | Calhoun | Alabama | 1015 | 30342 | 558 |
2174202 | 2174202 | 2022-02-02 | Chambers | Alabama | 1017 | 8239 | 148 |
2174203 | 2174203 | 2022-02-02 | Cherokee | Alabama | 1019 | 4869 | 69 |
2174204 | 2174204 | 2022-02-02 | Chilton | Alabama | 1021 | 10040 | 183 |
2174205 | 2174205 | 2022-02-02 | Choctaw | Alabama | 1023 | 1784 | 33 |
2174206 | 2174206 | 2022-02-02 | Clarke | Alabama | 1025 | 6801 | 93 |
2174207 | 2174207 | 2022-02-02 | Clay | Alabama | 1027 | 3932 | 72 |
2174208 | 2174208 | 2022-02-02 | Cleburne | Alabama | 1029 | 3411 | 63 |
2174209 | 2174209 | 2022-02-02 | Coffee | Alabama | 1031 | 12905 | 208 |
2174210 | 2174210 | 2022-02-02 | Colbert | Alabama | 1033 | 15414 | 219 |
2174211 | 2174211 | 2022-02-02 | Conecuh | Alabama | 1035 | 2775 | 63 |
2174212 | 2174212 | 2022-02-02 | Coosa | Alabama | 1037 | 2800 | 53 |
2174213 | 2174213 | 2022-02-02 | Covington | Alabama | 1039 | 8977 | 205 |
2174214 | 2174214 | 2022-02-02 | Crenshaw | Alabama | 1041 | 3645 | 82 |
2174215 | 2174215 | 2022-02-02 | Cullman | Alabama | 1043 | 23337 | 325 |
2174216 | 2174216 | 2022-02-02 | Dale | Alabama | 1045 | 11924 | 207 |
2174217 | 2174217 | 2022-02-02 | Dallas | Alabama | 1047 | 7870 | 225 |
2174218 | 2174218 | 2022-02-02 | DeKalb | Alabama | 1049 | 17744 | 291 |
2174219 | 2174219 | 2022-02-02 | Elmore | Alabama | 1051 | 22220 | 311 |
2174220 | 2174220 | 2022-02-02 | Escambia | Alabama | 1053 | 9656 | 152 |
2174221 | 2174221 | 2022-02-02 | Etowah | Alabama | 1055 | 27358 | 548 |
2174222 | 2174222 | 2022-02-02 | Fayette | Alabama | 1057 | 4412 | 87 |
2174223 | 2174223 | 2022-02-02 | Franklin | Alabama | 1059 | 9270 | 120 |
2174224 | 2174224 | 2022-02-02 | Geneva | Alabama | 1061 | 5886 | 142 |
2174225 | 2174225 | 2022-02-02 | Greene | Alabama | 1063 | 1756 | 47 |
2174226 | 2174226 | 2022-02-02 | Hale | Alabama | 1065 | 4426 | 95 |
2174227 | 2174227 | 2022-02-02 | Henry | Alabama | 1067 | 4256 | 67 |
2174228 | 2174228 | 2022-02-02 | Houston | Alabama | 1069 | 23861 | 451 |
2174229 | 2174229 | 2022-02-02 | Jackson | Alabama | 1071 | 14184 | 211 |
2174230 | 2174230 | 2022-02-02 | Jefferson | Alabama | 1073 | 176555 | 2089 |
2174231 | 2174231 | 2022-02-02 | Lamar | Alabama | 1075 | 3430 | 61 |
2174232 | 2174232 | 2022-02-02 | Lauderdale | Alabama | 1077 | 22783 | 338 |
2174233 | 2174233 | 2022-02-02 | Lawrence | Alabama | 1079 | 7158 | 144 |
2174234 | 2174234 | 2022-02-02 | Lee | Alabama | 1081 | 36514 | 288 |
2174235 | 2174235 | 2022-02-02 | Limestone | Alabama | 1083 | 23540 | 243 |
2174236 | 2174236 | 2022-02-02 | Lowndes | Alabama | 1085 | 2529 | 68 |
2174237 | 2174237 | 2022-02-02 | Macon | Alabama | 1087 | 3704 | 71 |
2174238 | 2174238 | 2022-02-02 | Madison | Alabama | 1089 | 83501 | 821 |
2174239 | 2174239 | 2022-02-02 | Marengo | Alabama | 1091 | 4563 | 96 |
2174240 | 2174240 | 2022-02-02 | Marion | Alabama | 1093 | 7634 | 138 |
2174241 | 2174241 | 2022-02-02 | Marshall | Alabama | 1095 | 26135 | 345 |
2174242 | 2174242 | 2022-02-02 | Mobile | Alabama | 1097 | 108108 | 1468 |
2174243 | 2174243 | 2022-02-02 | Monroe | Alabama | 1099 | 5064 | 70 |
2174244 | 2174244 | 2022-02-02 | Montgomery | Alabama | 1101 | 52692 | 815 |
2174245 | 2174245 | 2022-02-02 | Morgan | Alabama | 1103 | 34153 | 452 |
2174246 | 2174246 | 2022-02-02 | Perry | Alabama | 1105 | 1961 | 40 |
2174247 | 2174247 | 2022-02-02 | Pickens | Alabama | 1107 | 4881 | 93 |
2174248 | 2174248 | 2022-02-02 | Pike | Alabama | 1109 | 7099 | 118 |
2174249 | 2174249 | 2022-02-02 | Randolph | Alabama | 1111 | 4865 | 70 |
2174250 | 2174250 | 2022-02-02 | Russell | Alabama | 1113 | 9549 | 71 |
2174251 | 2174251 | 2022-02-02 | Shelby | Alabama | 1117 | 56816 | 402 |
2174252 | 2174252 | 2022-02-02 | St. Clair | Alabama | 1115 | 24128 | 379 |
2174253 | 2174253 | 2022-02-02 | Sumter | Alabama | 1119 | 2281 | 43 |
2174254 | 2174254 | 2022-02-02 | Talladega | Alabama | 1121 | 21051 | 325 |
2174255 | 2174255 | 2022-02-02 | Tallapoosa | Alabama | 1123 | 10934 | 213 |
2174256 | 2174256 | 2022-02-02 | Tuscaloosa | Alabama | 1125 | 52074 | 691 |
2174257 | 2174257 | 2022-02-02 | Walker | Alabama | 1127 | 17677 | 398 |
2174258 | 2174258 | 2022-02-02 | Washington | Alabama | 1129 | 3462 | 53 |
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);