ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
679 rows where county = "Ontonagon" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921745 | 921745 | 2021-01-12 | Ontonagon | Michigan | 26131 | 313 | 16 |
918500 | 918500 | 2021-01-11 | Ontonagon | Michigan | 26131 | 312 | 16 |
915255 | 915255 | 2021-01-10 | Ontonagon | Michigan | 26131 | 312 | 16 |
912010 | 912010 | 2021-01-09 | Ontonagon | Michigan | 26131 | 312 | 16 |
908765 | 908765 | 2021-01-08 | Ontonagon | Michigan | 26131 | 312 | 16 |
905519 | 905519 | 2021-01-07 | Ontonagon | Michigan | 26131 | 310 | 16 |
902274 | 902274 | 2021-01-06 | Ontonagon | Michigan | 26131 | 309 | 16 |
899029 | 899029 | 2021-01-05 | Ontonagon | Michigan | 26131 | 309 | 16 |
895784 | 895784 | 2021-01-04 | Ontonagon | Michigan | 26131 | 309 | 16 |
892537 | 892537 | 2021-01-03 | Ontonagon | Michigan | 26131 | 307 | 16 |
889291 | 889291 | 2021-01-02 | Ontonagon | Michigan | 26131 | 307 | 16 |
886045 | 886045 | 2021-01-01 | Ontonagon | Michigan | 26131 | 306 | 16 |
882800 | 882800 | 2020-12-31 | Ontonagon | Michigan | 26131 | 306 | 16 |
879555 | 879555 | 2020-12-30 | Ontonagon | Michigan | 26131 | 306 | 16 |
876310 | 876310 | 2020-12-29 | Ontonagon | Michigan | 26131 | 306 | 16 |
873065 | 873065 | 2020-12-28 | Ontonagon | Michigan | 26131 | 304 | 16 |
869820 | 869820 | 2020-12-27 | Ontonagon | Michigan | 26131 | 304 | 16 |
866575 | 866575 | 2020-12-26 | Ontonagon | Michigan | 26131 | 304 | 16 |
863330 | 863330 | 2020-12-25 | Ontonagon | Michigan | 26131 | 303 | 15 |
860085 | 860085 | 2020-12-24 | Ontonagon | Michigan | 26131 | 303 | 15 |
856840 | 856840 | 2020-12-23 | Ontonagon | Michigan | 26131 | 303 | 15 |
853595 | 853595 | 2020-12-22 | Ontonagon | Michigan | 26131 | 303 | 15 |
850350 | 850350 | 2020-12-21 | Ontonagon | Michigan | 26131 | 303 | 15 |
847105 | 847105 | 2020-12-20 | Ontonagon | Michigan | 26131 | 302 | 15 |
843859 | 843859 | 2020-12-19 | Ontonagon | Michigan | 26131 | 302 | 15 |
840614 | 840614 | 2020-12-18 | Ontonagon | Michigan | 26131 | 300 | 15 |
837369 | 837369 | 2020-12-17 | Ontonagon | Michigan | 26131 | 300 | 15 |
834123 | 834123 | 2020-12-16 | Ontonagon | Michigan | 26131 | 300 | 15 |
830876 | 830876 | 2020-12-15 | Ontonagon | Michigan | 26131 | 300 | 15 |
827630 | 827630 | 2020-12-14 | Ontonagon | Michigan | 26131 | 299 | 15 |
824383 | 824383 | 2020-12-13 | Ontonagon | Michigan | 26131 | 298 | 15 |
821137 | 821137 | 2020-12-12 | Ontonagon | Michigan | 26131 | 298 | 15 |
817891 | 817891 | 2020-12-11 | Ontonagon | Michigan | 26131 | 296 | 15 |
814645 | 814645 | 2020-12-10 | Ontonagon | Michigan | 26131 | 296 | 16 |
811400 | 811400 | 2020-12-09 | Ontonagon | Michigan | 26131 | 296 | 15 |
808155 | 808155 | 2020-12-08 | Ontonagon | Michigan | 26131 | 296 | 15 |
804910 | 804910 | 2020-12-07 | Ontonagon | Michigan | 26131 | 294 | 15 |
801665 | 801665 | 2020-12-06 | Ontonagon | Michigan | 26131 | 292 | 15 |
798420 | 798420 | 2020-12-05 | Ontonagon | Michigan | 26131 | 292 | 15 |
795175 | 795175 | 2020-12-04 | Ontonagon | Michigan | 26131 | 291 | 14 |
791930 | 791930 | 2020-12-03 | Ontonagon | Michigan | 26131 | 288 | 14 |
788685 | 788685 | 2020-12-02 | Ontonagon | Michigan | 26131 | 283 | 14 |
785440 | 785440 | 2020-12-01 | Ontonagon | Michigan | 26131 | 280 | 14 |
782196 | 782196 | 2020-11-30 | Ontonagon | Michigan | 26131 | 275 | 14 |
778950 | 778950 | 2020-11-29 | Ontonagon | Michigan | 26131 | 275 | 14 |
775705 | 775705 | 2020-11-28 | Ontonagon | Michigan | 26131 | 275 | 14 |
772460 | 772460 | 2020-11-27 | Ontonagon | Michigan | 26131 | 275 | 13 |
769215 | 769215 | 2020-11-26 | Ontonagon | Michigan | 26131 | 270 | 13 |
765969 | 765969 | 2020-11-25 | Ontonagon | Michigan | 26131 | 270 | 13 |
762724 | 762724 | 2020-11-24 | Ontonagon | Michigan | 26131 | 270 | 12 |
759479 | 759479 | 2020-11-23 | Ontonagon | Michigan | 26131 | 267 | 12 |
756232 | 756232 | 2020-11-22 | Ontonagon | Michigan | 26131 | 257 | 11 |
752986 | 752986 | 2020-11-21 | Ontonagon | Michigan | 26131 | 257 | 11 |
749740 | 749740 | 2020-11-20 | Ontonagon | Michigan | 26131 | 254 | 10 |
746494 | 746494 | 2020-11-19 | Ontonagon | Michigan | 26131 | 251 | 9 |
743247 | 743247 | 2020-11-18 | Ontonagon | Michigan | 26131 | 251 | 7 |
740000 | 740000 | 2020-11-17 | Ontonagon | Michigan | 26131 | 246 | 7 |
736756 | 736756 | 2020-11-16 | Ontonagon | Michigan | 26131 | 244 | 6 |
733510 | 733510 | 2020-11-15 | Ontonagon | Michigan | 26131 | 237 | 6 |
730265 | 730265 | 2020-11-14 | Ontonagon | Michigan | 26131 | 237 | 6 |
727022 | 727022 | 2020-11-13 | Ontonagon | Michigan | 26131 | 235 | 5 |
723779 | 723779 | 2020-11-12 | Ontonagon | Michigan | 26131 | 226 | 5 |
720536 | 720536 | 2020-11-11 | Ontonagon | Michigan | 26131 | 222 | 4 |
717293 | 717293 | 2020-11-10 | Ontonagon | Michigan | 26131 | 217 | 2 |
714049 | 714049 | 2020-11-09 | Ontonagon | Michigan | 26131 | 211 | 1 |
710805 | 710805 | 2020-11-08 | Ontonagon | Michigan | 26131 | 198 | 1 |
707561 | 707561 | 2020-11-07 | Ontonagon | Michigan | 26131 | 198 | 1 |
704318 | 704318 | 2020-11-06 | Ontonagon | Michigan | 26131 | 187 | 1 |
701076 | 701076 | 2020-11-05 | Ontonagon | Michigan | 26131 | 183 | 1 |
697832 | 697832 | 2020-11-04 | Ontonagon | Michigan | 26131 | 166 | 1 |
694589 | 694589 | 2020-11-03 | Ontonagon | Michigan | 26131 | 145 | 1 |
691347 | 691347 | 2020-11-02 | Ontonagon | Michigan | 26131 | 129 | 1 |
688102 | 688102 | 2020-11-01 | Ontonagon | Michigan | 26131 | 127 | 1 |
684858 | 684858 | 2020-10-31 | Ontonagon | Michigan | 26131 | 127 | 1 |
681615 | 681615 | 2020-10-30 | Ontonagon | Michigan | 26131 | 116 | 0 |
678371 | 678371 | 2020-10-29 | Ontonagon | Michigan | 26131 | 110 | 0 |
675129 | 675129 | 2020-10-28 | Ontonagon | Michigan | 26131 | 106 | 0 |
671886 | 671886 | 2020-10-27 | Ontonagon | Michigan | 26131 | 103 | 0 |
668644 | 668644 | 2020-10-26 | Ontonagon | Michigan | 26131 | 96 | 0 |
665400 | 665400 | 2020-10-25 | Ontonagon | Michigan | 26131 | 91 | 0 |
662155 | 662155 | 2020-10-24 | Ontonagon | Michigan | 26131 | 91 | 0 |
658911 | 658911 | 2020-10-23 | Ontonagon | Michigan | 26131 | 79 | 0 |
655666 | 655666 | 2020-10-22 | Ontonagon | Michigan | 26131 | 78 | 0 |
652421 | 652421 | 2020-10-21 | Ontonagon | Michigan | 26131 | 74 | 0 |
649176 | 649176 | 2020-10-20 | Ontonagon | Michigan | 26131 | 73 | 0 |
645932 | 645932 | 2020-10-19 | Ontonagon | Michigan | 26131 | 72 | 0 |
642685 | 642685 | 2020-10-18 | Ontonagon | Michigan | 26131 | 64 | 0 |
639438 | 639438 | 2020-10-17 | Ontonagon | Michigan | 26131 | 64 | 0 |
636192 | 636192 | 2020-10-16 | Ontonagon | Michigan | 26131 | 64 | 0 |
632946 | 632946 | 2020-10-15 | Ontonagon | Michigan | 26131 | 60 | 0 |
629701 | 629701 | 2020-10-14 | Ontonagon | Michigan | 26131 | 59 | 0 |
626457 | 626457 | 2020-10-13 | Ontonagon | Michigan | 26131 | 58 | 0 |
623215 | 623215 | 2020-10-12 | Ontonagon | Michigan | 26131 | 57 | 0 |
619972 | 619972 | 2020-10-11 | Ontonagon | Michigan | 26131 | 53 | 0 |
616730 | 616730 | 2020-10-10 | Ontonagon | Michigan | 26131 | 53 | 0 |
613489 | 613489 | 2020-10-09 | Ontonagon | Michigan | 26131 | 50 | 0 |
610247 | 610247 | 2020-10-08 | Ontonagon | Michigan | 26131 | 50 | 0 |
607005 | 607005 | 2020-10-07 | Ontonagon | Michigan | 26131 | 46 | 0 |
603762 | 603762 | 2020-10-06 | Ontonagon | Michigan | 26131 | 46 | 0 |
600520 | 600520 | 2020-10-05 | Ontonagon | Michigan | 26131 | 46 | 0 |
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);