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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
319649 | 319649 | 2020-07-10 | Lincoln | Kansas | 20105 | 1 | 0 |
322828 | 322828 | 2020-07-11 | Lincoln | Kansas | 20105 | 1 | 0 |
326011 | 326011 | 2020-07-12 | Lincoln | Kansas | 20105 | 1 | 0 |
329197 | 329197 | 2020-07-13 | Lincoln | Kansas | 20105 | 2 | 0 |
332384 | 332384 | 2020-07-14 | Lincoln | Kansas | 20105 | 2 | 0 |
335577 | 335577 | 2020-07-15 | Lincoln | Kansas | 20105 | 4 | 0 |
338773 | 338773 | 2020-07-16 | Lincoln | Kansas | 20105 | 4 | 0 |
341969 | 341969 | 2020-07-17 | Lincoln | Kansas | 20105 | 5 | 0 |
345169 | 345169 | 2020-07-18 | Lincoln | Kansas | 20105 | 5 | 0 |
348370 | 348370 | 2020-07-19 | Lincoln | Kansas | 20105 | 5 | 0 |
351570 | 351570 | 2020-07-20 | Lincoln | Kansas | 20105 | 5 | 0 |
354772 | 354772 | 2020-07-21 | Lincoln | Kansas | 20105 | 5 | 0 |
357974 | 357974 | 2020-07-22 | Lincoln | Kansas | 20105 | 5 | 0 |
361179 | 361179 | 2020-07-23 | Lincoln | Kansas | 20105 | 5 | 0 |
364386 | 364386 | 2020-07-24 | Lincoln | Kansas | 20105 | 6 | 0 |
367593 | 367593 | 2020-07-25 | Lincoln | Kansas | 20105 | 6 | 0 |
370803 | 370803 | 2020-07-26 | Lincoln | Kansas | 20105 | 6 | 0 |
374015 | 374015 | 2020-07-27 | Lincoln | Kansas | 20105 | 6 | 0 |
377230 | 377230 | 2020-07-28 | Lincoln | Kansas | 20105 | 6 | 0 |
380447 | 380447 | 2020-07-29 | Lincoln | Kansas | 20105 | 6 | 0 |
383664 | 383664 | 2020-07-30 | Lincoln | Kansas | 20105 | 6 | 0 |
386882 | 386882 | 2020-07-31 | Lincoln | Kansas | 20105 | 6 | 0 |
390099 | 390099 | 2020-08-01 | Lincoln | Kansas | 20105 | 6 | 0 |
393316 | 393316 | 2020-08-02 | Lincoln | Kansas | 20105 | 6 | 0 |
396532 | 396532 | 2020-08-03 | Lincoln | Kansas | 20105 | 6 | 0 |
399747 | 399747 | 2020-08-04 | Lincoln | Kansas | 20105 | 6 | 0 |
402964 | 402964 | 2020-08-05 | Lincoln | Kansas | 20105 | 6 | 0 |
406182 | 406182 | 2020-08-06 | Lincoln | Kansas | 20105 | 6 | 0 |
409401 | 409401 | 2020-08-07 | Lincoln | Kansas | 20105 | 6 | 0 |
412621 | 412621 | 2020-08-08 | Lincoln | Kansas | 20105 | 6 | 0 |
415841 | 415841 | 2020-08-09 | Lincoln | Kansas | 20105 | 6 | 0 |
419062 | 419062 | 2020-08-10 | Lincoln | Kansas | 20105 | 6 | 0 |
422285 | 422285 | 2020-08-11 | Lincoln | Kansas | 20105 | 6 | 0 |
425506 | 425506 | 2020-08-12 | Lincoln | Kansas | 20105 | 6 | 0 |
428730 | 428730 | 2020-08-13 | Lincoln | Kansas | 20105 | 6 | 0 |
431958 | 431958 | 2020-08-14 | Lincoln | Kansas | 20105 | 6 | 0 |
435183 | 435183 | 2020-08-15 | Lincoln | Kansas | 20105 | 6 | 0 |
438408 | 438408 | 2020-08-16 | Lincoln | Kansas | 20105 | 6 | 0 |
441635 | 441635 | 2020-08-17 | Lincoln | Kansas | 20105 | 6 | 0 |
444861 | 444861 | 2020-08-18 | Lincoln | Kansas | 20105 | 6 | 0 |
448088 | 448088 | 2020-08-19 | Lincoln | Kansas | 20105 | 6 | 0 |
451316 | 451316 | 2020-08-20 | Lincoln | Kansas | 20105 | 6 | 0 |
454544 | 454544 | 2020-08-21 | Lincoln | Kansas | 20105 | 6 | 0 |
457772 | 457772 | 2020-08-22 | Lincoln | Kansas | 20105 | 6 | 0 |
460999 | 460999 | 2020-08-23 | Lincoln | Kansas | 20105 | 6 | 0 |
464228 | 464228 | 2020-08-24 | Lincoln | Kansas | 20105 | 6 | 0 |
467457 | 467457 | 2020-08-25 | Lincoln | Kansas | 20105 | 6 | 0 |
470686 | 470686 | 2020-08-26 | Lincoln | Kansas | 20105 | 7 | 0 |
473918 | 473918 | 2020-08-27 | Lincoln | Kansas | 20105 | 7 | 0 |
477151 | 477151 | 2020-08-28 | Lincoln | Kansas | 20105 | 8 | 0 |
480384 | 480384 | 2020-08-29 | Lincoln | Kansas | 20105 | 8 | 0 |
483618 | 483618 | 2020-08-30 | Lincoln | Kansas | 20105 | 8 | 0 |
486853 | 486853 | 2020-08-31 | Lincoln | Kansas | 20105 | 8 | 0 |
490086 | 490086 | 2020-09-01 | Lincoln | Kansas | 20105 | 8 | 0 |
493319 | 493319 | 2020-09-02 | Lincoln | Kansas | 20105 | 8 | 0 |
496553 | 496553 | 2020-09-03 | Lincoln | Kansas | 20105 | 8 | 0 |
499786 | 499786 | 2020-09-04 | Lincoln | Kansas | 20105 | 10 | 0 |
503020 | 503020 | 2020-09-05 | Lincoln | Kansas | 20105 | 10 | 0 |
506254 | 506254 | 2020-09-06 | Lincoln | Kansas | 20105 | 10 | 0 |
509486 | 509486 | 2020-09-07 | Lincoln | Kansas | 20105 | 10 | 0 |
512719 | 512719 | 2020-09-08 | Lincoln | Kansas | 20105 | 10 | 0 |
515952 | 515952 | 2020-09-09 | Lincoln | Kansas | 20105 | 11 | 0 |
519187 | 519187 | 2020-09-10 | Lincoln | Kansas | 20105 | 11 | 0 |
522424 | 522424 | 2020-09-11 | Lincoln | Kansas | 20105 | 11 | 0 |
525660 | 525660 | 2020-09-12 | Lincoln | Kansas | 20105 | 11 | 0 |
528896 | 528896 | 2020-09-13 | Lincoln | Kansas | 20105 | 11 | 0 |
532133 | 532133 | 2020-09-14 | Lincoln | Kansas | 20105 | 11 | 0 |
535368 | 535368 | 2020-09-15 | Lincoln | Kansas | 20105 | 11 | 0 |
538604 | 538604 | 2020-09-16 | Lincoln | Kansas | 20105 | 12 | 0 |
541841 | 541841 | 2020-09-17 | Lincoln | Kansas | 20105 | 12 | 0 |
545077 | 545077 | 2020-09-18 | Lincoln | Kansas | 20105 | 12 | 0 |
548315 | 548315 | 2020-09-19 | Lincoln | Kansas | 20105 | 12 | 0 |
551554 | 551554 | 2020-09-20 | Lincoln | Kansas | 20105 | 12 | 0 |
554793 | 554793 | 2020-09-21 | Lincoln | Kansas | 20105 | 12 | 0 |
558030 | 558030 | 2020-09-22 | Lincoln | Kansas | 20105 | 12 | 0 |
561266 | 561266 | 2020-09-23 | Lincoln | Kansas | 20105 | 12 | 0 |
564506 | 564506 | 2020-09-24 | Lincoln | Kansas | 20105 | 12 | 0 |
567746 | 567746 | 2020-09-25 | Lincoln | Kansas | 20105 | 12 | 0 |
570988 | 570988 | 2020-09-26 | Lincoln | Kansas | 20105 | 12 | 0 |
574231 | 574231 | 2020-09-27 | Lincoln | Kansas | 20105 | 12 | 0 |
577473 | 577473 | 2020-09-28 | Lincoln | Kansas | 20105 | 14 | 0 |
580714 | 580714 | 2020-09-29 | Lincoln | Kansas | 20105 | 14 | 0 |
583953 | 583953 | 2020-09-30 | Lincoln | Kansas | 20105 | 14 | 0 |
587193 | 587193 | 2020-10-01 | Lincoln | Kansas | 20105 | 14 | 0 |
590434 | 590434 | 2020-10-02 | Lincoln | Kansas | 20105 | 14 | 0 |
593675 | 593675 | 2020-10-03 | Lincoln | Kansas | 20105 | 14 | 0 |
596917 | 596917 | 2020-10-04 | Lincoln | Kansas | 20105 | 14 | 0 |
600159 | 600159 | 2020-10-05 | Lincoln | Kansas | 20105 | 15 | 0 |
603402 | 603402 | 2020-10-06 | Lincoln | Kansas | 20105 | 15 | 0 |
606644 | 606644 | 2020-10-07 | Lincoln | Kansas | 20105 | 15 | 0 |
609887 | 609887 | 2020-10-08 | Lincoln | Kansas | 20105 | 15 | 0 |
613129 | 613129 | 2020-10-09 | Lincoln | Kansas | 20105 | 15 | 0 |
616370 | 616370 | 2020-10-10 | Lincoln | Kansas | 20105 | 15 | 0 |
619612 | 619612 | 2020-10-11 | Lincoln | Kansas | 20105 | 15 | 0 |
622856 | 622856 | 2020-10-12 | Lincoln | Kansas | 20105 | 16 | 0 |
626098 | 626098 | 2020-10-13 | Lincoln | Kansas | 20105 | 16 | 0 |
629341 | 629341 | 2020-10-14 | Lincoln | Kansas | 20105 | 16 | 1 |
632585 | 632585 | 2020-10-15 | Lincoln | Kansas | 20105 | 16 | 1 |
635831 | 635831 | 2020-10-16 | Lincoln | Kansas | 20105 | 17 | 1 |
639077 | 639077 | 2020-10-17 | Lincoln | Kansas | 20105 | 17 | 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);