ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where deaths = 100 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 |
---|---|---|---|---|---|---|---|
2291169 | 2291169 | 2022-03-09 | Wyoming | West Virginia | 54109 | 6903 | 100 |
2287917 | 2287917 | 2022-03-08 | Wyoming | West Virginia | 54109 | 6891 | 100 |
2284665 | 2284665 | 2022-03-07 | Wyoming | West Virginia | 54109 | 6887 | 100 |
2281413 | 2281413 | 2022-03-06 | Wyoming | West Virginia | 54109 | 6862 | 100 |
2278160 | 2278160 | 2022-03-05 | Wyoming | West Virginia | 54109 | 6862 | 100 |
2274907 | 2274907 | 2022-03-04 | Wyoming | West Virginia | 54109 | 6862 | 100 |
2271654 | 2271654 | 2022-03-03 | Wyoming | West Virginia | 54109 | 6855 | 100 |
2216381 | 2216381 | 2022-02-14 | Wayne | West Virginia | 54099 | 9464 | 100 |
2213130 | 2213130 | 2022-02-13 | Wayne | West Virginia | 54099 | 9451 | 100 |
2209877 | 2209877 | 2022-02-12 | Wayne | West Virginia | 54099 | 9415 | 100 |
2206624 | 2206624 | 2022-02-11 | Wayne | West Virginia | 54099 | 9379 | 100 |
2203371 | 2203371 | 2022-02-10 | Wayne | West Virginia | 54099 | 9334 | 100 |
2200117 | 2200117 | 2022-02-09 | Wayne | West Virginia | 54099 | 9288 | 100 |
2196863 | 2196863 | 2022-02-08 | Wayne | West Virginia | 54099 | 9246 | 100 |
2102494 | 2102494 | 2022-01-10 | Jefferson | West Virginia | 54037 | 11152 | 100 |
2099243 | 2099243 | 2022-01-09 | Jefferson | West Virginia | 54037 | 10970 | 100 |
2095992 | 2095992 | 2022-01-08 | Jefferson | West Virginia | 54037 | 10848 | 100 |
2092740 | 2092740 | 2022-01-07 | Jefferson | West Virginia | 54037 | 10615 | 100 |
1923705 | 1923705 | 2021-11-16 | Greenbrier | West Virginia | 54025 | 5112 | 100 |
1920456 | 1920456 | 2021-11-15 | Greenbrier | West Virginia | 54025 | 5106 | 100 |
1917206 | 1917206 | 2021-11-14 | Greenbrier | West Virginia | 54025 | 5097 | 100 |
1913956 | 1913956 | 2021-11-13 | Greenbrier | West Virginia | 54025 | 5088 | 100 |
1910706 | 1910706 | 2021-11-12 | Greenbrier | West Virginia | 54025 | 5076 | 100 |
1907457 | 1907457 | 2021-11-11 | Greenbrier | West Virginia | 54025 | 5067 | 100 |
1904208 | 1904208 | 2021-11-10 | Greenbrier | West Virginia | 54025 | 5053 | 100 |
1803501 | 1803501 | 2021-10-10 | Ohio | West Virginia | 54069 | 5854 | 100 |
1800252 | 1800252 | 2021-10-09 | Ohio | West Virginia | 54069 | 5832 | 100 |
1797003 | 1797003 | 2021-10-08 | Ohio | West Virginia | 54069 | 5809 | 100 |
1783988 | 1783988 | 2021-10-04 | Hancock | West Virginia | 54029 | 3819 | 100 |
1748263 | 1748263 | 2021-09-23 | Mineral | West Virginia | 54057 | 3953 | 100 |
1745013 | 1745013 | 2021-09-22 | Mineral | West Virginia | 54057 | 3934 | 100 |
1741764 | 1741764 | 2021-09-21 | Mineral | West Virginia | 54057 | 3921 | 100 |
1738515 | 1738515 | 2021-09-20 | Mineral | West Virginia | 54057 | 3892 | 100 |
1725504 | 1725504 | 2021-09-16 | Harrison | West Virginia | 54033 | 8205 | 100 |
1719021 | 1719021 | 2021-09-14 | Monongalia | West Virginia | 54061 | 10921 | 100 |
1673552 | 1673552 | 2021-08-31 | Putnam | West Virginia | 54079 | 6132 | 100 |
1663792 | 1663792 | 2021-08-28 | Logan | West Virginia | 54045 | 3680 | 100 |
1660544 | 1660544 | 2021-08-27 | Logan | West Virginia | 54045 | 3680 | 100 |
1540377 | 1540377 | 2021-07-21 | Raleigh | West Virginia | 54081 | 7132 | 100 |
1537130 | 1537130 | 2021-07-20 | Raleigh | West Virginia | 54081 | 7130 | 100 |
1533882 | 1533882 | 2021-07-19 | Raleigh | West Virginia | 54081 | 7128 | 100 |
1530635 | 1530635 | 2021-07-18 | Raleigh | West Virginia | 54081 | 7119 | 100 |
1527388 | 1527388 | 2021-07-17 | Raleigh | West Virginia | 54081 | 7119 | 100 |
1524141 | 1524141 | 2021-07-16 | Raleigh | West Virginia | 54081 | 7119 | 100 |
1520893 | 1520893 | 2021-07-15 | Raleigh | West Virginia | 54081 | 7113 | 100 |
1517645 | 1517645 | 2021-07-14 | Raleigh | West Virginia | 54081 | 7110 | 100 |
1261198 | 1261198 | 2021-04-26 | Putnam | West Virginia | 54079 | 4913 | 100 |
1257951 | 1257951 | 2021-04-25 | Putnam | West Virginia | 54079 | 4896 | 100 |
1254704 | 1254704 | 2021-04-24 | Putnam | West Virginia | 54079 | 4877 | 100 |
1251457 | 1251457 | 2021-04-23 | Putnam | West Virginia | 54079 | 4866 | 100 |
1248210 | 1248210 | 2021-04-22 | Putnam | West Virginia | 54079 | 4854 | 100 |
1244963 | 1244963 | 2021-04-21 | Putnam | West Virginia | 54079 | 4843 | 100 |
1241716 | 1241716 | 2021-04-20 | Putnam | West Virginia | 54079 | 4833 | 100 |
1238469 | 1238469 | 2021-04-19 | Putnam | West Virginia | 54079 | 4823 | 100 |
1235222 | 1235222 | 2021-04-18 | Putnam | West Virginia | 54079 | 4815 | 100 |
1231974 | 1231974 | 2021-04-17 | Putnam | West Virginia | 54079 | 4806 | 100 |
1228726 | 1228726 | 2021-04-16 | Putnam | West Virginia | 54079 | 4782 | 100 |
1225478 | 1225478 | 2021-04-15 | Putnam | West Virginia | 54079 | 4764 | 100 |
1111782 | 1111782 | 2021-03-11 | Berkeley | West Virginia | 54003 | 9931 | 100 |
1108536 | 1108536 | 2021-03-10 | Berkeley | West Virginia | 54003 | 9897 | 100 |
1105290 | 1105290 | 2021-03-09 | Berkeley | West Virginia | 54003 | 9864 | 100 |
1095550 | 1095550 | 2021-03-06 | Berkeley | West Virginia | 54003 | 9783 | 100 |
1092304 | 1092304 | 2021-03-05 | Berkeley | West Virginia | 54003 | 9751 | 100 |
1089058 | 1089058 | 2021-03-04 | Berkeley | West Virginia | 54003 | 9741 | 100 |
1085813 | 1085813 | 2021-03-03 | Berkeley | West Virginia | 54003 | 9722 | 100 |
1043644 | 1043644 | 2021-02-18 | Mercer | West Virginia | 54055 | 4126 | 100 |
1040399 | 1040399 | 2021-02-17 | Mercer | West Virginia | 54055 | 4123 | 100 |
965776 | 965776 | 2021-01-25 | Wood | West Virginia | 54107 | 6345 | 100 |
962531 | 962531 | 2021-01-24 | Wood | West Virginia | 54107 | 6326 | 100 |
631508 | 631508 | 2020-10-14 | Kanawha | West Virginia | 54039 | 3170 | 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);