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 311
- Litchfield 307
- Hartford 305
- New Haven 305
- Middlesex 301
- Tolland 300
- Windham 300
- New London 299
- Unknown 289
state 1
- Connecticut · 2,717 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920746 | 920746 | 2021-01-12 | Fairfield | Connecticut | 9001 | 64066 | 1806 |
920747 | 920747 | 2021-01-12 | Hartford | Connecticut | 9003 | 54900 | 1966 |
920748 | 920748 | 2021-01-12 | Litchfield | Connecticut | 9005 | 8631 | 241 |
920749 | 920749 | 2021-01-12 | Middlesex | Connecticut | 9007 | 7875 | 282 |
920750 | 920750 | 2021-01-12 | New Haven | Connecticut | 9009 | 54757 | 1653 |
920751 | 920751 | 2021-01-12 | New London | Connecticut | 9011 | 13492 | 284 |
920752 | 920752 | 2021-01-12 | Tolland | Connecticut | 9013 | 5791 | 120 |
920753 | 920753 | 2021-01-12 | Unknown | Connecticut | 803 | 2 | |
920754 | 920754 | 2021-01-12 | Windham | Connecticut | 9015 | 6732 | 95 |
917501 | 917501 | 2021-01-11 | Fairfield | Connecticut | 9001 | 63073 | 1797 |
917502 | 917502 | 2021-01-11 | Hartford | Connecticut | 9003 | 53892 | 1958 |
917503 | 917503 | 2021-01-11 | Litchfield | Connecticut | 9005 | 8496 | 239 |
917504 | 917504 | 2021-01-11 | Middlesex | Connecticut | 9007 | 7757 | 281 |
917505 | 917505 | 2021-01-11 | New Haven | Connecticut | 9009 | 53924 | 1648 |
917506 | 917506 | 2021-01-11 | New London | Connecticut | 9011 | 13160 | 282 |
917507 | 917507 | 2021-01-11 | Tolland | Connecticut | 9013 | 5689 | 118 |
917508 | 917508 | 2021-01-11 | Unknown | Connecticut | 779 | 1 | |
917509 | 917509 | 2021-01-11 | Windham | Connecticut | 9015 | 6588 | 92 |
914256 | 914256 | 2021-01-10 | Fairfield | Connecticut | 9001 | 61285 | 1779 |
914257 | 914257 | 2021-01-10 | Hartford | Connecticut | 9003 | 51890 | 1921 |
914258 | 914258 | 2021-01-10 | Litchfield | Connecticut | 9005 | 8239 | 239 |
914259 | 914259 | 2021-01-10 | Middlesex | Connecticut | 9007 | 7483 | 277 |
914260 | 914260 | 2021-01-10 | New Haven | Connecticut | 9009 | 52278 | 1627 |
914261 | 914261 | 2021-01-10 | New London | Connecticut | 9011 | 12434 | 276 |
914262 | 914262 | 2021-01-10 | Tolland | Connecticut | 9013 | 5443 | 115 |
914263 | 914263 | 2021-01-10 | Unknown | Connecticut | 770 | 1 | |
914264 | 914264 | 2021-01-10 | Windham | Connecticut | 9015 | 6172 | 89 |
911011 | 911011 | 2021-01-09 | Fairfield | Connecticut | 9001 | 61285 | 1779 |
911012 | 911012 | 2021-01-09 | Hartford | Connecticut | 9003 | 51890 | 1921 |
911013 | 911013 | 2021-01-09 | Litchfield | Connecticut | 9005 | 8239 | 239 |
911014 | 911014 | 2021-01-09 | Middlesex | Connecticut | 9007 | 7483 | 277 |
911015 | 911015 | 2021-01-09 | New Haven | Connecticut | 9009 | 52278 | 1627 |
911016 | 911016 | 2021-01-09 | New London | Connecticut | 9011 | 12434 | 276 |
911017 | 911017 | 2021-01-09 | Tolland | Connecticut | 9013 | 5443 | 115 |
911018 | 911018 | 2021-01-09 | Unknown | Connecticut | 770 | 1 | |
911019 | 911019 | 2021-01-09 | Windham | Connecticut | 9015 | 6172 | 89 |
907766 | 907766 | 2021-01-08 | Fairfield | Connecticut | 9001 | 61285 | 1779 |
907767 | 907767 | 2021-01-08 | Hartford | Connecticut | 9003 | 51890 | 1921 |
907768 | 907768 | 2021-01-08 | Litchfield | Connecticut | 9005 | 8239 | 239 |
907769 | 907769 | 2021-01-08 | Middlesex | Connecticut | 9007 | 7483 | 277 |
907770 | 907770 | 2021-01-08 | New Haven | Connecticut | 9009 | 52278 | 1627 |
907771 | 907771 | 2021-01-08 | New London | Connecticut | 9011 | 12434 | 276 |
907772 | 907772 | 2021-01-08 | Tolland | Connecticut | 9013 | 5443 | 115 |
907773 | 907773 | 2021-01-08 | Unknown | Connecticut | 770 | 1 | |
907774 | 907774 | 2021-01-08 | Windham | Connecticut | 9015 | 6172 | 89 |
904520 | 904520 | 2021-01-07 | Fairfield | Connecticut | 9001 | 60396 | 1772 |
904521 | 904521 | 2021-01-07 | Hartford | Connecticut | 9003 | 51050 | 1917 |
904522 | 904522 | 2021-01-07 | Litchfield | Connecticut | 9005 | 8117 | 235 |
904523 | 904523 | 2021-01-07 | Middlesex | Connecticut | 9007 | 7341 | 270 |
904524 | 904524 | 2021-01-07 | New Haven | Connecticut | 9009 | 51566 | 1615 |
904525 | 904525 | 2021-01-07 | New London | Connecticut | 9011 | 12164 | 275 |
904526 | 904526 | 2021-01-07 | Tolland | Connecticut | 9013 | 5365 | 114 |
904527 | 904527 | 2021-01-07 | Unknown | Connecticut | 755 | 1 | |
904528 | 904528 | 2021-01-07 | Windham | Connecticut | 9015 | 6004 | 88 |
901275 | 901275 | 2021-01-06 | Fairfield | Connecticut | 9001 | 59565 | 1763 |
901276 | 901276 | 2021-01-06 | Hartford | Connecticut | 9003 | 50223 | 1907 |
901277 | 901277 | 2021-01-06 | Litchfield | Connecticut | 9005 | 7977 | 235 |
901278 | 901278 | 2021-01-06 | Middlesex | Connecticut | 9007 | 7166 | 263 |
901279 | 901279 | 2021-01-06 | New Haven | Connecticut | 9009 | 50791 | 1595 |
901280 | 901280 | 2021-01-06 | New London | Connecticut | 9011 | 11873 | 267 |
901281 | 901281 | 2021-01-06 | Tolland | Connecticut | 9013 | 5292 | 114 |
901282 | 901282 | 2021-01-06 | Unknown | Connecticut | 723 | 0 | |
901283 | 901283 | 2021-01-06 | Windham | Connecticut | 9015 | 5844 | 86 |
898030 | 898030 | 2021-01-05 | Fairfield | Connecticut | 9001 | 58959 | 1755 |
898031 | 898031 | 2021-01-05 | Hartford | Connecticut | 9003 | 49560 | 1900 |
898032 | 898032 | 2021-01-05 | Litchfield | Connecticut | 9005 | 7885 | 232 |
898033 | 898033 | 2021-01-05 | Middlesex | Connecticut | 9007 | 7047 | 258 |
898034 | 898034 | 2021-01-05 | New Haven | Connecticut | 9009 | 50290 | 1584 |
898035 | 898035 | 2021-01-05 | New London | Connecticut | 9011 | 11616 | 264 |
898036 | 898036 | 2021-01-05 | Tolland | Connecticut | 9013 | 5225 | 113 |
898037 | 898037 | 2021-01-05 | Unknown | Connecticut | 710 | 0 | |
898038 | 898038 | 2021-01-05 | Windham | Connecticut | 9015 | 5676 | 86 |
894785 | 894785 | 2021-01-04 | Fairfield | Connecticut | 9001 | 58431 | 1750 |
894786 | 894786 | 2021-01-04 | Hartford | Connecticut | 9003 | 48913 | 1893 |
894787 | 894787 | 2021-01-04 | Litchfield | Connecticut | 9005 | 7826 | 232 |
894788 | 894788 | 2021-01-04 | Middlesex | Connecticut | 9007 | 6931 | 254 |
894789 | 894789 | 2021-01-04 | New Haven | Connecticut | 9009 | 49678 | 1578 |
894790 | 894790 | 2021-01-04 | New London | Connecticut | 9011 | 11440 | 263 |
894791 | 894791 | 2021-01-04 | Tolland | Connecticut | 9013 | 5159 | 112 |
894792 | 894792 | 2021-01-04 | Unknown | Connecticut | 703 | 0 | |
894793 | 894793 | 2021-01-04 | Windham | Connecticut | 9015 | 5555 | 86 |
891538 | 891538 | 2021-01-03 | Fairfield | Connecticut | 9001 | 57467 | 1740 |
891539 | 891539 | 2021-01-03 | Hartford | Connecticut | 9003 | 47726 | 1878 |
891540 | 891540 | 2021-01-03 | Litchfield | Connecticut | 9005 | 7645 | 229 |
891541 | 891541 | 2021-01-03 | Middlesex | Connecticut | 9007 | 6737 | 245 |
891542 | 891542 | 2021-01-03 | New Haven | Connecticut | 9009 | 48507 | 1559 |
891543 | 891543 | 2021-01-03 | New London | Connecticut | 9011 | 10981 | 254 |
891544 | 891544 | 2021-01-03 | Tolland | Connecticut | 9013 | 5033 | 111 |
891545 | 891545 | 2021-01-03 | Unknown | Connecticut | 684 | 0 | |
891546 | 891546 | 2021-01-03 | Windham | Connecticut | 9015 | 5340 | 83 |
888291 | 888291 | 2021-01-02 | Fairfield | Connecticut | 9001 | 57467 | 1740 |
888292 | 888292 | 2021-01-02 | Hartford | Connecticut | 9003 | 47726 | 1878 |
888293 | 888293 | 2021-01-02 | Litchfield | Connecticut | 9005 | 7645 | 229 |
888294 | 888294 | 2021-01-02 | Middlesex | Connecticut | 9007 | 6737 | 245 |
888295 | 888295 | 2021-01-02 | New Haven | Connecticut | 9009 | 48507 | 1559 |
888296 | 888296 | 2021-01-02 | New London | Connecticut | 9011 | 10981 | 254 |
888297 | 888297 | 2021-01-02 | Tolland | Connecticut | 9013 | 5033 | 111 |
888298 | 888298 | 2021-01-02 | Unknown | Connecticut | 684 | 0 | |
888299 | 888299 | 2021-01-02 | Windham | Connecticut | 9015 | 5340 | 83 |
885046 | 885046 | 2021-01-01 | Fairfield | Connecticut | 9001 | 56288 | 1720 |
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);