ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where "date" is on date 2020-04-13 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 62
- 20005 1
- 20007 1
- 20009 1
- 20011 1
- 20015 1
- 20019 1
- 20021 1
- 20027 1
- 20029 1
- 20031 1
- 20035 1
- 20037 1
- 20043 1
- 20045 1
- 20051 1
- 20055 1
- 20057 1
- 20059 1
- 20061 1
- 20063 1
- 20073 1
- 20075 1
- 20079 1
- 20085 1
- 20087 1
- 20089 1
- 20091 1
- 20093 1
- 20099 1
- 20103 1
- 20107 1
- 20111 1
- 20113 1
- 20115 1
- 20121 1
- 20123 1
- 20125 1
- 20127 1
- 20129 1
- 20133 1
- 20139 1
- 20141 1
- 20143 1
- 20147 1
- 20149 1
- 20151 1
- 20155 1
- 20157 1
- 20161 1
- 20163 1
- 20169 1
- 20171 1
- 20173 1
- 20175 1
- 20177 1
- 20185 1
- 20187 1
- 20189 1
- 20191 1
- 20197 1
- 20207 1
- 20209 1
county 62
- Atchison 1
- Barber 1
- Barton 1
- Bourbon 1
- Butler 1
- Chautauqua 1
- Cherokee 1
- Clay 1
- Cloud 1
- Coffey 1
- Cowley 1
- Crawford 1
- Doniphan 1
- Douglas 1
- Ellis 1
- Finney 1
- Ford 1
- Franklin 1
- Geary 1
- Gove 1
- Greenwood 1
- Hamilton 1
- Harvey 1
- Jackson 1
- Jefferson 1
- Jewell 1
- Johnson 1
- Kearny 1
- Labette 1
- Leavenworth 1
- Linn 1
- Lyon 1
- Marion 1
- McPherson 1
- Miami 1
- Mitchell 1
- Montgomery 1
- Morris 1
- Morton 1
- Neosho 1
- Osage 1
- Osborne 1
- Ottawa 1
- Phillips 1
- Pottawatomie 1
- Pratt 1
- Reno 1
- Republic 1
- Riley 1
- Rooks 1
- Saline 1
- Scott 1
- Sedgwick 1
- Seward 1
- Shawnee 1
- Stafford 1
- Stanton 1
- Stevens 1
- Sumner 1
- Wabaunsee 1
- Woodson 1
- Wyandotte 1
state 1
- Kansas · 62 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
54582 | 54582 | 2020-04-13 | Atchison | Kansas | 20005 | 3 | 0 |
54583 | 54583 | 2020-04-13 | Barber | Kansas | 20007 | 1 | 0 |
54584 | 54584 | 2020-04-13 | Barton | Kansas | 20009 | 5 | 0 |
54585 | 54585 | 2020-04-13 | Bourbon | Kansas | 20011 | 6 | 1 |
54586 | 54586 | 2020-04-13 | Butler | Kansas | 20015 | 9 | 0 |
54587 | 54587 | 2020-04-13 | Chautauqua | Kansas | 20019 | 3 | 0 |
54588 | 54588 | 2020-04-13 | Cherokee | Kansas | 20021 | 6 | 0 |
54589 | 54589 | 2020-04-13 | Clay | Kansas | 20027 | 1 | 0 |
54590 | 54590 | 2020-04-13 | Cloud | Kansas | 20029 | 3 | 0 |
54591 | 54591 | 2020-04-13 | Coffey | Kansas | 20031 | 40 | 3 |
54592 | 54592 | 2020-04-13 | Cowley | Kansas | 20035 | 2 | 1 |
54593 | 54593 | 2020-04-13 | Crawford | Kansas | 20037 | 6 | 1 |
54594 | 54594 | 2020-04-13 | Doniphan | Kansas | 20043 | 1 | 0 |
54595 | 54595 | 2020-04-13 | Douglas | Kansas | 20045 | 40 | 0 |
54596 | 54596 | 2020-04-13 | Ellis | Kansas | 20051 | 1 | 0 |
54597 | 54597 | 2020-04-13 | Finney | Kansas | 20055 | 16 | 0 |
54598 | 54598 | 2020-04-13 | Ford | Kansas | 20057 | 16 | 0 |
54599 | 54599 | 2020-04-13 | Franklin | Kansas | 20059 | 12 | 0 |
54600 | 54600 | 2020-04-13 | Geary | Kansas | 20061 | 8 | 0 |
54601 | 54601 | 2020-04-13 | Gove | Kansas | 20063 | 1 | 0 |
54602 | 54602 | 2020-04-13 | Greenwood | Kansas | 20073 | 1 | 0 |
54603 | 54603 | 2020-04-13 | Hamilton | Kansas | 20075 | 1 | 0 |
54604 | 54604 | 2020-04-13 | Harvey | Kansas | 20079 | 4 | 0 |
54605 | 54605 | 2020-04-13 | Jackson | Kansas | 20085 | 1 | 0 |
54606 | 54606 | 2020-04-13 | Jefferson | Kansas | 20087 | 5 | 0 |
54607 | 54607 | 2020-04-13 | Jewell | Kansas | 20089 | 3 | 0 |
54608 | 54608 | 2020-04-13 | Johnson | Kansas | 20091 | 309 | 15 |
54609 | 54609 | 2020-04-13 | Kearny | Kansas | 20093 | 1 | 0 |
54610 | 54610 | 2020-04-13 | Labette | Kansas | 20099 | 18 | 0 |
54611 | 54611 | 2020-04-13 | Leavenworth | Kansas | 20103 | 87 | 1 |
54612 | 54612 | 2020-04-13 | Linn | Kansas | 20107 | 6 | 0 |
54613 | 54613 | 2020-04-13 | Lyon | Kansas | 20111 | 29 | 0 |
54614 | 54614 | 2020-04-13 | Marion | Kansas | 20115 | 4 | 0 |
54615 | 54615 | 2020-04-13 | McPherson | Kansas | 20113 | 13 | 0 |
54616 | 54616 | 2020-04-13 | Miami | Kansas | 20121 | 3 | 0 |
54617 | 54617 | 2020-04-13 | Mitchell | Kansas | 20123 | 2 | 0 |
54618 | 54618 | 2020-04-13 | Montgomery | Kansas | 20125 | 11 | 2 |
54619 | 54619 | 2020-04-13 | Morris | Kansas | 20127 | 2 | 0 |
54620 | 54620 | 2020-04-13 | Morton | Kansas | 20129 | 1 | 0 |
54621 | 54621 | 2020-04-13 | Neosho | Kansas | 20133 | 2 | 0 |
54622 | 54622 | 2020-04-13 | Osage | Kansas | 20139 | 4 | 0 |
54623 | 54623 | 2020-04-13 | Osborne | Kansas | 20141 | 2 | 0 |
54624 | 54624 | 2020-04-13 | Ottawa | Kansas | 20143 | 3 | 0 |
54625 | 54625 | 2020-04-13 | Phillips | Kansas | 20147 | 1 | 0 |
54626 | 54626 | 2020-04-13 | Pottawatomie | Kansas | 20149 | 5 | 0 |
54627 | 54627 | 2020-04-13 | Pratt | Kansas | 20151 | 1 | 0 |
54628 | 54628 | 2020-04-13 | Reno | Kansas | 20155 | 13 | 0 |
54629 | 54629 | 2020-04-13 | Republic | Kansas | 20157 | 4 | 0 |
54630 | 54630 | 2020-04-13 | Riley | Kansas | 20161 | 21 | 0 |
54631 | 54631 | 2020-04-13 | Rooks | Kansas | 20163 | 2 | 0 |
54632 | 54632 | 2020-04-13 | Saline | Kansas | 20169 | 10 | 2 |
54633 | 54633 | 2020-04-13 | Scott | Kansas | 20171 | 2 | 0 |
54634 | 54634 | 2020-04-13 | Sedgwick | Kansas | 20173 | 200 | 2 |
54635 | 54635 | 2020-04-13 | Seward | Kansas | 20175 | 6 | 0 |
54636 | 54636 | 2020-04-13 | Shawnee | Kansas | 20177 | 78 | 5 |
54637 | 54637 | 2020-04-13 | Stafford | Kansas | 20185 | 1 | 0 |
54638 | 54638 | 2020-04-13 | Stanton | Kansas | 20187 | 2 | 0 |
54639 | 54639 | 2020-04-13 | Stevens | Kansas | 20189 | 2 | 0 |
54640 | 54640 | 2020-04-13 | Sumner | Kansas | 20191 | 2 | 1 |
54641 | 54641 | 2020-04-13 | Wabaunsee | Kansas | 20197 | 1 | 0 |
54642 | 54642 | 2020-04-13 | Woodson | Kansas | 20207 | 4 | 0 |
54643 | 54643 | 2020-04-13 | Wyandotte | Kansas | 20209 | 337 | 29 |
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);