ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 20127 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947358 | 947358 | 2021-01-20 | Morris | Kansas | 20127 | 502 | 16 |
944111 | 944111 | 2021-01-19 | Morris | Kansas | 20127 | 502 | 16 |
940866 | 940866 | 2021-01-18 | Morris | Kansas | 20127 | 502 | 16 |
937621 | 937621 | 2021-01-17 | Morris | Kansas | 20127 | 478 | 6 |
934376 | 934376 | 2021-01-16 | Morris | Kansas | 20127 | 478 | 6 |
931131 | 931131 | 2021-01-15 | Morris | Kansas | 20127 | 478 | 6 |
927886 | 927886 | 2021-01-14 | Morris | Kansas | 20127 | 478 | 6 |
924640 | 924640 | 2021-01-13 | Morris | Kansas | 20127 | 478 | 6 |
921395 | 921395 | 2021-01-12 | Morris | Kansas | 20127 | 439 | 6 |
918150 | 918150 | 2021-01-11 | Morris | Kansas | 20127 | 439 | 6 |
914905 | 914905 | 2021-01-10 | Morris | Kansas | 20127 | 439 | 6 |
911660 | 911660 | 2021-01-09 | Morris | Kansas | 20127 | 439 | 6 |
908415 | 908415 | 2021-01-08 | Morris | Kansas | 20127 | 439 | 6 |
905169 | 905169 | 2021-01-07 | Morris | Kansas | 20127 | 439 | 6 |
901924 | 901924 | 2021-01-06 | Morris | Kansas | 20127 | 439 | 6 |
898679 | 898679 | 2021-01-05 | Morris | Kansas | 20127 | 439 | 6 |
895434 | 895434 | 2021-01-04 | Morris | Kansas | 20127 | 439 | 6 |
892187 | 892187 | 2021-01-03 | Morris | Kansas | 20127 | 404 | 4 |
888941 | 888941 | 2021-01-02 | Morris | Kansas | 20127 | 404 | 4 |
885695 | 885695 | 2021-01-01 | Morris | Kansas | 20127 | 404 | 4 |
882450 | 882450 | 2020-12-31 | Morris | Kansas | 20127 | 404 | 4 |
879205 | 879205 | 2020-12-30 | Morris | Kansas | 20127 | 404 | 4 |
875960 | 875960 | 2020-12-29 | Morris | Kansas | 20127 | 404 | 4 |
872715 | 872715 | 2020-12-28 | Morris | Kansas | 20127 | 373 | 2 |
869470 | 869470 | 2020-12-27 | Morris | Kansas | 20127 | 373 | 2 |
866225 | 866225 | 2020-12-26 | Morris | Kansas | 20127 | 373 | 2 |
862980 | 862980 | 2020-12-25 | Morris | Kansas | 20127 | 373 | 2 |
859735 | 859735 | 2020-12-24 | Morris | Kansas | 20127 | 373 | 2 |
856490 | 856490 | 2020-12-23 | Morris | Kansas | 20127 | 373 | 2 |
853245 | 853245 | 2020-12-22 | Morris | Kansas | 20127 | 373 | 2 |
850000 | 850000 | 2020-12-21 | Morris | Kansas | 20127 | 373 | 2 |
846755 | 846755 | 2020-12-20 | Morris | Kansas | 20127 | 339 | 2 |
843509 | 843509 | 2020-12-19 | Morris | Kansas | 20127 | 339 | 2 |
840264 | 840264 | 2020-12-18 | Morris | Kansas | 20127 | 339 | 2 |
837019 | 837019 | 2020-12-17 | Morris | Kansas | 20127 | 339 | 2 |
833773 | 833773 | 2020-12-16 | Morris | Kansas | 20127 | 339 | 1 |
830526 | 830526 | 2020-12-15 | Morris | Kansas | 20127 | 339 | 1 |
827280 | 827280 | 2020-12-14 | Morris | Kansas | 20127 | 299 | 1 |
824033 | 824033 | 2020-12-13 | Morris | Kansas | 20127 | 299 | 1 |
820787 | 820787 | 2020-12-12 | Morris | Kansas | 20127 | 299 | 1 |
817541 | 817541 | 2020-12-11 | Morris | Kansas | 20127 | 299 | 1 |
814295 | 814295 | 2020-12-10 | Morris | Kansas | 20127 | 299 | 1 |
811050 | 811050 | 2020-12-09 | Morris | Kansas | 20127 | 299 | 1 |
807805 | 807805 | 2020-12-08 | Morris | Kansas | 20127 | 299 | 1 |
804560 | 804560 | 2020-12-07 | Morris | Kansas | 20127 | 299 | 1 |
801315 | 801315 | 2020-12-06 | Morris | Kansas | 20127 | 220 | 1 |
798070 | 798070 | 2020-12-05 | Morris | Kansas | 20127 | 220 | 1 |
794825 | 794825 | 2020-12-04 | Morris | Kansas | 20127 | 220 | 1 |
791580 | 791580 | 2020-12-03 | Morris | Kansas | 20127 | 205 | 1 |
788335 | 788335 | 2020-12-02 | Morris | Kansas | 20127 | 205 | 1 |
785091 | 785091 | 2020-12-01 | Morris | Kansas | 20127 | 205 | 1 |
781846 | 781846 | 2020-11-30 | Morris | Kansas | 20127 | 205 | 1 |
778600 | 778600 | 2020-11-29 | Morris | Kansas | 20127 | 166 | 1 |
775355 | 775355 | 2020-11-28 | Morris | Kansas | 20127 | 166 | 1 |
772110 | 772110 | 2020-11-27 | Morris | Kansas | 20127 | 166 | 1 |
768865 | 768865 | 2020-11-26 | Morris | Kansas | 20127 | 163 | 1 |
765619 | 765619 | 2020-11-25 | Morris | Kansas | 20127 | 163 | 1 |
762374 | 762374 | 2020-11-24 | Morris | Kansas | 20127 | 163 | 1 |
759129 | 759129 | 2020-11-23 | Morris | Kansas | 20127 | 163 | 1 |
755882 | 755882 | 2020-11-22 | Morris | Kansas | 20127 | 147 | 1 |
752636 | 752636 | 2020-11-21 | Morris | Kansas | 20127 | 147 | 1 |
749390 | 749390 | 2020-11-20 | Morris | Kansas | 20127 | 147 | 1 |
746144 | 746144 | 2020-11-19 | Morris | Kansas | 20127 | 143 | 1 |
742897 | 742897 | 2020-11-18 | Morris | Kansas | 20127 | 143 | 1 |
739650 | 739650 | 2020-11-17 | Morris | Kansas | 20127 | 140 | 1 |
736406 | 736406 | 2020-11-16 | Morris | Kansas | 20127 | 140 | 1 |
733160 | 733160 | 2020-11-15 | Morris | Kansas | 20127 | 140 | 1 |
729915 | 729915 | 2020-11-14 | Morris | Kansas | 20127 | 140 | 1 |
726672 | 726672 | 2020-11-13 | Morris | Kansas | 20127 | 123 | 1 |
723429 | 723429 | 2020-11-12 | Morris | Kansas | 20127 | 123 | 1 |
720186 | 720186 | 2020-11-11 | Morris | Kansas | 20127 | 123 | 1 |
716943 | 716943 | 2020-11-10 | Morris | Kansas | 20127 | 97 | 0 |
713699 | 713699 | 2020-11-09 | Morris | Kansas | 20127 | 97 | 0 |
710455 | 710455 | 2020-11-08 | Morris | Kansas | 20127 | 91 | 0 |
707211 | 707211 | 2020-11-07 | Morris | Kansas | 20127 | 91 | 0 |
703968 | 703968 | 2020-11-06 | Morris | Kansas | 20127 | 91 | 0 |
700726 | 700726 | 2020-11-05 | Morris | Kansas | 20127 | 82 | 0 |
697482 | 697482 | 2020-11-04 | Morris | Kansas | 20127 | 82 | 0 |
694240 | 694240 | 2020-11-03 | Morris | Kansas | 20127 | 81 | 0 |
690997 | 690997 | 2020-11-02 | Morris | Kansas | 20127 | 81 | 0 |
687752 | 687752 | 2020-11-01 | Morris | Kansas | 20127 | 69 | 0 |
684508 | 684508 | 2020-10-31 | Morris | Kansas | 20127 | 69 | 0 |
681265 | 681265 | 2020-10-30 | Morris | Kansas | 20127 | 69 | 0 |
678022 | 678022 | 2020-10-29 | Morris | Kansas | 20127 | 64 | 0 |
674779 | 674779 | 2020-10-28 | Morris | Kansas | 20127 | 64 | 0 |
671537 | 671537 | 2020-10-27 | Morris | Kansas | 20127 | 60 | 0 |
668294 | 668294 | 2020-10-26 | Morris | Kansas | 20127 | 60 | 0 |
665050 | 665050 | 2020-10-25 | Morris | Kansas | 20127 | 56 | 0 |
661805 | 661805 | 2020-10-24 | Morris | Kansas | 20127 | 56 | 0 |
658561 | 658561 | 2020-10-23 | Morris | Kansas | 20127 | 56 | 0 |
655316 | 655316 | 2020-10-22 | Morris | Kansas | 20127 | 55 | 0 |
652071 | 652071 | 2020-10-21 | Morris | Kansas | 20127 | 55 | 0 |
648827 | 648827 | 2020-10-20 | Morris | Kansas | 20127 | 53 | 0 |
645582 | 645582 | 2020-10-19 | Morris | Kansas | 20127 | 53 | 0 |
642335 | 642335 | 2020-10-18 | Morris | Kansas | 20127 | 52 | 0 |
639088 | 639088 | 2020-10-17 | Morris | Kansas | 20127 | 52 | 0 |
635842 | 635842 | 2020-10-16 | Morris | Kansas | 20127 | 52 | 0 |
632596 | 632596 | 2020-10-15 | Morris | Kansas | 20127 | 50 | 0 |
629352 | 629352 | 2020-10-14 | Morris | Kansas | 20127 | 50 | 0 |
626109 | 626109 | 2020-10-13 | Morris | Kansas | 20127 | 48 | 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);