ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 25009 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 682 ✖
- 17930 8
- 97993 4
- 103447 4
- 109928 4
- 181006 4
- 201680 4
- 206639 4
- 98068 3
- 98173 3
- 98415 3
- 98816 3
- 99428 3
- 100285 3
- 101192 3
- 102266 3
- 104696 3
- 106142 3
- 107458 3
- 108788 3
- 111055 3
- 112130 3
- 113176 3
- 114525 3
- 116274 3
- 118653 3
- 121070 3
- 124533 3
- 128724 3
- 132872 3
- 138812 3
- 149987 3
- 166430 3
- 191083 3
- 196731 3
- 199398 3
- 200813 3
- 202263 3
- 202654 3
- 202995 3
- 203407 3
- 203953 3
- 204616 3
- 205415 3
- 207962 3
- 209640 3
- 211651 3
- 1 2
- 2 2
- 18430 2
- 32897 2
- 53682 2
- 58429 2
- 90089 2
- 97571 2
- 115699 2
- 120475 2
- 5 1
- 6 1
- 7 1
- 8 1
- 14 1
- 19 1
- 29 1
- 41 1
- 60 1
- 73 1
- 118 1
- 177 1
- 247 1
- 350 1
- 472 1
- 570 1
- 653 1
- 784 1
- 885 1
- 1039 1
- 1238 1
- 1400 1
- 1506 1
- 1653 1
- 1841 1
- 2103 1
- 2336 1
- 2670 1
- 2896 1
- 3170 1
- 3413 1
- 3594 1
- 3894 1
- 4245 1
- 4584 1
- 4914 1
- 5153 1
- 5296 1
- 5521 1
- 5783 1
- 6219 1
- 6841 1
- 7212 1
- 7489 1
- 7708 1
- 7972 1
- 8380 1
- 8673 1
- 9028 1
- 9362 1
- 9542 1
- 9773 1
- 9979 1
- 10344 1
- 10610 1
- 10995 1
- 11211 1
- 11353 1
- 11432 1
- 11572 1
- 11703 1
- 11950 1
- 12131 1
- 12314 1
- 12462 1
- 12587 1
- 12748 1
- 12920 1
- 13063 1
- 13221 1
- 13334 1
- 13457 1
- 13575 1
- 13670 1
- 13778 1
- 13899 1
- 13994 1
- 14099 1
- 14225 1
- 14721 1
- 14795 1
- 14857 1
- 14969 1
- 15064 1
- 15170 1
- 15217 1
- 15236 1
- 15271 1
- 15365 1
- 15465 1
- 15518 1
- 15573 1
- 15604 1
- 15627 1
- 15667 1
- 15703 1
- 15739 1
- 15778 1
- 15817 1
- 15829 1
- 15851 1
- 15885 1
- 15920 1
- 15952 1
- 15975 1
- 16028 1
- 16053 1
- 16069 1
- 16088 1
- 16122 1
- 16176 1
- 16210 1
- 16235 1
- 16254 1
- 16283 1
- 16318 1
- 16342 1
- 16379 1
- 16414 1
- 16452 1
- 16469 1
- 16485 1
- 16530 1
- 16564 1
- 16596 1
- 16632 1
- 16710 1
- 16733 1
- 16757 1
- 16784 1
- 16815 1
- 16856 1
- 16883 1
- 16915 1
- 16952 1
- 16990 1
- 17033 1
- 17119 1
- 17169 1
- 17232 1
- 17305 1
- 17386 1
- 17422 1
- 17494 1
- 17571 1
- 17617 1
- 17699 1
- 17789 1
- 17846 1
- 17883 1
- 18125 1
- 18186 1
- 18249 1
- 18291 1
- 18316 1
- 18343 1
- 18382 1
- 18398 1
- 18406 1
- 18431 1
- 18454 1
- 18508 1
- 18510 1
- 18563 1
- 18580 1
- 18628 1
- 18643 1
- 18679 1
- 18680 1
- 18703 1
- 18746 1
- 18756 1
- 18770 1
- 18808 1
- 18815 1
- 18835 1
- 18863 1
- 18872 1
- 18912 1
- 19022 1
- 19074 1
- 19086 1
- 19120 1
- 19305 1
- 19422 1
- 19525 1
- 19637 1
- 19765 1
- 19819 1
- 19921 1
- 20031 1
- 20156 1
- 20257 1
- 20370 1
- 20465 1
- 20617 1
- 20672 1
- 20768 1
- 20835 1
- 20945 1
- 21078 1
- 21193 1
- 21296 1
- 21380 1
- 21516 1
- 21619 1
- 21736 1
- 21865 1
- 22035 1
- 22192 1
- 22315 1
- 22446 1
- 22596 1
- 22739 1
- 22939 1
- 23175 1
- 23296 1
- 23418 1
- 23642 1
- 23861 1
- 24089 1
- 24319 1
- 24500 1
- 24612 1
- 24724 1
- 25065 1
- 25365 1
- 25741 1
- 26137 1
- 26490 1
- 26621 1
- 26889 1
- 27231 1
- 27678 1
- 28045 1
- 28583 1
- 28965 1
- 29209 1
- 29558 1
- 29983 1
- 30381 1
- 30674 1
- 31122 1
- 31725 1
- 32012 1
- 32308 1
- 33663 1
- 34124 1
- 34607 1
- 34835 1
- 35205 1
- 36106 1
- 37476 1
- 38467 1
- 39369 1
- 40305 1
- 40666 1
- 41158 1
- 42222 1
- 43110 1
- 44163 1
- 45050 1
- 45853 1
- 46390 1
- 46814 1
- 47846 1
- 48769 1
- 49616 1
- 50163 1
- 50902 1
- 51523 1
- 51880 1
- 52699 1
- 54530 1
- 54879 1
- 55755 1
- 56247 1
- 57353 1
- 59403 1
- 59763 1
- 60624 1
- 61162 1
- 62272 1
- 63337 1
- 64512 1
- 65536 1
- 66326 1
- 66977 1
- 67475 1
- 68261 1
- 69090 1
- 69855 1
- 70581 1
- 71251 1
- 71592 1
- 71834 1
- 72391 1
- 73092 1
- 73746 1
- 74259 1
- 74753 1
- 75162 1
- 75335 1
- 75810 1
- 76259 1
- 76579 1
- 77085 1
- 77363 1
- 77656 1
- 77815 1
- 78059 1
- 78344 1
- 78729 1
- 79118 1
- 79511 1
- 79678 1
- 79820 1
- 80057 1
- 80361 1
- 80676 1
- 80899 1
- 81114 1
- 81297 1
- 81390 1
- 81593 1
- 81841 1
- 82069 1
- 82291 1
- 82488 1
- 82647 1
- 82754 1
- 83017 1
- 83245 1
- 83447 1
- 83624 1
- 83792 1
- 83903 1
- 83912 1
- 84083 1
- 84220 1
- 84395 1
- 84604 1
- 84740 1
- 84840 1
- 84932 1
- 85100 1
- 85283 1
- 85480 1
- 85661 1
- 85861 1
- 85985 1
- 86094 1
- 86330 1
- 86550 1
- 86803 1
- 87031 1
- 87224 1
- 87351 1
- 87487 1
- 87736 1
- 87984 1
- 88247 1
- 88521 1
- 88703 1
- 88865 1
- 89018 1
- 89306 1
- 89599 1
- 89805 1
- 90423 1
- 90642 1
- 90985 1
- 91238 1
- 91546 1
- 91808 1
- 92025 1
- 92198 1
- 92374 1
- 92620 1
- 92856 1
- 93110 1
- 93317 1
- 93489 1
- 93678 1
- 93795 1
- 94029 1
- 94229 1
- 94408 1
- 94589 1
- 94724 1
- 94838 1
- 94925 1
- 95134 1
- 95316 1
- 95471 1
- 95601 1
- 95677 1
- 95725 1
- 95805 1
- 95948 1
- 96089 1
- 96201 1
- 96304 1
- 96389 1
- 96453 1
- 96471 1
- 96612 1
- 96706 1
- 96751 1
- 96828 1
- 96904 1
- 96949 1
- 96999 1
- 97072 1
- 97154 1
- 97197 1
- 97256 1
- 97317 1
- 97349 1
- 97373 1
- 97450 1
- 97491 1
- 97516 1
- 97549 1
- 97598 1
- 97615 1
- 97652 1
- 97679 1
- 97704 1
- 97722 1
- 97729 1
- 97740 1
- 97759 1
- 97770 1
- 97789 1
- 97803 1
- 97809 1
- 97819 1
- 97835 1
- 97836 1
- 97855 1
- 97869 1
- 97878 1
- 97882 1
- 97894 1
- 97896 1
- 97904 1
- 97916 1
- 97921 1
- 97935 1
- 97941 1
- 97946 1
- 97958 1
- 97969 1
- 97975 1
- 98020 1
- 98030 1
- 98042 1
- 98097 1
- 98112 1
- 98135 1
- 98160 1
- 98239 1
- 98277 1
- 98320 1
- 98358 1
- 98535 1
- 98627 1
- 98685 1
- 98743 1
- 99022 1
- 99113 1
- 99203 1
- 99325 1
- 99715 1
- 99861 1
- 100012 1
- 100161 1
- 100570 1
- 100706 1
- 100883 1
- 101029 1
- 101562 1
- 101701 1
- 101876 1
- 102095 1
- 102705 1
- 102864 1
- 103060 1
- 103291 1
- 104098 1
- 104261 1
- 104488 1
- 105178 1
- 105372 1
- 105695 1
- 105909 1
- 106607 1
- 106751 1
- 106964 1
- 107248 1
- 107994 1
- 108207 1
- 108408 1
- 108596 1
- 109156 1
- 109294 1
- 109518 1
- 109711 1
- 110467 1
- 110662 1
- 110879 1
- 111389 1
- 111618 1
- 111832 1
- 111974 1
- 112528 1
- 112647 1
- 112825 1
- 113000 1
- 113611 1
- 113769 1
- 114001 1
- 114233 1
- 115105 1
- 115314 1
- 117026 1
- 117338 1
- 117844 1
- 118320 1
- 119580 1
- 119955 1
- 121868 1
- 122302 1
- 123013 1
- 123763 1
- 126012 1
- 126527 1
- 127345 1
- 128064 1
- 130107 1
- 130702 1
- 131433 1
- 132127 1
- 134532 1
- 135274 1
- 136197 1
- 137357 1
- 140381 1
- 141523 1
- 143818 1
- 146881 1
- 153925 1
- 155765 1
- 159515 1
- 162507 1
- 173392 1
- 175240 1
- 177805 1
- 180115 1
- 186681 1
- 188286 1
- 189729 1
- 193746 1
- 194465 1
- 195242 1
- 196066 1
- 197960 1
- 198216 1
- 198689 1
- 199114 1
- 199977 1
- 200147 1
- 200370 1
- 200603 1
- 201122 1
- 201252 1
- 201384 1
- 201562 1
- 202013 1
- 202060 1
- 202179 1
- 202395 1
- 202469 1
- 202523 1
- 202589 1
- 202765 1
- 202811 1
- 202872 1
- 202936 1
- 203143 1
- 203192 1
- 203263 1
- 203340 1
- 203572 1
- 203639 1
- 203751 1
- 203865 1
- 204158 1
- 204254 1
- 204374 1
- 204505 1
- 204895 1
- 205012 1
- 205128 1
- 205284 1
- 205824 1
- 205978 1
- 206145 1
- 206382 1
- 207319 1
- 207493 1
- 207770 1
- 208519 1
- 208775 1
- 209027 1
- 209340 1
- 210295 1
- 210536 1
- 210805 1
- 211312 1
- 212536 1
- 212871 1
- 213261 1
- 213890 1
- 214332 1
state 1
- Massachusetts 795
fips 1
- 25009 · 795 ✖
county 1
- Essex 795
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1075 | 1075 | 2020-03-10 | Essex | Massachusetts | 25009 | 1 | 0 |
1255 | 1255 | 2020-03-11 | Essex | Massachusetts | 25009 | 1 | 0 |
1473 | 1473 | 2020-03-12 | Essex | Massachusetts | 25009 | 2 | 0 |
1752 | 1752 | 2020-03-13 | Essex | Massachusetts | 25009 | 2 | 0 |
2095 | 2095 | 2020-03-14 | Essex | Massachusetts | 25009 | 5 | 0 |
2496 | 2496 | 2020-03-15 | Essex | Massachusetts | 25009 | 6 | 0 |
2945 | 2945 | 2020-03-16 | Essex | Massachusetts | 25009 | 7 | 0 |
3446 | 3446 | 2020-03-17 | Essex | Massachusetts | 25009 | 8 | 0 |
4028 | 4028 | 2020-03-18 | Essex | Massachusetts | 25009 | 14 | 0 |
4732 | 4732 | 2020-03-19 | Essex | Massachusetts | 25009 | 19 | 0 |
5551 | 5551 | 2020-03-20 | Essex | Massachusetts | 25009 | 29 | 0 |
6510 | 6510 | 2020-03-21 | Essex | Massachusetts | 25009 | 41 | 0 |
7587 | 7587 | 2020-03-22 | Essex | Massachusetts | 25009 | 60 | 0 |
8759 | 8759 | 2020-03-23 | Essex | Massachusetts | 25009 | 73 | 1 |
10048 | 10048 | 2020-03-24 | Essex | Massachusetts | 25009 | 118 | 1 |
11460 | 11460 | 2020-03-25 | Essex | Massachusetts | 25009 | 177 | 1 |
13041 | 13041 | 2020-03-26 | Essex | Massachusetts | 25009 | 247 | 3 |
14749 | 14749 | 2020-03-27 | Essex | Massachusetts | 25009 | 350 | 3 |
16569 | 16569 | 2020-03-28 | Essex | Massachusetts | 25009 | 472 | 4 |
18484 | 18484 | 2020-03-29 | Essex | Massachusetts | 25009 | 570 | 5 |
20500 | 20500 | 2020-03-30 | Essex | Massachusetts | 25009 | 653 | 7 |
22609 | 22609 | 2020-03-31 | Essex | Massachusetts | 25009 | 784 | 13 |
24788 | 24788 | 2020-04-01 | Essex | Massachusetts | 25009 | 885 | 18 |
27040 | 27040 | 2020-04-02 | Essex | Massachusetts | 25009 | 1039 | 19 |
29358 | 29358 | 2020-04-03 | Essex | Massachusetts | 25009 | 1238 | 24 |
31736 | 31736 | 2020-04-04 | Essex | Massachusetts | 25009 | 1400 | 26 |
34161 | 34161 | 2020-04-05 | Essex | Massachusetts | 25009 | 1506 | 28 |
36620 | 36620 | 2020-04-06 | Essex | Massachusetts | 25009 | 1653 | 31 |
39128 | 39128 | 2020-04-07 | Essex | Massachusetts | 25009 | 1841 | 37 |
41680 | 41680 | 2020-04-08 | Essex | Massachusetts | 25009 | 2103 | 52 |
44256 | 44256 | 2020-04-09 | Essex | Massachusetts | 25009 | 2336 | 61 |
46864 | 46864 | 2020-04-10 | Essex | Massachusetts | 25009 | 2670 | 80 |
49506 | 49506 | 2020-04-11 | Essex | Massachusetts | 25009 | 2896 | 92 |
52176 | 52176 | 2020-04-12 | Essex | Massachusetts | 25009 | 3170 | 102 |
54857 | 54857 | 2020-04-13 | Essex | Massachusetts | 25009 | 3413 | 114 |
57555 | 57555 | 2020-04-14 | Essex | Massachusetts | 25009 | 3594 | 126 |
60264 | 60264 | 2020-04-15 | Essex | Massachusetts | 25009 | 3894 | 141 |
62985 | 62985 | 2020-04-16 | Essex | Massachusetts | 25009 | 4245 | 160 |
65723 | 65723 | 2020-04-17 | Essex | Massachusetts | 25009 | 4584 | 179 |
68473 | 68473 | 2020-04-18 | Essex | Massachusetts | 25009 | 4914 | 194 |
71237 | 71237 | 2020-04-19 | Essex | Massachusetts | 25009 | 5153 | 210 |
74009 | 74009 | 2020-04-20 | Essex | Massachusetts | 25009 | 5296 | 225 |
76789 | 76789 | 2020-04-21 | Essex | Massachusetts | 25009 | 5521 | 245 |
79575 | 79575 | 2020-04-22 | Essex | Massachusetts | 25009 | 5783 | 271 |
82370 | 82370 | 2020-04-23 | Essex | Massachusetts | 25009 | 6219 | 292 |
85174 | 85174 | 2020-04-24 | Essex | Massachusetts | 25009 | 6841 | 319 |
87984 | 87984 | 2020-04-25 | Essex | Massachusetts | 25009 | 7212 | 336 |
90800 | 90800 | 2020-04-26 | Essex | Massachusetts | 25009 | 7489 | 350 |
93621 | 93621 | 2020-04-27 | Essex | Massachusetts | 25009 | 7708 | 359 |
96456 | 96456 | 2020-04-28 | Essex | Massachusetts | 25009 | 7972 | 383 |
99302 | 99302 | 2020-04-29 | Essex | Massachusetts | 25009 | 8380 | 425 |
102154 | 102154 | 2020-04-30 | Essex | Massachusetts | 25009 | 8673 | 448 |
105014 | 105014 | 2020-05-01 | Essex | Massachusetts | 25009 | 9028 | 460 |
107878 | 107878 | 2020-05-02 | Essex | Massachusetts | 25009 | 9362 | 484 |
110750 | 110750 | 2020-05-03 | Essex | Massachusetts | 25009 | 9542 | 499 |
113628 | 113628 | 2020-05-04 | Essex | Massachusetts | 25009 | 9773 | 512 |
116509 | 116509 | 2020-05-05 | Essex | Massachusetts | 25009 | 9979 | 527 |
119470 | 119470 | 2020-05-06 | Essex | Massachusetts | 25009 | 10344 | 561 |
122442 | 122442 | 2020-05-07 | Essex | Massachusetts | 25009 | 10610 | 578 |
125424 | 125424 | 2020-05-08 | Essex | Massachusetts | 25009 | 10995 | 601 |
128411 | 128411 | 2020-05-09 | Essex | Massachusetts | 25009 | 11211 | 625 |
131401 | 131401 | 2020-05-10 | Essex | Massachusetts | 25009 | 11353 | 644 |
134392 | 134392 | 2020-05-11 | Essex | Massachusetts | 25009 | 11432 | 669 |
137382 | 137382 | 2020-05-12 | Essex | Massachusetts | 25009 | 11572 | 678 |
140376 | 140376 | 2020-05-13 | Essex | Massachusetts | 25009 | 11703 | 704 |
143371 | 143371 | 2020-05-14 | Essex | Massachusetts | 25009 | 11950 | 725 |
146371 | 146371 | 2020-05-15 | Essex | Massachusetts | 25009 | 12131 | 751 |
149376 | 149376 | 2020-05-16 | Essex | Massachusetts | 25009 | 12314 | 766 |
152387 | 152387 | 2020-05-17 | Essex | Massachusetts | 25009 | 12462 | 776 |
155401 | 155401 | 2020-05-18 | Essex | Massachusetts | 25009 | 12587 | 790 |
158419 | 158419 | 2020-05-19 | Essex | Massachusetts | 25009 | 12748 | 797 |
161445 | 161445 | 2020-05-20 | Essex | Massachusetts | 25009 | 12920 | 817 |
164474 | 164474 | 2020-05-21 | Essex | Massachusetts | 25009 | 13063 | 831 |
167510 | 167510 | 2020-05-22 | Essex | Massachusetts | 25009 | 13221 | 842 |
170547 | 170547 | 2020-05-23 | Essex | Massachusetts | 25009 | 13334 | 848 |
173589 | 173589 | 2020-05-24 | Essex | Massachusetts | 25009 | 13457 | 859 |
176632 | 176632 | 2020-05-25 | Essex | Massachusetts | 25009 | 13575 | 863 |
179676 | 179676 | 2020-05-26 | Essex | Massachusetts | 25009 | 13670 | 870 |
182722 | 182722 | 2020-05-27 | Essex | Massachusetts | 25009 | 13778 | 878 |
185777 | 185777 | 2020-05-28 | Essex | Massachusetts | 25009 | 13899 | 895 |
188835 | 188835 | 2020-05-29 | Essex | Massachusetts | 25009 | 13994 | 906 |
191899 | 191899 | 2020-05-30 | Essex | Massachusetts | 25009 | 14099 | 909 |
194967 | 194967 | 2020-05-31 | Essex | Massachusetts | 25009 | 14225 | 925 |
198038 | 198038 | 2020-06-01 | Essex | Massachusetts | 25009 | 14721 | 968 |
201110 | 201110 | 2020-06-02 | Essex | Massachusetts | 25009 | 14795 | 971 |
204187 | 204187 | 2020-06-03 | Essex | Massachusetts | 25009 | 14857 | 979 |
207268 | 207268 | 2020-06-04 | Essex | Massachusetts | 25009 | 14969 | 986 |
210349 | 210349 | 2020-06-05 | Essex | Massachusetts | 25009 | 15064 | 990 |
213433 | 213433 | 2020-06-06 | Essex | Massachusetts | 25009 | 15170 | 998 |
216521 | 216521 | 2020-06-07 | Essex | Massachusetts | 25009 | 15217 | 1003 |
219613 | 219613 | 2020-06-08 | Essex | Massachusetts | 25009 | 15236 | 1006 |
222708 | 222708 | 2020-06-09 | Essex | Massachusetts | 25009 | 15271 | 1016 |
225804 | 225804 | 2020-06-10 | Essex | Massachusetts | 25009 | 15365 | 1024 |
228906 | 228906 | 2020-06-11 | Essex | Massachusetts | 25009 | 15465 | 1031 |
232010 | 232010 | 2020-06-12 | Essex | Massachusetts | 25009 | 15518 | 1035 |
235115 | 235115 | 2020-06-13 | Essex | Massachusetts | 25009 | 15573 | 1041 |
238222 | 238222 | 2020-06-14 | Essex | Massachusetts | 25009 | 15604 | 1046 |
241331 | 241331 | 2020-06-15 | Essex | Massachusetts | 25009 | 15627 | 1051 |
244442 | 244442 | 2020-06-16 | Essex | Massachusetts | 25009 | 15667 | 1052 |
247555 | 247555 | 2020-06-17 | Essex | Massachusetts | 25009 | 15703 | 1057 |
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);