ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Eaton" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1392429 | 1392429 | 2021-06-06 | Eaton | Michigan | 26045 | 10122 | 207 |
1389184 | 1389184 | 2021-06-05 | Eaton | Michigan | 26045 | 10122 | 207 |
1385939 | 1385939 | 2021-06-04 | Eaton | Michigan | 26045 | 10120 | 207 |
1382694 | 1382694 | 2021-06-03 | Eaton | Michigan | 26045 | 10117 | 207 |
1379448 | 1379448 | 2021-06-02 | Eaton | Michigan | 26045 | 10111 | 208 |
1376203 | 1376203 | 2021-06-01 | Eaton | Michigan | 26045 | 10099 | 208 |
1372957 | 1372957 | 2021-05-31 | Eaton | Michigan | 26045 | 10091 | 208 |
1369712 | 1369712 | 2021-05-30 | Eaton | Michigan | 26045 | 10091 | 208 |
1366466 | 1366466 | 2021-05-29 | Eaton | Michigan | 26045 | 10091 | 208 |
1363220 | 1363220 | 2021-05-28 | Eaton | Michigan | 26045 | 10090 | 208 |
1359973 | 1359973 | 2021-05-27 | Eaton | Michigan | 26045 | 10082 | 208 |
1356727 | 1356727 | 2021-05-26 | Eaton | Michigan | 26045 | 10075 | 208 |
1353481 | 1353481 | 2021-05-25 | Eaton | Michigan | 26045 | 10064 | 208 |
1350235 | 1350235 | 2021-05-24 | Eaton | Michigan | 26045 | 10054 | 209 |
1346989 | 1346989 | 2021-05-23 | Eaton | Michigan | 26045 | 10039 | 206 |
1343741 | 1343741 | 2021-05-22 | Eaton | Michigan | 26045 | 10039 | 206 |
1340492 | 1340492 | 2021-05-21 | Eaton | Michigan | 26045 | 10035 | 205 |
1337245 | 1337245 | 2021-05-20 | Eaton | Michigan | 26045 | 10026 | 205 |
1333998 | 1333998 | 2021-05-19 | Eaton | Michigan | 26045 | 10004 | 203 |
1330751 | 1330751 | 2021-05-18 | Eaton | Michigan | 26045 | 9983 | 203 |
1327504 | 1327504 | 2021-05-17 | Eaton | Michigan | 26045 | 9964 | 203 |
1324258 | 1324258 | 2021-05-16 | Eaton | Michigan | 26045 | 9952 | 202 |
1321012 | 1321012 | 2021-05-15 | Eaton | Michigan | 26045 | 9952 | 202 |
1317766 | 1317766 | 2021-05-14 | Eaton | Michigan | 26045 | 9941 | 199 |
1314518 | 1314518 | 2021-05-13 | Eaton | Michigan | 26045 | 9926 | 198 |
1311272 | 1311272 | 2021-05-12 | Eaton | Michigan | 26045 | 9910 | 195 |
1308025 | 1308025 | 2021-05-11 | Eaton | Michigan | 26045 | 9880 | 195 |
1304779 | 1304779 | 2021-05-10 | Eaton | Michigan | 26045 | 9867 | 195 |
1301533 | 1301533 | 2021-05-09 | Eaton | Michigan | 26045 | 9834 | 193 |
1298285 | 1298285 | 2021-05-08 | Eaton | Michigan | 26045 | 9834 | 193 |
1295039 | 1295039 | 2021-05-07 | Eaton | Michigan | 26045 | 9822 | 190 |
1291793 | 1291793 | 2021-05-06 | Eaton | Michigan | 26045 | 9803 | 190 |
1288547 | 1288547 | 2021-05-05 | Eaton | Michigan | 26045 | 9770 | 189 |
1285301 | 1285301 | 2021-05-04 | Eaton | Michigan | 26045 | 9748 | 189 |
1282055 | 1282055 | 2021-05-03 | Eaton | Michigan | 26045 | 9717 | 187 |
1278808 | 1278808 | 2021-05-02 | Eaton | Michigan | 26045 | 9681 | 187 |
1275561 | 1275561 | 2021-05-01 | Eaton | Michigan | 26045 | 9681 | 187 |
1272314 | 1272314 | 2021-04-30 | Eaton | Michigan | 26045 | 9648 | 184 |
1269067 | 1269067 | 2021-04-29 | Eaton | Michigan | 26045 | 9625 | 182 |
1265820 | 1265820 | 2021-04-28 | Eaton | Michigan | 26045 | 9580 | 182 |
1262573 | 1262573 | 2021-04-27 | Eaton | Michigan | 26045 | 9555 | 182 |
1259326 | 1259326 | 2021-04-26 | Eaton | Michigan | 26045 | 9498 | 180 |
1256079 | 1256079 | 2021-04-25 | Eaton | Michigan | 26045 | 9413 | 180 |
1252832 | 1252832 | 2021-04-24 | Eaton | Michigan | 26045 | 9413 | 180 |
1249585 | 1249585 | 2021-04-23 | Eaton | Michigan | 26045 | 9367 | 180 |
1246338 | 1246338 | 2021-04-22 | Eaton | Michigan | 26045 | 9338 | 179 |
1243091 | 1243091 | 2021-04-21 | Eaton | Michigan | 26045 | 9276 | 176 |
1239844 | 1239844 | 2021-04-20 | Eaton | Michigan | 26045 | 9209 | 174 |
1236597 | 1236597 | 2021-04-19 | Eaton | Michigan | 26045 | 9181 | 173 |
1233350 | 1233350 | 2021-04-18 | Eaton | Michigan | 26045 | 9097 | 170 |
1230102 | 1230102 | 2021-04-17 | Eaton | Michigan | 26045 | 9097 | 170 |
1226854 | 1226854 | 2021-04-16 | Eaton | Michigan | 26045 | 9036 | 169 |
1223606 | 1223606 | 2021-04-15 | Eaton | Michigan | 26045 | 8936 | 169 |
1220359 | 1220359 | 2021-04-14 | Eaton | Michigan | 26045 | 8871 | 168 |
1217111 | 1217111 | 2021-04-13 | Eaton | Michigan | 26045 | 8807 | 167 |
1213864 | 1213864 | 2021-04-12 | Eaton | Michigan | 26045 | 8699 | 167 |
1210616 | 1210616 | 2021-04-11 | Eaton | Michigan | 26045 | 8581 | 167 |
1207367 | 1207367 | 2021-04-10 | Eaton | Michigan | 26045 | 8581 | 167 |
1204119 | 1204119 | 2021-04-09 | Eaton | Michigan | 26045 | 8469 | 165 |
1200871 | 1200871 | 2021-04-08 | Eaton | Michigan | 26045 | 8367 | 165 |
1197622 | 1197622 | 2021-04-07 | Eaton | Michigan | 26045 | 8265 | 164 |
1194373 | 1194373 | 2021-04-06 | Eaton | Michigan | 26045 | 8148 | 163 |
1191124 | 1191124 | 2021-04-05 | Eaton | Michigan | 26045 | 8031 | 162 |
1187876 | 1187876 | 2021-04-04 | Eaton | Michigan | 26045 | 7895 | 162 |
1184629 | 1184629 | 2021-04-03 | Eaton | Michigan | 26045 | 7895 | 162 |
1181383 | 1181383 | 2021-04-02 | Eaton | Michigan | 26045 | 7789 | 162 |
1178136 | 1178136 | 2021-04-01 | Eaton | Michigan | 26045 | 7706 | 162 |
1174889 | 1174889 | 2021-03-31 | Eaton | Michigan | 26045 | 7583 | 161 |
1171642 | 1171642 | 2021-03-30 | Eaton | Michigan | 26045 | 7491 | 160 |
1168394 | 1168394 | 2021-03-29 | Eaton | Michigan | 26045 | 7375 | 160 |
1165146 | 1165146 | 2021-03-28 | Eaton | Michigan | 26045 | 7257 | 160 |
1161898 | 1161898 | 2021-03-27 | Eaton | Michigan | 26045 | 7257 | 160 |
1158650 | 1158650 | 2021-03-26 | Eaton | Michigan | 26045 | 7204 | 160 |
1155403 | 1155403 | 2021-03-25 | Eaton | Michigan | 26045 | 7095 | 160 |
1152156 | 1152156 | 2021-03-24 | Eaton | Michigan | 26045 | 7041 | 160 |
1148909 | 1148909 | 2021-03-23 | Eaton | Michigan | 26045 | 6959 | 160 |
1145662 | 1145662 | 2021-03-22 | Eaton | Michigan | 26045 | 6903 | 160 |
1142415 | 1142415 | 2021-03-21 | Eaton | Michigan | 26045 | 6833 | 160 |
1139168 | 1139168 | 2021-03-20 | Eaton | Michigan | 26045 | 6833 | 160 |
1135922 | 1135922 | 2021-03-19 | Eaton | Michigan | 26045 | 6797 | 159 |
1132676 | 1132676 | 2021-03-18 | Eaton | Michigan | 26045 | 6728 | 159 |
1129428 | 1129428 | 2021-03-17 | Eaton | Michigan | 26045 | 6680 | 159 |
1126181 | 1126181 | 2021-03-16 | Eaton | Michigan | 26045 | 6648 | 159 |
1122935 | 1122935 | 2021-03-15 | Eaton | Michigan | 26045 | 6611 | 158 |
1119688 | 1119688 | 2021-03-14 | Eaton | Michigan | 26045 | 6548 | 158 |
1116441 | 1116441 | 2021-03-13 | Eaton | Michigan | 26045 | 6548 | 158 |
1113195 | 1113195 | 2021-03-12 | Eaton | Michigan | 26045 | 6525 | 156 |
1109949 | 1109949 | 2021-03-11 | Eaton | Michigan | 26045 | 6496 | 156 |
1106703 | 1106703 | 2021-03-10 | Eaton | Michigan | 26045 | 6455 | 156 |
1103457 | 1103457 | 2021-03-09 | Eaton | Michigan | 26045 | 6429 | 156 |
1100211 | 1100211 | 2021-03-08 | Eaton | Michigan | 26045 | 6426 | 156 |
1096964 | 1096964 | 2021-03-07 | Eaton | Michigan | 26045 | 6407 | 156 |
1093717 | 1093717 | 2021-03-06 | Eaton | Michigan | 26045 | 6407 | 156 |
1090471 | 1090471 | 2021-03-05 | Eaton | Michigan | 26045 | 6388 | 156 |
1087226 | 1087226 | 2021-03-04 | Eaton | Michigan | 26045 | 6379 | 156 |
1083981 | 1083981 | 2021-03-03 | Eaton | Michigan | 26045 | 6353 | 156 |
1080735 | 1080735 | 2021-03-02 | Eaton | Michigan | 26045 | 6329 | 155 |
1077489 | 1077489 | 2021-03-01 | Eaton | Michigan | 26045 | 6307 | 155 |
1074243 | 1074243 | 2021-02-28 | Eaton | Michigan | 26045 | 6276 | 153 |
1070997 | 1070997 | 2021-02-27 | Eaton | Michigan | 26045 | 6276 | 153 |
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);