ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,091 rows where state = "Connecticut" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 9
- Fairfield 797
- Litchfield 793
- Hartford 791
- New Haven 791
- Middlesex 787
- Tolland 786
- Windham 786
- New London 785
- Unknown 775
state 1
- Connecticut · 7,091 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
778 | 778 | 2020-03-08 | Fairfield | Connecticut | 9001 | 1 | 0 |
895 | 895 | 2020-03-09 | Fairfield | Connecticut | 9001 | 2 | 0 |
1030 | 1030 | 2020-03-10 | Fairfield | Connecticut | 9001 | 2 | 0 |
1198 | 1198 | 2020-03-11 | Fairfield | Connecticut | 9001 | 3 | 0 |
1406 | 1406 | 2020-03-12 | Fairfield | Connecticut | 9001 | 5 | 0 |
1407 | 1407 | 2020-03-12 | Litchfield | Connecticut | 9005 | 1 | 0 |
1672 | 1672 | 2020-03-13 | Fairfield | Connecticut | 9001 | 8 | 0 |
1673 | 1673 | 2020-03-13 | Litchfield | Connecticut | 9005 | 3 | 0 |
1992 | 1992 | 2020-03-14 | Fairfield | Connecticut | 9001 | 15 | 0 |
1993 | 1993 | 2020-03-14 | Hartford | Connecticut | 9003 | 1 | 0 |
1994 | 1994 | 2020-03-14 | Litchfield | Connecticut | 9005 | 3 | 0 |
1995 | 1995 | 2020-03-14 | New Haven | Connecticut | 9009 | 1 | 0 |
2374 | 2374 | 2020-03-15 | Fairfield | Connecticut | 9001 | 16 | 0 |
2375 | 2375 | 2020-03-15 | Hartford | Connecticut | 9003 | 3 | 0 |
2376 | 2376 | 2020-03-15 | Litchfield | Connecticut | 9005 | 4 | 0 |
2377 | 2377 | 2020-03-15 | New Haven | Connecticut | 9009 | 3 | 0 |
2809 | 2809 | 2020-03-16 | Fairfield | Connecticut | 9001 | 29 | 0 |
2810 | 2810 | 2020-03-16 | Hartford | Connecticut | 9003 | 4 | 0 |
2811 | 2811 | 2020-03-16 | Litchfield | Connecticut | 9005 | 4 | 0 |
2812 | 2812 | 2020-03-16 | New Haven | Connecticut | 9009 | 4 | 0 |
3291 | 3291 | 2020-03-17 | Fairfield | Connecticut | 9001 | 48 | 0 |
3292 | 3292 | 2020-03-17 | Hartford | Connecticut | 9003 | 7 | 0 |
3293 | 3293 | 2020-03-17 | Litchfield | Connecticut | 9005 | 5 | 0 |
3294 | 3294 | 2020-03-17 | New Haven | Connecticut | 9009 | 8 | 0 |
3847 | 3847 | 2020-03-18 | Hartford | Connecticut | 9003 | 11 | 0 |
3848 | 3848 | 2020-03-18 | Litchfield | Connecticut | 9005 | 5 | 0 |
3849 | 3849 | 2020-03-18 | Middlesex | Connecticut | 9007 | 1 | 0 |
3850 | 3850 | 2020-03-18 | New Haven | Connecticut | 9009 | 10 | 0 |
4510 | 4510 | 2020-03-19 | Hartford | Connecticut | 9003 | 18 | 0 |
4511 | 4511 | 2020-03-19 | Litchfield | Connecticut | 9005 | 7 | 0 |
4512 | 4512 | 2020-03-19 | Middlesex | Connecticut | 9007 | 3 | 0 |
4513 | 4513 | 2020-03-19 | New Haven | Connecticut | 9009 | 24 | 0 |
4514 | 4514 | 2020-03-19 | Tolland | Connecticut | 9013 | 4 | 0 |
4515 | 4515 | 2020-03-19 | Windham | Connecticut | 9015 | 1 | 0 |
5288 | 5288 | 2020-03-20 | Hartford | Connecticut | 9003 | 29 | 0 |
5289 | 5289 | 2020-03-20 | Litchfield | Connecticut | 9005 | 8 | 0 |
5290 | 5290 | 2020-03-20 | Middlesex | Connecticut | 9007 | 5 | 0 |
5291 | 5291 | 2020-03-20 | New Haven | Connecticut | 9009 | 24 | 0 |
5292 | 5292 | 2020-03-20 | New London | Connecticut | 9011 | 1 | 0 |
5293 | 5293 | 2020-03-20 | Tolland | Connecticut | 9013 | 4 | 0 |
5294 | 5294 | 2020-03-20 | Windham | Connecticut | 9015 | 1 | 0 |
6215 | 6215 | 2020-03-21 | Hartford | Connecticut | 9003 | 35 | 0 |
6216 | 6216 | 2020-03-21 | Litchfield | Connecticut | 9005 | 11 | 0 |
6217 | 6217 | 2020-03-21 | Middlesex | Connecticut | 9007 | 6 | 0 |
6218 | 6218 | 2020-03-21 | New Haven | Connecticut | 9009 | 24 | 0 |
6219 | 6219 | 2020-03-21 | New London | Connecticut | 9011 | 1 | 0 |
6221 | 6221 | 2020-03-21 | Windham | Connecticut | 9015 | 1 | 0 |
7252 | 7252 | 2020-03-22 | Litchfield | Connecticut | 9005 | 12 | 0 |
7253 | 7253 | 2020-03-22 | Middlesex | Connecticut | 9007 | 6 | 0 |
7254 | 7254 | 2020-03-22 | New Haven | Connecticut | 9009 | 29 | 0 |
7255 | 7255 | 2020-03-22 | New London | Connecticut | 9011 | 3 | 0 |
7257 | 7257 | 2020-03-22 | Windham | Connecticut | 9015 | 1 | 0 |
8398 | 8398 | 2020-03-23 | Litchfield | Connecticut | 9005 | 13 | 0 |
8399 | 8399 | 2020-03-23 | Middlesex | Connecticut | 9007 | 8 | 0 |
8400 | 8400 | 2020-03-23 | New Haven | Connecticut | 9009 | 41 | 0 |
8401 | 8401 | 2020-03-23 | New London | Connecticut | 9011 | 4 | 0 |
8403 | 8403 | 2020-03-23 | Windham | Connecticut | 9015 | 2 | 0 |
9643 | 9643 | 2020-03-24 | Litchfield | Connecticut | 9005 | 22 | 0 |
9644 | 9644 | 2020-03-24 | Middlesex | Connecticut | 9007 | 8 | 0 |
9645 | 9645 | 2020-03-24 | New Haven | Connecticut | 9009 | 89 | 0 |
9646 | 9646 | 2020-03-24 | New London | Connecticut | 9011 | 6 | 0 |
9648 | 9648 | 2020-03-24 | Windham | Connecticut | 9015 | 2 | 0 |
11017 | 11017 | 2020-03-25 | Litchfield | Connecticut | 9005 | 33 | 0 |
11018 | 11018 | 2020-03-25 | Middlesex | Connecticut | 9007 | 15 | 0 |
11020 | 11020 | 2020-03-25 | New London | Connecticut | 9011 | 9 | 0 |
11022 | 11022 | 2020-03-25 | Windham | Connecticut | 9015 | 2 | 0 |
12565 | 12565 | 2020-03-26 | Litchfield | Connecticut | 9005 | 44 | 0 |
12568 | 12568 | 2020-03-26 | New London | Connecticut | 9011 | 13 | 0 |
12570 | 12570 | 2020-03-26 | Windham | Connecticut | 9015 | 3 | 0 |
14234 | 14234 | 2020-03-27 | Litchfield | Connecticut | 9005 | 52 | 0 |
14237 | 14237 | 2020-03-27 | New London | Connecticut | 9011 | 15 | 0 |
14239 | 14239 | 2020-03-27 | Windham | Connecticut | 9015 | 3 | 0 |
16018 | 16018 | 2020-03-28 | Litchfield | Connecticut | 9005 | 65 | 0 |
16021 | 16021 | 2020-03-28 | New London | Connecticut | 9011 | 19 | 0 |
16023 | 16023 | 2020-03-28 | Windham | Connecticut | 9015 | 3 | 0 |
17910 | 17910 | 2020-03-29 | Litchfield | Connecticut | 9005 | 87 | 0 |
17913 | 17913 | 2020-03-29 | New London | Connecticut | 9011 | 20 | 0 |
17915 | 17915 | 2020-03-29 | Windham | Connecticut | 9015 | 7 | 0 |
19892 | 19892 | 2020-03-30 | New London | Connecticut | 9011 | 24 | 0 |
19894 | 19894 | 2020-03-30 | Unknown | Connecticut | 176 | 0 | |
19895 | 19895 | 2020-03-30 | Windham | Connecticut | 9015 | 10 | 0 |
21972 | 21972 | 2020-03-31 | Windham | Connecticut | 9015 | 11 | 0 |
24131 | 24131 | 2020-04-01 | Windham | Connecticut | 9015 | 19 | 0 |
26361 | 26361 | 2020-04-02 | Windham | Connecticut | 9015 | 21 | 0 |
28663 | 28663 | 2020-04-03 | Windham | Connecticut | 9015 | 27 | 0 |
35871 | 35871 | 2020-04-06 | Unknown | Connecticut | 264 | 0 | |
89959 | 89959 | 2020-04-26 | Unknown | Connecticut | 522 | 0 | |
92777 | 92777 | 2020-04-27 | Unknown | Connecticut | 484 | 0 | |
172709 | 172709 | 2020-05-24 | Unknown | Connecticut | 210 | 0 | |
175752 | 175752 | 2020-05-25 | Unknown | Connecticut | 224 | 0 | |
184894 | 184894 | 2020-05-28 | Unknown | Connecticut | 218 | 0 | |
187950 | 187950 | 2020-05-29 | Unknown | Connecticut | 226 | 0 | |
191015 | 191015 | 2020-05-30 | Unknown | Connecticut | 229 | 0 | |
194082 | 194082 | 2020-05-31 | Unknown | Connecticut | 234 | 0 | |
197152 | 197152 | 2020-06-01 | Unknown | Connecticut | 240 | 0 | |
200225 | 200225 | 2020-06-02 | Unknown | Connecticut | 251 | 0 | |
203301 | 203301 | 2020-06-03 | Unknown | Connecticut | 248 | 0 | |
206381 | 206381 | 2020-06-04 | Unknown | Connecticut | 241 | 0 | |
209462 | 209462 | 2020-06-05 | Unknown | Connecticut | 245 | 0 | |
212547 | 212547 | 2020-06-06 | Unknown | Connecticut | 255 | 0 |
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);