ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26021 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418381 | 1418381 | 2021-06-14 | Berrien | Michigan | 26021 | 15551 | 289 |
1415136 | 1415136 | 2021-06-13 | Berrien | Michigan | 26021 | 15551 | 289 |
1411890 | 1411890 | 2021-06-12 | Berrien | Michigan | 26021 | 15551 | 289 |
1408645 | 1408645 | 2021-06-11 | Berrien | Michigan | 26021 | 15550 | 288 |
1405400 | 1405400 | 2021-06-10 | Berrien | Michigan | 26021 | 15546 | 288 |
1402154 | 1402154 | 2021-06-09 | Berrien | Michigan | 26021 | 15540 | 288 |
1398909 | 1398909 | 2021-06-08 | Berrien | Michigan | 26021 | 15529 | 288 |
1395663 | 1395663 | 2021-06-07 | Berrien | Michigan | 26021 | 15521 | 288 |
1392417 | 1392417 | 2021-06-06 | Berrien | Michigan | 26021 | 15521 | 287 |
1389172 | 1389172 | 2021-06-05 | Berrien | Michigan | 26021 | 15520 | 287 |
1385927 | 1385927 | 2021-06-04 | Berrien | Michigan | 26021 | 15511 | 287 |
1382682 | 1382682 | 2021-06-03 | Berrien | Michigan | 26021 | 15504 | 287 |
1379436 | 1379436 | 2021-06-02 | Berrien | Michigan | 26021 | 15496 | 286 |
1376191 | 1376191 | 2021-06-01 | Berrien | Michigan | 26021 | 15490 | 286 |
1372945 | 1372945 | 2021-05-31 | Berrien | Michigan | 26021 | 15482 | 286 |
1369700 | 1369700 | 2021-05-30 | Berrien | Michigan | 26021 | 15482 | 286 |
1366454 | 1366454 | 2021-05-29 | Berrien | Michigan | 26021 | 15465 | 286 |
1363208 | 1363208 | 2021-05-28 | Berrien | Michigan | 26021 | 15465 | 286 |
1359961 | 1359961 | 2021-05-27 | Berrien | Michigan | 26021 | 15453 | 284 |
1356715 | 1356715 | 2021-05-26 | Berrien | Michigan | 26021 | 15443 | 283 |
1353469 | 1353469 | 2021-05-25 | Berrien | Michigan | 26021 | 15421 | 283 |
1350223 | 1350223 | 2021-05-24 | Berrien | Michigan | 26021 | 15404 | 282 |
1346977 | 1346977 | 2021-05-23 | Berrien | Michigan | 26021 | 15383 | 282 |
1343729 | 1343729 | 2021-05-22 | Berrien | Michigan | 26021 | 15379 | 282 |
1340480 | 1340480 | 2021-05-21 | Berrien | Michigan | 26021 | 15366 | 282 |
1337233 | 1337233 | 2021-05-20 | Berrien | Michigan | 26021 | 15347 | 281 |
1333986 | 1333986 | 2021-05-19 | Berrien | Michigan | 26021 | 15317 | 278 |
1330739 | 1330739 | 2021-05-18 | Berrien | Michigan | 26021 | 15286 | 278 |
1327492 | 1327492 | 2021-05-17 | Berrien | Michigan | 26021 | 15248 | 278 |
1324246 | 1324246 | 2021-05-16 | Berrien | Michigan | 26021 | 15236 | 278 |
1321000 | 1321000 | 2021-05-15 | Berrien | Michigan | 26021 | 15216 | 278 |
1317754 | 1317754 | 2021-05-14 | Berrien | Michigan | 26021 | 15179 | 277 |
1314506 | 1314506 | 2021-05-13 | Berrien | Michigan | 26021 | 15149 | 276 |
1311260 | 1311260 | 2021-05-12 | Berrien | Michigan | 26021 | 15121 | 275 |
1308013 | 1308013 | 2021-05-11 | Berrien | Michigan | 26021 | 15100 | 275 |
1304767 | 1304767 | 2021-05-10 | Berrien | Michigan | 26021 | 15066 | 274 |
1301521 | 1301521 | 2021-05-09 | Berrien | Michigan | 26021 | 15058 | 273 |
1298273 | 1298273 | 2021-05-08 | Berrien | Michigan | 26021 | 15029 | 273 |
1295027 | 1295027 | 2021-05-07 | Berrien | Michigan | 26021 | 14993 | 271 |
1291781 | 1291781 | 2021-05-06 | Berrien | Michigan | 26021 | 14945 | 271 |
1288535 | 1288535 | 2021-05-05 | Berrien | Michigan | 26021 | 14915 | 270 |
1285289 | 1285289 | 2021-05-04 | Berrien | Michigan | 26021 | 14825 | 270 |
1282043 | 1282043 | 2021-05-03 | Berrien | Michigan | 26021 | 14744 | 270 |
1278796 | 1278796 | 2021-05-02 | Berrien | Michigan | 26021 | 14689 | 270 |
1275549 | 1275549 | 2021-05-01 | Berrien | Michigan | 26021 | 14676 | 270 |
1272302 | 1272302 | 2021-04-30 | Berrien | Michigan | 26021 | 14663 | 268 |
1269055 | 1269055 | 2021-04-29 | Berrien | Michigan | 26021 | 14640 | 268 |
1265808 | 1265808 | 2021-04-28 | Berrien | Michigan | 26021 | 14569 | 267 |
1262561 | 1262561 | 2021-04-27 | Berrien | Michigan | 26021 | 14516 | 267 |
1259314 | 1259314 | 2021-04-26 | Berrien | Michigan | 26021 | 14465 | 265 |
1256067 | 1256067 | 2021-04-25 | Berrien | Michigan | 26021 | 14420 | 265 |
1252820 | 1252820 | 2021-04-24 | Berrien | Michigan | 26021 | 14384 | 265 |
1249573 | 1249573 | 2021-04-23 | Berrien | Michigan | 26021 | 14334 | 264 |
1246326 | 1246326 | 2021-04-22 | Berrien | Michigan | 26021 | 14283 | 264 |
1243079 | 1243079 | 2021-04-21 | Berrien | Michigan | 26021 | 14227 | 261 |
1239832 | 1239832 | 2021-04-20 | Berrien | Michigan | 26021 | 14160 | 259 |
1236585 | 1236585 | 2021-04-19 | Berrien | Michigan | 26021 | 14104 | 260 |
1233338 | 1233338 | 2021-04-18 | Berrien | Michigan | 26021 | 14044 | 259 |
1230090 | 1230090 | 2021-04-17 | Berrien | Michigan | 26021 | 14012 | 259 |
1226842 | 1226842 | 2021-04-16 | Berrien | Michigan | 26021 | 13943 | 259 |
1223594 | 1223594 | 2021-04-15 | Berrien | Michigan | 26021 | 13847 | 259 |
1220347 | 1220347 | 2021-04-14 | Berrien | Michigan | 26021 | 13795 | 259 |
1217099 | 1217099 | 2021-04-13 | Berrien | Michigan | 26021 | 13681 | 258 |
1213852 | 1213852 | 2021-04-12 | Berrien | Michigan | 26021 | 13576 | 256 |
1210604 | 1210604 | 2021-04-11 | Berrien | Michigan | 26021 | 13523 | 255 |
1207355 | 1207355 | 2021-04-10 | Berrien | Michigan | 26021 | 13472 | 255 |
1204107 | 1204107 | 2021-04-09 | Berrien | Michigan | 26021 | 13420 | 255 |
1200859 | 1200859 | 2021-04-08 | Berrien | Michigan | 26021 | 13323 | 254 |
1197610 | 1197610 | 2021-04-07 | Berrien | Michigan | 26021 | 13285 | 253 |
1194361 | 1194361 | 2021-04-06 | Berrien | Michigan | 26021 | 13198 | 253 |
1191112 | 1191112 | 2021-04-05 | Berrien | Michigan | 26021 | 13149 | 252 |
1187864 | 1187864 | 2021-04-04 | Berrien | Michigan | 26021 | 13081 | 252 |
1184617 | 1184617 | 2021-04-03 | Berrien | Michigan | 26021 | 13043 | 252 |
1181371 | 1181371 | 2021-04-02 | Berrien | Michigan | 26021 | 12930 | 251 |
1178124 | 1178124 | 2021-04-01 | Berrien | Michigan | 26021 | 12930 | 251 |
1174877 | 1174877 | 2021-03-31 | Berrien | Michigan | 26021 | 12856 | 251 |
1171630 | 1171630 | 2021-03-30 | Berrien | Michigan | 26021 | 12780 | 250 |
1168382 | 1168382 | 2021-03-29 | Berrien | Michigan | 26021 | 12691 | 250 |
1165134 | 1165134 | 2021-03-28 | Berrien | Michigan | 26021 | 12603 | 250 |
1161886 | 1161886 | 2021-03-27 | Berrien | Michigan | 26021 | 12603 | 250 |
1158638 | 1158638 | 2021-03-26 | Berrien | Michigan | 26021 | 12553 | 250 |
1155391 | 1155391 | 2021-03-25 | Berrien | Michigan | 26021 | 12502 | 250 |
1152144 | 1152144 | 2021-03-24 | Berrien | Michigan | 26021 | 12418 | 249 |
1148897 | 1148897 | 2021-03-23 | Berrien | Michigan | 26021 | 12378 | 249 |
1145650 | 1145650 | 2021-03-22 | Berrien | Michigan | 26021 | 12300 | 248 |
1142403 | 1142403 | 2021-03-21 | Berrien | Michigan | 26021 | 12257 | 248 |
1139156 | 1139156 | 2021-03-20 | Berrien | Michigan | 26021 | 12233 | 248 |
1135910 | 1135910 | 2021-03-19 | Berrien | Michigan | 26021 | 12194 | 247 |
1132664 | 1132664 | 2021-03-18 | Berrien | Michigan | 26021 | 12113 | 247 |
1129416 | 1129416 | 2021-03-17 | Berrien | Michigan | 26021 | 12089 | 248 |
1126169 | 1126169 | 2021-03-16 | Berrien | Michigan | 26021 | 12004 | 248 |
1122923 | 1122923 | 2021-03-15 | Berrien | Michigan | 26021 | 11981 | 247 |
1119676 | 1119676 | 2021-03-14 | Berrien | Michigan | 26021 | 11959 | 247 |
1116429 | 1116429 | 2021-03-13 | Berrien | Michigan | 26021 | 11935 | 247 |
1113183 | 1113183 | 2021-03-12 | Berrien | Michigan | 26021 | 11897 | 246 |
1109937 | 1109937 | 2021-03-11 | Berrien | Michigan | 26021 | 11870 | 245 |
1106691 | 1106691 | 2021-03-10 | Berrien | Michigan | 26021 | 11831 | 245 |
1103445 | 1103445 | 2021-03-09 | Berrien | Michigan | 26021 | 11782 | 245 |
1100199 | 1100199 | 2021-03-08 | Berrien | Michigan | 26021 | 11755 | 245 |
1096952 | 1096952 | 2021-03-07 | Berrien | Michigan | 26021 | 11732 | 245 |
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);