ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 20085 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947337 | 947337 | 2021-01-20 | Jackson | Kansas | 20085 | 1219 | 10 |
944090 | 944090 | 2021-01-19 | Jackson | Kansas | 20085 | 1204 | 10 |
940845 | 940845 | 2021-01-18 | Jackson | Kansas | 20085 | 1204 | 10 |
937600 | 937600 | 2021-01-17 | Jackson | Kansas | 20085 | 1194 | 10 |
934355 | 934355 | 2021-01-16 | Jackson | Kansas | 20085 | 1194 | 10 |
931110 | 931110 | 2021-01-15 | Jackson | Kansas | 20085 | 1194 | 10 |
927865 | 927865 | 2021-01-14 | Jackson | Kansas | 20085 | 1183 | 10 |
924619 | 924619 | 2021-01-13 | Jackson | Kansas | 20085 | 1183 | 10 |
921374 | 921374 | 2021-01-12 | Jackson | Kansas | 20085 | 1160 | 10 |
918129 | 918129 | 2021-01-11 | Jackson | Kansas | 20085 | 1160 | 10 |
914884 | 914884 | 2021-01-10 | Jackson | Kansas | 20085 | 1126 | 10 |
911639 | 911639 | 2021-01-09 | Jackson | Kansas | 20085 | 1126 | 10 |
908394 | 908394 | 2021-01-08 | Jackson | Kansas | 20085 | 1126 | 10 |
905148 | 905148 | 2021-01-07 | Jackson | Kansas | 20085 | 1094 | 10 |
901903 | 901903 | 2021-01-06 | Jackson | Kansas | 20085 | 1094 | 10 |
898658 | 898658 | 2021-01-05 | Jackson | Kansas | 20085 | 1051 | 10 |
895413 | 895413 | 2021-01-04 | Jackson | Kansas | 20085 | 1051 | 10 |
892166 | 892166 | 2021-01-03 | Jackson | Kansas | 20085 | 1039 | 10 |
888920 | 888920 | 2021-01-02 | Jackson | Kansas | 20085 | 1039 | 10 |
885674 | 885674 | 2021-01-01 | Jackson | Kansas | 20085 | 1039 | 10 |
882429 | 882429 | 2020-12-31 | Jackson | Kansas | 20085 | 1018 | 10 |
879184 | 879184 | 2020-12-30 | Jackson | Kansas | 20085 | 1018 | 10 |
875939 | 875939 | 2020-12-29 | Jackson | Kansas | 20085 | 1001 | 10 |
872694 | 872694 | 2020-12-28 | Jackson | Kansas | 20085 | 1001 | 10 |
869449 | 869449 | 2020-12-27 | Jackson | Kansas | 20085 | 991 | 10 |
866204 | 866204 | 2020-12-26 | Jackson | Kansas | 20085 | 991 | 10 |
862959 | 862959 | 2020-12-25 | Jackson | Kansas | 20085 | 991 | 10 |
859714 | 859714 | 2020-12-24 | Jackson | Kansas | 20085 | 991 | 10 |
856469 | 856469 | 2020-12-23 | Jackson | Kansas | 20085 | 991 | 10 |
853224 | 853224 | 2020-12-22 | Jackson | Kansas | 20085 | 979 | 10 |
849979 | 849979 | 2020-12-21 | Jackson | Kansas | 20085 | 979 | 10 |
846734 | 846734 | 2020-12-20 | Jackson | Kansas | 20085 | 962 | 10 |
843488 | 843488 | 2020-12-19 | Jackson | Kansas | 20085 | 962 | 10 |
840243 | 840243 | 2020-12-18 | Jackson | Kansas | 20085 | 962 | 10 |
836998 | 836998 | 2020-12-17 | Jackson | Kansas | 20085 | 916 | 10 |
833752 | 833752 | 2020-12-16 | Jackson | Kansas | 20085 | 916 | 10 |
830505 | 830505 | 2020-12-15 | Jackson | Kansas | 20085 | 888 | 10 |
827259 | 827259 | 2020-12-14 | Jackson | Kansas | 20085 | 888 | 10 |
824012 | 824012 | 2020-12-13 | Jackson | Kansas | 20085 | 853 | 10 |
820766 | 820766 | 2020-12-12 | Jackson | Kansas | 20085 | 853 | 10 |
817520 | 817520 | 2020-12-11 | Jackson | Kansas | 20085 | 853 | 10 |
814274 | 814274 | 2020-12-10 | Jackson | Kansas | 20085 | 837 | 10 |
811029 | 811029 | 2020-12-09 | Jackson | Kansas | 20085 | 824 | 10 |
807784 | 807784 | 2020-12-08 | Jackson | Kansas | 20085 | 784 | 10 |
804539 | 804539 | 2020-12-07 | Jackson | Kansas | 20085 | 784 | 10 |
801294 | 801294 | 2020-12-06 | Jackson | Kansas | 20085 | 762 | 9 |
798049 | 798049 | 2020-12-05 | Jackson | Kansas | 20085 | 762 | 9 |
794804 | 794804 | 2020-12-04 | Jackson | Kansas | 20085 | 762 | 9 |
791559 | 791559 | 2020-12-03 | Jackson | Kansas | 20085 | 735 | 9 |
788314 | 788314 | 2020-12-02 | Jackson | Kansas | 20085 | 735 | 9 |
785070 | 785070 | 2020-12-01 | Jackson | Kansas | 20085 | 697 | 4 |
781825 | 781825 | 2020-11-30 | Jackson | Kansas | 20085 | 697 | 4 |
778579 | 778579 | 2020-11-29 | Jackson | Kansas | 20085 | 682 | 4 |
775334 | 775334 | 2020-11-28 | Jackson | Kansas | 20085 | 682 | 4 |
772089 | 772089 | 2020-11-27 | Jackson | Kansas | 20085 | 682 | 4 |
768844 | 768844 | 2020-11-26 | Jackson | Kansas | 20085 | 653 | 4 |
765598 | 765598 | 2020-11-25 | Jackson | Kansas | 20085 | 653 | 4 |
762353 | 762353 | 2020-11-24 | Jackson | Kansas | 20085 | 629 | 4 |
759108 | 759108 | 2020-11-23 | Jackson | Kansas | 20085 | 629 | 4 |
755861 | 755861 | 2020-11-22 | Jackson | Kansas | 20085 | 573 | 4 |
752615 | 752615 | 2020-11-21 | Jackson | Kansas | 20085 | 573 | 4 |
749369 | 749369 | 2020-11-20 | Jackson | Kansas | 20085 | 573 | 4 |
746123 | 746123 | 2020-11-19 | Jackson | Kansas | 20085 | 539 | 4 |
742876 | 742876 | 2020-11-18 | Jackson | Kansas | 20085 | 539 | 4 |
739629 | 739629 | 2020-11-17 | Jackson | Kansas | 20085 | 515 | 4 |
736385 | 736385 | 2020-11-16 | Jackson | Kansas | 20085 | 515 | 4 |
733139 | 733139 | 2020-11-15 | Jackson | Kansas | 20085 | 487 | 4 |
729894 | 729894 | 2020-11-14 | Jackson | Kansas | 20085 | 487 | 4 |
726651 | 726651 | 2020-11-13 | Jackson | Kansas | 20085 | 487 | 4 |
723408 | 723408 | 2020-11-12 | Jackson | Kansas | 20085 | 450 | 4 |
720165 | 720165 | 2020-11-11 | Jackson | Kansas | 20085 | 450 | 4 |
716922 | 716922 | 2020-11-10 | Jackson | Kansas | 20085 | 422 | 4 |
713678 | 713678 | 2020-11-09 | Jackson | Kansas | 20085 | 422 | 4 |
710434 | 710434 | 2020-11-08 | Jackson | Kansas | 20085 | 401 | 4 |
707190 | 707190 | 2020-11-07 | Jackson | Kansas | 20085 | 401 | 4 |
703947 | 703947 | 2020-11-06 | Jackson | Kansas | 20085 | 398 | 4 |
700705 | 700705 | 2020-11-05 | Jackson | Kansas | 20085 | 371 | 4 |
697461 | 697461 | 2020-11-04 | Jackson | Kansas | 20085 | 371 | 4 |
694219 | 694219 | 2020-11-03 | Jackson | Kansas | 20085 | 360 | 4 |
690976 | 690976 | 2020-11-02 | Jackson | Kansas | 20085 | 360 | 4 |
687731 | 687731 | 2020-11-01 | Jackson | Kansas | 20085 | 352 | 4 |
684487 | 684487 | 2020-10-31 | Jackson | Kansas | 20085 | 352 | 4 |
681244 | 681244 | 2020-10-30 | Jackson | Kansas | 20085 | 352 | 4 |
678001 | 678001 | 2020-10-29 | Jackson | Kansas | 20085 | 329 | 4 |
674758 | 674758 | 2020-10-28 | Jackson | Kansas | 20085 | 329 | 4 |
671516 | 671516 | 2020-10-27 | Jackson | Kansas | 20085 | 320 | 4 |
668273 | 668273 | 2020-10-26 | Jackson | Kansas | 20085 | 319 | 4 |
665029 | 665029 | 2020-10-25 | Jackson | Kansas | 20085 | 312 | 4 |
661784 | 661784 | 2020-10-24 | Jackson | Kansas | 20085 | 312 | 4 |
658540 | 658540 | 2020-10-23 | Jackson | Kansas | 20085 | 312 | 4 |
655295 | 655295 | 2020-10-22 | Jackson | Kansas | 20085 | 306 | 4 |
652050 | 652050 | 2020-10-21 | Jackson | Kansas | 20085 | 298 | 4 |
648806 | 648806 | 2020-10-20 | Jackson | Kansas | 20085 | 291 | 4 |
645561 | 645561 | 2020-10-19 | Jackson | Kansas | 20085 | 291 | 4 |
642314 | 642314 | 2020-10-18 | Jackson | Kansas | 20085 | 286 | 4 |
639067 | 639067 | 2020-10-17 | Jackson | Kansas | 20085 | 286 | 4 |
635821 | 635821 | 2020-10-16 | Jackson | Kansas | 20085 | 286 | 4 |
632575 | 632575 | 2020-10-15 | Jackson | Kansas | 20085 | 279 | 3 |
629331 | 629331 | 2020-10-14 | Jackson | Kansas | 20085 | 279 | 3 |
626088 | 626088 | 2020-10-13 | Jackson | Kansas | 20085 | 275 | 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);