ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 25017 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 687 ✖
- 26565 8
- 135427 4
- 145291 4
- 154477 4
- 270534 4
- 314707 4
- 331797 4
- 135555 3
- 135791 3
- 136324 3
- 137187 3
- 138377 3
- 139897 3
- 141542 3
- 143362 3
- 147182 3
- 149283 3
- 151269 3
- 152899 3
- 156101 3
- 157854 3
- 159612 3
- 161457 3
- 163654 3
- 166818 3
- 170099 3
- 174735 3
- 180554 3
- 186874 3
- 196703 3
- 213486 3
- 241111 3
- 291711 3
- 303054 3
- 308833 3
- 312054 3
- 316558 3
- 318306 3
- 319742 3
- 321021 3
- 322822 3
- 325150 3
- 327895 3
- 335583 3
- 340026 3
- 345386 3
- 1 2
- 41 2
- 27056 2
- 43538 2
- 69259 2
- 75615 2
- 123681 2
- 134871 2
- 162934 2
- 169160 2
- 5 1
- 10 1
- 15 1
- 49 1
- 60 1
- 65 1
- 75 1
- 83 1
- 89 1
- 100 1
- 119 1
- 144 1
- 177 1
- 199 1
- 232 1
- 304 1
- 446 1
- 538 1
- 685 1
- 842 1
- 981 1
- 1141 1
- 1340 1
- 1582 1
- 1870 1
- 2202 1
- 2468 1
- 2632 1
- 2950 1
- 3187 1
- 3545 1
- 4045 1
- 4447 1
- 4872 1
- 5660 1
- 5983 1
- 6254 1
- 6681 1
- 7206 1
- 7744 1
- 8297 1
- 8737 1
- 9253 1
- 9621 1
- 10094 1
- 10724 1
- 11681 1
- 12253 1
- 12648 1
- 12953 1
- 13417 1
- 13799 1
- 14208 1
- 14607 1
- 15048 1
- 15370 1
- 15757 1
- 15980 1
- 16327 1
- 16676 1
- 17014 1
- 17307 1
- 17589 1
- 17774 1
- 17953 1
- 18201 1
- 18381 1
- 18683 1
- 18883 1
- 19129 1
- 19345 1
- 19504 1
- 19708 1
- 19930 1
- 20085 1
- 20232 1
- 20437 1
- 20539 1
- 20601 1
- 20706 1
- 20857 1
- 20972 1
- 21124 1
- 21287 1
- 22224 1
- 22296 1
- 22403 1
- 22485 1
- 22583 1
- 22686 1
- 22754 1
- 22812 1
- 22845 1
- 22889 1
- 22996 1
- 23075 1
- 23156 1
- 23195 1
- 23227 1
- 23269 1
- 23346 1
- 23407 1
- 23464 1
- 23544 1
- 23574 1
- 23609 1
- 23647 1
- 23697 1
- 23741 1
- 23786 1
- 23859 1
- 23915 1
- 23946 1
- 23962 1
- 23998 1
- 24039 1
- 24083 1
- 24115 1
- 24153 1
- 24193 1
- 24243 1
- 24300 1
- 24348 1
- 24377 1
- 24436 1
- 24483 1
- 24536 1
- 24600 1
- 24652 1
- 24685 1
- 24738 1
- 24809 1
- 24886 1
- 24958 1
- 25011 1
- 25084 1
- 25123 1
- 25190 1
- 25250 1
- 25333 1
- 25396 1
- 25411 1
- 25429 1
- 25495 1
- 25535 1
- 25558 1
- 25617 1
- 25629 1
- 25706 1
- 25712 1
- 25752 1
- 25792 1
- 25801 1
- 25847 1
- 25894 1
- 25931 1
- 25932 1
- 26021 1
- 26027 1
- 26109 1
- 26138 1
- 26156 1
- 26182 1
- 26246 1
- 26254 1
- 26304 1
- 26345 1
- 26383 1
- 26420 1
- 26469 1
- 26470 1
- 26545 1
- 26644 1
- 26732 1
- 26784 1
- 26820 1
- 26896 1
- 26943 1
- 26954 1
- 27014 1
- 27029 1
- 27103 1
- 27158 1
- 27201 1
- 27248 1
- 27296 1
- 27340 1
- 27377 1
- 27392 1
- 27463 1
- 27507 1
- 27562 1
- 27595 1
- 27624 1
- 27665 1
- 27732 1
- 27779 1
- 27961 1
- 28101 1
- 28243 1
- 28308 1
- 28392 1
- 28533 1
- 28638 1
- 28796 1
- 28917 1
- 29055 1
- 29225 1
- 29358 1
- 29460 1
- 29587 1
- 29728 1
- 29845 1
- 29986 1
- 30182 1
- 30367 1
- 30502 1
- 30656 1
- 30831 1
- 31032 1
- 31257 1
- 31401 1
- 31594 1
- 31808 1
- 32015 1
- 32295 1
- 32557 1
- 32781 1
- 32907 1
- 33119 1
- 33452 1
- 33774 1
- 34142 1
- 34586 1
- 34979 1
- 35177 1
- 35516 1
- 36023 1
- 36551 1
- 37113 1
- 37652 1
- 38246 1
- 38643 1
- 39117 1
- 39666 1
- 40230 1
- 40680 1
- 41384 1
- 42019 1
- 42437 1
- 42863 1
- 44577 1
- 45363 1
- 45972 1
- 46230 1
- 46743 1
- 47671 1
- 48896 1
- 50108 1
- 51310 1
- 52345 1
- 52839 1
- 53518 1
- 54680 1
- 55765 1
- 56850 1
- 57947 1
- 59078 1
- 59835 1
- 60621 1
- 61640 1
- 62721 1
- 63998 1
- 64782 1
- 65653 1
- 66506 1
- 67233 1
- 68154 1
- 70748 1
- 71348 1
- 72124 1
- 72973 1
- 74298 1
- 77222 1
- 77821 1
- 78663 1
- 79505 1
- 80812 1
- 82238 1
- 83698 1
- 85112 1
- 86020 1
- 86826 1
- 87864 1
- 88898 1
- 89999 1
- 90918 1
- 91946 1
- 92781 1
- 93414 1
- 93861 1
- 94631 1
- 95512 1
- 96331 1
- 97177 1
- 97870 1
- 98482 1
- 98828 1
- 99560 1
- 100273 1
- 100774 1
- 101488 1
- 101919 1
- 102399 1
- 102781 1
- 103162 1
- 103581 1
- 104142 1
- 104730 1
- 105266 1
- 105526 1
- 105754 1
- 106111 1
- 106482 1
- 106911 1
- 107316 1
- 107656 1
- 107996 1
- 108172 1
- 108411 1
- 108759 1
- 109093 1
- 109457 1
- 109679 1
- 109891 1
- 110116 1
- 110488 1
- 110899 1
- 111231 1
- 111505 1
- 111798 1
- 112050 1
- 112066 1
- 112361 1
- 112643 1
- 112945 1
- 113262 1
- 113553 1
- 113766 1
- 113972 1
- 114299 1
- 114617 1
- 115029 1
- 115376 1
- 115697 1
- 115937 1
- 116175 1
- 116588 1
- 117031 1
- 117434 1
- 117840 1
- 118225 1
- 118504 1
- 118787 1
- 119223 1
- 119685 1
- 120170 1
- 120686 1
- 121081 1
- 121435 1
- 121737 1
- 122222 1
- 122757 1
- 123209 1
- 124297 1
- 124618 1
- 125122 1
- 125587 1
- 126060 1
- 126556 1
- 127007 1
- 127341 1
- 127550 1
- 127985 1
- 128401 1
- 128832 1
- 129172 1
- 129437 1
- 129684 1
- 129834 1
- 130103 1
- 130366 1
- 130661 1
- 130965 1
- 131174 1
- 131332 1
- 131487 1
- 131763 1
- 132011 1
- 132248 1
- 132458 1
- 132603 1
- 132683 1
- 132810 1
- 132967 1
- 133161 1
- 133329 1
- 133465 1
- 133571 1
- 133645 1
- 133668 1
- 133808 1
- 133890 1
- 133940 1
- 134047 1
- 134134 1
- 134167 1
- 134220 1
- 134286 1
- 134362 1
- 134439 1
- 134526 1
- 134583 1
- 134619 1
- 134657 1
- 134729 1
- 134758 1
- 134817 1
- 134846 1
- 134915 1
- 134928 1
- 134980 1
- 135007 1
- 135049 1
- 135066 1
- 135081 1
- 135107 1
- 135121 1
- 135136 1
- 135151 1
- 135172 1
- 135182 1
- 135191 1
- 135202 1
- 135218 1
- 135224 1
- 135248 1
- 135267 1
- 135278 1
- 135286 1
- 135294 1
- 135312 1
- 135332 1
- 135342 1
- 135349 1
- 135353 1
- 135362 1
- 135369 1
- 135387 1
- 135401 1
- 135478 1
- 135505 1
- 135523 1
- 135609 1
- 135662 1
- 135707 1
- 135745 1
- 135938 1
- 136020 1
- 136114 1
- 136210 1
- 136594 1
- 136723 1
- 136846 1
- 136999 1
- 137559 1
- 137762 1
- 137955 1
- 138172 1
- 138880 1
- 139103 1
- 139401 1
- 139654 1
- 140492 1
- 140744 1
- 141020 1
- 141256 1
- 142209 1
- 142454 1
- 142761 1
- 143063 1
- 144115 1
- 144407 1
- 144708 1
- 145000 1
- 146251 1
- 146511 1
- 146875 1
- 147952 1
- 148177 1
- 148641 1
- 148946 1
- 150054 1
- 150259 1
- 150604 1
- 150924 1
- 151946 1
- 152148 1
- 152419 1
- 152657 1
- 153466 1
- 153695 1
- 153938 1
- 154205 1
- 155244 1
- 155491 1
- 155781 1
- 156655 1
- 157009 1
- 157311 1
- 157580 1
- 158495 1
- 158740 1
- 159020 1
- 159335 1
- 160294 1
- 160515 1
- 160772 1
- 161124 1
- 162297 1
- 162565 1
- 164749 1
- 165102 1
- 165657 1
- 166268 1
- 168126 1
- 168570 1
- 171126 1
- 171732 1
- 172710 1
- 173693 1
- 176891 1
- 177499 1
- 178510 1
- 179618 1
- 182713 1
- 183387 1
- 184434 1
- 185583 1
- 189533 1
- 190649 1
- 192450 1
- 194544 1
- 199271 1
- 201332 1
- 204638 1
- 208865 1
- 219876 1
- 223261 1
- 229701 1
- 235997 1
- 254872 1
- 258623 1
- 263784 1
- 267670 1
- 282467 1
- 286132 1
- 289046 1
- 296675 1
- 298050 1
- 299948 1
- 301631 1
- 305536 1
- 306086 1
- 307188 1
- 308084 1
- 310094 1
- 310461 1
- 311088 1
- 311591 1
- 312865 1
- 313199 1
- 313621 1
- 314181 1
- 315587 1
- 315897 1
- 316238 1
- 316954 1
- 317312 1
- 317634 1
- 317996 1
- 318765 1
- 319007 1
- 319275 1
- 319520 1
- 320163 1
- 320334 1
- 320543 1
- 320772 1
- 321549 1
- 321828 1
- 322156 1
- 322485 1
- 323545 1
- 323901 1
- 324307 1
- 324707 1
- 326001 1
- 326413 1
- 326882 1
- 327400 1
- 329073 1
- 329623 1
- 330255 1
- 331134 1
- 333781 1
- 334361 1
- 335080 1
- 337006 1
- 337602 1
- 338353 1
- 339224 1
- 341774 1
- 342503 1
- 343274 1
- 344393 1
- 347746 1
- 348380 1
- 349443 1
- 350880 1
- 352032 1
state 1
- Massachusetts 800
fips 1
- 25017 · 800 ✖
county 1
- Middlesex 800
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
557 | 557 | 2020-03-05 | Middlesex | Massachusetts | 25017 | 1 | 0 |
617 | 617 | 2020-03-06 | Middlesex | Massachusetts | 25017 | 1 | 0 |
703 | 703 | 2020-03-07 | Middlesex | Massachusetts | 25017 | 5 | 0 |
805 | 805 | 2020-03-08 | Middlesex | Massachusetts | 25017 | 10 | 0 |
929 | 929 | 2020-03-09 | Middlesex | Massachusetts | 25017 | 15 | 0 |
1076 | 1076 | 2020-03-10 | Middlesex | Massachusetts | 25017 | 41 | 0 |
1256 | 1256 | 2020-03-11 | Middlesex | Massachusetts | 25017 | 41 | 0 |
1474 | 1474 | 2020-03-12 | Middlesex | Massachusetts | 25017 | 49 | 0 |
1753 | 1753 | 2020-03-13 | Middlesex | Massachusetts | 25017 | 60 | 0 |
2096 | 2096 | 2020-03-14 | Middlesex | Massachusetts | 25017 | 65 | 0 |
2498 | 2498 | 2020-03-15 | Middlesex | Massachusetts | 25017 | 75 | 0 |
2947 | 2947 | 2020-03-16 | Middlesex | Massachusetts | 25017 | 83 | 0 |
3448 | 3448 | 2020-03-17 | Middlesex | Massachusetts | 25017 | 89 | 0 |
4031 | 4031 | 2020-03-18 | Middlesex | Massachusetts | 25017 | 100 | 0 |
4736 | 4736 | 2020-03-19 | Middlesex | Massachusetts | 25017 | 119 | 0 |
5555 | 5555 | 2020-03-20 | Middlesex | Massachusetts | 25017 | 144 | 0 |
6514 | 6514 | 2020-03-21 | Middlesex | Massachusetts | 25017 | 177 | 1 |
7591 | 7591 | 2020-03-22 | Middlesex | Massachusetts | 25017 | 199 | 1 |
8763 | 8763 | 2020-03-23 | Middlesex | Massachusetts | 25017 | 232 | 1 |
10052 | 10052 | 2020-03-24 | Middlesex | Massachusetts | 25017 | 304 | 2 |
11464 | 11464 | 2020-03-25 | Middlesex | Massachusetts | 25017 | 446 | 2 |
13045 | 13045 | 2020-03-26 | Middlesex | Massachusetts | 25017 | 538 | 5 |
14753 | 14753 | 2020-03-27 | Middlesex | Massachusetts | 25017 | 685 | 6 |
16573 | 16573 | 2020-03-28 | Middlesex | Massachusetts | 25017 | 842 | 6 |
18488 | 18488 | 2020-03-29 | Middlesex | Massachusetts | 25017 | 981 | 7 |
20504 | 20504 | 2020-03-30 | Middlesex | Massachusetts | 25017 | 1141 | 9 |
22613 | 22613 | 2020-03-31 | Middlesex | Massachusetts | 25017 | 1340 | 18 |
24792 | 24792 | 2020-04-01 | Middlesex | Massachusetts | 25017 | 1582 | 21 |
27044 | 27044 | 2020-04-02 | Middlesex | Massachusetts | 25017 | 1870 | 29 |
29362 | 29362 | 2020-04-03 | Middlesex | Massachusetts | 25017 | 2202 | 39 |
31740 | 31740 | 2020-04-04 | Middlesex | Massachusetts | 25017 | 2468 | 39 |
34165 | 34165 | 2020-04-05 | Middlesex | Massachusetts | 25017 | 2632 | 42 |
36624 | 36624 | 2020-04-06 | Middlesex | Massachusetts | 25017 | 2950 | 48 |
39132 | 39132 | 2020-04-07 | Middlesex | Massachusetts | 25017 | 3187 | 69 |
41684 | 41684 | 2020-04-08 | Middlesex | Massachusetts | 25017 | 3545 | 80 |
44260 | 44260 | 2020-04-09 | Middlesex | Massachusetts | 25017 | 4045 | 93 |
46868 | 46868 | 2020-04-10 | Middlesex | Massachusetts | 25017 | 4447 | 109 |
49510 | 49510 | 2020-04-11 | Middlesex | Massachusetts | 25017 | 4872 | 137 |
52180 | 52180 | 2020-04-12 | Middlesex | Massachusetts | 25017 | 5660 | 149 |
54861 | 54861 | 2020-04-13 | Middlesex | Massachusetts | 25017 | 5983 | 163 |
57559 | 57559 | 2020-04-14 | Middlesex | Massachusetts | 25017 | 6254 | 188 |
60268 | 60268 | 2020-04-15 | Middlesex | Massachusetts | 25017 | 6681 | 221 |
62989 | 62989 | 2020-04-16 | Middlesex | Massachusetts | 25017 | 7206 | 258 |
65727 | 65727 | 2020-04-17 | Middlesex | Massachusetts | 25017 | 7744 | 294 |
68477 | 68477 | 2020-04-18 | Middlesex | Massachusetts | 25017 | 8297 | 334 |
71241 | 71241 | 2020-04-19 | Middlesex | Massachusetts | 25017 | 8737 | 372 |
74013 | 74013 | 2020-04-20 | Middlesex | Massachusetts | 25017 | 9253 | 402 |
76793 | 76793 | 2020-04-21 | Middlesex | Massachusetts | 25017 | 9621 | 428 |
79579 | 79579 | 2020-04-22 | Middlesex | Massachusetts | 25017 | 10094 | 494 |
82374 | 82374 | 2020-04-23 | Middlesex | Massachusetts | 25017 | 10724 | 545 |
85178 | 85178 | 2020-04-24 | Middlesex | Massachusetts | 25017 | 11681 | 585 |
87988 | 87988 | 2020-04-25 | Middlesex | Massachusetts | 25017 | 12253 | 629 |
90804 | 90804 | 2020-04-26 | Middlesex | Massachusetts | 25017 | 12648 | 670 |
93625 | 93625 | 2020-04-27 | Middlesex | Massachusetts | 25017 | 12953 | 700 |
96460 | 96460 | 2020-04-28 | Middlesex | Massachusetts | 25017 | 13417 | 731 |
99306 | 99306 | 2020-04-29 | Middlesex | Massachusetts | 25017 | 13799 | 802 |
102158 | 102158 | 2020-04-30 | Middlesex | Massachusetts | 25017 | 14208 | 845 |
105018 | 105018 | 2020-05-01 | Middlesex | Massachusetts | 25017 | 14607 | 885 |
107882 | 107882 | 2020-05-02 | Middlesex | Massachusetts | 25017 | 15048 | 923 |
110754 | 110754 | 2020-05-03 | Middlesex | Massachusetts | 25017 | 15370 | 972 |
113632 | 113632 | 2020-05-04 | Middlesex | Massachusetts | 25017 | 15757 | 997 |
116513 | 116513 | 2020-05-05 | Middlesex | Massachusetts | 25017 | 15980 | 1028 |
119474 | 119474 | 2020-05-06 | Middlesex | Massachusetts | 25017 | 16327 | 1070 |
122446 | 122446 | 2020-05-07 | Middlesex | Massachusetts | 25017 | 16676 | 1103 |
125428 | 125428 | 2020-05-08 | Middlesex | Massachusetts | 25017 | 17014 | 1132 |
128415 | 128415 | 2020-05-09 | Middlesex | Massachusetts | 25017 | 17307 | 1169 |
131405 | 131405 | 2020-05-10 | Middlesex | Massachusetts | 25017 | 17589 | 1207 |
134396 | 134396 | 2020-05-11 | Middlesex | Massachusetts | 25017 | 17774 | 1235 |
137386 | 137386 | 2020-05-12 | Middlesex | Massachusetts | 25017 | 17953 | 1244 |
140380 | 140380 | 2020-05-13 | Middlesex | Massachusetts | 25017 | 18201 | 1282 |
143375 | 143375 | 2020-05-14 | Middlesex | Massachusetts | 25017 | 18381 | 1327 |
146375 | 146375 | 2020-05-15 | Middlesex | Massachusetts | 25017 | 18683 | 1347 |
149380 | 149380 | 2020-05-16 | Middlesex | Massachusetts | 25017 | 18883 | 1370 |
152391 | 152391 | 2020-05-17 | Middlesex | Massachusetts | 25017 | 19129 | 1394 |
155405 | 155405 | 2020-05-18 | Middlesex | Massachusetts | 25017 | 19345 | 1412 |
158423 | 158423 | 2020-05-19 | Middlesex | Massachusetts | 25017 | 19504 | 1436 |
161449 | 161449 | 2020-05-20 | Middlesex | Massachusetts | 25017 | 19708 | 1462 |
164478 | 164478 | 2020-05-21 | Middlesex | Massachusetts | 25017 | 19930 | 1478 |
167514 | 167514 | 2020-05-22 | Middlesex | Massachusetts | 25017 | 20085 | 1496 |
170551 | 170551 | 2020-05-23 | Middlesex | Massachusetts | 25017 | 20232 | 1512 |
173593 | 173593 | 2020-05-24 | Middlesex | Massachusetts | 25017 | 20437 | 1518 |
176636 | 176636 | 2020-05-25 | Middlesex | Massachusetts | 25017 | 20539 | 1527 |
179680 | 179680 | 2020-05-26 | Middlesex | Massachusetts | 25017 | 20601 | 1535 |
182726 | 182726 | 2020-05-27 | Middlesex | Massachusetts | 25017 | 20706 | 1549 |
185781 | 185781 | 2020-05-28 | Middlesex | Massachusetts | 25017 | 20857 | 1564 |
188839 | 188839 | 2020-05-29 | Middlesex | Massachusetts | 25017 | 20972 | 1583 |
191903 | 191903 | 2020-05-30 | Middlesex | Massachusetts | 25017 | 21124 | 1596 |
194971 | 194971 | 2020-05-31 | Middlesex | Massachusetts | 25017 | 21287 | 1615 |
198042 | 198042 | 2020-06-01 | Middlesex | Massachusetts | 25017 | 22224 | 1650 |
201114 | 201114 | 2020-06-02 | Middlesex | Massachusetts | 25017 | 22296 | 1663 |
204191 | 204191 | 2020-06-03 | Middlesex | Massachusetts | 25017 | 22403 | 1676 |
207272 | 207272 | 2020-06-04 | Middlesex | Massachusetts | 25017 | 22485 | 1689 |
210353 | 210353 | 2020-06-05 | Middlesex | Massachusetts | 25017 | 22583 | 1695 |
213437 | 213437 | 2020-06-06 | Middlesex | Massachusetts | 25017 | 22686 | 1701 |
216525 | 216525 | 2020-06-07 | Middlesex | Massachusetts | 25017 | 22754 | 1705 |
219617 | 219617 | 2020-06-08 | Middlesex | Massachusetts | 25017 | 22812 | 1711 |
222712 | 222712 | 2020-06-09 | Middlesex | Massachusetts | 25017 | 22845 | 1720 |
225808 | 225808 | 2020-06-10 | Middlesex | Massachusetts | 25017 | 22889 | 1725 |
228910 | 228910 | 2020-06-11 | Middlesex | Massachusetts | 25017 | 22996 | 1733 |
232014 | 232014 | 2020-06-12 | Middlesex | Massachusetts | 25017 | 23075 | 1744 |
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);