ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Riley" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947375 | 947375 | 2021-01-20 | Riley | Kansas | 20161 | 5724 | 28 |
944128 | 944128 | 2021-01-19 | Riley | Kansas | 20161 | 5597 | 23 |
940883 | 940883 | 2021-01-18 | Riley | Kansas | 20161 | 5597 | 23 |
937638 | 937638 | 2021-01-17 | Riley | Kansas | 20161 | 5597 | 23 |
934393 | 934393 | 2021-01-16 | Riley | Kansas | 20161 | 5597 | 23 |
931148 | 931148 | 2021-01-15 | Riley | Kansas | 20161 | 5597 | 23 |
927903 | 927903 | 2021-01-14 | Riley | Kansas | 20161 | 5467 | 22 |
924657 | 924657 | 2021-01-13 | Riley | Kansas | 20161 | 5467 | 22 |
921412 | 921412 | 2021-01-12 | Riley | Kansas | 20161 | 5384 | 22 |
918167 | 918167 | 2021-01-11 | Riley | Kansas | 20161 | 5384 | 22 |
914922 | 914922 | 2021-01-10 | Riley | Kansas | 20161 | 5278 | 22 |
911677 | 911677 | 2021-01-09 | Riley | Kansas | 20161 | 5278 | 22 |
908432 | 908432 | 2021-01-08 | Riley | Kansas | 20161 | 5278 | 22 |
905186 | 905186 | 2021-01-07 | Riley | Kansas | 20161 | 5173 | 22 |
901941 | 901941 | 2021-01-06 | Riley | Kansas | 20161 | 5173 | 22 |
898696 | 898696 | 2021-01-05 | Riley | Kansas | 20161 | 5033 | 22 |
895451 | 895451 | 2021-01-04 | Riley | Kansas | 20161 | 5033 | 22 |
892204 | 892204 | 2021-01-03 | Riley | Kansas | 20161 | 4917 | 20 |
888958 | 888958 | 2021-01-02 | Riley | Kansas | 20161 | 4917 | 20 |
885712 | 885712 | 2021-01-01 | Riley | Kansas | 20161 | 4917 | 20 |
882467 | 882467 | 2020-12-31 | Riley | Kansas | 20161 | 4917 | 20 |
879222 | 879222 | 2020-12-30 | Riley | Kansas | 20161 | 4917 | 20 |
875977 | 875977 | 2020-12-29 | Riley | Kansas | 20161 | 4718 | 20 |
872732 | 872732 | 2020-12-28 | Riley | Kansas | 20161 | 4718 | 20 |
869487 | 869487 | 2020-12-27 | Riley | Kansas | 20161 | 4673 | 20 |
866242 | 866242 | 2020-12-26 | Riley | Kansas | 20161 | 4673 | 20 |
862997 | 862997 | 2020-12-25 | Riley | Kansas | 20161 | 4673 | 20 |
859752 | 859752 | 2020-12-24 | Riley | Kansas | 20161 | 4673 | 20 |
856507 | 856507 | 2020-12-23 | Riley | Kansas | 20161 | 4673 | 20 |
853262 | 853262 | 2020-12-22 | Riley | Kansas | 20161 | 4565 | 19 |
850017 | 850017 | 2020-12-21 | Riley | Kansas | 20161 | 4565 | 19 |
846772 | 846772 | 2020-12-20 | Riley | Kansas | 20161 | 4494 | 19 |
843526 | 843526 | 2020-12-19 | Riley | Kansas | 20161 | 4494 | 19 |
840281 | 840281 | 2020-12-18 | Riley | Kansas | 20161 | 4494 | 19 |
837036 | 837036 | 2020-12-17 | Riley | Kansas | 20161 | 4396 | 19 |
833790 | 833790 | 2020-12-16 | Riley | Kansas | 20161 | 4396 | 19 |
830543 | 830543 | 2020-12-15 | Riley | Kansas | 20161 | 4270 | 16 |
827297 | 827297 | 2020-12-14 | Riley | Kansas | 20161 | 4270 | 16 |
824050 | 824050 | 2020-12-13 | Riley | Kansas | 20161 | 4176 | 16 |
820804 | 820804 | 2020-12-12 | Riley | Kansas | 20161 | 4176 | 16 |
817558 | 817558 | 2020-12-11 | Riley | Kansas | 20161 | 4176 | 16 |
814312 | 814312 | 2020-12-10 | Riley | Kansas | 20161 | 4176 | 16 |
811067 | 811067 | 2020-12-09 | Riley | Kansas | 20161 | 4176 | 16 |
807822 | 807822 | 2020-12-08 | Riley | Kansas | 20161 | 4023 | 16 |
804577 | 804577 | 2020-12-07 | Riley | Kansas | 20161 | 4023 | 16 |
801332 | 801332 | 2020-12-06 | Riley | Kansas | 20161 | 3905 | 16 |
798087 | 798087 | 2020-12-05 | Riley | Kansas | 20161 | 3905 | 16 |
794842 | 794842 | 2020-12-04 | Riley | Kansas | 20161 | 3905 | 16 |
791597 | 791597 | 2020-12-03 | Riley | Kansas | 20161 | 3780 | 16 |
788352 | 788352 | 2020-12-02 | Riley | Kansas | 20161 | 3780 | 16 |
785108 | 785108 | 2020-12-01 | Riley | Kansas | 20161 | 3709 | 15 |
781863 | 781863 | 2020-11-30 | Riley | Kansas | 20161 | 3709 | 15 |
778617 | 778617 | 2020-11-29 | Riley | Kansas | 20161 | 3428 | 14 |
775372 | 775372 | 2020-11-28 | Riley | Kansas | 20161 | 3428 | 14 |
772127 | 772127 | 2020-11-27 | Riley | Kansas | 20161 | 3428 | 14 |
768882 | 768882 | 2020-11-26 | Riley | Kansas | 20161 | 3428 | 14 |
765636 | 765636 | 2020-11-25 | Riley | Kansas | 20161 | 3428 | 14 |
762391 | 762391 | 2020-11-24 | Riley | Kansas | 20161 | 3428 | 14 |
759146 | 759146 | 2020-11-23 | Riley | Kansas | 20161 | 3428 | 14 |
755899 | 755899 | 2020-11-22 | Riley | Kansas | 20161 | 3157 | 14 |
752653 | 752653 | 2020-11-21 | Riley | Kansas | 20161 | 3157 | 14 |
749407 | 749407 | 2020-11-20 | Riley | Kansas | 20161 | 3157 | 14 |
746161 | 746161 | 2020-11-19 | Riley | Kansas | 20161 | 3043 | 14 |
742914 | 742914 | 2020-11-18 | Riley | Kansas | 20161 | 2987 | 14 |
739667 | 739667 | 2020-11-17 | Riley | Kansas | 20161 | 2987 | 14 |
736423 | 736423 | 2020-11-16 | Riley | Kansas | 20161 | 2987 | 14 |
733177 | 733177 | 2020-11-15 | Riley | Kansas | 20161 | 2807 | 14 |
729932 | 729932 | 2020-11-14 | Riley | Kansas | 20161 | 2807 | 14 |
726689 | 726689 | 2020-11-13 | Riley | Kansas | 20161 | 2807 | 14 |
723446 | 723446 | 2020-11-12 | Riley | Kansas | 20161 | 2637 | 13 |
720203 | 720203 | 2020-11-11 | Riley | Kansas | 20161 | 2637 | 13 |
716960 | 716960 | 2020-11-10 | Riley | Kansas | 20161 | 2523 | 12 |
713716 | 713716 | 2020-11-09 | Riley | Kansas | 20161 | 2523 | 12 |
710472 | 710472 | 2020-11-08 | Riley | Kansas | 20161 | 2397 | 12 |
707228 | 707228 | 2020-11-07 | Riley | Kansas | 20161 | 2397 | 12 |
703985 | 703985 | 2020-11-06 | Riley | Kansas | 20161 | 2397 | 12 |
700743 | 700743 | 2020-11-05 | Riley | Kansas | 20161 | 2311 | 12 |
697499 | 697499 | 2020-11-04 | Riley | Kansas | 20161 | 2311 | 12 |
694257 | 694257 | 2020-11-03 | Riley | Kansas | 20161 | 2251 | 12 |
691014 | 691014 | 2020-11-02 | Riley | Kansas | 20161 | 2251 | 12 |
687769 | 687769 | 2020-11-01 | Riley | Kansas | 20161 | 2177 | 11 |
684525 | 684525 | 2020-10-31 | Riley | Kansas | 20161 | 2177 | 11 |
681282 | 681282 | 2020-10-30 | Riley | Kansas | 20161 | 2177 | 11 |
678039 | 678039 | 2020-10-29 | Riley | Kansas | 20161 | 2177 | 11 |
674796 | 674796 | 2020-10-28 | Riley | Kansas | 20161 | 2084 | 11 |
671554 | 671554 | 2020-10-27 | Riley | Kansas | 20161 | 2084 | 11 |
668311 | 668311 | 2020-10-26 | Riley | Kansas | 20161 | 2084 | 11 |
665067 | 665067 | 2020-10-25 | Riley | Kansas | 20161 | 2084 | 11 |
661822 | 661822 | 2020-10-24 | Riley | Kansas | 20161 | 2084 | 11 |
658578 | 658578 | 2020-10-23 | Riley | Kansas | 20161 | 2084 | 11 |
655333 | 655333 | 2020-10-22 | Riley | Kansas | 20161 | 2084 | 11 |
652088 | 652088 | 2020-10-21 | Riley | Kansas | 20161 | 2084 | 11 |
648844 | 648844 | 2020-10-20 | Riley | Kansas | 20161 | 2045 | 11 |
645599 | 645599 | 2020-10-19 | Riley | Kansas | 20161 | 2045 | 11 |
642352 | 642352 | 2020-10-18 | Riley | Kansas | 20161 | 2035 | 11 |
639105 | 639105 | 2020-10-17 | Riley | Kansas | 20161 | 2035 | 11 |
635859 | 635859 | 2020-10-16 | Riley | Kansas | 20161 | 2035 | 11 |
632613 | 632613 | 2020-10-15 | Riley | Kansas | 20161 | 2004 | 10 |
629369 | 629369 | 2020-10-14 | Riley | Kansas | 20161 | 2003 | 9 |
626126 | 626126 | 2020-10-13 | Riley | Kansas | 20161 | 1968 | 9 |
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);