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 |
---|---|---|---|---|---|---|---|
1054413 | 1054413 | 2021-02-22 | Clark | Kansas | 20025 | 238 | 4 |
1051166 | 1051166 | 2021-02-21 | Clark | Kansas | 20025 | 235 | 4 |
1047919 | 1047919 | 2021-02-20 | Clark | Kansas | 20025 | 235 | 4 |
1044674 | 1044674 | 2021-02-19 | Clark | Kansas | 20025 | 235 | 4 |
1041429 | 1041429 | 2021-02-18 | Clark | Kansas | 20025 | 233 | 4 |
1038184 | 1038184 | 2021-02-17 | Clark | Kansas | 20025 | 233 | 4 |
1034939 | 1034939 | 2021-02-16 | Clark | Kansas | 20025 | 233 | 4 |
1031693 | 1031693 | 2021-02-15 | Clark | Kansas | 20025 | 233 | 4 |
1028446 | 1028446 | 2021-02-14 | Clark | Kansas | 20025 | 233 | 4 |
1025201 | 1025201 | 2021-02-13 | Clark | Kansas | 20025 | 233 | 4 |
1021956 | 1021956 | 2021-02-12 | Clark | Kansas | 20025 | 233 | 4 |
1018711 | 1018711 | 2021-02-11 | Clark | Kansas | 20025 | 233 | 4 |
1015466 | 1015466 | 2021-02-10 | Clark | Kansas | 20025 | 233 | 4 |
1012221 | 1012221 | 2021-02-09 | Clark | Kansas | 20025 | 233 | 4 |
1008975 | 1008975 | 2021-02-08 | Clark | Kansas | 20025 | 233 | 4 |
1005729 | 1005729 | 2021-02-07 | Clark | Kansas | 20025 | 233 | 4 |
1002483 | 1002483 | 2021-02-06 | Clark | Kansas | 20025 | 233 | 4 |
999237 | 999237 | 2021-02-05 | Clark | Kansas | 20025 | 233 | 4 |
995991 | 995991 | 2021-02-04 | Clark | Kansas | 20025 | 231 | 4 |
992745 | 992745 | 2021-02-03 | Clark | Kansas | 20025 | 231 | 4 |
989499 | 989499 | 2021-02-02 | Clark | Kansas | 20025 | 230 | 4 |
986252 | 986252 | 2021-02-01 | Clark | Kansas | 20025 | 230 | 4 |
983005 | 983005 | 2021-01-31 | Clark | Kansas | 20025 | 230 | 4 |
979759 | 979759 | 2021-01-30 | Clark | Kansas | 20025 | 230 | 4 |
976513 | 976513 | 2021-01-29 | Clark | Kansas | 20025 | 230 | 4 |
973268 | 973268 | 2021-01-28 | Clark | Kansas | 20025 | 228 | 4 |
970023 | 970023 | 2021-01-27 | Clark | Kansas | 20025 | 228 | 4 |
966779 | 966779 | 2021-01-26 | Clark | Kansas | 20025 | 226 | 4 |
963534 | 963534 | 2021-01-25 | Clark | Kansas | 20025 | 226 | 4 |
960289 | 960289 | 2021-01-24 | Clark | Kansas | 20025 | 224 | 4 |
957043 | 957043 | 2021-01-23 | Clark | Kansas | 20025 | 224 | 4 |
953798 | 953798 | 2021-01-22 | Clark | Kansas | 20025 | 224 | 4 |
950553 | 950553 | 2021-01-21 | Clark | Kansas | 20025 | 222 | 4 |
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 |
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);