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 352
- Litchfield 348
- Hartford 346
- New Haven 346
- Middlesex 342
- Tolland 341
- Windham 341
- New London 340
- Unknown 330
state 1
- Connecticut · 3,086 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053814 | 1053814 | 2021-02-22 | Fairfield | Connecticut | 9001 | 78803 | 2034 |
1053815 | 1053815 | 2021-02-22 | Hartford | Connecticut | 9003 | 69078 | 2258 |
1053816 | 1053816 | 2021-02-22 | Litchfield | Connecticut | 9005 | 10917 | 272 |
1053817 | 1053817 | 2021-02-22 | Middlesex | Connecticut | 9007 | 10212 | 340 |
1053818 | 1053818 | 2021-02-22 | New Haven | Connecticut | 9009 | 69832 | 1905 |
1053819 | 1053819 | 2021-02-22 | New London | Connecticut | 9011 | 18791 | 405 |
1053820 | 1053820 | 2021-02-22 | Tolland | Connecticut | 9013 | 7673 | 161 |
1053821 | 1053821 | 2021-02-22 | Unknown | Connecticut | 947 | 9 | |
1053822 | 1053822 | 2021-02-22 | Windham | Connecticut | 9015 | 9081 | 178 |
1050567 | 1050567 | 2021-02-21 | Fairfield | Connecticut | 9001 | 78181 | 2027 |
1050568 | 1050568 | 2021-02-21 | Hartford | Connecticut | 9003 | 68527 | 2251 |
1050569 | 1050569 | 2021-02-21 | Litchfield | Connecticut | 9005 | 10835 | 270 |
1050570 | 1050570 | 2021-02-21 | Middlesex | Connecticut | 9007 | 10113 | 337 |
1050571 | 1050571 | 2021-02-21 | New Haven | Connecticut | 9009 | 69233 | 1891 |
1050572 | 1050572 | 2021-02-21 | New London | Connecticut | 9011 | 18635 | 403 |
1050573 | 1050573 | 2021-02-21 | Tolland | Connecticut | 9013 | 7612 | 159 |
1050574 | 1050574 | 2021-02-21 | Unknown | Connecticut | 937 | 9 | |
1050575 | 1050575 | 2021-02-21 | Windham | Connecticut | 9015 | 9028 | 176 |
1047320 | 1047320 | 2021-02-20 | Fairfield | Connecticut | 9001 | 78181 | 2027 |
1047321 | 1047321 | 2021-02-20 | Hartford | Connecticut | 9003 | 68527 | 2251 |
1047322 | 1047322 | 2021-02-20 | Litchfield | Connecticut | 9005 | 10835 | 270 |
1047323 | 1047323 | 2021-02-20 | Middlesex | Connecticut | 9007 | 10113 | 337 |
1047324 | 1047324 | 2021-02-20 | New Haven | Connecticut | 9009 | 69233 | 1891 |
1047325 | 1047325 | 2021-02-20 | New London | Connecticut | 9011 | 18635 | 403 |
1047326 | 1047326 | 2021-02-20 | Tolland | Connecticut | 9013 | 7612 | 159 |
1047327 | 1047327 | 2021-02-20 | Unknown | Connecticut | 937 | 9 | |
1047328 | 1047328 | 2021-02-20 | Windham | Connecticut | 9015 | 9028 | 176 |
1044075 | 1044075 | 2021-02-19 | Fairfield | Connecticut | 9001 | 78181 | 2027 |
1044076 | 1044076 | 2021-02-19 | Hartford | Connecticut | 9003 | 68527 | 2251 |
1044077 | 1044077 | 2021-02-19 | Litchfield | Connecticut | 9005 | 10835 | 270 |
1044078 | 1044078 | 2021-02-19 | Middlesex | Connecticut | 9007 | 10113 | 337 |
1044079 | 1044079 | 2021-02-19 | New Haven | Connecticut | 9009 | 69233 | 1891 |
1044080 | 1044080 | 2021-02-19 | New London | Connecticut | 9011 | 18635 | 403 |
1044081 | 1044081 | 2021-02-19 | Tolland | Connecticut | 9013 | 7612 | 159 |
1044082 | 1044082 | 2021-02-19 | Unknown | Connecticut | 937 | 9 | |
1044083 | 1044083 | 2021-02-19 | Windham | Connecticut | 9015 | 9028 | 176 |
1040830 | 1040830 | 2021-02-18 | Fairfield | Connecticut | 9001 | 77794 | 2016 |
1040831 | 1040831 | 2021-02-18 | Hartford | Connecticut | 9003 | 68277 | 2246 |
1040832 | 1040832 | 2021-02-18 | Litchfield | Connecticut | 9005 | 10790 | 270 |
1040833 | 1040833 | 2021-02-18 | Middlesex | Connecticut | 9007 | 10047 | 336 |
1040834 | 1040834 | 2021-02-18 | New Haven | Connecticut | 9009 | 68953 | 1885 |
1040835 | 1040835 | 2021-02-18 | New London | Connecticut | 9011 | 18547 | 402 |
1040836 | 1040836 | 2021-02-18 | Tolland | Connecticut | 9013 | 7584 | 158 |
1040837 | 1040837 | 2021-02-18 | Unknown | Connecticut | 935 | 9 | |
1040838 | 1040838 | 2021-02-18 | Windham | Connecticut | 9015 | 8976 | 174 |
1037585 | 1037585 | 2021-02-17 | Fairfield | Connecticut | 9001 | 77597 | 2010 |
1037586 | 1037586 | 2021-02-17 | Hartford | Connecticut | 9003 | 68159 | 2240 |
1037587 | 1037587 | 2021-02-17 | Litchfield | Connecticut | 9005 | 10765 | 270 |
1037588 | 1037588 | 2021-02-17 | Middlesex | Connecticut | 9007 | 10044 | 335 |
1037589 | 1037589 | 2021-02-17 | New Haven | Connecticut | 9009 | 68795 | 1880 |
1037590 | 1037590 | 2021-02-17 | New London | Connecticut | 9011 | 18529 | 401 |
1037591 | 1037591 | 2021-02-17 | Tolland | Connecticut | 9013 | 7565 | 157 |
1037592 | 1037592 | 2021-02-17 | Unknown | Connecticut | 928 | 9 | |
1037593 | 1037593 | 2021-02-17 | Windham | Connecticut | 9015 | 8974 | 174 |
1034340 | 1034340 | 2021-02-16 | Fairfield | Connecticut | 9001 | 77457 | 2000 |
1034341 | 1034341 | 2021-02-16 | Hartford | Connecticut | 9003 | 68055 | 2236 |
1034342 | 1034342 | 2021-02-16 | Litchfield | Connecticut | 9005 | 10743 | 269 |
1034343 | 1034343 | 2021-02-16 | Middlesex | Connecticut | 9007 | 10034 | 335 |
1034344 | 1034344 | 2021-02-16 | New Haven | Connecticut | 9009 | 68593 | 1873 |
1034345 | 1034345 | 2021-02-16 | New London | Connecticut | 9011 | 18500 | 399 |
1034346 | 1034346 | 2021-02-16 | Tolland | Connecticut | 9013 | 7555 | 156 |
1034347 | 1034347 | 2021-02-16 | Unknown | Connecticut | 922 | 9 | |
1034348 | 1034348 | 2021-02-16 | Windham | Connecticut | 9015 | 8963 | 172 |
1031094 | 1031094 | 2021-02-15 | Fairfield | Connecticut | 9001 | 77266 | 1998 |
1031095 | 1031095 | 2021-02-15 | Hartford | Connecticut | 9003 | 67994 | 2236 |
1031096 | 1031096 | 2021-02-15 | Litchfield | Connecticut | 9005 | 10710 | 269 |
1031097 | 1031097 | 2021-02-15 | Middlesex | Connecticut | 9007 | 9998 | 334 |
1031098 | 1031098 | 2021-02-15 | New Haven | Connecticut | 9009 | 68437 | 1874 |
1031099 | 1031099 | 2021-02-15 | New London | Connecticut | 9011 | 18447 | 399 |
1031100 | 1031100 | 2021-02-15 | Tolland | Connecticut | 9013 | 7527 | 156 |
1031101 | 1031101 | 2021-02-15 | Unknown | Connecticut | 919 | 9 | |
1031102 | 1031102 | 2021-02-15 | Windham | Connecticut | 9015 | 8944 | 172 |
1027847 | 1027847 | 2021-02-14 | Fairfield | Connecticut | 9001 | 76511 | 1986 |
1027848 | 1027848 | 2021-02-14 | Hartford | Connecticut | 9003 | 67328 | 2223 |
1027849 | 1027849 | 2021-02-14 | Litchfield | Connecticut | 9005 | 10604 | 267 |
1027850 | 1027850 | 2021-02-14 | Middlesex | Connecticut | 9007 | 9868 | 332 |
1027851 | 1027851 | 2021-02-14 | New Haven | Connecticut | 9009 | 67586 | 1859 |
1027852 | 1027852 | 2021-02-14 | New London | Connecticut | 9011 | 18226 | 391 |
1027853 | 1027853 | 2021-02-14 | Tolland | Connecticut | 9013 | 7445 | 151 |
1027854 | 1027854 | 2021-02-14 | Unknown | Connecticut | 904 | 8 | |
1027855 | 1027855 | 2021-02-14 | Windham | Connecticut | 9015 | 8865 | 164 |
1024602 | 1024602 | 2021-02-13 | Fairfield | Connecticut | 9001 | 76511 | 1986 |
1024603 | 1024603 | 2021-02-13 | Hartford | Connecticut | 9003 | 67328 | 2223 |
1024604 | 1024604 | 2021-02-13 | Litchfield | Connecticut | 9005 | 10604 | 267 |
1024605 | 1024605 | 2021-02-13 | Middlesex | Connecticut | 9007 | 9868 | 332 |
1024606 | 1024606 | 2021-02-13 | New Haven | Connecticut | 9009 | 67586 | 1859 |
1024607 | 1024607 | 2021-02-13 | New London | Connecticut | 9011 | 18226 | 391 |
1024608 | 1024608 | 2021-02-13 | Tolland | Connecticut | 9013 | 7445 | 151 |
1024609 | 1024609 | 2021-02-13 | Unknown | Connecticut | 904 | 8 | |
1024610 | 1024610 | 2021-02-13 | Windham | Connecticut | 9015 | 8865 | 164 |
1021357 | 1021357 | 2021-02-12 | Fairfield | Connecticut | 9001 | 76511 | 1986 |
1021358 | 1021358 | 2021-02-12 | Hartford | Connecticut | 9003 | 67328 | 2223 |
1021359 | 1021359 | 2021-02-12 | Litchfield | Connecticut | 9005 | 10604 | 267 |
1021360 | 1021360 | 2021-02-12 | Middlesex | Connecticut | 9007 | 9868 | 332 |
1021361 | 1021361 | 2021-02-12 | New Haven | Connecticut | 9009 | 67586 | 1859 |
1021362 | 1021362 | 2021-02-12 | New London | Connecticut | 9011 | 18226 | 391 |
1021363 | 1021363 | 2021-02-12 | Tolland | Connecticut | 9013 | 7445 | 151 |
1021364 | 1021364 | 2021-02-12 | Unknown | Connecticut | 904 | 8 | |
1021365 | 1021365 | 2021-02-12 | Windham | Connecticut | 9015 | 8865 | 164 |
1018112 | 1018112 | 2021-02-11 | Fairfield | Connecticut | 9001 | 76266 | 1982 |
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);