ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
146 rows where deaths = 127 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 24
county 24
- St. Charles 42
- Washington 13
- Avoyelles 12
- Vermilion 11
- Jefferson Davis 9
- Natchitoches 7
- Beauregard 6
- Morehouse 6
- St. Mary 6
- Tangipahoa 6
- Lincoln 5
- Calcasieu 4
- Iberville 4
- Bossier 3
- Iberia 3
- Acadia 1
- De Soto 1
- East Feliciana 1
- Ouachita 1
- Rapides 1
- St. John the Baptist 1
- St. Martin 1
- Union 1
- Vernon 1
state 1
- Louisiana · 146 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2269676 | 2269676 | 2022-03-03 | Union | Louisiana | 22111 | 6889 | 127 |
2198120 | 2198120 | 2022-02-09 | Morehouse | Louisiana | 22067 | 6704 | 127 |
2194863 | 2194863 | 2022-02-08 | Lincoln | Louisiana | 22061 | 11842 | 127 |
2194866 | 2194866 | 2022-02-08 | Morehouse | Louisiana | 22067 | 6691 | 127 |
2191594 | 2191594 | 2022-02-07 | De Soto | Louisiana | 22031 | 7199 | 127 |
2191609 | 2191609 | 2022-02-07 | Lincoln | Louisiana | 22061 | 11775 | 127 |
2191612 | 2191612 | 2022-02-07 | Morehouse | Louisiana | 22067 | 6669 | 127 |
2188356 | 2188356 | 2022-02-06 | Lincoln | Louisiana | 22061 | 11712 | 127 |
2188359 | 2188359 | 2022-02-06 | Morehouse | Louisiana | 22067 | 6636 | 127 |
2185103 | 2185103 | 2022-02-05 | Lincoln | Louisiana | 22061 | 11712 | 127 |
2185106 | 2185106 | 2022-02-05 | Morehouse | Louisiana | 22067 | 6636 | 127 |
2181851 | 2181851 | 2022-02-04 | Lincoln | Louisiana | 22061 | 11712 | 127 |
2181854 | 2181854 | 2022-02-04 | Morehouse | Louisiana | 22067 | 6636 | 127 |
2015986 | 2015986 | 2021-12-15 | Beauregard | Louisiana | 22011 | 6208 | 127 |
2012735 | 2012735 | 2021-12-14 | Beauregard | Louisiana | 22011 | 6201 | 127 |
2009484 | 2009484 | 2021-12-13 | Beauregard | Louisiana | 22011 | 6197 | 127 |
2006233 | 2006233 | 2021-12-12 | Beauregard | Louisiana | 22011 | 6196 | 127 |
2002982 | 2002982 | 2021-12-11 | Beauregard | Louisiana | 22011 | 6196 | 127 |
1999732 | 1999732 | 2021-12-10 | Beauregard | Louisiana | 22011 | 6196 | 127 |
1967269 | 1967269 | 2021-11-30 | St. Charles | Louisiana | 22089 | 8987 | 127 |
1964017 | 1964017 | 2021-11-29 | St. Charles | Louisiana | 22089 | 8967 | 127 |
1960766 | 1960766 | 2021-11-28 | St. Charles | Louisiana | 22089 | 8941 | 127 |
1957515 | 1957515 | 2021-11-27 | St. Charles | Louisiana | 22089 | 8941 | 127 |
1954264 | 1954264 | 2021-11-26 | St. Charles | Louisiana | 22089 | 8941 | 127 |
1951013 | 1951013 | 2021-11-25 | St. Charles | Louisiana | 22089 | 8941 | 127 |
1947762 | 1947762 | 2021-11-24 | St. Charles | Louisiana | 22089 | 8941 | 127 |
1944511 | 1944511 | 2021-11-23 | St. Charles | Louisiana | 22089 | 8941 | 127 |
1941261 | 1941261 | 2021-11-22 | St. Charles | Louisiana | 22089 | 8941 | 127 |
1938011 | 1938011 | 2021-11-21 | St. Charles | Louisiana | 22089 | 8933 | 127 |
1934761 | 1934761 | 2021-11-20 | St. Charles | Louisiana | 22089 | 8933 | 127 |
1931510 | 1931510 | 2021-11-19 | St. Charles | Louisiana | 22089 | 8933 | 127 |
1928259 | 1928259 | 2021-11-18 | St. Charles | Louisiana | 22089 | 8933 | 127 |
1925009 | 1925009 | 2021-11-17 | St. Charles | Louisiana | 22089 | 8927 | 127 |
1921760 | 1921760 | 2021-11-16 | St. Charles | Louisiana | 22089 | 8925 | 127 |
1918489 | 1918489 | 2021-11-15 | Iberville | Louisiana | 22047 | 5857 | 127 |
1918510 | 1918510 | 2021-11-15 | St. Charles | Louisiana | 22089 | 8923 | 127 |
1915239 | 1915239 | 2021-11-14 | Iberville | Louisiana | 22047 | 5853 | 127 |
1915260 | 1915260 | 2021-11-14 | St. Charles | Louisiana | 22089 | 8921 | 127 |
1911989 | 1911989 | 2021-11-13 | Iberville | Louisiana | 22047 | 5853 | 127 |
1912010 | 1912010 | 2021-11-13 | St. Charles | Louisiana | 22089 | 8921 | 127 |
1908740 | 1908740 | 2021-11-12 | Iberville | Louisiana | 22047 | 5853 | 127 |
1908761 | 1908761 | 2021-11-12 | St. Charles | Louisiana | 22089 | 8921 | 127 |
1905494 | 1905494 | 2021-11-11 | Jefferson Davis | Louisiana | 22053 | 4756 | 127 |
1905512 | 1905512 | 2021-11-11 | St. Charles | Louisiana | 22089 | 8911 | 127 |
1902244 | 1902244 | 2021-11-10 | Jefferson Davis | Louisiana | 22053 | 4756 | 127 |
1902262 | 1902262 | 2021-11-10 | St. Charles | Louisiana | 22089 | 8911 | 127 |
1898994 | 1898994 | 2021-11-09 | Jefferson Davis | Louisiana | 22053 | 4753 | 127 |
1899012 | 1899012 | 2021-11-09 | St. Charles | Louisiana | 22089 | 8910 | 127 |
1895744 | 1895744 | 2021-11-08 | Jefferson Davis | Louisiana | 22053 | 4748 | 127 |
1895762 | 1895762 | 2021-11-08 | St. Charles | Louisiana | 22089 | 8910 | 127 |
1892494 | 1892494 | 2021-11-07 | Jefferson Davis | Louisiana | 22053 | 4738 | 127 |
1892512 | 1892512 | 2021-11-07 | St. Charles | Louisiana | 22089 | 8904 | 127 |
1889244 | 1889244 | 2021-11-06 | Jefferson Davis | Louisiana | 22053 | 4738 | 127 |
1889262 | 1889262 | 2021-11-06 | St. Charles | Louisiana | 22089 | 8904 | 127 |
1885994 | 1885994 | 2021-11-05 | Jefferson Davis | Louisiana | 22053 | 4738 | 127 |
1886012 | 1886012 | 2021-11-05 | St. Charles | Louisiana | 22089 | 8904 | 127 |
1882745 | 1882745 | 2021-11-04 | Jefferson Davis | Louisiana | 22053 | 4737 | 127 |
1882763 | 1882763 | 2021-11-04 | St. Charles | Louisiana | 22089 | 8896 | 127 |
1879496 | 1879496 | 2021-11-03 | Jefferson Davis | Louisiana | 22053 | 4730 | 127 |
1879514 | 1879514 | 2021-11-03 | St. Charles | Louisiana | 22089 | 8894 | 127 |
1876265 | 1876265 | 2021-11-02 | St. Charles | Louisiana | 22089 | 8890 | 127 |
1873016 | 1873016 | 2021-11-01 | St. Charles | Louisiana | 22089 | 8888 | 127 |
1869767 | 1869767 | 2021-10-31 | St. Charles | Louisiana | 22089 | 8872 | 127 |
1866518 | 1866518 | 2021-10-30 | St. Charles | Louisiana | 22089 | 8872 | 127 |
1863269 | 1863269 | 2021-10-29 | St. Charles | Louisiana | 22089 | 8872 | 127 |
1860020 | 1860020 | 2021-10-28 | St. Charles | Louisiana | 22089 | 8869 | 127 |
1856771 | 1856771 | 2021-10-27 | St. Charles | Louisiana | 22089 | 8867 | 127 |
1853522 | 1853522 | 2021-10-26 | St. Charles | Louisiana | 22089 | 8865 | 127 |
1850273 | 1850273 | 2021-10-25 | St. Charles | Louisiana | 22089 | 8860 | 127 |
1847023 | 1847023 | 2021-10-24 | St. Charles | Louisiana | 22089 | 8848 | 127 |
1843773 | 1843773 | 2021-10-23 | St. Charles | Louisiana | 22089 | 8848 | 127 |
1840523 | 1840523 | 2021-10-22 | St. Charles | Louisiana | 22089 | 8848 | 127 |
1837274 | 1837274 | 2021-10-21 | St. Charles | Louisiana | 22089 | 8845 | 127 |
1834025 | 1834025 | 2021-10-20 | St. Charles | Louisiana | 22089 | 8836 | 127 |
1782031 | 1782031 | 2021-10-04 | Natchitoches | Louisiana | 22069 | 6435 | 127 |
1778781 | 1778781 | 2021-10-03 | Natchitoches | Louisiana | 22069 | 6419 | 127 |
1775531 | 1775531 | 2021-10-02 | Natchitoches | Louisiana | 22069 | 6419 | 127 |
1772281 | 1772281 | 2021-10-01 | Natchitoches | Louisiana | 22069 | 6419 | 127 |
1769032 | 1769032 | 2021-09-30 | Natchitoches | Louisiana | 22069 | 6408 | 127 |
1765783 | 1765783 | 2021-09-29 | Natchitoches | Louisiana | 22069 | 6403 | 127 |
1762534 | 1762534 | 2021-09-28 | Natchitoches | Louisiana | 22069 | 6384 | 127 |
1645611 | 1645611 | 2021-08-23 | Vernon | Louisiana | 22115 | 4599 | 127 |
1632603 | 1632603 | 2021-08-19 | St. Martin | Louisiana | 22099 | 7320 | 127 |
1626078 | 1626078 | 2021-08-17 | East Feliciana | Louisiana | 22037 | 4046 | 127 |
1577334 | 1577334 | 2021-08-02 | Avoyelles | Louisiana | 22009 | 4787 | 127 |
1574086 | 1574086 | 2021-08-01 | Avoyelles | Louisiana | 22009 | 4714 | 127 |
1570838 | 1570838 | 2021-07-31 | Avoyelles | Louisiana | 22009 | 4714 | 127 |
1567590 | 1567590 | 2021-07-30 | Avoyelles | Louisiana | 22009 | 4714 | 127 |
1564342 | 1564342 | 2021-07-29 | Avoyelles | Louisiana | 22009 | 4672 | 127 |
1561094 | 1561094 | 2021-07-28 | Avoyelles | Louisiana | 22009 | 4638 | 127 |
1557847 | 1557847 | 2021-07-27 | Avoyelles | Louisiana | 22009 | 4587 | 127 |
1554600 | 1554600 | 2021-07-26 | Avoyelles | Louisiana | 22009 | 4569 | 127 |
1551353 | 1551353 | 2021-07-25 | Avoyelles | Louisiana | 22009 | 4528 | 127 |
1551406 | 1551406 | 2021-07-25 | Vermilion | Louisiana | 22113 | 6150 | 127 |
1548106 | 1548106 | 2021-07-24 | Avoyelles | Louisiana | 22009 | 4528 | 127 |
1548159 | 1548159 | 2021-07-24 | Vermilion | Louisiana | 22113 | 6150 | 127 |
1544859 | 1544859 | 2021-07-23 | Avoyelles | Louisiana | 22009 | 4528 | 127 |
1544912 | 1544912 | 2021-07-23 | Vermilion | Louisiana | 22113 | 6150 | 127 |
1541611 | 1541611 | 2021-07-22 | Avoyelles | Louisiana | 22009 | 4519 | 127 |
1541664 | 1541664 | 2021-07-22 | Vermilion | Louisiana | 22113 | 6109 | 127 |
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);