ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39077 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 654 ✖
- 14439 7
- 14454 7
- 14468 7
- 14484 7
- 14494 7
- 14520 7
- 14535 7
- 14567 7
- 1 6
- 3 5
- 462 5
- 5577 5
- 14 4
- 5539 4
- 14432 4
- 4 3
- 10 3
- 16 3
- 29 3
- 38 3
- 39 3
- 55 3
- 60 3
- 5498 3
- 5600 3
- 5602 3
- 2 2
- 6 2
- 9 2
- 15 2
- 25 2
- 30 2
- 31 2
- 34 2
- 40 2
- 56 2
- 61 2
- 63 2
- 64 2
- 77 2
- 177 2
- 418 2
- 425 2
- 493 2
- 520 2
- 542 2
- 629 2
- 1555 2
- 3136 2
- 3389 2
- 5159 2
- 5307 2
- 5544 2
- 5546 2
- 5569 2
- 5624 2
- 9480 2
- 10832 2
- 11334 2
- 14250 2
- 14343 2
- 14404 2
- 14626 2
- 5 1
- 20 1
- 23 1
- 24 1
- 27 1
- 28 1
- 32 1
- 33 1
- 37 1
- 41 1
- 42 1
- 43 1
- 44 1
- 46 1
- 48 1
- 49 1
- 52 1
- 57 1
- 58 1
- 62 1
- 71 1
- 72 1
- 74 1
- 79 1
- 81 1
- 95 1
- 96 1
- 97 1
- 110 1
- 122 1
- 127 1
- 129 1
- 144 1
- 147 1
- 153 1
- 159 1
- 165 1
- 170 1
- 199 1
- 211 1
- 215 1
- 220 1
- 223 1
- 228 1
- 234 1
- 238 1
- 240 1
- 247 1
- 260 1
- 264 1
- 271 1
- 275 1
- 278 1
- 284 1
- 290 1
- 303 1
- 309 1
- 311 1
- 317 1
- 320 1
- 328 1
- 329 1
- 334 1
- 343 1
- 349 1
- 359 1
- 368 1
- 369 1
- 371 1
- 376 1
- 378 1
- 383 1
- 388 1
- 393 1
- 395 1
- 396 1
- 401 1
- 404 1
- 411 1
- 413 1
- 414 1
- 420 1
- 423 1
- 459 1
- 465 1
- 468 1
- 469 1
- 470 1
- 475 1
- 479 1
- 481 1
- 483 1
- 487 1
- 495 1
- 496 1
- 498 1
- 499 1
- 502 1
- 504 1
- 505 1
- 509 1
- 512 1
- 517 1
- 521 1
- 523 1
- 530 1
- 533 1
- 538 1
- 546 1
- 551 1
- 555 1
- 572 1
- 588 1
- 598 1
- 606 1
- 608 1
- 612 1
- 618 1
- 636 1
- 641 1
- 643 1
- 646 1
- 654 1
- 664 1
- 674 1
- 680 1
- 682 1
- 687 1
- 690 1
- 698 1
- 699 1
- 706 1
- 709 1
- 716 1
- 719 1
- 723 1
- 729 1
- 737 1
- 741 1
- 752 1
- 765 1
- 769 1
- 773 1
- 784 1
- 797 1
- 817 1
- 839 1
- 859 1
- 880 1
- 888 1
- 913 1
- 940 1
- 976 1
- 1011 1
- 1043 1
- 1067 1
- 1107 1
- 1147 1
- 1186 1
- 1219 1
- 1263 1
- 1325 1
- 1359 1
- 1392 1
- 1475 1
- 1523 1
- 1630 1
- 1697 1
- 1727 1
- 1741 1
- 1781 1
- 1809 1
- 1854 1
- 1899 1
- 1956 1
- 1981 1
- 2012 1
- 2351 1
- 2395 1
- 2468 1
- 2511 1
- 2548 1
- 2581 1
- 2630 1
- 2701 1
- 2712 1
- 2761 1
- 2856 1
- 2905 1
- 2936 1
- 2995 1
- 3027 1
- 3062 1
- 3176 1
- 3196 1
- 3210 1
- 3261 1
- 3311 1
- 3444 1
- 3472 1
- 3494 1
- 3538 1
- 3582 1
- 3664 1
- 3734 1
- 3773 1
- 3804 1
- 3861 1
- 3914 1
- 3945 1
- 3997 1
- 4037 1
- 4091 1
- 4103 1
- 4136 1
- 4161 1
- 4193 1
- 4235 1
- 4254 1
- 4287 1
- 4300 1
- 4328 1
- 4355 1
- 4377 1
- 4400 1
- 4424 1
- 4441 1
- 4447 1
- 4468 1
- 4482 1
- 4493 1
- 4510 1
- 4542 1
- 4559 1
- 4561 1
- 4567 1
- 4570 1
- 4584 1
- 4593 1
- 4609 1
- 4615 1
- 4618 1
- 4625 1
- 4628 1
- 4637 1
- 4652 1
- 4663 1
- 4670 1
- 4675 1
- 4691 1
- 4701 1
- 4722 1
- 4745 1
- 4761 1
- 4776 1
- 4781 1
- 4797 1
- 4807 1
- 4825 1
- 4838 1
- 4848 1
- 4859 1
- 4862 1
- 4869 1
- 4881 1
- 4895 1
- 4908 1
- 4919 1
- 4925 1
- 4928 1
- 4945 1
- 4957 1
- 4963 1
- 4979 1
- 4982 1
- 4993 1
- 4998 1
- 5024 1
- 5037 1
- 5063 1
- 5078 1
- 5094 1
- 5105 1
- 5108 1
- 5115 1
- 5132 1
- 5139 1
- 5147 1
- 5152 1
- 5167 1
- 5178 1
- 5190 1
- 5204 1
- 5219 1
- 5229 1
- 5237 1
- 5247 1
- 5257 1
- 5265 1
- 5270 1
- 5298 1
- 5314 1
- 5326 1
- 5333 1
- 5341 1
- 5346 1
- 5351 1
- 5353 1
- 5360 1
- 5371 1
- 5375 1
- 5384 1
- 5390 1
- 5397 1
- 5403 1
- 5406 1
- 5409 1
- 5419 1
- 5422 1
- 5427 1
- 5430 1
- 5431 1
- 5435 1
- 5439 1
- 5443 1
- 5446 1
- 5453 1
- 5455 1
- 5457 1
- 5462 1
- 5469 1
- 5473 1
- 5477 1
- 5479 1
- 5482 1
- 5484 1
- 5485 1
- 5488 1
- 5491 1
- 5494 1
- 5496 1
- 5499 1
- 5501 1
- 5504 1
- 5510 1
- 5518 1
- 5519 1
- 5520 1
- 5522 1
- 5525 1
- 5531 1
- 5537 1
- 5541 1
- 5547 1
- 5550 1
- 5554 1
- 5555 1
- 5556 1
- 5560 1
- 5562 1
- 5564 1
- 5572 1
- 5575 1
- 5580 1
- 5587 1
- 5589 1
- 5591 1
- 5592 1
- 5596 1
- 5607 1
- 5613 1
- 5618 1
- 5622 1
- 5630 1
- 5638 1
- 5644 1
- 5654 1
- 5658 1
- 5664 1
- 5666 1
- 5671 1
- 5678 1
- 5697 1
- 5705 1
- 5727 1
- 5742 1
- 5750 1
- 5762 1
- 5773 1
- 5790 1
- 5813 1
- 5827 1
- 5848 1
- 5859 1
- 5874 1
- 5894 1
- 5921 1
- 5954 1
- 5982 1
- 6009 1
- 6049 1
- 6062 1
- 6102 1
- 6139 1
- 6195 1
- 6224 1
- 6250 1
- 6291 1
- 6314 1
- 6359 1
- 6403 1
- 6453 1
- 6504 1
- 6552 1
- 6596 1
- 6634 1
- 6650 1
- 6710 1
- 6786 1
- 6843 1
- 6887 1
- 6920 1
- 6983 1
- 7020 1
- 7087 1
- 7143 1
- 7210 1
- 7253 1
- 7279 1
- 7309 1
- 7366 1
- 7423 1
- 7476 1
- 7507 1
- 7537 1
- 7566 1
- 7598 1
- 7651 1
- 7686 1
- 7721 1
- 7749 1
- 7791 1
- 7812 1
- 7830 1
- 7862 1
- 7900 1
- 7933 1
- 7978 1
- 7997 1
- 8013 1
- 8031 1
- 8068 1
- 8102 1
- 8143 1
- 8172 1
- 8193 1
- 8209 1
- 8229 1
- 8256 1
- 8295 1
- 8338 1
- 8380 1
- 8404 1
- 8412 1
- 8427 1
- 8465 1
- 8510 1
- 8545 1
- 8590 1
- 8619 1
- 8633 1
- 8648 1
- 8684 1
- 8720 1
- 8748 1
- 8790 1
- 8805 1
- 8831 1
- 8857 1
- 8888 1
- 8934 1
- 8973 1
- 9013 1
- 9036 1
- 9062 1
- 9097 1
- 9146 1
- 9186 1
- 9243 1
- 9309 1
- 9346 1
- 9359 1
- 9384 1
- 9441 1
- 9519 1
- 9545 1
- 9560 1
- 9588 1
- 9633 1
- 9692 1
- 9765 1
- 9805 1
- 9839 1
- 9867 1
- 9891 1
- 9939 1
- 10000 1
- 10066 1
- 10117 1
- 10161 1
- 10182 1
- 10212 1
- 10261 1
- 10319 1
- 10387 1
- 10458 1
- 10493 1
- 10525 1
- 10555 1
- 10624 1
- 10707 1
- 10784 1
- 10922 1
- 10954 1
- 11024 1
- 11138 1
- 11219 1
- 11580 1
- 11703 1
- 11774 1
- 11881 1
- 12009 1
- 12110 1
- 12217 1
- 12298 1
- 12408 1
- 12505 1
- 12686 1
- 12763 1
- 13030 1
- 13238 1
- 13341 1
- 13399 1
- 13460 1
- 13584 1
- 13682 1
- 13768 1
- 13838 1
- 13870 1
- 13908 1
- 13938 1
- 13984 1
- 14032 1
- 14072 1
- 14111 1
- 14131 1
- 14141 1
- 14163 1
- 14189 1
- 14213 1
- 14230 1
- 14239 1
- 14242 1
- 14257 1
- 14270 1
- 14295 1
- 14297 1
- 14300 1
- 14309 1
- 14313 1
- 14321 1
- 14327 1
- 14333 1
- 14338 1
- 14348 1
- 14360 1
- 14364 1
- 14370 1
- 14371 1
- 14379 1
- 14382 1
- 14388 1
- 14391 1
- 14394 1
- 14397 1
- 14401 1
- 14420 1
- 14424 1
- 14428 1
- 14429 1
- 14430 1
state 1
- Ohio 787
fips 1
- 39077 · 787 ✖
county 1
- Huron 787
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
4205 | 4205 | 2020-03-18 | Huron | Ohio | 39077 | 1 | 0 |
4937 | 4937 | 2020-03-19 | Huron | Ohio | 39077 | 1 | 0 |
5800 | 5800 | 2020-03-20 | Huron | Ohio | 39077 | 1 | 0 |
6800 | 6800 | 2020-03-21 | Huron | Ohio | 39077 | 1 | 0 |
7911 | 7911 | 2020-03-22 | Huron | Ohio | 39077 | 1 | 0 |
9114 | 9114 | 2020-03-23 | Huron | Ohio | 39077 | 1 | 0 |
10430 | 10430 | 2020-03-24 | Huron | Ohio | 39077 | 2 | 0 |
11878 | 11878 | 2020-03-25 | Huron | Ohio | 39077 | 2 | 0 |
13485 | 13485 | 2020-03-26 | Huron | Ohio | 39077 | 3 | 0 |
15223 | 15223 | 2020-03-27 | Huron | Ohio | 39077 | 3 | 0 |
17065 | 17065 | 2020-03-28 | Huron | Ohio | 39077 | 3 | 0 |
18999 | 18999 | 2020-03-29 | Huron | Ohio | 39077 | 3 | 0 |
21044 | 21044 | 2020-03-30 | Huron | Ohio | 39077 | 3 | 1 |
23176 | 23176 | 2020-03-31 | Huron | Ohio | 39077 | 4 | 1 |
25371 | 25371 | 2020-04-01 | Huron | Ohio | 39077 | 4 | 1 |
27639 | 27639 | 2020-04-02 | Huron | Ohio | 39077 | 4 | 1 |
29968 | 29968 | 2020-04-03 | Huron | Ohio | 39077 | 5 | 1 |
32357 | 32357 | 2020-04-04 | Huron | Ohio | 39077 | 6 | 1 |
34790 | 34790 | 2020-04-05 | Huron | Ohio | 39077 | 6 | 1 |
37259 | 37259 | 2020-04-06 | Huron | Ohio | 39077 | 9 | 1 |
39776 | 39776 | 2020-04-07 | Huron | Ohio | 39077 | 10 | 1 |
42335 | 42335 | 2020-04-08 | Huron | Ohio | 39077 | 9 | 1 |
44920 | 44920 | 2020-04-09 | Huron | Ohio | 39077 | 10 | 1 |
47535 | 47535 | 2020-04-10 | Huron | Ohio | 39077 | 10 | 1 |
50191 | 50191 | 2020-04-11 | Huron | Ohio | 39077 | 15 | 1 |
52864 | 52864 | 2020-04-12 | Huron | Ohio | 39077 | 14 | 1 |
55548 | 55548 | 2020-04-13 | Huron | Ohio | 39077 | 14 | 1 |
58249 | 58249 | 2020-04-14 | Huron | Ohio | 39077 | 14 | 1 |
60964 | 60964 | 2020-04-15 | Huron | Ohio | 39077 | 14 | 1 |
63690 | 63690 | 2020-04-16 | Huron | Ohio | 39077 | 16 | 1 |
66433 | 66433 | 2020-04-17 | Huron | Ohio | 39077 | 16 | 1 |
69190 | 69190 | 2020-04-18 | Huron | Ohio | 39077 | 15 | 1 |
71957 | 71957 | 2020-04-19 | Huron | Ohio | 39077 | 16 | 1 |
74732 | 74732 | 2020-04-20 | Huron | Ohio | 39077 | 20 | 1 |
77513 | 77513 | 2020-04-21 | Huron | Ohio | 39077 | 23 | 1 |
80303 | 80303 | 2020-04-22 | Huron | Ohio | 39077 | 25 | 2 |
83102 | 83102 | 2020-04-23 | Huron | Ohio | 39077 | 24 | 1 |
85906 | 85906 | 2020-04-24 | Huron | Ohio | 39077 | 25 | 1 |
88720 | 88720 | 2020-04-25 | Huron | Ohio | 39077 | 27 | 1 |
91536 | 91536 | 2020-04-26 | Huron | Ohio | 39077 | 28 | 1 |
94362 | 94362 | 2020-04-27 | Huron | Ohio | 39077 | 29 | 1 |
97199 | 97199 | 2020-04-28 | Huron | Ohio | 39077 | 30 | 1 |
100048 | 100048 | 2020-04-29 | Huron | Ohio | 39077 | 30 | 1 |
102901 | 102901 | 2020-04-30 | Huron | Ohio | 39077 | 29 | 1 |
105764 | 105764 | 2020-05-01 | Huron | Ohio | 39077 | 29 | 1 |
108631 | 108631 | 2020-05-02 | Huron | Ohio | 39077 | 31 | 1 |
111505 | 111505 | 2020-05-03 | Huron | Ohio | 39077 | 31 | 1 |
114386 | 114386 | 2020-05-04 | Huron | Ohio | 39077 | 32 | 1 |
117267 | 117267 | 2020-05-05 | Huron | Ohio | 39077 | 33 | 1 |
120228 | 120228 | 2020-05-06 | Huron | Ohio | 39077 | 34 | 1 |
123205 | 123205 | 2020-05-07 | Huron | Ohio | 39077 | 34 | 1 |
126188 | 126188 | 2020-05-08 | Huron | Ohio | 39077 | 37 | 1 |
129177 | 129177 | 2020-05-09 | Huron | Ohio | 39077 | 38 | 1 |
132166 | 132166 | 2020-05-10 | Huron | Ohio | 39077 | 38 | 1 |
135157 | 135157 | 2020-05-11 | Huron | Ohio | 39077 | 38 | 1 |
138147 | 138147 | 2020-05-12 | Huron | Ohio | 39077 | 39 | 1 |
141143 | 141143 | 2020-05-13 | Huron | Ohio | 39077 | 39 | 1 |
144138 | 144138 | 2020-05-14 | Huron | Ohio | 39077 | 40 | 1 |
147139 | 147139 | 2020-05-15 | Huron | Ohio | 39077 | 39 | 1 |
150146 | 150146 | 2020-05-16 | Huron | Ohio | 39077 | 40 | 1 |
153157 | 153157 | 2020-05-17 | Huron | Ohio | 39077 | 41 | 1 |
156174 | 156174 | 2020-05-18 | Huron | Ohio | 39077 | 42 | 1 |
159194 | 159194 | 2020-05-19 | Huron | Ohio | 39077 | 43 | 1 |
162221 | 162221 | 2020-05-20 | Huron | Ohio | 39077 | 44 | 1 |
165250 | 165250 | 2020-05-21 | Huron | Ohio | 39077 | 46 | 1 |
168286 | 168286 | 2020-05-22 | Huron | Ohio | 39077 | 48 | 1 |
171325 | 171325 | 2020-05-23 | Huron | Ohio | 39077 | 49 | 1 |
174367 | 174367 | 2020-05-24 | Huron | Ohio | 39077 | 52 | 1 |
177411 | 177411 | 2020-05-25 | Huron | Ohio | 39077 | 55 | 1 |
180454 | 180454 | 2020-05-26 | Huron | Ohio | 39077 | 55 | 1 |
183503 | 183503 | 2020-05-27 | Huron | Ohio | 39077 | 55 | 1 |
186560 | 186560 | 2020-05-28 | Huron | Ohio | 39077 | 56 | 1 |
189620 | 189620 | 2020-05-29 | Huron | Ohio | 39077 | 56 | 1 |
192684 | 192684 | 2020-05-30 | Huron | Ohio | 39077 | 57 | 1 |
195754 | 195754 | 2020-05-31 | Huron | Ohio | 39077 | 58 | 1 |
198827 | 198827 | 2020-06-01 | Huron | Ohio | 39077 | 60 | 1 |
201902 | 201902 | 2020-06-02 | Huron | Ohio | 39077 | 60 | 1 |
204979 | 204979 | 2020-06-03 | Huron | Ohio | 39077 | 60 | 1 |
208060 | 208060 | 2020-06-04 | Huron | Ohio | 39077 | 61 | 1 |
211142 | 211142 | 2020-06-05 | Huron | Ohio | 39077 | 61 | 1 |
214228 | 214228 | 2020-06-06 | Huron | Ohio | 39077 | 62 | 1 |
217318 | 217318 | 2020-06-07 | Huron | Ohio | 39077 | 63 | 1 |
220410 | 220410 | 2020-06-08 | Huron | Ohio | 39077 | 63 | 1 |
223505 | 223505 | 2020-06-09 | Huron | Ohio | 39077 | 64 | 1 |
226605 | 226605 | 2020-06-10 | Huron | Ohio | 39077 | 64 | 1 |
229709 | 229709 | 2020-06-11 | Huron | Ohio | 39077 | 71 | 1 |
232814 | 232814 | 2020-06-12 | Huron | Ohio | 39077 | 72 | 1 |
235919 | 235919 | 2020-06-13 | Huron | Ohio | 39077 | 74 | 1 |
239027 | 239027 | 2020-06-14 | Huron | Ohio | 39077 | 77 | 1 |
242136 | 242136 | 2020-06-15 | Huron | Ohio | 39077 | 77 | 1 |
245248 | 245248 | 2020-06-16 | Huron | Ohio | 39077 | 79 | 1 |
248361 | 248361 | 2020-06-17 | Huron | Ohio | 39077 | 81 | 1 |
251476 | 251476 | 2020-06-18 | Huron | Ohio | 39077 | 95 | 1 |
254591 | 254591 | 2020-06-19 | Huron | Ohio | 39077 | 96 | 1 |
257716 | 257716 | 2020-06-20 | Huron | Ohio | 39077 | 97 | 1 |
260843 | 260843 | 2020-06-21 | Huron | Ohio | 39077 | 110 | 1 |
263971 | 263971 | 2020-06-22 | Huron | Ohio | 39077 | 122 | 1 |
267099 | 267099 | 2020-06-23 | Huron | Ohio | 39077 | 127 | 1 |
270233 | 270233 | 2020-06-24 | Huron | Ohio | 39077 | 129 | 1 |
273372 | 273372 | 2020-06-25 | Huron | Ohio | 39077 | 144 | 1 |
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);