ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79,294 rows where state = "Kansas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 20091 798
- 20209 793
- 20015 792
- 20059 791
- 20045 788
- 20057 788
- 20103 787
- 20021 786
- 20107 786
- 20127 786
- 20173 786
- 20155 785
- 20161 785
- 20085 783
- 20123 783
- 20011 782
- 20111 782
- 20043 781
- 20149 781
- 20207 781
- 20037 780
- 20133 780
- 20177 780
- 20087 779
- 20191 779
- 20027 778
- 20031 778
- 20063 778
- 20079 778
- 20113 778
- …
county >30
- Johnson 798
- Wyandotte 793
- Butler 792
- Franklin 791
- Douglas 788
- Ford 788
- Leavenworth 787
- Cherokee 786
- Linn 786
- Morris 786
- Sedgwick 786
- Reno 785
- Riley 785
- Jackson 783
- Mitchell 783
- Bourbon 782
- Lyon 782
- Doniphan 781
- Pottawatomie 781
- Woodson 781
- Crawford 780
- Neosho 780
- Shawnee 780
- Jefferson 779
- Sumner 779
- Clay 778
- Coffey 778
- Gove 778
- Harvey 778
- McPherson 778
- …
state 1
- Kansas · 79,194 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
875995 | 875995 | 2020-12-29 | Unknown | Kansas | 0 | 293 | |
879240 | 879240 | 2020-12-30 | Unknown | Kansas | 0 | 444 | |
882485 | 882485 | 2020-12-31 | Unknown | Kansas | 0 | 408 | |
885730 | 885730 | 2021-01-01 | Unknown | Kansas | 0 | 506 | |
888976 | 888976 | 2021-01-02 | Unknown | Kansas | 0 | 505 | |
892222 | 892222 | 2021-01-03 | Unknown | Kansas | 0 | 505 | |
895469 | 895469 | 2021-01-04 | Unknown | Kansas | 0 | 473 | |
898714 | 898714 | 2021-01-05 | Unknown | Kansas | 0 | 435 | |
901959 | 901959 | 2021-01-06 | Unknown | Kansas | 0 | 512 | |
905204 | 905204 | 2021-01-07 | Unknown | Kansas | 0 | 474 | |
908450 | 908450 | 2021-01-08 | Unknown | Kansas | 0 | 572 | |
911695 | 911695 | 2021-01-09 | Unknown | Kansas | 0 | 552 | |
914940 | 914940 | 2021-01-10 | Unknown | Kansas | 0 | 550 | |
918185 | 918185 | 2021-01-11 | Unknown | Kansas | 0 | 628 | |
921430 | 921430 | 2021-01-12 | Unknown | Kansas | 0 | 584 | |
924675 | 924675 | 2021-01-13 | Unknown | Kansas | 0 | 638 | |
927921 | 927921 | 2021-01-14 | Unknown | Kansas | 0 | 620 | |
931166 | 931166 | 2021-01-15 | Unknown | Kansas | 0 | 734 | |
934411 | 934411 | 2021-01-16 | Unknown | Kansas | 0 | 716 | |
937656 | 937656 | 2021-01-17 | Unknown | Kansas | 0 | 713 | |
940901 | 940901 | 2021-01-18 | Unknown | Kansas | 0 | 720 | |
944146 | 944146 | 2021-01-19 | Unknown | Kansas | 0 | 710 | |
947393 | 947393 | 2021-01-20 | Unknown | Kansas | 0 | 725 | |
950639 | 950639 | 2021-01-21 | Unknown | Kansas | 0 | 699 | |
953884 | 953884 | 2021-01-22 | Unknown | Kansas | 0 | 708 | |
957129 | 957129 | 2021-01-23 | Unknown | Kansas | 0 | 701 | |
960375 | 960375 | 2021-01-24 | Unknown | Kansas | 0 | 699 | |
963620 | 963620 | 2021-01-25 | Unknown | Kansas | 0 | 709 | |
966865 | 966865 | 2021-01-26 | Unknown | Kansas | 0 | 684 | |
970109 | 970109 | 2021-01-27 | Unknown | Kansas | 0 | 749 | |
973354 | 973354 | 2021-01-28 | Unknown | Kansas | 0 | 699 | |
976599 | 976599 | 2021-01-29 | Unknown | Kansas | 0 | 731 | |
979845 | 979845 | 2021-01-30 | Unknown | Kansas | 0 | 727 | |
983091 | 983091 | 2021-01-31 | Unknown | Kansas | 0 | 725 | |
986338 | 986338 | 2021-02-01 | Unknown | Kansas | 0 | 742 | |
989585 | 989585 | 2021-02-02 | Unknown | Kansas | 0 | 716 | |
992831 | 992831 | 2021-02-03 | Unknown | Kansas | 0 | 756 | |
996077 | 996077 | 2021-02-04 | Unknown | Kansas | 0 | 724 | |
999323 | 999323 | 2021-02-05 | Unknown | Kansas | 0 | 885 | |
1002569 | 1002569 | 2021-02-06 | Unknown | Kansas | 0 | 881 | |
1005815 | 1005815 | 2021-02-07 | Unknown | Kansas | 0 | 881 | |
1009061 | 1009061 | 2021-02-08 | Unknown | Kansas | 0 | 949 | |
1012307 | 1012307 | 2021-02-09 | Unknown | Kansas | 0 | 894 | |
1015552 | 1015552 | 2021-02-10 | Unknown | Kansas | 0 | 970 | |
1018797 | 1018797 | 2021-02-11 | Unknown | Kansas | 0 | 933 | |
1022042 | 1022042 | 2021-02-12 | Unknown | Kansas | 0 | 977 | |
1025287 | 1025287 | 2021-02-13 | Unknown | Kansas | 0 | 966 | |
1028532 | 1028532 | 2021-02-14 | Unknown | Kansas | 0 | 966 | |
1031779 | 1031779 | 2021-02-15 | Unknown | Kansas | 0 | 1004 | |
1035025 | 1035025 | 2021-02-16 | Unknown | Kansas | 0 | 987 | |
1038270 | 1038270 | 2021-02-17 | Unknown | Kansas | 0 | 1077 | |
1041515 | 1041515 | 2021-02-18 | Unknown | Kansas | 0 | 1016 | |
1044760 | 1044760 | 2021-02-19 | Unknown | Kansas | 0 | 1086 | |
1048005 | 1048005 | 2021-02-20 | Unknown | Kansas | 0 | 1072 | |
1051252 | 1051252 | 2021-02-21 | Unknown | Kansas | 0 | 1072 | |
1054499 | 1054499 | 2021-02-22 | Unknown | Kansas | 0 | 1069 | |
1057745 | 1057745 | 2021-02-23 | Unknown | Kansas | 0 | 1040 | |
1060991 | 1060991 | 2021-02-24 | Unknown | Kansas | 0 | 1092 | |
1064236 | 1064236 | 2021-02-25 | Unknown | Kansas | 0 | 1080 | |
1067481 | 1067481 | 2021-02-26 | Unknown | Kansas | 0 | 1062 | |
1070726 | 1070726 | 2021-02-27 | Unknown | Kansas | 0 | 1062 | |
1073972 | 1073972 | 2021-02-28 | Unknown | Kansas | 0 | 1062 | |
1077218 | 1077218 | 2021-03-01 | Unknown | Kansas | 0 | 1063 | |
1080463 | 1080463 | 2021-03-02 | Unknown | Kansas | 0 | 1050 | |
1083709 | 1083709 | 2021-03-03 | Unknown | Kansas | 0 | 1107 | |
1086955 | 1086955 | 2021-03-04 | Unknown | Kansas | 0 | 1080 | |
1090200 | 1090200 | 2021-03-05 | Unknown | Kansas | 0 | 1082 | |
1093446 | 1093446 | 2021-03-06 | Unknown | Kansas | 0 | 1081 | |
1096692 | 1096692 | 2021-03-07 | Unknown | Kansas | 0 | 1081 | |
1099940 | 1099940 | 2021-03-08 | Unknown | Kansas | 0 | 1079 | |
1103186 | 1103186 | 2021-03-09 | Unknown | Kansas | 0 | 1070 | |
1106432 | 1106432 | 2021-03-10 | Unknown | Kansas | 0 | 1083 | |
1109678 | 1109678 | 2021-03-11 | Unknown | Kansas | 0 | 1057 | |
1112924 | 1112924 | 2021-03-12 | Unknown | Kansas | 0 | 1025 | |
1116170 | 1116170 | 2021-03-13 | Unknown | Kansas | 0 | 1025 | |
1119417 | 1119417 | 2021-03-14 | Unknown | Kansas | 0 | 1025 | |
1122664 | 1122664 | 2021-03-15 | Unknown | Kansas | 0 | 1021 | |
1125910 | 1125910 | 2021-03-16 | Unknown | Kansas | 0 | 1011 | |
1129156 | 1129156 | 2021-03-17 | Unknown | Kansas | 0 | 1008 | |
1132404 | 1132404 | 2021-03-18 | Unknown | Kansas | 0 | 1000 | |
1135651 | 1135651 | 2021-03-19 | Unknown | Kansas | 0 | 999 | |
1138897 | 1138897 | 2021-03-20 | Unknown | Kansas | 0 | 999 | |
1142143 | 1142143 | 2021-03-21 | Unknown | Kansas | 0 | 1005 | |
1145390 | 1145390 | 2021-03-22 | Unknown | Kansas | 0 | 1008 | |
1148637 | 1148637 | 2021-03-23 | Unknown | Kansas | 0 | 996 | |
1151884 | 1151884 | 2021-03-24 | Unknown | Kansas | 0 | 1024 | |
1155131 | 1155131 | 2021-03-25 | Unknown | Kansas | 0 | 1014 | |
1158378 | 1158378 | 2021-03-26 | Unknown | Kansas | 0 | 1021 | |
1161626 | 1161626 | 2021-03-27 | Unknown | Kansas | 0 | 1021 | |
1164874 | 1164874 | 2021-03-28 | Unknown | Kansas | 0 | 1010 | |
1168122 | 1168122 | 2021-03-29 | Unknown | Kansas | 0 | 1014 | |
1171370 | 1171370 | 2021-03-30 | Unknown | Kansas | 0 | 1014 | |
1174617 | 1174617 | 2021-03-31 | Unknown | Kansas | 0 | 1017 | |
1177864 | 1177864 | 2021-04-01 | Unknown | Kansas | 0 | 1013 | |
1181111 | 1181111 | 2021-04-02 | Unknown | Kansas | 0 | 1022 | |
1184358 | 1184358 | 2021-04-03 | Unknown | Kansas | 0 | 1022 | |
1187605 | 1187605 | 2021-04-04 | Unknown | Kansas | 0 | 1022 | |
1190852 | 1190852 | 2021-04-05 | Unknown | Kansas | 0 | 1020 | |
1194102 | 1194102 | 2021-04-06 | Unknown | Kansas | 0 | 1016 | |
1197350 | 1197350 | 2021-04-07 | Unknown | Kansas | 0 | 1016 |
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);