ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 9011 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5292 | 5292 | 2020-03-20 | New London | Connecticut | 9011 | 1 | 0 |
6219 | 6219 | 2020-03-21 | New London | Connecticut | 9011 | 1 | 0 |
7255 | 7255 | 2020-03-22 | New London | Connecticut | 9011 | 3 | 0 |
8401 | 8401 | 2020-03-23 | New London | Connecticut | 9011 | 4 | 0 |
9646 | 9646 | 2020-03-24 | New London | Connecticut | 9011 | 6 | 0 |
11020 | 11020 | 2020-03-25 | New London | Connecticut | 9011 | 9 | 0 |
12568 | 12568 | 2020-03-26 | New London | Connecticut | 9011 | 13 | 0 |
14237 | 14237 | 2020-03-27 | New London | Connecticut | 9011 | 15 | 0 |
16021 | 16021 | 2020-03-28 | New London | Connecticut | 9011 | 19 | 0 |
17913 | 17913 | 2020-03-29 | New London | Connecticut | 9011 | 20 | 0 |
19892 | 19892 | 2020-03-30 | New London | Connecticut | 9011 | 24 | 0 |
21969 | 21969 | 2020-03-31 | New London | Connecticut | 9011 | 27 | 1 |
24128 | 24128 | 2020-04-01 | New London | Connecticut | 9011 | 29 | 1 |
26358 | 26358 | 2020-04-02 | New London | Connecticut | 9011 | 29 | 1 |
28660 | 28660 | 2020-04-03 | New London | Connecticut | 9011 | 40 | 3 |
31018 | 31018 | 2020-04-04 | New London | Connecticut | 9011 | 57 | 3 |
33424 | 33424 | 2020-04-05 | New London | Connecticut | 9011 | 57 | 4 |
35869 | 35869 | 2020-04-06 | New London | Connecticut | 9011 | 65 | 4 |
38359 | 38359 | 2020-04-07 | New London | Connecticut | 9011 | 85 | 4 |
40902 | 40902 | 2020-04-08 | New London | Connecticut | 9011 | 120 | 5 |
43476 | 43476 | 2020-04-09 | New London | Connecticut | 9011 | 139 | 6 |
46076 | 46076 | 2020-04-10 | New London | Connecticut | 9011 | 156 | 7 |
48706 | 48706 | 2020-04-11 | New London | Connecticut | 9011 | 185 | 7 |
51368 | 51368 | 2020-04-12 | New London | Connecticut | 9011 | 190 | 7 |
54047 | 54047 | 2020-04-13 | New London | Connecticut | 9011 | 222 | 7 |
56739 | 56739 | 2020-04-14 | New London | Connecticut | 9011 | 227 | 7 |
59447 | 59447 | 2020-04-15 | New London | Connecticut | 9011 | 236 | 7 |
62166 | 62166 | 2020-04-16 | New London | Connecticut | 9011 | 255 | 9 |
64899 | 64899 | 2020-04-17 | New London | Connecticut | 9011 | 292 | 10 |
67647 | 67647 | 2020-04-18 | New London | Connecticut | 9011 | 315 | 10 |
70409 | 70409 | 2020-04-19 | New London | Connecticut | 9011 | 339 | 10 |
73178 | 73178 | 2020-04-20 | New London | Connecticut | 9011 | 356 | 13 |
75954 | 75954 | 2020-04-21 | New London | Connecticut | 9011 | 369 | 13 |
78738 | 78738 | 2020-04-22 | New London | Connecticut | 9011 | 397 | 14 |
81532 | 81532 | 2020-04-23 | New London | Connecticut | 9011 | 419 | 17 |
84332 | 84332 | 2020-04-24 | New London | Connecticut | 9011 | 448 | 23 |
87140 | 87140 | 2020-04-25 | New London | Connecticut | 9011 | 473 | 28 |
89957 | 89957 | 2020-04-26 | New London | Connecticut | 9011 | 498 | 31 |
92775 | 92775 | 2020-04-27 | New London | Connecticut | 9011 | 516 | 34 |
95607 | 95607 | 2020-04-28 | New London | Connecticut | 9011 | 530 | 34 |
98452 | 98452 | 2020-04-29 | New London | Connecticut | 9011 | 540 | 35 |
101302 | 101302 | 2020-04-30 | New London | Connecticut | 9011 | 564 | 36 |
104157 | 104157 | 2020-05-01 | New London | Connecticut | 9011 | 603 | 42 |
107022 | 107022 | 2020-05-02 | New London | Connecticut | 9011 | 623 | 43 |
109891 | 109891 | 2020-05-03 | New London | Connecticut | 9011 | 623 | 43 |
112766 | 112766 | 2020-05-04 | New London | Connecticut | 9011 | 641 | 45 |
115649 | 115649 | 2020-05-05 | New London | Connecticut | 9011 | 681 | 45 |
118609 | 118609 | 2020-05-06 | New London | Connecticut | 9011 | 704 | 47 |
121578 | 121578 | 2020-05-07 | New London | Connecticut | 9011 | 742 | 49 |
124558 | 124558 | 2020-05-08 | New London | Connecticut | 9011 | 755 | 50 |
127544 | 127544 | 2020-05-09 | New London | Connecticut | 9011 | 775 | 54 |
130535 | 130535 | 2020-05-10 | New London | Connecticut | 9011 | 782 | 54 |
133526 | 133526 | 2020-05-11 | New London | Connecticut | 9011 | 784 | 56 |
136515 | 136515 | 2020-05-12 | New London | Connecticut | 9011 | 793 | 58 |
139506 | 139506 | 2020-05-13 | New London | Connecticut | 9011 | 804 | 60 |
142502 | 142502 | 2020-05-14 | New London | Connecticut | 9011 | 821 | 62 |
145502 | 145502 | 2020-05-15 | New London | Connecticut | 9011 | 844 | 63 |
148505 | 148505 | 2020-05-16 | New London | Connecticut | 9011 | 860 | 65 |
151514 | 151514 | 2020-05-17 | New London | Connecticut | 9011 | 873 | 66 |
154526 | 154526 | 2020-05-18 | New London | Connecticut | 9011 | 876 | 66 |
157542 | 157542 | 2020-05-19 | New London | Connecticut | 9011 | 880 | 66 |
160568 | 160568 | 2020-05-20 | New London | Connecticut | 9011 | 896 | 68 |
163596 | 163596 | 2020-05-21 | New London | Connecticut | 9011 | 903 | 73 |
166629 | 166629 | 2020-05-22 | New London | Connecticut | 9011 | 910 | 72 |
169666 | 169666 | 2020-05-23 | New London | Connecticut | 9011 | 970 | 72 |
172707 | 172707 | 2020-05-24 | New London | Connecticut | 9011 | 1046 | 74 |
175750 | 175750 | 2020-05-25 | New London | Connecticut | 9011 | 1043 | 78 |
178794 | 178794 | 2020-05-26 | New London | Connecticut | 9011 | 1075 | 78 |
181838 | 181838 | 2020-05-27 | New London | Connecticut | 9011 | 1053 | 79 |
184892 | 184892 | 2020-05-28 | New London | Connecticut | 9011 | 1067 | 83 |
187948 | 187948 | 2020-05-29 | New London | Connecticut | 9011 | 1068 | 85 |
191013 | 191013 | 2020-05-30 | New London | Connecticut | 9011 | 1076 | 89 |
194080 | 194080 | 2020-05-31 | New London | Connecticut | 9011 | 1078 | 89 |
197150 | 197150 | 2020-06-01 | New London | Connecticut | 9011 | 1091 | 89 |
200223 | 200223 | 2020-06-02 | New London | Connecticut | 9011 | 1094 | 90 |
203299 | 203299 | 2020-06-03 | New London | Connecticut | 9011 | 1100 | 92 |
206379 | 206379 | 2020-06-04 | New London | Connecticut | 9011 | 1104 | 94 |
209460 | 209460 | 2020-06-05 | New London | Connecticut | 9011 | 1108 | 95 |
212545 | 212545 | 2020-06-06 | New London | Connecticut | 9011 | 1112 | 95 |
215632 | 215632 | 2020-06-07 | New London | Connecticut | 9011 | 1119 | 95 |
218723 | 218723 | 2020-06-08 | New London | Connecticut | 9011 | 1120 | 96 |
221818 | 221818 | 2020-06-09 | New London | Connecticut | 9011 | 1122 | 96 |
224913 | 224913 | 2020-06-10 | New London | Connecticut | 9011 | 1130 | 97 |
228015 | 228015 | 2020-06-11 | New London | Connecticut | 9011 | 1147 | 98 |
231118 | 231118 | 2020-06-12 | New London | Connecticut | 9011 | 1150 | 98 |
234224 | 234224 | 2020-06-13 | New London | Connecticut | 9011 | 1198 | 100 |
237331 | 237331 | 2020-06-14 | New London | Connecticut | 9011 | 1236 | 101 |
240439 | 240439 | 2020-06-15 | New London | Connecticut | 9011 | 1240 | 102 |
243550 | 243550 | 2020-06-16 | New London | Connecticut | 9011 | 1276 | 102 |
246663 | 246663 | 2020-06-17 | New London | Connecticut | 9011 | 1285 | 101 |
249775 | 249775 | 2020-06-18 | New London | Connecticut | 9011 | 1288 | 101 |
252890 | 252890 | 2020-06-19 | New London | Connecticut | 9011 | 1203 | 101 |
256009 | 256009 | 2020-06-20 | New London | Connecticut | 9011 | 1209 | 101 |
259136 | 259136 | 2020-06-21 | New London | Connecticut | 9011 | 1217 | 101 |
262263 | 262263 | 2020-06-22 | New London | Connecticut | 9011 | 1214 | 101 |
265391 | 265391 | 2020-06-23 | New London | Connecticut | 9011 | 1221 | 102 |
268521 | 268521 | 2020-06-24 | New London | Connecticut | 9011 | 1221 | 102 |
271657 | 271657 | 2020-06-25 | New London | Connecticut | 9011 | 1219 | 102 |
274797 | 274797 | 2020-06-26 | New London | Connecticut | 9011 | 1223 | 102 |
277945 | 277945 | 2020-06-27 | New London | Connecticut | 9011 | 1241 | 102 |
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);