ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 173 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1928025 | 1928025 | 2021-11-18 | Greeley | Kansas | 20071 | 173 | 3 |
1924775 | 1924775 | 2021-11-17 | Greeley | Kansas | 20071 | 173 | 3 |
1921526 | 1921526 | 2021-11-16 | Greeley | Kansas | 20071 | 173 | 3 |
1918276 | 1918276 | 2021-11-15 | Greeley | Kansas | 20071 | 173 | 3 |
1892293 | 1892293 | 2021-11-07 | Lane | Kansas | 20101 | 173 | 8 |
1889043 | 1889043 | 2021-11-06 | Lane | Kansas | 20101 | 173 | 8 |
1885793 | 1885793 | 2021-11-05 | Lane | Kansas | 20101 | 173 | 8 |
1882544 | 1882544 | 2021-11-04 | Lane | Kansas | 20101 | 173 | 8 |
1879295 | 1879295 | 2021-11-03 | Lane | Kansas | 20101 | 173 | 8 |
966808 | 966808 | 2021-01-26 | Hodgeman | Kansas | 20083 | 173 | 4 |
963563 | 963563 | 2021-01-25 | Hodgeman | Kansas | 20083 | 173 | 4 |
830500 | 830500 | 2020-12-15 | Hamilton | Kansas | 20075 | 173 | 0 |
827254 | 827254 | 2020-12-14 | Hamilton | Kansas | 20075 | 173 | 0 |
762372 | 762372 | 2020-11-24 | Mitchell | Kansas | 20123 | 173 | 0 |
759127 | 759127 | 2020-11-23 | Mitchell | Kansas | 20123 | 173 | 0 |
726685 | 726685 | 2020-11-13 | Rawlins | Kansas | 20153 | 173 | 1 |
723442 | 723442 | 2020-11-12 | Rawlins | Kansas | 20153 | 173 | 1 |
720199 | 720199 | 2020-11-11 | Rawlins | Kansas | 20153 | 173 | 1 |
716956 | 716956 | 2020-11-10 | Rawlins | Kansas | 20153 | 173 | 1 |
716983 | 716983 | 2020-11-10 | Wilson | Kansas | 20205 | 173 | 4 |
713712 | 713712 | 2020-11-09 | Rawlins | Kansas | 20153 | 173 | 1 |
713739 | 713739 | 2020-11-09 | Wilson | Kansas | 20205 | 173 | 4 |
710468 | 710468 | 2020-11-08 | Rawlins | Kansas | 20153 | 173 | 1 |
707224 | 707224 | 2020-11-07 | Rawlins | Kansas | 20153 | 173 | 1 |
703981 | 703981 | 2020-11-06 | Rawlins | Kansas | 20153 | 173 | 1 |
700744 | 700744 | 2020-11-05 | Rooks | Kansas | 20163 | 173 | 7 |
697500 | 697500 | 2020-11-04 | Rooks | Kansas | 20163 | 173 | 7 |
665070 | 665070 | 2020-10-25 | Russell | Kansas | 20167 | 173 | 4 |
661825 | 661825 | 2020-10-24 | Russell | Kansas | 20167 | 173 | 4 |
658581 | 658581 | 2020-10-23 | Russell | Kansas | 20167 | 173 | 4 |
642293 | 642293 | 2020-10-18 | Doniphan | Kansas | 20043 | 173 | 0 |
639046 | 639046 | 2020-10-17 | Doniphan | Kansas | 20043 | 173 | 0 |
635800 | 635800 | 2020-10-16 | Doniphan | Kansas | 20043 | 173 | 0 |
603444 | 603444 | 2020-10-06 | Stevens | Kansas | 20189 | 173 | 1 |
600201 | 600201 | 2020-10-05 | Stevens | Kansas | 20189 | 173 | 1 |
577487 | 577487 | 2020-09-28 | Neosho | Kansas | 20133 | 173 | 0 |
574245 | 574245 | 2020-09-27 | Neosho | Kansas | 20133 | 173 | 0 |
448078 | 448078 | 2020-08-19 | Jackson | Kansas | 20085 | 173 | 1 |
419027 | 419027 | 2020-08-10 | Cowley | Kansas | 20035 | 173 | 2 |
370781 | 370781 | 2020-07-26 | Geary | Kansas | 20061 | 173 | 1 |
367571 | 367571 | 2020-07-25 | Geary | Kansas | 20061 | 173 | 1 |
364364 | 364364 | 2020-07-24 | Geary | Kansas | 20061 | 173 | 1 |
310161 | 310161 | 2020-07-07 | Saline | Kansas | 20169 | 173 | 2 |
306993 | 306993 | 2020-07-06 | Saline | Kansas | 20169 | 173 | 2 |
137146 | 137146 | 2020-05-12 | Shawnee | Kansas | 20177 | 173 | 5 |
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);