⚠️ 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 source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

34,603 rows where province_or_state = "Kansas" sorted by day descending

View and edit SQL

province_or_state

  • Kansas · 34,603

country_or_region

  • US 34,603
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
901931 2021-03-04 US Kansas Allen 20001 1135 16 0 1119 37.88582951 -95.30030847 2021-03-05 05:26:29 Allen, Kansas, US
901932 2021-03-04 US Kansas Anderson 20003 815 18 0 797 38.21413251 -95.29272815 2021-03-05 05:26:29 Anderson, Kansas, US
901933 2021-03-04 US Kansas Atchison 20005 1532 13 0 1519 39.53185661 -95.30870026 2021-03-05 05:26:29 Atchison, Kansas, US
901934 2021-03-04 US Kansas Barber 20007 367 7 0 360 37.2288586 -98.68460053 2021-03-05 05:26:29 Barber, Kansas, US
901935 2021-03-04 US Kansas Barton 20009 2573 48 0 2525 38.47889676 -98.75636726 2021-03-05 05:26:29 Barton, Kansas, US
901936 2021-03-04 US Kansas Bourbon 20011 1283 24 0 1259 37.85508555 -94.84865997 2021-03-05 05:26:29 Bourbon, Kansas, US
901937 2021-03-04 US Kansas Brown 20013 1215 36 0 1179 39.82652589 -95.56421698 2021-03-05 05:26:29 Brown, Kansas, US
901938 2021-03-04 US Kansas Butler 20015 7217 83 0 7134 37.78134351 -96.83878537 2021-03-05 05:26:29 Butler, Kansas, US
901939 2021-03-04 US Kansas Chase 20017 245 3 0 242 38.30292938 -96.59563862 2021-03-05 05:26:29 Chase, Kansas, US
901940 2021-03-04 US Kansas Chautauqua 20019 258 6 0 252 37.14994405 -96.2454192 2021-03-05 05:26:29 Chautauqua, Kansas, US
901941 2021-03-04 US Kansas Cherokee 20021 2365 47 0 2318 37.16928494 -94.8462897 2021-03-05 05:26:29 Cherokee, Kansas, US
901942 2021-03-04 US Kansas Cheyenne 20023 353 13 0 340 39.78580976 -101.7318201 2021-03-05 05:26:29 Cheyenne, Kansas, US
901943 2021-03-04 US Kansas Clark 20025 244 7 0 237 37.23577007 -99.81883015 2021-03-05 05:26:29 Clark, Kansas, US
901944 2021-03-04 US Kansas Clay 20027 781 27 0 754 39.34948772 -97.16518128 2021-03-05 05:26:29 Clay, Kansas, US
901945 2021-03-04 US Kansas Cloud 20029 968 26 0 942 39.48028352 -97.64925343 2021-03-05 05:26:29 Cloud, Kansas, US
901946 2021-03-04 US Kansas Coffey 20031 711 19 0 692 38.2365018 -95.73379515 2021-03-05 05:26:29 Coffey, Kansas, US
901947 2021-03-04 US Kansas Comanche 20033 159 9 0 150 37.19114520000001 -99.27113247 2021-03-05 05:26:29 Comanche, Kansas, US
901948 2021-03-04 US Kansas Cowley 20035 3815 102 0 3713 37.23781842 -96.83776647 2021-03-05 05:26:29 Cowley, Kansas, US
901949 2021-03-04 US Kansas Crawford 20037 4528 70 0 4458 37.50675523 -94.85245778 2021-03-05 05:26:29 Crawford, Kansas, US
901950 2021-03-04 US Kansas Decatur 20039 259 11 0 248 39.78468441 -100.4594081 2021-03-05 05:26:29 Decatur, Kansas, US
901951 2021-03-04 US Kansas Dickinson 20041 1688 42 0 1646 38.86600962 -97.15532383 2021-03-05 05:26:29 Dickinson, Kansas, US
901952 2021-03-04 US Kansas Doniphan 20043 942 22 0 920 39.79067154 -95.14056866 2021-03-05 05:26:29 Doniphan, Kansas, US
901953 2021-03-04 US Kansas Douglas 20045 8679 79 0 8600 38.88503636 -95.2925121 2021-03-05 05:26:29 Douglas, Kansas, US
901954 2021-03-04 US Kansas Edwards 20047 254 12 0 242 37.88735543 -99.31263309 2021-03-05 05:26:29 Edwards, Kansas, US
901955 2021-03-04 US Kansas Elk 20049 176 5 0 171 37.45338105 -96.24369667 2021-03-05 05:26:29 Elk, Kansas, US
901956 2021-03-04 US Kansas Ellis 20051 3685 72 0 3613 38.91458712 -99.31751551 2021-03-05 05:26:29 Ellis, Kansas, US
901957 2021-03-04 US Kansas Ellsworth 20053 1210 25 0 1185 38.69677695 -98.20462799 2021-03-05 05:26:29 Ellsworth, Kansas, US
901958 2021-03-04 US Kansas Finney 20055 5989 72 0 5917 38.04340344 -100.7381938 2021-03-05 05:26:29 Finney, Kansas, US
901959 2021-03-04 US Kansas Ford 20057 5581 70 0 5511 37.69200114 -99.88825298 2021-03-05 05:26:29 Ford, Kansas, US
901960 2021-03-04 US Kansas Franklin 20059 2446 37 0 2409 38.56443815 -95.28644341 2021-03-05 05:26:29 Franklin, Kansas, US
901961 2021-03-04 US Kansas Geary 20061 3043 37 0 3006 38.99871131 -96.7577178 2021-03-05 05:26:29 Geary, Kansas, US
901962 2021-03-04 US Kansas Gove 20063 385 19 0 366 38.91588178 -100.4829321 2021-03-05 05:26:29 Gove, Kansas, US
901963 2021-03-04 US Kansas Graham 20065 250 7 0 243 39.34987223 -99.88332493 2021-03-05 05:26:29 Graham, Kansas, US
901964 2021-03-04 US Kansas Grant 20067 926 18 0 908 37.56227336 -101.3079758 2021-03-05 05:26:29 Grant, Kansas, US
901965 2021-03-04 US Kansas Gray 20069 552 14 0 538 37.73836671 -100.4369088 2021-03-05 05:26:29 Gray, Kansas, US
901966 2021-03-04 US Kansas Greeley 20071 101 1 0 100 38.4808095 -101.8061079 2021-03-05 05:26:29 Greeley, Kansas, US
901967 2021-03-04 US Kansas Greenwood 20073 549 13 0 536 37.8774388 -96.23250453 2021-03-05 05:26:29 Greenwood, Kansas, US
901968 2021-03-04 US Kansas Hamilton 20075 201 1 0 200 37.99978709 -101.7921066 2021-03-05 05:26:29 Hamilton, Kansas, US
901969 2021-03-04 US Kansas Harper 20077 598 20 0 578 37.19175361 -98.07578384 2021-03-05 05:26:29 Harper, Kansas, US
901970 2021-03-04 US Kansas Harvey 20079 3411 62 0 3349 38.04293782 -97.42747573 2021-03-05 05:26:29 Harvey, Kansas, US
901971 2021-03-04 US Kansas Haskell 20081 407 9 0 398 37.5620394 -100.8710738 2021-03-05 05:26:29 Haskell, Kansas, US
901972 2021-03-04 US Kansas Hodgeman 20083 206 7 0 199 38.08780079 -99.89829881 2021-03-05 05:26:29 Hodgeman, Kansas, US
901973 2021-03-04 US Kansas Jackson 20085 1336 15 0 1321 39.41673394 -95.79356799 2021-03-05 05:26:29 Jackson, Kansas, US
901974 2021-03-04 US Kansas Jefferson 20087 1620 32 0 1588 39.2347941 -95.38289232 2021-03-05 05:26:29 Jefferson, Kansas, US
901975 2021-03-04 US Kansas Jewell 20089 199 4 0 195 39.78470589 -98.21820662 2021-03-05 05:26:29 Jewell, Kansas, US
901976 2021-03-04 US Kansas Johnson 20091 54533 752 0 53781 38.88548175 -94.82250877 2021-03-05 05:26:29 Johnson, Kansas, US
901977 2021-03-04 US Kansas Kearny 20093 561 11 0 550 38.00017981 -101.321681 2021-03-05 05:26:29 Kearny, Kansas, US
901978 2021-03-04 US Kansas Kingman 20095 729 14 0 715 37.55909527 -98.13638678 2021-03-05 05:26:29 Kingman, Kansas, US
901979 2021-03-04 US Kansas Kiowa 20097 237 4 0 233 37.55848695 -99.2856537 2021-03-05 05:26:29 Kiowa, Kansas, US
901980 2021-03-04 US Kansas Labette 20099 2616 10 0 2606 37.19113093 -95.29849679 2021-03-05 05:26:29 Labette, Kansas, US
901981 2021-03-04 US Kansas Lane 20101 124 7 0 117 38.48119447 -100.4660754 2021-03-05 05:26:29 Lane, Kansas, US
901982 2021-03-04 US Kansas Leavenworth 20103 6810 83 0 6727 39.20183497 -95.03620809 2021-03-05 05:26:29 Leavenworth, Kansas, US
901983 2021-03-04 US Kansas Lincoln 20105 255 4 0 251 39.04549684 -98.20756994 2021-03-05 05:26:29 Lincoln, Kansas, US
901984 2021-03-04 US Kansas Linn 20107 752 8 0 744 38.21267844 -94.84254089 2021-03-05 05:26:29 Linn, Kansas, US
901985 2021-03-04 US Kansas Logan 20109 292 6 0 286 38.91735806 -101.148475 2021-03-05 05:26:29 Logan, Kansas, US
901986 2021-03-04 US Kansas Lyon 20111 4112 81 0 4031 38.45576156 -96.15275715 2021-03-05 05:26:29 Lyon, Kansas, US
901987 2021-03-04 US Kansas Marion 20115 1029 24 0 1005 38.35855394 -97.0985251 2021-03-05 05:26:29 Marion, Kansas, US
901988 2021-03-04 US Kansas Marshall 20117 1069 23 0 1046 39.78359669 -96.52278974 2021-03-05 05:26:29 Marshall, Kansas, US
901989 2021-03-04 US Kansas McPherson 20113 3126 84 0 3042 38.39184858 -97.64769869 2021-03-05 05:26:29 McPherson, Kansas, US
901990 2021-03-04 US Kansas Meade 20119 492 10 0 482 37.23859987 -100.364831 2021-03-05 05:26:29 Meade, Kansas, US
901991 2021-03-04 US Kansas Miami 20121 2645 42 0 2603 38.56383358 -94.83832189 2021-03-05 05:26:29 Miami, Kansas, US
901992 2021-03-04 US Kansas Mitchell 20123 559 19 0 540 39.39331582 -98.20906732 2021-03-05 05:26:29 Mitchell, Kansas, US
901993 2021-03-04 US Kansas Montgomery 20125 3302 72 0 3230 37.19236568 -95.74329258 2021-03-05 05:26:29 Montgomery, Kansas, US
901994 2021-03-04 US Kansas Morris 20127 557 21 0 536 38.68827511 -96.65128437 2021-03-05 05:26:29 Morris, Kansas, US
901995 2021-03-04 US Kansas Morton 20129 254 8 0 246 37.19141121 -101.79925190000002 2021-03-05 05:26:29 Morton, Kansas, US
901996 2021-03-04 US Kansas Nemaha 20131 1483 55 0 1428 39.78345387 -96.01392079 2021-03-05 05:26:29 Nemaha, Kansas, US
901997 2021-03-04 US Kansas Neosho 20133 1753 23 0 1730 37.55862897 -95.30670046 2021-03-05 05:26:29 Neosho, Kansas, US
901998 2021-03-04 US Kansas Ness 20135 365 15 0 350 38.47974157 -99.91547333 2021-03-05 05:26:29 Ness, Kansas, US
901999 2021-03-04 US Kansas Norton 20137 1201 27 0 1174 39.78443827 -99.90286639 2021-03-05 05:26:29 Norton, Kansas, US
902000 2021-03-04 US Kansas Osage 20139 1192 23 0 1169 38.65235984 -95.72707998 2021-03-05 05:26:29 Osage, Kansas, US
902001 2021-03-04 US Kansas Osborne 20141 287 11 0 276 39.3503437 -98.76753828 2021-03-05 05:26:29 Osborne, Kansas, US
902002 2021-03-04 US Kansas Ottawa 20143 548 13 0 535 39.13237408 -97.65020313 2021-03-05 05:26:29 Ottawa, Kansas, US
902003 2021-03-04 US Kansas Out of KS 80020 0 0 0 0 39.82799632 -99.91547333 2021-03-05 05:26:29 Out of KS, Kansas, US
902004 2021-03-04 US Kansas Pawnee 20145 1134 14 0 1120 38.18108732 -99.23692334 2021-03-05 05:26:29 Pawnee, Kansas, US
902005 2021-03-04 US Kansas Phillips 20147 704 23 0 681 39.78465501 -99.34668865 2021-03-05 05:26:29 Phillips, Kansas, US
902006 2021-03-04 US Kansas Pottawatomie 20149 1758 29 0 1729 39.37925655 -96.34564657 2021-03-05 05:26:29 Pottawatomie, Kansas, US
902007 2021-03-04 US Kansas Pratt 20151 807 25 0 782 37.64780729 -98.73922153 2021-03-05 05:26:29 Pratt, Kansas, US
902008 2021-03-04 US Kansas Rawlins 20153 290 8 0 282 39.78525843 -101.0761617 2021-03-05 05:26:29 Rawlins, Kansas, US
902009 2021-03-04 US Kansas Reno 20155 8306 139 0 8167 37.95230263 -98.08607292 2021-03-05 05:26:29 Reno, Kansas, US
902010 2021-03-04 US Kansas Republic 20157 657 13 0 644 39.82799632 -97.65036709 2021-03-05 05:26:29 Republic, Kansas, US
902011 2021-03-04 US Kansas Rice 20159 1055 12 0 1043 38.34616184 -98.19992118 2021-03-05 05:26:29 Rice, Kansas, US
902012 2021-03-04 US Kansas Riley 20161 6216 33 0 6183 39.28935726 -96.73420026 2021-03-05 05:26:29 Riley, Kansas, US
902013 2021-03-04 US Kansas Rooks 20163 635 12 0 623 39.35022773 -99.32484567 2021-03-05 05:26:29 Rooks, Kansas, US
902014 2021-03-04 US Kansas Rush 20165 425 13 0 412 38.52275276 -99.30863983 2021-03-05 05:26:29 Rush, Kansas, US
902015 2021-03-04 US Kansas Russell 20167 842 27 0 815 38.91462787 -98.76254297 2021-03-05 05:26:29 Russell, Kansas, US
902016 2021-03-04 US Kansas Saline 20169 5985 133 0 5852 38.78369175 -97.65185177 2021-03-05 05:26:29 Saline, Kansas, US
902017 2021-03-04 US Kansas Scott 20171 569 23 0 546 38.48222076 -100.9066539 2021-03-05 05:26:29 Scott, Kansas, US
902018 2021-03-04 US Kansas Sedgwick 20173 53830 711 0 53119 37.6842718 -97.4608198 2021-03-05 05:26:29 Sedgwick, Kansas, US
902019 2021-03-04 US Kansas Seward 20175 3782 34 0 3748 37.19324632 -100.8507201 2021-03-05 05:26:29 Seward, Kansas, US
902020 2021-03-04 US Kansas Shawnee 20177 16409 343 0 16066 39.04100763 -95.7557264 2021-03-05 05:26:29 Shawnee, Kansas, US
902021 2021-03-04 US Kansas Sheridan 20179 428 12 0 416 39.35018161 -100.4418259 2021-03-05 05:26:29 Sheridan, Kansas, US
902022 2021-03-04 US Kansas Sherman 20181 607 11 0 596 39.35147699 -101.7197624 2021-03-05 05:26:29 Sherman, Kansas, US
902023 2021-03-04 US Kansas Smith 20183 264 2 0 262 39.78516566 -98.78566062 2021-03-05 05:26:29 Smith, Kansas, US
902024 2021-03-04 US Kansas Stafford 20185 333 9 0 324 38.03100851 -98.71762001 2021-03-05 05:26:29 Stafford, Kansas, US
902025 2021-03-04 US Kansas Stanton 20187 184 7 0 177 37.56304714 -101.7843534 2021-03-05 05:26:29 Stanton, Kansas, US
902026 2021-03-04 US Kansas Stevens 20189 547 9 0 538 37.1923008 -101.3118967 2021-03-05 05:26:29 Stevens, Kansas, US
902027 2021-03-04 US Kansas Sumner 20191 2074 49 0 2025 37.23682549 -97.47721621 2021-03-05 05:26:29 Sumner, Kansas, US
902028 2021-03-04 US Kansas Thomas 20193 1076 17 0 1059 39.35107575 -101.0553705 2021-03-05 05:26:29 Thomas, Kansas, US
902029 2021-03-04 US Kansas Trego 20195 401 8 0 393 38.91467218 -99.87284448 2021-03-05 05:26:29 Trego, Kansas, US
902030 2021-03-04 US Kansas Unassigned 90020 0 0 0 0 39.82799632 -99.91547333 2021-03-05 05:26:29 Unassigned, Kansas, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);