ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 26161 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636208 | 636208 | 2020-10-16 | Washtenaw | Michigan | 26161 | 5072 | 126 |
632962 | 632962 | 2020-10-15 | Washtenaw | Michigan | 26161 | 5004 | 126 |
629717 | 629717 | 2020-10-14 | Washtenaw | Michigan | 26161 | 4832 | 126 |
626473 | 626473 | 2020-10-13 | Washtenaw | Michigan | 26161 | 4756 | 126 |
623231 | 623231 | 2020-10-12 | Washtenaw | Michigan | 26161 | 4615 | 126 |
619988 | 619988 | 2020-10-11 | Washtenaw | Michigan | 26161 | 4605 | 126 |
616746 | 616746 | 2020-10-10 | Washtenaw | Michigan | 26161 | 4605 | 126 |
613505 | 613505 | 2020-10-09 | Washtenaw | Michigan | 26161 | 4605 | 126 |
610263 | 610263 | 2020-10-08 | Washtenaw | Michigan | 26161 | 4569 | 126 |
607021 | 607021 | 2020-10-07 | Washtenaw | Michigan | 26161 | 4497 | 126 |
603778 | 603778 | 2020-10-06 | Washtenaw | Michigan | 26161 | 4459 | 126 |
600536 | 600536 | 2020-10-05 | Washtenaw | Michigan | 26161 | 4429 | 126 |
597293 | 597293 | 2020-10-04 | Washtenaw | Michigan | 26161 | 4373 | 126 |
594052 | 594052 | 2020-10-03 | Washtenaw | Michigan | 26161 | 4373 | 126 |
590811 | 590811 | 2020-10-02 | Washtenaw | Michigan | 26161 | 4373 | 126 |
587570 | 587570 | 2020-10-01 | Washtenaw | Michigan | 26161 | 4326 | 126 |
584330 | 584330 | 2020-09-30 | Washtenaw | Michigan | 26161 | 4300 | 126 |
581089 | 581089 | 2020-09-29 | Washtenaw | Michigan | 26161 | 4260 | 126 |
577848 | 577848 | 2020-09-28 | Washtenaw | Michigan | 26161 | 4189 | 126 |
574607 | 574607 | 2020-09-27 | Washtenaw | Michigan | 26161 | 4050 | 125 |
571364 | 571364 | 2020-09-26 | Washtenaw | Michigan | 26161 | 4050 | 125 |
568122 | 568122 | 2020-09-25 | Washtenaw | Michigan | 26161 | 4050 | 125 |
564882 | 564882 | 2020-09-24 | Washtenaw | Michigan | 26161 | 4009 | 125 |
561642 | 561642 | 2020-09-23 | Washtenaw | Michigan | 26161 | 3919 | 125 |
558405 | 558405 | 2020-09-22 | Washtenaw | Michigan | 26161 | 3902 | 125 |
555168 | 555168 | 2020-09-21 | Washtenaw | Michigan | 26161 | 3881 | 125 |
551930 | 551930 | 2020-09-20 | Washtenaw | Michigan | 26161 | 3819 | 125 |
548691 | 548691 | 2020-09-19 | Washtenaw | Michigan | 26161 | 3819 | 125 |
545453 | 545453 | 2020-09-18 | Washtenaw | Michigan | 26161 | 3819 | 125 |
542216 | 542216 | 2020-09-17 | Washtenaw | Michigan | 26161 | 3794 | 125 |
538980 | 538980 | 2020-09-16 | Washtenaw | Michigan | 26161 | 3744 | 125 |
535743 | 535743 | 2020-09-15 | Washtenaw | Michigan | 26161 | 3733 | 125 |
532508 | 532508 | 2020-09-14 | Washtenaw | Michigan | 26161 | 3715 | 124 |
529272 | 529272 | 2020-09-13 | Washtenaw | Michigan | 26161 | 3657 | 124 |
526036 | 526036 | 2020-09-12 | Washtenaw | Michigan | 26161 | 3657 | 124 |
522800 | 522800 | 2020-09-11 | Washtenaw | Michigan | 26161 | 3657 | 124 |
519563 | 519563 | 2020-09-10 | Washtenaw | Michigan | 26161 | 3603 | 124 |
516328 | 516328 | 2020-09-09 | Washtenaw | Michigan | 26161 | 3588 | 124 |
513094 | 513094 | 2020-09-08 | Washtenaw | Michigan | 26161 | 3564 | 124 |
509862 | 509862 | 2020-09-07 | Washtenaw | Michigan | 26161 | 3508 | 124 |
506629 | 506629 | 2020-09-06 | Washtenaw | Michigan | 26161 | 3508 | 124 |
503396 | 503396 | 2020-09-05 | Washtenaw | Michigan | 26161 | 3508 | 124 |
500162 | 500162 | 2020-09-04 | Washtenaw | Michigan | 26161 | 3508 | 124 |
496928 | 496928 | 2020-09-03 | Washtenaw | Michigan | 26161 | 3482 | 124 |
493695 | 493695 | 2020-09-02 | Washtenaw | Michigan | 26161 | 3466 | 124 |
490461 | 490461 | 2020-09-01 | Washtenaw | Michigan | 26161 | 3448 | 124 |
487228 | 487228 | 2020-08-31 | Washtenaw | Michigan | 26161 | 3425 | 124 |
483994 | 483994 | 2020-08-30 | Washtenaw | Michigan | 26161 | 3381 | 124 |
480759 | 480759 | 2020-08-29 | Washtenaw | Michigan | 26161 | 3381 | 124 |
477527 | 477527 | 2020-08-28 | Washtenaw | Michigan | 26161 | 3381 | 124 |
474294 | 474294 | 2020-08-27 | Washtenaw | Michigan | 26161 | 3367 | 124 |
471062 | 471062 | 2020-08-26 | Washtenaw | Michigan | 26161 | 3351 | 124 |
467832 | 467832 | 2020-08-25 | Washtenaw | Michigan | 26161 | 3328 | 124 |
464603 | 464603 | 2020-08-24 | Washtenaw | Michigan | 26161 | 3306 | 124 |
461372 | 461372 | 2020-08-23 | Washtenaw | Michigan | 26161 | 3249 | 124 |
458145 | 458145 | 2020-08-22 | Washtenaw | Michigan | 26161 | 3249 | 124 |
454917 | 454917 | 2020-08-21 | Washtenaw | Michigan | 26161 | 3249 | 124 |
451689 | 451689 | 2020-08-20 | Washtenaw | Michigan | 26161 | 3235 | 124 |
448461 | 448461 | 2020-08-19 | Washtenaw | Michigan | 26161 | 3214 | 124 |
445235 | 445235 | 2020-08-18 | Washtenaw | Michigan | 26161 | 3191 | 123 |
442009 | 442009 | 2020-08-17 | Washtenaw | Michigan | 26161 | 3181 | 123 |
438782 | 438782 | 2020-08-16 | Washtenaw | Michigan | 26161 | 3153 | 123 |
435557 | 435557 | 2020-08-15 | Washtenaw | Michigan | 26161 | 3153 | 123 |
432331 | 432331 | 2020-08-14 | Washtenaw | Michigan | 26161 | 3153 | 123 |
429104 | 429104 | 2020-08-13 | Washtenaw | Michigan | 26161 | 3138 | 122 |
425880 | 425880 | 2020-08-12 | Washtenaw | Michigan | 26161 | 3111 | 122 |
422658 | 422658 | 2020-08-11 | Washtenaw | Michigan | 26161 | 3100 | 122 |
419436 | 419436 | 2020-08-10 | Washtenaw | Michigan | 26161 | 3081 | 122 |
416215 | 416215 | 2020-08-09 | Washtenaw | Michigan | 26161 | 3031 | 122 |
412995 | 412995 | 2020-08-08 | Washtenaw | Michigan | 26161 | 3031 | 122 |
409775 | 409775 | 2020-08-07 | Washtenaw | Michigan | 26161 | 3031 | 122 |
406555 | 406555 | 2020-08-06 | Washtenaw | Michigan | 26161 | 2997 | 122 |
403337 | 403337 | 2020-08-05 | Washtenaw | Michigan | 26161 | 2982 | 122 |
400120 | 400120 | 2020-08-04 | Washtenaw | Michigan | 26161 | 2953 | 122 |
396906 | 396906 | 2020-08-03 | Washtenaw | Michigan | 26161 | 2933 | 122 |
393690 | 393690 | 2020-08-02 | Washtenaw | Michigan | 26161 | 2894 | 122 |
390473 | 390473 | 2020-08-01 | Washtenaw | Michigan | 26161 | 2894 | 122 |
387256 | 387256 | 2020-07-31 | Washtenaw | Michigan | 26161 | 2894 | 122 |
384038 | 384038 | 2020-07-30 | Washtenaw | Michigan | 26161 | 2860 | 122 |
380821 | 380821 | 2020-07-29 | Washtenaw | Michigan | 26161 | 2846 | 121 |
377604 | 377604 | 2020-07-28 | Washtenaw | Michigan | 26161 | 2814 | 120 |
374389 | 374389 | 2020-07-27 | Washtenaw | Michigan | 26161 | 2797 | 119 |
371177 | 371177 | 2020-07-26 | Washtenaw | Michigan | 26161 | 2725 | 119 |
367967 | 367967 | 2020-07-25 | Washtenaw | Michigan | 26161 | 2725 | 119 |
364760 | 364760 | 2020-07-24 | Washtenaw | Michigan | 26161 | 2725 | 119 |
361553 | 361553 | 2020-07-23 | Washtenaw | Michigan | 26161 | 2688 | 119 |
358348 | 358348 | 2020-07-22 | Washtenaw | Michigan | 26161 | 2670 | 120 |
355145 | 355145 | 2020-07-21 | Washtenaw | Michigan | 26161 | 2645 | 120 |
351943 | 351943 | 2020-07-20 | Washtenaw | Michigan | 26161 | 2628 | 120 |
348743 | 348743 | 2020-07-19 | Washtenaw | Michigan | 26161 | 2575 | 119 |
345542 | 345542 | 2020-07-18 | Washtenaw | Michigan | 26161 | 2575 | 119 |
342342 | 342342 | 2020-07-17 | Washtenaw | Michigan | 26161 | 2575 | 119 |
339146 | 339146 | 2020-07-16 | Washtenaw | Michigan | 26161 | 2511 | 119 |
335950 | 335950 | 2020-07-15 | Washtenaw | Michigan | 26161 | 2483 | 119 |
332757 | 332757 | 2020-07-14 | Washtenaw | Michigan | 26161 | 2454 | 118 |
329570 | 329570 | 2020-07-13 | Washtenaw | Michigan | 26161 | 2433 | 118 |
326384 | 326384 | 2020-07-12 | Washtenaw | Michigan | 26161 | 2413 | 118 |
323201 | 323201 | 2020-07-11 | Washtenaw | Michigan | 26161 | 2408 | 118 |
320022 | 320022 | 2020-07-10 | Washtenaw | Michigan | 26161 | 2381 | 117 |
316847 | 316847 | 2020-07-09 | Washtenaw | Michigan | 26161 | 2340 | 117 |
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);