ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
136 rows where county = "Smith", deaths = 34 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1541964 | 1541964 | 2021-07-22 | Smith | Mississippi | 28129 | 1753 | 34 |
1538717 | 1538717 | 2021-07-21 | Smith | Mississippi | 28129 | 1745 | 34 |
1535470 | 1535470 | 2021-07-20 | Smith | Mississippi | 28129 | 1740 | 34 |
1532222 | 1532222 | 2021-07-19 | Smith | Mississippi | 28129 | 1737 | 34 |
1528975 | 1528975 | 2021-07-18 | Smith | Mississippi | 28129 | 1714 | 34 |
1525728 | 1525728 | 2021-07-17 | Smith | Mississippi | 28129 | 1714 | 34 |
1522481 | 1522481 | 2021-07-16 | Smith | Mississippi | 28129 | 1714 | 34 |
1519232 | 1519232 | 2021-07-15 | Smith | Mississippi | 28129 | 1712 | 34 |
1515985 | 1515985 | 2021-07-14 | Smith | Mississippi | 28129 | 1710 | 34 |
1512739 | 1512739 | 2021-07-13 | Smith | Mississippi | 28129 | 1699 | 34 |
1509492 | 1509492 | 2021-07-12 | Smith | Mississippi | 28129 | 1698 | 34 |
1506246 | 1506246 | 2021-07-11 | Smith | Mississippi | 28129 | 1694 | 34 |
1503000 | 1503000 | 2021-07-10 | Smith | Mississippi | 28129 | 1694 | 34 |
1499754 | 1499754 | 2021-07-09 | Smith | Mississippi | 28129 | 1694 | 34 |
1496508 | 1496508 | 2021-07-08 | Smith | Mississippi | 28129 | 1689 | 34 |
1493261 | 1493261 | 2021-07-07 | Smith | Mississippi | 28129 | 1678 | 34 |
1490014 | 1490014 | 2021-07-06 | Smith | Mississippi | 28129 | 1670 | 34 |
1486767 | 1486767 | 2021-07-05 | Smith | Mississippi | 28129 | 1659 | 34 |
1483521 | 1483521 | 2021-07-04 | Smith | Mississippi | 28129 | 1659 | 34 |
1480275 | 1480275 | 2021-07-03 | Smith | Mississippi | 28129 | 1659 | 34 |
1477028 | 1477028 | 2021-07-02 | Smith | Mississippi | 28129 | 1659 | 34 |
1473782 | 1473782 | 2021-07-01 | Smith | Mississippi | 28129 | 1653 | 34 |
1470536 | 1470536 | 2021-06-30 | Smith | Mississippi | 28129 | 1649 | 34 |
1467291 | 1467291 | 2021-06-29 | Smith | Mississippi | 28129 | 1648 | 34 |
1464046 | 1464046 | 2021-06-28 | Smith | Mississippi | 28129 | 1643 | 34 |
1460801 | 1460801 | 2021-06-27 | Smith | Mississippi | 28129 | 1642 | 34 |
1457556 | 1457556 | 2021-06-26 | Smith | Mississippi | 28129 | 1642 | 34 |
1454311 | 1454311 | 2021-06-25 | Smith | Mississippi | 28129 | 1642 | 34 |
1451066 | 1451066 | 2021-06-24 | Smith | Mississippi | 28129 | 1642 | 34 |
1447820 | 1447820 | 2021-06-23 | Smith | Mississippi | 28129 | 1641 | 34 |
1444575 | 1444575 | 2021-06-22 | Smith | Mississippi | 28129 | 1641 | 34 |
1441330 | 1441330 | 2021-06-21 | Smith | Mississippi | 28129 | 1641 | 34 |
1438084 | 1438084 | 2021-06-20 | Smith | Mississippi | 28129 | 1641 | 34 |
1434837 | 1434837 | 2021-06-19 | Smith | Mississippi | 28129 | 1641 | 34 |
1431590 | 1431590 | 2021-06-18 | Smith | Mississippi | 28129 | 1641 | 34 |
1428345 | 1428345 | 2021-06-17 | Smith | Mississippi | 28129 | 1640 | 34 |
1425100 | 1425100 | 2021-06-16 | Smith | Mississippi | 28129 | 1640 | 34 |
1421852 | 1421852 | 2021-06-15 | Smith | Mississippi | 28129 | 1640 | 34 |
1418607 | 1418607 | 2021-06-14 | Smith | Mississippi | 28129 | 1640 | 34 |
1415362 | 1415362 | 2021-06-13 | Smith | Mississippi | 28129 | 1640 | 34 |
1412116 | 1412116 | 2021-06-12 | Smith | Mississippi | 28129 | 1640 | 34 |
1408871 | 1408871 | 2021-06-11 | Smith | Mississippi | 28129 | 1640 | 34 |
1405626 | 1405626 | 2021-06-10 | Smith | Mississippi | 28129 | 1640 | 34 |
1402380 | 1402380 | 2021-06-09 | Smith | Mississippi | 28129 | 1640 | 34 |
1399135 | 1399135 | 2021-06-08 | Smith | Mississippi | 28129 | 1639 | 34 |
1395889 | 1395889 | 2021-06-07 | Smith | Mississippi | 28129 | 1639 | 34 |
1392643 | 1392643 | 2021-06-06 | Smith | Mississippi | 28129 | 1639 | 34 |
1389398 | 1389398 | 2021-06-05 | Smith | Mississippi | 28129 | 1639 | 34 |
1386153 | 1386153 | 2021-06-04 | Smith | Mississippi | 28129 | 1639 | 34 |
1382908 | 1382908 | 2021-06-03 | Smith | Mississippi | 28129 | 1637 | 34 |
1379662 | 1379662 | 2021-06-02 | Smith | Mississippi | 28129 | 1637 | 34 |
1376417 | 1376417 | 2021-06-01 | Smith | Mississippi | 28129 | 1637 | 34 |
1373171 | 1373171 | 2021-05-31 | Smith | Mississippi | 28129 | 1636 | 34 |
1369926 | 1369926 | 2021-05-30 | Smith | Mississippi | 28129 | 1633 | 34 |
1366680 | 1366680 | 2021-05-29 | Smith | Mississippi | 28129 | 1633 | 34 |
1363434 | 1363434 | 2021-05-28 | Smith | Mississippi | 28129 | 1633 | 34 |
1360187 | 1360187 | 2021-05-27 | Smith | Mississippi | 28129 | 1633 | 34 |
1356941 | 1356941 | 2021-05-26 | Smith | Mississippi | 28129 | 1633 | 34 |
1353695 | 1353695 | 2021-05-25 | Smith | Mississippi | 28129 | 1632 | 34 |
1350449 | 1350449 | 2021-05-24 | Smith | Mississippi | 28129 | 1632 | 34 |
1347203 | 1347203 | 2021-05-23 | Smith | Mississippi | 28129 | 1631 | 34 |
1343955 | 1343955 | 2021-05-22 | Smith | Mississippi | 28129 | 1631 | 34 |
1340706 | 1340706 | 2021-05-21 | Smith | Mississippi | 28129 | 1631 | 34 |
1337459 | 1337459 | 2021-05-20 | Smith | Mississippi | 28129 | 1631 | 34 |
1334212 | 1334212 | 2021-05-19 | Smith | Mississippi | 28129 | 1631 | 34 |
1330965 | 1330965 | 2021-05-18 | Smith | Mississippi | 28129 | 1628 | 34 |
1327718 | 1327718 | 2021-05-17 | Smith | Mississippi | 28129 | 1627 | 34 |
1324472 | 1324472 | 2021-05-16 | Smith | Mississippi | 28129 | 1625 | 34 |
1321226 | 1321226 | 2021-05-15 | Smith | Mississippi | 28129 | 1625 | 34 |
1317980 | 1317980 | 2021-05-14 | Smith | Mississippi | 28129 | 1625 | 34 |
1314732 | 1314732 | 2021-05-13 | Smith | Mississippi | 28129 | 1624 | 34 |
1311486 | 1311486 | 2021-05-12 | Smith | Mississippi | 28129 | 1623 | 34 |
1308239 | 1308239 | 2021-05-11 | Smith | Mississippi | 28129 | 1623 | 34 |
1304993 | 1304993 | 2021-05-10 | Smith | Mississippi | 28129 | 1623 | 34 |
1301747 | 1301747 | 2021-05-09 | Smith | Mississippi | 28129 | 1622 | 34 |
1298499 | 1298499 | 2021-05-08 | Smith | Mississippi | 28129 | 1622 | 34 |
1295253 | 1295253 | 2021-05-07 | Smith | Mississippi | 28129 | 1622 | 34 |
1292007 | 1292007 | 2021-05-06 | Smith | Mississippi | 28129 | 1622 | 34 |
1288761 | 1288761 | 2021-05-05 | Smith | Mississippi | 28129 | 1621 | 34 |
1285515 | 1285515 | 2021-05-04 | Smith | Mississippi | 28129 | 1620 | 34 |
1282269 | 1282269 | 2021-05-03 | Smith | Mississippi | 28129 | 1619 | 34 |
1279022 | 1279022 | 2021-05-02 | Smith | Mississippi | 28129 | 1619 | 34 |
1275775 | 1275775 | 2021-05-01 | Smith | Mississippi | 28129 | 1619 | 34 |
1272528 | 1272528 | 2021-04-30 | Smith | Mississippi | 28129 | 1619 | 34 |
1269281 | 1269281 | 2021-04-29 | Smith | Mississippi | 28129 | 1617 | 34 |
1266034 | 1266034 | 2021-04-28 | Smith | Mississippi | 28129 | 1617 | 34 |
1262787 | 1262787 | 2021-04-27 | Smith | Mississippi | 28129 | 1615 | 34 |
1259540 | 1259540 | 2021-04-26 | Smith | Mississippi | 28129 | 1613 | 34 |
1256293 | 1256293 | 2021-04-25 | Smith | Mississippi | 28129 | 1613 | 34 |
1253046 | 1253046 | 2021-04-24 | Smith | Mississippi | 28129 | 1613 | 34 |
1249799 | 1249799 | 2021-04-23 | Smith | Mississippi | 28129 | 1613 | 34 |
1246552 | 1246552 | 2021-04-22 | Smith | Mississippi | 28129 | 1610 | 34 |
1243305 | 1243305 | 2021-04-21 | Smith | Mississippi | 28129 | 1607 | 34 |
1240058 | 1240058 | 2021-04-20 | Smith | Mississippi | 28129 | 1606 | 34 |
1236811 | 1236811 | 2021-04-19 | Smith | Mississippi | 28129 | 1597 | 34 |
1233564 | 1233564 | 2021-04-18 | Smith | Mississippi | 28129 | 1594 | 34 |
1230316 | 1230316 | 2021-04-17 | Smith | Mississippi | 28129 | 1594 | 34 |
1227068 | 1227068 | 2021-04-16 | Smith | Mississippi | 28129 | 1593 | 34 |
1223820 | 1223820 | 2021-04-15 | Smith | Mississippi | 28129 | 1592 | 34 |
1220573 | 1220573 | 2021-04-14 | Smith | Mississippi | 28129 | 1590 | 34 |
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);