ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 48209 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176927 | 2176927 | 2022-02-02 | Hays | Texas | 48209 | 54454 | 454 |
2173673 | 2173673 | 2022-02-01 | Hays | Texas | 48209 | 54102 | 452 |
2170421 | 2170421 | 2022-01-31 | Hays | Texas | 48209 | 53842 | 447 |
2167167 | 2167167 | 2022-01-30 | Hays | Texas | 48209 | 53576 | 446 |
2163912 | 2163912 | 2022-01-29 | Hays | Texas | 48209 | 53233 | 446 |
2160657 | 2160657 | 2022-01-28 | Hays | Texas | 48209 | 52817 | 446 |
2157401 | 2157401 | 2022-01-27 | Hays | Texas | 48209 | 52389 | 445 |
2154148 | 2154148 | 2022-01-26 | Hays | Texas | 48209 | 51873 | 442 |
2150896 | 2150896 | 2022-01-25 | Hays | Texas | 48209 | 51455 | 440 |
2147644 | 2147644 | 2022-01-24 | Hays | Texas | 48209 | 51102 | 437 |
2144390 | 2144390 | 2022-01-23 | Hays | Texas | 48209 | 50819 | 431 |
2141135 | 2141135 | 2022-01-22 | Hays | Texas | 48209 | 49957 | 431 |
2137879 | 2137879 | 2022-01-21 | Hays | Texas | 48209 | 49416 | 431 |
2134625 | 2134625 | 2022-01-20 | Hays | Texas | 48209 | 48440 | 430 |
2131373 | 2131373 | 2022-01-19 | Hays | Texas | 48209 | 48024 | 427 |
2128119 | 2128119 | 2022-01-18 | Hays | Texas | 48209 | 47252 | 427 |
2124867 | 2124867 | 2022-01-17 | Hays | Texas | 48209 | 46691 | 426 |
2121615 | 2121615 | 2022-01-16 | Hays | Texas | 48209 | 46040 | 426 |
2118363 | 2118363 | 2022-01-15 | Hays | Texas | 48209 | 45655 | 426 |
2115112 | 2115112 | 2022-01-14 | Hays | Texas | 48209 | 45096 | 426 |
2111860 | 2111860 | 2022-01-13 | Hays | Texas | 48209 | 44196 | 420 |
2108608 | 2108608 | 2022-01-12 | Hays | Texas | 48209 | 43542 | 420 |
2105357 | 2105357 | 2022-01-11 | Hays | Texas | 48209 | 43004 | 418 |
2102106 | 2102106 | 2022-01-10 | Hays | Texas | 48209 | 42564 | 418 |
2098855 | 2098855 | 2022-01-09 | Hays | Texas | 48209 | 41808 | 418 |
2095603 | 2095603 | 2022-01-08 | Hays | Texas | 48209 | 41399 | 418 |
2092351 | 2092351 | 2022-01-07 | Hays | Texas | 48209 | 41399 | 418 |
2089099 | 2089099 | 2022-01-06 | Hays | Texas | 48209 | 40659 | 418 |
2085848 | 2085848 | 2022-01-05 | Hays | Texas | 48209 | 39569 | 417 |
2082596 | 2082596 | 2022-01-04 | Hays | Texas | 48209 | 39257 | 416 |
2079344 | 2079344 | 2022-01-03 | Hays | Texas | 48209 | 38221 | 414 |
2076093 | 2076093 | 2022-01-02 | Hays | Texas | 48209 | 37439 | 414 |
2072842 | 2072842 | 2022-01-01 | Hays | Texas | 48209 | 37439 | 414 |
2069591 | 2069591 | 2021-12-31 | Hays | Texas | 48209 | 37439 | 414 |
2066340 | 2066340 | 2021-12-30 | Hays | Texas | 48209 | 36959 | 414 |
2063090 | 2063090 | 2021-12-29 | Hays | Texas | 48209 | 36656 | 413 |
2059840 | 2059840 | 2021-12-28 | Hays | Texas | 48209 | 35924 | 413 |
2056591 | 2056591 | 2021-12-27 | Hays | Texas | 48209 | 35610 | 411 |
2053342 | 2053342 | 2021-12-26 | Hays | Texas | 48209 | 34970 | 411 |
2050092 | 2050092 | 2021-12-25 | Hays | Texas | 48209 | 34970 | 411 |
2046842 | 2046842 | 2021-12-24 | Hays | Texas | 48209 | 34970 | 411 |
2043592 | 2043592 | 2021-12-23 | Hays | Texas | 48209 | 34970 | 411 |
2040343 | 2040343 | 2021-12-22 | Hays | Texas | 48209 | 34781 | 411 |
2037093 | 2037093 | 2021-12-21 | Hays | Texas | 48209 | 34687 | 411 |
2033843 | 2033843 | 2021-12-20 | Hays | Texas | 48209 | 34602 | 411 |
2030593 | 2030593 | 2021-12-19 | Hays | Texas | 48209 | 34526 | 411 |
2027342 | 2027342 | 2021-12-18 | Hays | Texas | 48209 | 34480 | 411 |
2024091 | 2024091 | 2021-12-17 | Hays | Texas | 48209 | 34420 | 411 |
2020840 | 2020840 | 2021-12-16 | Hays | Texas | 48209 | 34346 | 411 |
2017589 | 2017589 | 2021-12-15 | Hays | Texas | 48209 | 34302 | 411 |
2014339 | 2014339 | 2021-12-14 | Hays | Texas | 48209 | 34270 | 410 |
2011088 | 2011088 | 2021-12-13 | Hays | Texas | 48209 | 34253 | 410 |
2007837 | 2007837 | 2021-12-12 | Hays | Texas | 48209 | 34231 | 408 |
2004586 | 2004586 | 2021-12-11 | Hays | Texas | 48209 | 34206 | 408 |
2001335 | 2001335 | 2021-12-10 | Hays | Texas | 48209 | 34173 | 408 |
1998085 | 1998085 | 2021-12-09 | Hays | Texas | 48209 | 34131 | 408 |
1994834 | 1994834 | 2021-12-08 | Hays | Texas | 48209 | 34098 | 408 |
1991583 | 1991583 | 2021-12-07 | Hays | Texas | 48209 | 34028 | 408 |
1988332 | 1988332 | 2021-12-06 | Hays | Texas | 48209 | 34028 | 408 |
1985082 | 1985082 | 2021-12-05 | Hays | Texas | 48209 | 33981 | 407 |
1981832 | 1981832 | 2021-12-04 | Hays | Texas | 48209 | 33981 | 407 |
1978582 | 1978582 | 2021-12-03 | Hays | Texas | 48209 | 33981 | 407 |
1975332 | 1975332 | 2021-12-02 | Hays | Texas | 48209 | 33969 | 407 |
1972083 | 1972083 | 2021-12-01 | Hays | Texas | 48209 | 33888 | 407 |
1968833 | 1968833 | 2021-11-30 | Hays | Texas | 48209 | 33843 | 407 |
1965582 | 1965582 | 2021-11-29 | Hays | Texas | 48209 | 33812 | 406 |
1962330 | 1962330 | 2021-11-28 | Hays | Texas | 48209 | 33747 | 405 |
1959079 | 1959079 | 2021-11-27 | Hays | Texas | 48209 | 33747 | 405 |
1955828 | 1955828 | 2021-11-26 | Hays | Texas | 48209 | 33747 | 405 |
1952577 | 1952577 | 2021-11-25 | Hays | Texas | 48209 | 33747 | 405 |
1949326 | 1949326 | 2021-11-24 | Hays | Texas | 48209 | 33747 | 405 |
1946075 | 1946075 | 2021-11-23 | Hays | Texas | 48209 | 33747 | 405 |
1942824 | 1942824 | 2021-11-22 | Hays | Texas | 48209 | 33729 | 404 |
1939574 | 1939574 | 2021-11-21 | Hays | Texas | 48209 | 33559 | 403 |
1936324 | 1936324 | 2021-11-20 | Hays | Texas | 48209 | 33559 | 403 |
1933074 | 1933074 | 2021-11-19 | Hays | Texas | 48209 | 33559 | 403 |
1929823 | 1929823 | 2021-11-18 | Hays | Texas | 48209 | 33559 | 403 |
1926573 | 1926573 | 2021-11-17 | Hays | Texas | 48209 | 33559 | 403 |
1923323 | 1923323 | 2021-11-16 | Hays | Texas | 48209 | 33495 | 403 |
1920074 | 1920074 | 2021-11-15 | Hays | Texas | 48209 | 33472 | 403 |
1916824 | 1916824 | 2021-11-14 | Hays | Texas | 48209 | 33406 | 402 |
1913574 | 1913574 | 2021-11-13 | Hays | Texas | 48209 | 33406 | 402 |
1910324 | 1910324 | 2021-11-12 | Hays | Texas | 48209 | 33406 | 402 |
1907075 | 1907075 | 2021-11-11 | Hays | Texas | 48209 | 33342 | 401 |
1903826 | 1903826 | 2021-11-10 | Hays | Texas | 48209 | 33342 | 401 |
1900576 | 1900576 | 2021-11-09 | Hays | Texas | 48209 | 33260 | 401 |
1897326 | 1897326 | 2021-11-08 | Hays | Texas | 48209 | 33233 | 401 |
1894076 | 1894076 | 2021-11-07 | Hays | Texas | 48209 | 33147 | 400 |
1890826 | 1890826 | 2021-11-06 | Hays | Texas | 48209 | 33147 | 400 |
1887576 | 1887576 | 2021-11-05 | Hays | Texas | 48209 | 33147 | 400 |
1884326 | 1884326 | 2021-11-04 | Hays | Texas | 48209 | 33143 | 400 |
1881077 | 1881077 | 2021-11-03 | Hays | Texas | 48209 | 33109 | 400 |
1877828 | 1877828 | 2021-11-02 | Hays | Texas | 48209 | 33069 | 400 |
1874579 | 1874579 | 2021-11-01 | Hays | Texas | 48209 | 33033 | 399 |
1871330 | 1871330 | 2021-10-31 | Hays | Texas | 48209 | 32990 | 399 |
1868081 | 1868081 | 2021-10-30 | Hays | Texas | 48209 | 32990 | 399 |
1864832 | 1864832 | 2021-10-29 | Hays | Texas | 48209 | 32990 | 399 |
1861583 | 1861583 | 2021-10-28 | Hays | Texas | 48209 | 32939 | 398 |
1858334 | 1858334 | 2021-10-27 | Hays | Texas | 48209 | 32892 | 396 |
1855085 | 1855085 | 2021-10-26 | Hays | Texas | 48209 | 32847 | 396 |
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);