ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 410 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2103556 | 2103556 | 2022-01-11 | Graham | Kansas | 20065 | 410 | 13 |
2100305 | 2100305 | 2022-01-10 | Graham | Kansas | 20065 | 410 | 13 |
1983301 | 1983301 | 2021-12-05 | Lincoln | Kansas | 20105 | 410 | 7 |
1980051 | 1980051 | 2021-12-04 | Lincoln | Kansas | 20105 | 410 | 7 |
1976801 | 1976801 | 2021-12-03 | Lincoln | Kansas | 20105 | 410 | 7 |
1967008 | 1967008 | 2021-11-30 | Chase | Kansas | 20017 | 410 | 4 |
1963756 | 1963756 | 2021-11-29 | Chase | Kansas | 20017 | 410 | 4 |
1921539 | 1921539 | 2021-11-16 | Kiowa | Kansas | 20097 | 410 | 5 |
1918289 | 1918289 | 2021-11-15 | Kiowa | Kansas | 20097 | 410 | 5 |
1898807 | 1898807 | 2021-11-09 | Morton | Kansas | 20129 | 410 | 9 |
1895557 | 1895557 | 2021-11-08 | Morton | Kansas | 20129 | 410 | 9 |
1837059 | 1837059 | 2021-10-21 | Logan | Kansas | 20109 | 410 | 8 |
1833810 | 1833810 | 2021-10-20 | Logan | Kansas | 20109 | 410 | 8 |
1830583 | 1830583 | 2021-10-19 | Rawlins | Kansas | 20153 | 410 | 7 |
1827334 | 1827334 | 2021-10-18 | Rawlins | Kansas | 20153 | 410 | 7 |
1109620 | 1109620 | 2021-03-11 | Haskell | Kansas | 20081 | 410 | 1 |
1106374 | 1106374 | 2021-03-10 | Haskell | Kansas | 20081 | 410 | 1 |
824051 | 824051 | 2020-12-13 | Rooks | Kansas | 20163 | 410 | 8 |
820805 | 820805 | 2020-12-12 | Rooks | Kansas | 20163 | 410 | 8 |
817559 | 817559 | 2020-12-11 | Rooks | Kansas | 20163 | 410 | 8 |
768875 | 768875 | 2020-11-26 | Phillips | Kansas | 20147 | 410 | 10 |
765629 | 765629 | 2020-11-25 | Phillips | Kansas | 20147 | 410 | 10 |
755832 | 755832 | 2020-11-22 | Clay | Kansas | 20027 | 410 | 9 |
755875 | 755875 | 2020-11-22 | Marion | Kansas | 20115 | 410 | 1 |
752586 | 752586 | 2020-11-21 | Clay | Kansas | 20027 | 410 | 9 |
752629 | 752629 | 2020-11-21 | Marion | Kansas | 20115 | 410 | 1 |
749340 | 749340 | 2020-11-20 | Clay | Kansas | 20027 | 410 | 9 |
749383 | 749383 | 2020-11-20 | Marion | Kansas | 20115 | 410 | 1 |
694273 | 694273 | 2020-11-03 | Thomas | Kansas | 20193 | 410 | 2 |
648797 | 648797 | 2020-10-20 | Grant | Kansas | 20067 | 410 | 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);