ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Leavenworth" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054452 | 1054452 | 2021-02-22 | Leavenworth | Kansas | 20103 | 6708 | 50 |
1051205 | 1051205 | 2021-02-21 | Leavenworth | Kansas | 20103 | 6680 | 49 |
1047958 | 1047958 | 2021-02-20 | Leavenworth | Kansas | 20103 | 6680 | 49 |
1044713 | 1044713 | 2021-02-19 | Leavenworth | Kansas | 20103 | 6680 | 49 |
1041468 | 1041468 | 2021-02-18 | Leavenworth | Kansas | 20103 | 6632 | 48 |
1038223 | 1038223 | 2021-02-17 | Leavenworth | Kansas | 20103 | 6632 | 48 |
1034978 | 1034978 | 2021-02-16 | Leavenworth | Kansas | 20103 | 6601 | 48 |
1031732 | 1031732 | 2021-02-15 | Leavenworth | Kansas | 20103 | 6601 | 48 |
1028485 | 1028485 | 2021-02-14 | Leavenworth | Kansas | 20103 | 6555 | 48 |
1025240 | 1025240 | 2021-02-13 | Leavenworth | Kansas | 20103 | 6555 | 48 |
1021995 | 1021995 | 2021-02-12 | Leavenworth | Kansas | 20103 | 6555 | 48 |
1018750 | 1018750 | 2021-02-11 | Leavenworth | Kansas | 20103 | 6516 | 48 |
1015505 | 1015505 | 2021-02-10 | Leavenworth | Kansas | 20103 | 6516 | 48 |
1012260 | 1012260 | 2021-02-09 | Leavenworth | Kansas | 20103 | 6451 | 48 |
1009014 | 1009014 | 2021-02-08 | Leavenworth | Kansas | 20103 | 6451 | 48 |
1005768 | 1005768 | 2021-02-07 | Leavenworth | Kansas | 20103 | 6378 | 47 |
1002522 | 1002522 | 2021-02-06 | Leavenworth | Kansas | 20103 | 6378 | 47 |
999276 | 999276 | 2021-02-05 | Leavenworth | Kansas | 20103 | 6378 | 47 |
996030 | 996030 | 2021-02-04 | Leavenworth | Kansas | 20103 | 6304 | 47 |
992784 | 992784 | 2021-02-03 | Leavenworth | Kansas | 20103 | 6304 | 47 |
989538 | 989538 | 2021-02-02 | Leavenworth | Kansas | 20103 | 6247 | 47 |
986291 | 986291 | 2021-02-01 | Leavenworth | Kansas | 20103 | 6247 | 47 |
983044 | 983044 | 2021-01-31 | Leavenworth | Kansas | 20103 | 6186 | 45 |
979798 | 979798 | 2021-01-30 | Leavenworth | Kansas | 20103 | 6186 | 45 |
976552 | 976552 | 2021-01-29 | Leavenworth | Kansas | 20103 | 6186 | 45 |
973307 | 973307 | 2021-01-28 | Leavenworth | Kansas | 20103 | 6121 | 45 |
970062 | 970062 | 2021-01-27 | Leavenworth | Kansas | 20103 | 6121 | 45 |
966818 | 966818 | 2021-01-26 | Leavenworth | Kansas | 20103 | 6011 | 43 |
963573 | 963573 | 2021-01-25 | Leavenworth | Kansas | 20103 | 6011 | 43 |
960328 | 960328 | 2021-01-24 | Leavenworth | Kansas | 20103 | 5968 | 43 |
957082 | 957082 | 2021-01-23 | Leavenworth | Kansas | 20103 | 5968 | 43 |
953837 | 953837 | 2021-01-22 | Leavenworth | Kansas | 20103 | 5968 | 43 |
950592 | 950592 | 2021-01-21 | Leavenworth | Kansas | 20103 | 5866 | 43 |
947346 | 947346 | 2021-01-20 | Leavenworth | Kansas | 20103 | 5866 | 43 |
944099 | 944099 | 2021-01-19 | Leavenworth | Kansas | 20103 | 5780 | 42 |
940854 | 940854 | 2021-01-18 | Leavenworth | Kansas | 20103 | 5780 | 42 |
937609 | 937609 | 2021-01-17 | Leavenworth | Kansas | 20103 | 5666 | 42 |
934364 | 934364 | 2021-01-16 | Leavenworth | Kansas | 20103 | 5666 | 42 |
931119 | 931119 | 2021-01-15 | Leavenworth | Kansas | 20103 | 5666 | 42 |
927874 | 927874 | 2021-01-14 | Leavenworth | Kansas | 20103 | 5574 | 42 |
924628 | 924628 | 2021-01-13 | Leavenworth | Kansas | 20103 | 5574 | 42 |
921383 | 921383 | 2021-01-12 | Leavenworth | Kansas | 20103 | 5512 | 42 |
918138 | 918138 | 2021-01-11 | Leavenworth | Kansas | 20103 | 5512 | 42 |
914893 | 914893 | 2021-01-10 | Leavenworth | Kansas | 20103 | 5395 | 42 |
911648 | 911648 | 2021-01-09 | Leavenworth | Kansas | 20103 | 5395 | 42 |
908403 | 908403 | 2021-01-08 | Leavenworth | Kansas | 20103 | 5395 | 42 |
905157 | 905157 | 2021-01-07 | Leavenworth | Kansas | 20103 | 5279 | 42 |
901912 | 901912 | 2021-01-06 | Leavenworth | Kansas | 20103 | 5279 | 42 |
898667 | 898667 | 2021-01-05 | Leavenworth | Kansas | 20103 | 5183 | 39 |
895422 | 895422 | 2021-01-04 | Leavenworth | Kansas | 20103 | 5183 | 39 |
892175 | 892175 | 2021-01-03 | Leavenworth | Kansas | 20103 | 5118 | 38 |
888929 | 888929 | 2021-01-02 | Leavenworth | Kansas | 20103 | 5118 | 38 |
885683 | 885683 | 2021-01-01 | Leavenworth | Kansas | 20103 | 5118 | 38 |
882438 | 882438 | 2020-12-31 | Leavenworth | Kansas | 20103 | 5044 | 38 |
879193 | 879193 | 2020-12-30 | Leavenworth | Kansas | 20103 | 5044 | 38 |
875948 | 875948 | 2020-12-29 | Leavenworth | Kansas | 20103 | 4939 | 38 |
872703 | 872703 | 2020-12-28 | Leavenworth | Kansas | 20103 | 4939 | 38 |
869458 | 869458 | 2020-12-27 | Leavenworth | Kansas | 20103 | 4823 | 38 |
866213 | 866213 | 2020-12-26 | Leavenworth | Kansas | 20103 | 4823 | 38 |
862968 | 862968 | 2020-12-25 | Leavenworth | Kansas | 20103 | 4823 | 38 |
859723 | 859723 | 2020-12-24 | Leavenworth | Kansas | 20103 | 4823 | 38 |
856478 | 856478 | 2020-12-23 | Leavenworth | Kansas | 20103 | 4823 | 38 |
853233 | 853233 | 2020-12-22 | Leavenworth | Kansas | 20103 | 4761 | 37 |
849988 | 849988 | 2020-12-21 | Leavenworth | Kansas | 20103 | 4761 | 37 |
846743 | 846743 | 2020-12-20 | Leavenworth | Kansas | 20103 | 4698 | 36 |
843497 | 843497 | 2020-12-19 | Leavenworth | Kansas | 20103 | 4698 | 36 |
840252 | 840252 | 2020-12-18 | Leavenworth | Kansas | 20103 | 4698 | 36 |
837007 | 837007 | 2020-12-17 | Leavenworth | Kansas | 20103 | 4553 | 36 |
833761 | 833761 | 2020-12-16 | Leavenworth | Kansas | 20103 | 4553 | 36 |
830514 | 830514 | 2020-12-15 | Leavenworth | Kansas | 20103 | 4435 | 35 |
827268 | 827268 | 2020-12-14 | Leavenworth | Kansas | 20103 | 4435 | 35 |
824021 | 824021 | 2020-12-13 | Leavenworth | Kansas | 20103 | 4347 | 35 |
820775 | 820775 | 2020-12-12 | Leavenworth | Kansas | 20103 | 4347 | 35 |
817529 | 817529 | 2020-12-11 | Leavenworth | Kansas | 20103 | 4347 | 35 |
814283 | 814283 | 2020-12-10 | Leavenworth | Kansas | 20103 | 4269 | 34 |
811038 | 811038 | 2020-12-09 | Leavenworth | Kansas | 20103 | 4269 | 34 |
807793 | 807793 | 2020-12-08 | Leavenworth | Kansas | 20103 | 4138 | 34 |
804548 | 804548 | 2020-12-07 | Leavenworth | Kansas | 20103 | 4138 | 34 |
801303 | 801303 | 2020-12-06 | Leavenworth | Kansas | 20103 | 4001 | 32 |
798058 | 798058 | 2020-12-05 | Leavenworth | Kansas | 20103 | 4001 | 32 |
794813 | 794813 | 2020-12-04 | Leavenworth | Kansas | 20103 | 4001 | 32 |
791568 | 791568 | 2020-12-03 | Leavenworth | Kansas | 20103 | 3895 | 32 |
788323 | 788323 | 2020-12-02 | Leavenworth | Kansas | 20103 | 3895 | 32 |
785079 | 785079 | 2020-12-01 | Leavenworth | Kansas | 20103 | 3817 | 31 |
781834 | 781834 | 2020-11-30 | Leavenworth | Kansas | 20103 | 3817 | 31 |
778588 | 778588 | 2020-11-29 | Leavenworth | Kansas | 20103 | 3729 | 31 |
775343 | 775343 | 2020-11-28 | Leavenworth | Kansas | 20103 | 3729 | 31 |
772098 | 772098 | 2020-11-27 | Leavenworth | Kansas | 20103 | 3729 | 31 |
768853 | 768853 | 2020-11-26 | Leavenworth | Kansas | 20103 | 3612 | 31 |
765607 | 765607 | 2020-11-25 | Leavenworth | Kansas | 20103 | 3612 | 31 |
762362 | 762362 | 2020-11-24 | Leavenworth | Kansas | 20103 | 3503 | 29 |
759117 | 759117 | 2020-11-23 | Leavenworth | Kansas | 20103 | 3503 | 29 |
755870 | 755870 | 2020-11-22 | Leavenworth | Kansas | 20103 | 3408 | 27 |
752624 | 752624 | 2020-11-21 | Leavenworth | Kansas | 20103 | 3408 | 27 |
749378 | 749378 | 2020-11-20 | Leavenworth | Kansas | 20103 | 3408 | 27 |
746132 | 746132 | 2020-11-19 | Leavenworth | Kansas | 20103 | 3297 | 27 |
742885 | 742885 | 2020-11-18 | Leavenworth | Kansas | 20103 | 3297 | 27 |
739638 | 739638 | 2020-11-17 | Leavenworth | Kansas | 20103 | 3208 | 26 |
736394 | 736394 | 2020-11-16 | Leavenworth | Kansas | 20103 | 3208 | 25 |
733148 | 733148 | 2020-11-15 | Leavenworth | Kansas | 20103 | 3095 | 25 |
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);