ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Monongalia" 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 |
---|---|---|---|---|---|---|---|
2177327 | 2177327 | 2022-02-02 | Monongalia | West Virginia | 54061 | 22696 | 171 |
2174074 | 2174074 | 2022-02-01 | Monongalia | West Virginia | 54061 | 22520 | 171 |
2170822 | 2170822 | 2022-01-31 | Monongalia | West Virginia | 54061 | 22448 | 171 |
2167569 | 2167569 | 2022-01-30 | Monongalia | West Virginia | 54061 | 22392 | 169 |
2164314 | 2164314 | 2022-01-29 | Monongalia | West Virginia | 54061 | 22251 | 169 |
2161059 | 2161059 | 2022-01-28 | Monongalia | West Virginia | 54061 | 22061 | 169 |
2157803 | 2157803 | 2022-01-27 | Monongalia | West Virginia | 54061 | 21878 | 168 |
2154550 | 2154550 | 2022-01-26 | Monongalia | West Virginia | 54061 | 21695 | 168 |
2151297 | 2151297 | 2022-01-25 | Monongalia | West Virginia | 54061 | 21417 | 168 |
2148045 | 2148045 | 2022-01-24 | Monongalia | West Virginia | 54061 | 21259 | 168 |
2144793 | 2144793 | 2022-01-23 | Monongalia | West Virginia | 54061 | 21126 | 167 |
2141538 | 2141538 | 2022-01-22 | Monongalia | West Virginia | 54061 | 20832 | 167 |
2138282 | 2138282 | 2022-01-21 | Monongalia | West Virginia | 54061 | 20481 | 167 |
2135027 | 2135027 | 2022-01-20 | Monongalia | West Virginia | 54061 | 20193 | 166 |
2131775 | 2131775 | 2022-01-19 | Monongalia | West Virginia | 54061 | 19911 | 166 |
2128521 | 2128521 | 2022-01-18 | Monongalia | West Virginia | 54061 | 19770 | 166 |
2125268 | 2125268 | 2022-01-17 | Monongalia | West Virginia | 54061 | 19690 | 164 |
2122016 | 2122016 | 2022-01-16 | Monongalia | West Virginia | 54061 | 19542 | 163 |
2118764 | 2118764 | 2022-01-15 | Monongalia | West Virginia | 54061 | 19233 | 163 |
2115512 | 2115512 | 2022-01-14 | Monongalia | West Virginia | 54061 | 18953 | 163 |
2112260 | 2112260 | 2022-01-13 | Monongalia | West Virginia | 54061 | 18667 | 162 |
2109008 | 2109008 | 2022-01-12 | Monongalia | West Virginia | 54061 | 18351 | 160 |
2105757 | 2105757 | 2022-01-11 | Monongalia | West Virginia | 54061 | 17994 | 160 |
2102506 | 2102506 | 2022-01-10 | Monongalia | West Virginia | 54061 | 17897 | 160 |
2099255 | 2099255 | 2022-01-09 | Monongalia | West Virginia | 54061 | 17778 | 160 |
2096004 | 2096004 | 2022-01-08 | Monongalia | West Virginia | 54061 | 17619 | 160 |
2092752 | 2092752 | 2022-01-07 | Monongalia | West Virginia | 54061 | 17266 | 160 |
2089500 | 2089500 | 2022-01-06 | Monongalia | West Virginia | 54061 | 17019 | 159 |
2086249 | 2086249 | 2022-01-05 | Monongalia | West Virginia | 54061 | 16649 | 159 |
2082997 | 2082997 | 2022-01-04 | Monongalia | West Virginia | 54061 | 16345 | 158 |
2079745 | 2079745 | 2022-01-03 | Monongalia | West Virginia | 54061 | 16266 | 158 |
2076493 | 2076493 | 2022-01-02 | Monongalia | West Virginia | 54061 | 15710 | 158 |
2073242 | 2073242 | 2022-01-01 | Monongalia | West Virginia | 54061 | 15710 | 158 |
2069991 | 2069991 | 2021-12-31 | Monongalia | West Virginia | 54061 | 15710 | 158 |
2066740 | 2066740 | 2021-12-30 | Monongalia | West Virginia | 54061 | 15710 | 158 |
2063490 | 2063490 | 2021-12-29 | Monongalia | West Virginia | 54061 | 15534 | 158 |
2060240 | 2060240 | 2021-12-28 | Monongalia | West Virginia | 54061 | 15414 | 156 |
2056991 | 2056991 | 2021-12-27 | Monongalia | West Virginia | 54061 | 15361 | 156 |
2053742 | 2053742 | 2021-12-26 | Monongalia | West Virginia | 54061 | 15194 | 156 |
2050492 | 2050492 | 2021-12-25 | Monongalia | West Virginia | 54061 | 15194 | 156 |
2047242 | 2047242 | 2021-12-24 | Monongalia | West Virginia | 54061 | 15194 | 156 |
2043992 | 2043992 | 2021-12-23 | Monongalia | West Virginia | 54061 | 15194 | 156 |
2040743 | 2040743 | 2021-12-22 | Monongalia | West Virginia | 54061 | 15120 | 156 |
2037493 | 2037493 | 2021-12-21 | Monongalia | West Virginia | 54061 | 15080 | 155 |
2034243 | 2034243 | 2021-12-20 | Monongalia | West Virginia | 54061 | 15070 | 154 |
2030993 | 2030993 | 2021-12-19 | Monongalia | West Virginia | 54061 | 15040 | 153 |
2027742 | 2027742 | 2021-12-18 | Monongalia | West Virginia | 54061 | 15010 | 153 |
2024491 | 2024491 | 2021-12-17 | Monongalia | West Virginia | 54061 | 14978 | 154 |
2021240 | 2021240 | 2021-12-16 | Monongalia | West Virginia | 54061 | 14943 | 153 |
2017989 | 2017989 | 2021-12-15 | Monongalia | West Virginia | 54061 | 14900 | 152 |
2014739 | 2014739 | 2021-12-14 | Monongalia | West Virginia | 54061 | 14853 | 150 |
2011488 | 2011488 | 2021-12-13 | Monongalia | West Virginia | 54061 | 14826 | 150 |
2008237 | 2008237 | 2021-12-12 | Monongalia | West Virginia | 54061 | 14784 | 150 |
2004986 | 2004986 | 2021-12-11 | Monongalia | West Virginia | 54061 | 14756 | 150 |
2001735 | 2001735 | 2021-12-10 | Monongalia | West Virginia | 54061 | 14716 | 150 |
1998485 | 1998485 | 2021-12-09 | Monongalia | West Virginia | 54061 | 14693 | 149 |
1995234 | 1995234 | 2021-12-08 | Monongalia | West Virginia | 54061 | 14644 | 149 |
1991983 | 1991983 | 2021-12-07 | Monongalia | West Virginia | 54061 | 14620 | 149 |
1988732 | 1988732 | 2021-12-06 | Monongalia | West Virginia | 54061 | 14593 | 149 |
1985482 | 1985482 | 2021-12-05 | Monongalia | West Virginia | 54061 | 14561 | 148 |
1982232 | 1982232 | 2021-12-04 | Monongalia | West Virginia | 54061 | 14515 | 148 |
1978982 | 1978982 | 2021-12-03 | Monongalia | West Virginia | 54061 | 14474 | 148 |
1975732 | 1975732 | 2021-12-02 | Monongalia | West Virginia | 54061 | 14439 | 148 |
1972483 | 1972483 | 2021-12-01 | Monongalia | West Virginia | 54061 | 14391 | 147 |
1969233 | 1969233 | 2021-11-30 | Monongalia | West Virginia | 54061 | 14345 | 147 |
1965983 | 1965983 | 2021-11-29 | Monongalia | West Virginia | 54061 | 14321 | 146 |
1962731 | 1962731 | 2021-11-28 | Monongalia | West Virginia | 54061 | 14213 | 147 |
1959480 | 1959480 | 2021-11-27 | Monongalia | West Virginia | 54061 | 14213 | 147 |
1956229 | 1956229 | 2021-11-26 | Monongalia | West Virginia | 54061 | 14213 | 147 |
1952978 | 1952978 | 2021-11-25 | Monongalia | West Virginia | 54061 | 14213 | 147 |
1949727 | 1949727 | 2021-11-24 | Monongalia | West Virginia | 54061 | 14213 | 147 |
1946476 | 1946476 | 2021-11-23 | Monongalia | West Virginia | 54061 | 14195 | 147 |
1943225 | 1943225 | 2021-11-22 | Monongalia | West Virginia | 54061 | 14166 | 147 |
1939975 | 1939975 | 2021-11-21 | Monongalia | West Virginia | 54061 | 14151 | 147 |
1936725 | 1936725 | 2021-11-20 | Monongalia | West Virginia | 54061 | 14124 | 147 |
1933475 | 1933475 | 2021-11-19 | Monongalia | West Virginia | 54061 | 14083 | 147 |
1930223 | 1930223 | 2021-11-18 | Monongalia | West Virginia | 54061 | 14059 | 147 |
1926973 | 1926973 | 2021-11-17 | Monongalia | West Virginia | 54061 | 14022 | 147 |
1923723 | 1923723 | 2021-11-16 | Monongalia | West Virginia | 54061 | 13976 | 146 |
1920474 | 1920474 | 2021-11-15 | Monongalia | West Virginia | 54061 | 13949 | 145 |
1917224 | 1917224 | 2021-11-14 | Monongalia | West Virginia | 54061 | 13931 | 145 |
1913974 | 1913974 | 2021-11-13 | Monongalia | West Virginia | 54061 | 13890 | 145 |
1910724 | 1910724 | 2021-11-12 | Monongalia | West Virginia | 54061 | 13858 | 145 |
1907475 | 1907475 | 2021-11-11 | Monongalia | West Virginia | 54061 | 13838 | 145 |
1904226 | 1904226 | 2021-11-10 | Monongalia | West Virginia | 54061 | 13796 | 144 |
1900976 | 1900976 | 2021-11-09 | Monongalia | West Virginia | 54061 | 13770 | 141 |
1897726 | 1897726 | 2021-11-08 | Monongalia | West Virginia | 54061 | 13752 | 141 |
1894476 | 1894476 | 2021-11-07 | Monongalia | West Virginia | 54061 | 13739 | 141 |
1891226 | 1891226 | 2021-11-06 | Monongalia | West Virginia | 54061 | 13704 | 141 |
1887976 | 1887976 | 2021-11-05 | Monongalia | West Virginia | 54061 | 13655 | 141 |
1884726 | 1884726 | 2021-11-04 | Monongalia | West Virginia | 54061 | 13619 | 141 |
1881477 | 1881477 | 2021-11-03 | Monongalia | West Virginia | 54061 | 13570 | 141 |
1878228 | 1878228 | 2021-11-02 | Monongalia | West Virginia | 54061 | 13539 | 140 |
1874979 | 1874979 | 2021-11-01 | Monongalia | West Virginia | 54061 | 13521 | 140 |
1871730 | 1871730 | 2021-10-31 | Monongalia | West Virginia | 54061 | 13500 | 139 |
1868481 | 1868481 | 2021-10-30 | Monongalia | West Virginia | 54061 | 13466 | 139 |
1865232 | 1865232 | 2021-10-29 | Monongalia | West Virginia | 54061 | 13427 | 139 |
1861983 | 1861983 | 2021-10-28 | Monongalia | West Virginia | 54061 | 13396 | 137 |
1858734 | 1858734 | 2021-10-27 | Monongalia | West Virginia | 54061 | 13344 | 136 |
1855485 | 1855485 | 2021-10-26 | Monongalia | West Virginia | 54061 | 13292 | 136 |
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);