ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where "date" is on date 2020-07-01 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
291111 | 291111 | 2020-07-01 | Allen | Kansas | 20001 | 5 | 0 |
291112 | 291112 | 2020-07-01 | Anderson | Kansas | 20003 | 4 | 0 |
291113 | 291113 | 2020-07-01 | Atchison | Kansas | 20005 | 34 | 0 |
291114 | 291114 | 2020-07-01 | Barber | Kansas | 20007 | 1 | 0 |
291115 | 291115 | 2020-07-01 | Barton | Kansas | 20009 | 57 | 2 |
291116 | 291116 | 2020-07-01 | Bourbon | Kansas | 20011 | 27 | 1 |
291117 | 291117 | 2020-07-01 | Brown | Kansas | 20013 | 11 | 0 |
291118 | 291118 | 2020-07-01 | Butler | Kansas | 20015 | 61 | 0 |
291119 | 291119 | 2020-07-01 | Chase | Kansas | 20017 | 4 | 0 |
291120 | 291120 | 2020-07-01 | Chautauqua | Kansas | 20019 | 4 | 0 |
291121 | 291121 | 2020-07-01 | Cherokee | Kansas | 20021 | 31 | 0 |
291122 | 291122 | 2020-07-01 | Cheyenne | Kansas | 20023 | 2 | 0 |
291123 | 291123 | 2020-07-01 | Clark | Kansas | 20025 | 34 | 0 |
291124 | 291124 | 2020-07-01 | Clay | Kansas | 20027 | 7 | 2 |
291125 | 291125 | 2020-07-01 | Cloud | Kansas | 20029 | 18 | 0 |
291126 | 291126 | 2020-07-01 | Coffey | Kansas | 20031 | 53 | 8 |
291127 | 291127 | 2020-07-01 | Comanche | Kansas | 20033 | 2 | 0 |
291128 | 291128 | 2020-07-01 | Cowley | Kansas | 20035 | 71 | 1 |
291129 | 291129 | 2020-07-01 | Crawford | Kansas | 20037 | 263 | 1 |
291130 | 291130 | 2020-07-01 | Dickinson | Kansas | 20041 | 8 | 0 |
291131 | 291131 | 2020-07-01 | Doniphan | Kansas | 20043 | 26 | 0 |
291132 | 291132 | 2020-07-01 | Douglas | Kansas | 20045 | 188 | 0 |
291133 | 291133 | 2020-07-01 | Edwards | Kansas | 20047 | 7 | 0 |
291134 | 291134 | 2020-07-01 | Elk | Kansas | 20049 | 1 | 0 |
291135 | 291135 | 2020-07-01 | Ellis | Kansas | 20051 | 25 | 0 |
291136 | 291136 | 2020-07-01 | Ellsworth | Kansas | 20053 | 4 | 0 |
291137 | 291137 | 2020-07-01 | Finney | Kansas | 20055 | 1574 | 10 |
291138 | 291138 | 2020-07-01 | Ford | Kansas | 20057 | 2008 | 10 |
291139 | 291139 | 2020-07-01 | Franklin | Kansas | 20059 | 72 | 1 |
291140 | 291140 | 2020-07-01 | Geary | Kansas | 20061 | 70 | 1 |
291141 | 291141 | 2020-07-01 | Gove | Kansas | 20063 | 1 | 0 |
291142 | 291142 | 2020-07-01 | Grant | Kansas | 20067 | 48 | 1 |
291143 | 291143 | 2020-07-01 | Gray | Kansas | 20069 | 26 | 0 |
291144 | 291144 | 2020-07-01 | Greenwood | Kansas | 20073 | 11 | 0 |
291145 | 291145 | 2020-07-01 | Hamilton | Kansas | 20075 | 33 | 0 |
291146 | 291146 | 2020-07-01 | Harper | Kansas | 20077 | 4 | 0 |
291147 | 291147 | 2020-07-01 | Harvey | Kansas | 20079 | 39 | 2 |
291148 | 291148 | 2020-07-01 | Haskell | Kansas | 20081 | 24 | 0 |
291149 | 291149 | 2020-07-01 | Hodgeman | Kansas | 20083 | 9 | 0 |
291150 | 291150 | 2020-07-01 | Jackson | Kansas | 20085 | 113 | 1 |
291151 | 291151 | 2020-07-01 | Jefferson | Kansas | 20087 | 25 | 0 |
291152 | 291152 | 2020-07-01 | Jewell | Kansas | 20089 | 4 | 0 |
291153 | 291153 | 2020-07-01 | Johnson | Kansas | 20091 | 1870 | 87 |
291154 | 291154 | 2020-07-01 | Kearny | Kansas | 20093 | 48 | 1 |
291155 | 291155 | 2020-07-01 | Kiowa | Kansas | 20097 | 3 | 0 |
291156 | 291156 | 2020-07-01 | Labette | Kansas | 20099 | 61 | 0 |
291157 | 291157 | 2020-07-01 | Lane | Kansas | 20101 | 5 | 0 |
291158 | 291158 | 2020-07-01 | Leavenworth | Kansas | 20103 | 1173 | 7 |
291159 | 291159 | 2020-07-01 | Linn | Kansas | 20107 | 15 | 0 |
291160 | 291160 | 2020-07-01 | Logan | Kansas | 20109 | 1 | 0 |
291161 | 291161 | 2020-07-01 | Lyon | Kansas | 20111 | 499 | 7 |
291162 | 291162 | 2020-07-01 | Marion | Kansas | 20115 | 11 | 1 |
291163 | 291163 | 2020-07-01 | Marshall | Kansas | 20117 | 1 | 0 |
291164 | 291164 | 2020-07-01 | McPherson | Kansas | 20113 | 77 | 0 |
291165 | 291165 | 2020-07-01 | Meade | Kansas | 20119 | 30 | 0 |
291166 | 291166 | 2020-07-01 | Miami | Kansas | 20121 | 34 | 0 |
291167 | 291167 | 2020-07-01 | Mitchell | Kansas | 20123 | 4 | 0 |
291168 | 291168 | 2020-07-01 | Montgomery | Kansas | 20125 | 36 | 3 |
291169 | 291169 | 2020-07-01 | Morris | Kansas | 20127 | 5 | 0 |
291170 | 291170 | 2020-07-01 | Morton | Kansas | 20129 | 7 | 2 |
291171 | 291171 | 2020-07-01 | Nemaha | Kansas | 20131 | 28 | 0 |
291172 | 291172 | 2020-07-01 | Neosho | Kansas | 20133 | 30 | 0 |
291173 | 291173 | 2020-07-01 | Ness | Kansas | 20135 | 4 | 0 |
291174 | 291174 | 2020-07-01 | Norton | Kansas | 20137 | 4 | 0 |
291175 | 291175 | 2020-07-01 | Osage | Kansas | 20139 | 13 | 0 |
291176 | 291176 | 2020-07-01 | Osborne | Kansas | 20141 | 2 | 0 |
291177 | 291177 | 2020-07-01 | Ottawa | Kansas | 20143 | 6 | 0 |
291178 | 291178 | 2020-07-01 | Pawnee | Kansas | 20145 | 3 | 0 |
291179 | 291179 | 2020-07-01 | Phillips | Kansas | 20147 | 3 | 0 |
291180 | 291180 | 2020-07-01 | Pottawatomie | Kansas | 20149 | 74 | 0 |
291181 | 291181 | 2020-07-01 | Pratt | Kansas | 20151 | 12 | 0 |
291182 | 291182 | 2020-07-01 | Reno | Kansas | 20155 | 74 | 0 |
291183 | 291183 | 2020-07-01 | Republic | Kansas | 20157 | 9 | 0 |
291184 | 291184 | 2020-07-01 | Rice | Kansas | 20159 | 4 | 0 |
291185 | 291185 | 2020-07-01 | Riley | Kansas | 20161 | 242 | 3 |
291186 | 291186 | 2020-07-01 | Rooks | Kansas | 20163 | 8 | 0 |
291187 | 291187 | 2020-07-01 | Rush | Kansas | 20165 | 1 | 0 |
291188 | 291188 | 2020-07-01 | Saline | Kansas | 20169 | 110 | 2 |
291189 | 291189 | 2020-07-01 | Scott | Kansas | 20171 | 16 | 0 |
291190 | 291190 | 2020-07-01 | Sedgwick | Kansas | 20173 | 1368 | 28 |
291191 | 291191 | 2020-07-01 | Seward | Kansas | 20175 | 1019 | 2 |
291192 | 291192 | 2020-07-01 | Shawnee | Kansas | 20177 | 670 | 12 |
291193 | 291193 | 2020-07-01 | Sheridan | Kansas | 20179 | 5 | 0 |
291194 | 291194 | 2020-07-01 | Sherman | Kansas | 20181 | 7 | 0 |
291195 | 291195 | 2020-07-01 | Smith | Kansas | 20183 | 3 | 0 |
291196 | 291196 | 2020-07-01 | Stafford | Kansas | 20185 | 1 | 0 |
291197 | 291197 | 2020-07-01 | Stanton | Kansas | 20187 | 10 | 0 |
291198 | 291198 | 2020-07-01 | Stevens | Kansas | 20189 | 32 | 0 |
291199 | 291199 | 2020-07-01 | Sumner | Kansas | 20191 | 13 | 1 |
291200 | 291200 | 2020-07-01 | Thomas | Kansas | 20193 | 15 | 0 |
291201 | 291201 | 2020-07-01 | Trego | Kansas | 20195 | 1 | 0 |
291202 | 291202 | 2020-07-01 | Wabaunsee | Kansas | 20197 | 35 | 0 |
291203 | 291203 | 2020-07-01 | Washington | Kansas | 20201 | 1 | 0 |
291204 | 291204 | 2020-07-01 | Wilson | Kansas | 20205 | 2 | 0 |
291205 | 291205 | 2020-07-01 | Woodson | Kansas | 20207 | 8 | 0 |
291206 | 291206 | 2020-07-01 | Wyandotte | Kansas | 20209 | 2420 | 83 |
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);