ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Clinton" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921698 | 921698 | 2021-01-12 | Clinton | Michigan | 26037 | 4376 | 50 |
918453 | 918453 | 2021-01-11 | Clinton | Michigan | 26037 | 4344 | 50 |
915208 | 915208 | 2021-01-10 | Clinton | Michigan | 26037 | 4297 | 48 |
911963 | 911963 | 2021-01-09 | Clinton | Michigan | 26037 | 4297 | 48 |
908718 | 908718 | 2021-01-08 | Clinton | Michigan | 26037 | 4270 | 44 |
905472 | 905472 | 2021-01-07 | Clinton | Michigan | 26037 | 4220 | 44 |
902227 | 902227 | 2021-01-06 | Clinton | Michigan | 26037 | 4209 | 44 |
898982 | 898982 | 2021-01-05 | Clinton | Michigan | 26037 | 4167 | 44 |
895737 | 895737 | 2021-01-04 | Clinton | Michigan | 26037 | 4128 | 42 |
892490 | 892490 | 2021-01-03 | Clinton | Michigan | 26037 | 4012 | 41 |
889244 | 889244 | 2021-01-02 | Clinton | Michigan | 26037 | 4012 | 41 |
885998 | 885998 | 2021-01-01 | Clinton | Michigan | 26037 | 3879 | 40 |
882753 | 882753 | 2020-12-31 | Clinton | Michigan | 26037 | 3879 | 40 |
879508 | 879508 | 2020-12-30 | Clinton | Michigan | 26037 | 3879 | 40 |
876263 | 876263 | 2020-12-29 | Clinton | Michigan | 26037 | 3834 | 39 |
873018 | 873018 | 2020-12-28 | Clinton | Michigan | 26037 | 3743 | 40 |
869773 | 869773 | 2020-12-27 | Clinton | Michigan | 26037 | 3697 | 39 |
866528 | 866528 | 2020-12-26 | Clinton | Michigan | 26037 | 3697 | 39 |
863283 | 863283 | 2020-12-25 | Clinton | Michigan | 26037 | 3652 | 38 |
860038 | 860038 | 2020-12-24 | Clinton | Michigan | 26037 | 3652 | 38 |
856793 | 856793 | 2020-12-23 | Clinton | Michigan | 26037 | 3652 | 38 |
853548 | 853548 | 2020-12-22 | Clinton | Michigan | 26037 | 3622 | 37 |
850303 | 850303 | 2020-12-21 | Clinton | Michigan | 26037 | 3594 | 34 |
847058 | 847058 | 2020-12-20 | Clinton | Michigan | 26037 | 3539 | 33 |
843812 | 843812 | 2020-12-19 | Clinton | Michigan | 26037 | 3539 | 33 |
840567 | 840567 | 2020-12-18 | Clinton | Michigan | 26037 | 3599 | 34 |
837322 | 837322 | 2020-12-17 | Clinton | Michigan | 26037 | 3556 | 34 |
834076 | 834076 | 2020-12-16 | Clinton | Michigan | 26037 | 3499 | 32 |
830829 | 830829 | 2020-12-15 | Clinton | Michigan | 26037 | 3451 | 31 |
827583 | 827583 | 2020-12-14 | Clinton | Michigan | 26037 | 3406 | 29 |
824336 | 824336 | 2020-12-13 | Clinton | Michigan | 26037 | 3349 | 29 |
821090 | 821090 | 2020-12-12 | Clinton | Michigan | 26037 | 3349 | 29 |
817844 | 817844 | 2020-12-11 | Clinton | Michigan | 26037 | 3311 | 29 |
814598 | 814598 | 2020-12-10 | Clinton | Michigan | 26037 | 3285 | 29 |
811353 | 811353 | 2020-12-09 | Clinton | Michigan | 26037 | 3232 | 27 |
808108 | 808108 | 2020-12-08 | Clinton | Michigan | 26037 | 3190 | 29 |
804863 | 804863 | 2020-12-07 | Clinton | Michigan | 26037 | 3153 | 29 |
801618 | 801618 | 2020-12-06 | Clinton | Michigan | 26037 | 3099 | 27 |
798373 | 798373 | 2020-12-05 | Clinton | Michigan | 26037 | 3099 | 27 |
795128 | 795128 | 2020-12-04 | Clinton | Michigan | 26037 | 3070 | 24 |
791883 | 791883 | 2020-12-03 | Clinton | Michigan | 26037 | 3026 | 24 |
788638 | 788638 | 2020-12-02 | Clinton | Michigan | 26037 | 2939 | 24 |
785393 | 785393 | 2020-12-01 | Clinton | Michigan | 26037 | 2871 | 23 |
782149 | 782149 | 2020-11-30 | Clinton | Michigan | 26037 | 2788 | 23 |
778903 | 778903 | 2020-11-29 | Clinton | Michigan | 26037 | 2687 | 22 |
775658 | 775658 | 2020-11-28 | Clinton | Michigan | 26037 | 2687 | 22 |
772413 | 772413 | 2020-11-27 | Clinton | Michigan | 26037 | 2612 | 22 |
769168 | 769168 | 2020-11-26 | Clinton | Michigan | 26037 | 2534 | 22 |
765922 | 765922 | 2020-11-25 | Clinton | Michigan | 26037 | 2534 | 22 |
762677 | 762677 | 2020-11-24 | Clinton | Michigan | 26037 | 2513 | 20 |
759432 | 759432 | 2020-11-23 | Clinton | Michigan | 26037 | 2495 | 20 |
756185 | 756185 | 2020-11-22 | Clinton | Michigan | 26037 | 2396 | 19 |
752939 | 752939 | 2020-11-21 | Clinton | Michigan | 26037 | 2396 | 19 |
749693 | 749693 | 2020-11-20 | Clinton | Michigan | 26037 | 2341 | 18 |
746447 | 746447 | 2020-11-19 | Clinton | Michigan | 26037 | 2286 | 18 |
743200 | 743200 | 2020-11-18 | Clinton | Michigan | 26037 | 2232 | 18 |
739953 | 739953 | 2020-11-17 | Clinton | Michigan | 26037 | 2193 | 18 |
736709 | 736709 | 2020-11-16 | Clinton | Michigan | 26037 | 2152 | 18 |
733463 | 733463 | 2020-11-15 | Clinton | Michigan | 26037 | 2042 | 18 |
730218 | 730218 | 2020-11-14 | Clinton | Michigan | 26037 | 2042 | 18 |
726975 | 726975 | 2020-11-13 | Clinton | Michigan | 26037 | 1942 | 18 |
723732 | 723732 | 2020-11-12 | Clinton | Michigan | 26037 | 1814 | 18 |
720489 | 720489 | 2020-11-11 | Clinton | Michigan | 26037 | 1750 | 18 |
717246 | 717246 | 2020-11-10 | Clinton | Michigan | 26037 | 1692 | 18 |
714002 | 714002 | 2020-11-09 | Clinton | Michigan | 26037 | 1640 | 18 |
710758 | 710758 | 2020-11-08 | Clinton | Michigan | 26037 | 1577 | 17 |
707514 | 707514 | 2020-11-07 | Clinton | Michigan | 26037 | 1577 | 17 |
704271 | 704271 | 2020-11-06 | Clinton | Michigan | 26037 | 1536 | 17 |
701029 | 701029 | 2020-11-05 | Clinton | Michigan | 26037 | 1499 | 17 |
697785 | 697785 | 2020-11-04 | Clinton | Michigan | 26037 | 1417 | 16 |
694542 | 694542 | 2020-11-03 | Clinton | Michigan | 26037 | 1380 | 16 |
691300 | 691300 | 2020-11-02 | Clinton | Michigan | 26037 | 1345 | 16 |
688055 | 688055 | 2020-11-01 | Clinton | Michigan | 26037 | 1297 | 16 |
684811 | 684811 | 2020-10-31 | Clinton | Michigan | 26037 | 1297 | 16 |
681568 | 681568 | 2020-10-30 | Clinton | Michigan | 26037 | 1249 | 16 |
678324 | 678324 | 2020-10-29 | Clinton | Michigan | 26037 | 1205 | 16 |
675082 | 675082 | 2020-10-28 | Clinton | Michigan | 26037 | 1149 | 16 |
671839 | 671839 | 2020-10-27 | Clinton | Michigan | 26037 | 1125 | 16 |
668597 | 668597 | 2020-10-26 | Clinton | Michigan | 26037 | 1091 | 16 |
665353 | 665353 | 2020-10-25 | Clinton | Michigan | 26037 | 1050 | 15 |
662108 | 662108 | 2020-10-24 | Clinton | Michigan | 26037 | 1050 | 15 |
658864 | 658864 | 2020-10-23 | Clinton | Michigan | 26037 | 1007 | 14 |
655619 | 655619 | 2020-10-22 | Clinton | Michigan | 26037 | 972 | 14 |
652374 | 652374 | 2020-10-21 | Clinton | Michigan | 26037 | 963 | 14 |
649129 | 649129 | 2020-10-20 | Clinton | Michigan | 26037 | 918 | 14 |
645885 | 645885 | 2020-10-19 | Clinton | Michigan | 26037 | 906 | 14 |
642638 | 642638 | 2020-10-18 | Clinton | Michigan | 26037 | 857 | 14 |
639391 | 639391 | 2020-10-17 | Clinton | Michigan | 26037 | 857 | 14 |
636145 | 636145 | 2020-10-16 | Clinton | Michigan | 26037 | 857 | 14 |
632899 | 632899 | 2020-10-15 | Clinton | Michigan | 26037 | 844 | 14 |
629654 | 629654 | 2020-10-14 | Clinton | Michigan | 26037 | 821 | 14 |
626410 | 626410 | 2020-10-13 | Clinton | Michigan | 26037 | 815 | 14 |
623168 | 623168 | 2020-10-12 | Clinton | Michigan | 26037 | 805 | 14 |
619925 | 619925 | 2020-10-11 | Clinton | Michigan | 26037 | 789 | 14 |
616683 | 616683 | 2020-10-10 | Clinton | Michigan | 26037 | 789 | 14 |
613442 | 613442 | 2020-10-09 | Clinton | Michigan | 26037 | 779 | 14 |
610200 | 610200 | 2020-10-08 | Clinton | Michigan | 26037 | 770 | 14 |
606958 | 606958 | 2020-10-07 | Clinton | Michigan | 26037 | 762 | 14 |
603715 | 603715 | 2020-10-06 | Clinton | Michigan | 26037 | 754 | 14 |
600473 | 600473 | 2020-10-05 | Clinton | Michigan | 26037 | 746 | 14 |
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);