ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
611 rows where fips = 49009 and state = "Utah" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
521112 | 521112 | 2020-09-10 | Daggett | Utah | 49009 | 1 | 0 |
524348 | 524348 | 2020-09-11 | Daggett | Utah | 49009 | 1 | 0 |
527584 | 527584 | 2020-09-12 | Daggett | Utah | 49009 | 1 | 0 |
530821 | 530821 | 2020-09-13 | Daggett | Utah | 49009 | 1 | 0 |
534056 | 534056 | 2020-09-14 | Daggett | Utah | 49009 | 1 | 0 |
537292 | 537292 | 2020-09-15 | Daggett | Utah | 49009 | 1 | 0 |
540529 | 540529 | 2020-09-16 | Daggett | Utah | 49009 | 1 | 0 |
543765 | 543765 | 2020-09-17 | Daggett | Utah | 49009 | 1 | 0 |
547002 | 547002 | 2020-09-18 | Daggett | Utah | 49009 | 1 | 0 |
550241 | 550241 | 2020-09-19 | Daggett | Utah | 49009 | 1 | 0 |
553480 | 553480 | 2020-09-20 | Daggett | Utah | 49009 | 1 | 0 |
556717 | 556717 | 2020-09-21 | Daggett | Utah | 49009 | 1 | 0 |
559953 | 559953 | 2020-09-22 | Daggett | Utah | 49009 | 1 | 0 |
563192 | 563192 | 2020-09-23 | Daggett | Utah | 49009 | 1 | 0 |
566433 | 566433 | 2020-09-24 | Daggett | Utah | 49009 | 1 | 0 |
569674 | 569674 | 2020-09-25 | Daggett | Utah | 49009 | 1 | 0 |
572916 | 572916 | 2020-09-26 | Daggett | Utah | 49009 | 1 | 0 |
576160 | 576160 | 2020-09-27 | Daggett | Utah | 49009 | 1 | 0 |
579401 | 579401 | 2020-09-28 | Daggett | Utah | 49009 | 1 | 0 |
582640 | 582640 | 2020-09-29 | Daggett | Utah | 49009 | 1 | 0 |
585880 | 585880 | 2020-09-30 | Daggett | Utah | 49009 | 1 | 0 |
589121 | 589121 | 2020-10-01 | Daggett | Utah | 49009 | 1 | 0 |
592361 | 592361 | 2020-10-02 | Daggett | Utah | 49009 | 1 | 0 |
595603 | 595603 | 2020-10-03 | Daggett | Utah | 49009 | 1 | 0 |
598846 | 598846 | 2020-10-04 | Daggett | Utah | 49009 | 1 | 0 |
602089 | 602089 | 2020-10-05 | Daggett | Utah | 49009 | 1 | 0 |
605331 | 605331 | 2020-10-06 | Daggett | Utah | 49009 | 1 | 0 |
608574 | 608574 | 2020-10-07 | Daggett | Utah | 49009 | 1 | 0 |
611816 | 611816 | 2020-10-08 | Daggett | Utah | 49009 | 1 | 0 |
615057 | 615057 | 2020-10-09 | Daggett | Utah | 49009 | 1 | 0 |
618299 | 618299 | 2020-10-10 | Daggett | Utah | 49009 | 1 | 0 |
621542 | 621542 | 2020-10-11 | Daggett | Utah | 49009 | 1 | 0 |
624785 | 624785 | 2020-10-12 | Daggett | Utah | 49009 | 1 | 0 |
628028 | 628028 | 2020-10-13 | Daggett | Utah | 49009 | 1 | 0 |
631272 | 631272 | 2020-10-14 | Daggett | Utah | 49009 | 1 | 0 |
634517 | 634517 | 2020-10-15 | Daggett | Utah | 49009 | 1 | 0 |
637762 | 637762 | 2020-10-16 | Daggett | Utah | 49009 | 1 | 0 |
641009 | 641009 | 2020-10-17 | Daggett | Utah | 49009 | 1 | 0 |
644257 | 644257 | 2020-10-18 | Daggett | Utah | 49009 | 1 | 0 |
647503 | 647503 | 2020-10-19 | Daggett | Utah | 49009 | 1 | 0 |
650747 | 650747 | 2020-10-20 | Daggett | Utah | 49009 | 1 | 0 |
653992 | 653992 | 2020-10-21 | Daggett | Utah | 49009 | 1 | 0 |
657237 | 657237 | 2020-10-22 | Daggett | Utah | 49009 | 1 | 0 |
660481 | 660481 | 2020-10-23 | Daggett | Utah | 49009 | 1 | 0 |
663725 | 663725 | 2020-10-24 | Daggett | Utah | 49009 | 1 | 0 |
666970 | 666970 | 2020-10-25 | Daggett | Utah | 49009 | 1 | 0 |
670213 | 670213 | 2020-10-26 | Daggett | Utah | 49009 | 1 | 0 |
673455 | 673455 | 2020-10-27 | Daggett | Utah | 49009 | 1 | 0 |
676698 | 676698 | 2020-10-28 | Daggett | Utah | 49009 | 1 | 0 |
679941 | 679941 | 2020-10-29 | Daggett | Utah | 49009 | 1 | 0 |
683184 | 683184 | 2020-10-30 | Daggett | Utah | 49009 | 1 | 0 |
686427 | 686427 | 2020-10-31 | Daggett | Utah | 49009 | 1 | 0 |
689672 | 689672 | 2020-11-01 | Daggett | Utah | 49009 | 1 | 0 |
692916 | 692916 | 2020-11-02 | Daggett | Utah | 49009 | 1 | 0 |
696158 | 696158 | 2020-11-03 | Daggett | Utah | 49009 | 1 | 0 |
699402 | 699402 | 2020-11-04 | Daggett | Utah | 49009 | 1 | 0 |
702645 | 702645 | 2020-11-05 | Daggett | Utah | 49009 | 1 | 0 |
705888 | 705888 | 2020-11-06 | Daggett | Utah | 49009 | 1 | 0 |
709132 | 709132 | 2020-11-07 | Daggett | Utah | 49009 | 1 | 0 |
712376 | 712376 | 2020-11-08 | Daggett | Utah | 49009 | 1 | 0 |
715620 | 715620 | 2020-11-09 | Daggett | Utah | 49009 | 1 | 0 |
718863 | 718863 | 2020-11-10 | Daggett | Utah | 49009 | 1 | 0 |
722106 | 722106 | 2020-11-11 | Daggett | Utah | 49009 | 1 | 0 |
725349 | 725349 | 2020-11-12 | Daggett | Utah | 49009 | 1 | 0 |
728592 | 728592 | 2020-11-13 | Daggett | Utah | 49009 | 1 | 0 |
731837 | 731837 | 2020-11-14 | Daggett | Utah | 49009 | 1 | 0 |
735083 | 735083 | 2020-11-15 | Daggett | Utah | 49009 | 1 | 0 |
738327 | 738327 | 2020-11-16 | Daggett | Utah | 49009 | 1 | 0 |
741574 | 741574 | 2020-11-17 | Daggett | Utah | 49009 | 1 | 0 |
744821 | 744821 | 2020-11-18 | Daggett | Utah | 49009 | 1 | 0 |
748067 | 748067 | 2020-11-19 | Daggett | Utah | 49009 | 1 | 0 |
751313 | 751313 | 2020-11-20 | Daggett | Utah | 49009 | 1 | 0 |
754559 | 754559 | 2020-11-21 | Daggett | Utah | 49009 | 1 | 0 |
757806 | 757806 | 2020-11-22 | Daggett | Utah | 49009 | 1 | 0 |
761051 | 761051 | 2020-11-23 | Daggett | Utah | 49009 | 3 | 0 |
764296 | 764296 | 2020-11-24 | Daggett | Utah | 49009 | 5 | 0 |
767541 | 767541 | 2020-11-25 | Daggett | Utah | 49009 | 5 | 0 |
770787 | 770787 | 2020-11-26 | Daggett | Utah | 49009 | 5 | 0 |
774032 | 774032 | 2020-11-27 | Daggett | Utah | 49009 | 6 | 0 |
777277 | 777277 | 2020-11-28 | Daggett | Utah | 49009 | 6 | 0 |
780523 | 780523 | 2020-11-29 | Daggett | Utah | 49009 | 6 | 0 |
783768 | 783768 | 2020-11-30 | Daggett | Utah | 49009 | 6 | 0 |
787012 | 787012 | 2020-12-01 | Daggett | Utah | 49009 | 6 | 0 |
790257 | 790257 | 2020-12-02 | Daggett | Utah | 49009 | 6 | 0 |
793502 | 793502 | 2020-12-03 | Daggett | Utah | 49009 | 9 | 0 |
796747 | 796747 | 2020-12-04 | Daggett | Utah | 49009 | 9 | 0 |
799992 | 799992 | 2020-12-05 | Daggett | Utah | 49009 | 9 | 0 |
803237 | 803237 | 2020-12-06 | Daggett | Utah | 49009 | 9 | 0 |
806482 | 806482 | 2020-12-07 | Daggett | Utah | 49009 | 9 | 0 |
809727 | 809727 | 2020-12-08 | Daggett | Utah | 49009 | 11 | 0 |
812971 | 812971 | 2020-12-09 | Daggett | Utah | 49009 | 12 | 0 |
816217 | 816217 | 2020-12-10 | Daggett | Utah | 49009 | 12 | 0 |
819463 | 819463 | 2020-12-11 | Daggett | Utah | 49009 | 12 | 0 |
822709 | 822709 | 2020-12-12 | Daggett | Utah | 49009 | 12 | 0 |
825956 | 825956 | 2020-12-13 | Daggett | Utah | 49009 | 12 | 0 |
829202 | 829202 | 2020-12-14 | Daggett | Utah | 49009 | 12 | 0 |
832449 | 832449 | 2020-12-15 | Daggett | Utah | 49009 | 12 | 0 |
835695 | 835695 | 2020-12-16 | Daggett | Utah | 49009 | 12 | 0 |
838941 | 838941 | 2020-12-17 | Daggett | Utah | 49009 | 13 | 0 |
842186 | 842186 | 2020-12-18 | Daggett | Utah | 49009 | 13 | 0 |
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);