ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where deaths = 70 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 |
---|---|---|---|---|---|---|---|
2336667 | 2336667 | 2022-03-23 | Hampshire | West Virginia | 54027 | 5811 | 70 |
2333413 | 2333413 | 2022-03-22 | Hampshire | West Virginia | 54027 | 5810 | 70 |
2330159 | 2330159 | 2022-03-21 | Hampshire | West Virginia | 54027 | 5806 | 70 |
2330191 | 2330191 | 2022-03-21 | Taylor | West Virginia | 54091 | 4497 | 70 |
2326907 | 2326907 | 2022-03-20 | Hampshire | West Virginia | 54027 | 5803 | 70 |
2326939 | 2326939 | 2022-03-20 | Taylor | West Virginia | 54091 | 4492 | 70 |
2323654 | 2323654 | 2022-03-19 | Hampshire | West Virginia | 54027 | 5803 | 70 |
2323686 | 2323686 | 2022-03-19 | Taylor | West Virginia | 54091 | 4492 | 70 |
2320400 | 2320400 | 2022-03-18 | Hampshire | West Virginia | 54027 | 5803 | 70 |
2320432 | 2320432 | 2022-03-18 | Taylor | West Virginia | 54091 | 4492 | 70 |
2317146 | 2317146 | 2022-03-17 | Hampshire | West Virginia | 54027 | 5801 | 70 |
2317178 | 2317178 | 2022-03-17 | Taylor | West Virginia | 54091 | 4488 | 70 |
2313893 | 2313893 | 2022-03-16 | Hampshire | West Virginia | 54027 | 5800 | 70 |
2313925 | 2313925 | 2022-03-16 | Taylor | West Virginia | 54091 | 4482 | 70 |
2310672 | 2310672 | 2022-03-15 | Taylor | West Virginia | 54091 | 4479 | 70 |
2307419 | 2307419 | 2022-03-14 | Taylor | West Virginia | 54091 | 4477 | 70 |
2284632 | 2284632 | 2022-03-07 | Lincoln | West Virginia | 54043 | 5465 | 70 |
2281380 | 2281380 | 2022-03-06 | Lincoln | West Virginia | 54043 | 5452 | 70 |
2278127 | 2278127 | 2022-03-05 | Lincoln | West Virginia | 54043 | 5452 | 70 |
2274874 | 2274874 | 2022-03-04 | Lincoln | West Virginia | 54043 | 5452 | 70 |
2271621 | 2271621 | 2022-03-03 | Lincoln | West Virginia | 54043 | 5444 | 70 |
2245590 | 2245590 | 2022-02-23 | Barbour | West Virginia | 54001 | 4646 | 70 |
2242341 | 2242341 | 2022-02-22 | Boone | West Virginia | 54005 | 6463 | 70 |
2235878 | 2235878 | 2022-02-20 | Randolph | West Virginia | 54083 | 9064 | 70 |
2232627 | 2232627 | 2022-02-19 | Randolph | West Virginia | 54083 | 9064 | 70 |
2229376 | 2229376 | 2022-02-18 | Randolph | West Virginia | 54083 | 9064 | 70 |
2226125 | 2226125 | 2022-02-17 | Randolph | West Virginia | 54083 | 9066 | 70 |
2151318 | 2151318 | 2022-01-25 | Wetzel | West Virginia | 54103 | 3693 | 70 |
2148066 | 2148066 | 2022-01-24 | Wetzel | West Virginia | 54103 | 3683 | 70 |
2144783 | 2144783 | 2022-01-23 | Lewis | West Virginia | 54041 | 4337 | 70 |
2141528 | 2141528 | 2022-01-22 | Lewis | West Virginia | 54041 | 4293 | 70 |
2138272 | 2138272 | 2022-01-21 | Lewis | West Virginia | 54041 | 4240 | 70 |
2135017 | 2135017 | 2022-01-20 | Lewis | West Virginia | 54041 | 4185 | 70 |
2131765 | 2131765 | 2022-01-19 | Lewis | West Virginia | 54041 | 4129 | 70 |
2128511 | 2128511 | 2022-01-18 | Lewis | West Virginia | 54041 | 4098 | 70 |
2125258 | 2125258 | 2022-01-17 | Lewis | West Virginia | 54041 | 4080 | 70 |
2122006 | 2122006 | 2022-01-16 | Lewis | West Virginia | 54041 | 4065 | 70 |
2118754 | 2118754 | 2022-01-15 | Lewis | West Virginia | 54041 | 4045 | 70 |
2115502 | 2115502 | 2022-01-14 | Lewis | West Virginia | 54041 | 4003 | 70 |
2112250 | 2112250 | 2022-01-13 | Lewis | West Virginia | 54041 | 3969 | 70 |
2082992 | 2082992 | 2022-01-04 | Mason | West Virginia | 54053 | 4444 | 70 |
2079740 | 2079740 | 2022-01-03 | Mason | West Virginia | 54053 | 4424 | 70 |
2014742 | 2014742 | 2021-12-14 | Nicholas | West Virginia | 54067 | 4580 | 70 |
2011491 | 2011491 | 2021-12-13 | Nicholas | West Virginia | 54067 | 4563 | 70 |
2008240 | 2008240 | 2021-12-12 | Nicholas | West Virginia | 54067 | 4553 | 70 |
2004989 | 2004989 | 2021-12-11 | Nicholas | West Virginia | 54067 | 4531 | 70 |
2001738 | 2001738 | 2021-12-10 | Nicholas | West Virginia | 54067 | 4496 | 70 |
1995252 | 1995252 | 2021-12-08 | Upshur | West Virginia | 54097 | 4538 | 70 |
1992001 | 1992001 | 2021-12-07 | Upshur | West Virginia | 54097 | 4532 | 70 |
1988750 | 1988750 | 2021-12-06 | Upshur | West Virginia | 54097 | 4521 | 70 |
1985500 | 1985500 | 2021-12-05 | Upshur | West Virginia | 54097 | 4510 | 70 |
1982250 | 1982250 | 2021-12-04 | Upshur | West Virginia | 54097 | 4503 | 70 |
1979000 | 1979000 | 2021-12-03 | Upshur | West Virginia | 54097 | 4490 | 70 |
1975750 | 1975750 | 2021-12-02 | Upshur | West Virginia | 54097 | 4477 | 70 |
1946494 | 1946494 | 2021-11-23 | Upshur | West Virginia | 54097 | 4364 | 70 |
1826260 | 1826260 | 2021-10-17 | Wayne | West Virginia | 54099 | 5520 | 70 |
1823011 | 1823011 | 2021-10-16 | Wayne | West Virginia | 54099 | 5512 | 70 |
1819762 | 1819762 | 2021-10-15 | Wayne | West Virginia | 54099 | 5483 | 70 |
1816513 | 1816513 | 2021-10-14 | Wayne | West Virginia | 54099 | 5462 | 70 |
1806747 | 1806747 | 2021-10-11 | Mingo | West Virginia | 54059 | 4349 | 70 |
1803496 | 1803496 | 2021-10-10 | Mingo | West Virginia | 54059 | 4334 | 70 |
1800247 | 1800247 | 2021-10-09 | Mingo | West Virginia | 54059 | 4324 | 70 |
1796998 | 1796998 | 2021-10-08 | Mingo | West Virginia | 54059 | 4303 | 70 |
1767743 | 1767743 | 2021-09-29 | Jackson | West Virginia | 54035 | 3378 | 70 |
1741754 | 1741754 | 2021-09-21 | Jefferson | West Virginia | 54037 | 5981 | 70 |
1738505 | 1738505 | 2021-09-20 | Jefferson | West Virginia | 54037 | 5947 | 70 |
1722251 | 1722251 | 2021-09-15 | Greenbrier | West Virginia | 54025 | 3964 | 70 |
1719003 | 1719003 | 2021-09-14 | Greenbrier | West Virginia | 54025 | 3948 | 70 |
1176761 | 1176761 | 2021-03-31 | Raleigh | West Virginia | 54081 | 5533 | 70 |
1173514 | 1173514 | 2021-03-30 | Raleigh | West Virginia | 54081 | 5494 | 70 |
1111790 | 1111790 | 2021-03-11 | Fayette | West Virginia | 54019 | 2743 | 70 |
1111797 | 1111797 | 2021-03-11 | Harrison | West Virginia | 54033 | 4937 | 70 |
1108544 | 1108544 | 2021-03-10 | Fayette | West Virginia | 54019 | 2732 | 70 |
1108551 | 1108551 | 2021-03-10 | Harrison | West Virginia | 54033 | 4922 | 70 |
1105298 | 1105298 | 2021-03-09 | Fayette | West Virginia | 54019 | 2731 | 70 |
1105305 | 1105305 | 2021-03-09 | Harrison | West Virginia | 54033 | 4919 | 70 |
1102052 | 1102052 | 2021-03-08 | Fayette | West Virginia | 54019 | 2726 | 70 |
1098806 | 1098806 | 2021-03-07 | Fayette | West Virginia | 54019 | 2719 | 70 |
1098813 | 1098813 | 2021-03-07 | Harrison | West Virginia | 54033 | 4901 | 70 |
1095558 | 1095558 | 2021-03-06 | Fayette | West Virginia | 54019 | 2721 | 70 |
1095565 | 1095565 | 2021-03-06 | Harrison | West Virginia | 54033 | 4880 | 70 |
1092312 | 1092312 | 2021-03-05 | Fayette | West Virginia | 54019 | 2710 | 70 |
1092319 | 1092319 | 2021-03-05 | Harrison | West Virginia | 54033 | 4866 | 70 |
1089066 | 1089066 | 2021-03-04 | Fayette | West Virginia | 54019 | 2692 | 70 |
1089073 | 1089073 | 2021-03-04 | Harrison | West Virginia | 54033 | 4862 | 70 |
1085821 | 1085821 | 2021-03-03 | Fayette | West Virginia | 54019 | 2684 | 70 |
1085828 | 1085828 | 2021-03-03 | Harrison | West Virginia | 54033 | 4854 | 70 |
1082575 | 1082575 | 2021-03-02 | Fayette | West Virginia | 54019 | 2677 | 70 |
1082582 | 1082582 | 2021-03-02 | Harrison | West Virginia | 54033 | 4846 | 70 |
1082596 | 1082596 | 2021-03-02 | Monongalia | West Virginia | 54061 | 8054 | 70 |
1079329 | 1079329 | 2021-03-01 | Fayette | West Virginia | 54019 | 2677 | 70 |
1079336 | 1079336 | 2021-03-01 | Harrison | West Virginia | 54033 | 4843 | 70 |
1079350 | 1079350 | 2021-03-01 | Monongalia | West Virginia | 54061 | 8049 | 70 |
1076084 | 1076084 | 2021-02-28 | Fayette | West Virginia | 54019 | 2661 | 70 |
1076091 | 1076091 | 2021-02-28 | Harrison | West Virginia | 54033 | 4835 | 70 |
1076105 | 1076105 | 2021-02-28 | Monongalia | West Virginia | 54061 | 8025 | 70 |
1072838 | 1072838 | 2021-02-27 | Fayette | West Virginia | 54019 | 2655 | 70 |
1072845 | 1072845 | 2021-02-27 | Harrison | West Virginia | 54033 | 4827 | 70 |
1072859 | 1072859 | 2021-02-27 | Monongalia | West Virginia | 54061 | 7994 | 70 |
1069592 | 1069592 | 2021-02-26 | Fayette | West Virginia | 54019 | 2644 | 70 |
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);