ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 110 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
804541 | 804541 | 2020-12-07 | Jewell | Kansas | 20089 | 110 | 1 |
801296 | 801296 | 2020-12-06 | Jewell | Kansas | 20089 | 110 | 1 |
798051 | 798051 | 2020-12-05 | Jewell | Kansas | 20089 | 110 | 1 |
794806 | 794806 | 2020-12-04 | Jewell | Kansas | 20089 | 110 | 1 |
791561 | 791561 | 2020-12-03 | Jewell | Kansas | 20089 | 110 | 1 |
788316 | 788316 | 2020-12-02 | Jewell | Kansas | 20089 | 110 | 1 |
785072 | 785072 | 2020-12-01 | Jewell | Kansas | 20089 | 110 | 1 |
710485 | 710485 | 2020-11-08 | Stanton | Kansas | 20187 | 110 | 2 |
707241 | 707241 | 2020-11-07 | Stanton | Kansas | 20187 | 110 | 2 |
703998 | 703998 | 2020-11-06 | Stanton | Kansas | 20187 | 110 | 2 |
694259 | 694259 | 2020-11-03 | Rush | Kansas | 20165 | 110 | 0 |
691016 | 691016 | 2020-11-02 | Rush | Kansas | 20165 | 110 | 0 |
619650 | 619650 | 2020-10-11 | Sherman | Kansas | 20181 | 110 | 0 |
616364 | 616364 | 2020-10-10 | Kearny | Kansas | 20093 | 110 | 1 |
616408 | 616408 | 2020-10-10 | Sherman | Kansas | 20181 | 110 | 0 |
613123 | 613123 | 2020-10-09 | Kearny | Kansas | 20093 | 110 | 1 |
603406 | 603406 | 2020-10-06 | Marion | Kansas | 20115 | 110 | 1 |
600163 | 600163 | 2020-10-05 | Marion | Kansas | 20115 | 110 | 1 |
558051 | 558051 | 2020-09-22 | Phillips | Kansas | 20147 | 110 | 8 |
541883 | 541883 | 2020-09-17 | Stevens | Kansas | 20189 | 110 | 1 |
512672 | 512672 | 2020-09-08 | Bourbon | Kansas | 20011 | 110 | 2 |
509439 | 509439 | 2020-09-07 | Bourbon | Kansas | 20011 | 110 | 2 |
483604 | 483604 | 2020-08-30 | Harper | Kansas | 20077 | 110 | 0 |
480370 | 480370 | 2020-08-29 | Harper | Kansas | 20077 | 110 | 0 |
477137 | 477137 | 2020-08-28 | Harper | Kansas | 20077 | 110 | 0 |
461041 | 461041 | 2020-08-23 | Sumner | Kansas | 20191 | 110 | 3 |
457814 | 457814 | 2020-08-22 | Sumner | Kansas | 20191 | 110 | 3 |
454586 | 454586 | 2020-08-21 | Sumner | Kansas | 20191 | 110 | 3 |
412602 | 412602 | 2020-08-08 | Grant | Kansas | 20067 | 110 | 2 |
409382 | 409382 | 2020-08-07 | Grant | Kansas | 20067 | 110 | 2 |
399744 | 399744 | 2020-08-04 | Labette | Kansas | 20099 | 110 | 0 |
396529 | 396529 | 2020-08-03 | Labette | Kansas | 20099 | 110 | 0 |
377227 | 377227 | 2020-07-28 | Labette | Kansas | 20099 | 110 | 0 |
374012 | 374012 | 2020-07-27 | Labette | Kansas | 20099 | 110 | 0 |
294342 | 294342 | 2020-07-02 | Saline | Kansas | 20169 | 110 | 2 |
291188 | 291188 | 2020-07-01 | Saline | Kansas | 20169 | 110 | 2 |
288038 | 288038 | 2020-06-30 | Saline | Kansas | 20169 | 110 | 2 |
284889 | 284889 | 2020-06-29 | Saline | Kansas | 20169 | 110 | 2 |
79319 | 79319 | 2020-04-22 | Lyon | Kansas | 20111 | 110 | 1 |
76534 | 76534 | 2020-04-21 | Lyon | Kansas | 20111 | 110 | 1 |
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);