ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
673 rows where county = "Lincoln" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921384 | 921384 | 2021-01-12 | Lincoln | Kansas | 20105 | 235 | 2 |
918139 | 918139 | 2021-01-11 | Lincoln | Kansas | 20105 | 235 | 2 |
914894 | 914894 | 2021-01-10 | Lincoln | Kansas | 20105 | 227 | 2 |
911649 | 911649 | 2021-01-09 | Lincoln | Kansas | 20105 | 227 | 2 |
908404 | 908404 | 2021-01-08 | Lincoln | Kansas | 20105 | 227 | 2 |
905158 | 905158 | 2021-01-07 | Lincoln | Kansas | 20105 | 225 | 2 |
901913 | 901913 | 2021-01-06 | Lincoln | Kansas | 20105 | 221 | 2 |
898668 | 898668 | 2021-01-05 | Lincoln | Kansas | 20105 | 217 | 2 |
895423 | 895423 | 2021-01-04 | Lincoln | Kansas | 20105 | 217 | 2 |
892176 | 892176 | 2021-01-03 | Lincoln | Kansas | 20105 | 217 | 2 |
888930 | 888930 | 2021-01-02 | Lincoln | Kansas | 20105 | 217 | 2 |
885684 | 885684 | 2021-01-01 | Lincoln | Kansas | 20105 | 217 | 2 |
882439 | 882439 | 2020-12-31 | Lincoln | Kansas | 20105 | 208 | 2 |
879194 | 879194 | 2020-12-30 | Lincoln | Kansas | 20105 | 208 | 2 |
875949 | 875949 | 2020-12-29 | Lincoln | Kansas | 20105 | 201 | 2 |
872704 | 872704 | 2020-12-28 | Lincoln | Kansas | 20105 | 201 | 2 |
869459 | 869459 | 2020-12-27 | Lincoln | Kansas | 20105 | 194 | 2 |
866214 | 866214 | 2020-12-26 | Lincoln | Kansas | 20105 | 184 | 1 |
862969 | 862969 | 2020-12-25 | Lincoln | Kansas | 20105 | 184 | 1 |
859724 | 859724 | 2020-12-24 | Lincoln | Kansas | 20105 | 184 | 1 |
856479 | 856479 | 2020-12-23 | Lincoln | Kansas | 20105 | 184 | 1 |
853234 | 853234 | 2020-12-22 | Lincoln | Kansas | 20105 | 182 | 1 |
849989 | 849989 | 2020-12-21 | Lincoln | Kansas | 20105 | 177 | 1 |
846744 | 846744 | 2020-12-20 | Lincoln | Kansas | 20105 | 174 | 1 |
843498 | 843498 | 2020-12-19 | Lincoln | Kansas | 20105 | 174 | 1 |
840253 | 840253 | 2020-12-18 | Lincoln | Kansas | 20105 | 174 | 1 |
837008 | 837008 | 2020-12-17 | Lincoln | Kansas | 20105 | 153 | 1 |
833762 | 833762 | 2020-12-16 | Lincoln | Kansas | 20105 | 153 | 1 |
830515 | 830515 | 2020-12-15 | Lincoln | Kansas | 20105 | 150 | 1 |
827269 | 827269 | 2020-12-14 | Lincoln | Kansas | 20105 | 150 | 1 |
824022 | 824022 | 2020-12-13 | Lincoln | Kansas | 20105 | 146 | 1 |
820776 | 820776 | 2020-12-12 | Lincoln | Kansas | 20105 | 146 | 1 |
817530 | 817530 | 2020-12-11 | Lincoln | Kansas | 20105 | 146 | 1 |
814284 | 814284 | 2020-12-10 | Lincoln | Kansas | 20105 | 144 | 1 |
811039 | 811039 | 2020-12-09 | Lincoln | Kansas | 20105 | 144 | 1 |
807794 | 807794 | 2020-12-08 | Lincoln | Kansas | 20105 | 122 | 1 |
804549 | 804549 | 2020-12-07 | Lincoln | Kansas | 20105 | 122 | 1 |
801304 | 801304 | 2020-12-06 | Lincoln | Kansas | 20105 | 109 | 1 |
798059 | 798059 | 2020-12-05 | Lincoln | Kansas | 20105 | 109 | 1 |
794814 | 794814 | 2020-12-04 | Lincoln | Kansas | 20105 | 109 | 1 |
791569 | 791569 | 2020-12-03 | Lincoln | Kansas | 20105 | 98 | 1 |
788324 | 788324 | 2020-12-02 | Lincoln | Kansas | 20105 | 98 | 1 |
785080 | 785080 | 2020-12-01 | Lincoln | Kansas | 20105 | 94 | 1 |
781835 | 781835 | 2020-11-30 | Lincoln | Kansas | 20105 | 90 | 1 |
778589 | 778589 | 2020-11-29 | Lincoln | Kansas | 20105 | 82 | 1 |
775344 | 775344 | 2020-11-28 | Lincoln | Kansas | 20105 | 78 | 1 |
772099 | 772099 | 2020-11-27 | Lincoln | Kansas | 20105 | 78 | 1 |
768854 | 768854 | 2020-11-26 | Lincoln | Kansas | 20105 | 67 | 1 |
765608 | 765608 | 2020-11-25 | Lincoln | Kansas | 20105 | 67 | 1 |
762363 | 762363 | 2020-11-24 | Lincoln | Kansas | 20105 | 63 | 1 |
759118 | 759118 | 2020-11-23 | Lincoln | Kansas | 20105 | 63 | 1 |
755871 | 755871 | 2020-11-22 | Lincoln | Kansas | 20105 | 57 | 1 |
752625 | 752625 | 2020-11-21 | Lincoln | Kansas | 20105 | 57 | 1 |
749379 | 749379 | 2020-11-20 | Lincoln | Kansas | 20105 | 57 | 1 |
746133 | 746133 | 2020-11-19 | Lincoln | Kansas | 20105 | 44 | 1 |
742886 | 742886 | 2020-11-18 | Lincoln | Kansas | 20105 | 44 | 1 |
739639 | 739639 | 2020-11-17 | Lincoln | Kansas | 20105 | 39 | 1 |
736395 | 736395 | 2020-11-16 | Lincoln | Kansas | 20105 | 39 | 1 |
733149 | 733149 | 2020-11-15 | Lincoln | Kansas | 20105 | 31 | 1 |
729904 | 729904 | 2020-11-14 | Lincoln | Kansas | 20105 | 31 | 1 |
726661 | 726661 | 2020-11-13 | Lincoln | Kansas | 20105 | 31 | 1 |
723418 | 723418 | 2020-11-12 | Lincoln | Kansas | 20105 | 28 | 1 |
720175 | 720175 | 2020-11-11 | Lincoln | Kansas | 20105 | 28 | 1 |
716932 | 716932 | 2020-11-10 | Lincoln | Kansas | 20105 | 26 | 1 |
713688 | 713688 | 2020-11-09 | Lincoln | Kansas | 20105 | 26 | 1 |
710444 | 710444 | 2020-11-08 | Lincoln | Kansas | 20105 | 25 | 1 |
707200 | 707200 | 2020-11-07 | Lincoln | Kansas | 20105 | 25 | 1 |
703957 | 703957 | 2020-11-06 | Lincoln | Kansas | 20105 | 25 | 1 |
700715 | 700715 | 2020-11-05 | Lincoln | Kansas | 20105 | 24 | 1 |
697471 | 697471 | 2020-11-04 | Lincoln | Kansas | 20105 | 24 | 1 |
694229 | 694229 | 2020-11-03 | Lincoln | Kansas | 20105 | 24 | 1 |
690986 | 690986 | 2020-11-02 | Lincoln | Kansas | 20105 | 24 | 1 |
687741 | 687741 | 2020-11-01 | Lincoln | Kansas | 20105 | 23 | 1 |
684497 | 684497 | 2020-10-31 | Lincoln | Kansas | 20105 | 23 | 1 |
681254 | 681254 | 2020-10-30 | Lincoln | Kansas | 20105 | 23 | 1 |
678011 | 678011 | 2020-10-29 | Lincoln | Kansas | 20105 | 23 | 1 |
674768 | 674768 | 2020-10-28 | Lincoln | Kansas | 20105 | 23 | 1 |
671526 | 671526 | 2020-10-27 | Lincoln | Kansas | 20105 | 22 | 1 |
668283 | 668283 | 2020-10-26 | Lincoln | Kansas | 20105 | 22 | 1 |
665039 | 665039 | 2020-10-25 | Lincoln | Kansas | 20105 | 21 | 1 |
661794 | 661794 | 2020-10-24 | Lincoln | Kansas | 20105 | 21 | 1 |
658550 | 658550 | 2020-10-23 | Lincoln | Kansas | 20105 | 21 | 1 |
655305 | 655305 | 2020-10-22 | Lincoln | Kansas | 20105 | 20 | 1 |
652060 | 652060 | 2020-10-21 | Lincoln | Kansas | 20105 | 20 | 1 |
648816 | 648816 | 2020-10-20 | Lincoln | Kansas | 20105 | 19 | 1 |
645571 | 645571 | 2020-10-19 | Lincoln | Kansas | 20105 | 19 | 1 |
642324 | 642324 | 2020-10-18 | Lincoln | Kansas | 20105 | 19 | 1 |
639077 | 639077 | 2020-10-17 | Lincoln | Kansas | 20105 | 17 | 1 |
635831 | 635831 | 2020-10-16 | Lincoln | Kansas | 20105 | 17 | 1 |
632585 | 632585 | 2020-10-15 | Lincoln | Kansas | 20105 | 16 | 1 |
629341 | 629341 | 2020-10-14 | Lincoln | Kansas | 20105 | 16 | 1 |
626098 | 626098 | 2020-10-13 | Lincoln | Kansas | 20105 | 16 | 0 |
622856 | 622856 | 2020-10-12 | Lincoln | Kansas | 20105 | 16 | 0 |
619612 | 619612 | 2020-10-11 | Lincoln | Kansas | 20105 | 15 | 0 |
616370 | 616370 | 2020-10-10 | Lincoln | Kansas | 20105 | 15 | 0 |
613129 | 613129 | 2020-10-09 | Lincoln | Kansas | 20105 | 15 | 0 |
609887 | 609887 | 2020-10-08 | Lincoln | Kansas | 20105 | 15 | 0 |
606644 | 606644 | 2020-10-07 | Lincoln | Kansas | 20105 | 15 | 0 |
603402 | 603402 | 2020-10-06 | Lincoln | Kansas | 20105 | 15 | 0 |
600159 | 600159 | 2020-10-05 | Lincoln | Kansas | 20105 | 15 | 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);