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 |
---|---|---|---|---|---|---|---|
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 |
729903 | 729903 | 2020-11-14 | Leavenworth | Kansas | 20103 | 3095 | 25 |
726660 | 726660 | 2020-11-13 | Leavenworth | Kansas | 20103 | 3095 | 25 |
723417 | 723417 | 2020-11-12 | Leavenworth | Kansas | 20103 | 3010 | 25 |
720174 | 720174 | 2020-11-11 | Leavenworth | Kansas | 20103 | 3010 | 25 |
716931 | 716931 | 2020-11-10 | Leavenworth | Kansas | 20103 | 2913 | 21 |
713687 | 713687 | 2020-11-09 | Leavenworth | Kansas | 20103 | 2913 | 21 |
710443 | 710443 | 2020-11-08 | Leavenworth | Kansas | 20103 | 2830 | 21 |
707199 | 707199 | 2020-11-07 | Leavenworth | Kansas | 20103 | 2830 | 21 |
703956 | 703956 | 2020-11-06 | Leavenworth | Kansas | 20103 | 2830 | 21 |
700714 | 700714 | 2020-11-05 | Leavenworth | Kansas | 20103 | 2779 | 21 |
697470 | 697470 | 2020-11-04 | Leavenworth | Kansas | 20103 | 2779 | 21 |
694228 | 694228 | 2020-11-03 | Leavenworth | Kansas | 20103 | 2736 | 20 |
690985 | 690985 | 2020-11-02 | Leavenworth | Kansas | 20103 | 2736 | 20 |
687740 | 687740 | 2020-11-01 | Leavenworth | Kansas | 20103 | 2687 | 18 |
684496 | 684496 | 2020-10-31 | Leavenworth | Kansas | 20103 | 2687 | 18 |
681253 | 681253 | 2020-10-30 | Leavenworth | Kansas | 20103 | 2687 | 18 |
678010 | 678010 | 2020-10-29 | Leavenworth | Kansas | 20103 | 2648 | 18 |
674767 | 674767 | 2020-10-28 | Leavenworth | Kansas | 20103 | 2648 | 18 |
671525 | 671525 | 2020-10-27 | Leavenworth | Kansas | 20103 | 2613 | 18 |
668282 | 668282 | 2020-10-26 | Leavenworth | Kansas | 20103 | 2613 | 18 |
665038 | 665038 | 2020-10-25 | Leavenworth | Kansas | 20103 | 2582 | 18 |
661793 | 661793 | 2020-10-24 | Leavenworth | Kansas | 20103 | 2582 | 18 |
658549 | 658549 | 2020-10-23 | Leavenworth | Kansas | 20103 | 2582 | 18 |
655304 | 655304 | 2020-10-22 | Leavenworth | Kansas | 20103 | 2561 | 18 |
652059 | 652059 | 2020-10-21 | Leavenworth | Kansas | 20103 | 2561 | 18 |
648815 | 648815 | 2020-10-20 | Leavenworth | Kansas | 20103 | 2534 | 17 |
645570 | 645570 | 2020-10-19 | Leavenworth | Kansas | 20103 | 2534 | 17 |
642323 | 642323 | 2020-10-18 | Leavenworth | Kansas | 20103 | 2487 | 17 |
639076 | 639076 | 2020-10-17 | Leavenworth | Kansas | 20103 | 2487 | 17 |
635830 | 635830 | 2020-10-16 | Leavenworth | Kansas | 20103 | 2487 | 17 |
632584 | 632584 | 2020-10-15 | Leavenworth | Kansas | 20103 | 2449 | 17 |
629340 | 629340 | 2020-10-14 | Leavenworth | Kansas | 20103 | 2449 | 17 |
626097 | 626097 | 2020-10-13 | Leavenworth | Kansas | 20103 | 2429 | 15 |
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);