ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 26137 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194419 | 1194419 | 2021-04-06 | Otsego | Michigan | 26137 | 1793 | 28 |
1191170 | 1191170 | 2021-04-05 | Otsego | Michigan | 26137 | 1775 | 28 |
1187922 | 1187922 | 2021-04-04 | Otsego | Michigan | 26137 | 1715 | 28 |
1184675 | 1184675 | 2021-04-03 | Otsego | Michigan | 26137 | 1715 | 28 |
1181429 | 1181429 | 2021-04-02 | Otsego | Michigan | 26137 | 1692 | 28 |
1178182 | 1178182 | 2021-04-01 | Otsego | Michigan | 26137 | 1673 | 28 |
1174935 | 1174935 | 2021-03-31 | Otsego | Michigan | 26137 | 1636 | 28 |
1171688 | 1171688 | 2021-03-30 | Otsego | Michigan | 26137 | 1615 | 28 |
1168440 | 1168440 | 2021-03-29 | Otsego | Michigan | 26137 | 1599 | 28 |
1165192 | 1165192 | 2021-03-28 | Otsego | Michigan | 26137 | 1542 | 28 |
1161944 | 1161944 | 2021-03-27 | Otsego | Michigan | 26137 | 1542 | 28 |
1158696 | 1158696 | 2021-03-26 | Otsego | Michigan | 26137 | 1534 | 28 |
1155449 | 1155449 | 2021-03-25 | Otsego | Michigan | 26137 | 1512 | 28 |
1152202 | 1152202 | 2021-03-24 | Otsego | Michigan | 26137 | 1494 | 28 |
1148955 | 1148955 | 2021-03-23 | Otsego | Michigan | 26137 | 1470 | 28 |
1145708 | 1145708 | 2021-03-22 | Otsego | Michigan | 26137 | 1451 | 28 |
1142461 | 1142461 | 2021-03-21 | Otsego | Michigan | 26137 | 1398 | 28 |
1139214 | 1139214 | 2021-03-20 | Otsego | Michigan | 26137 | 1398 | 28 |
1135968 | 1135968 | 2021-03-19 | Otsego | Michigan | 26137 | 1392 | 28 |
1132722 | 1132722 | 2021-03-18 | Otsego | Michigan | 26137 | 1378 | 28 |
1129474 | 1129474 | 2021-03-17 | Otsego | Michigan | 26137 | 1352 | 27 |
1126227 | 1126227 | 2021-03-16 | Otsego | Michigan | 26137 | 1332 | 27 |
1122981 | 1122981 | 2021-03-15 | Otsego | Michigan | 26137 | 1319 | 27 |
1119734 | 1119734 | 2021-03-14 | Otsego | Michigan | 26137 | 1288 | 27 |
1116487 | 1116487 | 2021-03-13 | Otsego | Michigan | 26137 | 1288 | 27 |
1113241 | 1113241 | 2021-03-12 | Otsego | Michigan | 26137 | 1288 | 27 |
1109995 | 1109995 | 2021-03-11 | Otsego | Michigan | 26137 | 1272 | 27 |
1106749 | 1106749 | 2021-03-10 | Otsego | Michigan | 26137 | 1257 | 27 |
1103503 | 1103503 | 2021-03-09 | Otsego | Michigan | 26137 | 1236 | 27 |
1100257 | 1100257 | 2021-03-08 | Otsego | Michigan | 26137 | 1218 | 27 |
1097010 | 1097010 | 2021-03-07 | Otsego | Michigan | 26137 | 1196 | 27 |
1093763 | 1093763 | 2021-03-06 | Otsego | Michigan | 26137 | 1196 | 27 |
1090517 | 1090517 | 2021-03-05 | Otsego | Michigan | 26137 | 1196 | 27 |
1087272 | 1087272 | 2021-03-04 | Otsego | Michigan | 26137 | 1191 | 28 |
1084027 | 1084027 | 2021-03-03 | Otsego | Michigan | 26137 | 1181 | 27 |
1080781 | 1080781 | 2021-03-02 | Otsego | Michigan | 26137 | 1170 | 27 |
1077535 | 1077535 | 2021-03-01 | Otsego | Michigan | 26137 | 1170 | 27 |
1074289 | 1074289 | 2021-02-28 | Otsego | Michigan | 26137 | 1168 | 26 |
1071043 | 1071043 | 2021-02-27 | Otsego | Michigan | 26137 | 1168 | 26 |
1067798 | 1067798 | 2021-02-26 | Otsego | Michigan | 26137 | 1168 | 25 |
1064553 | 1064553 | 2021-02-25 | Otsego | Michigan | 26137 | 1166 | 25 |
1061309 | 1061309 | 2021-02-24 | Otsego | Michigan | 26137 | 1163 | 25 |
1058063 | 1058063 | 2021-02-23 | Otsego | Michigan | 26137 | 1160 | 25 |
1054817 | 1054817 | 2021-02-22 | Otsego | Michigan | 26137 | 1160 | 25 |
1051570 | 1051570 | 2021-02-21 | Otsego | Michigan | 26137 | 1151 | 25 |
1048323 | 1048323 | 2021-02-20 | Otsego | Michigan | 26137 | 1151 | 25 |
1045077 | 1045077 | 2021-02-19 | Otsego | Michigan | 26137 | 1151 | 25 |
1041832 | 1041832 | 2021-02-18 | Otsego | Michigan | 26137 | 1146 | 25 |
1038587 | 1038587 | 2021-02-17 | Otsego | Michigan | 26137 | 1145 | 25 |
1035342 | 1035342 | 2021-02-16 | Otsego | Michigan | 26137 | 1143 | 25 |
1032097 | 1032097 | 2021-02-15 | Otsego | Michigan | 26137 | 1128 | 25 |
1028850 | 1028850 | 2021-02-14 | Otsego | Michigan | 26137 | 1128 | 25 |
1025604 | 1025604 | 2021-02-13 | Otsego | Michigan | 26137 | 1128 | 25 |
1022359 | 1022359 | 2021-02-12 | Otsego | Michigan | 26137 | 1127 | 25 |
1019114 | 1019114 | 2021-02-11 | Otsego | Michigan | 26137 | 1127 | 25 |
1015869 | 1015869 | 2021-02-10 | Otsego | Michigan | 26137 | 1126 | 25 |
1012624 | 1012624 | 2021-02-09 | Otsego | Michigan | 26137 | 1126 | 25 |
1009379 | 1009379 | 2021-02-08 | Otsego | Michigan | 26137 | 1126 | 25 |
1006132 | 1006132 | 2021-02-07 | Otsego | Michigan | 26137 | 1123 | 25 |
1002886 | 1002886 | 2021-02-06 | Otsego | Michigan | 26137 | 1123 | 25 |
999641 | 999641 | 2021-02-05 | Otsego | Michigan | 26137 | 1123 | 25 |
996395 | 996395 | 2021-02-04 | Otsego | Michigan | 26137 | 1118 | 25 |
993149 | 993149 | 2021-02-03 | Otsego | Michigan | 26137 | 1117 | 25 |
989903 | 989903 | 2021-02-02 | Otsego | Michigan | 26137 | 1111 | 25 |
986656 | 986656 | 2021-02-01 | Otsego | Michigan | 26137 | 1103 | 25 |
983409 | 983409 | 2021-01-31 | Otsego | Michigan | 26137 | 1100 | 25 |
980163 | 980163 | 2021-01-30 | Otsego | Michigan | 26137 | 1100 | 25 |
976917 | 976917 | 2021-01-29 | Otsego | Michigan | 26137 | 1100 | 25 |
973672 | 973672 | 2021-01-28 | Otsego | Michigan | 26137 | 1099 | 25 |
970427 | 970427 | 2021-01-27 | Otsego | Michigan | 26137 | 1098 | 25 |
967182 | 967182 | 2021-01-26 | Otsego | Michigan | 26137 | 1093 | 25 |
963938 | 963938 | 2021-01-25 | Otsego | Michigan | 26137 | 1092 | 25 |
960693 | 960693 | 2021-01-24 | Otsego | Michigan | 26137 | 1089 | 25 |
957447 | 957447 | 2021-01-23 | Otsego | Michigan | 26137 | 1089 | 25 |
954202 | 954202 | 2021-01-22 | Otsego | Michigan | 26137 | 1089 | 25 |
950957 | 950957 | 2021-01-21 | Otsego | Michigan | 26137 | 1088 | 25 |
947711 | 947711 | 2021-01-20 | Otsego | Michigan | 26137 | 1086 | 25 |
944464 | 944464 | 2021-01-19 | Otsego | Michigan | 26137 | 1085 | 25 |
941219 | 941219 | 2021-01-18 | Otsego | Michigan | 26137 | 1084 | 25 |
937974 | 937974 | 2021-01-17 | Otsego | Michigan | 26137 | 1082 | 25 |
934729 | 934729 | 2021-01-16 | Otsego | Michigan | 26137 | 1082 | 25 |
931484 | 931484 | 2021-01-15 | Otsego | Michigan | 26137 | 1082 | 25 |
928239 | 928239 | 2021-01-14 | Otsego | Michigan | 26137 | 1076 | 25 |
924993 | 924993 | 2021-01-13 | Otsego | Michigan | 26137 | 1073 | 25 |
921748 | 921748 | 2021-01-12 | Otsego | Michigan | 26137 | 1067 | 25 |
918503 | 918503 | 2021-01-11 | Otsego | Michigan | 26137 | 1062 | 25 |
915258 | 915258 | 2021-01-10 | Otsego | Michigan | 26137 | 1056 | 25 |
912013 | 912013 | 2021-01-09 | Otsego | Michigan | 26137 | 1056 | 25 |
908768 | 908768 | 2021-01-08 | Otsego | Michigan | 26137 | 1056 | 25 |
905522 | 905522 | 2021-01-07 | Otsego | Michigan | 26137 | 1042 | 25 |
902277 | 902277 | 2021-01-06 | Otsego | Michigan | 26137 | 1042 | 24 |
899032 | 899032 | 2021-01-05 | Otsego | Michigan | 26137 | 1037 | 24 |
895787 | 895787 | 2021-01-04 | Otsego | Michigan | 26137 | 1033 | 24 |
892540 | 892540 | 2021-01-03 | Otsego | Michigan | 26137 | 1031 | 23 |
889294 | 889294 | 2021-01-02 | Otsego | Michigan | 26137 | 1026 | 23 |
886048 | 886048 | 2021-01-01 | Otsego | Michigan | 26137 | 1026 | 22 |
882803 | 882803 | 2020-12-31 | Otsego | Michigan | 26137 | 1026 | 22 |
879558 | 879558 | 2020-12-30 | Otsego | Michigan | 26137 | 1026 | 22 |
876313 | 876313 | 2020-12-29 | Otsego | Michigan | 26137 | 1026 | 22 |
873068 | 873068 | 2020-12-28 | Otsego | Michigan | 26137 | 1021 | 21 |
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);