ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Lincoln" and fips = 27081 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921804 | 921804 | 2021-01-12 | Lincoln | Minnesota | 27081 | 477 | 1 |
918559 | 918559 | 2021-01-11 | Lincoln | Minnesota | 27081 | 477 | 1 |
915314 | 915314 | 2021-01-10 | Lincoln | Minnesota | 27081 | 477 | 1 |
912069 | 912069 | 2021-01-09 | Lincoln | Minnesota | 27081 | 475 | 1 |
908824 | 908824 | 2021-01-08 | Lincoln | Minnesota | 27081 | 471 | 1 |
905578 | 905578 | 2021-01-07 | Lincoln | Minnesota | 27081 | 468 | 1 |
902333 | 902333 | 2021-01-06 | Lincoln | Minnesota | 27081 | 464 | 1 |
899088 | 899088 | 2021-01-05 | Lincoln | Minnesota | 27081 | 462 | 1 |
895843 | 895843 | 2021-01-04 | Lincoln | Minnesota | 27081 | 460 | 1 |
892596 | 892596 | 2021-01-03 | Lincoln | Minnesota | 27081 | 456 | 1 |
889350 | 889350 | 2021-01-02 | Lincoln | Minnesota | 27081 | 454 | 1 |
886104 | 886104 | 2021-01-01 | Lincoln | Minnesota | 27081 | 454 | 1 |
882859 | 882859 | 2020-12-31 | Lincoln | Minnesota | 27081 | 454 | 1 |
879614 | 879614 | 2020-12-30 | Lincoln | Minnesota | 27081 | 449 | 1 |
876369 | 876369 | 2020-12-29 | Lincoln | Minnesota | 27081 | 447 | 1 |
873124 | 873124 | 2020-12-28 | Lincoln | Minnesota | 27081 | 445 | 1 |
869879 | 869879 | 2020-12-27 | Lincoln | Minnesota | 27081 | 445 | 1 |
866634 | 866634 | 2020-12-26 | Lincoln | Minnesota | 27081 | 445 | 1 |
863389 | 863389 | 2020-12-25 | Lincoln | Minnesota | 27081 | 444 | 1 |
860144 | 860144 | 2020-12-24 | Lincoln | Minnesota | 27081 | 444 | 1 |
856899 | 856899 | 2020-12-23 | Lincoln | Minnesota | 27081 | 442 | 1 |
853654 | 853654 | 2020-12-22 | Lincoln | Minnesota | 27081 | 440 | 1 |
850409 | 850409 | 2020-12-21 | Lincoln | Minnesota | 27081 | 438 | 1 |
847164 | 847164 | 2020-12-20 | Lincoln | Minnesota | 27081 | 436 | 1 |
843918 | 843918 | 2020-12-19 | Lincoln | Minnesota | 27081 | 436 | 1 |
840673 | 840673 | 2020-12-18 | Lincoln | Minnesota | 27081 | 433 | 1 |
837428 | 837428 | 2020-12-17 | Lincoln | Minnesota | 27081 | 433 | 1 |
834182 | 834182 | 2020-12-16 | Lincoln | Minnesota | 27081 | 431 | 1 |
830935 | 830935 | 2020-12-15 | Lincoln | Minnesota | 27081 | 431 | 1 |
827689 | 827689 | 2020-12-14 | Lincoln | Minnesota | 27081 | 427 | 1 |
824442 | 824442 | 2020-12-13 | Lincoln | Minnesota | 27081 | 427 | 1 |
821196 | 821196 | 2020-12-12 | Lincoln | Minnesota | 27081 | 420 | 1 |
817950 | 817950 | 2020-12-11 | Lincoln | Minnesota | 27081 | 420 | 1 |
814704 | 814704 | 2020-12-10 | Lincoln | Minnesota | 27081 | 418 | 1 |
811459 | 811459 | 2020-12-09 | Lincoln | Minnesota | 27081 | 412 | 1 |
808214 | 808214 | 2020-12-08 | Lincoln | Minnesota | 27081 | 406 | 1 |
804969 | 804969 | 2020-12-07 | Lincoln | Minnesota | 27081 | 405 | 1 |
801724 | 801724 | 2020-12-06 | Lincoln | Minnesota | 27081 | 403 | 1 |
798479 | 798479 | 2020-12-05 | Lincoln | Minnesota | 27081 | 398 | 1 |
795234 | 795234 | 2020-12-04 | Lincoln | Minnesota | 27081 | 390 | 1 |
791989 | 791989 | 2020-12-03 | Lincoln | Minnesota | 27081 | 381 | 1 |
788744 | 788744 | 2020-12-02 | Lincoln | Minnesota | 27081 | 372 | 1 |
785499 | 785499 | 2020-12-01 | Lincoln | Minnesota | 27081 | 368 | 1 |
782255 | 782255 | 2020-11-30 | Lincoln | Minnesota | 27081 | 365 | 1 |
779009 | 779009 | 2020-11-29 | Lincoln | Minnesota | 27081 | 359 | 1 |
775764 | 775764 | 2020-11-28 | Lincoln | Minnesota | 27081 | 351 | 1 |
772519 | 772519 | 2020-11-27 | Lincoln | Minnesota | 27081 | 333 | 1 |
769274 | 769274 | 2020-11-26 | Lincoln | Minnesota | 27081 | 317 | 1 |
766028 | 766028 | 2020-11-25 | Lincoln | Minnesota | 27081 | 317 | 1 |
762783 | 762783 | 2020-11-24 | Lincoln | Minnesota | 27081 | 317 | 1 |
759538 | 759538 | 2020-11-23 | Lincoln | Minnesota | 27081 | 314 | 1 |
756291 | 756291 | 2020-11-22 | Lincoln | Minnesota | 27081 | 308 | 1 |
753045 | 753045 | 2020-11-21 | Lincoln | Minnesota | 27081 | 293 | 1 |
749799 | 749799 | 2020-11-20 | Lincoln | Minnesota | 27081 | 286 | 1 |
746553 | 746553 | 2020-11-19 | Lincoln | Minnesota | 27081 | 281 | 1 |
743306 | 743306 | 2020-11-18 | Lincoln | Minnesota | 27081 | 275 | 1 |
740059 | 740059 | 2020-11-17 | Lincoln | Minnesota | 27081 | 270 | 1 |
736815 | 736815 | 2020-11-16 | Lincoln | Minnesota | 27081 | 266 | 1 |
733569 | 733569 | 2020-11-15 | Lincoln | Minnesota | 27081 | 262 | 1 |
730324 | 730324 | 2020-11-14 | Lincoln | Minnesota | 27081 | 256 | 1 |
727081 | 727081 | 2020-11-13 | Lincoln | Minnesota | 27081 | 248 | 1 |
723838 | 723838 | 2020-11-12 | Lincoln | Minnesota | 27081 | 242 | 1 |
720595 | 720595 | 2020-11-11 | Lincoln | Minnesota | 27081 | 240 | 1 |
717352 | 717352 | 2020-11-10 | Lincoln | Minnesota | 27081 | 234 | 1 |
714108 | 714108 | 2020-11-09 | Lincoln | Minnesota | 27081 | 231 | 1 |
710864 | 710864 | 2020-11-08 | Lincoln | Minnesota | 27081 | 229 | 1 |
707620 | 707620 | 2020-11-07 | Lincoln | Minnesota | 27081 | 226 | 1 |
704377 | 704377 | 2020-11-06 | Lincoln | Minnesota | 27081 | 222 | 1 |
701135 | 701135 | 2020-11-05 | Lincoln | Minnesota | 27081 | 219 | 1 |
697891 | 697891 | 2020-11-04 | Lincoln | Minnesota | 27081 | 214 | 0 |
694648 | 694648 | 2020-11-03 | Lincoln | Minnesota | 27081 | 212 | 0 |
691406 | 691406 | 2020-11-02 | Lincoln | Minnesota | 27081 | 210 | 0 |
688161 | 688161 | 2020-11-01 | Lincoln | Minnesota | 27081 | 208 | 0 |
684917 | 684917 | 2020-10-31 | Lincoln | Minnesota | 27081 | 203 | 0 |
681674 | 681674 | 2020-10-30 | Lincoln | Minnesota | 27081 | 197 | 0 |
678430 | 678430 | 2020-10-29 | Lincoln | Minnesota | 27081 | 193 | 0 |
675188 | 675188 | 2020-10-28 | Lincoln | Minnesota | 27081 | 191 | 0 |
671945 | 671945 | 2020-10-27 | Lincoln | Minnesota | 27081 | 189 | 0 |
668703 | 668703 | 2020-10-26 | Lincoln | Minnesota | 27081 | 184 | 0 |
665459 | 665459 | 2020-10-25 | Lincoln | Minnesota | 27081 | 182 | 0 |
662214 | 662214 | 2020-10-24 | Lincoln | Minnesota | 27081 | 182 | 0 |
658970 | 658970 | 2020-10-23 | Lincoln | Minnesota | 27081 | 176 | 0 |
655725 | 655725 | 2020-10-22 | Lincoln | Minnesota | 27081 | 172 | 0 |
652480 | 652480 | 2020-10-21 | Lincoln | Minnesota | 27081 | 171 | 0 |
649235 | 649235 | 2020-10-20 | Lincoln | Minnesota | 27081 | 167 | 0 |
645991 | 645991 | 2020-10-19 | Lincoln | Minnesota | 27081 | 165 | 0 |
642744 | 642744 | 2020-10-18 | Lincoln | Minnesota | 27081 | 164 | 0 |
639497 | 639497 | 2020-10-17 | Lincoln | Minnesota | 27081 | 161 | 0 |
636251 | 636251 | 2020-10-16 | Lincoln | Minnesota | 27081 | 156 | 0 |
633005 | 633005 | 2020-10-15 | Lincoln | Minnesota | 27081 | 151 | 0 |
629760 | 629760 | 2020-10-14 | Lincoln | Minnesota | 27081 | 150 | 0 |
626516 | 626516 | 2020-10-13 | Lincoln | Minnesota | 27081 | 149 | 0 |
623274 | 623274 | 2020-10-12 | Lincoln | Minnesota | 27081 | 147 | 0 |
620031 | 620031 | 2020-10-11 | Lincoln | Minnesota | 27081 | 147 | 0 |
616789 | 616789 | 2020-10-10 | Lincoln | Minnesota | 27081 | 144 | 0 |
613548 | 613548 | 2020-10-09 | Lincoln | Minnesota | 27081 | 140 | 0 |
610306 | 610306 | 2020-10-08 | Lincoln | Minnesota | 27081 | 136 | 0 |
607064 | 607064 | 2020-10-07 | Lincoln | Minnesota | 27081 | 132 | 0 |
603821 | 603821 | 2020-10-06 | Lincoln | Minnesota | 27081 | 129 | 0 |
600579 | 600579 | 2020-10-05 | Lincoln | Minnesota | 27081 | 127 | 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);