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 |
---|---|---|---|---|---|---|---|
1054830 | 1054830 | 2021-02-22 | Washtenaw | Michigan | 26161 | 18978 | 251 |
1051583 | 1051583 | 2021-02-21 | Washtenaw | Michigan | 26161 | 18852 | 249 |
1048336 | 1048336 | 2021-02-20 | Washtenaw | Michigan | 26161 | 18852 | 249 |
1045090 | 1045090 | 2021-02-19 | Washtenaw | Michigan | 26161 | 18852 | 249 |
1041845 | 1041845 | 2021-02-18 | Washtenaw | Michigan | 26161 | 18759 | 249 |
1038600 | 1038600 | 2021-02-17 | Washtenaw | Michigan | 26161 | 18658 | 246 |
1035355 | 1035355 | 2021-02-16 | Washtenaw | Michigan | 26161 | 18519 | 245 |
1032110 | 1032110 | 2021-02-15 | Washtenaw | Michigan | 26161 | 18485 | 244 |
1028863 | 1028863 | 2021-02-14 | Washtenaw | Michigan | 26161 | 18415 | 244 |
1025617 | 1025617 | 2021-02-13 | Washtenaw | Michigan | 26161 | 18415 | 244 |
1022372 | 1022372 | 2021-02-12 | Washtenaw | Michigan | 26161 | 18404 | 242 |
1019127 | 1019127 | 2021-02-11 | Washtenaw | Michigan | 26161 | 18294 | 242 |
1015882 | 1015882 | 2021-02-10 | Washtenaw | Michigan | 26161 | 18164 | 241 |
1012637 | 1012637 | 2021-02-09 | Washtenaw | Michigan | 26161 | 18116 | 241 |
1009392 | 1009392 | 2021-02-08 | Washtenaw | Michigan | 26161 | 18157 | 240 |
1006145 | 1006145 | 2021-02-07 | Washtenaw | Michigan | 26161 | 17890 | 237 |
1002899 | 1002899 | 2021-02-06 | Washtenaw | Michigan | 26161 | 17890 | 237 |
999654 | 999654 | 2021-02-05 | Washtenaw | Michigan | 26161 | 17890 | 237 |
996408 | 996408 | 2021-02-04 | Washtenaw | Michigan | 26161 | 17789 | 237 |
993162 | 993162 | 2021-02-03 | Washtenaw | Michigan | 26161 | 17561 | 236 |
989916 | 989916 | 2021-02-02 | Washtenaw | Michigan | 26161 | 17492 | 236 |
986669 | 986669 | 2021-02-01 | Washtenaw | Michigan | 26161 | 17395 | 236 |
983422 | 983422 | 2021-01-31 | Washtenaw | Michigan | 26161 | 17165 | 234 |
980176 | 980176 | 2021-01-30 | Washtenaw | Michigan | 26161 | 17165 | 234 |
976930 | 976930 | 2021-01-29 | Washtenaw | Michigan | 26161 | 17162 | 234 |
973685 | 973685 | 2021-01-28 | Washtenaw | Michigan | 26161 | 17015 | 234 |
970440 | 970440 | 2021-01-27 | Washtenaw | Michigan | 26161 | 16814 | 231 |
967195 | 967195 | 2021-01-26 | Washtenaw | Michigan | 26161 | 16722 | 231 |
963951 | 963951 | 2021-01-25 | Washtenaw | Michigan | 26161 | 16588 | 231 |
960706 | 960706 | 2021-01-24 | Washtenaw | Michigan | 26161 | 16402 | 231 |
957460 | 957460 | 2021-01-23 | Washtenaw | Michigan | 26161 | 16402 | 231 |
954215 | 954215 | 2021-01-22 | Washtenaw | Michigan | 26161 | 16402 | 228 |
950970 | 950970 | 2021-01-21 | Washtenaw | Michigan | 26161 | 16341 | 228 |
947724 | 947724 | 2021-01-20 | Washtenaw | Michigan | 26161 | 16208 | 226 |
944477 | 944477 | 2021-01-19 | Washtenaw | Michigan | 26161 | 16145 | 225 |
941232 | 941232 | 2021-01-18 | Washtenaw | Michigan | 26161 | 15957 | 225 |
937987 | 937987 | 2021-01-17 | Washtenaw | Michigan | 26161 | 15880 | 225 |
934742 | 934742 | 2021-01-16 | Washtenaw | Michigan | 26161 | 15880 | 225 |
931497 | 931497 | 2021-01-15 | Washtenaw | Michigan | 26161 | 15880 | 224 |
928252 | 928252 | 2021-01-14 | Washtenaw | Michigan | 26161 | 15801 | 224 |
925006 | 925006 | 2021-01-13 | Washtenaw | Michigan | 26161 | 15607 | 222 |
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 |
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);