ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 48037 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176841 | 2176841 | 2022-02-02 | Bowie | Texas | 48037 | 17996 | 374 |
2173587 | 2173587 | 2022-02-01 | Bowie | Texas | 48037 | 17876 | 374 |
2170335 | 2170335 | 2022-01-31 | Bowie | Texas | 48037 | 17801 | 373 |
2167081 | 2167081 | 2022-01-30 | Bowie | Texas | 48037 | 17754 | 373 |
2163826 | 2163826 | 2022-01-29 | Bowie | Texas | 48037 | 17719 | 372 |
2160571 | 2160571 | 2022-01-28 | Bowie | Texas | 48037 | 17561 | 372 |
2157315 | 2157315 | 2022-01-27 | Bowie | Texas | 48037 | 17411 | 372 |
2154062 | 2154062 | 2022-01-26 | Bowie | Texas | 48037 | 17324 | 369 |
2150810 | 2150810 | 2022-01-25 | Bowie | Texas | 48037 | 17270 | 364 |
2147558 | 2147558 | 2022-01-24 | Bowie | Texas | 48037 | 17184 | 364 |
2144304 | 2144304 | 2022-01-23 | Bowie | Texas | 48037 | 17094 | 364 |
2141049 | 2141049 | 2022-01-22 | Bowie | Texas | 48037 | 16950 | 364 |
2137793 | 2137793 | 2022-01-21 | Bowie | Texas | 48037 | 16824 | 364 |
2134539 | 2134539 | 2022-01-20 | Bowie | Texas | 48037 | 16624 | 363 |
2131287 | 2131287 | 2022-01-19 | Bowie | Texas | 48037 | 16449 | 362 |
2128033 | 2128033 | 2022-01-18 | Bowie | Texas | 48037 | 16364 | 362 |
2124781 | 2124781 | 2022-01-17 | Bowie | Texas | 48037 | 16280 | 362 |
2121529 | 2121529 | 2022-01-16 | Bowie | Texas | 48037 | 16045 | 362 |
2118277 | 2118277 | 2022-01-15 | Bowie | Texas | 48037 | 15977 | 361 |
2115026 | 2115026 | 2022-01-14 | Bowie | Texas | 48037 | 15790 | 360 |
2111774 | 2111774 | 2022-01-13 | Bowie | Texas | 48037 | 14971 | 359 |
2108522 | 2108522 | 2022-01-12 | Bowie | Texas | 48037 | 14832 | 360 |
2105271 | 2105271 | 2022-01-11 | Bowie | Texas | 48037 | 14640 | 358 |
2102020 | 2102020 | 2022-01-10 | Bowie | Texas | 48037 | 14550 | 358 |
2098769 | 2098769 | 2022-01-09 | Bowie | Texas | 48037 | 14430 | 358 |
2095517 | 2095517 | 2022-01-08 | Bowie | Texas | 48037 | 14313 | 357 |
2092265 | 2092265 | 2022-01-07 | Bowie | Texas | 48037 | 14209 | 356 |
2089013 | 2089013 | 2022-01-06 | Bowie | Texas | 48037 | 14052 | 356 |
2085762 | 2085762 | 2022-01-05 | Bowie | Texas | 48037 | 13998 | 355 |
2082510 | 2082510 | 2022-01-04 | Bowie | Texas | 48037 | 13915 | 354 |
2079258 | 2079258 | 2022-01-03 | Bowie | Texas | 48037 | 13805 | 354 |
2076007 | 2076007 | 2022-01-02 | Bowie | Texas | 48037 | 13565 | 351 |
2072756 | 2072756 | 2022-01-01 | Bowie | Texas | 48037 | 13565 | 351 |
2069505 | 2069505 | 2021-12-31 | Bowie | Texas | 48037 | 13565 | 351 |
2066254 | 2066254 | 2021-12-30 | Bowie | Texas | 48037 | 13565 | 351 |
2063004 | 2063004 | 2021-12-29 | Bowie | Texas | 48037 | 13549 | 351 |
2059754 | 2059754 | 2021-12-28 | Bowie | Texas | 48037 | 13528 | 351 |
2056505 | 2056505 | 2021-12-27 | Bowie | Texas | 48037 | 13474 | 351 |
2053256 | 2053256 | 2021-12-26 | Bowie | Texas | 48037 | 13416 | 349 |
2050006 | 2050006 | 2021-12-25 | Bowie | Texas | 48037 | 13416 | 349 |
2046756 | 2046756 | 2021-12-24 | Bowie | Texas | 48037 | 13416 | 349 |
2043506 | 2043506 | 2021-12-23 | Bowie | Texas | 48037 | 13416 | 349 |
2040257 | 2040257 | 2021-12-22 | Bowie | Texas | 48037 | 13387 | 349 |
2037007 | 2037007 | 2021-12-21 | Bowie | Texas | 48037 | 13363 | 348 |
2033757 | 2033757 | 2021-12-20 | Bowie | Texas | 48037 | 13342 | 348 |
2030507 | 2030507 | 2021-12-19 | Bowie | Texas | 48037 | 13335 | 348 |
2027256 | 2027256 | 2021-12-18 | Bowie | Texas | 48037 | 13326 | 348 |
2024005 | 2024005 | 2021-12-17 | Bowie | Texas | 48037 | 13298 | 348 |
2020754 | 2020754 | 2021-12-16 | Bowie | Texas | 48037 | 13251 | 347 |
2017503 | 2017503 | 2021-12-15 | Bowie | Texas | 48037 | 13216 | 347 |
2014253 | 2014253 | 2021-12-14 | Bowie | Texas | 48037 | 13141 | 347 |
2011002 | 2011002 | 2021-12-13 | Bowie | Texas | 48037 | 13117 | 347 |
2007751 | 2007751 | 2021-12-12 | Bowie | Texas | 48037 | 13111 | 347 |
2004500 | 2004500 | 2021-12-11 | Bowie | Texas | 48037 | 13105 | 347 |
2001249 | 2001249 | 2021-12-10 | Bowie | Texas | 48037 | 13070 | 347 |
1997999 | 1997999 | 2021-12-09 | Bowie | Texas | 48037 | 13024 | 347 |
1994748 | 1994748 | 2021-12-08 | Bowie | Texas | 48037 | 12998 | 347 |
1991497 | 1991497 | 2021-12-07 | Bowie | Texas | 48037 | 12981 | 347 |
1988246 | 1988246 | 2021-12-06 | Bowie | Texas | 48037 | 12971 | 346 |
1984996 | 1984996 | 2021-12-05 | Bowie | Texas | 48037 | 12965 | 346 |
1981746 | 1981746 | 2021-12-04 | Bowie | Texas | 48037 | 12963 | 346 |
1978496 | 1978496 | 2021-12-03 | Bowie | Texas | 48037 | 12956 | 346 |
1975246 | 1975246 | 2021-12-02 | Bowie | Texas | 48037 | 12947 | 346 |
1971997 | 1971997 | 2021-12-01 | Bowie | Texas | 48037 | 12940 | 345 |
1968747 | 1968747 | 2021-11-30 | Bowie | Texas | 48037 | 12928 | 345 |
1965496 | 1965496 | 2021-11-29 | Bowie | Texas | 48037 | 12904 | 344 |
1962244 | 1962244 | 2021-11-28 | Bowie | Texas | 48037 | 12896 | 342 |
1958993 | 1958993 | 2021-11-27 | Bowie | Texas | 48037 | 12896 | 342 |
1955742 | 1955742 | 2021-11-26 | Bowie | Texas | 48037 | 12896 | 342 |
1952491 | 1952491 | 2021-11-25 | Bowie | Texas | 48037 | 12896 | 342 |
1949240 | 1949240 | 2021-11-24 | Bowie | Texas | 48037 | 12896 | 342 |
1945989 | 1945989 | 2021-11-23 | Bowie | Texas | 48037 | 12885 | 342 |
1942738 | 1942738 | 2021-11-22 | Bowie | Texas | 48037 | 12858 | 342 |
1939488 | 1939488 | 2021-11-21 | Bowie | Texas | 48037 | 12858 | 342 |
1936238 | 1936238 | 2021-11-20 | Bowie | Texas | 48037 | 12858 | 342 |
1932988 | 1932988 | 2021-11-19 | Bowie | Texas | 48037 | 12848 | 342 |
1929737 | 1929737 | 2021-11-18 | Bowie | Texas | 48037 | 12848 | 342 |
1926487 | 1926487 | 2021-11-17 | Bowie | Texas | 48037 | 12849 | 342 |
1923237 | 1923237 | 2021-11-16 | Bowie | Texas | 48037 | 12846 | 340 |
1919988 | 1919988 | 2021-11-15 | Bowie | Texas | 48037 | 12846 | 339 |
1916738 | 1916738 | 2021-11-14 | Bowie | Texas | 48037 | 12846 | 339 |
1913488 | 1913488 | 2021-11-13 | Bowie | Texas | 48037 | 12846 | 339 |
1910238 | 1910238 | 2021-11-12 | Bowie | Texas | 48037 | 12834 | 339 |
1906989 | 1906989 | 2021-11-11 | Bowie | Texas | 48037 | 12821 | 335 |
1903740 | 1903740 | 2021-11-10 | Bowie | Texas | 48037 | 12802 | 332 |
1900490 | 1900490 | 2021-11-09 | Bowie | Texas | 48037 | 12802 | 332 |
1897240 | 1897240 | 2021-11-08 | Bowie | Texas | 48037 | 12773 | 332 |
1893990 | 1893990 | 2021-11-07 | Bowie | Texas | 48037 | 12773 | 332 |
1890740 | 1890740 | 2021-11-06 | Bowie | Texas | 48037 | 12773 | 332 |
1887490 | 1887490 | 2021-11-05 | Bowie | Texas | 48037 | 12757 | 331 |
1884240 | 1884240 | 2021-11-04 | Bowie | Texas | 48037 | 12750 | 330 |
1880991 | 1880991 | 2021-11-03 | Bowie | Texas | 48037 | 12740 | 329 |
1877742 | 1877742 | 2021-11-02 | Bowie | Texas | 48037 | 12733 | 328 |
1874493 | 1874493 | 2021-11-01 | Bowie | Texas | 48037 | 12715 | 325 |
1871244 | 1871244 | 2021-10-31 | Bowie | Texas | 48037 | 12715 | 325 |
1867995 | 1867995 | 2021-10-30 | Bowie | Texas | 48037 | 12715 | 325 |
1864746 | 1864746 | 2021-10-29 | Bowie | Texas | 48037 | 12697 | 325 |
1861497 | 1861497 | 2021-10-28 | Bowie | Texas | 48037 | 12683 | 321 |
1858248 | 1858248 | 2021-10-27 | Bowie | Texas | 48037 | 12687 | 320 |
1854999 | 1854999 | 2021-10-26 | Bowie | Texas | 48037 | 12714 | 319 |
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);