ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
259 rows where deaths = 27 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Plaquemines 91
- East Carroll 48
- Pointe Coupee 15
- St. James 15
- St. Martin 11
- St. Bernard 7
- Evangeline 5
- Morehouse 5
- West Carroll 5
- Bienville 4
- Livingston 4
- Union 4
- Avoyelles 3
- De Soto 3
- East Feliciana 3
- Grant 3
- Webster 3
- Winn 3
- Ascension 2
- Calcasieu 2
- Lafayette 2
- Richland 2
- Tangipahoa 2
- Vernon 2
- Acadia 1
- Beauregard 1
- Bossier 1
- Claiborne 1
- Concordia 1
- Iberville 1
- …
state 1
- Louisiana · 259 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1583866 | 1583866 | 2021-08-04 | Plaquemines | Louisiana | 22075 | 3030 | 27 |
1580616 | 1580616 | 2021-08-03 | Plaquemines | Louisiana | 22075 | 2992 | 27 |
1577367 | 1577367 | 2021-08-02 | Plaquemines | Louisiana | 22075 | 2975 | 27 |
1574119 | 1574119 | 2021-08-01 | Plaquemines | Louisiana | 22075 | 2909 | 27 |
1570871 | 1570871 | 2021-07-31 | Plaquemines | Louisiana | 22075 | 2909 | 27 |
1567623 | 1567623 | 2021-07-30 | Plaquemines | Louisiana | 22075 | 2909 | 27 |
1564375 | 1564375 | 2021-07-29 | Plaquemines | Louisiana | 22075 | 2877 | 27 |
1561127 | 1561127 | 2021-07-28 | Plaquemines | Louisiana | 22075 | 2855 | 27 |
1557880 | 1557880 | 2021-07-27 | Plaquemines | Louisiana | 22075 | 2836 | 27 |
1554633 | 1554633 | 2021-07-26 | Plaquemines | Louisiana | 22075 | 2795 | 27 |
1551386 | 1551386 | 2021-07-25 | Plaquemines | Louisiana | 22075 | 2768 | 27 |
1548139 | 1548139 | 2021-07-24 | Plaquemines | Louisiana | 22075 | 2768 | 27 |
1544892 | 1544892 | 2021-07-23 | Plaquemines | Louisiana | 22075 | 2768 | 27 |
1541644 | 1541644 | 2021-07-22 | Plaquemines | Louisiana | 22075 | 2743 | 27 |
1538397 | 1538397 | 2021-07-21 | Plaquemines | Louisiana | 22075 | 2726 | 27 |
1535149 | 1535149 | 2021-07-20 | Plaquemines | Louisiana | 22075 | 2664 | 27 |
1531902 | 1531902 | 2021-07-19 | Plaquemines | Louisiana | 22075 | 2662 | 27 |
1528655 | 1528655 | 2021-07-18 | Plaquemines | Louisiana | 22075 | 2634 | 27 |
1525408 | 1525408 | 2021-07-17 | Plaquemines | Louisiana | 22075 | 2634 | 27 |
1522160 | 1522160 | 2021-07-16 | Plaquemines | Louisiana | 22075 | 2634 | 27 |
1518912 | 1518912 | 2021-07-15 | Plaquemines | Louisiana | 22075 | 2625 | 27 |
1515665 | 1515665 | 2021-07-14 | Plaquemines | Louisiana | 22075 | 2618 | 27 |
1512399 | 1512399 | 2021-07-13 | East Carroll | Louisiana | 22035 | 1146 | 27 |
1512419 | 1512419 | 2021-07-13 | Plaquemines | Louisiana | 22075 | 2606 | 27 |
1509152 | 1509152 | 2021-07-12 | East Carroll | Louisiana | 22035 | 1145 | 27 |
1509172 | 1509172 | 2021-07-12 | Plaquemines | Louisiana | 22075 | 2599 | 27 |
1505906 | 1505906 | 2021-07-11 | East Carroll | Louisiana | 22035 | 1144 | 27 |
1505926 | 1505926 | 2021-07-11 | Plaquemines | Louisiana | 22075 | 2587 | 27 |
1502660 | 1502660 | 2021-07-10 | East Carroll | Louisiana | 22035 | 1144 | 27 |
1502680 | 1502680 | 2021-07-10 | Plaquemines | Louisiana | 22075 | 2587 | 27 |
1499414 | 1499414 | 2021-07-09 | East Carroll | Louisiana | 22035 | 1144 | 27 |
1499434 | 1499434 | 2021-07-09 | Plaquemines | Louisiana | 22075 | 2587 | 27 |
1496167 | 1496167 | 2021-07-08 | East Carroll | Louisiana | 22035 | 1144 | 27 |
1496187 | 1496187 | 2021-07-08 | Plaquemines | Louisiana | 22075 | 2580 | 27 |
1492921 | 1492921 | 2021-07-07 | East Carroll | Louisiana | 22035 | 1144 | 27 |
1492941 | 1492941 | 2021-07-07 | Plaquemines | Louisiana | 22075 | 2579 | 27 |
1489674 | 1489674 | 2021-07-06 | East Carroll | Louisiana | 22035 | 1144 | 27 |
1489694 | 1489694 | 2021-07-06 | Plaquemines | Louisiana | 22075 | 2577 | 27 |
1486427 | 1486427 | 2021-07-05 | East Carroll | Louisiana | 22035 | 1139 | 27 |
1486447 | 1486447 | 2021-07-05 | Plaquemines | Louisiana | 22075 | 2576 | 27 |
1483181 | 1483181 | 2021-07-04 | East Carroll | Louisiana | 22035 | 1139 | 27 |
1483201 | 1483201 | 2021-07-04 | Plaquemines | Louisiana | 22075 | 2576 | 27 |
1479934 | 1479934 | 2021-07-03 | East Carroll | Louisiana | 22035 | 1139 | 27 |
1479954 | 1479954 | 2021-07-03 | Plaquemines | Louisiana | 22075 | 2576 | 27 |
1476688 | 1476688 | 2021-07-02 | East Carroll | Louisiana | 22035 | 1139 | 27 |
1476708 | 1476708 | 2021-07-02 | Plaquemines | Louisiana | 22075 | 2576 | 27 |
1473442 | 1473442 | 2021-07-01 | East Carroll | Louisiana | 22035 | 1139 | 27 |
1473462 | 1473462 | 2021-07-01 | Plaquemines | Louisiana | 22075 | 2570 | 27 |
1470196 | 1470196 | 2021-06-30 | East Carroll | Louisiana | 22035 | 1140 | 27 |
1470216 | 1470216 | 2021-06-30 | Plaquemines | Louisiana | 22075 | 2572 | 27 |
1466951 | 1466951 | 2021-06-29 | East Carroll | Louisiana | 22035 | 1139 | 27 |
1466971 | 1466971 | 2021-06-29 | Plaquemines | Louisiana | 22075 | 2568 | 27 |
1463706 | 1463706 | 2021-06-28 | East Carroll | Louisiana | 22035 | 1138 | 27 |
1463726 | 1463726 | 2021-06-28 | Plaquemines | Louisiana | 22075 | 2569 | 27 |
1460461 | 1460461 | 2021-06-27 | East Carroll | Louisiana | 22035 | 1138 | 27 |
1460481 | 1460481 | 2021-06-27 | Plaquemines | Louisiana | 22075 | 2567 | 27 |
1457216 | 1457216 | 2021-06-26 | East Carroll | Louisiana | 22035 | 1138 | 27 |
1457236 | 1457236 | 2021-06-26 | Plaquemines | Louisiana | 22075 | 2567 | 27 |
1453971 | 1453971 | 2021-06-25 | East Carroll | Louisiana | 22035 | 1138 | 27 |
1453991 | 1453991 | 2021-06-25 | Plaquemines | Louisiana | 22075 | 2567 | 27 |
1450725 | 1450725 | 2021-06-24 | East Carroll | Louisiana | 22035 | 1139 | 27 |
1450745 | 1450745 | 2021-06-24 | Plaquemines | Louisiana | 22075 | 2565 | 27 |
1447480 | 1447480 | 2021-06-23 | East Carroll | Louisiana | 22035 | 1137 | 27 |
1447500 | 1447500 | 2021-06-23 | Plaquemines | Louisiana | 22075 | 2565 | 27 |
1444235 | 1444235 | 2021-06-22 | East Carroll | Louisiana | 22035 | 1136 | 27 |
1444255 | 1444255 | 2021-06-22 | Plaquemines | Louisiana | 22075 | 2564 | 27 |
1440990 | 1440990 | 2021-06-21 | East Carroll | Louisiana | 22035 | 1136 | 27 |
1441010 | 1441010 | 2021-06-21 | Plaquemines | Louisiana | 22075 | 2563 | 27 |
1437743 | 1437743 | 2021-06-20 | East Carroll | Louisiana | 22035 | 1137 | 27 |
1437763 | 1437763 | 2021-06-20 | Plaquemines | Louisiana | 22075 | 2561 | 27 |
1434496 | 1434496 | 2021-06-19 | East Carroll | Louisiana | 22035 | 1137 | 27 |
1434516 | 1434516 | 2021-06-19 | Plaquemines | Louisiana | 22075 | 2561 | 27 |
1431250 | 1431250 | 2021-06-18 | East Carroll | Louisiana | 22035 | 1137 | 27 |
1431270 | 1431270 | 2021-06-18 | Plaquemines | Louisiana | 22075 | 2561 | 27 |
1428005 | 1428005 | 2021-06-17 | East Carroll | Louisiana | 22035 | 1136 | 27 |
1428025 | 1428025 | 2021-06-17 | Plaquemines | Louisiana | 22075 | 2559 | 27 |
1424760 | 1424760 | 2021-06-16 | East Carroll | Louisiana | 22035 | 1137 | 27 |
1424780 | 1424780 | 2021-06-16 | Plaquemines | Louisiana | 22075 | 2558 | 27 |
1421512 | 1421512 | 2021-06-15 | East Carroll | Louisiana | 22035 | 1136 | 27 |
1421532 | 1421532 | 2021-06-15 | Plaquemines | Louisiana | 22075 | 2560 | 27 |
1418267 | 1418267 | 2021-06-14 | East Carroll | Louisiana | 22035 | 1136 | 27 |
1418287 | 1418287 | 2021-06-14 | Plaquemines | Louisiana | 22075 | 2559 | 27 |
1415021 | 1415021 | 2021-06-13 | East Carroll | Louisiana | 22035 | 1135 | 27 |
1415041 | 1415041 | 2021-06-13 | Plaquemines | Louisiana | 22075 | 2557 | 27 |
1411776 | 1411776 | 2021-06-12 | East Carroll | Louisiana | 22035 | 1135 | 27 |
1411796 | 1411796 | 2021-06-12 | Plaquemines | Louisiana | 22075 | 2557 | 27 |
1408531 | 1408531 | 2021-06-11 | East Carroll | Louisiana | 22035 | 1135 | 27 |
1408551 | 1408551 | 2021-06-11 | Plaquemines | Louisiana | 22075 | 2557 | 27 |
1405285 | 1405285 | 2021-06-10 | East Carroll | Louisiana | 22035 | 1135 | 27 |
1405305 | 1405305 | 2021-06-10 | Plaquemines | Louisiana | 22075 | 2556 | 27 |
1402040 | 1402040 | 2021-06-09 | East Carroll | Louisiana | 22035 | 1135 | 27 |
1402060 | 1402060 | 2021-06-09 | Plaquemines | Louisiana | 22075 | 2557 | 27 |
1398795 | 1398795 | 2021-06-08 | East Carroll | Louisiana | 22035 | 1134 | 27 |
1398815 | 1398815 | 2021-06-08 | Plaquemines | Louisiana | 22075 | 2556 | 27 |
1395548 | 1395548 | 2021-06-07 | East Carroll | Louisiana | 22035 | 1133 | 27 |
1395568 | 1395568 | 2021-06-07 | Plaquemines | Louisiana | 22075 | 2560 | 27 |
1392303 | 1392303 | 2021-06-06 | East Carroll | Louisiana | 22035 | 1133 | 27 |
1392323 | 1392323 | 2021-06-06 | Plaquemines | Louisiana | 22075 | 2560 | 27 |
1389058 | 1389058 | 2021-06-05 | East Carroll | Louisiana | 22035 | 1133 | 27 |
1389078 | 1389078 | 2021-06-05 | Plaquemines | Louisiana | 22075 | 2560 | 27 |
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);