ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where "date" is on date 2020-10-04 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
596865 | 596865 | 2020-10-04 | Allen | Kansas | 20001 | 82 | 1 |
596866 | 596866 | 2020-10-04 | Anderson | Kansas | 20003 | 85 | 0 |
596867 | 596867 | 2020-10-04 | Atchison | Kansas | 20005 | 366 | 3 |
596868 | 596868 | 2020-10-04 | Barber | Kansas | 20007 | 11 | 0 |
596869 | 596869 | 2020-10-04 | Barton | Kansas | 20009 | 536 | 7 |
596870 | 596870 | 2020-10-04 | Bourbon | Kansas | 20011 | 194 | 3 |
596871 | 596871 | 2020-10-04 | Brown | Kansas | 20013 | 145 | 5 |
596872 | 596872 | 2020-10-04 | Butler | Kansas | 20015 | 1012 | 4 |
596873 | 596873 | 2020-10-04 | Chase | Kansas | 20017 | 83 | 1 |
596874 | 596874 | 2020-10-04 | Chautauqua | Kansas | 20019 | 21 | 0 |
596875 | 596875 | 2020-10-04 | Cherokee | Kansas | 20021 | 535 | 8 |
596876 | 596876 | 2020-10-04 | Cheyenne | Kansas | 20023 | 72 | 2 |
596877 | 596877 | 2020-10-04 | Clark | Kansas | 20025 | 55 | 1 |
596878 | 596878 | 2020-10-04 | Clay | Kansas | 20027 | 62 | 2 |
596879 | 596879 | 2020-10-04 | Cloud | Kansas | 20029 | 74 | 1 |
596880 | 596880 | 2020-10-04 | Coffey | Kansas | 20031 | 129 | 9 |
596881 | 596881 | 2020-10-04 | Comanche | Kansas | 20033 | 16 | 0 |
596882 | 596882 | 2020-10-04 | Cowley | Kansas | 20035 | 407 | 8 |
596883 | 596883 | 2020-10-04 | Crawford | Kansas | 20037 | 1128 | 8 |
596884 | 596884 | 2020-10-04 | Decatur | Kansas | 20039 | 29 | 1 |
596885 | 596885 | 2020-10-04 | Dickinson | Kansas | 20041 | 222 | 1 |
596886 | 596886 | 2020-10-04 | Doniphan | Kansas | 20043 | 118 | 0 |
596887 | 596887 | 2020-10-04 | Douglas | Kansas | 20045 | 2411 | 13 |
596888 | 596888 | 2020-10-04 | Edwards | Kansas | 20047 | 53 | 0 |
596889 | 596889 | 2020-10-04 | Elk | Kansas | 20049 | 7 | 0 |
596890 | 596890 | 2020-10-04 | Ellis | Kansas | 20051 | 1088 | 6 |
596891 | 596891 | 2020-10-04 | Ellsworth | Kansas | 20053 | 62 | 0 |
596892 | 596892 | 2020-10-04 | Finney | Kansas | 20055 | 2265 | 12 |
596893 | 596893 | 2020-10-04 | Ford | Kansas | 20057 | 2942 | 10 |
596894 | 596894 | 2020-10-04 | Franklin | Kansas | 20059 | 411 | 3 |
596895 | 596895 | 2020-10-04 | Geary | Kansas | 20061 | 440 | 3 |
596896 | 596896 | 2020-10-04 | Gove | Kansas | 20063 | 101 | 0 |
596897 | 596897 | 2020-10-04 | Graham | Kansas | 20065 | 44 | 1 |
596898 | 596898 | 2020-10-04 | Grant | Kansas | 20067 | 321 | 5 |
596899 | 596899 | 2020-10-04 | Gray | Kansas | 20069 | 129 | 0 |
596900 | 596900 | 2020-10-04 | Greeley | Kansas | 20071 | 15 | 0 |
596901 | 596901 | 2020-10-04 | Greenwood | Kansas | 20073 | 50 | 0 |
596902 | 596902 | 2020-10-04 | Hamilton | Kansas | 20075 | 47 | 0 |
596903 | 596903 | 2020-10-04 | Harper | Kansas | 20077 | 120 | 2 |
596904 | 596904 | 2020-10-04 | Harvey | Kansas | 20079 | 371 | 8 |
596905 | 596905 | 2020-10-04 | Haskell | Kansas | 20081 | 128 | 1 |
596906 | 596906 | 2020-10-04 | Hodgeman | Kansas | 20083 | 25 | 0 |
596907 | 596907 | 2020-10-04 | Jackson | Kansas | 20085 | 253 | 2 |
596908 | 596908 | 2020-10-04 | Jefferson | Kansas | 20087 | 202 | 4 |
596909 | 596909 | 2020-10-04 | Jewell | Kansas | 20089 | 17 | 1 |
596910 | 596910 | 2020-10-04 | Johnson | Kansas | 20091 | 11800 | 158 |
596911 | 596911 | 2020-10-04 | Kearny | Kansas | 20093 | 102 | 1 |
596912 | 596912 | 2020-10-04 | Kingman | Kansas | 20095 | 102 | 1 |
596913 | 596913 | 2020-10-04 | Kiowa | Kansas | 20097 | 27 | 0 |
596914 | 596914 | 2020-10-04 | Labette | Kansas | 20099 | 253 | 4 |
596915 | 596915 | 2020-10-04 | Lane | Kansas | 20101 | 16 | 0 |
596916 | 596916 | 2020-10-04 | Leavenworth | Kansas | 20103 | 2293 | 13 |
596917 | 596917 | 2020-10-04 | Lincoln | Kansas | 20105 | 14 | 0 |
596918 | 596918 | 2020-10-04 | Linn | Kansas | 20107 | 87 | 0 |
596919 | 596919 | 2020-10-04 | Logan | Kansas | 20109 | 35 | 0 |
596920 | 596920 | 2020-10-04 | Lyon | Kansas | 20111 | 1092 | 35 |
596921 | 596921 | 2020-10-04 | Marion | Kansas | 20115 | 103 | 1 |
596922 | 596922 | 2020-10-04 | Marshall | Kansas | 20117 | 39 | 0 |
596923 | 596923 | 2020-10-04 | McPherson | Kansas | 20113 | 273 | 1 |
596924 | 596924 | 2020-10-04 | Meade | Kansas | 20119 | 147 | 1 |
596925 | 596925 | 2020-10-04 | Miami | Kansas | 20121 | 418 | 1 |
596926 | 596926 | 2020-10-04 | Mitchell | Kansas | 20123 | 46 | 0 |
596927 | 596927 | 2020-10-04 | Montgomery | Kansas | 20125 | 457 | 6 |
596928 | 596928 | 2020-10-04 | Morris | Kansas | 20127 | 43 | 0 |
596929 | 596929 | 2020-10-04 | Morton | Kansas | 20129 | 21 | 2 |
596930 | 596930 | 2020-10-04 | Nemaha | Kansas | 20131 | 136 | 1 |
596931 | 596931 | 2020-10-04 | Neosho | Kansas | 20133 | 183 | 0 |
596932 | 596932 | 2020-10-04 | Ness | Kansas | 20135 | 101 | 7 |
596933 | 596933 | 2020-10-04 | Norton | Kansas | 20137 | 40 | 0 |
596934 | 596934 | 2020-10-04 | Osage | Kansas | 20139 | 115 | 0 |
596935 | 596935 | 2020-10-04 | Osborne | Kansas | 20141 | 12 | 0 |
596936 | 596936 | 2020-10-04 | Ottawa | Kansas | 20143 | 59 | 0 |
596937 | 596937 | 2020-10-04 | Pawnee | Kansas | 20145 | 393 | 1 |
596938 | 596938 | 2020-10-04 | Phillips | Kansas | 20147 | 131 | 8 |
596939 | 596939 | 2020-10-04 | Pottawatomie | Kansas | 20149 | 288 | 0 |
596940 | 596940 | 2020-10-04 | Pratt | Kansas | 20151 | 77 | 0 |
596941 | 596941 | 2020-10-04 | Rawlins | Kansas | 20153 | 83 | 0 |
596942 | 596942 | 2020-10-04 | Reno | Kansas | 20155 | 1200 | 4 |
596943 | 596943 | 2020-10-04 | Republic | Kansas | 20157 | 49 | 1 |
596944 | 596944 | 2020-10-04 | Rice | Kansas | 20159 | 86 | 1 |
596945 | 596945 | 2020-10-04 | Riley | Kansas | 20161 | 1857 | 8 |
596946 | 596946 | 2020-10-04 | Rooks | Kansas | 20163 | 115 | 4 |
596947 | 596947 | 2020-10-04 | Rush | Kansas | 20165 | 73 | 0 |
596948 | 596948 | 2020-10-04 | Russell | Kansas | 20167 | 115 | 1 |
596949 | 596949 | 2020-10-04 | Saline | Kansas | 20169 | 781 | 11 |
596950 | 596950 | 2020-10-04 | Scott | Kansas | 20171 | 134 | 1 |
596951 | 596951 | 2020-10-04 | Sedgwick | Kansas | 20173 | 9276 | 93 |
596952 | 596952 | 2020-10-04 | Seward | Kansas | 20175 | 1731 | 7 |
596953 | 596953 | 2020-10-04 | Shawnee | Kansas | 20177 | 2864 | 34 |
596954 | 596954 | 2020-10-04 | Sheridan | Kansas | 20179 | 32 | 0 |
596955 | 596955 | 2020-10-04 | Sherman | Kansas | 20181 | 47 | 0 |
596956 | 596956 | 2020-10-04 | Smith | Kansas | 20183 | 11 | 0 |
596957 | 596957 | 2020-10-04 | Stafford | Kansas | 20185 | 60 | 1 |
596958 | 596958 | 2020-10-04 | Stanton | Kansas | 20187 | 71 | 2 |
596959 | 596959 | 2020-10-04 | Stevens | Kansas | 20189 | 171 | 1 |
596960 | 596960 | 2020-10-04 | Sumner | Kansas | 20191 | 213 | 3 |
596961 | 596961 | 2020-10-04 | Thomas | Kansas | 20193 | 187 | 0 |
596962 | 596962 | 2020-10-04 | Trego | Kansas | 20195 | 58 | 3 |
596963 | 596963 | 2020-10-04 | Unknown | Kansas | 0 | 9 | |
596964 | 596964 | 2020-10-04 | 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);