ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Bourbon" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947300 | 947300 | 2021-01-20 | Bourbon | Kansas | 20011 | 1181 | 3 |
944053 | 944053 | 2021-01-19 | Bourbon | Kansas | 20011 | 1164 | 3 |
940808 | 940808 | 2021-01-18 | Bourbon | Kansas | 20011 | 1164 | 3 |
937563 | 937563 | 2021-01-17 | Bourbon | Kansas | 20011 | 1151 | 3 |
934318 | 934318 | 2021-01-16 | Bourbon | Kansas | 20011 | 1151 | 3 |
931073 | 931073 | 2021-01-15 | Bourbon | Kansas | 20011 | 1151 | 3 |
927828 | 927828 | 2021-01-14 | Bourbon | Kansas | 20011 | 1123 | 3 |
924582 | 924582 | 2021-01-13 | Bourbon | Kansas | 20011 | 1123 | 3 |
921337 | 921337 | 2021-01-12 | Bourbon | Kansas | 20011 | 1081 | 3 |
918092 | 918092 | 2021-01-11 | Bourbon | Kansas | 20011 | 1081 | 3 |
914847 | 914847 | 2021-01-10 | Bourbon | Kansas | 20011 | 1066 | 3 |
911602 | 911602 | 2021-01-09 | Bourbon | Kansas | 20011 | 1066 | 3 |
908357 | 908357 | 2021-01-08 | Bourbon | Kansas | 20011 | 1066 | 3 |
905111 | 905111 | 2021-01-07 | Bourbon | Kansas | 20011 | 1034 | 3 |
901866 | 901866 | 2021-01-06 | Bourbon | Kansas | 20011 | 1034 | 3 |
898621 | 898621 | 2021-01-05 | Bourbon | Kansas | 20011 | 1003 | 3 |
895376 | 895376 | 2021-01-04 | Bourbon | Kansas | 20011 | 1003 | 3 |
892129 | 892129 | 2021-01-03 | Bourbon | Kansas | 20011 | 971 | 3 |
888883 | 888883 | 2021-01-02 | Bourbon | Kansas | 20011 | 971 | 3 |
885637 | 885637 | 2021-01-01 | Bourbon | Kansas | 20011 | 971 | 3 |
882392 | 882392 | 2020-12-31 | Bourbon | Kansas | 20011 | 927 | 3 |
879147 | 879147 | 2020-12-30 | Bourbon | Kansas | 20011 | 927 | 3 |
875902 | 875902 | 2020-12-29 | Bourbon | Kansas | 20011 | 870 | 3 |
872657 | 872657 | 2020-12-28 | Bourbon | Kansas | 20011 | 870 | 3 |
869412 | 869412 | 2020-12-27 | Bourbon | Kansas | 20011 | 834 | 3 |
866167 | 866167 | 2020-12-26 | Bourbon | Kansas | 20011 | 834 | 3 |
862922 | 862922 | 2020-12-25 | Bourbon | Kansas | 20011 | 834 | 3 |
859677 | 859677 | 2020-12-24 | Bourbon | Kansas | 20011 | 834 | 3 |
856432 | 856432 | 2020-12-23 | Bourbon | Kansas | 20011 | 834 | 3 |
853187 | 853187 | 2020-12-22 | Bourbon | Kansas | 20011 | 811 | 3 |
849942 | 849942 | 2020-12-21 | Bourbon | Kansas | 20011 | 811 | 3 |
846697 | 846697 | 2020-12-20 | Bourbon | Kansas | 20011 | 799 | 3 |
843451 | 843451 | 2020-12-19 | Bourbon | Kansas | 20011 | 799 | 3 |
840206 | 840206 | 2020-12-18 | Bourbon | Kansas | 20011 | 799 | 3 |
836961 | 836961 | 2020-12-17 | Bourbon | Kansas | 20011 | 762 | 3 |
833715 | 833715 | 2020-12-16 | Bourbon | Kansas | 20011 | 762 | 3 |
830468 | 830468 | 2020-12-15 | Bourbon | Kansas | 20011 | 730 | 3 |
827222 | 827222 | 2020-12-14 | Bourbon | Kansas | 20011 | 730 | 3 |
823975 | 823975 | 2020-12-13 | Bourbon | Kansas | 20011 | 722 | 3 |
820729 | 820729 | 2020-12-12 | Bourbon | Kansas | 20011 | 722 | 3 |
817483 | 817483 | 2020-12-11 | Bourbon | Kansas | 20011 | 722 | 3 |
814237 | 814237 | 2020-12-10 | Bourbon | Kansas | 20011 | 695 | 3 |
810992 | 810992 | 2020-12-09 | Bourbon | Kansas | 20011 | 695 | 3 |
807747 | 807747 | 2020-12-08 | Bourbon | Kansas | 20011 | 663 | 3 |
804502 | 804502 | 2020-12-07 | Bourbon | Kansas | 20011 | 663 | 3 |
801257 | 801257 | 2020-12-06 | Bourbon | Kansas | 20011 | 641 | 3 |
798012 | 798012 | 2020-12-05 | Bourbon | Kansas | 20011 | 641 | 3 |
794767 | 794767 | 2020-12-04 | Bourbon | Kansas | 20011 | 641 | 3 |
791522 | 791522 | 2020-12-03 | Bourbon | Kansas | 20011 | 609 | 3 |
788277 | 788277 | 2020-12-02 | Bourbon | Kansas | 20011 | 609 | 3 |
785033 | 785033 | 2020-12-01 | Bourbon | Kansas | 20011 | 564 | 3 |
781788 | 781788 | 2020-11-30 | Bourbon | Kansas | 20011 | 564 | 3 |
778542 | 778542 | 2020-11-29 | Bourbon | Kansas | 20011 | 543 | 3 |
775297 | 775297 | 2020-11-28 | Bourbon | Kansas | 20011 | 543 | 3 |
772052 | 772052 | 2020-11-27 | Bourbon | Kansas | 20011 | 543 | 3 |
768807 | 768807 | 2020-11-26 | Bourbon | Kansas | 20011 | 520 | 3 |
765561 | 765561 | 2020-11-25 | Bourbon | Kansas | 20011 | 520 | 3 |
762316 | 762316 | 2020-11-24 | Bourbon | Kansas | 20011 | 495 | 3 |
759071 | 759071 | 2020-11-23 | Bourbon | Kansas | 20011 | 495 | 3 |
755824 | 755824 | 2020-11-22 | Bourbon | Kansas | 20011 | 463 | 3 |
752578 | 752578 | 2020-11-21 | Bourbon | Kansas | 20011 | 463 | 3 |
749332 | 749332 | 2020-11-20 | Bourbon | Kansas | 20011 | 463 | 3 |
746086 | 746086 | 2020-11-19 | Bourbon | Kansas | 20011 | 438 | 3 |
742839 | 742839 | 2020-11-18 | Bourbon | Kansas | 20011 | 438 | 3 |
739592 | 739592 | 2020-11-17 | Bourbon | Kansas | 20011 | 395 | 3 |
736348 | 736348 | 2020-11-16 | Bourbon | Kansas | 20011 | 395 | 3 |
733102 | 733102 | 2020-11-15 | Bourbon | Kansas | 20011 | 382 | 3 |
729857 | 729857 | 2020-11-14 | Bourbon | Kansas | 20011 | 382 | 3 |
726614 | 726614 | 2020-11-13 | Bourbon | Kansas | 20011 | 382 | 3 |
723371 | 723371 | 2020-11-12 | Bourbon | Kansas | 20011 | 365 | 3 |
720128 | 720128 | 2020-11-11 | Bourbon | Kansas | 20011 | 365 | 3 |
716885 | 716885 | 2020-11-10 | Bourbon | Kansas | 20011 | 343 | 3 |
713641 | 713641 | 2020-11-09 | Bourbon | Kansas | 20011 | 343 | 3 |
710397 | 710397 | 2020-11-08 | Bourbon | Kansas | 20011 | 334 | 3 |
707153 | 707153 | 2020-11-07 | Bourbon | Kansas | 20011 | 334 | 3 |
703910 | 703910 | 2020-11-06 | Bourbon | Kansas | 20011 | 334 | 3 |
700668 | 700668 | 2020-11-05 | Bourbon | Kansas | 20011 | 328 | 3 |
697424 | 697424 | 2020-11-04 | Bourbon | Kansas | 20011 | 328 | 3 |
694182 | 694182 | 2020-11-03 | Bourbon | Kansas | 20011 | 315 | 3 |
690939 | 690939 | 2020-11-02 | Bourbon | Kansas | 20011 | 315 | 3 |
687694 | 687694 | 2020-11-01 | Bourbon | Kansas | 20011 | 307 | 3 |
684450 | 684450 | 2020-10-31 | Bourbon | Kansas | 20011 | 307 | 3 |
681207 | 681207 | 2020-10-30 | Bourbon | Kansas | 20011 | 307 | 3 |
677964 | 677964 | 2020-10-29 | Bourbon | Kansas | 20011 | 303 | 3 |
674721 | 674721 | 2020-10-28 | Bourbon | Kansas | 20011 | 303 | 3 |
671479 | 671479 | 2020-10-27 | Bourbon | Kansas | 20011 | 303 | 3 |
668236 | 668236 | 2020-10-26 | Bourbon | Kansas | 20011 | 303 | 3 |
664992 | 664992 | 2020-10-25 | Bourbon | Kansas | 20011 | 303 | 3 |
661747 | 661747 | 2020-10-24 | Bourbon | Kansas | 20011 | 303 | 3 |
658503 | 658503 | 2020-10-23 | Bourbon | Kansas | 20011 | 303 | 3 |
655258 | 655258 | 2020-10-22 | Bourbon | Kansas | 20011 | 303 | 3 |
652013 | 652013 | 2020-10-21 | Bourbon | Kansas | 20011 | 303 | 3 |
648769 | 648769 | 2020-10-20 | Bourbon | Kansas | 20011 | 303 | 3 |
645524 | 645524 | 2020-10-19 | Bourbon | Kansas | 20011 | 264 | 3 |
642277 | 642277 | 2020-10-18 | Bourbon | Kansas | 20011 | 264 | 3 |
639030 | 639030 | 2020-10-17 | Bourbon | Kansas | 20011 | 264 | 3 |
635784 | 635784 | 2020-10-16 | Bourbon | Kansas | 20011 | 264 | 3 |
632538 | 632538 | 2020-10-15 | Bourbon | Kansas | 20011 | 264 | 3 |
629294 | 629294 | 2020-10-14 | Bourbon | Kansas | 20011 | 264 | 3 |
626051 | 626051 | 2020-10-13 | Bourbon | Kansas | 20011 | 264 | 3 |
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);