ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Travis" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502434 | 2502434 | 2022-05-13 | Travis | Texas | 48453 | 227227 | 1735 |
2499176 | 2499176 | 2022-05-12 | Travis | Texas | 48453 | 226936 | 1735 |
2495918 | 2495918 | 2022-05-11 | Travis | Texas | 48453 | 226674 | 1735 |
2492660 | 2492660 | 2022-05-10 | Travis | Texas | 48453 | 226442 | 1734 |
2489402 | 2489402 | 2022-05-09 | Travis | Texas | 48453 | 226225 | 1733 |
2486144 | 2486144 | 2022-05-08 | Travis | Texas | 48453 | 226016 | 1733 |
2482886 | 2482886 | 2022-05-07 | Travis | Texas | 48453 | 225777 | 1733 |
2479628 | 2479628 | 2022-05-06 | Travis | Texas | 48453 | 225546 | 1733 |
2476370 | 2476370 | 2022-05-05 | Travis | Texas | 48453 | 225351 | 1733 |
2473113 | 2473113 | 2022-05-04 | Travis | Texas | 48453 | 225171 | 1733 |
2469857 | 2469857 | 2022-05-03 | Travis | Texas | 48453 | 224996 | 1733 |
2466601 | 2466601 | 2022-05-02 | Travis | Texas | 48453 | 224875 | 1733 |
2463346 | 2463346 | 2022-05-01 | Travis | Texas | 48453 | 224757 | 1733 |
2460090 | 2460090 | 2022-04-30 | Travis | Texas | 48453 | 224605 | 1733 |
2456834 | 2456834 | 2022-04-29 | Travis | Texas | 48453 | 224445 | 1732 |
2453578 | 2453578 | 2022-04-28 | Travis | Texas | 48453 | 224310 | 1732 |
2450322 | 2450322 | 2022-04-27 | Travis | Texas | 48453 | 224164 | 1731 |
2447065 | 2447065 | 2022-04-26 | Travis | Texas | 48453 | 224069 | 1731 |
2443810 | 2443810 | 2022-04-25 | Travis | Texas | 48453 | 223958 | 1731 |
2440554 | 2440554 | 2022-04-24 | Travis | Texas | 48453 | 223865 | 1731 |
2437298 | 2437298 | 2022-04-23 | Travis | Texas | 48453 | 223736 | 1731 |
2434042 | 2434042 | 2022-04-22 | Travis | Texas | 48453 | 223580 | 1731 |
2430786 | 2430786 | 2022-04-21 | Travis | Texas | 48453 | 223459 | 1731 |
2427530 | 2427530 | 2022-04-20 | Travis | Texas | 48453 | 223329 | 1730 |
2424274 | 2424274 | 2022-04-19 | Travis | Texas | 48453 | 223264 | 1727 |
2421018 | 2421018 | 2022-04-18 | Travis | Texas | 48453 | 223150 | 1726 |
2417762 | 2417762 | 2022-04-17 | Travis | Texas | 48453 | 222701 | 1724 |
2414506 | 2414506 | 2022-04-16 | Travis | Texas | 48453 | 222701 | 1724 |
2411250 | 2411250 | 2022-04-15 | Travis | Texas | 48453 | 222701 | 1724 |
2407994 | 2407994 | 2022-04-14 | Travis | Texas | 48453 | 222701 | 1724 |
2404738 | 2404738 | 2022-04-13 | Travis | Texas | 48453 | 222594 | 1724 |
2401483 | 2401483 | 2022-04-12 | Travis | Texas | 48453 | 222524 | 1723 |
2398228 | 2398228 | 2022-04-11 | Travis | Texas | 48453 | 222458 | 1721 |
2394973 | 2394973 | 2022-04-10 | Travis | Texas | 48453 | 222391 | 1721 |
2391717 | 2391717 | 2022-04-09 | Travis | Texas | 48453 | 222298 | 1721 |
2388461 | 2388461 | 2022-04-08 | Travis | Texas | 48453 | 222155 | 1720 |
2385206 | 2385206 | 2022-04-07 | Travis | Texas | 48453 | 222062 | 1720 |
2381951 | 2381951 | 2022-04-06 | Travis | Texas | 48453 | 221959 | 1717 |
2378696 | 2378696 | 2022-04-05 | Travis | Texas | 48453 | 221879 | 1717 |
2375442 | 2375442 | 2022-04-04 | Travis | Texas | 48453 | 221774 | 1716 |
2372190 | 2372190 | 2022-04-03 | Travis | Texas | 48453 | 221687 | 1716 |
2368937 | 2368937 | 2022-04-02 | Travis | Texas | 48453 | 221572 | 1716 |
2365684 | 2365684 | 2022-04-01 | Travis | Texas | 48453 | 221438 | 1714 |
2362431 | 2362431 | 2022-03-31 | Travis | Texas | 48453 | 221294 | 1714 |
2359177 | 2359177 | 2022-03-30 | Travis | Texas | 48453 | 221157 | 1714 |
2355923 | 2355923 | 2022-03-29 | Travis | Texas | 48453 | 221030 | 1714 |
2352670 | 2352670 | 2022-03-28 | Travis | Texas | 48453 | 220819 | 1710 |
2349418 | 2349418 | 2022-03-27 | Travis | Texas | 48453 | 220748 | 1710 |
2346165 | 2346165 | 2022-03-26 | Travis | Texas | 48453 | 220683 | 1707 |
2342912 | 2342912 | 2022-03-25 | Travis | Texas | 48453 | 220555 | 1705 |
2339659 | 2339659 | 2022-03-24 | Travis | Texas | 48453 | 220412 | 1705 |
2336405 | 2336405 | 2022-03-23 | Travis | Texas | 48453 | 220296 | 1704 |
2333151 | 2333151 | 2022-03-22 | Travis | Texas | 48453 | 220114 | 1704 |
2329898 | 2329898 | 2022-03-21 | Travis | Texas | 48453 | 220097 | 1702 |
2326646 | 2326646 | 2022-03-20 | Travis | Texas | 48453 | 220039 | 1701 |
2323393 | 2323393 | 2022-03-19 | Travis | Texas | 48453 | 219905 | 1700 |
2320139 | 2320139 | 2022-03-18 | Travis | Texas | 48453 | 219905 | 1700 |
2316885 | 2316885 | 2022-03-17 | Travis | Texas | 48453 | 219864 | 1697 |
2313632 | 2313632 | 2022-03-16 | Travis | Texas | 48453 | 219815 | 1696 |
2310379 | 2310379 | 2022-03-15 | Travis | Texas | 48453 | 219778 | 1695 |
2307126 | 2307126 | 2022-03-14 | Travis | Texas | 48453 | 219688 | 1695 |
2303875 | 2303875 | 2022-03-13 | Travis | Texas | 48453 | 219648 | 1692 |
2300623 | 2300623 | 2022-03-12 | Travis | Texas | 48453 | 219593 | 1690 |
2297371 | 2297371 | 2022-03-11 | Travis | Texas | 48453 | 219539 | 1688 |
2294119 | 2294119 | 2022-03-10 | Travis | Texas | 48453 | 219497 | 1687 |
2290867 | 2290867 | 2022-03-09 | Travis | Texas | 48453 | 219430 | 1685 |
2287615 | 2287615 | 2022-03-08 | Travis | Texas | 48453 | 219368 | 1684 |
2284363 | 2284363 | 2022-03-07 | Travis | Texas | 48453 | 219309 | 1684 |
2281111 | 2281111 | 2022-03-06 | Travis | Texas | 48453 | 219239 | 1684 |
2277858 | 2277858 | 2022-03-05 | Travis | Texas | 48453 | 219214 | 1682 |
2274605 | 2274605 | 2022-03-04 | Travis | Texas | 48453 | 219148 | 1678 |
2271352 | 2271352 | 2022-03-03 | Travis | Texas | 48453 | 219076 | 1672 |
2268100 | 2268100 | 2022-03-02 | Travis | Texas | 48453 | 218994 | 1671 |
2264847 | 2264847 | 2022-03-01 | Travis | Texas | 48453 | 218929 | 1671 |
2261597 | 2261597 | 2022-02-28 | Travis | Texas | 48453 | 218804 | 1667 |
2258346 | 2258346 | 2022-02-27 | Travis | Texas | 48453 | 218702 | 1666 |
2255095 | 2255095 | 2022-02-26 | Travis | Texas | 48453 | 218648 | 1667 |
2251844 | 2251844 | 2022-02-25 | Travis | Texas | 48453 | 218547 | 1663 |
2248593 | 2248593 | 2022-02-24 | Travis | Texas | 48453 | 218456 | 1661 |
2245342 | 2245342 | 2022-02-23 | Travis | Texas | 48453 | 218279 | 1657 |
2242091 | 2242091 | 2022-02-22 | Travis | Texas | 48453 | 218183 | 1655 |
2238840 | 2238840 | 2022-02-21 | Travis | Texas | 48453 | 218043 | 1654 |
2235589 | 2235589 | 2022-02-20 | Travis | Texas | 48453 | 217921 | 1654 |
2232338 | 2232338 | 2022-02-19 | Travis | Texas | 48453 | 217842 | 1654 |
2229087 | 2229087 | 2022-02-18 | Travis | Texas | 48453 | 217645 | 1650 |
2225836 | 2225836 | 2022-02-17 | Travis | Texas | 48453 | 217494 | 1644 |
2222585 | 2222585 | 2022-02-16 | Travis | Texas | 48453 | 217314 | 1639 |
2219334 | 2219334 | 2022-02-15 | Travis | Texas | 48453 | 217131 | 1636 |
2216083 | 2216083 | 2022-02-14 | Travis | Texas | 48453 | 216882 | 1633 |
2212832 | 2212832 | 2022-02-13 | Travis | Texas | 48453 | 216611 | 1631 |
2209579 | 2209579 | 2022-02-12 | Travis | Texas | 48453 | 216360 | 1624 |
2206326 | 2206326 | 2022-02-11 | Travis | Texas | 48453 | 216064 | 1618 |
2203073 | 2203073 | 2022-02-10 | Travis | Texas | 48453 | 215601 | 1610 |
2199819 | 2199819 | 2022-02-09 | Travis | Texas | 48453 | 215204 | 1602 |
2196565 | 2196565 | 2022-02-08 | Travis | Texas | 48453 | 214800 | 1596 |
2193311 | 2193311 | 2022-02-07 | Travis | Texas | 48453 | 214425 | 1593 |
2190057 | 2190057 | 2022-02-06 | Travis | Texas | 48453 | 213948 | 1593 |
2186804 | 2186804 | 2022-02-05 | Travis | Texas | 48453 | 213368 | 1593 |
2183552 | 2183552 | 2022-02-04 | Travis | Texas | 48453 | 213023 | 1585 |
2180300 | 2180300 | 2022-02-03 | Travis | Texas | 48453 | 212212 | 1581 |
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);