ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
328 rows where fips = 49035 sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
939636 | 939636 | 2021-01-17 | Salt Lake | Utah | 49035 | 122400 | 624 |
936391 | 936391 | 2021-01-16 | Salt Lake | Utah | 49035 | 121741 | 624 |
933146 | 933146 | 2021-01-15 | Salt Lake | Utah | 49035 | 121050 | 622 |
929901 | 929901 | 2021-01-14 | Salt Lake | Utah | 49035 | 120091 | 615 |
926656 | 926656 | 2021-01-13 | Salt Lake | Utah | 49035 | 119222 | 612 |
923410 | 923410 | 2021-01-12 | Salt Lake | Utah | 49035 | 118431 | 610 |
920165 | 920165 | 2021-01-11 | Salt Lake | Utah | 49035 | 117670 | 600 |
916920 | 916920 | 2021-01-10 | Salt Lake | Utah | 49035 | 117126 | 599 |
913675 | 913675 | 2021-01-09 | Salt Lake | Utah | 49035 | 116220 | 599 |
910430 | 910430 | 2021-01-08 | Salt Lake | Utah | 49035 | 115315 | 594 |
907185 | 907185 | 2021-01-07 | Salt Lake | Utah | 49035 | 114097 | 583 |
903939 | 903939 | 2021-01-06 | Salt Lake | Utah | 49035 | 112552 | 571 |
900694 | 900694 | 2021-01-05 | Salt Lake | Utah | 49035 | 111389 | 564 |
897449 | 897449 | 2021-01-04 | Salt Lake | Utah | 49035 | 110242 | 563 |
894203 | 894203 | 2021-01-03 | Salt Lake | Utah | 49035 | 109533 | 561 |
890957 | 890957 | 2021-01-02 | Salt Lake | Utah | 49035 | 108971 | 560 |
887710 | 887710 | 2021-01-01 | Salt Lake | Utah | 49035 | 107386 | 554 |
884465 | 884465 | 2020-12-31 | Salt Lake | Utah | 49035 | 107386 | 554 |
881220 | 881220 | 2020-12-30 | Salt Lake | Utah | 49035 | 105933 | 551 |
877975 | 877975 | 2020-12-29 | Salt Lake | Utah | 49035 | 105026 | 542 |
874730 | 874730 | 2020-12-28 | Salt Lake | Utah | 49035 | 104167 | 536 |
871485 | 871485 | 2020-12-27 | Salt Lake | Utah | 49035 | 103615 | 535 |
868240 | 868240 | 2020-12-26 | Salt Lake | Utah | 49035 | 103313 | 533 |
864995 | 864995 | 2020-12-25 | Salt Lake | Utah | 49035 | 102160 | 532 |
861750 | 861750 | 2020-12-24 | Salt Lake | Utah | 49035 | 102160 | 532 |
858505 | 858505 | 2020-12-23 | Salt Lake | Utah | 49035 | 101258 | 527 |
855260 | 855260 | 2020-12-22 | Salt Lake | Utah | 49035 | 100482 | 516 |
852015 | 852015 | 2020-12-21 | Salt Lake | Utah | 49035 | 99874 | 512 |
848770 | 848770 | 2020-12-20 | Salt Lake | Utah | 49035 | 99234 | 509 |
845525 | 845525 | 2020-12-19 | Salt Lake | Utah | 49035 | 98563 | 507 |
842279 | 842279 | 2020-12-18 | Salt Lake | Utah | 49035 | 97748 | 502 |
839034 | 839034 | 2020-12-17 | Salt Lake | Utah | 49035 | 96864 | 497 |
835788 | 835788 | 2020-12-16 | Salt Lake | Utah | 49035 | 95917 | 488 |
832542 | 832542 | 2020-12-15 | Salt Lake | Utah | 49035 | 94942 | 477 |
829295 | 829295 | 2020-12-14 | Salt Lake | Utah | 49035 | 94415 | 474 |
826049 | 826049 | 2020-12-13 | Salt Lake | Utah | 49035 | 93761 | 473 |
822802 | 822802 | 2020-12-12 | Salt Lake | Utah | 49035 | 93065 | 467 |
819556 | 819556 | 2020-12-11 | Salt Lake | Utah | 49035 | 91795 | 465 |
816310 | 816310 | 2020-12-10 | Salt Lake | Utah | 49035 | 91056 | 460 |
813064 | 813064 | 2020-12-09 | Salt Lake | Utah | 49035 | 89832 | 448 |
809820 | 809820 | 2020-12-08 | Salt Lake | Utah | 49035 | 88921 | 442 |
806575 | 806575 | 2020-12-07 | Salt Lake | Utah | 49035 | 88184 | 431 |
803330 | 803330 | 2020-12-06 | Salt Lake | Utah | 49035 | 87328 | 428 |
800084 | 800084 | 2020-12-05 | Salt Lake | Utah | 49035 | 86339 | 428 |
796838 | 796838 | 2020-12-04 | Salt Lake | Utah | 49035 | 85082 | 422 |
793593 | 793593 | 2020-12-03 | Salt Lake | Utah | 49035 | 84141 | 416 |
790347 | 790347 | 2020-12-02 | Salt Lake | Utah | 49035 | 82813 | 411 |
787101 | 787101 | 2020-12-01 | Salt Lake | Utah | 49035 | 81337 | 407 |
783857 | 783857 | 2020-11-30 | Salt Lake | Utah | 49035 | 80533 | 402 |
780612 | 780612 | 2020-11-29 | Salt Lake | Utah | 49035 | 79836 | 402 |
777366 | 777366 | 2020-11-28 | Salt Lake | Utah | 49035 | 79227 | 401 |
774120 | 774120 | 2020-11-27 | Salt Lake | Utah | 49035 | 78530 | 394 |
770875 | 770875 | 2020-11-26 | Salt Lake | Utah | 49035 | 76220 | 390 |
767628 | 767628 | 2020-11-25 | Salt Lake | Utah | 49035 | 76220 | 390 |
764382 | 764382 | 2020-11-24 | Salt Lake | Utah | 49035 | 75458 | 383 |
761136 | 761136 | 2020-11-23 | Salt Lake | Utah | 49035 | 74269 | 382 |
757890 | 757890 | 2020-11-22 | Salt Lake | Utah | 49035 | 73469 | 380 |
754643 | 754643 | 2020-11-21 | Salt Lake | Utah | 49035 | 72206 | 378 |
751396 | 751396 | 2020-11-20 | Salt Lake | Utah | 49035 | 71088 | 371 |
748149 | 748149 | 2020-11-19 | Salt Lake | Utah | 49035 | 69503 | 364 |
744902 | 744902 | 2020-11-18 | Salt Lake | Utah | 49035 | 67942 | 360 |
741655 | 741655 | 2020-11-17 | Salt Lake | Utah | 49035 | 66727 | 356 |
738408 | 738408 | 2020-11-16 | Salt Lake | Utah | 49035 | 65681 | 353 |
735163 | 735163 | 2020-11-15 | Salt Lake | Utah | 49035 | 64794 | 351 |
731917 | 731917 | 2020-11-14 | Salt Lake | Utah | 49035 | 63768 | 350 |
728672 | 728672 | 2020-11-13 | Salt Lake | Utah | 49035 | 61673 | 348 |
725428 | 725428 | 2020-11-12 | Salt Lake | Utah | 49035 | 60859 | 342 |
722184 | 722184 | 2020-11-11 | Salt Lake | Utah | 49035 | 59493 | 339 |
718940 | 718940 | 2020-11-10 | Salt Lake | Utah | 49035 | 58495 | 334 |
715696 | 715696 | 2020-11-09 | Salt Lake | Utah | 49035 | 57531 | 331 |
712452 | 712452 | 2020-11-08 | Salt Lake | Utah | 49035 | 56567 | 330 |
709208 | 709208 | 2020-11-07 | Salt Lake | Utah | 49035 | 55566 | 330 |
705964 | 705964 | 2020-11-06 | Salt Lake | Utah | 49035 | 54332 | 326 |
702721 | 702721 | 2020-11-05 | Salt Lake | Utah | 49035 | 53149 | 321 |
699477 | 699477 | 2020-11-04 | Salt Lake | Utah | 49035 | 51985 | 318 |
696232 | 696232 | 2020-11-03 | Salt Lake | Utah | 49035 | 51124 | 317 |
692989 | 692989 | 2020-11-02 | Salt Lake | Utah | 49035 | 50461 | 314 |
689745 | 689745 | 2020-11-01 | Salt Lake | Utah | 49035 | 49887 | 314 |
686500 | 686500 | 2020-10-31 | Salt Lake | Utah | 49035 | 49087 | 309 |
683256 | 683256 | 2020-10-30 | Salt Lake | Utah | 49035 | 48330 | 309 |
680012 | 680012 | 2020-10-29 | Salt Lake | Utah | 49035 | 47429 | 308 |
676769 | 676769 | 2020-10-28 | Salt Lake | Utah | 49035 | 46672 | 304 |
673525 | 673525 | 2020-10-27 | Salt Lake | Utah | 49035 | 45969 | 299 |
670283 | 670283 | 2020-10-26 | Salt Lake | Utah | 49035 | 45508 | 299 |
667040 | 667040 | 2020-10-25 | Salt Lake | Utah | 49035 | 45042 | 299 |
663794 | 663794 | 2020-10-24 | Salt Lake | Utah | 49035 | 44305 | 299 |
660549 | 660549 | 2020-10-23 | Salt Lake | Utah | 49035 | 43647 | 298 |
657305 | 657305 | 2020-10-22 | Salt Lake | Utah | 49035 | 42902 | 297 |
654060 | 654060 | 2020-10-21 | Salt Lake | Utah | 49035 | 42276 | 295 |
650815 | 650815 | 2020-10-20 | Salt Lake | Utah | 49035 | 41665 | 292 |
647571 | 647571 | 2020-10-19 | Salt Lake | Utah | 49035 | 41213 | 290 |
644325 | 644325 | 2020-10-18 | Salt Lake | Utah | 49035 | 40713 | 289 |
641077 | 641077 | 2020-10-17 | Salt Lake | Utah | 49035 | 40227 | 287 |
637830 | 637830 | 2020-10-16 | Salt Lake | Utah | 49035 | 39645 | 286 |
634585 | 634585 | 2020-10-15 | Salt Lake | Utah | 49035 | 38949 | 285 |
631340 | 631340 | 2020-10-14 | Salt Lake | Utah | 49035 | 38369 | 283 |
628096 | 628096 | 2020-10-13 | Salt Lake | Utah | 49035 | 37821 | 281 |
624853 | 624853 | 2020-10-12 | Salt Lake | Utah | 49035 | 37479 | 281 |
621610 | 621610 | 2020-10-11 | Salt Lake | Utah | 49035 | 37088 | 280 |
618367 | 618367 | 2020-10-10 | Salt Lake | Utah | 49035 | 36554 | 277 |
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]);