ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
687 rows where fips = 20049 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947319 | 947319 | 2021-01-20 | Elk | Kansas | 20049 | 151 | 0 |
944072 | 944072 | 2021-01-19 | Elk | Kansas | 20049 | 149 | 0 |
940827 | 940827 | 2021-01-18 | Elk | Kansas | 20049 | 149 | 0 |
937582 | 937582 | 2021-01-17 | Elk | Kansas | 20049 | 148 | 0 |
934337 | 934337 | 2021-01-16 | Elk | Kansas | 20049 | 148 | 0 |
931092 | 931092 | 2021-01-15 | Elk | Kansas | 20049 | 148 | 0 |
927847 | 927847 | 2021-01-14 | Elk | Kansas | 20049 | 144 | 0 |
924601 | 924601 | 2021-01-13 | Elk | Kansas | 20049 | 144 | 0 |
921356 | 921356 | 2021-01-12 | Elk | Kansas | 20049 | 136 | 0 |
918111 | 918111 | 2021-01-11 | Elk | Kansas | 20049 | 136 | 0 |
914866 | 914866 | 2021-01-10 | Elk | Kansas | 20049 | 136 | 0 |
911621 | 911621 | 2021-01-09 | Elk | Kansas | 20049 | 136 | 0 |
908376 | 908376 | 2021-01-08 | Elk | Kansas | 20049 | 136 | 0 |
905130 | 905130 | 2021-01-07 | Elk | Kansas | 20049 | 126 | 0 |
901885 | 901885 | 2021-01-06 | Elk | Kansas | 20049 | 126 | 0 |
898640 | 898640 | 2021-01-05 | Elk | Kansas | 20049 | 115 | 0 |
895395 | 895395 | 2021-01-04 | Elk | Kansas | 20049 | 115 | 0 |
892148 | 892148 | 2021-01-03 | Elk | Kansas | 20049 | 114 | 0 |
888902 | 888902 | 2021-01-02 | Elk | Kansas | 20049 | 114 | 0 |
885656 | 885656 | 2021-01-01 | Elk | Kansas | 20049 | 114 | 0 |
882411 | 882411 | 2020-12-31 | Elk | Kansas | 20049 | 106 | 0 |
879166 | 879166 | 2020-12-30 | Elk | Kansas | 20049 | 106 | 0 |
875921 | 875921 | 2020-12-29 | Elk | Kansas | 20049 | 98 | 0 |
872676 | 872676 | 2020-12-28 | Elk | Kansas | 20049 | 98 | 0 |
869431 | 869431 | 2020-12-27 | Elk | Kansas | 20049 | 96 | 0 |
866186 | 866186 | 2020-12-26 | Elk | Kansas | 20049 | 96 | 0 |
862941 | 862941 | 2020-12-25 | Elk | Kansas | 20049 | 96 | 0 |
859696 | 859696 | 2020-12-24 | Elk | Kansas | 20049 | 96 | 0 |
856451 | 856451 | 2020-12-23 | Elk | Kansas | 20049 | 96 | 0 |
853206 | 853206 | 2020-12-22 | Elk | Kansas | 20049 | 90 | 0 |
849961 | 849961 | 2020-12-21 | Elk | Kansas | 20049 | 90 | 0 |
846716 | 846716 | 2020-12-20 | Elk | Kansas | 20049 | 87 | 0 |
843470 | 843470 | 2020-12-19 | Elk | Kansas | 20049 | 87 | 0 |
840225 | 840225 | 2020-12-18 | Elk | Kansas | 20049 | 87 | 0 |
836980 | 836980 | 2020-12-17 | Elk | Kansas | 20049 | 84 | 0 |
833734 | 833734 | 2020-12-16 | Elk | Kansas | 20049 | 84 | 0 |
830487 | 830487 | 2020-12-15 | Elk | Kansas | 20049 | 77 | 0 |
827241 | 827241 | 2020-12-14 | Elk | Kansas | 20049 | 77 | 0 |
823994 | 823994 | 2020-12-13 | Elk | Kansas | 20049 | 71 | 0 |
820748 | 820748 | 2020-12-12 | Elk | Kansas | 20049 | 71 | 0 |
817502 | 817502 | 2020-12-11 | Elk | Kansas | 20049 | 71 | 0 |
814256 | 814256 | 2020-12-10 | Elk | Kansas | 20049 | 66 | 0 |
811011 | 811011 | 2020-12-09 | Elk | Kansas | 20049 | 66 | 0 |
807766 | 807766 | 2020-12-08 | Elk | Kansas | 20049 | 63 | 0 |
804521 | 804521 | 2020-12-07 | Elk | Kansas | 20049 | 63 | 0 |
801276 | 801276 | 2020-12-06 | Elk | Kansas | 20049 | 63 | 0 |
798031 | 798031 | 2020-12-05 | Elk | Kansas | 20049 | 63 | 0 |
794786 | 794786 | 2020-12-04 | Elk | Kansas | 20049 | 63 | 0 |
791541 | 791541 | 2020-12-03 | Elk | Kansas | 20049 | 62 | 0 |
788296 | 788296 | 2020-12-02 | Elk | Kansas | 20049 | 62 | 0 |
785052 | 785052 | 2020-12-01 | Elk | Kansas | 20049 | 58 | 0 |
781807 | 781807 | 2020-11-30 | Elk | Kansas | 20049 | 58 | 0 |
778561 | 778561 | 2020-11-29 | Elk | Kansas | 20049 | 54 | 0 |
775316 | 775316 | 2020-11-28 | Elk | Kansas | 20049 | 54 | 0 |
772071 | 772071 | 2020-11-27 | Elk | Kansas | 20049 | 54 | 0 |
768826 | 768826 | 2020-11-26 | Elk | Kansas | 20049 | 51 | 0 |
765580 | 765580 | 2020-11-25 | Elk | Kansas | 20049 | 51 | 0 |
762335 | 762335 | 2020-11-24 | Elk | Kansas | 20049 | 47 | 0 |
759090 | 759090 | 2020-11-23 | Elk | Kansas | 20049 | 47 | 0 |
755843 | 755843 | 2020-11-22 | Elk | Kansas | 20049 | 40 | 0 |
752597 | 752597 | 2020-11-21 | Elk | Kansas | 20049 | 40 | 0 |
749351 | 749351 | 2020-11-20 | Elk | Kansas | 20049 | 40 | 0 |
746105 | 746105 | 2020-11-19 | Elk | Kansas | 20049 | 36 | 0 |
742858 | 742858 | 2020-11-18 | Elk | Kansas | 20049 | 36 | 0 |
739611 | 739611 | 2020-11-17 | Elk | Kansas | 20049 | 33 | 0 |
736367 | 736367 | 2020-11-16 | Elk | Kansas | 20049 | 33 | 0 |
733121 | 733121 | 2020-11-15 | Elk | Kansas | 20049 | 29 | 0 |
729876 | 729876 | 2020-11-14 | Elk | Kansas | 20049 | 29 | 0 |
726633 | 726633 | 2020-11-13 | Elk | Kansas | 20049 | 29 | 0 |
723390 | 723390 | 2020-11-12 | Elk | Kansas | 20049 | 28 | 0 |
720147 | 720147 | 2020-11-11 | Elk | Kansas | 20049 | 28 | 0 |
716904 | 716904 | 2020-11-10 | Elk | Kansas | 20049 | 23 | 0 |
713660 | 713660 | 2020-11-09 | Elk | Kansas | 20049 | 23 | 0 |
710416 | 710416 | 2020-11-08 | Elk | Kansas | 20049 | 20 | 0 |
707172 | 707172 | 2020-11-07 | Elk | Kansas | 20049 | 20 | 0 |
703929 | 703929 | 2020-11-06 | Elk | Kansas | 20049 | 20 | 0 |
700687 | 700687 | 2020-11-05 | Elk | Kansas | 20049 | 17 | 0 |
697443 | 697443 | 2020-11-04 | Elk | Kansas | 20049 | 17 | 0 |
694201 | 694201 | 2020-11-03 | Elk | Kansas | 20049 | 16 | 0 |
690958 | 690958 | 2020-11-02 | Elk | Kansas | 20049 | 16 | 0 |
687713 | 687713 | 2020-11-01 | Elk | Kansas | 20049 | 15 | 0 |
684469 | 684469 | 2020-10-31 | Elk | Kansas | 20049 | 15 | 0 |
681226 | 681226 | 2020-10-30 | Elk | Kansas | 20049 | 15 | 0 |
677983 | 677983 | 2020-10-29 | Elk | Kansas | 20049 | 15 | 0 |
674740 | 674740 | 2020-10-28 | Elk | Kansas | 20049 | 15 | 0 |
671498 | 671498 | 2020-10-27 | Elk | Kansas | 20049 | 15 | 0 |
668255 | 668255 | 2020-10-26 | Elk | Kansas | 20049 | 15 | 0 |
665011 | 665011 | 2020-10-25 | Elk | Kansas | 20049 | 15 | 0 |
661766 | 661766 | 2020-10-24 | Elk | Kansas | 20049 | 15 | 0 |
658522 | 658522 | 2020-10-23 | Elk | Kansas | 20049 | 15 | 0 |
655277 | 655277 | 2020-10-22 | Elk | Kansas | 20049 | 15 | 0 |
652032 | 652032 | 2020-10-21 | Elk | Kansas | 20049 | 15 | 0 |
648788 | 648788 | 2020-10-20 | Elk | Kansas | 20049 | 14 | 0 |
645543 | 645543 | 2020-10-19 | Elk | Kansas | 20049 | 14 | 0 |
642296 | 642296 | 2020-10-18 | Elk | Kansas | 20049 | 13 | 0 |
639049 | 639049 | 2020-10-17 | Elk | Kansas | 20049 | 13 | 0 |
635803 | 635803 | 2020-10-16 | Elk | Kansas | 20049 | 13 | 0 |
632557 | 632557 | 2020-10-15 | Elk | Kansas | 20049 | 13 | 0 |
629313 | 629313 | 2020-10-14 | Elk | Kansas | 20049 | 13 | 0 |
626070 | 626070 | 2020-10-13 | Elk | Kansas | 20049 | 12 | 0 |
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);