ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 85 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
791533 | 791533 | 2020-12-03 | Comanche | Kansas | 20033 | 85 | 0 |
788288 | 788288 | 2020-12-02 | Comanche | Kansas | 20033 | 85 | 0 |
778572 | 778572 | 2020-11-29 | Greeley | Kansas | 20071 | 85 | 0 |
775327 | 775327 | 2020-11-28 | Greeley | Kansas | 20071 | 85 | 0 |
772082 | 772082 | 2020-11-27 | Greeley | Kansas | 20071 | 85 | 0 |
768837 | 768837 | 2020-11-26 | Greeley | Kansas | 20071 | 85 | 0 |
765591 | 765591 | 2020-11-25 | Greeley | Kansas | 20071 | 85 | 0 |
733134 | 733134 | 2020-11-15 | Hamilton | Kansas | 20075 | 85 | 0 |
729889 | 729889 | 2020-11-14 | Hamilton | Kansas | 20075 | 85 | 0 |
726646 | 726646 | 2020-11-13 | Hamilton | Kansas | 20075 | 85 | 0 |
723414 | 723414 | 2020-11-12 | Kiowa | Kansas | 20097 | 85 | 0 |
720171 | 720171 | 2020-11-11 | Kiowa | Kansas | 20097 | 85 | 0 |
710433 | 710433 | 2020-11-08 | Hodgeman | Kansas | 20083 | 85 | 0 |
707189 | 707189 | 2020-11-07 | Hodgeman | Kansas | 20083 | 85 | 0 |
703946 | 703946 | 2020-11-06 | Hodgeman | Kansas | 20083 | 85 | 0 |
678051 | 678051 | 2020-10-29 | Stafford | Kansas | 20185 | 85 | 1 |
674808 | 674808 | 2020-10-28 | Stafford | Kansas | 20185 | 85 | 1 |
665023 | 665023 | 2020-10-25 | Greenwood | Kansas | 20073 | 85 | 0 |
661778 | 661778 | 2020-10-24 | Greenwood | Kansas | 20073 | 85 | 0 |
658534 | 658534 | 2020-10-23 | Greenwood | Kansas | 20073 | 85 | 0 |
626057 | 626057 | 2020-10-13 | Cheyenne | Kansas | 20023 | 85 | 3 |
626148 | 626148 | 2020-10-13 | Wilson | Kansas | 20205 | 85 | 2 |
622815 | 622815 | 2020-10-12 | Cheyenne | Kansas | 20023 | 85 | 3 |
622906 | 622906 | 2020-10-12 | Wilson | Kansas | 20205 | 85 | 2 |
619662 | 619662 | 2020-10-11 | Wilson | Kansas | 20205 | 85 | 2 |
616420 | 616420 | 2020-10-10 | Wilson | Kansas | 20205 | 85 | 2 |
613179 | 613179 | 2020-10-09 | Wilson | Kansas | 20205 | 85 | 2 |
596866 | 596866 | 2020-10-04 | Anderson | Kansas | 20003 | 85 | 0 |
593624 | 593624 | 2020-10-03 | Anderson | Kansas | 20003 | 85 | 0 |
593654 | 593654 | 2020-10-03 | Gove | Kansas | 20063 | 85 | 0 |
590383 | 590383 | 2020-10-02 | Anderson | Kansas | 20003 | 85 | 0 |
590413 | 590413 | 2020-10-02 | Gove | Kansas | 20063 | 85 | 0 |
587142 | 587142 | 2020-10-01 | Anderson | Kansas | 20003 | 85 | 0 |
583902 | 583902 | 2020-09-30 | Anderson | Kansas | 20003 | 85 | 0 |
580663 | 580663 | 2020-09-29 | Anderson | Kansas | 20003 | 85 | 0 |
580729 | 580729 | 2020-09-29 | Ness | Kansas | 20135 | 85 | 6 |
577488 | 577488 | 2020-09-28 | Ness | Kansas | 20135 | 85 | 6 |
541845 | 541845 | 2020-09-17 | Marion | Kansas | 20115 | 85 | 1 |
538608 | 538608 | 2020-09-16 | Marion | Kansas | 20115 | 85 | 1 |
535372 | 535372 | 2020-09-15 | Marion | Kansas | 20115 | 85 | 1 |
535385 | 535385 | 2020-09-15 | Osage | Kansas | 20139 | 85 | 0 |
532137 | 532137 | 2020-09-14 | Marion | Kansas | 20115 | 85 | 1 |
532150 | 532150 | 2020-09-14 | Osage | Kansas | 20139 | 85 | 0 |
525704 | 525704 | 2020-09-12 | Thomas | Kansas | 20193 | 85 | 0 |
473900 | 473900 | 2020-08-27 | Gray | Kansas | 20069 | 85 | 0 |
470668 | 470668 | 2020-08-26 | Gray | Kansas | 20069 | 85 | 0 |
370845 | 370845 | 2020-07-26 | Sumner | Kansas | 20191 | 85 | 2 |
367635 | 367635 | 2020-07-25 | Sumner | Kansas | 20191 | 85 | 2 |
364428 | 364428 | 2020-07-24 | Sumner | Kansas | 20191 | 85 | 2 |
303778 | 303778 | 2020-07-05 | Geary | Kansas | 20061 | 85 | 1 |
300614 | 300614 | 2020-07-04 | Geary | Kansas | 20061 | 85 | 1 |
297452 | 297452 | 2020-07-03 | Geary | Kansas | 20061 | 85 | 1 |
244142 | 244142 | 2020-06-16 | Douglas | Kansas | 20045 | 85 | 0 |
241031 | 241031 | 2020-06-15 | Douglas | Kansas | 20045 | 85 | 0 |
65457 | 65457 | 2020-04-17 | Ford | Kansas | 20057 | 85 | 0 |
29169 | 29169 | 2020-04-03 | Sedgwick | Kansas | 20173 | 85 | 1 |
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);