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 |
---|---|---|---|---|---|---|---|
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 |
731850 | 731850 | 2020-11-14 | Salt Lake | Utah | 49035 | 63768 | 350 |
728605 | 728605 | 2020-11-13 | Salt Lake | Utah | 49035 | 61673 | 348 |
725362 | 725362 | 2020-11-12 | Salt Lake | Utah | 49035 | 60859 | 342 |
722119 | 722119 | 2020-11-11 | Salt Lake | Utah | 49035 | 59493 | 339 |
718876 | 718876 | 2020-11-10 | Salt Lake | Utah | 49035 | 58495 | 334 |
715633 | 715633 | 2020-11-09 | Salt Lake | Utah | 49035 | 57531 | 331 |
712389 | 712389 | 2020-11-08 | Salt Lake | Utah | 49035 | 56567 | 330 |
709145 | 709145 | 2020-11-07 | Salt Lake | Utah | 49035 | 55566 | 330 |
705901 | 705901 | 2020-11-06 | Salt Lake | Utah | 49035 | 54332 | 326 |
702658 | 702658 | 2020-11-05 | Salt Lake | Utah | 49035 | 53149 | 321 |
699415 | 699415 | 2020-11-04 | Salt Lake | Utah | 49035 | 51985 | 318 |
696171 | 696171 | 2020-11-03 | Salt Lake | Utah | 49035 | 51124 | 317 |
692929 | 692929 | 2020-11-02 | Salt Lake | Utah | 49035 | 50461 | 314 |
689685 | 689685 | 2020-11-01 | Salt Lake | Utah | 49035 | 49887 | 314 |
686440 | 686440 | 2020-10-31 | Salt Lake | Utah | 49035 | 49087 | 309 |
683197 | 683197 | 2020-10-30 | Salt Lake | Utah | 49035 | 48330 | 309 |
679954 | 679954 | 2020-10-29 | Salt Lake | Utah | 49035 | 47429 | 308 |
676711 | 676711 | 2020-10-28 | Salt Lake | Utah | 49035 | 46672 | 304 |
673468 | 673468 | 2020-10-27 | Salt Lake | Utah | 49035 | 45969 | 299 |
670226 | 670226 | 2020-10-26 | Salt Lake | Utah | 49035 | 45508 | 299 |
666983 | 666983 | 2020-10-25 | Salt Lake | Utah | 49035 | 45042 | 299 |
663738 | 663738 | 2020-10-24 | Salt Lake | Utah | 49035 | 44305 | 299 |
660494 | 660494 | 2020-10-23 | Salt Lake | Utah | 49035 | 43647 | 298 |
657250 | 657250 | 2020-10-22 | Salt Lake | Utah | 49035 | 42902 | 297 |
654005 | 654005 | 2020-10-21 | Salt Lake | Utah | 49035 | 42276 | 295 |
650760 | 650760 | 2020-10-20 | Salt Lake | Utah | 49035 | 41665 | 292 |
647516 | 647516 | 2020-10-19 | Salt Lake | Utah | 49035 | 41213 | 290 |
644270 | 644270 | 2020-10-18 | Salt Lake | Utah | 49035 | 40713 | 289 |
641022 | 641022 | 2020-10-17 | Salt Lake | Utah | 49035 | 40227 | 287 |
637775 | 637775 | 2020-10-16 | Salt Lake | Utah | 49035 | 39645 | 286 |
634530 | 634530 | 2020-10-15 | Salt Lake | Utah | 49035 | 38949 | 285 |
631285 | 631285 | 2020-10-14 | Salt Lake | Utah | 49035 | 38369 | 283 |
628041 | 628041 | 2020-10-13 | Salt Lake | Utah | 49035 | 37821 | 281 |
624798 | 624798 | 2020-10-12 | Salt Lake | Utah | 49035 | 37479 | 281 |
621555 | 621555 | 2020-10-11 | Salt Lake | Utah | 49035 | 37088 | 280 |
618312 | 618312 | 2020-10-10 | Salt Lake | Utah | 49035 | 36554 | 277 |
615070 | 615070 | 2020-10-09 | Salt Lake | Utah | 49035 | 35952 | 275 |
611829 | 611829 | 2020-10-08 | Salt Lake | Utah | 49035 | 35436 | 272 |
608587 | 608587 | 2020-10-07 | Salt Lake | Utah | 49035 | 34884 | 269 |
605344 | 605344 | 2020-10-06 | Salt Lake | Utah | 49035 | 34396 | 265 |
602102 | 602102 | 2020-10-05 | Salt Lake | Utah | 49035 | 34071 | 260 |
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);