ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,808 rows where date = "2020-04-24" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 204
- Georgia 158
- Virginia 127
- Kentucky 111
- Missouri 99
- Illinois 97
- North Carolina 93
- Tennessee 93
- Indiana 92
- Ohio 87
- Iowa 85
- Mississippi 81
- Michigan 80
- Minnesota 79
- Kansas 76
- Arkansas 73
- Oklahoma 69
- Alabama 67
- Florida 67
- Pennsylvania 67
- Wisconsin 66
- Louisiana 65
- New York 58
- Colorado 57
- Nebraska 55
- California 53
- West Virginia 48
- South Carolina 46
- South Dakota 41
- Washington 38
- …
fips >30
county >30
- Washington 30
- Jefferson 25
- Franklin 24
- Unknown 24
- Jackson 22
- Lincoln 21
- Madison 19
- Clay 17
- Marion 17
- Montgomery 17
- Union 17
- Monroe 15
- Greene 14
- Warren 14
- Carroll 13
- Wayne 13
- Grant 12
- Johnson 12
- Polk 12
- Clark 11
- Crawford 11
- Fayette 11
- Lee 11
- Marshall 11
- Morgan 11
- Adams 10
- Douglas 10
- Hamilton 10
- Henry 10
- Lake 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
84049 | 84049 | 2020-04-24 | Autauga | Alabama | 1001 | 36 | 2 |
84050 | 84050 | 2020-04-24 | Baldwin | Alabama | 1003 | 147 | 3 |
84051 | 84051 | 2020-04-24 | Barbour | Alabama | 1005 | 32 | 0 |
84052 | 84052 | 2020-04-24 | Bibb | Alabama | 1007 | 34 | 0 |
84053 | 84053 | 2020-04-24 | Blount | Alabama | 1009 | 31 | 0 |
84054 | 84054 | 2020-04-24 | Bullock | Alabama | 1011 | 12 | 0 |
84055 | 84055 | 2020-04-24 | Butler | Alabama | 1013 | 21 | 0 |
84056 | 84056 | 2020-04-24 | Calhoun | Alabama | 1015 | 89 | 3 |
84057 | 84057 | 2020-04-24 | Chambers | Alabama | 1017 | 282 | 17 |
84058 | 84058 | 2020-04-24 | Cherokee | Alabama | 1019 | 12 | 0 |
84059 | 84059 | 2020-04-24 | Chilton | Alabama | 1021 | 49 | 1 |
84060 | 84060 | 2020-04-24 | Choctaw | Alabama | 1023 | 25 | 0 |
84061 | 84061 | 2020-04-24 | Clarke | Alabama | 1025 | 24 | 1 |
84062 | 84062 | 2020-04-24 | Clay | Alabama | 1027 | 19 | 1 |
84063 | 84063 | 2020-04-24 | Cleburne | Alabama | 1029 | 12 | 1 |
84064 | 84064 | 2020-04-24 | Coffee | Alabama | 1031 | 87 | 0 |
84065 | 84065 | 2020-04-24 | Colbert | Alabama | 1033 | 23 | 2 |
84066 | 84066 | 2020-04-24 | Conecuh | Alabama | 1035 | 9 | 0 |
84067 | 84067 | 2020-04-24 | Coosa | Alabama | 1037 | 29 | 1 |
84068 | 84068 | 2020-04-24 | Covington | Alabama | 1039 | 31 | 0 |
84069 | 84069 | 2020-04-24 | Crenshaw | Alabama | 1041 | 10 | 0 |
84070 | 84070 | 2020-04-24 | Cullman | Alabama | 1043 | 47 | 0 |
84071 | 84071 | 2020-04-24 | Dale | Alabama | 1045 | 23 | 0 |
84072 | 84072 | 2020-04-24 | Dallas | Alabama | 1047 | 32 | 2 |
84073 | 84073 | 2020-04-24 | DeKalb | Alabama | 1049 | 61 | 2 |
84074 | 84074 | 2020-04-24 | Elmore | Alabama | 1051 | 74 | 1 |
84075 | 84075 | 2020-04-24 | Escambia | Alabama | 1053 | 22 | 1 |
84076 | 84076 | 2020-04-24 | Etowah | Alabama | 1055 | 121 | 8 |
84077 | 84077 | 2020-04-24 | Fayette | Alabama | 1057 | 4 | 0 |
84078 | 84078 | 2020-04-24 | Franklin | Alabama | 1059 | 32 | 0 |
84079 | 84079 | 2020-04-24 | Geneva | Alabama | 1061 | 6 | 0 |
84080 | 84080 | 2020-04-24 | Greene | Alabama | 1063 | 44 | 0 |
84081 | 84081 | 2020-04-24 | Hale | Alabama | 1065 | 39 | 2 |
84082 | 84082 | 2020-04-24 | Henry | Alabama | 1067 | 22 | 1 |
84083 | 84083 | 2020-04-24 | Houston | Alabama | 1069 | 76 | 3 |
84084 | 84084 | 2020-04-24 | Jackson | Alabama | 1071 | 45 | 2 |
84085 | 84085 | 2020-04-24 | Jefferson | Alabama | 1073 | 797 | 33 |
84086 | 84086 | 2020-04-24 | Lamar | Alabama | 1075 | 10 | 0 |
84087 | 84087 | 2020-04-24 | Lauderdale | Alabama | 1077 | 25 | 2 |
84088 | 84088 | 2020-04-24 | Lawrence | Alabama | 1079 | 12 | 0 |
84089 | 84089 | 2020-04-24 | Lee | Alabama | 1081 | 351 | 22 |
84090 | 84090 | 2020-04-24 | Limestone | Alabama | 1083 | 41 | 0 |
84091 | 84091 | 2020-04-24 | Lowndes | Alabama | 1085 | 36 | 1 |
84092 | 84092 | 2020-04-24 | Macon | Alabama | 1087 | 29 | 2 |
84093 | 84093 | 2020-04-24 | Madison | Alabama | 1089 | 202 | 4 |
84094 | 84094 | 2020-04-24 | Marengo | Alabama | 1091 | 39 | 3 |
84095 | 84095 | 2020-04-24 | Marion | Alabama | 1093 | 69 | 5 |
84096 | 84096 | 2020-04-24 | Marshall | Alabama | 1095 | 267 | 4 |
84097 | 84097 | 2020-04-24 | Mobile | Alabama | 1097 | 845 | 40 |
84098 | 84098 | 2020-04-24 | Monroe | Alabama | 1099 | 11 | 1 |
84099 | 84099 | 2020-04-24 | Montgomery | Alabama | 1101 | 274 | 4 |
84100 | 84100 | 2020-04-24 | Morgan | Alabama | 1103 | 55 | 0 |
84101 | 84101 | 2020-04-24 | Perry | Alabama | 1105 | 9 | 0 |
84102 | 84102 | 2020-04-24 | Pickens | Alabama | 1107 | 45 | 1 |
84103 | 84103 | 2020-04-24 | Pike | Alabama | 1109 | 58 | 0 |
84104 | 84104 | 2020-04-24 | Randolph | Alabama | 1111 | 60 | 4 |
84105 | 84105 | 2020-04-24 | Russell | Alabama | 1113 | 53 | 0 |
84106 | 84106 | 2020-04-24 | Shelby | Alabama | 1117 | 294 | 7 |
84107 | 84107 | 2020-04-24 | St. Clair | Alabama | 1115 | 63 | 0 |
84108 | 84108 | 2020-04-24 | Sumter | Alabama | 1119 | 51 | 1 |
84109 | 84109 | 2020-04-24 | Talladega | Alabama | 1121 | 54 | 2 |
84110 | 84110 | 2020-04-24 | Tallapoosa | Alabama | 1123 | 261 | 17 |
84111 | 84111 | 2020-04-24 | Tuscaloosa | Alabama | 1125 | 182 | 0 |
84112 | 84112 | 2020-04-24 | Walker | Alabama | 1127 | 89 | 0 |
84113 | 84113 | 2020-04-24 | Washington | Alabama | 1129 | 19 | 1 |
84114 | 84114 | 2020-04-24 | Wilcox | Alabama | 1131 | 53 | 1 |
84115 | 84115 | 2020-04-24 | Winston | Alabama | 1133 | 10 | 0 |
84116 | 84116 | 2020-04-24 | Anchorage | Alaska | 2020 | 168 | 4 |
84117 | 84117 | 2020-04-24 | Bethel Census Area | Alaska | 2050 | 1 | 0 |
84118 | 84118 | 2020-04-24 | Fairbanks North Star Borough | Alaska | 2090 | 79 | 2 |
84119 | 84119 | 2020-04-24 | Juneau City and Borough | Alaska | 2110 | 27 | 0 |
84120 | 84120 | 2020-04-24 | Kenai Peninsula Borough | Alaska | 2122 | 18 | 0 |
84121 | 84121 | 2020-04-24 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
84122 | 84122 | 2020-04-24 | Kodiak Island Borough | Alaska | 2150 | 1 | 0 |
84123 | 84123 | 2020-04-24 | Matanuska-Susitna Borough | Alaska | 2170 | 20 | 1 |
84124 | 84124 | 2020-04-24 | Nome Census Area | Alaska | 2180 | 1 | 0 |
84125 | 84125 | 2020-04-24 | Petersburg Borough | Alaska | 2195 | 2 | 0 |
84126 | 84126 | 2020-04-24 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 2 | 0 |
84127 | 84127 | 2020-04-24 | Southeast Fairbanks Census Area | Alaska | 2240 | 1 | 0 |
84128 | 84128 | 2020-04-24 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1 | 0 |
84129 | 84129 | 2020-04-24 | Apache | Arizona | 4001 | 296 | 5 |
84130 | 84130 | 2020-04-24 | Cochise | Arizona | 4003 | 34 | 0 |
84131 | 84131 | 2020-04-24 | Coconino | Arizona | 4005 | 391 | 36 |
84132 | 84132 | 2020-04-24 | Gila | Arizona | 4007 | 11 | 0 |
84133 | 84133 | 2020-04-24 | Graham | Arizona | 4009 | 7 | 0 |
84134 | 84134 | 2020-04-24 | Greenlee | Arizona | 4011 | 2 | 0 |
84135 | 84135 | 2020-04-24 | La Paz | Arizona | 4012 | 8 | 1 |
84136 | 84136 | 2020-04-24 | Maricopa | Arizona | 4013 | 3116 | 120 |
84137 | 84137 | 2020-04-24 | Mohave | Arizona | 4015 | 73 | 3 |
84138 | 84138 | 2020-04-24 | Navajo | Arizona | 4017 | 583 | 18 |
84139 | 84139 | 2020-04-24 | Pima | Arizona | 4019 | 1060 | 74 |
84140 | 84140 | 2020-04-24 | Pinal | Arizona | 4021 | 317 | 9 |
84141 | 84141 | 2020-04-24 | Santa Cruz | Arizona | 4023 | 30 | 0 |
84142 | 84142 | 2020-04-24 | Yavapai | Arizona | 4025 | 75 | 1 |
84143 | 84143 | 2020-04-24 | Yuma | Arizona | 4027 | 42 | 1 |
84144 | 84144 | 2020-04-24 | Arkansas | Arkansas | 5001 | 2 | 0 |
84145 | 84145 | 2020-04-24 | Ashley | Arkansas | 5003 | 13 | 0 |
84146 | 84146 | 2020-04-24 | Baxter | Arkansas | 5005 | 5 | 0 |
84147 | 84147 | 2020-04-24 | Benton | Arkansas | 5007 | 77 | 0 |
84148 | 84148 | 2020-04-24 | Boone | Arkansas | 5009 | 4 | 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);