ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
256 rows where deaths = 100 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 30
county 30
- Iberville 61
- Bienville 34
- Franklin 30
- Evangeline 23
- Sabine 16
- Ascension 15
- Lincoln 15
- Acadia 9
- St. John the Baptist 7
- Union 6
- De Soto 5
- Jefferson Davis 5
- Natchitoches 5
- Avoyelles 4
- Lafayette 4
- Vernon 2
- Webster 2
- Beauregard 1
- Bossier 1
- Caddo 1
- East Baton Rouge 1
- Lafourche 1
- Livingston 1
- Ouachita 1
- Rapides 1
- St. Bernard 1
- St. Charles 1
- St. Mary 1
- St. Tammany 1
- Vermilion 1
state 1
- Louisiana · 256 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2152581 | 2152581 | 2022-01-26 | Sabine | Louisiana | 22085 | 5950 | 100 |
2149329 | 2149329 | 2022-01-25 | Sabine | Louisiana | 22085 | 5636 | 100 |
2146077 | 2146077 | 2022-01-24 | Sabine | Louisiana | 22085 | 5587 | 100 |
2142822 | 2142822 | 2022-01-23 | Sabine | Louisiana | 22085 | 5535 | 100 |
2139567 | 2139567 | 2022-01-22 | Sabine | Louisiana | 22085 | 5535 | 100 |
2136311 | 2136311 | 2022-01-21 | Sabine | Louisiana | 22085 | 5535 | 100 |
2133059 | 2133059 | 2022-01-20 | Sabine | Louisiana | 22085 | 5512 | 100 |
2129806 | 2129806 | 2022-01-19 | Sabine | Louisiana | 22085 | 5477 | 100 |
2126552 | 2126552 | 2022-01-18 | Sabine | Louisiana | 22085 | 5402 | 100 |
2123264 | 2123264 | 2022-01-17 | Bienville | Louisiana | 22013 | 3078 | 100 |
2123300 | 2123300 | 2022-01-17 | Sabine | Louisiana | 22085 | 5341 | 100 |
2120012 | 2120012 | 2022-01-16 | Bienville | Louisiana | 22013 | 3078 | 100 |
2120048 | 2120048 | 2022-01-16 | Sabine | Louisiana | 22085 | 5341 | 100 |
2116760 | 2116760 | 2022-01-15 | Bienville | Louisiana | 22013 | 3078 | 100 |
2116796 | 2116796 | 2022-01-15 | Sabine | Louisiana | 22085 | 5341 | 100 |
2113509 | 2113509 | 2022-01-14 | Bienville | Louisiana | 22013 | 3078 | 100 |
2113545 | 2113545 | 2022-01-14 | Sabine | Louisiana | 22085 | 5341 | 100 |
2110257 | 2110257 | 2022-01-13 | Bienville | Louisiana | 22013 | 2968 | 100 |
2110293 | 2110293 | 2022-01-13 | Sabine | Louisiana | 22085 | 5234 | 100 |
2107006 | 2107006 | 2022-01-12 | Bienville | Louisiana | 22013 | 2968 | 100 |
2107042 | 2107042 | 2022-01-12 | Sabine | Louisiana | 22085 | 5234 | 100 |
2103755 | 2103755 | 2022-01-11 | Bienville | Louisiana | 22013 | 2968 | 100 |
2103791 | 2103791 | 2022-01-11 | Sabine | Louisiana | 22085 | 5234 | 100 |
2100504 | 2100504 | 2022-01-10 | Bienville | Louisiana | 22013 | 2931 | 100 |
2100541 | 2100541 | 2022-01-10 | St. Bernard | Louisiana | 22087 | 8893 | 100 |
2097253 | 2097253 | 2022-01-09 | Bienville | Louisiana | 22013 | 2835 | 100 |
2094001 | 2094001 | 2022-01-08 | Bienville | Louisiana | 22013 | 2835 | 100 |
2090749 | 2090749 | 2022-01-07 | Bienville | Louisiana | 22013 | 2835 | 100 |
2087498 | 2087498 | 2022-01-06 | Bienville | Louisiana | 22013 | 2807 | 100 |
2084246 | 2084246 | 2022-01-05 | Bienville | Louisiana | 22013 | 2758 | 100 |
2080994 | 2080994 | 2022-01-04 | Bienville | Louisiana | 22013 | 2736 | 100 |
2077742 | 2077742 | 2022-01-03 | Bienville | Louisiana | 22013 | 2718 | 100 |
2074491 | 2074491 | 2022-01-02 | Bienville | Louisiana | 22013 | 2641 | 100 |
2071240 | 2071240 | 2022-01-01 | Bienville | Louisiana | 22013 | 2641 | 100 |
2067989 | 2067989 | 2021-12-31 | Bienville | Louisiana | 22013 | 2641 | 100 |
2064738 | 2064738 | 2021-12-30 | Bienville | Louisiana | 22013 | 2641 | 100 |
2061488 | 2061488 | 2021-12-29 | Bienville | Louisiana | 22013 | 2610 | 100 |
2058239 | 2058239 | 2021-12-28 | Bienville | Louisiana | 22013 | 2584 | 100 |
2054990 | 2054990 | 2021-12-27 | Bienville | Louisiana | 22013 | 2571 | 100 |
2051740 | 2051740 | 2021-12-26 | Bienville | Louisiana | 22013 | 2557 | 100 |
2048490 | 2048490 | 2021-12-25 | Bienville | Louisiana | 22013 | 2557 | 100 |
2045240 | 2045240 | 2021-12-24 | Bienville | Louisiana | 22013 | 2557 | 100 |
2041991 | 2041991 | 2021-12-23 | Bienville | Louisiana | 22013 | 2557 | 100 |
2038741 | 2038741 | 2021-12-22 | Bienville | Louisiana | 22013 | 2554 | 100 |
2035491 | 2035491 | 2021-12-21 | Bienville | Louisiana | 22013 | 2548 | 100 |
2032241 | 2032241 | 2021-12-20 | Bienville | Louisiana | 22013 | 2547 | 100 |
2028990 | 2028990 | 2021-12-19 | Bienville | Louisiana | 22013 | 2540 | 100 |
2025739 | 2025739 | 2021-12-18 | Bienville | Louisiana | 22013 | 2540 | 100 |
2022488 | 2022488 | 2021-12-17 | Bienville | Louisiana | 22013 | 2540 | 100 |
2019237 | 2019237 | 2021-12-16 | Bienville | Louisiana | 22013 | 2538 | 100 |
2015987 | 2015987 | 2021-12-15 | Bienville | Louisiana | 22013 | 2537 | 100 |
1785301 | 1785301 | 2021-10-05 | Union | Louisiana | 22111 | 3904 | 100 |
1782052 | 1782052 | 2021-10-04 | Union | Louisiana | 22111 | 3895 | 100 |
1778802 | 1778802 | 2021-10-03 | Union | Louisiana | 22111 | 3884 | 100 |
1775552 | 1775552 | 2021-10-02 | Union | Louisiana | 22111 | 3884 | 100 |
1772302 | 1772302 | 2021-10-01 | Union | Louisiana | 22111 | 3884 | 100 |
1769053 | 1769053 | 2021-09-30 | Union | Louisiana | 22111 | 3873 | 100 |
1710536 | 1710536 | 2021-09-12 | De Soto | Louisiana | 22031 | 4414 | 100 |
1707289 | 1707289 | 2021-09-11 | De Soto | Louisiana | 22031 | 4414 | 100 |
1704041 | 1704041 | 2021-09-10 | De Soto | Louisiana | 22031 | 4414 | 100 |
1700791 | 1700791 | 2021-09-09 | De Soto | Louisiana | 22031 | 4405 | 100 |
1697542 | 1697542 | 2021-09-08 | De Soto | Louisiana | 22031 | 4386 | 100 |
1694284 | 1694284 | 2021-09-07 | Beauregard | Louisiana | 22011 | 5258 | 100 |
1671565 | 1671565 | 2021-08-31 | Lincoln | Louisiana | 22061 | 5984 | 100 |
1668318 | 1668318 | 2021-08-30 | Lincoln | Louisiana | 22061 | 5984 | 100 |
1665071 | 1665071 | 2021-08-29 | Lincoln | Louisiana | 22061 | 5984 | 100 |
1661823 | 1661823 | 2021-08-28 | Lincoln | Louisiana | 22061 | 5984 | 100 |
1658575 | 1658575 | 2021-08-27 | Lincoln | Louisiana | 22061 | 5984 | 100 |
1655327 | 1655327 | 2021-08-26 | Lincoln | Louisiana | 22061 | 5952 | 100 |
1652080 | 1652080 | 2021-08-25 | Lincoln | Louisiana | 22061 | 5917 | 100 |
1648831 | 1648831 | 2021-08-24 | Lincoln | Louisiana | 22061 | 5851 | 100 |
1645583 | 1645583 | 2021-08-23 | Lincoln | Louisiana | 22061 | 5827 | 100 |
1642334 | 1642334 | 2021-08-22 | Lincoln | Louisiana | 22061 | 5822 | 100 |
1639084 | 1639084 | 2021-08-21 | Lincoln | Louisiana | 22061 | 5822 | 100 |
1635834 | 1635834 | 2021-08-20 | Lincoln | Louisiana | 22061 | 5822 | 100 |
1632584 | 1632584 | 2021-08-19 | Lincoln | Louisiana | 22061 | 5782 | 100 |
1629337 | 1629337 | 2021-08-18 | Lincoln | Louisiana | 22061 | 5747 | 100 |
1626090 | 1626090 | 2021-08-17 | Lincoln | Louisiana | 22061 | 5683 | 100 |
1622847 | 1622847 | 2021-08-16 | Natchitoches | Louisiana | 22069 | 4908 | 100 |
1619600 | 1619600 | 2021-08-15 | Natchitoches | Louisiana | 22069 | 4831 | 100 |
1616352 | 1616352 | 2021-08-14 | Natchitoches | Louisiana | 22069 | 4831 | 100 |
1613103 | 1613103 | 2021-08-13 | Natchitoches | Louisiana | 22069 | 4831 | 100 |
1609840 | 1609840 | 2021-08-12 | Evangeline | Louisiana | 22039 | 4437 | 100 |
1609855 | 1609855 | 2021-08-12 | Natchitoches | Louisiana | 22069 | 4781 | 100 |
1606591 | 1606591 | 2021-08-11 | Evangeline | Louisiana | 22039 | 4380 | 100 |
1603342 | 1603342 | 2021-08-10 | Evangeline | Louisiana | 22039 | 4343 | 100 |
1600093 | 1600093 | 2021-08-09 | Evangeline | Louisiana | 22039 | 4295 | 100 |
1596845 | 1596845 | 2021-08-08 | Evangeline | Louisiana | 22039 | 4205 | 100 |
1596852 | 1596852 | 2021-08-08 | Jefferson Davis | Louisiana | 22053 | 3595 | 100 |
1593596 | 1593596 | 2021-08-07 | Evangeline | Louisiana | 22039 | 4205 | 100 |
1593603 | 1593603 | 2021-08-07 | Jefferson Davis | Louisiana | 22053 | 3595 | 100 |
1590347 | 1590347 | 2021-08-06 | Evangeline | Louisiana | 22039 | 4205 | 100 |
1590354 | 1590354 | 2021-08-06 | Jefferson Davis | Louisiana | 22053 | 3595 | 100 |
1587098 | 1587098 | 2021-08-05 | Evangeline | Louisiana | 22039 | 4147 | 100 |
1587105 | 1587105 | 2021-08-05 | Jefferson Davis | Louisiana | 22053 | 3569 | 100 |
1583848 | 1583848 | 2021-08-04 | Evangeline | Louisiana | 22039 | 4122 | 100 |
1583855 | 1583855 | 2021-08-04 | Jefferson Davis | Louisiana | 22053 | 3549 | 100 |
1580598 | 1580598 | 2021-08-03 | Evangeline | Louisiana | 22039 | 4089 | 100 |
1580623 | 1580623 | 2021-08-03 | St. Charles | Louisiana | 22089 | 6859 | 100 |
1577349 | 1577349 | 2021-08-02 | Evangeline | Louisiana | 22039 | 4019 | 100 |
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);