ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where deaths = 39, fips = 22021 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1986734 | 1986734 | 2021-12-06 | Caldwell | Louisiana | 22021 | 2317 | 39 |
1983484 | 1983484 | 2021-12-05 | Caldwell | Louisiana | 22021 | 2314 | 39 |
1980234 | 1980234 | 2021-12-04 | Caldwell | Louisiana | 22021 | 2314 | 39 |
1976984 | 1976984 | 2021-12-03 | Caldwell | Louisiana | 22021 | 2314 | 39 |
1973735 | 1973735 | 2021-12-02 | Caldwell | Louisiana | 22021 | 2313 | 39 |
1970485 | 1970485 | 2021-12-01 | Caldwell | Louisiana | 22021 | 2308 | 39 |
1967235 | 1967235 | 2021-11-30 | Caldwell | Louisiana | 22021 | 2304 | 39 |
1963983 | 1963983 | 2021-11-29 | Caldwell | Louisiana | 22021 | 2300 | 39 |
1960732 | 1960732 | 2021-11-28 | Caldwell | Louisiana | 22021 | 2299 | 39 |
1957481 | 1957481 | 2021-11-27 | Caldwell | Louisiana | 22021 | 2299 | 39 |
1954230 | 1954230 | 2021-11-26 | Caldwell | Louisiana | 22021 | 2299 | 39 |
1950979 | 1950979 | 2021-11-25 | Caldwell | Louisiana | 22021 | 2299 | 39 |
1947728 | 1947728 | 2021-11-24 | Caldwell | Louisiana | 22021 | 2299 | 39 |
1944477 | 1944477 | 2021-11-23 | Caldwell | Louisiana | 22021 | 2294 | 39 |
1941227 | 1941227 | 2021-11-22 | Caldwell | Louisiana | 22021 | 2290 | 39 |
1937977 | 1937977 | 2021-11-21 | Caldwell | Louisiana | 22021 | 2289 | 39 |
1934727 | 1934727 | 2021-11-20 | Caldwell | Louisiana | 22021 | 2289 | 39 |
1931476 | 1931476 | 2021-11-19 | Caldwell | Louisiana | 22021 | 2289 | 39 |
1928225 | 1928225 | 2021-11-18 | Caldwell | Louisiana | 22021 | 2277 | 39 |
1924975 | 1924975 | 2021-11-17 | Caldwell | Louisiana | 22021 | 2277 | 39 |
1921726 | 1921726 | 2021-11-16 | Caldwell | Louisiana | 22021 | 2268 | 39 |
1918476 | 1918476 | 2021-11-15 | Caldwell | Louisiana | 22021 | 2264 | 39 |
1915226 | 1915226 | 2021-11-14 | Caldwell | Louisiana | 22021 | 2261 | 39 |
1911976 | 1911976 | 2021-11-13 | Caldwell | Louisiana | 22021 | 2261 | 39 |
1908727 | 1908727 | 2021-11-12 | Caldwell | Louisiana | 22021 | 2261 | 39 |
1905478 | 1905478 | 2021-11-11 | Caldwell | Louisiana | 22021 | 2252 | 39 |
1902228 | 1902228 | 2021-11-10 | Caldwell | Louisiana | 22021 | 2252 | 39 |
1898978 | 1898978 | 2021-11-09 | Caldwell | Louisiana | 22021 | 2250 | 39 |
1895728 | 1895728 | 2021-11-08 | Caldwell | Louisiana | 22021 | 2249 | 39 |
1892478 | 1892478 | 2021-11-07 | Caldwell | Louisiana | 22021 | 2247 | 39 |
1889228 | 1889228 | 2021-11-06 | Caldwell | Louisiana | 22021 | 2247 | 39 |
1885978 | 1885978 | 2021-11-05 | Caldwell | Louisiana | 22021 | 2247 | 39 |
1882729 | 1882729 | 2021-11-04 | Caldwell | Louisiana | 22021 | 2244 | 39 |
1879480 | 1879480 | 2021-11-03 | Caldwell | Louisiana | 22021 | 2244 | 39 |
1876231 | 1876231 | 2021-11-02 | Caldwell | Louisiana | 22021 | 2241 | 39 |
1872982 | 1872982 | 2021-11-01 | Caldwell | Louisiana | 22021 | 2239 | 39 |
1869733 | 1869733 | 2021-10-31 | Caldwell | Louisiana | 22021 | 2231 | 39 |
1866484 | 1866484 | 2021-10-30 | Caldwell | Louisiana | 22021 | 2231 | 39 |
1863235 | 1863235 | 2021-10-29 | Caldwell | Louisiana | 22021 | 2231 | 39 |
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);