ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 48183 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176914 | 2176914 | 2022-02-02 | Gregg | Texas | 48183 | 22301 | 607 |
2173660 | 2173660 | 2022-02-01 | Gregg | Texas | 48183 | 22236 | 605 |
2170408 | 2170408 | 2022-01-31 | Gregg | Texas | 48183 | 22167 | 604 |
2167154 | 2167154 | 2022-01-30 | Gregg | Texas | 48183 | 22074 | 604 |
2163899 | 2163899 | 2022-01-29 | Gregg | Texas | 48183 | 22015 | 602 |
2160644 | 2160644 | 2022-01-28 | Gregg | Texas | 48183 | 21854 | 602 |
2157388 | 2157388 | 2022-01-27 | Gregg | Texas | 48183 | 21752 | 602 |
2154135 | 2154135 | 2022-01-26 | Gregg | Texas | 48183 | 21659 | 598 |
2150883 | 2150883 | 2022-01-25 | Gregg | Texas | 48183 | 21605 | 598 |
2147631 | 2147631 | 2022-01-24 | Gregg | Texas | 48183 | 21483 | 598 |
2144377 | 2144377 | 2022-01-23 | Gregg | Texas | 48183 | 21316 | 598 |
2141122 | 2141122 | 2022-01-22 | Gregg | Texas | 48183 | 21166 | 596 |
2137866 | 2137866 | 2022-01-21 | Gregg | Texas | 48183 | 20936 | 595 |
2134612 | 2134612 | 2022-01-20 | Gregg | Texas | 48183 | 20754 | 594 |
2131360 | 2131360 | 2022-01-19 | Gregg | Texas | 48183 | 20602 | 594 |
2128106 | 2128106 | 2022-01-18 | Gregg | Texas | 48183 | 20491 | 593 |
2124854 | 2124854 | 2022-01-17 | Gregg | Texas | 48183 | 20361 | 592 |
2121602 | 2121602 | 2022-01-16 | Gregg | Texas | 48183 | 20110 | 592 |
2118350 | 2118350 | 2022-01-15 | Gregg | Texas | 48183 | 20050 | 592 |
2115099 | 2115099 | 2022-01-14 | Gregg | Texas | 48183 | 19798 | 592 |
2111847 | 2111847 | 2022-01-13 | Gregg | Texas | 48183 | 21506 | 592 |
2108595 | 2108595 | 2022-01-12 | Gregg | Texas | 48183 | 21234 | 592 |
2105344 | 2105344 | 2022-01-11 | Gregg | Texas | 48183 | 21009 | 590 |
2102093 | 2102093 | 2022-01-10 | Gregg | Texas | 48183 | 20955 | 590 |
2098842 | 2098842 | 2022-01-09 | Gregg | Texas | 48183 | 20763 | 590 |
2095590 | 2095590 | 2022-01-08 | Gregg | Texas | 48183 | 20655 | 590 |
2092338 | 2092338 | 2022-01-07 | Gregg | Texas | 48183 | 20532 | 591 |
2089086 | 2089086 | 2022-01-06 | Gregg | Texas | 48183 | 20410 | 591 |
2085835 | 2085835 | 2022-01-05 | Gregg | Texas | 48183 | 20263 | 591 |
2082583 | 2082583 | 2022-01-04 | Gregg | Texas | 48183 | 20150 | 591 |
2079331 | 2079331 | 2022-01-03 | Gregg | Texas | 48183 | 20052 | 591 |
2076080 | 2076080 | 2022-01-02 | Gregg | Texas | 48183 | 19691 | 587 |
2072829 | 2072829 | 2022-01-01 | Gregg | Texas | 48183 | 19691 | 587 |
2069578 | 2069578 | 2021-12-31 | Gregg | Texas | 48183 | 19691 | 587 |
2066327 | 2066327 | 2021-12-30 | Gregg | Texas | 48183 | 19691 | 587 |
2063077 | 2063077 | 2021-12-29 | Gregg | Texas | 48183 | 19663 | 586 |
2059827 | 2059827 | 2021-12-28 | Gregg | Texas | 48183 | 19649 | 586 |
2056578 | 2056578 | 2021-12-27 | Gregg | Texas | 48183 | 19627 | 586 |
2053329 | 2053329 | 2021-12-26 | Gregg | Texas | 48183 | 19584 | 584 |
2050079 | 2050079 | 2021-12-25 | Gregg | Texas | 48183 | 19584 | 584 |
2046829 | 2046829 | 2021-12-24 | Gregg | Texas | 48183 | 19584 | 584 |
2043579 | 2043579 | 2021-12-23 | Gregg | Texas | 48183 | 19584 | 584 |
2040330 | 2040330 | 2021-12-22 | Gregg | Texas | 48183 | 19574 | 584 |
2037080 | 2037080 | 2021-12-21 | Gregg | Texas | 48183 | 19574 | 584 |
2033830 | 2033830 | 2021-12-20 | Gregg | Texas | 48183 | 19566 | 584 |
2030580 | 2030580 | 2021-12-19 | Gregg | Texas | 48183 | 19563 | 584 |
2027329 | 2027329 | 2021-12-18 | Gregg | Texas | 48183 | 19555 | 584 |
2024078 | 2024078 | 2021-12-17 | Gregg | Texas | 48183 | 19551 | 584 |
2020827 | 2020827 | 2021-12-16 | Gregg | Texas | 48183 | 19548 | 584 |
2017576 | 2017576 | 2021-12-15 | Gregg | Texas | 48183 | 19542 | 584 |
2014326 | 2014326 | 2021-12-14 | Gregg | Texas | 48183 | 19534 | 583 |
2011075 | 2011075 | 2021-12-13 | Gregg | Texas | 48183 | 19532 | 583 |
2007824 | 2007824 | 2021-12-12 | Gregg | Texas | 48183 | 19523 | 583 |
2004573 | 2004573 | 2021-12-11 | Gregg | Texas | 48183 | 19519 | 583 |
2001322 | 2001322 | 2021-12-10 | Gregg | Texas | 48183 | 19515 | 583 |
1998072 | 1998072 | 2021-12-09 | Gregg | Texas | 48183 | 19491 | 583 |
1994821 | 1994821 | 2021-12-08 | Gregg | Texas | 48183 | 19486 | 582 |
1991570 | 1991570 | 2021-12-07 | Gregg | Texas | 48183 | 19482 | 582 |
1988319 | 1988319 | 2021-12-06 | Gregg | Texas | 48183 | 19475 | 581 |
1985069 | 1985069 | 2021-12-05 | Gregg | Texas | 48183 | 19466 | 581 |
1981819 | 1981819 | 2021-12-04 | Gregg | Texas | 48183 | 19465 | 581 |
1978569 | 1978569 | 2021-12-03 | Gregg | Texas | 48183 | 19462 | 581 |
1975319 | 1975319 | 2021-12-02 | Gregg | Texas | 48183 | 19459 | 581 |
1972070 | 1972070 | 2021-12-01 | Gregg | Texas | 48183 | 19449 | 579 |
1968820 | 1968820 | 2021-11-30 | Gregg | Texas | 48183 | 19449 | 579 |
1965569 | 1965569 | 2021-11-29 | Gregg | Texas | 48183 | 19438 | 578 |
1962317 | 1962317 | 2021-11-28 | Gregg | Texas | 48183 | 19420 | 577 |
1959066 | 1959066 | 2021-11-27 | Gregg | Texas | 48183 | 19420 | 577 |
1955815 | 1955815 | 2021-11-26 | Gregg | Texas | 48183 | 19420 | 577 |
1952564 | 1952564 | 2021-11-25 | Gregg | Texas | 48183 | 19420 | 577 |
1949313 | 1949313 | 2021-11-24 | Gregg | Texas | 48183 | 19420 | 577 |
1946062 | 1946062 | 2021-11-23 | Gregg | Texas | 48183 | 19420 | 576 |
1942811 | 1942811 | 2021-11-22 | Gregg | Texas | 48183 | 19402 | 575 |
1939561 | 1939561 | 2021-11-21 | Gregg | Texas | 48183 | 19402 | 575 |
1936311 | 1936311 | 2021-11-20 | Gregg | Texas | 48183 | 19402 | 574 |
1933061 | 1933061 | 2021-11-19 | Gregg | Texas | 48183 | 19384 | 573 |
1929810 | 1929810 | 2021-11-18 | Gregg | Texas | 48183 | 19384 | 571 |
1926560 | 1926560 | 2021-11-17 | Gregg | Texas | 48183 | 19384 | 569 |
1923310 | 1923310 | 2021-11-16 | Gregg | Texas | 48183 | 19384 | 568 |
1920061 | 1920061 | 2021-11-15 | Gregg | Texas | 48183 | 19359 | 568 |
1916811 | 1916811 | 2021-11-14 | Gregg | Texas | 48183 | 19359 | 568 |
1913561 | 1913561 | 2021-11-13 | Gregg | Texas | 48183 | 19359 | 568 |
1910311 | 1910311 | 2021-11-12 | Gregg | Texas | 48183 | 19359 | 567 |
1907062 | 1907062 | 2021-11-11 | Gregg | Texas | 48183 | 19343 | 558 |
1903813 | 1903813 | 2021-11-10 | Gregg | Texas | 48183 | 19343 | 556 |
1900563 | 1900563 | 2021-11-09 | Gregg | Texas | 48183 | 19343 | 556 |
1897313 | 1897313 | 2021-11-08 | Gregg | Texas | 48183 | 19328 | 555 |
1894063 | 1894063 | 2021-11-07 | Gregg | Texas | 48183 | 19328 | 554 |
1890813 | 1890813 | 2021-11-06 | Gregg | Texas | 48183 | 19328 | 553 |
1887563 | 1887563 | 2021-11-05 | Gregg | Texas | 48183 | 19328 | 550 |
1884313 | 1884313 | 2021-11-04 | Gregg | Texas | 48183 | 19295 | 547 |
1881064 | 1881064 | 2021-11-03 | Gregg | Texas | 48183 | 19295 | 547 |
1877815 | 1877815 | 2021-11-02 | Gregg | Texas | 48183 | 19295 | 544 |
1874566 | 1874566 | 2021-11-01 | Gregg | Texas | 48183 | 19266 | 543 |
1871317 | 1871317 | 2021-10-31 | Gregg | Texas | 48183 | 19266 | 543 |
1868068 | 1868068 | 2021-10-30 | Gregg | Texas | 48183 | 19266 | 543 |
1864819 | 1864819 | 2021-10-29 | Gregg | Texas | 48183 | 19266 | 543 |
1861570 | 1861570 | 2021-10-28 | Gregg | Texas | 48183 | 19219 | 540 |
1858321 | 1858321 | 2021-10-27 | Gregg | Texas | 48183 | 19219 | 539 |
1855072 | 1855072 | 2021-10-26 | Gregg | Texas | 48183 | 19219 | 539 |
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);