ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 26155 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054824 | 1054824 | 2021-02-22 | Shiawassee | Michigan | 26155 | 3762 | 78 |
1051577 | 1051577 | 2021-02-21 | Shiawassee | Michigan | 26155 | 3746 | 78 |
1048330 | 1048330 | 2021-02-20 | Shiawassee | Michigan | 26155 | 3746 | 78 |
1045084 | 1045084 | 2021-02-19 | Shiawassee | Michigan | 26155 | 3740 | 77 |
1041839 | 1041839 | 2021-02-18 | Shiawassee | Michigan | 26155 | 3733 | 77 |
1038594 | 1038594 | 2021-02-17 | Shiawassee | Michigan | 26155 | 3719 | 76 |
1035349 | 1035349 | 2021-02-16 | Shiawassee | Michigan | 26155 | 3711 | 76 |
1032104 | 1032104 | 2021-02-15 | Shiawassee | Michigan | 26155 | 3706 | 76 |
1028857 | 1028857 | 2021-02-14 | Shiawassee | Michigan | 26155 | 3700 | 75 |
1025611 | 1025611 | 2021-02-13 | Shiawassee | Michigan | 26155 | 3700 | 75 |
1022366 | 1022366 | 2021-02-12 | Shiawassee | Michigan | 26155 | 3688 | 74 |
1019121 | 1019121 | 2021-02-11 | Shiawassee | Michigan | 26155 | 3679 | 74 |
1015876 | 1015876 | 2021-02-10 | Shiawassee | Michigan | 26155 | 3664 | 74 |
1012631 | 1012631 | 2021-02-09 | Shiawassee | Michigan | 26155 | 3650 | 74 |
1009386 | 1009386 | 2021-02-08 | Shiawassee | Michigan | 26155 | 3647 | 74 |
1006139 | 1006139 | 2021-02-07 | Shiawassee | Michigan | 26155 | 3628 | 74 |
1002893 | 1002893 | 2021-02-06 | Shiawassee | Michigan | 26155 | 3628 | 74 |
999648 | 999648 | 2021-02-05 | Shiawassee | Michigan | 26155 | 3623 | 74 |
996402 | 996402 | 2021-02-04 | Shiawassee | Michigan | 26155 | 3609 | 74 |
993156 | 993156 | 2021-02-03 | Shiawassee | Michigan | 26155 | 3602 | 73 |
989910 | 989910 | 2021-02-02 | Shiawassee | Michigan | 26155 | 3583 | 72 |
986663 | 986663 | 2021-02-01 | Shiawassee | Michigan | 26155 | 3575 | 72 |
983416 | 983416 | 2021-01-31 | Shiawassee | Michigan | 26155 | 3557 | 72 |
980170 | 980170 | 2021-01-30 | Shiawassee | Michigan | 26155 | 3557 | 72 |
976924 | 976924 | 2021-01-29 | Shiawassee | Michigan | 26155 | 3538 | 73 |
973679 | 973679 | 2021-01-28 | Shiawassee | Michigan | 26155 | 3533 | 74 |
970434 | 970434 | 2021-01-27 | Shiawassee | Michigan | 26155 | 3522 | 68 |
967189 | 967189 | 2021-01-26 | Shiawassee | Michigan | 26155 | 3507 | 68 |
963945 | 963945 | 2021-01-25 | Shiawassee | Michigan | 26155 | 3496 | 68 |
960700 | 960700 | 2021-01-24 | Shiawassee | Michigan | 26155 | 3461 | 68 |
957454 | 957454 | 2021-01-23 | Shiawassee | Michigan | 26155 | 3461 | 68 |
954209 | 954209 | 2021-01-22 | Shiawassee | Michigan | 26155 | 3454 | 67 |
950964 | 950964 | 2021-01-21 | Shiawassee | Michigan | 26155 | 3432 | 67 |
947718 | 947718 | 2021-01-20 | Shiawassee | Michigan | 26155 | 3405 | 65 |
944471 | 944471 | 2021-01-19 | Shiawassee | Michigan | 26155 | 3375 | 65 |
941226 | 941226 | 2021-01-18 | Shiawassee | Michigan | 26155 | 3366 | 65 |
937981 | 937981 | 2021-01-17 | Shiawassee | Michigan | 26155 | 3328 | 65 |
934736 | 934736 | 2021-01-16 | Shiawassee | Michigan | 26155 | 3328 | 65 |
931491 | 931491 | 2021-01-15 | Shiawassee | Michigan | 26155 | 3315 | 64 |
928246 | 928246 | 2021-01-14 | Shiawassee | Michigan | 26155 | 3298 | 63 |
925000 | 925000 | 2021-01-13 | Shiawassee | Michigan | 26155 | 3274 | 62 |
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 |
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);