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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
- Fairfield 395
- Litchfield 391
- Hartford 389
- New Haven 389
- Middlesex 385
- Tolland 384
- Windham 384
- New London 383
- Unknown 373
state 1
- Connecticut · 3,473 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193417 | 1193417 | 2021-04-06 | Fairfield | Connecticut | 9001 | 91622 | 2126 |
1193418 | 1193418 | 2021-04-06 | Hartford | Connecticut | 9003 | 77133 | 2355 |
1193419 | 1193419 | 2021-04-06 | Litchfield | Connecticut | 9005 | 13282 | 286 |
1193420 | 1193420 | 2021-04-06 | Middlesex | Connecticut | 9007 | 11820 | 355 |
1193421 | 1193421 | 2021-04-06 | New Haven | Connecticut | 9009 | 82967 | 2008 |
1193422 | 1193422 | 2021-04-06 | New London | Connecticut | 9011 | 20986 | 423 |
1193423 | 1193423 | 2021-04-06 | Tolland | Connecticut | 9013 | 8783 | 177 |
1193424 | 1193424 | 2021-04-06 | Unknown | Connecticut | 1118 | 12 | |
1193425 | 1193425 | 2021-04-06 | Windham | Connecticut | 9015 | 10018 | 188 |
1190167 | 1190167 | 2021-04-05 | Fairfield | Connecticut | 9001 | 91364 | 2125 |
1190168 | 1190168 | 2021-04-05 | Hartford | Connecticut | 9003 | 76839 | 2352 |
1190169 | 1190169 | 2021-04-05 | Litchfield | Connecticut | 9005 | 13216 | 285 |
1190170 | 1190170 | 2021-04-05 | Middlesex | Connecticut | 9007 | 11781 | 355 |
1190171 | 1190171 | 2021-04-05 | New Haven | Connecticut | 9009 | 82651 | 2006 |
1190172 | 1190172 | 2021-04-05 | New London | Connecticut | 9011 | 20938 | 424 |
1190173 | 1190173 | 2021-04-05 | Tolland | Connecticut | 9013 | 8747 | 177 |
1190174 | 1190174 | 2021-04-05 | Unknown | Connecticut | 1113 | 11 | |
1190175 | 1190175 | 2021-04-05 | Windham | Connecticut | 9015 | 10006 | 188 |
1186920 | 1186920 | 2021-04-04 | Fairfield | Connecticut | 9001 | 90537 | 2117 |
1186921 | 1186921 | 2021-04-04 | Hartford | Connecticut | 9003 | 76341 | 2348 |
1186922 | 1186922 | 2021-04-04 | Litchfield | Connecticut | 9005 | 13064 | 283 |
1186923 | 1186923 | 2021-04-04 | Middlesex | Connecticut | 9007 | 11668 | 354 |
1186924 | 1186924 | 2021-04-04 | New Haven | Connecticut | 9009 | 81793 | 2002 |
1186925 | 1186925 | 2021-04-04 | New London | Connecticut | 9011 | 20819 | 424 |
1186926 | 1186926 | 2021-04-04 | Tolland | Connecticut | 9013 | 8690 | 177 |
1186927 | 1186927 | 2021-04-04 | Unknown | Connecticut | 1103 | 11 | |
1186928 | 1186928 | 2021-04-04 | Windham | Connecticut | 9015 | 9941 | 188 |
1183673 | 1183673 | 2021-04-03 | Fairfield | Connecticut | 9001 | 90537 | 2117 |
1183674 | 1183674 | 2021-04-03 | Hartford | Connecticut | 9003 | 76341 | 2348 |
1183675 | 1183675 | 2021-04-03 | Litchfield | Connecticut | 9005 | 13064 | 283 |
1183676 | 1183676 | 2021-04-03 | Middlesex | Connecticut | 9007 | 11668 | 354 |
1183677 | 1183677 | 2021-04-03 | New Haven | Connecticut | 9009 | 81793 | 2002 |
1183678 | 1183678 | 2021-04-03 | New London | Connecticut | 9011 | 20819 | 424 |
1183679 | 1183679 | 2021-04-03 | Tolland | Connecticut | 9013 | 8690 | 177 |
1183680 | 1183680 | 2021-04-03 | Unknown | Connecticut | 1103 | 11 | |
1183681 | 1183681 | 2021-04-03 | Windham | Connecticut | 9015 | 9941 | 188 |
1180426 | 1180426 | 2021-04-02 | Fairfield | Connecticut | 9001 | 90537 | 2117 |
1180427 | 1180427 | 2021-04-02 | Hartford | Connecticut | 9003 | 76341 | 2348 |
1180428 | 1180428 | 2021-04-02 | Litchfield | Connecticut | 9005 | 13064 | 283 |
1180429 | 1180429 | 2021-04-02 | Middlesex | Connecticut | 9007 | 11668 | 354 |
1180430 | 1180430 | 2021-04-02 | New Haven | Connecticut | 9009 | 81793 | 2002 |
1180431 | 1180431 | 2021-04-02 | New London | Connecticut | 9011 | 20819 | 424 |
1180432 | 1180432 | 2021-04-02 | Tolland | Connecticut | 9013 | 8690 | 177 |
1180433 | 1180433 | 2021-04-02 | Unknown | Connecticut | 1103 | 11 | |
1180434 | 1180434 | 2021-04-02 | Windham | Connecticut | 9015 | 9941 | 188 |
1177179 | 1177179 | 2021-04-01 | Fairfield | Connecticut | 9001 | 90096 | 2115 |
1177180 | 1177180 | 2021-04-01 | Hartford | Connecticut | 9003 | 76038 | 2347 |
1177181 | 1177181 | 2021-04-01 | Litchfield | Connecticut | 9005 | 12995 | 283 |
1177182 | 1177182 | 2021-04-01 | Middlesex | Connecticut | 9007 | 11611 | 354 |
1177183 | 1177183 | 2021-04-01 | New Haven | Connecticut | 9009 | 81318 | 2001 |
1177184 | 1177184 | 2021-04-01 | New London | Connecticut | 9011 | 20759 | 424 |
1177185 | 1177185 | 2021-04-01 | Tolland | Connecticut | 9013 | 8653 | 177 |
1177186 | 1177186 | 2021-04-01 | Unknown | Connecticut | 1099 | 11 | |
1177187 | 1177187 | 2021-04-01 | Windham | Connecticut | 9015 | 9899 | 188 |
1173932 | 1173932 | 2021-03-31 | Fairfield | Connecticut | 9001 | 89598 | 2111 |
1173933 | 1173933 | 2021-03-31 | Hartford | Connecticut | 9003 | 75802 | 2345 |
1173934 | 1173934 | 2021-03-31 | Litchfield | Connecticut | 9005 | 12872 | 283 |
1173935 | 1173935 | 2021-03-31 | Middlesex | Connecticut | 9007 | 11552 | 354 |
1173936 | 1173936 | 2021-03-31 | New Haven | Connecticut | 9009 | 80806 | 1996 |
1173937 | 1173937 | 2021-03-31 | New London | Connecticut | 9011 | 20674 | 423 |
1173938 | 1173938 | 2021-03-31 | Tolland | Connecticut | 9013 | 8614 | 176 |
1173939 | 1173939 | 2021-03-31 | Unknown | Connecticut | 1089 | 11 | |
1173940 | 1173940 | 2021-03-31 | Windham | Connecticut | 9015 | 9881 | 187 |
1170685 | 1170685 | 2021-03-30 | Fairfield | Connecticut | 9001 | 89346 | 2109 |
1170686 | 1170686 | 2021-03-30 | Hartford | Connecticut | 9003 | 75665 | 2345 |
1170687 | 1170687 | 2021-03-30 | Litchfield | Connecticut | 9005 | 12805 | 283 |
1170688 | 1170688 | 2021-03-30 | Middlesex | Connecticut | 9007 | 11529 | 353 |
1170689 | 1170689 | 2021-03-30 | New Haven | Connecticut | 9009 | 80542 | 1999 |
1170690 | 1170690 | 2021-03-30 | New London | Connecticut | 9011 | 20641 | 422 |
1170691 | 1170691 | 2021-03-30 | Tolland | Connecticut | 9013 | 8589 | 176 |
1170692 | 1170692 | 2021-03-30 | Unknown | Connecticut | 1079 | 11 | |
1170693 | 1170693 | 2021-03-30 | Windham | Connecticut | 9015 | 9860 | 187 |
1167437 | 1167437 | 2021-03-29 | Fairfield | Connecticut | 9001 | 88876 | 2108 |
1167438 | 1167438 | 2021-03-29 | Hartford | Connecticut | 9003 | 75294 | 2345 |
1167439 | 1167439 | 2021-03-29 | Litchfield | Connecticut | 9005 | 12713 | 283 |
1167440 | 1167440 | 2021-03-29 | Middlesex | Connecticut | 9007 | 11475 | 352 |
1167441 | 1167441 | 2021-03-29 | New Haven | Connecticut | 9009 | 80047 | 2000 |
1167442 | 1167442 | 2021-03-29 | New London | Connecticut | 9011 | 20582 | 421 |
1167443 | 1167443 | 2021-03-29 | Tolland | Connecticut | 9013 | 8536 | 176 |
1167444 | 1167444 | 2021-03-29 | Unknown | Connecticut | 1078 | 11 | |
1167445 | 1167445 | 2021-03-29 | Windham | Connecticut | 9015 | 9838 | 187 |
1164189 | 1164189 | 2021-03-28 | Fairfield | Connecticut | 9001 | 87890 | 2106 |
1164190 | 1164190 | 2021-03-28 | Hartford | Connecticut | 9003 | 74654 | 2341 |
1164191 | 1164191 | 2021-03-28 | Litchfield | Connecticut | 9005 | 12518 | 282 |
1164192 | 1164192 | 2021-03-28 | Middlesex | Connecticut | 9007 | 11364 | 350 |
1164193 | 1164193 | 2021-03-28 | New Haven | Connecticut | 9009 | 79060 | 1992 |
1164194 | 1164194 | 2021-03-28 | New London | Connecticut | 9011 | 20412 | 420 |
1164195 | 1164195 | 2021-03-28 | Tolland | Connecticut | 9013 | 8457 | 176 |
1164196 | 1164196 | 2021-03-28 | Unknown | Connecticut | 1073 | 11 | |
1164197 | 1164197 | 2021-03-28 | Windham | Connecticut | 9015 | 9782 | 187 |
1160941 | 1160941 | 2021-03-27 | Fairfield | Connecticut | 9001 | 87890 | 2106 |
1160942 | 1160942 | 2021-03-27 | Hartford | Connecticut | 9003 | 74654 | 2341 |
1160943 | 1160943 | 2021-03-27 | Litchfield | Connecticut | 9005 | 12518 | 282 |
1160944 | 1160944 | 2021-03-27 | Middlesex | Connecticut | 9007 | 11364 | 350 |
1160945 | 1160945 | 2021-03-27 | New Haven | Connecticut | 9009 | 79060 | 1992 |
1160946 | 1160946 | 2021-03-27 | New London | Connecticut | 9011 | 20412 | 420 |
1160947 | 1160947 | 2021-03-27 | Tolland | Connecticut | 9013 | 8457 | 176 |
1160948 | 1160948 | 2021-03-27 | Unknown | Connecticut | 1073 | 11 | |
1160949 | 1160949 | 2021-03-27 | Windham | Connecticut | 9015 | 9782 | 187 |
1157693 | 1157693 | 2021-03-26 | Fairfield | Connecticut | 9001 | 87890 | 2106 |
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);