ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where date = "2020-09-30" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
583901 | 583901 | 2020-09-30 | Allen | Kansas | 20001 | 82 | 1 |
583902 | 583902 | 2020-09-30 | Anderson | Kansas | 20003 | 85 | 0 |
583903 | 583903 | 2020-09-30 | Atchison | Kansas | 20005 | 331 | 2 |
583904 | 583904 | 2020-09-30 | Barber | Kansas | 20007 | 9 | 0 |
583905 | 583905 | 2020-09-30 | Barton | Kansas | 20009 | 507 | 7 |
583906 | 583906 | 2020-09-30 | Bourbon | Kansas | 20011 | 194 | 3 |
583907 | 583907 | 2020-09-30 | Brown | Kansas | 20013 | 137 | 3 |
583908 | 583908 | 2020-09-30 | Butler | Kansas | 20015 | 985 | 4 |
583909 | 583909 | 2020-09-30 | Chase | Kansas | 20017 | 83 | 1 |
583910 | 583910 | 2020-09-30 | Chautauqua | Kansas | 20019 | 19 | 0 |
583911 | 583911 | 2020-09-30 | Cherokee | Kansas | 20021 | 520 | 8 |
583912 | 583912 | 2020-09-30 | Cheyenne | Kansas | 20023 | 68 | 0 |
583913 | 583913 | 2020-09-30 | Clark | Kansas | 20025 | 52 | 1 |
583914 | 583914 | 2020-09-30 | Clay | Kansas | 20027 | 52 | 2 |
583915 | 583915 | 2020-09-30 | Cloud | Kansas | 20029 | 71 | 1 |
583916 | 583916 | 2020-09-30 | Coffey | Kansas | 20031 | 124 | 8 |
583917 | 583917 | 2020-09-30 | Comanche | Kansas | 20033 | 12 | 0 |
583918 | 583918 | 2020-09-30 | Cowley | Kansas | 20035 | 401 | 5 |
583919 | 583919 | 2020-09-30 | Crawford | Kansas | 20037 | 1098 | 8 |
583920 | 583920 | 2020-09-30 | Decatur | Kansas | 20039 | 26 | 1 |
583921 | 583921 | 2020-09-30 | Dickinson | Kansas | 20041 | 208 | 1 |
583922 | 583922 | 2020-09-30 | Doniphan | Kansas | 20043 | 114 | 0 |
583923 | 583923 | 2020-09-30 | Douglas | Kansas | 20045 | 2340 | 13 |
583924 | 583924 | 2020-09-30 | Edwards | Kansas | 20047 | 51 | 0 |
583925 | 583925 | 2020-09-30 | Elk | Kansas | 20049 | 6 | 0 |
583926 | 583926 | 2020-09-30 | Ellis | Kansas | 20051 | 1038 | 5 |
583927 | 583927 | 2020-09-30 | Ellsworth | Kansas | 20053 | 58 | 0 |
583928 | 583928 | 2020-09-30 | Finney | Kansas | 20055 | 2169 | 12 |
583929 | 583929 | 2020-09-30 | Ford | Kansas | 20057 | 2902 | 10 |
583930 | 583930 | 2020-09-30 | Franklin | Kansas | 20059 | 393 | 3 |
583931 | 583931 | 2020-09-30 | Geary | Kansas | 20061 | 427 | 2 |
583932 | 583932 | 2020-09-30 | Gove | Kansas | 20063 | 76 | 0 |
583933 | 583933 | 2020-09-30 | Graham | Kansas | 20065 | 36 | 1 |
583934 | 583934 | 2020-09-30 | Grant | Kansas | 20067 | 305 | 5 |
583935 | 583935 | 2020-09-30 | Gray | Kansas | 20069 | 127 | 0 |
583936 | 583936 | 2020-09-30 | Greeley | Kansas | 20071 | 9 | 0 |
583937 | 583937 | 2020-09-30 | Greenwood | Kansas | 20073 | 49 | 0 |
583938 | 583938 | 2020-09-30 | Hamilton | Kansas | 20075 | 46 | 0 |
583939 | 583939 | 2020-09-30 | Harper | Kansas | 20077 | 120 | 2 |
583940 | 583940 | 2020-09-30 | Harvey | Kansas | 20079 | 361 | 8 |
583941 | 583941 | 2020-09-30 | Haskell | Kansas | 20081 | 126 | 1 |
583942 | 583942 | 2020-09-30 | Hodgeman | Kansas | 20083 | 24 | 0 |
583943 | 583943 | 2020-09-30 | Jackson | Kansas | 20085 | 247 | 2 |
583944 | 583944 | 2020-09-30 | Jefferson | Kansas | 20087 | 198 | 4 |
583945 | 583945 | 2020-09-30 | Jewell | Kansas | 20089 | 17 | 1 |
583946 | 583946 | 2020-09-30 | Johnson | Kansas | 20091 | 11575 | 154 |
583947 | 583947 | 2020-09-30 | Kearny | Kansas | 20093 | 100 | 1 |
583948 | 583948 | 2020-09-30 | Kingman | Kansas | 20095 | 100 | 1 |
583949 | 583949 | 2020-09-30 | Kiowa | Kansas | 20097 | 28 | 0 |
583950 | 583950 | 2020-09-30 | Labette | Kansas | 20099 | 246 | 4 |
583951 | 583951 | 2020-09-30 | Lane | Kansas | 20101 | 14 | 0 |
583952 | 583952 | 2020-09-30 | Leavenworth | Kansas | 20103 | 2258 | 11 |
583953 | 583953 | 2020-09-30 | Lincoln | Kansas | 20105 | 14 | 0 |
583954 | 583954 | 2020-09-30 | Linn | Kansas | 20107 | 83 | 0 |
583955 | 583955 | 2020-09-30 | Logan | Kansas | 20109 | 29 | 0 |
583956 | 583956 | 2020-09-30 | Lyon | Kansas | 20111 | 1080 | 35 |
583957 | 583957 | 2020-09-30 | Marion | Kansas | 20115 | 102 | 1 |
583958 | 583958 | 2020-09-30 | Marshall | Kansas | 20117 | 30 | 0 |
583959 | 583959 | 2020-09-30 | McPherson | Kansas | 20113 | 270 | 1 |
583960 | 583960 | 2020-09-30 | Meade | Kansas | 20119 | 136 | 1 |
583961 | 583961 | 2020-09-30 | Miami | Kansas | 20121 | 412 | 1 |
583962 | 583962 | 2020-09-30 | Mitchell | Kansas | 20123 | 46 | 0 |
583963 | 583963 | 2020-09-30 | Montgomery | Kansas | 20125 | 435 | 6 |
583964 | 583964 | 2020-09-30 | Morris | Kansas | 20127 | 41 | 0 |
583965 | 583965 | 2020-09-30 | Morton | Kansas | 20129 | 17 | 2 |
583966 | 583966 | 2020-09-30 | Nemaha | Kansas | 20131 | 128 | 1 |
583967 | 583967 | 2020-09-30 | Neosho | Kansas | 20133 | 179 | 0 |
583968 | 583968 | 2020-09-30 | Ness | Kansas | 20135 | 92 | 6 |
583969 | 583969 | 2020-09-30 | Norton | Kansas | 20137 | 35 | 0 |
583970 | 583970 | 2020-09-30 | Osage | Kansas | 20139 | 114 | 0 |
583971 | 583971 | 2020-09-30 | Osborne | Kansas | 20141 | 11 | 0 |
583972 | 583972 | 2020-09-30 | Ottawa | Kansas | 20143 | 58 | 0 |
583973 | 583973 | 2020-09-30 | Pawnee | Kansas | 20145 | 385 | 0 |
583974 | 583974 | 2020-09-30 | Phillips | Kansas | 20147 | 122 | 8 |
583975 | 583975 | 2020-09-30 | Pottawatomie | Kansas | 20149 | 278 | 0 |
583976 | 583976 | 2020-09-30 | Pratt | Kansas | 20151 | 77 | 0 |
583977 | 583977 | 2020-09-30 | Rawlins | Kansas | 20153 | 68 | 0 |
583978 | 583978 | 2020-09-30 | Reno | Kansas | 20155 | 1155 | 4 |
583979 | 583979 | 2020-09-30 | Republic | Kansas | 20157 | 49 | 1 |
583980 | 583980 | 2020-09-30 | Rice | Kansas | 20159 | 84 | 1 |
583981 | 583981 | 2020-09-30 | Riley | Kansas | 20161 | 1857 | 8 |
583982 | 583982 | 2020-09-30 | Rooks | Kansas | 20163 | 99 | 0 |
583983 | 583983 | 2020-09-30 | Rush | Kansas | 20165 | 66 | 0 |
583984 | 583984 | 2020-09-30 | Russell | Kansas | 20167 | 100 | 1 |
583985 | 583985 | 2020-09-30 | Saline | Kansas | 20169 | 783 | 11 |
583986 | 583986 | 2020-09-30 | Scott | Kansas | 20171 | 129 | 1 |
583987 | 583987 | 2020-09-30 | Sedgwick | Kansas | 20173 | 9102 | 93 |
583988 | 583988 | 2020-09-30 | Seward | Kansas | 20175 | 1699 | 5 |
583989 | 583989 | 2020-09-30 | Shawnee | Kansas | 20177 | 2804 | 32 |
583990 | 583990 | 2020-09-30 | Sheridan | Kansas | 20179 | 28 | 0 |
583991 | 583991 | 2020-09-30 | Sherman | Kansas | 20181 | 42 | 0 |
583992 | 583992 | 2020-09-30 | Smith | Kansas | 20183 | 8 | 0 |
583993 | 583993 | 2020-09-30 | Stafford | Kansas | 20185 | 59 | 1 |
583994 | 583994 | 2020-09-30 | Stanton | Kansas | 20187 | 67 | 2 |
583995 | 583995 | 2020-09-30 | Stevens | Kansas | 20189 | 161 | 1 |
583996 | 583996 | 2020-09-30 | Sumner | Kansas | 20191 | 208 | 3 |
583997 | 583997 | 2020-09-30 | Thomas | Kansas | 20193 | 165 | 0 |
583998 | 583998 | 2020-09-30 | Trego | Kansas | 20195 | 58 | 3 |
583999 | 583999 | 2020-09-30 | Unknown | Kansas | 0 | 16 | |
584000 | 584000 | 2020-09-30 | Wabaunsee | Kansas | 20197 | 72 | 1 |
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);