ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 48401 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111956 | 2111956 | 2022-01-13 | Rusk | Texas | 48401 | 8963 | 191 |
2108704 | 2108704 | 2022-01-12 | Rusk | Texas | 48401 | 8907 | 191 |
2105453 | 2105453 | 2022-01-11 | Rusk | Texas | 48401 | 8852 | 191 |
2102202 | 2102202 | 2022-01-10 | Rusk | Texas | 48401 | 8808 | 191 |
2098951 | 2098951 | 2022-01-09 | Rusk | Texas | 48401 | 8766 | 191 |
2095699 | 2095699 | 2022-01-08 | Rusk | Texas | 48401 | 8726 | 191 |
2092447 | 2092447 | 2022-01-07 | Rusk | Texas | 48401 | 8679 | 191 |
2089195 | 2089195 | 2022-01-06 | Rusk | Texas | 48401 | 8632 | 191 |
2085944 | 2085944 | 2022-01-05 | Rusk | Texas | 48401 | 8583 | 191 |
2082692 | 2082692 | 2022-01-04 | Rusk | Texas | 48401 | 8552 | 191 |
2079440 | 2079440 | 2022-01-03 | Rusk | Texas | 48401 | 8517 | 191 |
2076189 | 2076189 | 2022-01-02 | Rusk | Texas | 48401 | 8428 | 191 |
2072938 | 2072938 | 2022-01-01 | Rusk | Texas | 48401 | 8428 | 191 |
2069687 | 2069687 | 2021-12-31 | Rusk | Texas | 48401 | 8428 | 191 |
2066436 | 2066436 | 2021-12-30 | Rusk | Texas | 48401 | 8428 | 191 |
2063186 | 2063186 | 2021-12-29 | Rusk | Texas | 48401 | 8405 | 191 |
2059936 | 2059936 | 2021-12-28 | Rusk | Texas | 48401 | 8400 | 191 |
2056687 | 2056687 | 2021-12-27 | Rusk | Texas | 48401 | 8382 | 191 |
2053438 | 2053438 | 2021-12-26 | Rusk | Texas | 48401 | 8358 | 190 |
2050188 | 2050188 | 2021-12-25 | Rusk | Texas | 48401 | 8358 | 190 |
2046938 | 2046938 | 2021-12-24 | Rusk | Texas | 48401 | 8358 | 190 |
2043688 | 2043688 | 2021-12-23 | Rusk | Texas | 48401 | 8358 | 190 |
2040439 | 2040439 | 2021-12-22 | Rusk | Texas | 48401 | 8346 | 190 |
2037189 | 2037189 | 2021-12-21 | Rusk | Texas | 48401 | 8340 | 190 |
2033939 | 2033939 | 2021-12-20 | Rusk | Texas | 48401 | 8335 | 190 |
2030689 | 2030689 | 2021-12-19 | Rusk | Texas | 48401 | 8332 | 190 |
2027438 | 2027438 | 2021-12-18 | Rusk | Texas | 48401 | 8328 | 190 |
2024187 | 2024187 | 2021-12-17 | Rusk | Texas | 48401 | 8321 | 190 |
2020936 | 2020936 | 2021-12-16 | Rusk | Texas | 48401 | 8309 | 189 |
2017685 | 2017685 | 2021-12-15 | Rusk | Texas | 48401 | 8299 | 189 |
2014435 | 2014435 | 2021-12-14 | Rusk | Texas | 48401 | 8280 | 189 |
2011184 | 2011184 | 2021-12-13 | Rusk | Texas | 48401 | 8263 | 189 |
2007933 | 2007933 | 2021-12-12 | Rusk | Texas | 48401 | 8261 | 189 |
2004682 | 2004682 | 2021-12-11 | Rusk | Texas | 48401 | 8261 | 189 |
2001431 | 2001431 | 2021-12-10 | Rusk | Texas | 48401 | 8251 | 189 |
1998181 | 1998181 | 2021-12-09 | Rusk | Texas | 48401 | 8236 | 189 |
1994930 | 1994930 | 2021-12-08 | Rusk | Texas | 48401 | 8230 | 189 |
1991679 | 1991679 | 2021-12-07 | Rusk | Texas | 48401 | 8213 | 189 |
1988428 | 1988428 | 2021-12-06 | Rusk | Texas | 48401 | 8203 | 189 |
1985178 | 1985178 | 2021-12-05 | Rusk | Texas | 48401 | 8201 | 189 |
1981928 | 1981928 | 2021-12-04 | Rusk | Texas | 48401 | 8201 | 189 |
1978678 | 1978678 | 2021-12-03 | Rusk | Texas | 48401 | 8194 | 189 |
1975428 | 1975428 | 2021-12-02 | Rusk | Texas | 48401 | 8189 | 189 |
1972179 | 1972179 | 2021-12-01 | Rusk | Texas | 48401 | 8181 | 189 |
1968929 | 1968929 | 2021-11-30 | Rusk | Texas | 48401 | 8177 | 189 |
1965678 | 1965678 | 2021-11-29 | Rusk | Texas | 48401 | 8169 | 188 |
1962426 | 1962426 | 2021-11-28 | Rusk | Texas | 48401 | 8163 | 188 |
1959175 | 1959175 | 2021-11-27 | Rusk | Texas | 48401 | 8163 | 188 |
1955924 | 1955924 | 2021-11-26 | Rusk | Texas | 48401 | 8163 | 188 |
1952673 | 1952673 | 2021-11-25 | Rusk | Texas | 48401 | 8163 | 188 |
1949422 | 1949422 | 2021-11-24 | Rusk | Texas | 48401 | 8163 | 188 |
1946171 | 1946171 | 2021-11-23 | Rusk | Texas | 48401 | 8167 | 188 |
1942920 | 1942920 | 2021-11-22 | Rusk | Texas | 48401 | 8160 | 188 |
1939670 | 1939670 | 2021-11-21 | Rusk | Texas | 48401 | 8160 | 188 |
1936420 | 1936420 | 2021-11-20 | Rusk | Texas | 48401 | 8160 | 187 |
1933170 | 1933170 | 2021-11-19 | Rusk | Texas | 48401 | 8158 | 187 |
1929919 | 1929919 | 2021-11-18 | Rusk | Texas | 48401 | 8158 | 186 |
1926669 | 1926669 | 2021-11-17 | Rusk | Texas | 48401 | 8162 | 185 |
1923419 | 1923419 | 2021-11-16 | Rusk | Texas | 48401 | 8160 | 185 |
1920170 | 1920170 | 2021-11-15 | Rusk | Texas | 48401 | 8160 | 184 |
1916920 | 1916920 | 2021-11-14 | Rusk | Texas | 48401 | 8160 | 184 |
1913670 | 1913670 | 2021-11-13 | Rusk | Texas | 48401 | 8160 | 184 |
1910420 | 1910420 | 2021-11-12 | Rusk | Texas | 48401 | 8167 | 183 |
1907171 | 1907171 | 2021-11-11 | Rusk | Texas | 48401 | 8163 | 180 |
1903922 | 1903922 | 2021-11-10 | Rusk | Texas | 48401 | 8160 | 179 |
1900672 | 1900672 | 2021-11-09 | Rusk | Texas | 48401 | 8160 | 179 |
1897422 | 1897422 | 2021-11-08 | Rusk | Texas | 48401 | 8171 | 179 |
1894172 | 1894172 | 2021-11-07 | Rusk | Texas | 48401 | 8171 | 179 |
1890922 | 1890922 | 2021-11-06 | Rusk | Texas | 48401 | 8171 | 179 |
1887672 | 1887672 | 2021-11-05 | Rusk | Texas | 48401 | 8165 | 179 |
1884422 | 1884422 | 2021-11-04 | Rusk | Texas | 48401 | 8169 | 179 |
1881173 | 1881173 | 2021-11-03 | Rusk | Texas | 48401 | 8163 | 179 |
1877924 | 1877924 | 2021-11-02 | Rusk | Texas | 48401 | 8166 | 179 |
1874675 | 1874675 | 2021-11-01 | Rusk | Texas | 48401 | 8155 | 179 |
1871426 | 1871426 | 2021-10-31 | Rusk | Texas | 48401 | 8155 | 179 |
1868177 | 1868177 | 2021-10-30 | Rusk | Texas | 48401 | 8155 | 178 |
1864928 | 1864928 | 2021-10-29 | Rusk | Texas | 48401 | 8141 | 178 |
1861679 | 1861679 | 2021-10-28 | Rusk | Texas | 48401 | 8129 | 178 |
1858430 | 1858430 | 2021-10-27 | Rusk | Texas | 48401 | 8136 | 178 |
1855181 | 1855181 | 2021-10-26 | Rusk | Texas | 48401 | 8147 | 176 |
1851932 | 1851932 | 2021-10-25 | Rusk | Texas | 48401 | 8136 | 175 |
1848682 | 1848682 | 2021-10-24 | Rusk | Texas | 48401 | 8136 | 175 |
1845432 | 1845432 | 2021-10-23 | Rusk | Texas | 48401 | 8128 | 174 |
1842182 | 1842182 | 2021-10-22 | Rusk | Texas | 48401 | 8128 | 172 |
1838933 | 1838933 | 2021-10-21 | Rusk | Texas | 48401 | 8114 | 172 |
1835684 | 1835684 | 2021-10-20 | Rusk | Texas | 48401 | 8110 | 171 |
1832435 | 1832435 | 2021-10-19 | Rusk | Texas | 48401 | 8093 | 170 |
1829186 | 1829186 | 2021-10-18 | Rusk | Texas | 48401 | 8078 | 168 |
1825937 | 1825937 | 2021-10-17 | Rusk | Texas | 48401 | 8078 | 168 |
1822688 | 1822688 | 2021-10-16 | Rusk | Texas | 48401 | 8078 | 168 |
1819439 | 1819439 | 2021-10-15 | Rusk | Texas | 48401 | 8072 | 168 |
1816190 | 1816190 | 2021-10-14 | Rusk | Texas | 48401 | 8059 | 166 |
1812942 | 1812942 | 2021-10-13 | Rusk | Texas | 48401 | 8046 | 166 |
1809693 | 1809693 | 2021-10-12 | Rusk | Texas | 48401 | 8052 | 164 |
1806443 | 1806443 | 2021-10-11 | Rusk | Texas | 48401 | 8013 | 164 |
1803193 | 1803193 | 2021-10-10 | Rusk | Texas | 48401 | 8013 | 164 |
1799944 | 1799944 | 2021-10-09 | Rusk | Texas | 48401 | 8013 | 164 |
1796695 | 1796695 | 2021-10-08 | Rusk | Texas | 48401 | 7985 | 164 |
1793446 | 1793446 | 2021-10-07 | Rusk | Texas | 48401 | 7964 | 161 |
1790197 | 1790197 | 2021-10-06 | Rusk | Texas | 48401 | 7929 | 160 |
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);