ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
624 rows where cases = 8 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Loving 76
- Jeff Davis 39
- Lampasas 21
- Lamar 19
- Madison 18
- Roberts 17
- Armstrong 16
- Throckmorton 14
- Callahan 12
- Trinity 11
- Hopkins 10
- Rains 10
- Zapata 10
- Cherokee 8
- Lavaca 8
- San Patricio 7
- Stephens 7
- Blanco 6
- Castro 6
- Crosby 6
- Hill 6
- Hunt 6
- Kent 6
- Lynn 6
- McMullen 6
- Terrell 6
- Archer 5
- Burleson 5
- Hall 5
- Hamilton 5
- …
state 1
- Texas · 624 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1968879 | 1968879 | 2021-11-30 | Loving | Texas | 48301 | 8 | 0 |
1965628 | 1965628 | 2021-11-29 | Loving | Texas | 48301 | 8 | 0 |
1962376 | 1962376 | 2021-11-28 | Loving | Texas | 48301 | 8 | 0 |
1959125 | 1959125 | 2021-11-27 | Loving | Texas | 48301 | 8 | 0 |
1955874 | 1955874 | 2021-11-26 | Loving | Texas | 48301 | 8 | 0 |
1952623 | 1952623 | 2021-11-25 | Loving | Texas | 48301 | 8 | 0 |
1949372 | 1949372 | 2021-11-24 | Loving | Texas | 48301 | 8 | 0 |
1946121 | 1946121 | 2021-11-23 | Loving | Texas | 48301 | 8 | 0 |
1942870 | 1942870 | 2021-11-22 | Loving | Texas | 48301 | 8 | 0 |
1939620 | 1939620 | 2021-11-21 | Loving | Texas | 48301 | 8 | 0 |
1936370 | 1936370 | 2021-11-20 | Loving | Texas | 48301 | 8 | 0 |
1933120 | 1933120 | 2021-11-19 | Loving | Texas | 48301 | 8 | 0 |
1929869 | 1929869 | 2021-11-18 | Loving | Texas | 48301 | 8 | 0 |
1926619 | 1926619 | 2021-11-17 | Loving | Texas | 48301 | 8 | 0 |
1923369 | 1923369 | 2021-11-16 | Loving | Texas | 48301 | 8 | 0 |
1920120 | 1920120 | 2021-11-15 | Loving | Texas | 48301 | 8 | 0 |
1916870 | 1916870 | 2021-11-14 | Loving | Texas | 48301 | 8 | 0 |
1913620 | 1913620 | 2021-11-13 | Loving | Texas | 48301 | 8 | 0 |
1910370 | 1910370 | 2021-11-12 | Loving | Texas | 48301 | 8 | 0 |
1907121 | 1907121 | 2021-11-11 | Loving | Texas | 48301 | 8 | 0 |
1903872 | 1903872 | 2021-11-10 | Loving | Texas | 48301 | 8 | 0 |
1900622 | 1900622 | 2021-11-09 | Loving | Texas | 48301 | 8 | 0 |
1897372 | 1897372 | 2021-11-08 | Loving | Texas | 48301 | 8 | 0 |
1894122 | 1894122 | 2021-11-07 | Loving | Texas | 48301 | 8 | 0 |
1890872 | 1890872 | 2021-11-06 | Loving | Texas | 48301 | 8 | 0 |
1887622 | 1887622 | 2021-11-05 | Loving | Texas | 48301 | 8 | 0 |
1884372 | 1884372 | 2021-11-04 | Loving | Texas | 48301 | 8 | 0 |
1881123 | 1881123 | 2021-11-03 | Loving | Texas | 48301 | 8 | 0 |
1877874 | 1877874 | 2021-11-02 | Loving | Texas | 48301 | 8 | 0 |
1874625 | 1874625 | 2021-11-01 | Loving | Texas | 48301 | 8 | 0 |
1871376 | 1871376 | 2021-10-31 | Loving | Texas | 48301 | 8 | 0 |
1868127 | 1868127 | 2021-10-30 | Loving | Texas | 48301 | 8 | 0 |
1864878 | 1864878 | 2021-10-29 | Loving | Texas | 48301 | 8 | 0 |
1861629 | 1861629 | 2021-10-28 | Loving | Texas | 48301 | 8 | 0 |
1858380 | 1858380 | 2021-10-27 | Loving | Texas | 48301 | 8 | 0 |
1855131 | 1855131 | 2021-10-26 | Loving | Texas | 48301 | 8 | 0 |
1851882 | 1851882 | 2021-10-25 | Loving | Texas | 48301 | 8 | 0 |
1848632 | 1848632 | 2021-10-24 | Loving | Texas | 48301 | 8 | 0 |
1845382 | 1845382 | 2021-10-23 | Loving | Texas | 48301 | 8 | 0 |
1842132 | 1842132 | 2021-10-22 | Loving | Texas | 48301 | 8 | 0 |
1838883 | 1838883 | 2021-10-21 | Loving | Texas | 48301 | 8 | 0 |
1835634 | 1835634 | 2021-10-20 | Loving | Texas | 48301 | 8 | 0 |
1832385 | 1832385 | 2021-10-19 | Loving | Texas | 48301 | 8 | 0 |
1829136 | 1829136 | 2021-10-18 | Loving | Texas | 48301 | 8 | 0 |
1825887 | 1825887 | 2021-10-17 | Loving | Texas | 48301 | 8 | 0 |
1822638 | 1822638 | 2021-10-16 | Loving | Texas | 48301 | 8 | 0 |
1819389 | 1819389 | 2021-10-15 | Loving | Texas | 48301 | 8 | 0 |
1816140 | 1816140 | 2021-10-14 | Loving | Texas | 48301 | 8 | 0 |
1812892 | 1812892 | 2021-10-13 | Loving | Texas | 48301 | 8 | 0 |
1809643 | 1809643 | 2021-10-12 | Loving | Texas | 48301 | 8 | 0 |
1806393 | 1806393 | 2021-10-11 | Loving | Texas | 48301 | 8 | 0 |
1803143 | 1803143 | 2021-10-10 | Loving | Texas | 48301 | 8 | 0 |
1799894 | 1799894 | 2021-10-09 | Loving | Texas | 48301 | 8 | 0 |
1796645 | 1796645 | 2021-10-08 | Loving | Texas | 48301 | 8 | 0 |
1793396 | 1793396 | 2021-10-07 | Loving | Texas | 48301 | 8 | 0 |
1790147 | 1790147 | 2021-10-06 | Loving | Texas | 48301 | 8 | 0 |
1786899 | 1786899 | 2021-10-05 | Loving | Texas | 48301 | 8 | 0 |
1783650 | 1783650 | 2021-10-04 | Loving | Texas | 48301 | 8 | 0 |
1780401 | 1780401 | 2021-10-03 | Loving | Texas | 48301 | 8 | 0 |
1777151 | 1777151 | 2021-10-02 | Loving | Texas | 48301 | 8 | 0 |
1773901 | 1773901 | 2021-10-01 | Loving | Texas | 48301 | 8 | 0 |
1770651 | 1770651 | 2021-09-30 | Loving | Texas | 48301 | 8 | 0 |
1760904 | 1760904 | 2021-09-27 | Loving | Texas | 48301 | 8 | 0 |
1757656 | 1757656 | 2021-09-26 | Loving | Texas | 48301 | 8 | 0 |
1754408 | 1754408 | 2021-09-25 | Loving | Texas | 48301 | 8 | 0 |
1751160 | 1751160 | 2021-09-24 | Loving | Texas | 48301 | 8 | 0 |
1747911 | 1747911 | 2021-09-23 | Loving | Texas | 48301 | 8 | 0 |
1744661 | 1744661 | 2021-09-22 | Loving | Texas | 48301 | 8 | 0 |
1741412 | 1741412 | 2021-09-21 | Loving | Texas | 48301 | 8 | 0 |
1738163 | 1738163 | 2021-09-20 | Loving | Texas | 48301 | 8 | 0 |
1734913 | 1734913 | 2021-09-19 | Loving | Texas | 48301 | 8 | 0 |
1731663 | 1731663 | 2021-09-18 | Loving | Texas | 48301 | 8 | 0 |
1728413 | 1728413 | 2021-09-17 | Loving | Texas | 48301 | 8 | 0 |
1725164 | 1725164 | 2021-09-16 | Loving | Texas | 48301 | 8 | 0 |
1721915 | 1721915 | 2021-09-15 | Loving | Texas | 48301 | 8 | 0 |
1718667 | 1718667 | 2021-09-14 | Loving | Texas | 48301 | 8 | 0 |
722069 | 722069 | 2020-11-11 | Terrell | Texas | 48443 | 8 | 0 |
718826 | 718826 | 2020-11-10 | Terrell | Texas | 48443 | 8 | 0 |
715583 | 715583 | 2020-11-09 | Terrell | Texas | 48443 | 8 | 0 |
712339 | 712339 | 2020-11-08 | Terrell | Texas | 48443 | 8 | 0 |
709095 | 709095 | 2020-11-07 | Terrell | Texas | 48443 | 8 | 0 |
705851 | 705851 | 2020-11-06 | Terrell | Texas | 48443 | 8 | 0 |
627985 | 627985 | 2020-10-13 | Sterling | Texas | 48431 | 8 | 0 |
602054 | 602054 | 2020-10-05 | Throckmorton | Texas | 48447 | 8 | 2 |
598811 | 598811 | 2020-10-04 | Throckmorton | Texas | 48447 | 8 | 2 |
595568 | 595568 | 2020-10-03 | Throckmorton | Texas | 48447 | 8 | 2 |
592326 | 592326 | 2020-10-02 | Throckmorton | Texas | 48447 | 8 | 2 |
589086 | 589086 | 2020-10-01 | Throckmorton | Texas | 48447 | 8 | 2 |
585845 | 585845 | 2020-09-30 | Throckmorton | Texas | 48447 | 8 | 2 |
582605 | 582605 | 2020-09-29 | Throckmorton | Texas | 48447 | 8 | 2 |
579366 | 579366 | 2020-09-28 | Throckmorton | Texas | 48447 | 8 | 2 |
576125 | 576125 | 2020-09-27 | Throckmorton | Texas | 48447 | 8 | 2 |
572881 | 572881 | 2020-09-26 | Throckmorton | Texas | 48447 | 8 | 2 |
569588 | 569588 | 2020-09-25 | Motley | Texas | 48345 | 8 | 0 |
569639 | 569639 | 2020-09-25 | Throckmorton | Texas | 48447 | 8 | 2 |
566347 | 566347 | 2020-09-24 | Motley | Texas | 48345 | 8 | 0 |
566398 | 566398 | 2020-09-24 | Throckmorton | Texas | 48447 | 8 | 2 |
563022 | 563022 | 2020-09-23 | Glasscock | Texas | 48173 | 8 | 0 |
563157 | 563157 | 2020-09-23 | Throckmorton | Texas | 48447 | 8 | 2 |
559783 | 559783 | 2020-09-22 | Glasscock | Texas | 48173 | 8 | 0 |
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);