ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
809 rows where fips = 49035 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056399 | 1056399 | 2021-02-22 | Salt Lake | Utah | 49035 | 137262 | 734 |
1053153 | 1053153 | 2021-02-21 | Salt Lake | Utah | 49035 | 137117 | 734 |
1049906 | 1049906 | 2021-02-20 | Salt Lake | Utah | 49035 | 136873 | 731 |
1046659 | 1046659 | 2021-02-19 | Salt Lake | Utah | 49035 | 136602 | 726 |
1043414 | 1043414 | 2021-02-18 | Salt Lake | Utah | 49035 | 136338 | 723 |
1040169 | 1040169 | 2021-02-17 | Salt Lake | Utah | 49035 | 135998 | 720 |
1036924 | 1036924 | 2021-02-16 | Salt Lake | Utah | 49035 | 135691 | 718 |
1033679 | 1033679 | 2021-02-15 | Salt Lake | Utah | 49035 | 135477 | 717 |
1030433 | 1030433 | 2021-02-14 | Salt Lake | Utah | 49035 | 135294 | 717 |
1027186 | 1027186 | 2021-02-13 | Salt Lake | Utah | 49035 | 135052 | 717 |
1023941 | 1023941 | 2021-02-12 | Salt Lake | Utah | 49035 | 134729 | 716 |
1020696 | 1020696 | 2021-02-11 | Salt Lake | Utah | 49035 | 134381 | 715 |
1017451 | 1017451 | 2021-02-10 | Salt Lake | Utah | 49035 | 133913 | 714 |
1014206 | 1014206 | 2021-02-09 | Salt Lake | Utah | 49035 | 133449 | 711 |
1010961 | 1010961 | 2021-02-08 | Salt Lake | Utah | 49035 | 133103 | 708 |
1007715 | 1007715 | 2021-02-07 | Salt Lake | Utah | 49035 | 132902 | 708 |
1004469 | 1004469 | 2021-02-06 | Salt Lake | Utah | 49035 | 132547 | 708 |
1001223 | 1001223 | 2021-02-05 | Salt Lake | Utah | 49035 | 132130 | 707 |
997977 | 997977 | 2021-02-04 | Salt Lake | Utah | 49035 | 131697 | 701 |
994731 | 994731 | 2021-02-03 | Salt Lake | Utah | 49035 | 131260 | 695 |
991485 | 991485 | 2021-02-02 | Salt Lake | Utah | 49035 | 130734 | 690 |
988239 | 988239 | 2021-02-01 | Salt Lake | Utah | 49035 | 130275 | 681 |
984992 | 984992 | 2021-01-31 | Salt Lake | Utah | 49035 | 130042 | 680 |
981745 | 981745 | 2021-01-30 | Salt Lake | Utah | 49035 | 129608 | 680 |
978499 | 978499 | 2021-01-29 | Salt Lake | Utah | 49035 | 129114 | 675 |
975254 | 975254 | 2021-01-28 | Salt Lake | Utah | 49035 | 128589 | 660 |
972009 | 972009 | 2021-01-27 | Salt Lake | Utah | 49035 | 128020 | 660 |
968764 | 968764 | 2021-01-26 | Salt Lake | Utah | 49035 | 127384 | 660 |
965520 | 965520 | 2021-01-25 | Salt Lake | Utah | 49035 | 126940 | 657 |
962275 | 962275 | 2021-01-24 | Salt Lake | Utah | 49035 | 126604 | 657 |
959030 | 959030 | 2021-01-23 | Salt Lake | Utah | 49035 | 126093 | 653 |
955784 | 955784 | 2021-01-22 | Salt Lake | Utah | 49035 | 125468 | 649 |
952539 | 952539 | 2021-01-21 | Salt Lake | Utah | 49035 | 124688 | 639 |
949294 | 949294 | 2021-01-20 | Salt Lake | Utah | 49035 | 123926 | 631 |
946048 | 946048 | 2021-01-19 | Salt Lake | Utah | 49035 | 123304 | 627 |
942801 | 942801 | 2021-01-18 | Salt Lake | Utah | 49035 | 122887 | 624 |
939556 | 939556 | 2021-01-17 | Salt Lake | Utah | 49035 | 122400 | 624 |
936311 | 936311 | 2021-01-16 | Salt Lake | Utah | 49035 | 121741 | 624 |
933066 | 933066 | 2021-01-15 | Salt Lake | Utah | 49035 | 121050 | 622 |
929821 | 929821 | 2021-01-14 | Salt Lake | Utah | 49035 | 120091 | 615 |
926576 | 926576 | 2021-01-13 | Salt Lake | Utah | 49035 | 119222 | 612 |
923330 | 923330 | 2021-01-12 | Salt Lake | Utah | 49035 | 118431 | 610 |
920085 | 920085 | 2021-01-11 | Salt Lake | Utah | 49035 | 117670 | 600 |
916840 | 916840 | 2021-01-10 | Salt Lake | Utah | 49035 | 117126 | 599 |
913595 | 913595 | 2021-01-09 | Salt Lake | Utah | 49035 | 116220 | 599 |
910350 | 910350 | 2021-01-08 | Salt Lake | Utah | 49035 | 115315 | 594 |
907105 | 907105 | 2021-01-07 | Salt Lake | Utah | 49035 | 114097 | 583 |
903859 | 903859 | 2021-01-06 | Salt Lake | Utah | 49035 | 112552 | 571 |
900614 | 900614 | 2021-01-05 | Salt Lake | Utah | 49035 | 111389 | 564 |
897369 | 897369 | 2021-01-04 | Salt Lake | Utah | 49035 | 110242 | 563 |
894123 | 894123 | 2021-01-03 | Salt Lake | Utah | 49035 | 109533 | 561 |
890877 | 890877 | 2021-01-02 | Salt Lake | Utah | 49035 | 108971 | 560 |
887630 | 887630 | 2021-01-01 | Salt Lake | Utah | 49035 | 107386 | 554 |
884385 | 884385 | 2020-12-31 | Salt Lake | Utah | 49035 | 107386 | 554 |
881140 | 881140 | 2020-12-30 | Salt Lake | Utah | 49035 | 105933 | 551 |
877895 | 877895 | 2020-12-29 | Salt Lake | Utah | 49035 | 105026 | 542 |
874650 | 874650 | 2020-12-28 | Salt Lake | Utah | 49035 | 104167 | 536 |
871405 | 871405 | 2020-12-27 | Salt Lake | Utah | 49035 | 103615 | 535 |
868160 | 868160 | 2020-12-26 | Salt Lake | Utah | 49035 | 103313 | 533 |
864915 | 864915 | 2020-12-25 | Salt Lake | Utah | 49035 | 102160 | 532 |
861670 | 861670 | 2020-12-24 | Salt Lake | Utah | 49035 | 102160 | 532 |
858425 | 858425 | 2020-12-23 | Salt Lake | Utah | 49035 | 101258 | 527 |
855180 | 855180 | 2020-12-22 | Salt Lake | Utah | 49035 | 100482 | 516 |
851935 | 851935 | 2020-12-21 | Salt Lake | Utah | 49035 | 99874 | 512 |
848690 | 848690 | 2020-12-20 | Salt Lake | Utah | 49035 | 99234 | 509 |
845445 | 845445 | 2020-12-19 | Salt Lake | Utah | 49035 | 98563 | 507 |
842199 | 842199 | 2020-12-18 | Salt Lake | Utah | 49035 | 97748 | 502 |
838954 | 838954 | 2020-12-17 | Salt Lake | Utah | 49035 | 96864 | 497 |
835708 | 835708 | 2020-12-16 | Salt Lake | Utah | 49035 | 95917 | 488 |
832462 | 832462 | 2020-12-15 | Salt Lake | Utah | 49035 | 94942 | 477 |
829215 | 829215 | 2020-12-14 | Salt Lake | Utah | 49035 | 94415 | 474 |
825969 | 825969 | 2020-12-13 | Salt Lake | Utah | 49035 | 93761 | 473 |
822722 | 822722 | 2020-12-12 | Salt Lake | Utah | 49035 | 93065 | 467 |
819476 | 819476 | 2020-12-11 | Salt Lake | Utah | 49035 | 91795 | 465 |
816230 | 816230 | 2020-12-10 | Salt Lake | Utah | 49035 | 91056 | 460 |
812984 | 812984 | 2020-12-09 | Salt Lake | Utah | 49035 | 89832 | 448 |
809740 | 809740 | 2020-12-08 | Salt Lake | Utah | 49035 | 88921 | 442 |
806495 | 806495 | 2020-12-07 | Salt Lake | Utah | 49035 | 88184 | 431 |
803250 | 803250 | 2020-12-06 | Salt Lake | Utah | 49035 | 87328 | 428 |
800005 | 800005 | 2020-12-05 | Salt Lake | Utah | 49035 | 86339 | 428 |
796760 | 796760 | 2020-12-04 | Salt Lake | Utah | 49035 | 85082 | 422 |
793515 | 793515 | 2020-12-03 | Salt Lake | Utah | 49035 | 84141 | 416 |
790270 | 790270 | 2020-12-02 | Salt Lake | Utah | 49035 | 82813 | 411 |
787025 | 787025 | 2020-12-01 | Salt Lake | Utah | 49035 | 81337 | 407 |
783781 | 783781 | 2020-11-30 | Salt Lake | Utah | 49035 | 80533 | 402 |
780536 | 780536 | 2020-11-29 | Salt Lake | Utah | 49035 | 79836 | 402 |
777290 | 777290 | 2020-11-28 | Salt Lake | Utah | 49035 | 79227 | 401 |
774045 | 774045 | 2020-11-27 | Salt Lake | Utah | 49035 | 78530 | 394 |
770800 | 770800 | 2020-11-26 | Salt Lake | Utah | 49035 | 76220 | 390 |
767554 | 767554 | 2020-11-25 | Salt Lake | Utah | 49035 | 76220 | 390 |
764309 | 764309 | 2020-11-24 | Salt Lake | Utah | 49035 | 75458 | 383 |
761064 | 761064 | 2020-11-23 | Salt Lake | Utah | 49035 | 74269 | 382 |
757819 | 757819 | 2020-11-22 | Salt Lake | Utah | 49035 | 73469 | 380 |
754572 | 754572 | 2020-11-21 | Salt Lake | Utah | 49035 | 72206 | 378 |
751326 | 751326 | 2020-11-20 | Salt Lake | Utah | 49035 | 71088 | 371 |
748080 | 748080 | 2020-11-19 | Salt Lake | Utah | 49035 | 69503 | 364 |
744834 | 744834 | 2020-11-18 | Salt Lake | Utah | 49035 | 67942 | 360 |
741587 | 741587 | 2020-11-17 | Salt Lake | Utah | 49035 | 66727 | 356 |
738340 | 738340 | 2020-11-16 | Salt Lake | Utah | 49035 | 65681 | 353 |
735096 | 735096 | 2020-11-15 | Salt Lake | Utah | 49035 | 64794 | 351 |
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);