ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Shiawassee" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921755 | 921755 | 2021-01-12 | Shiawassee | Michigan | 26155 | 3252 | 61 |
918510 | 918510 | 2021-01-11 | Shiawassee | Michigan | 26155 | 3224 | 62 |
915265 | 915265 | 2021-01-10 | Shiawassee | Michigan | 26155 | 3181 | 60 |
912020 | 912020 | 2021-01-09 | Shiawassee | Michigan | 26155 | 3181 | 60 |
908775 | 908775 | 2021-01-08 | Shiawassee | Michigan | 26155 | 3150 | 59 |
905529 | 905529 | 2021-01-07 | Shiawassee | Michigan | 26155 | 3126 | 59 |
902284 | 902284 | 2021-01-06 | Shiawassee | Michigan | 26155 | 3088 | 59 |
899039 | 899039 | 2021-01-05 | Shiawassee | Michigan | 26155 | 3060 | 59 |
895794 | 895794 | 2021-01-04 | Shiawassee | Michigan | 26155 | 3047 | 58 |
892547 | 892547 | 2021-01-03 | Shiawassee | Michigan | 26155 | 3012 | 58 |
889301 | 889301 | 2021-01-02 | Shiawassee | Michigan | 26155 | 3012 | 58 |
886055 | 886055 | 2021-01-01 | Shiawassee | Michigan | 26155 | 2954 | 58 |
882810 | 882810 | 2020-12-31 | Shiawassee | Michigan | 26155 | 2954 | 58 |
879565 | 879565 | 2020-12-30 | Shiawassee | Michigan | 26155 | 2954 | 58 |
876320 | 876320 | 2020-12-29 | Shiawassee | Michigan | 26155 | 2918 | 57 |
873075 | 873075 | 2020-12-28 | Shiawassee | Michigan | 26155 | 2895 | 56 |
869830 | 869830 | 2020-12-27 | Shiawassee | Michigan | 26155 | 2867 | 56 |
866585 | 866585 | 2020-12-26 | Shiawassee | Michigan | 26155 | 2867 | 56 |
863340 | 863340 | 2020-12-25 | Shiawassee | Michigan | 26155 | 2807 | 56 |
860095 | 860095 | 2020-12-24 | Shiawassee | Michigan | 26155 | 2807 | 56 |
856850 | 856850 | 2020-12-23 | Shiawassee | Michigan | 26155 | 2807 | 56 |
853605 | 853605 | 2020-12-22 | Shiawassee | Michigan | 26155 | 2776 | 56 |
850360 | 850360 | 2020-12-21 | Shiawassee | Michigan | 26155 | 2747 | 55 |
847115 | 847115 | 2020-12-20 | Shiawassee | Michigan | 26155 | 2689 | 55 |
843869 | 843869 | 2020-12-19 | Shiawassee | Michigan | 26155 | 2689 | 55 |
840624 | 840624 | 2020-12-18 | Shiawassee | Michigan | 26155 | 2669 | 54 |
837379 | 837379 | 2020-12-17 | Shiawassee | Michigan | 26155 | 2634 | 55 |
834133 | 834133 | 2020-12-16 | Shiawassee | Michigan | 26155 | 2610 | 51 |
830886 | 830886 | 2020-12-15 | Shiawassee | Michigan | 26155 | 2580 | 51 |
827640 | 827640 | 2020-12-14 | Shiawassee | Michigan | 26155 | 2555 | 51 |
824393 | 824393 | 2020-12-13 | Shiawassee | Michigan | 26155 | 2515 | 51 |
821147 | 821147 | 2020-12-12 | Shiawassee | Michigan | 26155 | 2515 | 51 |
817901 | 817901 | 2020-12-11 | Shiawassee | Michigan | 26155 | 2491 | 50 |
814655 | 814655 | 2020-12-10 | Shiawassee | Michigan | 26155 | 2467 | 50 |
811410 | 811410 | 2020-12-09 | Shiawassee | Michigan | 26155 | 2436 | 50 |
808165 | 808165 | 2020-12-08 | Shiawassee | Michigan | 26155 | 2398 | 49 |
804920 | 804920 | 2020-12-07 | Shiawassee | Michigan | 26155 | 2361 | 49 |
801675 | 801675 | 2020-12-06 | Shiawassee | Michigan | 26155 | 2286 | 49 |
798430 | 798430 | 2020-12-05 | Shiawassee | Michigan | 26155 | 2286 | 49 |
795185 | 795185 | 2020-12-04 | Shiawassee | Michigan | 26155 | 2271 | 48 |
791940 | 791940 | 2020-12-03 | Shiawassee | Michigan | 26155 | 2194 | 45 |
788695 | 788695 | 2020-12-02 | Shiawassee | Michigan | 26155 | 2122 | 45 |
785450 | 785450 | 2020-12-01 | Shiawassee | Michigan | 26155 | 2053 | 44 |
782206 | 782206 | 2020-11-30 | Shiawassee | Michigan | 26155 | 2008 | 42 |
778960 | 778960 | 2020-11-29 | Shiawassee | Michigan | 26155 | 1909 | 42 |
775715 | 775715 | 2020-11-28 | Shiawassee | Michigan | 26155 | 1909 | 42 |
772470 | 772470 | 2020-11-27 | Shiawassee | Michigan | 26155 | 1859 | 41 |
769225 | 769225 | 2020-11-26 | Shiawassee | Michigan | 26155 | 1769 | 40 |
765979 | 765979 | 2020-11-25 | Shiawassee | Michigan | 26155 | 1769 | 40 |
762734 | 762734 | 2020-11-24 | Shiawassee | Michigan | 26155 | 1737 | 40 |
759489 | 759489 | 2020-11-23 | Shiawassee | Michigan | 26155 | 1692 | 39 |
756242 | 756242 | 2020-11-22 | Shiawassee | Michigan | 26155 | 1626 | 38 |
752996 | 752996 | 2020-11-21 | Shiawassee | Michigan | 26155 | 1626 | 38 |
749750 | 749750 | 2020-11-20 | Shiawassee | Michigan | 26155 | 1573 | 37 |
746504 | 746504 | 2020-11-19 | Shiawassee | Michigan | 26155 | 1512 | 36 |
743257 | 743257 | 2020-11-18 | Shiawassee | Michigan | 26155 | 1451 | 36 |
740010 | 740010 | 2020-11-17 | Shiawassee | Michigan | 26155 | 1429 | 35 |
736766 | 736766 | 2020-11-16 | Shiawassee | Michigan | 26155 | 1387 | 35 |
733520 | 733520 | 2020-11-15 | Shiawassee | Michigan | 26155 | 1310 | 35 |
730275 | 730275 | 2020-11-14 | Shiawassee | Michigan | 26155 | 1310 | 35 |
727032 | 727032 | 2020-11-13 | Shiawassee | Michigan | 26155 | 1258 | 36 |
723789 | 723789 | 2020-11-12 | Shiawassee | Michigan | 26155 | 1194 | 35 |
720546 | 720546 | 2020-11-11 | Shiawassee | Michigan | 26155 | 1149 | 35 |
717303 | 717303 | 2020-11-10 | Shiawassee | Michigan | 26155 | 1112 | 35 |
714059 | 714059 | 2020-11-09 | Shiawassee | Michigan | 26155 | 1056 | 35 |
710815 | 710815 | 2020-11-08 | Shiawassee | Michigan | 26155 | 980 | 35 |
707571 | 707571 | 2020-11-07 | Shiawassee | Michigan | 26155 | 980 | 35 |
704328 | 704328 | 2020-11-06 | Shiawassee | Michigan | 26155 | 925 | 35 |
701086 | 701086 | 2020-11-05 | Shiawassee | Michigan | 26155 | 905 | 35 |
697842 | 697842 | 2020-11-04 | Shiawassee | Michigan | 26155 | 882 | 34 |
694599 | 694599 | 2020-11-03 | Shiawassee | Michigan | 26155 | 868 | 34 |
691357 | 691357 | 2020-11-02 | Shiawassee | Michigan | 26155 | 845 | 34 |
688112 | 688112 | 2020-11-01 | Shiawassee | Michigan | 26155 | 787 | 34 |
684868 | 684868 | 2020-10-31 | Shiawassee | Michigan | 26155 | 787 | 34 |
681625 | 681625 | 2020-10-30 | Shiawassee | Michigan | 26155 | 786 | 34 |
678381 | 678381 | 2020-10-29 | Shiawassee | Michigan | 26155 | 758 | 34 |
675139 | 675139 | 2020-10-28 | Shiawassee | Michigan | 26155 | 728 | 34 |
671896 | 671896 | 2020-10-27 | Shiawassee | Michigan | 26155 | 719 | 34 |
668654 | 668654 | 2020-10-26 | Shiawassee | Michigan | 26155 | 711 | 34 |
665410 | 665410 | 2020-10-25 | Shiawassee | Michigan | 26155 | 682 | 34 |
662165 | 662165 | 2020-10-24 | Shiawassee | Michigan | 26155 | 682 | 34 |
658921 | 658921 | 2020-10-23 | Shiawassee | Michigan | 26155 | 667 | 34 |
655676 | 655676 | 2020-10-22 | Shiawassee | Michigan | 26155 | 663 | 33 |
652431 | 652431 | 2020-10-21 | Shiawassee | Michigan | 26155 | 650 | 33 |
649186 | 649186 | 2020-10-20 | Shiawassee | Michigan | 26155 | 636 | 33 |
645942 | 645942 | 2020-10-19 | Shiawassee | Michigan | 26155 | 635 | 33 |
642695 | 642695 | 2020-10-18 | Shiawassee | Michigan | 26155 | 605 | 33 |
639448 | 639448 | 2020-10-17 | Shiawassee | Michigan | 26155 | 605 | 33 |
636202 | 636202 | 2020-10-16 | Shiawassee | Michigan | 26155 | 605 | 33 |
632956 | 632956 | 2020-10-15 | Shiawassee | Michigan | 26155 | 598 | 33 |
629711 | 629711 | 2020-10-14 | Shiawassee | Michigan | 26155 | 593 | 32 |
626467 | 626467 | 2020-10-13 | Shiawassee | Michigan | 26155 | 590 | 32 |
623225 | 623225 | 2020-10-12 | Shiawassee | Michigan | 26155 | 589 | 32 |
619982 | 619982 | 2020-10-11 | Shiawassee | Michigan | 26155 | 575 | 32 |
616740 | 616740 | 2020-10-10 | Shiawassee | Michigan | 26155 | 575 | 32 |
613499 | 613499 | 2020-10-09 | Shiawassee | Michigan | 26155 | 574 | 32 |
610257 | 610257 | 2020-10-08 | Shiawassee | Michigan | 26155 | 565 | 32 |
607015 | 607015 | 2020-10-07 | Shiawassee | Michigan | 26155 | 562 | 32 |
603772 | 603772 | 2020-10-06 | Shiawassee | Michigan | 26155 | 556 | 32 |
600530 | 600530 | 2020-10-05 | Shiawassee | Michigan | 26155 | 553 | 32 |
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);