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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 20091 147
- 20209 142
- 20015 141
- 20059 140
- 20045 137
- 20057 137
- 20103 136
- 20021 135
- 20107 135
- 20127 135
- 20173 135
- 20155 134
- 20161 134
- 20085 132
- 20123 132
- 20011 131
- 20111 131
- 20043 130
- 20149 130
- 20207 130
- 20037 129
- 20133 129
- 20177 129
- 20087 128
- 20191 128
- 20027 127
- 20031 127
- 20063 127
- 20079 127
- 20113 127
- …
county >30
- Johnson 147
- Wyandotte 142
- Butler 141
- Franklin 140
- Douglas 137
- Ford 137
- Leavenworth 136
- Cherokee 135
- Linn 135
- Morris 135
- Sedgwick 135
- Reno 134
- Riley 134
- Jackson 132
- Mitchell 132
- Bourbon 131
- Lyon 131
- Doniphan 130
- Pottawatomie 130
- Woodson 130
- Crawford 129
- Neosho 129
- Shawnee 129
- Jefferson 128
- Sumner 128
- Clay 127
- Coffey 127
- Gove 127
- Harvey 127
- McPherson 127
- …
state 1
- Kansas · 10,751 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386830 | 386830 | 2020-07-31 | Allen | Kansas | 20001 | 14 | 0 |
386831 | 386831 | 2020-07-31 | Anderson | Kansas | 20003 | 27 | 0 |
386832 | 386832 | 2020-07-31 | Atchison | Kansas | 20005 | 61 | 0 |
386833 | 386833 | 2020-07-31 | Barber | Kansas | 20007 | 4 | 0 |
386834 | 386834 | 2020-07-31 | Barton | Kansas | 20009 | 109 | 3 |
386835 | 386835 | 2020-07-31 | Bourbon | Kansas | 20011 | 69 | 1 |
386836 | 386836 | 2020-07-31 | Brown | Kansas | 20013 | 36 | 0 |
386837 | 386837 | 2020-07-31 | Butler | Kansas | 20015 | 215 | 0 |
386838 | 386838 | 2020-07-31 | Chase | Kansas | 20017 | 6 | 0 |
386839 | 386839 | 2020-07-31 | Chautauqua | Kansas | 20019 | 5 | 0 |
386840 | 386840 | 2020-07-31 | Cherokee | Kansas | 20021 | 74 | 1 |
386841 | 386841 | 2020-07-31 | Cheyenne | Kansas | 20023 | 2 | 0 |
386842 | 386842 | 2020-07-31 | Clark | Kansas | 20025 | 44 | 1 |
386843 | 386843 | 2020-07-31 | Clay | Kansas | 20027 | 18 | 2 |
386844 | 386844 | 2020-07-31 | Cloud | Kansas | 20029 | 29 | 0 |
386845 | 386845 | 2020-07-31 | Coffey | Kansas | 20031 | 67 | 8 |
386846 | 386846 | 2020-07-31 | Comanche | Kansas | 20033 | 3 | 0 |
386847 | 386847 | 2020-07-31 | Cowley | Kansas | 20035 | 151 | 2 |
386848 | 386848 | 2020-07-31 | Crawford | Kansas | 20037 | 380 | 1 |
386849 | 386849 | 2020-07-31 | Decatur | Kansas | 20039 | 6 | 0 |
386850 | 386850 | 2020-07-31 | Dickinson | Kansas | 20041 | 40 | 1 |
386851 | 386851 | 2020-07-31 | Doniphan | Kansas | 20043 | 42 | 0 |
386852 | 386852 | 2020-07-31 | Douglas | Kansas | 20045 | 663 | 3 |
386853 | 386853 | 2020-07-31 | Edwards | Kansas | 20047 | 10 | 0 |
386854 | 386854 | 2020-07-31 | Elk | Kansas | 20049 | 1 | 0 |
386855 | 386855 | 2020-07-31 | Ellis | Kansas | 20051 | 131 | 1 |
386856 | 386856 | 2020-07-31 | Ellsworth | Kansas | 20053 | 18 | 0 |
386857 | 386857 | 2020-07-31 | Finney | Kansas | 20055 | 1737 | 10 |
386858 | 386858 | 2020-07-31 | Ford | Kansas | 20057 | 2106 | 10 |
386859 | 386859 | 2020-07-31 | Franklin | Kansas | 20059 | 150 | 1 |
386860 | 386860 | 2020-07-31 | Geary | Kansas | 20061 | 179 | 1 |
386861 | 386861 | 2020-07-31 | Gove | Kansas | 20063 | 3 | 0 |
386862 | 386862 | 2020-07-31 | Graham | Kansas | 20065 | 17 | 0 |
386863 | 386863 | 2020-07-31 | Grant | Kansas | 20067 | 92 | 2 |
386864 | 386864 | 2020-07-31 | Gray | Kansas | 20069 | 64 | 0 |
386865 | 386865 | 2020-07-31 | Greeley | Kansas | 20071 | 3 | 0 |
386866 | 386866 | 2020-07-31 | Greenwood | Kansas | 20073 | 15 | 0 |
386867 | 386867 | 2020-07-31 | Hamilton | Kansas | 20075 | 41 | 0 |
386868 | 386868 | 2020-07-31 | Harper | Kansas | 20077 | 8 | 0 |
386869 | 386869 | 2020-07-31 | Harvey | Kansas | 20079 | 165 | 3 |
386870 | 386870 | 2020-07-31 | Haskell | Kansas | 20081 | 39 | 0 |
386871 | 386871 | 2020-07-31 | Hodgeman | Kansas | 20083 | 11 | 0 |
386872 | 386872 | 2020-07-31 | Jackson | Kansas | 20085 | 144 | 1 |
386873 | 386873 | 2020-07-31 | Jefferson | Kansas | 20087 | 61 | 0 |
386874 | 386874 | 2020-07-31 | Jewell | Kansas | 20089 | 9 | 0 |
386875 | 386875 | 2020-07-31 | Johnson | Kansas | 20091 | 4995 | 98 |
386876 | 386876 | 2020-07-31 | Kearny | Kansas | 20093 | 54 | 1 |
386877 | 386877 | 2020-07-31 | Kingman | Kansas | 20095 | 9 | 0 |
386878 | 386878 | 2020-07-31 | Kiowa | Kansas | 20097 | 6 | 0 |
386879 | 386879 | 2020-07-31 | Labette | Kansas | 20099 | 109 | 0 |
386880 | 386880 | 2020-07-31 | Lane | Kansas | 20101 | 5 | 0 |
386881 | 386881 | 2020-07-31 | Leavenworth | Kansas | 20103 | 1422 | 8 |
386882 | 386882 | 2020-07-31 | Lincoln | Kansas | 20105 | 6 | 0 |
386883 | 386883 | 2020-07-31 | Linn | Kansas | 20107 | 33 | 0 |
386884 | 386884 | 2020-07-31 | Logan | Kansas | 20109 | 2 | 0 |
386885 | 386885 | 2020-07-31 | Lyon | Kansas | 20111 | 644 | 11 |
386886 | 386886 | 2020-07-31 | Marion | Kansas | 20115 | 51 | 1 |
386887 | 386887 | 2020-07-31 | Marshall | Kansas | 20117 | 9 | 0 |
386888 | 386888 | 2020-07-31 | McPherson | Kansas | 20113 | 141 | 1 |
386889 | 386889 | 2020-07-31 | Meade | Kansas | 20119 | 57 | 0 |
386890 | 386890 | 2020-07-31 | Miami | Kansas | 20121 | 122 | 0 |
386891 | 386891 | 2020-07-31 | Mitchell | Kansas | 20123 | 27 | 0 |
386892 | 386892 | 2020-07-31 | Montgomery | Kansas | 20125 | 152 | 5 |
386893 | 386893 | 2020-07-31 | Morris | Kansas | 20127 | 9 | 0 |
386894 | 386894 | 2020-07-31 | Morton | Kansas | 20129 | 9 | 2 |
386895 | 386895 | 2020-07-31 | Nemaha | Kansas | 20131 | 46 | 0 |
386896 | 386896 | 2020-07-31 | Neosho | Kansas | 20133 | 51 | 0 |
386897 | 386897 | 2020-07-31 | Ness | Kansas | 20135 | 5 | 0 |
386898 | 386898 | 2020-07-31 | Norton | Kansas | 20137 | 22 | 0 |
386899 | 386899 | 2020-07-31 | Osage | Kansas | 20139 | 37 | 0 |
386900 | 386900 | 2020-07-31 | Osborne | Kansas | 20141 | 4 | 0 |
386901 | 386901 | 2020-07-31 | Ottawa | Kansas | 20143 | 30 | 0 |
386902 | 386902 | 2020-07-31 | Pawnee | Kansas | 20145 | 7 | 0 |
386903 | 386903 | 2020-07-31 | Phillips | Kansas | 20147 | 47 | 8 |
386904 | 386904 | 2020-07-31 | Pottawatomie | Kansas | 20149 | 109 | 0 |
386905 | 386905 | 2020-07-31 | Pratt | Kansas | 20151 | 33 | 0 |
386906 | 386906 | 2020-07-31 | Reno | Kansas | 20155 | 229 | 1 |
386907 | 386907 | 2020-07-31 | Republic | Kansas | 20157 | 28 | 0 |
386908 | 386908 | 2020-07-31 | Rice | Kansas | 20159 | 26 | 0 |
386909 | 386909 | 2020-07-31 | Riley | Kansas | 20161 | 449 | 5 |
386910 | 386910 | 2020-07-31 | Rooks | Kansas | 20163 | 16 | 0 |
386911 | 386911 | 2020-07-31 | Rush | Kansas | 20165 | 6 | 0 |
386912 | 386912 | 2020-07-31 | Russell | Kansas | 20167 | 11 | 0 |
386913 | 386913 | 2020-07-31 | Saline | Kansas | 20169 | 345 | 5 |
386914 | 386914 | 2020-07-31 | Scott | Kansas | 20171 | 28 | 0 |
386915 | 386915 | 2020-07-31 | Sedgwick | Kansas | 20173 | 4196 | 39 |
386916 | 386916 | 2020-07-31 | Seward | Kansas | 20175 | 1188 | 4 |
386917 | 386917 | 2020-07-31 | Shawnee | Kansas | 20177 | 1398 | 19 |
386918 | 386918 | 2020-07-31 | Sheridan | Kansas | 20179 | 7 | 0 |
386919 | 386919 | 2020-07-31 | Sherman | Kansas | 20181 | 14 | 0 |
386920 | 386920 | 2020-07-31 | Smith | Kansas | 20183 | 3 | 0 |
386921 | 386921 | 2020-07-31 | Stafford | Kansas | 20185 | 3 | 0 |
386922 | 386922 | 2020-07-31 | Stanton | Kansas | 20187 | 23 | 0 |
386923 | 386923 | 2020-07-31 | Stevens | Kansas | 20189 | 43 | 0 |
386924 | 386924 | 2020-07-31 | Sumner | Kansas | 20191 | 97 | 3 |
386925 | 386925 | 2020-07-31 | Thomas | Kansas | 20193 | 32 | 0 |
386926 | 386926 | 2020-07-31 | Trego | Kansas | 20195 | 5 | 0 |
386927 | 386927 | 2020-07-31 | Wabaunsee | Kansas | 20197 | 39 | 0 |
386928 | 386928 | 2020-07-31 | Washington | Kansas | 20201 | 2 | 0 |
386929 | 386929 | 2020-07-31 | Wichita | Kansas | 20203 | 3 | 0 |
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);