ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Assumption" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110254 | 2110254 | 2022-01-13 | Assumption | Louisiana | 22007 | 4427 | 57 |
2107003 | 2107003 | 2022-01-12 | Assumption | Louisiana | 22007 | 4427 | 57 |
2103752 | 2103752 | 2022-01-11 | Assumption | Louisiana | 22007 | 4427 | 57 |
2100501 | 2100501 | 2022-01-10 | Assumption | Louisiana | 22007 | 4391 | 57 |
2097250 | 2097250 | 2022-01-09 | Assumption | Louisiana | 22007 | 4282 | 57 |
2093998 | 2093998 | 2022-01-08 | Assumption | Louisiana | 22007 | 4282 | 57 |
2090746 | 2090746 | 2022-01-07 | Assumption | Louisiana | 22007 | 4282 | 57 |
2087495 | 2087495 | 2022-01-06 | Assumption | Louisiana | 22007 | 4229 | 57 |
2084243 | 2084243 | 2022-01-05 | Assumption | Louisiana | 22007 | 4149 | 57 |
2080991 | 2080991 | 2022-01-04 | Assumption | Louisiana | 22007 | 4092 | 57 |
2077739 | 2077739 | 2022-01-03 | Assumption | Louisiana | 22007 | 4050 | 57 |
2074488 | 2074488 | 2022-01-02 | Assumption | Louisiana | 22007 | 3927 | 57 |
2071237 | 2071237 | 2022-01-01 | Assumption | Louisiana | 22007 | 3927 | 57 |
2067986 | 2067986 | 2021-12-31 | Assumption | Louisiana | 22007 | 3927 | 57 |
2064735 | 2064735 | 2021-12-30 | Assumption | Louisiana | 22007 | 3927 | 57 |
2061485 | 2061485 | 2021-12-29 | Assumption | Louisiana | 22007 | 3872 | 57 |
2058236 | 2058236 | 2021-12-28 | Assumption | Louisiana | 22007 | 3818 | 57 |
2054987 | 2054987 | 2021-12-27 | Assumption | Louisiana | 22007 | 3795 | 57 |
2051737 | 2051737 | 2021-12-26 | Assumption | Louisiana | 22007 | 3757 | 57 |
2048487 | 2048487 | 2021-12-25 | Assumption | Louisiana | 22007 | 3757 | 57 |
2045237 | 2045237 | 2021-12-24 | Assumption | Louisiana | 22007 | 3757 | 57 |
2041988 | 2041988 | 2021-12-23 | Assumption | Louisiana | 22007 | 3757 | 57 |
2038738 | 2038738 | 2021-12-22 | Assumption | Louisiana | 22007 | 3740 | 57 |
2035488 | 2035488 | 2021-12-21 | Assumption | Louisiana | 22007 | 3734 | 57 |
2032238 | 2032238 | 2021-12-20 | Assumption | Louisiana | 22007 | 3734 | 57 |
2028987 | 2028987 | 2021-12-19 | Assumption | Louisiana | 22007 | 3718 | 57 |
2025736 | 2025736 | 2021-12-18 | Assumption | Louisiana | 22007 | 3718 | 57 |
2022485 | 2022485 | 2021-12-17 | Assumption | Louisiana | 22007 | 3718 | 57 |
2019234 | 2019234 | 2021-12-16 | Assumption | Louisiana | 22007 | 3714 | 57 |
2015984 | 2015984 | 2021-12-15 | Assumption | Louisiana | 22007 | 3712 | 57 |
2012733 | 2012733 | 2021-12-14 | Assumption | Louisiana | 22007 | 3711 | 57 |
2009482 | 2009482 | 2021-12-13 | Assumption | Louisiana | 22007 | 3711 | 57 |
2006231 | 2006231 | 2021-12-12 | Assumption | Louisiana | 22007 | 3705 | 57 |
2002980 | 2002980 | 2021-12-11 | Assumption | Louisiana | 22007 | 3705 | 57 |
1999730 | 1999730 | 2021-12-10 | Assumption | Louisiana | 22007 | 3705 | 57 |
1996479 | 1996479 | 2021-12-09 | Assumption | Louisiana | 22007 | 3704 | 57 |
1993228 | 1993228 | 2021-12-08 | Assumption | Louisiana | 22007 | 3703 | 57 |
1989977 | 1989977 | 2021-12-07 | Assumption | Louisiana | 22007 | 3703 | 57 |
1986727 | 1986727 | 2021-12-06 | Assumption | Louisiana | 22007 | 3702 | 57 |
1983477 | 1983477 | 2021-12-05 | Assumption | Louisiana | 22007 | 3702 | 57 |
1980227 | 1980227 | 2021-12-04 | Assumption | Louisiana | 22007 | 3702 | 57 |
1976977 | 1976977 | 2021-12-03 | Assumption | Louisiana | 22007 | 3702 | 57 |
1973728 | 1973728 | 2021-12-02 | Assumption | Louisiana | 22007 | 3702 | 57 |
1970478 | 1970478 | 2021-12-01 | Assumption | Louisiana | 22007 | 3702 | 57 |
1967228 | 1967228 | 2021-11-30 | Assumption | Louisiana | 22007 | 3702 | 57 |
1963976 | 1963976 | 2021-11-29 | Assumption | Louisiana | 22007 | 3702 | 57 |
1960725 | 1960725 | 2021-11-28 | Assumption | Louisiana | 22007 | 3698 | 57 |
1957474 | 1957474 | 2021-11-27 | Assumption | Louisiana | 22007 | 3698 | 57 |
1954223 | 1954223 | 2021-11-26 | Assumption | Louisiana | 22007 | 3698 | 57 |
1950972 | 1950972 | 2021-11-25 | Assumption | Louisiana | 22007 | 3698 | 57 |
1947721 | 1947721 | 2021-11-24 | Assumption | Louisiana | 22007 | 3698 | 57 |
1944470 | 1944470 | 2021-11-23 | Assumption | Louisiana | 22007 | 3698 | 57 |
1941220 | 1941220 | 2021-11-22 | Assumption | Louisiana | 22007 | 3695 | 57 |
1937970 | 1937970 | 2021-11-21 | Assumption | Louisiana | 22007 | 3689 | 57 |
1934720 | 1934720 | 2021-11-20 | Assumption | Louisiana | 22007 | 3689 | 57 |
1931469 | 1931469 | 2021-11-19 | Assumption | Louisiana | 22007 | 3689 | 57 |
1928218 | 1928218 | 2021-11-18 | Assumption | Louisiana | 22007 | 3686 | 57 |
1924968 | 1924968 | 2021-11-17 | Assumption | Louisiana | 22007 | 3686 | 57 |
1921719 | 1921719 | 2021-11-16 | Assumption | Louisiana | 22007 | 3682 | 57 |
1918469 | 1918469 | 2021-11-15 | Assumption | Louisiana | 22007 | 3680 | 57 |
1915219 | 1915219 | 2021-11-14 | Assumption | Louisiana | 22007 | 3677 | 57 |
1911969 | 1911969 | 2021-11-13 | Assumption | Louisiana | 22007 | 3677 | 57 |
1908720 | 1908720 | 2021-11-12 | Assumption | Louisiana | 22007 | 3677 | 57 |
1905471 | 1905471 | 2021-11-11 | Assumption | Louisiana | 22007 | 3670 | 57 |
1902221 | 1902221 | 2021-11-10 | Assumption | Louisiana | 22007 | 3670 | 57 |
1898971 | 1898971 | 2021-11-09 | Assumption | Louisiana | 22007 | 3670 | 57 |
1895721 | 1895721 | 2021-11-08 | Assumption | Louisiana | 22007 | 3670 | 57 |
1892471 | 1892471 | 2021-11-07 | Assumption | Louisiana | 22007 | 3664 | 57 |
1889221 | 1889221 | 2021-11-06 | Assumption | Louisiana | 22007 | 3664 | 57 |
1885971 | 1885971 | 2021-11-05 | Assumption | Louisiana | 22007 | 3664 | 57 |
1882722 | 1882722 | 2021-11-04 | Assumption | Louisiana | 22007 | 3664 | 56 |
1879473 | 1879473 | 2021-11-03 | Assumption | Louisiana | 22007 | 3663 | 56 |
1876224 | 1876224 | 2021-11-02 | Assumption | Louisiana | 22007 | 3661 | 56 |
1872975 | 1872975 | 2021-11-01 | Assumption | Louisiana | 22007 | 3660 | 56 |
1869726 | 1869726 | 2021-10-31 | Assumption | Louisiana | 22007 | 3655 | 56 |
1866477 | 1866477 | 2021-10-30 | Assumption | Louisiana | 22007 | 3655 | 56 |
1863228 | 1863228 | 2021-10-29 | Assumption | Louisiana | 22007 | 3655 | 56 |
1859979 | 1859979 | 2021-10-28 | Assumption | Louisiana | 22007 | 3654 | 56 |
1856730 | 1856730 | 2021-10-27 | Assumption | Louisiana | 22007 | 3652 | 56 |
1853481 | 1853481 | 2021-10-26 | Assumption | Louisiana | 22007 | 3649 | 56 |
1850232 | 1850232 | 2021-10-25 | Assumption | Louisiana | 22007 | 3648 | 56 |
1846982 | 1846982 | 2021-10-24 | Assumption | Louisiana | 22007 | 3643 | 56 |
1843732 | 1843732 | 2021-10-23 | Assumption | Louisiana | 22007 | 3643 | 56 |
1840482 | 1840482 | 2021-10-22 | Assumption | Louisiana | 22007 | 3643 | 56 |
1837233 | 1837233 | 2021-10-21 | Assumption | Louisiana | 22007 | 3640 | 57 |
1833984 | 1833984 | 2021-10-20 | Assumption | Louisiana | 22007 | 3637 | 57 |
1830735 | 1830735 | 2021-10-19 | Assumption | Louisiana | 22007 | 3634 | 57 |
1827486 | 1827486 | 2021-10-18 | Assumption | Louisiana | 22007 | 3633 | 57 |
1824237 | 1824237 | 2021-10-17 | Assumption | Louisiana | 22007 | 3619 | 57 |
1820988 | 1820988 | 2021-10-16 | Assumption | Louisiana | 22007 | 3619 | 57 |
1817739 | 1817739 | 2021-10-15 | Assumption | Louisiana | 22007 | 3619 | 57 |
1814491 | 1814491 | 2021-10-14 | Assumption | Louisiana | 22007 | 3615 | 57 |
1811242 | 1811242 | 2021-10-13 | Assumption | Louisiana | 22007 | 3610 | 57 |
1807993 | 1807993 | 2021-10-12 | Assumption | Louisiana | 22007 | 3608 | 57 |
1804742 | 1804742 | 2021-10-11 | Assumption | Louisiana | 22007 | 3603 | 57 |
1801493 | 1801493 | 2021-10-10 | Assumption | Louisiana | 22007 | 3584 | 57 |
1798244 | 1798244 | 2021-10-09 | Assumption | Louisiana | 22007 | 3584 | 57 |
1794995 | 1794995 | 2021-10-08 | Assumption | Louisiana | 22007 | 3584 | 57 |
1791747 | 1791747 | 2021-10-07 | Assumption | Louisiana | 22007 | 3576 | 57 |
1788498 | 1788498 | 2021-10-06 | Assumption | Louisiana | 22007 | 3570 | 57 |
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);