ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
722 rows where fips = 20195 and state = "Kansas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
167277 | 167277 | 2020-05-22 | Trego | Kansas | 20195 | 1 | 0 |
170315 | 170315 | 2020-05-23 | Trego | Kansas | 20195 | 1 | 0 |
173356 | 173356 | 2020-05-24 | Trego | Kansas | 20195 | 1 | 0 |
176400 | 176400 | 2020-05-25 | Trego | Kansas | 20195 | 1 | 0 |
179444 | 179444 | 2020-05-26 | Trego | Kansas | 20195 | 1 | 0 |
182489 | 182489 | 2020-05-27 | Trego | Kansas | 20195 | 1 | 0 |
185543 | 185543 | 2020-05-28 | Trego | Kansas | 20195 | 1 | 0 |
188601 | 188601 | 2020-05-29 | Trego | Kansas | 20195 | 1 | 0 |
191665 | 191665 | 2020-05-30 | Trego | Kansas | 20195 | 1 | 0 |
194733 | 194733 | 2020-05-31 | Trego | Kansas | 20195 | 1 | 0 |
197803 | 197803 | 2020-06-01 | Trego | Kansas | 20195 | 1 | 0 |
200875 | 200875 | 2020-06-02 | Trego | Kansas | 20195 | 1 | 0 |
203952 | 203952 | 2020-06-03 | Trego | Kansas | 20195 | 1 | 0 |
207033 | 207033 | 2020-06-04 | Trego | Kansas | 20195 | 1 | 0 |
210114 | 210114 | 2020-06-05 | Trego | Kansas | 20195 | 1 | 0 |
213199 | 213199 | 2020-06-06 | Trego | Kansas | 20195 | 1 | 0 |
216286 | 216286 | 2020-06-07 | Trego | Kansas | 20195 | 1 | 0 |
219378 | 219378 | 2020-06-08 | Trego | Kansas | 20195 | 1 | 0 |
222473 | 222473 | 2020-06-09 | Trego | Kansas | 20195 | 1 | 0 |
225568 | 225568 | 2020-06-10 | Trego | Kansas | 20195 | 1 | 0 |
228670 | 228670 | 2020-06-11 | Trego | Kansas | 20195 | 1 | 0 |
231773 | 231773 | 2020-06-12 | Trego | Kansas | 20195 | 1 | 0 |
234879 | 234879 | 2020-06-13 | Trego | Kansas | 20195 | 1 | 0 |
237986 | 237986 | 2020-06-14 | Trego | Kansas | 20195 | 1 | 0 |
241095 | 241095 | 2020-06-15 | Trego | Kansas | 20195 | 1 | 0 |
244206 | 244206 | 2020-06-16 | Trego | Kansas | 20195 | 1 | 0 |
247319 | 247319 | 2020-06-17 | Trego | Kansas | 20195 | 1 | 0 |
250431 | 250431 | 2020-06-18 | Trego | Kansas | 20195 | 1 | 0 |
253546 | 253546 | 2020-06-19 | Trego | Kansas | 20195 | 1 | 0 |
256666 | 256666 | 2020-06-20 | Trego | Kansas | 20195 | 1 | 0 |
259792 | 259792 | 2020-06-21 | Trego | Kansas | 20195 | 1 | 0 |
262920 | 262920 | 2020-06-22 | Trego | Kansas | 20195 | 1 | 0 |
266048 | 266048 | 2020-06-23 | Trego | Kansas | 20195 | 1 | 0 |
269180 | 269180 | 2020-06-24 | Trego | Kansas | 20195 | 1 | 0 |
272317 | 272317 | 2020-06-25 | Trego | Kansas | 20195 | 1 | 0 |
275460 | 275460 | 2020-06-26 | Trego | Kansas | 20195 | 1 | 0 |
278608 | 278608 | 2020-06-27 | Trego | Kansas | 20195 | 1 | 0 |
281756 | 281756 | 2020-06-28 | Trego | Kansas | 20195 | 1 | 0 |
284902 | 284902 | 2020-06-29 | Trego | Kansas | 20195 | 1 | 0 |
288051 | 288051 | 2020-06-30 | Trego | Kansas | 20195 | 1 | 0 |
291201 | 291201 | 2020-07-01 | Trego | Kansas | 20195 | 1 | 0 |
294355 | 294355 | 2020-07-02 | Trego | Kansas | 20195 | 1 | 0 |
297513 | 297513 | 2020-07-03 | Trego | Kansas | 20195 | 1 | 0 |
300675 | 300675 | 2020-07-04 | Trego | Kansas | 20195 | 1 | 0 |
303839 | 303839 | 2020-07-05 | Trego | Kansas | 20195 | 1 | 0 |
307006 | 307006 | 2020-07-06 | Trego | Kansas | 20195 | 1 | 0 |
310174 | 310174 | 2020-07-07 | Trego | Kansas | 20195 | 1 | 0 |
313344 | 313344 | 2020-07-08 | Trego | Kansas | 20195 | 2 | 0 |
316518 | 316518 | 2020-07-09 | Trego | Kansas | 20195 | 2 | 0 |
319693 | 319693 | 2020-07-10 | Trego | Kansas | 20195 | 2 | 0 |
322872 | 322872 | 2020-07-11 | Trego | Kansas | 20195 | 2 | 0 |
326055 | 326055 | 2020-07-12 | Trego | Kansas | 20195 | 2 | 0 |
329241 | 329241 | 2020-07-13 | Trego | Kansas | 20195 | 2 | 0 |
332428 | 332428 | 2020-07-14 | Trego | Kansas | 20195 | 2 | 0 |
335621 | 335621 | 2020-07-15 | Trego | Kansas | 20195 | 3 | 0 |
338817 | 338817 | 2020-07-16 | Trego | Kansas | 20195 | 3 | 0 |
342013 | 342013 | 2020-07-17 | Trego | Kansas | 20195 | 3 | 0 |
345213 | 345213 | 2020-07-18 | Trego | Kansas | 20195 | 3 | 0 |
348414 | 348414 | 2020-07-19 | Trego | Kansas | 20195 | 3 | 0 |
351614 | 351614 | 2020-07-20 | Trego | Kansas | 20195 | 3 | 0 |
354816 | 354816 | 2020-07-21 | Trego | Kansas | 20195 | 3 | 0 |
358018 | 358018 | 2020-07-22 | Trego | Kansas | 20195 | 3 | 0 |
361223 | 361223 | 2020-07-23 | Trego | Kansas | 20195 | 3 | 0 |
364430 | 364430 | 2020-07-24 | Trego | Kansas | 20195 | 3 | 0 |
367637 | 367637 | 2020-07-25 | Trego | Kansas | 20195 | 3 | 0 |
370847 | 370847 | 2020-07-26 | Trego | Kansas | 20195 | 3 | 0 |
374059 | 374059 | 2020-07-27 | Trego | Kansas | 20195 | 3 | 0 |
377274 | 377274 | 2020-07-28 | Trego | Kansas | 20195 | 3 | 0 |
380491 | 380491 | 2020-07-29 | Trego | Kansas | 20195 | 5 | 0 |
383708 | 383708 | 2020-07-30 | Trego | Kansas | 20195 | 5 | 0 |
386926 | 386926 | 2020-07-31 | Trego | Kansas | 20195 | 5 | 0 |
390143 | 390143 | 2020-08-01 | Trego | Kansas | 20195 | 5 | 0 |
393360 | 393360 | 2020-08-02 | Trego | Kansas | 20195 | 5 | 0 |
396576 | 396576 | 2020-08-03 | Trego | Kansas | 20195 | 5 | 0 |
399791 | 399791 | 2020-08-04 | Trego | Kansas | 20195 | 5 | 0 |
403008 | 403008 | 2020-08-05 | Trego | Kansas | 20195 | 5 | 0 |
406226 | 406226 | 2020-08-06 | Trego | Kansas | 20195 | 5 | 0 |
409445 | 409445 | 2020-08-07 | Trego | Kansas | 20195 | 6 | 0 |
412665 | 412665 | 2020-08-08 | Trego | Kansas | 20195 | 6 | 0 |
415885 | 415885 | 2020-08-09 | Trego | Kansas | 20195 | 6 | 0 |
419106 | 419106 | 2020-08-10 | Trego | Kansas | 20195 | 6 | 0 |
422329 | 422329 | 2020-08-11 | Trego | Kansas | 20195 | 6 | 0 |
425550 | 425550 | 2020-08-12 | Trego | Kansas | 20195 | 6 | 1 |
428774 | 428774 | 2020-08-13 | Trego | Kansas | 20195 | 6 | 1 |
432002 | 432002 | 2020-08-14 | Trego | Kansas | 20195 | 7 | 1 |
435227 | 435227 | 2020-08-15 | Trego | Kansas | 20195 | 7 | 1 |
438452 | 438452 | 2020-08-16 | Trego | Kansas | 20195 | 7 | 1 |
441679 | 441679 | 2020-08-17 | Trego | Kansas | 20195 | 7 | 1 |
444905 | 444905 | 2020-08-18 | Trego | Kansas | 20195 | 7 | 1 |
448132 | 448132 | 2020-08-19 | Trego | Kansas | 20195 | 7 | 1 |
451360 | 451360 | 2020-08-20 | Trego | Kansas | 20195 | 7 | 1 |
454588 | 454588 | 2020-08-21 | Trego | Kansas | 20195 | 7 | 1 |
457816 | 457816 | 2020-08-22 | Trego | Kansas | 20195 | 7 | 1 |
461043 | 461043 | 2020-08-23 | Trego | Kansas | 20195 | 7 | 1 |
464273 | 464273 | 2020-08-24 | Trego | Kansas | 20195 | 9 | 1 |
467502 | 467502 | 2020-08-25 | Trego | Kansas | 20195 | 9 | 1 |
470731 | 470731 | 2020-08-26 | Trego | Kansas | 20195 | 11 | 1 |
473963 | 473963 | 2020-08-27 | Trego | Kansas | 20195 | 11 | 1 |
477196 | 477196 | 2020-08-28 | Trego | Kansas | 20195 | 24 | 1 |
480429 | 480429 | 2020-08-29 | Trego | Kansas | 20195 | 24 | 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);