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 |
---|---|---|---|---|---|---|---|
2175319 | 2175319 | 2022-02-02 | Ascension | Louisiana | 22005 | 33601 | 268 |
2172066 | 2172066 | 2022-02-01 | Ascension | Louisiana | 22005 | 33516 | 268 |
2168813 | 2168813 | 2022-01-31 | Ascension | Louisiana | 22005 | 33396 | 264 |
2165558 | 2165558 | 2022-01-30 | Ascension | Louisiana | 22005 | 33209 | 264 |
2162303 | 2162303 | 2022-01-29 | Ascension | Louisiana | 22005 | 33209 | 264 |
2159048 | 2159048 | 2022-01-28 | Ascension | Louisiana | 22005 | 33209 | 264 |
2155794 | 2155794 | 2022-01-27 | Ascension | Louisiana | 22005 | 33089 | 263 |
2152541 | 2152541 | 2022-01-26 | Ascension | Louisiana | 22005 | 32894 | 258 |
2149289 | 2149289 | 2022-01-25 | Ascension | Louisiana | 22005 | 31287 | 258 |
2146037 | 2146037 | 2022-01-24 | Ascension | Louisiana | 22005 | 31118 | 258 |
2142782 | 2142782 | 2022-01-23 | Ascension | Louisiana | 22005 | 30639 | 256 |
2139527 | 2139527 | 2022-01-22 | Ascension | Louisiana | 22005 | 30639 | 256 |
2136271 | 2136271 | 2022-01-21 | Ascension | Louisiana | 22005 | 30639 | 256 |
2133019 | 2133019 | 2022-01-20 | Ascension | Louisiana | 22005 | 30434 | 256 |
2129766 | 2129766 | 2022-01-19 | Ascension | Louisiana | 22005 | 29984 | 256 |
2126512 | 2126512 | 2022-01-18 | Ascension | Louisiana | 22005 | 29695 | 256 |
2123260 | 2123260 | 2022-01-17 | Ascension | Louisiana | 22005 | 28732 | 253 |
2120008 | 2120008 | 2022-01-16 | Ascension | Louisiana | 22005 | 28732 | 253 |
2116756 | 2116756 | 2022-01-15 | Ascension | Louisiana | 22005 | 28732 | 253 |
2113505 | 2113505 | 2022-01-14 | Ascension | Louisiana | 22005 | 28732 | 253 |
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 |
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);