ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Unknown" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921759 | 921759 | 2021-01-12 | Unknown | Michigan | 8830 | 46 | |
918514 | 918514 | 2021-01-11 | Unknown | Michigan | 8770 | 46 | |
915269 | 915269 | 2021-01-10 | Unknown | Michigan | 8663 | 45 | |
912024 | 912024 | 2021-01-09 | Unknown | Michigan | 8663 | 45 | |
908779 | 908779 | 2021-01-08 | Unknown | Michigan | 8596 | 44 | |
905533 | 905533 | 2021-01-07 | Unknown | Michigan | 8287 | 43 | |
902288 | 902288 | 2021-01-06 | Unknown | Michigan | 8180 | 43 | |
899043 | 899043 | 2021-01-05 | Unknown | Michigan | 8104 | 41 | |
895798 | 895798 | 2021-01-04 | Unknown | Michigan | 8099 | 40 | |
892551 | 892551 | 2021-01-03 | Unknown | Michigan | 8002 | 39 | |
889305 | 889305 | 2021-01-02 | Unknown | Michigan | 8002 | 39 | |
886059 | 886059 | 2021-01-01 | Unknown | Michigan | 7105 | 37 | |
882814 | 882814 | 2020-12-31 | Unknown | Michigan | 7105 | 37 | |
879569 | 879569 | 2020-12-30 | Unknown | Michigan | 7105 | 37 | |
876324 | 876324 | 2020-12-29 | Unknown | Michigan | 7105 | 36 | |
873079 | 873079 | 2020-12-28 | Unknown | Michigan | 7006 | 35 | |
869834 | 869834 | 2020-12-27 | Unknown | Michigan | 6867 | 32 | |
866589 | 866589 | 2020-12-26 | Unknown | Michigan | 6867 | 32 | |
863344 | 863344 | 2020-12-25 | Unknown | Michigan | 6417 | 27 | |
860099 | 860099 | 2020-12-24 | Unknown | Michigan | 6417 | 27 | |
856854 | 856854 | 2020-12-23 | Unknown | Michigan | 6417 | 27 | |
853609 | 853609 | 2020-12-22 | Unknown | Michigan | 5854 | 27 | |
850364 | 850364 | 2020-12-21 | Unknown | Michigan | 5459 | 26 | |
847119 | 847119 | 2020-12-20 | Unknown | Michigan | 5340 | 24 | |
843873 | 843873 | 2020-12-19 | Unknown | Michigan | 5340 | 24 | |
840628 | 840628 | 2020-12-18 | Unknown | Michigan | 4921 | 23 | |
837383 | 837383 | 2020-12-17 | Unknown | Michigan | 4774 | 21 | |
834137 | 834137 | 2020-12-16 | Unknown | Michigan | 4630 | 20 | |
830890 | 830890 | 2020-12-15 | Unknown | Michigan | 4526 | 19 | |
827644 | 827644 | 2020-12-14 | Unknown | Michigan | 4312 | 17 | |
824397 | 824397 | 2020-12-13 | Unknown | Michigan | 3556 | 15 | |
821151 | 821151 | 2020-12-12 | Unknown | Michigan | 3556 | 15 | |
817905 | 817905 | 2020-12-11 | Unknown | Michigan | 3209 | 15 | |
814659 | 814659 | 2020-12-10 | Unknown | Michigan | 2645 | 12 | |
811414 | 811414 | 2020-12-09 | Unknown | Michigan | 2563 | 13 | |
808169 | 808169 | 2020-12-08 | Unknown | Michigan | 2529 | 11 | |
804924 | 804924 | 2020-12-07 | Unknown | Michigan | 2374 | 11 | |
801679 | 801679 | 2020-12-06 | Unknown | Michigan | 1751 | 10 | |
798434 | 798434 | 2020-12-05 | Unknown | Michigan | 1751 | 10 | |
795189 | 795189 | 2020-12-04 | Unknown | Michigan | 1118 | 8 | |
791944 | 791944 | 2020-12-03 | Unknown | Michigan | 6388 | 21 | |
788699 | 788699 | 2020-12-02 | Unknown | Michigan | 6017 | 20 | |
785454 | 785454 | 2020-12-01 | Unknown | Michigan | 6010 | 17 | |
782210 | 782210 | 2020-11-30 | Unknown | Michigan | 5913 | 17 | |
778964 | 778964 | 2020-11-29 | Unknown | Michigan | 5437 | 15 | |
775719 | 775719 | 2020-11-28 | Unknown | Michigan | 5437 | 15 | |
772474 | 772474 | 2020-11-27 | Unknown | Michigan | 4938 | 12 | |
769229 | 769229 | 2020-11-26 | Unknown | Michigan | 4659 | 9 | |
765983 | 765983 | 2020-11-25 | Unknown | Michigan | 4659 | 9 | |
762738 | 762738 | 2020-11-24 | Unknown | Michigan | 4666 | 8 | |
759493 | 759493 | 2020-11-23 | Unknown | Michigan | 4600 | 8 | |
756246 | 756246 | 2020-11-22 | Unknown | Michigan | 4518 | 8 | |
753000 | 753000 | 2020-11-21 | Unknown | Michigan | 4518 | 8 | |
749754 | 749754 | 2020-11-20 | Unknown | Michigan | 3638 | 7 | |
746508 | 746508 | 2020-11-19 | Unknown | Michigan | 2721 | 5 | |
743261 | 743261 | 2020-11-18 | Unknown | Michigan | 2348 | 5 | |
740014 | 740014 | 2020-11-17 | Unknown | Michigan | 2322 | 4 | |
736770 | 736770 | 2020-11-16 | Unknown | Michigan | 2235 | 4 | |
733524 | 733524 | 2020-11-15 | Unknown | Michigan | 2001 | 4 | |
730279 | 730279 | 2020-11-14 | Unknown | Michigan | 2001 | 4 | |
727036 | 727036 | 2020-11-13 | Unknown | Michigan | 1697 | 4 | |
723793 | 723793 | 2020-11-12 | Unknown | Michigan | 1014 | 4 | |
720550 | 720550 | 2020-11-11 | Unknown | Michigan | 860 | 3 | |
717307 | 717307 | 2020-11-10 | Unknown | Michigan | 852 | 3 | |
714063 | 714063 | 2020-11-09 | Unknown | Michigan | 867 | 3 | |
710819 | 710819 | 2020-11-08 | Unknown | Michigan | 431 | 3 | |
707575 | 707575 | 2020-11-07 | Unknown | Michigan | 431 | 3 | |
704332 | 704332 | 2020-11-06 | Unknown | Michigan | 282 | 3 | |
701090 | 701090 | 2020-11-05 | Unknown | Michigan | 235 | 3 | |
697846 | 697846 | 2020-11-04 | Unknown | Michigan | 0 | 3 | |
694603 | 694603 | 2020-11-03 | Unknown | Michigan | 0 | 3 | |
691361 | 691361 | 2020-11-02 | Unknown | Michigan | 1498 | 4 | |
688116 | 688116 | 2020-11-01 | Unknown | Michigan | 1512 | 4 | |
684872 | 684872 | 2020-10-31 | Unknown | Michigan | 1512 | 4 | |
681629 | 681629 | 2020-10-30 | Unknown | Michigan | 1442 | 4 | |
678385 | 678385 | 2020-10-29 | Unknown | Michigan | 1371 | 4 | |
675143 | 675143 | 2020-10-28 | Unknown | Michigan | 1171 | 4 | |
671900 | 671900 | 2020-10-27 | Unknown | Michigan | 1046 | 4 | |
668658 | 668658 | 2020-10-26 | Unknown | Michigan | 1025 | 4 | |
665414 | 665414 | 2020-10-25 | Unknown | Michigan | 991 | 4 | |
662169 | 662169 | 2020-10-24 | Unknown | Michigan | 991 | 4 | |
658925 | 658925 | 2020-10-23 | Unknown | Michigan | 937 | 4 | |
655680 | 655680 | 2020-10-22 | Unknown | Michigan | 808 | 4 | |
652435 | 652435 | 2020-10-21 | Unknown | Michigan | 770 | 4 | |
649190 | 649190 | 2020-10-20 | Unknown | Michigan | 747 | 4 | |
645946 | 645946 | 2020-10-19 | Unknown | Michigan | 727 | 4 | |
642699 | 642699 | 2020-10-18 | Unknown | Michigan | 317 | 4 | |
639452 | 639452 | 2020-10-17 | Unknown | Michigan | 317 | 4 | |
636206 | 636206 | 2020-10-16 | Unknown | Michigan | 317 | 4 | |
632960 | 632960 | 2020-10-15 | Unknown | Michigan | 280 | 4 | |
629715 | 629715 | 2020-10-14 | Unknown | Michigan | 271 | 4 | |
626471 | 626471 | 2020-10-13 | Unknown | Michigan | 268 | 4 | |
623229 | 623229 | 2020-10-12 | Unknown | Michigan | 169 | 4 | |
619986 | 619986 | 2020-10-11 | Unknown | Michigan | 141 | 4 | |
616744 | 616744 | 2020-10-10 | Unknown | Michigan | 141 | 4 | |
613503 | 613503 | 2020-10-09 | Unknown | Michigan | 125 | 4 | |
610261 | 610261 | 2020-10-08 | Unknown | Michigan | 113 | 4 | |
607019 | 607019 | 2020-10-07 | Unknown | Michigan | 121 | 4 | |
603776 | 603776 | 2020-10-06 | Unknown | Michigan | 107 | 3 | |
600534 | 600534 | 2020-10-05 | Unknown | Michigan | 180 | 6 |
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);