ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 22091 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175362 | 2175362 | 2022-02-02 | St. Helena | Louisiana | 22091 | 1821 | 21 |
2172109 | 2172109 | 2022-02-01 | St. Helena | Louisiana | 22091 | 1816 | 21 |
2168856 | 2168856 | 2022-01-31 | St. Helena | Louisiana | 22091 | 1813 | 21 |
2165601 | 2165601 | 2022-01-30 | St. Helena | Louisiana | 22091 | 1801 | 21 |
2162346 | 2162346 | 2022-01-29 | St. Helena | Louisiana | 22091 | 1801 | 21 |
2159091 | 2159091 | 2022-01-28 | St. Helena | Louisiana | 22091 | 1801 | 21 |
2155837 | 2155837 | 2022-01-27 | St. Helena | Louisiana | 22091 | 1797 | 21 |
2152584 | 2152584 | 2022-01-26 | St. Helena | Louisiana | 22091 | 1764 | 21 |
2149332 | 2149332 | 2022-01-25 | St. Helena | Louisiana | 22091 | 1685 | 21 |
2146080 | 2146080 | 2022-01-24 | St. Helena | Louisiana | 22091 | 1677 | 21 |
2142825 | 2142825 | 2022-01-23 | St. Helena | Louisiana | 22091 | 1647 | 20 |
2139570 | 2139570 | 2022-01-22 | St. Helena | Louisiana | 22091 | 1647 | 20 |
2136314 | 2136314 | 2022-01-21 | St. Helena | Louisiana | 22091 | 1647 | 20 |
2133062 | 2133062 | 2022-01-20 | St. Helena | Louisiana | 22091 | 1636 | 20 |
2129809 | 2129809 | 2022-01-19 | St. Helena | Louisiana | 22091 | 1570 | 20 |
2126555 | 2126555 | 2022-01-18 | St. Helena | Louisiana | 22091 | 1559 | 20 |
2123303 | 2123303 | 2022-01-17 | St. Helena | Louisiana | 22091 | 1524 | 20 |
2120051 | 2120051 | 2022-01-16 | St. Helena | Louisiana | 22091 | 1524 | 20 |
2116799 | 2116799 | 2022-01-15 | St. Helena | Louisiana | 22091 | 1524 | 20 |
2113548 | 2113548 | 2022-01-14 | St. Helena | Louisiana | 22091 | 1524 | 20 |
2110296 | 2110296 | 2022-01-13 | St. Helena | Louisiana | 22091 | 1435 | 20 |
2107045 | 2107045 | 2022-01-12 | St. Helena | Louisiana | 22091 | 1435 | 20 |
2103794 | 2103794 | 2022-01-11 | St. Helena | Louisiana | 22091 | 1435 | 20 |
2100543 | 2100543 | 2022-01-10 | St. Helena | Louisiana | 22091 | 1430 | 20 |
2097292 | 2097292 | 2022-01-09 | St. Helena | Louisiana | 22091 | 1403 | 20 |
2094040 | 2094040 | 2022-01-08 | St. Helena | Louisiana | 22091 | 1403 | 20 |
2090788 | 2090788 | 2022-01-07 | St. Helena | Louisiana | 22091 | 1403 | 20 |
2087537 | 2087537 | 2022-01-06 | St. Helena | Louisiana | 22091 | 1389 | 20 |
2084285 | 2084285 | 2022-01-05 | St. Helena | Louisiana | 22091 | 1376 | 19 |
2081033 | 2081033 | 2022-01-04 | St. Helena | Louisiana | 22091 | 1358 | 19 |
2077781 | 2077781 | 2022-01-03 | St. Helena | Louisiana | 22091 | 1354 | 19 |
2074530 | 2074530 | 2022-01-02 | St. Helena | Louisiana | 22091 | 1310 | 19 |
2071279 | 2071279 | 2022-01-01 | St. Helena | Louisiana | 22091 | 1310 | 19 |
2068028 | 2068028 | 2021-12-31 | St. Helena | Louisiana | 22091 | 1310 | 19 |
2064777 | 2064777 | 2021-12-30 | St. Helena | Louisiana | 22091 | 1310 | 19 |
2061527 | 2061527 | 2021-12-29 | St. Helena | Louisiana | 22091 | 1298 | 19 |
2058278 | 2058278 | 2021-12-28 | St. Helena | Louisiana | 22091 | 1286 | 19 |
2055029 | 2055029 | 2021-12-27 | St. Helena | Louisiana | 22091 | 1282 | 19 |
2051779 | 2051779 | 2021-12-26 | St. Helena | Louisiana | 22091 | 1273 | 19 |
2048529 | 2048529 | 2021-12-25 | St. Helena | Louisiana | 22091 | 1273 | 19 |
2045279 | 2045279 | 2021-12-24 | St. Helena | Louisiana | 22091 | 1273 | 19 |
2042030 | 2042030 | 2021-12-23 | St. Helena | Louisiana | 22091 | 1273 | 19 |
2038780 | 2038780 | 2021-12-22 | St. Helena | Louisiana | 22091 | 1271 | 19 |
2035530 | 2035530 | 2021-12-21 | St. Helena | Louisiana | 22091 | 1271 | 19 |
2032280 | 2032280 | 2021-12-20 | St. Helena | Louisiana | 22091 | 1270 | 19 |
2029029 | 2029029 | 2021-12-19 | St. Helena | Louisiana | 22091 | 1270 | 19 |
2025778 | 2025778 | 2021-12-18 | St. Helena | Louisiana | 22091 | 1270 | 19 |
2022527 | 2022527 | 2021-12-17 | St. Helena | Louisiana | 22091 | 1270 | 19 |
2019276 | 2019276 | 2021-12-16 | St. Helena | Louisiana | 22091 | 1270 | 19 |
2016026 | 2016026 | 2021-12-15 | St. Helena | Louisiana | 22091 | 1270 | 19 |
2012775 | 2012775 | 2021-12-14 | St. Helena | Louisiana | 22091 | 1270 | 19 |
2009524 | 2009524 | 2021-12-13 | St. Helena | Louisiana | 22091 | 1270 | 19 |
2006273 | 2006273 | 2021-12-12 | St. Helena | Louisiana | 22091 | 1268 | 19 |
2003022 | 2003022 | 2021-12-11 | St. Helena | Louisiana | 22091 | 1268 | 19 |
1999772 | 1999772 | 2021-12-10 | St. Helena | Louisiana | 22091 | 1268 | 19 |
1996521 | 1996521 | 2021-12-09 | St. Helena | Louisiana | 22091 | 1268 | 19 |
1993270 | 1993270 | 2021-12-08 | St. Helena | Louisiana | 22091 | 1268 | 19 |
1990019 | 1990019 | 2021-12-07 | St. Helena | Louisiana | 22091 | 1268 | 19 |
1986769 | 1986769 | 2021-12-06 | St. Helena | Louisiana | 22091 | 1268 | 19 |
1983519 | 1983519 | 2021-12-05 | St. Helena | Louisiana | 22091 | 1268 | 19 |
1980269 | 1980269 | 2021-12-04 | St. Helena | Louisiana | 22091 | 1268 | 19 |
1977019 | 1977019 | 2021-12-03 | St. Helena | Louisiana | 22091 | 1268 | 19 |
1973770 | 1973770 | 2021-12-02 | St. Helena | Louisiana | 22091 | 1268 | 19 |
1970520 | 1970520 | 2021-12-01 | St. Helena | Louisiana | 22091 | 1267 | 19 |
1967270 | 1967270 | 2021-11-30 | St. Helena | Louisiana | 22091 | 1264 | 19 |
1964018 | 1964018 | 2021-11-29 | St. Helena | Louisiana | 22091 | 1264 | 19 |
1960767 | 1960767 | 2021-11-28 | St. Helena | Louisiana | 22091 | 1264 | 19 |
1957516 | 1957516 | 2021-11-27 | St. Helena | Louisiana | 22091 | 1264 | 19 |
1954265 | 1954265 | 2021-11-26 | St. Helena | Louisiana | 22091 | 1264 | 19 |
1951014 | 1951014 | 2021-11-25 | St. Helena | Louisiana | 22091 | 1264 | 19 |
1947763 | 1947763 | 2021-11-24 | St. Helena | Louisiana | 22091 | 1264 | 19 |
1944512 | 1944512 | 2021-11-23 | St. Helena | Louisiana | 22091 | 1264 | 19 |
1941262 | 1941262 | 2021-11-22 | St. Helena | Louisiana | 22091 | 1264 | 19 |
1938012 | 1938012 | 2021-11-21 | St. Helena | Louisiana | 22091 | 1264 | 19 |
1934762 | 1934762 | 2021-11-20 | St. Helena | Louisiana | 22091 | 1264 | 19 |
1931511 | 1931511 | 2021-11-19 | St. Helena | Louisiana | 22091 | 1264 | 19 |
1928260 | 1928260 | 2021-11-18 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1925010 | 1925010 | 2021-11-17 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1921761 | 1921761 | 2021-11-16 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1918511 | 1918511 | 2021-11-15 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1915261 | 1915261 | 2021-11-14 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1912011 | 1912011 | 2021-11-13 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1908762 | 1908762 | 2021-11-12 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1905513 | 1905513 | 2021-11-11 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1902263 | 1902263 | 2021-11-10 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1899013 | 1899013 | 2021-11-09 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1895763 | 1895763 | 2021-11-08 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1892513 | 1892513 | 2021-11-07 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1889263 | 1889263 | 2021-11-06 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1886013 | 1886013 | 2021-11-05 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1882764 | 1882764 | 2021-11-04 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1879515 | 1879515 | 2021-11-03 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1876266 | 1876266 | 2021-11-02 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1873017 | 1873017 | 2021-11-01 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1869768 | 1869768 | 2021-10-31 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1866519 | 1866519 | 2021-10-30 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1863270 | 1863270 | 2021-10-29 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1860021 | 1860021 | 2021-10-28 | St. Helena | Louisiana | 22091 | 1264 | 18 |
1856772 | 1856772 | 2021-10-27 | St. Helena | Louisiana | 22091 | 1263 | 18 |
1853523 | 1853523 | 2021-10-26 | St. Helena | Louisiana | 22091 | 1262 | 18 |
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);