ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 8, fips = 20129 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947359 | 947359 | 2021-01-20 | Morton | Kansas | 20129 | 220 | 8 |
944112 | 944112 | 2021-01-19 | Morton | Kansas | 20129 | 220 | 8 |
940867 | 940867 | 2021-01-18 | Morton | Kansas | 20129 | 220 | 8 |
937622 | 937622 | 2021-01-17 | Morton | Kansas | 20129 | 220 | 8 |
934377 | 934377 | 2021-01-16 | Morton | Kansas | 20129 | 220 | 8 |
931132 | 931132 | 2021-01-15 | Morton | Kansas | 20129 | 220 | 8 |
927887 | 927887 | 2021-01-14 | Morton | Kansas | 20129 | 220 | 8 |
924641 | 924641 | 2021-01-13 | Morton | Kansas | 20129 | 212 | 8 |
921396 | 921396 | 2021-01-12 | Morton | Kansas | 20129 | 212 | 8 |
918151 | 918151 | 2021-01-11 | Morton | Kansas | 20129 | 212 | 8 |
914906 | 914906 | 2021-01-10 | Morton | Kansas | 20129 | 212 | 8 |
911661 | 911661 | 2021-01-09 | Morton | Kansas | 20129 | 212 | 8 |
908416 | 908416 | 2021-01-08 | Morton | Kansas | 20129 | 212 | 8 |
905170 | 905170 | 2021-01-07 | Morton | Kansas | 20129 | 212 | 8 |
901925 | 901925 | 2021-01-06 | Morton | Kansas | 20129 | 212 | 8 |
898680 | 898680 | 2021-01-05 | Morton | Kansas | 20129 | 212 | 8 |
895435 | 895435 | 2021-01-04 | Morton | Kansas | 20129 | 212 | 8 |
892188 | 892188 | 2021-01-03 | Morton | Kansas | 20129 | 201 | 8 |
888942 | 888942 | 2021-01-02 | Morton | Kansas | 20129 | 201 | 8 |
885696 | 885696 | 2021-01-01 | Morton | Kansas | 20129 | 201 | 8 |
882451 | 882451 | 2020-12-31 | Morton | Kansas | 20129 | 201 | 8 |
879206 | 879206 | 2020-12-30 | Morton | Kansas | 20129 | 201 | 8 |
875961 | 875961 | 2020-12-29 | Morton | Kansas | 20129 | 201 | 8 |
872716 | 872716 | 2020-12-28 | Morton | Kansas | 20129 | 201 | 8 |
869471 | 869471 | 2020-12-27 | Morton | Kansas | 20129 | 201 | 8 |
866226 | 866226 | 2020-12-26 | Morton | Kansas | 20129 | 201 | 8 |
862981 | 862981 | 2020-12-25 | Morton | Kansas | 20129 | 201 | 8 |
859736 | 859736 | 2020-12-24 | Morton | Kansas | 20129 | 201 | 8 |
856491 | 856491 | 2020-12-23 | Morton | Kansas | 20129 | 201 | 8 |
853246 | 853246 | 2020-12-22 | Morton | Kansas | 20129 | 201 | 8 |
850001 | 850001 | 2020-12-21 | Morton | Kansas | 20129 | 201 | 8 |
846756 | 846756 | 2020-12-20 | Morton | Kansas | 20129 | 195 | 8 |
843510 | 843510 | 2020-12-19 | Morton | Kansas | 20129 | 195 | 8 |
840265 | 840265 | 2020-12-18 | Morton | Kansas | 20129 | 195 | 8 |
837020 | 837020 | 2020-12-17 | Morton | Kansas | 20129 | 195 | 8 |
833774 | 833774 | 2020-12-16 | Morton | Kansas | 20129 | 195 | 8 |
830527 | 830527 | 2020-12-15 | Morton | Kansas | 20129 | 195 | 8 |
827281 | 827281 | 2020-12-14 | Morton | Kansas | 20129 | 195 | 8 |
824034 | 824034 | 2020-12-13 | Morton | Kansas | 20129 | 195 | 8 |
820788 | 820788 | 2020-12-12 | Morton | Kansas | 20129 | 195 | 8 |
817542 | 817542 | 2020-12-11 | Morton | Kansas | 20129 | 195 | 8 |
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);