ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,221 rows where date = "2020-04-01" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Georgia 143
- Texas 135
- Virginia 98
- Tennessee 84
- Indiana 83
- North Carolina 78
- Mississippi 77
- Ohio 72
- Missouri 71
- Kentucky 69
- Michigan 68
- Alabama 62
- Louisiana 61
- Iowa 60
- Pennsylvania 60
- Florida 59
- New York 58
- Illinois 57
- Arkansas 56
- Minnesota 56
- California 51
- Colorado 51
- Wisconsin 50
- Oklahoma 49
- Kansas 43
- South Carolina 43
- Washington 34
- West Virginia 30
- Idaho 29
- South Dakota 29
- …
fips >30
county >30
- Unknown 33
- Washington 27
- Franklin 20
- Jefferson 19
- Jackson 17
- Lincoln 17
- Madison 16
- Montgomery 16
- Union 14
- Clay 13
- Carroll 12
- Warren 12
- Greene 11
- Marion 11
- Monroe 11
- Crawford 10
- Douglas 10
- Fayette 10
- Clark 9
- Grant 9
- Johnson 9
- Lawrence 9
- Marshall 9
- Morgan 9
- Adams 8
- Benton 8
- Columbia 8
- Henry 8
- Lee 8
- Orange 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
23881 | 23881 | 2020-04-01 | Autauga | Alabama | 1001 | 10 | 0 |
23882 | 23882 | 2020-04-01 | Baldwin | Alabama | 1003 | 23 | 1 |
23883 | 23883 | 2020-04-01 | Bibb | Alabama | 1007 | 3 | 0 |
23884 | 23884 | 2020-04-01 | Blount | Alabama | 1009 | 5 | 0 |
23885 | 23885 | 2020-04-01 | Bullock | Alabama | 1011 | 3 | 0 |
23886 | 23886 | 2020-04-01 | Butler | Alabama | 1013 | 1 | 0 |
23887 | 23887 | 2020-04-01 | Calhoun | Alabama | 1015 | 11 | 0 |
23888 | 23888 | 2020-04-01 | Chambers | Alabama | 1017 | 45 | 4 |
23889 | 23889 | 2020-04-01 | Cherokee | Alabama | 1019 | 2 | 0 |
23890 | 23890 | 2020-04-01 | Chilton | Alabama | 1021 | 13 | 0 |
23891 | 23891 | 2020-04-01 | Choctaw | Alabama | 1023 | 4 | 0 |
23892 | 23892 | 2020-04-01 | Clarke | Alabama | 1025 | 2 | 0 |
23893 | 23893 | 2020-04-01 | Clay | Alabama | 1027 | 3 | 0 |
23894 | 23894 | 2020-04-01 | Cleburne | Alabama | 1029 | 6 | 0 |
23895 | 23895 | 2020-04-01 | Colbert | Alabama | 1033 | 4 | 0 |
23896 | 23896 | 2020-04-01 | Conecuh | Alabama | 1035 | 1 | 0 |
23897 | 23897 | 2020-04-01 | Coosa | Alabama | 1037 | 4 | 0 |
23898 | 23898 | 2020-04-01 | Covington | Alabama | 1039 | 3 | 0 |
23899 | 23899 | 2020-04-01 | Crenshaw | Alabama | 1041 | 1 | 0 |
23900 | 23900 | 2020-04-01 | Cullman | Alabama | 1043 | 9 | 1 |
23901 | 23901 | 2020-04-01 | Dale | Alabama | 1045 | 1 | 0 |
23902 | 23902 | 2020-04-01 | Dallas | Alabama | 1047 | 3 | 0 |
23903 | 23903 | 2020-04-01 | DeKalb | Alabama | 1049 | 6 | 0 |
23904 | 23904 | 2020-04-01 | Elmore | Alabama | 1051 | 15 | 0 |
23905 | 23905 | 2020-04-01 | Escambia | Alabama | 1053 | 1 | 0 |
23906 | 23906 | 2020-04-01 | Etowah | Alabama | 1055 | 10 | 1 |
23907 | 23907 | 2020-04-01 | Fayette | Alabama | 1057 | 1 | 0 |
23908 | 23908 | 2020-04-01 | Franklin | Alabama | 1059 | 3 | 0 |
23909 | 23909 | 2020-04-01 | Greene | Alabama | 1063 | 4 | 0 |
23910 | 23910 | 2020-04-01 | Hale | Alabama | 1065 | 1 | 0 |
23911 | 23911 | 2020-04-01 | Houston | Alabama | 1069 | 9 | 1 |
23912 | 23912 | 2020-04-01 | Jackson | Alabama | 1071 | 8 | 1 |
23913 | 23913 | 2020-04-01 | Jefferson | Alabama | 1073 | 305 | 4 |
23914 | 23914 | 2020-04-01 | Lamar | Alabama | 1075 | 1 | 0 |
23915 | 23915 | 2020-04-01 | Lauderdale | Alabama | 1077 | 12 | 1 |
23916 | 23916 | 2020-04-01 | Lawrence | Alabama | 1079 | 3 | 0 |
23917 | 23917 | 2020-04-01 | Lee | Alabama | 1081 | 83 | 2 |
23918 | 23918 | 2020-04-01 | Limestone | Alabama | 1083 | 23 | 0 |
23919 | 23919 | 2020-04-01 | Lowndes | Alabama | 1085 | 1 | 0 |
23920 | 23920 | 2020-04-01 | Macon | Alabama | 1087 | 2 | 0 |
23921 | 23921 | 2020-04-01 | Madison | Alabama | 1089 | 107 | 1 |
23922 | 23922 | 2020-04-01 | Marengo | Alabama | 1091 | 5 | 0 |
23923 | 23923 | 2020-04-01 | Marion | Alabama | 1093 | 11 | 2 |
23924 | 23924 | 2020-04-01 | Marshall | Alabama | 1095 | 6 | 0 |
23925 | 23925 | 2020-04-01 | Mobile | Alabama | 1097 | 57 | 3 |
23926 | 23926 | 2020-04-01 | Monroe | Alabama | 1099 | 3 | 0 |
23927 | 23927 | 2020-04-01 | Montgomery | Alabama | 1101 | 35 | 1 |
23928 | 23928 | 2020-04-01 | Morgan | Alabama | 1103 | 20 | 0 |
23929 | 23929 | 2020-04-01 | Pickens | Alabama | 1107 | 4 | 0 |
23930 | 23930 | 2020-04-01 | Pike | Alabama | 1109 | 7 | 0 |
23931 | 23931 | 2020-04-01 | Randolph | Alabama | 1111 | 5 | 0 |
23932 | 23932 | 2020-04-01 | Russell | Alabama | 1113 | 2 | 0 |
23933 | 23933 | 2020-04-01 | Shelby | Alabama | 1117 | 89 | 3 |
23934 | 23934 | 2020-04-01 | St. Clair | Alabama | 1115 | 17 | 0 |
23935 | 23935 | 2020-04-01 | Sumter | Alabama | 1119 | 3 | 0 |
23936 | 23936 | 2020-04-01 | Talladega | Alabama | 1121 | 8 | 0 |
23937 | 23937 | 2020-04-01 | Tallapoosa | Alabama | 1123 | 14 | 1 |
23938 | 23938 | 2020-04-01 | Tuscaloosa | Alabama | 1125 | 30 | 0 |
23939 | 23939 | 2020-04-01 | Walker | Alabama | 1127 | 32 | 0 |
23940 | 23940 | 2020-04-01 | Washington | Alabama | 1129 | 3 | 1 |
23941 | 23941 | 2020-04-01 | Wilcox | Alabama | 1131 | 3 | 0 |
23942 | 23942 | 2020-04-01 | Winston | Alabama | 1133 | 2 | 0 |
23943 | 23943 | 2020-04-01 | Anchorage | Alaska | 2020 | 67 | 2 |
23944 | 23944 | 2020-04-01 | Fairbanks North Star Borough | Alaska | 2090 | 40 | 0 |
23945 | 23945 | 2020-04-01 | Juneau City and Borough | Alaska | 2110 | 10 | 0 |
23946 | 23946 | 2020-04-01 | Kenai Peninsula Borough | Alaska | 2122 | 8 | 0 |
23947 | 23947 | 2020-04-01 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
23948 | 23948 | 2020-04-01 | Matanuska-Susitna Borough | Alaska | 2170 | 4 | 0 |
23949 | 23949 | 2020-04-01 | Apache | Arizona | 4001 | 17 | 0 |
23950 | 23950 | 2020-04-01 | Cochise | Arizona | 4003 | 4 | 0 |
23951 | 23951 | 2020-04-01 | Coconino | Arizona | 4005 | 85 | 3 |
23952 | 23952 | 2020-04-01 | Gila | Arizona | 4007 | 1 | 0 |
23953 | 23953 | 2020-04-01 | Graham | Arizona | 4009 | 2 | 0 |
23954 | 23954 | 2020-04-01 | Greenlee | Arizona | 4011 | 1 | 0 |
23955 | 23955 | 2020-04-01 | La Paz | Arizona | 4012 | 2 | 0 |
23956 | 23956 | 2020-04-01 | Maricopa | Arizona | 4013 | 871 | 8 |
23957 | 23957 | 2020-04-01 | Mohave | Arizona | 4015 | 7 | 0 |
23958 | 23958 | 2020-04-01 | Navajo | Arizona | 4017 | 102 | 0 |
23959 | 23959 | 2020-04-01 | Pima | Arizona | 4019 | 217 | 10 |
23960 | 23960 | 2020-04-01 | Pinal | Arizona | 4021 | 65 | 0 |
23961 | 23961 | 2020-04-01 | Santa Cruz | Arizona | 4023 | 3 | 0 |
23962 | 23962 | 2020-04-01 | Unknown | Arizona | 0 | 8 | |
23963 | 23963 | 2020-04-01 | Yavapai | Arizona | 4025 | 24 | 0 |
23964 | 23964 | 2020-04-01 | Yuma | Arizona | 4027 | 12 | 0 |
23965 | 23965 | 2020-04-01 | Arkansas | Arkansas | 5001 | 2 | 0 |
23966 | 23966 | 2020-04-01 | Ashley | Arkansas | 5003 | 2 | 0 |
23967 | 23967 | 2020-04-01 | Baxter | Arkansas | 5005 | 3 | 0 |
23968 | 23968 | 2020-04-01 | Benton | Arkansas | 5007 | 40 | 0 |
23969 | 23969 | 2020-04-01 | Boone | Arkansas | 5009 | 3 | 0 |
23970 | 23970 | 2020-04-01 | Bradley | Arkansas | 5011 | 4 | 0 |
23971 | 23971 | 2020-04-01 | Carroll | Arkansas | 5015 | 1 | 0 |
23972 | 23972 | 2020-04-01 | Chicot | Arkansas | 5017 | 2 | 0 |
23973 | 23973 | 2020-04-01 | Clark | Arkansas | 5019 | 26 | 0 |
23974 | 23974 | 2020-04-01 | Cleburne | Arkansas | 5023 | 63 | 3 |
23975 | 23975 | 2020-04-01 | Cleveland | Arkansas | 5025 | 5 | 0 |
23976 | 23976 | 2020-04-01 | Columbia | Arkansas | 5027 | 2 | 0 |
23977 | 23977 | 2020-04-01 | Conway | Arkansas | 5029 | 3 | 1 |
23978 | 23978 | 2020-04-01 | Craighead | Arkansas | 5031 | 13 | 0 |
23979 | 23979 | 2020-04-01 | Crawford | Arkansas | 5033 | 3 | 0 |
23980 | 23980 | 2020-04-01 | Crittenden | Arkansas | 5035 | 31 | 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);