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 |
---|---|---|---|---|---|---|---|
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 |
1486449 | 1486449 | 2021-07-05 | Rapides | Louisiana | 22079 | 12765 | 328 |
1483203 | 1483203 | 2021-07-04 | Rapides | Louisiana | 22079 | 12765 | 328 |
1479956 | 1479956 | 2021-07-03 | Rapides | Louisiana | 22079 | 12765 | 328 |
1476710 | 1476710 | 2021-07-02 | Rapides | Louisiana | 22079 | 12765 | 328 |
1473464 | 1473464 | 2021-07-01 | Rapides | Louisiana | 22079 | 12757 | 327 |
1470218 | 1470218 | 2021-06-30 | Rapides | Louisiana | 22079 | 12748 | 327 |
1466973 | 1466973 | 2021-06-29 | Rapides | Louisiana | 22079 | 12726 | 327 |
1463728 | 1463728 | 2021-06-28 | Rapides | Louisiana | 22079 | 12720 | 326 |
1460483 | 1460483 | 2021-06-27 | Rapides | Louisiana | 22079 | 12704 | 326 |
1457238 | 1457238 | 2021-06-26 | Rapides | Louisiana | 22079 | 12704 | 326 |
1453993 | 1453993 | 2021-06-25 | Rapides | Louisiana | 22079 | 12704 | 326 |
1450747 | 1450747 | 2021-06-24 | Rapides | Louisiana | 22079 | 12703 | 326 |
1447502 | 1447502 | 2021-06-23 | Rapides | Louisiana | 22079 | 12697 | 326 |
1444257 | 1444257 | 2021-06-22 | Rapides | Louisiana | 22079 | 12681 | 326 |
1441012 | 1441012 | 2021-06-21 | Rapides | Louisiana | 22079 | 12678 | 325 |
1437765 | 1437765 | 2021-06-20 | Rapides | Louisiana | 22079 | 12666 | 325 |
1434518 | 1434518 | 2021-06-19 | Rapides | Louisiana | 22079 | 12666 | 325 |
1431272 | 1431272 | 2021-06-18 | Rapides | Louisiana | 22079 | 12666 | 325 |
1428027 | 1428027 | 2021-06-17 | Rapides | Louisiana | 22079 | 12660 | 325 |
1424782 | 1424782 | 2021-06-16 | Rapides | Louisiana | 22079 | 12640 | 325 |
1421534 | 1421534 | 2021-06-15 | Rapides | Louisiana | 22079 | 12633 | 325 |
1418289 | 1418289 | 2021-06-14 | Rapides | Louisiana | 22079 | 12622 | 324 |
1415043 | 1415043 | 2021-06-13 | Rapides | Louisiana | 22079 | 12603 | 322 |
1411798 | 1411798 | 2021-06-12 | Rapides | Louisiana | 22079 | 12603 | 322 |
1408553 | 1408553 | 2021-06-11 | Rapides | Louisiana | 22079 | 12603 | 322 |
1405307 | 1405307 | 2021-06-10 | Rapides | Louisiana | 22079 | 12599 | 320 |
1402062 | 1402062 | 2021-06-09 | Rapides | Louisiana | 22079 | 12590 | 320 |
1398817 | 1398817 | 2021-06-08 | Rapides | Louisiana | 22079 | 12584 | 319 |
1395570 | 1395570 | 2021-06-07 | Rapides | Louisiana | 22079 | 12583 | 319 |
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);