ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 49043 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637779 | 637779 | 2020-10-16 | Summit | Utah | 49043 | 1204 | 1 |
634534 | 634534 | 2020-10-15 | Summit | Utah | 49043 | 1187 | 1 |
631289 | 631289 | 2020-10-14 | Summit | Utah | 49043 | 1176 | 1 |
628045 | 628045 | 2020-10-13 | Summit | Utah | 49043 | 1164 | 1 |
624802 | 624802 | 2020-10-12 | Summit | Utah | 49043 | 1159 | 1 |
621559 | 621559 | 2020-10-11 | Summit | Utah | 49043 | 1151 | 1 |
618316 | 618316 | 2020-10-10 | Summit | Utah | 49043 | 1138 | 1 |
615074 | 615074 | 2020-10-09 | Summit | Utah | 49043 | 1124 | 1 |
611833 | 611833 | 2020-10-08 | Summit | Utah | 49043 | 1112 | 1 |
608591 | 608591 | 2020-10-07 | Summit | Utah | 49043 | 1100 | 1 |
605348 | 605348 | 2020-10-06 | Summit | Utah | 49043 | 1088 | 1 |
602106 | 602106 | 2020-10-05 | Summit | Utah | 49043 | 1084 | 1 |
598863 | 598863 | 2020-10-04 | Summit | Utah | 49043 | 1065 | 1 |
595620 | 595620 | 2020-10-03 | Summit | Utah | 49043 | 1046 | 1 |
592378 | 592378 | 2020-10-02 | Summit | Utah | 49043 | 1036 | 1 |
589138 | 589138 | 2020-10-01 | Summit | Utah | 49043 | 1029 | 1 |
585897 | 585897 | 2020-09-30 | Summit | Utah | 49043 | 1022 | 1 |
582657 | 582657 | 2020-09-29 | Summit | Utah | 49043 | 1014 | 1 |
579418 | 579418 | 2020-09-28 | Summit | Utah | 49043 | 1005 | 1 |
576177 | 576177 | 2020-09-27 | Summit | Utah | 49043 | 998 | 1 |
572933 | 572933 | 2020-09-26 | Summit | Utah | 49043 | 991 | 1 |
569691 | 569691 | 2020-09-25 | Summit | Utah | 49043 | 981 | 1 |
566450 | 566450 | 2020-09-24 | Summit | Utah | 49043 | 977 | 1 |
563209 | 563209 | 2020-09-23 | Summit | Utah | 49043 | 961 | 1 |
559970 | 559970 | 2020-09-22 | Summit | Utah | 49043 | 955 | 1 |
556734 | 556734 | 2020-09-21 | Summit | Utah | 49043 | 954 | 1 |
553497 | 553497 | 2020-09-20 | Summit | Utah | 49043 | 950 | 1 |
550258 | 550258 | 2020-09-19 | Summit | Utah | 49043 | 940 | 1 |
547019 | 547019 | 2020-09-18 | Summit | Utah | 49043 | 930 | 1 |
543782 | 543782 | 2020-09-17 | Summit | Utah | 49043 | 927 | 1 |
540546 | 540546 | 2020-09-16 | Summit | Utah | 49043 | 925 | 1 |
537309 | 537309 | 2020-09-15 | Summit | Utah | 49043 | 923 | 1 |
534073 | 534073 | 2020-09-14 | Summit | Utah | 49043 | 919 | 1 |
530838 | 530838 | 2020-09-13 | Summit | Utah | 49043 | 914 | 1 |
527601 | 527601 | 2020-09-12 | Summit | Utah | 49043 | 907 | 1 |
524365 | 524365 | 2020-09-11 | Summit | Utah | 49043 | 905 | 1 |
521129 | 521129 | 2020-09-10 | Summit | Utah | 49043 | 898 | 1 |
517892 | 517892 | 2020-09-09 | Summit | Utah | 49043 | 895 | 1 |
514657 | 514657 | 2020-09-08 | Summit | Utah | 49043 | 888 | 1 |
511424 | 511424 | 2020-09-07 | Summit | Utah | 49043 | 882 | 1 |
508191 | 508191 | 2020-09-06 | Summit | Utah | 49043 | 880 | 1 |
504959 | 504959 | 2020-09-05 | Summit | Utah | 49043 | 873 | 1 |
501725 | 501725 | 2020-09-04 | Summit | Utah | 49043 | 863 | 1 |
498491 | 498491 | 2020-09-03 | Summit | Utah | 49043 | 856 | 1 |
495258 | 495258 | 2020-09-02 | Summit | Utah | 49043 | 854 | 1 |
492024 | 492024 | 2020-09-01 | Summit | Utah | 49043 | 852 | 1 |
488791 | 488791 | 2020-08-31 | Summit | Utah | 49043 | 847 | 1 |
485558 | 485558 | 2020-08-30 | Summit | Utah | 49043 | 841 | 1 |
482323 | 482323 | 2020-08-29 | Summit | Utah | 49043 | 839 | 1 |
479089 | 479089 | 2020-08-28 | Summit | Utah | 49043 | 837 | 1 |
475856 | 475856 | 2020-08-27 | Summit | Utah | 49043 | 832 | 1 |
472623 | 472623 | 2020-08-26 | Summit | Utah | 49043 | 828 | 1 |
469391 | 469391 | 2020-08-25 | Summit | Utah | 49043 | 821 | 1 |
466162 | 466162 | 2020-08-24 | Summit | Utah | 49043 | 815 | 1 |
462933 | 462933 | 2020-08-23 | Summit | Utah | 49043 | 810 | 1 |
459704 | 459704 | 2020-08-22 | Summit | Utah | 49043 | 805 | 1 |
456477 | 456477 | 2020-08-21 | Summit | Utah | 49043 | 792 | 1 |
453249 | 453249 | 2020-08-20 | Summit | Utah | 49043 | 787 | 1 |
450021 | 450021 | 2020-08-19 | Summit | Utah | 49043 | 765 | 1 |
446793 | 446793 | 2020-08-18 | Summit | Utah | 49043 | 758 | 1 |
443566 | 443566 | 2020-08-17 | Summit | Utah | 49043 | 746 | 1 |
440340 | 440340 | 2020-08-16 | Summit | Utah | 49043 | 733 | 1 |
437114 | 437114 | 2020-08-15 | Summit | Utah | 49043 | 729 | 1 |
433888 | 433888 | 2020-08-14 | Summit | Utah | 49043 | 724 | 1 |
430663 | 430663 | 2020-08-13 | Summit | Utah | 49043 | 718 | 1 |
427435 | 427435 | 2020-08-12 | Summit | Utah | 49043 | 717 | 1 |
424211 | 424211 | 2020-08-11 | Summit | Utah | 49043 | 714 | 1 |
420990 | 420990 | 2020-08-10 | Summit | Utah | 49043 | 713 | 1 |
417769 | 417769 | 2020-08-09 | Summit | Utah | 49043 | 710 | 1 |
414548 | 414548 | 2020-08-08 | Summit | Utah | 49043 | 706 | 1 |
411328 | 411328 | 2020-08-07 | Summit | Utah | 49043 | 706 | 1 |
408109 | 408109 | 2020-08-06 | Summit | Utah | 49043 | 706 | 1 |
404889 | 404889 | 2020-08-05 | Summit | Utah | 49043 | 701 | 1 |
401671 | 401671 | 2020-08-04 | Summit | Utah | 49043 | 698 | 1 |
398455 | 398455 | 2020-08-03 | Summit | Utah | 49043 | 697 | 1 |
395239 | 395239 | 2020-08-02 | Summit | Utah | 49043 | 695 | 1 |
392023 | 392023 | 2020-08-01 | Summit | Utah | 49043 | 689 | 1 |
388806 | 388806 | 2020-07-31 | Summit | Utah | 49043 | 687 | 1 |
385589 | 385589 | 2020-07-30 | Summit | Utah | 49043 | 683 | 1 |
382371 | 382371 | 2020-07-29 | Summit | Utah | 49043 | 679 | 1 |
379154 | 379154 | 2020-07-28 | Summit | Utah | 49043 | 673 | 1 |
375938 | 375938 | 2020-07-27 | Summit | Utah | 49043 | 673 | 1 |
372725 | 372725 | 2020-07-26 | Summit | Utah | 49043 | 669 | 1 |
369513 | 369513 | 2020-07-25 | Summit | Utah | 49043 | 663 | 1 |
366304 | 366304 | 2020-07-24 | Summit | Utah | 49043 | 658 | 1 |
363098 | 363098 | 2020-07-23 | Summit | Utah | 49043 | 651 | 1 |
359891 | 359891 | 2020-07-22 | Summit | Utah | 49043 | 645 | 1 |
356686 | 356686 | 2020-07-21 | Summit | Utah | 49043 | 643 | 1 |
353483 | 353483 | 2020-07-20 | Summit | Utah | 49043 | 637 | 1 |
350281 | 350281 | 2020-07-19 | Summit | Utah | 49043 | 635 | 1 |
347081 | 347081 | 2020-07-18 | Summit | Utah | 49043 | 620 | 1 |
343880 | 343880 | 2020-07-17 | Summit | Utah | 49043 | 612 | 1 |
340681 | 340681 | 2020-07-16 | Summit | Utah | 49043 | 605 | 1 |
337485 | 337485 | 2020-07-15 | Summit | Utah | 49043 | 597 | 1 |
334290 | 334290 | 2020-07-14 | Summit | Utah | 49043 | 596 | 1 |
331097 | 331097 | 2020-07-13 | Summit | Utah | 49043 | 591 | 1 |
327911 | 327911 | 2020-07-12 | Summit | Utah | 49043 | 584 | 1 |
324726 | 324726 | 2020-07-11 | Summit | Utah | 49043 | 574 | 1 |
321545 | 321545 | 2020-07-10 | Summit | Utah | 49043 | 560 | 1 |
318366 | 318366 | 2020-07-09 | Summit | Utah | 49043 | 553 | 1 |
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);