ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 20079 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947334 | 947334 | 2021-01-20 | Harvey | Kansas | 20079 | 3269 | 36 |
944087 | 944087 | 2021-01-19 | Harvey | Kansas | 20079 | 3218 | 36 |
940842 | 940842 | 2021-01-18 | Harvey | Kansas | 20079 | 3218 | 33 |
937597 | 937597 | 2021-01-17 | Harvey | Kansas | 20079 | 3170 | 33 |
934352 | 934352 | 2021-01-16 | Harvey | Kansas | 20079 | 3170 | 30 |
931107 | 931107 | 2021-01-15 | Harvey | Kansas | 20079 | 3170 | 30 |
927862 | 927862 | 2021-01-14 | Harvey | Kansas | 20079 | 3110 | 30 |
924616 | 924616 | 2021-01-13 | Harvey | Kansas | 20079 | 3110 | 30 |
921371 | 921371 | 2021-01-12 | Harvey | Kansas | 20079 | 3041 | 30 |
918126 | 918126 | 2021-01-11 | Harvey | Kansas | 20079 | 3041 | 30 |
914881 | 914881 | 2021-01-10 | Harvey | Kansas | 20079 | 2952 | 29 |
911636 | 911636 | 2021-01-09 | Harvey | Kansas | 20079 | 2952 | 29 |
908391 | 908391 | 2021-01-08 | Harvey | Kansas | 20079 | 2952 | 29 |
905145 | 905145 | 2021-01-07 | Harvey | Kansas | 20079 | 2866 | 29 |
901900 | 901900 | 2021-01-06 | Harvey | Kansas | 20079 | 2866 | 29 |
898655 | 898655 | 2021-01-05 | Harvey | Kansas | 20079 | 2765 | 29 |
895410 | 895410 | 2021-01-04 | Harvey | Kansas | 20079 | 2765 | 27 |
892163 | 892163 | 2021-01-03 | Harvey | Kansas | 20079 | 2707 | 27 |
888917 | 888917 | 2021-01-02 | Harvey | Kansas | 20079 | 2707 | 27 |
885671 | 885671 | 2021-01-01 | Harvey | Kansas | 20079 | 2707 | 27 |
882426 | 882426 | 2020-12-31 | Harvey | Kansas | 20079 | 2623 | 27 |
879181 | 879181 | 2020-12-30 | Harvey | Kansas | 20079 | 2623 | 27 |
875936 | 875936 | 2020-12-29 | Harvey | Kansas | 20079 | 2523 | 27 |
872691 | 872691 | 2020-12-28 | Harvey | Kansas | 20079 | 2523 | 27 |
869446 | 869446 | 2020-12-27 | Harvey | Kansas | 20079 | 2444 | 26 |
866201 | 866201 | 2020-12-26 | Harvey | Kansas | 20079 | 2444 | 26 |
862956 | 862956 | 2020-12-25 | Harvey | Kansas | 20079 | 2444 | 26 |
859711 | 859711 | 2020-12-24 | Harvey | Kansas | 20079 | 2444 | 26 |
856466 | 856466 | 2020-12-23 | Harvey | Kansas | 20079 | 2444 | 26 |
853221 | 853221 | 2020-12-22 | Harvey | Kansas | 20079 | 2388 | 26 |
849976 | 849976 | 2020-12-21 | Harvey | Kansas | 20079 | 2388 | 26 |
846731 | 846731 | 2020-12-20 | Harvey | Kansas | 20079 | 2316 | 23 |
843485 | 843485 | 2020-12-19 | Harvey | Kansas | 20079 | 2316 | 23 |
840240 | 840240 | 2020-12-18 | Harvey | Kansas | 20079 | 2316 | 23 |
836995 | 836995 | 2020-12-17 | Harvey | Kansas | 20079 | 2226 | 23 |
833749 | 833749 | 2020-12-16 | Harvey | Kansas | 20079 | 2226 | 22 |
830502 | 830502 | 2020-12-15 | Harvey | Kansas | 20079 | 2186 | 22 |
827256 | 827256 | 2020-12-14 | Harvey | Kansas | 20079 | 2186 | 22 |
824009 | 824009 | 2020-12-13 | Harvey | Kansas | 20079 | 2161 | 19 |
820763 | 820763 | 2020-12-12 | Harvey | Kansas | 20079 | 2161 | 19 |
817517 | 817517 | 2020-12-11 | Harvey | Kansas | 20079 | 2161 | 19 |
814271 | 814271 | 2020-12-10 | Harvey | Kansas | 20079 | 2095 | 19 |
811026 | 811026 | 2020-12-09 | Harvey | Kansas | 20079 | 2095 | 19 |
807781 | 807781 | 2020-12-08 | Harvey | Kansas | 20079 | 2047 | 18 |
804536 | 804536 | 2020-12-07 | Harvey | Kansas | 20079 | 2047 | 18 |
801291 | 801291 | 2020-12-06 | Harvey | Kansas | 20079 | 1975 | 17 |
798046 | 798046 | 2020-12-05 | Harvey | Kansas | 20079 | 1975 | 17 |
794801 | 794801 | 2020-12-04 | Harvey | Kansas | 20079 | 1975 | 17 |
791556 | 791556 | 2020-12-03 | Harvey | Kansas | 20079 | 1911 | 17 |
788311 | 788311 | 2020-12-02 | Harvey | Kansas | 20079 | 1911 | 16 |
785067 | 785067 | 2020-12-01 | Harvey | Kansas | 20079 | 1842 | 16 |
781822 | 781822 | 2020-11-30 | Harvey | Kansas | 20079 | 1842 | 15 |
778576 | 778576 | 2020-11-29 | Harvey | Kansas | 20079 | 1796 | 15 |
775331 | 775331 | 2020-11-28 | Harvey | Kansas | 20079 | 1796 | 15 |
772086 | 772086 | 2020-11-27 | Harvey | Kansas | 20079 | 1796 | 15 |
768841 | 768841 | 2020-11-26 | Harvey | Kansas | 20079 | 1730 | 15 |
765595 | 765595 | 2020-11-25 | Harvey | Kansas | 20079 | 1730 | 15 |
762350 | 762350 | 2020-11-24 | Harvey | Kansas | 20079 | 1643 | 9 |
759105 | 759105 | 2020-11-23 | Harvey | Kansas | 20079 | 1643 | 9 |
755858 | 755858 | 2020-11-22 | Harvey | Kansas | 20079 | 1553 | 9 |
752612 | 752612 | 2020-11-21 | Harvey | Kansas | 20079 | 1553 | 9 |
749366 | 749366 | 2020-11-20 | Harvey | Kansas | 20079 | 1553 | 9 |
746120 | 746120 | 2020-11-19 | Harvey | Kansas | 20079 | 1482 | 9 |
742873 | 742873 | 2020-11-18 | Harvey | Kansas | 20079 | 1482 | 9 |
739626 | 739626 | 2020-11-17 | Harvey | Kansas | 20079 | 1373 | 9 |
736382 | 736382 | 2020-11-16 | Harvey | Kansas | 20079 | 1373 | 9 |
733136 | 733136 | 2020-11-15 | Harvey | Kansas | 20079 | 1274 | 9 |
729891 | 729891 | 2020-11-14 | Harvey | Kansas | 20079 | 1274 | 9 |
726648 | 726648 | 2020-11-13 | Harvey | Kansas | 20079 | 1274 | 9 |
723405 | 723405 | 2020-11-12 | Harvey | Kansas | 20079 | 1147 | 9 |
720162 | 720162 | 2020-11-11 | Harvey | Kansas | 20079 | 1147 | 9 |
716919 | 716919 | 2020-11-10 | Harvey | Kansas | 20079 | 1048 | 9 |
713675 | 713675 | 2020-11-09 | Harvey | Kansas | 20079 | 1048 | 9 |
710431 | 710431 | 2020-11-08 | Harvey | Kansas | 20079 | 946 | 9 |
707187 | 707187 | 2020-11-07 | Harvey | Kansas | 20079 | 946 | 9 |
703944 | 703944 | 2020-11-06 | Harvey | Kansas | 20079 | 946 | 9 |
700702 | 700702 | 2020-11-05 | Harvey | Kansas | 20079 | 832 | 9 |
697458 | 697458 | 2020-11-04 | Harvey | Kansas | 20079 | 832 | 9 |
694216 | 694216 | 2020-11-03 | Harvey | Kansas | 20079 | 744 | 9 |
690973 | 690973 | 2020-11-02 | Harvey | Kansas | 20079 | 744 | 9 |
687728 | 687728 | 2020-11-01 | Harvey | Kansas | 20079 | 649 | 8 |
684484 | 684484 | 2020-10-31 | Harvey | Kansas | 20079 | 649 | 8 |
681241 | 681241 | 2020-10-30 | Harvey | Kansas | 20079 | 649 | 8 |
677998 | 677998 | 2020-10-29 | Harvey | Kansas | 20079 | 607 | 8 |
674755 | 674755 | 2020-10-28 | Harvey | Kansas | 20079 | 607 | 8 |
671513 | 671513 | 2020-10-27 | Harvey | Kansas | 20079 | 572 | 8 |
668270 | 668270 | 2020-10-26 | Harvey | Kansas | 20079 | 572 | 8 |
665026 | 665026 | 2020-10-25 | Harvey | Kansas | 20079 | 532 | 8 |
661781 | 661781 | 2020-10-24 | Harvey | Kansas | 20079 | 532 | 8 |
658537 | 658537 | 2020-10-23 | Harvey | Kansas | 20079 | 532 | 8 |
655292 | 655292 | 2020-10-22 | Harvey | Kansas | 20079 | 512 | 8 |
652047 | 652047 | 2020-10-21 | Harvey | Kansas | 20079 | 512 | 8 |
648803 | 648803 | 2020-10-20 | Harvey | Kansas | 20079 | 499 | 8 |
645558 | 645558 | 2020-10-19 | Harvey | Kansas | 20079 | 499 | 8 |
642311 | 642311 | 2020-10-18 | Harvey | Kansas | 20079 | 481 | 8 |
639064 | 639064 | 2020-10-17 | Harvey | Kansas | 20079 | 481 | 8 |
635818 | 635818 | 2020-10-16 | Harvey | Kansas | 20079 | 481 | 8 |
632572 | 632572 | 2020-10-15 | Harvey | Kansas | 20079 | 465 | 8 |
629328 | 629328 | 2020-10-14 | Harvey | Kansas | 20079 | 465 | 8 |
626085 | 626085 | 2020-10-13 | Harvey | Kansas | 20079 | 457 | 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);