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 |
---|---|---|---|---|---|---|---|
1054475 | 1054475 | 2021-02-22 | Pottawatomie | Kansas | 20149 | 1728 | 24 |
1051228 | 1051228 | 2021-02-21 | Pottawatomie | Kansas | 20149 | 1728 | 24 |
1047981 | 1047981 | 2021-02-20 | Pottawatomie | Kansas | 20149 | 1728 | 24 |
1044736 | 1044736 | 2021-02-19 | Pottawatomie | Kansas | 20149 | 1728 | 24 |
1041491 | 1041491 | 2021-02-18 | Pottawatomie | Kansas | 20149 | 1713 | 23 |
1038246 | 1038246 | 2021-02-17 | Pottawatomie | Kansas | 20149 | 1713 | 23 |
1035001 | 1035001 | 2021-02-16 | Pottawatomie | Kansas | 20149 | 1642 | 21 |
1031755 | 1031755 | 2021-02-15 | Pottawatomie | Kansas | 20149 | 1642 | 21 |
1028508 | 1028508 | 2021-02-14 | Pottawatomie | Kansas | 20149 | 1637 | 21 |
1025263 | 1025263 | 2021-02-13 | Pottawatomie | Kansas | 20149 | 1637 | 21 |
1022018 | 1022018 | 2021-02-12 | Pottawatomie | Kansas | 20149 | 1637 | 21 |
1018773 | 1018773 | 2021-02-11 | Pottawatomie | Kansas | 20149 | 1615 | 21 |
1015528 | 1015528 | 2021-02-10 | Pottawatomie | Kansas | 20149 | 1615 | 19 |
1012283 | 1012283 | 2021-02-09 | Pottawatomie | Kansas | 20149 | 1593 | 19 |
1009037 | 1009037 | 2021-02-08 | Pottawatomie | Kansas | 20149 | 1593 | 18 |
1005791 | 1005791 | 2021-02-07 | Pottawatomie | Kansas | 20149 | 1573 | 11 |
1002545 | 1002545 | 2021-02-06 | Pottawatomie | Kansas | 20149 | 1573 | 11 |
999299 | 999299 | 2021-02-05 | Pottawatomie | Kansas | 20149 | 1573 | 11 |
996053 | 996053 | 2021-02-04 | Pottawatomie | Kansas | 20149 | 1548 | 11 |
992807 | 992807 | 2021-02-03 | Pottawatomie | Kansas | 20149 | 1548 | 11 |
989561 | 989561 | 2021-02-02 | Pottawatomie | Kansas | 20149 | 1527 | 11 |
986314 | 986314 | 2021-02-01 | Pottawatomie | Kansas | 20149 | 1527 | 11 |
983067 | 983067 | 2021-01-31 | Pottawatomie | Kansas | 20149 | 1502 | 11 |
979821 | 979821 | 2021-01-30 | Pottawatomie | Kansas | 20149 | 1502 | 11 |
976575 | 976575 | 2021-01-29 | Pottawatomie | Kansas | 20149 | 1502 | 11 |
973330 | 973330 | 2021-01-28 | Pottawatomie | Kansas | 20149 | 1472 | 10 |
970085 | 970085 | 2021-01-27 | Pottawatomie | Kansas | 20149 | 1472 | 10 |
966841 | 966841 | 2021-01-26 | Pottawatomie | Kansas | 20149 | 1449 | 10 |
963596 | 963596 | 2021-01-25 | Pottawatomie | Kansas | 20149 | 1449 | 9 |
960351 | 960351 | 2021-01-24 | Pottawatomie | Kansas | 20149 | 1418 | 9 |
957105 | 957105 | 2021-01-23 | Pottawatomie | Kansas | 20149 | 1418 | 9 |
953860 | 953860 | 2021-01-22 | Pottawatomie | Kansas | 20149 | 1418 | 9 |
950615 | 950615 | 2021-01-21 | Pottawatomie | Kansas | 20149 | 1391 | 9 |
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 |
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);