ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Franklin" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947324 | 947324 | 2021-01-20 | Franklin | Kansas | 20059 | 2162 | 19 |
944077 | 944077 | 2021-01-19 | Franklin | Kansas | 20059 | 2102 | 19 |
940832 | 940832 | 2021-01-18 | Franklin | Kansas | 20059 | 2102 | 19 |
937587 | 937587 | 2021-01-17 | Franklin | Kansas | 20059 | 2072 | 19 |
934342 | 934342 | 2021-01-16 | Franklin | Kansas | 20059 | 2072 | 19 |
931097 | 931097 | 2021-01-15 | Franklin | Kansas | 20059 | 2072 | 19 |
927852 | 927852 | 2021-01-14 | Franklin | Kansas | 20059 | 2059 | 19 |
924606 | 924606 | 2021-01-13 | Franklin | Kansas | 20059 | 2059 | 19 |
921361 | 921361 | 2021-01-12 | Franklin | Kansas | 20059 | 2038 | 19 |
918116 | 918116 | 2021-01-11 | Franklin | Kansas | 20059 | 2038 | 19 |
914871 | 914871 | 2021-01-10 | Franklin | Kansas | 20059 | 2001 | 19 |
911626 | 911626 | 2021-01-09 | Franklin | Kansas | 20059 | 2001 | 19 |
908381 | 908381 | 2021-01-08 | Franklin | Kansas | 20059 | 2001 | 19 |
905135 | 905135 | 2021-01-07 | Franklin | Kansas | 20059 | 1942 | 18 |
901890 | 901890 | 2021-01-06 | Franklin | Kansas | 20059 | 1942 | 18 |
898645 | 898645 | 2021-01-05 | Franklin | Kansas | 20059 | 1883 | 18 |
895400 | 895400 | 2021-01-04 | Franklin | Kansas | 20059 | 1883 | 18 |
892153 | 892153 | 2021-01-03 | Franklin | Kansas | 20059 | 1835 | 18 |
888907 | 888907 | 2021-01-02 | Franklin | Kansas | 20059 | 1835 | 18 |
885661 | 885661 | 2021-01-01 | Franklin | Kansas | 20059 | 1835 | 18 |
882416 | 882416 | 2020-12-31 | Franklin | Kansas | 20059 | 1757 | 18 |
879171 | 879171 | 2020-12-30 | Franklin | Kansas | 20059 | 1757 | 18 |
875926 | 875926 | 2020-12-29 | Franklin | Kansas | 20059 | 1703 | 18 |
872681 | 872681 | 2020-12-28 | Franklin | Kansas | 20059 | 1703 | 18 |
869436 | 869436 | 2020-12-27 | Franklin | Kansas | 20059 | 1594 | 18 |
866191 | 866191 | 2020-12-26 | Franklin | Kansas | 20059 | 1594 | 18 |
862946 | 862946 | 2020-12-25 | Franklin | Kansas | 20059 | 1594 | 18 |
859701 | 859701 | 2020-12-24 | Franklin | Kansas | 20059 | 1594 | 18 |
856456 | 856456 | 2020-12-23 | Franklin | Kansas | 20059 | 1594 | 18 |
853211 | 853211 | 2020-12-22 | Franklin | Kansas | 20059 | 1534 | 17 |
849966 | 849966 | 2020-12-21 | Franklin | Kansas | 20059 | 1534 | 17 |
846721 | 846721 | 2020-12-20 | Franklin | Kansas | 20059 | 1486 | 17 |
843475 | 843475 | 2020-12-19 | Franklin | Kansas | 20059 | 1486 | 17 |
840230 | 840230 | 2020-12-18 | Franklin | Kansas | 20059 | 1486 | 17 |
836985 | 836985 | 2020-12-17 | Franklin | Kansas | 20059 | 1453 | 17 |
833739 | 833739 | 2020-12-16 | Franklin | Kansas | 20059 | 1453 | 17 |
830492 | 830492 | 2020-12-15 | Franklin | Kansas | 20059 | 1412 | 17 |
827246 | 827246 | 2020-12-14 | Franklin | Kansas | 20059 | 1412 | 17 |
823999 | 823999 | 2020-12-13 | Franklin | Kansas | 20059 | 1363 | 17 |
820753 | 820753 | 2020-12-12 | Franklin | Kansas | 20059 | 1363 | 17 |
817507 | 817507 | 2020-12-11 | Franklin | Kansas | 20059 | 1363 | 17 |
814261 | 814261 | 2020-12-10 | Franklin | Kansas | 20059 | 1310 | 17 |
811016 | 811016 | 2020-12-09 | Franklin | Kansas | 20059 | 1310 | 17 |
807771 | 807771 | 2020-12-08 | Franklin | Kansas | 20059 | 1270 | 17 |
804526 | 804526 | 2020-12-07 | Franklin | Kansas | 20059 | 1270 | 17 |
801281 | 801281 | 2020-12-06 | Franklin | Kansas | 20059 | 1178 | 17 |
798036 | 798036 | 2020-12-05 | Franklin | Kansas | 20059 | 1178 | 17 |
794791 | 794791 | 2020-12-04 | Franklin | Kansas | 20059 | 1178 | 17 |
791546 | 791546 | 2020-12-03 | Franklin | Kansas | 20059 | 1146 | 17 |
788301 | 788301 | 2020-12-02 | Franklin | Kansas | 20059 | 1146 | 17 |
785057 | 785057 | 2020-12-01 | Franklin | Kansas | 20059 | 1115 | 16 |
781812 | 781812 | 2020-11-30 | Franklin | Kansas | 20059 | 1115 | 16 |
778566 | 778566 | 2020-11-29 | Franklin | Kansas | 20059 | 1093 | 15 |
775321 | 775321 | 2020-11-28 | Franklin | Kansas | 20059 | 1093 | 15 |
772076 | 772076 | 2020-11-27 | Franklin | Kansas | 20059 | 1093 | 15 |
768831 | 768831 | 2020-11-26 | Franklin | Kansas | 20059 | 1048 | 15 |
765585 | 765585 | 2020-11-25 | Franklin | Kansas | 20059 | 1048 | 15 |
762340 | 762340 | 2020-11-24 | Franklin | Kansas | 20059 | 1022 | 15 |
759095 | 759095 | 2020-11-23 | Franklin | Kansas | 20059 | 1022 | 15 |
755848 | 755848 | 2020-11-22 | Franklin | Kansas | 20059 | 949 | 14 |
752602 | 752602 | 2020-11-21 | Franklin | Kansas | 20059 | 949 | 14 |
749356 | 749356 | 2020-11-20 | Franklin | Kansas | 20059 | 949 | 14 |
746110 | 746110 | 2020-11-19 | Franklin | Kansas | 20059 | 919 | 13 |
742863 | 742863 | 2020-11-18 | Franklin | Kansas | 20059 | 919 | 13 |
739616 | 739616 | 2020-11-17 | Franklin | Kansas | 20059 | 887 | 13 |
736372 | 736372 | 2020-11-16 | Franklin | Kansas | 20059 | 887 | 13 |
733126 | 733126 | 2020-11-15 | Franklin | Kansas | 20059 | 824 | 8 |
729881 | 729881 | 2020-11-14 | Franklin | Kansas | 20059 | 824 | 8 |
726638 | 726638 | 2020-11-13 | Franklin | Kansas | 20059 | 824 | 8 |
723395 | 723395 | 2020-11-12 | Franklin | Kansas | 20059 | 790 | 8 |
720152 | 720152 | 2020-11-11 | Franklin | Kansas | 20059 | 790 | 8 |
716909 | 716909 | 2020-11-10 | Franklin | Kansas | 20059 | 761 | 8 |
713665 | 713665 | 2020-11-09 | Franklin | Kansas | 20059 | 761 | 8 |
710421 | 710421 | 2020-11-08 | Franklin | Kansas | 20059 | 679 | 7 |
707177 | 707177 | 2020-11-07 | Franklin | Kansas | 20059 | 679 | 7 |
703934 | 703934 | 2020-11-06 | Franklin | Kansas | 20059 | 679 | 7 |
700692 | 700692 | 2020-11-05 | Franklin | Kansas | 20059 | 648 | 5 |
697448 | 697448 | 2020-11-04 | Franklin | Kansas | 20059 | 648 | 5 |
694206 | 694206 | 2020-11-03 | Franklin | Kansas | 20059 | 621 | 5 |
690963 | 690963 | 2020-11-02 | Franklin | Kansas | 20059 | 621 | 5 |
687718 | 687718 | 2020-11-01 | Franklin | Kansas | 20059 | 594 | 5 |
684474 | 684474 | 2020-10-31 | Franklin | Kansas | 20059 | 594 | 5 |
681231 | 681231 | 2020-10-30 | Franklin | Kansas | 20059 | 594 | 5 |
677988 | 677988 | 2020-10-29 | Franklin | Kansas | 20059 | 561 | 5 |
674745 | 674745 | 2020-10-28 | Franklin | Kansas | 20059 | 561 | 5 |
671503 | 671503 | 2020-10-27 | Franklin | Kansas | 20059 | 533 | 3 |
668260 | 668260 | 2020-10-26 | Franklin | Kansas | 20059 | 526 | 3 |
665016 | 665016 | 2020-10-25 | Franklin | Kansas | 20059 | 524 | 3 |
661771 | 661771 | 2020-10-24 | Franklin | Kansas | 20059 | 524 | 3 |
658527 | 658527 | 2020-10-23 | Franklin | Kansas | 20059 | 524 | 3 |
655282 | 655282 | 2020-10-22 | Franklin | Kansas | 20059 | 508 | 3 |
652037 | 652037 | 2020-10-21 | Franklin | Kansas | 20059 | 508 | 3 |
648793 | 648793 | 2020-10-20 | Franklin | Kansas | 20059 | 500 | 3 |
645548 | 645548 | 2020-10-19 | Franklin | Kansas | 20059 | 500 | 3 |
642301 | 642301 | 2020-10-18 | Franklin | Kansas | 20059 | 486 | 3 |
639054 | 639054 | 2020-10-17 | Franklin | Kansas | 20059 | 486 | 3 |
635808 | 635808 | 2020-10-16 | Franklin | Kansas | 20059 | 486 | 3 |
632562 | 632562 | 2020-10-15 | Franklin | Kansas | 20059 | 473 | 3 |
629318 | 629318 | 2020-10-14 | Franklin | Kansas | 20059 | 473 | 3 |
626075 | 626075 | 2020-10-13 | Franklin | Kansas | 20059 | 469 | 3 |
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);