ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 26159 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921760 | 921760 | 2021-01-12 | Van Buren | Michigan | 26159 | 4434 | 86 |
918515 | 918515 | 2021-01-11 | Van Buren | Michigan | 26159 | 4409 | 86 |
915270 | 915270 | 2021-01-10 | Van Buren | Michigan | 26159 | 4366 | 85 |
912025 | 912025 | 2021-01-09 | Van Buren | Michigan | 26159 | 4366 | 85 |
908780 | 908780 | 2021-01-08 | Van Buren | Michigan | 26159 | 4337 | 83 |
905534 | 905534 | 2021-01-07 | Van Buren | Michigan | 26159 | 4306 | 83 |
902289 | 902289 | 2021-01-06 | Van Buren | Michigan | 26159 | 4274 | 80 |
899044 | 899044 | 2021-01-05 | Van Buren | Michigan | 26159 | 4229 | 80 |
895799 | 895799 | 2021-01-04 | Van Buren | Michigan | 26159 | 4210 | 79 |
892552 | 892552 | 2021-01-03 | Van Buren | Michigan | 26159 | 4154 | 79 |
889306 | 889306 | 2021-01-02 | Van Buren | Michigan | 26159 | 4154 | 79 |
886060 | 886060 | 2021-01-01 | Van Buren | Michigan | 26159 | 4044 | 78 |
882815 | 882815 | 2020-12-31 | Van Buren | Michigan | 26159 | 4044 | 78 |
879570 | 879570 | 2020-12-30 | Van Buren | Michigan | 26159 | 4044 | 78 |
876325 | 876325 | 2020-12-29 | Van Buren | Michigan | 26159 | 4026 | 78 |
873080 | 873080 | 2020-12-28 | Van Buren | Michigan | 26159 | 3992 | 76 |
869835 | 869835 | 2020-12-27 | Van Buren | Michigan | 26159 | 3972 | 76 |
866590 | 866590 | 2020-12-26 | Van Buren | Michigan | 26159 | 3972 | 76 |
863345 | 863345 | 2020-12-25 | Van Buren | Michigan | 26159 | 3918 | 73 |
860100 | 860100 | 2020-12-24 | Van Buren | Michigan | 26159 | 3918 | 73 |
856855 | 856855 | 2020-12-23 | Van Buren | Michigan | 26159 | 3918 | 73 |
853610 | 853610 | 2020-12-22 | Van Buren | Michigan | 26159 | 3890 | 73 |
850365 | 850365 | 2020-12-21 | Van Buren | Michigan | 26159 | 3893 | 73 |
847120 | 847120 | 2020-12-20 | Van Buren | Michigan | 26159 | 3853 | 73 |
843874 | 843874 | 2020-12-19 | Van Buren | Michigan | 26159 | 3853 | 73 |
840629 | 840629 | 2020-12-18 | Van Buren | Michigan | 26159 | 3801 | 69 |
837384 | 837384 | 2020-12-17 | Van Buren | Michigan | 26159 | 3764 | 69 |
834138 | 834138 | 2020-12-16 | Van Buren | Michigan | 26159 | 3732 | 68 |
830891 | 830891 | 2020-12-15 | Van Buren | Michigan | 26159 | 3685 | 69 |
827645 | 827645 | 2020-12-14 | Van Buren | Michigan | 26159 | 3649 | 65 |
824398 | 824398 | 2020-12-13 | Van Buren | Michigan | 26159 | 3580 | 65 |
821152 | 821152 | 2020-12-12 | Van Buren | Michigan | 26159 | 3580 | 65 |
817906 | 817906 | 2020-12-11 | Van Buren | Michigan | 26159 | 3525 | 59 |
814660 | 814660 | 2020-12-10 | Van Buren | Michigan | 26159 | 3468 | 58 |
811415 | 811415 | 2020-12-09 | Van Buren | Michigan | 26159 | 3412 | 56 |
808170 | 808170 | 2020-12-08 | Van Buren | Michigan | 26159 | 3360 | 55 |
804925 | 804925 | 2020-12-07 | Van Buren | Michigan | 26159 | 3299 | 55 |
801680 | 801680 | 2020-12-06 | Van Buren | Michigan | 26159 | 3189 | 53 |
798435 | 798435 | 2020-12-05 | Van Buren | Michigan | 26159 | 3189 | 53 |
795190 | 795190 | 2020-12-04 | Van Buren | Michigan | 26159 | 3154 | 50 |
791945 | 791945 | 2020-12-03 | Van Buren | Michigan | 26159 | 3054 | 49 |
788700 | 788700 | 2020-12-02 | Van Buren | Michigan | 26159 | 3007 | 47 |
785455 | 785455 | 2020-12-01 | Van Buren | Michigan | 26159 | 2955 | 47 |
782211 | 782211 | 2020-11-30 | Van Buren | Michigan | 26159 | 2884 | 44 |
778965 | 778965 | 2020-11-29 | Van Buren | Michigan | 26159 | 2792 | 43 |
775720 | 775720 | 2020-11-28 | Van Buren | Michigan | 26159 | 2792 | 43 |
772475 | 772475 | 2020-11-27 | Van Buren | Michigan | 26159 | 2727 | 41 |
769230 | 769230 | 2020-11-26 | Van Buren | Michigan | 26159 | 2606 | 35 |
765984 | 765984 | 2020-11-25 | Van Buren | Michigan | 26159 | 2606 | 35 |
762739 | 762739 | 2020-11-24 | Van Buren | Michigan | 26159 | 2569 | 34 |
759494 | 759494 | 2020-11-23 | Van Buren | Michigan | 26159 | 2501 | 32 |
756247 | 756247 | 2020-11-22 | Van Buren | Michigan | 26159 | 2352 | 32 |
753001 | 753001 | 2020-11-21 | Van Buren | Michigan | 26159 | 2352 | 32 |
749755 | 749755 | 2020-11-20 | Van Buren | Michigan | 26159 | 2274 | 31 |
746509 | 746509 | 2020-11-19 | Van Buren | Michigan | 26159 | 2209 | 30 |
743262 | 743262 | 2020-11-18 | Van Buren | Michigan | 26159 | 2136 | 29 |
740015 | 740015 | 2020-11-17 | Van Buren | Michigan | 26159 | 2085 | 25 |
736771 | 736771 | 2020-11-16 | Van Buren | Michigan | 26159 | 2010 | 25 |
733525 | 733525 | 2020-11-15 | Van Buren | Michigan | 26159 | 1925 | 25 |
730280 | 730280 | 2020-11-14 | Van Buren | Michigan | 26159 | 1925 | 25 |
727037 | 727037 | 2020-11-13 | Van Buren | Michigan | 26159 | 1858 | 25 |
723794 | 723794 | 2020-11-12 | Van Buren | Michigan | 26159 | 1807 | 23 |
720551 | 720551 | 2020-11-11 | Van Buren | Michigan | 26159 | 1760 | 23 |
717308 | 717308 | 2020-11-10 | Van Buren | Michigan | 26159 | 1692 | 22 |
714064 | 714064 | 2020-11-09 | Van Buren | Michigan | 26159 | 1628 | 22 |
710820 | 710820 | 2020-11-08 | Van Buren | Michigan | 26159 | 1495 | 21 |
707576 | 707576 | 2020-11-07 | Van Buren | Michigan | 26159 | 1495 | 21 |
704333 | 704333 | 2020-11-06 | Van Buren | Michigan | 26159 | 1446 | 21 |
701091 | 701091 | 2020-11-05 | Van Buren | Michigan | 26159 | 1415 | 20 |
697847 | 697847 | 2020-11-04 | Van Buren | Michigan | 26159 | 1375 | 20 |
694604 | 694604 | 2020-11-03 | Van Buren | Michigan | 26159 | 1338 | 20 |
691362 | 691362 | 2020-11-02 | Van Buren | Michigan | 26159 | 1315 | 20 |
688117 | 688117 | 2020-11-01 | Van Buren | Michigan | 26159 | 1222 | 20 |
684873 | 684873 | 2020-10-31 | Van Buren | Michigan | 26159 | 1222 | 20 |
681630 | 681630 | 2020-10-30 | Van Buren | Michigan | 26159 | 1182 | 20 |
678386 | 678386 | 2020-10-29 | Van Buren | Michigan | 26159 | 1157 | 20 |
675144 | 675144 | 2020-10-28 | Van Buren | Michigan | 26159 | 1124 | 19 |
671901 | 671901 | 2020-10-27 | Van Buren | Michigan | 26159 | 1092 | 19 |
668659 | 668659 | 2020-10-26 | Van Buren | Michigan | 26159 | 1080 | 18 |
665415 | 665415 | 2020-10-25 | Van Buren | Michigan | 26159 | 1040 | 18 |
662170 | 662170 | 2020-10-24 | Van Buren | Michigan | 26159 | 1040 | 18 |
658926 | 658926 | 2020-10-23 | Van Buren | Michigan | 26159 | 1001 | 18 |
655681 | 655681 | 2020-10-22 | Van Buren | Michigan | 26159 | 996 | 18 |
652436 | 652436 | 2020-10-21 | Van Buren | Michigan | 26159 | 974 | 18 |
649191 | 649191 | 2020-10-20 | Van Buren | Michigan | 26159 | 967 | 18 |
645947 | 645947 | 2020-10-19 | Van Buren | Michigan | 26159 | 958 | 18 |
642700 | 642700 | 2020-10-18 | Van Buren | Michigan | 26159 | 914 | 18 |
639453 | 639453 | 2020-10-17 | Van Buren | Michigan | 26159 | 914 | 18 |
636207 | 636207 | 2020-10-16 | Van Buren | Michigan | 26159 | 914 | 18 |
632961 | 632961 | 2020-10-15 | Van Buren | Michigan | 26159 | 904 | 18 |
629716 | 629716 | 2020-10-14 | Van Buren | Michigan | 26159 | 882 | 18 |
626472 | 626472 | 2020-10-13 | Van Buren | Michigan | 26159 | 876 | 18 |
623230 | 623230 | 2020-10-12 | Van Buren | Michigan | 26159 | 872 | 18 |
619987 | 619987 | 2020-10-11 | Van Buren | Michigan | 26159 | 846 | 18 |
616745 | 616745 | 2020-10-10 | Van Buren | Michigan | 26159 | 846 | 18 |
613504 | 613504 | 2020-10-09 | Van Buren | Michigan | 26159 | 833 | 18 |
610262 | 610262 | 2020-10-08 | Van Buren | Michigan | 26159 | 825 | 18 |
607020 | 607020 | 2020-10-07 | Van Buren | Michigan | 26159 | 812 | 18 |
603777 | 603777 | 2020-10-06 | Van Buren | Michigan | 26159 | 809 | 18 |
600535 | 600535 | 2020-10-05 | Van Buren | Michigan | 26159 | 805 | 18 |
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);