ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 49051 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 633 ✖
- 10694 7
- 10707 7
- 10718 7
- 103 4
- 4741 4
- 4825 4
- 5333 4
- 5802 4
- 6926 4
- 7186 4
- 8692 4
- 10584 4
- 10725 4
- 10738 4
- 10766 4
- 658 3
- 4648 3
- 4686 3
- 4759 3
- 4786 3
- 4913 3
- 4990 3
- 5054 3
- 5141 3
- 5234 3
- 5429 3
- 5558 3
- 5648 3
- 5724 3
- 5868 3
- 5956 3
- 6045 3
- 6180 3
- 6366 3
- 6513 3
- 6629 3
- 6734 3
- 6812 3
- 6867 3
- 7880 3
- 9604 3
- 10197 3
- 10413 3
- 10523 3
- 10622 3
- 10641 3
- 10657 3
- 10668 3
- 10682 3
- 10728 3
- 2 2
- 16 2
- 105 2
- 173 2
- 176 2
- 380 2
- 515 2
- 525 2
- 600 2
- 615 2
- 671 2
- 2023 2
- 3013 2
- 3196 2
- 4497 2
- 4534 2
- 4638 2
- 4641 2
- 4661 2
- 4670 2
- 4675 2
- 4685 2
- 4688 2
- 4689 2
- 4705 2
- 4750 2
- 6307 2
- 6602 2
- 10649 2
- 10663 2
- 10755 2
- 10804 2
- 1 1
- 3 1
- 4 1
- 7 1
- 8 1
- 11 1
- 21 1
- 29 1
- 36 1
- 40 1
- 45 1
- 50 1
- 56 1
- 61 1
- 69 1
- 70 1
- 78 1
- 79 1
- 80 1
- 82 1
- 88 1
- 96 1
- 98 1
- 109 1
- 111 1
- 118 1
- 122 1
- 123 1
- 127 1
- 129 1
- 132 1
- 138 1
- 140 1
- 142 1
- 147 1
- 148 1
- 155 1
- 156 1
- 159 1
- 165 1
- 166 1
- 170 1
- 183 1
- 184 1
- 185 1
- 188 1
- 196 1
- 200 1
- 202 1
- 203 1
- 212 1
- 217 1
- 222 1
- 228 1
- 237 1
- 241 1
- 247 1
- 253 1
- 258 1
- 259 1
- 265 1
- 272 1
- 282 1
- 292 1
- 294 1
- 305 1
- 313 1
- 317 1
- 326 1
- 330 1
- 332 1
- 335 1
- 337 1
- 341 1
- 342 1
- 343 1
- 349 1
- 351 1
- 356 1
- 362 1
- 368 1
- 371 1
- 384 1
- 387 1
- 389 1
- 392 1
- 394 1
- 399 1
- 400 1
- 406 1
- 408 1
- 410 1
- 414 1
- 418 1
- 419 1
- 422 1
- 426 1
- 427 1
- 436 1
- 442 1
- 448 1
- 452 1
- 456 1
- 462 1
- 464 1
- 465 1
- 472 1
- 476 1
- 481 1
- 489 1
- 491 1
- 495 1
- 497 1
- 498 1
- 508 1
- 512 1
- 519 1
- 522 1
- 523 1
- 531 1
- 533 1
- 536 1
- 538 1
- 545 1
- 552 1
- 558 1
- 563 1
- 568 1
- 576 1
- 583 1
- 584 1
- 588 1
- 592 1
- 598 1
- 601 1
- 604 1
- 609 1
- 611 1
- 621 1
- 624 1
- 625 1
- 627 1
- 629 1
- 633 1
- 639 1
- 640 1
- 646 1
- 648 1
- 649 1
- 656 1
- 659 1
- 660 1
- 662 1
- 666 1
- 675 1
- 681 1
- 687 1
- 692 1
- 700 1
- 703 1
- 707 1
- 713 1
- 724 1
- 733 1
- 745 1
- 750 1
- 762 1
- 770 1
- 781 1
- 793 1
- 799 1
- 810 1
- 826 1
- 839 1
- 844 1
- 855 1
- 865 1
- 875 1
- 886 1
- 896 1
- 901 1
- 912 1
- 927 1
- 934 1
- 946 1
- 967 1
- 971 1
- 979 1
- 986 1
- 994 1
- 1008 1
- 1020 1
- 1039 1
- 1060 1
- 1081 1
- 1107 1
- 1124 1
- 1145 1
- 1160 1
- 1187 1
- 1204 1
- 1219 1
- 1227 1
- 1259 1
- 1268 1
- 1284 1
- 1317 1
- 1349 1
- 1377 1
- 1401 1
- 1421 1
- 1443 1
- 1498 1
- 1511 1
- 1570 1
- 1601 1
- 1627 1
- 1688 1
- 1726 1
- 1760 1
- 1808 1
- 1844 1
- 1890 1
- 1927 1
- 1970 1
- 2097 1
- 2129 1
- 2147 1
- 2194 1
- 2252 1
- 2323 1
- 2373 1
- 2413 1
- 2455 1
- 2498 1
- 2537 1
- 2553 1
- 2599 1
- 2631 1
- 2666 1
- 2698 1
- 2717 1
- 2753 1
- 2781 1
- 2814 1
- 2830 1
- 2865 1
- 2893 1
- 2904 1
- 2933 1
- 2959 1
- 2998 1
- 3044 1
- 3057 1
- 3088 1
- 3117 1
- 3156 1
- 3247 1
- 3255 1
- 3296 1
- 3317 1
- 3343 1
- 3386 1
- 3442 1
- 3484 1
- 3521 1
- 3539 1
- 3558 1
- 3613 1
- 3654 1
- 3685 1
- 3714 1
- 3736 1
- 3761 1
- 3771 1
- 3814 1
- 3853 1
- 3880 1
- 3906 1
- 3927 1
- 3937 1
- 3961 1
- 3993 1
- 4013 1
- 4036 1
- 4068 1
- 4074 1
- 4091 1
- 4099 1
- 4116 1
- 4126 1
- 4138 1
- 4153 1
- 4157 1
- 4165 1
- 4168 1
- 4184 1
- 4190 1
- 4205 1
- 4210 1
- 4216 1
- 4225 1
- 4235 1
- 4252 1
- 4268 1
- 4273 1
- 4279 1
- 4287 1
- 4290 1
- 4293 1
- 4302 1
- 4307 1
- 4317 1
- 4324 1
- 4328 1
- 4334 1
- 4342 1
- 4352 1
- 4356 1
- 4360 1
- 4368 1
- 4372 1
- 4375 1
- 4381 1
- 4383 1
- 4390 1
- 4396 1
- 4401 1
- 4402 1
- 4406 1
- 4411 1
- 4416 1
- 4424 1
- 4427 1
- 4431 1
- 4432 1
- 4433 1
- 4436 1
- 4442 1
- 4449 1
- 4451 1
- 4460 1
- 4465 1
- 4470 1
- 4473 1
- 4477 1
- 4481 1
- 4485 1
- 4492 1
- 4501 1
- 4515 1
- 4519 1
- 4526 1
- 4530 1
- 4535 1
- 4543 1
- 4545 1
- 4559 1
- 4564 1
- 4568 1
- 4570 1
- 4572 1
- 4574 1
- 4579 1
- 4580 1
- 4585 1
- 4588 1
- 4592 1
- 4596 1
- 4600 1
- 4603 1
- 4607 1
- 4611 1
- 4616 1
- 4619 1
- 4622 1
- 4630 1
- 4636 1
- 4639 1
- 4644 1
- 4645 1
- 4647 1
- 4649 1
- 4653 1
- 4655 1
- 4657 1
- 4658 1
- 4664 1
- 4666 1
- 4667 1
- 4668 1
- 4673 1
- 4683 1
- 4684 1
- 4692 1
- 4697 1
- 4700 1
- 4703 1
- 4707 1
- 4708 1
- 4710 1
- 4711 1
- 4714 1
- 4715 1
- 4717 1
- 4724 1
- 4731 1
- 4733 1
- 4737 1
- 4738 1
- 4753 1
- 4769 1
- 4772 1
- 4775 1
- 4779 1
- 4801 1
- 4804 1
- 4815 1
- 4856 1
- 4875 1
- 4883 1
- 4894 1
- 4950 1
- 4957 1
- 4969 1
- 4986 1
- 5018 1
- 5026 1
- 5040 1
- 5048 1
- 5087 1
- 5096 1
- 5107 1
- 5126 1
- 5184 1
- 5196 1
- 5219 1
- 5230 1
- 5274 1
- 5281 1
- 5297 1
- 5310 1
- 5374 1
- 5397 1
- 5415 1
- 5486 1
- 5506 1
- 5526 1
- 5546 1
- 5594 1
- 5604 1
- 5626 1
- 5642 1
- 5674 1
- 5689 1
- 5699 1
- 5709 1
- 5741 1
- 5762 1
- 5775 1
- 5782 1
- 5827 1
- 5844 1
- 5859 1
- 5900 1
- 5915 1
- 5932 1
- 5941 1
- 5990 1
- 6011 1
- 6018 1
- 6034 1
- 6075 1
- 6107 1
- 6132 1
- 6154 1
- 6236 1
- 6272 1
- 6423 1
- 6451 1
- 6480 1
- 6488 1
- 6564 1
- 6587 1
- 6656 1
- 6685 1
- 6709 1
- 6727 1
- 6772 1
- 6785 1
- 6796 1
- 6804 1
- 6831 1
- 6843 1
- 6853 1
- 6858 1
- 6884 1
- 6898 1
- 6917 1
- 6999 1
- 7058 1
- 7111 1
- 7454 1
- 7540 1
- 7627 1
- 7759 1
- 8206 1
- 8302 1
- 8457 1
- 8618 1
- 9192 1
- 9326 1
- 9469 1
- 9896 1
- 9983 1
- 10075 1
- 10135 1
- 10274 1
- 10310 1
- 10348 1
- 10391 1
- 10466 1
- 10483 1
- 10502 1
- 10514 1
- 10538 1
- 10546 1
- 10560 1
- 10575 1
- 10610 1
- 10614 1
- 10617 1
- 10629 1
- 10632 1
- 10634 1
- 10639 1
- 10647 1
- 10651 1
- 10662 1
- 10667 1
- 10672 1
- 10677 1
- 10679 1
- 10680 1
- 10688 1
- 10689 1
- 10690 1
- 10753 1
- 10781 1
- 10784 1
- 10788 1
state 1
- Utah 789
fips 1
- 49051 · 789 ✖
county 1
- Wasatch 789
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3159 | 3159 | 2020-03-16 | Wasatch | Utah | 49051 | 1 | 0 |
3695 | 3695 | 2020-03-17 | Wasatch | Utah | 49051 | 2 | 0 |
4327 | 4327 | 2020-03-18 | Wasatch | Utah | 49051 | 2 | 0 |
5083 | 5083 | 2020-03-19 | Wasatch | Utah | 49051 | 3 | 0 |
5977 | 5977 | 2020-03-20 | Wasatch | Utah | 49051 | 4 | 0 |
7000 | 7000 | 2020-03-21 | Wasatch | Utah | 49051 | 7 | 0 |
8130 | 8130 | 2020-03-22 | Wasatch | Utah | 49051 | 8 | 0 |
9350 | 9350 | 2020-03-23 | Wasatch | Utah | 49051 | 11 | 0 |
10694 | 10694 | 2020-03-24 | Wasatch | Utah | 49051 | 16 | 0 |
12205 | 12205 | 2020-03-25 | Wasatch | Utah | 49051 | 16 | 0 |
13841 | 13841 | 2020-03-26 | Wasatch | Utah | 49051 | 21 | 0 |
15607 | 15607 | 2020-03-27 | Wasatch | Utah | 49051 | 29 | 0 |
17481 | 17481 | 2020-03-28 | Wasatch | Utah | 49051 | 36 | 0 |
19440 | 19440 | 2020-03-29 | Wasatch | Utah | 49051 | 40 | 0 |
21503 | 21503 | 2020-03-30 | Wasatch | Utah | 49051 | 45 | 0 |
23642 | 23642 | 2020-03-31 | Wasatch | Utah | 49051 | 50 | 0 |
25857 | 25857 | 2020-04-01 | Wasatch | Utah | 49051 | 56 | 0 |
28146 | 28146 | 2020-04-02 | Wasatch | Utah | 49051 | 61 | 0 |
30489 | 30489 | 2020-04-03 | Wasatch | Utah | 49051 | 69 | 0 |
32887 | 32887 | 2020-04-04 | Wasatch | Utah | 49051 | 70 | 0 |
35325 | 35325 | 2020-04-05 | Wasatch | Utah | 49051 | 78 | 0 |
37803 | 37803 | 2020-04-06 | Wasatch | Utah | 49051 | 79 | 0 |
40332 | 40332 | 2020-04-07 | Wasatch | Utah | 49051 | 80 | 0 |
42900 | 42900 | 2020-04-08 | Wasatch | Utah | 49051 | 82 | 0 |
45494 | 45494 | 2020-04-09 | Wasatch | Utah | 49051 | 88 | 0 |
48118 | 48118 | 2020-04-10 | Wasatch | Utah | 49051 | 96 | 0 |
50776 | 50776 | 2020-04-11 | Wasatch | Utah | 49051 | 98 | 1 |
53451 | 53451 | 2020-04-12 | Wasatch | Utah | 49051 | 103 | 1 |
56140 | 56140 | 2020-04-13 | Wasatch | Utah | 49051 | 103 | 1 |
58846 | 58846 | 2020-04-14 | Wasatch | Utah | 49051 | 105 | 1 |
61565 | 61565 | 2020-04-15 | Wasatch | Utah | 49051 | 105 | 1 |
64297 | 64297 | 2020-04-16 | Wasatch | Utah | 49051 | 103 | 1 |
67045 | 67045 | 2020-04-17 | Wasatch | Utah | 49051 | 103 | 1 |
69807 | 69807 | 2020-04-18 | Wasatch | Utah | 49051 | 109 | 1 |
72577 | 72577 | 2020-04-19 | Wasatch | Utah | 49051 | 111 | 1 |
75353 | 75353 | 2020-04-20 | Wasatch | Utah | 49051 | 118 | 1 |
78135 | 78135 | 2020-04-21 | Wasatch | Utah | 49051 | 122 | 1 |
80927 | 80927 | 2020-04-22 | Wasatch | Utah | 49051 | 123 | 1 |
83728 | 83728 | 2020-04-23 | Wasatch | Utah | 49051 | 127 | 1 |
86535 | 86535 | 2020-04-24 | Wasatch | Utah | 49051 | 129 | 1 |
89350 | 89350 | 2020-04-25 | Wasatch | Utah | 49051 | 132 | 1 |
92167 | 92167 | 2020-04-26 | Wasatch | Utah | 49051 | 138 | 1 |
94996 | 94996 | 2020-04-27 | Wasatch | Utah | 49051 | 140 | 1 |
97838 | 97838 | 2020-04-28 | Wasatch | Utah | 49051 | 142 | 1 |
100688 | 100688 | 2020-04-29 | Wasatch | Utah | 49051 | 147 | 1 |
103543 | 103543 | 2020-04-30 | Wasatch | Utah | 49051 | 148 | 1 |
106407 | 106407 | 2020-05-01 | Wasatch | Utah | 49051 | 155 | 1 |
109276 | 109276 | 2020-05-02 | Wasatch | Utah | 49051 | 156 | 1 |
112150 | 112150 | 2020-05-03 | Wasatch | Utah | 49051 | 159 | 1 |
115033 | 115033 | 2020-05-04 | Wasatch | Utah | 49051 | 165 | 1 |
117992 | 117992 | 2020-05-05 | Wasatch | Utah | 49051 | 166 | 1 |
120956 | 120956 | 2020-05-06 | Wasatch | Utah | 49051 | 170 | 1 |
123937 | 123937 | 2020-05-07 | Wasatch | Utah | 49051 | 173 | 1 |
126922 | 126922 | 2020-05-08 | Wasatch | Utah | 49051 | 173 | 1 |
129911 | 129911 | 2020-05-09 | Wasatch | Utah | 49051 | 176 | 1 |
132901 | 132901 | 2020-05-10 | Wasatch | Utah | 49051 | 176 | 1 |
135891 | 135891 | 2020-05-11 | Wasatch | Utah | 49051 | 183 | 1 |
138882 | 138882 | 2020-05-12 | Wasatch | Utah | 49051 | 184 | 1 |
141878 | 141878 | 2020-05-13 | Wasatch | Utah | 49051 | 185 | 1 |
144875 | 144875 | 2020-05-14 | Wasatch | Utah | 49051 | 188 | 1 |
147878 | 147878 | 2020-05-15 | Wasatch | Utah | 49051 | 196 | 1 |
150887 | 150887 | 2020-05-16 | Wasatch | Utah | 49051 | 200 | 1 |
153898 | 153898 | 2020-05-17 | Wasatch | Utah | 49051 | 202 | 1 |
156915 | 156915 | 2020-05-18 | Wasatch | Utah | 49051 | 203 | 1 |
159939 | 159939 | 2020-05-19 | Wasatch | Utah | 49051 | 212 | 1 |
162967 | 162967 | 2020-05-20 | Wasatch | Utah | 49051 | 217 | 1 |
165996 | 165996 | 2020-05-21 | Wasatch | Utah | 49051 | 222 | 1 |
169032 | 169032 | 2020-05-22 | Wasatch | Utah | 49051 | 228 | 1 |
172073 | 172073 | 2020-05-23 | Wasatch | Utah | 49051 | 237 | 1 |
175116 | 175116 | 2020-05-24 | Wasatch | Utah | 49051 | 241 | 1 |
178161 | 178161 | 2020-05-25 | Wasatch | Utah | 49051 | 247 | 1 |
181205 | 181205 | 2020-05-26 | Wasatch | Utah | 49051 | 253 | 1 |
184256 | 184256 | 2020-05-27 | Wasatch | Utah | 49051 | 258 | 1 |
187313 | 187313 | 2020-05-28 | Wasatch | Utah | 49051 | 259 | 1 |
190377 | 190377 | 2020-05-29 | Wasatch | Utah | 49051 | 265 | 1 |
193443 | 193443 | 2020-05-30 | Wasatch | Utah | 49051 | 272 | 1 |
196513 | 196513 | 2020-05-31 | Wasatch | Utah | 49051 | 282 | 2 |
199586 | 199586 | 2020-06-01 | Wasatch | Utah | 49051 | 292 | 2 |
202662 | 202662 | 2020-06-02 | Wasatch | Utah | 49051 | 294 | 2 |
205741 | 205741 | 2020-06-03 | Wasatch | Utah | 49051 | 305 | 2 |
208823 | 208823 | 2020-06-04 | Wasatch | Utah | 49051 | 313 | 2 |
211908 | 211908 | 2020-06-05 | Wasatch | Utah | 49051 | 317 | 2 |
214995 | 214995 | 2020-06-06 | Wasatch | Utah | 49051 | 326 | 2 |
218085 | 218085 | 2020-06-07 | Wasatch | Utah | 49051 | 330 | 2 |
221177 | 221177 | 2020-06-08 | Wasatch | Utah | 49051 | 332 | 2 |
224273 | 224273 | 2020-06-09 | Wasatch | Utah | 49051 | 335 | 2 |
227373 | 227373 | 2020-06-10 | Wasatch | Utah | 49051 | 337 | 2 |
230477 | 230477 | 2020-06-11 | Wasatch | Utah | 49051 | 341 | 2 |
233582 | 233582 | 2020-06-12 | Wasatch | Utah | 49051 | 342 | 2 |
236689 | 236689 | 2020-06-13 | Wasatch | Utah | 49051 | 343 | 2 |
239797 | 239797 | 2020-06-14 | Wasatch | Utah | 49051 | 349 | 2 |
242908 | 242908 | 2020-06-15 | Wasatch | Utah | 49051 | 351 | 2 |
246020 | 246020 | 2020-06-16 | Wasatch | Utah | 49051 | 356 | 2 |
249132 | 249132 | 2020-06-17 | Wasatch | Utah | 49051 | 362 | 2 |
252247 | 252247 | 2020-06-18 | Wasatch | Utah | 49051 | 368 | 2 |
255365 | 255365 | 2020-06-19 | Wasatch | Utah | 49051 | 371 | 3 |
258492 | 258492 | 2020-06-20 | Wasatch | Utah | 49051 | 380 | 3 |
261619 | 261619 | 2020-06-21 | Wasatch | Utah | 49051 | 380 | 3 |
264748 | 264748 | 2020-06-22 | Wasatch | Utah | 49051 | 384 | 3 |
267877 | 267877 | 2020-06-23 | Wasatch | Utah | 49051 | 387 | 3 |
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);