ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Butler" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054408 | 1054408 | 2021-02-22 | Butler | Kansas | 20015 | 7148 | 60 |
1051161 | 1051161 | 2021-02-21 | Butler | Kansas | 20015 | 7094 | 60 |
1047914 | 1047914 | 2021-02-20 | Butler | Kansas | 20015 | 7094 | 60 |
1044669 | 1044669 | 2021-02-19 | Butler | Kansas | 20015 | 7094 | 60 |
1041424 | 1041424 | 2021-02-18 | Butler | Kansas | 20015 | 7071 | 60 |
1038179 | 1038179 | 2021-02-17 | Butler | Kansas | 20015 | 7071 | 60 |
1034934 | 1034934 | 2021-02-16 | Butler | Kansas | 20015 | 7058 | 52 |
1031688 | 1031688 | 2021-02-15 | Butler | Kansas | 20015 | 7058 | 52 |
1028441 | 1028441 | 2021-02-14 | Butler | Kansas | 20015 | 7038 | 52 |
1025196 | 1025196 | 2021-02-13 | Butler | Kansas | 20015 | 7038 | 52 |
1021951 | 1021951 | 2021-02-12 | Butler | Kansas | 20015 | 7038 | 52 |
1018706 | 1018706 | 2021-02-11 | Butler | Kansas | 20015 | 7013 | 52 |
1015461 | 1015461 | 2021-02-10 | Butler | Kansas | 20015 | 7013 | 52 |
1012216 | 1012216 | 2021-02-09 | Butler | Kansas | 20015 | 6988 | 52 |
1008970 | 1008970 | 2021-02-08 | Butler | Kansas | 20015 | 6988 | 50 |
1005724 | 1005724 | 2021-02-07 | Butler | Kansas | 20015 | 6935 | 50 |
1002478 | 1002478 | 2021-02-06 | Butler | Kansas | 20015 | 6935 | 50 |
999232 | 999232 | 2021-02-05 | Butler | Kansas | 20015 | 6935 | 50 |
995986 | 995986 | 2021-02-04 | Butler | Kansas | 20015 | 6863 | 50 |
992740 | 992740 | 2021-02-03 | Butler | Kansas | 20015 | 6863 | 50 |
989494 | 989494 | 2021-02-02 | Butler | Kansas | 20015 | 6804 | 50 |
986247 | 986247 | 2021-02-01 | Butler | Kansas | 20015 | 6804 | 44 |
983000 | 983000 | 2021-01-31 | Butler | Kansas | 20015 | 6765 | 44 |
979754 | 979754 | 2021-01-30 | Butler | Kansas | 20015 | 6765 | 44 |
976508 | 976508 | 2021-01-29 | Butler | Kansas | 20015 | 6765 | 44 |
973263 | 973263 | 2021-01-28 | Butler | Kansas | 20015 | 6713 | 44 |
970018 | 970018 | 2021-01-27 | Butler | Kansas | 20015 | 6713 | 44 |
966774 | 966774 | 2021-01-26 | Butler | Kansas | 20015 | 6653 | 44 |
963529 | 963529 | 2021-01-25 | Butler | Kansas | 20015 | 6653 | 43 |
960284 | 960284 | 2021-01-24 | Butler | Kansas | 20015 | 6584 | 43 |
957038 | 957038 | 2021-01-23 | Butler | Kansas | 20015 | 6584 | 43 |
953793 | 953793 | 2021-01-22 | Butler | Kansas | 20015 | 6584 | 43 |
950548 | 950548 | 2021-01-21 | Butler | Kansas | 20015 | 6516 | 43 |
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 |
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);