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 464
- Litchfield 460
- Hartford 458
- New Haven 458
- Middlesex 454
- Tolland 453
- Windham 453
- New London 452
- Unknown 442
state 1
- Connecticut · 4,094 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417438 | 1417438 | 2021-06-14 | Fairfield | Connecticut | 9001 | 100293 | 2201 |
1417439 | 1417439 | 2021-06-14 | Hartford | Connecticut | 9003 | 84300 | 2431 |
1417440 | 1417440 | 2021-06-14 | Litchfield | Connecticut | 9005 | 14634 | 298 |
1417441 | 1417441 | 2021-06-14 | Middlesex | Connecticut | 9007 | 12824 | 372 |
1417442 | 1417442 | 2021-06-14 | New Haven | Connecticut | 9009 | 92170 | 2128 |
1417443 | 1417443 | 2021-06-14 | New London | Connecticut | 9011 | 22534 | 450 |
1417444 | 1417444 | 2021-06-14 | Tolland | Connecticut | 9013 | 9621 | 187 |
1417445 | 1417445 | 2021-06-14 | Unknown | Connecticut | 1181 | 1 | |
1417446 | 1417446 | 2021-06-14 | Windham | Connecticut | 9015 | 10908 | 195 |
1414192 | 1414192 | 2021-06-13 | Fairfield | Connecticut | 9001 | 100257 | 2201 |
1414193 | 1414193 | 2021-06-13 | Hartford | Connecticut | 9003 | 84269 | 2431 |
1414194 | 1414194 | 2021-06-13 | Litchfield | Connecticut | 9005 | 14631 | 298 |
1414195 | 1414195 | 2021-06-13 | Middlesex | Connecticut | 9007 | 12819 | 371 |
1414196 | 1414196 | 2021-06-13 | New Haven | Connecticut | 9009 | 92136 | 2127 |
1414197 | 1414197 | 2021-06-13 | New London | Connecticut | 9011 | 22530 | 450 |
1414198 | 1414198 | 2021-06-13 | Tolland | Connecticut | 9013 | 9616 | 187 |
1414199 | 1414199 | 2021-06-13 | Unknown | Connecticut | 1183 | 1 | |
1414200 | 1414200 | 2021-06-13 | Windham | Connecticut | 9015 | 10909 | 195 |
1410947 | 1410947 | 2021-06-12 | Fairfield | Connecticut | 9001 | 100257 | 2201 |
1410948 | 1410948 | 2021-06-12 | Hartford | Connecticut | 9003 | 84269 | 2431 |
1410949 | 1410949 | 2021-06-12 | Litchfield | Connecticut | 9005 | 14631 | 298 |
1410950 | 1410950 | 2021-06-12 | Middlesex | Connecticut | 9007 | 12819 | 371 |
1410951 | 1410951 | 2021-06-12 | New Haven | Connecticut | 9009 | 92136 | 2127 |
1410952 | 1410952 | 2021-06-12 | New London | Connecticut | 9011 | 22530 | 450 |
1410953 | 1410953 | 2021-06-12 | Tolland | Connecticut | 9013 | 9616 | 187 |
1410954 | 1410954 | 2021-06-12 | Unknown | Connecticut | 1183 | 1 | |
1410955 | 1410955 | 2021-06-12 | Windham | Connecticut | 9015 | 10909 | 195 |
1407702 | 1407702 | 2021-06-11 | Fairfield | Connecticut | 9001 | 100257 | 2201 |
1407703 | 1407703 | 2021-06-11 | Hartford | Connecticut | 9003 | 84269 | 2431 |
1407704 | 1407704 | 2021-06-11 | Litchfield | Connecticut | 9005 | 14631 | 298 |
1407705 | 1407705 | 2021-06-11 | Middlesex | Connecticut | 9007 | 12819 | 371 |
1407706 | 1407706 | 2021-06-11 | New Haven | Connecticut | 9009 | 92136 | 2127 |
1407707 | 1407707 | 2021-06-11 | New London | Connecticut | 9011 | 22530 | 450 |
1407708 | 1407708 | 2021-06-11 | Tolland | Connecticut | 9013 | 9616 | 187 |
1407709 | 1407709 | 2021-06-11 | Unknown | Connecticut | 1183 | 1 | |
1407710 | 1407710 | 2021-06-11 | Windham | Connecticut | 9015 | 10909 | 195 |
1404456 | 1404456 | 2021-06-10 | Fairfield | Connecticut | 9001 | 100247 | 2201 |
1404457 | 1404457 | 2021-06-10 | Hartford | Connecticut | 9003 | 84266 | 2431 |
1404458 | 1404458 | 2021-06-10 | Litchfield | Connecticut | 9005 | 14632 | 298 |
1404459 | 1404459 | 2021-06-10 | Middlesex | Connecticut | 9007 | 12817 | 371 |
1404460 | 1404460 | 2021-06-10 | New Haven | Connecticut | 9009 | 92127 | 2126 |
1404461 | 1404461 | 2021-06-10 | New London | Connecticut | 9011 | 22522 | 450 |
1404462 | 1404462 | 2021-06-10 | Tolland | Connecticut | 9013 | 9613 | 187 |
1404463 | 1404463 | 2021-06-10 | Unknown | Connecticut | 1183 | 1 | |
1404464 | 1404464 | 2021-06-10 | Windham | Connecticut | 9015 | 10912 | 195 |
1401211 | 1401211 | 2021-06-09 | Fairfield | Connecticut | 9001 | 100226 | 2201 |
1401212 | 1401212 | 2021-06-09 | Hartford | Connecticut | 9003 | 84262 | 2430 |
1401213 | 1401213 | 2021-06-09 | Litchfield | Connecticut | 9005 | 14628 | 298 |
1401214 | 1401214 | 2021-06-09 | Middlesex | Connecticut | 9007 | 12812 | 371 |
1401215 | 1401215 | 2021-06-09 | New Haven | Connecticut | 9009 | 92115 | 2125 |
1401216 | 1401216 | 2021-06-09 | New London | Connecticut | 9011 | 22516 | 449 |
1401217 | 1401217 | 2021-06-09 | Tolland | Connecticut | 9013 | 9614 | 187 |
1401218 | 1401218 | 2021-06-09 | Unknown | Connecticut | 1182 | 1 | |
1401219 | 1401219 | 2021-06-09 | Windham | Connecticut | 9015 | 10907 | 195 |
1397966 | 1397966 | 2021-06-08 | Fairfield | Connecticut | 9001 | 100200 | 2201 |
1397967 | 1397967 | 2021-06-08 | Hartford | Connecticut | 9003 | 84226 | 2429 |
1397968 | 1397968 | 2021-06-08 | Litchfield | Connecticut | 9005 | 14615 | 298 |
1397969 | 1397969 | 2021-06-08 | Middlesex | Connecticut | 9007 | 12807 | 371 |
1397970 | 1397970 | 2021-06-08 | New Haven | Connecticut | 9009 | 92094 | 2124 |
1397971 | 1397971 | 2021-06-08 | New London | Connecticut | 9011 | 22512 | 449 |
1397972 | 1397972 | 2021-06-08 | Tolland | Connecticut | 9013 | 9612 | 187 |
1397973 | 1397973 | 2021-06-08 | Unknown | Connecticut | 1183 | 1 | |
1397974 | 1397974 | 2021-06-08 | Windham | Connecticut | 9015 | 10905 | 195 |
1394719 | 1394719 | 2021-06-07 | Fairfield | Connecticut | 9001 | 100188 | 2200 |
1394720 | 1394720 | 2021-06-07 | Hartford | Connecticut | 9003 | 84200 | 2428 |
1394721 | 1394721 | 2021-06-07 | Litchfield | Connecticut | 9005 | 14610 | 298 |
1394722 | 1394722 | 2021-06-07 | Middlesex | Connecticut | 9007 | 12808 | 371 |
1394723 | 1394723 | 2021-06-07 | New Haven | Connecticut | 9009 | 92079 | 2124 |
1394724 | 1394724 | 2021-06-07 | New London | Connecticut | 9011 | 22511 | 449 |
1394725 | 1394725 | 2021-06-07 | Tolland | Connecticut | 9013 | 9609 | 187 |
1394726 | 1394726 | 2021-06-07 | Unknown | Connecticut | 1183 | 1 | |
1394727 | 1394727 | 2021-06-07 | Windham | Connecticut | 9015 | 10900 | 195 |
1391474 | 1391474 | 2021-06-06 | Fairfield | Connecticut | 9001 | 100155 | 2198 |
1391475 | 1391475 | 2021-06-06 | Hartford | Connecticut | 9003 | 84146 | 2427 |
1391476 | 1391476 | 2021-06-06 | Litchfield | Connecticut | 9005 | 14606 | 297 |
1391477 | 1391477 | 2021-06-06 | Middlesex | Connecticut | 9007 | 12797 | 371 |
1391478 | 1391478 | 2021-06-06 | New Haven | Connecticut | 9009 | 92013 | 2121 |
1391479 | 1391479 | 2021-06-06 | New London | Connecticut | 9011 | 22497 | 449 |
1391480 | 1391480 | 2021-06-06 | Tolland | Connecticut | 9013 | 9600 | 187 |
1391481 | 1391481 | 2021-06-06 | Unknown | Connecticut | 1183 | 1 | |
1391482 | 1391482 | 2021-06-06 | Windham | Connecticut | 9015 | 10894 | 195 |
1388229 | 1388229 | 2021-06-05 | Fairfield | Connecticut | 9001 | 100155 | 2198 |
1388230 | 1388230 | 2021-06-05 | Hartford | Connecticut | 9003 | 84146 | 2427 |
1388231 | 1388231 | 2021-06-05 | Litchfield | Connecticut | 9005 | 14606 | 297 |
1388232 | 1388232 | 2021-06-05 | Middlesex | Connecticut | 9007 | 12797 | 371 |
1388233 | 1388233 | 2021-06-05 | New Haven | Connecticut | 9009 | 92013 | 2121 |
1388234 | 1388234 | 2021-06-05 | New London | Connecticut | 9011 | 22497 | 449 |
1388235 | 1388235 | 2021-06-05 | Tolland | Connecticut | 9013 | 9600 | 187 |
1388236 | 1388236 | 2021-06-05 | Unknown | Connecticut | 1183 | 1 | |
1388237 | 1388237 | 2021-06-05 | Windham | Connecticut | 9015 | 10894 | 195 |
1384984 | 1384984 | 2021-06-04 | Fairfield | Connecticut | 9001 | 100155 | 2198 |
1384985 | 1384985 | 2021-06-04 | Hartford | Connecticut | 9003 | 84146 | 2427 |
1384986 | 1384986 | 2021-06-04 | Litchfield | Connecticut | 9005 | 14606 | 297 |
1384987 | 1384987 | 2021-06-04 | Middlesex | Connecticut | 9007 | 12797 | 371 |
1384988 | 1384988 | 2021-06-04 | New Haven | Connecticut | 9009 | 92013 | 2121 |
1384989 | 1384989 | 2021-06-04 | New London | Connecticut | 9011 | 22497 | 449 |
1384990 | 1384990 | 2021-06-04 | Tolland | Connecticut | 9013 | 9600 | 187 |
1384991 | 1384991 | 2021-06-04 | Unknown | Connecticut | 1183 | 1 | |
1384992 | 1384992 | 2021-06-04 | Windham | Connecticut | 9015 | 10894 | 195 |
1381738 | 1381738 | 2021-06-03 | Fairfield | Connecticut | 9001 | 100093 | 2198 |
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);