ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79,294 rows where state = "Kansas" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 20209 793
- 20091 784
- 20123 781
- 20127 781
- 20149 781
- 20155 781
- 20161 781
- 20173 781
- 20207 781
- 20011 780
- 20015 780
- 20021 780
- 20037 780
- 20043 780
- 20045 780
- 20057 780
- 20059 780
- 20085 780
- 20103 780
- 20107 780
- 20111 780
- 20133 780
- 20177 780
- 20087 779
- 20191 779
- 20027 778
- 20031 778
- 20063 778
- 20079 778
- 20113 778
- …
county >30
- Wyandotte 793
- Johnson 784
- Mitchell 781
- Morris 781
- Pottawatomie 781
- Reno 781
- Riley 781
- Sedgwick 781
- Woodson 781
- Bourbon 780
- Butler 780
- Cherokee 780
- Crawford 780
- Doniphan 780
- Douglas 780
- Ford 780
- Franklin 780
- Jackson 780
- Leavenworth 780
- Linn 780
- Lyon 780
- Neosho 780
- Shawnee 780
- Jefferson 779
- Sumner 779
- Clay 778
- Coffey 778
- Gove 778
- Harvey 778
- McPherson 778
- …
state 1
- Kansas · 79,194 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
9930 | 9930 | 2020-03-24 | Mitchell | Kansas | 20123 | 3 | 0 |
9931 | 9931 | 2020-03-24 | Morris | Kansas | 20127 | 2 | 0 |
9932 | 9932 | 2020-03-24 | Pottawatomie | Kansas | 20149 | 1 | 0 |
9933 | 9933 | 2020-03-24 | Reno | Kansas | 20155 | 2 | 0 |
9934 | 9934 | 2020-03-24 | Riley | Kansas | 20161 | 1 | 0 |
9935 | 9935 | 2020-03-24 | Sedgwick | Kansas | 20173 | 7 | 0 |
9936 | 9936 | 2020-03-24 | Woodson | Kansas | 20207 | 1 | 0 |
11315 | 11315 | 2020-03-25 | Bourbon | Kansas | 20011 | 1 | 0 |
11316 | 11316 | 2020-03-25 | Butler | Kansas | 20015 | 3 | 0 |
11317 | 11317 | 2020-03-25 | Cherokee | Kansas | 20021 | 2 | 0 |
11318 | 11318 | 2020-03-25 | Crawford | Kansas | 20037 | 1 | 0 |
11319 | 11319 | 2020-03-25 | Doniphan | Kansas | 20043 | 1 | 0 |
11320 | 11320 | 2020-03-25 | Douglas | Kansas | 20045 | 10 | 0 |
11321 | 11321 | 2020-03-25 | Ford | Kansas | 20057 | 1 | 0 |
11322 | 11322 | 2020-03-25 | Franklin | Kansas | 20059 | 1 | 0 |
11323 | 11323 | 2020-03-25 | Jackson | Kansas | 20085 | 1 | 0 |
11325 | 11325 | 2020-03-25 | Leavenworth | Kansas | 20103 | 11 | 0 |
11326 | 11326 | 2020-03-25 | Linn | Kansas | 20107 | 2 | 0 |
11327 | 11327 | 2020-03-25 | Lyon | Kansas | 20111 | 2 | 0 |
11328 | 11328 | 2020-03-25 | Mitchell | Kansas | 20123 | 3 | 0 |
11329 | 11329 | 2020-03-25 | Morris | Kansas | 20127 | 2 | 0 |
11330 | 11330 | 2020-03-25 | Neosho | Kansas | 20133 | 1 | 0 |
11331 | 11331 | 2020-03-25 | Pottawatomie | Kansas | 20149 | 1 | 0 |
11332 | 11332 | 2020-03-25 | Reno | Kansas | 20155 | 2 | 0 |
11333 | 11333 | 2020-03-25 | Riley | Kansas | 20161 | 1 | 0 |
11334 | 11334 | 2020-03-25 | Sedgwick | Kansas | 20173 | 11 | 0 |
11335 | 11335 | 2020-03-25 | Shawnee | Kansas | 20177 | 3 | 0 |
11336 | 11336 | 2020-03-25 | Woodson | Kansas | 20207 | 1 | 0 |
12882 | 12882 | 2020-03-26 | Bourbon | Kansas | 20011 | 1 | 0 |
12883 | 12883 | 2020-03-26 | Butler | Kansas | 20015 | 3 | 0 |
12884 | 12884 | 2020-03-26 | Cherokee | Kansas | 20021 | 2 | 0 |
12885 | 12885 | 2020-03-26 | Crawford | Kansas | 20037 | 3 | 0 |
12886 | 12886 | 2020-03-26 | Doniphan | Kansas | 20043 | 1 | 0 |
12887 | 12887 | 2020-03-26 | Douglas | Kansas | 20045 | 13 | 0 |
12888 | 12888 | 2020-03-26 | Ford | Kansas | 20057 | 1 | 0 |
12889 | 12889 | 2020-03-26 | Franklin | Kansas | 20059 | 1 | 0 |
12890 | 12890 | 2020-03-26 | Jackson | Kansas | 20085 | 1 | 0 |
12891 | 12891 | 2020-03-26 | Jefferson | Kansas | 20087 | 1 | 0 |
12893 | 12893 | 2020-03-26 | Leavenworth | Kansas | 20103 | 12 | 0 |
12894 | 12894 | 2020-03-26 | Linn | Kansas | 20107 | 4 | 0 |
12895 | 12895 | 2020-03-26 | Lyon | Kansas | 20111 | 3 | 0 |
12896 | 12896 | 2020-03-26 | Mitchell | Kansas | 20123 | 3 | 0 |
12897 | 12897 | 2020-03-26 | Morris | Kansas | 20127 | 2 | 0 |
12898 | 12898 | 2020-03-26 | Neosho | Kansas | 20133 | 1 | 0 |
12899 | 12899 | 2020-03-26 | Pottawatomie | Kansas | 20149 | 1 | 0 |
12900 | 12900 | 2020-03-26 | Reno | Kansas | 20155 | 4 | 0 |
12901 | 12901 | 2020-03-26 | Riley | Kansas | 20161 | 1 | 0 |
12902 | 12902 | 2020-03-26 | Sedgwick | Kansas | 20173 | 16 | 0 |
12903 | 12903 | 2020-03-26 | Shawnee | Kansas | 20177 | 4 | 0 |
12904 | 12904 | 2020-03-26 | Sumner | Kansas | 20191 | 1 | 0 |
12905 | 12905 | 2020-03-26 | Woodson | Kansas | 20207 | 1 | 0 |
14578 | 14578 | 2020-03-27 | Bourbon | Kansas | 20011 | 3 | 0 |
14579 | 14579 | 2020-03-27 | Butler | Kansas | 20015 | 3 | 0 |
14580 | 14580 | 2020-03-27 | Cherokee | Kansas | 20021 | 2 | 0 |
14581 | 14581 | 2020-03-27 | Clay | Kansas | 20027 | 1 | 0 |
14582 | 14582 | 2020-03-27 | Coffey | Kansas | 20031 | 1 | 0 |
14583 | 14583 | 2020-03-27 | Crawford | Kansas | 20037 | 3 | 0 |
14584 | 14584 | 2020-03-27 | Doniphan | Kansas | 20043 | 1 | 0 |
14585 | 14585 | 2020-03-27 | Douglas | Kansas | 20045 | 18 | 0 |
14586 | 14586 | 2020-03-27 | Ford | Kansas | 20057 | 1 | 0 |
14587 | 14587 | 2020-03-27 | Franklin | Kansas | 20059 | 2 | 0 |
14588 | 14588 | 2020-03-27 | Gove | Kansas | 20063 | 1 | 0 |
14589 | 14589 | 2020-03-27 | Harvey | Kansas | 20079 | 1 | 0 |
14590 | 14590 | 2020-03-27 | Jackson | Kansas | 20085 | 1 | 0 |
14591 | 14591 | 2020-03-27 | Jefferson | Kansas | 20087 | 1 | 0 |
14593 | 14593 | 2020-03-27 | Leavenworth | Kansas | 20103 | 12 | 0 |
14594 | 14594 | 2020-03-27 | Linn | Kansas | 20107 | 4 | 0 |
14595 | 14595 | 2020-03-27 | Lyon | Kansas | 20111 | 5 | 0 |
14596 | 14596 | 2020-03-27 | McPherson | Kansas | 20113 | 1 | 0 |
14597 | 14597 | 2020-03-27 | Mitchell | Kansas | 20123 | 3 | 0 |
14598 | 14598 | 2020-03-27 | Morris | Kansas | 20127 | 2 | 0 |
14599 | 14599 | 2020-03-27 | Neosho | Kansas | 20133 | 1 | 0 |
14600 | 14600 | 2020-03-27 | Osage | Kansas | 20139 | 1 | 0 |
14601 | 14601 | 2020-03-27 | Ottawa | Kansas | 20143 | 1 | 0 |
14602 | 14602 | 2020-03-27 | Pottawatomie | Kansas | 20149 | 1 | 0 |
14603 | 14603 | 2020-03-27 | Reno | Kansas | 20155 | 5 | 0 |
14604 | 14604 | 2020-03-27 | Riley | Kansas | 20161 | 2 | 0 |
14605 | 14605 | 2020-03-27 | Sedgwick | Kansas | 20173 | 20 | 0 |
14606 | 14606 | 2020-03-27 | Shawnee | Kansas | 20177 | 5 | 0 |
14607 | 14607 | 2020-03-27 | Sumner | Kansas | 20191 | 1 | 0 |
14608 | 14608 | 2020-03-27 | Woodson | Kansas | 20207 | 1 | 0 |
16385 | 16385 | 2020-03-28 | Bourbon | Kansas | 20011 | 3 | 0 |
16386 | 16386 | 2020-03-28 | Butler | Kansas | 20015 | 3 | 0 |
16387 | 16387 | 2020-03-28 | Cherokee | Kansas | 20021 | 2 | 0 |
16388 | 16388 | 2020-03-28 | Clay | Kansas | 20027 | 1 | 0 |
16389 | 16389 | 2020-03-28 | Coffey | Kansas | 20031 | 8 | 0 |
16390 | 16390 | 2020-03-28 | Crawford | Kansas | 20037 | 3 | 0 |
16391 | 16391 | 2020-03-28 | Doniphan | Kansas | 20043 | 1 | 0 |
16392 | 16392 | 2020-03-28 | Douglas | Kansas | 20045 | 23 | 0 |
16393 | 16393 | 2020-03-28 | Ford | Kansas | 20057 | 1 | 0 |
16394 | 16394 | 2020-03-28 | Franklin | Kansas | 20059 | 6 | 0 |
16395 | 16395 | 2020-03-28 | Gove | Kansas | 20063 | 1 | 0 |
16396 | 16396 | 2020-03-28 | Harvey | Kansas | 20079 | 1 | 0 |
16397 | 16397 | 2020-03-28 | Jackson | Kansas | 20085 | 1 | 0 |
16398 | 16398 | 2020-03-28 | Jefferson | Kansas | 20087 | 1 | 0 |
16400 | 16400 | 2020-03-28 | Leavenworth | Kansas | 20103 | 15 | 0 |
16401 | 16401 | 2020-03-28 | Linn | Kansas | 20107 | 4 | 0 |
16402 | 16402 | 2020-03-28 | Lyon | Kansas | 20111 | 5 | 0 |
16403 | 16403 | 2020-03-28 | McPherson | Kansas | 20113 | 1 | 0 |
16404 | 16404 | 2020-03-28 | Miami | Kansas | 20121 | 1 | 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);