ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Washington" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1809731 | 1809731 | 2021-10-12 | Washington | Texas | 48477 | 5653 | 123 |
1806481 | 1806481 | 2021-10-11 | Washington | Texas | 48477 | 5641 | 122 |
1803231 | 1803231 | 2021-10-10 | Washington | Texas | 48477 | 5628 | 122 |
1799982 | 1799982 | 2021-10-09 | Washington | Texas | 48477 | 5628 | 122 |
1796733 | 1796733 | 2021-10-08 | Washington | Texas | 48477 | 5620 | 122 |
1793484 | 1793484 | 2021-10-07 | Washington | Texas | 48477 | 5616 | 121 |
1790235 | 1790235 | 2021-10-06 | Washington | Texas | 48477 | 5601 | 121 |
1786987 | 1786987 | 2021-10-05 | Washington | Texas | 48477 | 5593 | 121 |
1783738 | 1783738 | 2021-10-04 | Washington | Texas | 48477 | 5583 | 121 |
1780489 | 1780489 | 2021-10-03 | Washington | Texas | 48477 | 5567 | 121 |
1777239 | 1777239 | 2021-10-02 | Washington | Texas | 48477 | 5567 | 121 |
1773989 | 1773989 | 2021-10-01 | Washington | Texas | 48477 | 5564 | 120 |
1770739 | 1770739 | 2021-09-30 | Washington | Texas | 48477 | 5557 | 119 |
1767490 | 1767490 | 2021-09-29 | Washington | Texas | 48477 | 5546 | 119 |
1764241 | 1764241 | 2021-09-28 | Washington | Texas | 48477 | 5535 | 119 |
1760992 | 1760992 | 2021-09-27 | Washington | Texas | 48477 | 5524 | 119 |
1757744 | 1757744 | 2021-09-26 | Washington | Texas | 48477 | 5489 | 119 |
1754496 | 1754496 | 2021-09-25 | Washington | Texas | 48477 | 5489 | 119 |
1751248 | 1751248 | 2021-09-24 | Washington | Texas | 48477 | 5455 | 117 |
1747999 | 1747999 | 2021-09-23 | Washington | Texas | 48477 | 5455 | 116 |
1744749 | 1744749 | 2021-09-22 | Washington | Texas | 48477 | 5436 | 116 |
1741500 | 1741500 | 2021-09-21 | Washington | Texas | 48477 | 5406 | 115 |
1738251 | 1738251 | 2021-09-20 | Washington | Texas | 48477 | 5356 | 115 |
1735001 | 1735001 | 2021-09-19 | Washington | Texas | 48477 | 5356 | 115 |
1731751 | 1731751 | 2021-09-18 | Washington | Texas | 48477 | 5356 | 114 |
1728501 | 1728501 | 2021-09-17 | Washington | Texas | 48477 | 5321 | 113 |
1725252 | 1725252 | 2021-09-16 | Washington | Texas | 48477 | 5313 | 113 |
1722003 | 1722003 | 2021-09-15 | Washington | Texas | 48477 | 5285 | 111 |
1718755 | 1718755 | 2021-09-14 | Washington | Texas | 48477 | 5276 | 111 |
1715507 | 1715507 | 2021-09-13 | Washington | Texas | 48477 | 5242 | 110 |
1712261 | 1712261 | 2021-09-12 | Washington | Texas | 48477 | 5218 | 110 |
1709014 | 1709014 | 2021-09-11 | Washington | Texas | 48477 | 5218 | 110 |
1705767 | 1705767 | 2021-09-10 | Washington | Texas | 48477 | 5182 | 107 |
1702517 | 1702517 | 2021-09-09 | Washington | Texas | 48477 | 5165 | 106 |
1699268 | 1699268 | 2021-09-08 | Washington | Texas | 48477 | 5144 | 105 |
1696020 | 1696020 | 2021-09-07 | Washington | Texas | 48477 | 5131 | 105 |
1692772 | 1692772 | 2021-09-06 | Washington | Texas | 48477 | 5101 | 105 |
1689523 | 1689523 | 2021-09-05 | Washington | Texas | 48477 | 5038 | 105 |
1686273 | 1686273 | 2021-09-04 | Washington | Texas | 48477 | 5038 | 105 |
1683022 | 1683022 | 2021-09-03 | Washington | Texas | 48477 | 5017 | 104 |
1679772 | 1679772 | 2021-09-02 | Washington | Texas | 48477 | 4972 | 104 |
1676524 | 1676524 | 2021-09-01 | Washington | Texas | 48477 | 4939 | 104 |
1673277 | 1673277 | 2021-08-31 | Washington | Texas | 48477 | 4912 | 104 |
1670029 | 1670029 | 2021-08-30 | Washington | Texas | 48477 | 4909 | 104 |
1666782 | 1666782 | 2021-08-29 | Washington | Texas | 48477 | 4888 | 104 |
1663534 | 1663534 | 2021-08-28 | Washington | Texas | 48477 | 4888 | 104 |
1660286 | 1660286 | 2021-08-27 | Washington | Texas | 48477 | 4876 | 104 |
1657037 | 1657037 | 2021-08-26 | Washington | Texas | 48477 | 4850 | 103 |
1653790 | 1653790 | 2021-08-25 | Washington | Texas | 48477 | 4827 | 103 |
1650543 | 1650543 | 2021-08-24 | Washington | Texas | 48477 | 4812 | 102 |
1647294 | 1647294 | 2021-08-23 | Washington | Texas | 48477 | 4803 | 102 |
1644045 | 1644045 | 2021-08-22 | Washington | Texas | 48477 | 4791 | 102 |
1640795 | 1640795 | 2021-08-21 | Washington | Texas | 48477 | 4791 | 102 |
1637545 | 1637545 | 2021-08-20 | Washington | Texas | 48477 | 4779 | 102 |
1634295 | 1634295 | 2021-08-19 | Washington | Texas | 48477 | 4771 | 102 |
1631048 | 1631048 | 2021-08-18 | Washington | Texas | 48477 | 4748 | 101 |
1627801 | 1627801 | 2021-08-17 | Washington | Texas | 48477 | 4711 | 100 |
1624554 | 1624554 | 2021-08-16 | Washington | Texas | 48477 | 4698 | 100 |
1621307 | 1621307 | 2021-08-15 | Washington | Texas | 48477 | 4671 | 100 |
1618059 | 1618059 | 2021-08-14 | Washington | Texas | 48477 | 4671 | 100 |
1614811 | 1614811 | 2021-08-13 | Washington | Texas | 48477 | 4645 | 100 |
1611562 | 1611562 | 2021-08-12 | Washington | Texas | 48477 | 4627 | 100 |
1608314 | 1608314 | 2021-08-11 | Washington | Texas | 48477 | 4618 | 100 |
1605065 | 1605065 | 2021-08-10 | Washington | Texas | 48477 | 4601 | 100 |
1601816 | 1601816 | 2021-08-09 | Washington | Texas | 48477 | 4589 | 100 |
1598568 | 1598568 | 2021-08-08 | Washington | Texas | 48477 | 4568 | 100 |
1595319 | 1595319 | 2021-08-07 | Washington | Texas | 48477 | 4568 | 100 |
1592070 | 1592070 | 2021-08-06 | Washington | Texas | 48477 | 4550 | 100 |
1588821 | 1588821 | 2021-08-05 | Washington | Texas | 48477 | 4534 | 100 |
1585571 | 1585571 | 2021-08-04 | Washington | Texas | 48477 | 4515 | 100 |
1582321 | 1582321 | 2021-08-03 | Washington | Texas | 48477 | 4485 | 99 |
1579072 | 1579072 | 2021-08-02 | Washington | Texas | 48477 | 4480 | 99 |
1575824 | 1575824 | 2021-08-01 | Washington | Texas | 48477 | 4462 | 99 |
1572576 | 1572576 | 2021-07-31 | Washington | Texas | 48477 | 4462 | 99 |
1569328 | 1569328 | 2021-07-30 | Washington | Texas | 48477 | 4448 | 98 |
1566080 | 1566080 | 2021-07-29 | Washington | Texas | 48477 | 4444 | 98 |
1562832 | 1562832 | 2021-07-28 | Washington | Texas | 48477 | 4433 | 98 |
1559584 | 1559584 | 2021-07-27 | Washington | Texas | 48477 | 4421 | 96 |
1556337 | 1556337 | 2021-07-26 | Washington | Texas | 48477 | 4413 | 96 |
1553090 | 1553090 | 2021-07-25 | Washington | Texas | 48477 | 4401 | 96 |
1549843 | 1549843 | 2021-07-24 | Washington | Texas | 48477 | 4401 | 96 |
1546596 | 1546596 | 2021-07-23 | Washington | Texas | 48477 | 4400 | 96 |
1543349 | 1543349 | 2021-07-22 | Washington | Texas | 48477 | 4390 | 96 |
1540101 | 1540101 | 2021-07-21 | Washington | Texas | 48477 | 4368 | 96 |
1536854 | 1536854 | 2021-07-20 | Washington | Texas | 48477 | 4358 | 96 |
1533606 | 1533606 | 2021-07-19 | Washington | Texas | 48477 | 4355 | 96 |
1530359 | 1530359 | 2021-07-18 | Washington | Texas | 48477 | 4354 | 96 |
1527112 | 1527112 | 2021-07-17 | Washington | Texas | 48477 | 4354 | 96 |
1523865 | 1523865 | 2021-07-16 | Washington | Texas | 48477 | 4350 | 96 |
1520617 | 1520617 | 2021-07-15 | Washington | Texas | 48477 | 4346 | 96 |
1517369 | 1517369 | 2021-07-14 | Washington | Texas | 48477 | 4343 | 96 |
1514122 | 1514122 | 2021-07-13 | Washington | Texas | 48477 | 4340 | 96 |
1510876 | 1510876 | 2021-07-12 | Washington | Texas | 48477 | 4332 | 96 |
1507629 | 1507629 | 2021-07-11 | Washington | Texas | 48477 | 4318 | 96 |
1504383 | 1504383 | 2021-07-10 | Washington | Texas | 48477 | 4318 | 96 |
1501137 | 1501137 | 2021-07-09 | Washington | Texas | 48477 | 4310 | 96 |
1497891 | 1497891 | 2021-07-08 | Washington | Texas | 48477 | 4306 | 96 |
1494644 | 1494644 | 2021-07-07 | Washington | Texas | 48477 | 4303 | 95 |
1491397 | 1491397 | 2021-07-06 | Washington | Texas | 48477 | 4297 | 95 |
1488150 | 1488150 | 2021-07-05 | Washington | Texas | 48477 | 4291 | 95 |
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);