ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Fayette" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177306 | 2177306 | 2022-02-02 | Fayette | West Virginia | 54019 | 11369 | 158 |
2174053 | 2174053 | 2022-02-01 | Fayette | West Virginia | 54019 | 11290 | 158 |
2170801 | 2170801 | 2022-01-31 | Fayette | West Virginia | 54019 | 11214 | 158 |
2167548 | 2167548 | 2022-01-30 | Fayette | West Virginia | 54019 | 11119 | 158 |
2164293 | 2164293 | 2022-01-29 | Fayette | West Virginia | 54019 | 10884 | 158 |
2161038 | 2161038 | 2022-01-28 | Fayette | West Virginia | 54019 | 10769 | 158 |
2157782 | 2157782 | 2022-01-27 | Fayette | West Virginia | 54019 | 10596 | 156 |
2154529 | 2154529 | 2022-01-26 | Fayette | West Virginia | 54019 | 10404 | 155 |
2151276 | 2151276 | 2022-01-25 | Fayette | West Virginia | 54019 | 10285 | 154 |
2148024 | 2148024 | 2022-01-24 | Fayette | West Virginia | 54019 | 10231 | 154 |
2144772 | 2144772 | 2022-01-23 | Fayette | West Virginia | 54019 | 10121 | 153 |
2141517 | 2141517 | 2022-01-22 | Fayette | West Virginia | 54019 | 9949 | 153 |
2138261 | 2138261 | 2022-01-21 | Fayette | West Virginia | 54019 | 9695 | 153 |
2135006 | 2135006 | 2022-01-20 | Fayette | West Virginia | 54019 | 9496 | 153 |
2131754 | 2131754 | 2022-01-19 | Fayette | West Virginia | 54019 | 9362 | 153 |
2128500 | 2128500 | 2022-01-18 | Fayette | West Virginia | 54019 | 9246 | 153 |
2125247 | 2125247 | 2022-01-17 | Fayette | West Virginia | 54019 | 9190 | 153 |
2121995 | 2121995 | 2022-01-16 | Fayette | West Virginia | 54019 | 9086 | 153 |
2118743 | 2118743 | 2022-01-15 | Fayette | West Virginia | 54019 | 8924 | 153 |
2115491 | 2115491 | 2022-01-14 | Fayette | West Virginia | 54019 | 8787 | 153 |
2112239 | 2112239 | 2022-01-13 | Fayette | West Virginia | 54019 | 8646 | 153 |
2108987 | 2108987 | 2022-01-12 | Fayette | West Virginia | 54019 | 8478 | 152 |
2105736 | 2105736 | 2022-01-11 | Fayette | West Virginia | 54019 | 8367 | 152 |
2102485 | 2102485 | 2022-01-10 | Fayette | West Virginia | 54019 | 8319 | 152 |
2099234 | 2099234 | 2022-01-09 | Fayette | West Virginia | 54019 | 8255 | 152 |
2095983 | 2095983 | 2022-01-08 | Fayette | West Virginia | 54019 | 8237 | 152 |
2092731 | 2092731 | 2022-01-07 | Fayette | West Virginia | 54019 | 8157 | 152 |
2089479 | 2089479 | 2022-01-06 | Fayette | West Virginia | 54019 | 8058 | 152 |
2086228 | 2086228 | 2022-01-05 | Fayette | West Virginia | 54019 | 7972 | 152 |
2082976 | 2082976 | 2022-01-04 | Fayette | West Virginia | 54019 | 7909 | 152 |
2079724 | 2079724 | 2022-01-03 | Fayette | West Virginia | 54019 | 7875 | 152 |
2076472 | 2076472 | 2022-01-02 | Fayette | West Virginia | 54019 | 7687 | 151 |
2073221 | 2073221 | 2022-01-01 | Fayette | West Virginia | 54019 | 7687 | 151 |
2069970 | 2069970 | 2021-12-31 | Fayette | West Virginia | 54019 | 7687 | 151 |
2066719 | 2066719 | 2021-12-30 | Fayette | West Virginia | 54019 | 7687 | 151 |
2063469 | 2063469 | 2021-12-29 | Fayette | West Virginia | 54019 | 7643 | 151 |
2060219 | 2060219 | 2021-12-28 | Fayette | West Virginia | 54019 | 7600 | 150 |
2056970 | 2056970 | 2021-12-27 | Fayette | West Virginia | 54019 | 7573 | 147 |
2053721 | 2053721 | 2021-12-26 | Fayette | West Virginia | 54019 | 7502 | 147 |
2050471 | 2050471 | 2021-12-25 | Fayette | West Virginia | 54019 | 7502 | 147 |
2047221 | 2047221 | 2021-12-24 | Fayette | West Virginia | 54019 | 7502 | 147 |
2043971 | 2043971 | 2021-12-23 | Fayette | West Virginia | 54019 | 7502 | 147 |
2040722 | 2040722 | 2021-12-22 | Fayette | West Virginia | 54019 | 7466 | 147 |
2037472 | 2037472 | 2021-12-21 | Fayette | West Virginia | 54019 | 7433 | 145 |
2034222 | 2034222 | 2021-12-20 | Fayette | West Virginia | 54019 | 7416 | 144 |
2030972 | 2030972 | 2021-12-19 | Fayette | West Virginia | 54019 | 7387 | 144 |
2027721 | 2027721 | 2021-12-18 | Fayette | West Virginia | 54019 | 7339 | 144 |
2024470 | 2024470 | 2021-12-17 | Fayette | West Virginia | 54019 | 7309 | 144 |
2021219 | 2021219 | 2021-12-16 | Fayette | West Virginia | 54019 | 7277 | 144 |
2017968 | 2017968 | 2021-12-15 | Fayette | West Virginia | 54019 | 7234 | 144 |
2014718 | 2014718 | 2021-12-14 | Fayette | West Virginia | 54019 | 7181 | 144 |
2011467 | 2011467 | 2021-12-13 | Fayette | West Virginia | 54019 | 7172 | 143 |
2008216 | 2008216 | 2021-12-12 | Fayette | West Virginia | 54019 | 7105 | 141 |
2004965 | 2004965 | 2021-12-11 | Fayette | West Virginia | 54019 | 7078 | 141 |
2001714 | 2001714 | 2021-12-10 | Fayette | West Virginia | 54019 | 7048 | 141 |
1998464 | 1998464 | 2021-12-09 | Fayette | West Virginia | 54019 | 7017 | 140 |
1995213 | 1995213 | 2021-12-08 | Fayette | West Virginia | 54019 | 6985 | 140 |
1991962 | 1991962 | 2021-12-07 | Fayette | West Virginia | 54019 | 6973 | 140 |
1988711 | 1988711 | 2021-12-06 | Fayette | West Virginia | 54019 | 6962 | 138 |
1985461 | 1985461 | 2021-12-05 | Fayette | West Virginia | 54019 | 6940 | 137 |
1982211 | 1982211 | 2021-12-04 | Fayette | West Virginia | 54019 | 6913 | 137 |
1978961 | 1978961 | 2021-12-03 | Fayette | West Virginia | 54019 | 6879 | 137 |
1975711 | 1975711 | 2021-12-02 | Fayette | West Virginia | 54019 | 6840 | 137 |
1972462 | 1972462 | 2021-12-01 | Fayette | West Virginia | 54019 | 6791 | 137 |
1969212 | 1969212 | 2021-11-30 | Fayette | West Virginia | 54019 | 6782 | 137 |
1965962 | 1965962 | 2021-11-29 | Fayette | West Virginia | 54019 | 6771 | 136 |
1962710 | 1962710 | 2021-11-28 | Fayette | West Virginia | 54019 | 6676 | 135 |
1959459 | 1959459 | 2021-11-27 | Fayette | West Virginia | 54019 | 6676 | 135 |
1956208 | 1956208 | 2021-11-26 | Fayette | West Virginia | 54019 | 6676 | 135 |
1952957 | 1952957 | 2021-11-25 | Fayette | West Virginia | 54019 | 6676 | 135 |
1949706 | 1949706 | 2021-11-24 | Fayette | West Virginia | 54019 | 6676 | 135 |
1946455 | 1946455 | 2021-11-23 | Fayette | West Virginia | 54019 | 6657 | 135 |
1943204 | 1943204 | 2021-11-22 | Fayette | West Virginia | 54019 | 6658 | 134 |
1939954 | 1939954 | 2021-11-21 | Fayette | West Virginia | 54019 | 6643 | 134 |
1936704 | 1936704 | 2021-11-20 | Fayette | West Virginia | 54019 | 6615 | 134 |
1933454 | 1933454 | 2021-11-19 | Fayette | West Virginia | 54019 | 6585 | 134 |
1930202 | 1930202 | 2021-11-18 | Fayette | West Virginia | 54019 | 6557 | 133 |
1926952 | 1926952 | 2021-11-17 | Fayette | West Virginia | 54019 | 6521 | 133 |
1923702 | 1923702 | 2021-11-16 | Fayette | West Virginia | 54019 | 6511 | 133 |
1920453 | 1920453 | 2021-11-15 | Fayette | West Virginia | 54019 | 6487 | 131 |
1917203 | 1917203 | 2021-11-14 | Fayette | West Virginia | 54019 | 6457 | 131 |
1913953 | 1913953 | 2021-11-13 | Fayette | West Virginia | 54019 | 6447 | 131 |
1910703 | 1910703 | 2021-11-12 | Fayette | West Virginia | 54019 | 6422 | 131 |
1907454 | 1907454 | 2021-11-11 | Fayette | West Virginia | 54019 | 6411 | 131 |
1904205 | 1904205 | 2021-11-10 | Fayette | West Virginia | 54019 | 6386 | 131 |
1900955 | 1900955 | 2021-11-09 | Fayette | West Virginia | 54019 | 6368 | 131 |
1897705 | 1897705 | 2021-11-08 | Fayette | West Virginia | 54019 | 6359 | 130 |
1894455 | 1894455 | 2021-11-07 | Fayette | West Virginia | 54019 | 6348 | 130 |
1891205 | 1891205 | 2021-11-06 | Fayette | West Virginia | 54019 | 6327 | 130 |
1887955 | 1887955 | 2021-11-05 | Fayette | West Virginia | 54019 | 6313 | 130 |
1884705 | 1884705 | 2021-11-04 | Fayette | West Virginia | 54019 | 6289 | 130 |
1881456 | 1881456 | 2021-11-03 | Fayette | West Virginia | 54019 | 6273 | 128 |
1878207 | 1878207 | 2021-11-02 | Fayette | West Virginia | 54019 | 6246 | 128 |
1874958 | 1874958 | 2021-11-01 | Fayette | West Virginia | 54019 | 6228 | 126 |
1871709 | 1871709 | 2021-10-31 | Fayette | West Virginia | 54019 | 6207 | 124 |
1868460 | 1868460 | 2021-10-30 | Fayette | West Virginia | 54019 | 6193 | 124 |
1865211 | 1865211 | 2021-10-29 | Fayette | West Virginia | 54019 | 6177 | 124 |
1861962 | 1861962 | 2021-10-28 | Fayette | West Virginia | 54019 | 6157 | 123 |
1858713 | 1858713 | 2021-10-27 | Fayette | West Virginia | 54019 | 6132 | 122 |
1855464 | 1855464 | 2021-10-26 | Fayette | West Virginia | 54019 | 6121 | 121 |
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);