ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
673 rows where county = "Lincoln" and fips = 20105 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054453 | 1054453 | 2021-02-22 | Lincoln | Kansas | 20105 | 254 | 4 |
1051206 | 1051206 | 2021-02-21 | Lincoln | Kansas | 20105 | 254 | 4 |
1047959 | 1047959 | 2021-02-20 | Lincoln | Kansas | 20105 | 254 | 4 |
1044714 | 1044714 | 2021-02-19 | Lincoln | Kansas | 20105 | 254 | 4 |
1041469 | 1041469 | 2021-02-18 | Lincoln | Kansas | 20105 | 254 | 4 |
1038224 | 1038224 | 2021-02-17 | Lincoln | Kansas | 20105 | 254 | 4 |
1034979 | 1034979 | 2021-02-16 | Lincoln | Kansas | 20105 | 253 | 4 |
1031733 | 1031733 | 2021-02-15 | Lincoln | Kansas | 20105 | 253 | 4 |
1028486 | 1028486 | 2021-02-14 | Lincoln | Kansas | 20105 | 252 | 4 |
1025241 | 1025241 | 2021-02-13 | Lincoln | Kansas | 20105 | 252 | 4 |
1021996 | 1021996 | 2021-02-12 | Lincoln | Kansas | 20105 | 252 | 4 |
1018751 | 1018751 | 2021-02-11 | Lincoln | Kansas | 20105 | 251 | 4 |
1015506 | 1015506 | 2021-02-10 | Lincoln | Kansas | 20105 | 251 | 4 |
1012261 | 1012261 | 2021-02-09 | Lincoln | Kansas | 20105 | 252 | 4 |
1009015 | 1009015 | 2021-02-08 | Lincoln | Kansas | 20105 | 252 | 4 |
1005769 | 1005769 | 2021-02-07 | Lincoln | Kansas | 20105 | 250 | 4 |
1002523 | 1002523 | 2021-02-06 | Lincoln | Kansas | 20105 | 250 | 4 |
999277 | 999277 | 2021-02-05 | Lincoln | Kansas | 20105 | 250 | 4 |
996031 | 996031 | 2021-02-04 | Lincoln | Kansas | 20105 | 250 | 4 |
992785 | 992785 | 2021-02-03 | Lincoln | Kansas | 20105 | 250 | 4 |
989539 | 989539 | 2021-02-02 | Lincoln | Kansas | 20105 | 249 | 4 |
986292 | 986292 | 2021-02-01 | Lincoln | Kansas | 20105 | 249 | 4 |
983045 | 983045 | 2021-01-31 | Lincoln | Kansas | 20105 | 248 | 4 |
979799 | 979799 | 2021-01-30 | Lincoln | Kansas | 20105 | 248 | 4 |
976553 | 976553 | 2021-01-29 | Lincoln | Kansas | 20105 | 248 | 4 |
973308 | 973308 | 2021-01-28 | Lincoln | Kansas | 20105 | 247 | 4 |
970063 | 970063 | 2021-01-27 | Lincoln | Kansas | 20105 | 247 | 4 |
966819 | 966819 | 2021-01-26 | Lincoln | Kansas | 20105 | 246 | 4 |
963574 | 963574 | 2021-01-25 | Lincoln | Kansas | 20105 | 246 | 4 |
960329 | 960329 | 2021-01-24 | Lincoln | Kansas | 20105 | 244 | 4 |
957083 | 957083 | 2021-01-23 | Lincoln | Kansas | 20105 | 244 | 4 |
953838 | 953838 | 2021-01-22 | Lincoln | Kansas | 20105 | 244 | 4 |
950593 | 950593 | 2021-01-21 | Lincoln | Kansas | 20105 | 243 | 3 |
947347 | 947347 | 2021-01-20 | Lincoln | Kansas | 20105 | 243 | 3 |
944100 | 944100 | 2021-01-19 | Lincoln | Kansas | 20105 | 240 | 3 |
940855 | 940855 | 2021-01-18 | Lincoln | Kansas | 20105 | 240 | 3 |
937610 | 937610 | 2021-01-17 | Lincoln | Kansas | 20105 | 236 | 2 |
934365 | 934365 | 2021-01-16 | Lincoln | Kansas | 20105 | 236 | 2 |
931120 | 931120 | 2021-01-15 | Lincoln | Kansas | 20105 | 236 | 2 |
927875 | 927875 | 2021-01-14 | Lincoln | Kansas | 20105 | 235 | 2 |
924629 | 924629 | 2021-01-13 | Lincoln | Kansas | 20105 | 235 | 2 |
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 |
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);