ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where date = "2021-01-12" 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 |
---|---|---|---|---|---|---|---|
923533 | 923533 | 2021-01-12 | Barbour | West Virginia | 54001 | 1088 | 14 |
923534 | 923534 | 2021-01-12 | Berkeley | West Virginia | 54003 | 7597 | 60 |
923535 | 923535 | 2021-01-12 | Boone | West Virginia | 54005 | 1228 | 25 |
923536 | 923536 | 2021-01-12 | Braxton | West Virginia | 54007 | 633 | 1 |
923537 | 923537 | 2021-01-12 | Brooke | West Virginia | 54009 | 1654 | 40 |
923538 | 923538 | 2021-01-12 | Cabell | West Virginia | 54011 | 6101 | 121 |
923539 | 923539 | 2021-01-12 | Calhoun | West Virginia | 54013 | 177 | 0 |
923540 | 923540 | 2021-01-12 | Clay | West Virginia | 54015 | 288 | 4 |
923541 | 923541 | 2021-01-12 | Doddridge | West Virginia | 54017 | 320 | 3 |
923542 | 923542 | 2021-01-12 | Fayette | West Virginia | 54019 | 2063 | 55 |
923543 | 923543 | 2021-01-12 | Gilmer | West Virginia | 54021 | 506 | 5 |
923544 | 923544 | 2021-01-12 | Grant | West Virginia | 54023 | 882 | 19 |
923545 | 923545 | 2021-01-12 | Greenbrier | West Virginia | 54025 | 1914 | 43 |
923546 | 923546 | 2021-01-12 | Hampshire | West Virginia | 54027 | 1175 | 23 |
923547 | 923547 | 2021-01-12 | Hancock | West Virginia | 54029 | 2200 | 61 |
923548 | 923548 | 2021-01-12 | Hardy | West Virginia | 54031 | 1011 | 11 |
923549 | 923549 | 2021-01-12 | Harrison | West Virginia | 54033 | 3742 | 39 |
923550 | 923550 | 2021-01-12 | Jackson | West Virginia | 54035 | 1411 | 39 |
923551 | 923551 | 2021-01-12 | Jefferson | West Virginia | 54037 | 2828 | 28 |
923552 | 923552 | 2021-01-12 | Kanawha | West Virginia | 54039 | 9853 | 227 |
923553 | 923553 | 2021-01-12 | Lewis | West Virginia | 54041 | 663 | 8 |
923554 | 923554 | 2021-01-12 | Lincoln | West Virginia | 54043 | 954 | 9 |
923555 | 923555 | 2021-01-12 | Logan | West Virginia | 54045 | 1992 | 63 |
923556 | 923556 | 2021-01-12 | Marion | West Virginia | 54049 | 2580 | 19 |
923557 | 923557 | 2021-01-12 | Marshall | West Virginia | 54051 | 2433 | 57 |
923558 | 923558 | 2021-01-12 | Mason | West Virginia | 54053 | 1232 | 24 |
923559 | 923559 | 2021-01-12 | McDowell | West Virginia | 54047 | 1095 | 7 |
923560 | 923560 | 2021-01-12 | Mercer | West Virginia | 54055 | 3534 | 67 |
923561 | 923561 | 2021-01-12 | Mineral | West Virginia | 54057 | 2264 | 71 |
923562 | 923562 | 2021-01-12 | Mingo | West Virginia | 54059 | 1666 | 20 |
923563 | 923563 | 2021-01-12 | Monongalia | West Virginia | 54061 | 6157 | 49 |
923564 | 923564 | 2021-01-12 | Monroe | West Virginia | 54063 | 757 | 11 |
923565 | 923565 | 2021-01-12 | Morgan | West Virginia | 54065 | 784 | 9 |
923566 | 923566 | 2021-01-12 | Nicholas | West Virginia | 54067 | 856 | 9 |
923567 | 923567 | 2021-01-12 | Ohio | West Virginia | 54069 | 2906 | 51 |
923568 | 923568 | 2021-01-12 | Pendleton | West Virginia | 54071 | 410 | 2 |
923569 | 923569 | 2021-01-12 | Pleasants | West Virginia | 54073 | 692 | 7 |
923570 | 923570 | 2021-01-12 | Pocahontas | West Virginia | 54075 | 425 | 9 |
923571 | 923571 | 2021-01-12 | Preston | West Virginia | 54077 | 2043 | 34 |
923572 | 923572 | 2021-01-12 | Putnam | West Virginia | 54079 | 3348 | 61 |
923573 | 923573 | 2021-01-12 | Raleigh | West Virginia | 54081 | 3356 | 33 |
923574 | 923574 | 2021-01-12 | Randolph | West Virginia | 54083 | 1589 | 8 |
923575 | 923575 | 2021-01-12 | Ritchie | West Virginia | 54085 | 465 | 7 |
923576 | 923576 | 2021-01-12 | Roane | West Virginia | 54087 | 365 | 6 |
923577 | 923577 | 2021-01-12 | Summers | West Virginia | 54089 | 585 | 17 |
923578 | 923578 | 2021-01-12 | Taylor | West Virginia | 54091 | 853 | 13 |
923579 | 923579 | 2021-01-12 | Tucker | West Virginia | 54093 | 403 | 4 |
923580 | 923580 | 2021-01-12 | Tyler | West Virginia | 54095 | 447 | 3 |
923581 | 923581 | 2021-01-12 | Upshur | West Virginia | 54097 | 1188 | 12 |
923582 | 923582 | 2021-01-12 | Wayne | West Virginia | 54099 | 1993 | 24 |
923583 | 923583 | 2021-01-12 | Webster | West Virginia | 54101 | 198 | 0 |
923584 | 923584 | 2021-01-12 | Wetzel | West Virginia | 54103 | 833 | 16 |
923585 | 923585 | 2021-01-12 | Wirt | West Virginia | 54105 | 270 | 1 |
923586 | 923586 | 2021-01-12 | Wood | West Virginia | 54107 | 5857 | 62 |
923587 | 923587 | 2021-01-12 | Wyoming | West Virginia | 54109 | 1339 | 23 |
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);