ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 48,994
- Georgia 33,849
- Virginia 27,443
- Kentucky 24,292
- Missouri 23,026
- Illinois 20,979
- North Carolina 20,908
- Iowa 20,170
- Tennessee 20,107
- Indiana 19,538
- Kansas 19,338
- Ohio 18,594
- Minnesota 17,811
- Mississippi 17,432
- Michigan 17,406
- Nebraska 15,968
- Arkansas 15,743
- Oklahoma 15,542
- Wisconsin 15,021
- Florida 14,670
- Pennsylvania 14,318
- Alabama 14,122
- Louisiana 13,918
- Puerto Rico 13,446
- Colorado 13,111
- New York 12,690
- California 12,683
- South Dakota 11,998
- West Virginia 10,941
- South Carolina 9,917
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
651269 | 651269 | 2020-10-21 | Miller | Arkansas | 5091 | 1235 | 15 |
651270 | 651270 | 2020-10-21 | Mississippi | Arkansas | 5093 | 2128 | 64 |
651271 | 651271 | 2020-10-21 | Monroe | Arkansas | 5095 | 201 | 1 |
651272 | 651272 | 2020-10-21 | Montgomery | Arkansas | 5097 | 181 | 8 |
651273 | 651273 | 2020-10-21 | Nevada | Arkansas | 5099 | 283 | 14 |
651274 | 651274 | 2020-10-21 | Newton | Arkansas | 5101 | 290 | 19 |
651275 | 651275 | 2020-10-21 | Ouachita | Arkansas | 5103 | 346 | 8 |
651276 | 651276 | 2020-10-21 | Perry | Arkansas | 5105 | 130 | 0 |
651277 | 651277 | 2020-10-21 | Phillips | Arkansas | 5107 | 699 | 15 |
651278 | 651278 | 2020-10-21 | Pike | Arkansas | 5109 | 258 | 1 |
651279 | 651279 | 2020-10-21 | Poinsett | Arkansas | 5111 | 965 | 17 |
651280 | 651280 | 2020-10-21 | Polk | Arkansas | 5113 | 341 | 4 |
651281 | 651281 | 2020-10-21 | Pope | Arkansas | 5115 | 2616 | 37 |
651282 | 651282 | 2020-10-21 | Prairie | Arkansas | 5117 | 195 | 4 |
651283 | 651283 | 2020-10-21 | Pulaski | Arkansas | 5119 | 11355 | 199 |
651284 | 651284 | 2020-10-21 | Randolph | Arkansas | 5121 | 607 | 24 |
651285 | 651285 | 2020-10-21 | Saline | Arkansas | 5125 | 2669 | 28 |
651286 | 651286 | 2020-10-21 | Scott | Arkansas | 5127 | 158 | 1 |
651287 | 651287 | 2020-10-21 | Searcy | Arkansas | 5129 | 179 | 1 |
651288 | 651288 | 2020-10-21 | Sebastian | Arkansas | 5131 | 4632 | 90 |
651289 | 651289 | 2020-10-21 | Sevier | Arkansas | 5133 | 1291 | 16 |
651290 | 651290 | 2020-10-21 | Sharp | Arkansas | 5135 | 317 | 10 |
651291 | 651291 | 2020-10-21 | St. Francis | Arkansas | 5123 | 1668 | 10 |
651292 | 651292 | 2020-10-21 | Stone | Arkansas | 5137 | 390 | 21 |
651293 | 651293 | 2020-10-21 | Union | Arkansas | 5139 | 1089 | 47 |
651294 | 651294 | 2020-10-21 | Unknown | Arkansas | 1999 | 0 | |
651295 | 651295 | 2020-10-21 | Van Buren | Arkansas | 5141 | 201 | 3 |
651296 | 651296 | 2020-10-21 | Washington | Arkansas | 5143 | 11042 | 143 |
651297 | 651297 | 2020-10-21 | White | Arkansas | 5145 | 1347 | 32 |
651298 | 651298 | 2020-10-21 | Woodruff | Arkansas | 5147 | 96 | 0 |
651299 | 651299 | 2020-10-21 | Yell | Arkansas | 5149 | 1327 | 30 |
651300 | 651300 | 2020-10-21 | Alameda | California | 6001 | 22953 | 435 |
651301 | 651301 | 2020-10-21 | Alpine | California | 6003 | 3 | 0 |
651302 | 651302 | 2020-10-21 | Amador | California | 6005 | 312 | 16 |
651303 | 651303 | 2020-10-21 | Butte | California | 6007 | 3027 | 51 |
651304 | 651304 | 2020-10-21 | Calaveras | California | 6009 | 339 | 17 |
651305 | 651305 | 2020-10-21 | Colusa | California | 6011 | 549 | 6 |
651306 | 651306 | 2020-10-21 | Contra Costa | California | 6013 | 18246 | 238 |
651307 | 651307 | 2020-10-21 | Del Norte | California | 6015 | 175 | 1 |
651308 | 651308 | 2020-10-21 | El Dorado | California | 6017 | 1295 | 4 |
651309 | 651309 | 2020-10-21 | Fresno | California | 6019 | 30220 | 430 |
651310 | 651310 | 2020-10-21 | Glenn | California | 6021 | 638 | 3 |
651311 | 651311 | 2020-10-21 | Humboldt | California | 6023 | 560 | 9 |
651312 | 651312 | 2020-10-21 | Imperial | California | 6025 | 12610 | 335 |
651313 | 651313 | 2020-10-21 | Inyo | California | 6027 | 218 | 15 |
651314 | 651314 | 2020-10-21 | Kern | California | 6029 | 33630 | 415 |
651315 | 651315 | 2020-10-21 | Kings | California | 6031 | 8178 | 83 |
651316 | 651316 | 2020-10-21 | Lake | California | 6033 | 675 | 15 |
651317 | 651317 | 2020-10-21 | Lassen | California | 6035 | 761 | 1 |
651318 | 651318 | 2020-10-21 | Los Angeles | California | 6037 | 290486 | 6944 |
651319 | 651319 | 2020-10-21 | Madera | California | 6039 | 4928 | 73 |
651320 | 651320 | 2020-10-21 | Marin | California | 6041 | 7038 | 127 |
651321 | 651321 | 2020-10-21 | Mariposa | California | 6043 | 78 | 2 |
651322 | 651322 | 2020-10-21 | Mendocino | California | 6045 | 1118 | 21 |
651323 | 651323 | 2020-10-21 | Merced | California | 6047 | 9415 | 154 |
651324 | 651324 | 2020-10-21 | Modoc | California | 6049 | 27 | 0 |
651325 | 651325 | 2020-10-21 | Mono | California | 6051 | 176 | 2 |
651326 | 651326 | 2020-10-21 | Monterey | California | 6053 | 11225 | 86 |
651327 | 651327 | 2020-10-21 | Napa | California | 6055 | 1914 | 14 |
651328 | 651328 | 2020-10-21 | Nevada | California | 6057 | 601 | 8 |
651329 | 651329 | 2020-10-21 | Orange | California | 6059 | 59448 | 1423 |
651330 | 651330 | 2020-10-21 | Placer | California | 6061 | 4023 | 55 |
651331 | 651331 | 2020-10-21 | Plumas | California | 6063 | 53 | 0 |
651332 | 651332 | 2020-10-21 | Riverside | California | 6065 | 65056 | 1275 |
651333 | 651333 | 2020-10-21 | Sacramento | California | 6067 | 24956 | 480 |
651334 | 651334 | 2020-10-21 | San Benito | California | 6069 | 1411 | 14 |
651335 | 651335 | 2020-10-21 | San Bernardino | California | 6071 | 60945 | 1065 |
651336 | 651336 | 2020-10-21 | San Diego | California | 6073 | 53326 | 863 |
651337 | 651337 | 2020-10-21 | San Francisco | California | 6075 | 12016 | 137 |
651338 | 651338 | 2020-10-21 | San Joaquin | California | 6077 | 21473 | 488 |
651339 | 651339 | 2020-10-21 | San Luis Obispo | California | 6079 | 4092 | 32 |
651340 | 651340 | 2020-10-21 | San Mateo | California | 6081 | 10918 | 157 |
651341 | 651341 | 2020-10-21 | Santa Barbara | California | 6083 | 9688 | 119 |
651342 | 651342 | 2020-10-21 | Santa Clara | California | 6085 | 23591 | 386 |
651343 | 651343 | 2020-10-21 | Santa Cruz | California | 6087 | 2744 | 25 |
651344 | 651344 | 2020-10-21 | Shasta | California | 6089 | 1786 | 29 |
651345 | 651345 | 2020-10-21 | Sierra | California | 6091 | 6 | 0 |
651346 | 651346 | 2020-10-21 | Siskiyou | California | 6093 | 187 | 0 |
651347 | 651347 | 2020-10-21 | Solano | California | 6095 | 7210 | 74 |
651348 | 651348 | 2020-10-21 | Sonoma | California | 6097 | 9073 | 134 |
651349 | 651349 | 2020-10-21 | Stanislaus | California | 6099 | 18098 | 394 |
651350 | 651350 | 2020-10-21 | Sutter | California | 6101 | 1830 | 12 |
651351 | 651351 | 2020-10-21 | Tehama | California | 6103 | 813 | 8 |
651352 | 651352 | 2020-10-21 | Trinity | California | 6105 | 26 | 0 |
651353 | 651353 | 2020-10-21 | Tulare | California | 6107 | 17365 | 282 |
651354 | 651354 | 2020-10-21 | Tuolumne | California | 6109 | 258 | 4 |
651355 | 651355 | 2020-10-21 | Ventura | California | 6111 | 13980 | 160 |
651356 | 651356 | 2020-10-21 | Yolo | California | 6113 | 3099 | 58 |
651357 | 651357 | 2020-10-21 | Yuba | California | 6115 | 1288 | 10 |
651358 | 651358 | 2020-10-21 | Adams | Colorado | 8001 | 12414 | 249 |
651359 | 651359 | 2020-10-21 | Alamosa | Colorado | 8003 | 292 | 9 |
651360 | 651360 | 2020-10-21 | Arapahoe | Colorado | 8005 | 11621 | 394 |
651361 | 651361 | 2020-10-21 | Archuleta | Colorado | 8007 | 61 | 0 |
651362 | 651362 | 2020-10-21 | Baca | Colorado | 8009 | 25 | 0 |
651363 | 651363 | 2020-10-21 | Bent | Colorado | 8011 | 12 | 0 |
651364 | 651364 | 2020-10-21 | Boulder | Colorado | 8013 | 5189 | 85 |
651365 | 651365 | 2020-10-21 | Broomfield | Colorado | 8014 | 846 | 41 |
651366 | 651366 | 2020-10-21 | Chaffee | Colorado | 8015 | 374 | 20 |
651367 | 651367 | 2020-10-21 | Cheyenne | Colorado | 8017 | 14 | 0 |
651368 | 651368 | 2020-10-21 | Clear Creek | Colorado | 8019 | 63 | 1 |
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);