ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 48041 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176843 | 2176843 | 2022-02-02 | Brazos | Texas | 48041 | 57382 | 375 |
2173589 | 2173589 | 2022-02-01 | Brazos | Texas | 48041 | 57101 | 375 |
2170337 | 2170337 | 2022-01-31 | Brazos | Texas | 48041 | 56959 | 374 |
2167083 | 2167083 | 2022-01-30 | Brazos | Texas | 48041 | 56783 | 374 |
2163828 | 2163828 | 2022-01-29 | Brazos | Texas | 48041 | 56463 | 374 |
2160573 | 2160573 | 2022-01-28 | Brazos | Texas | 48041 | 56020 | 372 |
2157317 | 2157317 | 2022-01-27 | Brazos | Texas | 48041 | 55601 | 372 |
2154064 | 2154064 | 2022-01-26 | Brazos | Texas | 48041 | 55207 | 372 |
2150812 | 2150812 | 2022-01-25 | Brazos | Texas | 48041 | 54726 | 372 |
2147560 | 2147560 | 2022-01-24 | Brazos | Texas | 48041 | 54501 | 372 |
2144306 | 2144306 | 2022-01-23 | Brazos | Texas | 48041 | 54142 | 372 |
2141051 | 2141051 | 2022-01-22 | Brazos | Texas | 48041 | 53269 | 372 |
2137795 | 2137795 | 2022-01-21 | Brazos | Texas | 48041 | 52681 | 372 |
2134541 | 2134541 | 2022-01-20 | Brazos | Texas | 48041 | 52003 | 372 |
2131289 | 2131289 | 2022-01-19 | Brazos | Texas | 48041 | 51550 | 370 |
2128035 | 2128035 | 2022-01-18 | Brazos | Texas | 48041 | 51025 | 370 |
2124783 | 2124783 | 2022-01-17 | Brazos | Texas | 48041 | 50792 | 368 |
2121531 | 2121531 | 2022-01-16 | Brazos | Texas | 48041 | 50285 | 368 |
2118279 | 2118279 | 2022-01-15 | Brazos | Texas | 48041 | 49714 | 368 |
2115028 | 2115028 | 2022-01-14 | Brazos | Texas | 48041 | 48872 | 368 |
2111776 | 2111776 | 2022-01-13 | Brazos | Texas | 48041 | 48387 | 368 |
2108524 | 2108524 | 2022-01-12 | Brazos | Texas | 48041 | 47748 | 368 |
2105273 | 2105273 | 2022-01-11 | Brazos | Texas | 48041 | 47444 | 368 |
2102022 | 2102022 | 2022-01-10 | Brazos | Texas | 48041 | 46882 | 368 |
2098771 | 2098771 | 2022-01-09 | Brazos | Texas | 48041 | 46425 | 368 |
2095519 | 2095519 | 2022-01-08 | Brazos | Texas | 48041 | 46041 | 368 |
2092267 | 2092267 | 2022-01-07 | Brazos | Texas | 48041 | 45559 | 368 |
2089015 | 2089015 | 2022-01-06 | Brazos | Texas | 48041 | 44709 | 368 |
2085764 | 2085764 | 2022-01-05 | Brazos | Texas | 48041 | 43877 | 368 |
2082512 | 2082512 | 2022-01-04 | Brazos | Texas | 48041 | 43358 | 368 |
2079260 | 2079260 | 2022-01-03 | Brazos | Texas | 48041 | 42894 | 368 |
2076009 | 2076009 | 2022-01-02 | Brazos | Texas | 48041 | 40712 | 368 |
2072758 | 2072758 | 2022-01-01 | Brazos | Texas | 48041 | 40712 | 368 |
2069507 | 2069507 | 2021-12-31 | Brazos | Texas | 48041 | 40712 | 368 |
2066256 | 2066256 | 2021-12-30 | Brazos | Texas | 48041 | 40712 | 368 |
2063006 | 2063006 | 2021-12-29 | Brazos | Texas | 48041 | 40641 | 368 |
2059756 | 2059756 | 2021-12-28 | Brazos | Texas | 48041 | 40558 | 368 |
2056507 | 2056507 | 2021-12-27 | Brazos | Texas | 48041 | 40491 | 368 |
2053258 | 2053258 | 2021-12-26 | Brazos | Texas | 48041 | 39865 | 368 |
2050008 | 2050008 | 2021-12-25 | Brazos | Texas | 48041 | 39865 | 368 |
2046758 | 2046758 | 2021-12-24 | Brazos | Texas | 48041 | 39865 | 368 |
2043508 | 2043508 | 2021-12-23 | Brazos | Texas | 48041 | 39865 | 368 |
2040259 | 2040259 | 2021-12-22 | Brazos | Texas | 48041 | 39685 | 368 |
2037009 | 2037009 | 2021-12-21 | Brazos | Texas | 48041 | 39549 | 368 |
2033759 | 2033759 | 2021-12-20 | Brazos | Texas | 48041 | 39493 | 368 |
2030509 | 2030509 | 2021-12-19 | Brazos | Texas | 48041 | 39448 | 368 |
2027258 | 2027258 | 2021-12-18 | Brazos | Texas | 48041 | 39446 | 368 |
2024007 | 2024007 | 2021-12-17 | Brazos | Texas | 48041 | 39446 | 368 |
2020756 | 2020756 | 2021-12-16 | Brazos | Texas | 48041 | 39415 | 368 |
2017505 | 2017505 | 2021-12-15 | Brazos | Texas | 48041 | 39381 | 368 |
2014255 | 2014255 | 2021-12-14 | Brazos | Texas | 48041 | 39351 | 368 |
2011004 | 2011004 | 2021-12-13 | Brazos | Texas | 48041 | 39324 | 368 |
2007753 | 2007753 | 2021-12-12 | Brazos | Texas | 48041 | 39302 | 368 |
2004502 | 2004502 | 2021-12-11 | Brazos | Texas | 48041 | 39302 | 368 |
2001251 | 2001251 | 2021-12-10 | Brazos | Texas | 48041 | 39302 | 368 |
1998001 | 1998001 | 2021-12-09 | Brazos | Texas | 48041 | 39274 | 366 |
1994750 | 1994750 | 2021-12-08 | Brazos | Texas | 48041 | 39249 | 366 |
1991499 | 1991499 | 2021-12-07 | Brazos | Texas | 48041 | 39222 | 366 |
1988248 | 1988248 | 2021-12-06 | Brazos | Texas | 48041 | 39194 | 366 |
1984998 | 1984998 | 2021-12-05 | Brazos | Texas | 48041 | 39167 | 366 |
1981748 | 1981748 | 2021-12-04 | Brazos | Texas | 48041 | 39167 | 366 |
1978498 | 1978498 | 2021-12-03 | Brazos | Texas | 48041 | 39167 | 366 |
1975248 | 1975248 | 2021-12-02 | Brazos | Texas | 48041 | 39142 | 364 |
1971999 | 1971999 | 2021-12-01 | Brazos | Texas | 48041 | 39111 | 364 |
1968749 | 1968749 | 2021-11-30 | Brazos | Texas | 48041 | 39082 | 364 |
1965498 | 1965498 | 2021-11-29 | Brazos | Texas | 48041 | 39055 | 364 |
1962246 | 1962246 | 2021-11-28 | Brazos | Texas | 48041 | 39026 | 364 |
1958995 | 1958995 | 2021-11-27 | Brazos | Texas | 48041 | 39026 | 364 |
1955744 | 1955744 | 2021-11-26 | Brazos | Texas | 48041 | 39026 | 364 |
1952493 | 1952493 | 2021-11-25 | Brazos | Texas | 48041 | 39026 | 364 |
1949242 | 1949242 | 2021-11-24 | Brazos | Texas | 48041 | 39026 | 364 |
1945991 | 1945991 | 2021-11-23 | Brazos | Texas | 48041 | 39001 | 363 |
1942740 | 1942740 | 2021-11-22 | Brazos | Texas | 48041 | 38954 | 363 |
1939490 | 1939490 | 2021-11-21 | Brazos | Texas | 48041 | 38929 | 363 |
1936240 | 1936240 | 2021-11-20 | Brazos | Texas | 48041 | 38929 | 363 |
1932990 | 1932990 | 2021-11-19 | Brazos | Texas | 48041 | 38929 | 363 |
1929739 | 1929739 | 2021-11-18 | Brazos | Texas | 48041 | 38904 | 363 |
1926489 | 1926489 | 2021-11-17 | Brazos | Texas | 48041 | 38884 | 363 |
1923239 | 1923239 | 2021-11-16 | Brazos | Texas | 48041 | 38862 | 363 |
1919990 | 1919990 | 2021-11-15 | Brazos | Texas | 48041 | 38838 | 363 |
1916740 | 1916740 | 2021-11-14 | Brazos | Texas | 48041 | 38819 | 363 |
1913490 | 1913490 | 2021-11-13 | Brazos | Texas | 48041 | 38819 | 363 |
1910240 | 1910240 | 2021-11-12 | Brazos | Texas | 48041 | 38819 | 363 |
1906991 | 1906991 | 2021-11-11 | Brazos | Texas | 48041 | 38785 | 363 |
1903742 | 1903742 | 2021-11-10 | Brazos | Texas | 48041 | 38751 | 363 |
1900492 | 1900492 | 2021-11-09 | Brazos | Texas | 48041 | 38722 | 363 |
1897242 | 1897242 | 2021-11-08 | Brazos | Texas | 48041 | 38699 | 359 |
1893992 | 1893992 | 2021-11-07 | Brazos | Texas | 48041 | 38687 | 359 |
1890742 | 1890742 | 2021-11-06 | Brazos | Texas | 48041 | 38687 | 359 |
1887492 | 1887492 | 2021-11-05 | Brazos | Texas | 48041 | 38687 | 359 |
1884242 | 1884242 | 2021-11-04 | Brazos | Texas | 48041 | 38670 | 359 |
1880993 | 1880993 | 2021-11-03 | Brazos | Texas | 48041 | 38660 | 359 |
1877744 | 1877744 | 2021-11-02 | Brazos | Texas | 48041 | 38645 | 359 |
1874495 | 1874495 | 2021-11-01 | Brazos | Texas | 48041 | 38637 | 359 |
1871246 | 1871246 | 2021-10-31 | Brazos | Texas | 48041 | 38626 | 354 |
1867997 | 1867997 | 2021-10-30 | Brazos | Texas | 48041 | 38626 | 354 |
1864748 | 1864748 | 2021-10-29 | Brazos | Texas | 48041 | 38626 | 354 |
1861499 | 1861499 | 2021-10-28 | Brazos | Texas | 48041 | 38609 | 354 |
1858250 | 1858250 | 2021-10-27 | Brazos | Texas | 48041 | 38589 | 354 |
1855001 | 1855001 | 2021-10-26 | Brazos | Texas | 48041 | 38553 | 354 |
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);