ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Unknown", fips = "" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175373 | 2175373 | 2022-02-02 | Unknown | Louisiana | 953 | 0 | |
2172120 | 2172120 | 2022-02-01 | Unknown | Louisiana | 953 | 0 | |
2168867 | 2168867 | 2022-01-31 | Unknown | Louisiana | 951 | 0 | |
2165612 | 2165612 | 2022-01-30 | Unknown | Louisiana | 946 | 0 | |
2162357 | 2162357 | 2022-01-29 | Unknown | Louisiana | 946 | 0 | |
2159102 | 2159102 | 2022-01-28 | Unknown | Louisiana | 946 | 0 | |
2155848 | 2155848 | 2022-01-27 | Unknown | Louisiana | 945 | 0 | |
2152595 | 2152595 | 2022-01-26 | Unknown | Louisiana | 935 | 0 | |
2149343 | 2149343 | 2022-01-25 | Unknown | Louisiana | 884 | 0 | |
2146091 | 2146091 | 2022-01-24 | Unknown | Louisiana | 882 | 0 | |
2142836 | 2142836 | 2022-01-23 | Unknown | Louisiana | 869 | 0 | |
2139581 | 2139581 | 2022-01-22 | Unknown | Louisiana | 869 | 0 | |
2136325 | 2136325 | 2022-01-21 | Unknown | Louisiana | 869 | 0 | |
2133073 | 2133073 | 2022-01-20 | Unknown | Louisiana | 861 | 0 | |
2129820 | 2129820 | 2022-01-19 | Unknown | Louisiana | 850 | 0 | |
2126566 | 2126566 | 2022-01-18 | Unknown | Louisiana | 824 | 0 | |
2123314 | 2123314 | 2022-01-17 | Unknown | Louisiana | 799 | 0 | |
2120062 | 2120062 | 2022-01-16 | Unknown | Louisiana | 799 | 0 | |
2116810 | 2116810 | 2022-01-15 | Unknown | Louisiana | 799 | 0 | |
2113559 | 2113559 | 2022-01-14 | Unknown | Louisiana | 799 | 0 | |
2110307 | 2110307 | 2022-01-13 | Unknown | Louisiana | 33238 | 0 | |
2107056 | 2107056 | 2022-01-12 | Unknown | Louisiana | 18306 | 0 | |
2103805 | 2103805 | 2022-01-11 | Unknown | Louisiana | 714 | 0 | |
2100554 | 2100554 | 2022-01-10 | Unknown | Louisiana | 706 | 0 | |
2097303 | 2097303 | 2022-01-09 | Unknown | Louisiana | 691 | 0 | |
2094051 | 2094051 | 2022-01-08 | Unknown | Louisiana | 691 | 0 | |
2090799 | 2090799 | 2022-01-07 | Unknown | Louisiana | 691 | 0 | |
2087548 | 2087548 | 2022-01-06 | Unknown | Louisiana | 666 | 0 | |
2084296 | 2084296 | 2022-01-05 | Unknown | Louisiana | 661 | 0 | |
2081044 | 2081044 | 2022-01-04 | Unknown | Louisiana | 653 | 0 | |
2077792 | 2077792 | 2022-01-03 | Unknown | Louisiana | 634 | 0 | |
2074541 | 2074541 | 2022-01-02 | Unknown | Louisiana | 617 | 0 | |
2071290 | 2071290 | 2022-01-01 | Unknown | Louisiana | 617 | 0 | |
2068039 | 2068039 | 2021-12-31 | Unknown | Louisiana | 617 | 0 | |
2064788 | 2064788 | 2021-12-30 | Unknown | Louisiana | 617 | 0 | |
2061538 | 2061538 | 2021-12-29 | Unknown | Louisiana | 608 | 0 | |
2058289 | 2058289 | 2021-12-28 | Unknown | Louisiana | 596 | 0 | |
2055040 | 2055040 | 2021-12-27 | Unknown | Louisiana | 592 | 0 | |
2051790 | 2051790 | 2021-12-26 | Unknown | Louisiana | 591 | 0 | |
2048540 | 2048540 | 2021-12-25 | Unknown | Louisiana | 591 | 0 | |
2045290 | 2045290 | 2021-12-24 | Unknown | Louisiana | 591 | 0 | |
2042041 | 2042041 | 2021-12-23 | Unknown | Louisiana | 591 | 0 | |
2038791 | 2038791 | 2021-12-22 | Unknown | Louisiana | 590 | 0 | |
2035541 | 2035541 | 2021-12-21 | Unknown | Louisiana | 589 | 0 | |
2032291 | 2032291 | 2021-12-20 | Unknown | Louisiana | 589 | 0 | |
2029040 | 2029040 | 2021-12-19 | Unknown | Louisiana | 589 | 0 | |
2025789 | 2025789 | 2021-12-18 | Unknown | Louisiana | 589 | 0 | |
2022538 | 2022538 | 2021-12-17 | Unknown | Louisiana | 589 | 0 | |
2019287 | 2019287 | 2021-12-16 | Unknown | Louisiana | 589 | 0 | |
2016037 | 2016037 | 2021-12-15 | Unknown | Louisiana | 589 | 0 | |
2012786 | 2012786 | 2021-12-14 | Unknown | Louisiana | 589 | 0 | |
2009535 | 2009535 | 2021-12-13 | Unknown | Louisiana | 589 | 0 | |
2006284 | 2006284 | 2021-12-12 | Unknown | Louisiana | 587 | 0 | |
2003033 | 2003033 | 2021-12-11 | Unknown | Louisiana | 587 | 0 | |
1999783 | 1999783 | 2021-12-10 | Unknown | Louisiana | 587 | 0 | |
1996532 | 1996532 | 2021-12-09 | Unknown | Louisiana | 587 | 0 | |
1993281 | 1993281 | 2021-12-08 | Unknown | Louisiana | 587 | 0 | |
1990030 | 1990030 | 2021-12-07 | Unknown | Louisiana | 587 | 0 | |
1986780 | 1986780 | 2021-12-06 | Unknown | Louisiana | 590 | 0 | |
1983530 | 1983530 | 2021-12-05 | Unknown | Louisiana | 588 | 0 | |
1980280 | 1980280 | 2021-12-04 | Unknown | Louisiana | 588 | 0 | |
1977030 | 1977030 | 2021-12-03 | Unknown | Louisiana | 588 | 0 | |
1973781 | 1973781 | 2021-12-02 | Unknown | Louisiana | 588 | 0 | |
1970531 | 1970531 | 2021-12-01 | Unknown | Louisiana | 586 | 0 | |
1967281 | 1967281 | 2021-11-30 | Unknown | Louisiana | 585 | 0 | |
1964029 | 1964029 | 2021-11-29 | Unknown | Louisiana | 585 | 0 | |
1960778 | 1960778 | 2021-11-28 | Unknown | Louisiana | 584 | 0 | |
1957527 | 1957527 | 2021-11-27 | Unknown | Louisiana | 584 | 0 | |
1954276 | 1954276 | 2021-11-26 | Unknown | Louisiana | 584 | 0 | |
1951025 | 1951025 | 2021-11-25 | Unknown | Louisiana | 584 | 0 | |
1947774 | 1947774 | 2021-11-24 | Unknown | Louisiana | 584 | 0 | |
1944523 | 1944523 | 2021-11-23 | Unknown | Louisiana | 583 | 0 | |
1941273 | 1941273 | 2021-11-22 | Unknown | Louisiana | 583 | 0 | |
1938023 | 1938023 | 2021-11-21 | Unknown | Louisiana | 582 | 0 | |
1934773 | 1934773 | 2021-11-20 | Unknown | Louisiana | 582 | 0 | |
1931522 | 1931522 | 2021-11-19 | Unknown | Louisiana | 582 | 0 | |
1928271 | 1928271 | 2021-11-18 | Unknown | Louisiana | 582 | 0 | |
1925021 | 1925021 | 2021-11-17 | Unknown | Louisiana | 582 | 0 | |
1921772 | 1921772 | 2021-11-16 | Unknown | Louisiana | 582 | 0 | |
1918522 | 1918522 | 2021-11-15 | Unknown | Louisiana | 582 | 0 | |
1915272 | 1915272 | 2021-11-14 | Unknown | Louisiana | 582 | 0 | |
1912022 | 1912022 | 2021-11-13 | Unknown | Louisiana | 582 | 0 | |
1908773 | 1908773 | 2021-11-12 | Unknown | Louisiana | 582 | 0 | |
1905524 | 1905524 | 2021-11-11 | Unknown | Louisiana | 581 | 0 | |
1902274 | 1902274 | 2021-11-10 | Unknown | Louisiana | 581 | 0 | |
1899024 | 1899024 | 2021-11-09 | Unknown | Louisiana | 581 | 0 | |
1895774 | 1895774 | 2021-11-08 | Unknown | Louisiana | 581 | 0 | |
1892524 | 1892524 | 2021-11-07 | Unknown | Louisiana | 580 | 0 | |
1889274 | 1889274 | 2021-11-06 | Unknown | Louisiana | 580 | 0 | |
1886024 | 1886024 | 2021-11-05 | Unknown | Louisiana | 580 | 0 | |
1882775 | 1882775 | 2021-11-04 | Unknown | Louisiana | 580 | 0 | |
1879526 | 1879526 | 2021-11-03 | Unknown | Louisiana | 579 | 0 | |
1876277 | 1876277 | 2021-11-02 | Unknown | Louisiana | 579 | 0 | |
1873028 | 1873028 | 2021-11-01 | Unknown | Louisiana | 579 | 0 | |
1869779 | 1869779 | 2021-10-31 | Unknown | Louisiana | 578 | 0 | |
1866530 | 1866530 | 2021-10-30 | Unknown | Louisiana | 578 | 0 | |
1863281 | 1863281 | 2021-10-29 | Unknown | Louisiana | 578 | 0 | |
1860032 | 1860032 | 2021-10-28 | Unknown | Louisiana | 578 | 0 | |
1856783 | 1856783 | 2021-10-27 | Unknown | Louisiana | 578 | 0 | |
1853534 | 1853534 | 2021-10-26 | Unknown | Louisiana | 577 | 0 |
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);