daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,022 rows where country_or_region = "Kenya" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, day (date), last_update (date)
country_or_region 1
- Kenya · 1,022 ✖
province_or_state 0
day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-13 | Kenya | 1 | 0 | 0 | -0.0236 | 37.9062 | 2020-03-11T20:00:00 | |||||
2020-03-14 | Kenya | 1 | 0 | 0 | -0.0236 | 37.9062 | 2020-03-13T22:22:03 | |||||
2020-03-15 | Kenya | 3 | 0 | 0 | -0.0236 | 37.9062 | 2020-03-13T22:22:03 | |||||
2020-03-16 | Kenya | 3 | 0 | 0 | -0.0236 | 37.9062 | 2020-03-16T00:22:11 | |||||
2020-03-17 | Kenya | 3 | 0 | 0 | -0.0236 | 37.9062 | 2020-03-16T00:22:11 | |||||
2020-03-18 | Kenya | 3 | 0 | 0 | -0.0236 | 37.9062 | 2020-03-16T00:22:11 | |||||
2020-03-19 | Kenya | 7 | 0 | 0 | -0.0236 | 37.9062 | 2020-03-19T02:33:08 | |||||
2020-03-20 | Kenya | 7 | 0 | 0 | -0.0236 | 37.9062 | 2020-03-19T02:33:08 | |||||
2020-03-21 | Kenya | 7 | 0 | 0 | -0.0236 | 37.9062 | 2020-03-19T02:33:08 | |||||
2020-03-22 | Kenya | 15 | 0 | 0 | 15 | -0.0236 | 37.9062 | 3/22/20 23:45 | Kenya | |||
2020-03-23 | Kenya | 16 | 0 | 0 | 16 | -0.0236 | 37.9062 | 2020-03-23 23:19:21 | Kenya | |||
2020-03-24 | Kenya | 25 | 0 | 0 | 25 | -0.0236 | 37.9062 | 2020-03-24 23:37:15 | Kenya | |||
2020-03-25 | Kenya | 28 | 0 | 1 | 27 | -0.0236 | 37.9062 | 2020-03-25 23:33:04 | Kenya | |||
2020-03-26 | Kenya | 31 | 1 | 1 | 29 | -0.0236 | 37.9062 | 2020-03-26 23:48:18 | Kenya | |||
2020-03-27 | Kenya | 31 | 1 | 1 | 29 | -0.0236 | 37.9062 | 2020-03-27 23:23:03 | Kenya | |||
2020-03-28 | Kenya | 38 | 1 | 1 | 36 | -0.0236 | 37.9062 | 3/28/20 23:05 | Kenya | |||
2020-03-29 | Kenya | 42 | 1 | 1 | 40 | -0.0236 | 37.9062 | 3/29/20 23:08 | Kenya | |||
2020-03-30 | Kenya | 50 | 1 | 1 | 48 | -0.0236 | 37.9062 | 3/30/20 22:52 | Kenya | |||
2020-03-31 | Kenya | 59 | 1 | 1 | 57 | -0.0236 | 37.9062 | 2020-03-31 23:43:43 | Kenya | |||
2020-04-01 | Kenya | 81 | 1 | 3 | 77 | -0.0236 | 37.9062 | 2020-04-01 21:58:34 | Kenya | |||
2020-04-02 | Kenya | 110 | 3 | 4 | 103 | -0.0236 | 37.9062 | 4/2/20 23:25 | Kenya | |||
2020-04-03 | Kenya | 122 | 4 | 4 | 114 | -0.0236 | 37.9062 | 2020-04-03 22:46:20 | Kenya | |||
2020-04-04 | Kenya | 126 | 4 | 4 | 118 | -0.0236 | 37.9062 | 4/4/20 23:34 | Kenya | |||
2020-04-05 | Kenya | 142 | 4 | 4 | 134 | -0.0236 | 37.9062 | 2020-04-05 23:06:26 | Kenya | |||
2020-04-06 | Kenya | 158 | 6 | 4 | 148 | -0.0236 | 37.9062 | 4/6/20 23:21 | Kenya | |||
2020-04-07 | Kenya | 172 | 6 | 7 | 159 | -0.0236 | 37.9062 | 2020-04-07 23:04:29 | Kenya | |||
2020-04-08 | Kenya | 179 | 6 | 9 | 164 | -0.0236 | 37.9062 | 2020-04-08 22:51:39 | Kenya | |||
2020-04-09 | Kenya | 184 | 7 | 12 | 165 | -0.0236 | 37.9062 | 2020-04-09 23:02:19 | Kenya | |||
2020-04-10 | Kenya | 189 | 7 | 22 | 160 | -0.0236 | 37.9062 | 2020-04-10 22:53:48 | Kenya | |||
2020-04-11 | Kenya | 191 | 7 | 24 | 160 | -0.0236 | 37.9062 | 2020-04-11 22:45:13 | Kenya | |||
2020-04-12 | Kenya | 197 | 8 | 25 | 164 | -0.0236 | 37.9062 | 2020-04-12 23:17:00 | Kenya | |||
2020-04-13 | Kenya | 208 | 9 | 40 | 159 | -0.0236 | 37.9062 | 2020-04-13 23:07:34 | Kenya | |||
2020-04-14 | Kenya | 216 | 9 | 41 | 166 | -0.0236 | 37.9062 | 2020-04-14 23:33:12 | Kenya | |||
2020-04-15 | Kenya | 225 | 10 | 53 | 162 | -0.0236 | 37.9062 | 2020-04-15 22:56:32 | Kenya | |||
2020-04-16 | Kenya | 234 | 11 | 53 | 170 | -0.0236 | 37.9062 | 2020-04-16 23:30:31 | Kenya | |||
2020-04-17 | Kenya | 246 | 11 | 53 | 182 | -0.0236 | 37.9062 | 2020-04-17 23:30:32 | Kenya | |||
2020-04-18 | Kenya | 262 | 12 | 60 | 190 | -0.0236 | 37.9062 | 2020-04-18 22:32:28 | Kenya | |||
2020-04-19 | Kenya | 270 | 14 | 67 | 189 | -0.0236 | 37.9062 | 2020-04-19 23:40:41 | Kenya | |||
2020-04-20 | Kenya | 281 | 14 | 69 | 198 | -0.0236 | 37.9062 | 2020-04-20 23:36:27 | Kenya | |||
2020-04-21 | Kenya | 296 | 14 | 74 | 208 | -0.0236 | 37.9062 | 2020-04-21 23:30:30 | Kenya | |||
2020-04-22 | Kenya | 303 | 14 | 74 | 215 | -0.0236 | 37.9062 | 2020-04-22 23:30:32 | Kenya | |||
2020-04-23 | Kenya | 320 | 14 | 89 | 217 | -0.0236 | 37.9062 | 2020-04-24 03:30:31 | Kenya | |||
2020-04-24 | Kenya | 336 | 14 | 94 | 228 | -0.0236 | 37.9062 | 2020-04-25 06:30:33 | Kenya | |||
2020-04-25 | Kenya | 343 | 14 | 98 | 231 | -0.0236 | 37.9062 | 2020-04-26 02:30:31 | Kenya | |||
2020-04-26 | Kenya | 355 | 14 | 106 | 235 | -0.0236 | 37.9062 | 2020-04-27 02:30:33 | Kenya | |||
2020-04-27 | Kenya | 363 | 14 | 114 | 235 | -0.0236 | 37.9062 | 2020-04-28 02:30:32 | Kenya | |||
2020-04-28 | Kenya | 374 | 14 | 124 | 236 | -0.0236 | 37.9062 | 2020-04-29 02:32:29 | Kenya | |||
2020-04-29 | Kenya | 384 | 15 | 129 | 240 | -0.0236 | 37.9062 | 2020-04-30 02:32:27 | Kenya | |||
2020-04-30 | Kenya | 396 | 17 | 144 | 235 | -0.0236 | 37.9062 | 2020-05-01 02:32:28 | Kenya | |||
2020-05-01 | Kenya | 411 | 21 | 150 | 240 | -0.0236 | 37.9062 | 2020-05-02 02:32:27 | Kenya | |||
2020-05-02 | Kenya | 435 | 22 | 152 | 261 | -0.0236 | 37.9062 | 2020-05-03 02:32:28 | Kenya | |||
2020-05-03 | Kenya | 465 | 24 | 167 | 274 | -0.0236 | 37.9062 | 2020-05-04 02:32:28 | Kenya | |||
2020-05-04 | Kenya | 490 | 24 | 173 | 293 | -0.0236 | 37.9062 | 2020-05-05 02:32:34 | Kenya | |||
2020-05-05 | Kenya | 535 | 24 | 182 | 329 | -0.0236 | 37.9062 | 2020-05-06 02:32:31 | Kenya | |||
2020-05-06 | Kenya | 582 | 26 | 190 | 366 | -0.0236 | 37.9062 | 2020-05-07 02:32:28 | Kenya | |||
2020-05-07 | Kenya | 607 | 29 | 197 | 381 | -0.0236 | 37.9062 | 2020-05-08 02:32:32 | Kenya | |||
2020-05-08 | Kenya | 621 | 29 | 202 | 390 | -0.0236 | 37.9062 | 2020-05-09 02:32:35 | Kenya | |||
2020-05-09 | Kenya | 649 | 30 | 207 | 412 | -0.0236 | 37.9062 | 2020-05-10 02:32:30 | Kenya | |||
2020-05-10 | Kenya | 672 | 32 | 239 | 401 | -0.0236 | 37.9062 | 2020-05-11 02:32:30 | Kenya | |||
2020-05-11 | Kenya | 700 | 33 | 251 | 416 | -0.0236 | 37.9062 | 2020-05-12 03:32:27 | Kenya | |||
2020-05-12 | Kenya | 715 | 36 | 259 | 420 | -0.0236 | 37.9062 | 2020-05-13 03:32:26 | Kenya | |||
2020-05-13 | Kenya | 737 | 40 | 281 | 416 | -0.0236 | 37.9062 | 2020-05-14 03:32:28 | Kenya | |||
2020-05-14 | Kenya | 758 | 42 | 284 | 432 | -0.0236 | 37.9062 | 2020-05-15 02:33:02 | Kenya | |||
2020-05-15 | Kenya | 781 | 45 | 284 | 452 | -0.0236 | 37.9062 | 2020-05-16 02:32:19 | Kenya | |||
2020-05-16 | Kenya | 830 | 50 | 301 | 479 | -0.0236 | 37.9062 | 2020-05-17 02:32:32 | Kenya | |||
2020-05-17 | Kenya | 887 | 50 | 313 | 524 | -0.0236 | 37.9062 | 2020-05-18 02:32:21 | Kenya | |||
2020-05-18 | Kenya | 912 | 50 | 336 | 526 | -0.0236 | 37.9062 | 2020-05-19 02:32:18 | Kenya | |||
2020-05-19 | Kenya | 963 | 50 | 358 | 555 | -0.0236 | 37.9062 | 2020-05-20 02:32:19 | Kenya | |||
2020-05-20 | Kenya | 1029 | 50 | 366 | 613 | -0.0236 | 37.9062 | 2020-05-21 02:32:48 | Kenya | |||
2020-05-21 | Kenya | 1109 | 50 | 375 | 684 | -0.0236 | 37.9062 | 2020-05-22 02:36:51 | Kenya | |||
2020-05-22 | Kenya | 1161 | 50 | 380 | 731 | -0.0236 | 37.9062 | 2020-05-23 02:32:42 | Kenya | |||
2020-05-23 | Kenya | 1192 | 50 | 380 | 762 | -0.0236 | 37.9062 | 2020-05-24 02:32:43 | Kenya | |||
2020-05-24 | Kenya | 1214 | 51 | 383 | 780 | -0.0236 | 37.9062 | 2020-05-25 02:32:44 | Kenya | |||
2020-05-25 | Kenya | 1286 | 52 | 402 | 832 | -0.0236 | 37.9062 | 2020-05-26 02:32:35 | Kenya | |||
2020-05-26 | Kenya | 1348 | 52 | 405 | 891 | -0.0236 | 37.9062 | 2020-05-27 02:32:31 | Kenya | |||
2020-05-27 | Kenya | 1471 | 55 | 408 | 1008 | -0.0236 | 37.9062 | 2020-05-28 02:32:31 | Kenya | |||
2020-05-28 | Kenya | 1618 | 58 | 421 | 1139 | -0.0236 | 37.9062 | 2020-05-29 02:32:50 | Kenya | |||
2020-05-29 | Kenya | 1745 | 62 | 438 | 1245 | -0.0236 | 37.9062 | 2020-05-30 02:32:48 | Kenya | |||
2020-05-30 | Kenya | 1888 | 63 | 464 | 1361 | -0.0236 | 37.9062 | 2020-05-31 02:32:45 | Kenya | |||
2020-05-31 | Kenya | 1962 | 64 | 478 | 1420 | -0.0236 | 37.9062 | 2020-06-01 02:32:46 | Kenya | |||
2020-06-01 | Kenya | 2021 | 69 | 482 | 1470 | -0.0236 | 37.9062 | 2020-06-02 02:33:08 | Kenya | |||
2020-06-02 | Kenya | 2093 | 71 | 499 | 1523 | -0.0236 | 37.9062 | 2020-06-03 02:33:13 | Kenya | |||
2020-06-03 | Kenya | 2216 | 74 | 553 | 1589 | -0.0236 | 37.9062 | 2020-06-04 02:33:14 | Kenya | |||
2020-06-04 | Kenya | 2340 | 78 | 592 | 1670 | -0.0236 | 37.9062 | 2020-06-05 02:33:06 | Kenya | |||
2020-06-05 | Kenya | 2474 | 79 | 643 | 1752 | -0.0236 | 37.9062 | 2020-06-06 02:33:00 | Kenya | |||
2020-06-06 | Kenya | 2600 | 83 | 706 | 1811 | -0.0236 | 37.9062 | 2020-06-07 03:53:30 | Kenya | |||
2020-06-07 | Kenya | 2767 | 84 | 752 | 1931 | -0.0236 | 37.9062 | 2020-06-08 03:33:22 | Kenya | |||
2020-06-08 | Kenya | 2872 | 85 | 849 | 1938 | -0.0236 | 37.9062 | 2020-06-09 03:33:03 | Kenya | |||
2020-06-09 | Kenya | 2989 | 88 | 873 | 2028 | -0.0236 | 37.9062 | 2020-06-10 04:07:00 | Kenya | |||
2020-06-10 | Kenya | 3094 | 89 | 1048 | 1957 | -0.0236 | 37.9062 | 2020-06-11 03:33:41 | Kenya | |||
2020-06-11 | Kenya | 3215 | 92 | 1092 | 2031 | -0.0236 | 37.9062 | 2020-06-12 05:09:52 | Kenya | |||
2020-06-12 | Kenya | 3305 | 96 | 1164 | 2045 | -0.0236 | 37.9062 | 2020-06-13 03:33:14 | Kenya | |||
2020-06-13 | Kenya | 3457 | 100 | 1221 | 2136 | -0.0236 | 37.9062 | 2020-06-14 03:33:15 | Kenya | |||
2020-06-14 | Kenya | 3594 | 103 | 1253 | 2238 | -0.0236 | 37.9062 | 2020-06-15 03:33:14 | Kenya | |||
2020-06-15 | Kenya | 3727 | 104 | 1286 | 2337 | -0.0236 | 37.9062 | 2020-06-16 04:33:09 | Kenya | |||
2020-06-16 | Kenya | 3860 | 105 | 1328 | 2427 | -0.0236 | 37.9062 | 2020-06-17 04:33:21 | Kenya | |||
2020-06-17 | Kenya | 4044 | 107 | 1353 | 2584 | -0.0236 | 37.9062 | 2020-06-18 04:33:18 | Kenya | |||
2020-06-18 | Kenya | 4257 | 117 | 1459 | 2681 | -0.0236 | 37.9062 | 2020-06-19 04:33:17 | Kenya | |||
2020-06-19 | Kenya | 4374 | 119 | 1550 | 2705 | -0.0236 | 37.9062 | 2020-06-20 04:33:19 | Kenya | |||
2020-06-20 | Kenya | 4478 | 121 | 1586 | 2771 | -0.0236 | 37.9062 | 2020-06-21 04:33:19 | Kenya |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;