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 |
---|---|---|---|---|---|---|---|
2175368 | 2175368 | 2022-02-02 | St. Tammany | Louisiana | 22103 | 69464 | 777 |
2172115 | 2172115 | 2022-02-01 | St. Tammany | Louisiana | 22103 | 69181 | 775 |
2168862 | 2168862 | 2022-01-31 | St. Tammany | Louisiana | 22103 | 68876 | 771 |
2165607 | 2165607 | 2022-01-30 | St. Tammany | Louisiana | 22103 | 68247 | 770 |
2162352 | 2162352 | 2022-01-29 | St. Tammany | Louisiana | 22103 | 68247 | 770 |
2159097 | 2159097 | 2022-01-28 | St. Tammany | Louisiana | 22103 | 68247 | 770 |
2155843 | 2155843 | 2022-01-27 | St. Tammany | Louisiana | 22103 | 67849 | 769 |
2152590 | 2152590 | 2022-01-26 | St. Tammany | Louisiana | 22103 | 67414 | 768 |
2149338 | 2149338 | 2022-01-25 | St. Tammany | Louisiana | 22103 | 63760 | 765 |
2146086 | 2146086 | 2022-01-24 | St. Tammany | Louisiana | 22103 | 63365 | 761 |
2142831 | 2142831 | 2022-01-23 | St. Tammany | Louisiana | 22103 | 62352 | 757 |
2139576 | 2139576 | 2022-01-22 | St. Tammany | Louisiana | 22103 | 62352 | 757 |
2136320 | 2136320 | 2022-01-21 | St. Tammany | Louisiana | 22103 | 62352 | 757 |
2133068 | 2133068 | 2022-01-20 | St. Tammany | Louisiana | 22103 | 61598 | 755 |
2129815 | 2129815 | 2022-01-19 | St. Tammany | Louisiana | 22103 | 60848 | 751 |
2126561 | 2126561 | 2022-01-18 | St. Tammany | Louisiana | 22103 | 60141 | 751 |
2123309 | 2123309 | 2022-01-17 | St. Tammany | Louisiana | 22103 | 58119 | 748 |
2120057 | 2120057 | 2022-01-16 | St. Tammany | Louisiana | 22103 | 58119 | 748 |
2116805 | 2116805 | 2022-01-15 | St. Tammany | Louisiana | 22103 | 58119 | 748 |
2113554 | 2113554 | 2022-01-14 | St. Tammany | Louisiana | 22103 | 58119 | 748 |
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 |
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);