ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where cases = 375 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2126378 | 2126378 | 2022-01-18 | Stanton | Kansas | 20187 | 375 | 7 |
2123126 | 2123126 | 2022-01-17 | Stanton | Kansas | 20187 | 375 | 7 |
2119874 | 2119874 | 2022-01-16 | Stanton | Kansas | 20187 | 375 | 7 |
2116622 | 2116622 | 2022-01-15 | Stanton | Kansas | 20187 | 375 | 7 |
2113371 | 2113371 | 2022-01-14 | Stanton | Kansas | 20187 | 375 | 7 |
2035292 | 2035292 | 2021-12-21 | Graham | Kansas | 20065 | 375 | 12 |
2032042 | 2032042 | 2021-12-20 | Graham | Kansas | 20065 | 375 | 12 |
1996275 | 1996275 | 2021-12-09 | Elk | Kansas | 20049 | 375 | 6 |
1993024 | 1993024 | 2021-12-08 | Elk | Kansas | 20049 | 375 | 6 |
1905262 | 1905262 | 2021-11-11 | Decatur | Kansas | 20039 | 375 | 13 |
1902012 | 1902012 | 2021-11-10 | Decatur | Kansas | 20039 | 375 | 13 |
1853301 | 1853301 | 2021-10-26 | Kiowa | Kansas | 20097 | 375 | 5 |
1850052 | 1850052 | 2021-10-25 | Kiowa | Kansas | 20097 | 375 | 5 |
1807809 | 1807809 | 2021-10-12 | Jewell | Kansas | 20089 | 375 | 8 |
1804558 | 1804558 | 2021-10-11 | Jewell | Kansas | 20089 | 375 | 8 |
1785091 | 1785091 | 2021-10-05 | Osborne | Kansas | 20141 | 375 | 14 |
1781842 | 1781842 | 2021-10-04 | Osborne | Kansas | 20141 | 375 | 14 |
1557685 | 1557685 | 2021-07-27 | Ness | Kansas | 20135 | 375 | 16 |
1554438 | 1554438 | 2021-07-26 | Ness | Kansas | 20135 | 375 | 16 |
1551191 | 1551191 | 2021-07-25 | Ness | Kansas | 20135 | 375 | 16 |
1547944 | 1547944 | 2021-07-24 | Ness | Kansas | 20135 | 375 | 16 |
1544697 | 1544697 | 2021-07-23 | Ness | Kansas | 20135 | 375 | 16 |
1518653 | 1518653 | 2021-07-15 | Barber | Kansas | 20007 | 375 | 6 |
1515406 | 1515406 | 2021-07-14 | Barber | Kansas | 20007 | 375 | 6 |
1512160 | 1512160 | 2021-07-13 | Barber | Kansas | 20007 | 375 | 6 |
1508913 | 1508913 | 2021-07-12 | Barber | Kansas | 20007 | 375 | 6 |
1505667 | 1505667 | 2021-07-11 | Barber | Kansas | 20007 | 375 | 6 |
1502421 | 1502421 | 2021-07-10 | Barber | Kansas | 20007 | 375 | 6 |
1499175 | 1499175 | 2021-07-09 | Barber | Kansas | 20007 | 375 | 6 |
1041448 | 1041448 | 2021-02-18 | Gove | Kansas | 20063 | 375 | 22 |
1038203 | 1038203 | 2021-02-17 | Gove | Kansas | 20063 | 375 | 22 |
846728 | 846728 | 2020-12-20 | Greenwood | Kansas | 20073 | 375 | 2 |
843482 | 843482 | 2020-12-19 | Greenwood | Kansas | 20073 | 375 | 2 |
840237 | 840237 | 2020-12-18 | Greenwood | Kansas | 20073 | 375 | 2 |
837057 | 837057 | 2020-12-17 | Washington | Kansas | 20201 | 375 | 8 |
833811 | 833811 | 2020-12-16 | Washington | Kansas | 20201 | 375 | 8 |
778538 | 778538 | 2020-11-29 | Anderson | Kansas | 20003 | 375 | 0 |
775293 | 775293 | 2020-11-28 | Anderson | Kansas | 20003 | 375 | 0 |
772048 | 772048 | 2020-11-27 | Anderson | Kansas | 20003 | 375 | 0 |
746166 | 746166 | 2020-11-19 | Scott | Kansas | 20171 | 375 | 2 |
742919 | 742919 | 2020-11-18 | Scott | Kansas | 20171 | 375 | 2 |
690954 | 690954 | 2020-11-02 | Dickinson | Kansas | 20041 | 375 | 4 |
691030 | 691030 | 2020-11-02 | Thomas | Kansas | 20193 | 375 | 2 |
574239 | 574239 | 2020-09-27 | Miami | Kansas | 20121 | 375 | 1 |
570996 | 570996 | 2020-09-26 | Miami | Kansas | 20121 | 375 | 1 |
567754 | 567754 | 2020-09-25 | Miami | Kansas | 20121 | 375 | 1 |
383630 | 383630 | 2020-07-30 | Crawford | Kansas | 20037 | 375 | 1 |
380413 | 380413 | 2020-07-29 | Crawford | Kansas | 20037 | 375 | 1 |
164206 | 164206 | 2020-05-21 | Lyon | Kansas | 20111 | 375 | 3 |
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);