ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

270 rows where deaths = 28 and state = "Louisiana" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

state 1

  • Louisiana · 270 ✖
Link rowid date ▲ county state fips cases deaths
1694296 1694296 2021-09-07 East Carroll Louisiana 22035 1445 28
1691047 1691047 2021-09-06 East Carroll Louisiana 22035 1441 28
1687797 1687797 2021-09-05 East Carroll Louisiana 22035 1441 28
1684547 1684547 2021-09-04 East Carroll Louisiana 22035 1441 28
1681296 1681296 2021-09-03 East Carroll Louisiana 22035 1441 28
1678048 1678048 2021-09-02 East Carroll Louisiana 22035 1426 28
1674801 1674801 2021-09-01 East Carroll Louisiana 22035 1416 28
1671552 1671552 2021-08-31 East Carroll Louisiana 22035 1399 28
1668305 1668305 2021-08-30 East Carroll Louisiana 22035 1399 28
1665058 1665058 2021-08-29 East Carroll Louisiana 22035 1399 28
1661810 1661810 2021-08-28 East Carroll Louisiana 22035 1399 28
1658562 1658562 2021-08-27 East Carroll Louisiana 22035 1399 28
1655314 1655314 2021-08-26 East Carroll Louisiana 22035 1393 28
1652067 1652067 2021-08-25 East Carroll Louisiana 22035 1381 28
1648818 1648818 2021-08-24 East Carroll Louisiana 22035 1369 28
1645570 1645570 2021-08-23 East Carroll Louisiana 22035 1366 28
1642321 1642321 2021-08-22 East Carroll Louisiana 22035 1357 28
1639071 1639071 2021-08-21 East Carroll Louisiana 22035 1357 28
1635821 1635821 2021-08-20 East Carroll Louisiana 22035 1357 28
1632571 1632571 2021-08-19 East Carroll Louisiana 22035 1341 28
1629324 1629324 2021-08-18 East Carroll Louisiana 22035 1334 28
1626077 1626077 2021-08-17 East Carroll Louisiana 22035 1313 28
1622830 1622830 2021-08-16 East Carroll Louisiana 22035 1311 28
1619583 1619583 2021-08-15 East Carroll Louisiana 22035 1306 28
1616335 1616335 2021-08-14 East Carroll Louisiana 22035 1306 28
1613086 1613086 2021-08-13 East Carroll Louisiana 22035 1306 28
1609838 1609838 2021-08-12 East Carroll Louisiana 22035 1285 28
1606589 1606589 2021-08-11 East Carroll Louisiana 22035 1282 28
1603340 1603340 2021-08-10 East Carroll Louisiana 22035 1277 28
1600091 1600091 2021-08-09 East Carroll Louisiana 22035 1268 28
1600111 1600111 2021-08-09 Plaquemines Louisiana 22075 3144 28
1596843 1596843 2021-08-08 East Carroll Louisiana 22035 1243 28
1596863 1596863 2021-08-08 Plaquemines Louisiana 22075 3089 28
1593594 1593594 2021-08-07 East Carroll Louisiana 22035 1243 28
1593614 1593614 2021-08-07 Plaquemines Louisiana 22075 3089 28
1590345 1590345 2021-08-06 East Carroll Louisiana 22035 1243 28
1590365 1590365 2021-08-06 Plaquemines Louisiana 22075 3089 28
1587096 1587096 2021-08-05 East Carroll Louisiana 22035 1218 28
1587116 1587116 2021-08-05 Plaquemines Louisiana 22075 3058 28
1583846 1583846 2021-08-04 East Carroll Louisiana 22035 1206 28
1580596 1580596 2021-08-03 East Carroll Louisiana 22035 1205 28
1577347 1577347 2021-08-02 East Carroll Louisiana 22035 1202 28
1574099 1574099 2021-08-01 East Carroll Louisiana 22035 1185 28
1570851 1570851 2021-07-31 East Carroll Louisiana 22035 1185 28
1567603 1567603 2021-07-30 East Carroll Louisiana 22035 1185 28
1564355 1564355 2021-07-29 East Carroll Louisiana 22035 1180 28
1561107 1561107 2021-07-28 East Carroll Louisiana 22035 1177 28
1557860 1557860 2021-07-27 East Carroll Louisiana 22035 1175 28
1554613 1554613 2021-07-26 East Carroll Louisiana 22035 1174 28
1551366 1551366 2021-07-25 East Carroll Louisiana 22035 1169 28
1548119 1548119 2021-07-24 East Carroll Louisiana 22035 1169 28
1544872 1544872 2021-07-23 East Carroll Louisiana 22035 1169 28
1541624 1541624 2021-07-22 East Carroll Louisiana 22035 1167 28
1538377 1538377 2021-07-21 East Carroll Louisiana 22035 1164 28
1535129 1535129 2021-07-20 East Carroll Louisiana 22035 1150 28
1531882 1531882 2021-07-19 East Carroll Louisiana 22035 1150 28
1528635 1528635 2021-07-18 East Carroll Louisiana 22035 1146 28
1525388 1525388 2021-07-17 East Carroll Louisiana 22035 1146 28
1522140 1522140 2021-07-16 East Carroll Louisiana 22035 1146 28
1518892 1518892 2021-07-15 East Carroll Louisiana 22035 1145 28
1515645 1515645 2021-07-14 East Carroll Louisiana 22035 1145 28
1002729 1002729 2021-02-06 Madison Louisiana 22065 1522 28
999483 999483 2021-02-05 Madison Louisiana 22065 1522 28
996237 996237 2021-02-04 Madison Louisiana 22065 1521 28
992991 992991 2021-02-03 Madison Louisiana 22065 1519 28
989745 989745 2021-02-02 Madison Louisiana 22065 1521 28
989776 989776 2021-02-02 West Feliciana Louisiana 22125 1086 28
986498 986498 2021-02-01 Madison Louisiana 22065 1519 28
986529 986529 2021-02-01 West Feliciana Louisiana 22125 1087 28
983251 983251 2021-01-31 Madison Louisiana 22065 1518 28
983282 983282 2021-01-31 West Feliciana Louisiana 22125 1087 28
980005 980005 2021-01-30 Madison Louisiana 22065 1517 28
980036 980036 2021-01-30 West Feliciana Louisiana 22125 1078 28
976759 976759 2021-01-29 Madison Louisiana 22065 1517 28
976790 976790 2021-01-29 West Feliciana Louisiana 22125 1078 28
973514 973514 2021-01-28 Madison Louisiana 22065 1510 28
973545 973545 2021-01-28 West Feliciana Louisiana 22125 1058 28
970269 970269 2021-01-27 Madison Louisiana 22065 1506 28
970300 970300 2021-01-27 West Feliciana Louisiana 22125 1060 28
967025 967025 2021-01-26 Madison Louisiana 22065 1502 28
967056 967056 2021-01-26 West Feliciana Louisiana 22125 1062 28
963780 963780 2021-01-25 Madison Louisiana 22065 1497 28
963811 963811 2021-01-25 West Feliciana Louisiana 22125 1042 28
960535 960535 2021-01-24 Madison Louisiana 22065 1494 28
960566 960566 2021-01-24 West Feliciana Louisiana 22125 1042 28
957289 957289 2021-01-23 Madison Louisiana 22065 1490 28
957320 957320 2021-01-23 West Feliciana Louisiana 22125 1046 28
954044 954044 2021-01-22 Madison Louisiana 22065 1490 28
954075 954075 2021-01-22 West Feliciana Louisiana 22125 1046 28
950799 950799 2021-01-21 Madison Louisiana 22065 1480 28
950830 950830 2021-01-21 West Feliciana Louisiana 22125 1038 28
947584 947584 2021-01-20 West Feliciana Louisiana 22125 1038 28
944337 944337 2021-01-19 West Feliciana Louisiana 22125 1032 28
937811 937811 2021-01-17 LaSalle Louisiana 22059 1275 28
934566 934566 2021-01-16 LaSalle Louisiana 22059 1264 28
931321 931321 2021-01-15 LaSalle Louisiana 22059 1264 28
928076 928076 2021-01-14 LaSalle Louisiana 22059 1252 28
895600 895600 2021-01-04 Assumption Louisiana 22007 1408 28
892353 892353 2021-01-03 Assumption Louisiana 22007 1404 28
889107 889107 2021-01-02 Assumption Louisiana 22007 1379 28

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);