ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
260 rows where deaths = 92 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Allen 73
- Lincoln 27
- Pointe Coupee 21
- Evangeline 16
- Ascension 11
- Webster 11
- Union 10
- Bienville 9
- Bossier 8
- Iberville 7
- Richland 7
- St. John the Baptist 7
- Natchitoches 6
- Franklin 5
- Morehouse 5
- Acadia 4
- Calcasieu 4
- Iberia 4
- St. Charles 4
- Lafourche 3
- Vernon 3
- Jefferson Davis 2
- St. Landry 2
- St. Martin 2
- Avoyelles 1
- Caddo 1
- East Feliciana 1
- Livingston 1
- Ouachita 1
- Rapides 1
- …
state 1
- Louisiana · 260 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2403042 | 2403042 | 2022-04-13 | Pointe Coupee | Louisiana | 22077 | 6270 | 92 |
2399788 | 2399788 | 2022-04-12 | Pointe Coupee | Louisiana | 22077 | 6270 | 92 |
2396532 | 2396532 | 2022-04-11 | Pointe Coupee | Louisiana | 22077 | 6269 | 92 |
2393277 | 2393277 | 2022-04-10 | Pointe Coupee | Louisiana | 22077 | 6269 | 92 |
2390021 | 2390021 | 2022-04-09 | Pointe Coupee | Louisiana | 22077 | 6269 | 92 |
2386765 | 2386765 | 2022-04-08 | Pointe Coupee | Louisiana | 22077 | 6269 | 92 |
2383510 | 2383510 | 2022-04-07 | Pointe Coupee | Louisiana | 22077 | 6268 | 92 |
2380255 | 2380255 | 2022-04-06 | Pointe Coupee | Louisiana | 22077 | 6268 | 92 |
2377000 | 2377000 | 2022-04-05 | Pointe Coupee | Louisiana | 22077 | 6268 | 92 |
2373748 | 2373748 | 2022-04-04 | Pointe Coupee | Louisiana | 22077 | 6267 | 92 |
2370495 | 2370495 | 2022-04-03 | Pointe Coupee | Louisiana | 22077 | 6267 | 92 |
2367242 | 2367242 | 2022-04-02 | Pointe Coupee | Louisiana | 22077 | 6267 | 92 |
2363989 | 2363989 | 2022-04-01 | Pointe Coupee | Louisiana | 22077 | 6267 | 92 |
2360735 | 2360735 | 2022-03-31 | Pointe Coupee | Louisiana | 22077 | 6265 | 92 |
2357481 | 2357481 | 2022-03-30 | Pointe Coupee | Louisiana | 22077 | 6265 | 92 |
2354228 | 2354228 | 2022-03-29 | Pointe Coupee | Louisiana | 22077 | 6264 | 92 |
2350976 | 2350976 | 2022-03-28 | Pointe Coupee | Louisiana | 22077 | 6264 | 92 |
2347723 | 2347723 | 2022-03-27 | Pointe Coupee | Louisiana | 22077 | 6264 | 92 |
2344470 | 2344470 | 2022-03-26 | Pointe Coupee | Louisiana | 22077 | 6264 | 92 |
2341217 | 2341217 | 2022-03-25 | Pointe Coupee | Louisiana | 22077 | 6264 | 92 |
2337964 | 2337964 | 2022-03-24 | Pointe Coupee | Louisiana | 22077 | 6264 | 92 |
2240401 | 2240401 | 2022-02-22 | Richland | Louisiana | 22083 | 6550 | 92 |
2237150 | 2237150 | 2022-02-21 | Richland | Louisiana | 22083 | 6538 | 92 |
2233899 | 2233899 | 2022-02-20 | Richland | Louisiana | 22083 | 6512 | 92 |
2230648 | 2230648 | 2022-02-19 | Richland | Louisiana | 22083 | 6512 | 92 |
2227397 | 2227397 | 2022-02-18 | Richland | Louisiana | 22083 | 6512 | 92 |
2224146 | 2224146 | 2022-02-17 | Richland | Louisiana | 22083 | 6487 | 92 |
2220895 | 2220895 | 2022-02-16 | Richland | Louisiana | 22083 | 6474 | 92 |
1879512 | 1879512 | 2021-11-03 | Sabine | Louisiana | 22085 | 4516 | 92 |
1785252 | 1785252 | 2021-10-05 | Bienville | Louisiana | 22013 | 2447 | 92 |
1782003 | 1782003 | 2021-10-04 | Bienville | Louisiana | 22013 | 2445 | 92 |
1778753 | 1778753 | 2021-10-03 | Bienville | Louisiana | 22013 | 2439 | 92 |
1775503 | 1775503 | 2021-10-02 | Bienville | Louisiana | 22013 | 2439 | 92 |
1772253 | 1772253 | 2021-10-01 | Bienville | Louisiana | 22013 | 2439 | 92 |
1769004 | 1769004 | 2021-09-30 | Bienville | Louisiana | 22013 | 2434 | 92 |
1765755 | 1765755 | 2021-09-29 | Bienville | Louisiana | 22013 | 2425 | 92 |
1762506 | 1762506 | 2021-09-28 | Bienville | Louisiana | 22013 | 2424 | 92 |
1759258 | 1759258 | 2021-09-27 | Bienville | Louisiana | 22013 | 2423 | 92 |
1746300 | 1746300 | 2021-09-23 | St. Bernard | Louisiana | 22087 | 6704 | 92 |
1710576 | 1710576 | 2021-09-12 | Union | Louisiana | 22111 | 3638 | 92 |
1707329 | 1707329 | 2021-09-11 | Union | Louisiana | 22111 | 3638 | 92 |
1704081 | 1704081 | 2021-09-10 | Union | Louisiana | 22111 | 3638 | 92 |
1700831 | 1700831 | 2021-09-09 | Union | Louisiana | 22111 | 3613 | 92 |
1697582 | 1697582 | 2021-09-08 | Union | Louisiana | 22111 | 3589 | 92 |
1694334 | 1694334 | 2021-09-07 | Union | Louisiana | 22111 | 3550 | 92 |
1691085 | 1691085 | 2021-09-06 | Union | Louisiana | 22111 | 3510 | 92 |
1687835 | 1687835 | 2021-09-05 | Union | Louisiana | 22111 | 3510 | 92 |
1684585 | 1684585 | 2021-09-04 | Union | Louisiana | 22111 | 3510 | 92 |
1681334 | 1681334 | 2021-09-03 | Union | Louisiana | 22111 | 3510 | 92 |
1671568 | 1671568 | 2021-08-31 | Morehouse | Louisiana | 22067 | 3960 | 92 |
1668321 | 1668321 | 2021-08-30 | Morehouse | Louisiana | 22067 | 3960 | 92 |
1665074 | 1665074 | 2021-08-29 | Morehouse | Louisiana | 22067 | 3960 | 92 |
1661826 | 1661826 | 2021-08-28 | Morehouse | Louisiana | 22067 | 3960 | 92 |
1658578 | 1658578 | 2021-08-27 | Morehouse | Louisiana | 22067 | 3960 | 92 |
1528619 | 1528619 | 2021-07-18 | Allen | Louisiana | 22003 | 3299 | 92 |
1525372 | 1525372 | 2021-07-17 | Allen | Louisiana | 22003 | 3299 | 92 |
1522124 | 1522124 | 2021-07-16 | Allen | Louisiana | 22003 | 3299 | 92 |
1518876 | 1518876 | 2021-07-15 | Allen | Louisiana | 22003 | 3298 | 92 |
1515629 | 1515629 | 2021-07-14 | Allen | Louisiana | 22003 | 3295 | 92 |
1512383 | 1512383 | 2021-07-13 | Allen | Louisiana | 22003 | 3294 | 92 |
1509136 | 1509136 | 2021-07-12 | Allen | Louisiana | 22003 | 3294 | 92 |
1505890 | 1505890 | 2021-07-11 | Allen | Louisiana | 22003 | 3288 | 92 |
1502644 | 1502644 | 2021-07-10 | Allen | Louisiana | 22003 | 3288 | 92 |
1499398 | 1499398 | 2021-07-09 | Allen | Louisiana | 22003 | 3288 | 92 |
1496151 | 1496151 | 2021-07-08 | Allen | Louisiana | 22003 | 3285 | 92 |
1492905 | 1492905 | 2021-07-07 | Allen | Louisiana | 22003 | 3282 | 92 |
1489658 | 1489658 | 2021-07-06 | Allen | Louisiana | 22003 | 3277 | 92 |
1486411 | 1486411 | 2021-07-05 | Allen | Louisiana | 22003 | 3276 | 92 |
1483165 | 1483165 | 2021-07-04 | Allen | Louisiana | 22003 | 3276 | 92 |
1479918 | 1479918 | 2021-07-03 | Allen | Louisiana | 22003 | 3276 | 92 |
1476672 | 1476672 | 2021-07-02 | Allen | Louisiana | 22003 | 3276 | 92 |
1473426 | 1473426 | 2021-07-01 | Allen | Louisiana | 22003 | 3275 | 92 |
1470180 | 1470180 | 2021-06-30 | Allen | Louisiana | 22003 | 3272 | 92 |
1466935 | 1466935 | 2021-06-29 | Allen | Louisiana | 22003 | 3272 | 92 |
1463690 | 1463690 | 2021-06-28 | Allen | Louisiana | 22003 | 3270 | 92 |
1460445 | 1460445 | 2021-06-27 | Allen | Louisiana | 22003 | 3268 | 92 |
1457200 | 1457200 | 2021-06-26 | Allen | Louisiana | 22003 | 3268 | 92 |
1453955 | 1453955 | 2021-06-25 | Allen | Louisiana | 22003 | 3268 | 92 |
1450709 | 1450709 | 2021-06-24 | Allen | Louisiana | 22003 | 3269 | 92 |
1447464 | 1447464 | 2021-06-23 | Allen | Louisiana | 22003 | 3265 | 92 |
1444219 | 1444219 | 2021-06-22 | Allen | Louisiana | 22003 | 3265 | 92 |
1440974 | 1440974 | 2021-06-21 | Allen | Louisiana | 22003 | 3264 | 92 |
1437727 | 1437727 | 2021-06-20 | Allen | Louisiana | 22003 | 3263 | 92 |
1434480 | 1434480 | 2021-06-19 | Allen | Louisiana | 22003 | 3263 | 92 |
1431234 | 1431234 | 2021-06-18 | Allen | Louisiana | 22003 | 3263 | 92 |
1427989 | 1427989 | 2021-06-17 | Allen | Louisiana | 22003 | 3260 | 92 |
1424744 | 1424744 | 2021-06-16 | Allen | Louisiana | 22003 | 3260 | 92 |
1421496 | 1421496 | 2021-06-15 | Allen | Louisiana | 22003 | 3258 | 92 |
1418251 | 1418251 | 2021-06-14 | Allen | Louisiana | 22003 | 3255 | 92 |
1415005 | 1415005 | 2021-06-13 | Allen | Louisiana | 22003 | 3255 | 92 |
1411760 | 1411760 | 2021-06-12 | Allen | Louisiana | 22003 | 3255 | 92 |
1408515 | 1408515 | 2021-06-11 | Allen | Louisiana | 22003 | 3255 | 92 |
1405269 | 1405269 | 2021-06-10 | Allen | Louisiana | 22003 | 3254 | 92 |
1402024 | 1402024 | 2021-06-09 | Allen | Louisiana | 22003 | 3246 | 92 |
1398779 | 1398779 | 2021-06-08 | Allen | Louisiana | 22003 | 3236 | 92 |
1395532 | 1395532 | 2021-06-07 | Allen | Louisiana | 22003 | 3250 | 92 |
1392287 | 1392287 | 2021-06-06 | Allen | Louisiana | 22003 | 3239 | 92 |
1389042 | 1389042 | 2021-06-05 | Allen | Louisiana | 22003 | 3239 | 92 |
1385797 | 1385797 | 2021-06-04 | Allen | Louisiana | 22003 | 3239 | 92 |
1382551 | 1382551 | 2021-06-03 | Allen | Louisiana | 22003 | 3233 | 92 |
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);