ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
98 rows where date = "2020-07-07" 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 |
---|---|---|---|---|---|---|---|
310082 | 310082 | 2020-07-07 | Allen | Kansas | 20001 | 5 | 0 |
310083 | 310083 | 2020-07-07 | Anderson | Kansas | 20003 | 5 | 0 |
310084 | 310084 | 2020-07-07 | Atchison | Kansas | 20005 | 40 | 0 |
310085 | 310085 | 2020-07-07 | Barber | Kansas | 20007 | 2 | 0 |
310086 | 310086 | 2020-07-07 | Barton | Kansas | 20009 | 57 | 2 |
310087 | 310087 | 2020-07-07 | Bourbon | Kansas | 20011 | 35 | 1 |
310088 | 310088 | 2020-07-07 | Brown | Kansas | 20013 | 12 | 0 |
310089 | 310089 | 2020-07-07 | Butler | Kansas | 20015 | 76 | 0 |
310090 | 310090 | 2020-07-07 | Chase | Kansas | 20017 | 5 | 0 |
310091 | 310091 | 2020-07-07 | Chautauqua | Kansas | 20019 | 4 | 0 |
310092 | 310092 | 2020-07-07 | Cherokee | Kansas | 20021 | 40 | 1 |
310093 | 310093 | 2020-07-07 | Cheyenne | Kansas | 20023 | 2 | 0 |
310094 | 310094 | 2020-07-07 | Clark | Kansas | 20025 | 34 | 1 |
310095 | 310095 | 2020-07-07 | Clay | Kansas | 20027 | 9 | 2 |
310096 | 310096 | 2020-07-07 | Cloud | Kansas | 20029 | 24 | 0 |
310097 | 310097 | 2020-07-07 | Coffey | Kansas | 20031 | 53 | 8 |
310098 | 310098 | 2020-07-07 | Comanche | Kansas | 20033 | 3 | 0 |
310099 | 310099 | 2020-07-07 | Cowley | Kansas | 20035 | 76 | 1 |
310100 | 310100 | 2020-07-07 | Crawford | Kansas | 20037 | 278 | 1 |
310101 | 310101 | 2020-07-07 | Dickinson | Kansas | 20041 | 10 | 1 |
310102 | 310102 | 2020-07-07 | Doniphan | Kansas | 20043 | 27 | 0 |
310103 | 310103 | 2020-07-07 | Douglas | Kansas | 20045 | 354 | 0 |
310104 | 310104 | 2020-07-07 | Edwards | Kansas | 20047 | 7 | 0 |
310105 | 310105 | 2020-07-07 | Elk | Kansas | 20049 | 1 | 0 |
310106 | 310106 | 2020-07-07 | Ellis | Kansas | 20051 | 30 | 0 |
310107 | 310107 | 2020-07-07 | Ellsworth | Kansas | 20053 | 10 | 0 |
310108 | 310108 | 2020-07-07 | Finney | Kansas | 20055 | 1584 | 10 |
310109 | 310109 | 2020-07-07 | Ford | Kansas | 20057 | 2016 | 10 |
310110 | 310110 | 2020-07-07 | Franklin | Kansas | 20059 | 81 | 1 |
310111 | 310111 | 2020-07-07 | Geary | Kansas | 20061 | 95 | 1 |
310112 | 310112 | 2020-07-07 | Gove | Kansas | 20063 | 2 | 0 |
310113 | 310113 | 2020-07-07 | Graham | Kansas | 20065 | 2 | 0 |
310114 | 310114 | 2020-07-07 | Grant | Kansas | 20067 | 55 | 1 |
310115 | 310115 | 2020-07-07 | Gray | Kansas | 20069 | 27 | 0 |
310116 | 310116 | 2020-07-07 | Greenwood | Kansas | 20073 | 11 | 0 |
310117 | 310117 | 2020-07-07 | Hamilton | Kansas | 20075 | 35 | 0 |
310118 | 310118 | 2020-07-07 | Harper | Kansas | 20077 | 2 | 0 |
310119 | 310119 | 2020-07-07 | Harvey | Kansas | 20079 | 52 | 2 |
310120 | 310120 | 2020-07-07 | Haskell | Kansas | 20081 | 30 | 0 |
310121 | 310121 | 2020-07-07 | Hodgeman | Kansas | 20083 | 9 | 0 |
310122 | 310122 | 2020-07-07 | Jackson | Kansas | 20085 | 117 | 1 |
310123 | 310123 | 2020-07-07 | Jefferson | Kansas | 20087 | 31 | 0 |
310124 | 310124 | 2020-07-07 | Jewell | Kansas | 20089 | 4 | 0 |
310125 | 310125 | 2020-07-07 | Johnson | Kansas | 20091 | 2356 | 91 |
310126 | 310126 | 2020-07-07 | Kearny | Kansas | 20093 | 48 | 1 |
310127 | 310127 | 2020-07-07 | Kingman | Kansas | 20095 | 1 | 0 |
310128 | 310128 | 2020-07-07 | Kiowa | Kansas | 20097 | 3 | 0 |
310129 | 310129 | 2020-07-07 | Labette | Kansas | 20099 | 66 | 0 |
310130 | 310130 | 2020-07-07 | Lane | Kansas | 20101 | 5 | 0 |
310131 | 310131 | 2020-07-07 | Leavenworth | Kansas | 20103 | 1194 | 7 |
310132 | 310132 | 2020-07-07 | Linn | Kansas | 20107 | 17 | 0 |
310133 | 310133 | 2020-07-07 | Logan | Kansas | 20109 | 1 | 0 |
310134 | 310134 | 2020-07-07 | Lyon | Kansas | 20111 | 510 | 7 |
310135 | 310135 | 2020-07-07 | Marion | Kansas | 20115 | 12 | 1 |
310136 | 310136 | 2020-07-07 | Marshall | Kansas | 20117 | 2 | 0 |
310137 | 310137 | 2020-07-07 | McPherson | Kansas | 20113 | 84 | 0 |
310138 | 310138 | 2020-07-07 | Meade | Kansas | 20119 | 30 | 0 |
310139 | 310139 | 2020-07-07 | Miami | Kansas | 20121 | 46 | 0 |
310140 | 310140 | 2020-07-07 | Mitchell | Kansas | 20123 | 4 | 0 |
310141 | 310141 | 2020-07-07 | Montgomery | Kansas | 20125 | 49 | 3 |
310142 | 310142 | 2020-07-07 | Morris | Kansas | 20127 | 5 | 0 |
310143 | 310143 | 2020-07-07 | Morton | Kansas | 20129 | 7 | 2 |
310144 | 310144 | 2020-07-07 | Nemaha | Kansas | 20131 | 28 | 0 |
310145 | 310145 | 2020-07-07 | Neosho | Kansas | 20133 | 35 | 0 |
310146 | 310146 | 2020-07-07 | Ness | Kansas | 20135 | 4 | 0 |
310147 | 310147 | 2020-07-07 | Norton | Kansas | 20137 | 10 | 0 |
310148 | 310148 | 2020-07-07 | Osage | Kansas | 20139 | 18 | 0 |
310149 | 310149 | 2020-07-07 | Osborne | Kansas | 20141 | 3 | 0 |
310150 | 310150 | 2020-07-07 | Ottawa | Kansas | 20143 | 10 | 0 |
310151 | 310151 | 2020-07-07 | Pawnee | Kansas | 20145 | 3 | 0 |
310152 | 310152 | 2020-07-07 | Phillips | Kansas | 20147 | 27 | 0 |
310153 | 310153 | 2020-07-07 | Pottawatomie | Kansas | 20149 | 82 | 0 |
310154 | 310154 | 2020-07-07 | Pratt | Kansas | 20151 | 11 | 0 |
310155 | 310155 | 2020-07-07 | Reno | Kansas | 20155 | 96 | 0 |
310156 | 310156 | 2020-07-07 | Republic | Kansas | 20157 | 9 | 0 |
310157 | 310157 | 2020-07-07 | Rice | Kansas | 20159 | 4 | 0 |
310158 | 310158 | 2020-07-07 | Riley | Kansas | 20161 | 317 | 3 |
310159 | 310159 | 2020-07-07 | Rooks | Kansas | 20163 | 8 | 0 |
310160 | 310160 | 2020-07-07 | Rush | Kansas | 20165 | 1 | 0 |
310161 | 310161 | 2020-07-07 | Saline | Kansas | 20169 | 173 | 2 |
310162 | 310162 | 2020-07-07 | Scott | Kansas | 20171 | 16 | 0 |
310163 | 310163 | 2020-07-07 | Sedgwick | Kansas | 20173 | 1750 | 28 |
310164 | 310164 | 2020-07-07 | Seward | Kansas | 20175 | 1045 | 2 |
310165 | 310165 | 2020-07-07 | Shawnee | Kansas | 20177 | 844 | 13 |
310166 | 310166 | 2020-07-07 | Sheridan | Kansas | 20179 | 5 | 0 |
310167 | 310167 | 2020-07-07 | Sherman | Kansas | 20181 | 7 | 0 |
310168 | 310168 | 2020-07-07 | Smith | Kansas | 20183 | 3 | 0 |
310169 | 310169 | 2020-07-07 | Stafford | Kansas | 20185 | 1 | 0 |
310170 | 310170 | 2020-07-07 | Stanton | Kansas | 20187 | 12 | 0 |
310171 | 310171 | 2020-07-07 | Stevens | Kansas | 20189 | 32 | 0 |
310172 | 310172 | 2020-07-07 | Sumner | Kansas | 20191 | 16 | 1 |
310173 | 310173 | 2020-07-07 | Thomas | Kansas | 20193 | 16 | 0 |
310174 | 310174 | 2020-07-07 | Trego | Kansas | 20195 | 1 | 0 |
310175 | 310175 | 2020-07-07 | Wabaunsee | Kansas | 20197 | 36 | 0 |
310176 | 310176 | 2020-07-07 | Washington | Kansas | 20201 | 1 | 0 |
310177 | 310177 | 2020-07-07 | Wilson | Kansas | 20205 | 4 | 0 |
310178 | 310178 | 2020-07-07 | Woodson | Kansas | 20207 | 9 | 0 |
310179 | 310179 | 2020-07-07 | Wyandotte | Kansas | 20209 | 2728 | 85 |
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);