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 |
---|---|---|---|---|---|---|---|
1054443 | 1054443 | 2021-02-22 | Jackson | Kansas | 20085 | 1328 | 11 |
1051196 | 1051196 | 2021-02-21 | Jackson | Kansas | 20085 | 1327 | 11 |
1047949 | 1047949 | 2021-02-20 | Jackson | Kansas | 20085 | 1327 | 11 |
1044704 | 1044704 | 2021-02-19 | Jackson | Kansas | 20085 | 1327 | 11 |
1041459 | 1041459 | 2021-02-18 | Jackson | Kansas | 20085 | 1324 | 11 |
1038214 | 1038214 | 2021-02-17 | Jackson | Kansas | 20085 | 1324 | 11 |
1034969 | 1034969 | 2021-02-16 | Jackson | Kansas | 20085 | 1316 | 11 |
1031723 | 1031723 | 2021-02-15 | Jackson | Kansas | 20085 | 1316 | 11 |
1028476 | 1028476 | 2021-02-14 | Jackson | Kansas | 20085 | 1312 | 11 |
1025231 | 1025231 | 2021-02-13 | Jackson | Kansas | 20085 | 1312 | 11 |
1021986 | 1021986 | 2021-02-12 | Jackson | Kansas | 20085 | 1312 | 11 |
1018741 | 1018741 | 2021-02-11 | Jackson | Kansas | 20085 | 1303 | 11 |
1015496 | 1015496 | 2021-02-10 | Jackson | Kansas | 20085 | 1303 | 11 |
1012251 | 1012251 | 2021-02-09 | Jackson | Kansas | 20085 | 1290 | 11 |
1009005 | 1009005 | 2021-02-08 | Jackson | Kansas | 20085 | 1290 | 11 |
1005759 | 1005759 | 2021-02-07 | Jackson | Kansas | 20085 | 1284 | 11 |
1002513 | 1002513 | 2021-02-06 | Jackson | Kansas | 20085 | 1284 | 11 |
999267 | 999267 | 2021-02-05 | Jackson | Kansas | 20085 | 1284 | 11 |
996021 | 996021 | 2021-02-04 | Jackson | Kansas | 20085 | 1274 | 11 |
992775 | 992775 | 2021-02-03 | Jackson | Kansas | 20085 | 1274 | 11 |
989529 | 989529 | 2021-02-02 | Jackson | Kansas | 20085 | 1264 | 11 |
986282 | 986282 | 2021-02-01 | Jackson | Kansas | 20085 | 1264 | 11 |
983035 | 983035 | 2021-01-31 | Jackson | Kansas | 20085 | 1259 | 11 |
979789 | 979789 | 2021-01-30 | Jackson | Kansas | 20085 | 1259 | 11 |
976543 | 976543 | 2021-01-29 | Jackson | Kansas | 20085 | 1259 | 11 |
973298 | 973298 | 2021-01-28 | Jackson | Kansas | 20085 | 1248 | 11 |
970053 | 970053 | 2021-01-27 | Jackson | Kansas | 20085 | 1248 | 11 |
966809 | 966809 | 2021-01-26 | Jackson | Kansas | 20085 | 1236 | 11 |
963564 | 963564 | 2021-01-25 | Jackson | Kansas | 20085 | 1236 | 10 |
960319 | 960319 | 2021-01-24 | Jackson | Kansas | 20085 | 1234 | 10 |
957073 | 957073 | 2021-01-23 | Jackson | Kansas | 20085 | 1234 | 10 |
953828 | 953828 | 2021-01-22 | Jackson | Kansas | 20085 | 1234 | 10 |
950583 | 950583 | 2021-01-21 | Jackson | Kansas | 20085 | 1219 | 10 |
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 |
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);