ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
628 rows where fips = 20153 and state = "Kansas" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
464252 | 464252 | 2020-08-24 | Rawlins | Kansas | 20153 | 1 | 0 |
467481 | 467481 | 2020-08-25 | Rawlins | Kansas | 20153 | 1 | 0 |
470710 | 470710 | 2020-08-26 | Rawlins | Kansas | 20153 | 1 | 0 |
473942 | 473942 | 2020-08-27 | Rawlins | Kansas | 20153 | 1 | 0 |
477175 | 477175 | 2020-08-28 | Rawlins | Kansas | 20153 | 1 | 0 |
480408 | 480408 | 2020-08-29 | Rawlins | Kansas | 20153 | 1 | 0 |
483642 | 483642 | 2020-08-30 | Rawlins | Kansas | 20153 | 1 | 0 |
486877 | 486877 | 2020-08-31 | Rawlins | Kansas | 20153 | 1 | 0 |
490110 | 490110 | 2020-09-01 | Rawlins | Kansas | 20153 | 1 | 0 |
493343 | 493343 | 2020-09-02 | Rawlins | Kansas | 20153 | 1 | 0 |
496577 | 496577 | 2020-09-03 | Rawlins | Kansas | 20153 | 1 | 0 |
499810 | 499810 | 2020-09-04 | Rawlins | Kansas | 20153 | 2 | 0 |
503044 | 503044 | 2020-09-05 | Rawlins | Kansas | 20153 | 2 | 0 |
506278 | 506278 | 2020-09-06 | Rawlins | Kansas | 20153 | 2 | 0 |
509510 | 509510 | 2020-09-07 | Rawlins | Kansas | 20153 | 1 | 0 |
512743 | 512743 | 2020-09-08 | Rawlins | Kansas | 20153 | 1 | 0 |
515976 | 515976 | 2020-09-09 | Rawlins | Kansas | 20153 | 2 | 0 |
519211 | 519211 | 2020-09-10 | Rawlins | Kansas | 20153 | 2 | 0 |
522448 | 522448 | 2020-09-11 | Rawlins | Kansas | 20153 | 4 | 0 |
525684 | 525684 | 2020-09-12 | Rawlins | Kansas | 20153 | 4 | 0 |
528920 | 528920 | 2020-09-13 | Rawlins | Kansas | 20153 | 4 | 0 |
532157 | 532157 | 2020-09-14 | Rawlins | Kansas | 20153 | 5 | 0 |
535392 | 535392 | 2020-09-15 | Rawlins | Kansas | 20153 | 5 | 0 |
538628 | 538628 | 2020-09-16 | Rawlins | Kansas | 20153 | 9 | 0 |
541865 | 541865 | 2020-09-17 | Rawlins | Kansas | 20153 | 13 | 0 |
545101 | 545101 | 2020-09-18 | Rawlins | Kansas | 20153 | 20 | 0 |
548339 | 548339 | 2020-09-19 | Rawlins | Kansas | 20153 | 20 | 0 |
551578 | 551578 | 2020-09-20 | Rawlins | Kansas | 20153 | 24 | 0 |
554817 | 554817 | 2020-09-21 | Rawlins | Kansas | 20153 | 24 | 0 |
558054 | 558054 | 2020-09-22 | Rawlins | Kansas | 20153 | 31 | 0 |
561290 | 561290 | 2020-09-23 | Rawlins | Kansas | 20153 | 41 | 0 |
564530 | 564530 | 2020-09-24 | Rawlins | Kansas | 20153 | 49 | 0 |
567770 | 567770 | 2020-09-25 | Rawlins | Kansas | 20153 | 49 | 0 |
571012 | 571012 | 2020-09-26 | Rawlins | Kansas | 20153 | 49 | 0 |
574255 | 574255 | 2020-09-27 | Rawlins | Kansas | 20153 | 49 | 0 |
577497 | 577497 | 2020-09-28 | Rawlins | Kansas | 20153 | 61 | 0 |
580738 | 580738 | 2020-09-29 | Rawlins | Kansas | 20153 | 61 | 0 |
583977 | 583977 | 2020-09-30 | Rawlins | Kansas | 20153 | 68 | 0 |
587217 | 587217 | 2020-10-01 | Rawlins | Kansas | 20153 | 68 | 0 |
590458 | 590458 | 2020-10-02 | Rawlins | Kansas | 20153 | 77 | 0 |
593699 | 593699 | 2020-10-03 | Rawlins | Kansas | 20153 | 83 | 0 |
596941 | 596941 | 2020-10-04 | Rawlins | Kansas | 20153 | 83 | 0 |
600183 | 600183 | 2020-10-05 | Rawlins | Kansas | 20153 | 83 | 0 |
603426 | 603426 | 2020-10-06 | Rawlins | Kansas | 20153 | 88 | 0 |
606668 | 606668 | 2020-10-07 | Rawlins | Kansas | 20153 | 88 | 0 |
609911 | 609911 | 2020-10-08 | Rawlins | Kansas | 20153 | 95 | 0 |
613153 | 613153 | 2020-10-09 | Rawlins | Kansas | 20153 | 95 | 0 |
616394 | 616394 | 2020-10-10 | Rawlins | Kansas | 20153 | 95 | 0 |
619636 | 619636 | 2020-10-11 | Rawlins | Kansas | 20153 | 95 | 0 |
622880 | 622880 | 2020-10-12 | Rawlins | Kansas | 20153 | 104 | 0 |
626122 | 626122 | 2020-10-13 | Rawlins | Kansas | 20153 | 104 | 0 |
629365 | 629365 | 2020-10-14 | Rawlins | Kansas | 20153 | 106 | 0 |
632609 | 632609 | 2020-10-15 | Rawlins | Kansas | 20153 | 106 | 0 |
635855 | 635855 | 2020-10-16 | Rawlins | Kansas | 20153 | 113 | 0 |
639101 | 639101 | 2020-10-17 | Rawlins | Kansas | 20153 | 113 | 0 |
642348 | 642348 | 2020-10-18 | Rawlins | Kansas | 20153 | 113 | 0 |
645595 | 645595 | 2020-10-19 | Rawlins | Kansas | 20153 | 113 | 0 |
648840 | 648840 | 2020-10-20 | Rawlins | Kansas | 20153 | 118 | 0 |
652084 | 652084 | 2020-10-21 | Rawlins | Kansas | 20153 | 123 | 0 |
655329 | 655329 | 2020-10-22 | Rawlins | Kansas | 20153 | 123 | 0 |
658574 | 658574 | 2020-10-23 | Rawlins | Kansas | 20153 | 139 | 0 |
661818 | 661818 | 2020-10-24 | Rawlins | Kansas | 20153 | 139 | 0 |
665063 | 665063 | 2020-10-25 | Rawlins | Kansas | 20153 | 139 | 0 |
668307 | 668307 | 2020-10-26 | Rawlins | Kansas | 20153 | 144 | 0 |
671550 | 671550 | 2020-10-27 | Rawlins | Kansas | 20153 | 144 | 0 |
674792 | 674792 | 2020-10-28 | Rawlins | Kansas | 20153 | 144 | 0 |
678035 | 678035 | 2020-10-29 | Rawlins | Kansas | 20153 | 144 | 0 |
681278 | 681278 | 2020-10-30 | Rawlins | Kansas | 20153 | 154 | 0 |
684521 | 684521 | 2020-10-31 | Rawlins | Kansas | 20153 | 154 | 0 |
687765 | 687765 | 2020-11-01 | Rawlins | Kansas | 20153 | 154 | 0 |
691010 | 691010 | 2020-11-02 | Rawlins | Kansas | 20153 | 154 | 0 |
694253 | 694253 | 2020-11-03 | Rawlins | Kansas | 20153 | 156 | 0 |
697495 | 697495 | 2020-11-04 | Rawlins | Kansas | 20153 | 156 | 0 |
700739 | 700739 | 2020-11-05 | Rawlins | Kansas | 20153 | 156 | 0 |
703981 | 703981 | 2020-11-06 | Rawlins | Kansas | 20153 | 173 | 1 |
707224 | 707224 | 2020-11-07 | Rawlins | Kansas | 20153 | 173 | 1 |
710468 | 710468 | 2020-11-08 | Rawlins | Kansas | 20153 | 173 | 1 |
713712 | 713712 | 2020-11-09 | Rawlins | Kansas | 20153 | 173 | 1 |
716956 | 716956 | 2020-11-10 | Rawlins | Kansas | 20153 | 173 | 1 |
720199 | 720199 | 2020-11-11 | Rawlins | Kansas | 20153 | 173 | 1 |
723442 | 723442 | 2020-11-12 | Rawlins | Kansas | 20153 | 173 | 1 |
726685 | 726685 | 2020-11-13 | Rawlins | Kansas | 20153 | 173 | 1 |
729928 | 729928 | 2020-11-14 | Rawlins | Kansas | 20153 | 199 | 2 |
733173 | 733173 | 2020-11-15 | Rawlins | Kansas | 20153 | 199 | 2 |
736419 | 736419 | 2020-11-16 | Rawlins | Kansas | 20153 | 199 | 2 |
739663 | 739663 | 2020-11-17 | Rawlins | Kansas | 20153 | 244 | 2 |
742910 | 742910 | 2020-11-18 | Rawlins | Kansas | 20153 | 244 | 2 |
746157 | 746157 | 2020-11-19 | Rawlins | Kansas | 20153 | 244 | 2 |
749403 | 749403 | 2020-11-20 | Rawlins | Kansas | 20153 | 214 | 2 |
752649 | 752649 | 2020-11-21 | Rawlins | Kansas | 20153 | 214 | 2 |
755895 | 755895 | 2020-11-22 | Rawlins | Kansas | 20153 | 214 | 2 |
759142 | 759142 | 2020-11-23 | Rawlins | Kansas | 20153 | 214 | 3 |
762387 | 762387 | 2020-11-24 | Rawlins | Kansas | 20153 | 227 | 3 |
765632 | 765632 | 2020-11-25 | Rawlins | Kansas | 20153 | 227 | 3 |
768878 | 768878 | 2020-11-26 | Rawlins | Kansas | 20153 | 227 | 3 |
772123 | 772123 | 2020-11-27 | Rawlins | Kansas | 20153 | 227 | 3 |
775368 | 775368 | 2020-11-28 | Rawlins | Kansas | 20153 | 227 | 3 |
778613 | 778613 | 2020-11-29 | Rawlins | Kansas | 20153 | 227 | 3 |
781859 | 781859 | 2020-11-30 | Rawlins | Kansas | 20153 | 239 | 3 |
785104 | 785104 | 2020-12-01 | Rawlins | Kansas | 20153 | 239 | 3 |
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);