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-08" 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
- Unknown 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 |
---|---|---|---|---|---|---|---|
806849 | 806849 | 2020-12-08 | Autauga | Alabama | 1001 | 3087 | 42 |
806850 | 806850 | 2020-12-08 | Baldwin | Alabama | 1003 | 9974 | 141 |
806851 | 806851 | 2020-12-08 | Barbour | Alabama | 1005 | 1240 | 30 |
806852 | 806852 | 2020-12-08 | Bibb | Alabama | 1007 | 1317 | 39 |
806853 | 806853 | 2020-12-08 | Blount | Alabama | 1009 | 3426 | 46 |
806854 | 806854 | 2020-12-08 | Bullock | Alabama | 1011 | 719 | 20 |
806855 | 806855 | 2020-12-08 | Butler | Alabama | 1013 | 1257 | 42 |
806856 | 806856 | 2020-12-08 | Calhoun | Alabama | 1015 | 7300 | 127 |
806857 | 806857 | 2020-12-08 | Chambers | Alabama | 1017 | 1945 | 54 |
806858 | 806858 | 2020-12-08 | Cherokee | Alabama | 1019 | 1125 | 24 |
806859 | 806859 | 2020-12-08 | Chilton | Alabama | 1021 | 2441 | 46 |
806860 | 806860 | 2020-12-08 | Choctaw | Alabama | 1023 | 442 | 20 |
806861 | 806861 | 2020-12-08 | Clarke | Alabama | 1025 | 1699 | 23 |
806862 | 806862 | 2020-12-08 | Clay | Alabama | 1027 | 979 | 27 |
806863 | 806863 | 2020-12-08 | Cleburne | Alabama | 1029 | 837 | 14 |
806864 | 806864 | 2020-12-08 | Coffee | Alabama | 1031 | 2728 | 25 |
806865 | 806865 | 2020-12-08 | Colbert | Alabama | 1033 | 3578 | 50 |
806866 | 806866 | 2020-12-08 | Conecuh | Alabama | 1035 | 759 | 15 |
806867 | 806867 | 2020-12-08 | Coosa | Alabama | 1037 | 408 | 4 |
806868 | 806868 | 2020-12-08 | Covington | Alabama | 1039 | 2415 | 38 |
806869 | 806869 | 2020-12-08 | Crenshaw | Alabama | 1041 | 756 | 31 |
806870 | 806870 | 2020-12-08 | Cullman | Alabama | 1043 | 5299 | 56 |
806871 | 806871 | 2020-12-08 | Dale | Alabama | 1045 | 2560 | 59 |
806872 | 806872 | 2020-12-08 | Dallas | Alabama | 1047 | 2424 | 34 |
806873 | 806873 | 2020-12-08 | DeKalb | Alabama | 1049 | 5438 | 46 |
806874 | 806874 | 2020-12-08 | Elmore | Alabama | 1051 | 4618 | 70 |
806875 | 806875 | 2020-12-08 | Escambia | Alabama | 1053 | 2184 | 32 |
806876 | 806876 | 2020-12-08 | Etowah | Alabama | 1055 | 7471 | 71 |
806877 | 806877 | 2020-12-08 | Fayette | Alabama | 1057 | 1083 | 16 |
806878 | 806878 | 2020-12-08 | Franklin | Alabama | 1059 | 2735 | 34 |
806879 | 806879 | 2020-12-08 | Geneva | Alabama | 1061 | 1343 | 12 |
806880 | 806880 | 2020-12-08 | Greene | Alabama | 1063 | 488 | 18 |
806881 | 806881 | 2020-12-08 | Hale | Alabama | 1065 | 1057 | 32 |
806882 | 806882 | 2020-12-08 | Henry | Alabama | 1067 | 937 | 7 |
806883 | 806883 | 2020-12-08 | Houston | Alabama | 1069 | 5771 | 46 |
806884 | 806884 | 2020-12-08 | Jackson | Alabama | 1071 | 4021 | 23 |
806885 | 806885 | 2020-12-08 | Jefferson | Alabama | 1073 | 37488 | 529 |
806886 | 806886 | 2020-12-08 | Lamar | Alabama | 1075 | 769 | 8 |
806887 | 806887 | 2020-12-08 | Lauderdale | Alabama | 1077 | 4722 | 57 |
806888 | 806888 | 2020-12-08 | Lawrence | Alabama | 1079 | 1453 | 36 |
806889 | 806889 | 2020-12-08 | Lee | Alabama | 1081 | 8298 | 71 |
806890 | 806890 | 2020-12-08 | Limestone | Alabama | 1083 | 4905 | 48 |
806891 | 806891 | 2020-12-08 | Lowndes | Alabama | 1085 | 845 | 30 |
806892 | 806892 | 2020-12-08 | Macon | Alabama | 1087 | 807 | 22 |
806893 | 806893 | 2020-12-08 | Madison | Alabama | 1089 | 15575 | 161 |
806894 | 806894 | 2020-12-08 | Marengo | Alabama | 1091 | 1340 | 24 |
806895 | 806895 | 2020-12-08 | Marion | Alabama | 1093 | 1585 | 36 |
806896 | 806896 | 2020-12-08 | Marshall | Alabama | 1095 | 7319 | 59 |
806897 | 806897 | 2020-12-08 | Mobile | Alabama | 1097 | 21257 | 383 |
806898 | 806898 | 2020-12-08 | Monroe | Alabama | 1099 | 881 | 11 |
806899 | 806899 | 2020-12-08 | Montgomery | Alabama | 1101 | 13186 | 248 |
806900 | 806900 | 2020-12-08 | Morgan | Alabama | 1103 | 7834 | 59 |
806901 | 806901 | 2020-12-08 | Perry | Alabama | 1105 | 714 | 7 |
806902 | 806902 | 2020-12-08 | Pickens | Alabama | 1107 | 1330 | 22 |
806903 | 806903 | 2020-12-08 | Pike | Alabama | 1109 | 1679 | 15 |
806904 | 806904 | 2020-12-08 | Randolph | Alabama | 1111 | 1100 | 22 |
806905 | 806905 | 2020-12-08 | Russell | Alabama | 1113 | 2383 | 5 |
806906 | 806906 | 2020-12-08 | Shelby | Alabama | 1117 | 11881 | 78 |
806907 | 806907 | 2020-12-08 | St. Clair | Alabama | 1115 | 4938 | 57 |
806908 | 806908 | 2020-12-08 | Sumter | Alabama | 1119 | 622 | 22 |
806909 | 806909 | 2020-12-08 | Talladega | Alabama | 1121 | 4082 | 62 |
806910 | 806910 | 2020-12-08 | Tallapoosa | Alabama | 1123 | 1983 | 92 |
806911 | 806911 | 2020-12-08 | Tuscaloosa | Alabama | 1125 | 14507 | 186 |
806912 | 806912 | 2020-12-08 | Walker | Alabama | 1127 | 4128 | 113 |
806913 | 806913 | 2020-12-08 | Washington | Alabama | 1129 | 969 | 22 |
806914 | 806914 | 2020-12-08 | Wilcox | Alabama | 1131 | 677 | 18 |
806915 | 806915 | 2020-12-08 | Winston | Alabama | 1133 | 1547 | 25 |
806916 | 806916 | 2020-12-08 | Aleutians East Borough | Alaska | 2013 | 42 | 0 |
806917 | 806917 | 2020-12-08 | Aleutians West Census Area | Alaska | 2016 | 146 | 0 |
806918 | 806918 | 2020-12-08 | Anchorage | Alaska | 2020 | 18960 | 80 |
806919 | 806919 | 2020-12-08 | Bethel Census Area | Alaska | 2050 | 1806 | 7 |
806920 | 806920 | 2020-12-08 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 151 | 0 |
806921 | 806921 | 2020-12-08 | Denali Borough | Alaska | 2068 | 48 | 0 |
806922 | 806922 | 2020-12-08 | Dillingham Census Area | Alaska | 2070 | 105 | 1 |
806923 | 806923 | 2020-12-08 | Fairbanks North Star Borough | Alaska | 2090 | 3859 | 17 |
806924 | 806924 | 2020-12-08 | Haines Borough | Alaska | 2100 | 17 | 0 |
806925 | 806925 | 2020-12-08 | Juneau City and Borough | Alaska | 2110 | 904 | 3 |
806926 | 806926 | 2020-12-08 | Kenai Peninsula Borough | Alaska | 2122 | 3020 | 10 |
806927 | 806927 | 2020-12-08 | Ketchikan Gateway Borough | Alaska | 2130 | 212 | 0 |
806928 | 806928 | 2020-12-08 | Kodiak Island Borough | Alaska | 2150 | 528 | 1 |
806929 | 806929 | 2020-12-08 | Kusilvak Census Area | Alaska | 2158 | 496 | 2 |
806930 | 806930 | 2020-12-08 | Matanuska-Susitna Borough | Alaska | 2170 | 5042 | 8 |
806931 | 806931 | 2020-12-08 | Nome Census Area | Alaska | 2180 | 249 | 0 |
806932 | 806932 | 2020-12-08 | North Slope Borough | Alaska | 2185 | 572 | 1 |
806933 | 806933 | 2020-12-08 | Northwest Arctic Borough | Alaska | 2188 | 376 | 0 |
806934 | 806934 | 2020-12-08 | Petersburg Borough | Alaska | 2195 | 26 | 0 |
806935 | 806935 | 2020-12-08 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 58 | 1 |
806936 | 806936 | 2020-12-08 | Sitka City and Borough | Alaska | 2220 | 227 | 0 |
806937 | 806937 | 2020-12-08 | Skagway Municipality | Alaska | 2230 | 11 | 0 |
806938 | 806938 | 2020-12-08 | Southeast Fairbanks Census Area | Alaska | 2240 | 338 | 2 |
806939 | 806939 | 2020-12-08 | Unknown | Alaska | 192 | 0 | |
806940 | 806940 | 2020-12-08 | Valdez-Cordova Census Area | Alaska | 2261 | 283 | 3 |
806941 | 806941 | 2020-12-08 | Wrangell City and Borough | Alaska | 2275 | 22 | 0 |
806942 | 806942 | 2020-12-08 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 49 | 0 |
806943 | 806943 | 2020-12-08 | Yukon-Koyukuk Census Area | Alaska | 2290 | 184 | 3 |
806944 | 806944 | 2020-12-08 | Apache | Arizona | 4001 | 5952 | 200 |
806945 | 806945 | 2020-12-08 | Cochise | Arizona | 4003 | 4663 | 91 |
806946 | 806946 | 2020-12-08 | Coconino | Arizona | 4005 | 8494 | 182 |
806947 | 806947 | 2020-12-08 | Gila | Arizona | 4007 | 3365 | 105 |
806948 | 806948 | 2020-12-08 | Graham | Arizona | 4009 | 2419 | 38 |
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);