ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "St. Tammany" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947769 | 1947769 | 2021-11-24 | St. Tammany | Louisiana | 22103 | 44165 | 733 |
1944518 | 1944518 | 2021-11-23 | St. Tammany | Louisiana | 22103 | 44141 | 733 |
1941268 | 1941268 | 2021-11-22 | St. Tammany | Louisiana | 22103 | 44114 | 733 |
1938018 | 1938018 | 2021-11-21 | St. Tammany | Louisiana | 22103 | 44074 | 733 |
1934768 | 1934768 | 2021-11-20 | St. Tammany | Louisiana | 22103 | 44074 | 733 |
1931517 | 1931517 | 2021-11-19 | St. Tammany | Louisiana | 22103 | 44074 | 733 |
1928266 | 1928266 | 2021-11-18 | St. Tammany | Louisiana | 22103 | 44049 | 732 |
1925016 | 1925016 | 2021-11-17 | St. Tammany | Louisiana | 22103 | 44026 | 731 |
1921767 | 1921767 | 2021-11-16 | St. Tammany | Louisiana | 22103 | 44003 | 731 |
1918517 | 1918517 | 2021-11-15 | St. Tammany | Louisiana | 22103 | 43973 | 731 |
1915267 | 1915267 | 2021-11-14 | St. Tammany | Louisiana | 22103 | 43919 | 730 |
1912017 | 1912017 | 2021-11-13 | St. Tammany | Louisiana | 22103 | 43919 | 730 |
1908768 | 1908768 | 2021-11-12 | St. Tammany | Louisiana | 22103 | 43919 | 730 |
1905519 | 1905519 | 2021-11-11 | St. Tammany | Louisiana | 22103 | 43870 | 730 |
1902269 | 1902269 | 2021-11-10 | St. Tammany | Louisiana | 22103 | 43870 | 730 |
1899019 | 1899019 | 2021-11-09 | St. Tammany | Louisiana | 22103 | 43840 | 729 |
1895769 | 1895769 | 2021-11-08 | St. Tammany | Louisiana | 22103 | 43810 | 728 |
1892519 | 1892519 | 2021-11-07 | St. Tammany | Louisiana | 22103 | 43762 | 727 |
1889269 | 1889269 | 2021-11-06 | St. Tammany | Louisiana | 22103 | 43762 | 727 |
1886019 | 1886019 | 2021-11-05 | St. Tammany | Louisiana | 22103 | 43762 | 727 |
1882770 | 1882770 | 2021-11-04 | St. Tammany | Louisiana | 22103 | 43739 | 726 |
1879521 | 1879521 | 2021-11-03 | St. Tammany | Louisiana | 22103 | 43703 | 725 |
1876272 | 1876272 | 2021-11-02 | St. Tammany | Louisiana | 22103 | 43661 | 724 |
1873023 | 1873023 | 2021-11-01 | St. Tammany | Louisiana | 22103 | 43642 | 724 |
1869774 | 1869774 | 2021-10-31 | St. Tammany | Louisiana | 22103 | 43568 | 724 |
1866525 | 1866525 | 2021-10-30 | St. Tammany | Louisiana | 22103 | 43568 | 724 |
1863276 | 1863276 | 2021-10-29 | St. Tammany | Louisiana | 22103 | 43568 | 724 |
1860027 | 1860027 | 2021-10-28 | St. Tammany | Louisiana | 22103 | 43557 | 723 |
1856778 | 1856778 | 2021-10-27 | St. Tammany | Louisiana | 22103 | 43523 | 721 |
1853529 | 1853529 | 2021-10-26 | St. Tammany | Louisiana | 22103 | 43485 | 720 |
1850280 | 1850280 | 2021-10-25 | St. Tammany | Louisiana | 22103 | 43462 | 720 |
1847030 | 1847030 | 2021-10-24 | St. Tammany | Louisiana | 22103 | 43411 | 716 |
1843780 | 1843780 | 2021-10-23 | St. Tammany | Louisiana | 22103 | 43411 | 716 |
1840530 | 1840530 | 2021-10-22 | St. Tammany | Louisiana | 22103 | 43411 | 716 |
1837281 | 1837281 | 2021-10-21 | St. Tammany | Louisiana | 22103 | 43370 | 715 |
1834032 | 1834032 | 2021-10-20 | St. Tammany | Louisiana | 22103 | 43342 | 715 |
1830783 | 1830783 | 2021-10-19 | St. Tammany | Louisiana | 22103 | 43315 | 713 |
1827534 | 1827534 | 2021-10-18 | St. Tammany | Louisiana | 22103 | 43296 | 712 |
1824285 | 1824285 | 2021-10-17 | St. Tammany | Louisiana | 22103 | 43240 | 710 |
1821036 | 1821036 | 2021-10-16 | St. Tammany | Louisiana | 22103 | 43240 | 710 |
1817787 | 1817787 | 2021-10-15 | St. Tammany | Louisiana | 22103 | 43240 | 710 |
1814539 | 1814539 | 2021-10-14 | St. Tammany | Louisiana | 22103 | 43200 | 709 |
1811290 | 1811290 | 2021-10-13 | St. Tammany | Louisiana | 22103 | 43151 | 707 |
1808041 | 1808041 | 2021-10-12 | St. Tammany | Louisiana | 22103 | 43122 | 704 |
1804790 | 1804790 | 2021-10-11 | St. Tammany | Louisiana | 22103 | 43076 | 703 |
1801541 | 1801541 | 2021-10-10 | St. Tammany | Louisiana | 22103 | 42999 | 703 |
1798292 | 1798292 | 2021-10-09 | St. Tammany | Louisiana | 22103 | 42999 | 703 |
1795043 | 1795043 | 2021-10-08 | St. Tammany | Louisiana | 22103 | 42999 | 703 |
1791795 | 1791795 | 2021-10-07 | St. Tammany | Louisiana | 22103 | 42958 | 701 |
1788546 | 1788546 | 2021-10-06 | St. Tammany | Louisiana | 22103 | 42897 | 700 |
1785297 | 1785297 | 2021-10-05 | St. Tammany | Louisiana | 22103 | 42833 | 694 |
1782048 | 1782048 | 2021-10-04 | St. Tammany | Louisiana | 22103 | 42795 | 692 |
1778798 | 1778798 | 2021-10-03 | St. Tammany | Louisiana | 22103 | 42685 | 690 |
1775548 | 1775548 | 2021-10-02 | St. Tammany | Louisiana | 22103 | 42685 | 690 |
1772298 | 1772298 | 2021-10-01 | St. Tammany | Louisiana | 22103 | 42685 | 690 |
1769049 | 1769049 | 2021-09-30 | St. Tammany | Louisiana | 22103 | 42595 | 686 |
1765800 | 1765800 | 2021-09-29 | St. Tammany | Louisiana | 22103 | 42550 | 686 |
1762551 | 1762551 | 2021-09-28 | St. Tammany | Louisiana | 22103 | 42470 | 683 |
1759303 | 1759303 | 2021-09-27 | St. Tammany | Louisiana | 22103 | 42433 | 680 |
1756055 | 1756055 | 2021-09-26 | St. Tammany | Louisiana | 22103 | 42301 | 677 |
1752807 | 1752807 | 2021-09-25 | St. Tammany | Louisiana | 22103 | 42301 | 677 |
1749558 | 1749558 | 2021-09-24 | St. Tammany | Louisiana | 22103 | 42301 | 677 |
1746308 | 1746308 | 2021-09-23 | St. Tammany | Louisiana | 22103 | 42244 | 675 |
1743059 | 1743059 | 2021-09-22 | St. Tammany | Louisiana | 22103 | 42162 | 672 |
1739810 | 1739810 | 2021-09-21 | St. Tammany | Louisiana | 22103 | 42019 | 662 |
1736561 | 1736561 | 2021-09-20 | St. Tammany | Louisiana | 22103 | 41946 | 662 |
1733311 | 1733311 | 2021-09-19 | St. Tammany | Louisiana | 22103 | 41787 | 661 |
1730061 | 1730061 | 2021-09-18 | St. Tammany | Louisiana | 22103 | 41787 | 661 |
1726811 | 1726811 | 2021-09-17 | St. Tammany | Louisiana | 22103 | 41787 | 661 |
1723562 | 1723562 | 2021-09-16 | St. Tammany | Louisiana | 22103 | 41687 | 658 |
1720313 | 1720313 | 2021-09-15 | St. Tammany | Louisiana | 22103 | 41594 | 655 |
1717065 | 1717065 | 2021-09-14 | St. Tammany | Louisiana | 22103 | 41470 | 645 |
1713819 | 1713819 | 2021-09-13 | St. Tammany | Louisiana | 22103 | 41389 | 644 |
1710572 | 1710572 | 2021-09-12 | St. Tammany | Louisiana | 22103 | 41120 | 644 |
1707325 | 1707325 | 2021-09-11 | St. Tammany | Louisiana | 22103 | 41120 | 644 |
1704077 | 1704077 | 2021-09-10 | St. Tammany | Louisiana | 22103 | 41120 | 644 |
1700827 | 1700827 | 2021-09-09 | St. Tammany | Louisiana | 22103 | 40968 | 644 |
1697578 | 1697578 | 2021-09-08 | St. Tammany | Louisiana | 22103 | 40853 | 636 |
1694330 | 1694330 | 2021-09-07 | St. Tammany | Louisiana | 22103 | 40740 | 636 |
1691081 | 1691081 | 2021-09-06 | St. Tammany | Louisiana | 22103 | 40391 | 626 |
1687831 | 1687831 | 2021-09-05 | St. Tammany | Louisiana | 22103 | 40391 | 626 |
1684581 | 1684581 | 2021-09-04 | St. Tammany | Louisiana | 22103 | 40391 | 626 |
1681330 | 1681330 | 2021-09-03 | St. Tammany | Louisiana | 22103 | 40391 | 626 |
1678082 | 1678082 | 2021-09-02 | St. Tammany | Louisiana | 22103 | 40332 | 622 |
1674835 | 1674835 | 2021-09-01 | St. Tammany | Louisiana | 22103 | 40298 | 614 |
1671586 | 1671586 | 2021-08-31 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1668339 | 1668339 | 2021-08-30 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1665092 | 1665092 | 2021-08-29 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1661844 | 1661844 | 2021-08-28 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1658596 | 1658596 | 2021-08-27 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1655348 | 1655348 | 2021-08-26 | St. Tammany | Louisiana | 22103 | 39541 | 602 |
1652101 | 1652101 | 2021-08-25 | St. Tammany | Louisiana | 22103 | 39229 | 600 |
1648852 | 1648852 | 2021-08-24 | St. Tammany | Louisiana | 22103 | 38863 | 594 |
1645604 | 1645604 | 2021-08-23 | St. Tammany | Louisiana | 22103 | 38626 | 589 |
1642355 | 1642355 | 2021-08-22 | St. Tammany | Louisiana | 22103 | 37854 | 586 |
1639105 | 1639105 | 2021-08-21 | St. Tammany | Louisiana | 22103 | 37854 | 586 |
1635855 | 1635855 | 2021-08-20 | St. Tammany | Louisiana | 22103 | 37854 | 586 |
1632605 | 1632605 | 2021-08-19 | St. Tammany | Louisiana | 22103 | 37472 | 586 |
1629358 | 1629358 | 2021-08-18 | St. Tammany | Louisiana | 22103 | 37128 | 586 |
1626111 | 1626111 | 2021-08-17 | St. Tammany | Louisiana | 22103 | 36760 | 582 |
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);