ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Washtenaw" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194432 | 1194432 | 2021-04-06 | Washtenaw | Michigan | 26161 | 22415 | 262 |
1191183 | 1191183 | 2021-04-05 | Washtenaw | Michigan | 26161 | 22264 | 262 |
1187935 | 1187935 | 2021-04-04 | Washtenaw | Michigan | 26161 | 21959 | 260 |
1184688 | 1184688 | 2021-04-03 | Washtenaw | Michigan | 26161 | 21959 | 260 |
1181442 | 1181442 | 2021-04-02 | Washtenaw | Michigan | 26161 | 21890 | 260 |
1178195 | 1178195 | 2021-04-01 | Washtenaw | Michigan | 26161 | 21755 | 260 |
1174948 | 1174948 | 2021-03-31 | Washtenaw | Michigan | 26161 | 21491 | 259 |
1171701 | 1171701 | 2021-03-30 | Washtenaw | Michigan | 26161 | 21378 | 259 |
1168453 | 1168453 | 2021-03-29 | Washtenaw | Michigan | 26161 | 21253 | 259 |
1165205 | 1165205 | 2021-03-28 | Washtenaw | Michigan | 26161 | 20950 | 257 |
1161957 | 1161957 | 2021-03-27 | Washtenaw | Michigan | 26161 | 20950 | 257 |
1158709 | 1158709 | 2021-03-26 | Washtenaw | Michigan | 26161 | 20909 | 257 |
1155462 | 1155462 | 2021-03-25 | Washtenaw | Michigan | 26161 | 20778 | 257 |
1152215 | 1152215 | 2021-03-24 | Washtenaw | Michigan | 26161 | 20531 | 257 |
1148968 | 1148968 | 2021-03-23 | Washtenaw | Michigan | 26161 | 20471 | 256 |
1145721 | 1145721 | 2021-03-22 | Washtenaw | Michigan | 26161 | 20375 | 256 |
1142474 | 1142474 | 2021-03-21 | Washtenaw | Michigan | 26161 | 20227 | 255 |
1139227 | 1139227 | 2021-03-20 | Washtenaw | Michigan | 26161 | 20227 | 255 |
1135981 | 1135981 | 2021-03-19 | Washtenaw | Michigan | 26161 | 20226 | 255 |
1132735 | 1132735 | 2021-03-18 | Washtenaw | Michigan | 26161 | 20156 | 254 |
1129487 | 1129487 | 2021-03-17 | Washtenaw | Michigan | 26161 | 20060 | 254 |
1126240 | 1126240 | 2021-03-16 | Washtenaw | Michigan | 26161 | 19948 | 254 |
1122994 | 1122994 | 2021-03-15 | Washtenaw | Michigan | 26161 | 19948 | 254 |
1119747 | 1119747 | 2021-03-14 | Washtenaw | Michigan | 26161 | 19850 | 253 |
1116500 | 1116500 | 2021-03-13 | Washtenaw | Michigan | 26161 | 19850 | 253 |
1113254 | 1113254 | 2021-03-12 | Washtenaw | Michigan | 26161 | 19850 | 253 |
1110008 | 1110008 | 2021-03-11 | Washtenaw | Michigan | 26161 | 19806 | 253 |
1106762 | 1106762 | 2021-03-10 | Washtenaw | Michigan | 26161 | 19728 | 253 |
1103516 | 1103516 | 2021-03-09 | Washtenaw | Michigan | 26161 | 19676 | 253 |
1100270 | 1100270 | 2021-03-08 | Washtenaw | Michigan | 26161 | 19651 | 253 |
1097023 | 1097023 | 2021-03-07 | Washtenaw | Michigan | 26161 | 19548 | 252 |
1093776 | 1093776 | 2021-03-06 | Washtenaw | Michigan | 26161 | 19548 | 252 |
1090530 | 1090530 | 2021-03-05 | Washtenaw | Michigan | 26161 | 19548 | 252 |
1087285 | 1087285 | 2021-03-04 | Washtenaw | Michigan | 26161 | 19510 | 252 |
1084040 | 1084040 | 2021-03-03 | Washtenaw | Michigan | 26161 | 19433 | 252 |
1080794 | 1080794 | 2021-03-02 | Washtenaw | Michigan | 26161 | 19386 | 251 |
1077548 | 1077548 | 2021-03-01 | Washtenaw | Michigan | 26161 | 19358 | 251 |
1074302 | 1074302 | 2021-02-28 | Washtenaw | Michigan | 26161 | 19252 | 251 |
1071056 | 1071056 | 2021-02-27 | Washtenaw | Michigan | 26161 | 19252 | 251 |
1067811 | 1067811 | 2021-02-26 | Washtenaw | Michigan | 26161 | 19246 | 251 |
1064566 | 1064566 | 2021-02-25 | Washtenaw | Michigan | 26161 | 19198 | 251 |
1061322 | 1061322 | 2021-02-24 | Washtenaw | Michigan | 26161 | 19088 | 251 |
1058076 | 1058076 | 2021-02-23 | Washtenaw | Michigan | 26161 | 19036 | 251 |
1054830 | 1054830 | 2021-02-22 | Washtenaw | Michigan | 26161 | 18978 | 251 |
1051583 | 1051583 | 2021-02-21 | Washtenaw | Michigan | 26161 | 18852 | 249 |
1048336 | 1048336 | 2021-02-20 | Washtenaw | Michigan | 26161 | 18852 | 249 |
1045090 | 1045090 | 2021-02-19 | Washtenaw | Michigan | 26161 | 18852 | 249 |
1041845 | 1041845 | 2021-02-18 | Washtenaw | Michigan | 26161 | 18759 | 249 |
1038600 | 1038600 | 2021-02-17 | Washtenaw | Michigan | 26161 | 18658 | 246 |
1035355 | 1035355 | 2021-02-16 | Washtenaw | Michigan | 26161 | 18519 | 245 |
1032110 | 1032110 | 2021-02-15 | Washtenaw | Michigan | 26161 | 18485 | 244 |
1028863 | 1028863 | 2021-02-14 | Washtenaw | Michigan | 26161 | 18415 | 244 |
1025617 | 1025617 | 2021-02-13 | Washtenaw | Michigan | 26161 | 18415 | 244 |
1022372 | 1022372 | 2021-02-12 | Washtenaw | Michigan | 26161 | 18404 | 242 |
1019127 | 1019127 | 2021-02-11 | Washtenaw | Michigan | 26161 | 18294 | 242 |
1015882 | 1015882 | 2021-02-10 | Washtenaw | Michigan | 26161 | 18164 | 241 |
1012637 | 1012637 | 2021-02-09 | Washtenaw | Michigan | 26161 | 18116 | 241 |
1009392 | 1009392 | 2021-02-08 | Washtenaw | Michigan | 26161 | 18157 | 240 |
1006145 | 1006145 | 2021-02-07 | Washtenaw | Michigan | 26161 | 17890 | 237 |
1002899 | 1002899 | 2021-02-06 | Washtenaw | Michigan | 26161 | 17890 | 237 |
999654 | 999654 | 2021-02-05 | Washtenaw | Michigan | 26161 | 17890 | 237 |
996408 | 996408 | 2021-02-04 | Washtenaw | Michigan | 26161 | 17789 | 237 |
993162 | 993162 | 2021-02-03 | Washtenaw | Michigan | 26161 | 17561 | 236 |
989916 | 989916 | 2021-02-02 | Washtenaw | Michigan | 26161 | 17492 | 236 |
986669 | 986669 | 2021-02-01 | Washtenaw | Michigan | 26161 | 17395 | 236 |
983422 | 983422 | 2021-01-31 | Washtenaw | Michigan | 26161 | 17165 | 234 |
980176 | 980176 | 2021-01-30 | Washtenaw | Michigan | 26161 | 17165 | 234 |
976930 | 976930 | 2021-01-29 | Washtenaw | Michigan | 26161 | 17162 | 234 |
973685 | 973685 | 2021-01-28 | Washtenaw | Michigan | 26161 | 17015 | 234 |
970440 | 970440 | 2021-01-27 | Washtenaw | Michigan | 26161 | 16814 | 231 |
967195 | 967195 | 2021-01-26 | Washtenaw | Michigan | 26161 | 16722 | 231 |
963951 | 963951 | 2021-01-25 | Washtenaw | Michigan | 26161 | 16588 | 231 |
960706 | 960706 | 2021-01-24 | Washtenaw | Michigan | 26161 | 16402 | 231 |
957460 | 957460 | 2021-01-23 | Washtenaw | Michigan | 26161 | 16402 | 231 |
954215 | 954215 | 2021-01-22 | Washtenaw | Michigan | 26161 | 16402 | 228 |
950970 | 950970 | 2021-01-21 | Washtenaw | Michigan | 26161 | 16341 | 228 |
947724 | 947724 | 2021-01-20 | Washtenaw | Michigan | 26161 | 16208 | 226 |
944477 | 944477 | 2021-01-19 | Washtenaw | Michigan | 26161 | 16145 | 225 |
941232 | 941232 | 2021-01-18 | Washtenaw | Michigan | 26161 | 15957 | 225 |
937987 | 937987 | 2021-01-17 | Washtenaw | Michigan | 26161 | 15880 | 225 |
934742 | 934742 | 2021-01-16 | Washtenaw | Michigan | 26161 | 15880 | 225 |
931497 | 931497 | 2021-01-15 | Washtenaw | Michigan | 26161 | 15880 | 224 |
928252 | 928252 | 2021-01-14 | Washtenaw | Michigan | 26161 | 15801 | 224 |
925006 | 925006 | 2021-01-13 | Washtenaw | Michigan | 26161 | 15607 | 222 |
921761 | 921761 | 2021-01-12 | Washtenaw | Michigan | 26161 | 15564 | 222 |
918516 | 918516 | 2021-01-11 | Washtenaw | Michigan | 26161 | 15466 | 220 |
915271 | 915271 | 2021-01-10 | Washtenaw | Michigan | 26161 | 15220 | 220 |
912026 | 912026 | 2021-01-09 | Washtenaw | Michigan | 26161 | 15220 | 220 |
908781 | 908781 | 2021-01-08 | Washtenaw | Michigan | 26161 | 15220 | 215 |
905535 | 905535 | 2021-01-07 | Washtenaw | Michigan | 26161 | 15078 | 215 |
902290 | 902290 | 2021-01-06 | Washtenaw | Michigan | 26161 | 14875 | 212 |
899045 | 899045 | 2021-01-05 | Washtenaw | Michigan | 26161 | 14765 | 211 |
895800 | 895800 | 2021-01-04 | Washtenaw | Michigan | 26161 | 14667 | 207 |
892553 | 892553 | 2021-01-03 | Washtenaw | Michigan | 26161 | 14372 | 205 |
889307 | 889307 | 2021-01-02 | Washtenaw | Michigan | 26161 | 14372 | 205 |
886061 | 886061 | 2021-01-01 | Washtenaw | Michigan | 26161 | 14234 | 200 |
882816 | 882816 | 2020-12-31 | Washtenaw | Michigan | 26161 | 14234 | 200 |
879571 | 879571 | 2020-12-30 | Washtenaw | Michigan | 26161 | 14234 | 200 |
876326 | 876326 | 2020-12-29 | Washtenaw | Michigan | 26161 | 14064 | 199 |
873081 | 873081 | 2020-12-28 | Washtenaw | Michigan | 26161 | 13975 | 194 |
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);