ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 20127 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054464 | 1054464 | 2021-02-22 | Morris | Kansas | 20127 | 588 | 20 |
1051217 | 1051217 | 2021-02-21 | Morris | Kansas | 20127 | 581 | 17 |
1047970 | 1047970 | 2021-02-20 | Morris | Kansas | 20127 | 581 | 17 |
1044725 | 1044725 | 2021-02-19 | Morris | Kansas | 20127 | 581 | 17 |
1041480 | 1041480 | 2021-02-18 | Morris | Kansas | 20127 | 581 | 17 |
1038235 | 1038235 | 2021-02-17 | Morris | Kansas | 20127 | 581 | 17 |
1034990 | 1034990 | 2021-02-16 | Morris | Kansas | 20127 | 581 | 17 |
1031744 | 1031744 | 2021-02-15 | Morris | Kansas | 20127 | 573 | 17 |
1028497 | 1028497 | 2021-02-14 | Morris | Kansas | 20127 | 573 | 17 |
1025252 | 1025252 | 2021-02-13 | Morris | Kansas | 20127 | 573 | 17 |
1022007 | 1022007 | 2021-02-12 | Morris | Kansas | 20127 | 573 | 17 |
1018762 | 1018762 | 2021-02-11 | Morris | Kansas | 20127 | 573 | 17 |
1015517 | 1015517 | 2021-02-10 | Morris | Kansas | 20127 | 573 | 17 |
1012272 | 1012272 | 2021-02-09 | Morris | Kansas | 20127 | 573 | 17 |
1009026 | 1009026 | 2021-02-08 | Morris | Kansas | 20127 | 551 | 17 |
1005780 | 1005780 | 2021-02-07 | Morris | Kansas | 20127 | 551 | 17 |
1002534 | 1002534 | 2021-02-06 | Morris | Kansas | 20127 | 551 | 17 |
999288 | 999288 | 2021-02-05 | Morris | Kansas | 20127 | 551 | 17 |
996042 | 996042 | 2021-02-04 | Morris | Kansas | 20127 | 551 | 17 |
992796 | 992796 | 2021-02-03 | Morris | Kansas | 20127 | 530 | 16 |
989550 | 989550 | 2021-02-02 | Morris | Kansas | 20127 | 530 | 16 |
986303 | 986303 | 2021-02-01 | Morris | Kansas | 20127 | 530 | 16 |
983056 | 983056 | 2021-01-31 | Morris | Kansas | 20127 | 530 | 16 |
979810 | 979810 | 2021-01-30 | Morris | Kansas | 20127 | 530 | 16 |
976564 | 976564 | 2021-01-29 | Morris | Kansas | 20127 | 530 | 16 |
973319 | 973319 | 2021-01-28 | Morris | Kansas | 20127 | 530 | 16 |
970074 | 970074 | 2021-01-27 | Morris | Kansas | 20127 | 530 | 16 |
966830 | 966830 | 2021-01-26 | Morris | Kansas | 20127 | 530 | 16 |
963585 | 963585 | 2021-01-25 | Morris | Kansas | 20127 | 530 | 16 |
960340 | 960340 | 2021-01-24 | Morris | Kansas | 20127 | 502 | 16 |
957094 | 957094 | 2021-01-23 | Morris | Kansas | 20127 | 502 | 16 |
953849 | 953849 | 2021-01-22 | Morris | Kansas | 20127 | 502 | 16 |
950604 | 950604 | 2021-01-21 | Morris | Kansas | 20127 | 502 | 16 |
947358 | 947358 | 2021-01-20 | Morris | Kansas | 20127 | 502 | 16 |
944111 | 944111 | 2021-01-19 | Morris | Kansas | 20127 | 502 | 16 |
940866 | 940866 | 2021-01-18 | Morris | Kansas | 20127 | 502 | 16 |
937621 | 937621 | 2021-01-17 | Morris | Kansas | 20127 | 478 | 6 |
934376 | 934376 | 2021-01-16 | Morris | Kansas | 20127 | 478 | 6 |
931131 | 931131 | 2021-01-15 | Morris | Kansas | 20127 | 478 | 6 |
927886 | 927886 | 2021-01-14 | Morris | Kansas | 20127 | 478 | 6 |
924640 | 924640 | 2021-01-13 | Morris | Kansas | 20127 | 478 | 6 |
921395 | 921395 | 2021-01-12 | Morris | Kansas | 20127 | 439 | 6 |
918150 | 918150 | 2021-01-11 | Morris | Kansas | 20127 | 439 | 6 |
914905 | 914905 | 2021-01-10 | Morris | Kansas | 20127 | 439 | 6 |
911660 | 911660 | 2021-01-09 | Morris | Kansas | 20127 | 439 | 6 |
908415 | 908415 | 2021-01-08 | Morris | Kansas | 20127 | 439 | 6 |
905169 | 905169 | 2021-01-07 | Morris | Kansas | 20127 | 439 | 6 |
901924 | 901924 | 2021-01-06 | Morris | Kansas | 20127 | 439 | 6 |
898679 | 898679 | 2021-01-05 | Morris | Kansas | 20127 | 439 | 6 |
895434 | 895434 | 2021-01-04 | Morris | Kansas | 20127 | 439 | 6 |
892187 | 892187 | 2021-01-03 | Morris | Kansas | 20127 | 404 | 4 |
888941 | 888941 | 2021-01-02 | Morris | Kansas | 20127 | 404 | 4 |
885695 | 885695 | 2021-01-01 | Morris | Kansas | 20127 | 404 | 4 |
882450 | 882450 | 2020-12-31 | Morris | Kansas | 20127 | 404 | 4 |
879205 | 879205 | 2020-12-30 | Morris | Kansas | 20127 | 404 | 4 |
875960 | 875960 | 2020-12-29 | Morris | Kansas | 20127 | 404 | 4 |
872715 | 872715 | 2020-12-28 | Morris | Kansas | 20127 | 373 | 2 |
869470 | 869470 | 2020-12-27 | Morris | Kansas | 20127 | 373 | 2 |
866225 | 866225 | 2020-12-26 | Morris | Kansas | 20127 | 373 | 2 |
862980 | 862980 | 2020-12-25 | Morris | Kansas | 20127 | 373 | 2 |
859735 | 859735 | 2020-12-24 | Morris | Kansas | 20127 | 373 | 2 |
856490 | 856490 | 2020-12-23 | Morris | Kansas | 20127 | 373 | 2 |
853245 | 853245 | 2020-12-22 | Morris | Kansas | 20127 | 373 | 2 |
850000 | 850000 | 2020-12-21 | Morris | Kansas | 20127 | 373 | 2 |
846755 | 846755 | 2020-12-20 | Morris | Kansas | 20127 | 339 | 2 |
843509 | 843509 | 2020-12-19 | Morris | Kansas | 20127 | 339 | 2 |
840264 | 840264 | 2020-12-18 | Morris | Kansas | 20127 | 339 | 2 |
837019 | 837019 | 2020-12-17 | Morris | Kansas | 20127 | 339 | 2 |
833773 | 833773 | 2020-12-16 | Morris | Kansas | 20127 | 339 | 1 |
830526 | 830526 | 2020-12-15 | Morris | Kansas | 20127 | 339 | 1 |
827280 | 827280 | 2020-12-14 | Morris | Kansas | 20127 | 299 | 1 |
824033 | 824033 | 2020-12-13 | Morris | Kansas | 20127 | 299 | 1 |
820787 | 820787 | 2020-12-12 | Morris | Kansas | 20127 | 299 | 1 |
817541 | 817541 | 2020-12-11 | Morris | Kansas | 20127 | 299 | 1 |
814295 | 814295 | 2020-12-10 | Morris | Kansas | 20127 | 299 | 1 |
811050 | 811050 | 2020-12-09 | Morris | Kansas | 20127 | 299 | 1 |
807805 | 807805 | 2020-12-08 | Morris | Kansas | 20127 | 299 | 1 |
804560 | 804560 | 2020-12-07 | Morris | Kansas | 20127 | 299 | 1 |
801315 | 801315 | 2020-12-06 | Morris | Kansas | 20127 | 220 | 1 |
798070 | 798070 | 2020-12-05 | Morris | Kansas | 20127 | 220 | 1 |
794825 | 794825 | 2020-12-04 | Morris | Kansas | 20127 | 220 | 1 |
791580 | 791580 | 2020-12-03 | Morris | Kansas | 20127 | 205 | 1 |
788335 | 788335 | 2020-12-02 | Morris | Kansas | 20127 | 205 | 1 |
785091 | 785091 | 2020-12-01 | Morris | Kansas | 20127 | 205 | 1 |
781846 | 781846 | 2020-11-30 | Morris | Kansas | 20127 | 205 | 1 |
778600 | 778600 | 2020-11-29 | Morris | Kansas | 20127 | 166 | 1 |
775355 | 775355 | 2020-11-28 | Morris | Kansas | 20127 | 166 | 1 |
772110 | 772110 | 2020-11-27 | Morris | Kansas | 20127 | 166 | 1 |
768865 | 768865 | 2020-11-26 | Morris | Kansas | 20127 | 163 | 1 |
765619 | 765619 | 2020-11-25 | Morris | Kansas | 20127 | 163 | 1 |
762374 | 762374 | 2020-11-24 | Morris | Kansas | 20127 | 163 | 1 |
759129 | 759129 | 2020-11-23 | Morris | Kansas | 20127 | 163 | 1 |
755882 | 755882 | 2020-11-22 | Morris | Kansas | 20127 | 147 | 1 |
752636 | 752636 | 2020-11-21 | Morris | Kansas | 20127 | 147 | 1 |
749390 | 749390 | 2020-11-20 | Morris | Kansas | 20127 | 147 | 1 |
746144 | 746144 | 2020-11-19 | Morris | Kansas | 20127 | 143 | 1 |
742897 | 742897 | 2020-11-18 | Morris | Kansas | 20127 | 143 | 1 |
739650 | 739650 | 2020-11-17 | Morris | Kansas | 20127 | 140 | 1 |
736406 | 736406 | 2020-11-16 | Morris | Kansas | 20127 | 140 | 1 |
733160 | 733160 | 2020-11-15 | Morris | Kansas | 20127 | 140 | 1 |
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);