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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 570 ✖
- 1620 4
- 9645 4
- 22467 4
- 22590 4
- 24791 4
- 26746 4
- 34077 4
- 36134 4
- 1277 3
- 1322 3
- 1347 3
- 1362 3
- 1402 3
- 1433 3
- 1477 3
- 1505 3
- 1554 3
- 1651 3
- 1717 3
- 1843 3
- 2206 3
- 2570 3
- 3083 3
- 3456 3
- 3803 3
- 4220 3
- 4668 3
- 5352 3
- 5867 3
- 6648 3
- 7684 3
- 8940 3
- 12434 3
- 14167 3
- 15684 3
- 16753 3
- 17587 3
- 18226 3
- 18635 3
- 19123 3
- 19445 3
- 19731 3
- 20012 3
- 20412 3
- 20819 3
- 21119 3
- 21432 3
- 21654 3
- 21907 3
- 22153 3
- 22307 3
- 22406 3
- 22497 3
- 22530 3
- 22540 3
- 22558 3
- 22625 3
- 22675 3
- 22807 3
- 22975 3
- 23238 3
- 23561 3
- 23934 3
- 24391 3
- 25260 3
- 25746 3
- 26080 3
- 26428 3
- 27028 3
- 27301 3
- 27543 3
- 27786 3
- 28097 3
- 28789 3
- 29473 3
- 30126 3
- 31520 3
- 32875 3
- 40016 3
- 45088 3
- 48476 3
- 50879 3
- 51909 3
- 52549 3
- 53177 3
- 53426 3
- 53711 3
- 54060 3
- 54240 3
- 54414 3
- 54607 3
- 54968 3
- 55412 3
- 55880 3
- 56500 3
- 57081 3
- 1 2
- 29 2
- 57 2
- 623 2
- 1221 2
- 1268 2
- 1499 2
- 1526 2
- 1649 2
- 5731 2
- 10618 2
- 10981 2
- 22488 2
- 22545 2
- 29221 2
- 3 1
- 4 1
- 6 1
- 9 1
- 13 1
- 15 1
- 19 1
- 20 1
- 24 1
- 27 1
- 40 1
- 65 1
- 85 1
- 120 1
- 139 1
- 156 1
- 185 1
- 190 1
- 222 1
- 227 1
- 236 1
- 255 1
- 292 1
- 315 1
- 339 1
- 356 1
- 369 1
- 397 1
- 419 1
- 448 1
- 473 1
- 498 1
- 516 1
- 530 1
- 540 1
- 564 1
- 603 1
- 641 1
- 681 1
- 704 1
- 742 1
- 755 1
- 775 1
- 782 1
- 784 1
- 793 1
- 804 1
- 821 1
- 844 1
- 860 1
- 873 1
- 876 1
- 880 1
- 896 1
- 903 1
- 910 1
- 970 1
- 1043 1
- 1046 1
- 1053 1
- 1067 1
- 1068 1
- 1075 1
- 1076 1
- 1078 1
- 1091 1
- 1094 1
- 1100 1
- 1104 1
- 1108 1
- 1112 1
- 1119 1
- 1120 1
- 1122 1
- 1130 1
- 1147 1
- 1150 1
- 1198 1
- 1203 1
- 1209 1
- 1214 1
- 1217 1
- 1219 1
- 1223 1
- 1236 1
- 1240 1
- 1241 1
- 1244 1
- 1255 1
- 1273 1
- 1276 1
- 1285 1
- 1288 1
- 1296 1
- 1304 1
- 1308 1
- 1319 1
- 1328 1
- 1334 1
- 1339 1
- 1345 1
- 1352 1
- 1356 1
- 1357 1
- 1364 1
- 1373 1
- 1382 1
- 1387 1
- 1396 1
- 1414 1
- 1421 1
- 1428 1
- 1431 1
- 1457 1
- 1467 1
- 1469 1
- 1475 1
- 1497 1
- 1503 1
- 1517 1
- 1520 1
- 1577 1
- 1587 1
- 1590 1
- 1598 1
- 1643 1
- 1677 1
- 1682 1
- 1689 1
- 1705 1
- 1774 1
- 1782 1
- 1803 1
- 1830 1
- 1959 1
- 1994 1
- 2053 1
- 2087 1
- 2349 1
- 2413 1
- 2426 1
- 2515 1
- 2837 1
- 2905 1
- 2918 1
- 2924 1
- 3234 1
- 3281 1
- 3329 1
- 3386 1
- 3660 1
- 3695 1
- 3715 1
- 3765 1
- 3955 1
- 4041 1
- 4068 1
- 4141 1
- 4326 1
- 4397 1
- 4475 1
- 4518 1
- 4906 1
- 4968 1
- 5112 1
- 5256 1
- 5592 1
- 5648 1
- 6051 1
- 6148 1
- 6250 1
- 6557 1
- 7064 1
- 7198 1
- 7335 1
- 7485 1
- 8212 1
- 8343 1
- 8562 1
- 8716 1
- 9255 1
- 9349 1
- 9469 1
- 10295 1
- 10356 1
- 10480 1
- 11440 1
- 11616 1
- 11873 1
- 12164 1
- 13160 1
- 13492 1
- 13890 1
- 14000 1
- 14885 1
- 15086 1
- 15298 1
- 15483 1
- 16194 1
- 16321 1
- 16518 1
- 16644 1
- 17127 1
- 17332 1
- 17373 1
- 17459 1
- 17948 1
- 18007 1
- 18070 1
- 18152 1
- 18447 1
- 18500 1
- 18529 1
- 18547 1
- 18791 1
- 18914 1
- 19032 1
- 19096 1
- 19308 1
- 19329 1
- 19350 1
- 19395 1
- 19568 1
- 19606 1
- 19624 1
- 19649 1
- 19850 1
- 19872 1
- 19888 1
- 19956 1
- 20159 1
- 20189 1
- 20294 1
- 20348 1
- 20582 1
- 20641 1
- 20674 1
- 20759 1
- 20938 1
- 20986 1
- 21018 1
- 21053 1
- 21222 1
- 21272 1
- 21342 1
- 21382 1
- 21516 1
- 21545 1
- 21587 1
- 21610 1
- 21773 1
- 21803 1
- 21832 1
- 21862 1
- 22017 1
- 22057 1
- 22096 1
- 22134 1
- 22208 1
- 22234 1
- 22244 1
- 22278 1
- 22361 1
- 22365 1
- 22370 1
- 22392 1
- 22421 1
- 22435 1
- 22440 1
- 22446 1
- 22492 1
- 22511 1
- 22512 1
- 22516 1
- 22522 1
- 22534 1
- 22536 1
- 22537 1
- 22539 1
- 22546 1
- 22554 1
- 22572 1
- 22573 1
- 22578 1
- 22587 1
- 22599 1
- 22613 1
- 22620 1
- 22626 1
- 22647 1
- 22657 1
- 22667 1
- 22717 1
- 22729 1
- 22746 1
- 22780 1
- 22859 1
- 22898 1
- 22923 1
- 22945 1
- 23072 1
- 23106 1
- 23131 1
- 23190 1
- 23340 1
- 23362 1
- 23431 1
- 23493 1
- 23715 1
- 23807 1
- 23864 1
- 23907 1
- 24088 1
- 24186 1
- 24243 1
- 24315 1
- 24514 1
- 24595 1
- 24663 1
- 24738 1
- 24985 1
- 25112 1
- 25162 1
- 25406 1
- 25533 1
- 25576 1
- 25675 1
- 25883 1
- 25922 1
- 25959 1
- 26026 1
- 26249 1
- 26294 1
- 26345 1
- 26361 1
- 26572 1
- 26603 1
- 26642 1
- 26680 1
- 26863 1
- 26883 1
- 26971 1
- 27134 1
- 27166 1
- 27206 1
- 27248 1
- 27386 1
- 27428 1
- 27451 1
- 27494 1
- 27645 1
- 27685 1
- 27728 1
- 27760 1
- 27896 1
- 27923 1
- 28006 1
- 28061 1
- 28410 1
- 28462 1
- 28564 1
- 28682 1
- 29050 1
- 29135 1
- 29689 1
- 29782 1
- 29881 1
- 30052 1
- 30694 1
- 30862 1
- 30904 1
- 31159 1
- 32214 1
- 32421 1
- 32578 1
- 32724 1
- 33369 1
- 33796 1
- 33949 1
- 34949 1
- 35329 1
- 35683 1
- 37396 1
- 37997 1
- 38819 1
- 39336 1
- 42381 1
- 42826 1
- 43531 1
- 44355 1
- 46635 1
- 46934 1
- 47461 1
- 47913 1
- 49451 1
- 49922 1
- 50278 1
- 50633 1
- 51160 1
- 51271 1
- 51447 1
- 51809 1
- 52125 1
- 52274 1
- 52357 1
- 52453 1
- 52670 1
- 52748 1
- 52840 1
- 52955 1
- 53279 1
- 53322 1
- 53366 1
- 53386 1
- 53571 1
- 53576 1
- 53618 1
- 53682 1
- 53884 1
- 53972 1
- 54008 1
- 54034 1
- 54115 1
- 54151 1
- 54184 1
- 54208 1
- 54284 1
- 54327 1
- 54361 1
- 54384 1
- 54484 1
- 54505 1
- 54543 1
- 54580 1
- 54700 1
- 54725 1
- 54758 1
- 54875 1
- 55101 1
- 55232 1
- 55300 1
- 55324 1
- 55558 1
- 55618 1
- 55721 1
- 55796 1
- 56071 1
- 56161 1
- 56268 1
- 56391 1
- 56707 1
- 56816 1
- 56880 1
- 56984 1
- 57454 1
- 57604 1
- 57803 1
- 57958 1
- 58138 1
state 1
- Connecticut 785
fips 1
- 9011 · 785 ✖
county 1
- New London 785
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);