ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 26139 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054818 | 1054818 | 2021-02-22 | Ottawa | Michigan | 26139 | 22166 | 347 |
1051571 | 1051571 | 2021-02-21 | Ottawa | Michigan | 26139 | 22114 | 347 |
1048324 | 1048324 | 2021-02-20 | Ottawa | Michigan | 26139 | 22106 | 347 |
1045078 | 1045078 | 2021-02-19 | Ottawa | Michigan | 26139 | 22129 | 347 |
1041833 | 1041833 | 2021-02-18 | Ottawa | Michigan | 26139 | 22087 | 347 |
1038588 | 1038588 | 2021-02-17 | Ottawa | Michigan | 26139 | 22048 | 344 |
1035343 | 1035343 | 2021-02-16 | Ottawa | Michigan | 26139 | 22013 | 344 |
1032098 | 1032098 | 2021-02-15 | Ottawa | Michigan | 26139 | 21944 | 344 |
1028851 | 1028851 | 2021-02-14 | Ottawa | Michigan | 26139 | 21908 | 344 |
1025605 | 1025605 | 2021-02-13 | Ottawa | Michigan | 26139 | 21867 | 344 |
1022360 | 1022360 | 2021-02-12 | Ottawa | Michigan | 26139 | 21839 | 344 |
1019115 | 1019115 | 2021-02-11 | Ottawa | Michigan | 26139 | 21785 | 344 |
1015870 | 1015870 | 2021-02-10 | Ottawa | Michigan | 26139 | 21729 | 341 |
1012625 | 1012625 | 2021-02-09 | Ottawa | Michigan | 26139 | 21673 | 340 |
1009380 | 1009380 | 2021-02-08 | Ottawa | Michigan | 26139 | 21633 | 338 |
1006133 | 1006133 | 2021-02-07 | Ottawa | Michigan | 26139 | 21607 | 338 |
1002887 | 1002887 | 2021-02-06 | Ottawa | Michigan | 26139 | 21571 | 338 |
999642 | 999642 | 2021-02-05 | Ottawa | Michigan | 26139 | 21535 | 337 |
996396 | 996396 | 2021-02-04 | Ottawa | Michigan | 26139 | 21486 | 337 |
993150 | 993150 | 2021-02-03 | Ottawa | Michigan | 26139 | 21411 | 336 |
989904 | 989904 | 2021-02-02 | Ottawa | Michigan | 26139 | 21370 | 336 |
986657 | 986657 | 2021-02-01 | Ottawa | Michigan | 26139 | 21288 | 335 |
983410 | 983410 | 2021-01-31 | Ottawa | Michigan | 26139 | 21288 | 334 |
980164 | 980164 | 2021-01-30 | Ottawa | Michigan | 26139 | 21255 | 334 |
976918 | 976918 | 2021-01-29 | Ottawa | Michigan | 26139 | 21204 | 330 |
973673 | 973673 | 2021-01-28 | Ottawa | Michigan | 26139 | 21144 | 329 |
970428 | 970428 | 2021-01-27 | Ottawa | Michigan | 26139 | 21058 | 327 |
967183 | 967183 | 2021-01-26 | Ottawa | Michigan | 26139 | 20960 | 327 |
963939 | 963939 | 2021-01-25 | Ottawa | Michigan | 26139 | 20877 | 325 |
960694 | 960694 | 2021-01-24 | Ottawa | Michigan | 26139 | 20776 | 324 |
957448 | 957448 | 2021-01-23 | Ottawa | Michigan | 26139 | 20776 | 324 |
954203 | 954203 | 2021-01-22 | Ottawa | Michigan | 26139 | 20715 | 317 |
950958 | 950958 | 2021-01-21 | Ottawa | Michigan | 26139 | 20626 | 317 |
947712 | 947712 | 2021-01-20 | Ottawa | Michigan | 26139 | 20512 | 312 |
944465 | 944465 | 2021-01-19 | Ottawa | Michigan | 26139 | 20473 | 312 |
941220 | 941220 | 2021-01-18 | Ottawa | Michigan | 26139 | 20367 | 311 |
937975 | 937975 | 2021-01-17 | Ottawa | Michigan | 26139 | 20285 | 308 |
934730 | 934730 | 2021-01-16 | Ottawa | Michigan | 26139 | 20239 | 308 |
931485 | 931485 | 2021-01-15 | Ottawa | Michigan | 26139 | 20112 | 307 |
928240 | 928240 | 2021-01-14 | Ottawa | Michigan | 26139 | 20050 | 307 |
924994 | 924994 | 2021-01-13 | Ottawa | Michigan | 26139 | 19926 | 304 |
921749 | 921749 | 2021-01-12 | Ottawa | Michigan | 26139 | 19781 | 302 |
918504 | 918504 | 2021-01-11 | Ottawa | Michigan | 26139 | 19712 | 297 |
915259 | 915259 | 2021-01-10 | Ottawa | Michigan | 26139 | 19552 | 296 |
912014 | 912014 | 2021-01-09 | Ottawa | Michigan | 26139 | 19552 | 296 |
908769 | 908769 | 2021-01-08 | Ottawa | Michigan | 26139 | 19437 | 291 |
905523 | 905523 | 2021-01-07 | Ottawa | Michigan | 26139 | 19314 | 290 |
902278 | 902278 | 2021-01-06 | Ottawa | Michigan | 26139 | 19160 | 287 |
899033 | 899033 | 2021-01-05 | Ottawa | Michigan | 26139 | 19104 | 285 |
895788 | 895788 | 2021-01-04 | Ottawa | Michigan | 26139 | 18997 | 281 |
892541 | 892541 | 2021-01-03 | Ottawa | Michigan | 26139 | 18869 | 277 |
889295 | 889295 | 2021-01-02 | Ottawa | Michigan | 26139 | 18732 | 277 |
886049 | 886049 | 2021-01-01 | Ottawa | Michigan | 26139 | 18732 | 272 |
882804 | 882804 | 2020-12-31 | Ottawa | Michigan | 26139 | 18640 | 272 |
879559 | 879559 | 2020-12-30 | Ottawa | Michigan | 26139 | 18516 | 272 |
876314 | 876314 | 2020-12-29 | Ottawa | Michigan | 26139 | 18346 | 271 |
873069 | 873069 | 2020-12-28 | Ottawa | Michigan | 26139 | 18265 | 264 |
869824 | 869824 | 2020-12-27 | Ottawa | Michigan | 26139 | 18242 | 262 |
866579 | 866579 | 2020-12-26 | Ottawa | Michigan | 26139 | 18206 | 262 |
863334 | 863334 | 2020-12-25 | Ottawa | Michigan | 26139 | 18128 | 253 |
860089 | 860089 | 2020-12-24 | Ottawa | Michigan | 26139 | 18058 | 253 |
856844 | 856844 | 2020-12-23 | Ottawa | Michigan | 26139 | 17928 | 252 |
853599 | 853599 | 2020-12-22 | Ottawa | Michigan | 26139 | 17754 | 248 |
850354 | 850354 | 2020-12-21 | Ottawa | Michigan | 26139 | 17728 | 243 |
847109 | 847109 | 2020-12-20 | Ottawa | Michigan | 26139 | 17700 | 241 |
843863 | 843863 | 2020-12-19 | Ottawa | Michigan | 26139 | 17600 | 241 |
840618 | 840618 | 2020-12-18 | Ottawa | Michigan | 26139 | 17412 | 235 |
837373 | 837373 | 2020-12-17 | Ottawa | Michigan | 26139 | 17305 | 230 |
834127 | 834127 | 2020-12-16 | Ottawa | Michigan | 26139 | 17129 | 226 |
830880 | 830880 | 2020-12-15 | Ottawa | Michigan | 26139 | 16920 | 220 |
827634 | 827634 | 2020-12-14 | Ottawa | Michigan | 26139 | 16758 | 218 |
824387 | 824387 | 2020-12-13 | Ottawa | Michigan | 26139 | 16645 | 214 |
821141 | 821141 | 2020-12-12 | Ottawa | Michigan | 26139 | 16517 | 214 |
817895 | 817895 | 2020-12-11 | Ottawa | Michigan | 26139 | 16402 | 207 |
814649 | 814649 | 2020-12-10 | Ottawa | Michigan | 26139 | 16235 | 205 |
811404 | 811404 | 2020-12-09 | Ottawa | Michigan | 26139 | 16005 | 200 |
808159 | 808159 | 2020-12-08 | Ottawa | Michigan | 26139 | 15824 | 197 |
804914 | 804914 | 2020-12-07 | Ottawa | Michigan | 26139 | 15650 | 184 |
801669 | 801669 | 2020-12-06 | Ottawa | Michigan | 26139 | 15499 | 178 |
798424 | 798424 | 2020-12-05 | Ottawa | Michigan | 26139 | 15326 | 178 |
795179 | 795179 | 2020-12-04 | Ottawa | Michigan | 26139 | 15102 | 173 |
791934 | 791934 | 2020-12-03 | Ottawa | Michigan | 26139 | 14704 | 169 |
788689 | 788689 | 2020-12-02 | Ottawa | Michigan | 26139 | 14386 | 165 |
785444 | 785444 | 2020-12-01 | Ottawa | Michigan | 26139 | 14120 | 163 |
782200 | 782200 | 2020-11-30 | Ottawa | Michigan | 26139 | 13912 | 158 |
778954 | 778954 | 2020-11-29 | Ottawa | Michigan | 26139 | 13700 | 151 |
775709 | 775709 | 2020-11-28 | Ottawa | Michigan | 26139 | 13571 | 151 |
772464 | 772464 | 2020-11-27 | Ottawa | Michigan | 26139 | 13324 | 143 |
769219 | 769219 | 2020-11-26 | Ottawa | Michigan | 26139 | 12667 | 134 |
765973 | 765973 | 2020-11-25 | Ottawa | Michigan | 26139 | 12667 | 134 |
762728 | 762728 | 2020-11-24 | Ottawa | Michigan | 26139 | 12467 | 130 |
759483 | 759483 | 2020-11-23 | Ottawa | Michigan | 26139 | 12229 | 124 |
756236 | 756236 | 2020-11-22 | Ottawa | Michigan | 26139 | 12031 | 124 |
752990 | 752990 | 2020-11-21 | Ottawa | Michigan | 26139 | 11706 | 124 |
749744 | 749744 | 2020-11-20 | Ottawa | Michigan | 26139 | 11344 | 121 |
746498 | 746498 | 2020-11-19 | Ottawa | Michigan | 26139 | 11056 | 120 |
743251 | 743251 | 2020-11-18 | Ottawa | Michigan | 26139 | 10706 | 111 |
740004 | 740004 | 2020-11-17 | Ottawa | Michigan | 26139 | 10394 | 107 |
736760 | 736760 | 2020-11-16 | Ottawa | Michigan | 26139 | 10056 | 104 |
733514 | 733514 | 2020-11-15 | Ottawa | Michigan | 26139 | 9743 | 101 |
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);