ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 20177 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947383 | 947383 | 2021-01-20 | Shawnee | Kansas | 20177 | 14360 | 265 |
944136 | 944136 | 2021-01-19 | Shawnee | Kansas | 20177 | 14169 | 263 |
940891 | 940891 | 2021-01-18 | Shawnee | Kansas | 20177 | 14169 | 263 |
937646 | 937646 | 2021-01-17 | Shawnee | Kansas | 20177 | 13913 | 263 |
934401 | 934401 | 2021-01-16 | Shawnee | Kansas | 20177 | 13913 | 263 |
931156 | 931156 | 2021-01-15 | Shawnee | Kansas | 20177 | 13913 | 263 |
927911 | 927911 | 2021-01-14 | Shawnee | Kansas | 20177 | 13680 | 253 |
924665 | 924665 | 2021-01-13 | Shawnee | Kansas | 20177 | 13654 | 253 |
921420 | 921420 | 2021-01-12 | Shawnee | Kansas | 20177 | 13410 | 248 |
918175 | 918175 | 2021-01-11 | Shawnee | Kansas | 20177 | 13374 | 248 |
914930 | 914930 | 2021-01-10 | Shawnee | Kansas | 20177 | 12959 | 242 |
911685 | 911685 | 2021-01-09 | Shawnee | Kansas | 20177 | 12959 | 242 |
908440 | 908440 | 2021-01-08 | Shawnee | Kansas | 20177 | 12959 | 242 |
905194 | 905194 | 2021-01-07 | Shawnee | Kansas | 20177 | 12683 | 237 |
901949 | 901949 | 2021-01-06 | Shawnee | Kansas | 20177 | 12569 | 229 |
898704 | 898704 | 2021-01-05 | Shawnee | Kansas | 20177 | 12213 | 225 |
895459 | 895459 | 2021-01-04 | Shawnee | Kansas | 20177 | 12176 | 225 |
892212 | 892212 | 2021-01-03 | Shawnee | Kansas | 20177 | 11929 | 219 |
888966 | 888966 | 2021-01-02 | Shawnee | Kansas | 20177 | 11929 | 219 |
885720 | 885720 | 2021-01-01 | Shawnee | Kansas | 20177 | 11929 | 219 |
882475 | 882475 | 2020-12-31 | Shawnee | Kansas | 20177 | 11622 | 219 |
879230 | 879230 | 2020-12-30 | Shawnee | Kansas | 20177 | 11608 | 210 |
875985 | 875985 | 2020-12-29 | Shawnee | Kansas | 20177 | 11361 | 210 |
872740 | 872740 | 2020-12-28 | Shawnee | Kansas | 20177 | 11310 | 204 |
869495 | 869495 | 2020-12-27 | Shawnee | Kansas | 20177 | 10896 | 195 |
866250 | 866250 | 2020-12-26 | Shawnee | Kansas | 20177 | 10896 | 195 |
863005 | 863005 | 2020-12-25 | Shawnee | Kansas | 20177 | 10896 | 195 |
859760 | 859760 | 2020-12-24 | Shawnee | Kansas | 20177 | 10896 | 195 |
856515 | 856515 | 2020-12-23 | Shawnee | Kansas | 20177 | 10878 | 195 |
853270 | 853270 | 2020-12-22 | Shawnee | Kansas | 20177 | 10687 | 194 |
850025 | 850025 | 2020-12-21 | Shawnee | Kansas | 20177 | 10687 | 194 |
846780 | 846780 | 2020-12-20 | Shawnee | Kansas | 20177 | 10393 | 190 |
843534 | 843534 | 2020-12-19 | Shawnee | Kansas | 20177 | 10393 | 190 |
840289 | 840289 | 2020-12-18 | Shawnee | Kansas | 20177 | 10393 | 190 |
837044 | 837044 | 2020-12-17 | Shawnee | Kansas | 20177 | 10214 | 187 |
833798 | 833798 | 2020-12-16 | Shawnee | Kansas | 20177 | 10126 | 183 |
830551 | 830551 | 2020-12-15 | Shawnee | Kansas | 20177 | 9862 | 180 |
827305 | 827305 | 2020-12-14 | Shawnee | Kansas | 20177 | 9829 | 177 |
824058 | 824058 | 2020-12-13 | Shawnee | Kansas | 20177 | 9623 | 171 |
820812 | 820812 | 2020-12-12 | Shawnee | Kansas | 20177 | 9623 | 171 |
817566 | 817566 | 2020-12-11 | Shawnee | Kansas | 20177 | 9623 | 171 |
814320 | 814320 | 2020-12-10 | Shawnee | Kansas | 20177 | 9395 | 168 |
811075 | 811075 | 2020-12-09 | Shawnee | Kansas | 20177 | 9281 | 160 |
807830 | 807830 | 2020-12-08 | Shawnee | Kansas | 20177 | 9048 | 158 |
804585 | 804585 | 2020-12-07 | Shawnee | Kansas | 20177 | 8927 | 153 |
801340 | 801340 | 2020-12-06 | Shawnee | Kansas | 20177 | 8568 | 148 |
798095 | 798095 | 2020-12-05 | Shawnee | Kansas | 20177 | 8568 | 148 |
794850 | 794850 | 2020-12-04 | Shawnee | Kansas | 20177 | 8568 | 148 |
791605 | 791605 | 2020-12-03 | Shawnee | Kansas | 20177 | 8359 | 143 |
788360 | 788360 | 2020-12-02 | Shawnee | Kansas | 20177 | 8179 | 139 |
785116 | 785116 | 2020-12-01 | Shawnee | Kansas | 20177 | 7927 | 139 |
781871 | 781871 | 2020-11-30 | Shawnee | Kansas | 20177 | 7855 | 134 |
778625 | 778625 | 2020-11-29 | Shawnee | Kansas | 20177 | 7546 | 125 |
775380 | 775380 | 2020-11-28 | Shawnee | Kansas | 20177 | 7546 | 125 |
772135 | 772135 | 2020-11-27 | Shawnee | Kansas | 20177 | 7546 | 125 |
768890 | 768890 | 2020-11-26 | Shawnee | Kansas | 20177 | 7150 | 125 |
765644 | 765644 | 2020-11-25 | Shawnee | Kansas | 20177 | 7150 | 125 |
762399 | 762399 | 2020-11-24 | Shawnee | Kansas | 20177 | 6976 | 119 |
759154 | 759154 | 2020-11-23 | Shawnee | Kansas | 20177 | 6862 | 115 |
755907 | 755907 | 2020-11-22 | Shawnee | Kansas | 20177 | 6382 | 108 |
752661 | 752661 | 2020-11-21 | Shawnee | Kansas | 20177 | 6382 | 108 |
749415 | 749415 | 2020-11-20 | Shawnee | Kansas | 20177 | 6382 | 108 |
746169 | 746169 | 2020-11-19 | Shawnee | Kansas | 20177 | 6151 | 104 |
742922 | 742922 | 2020-11-18 | Shawnee | Kansas | 20177 | 6097 | 97 |
739675 | 739675 | 2020-11-17 | Shawnee | Kansas | 20177 | 5908 | 95 |
736431 | 736431 | 2020-11-16 | Shawnee | Kansas | 20177 | 5792 | 95 |
733185 | 733185 | 2020-11-15 | Shawnee | Kansas | 20177 | 5335 | 97 |
729940 | 729940 | 2020-11-14 | Shawnee | Kansas | 20177 | 5335 | 97 |
726697 | 726697 | 2020-11-13 | Shawnee | Kansas | 20177 | 5335 | 97 |
723454 | 723454 | 2020-11-12 | Shawnee | Kansas | 20177 | 5199 | 95 |
720211 | 720211 | 2020-11-11 | Shawnee | Kansas | 20177 | 5061 | 90 |
716968 | 716968 | 2020-11-10 | Shawnee | Kansas | 20177 | 4892 | 90 |
713724 | 713724 | 2020-11-09 | Shawnee | Kansas | 20177 | 4737 | 89 |
710480 | 710480 | 2020-11-08 | Shawnee | Kansas | 20177 | 4398 | 89 |
707236 | 707236 | 2020-11-07 | Shawnee | Kansas | 20177 | 4398 | 89 |
703993 | 703993 | 2020-11-06 | Shawnee | Kansas | 20177 | 4398 | 89 |
700751 | 700751 | 2020-11-05 | Shawnee | Kansas | 20177 | 4247 | 85 |
697507 | 697507 | 2020-11-04 | Shawnee | Kansas | 20177 | 4103 | 85 |
694265 | 694265 | 2020-11-03 | Shawnee | Kansas | 20177 | 3981 | 85 |
691022 | 691022 | 2020-11-02 | Shawnee | Kansas | 20177 | 3947 | 84 |
687777 | 687777 | 2020-11-01 | Shawnee | Kansas | 20177 | 3769 | 84 |
684533 | 684533 | 2020-10-31 | Shawnee | Kansas | 20177 | 3769 | 84 |
681290 | 681290 | 2020-10-30 | Shawnee | Kansas | 20177 | 3769 | 84 |
678047 | 678047 | 2020-10-29 | Shawnee | Kansas | 20177 | 3653 | 82 |
674804 | 674804 | 2020-10-28 | Shawnee | Kansas | 20177 | 3641 | 82 |
671562 | 671562 | 2020-10-27 | Shawnee | Kansas | 20177 | 3528 | 81 |
668319 | 668319 | 2020-10-26 | Shawnee | Kansas | 20177 | 3495 | 82 |
665075 | 665075 | 2020-10-25 | Shawnee | Kansas | 20177 | 3416 | 77 |
661830 | 661830 | 2020-10-24 | Shawnee | Kansas | 20177 | 3416 | 77 |
658586 | 658586 | 2020-10-23 | Shawnee | Kansas | 20177 | 3416 | 77 |
655341 | 655341 | 2020-10-22 | Shawnee | Kansas | 20177 | 3390 | 77 |
652096 | 652096 | 2020-10-21 | Shawnee | Kansas | 20177 | 3376 | 77 |
648852 | 648852 | 2020-10-20 | Shawnee | Kansas | 20177 | 3331 | 77 |
645607 | 645607 | 2020-10-19 | Shawnee | Kansas | 20177 | 3318 | 73 |
642360 | 642360 | 2020-10-18 | Shawnee | Kansas | 20177 | 3235 | 69 |
639113 | 639113 | 2020-10-17 | Shawnee | Kansas | 20177 | 3235 | 69 |
635867 | 635867 | 2020-10-16 | Shawnee | Kansas | 20177 | 3235 | 69 |
632621 | 632621 | 2020-10-15 | Shawnee | Kansas | 20177 | 3185 | 65 |
629377 | 629377 | 2020-10-14 | Shawnee | Kansas | 20177 | 3180 | 65 |
626134 | 626134 | 2020-10-13 | Shawnee | Kansas | 20177 | 3116 | 62 |
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);