ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 20021 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947305 | 947305 | 2021-01-20 | Cherokee | Kansas | 20021 | 2073 | 16 |
944058 | 944058 | 2021-01-19 | Cherokee | Kansas | 20021 | 2046 | 16 |
940813 | 940813 | 2021-01-18 | Cherokee | Kansas | 20021 | 2046 | 16 |
937568 | 937568 | 2021-01-17 | Cherokee | Kansas | 20021 | 2032 | 16 |
934323 | 934323 | 2021-01-16 | Cherokee | Kansas | 20021 | 2032 | 16 |
931078 | 931078 | 2021-01-15 | Cherokee | Kansas | 20021 | 2032 | 16 |
927833 | 927833 | 2021-01-14 | Cherokee | Kansas | 20021 | 1997 | 16 |
924587 | 924587 | 2021-01-13 | Cherokee | Kansas | 20021 | 1997 | 16 |
921342 | 921342 | 2021-01-12 | Cherokee | Kansas | 20021 | 1959 | 16 |
918097 | 918097 | 2021-01-11 | Cherokee | Kansas | 20021 | 1959 | 16 |
914852 | 914852 | 2021-01-10 | Cherokee | Kansas | 20021 | 1912 | 16 |
911607 | 911607 | 2021-01-09 | Cherokee | Kansas | 20021 | 1912 | 16 |
908362 | 908362 | 2021-01-08 | Cherokee | Kansas | 20021 | 1912 | 16 |
905116 | 905116 | 2021-01-07 | Cherokee | Kansas | 20021 | 1859 | 16 |
901871 | 901871 | 2021-01-06 | Cherokee | Kansas | 20021 | 1859 | 16 |
898626 | 898626 | 2021-01-05 | Cherokee | Kansas | 20021 | 1812 | 16 |
895381 | 895381 | 2021-01-04 | Cherokee | Kansas | 20021 | 1812 | 16 |
892134 | 892134 | 2021-01-03 | Cherokee | Kansas | 20021 | 1764 | 16 |
888888 | 888888 | 2021-01-02 | Cherokee | Kansas | 20021 | 1764 | 16 |
885642 | 885642 | 2021-01-01 | Cherokee | Kansas | 20021 | 1764 | 16 |
882397 | 882397 | 2020-12-31 | Cherokee | Kansas | 20021 | 1709 | 16 |
879152 | 879152 | 2020-12-30 | Cherokee | Kansas | 20021 | 1709 | 16 |
875907 | 875907 | 2020-12-29 | Cherokee | Kansas | 20021 | 1656 | 16 |
872662 | 872662 | 2020-12-28 | Cherokee | Kansas | 20021 | 1656 | 16 |
869417 | 869417 | 2020-12-27 | Cherokee | Kansas | 20021 | 1604 | 15 |
866172 | 866172 | 2020-12-26 | Cherokee | Kansas | 20021 | 1604 | 15 |
862927 | 862927 | 2020-12-25 | Cherokee | Kansas | 20021 | 1604 | 15 |
859682 | 859682 | 2020-12-24 | Cherokee | Kansas | 20021 | 1604 | 15 |
856437 | 856437 | 2020-12-23 | Cherokee | Kansas | 20021 | 1604 | 15 |
853192 | 853192 | 2020-12-22 | Cherokee | Kansas | 20021 | 1561 | 13 |
849947 | 849947 | 2020-12-21 | Cherokee | Kansas | 20021 | 1561 | 13 |
846702 | 846702 | 2020-12-20 | Cherokee | Kansas | 20021 | 1530 | 13 |
843456 | 843456 | 2020-12-19 | Cherokee | Kansas | 20021 | 1530 | 13 |
840211 | 840211 | 2020-12-18 | Cherokee | Kansas | 20021 | 1530 | 13 |
836966 | 836966 | 2020-12-17 | Cherokee | Kansas | 20021 | 1481 | 13 |
833720 | 833720 | 2020-12-16 | Cherokee | Kansas | 20021 | 1481 | 13 |
830473 | 830473 | 2020-12-15 | Cherokee | Kansas | 20021 | 1443 | 13 |
827227 | 827227 | 2020-12-14 | Cherokee | Kansas | 20021 | 1443 | 13 |
823980 | 823980 | 2020-12-13 | Cherokee | Kansas | 20021 | 1409 | 12 |
820734 | 820734 | 2020-12-12 | Cherokee | Kansas | 20021 | 1409 | 12 |
817488 | 817488 | 2020-12-11 | Cherokee | Kansas | 20021 | 1409 | 12 |
814242 | 814242 | 2020-12-10 | Cherokee | Kansas | 20021 | 1374 | 11 |
810997 | 810997 | 2020-12-09 | Cherokee | Kansas | 20021 | 1338 | 10 |
807752 | 807752 | 2020-12-08 | Cherokee | Kansas | 20021 | 1281 | 10 |
804507 | 804507 | 2020-12-07 | Cherokee | Kansas | 20021 | 1281 | 10 |
801262 | 801262 | 2020-12-06 | Cherokee | Kansas | 20021 | 1240 | 10 |
798017 | 798017 | 2020-12-05 | Cherokee | Kansas | 20021 | 1240 | 10 |
794772 | 794772 | 2020-12-04 | Cherokee | Kansas | 20021 | 1240 | 10 |
791527 | 791527 | 2020-12-03 | Cherokee | Kansas | 20021 | 1206 | 10 |
788282 | 788282 | 2020-12-02 | Cherokee | Kansas | 20021 | 1206 | 10 |
785038 | 785038 | 2020-12-01 | Cherokee | Kansas | 20021 | 1151 | 10 |
781793 | 781793 | 2020-11-30 | Cherokee | Kansas | 20021 | 1151 | 10 |
778547 | 778547 | 2020-11-29 | Cherokee | Kansas | 20021 | 1124 | 10 |
775302 | 775302 | 2020-11-28 | Cherokee | Kansas | 20021 | 1124 | 10 |
772057 | 772057 | 2020-11-27 | Cherokee | Kansas | 20021 | 1124 | 10 |
768812 | 768812 | 2020-11-26 | Cherokee | Kansas | 20021 | 1093 | 9 |
765566 | 765566 | 2020-11-25 | Cherokee | Kansas | 20021 | 1093 | 9 |
762321 | 762321 | 2020-11-24 | Cherokee | Kansas | 20021 | 1070 | 9 |
759076 | 759076 | 2020-11-23 | Cherokee | Kansas | 20021 | 1070 | 9 |
755829 | 755829 | 2020-11-22 | Cherokee | Kansas | 20021 | 1042 | 9 |
752583 | 752583 | 2020-11-21 | Cherokee | Kansas | 20021 | 1042 | 9 |
749337 | 749337 | 2020-11-20 | Cherokee | Kansas | 20021 | 1023 | 9 |
746091 | 746091 | 2020-11-19 | Cherokee | Kansas | 20021 | 999 | 9 |
742844 | 742844 | 2020-11-18 | Cherokee | Kansas | 20021 | 999 | 9 |
739597 | 739597 | 2020-11-17 | Cherokee | Kansas | 20021 | 962 | 9 |
736353 | 736353 | 2020-11-16 | Cherokee | Kansas | 20021 | 931 | 9 |
733107 | 733107 | 2020-11-15 | Cherokee | Kansas | 20021 | 928 | 9 |
729862 | 729862 | 2020-11-14 | Cherokee | Kansas | 20021 | 928 | 9 |
726619 | 726619 | 2020-11-13 | Cherokee | Kansas | 20021 | 928 | 9 |
723376 | 723376 | 2020-11-12 | Cherokee | Kansas | 20021 | 859 | 8 |
720133 | 720133 | 2020-11-11 | Cherokee | Kansas | 20021 | 859 | 8 |
716890 | 716890 | 2020-11-10 | Cherokee | Kansas | 20021 | 823 | 8 |
713646 | 713646 | 2020-11-09 | Cherokee | Kansas | 20021 | 823 | 8 |
710402 | 710402 | 2020-11-08 | Cherokee | Kansas | 20021 | 810 | 8 |
707158 | 707158 | 2020-11-07 | Cherokee | Kansas | 20021 | 810 | 8 |
703915 | 703915 | 2020-11-06 | Cherokee | Kansas | 20021 | 810 | 8 |
700673 | 700673 | 2020-11-05 | Cherokee | Kansas | 20021 | 767 | 8 |
697429 | 697429 | 2020-11-04 | Cherokee | Kansas | 20021 | 767 | 8 |
694187 | 694187 | 2020-11-03 | Cherokee | Kansas | 20021 | 744 | 8 |
690944 | 690944 | 2020-11-02 | Cherokee | Kansas | 20021 | 744 | 8 |
687699 | 687699 | 2020-11-01 | Cherokee | Kansas | 20021 | 715 | 8 |
684455 | 684455 | 2020-10-31 | Cherokee | Kansas | 20021 | 715 | 8 |
681212 | 681212 | 2020-10-30 | Cherokee | Kansas | 20021 | 715 | 8 |
677969 | 677969 | 2020-10-29 | Cherokee | Kansas | 20021 | 694 | 8 |
674726 | 674726 | 2020-10-28 | Cherokee | Kansas | 20021 | 694 | 8 |
671484 | 671484 | 2020-10-27 | Cherokee | Kansas | 20021 | 676 | 8 |
668241 | 668241 | 2020-10-26 | Cherokee | Kansas | 20021 | 676 | 8 |
664997 | 664997 | 2020-10-25 | Cherokee | Kansas | 20021 | 655 | 8 |
661752 | 661752 | 2020-10-24 | Cherokee | Kansas | 20021 | 655 | 8 |
658508 | 658508 | 2020-10-23 | Cherokee | Kansas | 20021 | 655 | 8 |
655263 | 655263 | 2020-10-22 | Cherokee | Kansas | 20021 | 645 | 8 |
652018 | 652018 | 2020-10-21 | Cherokee | Kansas | 20021 | 645 | 8 |
648774 | 648774 | 2020-10-20 | Cherokee | Kansas | 20021 | 631 | 8 |
645529 | 645529 | 2020-10-19 | Cherokee | Kansas | 20021 | 631 | 8 |
642282 | 642282 | 2020-10-18 | Cherokee | Kansas | 20021 | 616 | 8 |
639035 | 639035 | 2020-10-17 | Cherokee | Kansas | 20021 | 616 | 8 |
635789 | 635789 | 2020-10-16 | Cherokee | Kansas | 20021 | 616 | 8 |
632543 | 632543 | 2020-10-15 | Cherokee | Kansas | 20021 | 601 | 8 |
629299 | 629299 | 2020-10-14 | Cherokee | Kansas | 20021 | 601 | 8 |
626056 | 626056 | 2020-10-13 | Cherokee | Kansas | 20021 | 585 | 8 |
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);