ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,245 rows where date = "2020-10-19" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 253
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 106
- Illinois 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Nebraska 94
- Indiana 92
- Minnesota 88
- Ohio 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
- Washington 31
- Unknown 27
- 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 |
---|---|---|---|---|---|---|---|
644625 | 644625 | 2020-10-19 | Autauga | Alabama | 1001 | 1999 | 28 |
644626 | 644626 | 2020-10-19 | Baldwin | Alabama | 1003 | 6375 | 67 |
644627 | 644627 | 2020-10-19 | Barbour | Alabama | 1005 | 981 | 9 |
644628 | 644628 | 2020-10-19 | Bibb | Alabama | 1007 | 789 | 13 |
644629 | 644629 | 2020-10-19 | Blount | Alabama | 1009 | 1838 | 23 |
644630 | 644630 | 2020-10-19 | Bullock | Alabama | 1011 | 635 | 17 |
644631 | 644631 | 2020-10-19 | Butler | Alabama | 1013 | 998 | 40 |
644632 | 644632 | 2020-10-19 | Calhoun | Alabama | 1015 | 4102 | 59 |
644633 | 644633 | 2020-10-19 | Chambers | Alabama | 1017 | 1273 | 43 |
644634 | 644634 | 2020-10-19 | Cherokee | Alabama | 1019 | 715 | 14 |
644635 | 644635 | 2020-10-19 | Chilton | Alabama | 1021 | 1805 | 31 |
644636 | 644636 | 2020-10-19 | Choctaw | Alabama | 1023 | 386 | 12 |
644637 | 644637 | 2020-10-19 | Clarke | Alabama | 1025 | 1267 | 16 |
644638 | 644638 | 2020-10-19 | Clay | Alabama | 1027 | 707 | 12 |
644639 | 644639 | 2020-10-19 | Cleburne | Alabama | 1029 | 524 | 7 |
644640 | 644640 | 2020-10-19 | Coffee | Alabama | 1031 | 1640 | 9 |
644641 | 644641 | 2020-10-19 | Colbert | Alabama | 1033 | 1906 | 27 |
644642 | 644642 | 2020-10-19 | Conecuh | Alabama | 1035 | 554 | 13 |
644643 | 644643 | 2020-10-19 | Coosa | Alabama | 1037 | 196 | 3 |
644644 | 644644 | 2020-10-19 | Covington | Alabama | 1039 | 1647 | 29 |
644645 | 644645 | 2020-10-19 | Crenshaw | Alabama | 1041 | 590 | 30 |
644646 | 644646 | 2020-10-19 | Cullman | Alabama | 1043 | 2258 | 23 |
644647 | 644647 | 2020-10-19 | Dale | Alabama | 1045 | 1625 | 51 |
644648 | 644648 | 2020-10-19 | Dallas | Alabama | 1047 | 1852 | 27 |
644649 | 644649 | 2020-10-19 | DeKalb | Alabama | 1049 | 3167 | 27 |
644650 | 644650 | 2020-10-19 | Elmore | Alabama | 1051 | 3095 | 52 |
644651 | 644651 | 2020-10-19 | Escambia | Alabama | 1053 | 1709 | 28 |
644652 | 644652 | 2020-10-19 | Etowah | Alabama | 1055 | 4020 | 49 |
644653 | 644653 | 2020-10-19 | Fayette | Alabama | 1057 | 547 | 12 |
644654 | 644654 | 2020-10-19 | Franklin | Alabama | 1059 | 1991 | 31 |
644655 | 644655 | 2020-10-19 | Geneva | Alabama | 1061 | 833 | 7 |
644656 | 644656 | 2020-10-19 | Greene | Alabama | 1063 | 333 | 16 |
644657 | 644657 | 2020-10-19 | Hale | Alabama | 1065 | 745 | 29 |
644658 | 644658 | 2020-10-19 | Henry | Alabama | 1067 | 631 | 6 |
644659 | 644659 | 2020-10-19 | Houston | Alabama | 1069 | 3631 | 32 |
644660 | 644660 | 2020-10-19 | Jackson | Alabama | 1071 | 1991 | 14 |
644661 | 644661 | 2020-10-19 | Jefferson | Alabama | 1073 | 22400 | 372 |
644662 | 644662 | 2020-10-19 | Lamar | Alabama | 1075 | 457 | 5 |
644663 | 644663 | 2020-10-19 | Lauderdale | Alabama | 1077 | 2063 | 40 |
644664 | 644664 | 2020-10-19 | Lawrence | Alabama | 1079 | 792 | 30 |
644665 | 644665 | 2020-10-19 | Lee | Alabama | 1081 | 6439 | 66 |
644666 | 644666 | 2020-10-19 | Limestone | Alabama | 1083 | 2692 | 27 |
644667 | 644667 | 2020-10-19 | Lowndes | Alabama | 1085 | 699 | 27 |
644668 | 644668 | 2020-10-19 | Macon | Alabama | 1087 | 529 | 19 |
644669 | 644669 | 2020-10-19 | Madison | Alabama | 1089 | 8999 | 92 |
644670 | 644670 | 2020-10-19 | Marengo | Alabama | 1091 | 967 | 21 |
644671 | 644671 | 2020-10-19 | Marion | Alabama | 1093 | 1042 | 29 |
644672 | 644672 | 2020-10-19 | Marshall | Alabama | 1095 | 4267 | 48 |
644673 | 644673 | 2020-10-19 | Mobile | Alabama | 1097 | 14282 | 314 |
644674 | 644674 | 2020-10-19 | Monroe | Alabama | 1099 | 627 | 9 |
644675 | 644675 | 2020-10-19 | Montgomery | Alabama | 1101 | 9691 | 196 |
644676 | 644676 | 2020-10-19 | Morgan | Alabama | 1103 | 3945 | 32 |
644677 | 644677 | 2020-10-19 | Perry | Alabama | 1105 | 579 | 6 |
644678 | 644678 | 2020-10-19 | Pickens | Alabama | 1107 | 803 | 17 |
644679 | 644679 | 2020-10-19 | Pike | Alabama | 1109 | 1302 | 12 |
644680 | 644680 | 2020-10-19 | Randolph | Alabama | 1111 | 795 | 14 |
644681 | 644681 | 2020-10-19 | Russell | Alabama | 1113 | 1902 | 3 |
644682 | 644682 | 2020-10-19 | Shelby | Alabama | 1117 | 7035 | 60 |
644683 | 644683 | 2020-10-19 | St. Clair | Alabama | 1115 | 2797 | 42 |
644684 | 644684 | 2020-10-19 | Sumter | Alabama | 1119 | 464 | 21 |
644685 | 644685 | 2020-10-19 | Talladega | Alabama | 1121 | 2550 | 34 |
644686 | 644686 | 2020-10-19 | Tallapoosa | Alabama | 1123 | 1272 | 86 |
644687 | 644687 | 2020-10-19 | Tuscaloosa | Alabama | 1125 | 9983 | 132 |
644688 | 644688 | 2020-10-19 | Walker | Alabama | 1127 | 2680 | 92 |
644689 | 644689 | 2020-10-19 | Washington | Alabama | 1129 | 621 | 12 |
644690 | 644690 | 2020-10-19 | Wilcox | Alabama | 1131 | 557 | 12 |
644691 | 644691 | 2020-10-19 | Winston | Alabama | 1133 | 899 | 13 |
644692 | 644692 | 2020-10-19 | Aleutians East Borough | Alaska | 2013 | 15 | 0 |
644693 | 644693 | 2020-10-19 | Aleutians West Census Area | Alaska | 2016 | 98 | 0 |
644694 | 644694 | 2020-10-19 | Anchorage | Alaska | 2020 | 6382 | 41 |
644695 | 644695 | 2020-10-19 | Bethel Census Area | Alaska | 2050 | 263 | 0 |
644696 | 644696 | 2020-10-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 100 | 0 |
644697 | 644697 | 2020-10-19 | Denali Borough | Alaska | 2068 | 21 | 0 |
644698 | 644698 | 2020-10-19 | Dillingham Census Area | Alaska | 2070 | 44 | 0 |
644699 | 644699 | 2020-10-19 | Fairbanks North Star Borough | Alaska | 2090 | 1859 | 13 |
644700 | 644700 | 2020-10-19 | Haines Borough | Alaska | 2100 | 12 | 0 |
644701 | 644701 | 2020-10-19 | Juneau City and Borough | Alaska | 2110 | 450 | 2 |
644702 | 644702 | 2020-10-19 | Kenai Peninsula Borough | Alaska | 2122 | 753 | 1 |
644703 | 644703 | 2020-10-19 | Ketchikan Gateway Borough | Alaska | 2130 | 77 | 0 |
644704 | 644704 | 2020-10-19 | Kodiak Island Borough | Alaska | 2150 | 91 | 0 |
644705 | 644705 | 2020-10-19 | Kusilvak Census Area | Alaska | 2158 | 28 | 0 |
644706 | 644706 | 2020-10-19 | Matanuska-Susitna Borough | Alaska | 2170 | 871 | 3 |
644707 | 644707 | 2020-10-19 | Nome Census Area | Alaska | 2180 | 112 | 0 |
644708 | 644708 | 2020-10-19 | North Slope Borough | Alaska | 2185 | 213 | 0 |
644709 | 644709 | 2020-10-19 | Northwest Arctic Borough | Alaska | 2188 | 214 | 0 |
644710 | 644710 | 2020-10-19 | Petersburg Borough | Alaska | 2195 | 14 | 0 |
644711 | 644711 | 2020-10-19 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 33 | 0 |
644712 | 644712 | 2020-10-19 | Sitka City and Borough | Alaska | 2220 | 70 | 0 |
644713 | 644713 | 2020-10-19 | Skagway Municipality | Alaska | 2230 | 1 | 0 |
644714 | 644714 | 2020-10-19 | Southeast Fairbanks Census Area | Alaska | 2240 | 61 | 0 |
644715 | 644715 | 2020-10-19 | Unknown | Alaska | 53 | 0 | |
644716 | 644716 | 2020-10-19 | Valdez-Cordova Census Area | Alaska | 2261 | 148 | 1 |
644717 | 644717 | 2020-10-19 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
644718 | 644718 | 2020-10-19 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 33 | 0 |
644719 | 644719 | 2020-10-19 | Yukon-Koyukuk Census Area | Alaska | 2290 | 103 | 2 |
644720 | 644720 | 2020-10-19 | Apache | Arizona | 4001 | 3781 | 168 |
644721 | 644721 | 2020-10-19 | Cochise | Arizona | 4003 | 2057 | 73 |
644722 | 644722 | 2020-10-19 | Coconino | Arizona | 4005 | 4746 | 147 |
644723 | 644723 | 2020-10-19 | Gila | Arizona | 4007 | 1748 | 65 |
644724 | 644724 | 2020-10-19 | Graham | Arizona | 4009 | 1038 | 27 |
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);