ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where date = "2022-03-03" 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 |
---|---|---|---|---|---|---|---|
2271600 | 2271600 | 2022-03-03 | Barbour | West Virginia | 54001 | 4720 | 74 |
2271601 | 2271601 | 2022-03-03 | Berkeley | West Virginia | 54003 | 35329 | 261 |
2271602 | 2271602 | 2022-03-03 | Boone | West Virginia | 54005 | 6519 | 74 |
2271603 | 2271603 | 2022-03-03 | Braxton | West Virginia | 54007 | 3787 | 42 |
2271604 | 2271604 | 2022-03-03 | Brooke | West Virginia | 54009 | 4917 | 103 |
2271605 | 2271605 | 2022-03-03 | Cabell | West Virginia | 54011 | 27063 | 355 |
2271606 | 2271606 | 2022-03-03 | Calhoun | West Virginia | 54013 | 1803 | 13 |
2271607 | 2271607 | 2022-03-03 | Clay | West Virginia | 54015 | 2311 | 36 |
2271608 | 2271608 | 2022-03-03 | Doddridge | West Virginia | 54017 | 2129 | 18 |
2271609 | 2271609 | 2022-03-03 | Fayette | West Virginia | 54019 | 12853 | 178 |
2271610 | 2271610 | 2022-03-03 | Gilmer | West Virginia | 54021 | 2070 | 18 |
2271611 | 2271611 | 2022-03-03 | Grant | West Virginia | 54023 | 3746 | 56 |
2271612 | 2271612 | 2022-03-03 | Greenbrier | West Virginia | 54025 | 9308 | 146 |
2271613 | 2271613 | 2022-03-03 | Hampshire | West Virginia | 54027 | 5772 | 67 |
2271614 | 2271614 | 2022-03-03 | Hancock | West Virginia | 54029 | 6634 | 139 |
2271615 | 2271615 | 2022-03-03 | Hardy | West Virginia | 54031 | 4153 | 48 |
2271616 | 2271616 | 2022-03-03 | Harrison | West Virginia | 54033 | 19589 | 243 |
2271617 | 2271617 | 2022-03-03 | Jackson | West Virginia | 54035 | 6804 | 130 |
2271618 | 2271618 | 2022-03-03 | Jefferson | West Virginia | 54037 | 14077 | 131 |
2271619 | 2271619 | 2022-03-03 | Kanawha | West Virginia | 54039 | 46690 | 683 |
2271620 | 2271620 | 2022-03-03 | Lewis | West Virginia | 54041 | 5239 | 78 |
2271621 | 2271621 | 2022-03-03 | Lincoln | West Virginia | 54043 | 5444 | 70 |
2271622 | 2271622 | 2022-03-03 | Logan | West Virginia | 54045 | 9492 | 169 |
2271623 | 2271623 | 2022-03-03 | Marion | West Virginia | 54049 | 14629 | 164 |
2271624 | 2271624 | 2022-03-03 | Marshall | West Virginia | 54051 | 8721 | 150 |
2271625 | 2271625 | 2022-03-03 | Mason | West Virginia | 54053 | 6549 | 88 |
2271626 | 2271626 | 2022-03-03 | McDowell | West Virginia | 54047 | 5469 | 63 |
2271627 | 2271627 | 2022-03-03 | Mercer | West Virginia | 54055 | 16642 | 249 |
2271628 | 2271628 | 2022-03-03 | Mineral | West Virginia | 54057 | 7785 | 153 |
2271629 | 2271629 | 2022-03-03 | Mingo | West Virginia | 54059 | 7820 | 119 |
2271630 | 2271630 | 2022-03-03 | Monongalia | West Virginia | 54061 | 24197 | 192 |
2271631 | 2271631 | 2022-03-03 | Monroe | West Virginia | 54063 | 4137 | 40 |
2271632 | 2271632 | 2022-03-03 | Morgan | West Virginia | 54065 | 4203 | 67 |
2271633 | 2271633 | 2022-03-03 | Nicholas | West Virginia | 54067 | 7177 | 90 |
2271634 | 2271634 | 2022-03-03 | Ohio | West Virginia | 54069 | 10950 | 156 |
2271635 | 2271635 | 2022-03-03 | Pendleton | West Virginia | 54071 | 1918 | 17 |
2271636 | 2271636 | 2022-03-03 | Pleasants | West Virginia | 54073 | 2047 | 34 |
2271637 | 2271637 | 2022-03-03 | Pocahontas | West Virginia | 54075 | 1983 | 27 |
2271638 | 2271638 | 2022-03-03 | Preston | West Virginia | 54077 | 9090 | 126 |
2271639 | 2271639 | 2022-03-03 | Putnam | West Virginia | 54079 | 16460 | 170 |
2271640 | 2271640 | 2022-03-03 | Raleigh | West Virginia | 54081 | 22332 | 314 |
2271641 | 2271641 | 2022-03-03 | Randolph | West Virginia | 54083 | 9252 | 77 |
2271642 | 2271642 | 2022-03-03 | Ritchie | West Virginia | 54085 | 2391 | 30 |
2271643 | 2271643 | 2022-03-03 | Roane | West Virginia | 54087 | 3108 | 36 |
2271644 | 2271644 | 2022-03-03 | Summers | West Virginia | 54089 | 2755 | 49 |
2271645 | 2271645 | 2022-03-03 | Taylor | West Virginia | 54091 | 4433 | 64 |
2271646 | 2271646 | 2022-03-03 | Tucker | West Virginia | 54093 | 1939 | 33 |
2271647 | 2271647 | 2022-03-03 | Tyler | West Virginia | 54095 | 2164 | 30 |
2271648 | 2271648 | 2022-03-03 | Upshur | West Virginia | 54097 | 6733 | 81 |
2271649 | 2271649 | 2022-03-03 | Wayne | West Virginia | 54099 | 9731 | 111 |
2271650 | 2271650 | 2022-03-03 | Webster | West Virginia | 54101 | 2160 | 28 |
2271651 | 2271651 | 2022-03-03 | Wetzel | West Virginia | 54103 | 4259 | 80 |
2271652 | 2271652 | 2022-03-03 | Wirt | West Virginia | 54105 | 1426 | 23 |
2271653 | 2271653 | 2022-03-03 | Wood | West Virginia | 54107 | 21934 | 334 |
2271654 | 2271654 | 2022-03-03 | Wyoming | West Virginia | 54109 | 6855 | 100 |
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);