ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 1302 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
state 1
- Kansas · 17 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2194686 | 2194686 | 2022-02-08 | Republic | Kansas | 20157 | 1302 | 14 |
2191432 | 2191432 | 2022-02-07 | Republic | Kansas | 20157 | 1302 | 14 |
2171912 | 2171912 | 2022-02-01 | Phillips | Kansas | 20147 | 1302 | 28 |
2168659 | 2168659 | 2022-01-31 | Phillips | Kansas | 20147 | 1302 | 28 |
1905318 | 1905318 | 2021-11-11 | Pratt | Kansas | 20151 | 1302 | 27 |
1902068 | 1902068 | 2021-11-10 | Pratt | Kansas | 20151 | 1302 | 27 |
1837019 | 1837019 | 2021-10-21 | Cloud | Kansas | 20029 | 1302 | 27 |
1833770 | 1833770 | 2021-10-20 | Cloud | Kansas | 20029 | 1302 | 27 |
1778618 | 1778618 | 2021-10-03 | Thomas | Kansas | 20193 | 1302 | 21 |
1775368 | 1775368 | 2021-10-02 | Thomas | Kansas | 20193 | 1302 | 21 |
1772118 | 1772118 | 2021-10-01 | Thomas | Kansas | 20193 | 1302 | 21 |
1671367 | 1671367 | 2021-08-31 | Marshall | Kansas | 20117 | 1302 | 28 |
1668120 | 1668120 | 2021-08-30 | Marshall | Kansas | 20117 | 1302 | 28 |
1132311 | 1132311 | 2021-03-18 | Bourbon | Kansas | 20011 | 1302 | 3 |
1129063 | 1129063 | 2021-03-17 | Bourbon | Kansas | 20011 | 1302 | 3 |
648789 | 648789 | 2020-10-20 | Ellis | Kansas | 20051 | 1302 | 16 |
645544 | 645544 | 2020-10-19 | Ellis | Kansas | 20051 | 1302 | 16 |
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);