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 |
---|---|---|---|---|---|---|---|
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 |
1486418 | 1486418 | 2021-07-05 | Caddo | Louisiana | 22017 | 27284 | 762 |
1483172 | 1483172 | 2021-07-04 | Caddo | Louisiana | 22017 | 27284 | 762 |
1479925 | 1479925 | 2021-07-03 | Caddo | Louisiana | 22017 | 27284 | 762 |
1476679 | 1476679 | 2021-07-02 | Caddo | Louisiana | 22017 | 27284 | 762 |
1473433 | 1473433 | 2021-07-01 | Caddo | Louisiana | 22017 | 27264 | 761 |
1470187 | 1470187 | 2021-06-30 | Caddo | Louisiana | 22017 | 27253 | 761 |
1466942 | 1466942 | 2021-06-29 | Caddo | Louisiana | 22017 | 27240 | 761 |
1463697 | 1463697 | 2021-06-28 | Caddo | Louisiana | 22017 | 27223 | 761 |
1460452 | 1460452 | 2021-06-27 | Caddo | Louisiana | 22017 | 27197 | 761 |
1457207 | 1457207 | 2021-06-26 | Caddo | Louisiana | 22017 | 27197 | 761 |
1453962 | 1453962 | 2021-06-25 | Caddo | Louisiana | 22017 | 27197 | 761 |
1450716 | 1450716 | 2021-06-24 | Caddo | Louisiana | 22017 | 27187 | 761 |
1447471 | 1447471 | 2021-06-23 | Caddo | Louisiana | 22017 | 27161 | 761 |
1444226 | 1444226 | 2021-06-22 | Caddo | Louisiana | 22017 | 27136 | 760 |
1440981 | 1440981 | 2021-06-21 | Caddo | Louisiana | 22017 | 27127 | 760 |
1437734 | 1437734 | 2021-06-20 | Caddo | Louisiana | 22017 | 27089 | 759 |
1434487 | 1434487 | 2021-06-19 | Caddo | Louisiana | 22017 | 27089 | 759 |
1431241 | 1431241 | 2021-06-18 | Caddo | Louisiana | 22017 | 27089 | 759 |
1427996 | 1427996 | 2021-06-17 | Caddo | Louisiana | 22017 | 27060 | 759 |
1424751 | 1424751 | 2021-06-16 | Caddo | Louisiana | 22017 | 27041 | 759 |
1421503 | 1421503 | 2021-06-15 | Caddo | Louisiana | 22017 | 27023 | 759 |
1418258 | 1418258 | 2021-06-14 | Caddo | Louisiana | 22017 | 26972 | 759 |
1415012 | 1415012 | 2021-06-13 | Caddo | Louisiana | 22017 | 26944 | 759 |
1411767 | 1411767 | 2021-06-12 | Caddo | Louisiana | 22017 | 26944 | 759 |
1408522 | 1408522 | 2021-06-11 | Caddo | Louisiana | 22017 | 26944 | 759 |
1405276 | 1405276 | 2021-06-10 | Caddo | Louisiana | 22017 | 26919 | 758 |
1402031 | 1402031 | 2021-06-09 | Caddo | Louisiana | 22017 | 26887 | 757 |
1398786 | 1398786 | 2021-06-08 | Caddo | Louisiana | 22017 | 26848 | 757 |
1395539 | 1395539 | 2021-06-07 | Caddo | Louisiana | 22017 | 26818 | 755 |
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);