ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where deaths = 189 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487449 | 2487449 | 2022-05-09 | Butler | Kansas | 20015 | 19057 | 189 |
2484191 | 2484191 | 2022-05-08 | Butler | Kansas | 20015 | 19057 | 189 |
2480933 | 2480933 | 2022-05-07 | Butler | Kansas | 20015 | 19057 | 189 |
2477675 | 2477675 | 2022-05-06 | Butler | Kansas | 20015 | 19057 | 189 |
2474417 | 2474417 | 2022-05-05 | Butler | Kansas | 20015 | 19033 | 189 |
2471160 | 2471160 | 2022-05-04 | Butler | Kansas | 20015 | 19033 | 189 |
2467904 | 2467904 | 2022-05-03 | Butler | Kansas | 20015 | 19033 | 189 |
2464649 | 2464649 | 2022-05-02 | Butler | Kansas | 20015 | 19033 | 189 |
2461393 | 2461393 | 2022-05-01 | Butler | Kansas | 20015 | 19033 | 189 |
2458137 | 2458137 | 2022-04-30 | Butler | Kansas | 20015 | 19033 | 189 |
2454881 | 2454881 | 2022-04-29 | Butler | Kansas | 20015 | 19033 | 189 |
2451625 | 2451625 | 2022-04-28 | Butler | Kansas | 20015 | 19012 | 189 |
2448369 | 2448369 | 2022-04-27 | Butler | Kansas | 20015 | 19012 | 189 |
2080840 | 2080840 | 2022-01-04 | Reno | Kansas | 20155 | 14118 | 189 |
2077588 | 2077588 | 2022-01-03 | Reno | Kansas | 20155 | 14118 | 189 |
840306 | 840306 | 2020-12-18 | Wyandotte | Kansas | 20209 | 14105 | 189 |
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);