ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,865 rows where date = "2020-05-01" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 210
- Georgia 158
- Virginia 130
- Kentucky 113
- Illinois 98
- Missouri 98
- North Carolina 98
- Tennessee 93
- Indiana 92
- Iowa 91
- Ohio 88
- Minnesota 81
- Mississippi 81
- Kansas 80
- Michigan 80
- Arkansas 74
- Oklahoma 70
- Florida 68
- Alabama 67
- Pennsylvania 67
- Wisconsin 67
- Louisiana 65
- Nebraska 62
- New York 58
- Colorado 57
- California 54
- West Virginia 51
- South Carolina 46
- South Dakota 46
- Washington 38
- …
fips >30
county >30
- Washington 30
- Jefferson 26
- Unknown 26
- Franklin 24
- Jackson 22
- Lincoln 22
- Madison 20
- Montgomery 18
- Union 18
- Clay 17
- Marion 17
- Monroe 15
- Greene 14
- Warren 14
- Wayne 14
- Carroll 13
- Grant 12
- Johnson 12
- Polk 12
- Clark 11
- Crawford 11
- Douglas 11
- Fayette 11
- Lee 11
- Marshall 11
- Morgan 11
- Adams 10
- Calhoun 10
- Hamilton 10
- Henry 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
103871 | 103871 | 2020-05-01 | Autauga | Alabama | 1001 | 42 | 3 |
103872 | 103872 | 2020-05-01 | Baldwin | Alabama | 1003 | 175 | 4 |
103873 | 103873 | 2020-05-01 | Barbour | Alabama | 1005 | 42 | 1 |
103874 | 103874 | 2020-05-01 | Bibb | Alabama | 1007 | 42 | 0 |
103875 | 103875 | 2020-05-01 | Blount | Alabama | 1009 | 39 | 0 |
103876 | 103876 | 2020-05-01 | Bullock | Alabama | 1011 | 14 | 0 |
103877 | 103877 | 2020-05-01 | Butler | Alabama | 1013 | 65 | 1 |
103878 | 103878 | 2020-05-01 | Calhoun | Alabama | 1015 | 93 | 3 |
103879 | 103879 | 2020-05-01 | Chambers | Alabama | 1017 | 290 | 21 |
103880 | 103880 | 2020-05-01 | Cherokee | Alabama | 1019 | 15 | 0 |
103881 | 103881 | 2020-05-01 | Chilton | Alabama | 1021 | 52 | 1 |
103882 | 103882 | 2020-05-01 | Choctaw | Alabama | 1023 | 49 | 0 |
103883 | 103883 | 2020-05-01 | Clarke | Alabama | 1025 | 34 | 1 |
103884 | 103884 | 2020-05-01 | Clay | Alabama | 1027 | 21 | 1 |
103885 | 103885 | 2020-05-01 | Cleburne | Alabama | 1029 | 12 | 1 |
103886 | 103886 | 2020-05-01 | Coffee | Alabama | 1031 | 117 | 0 |
103887 | 103887 | 2020-05-01 | Colbert | Alabama | 1033 | 33 | 2 |
103888 | 103888 | 2020-05-01 | Conecuh | Alabama | 1035 | 9 | 0 |
103889 | 103889 | 2020-05-01 | Coosa | Alabama | 1037 | 29 | 1 |
103890 | 103890 | 2020-05-01 | Covington | Alabama | 1039 | 38 | 1 |
103891 | 103891 | 2020-05-01 | Crenshaw | Alabama | 1041 | 19 | 0 |
103892 | 103892 | 2020-05-01 | Cullman | Alabama | 1043 | 57 | 0 |
103893 | 103893 | 2020-05-01 | Dale | Alabama | 1045 | 27 | 0 |
103894 | 103894 | 2020-05-01 | Dallas | Alabama | 1047 | 42 | 3 |
103895 | 103895 | 2020-05-01 | DeKalb | Alabama | 1049 | 76 | 2 |
103896 | 103896 | 2020-05-01 | Elmore | Alabama | 1051 | 88 | 2 |
103897 | 103897 | 2020-05-01 | Escambia | Alabama | 1053 | 29 | 2 |
103898 | 103898 | 2020-05-01 | Etowah | Alabama | 1055 | 139 | 10 |
103899 | 103899 | 2020-05-01 | Fayette | Alabama | 1057 | 6 | 0 |
103900 | 103900 | 2020-05-01 | Franklin | Alabama | 1059 | 78 | 0 |
103901 | 103901 | 2020-05-01 | Geneva | Alabama | 1061 | 9 | 0 |
103902 | 103902 | 2020-05-01 | Greene | Alabama | 1063 | 54 | 1 |
103903 | 103903 | 2020-05-01 | Hale | Alabama | 1065 | 50 | 2 |
103904 | 103904 | 2020-05-01 | Henry | Alabama | 1067 | 24 | 1 |
103905 | 103905 | 2020-05-01 | Houston | Alabama | 1069 | 90 | 4 |
103906 | 103906 | 2020-05-01 | Jackson | Alabama | 1071 | 49 | 2 |
103907 | 103907 | 2020-05-01 | Jefferson | Alabama | 1073 | 929 | 48 |
103908 | 103908 | 2020-05-01 | Lamar | Alabama | 1075 | 11 | 0 |
103909 | 103909 | 2020-05-01 | Lauderdale | Alabama | 1077 | 50 | 2 |
103910 | 103910 | 2020-05-01 | Lawrence | Alabama | 1079 | 13 | 0 |
103911 | 103911 | 2020-05-01 | Lee | Alabama | 1081 | 391 | 29 |
103912 | 103912 | 2020-05-01 | Limestone | Alabama | 1083 | 44 | 0 |
103913 | 103913 | 2020-05-01 | Lowndes | Alabama | 1085 | 67 | 1 |
103914 | 103914 | 2020-05-01 | Macon | Alabama | 1087 | 37 | 2 |
103915 | 103915 | 2020-05-01 | Madison | Alabama | 1089 | 225 | 4 |
103916 | 103916 | 2020-05-01 | Marengo | Alabama | 1091 | 52 | 3 |
103917 | 103917 | 2020-05-01 | Marion | Alabama | 1093 | 78 | 6 |
103918 | 103918 | 2020-05-01 | Marshall | Alabama | 1095 | 328 | 7 |
103919 | 103919 | 2020-05-01 | Mobile | Alabama | 1097 | 1099 | 61 |
103920 | 103920 | 2020-05-01 | Monroe | Alabama | 1099 | 13 | 1 |
103921 | 103921 | 2020-05-01 | Montgomery | Alabama | 1101 | 355 | 6 |
103922 | 103922 | 2020-05-01 | Morgan | Alabama | 1103 | 71 | 0 |
103923 | 103923 | 2020-05-01 | Perry | Alabama | 1105 | 10 | 0 |
103924 | 103924 | 2020-05-01 | Pickens | Alabama | 1107 | 50 | 2 |
103925 | 103925 | 2020-05-01 | Pike | Alabama | 1109 | 69 | 0 |
103926 | 103926 | 2020-05-01 | Randolph | Alabama | 1111 | 62 | 4 |
103927 | 103927 | 2020-05-01 | Russell | Alabama | 1113 | 60 | 0 |
103928 | 103928 | 2020-05-01 | Shelby | Alabama | 1117 | 320 | 13 |
103929 | 103929 | 2020-05-01 | St. Clair | Alabama | 1115 | 73 | 0 |
103930 | 103930 | 2020-05-01 | Sumter | Alabama | 1119 | 68 | 3 |
103931 | 103931 | 2020-05-01 | Talladega | Alabama | 1121 | 61 | 2 |
103932 | 103932 | 2020-05-01 | Tallapoosa | Alabama | 1123 | 286 | 18 |
103933 | 103933 | 2020-05-01 | Tuscaloosa | Alabama | 1125 | 210 | 2 |
103934 | 103934 | 2020-05-01 | Walker | Alabama | 1127 | 97 | 0 |
103935 | 103935 | 2020-05-01 | Washington | Alabama | 1129 | 35 | 2 |
103936 | 103936 | 2020-05-01 | Wilcox | Alabama | 1131 | 67 | 3 |
103937 | 103937 | 2020-05-01 | Winston | Alabama | 1133 | 15 | 0 |
103938 | 103938 | 2020-05-01 | Anchorage | Alaska | 2020 | 185 | 4 |
103939 | 103939 | 2020-05-01 | Bethel Census Area | Alaska | 2050 | 1 | 0 |
103940 | 103940 | 2020-05-01 | Fairbanks North Star Borough | Alaska | 2090 | 82 | 2 |
103941 | 103941 | 2020-05-01 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
103942 | 103942 | 2020-05-01 | Kenai Peninsula Borough | Alaska | 2122 | 20 | 0 |
103943 | 103943 | 2020-05-01 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
103944 | 103944 | 2020-05-01 | Kodiak Island Borough | Alaska | 2150 | 1 | 0 |
103945 | 103945 | 2020-05-01 | Matanuska-Susitna Borough | Alaska | 2170 | 21 | 1 |
103946 | 103946 | 2020-05-01 | Nome Census Area | Alaska | 2180 | 1 | 0 |
103947 | 103947 | 2020-05-01 | Petersburg Borough | Alaska | 2195 | 3 | 0 |
103948 | 103948 | 2020-05-01 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 2 | 0 |
103949 | 103949 | 2020-05-01 | Sitka City and Borough | Alaska | 2220 | 1 | 0 |
103950 | 103950 | 2020-05-01 | Southeast Fairbanks Census Area | Alaska | 2240 | 1 | 0 |
103951 | 103951 | 2020-05-01 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1 | 0 |
103952 | 103952 | 2020-05-01 | Apache | Arizona | 4001 | 478 | 6 |
103953 | 103953 | 2020-05-01 | Cochise | Arizona | 4003 | 39 | 0 |
103954 | 103954 | 2020-05-01 | Coconino | Arizona | 4005 | 498 | 44 |
103955 | 103955 | 2020-05-01 | Gila | Arizona | 4007 | 13 | 0 |
103956 | 103956 | 2020-05-01 | Graham | Arizona | 4009 | 17 | 0 |
103957 | 103957 | 2020-05-01 | Greenlee | Arizona | 4011 | 2 | 0 |
103958 | 103958 | 2020-05-01 | La Paz | Arizona | 4012 | 15 | 2 |
103959 | 103959 | 2020-05-01 | Maricopa | Arizona | 4013 | 4156 | 147 |
103960 | 103960 | 2020-05-01 | Mohave | Arizona | 4015 | 122 | 13 |
103961 | 103961 | 2020-05-01 | Navajo | Arizona | 4017 | 741 | 21 |
103962 | 103962 | 2020-05-01 | Pima | Arizona | 4019 | 1267 | 81 |
103963 | 103963 | 2020-05-01 | Pinal | Arizona | 4021 | 417 | 13 |
103964 | 103964 | 2020-05-01 | Santa Cruz | Arizona | 4023 | 33 | 0 |
103965 | 103965 | 2020-05-01 | Yavapai | Arizona | 4025 | 82 | 2 |
103966 | 103966 | 2020-05-01 | Yuma | Arizona | 4027 | 82 | 1 |
103967 | 103967 | 2020-05-01 | Arkansas | Arkansas | 5001 | 2 | 0 |
103968 | 103968 | 2020-05-01 | Ashley | Arkansas | 5003 | 16 | 0 |
103969 | 103969 | 2020-05-01 | Baxter | Arkansas | 5005 | 5 | 0 |
103970 | 103970 | 2020-05-01 | Benton | Arkansas | 5007 | 101 | 0 |
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);