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 |
---|---|---|---|---|---|---|---|
1054481 | 1054481 | 2021-02-22 | Riley | Kansas | 20161 | 6158 | 33 |
1051234 | 1051234 | 2021-02-21 | Riley | Kansas | 20161 | 6158 | 33 |
1047987 | 1047987 | 2021-02-20 | Riley | Kansas | 20161 | 6158 | 33 |
1044742 | 1044742 | 2021-02-19 | Riley | Kansas | 20161 | 6158 | 33 |
1041497 | 1041497 | 2021-02-18 | Riley | Kansas | 20161 | 6148 | 32 |
1038252 | 1038252 | 2021-02-17 | Riley | Kansas | 20161 | 6148 | 32 |
1035007 | 1035007 | 2021-02-16 | Riley | Kansas | 20161 | 6115 | 32 |
1031761 | 1031761 | 2021-02-15 | Riley | Kansas | 20161 | 6115 | 32 |
1028514 | 1028514 | 2021-02-14 | Riley | Kansas | 20161 | 6115 | 32 |
1025269 | 1025269 | 2021-02-13 | Riley | Kansas | 20161 | 6115 | 32 |
1022024 | 1022024 | 2021-02-12 | Riley | Kansas | 20161 | 6115 | 32 |
1018779 | 1018779 | 2021-02-11 | Riley | Kansas | 20161 | 6080 | 32 |
1015534 | 1015534 | 2021-02-10 | Riley | Kansas | 20161 | 6080 | 32 |
1012289 | 1012289 | 2021-02-09 | Riley | Kansas | 20161 | 6063 | 31 |
1009043 | 1009043 | 2021-02-08 | Riley | Kansas | 20161 | 6063 | 31 |
1005797 | 1005797 | 2021-02-07 | Riley | Kansas | 20161 | 6025 | 31 |
1002551 | 1002551 | 2021-02-06 | Riley | Kansas | 20161 | 6025 | 31 |
999305 | 999305 | 2021-02-05 | Riley | Kansas | 20161 | 6025 | 31 |
996059 | 996059 | 2021-02-04 | Riley | Kansas | 20161 | 6025 | 31 |
992813 | 992813 | 2021-02-03 | Riley | Kansas | 20161 | 6025 | 31 |
989567 | 989567 | 2021-02-02 | Riley | Kansas | 20161 | 6002 | 31 |
986320 | 986320 | 2021-02-01 | Riley | Kansas | 20161 | 6002 | 31 |
983073 | 983073 | 2021-01-31 | Riley | Kansas | 20161 | 5934 | 30 |
979827 | 979827 | 2021-01-30 | Riley | Kansas | 20161 | 5934 | 30 |
976581 | 976581 | 2021-01-29 | Riley | Kansas | 20161 | 5934 | 30 |
973336 | 973336 | 2021-01-28 | Riley | Kansas | 20161 | 5886 | 30 |
970091 | 970091 | 2021-01-27 | Riley | Kansas | 20161 | 5886 | 30 |
966847 | 966847 | 2021-01-26 | Riley | Kansas | 20161 | 5827 | 30 |
963602 | 963602 | 2021-01-25 | Riley | Kansas | 20161 | 5827 | 30 |
960357 | 960357 | 2021-01-24 | Riley | Kansas | 20161 | 5799 | 28 |
957111 | 957111 | 2021-01-23 | Riley | Kansas | 20161 | 5799 | 28 |
953866 | 953866 | 2021-01-22 | Riley | Kansas | 20161 | 5799 | 28 |
950621 | 950621 | 2021-01-21 | Riley | Kansas | 20161 | 5724 | 28 |
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 |
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);