ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
302 rows where deaths = 42 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- West Baton Rouge 42
- Red River 34
- West Feliciana 29
- West Carroll 20
- Plaquemines 19
- Caldwell 17
- Pointe Coupee 16
- Iberia 13
- Tangipahoa 13
- Winn 10
- Union 9
- Jefferson Davis 7
- Iberville 6
- Richland 6
- Washington 6
- Webster 6
- St. Charles 5
- St. Martin 5
- Grant 4
- Bienville 3
- Lincoln 3
- Livingston 3
- Madison 3
- St. Mary 3
- Assumption 2
- Calcasieu 2
- St. Bernard 2
- St. James 2
- Acadia 1
- Avoyelles 1
- …
state 1
- Louisiana · 302 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2263180 | 2263180 | 2022-03-01 | West Feliciana | Louisiana | 22125 | 2820 | 42 |
2259929 | 2259929 | 2022-02-28 | West Feliciana | Louisiana | 22125 | 2820 | 42 |
2256678 | 2256678 | 2022-02-27 | West Feliciana | Louisiana | 22125 | 2820 | 42 |
2253427 | 2253427 | 2022-02-26 | West Feliciana | Louisiana | 22125 | 2820 | 42 |
2250176 | 2250176 | 2022-02-25 | West Feliciana | Louisiana | 22125 | 2820 | 42 |
2246925 | 2246925 | 2022-02-24 | West Feliciana | Louisiana | 22125 | 2819 | 42 |
2243674 | 2243674 | 2022-02-23 | West Feliciana | Louisiana | 22125 | 2819 | 42 |
2240423 | 2240423 | 2022-02-22 | West Feliciana | Louisiana | 22125 | 2818 | 42 |
2237172 | 2237172 | 2022-02-21 | West Feliciana | Louisiana | 22125 | 2816 | 42 |
2233921 | 2233921 | 2022-02-20 | West Feliciana | Louisiana | 22125 | 2814 | 42 |
2230670 | 2230670 | 2022-02-19 | West Feliciana | Louisiana | 22125 | 2814 | 42 |
2227419 | 2227419 | 2022-02-18 | West Feliciana | Louisiana | 22125 | 2814 | 42 |
2224168 | 2224168 | 2022-02-17 | West Feliciana | Louisiana | 22125 | 2814 | 42 |
2220917 | 2220917 | 2022-02-16 | West Feliciana | Louisiana | 22125 | 2805 | 42 |
2217666 | 2217666 | 2022-02-15 | West Feliciana | Louisiana | 22125 | 2804 | 42 |
2214389 | 2214389 | 2022-02-14 | Plaquemines | Louisiana | 22075 | 6333 | 42 |
2214415 | 2214415 | 2022-02-14 | West Feliciana | Louisiana | 22125 | 2800 | 42 |
2211137 | 2211137 | 2022-02-13 | Plaquemines | Louisiana | 22075 | 6323 | 42 |
2211163 | 2211163 | 2022-02-13 | West Feliciana | Louisiana | 22125 | 2791 | 42 |
2207884 | 2207884 | 2022-02-12 | Plaquemines | Louisiana | 22075 | 6323 | 42 |
2207910 | 2207910 | 2022-02-12 | West Feliciana | Louisiana | 22125 | 2791 | 42 |
2204631 | 2204631 | 2022-02-11 | Plaquemines | Louisiana | 22075 | 6323 | 42 |
2204657 | 2204657 | 2022-02-11 | West Feliciana | Louisiana | 22125 | 2791 | 42 |
2201378 | 2201378 | 2022-02-10 | Plaquemines | Louisiana | 22075 | 6319 | 42 |
2201404 | 2201404 | 2022-02-10 | West Feliciana | Louisiana | 22125 | 2789 | 42 |
2198124 | 2198124 | 2022-02-09 | Plaquemines | Louisiana | 22075 | 6316 | 42 |
2198150 | 2198150 | 2022-02-09 | West Feliciana | Louisiana | 22125 | 2773 | 42 |
2194870 | 2194870 | 2022-02-08 | Plaquemines | Louisiana | 22075 | 6308 | 42 |
2194896 | 2194896 | 2022-02-08 | West Feliciana | Louisiana | 22125 | 2765 | 42 |
2191616 | 2191616 | 2022-02-07 | Plaquemines | Louisiana | 22075 | 6290 | 42 |
2191642 | 2191642 | 2022-02-07 | West Feliciana | Louisiana | 22125 | 2762 | 42 |
2188363 | 2188363 | 2022-02-06 | Plaquemines | Louisiana | 22075 | 6272 | 42 |
2188389 | 2188389 | 2022-02-06 | West Feliciana | Louisiana | 22125 | 2745 | 42 |
2185110 | 2185110 | 2022-02-05 | Plaquemines | Louisiana | 22075 | 6272 | 42 |
2185136 | 2185136 | 2022-02-05 | West Feliciana | Louisiana | 22125 | 2745 | 42 |
2181858 | 2181858 | 2022-02-04 | Plaquemines | Louisiana | 22075 | 6272 | 42 |
2181884 | 2181884 | 2022-02-04 | West Feliciana | Louisiana | 22125 | 2745 | 42 |
2178607 | 2178607 | 2022-02-03 | Plaquemines | Louisiana | 22075 | 6262 | 42 |
2178633 | 2178633 | 2022-02-03 | West Feliciana | Louisiana | 22125 | 2735 | 42 |
2175354 | 2175354 | 2022-02-02 | Plaquemines | Louisiana | 22075 | 6233 | 42 |
2175380 | 2175380 | 2022-02-02 | West Feliciana | Louisiana | 22125 | 2704 | 42 |
2172101 | 2172101 | 2022-02-01 | Plaquemines | Louisiana | 22075 | 6221 | 42 |
2172127 | 2172127 | 2022-02-01 | West Feliciana | Louisiana | 22125 | 2694 | 42 |
2168848 | 2168848 | 2022-01-31 | Plaquemines | Louisiana | 22075 | 6192 | 42 |
2165593 | 2165593 | 2022-01-30 | Plaquemines | Louisiana | 22075 | 6142 | 42 |
2162338 | 2162338 | 2022-01-29 | Plaquemines | Louisiana | 22075 | 6142 | 42 |
2159083 | 2159083 | 2022-01-28 | Plaquemines | Louisiana | 22075 | 6142 | 42 |
2155829 | 2155829 | 2022-01-27 | Plaquemines | Louisiana | 22075 | 6119 | 42 |
2087502 | 2087502 | 2022-01-06 | Caldwell | Louisiana | 22021 | 2436 | 42 |
2084250 | 2084250 | 2022-01-05 | Caldwell | Louisiana | 22021 | 2413 | 42 |
2080998 | 2080998 | 2022-01-04 | Caldwell | Louisiana | 22021 | 2405 | 42 |
2077746 | 2077746 | 2022-01-03 | Caldwell | Louisiana | 22021 | 2391 | 42 |
2074495 | 2074495 | 2022-01-02 | Caldwell | Louisiana | 22021 | 2360 | 42 |
2071244 | 2071244 | 2022-01-01 | Caldwell | Louisiana | 22021 | 2360 | 42 |
2067993 | 2067993 | 2021-12-31 | Caldwell | Louisiana | 22021 | 2360 | 42 |
2064742 | 2064742 | 2021-12-30 | Caldwell | Louisiana | 22021 | 2360 | 42 |
2061492 | 2061492 | 2021-12-29 | Caldwell | Louisiana | 22021 | 2359 | 42 |
2058243 | 2058243 | 2021-12-28 | Caldwell | Louisiana | 22021 | 2352 | 42 |
2054994 | 2054994 | 2021-12-27 | Caldwell | Louisiana | 22021 | 2347 | 42 |
2051744 | 2051744 | 2021-12-26 | Caldwell | Louisiana | 22021 | 2342 | 42 |
2048494 | 2048494 | 2021-12-25 | Caldwell | Louisiana | 22021 | 2342 | 42 |
2045244 | 2045244 | 2021-12-24 | Caldwell | Louisiana | 22021 | 2342 | 42 |
2041995 | 2041995 | 2021-12-23 | Caldwell | Louisiana | 22021 | 2342 | 42 |
2038745 | 2038745 | 2021-12-22 | Caldwell | Louisiana | 22021 | 2339 | 42 |
2035495 | 2035495 | 2021-12-21 | Caldwell | Louisiana | 22021 | 2338 | 42 |
1759292 | 1759292 | 2021-09-27 | Red River | Louisiana | 22081 | 1364 | 42 |
1756044 | 1756044 | 2021-09-26 | Red River | Louisiana | 22081 | 1353 | 42 |
1752796 | 1752796 | 2021-09-25 | Red River | Louisiana | 22081 | 1353 | 42 |
1749547 | 1749547 | 2021-09-24 | Red River | Louisiana | 22081 | 1353 | 42 |
1746297 | 1746297 | 2021-09-23 | Red River | Louisiana | 22081 | 1352 | 42 |
1743048 | 1743048 | 2021-09-22 | Red River | Louisiana | 22081 | 1345 | 42 |
1739799 | 1739799 | 2021-09-21 | Red River | Louisiana | 22081 | 1341 | 42 |
1736550 | 1736550 | 2021-09-20 | Red River | Louisiana | 22081 | 1332 | 42 |
1733300 | 1733300 | 2021-09-19 | Red River | Louisiana | 22081 | 1325 | 42 |
1730050 | 1730050 | 2021-09-18 | Red River | Louisiana | 22081 | 1325 | 42 |
1726800 | 1726800 | 2021-09-17 | Red River | Louisiana | 22081 | 1325 | 42 |
1723551 | 1723551 | 2021-09-16 | Red River | Louisiana | 22081 | 1320 | 42 |
1720302 | 1720302 | 2021-09-15 | Red River | Louisiana | 22081 | 1314 | 42 |
1713808 | 1713808 | 2021-09-13 | Red River | Louisiana | 22081 | 1293 | 42 |
1710561 | 1710561 | 2021-09-12 | Red River | Louisiana | 22081 | 1277 | 42 |
1707314 | 1707314 | 2021-09-11 | Red River | Louisiana | 22081 | 1277 | 42 |
1704066 | 1704066 | 2021-09-10 | Red River | Louisiana | 22081 | 1277 | 42 |
1700816 | 1700816 | 2021-09-09 | Red River | Louisiana | 22081 | 1259 | 42 |
1697567 | 1697567 | 2021-09-08 | Red River | Louisiana | 22081 | 1250 | 42 |
1694319 | 1694319 | 2021-09-07 | Red River | Louisiana | 22081 | 1236 | 42 |
1691070 | 1691070 | 2021-09-06 | Red River | Louisiana | 22081 | 1212 | 42 |
1687820 | 1687820 | 2021-09-05 | Red River | Louisiana | 22081 | 1212 | 42 |
1684570 | 1684570 | 2021-09-04 | Red River | Louisiana | 22081 | 1212 | 42 |
1681319 | 1681319 | 2021-09-03 | Red River | Louisiana | 22081 | 1212 | 42 |
1678071 | 1678071 | 2021-09-02 | Red River | Louisiana | 22081 | 1200 | 42 |
1674824 | 1674824 | 2021-09-01 | Red River | Louisiana | 22081 | 1181 | 42 |
1671575 | 1671575 | 2021-08-31 | Red River | Louisiana | 22081 | 1158 | 42 |
1668328 | 1668328 | 2021-08-30 | Red River | Louisiana | 22081 | 1158 | 42 |
1665081 | 1665081 | 2021-08-29 | Red River | Louisiana | 22081 | 1158 | 42 |
1661833 | 1661833 | 2021-08-28 | Red River | Louisiana | 22081 | 1158 | 42 |
1658585 | 1658585 | 2021-08-27 | Red River | Louisiana | 22081 | 1158 | 42 |
1655337 | 1655337 | 2021-08-26 | Red River | Louisiana | 22081 | 1141 | 42 |
1652090 | 1652090 | 2021-08-25 | Red River | Louisiana | 22081 | 1123 | 42 |
1648804 | 1648804 | 2021-08-24 | Assumption | Louisiana | 22007 | 3273 | 42 |
1645556 | 1645556 | 2021-08-23 | Assumption | Louisiana | 22007 | 3260 | 42 |
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);