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 |
---|---|---|---|---|---|---|---|
1194429 | 1194429 | 2021-04-06 | Tuscola | Michigan | 26157 | 4355 | 144 |
1191180 | 1191180 | 2021-04-05 | Tuscola | Michigan | 26157 | 4298 | 142 |
1187932 | 1187932 | 2021-04-04 | Tuscola | Michigan | 26157 | 4217 | 142 |
1184685 | 1184685 | 2021-04-03 | Tuscola | Michigan | 26157 | 4217 | 142 |
1181439 | 1181439 | 2021-04-02 | Tuscola | Michigan | 26157 | 4146 | 141 |
1178192 | 1178192 | 2021-04-01 | Tuscola | Michigan | 26157 | 4088 | 141 |
1174945 | 1174945 | 2021-03-31 | Tuscola | Michigan | 26157 | 4009 | 141 |
1171698 | 1171698 | 2021-03-30 | Tuscola | Michigan | 26157 | 3927 | 141 |
1168450 | 1168450 | 2021-03-29 | Tuscola | Michigan | 26157 | 3874 | 140 |
1165202 | 1165202 | 2021-03-28 | Tuscola | Michigan | 26157 | 3815 | 140 |
1161954 | 1161954 | 2021-03-27 | Tuscola | Michigan | 26157 | 3815 | 140 |
1158706 | 1158706 | 2021-03-26 | Tuscola | Michigan | 26157 | 3766 | 140 |
1155459 | 1155459 | 2021-03-25 | Tuscola | Michigan | 26157 | 3726 | 140 |
1152212 | 1152212 | 2021-03-24 | Tuscola | Michigan | 26157 | 3684 | 140 |
1148965 | 1148965 | 2021-03-23 | Tuscola | Michigan | 26157 | 3647 | 140 |
1145718 | 1145718 | 2021-03-22 | Tuscola | Michigan | 26157 | 3591 | 140 |
1142471 | 1142471 | 2021-03-21 | Tuscola | Michigan | 26157 | 3555 | 140 |
1139224 | 1139224 | 2021-03-20 | Tuscola | Michigan | 26157 | 3555 | 140 |
1135978 | 1135978 | 2021-03-19 | Tuscola | Michigan | 26157 | 3535 | 139 |
1132732 | 1132732 | 2021-03-18 | Tuscola | Michigan | 26157 | 3500 | 139 |
1129484 | 1129484 | 2021-03-17 | Tuscola | Michigan | 26157 | 3478 | 139 |
1126237 | 1126237 | 2021-03-16 | Tuscola | Michigan | 26157 | 3445 | 139 |
1122991 | 1122991 | 2021-03-15 | Tuscola | Michigan | 26157 | 3414 | 139 |
1119744 | 1119744 | 2021-03-14 | Tuscola | Michigan | 26157 | 3387 | 139 |
1116497 | 1116497 | 2021-03-13 | Tuscola | Michigan | 26157 | 3387 | 139 |
1113251 | 1113251 | 2021-03-12 | Tuscola | Michigan | 26157 | 3368 | 139 |
1110005 | 1110005 | 2021-03-11 | Tuscola | Michigan | 26157 | 3346 | 139 |
1106759 | 1106759 | 2021-03-10 | Tuscola | Michigan | 26157 | 3329 | 139 |
1103513 | 1103513 | 2021-03-09 | Tuscola | Michigan | 26157 | 3318 | 139 |
1100267 | 1100267 | 2021-03-08 | Tuscola | Michigan | 26157 | 3305 | 138 |
1097020 | 1097020 | 2021-03-07 | Tuscola | Michigan | 26157 | 3293 | 138 |
1093773 | 1093773 | 2021-03-06 | Tuscola | Michigan | 26157 | 3293 | 138 |
1090527 | 1090527 | 2021-03-05 | Tuscola | Michigan | 26157 | 3264 | 138 |
1087282 | 1087282 | 2021-03-04 | Tuscola | Michigan | 26157 | 3254 | 138 |
1084037 | 1084037 | 2021-03-03 | Tuscola | Michigan | 26157 | 3242 | 138 |
1080791 | 1080791 | 2021-03-02 | Tuscola | Michigan | 26157 | 3231 | 138 |
1077545 | 1077545 | 2021-03-01 | Tuscola | Michigan | 26157 | 3217 | 138 |
1074299 | 1074299 | 2021-02-28 | Tuscola | Michigan | 26157 | 3204 | 137 |
1071053 | 1071053 | 2021-02-27 | Tuscola | Michigan | 26157 | 3204 | 137 |
1067808 | 1067808 | 2021-02-26 | Tuscola | Michigan | 26157 | 3189 | 137 |
1064563 | 1064563 | 2021-02-25 | Tuscola | Michigan | 26157 | 3176 | 137 |
1061319 | 1061319 | 2021-02-24 | Tuscola | Michigan | 26157 | 3168 | 137 |
1058073 | 1058073 | 2021-02-23 | Tuscola | Michigan | 26157 | 3153 | 137 |
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 |
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);