ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where deaths = 189 and state = "Connecticut" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
county 4
- Windham 14
- Middlesex 9
- Tolland 7
- New London 1
state 1
- Connecticut · 31 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1651244 | 1651244 | 2021-08-25 | Tolland | Connecticut | 9013 | 10234 | 189 |
1647995 | 1647995 | 2021-08-24 | Tolland | Connecticut | 9013 | 10222 | 189 |
1644747 | 1644747 | 2021-08-23 | Tolland | Connecticut | 9013 | 10187 | 189 |
1641497 | 1641497 | 2021-08-22 | Tolland | Connecticut | 9013 | 10133 | 189 |
1638247 | 1638247 | 2021-08-21 | Tolland | Connecticut | 9013 | 10133 | 189 |
1634997 | 1634997 | 2021-08-20 | Tolland | Connecticut | 9013 | 10133 | 189 |
1631748 | 1631748 | 2021-08-19 | Tolland | Connecticut | 9013 | 10121 | 189 |
1258378 | 1258378 | 2021-04-26 | Windham | Connecticut | 9015 | 10550 | 189 |
1255131 | 1255131 | 2021-04-25 | Windham | Connecticut | 9015 | 10495 | 189 |
1251884 | 1251884 | 2021-04-24 | Windham | Connecticut | 9015 | 10495 | 189 |
1248637 | 1248637 | 2021-04-23 | Windham | Connecticut | 9015 | 10495 | 189 |
1245390 | 1245390 | 2021-04-22 | Windham | Connecticut | 9015 | 10461 | 189 |
1242143 | 1242143 | 2021-04-21 | Windham | Connecticut | 9015 | 10449 | 189 |
1238896 | 1238896 | 2021-04-20 | Windham | Connecticut | 9015 | 10412 | 189 |
1235649 | 1235649 | 2021-04-19 | Windham | Connecticut | 9015 | 10395 | 189 |
1232402 | 1232402 | 2021-04-18 | Windham | Connecticut | 9015 | 10337 | 189 |
1229153 | 1229153 | 2021-04-17 | Windham | Connecticut | 9015 | 10337 | 189 |
1225905 | 1225905 | 2021-04-16 | Windham | Connecticut | 9015 | 10337 | 189 |
1222658 | 1222658 | 2021-04-15 | Windham | Connecticut | 9015 | 10298 | 189 |
1219410 | 1219410 | 2021-04-14 | Windham | Connecticut | 9015 | 10289 | 189 |
1216162 | 1216162 | 2021-04-13 | Windham | Connecticut | 9015 | 10235 | 189 |
810407 | 810407 | 2020-12-09 | New London | Connecticut | 9011 | 7335 | 189 |
379814 | 379814 | 2020-07-29 | Middlesex | Connecticut | 9007 | 1375 | 189 |
376597 | 376597 | 2020-07-28 | Middlesex | Connecticut | 9007 | 1374 | 189 |
373383 | 373383 | 2020-07-27 | Middlesex | Connecticut | 9007 | 1373 | 189 |
354139 | 354139 | 2020-07-21 | Middlesex | Connecticut | 9007 | 1361 | 189 |
350937 | 350937 | 2020-07-20 | Middlesex | Connecticut | 9007 | 1359 | 189 |
347736 | 347736 | 2020-07-19 | Middlesex | Connecticut | 9007 | 1357 | 189 |
344536 | 344536 | 2020-07-18 | Middlesex | Connecticut | 9007 | 1357 | 189 |
341337 | 341337 | 2020-07-17 | Middlesex | Connecticut | 9007 | 1357 | 189 |
338140 | 338140 | 2020-07-16 | Middlesex | Connecticut | 9007 | 1351 | 189 |
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);