johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
81 rows where active = 58, country_or_region = "US" and province_or_state = "Kansas" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2538666 | 2538666 | 2020-12-01 | US | Kansas | Elk | 20049 | 58 | 0 | 0 | 58 | 37.45338105 | -96.24369667 | 2020-12-02 05:27:41 | Elk, Kansas, US |
1585435 | 1585435 | 2020-11-30 | US | Kansas | Elk | 20049 | 58 | 0 | 0 | 58 | 37.45338105 | -96.24369667 | 2020-12-01 05:26:18 | Elk, Kansas, US |
1178786 | 1178786 | 2020-10-22 | US | Kansas | Kiowa | 20097 | 58 | 0 | 0 | 58 | 37.55848695 | -99.2856537 | 2020-10-23 04:24:46 | Kiowa, Kansas, US |
80387 | 80387 | 2020-10-14 | US | Kansas | Marshall | 20117 | 58 | 0 | 0 | 58 | 39.78359669 | -96.52278974 | 2020-10-15 04:24:28 | Marshall, Kansas, US |
3783202 | 3783202 | 2020-10-13 | US | Kansas | Marshall | 20117 | 58 | 0 | 0 | 58 | 39.78359669 | -96.52278974 | 2020-10-14 04:24:05 | Marshall, Kansas, US |
2292697 | 2292697 | 2020-10-12 | US | Kansas | Clark | 20025 | 59 | 1 | 0 | 58 | 37.23577007 | -99.81883015 | 2020-10-13 04:24:02 | Clark, Kansas, US |
3787149 | 3787149 | 2020-10-11 | US | Kansas | Clark | 20025 | 59 | 1 | 0 | 58 | 37.23577007 | -99.81883015 | 2020-10-12 04:23:45 | Clark, Kansas, US |
2603311 | 2603311 | 2020-10-10 | US | Kansas | Greenwood | 20073 | 58 | 0 | 0 | 58 | 37.8774388 | -96.23250453 | 2020-10-11 04:23:46 | Greenwood, Kansas, US |
818844 | 818844 | 2020-10-09 | US | Kansas | Greenwood | 20073 | 58 | 0 | 0 | 58 | 37.8774388 | -96.23250453 | 2020-10-10 04:23:57 | Greenwood, Kansas, US |
2380968 | 2380968 | 2020-10-01 | US | Kansas | Trego | 20195 | 61 | 3 | 0 | 58 | 38.91467218 | -99.87284448 | 2020-10-02 04:23:51 | Trego, Kansas, US |
1047083 | 1047083 | 2020-09-30 | US | Kansas | Ellsworth | 20053 | 58 | 0 | 0 | 58 | 38.69677695 | -98.20462799 | 2020-10-01 04:23:42 | Ellsworth, Kansas, US |
1047128 | 1047128 | 2020-09-30 | US | Kansas | Ottawa | 20143 | 58 | 0 | 0 | 58 | 39.13237408 | -97.65020313 | 2020-10-01 04:23:42 | Ottawa, Kansas, US |
1047149 | 1047149 | 2020-09-30 | US | Kansas | Stafford | 20185 | 59 | 1 | 0 | 58 | 38.03100851 | -98.71762001 | 2020-10-01 04:23:42 | Stafford, Kansas, US |
1047154 | 1047154 | 2020-09-30 | US | Kansas | Trego | 20195 | 61 | 3 | 0 | 58 | 38.91467218 | -99.87284448 | 2020-10-01 04:23:42 | Trego, Kansas, US |
968164 | 968164 | 2020-09-29 | US | Kansas | Ellsworth | 20053 | 58 | 0 | 0 | 58 | 38.69677695 | -98.20462799 | 2020-09-30 04:23:33 | Ellsworth, Kansas, US |
968209 | 968209 | 2020-09-29 | US | Kansas | Ottawa | 20143 | 58 | 0 | 0 | 58 | 39.13237408 | -97.65020313 | 2020-09-30 04:23:33 | Ottawa, Kansas, US |
968230 | 968230 | 2020-09-29 | US | Kansas | Stafford | 20185 | 59 | 1 | 0 | 58 | 38.03100851 | -98.71762001 | 2020-09-30 04:23:33 | Stafford, Kansas, US |
2607278 | 2607278 | 2020-09-24 | US | Kansas | Cheyenne | 20023 | 58 | 0 | 0 | 58 | 39.78580976 | -101.7318201 | 2020-09-25 04:23:00 | Cheyenne, Kansas, US |
2655021 | 2655021 | 2020-09-23 | US | Kansas | Cheyenne | 20023 | 58 | 0 | 0 | 58 | 39.78580976 | -101.7318201 | 2020-09-24 04:23:00 | Cheyenne, Kansas, US |
2456079 | 2456079 | 2020-09-19 | US | Kansas | Ness | 20135 | 64 | 6 | 0 | 58 | 38.47974157 | -99.91547333 | 2020-09-20 04:22:00 | Ness, Kansas, US |
2850148 | 2850148 | 2020-09-18 | US | Kansas | Ness | 20135 | 64 | 6 | 0 | 58 | 38.47974157 | -99.91547333 | 2020-09-19 04:22:00 | Ness, Kansas, US |
2730323 | 2730323 | 2020-09-15 | US | Kansas | Rice | 20159 | 59 | 1 | 0 | 58 | 38.34616184 | -98.19992118 | 2020-09-16 04:22:53 | Rice, Kansas, US |
345595 | 345595 | 2020-09-14 | US | Kansas | Rice | 20159 | 59 | 1 | 0 | 58 | 38.34616184 | -98.19992118 | 2020-09-15 03:22:50 | Rice, Kansas, US |
2870030 | 2870030 | 2020-09-13 | US | Kansas | Pratt | 20151 | 58 | 0 | 0 | 58 | 37.64780729 | -98.73922153 | 2020-09-14 04:26:00 | Pratt, Kansas, US |
548069 | 548069 | 2020-09-12 | US | Kansas | Pratt | 20151 | 58 | 0 | 0 | 58 | 37.64780729 | -98.73922153 | 2020-09-13 04:30:52 | Pratt, Kansas, US |
1445898 | 1445898 | 2020-09-11 | US | Kansas | Pratt | 20151 | 58 | 0 | 0 | 58 | 37.64780729 | -98.73922153 | 2020-09-12 04:25:05 | Pratt, Kansas, US |
1355656 | 1355656 | 2020-09-03 | US | Kansas | Wabaunsee | 20197 | 58 | 0 | 0 | 58 | 38.95471985 | -96.20350509 | 2020-09-04 04:28:26 | Wabaunsee, Kansas, US |
1106893 | 1106893 | 2020-09-02 | US | Kansas | Wabaunsee | 20197 | 58 | 0 | 0 | 58 | 38.95471985 | -96.20350509 | 2020-09-03 04:28:22 | Wabaunsee, Kansas, US |
1997906 | 1997906 | 2020-08-26 | US | Kansas | Doniphan | 20043 | 58 | 0 | 0 | 58 | 39.79067154 | -95.14056866 | 2020-08-27 04:28:15 | Doniphan, Kansas, US |
3563830 | 3563830 | 2020-08-25 | US | Kansas | Doniphan | 20043 | 58 | 0 | 0 | 58 | 39.79067154 | -95.14056866 | 2020-08-26 04:28:11 | Doniphan, Kansas, US |
3563868 | 3563868 | 2020-08-25 | US | Kansas | Meade | 20119 | 58 | 0 | 0 | 58 | 37.23859987 | -100.364831 | 2020-08-26 04:28:11 | Meade, Kansas, US |
2992534 | 2992534 | 2020-08-24 | US | Kansas | Doniphan | 20043 | 58 | 0 | 0 | 58 | 39.79067154 | -95.14056866 | 2020-08-25 04:28:02 | Doniphan, Kansas, US |
2992572 | 2992572 | 2020-08-24 | US | Kansas | Meade | 20119 | 58 | 0 | 0 | 58 | 37.23859987 | -100.364831 | 2020-08-25 04:28:02 | Meade, Kansas, US |
2216916 | 2216916 | 2020-08-23 | US | Kansas | Chase | 20017 | 58 | 0 | 0 | 58 | 38.30292938 | -96.59563862 | 2020-08-24 04:27:56 | Chase, Kansas, US |
2216929 | 2216929 | 2020-08-23 | US | Kansas | Doniphan | 20043 | 58 | 0 | 0 | 58 | 39.79067154 | -95.14056866 | 2020-08-24 04:27:56 | Doniphan, Kansas, US |
2216967 | 2216967 | 2020-08-23 | US | Kansas | Meade | 20119 | 58 | 0 | 0 | 58 | 37.23859987 | -100.364831 | 2020-08-24 04:27:56 | Meade, Kansas, US |
2300698 | 2300698 | 2020-08-22 | US | Kansas | Chase | 20017 | 58 | 0 | 0 | 58 | 38.30292938 | -96.59563862 | 2020-08-23 04:27:48 | Chase, Kansas, US |
2300711 | 2300711 | 2020-08-22 | US | Kansas | Doniphan | 20043 | 58 | 0 | 0 | 58 | 39.79067154 | -95.14056866 | 2020-08-23 04:27:48 | Doniphan, Kansas, US |
2300749 | 2300749 | 2020-08-22 | US | Kansas | Meade | 20119 | 58 | 0 | 0 | 58 | 37.23859987 | -100.364831 | 2020-08-23 04:27:48 | Meade, Kansas, US |
1480804 | 1480804 | 2020-08-21 | US | Kansas | Chase | 20017 | 58 | 0 | 0 | 58 | 38.30292938 | -96.59563862 | 2020-08-22 04:27:49 | Chase, Kansas, US |
1480817 | 1480817 | 2020-08-21 | US | Kansas | Doniphan | 20043 | 58 | 0 | 0 | 58 | 39.79067154 | -95.14056866 | 2020-08-22 04:27:49 | Doniphan, Kansas, US |
1480855 | 1480855 | 2020-08-21 | US | Kansas | Meade | 20119 | 58 | 0 | 0 | 58 | 37.23859987 | -100.364831 | 2020-08-22 04:27:49 | Meade, Kansas, US |
3485553 | 3485553 | 2020-08-20 | US | Kansas | Chase | 20017 | 58 | 0 | 0 | 58 | 38.30292938 | -96.59563862 | 2020-08-21 04:27:41 | Chase, Kansas, US |
3485566 | 3485566 | 2020-08-20 | US | Kansas | Doniphan | 20043 | 58 | 0 | 0 | 58 | 39.79067154 | -95.14056866 | 2020-08-21 04:27:41 | Doniphan, Kansas, US |
3485601 | 3485601 | 2020-08-20 | US | Kansas | Marion | 20115 | 59 | 1 | 0 | 58 | 38.35855394 | -97.0985251 | 2020-08-21 04:27:41 | Marion, Kansas, US |
207502 | 207502 | 2020-08-19 | US | Kansas | Chase | 20017 | 58 | 0 | 0 | 58 | 38.30292938 | -96.59563862 | 2020-08-20 04:27:43 | Chase, Kansas, US |
207515 | 207515 | 2020-08-19 | US | Kansas | Doniphan | 20043 | 58 | 0 | 0 | 58 | 39.79067154 | -95.14056866 | 2020-08-20 04:27:43 | Doniphan, Kansas, US |
207550 | 207550 | 2020-08-19 | US | Kansas | Marion | 20115 | 59 | 1 | 0 | 58 | 38.35855394 | -97.0985251 | 2020-08-20 04:27:43 | Marion, Kansas, US |
3179256 | 3179256 | 2020-08-18 | US | Kansas | Chase | 20017 | 58 | 0 | 0 | 58 | 38.30292938 | -96.59563862 | 2020-08-19 04:27:00 | Chase, Kansas, US |
3179304 | 3179304 | 2020-08-18 | US | Kansas | Marion | 20115 | 59 | 1 | 0 | 58 | 38.35855394 | -97.0985251 | 2020-08-19 04:27:00 | Marion, Kansas, US |
838860 | 838860 | 2020-08-17 | US | Kansas | Chase | 20017 | 58 | 0 | 0 | 58 | 38.30292938 | -96.59563862 | 2020-08-18 04:27:56 | Chase, Kansas, US |
838908 | 838908 | 2020-08-17 | US | Kansas | Marion | 20115 | 59 | 1 | 0 | 58 | 38.35855394 | -97.0985251 | 2020-08-18 04:27:56 | Marion, Kansas, US |
1557266 | 1557266 | 2020-08-16 | US | Kansas | Marion | 20115 | 59 | 1 | 0 | 58 | 38.35855394 | -97.0985251 | 2020-08-17 04:27:20 | Marion, Kansas, US |
147268 | 147268 | 2020-08-15 | US | Kansas | Marion | 20115 | 59 | 1 | 0 | 58 | 38.35855394 | -97.0985251 | 2020-08-16 04:27:42 | Marion, Kansas, US |
3921223 | 3921223 | 2020-08-09 | US | Kansas | Kearny | 20093 | 59 | 1 | 0 | 58 | 38.00017981 | -101.321681 | 2020-08-10 04:34:55 | Kearny, Kansas, US |
3921807 | 3921807 | 2020-08-09 | US | Kansas | Neosho | 20133 | 58 | 0 | 0 | 58 | 37.55862897 | -95.30670046 | 2020-08-10 04:34:55 | Neosho, Kansas, US |
369391 | 369391 | 2020-08-08 | US | Kansas | Kearny | 20093 | 59 | 1 | 0 | 58 | 38.00017981 | -101.321681 | 2020-08-09 04:34:54 | Kearny, Kansas, US |
369975 | 369975 | 2020-08-08 | US | Kansas | Neosho | 20133 | 58 | 0 | 0 | 58 | 37.55862897 | -95.30670046 | 2020-08-09 04:34:54 | Neosho, Kansas, US |
456575 | 456575 | 2020-08-07 | US | Kansas | Kearny | 20093 | 59 | 1 | 0 | 58 | 38.00017981 | -101.321681 | 2020-08-08 04:34:53 | Kearny, Kansas, US |
457159 | 457159 | 2020-08-07 | US | Kansas | Neosho | 20133 | 58 | 0 | 0 | 58 | 37.55862897 | -95.30670046 | 2020-08-08 04:34:53 | Neosho, Kansas, US |
841552 | 841552 | 2020-07-22 | US | Kansas | Bourbon | 20011 | 59 | 1 | 0 | 58 | 37.85508555 | -94.84865997 | 2020-07-23 05:15:04 | Bourbon, Kansas, US |
1704292 | 1704292 | 2020-07-21 | US | Kansas | Bourbon | 20011 | 59 | 1 | 0 | 58 | 37.85508555 | -94.84865997 | 2020-07-22 04:34:42 | Bourbon, Kansas, US |
323866 | 323866 | 2020-07-20 | US | Kansas | Bourbon | 20011 | 59 | 1 | 0 | 58 | 37.85508555 | -94.84865997 | 2020-07-21 04:38:46 | Bourbon, Kansas, US |
2705676 | 2705676 | 2020-07-17 | US | Kansas | Cherokee | 20021 | 59 | 1 | 0 | 58 | 37.16928494 | -94.8462897 | 2020-07-18 04:34:45 | Cherokee, Kansas, US |
364495 | 364495 | 2020-07-16 | US | Kansas | Cherokee | 20021 | 59 | 1 | 0 | 58 | 37.16928494 | -94.8462897 | 2020-07-17 04:34:50 | Cherokee, Kansas, US |
2745164 | 2745164 | 2020-07-15 | US | Kansas | Cherokee | 20021 | 59 | 1 | 0 | 58 | 37.16928494 | -94.8462897 | 2020-07-16 04:44:59 | Cherokee, Kansas, US |
2305397 | 2305397 | 2020-06-28 | US | Kansas | Pottawatomie | 20149 | 58 | 0 | 0 | 58 | 39.37925655 | -96.34564657 | 2020-06-29 04:33:44 | Pottawatomie, Kansas, US |
2038732 | 2038732 | 2020-06-27 | US | Kansas | Pottawatomie | 20149 | 58 | 0 | 0 | 58 | 39.37925655 | -96.34564657 | 2020-06-28 04:34:04 | Pottawatomie, Kansas, US |
1135013 | 1135013 | 2020-06-26 | US | Kansas | Pottawatomie | 20149 | 58 | 0 | 0 | 58 | 39.37925655 | -96.34564657 | 2020-06-27 04:33:35 | Pottawatomie, Kansas, US |
2699720 | 2699720 | 2020-06-24 | US | Kansas | Reno | 20155 | 58 | 0 | 0 | 58 | 37.95230263 | -98.08607292 | 2020-06-25 05:26:54 | Reno, Kansas, US |
1521408 | 1521408 | 2020-06-23 | US | Kansas | Reno | 20155 | 58 | 0 | 0 | 58 | 37.95230263 | -98.08607292 | 2020-06-24 04:33:28 | Reno, Kansas, US |
1507914 | 1507914 | 2020-06-22 | US | Kansas | Cowley | 20035 | 59 | 1 | 0 | 58 | 37.23781842 | -96.83776647 | 2020-06-23 04:33:22 | Cowley, Kansas, US |
1402133 | 1402133 | 2020-05-14 | US | Kansas | Douglas | 20045 | 58 | 0 | 0 | 58 | 38.88503636 | -95.2925121 | 2020-05-15 02:33:02 | Douglas, Kansas, US |
1403634 | 1403634 | 2020-05-14 | US | Kansas | Riley | 20161 | 59 | 1 | 0 | 58 | 39.28935726 | -96.73420026 | 2020-05-15 02:33:02 | Riley, Kansas, US |
3844950 | 3844950 | 2020-05-13 | US | Kansas | Douglas | 20045 | 58 | 0 | 0 | 58 | 38.88503636 | -95.2925121 | 2020-05-14 03:32:28 | Douglas, Kansas, US |
3846451 | 3846451 | 2020-05-13 | US | Kansas | Riley | 20161 | 59 | 1 | 0 | 58 | 39.28935726 | -96.73420026 | 2020-05-14 03:32:28 | Riley, Kansas, US |
2579158 | 2579158 | 2020-05-12 | US | Kansas | Douglas | 20045 | 58 | 0 | 0 | 58 | 38.88503636 | -95.2925121 | 2020-05-13 03:32:26 | Douglas, Kansas, US |
3330192 | 3330192 | 2020-05-11 | US | Kansas | Riley | 20161 | 58 | 0 | 0 | 58 | 39.28935726 | -96.73420026 | 2020-05-12 03:32:27 | Riley, Kansas, US |
3458807 | 3458807 | 2020-05-10 | US | Kansas | Riley | 20161 | 58 | 0 | 0 | 58 | 39.28935726 | -96.73420026 | 2020-05-11 02:32:30 | Riley, Kansas, US |
3560662 | 3560662 | 2020-04-08 | US | Kansas | Leavenworth | 20103 | 59 | 1 | 0 | 58 | 39.20183497 | -95.03620809 | 2020-04-08 22:51:58 | Leavenworth, Kansas, US |
917337 | 917337 | 2020-03-26 | US | Kansas | Johnson | 20091 | 59 | 1 | 0 | 58 | 38.88548175 | -94.82250877 | 2020-03-26 23:48:35 | Johnson, Kansas, US |
Advanced export
JSON shape: default, array, newline-delimited
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] TEXT, [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]);