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

346 rows where deaths = 29 and state = "Louisiana" sorted by date descending

✎ View and edit SQL

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

fips >30

state 1

  • Louisiana · 346 ✖
Link rowid date ▲ county state fips cases deaths
1717031 1717031 2021-09-14 East Carroll Louisiana 22035 1466 29
1713785 1713785 2021-09-13 East Carroll Louisiana 22035 1465 29
1710538 1710538 2021-09-12 East Carroll Louisiana 22035 1463 29
1707291 1707291 2021-09-11 East Carroll Louisiana 22035 1463 29
1704043 1704043 2021-09-10 East Carroll Louisiana 22035 1463 29
1700793 1700793 2021-09-09 East Carroll Louisiana 22035 1461 29
1697544 1697544 2021-09-08 East Carroll Louisiana 22035 1446 29
1622850 1622850 2021-08-16 Plaquemines Louisiana 22075 3341 29
1619603 1619603 2021-08-15 Plaquemines Louisiana 22075 3256 29
1616355 1616355 2021-08-14 Plaquemines Louisiana 22075 3256 29
1613106 1613106 2021-08-13 Plaquemines Louisiana 22075 3256 29
1609858 1609858 2021-08-12 Plaquemines Louisiana 22075 3234 29
1606609 1606609 2021-08-11 Plaquemines Louisiana 22075 3219 29
1603360 1603360 2021-08-10 Plaquemines Louisiana 22075 3184 29
1580589 1580589 2021-08-03 Caldwell Louisiana 22021 1259 29
1577340 1577340 2021-08-02 Caldwell Louisiana 22021 1266 29
1574092 1574092 2021-08-01 Caldwell Louisiana 22021 1226 29
1570844 1570844 2021-07-31 Caldwell Louisiana 22021 1226 29
1567596 1567596 2021-07-30 Caldwell Louisiana 22021 1226 29
1564348 1564348 2021-07-29 Caldwell Louisiana 22021 1219 29
1561100 1561100 2021-07-28 Caldwell Louisiana 22021 1215 29
1557853 1557853 2021-07-27 Caldwell Louisiana 22021 1210 29
1554606 1554606 2021-07-26 Caldwell Louisiana 22021 1204 29
1551359 1551359 2021-07-25 Caldwell Louisiana 22021 1189 29
1548112 1548112 2021-07-24 Caldwell Louisiana 22021 1189 29
1544865 1544865 2021-07-23 Caldwell Louisiana 22021 1189 29
1541617 1541617 2021-07-22 Caldwell Louisiana 22021 1186 29
1538370 1538370 2021-07-21 Caldwell Louisiana 22021 1170 29
1535122 1535122 2021-07-20 Caldwell Louisiana 22021 1164 29
1531875 1531875 2021-07-19 Caldwell Louisiana 22021 1163 29
1528628 1528628 2021-07-18 Caldwell Louisiana 22021 1157 29
1525381 1525381 2021-07-17 Caldwell Louisiana 22021 1157 29
1522133 1522133 2021-07-16 Caldwell Louisiana 22021 1157 29
1518885 1518885 2021-07-15 Caldwell Louisiana 22021 1154 29
1515638 1515638 2021-07-14 Caldwell Louisiana 22021 1150 29
1512392 1512392 2021-07-13 Caldwell Louisiana 22021 1148 29
1509145 1509145 2021-07-12 Caldwell Louisiana 22021 1149 29
1505899 1505899 2021-07-11 Caldwell Louisiana 22021 1143 29
1502653 1502653 2021-07-10 Caldwell Louisiana 22021 1143 29
1499407 1499407 2021-07-09 Caldwell Louisiana 22021 1143 29
1496160 1496160 2021-07-08 Caldwell Louisiana 22021 1143 29
1492914 1492914 2021-07-07 Caldwell Louisiana 22021 1142 29
1489667 1489667 2021-07-06 Caldwell Louisiana 22021 1142 29
1486420 1486420 2021-07-05 Caldwell Louisiana 22021 1141 29
1483174 1483174 2021-07-04 Caldwell Louisiana 22021 1141 29
1479927 1479927 2021-07-03 Caldwell Louisiana 22021 1141 29
1476681 1476681 2021-07-02 Caldwell Louisiana 22021 1141 29
1473435 1473435 2021-07-01 Caldwell Louisiana 22021 1140 29
1470189 1470189 2021-06-30 Caldwell Louisiana 22021 1139 29
1466944 1466944 2021-06-29 Caldwell Louisiana 22021 1137 29
1463699 1463699 2021-06-28 Caldwell Louisiana 22021 1134 29
1460454 1460454 2021-06-27 Caldwell Louisiana 22021 1133 29
1457209 1457209 2021-06-26 Caldwell Louisiana 22021 1133 29
1453964 1453964 2021-06-25 Caldwell Louisiana 22021 1133 29
1450718 1450718 2021-06-24 Caldwell Louisiana 22021 1133 29
1447473 1447473 2021-06-23 Caldwell Louisiana 22021 1133 29
1444228 1444228 2021-06-22 Caldwell Louisiana 22021 1132 29
1440983 1440983 2021-06-21 Caldwell Louisiana 22021 1132 29
1437736 1437736 2021-06-20 Caldwell Louisiana 22021 1129 29
1434489 1434489 2021-06-19 Caldwell Louisiana 22021 1129 29
1431243 1431243 2021-06-18 Caldwell Louisiana 22021 1129 29
1427998 1427998 2021-06-17 Caldwell Louisiana 22021 1129 29
1424753 1424753 2021-06-16 Caldwell Louisiana 22021 1128 29
1421505 1421505 2021-06-15 Caldwell Louisiana 22021 1128 29
1418260 1418260 2021-06-14 Caldwell Louisiana 22021 1128 29
1415014 1415014 2021-06-13 Caldwell Louisiana 22021 1128 29
1411769 1411769 2021-06-12 Caldwell Louisiana 22021 1128 29
1408524 1408524 2021-06-11 Caldwell Louisiana 22021 1128 29
1405278 1405278 2021-06-10 Caldwell Louisiana 22021 1127 29
1402033 1402033 2021-06-09 Caldwell Louisiana 22021 1125 29
1398788 1398788 2021-06-08 Caldwell Louisiana 22021 1124 29
1395541 1395541 2021-06-07 Caldwell Louisiana 22021 1127 29
1392296 1392296 2021-06-06 Caldwell Louisiana 22021 1125 29
1389051 1389051 2021-06-05 Caldwell Louisiana 22021 1125 29
1385806 1385806 2021-06-04 Caldwell Louisiana 22021 1125 29
1382560 1382560 2021-06-03 Caldwell Louisiana 22021 1125 29
1379315 1379315 2021-06-02 Caldwell Louisiana 22021 1121 29
1376069 1376069 2021-06-01 Caldwell Louisiana 22021 1120 29
1372824 1372824 2021-05-31 Caldwell Louisiana 22021 1119 29
1369579 1369579 2021-05-30 Caldwell Louisiana 22021 1119 29
1366333 1366333 2021-05-29 Caldwell Louisiana 22021 1119 29
1363087 1363087 2021-05-28 Caldwell Louisiana 22021 1119 29
1359840 1359840 2021-05-27 Caldwell Louisiana 22021 1119 29
1356594 1356594 2021-05-26 Caldwell Louisiana 22021 1118 29
1353348 1353348 2021-05-25 Caldwell Louisiana 22021 1116 29
1350102 1350102 2021-05-24 Caldwell Louisiana 22021 1117 29
1346855 1346855 2021-05-23 Caldwell Louisiana 22021 1117 29
1343607 1343607 2021-05-22 Caldwell Louisiana 22021 1117 29
1340359 1340359 2021-05-21 Caldwell Louisiana 22021 1117 29
1337112 1337112 2021-05-20 Caldwell Louisiana 22021 1115 29
1333865 1333865 2021-05-19 Caldwell Louisiana 22021 1115 29
1330618 1330618 2021-05-18 Caldwell Louisiana 22021 1114 29
1327371 1327371 2021-05-17 Caldwell Louisiana 22021 1115 29
1324125 1324125 2021-05-16 Caldwell Louisiana 22021 1116 29
1320879 1320879 2021-05-15 Caldwell Louisiana 22021 1116 29
1317632 1317632 2021-05-14 Caldwell Louisiana 22021 1116 29
1314385 1314385 2021-05-13 Caldwell Louisiana 22021 1115 29
1311138 1311138 2021-05-12 Caldwell Louisiana 22021 1111 29
1307892 1307892 2021-05-11 Caldwell Louisiana 22021 1107 29
1304646 1304646 2021-05-10 Caldwell Louisiana 22021 1110 29

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