ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
754 rows where fips = 20081 and state = "Kansas" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
73745 | 73745 | 2020-04-20 | Haskell | Kansas | 20081 | 1 | 0 |
76525 | 76525 | 2020-04-21 | Haskell | Kansas | 20081 | 1 | 0 |
79310 | 79310 | 2020-04-22 | Haskell | Kansas | 20081 | 1 | 0 |
82104 | 82104 | 2020-04-23 | Haskell | Kansas | 20081 | 6 | 0 |
84906 | 84906 | 2020-04-24 | Haskell | Kansas | 20081 | 6 | 0 |
87715 | 87715 | 2020-04-25 | Haskell | Kansas | 20081 | 7 | 0 |
90531 | 90531 | 2020-04-26 | Haskell | Kansas | 20081 | 7 | 0 |
93352 | 93352 | 2020-04-27 | Haskell | Kansas | 20081 | 7 | 0 |
96184 | 96184 | 2020-04-28 | Haskell | Kansas | 20081 | 7 | 0 |
99030 | 99030 | 2020-04-29 | Haskell | Kansas | 20081 | 7 | 0 |
101882 | 101882 | 2020-04-30 | Haskell | Kansas | 20081 | 7 | 0 |
104742 | 104742 | 2020-05-01 | Haskell | Kansas | 20081 | 7 | 0 |
107607 | 107607 | 2020-05-02 | Haskell | Kansas | 20081 | 7 | 0 |
110478 | 110478 | 2020-05-03 | Haskell | Kansas | 20081 | 7 | 0 |
113355 | 113355 | 2020-05-04 | Haskell | Kansas | 20081 | 8 | 0 |
116237 | 116237 | 2020-05-05 | Haskell | Kansas | 20081 | 8 | 0 |
119198 | 119198 | 2020-05-06 | Haskell | Kansas | 20081 | 8 | 0 |
122168 | 122168 | 2020-05-07 | Haskell | Kansas | 20081 | 9 | 0 |
125150 | 125150 | 2020-05-08 | Haskell | Kansas | 20081 | 14 | 0 |
128138 | 128138 | 2020-05-09 | Haskell | Kansas | 20081 | 15 | 0 |
131128 | 131128 | 2020-05-10 | Haskell | Kansas | 20081 | 16 | 0 |
134119 | 134119 | 2020-05-11 | Haskell | Kansas | 20081 | 16 | 0 |
137109 | 137109 | 2020-05-12 | Haskell | Kansas | 20081 | 16 | 0 |
140102 | 140102 | 2020-05-13 | Haskell | Kansas | 20081 | 16 | 0 |
143098 | 143098 | 2020-05-14 | Haskell | Kansas | 20081 | 16 | 0 |
146098 | 146098 | 2020-05-15 | Haskell | Kansas | 20081 | 16 | 0 |
149102 | 149102 | 2020-05-16 | Haskell | Kansas | 20081 | 16 | 0 |
152113 | 152113 | 2020-05-17 | Haskell | Kansas | 20081 | 16 | 0 |
155125 | 155125 | 2020-05-18 | Haskell | Kansas | 20081 | 16 | 0 |
158142 | 158142 | 2020-05-19 | Haskell | Kansas | 20081 | 16 | 0 |
161167 | 161167 | 2020-05-20 | Haskell | Kansas | 20081 | 16 | 0 |
164196 | 164196 | 2020-05-21 | Haskell | Kansas | 20081 | 16 | 0 |
167229 | 167229 | 2020-05-22 | Haskell | Kansas | 20081 | 17 | 0 |
170267 | 170267 | 2020-05-23 | Haskell | Kansas | 20081 | 17 | 0 |
173308 | 173308 | 2020-05-24 | Haskell | Kansas | 20081 | 17 | 0 |
176352 | 176352 | 2020-05-25 | Haskell | Kansas | 20081 | 18 | 0 |
179396 | 179396 | 2020-05-26 | Haskell | Kansas | 20081 | 18 | 0 |
182441 | 182441 | 2020-05-27 | Haskell | Kansas | 20081 | 18 | 0 |
185495 | 185495 | 2020-05-28 | Haskell | Kansas | 20081 | 18 | 0 |
188553 | 188553 | 2020-05-29 | Haskell | Kansas | 20081 | 21 | 0 |
191617 | 191617 | 2020-05-30 | Haskell | Kansas | 20081 | 21 | 0 |
194685 | 194685 | 2020-05-31 | Haskell | Kansas | 20081 | 21 | 0 |
197755 | 197755 | 2020-06-01 | Haskell | Kansas | 20081 | 21 | 0 |
200827 | 200827 | 2020-06-02 | Haskell | Kansas | 20081 | 21 | 0 |
203903 | 203903 | 2020-06-03 | Haskell | Kansas | 20081 | 22 | 0 |
206984 | 206984 | 2020-06-04 | Haskell | Kansas | 20081 | 22 | 0 |
210065 | 210065 | 2020-06-05 | Haskell | Kansas | 20081 | 22 | 0 |
213150 | 213150 | 2020-06-06 | Haskell | Kansas | 20081 | 22 | 0 |
216237 | 216237 | 2020-06-07 | Haskell | Kansas | 20081 | 22 | 0 |
219329 | 219329 | 2020-06-08 | Haskell | Kansas | 20081 | 22 | 0 |
222424 | 222424 | 2020-06-09 | Haskell | Kansas | 20081 | 22 | 0 |
225519 | 225519 | 2020-06-10 | Haskell | Kansas | 20081 | 22 | 0 |
228621 | 228621 | 2020-06-11 | Haskell | Kansas | 20081 | 22 | 0 |
231724 | 231724 | 2020-06-12 | Haskell | Kansas | 20081 | 22 | 0 |
234830 | 234830 | 2020-06-13 | Haskell | Kansas | 20081 | 22 | 0 |
237937 | 237937 | 2020-06-14 | Haskell | Kansas | 20081 | 22 | 0 |
241046 | 241046 | 2020-06-15 | Haskell | Kansas | 20081 | 22 | 0 |
244157 | 244157 | 2020-06-16 | Haskell | Kansas | 20081 | 22 | 0 |
247270 | 247270 | 2020-06-17 | Haskell | Kansas | 20081 | 22 | 0 |
250382 | 250382 | 2020-06-18 | Haskell | Kansas | 20081 | 22 | 0 |
253497 | 253497 | 2020-06-19 | Haskell | Kansas | 20081 | 23 | 0 |
256617 | 256617 | 2020-06-20 | Haskell | Kansas | 20081 | 23 | 0 |
259743 | 259743 | 2020-06-21 | Haskell | Kansas | 20081 | 23 | 0 |
262870 | 262870 | 2020-06-22 | Haskell | Kansas | 20081 | 23 | 0 |
265998 | 265998 | 2020-06-23 | Haskell | Kansas | 20081 | 23 | 0 |
269128 | 269128 | 2020-06-24 | Haskell | Kansas | 20081 | 23 | 0 |
272265 | 272265 | 2020-06-25 | Haskell | Kansas | 20081 | 23 | 0 |
275408 | 275408 | 2020-06-26 | Haskell | Kansas | 20081 | 23 | 0 |
278556 | 278556 | 2020-06-27 | Haskell | Kansas | 20081 | 23 | 0 |
281704 | 281704 | 2020-06-28 | Haskell | Kansas | 20081 | 23 | 0 |
284849 | 284849 | 2020-06-29 | Haskell | Kansas | 20081 | 23 | 0 |
287998 | 287998 | 2020-06-30 | Haskell | Kansas | 20081 | 23 | 0 |
291148 | 291148 | 2020-07-01 | Haskell | Kansas | 20081 | 24 | 0 |
294302 | 294302 | 2020-07-02 | Haskell | Kansas | 20081 | 24 | 0 |
297460 | 297460 | 2020-07-03 | Haskell | Kansas | 20081 | 28 | 0 |
300622 | 300622 | 2020-07-04 | Haskell | Kansas | 20081 | 28 | 0 |
303786 | 303786 | 2020-07-05 | Haskell | Kansas | 20081 | 28 | 0 |
306952 | 306952 | 2020-07-06 | Haskell | Kansas | 20081 | 30 | 0 |
310120 | 310120 | 2020-07-07 | Haskell | Kansas | 20081 | 30 | 0 |
313290 | 313290 | 2020-07-08 | Haskell | Kansas | 20081 | 30 | 0 |
316464 | 316464 | 2020-07-09 | Haskell | Kansas | 20081 | 30 | 0 |
319637 | 319637 | 2020-07-10 | Haskell | Kansas | 20081 | 34 | 0 |
322816 | 322816 | 2020-07-11 | Haskell | Kansas | 20081 | 34 | 0 |
325999 | 325999 | 2020-07-12 | Haskell | Kansas | 20081 | 34 | 0 |
329185 | 329185 | 2020-07-13 | Haskell | Kansas | 20081 | 35 | 0 |
332372 | 332372 | 2020-07-14 | Haskell | Kansas | 20081 | 35 | 0 |
335565 | 335565 | 2020-07-15 | Haskell | Kansas | 20081 | 35 | 0 |
338761 | 338761 | 2020-07-16 | Haskell | Kansas | 20081 | 35 | 0 |
341957 | 341957 | 2020-07-17 | Haskell | Kansas | 20081 | 35 | 0 |
345157 | 345157 | 2020-07-18 | Haskell | Kansas | 20081 | 35 | 0 |
348358 | 348358 | 2020-07-19 | Haskell | Kansas | 20081 | 35 | 0 |
351558 | 351558 | 2020-07-20 | Haskell | Kansas | 20081 | 35 | 0 |
354760 | 354760 | 2020-07-21 | Haskell | Kansas | 20081 | 35 | 0 |
357962 | 357962 | 2020-07-22 | Haskell | Kansas | 20081 | 35 | 0 |
361167 | 361167 | 2020-07-23 | Haskell | Kansas | 20081 | 35 | 0 |
364374 | 364374 | 2020-07-24 | Haskell | Kansas | 20081 | 38 | 0 |
367581 | 367581 | 2020-07-25 | Haskell | Kansas | 20081 | 38 | 0 |
370791 | 370791 | 2020-07-26 | Haskell | Kansas | 20081 | 38 | 0 |
374003 | 374003 | 2020-07-27 | Haskell | Kansas | 20081 | 38 | 0 |
377218 | 377218 | 2020-07-28 | Haskell | Kansas | 20081 | 38 | 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);