ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
233 rows where deaths = 47 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Winn 48
- West Carroll 19
- Jackson 13
- Grant 12
- Iberville 12
- West Baton Rouge 12
- Claiborne 9
- Franklin 9
- Jefferson Davis 9
- Sabine 8
- Lincoln 6
- Richland 6
- Assumption 5
- Avoyelles 5
- Caldwell 5
- Livingston 5
- LaSalle 4
- Webster 4
- Bienville 3
- Catahoula 3
- Madison 3
- St. Bernard 3
- St. Martin 3
- Tangipahoa 3
- Washington 3
- Beauregard 2
- Concordia 2
- Iberia 2
- Lafayette 2
- Rapides 2
- …
state 1
- Louisiana · 233 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2233868 | 2233868 | 2022-02-20 | Caldwell | Louisiana | 22021 | 3028 | 47 |
2230617 | 2230617 | 2022-02-19 | Caldwell | Louisiana | 22021 | 3028 | 47 |
2227366 | 2227366 | 2022-02-18 | Caldwell | Louisiana | 22021 | 3028 | 47 |
2224115 | 2224115 | 2022-02-17 | Caldwell | Louisiana | 22021 | 3022 | 47 |
2220864 | 2220864 | 2022-02-16 | Caldwell | Louisiana | 22021 | 3021 | 47 |
2155819 | 2155819 | 2022-01-27 | LaSalle | Louisiana | 22059 | 3792 | 47 |
2152566 | 2152566 | 2022-01-26 | LaSalle | Louisiana | 22059 | 3754 | 47 |
2149314 | 2149314 | 2022-01-25 | LaSalle | Louisiana | 22059 | 3553 | 47 |
2146062 | 2146062 | 2022-01-24 | LaSalle | Louisiana | 22059 | 3515 | 47 |
1850291 | 1850291 | 2021-10-25 | West Carroll | Louisiana | 22123 | 1981 | 47 |
1847041 | 1847041 | 2021-10-24 | West Carroll | Louisiana | 22123 | 1971 | 47 |
1843791 | 1843791 | 2021-10-23 | West Carroll | Louisiana | 22123 | 1971 | 47 |
1840541 | 1840541 | 2021-10-22 | West Carroll | Louisiana | 22123 | 1971 | 47 |
1837292 | 1837292 | 2021-10-21 | West Carroll | Louisiana | 22123 | 1968 | 47 |
1834043 | 1834043 | 2021-10-20 | West Carroll | Louisiana | 22123 | 1966 | 47 |
1830794 | 1830794 | 2021-10-19 | West Carroll | Louisiana | 22123 | 1959 | 47 |
1827545 | 1827545 | 2021-10-18 | West Carroll | Louisiana | 22123 | 1958 | 47 |
1824296 | 1824296 | 2021-10-17 | West Carroll | Louisiana | 22123 | 1941 | 47 |
1821047 | 1821047 | 2021-10-16 | West Carroll | Louisiana | 22123 | 1941 | 47 |
1817798 | 1817798 | 2021-10-15 | West Carroll | Louisiana | 22123 | 1941 | 47 |
1814528 | 1814528 | 2021-10-14 | Red River | Louisiana | 22081 | 1396 | 47 |
1814550 | 1814550 | 2021-10-14 | West Carroll | Louisiana | 22123 | 1935 | 47 |
1811301 | 1811301 | 2021-10-13 | West Carroll | Louisiana | 22123 | 1925 | 47 |
1808052 | 1808052 | 2021-10-12 | West Carroll | Louisiana | 22123 | 1922 | 47 |
1804801 | 1804801 | 2021-10-11 | West Carroll | Louisiana | 22123 | 1922 | 47 |
1801552 | 1801552 | 2021-10-10 | West Carroll | Louisiana | 22123 | 1911 | 47 |
1798303 | 1798303 | 2021-10-09 | West Carroll | Louisiana | 22123 | 1911 | 47 |
1795054 | 1795054 | 2021-10-08 | West Carroll | Louisiana | 22123 | 1911 | 47 |
1791806 | 1791806 | 2021-10-07 | West Carroll | Louisiana | 22123 | 1905 | 47 |
1769010 | 1769010 | 2021-09-30 | Catahoula | Louisiana | 22025 | 1758 | 47 |
1765761 | 1765761 | 2021-09-29 | Catahoula | Louisiana | 22025 | 1755 | 47 |
1762512 | 1762512 | 2021-09-28 | Catahoula | Louisiana | 22025 | 1752 | 47 |
1691033 | 1691033 | 2021-09-06 | Assumption | Louisiana | 22007 | 3377 | 47 |
1687783 | 1687783 | 2021-09-05 | Assumption | Louisiana | 22007 | 3377 | 47 |
1684533 | 1684533 | 2021-09-04 | Assumption | Louisiana | 22007 | 3377 | 47 |
1681282 | 1681282 | 2021-09-03 | Assumption | Louisiana | 22007 | 3377 | 47 |
1678034 | 1678034 | 2021-09-02 | Assumption | Louisiana | 22007 | 3365 | 47 |
1652082 | 1652082 | 2021-08-25 | Madison | Louisiana | 22065 | 1869 | 47 |
1648833 | 1648833 | 2021-08-24 | Madison | Louisiana | 22065 | 1854 | 47 |
1645585 | 1645585 | 2021-08-23 | Madison | Louisiana | 22065 | 1846 | 47 |
1577394 | 1577394 | 2021-08-02 | Winn | Louisiana | 22127 | 1748 | 47 |
1574146 | 1574146 | 2021-08-01 | Winn | Louisiana | 22127 | 1723 | 47 |
1570898 | 1570898 | 2021-07-31 | Winn | Louisiana | 22127 | 1723 | 47 |
1567650 | 1567650 | 2021-07-30 | Winn | Louisiana | 22127 | 1723 | 47 |
1564402 | 1564402 | 2021-07-29 | Winn | Louisiana | 22127 | 1707 | 47 |
1561154 | 1561154 | 2021-07-28 | Winn | Louisiana | 22127 | 1702 | 47 |
1557907 | 1557907 | 2021-07-27 | Winn | Louisiana | 22127 | 1683 | 47 |
1554660 | 1554660 | 2021-07-26 | Winn | Louisiana | 22127 | 1656 | 47 |
1551413 | 1551413 | 2021-07-25 | Winn | Louisiana | 22127 | 1645 | 47 |
1548166 | 1548166 | 2021-07-24 | Winn | Louisiana | 22127 | 1645 | 47 |
1544919 | 1544919 | 2021-07-23 | Winn | Louisiana | 22127 | 1645 | 47 |
1541671 | 1541671 | 2021-07-22 | Winn | Louisiana | 22127 | 1639 | 47 |
1538424 | 1538424 | 2021-07-21 | Winn | Louisiana | 22127 | 1629 | 47 |
1535176 | 1535176 | 2021-07-20 | Winn | Louisiana | 22127 | 1622 | 47 |
1531929 | 1531929 | 2021-07-19 | Winn | Louisiana | 22127 | 1615 | 47 |
1528682 | 1528682 | 2021-07-18 | Winn | Louisiana | 22127 | 1612 | 47 |
1525435 | 1525435 | 2021-07-17 | Winn | Louisiana | 22127 | 1612 | 47 |
1522187 | 1522187 | 2021-07-16 | Winn | Louisiana | 22127 | 1612 | 47 |
1518939 | 1518939 | 2021-07-15 | Winn | Louisiana | 22127 | 1607 | 47 |
1515692 | 1515692 | 2021-07-14 | Winn | Louisiana | 22127 | 1605 | 47 |
1512446 | 1512446 | 2021-07-13 | Winn | Louisiana | 22127 | 1601 | 47 |
1509199 | 1509199 | 2021-07-12 | Winn | Louisiana | 22127 | 1599 | 47 |
1505953 | 1505953 | 2021-07-11 | Winn | Louisiana | 22127 | 1598 | 47 |
1502707 | 1502707 | 2021-07-10 | Winn | Louisiana | 22127 | 1598 | 47 |
1499461 | 1499461 | 2021-07-09 | Winn | Louisiana | 22127 | 1598 | 47 |
1496214 | 1496214 | 2021-07-08 | Winn | Louisiana | 22127 | 1597 | 47 |
1492968 | 1492968 | 2021-07-07 | Winn | Louisiana | 22127 | 1596 | 47 |
1489721 | 1489721 | 2021-07-06 | Winn | Louisiana | 22127 | 1591 | 47 |
1486474 | 1486474 | 2021-07-05 | Winn | Louisiana | 22127 | 1588 | 47 |
1483228 | 1483228 | 2021-07-04 | Winn | Louisiana | 22127 | 1588 | 47 |
1479981 | 1479981 | 2021-07-03 | Winn | Louisiana | 22127 | 1588 | 47 |
1476735 | 1476735 | 2021-07-02 | Winn | Louisiana | 22127 | 1588 | 47 |
1473489 | 1473489 | 2021-07-01 | Winn | Louisiana | 22127 | 1587 | 47 |
1470243 | 1470243 | 2021-06-30 | Winn | Louisiana | 22127 | 1586 | 47 |
1466998 | 1466998 | 2021-06-29 | Winn | Louisiana | 22127 | 1586 | 47 |
1463753 | 1463753 | 2021-06-28 | Winn | Louisiana | 22127 | 1584 | 47 |
1460508 | 1460508 | 2021-06-27 | Winn | Louisiana | 22127 | 1584 | 47 |
1457263 | 1457263 | 2021-06-26 | Winn | Louisiana | 22127 | 1584 | 47 |
1454018 | 1454018 | 2021-06-25 | Winn | Louisiana | 22127 | 1584 | 47 |
1450772 | 1450772 | 2021-06-24 | Winn | Louisiana | 22127 | 1583 | 47 |
1447527 | 1447527 | 2021-06-23 | Winn | Louisiana | 22127 | 1583 | 47 |
1444282 | 1444282 | 2021-06-22 | Winn | Louisiana | 22127 | 1583 | 47 |
1441037 | 1441037 | 2021-06-21 | Winn | Louisiana | 22127 | 1583 | 47 |
1437790 | 1437790 | 2021-06-20 | Winn | Louisiana | 22127 | 1581 | 47 |
1434543 | 1434543 | 2021-06-19 | Winn | Louisiana | 22127 | 1581 | 47 |
1431297 | 1431297 | 2021-06-18 | Winn | Louisiana | 22127 | 1581 | 47 |
1428052 | 1428052 | 2021-06-17 | Winn | Louisiana | 22127 | 1580 | 47 |
1424807 | 1424807 | 2021-06-16 | Winn | Louisiana | 22127 | 1579 | 47 |
1119588 | 1119588 | 2021-03-14 | St. Bernard | Louisiana | 22087 | 3856 | 47 |
1116341 | 1116341 | 2021-03-13 | St. Bernard | Louisiana | 22087 | 3837 | 47 |
1113095 | 1113095 | 2021-03-12 | St. Bernard | Louisiana | 22087 | 3837 | 47 |
1096844 | 1096844 | 2021-03-07 | Jackson | Louisiana | 22049 | 1798 | 47 |
1093598 | 1093598 | 2021-03-06 | Jackson | Louisiana | 22049 | 1792 | 47 |
1090352 | 1090352 | 2021-03-05 | Jackson | Louisiana | 22049 | 1792 | 47 |
1087107 | 1087107 | 2021-03-04 | Jackson | Louisiana | 22049 | 1789 | 47 |
1083861 | 1083861 | 2021-03-03 | Jackson | Louisiana | 22049 | 1789 | 47 |
1080615 | 1080615 | 2021-03-02 | Jackson | Louisiana | 22049 | 1781 | 47 |
1077370 | 1077370 | 2021-03-01 | Jackson | Louisiana | 22049 | 1786 | 47 |
1074124 | 1074124 | 2021-02-28 | Jackson | Louisiana | 22049 | 1776 | 47 |
1070878 | 1070878 | 2021-02-27 | Jackson | Louisiana | 22049 | 1777 | 47 |
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);