ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where cases = 975 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Kansas · 24 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1882530 | 1882530 | 2021-11-04 | Greenwood | Kansas | 20073 | 975 | 14 |
1879281 | 1879281 | 2021-11-03 | Greenwood | Kansas | 20073 | 975 | 14 |
1677819 | 1677819 | 2021-09-02 | Clay | Kansas | 20027 | 975 | 31 |
1674572 | 1674572 | 2021-09-01 | Clay | Kansas | 20027 | 975 | 31 |
1278472 | 1278472 | 2021-05-02 | Grant | Kansas | 20067 | 975 | 18 |
1275225 | 1275225 | 2021-05-01 | Grant | Kansas | 20067 | 975 | 18 |
1271978 | 1271978 | 2021-04-30 | Grant | Kansas | 20067 | 975 | 18 |
1268731 | 1268731 | 2021-04-29 | Grant | Kansas | 20067 | 975 | 18 |
1265484 | 1265484 | 2021-04-28 | Grant | Kansas | 20067 | 975 | 18 |
1262237 | 1262237 | 2021-04-27 | Grant | Kansas | 20067 | 975 | 18 |
1258990 | 1258990 | 2021-04-26 | Grant | Kansas | 20067 | 975 | 18 |
1255743 | 1255743 | 2021-04-25 | Grant | Kansas | 20067 | 975 | 18 |
1252496 | 1252496 | 2021-04-24 | Grant | Kansas | 20067 | 975 | 18 |
1249249 | 1249249 | 2021-04-23 | Grant | Kansas | 20067 | 975 | 18 |
1246002 | 1246002 | 2021-04-22 | Grant | Kansas | 20067 | 975 | 18 |
1242755 | 1242755 | 2021-04-21 | Grant | Kansas | 20067 | 975 | 18 |
1239508 | 1239508 | 2021-04-20 | Grant | Kansas | 20067 | 975 | 18 |
1236261 | 1236261 | 2021-04-19 | Grant | Kansas | 20067 | 975 | 18 |
1216755 | 1216755 | 2021-04-13 | Cloud | Kansas | 20029 | 975 | 2 |
1213508 | 1213508 | 2021-04-12 | Cloud | Kansas | 20029 | 975 | 2 |
973335 | 973335 | 2021-01-28 | Rice | Kansas | 20159 | 975 | 1 |
970090 | 970090 | 2021-01-27 | Rice | Kansas | 20159 | 975 | 1 |
557996 | 557996 | 2020-09-22 | Crawford | Kansas | 20037 | 975 | 6 |
554759 | 554759 | 2020-09-21 | Crawford | Kansas | 20037 | 975 | 6 |
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);