ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
744 rows where fips = 48173 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176909 | 2176909 | 2022-02-02 | Glasscock | Texas | 48173 | 191 | 3 |
2173655 | 2173655 | 2022-02-01 | Glasscock | Texas | 48173 | 189 | 3 |
2170403 | 2170403 | 2022-01-31 | Glasscock | Texas | 48173 | 189 | 3 |
2167149 | 2167149 | 2022-01-30 | Glasscock | Texas | 48173 | 189 | 3 |
2163894 | 2163894 | 2022-01-29 | Glasscock | Texas | 48173 | 188 | 3 |
2160639 | 2160639 | 2022-01-28 | Glasscock | Texas | 48173 | 187 | 3 |
2157383 | 2157383 | 2022-01-27 | Glasscock | Texas | 48173 | 187 | 3 |
2154130 | 2154130 | 2022-01-26 | Glasscock | Texas | 48173 | 187 | 3 |
2150878 | 2150878 | 2022-01-25 | Glasscock | Texas | 48173 | 187 | 3 |
2147626 | 2147626 | 2022-01-24 | Glasscock | Texas | 48173 | 187 | 3 |
2144372 | 2144372 | 2022-01-23 | Glasscock | Texas | 48173 | 187 | 3 |
2141117 | 2141117 | 2022-01-22 | Glasscock | Texas | 48173 | 187 | 3 |
2137861 | 2137861 | 2022-01-21 | Glasscock | Texas | 48173 | 186 | 3 |
2134607 | 2134607 | 2022-01-20 | Glasscock | Texas | 48173 | 184 | 3 |
2131355 | 2131355 | 2022-01-19 | Glasscock | Texas | 48173 | 184 | 3 |
2128101 | 2128101 | 2022-01-18 | Glasscock | Texas | 48173 | 184 | 3 |
2124849 | 2124849 | 2022-01-17 | Glasscock | Texas | 48173 | 181 | 3 |
2121597 | 2121597 | 2022-01-16 | Glasscock | Texas | 48173 | 180 | 3 |
2118345 | 2118345 | 2022-01-15 | Glasscock | Texas | 48173 | 180 | 3 |
2115094 | 2115094 | 2022-01-14 | Glasscock | Texas | 48173 | 176 | 3 |
2111842 | 2111842 | 2022-01-13 | Glasscock | Texas | 48173 | 180 | 3 |
2108590 | 2108590 | 2022-01-12 | Glasscock | Texas | 48173 | 178 | 3 |
2105339 | 2105339 | 2022-01-11 | Glasscock | Texas | 48173 | 175 | 3 |
2102088 | 2102088 | 2022-01-10 | Glasscock | Texas | 48173 | 174 | 3 |
2098837 | 2098837 | 2022-01-09 | Glasscock | Texas | 48173 | 174 | 3 |
2095585 | 2095585 | 2022-01-08 | Glasscock | Texas | 48173 | 173 | 3 |
2092333 | 2092333 | 2022-01-07 | Glasscock | Texas | 48173 | 172 | 3 |
2089081 | 2089081 | 2022-01-06 | Glasscock | Texas | 48173 | 172 | 3 |
2085830 | 2085830 | 2022-01-05 | Glasscock | Texas | 48173 | 169 | 3 |
2082578 | 2082578 | 2022-01-04 | Glasscock | Texas | 48173 | 167 | 3 |
2079326 | 2079326 | 2022-01-03 | Glasscock | Texas | 48173 | 165 | 3 |
2076075 | 2076075 | 2022-01-02 | Glasscock | Texas | 48173 | 163 | 3 |
2072824 | 2072824 | 2022-01-01 | Glasscock | Texas | 48173 | 163 | 3 |
2069573 | 2069573 | 2021-12-31 | Glasscock | Texas | 48173 | 163 | 3 |
2066322 | 2066322 | 2021-12-30 | Glasscock | Texas | 48173 | 163 | 3 |
2063072 | 2063072 | 2021-12-29 | Glasscock | Texas | 48173 | 163 | 3 |
2059822 | 2059822 | 2021-12-28 | Glasscock | Texas | 48173 | 163 | 3 |
2056573 | 2056573 | 2021-12-27 | Glasscock | Texas | 48173 | 161 | 3 |
2053324 | 2053324 | 2021-12-26 | Glasscock | Texas | 48173 | 160 | 3 |
2050074 | 2050074 | 2021-12-25 | Glasscock | Texas | 48173 | 160 | 3 |
2046824 | 2046824 | 2021-12-24 | Glasscock | Texas | 48173 | 160 | 3 |
2043574 | 2043574 | 2021-12-23 | Glasscock | Texas | 48173 | 160 | 3 |
2040325 | 2040325 | 2021-12-22 | Glasscock | Texas | 48173 | 160 | 3 |
2037075 | 2037075 | 2021-12-21 | Glasscock | Texas | 48173 | 160 | 3 |
2033825 | 2033825 | 2021-12-20 | Glasscock | Texas | 48173 | 159 | 3 |
2030575 | 2030575 | 2021-12-19 | Glasscock | Texas | 48173 | 159 | 3 |
2027324 | 2027324 | 2021-12-18 | Glasscock | Texas | 48173 | 159 | 3 |
2024073 | 2024073 | 2021-12-17 | Glasscock | Texas | 48173 | 159 | 3 |
2020822 | 2020822 | 2021-12-16 | Glasscock | Texas | 48173 | 159 | 3 |
2017571 | 2017571 | 2021-12-15 | Glasscock | Texas | 48173 | 159 | 3 |
2014321 | 2014321 | 2021-12-14 | Glasscock | Texas | 48173 | 159 | 3 |
2011070 | 2011070 | 2021-12-13 | Glasscock | Texas | 48173 | 159 | 3 |
2007819 | 2007819 | 2021-12-12 | Glasscock | Texas | 48173 | 158 | 3 |
2004568 | 2004568 | 2021-12-11 | Glasscock | Texas | 48173 | 158 | 3 |
2001317 | 2001317 | 2021-12-10 | Glasscock | Texas | 48173 | 158 | 3 |
1998067 | 1998067 | 2021-12-09 | Glasscock | Texas | 48173 | 158 | 3 |
1994816 | 1994816 | 2021-12-08 | Glasscock | Texas | 48173 | 158 | 3 |
1991565 | 1991565 | 2021-12-07 | Glasscock | Texas | 48173 | 158 | 3 |
1988314 | 1988314 | 2021-12-06 | Glasscock | Texas | 48173 | 157 | 3 |
1985064 | 1985064 | 2021-12-05 | Glasscock | Texas | 48173 | 157 | 3 |
1981814 | 1981814 | 2021-12-04 | Glasscock | Texas | 48173 | 157 | 3 |
1978564 | 1978564 | 2021-12-03 | Glasscock | Texas | 48173 | 157 | 3 |
1975314 | 1975314 | 2021-12-02 | Glasscock | Texas | 48173 | 157 | 3 |
1972065 | 1972065 | 2021-12-01 | Glasscock | Texas | 48173 | 157 | 3 |
1968815 | 1968815 | 2021-11-30 | Glasscock | Texas | 48173 | 156 | 3 |
1965564 | 1965564 | 2021-11-29 | Glasscock | Texas | 48173 | 156 | 3 |
1962312 | 1962312 | 2021-11-28 | Glasscock | Texas | 48173 | 156 | 3 |
1959061 | 1959061 | 2021-11-27 | Glasscock | Texas | 48173 | 156 | 3 |
1955810 | 1955810 | 2021-11-26 | Glasscock | Texas | 48173 | 156 | 3 |
1952559 | 1952559 | 2021-11-25 | Glasscock | Texas | 48173 | 156 | 3 |
1949308 | 1949308 | 2021-11-24 | Glasscock | Texas | 48173 | 156 | 3 |
1946057 | 1946057 | 2021-11-23 | Glasscock | Texas | 48173 | 156 | 3 |
1942806 | 1942806 | 2021-11-22 | Glasscock | Texas | 48173 | 156 | 3 |
1939556 | 1939556 | 2021-11-21 | Glasscock | Texas | 48173 | 156 | 3 |
1936306 | 1936306 | 2021-11-20 | Glasscock | Texas | 48173 | 156 | 3 |
1933056 | 1933056 | 2021-11-19 | Glasscock | Texas | 48173 | 156 | 3 |
1929805 | 1929805 | 2021-11-18 | Glasscock | Texas | 48173 | 155 | 3 |
1926555 | 1926555 | 2021-11-17 | Glasscock | Texas | 48173 | 155 | 3 |
1923305 | 1923305 | 2021-11-16 | Glasscock | Texas | 48173 | 155 | 3 |
1920056 | 1920056 | 2021-11-15 | Glasscock | Texas | 48173 | 155 | 3 |
1916806 | 1916806 | 2021-11-14 | Glasscock | Texas | 48173 | 155 | 3 |
1913556 | 1913556 | 2021-11-13 | Glasscock | Texas | 48173 | 155 | 3 |
1910306 | 1910306 | 2021-11-12 | Glasscock | Texas | 48173 | 155 | 3 |
1907057 | 1907057 | 2021-11-11 | Glasscock | Texas | 48173 | 155 | 3 |
1903808 | 1903808 | 2021-11-10 | Glasscock | Texas | 48173 | 155 | 3 |
1900558 | 1900558 | 2021-11-09 | Glasscock | Texas | 48173 | 155 | 3 |
1897308 | 1897308 | 2021-11-08 | Glasscock | Texas | 48173 | 155 | 3 |
1894058 | 1894058 | 2021-11-07 | Glasscock | Texas | 48173 | 155 | 3 |
1890808 | 1890808 | 2021-11-06 | Glasscock | Texas | 48173 | 155 | 3 |
1887558 | 1887558 | 2021-11-05 | Glasscock | Texas | 48173 | 155 | 3 |
1884308 | 1884308 | 2021-11-04 | Glasscock | Texas | 48173 | 155 | 3 |
1881059 | 1881059 | 2021-11-03 | Glasscock | Texas | 48173 | 155 | 3 |
1877810 | 1877810 | 2021-11-02 | Glasscock | Texas | 48173 | 155 | 3 |
1874561 | 1874561 | 2021-11-01 | Glasscock | Texas | 48173 | 155 | 3 |
1871312 | 1871312 | 2021-10-31 | Glasscock | Texas | 48173 | 155 | 3 |
1868063 | 1868063 | 2021-10-30 | Glasscock | Texas | 48173 | 155 | 3 |
1864814 | 1864814 | 2021-10-29 | Glasscock | Texas | 48173 | 155 | 3 |
1861565 | 1861565 | 2021-10-28 | Glasscock | Texas | 48173 | 155 | 3 |
1858316 | 1858316 | 2021-10-27 | Glasscock | Texas | 48173 | 154 | 3 |
1855067 | 1855067 | 2021-10-26 | Glasscock | Texas | 48173 | 154 | 3 |
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);