ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,236 rows where date = "2020-09-17" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 251
- Georgia 160
- Virginia 133
- Kentucky 120
- Missouri 117
- Kansas 105
- Illinois 103
- Iowa 100
- North Carolina 100
- Tennessee 96
- Indiana 92
- Nebraska 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 63
- California 58
- New York 58
- West Virginia 55
- Montana 54
- …
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 |
---|---|---|---|---|---|---|---|
540897 | 540897 | 2020-09-17 | Autauga | Alabama | 1001 | 1624 | 24 |
540898 | 540898 | 2020-09-17 | Baldwin | Alabama | 1003 | 5021 | 48 |
540899 | 540899 | 2020-09-17 | Barbour | Alabama | 1005 | 809 | 7 |
540900 | 540900 | 2020-09-17 | Bibb | Alabama | 1007 | 617 | 9 |
540901 | 540901 | 2020-09-17 | Blount | Alabama | 1009 | 1504 | 13 |
540902 | 540902 | 2020-09-17 | Bullock | Alabama | 1011 | 585 | 14 |
540903 | 540903 | 2020-09-17 | Butler | Alabama | 1013 | 902 | 38 |
540904 | 540904 | 2020-09-17 | Calhoun | Alabama | 1015 | 3211 | 39 |
540905 | 540905 | 2020-09-17 | Chambers | Alabama | 1017 | 1106 | 42 |
540906 | 540906 | 2020-09-17 | Cherokee | Alabama | 1019 | 528 | 16 |
540907 | 540907 | 2020-09-17 | Chilton | Alabama | 1021 | 1433 | 25 |
540908 | 540908 | 2020-09-17 | Choctaw | Alabama | 1023 | 342 | 12 |
540909 | 540909 | 2020-09-17 | Clarke | Alabama | 1025 | 1044 | 17 |
540910 | 540910 | 2020-09-17 | Clay | Alabama | 1027 | 518 | 7 |
540911 | 540911 | 2020-09-17 | Cleburne | Alabama | 1029 | 311 | 6 |
540912 | 540912 | 2020-09-17 | Coffee | Alabama | 1031 | 1238 | 8 |
540913 | 540913 | 2020-09-17 | Colbert | Alabama | 1033 | 1572 | 24 |
540914 | 540914 | 2020-09-17 | Conecuh | Alabama | 1035 | 516 | 11 |
540915 | 540915 | 2020-09-17 | Coosa | Alabama | 1037 | 157 | 3 |
540916 | 540916 | 2020-09-17 | Covington | Alabama | 1039 | 1270 | 27 |
540917 | 540917 | 2020-09-17 | Crenshaw | Alabama | 1041 | 515 | 31 |
540918 | 540918 | 2020-09-17 | Cullman | Alabama | 1043 | 1800 | 17 |
540919 | 540919 | 2020-09-17 | Dale | Alabama | 1045 | 1280 | 42 |
540920 | 540920 | 2020-09-17 | Dallas | Alabama | 1047 | 1725 | 26 |
540921 | 540921 | 2020-09-17 | DeKalb | Alabama | 1049 | 2301 | 19 |
540922 | 540922 | 2020-09-17 | Elmore | Alabama | 1051 | 2475 | 47 |
540923 | 540923 | 2020-09-17 | Escambia | Alabama | 1053 | 1543 | 24 |
540924 | 540924 | 2020-09-17 | Etowah | Alabama | 1055 | 3263 | 44 |
540925 | 540925 | 2020-09-17 | Fayette | Alabama | 1057 | 412 | 8 |
540926 | 540926 | 2020-09-17 | Franklin | Alabama | 1059 | 1727 | 28 |
540927 | 540927 | 2020-09-17 | Geneva | Alabama | 1061 | 540 | 4 |
540928 | 540928 | 2020-09-17 | Greene | Alabama | 1063 | 299 | 15 |
540929 | 540929 | 2020-09-17 | Hale | Alabama | 1065 | 608 | 28 |
540930 | 540930 | 2020-09-17 | Henry | Alabama | 1067 | 452 | 4 |
540931 | 540931 | 2020-09-17 | Houston | Alabama | 1069 | 2606 | 21 |
540932 | 540932 | 2020-09-17 | Jackson | Alabama | 1071 | 1466 | 10 |
540933 | 540933 | 2020-09-17 | Jefferson | Alabama | 1073 | 18648 | 332 |
540934 | 540934 | 2020-09-17 | Lamar | Alabama | 1075 | 330 | 2 |
540935 | 540935 | 2020-09-17 | Lauderdale | Alabama | 1077 | 1592 | 31 |
540936 | 540936 | 2020-09-17 | Lawrence | Alabama | 1079 | 576 | 20 |
540937 | 540937 | 2020-09-17 | Lee | Alabama | 1081 | 5582 | 59 |
540938 | 540938 | 2020-09-17 | Limestone | Alabama | 1083 | 1919 | 19 |
540939 | 540939 | 2020-09-17 | Lowndes | Alabama | 1085 | 643 | 27 |
540940 | 540940 | 2020-09-17 | Macon | Alabama | 1087 | 466 | 19 |
540941 | 540941 | 2020-09-17 | Madison | Alabama | 1089 | 7365 | 73 |
540942 | 540942 | 2020-09-17 | Marengo | Alabama | 1091 | 693 | 19 |
540943 | 540943 | 2020-09-17 | Marion | Alabama | 1093 | 914 | 28 |
540944 | 540944 | 2020-09-17 | Marshall | Alabama | 1095 | 3763 | 42 |
540945 | 540945 | 2020-09-17 | Mobile | Alabama | 1097 | 12949 | 288 |
540946 | 540946 | 2020-09-17 | Monroe | Alabama | 1099 | 570 | 8 |
540947 | 540947 | 2020-09-17 | Montgomery | Alabama | 1101 | 8560 | 170 |
540948 | 540948 | 2020-09-17 | Morgan | Alabama | 1103 | 3129 | 25 |
540949 | 540949 | 2020-09-17 | Perry | Alabama | 1105 | 535 | 6 |
540950 | 540950 | 2020-09-17 | Pickens | Alabama | 1107 | 622 | 14 |
540951 | 540951 | 2020-09-17 | Pike | Alabama | 1109 | 1132 | 9 |
540952 | 540952 | 2020-09-17 | Randolph | Alabama | 1111 | 585 | 12 |
540953 | 540953 | 2020-09-17 | Russell | Alabama | 1113 | 1691 | 2 |
540954 | 540954 | 2020-09-17 | Shelby | Alabama | 1117 | 5501 | 49 |
540955 | 540955 | 2020-09-17 | St. Clair | Alabama | 1115 | 2181 | 34 |
540956 | 540956 | 2020-09-17 | Sumter | Alabama | 1119 | 417 | 19 |
540957 | 540957 | 2020-09-17 | Talladega | Alabama | 1121 | 1999 | 25 |
540958 | 540958 | 2020-09-17 | Tallapoosa | Alabama | 1123 | 1124 | 83 |
540959 | 540959 | 2020-09-17 | Tuscaloosa | Alabama | 1125 | 7015 | 112 |
540960 | 540960 | 2020-09-17 | Walker | Alabama | 1127 | 2177 | 80 |
540961 | 540961 | 2020-09-17 | Washington | Alabama | 1129 | 545 | 13 |
540962 | 540962 | 2020-09-17 | Wilcox | Alabama | 1131 | 529 | 11 |
540963 | 540963 | 2020-09-17 | Winston | Alabama | 1133 | 685 | 12 |
540964 | 540964 | 2020-09-17 | Aleutians East Borough | Alaska | 2013 | 11 | 0 |
540965 | 540965 | 2020-09-17 | Aleutians West Census Area | Alaska | 2016 | 93 | 0 |
540966 | 540966 | 2020-09-17 | Anchorage | Alaska | 2020 | 3823 | 27 |
540967 | 540967 | 2020-09-17 | Bethel Census Area | Alaska | 2050 | 91 | 1 |
540968 | 540968 | 2020-09-17 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 88 | 0 |
540969 | 540969 | 2020-09-17 | Denali Borough | Alaska | 2068 | 5 | 0 |
540970 | 540970 | 2020-09-17 | Dillingham Census Area | Alaska | 2070 | 28 | 0 |
540971 | 540971 | 2020-09-17 | Fairbanks North Star Borough | Alaska | 2090 | 971 | 9 |
540972 | 540972 | 2020-09-17 | Haines Borough | Alaska | 2100 | 10 | 0 |
540973 | 540973 | 2020-09-17 | Juneau City and Borough | Alaska | 2110 | 342 | 0 |
540974 | 540974 | 2020-09-17 | Kenai Peninsula Borough | Alaska | 2122 | 607 | 1 |
540975 | 540975 | 2020-09-17 | Ketchikan Gateway Borough | Alaska | 2130 | 68 | 0 |
540976 | 540976 | 2020-09-17 | Kodiak Island Borough | Alaska | 2150 | 64 | 0 |
540977 | 540977 | 2020-09-17 | Kusilvak Census Area | Alaska | 2158 | 11 | 0 |
540978 | 540978 | 2020-09-17 | Matanuska-Susitna Borough | Alaska | 2170 | 568 | 2 |
540979 | 540979 | 2020-09-17 | Nome Census Area | Alaska | 2180 | 55 | 0 |
540980 | 540980 | 2020-09-17 | North Slope Borough | Alaska | 2185 | 80 | 0 |
540981 | 540981 | 2020-09-17 | Northwest Arctic Borough | Alaska | 2188 | 82 | 0 |
540982 | 540982 | 2020-09-17 | Petersburg Borough | Alaska | 2195 | 11 | 0 |
540983 | 540983 | 2020-09-17 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 30 | 0 |
540984 | 540984 | 2020-09-17 | Sitka City and Borough | Alaska | 2220 | 53 | 0 |
540985 | 540985 | 2020-09-17 | Southeast Fairbanks Census Area | Alaska | 2240 | 35 | 0 |
540986 | 540986 | 2020-09-17 | Unknown | Alaska | 41 | 0 | |
540987 | 540987 | 2020-09-17 | Valdez-Cordova Census Area | Alaska | 2261 | 123 | 0 |
540988 | 540988 | 2020-09-17 | Wrangell City and Borough | Alaska | 2275 | 19 | 0 |
540989 | 540989 | 2020-09-17 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 26 | 0 |
540990 | 540990 | 2020-09-17 | Yukon-Koyukuk Census Area | Alaska | 2290 | 78 | 1 |
540991 | 540991 | 2020-09-17 | Apache | Arizona | 4001 | 3417 | 159 |
540992 | 540992 | 2020-09-17 | Cochise | Arizona | 4003 | 1878 | 71 |
540993 | 540993 | 2020-09-17 | Coconino | Arizona | 4005 | 3644 | 133 |
540994 | 540994 | 2020-09-17 | Gila | Arizona | 4007 | 1208 | 51 |
540995 | 540995 | 2020-09-17 | Graham | Arizona | 4009 | 786 | 24 |
540996 | 540996 | 2020-09-17 | Greenlee | Arizona | 4011 | 58 | 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);