ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-01-03 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
894326 | 894326 | 2021-01-03 | Barbour | West Virginia | 54001 | 825 | 9 |
894327 | 894327 | 2021-01-03 | Berkeley | West Virginia | 54003 | 6573 | 53 |
894328 | 894328 | 2021-01-03 | Boone | West Virginia | 54005 | 1098 | 22 |
894329 | 894329 | 2021-01-03 | Braxton | West Virginia | 54007 | 561 | 1 |
894330 | 894330 | 2021-01-03 | Brooke | West Virginia | 54009 | 1488 | 25 |
894331 | 894331 | 2021-01-03 | Cabell | West Virginia | 54011 | 5491 | 101 |
894332 | 894332 | 2021-01-03 | Calhoun | West Virginia | 54013 | 141 | 0 |
894333 | 894333 | 2021-01-03 | Clay | West Virginia | 54015 | 268 | 4 |
894334 | 894334 | 2021-01-03 | Doddridge | West Virginia | 54017 | 269 | 3 |
894335 | 894335 | 2021-01-03 | Fayette | West Virginia | 54019 | 1865 | 48 |
894336 | 894336 | 2021-01-03 | Gilmer | West Virginia | 54021 | 431 | 1 |
894337 | 894337 | 2021-01-03 | Grant | West Virginia | 54023 | 803 | 17 |
894338 | 894338 | 2021-01-03 | Greenbrier | West Virginia | 54025 | 1612 | 35 |
894339 | 894339 | 2021-01-03 | Hampshire | West Virginia | 54027 | 1038 | 14 |
894340 | 894340 | 2021-01-03 | Hancock | West Virginia | 54029 | 1996 | 42 |
894341 | 894341 | 2021-01-03 | Hardy | West Virginia | 54031 | 826 | 8 |
894342 | 894342 | 2021-01-03 | Harrison | West Virginia | 54033 | 3152 | 33 |
894343 | 894343 | 2021-01-03 | Jackson | West Virginia | 54035 | 1239 | 30 |
894344 | 894344 | 2021-01-03 | Jefferson | West Virginia | 54037 | 2492 | 26 |
894345 | 894345 | 2021-01-03 | Kanawha | West Virginia | 54039 | 9008 | 209 |
894346 | 894346 | 2021-01-03 | Lewis | West Virginia | 54041 | 571 | 4 |
894347 | 894347 | 2021-01-03 | Lincoln | West Virginia | 54043 | 817 | 8 |
894348 | 894348 | 2021-01-03 | Logan | West Virginia | 54045 | 1772 | 59 |
894349 | 894349 | 2021-01-03 | Marion | West Virginia | 54049 | 2042 | 15 |
894350 | 894350 | 2021-01-03 | Marshall | West Virginia | 54051 | 2201 | 53 |
894351 | 894351 | 2021-01-03 | Mason | West Virginia | 54053 | 1084 | 17 |
894352 | 894352 | 2021-01-03 | McDowell | West Virginia | 54047 | 1021 | 6 |
894353 | 894353 | 2021-01-03 | Mercer | West Virginia | 54055 | 3081 | 54 |
894354 | 894354 | 2021-01-03 | Mineral | West Virginia | 54057 | 2139 | 66 |
894355 | 894355 | 2021-01-03 | Mingo | West Virginia | 54059 | 1526 | 20 |
894356 | 894356 | 2021-01-03 | Monongalia | West Virginia | 54061 | 5578 | 31 |
894357 | 894357 | 2021-01-03 | Monroe | West Virginia | 54063 | 699 | 11 |
894358 | 894358 | 2021-01-03 | Morgan | West Virginia | 54065 | 682 | 8 |
894359 | 894359 | 2021-01-03 | Nicholas | West Virginia | 54067 | 732 | 8 |
894360 | 894360 | 2021-01-03 | Ohio | West Virginia | 54069 | 2627 | 39 |
894361 | 894361 | 2021-01-03 | Pendleton | West Virginia | 54071 | 328 | 2 |
894362 | 894362 | 2021-01-03 | Pleasants | West Virginia | 54073 | 591 | 5 |
894363 | 894363 | 2021-01-03 | Pocahontas | West Virginia | 54075 | 367 | 9 |
894364 | 894364 | 2021-01-03 | Preston | West Virginia | 54077 | 1773 | 31 |
894365 | 894365 | 2021-01-03 | Putnam | West Virginia | 54079 | 3114 | 56 |
894366 | 894366 | 2021-01-03 | Raleigh | West Virginia | 54081 | 2891 | 30 |
894367 | 894367 | 2021-01-03 | Randolph | West Virginia | 54083 | 1224 | 6 |
894368 | 894368 | 2021-01-03 | Ritchie | West Virginia | 54085 | 375 | 7 |
894369 | 894369 | 2021-01-03 | Roane | West Virginia | 54087 | 323 | 5 |
894370 | 894370 | 2021-01-03 | Summers | West Virginia | 54089 | 482 | 17 |
894371 | 894371 | 2021-01-03 | Taylor | West Virginia | 54091 | 741 | 13 |
894372 | 894372 | 2021-01-03 | Tucker | West Virginia | 54093 | 348 | 2 |
894373 | 894373 | 2021-01-03 | Tyler | West Virginia | 54095 | 387 | 2 |
894374 | 894374 | 2021-01-03 | Upshur | West Virginia | 54097 | 999 | 5 |
894375 | 894375 | 2021-01-03 | Wayne | West Virginia | 54099 | 1768 | 21 |
894376 | 894376 | 2021-01-03 | Webster | West Virginia | 54101 | 169 | 0 |
894377 | 894377 | 2021-01-03 | Wetzel | West Virginia | 54103 | 734 | 16 |
894378 | 894378 | 2021-01-03 | Wirt | West Virginia | 54105 | 238 | 1 |
894379 | 894379 | 2021-01-03 | Wood | West Virginia | 54107 | 5231 | 48 |
894380 | 894380 | 2021-01-03 | Wyoming | West Virginia | 54109 | 1227 | 20 |
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);