ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 9013 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4514 | 4514 | 2020-03-19 | Tolland | Connecticut | 9013 | 4 | 0 |
5293 | 5293 | 2020-03-20 | Tolland | Connecticut | 9013 | 4 | 0 |
6220 | 6220 | 2020-03-21 | Tolland | Connecticut | 9013 | 5 | 1 |
7256 | 7256 | 2020-03-22 | Tolland | Connecticut | 9013 | 14 | 2 |
8402 | 8402 | 2020-03-23 | Tolland | Connecticut | 9013 | 16 | 2 |
9647 | 9647 | 2020-03-24 | Tolland | Connecticut | 9013 | 19 | 3 |
11021 | 11021 | 2020-03-25 | Tolland | Connecticut | 9013 | 27 | 3 |
12569 | 12569 | 2020-03-26 | Tolland | Connecticut | 9013 | 33 | 3 |
14238 | 14238 | 2020-03-27 | Tolland | Connecticut | 9013 | 33 | 3 |
16022 | 16022 | 2020-03-28 | Tolland | Connecticut | 9013 | 37 | 4 |
17914 | 17914 | 2020-03-29 | Tolland | Connecticut | 9013 | 40 | 4 |
19893 | 19893 | 2020-03-30 | Tolland | Connecticut | 9013 | 50 | 4 |
21970 | 21970 | 2020-03-31 | Tolland | Connecticut | 9013 | 56 | 7 |
24129 | 24129 | 2020-04-01 | Tolland | Connecticut | 9013 | 61 | 7 |
26359 | 26359 | 2020-04-02 | Tolland | Connecticut | 9013 | 67 | 10 |
28661 | 28661 | 2020-04-03 | Tolland | Connecticut | 9013 | 79 | 10 |
31019 | 31019 | 2020-04-04 | Tolland | Connecticut | 9013 | 91 | 10 |
33425 | 33425 | 2020-04-05 | Tolland | Connecticut | 9013 | 94 | 11 |
35870 | 35870 | 2020-04-06 | Tolland | Connecticut | 9013 | 103 | 13 |
38360 | 38360 | 2020-04-07 | Tolland | Connecticut | 9013 | 111 | 13 |
40903 | 40903 | 2020-04-08 | Tolland | Connecticut | 9013 | 128 | 13 |
43477 | 43477 | 2020-04-09 | Tolland | Connecticut | 9013 | 145 | 13 |
46077 | 46077 | 2020-04-10 | Tolland | Connecticut | 9013 | 152 | 14 |
48707 | 48707 | 2020-04-11 | Tolland | Connecticut | 9013 | 171 | 15 |
51369 | 51369 | 2020-04-12 | Tolland | Connecticut | 9013 | 182 | 17 |
54048 | 54048 | 2020-04-13 | Tolland | Connecticut | 9013 | 195 | 17 |
56740 | 56740 | 2020-04-14 | Tolland | Connecticut | 9013 | 201 | 18 |
59448 | 59448 | 2020-04-15 | Tolland | Connecticut | 9013 | 216 | 22 |
62167 | 62167 | 2020-04-16 | Tolland | Connecticut | 9013 | 241 | 22 |
64900 | 64900 | 2020-04-17 | Tolland | Connecticut | 9013 | 258 | 24 |
67648 | 67648 | 2020-04-18 | Tolland | Connecticut | 9013 | 270 | 24 |
70410 | 70410 | 2020-04-19 | Tolland | Connecticut | 9013 | 276 | 24 |
73179 | 73179 | 2020-04-20 | Tolland | Connecticut | 9013 | 299 | 27 |
75955 | 75955 | 2020-04-21 | Tolland | Connecticut | 9013 | 305 | 30 |
78739 | 78739 | 2020-04-22 | Tolland | Connecticut | 9013 | 331 | 32 |
81533 | 81533 | 2020-04-23 | Tolland | Connecticut | 9013 | 359 | 33 |
84333 | 84333 | 2020-04-24 | Tolland | Connecticut | 9013 | 375 | 34 |
87141 | 87141 | 2020-04-25 | Tolland | Connecticut | 9013 | 384 | 35 |
89958 | 89958 | 2020-04-26 | Tolland | Connecticut | 9013 | 407 | 35 |
92776 | 92776 | 2020-04-27 | Tolland | Connecticut | 9013 | 419 | 35 |
95608 | 95608 | 2020-04-28 | Tolland | Connecticut | 9013 | 422 | 35 |
98453 | 98453 | 2020-04-29 | Tolland | Connecticut | 9013 | 427 | 36 |
101303 | 101303 | 2020-04-30 | Tolland | Connecticut | 9013 | 437 | 36 |
104158 | 104158 | 2020-05-01 | Tolland | Connecticut | 9013 | 446 | 38 |
107023 | 107023 | 2020-05-02 | Tolland | Connecticut | 9013 | 461 | 39 |
109892 | 109892 | 2020-05-03 | Tolland | Connecticut | 9013 | 461 | 39 |
112767 | 112767 | 2020-05-04 | Tolland | Connecticut | 9013 | 464 | 40 |
115650 | 115650 | 2020-05-05 | Tolland | Connecticut | 9013 | 502 | 43 |
118610 | 118610 | 2020-05-06 | Tolland | Connecticut | 9013 | 513 | 44 |
121579 | 121579 | 2020-05-07 | Tolland | Connecticut | 9013 | 522 | 46 |
124559 | 124559 | 2020-05-08 | Tolland | Connecticut | 9013 | 530 | 46 |
127545 | 127545 | 2020-05-09 | Tolland | Connecticut | 9013 | 540 | 46 |
130536 | 130536 | 2020-05-10 | Tolland | Connecticut | 9013 | 543 | 47 |
133527 | 133527 | 2020-05-11 | Tolland | Connecticut | 9013 | 545 | 47 |
136516 | 136516 | 2020-05-12 | Tolland | Connecticut | 9013 | 556 | 47 |
139507 | 139507 | 2020-05-13 | Tolland | Connecticut | 9013 | 560 | 49 |
142503 | 142503 | 2020-05-14 | Tolland | Connecticut | 9013 | 568 | 51 |
145503 | 145503 | 2020-05-15 | Tolland | Connecticut | 9013 | 583 | 51 |
148506 | 148506 | 2020-05-16 | Tolland | Connecticut | 9013 | 636 | 51 |
151515 | 151515 | 2020-05-17 | Tolland | Connecticut | 9013 | 715 | 54 |
154527 | 154527 | 2020-05-18 | Tolland | Connecticut | 9013 | 735 | 54 |
157543 | 157543 | 2020-05-19 | Tolland | Connecticut | 9013 | 770 | 54 |
160569 | 160569 | 2020-05-20 | Tolland | Connecticut | 9013 | 786 | 55 |
163597 | 163597 | 2020-05-21 | Tolland | Connecticut | 9013 | 787 | 55 |
166630 | 166630 | 2020-05-22 | Tolland | Connecticut | 9013 | 796 | 55 |
169667 | 169667 | 2020-05-23 | Tolland | Connecticut | 9013 | 799 | 55 |
172708 | 172708 | 2020-05-24 | Tolland | Connecticut | 9013 | 807 | 55 |
175751 | 175751 | 2020-05-25 | Tolland | Connecticut | 9013 | 812 | 56 |
178795 | 178795 | 2020-05-26 | Tolland | Connecticut | 9013 | 821 | 56 |
181839 | 181839 | 2020-05-27 | Tolland | Connecticut | 9013 | 815 | 57 |
184893 | 184893 | 2020-05-28 | Tolland | Connecticut | 9013 | 822 | 57 |
187949 | 187949 | 2020-05-29 | Tolland | Connecticut | 9013 | 827 | 57 |
191014 | 191014 | 2020-05-30 | Tolland | Connecticut | 9013 | 833 | 57 |
194081 | 194081 | 2020-05-31 | Tolland | Connecticut | 9013 | 836 | 57 |
197151 | 197151 | 2020-06-01 | Tolland | Connecticut | 9013 | 845 | 58 |
200224 | 200224 | 2020-06-02 | Tolland | Connecticut | 9013 | 848 | 60 |
203300 | 203300 | 2020-06-03 | Tolland | Connecticut | 9013 | 856 | 60 |
206380 | 206380 | 2020-06-04 | Tolland | Connecticut | 9013 | 859 | 60 |
209461 | 209461 | 2020-06-05 | Tolland | Connecticut | 9013 | 859 | 60 |
212546 | 212546 | 2020-06-06 | Tolland | Connecticut | 9013 | 864 | 60 |
215633 | 215633 | 2020-06-07 | Tolland | Connecticut | 9013 | 864 | 60 |
218724 | 218724 | 2020-06-08 | Tolland | Connecticut | 9013 | 863 | 60 |
221819 | 221819 | 2020-06-09 | Tolland | Connecticut | 9013 | 873 | 61 |
224914 | 224914 | 2020-06-10 | Tolland | Connecticut | 9013 | 878 | 61 |
228016 | 228016 | 2020-06-11 | Tolland | Connecticut | 9013 | 883 | 62 |
231119 | 231119 | 2020-06-12 | Tolland | Connecticut | 9013 | 886 | 62 |
234225 | 234225 | 2020-06-13 | Tolland | Connecticut | 9013 | 885 | 62 |
237332 | 237332 | 2020-06-14 | Tolland | Connecticut | 9013 | 888 | 62 |
240440 | 240440 | 2020-06-15 | Tolland | Connecticut | 9013 | 888 | 62 |
243551 | 243551 | 2020-06-16 | Tolland | Connecticut | 9013 | 888 | 62 |
246664 | 246664 | 2020-06-17 | Tolland | Connecticut | 9013 | 889 | 63 |
249776 | 249776 | 2020-06-18 | Tolland | Connecticut | 9013 | 892 | 64 |
252891 | 252891 | 2020-06-19 | Tolland | Connecticut | 9013 | 893 | 64 |
256010 | 256010 | 2020-06-20 | Tolland | Connecticut | 9013 | 895 | 64 |
259137 | 259137 | 2020-06-21 | Tolland | Connecticut | 9013 | 895 | 64 |
262264 | 262264 | 2020-06-22 | Tolland | Connecticut | 9013 | 895 | 64 |
265392 | 265392 | 2020-06-23 | Tolland | Connecticut | 9013 | 898 | 64 |
268522 | 268522 | 2020-06-24 | Tolland | Connecticut | 9013 | 898 | 64 |
271658 | 271658 | 2020-06-25 | Tolland | Connecticut | 9013 | 899 | 64 |
274798 | 274798 | 2020-06-26 | Tolland | Connecticut | 9013 | 904 | 64 |
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);