ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 22089 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717058 | 1717058 | 2021-09-14 | St. Charles | Louisiana | 22089 | 8559 | 117 |
1713812 | 1713812 | 2021-09-13 | St. Charles | Louisiana | 22089 | 8549 | 117 |
1710565 | 1710565 | 2021-09-12 | St. Charles | Louisiana | 22089 | 8507 | 117 |
1707318 | 1707318 | 2021-09-11 | St. Charles | Louisiana | 22089 | 8507 | 117 |
1704070 | 1704070 | 2021-09-10 | St. Charles | Louisiana | 22089 | 8507 | 117 |
1700820 | 1700820 | 2021-09-09 | St. Charles | Louisiana | 22089 | 8487 | 116 |
1697571 | 1697571 | 2021-09-08 | St. Charles | Louisiana | 22089 | 8467 | 116 |
1694323 | 1694323 | 2021-09-07 | St. Charles | Louisiana | 22089 | 8451 | 115 |
1691074 | 1691074 | 2021-09-06 | St. Charles | Louisiana | 22089 | 8408 | 115 |
1687824 | 1687824 | 2021-09-05 | St. Charles | Louisiana | 22089 | 8408 | 115 |
1684574 | 1684574 | 2021-09-04 | St. Charles | Louisiana | 22089 | 8408 | 115 |
1681323 | 1681323 | 2021-09-03 | St. Charles | Louisiana | 22089 | 8408 | 115 |
1678075 | 1678075 | 2021-09-02 | St. Charles | Louisiana | 22089 | 8399 | 115 |
1674828 | 1674828 | 2021-09-01 | St. Charles | Louisiana | 22089 | 8394 | 115 |
1671579 | 1671579 | 2021-08-31 | St. Charles | Louisiana | 22089 | 8289 | 115 |
1668332 | 1668332 | 2021-08-30 | St. Charles | Louisiana | 22089 | 8289 | 115 |
1665085 | 1665085 | 2021-08-29 | St. Charles | Louisiana | 22089 | 8289 | 115 |
1661837 | 1661837 | 2021-08-28 | St. Charles | Louisiana | 22089 | 8289 | 115 |
1658589 | 1658589 | 2021-08-27 | St. Charles | Louisiana | 22089 | 8289 | 115 |
1655341 | 1655341 | 2021-08-26 | St. Charles | Louisiana | 22089 | 8245 | 114 |
1652094 | 1652094 | 2021-08-25 | St. Charles | Louisiana | 22089 | 8207 | 113 |
1648845 | 1648845 | 2021-08-24 | St. Charles | Louisiana | 22089 | 8154 | 112 |
1645597 | 1645597 | 2021-08-23 | St. Charles | Louisiana | 22089 | 8094 | 110 |
1642348 | 1642348 | 2021-08-22 | St. Charles | Louisiana | 22089 | 7957 | 109 |
1639098 | 1639098 | 2021-08-21 | St. Charles | Louisiana | 22089 | 7957 | 109 |
1635848 | 1635848 | 2021-08-20 | St. Charles | Louisiana | 22089 | 7957 | 109 |
1632598 | 1632598 | 2021-08-19 | St. Charles | Louisiana | 22089 | 7916 | 107 |
1629351 | 1629351 | 2021-08-18 | St. Charles | Louisiana | 22089 | 7864 | 107 |
1626104 | 1626104 | 2021-08-17 | St. Charles | Louisiana | 22089 | 7811 | 105 |
1622857 | 1622857 | 2021-08-16 | St. Charles | Louisiana | 22089 | 7773 | 105 |
1619610 | 1619610 | 2021-08-15 | St. Charles | Louisiana | 22089 | 7603 | 103 |
1616362 | 1616362 | 2021-08-14 | St. Charles | Louisiana | 22089 | 7603 | 103 |
1613113 | 1613113 | 2021-08-13 | St. Charles | Louisiana | 22089 | 7603 | 103 |
1609865 | 1609865 | 2021-08-12 | St. Charles | Louisiana | 22089 | 7532 | 103 |
1606616 | 1606616 | 2021-08-11 | St. Charles | Louisiana | 22089 | 7423 | 103 |
1603367 | 1603367 | 2021-08-10 | St. Charles | Louisiana | 22089 | 7362 | 103 |
1600118 | 1600118 | 2021-08-09 | St. Charles | Louisiana | 22089 | 7318 | 102 |
1596870 | 1596870 | 2021-08-08 | St. Charles | Louisiana | 22089 | 7106 | 102 |
1593621 | 1593621 | 2021-08-07 | St. Charles | Louisiana | 22089 | 7106 | 102 |
1590372 | 1590372 | 2021-08-06 | St. Charles | Louisiana | 22089 | 7106 | 102 |
1587123 | 1587123 | 2021-08-05 | St. Charles | Louisiana | 22089 | 7040 | 101 |
1583873 | 1583873 | 2021-08-04 | St. Charles | Louisiana | 22089 | 6968 | 101 |
1580623 | 1580623 | 2021-08-03 | St. Charles | Louisiana | 22089 | 6859 | 100 |
1577374 | 1577374 | 2021-08-02 | St. Charles | Louisiana | 22089 | 6803 | 99 |
1574126 | 1574126 | 2021-08-01 | St. Charles | Louisiana | 22089 | 6609 | 99 |
1570878 | 1570878 | 2021-07-31 | St. Charles | Louisiana | 22089 | 6609 | 99 |
1567630 | 1567630 | 2021-07-30 | St. Charles | Louisiana | 22089 | 6609 | 99 |
1564382 | 1564382 | 2021-07-29 | St. Charles | Louisiana | 22089 | 6534 | 99 |
1561134 | 1561134 | 2021-07-28 | St. Charles | Louisiana | 22089 | 6437 | 99 |
1557887 | 1557887 | 2021-07-27 | St. Charles | Louisiana | 22089 | 6359 | 99 |
1554640 | 1554640 | 2021-07-26 | St. Charles | Louisiana | 22089 | 6280 | 99 |
1551393 | 1551393 | 2021-07-25 | St. Charles | Louisiana | 22089 | 6142 | 99 |
1548146 | 1548146 | 2021-07-24 | St. Charles | Louisiana | 22089 | 6142 | 99 |
1544899 | 1544899 | 2021-07-23 | St. Charles | Louisiana | 22089 | 6142 | 99 |
1541651 | 1541651 | 2021-07-22 | St. Charles | Louisiana | 22089 | 6094 | 99 |
1538404 | 1538404 | 2021-07-21 | St. Charles | Louisiana | 22089 | 6052 | 99 |
1535156 | 1535156 | 2021-07-20 | St. Charles | Louisiana | 22089 | 6011 | 98 |
1531909 | 1531909 | 2021-07-19 | St. Charles | Louisiana | 22089 | 5988 | 98 |
1528662 | 1528662 | 2021-07-18 | St. Charles | Louisiana | 22089 | 5903 | 98 |
1525415 | 1525415 | 2021-07-17 | St. Charles | Louisiana | 22089 | 5903 | 98 |
1522167 | 1522167 | 2021-07-16 | St. Charles | Louisiana | 22089 | 5903 | 98 |
1518919 | 1518919 | 2021-07-15 | St. Charles | Louisiana | 22089 | 5877 | 98 |
1515672 | 1515672 | 2021-07-14 | St. Charles | Louisiana | 22089 | 5853 | 98 |
1512426 | 1512426 | 2021-07-13 | St. Charles | Louisiana | 22089 | 5829 | 98 |
1509179 | 1509179 | 2021-07-12 | St. Charles | Louisiana | 22089 | 5813 | 98 |
1505933 | 1505933 | 2021-07-11 | St. Charles | Louisiana | 22089 | 5758 | 98 |
1502687 | 1502687 | 2021-07-10 | St. Charles | Louisiana | 22089 | 5758 | 98 |
1499441 | 1499441 | 2021-07-09 | St. Charles | Louisiana | 22089 | 5758 | 98 |
1496194 | 1496194 | 2021-07-08 | St. Charles | Louisiana | 22089 | 5740 | 98 |
1492948 | 1492948 | 2021-07-07 | St. Charles | Louisiana | 22089 | 5722 | 98 |
1489701 | 1489701 | 2021-07-06 | St. Charles | Louisiana | 22089 | 5704 | 98 |
1486454 | 1486454 | 2021-07-05 | St. Charles | Louisiana | 22089 | 5669 | 98 |
1483208 | 1483208 | 2021-07-04 | St. Charles | Louisiana | 22089 | 5669 | 98 |
1479961 | 1479961 | 2021-07-03 | St. Charles | Louisiana | 22089 | 5669 | 98 |
1476715 | 1476715 | 2021-07-02 | St. Charles | Louisiana | 22089 | 5669 | 98 |
1473469 | 1473469 | 2021-07-01 | St. Charles | Louisiana | 22089 | 5648 | 98 |
1470223 | 1470223 | 2021-06-30 | St. Charles | Louisiana | 22089 | 5642 | 98 |
1466978 | 1466978 | 2021-06-29 | St. Charles | Louisiana | 22089 | 5636 | 98 |
1463733 | 1463733 | 2021-06-28 | St. Charles | Louisiana | 22089 | 5629 | 98 |
1460488 | 1460488 | 2021-06-27 | St. Charles | Louisiana | 22089 | 5622 | 98 |
1457243 | 1457243 | 2021-06-26 | St. Charles | Louisiana | 22089 | 5622 | 98 |
1453998 | 1453998 | 2021-06-25 | St. Charles | Louisiana | 22089 | 5622 | 98 |
1450752 | 1450752 | 2021-06-24 | St. Charles | Louisiana | 22089 | 5617 | 98 |
1447507 | 1447507 | 2021-06-23 | St. Charles | Louisiana | 22089 | 5613 | 98 |
1444262 | 1444262 | 2021-06-22 | St. Charles | Louisiana | 22089 | 5612 | 98 |
1441017 | 1441017 | 2021-06-21 | St. Charles | Louisiana | 22089 | 5605 | 98 |
1437770 | 1437770 | 2021-06-20 | St. Charles | Louisiana | 22089 | 5601 | 98 |
1434523 | 1434523 | 2021-06-19 | St. Charles | Louisiana | 22089 | 5601 | 98 |
1431277 | 1431277 | 2021-06-18 | St. Charles | Louisiana | 22089 | 5601 | 98 |
1428032 | 1428032 | 2021-06-17 | St. Charles | Louisiana | 22089 | 5599 | 98 |
1424787 | 1424787 | 2021-06-16 | St. Charles | Louisiana | 22089 | 5594 | 98 |
1421539 | 1421539 | 2021-06-15 | St. Charles | Louisiana | 22089 | 5591 | 97 |
1418294 | 1418294 | 2021-06-14 | St. Charles | Louisiana | 22089 | 5586 | 97 |
1415048 | 1415048 | 2021-06-13 | St. Charles | Louisiana | 22089 | 5576 | 97 |
1411803 | 1411803 | 2021-06-12 | St. Charles | Louisiana | 22089 | 5576 | 97 |
1408558 | 1408558 | 2021-06-11 | St. Charles | Louisiana | 22089 | 5576 | 97 |
1405312 | 1405312 | 2021-06-10 | St. Charles | Louisiana | 22089 | 5571 | 97 |
1402067 | 1402067 | 2021-06-09 | St. Charles | Louisiana | 22089 | 5570 | 97 |
1398822 | 1398822 | 2021-06-08 | St. Charles | Louisiana | 22089 | 5561 | 97 |
1395575 | 1395575 | 2021-06-07 | St. Charles | Louisiana | 22089 | 5555 | 97 |
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);