ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,218 rows where date = "2020-07-30" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 250
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Illinois 103
- Kansas 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Indiana 92
- Minnesota 88
- Ohio 88
- Nebraska 86
- Michigan 84
- Mississippi 82
- Puerto Rico 79
- Oklahoma 77
- Arkansas 76
- Wisconsin 73
- Florida 68
- Alabama 67
- Pennsylvania 67
- Louisiana 65
- South Dakota 65
- Colorado 63
- California 58
- New York 58
- West Virginia 55
- North Dakota 54
- …
fips >30
county >30
- Washington 31
- Jefferson 26
- Unknown 26
- Franklin 25
- Jackson 24
- Lincoln 24
- Madison 20
- Clay 18
- Montgomery 18
- Union 18
- Marion 17
- Monroe 17
- Wayne 16
- Grant 14
- 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 |
---|---|---|---|---|---|---|---|
382722 | 382722 | 2020-07-30 | Autauga | Alabama | 1001 | 1002 | 21 |
382723 | 382723 | 2020-07-30 | Baldwin | Alabama | 1003 | 3028 | 21 |
382724 | 382724 | 2020-07-30 | Barbour | Alabama | 1005 | 585 | 5 |
382725 | 382725 | 2020-07-30 | Bibb | Alabama | 1007 | 352 | 2 |
382726 | 382726 | 2020-07-30 | Blount | Alabama | 1009 | 731 | 3 |
382727 | 382727 | 2020-07-30 | Bullock | Alabama | 1011 | 435 | 12 |
382728 | 382728 | 2020-07-30 | Butler | Alabama | 1013 | 747 | 36 |
382729 | 382729 | 2020-07-30 | Calhoun | Alabama | 1015 | 1336 | 8 |
382730 | 382730 | 2020-07-30 | Chambers | Alabama | 1017 | 848 | 38 |
382731 | 382731 | 2020-07-30 | Cherokee | Alabama | 1019 | 234 | 8 |
382732 | 382732 | 2020-07-30 | Chilton | Alabama | 1021 | 686 | 6 |
382733 | 382733 | 2020-07-30 | Choctaw | Alabama | 1023 | 270 | 12 |
382734 | 382734 | 2020-07-30 | Clarke | Alabama | 1025 | 487 | 9 |
382735 | 382735 | 2020-07-30 | Clay | Alabama | 1027 | 193 | 5 |
382736 | 382736 | 2020-07-30 | Cleburne | Alabama | 1029 | 110 | 1 |
382737 | 382737 | 2020-07-30 | Coffee | Alabama | 1031 | 697 | 5 |
382738 | 382738 | 2020-07-30 | Colbert | Alabama | 1033 | 1023 | 11 |
382739 | 382739 | 2020-07-30 | Conecuh | Alabama | 1035 | 365 | 10 |
382740 | 382740 | 2020-07-30 | Coosa | Alabama | 1037 | 94 | 2 |
382741 | 382741 | 2020-07-30 | Covington | Alabama | 1039 | 749 | 21 |
382742 | 382742 | 2020-07-30 | Crenshaw | Alabama | 1041 | 279 | 4 |
382743 | 382743 | 2020-07-30 | Cullman | Alabama | 1043 | 1099 | 11 |
382744 | 382744 | 2020-07-30 | Dale | Alabama | 1045 | 751 | 18 |
382745 | 382745 | 2020-07-30 | Dallas | Alabama | 1047 | 1301 | 23 |
382746 | 382746 | 2020-07-30 | DeKalb | Alabama | 1049 | 1622 | 11 |
382747 | 382747 | 2020-07-30 | Elmore | Alabama | 1051 | 1568 | 35 |
382748 | 382748 | 2020-07-30 | Escambia | Alabama | 1053 | 972 | 15 |
382749 | 382749 | 2020-07-30 | Etowah | Alabama | 1055 | 1846 | 19 |
382750 | 382750 | 2020-07-30 | Fayette | Alabama | 1057 | 170 | 5 |
382751 | 382751 | 2020-07-30 | Franklin | Alabama | 1059 | 1156 | 20 |
382752 | 382752 | 2020-07-30 | Geneva | Alabama | 1061 | 210 | 1 |
382753 | 382753 | 2020-07-30 | Greene | Alabama | 1063 | 241 | 11 |
382754 | 382754 | 2020-07-30 | Hale | Alabama | 1065 | 447 | 25 |
382755 | 382755 | 2020-07-30 | Henry | Alabama | 1067 | 242 | 4 |
382756 | 382756 | 2020-07-30 | Houston | Alabama | 1069 | 1251 | 14 |
382757 | 382757 | 2020-07-30 | Jackson | Alabama | 1071 | 730 | 5 |
382758 | 382758 | 2020-07-30 | Jefferson | Alabama | 1073 | 11111 | 222 |
382759 | 382759 | 2020-07-30 | Lamar | Alabama | 1075 | 194 | 2 |
382760 | 382760 | 2020-07-30 | Lauderdale | Alabama | 1077 | 996 | 10 |
382761 | 382761 | 2020-07-30 | Lawrence | Alabama | 1079 | 286 | 0 |
382762 | 382762 | 2020-07-30 | Lee | Alabama | 1081 | 2520 | 43 |
382763 | 382763 | 2020-07-30 | Limestone | Alabama | 1083 | 1134 | 12 |
382764 | 382764 | 2020-07-30 | Lowndes | Alabama | 1085 | 559 | 26 |
382765 | 382765 | 2020-07-30 | Macon | Alabama | 1087 | 308 | 12 |
382766 | 382766 | 2020-07-30 | Madison | Alabama | 1089 | 4744 | 30 |
382767 | 382767 | 2020-07-30 | Marengo | Alabama | 1091 | 509 | 14 |
382768 | 382768 | 2020-07-30 | Marion | Alabama | 1093 | 537 | 24 |
382769 | 382769 | 2020-07-30 | Marshall | Alabama | 1095 | 2843 | 29 |
382770 | 382770 | 2020-07-30 | Mobile | Alabama | 1097 | 7915 | 186 |
382771 | 382771 | 2020-07-30 | Monroe | Alabama | 1099 | 420 | 4 |
382772 | 382772 | 2020-07-30 | Montgomery | Alabama | 1101 | 6045 | 142 |
382773 | 382773 | 2020-07-30 | Morgan | Alabama | 1103 | 2125 | 15 |
382774 | 382774 | 2020-07-30 | Perry | Alabama | 1105 | 432 | 3 |
382775 | 382775 | 2020-07-30 | Pickens | Alabama | 1107 | 353 | 10 |
382776 | 382776 | 2020-07-30 | Pike | Alabama | 1109 | 641 | 7 |
382777 | 382777 | 2020-07-30 | Randolph | Alabama | 1111 | 388 | 11 |
382778 | 382778 | 2020-07-30 | Russell | Alabama | 1113 | 1168 | 1 |
382779 | 382779 | 2020-07-30 | Shelby | Alabama | 1117 | 2979 | 32 |
382780 | 382780 | 2020-07-30 | St. Clair | Alabama | 1115 | 1179 | 9 |
382781 | 382781 | 2020-07-30 | Sumter | Alabama | 1119 | 357 | 17 |
382782 | 382782 | 2020-07-30 | Talladega | Alabama | 1121 | 944 | 13 |
382783 | 382783 | 2020-07-30 | Tallapoosa | Alabama | 1123 | 824 | 79 |
382784 | 382784 | 2020-07-30 | Tuscaloosa | Alabama | 1125 | 3822 | 63 |
382785 | 382785 | 2020-07-30 | Walker | Alabama | 1127 | 1445 | 63 |
382786 | 382786 | 2020-07-30 | Washington | Alabama | 1129 | 301 | 10 |
382787 | 382787 | 2020-07-30 | Wilcox | Alabama | 1131 | 404 | 9 |
382788 | 382788 | 2020-07-30 | Winston | Alabama | 1133 | 422 | 10 |
382789 | 382789 | 2020-07-30 | Aleutians East Borough | Alaska | 2013 | 3 | 0 |
382790 | 382790 | 2020-07-30 | Aleutians West Census Area | Alaska | 2016 | 88 | 0 |
382791 | 382791 | 2020-07-30 | Anchorage | Alaska | 2020 | 1696 | 10 |
382792 | 382792 | 2020-07-30 | Bethel Census Area | Alaska | 2050 | 21 | 0 |
382793 | 382793 | 2020-07-30 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 68 | 0 |
382794 | 382794 | 2020-07-30 | Denali Borough | Alaska | 2068 | 4 | 0 |
382795 | 382795 | 2020-07-30 | Dillingham Census Area | Alaska | 2070 | 21 | 0 |
382796 | 382796 | 2020-07-30 | Fairbanks North Star Borough | Alaska | 2090 | 422 | 5 |
382797 | 382797 | 2020-07-30 | Haines Borough | Alaska | 2100 | 8 | 0 |
382798 | 382798 | 2020-07-30 | Juneau City and Borough | Alaska | 2110 | 141 | 2 |
382799 | 382799 | 2020-07-30 | Kenai Peninsula Borough | Alaska | 2122 | 436 | 1 |
382800 | 382800 | 2020-07-30 | Ketchikan Gateway Borough | Alaska | 2130 | 47 | 0 |
382801 | 382801 | 2020-07-30 | Kodiak Island Borough | Alaska | 2150 | 15 | 0 |
382802 | 382802 | 2020-07-30 | Kusilvak Census Area | Alaska | 2158 | 4 | 0 |
382803 | 382803 | 2020-07-30 | Matanuska-Susitna Borough | Alaska | 2170 | 271 | 2 |
382804 | 382804 | 2020-07-30 | Nome Census Area | Alaska | 2180 | 20 | 0 |
382805 | 382805 | 2020-07-30 | North Slope Borough | Alaska | 2185 | 15 | 0 |
382806 | 382806 | 2020-07-30 | Northwest Arctic Borough | Alaska | 2188 | 28 | 0 |
382807 | 382807 | 2020-07-30 | Petersburg Borough | Alaska | 2195 | 9 | 0 |
382808 | 382808 | 2020-07-30 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 6 | 0 |
382809 | 382809 | 2020-07-30 | Sitka City and Borough | Alaska | 2220 | 30 | 0 |
382810 | 382810 | 2020-07-30 | Southeast Fairbanks Census Area | Alaska | 2240 | 26 | 0 |
382811 | 382811 | 2020-07-30 | Unknown | Alaska | 37 | 0 | |
382812 | 382812 | 2020-07-30 | Valdez-Cordova Census Area | Alaska | 2261 | 85 | 0 |
382813 | 382813 | 2020-07-30 | Wrangell City and Borough | Alaska | 2275 | 8 | 0 |
382814 | 382814 | 2020-07-30 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 6 | 0 |
382815 | 382815 | 2020-07-30 | Yukon-Koyukuk Census Area | Alaska | 2290 | 42 | 1 |
382816 | 382816 | 2020-07-30 | Apache | Arizona | 4001 | 2969 | 129 |
382817 | 382817 | 2020-07-30 | Cochise | Arizona | 4003 | 1467 | 47 |
382818 | 382818 | 2020-07-30 | Coconino | Arizona | 4005 | 2933 | 117 |
382819 | 382819 | 2020-07-30 | Gila | Arizona | 4007 | 778 | 29 |
382820 | 382820 | 2020-07-30 | Graham | Arizona | 4009 | 435 | 8 |
382821 | 382821 | 2020-07-30 | Greenlee | Arizona | 4011 | 54 | 2 |
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);