ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Ascension" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110253 | 2110253 | 2022-01-13 | Ascension | Louisiana | 22005 | 27518 | 253 |
2107002 | 2107002 | 2022-01-12 | Ascension | Louisiana | 22005 | 27518 | 253 |
2103751 | 2103751 | 2022-01-11 | Ascension | Louisiana | 22005 | 27518 | 253 |
2100500 | 2100500 | 2022-01-10 | Ascension | Louisiana | 22005 | 26963 | 252 |
2097249 | 2097249 | 2022-01-09 | Ascension | Louisiana | 22005 | 25773 | 252 |
2093997 | 2093997 | 2022-01-08 | Ascension | Louisiana | 22005 | 25773 | 252 |
2090745 | 2090745 | 2022-01-07 | Ascension | Louisiana | 22005 | 25773 | 252 |
2087494 | 2087494 | 2022-01-06 | Ascension | Louisiana | 22005 | 25327 | 252 |
2084242 | 2084242 | 2022-01-05 | Ascension | Louisiana | 22005 | 25024 | 250 |
2080990 | 2080990 | 2022-01-04 | Ascension | Louisiana | 22005 | 24729 | 250 |
2077738 | 2077738 | 2022-01-03 | Ascension | Louisiana | 22005 | 24479 | 250 |
2074487 | 2074487 | 2022-01-02 | Ascension | Louisiana | 22005 | 23642 | 250 |
2071236 | 2071236 | 2022-01-01 | Ascension | Louisiana | 22005 | 23642 | 250 |
2067985 | 2067985 | 2021-12-31 | Ascension | Louisiana | 22005 | 23642 | 250 |
2064734 | 2064734 | 2021-12-30 | Ascension | Louisiana | 22005 | 23642 | 250 |
2061484 | 2061484 | 2021-12-29 | Ascension | Louisiana | 22005 | 23192 | 250 |
2058235 | 2058235 | 2021-12-28 | Ascension | Louisiana | 22005 | 22952 | 250 |
2054986 | 2054986 | 2021-12-27 | Ascension | Louisiana | 22005 | 22811 | 250 |
2051736 | 2051736 | 2021-12-26 | Ascension | Louisiana | 22005 | 22577 | 250 |
2048486 | 2048486 | 2021-12-25 | Ascension | Louisiana | 22005 | 22577 | 250 |
2045236 | 2045236 | 2021-12-24 | Ascension | Louisiana | 22005 | 22577 | 250 |
2041987 | 2041987 | 2021-12-23 | Ascension | Louisiana | 22005 | 22577 | 250 |
2038737 | 2038737 | 2021-12-22 | Ascension | Louisiana | 22005 | 22533 | 250 |
2035487 | 2035487 | 2021-12-21 | Ascension | Louisiana | 22005 | 22496 | 249 |
2032237 | 2032237 | 2021-12-20 | Ascension | Louisiana | 22005 | 22417 | 249 |
2028986 | 2028986 | 2021-12-19 | Ascension | Louisiana | 22005 | 22348 | 249 |
2025735 | 2025735 | 2021-12-18 | Ascension | Louisiana | 22005 | 22348 | 249 |
2022484 | 2022484 | 2021-12-17 | Ascension | Louisiana | 22005 | 22348 | 249 |
2019233 | 2019233 | 2021-12-16 | Ascension | Louisiana | 22005 | 22329 | 249 |
2015983 | 2015983 | 2021-12-15 | Ascension | Louisiana | 22005 | 22305 | 249 |
2012732 | 2012732 | 2021-12-14 | Ascension | Louisiana | 22005 | 22262 | 249 |
2009481 | 2009481 | 2021-12-13 | Ascension | Louisiana | 22005 | 22244 | 249 |
2006230 | 2006230 | 2021-12-12 | Ascension | Louisiana | 22005 | 22196 | 249 |
2002979 | 2002979 | 2021-12-11 | Ascension | Louisiana | 22005 | 22196 | 249 |
1999729 | 1999729 | 2021-12-10 | Ascension | Louisiana | 22005 | 22196 | 249 |
1996478 | 1996478 | 2021-12-09 | Ascension | Louisiana | 22005 | 22171 | 249 |
1993227 | 1993227 | 2021-12-08 | Ascension | Louisiana | 22005 | 22154 | 249 |
1989976 | 1989976 | 2021-12-07 | Ascension | Louisiana | 22005 | 22127 | 249 |
1986726 | 1986726 | 2021-12-06 | Ascension | Louisiana | 22005 | 22123 | 249 |
1983476 | 1983476 | 2021-12-05 | Ascension | Louisiana | 22005 | 22112 | 247 |
1980226 | 1980226 | 2021-12-04 | Ascension | Louisiana | 22005 | 22112 | 247 |
1976976 | 1976976 | 2021-12-03 | Ascension | Louisiana | 22005 | 22112 | 247 |
1973727 | 1973727 | 2021-12-02 | Ascension | Louisiana | 22005 | 22104 | 247 |
1970477 | 1970477 | 2021-12-01 | Ascension | Louisiana | 22005 | 22094 | 247 |
1967227 | 1967227 | 2021-11-30 | Ascension | Louisiana | 22005 | 22053 | 247 |
1963975 | 1963975 | 2021-11-29 | Ascension | Louisiana | 22005 | 22046 | 247 |
1960724 | 1960724 | 2021-11-28 | Ascension | Louisiana | 22005 | 22028 | 247 |
1957473 | 1957473 | 2021-11-27 | Ascension | Louisiana | 22005 | 22028 | 247 |
1954222 | 1954222 | 2021-11-26 | Ascension | Louisiana | 22005 | 22028 | 247 |
1950971 | 1950971 | 2021-11-25 | Ascension | Louisiana | 22005 | 22028 | 247 |
1947720 | 1947720 | 2021-11-24 | Ascension | Louisiana | 22005 | 22028 | 247 |
1944469 | 1944469 | 2021-11-23 | Ascension | Louisiana | 22005 | 22016 | 247 |
1941219 | 1941219 | 2021-11-22 | Ascension | Louisiana | 22005 | 21987 | 247 |
1937969 | 1937969 | 2021-11-21 | Ascension | Louisiana | 22005 | 21974 | 247 |
1934719 | 1934719 | 2021-11-20 | Ascension | Louisiana | 22005 | 21974 | 247 |
1931468 | 1931468 | 2021-11-19 | Ascension | Louisiana | 22005 | 21974 | 247 |
1928217 | 1928217 | 2021-11-18 | Ascension | Louisiana | 22005 | 21966 | 246 |
1924967 | 1924967 | 2021-11-17 | Ascension | Louisiana | 22005 | 21950 | 245 |
1921718 | 1921718 | 2021-11-16 | Ascension | Louisiana | 22005 | 21947 | 245 |
1918468 | 1918468 | 2021-11-15 | Ascension | Louisiana | 22005 | 21933 | 244 |
1915218 | 1915218 | 2021-11-14 | Ascension | Louisiana | 22005 | 21914 | 244 |
1911968 | 1911968 | 2021-11-13 | Ascension | Louisiana | 22005 | 21914 | 244 |
1908719 | 1908719 | 2021-11-12 | Ascension | Louisiana | 22005 | 21914 | 244 |
1905470 | 1905470 | 2021-11-11 | Ascension | Louisiana | 22005 | 21891 | 243 |
1902220 | 1902220 | 2021-11-10 | Ascension | Louisiana | 22005 | 21891 | 243 |
1898970 | 1898970 | 2021-11-09 | Ascension | Louisiana | 22005 | 21881 | 243 |
1895720 | 1895720 | 2021-11-08 | Ascension | Louisiana | 22005 | 21864 | 243 |
1892470 | 1892470 | 2021-11-07 | Ascension | Louisiana | 22005 | 21857 | 243 |
1889220 | 1889220 | 2021-11-06 | Ascension | Louisiana | 22005 | 21857 | 243 |
1885970 | 1885970 | 2021-11-05 | Ascension | Louisiana | 22005 | 21857 | 243 |
1882721 | 1882721 | 2021-11-04 | Ascension | Louisiana | 22005 | 21834 | 243 |
1879472 | 1879472 | 2021-11-03 | Ascension | Louisiana | 22005 | 21810 | 243 |
1876223 | 1876223 | 2021-11-02 | Ascension | Louisiana | 22005 | 21798 | 243 |
1872974 | 1872974 | 2021-11-01 | Ascension | Louisiana | 22005 | 21795 | 243 |
1869725 | 1869725 | 2021-10-31 | Ascension | Louisiana | 22005 | 21779 | 243 |
1866476 | 1866476 | 2021-10-30 | Ascension | Louisiana | 22005 | 21779 | 243 |
1863227 | 1863227 | 2021-10-29 | Ascension | Louisiana | 22005 | 21779 | 243 |
1859978 | 1859978 | 2021-10-28 | Ascension | Louisiana | 22005 | 21773 | 243 |
1856729 | 1856729 | 2021-10-27 | Ascension | Louisiana | 22005 | 21759 | 243 |
1853480 | 1853480 | 2021-10-26 | Ascension | Louisiana | 22005 | 21739 | 241 |
1850231 | 1850231 | 2021-10-25 | Ascension | Louisiana | 22005 | 21734 | 241 |
1846981 | 1846981 | 2021-10-24 | Ascension | Louisiana | 22005 | 21717 | 239 |
1843731 | 1843731 | 2021-10-23 | Ascension | Louisiana | 22005 | 21717 | 239 |
1840481 | 1840481 | 2021-10-22 | Ascension | Louisiana | 22005 | 21717 | 239 |
1837232 | 1837232 | 2021-10-21 | Ascension | Louisiana | 22005 | 21700 | 239 |
1833983 | 1833983 | 2021-10-20 | Ascension | Louisiana | 22005 | 21688 | 236 |
1830734 | 1830734 | 2021-10-19 | Ascension | Louisiana | 22005 | 21676 | 236 |
1827485 | 1827485 | 2021-10-18 | Ascension | Louisiana | 22005 | 21660 | 236 |
1824236 | 1824236 | 2021-10-17 | Ascension | Louisiana | 22005 | 21640 | 235 |
1820987 | 1820987 | 2021-10-16 | Ascension | Louisiana | 22005 | 21640 | 235 |
1817738 | 1817738 | 2021-10-15 | Ascension | Louisiana | 22005 | 21640 | 235 |
1814490 | 1814490 | 2021-10-14 | Ascension | Louisiana | 22005 | 21632 | 234 |
1811241 | 1811241 | 2021-10-13 | Ascension | Louisiana | 22005 | 21616 | 233 |
1807992 | 1807992 | 2021-10-12 | Ascension | Louisiana | 22005 | 21614 | 233 |
1804741 | 1804741 | 2021-10-11 | Ascension | Louisiana | 22005 | 21553 | 233 |
1801492 | 1801492 | 2021-10-10 | Ascension | Louisiana | 22005 | 21534 | 232 |
1798243 | 1798243 | 2021-10-09 | Ascension | Louisiana | 22005 | 21534 | 232 |
1794994 | 1794994 | 2021-10-08 | Ascension | Louisiana | 22005 | 21534 | 232 |
1791746 | 1791746 | 2021-10-07 | Ascension | Louisiana | 22005 | 21512 | 232 |
1788497 | 1788497 | 2021-10-06 | Ascension | Louisiana | 22005 | 21493 | 230 |
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);