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 |
---|---|---|---|---|---|---|---|
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 |
869836 | 869836 | 2020-12-27 | Washtenaw | Michigan | 26161 | 13742 | 195 |
866591 | 866591 | 2020-12-26 | Washtenaw | Michigan | 26161 | 13742 | 195 |
863346 | 863346 | 2020-12-25 | Washtenaw | Michigan | 26161 | 13572 | 187 |
860101 | 860101 | 2020-12-24 | Washtenaw | Michigan | 26161 | 13572 | 187 |
856856 | 856856 | 2020-12-23 | Washtenaw | Michigan | 26161 | 13572 | 187 |
853611 | 853611 | 2020-12-22 | Washtenaw | Michigan | 26161 | 13572 | 187 |
850366 | 850366 | 2020-12-21 | Washtenaw | Michigan | 26161 | 13420 | 180 |
847121 | 847121 | 2020-12-20 | Washtenaw | Michigan | 26161 | 13251 | 180 |
843875 | 843875 | 2020-12-19 | Washtenaw | Michigan | 26161 | 13251 | 180 |
840630 | 840630 | 2020-12-18 | Washtenaw | Michigan | 26161 | 13240 | 176 |
837385 | 837385 | 2020-12-17 | Washtenaw | Michigan | 26161 | 13135 | 173 |
834139 | 834139 | 2020-12-16 | Washtenaw | Michigan | 26161 | 12966 | 171 |
830892 | 830892 | 2020-12-15 | Washtenaw | Michigan | 26161 | 12874 | 167 |
827646 | 827646 | 2020-12-14 | Washtenaw | Michigan | 26161 | 12636 | 166 |
824399 | 824399 | 2020-12-13 | Washtenaw | Michigan | 26161 | 12334 | 162 |
821153 | 821153 | 2020-12-12 | Washtenaw | Michigan | 26161 | 12334 | 162 |
817907 | 817907 | 2020-12-11 | Washtenaw | Michigan | 26161 | 12286 | 162 |
814661 | 814661 | 2020-12-10 | Washtenaw | Michigan | 26161 | 12165 | 160 |
811416 | 811416 | 2020-12-09 | Washtenaw | Michigan | 26161 | 11941 | 157 |
808171 | 808171 | 2020-12-08 | Washtenaw | Michigan | 26161 | 11809 | 156 |
804926 | 804926 | 2020-12-07 | Washtenaw | Michigan | 26161 | 11629 | 152 |
801681 | 801681 | 2020-12-06 | Washtenaw | Michigan | 26161 | 11306 | 150 |
798436 | 798436 | 2020-12-05 | Washtenaw | Michigan | 26161 | 11306 | 150 |
795191 | 795191 | 2020-12-04 | Washtenaw | Michigan | 26161 | 11283 | 150 |
791946 | 791946 | 2020-12-03 | Washtenaw | Michigan | 26161 | 11198 | 149 |
788701 | 788701 | 2020-12-02 | Washtenaw | Michigan | 26161 | 10924 | 144 |
785456 | 785456 | 2020-12-01 | Washtenaw | Michigan | 26161 | 10887 | 145 |
782212 | 782212 | 2020-11-30 | Washtenaw | Michigan | 26161 | 10593 | 144 |
778966 | 778966 | 2020-11-29 | Washtenaw | Michigan | 26161 | 10332 | 141 |
775721 | 775721 | 2020-11-28 | Washtenaw | Michigan | 26161 | 10332 | 141 |
772476 | 772476 | 2020-11-27 | Washtenaw | Michigan | 26161 | 10121 | 140 |
769231 | 769231 | 2020-11-26 | Washtenaw | Michigan | 26161 | 9784 | 140 |
765985 | 765985 | 2020-11-25 | Washtenaw | Michigan | 26161 | 9784 | 140 |
762740 | 762740 | 2020-11-24 | Washtenaw | Michigan | 26161 | 9659 | 140 |
759495 | 759495 | 2020-11-23 | Washtenaw | Michigan | 26161 | 9479 | 140 |
756248 | 756248 | 2020-11-22 | Washtenaw | Michigan | 26161 | 9086 | 137 |
753002 | 753002 | 2020-11-21 | Washtenaw | Michigan | 26161 | 9086 | 137 |
749756 | 749756 | 2020-11-20 | Washtenaw | Michigan | 26161 | 9009 | 137 |
746510 | 746510 | 2020-11-19 | Washtenaw | Michigan | 26161 | 8747 | 137 |
743263 | 743263 | 2020-11-18 | Washtenaw | Michigan | 26161 | 8554 | 135 |
740016 | 740016 | 2020-11-17 | Washtenaw | Michigan | 26161 | 8428 | 135 |
736772 | 736772 | 2020-11-16 | Washtenaw | Michigan | 26161 | 8272 | 135 |
733526 | 733526 | 2020-11-15 | Washtenaw | Michigan | 26161 | 7925 | 133 |
730281 | 730281 | 2020-11-14 | Washtenaw | Michigan | 26161 | 7925 | 133 |
727038 | 727038 | 2020-11-13 | Washtenaw | Michigan | 26161 | 7866 | 133 |
723795 | 723795 | 2020-11-12 | Washtenaw | Michigan | 26161 | 7716 | 131 |
720552 | 720552 | 2020-11-11 | Washtenaw | Michigan | 26161 | 7393 | 131 |
717309 | 717309 | 2020-11-10 | Washtenaw | Michigan | 26161 | 7298 | 131 |
714065 | 714065 | 2020-11-09 | Washtenaw | Michigan | 26161 | 7165 | 131 |
710821 | 710821 | 2020-11-08 | Washtenaw | Michigan | 26161 | 6923 | 129 |
707577 | 707577 | 2020-11-07 | Washtenaw | Michigan | 26161 | 6923 | 129 |
704334 | 704334 | 2020-11-06 | Washtenaw | Michigan | 26161 | 6842 | 129 |
701092 | 701092 | 2020-11-05 | Washtenaw | Michigan | 26161 | 6751 | 129 |
697848 | 697848 | 2020-11-04 | Washtenaw | Michigan | 26161 | 6595 | 129 |
694605 | 694605 | 2020-11-03 | Washtenaw | Michigan | 26161 | 6499 | 129 |
691363 | 691363 | 2020-11-02 | Washtenaw | Michigan | 26161 | 6424 | 129 |
688118 | 688118 | 2020-11-01 | Washtenaw | Michigan | 26161 | 6240 | 129 |
684874 | 684874 | 2020-10-31 | Washtenaw | Michigan | 26161 | 6240 | 129 |
681631 | 681631 | 2020-10-30 | Washtenaw | Michigan | 26161 | 6240 | 129 |
678387 | 678387 | 2020-10-29 | Washtenaw | Michigan | 26161 | 6175 | 128 |
675145 | 675145 | 2020-10-28 | Washtenaw | Michigan | 26161 | 6040 | 128 |
671902 | 671902 | 2020-10-27 | Washtenaw | Michigan | 26161 | 5964 | 128 |
668660 | 668660 | 2020-10-26 | Washtenaw | Michigan | 26161 | 5877 | 127 |
665416 | 665416 | 2020-10-25 | Washtenaw | Michigan | 26161 | 5651 | 127 |
662171 | 662171 | 2020-10-24 | Washtenaw | Michigan | 26161 | 5651 | 127 |
658927 | 658927 | 2020-10-23 | Washtenaw | Michigan | 26161 | 5634 | 127 |
655682 | 655682 | 2020-10-22 | Washtenaw | Michigan | 26161 | 5550 | 126 |
652437 | 652437 | 2020-10-21 | Washtenaw | Michigan | 26161 | 5448 | 126 |
649192 | 649192 | 2020-10-20 | Washtenaw | Michigan | 26161 | 5360 | 126 |
645948 | 645948 | 2020-10-19 | Washtenaw | Michigan | 26161 | 5273 | 126 |
642701 | 642701 | 2020-10-18 | Washtenaw | Michigan | 26161 | 5072 | 126 |
639454 | 639454 | 2020-10-17 | Washtenaw | Michigan | 26161 | 5072 | 126 |
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 |
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);