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 193,519
- Georgia 124,729
- Virginia 103,128
- Kentucky 92,472
- Missouri 89,600
- Illinois 79,399
- Kansas 79,188
- North Carolina 77,809
- Iowa 76,970
- Tennessee 74,719
- Indiana 71,828
- Nebraska 69,255
- Ohio 69,101
- Minnesota 67,883
- Michigan 65,202
- Mississippi 64,147
- Oklahoma 59,923
- Arkansas 58,956
- Puerto Rico 58,397
- Wisconsin 55,993
- Florida 53,294
- Pennsylvania 52,441
- Alabama 52,245
- Louisiana 50,902
- South Dakota 49,552
- Colorado 49,463
- New York 45,692
- California 45,635
- West Virginia 42,238
- Montana 40,656
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500679 | 2500679 | 2022-05-13 | Robertson | Kentucky | 21201 | 672 | 21 |
2500680 | 2500680 | 2022-05-13 | Rockcastle | Kentucky | 21203 | 5059 | 59 |
2500681 | 2500681 | 2022-05-13 | Rowan | Kentucky | 21205 | 6739 | 69 |
2500682 | 2500682 | 2022-05-13 | Russell | Kentucky | 21207 | 6446 | 87 |
2500683 | 2500683 | 2022-05-13 | Scott | Kentucky | 21209 | 17723 | 109 |
2500684 | 2500684 | 2022-05-13 | Shelby | Kentucky | 21211 | 13410 | 162 |
2500685 | 2500685 | 2022-05-13 | Simpson | Kentucky | 21213 | 5635 | 94 |
2500686 | 2500686 | 2022-05-13 | Spencer | Kentucky | 21215 | 5384 | 59 |
2500687 | 2500687 | 2022-05-13 | Taylor | Kentucky | 21217 | 9492 | 124 |
2500688 | 2500688 | 2022-05-13 | Todd | Kentucky | 21219 | 2982 | 43 |
2500689 | 2500689 | 2022-05-13 | Trigg | Kentucky | 21221 | 4016 | 44 |
2500690 | 2500690 | 2022-05-13 | Trimble | Kentucky | 21223 | 2217 | 40 |
2500691 | 2500691 | 2022-05-13 | Union | Kentucky | 21225 | 4341 | 57 |
2500692 | 2500692 | 2022-05-13 | Warren | Kentucky | 21227 | 43102 | 372 |
2500693 | 2500693 | 2022-05-13 | Washington | Kentucky | 21229 | 3967 | 61 |
2500694 | 2500694 | 2022-05-13 | Wayne | Kentucky | 21231 | 6107 | 92 |
2500695 | 2500695 | 2022-05-13 | Webster | Kentucky | 21233 | 3914 | 49 |
2500696 | 2500696 | 2022-05-13 | Whitley | Kentucky | 21235 | 14412 | 199 |
2500697 | 2500697 | 2022-05-13 | Wolfe | Kentucky | 21237 | 2531 | 28 |
2500698 | 2500698 | 2022-05-13 | Woodford | Kentucky | 21239 | 6978 | 49 |
2500699 | 2500699 | 2022-05-13 | Acadia | Louisiana | 22001 | 15906 | 294 |
2500700 | 2500700 | 2022-05-13 | Allen | Louisiana | 22003 | 7880 | 141 |
2500701 | 2500701 | 2022-05-13 | Ascension | Louisiana | 22005 | 35030 | 293 |
2500702 | 2500702 | 2022-05-13 | Assumption | Louisiana | 22007 | 5575 | 70 |
2500703 | 2500703 | 2022-05-13 | Avoyelles | Louisiana | 22009 | 11600 | 208 |
2500704 | 2500704 | 2022-05-13 | Beauregard | Louisiana | 22011 | 9271 | 143 |
2500705 | 2500705 | 2022-05-13 | Bienville | Louisiana | 22013 | 3992 | 110 |
2500706 | 2500706 | 2022-05-13 | Bossier | Louisiana | 22015 | 37689 | 494 |
2500707 | 2500707 | 2022-05-13 | Caddo | Louisiana | 22017 | 67560 | 1156 |
2500708 | 2500708 | 2022-05-13 | Calcasieu | Louisiana | 22019 | 54862 | 706 |
2500709 | 2500709 | 2022-05-13 | Caldwell | Louisiana | 22021 | 3625 | 55 |
2500710 | 2500710 | 2022-05-13 | Cameron | Louisiana | 22023 | 1199 | 8 |
2500711 | 2500711 | 2022-05-13 | Catahoula | Louisiana | 22025 | 2700 | 55 |
2500712 | 2500712 | 2022-05-13 | Claiborne | Louisiana | 22027 | 3280 | 78 |
2500713 | 2500713 | 2022-05-13 | Concordia | Louisiana | 22029 | 5103 | 89 |
2500714 | 2500714 | 2022-05-13 | De Soto | Louisiana | 22031 | 7362 | 135 |
2500715 | 2500715 | 2022-05-13 | East Baton Rouge | Louisiana | 22033 | 111670 | 1349 |
2500716 | 2500716 | 2022-05-13 | East Carroll | Louisiana | 22035 | 2538 | 38 |
2500717 | 2500717 | 2022-05-13 | East Feliciana | Louisiana | 22037 | 7324 | 170 |
2500718 | 2500718 | 2022-05-13 | Evangeline | Louisiana | 22039 | 8398 | 159 |
2500719 | 2500719 | 2022-05-13 | Franklin | Louisiana | 22041 | 7352 | 178 |
2500720 | 2500720 | 2022-05-13 | Grant | Louisiana | 22043 | 5861 | 94 |
2500721 | 2500721 | 2022-05-13 | Iberia | Louisiana | 22045 | 19149 | 263 |
2500722 | 2500722 | 2022-05-13 | Iberville | Louisiana | 22047 | 9023 | 153 |
2500723 | 2500723 | 2022-05-13 | Jackson | Louisiana | 22049 | 4409 | 76 |
2500724 | 2500724 | 2022-05-13 | Jefferson | Louisiana | 22051 | 115373 | 1341 |
2500725 | 2500725 | 2022-05-13 | Jefferson Davis | Louisiana | 22053 | 6942 | 157 |
2500726 | 2500726 | 2022-05-13 | LaSalle | Louisiana | 22059 | 4275 | 61 |
2500727 | 2500727 | 2022-05-13 | Lafayette | Louisiana | 22055 | 62873 | 500 |
2500728 | 2500728 | 2022-05-13 | Lafourche | Louisiana | 22057 | 27889 | 372 |
2500729 | 2500729 | 2022-05-13 | Lincoln | Louisiana | 22061 | 12269 | 144 |
2500730 | 2500730 | 2022-05-13 | Livingston | Louisiana | 22063 | 37238 | 466 |
2500731 | 2500731 | 2022-05-13 | Madison | Louisiana | 22065 | 3264 | 59 |
2500732 | 2500732 | 2022-05-13 | Morehouse | Louisiana | 22067 | 6871 | 134 |
2500733 | 2500733 | 2022-05-13 | Natchitoches | Louisiana | 22069 | 10162 | 167 |
2500734 | 2500734 | 2022-05-13 | Orleans | Louisiana | 22071 | 90328 | 1109 |
2500735 | 2500735 | 2022-05-13 | Ouachita | Louisiana | 22073 | 50769 | 754 |
2500736 | 2500736 | 2022-05-13 | Plaquemines | Louisiana | 22075 | 6509 | 45 |
2500737 | 2500737 | 2022-05-13 | Pointe Coupee | Louisiana | 22077 | 6297 | 94 |
2500738 | 2500738 | 2022-05-13 | Rapides | Louisiana | 22079 | 32791 | 577 |
2500739 | 2500739 | 2022-05-13 | Red River | Louisiana | 22081 | 2112 | 53 |
2500740 | 2500740 | 2022-05-13 | Richland | Louisiana | 22083 | 6732 | 97 |
2500741 | 2500741 | 2022-05-13 | Sabine | Louisiana | 22085 | 6343 | 113 |
2500742 | 2500742 | 2022-05-13 | St. Bernard | Louisiana | 22087 | 11439 | 111 |
2500743 | 2500743 | 2022-05-13 | St. Charles | Louisiana | 22089 | 13920 | 145 |
2500744 | 2500744 | 2022-05-13 | St. Helena | Louisiana | 22091 | 1920 | 23 |
2500745 | 2500745 | 2022-05-13 | St. James | Louisiana | 22093 | 5805 | 77 |
2500746 | 2500746 | 2022-05-13 | St. John the Baptist | Louisiana | 22095 | 10628 | 184 |
2500747 | 2500747 | 2022-05-13 | St. Landry | Louisiana | 22097 | 22279 | 416 |
2500748 | 2500748 | 2022-05-13 | St. Martin | Louisiana | 22099 | 12985 | 188 |
2500749 | 2500749 | 2022-05-13 | St. Mary | Louisiana | 22101 | 12526 | 262 |
2500750 | 2500750 | 2022-05-13 | St. Tammany | Louisiana | 22103 | 73066 | 851 |
2500751 | 2500751 | 2022-05-13 | Tangipahoa | Louisiana | 22105 | 34885 | 599 |
2500752 | 2500752 | 2022-05-13 | Tensas | Louisiana | 22107 | 988 | 11 |
2500753 | 2500753 | 2022-05-13 | Terrebonne | Louisiana | 22109 | 31012 | 419 |
2500754 | 2500754 | 2022-05-13 | Union | Louisiana | 22111 | 6928 | 135 |
2500755 | 2500755 | 2022-05-13 | Unknown | Louisiana | 984 | 0 | |
2500756 | 2500756 | 2022-05-13 | Vermilion | Louisiana | 22113 | 15334 | 224 |
2500757 | 2500757 | 2022-05-13 | Vernon | Louisiana | 22115 | 9939 | 191 |
2500758 | 2500758 | 2022-05-13 | Washington | Louisiana | 22117 | 12994 | 249 |
2500759 | 2500759 | 2022-05-13 | Webster | Louisiana | 22119 | 11145 | 186 |
2500760 | 2500760 | 2022-05-13 | West Baton Rouge | Louisiana | 22121 | 7335 | 90 |
2500761 | 2500761 | 2022-05-13 | West Carroll | Louisiana | 22123 | 3629 | 66 |
2500762 | 2500762 | 2022-05-13 | West Feliciana | Louisiana | 22125 | 2835 | 46 |
2500763 | 2500763 | 2022-05-13 | Winn | Louisiana | 22127 | 4452 | 64 |
2500764 | 2500764 | 2022-05-13 | Androscoggin | Maine | 23001 | 23257 | 285 |
2500765 | 2500765 | 2022-05-13 | Aroostook | Maine | 23003 | 14393 | 166 |
2500766 | 2500766 | 2022-05-13 | Cumberland | Maine | 23005 | 52557 | 366 |
2500767 | 2500767 | 2022-05-13 | Franklin | Maine | 23007 | 6014 | 60 |
2500768 | 2500768 | 2022-05-13 | Hancock | Maine | 23009 | 7983 | 87 |
2500769 | 2500769 | 2022-05-13 | Kennebec | Maine | 23011 | 24799 | 240 |
2500770 | 2500770 | 2022-05-13 | Knox | Maine | 23013 | 6414 | 38 |
2500771 | 2500771 | 2022-05-13 | Lincoln | Maine | 23015 | 5578 | 35 |
2500772 | 2500772 | 2022-05-13 | Oxford | Maine | 23017 | 11799 | 148 |
2500773 | 2500773 | 2022-05-13 | Penobscot | Maine | 23019 | 29710 | 331 |
2500774 | 2500774 | 2022-05-13 | Piscataquis | Maine | 23021 | 3112 | 31 |
2500775 | 2500775 | 2022-05-13 | Sagadahoc | Maine | 23023 | 5531 | 32 |
2500776 | 2500776 | 2022-05-13 | Somerset | Maine | 23025 | 10213 | 110 |
2500777 | 2500777 | 2022-05-13 | Unknown | Maine | 42 | 0 | |
2500778 | 2500778 | 2022-05-13 | Waldo | Maine | 23027 | 6467 | 58 |
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);