ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,150 rows where date = "2020-06-30" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 244
- Georgia 160
- Virginia 132
- Kentucky 119
- Missouri 116
- Illinois 102
- Iowa 100
- North Carolina 100
- Kansas 96
- Tennessee 95
- Indiana 92
- Ohio 88
- Minnesota 87
- Michigan 83
- Mississippi 82
- Puerto Rico 79
- Nebraska 78
- Oklahoma 76
- Arkansas 75
- Wisconsin 73
- Florida 68
- Alabama 67
- Pennsylvania 67
- Louisiana 65
- Colorado 61
- South Dakota 59
- New York 58
- California 57
- West Virginia 53
- North Dakota 50
- …
fips >30
county >30
- Washington 31
- Jefferson 26
- Unknown 26
- Franklin 25
- Jackson 24
- Lincoln 23
- Madison 20
- Clay 18
- Montgomery 18
- Union 18
- Marion 17
- Monroe 17
- Wayne 15
- Grant 14
- Greene 14
- Warren 14
- Carroll 13
- Douglas 12
- Johnson 12
- Lake 12
- Lee 12
- Marshall 12
- Polk 12
- Adams 11
- Clark 11
- Crawford 11
- Fayette 11
- Lawrence 11
- Morgan 11
- Calhoun 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
287080 | 287080 | 2020-06-30 | Autauga | Alabama | 1001 | 537 | 12 |
287081 | 287081 | 2020-06-30 | Baldwin | Alabama | 1003 | 680 | 10 |
287082 | 287082 | 2020-06-30 | Barbour | Alabama | 1005 | 325 | 1 |
287083 | 287083 | 2020-06-30 | Bibb | Alabama | 1007 | 170 | 1 |
287084 | 287084 | 2020-06-30 | Blount | Alabama | 1009 | 208 | 1 |
287085 | 287085 | 2020-06-30 | Bullock | Alabama | 1011 | 365 | 10 |
287086 | 287086 | 2020-06-30 | Butler | Alabama | 1013 | 607 | 27 |
287087 | 287087 | 2020-06-30 | Calhoun | Alabama | 1015 | 276 | 5 |
287088 | 287088 | 2020-06-30 | Chambers | Alabama | 1017 | 590 | 27 |
287089 | 287089 | 2020-06-30 | Cherokee | Alabama | 1019 | 74 | 7 |
287090 | 287090 | 2020-06-30 | Chilton | Alabama | 1021 | 214 | 3 |
287091 | 287091 | 2020-06-30 | Choctaw | Alabama | 1023 | 192 | 12 |
287092 | 287092 | 2020-06-30 | Clarke | Alabama | 1025 | 265 | 5 |
287093 | 287093 | 2020-06-30 | Clay | Alabama | 1027 | 53 | 2 |
287094 | 287094 | 2020-06-30 | Cleburne | Alabama | 1029 | 29 | 1 |
287095 | 287095 | 2020-06-30 | Coffee | Alabama | 1031 | 357 | 2 |
287096 | 287096 | 2020-06-30 | Colbert | Alabama | 1033 | 372 | 5 |
287097 | 287097 | 2020-06-30 | Conecuh | Alabama | 1035 | 180 | 6 |
287098 | 287098 | 2020-06-30 | Coosa | Alabama | 1037 | 55 | 1 |
287099 | 287099 | 2020-06-30 | Covington | Alabama | 1039 | 316 | 7 |
287100 | 287100 | 2020-06-30 | Crenshaw | Alabama | 1041 | 126 | 3 |
287101 | 287101 | 2020-06-30 | Cullman | Alabama | 1043 | 408 | 3 |
287102 | 287102 | 2020-06-30 | Dale | Alabama | 1045 | 244 | 0 |
287103 | 287103 | 2020-06-30 | Dallas | Alabama | 1047 | 814 | 8 |
287104 | 287104 | 2020-06-30 | DeKalb | Alabama | 1049 | 583 | 5 |
287105 | 287105 | 2020-06-30 | Elmore | Alabama | 1051 | 822 | 14 |
287106 | 287106 | 2020-06-30 | Escambia | Alabama | 1053 | 258 | 6 |
287107 | 287107 | 2020-06-30 | Etowah | Alabama | 1055 | 615 | 13 |
287108 | 287108 | 2020-06-30 | Fayette | Alabama | 1057 | 69 | 1 |
287109 | 287109 | 2020-06-30 | Franklin | Alabama | 1059 | 847 | 13 |
287110 | 287110 | 2020-06-30 | Geneva | Alabama | 1061 | 63 | 0 |
287111 | 287111 | 2020-06-30 | Greene | Alabama | 1063 | 164 | 7 |
287112 | 287112 | 2020-06-30 | Hale | Alabama | 1065 | 290 | 20 |
287113 | 287113 | 2020-06-30 | Henry | Alabama | 1067 | 130 | 4 |
287114 | 287114 | 2020-06-30 | Houston | Alabama | 1069 | 439 | 6 |
287115 | 287115 | 2020-06-30 | Jackson | Alabama | 1071 | 214 | 3 |
287116 | 287116 | 2020-06-30 | Jefferson | Alabama | 1073 | 4258 | 142 |
287117 | 287117 | 2020-06-30 | Lamar | Alabama | 1075 | 72 | 1 |
287118 | 287118 | 2020-06-30 | Lauderdale | Alabama | 1077 | 412 | 5 |
287119 | 287119 | 2020-06-30 | Lawrence | Alabama | 1079 | 103 | 0 |
287120 | 287120 | 2020-06-30 | Lee | Alabama | 1081 | 1188 | 37 |
287121 | 287121 | 2020-06-30 | Limestone | Alabama | 1083 | 407 | 0 |
287122 | 287122 | 2020-06-30 | Lowndes | Alabama | 1085 | 462 | 20 |
287123 | 287123 | 2020-06-30 | Macon | Alabama | 1087 | 168 | 8 |
287124 | 287124 | 2020-06-30 | Madison | Alabama | 1089 | 1047 | 7 |
287125 | 287125 | 2020-06-30 | Marengo | Alabama | 1091 | 278 | 11 |
287126 | 287126 | 2020-06-30 | Marion | Alabama | 1093 | 205 | 12 |
287127 | 287127 | 2020-06-30 | Marshall | Alabama | 1095 | 1505 | 9 |
287128 | 287128 | 2020-06-30 | Mobile | Alabama | 1097 | 3660 | 138 |
287129 | 287129 | 2020-06-30 | Monroe | Alabama | 1099 | 195 | 2 |
287130 | 287130 | 2020-06-30 | Montgomery | Alabama | 1101 | 3839 | 97 |
287131 | 287131 | 2020-06-30 | Morgan | Alabama | 1103 | 966 | 3 |
287132 | 287132 | 2020-06-30 | Perry | Alabama | 1105 | 135 | 0 |
287133 | 287133 | 2020-06-30 | Pickens | Alabama | 1107 | 205 | 6 |
287134 | 287134 | 2020-06-30 | Pike | Alabama | 1109 | 404 | 5 |
287135 | 287135 | 2020-06-30 | Randolph | Alabama | 1111 | 171 | 9 |
287136 | 287136 | 2020-06-30 | Russell | Alabama | 1113 | 474 | 0 |
287137 | 287137 | 2020-06-30 | Shelby | Alabama | 1117 | 1077 | 23 |
287138 | 287138 | 2020-06-30 | St. Clair | Alabama | 1115 | 302 | 2 |
287139 | 287139 | 2020-06-30 | Sumter | Alabama | 1119 | 276 | 12 |
287140 | 287140 | 2020-06-30 | Talladega | Alabama | 1121 | 265 | 7 |
287141 | 287141 | 2020-06-30 | Tallapoosa | Alabama | 1123 | 567 | 70 |
287142 | 287142 | 2020-06-30 | Tuscaloosa | Alabama | 1125 | 1986 | 38 |
287143 | 287143 | 2020-06-30 | Walker | Alabama | 1127 | 855 | 17 |
287144 | 287144 | 2020-06-30 | Washington | Alabama | 1129 | 101 | 7 |
287145 | 287145 | 2020-06-30 | Wilcox | Alabama | 1131 | 280 | 8 |
287146 | 287146 | 2020-06-30 | Winston | Alabama | 1133 | 231 | 3 |
287147 | 287147 | 2020-06-30 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
287148 | 287148 | 2020-06-30 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
287149 | 287149 | 2020-06-30 | Anchorage | Alaska | 2020 | 485 | 6 |
287150 | 287150 | 2020-06-30 | Bethel Census Area | Alaska | 2050 | 11 | 0 |
287151 | 287151 | 2020-06-30 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 40 | 0 |
287152 | 287152 | 2020-06-30 | Denali Borough | Alaska | 2068 | 1 | 0 |
287153 | 287153 | 2020-06-30 | Dillingham Census Area | Alaska | 2070 | 18 | 0 |
287154 | 287154 | 2020-06-30 | Fairbanks North Star Borough | Alaska | 2090 | 155 | 2 |
287155 | 287155 | 2020-06-30 | Haines Borough | Alaska | 2100 | 5 | 0 |
287156 | 287156 | 2020-06-30 | Juneau City and Borough | Alaska | 2110 | 48 | 2 |
287157 | 287157 | 2020-06-30 | Kenai Peninsula Borough | Alaska | 2122 | 159 | 1 |
287158 | 287158 | 2020-06-30 | Ketchikan Gateway Borough | Alaska | 2130 | 29 | 0 |
287159 | 287159 | 2020-06-30 | Kodiak Island Borough | Alaska | 2150 | 7 | 0 |
287160 | 287160 | 2020-06-30 | Matanuska-Susitna Borough | Alaska | 2170 | 84 | 1 |
287161 | 287161 | 2020-06-30 | Nome Census Area | Alaska | 2180 | 9 | 0 |
287162 | 287162 | 2020-06-30 | North Slope Borough | Alaska | 2185 | 4 | 0 |
287163 | 287163 | 2020-06-30 | Northwest Arctic Borough | Alaska | 2188 | 4 | 0 |
287164 | 287164 | 2020-06-30 | Petersburg Borough | Alaska | 2195 | 4 | 0 |
287165 | 287165 | 2020-06-30 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 3 | 0 |
287166 | 287166 | 2020-06-30 | Sitka City and Borough | Alaska | 2220 | 17 | 0 |
287167 | 287167 | 2020-06-30 | Southeast Fairbanks Census Area | Alaska | 2240 | 11 | 0 |
287168 | 287168 | 2020-06-30 | Valdez-Cordova Census Area | Alaska | 2261 | 21 | 0 |
287169 | 287169 | 2020-06-30 | Wrangell City and Borough | Alaska | 2275 | 8 | 0 |
287170 | 287170 | 2020-06-30 | Yukon-Koyukuk Census Area | Alaska | 2290 | 3 | 0 |
287171 | 287171 | 2020-06-30 | Apache | Arizona | 4001 | 2337 | 86 |
287172 | 287172 | 2020-06-30 | Cochise | Arizona | 4003 | 645 | 8 |
287173 | 287173 | 2020-06-30 | Coconino | Arizona | 4005 | 1885 | 92 |
287174 | 287174 | 2020-06-30 | Gila | Arizona | 4007 | 292 | 5 |
287175 | 287175 | 2020-06-30 | Graham | Arizona | 4009 | 96 | 2 |
287176 | 287176 | 2020-06-30 | Greenlee | Arizona | 4011 | 18 | 1 |
287177 | 287177 | 2020-06-30 | La Paz | Arizona | 4012 | 342 | 5 |
287178 | 287178 | 2020-06-30 | Maricopa | Arizona | 4013 | 48710 | 771 |
287179 | 287179 | 2020-06-30 | Mohave | Arizona | 4015 | 1071 | 85 |
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);