ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where deaths = 451 and state = "Connecticut" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2164746 | 2164746 | 2022-01-30 | Middlesex | Connecticut | 9007 | 25778 | 451 |
2161491 | 2161491 | 2022-01-29 | Middlesex | Connecticut | 9007 | 25778 | 451 |
2158235 | 2158235 | 2022-01-28 | Middlesex | Connecticut | 9007 | 25778 | 451 |
1576523 | 1576523 | 2021-08-02 | New London | Connecticut | 9011 | 23072 | 451 |
1573275 | 1573275 | 2021-08-01 | New London | Connecticut | 9011 | 22975 | 451 |
1570027 | 1570027 | 2021-07-31 | New London | Connecticut | 9011 | 22975 | 451 |
1566779 | 1566779 | 2021-07-30 | New London | Connecticut | 9011 | 22975 | 451 |
1563531 | 1563531 | 2021-07-29 | New London | Connecticut | 9011 | 22945 | 451 |
1560283 | 1560283 | 2021-07-28 | New London | Connecticut | 9011 | 22923 | 451 |
1557036 | 1557036 | 2021-07-27 | New London | Connecticut | 9011 | 22898 | 451 |
1553789 | 1553789 | 2021-07-26 | New London | Connecticut | 9011 | 22859 | 451 |
1550542 | 1550542 | 2021-07-25 | New London | Connecticut | 9011 | 22807 | 451 |
1547295 | 1547295 | 2021-07-24 | New London | Connecticut | 9011 | 22807 | 451 |
1544048 | 1544048 | 2021-07-23 | New London | Connecticut | 9011 | 22807 | 451 |
1540800 | 1540800 | 2021-07-22 | New London | Connecticut | 9011 | 22780 | 451 |
1537553 | 1537553 | 2021-07-21 | New London | Connecticut | 9011 | 22746 | 451 |
1534305 | 1534305 | 2021-07-20 | New London | Connecticut | 9011 | 22729 | 451 |
1531058 | 1531058 | 2021-07-19 | New London | Connecticut | 9011 | 22717 | 451 |
1527811 | 1527811 | 2021-07-18 | New London | Connecticut | 9011 | 22675 | 451 |
1524564 | 1524564 | 2021-07-17 | New London | Connecticut | 9011 | 22675 | 451 |
1521316 | 1521316 | 2021-07-16 | New London | Connecticut | 9011 | 22675 | 451 |
1518068 | 1518068 | 2021-07-15 | New London | Connecticut | 9011 | 22667 | 451 |
1514821 | 1514821 | 2021-07-14 | New London | Connecticut | 9011 | 22657 | 451 |
1511575 | 1511575 | 2021-07-13 | New London | Connecticut | 9011 | 22647 | 451 |
1508328 | 1508328 | 2021-07-12 | New London | Connecticut | 9011 | 22626 | 451 |
1505082 | 1505082 | 2021-07-11 | New London | Connecticut | 9011 | 22625 | 451 |
1501836 | 1501836 | 2021-07-10 | New London | Connecticut | 9011 | 22625 | 451 |
1498590 | 1498590 | 2021-07-09 | New London | Connecticut | 9011 | 22625 | 451 |
1495343 | 1495343 | 2021-07-08 | New London | Connecticut | 9011 | 22620 | 451 |
1492097 | 1492097 | 2021-07-07 | New London | Connecticut | 9011 | 22613 | 451 |
1488850 | 1488850 | 2021-07-06 | New London | Connecticut | 9011 | 22599 | 451 |
1485603 | 1485603 | 2021-07-05 | New London | Connecticut | 9011 | 22590 | 451 |
1482357 | 1482357 | 2021-07-04 | New London | Connecticut | 9011 | 22590 | 451 |
1479110 | 1479110 | 2021-07-03 | New London | Connecticut | 9011 | 22590 | 451 |
1475864 | 1475864 | 2021-07-02 | New London | Connecticut | 9011 | 22590 | 451 |
1472618 | 1472618 | 2021-07-01 | New London | Connecticut | 9011 | 22587 | 451 |
1469372 | 1469372 | 2021-06-30 | New London | Connecticut | 9011 | 22578 | 451 |
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);