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 785
- Litchfield 782
- Hartford 780
- New Haven 780
- Middlesex 776
- Tolland 775
- Windham 775
- New London 774
- Unknown 764
state 1
- Connecticut · 6,991 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2464054 | 2464054 | 2022-05-02 | Hartford | Connecticut | 9003 | 182160 | 3135 |
2464055 | 2464055 | 2022-05-02 | Litchfield | Connecticut | 9005 | 32649 | 458 |
2464056 | 2464056 | 2022-05-02 | Middlesex | Connecticut | 9007 | 28996 | 480 |
2464057 | 2464057 | 2022-05-02 | New Haven | Connecticut | 9009 | 200763 | 2823 |
2464058 | 2464058 | 2022-05-02 | New London | Connecticut | 9011 | 56707 | 658 |
2464059 | 2464059 | 2022-05-02 | Tolland | Connecticut | 9013 | 21248 | 274 |
2464060 | 2464060 | 2022-05-02 | Unknown | Connecticut | 2291 | 2 | |
2464061 | 2464061 | 2022-05-02 | Windham | Connecticut | 9015 | 26157 | 303 |
2460797 | 2460797 | 2022-05-01 | Fairfield | Connecticut | 9001 | 208790 | 2717 |
2460798 | 2460798 | 2022-05-01 | Hartford | Connecticut | 9003 | 181772 | 3135 |
2460799 | 2460799 | 2022-05-01 | Litchfield | Connecticut | 9005 | 32588 | 458 |
2460800 | 2460800 | 2022-05-01 | Middlesex | Connecticut | 9007 | 28889 | 480 |
2460801 | 2460801 | 2022-05-01 | New Haven | Connecticut | 9009 | 200168 | 2823 |
2460802 | 2460802 | 2022-05-01 | New London | Connecticut | 9011 | 56500 | 658 |
2460803 | 2460803 | 2022-05-01 | Tolland | Connecticut | 9013 | 21198 | 274 |
2460804 | 2460804 | 2022-05-01 | Unknown | Connecticut | 2277 | 2 | |
2460805 | 2460805 | 2022-05-01 | Windham | Connecticut | 9015 | 26099 | 303 |
2457541 | 2457541 | 2022-04-30 | Fairfield | Connecticut | 9001 | 208790 | 2717 |
2457542 | 2457542 | 2022-04-30 | Hartford | Connecticut | 9003 | 181772 | 3135 |
2457543 | 2457543 | 2022-04-30 | Litchfield | Connecticut | 9005 | 32588 | 458 |
2457544 | 2457544 | 2022-04-30 | Middlesex | Connecticut | 9007 | 28889 | 480 |
2457545 | 2457545 | 2022-04-30 | New Haven | Connecticut | 9009 | 200168 | 2823 |
2457546 | 2457546 | 2022-04-30 | New London | Connecticut | 9011 | 56500 | 658 |
2457547 | 2457547 | 2022-04-30 | Tolland | Connecticut | 9013 | 21198 | 274 |
2457548 | 2457548 | 2022-04-30 | Unknown | Connecticut | 2277 | 2 | |
2457549 | 2457549 | 2022-04-30 | Windham | Connecticut | 9015 | 26099 | 303 |
2454285 | 2454285 | 2022-04-29 | Fairfield | Connecticut | 9001 | 208790 | 2717 |
2454286 | 2454286 | 2022-04-29 | Hartford | Connecticut | 9003 | 181772 | 3135 |
2454287 | 2454287 | 2022-04-29 | Litchfield | Connecticut | 9005 | 32588 | 458 |
2454288 | 2454288 | 2022-04-29 | Middlesex | Connecticut | 9007 | 28889 | 480 |
2454289 | 2454289 | 2022-04-29 | New Haven | Connecticut | 9009 | 200168 | 2823 |
2454290 | 2454290 | 2022-04-29 | New London | Connecticut | 9011 | 56500 | 658 |
2454291 | 2454291 | 2022-04-29 | Tolland | Connecticut | 9013 | 21198 | 274 |
2454292 | 2454292 | 2022-04-29 | Unknown | Connecticut | 2277 | 2 | |
2454293 | 2454293 | 2022-04-29 | Windham | Connecticut | 9015 | 26099 | 303 |
2451029 | 2451029 | 2022-04-28 | Fairfield | Connecticut | 9001 | 208537 | 2717 |
2451030 | 2451030 | 2022-04-28 | Hartford | Connecticut | 9003 | 181457 | 3131 |
2451031 | 2451031 | 2022-04-28 | Litchfield | Connecticut | 9005 | 32550 | 457 |
2451032 | 2451032 | 2022-04-28 | Middlesex | Connecticut | 9007 | 28846 | 480 |
2451033 | 2451033 | 2022-04-28 | New Haven | Connecticut | 9009 | 199932 | 2820 |
2451034 | 2451034 | 2022-04-28 | New London | Connecticut | 9011 | 56391 | 658 |
2451035 | 2451035 | 2022-04-28 | Tolland | Connecticut | 9013 | 21167 | 274 |
2451036 | 2451036 | 2022-04-28 | Unknown | Connecticut | 2275 | 1 | |
2451037 | 2451037 | 2022-04-28 | Windham | Connecticut | 9015 | 26072 | 302 |
2447773 | 2447773 | 2022-04-27 | Fairfield | Connecticut | 9001 | 208202 | 2716 |
2447774 | 2447774 | 2022-04-27 | Hartford | Connecticut | 9003 | 181188 | 3130 |
2447775 | 2447775 | 2022-04-27 | Litchfield | Connecticut | 9005 | 32485 | 457 |
2447776 | 2447776 | 2022-04-27 | Middlesex | Connecticut | 9007 | 28790 | 480 |
2447777 | 2447777 | 2022-04-27 | New Haven | Connecticut | 9009 | 199602 | 2820 |
2447778 | 2447778 | 2022-04-27 | New London | Connecticut | 9011 | 56268 | 658 |
2447779 | 2447779 | 2022-04-27 | Tolland | Connecticut | 9013 | 21127 | 274 |
2447780 | 2447780 | 2022-04-27 | Unknown | Connecticut | 2270 | 1 | |
2447781 | 2447781 | 2022-04-27 | Windham | Connecticut | 9015 | 26039 | 302 |
2444517 | 2444517 | 2022-04-26 | Fairfield | Connecticut | 9001 | 207943 | 2716 |
2444518 | 2444518 | 2022-04-26 | Hartford | Connecticut | 9003 | 180913 | 3130 |
2444519 | 2444519 | 2022-04-26 | Litchfield | Connecticut | 9005 | 32454 | 457 |
2444520 | 2444520 | 2022-04-26 | Middlesex | Connecticut | 9007 | 28737 | 480 |
2444521 | 2444521 | 2022-04-26 | New Haven | Connecticut | 9009 | 199354 | 2820 |
2444522 | 2444522 | 2022-04-26 | New London | Connecticut | 9011 | 56161 | 658 |
2444523 | 2444523 | 2022-04-26 | Tolland | Connecticut | 9013 | 21087 | 274 |
2444524 | 2444524 | 2022-04-26 | Unknown | Connecticut | 2266 | 1 | |
2444525 | 2444525 | 2022-04-26 | Windham | Connecticut | 9015 | 26009 | 302 |
2441261 | 2441261 | 2022-04-25 | Fairfield | Connecticut | 9001 | 207639 | 2714 |
2441262 | 2441262 | 2022-04-25 | Hartford | Connecticut | 9003 | 180627 | 3131 |
2441263 | 2441263 | 2022-04-25 | Litchfield | Connecticut | 9005 | 32425 | 457 |
2441264 | 2441264 | 2022-04-25 | Middlesex | Connecticut | 9007 | 28703 | 480 |
2441265 | 2441265 | 2022-04-25 | New Haven | Connecticut | 9009 | 199084 | 2818 |
2441266 | 2441266 | 2022-04-25 | New London | Connecticut | 9011 | 56071 | 657 |
2441267 | 2441267 | 2022-04-25 | Tolland | Connecticut | 9013 | 21051 | 274 |
2441268 | 2441268 | 2022-04-25 | Unknown | Connecticut | 2260 | 1 | |
2441269 | 2441269 | 2022-04-25 | Windham | Connecticut | 9015 | 25976 | 302 |
2438005 | 2438005 | 2022-04-24 | Fairfield | Connecticut | 9001 | 207102 | 2714 |
2438006 | 2438006 | 2022-04-24 | Hartford | Connecticut | 9003 | 180164 | 3131 |
2438007 | 2438007 | 2022-04-24 | Litchfield | Connecticut | 9005 | 32317 | 457 |
2438008 | 2438008 | 2022-04-24 | Middlesex | Connecticut | 9007 | 28587 | 480 |
2438009 | 2438009 | 2022-04-24 | New Haven | Connecticut | 9009 | 198601 | 2818 |
2438010 | 2438010 | 2022-04-24 | New London | Connecticut | 9011 | 55880 | 657 |
2438011 | 2438011 | 2022-04-24 | Tolland | Connecticut | 9013 | 20979 | 274 |
2438012 | 2438012 | 2022-04-24 | Unknown | Connecticut | 2246 | 1 | |
2438013 | 2438013 | 2022-04-24 | Windham | Connecticut | 9015 | 25934 | 302 |
2434749 | 2434749 | 2022-04-23 | Fairfield | Connecticut | 9001 | 207102 | 2714 |
2434750 | 2434750 | 2022-04-23 | Hartford | Connecticut | 9003 | 180164 | 3131 |
2434751 | 2434751 | 2022-04-23 | Litchfield | Connecticut | 9005 | 32317 | 457 |
2434752 | 2434752 | 2022-04-23 | Middlesex | Connecticut | 9007 | 28587 | 480 |
2434753 | 2434753 | 2022-04-23 | New Haven | Connecticut | 9009 | 198601 | 2818 |
2434754 | 2434754 | 2022-04-23 | New London | Connecticut | 9011 | 55880 | 657 |
2434755 | 2434755 | 2022-04-23 | Tolland | Connecticut | 9013 | 20979 | 274 |
2434756 | 2434756 | 2022-04-23 | Unknown | Connecticut | 2246 | 1 | |
2434757 | 2434757 | 2022-04-23 | Windham | Connecticut | 9015 | 25934 | 302 |
2431493 | 2431493 | 2022-04-22 | Fairfield | Connecticut | 9001 | 207102 | 2714 |
2431494 | 2431494 | 2022-04-22 | Hartford | Connecticut | 9003 | 180164 | 3131 |
2431495 | 2431495 | 2022-04-22 | Litchfield | Connecticut | 9005 | 32317 | 457 |
2431496 | 2431496 | 2022-04-22 | Middlesex | Connecticut | 9007 | 28587 | 480 |
2431497 | 2431497 | 2022-04-22 | New Haven | Connecticut | 9009 | 198601 | 2818 |
2431498 | 2431498 | 2022-04-22 | New London | Connecticut | 9011 | 55880 | 657 |
2431499 | 2431499 | 2022-04-22 | Tolland | Connecticut | 9013 | 20979 | 274 |
2431500 | 2431500 | 2022-04-22 | Unknown | Connecticut | 2246 | 1 | |
2431501 | 2431501 | 2022-04-22 | Windham | Connecticut | 9015 | 25934 | 302 |
2428237 | 2428237 | 2022-04-21 | Fairfield | Connecticut | 9001 | 206776 | 2711 |
2428238 | 2428238 | 2022-04-21 | Hartford | Connecticut | 9003 | 179841 | 3130 |
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);