ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26025 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054761 | 1054761 | 2021-02-22 | Calhoun | Michigan | 26025 | 9451 | 232 |
1051514 | 1051514 | 2021-02-21 | Calhoun | Michigan | 26025 | 9423 | 232 |
1048267 | 1048267 | 2021-02-20 | Calhoun | Michigan | 26025 | 9423 | 232 |
1045021 | 1045021 | 2021-02-19 | Calhoun | Michigan | 26025 | 9404 | 232 |
1041776 | 1041776 | 2021-02-18 | Calhoun | Michigan | 26025 | 9376 | 232 |
1038531 | 1038531 | 2021-02-17 | Calhoun | Michigan | 26025 | 9348 | 231 |
1035286 | 1035286 | 2021-02-16 | Calhoun | Michigan | 26025 | 9326 | 229 |
1032041 | 1032041 | 2021-02-15 | Calhoun | Michigan | 26025 | 9300 | 228 |
1028794 | 1028794 | 2021-02-14 | Calhoun | Michigan | 26025 | 9286 | 227 |
1025548 | 1025548 | 2021-02-13 | Calhoun | Michigan | 26025 | 9286 | 227 |
1022303 | 1022303 | 2021-02-12 | Calhoun | Michigan | 26025 | 9275 | 227 |
1019058 | 1019058 | 2021-02-11 | Calhoun | Michigan | 26025 | 9246 | 227 |
1015813 | 1015813 | 2021-02-10 | Calhoun | Michigan | 26025 | 9201 | 225 |
1012568 | 1012568 | 2021-02-09 | Calhoun | Michigan | 26025 | 9172 | 225 |
1009323 | 1009323 | 2021-02-08 | Calhoun | Michigan | 26025 | 9141 | 225 |
1006076 | 1006076 | 2021-02-07 | Calhoun | Michigan | 26025 | 9114 | 225 |
1002830 | 1002830 | 2021-02-06 | Calhoun | Michigan | 26025 | 9114 | 225 |
999585 | 999585 | 2021-02-05 | Calhoun | Michigan | 26025 | 9092 | 222 |
996339 | 996339 | 2021-02-04 | Calhoun | Michigan | 26025 | 9060 | 222 |
993093 | 993093 | 2021-02-03 | Calhoun | Michigan | 26025 | 9021 | 221 |
989847 | 989847 | 2021-02-02 | Calhoun | Michigan | 26025 | 8990 | 220 |
986600 | 986600 | 2021-02-01 | Calhoun | Michigan | 26025 | 8967 | 218 |
983353 | 983353 | 2021-01-31 | Calhoun | Michigan | 26025 | 8913 | 217 |
980107 | 980107 | 2021-01-30 | Calhoun | Michigan | 26025 | 8913 | 217 |
976861 | 976861 | 2021-01-29 | Calhoun | Michigan | 26025 | 8894 | 217 |
973616 | 973616 | 2021-01-28 | Calhoun | Michigan | 26025 | 8857 | 216 |
970371 | 970371 | 2021-01-27 | Calhoun | Michigan | 26025 | 8822 | 214 |
967126 | 967126 | 2021-01-26 | Calhoun | Michigan | 26025 | 8763 | 215 |
963882 | 963882 | 2021-01-25 | Calhoun | Michigan | 26025 | 8720 | 213 |
960637 | 960637 | 2021-01-24 | Calhoun | Michigan | 26025 | 8669 | 213 |
957391 | 957391 | 2021-01-23 | Calhoun | Michigan | 26025 | 8669 | 213 |
954146 | 954146 | 2021-01-22 | Calhoun | Michigan | 26025 | 8657 | 209 |
950901 | 950901 | 2021-01-21 | Calhoun | Michigan | 26025 | 8609 | 208 |
947655 | 947655 | 2021-01-20 | Calhoun | Michigan | 26025 | 8579 | 207 |
944408 | 944408 | 2021-01-19 | Calhoun | Michigan | 26025 | 8532 | 206 |
941163 | 941163 | 2021-01-18 | Calhoun | Michigan | 26025 | 8501 | 205 |
937918 | 937918 | 2021-01-17 | Calhoun | Michigan | 26025 | 8464 | 207 |
934673 | 934673 | 2021-01-16 | Calhoun | Michigan | 26025 | 8464 | 207 |
931428 | 931428 | 2021-01-15 | Calhoun | Michigan | 26025 | 8435 | 207 |
928183 | 928183 | 2021-01-14 | Calhoun | Michigan | 26025 | 8378 | 207 |
924937 | 924937 | 2021-01-13 | Calhoun | Michigan | 26025 | 8327 | 204 |
921692 | 921692 | 2021-01-12 | Calhoun | Michigan | 26025 | 8273 | 203 |
918447 | 918447 | 2021-01-11 | Calhoun | Michigan | 26025 | 8230 | 206 |
915202 | 915202 | 2021-01-10 | Calhoun | Michigan | 26025 | 8159 | 206 |
911957 | 911957 | 2021-01-09 | Calhoun | Michigan | 26025 | 8159 | 206 |
908712 | 908712 | 2021-01-08 | Calhoun | Michigan | 26025 | 8117 | 204 |
905466 | 905466 | 2021-01-07 | Calhoun | Michigan | 26025 | 8061 | 203 |
902221 | 902221 | 2021-01-06 | Calhoun | Michigan | 26025 | 8016 | 202 |
898976 | 898976 | 2021-01-05 | Calhoun | Michigan | 26025 | 7962 | 198 |
895731 | 895731 | 2021-01-04 | Calhoun | Michigan | 26025 | 7920 | 195 |
892484 | 892484 | 2021-01-03 | Calhoun | Michigan | 26025 | 7873 | 194 |
889238 | 889238 | 2021-01-02 | Calhoun | Michigan | 26025 | 7873 | 194 |
885992 | 885992 | 2021-01-01 | Calhoun | Michigan | 26025 | 7802 | 189 |
882747 | 882747 | 2020-12-31 | Calhoun | Michigan | 26025 | 7802 | 189 |
879502 | 879502 | 2020-12-30 | Calhoun | Michigan | 26025 | 7802 | 189 |
876257 | 876257 | 2020-12-29 | Calhoun | Michigan | 26025 | 7750 | 189 |
873012 | 873012 | 2020-12-28 | Calhoun | Michigan | 26025 | 7736 | 184 |
869767 | 869767 | 2020-12-27 | Calhoun | Michigan | 26025 | 7703 | 181 |
866522 | 866522 | 2020-12-26 | Calhoun | Michigan | 26025 | 7703 | 181 |
863277 | 863277 | 2020-12-25 | Calhoun | Michigan | 26025 | 7601 | 176 |
860032 | 860032 | 2020-12-24 | Calhoun | Michigan | 26025 | 7601 | 176 |
856787 | 856787 | 2020-12-23 | Calhoun | Michigan | 26025 | 7601 | 176 |
853542 | 853542 | 2020-12-22 | Calhoun | Michigan | 26025 | 7551 | 174 |
850297 | 850297 | 2020-12-21 | Calhoun | Michigan | 26025 | 7559 | 170 |
847052 | 847052 | 2020-12-20 | Calhoun | Michigan | 26025 | 7495 | 169 |
843806 | 843806 | 2020-12-19 | Calhoun | Michigan | 26025 | 7495 | 169 |
840561 | 840561 | 2020-12-18 | Calhoun | Michigan | 26025 | 7375 | 165 |
837316 | 837316 | 2020-12-17 | Calhoun | Michigan | 26025 | 7319 | 163 |
834070 | 834070 | 2020-12-16 | Calhoun | Michigan | 26025 | 7263 | 159 |
830823 | 830823 | 2020-12-15 | Calhoun | Michigan | 26025 | 7183 | 159 |
827577 | 827577 | 2020-12-14 | Calhoun | Michigan | 26025 | 7104 | 152 |
824330 | 824330 | 2020-12-13 | Calhoun | Michigan | 26025 | 7035 | 148 |
821084 | 821084 | 2020-12-12 | Calhoun | Michigan | 26025 | 7035 | 148 |
817838 | 817838 | 2020-12-11 | Calhoun | Michigan | 26025 | 6987 | 146 |
814592 | 814592 | 2020-12-10 | Calhoun | Michigan | 26025 | 6912 | 145 |
811347 | 811347 | 2020-12-09 | Calhoun | Michigan | 26025 | 6833 | 141 |
808102 | 808102 | 2020-12-08 | Calhoun | Michigan | 26025 | 6731 | 138 |
804857 | 804857 | 2020-12-07 | Calhoun | Michigan | 26025 | 6671 | 135 |
801612 | 801612 | 2020-12-06 | Calhoun | Michigan | 26025 | 6542 | 130 |
798367 | 798367 | 2020-12-05 | Calhoun | Michigan | 26025 | 6542 | 130 |
795122 | 795122 | 2020-12-04 | Calhoun | Michigan | 26025 | 6436 | 129 |
791877 | 791877 | 2020-12-03 | Calhoun | Michigan | 26025 | 6339 | 130 |
788632 | 788632 | 2020-12-02 | Calhoun | Michigan | 26025 | 6202 | 127 |
785387 | 785387 | 2020-12-01 | Calhoun | Michigan | 26025 | 6105 | 123 |
782143 | 782143 | 2020-11-30 | Calhoun | Michigan | 26025 | 6035 | 121 |
778897 | 778897 | 2020-11-29 | Calhoun | Michigan | 26025 | 5914 | 120 |
775652 | 775652 | 2020-11-28 | Calhoun | Michigan | 26025 | 5914 | 120 |
772407 | 772407 | 2020-11-27 | Calhoun | Michigan | 26025 | 5828 | 120 |
769162 | 769162 | 2020-11-26 | Calhoun | Michigan | 26025 | 5586 | 114 |
765916 | 765916 | 2020-11-25 | Calhoun | Michigan | 26025 | 5586 | 114 |
762671 | 762671 | 2020-11-24 | Calhoun | Michigan | 26025 | 5538 | 113 |
759426 | 759426 | 2020-11-23 | Calhoun | Michigan | 26025 | 5476 | 111 |
756179 | 756179 | 2020-11-22 | Calhoun | Michigan | 26025 | 5309 | 111 |
752933 | 752933 | 2020-11-21 | Calhoun | Michigan | 26025 | 5309 | 111 |
749687 | 749687 | 2020-11-20 | Calhoun | Michigan | 26025 | 5263 | 110 |
746441 | 746441 | 2020-11-19 | Calhoun | Michigan | 26025 | 5188 | 109 |
743194 | 743194 | 2020-11-18 | Calhoun | Michigan | 26025 | 5060 | 105 |
739947 | 739947 | 2020-11-17 | Calhoun | Michigan | 26025 | 4974 | 105 |
736703 | 736703 | 2020-11-16 | Calhoun | Michigan | 26025 | 4867 | 103 |
733457 | 733457 | 2020-11-15 | Calhoun | Michigan | 26025 | 4742 | 99 |
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);