ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lafayette" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717343 | 1717343 | 2021-09-14 | Lafayette | Mississippi | 28071 | 7958 | 135 |
1714095 | 1714095 | 2021-09-13 | Lafayette | Mississippi | 28071 | 7905 | 135 |
1710849 | 1710849 | 2021-09-12 | Lafayette | Mississippi | 28071 | 7850 | 134 |
1707602 | 1707602 | 2021-09-11 | Lafayette | Mississippi | 28071 | 7850 | 134 |
1704355 | 1704355 | 2021-09-10 | Lafayette | Mississippi | 28071 | 7850 | 134 |
1701105 | 1701105 | 2021-09-09 | Lafayette | Mississippi | 28071 | 7806 | 133 |
1697856 | 1697856 | 2021-09-08 | Lafayette | Mississippi | 28071 | 7770 | 132 |
1694608 | 1694608 | 2021-09-07 | Lafayette | Mississippi | 28071 | 7732 | 131 |
1691359 | 1691359 | 2021-09-06 | Lafayette | Mississippi | 28071 | 7721 | 131 |
1688109 | 1688109 | 2021-09-05 | Lafayette | Mississippi | 28071 | 7644 | 130 |
1684859 | 1684859 | 2021-09-04 | Lafayette | Mississippi | 28071 | 7644 | 130 |
1681608 | 1681608 | 2021-09-03 | Lafayette | Mississippi | 28071 | 7644 | 130 |
1678360 | 1678360 | 2021-09-02 | Lafayette | Mississippi | 28071 | 7574 | 130 |
1675112 | 1675112 | 2021-09-01 | Lafayette | Mississippi | 28071 | 7500 | 130 |
1671864 | 1671864 | 2021-08-31 | Lafayette | Mississippi | 28071 | 7451 | 130 |
1668617 | 1668617 | 2021-08-30 | Lafayette | Mississippi | 28071 | 7433 | 130 |
1665370 | 1665370 | 2021-08-29 | Lafayette | Mississippi | 28071 | 7363 | 129 |
1662122 | 1662122 | 2021-08-28 | Lafayette | Mississippi | 28071 | 7363 | 129 |
1658874 | 1658874 | 2021-08-27 | Lafayette | Mississippi | 28071 | 7363 | 129 |
1655625 | 1655625 | 2021-08-26 | Lafayette | Mississippi | 28071 | 7326 | 129 |
1652378 | 1652378 | 2021-08-25 | Lafayette | Mississippi | 28071 | 7304 | 129 |
1649130 | 1649130 | 2021-08-24 | Lafayette | Mississippi | 28071 | 7290 | 129 |
1645881 | 1645881 | 2021-08-23 | Lafayette | Mississippi | 28071 | 7243 | 129 |
1642632 | 1642632 | 2021-08-22 | Lafayette | Mississippi | 28071 | 7191 | 128 |
1639382 | 1639382 | 2021-08-21 | Lafayette | Mississippi | 28071 | 7191 | 128 |
1636132 | 1636132 | 2021-08-20 | Lafayette | Mississippi | 28071 | 7191 | 128 |
1632882 | 1632882 | 2021-08-19 | Lafayette | Mississippi | 28071 | 7154 | 128 |
1629635 | 1629635 | 2021-08-18 | Lafayette | Mississippi | 28071 | 7124 | 128 |
1626388 | 1626388 | 2021-08-17 | Lafayette | Mississippi | 28071 | 7098 | 128 |
1623141 | 1623141 | 2021-08-16 | Lafayette | Mississippi | 28071 | 7077 | 128 |
1619894 | 1619894 | 2021-08-15 | Lafayette | Mississippi | 28071 | 7012 | 127 |
1616646 | 1616646 | 2021-08-14 | Lafayette | Mississippi | 28071 | 7012 | 127 |
1613398 | 1613398 | 2021-08-13 | Lafayette | Mississippi | 28071 | 7012 | 127 |
1610149 | 1610149 | 2021-08-12 | Lafayette | Mississippi | 28071 | 6960 | 127 |
1606901 | 1606901 | 2021-08-11 | Lafayette | Mississippi | 28071 | 6923 | 127 |
1603652 | 1603652 | 2021-08-10 | Lafayette | Mississippi | 28071 | 6858 | 127 |
1600403 | 1600403 | 2021-08-09 | Lafayette | Mississippi | 28071 | 6814 | 126 |
1597155 | 1597155 | 2021-08-08 | Lafayette | Mississippi | 28071 | 6734 | 126 |
1593906 | 1593906 | 2021-08-07 | Lafayette | Mississippi | 28071 | 6734 | 126 |
1590657 | 1590657 | 2021-08-06 | Lafayette | Mississippi | 28071 | 6734 | 126 |
1587408 | 1587408 | 2021-08-05 | Lafayette | Mississippi | 28071 | 6716 | 125 |
1584157 | 1584157 | 2021-08-04 | Lafayette | Mississippi | 28071 | 6658 | 125 |
1580908 | 1580908 | 2021-08-03 | Lafayette | Mississippi | 28071 | 6631 | 125 |
1577659 | 1577659 | 2021-08-02 | Lafayette | Mississippi | 28071 | 6604 | 125 |
1574411 | 1574411 | 2021-08-01 | Lafayette | Mississippi | 28071 | 6548 | 124 |
1571163 | 1571163 | 2021-07-31 | Lafayette | Mississippi | 28071 | 6548 | 124 |
1567915 | 1567915 | 2021-07-30 | Lafayette | Mississippi | 28071 | 6548 | 124 |
1564667 | 1564667 | 2021-07-29 | Lafayette | Mississippi | 28071 | 6535 | 124 |
1561419 | 1561419 | 2021-07-28 | Lafayette | Mississippi | 28071 | 6513 | 124 |
1558171 | 1558171 | 2021-07-27 | Lafayette | Mississippi | 28071 | 6502 | 124 |
1554924 | 1554924 | 2021-07-26 | Lafayette | Mississippi | 28071 | 6485 | 124 |
1551677 | 1551677 | 2021-07-25 | Lafayette | Mississippi | 28071 | 6459 | 124 |
1548430 | 1548430 | 2021-07-24 | Lafayette | Mississippi | 28071 | 6459 | 124 |
1545183 | 1545183 | 2021-07-23 | Lafayette | Mississippi | 28071 | 6459 | 124 |
1541935 | 1541935 | 2021-07-22 | Lafayette | Mississippi | 28071 | 6446 | 124 |
1538688 | 1538688 | 2021-07-21 | Lafayette | Mississippi | 28071 | 6429 | 124 |
1535441 | 1535441 | 2021-07-20 | Lafayette | Mississippi | 28071 | 6421 | 124 |
1532193 | 1532193 | 2021-07-19 | Lafayette | Mississippi | 28071 | 6402 | 124 |
1528946 | 1528946 | 2021-07-18 | Lafayette | Mississippi | 28071 | 6378 | 124 |
1525699 | 1525699 | 2021-07-17 | Lafayette | Mississippi | 28071 | 6378 | 124 |
1522452 | 1522452 | 2021-07-16 | Lafayette | Mississippi | 28071 | 6378 | 124 |
1519203 | 1519203 | 2021-07-15 | Lafayette | Mississippi | 28071 | 6370 | 124 |
1515956 | 1515956 | 2021-07-14 | Lafayette | Mississippi | 28071 | 6366 | 124 |
1512710 | 1512710 | 2021-07-13 | Lafayette | Mississippi | 28071 | 6361 | 124 |
1509463 | 1509463 | 2021-07-12 | Lafayette | Mississippi | 28071 | 6361 | 124 |
1506217 | 1506217 | 2021-07-11 | Lafayette | Mississippi | 28071 | 6351 | 124 |
1502971 | 1502971 | 2021-07-10 | Lafayette | Mississippi | 28071 | 6351 | 124 |
1499725 | 1499725 | 2021-07-09 | Lafayette | Mississippi | 28071 | 6351 | 124 |
1496479 | 1496479 | 2021-07-08 | Lafayette | Mississippi | 28071 | 6345 | 124 |
1493232 | 1493232 | 2021-07-07 | Lafayette | Mississippi | 28071 | 6343 | 124 |
1489985 | 1489985 | 2021-07-06 | Lafayette | Mississippi | 28071 | 6342 | 124 |
1486738 | 1486738 | 2021-07-05 | Lafayette | Mississippi | 28071 | 6335 | 123 |
1483492 | 1483492 | 2021-07-04 | Lafayette | Mississippi | 28071 | 6335 | 123 |
1480246 | 1480246 | 2021-07-03 | Lafayette | Mississippi | 28071 | 6335 | 123 |
1476999 | 1476999 | 2021-07-02 | Lafayette | Mississippi | 28071 | 6335 | 123 |
1473753 | 1473753 | 2021-07-01 | Lafayette | Mississippi | 28071 | 6335 | 122 |
1470507 | 1470507 | 2021-06-30 | Lafayette | Mississippi | 28071 | 6333 | 122 |
1467262 | 1467262 | 2021-06-29 | Lafayette | Mississippi | 28071 | 6331 | 122 |
1464017 | 1464017 | 2021-06-28 | Lafayette | Mississippi | 28071 | 6325 | 121 |
1460772 | 1460772 | 2021-06-27 | Lafayette | Mississippi | 28071 | 6319 | 121 |
1457527 | 1457527 | 2021-06-26 | Lafayette | Mississippi | 28071 | 6319 | 121 |
1454282 | 1454282 | 2021-06-25 | Lafayette | Mississippi | 28071 | 6319 | 121 |
1451037 | 1451037 | 2021-06-24 | Lafayette | Mississippi | 28071 | 6319 | 121 |
1447791 | 1447791 | 2021-06-23 | Lafayette | Mississippi | 28071 | 6315 | 121 |
1444546 | 1444546 | 2021-06-22 | Lafayette | Mississippi | 28071 | 6314 | 121 |
1441301 | 1441301 | 2021-06-21 | Lafayette | Mississippi | 28071 | 6314 | 121 |
1438055 | 1438055 | 2021-06-20 | Lafayette | Mississippi | 28071 | 6313 | 121 |
1434808 | 1434808 | 2021-06-19 | Lafayette | Mississippi | 28071 | 6313 | 121 |
1431561 | 1431561 | 2021-06-18 | Lafayette | Mississippi | 28071 | 6313 | 121 |
1428316 | 1428316 | 2021-06-17 | Lafayette | Mississippi | 28071 | 6310 | 121 |
1425071 | 1425071 | 2021-06-16 | Lafayette | Mississippi | 28071 | 6303 | 121 |
1421823 | 1421823 | 2021-06-15 | Lafayette | Mississippi | 28071 | 6301 | 120 |
1418578 | 1418578 | 2021-06-14 | Lafayette | Mississippi | 28071 | 6298 | 120 |
1415333 | 1415333 | 2021-06-13 | Lafayette | Mississippi | 28071 | 6295 | 120 |
1412087 | 1412087 | 2021-06-12 | Lafayette | Mississippi | 28071 | 6295 | 120 |
1408842 | 1408842 | 2021-06-11 | Lafayette | Mississippi | 28071 | 6295 | 120 |
1405597 | 1405597 | 2021-06-10 | Lafayette | Mississippi | 28071 | 6294 | 120 |
1402351 | 1402351 | 2021-06-09 | Lafayette | Mississippi | 28071 | 6287 | 120 |
1399106 | 1399106 | 2021-06-08 | Lafayette | Mississippi | 28071 | 6285 | 120 |
1395860 | 1395860 | 2021-06-07 | Lafayette | Mississippi | 28071 | 6283 | 120 |
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);