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 |
---|---|---|---|---|---|---|---|
2110302 | 2110302 | 2022-01-13 | St. Tammany | Louisiana | 22103 | 55677 | 748 |
2107051 | 2107051 | 2022-01-12 | St. Tammany | Louisiana | 22103 | 55677 | 748 |
2103800 | 2103800 | 2022-01-11 | St. Tammany | Louisiana | 22103 | 55677 | 746 |
2100549 | 2100549 | 2022-01-10 | St. Tammany | Louisiana | 22103 | 54928 | 744 |
2097298 | 2097298 | 2022-01-09 | St. Tammany | Louisiana | 22103 | 52884 | 743 |
2094046 | 2094046 | 2022-01-08 | St. Tammany | Louisiana | 22103 | 52884 | 743 |
2090794 | 2090794 | 2022-01-07 | St. Tammany | Louisiana | 22103 | 52884 | 743 |
2087543 | 2087543 | 2022-01-06 | St. Tammany | Louisiana | 22103 | 52080 | 741 |
2084291 | 2084291 | 2022-01-05 | St. Tammany | Louisiana | 22103 | 51263 | 742 |
2081039 | 2081039 | 2022-01-04 | St. Tammany | Louisiana | 22103 | 50641 | 740 |
2077787 | 2077787 | 2022-01-03 | St. Tammany | Louisiana | 22103 | 50121 | 739 |
2074536 | 2074536 | 2022-01-02 | St. Tammany | Louisiana | 22103 | 47807 | 739 |
2071285 | 2071285 | 2022-01-01 | St. Tammany | Louisiana | 22103 | 47807 | 739 |
2068034 | 2068034 | 2021-12-31 | St. Tammany | Louisiana | 22103 | 47807 | 739 |
2064783 | 2064783 | 2021-12-30 | St. Tammany | Louisiana | 22103 | 47807 | 739 |
2061533 | 2061533 | 2021-12-29 | St. Tammany | Louisiana | 22103 | 47113 | 739 |
2058284 | 2058284 | 2021-12-28 | St. Tammany | Louisiana | 22103 | 46615 | 739 |
2055035 | 2055035 | 2021-12-27 | St. Tammany | Louisiana | 22103 | 46280 | 740 |
2051785 | 2051785 | 2021-12-26 | St. Tammany | Louisiana | 22103 | 45523 | 738 |
2048535 | 2048535 | 2021-12-25 | St. Tammany | Louisiana | 22103 | 45523 | 738 |
2045285 | 2045285 | 2021-12-24 | St. Tammany | Louisiana | 22103 | 45523 | 738 |
2042036 | 2042036 | 2021-12-23 | St. Tammany | Louisiana | 22103 | 45523 | 738 |
2038786 | 2038786 | 2021-12-22 | St. Tammany | Louisiana | 22103 | 45334 | 738 |
2035536 | 2035536 | 2021-12-21 | St. Tammany | Louisiana | 22103 | 45181 | 738 |
2032286 | 2032286 | 2021-12-20 | St. Tammany | Louisiana | 22103 | 45102 | 738 |
2029035 | 2029035 | 2021-12-19 | St. Tammany | Louisiana | 22103 | 44938 | 738 |
2025784 | 2025784 | 2021-12-18 | St. Tammany | Louisiana | 22103 | 44938 | 738 |
2022533 | 2022533 | 2021-12-17 | St. Tammany | Louisiana | 22103 | 44938 | 738 |
2019282 | 2019282 | 2021-12-16 | St. Tammany | Louisiana | 22103 | 44866 | 738 |
2016032 | 2016032 | 2021-12-15 | St. Tammany | Louisiana | 22103 | 44776 | 738 |
2012781 | 2012781 | 2021-12-14 | St. Tammany | Louisiana | 22103 | 44725 | 738 |
2009530 | 2009530 | 2021-12-13 | St. Tammany | Louisiana | 22103 | 44687 | 738 |
2006279 | 2006279 | 2021-12-12 | St. Tammany | Louisiana | 22103 | 44620 | 738 |
2003028 | 2003028 | 2021-12-11 | St. Tammany | Louisiana | 22103 | 44620 | 738 |
1999778 | 1999778 | 2021-12-10 | St. Tammany | Louisiana | 22103 | 44620 | 738 |
1996527 | 1996527 | 2021-12-09 | St. Tammany | Louisiana | 22103 | 44599 | 737 |
1993276 | 1993276 | 2021-12-08 | St. Tammany | Louisiana | 22103 | 44565 | 737 |
1990025 | 1990025 | 2021-12-07 | St. Tammany | Louisiana | 22103 | 44525 | 736 |
1986775 | 1986775 | 2021-12-06 | St. Tammany | Louisiana | 22103 | 44488 | 736 |
1983525 | 1983525 | 2021-12-05 | St. Tammany | Louisiana | 22103 | 44437 | 736 |
1980275 | 1980275 | 2021-12-04 | St. Tammany | Louisiana | 22103 | 44437 | 736 |
1977025 | 1977025 | 2021-12-03 | St. Tammany | Louisiana | 22103 | 44437 | 736 |
1973776 | 1973776 | 2021-12-02 | St. Tammany | Louisiana | 22103 | 44408 | 735 |
1970526 | 1970526 | 2021-12-01 | St. Tammany | Louisiana | 22103 | 44372 | 735 |
1967276 | 1967276 | 2021-11-30 | St. Tammany | Louisiana | 22103 | 44307 | 735 |
1964024 | 1964024 | 2021-11-29 | St. Tammany | Louisiana | 22103 | 44242 | 734 |
1960773 | 1960773 | 2021-11-28 | St. Tammany | Louisiana | 22103 | 44165 | 733 |
1957522 | 1957522 | 2021-11-27 | St. Tammany | Louisiana | 22103 | 44165 | 733 |
1954271 | 1954271 | 2021-11-26 | St. Tammany | Louisiana | 22103 | 44165 | 733 |
1951020 | 1951020 | 2021-11-25 | St. Tammany | Louisiana | 22103 | 44165 | 733 |
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 |
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);