ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where county = "Litchfield" and deaths = 298 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1628497 | 1628497 | 2021-08-18 | Litchfield | Connecticut | 9005 | 15260 | 298 |
1625250 | 1625250 | 2021-08-17 | Litchfield | Connecticut | 9005 | 15239 | 298 |
1622003 | 1622003 | 2021-08-16 | Litchfield | Connecticut | 9005 | 15213 | 298 |
1618756 | 1618756 | 2021-08-15 | Litchfield | Connecticut | 9005 | 15149 | 298 |
1615508 | 1615508 | 2021-08-14 | Litchfield | Connecticut | 9005 | 15149 | 298 |
1612259 | 1612259 | 2021-08-13 | Litchfield | Connecticut | 9005 | 15149 | 298 |
1609011 | 1609011 | 2021-08-12 | Litchfield | Connecticut | 9005 | 15132 | 298 |
1605762 | 1605762 | 2021-08-11 | Litchfield | Connecticut | 9005 | 15096 | 298 |
1602513 | 1602513 | 2021-08-10 | Litchfield | Connecticut | 9005 | 15064 | 298 |
1599264 | 1599264 | 2021-08-09 | Litchfield | Connecticut | 9005 | 15060 | 298 |
1596015 | 1596015 | 2021-08-08 | Litchfield | Connecticut | 9005 | 15012 | 298 |
1592766 | 1592766 | 2021-08-07 | Litchfield | Connecticut | 9005 | 15012 | 298 |
1589517 | 1589517 | 2021-08-06 | Litchfield | Connecticut | 9005 | 15012 | 298 |
1586268 | 1586268 | 2021-08-05 | Litchfield | Connecticut | 9005 | 14964 | 298 |
1583018 | 1583018 | 2021-08-04 | Litchfield | Connecticut | 9005 | 14947 | 298 |
1579768 | 1579768 | 2021-08-03 | Litchfield | Connecticut | 9005 | 14929 | 298 |
1576520 | 1576520 | 2021-08-02 | Litchfield | Connecticut | 9005 | 14908 | 298 |
1573272 | 1573272 | 2021-08-01 | Litchfield | Connecticut | 9005 | 14864 | 298 |
1570024 | 1570024 | 2021-07-31 | Litchfield | Connecticut | 9005 | 14864 | 298 |
1566776 | 1566776 | 2021-07-30 | Litchfield | Connecticut | 9005 | 14864 | 298 |
1563528 | 1563528 | 2021-07-29 | Litchfield | Connecticut | 9005 | 14841 | 298 |
1560280 | 1560280 | 2021-07-28 | Litchfield | Connecticut | 9005 | 14834 | 298 |
1557033 | 1557033 | 2021-07-27 | Litchfield | Connecticut | 9005 | 14828 | 298 |
1553786 | 1553786 | 2021-07-26 | Litchfield | Connecticut | 9005 | 14808 | 298 |
1550539 | 1550539 | 2021-07-25 | Litchfield | Connecticut | 9005 | 14794 | 298 |
1547292 | 1547292 | 2021-07-24 | Litchfield | Connecticut | 9005 | 14794 | 298 |
1544045 | 1544045 | 2021-07-23 | Litchfield | Connecticut | 9005 | 14794 | 298 |
1540797 | 1540797 | 2021-07-22 | Litchfield | Connecticut | 9005 | 14783 | 298 |
1537550 | 1537550 | 2021-07-21 | Litchfield | Connecticut | 9005 | 14778 | 298 |
1534302 | 1534302 | 2021-07-20 | Litchfield | Connecticut | 9005 | 14772 | 298 |
1531055 | 1531055 | 2021-07-19 | Litchfield | Connecticut | 9005 | 14755 | 298 |
1527808 | 1527808 | 2021-07-18 | Litchfield | Connecticut | 9005 | 14739 | 298 |
1524561 | 1524561 | 2021-07-17 | Litchfield | Connecticut | 9005 | 14739 | 298 |
1521313 | 1521313 | 2021-07-16 | Litchfield | Connecticut | 9005 | 14739 | 298 |
1518065 | 1518065 | 2021-07-15 | Litchfield | Connecticut | 9005 | 14735 | 298 |
1514818 | 1514818 | 2021-07-14 | Litchfield | Connecticut | 9005 | 14729 | 298 |
1511572 | 1511572 | 2021-07-13 | Litchfield | Connecticut | 9005 | 14723 | 298 |
1508325 | 1508325 | 2021-07-12 | Litchfield | Connecticut | 9005 | 14714 | 298 |
1505079 | 1505079 | 2021-07-11 | Litchfield | Connecticut | 9005 | 14712 | 298 |
1501833 | 1501833 | 2021-07-10 | Litchfield | Connecticut | 9005 | 14712 | 298 |
1498587 | 1498587 | 2021-07-09 | Litchfield | Connecticut | 9005 | 14712 | 298 |
1495340 | 1495340 | 2021-07-08 | Litchfield | Connecticut | 9005 | 14708 | 298 |
1492094 | 1492094 | 2021-07-07 | Litchfield | Connecticut | 9005 | 14706 | 298 |
1488847 | 1488847 | 2021-07-06 | Litchfield | Connecticut | 9005 | 14707 | 298 |
1485600 | 1485600 | 2021-07-05 | Litchfield | Connecticut | 9005 | 14696 | 298 |
1482354 | 1482354 | 2021-07-04 | Litchfield | Connecticut | 9005 | 14696 | 298 |
1479107 | 1479107 | 2021-07-03 | Litchfield | Connecticut | 9005 | 14696 | 298 |
1475861 | 1475861 | 2021-07-02 | Litchfield | Connecticut | 9005 | 14696 | 298 |
1472615 | 1472615 | 2021-07-01 | Litchfield | Connecticut | 9005 | 14693 | 298 |
1469369 | 1469369 | 2021-06-30 | Litchfield | Connecticut | 9005 | 14694 | 298 |
1466124 | 1466124 | 2021-06-29 | Litchfield | Connecticut | 9005 | 14692 | 298 |
1462879 | 1462879 | 2021-06-28 | Litchfield | Connecticut | 9005 | 14688 | 298 |
1459634 | 1459634 | 2021-06-27 | Litchfield | Connecticut | 9005 | 14686 | 298 |
1456389 | 1456389 | 2021-06-26 | Litchfield | Connecticut | 9005 | 14686 | 298 |
1453144 | 1453144 | 2021-06-25 | Litchfield | Connecticut | 9005 | 14686 | 298 |
1449898 | 1449898 | 2021-06-24 | Litchfield | Connecticut | 9005 | 14673 | 298 |
1446653 | 1446653 | 2021-06-23 | Litchfield | Connecticut | 9005 | 14665 | 298 |
1443408 | 1443408 | 2021-06-22 | Litchfield | Connecticut | 9005 | 14662 | 298 |
1440163 | 1440163 | 2021-06-21 | Litchfield | Connecticut | 9005 | 14662 | 298 |
1436916 | 1436916 | 2021-06-20 | Litchfield | Connecticut | 9005 | 14656 | 298 |
1433669 | 1433669 | 2021-06-19 | Litchfield | Connecticut | 9005 | 14656 | 298 |
1430423 | 1430423 | 2021-06-18 | Litchfield | Connecticut | 9005 | 14656 | 298 |
1427178 | 1427178 | 2021-06-17 | Litchfield | Connecticut | 9005 | 14651 | 298 |
1423933 | 1423933 | 2021-06-16 | Litchfield | Connecticut | 9005 | 14647 | 298 |
1420685 | 1420685 | 2021-06-15 | Litchfield | Connecticut | 9005 | 14644 | 298 |
1417440 | 1417440 | 2021-06-14 | Litchfield | Connecticut | 9005 | 14634 | 298 |
1414194 | 1414194 | 2021-06-13 | Litchfield | Connecticut | 9005 | 14631 | 298 |
1410949 | 1410949 | 2021-06-12 | Litchfield | Connecticut | 9005 | 14631 | 298 |
1407704 | 1407704 | 2021-06-11 | Litchfield | Connecticut | 9005 | 14631 | 298 |
1404458 | 1404458 | 2021-06-10 | Litchfield | Connecticut | 9005 | 14632 | 298 |
1401213 | 1401213 | 2021-06-09 | Litchfield | Connecticut | 9005 | 14628 | 298 |
1397968 | 1397968 | 2021-06-08 | Litchfield | Connecticut | 9005 | 14615 | 298 |
1394721 | 1394721 | 2021-06-07 | Litchfield | Connecticut | 9005 | 14610 | 298 |
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);