Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
This data as json, CSV (advanced)
Suggested facets: deaths, date (date)
fips
county
state
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 319398 | 319398 | 2020-07-11 | Barbour | West Virginia | 54001 | 19 | 1 |
| 319399 | 319399 | 2020-07-11 | Berkeley | West Virginia | 54003 | 531 | 10 |
| 319400 | 319400 | 2020-07-11 | Boone | West Virginia | 54005 | 33 | 0 |
| 319401 | 319401 | 2020-07-11 | Braxton | West Virginia | 54007 | 5 | 0 |
| 319402 | 319402 | 2020-07-11 | Brooke | West Virginia | 54009 | 24 | 0 |
| 319403 | 319403 | 2020-07-11 | Cabell | West Virginia | 54011 | 198 | 0 |
| 319404 | 319404 | 2020-07-11 | Calhoun | West Virginia | 54013 | 4 | 0 |
| 319405 | 319405 | 2020-07-11 | Clay | West Virginia | 54015 | 12 | 1 |
| 319406 | 319406 | 2020-07-11 | Fayette | West Virginia | 54019 | 79 | 4 |
| 319407 | 319407 | 2020-07-11 | Gilmer | West Virginia | 54021 | 13 | 0 |
| 319408 | 319408 | 2020-07-11 | Grant | West Virginia | 54023 | 19 | 0 |
| 319409 | 319409 | 2020-07-11 | Greenbrier | West Virginia | 54025 | 71 | 3 |
| 319410 | 319410 | 2020-07-11 | Hampshire | West Virginia | 54027 | 42 | 1 |
| 319411 | 319411 | 2020-07-11 | Hancock | West Virginia | 54029 | 41 | 0 |
| 319412 | 319412 | 2020-07-11 | Hardy | West Virginia | 54031 | 46 | 0 |
| 319413 | 319413 | 2020-07-11 | Harrison | West Virginia | 54033 | 115 | 1 |
| 319414 | 319414 | 2020-07-11 | Jackson | West Virginia | 54035 | 148 | 18 |
| 319415 | 319415 | 2020-07-11 | Jefferson | West Virginia | 54037 | 253 | 4 |
| 319416 | 319416 | 2020-07-11 | Kanawha | West Virginia | 54039 | 410 | 20 |
| 319417 | 319417 | 2020-07-11 | Lewis | West Virginia | 54041 | 22 | 2 |
| 319418 | 319418 | 2020-07-11 | Lincoln | West Virginia | 54043 | 9 | 0 |
| 319419 | 319419 | 2020-07-11 | Logan | West Virginia | 54045 | 36 | 1 |
| 319420 | 319420 | 2020-07-11 | Marion | West Virginia | 54049 | 108 | 2 |
| 319421 | 319421 | 2020-07-11 | Marshall | West Virginia | 54051 | 63 | 0 |
| 319422 | 319422 | 2020-07-11 | Mason | West Virginia | 54053 | 24 | 0 |
| 319423 | 319423 | 2020-07-11 | McDowell | West Virginia | 54047 | 8 | 0 |
| 319424 | 319424 | 2020-07-11 | Mercer | West Virginia | 54055 | 62 | 0 |
| 319425 | 319425 | 2020-07-11 | Mineral | West Virginia | 54057 | 65 | 3 |
| 319426 | 319426 | 2020-07-11 | Mingo | West Virginia | 54059 | 30 | 2 |
| 319427 | 319427 | 2020-07-11 | Monongalia | West Virginia | 54061 | 524 | 5 |
| 319428 | 319428 | 2020-07-11 | Monroe | West Virginia | 54063 | 15 | 0 |
| 319429 | 319429 | 2020-07-11 | Morgan | West Virginia | 54065 | 20 | 0 |
| 319430 | 319430 | 2020-07-11 | Nicholas | West Virginia | 54067 | 21 | 1 |
| 319431 | 319431 | 2020-07-11 | Ohio | West Virginia | 54069 | 140 | 2 |
| 319432 | 319432 | 2020-07-11 | Pendleton | West Virginia | 54071 | 16 | 1 |
| 319433 | 319433 | 2020-07-11 | Pleasants | West Virginia | 54073 | 5 | 0 |
| 319434 | 319434 | 2020-07-11 | Pocahontas | West Virginia | 54075 | 37 | 0 |
| 319435 | 319435 | 2020-07-11 | Preston | West Virginia | 54077 | 93 | 2 |
| 319436 | 319436 | 2020-07-11 | Putnam | West Virginia | 54079 | 86 | 0 |
| 319437 | 319437 | 2020-07-11 | Raleigh | West Virginia | 54081 | 76 | 0 |
| 319438 | 319438 | 2020-07-11 | Randolph | West Virginia | 54083 | 187 | 0 |
| 319439 | 319439 | 2020-07-11 | Ritchie | West Virginia | 54085 | 2 | 0 |
| 319440 | 319440 | 2020-07-11 | Roane | West Virginia | 54087 | 12 | 1 |
| 319441 | 319441 | 2020-07-11 | Summers | West Virginia | 54089 | 2 | 0 |
| 319442 | 319442 | 2020-07-11 | Taylor | West Virginia | 54091 | 23 | 0 |
| 319443 | 319443 | 2020-07-11 | Tucker | West Virginia | 54093 | 6 | 0 |
| 319444 | 319444 | 2020-07-11 | Tyler | West Virginia | 54095 | 10 | 0 |
| 319445 | 319445 | 2020-07-11 | Upshur | West Virginia | 54097 | 25 | 0 |
| 319446 | 319446 | 2020-07-11 | Wayne | West Virginia | 54099 | 124 | 9 |
| 319447 | 319447 | 2020-07-11 | Webster | West Virginia | 54101 | 1 | 0 |
| 319448 | 319448 | 2020-07-11 | Wetzel | West Virginia | 54103 | 34 | 0 |
| 319449 | 319449 | 2020-07-11 | Wirt | West Virginia | 54105 | 6 | 0 |
| 319450 | 319450 | 2020-07-11 | Wood | West Virginia | 54107 | 184 | 2 |
| 319451 | 319451 | 2020-07-11 | Wyoming | West Virginia | 54109 | 7 | 0 |
| 316297 | 316297 | 2020-07-10 | Barbour | West Virginia | 54001 | 18 | 1 |
| 316298 | 316298 | 2020-07-10 | Berkeley | West Virginia | 54003 | 523 | 10 |
| 316299 | 316299 | 2020-07-10 | Boone | West Virginia | 54005 | 31 | 0 |
| 316300 | 316300 | 2020-07-10 | Braxton | West Virginia | 54007 | 4 | 0 |
| 316301 | 316301 | 2020-07-10 | Brooke | West Virginia | 54009 | 25 | 0 |
| 316302 | 316302 | 2020-07-10 | Cabell | West Virginia | 54011 | 194 | 0 |
| 316303 | 316303 | 2020-07-10 | Calhoun | West Virginia | 54013 | 4 | 0 |
| 316304 | 316304 | 2020-07-10 | Clay | West Virginia | 54015 | 11 | 1 |
| 316305 | 316305 | 2020-07-10 | Fayette | West Virginia | 54019 | 79 | 4 |
| 316306 | 316306 | 2020-07-10 | Gilmer | West Virginia | 54021 | 13 | 0 |
| 316307 | 316307 | 2020-07-10 | Grant | West Virginia | 54023 | 19 | 0 |
| 316308 | 316308 | 2020-07-10 | Greenbrier | West Virginia | 54025 | 69 | 3 |
| 316309 | 316309 | 2020-07-10 | Hampshire | West Virginia | 54027 | 42 | 1 |
| 316310 | 316310 | 2020-07-10 | Hancock | West Virginia | 54029 | 38 | 0 |
| 316311 | 316311 | 2020-07-10 | Hardy | West Virginia | 54031 | 46 | 0 |
| 316312 | 316312 | 2020-07-10 | Harrison | West Virginia | 54033 | 109 | 1 |
| 316313 | 316313 | 2020-07-10 | Jackson | West Virginia | 54035 | 148 | 18 |
| 316314 | 316314 | 2020-07-10 | Jefferson | West Virginia | 54037 | 253 | 4 |
| 316315 | 316315 | 2020-07-10 | Kanawha | West Virginia | 54039 | 393 | 20 |
| 316316 | 316316 | 2020-07-10 | Lewis | West Virginia | 54041 | 20 | 2 |
| 316317 | 316317 | 2020-07-10 | Lincoln | West Virginia | 54043 | 10 | 0 |
| 316318 | 316318 | 2020-07-10 | Logan | West Virginia | 54045 | 35 | 1 |
| 316319 | 316319 | 2020-07-10 | Marion | West Virginia | 54049 | 98 | 2 |
| 316320 | 316320 | 2020-07-10 | Marshall | West Virginia | 54051 | 58 | 0 |
| 316321 | 316321 | 2020-07-10 | Mason | West Virginia | 54053 | 23 | 0 |
| 316322 | 316322 | 2020-07-10 | McDowell | West Virginia | 54047 | 8 | 0 |
| 316323 | 316323 | 2020-07-10 | Mercer | West Virginia | 54055 | 62 | 0 |
| 316324 | 316324 | 2020-07-10 | Mineral | West Virginia | 54057 | 64 | 3 |
| 316325 | 316325 | 2020-07-10 | Mingo | West Virginia | 54059 | 29 | 2 |
| 316326 | 316326 | 2020-07-10 | Monongalia | West Virginia | 54061 | 468 | 5 |
| 316327 | 316327 | 2020-07-10 | Monroe | West Virginia | 54063 | 15 | 0 |
| 316328 | 316328 | 2020-07-10 | Morgan | West Virginia | 54065 | 20 | 0 |
| 316329 | 316329 | 2020-07-10 | Nicholas | West Virginia | 54067 | 16 | 1 |
| 316330 | 316330 | 2020-07-10 | Ohio | West Virginia | 54069 | 138 | 1 |
| 316331 | 316331 | 2020-07-10 | Pendleton | West Virginia | 54071 | 16 | 1 |
| 316332 | 316332 | 2020-07-10 | Pleasants | West Virginia | 54073 | 5 | 0 |
| 316333 | 316333 | 2020-07-10 | Pocahontas | West Virginia | 54075 | 37 | 0 |
| 316334 | 316334 | 2020-07-10 | Preston | West Virginia | 54077 | 95 | 2 |
| 316335 | 316335 | 2020-07-10 | Putnam | West Virginia | 54079 | 79 | 0 |
| 316336 | 316336 | 2020-07-10 | Raleigh | West Virginia | 54081 | 71 | 0 |
| 316337 | 316337 | 2020-07-10 | Randolph | West Virginia | 54083 | 186 | 0 |
| 316338 | 316338 | 2020-07-10 | Ritchie | West Virginia | 54085 | 2 | 0 |
| 316339 | 316339 | 2020-07-10 | Roane | West Virginia | 54087 | 12 | 1 |
| 316340 | 316340 | 2020-07-10 | Summers | West Virginia | 54089 | 2 | 0 |
| 316341 | 316341 | 2020-07-10 | Taylor | West Virginia | 54091 | 23 | 0 |
| 316342 | 316342 | 2020-07-10 | Tucker | West Virginia | 54093 | 6 | 0 |
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );