ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Calhoun" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636139 | 636139 | 2020-10-16 | Calhoun | Michigan | 26025 | 2150 | 53 |
632893 | 632893 | 2020-10-15 | Calhoun | Michigan | 26025 | 2087 | 51 |
629648 | 629648 | 2020-10-14 | Calhoun | Michigan | 26025 | 1978 | 51 |
626404 | 626404 | 2020-10-13 | Calhoun | Michigan | 26025 | 1940 | 51 |
623162 | 623162 | 2020-10-12 | Calhoun | Michigan | 26025 | 1877 | 51 |
619919 | 619919 | 2020-10-11 | Calhoun | Michigan | 26025 | 1825 | 51 |
616677 | 616677 | 2020-10-10 | Calhoun | Michigan | 26025 | 1825 | 51 |
613436 | 613436 | 2020-10-09 | Calhoun | Michigan | 26025 | 1773 | 51 |
610194 | 610194 | 2020-10-08 | Calhoun | Michigan | 26025 | 1740 | 51 |
606952 | 606952 | 2020-10-07 | Calhoun | Michigan | 26025 | 1696 | 50 |
603709 | 603709 | 2020-10-06 | Calhoun | Michigan | 26025 | 1649 | 50 |
600467 | 600467 | 2020-10-05 | Calhoun | Michigan | 26025 | 1622 | 49 |
597224 | 597224 | 2020-10-04 | Calhoun | Michigan | 26025 | 1584 | 48 |
593983 | 593983 | 2020-10-03 | Calhoun | Michigan | 26025 | 1584 | 48 |
590742 | 590742 | 2020-10-02 | Calhoun | Michigan | 26025 | 1547 | 47 |
587501 | 587501 | 2020-10-01 | Calhoun | Michigan | 26025 | 1522 | 47 |
584261 | 584261 | 2020-09-30 | Calhoun | Michigan | 26025 | 1492 | 46 |
581020 | 581020 | 2020-09-29 | Calhoun | Michigan | 26025 | 1442 | 46 |
577779 | 577779 | 2020-09-28 | Calhoun | Michigan | 26025 | 1401 | 45 |
574538 | 574538 | 2020-09-27 | Calhoun | Michigan | 26025 | 1357 | 45 |
571295 | 571295 | 2020-09-26 | Calhoun | Michigan | 26025 | 1357 | 45 |
568053 | 568053 | 2020-09-25 | Calhoun | Michigan | 26025 | 1332 | 45 |
564813 | 564813 | 2020-09-24 | Calhoun | Michigan | 26025 | 1287 | 45 |
561573 | 561573 | 2020-09-23 | Calhoun | Michigan | 26025 | 1265 | 45 |
558336 | 558336 | 2020-09-22 | Calhoun | Michigan | 26025 | 1250 | 45 |
555099 | 555099 | 2020-09-21 | Calhoun | Michigan | 26025 | 1239 | 45 |
551861 | 551861 | 2020-09-20 | Calhoun | Michigan | 26025 | 1222 | 44 |
548622 | 548622 | 2020-09-19 | Calhoun | Michigan | 26025 | 1222 | 44 |
545384 | 545384 | 2020-09-18 | Calhoun | Michigan | 26025 | 1211 | 44 |
542147 | 542147 | 2020-09-17 | Calhoun | Michigan | 26025 | 1192 | 44 |
538911 | 538911 | 2020-09-16 | Calhoun | Michigan | 26025 | 1174 | 44 |
535674 | 535674 | 2020-09-15 | Calhoun | Michigan | 26025 | 1160 | 44 |
532439 | 532439 | 2020-09-14 | Calhoun | Michigan | 26025 | 1153 | 44 |
529203 | 529203 | 2020-09-13 | Calhoun | Michigan | 26025 | 1130 | 44 |
525967 | 525967 | 2020-09-12 | Calhoun | Michigan | 26025 | 1130 | 44 |
522731 | 522731 | 2020-09-11 | Calhoun | Michigan | 26025 | 1120 | 44 |
519494 | 519494 | 2020-09-10 | Calhoun | Michigan | 26025 | 1113 | 44 |
516259 | 516259 | 2020-09-09 | Calhoun | Michigan | 26025 | 1099 | 44 |
513025 | 513025 | 2020-09-08 | Calhoun | Michigan | 26025 | 1094 | 44 |
509793 | 509793 | 2020-09-07 | Calhoun | Michigan | 26025 | 1089 | 44 |
506560 | 506560 | 2020-09-06 | Calhoun | Michigan | 26025 | 1070 | 44 |
503327 | 503327 | 2020-09-05 | Calhoun | Michigan | 26025 | 1070 | 44 |
500093 | 500093 | 2020-09-04 | Calhoun | Michigan | 26025 | 1054 | 44 |
496859 | 496859 | 2020-09-03 | Calhoun | Michigan | 26025 | 1029 | 44 |
493626 | 493626 | 2020-09-02 | Calhoun | Michigan | 26025 | 1018 | 44 |
490392 | 490392 | 2020-09-01 | Calhoun | Michigan | 26025 | 1004 | 44 |
487159 | 487159 | 2020-08-31 | Calhoun | Michigan | 26025 | 994 | 44 |
483925 | 483925 | 2020-08-30 | Calhoun | Michigan | 26025 | 983 | 44 |
480690 | 480690 | 2020-08-29 | Calhoun | Michigan | 26025 | 974 | 45 |
477458 | 477458 | 2020-08-28 | Calhoun | Michigan | 26025 | 958 | 44 |
474225 | 474225 | 2020-08-27 | Calhoun | Michigan | 26025 | 947 | 44 |
470993 | 470993 | 2020-08-26 | Calhoun | Michigan | 26025 | 909 | 44 |
467763 | 467763 | 2020-08-25 | Calhoun | Michigan | 26025 | 897 | 44 |
464534 | 464534 | 2020-08-24 | Calhoun | Michigan | 26025 | 886 | 43 |
461303 | 461303 | 2020-08-23 | Calhoun | Michigan | 26025 | 878 | 43 |
458076 | 458076 | 2020-08-22 | Calhoun | Michigan | 26025 | 873 | 43 |
454848 | 454848 | 2020-08-21 | Calhoun | Michigan | 26025 | 864 | 43 |
451620 | 451620 | 2020-08-20 | Calhoun | Michigan | 26025 | 864 | 43 |
448392 | 448392 | 2020-08-19 | Calhoun | Michigan | 26025 | 862 | 43 |
445166 | 445166 | 2020-08-18 | Calhoun | Michigan | 26025 | 853 | 43 |
441940 | 441940 | 2020-08-17 | Calhoun | Michigan | 26025 | 849 | 43 |
438713 | 438713 | 2020-08-16 | Calhoun | Michigan | 26025 | 839 | 43 |
435488 | 435488 | 2020-08-15 | Calhoun | Michigan | 26025 | 835 | 43 |
432262 | 432262 | 2020-08-14 | Calhoun | Michigan | 26025 | 829 | 43 |
429035 | 429035 | 2020-08-13 | Calhoun | Michigan | 26025 | 819 | 42 |
425811 | 425811 | 2020-08-12 | Calhoun | Michigan | 26025 | 811 | 42 |
422589 | 422589 | 2020-08-11 | Calhoun | Michigan | 26025 | 802 | 42 |
419367 | 419367 | 2020-08-10 | Calhoun | Michigan | 26025 | 795 | 42 |
416146 | 416146 | 2020-08-09 | Calhoun | Michigan | 26025 | 789 | 41 |
412926 | 412926 | 2020-08-08 | Calhoun | Michigan | 26025 | 789 | 41 |
409706 | 409706 | 2020-08-07 | Calhoun | Michigan | 26025 | 782 | 41 |
406486 | 406486 | 2020-08-06 | Calhoun | Michigan | 26025 | 776 | 41 |
403268 | 403268 | 2020-08-05 | Calhoun | Michigan | 26025 | 768 | 41 |
400051 | 400051 | 2020-08-04 | Calhoun | Michigan | 26025 | 754 | 41 |
396837 | 396837 | 2020-08-03 | Calhoun | Michigan | 26025 | 749 | 42 |
393621 | 393621 | 2020-08-02 | Calhoun | Michigan | 26025 | 747 | 42 |
390404 | 390404 | 2020-08-01 | Calhoun | Michigan | 26025 | 737 | 42 |
387187 | 387187 | 2020-07-31 | Calhoun | Michigan | 26025 | 728 | 41 |
383969 | 383969 | 2020-07-30 | Calhoun | Michigan | 26025 | 717 | 41 |
380752 | 380752 | 2020-07-29 | Calhoun | Michigan | 26025 | 708 | 41 |
377535 | 377535 | 2020-07-28 | Calhoun | Michigan | 26025 | 705 | 40 |
374320 | 374320 | 2020-07-27 | Calhoun | Michigan | 26025 | 699 | 39 |
371108 | 371108 | 2020-07-26 | Calhoun | Michigan | 26025 | 694 | 39 |
367898 | 367898 | 2020-07-25 | Calhoun | Michigan | 26025 | 688 | 39 |
364691 | 364691 | 2020-07-24 | Calhoun | Michigan | 26025 | 685 | 39 |
361484 | 361484 | 2020-07-23 | Calhoun | Michigan | 26025 | 680 | 39 |
358279 | 358279 | 2020-07-22 | Calhoun | Michigan | 26025 | 676 | 39 |
355076 | 355076 | 2020-07-21 | Calhoun | Michigan | 26025 | 670 | 39 |
351874 | 351874 | 2020-07-20 | Calhoun | Michigan | 26025 | 665 | 39 |
348674 | 348674 | 2020-07-19 | Calhoun | Michigan | 26025 | 652 | 39 |
345473 | 345473 | 2020-07-18 | Calhoun | Michigan | 26025 | 651 | 39 |
342273 | 342273 | 2020-07-17 | Calhoun | Michigan | 26025 | 642 | 39 |
339077 | 339077 | 2020-07-16 | Calhoun | Michigan | 26025 | 636 | 39 |
335881 | 335881 | 2020-07-15 | Calhoun | Michigan | 26025 | 630 | 39 |
332688 | 332688 | 2020-07-14 | Calhoun | Michigan | 26025 | 622 | 39 |
329501 | 329501 | 2020-07-13 | Calhoun | Michigan | 26025 | 615 | 39 |
326315 | 326315 | 2020-07-12 | Calhoun | Michigan | 26025 | 608 | 39 |
323132 | 323132 | 2020-07-11 | Calhoun | Michigan | 26025 | 607 | 39 |
319953 | 319953 | 2020-07-10 | Calhoun | Michigan | 26025 | 598 | 39 |
316778 | 316778 | 2020-07-09 | Calhoun | Michigan | 26025 | 594 | 39 |
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);