ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 22079 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811278 | 1811278 | 2021-10-13 | Rapides | Louisiana | 22079 | 20996 | 453 |
1808029 | 1808029 | 2021-10-12 | Rapides | Louisiana | 22079 | 20987 | 453 |
1804778 | 1804778 | 2021-10-11 | Rapides | Louisiana | 22079 | 20937 | 452 |
1801529 | 1801529 | 2021-10-10 | Rapides | Louisiana | 22079 | 20912 | 452 |
1798280 | 1798280 | 2021-10-09 | Rapides | Louisiana | 22079 | 20912 | 452 |
1795031 | 1795031 | 2021-10-08 | Rapides | Louisiana | 22079 | 20912 | 452 |
1791783 | 1791783 | 2021-10-07 | Rapides | Louisiana | 22079 | 20888 | 451 |
1788534 | 1788534 | 2021-10-06 | Rapides | Louisiana | 22079 | 20865 | 451 |
1785285 | 1785285 | 2021-10-05 | Rapides | Louisiana | 22079 | 20843 | 448 |
1782036 | 1782036 | 2021-10-04 | Rapides | Louisiana | 22079 | 20806 | 448 |
1778786 | 1778786 | 2021-10-03 | Rapides | Louisiana | 22079 | 20768 | 448 |
1775536 | 1775536 | 2021-10-02 | Rapides | Louisiana | 22079 | 20768 | 448 |
1772286 | 1772286 | 2021-10-01 | Rapides | Louisiana | 22079 | 20768 | 448 |
1769037 | 1769037 | 2021-09-30 | Rapides | Louisiana | 22079 | 20736 | 446 |
1765788 | 1765788 | 2021-09-29 | Rapides | Louisiana | 22079 | 20720 | 445 |
1762539 | 1762539 | 2021-09-28 | Rapides | Louisiana | 22079 | 20683 | 445 |
1759291 | 1759291 | 2021-09-27 | Rapides | Louisiana | 22079 | 20651 | 443 |
1756043 | 1756043 | 2021-09-26 | Rapides | Louisiana | 22079 | 20569 | 442 |
1752795 | 1752795 | 2021-09-25 | Rapides | Louisiana | 22079 | 20569 | 442 |
1749546 | 1749546 | 2021-09-24 | Rapides | Louisiana | 22079 | 20569 | 442 |
1746296 | 1746296 | 2021-09-23 | Rapides | Louisiana | 22079 | 20552 | 441 |
1743047 | 1743047 | 2021-09-22 | Rapides | Louisiana | 22079 | 20497 | 441 |
1739798 | 1739798 | 2021-09-21 | Rapides | Louisiana | 22079 | 20420 | 437 |
1736549 | 1736549 | 2021-09-20 | Rapides | Louisiana | 22079 | 20391 | 433 |
1733299 | 1733299 | 2021-09-19 | Rapides | Louisiana | 22079 | 20292 | 430 |
1730049 | 1730049 | 2021-09-18 | Rapides | Louisiana | 22079 | 20292 | 430 |
1726799 | 1726799 | 2021-09-17 | Rapides | Louisiana | 22079 | 20292 | 430 |
1723550 | 1723550 | 2021-09-16 | Rapides | Louisiana | 22079 | 20207 | 426 |
1720301 | 1720301 | 2021-09-15 | Rapides | Louisiana | 22079 | 20165 | 425 |
1717053 | 1717053 | 2021-09-14 | Rapides | Louisiana | 22079 | 20125 | 422 |
1713807 | 1713807 | 2021-09-13 | Rapides | Louisiana | 22079 | 20033 | 414 |
1710560 | 1710560 | 2021-09-12 | Rapides | Louisiana | 22079 | 19900 | 409 |
1707313 | 1707313 | 2021-09-11 | Rapides | Louisiana | 22079 | 19900 | 409 |
1704065 | 1704065 | 2021-09-10 | Rapides | Louisiana | 22079 | 19900 | 409 |
1700815 | 1700815 | 2021-09-09 | Rapides | Louisiana | 22079 | 19846 | 408 |
1697566 | 1697566 | 2021-09-08 | Rapides | Louisiana | 22079 | 19528 | 407 |
1694318 | 1694318 | 2021-09-07 | Rapides | Louisiana | 22079 | 19434 | 400 |
1691069 | 1691069 | 2021-09-06 | Rapides | Louisiana | 22079 | 19262 | 397 |
1687819 | 1687819 | 2021-09-05 | Rapides | Louisiana | 22079 | 19262 | 397 |
1684569 | 1684569 | 2021-09-04 | Rapides | Louisiana | 22079 | 19262 | 397 |
1681318 | 1681318 | 2021-09-03 | Rapides | Louisiana | 22079 | 19262 | 397 |
1678070 | 1678070 | 2021-09-02 | Rapides | Louisiana | 22079 | 19121 | 394 |
1674823 | 1674823 | 2021-09-01 | Rapides | Louisiana | 22079 | 19022 | 391 |
1671574 | 1671574 | 2021-08-31 | Rapides | Louisiana | 22079 | 18539 | 384 |
1668327 | 1668327 | 2021-08-30 | Rapides | Louisiana | 22079 | 18539 | 384 |
1665080 | 1665080 | 2021-08-29 | Rapides | Louisiana | 22079 | 18539 | 384 |
1661832 | 1661832 | 2021-08-28 | Rapides | Louisiana | 22079 | 18539 | 384 |
1658584 | 1658584 | 2021-08-27 | Rapides | Louisiana | 22079 | 18539 | 384 |
1655336 | 1655336 | 2021-08-26 | Rapides | Louisiana | 22079 | 18482 | 383 |
1652089 | 1652089 | 2021-08-25 | Rapides | Louisiana | 22079 | 18313 | 381 |
1648840 | 1648840 | 2021-08-24 | Rapides | Louisiana | 22079 | 17963 | 375 |
1645592 | 1645592 | 2021-08-23 | Rapides | Louisiana | 22079 | 17871 | 374 |
1642343 | 1642343 | 2021-08-22 | Rapides | Louisiana | 22079 | 17574 | 367 |
1639093 | 1639093 | 2021-08-21 | Rapides | Louisiana | 22079 | 17574 | 367 |
1635843 | 1635843 | 2021-08-20 | Rapides | Louisiana | 22079 | 17574 | 367 |
1632593 | 1632593 | 2021-08-19 | Rapides | Louisiana | 22079 | 17267 | 365 |
1629346 | 1629346 | 2021-08-18 | Rapides | Louisiana | 22079 | 16995 | 365 |
1626099 | 1626099 | 2021-08-17 | Rapides | Louisiana | 22079 | 16742 | 361 |
1622852 | 1622852 | 2021-08-16 | Rapides | Louisiana | 22079 | 16642 | 356 |
1619605 | 1619605 | 2021-08-15 | Rapides | Louisiana | 22079 | 16209 | 355 |
1616357 | 1616357 | 2021-08-14 | Rapides | Louisiana | 22079 | 16209 | 355 |
1613108 | 1613108 | 2021-08-13 | Rapides | Louisiana | 22079 | 16209 | 355 |
1609860 | 1609860 | 2021-08-12 | Rapides | Louisiana | 22079 | 15898 | 355 |
1606611 | 1606611 | 2021-08-11 | Rapides | Louisiana | 22079 | 15792 | 352 |
1603362 | 1603362 | 2021-08-10 | Rapides | Louisiana | 22079 | 15632 | 349 |
1600113 | 1600113 | 2021-08-09 | Rapides | Louisiana | 22079 | 15420 | 346 |
1596865 | 1596865 | 2021-08-08 | Rapides | Louisiana | 22079 | 14920 | 345 |
1593616 | 1593616 | 2021-08-07 | Rapides | Louisiana | 22079 | 14920 | 345 |
1590367 | 1590367 | 2021-08-06 | Rapides | Louisiana | 22079 | 14920 | 345 |
1587118 | 1587118 | 2021-08-05 | Rapides | Louisiana | 22079 | 14822 | 344 |
1583868 | 1583868 | 2021-08-04 | Rapides | Louisiana | 22079 | 14698 | 344 |
1580618 | 1580618 | 2021-08-03 | Rapides | Louisiana | 22079 | 14568 | 341 |
1577369 | 1577369 | 2021-08-02 | Rapides | Louisiana | 22079 | 14478 | 334 |
1574121 | 1574121 | 2021-08-01 | Rapides | Louisiana | 22079 | 14181 | 334 |
1570873 | 1570873 | 2021-07-31 | Rapides | Louisiana | 22079 | 14181 | 334 |
1567625 | 1567625 | 2021-07-30 | Rapides | Louisiana | 22079 | 14181 | 334 |
1564377 | 1564377 | 2021-07-29 | Rapides | Louisiana | 22079 | 14111 | 334 |
1561129 | 1561129 | 2021-07-28 | Rapides | Louisiana | 22079 | 13993 | 334 |
1557882 | 1557882 | 2021-07-27 | Rapides | Louisiana | 22079 | 13890 | 334 |
1554635 | 1554635 | 2021-07-26 | Rapides | Louisiana | 22079 | 13652 | 331 |
1551388 | 1551388 | 2021-07-25 | Rapides | Louisiana | 22079 | 13530 | 330 |
1548141 | 1548141 | 2021-07-24 | Rapides | Louisiana | 22079 | 13530 | 330 |
1544894 | 1544894 | 2021-07-23 | Rapides | Louisiana | 22079 | 13530 | 330 |
1541646 | 1541646 | 2021-07-22 | Rapides | Louisiana | 22079 | 13471 | 330 |
1538399 | 1538399 | 2021-07-21 | Rapides | Louisiana | 22079 | 13412 | 330 |
1535151 | 1535151 | 2021-07-20 | Rapides | Louisiana | 22079 | 13222 | 330 |
1531904 | 1531904 | 2021-07-19 | Rapides | Louisiana | 22079 | 13198 | 329 |
1528657 | 1528657 | 2021-07-18 | Rapides | Louisiana | 22079 | 13121 | 328 |
1525410 | 1525410 | 2021-07-17 | Rapides | Louisiana | 22079 | 13121 | 328 |
1522162 | 1522162 | 2021-07-16 | Rapides | Louisiana | 22079 | 13121 | 328 |
1518914 | 1518914 | 2021-07-15 | Rapides | Louisiana | 22079 | 13070 | 328 |
1515667 | 1515667 | 2021-07-14 | Rapides | Louisiana | 22079 | 13026 | 328 |
1512421 | 1512421 | 2021-07-13 | Rapides | Louisiana | 22079 | 12972 | 328 |
1509174 | 1509174 | 2021-07-12 | Rapides | Louisiana | 22079 | 12947 | 328 |
1505928 | 1505928 | 2021-07-11 | Rapides | Louisiana | 22079 | 12895 | 328 |
1502682 | 1502682 | 2021-07-10 | Rapides | Louisiana | 22079 | 12895 | 328 |
1499436 | 1499436 | 2021-07-09 | Rapides | Louisiana | 22079 | 12895 | 328 |
1496189 | 1496189 | 2021-07-08 | Rapides | Louisiana | 22079 | 12851 | 328 |
1492943 | 1492943 | 2021-07-07 | Rapides | Louisiana | 22079 | 12827 | 328 |
1489696 | 1489696 | 2021-07-06 | Rapides | Louisiana | 22079 | 12797 | 328 |
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);