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 2022-04-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 |
---|---|---|---|---|---|---|---|
2424522 | 2424522 | 2022-04-19 | Barbour | West Virginia | 54001 | 4791 | 73 |
2424523 | 2424523 | 2022-04-19 | Berkeley | West Virginia | 54003 | 35746 | 289 |
2424524 | 2424524 | 2022-04-19 | Boone | West Virginia | 54005 | 6571 | 75 |
2424525 | 2424525 | 2022-04-19 | Braxton | West Virginia | 54007 | 3902 | 42 |
2424526 | 2424526 | 2022-04-19 | Brooke | West Virginia | 54009 | 5014 | 104 |
2424527 | 2424527 | 2022-04-19 | Cabell | West Virginia | 54011 | 27471 | 372 |
2424528 | 2424528 | 2022-04-19 | Calhoun | West Virginia | 54013 | 1838 | 13 |
2424529 | 2424529 | 2022-04-19 | Clay | West Virginia | 54015 | 2340 | 41 |
2424530 | 2424530 | 2022-04-19 | Doddridge | West Virginia | 54017 | 2151 | 18 |
2424531 | 2424531 | 2022-04-19 | Fayette | West Virginia | 54019 | 13066 | 198 |
2424532 | 2424532 | 2022-04-19 | Gilmer | West Virginia | 54021 | 2094 | 19 |
2424533 | 2424533 | 2022-04-19 | Grant | West Virginia | 54023 | 3773 | 56 |
2424534 | 2424534 | 2022-04-19 | Greenbrier | West Virginia | 54025 | 9524 | 158 |
2424535 | 2424535 | 2022-04-19 | Hampshire | West Virginia | 54027 | 5837 | 72 |
2424536 | 2424536 | 2022-04-19 | Hancock | West Virginia | 54029 | 6710 | 142 |
2424537 | 2424537 | 2022-04-19 | Hardy | West Virginia | 54031 | 4180 | 49 |
2424538 | 2424538 | 2022-04-19 | Harrison | West Virginia | 54033 | 19836 | 250 |
2424539 | 2424539 | 2022-04-19 | Jackson | West Virginia | 54035 | 6883 | 131 |
2424540 | 2424540 | 2022-04-19 | Jefferson | West Virginia | 54037 | 14243 | 130 |
2424541 | 2424541 | 2022-04-19 | Kanawha | West Virginia | 54039 | 47161 | 712 |
2424542 | 2424542 | 2022-04-19 | Lewis | West Virginia | 54041 | 5317 | 85 |
2424543 | 2424543 | 2022-04-19 | Lincoln | West Virginia | 54043 | 5526 | 81 |
2424544 | 2424544 | 2022-04-19 | Logan | West Virginia | 54045 | 9591 | 182 |
2424545 | 2424545 | 2022-04-19 | Marion | West Virginia | 54049 | 15009 | 178 |
2424546 | 2424546 | 2022-04-19 | Marshall | West Virginia | 54051 | 8952 | 153 |
2424547 | 2424547 | 2022-04-19 | Mason | West Virginia | 54053 | 6653 | 92 |
2424548 | 2424548 | 2022-04-19 | McDowell | West Virginia | 54047 | 5614 | 73 |
2424549 | 2424549 | 2022-04-19 | Mercer | West Virginia | 54055 | 17025 | 265 |
2424550 | 2424550 | 2022-04-19 | Mineral | West Virginia | 54057 | 7861 | 156 |
2424551 | 2424551 | 2022-04-19 | Mingo | West Virginia | 54059 | 7935 | 122 |
2424552 | 2424552 | 2022-04-19 | Monongalia | West Virginia | 54061 | 24689 | 196 |
2424553 | 2424553 | 2022-04-19 | Monroe | West Virginia | 54063 | 4175 | 46 |
2424554 | 2424554 | 2022-04-19 | Morgan | West Virginia | 54065 | 4254 | 69 |
2424555 | 2424555 | 2022-04-19 | Nicholas | West Virginia | 54067 | 7306 | 96 |
2424556 | 2424556 | 2022-04-19 | Ohio | West Virginia | 54069 | 11070 | 166 |
2424557 | 2424557 | 2022-04-19 | Pendleton | West Virginia | 54071 | 1961 | 21 |
2424558 | 2424558 | 2022-04-19 | Pleasants | West Virginia | 54073 | 2065 | 36 |
2424559 | 2424559 | 2022-04-19 | Pocahontas | West Virginia | 54075 | 2014 | 29 |
2424560 | 2424560 | 2022-04-19 | Preston | West Virginia | 54077 | 9281 | 135 |
2424561 | 2424561 | 2022-04-19 | Putnam | West Virginia | 54079 | 16695 | 176 |
2424562 | 2424562 | 2022-04-19 | Raleigh | West Virginia | 54081 | 22724 | 341 |
2424563 | 2424563 | 2022-04-19 | Randolph | West Virginia | 54083 | 9418 | 87 |
2424564 | 2424564 | 2022-04-19 | Ritchie | West Virginia | 54085 | 2446 | 31 |
2424565 | 2424565 | 2022-04-19 | Roane | West Virginia | 54087 | 3164 | 36 |
2424566 | 2424566 | 2022-04-19 | Summers | West Virginia | 54089 | 2806 | 53 |
2424567 | 2424567 | 2022-04-19 | Taylor | West Virginia | 54091 | 4523 | 73 |
2424568 | 2424568 | 2022-04-19 | Tucker | West Virginia | 54093 | 1999 | 37 |
2424569 | 2424569 | 2022-04-19 | Tyler | West Virginia | 54095 | 2201 | 31 |
2424570 | 2424570 | 2022-04-19 | Upshur | West Virginia | 54097 | 6822 | 95 |
2424571 | 2424571 | 2022-04-19 | Wayne | West Virginia | 54099 | 9820 | 122 |
2424572 | 2424572 | 2022-04-19 | Webster | West Virginia | 54101 | 2261 | 33 |
2424573 | 2424573 | 2022-04-19 | Wetzel | West Virginia | 54103 | 4337 | 85 |
2424574 | 2424574 | 2022-04-19 | Wirt | West Virginia | 54105 | 1446 | 24 |
2424575 | 2424575 | 2022-04-19 | Wood | West Virginia | 54107 | 22196 | 343 |
2424576 | 2424576 | 2022-04-19 | Wyoming | West Virginia | 54109 | 7001 | 112 |
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);