ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26157 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054827 | 1054827 | 2021-02-22 | Tuscola | Michigan | 26157 | 3150 | 137 |
1051580 | 1051580 | 2021-02-21 | Tuscola | Michigan | 26157 | 3137 | 137 |
1048333 | 1048333 | 2021-02-20 | Tuscola | Michigan | 26157 | 3137 | 137 |
1045087 | 1045087 | 2021-02-19 | Tuscola | Michigan | 26157 | 3133 | 134 |
1041842 | 1041842 | 2021-02-18 | Tuscola | Michigan | 26157 | 3126 | 133 |
1038597 | 1038597 | 2021-02-17 | Tuscola | Michigan | 26157 | 3126 | 132 |
1035352 | 1035352 | 2021-02-16 | Tuscola | Michigan | 26157 | 3122 | 132 |
1032107 | 1032107 | 2021-02-15 | Tuscola | Michigan | 26157 | 3109 | 132 |
1028860 | 1028860 | 2021-02-14 | Tuscola | Michigan | 26157 | 3099 | 132 |
1025614 | 1025614 | 2021-02-13 | Tuscola | Michigan | 26157 | 3099 | 132 |
1022369 | 1022369 | 2021-02-12 | Tuscola | Michigan | 26157 | 3100 | 132 |
1019124 | 1019124 | 2021-02-11 | Tuscola | Michigan | 26157 | 3089 | 132 |
1015879 | 1015879 | 2021-02-10 | Tuscola | Michigan | 26157 | 3078 | 131 |
1012634 | 1012634 | 2021-02-09 | Tuscola | Michigan | 26157 | 3068 | 131 |
1009389 | 1009389 | 2021-02-08 | Tuscola | Michigan | 26157 | 3065 | 131 |
1006142 | 1006142 | 2021-02-07 | Tuscola | Michigan | 26157 | 3056 | 131 |
1002896 | 1002896 | 2021-02-06 | Tuscola | Michigan | 26157 | 3056 | 131 |
999651 | 999651 | 2021-02-05 | Tuscola | Michigan | 26157 | 3054 | 128 |
996405 | 996405 | 2021-02-04 | Tuscola | Michigan | 26157 | 3038 | 128 |
993159 | 993159 | 2021-02-03 | Tuscola | Michigan | 26157 | 3032 | 128 |
989913 | 989913 | 2021-02-02 | Tuscola | Michigan | 26157 | 3030 | 128 |
986666 | 986666 | 2021-02-01 | Tuscola | Michigan | 26157 | 3075 | 127 |
983419 | 983419 | 2021-01-31 | Tuscola | Michigan | 26157 | 3060 | 127 |
980173 | 980173 | 2021-01-30 | Tuscola | Michigan | 26157 | 3060 | 127 |
976927 | 976927 | 2021-01-29 | Tuscola | Michigan | 26157 | 3050 | 127 |
973682 | 973682 | 2021-01-28 | Tuscola | Michigan | 26157 | 3043 | 127 |
970437 | 970437 | 2021-01-27 | Tuscola | Michigan | 26157 | 3036 | 126 |
967192 | 967192 | 2021-01-26 | Tuscola | Michigan | 26157 | 3028 | 126 |
963948 | 963948 | 2021-01-25 | Tuscola | Michigan | 26157 | 3009 | 125 |
960703 | 960703 | 2021-01-24 | Tuscola | Michigan | 26157 | 2993 | 124 |
957457 | 957457 | 2021-01-23 | Tuscola | Michigan | 26157 | 2993 | 124 |
954212 | 954212 | 2021-01-22 | Tuscola | Michigan | 26157 | 2978 | 122 |
950967 | 950967 | 2021-01-21 | Tuscola | Michigan | 26157 | 2961 | 120 |
947721 | 947721 | 2021-01-20 | Tuscola | Michigan | 26157 | 2958 | 116 |
944474 | 944474 | 2021-01-19 | Tuscola | Michigan | 26157 | 2948 | 117 |
941229 | 941229 | 2021-01-18 | Tuscola | Michigan | 26157 | 2946 | 116 |
937984 | 937984 | 2021-01-17 | Tuscola | Michigan | 26157 | 2931 | 114 |
934739 | 934739 | 2021-01-16 | Tuscola | Michigan | 26157 | 2931 | 114 |
931494 | 931494 | 2021-01-15 | Tuscola | Michigan | 26157 | 2927 | 113 |
928249 | 928249 | 2021-01-14 | Tuscola | Michigan | 26157 | 2914 | 109 |
925003 | 925003 | 2021-01-13 | Tuscola | Michigan | 26157 | 2900 | 108 |
921758 | 921758 | 2021-01-12 | Tuscola | Michigan | 26157 | 2891 | 107 |
918513 | 918513 | 2021-01-11 | Tuscola | Michigan | 26157 | 2884 | 106 |
915268 | 915268 | 2021-01-10 | Tuscola | Michigan | 26157 | 2842 | 103 |
912023 | 912023 | 2021-01-09 | Tuscola | Michigan | 26157 | 2842 | 103 |
908778 | 908778 | 2021-01-08 | Tuscola | Michigan | 26157 | 2821 | 102 |
905532 | 905532 | 2021-01-07 | Tuscola | Michigan | 26157 | 2797 | 101 |
902287 | 902287 | 2021-01-06 | Tuscola | Michigan | 26157 | 2769 | 101 |
899042 | 899042 | 2021-01-05 | Tuscola | Michigan | 26157 | 2738 | 101 |
895797 | 895797 | 2021-01-04 | Tuscola | Michigan | 26157 | 2715 | 97 |
892550 | 892550 | 2021-01-03 | Tuscola | Michigan | 26157 | 2686 | 94 |
889304 | 889304 | 2021-01-02 | Tuscola | Michigan | 26157 | 2686 | 94 |
886058 | 886058 | 2021-01-01 | Tuscola | Michigan | 26157 | 2637 | 89 |
882813 | 882813 | 2020-12-31 | Tuscola | Michigan | 26157 | 2637 | 89 |
879568 | 879568 | 2020-12-30 | Tuscola | Michigan | 26157 | 2637 | 89 |
876323 | 876323 | 2020-12-29 | Tuscola | Michigan | 26157 | 2618 | 89 |
873078 | 873078 | 2020-12-28 | Tuscola | Michigan | 26157 | 2605 | 86 |
869833 | 869833 | 2020-12-27 | Tuscola | Michigan | 26157 | 2585 | 86 |
866588 | 866588 | 2020-12-26 | Tuscola | Michigan | 26157 | 2585 | 86 |
863343 | 863343 | 2020-12-25 | Tuscola | Michigan | 26157 | 2551 | 84 |
860098 | 860098 | 2020-12-24 | Tuscola | Michigan | 26157 | 2551 | 84 |
856853 | 856853 | 2020-12-23 | Tuscola | Michigan | 26157 | 2551 | 84 |
853608 | 853608 | 2020-12-22 | Tuscola | Michigan | 26157 | 2415 | 82 |
850363 | 850363 | 2020-12-21 | Tuscola | Michigan | 26157 | 2407 | 81 |
847118 | 847118 | 2020-12-20 | Tuscola | Michigan | 26157 | 2379 | 81 |
843872 | 843872 | 2020-12-19 | Tuscola | Michigan | 26157 | 2379 | 81 |
840627 | 840627 | 2020-12-18 | Tuscola | Michigan | 26157 | 2347 | 80 |
837382 | 837382 | 2020-12-17 | Tuscola | Michigan | 26157 | 2315 | 80 |
834136 | 834136 | 2020-12-16 | Tuscola | Michigan | 26157 | 2289 | 80 |
830889 | 830889 | 2020-12-15 | Tuscola | Michigan | 26157 | 2245 | 75 |
827643 | 827643 | 2020-12-14 | Tuscola | Michigan | 26157 | 2210 | 73 |
824396 | 824396 | 2020-12-13 | Tuscola | Michigan | 26157 | 2169 | 72 |
821150 | 821150 | 2020-12-12 | Tuscola | Michigan | 26157 | 2169 | 72 |
817904 | 817904 | 2020-12-11 | Tuscola | Michigan | 26157 | 2129 | 69 |
814658 | 814658 | 2020-12-10 | Tuscola | Michigan | 26157 | 2083 | 68 |
811413 | 811413 | 2020-12-09 | Tuscola | Michigan | 26157 | 2055 | 67 |
808168 | 808168 | 2020-12-08 | Tuscola | Michigan | 26157 | 2018 | 66 |
804923 | 804923 | 2020-12-07 | Tuscola | Michigan | 26157 | 1999 | 64 |
801678 | 801678 | 2020-12-06 | Tuscola | Michigan | 26157 | 1941 | 61 |
798433 | 798433 | 2020-12-05 | Tuscola | Michigan | 26157 | 1941 | 61 |
795188 | 795188 | 2020-12-04 | Tuscola | Michigan | 26157 | 1911 | 60 |
791943 | 791943 | 2020-12-03 | Tuscola | Michigan | 26157 | 1855 | 60 |
788698 | 788698 | 2020-12-02 | Tuscola | Michigan | 26157 | 1823 | 58 |
785453 | 785453 | 2020-12-01 | Tuscola | Michigan | 26157 | 1796 | 57 |
782209 | 782209 | 2020-11-30 | Tuscola | Michigan | 26157 | 1737 | 54 |
778963 | 778963 | 2020-11-29 | Tuscola | Michigan | 26157 | 1683 | 54 |
775718 | 775718 | 2020-11-28 | Tuscola | Michigan | 26157 | 1683 | 54 |
772473 | 772473 | 2020-11-27 | Tuscola | Michigan | 26157 | 1651 | 51 |
769228 | 769228 | 2020-11-26 | Tuscola | Michigan | 26157 | 1546 | 51 |
765982 | 765982 | 2020-11-25 | Tuscola | Michigan | 26157 | 1546 | 51 |
762737 | 762737 | 2020-11-24 | Tuscola | Michigan | 26157 | 1521 | 50 |
759492 | 759492 | 2020-11-23 | Tuscola | Michigan | 26157 | 1490 | 48 |
756245 | 756245 | 2020-11-22 | Tuscola | Michigan | 26157 | 1426 | 46 |
752999 | 752999 | 2020-11-21 | Tuscola | Michigan | 26157 | 1426 | 46 |
749753 | 749753 | 2020-11-20 | Tuscola | Michigan | 26157 | 1394 | 44 |
746507 | 746507 | 2020-11-19 | Tuscola | Michigan | 26157 | 1343 | 44 |
743260 | 743260 | 2020-11-18 | Tuscola | Michigan | 26157 | 1318 | 43 |
740013 | 740013 | 2020-11-17 | Tuscola | Michigan | 26157 | 1286 | 43 |
736769 | 736769 | 2020-11-16 | Tuscola | Michigan | 26157 | 1241 | 42 |
733523 | 733523 | 2020-11-15 | Tuscola | Michigan | 26157 | 1149 | 41 |
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);