ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where cases = 80 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
768811 | 768811 | 2020-11-26 | Chautauqua | Kansas | 20019 | 80 | 1 |
765565 | 765565 | 2020-11-25 | Chautauqua | Kansas | 20019 | 80 | 1 |
733188 | 733188 | 2020-11-15 | Smith | Kansas | 20183 | 80 | 0 |
729943 | 729943 | 2020-11-14 | Smith | Kansas | 20183 | 80 | 0 |
723403 | 723403 | 2020-11-12 | Hamilton | Kansas | 20075 | 80 | 0 |
720160 | 720160 | 2020-11-11 | Hamilton | Kansas | 20075 | 80 | 0 |
710404 | 710404 | 2020-11-08 | Clark | Kansas | 20025 | 80 | 4 |
707160 | 707160 | 2020-11-07 | Clark | Kansas | 20025 | 80 | 4 |
703917 | 703917 | 2020-11-06 | Clark | Kansas | 20025 | 80 | 4 |
655272 | 655272 | 2020-10-22 | Decatur | Kansas | 20039 | 80 | 1 |
652027 | 652027 | 2020-10-21 | Decatur | Kansas | 20039 | 80 | 1 |
648800 | 648800 | 2020-10-20 | Greenwood | Kansas | 20073 | 80 | 0 |
642365 | 642365 | 2020-10-18 | Stanton | Kansas | 20187 | 80 | 2 |
639118 | 639118 | 2020-10-17 | Stanton | Kansas | 20187 | 80 | 2 |
635872 | 635872 | 2020-10-16 | Stanton | Kansas | 20187 | 80 | 2 |
580715 | 580715 | 2020-09-29 | Linn | Kansas | 20107 | 80 | 0 |
577474 | 577474 | 2020-09-28 | Linn | Kansas | 20107 | 80 | 0 |
535362 | 535362 | 2020-09-15 | Kearny | Kansas | 20093 | 80 | 1 |
532127 | 532127 | 2020-09-14 | Kearny | Kansas | 20093 | 80 | 1 |
528890 | 528890 | 2020-09-13 | Kearny | Kansas | 20093 | 80 | 1 |
525654 | 525654 | 2020-09-12 | Kearny | Kansas | 20093 | 80 | 1 |
522418 | 522418 | 2020-09-11 | Kearny | Kansas | 20093 | 80 | 1 |
519141 | 519141 | 2020-09-10 | Brown | Kansas | 20013 | 80 | 3 |
519156 | 519156 | 2020-09-10 | Doniphan | Kansas | 20043 | 80 | 0 |
519181 | 519181 | 2020-09-10 | Kearny | Kansas | 20093 | 80 | 1 |
515906 | 515906 | 2020-09-09 | Brown | Kansas | 20013 | 80 | 3 |
515921 | 515921 | 2020-09-09 | Doniphan | Kansas | 20043 | 80 | 0 |
515946 | 515946 | 2020-09-09 | Kearny | Kansas | 20093 | 80 | 1 |
512673 | 512673 | 2020-09-08 | Brown | Kansas | 20013 | 80 | 3 |
512687 | 512687 | 2020-09-08 | Dickinson | Kansas | 20041 | 80 | 1 |
512688 | 512688 | 2020-09-08 | Doniphan | Kansas | 20043 | 80 | 0 |
512713 | 512713 | 2020-09-08 | Kearny | Kansas | 20093 | 80 | 1 |
509440 | 509440 | 2020-09-07 | Brown | Kansas | 20013 | 80 | 3 |
509454 | 509454 | 2020-09-07 | Dickinson | Kansas | 20041 | 80 | 1 |
509455 | 509455 | 2020-09-07 | Doniphan | Kansas | 20043 | 80 | 0 |
509480 | 509480 | 2020-09-07 | Kearny | Kansas | 20093 | 80 | 1 |
506208 | 506208 | 2020-09-06 | Brown | Kansas | 20013 | 80 | 3 |
502974 | 502974 | 2020-09-05 | Brown | Kansas | 20013 | 80 | 3 |
499740 | 499740 | 2020-09-04 | Brown | Kansas | 20013 | 80 | 3 |
415832 | 415832 | 2020-08-09 | Jefferson | Kansas | 20087 | 80 | 0 |
412612 | 412612 | 2020-08-08 | Jefferson | Kansas | 20087 | 80 | 0 |
409392 | 409392 | 2020-08-07 | Jefferson | Kansas | 20087 | 80 | 0 |
348343 | 348343 | 2020-07-19 | Ellis | Kansas | 20051 | 80 | 1 |
345142 | 345142 | 2020-07-18 | Ellis | Kansas | 20051 | 80 | 1 |
341942 | 341942 | 2020-07-17 | Ellis | Kansas | 20051 | 80 | 1 |
244192 | 244192 | 2020-06-16 | Riley | Kansas | 20161 | 80 | 3 |
241081 | 241081 | 2020-06-15 | Riley | Kansas | 20161 | 80 | 3 |
57330 | 57330 | 2020-04-14 | Shawnee | Kansas | 20177 | 80 | 5 |
51929 | 51929 | 2020-04-12 | Leavenworth | Kansas | 20103 | 80 | 1 |
16399 | 16399 | 2020-03-28 | Johnson | Kansas | 20091 | 80 | 2 |
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);