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 |
---|---|---|---|---|---|---|---|
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 |
596917 | 596917 | 2020-10-04 | Lincoln | Kansas | 20105 | 14 | 0 |
593675 | 593675 | 2020-10-03 | Lincoln | Kansas | 20105 | 14 | 0 |
590434 | 590434 | 2020-10-02 | Lincoln | Kansas | 20105 | 14 | 0 |
587193 | 587193 | 2020-10-01 | Lincoln | Kansas | 20105 | 14 | 0 |
583953 | 583953 | 2020-09-30 | Lincoln | Kansas | 20105 | 14 | 0 |
580714 | 580714 | 2020-09-29 | Lincoln | Kansas | 20105 | 14 | 0 |
577473 | 577473 | 2020-09-28 | Lincoln | Kansas | 20105 | 14 | 0 |
574231 | 574231 | 2020-09-27 | Lincoln | Kansas | 20105 | 12 | 0 |
570988 | 570988 | 2020-09-26 | Lincoln | Kansas | 20105 | 12 | 0 |
567746 | 567746 | 2020-09-25 | Lincoln | Kansas | 20105 | 12 | 0 |
564506 | 564506 | 2020-09-24 | Lincoln | Kansas | 20105 | 12 | 0 |
561266 | 561266 | 2020-09-23 | Lincoln | Kansas | 20105 | 12 | 0 |
558030 | 558030 | 2020-09-22 | Lincoln | Kansas | 20105 | 12 | 0 |
554793 | 554793 | 2020-09-21 | Lincoln | Kansas | 20105 | 12 | 0 |
551554 | 551554 | 2020-09-20 | Lincoln | Kansas | 20105 | 12 | 0 |
548315 | 548315 | 2020-09-19 | Lincoln | Kansas | 20105 | 12 | 0 |
545077 | 545077 | 2020-09-18 | Lincoln | Kansas | 20105 | 12 | 0 |
541841 | 541841 | 2020-09-17 | Lincoln | Kansas | 20105 | 12 | 0 |
538604 | 538604 | 2020-09-16 | Lincoln | Kansas | 20105 | 12 | 0 |
535368 | 535368 | 2020-09-15 | Lincoln | Kansas | 20105 | 11 | 0 |
532133 | 532133 | 2020-09-14 | Lincoln | Kansas | 20105 | 11 | 0 |
528896 | 528896 | 2020-09-13 | Lincoln | Kansas | 20105 | 11 | 0 |
525660 | 525660 | 2020-09-12 | Lincoln | Kansas | 20105 | 11 | 0 |
522424 | 522424 | 2020-09-11 | Lincoln | Kansas | 20105 | 11 | 0 |
519187 | 519187 | 2020-09-10 | Lincoln | Kansas | 20105 | 11 | 0 |
515952 | 515952 | 2020-09-09 | Lincoln | Kansas | 20105 | 11 | 0 |
512719 | 512719 | 2020-09-08 | Lincoln | Kansas | 20105 | 10 | 0 |
509486 | 509486 | 2020-09-07 | Lincoln | Kansas | 20105 | 10 | 0 |
506254 | 506254 | 2020-09-06 | Lincoln | Kansas | 20105 | 10 | 0 |
503020 | 503020 | 2020-09-05 | Lincoln | Kansas | 20105 | 10 | 0 |
499786 | 499786 | 2020-09-04 | Lincoln | Kansas | 20105 | 10 | 0 |
496553 | 496553 | 2020-09-03 | Lincoln | Kansas | 20105 | 8 | 0 |
493319 | 493319 | 2020-09-02 | Lincoln | Kansas | 20105 | 8 | 0 |
490086 | 490086 | 2020-09-01 | Lincoln | Kansas | 20105 | 8 | 0 |
486853 | 486853 | 2020-08-31 | Lincoln | Kansas | 20105 | 8 | 0 |
483618 | 483618 | 2020-08-30 | Lincoln | Kansas | 20105 | 8 | 0 |
480384 | 480384 | 2020-08-29 | Lincoln | Kansas | 20105 | 8 | 0 |
477151 | 477151 | 2020-08-28 | Lincoln | Kansas | 20105 | 8 | 0 |
473918 | 473918 | 2020-08-27 | Lincoln | Kansas | 20105 | 7 | 0 |
470686 | 470686 | 2020-08-26 | Lincoln | Kansas | 20105 | 7 | 0 |
467457 | 467457 | 2020-08-25 | Lincoln | Kansas | 20105 | 6 | 0 |
464228 | 464228 | 2020-08-24 | Lincoln | Kansas | 20105 | 6 | 0 |
460999 | 460999 | 2020-08-23 | Lincoln | Kansas | 20105 | 6 | 0 |
457772 | 457772 | 2020-08-22 | Lincoln | Kansas | 20105 | 6 | 0 |
454544 | 454544 | 2020-08-21 | Lincoln | Kansas | 20105 | 6 | 0 |
451316 | 451316 | 2020-08-20 | Lincoln | Kansas | 20105 | 6 | 0 |
448088 | 448088 | 2020-08-19 | Lincoln | Kansas | 20105 | 6 | 0 |
444861 | 444861 | 2020-08-18 | Lincoln | Kansas | 20105 | 6 | 0 |
441635 | 441635 | 2020-08-17 | Lincoln | Kansas | 20105 | 6 | 0 |
438408 | 438408 | 2020-08-16 | Lincoln | Kansas | 20105 | 6 | 0 |
435183 | 435183 | 2020-08-15 | Lincoln | Kansas | 20105 | 6 | 0 |
431958 | 431958 | 2020-08-14 | Lincoln | Kansas | 20105 | 6 | 0 |
428730 | 428730 | 2020-08-13 | Lincoln | Kansas | 20105 | 6 | 0 |
425506 | 425506 | 2020-08-12 | Lincoln | Kansas | 20105 | 6 | 0 |
422285 | 422285 | 2020-08-11 | Lincoln | Kansas | 20105 | 6 | 0 |
419062 | 419062 | 2020-08-10 | Lincoln | Kansas | 20105 | 6 | 0 |
415841 | 415841 | 2020-08-09 | Lincoln | Kansas | 20105 | 6 | 0 |
412621 | 412621 | 2020-08-08 | Lincoln | Kansas | 20105 | 6 | 0 |
409401 | 409401 | 2020-08-07 | Lincoln | Kansas | 20105 | 6 | 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);