ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Cherokee" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054411 | 1054411 | 2021-02-22 | Cherokee | Kansas | 20021 | 2338 | 16 |
1051164 | 1051164 | 2021-02-21 | Cherokee | Kansas | 20021 | 2333 | 16 |
1047917 | 1047917 | 2021-02-20 | Cherokee | Kansas | 20021 | 2333 | 16 |
1044672 | 1044672 | 2021-02-19 | Cherokee | Kansas | 20021 | 2333 | 16 |
1041427 | 1041427 | 2021-02-18 | Cherokee | Kansas | 20021 | 2330 | 16 |
1038182 | 1038182 | 2021-02-17 | Cherokee | Kansas | 20021 | 2330 | 16 |
1034937 | 1034937 | 2021-02-16 | Cherokee | Kansas | 20021 | 2316 | 16 |
1031691 | 1031691 | 2021-02-15 | Cherokee | Kansas | 20021 | 2316 | 16 |
1028444 | 1028444 | 2021-02-14 | Cherokee | Kansas | 20021 | 2303 | 16 |
1025199 | 1025199 | 2021-02-13 | Cherokee | Kansas | 20021 | 2303 | 16 |
1021954 | 1021954 | 2021-02-12 | Cherokee | Kansas | 20021 | 2303 | 16 |
1018709 | 1018709 | 2021-02-11 | Cherokee | Kansas | 20021 | 2289 | 16 |
1015464 | 1015464 | 2021-02-10 | Cherokee | Kansas | 20021 | 2289 | 16 |
1012219 | 1012219 | 2021-02-09 | Cherokee | Kansas | 20021 | 2271 | 16 |
1008973 | 1008973 | 2021-02-08 | Cherokee | Kansas | 20021 | 2271 | 16 |
1005727 | 1005727 | 2021-02-07 | Cherokee | Kansas | 20021 | 2258 | 16 |
1002481 | 1002481 | 2021-02-06 | Cherokee | Kansas | 20021 | 2258 | 16 |
999235 | 999235 | 2021-02-05 | Cherokee | Kansas | 20021 | 2258 | 16 |
995989 | 995989 | 2021-02-04 | Cherokee | Kansas | 20021 | 2237 | 16 |
992743 | 992743 | 2021-02-03 | Cherokee | Kansas | 20021 | 2237 | 16 |
989497 | 989497 | 2021-02-02 | Cherokee | Kansas | 20021 | 2209 | 16 |
986250 | 986250 | 2021-02-01 | Cherokee | Kansas | 20021 | 2209 | 16 |
983003 | 983003 | 2021-01-31 | Cherokee | Kansas | 20021 | 2191 | 16 |
979757 | 979757 | 2021-01-30 | Cherokee | Kansas | 20021 | 2191 | 16 |
976511 | 976511 | 2021-01-29 | Cherokee | Kansas | 20021 | 2191 | 16 |
973266 | 973266 | 2021-01-28 | Cherokee | Kansas | 20021 | 2170 | 16 |
970021 | 970021 | 2021-01-27 | Cherokee | Kansas | 20021 | 2170 | 16 |
966777 | 966777 | 2021-01-26 | Cherokee | Kansas | 20021 | 2123 | 16 |
963532 | 963532 | 2021-01-25 | Cherokee | Kansas | 20021 | 2123 | 16 |
960287 | 960287 | 2021-01-24 | Cherokee | Kansas | 20021 | 2103 | 16 |
957041 | 957041 | 2021-01-23 | Cherokee | Kansas | 20021 | 2103 | 16 |
953796 | 953796 | 2021-01-22 | Cherokee | Kansas | 20021 | 2103 | 16 |
950551 | 950551 | 2021-01-21 | Cherokee | Kansas | 20021 | 2073 | 16 |
947305 | 947305 | 2021-01-20 | Cherokee | Kansas | 20021 | 2073 | 16 |
944058 | 944058 | 2021-01-19 | Cherokee | Kansas | 20021 | 2046 | 16 |
940813 | 940813 | 2021-01-18 | Cherokee | Kansas | 20021 | 2046 | 16 |
937568 | 937568 | 2021-01-17 | Cherokee | Kansas | 20021 | 2032 | 16 |
934323 | 934323 | 2021-01-16 | Cherokee | Kansas | 20021 | 2032 | 16 |
931078 | 931078 | 2021-01-15 | Cherokee | Kansas | 20021 | 2032 | 16 |
927833 | 927833 | 2021-01-14 | Cherokee | Kansas | 20021 | 1997 | 16 |
924587 | 924587 | 2021-01-13 | Cherokee | Kansas | 20021 | 1997 | 16 |
921342 | 921342 | 2021-01-12 | Cherokee | Kansas | 20021 | 1959 | 16 |
918097 | 918097 | 2021-01-11 | Cherokee | Kansas | 20021 | 1959 | 16 |
914852 | 914852 | 2021-01-10 | Cherokee | Kansas | 20021 | 1912 | 16 |
911607 | 911607 | 2021-01-09 | Cherokee | Kansas | 20021 | 1912 | 16 |
908362 | 908362 | 2021-01-08 | Cherokee | Kansas | 20021 | 1912 | 16 |
905116 | 905116 | 2021-01-07 | Cherokee | Kansas | 20021 | 1859 | 16 |
901871 | 901871 | 2021-01-06 | Cherokee | Kansas | 20021 | 1859 | 16 |
898626 | 898626 | 2021-01-05 | Cherokee | Kansas | 20021 | 1812 | 16 |
895381 | 895381 | 2021-01-04 | Cherokee | Kansas | 20021 | 1812 | 16 |
892134 | 892134 | 2021-01-03 | Cherokee | Kansas | 20021 | 1764 | 16 |
888888 | 888888 | 2021-01-02 | Cherokee | Kansas | 20021 | 1764 | 16 |
885642 | 885642 | 2021-01-01 | Cherokee | Kansas | 20021 | 1764 | 16 |
882397 | 882397 | 2020-12-31 | Cherokee | Kansas | 20021 | 1709 | 16 |
879152 | 879152 | 2020-12-30 | Cherokee | Kansas | 20021 | 1709 | 16 |
875907 | 875907 | 2020-12-29 | Cherokee | Kansas | 20021 | 1656 | 16 |
872662 | 872662 | 2020-12-28 | Cherokee | Kansas | 20021 | 1656 | 16 |
869417 | 869417 | 2020-12-27 | Cherokee | Kansas | 20021 | 1604 | 15 |
866172 | 866172 | 2020-12-26 | Cherokee | Kansas | 20021 | 1604 | 15 |
862927 | 862927 | 2020-12-25 | Cherokee | Kansas | 20021 | 1604 | 15 |
859682 | 859682 | 2020-12-24 | Cherokee | Kansas | 20021 | 1604 | 15 |
856437 | 856437 | 2020-12-23 | Cherokee | Kansas | 20021 | 1604 | 15 |
853192 | 853192 | 2020-12-22 | Cherokee | Kansas | 20021 | 1561 | 13 |
849947 | 849947 | 2020-12-21 | Cherokee | Kansas | 20021 | 1561 | 13 |
846702 | 846702 | 2020-12-20 | Cherokee | Kansas | 20021 | 1530 | 13 |
843456 | 843456 | 2020-12-19 | Cherokee | Kansas | 20021 | 1530 | 13 |
840211 | 840211 | 2020-12-18 | Cherokee | Kansas | 20021 | 1530 | 13 |
836966 | 836966 | 2020-12-17 | Cherokee | Kansas | 20021 | 1481 | 13 |
833720 | 833720 | 2020-12-16 | Cherokee | Kansas | 20021 | 1481 | 13 |
830473 | 830473 | 2020-12-15 | Cherokee | Kansas | 20021 | 1443 | 13 |
827227 | 827227 | 2020-12-14 | Cherokee | Kansas | 20021 | 1443 | 13 |
823980 | 823980 | 2020-12-13 | Cherokee | Kansas | 20021 | 1409 | 12 |
820734 | 820734 | 2020-12-12 | Cherokee | Kansas | 20021 | 1409 | 12 |
817488 | 817488 | 2020-12-11 | Cherokee | Kansas | 20021 | 1409 | 12 |
814242 | 814242 | 2020-12-10 | Cherokee | Kansas | 20021 | 1374 | 11 |
810997 | 810997 | 2020-12-09 | Cherokee | Kansas | 20021 | 1338 | 10 |
807752 | 807752 | 2020-12-08 | Cherokee | Kansas | 20021 | 1281 | 10 |
804507 | 804507 | 2020-12-07 | Cherokee | Kansas | 20021 | 1281 | 10 |
801262 | 801262 | 2020-12-06 | Cherokee | Kansas | 20021 | 1240 | 10 |
798017 | 798017 | 2020-12-05 | Cherokee | Kansas | 20021 | 1240 | 10 |
794772 | 794772 | 2020-12-04 | Cherokee | Kansas | 20021 | 1240 | 10 |
791527 | 791527 | 2020-12-03 | Cherokee | Kansas | 20021 | 1206 | 10 |
788282 | 788282 | 2020-12-02 | Cherokee | Kansas | 20021 | 1206 | 10 |
785038 | 785038 | 2020-12-01 | Cherokee | Kansas | 20021 | 1151 | 10 |
781793 | 781793 | 2020-11-30 | Cherokee | Kansas | 20021 | 1151 | 10 |
778547 | 778547 | 2020-11-29 | Cherokee | Kansas | 20021 | 1124 | 10 |
775302 | 775302 | 2020-11-28 | Cherokee | Kansas | 20021 | 1124 | 10 |
772057 | 772057 | 2020-11-27 | Cherokee | Kansas | 20021 | 1124 | 10 |
768812 | 768812 | 2020-11-26 | Cherokee | Kansas | 20021 | 1093 | 9 |
765566 | 765566 | 2020-11-25 | Cherokee | Kansas | 20021 | 1093 | 9 |
762321 | 762321 | 2020-11-24 | Cherokee | Kansas | 20021 | 1070 | 9 |
759076 | 759076 | 2020-11-23 | Cherokee | Kansas | 20021 | 1070 | 9 |
755829 | 755829 | 2020-11-22 | Cherokee | Kansas | 20021 | 1042 | 9 |
752583 | 752583 | 2020-11-21 | Cherokee | Kansas | 20021 | 1042 | 9 |
749337 | 749337 | 2020-11-20 | Cherokee | Kansas | 20021 | 1023 | 9 |
746091 | 746091 | 2020-11-19 | Cherokee | Kansas | 20021 | 999 | 9 |
742844 | 742844 | 2020-11-18 | Cherokee | Kansas | 20021 | 999 | 9 |
739597 | 739597 | 2020-11-17 | Cherokee | Kansas | 20021 | 962 | 9 |
736353 | 736353 | 2020-11-16 | Cherokee | Kansas | 20021 | 931 | 9 |
733107 | 733107 | 2020-11-15 | Cherokee | Kansas | 20021 | 928 | 9 |
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);