ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where deaths = 11, fips = 26085 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1168414 | 1168414 | 2021-03-29 | Lake | Michigan | 26085 | 424 | 11 |
1165166 | 1165166 | 2021-03-28 | Lake | Michigan | 26085 | 414 | 11 |
1161918 | 1161918 | 2021-03-27 | Lake | Michigan | 26085 | 414 | 11 |
1158670 | 1158670 | 2021-03-26 | Lake | Michigan | 26085 | 412 | 11 |
1155423 | 1155423 | 2021-03-25 | Lake | Michigan | 26085 | 407 | 11 |
1152176 | 1152176 | 2021-03-24 | Lake | Michigan | 26085 | 405 | 11 |
1148929 | 1148929 | 2021-03-23 | Lake | Michigan | 26085 | 400 | 11 |
1145682 | 1145682 | 2021-03-22 | Lake | Michigan | 26085 | 398 | 11 |
1142435 | 1142435 | 2021-03-21 | Lake | Michigan | 26085 | 394 | 11 |
1139188 | 1139188 | 2021-03-20 | Lake | Michigan | 26085 | 394 | 11 |
1135942 | 1135942 | 2021-03-19 | Lake | Michigan | 26085 | 392 | 11 |
1132696 | 1132696 | 2021-03-18 | Lake | Michigan | 26085 | 390 | 11 |
1129448 | 1129448 | 2021-03-17 | Lake | Michigan | 26085 | 386 | 11 |
1126201 | 1126201 | 2021-03-16 | Lake | Michigan | 26085 | 383 | 11 |
1122955 | 1122955 | 2021-03-15 | Lake | Michigan | 26085 | 380 | 11 |
1119708 | 1119708 | 2021-03-14 | Lake | Michigan | 26085 | 377 | 11 |
1116461 | 1116461 | 2021-03-13 | Lake | Michigan | 26085 | 377 | 11 |
1113215 | 1113215 | 2021-03-12 | Lake | Michigan | 26085 | 377 | 11 |
1109969 | 1109969 | 2021-03-11 | Lake | Michigan | 26085 | 375 | 11 |
1106723 | 1106723 | 2021-03-10 | Lake | Michigan | 26085 | 375 | 11 |
1103477 | 1103477 | 2021-03-09 | Lake | Michigan | 26085 | 373 | 11 |
1100231 | 1100231 | 2021-03-08 | Lake | Michigan | 26085 | 370 | 11 |
1096984 | 1096984 | 2021-03-07 | Lake | Michigan | 26085 | 368 | 11 |
1093737 | 1093737 | 2021-03-06 | Lake | Michigan | 26085 | 368 | 11 |
1090491 | 1090491 | 2021-03-05 | Lake | Michigan | 26085 | 367 | 11 |
1087246 | 1087246 | 2021-03-04 | Lake | Michigan | 26085 | 367 | 11 |
1084001 | 1084001 | 2021-03-03 | Lake | Michigan | 26085 | 364 | 11 |
1080755 | 1080755 | 2021-03-02 | Lake | Michigan | 26085 | 362 | 11 |
1077509 | 1077509 | 2021-03-01 | Lake | Michigan | 26085 | 362 | 11 |
1074263 | 1074263 | 2021-02-28 | Lake | Michigan | 26085 | 361 | 11 |
1071017 | 1071017 | 2021-02-27 | Lake | Michigan | 26085 | 361 | 11 |
1067772 | 1067772 | 2021-02-26 | Lake | Michigan | 26085 | 361 | 11 |
1064527 | 1064527 | 2021-02-25 | Lake | Michigan | 26085 | 360 | 11 |
1061283 | 1061283 | 2021-02-24 | Lake | Michigan | 26085 | 360 | 11 |
1058037 | 1058037 | 2021-02-23 | Lake | Michigan | 26085 | 360 | 11 |
1054791 | 1054791 | 2021-02-22 | Lake | Michigan | 26085 | 359 | 11 |
1051544 | 1051544 | 2021-02-21 | Lake | Michigan | 26085 | 356 | 11 |
1048297 | 1048297 | 2021-02-20 | Lake | Michigan | 26085 | 356 | 11 |
1045051 | 1045051 | 2021-02-19 | Lake | Michigan | 26085 | 356 | 11 |
1041806 | 1041806 | 2021-02-18 | Lake | Michigan | 26085 | 356 | 11 |
1038561 | 1038561 | 2021-02-17 | Lake | Michigan | 26085 | 356 | 11 |
1035316 | 1035316 | 2021-02-16 | Lake | Michigan | 26085 | 356 | 11 |
1032071 | 1032071 | 2021-02-15 | Lake | Michigan | 26085 | 356 | 11 |
1028824 | 1028824 | 2021-02-14 | Lake | Michigan | 26085 | 355 | 11 |
1025578 | 1025578 | 2021-02-13 | Lake | Michigan | 26085 | 355 | 11 |
1022333 | 1022333 | 2021-02-12 | Lake | Michigan | 26085 | 355 | 11 |
1019088 | 1019088 | 2021-02-11 | Lake | Michigan | 26085 | 355 | 11 |
1015843 | 1015843 | 2021-02-10 | Lake | Michigan | 26085 | 355 | 11 |
1012598 | 1012598 | 2021-02-09 | Lake | Michigan | 26085 | 355 | 11 |
1009353 | 1009353 | 2021-02-08 | Lake | Michigan | 26085 | 353 | 11 |
1006106 | 1006106 | 2021-02-07 | Lake | Michigan | 26085 | 351 | 11 |
1002860 | 1002860 | 2021-02-06 | Lake | Michigan | 26085 | 351 | 11 |
999615 | 999615 | 2021-02-05 | Lake | Michigan | 26085 | 350 | 11 |
996369 | 996369 | 2021-02-04 | Lake | Michigan | 26085 | 349 | 11 |
993123 | 993123 | 2021-02-03 | Lake | Michigan | 26085 | 349 | 11 |
989877 | 989877 | 2021-02-02 | Lake | Michigan | 26085 | 346 | 11 |
986630 | 986630 | 2021-02-01 | Lake | Michigan | 26085 | 346 | 11 |
983383 | 983383 | 2021-01-31 | Lake | Michigan | 26085 | 345 | 11 |
980137 | 980137 | 2021-01-30 | Lake | Michigan | 26085 | 345 | 11 |
976891 | 976891 | 2021-01-29 | Lake | Michigan | 26085 | 345 | 11 |
973646 | 973646 | 2021-01-28 | Lake | Michigan | 26085 | 345 | 11 |
970401 | 970401 | 2021-01-27 | Lake | Michigan | 26085 | 343 | 11 |
967156 | 967156 | 2021-01-26 | Lake | Michigan | 26085 | 342 | 11 |
963912 | 963912 | 2021-01-25 | Lake | Michigan | 26085 | 342 | 11 |
960667 | 960667 | 2021-01-24 | Lake | Michigan | 26085 | 340 | 11 |
957421 | 957421 | 2021-01-23 | Lake | Michigan | 26085 | 340 | 11 |
954176 | 954176 | 2021-01-22 | Lake | Michigan | 26085 | 340 | 11 |
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);