ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79,294 rows where state = "Kansas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 20091 798
- 20209 793
- 20015 792
- 20059 791
- 20045 788
- 20057 788
- 20103 787
- 20021 786
- 20107 786
- 20127 786
- 20173 786
- 20155 785
- 20161 785
- 20085 783
- 20123 783
- 20011 782
- 20111 782
- 20043 781
- 20149 781
- 20207 781
- 20037 780
- 20133 780
- 20177 780
- 20087 779
- 20191 779
- 20027 778
- 20031 778
- 20063 778
- 20079 778
- 20113 778
- …
county >30
- Johnson 798
- Wyandotte 793
- Butler 792
- Franklin 791
- Douglas 788
- Ford 788
- Leavenworth 787
- Cherokee 786
- Linn 786
- Morris 786
- Sedgwick 786
- Reno 785
- Riley 785
- Jackson 783
- Mitchell 783
- Bourbon 782
- Lyon 782
- Doniphan 781
- Pottawatomie 781
- Woodson 781
- Crawford 780
- Neosho 780
- Shawnee 780
- Jefferson 779
- Sumner 779
- Clay 778
- Coffey 778
- Gove 778
- Harvey 778
- McPherson 778
- …
state 1
- Kansas · 79,294 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
41473 | 41473 | 2020-04-08 | Unknown | Kansas | 0 | 2 | |
46656 | 46656 | 2020-04-10 | Unknown | Kansas | 0 | 4 | |
49293 | 49293 | 2020-04-11 | Unknown | Kansas | 0 | 4 | |
51959 | 51959 | 2020-04-12 | Unknown | Kansas | 0 | 3 | |
57335 | 57335 | 2020-04-14 | Unknown | Kansas | 0 | 2 | |
60044 | 60044 | 2020-04-15 | Unknown | Kansas | 0 | 2 | |
65502 | 65502 | 2020-04-17 | Unknown | Kansas | 0 | 1 | |
68251 | 68251 | 2020-04-18 | Unknown | Kansas | 0 | 1 | |
197804 | 197804 | 2020-06-01 | Unknown | Kansas | 0 | 5 | |
231774 | 231774 | 2020-06-12 | Unknown | Kansas | 0 | 1 | |
262921 | 262921 | 2020-06-22 | Unknown | Kansas | 0 | 1 | |
269181 | 269181 | 2020-06-24 | Unknown | Kansas | 0 | 1 | |
409446 | 409446 | 2020-08-07 | Unknown | Kansas | 0 | 3 | |
412666 | 412666 | 2020-08-08 | Unknown | Kansas | 0 | 2 | |
415886 | 415886 | 2020-08-09 | Unknown | Kansas | 0 | 1 | |
419107 | 419107 | 2020-08-10 | Unknown | Kansas | 0 | 6 | |
493365 | 493365 | 2020-09-02 | Unknown | Kansas | 0 | 2 | |
499832 | 499832 | 2020-09-04 | Unknown | Kansas | 0 | 3 | |
509532 | 509532 | 2020-09-07 | Unknown | Kansas | 0 | 1 | |
538650 | 538650 | 2020-09-16 | Unknown | Kansas | 0 | 4 | |
583999 | 583999 | 2020-09-30 | Unknown | Kansas | 0 | 16 | |
587239 | 587239 | 2020-10-01 | Unknown | Kansas | 0 | 4 | |
590480 | 590480 | 2020-10-02 | Unknown | Kansas | 0 | 12 | |
593721 | 593721 | 2020-10-03 | Unknown | Kansas | 0 | 9 | |
596963 | 596963 | 2020-10-04 | Unknown | Kansas | 0 | 9 | |
600205 | 600205 | 2020-10-05 | Unknown | Kansas | 0 | 13 | |
603448 | 603448 | 2020-10-06 | Unknown | Kansas | 0 | 6 | |
606690 | 606690 | 2020-10-07 | Unknown | Kansas | 0 | 13 | |
629387 | 629387 | 2020-10-14 | Unknown | Kansas | 0 | 24 | |
632631 | 632631 | 2020-10-15 | Unknown | Kansas | 0 | 11 | |
635877 | 635877 | 2020-10-16 | Unknown | Kansas | 0 | 5 | |
639123 | 639123 | 2020-10-17 | Unknown | Kansas | 0 | 3 | |
642370 | 642370 | 2020-10-18 | Unknown | Kansas | 0 | 3 | |
645617 | 645617 | 2020-10-19 | Unknown | Kansas | 0 | 6 | |
652106 | 652106 | 2020-10-21 | Unknown | Kansas | 0 | 39 | |
655351 | 655351 | 2020-10-22 | Unknown | Kansas | 0 | 20 | |
658596 | 658596 | 2020-10-23 | Unknown | Kansas | 0 | 24 | |
661840 | 661840 | 2020-10-24 | Unknown | Kansas | 0 | 20 | |
665085 | 665085 | 2020-10-25 | Unknown | Kansas | 0 | 17 | |
668329 | 668329 | 2020-10-26 | Unknown | Kansas | 0 | 4 | |
674814 | 674814 | 2020-10-28 | Unknown | Kansas | 0 | 11 | |
681300 | 681300 | 2020-10-30 | Unknown | Kansas | 0 | 10 | |
684543 | 684543 | 2020-10-31 | Unknown | Kansas | 0 | 4 | |
687787 | 687787 | 2020-11-01 | Unknown | Kansas | 0 | 3 | |
691032 | 691032 | 2020-11-02 | Unknown | Kansas | 0 | 17 | |
697517 | 697517 | 2020-11-04 | Unknown | Kansas | 0 | 22 | |
700761 | 700761 | 2020-11-05 | Unknown | Kansas | 0 | 15 | |
704003 | 704003 | 2020-11-06 | Unknown | Kansas | 0 | 81 | |
707246 | 707246 | 2020-11-07 | Unknown | Kansas | 0 | 71 | |
710490 | 710490 | 2020-11-08 | Unknown | Kansas | 0 | 68 | |
713734 | 713734 | 2020-11-09 | Unknown | Kansas | 0 | 69 | |
716978 | 716978 | 2020-11-10 | Unknown | Kansas | 0 | 56 | |
720221 | 720221 | 2020-11-11 | Unknown | Kansas | 0 | 65 | |
723464 | 723464 | 2020-11-12 | Unknown | Kansas | 0 | 56 | |
726707 | 726707 | 2020-11-13 | Unknown | Kansas | 0 | 86 | |
729950 | 729950 | 2020-11-14 | Unknown | Kansas | 0 | 76 | |
733195 | 733195 | 2020-11-15 | Unknown | Kansas | 0 | 76 | |
736441 | 736441 | 2020-11-16 | Unknown | Kansas | 0 | 70 | |
739685 | 739685 | 2020-11-17 | Unknown | Kansas | 0 | 49 | |
742932 | 742932 | 2020-11-18 | Unknown | Kansas | 0 | 88 | |
746179 | 746179 | 2020-11-19 | Unknown | Kansas | 0 | 64 | |
749425 | 749425 | 2020-11-20 | Unknown | Kansas | 0 | 100 | |
752671 | 752671 | 2020-11-21 | Unknown | Kansas | 0 | 87 | |
755917 | 755917 | 2020-11-22 | Unknown | Kansas | 0 | 78 | |
759164 | 759164 | 2020-11-23 | Unknown | Kansas | 0 | 104 | |
762409 | 762409 | 2020-11-24 | Unknown | Kansas | 0 | 74 | |
765654 | 765654 | 2020-11-25 | Unknown | Kansas | 0 | 86 | |
768900 | 768900 | 2020-11-26 | Unknown | Kansas | 0 | 84 | |
772145 | 772145 | 2020-11-27 | Unknown | Kansas | 0 | 102 | |
775390 | 775390 | 2020-11-28 | Unknown | Kansas | 0 | 101 | |
778635 | 778635 | 2020-11-29 | Unknown | Kansas | 0 | 100 | |
781881 | 781881 | 2020-11-30 | Unknown | Kansas | 0 | 95 | |
785126 | 785126 | 2020-12-01 | Unknown | Kansas | 0 | 60 | |
788370 | 788370 | 2020-12-02 | Unknown | Kansas | 0 | 117 | |
791615 | 791615 | 2020-12-03 | Unknown | Kansas | 0 | 100 | |
794860 | 794860 | 2020-12-04 | Unknown | Kansas | 0 | 178 | |
798105 | 798105 | 2020-12-05 | Unknown | Kansas | 0 | 171 | |
801350 | 801350 | 2020-12-06 | Unknown | Kansas | 0 | 165 | |
804595 | 804595 | 2020-12-07 | Unknown | Kansas | 0 | 208 | |
807840 | 807840 | 2020-12-08 | Unknown | Kansas | 0 | 156 | |
811085 | 811085 | 2020-12-09 | Unknown | Kansas | 0 | 204 | |
814330 | 814330 | 2020-12-10 | Unknown | Kansas | 0 | 171 | |
817576 | 817576 | 2020-12-11 | Unknown | Kansas | 0 | 264 | |
820822 | 820822 | 2020-12-12 | Unknown | Kansas | 0 | 260 | |
824068 | 824068 | 2020-12-13 | Unknown | Kansas | 0 | 255 | |
827315 | 827315 | 2020-12-14 | Unknown | Kansas | 0 | 262 | |
830561 | 830561 | 2020-12-15 | Unknown | Kansas | 0 | 192 | |
833808 | 833808 | 2020-12-16 | Unknown | Kansas | 0 | 287 | |
837054 | 837054 | 2020-12-17 | Unknown | Kansas | 0 | 247 | |
840299 | 840299 | 2020-12-18 | Unknown | Kansas | 0 | 316 | |
843544 | 843544 | 2020-12-19 | Unknown | Kansas | 0 | 309 | |
846790 | 846790 | 2020-12-20 | Unknown | Kansas | 0 | 308 | |
850035 | 850035 | 2020-12-21 | Unknown | Kansas | 0 | 389 | |
853280 | 853280 | 2020-12-22 | Unknown | Kansas | 0 | 348 | |
856525 | 856525 | 2020-12-23 | Unknown | Kansas | 0 | 380 | |
859770 | 859770 | 2020-12-24 | Unknown | Kansas | 0 | 369 | |
863015 | 863015 | 2020-12-25 | Unknown | Kansas | 0 | 369 | |
866260 | 866260 | 2020-12-26 | Unknown | Kansas | 0 | 369 | |
869505 | 869505 | 2020-12-27 | Unknown | Kansas | 0 | 361 | |
872750 | 872750 | 2020-12-28 | Unknown | Kansas | 0 | 354 |
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);