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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 9
- Fairfield 797
- Litchfield 793
- Hartford 791
- New Haven 791
- Middlesex 787
- Tolland 786
- Windham 786
- New London 785
- Unknown 775
state 1
- Connecticut · 7,091 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
778 | 778 | 2020-03-08 | Fairfield | Connecticut | 9001 | 1 | 0 |
895 | 895 | 2020-03-09 | Fairfield | Connecticut | 9001 | 2 | 0 |
1030 | 1030 | 2020-03-10 | Fairfield | Connecticut | 9001 | 2 | 0 |
1198 | 1198 | 2020-03-11 | Fairfield | Connecticut | 9001 | 3 | 0 |
1406 | 1406 | 2020-03-12 | Fairfield | Connecticut | 9001 | 5 | 0 |
1672 | 1672 | 2020-03-13 | Fairfield | Connecticut | 9001 | 8 | 0 |
1992 | 1992 | 2020-03-14 | Fairfield | Connecticut | 9001 | 15 | 0 |
2374 | 2374 | 2020-03-15 | Fairfield | Connecticut | 9001 | 16 | 0 |
2809 | 2809 | 2020-03-16 | Fairfield | Connecticut | 9001 | 29 | 0 |
3291 | 3291 | 2020-03-17 | Fairfield | Connecticut | 9001 | 48 | 0 |
3846 | 3846 | 2020-03-18 | Fairfield | Connecticut | 9001 | 69 | 1 |
4509 | 4509 | 2020-03-19 | Fairfield | Connecticut | 9001 | 102 | 4 |
5287 | 5287 | 2020-03-20 | Fairfield | Connecticut | 9001 | 122 | 4 |
6214 | 6214 | 2020-03-21 | Fairfield | Connecticut | 9001 | 140 | 4 |
7250 | 7250 | 2020-03-22 | Fairfield | Connecticut | 9001 | 208 | 5 |
8396 | 8396 | 2020-03-23 | Fairfield | Connecticut | 9001 | 270 | 6 |
9641 | 9641 | 2020-03-24 | Fairfield | Connecticut | 9001 | 384 | 7 |
11015 | 11015 | 2020-03-25 | Fairfield | Connecticut | 9001 | 546 | 12 |
12563 | 12563 | 2020-03-26 | Fairfield | Connecticut | 9001 | 607 | 13 |
14232 | 14232 | 2020-03-27 | Fairfield | Connecticut | 9001 | 752 | 15 |
16016 | 16016 | 2020-03-28 | Fairfield | Connecticut | 9001 | 908 | 20 |
17908 | 17908 | 2020-03-29 | Fairfield | Connecticut | 9001 | 1245 | 21 |
19887 | 19887 | 2020-03-30 | Fairfield | Connecticut | 9001 | 1445 | 21 |
21964 | 21964 | 2020-03-31 | Fairfield | Connecticut | 9001 | 1870 | 38 |
24123 | 24123 | 2020-04-01 | Fairfield | Connecticut | 9001 | 1986 | 46 |
26353 | 26353 | 2020-04-02 | Fairfield | Connecticut | 9001 | 2132 | 65 |
28655 | 28655 | 2020-04-03 | Fairfield | Connecticut | 9001 | 2717 | 76 |
31013 | 31013 | 2020-04-04 | Fairfield | Connecticut | 9001 | 2824 | 86 |
33419 | 33419 | 2020-04-05 | Fairfield | Connecticut | 9001 | 3050 | 96 |
35864 | 35864 | 2020-04-06 | Fairfield | Connecticut | 9001 | 3719 | 101 |
38354 | 38354 | 2020-04-07 | Fairfield | Connecticut | 9001 | 4136 | 132 |
40897 | 40897 | 2020-04-08 | Fairfield | Connecticut | 9001 | 4417 | 155 |
43471 | 43471 | 2020-04-09 | Fairfield | Connecticut | 9001 | 4882 | 178 |
46071 | 46071 | 2020-04-10 | Fairfield | Connecticut | 9001 | 5180 | 203 |
48701 | 48701 | 2020-04-11 | Fairfield | Connecticut | 9001 | 5407 | 220 |
51363 | 51363 | 2020-04-12 | Fairfield | Connecticut | 9001 | 5534 | 248 |
54042 | 54042 | 2020-04-13 | Fairfield | Connecticut | 9001 | 6004 | 262 |
56734 | 56734 | 2020-04-14 | Fairfield | Connecticut | 9001 | 6213 | 287 |
59442 | 59442 | 2020-04-15 | Fairfield | Connecticut | 9001 | 6480 | 365 |
62161 | 62161 | 2020-04-16 | Fairfield | Connecticut | 9001 | 6816 | 406 |
64894 | 64894 | 2020-04-17 | Fairfield | Connecticut | 9001 | 7146 | 425 |
67642 | 67642 | 2020-04-18 | Fairfield | Connecticut | 9001 | 7363 | 432 |
70404 | 70404 | 2020-04-19 | Fairfield | Connecticut | 9001 | 7434 | 447 |
73173 | 73173 | 2020-04-20 | Fairfield | Connecticut | 9001 | 8320 | 512 |
75949 | 75949 | 2020-04-21 | Fairfield | Connecticut | 9001 | 8472 | 544 |
78733 | 78733 | 2020-04-22 | Fairfield | Connecticut | 9001 | 9883 | 584 |
81527 | 81527 | 2020-04-23 | Fairfield | Connecticut | 9001 | 10008 | 615 |
84327 | 84327 | 2020-04-24 | Fairfield | Connecticut | 9001 | 10227 | 662 |
87135 | 87135 | 2020-04-25 | Fairfield | Connecticut | 9001 | 10373 | 689 |
89952 | 89952 | 2020-04-26 | Fairfield | Connecticut | 9001 | 10529 | 707 |
92770 | 92770 | 2020-04-27 | Fairfield | Connecticut | 9001 | 10763 | 727 |
95602 | 95602 | 2020-04-28 | Fairfield | Connecticut | 9001 | 10874 | 747 |
98447 | 98447 | 2020-04-29 | Fairfield | Connecticut | 9001 | 10985 | 774 |
101297 | 101297 | 2020-04-30 | Fairfield | Connecticut | 9001 | 11294 | 810 |
104152 | 104152 | 2020-05-01 | Fairfield | Connecticut | 9001 | 11612 | 839 |
107017 | 107017 | 2020-05-02 | Fairfield | Connecticut | 9001 | 11801 | 865 |
109886 | 109886 | 2020-05-03 | Fairfield | Connecticut | 9001 | 11801 | 865 |
112761 | 112761 | 2020-05-04 | Fairfield | Connecticut | 9001 | 12245 | 910 |
115644 | 115644 | 2020-05-05 | Fairfield | Connecticut | 9001 | 12360 | 935 |
118604 | 118604 | 2020-05-06 | Fairfield | Connecticut | 9001 | 12455 | 952 |
121573 | 121573 | 2020-05-07 | Fairfield | Connecticut | 9001 | 12679 | 977 |
124553 | 124553 | 2020-05-08 | Fairfield | Connecticut | 9001 | 12879 | 1006 |
127539 | 127539 | 2020-05-09 | Fairfield | Connecticut | 9001 | 13030 | 1017 |
130530 | 130530 | 2020-05-10 | Fairfield | Connecticut | 9001 | 13236 | 1024 |
133521 | 133521 | 2020-05-11 | Fairfield | Connecticut | 9001 | 13312 | 1034 |
136510 | 136510 | 2020-05-12 | Fairfield | Connecticut | 9001 | 13488 | 1046 |
139501 | 139501 | 2020-05-13 | Fairfield | Connecticut | 9001 | 13636 | 1068 |
142497 | 142497 | 2020-05-14 | Fairfield | Connecticut | 9001 | 13836 | 1093 |
145497 | 145497 | 2020-05-15 | Fairfield | Connecticut | 9001 | 14009 | 1109 |
148500 | 148500 | 2020-05-16 | Fairfield | Connecticut | 9001 | 14140 | 1125 |
151509 | 151509 | 2020-05-17 | Fairfield | Connecticut | 9001 | 14248 | 1146 |
154521 | 154521 | 2020-05-18 | Fairfield | Connecticut | 9001 | 14439 | 1153 |
157537 | 157537 | 2020-05-19 | Fairfield | Connecticut | 9001 | 14522 | 1160 |
160563 | 160563 | 2020-05-20 | Fairfield | Connecticut | 9001 | 14719 | 1167 |
163591 | 163591 | 2020-05-21 | Fairfield | Connecticut | 9001 | 14751 | 1180 |
166624 | 166624 | 2020-05-22 | Fairfield | Connecticut | 9001 | 14889 | 1195 |
169661 | 169661 | 2020-05-23 | Fairfield | Connecticut | 9001 | 14989 | 1208 |
172702 | 172702 | 2020-05-24 | Fairfield | Connecticut | 9001 | 15114 | 1215 |
175745 | 175745 | 2020-05-25 | Fairfield | Connecticut | 9001 | 15213 | 1221 |
178789 | 178789 | 2020-05-26 | Fairfield | Connecticut | 9001 | 15355 | 1231 |
181833 | 181833 | 2020-05-27 | Fairfield | Connecticut | 9001 | 15314 | 1242 |
184887 | 184887 | 2020-05-28 | Fairfield | Connecticut | 9001 | 15353 | 1246 |
187943 | 187943 | 2020-05-29 | Fairfield | Connecticut | 9001 | 15409 | 1257 |
191008 | 191008 | 2020-05-30 | Fairfield | Connecticut | 9001 | 15502 | 1267 |
194075 | 194075 | 2020-05-31 | Fairfield | Connecticut | 9001 | 15549 | 1277 |
197145 | 197145 | 2020-06-01 | Fairfield | Connecticut | 9001 | 15709 | 1288 |
200218 | 200218 | 2020-06-02 | Fairfield | Connecticut | 9001 | 15776 | 1287 |
203294 | 203294 | 2020-06-03 | Fairfield | Connecticut | 9001 | 15789 | 1289 |
206374 | 206374 | 2020-06-04 | Fairfield | Connecticut | 9001 | 15843 | 1293 |
209455 | 209455 | 2020-06-05 | Fairfield | Connecticut | 9001 | 15914 | 1304 |
212540 | 212540 | 2020-06-06 | Fairfield | Connecticut | 9001 | 16020 | 1309 |
215627 | 215627 | 2020-06-07 | Fairfield | Connecticut | 9001 | 16056 | 1312 |
218718 | 218718 | 2020-06-08 | Fairfield | Connecticut | 9001 | 16092 | 1316 |
221813 | 221813 | 2020-06-09 | Fairfield | Connecticut | 9001 | 16108 | 1319 |
224908 | 224908 | 2020-06-10 | Fairfield | Connecticut | 9001 | 16134 | 1321 |
228010 | 228010 | 2020-06-11 | Fairfield | Connecticut | 9001 | 16155 | 1333 |
231113 | 231113 | 2020-06-12 | Fairfield | Connecticut | 9001 | 16178 | 1337 |
234219 | 234219 | 2020-06-13 | Fairfield | Connecticut | 9001 | 16277 | 1345 |
237326 | 237326 | 2020-06-14 | Fairfield | Connecticut | 9001 | 16306 | 1346 |
240434 | 240434 | 2020-06-15 | Fairfield | Connecticut | 9001 | 16338 | 1347 |
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);