ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 136 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921356 | 921356 | 2021-01-12 | Elk | Kansas | 20049 | 136 | 0 |
918111 | 918111 | 2021-01-11 | Elk | Kansas | 20049 | 136 | 0 |
914866 | 914866 | 2021-01-10 | Elk | Kansas | 20049 | 136 | 0 |
911621 | 911621 | 2021-01-09 | Elk | Kansas | 20049 | 136 | 0 |
908376 | 908376 | 2021-01-08 | Elk | Kansas | 20049 | 136 | 0 |
762343 | 762343 | 2020-11-24 | Graham | Kansas | 20065 | 136 | 2 |
759098 | 759098 | 2020-11-23 | Graham | Kansas | 20065 | 136 | 2 |
720201 | 720201 | 2020-11-11 | Republic | Kansas | 20157 | 136 | 1 |
648810 | 648810 | 2020-10-20 | Kearny | Kansas | 20093 | 136 | 3 |
645565 | 645565 | 2020-10-19 | Kearny | Kansas | 20093 | 136 | 3 |
632564 | 632564 | 2020-10-15 | Gove | Kansas | 20063 | 136 | 2 |
629320 | 629320 | 2020-10-14 | Gove | Kansas | 20063 | 136 | 2 |
626077 | 626077 | 2020-10-13 | Gove | Kansas | 20063 | 136 | 2 |
622835 | 622835 | 2020-10-12 | Gove | Kansas | 20063 | 136 | 2 |
619575 | 619575 | 2020-10-11 | Coffey | Kansas | 20031 | 136 | 9 |
616333 | 616333 | 2020-10-10 | Coffey | Kansas | 20031 | 136 | 9 |
613092 | 613092 | 2020-10-09 | Coffey | Kansas | 20031 | 136 | 9 |
603390 | 603390 | 2020-10-06 | Haskell | Kansas | 20081 | 136 | 1 |
603423 | 603423 | 2020-10-06 | Phillips | Kansas | 20147 | 136 | 8 |
600147 | 600147 | 2020-10-05 | Haskell | Kansas | 20081 | 136 | 1 |
600192 | 600192 | 2020-10-05 | Scott | Kansas | 20171 | 136 | 1 |
596930 | 596930 | 2020-10-04 | Nemaha | Kansas | 20131 | 136 | 1 |
593688 | 593688 | 2020-10-03 | Nemaha | Kansas | 20131 | 136 | 1 |
590447 | 590447 | 2020-10-02 | Nemaha | Kansas | 20131 | 136 | 1 |
587200 | 587200 | 2020-10-01 | Meade | Kansas | 20119 | 136 | 1 |
583960 | 583960 | 2020-09-30 | Meade | Kansas | 20119 | 136 | 1 |
580721 | 580721 | 2020-09-29 | Meade | Kansas | 20119 | 136 | 1 |
577480 | 577480 | 2020-09-28 | Meade | Kansas | 20119 | 136 | 1 |
451297 | 451297 | 2020-08-20 | Grant | Kansas | 20067 | 136 | 3 |
415849 | 415849 | 2020-08-09 | Miami | Kansas | 20121 | 136 | 0 |
412629 | 412629 | 2020-08-08 | Miami | Kansas | 20121 | 136 | 0 |
409409 | 409409 | 2020-08-07 | Miami | Kansas | 20121 | 136 | 0 |
377220 | 377220 | 2020-07-28 | Jackson | Kansas | 20085 | 136 | 1 |
374005 | 374005 | 2020-07-27 | Jackson | Kansas | 20085 | 136 | 1 |
76532 | 76532 | 2020-04-21 | Leavenworth | Kansas | 20103 | 136 | 3 |
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);