ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where cases = 225 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2006038 | 2006038 | 2021-12-12 | Greeley | Kansas | 20071 | 225 | 3 |
2002787 | 2002787 | 2021-12-11 | Greeley | Kansas | 20071 | 225 | 3 |
1999537 | 1999537 | 2021-12-10 | Greeley | Kansas | 20071 | 225 | 3 |
1807864 | 1807864 | 2021-10-12 | Wallace | Kansas | 20199 | 225 | 4 |
1804613 | 1804613 | 2021-10-11 | Wallace | Kansas | 20199 | 225 | 4 |
1746073 | 1746073 | 2021-09-23 | Hodgeman | Kansas | 20083 | 225 | 10 |
1742824 | 1742824 | 2021-09-22 | Hodgeman | Kansas | 20083 | 225 | 10 |
1671354 | 1671354 | 2021-08-31 | Jewell | Kansas | 20089 | 225 | 6 |
1668107 | 1668107 | 2021-08-30 | Jewell | Kansas | 20089 | 225 | 6 |
1648669 | 1648669 | 2021-08-24 | Stanton | Kansas | 20187 | 225 | 6 |
1645421 | 1645421 | 2021-08-23 | Stanton | Kansas | 20187 | 225 | 6 |
1505767 | 1505767 | 2021-07-11 | Woodson | Kansas | 20207 | 225 | 5 |
1502521 | 1502521 | 2021-07-10 | Woodson | Kansas | 20207 | 225 | 5 |
1499275 | 1499275 | 2021-07-09 | Woodson | Kansas | 20207 | 225 | 5 |
1496028 | 1496028 | 2021-07-08 | Woodson | Kansas | 20207 | 225 | 5 |
1492782 | 1492782 | 2021-07-07 | Woodson | Kansas | 20207 | 225 | 5 |
1489535 | 1489535 | 2021-07-06 | Woodson | Kansas | 20207 | 225 | 5 |
1486288 | 1486288 | 2021-07-05 | Woodson | Kansas | 20207 | 225 | 5 |
1483042 | 1483042 | 2021-07-04 | Woodson | Kansas | 20207 | 225 | 5 |
1479795 | 1479795 | 2021-07-03 | Woodson | Kansas | 20207 | 225 | 5 |
1476549 | 1476549 | 2021-07-02 | Woodson | Kansas | 20207 | 225 | 5 |
1473303 | 1473303 | 2021-07-01 | Woodson | Kansas | 20207 | 225 | 5 |
1470057 | 1470057 | 2021-06-30 | Woodson | Kansas | 20207 | 225 | 5 |
1466812 | 1466812 | 2021-06-29 | Woodson | Kansas | 20207 | 225 | 5 |
1463567 | 1463567 | 2021-06-28 | Woodson | Kansas | 20207 | 225 | 5 |
1460322 | 1460322 | 2021-06-27 | Woodson | Kansas | 20207 | 225 | 5 |
1457077 | 1457077 | 2021-06-26 | Woodson | Kansas | 20207 | 225 | 5 |
1453832 | 1453832 | 2021-06-25 | Woodson | Kansas | 20207 | 225 | 5 |
1450586 | 1450586 | 2021-06-24 | Woodson | Kansas | 20207 | 225 | 5 |
1447341 | 1447341 | 2021-06-23 | Woodson | Kansas | 20207 | 225 | 5 |
966831 | 966831 | 2021-01-26 | Morton | Kansas | 20129 | 225 | 9 |
963586 | 963586 | 2021-01-25 | Morton | Kansas | 20129 | 225 | 9 |
960286 | 960286 | 2021-01-24 | Chautauqua | Kansas | 20019 | 225 | 3 |
957040 | 957040 | 2021-01-23 | Chautauqua | Kansas | 20019 | 225 | 3 |
953795 | 953795 | 2021-01-22 | Chautauqua | Kansas | 20019 | 225 | 3 |
905158 | 905158 | 2021-01-07 | Lincoln | Kansas | 20105 | 225 | 2 |
801344 | 801344 | 2020-12-06 | Stafford | Kansas | 20185 | 225 | 3 |
798099 | 798099 | 2020-12-05 | Stafford | Kansas | 20185 | 225 | 3 |
794854 | 794854 | 2020-12-04 | Stafford | Kansas | 20185 | 225 | 3 |
785125 | 785125 | 2020-12-01 | Trego | Kansas | 20195 | 225 | 3 |
781880 | 781880 | 2020-11-30 | Trego | Kansas | 20195 | 225 | 3 |
768873 | 768873 | 2020-11-26 | Ottawa | Kansas | 20143 | 225 | 0 |
765627 | 765627 | 2020-11-25 | Ottawa | Kansas | 20143 | 225 | 0 |
733135 | 733135 | 2020-11-15 | Harper | Kansas | 20077 | 225 | 4 |
729890 | 729890 | 2020-11-14 | Harper | Kansas | 20077 | 225 | 4 |
538594 | 538594 | 2020-09-16 | Jackson | Kansas | 20085 | 225 | 2 |
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);