ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
987 rows where deaths = 20 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Allen 100
- Rooks 99
- Kearny 87
- Gove 82
- Thomas 80
- Washington 70
- Meade 57
- Decatur 52
- Sherman 52
- Jackson 49
- Stevens 45
- Greenwood 28
- Pawnee 21
- Anderson 19
- Kingman 18
- Morris 16
- Finney 13
- Riley 12
- Atchison 9
- Sedgwick 9
- Douglas 7
- Gray 7
- Seward 7
- Wilson 7
- Franklin 5
- Russell 5
- Saline 5
- Wabaunsee 5
- Dickinson 3
- Norton 3
- …
state 1
- Kansas · 987 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500492 | 2500492 | 2022-05-13 | Decatur | Kansas | 20039 | 620 | 20 |
2500519 | 2500519 | 2022-05-13 | Kearny | Kansas | 20093 | 1236 | 20 |
2500532 | 2500532 | 2022-05-13 | Meade | Kansas | 20119 | 1221 | 20 |
2500554 | 2500554 | 2022-05-13 | Rooks | Kansas | 20163 | 1377 | 20 |
2500563 | 2500563 | 2022-05-13 | Sherman | Kansas | 20181 | 1514 | 20 |
2500567 | 2500567 | 2022-05-13 | Stevens | Kansas | 20189 | 1465 | 20 |
2497234 | 2497234 | 2022-05-12 | Decatur | Kansas | 20039 | 619 | 20 |
2497261 | 2497261 | 2022-05-12 | Kearny | Kansas | 20093 | 1236 | 20 |
2497274 | 2497274 | 2022-05-12 | Meade | Kansas | 20119 | 1220 | 20 |
2497296 | 2497296 | 2022-05-12 | Rooks | Kansas | 20163 | 1373 | 20 |
2497305 | 2497305 | 2022-05-12 | Sherman | Kansas | 20181 | 1513 | 20 |
2497309 | 2497309 | 2022-05-12 | Stevens | Kansas | 20189 | 1464 | 20 |
2493976 | 2493976 | 2022-05-11 | Decatur | Kansas | 20039 | 619 | 20 |
2494003 | 2494003 | 2022-05-11 | Kearny | Kansas | 20093 | 1236 | 20 |
2494016 | 2494016 | 2022-05-11 | Meade | Kansas | 20119 | 1220 | 20 |
2494038 | 2494038 | 2022-05-11 | Rooks | Kansas | 20163 | 1373 | 20 |
2494047 | 2494047 | 2022-05-11 | Sherman | Kansas | 20181 | 1513 | 20 |
2494051 | 2494051 | 2022-05-11 | Stevens | Kansas | 20189 | 1464 | 20 |
2490718 | 2490718 | 2022-05-10 | Decatur | Kansas | 20039 | 619 | 20 |
2490745 | 2490745 | 2022-05-10 | Kearny | Kansas | 20093 | 1236 | 20 |
2490758 | 2490758 | 2022-05-10 | Meade | Kansas | 20119 | 1220 | 20 |
2490780 | 2490780 | 2022-05-10 | Rooks | Kansas | 20163 | 1373 | 20 |
2490789 | 2490789 | 2022-05-10 | Sherman | Kansas | 20181 | 1513 | 20 |
2490793 | 2490793 | 2022-05-10 | Stevens | Kansas | 20189 | 1464 | 20 |
2487461 | 2487461 | 2022-05-09 | Decatur | Kansas | 20039 | 619 | 20 |
2487488 | 2487488 | 2022-05-09 | Kearny | Kansas | 20093 | 1236 | 20 |
2487501 | 2487501 | 2022-05-09 | Meade | Kansas | 20119 | 1220 | 20 |
2487523 | 2487523 | 2022-05-09 | Rooks | Kansas | 20163 | 1373 | 20 |
2487532 | 2487532 | 2022-05-09 | Sherman | Kansas | 20181 | 1513 | 20 |
2487536 | 2487536 | 2022-05-09 | Stevens | Kansas | 20189 | 1464 | 20 |
2484203 | 2484203 | 2022-05-08 | Decatur | Kansas | 20039 | 619 | 20 |
2484230 | 2484230 | 2022-05-08 | Kearny | Kansas | 20093 | 1236 | 20 |
2484243 | 2484243 | 2022-05-08 | Meade | Kansas | 20119 | 1220 | 20 |
2484265 | 2484265 | 2022-05-08 | Rooks | Kansas | 20163 | 1373 | 20 |
2484274 | 2484274 | 2022-05-08 | Sherman | Kansas | 20181 | 1513 | 20 |
2484278 | 2484278 | 2022-05-08 | Stevens | Kansas | 20189 | 1464 | 20 |
2480945 | 2480945 | 2022-05-07 | Decatur | Kansas | 20039 | 619 | 20 |
2480972 | 2480972 | 2022-05-07 | Kearny | Kansas | 20093 | 1236 | 20 |
2480985 | 2480985 | 2022-05-07 | Meade | Kansas | 20119 | 1220 | 20 |
2481007 | 2481007 | 2022-05-07 | Rooks | Kansas | 20163 | 1373 | 20 |
2481016 | 2481016 | 2022-05-07 | Sherman | Kansas | 20181 | 1513 | 20 |
2481020 | 2481020 | 2022-05-07 | Stevens | Kansas | 20189 | 1464 | 20 |
2477687 | 2477687 | 2022-05-06 | Decatur | Kansas | 20039 | 619 | 20 |
2477714 | 2477714 | 2022-05-06 | Kearny | Kansas | 20093 | 1236 | 20 |
2477727 | 2477727 | 2022-05-06 | Meade | Kansas | 20119 | 1220 | 20 |
2477749 | 2477749 | 2022-05-06 | Rooks | Kansas | 20163 | 1373 | 20 |
2477758 | 2477758 | 2022-05-06 | Sherman | Kansas | 20181 | 1513 | 20 |
2477762 | 2477762 | 2022-05-06 | Stevens | Kansas | 20189 | 1464 | 20 |
2474429 | 2474429 | 2022-05-05 | Decatur | Kansas | 20039 | 616 | 20 |
2474456 | 2474456 | 2022-05-05 | Kearny | Kansas | 20093 | 1236 | 20 |
2474469 | 2474469 | 2022-05-05 | Meade | Kansas | 20119 | 1220 | 20 |
2474491 | 2474491 | 2022-05-05 | Rooks | Kansas | 20163 | 1371 | 20 |
2474500 | 2474500 | 2022-05-05 | Sherman | Kansas | 20181 | 1511 | 20 |
2474504 | 2474504 | 2022-05-05 | Stevens | Kansas | 20189 | 1464 | 20 |
2471172 | 2471172 | 2022-05-04 | Decatur | Kansas | 20039 | 616 | 20 |
2471199 | 2471199 | 2022-05-04 | Kearny | Kansas | 20093 | 1236 | 20 |
2471212 | 2471212 | 2022-05-04 | Meade | Kansas | 20119 | 1220 | 20 |
2471234 | 2471234 | 2022-05-04 | Rooks | Kansas | 20163 | 1371 | 20 |
2471243 | 2471243 | 2022-05-04 | Sherman | Kansas | 20181 | 1511 | 20 |
2471247 | 2471247 | 2022-05-04 | Stevens | Kansas | 20189 | 1464 | 20 |
2467916 | 2467916 | 2022-05-03 | Decatur | Kansas | 20039 | 616 | 20 |
2467943 | 2467943 | 2022-05-03 | Kearny | Kansas | 20093 | 1236 | 20 |
2467956 | 2467956 | 2022-05-03 | Meade | Kansas | 20119 | 1220 | 20 |
2467978 | 2467978 | 2022-05-03 | Rooks | Kansas | 20163 | 1371 | 20 |
2467987 | 2467987 | 2022-05-03 | Sherman | Kansas | 20181 | 1511 | 20 |
2467991 | 2467991 | 2022-05-03 | Stevens | Kansas | 20189 | 1464 | 20 |
2464661 | 2464661 | 2022-05-02 | Decatur | Kansas | 20039 | 616 | 20 |
2464688 | 2464688 | 2022-05-02 | Kearny | Kansas | 20093 | 1236 | 20 |
2464701 | 2464701 | 2022-05-02 | Meade | Kansas | 20119 | 1220 | 20 |
2464723 | 2464723 | 2022-05-02 | Rooks | Kansas | 20163 | 1371 | 20 |
2464732 | 2464732 | 2022-05-02 | Sherman | Kansas | 20181 | 1511 | 20 |
2464736 | 2464736 | 2022-05-02 | Stevens | Kansas | 20189 | 1464 | 20 |
2461405 | 2461405 | 2022-05-01 | Decatur | Kansas | 20039 | 616 | 20 |
2461432 | 2461432 | 2022-05-01 | Kearny | Kansas | 20093 | 1236 | 20 |
2461445 | 2461445 | 2022-05-01 | Meade | Kansas | 20119 | 1220 | 20 |
2461467 | 2461467 | 2022-05-01 | Rooks | Kansas | 20163 | 1371 | 20 |
2461476 | 2461476 | 2022-05-01 | Sherman | Kansas | 20181 | 1511 | 20 |
2461480 | 2461480 | 2022-05-01 | Stevens | Kansas | 20189 | 1464 | 20 |
2458149 | 2458149 | 2022-04-30 | Decatur | Kansas | 20039 | 616 | 20 |
2458176 | 2458176 | 2022-04-30 | Kearny | Kansas | 20093 | 1236 | 20 |
2458189 | 2458189 | 2022-04-30 | Meade | Kansas | 20119 | 1220 | 20 |
2458211 | 2458211 | 2022-04-30 | Rooks | Kansas | 20163 | 1371 | 20 |
2458220 | 2458220 | 2022-04-30 | Sherman | Kansas | 20181 | 1511 | 20 |
2458224 | 2458224 | 2022-04-30 | Stevens | Kansas | 20189 | 1464 | 20 |
2454893 | 2454893 | 2022-04-29 | Decatur | Kansas | 20039 | 616 | 20 |
2454920 | 2454920 | 2022-04-29 | Kearny | Kansas | 20093 | 1236 | 20 |
2454933 | 2454933 | 2022-04-29 | Meade | Kansas | 20119 | 1220 | 20 |
2454955 | 2454955 | 2022-04-29 | Rooks | Kansas | 20163 | 1371 | 20 |
2454964 | 2454964 | 2022-04-29 | Sherman | Kansas | 20181 | 1511 | 20 |
2454968 | 2454968 | 2022-04-29 | Stevens | Kansas | 20189 | 1464 | 20 |
2451637 | 2451637 | 2022-04-28 | Decatur | Kansas | 20039 | 616 | 20 |
2451664 | 2451664 | 2022-04-28 | Kearny | Kansas | 20093 | 1235 | 20 |
2451677 | 2451677 | 2022-04-28 | Meade | Kansas | 20119 | 1220 | 20 |
2451699 | 2451699 | 2022-04-28 | Rooks | Kansas | 20163 | 1371 | 20 |
2451708 | 2451708 | 2022-04-28 | Sherman | Kansas | 20181 | 1508 | 20 |
2451712 | 2451712 | 2022-04-28 | Stevens | Kansas | 20189 | 1463 | 20 |
2448381 | 2448381 | 2022-04-27 | Decatur | Kansas | 20039 | 616 | 20 |
2448408 | 2448408 | 2022-04-27 | Kearny | Kansas | 20093 | 1235 | 20 |
2448421 | 2448421 | 2022-04-27 | Meade | Kansas | 20119 | 1220 | 20 |
2448443 | 2448443 | 2022-04-27 | Rooks | Kansas | 20163 | 1371 | 20 |
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);