ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 20143 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635850 | 635850 | 2020-10-16 | Ottawa | Kansas | 20143 | 104 | 0 |
632604 | 632604 | 2020-10-15 | Ottawa | Kansas | 20143 | 97 | 0 |
629360 | 629360 | 2020-10-14 | Ottawa | Kansas | 20143 | 97 | 0 |
626117 | 626117 | 2020-10-13 | Ottawa | Kansas | 20143 | 94 | 0 |
622875 | 622875 | 2020-10-12 | Ottawa | Kansas | 20143 | 94 | 0 |
619631 | 619631 | 2020-10-11 | Ottawa | Kansas | 20143 | 91 | 0 |
616389 | 616389 | 2020-10-10 | Ottawa | Kansas | 20143 | 91 | 0 |
613148 | 613148 | 2020-10-09 | Ottawa | Kansas | 20143 | 91 | 0 |
609906 | 609906 | 2020-10-08 | Ottawa | Kansas | 20143 | 78 | 0 |
606663 | 606663 | 2020-10-07 | Ottawa | Kansas | 20143 | 78 | 0 |
603421 | 603421 | 2020-10-06 | Ottawa | Kansas | 20143 | 61 | 0 |
600178 | 600178 | 2020-10-05 | Ottawa | Kansas | 20143 | 61 | 0 |
596936 | 596936 | 2020-10-04 | Ottawa | Kansas | 20143 | 59 | 0 |
593694 | 593694 | 2020-10-03 | Ottawa | Kansas | 20143 | 59 | 0 |
590453 | 590453 | 2020-10-02 | Ottawa | Kansas | 20143 | 59 | 0 |
587212 | 587212 | 2020-10-01 | Ottawa | Kansas | 20143 | 58 | 0 |
583972 | 583972 | 2020-09-30 | Ottawa | Kansas | 20143 | 58 | 0 |
580733 | 580733 | 2020-09-29 | Ottawa | Kansas | 20143 | 56 | 0 |
577492 | 577492 | 2020-09-28 | Ottawa | Kansas | 20143 | 56 | 0 |
574250 | 574250 | 2020-09-27 | Ottawa | Kansas | 20143 | 53 | 0 |
571007 | 571007 | 2020-09-26 | Ottawa | Kansas | 20143 | 53 | 0 |
567765 | 567765 | 2020-09-25 | Ottawa | Kansas | 20143 | 53 | 0 |
564525 | 564525 | 2020-09-24 | Ottawa | Kansas | 20143 | 52 | 0 |
561285 | 561285 | 2020-09-23 | Ottawa | Kansas | 20143 | 52 | 0 |
558049 | 558049 | 2020-09-22 | Ottawa | Kansas | 20143 | 50 | 0 |
554812 | 554812 | 2020-09-21 | Ottawa | Kansas | 20143 | 50 | 0 |
551573 | 551573 | 2020-09-20 | Ottawa | Kansas | 20143 | 48 | 0 |
548334 | 548334 | 2020-09-19 | Ottawa | Kansas | 20143 | 48 | 0 |
545096 | 545096 | 2020-09-18 | Ottawa | Kansas | 20143 | 48 | 0 |
541860 | 541860 | 2020-09-17 | Ottawa | Kansas | 20143 | 48 | 0 |
538623 | 538623 | 2020-09-16 | Ottawa | Kansas | 20143 | 48 | 0 |
535387 | 535387 | 2020-09-15 | Ottawa | Kansas | 20143 | 48 | 0 |
532152 | 532152 | 2020-09-14 | Ottawa | Kansas | 20143 | 48 | 0 |
528915 | 528915 | 2020-09-13 | Ottawa | Kansas | 20143 | 48 | 0 |
525679 | 525679 | 2020-09-12 | Ottawa | Kansas | 20143 | 48 | 0 |
522443 | 522443 | 2020-09-11 | Ottawa | Kansas | 20143 | 48 | 0 |
519206 | 519206 | 2020-09-10 | Ottawa | Kansas | 20143 | 48 | 0 |
515971 | 515971 | 2020-09-09 | Ottawa | Kansas | 20143 | 48 | 0 |
512738 | 512738 | 2020-09-08 | Ottawa | Kansas | 20143 | 48 | 0 |
509505 | 509505 | 2020-09-07 | Ottawa | Kansas | 20143 | 48 | 0 |
506273 | 506273 | 2020-09-06 | Ottawa | Kansas | 20143 | 47 | 0 |
503039 | 503039 | 2020-09-05 | Ottawa | Kansas | 20143 | 47 | 0 |
499805 | 499805 | 2020-09-04 | Ottawa | Kansas | 20143 | 47 | 0 |
496572 | 496572 | 2020-09-03 | Ottawa | Kansas | 20143 | 46 | 0 |
493338 | 493338 | 2020-09-02 | Ottawa | Kansas | 20143 | 46 | 0 |
490105 | 490105 | 2020-09-01 | Ottawa | Kansas | 20143 | 43 | 0 |
486872 | 486872 | 2020-08-31 | Ottawa | Kansas | 20143 | 43 | 0 |
483637 | 483637 | 2020-08-30 | Ottawa | Kansas | 20143 | 40 | 0 |
480403 | 480403 | 2020-08-29 | Ottawa | Kansas | 20143 | 40 | 0 |
477170 | 477170 | 2020-08-28 | Ottawa | Kansas | 20143 | 40 | 0 |
473937 | 473937 | 2020-08-27 | Ottawa | Kansas | 20143 | 40 | 0 |
470705 | 470705 | 2020-08-26 | Ottawa | Kansas | 20143 | 40 | 0 |
467476 | 467476 | 2020-08-25 | Ottawa | Kansas | 20143 | 39 | 0 |
464247 | 464247 | 2020-08-24 | Ottawa | Kansas | 20143 | 39 | 0 |
461018 | 461018 | 2020-08-23 | Ottawa | Kansas | 20143 | 39 | 0 |
457791 | 457791 | 2020-08-22 | Ottawa | Kansas | 20143 | 39 | 0 |
454563 | 454563 | 2020-08-21 | Ottawa | Kansas | 20143 | 39 | 0 |
451335 | 451335 | 2020-08-20 | Ottawa | Kansas | 20143 | 39 | 0 |
448107 | 448107 | 2020-08-19 | Ottawa | Kansas | 20143 | 39 | 0 |
444880 | 444880 | 2020-08-18 | Ottawa | Kansas | 20143 | 39 | 0 |
441654 | 441654 | 2020-08-17 | Ottawa | Kansas | 20143 | 39 | 0 |
438427 | 438427 | 2020-08-16 | Ottawa | Kansas | 20143 | 37 | 0 |
435202 | 435202 | 2020-08-15 | Ottawa | Kansas | 20143 | 37 | 0 |
431977 | 431977 | 2020-08-14 | Ottawa | Kansas | 20143 | 37 | 0 |
428749 | 428749 | 2020-08-13 | Ottawa | Kansas | 20143 | 35 | 0 |
425525 | 425525 | 2020-08-12 | Ottawa | Kansas | 20143 | 35 | 0 |
422304 | 422304 | 2020-08-11 | Ottawa | Kansas | 20143 | 35 | 0 |
419081 | 419081 | 2020-08-10 | Ottawa | Kansas | 20143 | 35 | 0 |
415860 | 415860 | 2020-08-09 | Ottawa | Kansas | 20143 | 34 | 0 |
412640 | 412640 | 2020-08-08 | Ottawa | Kansas | 20143 | 34 | 0 |
409420 | 409420 | 2020-08-07 | Ottawa | Kansas | 20143 | 34 | 0 |
406201 | 406201 | 2020-08-06 | Ottawa | Kansas | 20143 | 32 | 0 |
402983 | 402983 | 2020-08-05 | Ottawa | Kansas | 20143 | 32 | 0 |
399766 | 399766 | 2020-08-04 | Ottawa | Kansas | 20143 | 30 | 0 |
396551 | 396551 | 2020-08-03 | Ottawa | Kansas | 20143 | 30 | 0 |
393335 | 393335 | 2020-08-02 | Ottawa | Kansas | 20143 | 30 | 0 |
390118 | 390118 | 2020-08-01 | Ottawa | Kansas | 20143 | 30 | 0 |
386901 | 386901 | 2020-07-31 | Ottawa | Kansas | 20143 | 30 | 0 |
383683 | 383683 | 2020-07-30 | Ottawa | Kansas | 20143 | 30 | 0 |
380466 | 380466 | 2020-07-29 | Ottawa | Kansas | 20143 | 30 | 0 |
377249 | 377249 | 2020-07-28 | Ottawa | Kansas | 20143 | 30 | 0 |
374034 | 374034 | 2020-07-27 | Ottawa | Kansas | 20143 | 30 | 0 |
370822 | 370822 | 2020-07-26 | Ottawa | Kansas | 20143 | 28 | 0 |
367612 | 367612 | 2020-07-25 | Ottawa | Kansas | 20143 | 28 | 0 |
364405 | 364405 | 2020-07-24 | Ottawa | Kansas | 20143 | 28 | 0 |
361198 | 361198 | 2020-07-23 | Ottawa | Kansas | 20143 | 26 | 0 |
357993 | 357993 | 2020-07-22 | Ottawa | Kansas | 20143 | 26 | 0 |
354791 | 354791 | 2020-07-21 | Ottawa | Kansas | 20143 | 26 | 0 |
351589 | 351589 | 2020-07-20 | Ottawa | Kansas | 20143 | 26 | 0 |
348389 | 348389 | 2020-07-19 | Ottawa | Kansas | 20143 | 22 | 0 |
345188 | 345188 | 2020-07-18 | Ottawa | Kansas | 20143 | 22 | 0 |
341988 | 341988 | 2020-07-17 | Ottawa | Kansas | 20143 | 22 | 0 |
338792 | 338792 | 2020-07-16 | Ottawa | Kansas | 20143 | 20 | 0 |
335596 | 335596 | 2020-07-15 | Ottawa | Kansas | 20143 | 20 | 0 |
332403 | 332403 | 2020-07-14 | Ottawa | Kansas | 20143 | 20 | 0 |
329216 | 329216 | 2020-07-13 | Ottawa | Kansas | 20143 | 20 | 0 |
326030 | 326030 | 2020-07-12 | Ottawa | Kansas | 20143 | 15 | 0 |
322847 | 322847 | 2020-07-11 | Ottawa | Kansas | 20143 | 15 | 0 |
319668 | 319668 | 2020-07-10 | Ottawa | Kansas | 20143 | 15 | 0 |
316494 | 316494 | 2020-07-09 | Ottawa | Kansas | 20143 | 12 | 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);