ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
751 rows where county = "Clark" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947307 | 947307 | 2021-01-20 | Clark | Kansas | 20025 | 222 | 4 |
944060 | 944060 | 2021-01-19 | Clark | Kansas | 20025 | 220 | 4 |
940815 | 940815 | 2021-01-18 | Clark | Kansas | 20025 | 220 | 4 |
937570 | 937570 | 2021-01-17 | Clark | Kansas | 20025 | 215 | 4 |
934325 | 934325 | 2021-01-16 | Clark | Kansas | 20025 | 215 | 4 |
931080 | 931080 | 2021-01-15 | Clark | Kansas | 20025 | 215 | 4 |
927835 | 927835 | 2021-01-14 | Clark | Kansas | 20025 | 212 | 4 |
924589 | 924589 | 2021-01-13 | Clark | Kansas | 20025 | 212 | 4 |
921344 | 921344 | 2021-01-12 | Clark | Kansas | 20025 | 207 | 4 |
918099 | 918099 | 2021-01-11 | Clark | Kansas | 20025 | 207 | 4 |
914854 | 914854 | 2021-01-10 | Clark | Kansas | 20025 | 205 | 4 |
911609 | 911609 | 2021-01-09 | Clark | Kansas | 20025 | 205 | 4 |
908364 | 908364 | 2021-01-08 | Clark | Kansas | 20025 | 205 | 4 |
905118 | 905118 | 2021-01-07 | Clark | Kansas | 20025 | 203 | 4 |
901873 | 901873 | 2021-01-06 | Clark | Kansas | 20025 | 203 | 4 |
898628 | 898628 | 2021-01-05 | Clark | Kansas | 20025 | 198 | 4 |
895383 | 895383 | 2021-01-04 | Clark | Kansas | 20025 | 198 | 4 |
892136 | 892136 | 2021-01-03 | Clark | Kansas | 20025 | 195 | 4 |
888890 | 888890 | 2021-01-02 | Clark | Kansas | 20025 | 195 | 4 |
885644 | 885644 | 2021-01-01 | Clark | Kansas | 20025 | 195 | 4 |
882399 | 882399 | 2020-12-31 | Clark | Kansas | 20025 | 191 | 4 |
879154 | 879154 | 2020-12-30 | Clark | Kansas | 20025 | 191 | 4 |
875909 | 875909 | 2020-12-29 | Clark | Kansas | 20025 | 189 | 4 |
872664 | 872664 | 2020-12-28 | Clark | Kansas | 20025 | 189 | 4 |
869419 | 869419 | 2020-12-27 | Clark | Kansas | 20025 | 183 | 4 |
866174 | 866174 | 2020-12-26 | Clark | Kansas | 20025 | 183 | 4 |
862929 | 862929 | 2020-12-25 | Clark | Kansas | 20025 | 183 | 4 |
859684 | 859684 | 2020-12-24 | Clark | Kansas | 20025 | 183 | 4 |
856439 | 856439 | 2020-12-23 | Clark | Kansas | 20025 | 183 | 4 |
853194 | 853194 | 2020-12-22 | Clark | Kansas | 20025 | 181 | 4 |
849949 | 849949 | 2020-12-21 | Clark | Kansas | 20025 | 181 | 4 |
846704 | 846704 | 2020-12-20 | Clark | Kansas | 20025 | 180 | 4 |
843458 | 843458 | 2020-12-19 | Clark | Kansas | 20025 | 180 | 4 |
840213 | 840213 | 2020-12-18 | Clark | Kansas | 20025 | 180 | 4 |
836968 | 836968 | 2020-12-17 | Clark | Kansas | 20025 | 176 | 4 |
833722 | 833722 | 2020-12-16 | Clark | Kansas | 20025 | 176 | 4 |
830475 | 830475 | 2020-12-15 | Clark | Kansas | 20025 | 171 | 4 |
827229 | 827229 | 2020-12-14 | Clark | Kansas | 20025 | 171 | 4 |
823982 | 823982 | 2020-12-13 | Clark | Kansas | 20025 | 167 | 4 |
820736 | 820736 | 2020-12-12 | Clark | Kansas | 20025 | 167 | 4 |
817490 | 817490 | 2020-12-11 | Clark | Kansas | 20025 | 167 | 4 |
814244 | 814244 | 2020-12-10 | Clark | Kansas | 20025 | 164 | 4 |
810999 | 810999 | 2020-12-09 | Clark | Kansas | 20025 | 164 | 4 |
807754 | 807754 | 2020-12-08 | Clark | Kansas | 20025 | 154 | 4 |
804509 | 804509 | 2020-12-07 | Clark | Kansas | 20025 | 154 | 4 |
801264 | 801264 | 2020-12-06 | Clark | Kansas | 20025 | 148 | 4 |
798019 | 798019 | 2020-12-05 | Clark | Kansas | 20025 | 148 | 4 |
794774 | 794774 | 2020-12-04 | Clark | Kansas | 20025 | 148 | 4 |
791529 | 791529 | 2020-12-03 | Clark | Kansas | 20025 | 145 | 4 |
788284 | 788284 | 2020-12-02 | Clark | Kansas | 20025 | 145 | 4 |
785040 | 785040 | 2020-12-01 | Clark | Kansas | 20025 | 140 | 4 |
781795 | 781795 | 2020-11-30 | Clark | Kansas | 20025 | 140 | 4 |
778549 | 778549 | 2020-11-29 | Clark | Kansas | 20025 | 130 | 4 |
775304 | 775304 | 2020-11-28 | Clark | Kansas | 20025 | 130 | 4 |
772059 | 772059 | 2020-11-27 | Clark | Kansas | 20025 | 130 | 4 |
768814 | 768814 | 2020-11-26 | Clark | Kansas | 20025 | 123 | 4 |
765568 | 765568 | 2020-11-25 | Clark | Kansas | 20025 | 123 | 4 |
762323 | 762323 | 2020-11-24 | Clark | Kansas | 20025 | 109 | 4 |
759078 | 759078 | 2020-11-23 | Clark | Kansas | 20025 | 109 | 4 |
755831 | 755831 | 2020-11-22 | Clark | Kansas | 20025 | 100 | 4 |
752585 | 752585 | 2020-11-21 | Clark | Kansas | 20025 | 100 | 4 |
749339 | 749339 | 2020-11-20 | Clark | Kansas | 20025 | 100 | 4 |
746093 | 746093 | 2020-11-19 | Clark | Kansas | 20025 | 95 | 4 |
742846 | 742846 | 2020-11-18 | Clark | Kansas | 20025 | 95 | 4 |
739599 | 739599 | 2020-11-17 | Clark | Kansas | 20025 | 91 | 4 |
736355 | 736355 | 2020-11-16 | Clark | Kansas | 20025 | 91 | 4 |
733109 | 733109 | 2020-11-15 | Clark | Kansas | 20025 | 88 | 4 |
729864 | 729864 | 2020-11-14 | Clark | Kansas | 20025 | 88 | 4 |
726621 | 726621 | 2020-11-13 | Clark | Kansas | 20025 | 88 | 4 |
723378 | 723378 | 2020-11-12 | Clark | Kansas | 20025 | 84 | 4 |
720135 | 720135 | 2020-11-11 | Clark | Kansas | 20025 | 84 | 4 |
716892 | 716892 | 2020-11-10 | Clark | Kansas | 20025 | 82 | 4 |
713648 | 713648 | 2020-11-09 | Clark | Kansas | 20025 | 82 | 4 |
710404 | 710404 | 2020-11-08 | Clark | Kansas | 20025 | 80 | 4 |
707160 | 707160 | 2020-11-07 | Clark | Kansas | 20025 | 80 | 4 |
703917 | 703917 | 2020-11-06 | Clark | Kansas | 20025 | 80 | 4 |
700675 | 700675 | 2020-11-05 | Clark | Kansas | 20025 | 77 | 4 |
697431 | 697431 | 2020-11-04 | Clark | Kansas | 20025 | 77 | 4 |
694189 | 694189 | 2020-11-03 | Clark | Kansas | 20025 | 75 | 4 |
690946 | 690946 | 2020-11-02 | Clark | Kansas | 20025 | 75 | 4 |
687701 | 687701 | 2020-11-01 | Clark | Kansas | 20025 | 75 | 4 |
684457 | 684457 | 2020-10-31 | Clark | Kansas | 20025 | 75 | 4 |
681214 | 681214 | 2020-10-30 | Clark | Kansas | 20025 | 75 | 4 |
677971 | 677971 | 2020-10-29 | Clark | Kansas | 20025 | 70 | 4 |
674728 | 674728 | 2020-10-28 | Clark | Kansas | 20025 | 70 | 1 |
671486 | 671486 | 2020-10-27 | Clark | Kansas | 20025 | 68 | 1 |
668243 | 668243 | 2020-10-26 | Clark | Kansas | 20025 | 68 | 1 |
664999 | 664999 | 2020-10-25 | Clark | Kansas | 20025 | 67 | 1 |
661754 | 661754 | 2020-10-24 | Clark | Kansas | 20025 | 67 | 1 |
658510 | 658510 | 2020-10-23 | Clark | Kansas | 20025 | 67 | 1 |
655265 | 655265 | 2020-10-22 | Clark | Kansas | 20025 | 63 | 1 |
652020 | 652020 | 2020-10-21 | Clark | Kansas | 20025 | 63 | 1 |
648776 | 648776 | 2020-10-20 | Clark | Kansas | 20025 | 62 | 1 |
645531 | 645531 | 2020-10-19 | Clark | Kansas | 20025 | 62 | 1 |
642284 | 642284 | 2020-10-18 | Clark | Kansas | 20025 | 61 | 1 |
639037 | 639037 | 2020-10-17 | Clark | Kansas | 20025 | 61 | 1 |
635791 | 635791 | 2020-10-16 | Clark | Kansas | 20025 | 61 | 1 |
632545 | 632545 | 2020-10-15 | Clark | Kansas | 20025 | 60 | 1 |
629301 | 629301 | 2020-10-14 | Clark | Kansas | 20025 | 60 | 1 |
626058 | 626058 | 2020-10-13 | Clark | Kansas | 20025 | 59 | 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);