ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,245 rows where date = "2020-11-01" 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 95
- Nebraska 94
- Indiana 92
- Minnesota 88
- Ohio 88
- Michigan 84
- Mississippi 82
- Puerto Rico 79
- Oklahoma 78
- Arkansas 76
- Wisconsin 73
- 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 |
---|---|---|---|---|---|---|---|
686795 | 686795 | 2020-11-01 | Autauga | Alabama | 1001 | 2173 | 31 |
686796 | 686796 | 2020-11-01 | Baldwin | Alabama | 1003 | 6966 | 71 |
686797 | 686797 | 2020-11-01 | Barbour | Alabama | 1005 | 1061 | 9 |
686798 | 686798 | 2020-11-01 | Bibb | Alabama | 1007 | 878 | 15 |
686799 | 686799 | 2020-11-01 | Blount | Alabama | 1009 | 2095 | 25 |
686800 | 686800 | 2020-11-01 | Bullock | Alabama | 1011 | 655 | 17 |
686801 | 686801 | 2020-11-01 | Butler | Alabama | 1013 | 1024 | 41 |
686802 | 686802 | 2020-11-01 | Calhoun | Alabama | 1015 | 4892 | 65 |
686803 | 686803 | 2020-11-01 | Chambers | Alabama | 1017 | 1392 | 47 |
686804 | 686804 | 2020-11-01 | Cherokee | Alabama | 1019 | 787 | 15 |
686805 | 686805 | 2020-11-01 | Chilton | Alabama | 1021 | 1946 | 33 |
686806 | 686806 | 2020-11-01 | Choctaw | Alabama | 1023 | 395 | 12 |
686807 | 686807 | 2020-11-01 | Clarke | Alabama | 1025 | 1406 | 17 |
686808 | 686808 | 2020-11-01 | Clay | Alabama | 1027 | 776 | 12 |
686809 | 686809 | 2020-11-01 | Cleburne | Alabama | 1029 | 590 | 9 |
686810 | 686810 | 2020-11-01 | Coffee | Alabama | 1031 | 1878 | 11 |
686811 | 686811 | 2020-11-01 | Colbert | Alabama | 1033 | 2307 | 32 |
686812 | 686812 | 2020-11-01 | Conecuh | Alabama | 1035 | 577 | 13 |
686813 | 686813 | 2020-11-01 | Coosa | Alabama | 1037 | 223 | 3 |
686814 | 686814 | 2020-11-01 | Covington | Alabama | 1039 | 1892 | 30 |
686815 | 686815 | 2020-11-01 | Crenshaw | Alabama | 1041 | 621 | 30 |
686816 | 686816 | 2020-11-01 | Cullman | Alabama | 1043 | 2831 | 25 |
686817 | 686817 | 2020-11-01 | Dale | Alabama | 1045 | 1926 | 52 |
686818 | 686818 | 2020-11-01 | Dallas | Alabama | 1047 | 1907 | 27 |
686819 | 686819 | 2020-11-01 | DeKalb | Alabama | 1049 | 3691 | 30 |
686820 | 686820 | 2020-11-01 | Elmore | Alabama | 1051 | 3314 | 59 |
686821 | 686821 | 2020-11-01 | Escambia | Alabama | 1053 | 1768 | 31 |
686822 | 686822 | 2020-11-01 | Etowah | Alabama | 1055 | 4530 | 54 |
686823 | 686823 | 2020-11-01 | Fayette | Alabama | 1057 | 608 | 14 |
686824 | 686824 | 2020-11-01 | Franklin | Alabama | 1059 | 2185 | 32 |
686825 | 686825 | 2020-11-01 | Geneva | Alabama | 1061 | 975 | 7 |
686826 | 686826 | 2020-11-01 | Greene | Alabama | 1063 | 351 | 17 |
686827 | 686827 | 2020-11-01 | Hale | Alabama | 1065 | 796 | 30 |
686828 | 686828 | 2020-11-01 | Henry | Alabama | 1067 | 747 | 6 |
686829 | 686829 | 2020-11-01 | Houston | Alabama | 1069 | 4320 | 35 |
686830 | 686830 | 2020-11-01 | Jackson | Alabama | 1071 | 2347 | 19 |
686831 | 686831 | 2020-11-01 | Jefferson | Alabama | 1073 | 24472 | 388 |
686832 | 686832 | 2020-11-01 | Lamar | Alabama | 1075 | 534 | 6 |
686833 | 686833 | 2020-11-01 | Lauderdale | Alabama | 1077 | 2743 | 43 |
686834 | 686834 | 2020-11-01 | Lawrence | Alabama | 1079 | 941 | 33 |
686835 | 686835 | 2020-11-01 | Lee | Alabama | 1081 | 6715 | 65 |
686836 | 686836 | 2020-11-01 | Limestone | Alabama | 1083 | 3108 | 34 |
686837 | 686837 | 2020-11-01 | Lowndes | Alabama | 1085 | 728 | 29 |
686838 | 686838 | 2020-11-01 | Macon | Alabama | 1087 | 565 | 21 |
686839 | 686839 | 2020-11-01 | Madison | Alabama | 1089 | 9787 | 101 |
686840 | 686840 | 2020-11-01 | Marengo | Alabama | 1091 | 1066 | 23 |
686841 | 686841 | 2020-11-01 | Marion | Alabama | 1093 | 1127 | 31 |
686842 | 686842 | 2020-11-01 | Marshall | Alabama | 1095 | 4570 | 52 |
686843 | 686843 | 2020-11-01 | Mobile | Alabama | 1097 | 17298 | 322 |
686844 | 686844 | 2020-11-01 | Monroe | Alabama | 1099 | 668 | 10 |
686845 | 686845 | 2020-11-01 | Montgomery | Alabama | 1101 | 10702 | 210 |
686846 | 686846 | 2020-11-01 | Morgan | Alabama | 1103 | 4523 | 36 |
686847 | 686847 | 2020-11-01 | Perry | Alabama | 1105 | 606 | 6 |
686848 | 686848 | 2020-11-01 | Pickens | Alabama | 1107 | 929 | 18 |
686849 | 686849 | 2020-11-01 | Pike | Alabama | 1109 | 1385 | 14 |
686850 | 686850 | 2020-11-01 | Randolph | Alabama | 1111 | 865 | 16 |
686851 | 686851 | 2020-11-01 | Russell | Alabama | 1113 | 2007 | 3 |
686852 | 686852 | 2020-11-01 | Shelby | Alabama | 1117 | 7788 | 70 |
686853 | 686853 | 2020-11-01 | St. Clair | Alabama | 1115 | 3240 | 43 |
686854 | 686854 | 2020-11-01 | Sumter | Alabama | 1119 | 488 | 21 |
686855 | 686855 | 2020-11-01 | Talladega | Alabama | 1121 | 2808 | 38 |
686856 | 686856 | 2020-11-01 | Tallapoosa | Alabama | 1123 | 1403 | 87 |
686857 | 686857 | 2020-11-01 | Tuscaloosa | Alabama | 1125 | 10792 | 145 |
686858 | 686858 | 2020-11-01 | Walker | Alabama | 1127 | 2966 | 95 |
686859 | 686859 | 2020-11-01 | Washington | Alabama | 1129 | 774 | 12 |
686860 | 686860 | 2020-11-01 | Wilcox | Alabama | 1131 | 576 | 12 |
686861 | 686861 | 2020-11-01 | Winston | Alabama | 1133 | 981 | 13 |
686862 | 686862 | 2020-11-01 | Aleutians East Borough | Alaska | 2013 | 15 | 0 |
686863 | 686863 | 2020-11-01 | Aleutians West Census Area | Alaska | 2016 | 100 | 0 |
686864 | 686864 | 2020-11-01 | Anchorage | Alaska | 2020 | 8508 | 49 |
686865 | 686865 | 2020-11-01 | Bethel Census Area | Alaska | 2050 | 485 | 1 |
686866 | 686866 | 2020-11-01 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 113 | 0 |
686867 | 686867 | 2020-11-01 | Denali Borough | Alaska | 2068 | 31 | 0 |
686868 | 686868 | 2020-11-01 | Dillingham Census Area | Alaska | 2070 | 60 | 0 |
686869 | 686869 | 2020-11-01 | Fairbanks North Star Borough | Alaska | 2090 | 2285 | 16 |
686870 | 686870 | 2020-11-01 | Haines Borough | Alaska | 2100 | 13 | 0 |
686871 | 686871 | 2020-11-01 | Juneau City and Borough | Alaska | 2110 | 579 | 2 |
686872 | 686872 | 2020-11-01 | Kenai Peninsula Borough | Alaska | 2122 | 1114 | 2 |
686873 | 686873 | 2020-11-01 | Ketchikan Gateway Borough | Alaska | 2130 | 89 | 0 |
686874 | 686874 | 2020-11-01 | Kodiak Island Borough | Alaska | 2150 | 124 | 0 |
686875 | 686875 | 2020-11-01 | Kusilvak Census Area | Alaska | 2158 | 250 | 0 |
686876 | 686876 | 2020-11-01 | Matanuska-Susitna Borough | Alaska | 2170 | 1509 | 3 |
686877 | 686877 | 2020-11-01 | Nome Census Area | Alaska | 2180 | 138 | 0 |
686878 | 686878 | 2020-11-01 | North Slope Borough | Alaska | 2185 | 276 | 0 |
686879 | 686879 | 2020-11-01 | Northwest Arctic Borough | Alaska | 2188 | 258 | 0 |
686880 | 686880 | 2020-11-01 | Petersburg Borough | Alaska | 2195 | 18 | 0 |
686881 | 686881 | 2020-11-01 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 34 | 1 |
686882 | 686882 | 2020-11-01 | Sitka City and Borough | Alaska | 2220 | 81 | 0 |
686883 | 686883 | 2020-11-01 | Skagway Municipality | Alaska | 2230 | 8 | 0 |
686884 | 686884 | 2020-11-01 | Southeast Fairbanks Census Area | Alaska | 2240 | 89 | 1 |
686885 | 686885 | 2020-11-01 | Unknown | Alaska | 68 | 0 | |
686886 | 686886 | 2020-11-01 | Valdez-Cordova Census Area | Alaska | 2261 | 176 | 1 |
686887 | 686887 | 2020-11-01 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
686888 | 686888 | 2020-11-01 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 37 | 0 |
686889 | 686889 | 2020-11-01 | Yukon-Koyukuk Census Area | Alaska | 2290 | 120 | 2 |
686890 | 686890 | 2020-11-01 | Apache | Arizona | 4001 | 4003 | 171 |
686891 | 686891 | 2020-11-01 | Cochise | Arizona | 4003 | 2216 | 75 |
686892 | 686892 | 2020-11-01 | Coconino | Arizona | 4005 | 5405 | 149 |
686893 | 686893 | 2020-11-01 | Gila | Arizona | 4007 | 1989 | 72 |
686894 | 686894 | 2020-11-01 | Graham | Arizona | 4009 | 1281 | 29 |
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);