ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Miami" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947355 | 947355 | 2021-01-20 | Miami | Kansas | 20121 | 2343 | 25 |
944108 | 944108 | 2021-01-19 | Miami | Kansas | 20121 | 2221 | 19 |
940863 | 940863 | 2021-01-18 | Miami | Kansas | 20121 | 2221 | 19 |
937618 | 937618 | 2021-01-17 | Miami | Kansas | 20121 | 2209 | 19 |
934373 | 934373 | 2021-01-16 | Miami | Kansas | 20121 | 2209 | 19 |
931128 | 931128 | 2021-01-15 | Miami | Kansas | 20121 | 2209 | 19 |
927883 | 927883 | 2021-01-14 | Miami | Kansas | 20121 | 2178 | 19 |
924637 | 924637 | 2021-01-13 | Miami | Kansas | 20121 | 2178 | 19 |
921392 | 921392 | 2021-01-12 | Miami | Kansas | 20121 | 2133 | 15 |
918147 | 918147 | 2021-01-11 | Miami | Kansas | 20121 | 2133 | 15 |
914902 | 914902 | 2021-01-10 | Miami | Kansas | 20121 | 2083 | 15 |
911657 | 911657 | 2021-01-09 | Miami | Kansas | 20121 | 2083 | 15 |
908412 | 908412 | 2021-01-08 | Miami | Kansas | 20121 | 2083 | 15 |
905166 | 905166 | 2021-01-07 | Miami | Kansas | 20121 | 2002 | 15 |
901921 | 901921 | 2021-01-06 | Miami | Kansas | 20121 | 2002 | 15 |
898676 | 898676 | 2021-01-05 | Miami | Kansas | 20121 | 1941 | 15 |
895431 | 895431 | 2021-01-04 | Miami | Kansas | 20121 | 1941 | 15 |
892184 | 892184 | 2021-01-03 | Miami | Kansas | 20121 | 1880 | 15 |
888938 | 888938 | 2021-01-02 | Miami | Kansas | 20121 | 1880 | 15 |
885692 | 885692 | 2021-01-01 | Miami | Kansas | 20121 | 1880 | 15 |
882447 | 882447 | 2020-12-31 | Miami | Kansas | 20121 | 1818 | 7 |
879202 | 879202 | 2020-12-30 | Miami | Kansas | 20121 | 1818 | 7 |
875957 | 875957 | 2020-12-29 | Miami | Kansas | 20121 | 1725 | 7 |
872712 | 872712 | 2020-12-28 | Miami | Kansas | 20121 | 1725 | 7 |
869467 | 869467 | 2020-12-27 | Miami | Kansas | 20121 | 1618 | 7 |
866222 | 866222 | 2020-12-26 | Miami | Kansas | 20121 | 1618 | 7 |
862977 | 862977 | 2020-12-25 | Miami | Kansas | 20121 | 1618 | 7 |
859732 | 859732 | 2020-12-24 | Miami | Kansas | 20121 | 1618 | 7 |
856487 | 856487 | 2020-12-23 | Miami | Kansas | 20121 | 1618 | 7 |
853242 | 853242 | 2020-12-22 | Miami | Kansas | 20121 | 1566 | 7 |
849997 | 849997 | 2020-12-21 | Miami | Kansas | 20121 | 1566 | 7 |
846752 | 846752 | 2020-12-20 | Miami | Kansas | 20121 | 1514 | 7 |
843506 | 843506 | 2020-12-19 | Miami | Kansas | 20121 | 1514 | 7 |
840261 | 840261 | 2020-12-18 | Miami | Kansas | 20121 | 1514 | 7 |
837016 | 837016 | 2020-12-17 | Miami | Kansas | 20121 | 1456 | 7 |
833770 | 833770 | 2020-12-16 | Miami | Kansas | 20121 | 1456 | 7 |
830523 | 830523 | 2020-12-15 | Miami | Kansas | 20121 | 1404 | 7 |
827277 | 827277 | 2020-12-14 | Miami | Kansas | 20121 | 1404 | 7 |
824030 | 824030 | 2020-12-13 | Miami | Kansas | 20121 | 1339 | 7 |
820784 | 820784 | 2020-12-12 | Miami | Kansas | 20121 | 1339 | 7 |
817538 | 817538 | 2020-12-11 | Miami | Kansas | 20121 | 1339 | 7 |
814292 | 814292 | 2020-12-10 | Miami | Kansas | 20121 | 1296 | 7 |
811047 | 811047 | 2020-12-09 | Miami | Kansas | 20121 | 1296 | 7 |
807802 | 807802 | 2020-12-08 | Miami | Kansas | 20121 | 1229 | 5 |
804557 | 804557 | 2020-12-07 | Miami | Kansas | 20121 | 1229 | 5 |
801312 | 801312 | 2020-12-06 | Miami | Kansas | 20121 | 1143 | 5 |
798067 | 798067 | 2020-12-05 | Miami | Kansas | 20121 | 1143 | 5 |
794822 | 794822 | 2020-12-04 | Miami | Kansas | 20121 | 1143 | 5 |
791577 | 791577 | 2020-12-03 | Miami | Kansas | 20121 | 1091 | 3 |
788332 | 788332 | 2020-12-02 | Miami | Kansas | 20121 | 1091 | 3 |
785088 | 785088 | 2020-12-01 | Miami | Kansas | 20121 | 1073 | 2 |
781843 | 781843 | 2020-11-30 | Miami | Kansas | 20121 | 1073 | 2 |
778597 | 778597 | 2020-11-29 | Miami | Kansas | 20121 | 1013 | 2 |
775352 | 775352 | 2020-11-28 | Miami | Kansas | 20121 | 1013 | 2 |
772107 | 772107 | 2020-11-27 | Miami | Kansas | 20121 | 1013 | 2 |
768862 | 768862 | 2020-11-26 | Miami | Kansas | 20121 | 970 | 2 |
765616 | 765616 | 2020-11-25 | Miami | Kansas | 20121 | 970 | 2 |
762371 | 762371 | 2020-11-24 | Miami | Kansas | 20121 | 923 | 2 |
759126 | 759126 | 2020-11-23 | Miami | Kansas | 20121 | 923 | 2 |
755879 | 755879 | 2020-11-22 | Miami | Kansas | 20121 | 866 | 2 |
752633 | 752633 | 2020-11-21 | Miami | Kansas | 20121 | 866 | 2 |
749387 | 749387 | 2020-11-20 | Miami | Kansas | 20121 | 866 | 2 |
746141 | 746141 | 2020-11-19 | Miami | Kansas | 20121 | 823 | 2 |
742894 | 742894 | 2020-11-18 | Miami | Kansas | 20121 | 823 | 2 |
739647 | 739647 | 2020-11-17 | Miami | Kansas | 20121 | 786 | 2 |
736403 | 736403 | 2020-11-16 | Miami | Kansas | 20121 | 786 | 2 |
733157 | 733157 | 2020-11-15 | Miami | Kansas | 20121 | 747 | 2 |
729912 | 729912 | 2020-11-14 | Miami | Kansas | 20121 | 747 | 2 |
726669 | 726669 | 2020-11-13 | Miami | Kansas | 20121 | 747 | 2 |
723426 | 723426 | 2020-11-12 | Miami | Kansas | 20121 | 712 | 2 |
720183 | 720183 | 2020-11-11 | Miami | Kansas | 20121 | 712 | 2 |
716940 | 716940 | 2020-11-10 | Miami | Kansas | 20121 | 680 | 2 |
713696 | 713696 | 2020-11-09 | Miami | Kansas | 20121 | 680 | 2 |
710452 | 710452 | 2020-11-08 | Miami | Kansas | 20121 | 648 | 2 |
707208 | 707208 | 2020-11-07 | Miami | Kansas | 20121 | 648 | 2 |
703965 | 703965 | 2020-11-06 | Miami | Kansas | 20121 | 648 | 2 |
700723 | 700723 | 2020-11-05 | Miami | Kansas | 20121 | 620 | 2 |
697479 | 697479 | 2020-11-04 | Miami | Kansas | 20121 | 620 | 2 |
694237 | 694237 | 2020-11-03 | Miami | Kansas | 20121 | 603 | 2 |
690994 | 690994 | 2020-11-02 | Miami | Kansas | 20121 | 603 | 2 |
687749 | 687749 | 2020-11-01 | Miami | Kansas | 20121 | 583 | 2 |
684505 | 684505 | 2020-10-31 | Miami | Kansas | 20121 | 583 | 2 |
681262 | 681262 | 2020-10-30 | Miami | Kansas | 20121 | 583 | 2 |
678019 | 678019 | 2020-10-29 | Miami | Kansas | 20121 | 563 | 2 |
674776 | 674776 | 2020-10-28 | Miami | Kansas | 20121 | 563 | 2 |
671534 | 671534 | 2020-10-27 | Miami | Kansas | 20121 | 539 | 2 |
668291 | 668291 | 2020-10-26 | Miami | Kansas | 20121 | 539 | 2 |
665047 | 665047 | 2020-10-25 | Miami | Kansas | 20121 | 520 | 2 |
661802 | 661802 | 2020-10-24 | Miami | Kansas | 20121 | 520 | 2 |
658558 | 658558 | 2020-10-23 | Miami | Kansas | 20121 | 520 | 2 |
655313 | 655313 | 2020-10-22 | Miami | Kansas | 20121 | 509 | 2 |
652068 | 652068 | 2020-10-21 | Miami | Kansas | 20121 | 509 | 2 |
648824 | 648824 | 2020-10-20 | Miami | Kansas | 20121 | 505 | 2 |
645579 | 645579 | 2020-10-19 | Miami | Kansas | 20121 | 505 | 2 |
642332 | 642332 | 2020-10-18 | Miami | Kansas | 20121 | 495 | 2 |
639085 | 639085 | 2020-10-17 | Miami | Kansas | 20121 | 495 | 2 |
635839 | 635839 | 2020-10-16 | Miami | Kansas | 20121 | 495 | 2 |
632593 | 632593 | 2020-10-15 | Miami | Kansas | 20121 | 480 | 2 |
629349 | 629349 | 2020-10-14 | Miami | Kansas | 20121 | 480 | 2 |
626106 | 626106 | 2020-10-13 | Miami | Kansas | 20121 | 469 | 1 |
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);