ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48453 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- …
state 1
- Texas · 692 ✖
fips 1
- 48453 · 692 ✖
county 1
- Travis 692
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177049 | 2177049 | 2022-02-02 | Travis | Texas | 48453 | 211361 | 1578 |
2173795 | 2173795 | 2022-02-01 | Travis | Texas | 48453 | 210373 | 1569 |
2170543 | 2170543 | 2022-01-31 | Travis | Texas | 48453 | 209160 | 1563 |
2167289 | 2167289 | 2022-01-30 | Travis | Texas | 48453 | 207934 | 1562 |
2164034 | 2164034 | 2022-01-29 | Travis | Texas | 48453 | 207027 | 1558 |
2160779 | 2160779 | 2022-01-28 | Travis | Texas | 48453 | 205339 | 1554 |
2157523 | 2157523 | 2022-01-27 | Travis | Texas | 48453 | 204208 | 1551 |
2154270 | 2154270 | 2022-01-26 | Travis | Texas | 48453 | 202814 | 1547 |
2151018 | 2151018 | 2022-01-25 | Travis | Texas | 48453 | 201732 | 1544 |
2147766 | 2147766 | 2022-01-24 | Travis | Texas | 48453 | 200060 | 1541 |
2144512 | 2144512 | 2022-01-23 | Travis | Texas | 48453 | 198301 | 1541 |
2141257 | 2141257 | 2022-01-22 | Travis | Texas | 48453 | 195882 | 1539 |
2138001 | 2138001 | 2022-01-21 | Travis | Texas | 48453 | 193515 | 1534 |
2134747 | 2134747 | 2022-01-20 | Travis | Texas | 48453 | 190267 | 1528 |
2131495 | 2131495 | 2022-01-19 | Travis | Texas | 48453 | 188047 | 1526 |
2128241 | 2128241 | 2022-01-18 | Travis | Texas | 48453 | 185806 | 1524 |
2124989 | 2124989 | 2022-01-17 | Travis | Texas | 48453 | 183640 | 1523 |
2121737 | 2121737 | 2022-01-16 | Travis | Texas | 48453 | 180043 | 1523 |
2118485 | 2118485 | 2022-01-15 | Travis | Texas | 48453 | 178717 | 1521 |
2115234 | 2115234 | 2022-01-14 | Travis | Texas | 48453 | 176317 | 1517 |
2111982 | 2111982 | 2022-01-13 | Travis | Texas | 48453 | 167703 | 1511 |
2108730 | 2108730 | 2022-01-12 | Travis | Texas | 48453 | 164007 | 1509 |
2105479 | 2105479 | 2022-01-11 | Travis | Texas | 48453 | 161650 | 1509 |
2102228 | 2102228 | 2022-01-10 | Travis | Texas | 48453 | 159483 | 1509 |
2098977 | 2098977 | 2022-01-09 | Travis | Texas | 48453 | 157418 | 1509 |
2095725 | 2095725 | 2022-01-08 | Travis | Texas | 48453 | 155446 | 1509 |
2092473 | 2092473 | 2022-01-07 | Travis | Texas | 48453 | 153005 | 1508 |
2089221 | 2089221 | 2022-01-06 | Travis | Texas | 48453 | 150505 | 1508 |
2085970 | 2085970 | 2022-01-05 | Travis | Texas | 48453 | 148289 | 1507 |
2082718 | 2082718 | 2022-01-04 | Travis | Texas | 48453 | 145820 | 1503 |
2079466 | 2079466 | 2022-01-03 | Travis | Texas | 48453 | 143510 | 1502 |
2076215 | 2076215 | 2022-01-02 | Travis | Texas | 48453 | 133466 | 1500 |
2072964 | 2072964 | 2022-01-01 | Travis | Texas | 48453 | 133466 | 1500 |
2069713 | 2069713 | 2021-12-31 | Travis | Texas | 48453 | 133466 | 1500 |
2066462 | 2066462 | 2021-12-30 | Travis | Texas | 48453 | 133466 | 1500 |
2063212 | 2063212 | 2021-12-29 | Travis | Texas | 48453 | 132862 | 1500 |
2059962 | 2059962 | 2021-12-28 | Travis | Texas | 48453 | 132230 | 1500 |
2056713 | 2056713 | 2021-12-27 | Travis | Texas | 48453 | 131434 | 1500 |
2053464 | 2053464 | 2021-12-26 | Travis | Texas | 48453 | 127912 | 1498 |
2050214 | 2050214 | 2021-12-25 | Travis | Texas | 48453 | 127912 | 1498 |
2046964 | 2046964 | 2021-12-24 | Travis | Texas | 48453 | 127912 | 1498 |
2043714 | 2043714 | 2021-12-23 | Travis | Texas | 48453 | 127912 | 1498 |
2040465 | 2040465 | 2021-12-22 | Travis | Texas | 48453 | 127104 | 1498 |
2037215 | 2037215 | 2021-12-21 | Travis | Texas | 48453 | 126694 | 1495 |
2033965 | 2033965 | 2021-12-20 | Travis | Texas | 48453 | 126275 | 1493 |
2030715 | 2030715 | 2021-12-19 | Travis | Texas | 48453 | 125779 | 1492 |
2027464 | 2027464 | 2021-12-18 | Travis | Texas | 48453 | 125440 | 1492 |
2024213 | 2024213 | 2021-12-17 | Travis | Texas | 48453 | 125072 | 1491 |
2020962 | 2020962 | 2021-12-16 | Travis | Texas | 48453 | 124804 | 1490 |
2017711 | 2017711 | 2021-12-15 | Travis | Texas | 48453 | 124582 | 1489 |
2014461 | 2014461 | 2021-12-14 | Travis | Texas | 48453 | 124427 | 1488 |
2011210 | 2011210 | 2021-12-13 | Travis | Texas | 48453 | 124257 | 1486 |
2007959 | 2007959 | 2021-12-12 | Travis | Texas | 48453 | 124089 | 1486 |
2004708 | 2004708 | 2021-12-11 | Travis | Texas | 48453 | 123984 | 1485 |
2001457 | 2001457 | 2021-12-10 | Travis | Texas | 48453 | 123849 | 1485 |
1998207 | 1998207 | 2021-12-09 | Travis | Texas | 48453 | 122896 | 1484 |
1994956 | 1994956 | 2021-12-08 | Travis | Texas | 48453 | 122841 | 1481 |
1991705 | 1991705 | 2021-12-07 | Travis | Texas | 48453 | 122788 | 1476 |
1988454 | 1988454 | 2021-12-06 | Travis | Texas | 48453 | 122677 | 1476 |
1985204 | 1985204 | 2021-12-05 | Travis | Texas | 48453 | 122590 | 1475 |
1981954 | 1981954 | 2021-12-04 | Travis | Texas | 48453 | 122538 | 1475 |
1978704 | 1978704 | 2021-12-03 | Travis | Texas | 48453 | 122471 | 1474 |
1975454 | 1975454 | 2021-12-02 | Travis | Texas | 48453 | 122380 | 1470 |
1972205 | 1972205 | 2021-12-01 | Travis | Texas | 48453 | 122335 | 1470 |
1968955 | 1968955 | 2021-11-30 | Travis | Texas | 48453 | 122277 | 1467 |
1965704 | 1965704 | 2021-11-29 | Travis | Texas | 48453 | 122176 | 1465 |
1962452 | 1962452 | 2021-11-28 | Travis | Texas | 48453 | 122029 | 1465 |
1959201 | 1959201 | 2021-11-27 | Travis | Texas | 48453 | 122029 | 1465 |
1955950 | 1955950 | 2021-11-26 | Travis | Texas | 48453 | 122029 | 1465 |
1952699 | 1952699 | 2021-11-25 | Travis | Texas | 48453 | 122029 | 1465 |
1949448 | 1949448 | 2021-11-24 | Travis | Texas | 48453 | 122029 | 1465 |
1946197 | 1946197 | 2021-11-23 | Travis | Texas | 48453 | 121812 | 1464 |
1942946 | 1942946 | 2021-11-22 | Travis | Texas | 48453 | 121709 | 1464 |
1939696 | 1939696 | 2021-11-21 | Travis | Texas | 48453 | 121709 | 1463 |
1936446 | 1936446 | 2021-11-20 | Travis | Texas | 48453 | 121709 | 1463 |
1933196 | 1933196 | 2021-11-19 | Travis | Texas | 48453 | 121617 | 1463 |
1929945 | 1929945 | 2021-11-18 | Travis | Texas | 48453 | 121508 | 1462 |
1926695 | 1926695 | 2021-11-17 | Travis | Texas | 48453 | 121361 | 1462 |
1923445 | 1923445 | 2021-11-16 | Travis | Texas | 48453 | 121156 | 1461 |
1920196 | 1920196 | 2021-11-15 | Travis | Texas | 48453 | 120940 | 1461 |
1916946 | 1916946 | 2021-11-14 | Travis | Texas | 48453 | 120940 | 1460 |
1913696 | 1913696 | 2021-11-13 | Travis | Texas | 48453 | 120940 | 1458 |
1910446 | 1910446 | 2021-11-12 | Travis | Texas | 48453 | 120844 | 1456 |
1907197 | 1907197 | 2021-11-11 | Travis | Texas | 48453 | 120844 | 1452 |
1903948 | 1903948 | 2021-11-10 | Travis | Texas | 48453 | 120481 | 1447 |
1900698 | 1900698 | 2021-11-09 | Travis | Texas | 48453 | 120481 | 1447 |
1897448 | 1897448 | 2021-11-08 | Travis | Texas | 48453 | 120366 | 1446 |
1894198 | 1894198 | 2021-11-07 | Travis | Texas | 48453 | 120366 | 1445 |
1890948 | 1890948 | 2021-11-06 | Travis | Texas | 48453 | 120366 | 1445 |
1887698 | 1887698 | 2021-11-05 | Travis | Texas | 48453 | 120299 | 1442 |
1884448 | 1884448 | 2021-11-04 | Travis | Texas | 48453 | 120179 | 1439 |
1881199 | 1881199 | 2021-11-03 | Travis | Texas | 48453 | 120106 | 1438 |
1877950 | 1877950 | 2021-11-02 | Travis | Texas | 48453 | 119847 | 1436 |
1874701 | 1874701 | 2021-11-01 | Travis | Texas | 48453 | 119762 | 1434 |
1871452 | 1871452 | 2021-10-31 | Travis | Texas | 48453 | 119762 | 1433 |
1868203 | 1868203 | 2021-10-30 | Travis | Texas | 48453 | 119762 | 1431 |
1864954 | 1864954 | 2021-10-29 | Travis | Texas | 48453 | 119609 | 1431 |
1861705 | 1861705 | 2021-10-28 | Travis | Texas | 48453 | 119524 | 1429 |
1858456 | 1858456 | 2021-10-27 | Travis | Texas | 48453 | 119391 | 1426 |
1855207 | 1855207 | 2021-10-26 | Travis | Texas | 48453 | 119220 | 1419 |
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);