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 cases descending
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 |
---|---|---|---|---|---|---|---|
2500518 | 2500518 | 2022-05-13 | Johnson | Kansas | 20091 | 148890 | 1219 |
2477713 | 2477713 | 2022-05-06 | Johnson | Kansas | 20091 | 147803 | 1215 |
2480971 | 2480971 | 2022-05-07 | Johnson | Kansas | 20091 | 147803 | 1215 |
2484229 | 2484229 | 2022-05-08 | Johnson | Kansas | 20091 | 147803 | 1215 |
2487487 | 2487487 | 2022-05-09 | Johnson | Kansas | 20091 | 147803 | 1215 |
2490744 | 2490744 | 2022-05-10 | Johnson | Kansas | 20091 | 147803 | 1219 |
2494002 | 2494002 | 2022-05-11 | Johnson | Kansas | 20091 | 147803 | 1219 |
2497260 | 2497260 | 2022-05-12 | Johnson | Kansas | 20091 | 147803 | 1219 |
2454919 | 2454919 | 2022-04-29 | Johnson | Kansas | 20091 | 146955 | 1211 |
2458175 | 2458175 | 2022-04-30 | Johnson | Kansas | 20091 | 146955 | 1211 |
2461431 | 2461431 | 2022-05-01 | Johnson | Kansas | 20091 | 146955 | 1211 |
2464687 | 2464687 | 2022-05-02 | Johnson | Kansas | 20091 | 146955 | 1211 |
2467942 | 2467942 | 2022-05-03 | Johnson | Kansas | 20091 | 146955 | 1215 |
2471198 | 2471198 | 2022-05-04 | Johnson | Kansas | 20091 | 146955 | 1215 |
2474455 | 2474455 | 2022-05-05 | Johnson | Kansas | 20091 | 146955 | 1215 |
2432127 | 2432127 | 2022-04-22 | Johnson | Kansas | 20091 | 146355 | 1204 |
2435383 | 2435383 | 2022-04-23 | Johnson | Kansas | 20091 | 146355 | 1204 |
2438639 | 2438639 | 2022-04-24 | Johnson | Kansas | 20091 | 146355 | 1204 |
2441895 | 2441895 | 2022-04-25 | Johnson | Kansas | 20091 | 146355 | 1204 |
2445151 | 2445151 | 2022-04-26 | Johnson | Kansas | 20091 | 146355 | 1204 |
2448407 | 2448407 | 2022-04-27 | Johnson | Kansas | 20091 | 146355 | 1211 |
2451663 | 2451663 | 2022-04-28 | Johnson | Kansas | 20091 | 146355 | 1211 |
2409335 | 2409335 | 2022-04-15 | Johnson | Kansas | 20091 | 145781 | 1199 |
2412591 | 2412591 | 2022-04-16 | Johnson | Kansas | 20091 | 145781 | 1199 |
2415847 | 2415847 | 2022-04-17 | Johnson | Kansas | 20091 | 145781 | 1199 |
2419103 | 2419103 | 2022-04-18 | Johnson | Kansas | 20091 | 145781 | 1199 |
2422359 | 2422359 | 2022-04-19 | Johnson | Kansas | 20091 | 145781 | 1199 |
2425615 | 2425615 | 2022-04-20 | Johnson | Kansas | 20091 | 145781 | 1204 |
2428871 | 2428871 | 2022-04-21 | Johnson | Kansas | 20091 | 145781 | 1204 |
2500559 | 2500559 | 2022-05-13 | Sedgwick | Kansas | 20173 | 145517 | 1424 |
2386546 | 2386546 | 2022-04-08 | Johnson | Kansas | 20091 | 145478 | 1199 |
2389802 | 2389802 | 2022-04-09 | Johnson | Kansas | 20091 | 145478 | 1199 |
2393058 | 2393058 | 2022-04-10 | Johnson | Kansas | 20091 | 145478 | 1199 |
2396313 | 2396313 | 2022-04-11 | Johnson | Kansas | 20091 | 145478 | 1199 |
2399569 | 2399569 | 2022-04-12 | Johnson | Kansas | 20091 | 145478 | 1199 |
2402823 | 2402823 | 2022-04-13 | Johnson | Kansas | 20091 | 145478 | 1199 |
2406079 | 2406079 | 2022-04-14 | Johnson | Kansas | 20091 | 145478 | 1199 |
2363771 | 2363771 | 2022-04-01 | Johnson | Kansas | 20091 | 145215 | 1199 |
2367024 | 2367024 | 2022-04-02 | Johnson | Kansas | 20091 | 145215 | 1199 |
2370277 | 2370277 | 2022-04-03 | Johnson | Kansas | 20091 | 145215 | 1199 |
2373530 | 2373530 | 2022-04-04 | Johnson | Kansas | 20091 | 145215 | 1199 |
2376782 | 2376782 | 2022-04-05 | Johnson | Kansas | 20091 | 145215 | 1199 |
2380037 | 2380037 | 2022-04-06 | Johnson | Kansas | 20091 | 145215 | 1199 |
2383292 | 2383292 | 2022-04-07 | Johnson | Kansas | 20091 | 145215 | 1199 |
2477754 | 2477754 | 2022-05-06 | Sedgwick | Kansas | 20173 | 145185 | 1411 |
2481012 | 2481012 | 2022-05-07 | Sedgwick | Kansas | 20173 | 145185 | 1411 |
2484270 | 2484270 | 2022-05-08 | Sedgwick | Kansas | 20173 | 145185 | 1411 |
2487528 | 2487528 | 2022-05-09 | Sedgwick | Kansas | 20173 | 145185 | 1411 |
2490785 | 2490785 | 2022-05-10 | Sedgwick | Kansas | 20173 | 145185 | 1424 |
2494043 | 2494043 | 2022-05-11 | Sedgwick | Kansas | 20173 | 145185 | 1424 |
2497301 | 2497301 | 2022-05-12 | Sedgwick | Kansas | 20173 | 145185 | 1424 |
2357263 | 2357263 | 2022-03-30 | Johnson | Kansas | 20091 | 145130 | 1198 |
2360517 | 2360517 | 2022-03-31 | Johnson | Kansas | 20091 | 145130 | 1198 |
2350758 | 2350758 | 2022-03-28 | Johnson | Kansas | 20091 | 145027 | 1196 |
2354010 | 2354010 | 2022-03-29 | Johnson | Kansas | 20091 | 145027 | 1196 |
2340999 | 2340999 | 2022-03-25 | Johnson | Kansas | 20091 | 144986 | 1195 |
2344252 | 2344252 | 2022-03-26 | Johnson | Kansas | 20091 | 144986 | 1195 |
2347505 | 2347505 | 2022-03-27 | Johnson | Kansas | 20091 | 144986 | 1195 |
2454960 | 2454960 | 2022-04-29 | Sedgwick | Kansas | 20173 | 144967 | 1399 |
2458216 | 2458216 | 2022-04-30 | Sedgwick | Kansas | 20173 | 144967 | 1399 |
2461472 | 2461472 | 2022-05-01 | Sedgwick | Kansas | 20173 | 144967 | 1399 |
2464728 | 2464728 | 2022-05-02 | Sedgwick | Kansas | 20173 | 144967 | 1399 |
2467983 | 2467983 | 2022-05-03 | Sedgwick | Kansas | 20173 | 144967 | 1411 |
2471239 | 2471239 | 2022-05-04 | Sedgwick | Kansas | 20173 | 144967 | 1411 |
2474496 | 2474496 | 2022-05-05 | Sedgwick | Kansas | 20173 | 144967 | 1411 |
2334492 | 2334492 | 2022-03-23 | Johnson | Kansas | 20091 | 144965 | 1193 |
2337746 | 2337746 | 2022-03-24 | Johnson | Kansas | 20091 | 144965 | 1193 |
2327986 | 2327986 | 2022-03-21 | Johnson | Kansas | 20091 | 144867 | 1190 |
2331238 | 2331238 | 2022-03-22 | Johnson | Kansas | 20091 | 144867 | 1190 |
2318225 | 2318225 | 2022-03-18 | Johnson | Kansas | 20091 | 144826 | 1187 |
2321479 | 2321479 | 2022-03-19 | Johnson | Kansas | 20091 | 144826 | 1187 |
2324733 | 2324733 | 2022-03-20 | Johnson | Kansas | 20091 | 144826 | 1187 |
2311719 | 2311719 | 2022-03-16 | Johnson | Kansas | 20091 | 144783 | 1185 |
2314972 | 2314972 | 2022-03-17 | Johnson | Kansas | 20091 | 144783 | 1185 |
2432168 | 2432168 | 2022-04-22 | Sedgwick | Kansas | 20173 | 144742 | 1387 |
2435424 | 2435424 | 2022-04-23 | Sedgwick | Kansas | 20173 | 144742 | 1387 |
2438680 | 2438680 | 2022-04-24 | Sedgwick | Kansas | 20173 | 144742 | 1387 |
2441936 | 2441936 | 2022-04-25 | Sedgwick | Kansas | 20173 | 144742 | 1387 |
2445192 | 2445192 | 2022-04-26 | Sedgwick | Kansas | 20173 | 144742 | 1387 |
2448448 | 2448448 | 2022-04-27 | Sedgwick | Kansas | 20173 | 144742 | 1399 |
2451704 | 2451704 | 2022-04-28 | Sedgwick | Kansas | 20173 | 144742 | 1399 |
2305215 | 2305215 | 2022-03-14 | Johnson | Kansas | 20091 | 144708 | 1182 |
2308466 | 2308466 | 2022-03-15 | Johnson | Kansas | 20091 | 144708 | 1181 |
2295459 | 2295459 | 2022-03-11 | Johnson | Kansas | 20091 | 144643 | 1182 |
2298711 | 2298711 | 2022-03-12 | Johnson | Kansas | 20091 | 144643 | 1182 |
2301963 | 2301963 | 2022-03-13 | Johnson | Kansas | 20091 | 144643 | 1182 |
2409376 | 2409376 | 2022-04-15 | Sedgwick | Kansas | 20173 | 144623 | 1360 |
2412632 | 2412632 | 2022-04-16 | Sedgwick | Kansas | 20173 | 144623 | 1360 |
2415888 | 2415888 | 2022-04-17 | Sedgwick | Kansas | 20173 | 144623 | 1360 |
2419144 | 2419144 | 2022-04-18 | Sedgwick | Kansas | 20173 | 144623 | 1360 |
2422400 | 2422400 | 2022-04-19 | Sedgwick | Kansas | 20173 | 144623 | 1360 |
2425656 | 2425656 | 2022-04-20 | Sedgwick | Kansas | 20173 | 144623 | 1387 |
2428912 | 2428912 | 2022-04-21 | Sedgwick | Kansas | 20173 | 144623 | 1387 |
2386587 | 2386587 | 2022-04-08 | Sedgwick | Kansas | 20173 | 144551 | 1360 |
2389843 | 2389843 | 2022-04-09 | Sedgwick | Kansas | 20173 | 144551 | 1360 |
2393099 | 2393099 | 2022-04-10 | Sedgwick | Kansas | 20173 | 144551 | 1360 |
2396354 | 2396354 | 2022-04-11 | Sedgwick | Kansas | 20173 | 144551 | 1360 |
2399610 | 2399610 | 2022-04-12 | Sedgwick | Kansas | 20173 | 144551 | 1360 |
2402864 | 2402864 | 2022-04-13 | Sedgwick | Kansas | 20173 | 144551 | 1360 |
2406120 | 2406120 | 2022-04-14 | Sedgwick | Kansas | 20173 | 144551 | 1360 |
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);