ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22007 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717017 | 1717017 | 2021-09-14 | Assumption | Louisiana | 22007 | 3476 | 53 |
1713771 | 1713771 | 2021-09-13 | Assumption | Louisiana | 22007 | 3475 | 53 |
1710524 | 1710524 | 2021-09-12 | Assumption | Louisiana | 22007 | 3455 | 52 |
1707277 | 1707277 | 2021-09-11 | Assumption | Louisiana | 22007 | 3455 | 52 |
1704029 | 1704029 | 2021-09-10 | Assumption | Louisiana | 22007 | 3455 | 52 |
1700779 | 1700779 | 2021-09-09 | Assumption | Louisiana | 22007 | 3437 | 52 |
1697530 | 1697530 | 2021-09-08 | Assumption | Louisiana | 22007 | 3409 | 51 |
1694282 | 1694282 | 2021-09-07 | Assumption | Louisiana | 22007 | 3400 | 50 |
1691033 | 1691033 | 2021-09-06 | Assumption | Louisiana | 22007 | 3377 | 47 |
1687783 | 1687783 | 2021-09-05 | Assumption | Louisiana | 22007 | 3377 | 47 |
1684533 | 1684533 | 2021-09-04 | Assumption | Louisiana | 22007 | 3377 | 47 |
1681282 | 1681282 | 2021-09-03 | Assumption | Louisiana | 22007 | 3377 | 47 |
1678034 | 1678034 | 2021-09-02 | Assumption | Louisiana | 22007 | 3365 | 47 |
1674787 | 1674787 | 2021-09-01 | Assumption | Louisiana | 22007 | 3360 | 44 |
1671538 | 1671538 | 2021-08-31 | Assumption | Louisiana | 22007 | 3336 | 43 |
1668291 | 1668291 | 2021-08-30 | Assumption | Louisiana | 22007 | 3336 | 43 |
1665044 | 1665044 | 2021-08-29 | Assumption | Louisiana | 22007 | 3336 | 43 |
1661796 | 1661796 | 2021-08-28 | Assumption | Louisiana | 22007 | 3336 | 43 |
1658548 | 1658548 | 2021-08-27 | Assumption | Louisiana | 22007 | 3336 | 43 |
1655300 | 1655300 | 2021-08-26 | Assumption | Louisiana | 22007 | 3330 | 43 |
1652053 | 1652053 | 2021-08-25 | Assumption | Louisiana | 22007 | 3304 | 43 |
1648804 | 1648804 | 2021-08-24 | Assumption | Louisiana | 22007 | 3273 | 42 |
1645556 | 1645556 | 2021-08-23 | Assumption | Louisiana | 22007 | 3260 | 42 |
1642307 | 1642307 | 2021-08-22 | Assumption | Louisiana | 22007 | 3208 | 41 |
1639057 | 1639057 | 2021-08-21 | Assumption | Louisiana | 22007 | 3208 | 41 |
1635807 | 1635807 | 2021-08-20 | Assumption | Louisiana | 22007 | 3208 | 41 |
1632557 | 1632557 | 2021-08-19 | Assumption | Louisiana | 22007 | 3100 | 40 |
1629310 | 1629310 | 2021-08-18 | Assumption | Louisiana | 22007 | 3082 | 41 |
1626063 | 1626063 | 2021-08-17 | Assumption | Louisiana | 22007 | 3059 | 41 |
1622816 | 1622816 | 2021-08-16 | Assumption | Louisiana | 22007 | 3049 | 38 |
1619569 | 1619569 | 2021-08-15 | Assumption | Louisiana | 22007 | 3026 | 39 |
1616321 | 1616321 | 2021-08-14 | Assumption | Louisiana | 22007 | 3026 | 39 |
1613072 | 1613072 | 2021-08-13 | Assumption | Louisiana | 22007 | 3026 | 39 |
1609824 | 1609824 | 2021-08-12 | Assumption | Louisiana | 22007 | 3009 | 38 |
1606575 | 1606575 | 2021-08-11 | Assumption | Louisiana | 22007 | 2973 | 38 |
1603326 | 1603326 | 2021-08-10 | Assumption | Louisiana | 22007 | 2941 | 38 |
1600077 | 1600077 | 2021-08-09 | Assumption | Louisiana | 22007 | 2915 | 38 |
1596829 | 1596829 | 2021-08-08 | Assumption | Louisiana | 22007 | 2835 | 37 |
1593580 | 1593580 | 2021-08-07 | Assumption | Louisiana | 22007 | 2835 | 37 |
1590331 | 1590331 | 2021-08-06 | Assumption | Louisiana | 22007 | 2835 | 37 |
1587082 | 1587082 | 2021-08-05 | Assumption | Louisiana | 22007 | 2809 | 37 |
1583832 | 1583832 | 2021-08-04 | Assumption | Louisiana | 22007 | 2785 | 37 |
1580582 | 1580582 | 2021-08-03 | Assumption | Louisiana | 22007 | 2763 | 37 |
1577333 | 1577333 | 2021-08-02 | Assumption | Louisiana | 22007 | 2728 | 37 |
1574085 | 1574085 | 2021-08-01 | Assumption | Louisiana | 22007 | 2666 | 37 |
1570837 | 1570837 | 2021-07-31 | Assumption | Louisiana | 22007 | 2666 | 37 |
1567589 | 1567589 | 2021-07-30 | Assumption | Louisiana | 22007 | 2666 | 37 |
1564341 | 1564341 | 2021-07-29 | Assumption | Louisiana | 22007 | 2646 | 37 |
1561093 | 1561093 | 2021-07-28 | Assumption | Louisiana | 22007 | 2628 | 37 |
1557846 | 1557846 | 2021-07-27 | Assumption | Louisiana | 22007 | 2603 | 37 |
1554599 | 1554599 | 2021-07-26 | Assumption | Louisiana | 22007 | 2556 | 37 |
1551352 | 1551352 | 2021-07-25 | Assumption | Louisiana | 22007 | 2509 | 37 |
1548105 | 1548105 | 2021-07-24 | Assumption | Louisiana | 22007 | 2509 | 37 |
1544858 | 1544858 | 2021-07-23 | Assumption | Louisiana | 22007 | 2509 | 37 |
1541610 | 1541610 | 2021-07-22 | Assumption | Louisiana | 22007 | 2493 | 37 |
1538363 | 1538363 | 2021-07-21 | Assumption | Louisiana | 22007 | 2468 | 37 |
1535115 | 1535115 | 2021-07-20 | Assumption | Louisiana | 22007 | 2438 | 37 |
1531868 | 1531868 | 2021-07-19 | Assumption | Louisiana | 22007 | 2420 | 37 |
1528621 | 1528621 | 2021-07-18 | Assumption | Louisiana | 22007 | 2400 | 37 |
1525374 | 1525374 | 2021-07-17 | Assumption | Louisiana | 22007 | 2400 | 37 |
1522126 | 1522126 | 2021-07-16 | Assumption | Louisiana | 22007 | 2400 | 37 |
1518878 | 1518878 | 2021-07-15 | Assumption | Louisiana | 22007 | 2384 | 36 |
1515631 | 1515631 | 2021-07-14 | Assumption | Louisiana | 22007 | 2384 | 36 |
1512385 | 1512385 | 2021-07-13 | Assumption | Louisiana | 22007 | 2374 | 36 |
1509138 | 1509138 | 2021-07-12 | Assumption | Louisiana | 22007 | 2366 | 36 |
1505892 | 1505892 | 2021-07-11 | Assumption | Louisiana | 22007 | 2352 | 36 |
1502646 | 1502646 | 2021-07-10 | Assumption | Louisiana | 22007 | 2352 | 36 |
1499400 | 1499400 | 2021-07-09 | Assumption | Louisiana | 22007 | 2352 | 36 |
1496153 | 1496153 | 2021-07-08 | Assumption | Louisiana | 22007 | 2350 | 36 |
1492907 | 1492907 | 2021-07-07 | Assumption | Louisiana | 22007 | 2350 | 36 |
1489660 | 1489660 | 2021-07-06 | Assumption | Louisiana | 22007 | 2344 | 36 |
1486413 | 1486413 | 2021-07-05 | Assumption | Louisiana | 22007 | 2333 | 36 |
1483167 | 1483167 | 2021-07-04 | Assumption | Louisiana | 22007 | 2333 | 36 |
1479920 | 1479920 | 2021-07-03 | Assumption | Louisiana | 22007 | 2333 | 36 |
1476674 | 1476674 | 2021-07-02 | Assumption | Louisiana | 22007 | 2333 | 36 |
1473428 | 1473428 | 2021-07-01 | Assumption | Louisiana | 22007 | 2334 | 36 |
1470182 | 1470182 | 2021-06-30 | Assumption | Louisiana | 22007 | 2334 | 36 |
1466937 | 1466937 | 2021-06-29 | Assumption | Louisiana | 22007 | 2331 | 36 |
1463692 | 1463692 | 2021-06-28 | Assumption | Louisiana | 22007 | 2327 | 36 |
1460447 | 1460447 | 2021-06-27 | Assumption | Louisiana | 22007 | 2320 | 36 |
1457202 | 1457202 | 2021-06-26 | Assumption | Louisiana | 22007 | 2320 | 36 |
1453957 | 1453957 | 2021-06-25 | Assumption | Louisiana | 22007 | 2320 | 36 |
1450711 | 1450711 | 2021-06-24 | Assumption | Louisiana | 22007 | 2322 | 36 |
1447466 | 1447466 | 2021-06-23 | Assumption | Louisiana | 22007 | 2322 | 36 |
1444221 | 1444221 | 2021-06-22 | Assumption | Louisiana | 22007 | 2318 | 36 |
1440976 | 1440976 | 2021-06-21 | Assumption | Louisiana | 22007 | 2316 | 36 |
1437729 | 1437729 | 2021-06-20 | Assumption | Louisiana | 22007 | 2315 | 36 |
1434482 | 1434482 | 2021-06-19 | Assumption | Louisiana | 22007 | 2315 | 36 |
1431236 | 1431236 | 2021-06-18 | Assumption | Louisiana | 22007 | 2315 | 36 |
1427991 | 1427991 | 2021-06-17 | Assumption | Louisiana | 22007 | 2313 | 36 |
1424746 | 1424746 | 2021-06-16 | Assumption | Louisiana | 22007 | 2310 | 36 |
1421498 | 1421498 | 2021-06-15 | Assumption | Louisiana | 22007 | 2314 | 36 |
1418253 | 1418253 | 2021-06-14 | Assumption | Louisiana | 22007 | 2307 | 36 |
1415007 | 1415007 | 2021-06-13 | Assumption | Louisiana | 22007 | 2303 | 36 |
1411762 | 1411762 | 2021-06-12 | Assumption | Louisiana | 22007 | 2303 | 36 |
1408517 | 1408517 | 2021-06-11 | Assumption | Louisiana | 22007 | 2303 | 36 |
1405271 | 1405271 | 2021-06-10 | Assumption | Louisiana | 22007 | 2304 | 36 |
1402026 | 1402026 | 2021-06-09 | Assumption | Louisiana | 22007 | 2299 | 36 |
1398781 | 1398781 | 2021-06-08 | Assumption | Louisiana | 22007 | 2292 | 36 |
1395534 | 1395534 | 2021-06-07 | Assumption | Louisiana | 22007 | 2291 | 36 |
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);