ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Clay" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947308 | 947308 | 2021-01-20 | Clay | Kansas | 20027 | 746 | 21 |
944061 | 944061 | 2021-01-19 | Clay | Kansas | 20027 | 746 | 21 |
940816 | 940816 | 2021-01-18 | Clay | Kansas | 20027 | 746 | 21 |
937571 | 937571 | 2021-01-17 | Clay | Kansas | 20027 | 746 | 21 |
934326 | 934326 | 2021-01-16 | Clay | Kansas | 20027 | 746 | 21 |
931081 | 931081 | 2021-01-15 | Clay | Kansas | 20027 | 716 | 17 |
927836 | 927836 | 2021-01-14 | Clay | Kansas | 20027 | 716 | 17 |
924590 | 924590 | 2021-01-13 | Clay | Kansas | 20027 | 716 | 17 |
921345 | 921345 | 2021-01-12 | Clay | Kansas | 20027 | 680 | 17 |
918100 | 918100 | 2021-01-11 | Clay | Kansas | 20027 | 680 | 17 |
914855 | 914855 | 2021-01-10 | Clay | Kansas | 20027 | 677 | 17 |
911610 | 911610 | 2021-01-09 | Clay | Kansas | 20027 | 677 | 17 |
908365 | 908365 | 2021-01-08 | Clay | Kansas | 20027 | 677 | 17 |
905119 | 905119 | 2021-01-07 | Clay | Kansas | 20027 | 677 | 17 |
901874 | 901874 | 2021-01-06 | Clay | Kansas | 20027 | 653 | 17 |
898629 | 898629 | 2021-01-05 | Clay | Kansas | 20027 | 629 | 17 |
895384 | 895384 | 2021-01-04 | Clay | Kansas | 20027 | 629 | 17 |
892137 | 892137 | 2021-01-03 | Clay | Kansas | 20027 | 622 | 17 |
888891 | 888891 | 2021-01-02 | Clay | Kansas | 20027 | 622 | 17 |
885645 | 885645 | 2021-01-01 | Clay | Kansas | 20027 | 622 | 17 |
882400 | 882400 | 2020-12-31 | Clay | Kansas | 20027 | 611 | 17 |
879155 | 879155 | 2020-12-30 | Clay | Kansas | 20027 | 611 | 17 |
875910 | 875910 | 2020-12-29 | Clay | Kansas | 20027 | 587 | 17 |
872665 | 872665 | 2020-12-28 | Clay | Kansas | 20027 | 587 | 17 |
869420 | 869420 | 2020-12-27 | Clay | Kansas | 20027 | 582 | 17 |
866175 | 866175 | 2020-12-26 | Clay | Kansas | 20027 | 582 | 17 |
862930 | 862930 | 2020-12-25 | Clay | Kansas | 20027 | 582 | 17 |
859685 | 859685 | 2020-12-24 | Clay | Kansas | 20027 | 582 | 17 |
856440 | 856440 | 2020-12-23 | Clay | Kansas | 20027 | 582 | 17 |
853195 | 853195 | 2020-12-22 | Clay | Kansas | 20027 | 582 | 17 |
849950 | 849950 | 2020-12-21 | Clay | Kansas | 20027 | 582 | 17 |
846705 | 846705 | 2020-12-20 | Clay | Kansas | 20027 | 533 | 14 |
843459 | 843459 | 2020-12-19 | Clay | Kansas | 20027 | 533 | 14 |
840214 | 840214 | 2020-12-18 | Clay | Kansas | 20027 | 533 | 14 |
836969 | 836969 | 2020-12-17 | Clay | Kansas | 20027 | 507 | 14 |
833723 | 833723 | 2020-12-16 | Clay | Kansas | 20027 | 507 | 14 |
830476 | 830476 | 2020-12-15 | Clay | Kansas | 20027 | 500 | 14 |
827230 | 827230 | 2020-12-14 | Clay | Kansas | 20027 | 500 | 14 |
823983 | 823983 | 2020-12-13 | Clay | Kansas | 20027 | 500 | 14 |
820737 | 820737 | 2020-12-12 | Clay | Kansas | 20027 | 500 | 14 |
817491 | 817491 | 2020-12-11 | Clay | Kansas | 20027 | 500 | 14 |
814245 | 814245 | 2020-12-10 | Clay | Kansas | 20027 | 485 | 14 |
811000 | 811000 | 2020-12-09 | Clay | Kansas | 20027 | 485 | 14 |
807755 | 807755 | 2020-12-08 | Clay | Kansas | 20027 | 484 | 14 |
804510 | 804510 | 2020-12-07 | Clay | Kansas | 20027 | 484 | 14 |
801265 | 801265 | 2020-12-06 | Clay | Kansas | 20027 | 453 | 11 |
798020 | 798020 | 2020-12-05 | Clay | Kansas | 20027 | 453 | 11 |
794775 | 794775 | 2020-12-04 | Clay | Kansas | 20027 | 453 | 11 |
791530 | 791530 | 2020-12-03 | Clay | Kansas | 20027 | 453 | 11 |
788285 | 788285 | 2020-12-02 | Clay | Kansas | 20027 | 453 | 11 |
785041 | 785041 | 2020-12-01 | Clay | Kansas | 20027 | 453 | 11 |
781796 | 781796 | 2020-11-30 | Clay | Kansas | 20027 | 453 | 11 |
778550 | 778550 | 2020-11-29 | Clay | Kansas | 20027 | 419 | 9 |
775305 | 775305 | 2020-11-28 | Clay | Kansas | 20027 | 419 | 9 |
772060 | 772060 | 2020-11-27 | Clay | Kansas | 20027 | 419 | 9 |
768815 | 768815 | 2020-11-26 | Clay | Kansas | 20027 | 419 | 9 |
765569 | 765569 | 2020-11-25 | Clay | Kansas | 20027 | 419 | 9 |
762324 | 762324 | 2020-11-24 | Clay | Kansas | 20027 | 419 | 9 |
759079 | 759079 | 2020-11-23 | Clay | Kansas | 20027 | 419 | 9 |
755832 | 755832 | 2020-11-22 | Clay | Kansas | 20027 | 410 | 9 |
752586 | 752586 | 2020-11-21 | Clay | Kansas | 20027 | 410 | 9 |
749340 | 749340 | 2020-11-20 | Clay | Kansas | 20027 | 410 | 9 |
746094 | 746094 | 2020-11-19 | Clay | Kansas | 20027 | 381 | 9 |
742847 | 742847 | 2020-11-18 | Clay | Kansas | 20027 | 381 | 9 |
739600 | 739600 | 2020-11-17 | Clay | Kansas | 20027 | 311 | 8 |
736356 | 736356 | 2020-11-16 | Clay | Kansas | 20027 | 298 | 8 |
733110 | 733110 | 2020-11-15 | Clay | Kansas | 20027 | 282 | 8 |
729865 | 729865 | 2020-11-14 | Clay | Kansas | 20027 | 282 | 8 |
726622 | 726622 | 2020-11-13 | Clay | Kansas | 20027 | 274 | 8 |
723379 | 723379 | 2020-11-12 | Clay | Kansas | 20027 | 229 | 8 |
720136 | 720136 | 2020-11-11 | Clay | Kansas | 20027 | 229 | 8 |
716893 | 716893 | 2020-11-10 | Clay | Kansas | 20027 | 227 | 8 |
713649 | 713649 | 2020-11-09 | Clay | Kansas | 20027 | 227 | 8 |
710405 | 710405 | 2020-11-08 | Clay | Kansas | 20027 | 157 | 3 |
707161 | 707161 | 2020-11-07 | Clay | Kansas | 20027 | 157 | 3 |
703918 | 703918 | 2020-11-06 | Clay | Kansas | 20027 | 157 | 3 |
700676 | 700676 | 2020-11-05 | Clay | Kansas | 20027 | 143 | 3 |
697432 | 697432 | 2020-11-04 | Clay | Kansas | 20027 | 143 | 3 |
694190 | 694190 | 2020-11-03 | Clay | Kansas | 20027 | 131 | 3 |
690947 | 690947 | 2020-11-02 | Clay | Kansas | 20027 | 131 | 3 |
687702 | 687702 | 2020-11-01 | Clay | Kansas | 20027 | 115 | 3 |
684458 | 684458 | 2020-10-31 | Clay | Kansas | 20027 | 115 | 3 |
681215 | 681215 | 2020-10-30 | Clay | Kansas | 20027 | 115 | 3 |
677972 | 677972 | 2020-10-29 | Clay | Kansas | 20027 | 105 | 3 |
674729 | 674729 | 2020-10-28 | Clay | Kansas | 20027 | 105 | 3 |
671487 | 671487 | 2020-10-27 | Clay | Kansas | 20027 | 101 | 3 |
668244 | 668244 | 2020-10-26 | Clay | Kansas | 20027 | 101 | 3 |
665000 | 665000 | 2020-10-25 | Clay | Kansas | 20027 | 79 | 2 |
661755 | 661755 | 2020-10-24 | Clay | Kansas | 20027 | 79 | 2 |
658511 | 658511 | 2020-10-23 | Clay | Kansas | 20027 | 79 | 2 |
655266 | 655266 | 2020-10-22 | Clay | Kansas | 20027 | 77 | 2 |
652021 | 652021 | 2020-10-21 | Clay | Kansas | 20027 | 77 | 2 |
648777 | 648777 | 2020-10-20 | Clay | Kansas | 20027 | 77 | 2 |
645532 | 645532 | 2020-10-19 | Clay | Kansas | 20027 | 77 | 2 |
642285 | 642285 | 2020-10-18 | Clay | Kansas | 20027 | 75 | 2 |
639038 | 639038 | 2020-10-17 | Clay | Kansas | 20027 | 75 | 2 |
635792 | 635792 | 2020-10-16 | Clay | Kansas | 20027 | 75 | 2 |
632546 | 632546 | 2020-10-15 | Clay | Kansas | 20027 | 68 | 2 |
629302 | 629302 | 2020-10-14 | Clay | Kansas | 20027 | 68 | 2 |
626059 | 626059 | 2020-10-13 | Clay | Kansas | 20027 | 68 | 2 |
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);