ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Fayette" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176897 | 2176897 | 2022-02-02 | Fayette | Texas | 48149 | 4529 | 98 |
2173643 | 2173643 | 2022-02-01 | Fayette | Texas | 48149 | 4517 | 98 |
2170391 | 2170391 | 2022-01-31 | Fayette | Texas | 48149 | 4500 | 98 |
2167137 | 2167137 | 2022-01-30 | Fayette | Texas | 48149 | 4485 | 98 |
2163882 | 2163882 | 2022-01-29 | Fayette | Texas | 48149 | 4469 | 98 |
2160627 | 2160627 | 2022-01-28 | Fayette | Texas | 48149 | 4454 | 97 |
2157371 | 2157371 | 2022-01-27 | Fayette | Texas | 48149 | 4422 | 96 |
2154118 | 2154118 | 2022-01-26 | Fayette | Texas | 48149 | 4409 | 96 |
2150866 | 2150866 | 2022-01-25 | Fayette | Texas | 48149 | 4400 | 95 |
2147614 | 2147614 | 2022-01-24 | Fayette | Texas | 48149 | 4381 | 95 |
2144360 | 2144360 | 2022-01-23 | Fayette | Texas | 48149 | 4370 | 95 |
2141105 | 2141105 | 2022-01-22 | Fayette | Texas | 48149 | 4352 | 94 |
2137849 | 2137849 | 2022-01-21 | Fayette | Texas | 48149 | 4318 | 94 |
2134595 | 2134595 | 2022-01-20 | Fayette | Texas | 48149 | 4268 | 94 |
2131343 | 2131343 | 2022-01-19 | Fayette | Texas | 48149 | 4226 | 95 |
2128089 | 2128089 | 2022-01-18 | Fayette | Texas | 48149 | 4215 | 95 |
2124837 | 2124837 | 2022-01-17 | Fayette | Texas | 48149 | 4202 | 95 |
2121585 | 2121585 | 2022-01-16 | Fayette | Texas | 48149 | 4176 | 95 |
2118333 | 2118333 | 2022-01-15 | Fayette | Texas | 48149 | 4156 | 95 |
2115082 | 2115082 | 2022-01-14 | Fayette | Texas | 48149 | 4137 | 95 |
2111830 | 2111830 | 2022-01-13 | Fayette | Texas | 48149 | 4034 | 95 |
2108578 | 2108578 | 2022-01-12 | Fayette | Texas | 48149 | 3999 | 95 |
2105327 | 2105327 | 2022-01-11 | Fayette | Texas | 48149 | 3981 | 95 |
2102076 | 2102076 | 2022-01-10 | Fayette | Texas | 48149 | 3966 | 95 |
2098825 | 2098825 | 2022-01-09 | Fayette | Texas | 48149 | 3940 | 95 |
2095573 | 2095573 | 2022-01-08 | Fayette | Texas | 48149 | 3928 | 95 |
2092321 | 2092321 | 2022-01-07 | Fayette | Texas | 48149 | 3899 | 95 |
2089069 | 2089069 | 2022-01-06 | Fayette | Texas | 48149 | 3881 | 95 |
2085818 | 2085818 | 2022-01-05 | Fayette | Texas | 48149 | 3870 | 95 |
2082566 | 2082566 | 2022-01-04 | Fayette | Texas | 48149 | 3835 | 95 |
2079314 | 2079314 | 2022-01-03 | Fayette | Texas | 48149 | 3826 | 95 |
2076063 | 2076063 | 2022-01-02 | Fayette | Texas | 48149 | 3746 | 95 |
2072812 | 2072812 | 2022-01-01 | Fayette | Texas | 48149 | 3746 | 95 |
2069561 | 2069561 | 2021-12-31 | Fayette | Texas | 48149 | 3746 | 95 |
2066310 | 2066310 | 2021-12-30 | Fayette | Texas | 48149 | 3746 | 95 |
2063060 | 2063060 | 2021-12-29 | Fayette | Texas | 48149 | 3741 | 95 |
2059810 | 2059810 | 2021-12-28 | Fayette | Texas | 48149 | 3730 | 95 |
2056561 | 2056561 | 2021-12-27 | Fayette | Texas | 48149 | 3717 | 95 |
2053312 | 2053312 | 2021-12-26 | Fayette | Texas | 48149 | 3699 | 95 |
2050062 | 2050062 | 2021-12-25 | Fayette | Texas | 48149 | 3699 | 95 |
2046812 | 2046812 | 2021-12-24 | Fayette | Texas | 48149 | 3699 | 95 |
2043562 | 2043562 | 2021-12-23 | Fayette | Texas | 48149 | 3699 | 95 |
2040313 | 2040313 | 2021-12-22 | Fayette | Texas | 48149 | 3689 | 95 |
2037063 | 2037063 | 2021-12-21 | Fayette | Texas | 48149 | 3686 | 95 |
2033813 | 2033813 | 2021-12-20 | Fayette | Texas | 48149 | 3682 | 95 |
2030563 | 2030563 | 2021-12-19 | Fayette | Texas | 48149 | 3679 | 94 |
2027312 | 2027312 | 2021-12-18 | Fayette | Texas | 48149 | 3677 | 94 |
2024061 | 2024061 | 2021-12-17 | Fayette | Texas | 48149 | 3676 | 94 |
2020810 | 2020810 | 2021-12-16 | Fayette | Texas | 48149 | 3675 | 94 |
2017559 | 2017559 | 2021-12-15 | Fayette | Texas | 48149 | 3671 | 94 |
2014309 | 2014309 | 2021-12-14 | Fayette | Texas | 48149 | 3666 | 93 |
2011058 | 2011058 | 2021-12-13 | Fayette | Texas | 48149 | 3666 | 93 |
2007807 | 2007807 | 2021-12-12 | Fayette | Texas | 48149 | 3665 | 93 |
2004556 | 2004556 | 2021-12-11 | Fayette | Texas | 48149 | 3665 | 93 |
2001305 | 2001305 | 2021-12-10 | Fayette | Texas | 48149 | 3657 | 93 |
1998055 | 1998055 | 2021-12-09 | Fayette | Texas | 48149 | 3655 | 93 |
1994804 | 1994804 | 2021-12-08 | Fayette | Texas | 48149 | 3651 | 93 |
1991553 | 1991553 | 2021-12-07 | Fayette | Texas | 48149 | 3650 | 93 |
1988302 | 1988302 | 2021-12-06 | Fayette | Texas | 48149 | 3649 | 93 |
1985052 | 1985052 | 2021-12-05 | Fayette | Texas | 48149 | 3648 | 93 |
1981802 | 1981802 | 2021-12-04 | Fayette | Texas | 48149 | 3648 | 93 |
1978552 | 1978552 | 2021-12-03 | Fayette | Texas | 48149 | 3646 | 93 |
1975302 | 1975302 | 2021-12-02 | Fayette | Texas | 48149 | 3643 | 93 |
1972053 | 1972053 | 2021-12-01 | Fayette | Texas | 48149 | 3641 | 93 |
1968803 | 1968803 | 2021-11-30 | Fayette | Texas | 48149 | 3639 | 93 |
1965552 | 1965552 | 2021-11-29 | Fayette | Texas | 48149 | 3639 | 93 |
1962300 | 1962300 | 2021-11-28 | Fayette | Texas | 48149 | 3633 | 93 |
1959049 | 1959049 | 2021-11-27 | Fayette | Texas | 48149 | 3633 | 93 |
1955798 | 1955798 | 2021-11-26 | Fayette | Texas | 48149 | 3633 | 93 |
1952547 | 1952547 | 2021-11-25 | Fayette | Texas | 48149 | 3633 | 93 |
1949296 | 1949296 | 2021-11-24 | Fayette | Texas | 48149 | 3633 | 93 |
1946045 | 1946045 | 2021-11-23 | Fayette | Texas | 48149 | 3631 | 93 |
1942794 | 1942794 | 2021-11-22 | Fayette | Texas | 48149 | 3631 | 93 |
1939544 | 1939544 | 2021-11-21 | Fayette | Texas | 48149 | 3629 | 93 |
1936294 | 1936294 | 2021-11-20 | Fayette | Texas | 48149 | 3629 | 93 |
1933044 | 1933044 | 2021-11-19 | Fayette | Texas | 48149 | 3626 | 93 |
1929793 | 1929793 | 2021-11-18 | Fayette | Texas | 48149 | 3626 | 93 |
1926543 | 1926543 | 2021-11-17 | Fayette | Texas | 48149 | 3624 | 93 |
1923293 | 1923293 | 2021-11-16 | Fayette | Texas | 48149 | 3623 | 93 |
1920044 | 1920044 | 2021-11-15 | Fayette | Texas | 48149 | 3616 | 93 |
1916794 | 1916794 | 2021-11-14 | Fayette | Texas | 48149 | 3616 | 93 |
1913544 | 1913544 | 2021-11-13 | Fayette | Texas | 48149 | 3615 | 93 |
1910294 | 1910294 | 2021-11-12 | Fayette | Texas | 48149 | 3615 | 93 |
1907045 | 1907045 | 2021-11-11 | Fayette | Texas | 48149 | 3614 | 93 |
1903796 | 1903796 | 2021-11-10 | Fayette | Texas | 48149 | 3610 | 93 |
1900546 | 1900546 | 2021-11-09 | Fayette | Texas | 48149 | 3610 | 93 |
1897296 | 1897296 | 2021-11-08 | Fayette | Texas | 48149 | 3608 | 93 |
1894046 | 1894046 | 2021-11-07 | Fayette | Texas | 48149 | 3605 | 93 |
1890796 | 1890796 | 2021-11-06 | Fayette | Texas | 48149 | 3605 | 93 |
1887546 | 1887546 | 2021-11-05 | Fayette | Texas | 48149 | 3599 | 93 |
1884296 | 1884296 | 2021-11-04 | Fayette | Texas | 48149 | 3599 | 93 |
1881047 | 1881047 | 2021-11-03 | Fayette | Texas | 48149 | 3599 | 93 |
1877798 | 1877798 | 2021-11-02 | Fayette | Texas | 48149 | 3599 | 93 |
1874549 | 1874549 | 2021-11-01 | Fayette | Texas | 48149 | 3599 | 93 |
1871300 | 1871300 | 2021-10-31 | Fayette | Texas | 48149 | 3597 | 93 |
1868051 | 1868051 | 2021-10-30 | Fayette | Texas | 48149 | 3597 | 93 |
1864802 | 1864802 | 2021-10-29 | Fayette | Texas | 48149 | 3594 | 93 |
1861553 | 1861553 | 2021-10-28 | Fayette | Texas | 48149 | 3593 | 93 |
1858304 | 1858304 | 2021-10-27 | Fayette | Texas | 48149 | 3593 | 92 |
1855055 | 1855055 | 2021-10-26 | Fayette | Texas | 48149 | 3591 | 92 |
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);