ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 20149 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947369 | 947369 | 2021-01-20 | Pottawatomie | Kansas | 20149 | 1391 | 9 |
944122 | 944122 | 2021-01-19 | Pottawatomie | Kansas | 20149 | 1360 | 6 |
940877 | 940877 | 2021-01-18 | Pottawatomie | Kansas | 20149 | 1360 | 6 |
937632 | 937632 | 2021-01-17 | Pottawatomie | Kansas | 20149 | 1345 | 6 |
934387 | 934387 | 2021-01-16 | Pottawatomie | Kansas | 20149 | 1345 | 6 |
931142 | 931142 | 2021-01-15 | Pottawatomie | Kansas | 20149 | 1345 | 6 |
927897 | 927897 | 2021-01-14 | Pottawatomie | Kansas | 20149 | 1312 | 6 |
924651 | 924651 | 2021-01-13 | Pottawatomie | Kansas | 20149 | 1312 | 6 |
921406 | 921406 | 2021-01-12 | Pottawatomie | Kansas | 20149 | 1279 | 6 |
918161 | 918161 | 2021-01-11 | Pottawatomie | Kansas | 20149 | 1279 | 6 |
914916 | 914916 | 2021-01-10 | Pottawatomie | Kansas | 20149 | 1263 | 4 |
911671 | 911671 | 2021-01-09 | Pottawatomie | Kansas | 20149 | 1263 | 4 |
908426 | 908426 | 2021-01-08 | Pottawatomie | Kansas | 20149 | 1263 | 4 |
905180 | 905180 | 2021-01-07 | Pottawatomie | Kansas | 20149 | 1224 | 4 |
901935 | 901935 | 2021-01-06 | Pottawatomie | Kansas | 20149 | 1224 | 4 |
898690 | 898690 | 2021-01-05 | Pottawatomie | Kansas | 20149 | 1178 | 4 |
895445 | 895445 | 2021-01-04 | Pottawatomie | Kansas | 20149 | 1178 | 4 |
892198 | 892198 | 2021-01-03 | Pottawatomie | Kansas | 20149 | 1151 | 3 |
888952 | 888952 | 2021-01-02 | Pottawatomie | Kansas | 20149 | 1151 | 3 |
885706 | 885706 | 2021-01-01 | Pottawatomie | Kansas | 20149 | 1151 | 3 |
882461 | 882461 | 2020-12-31 | Pottawatomie | Kansas | 20149 | 1109 | 3 |
879216 | 879216 | 2020-12-30 | Pottawatomie | Kansas | 20149 | 1109 | 3 |
875971 | 875971 | 2020-12-29 | Pottawatomie | Kansas | 20149 | 1057 | 3 |
872726 | 872726 | 2020-12-28 | Pottawatomie | Kansas | 20149 | 1057 | 3 |
869481 | 869481 | 2020-12-27 | Pottawatomie | Kansas | 20149 | 990 | 3 |
866236 | 866236 | 2020-12-26 | Pottawatomie | Kansas | 20149 | 990 | 3 |
862991 | 862991 | 2020-12-25 | Pottawatomie | Kansas | 20149 | 990 | 3 |
859746 | 859746 | 2020-12-24 | Pottawatomie | Kansas | 20149 | 990 | 3 |
856501 | 856501 | 2020-12-23 | Pottawatomie | Kansas | 20149 | 990 | 3 |
853256 | 853256 | 2020-12-22 | Pottawatomie | Kansas | 20149 | 935 | 3 |
850011 | 850011 | 2020-12-21 | Pottawatomie | Kansas | 20149 | 935 | 3 |
846766 | 846766 | 2020-12-20 | Pottawatomie | Kansas | 20149 | 908 | 3 |
843520 | 843520 | 2020-12-19 | Pottawatomie | Kansas | 20149 | 908 | 3 |
840275 | 840275 | 2020-12-18 | Pottawatomie | Kansas | 20149 | 908 | 3 |
837030 | 837030 | 2020-12-17 | Pottawatomie | Kansas | 20149 | 866 | 3 |
833784 | 833784 | 2020-12-16 | Pottawatomie | Kansas | 20149 | 866 | 3 |
830537 | 830537 | 2020-12-15 | Pottawatomie | Kansas | 20149 | 834 | 3 |
827291 | 827291 | 2020-12-14 | Pottawatomie | Kansas | 20149 | 834 | 3 |
824044 | 824044 | 2020-12-13 | Pottawatomie | Kansas | 20149 | 799 | 3 |
820798 | 820798 | 2020-12-12 | Pottawatomie | Kansas | 20149 | 799 | 3 |
817552 | 817552 | 2020-12-11 | Pottawatomie | Kansas | 20149 | 799 | 3 |
814306 | 814306 | 2020-12-10 | Pottawatomie | Kansas | 20149 | 776 | 3 |
811061 | 811061 | 2020-12-09 | Pottawatomie | Kansas | 20149 | 776 | 3 |
807816 | 807816 | 2020-12-08 | Pottawatomie | Kansas | 20149 | 754 | 3 |
804571 | 804571 | 2020-12-07 | Pottawatomie | Kansas | 20149 | 754 | 3 |
801326 | 801326 | 2020-12-06 | Pottawatomie | Kansas | 20149 | 725 | 3 |
798081 | 798081 | 2020-12-05 | Pottawatomie | Kansas | 20149 | 725 | 3 |
794836 | 794836 | 2020-12-04 | Pottawatomie | Kansas | 20149 | 725 | 3 |
791591 | 791591 | 2020-12-03 | Pottawatomie | Kansas | 20149 | 703 | 2 |
788346 | 788346 | 2020-12-02 | Pottawatomie | Kansas | 20149 | 703 | 2 |
785102 | 785102 | 2020-12-01 | Pottawatomie | Kansas | 20149 | 691 | 2 |
781857 | 781857 | 2020-11-30 | Pottawatomie | Kansas | 20149 | 691 | 2 |
778611 | 778611 | 2020-11-29 | Pottawatomie | Kansas | 20149 | 676 | 2 |
775366 | 775366 | 2020-11-28 | Pottawatomie | Kansas | 20149 | 676 | 2 |
772121 | 772121 | 2020-11-27 | Pottawatomie | Kansas | 20149 | 676 | 2 |
768876 | 768876 | 2020-11-26 | Pottawatomie | Kansas | 20149 | 665 | 2 |
765630 | 765630 | 2020-11-25 | Pottawatomie | Kansas | 20149 | 665 | 2 |
762385 | 762385 | 2020-11-24 | Pottawatomie | Kansas | 20149 | 649 | 2 |
759140 | 759140 | 2020-11-23 | Pottawatomie | Kansas | 20149 | 649 | 2 |
755893 | 755893 | 2020-11-22 | Pottawatomie | Kansas | 20149 | 613 | 2 |
752647 | 752647 | 2020-11-21 | Pottawatomie | Kansas | 20149 | 613 | 2 |
749401 | 749401 | 2020-11-20 | Pottawatomie | Kansas | 20149 | 613 | 2 |
746155 | 746155 | 2020-11-19 | Pottawatomie | Kansas | 20149 | 590 | 2 |
742908 | 742908 | 2020-11-18 | Pottawatomie | Kansas | 20149 | 590 | 2 |
739661 | 739661 | 2020-11-17 | Pottawatomie | Kansas | 20149 | 574 | 0 |
736417 | 736417 | 2020-11-16 | Pottawatomie | Kansas | 20149 | 574 | 0 |
733171 | 733171 | 2020-11-15 | Pottawatomie | Kansas | 20149 | 534 | 0 |
729926 | 729926 | 2020-11-14 | Pottawatomie | Kansas | 20149 | 534 | 0 |
726683 | 726683 | 2020-11-13 | Pottawatomie | Kansas | 20149 | 534 | 0 |
723440 | 723440 | 2020-11-12 | Pottawatomie | Kansas | 20149 | 506 | 0 |
720197 | 720197 | 2020-11-11 | Pottawatomie | Kansas | 20149 | 506 | 0 |
716954 | 716954 | 2020-11-10 | Pottawatomie | Kansas | 20149 | 487 | 0 |
713710 | 713710 | 2020-11-09 | Pottawatomie | Kansas | 20149 | 487 | 0 |
710466 | 710466 | 2020-11-08 | Pottawatomie | Kansas | 20149 | 455 | 0 |
707222 | 707222 | 2020-11-07 | Pottawatomie | Kansas | 20149 | 455 | 0 |
703979 | 703979 | 2020-11-06 | Pottawatomie | Kansas | 20149 | 455 | 0 |
700737 | 700737 | 2020-11-05 | Pottawatomie | Kansas | 20149 | 434 | 0 |
697493 | 697493 | 2020-11-04 | Pottawatomie | Kansas | 20149 | 434 | 0 |
694251 | 694251 | 2020-11-03 | Pottawatomie | Kansas | 20149 | 420 | 0 |
691008 | 691008 | 2020-11-02 | Pottawatomie | Kansas | 20149 | 420 | 0 |
687763 | 687763 | 2020-11-01 | Pottawatomie | Kansas | 20149 | 405 | 0 |
684519 | 684519 | 2020-10-31 | Pottawatomie | Kansas | 20149 | 405 | 0 |
681276 | 681276 | 2020-10-30 | Pottawatomie | Kansas | 20149 | 405 | 0 |
678033 | 678033 | 2020-10-29 | Pottawatomie | Kansas | 20149 | 392 | 0 |
674790 | 674790 | 2020-10-28 | Pottawatomie | Kansas | 20149 | 392 | 0 |
671548 | 671548 | 2020-10-27 | Pottawatomie | Kansas | 20149 | 381 | 0 |
668305 | 668305 | 2020-10-26 | Pottawatomie | Kansas | 20149 | 381 | 0 |
665061 | 665061 | 2020-10-25 | Pottawatomie | Kansas | 20149 | 370 | 0 |
661816 | 661816 | 2020-10-24 | Pottawatomie | Kansas | 20149 | 370 | 0 |
658572 | 658572 | 2020-10-23 | Pottawatomie | Kansas | 20149 | 370 | 0 |
655327 | 655327 | 2020-10-22 | Pottawatomie | Kansas | 20149 | 362 | 0 |
652082 | 652082 | 2020-10-21 | Pottawatomie | Kansas | 20149 | 362 | 0 |
648838 | 648838 | 2020-10-20 | Pottawatomie | Kansas | 20149 | 353 | 0 |
645593 | 645593 | 2020-10-19 | Pottawatomie | Kansas | 20149 | 353 | 0 |
642346 | 642346 | 2020-10-18 | Pottawatomie | Kansas | 20149 | 347 | 0 |
639099 | 639099 | 2020-10-17 | Pottawatomie | Kansas | 20149 | 347 | 0 |
635853 | 635853 | 2020-10-16 | Pottawatomie | Kansas | 20149 | 347 | 0 |
632607 | 632607 | 2020-10-15 | Pottawatomie | Kansas | 20149 | 335 | 0 |
629363 | 629363 | 2020-10-14 | Pottawatomie | Kansas | 20149 | 335 | 0 |
626120 | 626120 | 2020-10-13 | Pottawatomie | Kansas | 20149 | 327 | 0 |
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);