ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where date = "2021-11-16" 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 |
---|---|---|---|---|---|---|---|
1923693 | 1923693 | 2021-11-16 | Barbour | West Virginia | 54001 | 2883 | 49 |
1923694 | 1923694 | 2021-11-16 | Berkeley | West Virginia | 54003 | 19461 | 190 |
1923695 | 1923695 | 2021-11-16 | Boone | West Virginia | 54005 | 3827 | 61 |
1923696 | 1923696 | 2021-11-16 | Braxton | West Virginia | 54007 | 2281 | 23 |
1923697 | 1923697 | 2021-11-16 | Brooke | West Virginia | 54009 | 3209 | 74 |
1923698 | 1923698 | 2021-11-16 | Cabell | West Virginia | 54011 | 15562 | 279 |
1923699 | 1923699 | 2021-11-16 | Calhoun | West Virginia | 54013 | 1011 | 5 |
1923700 | 1923700 | 2021-11-16 | Clay | West Virginia | 54015 | 1330 | 20 |
1923701 | 1923701 | 2021-11-16 | Doddridge | West Virginia | 54017 | 1386 | 11 |
1923702 | 1923702 | 2021-11-16 | Fayette | West Virginia | 54019 | 6511 | 133 |
1923703 | 1923703 | 2021-11-16 | Gilmer | West Virginia | 54021 | 1429 | 14 |
1923704 | 1923704 | 2021-11-16 | Grant | West Virginia | 54023 | 2331 | 36 |
1923705 | 1923705 | 2021-11-16 | Greenbrier | West Virginia | 54025 | 5112 | 100 |
1923706 | 1923706 | 2021-11-16 | Hampshire | West Virginia | 54027 | 3449 | 49 |
1923707 | 1923707 | 2021-11-16 | Hancock | West Virginia | 54029 | 4418 | 117 |
1923708 | 1923708 | 2021-11-16 | Hardy | West Virginia | 54031 | 2574 | 31 |
1923709 | 1923709 | 2021-11-16 | Harrison | West Virginia | 54033 | 11782 | 170 |
1923710 | 1923710 | 2021-11-16 | Jackson | West Virginia | 54035 | 4136 | 88 |
1923711 | 1923711 | 2021-11-16 | Jefferson | West Virginia | 54037 | 7092 | 89 |
1923712 | 1923712 | 2021-11-16 | Kanawha | West Virginia | 54039 | 25866 | 517 |
1923713 | 1923713 | 2021-11-16 | Lewis | West Virginia | 54041 | 3162 | 57 |
1923714 | 1923714 | 2021-11-16 | Lincoln | West Virginia | 54043 | 3126 | 48 |
1923715 | 1923715 | 2021-11-16 | Logan | West Virginia | 54045 | 5544 | 140 |
1923716 | 1923716 | 2021-11-16 | Marion | West Virginia | 54049 | 8680 | 111 |
1923717 | 1923717 | 2021-11-16 | Marshall | West Virginia | 54051 | 5492 | 117 |
1923718 | 1923718 | 2021-11-16 | Mason | West Virginia | 54053 | 3774 | 60 |
1923719 | 1923719 | 2021-11-16 | McDowell | West Virginia | 54047 | 3040 | 51 |
1923720 | 1923720 | 2021-11-16 | Mercer | West Virginia | 54055 | 9217 | 181 |
1923721 | 1923721 | 2021-11-16 | Mineral | West Virginia | 54057 | 4831 | 117 |
1923722 | 1923722 | 2021-11-16 | Mingo | West Virginia | 54059 | 4768 | 84 |
1923723 | 1923723 | 2021-11-16 | Monongalia | West Virginia | 54061 | 13976 | 146 |
1923724 | 1923724 | 2021-11-16 | Monroe | West Virginia | 54063 | 2185 | 26 |
1923725 | 1923725 | 2021-11-16 | Morgan | West Virginia | 54065 | 2214 | 48 |
1923726 | 1923726 | 2021-11-16 | Nicholas | West Virginia | 54067 | 4030 | 56 |
1923727 | 1923727 | 2021-11-16 | Ohio | West Virginia | 54069 | 6369 | 112 |
1923728 | 1923728 | 2021-11-16 | Pendleton | West Virginia | 54071 | 1151 | 15 |
1923729 | 1923729 | 2021-11-16 | Pleasants | West Virginia | 54073 | 1438 | 30 |
1923730 | 1923730 | 2021-11-16 | Pocahontas | West Virginia | 54075 | 1209 | 18 |
1923731 | 1923731 | 2021-11-16 | Preston | West Virginia | 54077 | 5564 | 94 |
1923732 | 1923732 | 2021-11-16 | Putnam | West Virginia | 54079 | 9352 | 128 |
1923733 | 1923733 | 2021-11-16 | Raleigh | West Virginia | 54081 | 11937 | 187 |
1923734 | 1923734 | 2021-11-16 | Randolph | West Virginia | 54083 | 5320 | 52 |
1923735 | 1923735 | 2021-11-16 | Ritchie | West Virginia | 54085 | 1508 | 21 |
1923736 | 1923736 | 2021-11-16 | Roane | West Virginia | 54087 | 1705 | 24 |
1923737 | 1923737 | 2021-11-16 | Summers | West Virginia | 54089 | 1486 | 31 |
1923738 | 1923738 | 2021-11-16 | Taylor | West Virginia | 54091 | 2489 | 40 |
1923739 | 1923739 | 2021-11-16 | Tucker | West Virginia | 54093 | 1202 | 30 |
1923740 | 1923740 | 2021-11-16 | Tyler | West Virginia | 54095 | 1389 | 24 |
1923741 | 1923741 | 2021-11-16 | Upshur | West Virginia | 54097 | 4272 | 67 |
1923742 | 1923742 | 2021-11-16 | Wayne | West Virginia | 54099 | 5839 | 88 |
1923743 | 1923743 | 2021-11-16 | Webster | West Virginia | 54101 | 1271 | 23 |
1923744 | 1923744 | 2021-11-16 | Wetzel | West Virginia | 54103 | 2682 | 58 |
1923745 | 1923745 | 2021-11-16 | Wirt | West Virginia | 54105 | 879 | 14 |
1923746 | 1923746 | 2021-11-16 | Wood | West Virginia | 54107 | 13600 | 255 |
1923747 | 1923747 | 2021-11-16 | Wyoming | West Virginia | 54109 | 3814 | 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);