ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

105 rows where date = "2021-10-24" and state = "Kansas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Kansas · 105 ✖
Link rowid date ▲ county state fips cases deaths
1846754 1846754 2021-10-24 Allen Kansas 20001 1875 25
1846755 1846755 2021-10-24 Anderson Kansas 20003 1098 21
1846756 1846756 2021-10-24 Atchison Kansas 20005 2380 24
1846757 1846757 2021-10-24 Barber Kansas 20007 495 7
1846758 1846758 2021-10-24 Barton Kansas 20009 3844 56
1846759 1846759 2021-10-24 Bourbon Kansas 20011 2435 42
1846760 1846760 2021-10-24 Brown Kansas 20013 1529 40
1846761 1846761 2021-10-24 Butler Kansas 20015 10840 124
1846762 1846762 2021-10-24 Chase Kansas 20017 353 4
1846763 1846763 2021-10-24 Chautauqua Kansas 20019 496 9
1846764 1846764 2021-10-24 Cherokee Kansas 20021 3626 77
1846765 1846765 2021-10-24 Cheyenne Kansas 20023 430 13
1846766 1846766 2021-10-24 Clark Kansas 20025 321 7
1846767 1846767 2021-10-24 Clay Kansas 20027 1234 31
1846768 1846768 2021-10-24 Cloud Kansas 20029 1325 28
1846769 1846769 2021-10-24 Coffey Kansas 20031 1171 26
1846770 1846770 2021-10-24 Comanche Kansas 20033 271 12
1846771 1846771 2021-10-24 Cowley Kansas 20035 5571 126
1846772 1846772 2021-10-24 Crawford Kansas 20037 6694 111
1846773 1846773 2021-10-24 Decatur Kansas 20039 351 13
1846774 1846774 2021-10-24 Dickinson Kansas 20041 2876 60
1846775 1846775 2021-10-24 Doniphan Kansas 20043 1362 27
1846776 1846776 2021-10-24 Douglas Kansas 20045 12335 102
1846777 1846777 2021-10-24 Edwards Kansas 20047 347 13
1846778 1846778 2021-10-24 Elk Kansas 20049 284 6
1846779 1846779 2021-10-24 Ellis Kansas 20051 4522 76
1846780 1846780 2021-10-24 Ellsworth Kansas 20053 1383 28
1846781 1846781 2021-10-24 Finney Kansas 20055 7385 84
1846782 1846782 2021-10-24 Ford Kansas 20057 7091 90
1846783 1846783 2021-10-24 Franklin Kansas 20059 3754 58
1846784 1846784 2021-10-24 Geary Kansas 20061 4734 54
1846785 1846785 2021-10-24 Gove Kansas 20063 469 22
1846786 1846786 2021-10-24 Graham Kansas 20065 319 11
1846787 1846787 2021-10-24 Grant Kansas 20067 1244 27
1846788 1846788 2021-10-24 Gray Kansas 20069 840 16
1846789 1846789 2021-10-24 Greeley Kansas 20071 153 2
1846790 1846790 2021-10-24 Greenwood Kansas 20073 967 14
1846791 1846791 2021-10-24 Hamilton Kansas 20075 272 1
1846792 1846792 2021-10-24 Harper Kansas 20077 915 19
1846793 1846793 2021-10-24 Harvey Kansas 20079 4993 80
1846794 1846794 2021-10-24 Haskell Kansas 20081 552 8
1846795 1846795 2021-10-24 Hodgeman Kansas 20083 233 10
1846796 1846796 2021-10-24 Jackson Kansas 20085 1970 19
1846797 1846797 2021-10-24 Jefferson Kansas 20087 2574 47
1846798 1846798 2021-10-24 Jewell Kansas 20089 407 8
1846799 1846799 2021-10-24 Johnson Kansas 20091 77388 920
1846800 1846800 2021-10-24 Kearny Kansas 20093 754 12
1846801 1846801 2021-10-24 Kingman Kansas 20095 1155 20
1846802 1846802 2021-10-24 Kiowa Kansas 20097 366 5
1846803 1846803 2021-10-24 Labette Kansas 20099 3495 60
1846804 1846804 2021-10-24 Lane Kansas 20101 167 7
1846805 1846805 2021-10-24 Leavenworth Kansas 20103 10279 123
1846806 1846806 2021-10-24 Lincoln Kansas 20105 349 5
1846807 1846807 2021-10-24 Linn Kansas 20107 1586 15
1846808 1846808 2021-10-24 Logan Kansas 20109 411 8
1846809 1846809 2021-10-24 Lyon Kansas 20111 5426 92
1846810 1846810 2021-10-24 Marion Kansas 20115 1600 29
1846811 1846811 2021-10-24 Marshall Kansas 20117 1442 28
1846812 1846812 2021-10-24 McPherson Kansas 20113 4468 94
1846813 1846813 2021-10-24 Meade Kansas 20119 685 14
1846814 1846814 2021-10-24 Miami Kansas 20121 4316 59
1846815 1846815 2021-10-24 Mitchell Kansas 20123 767 16
1846816 1846816 2021-10-24 Montgomery Kansas 20125 5346 110
1846817 1846817 2021-10-24 Morris Kansas 20127 766 23
1846818 1846818 2021-10-24 Morton Kansas 20129 367 9
1846819 1846819 2021-10-24 Nemaha Kansas 20131 1898 56
1846820 1846820 2021-10-24 Neosho Kansas 20133 2553 49
1846821 1846821 2021-10-24 Ness Kansas 20135 489 17
1846822 1846822 2021-10-24 Norton Kansas 20137 1401 30
1846823 1846823 2021-10-24 Osage Kansas 20139 1972 34
1846824 1846824 2021-10-24 Osborne Kansas 20141 411 14
1846825 1846825 2021-10-24 Ottawa Kansas 20143 716 14
1846826 1846826 2021-10-24 Pawnee Kansas 20145 1461 15
1846827 1846827 2021-10-24 Phillips Kansas 20147 879 26
1846828 1846828 2021-10-24 Pottawatomie Kansas 20149 2782 41
1846829 1846829 2021-10-24 Pratt Kansas 20151 1208 26
1846830 1846830 2021-10-24 Rawlins Kansas 20153 420 7
1846831 1846831 2021-10-24 Reno Kansas 20155 11181 163
1846832 1846832 2021-10-24 Republic Kansas 20157 884 15
1846833 1846833 2021-10-24 Rice Kansas 20159 1446 15
1846834 1846834 2021-10-24 Riley Kansas 20161 8059 59
1846835 1846835 2021-10-24 Rooks Kansas 20163 774 11
1846836 1846836 2021-10-24 Rush Kansas 20165 504 15
1846837 1846837 2021-10-24 Russell Kansas 20167 1120 33
1846838 1846838 2021-10-24 Saline Kansas 20169 8345 176
1846839 1846839 2021-10-24 Scott Kansas 20171 763 27
1846840 1846840 2021-10-24 Sedgwick Kansas 20173 80543 959
1846841 1846841 2021-10-24 Seward Kansas 20175 4703 47
1846842 1846842 2021-10-24 Shawnee Kansas 20177 25443 447
1846843 1846843 2021-10-24 Sheridan Kansas 20179 492 14
1846844 1846844 2021-10-24 Sherman Kansas 20181 787 13
1846845 1846845 2021-10-24 Smith Kansas 20183 392 3
1846846 1846846 2021-10-24 Stafford Kansas 20185 592 16
1846847 1846847 2021-10-24 Stanton Kansas 20187 275 6
1846848 1846848 2021-10-24 Stevens Kansas 20189 755 12
1846849 1846849 2021-10-24 Sumner Kansas 20191 3225 61
1846850 1846850 2021-10-24 Thomas Kansas 20193 1350 22
1846851 1846851 2021-10-24 Trego Kansas 20195 493 8
1846852 1846852 2021-10-24 Wabaunsee Kansas 20197 904 18
1846853 1846853 2021-10-24 Wallace Kansas 20199 238 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);