ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where cases = 188 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1937792 | 1937792 | 2021-11-21 | Lane | Kansas | 20101 | 188 | 8 |
1934542 | 1934542 | 2021-11-20 | Lane | Kansas | 20101 | 188 | 8 |
1931291 | 1931291 | 2021-11-19 | Lane | Kansas | 20101 | 188 | 8 |
1619357 | 1619357 | 2021-08-15 | Comanche | Kansas | 20033 | 188 | 10 |
1616109 | 1616109 | 2021-08-14 | Comanche | Kansas | 20033 | 188 | 10 |
1612860 | 1612860 | 2021-08-13 | Comanche | Kansas | 20033 | 188 | 10 |
1551217 | 1551217 | 2021-07-25 | Stanton | Kansas | 20187 | 188 | 6 |
1547970 | 1547970 | 2021-07-24 | Stanton | Kansas | 20187 | 188 | 6 |
1544723 | 1544723 | 2021-07-23 | Stanton | Kansas | 20187 | 188 | 6 |
1541475 | 1541475 | 2021-07-22 | Stanton | Kansas | 20187 | 188 | 6 |
1538228 | 1538228 | 2021-07-21 | Stanton | Kansas | 20187 | 188 | 6 |
1518743 | 1518743 | 2021-07-15 | Stanton | Kansas | 20187 | 188 | 6 |
1515496 | 1515496 | 2021-07-14 | Stanton | Kansas | 20187 | 188 | 6 |
1512250 | 1512250 | 2021-07-13 | Stanton | Kansas | 20187 | 188 | 6 |
1509003 | 1509003 | 2021-07-12 | Stanton | Kansas | 20187 | 188 | 6 |
1505757 | 1505757 | 2021-07-11 | Stanton | Kansas | 20187 | 188 | 6 |
1502511 | 1502511 | 2021-07-10 | Stanton | Kansas | 20187 | 188 | 6 |
1499265 | 1499265 | 2021-07-09 | Stanton | Kansas | 20187 | 188 | 6 |
892161 | 892161 | 2021-01-03 | Hamilton | Kansas | 20075 | 188 | 0 |
888915 | 888915 | 2021-01-02 | Hamilton | Kansas | 20075 | 188 | 0 |
885669 | 885669 | 2021-01-01 | Hamilton | Kansas | 20075 | 188 | 0 |
768805 | 768805 | 2020-11-26 | Barber | Kansas | 20007 | 188 | 2 |
765559 | 765559 | 2020-11-25 | Barber | Kansas | 20007 | 188 | 2 |
739606 | 739606 | 2020-11-17 | Decatur | Kansas | 20039 | 188 | 1 |
736362 | 736362 | 2020-11-16 | Decatur | Kansas | 20039 | 188 | 1 |
716927 | 716927 | 2020-11-10 | Kingman | Kansas | 20095 | 188 | 3 |
713683 | 713683 | 2020-11-09 | Kingman | Kansas | 20095 | 188 | 3 |
710471 | 710471 | 2020-11-08 | Rice | Kansas | 20159 | 188 | 1 |
707227 | 707227 | 2020-11-07 | Rice | Kansas | 20159 | 188 | 1 |
703984 | 703984 | 2020-11-06 | Rice | Kansas | 20159 | 188 | 1 |
671475 | 671475 | 2020-10-27 | Anderson | Kansas | 20003 | 188 | 0 |
668232 | 668232 | 2020-10-26 | Anderson | Kansas | 20003 | 188 | 0 |
645604 | 645604 | 2020-10-19 | Scott | Kansas | 20171 | 188 | 1 |
642357 | 642357 | 2020-10-18 | Scott | Kansas | 20171 | 188 | 1 |
639110 | 639110 | 2020-10-17 | Scott | Kansas | 20171 | 188 | 1 |
635864 | 635864 | 2020-10-16 | Scott | Kansas | 20171 | 188 | 1 |
632601 | 632601 | 2020-10-15 | Norton | Kansas | 20137 | 188 | 0 |
629357 | 629357 | 2020-10-14 | Norton | Kansas | 20137 | 188 | 0 |
626140 | 626140 | 2020-10-13 | Stevens | Kansas | 20189 | 188 | 1 |
622898 | 622898 | 2020-10-12 | Stevens | Kansas | 20189 | 188 | 1 |
619654 | 619654 | 2020-10-11 | Stevens | Kansas | 20189 | 188 | 1 |
616412 | 616412 | 2020-10-10 | Stevens | Kansas | 20189 | 188 | 1 |
613171 | 613171 | 2020-10-09 | Stevens | Kansas | 20189 | 188 | 1 |
574199 | 574199 | 2020-09-27 | Dickinson | Kansas | 20041 | 188 | 1 |
525641 | 525641 | 2020-09-12 | Grant | Kansas | 20067 | 188 | 3 |
291132 | 291132 | 2020-07-01 | Douglas | Kansas | 20045 | 188 | 0 |
76518 | 76518 | 2020-04-21 | Ford | Kansas | 20057 | 188 | 0 |
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);