ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "McPherson" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947353 | 947353 | 2021-01-20 | McPherson | Kansas | 20113 | 2848 | 49 |
944106 | 944106 | 2021-01-19 | McPherson | Kansas | 20113 | 2796 | 48 |
940861 | 940861 | 2021-01-18 | McPherson | Kansas | 20113 | 2796 | 48 |
937616 | 937616 | 2021-01-17 | McPherson | Kansas | 20113 | 2796 | 48 |
934371 | 934371 | 2021-01-16 | McPherson | Kansas | 20113 | 2796 | 48 |
931126 | 931126 | 2021-01-15 | McPherson | Kansas | 20113 | 2796 | 48 |
927881 | 927881 | 2021-01-14 | McPherson | Kansas | 20113 | 2730 | 44 |
924635 | 924635 | 2021-01-13 | McPherson | Kansas | 20113 | 2730 | 44 |
921390 | 921390 | 2021-01-12 | McPherson | Kansas | 20113 | 2617 | 31 |
918145 | 918145 | 2021-01-11 | McPherson | Kansas | 20113 | 2617 | 31 |
914900 | 914900 | 2021-01-10 | McPherson | Kansas | 20113 | 2617 | 31 |
911655 | 911655 | 2021-01-09 | McPherson | Kansas | 20113 | 2617 | 31 |
908410 | 908410 | 2021-01-08 | McPherson | Kansas | 20113 | 2617 | 31 |
905164 | 905164 | 2021-01-07 | McPherson | Kansas | 20113 | 2545 | 31 |
901919 | 901919 | 2021-01-06 | McPherson | Kansas | 20113 | 2545 | 31 |
898674 | 898674 | 2021-01-05 | McPherson | Kansas | 20113 | 2545 | 31 |
895429 | 895429 | 2021-01-04 | McPherson | Kansas | 20113 | 2423 | 26 |
892182 | 892182 | 2021-01-03 | McPherson | Kansas | 20113 | 2385 | 26 |
888936 | 888936 | 2021-01-02 | McPherson | Kansas | 20113 | 2385 | 26 |
885690 | 885690 | 2021-01-01 | McPherson | Kansas | 20113 | 2385 | 26 |
882445 | 882445 | 2020-12-31 | McPherson | Kansas | 20113 | 2348 | 26 |
879200 | 879200 | 2020-12-30 | McPherson | Kansas | 20113 | 2348 | 26 |
875955 | 875955 | 2020-12-29 | McPherson | Kansas | 20113 | 2256 | 22 |
872710 | 872710 | 2020-12-28 | McPherson | Kansas | 20113 | 2256 | 22 |
869465 | 869465 | 2020-12-27 | McPherson | Kansas | 20113 | 2239 | 22 |
866220 | 866220 | 2020-12-26 | McPherson | Kansas | 20113 | 2239 | 22 |
862975 | 862975 | 2020-12-25 | McPherson | Kansas | 20113 | 2239 | 22 |
859730 | 859730 | 2020-12-24 | McPherson | Kansas | 20113 | 2239 | 22 |
856485 | 856485 | 2020-12-23 | McPherson | Kansas | 20113 | 2239 | 22 |
853240 | 853240 | 2020-12-22 | McPherson | Kansas | 20113 | 2239 | 22 |
849995 | 849995 | 2020-12-21 | McPherson | Kansas | 20113 | 2239 | 22 |
846750 | 846750 | 2020-12-20 | McPherson | Kansas | 20113 | 2187 | 22 |
843504 | 843504 | 2020-12-19 | McPherson | Kansas | 20113 | 2187 | 22 |
840259 | 840259 | 2020-12-18 | McPherson | Kansas | 20113 | 2187 | 22 |
837014 | 837014 | 2020-12-17 | McPherson | Kansas | 20113 | 2114 | 22 |
833768 | 833768 | 2020-12-16 | McPherson | Kansas | 20113 | 2114 | 22 |
830521 | 830521 | 2020-12-15 | McPherson | Kansas | 20113 | 2023 | 19 |
827275 | 827275 | 2020-12-14 | McPherson | Kansas | 20113 | 1949 | 14 |
824028 | 824028 | 2020-12-13 | McPherson | Kansas | 20113 | 1949 | 14 |
820782 | 820782 | 2020-12-12 | McPherson | Kansas | 20113 | 1949 | 14 |
817536 | 817536 | 2020-12-11 | McPherson | Kansas | 20113 | 1949 | 14 |
814290 | 814290 | 2020-12-10 | McPherson | Kansas | 20113 | 1779 | 11 |
811045 | 811045 | 2020-12-09 | McPherson | Kansas | 20113 | 1779 | 11 |
807800 | 807800 | 2020-12-08 | McPherson | Kansas | 20113 | 1779 | 11 |
804555 | 804555 | 2020-12-07 | McPherson | Kansas | 20113 | 1779 | 11 |
801310 | 801310 | 2020-12-06 | McPherson | Kansas | 20113 | 1679 | 11 |
798065 | 798065 | 2020-12-05 | McPherson | Kansas | 20113 | 1679 | 11 |
794820 | 794820 | 2020-12-04 | McPherson | Kansas | 20113 | 1679 | 11 |
791575 | 791575 | 2020-12-03 | McPherson | Kansas | 20113 | 1590 | 11 |
788330 | 788330 | 2020-12-02 | McPherson | Kansas | 20113 | 1522 | 10 |
785086 | 785086 | 2020-12-01 | McPherson | Kansas | 20113 | 1447 | 9 |
781841 | 781841 | 2020-11-30 | McPherson | Kansas | 20113 | 1447 | 9 |
778595 | 778595 | 2020-11-29 | McPherson | Kansas | 20113 | 1380 | 9 |
775350 | 775350 | 2020-11-28 | McPherson | Kansas | 20113 | 1380 | 9 |
772105 | 772105 | 2020-11-27 | McPherson | Kansas | 20113 | 1380 | 9 |
768860 | 768860 | 2020-11-26 | McPherson | Kansas | 20113 | 1321 | 9 |
765614 | 765614 | 2020-11-25 | McPherson | Kansas | 20113 | 1321 | 9 |
762369 | 762369 | 2020-11-24 | McPherson | Kansas | 20113 | 1249 | 9 |
759124 | 759124 | 2020-11-23 | McPherson | Kansas | 20113 | 1249 | 9 |
755877 | 755877 | 2020-11-22 | McPherson | Kansas | 20113 | 1248 | 9 |
752631 | 752631 | 2020-11-21 | McPherson | Kansas | 20113 | 1157 | 8 |
749385 | 749385 | 2020-11-20 | McPherson | Kansas | 20113 | 1157 | 8 |
746139 | 746139 | 2020-11-19 | McPherson | Kansas | 20113 | 1150 | 8 |
742892 | 742892 | 2020-11-18 | McPherson | Kansas | 20113 | 1150 | 8 |
739645 | 739645 | 2020-11-17 | McPherson | Kansas | 20113 | 1063 | 8 |
736401 | 736401 | 2020-11-16 | McPherson | Kansas | 20113 | 993 | 8 |
733155 | 733155 | 2020-11-15 | McPherson | Kansas | 20113 | 874 | 8 |
729910 | 729910 | 2020-11-14 | McPherson | Kansas | 20113 | 874 | 8 |
726667 | 726667 | 2020-11-13 | McPherson | Kansas | 20113 | 874 | 8 |
723424 | 723424 | 2020-11-12 | McPherson | Kansas | 20113 | 802 | 8 |
720181 | 720181 | 2020-11-11 | McPherson | Kansas | 20113 | 789 | 8 |
716938 | 716938 | 2020-11-10 | McPherson | Kansas | 20113 | 728 | 8 |
713694 | 713694 | 2020-11-09 | McPherson | Kansas | 20113 | 690 | 8 |
710450 | 710450 | 2020-11-08 | McPherson | Kansas | 20113 | 657 | 8 |
707206 | 707206 | 2020-11-07 | McPherson | Kansas | 20113 | 657 | 8 |
703963 | 703963 | 2020-11-06 | McPherson | Kansas | 20113 | 657 | 8 |
700721 | 700721 | 2020-11-05 | McPherson | Kansas | 20113 | 522 | 7 |
697477 | 697477 | 2020-11-04 | McPherson | Kansas | 20113 | 522 | 7 |
694235 | 694235 | 2020-11-03 | McPherson | Kansas | 20113 | 522 | 7 |
690992 | 690992 | 2020-11-02 | McPherson | Kansas | 20113 | 470 | 7 |
687747 | 687747 | 2020-11-01 | McPherson | Kansas | 20113 | 455 | 7 |
684503 | 684503 | 2020-10-31 | McPherson | Kansas | 20113 | 455 | 7 |
681260 | 681260 | 2020-10-30 | McPherson | Kansas | 20113 | 455 | 7 |
678017 | 678017 | 2020-10-29 | McPherson | Kansas | 20113 | 428 | 7 |
674774 | 674774 | 2020-10-28 | McPherson | Kansas | 20113 | 395 | 6 |
671532 | 671532 | 2020-10-27 | McPherson | Kansas | 20113 | 395 | 6 |
668289 | 668289 | 2020-10-26 | McPherson | Kansas | 20113 | 373 | 6 |
665045 | 665045 | 2020-10-25 | McPherson | Kansas | 20113 | 373 | 6 |
661800 | 661800 | 2020-10-24 | McPherson | Kansas | 20113 | 373 | 6 |
658556 | 658556 | 2020-10-23 | McPherson | Kansas | 20113 | 373 | 6 |
655311 | 655311 | 2020-10-22 | McPherson | Kansas | 20113 | 355 | 6 |
652066 | 652066 | 2020-10-21 | McPherson | Kansas | 20113 | 355 | 6 |
648822 | 648822 | 2020-10-20 | McPherson | Kansas | 20113 | 342 | 3 |
645577 | 645577 | 2020-10-19 | McPherson | Kansas | 20113 | 342 | 3 |
642330 | 642330 | 2020-10-18 | McPherson | Kansas | 20113 | 313 | 3 |
639083 | 639083 | 2020-10-17 | McPherson | Kansas | 20113 | 313 | 3 |
635837 | 635837 | 2020-10-16 | McPherson | Kansas | 20113 | 313 | 3 |
632591 | 632591 | 2020-10-15 | McPherson | Kansas | 20113 | 313 | 3 |
629347 | 629347 | 2020-10-14 | McPherson | Kansas | 20113 | 313 | 3 |
626104 | 626104 | 2020-10-13 | McPherson | Kansas | 20113 | 303 | 3 |
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);