ny_times_us_counties

⚠️ 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

7,919 rows where state = "Kansas" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Kansas · 7,919
Link rowid date ▲ county state fips cases deaths
292646 2020-07-03 Allen Kansas 20001 5 0
292647 2020-07-03 Anderson Kansas 20003 4 0
292648 2020-07-03 Atchison Kansas 20005 38 0
292649 2020-07-03 Barber Kansas 20007 2 0
292650 2020-07-03 Barton Kansas 20009 57 2
292651 2020-07-03 Bourbon Kansas 20011 28 1
292652 2020-07-03 Brown Kansas 20013 12 0
292653 2020-07-03 Butler Kansas 20015 64 0
292654 2020-07-03 Chase Kansas 20017 5 0
292655 2020-07-03 Chautauqua Kansas 20019 4 0
292656 2020-07-03 Cherokee Kansas 20021 38 0
292657 2020-07-03 Cheyenne Kansas 20023 2 0
292658 2020-07-03 Clark Kansas 20025 34 0
292659 2020-07-03 Clay Kansas 20027 7 2
292660 2020-07-03 Cloud Kansas 20029 21 0
292661 2020-07-03 Coffey Kansas 20031 53 8
292662 2020-07-03 Comanche Kansas 20033 2 0
292663 2020-07-03 Cowley Kansas 20035 73 1
292664 2020-07-03 Crawford Kansas 20037 267 1
292665 2020-07-03 Dickinson Kansas 20041 8 0
292666 2020-07-03 Doniphan Kansas 20043 26 0
292667 2020-07-03 Douglas Kansas 20045 251 0
292668 2020-07-03 Edwards Kansas 20047 7 0
292669 2020-07-03 Elk Kansas 20049 1 0
292670 2020-07-03 Ellis Kansas 20051 27 0
292671 2020-07-03 Ellsworth Kansas 20053 4 0
292672 2020-07-03 Finney Kansas 20055 1575 10
292673 2020-07-03 Ford Kansas 20057 2015 10
292674 2020-07-03 Franklin Kansas 20059 78 1
292675 2020-07-03 Geary Kansas 20061 85 1
292676 2020-07-03 Gove Kansas 20063 2 0
292677 2020-07-03 Grant Kansas 20067 51 1
292678 2020-07-03 Gray Kansas 20069 27 0
292679 2020-07-03 Greenwood Kansas 20073 11 0
292680 2020-07-03 Hamilton Kansas 20075 33 0
292681 2020-07-03 Harper Kansas 20077 2 0
292682 2020-07-03 Harvey Kansas 20079 45 2
292683 2020-07-03 Haskell Kansas 20081 28 0
292684 2020-07-03 Hodgeman Kansas 20083 9 0
292685 2020-07-03 Jackson Kansas 20085 115 1
292686 2020-07-03 Jefferson Kansas 20087 28 0
292687 2020-07-03 Jewell Kansas 20089 4 0
292688 2020-07-03 Johnson Kansas 20091 2066 88
292689 2020-07-03 Kearny Kansas 20093 48 1
292690 2020-07-03 Kiowa Kansas 20097 3 0
292691 2020-07-03 Labette Kansas 20099 65 0
292692 2020-07-03 Lane Kansas 20101 5 0
292693 2020-07-03 Leavenworth Kansas 20103 1183 7
292694 2020-07-03 Linn Kansas 20107 16 0
292695 2020-07-03 Logan Kansas 20109 1 0
292696 2020-07-03 Lyon Kansas 20111 502 7
292697 2020-07-03 Marion Kansas 20115 12 1
292698 2020-07-03 Marshall Kansas 20117 2 0
292699 2020-07-03 McPherson Kansas 20113 81 0
292700 2020-07-03 Meade Kansas 20119 30 0
292701 2020-07-03 Miami Kansas 20121 39 0
292702 2020-07-03 Mitchell Kansas 20123 4 0
292703 2020-07-03 Montgomery Kansas 20125 41 3
292704 2020-07-03 Morris Kansas 20127 5 0
292705 2020-07-03 Morton Kansas 20129 7 2
292706 2020-07-03 Nemaha Kansas 20131 27 0
292707 2020-07-03 Neosho Kansas 20133 33 0
292708 2020-07-03 Ness Kansas 20135 4 0
292709 2020-07-03 Norton Kansas 20137 6 0
292710 2020-07-03 Osage Kansas 20139 15 0
292711 2020-07-03 Osborne Kansas 20141 2 0
292712 2020-07-03 Ottawa Kansas 20143 8 0
292713 2020-07-03 Pawnee Kansas 20145 3 0
292714 2020-07-03 Phillips Kansas 20147 10 0
292715 2020-07-03 Pottawatomie Kansas 20149 79 0
292716 2020-07-03 Pratt Kansas 20151 11 0
292717 2020-07-03 Reno Kansas 20155 84 0
292718 2020-07-03 Republic Kansas 20157 9 0
292719 2020-07-03 Rice Kansas 20159 4 0
292720 2020-07-03 Riley Kansas 20161 261 3
292721 2020-07-03 Rooks Kansas 20163 8 0
292722 2020-07-03 Rush Kansas 20165 1 0
292723 2020-07-03 Saline Kansas 20169 130 2
292724 2020-07-03 Scott Kansas 20171 16 0
292725 2020-07-03 Sedgwick Kansas 20173 1564 28
292726 2020-07-03 Seward Kansas 20175 1033 2
292727 2020-07-03 Shawnee Kansas 20177 759 13
292728 2020-07-03 Sheridan Kansas 20179 5 0
292729 2020-07-03 Sherman Kansas 20181 7 0
292730 2020-07-03 Smith Kansas 20183 3 0
292731 2020-07-03 Stafford Kansas 20185 1 0
292732 2020-07-03 Stanton Kansas 20187 11 0
292733 2020-07-03 Stevens Kansas 20189 32 0
292734 2020-07-03 Sumner Kansas 20191 13 1
292735 2020-07-03 Thomas Kansas 20193 15 0
292736 2020-07-03 Trego Kansas 20195 1 0
292737 2020-07-03 Wabaunsee Kansas 20197 36 0
292738 2020-07-03 Washington Kansas 20201 1 0
292739 2020-07-03 Wilson Kansas 20205 3 0
292740 2020-07-03 Woodson Kansas 20207 9 0
292741 2020-07-03 Wyandotte Kansas 20209 2553 84
289567 2020-07-02 Allen Kansas 20001 5 0
289568 2020-07-02 Anderson Kansas 20003 4 0
289569 2020-07-02 Atchison Kansas 20005 34 0
289570 2020-07-02 Barber Kansas 20007 1 0

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
);
Powered by Datasette · Query took 1043.474ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette