ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Kent" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054789 | 1054789 | 2021-02-22 | Kent | Michigan | 26081 | 51266 | 702 |
1051542 | 1051542 | 2021-02-21 | Kent | Michigan | 26081 | 51155 | 702 |
1048295 | 1048295 | 2021-02-20 | Kent | Michigan | 26081 | 51155 | 702 |
1045049 | 1045049 | 2021-02-19 | Kent | Michigan | 26081 | 51098 | 699 |
1041804 | 1041804 | 2021-02-18 | Kent | Michigan | 26081 | 50989 | 698 |
1038559 | 1038559 | 2021-02-17 | Kent | Michigan | 26081 | 50909 | 694 |
1035314 | 1035314 | 2021-02-16 | Kent | Michigan | 26081 | 50814 | 691 |
1032069 | 1032069 | 2021-02-15 | Kent | Michigan | 26081 | 50736 | 691 |
1028822 | 1028822 | 2021-02-14 | Kent | Michigan | 26081 | 50605 | 691 |
1025576 | 1025576 | 2021-02-13 | Kent | Michigan | 26081 | 50605 | 691 |
1022331 | 1022331 | 2021-02-12 | Kent | Michigan | 26081 | 50521 | 687 |
1019086 | 1019086 | 2021-02-11 | Kent | Michigan | 26081 | 50419 | 686 |
1015841 | 1015841 | 2021-02-10 | Kent | Michigan | 26081 | 50279 | 682 |
1012596 | 1012596 | 2021-02-09 | Kent | Michigan | 26081 | 50164 | 680 |
1009351 | 1009351 | 2021-02-08 | Kent | Michigan | 26081 | 50100 | 673 |
1006104 | 1006104 | 2021-02-07 | Kent | Michigan | 26081 | 49982 | 673 |
1002858 | 1002858 | 2021-02-06 | Kent | Michigan | 26081 | 49982 | 673 |
999613 | 999613 | 2021-02-05 | Kent | Michigan | 26081 | 49877 | 668 |
996367 | 996367 | 2021-02-04 | Kent | Michigan | 26081 | 49765 | 667 |
993121 | 993121 | 2021-02-03 | Kent | Michigan | 26081 | 49666 | 663 |
989875 | 989875 | 2021-02-02 | Kent | Michigan | 26081 | 49522 | 656 |
986628 | 986628 | 2021-02-01 | Kent | Michigan | 26081 | 49427 | 656 |
983381 | 983381 | 2021-01-31 | Kent | Michigan | 26081 | 49248 | 656 |
980135 | 980135 | 2021-01-30 | Kent | Michigan | 26081 | 49248 | 656 |
976889 | 976889 | 2021-01-29 | Kent | Michigan | 26081 | 49145 | 650 |
973644 | 973644 | 2021-01-28 | Kent | Michigan | 26081 | 49017 | 645 |
970399 | 970399 | 2021-01-27 | Kent | Michigan | 26081 | 48906 | 642 |
967154 | 967154 | 2021-01-26 | Kent | Michigan | 26081 | 48744 | 639 |
963910 | 963910 | 2021-01-25 | Kent | Michigan | 26081 | 48585 | 637 |
960665 | 960665 | 2021-01-24 | Kent | Michigan | 26081 | 48326 | 636 |
957419 | 957419 | 2021-01-23 | Kent | Michigan | 26081 | 48326 | 636 |
954174 | 954174 | 2021-01-22 | Kent | Michigan | 26081 | 48204 | 627 |
950929 | 950929 | 2021-01-21 | Kent | Michigan | 26081 | 48035 | 626 |
947683 | 947683 | 2021-01-20 | Kent | Michigan | 26081 | 47832 | 616 |
944436 | 944436 | 2021-01-19 | Kent | Michigan | 26081 | 47637 | 614 |
941191 | 941191 | 2021-01-18 | Kent | Michigan | 26081 | 47492 | 612 |
937946 | 937946 | 2021-01-17 | Kent | Michigan | 26081 | 47247 | 612 |
934701 | 934701 | 2021-01-16 | Kent | Michigan | 26081 | 47247 | 612 |
931456 | 931456 | 2021-01-15 | Kent | Michigan | 26081 | 47116 | 606 |
928211 | 928211 | 2021-01-14 | Kent | Michigan | 26081 | 46942 | 603 |
924965 | 924965 | 2021-01-13 | Kent | Michigan | 26081 | 46663 | 594 |
921720 | 921720 | 2021-01-12 | Kent | Michigan | 26081 | 46391 | 594 |
918475 | 918475 | 2021-01-11 | Kent | Michigan | 26081 | 46228 | 594 |
915230 | 915230 | 2021-01-10 | Kent | Michigan | 26081 | 45841 | 592 |
911985 | 911985 | 2021-01-09 | Kent | Michigan | 26081 | 45841 | 592 |
908740 | 908740 | 2021-01-08 | Kent | Michigan | 26081 | 45628 | 585 |
905494 | 905494 | 2021-01-07 | Kent | Michigan | 26081 | 45319 | 584 |
902249 | 902249 | 2021-01-06 | Kent | Michigan | 26081 | 45031 | 572 |
899004 | 899004 | 2021-01-05 | Kent | Michigan | 26081 | 44681 | 571 |
895759 | 895759 | 2021-01-04 | Kent | Michigan | 26081 | 44386 | 566 |
892512 | 892512 | 2021-01-03 | Kent | Michigan | 26081 | 44060 | 555 |
889266 | 889266 | 2021-01-02 | Kent | Michigan | 26081 | 44060 | 555 |
886020 | 886020 | 2021-01-01 | Kent | Michigan | 26081 | 43280 | 543 |
882775 | 882775 | 2020-12-31 | Kent | Michigan | 26081 | 43280 | 543 |
879530 | 879530 | 2020-12-30 | Kent | Michigan | 26081 | 43280 | 543 |
876285 | 876285 | 2020-12-29 | Kent | Michigan | 26081 | 42942 | 539 |
873040 | 873040 | 2020-12-28 | Kent | Michigan | 26081 | 42710 | 529 |
869795 | 869795 | 2020-12-27 | Kent | Michigan | 26081 | 42379 | 525 |
866550 | 866550 | 2020-12-26 | Kent | Michigan | 26081 | 42379 | 525 |
863305 | 863305 | 2020-12-25 | Kent | Michigan | 26081 | 41840 | 511 |
860060 | 860060 | 2020-12-24 | Kent | Michigan | 26081 | 41840 | 511 |
856815 | 856815 | 2020-12-23 | Kent | Michigan | 26081 | 41840 | 511 |
853570 | 853570 | 2020-12-22 | Kent | Michigan | 26081 | 41604 | 511 |
850325 | 850325 | 2020-12-21 | Kent | Michigan | 26081 | 41452 | 503 |
847080 | 847080 | 2020-12-20 | Kent | Michigan | 26081 | 41084 | 503 |
843834 | 843834 | 2020-12-19 | Kent | Michigan | 26081 | 41084 | 503 |
840589 | 840589 | 2020-12-18 | Kent | Michigan | 26081 | 40862 | 493 |
837344 | 837344 | 2020-12-17 | Kent | Michigan | 26081 | 40577 | 483 |
834098 | 834098 | 2020-12-16 | Kent | Michigan | 26081 | 40259 | 472 |
830851 | 830851 | 2020-12-15 | Kent | Michigan | 26081 | 39888 | 471 |
827605 | 827605 | 2020-12-14 | Kent | Michigan | 26081 | 39597 | 455 |
824358 | 824358 | 2020-12-13 | Kent | Michigan | 26081 | 39038 | 452 |
821112 | 821112 | 2020-12-12 | Kent | Michigan | 26081 | 39038 | 452 |
817866 | 817866 | 2020-12-11 | Kent | Michigan | 26081 | 38726 | 439 |
814620 | 814620 | 2020-12-10 | Kent | Michigan | 26081 | 38373 | 441 |
811375 | 811375 | 2020-12-09 | Kent | Michigan | 26081 | 37822 | 428 |
808130 | 808130 | 2020-12-08 | Kent | Michigan | 26081 | 37409 | 426 |
804885 | 804885 | 2020-12-07 | Kent | Michigan | 26081 | 37011 | 414 |
801640 | 801640 | 2020-12-06 | Kent | Michigan | 26081 | 36189 | 400 |
798395 | 798395 | 2020-12-05 | Kent | Michigan | 26081 | 36189 | 400 |
795150 | 795150 | 2020-12-04 | Kent | Michigan | 26081 | 35832 | 381 |
791905 | 791905 | 2020-12-03 | Kent | Michigan | 26081 | 35140 | 376 |
788660 | 788660 | 2020-12-02 | Kent | Michigan | 26081 | 34544 | 360 |
785415 | 785415 | 2020-12-01 | Kent | Michigan | 26081 | 33963 | 363 |
782171 | 782171 | 2020-11-30 | Kent | Michigan | 26081 | 33402 | 354 |
778925 | 778925 | 2020-11-29 | Kent | Michigan | 26081 | 32588 | 344 |
775680 | 775680 | 2020-11-28 | Kent | Michigan | 26081 | 32588 | 344 |
772435 | 772435 | 2020-11-27 | Kent | Michigan | 26081 | 32138 | 336 |
769190 | 769190 | 2020-11-26 | Kent | Michigan | 26081 | 30512 | 312 |
765944 | 765944 | 2020-11-25 | Kent | Michigan | 26081 | 30512 | 312 |
762699 | 762699 | 2020-11-24 | Kent | Michigan | 26081 | 30084 | 312 |
759454 | 759454 | 2020-11-23 | Kent | Michigan | 26081 | 29591 | 301 |
756207 | 756207 | 2020-11-22 | Kent | Michigan | 26081 | 28340 | 292 |
752961 | 752961 | 2020-11-21 | Kent | Michigan | 26081 | 28340 | 292 |
749715 | 749715 | 2020-11-20 | Kent | Michigan | 26081 | 27712 | 285 |
746469 | 746469 | 2020-11-19 | Kent | Michigan | 26081 | 27055 | 277 |
743222 | 743222 | 2020-11-18 | Kent | Michigan | 26081 | 26313 | 267 |
739975 | 739975 | 2020-11-17 | Kent | Michigan | 26081 | 25705 | 257 |
736731 | 736731 | 2020-11-16 | Kent | Michigan | 26081 | 24996 | 254 |
733485 | 733485 | 2020-11-15 | Kent | Michigan | 26081 | 23631 | 247 |
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);