ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where deaths = 6, fips = 20099 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
827266 | 827266 | 2020-12-14 | Labette | Kansas | 20099 | 1328 | 6 |
824019 | 824019 | 2020-12-13 | Labette | Kansas | 20099 | 1246 | 6 |
820773 | 820773 | 2020-12-12 | Labette | Kansas | 20099 | 1246 | 6 |
817527 | 817527 | 2020-12-11 | Labette | Kansas | 20099 | 1246 | 6 |
814281 | 814281 | 2020-12-10 | Labette | Kansas | 20099 | 1154 | 6 |
811036 | 811036 | 2020-12-09 | Labette | Kansas | 20099 | 1154 | 6 |
807791 | 807791 | 2020-12-08 | Labette | Kansas | 20099 | 1046 | 6 |
804546 | 804546 | 2020-12-07 | Labette | Kansas | 20099 | 1046 | 6 |
801301 | 801301 | 2020-12-06 | Labette | Kansas | 20099 | 999 | 6 |
798056 | 798056 | 2020-12-05 | Labette | Kansas | 20099 | 999 | 6 |
794811 | 794811 | 2020-12-04 | Labette | Kansas | 20099 | 999 | 6 |
791566 | 791566 | 2020-12-03 | Labette | Kansas | 20099 | 948 | 6 |
788321 | 788321 | 2020-12-02 | Labette | Kansas | 20099 | 948 | 6 |
785077 | 785077 | 2020-12-01 | Labette | Kansas | 20099 | 875 | 6 |
781832 | 781832 | 2020-11-30 | Labette | Kansas | 20099 | 875 | 6 |
778586 | 778586 | 2020-11-29 | Labette | Kansas | 20099 | 847 | 6 |
775341 | 775341 | 2020-11-28 | Labette | Kansas | 20099 | 847 | 6 |
772096 | 772096 | 2020-11-27 | Labette | Kansas | 20099 | 847 | 6 |
768851 | 768851 | 2020-11-26 | Labette | Kansas | 20099 | 818 | 6 |
765605 | 765605 | 2020-11-25 | Labette | Kansas | 20099 | 818 | 6 |
762360 | 762360 | 2020-11-24 | Labette | Kansas | 20099 | 785 | 6 |
759115 | 759115 | 2020-11-23 | Labette | Kansas | 20099 | 785 | 6 |
755868 | 755868 | 2020-11-22 | Labette | Kansas | 20099 | 734 | 6 |
752622 | 752622 | 2020-11-21 | Labette | Kansas | 20099 | 734 | 6 |
749376 | 749376 | 2020-11-20 | Labette | Kansas | 20099 | 734 | 6 |
746130 | 746130 | 2020-11-19 | Labette | Kansas | 20099 | 721 | 6 |
742883 | 742883 | 2020-11-18 | Labette | Kansas | 20099 | 721 | 6 |
739636 | 739636 | 2020-11-17 | Labette | Kansas | 20099 | 672 | 6 |
736392 | 736392 | 2020-11-16 | Labette | Kansas | 20099 | 672 | 6 |
733146 | 733146 | 2020-11-15 | Labette | Kansas | 20099 | 615 | 6 |
729901 | 729901 | 2020-11-14 | Labette | Kansas | 20099 | 615 | 6 |
726658 | 726658 | 2020-11-13 | Labette | Kansas | 20099 | 615 | 6 |
723415 | 723415 | 2020-11-12 | Labette | Kansas | 20099 | 544 | 6 |
720172 | 720172 | 2020-11-11 | Labette | Kansas | 20099 | 544 | 6 |
716929 | 716929 | 2020-11-10 | Labette | Kansas | 20099 | 499 | 6 |
713685 | 713685 | 2020-11-09 | Labette | Kansas | 20099 | 499 | 6 |
710441 | 710441 | 2020-11-08 | Labette | Kansas | 20099 | 461 | 6 |
707197 | 707197 | 2020-11-07 | Labette | Kansas | 20099 | 461 | 6 |
703954 | 703954 | 2020-11-06 | Labette | Kansas | 20099 | 461 | 6 |
700712 | 700712 | 2020-11-05 | Labette | Kansas | 20099 | 443 | 6 |
697468 | 697468 | 2020-11-04 | Labette | Kansas | 20099 | 443 | 6 |
694226 | 694226 | 2020-11-03 | Labette | Kansas | 20099 | 432 | 6 |
690983 | 690983 | 2020-11-02 | Labette | Kansas | 20099 | 426 | 6 |
687738 | 687738 | 2020-11-01 | Labette | Kansas | 20099 | 414 | 6 |
684494 | 684494 | 2020-10-31 | Labette | Kansas | 20099 | 414 | 6 |
681251 | 681251 | 2020-10-30 | Labette | Kansas | 20099 | 414 | 6 |
678008 | 678008 | 2020-10-29 | Labette | Kansas | 20099 | 397 | 6 |
674765 | 674765 | 2020-10-28 | Labette | Kansas | 20099 | 397 | 6 |
671523 | 671523 | 2020-10-27 | Labette | Kansas | 20099 | 384 | 6 |
668280 | 668280 | 2020-10-26 | Labette | Kansas | 20099 | 384 | 6 |
665036 | 665036 | 2020-10-25 | Labette | Kansas | 20099 | 377 | 6 |
661791 | 661791 | 2020-10-24 | Labette | Kansas | 20099 | 377 | 6 |
658547 | 658547 | 2020-10-23 | Labette | Kansas | 20099 | 377 | 6 |
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);