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 date
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 |
3846 | 3846 | 2020-03-18 | Fairfield | Connecticut | 9001 | 69 | 1 |
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 |
4509 | 4509 | 2020-03-19 | Fairfield | Connecticut | 9001 | 102 | 4 |
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 |
5287 | 5287 | 2020-03-20 | Fairfield | Connecticut | 9001 | 122 | 4 |
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 |
6214 | 6214 | 2020-03-21 | Fairfield | Connecticut | 9001 | 140 | 4 |
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 |
6220 | 6220 | 2020-03-21 | Tolland | Connecticut | 9013 | 5 | 1 |
6221 | 6221 | 2020-03-21 | Windham | Connecticut | 9015 | 1 | 0 |
7250 | 7250 | 2020-03-22 | Fairfield | Connecticut | 9001 | 208 | 5 |
7251 | 7251 | 2020-03-22 | Hartford | Connecticut | 9003 | 54 | 1 |
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 |
7256 | 7256 | 2020-03-22 | Tolland | Connecticut | 9013 | 14 | 2 |
7257 | 7257 | 2020-03-22 | Windham | Connecticut | 9015 | 1 | 0 |
8396 | 8396 | 2020-03-23 | Fairfield | Connecticut | 9001 | 270 | 6 |
8397 | 8397 | 2020-03-23 | Hartford | Connecticut | 9003 | 61 | 2 |
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 |
8402 | 8402 | 2020-03-23 | Tolland | Connecticut | 9013 | 16 | 2 |
8403 | 8403 | 2020-03-23 | Windham | Connecticut | 9015 | 2 | 0 |
9641 | 9641 | 2020-03-24 | Fairfield | Connecticut | 9001 | 384 | 7 |
9642 | 9642 | 2020-03-24 | Hartford | Connecticut | 9003 | 88 | 2 |
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 |
9647 | 9647 | 2020-03-24 | Tolland | Connecticut | 9013 | 19 | 3 |
9648 | 9648 | 2020-03-24 | Windham | Connecticut | 9015 | 2 | 0 |
11015 | 11015 | 2020-03-25 | Fairfield | Connecticut | 9001 | 546 | 12 |
11016 | 11016 | 2020-03-25 | Hartford | Connecticut | 9003 | 116 | 2 |
11017 | 11017 | 2020-03-25 | Litchfield | Connecticut | 9005 | 33 | 0 |
11018 | 11018 | 2020-03-25 | Middlesex | Connecticut | 9007 | 15 | 0 |
11019 | 11019 | 2020-03-25 | New Haven | Connecticut | 9009 | 127 | 2 |
11020 | 11020 | 2020-03-25 | New London | Connecticut | 9011 | 9 | 0 |
11021 | 11021 | 2020-03-25 | Tolland | Connecticut | 9013 | 27 | 3 |
11022 | 11022 | 2020-03-25 | Windham | Connecticut | 9015 | 2 | 0 |
12563 | 12563 | 2020-03-26 | Fairfield | Connecticut | 9001 | 607 | 13 |
12564 | 12564 | 2020-03-26 | Hartford | Connecticut | 9003 | 138 | 2 |
12565 | 12565 | 2020-03-26 | Litchfield | Connecticut | 9005 | 44 | 0 |
12566 | 12566 | 2020-03-26 | Middlesex | Connecticut | 9007 | 18 | 1 |
12567 | 12567 | 2020-03-26 | New Haven | Connecticut | 9009 | 156 | 2 |
12568 | 12568 | 2020-03-26 | New London | Connecticut | 9011 | 13 | 0 |
12569 | 12569 | 2020-03-26 | Tolland | Connecticut | 9013 | 33 | 3 |
12570 | 12570 | 2020-03-26 | Windham | Connecticut | 9015 | 3 | 0 |
14232 | 14232 | 2020-03-27 | Fairfield | Connecticut | 9001 | 752 | 15 |
14233 | 14233 | 2020-03-27 | Hartford | Connecticut | 9003 | 189 | 2 |
14234 | 14234 | 2020-03-27 | Litchfield | Connecticut | 9005 | 52 | 0 |
14235 | 14235 | 2020-03-27 | Middlesex | Connecticut | 9007 | 25 | 1 |
14236 | 14236 | 2020-03-27 | New Haven | Connecticut | 9009 | 222 | 6 |
14237 | 14237 | 2020-03-27 | New London | Connecticut | 9011 | 15 | 0 |
14238 | 14238 | 2020-03-27 | Tolland | Connecticut | 9013 | 33 | 3 |
14239 | 14239 | 2020-03-27 | Windham | Connecticut | 9015 | 3 | 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);