ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 468 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 11
state 1
- Kansas · 25 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2149074 | 2149074 | 2022-01-25 | Clark | Kansas | 20025 | 468 | 7 |
2145822 | 2145822 | 2022-01-24 | Clark | Kansas | 20025 | 468 | 7 |
2074268 | 2074268 | 2022-01-02 | Chase | Kansas | 20017 | 468 | 6 |
2071017 | 2071017 | 2022-01-01 | Chase | Kansas | 20017 | 468 | 6 |
2067766 | 2067766 | 2021-12-31 | Chase | Kansas | 20017 | 468 | 6 |
2064515 | 2064515 | 2021-12-30 | Chase | Kansas | 20017 | 468 | 6 |
2061265 | 2061265 | 2021-12-29 | Chase | Kansas | 20017 | 468 | 6 |
2019070 | 2019070 | 2021-12-16 | Morton | Kansas | 20129 | 468 | 10 |
2015820 | 2015820 | 2021-12-15 | Morton | Kansas | 20129 | 468 | 10 |
1989768 | 1989768 | 2021-12-07 | Decatur | Kansas | 20039 | 468 | 14 |
1986518 | 1986518 | 2021-12-06 | Decatur | Kansas | 20039 | 468 | 14 |
1778619 | 1778619 | 2021-10-03 | Trego | Kansas | 20195 | 468 | 8 |
1775369 | 1775369 | 2021-10-02 | Trego | Kansas | 20195 | 468 | 8 |
1772119 | 1772119 | 2021-10-01 | Trego | Kansas | 20195 | 468 | 8 |
905144 | 905144 | 2021-01-07 | Harper | Kansas | 20077 | 468 | 15 |
901899 | 901899 | 2021-01-06 | Harper | Kansas | 20077 | 468 | 15 |
791573 | 791573 | 2020-12-03 | Marion | Kansas | 20115 | 468 | 1 |
791602 | 791602 | 2020-12-03 | Scott | Kansas | 20171 | 468 | 5 |
788328 | 788328 | 2020-12-02 | Marion | Kansas | 20115 | 468 | 1 |
788357 | 788357 | 2020-12-02 | Scott | Kansas | 20171 | 468 | 5 |
785107 | 785107 | 2020-12-01 | Rice | Kansas | 20159 | 468 | 1 |
781862 | 781862 | 2020-11-30 | Rice | Kansas | 20159 | 468 | 1 |
716952 | 716952 | 2020-11-10 | Pawnee | Kansas | 20145 | 468 | 1 |
713708 | 713708 | 2020-11-09 | Pawnee | Kansas | 20145 | 468 | 1 |
131163 | 131163 | 2020-05-10 | Sedgwick | Kansas | 20173 | 468 | 19 |
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);