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 |
---|---|---|---|---|---|---|---|
1047920 | 1047920 | 2021-02-20 | Clay | Kansas | 20027 | 817 | 24 |
1044675 | 1044675 | 2021-02-19 | Clay | Kansas | 20027 | 773 | 24 |
1041430 | 1041430 | 2021-02-18 | Clay | Kansas | 20027 | 816 | 24 |
1038185 | 1038185 | 2021-02-17 | Clay | Kansas | 20027 | 816 | 24 |
1034940 | 1034940 | 2021-02-16 | Clay | Kansas | 20027 | 816 | 23 |
1031694 | 1031694 | 2021-02-15 | Clay | Kansas | 20027 | 816 | 23 |
1028447 | 1028447 | 2021-02-14 | Clay | Kansas | 20027 | 816 | 23 |
1025202 | 1025202 | 2021-02-13 | Clay | Kansas | 20027 | 816 | 23 |
1021957 | 1021957 | 2021-02-12 | Clay | Kansas | 20027 | 816 | 23 |
1018712 | 1018712 | 2021-02-11 | Clay | Kansas | 20027 | 811 | 23 |
1015467 | 1015467 | 2021-02-10 | Clay | Kansas | 20027 | 811 | 23 |
1012222 | 1012222 | 2021-02-09 | Clay | Kansas | 20027 | 811 | 23 |
1008976 | 1008976 | 2021-02-08 | Clay | Kansas | 20027 | 811 | 23 |
1005730 | 1005730 | 2021-02-07 | Clay | Kansas | 20027 | 811 | 23 |
1002484 | 1002484 | 2021-02-06 | Clay | Kansas | 20027 | 811 | 23 |
999238 | 999238 | 2021-02-05 | Clay | Kansas | 20027 | 811 | 23 |
995992 | 995992 | 2021-02-04 | Clay | Kansas | 20027 | 787 | 22 |
992746 | 992746 | 2021-02-03 | Clay | Kansas | 20027 | 787 | 22 |
989500 | 989500 | 2021-02-02 | Clay | Kansas | 20027 | 787 | 22 |
986253 | 986253 | 2021-02-01 | Clay | Kansas | 20027 | 787 | 22 |
983006 | 983006 | 2021-01-31 | Clay | Kansas | 20027 | 787 | 22 |
979760 | 979760 | 2021-01-30 | Clay | Kansas | 20027 | 787 | 22 |
976514 | 976514 | 2021-01-29 | Clay | Kansas | 20027 | 787 | 22 |
973269 | 973269 | 2021-01-28 | Clay | Kansas | 20027 | 760 | 22 |
970024 | 970024 | 2021-01-27 | Clay | Kansas | 20027 | 760 | 22 |
966780 | 966780 | 2021-01-26 | Clay | Kansas | 20027 | 760 | 22 |
963535 | 963535 | 2021-01-25 | Clay | Kansas | 20027 | 760 | 22 |
960290 | 960290 | 2021-01-24 | Clay | Kansas | 20027 | 760 | 22 |
957044 | 957044 | 2021-01-23 | Clay | Kansas | 20027 | 760 | 22 |
953799 | 953799 | 2021-01-22 | Clay | Kansas | 20027 | 760 | 22 |
950554 | 950554 | 2021-01-21 | Clay | Kansas | 20027 | 746 | 21 |
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 |
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);