ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 26057 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054777 | 1054777 | 2021-02-22 | Gratiot | Michigan | 26057 | 5633 | 105 |
1051530 | 1051530 | 2021-02-21 | Gratiot | Michigan | 26057 | 5629 | 105 |
1048283 | 1048283 | 2021-02-20 | Gratiot | Michigan | 26057 | 5629 | 105 |
1045037 | 1045037 | 2021-02-19 | Gratiot | Michigan | 26057 | 5627 | 105 |
1041792 | 1041792 | 2021-02-18 | Gratiot | Michigan | 26057 | 5627 | 105 |
1038547 | 1038547 | 2021-02-17 | Gratiot | Michigan | 26057 | 5626 | 103 |
1035302 | 1035302 | 2021-02-16 | Gratiot | Michigan | 26057 | 5625 | 103 |
1032057 | 1032057 | 2021-02-15 | Gratiot | Michigan | 26057 | 5624 | 103 |
1028810 | 1028810 | 2021-02-14 | Gratiot | Michigan | 26057 | 5624 | 104 |
1025564 | 1025564 | 2021-02-13 | Gratiot | Michigan | 26057 | 5624 | 104 |
1022319 | 1022319 | 2021-02-12 | Gratiot | Michigan | 26057 | 5622 | 102 |
1019074 | 1019074 | 2021-02-11 | Gratiot | Michigan | 26057 | 5619 | 102 |
1015829 | 1015829 | 2021-02-10 | Gratiot | Michigan | 26057 | 5618 | 101 |
1012584 | 1012584 | 2021-02-09 | Gratiot | Michigan | 26057 | 5617 | 101 |
1009339 | 1009339 | 2021-02-08 | Gratiot | Michigan | 26057 | 5617 | 100 |
1006092 | 1006092 | 2021-02-07 | Gratiot | Michigan | 26057 | 5613 | 100 |
1002846 | 1002846 | 2021-02-06 | Gratiot | Michigan | 26057 | 5613 | 100 |
999601 | 999601 | 2021-02-05 | Gratiot | Michigan | 26057 | 5613 | 100 |
996355 | 996355 | 2021-02-04 | Gratiot | Michigan | 26057 | 5609 | 100 |
993109 | 993109 | 2021-02-03 | Gratiot | Michigan | 26057 | 5603 | 99 |
989863 | 989863 | 2021-02-02 | Gratiot | Michigan | 26057 | 5599 | 99 |
986616 | 986616 | 2021-02-01 | Gratiot | Michigan | 26057 | 5593 | 98 |
983369 | 983369 | 2021-01-31 | Gratiot | Michigan | 26057 | 5574 | 98 |
980123 | 980123 | 2021-01-30 | Gratiot | Michigan | 26057 | 5574 | 98 |
976877 | 976877 | 2021-01-29 | Gratiot | Michigan | 26057 | 5569 | 98 |
973632 | 973632 | 2021-01-28 | Gratiot | Michigan | 26057 | 5564 | 98 |
970387 | 970387 | 2021-01-27 | Gratiot | Michigan | 26057 | 5557 | 98 |
967142 | 967142 | 2021-01-26 | Gratiot | Michigan | 26057 | 5577 | 98 |
963898 | 963898 | 2021-01-25 | Gratiot | Michigan | 26057 | 5541 | 98 |
960653 | 960653 | 2021-01-24 | Gratiot | Michigan | 26057 | 5530 | 98 |
957407 | 957407 | 2021-01-23 | Gratiot | Michigan | 26057 | 5530 | 98 |
954162 | 954162 | 2021-01-22 | Gratiot | Michigan | 26057 | 5527 | 95 |
950917 | 950917 | 2021-01-21 | Gratiot | Michigan | 26057 | 5511 | 95 |
947671 | 947671 | 2021-01-20 | Gratiot | Michigan | 26057 | 5495 | 95 |
944424 | 944424 | 2021-01-19 | Gratiot | Michigan | 26057 | 5497 | 95 |
941179 | 941179 | 2021-01-18 | Gratiot | Michigan | 26057 | 5483 | 94 |
937934 | 937934 | 2021-01-17 | Gratiot | Michigan | 26057 | 5462 | 94 |
934689 | 934689 | 2021-01-16 | Gratiot | Michigan | 26057 | 5462 | 94 |
931444 | 931444 | 2021-01-15 | Gratiot | Michigan | 26057 | 5459 | 92 |
928199 | 928199 | 2021-01-14 | Gratiot | Michigan | 26057 | 5451 | 92 |
924953 | 924953 | 2021-01-13 | Gratiot | Michigan | 26057 | 4275 | 88 |
921708 | 921708 | 2021-01-12 | Gratiot | Michigan | 26057 | 4263 | 88 |
918463 | 918463 | 2021-01-11 | Gratiot | Michigan | 26057 | 4251 | 87 |
915218 | 915218 | 2021-01-10 | Gratiot | Michigan | 26057 | 4233 | 84 |
911973 | 911973 | 2021-01-09 | Gratiot | Michigan | 26057 | 4233 | 84 |
908728 | 908728 | 2021-01-08 | Gratiot | Michigan | 26057 | 4211 | 84 |
905482 | 905482 | 2021-01-07 | Gratiot | Michigan | 26057 | 4198 | 84 |
902237 | 902237 | 2021-01-06 | Gratiot | Michigan | 26057 | 4176 | 82 |
898992 | 898992 | 2021-01-05 | Gratiot | Michigan | 26057 | 4162 | 82 |
895747 | 895747 | 2021-01-04 | Gratiot | Michigan | 26057 | 4143 | 81 |
892500 | 892500 | 2021-01-03 | Gratiot | Michigan | 26057 | 4120 | 81 |
889254 | 889254 | 2021-01-02 | Gratiot | Michigan | 26057 | 4120 | 81 |
886008 | 886008 | 2021-01-01 | Gratiot | Michigan | 26057 | 4148 | 71 |
882763 | 882763 | 2020-12-31 | Gratiot | Michigan | 26057 | 4148 | 71 |
879518 | 879518 | 2020-12-30 | Gratiot | Michigan | 26057 | 4148 | 71 |
876273 | 876273 | 2020-12-29 | Gratiot | Michigan | 26057 | 4087 | 69 |
873028 | 873028 | 2020-12-28 | Gratiot | Michigan | 26057 | 4073 | 66 |
869783 | 869783 | 2020-12-27 | Gratiot | Michigan | 26057 | 4070 | 66 |
866538 | 866538 | 2020-12-26 | Gratiot | Michigan | 26057 | 4070 | 66 |
863293 | 863293 | 2020-12-25 | Gratiot | Michigan | 26057 | 4050 | 62 |
860048 | 860048 | 2020-12-24 | Gratiot | Michigan | 26057 | 4050 | 62 |
856803 | 856803 | 2020-12-23 | Gratiot | Michigan | 26057 | 4050 | 62 |
853558 | 853558 | 2020-12-22 | Gratiot | Michigan | 26057 | 4036 | 62 |
850313 | 850313 | 2020-12-21 | Gratiot | Michigan | 26057 | 4028 | 60 |
847068 | 847068 | 2020-12-20 | Gratiot | Michigan | 26057 | 3981 | 60 |
843822 | 843822 | 2020-12-19 | Gratiot | Michigan | 26057 | 3981 | 60 |
840577 | 840577 | 2020-12-18 | Gratiot | Michigan | 26057 | 3952 | 57 |
837332 | 837332 | 2020-12-17 | Gratiot | Michigan | 26057 | 3914 | 55 |
834086 | 834086 | 2020-12-16 | Gratiot | Michigan | 26057 | 3893 | 54 |
830839 | 830839 | 2020-12-15 | Gratiot | Michigan | 26057 | 3853 | 52 |
827593 | 827593 | 2020-12-14 | Gratiot | Michigan | 26057 | 3824 | 50 |
824346 | 824346 | 2020-12-13 | Gratiot | Michigan | 26057 | 3763 | 50 |
821100 | 821100 | 2020-12-12 | Gratiot | Michigan | 26057 | 3763 | 50 |
817854 | 817854 | 2020-12-11 | Gratiot | Michigan | 26057 | 3758 | 47 |
814608 | 814608 | 2020-12-10 | Gratiot | Michigan | 26057 | 3702 | 46 |
811363 | 811363 | 2020-12-09 | Gratiot | Michigan | 26057 | 3658 | 44 |
808118 | 808118 | 2020-12-08 | Gratiot | Michigan | 26057 | 3630 | 44 |
804873 | 804873 | 2020-12-07 | Gratiot | Michigan | 26057 | 3598 | 44 |
801628 | 801628 | 2020-12-06 | Gratiot | Michigan | 26057 | 3545 | 42 |
798383 | 798383 | 2020-12-05 | Gratiot | Michigan | 26057 | 3545 | 42 |
795138 | 795138 | 2020-12-04 | Gratiot | Michigan | 26057 | 3526 | 39 |
791893 | 791893 | 2020-12-03 | Gratiot | Michigan | 26057 | 2116 | 36 |
788648 | 788648 | 2020-12-02 | Gratiot | Michigan | 26057 | 1782 | 31 |
785403 | 785403 | 2020-12-01 | Gratiot | Michigan | 26057 | 1681 | 31 |
782159 | 782159 | 2020-11-30 | Gratiot | Michigan | 26057 | 1643 | 31 |
778913 | 778913 | 2020-11-29 | Gratiot | Michigan | 26057 | 1574 | 29 |
775668 | 775668 | 2020-11-28 | Gratiot | Michigan | 26057 | 1574 | 29 |
772423 | 772423 | 2020-11-27 | Gratiot | Michigan | 26057 | 1595 | 29 |
769178 | 769178 | 2020-11-26 | Gratiot | Michigan | 26057 | 1463 | 29 |
765932 | 765932 | 2020-11-25 | Gratiot | Michigan | 26057 | 1463 | 29 |
762687 | 762687 | 2020-11-24 | Gratiot | Michigan | 26057 | 1428 | 29 |
759442 | 759442 | 2020-11-23 | Gratiot | Michigan | 26057 | 1377 | 28 |
756195 | 756195 | 2020-11-22 | Gratiot | Michigan | 26057 | 1351 | 27 |
752949 | 752949 | 2020-11-21 | Gratiot | Michigan | 26057 | 1351 | 27 |
749703 | 749703 | 2020-11-20 | Gratiot | Michigan | 26057 | 1602 | 25 |
746457 | 746457 | 2020-11-19 | Gratiot | Michigan | 26057 | 1248 | 24 |
743210 | 743210 | 2020-11-18 | Gratiot | Michigan | 26057 | 1203 | 23 |
739963 | 739963 | 2020-11-17 | Gratiot | Michigan | 26057 | 1182 | 21 |
736719 | 736719 | 2020-11-16 | Gratiot | Michigan | 26057 | 1135 | 21 |
733473 | 733473 | 2020-11-15 | Gratiot | Michigan | 26057 | 1065 | 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);