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 223
- Litchfield 219
- Hartford 217
- New Haven 217
- Middlesex 213
- Tolland 212
- Windham 212
- New London 211
- Unknown 201
state 1
- Connecticut · 1,925 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635193 | 635193 | 2020-10-16 | Fairfield | Connecticut | 9001 | 21368 | 1427 |
635194 | 635194 | 2020-10-16 | Hartford | Connecticut | 9003 | 16273 | 1445 |
635195 | 635195 | 2020-10-16 | Litchfield | Connecticut | 9005 | 1991 | 143 |
635196 | 635196 | 2020-10-16 | Middlesex | Connecticut | 9007 | 1754 | 194 |
635197 | 635197 | 2020-10-16 | New Haven | Connecticut | 9009 | 15455 | 1119 |
635198 | 635198 | 2020-10-16 | New London | Connecticut | 9011 | 3083 | 130 |
635199 | 635199 | 2020-10-16 | Tolland | Connecticut | 9013 | 1565 | 67 |
635200 | 635200 | 2020-10-16 | Unknown | Connecticut | 125 | 0 | |
635201 | 635201 | 2020-10-16 | Windham | Connecticut | 9015 | 1216 | 17 |
631947 | 631947 | 2020-10-15 | Fairfield | Connecticut | 9001 | 21183 | 1427 |
631948 | 631948 | 2020-10-15 | Hartford | Connecticut | 9003 | 16058 | 1445 |
631949 | 631949 | 2020-10-15 | Litchfield | Connecticut | 9005 | 1959 | 143 |
631950 | 631950 | 2020-10-15 | Middlesex | Connecticut | 9007 | 1733 | 193 |
631951 | 631951 | 2020-10-15 | New Haven | Connecticut | 9009 | 15310 | 1119 |
631952 | 631952 | 2020-10-15 | New London | Connecticut | 9011 | 2924 | 129 |
631953 | 631953 | 2020-10-15 | Tolland | Connecticut | 9013 | 1539 | 67 |
631954 | 631954 | 2020-10-15 | Unknown | Connecticut | 129 | 0 | |
631955 | 631955 | 2020-10-15 | Windham | Connecticut | 9015 | 1193 | 17 |
628703 | 628703 | 2020-10-14 | Fairfield | Connecticut | 9001 | 21128 | 1427 |
628704 | 628704 | 2020-10-14 | Hartford | Connecticut | 9003 | 16010 | 1443 |
628705 | 628705 | 2020-10-14 | Litchfield | Connecticut | 9005 | 1956 | 142 |
628706 | 628706 | 2020-10-14 | Middlesex | Connecticut | 9007 | 1720 | 193 |
628707 | 628707 | 2020-10-14 | New Haven | Connecticut | 9009 | 15263 | 1119 |
628708 | 628708 | 2020-10-14 | New London | Connecticut | 9011 | 2918 | 129 |
628709 | 628709 | 2020-10-14 | Tolland | Connecticut | 9013 | 1535 | 67 |
628710 | 628710 | 2020-10-14 | Unknown | Connecticut | 148 | 0 | |
628711 | 628711 | 2020-10-14 | Windham | Connecticut | 9015 | 1183 | 17 |
625460 | 625460 | 2020-10-13 | Fairfield | Connecticut | 9001 | 21104 | 1426 |
625461 | 625461 | 2020-10-13 | Hartford | Connecticut | 9003 | 15949 | 1443 |
625462 | 625462 | 2020-10-13 | Litchfield | Connecticut | 9005 | 1952 | 141 |
625463 | 625463 | 2020-10-13 | Middlesex | Connecticut | 9007 | 1714 | 193 |
625464 | 625464 | 2020-10-13 | New Haven | Connecticut | 9009 | 15223 | 1119 |
625465 | 625465 | 2020-10-13 | New London | Connecticut | 9011 | 2905 | 127 |
625466 | 625466 | 2020-10-13 | Tolland | Connecticut | 9013 | 1534 | 67 |
625467 | 625467 | 2020-10-13 | Unknown | Connecticut | 140 | 0 | |
625468 | 625468 | 2020-10-13 | Windham | Connecticut | 9015 | 1176 | 17 |
622217 | 622217 | 2020-10-12 | Fairfield | Connecticut | 9001 | 21052 | 1426 |
622218 | 622218 | 2020-10-12 | Hartford | Connecticut | 9003 | 15836 | 1443 |
622219 | 622219 | 2020-10-12 | Litchfield | Connecticut | 9005 | 1940 | 141 |
622220 | 622220 | 2020-10-12 | Middlesex | Connecticut | 9007 | 1709 | 193 |
622221 | 622221 | 2020-10-12 | New Haven | Connecticut | 9009 | 15164 | 1119 |
622222 | 622222 | 2020-10-12 | New London | Connecticut | 9011 | 2837 | 126 |
622223 | 622223 | 2020-10-12 | Tolland | Connecticut | 9013 | 1520 | 67 |
622224 | 622224 | 2020-10-12 | Unknown | Connecticut | 162 | 0 | |
622225 | 622225 | 2020-10-12 | Windham | Connecticut | 9015 | 1157 | 17 |
618974 | 618974 | 2020-10-11 | Fairfield | Connecticut | 9001 | 20752 | 1426 |
618975 | 618975 | 2020-10-11 | Hartford | Connecticut | 9003 | 15520 | 1442 |
618976 | 618976 | 2020-10-11 | Litchfield | Connecticut | 9005 | 1919 | 141 |
618977 | 618977 | 2020-10-11 | Middlesex | Connecticut | 9007 | 1667 | 193 |
618978 | 618978 | 2020-10-11 | New Haven | Connecticut | 9009 | 14877 | 1118 |
618979 | 618979 | 2020-10-11 | New London | Connecticut | 9011 | 2570 | 126 |
618980 | 618980 | 2020-10-11 | Tolland | Connecticut | 9013 | 1502 | 67 |
618981 | 618981 | 2020-10-11 | Unknown | Connecticut | 123 | 0 | |
618982 | 618982 | 2020-10-11 | Windham | Connecticut | 9015 | 1108 | 17 |
615732 | 615732 | 2020-10-10 | Fairfield | Connecticut | 9001 | 20752 | 1426 |
615733 | 615733 | 2020-10-10 | Hartford | Connecticut | 9003 | 15520 | 1442 |
615734 | 615734 | 2020-10-10 | Litchfield | Connecticut | 9005 | 1919 | 141 |
615735 | 615735 | 2020-10-10 | Middlesex | Connecticut | 9007 | 1667 | 193 |
615736 | 615736 | 2020-10-10 | New Haven | Connecticut | 9009 | 14877 | 1118 |
615737 | 615737 | 2020-10-10 | New London | Connecticut | 9011 | 2570 | 126 |
615738 | 615738 | 2020-10-10 | Tolland | Connecticut | 9013 | 1502 | 67 |
615739 | 615739 | 2020-10-10 | Unknown | Connecticut | 123 | 0 | |
615740 | 615740 | 2020-10-10 | Windham | Connecticut | 9015 | 1108 | 17 |
612491 | 612491 | 2020-10-09 | Fairfield | Connecticut | 9001 | 20752 | 1426 |
612492 | 612492 | 2020-10-09 | Hartford | Connecticut | 9003 | 15520 | 1442 |
612493 | 612493 | 2020-10-09 | Litchfield | Connecticut | 9005 | 1919 | 141 |
612494 | 612494 | 2020-10-09 | Middlesex | Connecticut | 9007 | 1667 | 193 |
612495 | 612495 | 2020-10-09 | New Haven | Connecticut | 9009 | 14877 | 1118 |
612496 | 612496 | 2020-10-09 | New London | Connecticut | 9011 | 2570 | 126 |
612497 | 612497 | 2020-10-09 | Tolland | Connecticut | 9013 | 1502 | 67 |
612498 | 612498 | 2020-10-09 | Unknown | Connecticut | 123 | 0 | |
612499 | 612499 | 2020-10-09 | Windham | Connecticut | 9015 | 1108 | 17 |
609249 | 609249 | 2020-10-08 | Fairfield | Connecticut | 9001 | 20701 | 1425 |
609250 | 609250 | 2020-10-08 | Hartford | Connecticut | 9003 | 15434 | 1442 |
609251 | 609251 | 2020-10-08 | Litchfield | Connecticut | 9005 | 1916 | 141 |
609252 | 609252 | 2020-10-08 | Middlesex | Connecticut | 9007 | 1652 | 193 |
609253 | 609253 | 2020-10-08 | New Haven | Connecticut | 9009 | 14830 | 1117 |
609254 | 609254 | 2020-10-08 | New London | Connecticut | 9011 | 2515 | 125 |
609255 | 609255 | 2020-10-08 | Tolland | Connecticut | 9013 | 1494 | 67 |
609256 | 609256 | 2020-10-08 | Unknown | Connecticut | 109 | 0 | |
609257 | 609257 | 2020-10-08 | Windham | Connecticut | 9015 | 1097 | 17 |
606006 | 606006 | 2020-10-07 | Fairfield | Connecticut | 9001 | 20612 | 1425 |
606007 | 606007 | 2020-10-07 | Hartford | Connecticut | 9003 | 15341 | 1440 |
606008 | 606008 | 2020-10-07 | Litchfield | Connecticut | 9005 | 1915 | 141 |
606009 | 606009 | 2020-10-07 | Middlesex | Connecticut | 9007 | 1635 | 193 |
606010 | 606010 | 2020-10-07 | New Haven | Connecticut | 9009 | 14749 | 1115 |
606011 | 606011 | 2020-10-07 | New London | Connecticut | 9011 | 2426 | 124 |
606012 | 606012 | 2020-10-07 | Tolland | Connecticut | 9013 | 1484 | 67 |
606013 | 606013 | 2020-10-07 | Unknown | Connecticut | 123 | 0 | |
606014 | 606014 | 2020-10-07 | Windham | Connecticut | 9015 | 1079 | 17 |
602764 | 602764 | 2020-10-06 | Fairfield | Connecticut | 9001 | 20587 | 1425 |
602765 | 602765 | 2020-10-06 | Hartford | Connecticut | 9003 | 15272 | 1440 |
602766 | 602766 | 2020-10-06 | Litchfield | Connecticut | 9005 | 1911 | 141 |
602767 | 602767 | 2020-10-06 | Middlesex | Connecticut | 9007 | 1631 | 193 |
602768 | 602768 | 2020-10-06 | New Haven | Connecticut | 9009 | 14722 | 1115 |
602769 | 602769 | 2020-10-06 | New London | Connecticut | 9011 | 2413 | 124 |
602770 | 602770 | 2020-10-06 | Tolland | Connecticut | 9013 | 1477 | 67 |
602771 | 602771 | 2020-10-06 | Unknown | Connecticut | 156 | 0 | |
602772 | 602772 | 2020-10-06 | Windham | Connecticut | 9015 | 1072 | 16 |
599521 | 599521 | 2020-10-05 | Fairfield | Connecticut | 9001 | 20587 | 1423 |
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);