ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
628 rows where fips = 20199 and state = "Kansas" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
464275 | 464275 | 2020-08-24 | Wallace | Kansas | 20199 | 1 | 0 |
467504 | 467504 | 2020-08-25 | Wallace | Kansas | 20199 | 1 | 0 |
470733 | 470733 | 2020-08-26 | Wallace | Kansas | 20199 | 1 | 0 |
473965 | 473965 | 2020-08-27 | Wallace | Kansas | 20199 | 1 | 0 |
477198 | 477198 | 2020-08-28 | Wallace | Kansas | 20199 | 1 | 0 |
480431 | 480431 | 2020-08-29 | Wallace | Kansas | 20199 | 1 | 0 |
483665 | 483665 | 2020-08-30 | Wallace | Kansas | 20199 | 1 | 0 |
486900 | 486900 | 2020-08-31 | Wallace | Kansas | 20199 | 4 | 0 |
490133 | 490133 | 2020-09-01 | Wallace | Kansas | 20199 | 4 | 0 |
493367 | 493367 | 2020-09-02 | Wallace | Kansas | 20199 | 5 | 0 |
496600 | 496600 | 2020-09-03 | Wallace | Kansas | 20199 | 5 | 0 |
499834 | 499834 | 2020-09-04 | Wallace | Kansas | 20199 | 10 | 0 |
503067 | 503067 | 2020-09-05 | Wallace | Kansas | 20199 | 10 | 0 |
506301 | 506301 | 2020-09-06 | Wallace | Kansas | 20199 | 10 | 0 |
509534 | 509534 | 2020-09-07 | Wallace | Kansas | 20199 | 10 | 0 |
512766 | 512766 | 2020-09-08 | Wallace | Kansas | 20199 | 10 | 0 |
515999 | 515999 | 2020-09-09 | Wallace | Kansas | 20199 | 10 | 0 |
519234 | 519234 | 2020-09-10 | Wallace | Kansas | 20199 | 10 | 0 |
522471 | 522471 | 2020-09-11 | Wallace | Kansas | 20199 | 12 | 0 |
525707 | 525707 | 2020-09-12 | Wallace | Kansas | 20199 | 12 | 0 |
528943 | 528943 | 2020-09-13 | Wallace | Kansas | 20199 | 12 | 0 |
532180 | 532180 | 2020-09-14 | Wallace | Kansas | 20199 | 14 | 0 |
535415 | 535415 | 2020-09-15 | Wallace | Kansas | 20199 | 14 | 0 |
538652 | 538652 | 2020-09-16 | Wallace | Kansas | 20199 | 16 | 0 |
541888 | 541888 | 2020-09-17 | Wallace | Kansas | 20199 | 16 | 0 |
545124 | 545124 | 2020-09-18 | Wallace | Kansas | 20199 | 16 | 0 |
548362 | 548362 | 2020-09-19 | Wallace | Kansas | 20199 | 16 | 0 |
551601 | 551601 | 2020-09-20 | Wallace | Kansas | 20199 | 16 | 0 |
554840 | 554840 | 2020-09-21 | Wallace | Kansas | 20199 | 17 | 0 |
558077 | 558077 | 2020-09-22 | Wallace | Kansas | 20199 | 17 | 0 |
561313 | 561313 | 2020-09-23 | Wallace | Kansas | 20199 | 17 | 0 |
564553 | 564553 | 2020-09-24 | Wallace | Kansas | 20199 | 17 | 0 |
567793 | 567793 | 2020-09-25 | Wallace | Kansas | 20199 | 17 | 0 |
571035 | 571035 | 2020-09-26 | Wallace | Kansas | 20199 | 17 | 0 |
574278 | 574278 | 2020-09-27 | Wallace | Kansas | 20199 | 17 | 0 |
577520 | 577520 | 2020-09-28 | Wallace | Kansas | 20199 | 18 | 0 |
580761 | 580761 | 2020-09-29 | Wallace | Kansas | 20199 | 18 | 0 |
584001 | 584001 | 2020-09-30 | Wallace | Kansas | 20199 | 19 | 0 |
587241 | 587241 | 2020-10-01 | Wallace | Kansas | 20199 | 19 | 0 |
590482 | 590482 | 2020-10-02 | Wallace | Kansas | 20199 | 19 | 0 |
593723 | 593723 | 2020-10-03 | Wallace | Kansas | 20199 | 19 | 0 |
596965 | 596965 | 2020-10-04 | Wallace | Kansas | 20199 | 19 | 0 |
600207 | 600207 | 2020-10-05 | Wallace | Kansas | 20199 | 19 | 0 |
603450 | 603450 | 2020-10-06 | Wallace | Kansas | 20199 | 19 | 0 |
606692 | 606692 | 2020-10-07 | Wallace | Kansas | 20199 | 20 | 0 |
609934 | 609934 | 2020-10-08 | Wallace | Kansas | 20199 | 20 | 0 |
613176 | 613176 | 2020-10-09 | Wallace | Kansas | 20199 | 20 | 0 |
616417 | 616417 | 2020-10-10 | Wallace | Kansas | 20199 | 20 | 0 |
619659 | 619659 | 2020-10-11 | Wallace | Kansas | 20199 | 20 | 0 |
622903 | 622903 | 2020-10-12 | Wallace | Kansas | 20199 | 23 | 0 |
626145 | 626145 | 2020-10-13 | Wallace | Kansas | 20199 | 23 | 0 |
629389 | 629389 | 2020-10-14 | Wallace | Kansas | 20199 | 23 | 0 |
632633 | 632633 | 2020-10-15 | Wallace | Kansas | 20199 | 23 | 0 |
635879 | 635879 | 2020-10-16 | Wallace | Kansas | 20199 | 27 | 0 |
639125 | 639125 | 2020-10-17 | Wallace | Kansas | 20199 | 27 | 0 |
642372 | 642372 | 2020-10-18 | Wallace | Kansas | 20199 | 27 | 0 |
645619 | 645619 | 2020-10-19 | Wallace | Kansas | 20199 | 29 | 0 |
648863 | 648863 | 2020-10-20 | Wallace | Kansas | 20199 | 29 | 0 |
652108 | 652108 | 2020-10-21 | Wallace | Kansas | 20199 | 30 | 0 |
655353 | 655353 | 2020-10-22 | Wallace | Kansas | 20199 | 30 | 0 |
658598 | 658598 | 2020-10-23 | Wallace | Kansas | 20199 | 36 | 0 |
661842 | 661842 | 2020-10-24 | Wallace | Kansas | 20199 | 36 | 0 |
665087 | 665087 | 2020-10-25 | Wallace | Kansas | 20199 | 36 | 0 |
668331 | 668331 | 2020-10-26 | Wallace | Kansas | 20199 | 40 | 0 |
671573 | 671573 | 2020-10-27 | Wallace | Kansas | 20199 | 52 | 0 |
674816 | 674816 | 2020-10-28 | Wallace | Kansas | 20199 | 59 | 0 |
678058 | 678058 | 2020-10-29 | Wallace | Kansas | 20199 | 59 | 0 |
681302 | 681302 | 2020-10-30 | Wallace | Kansas | 20199 | 67 | 0 |
684545 | 684545 | 2020-10-31 | Wallace | Kansas | 20199 | 67 | 0 |
687789 | 687789 | 2020-11-01 | Wallace | Kansas | 20199 | 67 | 0 |
691034 | 691034 | 2020-11-02 | Wallace | Kansas | 20199 | 82 | 0 |
694276 | 694276 | 2020-11-03 | Wallace | Kansas | 20199 | 82 | 0 |
697519 | 697519 | 2020-11-04 | Wallace | Kansas | 20199 | 89 | 0 |
700763 | 700763 | 2020-11-05 | Wallace | Kansas | 20199 | 89 | 0 |
704005 | 704005 | 2020-11-06 | Wallace | Kansas | 20199 | 97 | 0 |
707248 | 707248 | 2020-11-07 | Wallace | Kansas | 20199 | 97 | 0 |
710492 | 710492 | 2020-11-08 | Wallace | Kansas | 20199 | 97 | 0 |
713736 | 713736 | 2020-11-09 | Wallace | Kansas | 20199 | 104 | 0 |
716980 | 716980 | 2020-11-10 | Wallace | Kansas | 20199 | 104 | 0 |
720223 | 720223 | 2020-11-11 | Wallace | Kansas | 20199 | 107 | 0 |
723466 | 723466 | 2020-11-12 | Wallace | Kansas | 20199 | 107 | 0 |
726709 | 726709 | 2020-11-13 | Wallace | Kansas | 20199 | 116 | 0 |
729952 | 729952 | 2020-11-14 | Wallace | Kansas | 20199 | 118 | 0 |
733197 | 733197 | 2020-11-15 | Wallace | Kansas | 20199 | 118 | 0 |
736443 | 736443 | 2020-11-16 | Wallace | Kansas | 20199 | 124 | 0 |
739687 | 739687 | 2020-11-17 | Wallace | Kansas | 20199 | 124 | 0 |
742934 | 742934 | 2020-11-18 | Wallace | Kansas | 20199 | 128 | 0 |
746181 | 746181 | 2020-11-19 | Wallace | Kansas | 20199 | 128 | 0 |
749427 | 749427 | 2020-11-20 | Wallace | Kansas | 20199 | 133 | 0 |
752673 | 752673 | 2020-11-21 | Wallace | Kansas | 20199 | 133 | 0 |
755919 | 755919 | 2020-11-22 | Wallace | Kansas | 20199 | 133 | 0 |
759166 | 759166 | 2020-11-23 | Wallace | Kansas | 20199 | 135 | 0 |
762411 | 762411 | 2020-11-24 | Wallace | Kansas | 20199 | 135 | 0 |
765656 | 765656 | 2020-11-25 | Wallace | Kansas | 20199 | 137 | 0 |
768902 | 768902 | 2020-11-26 | Wallace | Kansas | 20199 | 137 | 0 |
772147 | 772147 | 2020-11-27 | Wallace | Kansas | 20199 | 137 | 0 |
775392 | 775392 | 2020-11-28 | Wallace | Kansas | 20199 | 137 | 0 |
778637 | 778637 | 2020-11-29 | Wallace | Kansas | 20199 | 137 | 0 |
781883 | 781883 | 2020-11-30 | Wallace | Kansas | 20199 | 137 | 0 |
785128 | 785128 | 2020-12-01 | Wallace | Kansas | 20199 | 138 | 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);