ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where date = "2021-11-19" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1933445 | 1933445 | 2021-11-19 | Barbour | West Virginia | 54001 | 2912 | 51 |
1933446 | 1933446 | 2021-11-19 | Berkeley | West Virginia | 54003 | 19672 | 190 |
1933447 | 1933447 | 2021-11-19 | Boone | West Virginia | 54005 | 3875 | 60 |
1933448 | 1933448 | 2021-11-19 | Braxton | West Virginia | 54007 | 2313 | 23 |
1933449 | 1933449 | 2021-11-19 | Brooke | West Virginia | 54009 | 3256 | 75 |
1933450 | 1933450 | 2021-11-19 | Cabell | West Virginia | 54011 | 15671 | 280 |
1933451 | 1933451 | 2021-11-19 | Calhoun | West Virginia | 54013 | 1038 | 5 |
1933452 | 1933452 | 2021-11-19 | Clay | West Virginia | 54015 | 1353 | 21 |
1933453 | 1933453 | 2021-11-19 | Doddridge | West Virginia | 54017 | 1396 | 11 |
1933454 | 1933454 | 2021-11-19 | Fayette | West Virginia | 54019 | 6585 | 134 |
1933455 | 1933455 | 2021-11-19 | Gilmer | West Virginia | 54021 | 1439 | 14 |
1933456 | 1933456 | 2021-11-19 | Grant | West Virginia | 54023 | 2354 | 36 |
1933457 | 1933457 | 2021-11-19 | Greenbrier | West Virginia | 54025 | 5142 | 102 |
1933458 | 1933458 | 2021-11-19 | Hampshire | West Virginia | 54027 | 3536 | 50 |
1933459 | 1933459 | 2021-11-19 | Hancock | West Virginia | 54029 | 4462 | 118 |
1933460 | 1933460 | 2021-11-19 | Hardy | West Virginia | 54031 | 2623 | 31 |
1933461 | 1933461 | 2021-11-19 | Harrison | West Virginia | 54033 | 11914 | 173 |
1933462 | 1933462 | 2021-11-19 | Jackson | West Virginia | 54035 | 4171 | 88 |
1933463 | 1933463 | 2021-11-19 | Jefferson | West Virginia | 54037 | 7183 | 89 |
1933464 | 1933464 | 2021-11-19 | Kanawha | West Virginia | 54039 | 26405 | 522 |
1933465 | 1933465 | 2021-11-19 | Lewis | West Virginia | 54041 | 3203 | 57 |
1933466 | 1933466 | 2021-11-19 | Lincoln | West Virginia | 54043 | 3162 | 49 |
1933467 | 1933467 | 2021-11-19 | Logan | West Virginia | 54045 | 5594 | 140 |
1933468 | 1933468 | 2021-11-19 | Marion | West Virginia | 54049 | 8784 | 117 |
1933469 | 1933469 | 2021-11-19 | Marshall | West Virginia | 54051 | 5563 | 117 |
1933470 | 1933470 | 2021-11-19 | Mason | West Virginia | 54053 | 3822 | 61 |
1933471 | 1933471 | 2021-11-19 | McDowell | West Virginia | 54047 | 3077 | 52 |
1933472 | 1933472 | 2021-11-19 | Mercer | West Virginia | 54055 | 9317 | 182 |
1933473 | 1933473 | 2021-11-19 | Mineral | West Virginia | 54057 | 4874 | 118 |
1933474 | 1933474 | 2021-11-19 | Mingo | West Virginia | 54059 | 4831 | 84 |
1933475 | 1933475 | 2021-11-19 | Monongalia | West Virginia | 54061 | 14083 | 147 |
1933476 | 1933476 | 2021-11-19 | Monroe | West Virginia | 54063 | 2195 | 26 |
1933477 | 1933477 | 2021-11-19 | Morgan | West Virginia | 54065 | 2251 | 48 |
1933478 | 1933478 | 2021-11-19 | Nicholas | West Virginia | 54067 | 4095 | 57 |
1933479 | 1933479 | 2021-11-19 | Ohio | West Virginia | 54069 | 6449 | 114 |
1933480 | 1933480 | 2021-11-19 | Pendleton | West Virginia | 54071 | 1181 | 15 |
1933481 | 1933481 | 2021-11-19 | Pleasants | West Virginia | 54073 | 1444 | 30 |
1933482 | 1933482 | 2021-11-19 | Pocahontas | West Virginia | 54075 | 1228 | 18 |
1933483 | 1933483 | 2021-11-19 | Preston | West Virginia | 54077 | 5649 | 97 |
1933484 | 1933484 | 2021-11-19 | Putnam | West Virginia | 54079 | 9463 | 132 |
1933485 | 1933485 | 2021-11-19 | Raleigh | West Virginia | 54081 | 12059 | 189 |
1933486 | 1933486 | 2021-11-19 | Randolph | West Virginia | 54083 | 5387 | 53 |
1933487 | 1933487 | 2021-11-19 | Ritchie | West Virginia | 54085 | 1517 | 21 |
1933488 | 1933488 | 2021-11-19 | Roane | West Virginia | 54087 | 1728 | 24 |
1933489 | 1933489 | 2021-11-19 | Summers | West Virginia | 54089 | 1504 | 32 |
1933490 | 1933490 | 2021-11-19 | Taylor | West Virginia | 54091 | 2510 | 41 |
1933491 | 1933491 | 2021-11-19 | Tucker | West Virginia | 54093 | 1217 | 30 |
1933492 | 1933492 | 2021-11-19 | Tyler | West Virginia | 54095 | 1403 | 24 |
1933493 | 1933493 | 2021-11-19 | Upshur | West Virginia | 54097 | 4324 | 67 |
1933494 | 1933494 | 2021-11-19 | Wayne | West Virginia | 54099 | 5885 | 88 |
1933495 | 1933495 | 2021-11-19 | Webster | West Virginia | 54101 | 1321 | 24 |
1933496 | 1933496 | 2021-11-19 | Wetzel | West Virginia | 54103 | 2715 | 58 |
1933497 | 1933497 | 2021-11-19 | Wirt | West Virginia | 54105 | 890 | 15 |
1933498 | 1933498 | 2021-11-19 | Wood | West Virginia | 54107 | 13745 | 259 |
1933499 | 1933499 | 2021-11-19 | Wyoming | West Virginia | 54109 | 3842 | 67 |
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);