ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
916 rows where date = "2020-03-20" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state >30
- Georgia 54
- New York 42
- Texas 38
- Florida 36
- California 35
- Mississippi 32
- North Carolina 30
- Louisiana 29
- Ohio 29
- Wisconsin 29
- Washington 28
- Arkansas 27
- Indiana 27
- Tennessee 27
- Pennsylvania 26
- Colorado 25
- South Carolina 25
- Virginia 25
- Illinois 24
- Minnesota 21
- New Jersey 21
- Alabama 20
- Michigan 20
- Kentucky 18
- Oregon 16
- Missouri 15
- Maryland 14
- Oklahoma 14
- Iowa 13
- Kansas 13
- …
fips >30
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5167 | 5167 | 2020-03-20 | Baldwin | Alabama | 1003 | 2 | 0 |
5168 | 5168 | 2020-03-20 | Calhoun | Alabama | 1015 | 1 | 0 |
5169 | 5169 | 2020-03-20 | Chambers | Alabama | 1017 | 1 | 0 |
5170 | 5170 | 2020-03-20 | Cullman | Alabama | 1043 | 1 | 0 |
5171 | 5171 | 2020-03-20 | Elmore | Alabama | 1051 | 6 | 0 |
5172 | 5172 | 2020-03-20 | Jackson | Alabama | 1071 | 1 | 0 |
5173 | 5173 | 2020-03-20 | Jefferson | Alabama | 1073 | 50 | 0 |
5174 | 5174 | 2020-03-20 | Lamar | Alabama | 1075 | 1 | 0 |
5175 | 5175 | 2020-03-20 | Lauderdale | Alabama | 1077 | 1 | 0 |
5176 | 5176 | 2020-03-20 | Lee | Alabama | 1081 | 11 | 0 |
5177 | 5177 | 2020-03-20 | Limestone | Alabama | 1083 | 1 | 0 |
5178 | 5178 | 2020-03-20 | Madison | Alabama | 1089 | 7 | 0 |
5179 | 5179 | 2020-03-20 | Mobile | Alabama | 1097 | 2 | 0 |
5180 | 5180 | 2020-03-20 | Montgomery | Alabama | 1101 | 3 | 0 |
5181 | 5181 | 2020-03-20 | Shelby | Alabama | 1117 | 10 | 0 |
5182 | 5182 | 2020-03-20 | St. Clair | Alabama | 1115 | 1 | 0 |
5183 | 5183 | 2020-03-20 | Talladega | Alabama | 1121 | 1 | 0 |
5184 | 5184 | 2020-03-20 | Tuscaloosa | Alabama | 1125 | 4 | 0 |
5185 | 5185 | 2020-03-20 | Walker | Alabama | 1127 | 1 | 0 |
5186 | 5186 | 2020-03-20 | Washington | Alabama | 1129 | 1 | 0 |
5187 | 5187 | 2020-03-20 | Anchorage | Alaska | 2020 | 4 | 0 |
5188 | 5188 | 2020-03-20 | Fairbanks North Star Borough | Alaska | 2090 | 6 | 0 |
5189 | 5189 | 2020-03-20 | Kenai Peninsula Borough | Alaska | 2122 | 1 | 0 |
5190 | 5190 | 2020-03-20 | Ketchikan Gateway Borough | Alaska | 2130 | 3 | 0 |
5191 | 5191 | 2020-03-20 | Coconino | Arizona | 4005 | 11 | 0 |
5192 | 5192 | 2020-03-20 | Graham | Arizona | 4009 | 1 | 0 |
5193 | 5193 | 2020-03-20 | Maricopa | Arizona | 4013 | 34 | 1 |
5194 | 5194 | 2020-03-20 | Navajo | Arizona | 4017 | 3 | 0 |
5195 | 5195 | 2020-03-20 | Pima | Arizona | 4019 | 8 | 0 |
5196 | 5196 | 2020-03-20 | Pinal | Arizona | 4021 | 10 | 0 |
5197 | 5197 | 2020-03-20 | Santa Cruz | Arizona | 4023 | 1 | 0 |
5198 | 5198 | 2020-03-20 | Yavapai | Arizona | 4025 | 1 | 0 |
5199 | 5199 | 2020-03-20 | Yuma | Arizona | 4027 | 1 | 0 |
5200 | 5200 | 2020-03-20 | Benton | Arkansas | 5007 | 1 | 0 |
5201 | 5201 | 2020-03-20 | Boone | Arkansas | 5009 | 1 | 0 |
5202 | 5202 | 2020-03-20 | Bradley | Arkansas | 5011 | 1 | 0 |
5203 | 5203 | 2020-03-20 | Clark | Arkansas | 5019 | 1 | 0 |
5204 | 5204 | 2020-03-20 | Cleburne | Arkansas | 5023 | 11 | 0 |
5205 | 5205 | 2020-03-20 | Cleveland | Arkansas | 5025 | 1 | 0 |
5206 | 5206 | 2020-03-20 | Craighead | Arkansas | 5031 | 1 | 0 |
5207 | 5207 | 2020-03-20 | Crittenden | Arkansas | 5035 | 1 | 0 |
5208 | 5208 | 2020-03-20 | Desha | Arkansas | 5041 | 1 | 0 |
5209 | 5209 | 2020-03-20 | Faulkner | Arkansas | 5045 | 1 | 0 |
5210 | 5210 | 2020-03-20 | Garland | Arkansas | 5051 | 6 | 0 |
5211 | 5211 | 2020-03-20 | Grant | Arkansas | 5053 | 1 | 0 |
5212 | 5212 | 2020-03-20 | Greene | Arkansas | 5055 | 1 | 0 |
5213 | 5213 | 2020-03-20 | Independence | Arkansas | 5063 | 1 | 0 |
5214 | 5214 | 2020-03-20 | Jefferson | Arkansas | 5069 | 19 | 0 |
5215 | 5215 | 2020-03-20 | Lincoln | Arkansas | 5079 | 1 | 0 |
5216 | 5216 | 2020-03-20 | Poinsett | Arkansas | 5111 | 1 | 0 |
5217 | 5217 | 2020-03-20 | Polk | Arkansas | 5113 | 1 | 0 |
5218 | 5218 | 2020-03-20 | Pope | Arkansas | 5115 | 1 | 0 |
5219 | 5219 | 2020-03-20 | Pulaski | Arkansas | 5119 | 23 | 0 |
5220 | 5220 | 2020-03-20 | Saline | Arkansas | 5125 | 1 | 0 |
5221 | 5221 | 2020-03-20 | Searcy | Arkansas | 5129 | 1 | 0 |
5222 | 5222 | 2020-03-20 | Sebastian | Arkansas | 5131 | 1 | 0 |
5223 | 5223 | 2020-03-20 | Sevier | Arkansas | 5133 | 1 | 0 |
5224 | 5224 | 2020-03-20 | Unknown | Arkansas | 19 | 0 | |
5225 | 5225 | 2020-03-20 | Van Buren | Arkansas | 5141 | 1 | 0 |
5226 | 5226 | 2020-03-20 | Washington | Arkansas | 5143 | 1 | 0 |
5227 | 5227 | 2020-03-20 | Alameda | California | 6001 | 67 | 0 |
5228 | 5228 | 2020-03-20 | Amador | California | 6005 | 1 | 0 |
5229 | 5229 | 2020-03-20 | Contra Costa | California | 6013 | 46 | 1 |
5230 | 5230 | 2020-03-20 | Fresno | California | 6019 | 10 | 0 |
5231 | 5231 | 2020-03-20 | Humboldt | California | 6023 | 2 | 0 |
5232 | 5232 | 2020-03-20 | Imperial | California | 6025 | 4 | 0 |
5233 | 5233 | 2020-03-20 | Kern | California | 6029 | 2 | 0 |
5234 | 5234 | 2020-03-20 | Los Angeles | California | 6037 | 292 | 2 |
5235 | 5235 | 2020-03-20 | Madera | California | 6039 | 3 | 0 |
5236 | 5236 | 2020-03-20 | Marin | California | 6041 | 38 | 0 |
5237 | 5237 | 2020-03-20 | Mendocino | California | 6045 | 1 | 0 |
5238 | 5238 | 2020-03-20 | Monterey | California | 6053 | 5 | 0 |
5239 | 5239 | 2020-03-20 | Napa | California | 6055 | 1 | 0 |
5240 | 5240 | 2020-03-20 | Nevada | California | 6057 | 1 | 0 |
5241 | 5241 | 2020-03-20 | Orange | California | 6059 | 65 | 0 |
5242 | 5242 | 2020-03-20 | Placer | California | 6061 | 9 | 1 |
5243 | 5243 | 2020-03-20 | Riverside | California | 6065 | 28 | 4 |
5244 | 5244 | 2020-03-20 | Sacramento | California | 6067 | 52 | 3 |
5245 | 5245 | 2020-03-20 | San Benito | California | 6069 | 5 | 1 |
5246 | 5246 | 2020-03-20 | San Bernardino | California | 6071 | 9 | 0 |
5247 | 5247 | 2020-03-20 | San Diego | California | 6073 | 131 | 0 |
5248 | 5248 | 2020-03-20 | San Francisco | California | 6075 | 79 | 0 |
5249 | 5249 | 2020-03-20 | San Joaquin | California | 6077 | 25 | 2 |
5250 | 5250 | 2020-03-20 | San Luis Obispo | California | 6079 | 16 | 0 |
5251 | 5251 | 2020-03-20 | San Mateo | California | 6081 | 100 | 1 |
5252 | 5252 | 2020-03-20 | Santa Barbara | California | 6083 | 9 | 0 |
5253 | 5253 | 2020-03-20 | Santa Clara | California | 6085 | 196 | 8 |
5254 | 5254 | 2020-03-20 | Santa Cruz | California | 6087 | 15 | 0 |
5255 | 5255 | 2020-03-20 | Shasta | California | 6089 | 1 | 0 |
5256 | 5256 | 2020-03-20 | Solano | California | 6095 | 18 | 0 |
5257 | 5257 | 2020-03-20 | Sonoma | California | 6097 | 11 | 1 |
5258 | 5258 | 2020-03-20 | Stanislaus | California | 6099 | 5 | 0 |
5259 | 5259 | 2020-03-20 | Tulare | California | 6107 | 11 | 0 |
5260 | 5260 | 2020-03-20 | Ventura | California | 6111 | 19 | 0 |
5261 | 5261 | 2020-03-20 | Yolo | California | 6113 | 6 | 0 |
5262 | 5262 | 2020-03-20 | Adams | Colorado | 8001 | 12 | 0 |
5263 | 5263 | 2020-03-20 | Arapahoe | Colorado | 8005 | 29 | 0 |
5264 | 5264 | 2020-03-20 | Boulder | Colorado | 8013 | 24 | 0 |
5265 | 5265 | 2020-03-20 | Broomfield | Colorado | 8014 | 1 | 0 |
5266 | 5266 | 2020-03-20 | Clear Creek | Colorado | 8019 | 2 | 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);