ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,245 rows where date = "2020-12-28" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 254
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 106
- Illinois 102
- Iowa 100
- North Carolina 100
- Tennessee 96
- Nebraska 93
- 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
- Jefferson 26
- Franklin 25
- Jackson 24
- Lincoln 24
- Unknown 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 |
---|---|---|---|---|---|---|---|
871758 | 871758 | 2020-12-28 | Autauga | Alabama | 1001 | 4065 | 47 |
871759 | 871759 | 2020-12-28 | Baldwin | Alabama | 1003 | 12962 | 152 |
871760 | 871760 | 2020-12-28 | Barbour | Alabama | 1005 | 1417 | 32 |
871761 | 871761 | 2020-12-28 | Bibb | Alabama | 1007 | 1762 | 42 |
871762 | 871762 | 2020-12-28 | Blount | Alabama | 1009 | 4483 | 58 |
871763 | 871763 | 2020-12-28 | Bullock | Alabama | 1011 | 830 | 20 |
871764 | 871764 | 2020-12-28 | Butler | Alabama | 1013 | 1457 | 45 |
871765 | 871765 | 2020-12-28 | Calhoun | Alabama | 1015 | 9286 | 149 |
871766 | 871766 | 2020-12-28 | Chambers | Alabama | 1017 | 2229 | 61 |
871767 | 871767 | 2020-12-28 | Cherokee | Alabama | 1019 | 1372 | 23 |
871768 | 871768 | 2020-12-28 | Chilton | Alabama | 1021 | 2845 | 54 |
871769 | 871769 | 2020-12-28 | Choctaw | Alabama | 1023 | 487 | 22 |
871770 | 871770 | 2020-12-28 | Clarke | Alabama | 1025 | 2311 | 25 |
871771 | 871771 | 2020-12-28 | Clay | Alabama | 1027 | 1111 | 34 |
871772 | 871772 | 2020-12-28 | Cleburne | Alabama | 1029 | 999 | 16 |
871773 | 871773 | 2020-12-28 | Coffee | Alabama | 1031 | 3430 | 38 |
871774 | 871774 | 2020-12-28 | Colbert | Alabama | 1033 | 4469 | 59 |
871775 | 871775 | 2020-12-28 | Conecuh | Alabama | 1035 | 824 | 17 |
871776 | 871776 | 2020-12-28 | Coosa | Alabama | 1037 | 480 | 7 |
871777 | 871777 | 2020-12-28 | Covington | Alabama | 1039 | 2796 | 38 |
871778 | 871778 | 2020-12-28 | Crenshaw | Alabama | 1041 | 912 | 36 |
871779 | 871779 | 2020-12-28 | Cullman | Alabama | 1043 | 6774 | 76 |
871780 | 871780 | 2020-12-28 | Dale | Alabama | 1045 | 3201 | 63 |
871781 | 871781 | 2020-12-28 | Dallas | Alabama | 1047 | 2689 | 39 |
871782 | 871782 | 2020-12-28 | DeKalb | Alabama | 1049 | 6734 | 58 |
871783 | 871783 | 2020-12-28 | Elmore | Alabama | 1051 | 6063 | 81 |
871784 | 871784 | 2020-12-28 | Escambia | Alabama | 1053 | 2544 | 34 |
871785 | 871785 | 2020-12-28 | Etowah | Alabama | 1055 | 9704 | 91 |
871786 | 871786 | 2020-12-28 | Fayette | Alabama | 1057 | 1393 | 19 |
871787 | 871787 | 2020-12-28 | Franklin | Alabama | 1059 | 3169 | 36 |
871788 | 871788 | 2020-12-28 | Geneva | Alabama | 1061 | 1604 | 18 |
871789 | 871789 | 2020-12-28 | Greene | Alabama | 1063 | 633 | 20 |
871790 | 871790 | 2020-12-28 | Hale | Alabama | 1065 | 1395 | 33 |
871791 | 871791 | 2020-12-28 | Henry | Alabama | 1067 | 1178 | 8 |
871792 | 871792 | 2020-12-28 | Houston | Alabama | 1069 | 6949 | 63 |
871793 | 871793 | 2020-12-28 | Jackson | Alabama | 1071 | 4915 | 34 |
871794 | 871794 | 2020-12-28 | Jefferson | Alabama | 1073 | 49981 | 675 |
871795 | 871795 | 2020-12-28 | Lamar | Alabama | 1075 | 1017 | 15 |
871796 | 871796 | 2020-12-28 | Lauderdale | Alabama | 1077 | 6162 | 68 |
871797 | 871797 | 2020-12-28 | Lawrence | Alabama | 1079 | 1958 | 42 |
871798 | 871798 | 2020-12-28 | Lee | Alabama | 1081 | 9928 | 74 |
871799 | 871799 | 2020-12-28 | Limestone | Alabama | 1083 | 6561 | 55 |
871800 | 871800 | 2020-12-28 | Lowndes | Alabama | 1085 | 922 | 32 |
871801 | 871801 | 2020-12-28 | Macon | Alabama | 1087 | 974 | 30 |
871802 | 871802 | 2020-12-28 | Madison | Alabama | 1089 | 21385 | 179 |
871803 | 871803 | 2020-12-28 | Marengo | Alabama | 1091 | 1755 | 26 |
871804 | 871804 | 2020-12-28 | Marion | Alabama | 1093 | 2004 | 43 |
871805 | 871805 | 2020-12-28 | Marshall | Alabama | 1095 | 8865 | 84 |
871806 | 871806 | 2020-12-28 | Mobile | Alabama | 1097 | 25171 | 489 |
871807 | 871807 | 2020-12-28 | Monroe | Alabama | 1099 | 1112 | 11 |
871808 | 871808 | 2020-12-28 | Montgomery | Alabama | 1101 | 15678 | 271 |
871809 | 871809 | 2020-12-28 | Morgan | Alabama | 1103 | 10252 | 87 |
871810 | 871810 | 2020-12-28 | Perry | Alabama | 1105 | 836 | 9 |
871811 | 871811 | 2020-12-28 | Pickens | Alabama | 1107 | 1681 | 26 |
871812 | 871812 | 2020-12-28 | Pike | Alabama | 1109 | 1912 | 23 |
871813 | 871813 | 2020-12-28 | Randolph | Alabama | 1111 | 1221 | 30 |
871814 | 871814 | 2020-12-28 | Russell | Alabama | 1113 | 2694 | 6 |
871815 | 871815 | 2020-12-28 | Shelby | Alabama | 1117 | 15159 | 103 |
871816 | 871816 | 2020-12-28 | St. Clair | Alabama | 1115 | 6280 | 71 |
871817 | 871817 | 2020-12-28 | Sumter | Alabama | 1119 | 822 | 24 |
871818 | 871818 | 2020-12-28 | Talladega | Alabama | 1121 | 4953 | 74 |
871819 | 871819 | 2020-12-28 | Tallapoosa | Alabama | 1123 | 2304 | 98 |
871820 | 871820 | 2020-12-28 | Tuscaloosa | Alabama | 1125 | 17859 | 216 |
871821 | 871821 | 2020-12-28 | Walker | Alabama | 1127 | 5046 | 133 |
871822 | 871822 | 2020-12-28 | Washington | Alabama | 1129 | 1159 | 24 |
871823 | 871823 | 2020-12-28 | Wilcox | Alabama | 1131 | 853 | 19 |
871824 | 871824 | 2020-12-28 | Winston | Alabama | 1133 | 1921 | 27 |
871825 | 871825 | 2020-12-28 | Aleutians East Borough | Alaska | 2013 | 39 | 0 |
871826 | 871826 | 2020-12-28 | Aleutians West Census Area | Alaska | 2016 | 188 | 0 |
871827 | 871827 | 2020-12-28 | Anchorage | Alaska | 2020 | 22441 | 116 |
871828 | 871828 | 2020-12-28 | Bethel Census Area | Alaska | 2050 | 2189 | 9 |
871829 | 871829 | 2020-12-28 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 157 | 0 |
871830 | 871830 | 2020-12-28 | Denali Borough | Alaska | 2068 | 59 | 0 |
871831 | 871831 | 2020-12-28 | Dillingham Census Area | Alaska | 2070 | 114 | 1 |
871832 | 871832 | 2020-12-28 | Fairbanks North Star Borough | Alaska | 2090 | 4809 | 19 |
871833 | 871833 | 2020-12-28 | Haines Borough | Alaska | 2100 | 20 | 0 |
871834 | 871834 | 2020-12-28 | Juneau City and Borough | Alaska | 2110 | 1012 | 3 |
871835 | 871835 | 2020-12-28 | Kenai Peninsula Borough | Alaska | 2122 | 3587 | 14 |
871836 | 871836 | 2020-12-28 | Ketchikan Gateway Borough | Alaska | 2130 | 229 | 0 |
871837 | 871837 | 2020-12-28 | Kodiak Island Borough | Alaska | 2150 | 892 | 1 |
871838 | 871838 | 2020-12-28 | Kusilvak Census Area | Alaska | 2158 | 693 | 2 |
871839 | 871839 | 2020-12-28 | Matanuska-Susitna Borough | Alaska | 2170 | 6184 | 14 |
871840 | 871840 | 2020-12-28 | Nome Census Area | Alaska | 2180 | 272 | 0 |
871841 | 871841 | 2020-12-28 | North Slope Borough | Alaska | 2185 | 791 | 2 |
871842 | 871842 | 2020-12-28 | Northwest Arctic Borough | Alaska | 2188 | 400 | 0 |
871843 | 871843 | 2020-12-28 | Petersburg Borough | Alaska | 2195 | 25 | 0 |
871844 | 871844 | 2020-12-28 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 69 | 1 |
871845 | 871845 | 2020-12-28 | Sitka City and Borough | Alaska | 2220 | 266 | 0 |
871846 | 871846 | 2020-12-28 | Skagway Municipality | Alaska | 2230 | 16 | 0 |
871847 | 871847 | 2020-12-28 | Southeast Fairbanks Census Area | Alaska | 2240 | 400 | 3 |
871848 | 871848 | 2020-12-28 | Unknown | Alaska | 216 | 0 | |
871849 | 871849 | 2020-12-28 | Valdez-Cordova Census Area | Alaska | 2261 | 325 | 2 |
871850 | 871850 | 2020-12-28 | Wrangell City and Borough | Alaska | 2275 | 23 | 0 |
871851 | 871851 | 2020-12-28 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 51 | 1 |
871852 | 871852 | 2020-12-28 | Yukon-Koyukuk Census Area | Alaska | 2290 | 207 | 4 |
871853 | 871853 | 2020-12-28 | Apache | Arizona | 4001 | 7255 | 225 |
871854 | 871854 | 2020-12-28 | Cochise | Arizona | 4003 | 7236 | 119 |
871855 | 871855 | 2020-12-28 | Coconino | Arizona | 4005 | 10852 | 205 |
871856 | 871856 | 2020-12-28 | Gila | Arizona | 4007 | 4347 | 126 |
871857 | 871857 | 2020-12-28 | Graham | Arizona | 4009 | 3137 | 48 |
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);