ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 9015 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4515 | 4515 | 2020-03-19 | Windham | Connecticut | 9015 | 1 | 0 |
5294 | 5294 | 2020-03-20 | Windham | Connecticut | 9015 | 1 | 0 |
6221 | 6221 | 2020-03-21 | Windham | Connecticut | 9015 | 1 | 0 |
7257 | 7257 | 2020-03-22 | Windham | Connecticut | 9015 | 1 | 0 |
8403 | 8403 | 2020-03-23 | Windham | Connecticut | 9015 | 2 | 0 |
9648 | 9648 | 2020-03-24 | Windham | Connecticut | 9015 | 2 | 0 |
11022 | 11022 | 2020-03-25 | Windham | Connecticut | 9015 | 2 | 0 |
12570 | 12570 | 2020-03-26 | Windham | Connecticut | 9015 | 3 | 0 |
14239 | 14239 | 2020-03-27 | Windham | Connecticut | 9015 | 3 | 0 |
16023 | 16023 | 2020-03-28 | Windham | Connecticut | 9015 | 3 | 0 |
17915 | 17915 | 2020-03-29 | Windham | Connecticut | 9015 | 7 | 0 |
19895 | 19895 | 2020-03-30 | Windham | Connecticut | 9015 | 10 | 0 |
21972 | 21972 | 2020-03-31 | Windham | Connecticut | 9015 | 11 | 0 |
24131 | 24131 | 2020-04-01 | Windham | Connecticut | 9015 | 19 | 0 |
26361 | 26361 | 2020-04-02 | Windham | Connecticut | 9015 | 21 | 0 |
28663 | 28663 | 2020-04-03 | Windham | Connecticut | 9015 | 27 | 0 |
31021 | 31021 | 2020-04-04 | Windham | Connecticut | 9015 | 31 | 1 |
33427 | 33427 | 2020-04-05 | Windham | Connecticut | 9015 | 32 | 1 |
35872 | 35872 | 2020-04-06 | Windham | Connecticut | 9015 | 40 | 1 |
38362 | 38362 | 2020-04-07 | Windham | Connecticut | 9015 | 43 | 1 |
40905 | 40905 | 2020-04-08 | Windham | Connecticut | 9015 | 49 | 1 |
43479 | 43479 | 2020-04-09 | Windham | Connecticut | 9015 | 52 | 1 |
46079 | 46079 | 2020-04-10 | Windham | Connecticut | 9015 | 59 | 1 |
48709 | 48709 | 2020-04-11 | Windham | Connecticut | 9015 | 66 | 1 |
51371 | 51371 | 2020-04-12 | Windham | Connecticut | 9015 | 66 | 1 |
54050 | 54050 | 2020-04-13 | Windham | Connecticut | 9015 | 83 | 1 |
56742 | 56742 | 2020-04-14 | Windham | Connecticut | 9015 | 87 | 1 |
59450 | 59450 | 2020-04-15 | Windham | Connecticut | 9015 | 89 | 1 |
62169 | 62169 | 2020-04-16 | Windham | Connecticut | 9015 | 87 | 1 |
64902 | 64902 | 2020-04-17 | Windham | Connecticut | 9015 | 92 | 2 |
67650 | 67650 | 2020-04-18 | Windham | Connecticut | 9015 | 97 | 2 |
70412 | 70412 | 2020-04-19 | Windham | Connecticut | 9015 | 100 | 2 |
73181 | 73181 | 2020-04-20 | Windham | Connecticut | 9015 | 108 | 2 |
75957 | 75957 | 2020-04-21 | Windham | Connecticut | 9015 | 112 | 2 |
78741 | 78741 | 2020-04-22 | Windham | Connecticut | 9015 | 122 | 4 |
81535 | 81535 | 2020-04-23 | Windham | Connecticut | 9015 | 129 | 4 |
84335 | 84335 | 2020-04-24 | Windham | Connecticut | 9015 | 139 | 4 |
87143 | 87143 | 2020-04-25 | Windham | Connecticut | 9015 | 151 | 4 |
89960 | 89960 | 2020-04-26 | Windham | Connecticut | 9015 | 157 | 4 |
92778 | 92778 | 2020-04-27 | Windham | Connecticut | 9015 | 164 | 4 |
95610 | 95610 | 2020-04-28 | Windham | Connecticut | 9015 | 164 | 4 |
98455 | 98455 | 2020-04-29 | Windham | Connecticut | 9015 | 165 | 4 |
101305 | 101305 | 2020-04-30 | Windham | Connecticut | 9015 | 186 | 4 |
104160 | 104160 | 2020-05-01 | Windham | Connecticut | 9015 | 200 | 2 |
107025 | 107025 | 2020-05-02 | Windham | Connecticut | 9015 | 211 | 2 |
109894 | 109894 | 2020-05-03 | Windham | Connecticut | 9015 | 211 | 2 |
112769 | 112769 | 2020-05-04 | Windham | Connecticut | 9015 | 217 | 3 |
115652 | 115652 | 2020-05-05 | Windham | Connecticut | 9015 | 223 | 4 |
118612 | 118612 | 2020-05-06 | Windham | Connecticut | 9015 | 242 | 4 |
121581 | 121581 | 2020-05-07 | Windham | Connecticut | 9015 | 250 | 5 |
124561 | 124561 | 2020-05-08 | Windham | Connecticut | 9015 | 249 | 5 |
127547 | 127547 | 2020-05-09 | Windham | Connecticut | 9015 | 266 | 6 |
130538 | 130538 | 2020-05-10 | Windham | Connecticut | 9015 | 270 | 7 |
133529 | 133529 | 2020-05-11 | Windham | Connecticut | 9015 | 271 | 7 |
136518 | 136518 | 2020-05-12 | Windham | Connecticut | 9015 | 281 | 7 |
139509 | 139509 | 2020-05-13 | Windham | Connecticut | 9015 | 287 | 9 |
142505 | 142505 | 2020-05-14 | Windham | Connecticut | 9015 | 291 | 11 |
145505 | 145505 | 2020-05-15 | Windham | Connecticut | 9015 | 301 | 12 |
148508 | 148508 | 2020-05-16 | Windham | Connecticut | 9015 | 304 | 12 |
151517 | 151517 | 2020-05-17 | Windham | Connecticut | 9015 | 313 | 14 |
154529 | 154529 | 2020-05-18 | Windham | Connecticut | 9015 | 322 | 14 |
157545 | 157545 | 2020-05-19 | Windham | Connecticut | 9015 | 326 | 14 |
160571 | 160571 | 2020-05-20 | Windham | Connecticut | 9015 | 329 | 14 |
163599 | 163599 | 2020-05-21 | Windham | Connecticut | 9015 | 336 | 14 |
166632 | 166632 | 2020-05-22 | Windham | Connecticut | 9015 | 348 | 14 |
169669 | 169669 | 2020-05-23 | Windham | Connecticut | 9015 | 354 | 14 |
172710 | 172710 | 2020-05-24 | Windham | Connecticut | 9015 | 359 | 14 |
175753 | 175753 | 2020-05-25 | Windham | Connecticut | 9015 | 365 | 14 |
178797 | 178797 | 2020-05-26 | Windham | Connecticut | 9015 | 371 | 14 |
181841 | 181841 | 2020-05-27 | Windham | Connecticut | 9015 | 371 | 14 |
184895 | 184895 | 2020-05-28 | Windham | Connecticut | 9015 | 375 | 14 |
187951 | 187951 | 2020-05-29 | Windham | Connecticut | 9015 | 380 | 14 |
191016 | 191016 | 2020-05-30 | Windham | Connecticut | 9015 | 381 | 14 |
194083 | 194083 | 2020-05-31 | Windham | Connecticut | 9015 | 384 | 14 |
197153 | 197153 | 2020-06-01 | Windham | Connecticut | 9015 | 388 | 13 |
200226 | 200226 | 2020-06-02 | Windham | Connecticut | 9015 | 393 | 14 |
203302 | 203302 | 2020-06-03 | Windham | Connecticut | 9015 | 392 | 14 |
206382 | 206382 | 2020-06-04 | Windham | Connecticut | 9015 | 397 | 14 |
209463 | 209463 | 2020-06-05 | Windham | Connecticut | 9015 | 405 | 14 |
212548 | 212548 | 2020-06-06 | Windham | Connecticut | 9015 | 416 | 14 |
215635 | 215635 | 2020-06-07 | Windham | Connecticut | 9015 | 420 | 14 |
218726 | 218726 | 2020-06-08 | Windham | Connecticut | 9015 | 428 | 14 |
221821 | 221821 | 2020-06-09 | Windham | Connecticut | 9015 | 430 | 15 |
224916 | 224916 | 2020-06-10 | Windham | Connecticut | 9015 | 437 | 14 |
228018 | 228018 | 2020-06-11 | Windham | Connecticut | 9015 | 441 | 14 |
231121 | 231121 | 2020-06-12 | Windham | Connecticut | 9015 | 453 | 14 |
234227 | 234227 | 2020-06-13 | Windham | Connecticut | 9015 | 463 | 14 |
237334 | 237334 | 2020-06-14 | Windham | Connecticut | 9015 | 465 | 14 |
240442 | 240442 | 2020-06-15 | Windham | Connecticut | 9015 | 467 | 14 |
243553 | 243553 | 2020-06-16 | Windham | Connecticut | 9015 | 469 | 14 |
246666 | 246666 | 2020-06-17 | Windham | Connecticut | 9015 | 471 | 14 |
249778 | 249778 | 2020-06-18 | Windham | Connecticut | 9015 | 472 | 14 |
252893 | 252893 | 2020-06-19 | Windham | Connecticut | 9015 | 567 | 14 |
256012 | 256012 | 2020-06-20 | Windham | Connecticut | 9015 | 575 | 14 |
259139 | 259139 | 2020-06-21 | Windham | Connecticut | 9015 | 579 | 14 |
262266 | 262266 | 2020-06-22 | Windham | Connecticut | 9015 | 584 | 14 |
265394 | 265394 | 2020-06-23 | Windham | Connecticut | 9015 | 587 | 14 |
268524 | 268524 | 2020-06-24 | Windham | Connecticut | 9015 | 588 | 14 |
271660 | 271660 | 2020-06-25 | Windham | Connecticut | 9015 | 595 | 14 |
274800 | 274800 | 2020-06-26 | Windham | Connecticut | 9015 | 598 | 14 |
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);