ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 22103 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717065 | 1717065 | 2021-09-14 | St. Tammany | Louisiana | 22103 | 41470 | 645 |
1713819 | 1713819 | 2021-09-13 | St. Tammany | Louisiana | 22103 | 41389 | 644 |
1710572 | 1710572 | 2021-09-12 | St. Tammany | Louisiana | 22103 | 41120 | 644 |
1707325 | 1707325 | 2021-09-11 | St. Tammany | Louisiana | 22103 | 41120 | 644 |
1704077 | 1704077 | 2021-09-10 | St. Tammany | Louisiana | 22103 | 41120 | 644 |
1700827 | 1700827 | 2021-09-09 | St. Tammany | Louisiana | 22103 | 40968 | 644 |
1697578 | 1697578 | 2021-09-08 | St. Tammany | Louisiana | 22103 | 40853 | 636 |
1694330 | 1694330 | 2021-09-07 | St. Tammany | Louisiana | 22103 | 40740 | 636 |
1691081 | 1691081 | 2021-09-06 | St. Tammany | Louisiana | 22103 | 40391 | 626 |
1687831 | 1687831 | 2021-09-05 | St. Tammany | Louisiana | 22103 | 40391 | 626 |
1684581 | 1684581 | 2021-09-04 | St. Tammany | Louisiana | 22103 | 40391 | 626 |
1681330 | 1681330 | 2021-09-03 | St. Tammany | Louisiana | 22103 | 40391 | 626 |
1678082 | 1678082 | 2021-09-02 | St. Tammany | Louisiana | 22103 | 40332 | 622 |
1674835 | 1674835 | 2021-09-01 | St. Tammany | Louisiana | 22103 | 40298 | 614 |
1671586 | 1671586 | 2021-08-31 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1668339 | 1668339 | 2021-08-30 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1665092 | 1665092 | 2021-08-29 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1661844 | 1661844 | 2021-08-28 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1658596 | 1658596 | 2021-08-27 | St. Tammany | Louisiana | 22103 | 39777 | 604 |
1655348 | 1655348 | 2021-08-26 | St. Tammany | Louisiana | 22103 | 39541 | 602 |
1652101 | 1652101 | 2021-08-25 | St. Tammany | Louisiana | 22103 | 39229 | 600 |
1648852 | 1648852 | 2021-08-24 | St. Tammany | Louisiana | 22103 | 38863 | 594 |
1645604 | 1645604 | 2021-08-23 | St. Tammany | Louisiana | 22103 | 38626 | 589 |
1642355 | 1642355 | 2021-08-22 | St. Tammany | Louisiana | 22103 | 37854 | 586 |
1639105 | 1639105 | 2021-08-21 | St. Tammany | Louisiana | 22103 | 37854 | 586 |
1635855 | 1635855 | 2021-08-20 | St. Tammany | Louisiana | 22103 | 37854 | 586 |
1632605 | 1632605 | 2021-08-19 | St. Tammany | Louisiana | 22103 | 37472 | 586 |
1629358 | 1629358 | 2021-08-18 | St. Tammany | Louisiana | 22103 | 37128 | 586 |
1626111 | 1626111 | 2021-08-17 | St. Tammany | Louisiana | 22103 | 36760 | 582 |
1622864 | 1622864 | 2021-08-16 | St. Tammany | Louisiana | 22103 | 36477 | 573 |
1619617 | 1619617 | 2021-08-15 | St. Tammany | Louisiana | 22103 | 35570 | 566 |
1616369 | 1616369 | 2021-08-14 | St. Tammany | Louisiana | 22103 | 35570 | 566 |
1613120 | 1613120 | 2021-08-13 | St. Tammany | Louisiana | 22103 | 35570 | 566 |
1609872 | 1609872 | 2021-08-12 | St. Tammany | Louisiana | 22103 | 35120 | 561 |
1606623 | 1606623 | 2021-08-11 | St. Tammany | Louisiana | 22103 | 34740 | 560 |
1603374 | 1603374 | 2021-08-10 | St. Tammany | Louisiana | 22103 | 34414 | 558 |
1600125 | 1600125 | 2021-08-09 | St. Tammany | Louisiana | 22103 | 34087 | 552 |
1596877 | 1596877 | 2021-08-08 | St. Tammany | Louisiana | 22103 | 33050 | 549 |
1593628 | 1593628 | 2021-08-07 | St. Tammany | Louisiana | 22103 | 33050 | 549 |
1590379 | 1590379 | 2021-08-06 | St. Tammany | Louisiana | 22103 | 33050 | 549 |
1587130 | 1587130 | 2021-08-05 | St. Tammany | Louisiana | 22103 | 32607 | 548 |
1583880 | 1583880 | 2021-08-04 | St. Tammany | Louisiana | 22103 | 32223 | 545 |
1580630 | 1580630 | 2021-08-03 | St. Tammany | Louisiana | 22103 | 31912 | 544 |
1577381 | 1577381 | 2021-08-02 | St. Tammany | Louisiana | 22103 | 31644 | 541 |
1574133 | 1574133 | 2021-08-01 | St. Tammany | Louisiana | 22103 | 30769 | 541 |
1570885 | 1570885 | 2021-07-31 | St. Tammany | Louisiana | 22103 | 30769 | 541 |
1567637 | 1567637 | 2021-07-30 | St. Tammany | Louisiana | 22103 | 30769 | 541 |
1564389 | 1564389 | 2021-07-29 | St. Tammany | Louisiana | 22103 | 30397 | 538 |
1561141 | 1561141 | 2021-07-28 | St. Tammany | Louisiana | 22103 | 30071 | 533 |
1557894 | 1557894 | 2021-07-27 | St. Tammany | Louisiana | 22103 | 29757 | 533 |
1554647 | 1554647 | 2021-07-26 | St. Tammany | Louisiana | 22103 | 29527 | 533 |
1551400 | 1551400 | 2021-07-25 | St. Tammany | Louisiana | 22103 | 28915 | 532 |
1548153 | 1548153 | 2021-07-24 | St. Tammany | Louisiana | 22103 | 28915 | 532 |
1544906 | 1544906 | 2021-07-23 | St. Tammany | Louisiana | 22103 | 28915 | 532 |
1541658 | 1541658 | 2021-07-22 | St. Tammany | Louisiana | 22103 | 28664 | 531 |
1538411 | 1538411 | 2021-07-21 | St. Tammany | Louisiana | 22103 | 28428 | 531 |
1535163 | 1535163 | 2021-07-20 | St. Tammany | Louisiana | 22103 | 28157 | 531 |
1531916 | 1531916 | 2021-07-19 | St. Tammany | Louisiana | 22103 | 28032 | 531 |
1528669 | 1528669 | 2021-07-18 | St. Tammany | Louisiana | 22103 | 27631 | 531 |
1525422 | 1525422 | 2021-07-17 | St. Tammany | Louisiana | 22103 | 27631 | 531 |
1522174 | 1522174 | 2021-07-16 | St. Tammany | Louisiana | 22103 | 27631 | 531 |
1518926 | 1518926 | 2021-07-15 | St. Tammany | Louisiana | 22103 | 27489 | 531 |
1515679 | 1515679 | 2021-07-14 | St. Tammany | Louisiana | 22103 | 27343 | 531 |
1512433 | 1512433 | 2021-07-13 | St. Tammany | Louisiana | 22103 | 27195 | 531 |
1509186 | 1509186 | 2021-07-12 | St. Tammany | Louisiana | 22103 | 27122 | 531 |
1505940 | 1505940 | 2021-07-11 | St. Tammany | Louisiana | 22103 | 26952 | 530 |
1502694 | 1502694 | 2021-07-10 | St. Tammany | Louisiana | 22103 | 26952 | 530 |
1499448 | 1499448 | 2021-07-09 | St. Tammany | Louisiana | 22103 | 26952 | 530 |
1496201 | 1496201 | 2021-07-08 | St. Tammany | Louisiana | 22103 | 26844 | 530 |
1492955 | 1492955 | 2021-07-07 | St. Tammany | Louisiana | 22103 | 26781 | 530 |
1489708 | 1489708 | 2021-07-06 | St. Tammany | Louisiana | 22103 | 26698 | 530 |
1486461 | 1486461 | 2021-07-05 | St. Tammany | Louisiana | 22103 | 26548 | 529 |
1483215 | 1483215 | 2021-07-04 | St. Tammany | Louisiana | 22103 | 26548 | 529 |
1479968 | 1479968 | 2021-07-03 | St. Tammany | Louisiana | 22103 | 26548 | 529 |
1476722 | 1476722 | 2021-07-02 | St. Tammany | Louisiana | 22103 | 26548 | 529 |
1473476 | 1473476 | 2021-07-01 | St. Tammany | Louisiana | 22103 | 26506 | 528 |
1470230 | 1470230 | 2021-06-30 | St. Tammany | Louisiana | 22103 | 26464 | 528 |
1466985 | 1466985 | 2021-06-29 | St. Tammany | Louisiana | 22103 | 26444 | 528 |
1463740 | 1463740 | 2021-06-28 | St. Tammany | Louisiana | 22103 | 26408 | 528 |
1460495 | 1460495 | 2021-06-27 | St. Tammany | Louisiana | 22103 | 26353 | 528 |
1457250 | 1457250 | 2021-06-26 | St. Tammany | Louisiana | 22103 | 26353 | 528 |
1454005 | 1454005 | 2021-06-25 | St. Tammany | Louisiana | 22103 | 26353 | 528 |
1450759 | 1450759 | 2021-06-24 | St. Tammany | Louisiana | 22103 | 26330 | 528 |
1447514 | 1447514 | 2021-06-23 | St. Tammany | Louisiana | 22103 | 26312 | 528 |
1444269 | 1444269 | 2021-06-22 | St. Tammany | Louisiana | 22103 | 26293 | 528 |
1441024 | 1441024 | 2021-06-21 | St. Tammany | Louisiana | 22103 | 26262 | 528 |
1437777 | 1437777 | 2021-06-20 | St. Tammany | Louisiana | 22103 | 26224 | 528 |
1434530 | 1434530 | 2021-06-19 | St. Tammany | Louisiana | 22103 | 26224 | 528 |
1431284 | 1431284 | 2021-06-18 | St. Tammany | Louisiana | 22103 | 26224 | 528 |
1428039 | 1428039 | 2021-06-17 | St. Tammany | Louisiana | 22103 | 26210 | 528 |
1424794 | 1424794 | 2021-06-16 | St. Tammany | Louisiana | 22103 | 26201 | 528 |
1421546 | 1421546 | 2021-06-15 | St. Tammany | Louisiana | 22103 | 26189 | 528 |
1418301 | 1418301 | 2021-06-14 | St. Tammany | Louisiana | 22103 | 26169 | 528 |
1415055 | 1415055 | 2021-06-13 | St. Tammany | Louisiana | 22103 | 26143 | 528 |
1411810 | 1411810 | 2021-06-12 | St. Tammany | Louisiana | 22103 | 26143 | 528 |
1408565 | 1408565 | 2021-06-11 | St. Tammany | Louisiana | 22103 | 26143 | 528 |
1405319 | 1405319 | 2021-06-10 | St. Tammany | Louisiana | 22103 | 26131 | 528 |
1402074 | 1402074 | 2021-06-09 | St. Tammany | Louisiana | 22103 | 26115 | 528 |
1398829 | 1398829 | 2021-06-08 | St. Tammany | Louisiana | 22103 | 26090 | 528 |
1395582 | 1395582 | 2021-06-07 | St. Tammany | Louisiana | 22103 | 26067 | 528 |
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);