ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where deaths = 45 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 |
---|---|---|---|---|---|---|---|
2356202 | 2356202 | 2022-03-29 | Monroe | West Virginia | 54063 | 4175 | 45 |
2203337 | 2203337 | 2022-02-10 | Hardy | West Virginia | 54031 | 4085 | 45 |
2200083 | 2200083 | 2022-02-09 | Hardy | West Virginia | 54031 | 4072 | 45 |
2200112 | 2200112 | 2022-02-09 | Summers | West Virginia | 54089 | 2605 | 45 |
2196829 | 2196829 | 2022-02-08 | Hardy | West Virginia | 54031 | 4056 | 45 |
2196858 | 2196858 | 2022-02-08 | Summers | West Virginia | 54089 | 2580 | 45 |
1900967 | 1900967 | 2021-11-09 | Lincoln | West Virginia | 54043 | 3030 | 45 |
1897696 | 1897696 | 2021-11-08 | Barbour | West Virginia | 54001 | 2779 | 45 |
1894446 | 1894446 | 2021-11-07 | Barbour | West Virginia | 54001 | 2772 | 45 |
1894467 | 1894467 | 2021-11-07 | Lincoln | West Virginia | 54043 | 3336 | 45 |
1891196 | 1891196 | 2021-11-06 | Barbour | West Virginia | 54001 | 2769 | 45 |
1891217 | 1891217 | 2021-11-06 | Lincoln | West Virginia | 54043 | 2979 | 45 |
1887946 | 1887946 | 2021-11-05 | Barbour | West Virginia | 54001 | 2759 | 45 |
1887967 | 1887967 | 2021-11-05 | Lincoln | West Virginia | 54043 | 2965 | 45 |
1884696 | 1884696 | 2021-11-04 | Barbour | West Virginia | 54001 | 2749 | 45 |
1884717 | 1884717 | 2021-11-04 | Lincoln | West Virginia | 54043 | 2926 | 45 |
1881447 | 1881447 | 2021-11-03 | Barbour | West Virginia | 54001 | 2744 | 45 |
1881468 | 1881468 | 2021-11-03 | Lincoln | West Virginia | 54043 | 2899 | 45 |
1878198 | 1878198 | 2021-11-02 | Barbour | West Virginia | 54001 | 2736 | 45 |
1874981 | 1874981 | 2021-11-01 | Morgan | West Virginia | 54065 | 2122 | 45 |
1816484 | 1816484 | 2021-10-14 | Lewis | West Virginia | 54041 | 2886 | 45 |
1800220 | 1800220 | 2021-10-09 | Boone | West Virginia | 54005 | 3313 | 45 |
1796971 | 1796971 | 2021-10-08 | Boone | West Virginia | 54005 | 3295 | 45 |
1745010 | 1745010 | 2021-09-22 | Mason | West Virginia | 54053 | 3066 | 45 |
1741761 | 1741761 | 2021-09-21 | Mason | West Virginia | 54053 | 3033 | 45 |
1741790 | 1741790 | 2021-09-21 | Wyoming | West Virginia | 54109 | 3088 | 45 |
1738512 | 1738512 | 2021-09-20 | Mason | West Virginia | 54053 | 3010 | 45 |
1738541 | 1738541 | 2021-09-20 | Wyoming | West Virginia | 54109 | 3075 | 45 |
1735263 | 1735263 | 2021-09-19 | Mason | West Virginia | 54053 | 3003 | 45 |
1732013 | 1732013 | 2021-09-18 | Mason | West Virginia | 54053 | 2985 | 45 |
1728763 | 1728763 | 2021-09-17 | Mason | West Virginia | 54053 | 2961 | 45 |
1719039 | 1719039 | 2021-09-14 | Upshur | West Virginia | 54097 | 3138 | 45 |
1631313 | 1631313 | 2021-08-18 | Mingo | West Virginia | 54059 | 2930 | 45 |
1628066 | 1628066 | 2021-08-17 | Mingo | West Virginia | 54059 | 2922 | 45 |
1624819 | 1624819 | 2021-08-16 | Mingo | West Virginia | 54059 | 2903 | 45 |
1621572 | 1621572 | 2021-08-15 | Mingo | West Virginia | 54059 | 2885 | 45 |
1618324 | 1618324 | 2021-08-14 | Mingo | West Virginia | 54059 | 2885 | 45 |
1615076 | 1615076 | 2021-08-13 | Mingo | West Virginia | 54059 | 2885 | 45 |
1611827 | 1611827 | 2021-08-12 | Mingo | West Virginia | 54059 | 2885 | 45 |
1608580 | 1608580 | 2021-08-11 | Mingo | West Virginia | 54059 | 2877 | 45 |
1605331 | 1605331 | 2021-08-10 | Mingo | West Virginia | 54059 | 2865 | 45 |
1602081 | 1602081 | 2021-08-09 | Mingo | West Virginia | 54059 | 2853 | 45 |
1277417 | 1277417 | 2021-05-01 | Marion | West Virginia | 54049 | 4311 | 45 |
1274170 | 1274170 | 2021-04-30 | Marion | West Virginia | 54049 | 4306 | 45 |
1270923 | 1270923 | 2021-04-29 | Marion | West Virginia | 54049 | 4293 | 45 |
1267676 | 1267676 | 2021-04-28 | Marion | West Virginia | 54049 | 4279 | 45 |
1264429 | 1264429 | 2021-04-27 | Marion | West Virginia | 54049 | 4270 | 45 |
1150759 | 1150759 | 2021-03-23 | Jefferson | West Virginia | 54037 | 3864 | 45 |
1147512 | 1147512 | 2021-03-22 | Jefferson | West Virginia | 54037 | 3854 | 45 |
1144265 | 1144265 | 2021-03-21 | Jefferson | West Virginia | 54037 | 3837 | 45 |
1141018 | 1141018 | 2021-03-20 | Jefferson | West Virginia | 54037 | 3814 | 45 |
1134531 | 1134531 | 2021-03-18 | Marion | West Virginia | 54049 | 3822 | 45 |
1131283 | 1131283 | 2021-03-17 | Marion | West Virginia | 54049 | 3805 | 45 |
1128036 | 1128036 | 2021-03-16 | Marion | West Virginia | 54049 | 3793 | 45 |
1124805 | 1124805 | 2021-03-15 | Preston | West Virginia | 54077 | 2631 | 45 |
1121559 | 1121559 | 2021-03-14 | Preston | West Virginia | 54077 | 2626 | 45 |
1118312 | 1118312 | 2021-03-13 | Preston | West Virginia | 54077 | 2618 | 45 |
1115065 | 1115065 | 2021-03-12 | Preston | West Virginia | 54077 | 2612 | 45 |
1011181 | 1011181 | 2021-02-08 | Jackson | West Virginia | 54035 | 1614 | 45 |
1007935 | 1007935 | 2021-02-07 | Jackson | West Virginia | 54035 | 1607 | 45 |
1004689 | 1004689 | 2021-02-06 | Jackson | West Virginia | 54035 | 1598 | 45 |
1001443 | 1001443 | 2021-02-05 | Jackson | West Virginia | 54035 | 1591 | 45 |
998197 | 998197 | 2021-02-04 | Jackson | West Virginia | 54035 | 1579 | 45 |
994951 | 994951 | 2021-02-03 | Jackson | West Virginia | 54035 | 1571 | 45 |
991705 | 991705 | 2021-02-02 | Jackson | West Virginia | 54035 | 1576 | 45 |
988459 | 988459 | 2021-02-01 | Jackson | West Virginia | 54035 | 1566 | 45 |
985212 | 985212 | 2021-01-31 | Jackson | West Virginia | 54035 | 1573 | 45 |
981965 | 981965 | 2021-01-30 | Jackson | West Virginia | 54035 | 1592 | 45 |
978719 | 978719 | 2021-01-29 | Jackson | West Virginia | 54035 | 1579 | 45 |
975474 | 975474 | 2021-01-28 | Jackson | West Virginia | 54035 | 1580 | 45 |
972229 | 972229 | 2021-01-27 | Jackson | West Virginia | 54035 | 1570 | 45 |
968984 | 968984 | 2021-01-26 | Jackson | West Virginia | 54035 | 1560 | 45 |
956003 | 956003 | 2021-01-22 | Harrison | West Virginia | 54033 | 4180 | 45 |
952758 | 952758 | 2021-01-21 | Harrison | West Virginia | 54033 | 4157 | 45 |
943016 | 943016 | 2021-01-18 | Greenbrier | West Virginia | 54025 | 2056 | 45 |
939763 | 939763 | 2021-01-17 | Brooke | West Virginia | 54009 | 1741 | 45 |
939771 | 939771 | 2021-01-17 | Greenbrier | West Virginia | 54025 | 2037 | 45 |
936526 | 936526 | 2021-01-16 | Greenbrier | West Virginia | 54025 | 2024 | 45 |
933281 | 933281 | 2021-01-15 | Greenbrier | West Virginia | 54025 | 1978 | 45 |
920318 | 920318 | 2021-01-11 | Monongalia | West Virginia | 54061 | 6110 | 45 |
917073 | 917073 | 2021-01-10 | Monongalia | West Virginia | 54061 | 6049 | 45 |
913828 | 913828 | 2021-01-09 | Monongalia | West Virginia | 54061 | 5989 | 45 |
907342 | 907342 | 2021-01-07 | Ohio | West Virginia | 54069 | 2721 | 45 |
891133 | 891133 | 2021-01-02 | Wood | West Virginia | 54107 | 5146 | 45 |
887886 | 887886 | 2021-01-01 | Wood | West Virginia | 54107 | 5038 | 45 |
842403 | 842403 | 2020-12-18 | Berkeley | West Virginia | 54003 | 4981 | 45 |
829446 | 829446 | 2020-12-14 | Mercer | West Virginia | 54055 | 1834 | 45 |
826200 | 826200 | 2020-12-13 | Mercer | West Virginia | 54055 | 1781 | 45 |
822953 | 822953 | 2020-12-12 | Mercer | West Virginia | 54055 | 1732 | 45 |
819707 | 819707 | 2020-12-11 | Mercer | West Virginia | 54055 | 1670 | 45 |
816461 | 816461 | 2020-12-10 | Mercer | West Virginia | 54055 | 1652 | 45 |
813215 | 813215 | 2020-12-09 | Mercer | West Virginia | 54055 | 1617 | 45 |
741796 | 741796 | 2020-11-17 | Cabell | West Virginia | 54011 | 2229 | 45 |
738549 | 738549 | 2020-11-16 | Cabell | West Virginia | 54011 | 2192 | 45 |
683423 | 683423 | 2020-10-30 | Logan | West Virginia | 54045 | 785 | 45 |
680180 | 680180 | 2020-10-29 | Logan | West Virginia | 54045 | 770 | 45 |
676937 | 676937 | 2020-10-28 | Logan | West Virginia | 54045 | 757 | 45 |
673694 | 673694 | 2020-10-27 | Logan | West Virginia | 54045 | 751 | 45 |
670452 | 670452 | 2020-10-26 | Logan | West Virginia | 54045 | 748 | 45 |
667209 | 667209 | 2020-10-25 | Logan | West Virginia | 54045 | 744 | 45 |
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);