ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where date = "2020-11-30" 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 |
---|---|---|---|---|---|---|---|
781783 | 781783 | 2020-11-30 | Allen | Kansas | 20001 | 374 | 1 |
781784 | 781784 | 2020-11-30 | Anderson | Kansas | 20003 | 385 | 0 |
781785 | 781785 | 2020-11-30 | Atchison | Kansas | 20005 | 873 | 9 |
781786 | 781786 | 2020-11-30 | Barber | Kansas | 20007 | 197 | 2 |
781787 | 781787 | 2020-11-30 | Barton | Kansas | 20009 | 1706 | 13 |
781788 | 781788 | 2020-11-30 | Bourbon | Kansas | 20011 | 564 | 3 |
781789 | 781789 | 2020-11-30 | Brown | Kansas | 20013 | 760 | 7 |
781790 | 781790 | 2020-11-30 | Butler | Kansas | 20015 | 3468 | 11 |
781791 | 781791 | 2020-11-30 | Chase | Kansas | 20017 | 187 | 3 |
781792 | 781792 | 2020-11-30 | Chautauqua | Kansas | 20019 | 81 | 1 |
781793 | 781793 | 2020-11-30 | Cherokee | Kansas | 20021 | 1151 | 10 |
781794 | 781794 | 2020-11-30 | Cheyenne | Kansas | 20023 | 208 | 9 |
781795 | 781795 | 2020-11-30 | Clark | Kansas | 20025 | 140 | 4 |
781796 | 781796 | 2020-11-30 | Clay | Kansas | 20027 | 453 | 11 |
781797 | 781797 | 2020-11-30 | Cloud | Kansas | 20029 | 613 | 2 |
781798 | 781798 | 2020-11-30 | Coffey | Kansas | 20031 | 309 | 10 |
781799 | 781799 | 2020-11-30 | Comanche | Kansas | 20033 | 82 | 0 |
781800 | 781800 | 2020-11-30 | Cowley | Kansas | 20035 | 1631 | 9 |
781801 | 781801 | 2020-11-30 | Crawford | Kansas | 20037 | 2427 | 18 |
781802 | 781802 | 2020-11-30 | Decatur | Kansas | 20039 | 201 | 1 |
781803 | 781803 | 2020-11-30 | Dickinson | Kansas | 20041 | 731 | 10 |
781804 | 781804 | 2020-11-30 | Doniphan | Kansas | 20043 | 516 | 2 |
781805 | 781805 | 2020-11-30 | Douglas | Kansas | 20045 | 4880 | 25 |
781806 | 781806 | 2020-11-30 | Edwards | Kansas | 20047 | 178 | 0 |
781807 | 781807 | 2020-11-30 | Elk | Kansas | 20049 | 58 | 0 |
781808 | 781808 | 2020-11-30 | Ellis | Kansas | 20051 | 2404 | 28 |
781809 | 781809 | 2020-11-30 | Ellsworth | Kansas | 20053 | 711 | 4 |
781810 | 781810 | 2020-11-30 | Finney | Kansas | 20055 | 4626 | 23 |
781811 | 781811 | 2020-11-30 | Ford | Kansas | 20057 | 4650 | 10 |
781812 | 781812 | 2020-11-30 | Franklin | Kansas | 20059 | 1115 | 16 |
781813 | 781813 | 2020-11-30 | Geary | Kansas | 20061 | 992 | 5 |
781814 | 781814 | 2020-11-30 | Gove | Kansas | 20063 | 301 | 20 |
781815 | 781815 | 2020-11-30 | Graham | Kansas | 20065 | 163 | 2 |
781816 | 781816 | 2020-11-30 | Grant | Kansas | 20067 | 739 | 10 |
781817 | 781817 | 2020-11-30 | Gray | Kansas | 20069 | 448 | 4 |
781818 | 781818 | 2020-11-30 | Greeley | Kansas | 20071 | 88 | 0 |
781819 | 781819 | 2020-11-30 | Greenwood | Kansas | 20073 | 227 | 1 |
781820 | 781820 | 2020-11-30 | Hamilton | Kansas | 20075 | 159 | 0 |
781821 | 781821 | 2020-11-30 | Harper | Kansas | 20077 | 320 | 12 |
781822 | 781822 | 2020-11-30 | Harvey | Kansas | 20079 | 1842 | 15 |
781823 | 781823 | 2020-11-30 | Haskell | Kansas | 20081 | 264 | 1 |
781824 | 781824 | 2020-11-30 | Hodgeman | Kansas | 20083 | 140 | 0 |
781825 | 781825 | 2020-11-30 | Jackson | Kansas | 20085 | 697 | 4 |
781826 | 781826 | 2020-11-30 | Jefferson | Kansas | 20087 | 731 | 8 |
781827 | 781827 | 2020-11-30 | Jewell | Kansas | 20089 | 93 | 1 |
781828 | 781828 | 2020-11-30 | Johnson | Kansas | 20091 | 27420 | 285 |
781829 | 781829 | 2020-11-30 | Kearny | Kansas | 20093 | 381 | 8 |
781830 | 781830 | 2020-11-30 | Kingman | Kansas | 20095 | 388 | 4 |
781831 | 781831 | 2020-11-30 | Kiowa | Kansas | 20097 | 118 | 0 |
781832 | 781832 | 2020-11-30 | Labette | Kansas | 20099 | 875 | 6 |
781833 | 781833 | 2020-11-30 | Lane | Kansas | 20101 | 92 | 2 |
781834 | 781834 | 2020-11-30 | Leavenworth | Kansas | 20103 | 3817 | 31 |
781835 | 781835 | 2020-11-30 | Lincoln | Kansas | 20105 | 90 | 1 |
781836 | 781836 | 2020-11-30 | Linn | Kansas | 20107 | 308 | 2 |
781837 | 781837 | 2020-11-30 | Logan | Kansas | 20109 | 238 | 0 |
781838 | 781838 | 2020-11-30 | Lyon | Kansas | 20111 | 2657 | 47 |
781839 | 781839 | 2020-11-30 | Marion | Kansas | 20115 | 454 | 1 |
781840 | 781840 | 2020-11-30 | Marshall | Kansas | 20117 | 667 | 10 |
781841 | 781841 | 2020-11-30 | McPherson | Kansas | 20113 | 1447 | 9 |
781842 | 781842 | 2020-11-30 | Meade | Kansas | 20119 | 308 | 4 |
781843 | 781843 | 2020-11-30 | Miami | Kansas | 20121 | 1073 | 2 |
781844 | 781844 | 2020-11-30 | Mitchell | Kansas | 20123 | 213 | 0 |
781845 | 781845 | 2020-11-30 | Montgomery | Kansas | 20125 | 1158 | 6 |
781846 | 781846 | 2020-11-30 | Morris | Kansas | 20127 | 205 | 1 |
781847 | 781847 | 2020-11-30 | Morton | Kansas | 20129 | 164 | 6 |
781848 | 781848 | 2020-11-30 | Nemaha | Kansas | 20131 | 1046 | 15 |
781849 | 781849 | 2020-11-30 | Neosho | Kansas | 20133 | 690 | 0 |
781850 | 781850 | 2020-11-30 | Ness | Kansas | 20135 | 278 | 13 |
781851 | 781851 | 2020-11-30 | Norton | Kansas | 20137 | 1092 | 23 |
781852 | 781852 | 2020-11-30 | Osage | Kansas | 20139 | 535 | 6 |
781853 | 781853 | 2020-11-30 | Osborne | Kansas | 20141 | 91 | 0 |
781854 | 781854 | 2020-11-30 | Ottawa | Kansas | 20143 | 250 | 0 |
781855 | 781855 | 2020-11-30 | Pawnee | Kansas | 20145 | 675 | 1 |
781856 | 781856 | 2020-11-30 | Phillips | Kansas | 20147 | 435 | 10 |
781857 | 781857 | 2020-11-30 | Pottawatomie | Kansas | 20149 | 691 | 2 |
781858 | 781858 | 2020-11-30 | Pratt | Kansas | 20151 | 500 | 10 |
781859 | 781859 | 2020-11-30 | Rawlins | Kansas | 20153 | 239 | 3 |
781860 | 781860 | 2020-11-30 | Reno | Kansas | 20155 | 5137 | 49 |
781861 | 781861 | 2020-11-30 | Republic | Kansas | 20157 | 338 | 3 |
781862 | 781862 | 2020-11-30 | Rice | Kansas | 20159 | 468 | 1 |
781863 | 781863 | 2020-11-30 | Riley | Kansas | 20161 | 3709 | 15 |
781864 | 781864 | 2020-11-30 | Rooks | Kansas | 20163 | 368 | 8 |
781865 | 781865 | 2020-11-30 | Rush | Kansas | 20165 | 264 | 0 |
781866 | 781866 | 2020-11-30 | Russell | Kansas | 20167 | 551 | 15 |
781867 | 781867 | 2020-11-30 | Saline | Kansas | 20169 | 2503 | 22 |
781868 | 781868 | 2020-11-30 | Scott | Kansas | 20171 | 456 | 3 |
781869 | 781869 | 2020-11-30 | Sedgwick | Kansas | 20173 | 27966 | 150 |
781870 | 781870 | 2020-11-30 | Seward | Kansas | 20175 | 3006 | 13 |
781871 | 781871 | 2020-11-30 | Shawnee | Kansas | 20177 | 7855 | 134 |
781872 | 781872 | 2020-11-30 | Sheridan | Kansas | 20179 | 320 | 0 |
781873 | 781873 | 2020-11-30 | Sherman | Kansas | 20181 | 451 | 7 |
781874 | 781874 | 2020-11-30 | Smith | Kansas | 20183 | 158 | 1 |
781875 | 781875 | 2020-11-30 | Stafford | Kansas | 20185 | 209 | 1 |
781876 | 781876 | 2020-11-30 | Stanton | Kansas | 20187 | 148 | 2 |
781877 | 781877 | 2020-11-30 | Stevens | Kansas | 20189 | 444 | 4 |
781878 | 781878 | 2020-11-30 | Sumner | Kansas | 20191 | 824 | 6 |
781879 | 781879 | 2020-11-30 | Thomas | Kansas | 20193 | 727 | 6 |
781880 | 781880 | 2020-11-30 | Trego | Kansas | 20195 | 225 | 3 |
781881 | 781881 | 2020-11-30 | Unknown | Kansas | 0 | 95 | |
781882 | 781882 | 2020-11-30 | Wabaunsee | Kansas | 20197 | 308 | 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);