ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 48139 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1949292 | 1949292 | 2021-11-24 | Ellis | Texas | 48139 | 34066 | 479 |
1946041 | 1946041 | 2021-11-23 | Ellis | Texas | 48139 | 34050 | 479 |
1942790 | 1942790 | 2021-11-22 | Ellis | Texas | 48139 | 34028 | 478 |
1939540 | 1939540 | 2021-11-21 | Ellis | Texas | 48139 | 34028 | 478 |
1936290 | 1936290 | 2021-11-20 | Ellis | Texas | 48139 | 34028 | 478 |
1933040 | 1933040 | 2021-11-19 | Ellis | Texas | 48139 | 34023 | 477 |
1929789 | 1929789 | 2021-11-18 | Ellis | Texas | 48139 | 34018 | 477 |
1926539 | 1926539 | 2021-11-17 | Ellis | Texas | 48139 | 34016 | 475 |
1923289 | 1923289 | 2021-11-16 | Ellis | Texas | 48139 | 34008 | 475 |
1920040 | 1920040 | 2021-11-15 | Ellis | Texas | 48139 | 33993 | 475 |
1916790 | 1916790 | 2021-11-14 | Ellis | Texas | 48139 | 33993 | 475 |
1913540 | 1913540 | 2021-11-13 | Ellis | Texas | 48139 | 33993 | 475 |
1910290 | 1910290 | 2021-11-12 | Ellis | Texas | 48139 | 33967 | 475 |
1907041 | 1907041 | 2021-11-11 | Ellis | Texas | 48139 | 33967 | 473 |
1903792 | 1903792 | 2021-11-10 | Ellis | Texas | 48139 | 33917 | 470 |
1900542 | 1900542 | 2021-11-09 | Ellis | Texas | 48139 | 33917 | 470 |
1897292 | 1897292 | 2021-11-08 | Ellis | Texas | 48139 | 33878 | 470 |
1894042 | 1894042 | 2021-11-07 | Ellis | Texas | 48139 | 33878 | 470 |
1890792 | 1890792 | 2021-11-06 | Ellis | Texas | 48139 | 33878 | 470 |
1887542 | 1887542 | 2021-11-05 | Ellis | Texas | 48139 | 33857 | 469 |
1884292 | 1884292 | 2021-11-04 | Ellis | Texas | 48139 | 33848 | 467 |
1881043 | 1881043 | 2021-11-03 | Ellis | Texas | 48139 | 33828 | 467 |
1877794 | 1877794 | 2021-11-02 | Ellis | Texas | 48139 | 33812 | 467 |
1874545 | 1874545 | 2021-11-01 | Ellis | Texas | 48139 | 33623 | 465 |
1871296 | 1871296 | 2021-10-31 | Ellis | Texas | 48139 | 33623 | 465 |
1868047 | 1868047 | 2021-10-30 | Ellis | Texas | 48139 | 33623 | 465 |
1864798 | 1864798 | 2021-10-29 | Ellis | Texas | 48139 | 33594 | 465 |
1861549 | 1861549 | 2021-10-28 | Ellis | Texas | 48139 | 33568 | 463 |
1858300 | 1858300 | 2021-10-27 | Ellis | Texas | 48139 | 33390 | 461 |
1855051 | 1855051 | 2021-10-26 | Ellis | Texas | 48139 | 33350 | 458 |
1851802 | 1851802 | 2021-10-25 | Ellis | Texas | 48139 | 33241 | 455 |
1848552 | 1848552 | 2021-10-24 | Ellis | Texas | 48139 | 33241 | 455 |
1845302 | 1845302 | 2021-10-23 | Ellis | Texas | 48139 | 33241 | 454 |
1842052 | 1842052 | 2021-10-22 | Ellis | Texas | 48139 | 33152 | 449 |
1838803 | 1838803 | 2021-10-21 | Ellis | Texas | 48139 | 33106 | 445 |
1835554 | 1835554 | 2021-10-20 | Ellis | Texas | 48139 | 33006 | 444 |
1832305 | 1832305 | 2021-10-19 | Ellis | Texas | 48139 | 32945 | 441 |
1829056 | 1829056 | 2021-10-18 | Ellis | Texas | 48139 | 32780 | 438 |
1825807 | 1825807 | 2021-10-17 | Ellis | Texas | 48139 | 32780 | 438 |
1822558 | 1822558 | 2021-10-16 | Ellis | Texas | 48139 | 32780 | 437 |
1819309 | 1819309 | 2021-10-15 | Ellis | Texas | 48139 | 32710 | 435 |
1816060 | 1816060 | 2021-10-14 | Ellis | Texas | 48139 | 32620 | 434 |
1812812 | 1812812 | 2021-10-13 | Ellis | Texas | 48139 | 32538 | 431 |
1809563 | 1809563 | 2021-10-12 | Ellis | Texas | 48139 | 32425 | 430 |
1806313 | 1806313 | 2021-10-11 | Ellis | Texas | 48139 | 32192 | 430 |
1803063 | 1803063 | 2021-10-10 | Ellis | Texas | 48139 | 32192 | 430 |
1799814 | 1799814 | 2021-10-09 | Ellis | Texas | 48139 | 32192 | 427 |
1796565 | 1796565 | 2021-10-08 | Ellis | Texas | 48139 | 32136 | 422 |
1793316 | 1793316 | 2021-10-07 | Ellis | Texas | 48139 | 32070 | 419 |
1790067 | 1790067 | 2021-10-06 | Ellis | Texas | 48139 | 31951 | 416 |
1786819 | 1786819 | 2021-10-05 | Ellis | Texas | 48139 | 31838 | 413 |
1783570 | 1783570 | 2021-10-04 | Ellis | Texas | 48139 | 31652 | 411 |
1780321 | 1780321 | 2021-10-03 | Ellis | Texas | 48139 | 31652 | 411 |
1777071 | 1777071 | 2021-10-02 | Ellis | Texas | 48139 | 31652 | 411 |
1773821 | 1773821 | 2021-10-01 | Ellis | Texas | 48139 | 31562 | 410 |
1770571 | 1770571 | 2021-09-30 | Ellis | Texas | 48139 | 31466 | 410 |
1767322 | 1767322 | 2021-09-29 | Ellis | Texas | 48139 | 31354 | 410 |
1764073 | 1764073 | 2021-09-28 | Ellis | Texas | 48139 | 31230 | 406 |
1760824 | 1760824 | 2021-09-27 | Ellis | Texas | 48139 | 30912 | 401 |
1757576 | 1757576 | 2021-09-26 | Ellis | Texas | 48139 | 30912 | 401 |
1754328 | 1754328 | 2021-09-25 | Ellis | Texas | 48139 | 30912 | 400 |
1751080 | 1751080 | 2021-09-24 | Ellis | Texas | 48139 | 30671 | 400 |
1747831 | 1747831 | 2021-09-23 | Ellis | Texas | 48139 | 30671 | 397 |
1744581 | 1744581 | 2021-09-22 | Ellis | Texas | 48139 | 30486 | 394 |
1741332 | 1741332 | 2021-09-21 | Ellis | Texas | 48139 | 30453 | 390 |
1738083 | 1738083 | 2021-09-20 | Ellis | Texas | 48139 | 30145 | 388 |
1734833 | 1734833 | 2021-09-19 | Ellis | Texas | 48139 | 30145 | 388 |
1731583 | 1731583 | 2021-09-18 | Ellis | Texas | 48139 | 30145 | 385 |
1728333 | 1728333 | 2021-09-17 | Ellis | Texas | 48139 | 30044 | 383 |
1725084 | 1725084 | 2021-09-16 | Ellis | Texas | 48139 | 29905 | 380 |
1721835 | 1721835 | 2021-09-15 | Ellis | Texas | 48139 | 29718 | 379 |
1718587 | 1718587 | 2021-09-14 | Ellis | Texas | 48139 | 29555 | 377 |
1715339 | 1715339 | 2021-09-13 | Ellis | Texas | 48139 | 29160 | 374 |
1712093 | 1712093 | 2021-09-12 | Ellis | Texas | 48139 | 29160 | 374 |
1708846 | 1708846 | 2021-09-11 | Ellis | Texas | 48139 | 29160 | 370 |
1705599 | 1705599 | 2021-09-10 | Ellis | Texas | 48139 | 29041 | 366 |
1702349 | 1702349 | 2021-09-09 | Ellis | Texas | 48139 | 28895 | 364 |
1699100 | 1699100 | 2021-09-08 | Ellis | Texas | 48139 | 28633 | 363 |
1695852 | 1695852 | 2021-09-07 | Ellis | Texas | 48139 | 27840 | 362 |
1692604 | 1692604 | 2021-09-06 | Ellis | Texas | 48139 | 27840 | 361 |
1689355 | 1689355 | 2021-09-05 | Ellis | Texas | 48139 | 27840 | 360 |
1686105 | 1686105 | 2021-09-04 | Ellis | Texas | 48139 | 27840 | 360 |
1682854 | 1682854 | 2021-09-03 | Ellis | Texas | 48139 | 27723 | 358 |
1679604 | 1679604 | 2021-09-02 | Ellis | Texas | 48139 | 27410 | 357 |
1676356 | 1676356 | 2021-09-01 | Ellis | Texas | 48139 | 27128 | 353 |
1673109 | 1673109 | 2021-08-31 | Ellis | Texas | 48139 | 26996 | 350 |
1669861 | 1669861 | 2021-08-30 | Ellis | Texas | 48139 | 26600 | 350 |
1666614 | 1666614 | 2021-08-29 | Ellis | Texas | 48139 | 26600 | 350 |
1663366 | 1663366 | 2021-08-28 | Ellis | Texas | 48139 | 26600 | 349 |
1660118 | 1660118 | 2021-08-27 | Ellis | Texas | 48139 | 26600 | 346 |
1656869 | 1656869 | 2021-08-26 | Ellis | Texas | 48139 | 26431 | 345 |
1653622 | 1653622 | 2021-08-25 | Ellis | Texas | 48139 | 26295 | 342 |
1650375 | 1650375 | 2021-08-24 | Ellis | Texas | 48139 | 26070 | 337 |
1647126 | 1647126 | 2021-08-23 | Ellis | Texas | 48139 | 25854 | 336 |
1643877 | 1643877 | 2021-08-22 | Ellis | Texas | 48139 | 25854 | 336 |
1640627 | 1640627 | 2021-08-21 | Ellis | Texas | 48139 | 25854 | 336 |
1637377 | 1637377 | 2021-08-20 | Ellis | Texas | 48139 | 25790 | 336 |
1634127 | 1634127 | 2021-08-19 | Ellis | Texas | 48139 | 25713 | 335 |
1630880 | 1630880 | 2021-08-18 | Ellis | Texas | 48139 | 25580 | 333 |
1627633 | 1627633 | 2021-08-17 | Ellis | Texas | 48139 | 25366 | 331 |
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);