ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where deaths = 195 and state = "Connecticut" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 6
- Windham 55
- New London 3
- Litchfield 1
- Middlesex 1
- New Haven 1
- Tolland 1
state 1
- Connecticut · 62 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1758445 | 1758445 | 2021-09-27 | Tolland | Connecticut | 9013 | 10911 | 195 |
1550545 | 1550545 | 2021-07-25 | Windham | Connecticut | 9015 | 11015 | 195 |
1547298 | 1547298 | 2021-07-24 | Windham | Connecticut | 9015 | 11015 | 195 |
1544051 | 1544051 | 2021-07-23 | Windham | Connecticut | 9015 | 11015 | 195 |
1540803 | 1540803 | 2021-07-22 | Windham | Connecticut | 9015 | 11011 | 195 |
1537556 | 1537556 | 2021-07-21 | Windham | Connecticut | 9015 | 11012 | 195 |
1534308 | 1534308 | 2021-07-20 | Windham | Connecticut | 9015 | 11009 | 195 |
1531061 | 1531061 | 2021-07-19 | Windham | Connecticut | 9015 | 11006 | 195 |
1527814 | 1527814 | 2021-07-18 | Windham | Connecticut | 9015 | 11002 | 195 |
1524567 | 1524567 | 2021-07-17 | Windham | Connecticut | 9015 | 11002 | 195 |
1521319 | 1521319 | 2021-07-16 | Windham | Connecticut | 9015 | 11002 | 195 |
1518071 | 1518071 | 2021-07-15 | Windham | Connecticut | 9015 | 11002 | 195 |
1514824 | 1514824 | 2021-07-14 | Windham | Connecticut | 9015 | 11000 | 195 |
1511578 | 1511578 | 2021-07-13 | Windham | Connecticut | 9015 | 11000 | 195 |
1508331 | 1508331 | 2021-07-12 | Windham | Connecticut | 9015 | 10995 | 195 |
1505085 | 1505085 | 2021-07-11 | Windham | Connecticut | 9015 | 10991 | 195 |
1501839 | 1501839 | 2021-07-10 | Windham | Connecticut | 9015 | 10991 | 195 |
1498593 | 1498593 | 2021-07-09 | Windham | Connecticut | 9015 | 10991 | 195 |
1495346 | 1495346 | 2021-07-08 | Windham | Connecticut | 9015 | 10956 | 195 |
1492100 | 1492100 | 2021-07-07 | Windham | Connecticut | 9015 | 10957 | 195 |
1488853 | 1488853 | 2021-07-06 | Windham | Connecticut | 9015 | 10956 | 195 |
1485606 | 1485606 | 2021-07-05 | Windham | Connecticut | 9015 | 10951 | 195 |
1482360 | 1482360 | 2021-07-04 | Windham | Connecticut | 9015 | 10951 | 195 |
1479113 | 1479113 | 2021-07-03 | Windham | Connecticut | 9015 | 10951 | 195 |
1475867 | 1475867 | 2021-07-02 | Windham | Connecticut | 9015 | 10951 | 195 |
1472621 | 1472621 | 2021-07-01 | Windham | Connecticut | 9015 | 10946 | 195 |
1469375 | 1469375 | 2021-06-30 | Windham | Connecticut | 9015 | 10947 | 195 |
1466130 | 1466130 | 2021-06-29 | Windham | Connecticut | 9015 | 10945 | 195 |
1462885 | 1462885 | 2021-06-28 | Windham | Connecticut | 9015 | 10937 | 195 |
1459640 | 1459640 | 2021-06-27 | Windham | Connecticut | 9015 | 10934 | 195 |
1456395 | 1456395 | 2021-06-26 | Windham | Connecticut | 9015 | 10934 | 195 |
1453150 | 1453150 | 2021-06-25 | Windham | Connecticut | 9015 | 10934 | 195 |
1449904 | 1449904 | 2021-06-24 | Windham | Connecticut | 9015 | 10933 | 195 |
1446659 | 1446659 | 2021-06-23 | Windham | Connecticut | 9015 | 10913 | 195 |
1443414 | 1443414 | 2021-06-22 | Windham | Connecticut | 9015 | 10913 | 195 |
1440169 | 1440169 | 2021-06-21 | Windham | Connecticut | 9015 | 10913 | 195 |
1436922 | 1436922 | 2021-06-20 | Windham | Connecticut | 9015 | 10915 | 195 |
1433675 | 1433675 | 2021-06-19 | Windham | Connecticut | 9015 | 10915 | 195 |
1430429 | 1430429 | 2021-06-18 | Windham | Connecticut | 9015 | 10915 | 195 |
1427184 | 1427184 | 2021-06-17 | Windham | Connecticut | 9015 | 10912 | 195 |
1423939 | 1423939 | 2021-06-16 | Windham | Connecticut | 9015 | 10911 | 195 |
1420691 | 1420691 | 2021-06-15 | Windham | Connecticut | 9015 | 10905 | 195 |
1417446 | 1417446 | 2021-06-14 | Windham | Connecticut | 9015 | 10908 | 195 |
1414200 | 1414200 | 2021-06-13 | Windham | Connecticut | 9015 | 10909 | 195 |
1410955 | 1410955 | 2021-06-12 | Windham | Connecticut | 9015 | 10909 | 195 |
1407710 | 1407710 | 2021-06-11 | Windham | Connecticut | 9015 | 10909 | 195 |
1404464 | 1404464 | 2021-06-10 | Windham | Connecticut | 9015 | 10912 | 195 |
1401219 | 1401219 | 2021-06-09 | Windham | Connecticut | 9015 | 10907 | 195 |
1397974 | 1397974 | 2021-06-08 | Windham | Connecticut | 9015 | 10905 | 195 |
1394727 | 1394727 | 2021-06-07 | Windham | Connecticut | 9015 | 10900 | 195 |
1391482 | 1391482 | 2021-06-06 | Windham | Connecticut | 9015 | 10894 | 195 |
1388237 | 1388237 | 2021-06-05 | Windham | Connecticut | 9015 | 10894 | 195 |
1384992 | 1384992 | 2021-06-04 | Windham | Connecticut | 9015 | 10894 | 195 |
1381746 | 1381746 | 2021-06-03 | Windham | Connecticut | 9015 | 10889 | 195 |
1378501 | 1378501 | 2021-06-02 | Windham | Connecticut | 9015 | 10888 | 195 |
1375255 | 1375255 | 2021-06-01 | Windham | Connecticut | 9015 | 10885 | 195 |
829879 | 829879 | 2020-12-15 | Litchfield | Connecticut | 9005 | 6138 | 195 |
823389 | 823389 | 2020-12-13 | New London | Connecticut | 9011 | 7684 | 195 |
820143 | 820143 | 2020-12-12 | New London | Connecticut | 9011 | 7684 | 195 |
816897 | 816897 | 2020-12-11 | New London | Connecticut | 9011 | 7684 | 195 |
644936 | 644936 | 2020-10-19 | Middlesex | Connecticut | 9007 | 1809 | 195 |
59446 | 59446 | 2020-04-15 | New Haven | Connecticut | 9009 | 3758 | 195 |
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);