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 |
---|---|---|---|---|---|---|---|
636137 | 636137 | 2020-10-16 | Berrien | Michigan | 26021 | 2359 | 78 |
632891 | 632891 | 2020-10-15 | Berrien | Michigan | 26021 | 2254 | 77 |
629646 | 629646 | 2020-10-14 | Berrien | Michigan | 26021 | 2219 | 77 |
626402 | 626402 | 2020-10-13 | Berrien | Michigan | 26021 | 2219 | 77 |
623160 | 623160 | 2020-10-12 | Berrien | Michigan | 26021 | 2203 | 76 |
619917 | 619917 | 2020-10-11 | Berrien | Michigan | 26021 | 2168 | 76 |
616675 | 616675 | 2020-10-10 | Berrien | Michigan | 26021 | 2168 | 76 |
613434 | 613434 | 2020-10-09 | Berrien | Michigan | 26021 | 2122 | 76 |
610192 | 610192 | 2020-10-08 | Berrien | Michigan | 26021 | 2118 | 76 |
606950 | 606950 | 2020-10-07 | Berrien | Michigan | 26021 | 2092 | 76 |
603707 | 603707 | 2020-10-06 | Berrien | Michigan | 26021 | 2067 | 75 |
600465 | 600465 | 2020-10-05 | Berrien | Michigan | 26021 | 2054 | 75 |
597222 | 597222 | 2020-10-04 | Berrien | Michigan | 26021 | 2041 | 75 |
593981 | 593981 | 2020-10-03 | Berrien | Michigan | 26021 | 2028 | 75 |
590740 | 590740 | 2020-10-02 | Berrien | Michigan | 26021 | 2007 | 75 |
587499 | 587499 | 2020-10-01 | Berrien | Michigan | 26021 | 1981 | 75 |
584259 | 584259 | 2020-09-30 | Berrien | Michigan | 26021 | 1981 | 74 |
581018 | 581018 | 2020-09-29 | Berrien | Michigan | 26021 | 1968 | 74 |
577777 | 577777 | 2020-09-28 | Berrien | Michigan | 26021 | 1959 | 74 |
574536 | 574536 | 2020-09-27 | Berrien | Michigan | 26021 | 1954 | 74 |
571293 | 571293 | 2020-09-26 | Berrien | Michigan | 26021 | 1946 | 74 |
568051 | 568051 | 2020-09-25 | Berrien | Michigan | 26021 | 1935 | 74 |
564811 | 564811 | 2020-09-24 | Berrien | Michigan | 26021 | 1917 | 74 |
561571 | 561571 | 2020-09-23 | Berrien | Michigan | 26021 | 1908 | 74 |
558334 | 558334 | 2020-09-22 | Berrien | Michigan | 26021 | 1900 | 73 |
555097 | 555097 | 2020-09-21 | Berrien | Michigan | 26021 | 1865 | 72 |
551859 | 551859 | 2020-09-20 | Berrien | Michigan | 26021 | 1865 | 72 |
548620 | 548620 | 2020-09-19 | Berrien | Michigan | 26021 | 1854 | 72 |
545382 | 545382 | 2020-09-18 | Berrien | Michigan | 26021 | 1845 | 72 |
542145 | 542145 | 2020-09-17 | Berrien | Michigan | 26021 | 1839 | 72 |
538909 | 538909 | 2020-09-16 | Berrien | Michigan | 26021 | 1825 | 72 |
535672 | 535672 | 2020-09-15 | Berrien | Michigan | 26021 | 1811 | 72 |
532437 | 532437 | 2020-09-14 | Berrien | Michigan | 26021 | 1807 | 72 |
529201 | 529201 | 2020-09-13 | Berrien | Michigan | 26021 | 1799 | 72 |
525965 | 525965 | 2020-09-12 | Berrien | Michigan | 26021 | 1808 | 72 |
522729 | 522729 | 2020-09-11 | Berrien | Michigan | 26021 | 1790 | 72 |
519492 | 519492 | 2020-09-10 | Berrien | Michigan | 26021 | 1768 | 72 |
516257 | 516257 | 2020-09-09 | Berrien | Michigan | 26021 | 1758 | 72 |
513023 | 513023 | 2020-09-08 | Berrien | Michigan | 26021 | 1758 | 71 |
509791 | 509791 | 2020-09-07 | Berrien | Michigan | 26021 | 1754 | 70 |
506558 | 506558 | 2020-09-06 | Berrien | Michigan | 26021 | 1745 | 70 |
503325 | 503325 | 2020-09-05 | Berrien | Michigan | 26021 | 1734 | 70 |
500091 | 500091 | 2020-09-04 | Berrien | Michigan | 26021 | 1724 | 70 |
496857 | 496857 | 2020-09-03 | Berrien | Michigan | 26021 | 1702 | 70 |
493624 | 493624 | 2020-09-02 | Berrien | Michigan | 26021 | 1693 | 70 |
490390 | 490390 | 2020-09-01 | Berrien | Michigan | 26021 | 1691 | 70 |
487157 | 487157 | 2020-08-31 | Berrien | Michigan | 26021 | 1683 | 70 |
483923 | 483923 | 2020-08-30 | Berrien | Michigan | 26021 | 1673 | 70 |
480688 | 480688 | 2020-08-29 | Berrien | Michigan | 26021 | 1663 | 70 |
477456 | 477456 | 2020-08-28 | Berrien | Michigan | 26021 | 1661 | 70 |
474223 | 474223 | 2020-08-27 | Berrien | Michigan | 26021 | 1644 | 70 |
470991 | 470991 | 2020-08-26 | Berrien | Michigan | 26021 | 1630 | 69 |
467761 | 467761 | 2020-08-25 | Berrien | Michigan | 26021 | 1622 | 69 |
464532 | 464532 | 2020-08-24 | Berrien | Michigan | 26021 | 1614 | 69 |
461301 | 461301 | 2020-08-23 | Berrien | Michigan | 26021 | 1584 | 69 |
458074 | 458074 | 2020-08-22 | Berrien | Michigan | 26021 | 1583 | 69 |
454846 | 454846 | 2020-08-21 | Berrien | Michigan | 26021 | 1561 | 69 |
451618 | 451618 | 2020-08-20 | Berrien | Michigan | 26021 | 1557 | 69 |
448390 | 448390 | 2020-08-19 | Berrien | Michigan | 26021 | 1550 | 69 |
445164 | 445164 | 2020-08-18 | Berrien | Michigan | 26021 | 1537 | 69 |
441938 | 441938 | 2020-08-17 | Berrien | Michigan | 26021 | 1530 | 68 |
438711 | 438711 | 2020-08-16 | Berrien | Michigan | 26021 | 1525 | 69 |
435486 | 435486 | 2020-08-15 | Berrien | Michigan | 26021 | 1517 | 69 |
432260 | 432260 | 2020-08-14 | Berrien | Michigan | 26021 | 1493 | 67 |
429033 | 429033 | 2020-08-13 | Berrien | Michigan | 26021 | 1472 | 67 |
425809 | 425809 | 2020-08-12 | Berrien | Michigan | 26021 | 1454 | 67 |
422587 | 422587 | 2020-08-11 | Berrien | Michigan | 26021 | 1444 | 67 |
419365 | 419365 | 2020-08-10 | Berrien | Michigan | 26021 | 1438 | 66 |
416144 | 416144 | 2020-08-09 | Berrien | Michigan | 26021 | 1426 | 66 |
412924 | 412924 | 2020-08-08 | Berrien | Michigan | 26021 | 1420 | 66 |
409704 | 409704 | 2020-08-07 | Berrien | Michigan | 26021 | 1410 | 66 |
406484 | 406484 | 2020-08-06 | Berrien | Michigan | 26021 | 1398 | 66 |
403266 | 403266 | 2020-08-05 | Berrien | Michigan | 26021 | 1379 | 66 |
400049 | 400049 | 2020-08-04 | Berrien | Michigan | 26021 | 1363 | 65 |
396835 | 396835 | 2020-08-03 | Berrien | Michigan | 26021 | 1356 | 65 |
393619 | 393619 | 2020-08-02 | Berrien | Michigan | 26021 | 1354 | 65 |
390402 | 390402 | 2020-08-01 | Berrien | Michigan | 26021 | 1343 | 65 |
387185 | 387185 | 2020-07-31 | Berrien | Michigan | 26021 | 1333 | 64 |
383967 | 383967 | 2020-07-30 | Berrien | Michigan | 26021 | 1326 | 64 |
380750 | 380750 | 2020-07-29 | Berrien | Michigan | 26021 | 1317 | 64 |
377533 | 377533 | 2020-07-28 | Berrien | Michigan | 26021 | 1304 | 64 |
374318 | 374318 | 2020-07-27 | Berrien | Michigan | 26021 | 1297 | 63 |
371106 | 371106 | 2020-07-26 | Berrien | Michigan | 26021 | 1291 | 63 |
367896 | 367896 | 2020-07-25 | Berrien | Michigan | 26021 | 1265 | 63 |
364689 | 364689 | 2020-07-24 | Berrien | Michigan | 26021 | 1259 | 63 |
361482 | 361482 | 2020-07-23 | Berrien | Michigan | 26021 | 1247 | 63 |
358277 | 358277 | 2020-07-22 | Berrien | Michigan | 26021 | 1218 | 61 |
355074 | 355074 | 2020-07-21 | Berrien | Michigan | 26021 | 1207 | 61 |
351872 | 351872 | 2020-07-20 | Berrien | Michigan | 26021 | 1193 | 61 |
348672 | 348672 | 2020-07-19 | Berrien | Michigan | 26021 | 1177 | 61 |
345471 | 345471 | 2020-07-18 | Berrien | Michigan | 26021 | 1161 | 61 |
342271 | 342271 | 2020-07-17 | Berrien | Michigan | 26021 | 1141 | 61 |
339075 | 339075 | 2020-07-16 | Berrien | Michigan | 26021 | 1117 | 61 |
335879 | 335879 | 2020-07-15 | Berrien | Michigan | 26021 | 1106 | 61 |
332686 | 332686 | 2020-07-14 | Berrien | Michigan | 26021 | 1089 | 61 |
329499 | 329499 | 2020-07-13 | Berrien | Michigan | 26021 | 1084 | 60 |
326313 | 326313 | 2020-07-12 | Berrien | Michigan | 26021 | 1069 | 60 |
323130 | 323130 | 2020-07-11 | Berrien | Michigan | 26021 | 1064 | 60 |
319951 | 319951 | 2020-07-10 | Berrien | Michigan | 26021 | 1046 | 60 |
316776 | 316776 | 2020-07-09 | Berrien | Michigan | 26021 | 1030 | 60 |
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);