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 cases
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 |
1407 | 1407 | 2020-03-12 | Litchfield | Connecticut | 9005 | 1 | 0 |
1993 | 1993 | 2020-03-14 | Hartford | Connecticut | 9003 | 1 | 0 |
1995 | 1995 | 2020-03-14 | New Haven | Connecticut | 9009 | 1 | 0 |
3849 | 3849 | 2020-03-18 | Middlesex | Connecticut | 9007 | 1 | 0 |
4515 | 4515 | 2020-03-19 | Windham | Connecticut | 9015 | 1 | 0 |
5292 | 5292 | 2020-03-20 | New London | Connecticut | 9011 | 1 | 0 |
5294 | 5294 | 2020-03-20 | Windham | Connecticut | 9015 | 1 | 0 |
6219 | 6219 | 2020-03-21 | New London | Connecticut | 9011 | 1 | 0 |
6221 | 6221 | 2020-03-21 | Windham | Connecticut | 9015 | 1 | 0 |
7257 | 7257 | 2020-03-22 | Windham | Connecticut | 9015 | 1 | 0 |
895 | 895 | 2020-03-09 | Fairfield | Connecticut | 9001 | 2 | 0 |
1030 | 1030 | 2020-03-10 | Fairfield | Connecticut | 9001 | 2 | 0 |
8403 | 8403 | 2020-03-23 | Windham | Connecticut | 9015 | 2 | 0 |
9648 | 9648 | 2020-03-24 | Windham | Connecticut | 9015 | 2 | 0 |
11022 | 11022 | 2020-03-25 | Windham | Connecticut | 9015 | 2 | 0 |
1198 | 1198 | 2020-03-11 | Fairfield | Connecticut | 9001 | 3 | 0 |
1673 | 1673 | 2020-03-13 | Litchfield | Connecticut | 9005 | 3 | 0 |
1994 | 1994 | 2020-03-14 | Litchfield | Connecticut | 9005 | 3 | 0 |
2375 | 2375 | 2020-03-15 | Hartford | Connecticut | 9003 | 3 | 0 |
2377 | 2377 | 2020-03-15 | New Haven | Connecticut | 9009 | 3 | 0 |
4512 | 4512 | 2020-03-19 | Middlesex | Connecticut | 9007 | 3 | 0 |
7255 | 7255 | 2020-03-22 | New London | Connecticut | 9011 | 3 | 0 |
12570 | 12570 | 2020-03-26 | Windham | Connecticut | 9015 | 3 | 0 |
14239 | 14239 | 2020-03-27 | Windham | Connecticut | 9015 | 3 | 0 |
16023 | 16023 | 2020-03-28 | Windham | Connecticut | 9015 | 3 | 0 |
2376 | 2376 | 2020-03-15 | Litchfield | Connecticut | 9005 | 4 | 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 |
4514 | 4514 | 2020-03-19 | Tolland | Connecticut | 9013 | 4 | 0 |
5293 | 5293 | 2020-03-20 | Tolland | Connecticut | 9013 | 4 | 0 |
8401 | 8401 | 2020-03-23 | New London | Connecticut | 9011 | 4 | 0 |
1406 | 1406 | 2020-03-12 | Fairfield | Connecticut | 9001 | 5 | 0 |
3293 | 3293 | 2020-03-17 | Litchfield | Connecticut | 9005 | 5 | 0 |
3848 | 3848 | 2020-03-18 | Litchfield | Connecticut | 9005 | 5 | 0 |
5290 | 5290 | 2020-03-20 | Middlesex | Connecticut | 9007 | 5 | 0 |
6220 | 6220 | 2020-03-21 | Tolland | Connecticut | 9013 | 5 | 1 |
6217 | 6217 | 2020-03-21 | Middlesex | Connecticut | 9007 | 6 | 0 |
7253 | 7253 | 2020-03-22 | Middlesex | Connecticut | 9007 | 6 | 0 |
9646 | 9646 | 2020-03-24 | New London | Connecticut | 9011 | 6 | 0 |
3292 | 3292 | 2020-03-17 | Hartford | Connecticut | 9003 | 7 | 0 |
4511 | 4511 | 2020-03-19 | Litchfield | Connecticut | 9005 | 7 | 0 |
17915 | 17915 | 2020-03-29 | Windham | Connecticut | 9015 | 7 | 0 |
1672 | 1672 | 2020-03-13 | Fairfield | Connecticut | 9001 | 8 | 0 |
3294 | 3294 | 2020-03-17 | New Haven | Connecticut | 9009 | 8 | 0 |
5289 | 5289 | 2020-03-20 | Litchfield | Connecticut | 9005 | 8 | 0 |
8399 | 8399 | 2020-03-23 | Middlesex | Connecticut | 9007 | 8 | 0 |
9644 | 9644 | 2020-03-24 | Middlesex | Connecticut | 9007 | 8 | 0 |
11020 | 11020 | 2020-03-25 | New London | Connecticut | 9011 | 9 | 0 |
3850 | 3850 | 2020-03-18 | New Haven | Connecticut | 9009 | 10 | 0 |
19895 | 19895 | 2020-03-30 | Windham | Connecticut | 9015 | 10 | 0 |
3847 | 3847 | 2020-03-18 | Hartford | Connecticut | 9003 | 11 | 0 |
6216 | 6216 | 2020-03-21 | Litchfield | Connecticut | 9005 | 11 | 0 |
21972 | 21972 | 2020-03-31 | Windham | Connecticut | 9015 | 11 | 0 |
7252 | 7252 | 2020-03-22 | Litchfield | Connecticut | 9005 | 12 | 0 |
8398 | 8398 | 2020-03-23 | Litchfield | Connecticut | 9005 | 13 | 0 |
12568 | 12568 | 2020-03-26 | New London | Connecticut | 9011 | 13 | 0 |
7256 | 7256 | 2020-03-22 | Tolland | Connecticut | 9013 | 14 | 2 |
1992 | 1992 | 2020-03-14 | Fairfield | Connecticut | 9001 | 15 | 0 |
11018 | 11018 | 2020-03-25 | Middlesex | Connecticut | 9007 | 15 | 0 |
14237 | 14237 | 2020-03-27 | New London | Connecticut | 9011 | 15 | 0 |
2374 | 2374 | 2020-03-15 | Fairfield | Connecticut | 9001 | 16 | 0 |
8402 | 8402 | 2020-03-23 | Tolland | Connecticut | 9013 | 16 | 2 |
4510 | 4510 | 2020-03-19 | Hartford | Connecticut | 9003 | 18 | 0 |
12566 | 12566 | 2020-03-26 | Middlesex | Connecticut | 9007 | 18 | 1 |
9647 | 9647 | 2020-03-24 | Tolland | Connecticut | 9013 | 19 | 3 |
16021 | 16021 | 2020-03-28 | New London | Connecticut | 9011 | 19 | 0 |
24131 | 24131 | 2020-04-01 | Windham | Connecticut | 9015 | 19 | 0 |
17913 | 17913 | 2020-03-29 | New London | Connecticut | 9011 | 20 | 0 |
26361 | 26361 | 2020-04-02 | Windham | Connecticut | 9015 | 21 | 0 |
9643 | 9643 | 2020-03-24 | Litchfield | Connecticut | 9005 | 22 | 0 |
4513 | 4513 | 2020-03-19 | New Haven | Connecticut | 9009 | 24 | 0 |
5291 | 5291 | 2020-03-20 | New Haven | Connecticut | 9009 | 24 | 0 |
6218 | 6218 | 2020-03-21 | New Haven | Connecticut | 9009 | 24 | 0 |
19892 | 19892 | 2020-03-30 | New London | Connecticut | 9011 | 24 | 0 |
14235 | 14235 | 2020-03-27 | Middlesex | Connecticut | 9007 | 25 | 1 |
11021 | 11021 | 2020-03-25 | Tolland | Connecticut | 9013 | 27 | 3 |
21969 | 21969 | 2020-03-31 | New London | Connecticut | 9011 | 27 | 1 |
28663 | 28663 | 2020-04-03 | Windham | Connecticut | 9015 | 27 | 0 |
16019 | 16019 | 2020-03-28 | Middlesex | Connecticut | 9007 | 28 | 1 |
2809 | 2809 | 2020-03-16 | Fairfield | Connecticut | 9001 | 29 | 0 |
5288 | 5288 | 2020-03-20 | Hartford | Connecticut | 9003 | 29 | 0 |
7254 | 7254 | 2020-03-22 | New Haven | Connecticut | 9009 | 29 | 0 |
24128 | 24128 | 2020-04-01 | New London | Connecticut | 9011 | 29 | 1 |
26358 | 26358 | 2020-04-02 | New London | Connecticut | 9011 | 29 | 1 |
31021 | 31021 | 2020-04-04 | Windham | Connecticut | 9015 | 31 | 1 |
33427 | 33427 | 2020-04-05 | Windham | Connecticut | 9015 | 32 | 1 |
11017 | 11017 | 2020-03-25 | Litchfield | Connecticut | 9005 | 33 | 0 |
12569 | 12569 | 2020-03-26 | Tolland | Connecticut | 9013 | 33 | 3 |
14238 | 14238 | 2020-03-27 | Tolland | Connecticut | 9013 | 33 | 3 |
6215 | 6215 | 2020-03-21 | Hartford | Connecticut | 9003 | 35 | 0 |
16022 | 16022 | 2020-03-28 | Tolland | Connecticut | 9013 | 37 | 4 |
17911 | 17911 | 2020-03-29 | Middlesex | Connecticut | 9007 | 38 | 1 |
17914 | 17914 | 2020-03-29 | Tolland | Connecticut | 9013 | 40 | 4 |
28660 | 28660 | 2020-04-03 | New London | Connecticut | 9011 | 40 | 3 |
35872 | 35872 | 2020-04-06 | Windham | Connecticut | 9015 | 40 | 1 |
8400 | 8400 | 2020-03-23 | New Haven | Connecticut | 9009 | 41 | 0 |
38362 | 38362 | 2020-04-07 | Windham | Connecticut | 9015 | 43 | 1 |
12565 | 12565 | 2020-03-26 | Litchfield | Connecticut | 9005 | 44 | 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);