ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 20015 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947302 | 947302 | 2021-01-20 | Butler | Kansas | 20015 | 6516 | 43 |
944055 | 944055 | 2021-01-19 | Butler | Kansas | 20015 | 6429 | 42 |
940810 | 940810 | 2021-01-18 | Butler | Kansas | 20015 | 6429 | 42 |
937565 | 937565 | 2021-01-17 | Butler | Kansas | 20015 | 6340 | 42 |
934320 | 934320 | 2021-01-16 | Butler | Kansas | 20015 | 6340 | 42 |
931075 | 931075 | 2021-01-15 | Butler | Kansas | 20015 | 6340 | 42 |
927830 | 927830 | 2021-01-14 | Butler | Kansas | 20015 | 6198 | 42 |
924584 | 924584 | 2021-01-13 | Butler | Kansas | 20015 | 6198 | 42 |
921339 | 921339 | 2021-01-12 | Butler | Kansas | 20015 | 6077 | 42 |
918094 | 918094 | 2021-01-11 | Butler | Kansas | 20015 | 6077 | 33 |
914849 | 914849 | 2021-01-10 | Butler | Kansas | 20015 | 5910 | 33 |
911604 | 911604 | 2021-01-09 | Butler | Kansas | 20015 | 5910 | 33 |
908359 | 908359 | 2021-01-08 | Butler | Kansas | 20015 | 5910 | 33 |
905113 | 905113 | 2021-01-07 | Butler | Kansas | 20015 | 5768 | 33 |
901868 | 901868 | 2021-01-06 | Butler | Kansas | 20015 | 5768 | 33 |
898623 | 898623 | 2021-01-05 | Butler | Kansas | 20015 | 5598 | 23 |
895378 | 895378 | 2021-01-04 | Butler | Kansas | 20015 | 5598 | 23 |
892131 | 892131 | 2021-01-03 | Butler | Kansas | 20015 | 5493 | 23 |
888885 | 888885 | 2021-01-02 | Butler | Kansas | 20015 | 5493 | 23 |
885639 | 885639 | 2021-01-01 | Butler | Kansas | 20015 | 5493 | 23 |
882394 | 882394 | 2020-12-31 | Butler | Kansas | 20015 | 5314 | 23 |
879149 | 879149 | 2020-12-30 | Butler | Kansas | 20015 | 5314 | 23 |
875904 | 875904 | 2020-12-29 | Butler | Kansas | 20015 | 5096 | 22 |
872659 | 872659 | 2020-12-28 | Butler | Kansas | 20015 | 5096 | 18 |
869414 | 869414 | 2020-12-27 | Butler | Kansas | 20015 | 4897 | 18 |
866169 | 866169 | 2020-12-26 | Butler | Kansas | 20015 | 4897 | 18 |
862924 | 862924 | 2020-12-25 | Butler | Kansas | 20015 | 4897 | 18 |
859679 | 859679 | 2020-12-24 | Butler | Kansas | 20015 | 4897 | 18 |
856434 | 856434 | 2020-12-23 | Butler | Kansas | 20015 | 4897 | 18 |
853189 | 853189 | 2020-12-22 | Butler | Kansas | 20015 | 4768 | 18 |
849944 | 849944 | 2020-12-21 | Butler | Kansas | 20015 | 4768 | 18 |
846699 | 846699 | 2020-12-20 | Butler | Kansas | 20015 | 4646 | 18 |
843453 | 843453 | 2020-12-19 | Butler | Kansas | 20015 | 4646 | 18 |
840208 | 840208 | 2020-12-18 | Butler | Kansas | 20015 | 4646 | 18 |
836963 | 836963 | 2020-12-17 | Butler | Kansas | 20015 | 4480 | 18 |
833717 | 833717 | 2020-12-16 | Butler | Kansas | 20015 | 4480 | 17 |
830470 | 830470 | 2020-12-15 | Butler | Kansas | 20015 | 4360 | 17 |
827224 | 827224 | 2020-12-14 | Butler | Kansas | 20015 | 4360 | 16 |
823977 | 823977 | 2020-12-13 | Butler | Kansas | 20015 | 4213 | 16 |
820731 | 820731 | 2020-12-12 | Butler | Kansas | 20015 | 4213 | 16 |
817485 | 817485 | 2020-12-11 | Butler | Kansas | 20015 | 4213 | 16 |
814239 | 814239 | 2020-12-10 | Butler | Kansas | 20015 | 4033 | 14 |
810994 | 810994 | 2020-12-09 | Butler | Kansas | 20015 | 4033 | 14 |
807749 | 807749 | 2020-12-08 | Butler | Kansas | 20015 | 3884 | 14 |
804504 | 804504 | 2020-12-07 | Butler | Kansas | 20015 | 3884 | 13 |
801259 | 801259 | 2020-12-06 | Butler | Kansas | 20015 | 3732 | 13 |
798014 | 798014 | 2020-12-05 | Butler | Kansas | 20015 | 3732 | 13 |
794769 | 794769 | 2020-12-04 | Butler | Kansas | 20015 | 3732 | 13 |
791524 | 791524 | 2020-12-03 | Butler | Kansas | 20015 | 3559 | 11 |
788279 | 788279 | 2020-12-02 | Butler | Kansas | 20015 | 3559 | 11 |
785035 | 785035 | 2020-12-01 | Butler | Kansas | 20015 | 3468 | 11 |
781790 | 781790 | 2020-11-30 | Butler | Kansas | 20015 | 3468 | 11 |
778544 | 778544 | 2020-11-29 | Butler | Kansas | 20015 | 3354 | 11 |
775299 | 775299 | 2020-11-28 | Butler | Kansas | 20015 | 3354 | 11 |
772054 | 772054 | 2020-11-27 | Butler | Kansas | 20015 | 3354 | 11 |
768809 | 768809 | 2020-11-26 | Butler | Kansas | 20015 | 3169 | 11 |
765563 | 765563 | 2020-11-25 | Butler | Kansas | 20015 | 3169 | 11 |
762318 | 762318 | 2020-11-24 | Butler | Kansas | 20015 | 3011 | 10 |
759073 | 759073 | 2020-11-23 | Butler | Kansas | 20015 | 3011 | 8 |
755826 | 755826 | 2020-11-22 | Butler | Kansas | 20015 | 2790 | 8 |
752580 | 752580 | 2020-11-21 | Butler | Kansas | 20015 | 2790 | 8 |
749334 | 749334 | 2020-11-20 | Butler | Kansas | 20015 | 2790 | 8 |
746088 | 746088 | 2020-11-19 | Butler | Kansas | 20015 | 2654 | 7 |
742841 | 742841 | 2020-11-18 | Butler | Kansas | 20015 | 2654 | 7 |
739594 | 739594 | 2020-11-17 | Butler | Kansas | 20015 | 2535 | 6 |
736350 | 736350 | 2020-11-16 | Butler | Kansas | 20015 | 2535 | 5 |
733104 | 733104 | 2020-11-15 | Butler | Kansas | 20015 | 2325 | 4 |
729859 | 729859 | 2020-11-14 | Butler | Kansas | 20015 | 2325 | 4 |
726616 | 726616 | 2020-11-13 | Butler | Kansas | 20015 | 2325 | 4 |
723373 | 723373 | 2020-11-12 | Butler | Kansas | 20015 | 2138 | 4 |
720130 | 720130 | 2020-11-11 | Butler | Kansas | 20015 | 2138 | 4 |
716887 | 716887 | 2020-11-10 | Butler | Kansas | 20015 | 1954 | 4 |
713643 | 713643 | 2020-11-09 | Butler | Kansas | 20015 | 1954 | 3 |
710399 | 710399 | 2020-11-08 | Butler | Kansas | 20015 | 1826 | 3 |
707155 | 707155 | 2020-11-07 | Butler | Kansas | 20015 | 1826 | 3 |
703912 | 703912 | 2020-11-06 | Butler | Kansas | 20015 | 1826 | 3 |
700670 | 700670 | 2020-11-05 | Butler | Kansas | 20015 | 1720 | 3 |
697426 | 697426 | 2020-11-04 | Butler | Kansas | 20015 | 1720 | 3 |
694184 | 694184 | 2020-11-03 | Butler | Kansas | 20015 | 1658 | 3 |
690941 | 690941 | 2020-11-02 | Butler | Kansas | 20015 | 1658 | 3 |
687696 | 687696 | 2020-11-01 | Butler | Kansas | 20015 | 1572 | 3 |
684452 | 684452 | 2020-10-31 | Butler | Kansas | 20015 | 1572 | 3 |
681209 | 681209 | 2020-10-30 | Butler | Kansas | 20015 | 1572 | 3 |
677966 | 677966 | 2020-10-29 | Butler | Kansas | 20015 | 1517 | 3 |
674723 | 674723 | 2020-10-28 | Butler | Kansas | 20015 | 1517 | 4 |
671481 | 671481 | 2020-10-27 | Butler | Kansas | 20015 | 1470 | 4 |
668238 | 668238 | 2020-10-26 | Butler | Kansas | 20015 | 1470 | 4 |
664994 | 664994 | 2020-10-25 | Butler | Kansas | 20015 | 1392 | 4 |
661749 | 661749 | 2020-10-24 | Butler | Kansas | 20015 | 1392 | 4 |
658505 | 658505 | 2020-10-23 | Butler | Kansas | 20015 | 1392 | 4 |
655260 | 655260 | 2020-10-22 | Butler | Kansas | 20015 | 1356 | 4 |
652015 | 652015 | 2020-10-21 | Butler | Kansas | 20015 | 1356 | 4 |
648771 | 648771 | 2020-10-20 | Butler | Kansas | 20015 | 1343 | 4 |
645526 | 645526 | 2020-10-19 | Butler | Kansas | 20015 | 1343 | 4 |
642279 | 642279 | 2020-10-18 | Butler | Kansas | 20015 | 1294 | 4 |
639032 | 639032 | 2020-10-17 | Butler | Kansas | 20015 | 1294 | 4 |
635786 | 635786 | 2020-10-16 | Butler | Kansas | 20015 | 1294 | 4 |
632540 | 632540 | 2020-10-15 | Butler | Kansas | 20015 | 1227 | 4 |
629296 | 629296 | 2020-10-14 | Butler | Kansas | 20015 | 1227 | 4 |
626053 | 626053 | 2020-10-13 | Butler | Kansas | 20015 | 1165 | 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);