ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 26111 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194406 | 1194406 | 2021-04-06 | Midland | Michigan | 26111 | 5864 | 71 |
1191157 | 1191157 | 2021-04-05 | Midland | Michigan | 26111 | 5811 | 70 |
1187909 | 1187909 | 2021-04-04 | Midland | Michigan | 26111 | 5738 | 70 |
1184662 | 1184662 | 2021-04-03 | Midland | Michigan | 26111 | 5738 | 70 |
1181416 | 1181416 | 2021-04-02 | Midland | Michigan | 26111 | 5677 | 69 |
1178169 | 1178169 | 2021-04-01 | Midland | Michigan | 26111 | 5644 | 69 |
1174922 | 1174922 | 2021-03-31 | Midland | Michigan | 26111 | 5582 | 69 |
1171675 | 1171675 | 2021-03-30 | Midland | Michigan | 26111 | 5560 | 69 |
1168427 | 1168427 | 2021-03-29 | Midland | Michigan | 26111 | 5530 | 68 |
1165179 | 1165179 | 2021-03-28 | Midland | Michigan | 26111 | 5490 | 68 |
1161931 | 1161931 | 2021-03-27 | Midland | Michigan | 26111 | 5490 | 68 |
1158683 | 1158683 | 2021-03-26 | Midland | Michigan | 26111 | 5471 | 67 |
1155436 | 1155436 | 2021-03-25 | Midland | Michigan | 26111 | 5439 | 66 |
1152189 | 1152189 | 2021-03-24 | Midland | Michigan | 26111 | 5394 | 66 |
1148942 | 1148942 | 2021-03-23 | Midland | Michigan | 26111 | 5377 | 66 |
1145695 | 1145695 | 2021-03-22 | Midland | Michigan | 26111 | 5352 | 66 |
1142448 | 1142448 | 2021-03-21 | Midland | Michigan | 26111 | 5295 | 66 |
1139201 | 1139201 | 2021-03-20 | Midland | Michigan | 26111 | 5295 | 66 |
1135955 | 1135955 | 2021-03-19 | Midland | Michigan | 26111 | 5286 | 66 |
1132709 | 1132709 | 2021-03-18 | Midland | Michigan | 26111 | 5259 | 66 |
1129461 | 1129461 | 2021-03-17 | Midland | Michigan | 26111 | 5248 | 66 |
1126214 | 1126214 | 2021-03-16 | Midland | Michigan | 26111 | 5232 | 66 |
1122968 | 1122968 | 2021-03-15 | Midland | Michigan | 26111 | 5221 | 66 |
1119721 | 1119721 | 2021-03-14 | Midland | Michigan | 26111 | 5204 | 66 |
1116474 | 1116474 | 2021-03-13 | Midland | Michigan | 26111 | 5204 | 66 |
1113228 | 1113228 | 2021-03-12 | Midland | Michigan | 26111 | 5184 | 66 |
1109982 | 1109982 | 2021-03-11 | Midland | Michigan | 26111 | 5164 | 66 |
1106736 | 1106736 | 2021-03-10 | Midland | Michigan | 26111 | 5139 | 66 |
1103490 | 1103490 | 2021-03-09 | Midland | Michigan | 26111 | 5128 | 66 |
1100244 | 1100244 | 2021-03-08 | Midland | Michigan | 26111 | 5114 | 66 |
1096997 | 1096997 | 2021-03-07 | Midland | Michigan | 26111 | 5088 | 66 |
1093750 | 1093750 | 2021-03-06 | Midland | Michigan | 26111 | 5088 | 66 |
1090504 | 1090504 | 2021-03-05 | Midland | Michigan | 26111 | 5064 | 65 |
1087259 | 1087259 | 2021-03-04 | Midland | Michigan | 26111 | 5050 | 65 |
1084014 | 1084014 | 2021-03-03 | Midland | Michigan | 26111 | 5030 | 65 |
1080768 | 1080768 | 2021-03-02 | Midland | Michigan | 26111 | 5020 | 65 |
1077522 | 1077522 | 2021-03-01 | Midland | Michigan | 26111 | 5008 | 65 |
1074276 | 1074276 | 2021-02-28 | Midland | Michigan | 26111 | 4991 | 65 |
1071030 | 1071030 | 2021-02-27 | Midland | Michigan | 26111 | 4991 | 65 |
1067785 | 1067785 | 2021-02-26 | Midland | Michigan | 26111 | 4969 | 64 |
1064540 | 1064540 | 2021-02-25 | Midland | Michigan | 26111 | 4956 | 64 |
1061296 | 1061296 | 2021-02-24 | Midland | Michigan | 26111 | 4933 | 64 |
1058050 | 1058050 | 2021-02-23 | Midland | Michigan | 26111 | 4926 | 64 |
1054804 | 1054804 | 2021-02-22 | Midland | Michigan | 26111 | 4910 | 64 |
1051557 | 1051557 | 2021-02-21 | Midland | Michigan | 26111 | 4905 | 64 |
1048310 | 1048310 | 2021-02-20 | Midland | Michigan | 26111 | 4905 | 64 |
1045064 | 1045064 | 2021-02-19 | Midland | Michigan | 26111 | 4903 | 64 |
1041819 | 1041819 | 2021-02-18 | Midland | Michigan | 26111 | 4891 | 64 |
1038574 | 1038574 | 2021-02-17 | Midland | Michigan | 26111 | 4889 | 64 |
1035329 | 1035329 | 2021-02-16 | Midland | Michigan | 26111 | 4886 | 64 |
1032084 | 1032084 | 2021-02-15 | Midland | Michigan | 26111 | 4881 | 64 |
1028837 | 1028837 | 2021-02-14 | Midland | Michigan | 26111 | 4881 | 64 |
1025591 | 1025591 | 2021-02-13 | Midland | Michigan | 26111 | 4881 | 64 |
1022346 | 1022346 | 2021-02-12 | Midland | Michigan | 26111 | 4882 | 63 |
1019101 | 1019101 | 2021-02-11 | Midland | Michigan | 26111 | 4872 | 62 |
1015856 | 1015856 | 2021-02-10 | Midland | Michigan | 26111 | 4865 | 62 |
1012611 | 1012611 | 2021-02-09 | Midland | Michigan | 26111 | 4858 | 61 |
1009366 | 1009366 | 2021-02-08 | Midland | Michigan | 26111 | 4849 | 61 |
1006119 | 1006119 | 2021-02-07 | Midland | Michigan | 26111 | 4822 | 61 |
1002873 | 1002873 | 2021-02-06 | Midland | Michigan | 26111 | 4822 | 61 |
999628 | 999628 | 2021-02-05 | Midland | Michigan | 26111 | 4819 | 59 |
996382 | 996382 | 2021-02-04 | Midland | Michigan | 26111 | 4816 | 57 |
993136 | 993136 | 2021-02-03 | Midland | Michigan | 26111 | 4802 | 57 |
989890 | 989890 | 2021-02-02 | Midland | Michigan | 26111 | 4783 | 57 |
986643 | 986643 | 2021-02-01 | Midland | Michigan | 26111 | 4771 | 56 |
983396 | 983396 | 2021-01-31 | Midland | Michigan | 26111 | 4721 | 56 |
980150 | 980150 | 2021-01-30 | Midland | Michigan | 26111 | 4721 | 56 |
976904 | 976904 | 2021-01-29 | Midland | Michigan | 26111 | 4720 | 56 |
973659 | 973659 | 2021-01-28 | Midland | Michigan | 26111 | 4697 | 56 |
970414 | 970414 | 2021-01-27 | Midland | Michigan | 26111 | 4687 | 55 |
967169 | 967169 | 2021-01-26 | Midland | Michigan | 26111 | 4672 | 55 |
963925 | 963925 | 2021-01-25 | Midland | Michigan | 26111 | 4647 | 55 |
960680 | 960680 | 2021-01-24 | Midland | Michigan | 26111 | 4608 | 55 |
957434 | 957434 | 2021-01-23 | Midland | Michigan | 26111 | 4608 | 55 |
954189 | 954189 | 2021-01-22 | Midland | Michigan | 26111 | 4593 | 53 |
950944 | 950944 | 2021-01-21 | Midland | Michigan | 26111 | 4569 | 53 |
947698 | 947698 | 2021-01-20 | Midland | Michigan | 26111 | 4562 | 53 |
944451 | 944451 | 2021-01-19 | Midland | Michigan | 26111 | 4554 | 52 |
941206 | 941206 | 2021-01-18 | Midland | Michigan | 26111 | 4524 | 52 |
937961 | 937961 | 2021-01-17 | Midland | Michigan | 26111 | 4497 | 53 |
934716 | 934716 | 2021-01-16 | Midland | Michigan | 26111 | 4497 | 53 |
931471 | 931471 | 2021-01-15 | Midland | Michigan | 26111 | 4474 | 53 |
928226 | 928226 | 2021-01-14 | Midland | Michigan | 26111 | 4456 | 53 |
924980 | 924980 | 2021-01-13 | Midland | Michigan | 26111 | 4420 | 51 |
921735 | 921735 | 2021-01-12 | Midland | Michigan | 26111 | 4383 | 51 |
918490 | 918490 | 2021-01-11 | Midland | Michigan | 26111 | 4351 | 49 |
915245 | 915245 | 2021-01-10 | Midland | Michigan | 26111 | 4322 | 49 |
912000 | 912000 | 2021-01-09 | Midland | Michigan | 26111 | 4322 | 49 |
908755 | 908755 | 2021-01-08 | Midland | Michigan | 26111 | 4303 | 49 |
905509 | 905509 | 2021-01-07 | Midland | Michigan | 26111 | 4272 | 49 |
902264 | 902264 | 2021-01-06 | Midland | Michigan | 26111 | 4235 | 49 |
899019 | 899019 | 2021-01-05 | Midland | Michigan | 26111 | 4191 | 51 |
895774 | 895774 | 2021-01-04 | Midland | Michigan | 26111 | 4156 | 47 |
892527 | 892527 | 2021-01-03 | Midland | Michigan | 26111 | 4099 | 46 |
889281 | 889281 | 2021-01-02 | Midland | Michigan | 26111 | 4099 | 46 |
886035 | 886035 | 2021-01-01 | Midland | Michigan | 26111 | 4011 | 44 |
882790 | 882790 | 2020-12-31 | Midland | Michigan | 26111 | 4011 | 44 |
879545 | 879545 | 2020-12-30 | Midland | Michigan | 26111 | 4011 | 44 |
876300 | 876300 | 2020-12-29 | Midland | Michigan | 26111 | 3978 | 44 |
873055 | 873055 | 2020-12-28 | Midland | Michigan | 26111 | 3903 | 45 |
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);