johns_hopkins_csse_daily_reports

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

12,834 rows where province_or_state = "Kansas" sorted by day descending

View and edit SQL

province_or_state

  • Kansas · 12,834

country_or_region

  • US 12,834
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
496228 2020-08-11 US Kansas Bourbon 20011 79 2 0 77 37.85508555 -94.84865997 2020-08-12 04:27:29 Bourbon, Kansas, US
496229 2020-08-11 US Kansas Butler 20015 285 1 0 284 37.78134351 -96.83878537 2020-08-12 04:27:29 Butler, Kansas, US
496230 2020-08-11 US Kansas Chautauqua 20019 6 0 0 6 37.14994405 -96.2454192 2020-08-12 04:27:29 Chautauqua, Kansas, US
496231 2020-08-11 US Kansas Clay 20027 20 2 0 18 39.34948772 -97.16518128 2020-08-12 04:27:29 Clay, Kansas, US
496232 2020-08-11 US Kansas Doniphan 20043 48 0 0 48 39.79067154 -95.14056866 2020-08-12 04:27:29 Doniphan, Kansas, US
496233 2020-08-11 US Kansas Edwards 20047 10 0 0 10 37.88735543 -99.31263309 2020-08-12 04:27:29 Edwards, Kansas, US
496234 2020-08-11 US Kansas Marion 20115 48 1 0 47 38.35855394 -97.0985251 2020-08-12 04:27:29 Marion, Kansas, US
496235 2020-08-11 US Kansas Mitchell 20123 28 0 0 28 39.39331582 -98.20906732 2020-08-12 04:27:29 Mitchell, Kansas, US
496236 2020-08-11 US Kansas Nemaha 20131 49 1 0 48 39.78345387 -96.01392079 2020-08-12 04:27:29 Nemaha, Kansas, US
496237 2020-08-11 US Kansas Pawnee 20145 8 0 0 8 38.18108732 -99.23692334 2020-08-12 04:27:29 Pawnee, Kansas, US
496238 2020-08-11 US Kansas Seward 20175 1243 4 0 1239 37.19324632 -100.8507201 2020-08-12 04:27:29 Seward, Kansas, US
496537 2020-08-11 US Kansas Allen 20001 20 0 0 20 37.88582951 -95.30030847 2020-08-12 04:27:29 Allen, Kansas, US
496538 2020-08-11 US Kansas Cheyenne 20023 3 0 0 3 39.78580976 -101.7318201 2020-08-12 04:27:29 Cheyenne, Kansas, US
496539 2020-08-11 US Kansas Douglas 20045 750 5 0 745 38.88503636 -95.2925121 2020-08-12 04:27:29 Douglas, Kansas, US
496540 2020-08-11 US Kansas Ford 20057 2088 10 0 2078 37.69200114 -99.88825298 2020-08-12 04:27:29 Ford, Kansas, US
496541 2020-08-11 US Kansas Gove 20063 6 0 0 6 38.91588178 -100.4829321 2020-08-12 04:27:29 Gove, Kansas, US
496542 2020-08-11 US Kansas Lincoln 20105 6 0 0 6 39.04549684 -98.20756994 2020-08-12 04:27:29 Lincoln, Kansas, US
496543 2020-08-11 US Kansas Logan 20109 2 0 0 2 38.91735806 -101.148475 2020-08-12 04:27:29 Logan, Kansas, US
496544 2020-08-11 US Kansas Lyon 20111 716 14 0 702 38.45576156 -96.15275715 2020-08-12 04:27:29 Lyon, Kansas, US
496545 2020-08-11 US Kansas McPherson 20113 148 1 0 147 38.39184858 -97.64769869 2020-08-12 04:27:29 McPherson, Kansas, US
496546 2020-08-11 US Kansas Stanton 20187 20 1 0 19 37.56304714 -101.7843534 2020-08-12 04:27:29 Stanton, Kansas, US
497002 2020-08-11 US Kansas Barber 20007 4 0 0 4 37.2288586 -98.68460053 2020-08-12 04:27:29 Barber, Kansas, US
497003 2020-08-11 US Kansas Coffey 20031 67 8 0 59 38.2365018 -95.73379515 2020-08-12 04:27:29 Coffey, Kansas, US
497004 2020-08-11 US Kansas Crawford 20037 385 1 0 384 37.50675523 -94.85245778 2020-08-12 04:27:29 Crawford, Kansas, US
497005 2020-08-11 US Kansas Ellis 20051 145 1 0 144 38.91458712 -99.31751551 2020-08-12 04:27:29 Ellis, Kansas, US
497006 2020-08-11 US Kansas Greeley 20071 4 0 0 4 38.4808095 -101.8061079 2020-08-12 04:27:29 Greeley, Kansas, US
497007 2020-08-11 US Kansas Greenwood 20073 23 0 0 23 37.8774388 -96.23250453 2020-08-12 04:27:29 Greenwood, Kansas, US
497008 2020-08-11 US Kansas Harper 20077 12 0 0 12 37.19175361 -98.07578384 2020-08-12 04:27:29 Harper, Kansas, US
497009 2020-08-11 US Kansas Jewell 20089 12 1 0 11 39.78470589 -98.21820662 2020-08-12 04:27:29 Jewell, Kansas, US
497010 2020-08-11 US Kansas Kearny 20093 63 1 0 62 38.00017981 -101.321681 2020-08-12 04:27:29 Kearny, Kansas, US
497011 2020-08-11 US Kansas Kiowa 20097 8 0 0 8 37.55848695 -99.2856537 2020-08-12 04:27:29 Kiowa, Kansas, US
497012 2020-08-11 US Kansas Labette 20099 138 1 0 137 37.19113093 -95.29849679 2020-08-12 04:27:29 Labette, Kansas, US
497013 2020-08-11 US Kansas Linn 20107 40 0 0 40 38.21267844 -94.84254089 2020-08-12 04:27:29 Linn, Kansas, US
497014 2020-08-11 US Kansas Morris 20127 13 0 0 13 38.68827511 -96.65128437 2020-08-12 04:27:29 Morris, Kansas, US
497015 2020-08-11 US Kansas Rice 20159 39 0 0 39 38.34616184 -98.19992118 2020-08-12 04:27:29 Rice, Kansas, US
497016 2020-08-11 US Kansas Russell 20167 16 0 0 16 38.91462787 -98.76254297 2020-08-12 04:27:29 Russell, Kansas, US
497017 2020-08-11 US Kansas Washington 20201 1 0 0 1 39.78420784 -97.0875323 2020-08-12 04:27:29 Washington, Kansas, US
497018 2020-08-11 US Kansas Wichita 20203 4 0 0 4 38.48178252 -101.3471509 2020-08-12 04:27:29 Wichita, Kansas, US
497467 2020-08-11 US Kansas Osborne 20141 4 0 0 4 39.3503437 -98.76753828 2020-08-12 04:27:29 Osborne, Kansas, US
497498 2020-08-11 US Kansas Barton 20009 148 3 0 145 38.47889676 -98.75636726 2020-08-12 04:27:29 Barton, Kansas, US
497499 2020-08-11 US Kansas Clark 20025 44 1 0 43 37.23577007 -99.81883015 2020-08-12 04:27:29 Clark, Kansas, US
497500 2020-08-11 US Kansas Cloud 20029 37 0 0 37 39.48028352 -97.64925343 2020-08-12 04:27:29 Cloud, Kansas, US
497501 2020-08-11 US Kansas Comanche 20033 6 0 0 6 37.19114520000001 -99.27113247 2020-08-12 04:27:29 Comanche, Kansas, US
497502 2020-08-11 US Kansas Cowley 20035 174 2 0 172 37.23781842 -96.83776647 2020-08-12 04:27:29 Cowley, Kansas, US
497503 2020-08-11 US Kansas Decatur 20039 5 0 0 5 39.78468441 -100.4594081 2020-08-12 04:27:29 Decatur, Kansas, US
497504 2020-08-11 US Kansas Grant 20067 116 2 0 114 37.56227336 -101.3079758 2020-08-12 04:27:29 Grant, Kansas, US
497505 2020-08-11 US Kansas Jackson 20085 155 1 0 154 39.41673394 -95.79356799 2020-08-12 04:27:29 Jackson, Kansas, US
497506 2020-08-11 US Kansas Kingman 20095 20 0 0 20 37.55909527 -98.13638678 2020-08-12 04:27:29 Kingman, Kansas, US
497507 2020-08-11 US Kansas Neosho 20133 65 0 0 65 37.55862897 -95.30670046 2020-08-12 04:27:29 Neosho, Kansas, US
497508 2020-08-11 US Kansas Osage 20139 41 0 0 41 38.65235984 -95.72707998 2020-08-12 04:27:29 Osage, Kansas, US
497509 2020-08-11 US Kansas Reno 20155 286 1 0 285 37.95230263 -98.08607292 2020-08-12 04:27:29 Reno, Kansas, US
497510 2020-08-11 US Kansas Scott 20171 52 0 0 52 38.48222076 -100.9066539 2020-08-12 04:27:29 Scott, Kansas, US
497511 2020-08-11 US Kansas Stafford 20185 6 1 0 5 38.03100851 -98.71762001 2020-08-12 04:27:29 Stafford, Kansas, US
497512 2020-08-11 US Kansas Wyandotte 20209 4959 101 0 4858 39.11727348 -94.76378225 2020-08-12 04:27:29 Wyandotte, Kansas, US
497944 2020-08-11 US Kansas Brown 20013 40 0 0 40 39.82652589 -95.56421698 2020-08-12 04:27:29 Brown, Kansas, US
497945 2020-08-11 US Kansas Cherokee 20021 129 1 0 128 37.16928494 -94.8462897 2020-08-12 04:27:29 Cherokee, Kansas, US
497946 2020-08-11 US Kansas Elk 20049 1 0 0 1 37.45338105 -96.24369667 2020-08-12 04:27:29 Elk, Kansas, US
497947 2020-08-11 US Kansas Ellsworth 20053 21 0 0 21 38.69677695 -98.20462799 2020-08-12 04:27:29 Ellsworth, Kansas, US
497948 2020-08-11 US Kansas Finney 20055 1795 11 0 1784 38.04340344 -100.7381938 2020-08-12 04:27:29 Finney, Kansas, US
497949 2020-08-11 US Kansas Geary 20061 152 2 0 150 38.99871131 -96.7577178 2020-08-12 04:27:29 Geary, Kansas, US
497950 2020-08-11 US Kansas Harvey 20079 204 1 0 203 38.04293782 -97.42747573 2020-08-12 04:27:29 Harvey, Kansas, US
497951 2020-08-11 US Kansas Marshall 20117 10 0 0 10 39.78359669 -96.52278974 2020-08-12 04:27:29 Marshall, Kansas, US
497952 2020-08-11 US Kansas Montgomery 20125 170 5 0 165 37.19236568 -95.74329258 2020-08-12 04:27:29 Montgomery, Kansas, US
497953 2020-08-11 US Kansas Morton 20129 9 2 0 7 37.19141121 -101.79925190000002 2020-08-12 04:27:29 Morton, Kansas, US
497954 2020-08-11 US Kansas Rooks 20163 18 0 0 18 39.35022773 -99.32484567 2020-08-12 04:27:29 Rooks, Kansas, US
497955 2020-08-11 US Kansas Sumner 20191 101 3 0 98 37.23682549 -97.47721621 2020-08-12 04:27:29 Sumner, Kansas, US
497956 2020-08-11 US Kansas Woodson 20207 12 0 0 12 37.8865336 -95.74006277 2020-08-12 04:27:29 Woodson, Kansas, US
498463 2020-08-11 US Kansas Franklin 20059 194 1 0 193 38.56443815 -95.28644341 2020-08-12 04:27:29 Franklin, Kansas, US
498464 2020-08-11 US Kansas Graham 20065 17 0 0 17 39.34987223 -99.88332493 2020-08-12 04:27:29 Graham, Kansas, US
498465 2020-08-11 US Kansas Gray 20069 84 0 0 84 37.73836671 -100.4369088 2020-08-12 04:27:29 Gray, Kansas, US
498466 2020-08-11 US Kansas Hamilton 20075 38 0 0 38 37.99978709 -101.7921066 2020-08-12 04:27:29 Hamilton, Kansas, US
498467 2020-08-11 US Kansas Ottawa 20143 35 0 0 35 39.13237408 -97.65020313 2020-08-12 04:27:29 Ottawa, Kansas, US
498468 2020-08-11 US Kansas Riley 20161 483 5 0 478 39.28935726 -96.73420026 2020-08-12 04:27:29 Riley, Kansas, US
498469 2020-08-11 US Kansas Shawnee 20177 1611 19 0 1592 39.04100763 -95.7557264 2020-08-12 04:27:29 Shawnee, Kansas, US
498470 2020-08-11 US Kansas Trego 20195 6 1 0 5 38.91467218 -99.87284448 2020-08-12 04:27:29 Trego, Kansas, US
498471 2020-08-11 US Kansas Wabaunsee 20197 43 0 0 43 38.95471985 -96.20350509 2020-08-12 04:27:29 Wabaunsee, Kansas, US
498959 2020-08-11 US Kansas Anderson 20003 31 0 0 31 38.21413251 -95.29272815 2020-08-12 04:27:29 Anderson, Kansas, US
498960 2020-08-11 US Kansas Atchison 20005 64 0 0 64 39.53185661 -95.30870026 2020-08-12 04:27:29 Atchison, Kansas, US
498961 2020-08-11 US Kansas Chase 20017 48 0 0 48 38.30292938 -96.59563862 2020-08-12 04:27:29 Chase, Kansas, US
498962 2020-08-11 US Kansas Dickinson 20041 48 1 0 47 38.86600962 -97.15532383 2020-08-12 04:27:29 Dickinson, Kansas, US
498963 2020-08-11 US Kansas Haskell 20081 44 0 0 44 37.5620394 -100.8710738 2020-08-12 04:27:29 Haskell, Kansas, US
498964 2020-08-11 US Kansas Jefferson 20087 76 0 0 76 39.2347941 -95.38289232 2020-08-12 04:27:29 Jefferson, Kansas, US
498965 2020-08-11 US Kansas Lane 20101 5 0 0 5 38.48119447 -100.4660754 2020-08-12 04:27:29 Lane, Kansas, US
498966 2020-08-11 US Kansas Leavenworth 20103 1483 9 0 1474 39.20183497 -95.03620809 2020-08-12 04:27:29 Leavenworth, Kansas, US
498967 2020-08-11 US Kansas Miami 20121 134 0 0 134 38.56383358 -94.83832189 2020-08-12 04:27:29 Miami, Kansas, US
498968 2020-08-11 US Kansas Ness 20135 6 0 0 6 38.47974157 -99.91547333 2020-08-12 04:27:29 Ness, Kansas, US
498969 2020-08-11 US Kansas Phillips 20147 51 8 0 43 39.78465501 -99.34668865 2020-08-12 04:27:29 Phillips, Kansas, US
498970 2020-08-11 US Kansas Pottawatomie 20149 108 0 0 108 39.37925655 -96.34564657 2020-08-12 04:27:29 Pottawatomie, Kansas, US
498971 2020-08-11 US Kansas Pratt 20151 35 0 0 35 37.64780729 -98.73922153 2020-08-12 04:27:29 Pratt, Kansas, US
498972 2020-08-11 US Kansas Saline 20169 384 5 0 379 38.78369175 -97.65185177 2020-08-12 04:27:29 Saline, Kansas, US
498973 2020-08-11 US Kansas Sedgwick 20173 4990 46 0 4944 37.6842718 -97.4608198 2020-08-12 04:27:29 Sedgwick, Kansas, US
498974 2020-08-11 US Kansas Sheridan 20179 7 0 0 7 39.35018161 -100.4418259 2020-08-12 04:27:29 Sheridan, Kansas, US
498975 2020-08-11 US Kansas Thomas 20193 40 0 0 40 39.35107575 -101.0553705 2020-08-12 04:27:29 Thomas, Kansas, US
498976 2020-08-11 US Kansas Wilson 20205 11 0 0 11 37.55937174 -95.74323255 2020-08-12 04:27:29 Wilson, Kansas, US
499440 2020-08-11 US Kansas Hodgeman 20083 11 0 0 11 38.08780079 -99.89829881 2020-08-12 04:27:29 Hodgeman, Kansas, US
499441 2020-08-11 US Kansas Johnson 20091 5869 105 0 5764 38.88548175 -94.82250877 2020-08-12 04:27:29 Johnson, Kansas, US
499442 2020-08-11 US Kansas Meade 20119 45 0 0 45 37.23859987 -100.364831 2020-08-12 04:27:29 Meade, Kansas, US
499443 2020-08-11 US Kansas Norton 20137 23 0 0 23 39.78443827 -99.90286639 2020-08-12 04:27:29 Norton, Kansas, US
499444 2020-08-11 US Kansas Republic 20157 32 0 0 32 39.82799632 -97.65036709 2020-08-12 04:27:29 Republic, Kansas, US
499445 2020-08-11 US Kansas Rush 20165 10 0 0 10 38.52275276 -99.30863983 2020-08-12 04:27:29 Rush, 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]);
Powered by Datasette · Query took 2145.162ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette