ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
374 rows where deaths = 39 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- West Feliciana 40
- Caldwell 39
- West Carroll 28
- Winn 21
- Jefferson Davis 18
- Madison 18
- Union 18
- Catahoula 16
- St. Mary 16
- LaSalle 15
- St. Bernard 15
- Beauregard 14
- De Soto 11
- West Baton Rouge 10
- Jackson 9
- Evangeline 8
- Lincoln 8
- Richland 7
- Tangipahoa 7
- Vernon 5
- Bossier 4
- Caddo 4
- East Feliciana 4
- Franklin 4
- Lafourche 4
- Assumption 3
- Concordia 3
- Natchitoches 3
- Pointe Coupee 3
- Terrebonne 3
- …
state 1
- Louisiana · 374 ✖
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 |
1808053 | 1808053 | 2021-10-12 | West Feliciana | Louisiana | 22125 | 1507 | 39 |
1804802 | 1804802 | 2021-10-11 | West Feliciana | Louisiana | 22125 | 1506 | 39 |
1801553 | 1801553 | 2021-10-10 | West Feliciana | Louisiana | 22125 | 1503 | 39 |
1798304 | 1798304 | 2021-10-09 | West Feliciana | Louisiana | 22125 | 1503 | 39 |
1795055 | 1795055 | 2021-10-08 | West Feliciana | Louisiana | 22125 | 1503 | 39 |
1791807 | 1791807 | 2021-10-07 | West Feliciana | Louisiana | 22125 | 1500 | 39 |
1788558 | 1788558 | 2021-10-06 | West Feliciana | Louisiana | 22125 | 1499 | 39 |
1785309 | 1785309 | 2021-10-05 | West Feliciana | Louisiana | 22125 | 1499 | 39 |
1782060 | 1782060 | 2021-10-04 | West Feliciana | Louisiana | 22125 | 1499 | 39 |
1778810 | 1778810 | 2021-10-03 | West Feliciana | Louisiana | 22125 | 1492 | 39 |
1775560 | 1775560 | 2021-10-02 | West Feliciana | Louisiana | 22125 | 1492 | 39 |
1772310 | 1772310 | 2021-10-01 | West Feliciana | Louisiana | 22125 | 1492 | 39 |
1769061 | 1769061 | 2021-09-30 | West Feliciana | Louisiana | 22125 | 1492 | 39 |
1765812 | 1765812 | 2021-09-29 | West Feliciana | Louisiana | 22125 | 1492 | 39 |
1762563 | 1762563 | 2021-09-28 | West Feliciana | Louisiana | 22125 | 1492 | 39 |
1759315 | 1759315 | 2021-09-27 | West Feliciana | Louisiana | 22125 | 1492 | 39 |
1756067 | 1756067 | 2021-09-26 | West Feliciana | Louisiana | 22125 | 1492 | 39 |
1752819 | 1752819 | 2021-09-25 | West Feliciana | Louisiana | 22125 | 1492 | 39 |
1749570 | 1749570 | 2021-09-24 | West Feliciana | Louisiana | 22125 | 1492 | 39 |
1746320 | 1746320 | 2021-09-23 | West Feliciana | Louisiana | 22125 | 1444 | 39 |
1743071 | 1743071 | 2021-09-22 | West Feliciana | Louisiana | 22125 | 1432 | 39 |
1739822 | 1739822 | 2021-09-21 | West Feliciana | Louisiana | 22125 | 1432 | 39 |
1736573 | 1736573 | 2021-09-20 | West Feliciana | Louisiana | 22125 | 1432 | 39 |
1733323 | 1733323 | 2021-09-19 | West Feliciana | Louisiana | 22125 | 1427 | 39 |
1730073 | 1730073 | 2021-09-18 | West Feliciana | Louisiana | 22125 | 1427 | 39 |
1726823 | 1726823 | 2021-09-17 | West Feliciana | Louisiana | 22125 | 1427 | 39 |
1723574 | 1723574 | 2021-09-16 | West Feliciana | Louisiana | 22125 | 1418 | 39 |
1720325 | 1720325 | 2021-09-15 | West Feliciana | Louisiana | 22125 | 1418 | 39 |
1717077 | 1717077 | 2021-09-14 | West Feliciana | Louisiana | 22125 | 1418 | 39 |
1713830 | 1713830 | 2021-09-13 | West Feliciana | Louisiana | 22125 | 1417 | 39 |
1710584 | 1710584 | 2021-09-12 | West Feliciana | Louisiana | 22125 | 1417 | 39 |
1707337 | 1707337 | 2021-09-11 | West Feliciana | Louisiana | 22125 | 1417 | 39 |
1704089 | 1704089 | 2021-09-10 | West Feliciana | Louisiana | 22125 | 1417 | 39 |
1700839 | 1700839 | 2021-09-09 | West Feliciana | Louisiana | 22125 | 1415 | 39 |
1697590 | 1697590 | 2021-09-08 | West Feliciana | Louisiana | 22125 | 1413 | 39 |
1694342 | 1694342 | 2021-09-07 | West Feliciana | Louisiana | 22125 | 1412 | 39 |
1691093 | 1691093 | 2021-09-06 | West Feliciana | Louisiana | 22125 | 1411 | 39 |
1687843 | 1687843 | 2021-09-05 | West Feliciana | Louisiana | 22125 | 1411 | 39 |
1684593 | 1684593 | 2021-09-04 | West Feliciana | Louisiana | 22125 | 1411 | 39 |
1681342 | 1681342 | 2021-09-03 | West Feliciana | Louisiana | 22125 | 1411 | 39 |
1652077 | 1652077 | 2021-08-25 | LaSalle | Louisiana | 22059 | 2290 | 39 |
1648828 | 1648828 | 2021-08-24 | LaSalle | Louisiana | 22059 | 2274 | 39 |
1645580 | 1645580 | 2021-08-23 | LaSalle | Louisiana | 22059 | 2262 | 39 |
1642331 | 1642331 | 2021-08-22 | LaSalle | Louisiana | 22059 | 2228 | 39 |
1639081 | 1639081 | 2021-08-21 | LaSalle | Louisiana | 22059 | 2228 | 39 |
1635831 | 1635831 | 2021-08-20 | LaSalle | Louisiana | 22059 | 2228 | 39 |
1632581 | 1632581 | 2021-08-19 | LaSalle | Louisiana | 22059 | 2209 | 39 |
1629319 | 1629319 | 2021-08-18 | Catahoula | Louisiana | 22025 | 1472 | 39 |
1629334 | 1629334 | 2021-08-18 | LaSalle | Louisiana | 22059 | 2188 | 39 |
1626072 | 1626072 | 2021-08-17 | Catahoula | Louisiana | 22025 | 1456 | 39 |
1626087 | 1626087 | 2021-08-17 | LaSalle | Louisiana | 22059 | 2158 | 39 |
1622825 | 1622825 | 2021-08-16 | Catahoula | Louisiana | 22025 | 1453 | 39 |
1622840 | 1622840 | 2021-08-16 | LaSalle | Louisiana | 22059 | 2145 | 39 |
1619569 | 1619569 | 2021-08-15 | Assumption | Louisiana | 22007 | 3026 | 39 |
1619578 | 1619578 | 2021-08-15 | Catahoula | Louisiana | 22025 | 1418 | 39 |
1619593 | 1619593 | 2021-08-15 | LaSalle | Louisiana | 22059 | 2074 | 39 |
1616321 | 1616321 | 2021-08-14 | Assumption | Louisiana | 22007 | 3026 | 39 |
1616330 | 1616330 | 2021-08-14 | Catahoula | Louisiana | 22025 | 1418 | 39 |
1616345 | 1616345 | 2021-08-14 | LaSalle | Louisiana | 22059 | 2074 | 39 |
1613072 | 1613072 | 2021-08-13 | Assumption | Louisiana | 22007 | 3026 | 39 |
1613081 | 1613081 | 2021-08-13 | Catahoula | Louisiana | 22025 | 1418 | 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);