ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 22017 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811247 | 1811247 | 2021-10-13 | Caddo | Louisiana | 22017 | 38990 | 935 |
1807998 | 1807998 | 2021-10-12 | Caddo | Louisiana | 22017 | 38959 | 931 |
1804747 | 1804747 | 2021-10-11 | Caddo | Louisiana | 22017 | 38870 | 931 |
1801498 | 1801498 | 2021-10-10 | Caddo | Louisiana | 22017 | 38761 | 930 |
1798249 | 1798249 | 2021-10-09 | Caddo | Louisiana | 22017 | 38761 | 930 |
1795000 | 1795000 | 2021-10-08 | Caddo | Louisiana | 22017 | 38761 | 930 |
1791752 | 1791752 | 2021-10-07 | Caddo | Louisiana | 22017 | 38710 | 930 |
1788503 | 1788503 | 2021-10-06 | Caddo | Louisiana | 22017 | 38657 | 928 |
1785254 | 1785254 | 2021-10-05 | Caddo | Louisiana | 22017 | 38587 | 924 |
1782005 | 1782005 | 2021-10-04 | Caddo | Louisiana | 22017 | 38531 | 921 |
1778755 | 1778755 | 2021-10-03 | Caddo | Louisiana | 22017 | 38375 | 919 |
1775505 | 1775505 | 2021-10-02 | Caddo | Louisiana | 22017 | 38375 | 919 |
1772255 | 1772255 | 2021-10-01 | Caddo | Louisiana | 22017 | 38375 | 919 |
1769006 | 1769006 | 2021-09-30 | Caddo | Louisiana | 22017 | 38306 | 919 |
1765757 | 1765757 | 2021-09-29 | Caddo | Louisiana | 22017 | 38242 | 916 |
1762508 | 1762508 | 2021-09-28 | Caddo | Louisiana | 22017 | 38170 | 914 |
1759260 | 1759260 | 2021-09-27 | Caddo | Louisiana | 22017 | 38098 | 911 |
1756012 | 1756012 | 2021-09-26 | Caddo | Louisiana | 22017 | 37913 | 910 |
1752764 | 1752764 | 2021-09-25 | Caddo | Louisiana | 22017 | 37913 | 910 |
1749515 | 1749515 | 2021-09-24 | Caddo | Louisiana | 22017 | 37913 | 910 |
1746265 | 1746265 | 2021-09-23 | Caddo | Louisiana | 22017 | 37854 | 901 |
1743016 | 1743016 | 2021-09-22 | Caddo | Louisiana | 22017 | 37757 | 899 |
1739767 | 1739767 | 2021-09-21 | Caddo | Louisiana | 22017 | 37668 | 899 |
1736518 | 1736518 | 2021-09-20 | Caddo | Louisiana | 22017 | 37585 | 898 |
1733268 | 1733268 | 2021-09-19 | Caddo | Louisiana | 22017 | 37373 | 895 |
1730018 | 1730018 | 2021-09-18 | Caddo | Louisiana | 22017 | 37373 | 895 |
1726768 | 1726768 | 2021-09-17 | Caddo | Louisiana | 22017 | 37373 | 895 |
1723519 | 1723519 | 2021-09-16 | Caddo | Louisiana | 22017 | 37282 | 886 |
1720270 | 1720270 | 2021-09-15 | Caddo | Louisiana | 22017 | 37203 | 885 |
1717022 | 1717022 | 2021-09-14 | Caddo | Louisiana | 22017 | 37090 | 882 |
1713776 | 1713776 | 2021-09-13 | Caddo | Louisiana | 22017 | 36986 | 880 |
1710529 | 1710529 | 2021-09-12 | Caddo | Louisiana | 22017 | 36741 | 866 |
1707282 | 1707282 | 2021-09-11 | Caddo | Louisiana | 22017 | 36741 | 866 |
1704034 | 1704034 | 2021-09-10 | Caddo | Louisiana | 22017 | 36741 | 866 |
1700784 | 1700784 | 2021-09-09 | Caddo | Louisiana | 22017 | 36614 | 863 |
1697535 | 1697535 | 2021-09-08 | Caddo | Louisiana | 22017 | 36467 | 862 |
1694287 | 1694287 | 2021-09-07 | Caddo | Louisiana | 22017 | 36342 | 857 |
1691038 | 1691038 | 2021-09-06 | Caddo | Louisiana | 22017 | 36002 | 855 |
1687788 | 1687788 | 2021-09-05 | Caddo | Louisiana | 22017 | 36002 | 855 |
1684538 | 1684538 | 2021-09-04 | Caddo | Louisiana | 22017 | 36002 | 855 |
1681287 | 1681287 | 2021-09-03 | Caddo | Louisiana | 22017 | 36002 | 855 |
1678039 | 1678039 | 2021-09-02 | Caddo | Louisiana | 22017 | 35889 | 851 |
1674792 | 1674792 | 2021-09-01 | Caddo | Louisiana | 22017 | 35761 | 847 |
1671543 | 1671543 | 2021-08-31 | Caddo | Louisiana | 22017 | 35084 | 822 |
1668296 | 1668296 | 2021-08-30 | Caddo | Louisiana | 22017 | 35084 | 822 |
1665049 | 1665049 | 2021-08-29 | Caddo | Louisiana | 22017 | 35084 | 822 |
1661801 | 1661801 | 2021-08-28 | Caddo | Louisiana | 22017 | 35084 | 822 |
1658553 | 1658553 | 2021-08-27 | Caddo | Louisiana | 22017 | 35084 | 822 |
1655305 | 1655305 | 2021-08-26 | Caddo | Louisiana | 22017 | 34939 | 820 |
1652058 | 1652058 | 2021-08-25 | Caddo | Louisiana | 22017 | 34739 | 816 |
1648809 | 1648809 | 2021-08-24 | Caddo | Louisiana | 22017 | 34535 | 811 |
1645561 | 1645561 | 2021-08-23 | Caddo | Louisiana | 22017 | 34295 | 805 |
1642312 | 1642312 | 2021-08-22 | Caddo | Louisiana | 22017 | 33744 | 803 |
1639062 | 1639062 | 2021-08-21 | Caddo | Louisiana | 22017 | 33744 | 803 |
1635812 | 1635812 | 2021-08-20 | Caddo | Louisiana | 22017 | 33744 | 803 |
1632562 | 1632562 | 2021-08-19 | Caddo | Louisiana | 22017 | 33536 | 798 |
1629315 | 1629315 | 2021-08-18 | Caddo | Louisiana | 22017 | 33320 | 797 |
1626068 | 1626068 | 2021-08-17 | Caddo | Louisiana | 22017 | 33134 | 795 |
1622821 | 1622821 | 2021-08-16 | Caddo | Louisiana | 22017 | 32858 | 789 |
1619574 | 1619574 | 2021-08-15 | Caddo | Louisiana | 22017 | 32223 | 786 |
1616326 | 1616326 | 2021-08-14 | Caddo | Louisiana | 22017 | 32223 | 786 |
1613077 | 1613077 | 2021-08-13 | Caddo | Louisiana | 22017 | 32223 | 786 |
1609829 | 1609829 | 2021-08-12 | Caddo | Louisiana | 22017 | 31970 | 784 |
1606580 | 1606580 | 2021-08-11 | Caddo | Louisiana | 22017 | 31709 | 784 |
1603331 | 1603331 | 2021-08-10 | Caddo | Louisiana | 22017 | 31410 | 784 |
1600082 | 1600082 | 2021-08-09 | Caddo | Louisiana | 22017 | 31138 | 783 |
1596834 | 1596834 | 2021-08-08 | Caddo | Louisiana | 22017 | 30523 | 781 |
1593585 | 1593585 | 2021-08-07 | Caddo | Louisiana | 22017 | 30523 | 781 |
1590336 | 1590336 | 2021-08-06 | Caddo | Louisiana | 22017 | 30523 | 781 |
1587087 | 1587087 | 2021-08-05 | Caddo | Louisiana | 22017 | 30320 | 777 |
1583837 | 1583837 | 2021-08-04 | Caddo | Louisiana | 22017 | 30058 | 777 |
1580587 | 1580587 | 2021-08-03 | Caddo | Louisiana | 22017 | 29839 | 776 |
1577338 | 1577338 | 2021-08-02 | Caddo | Louisiana | 22017 | 29638 | 773 |
1574090 | 1574090 | 2021-08-01 | Caddo | Louisiana | 22017 | 29190 | 771 |
1570842 | 1570842 | 2021-07-31 | Caddo | Louisiana | 22017 | 29190 | 771 |
1567594 | 1567594 | 2021-07-30 | Caddo | Louisiana | 22017 | 29190 | 771 |
1564346 | 1564346 | 2021-07-29 | Caddo | Louisiana | 22017 | 29005 | 770 |
1561098 | 1561098 | 2021-07-28 | Caddo | Louisiana | 22017 | 28850 | 770 |
1557851 | 1557851 | 2021-07-27 | Caddo | Louisiana | 22017 | 28699 | 770 |
1554604 | 1554604 | 2021-07-26 | Caddo | Louisiana | 22017 | 28505 | 770 |
1551357 | 1551357 | 2021-07-25 | Caddo | Louisiana | 22017 | 28253 | 770 |
1548110 | 1548110 | 2021-07-24 | Caddo | Louisiana | 22017 | 28253 | 770 |
1544863 | 1544863 | 2021-07-23 | Caddo | Louisiana | 22017 | 28253 | 770 |
1541615 | 1541615 | 2021-07-22 | Caddo | Louisiana | 22017 | 28122 | 768 |
1538368 | 1538368 | 2021-07-21 | Caddo | Louisiana | 22017 | 28035 | 768 |
1535120 | 1535120 | 2021-07-20 | Caddo | Louisiana | 22017 | 27930 | 768 |
1531873 | 1531873 | 2021-07-19 | Caddo | Louisiana | 22017 | 27852 | 768 |
1528626 | 1528626 | 2021-07-18 | Caddo | Louisiana | 22017 | 27682 | 767 |
1525379 | 1525379 | 2021-07-17 | Caddo | Louisiana | 22017 | 27682 | 767 |
1522131 | 1522131 | 2021-07-16 | Caddo | Louisiana | 22017 | 27682 | 767 |
1518883 | 1518883 | 2021-07-15 | Caddo | Louisiana | 22017 | 27629 | 767 |
1515636 | 1515636 | 2021-07-14 | Caddo | Louisiana | 22017 | 27580 | 766 |
1512390 | 1512390 | 2021-07-13 | Caddo | Louisiana | 22017 | 27536 | 766 |
1509143 | 1509143 | 2021-07-12 | Caddo | Louisiana | 22017 | 27491 | 765 |
1505897 | 1505897 | 2021-07-11 | Caddo | Louisiana | 22017 | 27424 | 766 |
1502651 | 1502651 | 2021-07-10 | Caddo | Louisiana | 22017 | 27424 | 766 |
1499405 | 1499405 | 2021-07-09 | Caddo | Louisiana | 22017 | 27424 | 766 |
1496158 | 1496158 | 2021-07-08 | Caddo | Louisiana | 22017 | 27397 | 765 |
1492912 | 1492912 | 2021-07-07 | Caddo | Louisiana | 22017 | 27371 | 763 |
1489665 | 1489665 | 2021-07-06 | Caddo | Louisiana | 22017 | 27343 | 763 |
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);