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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 20091 798
- 20209 793
- 20015 792
- 20059 791
- 20045 788
- 20057 788
- 20103 787
- 20021 786
- 20107 786
- 20127 786
- 20173 786
- 20155 785
- 20161 785
- 20085 783
- 20123 783
- 20011 782
- 20111 782
- 20043 781
- 20149 781
- 20207 781
- 20037 780
- 20133 780
- 20177 780
- 20087 779
- 20191 779
- 20027 778
- 20031 778
- 20063 778
- 20079 778
- 20113 778
- …
county >30
- Johnson 798
- Wyandotte 793
- Butler 792
- Franklin 791
- Douglas 788
- Ford 788
- Leavenworth 787
- Cherokee 786
- Linn 786
- Morris 786
- Sedgwick 786
- Reno 785
- Riley 785
- Jackson 783
- Mitchell 783
- Bourbon 782
- Lyon 782
- Doniphan 781
- Pottawatomie 781
- Woodson 781
- Crawford 780
- Neosho 780
- Shawnee 780
- Jefferson 779
- Sumner 779
- Clay 778
- Coffey 778
- Gove 778
- Harvey 778
- McPherson 778
- …
state 1
- Kansas · 79,294 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
699 | 699 | 2020-03-07 | Johnson | Kansas | 20091 | 1 | 0 |
798 | 798 | 2020-03-08 | Johnson | Kansas | 20091 | 1 | 0 |
920 | 920 | 2020-03-09 | Johnson | Kansas | 20091 | 1 | 0 |
1065 | 1065 | 2020-03-10 | Johnson | Kansas | 20091 | 1 | 0 |
1243 | 1243 | 2020-03-11 | Johnson | Kansas | 20091 | 1 | 0 |
1458 | 1458 | 2020-03-12 | Johnson | Kansas | 20091 | 4 | 0 |
1459 | 1459 | 2020-03-12 | Wyandotte | Kansas | 20209 | 1 | 1 |
1730 | 1730 | 2020-03-13 | Butler | Kansas | 20015 | 1 | 0 |
1731 | 1731 | 2020-03-13 | Johnson | Kansas | 20091 | 4 | 0 |
1732 | 1732 | 2020-03-13 | Wyandotte | Kansas | 20209 | 1 | 1 |
2064 | 2064 | 2020-03-14 | Butler | Kansas | 20015 | 1 | 0 |
2065 | 2065 | 2020-03-14 | Franklin | Kansas | 20059 | 1 | 0 |
2066 | 2066 | 2020-03-14 | Johnson | Kansas | 20091 | 5 | 0 |
2067 | 2067 | 2020-03-14 | Wyandotte | Kansas | 20209 | 1 | 1 |
2460 | 2460 | 2020-03-15 | Butler | Kansas | 20015 | 1 | 0 |
2461 | 2461 | 2020-03-15 | Franklin | Kansas | 20059 | 1 | 0 |
2462 | 2462 | 2020-03-15 | Johnson | Kansas | 20091 | 6 | 0 |
2463 | 2463 | 2020-03-15 | Wyandotte | Kansas | 20209 | 1 | 1 |
2905 | 2905 | 2020-03-16 | Butler | Kansas | 20015 | 1 | 0 |
2906 | 2906 | 2020-03-16 | Franklin | Kansas | 20059 | 1 | 0 |
2907 | 2907 | 2020-03-16 | Johnson | Kansas | 20091 | 8 | 0 |
2908 | 2908 | 2020-03-16 | Wyandotte | Kansas | 20209 | 1 | 1 |
3398 | 3398 | 2020-03-17 | Butler | Kansas | 20015 | 1 | 0 |
3399 | 3399 | 2020-03-17 | Douglas | Kansas | 20045 | 1 | 0 |
3400 | 3400 | 2020-03-17 | Ford | Kansas | 20057 | 1 | 0 |
3401 | 3401 | 2020-03-17 | Franklin | Kansas | 20059 | 1 | 0 |
3402 | 3402 | 2020-03-17 | Johnson | Kansas | 20091 | 10 | 0 |
3403 | 3403 | 2020-03-17 | Wyandotte | Kansas | 20209 | 3 | 1 |
3974 | 3974 | 2020-03-18 | Butler | Kansas | 20015 | 1 | 0 |
3975 | 3975 | 2020-03-18 | Douglas | Kansas | 20045 | 1 | 0 |
3976 | 3976 | 2020-03-18 | Ford | Kansas | 20057 | 1 | 0 |
3977 | 3977 | 2020-03-18 | Franklin | Kansas | 20059 | 1 | 0 |
3978 | 3978 | 2020-03-18 | Johnson | Kansas | 20091 | 11 | 0 |
3979 | 3979 | 2020-03-18 | Leavenworth | Kansas | 20103 | 2 | 0 |
3980 | 3980 | 2020-03-18 | Wyandotte | Kansas | 20209 | 5 | 1 |
4655 | 4655 | 2020-03-19 | Butler | Kansas | 20015 | 1 | 0 |
4656 | 4656 | 2020-03-19 | Cherokee | Kansas | 20021 | 1 | 0 |
4657 | 4657 | 2020-03-19 | Douglas | Kansas | 20045 | 1 | 0 |
4658 | 4658 | 2020-03-19 | Ford | Kansas | 20057 | 1 | 0 |
4659 | 4659 | 2020-03-19 | Franklin | Kansas | 20059 | 1 | 0 |
4660 | 4660 | 2020-03-19 | Johnson | Kansas | 20091 | 16 | 0 |
4661 | 4661 | 2020-03-19 | Leavenworth | Kansas | 20103 | 2 | 0 |
4662 | 4662 | 2020-03-19 | Linn | Kansas | 20107 | 1 | 0 |
4663 | 4663 | 2020-03-19 | Morris | Kansas | 20127 | 2 | 0 |
4664 | 4664 | 2020-03-19 | Sedgwick | Kansas | 20173 | 1 | 0 |
4665 | 4665 | 2020-03-19 | Wyandotte | Kansas | 20209 | 8 | 1 |
5466 | 5466 | 2020-03-20 | Butler | Kansas | 20015 | 2 | 0 |
5467 | 5467 | 2020-03-20 | Cherokee | Kansas | 20021 | 1 | 0 |
5468 | 5468 | 2020-03-20 | Douglas | Kansas | 20045 | 1 | 0 |
5469 | 5469 | 2020-03-20 | Ford | Kansas | 20057 | 1 | 0 |
5470 | 5470 | 2020-03-20 | Franklin | Kansas | 20059 | 1 | 0 |
5471 | 5471 | 2020-03-20 | Johnson | Kansas | 20091 | 24 | 0 |
5472 | 5472 | 2020-03-20 | Leavenworth | Kansas | 20103 | 4 | 0 |
5473 | 5473 | 2020-03-20 | Linn | Kansas | 20107 | 1 | 0 |
5474 | 5474 | 2020-03-20 | Morris | Kansas | 20127 | 2 | 0 |
5475 | 5475 | 2020-03-20 | Reno | Kansas | 20155 | 1 | 0 |
5476 | 5476 | 2020-03-20 | Riley | Kansas | 20161 | 1 | 0 |
5477 | 5477 | 2020-03-20 | Sedgwick | Kansas | 20173 | 1 | 0 |
5478 | 5478 | 2020-03-20 | Wyandotte | Kansas | 20209 | 9 | 1 |
6411 | 6411 | 2020-03-21 | Butler | Kansas | 20015 | 2 | 0 |
6412 | 6412 | 2020-03-21 | Cherokee | Kansas | 20021 | 1 | 0 |
6413 | 6413 | 2020-03-21 | Douglas | Kansas | 20045 | 3 | 0 |
6414 | 6414 | 2020-03-21 | Ford | Kansas | 20057 | 1 | 0 |
6415 | 6415 | 2020-03-21 | Franklin | Kansas | 20059 | 1 | 0 |
6416 | 6416 | 2020-03-21 | Johnson | Kansas | 20091 | 25 | 1 |
6417 | 6417 | 2020-03-21 | Leavenworth | Kansas | 20103 | 4 | 0 |
6418 | 6418 | 2020-03-21 | Linn | Kansas | 20107 | 1 | 0 |
6419 | 6419 | 2020-03-21 | Morris | Kansas | 20127 | 2 | 0 |
6420 | 6420 | 2020-03-21 | Reno | Kansas | 20155 | 1 | 0 |
6421 | 6421 | 2020-03-21 | Riley | Kansas | 20161 | 1 | 0 |
6422 | 6422 | 2020-03-21 | Sedgwick | Kansas | 20173 | 2 | 0 |
6423 | 6423 | 2020-03-21 | Wyandotte | Kansas | 20209 | 13 | 1 |
7478 | 7478 | 2020-03-22 | Butler | Kansas | 20015 | 3 | 0 |
7479 | 7479 | 2020-03-22 | Cherokee | Kansas | 20021 | 1 | 0 |
7480 | 7480 | 2020-03-22 | Douglas | Kansas | 20045 | 4 | 0 |
7481 | 7481 | 2020-03-22 | Ford | Kansas | 20057 | 1 | 0 |
7482 | 7482 | 2020-03-22 | Franklin | Kansas | 20059 | 1 | 0 |
7483 | 7483 | 2020-03-22 | Jackson | Kansas | 20085 | 1 | 0 |
7484 | 7484 | 2020-03-22 | Johnson | Kansas | 20091 | 28 | 1 |
7485 | 7485 | 2020-03-22 | Leavenworth | Kansas | 20103 | 4 | 0 |
7486 | 7486 | 2020-03-22 | Linn | Kansas | 20107 | 1 | 0 |
7487 | 7487 | 2020-03-22 | Mitchell | Kansas | 20123 | 1 | 0 |
7488 | 7488 | 2020-03-22 | Morris | Kansas | 20127 | 2 | 0 |
7489 | 7489 | 2020-03-22 | Reno | Kansas | 20155 | 2 | 0 |
7490 | 7490 | 2020-03-22 | Riley | Kansas | 20161 | 1 | 0 |
7491 | 7491 | 2020-03-22 | Sedgwick | Kansas | 20173 | 2 | 0 |
7492 | 7492 | 2020-03-22 | Wyandotte | Kansas | 20209 | 14 | 1 |
8638 | 8638 | 2020-03-23 | Bourbon | Kansas | 20011 | 1 | 0 |
8639 | 8639 | 2020-03-23 | Butler | Kansas | 20015 | 3 | 0 |
8640 | 8640 | 2020-03-23 | Cherokee | Kansas | 20021 | 2 | 0 |
8641 | 8641 | 2020-03-23 | Douglas | Kansas | 20045 | 6 | 0 |
8642 | 8642 | 2020-03-23 | Ford | Kansas | 20057 | 1 | 0 |
8643 | 8643 | 2020-03-23 | Franklin | Kansas | 20059 | 1 | 0 |
8644 | 8644 | 2020-03-23 | Jackson | Kansas | 20085 | 1 | 0 |
8645 | 8645 | 2020-03-23 | Johnson | Kansas | 20091 | 32 | 1 |
8646 | 8646 | 2020-03-23 | Leavenworth | Kansas | 20103 | 5 | 0 |
8647 | 8647 | 2020-03-23 | Linn | Kansas | 20107 | 2 | 0 |
8648 | 8648 | 2020-03-23 | Lyon | Kansas | 20111 | 2 | 0 |
8649 | 8649 | 2020-03-23 | Mitchell | Kansas | 20123 | 3 | 0 |
8650 | 8650 | 2020-03-23 | Morris | Kansas | 20127 | 2 | 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);