johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,005 rows where country_or_region = "Botswana" sorted by recovered
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, day (date), last_update (date)
country_or_region 1
- Botswana · 1,005 ✖
province_or_state 0
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered ▼ | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41 | 41 | 2021-12-02 | Botswana | 195302 | 2419 | 0 | -22.3285 | 24.6849 | 2021-12-03 04:23:05 | Botswana | ||||
4057 | 4057 | 2021-10-28 | Botswana | 186594 | 2406 | 0 | -22.3285 | 24.6849 | 2021-10-29 04:22:03 | Botswana | ||||
16082 | 16082 | 2021-09-18 | Botswana | 172252 | 2343 | 0 | -22.3285 | 24.6849 | 2021-09-19 04:21:34 | Botswana | ||||
24112 | 24112 | 2022-03-20 | Botswana | 263950 | 2619 | 0 | -22.3285 | 24.6849 | 2022-03-21 04:20:50 | Botswana | ||||
28127 | 28127 | 2021-11-11 | Botswana | 193701 | 2411 | 0 | -22.3285 | 24.6849 | 2021-11-12 04:22:01 | Botswana | ||||
32143 | 32143 | 2021-08-25 | Botswana | 150842 | 2171 | 0 | -22.3285 | 24.6849 | 2021-08-26 04:21:28 | Botswana | ||||
43183 | 43183 | 2020-04-13 | Botswana | 13 | 1 | 0 | 12 | -22.3285 | 24.6849 | 2020-04-13 23:07:34 | Botswana | |||
43419 | 43419 | 2021-11-02 | Botswana | 187281 | 2407 | 0 | -22.3285 | 24.6849 | 2021-11-03 06:22:09 | Botswana | ||||
50282 | 50282 | 2020-04-17 | Botswana | 15 | 1 | 0 | 14 | -22.3285 | 24.6849 | 2020-04-17 23:30:32 | Botswana | |||
62773 | 62773 | 2022-11-12 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-11-13 04:21:14 | Botswana | ||||
66788 | 66788 | 2021-09-01 | Botswana | 156927 | 2261 | 0 | -22.3285 | 24.6849 | 2021-09-02 04:21:15 | Botswana | ||||
70802 | 70802 | 2022-02-07 | Botswana | 257167 | 2593 | 0 | -22.3285 | 24.6849 | 2022-02-08 04:21:15 | Botswana | ||||
86836 | 86836 | 2021-11-09 | Botswana | 193449 | 2409 | 0 | -22.3285 | 24.6849 | 2021-11-10 04:21:38 | Botswana | ||||
90853 | 90853 | 2022-07-23 | Botswana | 325181 | 2763 | 0 | -22.3285 | 24.6849 | 2022-07-24 04:20:47 | Botswana | ||||
99037 | 99037 | 2022-01-14 | Botswana | 237678 | 2514 | 0 | -22.3285 | 24.6849 | 2022-01-15 04:21:07 | Botswana | ||||
103053 | 103053 | 2021-08-15 | Botswana | 136758 | 1973 | 0 | -22.3285 | 24.6849 | 2021-08-16 04:21:31 | Botswana | ||||
114463 | 114463 | 2022-09-06 | Botswana | 325911 | 2778 | 0 | -22.3285 | 24.6849 | 2022-09-07 04:20:59 | Botswana | ||||
126444 | 126444 | 2022-01-09 | Botswana | 229855 | 2475 | 0 | -22.3285 | 24.6849 | 2022-01-10 04:22:07 | Botswana | ||||
130461 | 130461 | 2022-10-04 | Botswana | 326329 | 2789 | 0 | -22.3285 | 24.6849 | 2022-10-05 04:23:06 | Botswana | ||||
137682 | 137682 | 2021-12-04 | Botswana | 195302 | 2419 | 0 | -22.3285 | 24.6849 | 2021-12-05 04:22:25 | Botswana | ||||
141699 | 141699 | 2022-07-09 | Botswana | 324154 | 2753 | 0 | -22.3285 | 24.6849 | 2022-07-10 04:20:54 | Botswana | ||||
149695 | 149695 | 2021-11-29 | Botswana | 195068 | 2418 | 0 | -22.3285 | 24.6849 | 2021-11-30 04:22:53 | Botswana | ||||
157724 | 157724 | 2022-03-29 | Botswana | 263950 | 2619 | 0 | -22.3285 | 24.6849 | 2022-03-30 04:20:45 | Botswana | ||||
161739 | 161739 | 2021-11-19 | Botswana | 194445 | 2416 | 0 | -22.3285 | 24.6849 | 2021-11-20 04:22:17 | Botswana | ||||
165756 | 165756 | 2022-06-21 | Botswana | 318528 | 2719 | 0 | -22.3285 | 24.6849 | 2022-06-22 04:20:54 | Botswana | ||||
177753 | 177753 | 2021-09-02 | Botswana | 159317 | 2276 | 0 | -22.3285 | 24.6849 | 2021-09-03 04:21:20 | Botswana | ||||
185782 | 185782 | 2022-02-13 | Botswana | 259655 | 2597 | 0 | -22.3285 | 24.6849 | 2022-02-14 04:20:51 | Botswana | ||||
197970 | 197970 | 2022-10-19 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-10-20 04:22:59 | Botswana | ||||
217691 | 217691 | 2022-12-26 | Botswana | 327511 | 2794 | 0 | -22.3285 | 24.6849 | 2022-12-27 04:21:07 | Botswana | ||||
221707 | 221707 | 2022-05-09 | Botswana | 306200 | 2690 | 0 | -22.3285 | 24.6849 | 2022-05-10 04:20:50 | Botswana | ||||
228938 | 228938 | 2022-05-31 | Botswana | 308126 | 2697 | 0 | -22.3285 | 24.6849 | 2022-06-01 04:20:55 | Botswana | ||||
232954 | 232954 | 2022-02-11 | Botswana | 259655 | 2597 | 0 | -22.3285 | 24.6849 | 2022-02-12 04:21:06 | Botswana | ||||
244996 | 244996 | 2021-08-17 | Botswana | 142380 | 2043 | 0 | -22.3285 | 24.6849 | 2021-08-18 04:21:35 | Botswana | ||||
249010 | 249010 | 2021-09-04 | Botswana | 159317 | 2276 | 0 | -22.3285 | 24.6849 | 2021-09-05 04:21:33 | Botswana | ||||
253025 | 253025 | 2022-09-08 | Botswana | 325911 | 2778 | 0 | -22.3285 | 24.6849 | 2022-09-09 04:21:11 | Botswana | ||||
257041 | 257041 | 2022-12-10 | Botswana | 326800 | 2793 | 0 | -22.3285 | 24.6849 | 2022-12-11 04:20:50 | Botswana | ||||
261244 | 261244 | 2022-03-15 | Botswana | 263950 | 2619 | 0 | -22.3285 | 24.6849 | 2022-03-16 04:20:50 | Botswana | ||||
271660 | 271660 | 2020-04-28 | Botswana | 23 | 1 | 0 | 22 | -22.3285 | 24.6849 | 2020-04-29 02:32:29 | Botswana | |||
275894 | 275894 | 2021-11-03 | Botswana | 187281 | 2407 | 0 | -22.3285 | 24.6849 | 2021-11-04 04:22:20 | Botswana | ||||
287707 | 287707 | 2021-10-31 | Botswana | 186594 | 2406 | 0 | -22.3285 | 24.6849 | 2021-11-01 04:22:01 | Botswana | ||||
291724 | 291724 | 2022-11-15 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-11-16 04:21:09 | Botswana | ||||
303580 | 303580 | 2022-04-16 | Botswana | 305859 | 2688 | 0 | -22.3285 | 24.6849 | 2022-04-17 04:20:59 | Botswana | ||||
307596 | 307596 | 2022-12-13 | Botswana | 327061 | 2793 | 0 | -22.3285 | 24.6849 | 2022-12-14 04:21:04 | Botswana | ||||
311612 | 311612 | 2022-11-13 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-11-14 04:21:09 | Botswana | ||||
315628 | 315628 | 2022-02-12 | Botswana | 259655 | 2597 | 0 | -22.3285 | 24.6849 | 2022-02-13 04:21:00 | Botswana | ||||
319644 | 319644 | 2022-10-30 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-10-31 04:21:36 | Botswana | ||||
327618 | 327618 | 2022-12-27 | Botswana | 327511 | 2794 | 0 | -22.3285 | 24.6849 | 2022-12-28 04:21:04 | Botswana | ||||
335648 | 335648 | 2022-03-18 | Botswana | 263950 | 2619 | 0 | -22.3285 | 24.6849 | 2022-03-19 04:20:47 | Botswana | ||||
348008 | 348008 | 2022-12-14 | Botswana | 327061 | 2793 | 0 | -22.3285 | 24.6849 | 2022-12-15 04:20:58 | Botswana | ||||
356038 | 356038 | 2022-03-11 | Botswana | 263950 | 2619 | 0 | -22.3285 | 24.6849 | 2022-03-12 04:20:50 | Botswana | ||||
360054 | 360054 | 2022-05-07 | Botswana | 306200 | 2690 | 0 | -22.3285 | 24.6849 | 2022-05-08 04:20:49 | Botswana | ||||
371908 | 371908 | 2022-09-13 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-14 04:20:44 | Botswana | ||||
383935 | 383935 | 2022-09-23 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-24 04:21:40 | Botswana | ||||
395976 | 395976 | 2022-10-07 | Botswana | 326329 | 2789 | 0 | -22.3285 | 24.6849 | 2022-10-08 04:22:56 | Botswana | ||||
404005 | 404005 | 2021-12-07 | Botswana | 195552 | 2420 | 0 | -22.3285 | 24.6849 | 2021-12-08 04:22:46 | Botswana | ||||
418810 | 418810 | 2020-04-18 | Botswana | 15 | 1 | 0 | 14 | -22.3285 | 24.6849 | 2020-04-18 22:32:28 | Botswana | |||
419047 | 419047 | 2022-09-18 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-19 04:21:49 | Botswana | ||||
423062 | 423062 | 2021-10-10 | Botswana | 180438 | 2376 | 0 | -22.3285 | 24.6849 | 2021-10-11 04:21:31 | Botswana | ||||
431069 | 431069 | 2022-11-03 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-11-04 04:22:11 | Botswana | ||||
443066 | 443066 | 2021-10-20 | Botswana | 184051 | 2389 | 0 | -22.3285 | 24.6849 | 2021-10-21 04:21:18 | Botswana | ||||
447082 | 447082 | 2021-11-17 | Botswana | 194129 | 2416 | 0 | -22.3285 | 24.6849 | 2021-11-18 04:21:33 | Botswana | ||||
451099 | 451099 | 2022-12-21 | Botswana | 327511 | 2794 | 0 | -22.3285 | 24.6849 | 2022-12-22 04:20:56 | Botswana | ||||
459091 | 459091 | 2022-02-02 | Botswana | 253036 | 2581 | 0 | -22.3285 | 24.6849 | 2022-02-03 04:21:21 | Botswana | ||||
463108 | 463108 | 2022-05-02 | Botswana | 305984 | 2688 | 0 | -22.3285 | 24.6849 | 2022-05-03 04:21:00 | Botswana | ||||
467123 | 467123 | 2021-10-07 | Botswana | 180438 | 2376 | 0 | -22.3285 | 24.6849 | 2021-10-08 04:21:25 | Botswana | ||||
475154 | 475154 | 2022-06-26 | Botswana | 318528 | 2719 | 0 | -22.3285 | 24.6849 | 2022-06-27 04:21:00 | Botswana | ||||
479302 | 479302 | 2022-11-08 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-11-09 04:21:22 | Botswana | ||||
487332 | 487332 | 2022-11-25 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-11-26 04:21:11 | Botswana | ||||
491347 | 491347 | 2021-10-14 | Botswana | 181856 | 2386 | 0 | -22.3285 | 24.6849 | 2021-10-15 04:21:26 | Botswana | ||||
495363 | 495363 | 2021-11-06 | Botswana | 192935 | 2407 | 0 | -22.3285 | 24.6849 | 2021-11-07 04:21:53 | Botswana | ||||
499380 | 499380 | 2022-04-02 | Botswana | 305526 | 2686 | 0 | -22.3285 | 24.6849 | 2022-04-03 04:20:48 | Botswana | ||||
503396 | 503396 | 2022-12-17 | Botswana | 327511 | 2794 | 0 | -22.3285 | 24.6849 | 2022-12-18 04:21:03 | Botswana | ||||
507411 | 507411 | 2021-08-14 | Botswana | 136758 | 1973 | 0 | -22.3285 | 24.6849 | 2021-08-15 04:21:41 | Botswana | ||||
511425 | 511425 | 2021-08-19 | Botswana | 146461 | 2081 | 0 | -22.3285 | 24.6849 | 2021-08-20 04:21:33 | Botswana | ||||
515440 | 515440 | 2022-10-15 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-10-16 04:22:39 | Botswana | ||||
522348 | 522348 | 2020-04-21 | Botswana | 20 | 1 | 0 | 19 | -22.3285 | 24.6849 | 2020-04-21 23:30:30 | Botswana | |||
534447 | 534447 | 2021-10-27 | Botswana | 185985 | 2402 | 0 | -22.3285 | 24.6849 | 2021-10-28 04:22:08 | Botswana | ||||
538464 | 538464 | 2022-10-26 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-10-27 04:22:01 | Botswana | ||||
542480 | 542480 | 2022-12-15 | Botswana | 327061 | 2793 | 0 | -22.3285 | 24.6849 | 2022-12-16 04:21:01 | Botswana | ||||
550485 | 550485 | 2021-12-08 | Botswana | 195552 | 2420 | 0 | -22.3285 | 24.6849 | 2021-12-09 04:22:49 | Botswana | ||||
554501 | 554501 | 2022-01-16 | Botswana | 237678 | 2514 | 0 | -22.3285 | 24.6849 | 2022-01-17 04:21:08 | Botswana | ||||
558518 | 558518 | 2022-06-16 | Botswana | 314242 | 2709 | 0 | -22.3285 | 24.6849 | 2022-06-17 04:20:56 | Botswana | ||||
566815 | 566815 | 2021-10-29 | Botswana | 186594 | 2406 | 0 | -22.3285 | 24.6849 | 2021-10-30 04:22:03 | Botswana | ||||
574544 | 574544 | 2022-02-25 | Botswana | 263950 | 2619 | 0 | -22.3285 | 24.6849 | 2022-02-26 04:21:12 | Botswana | ||||
589120 | 589120 | 2020-04-05 | Botswana | 6 | 1 | 0 | 5 | -22.3285 | 24.6849 | 2020-04-05 23:06:26 | Botswana | |||
589355 | 589355 | 2021-08-08 | Botswana | 122574 | 1704 | 0 | -22.3285 | 24.6849 | 2021-08-09 04:21:24 | Botswana | ||||
593370 | 593370 | 2022-07-01 | Botswana | 322769 | 2750 | 0 | -22.3285 | 24.6849 | 2022-07-02 04:21:16 | Botswana | ||||
597385 | 597385 | 2021-10-19 | Botswana | 184051 | 2389 | 0 | -22.3285 | 24.6849 | 2021-10-20 04:21:00 | Botswana | ||||
601401 | 601401 | 2021-09-23 | Botswana | 176427 | 2360 | 0 | -22.3285 | 24.6849 | 2021-09-24 04:21:44 | Botswana | ||||
617574 | 617574 | 2022-11-05 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-11-06 04:21:24 | Botswana | ||||
621590 | 621590 | 2022-05-22 | Botswana | 307126 | 2695 | 0 | -22.3285 | 24.6849 | 2022-05-26 04:20:50 | Botswana | ||||
629620 | 629620 | 2022-07-12 | Botswana | 324154 | 2753 | 0 | -22.3285 | 24.6849 | 2022-07-13 04:20:58 | Botswana | ||||
633635 | 633635 | 2021-10-13 | Botswana | 181251 | 2381 | 0 | -22.3285 | 24.6849 | 2021-10-14 04:21:29 | Botswana | ||||
641665 | 641665 | 2021-09-07 | Botswana | 162186 | 2309 | 0 | -22.3285 | 24.6849 | 2021-09-08 04:21:31 | Botswana | ||||
649693 | 649693 | 2021-08-09 | Botswana | 130771 | 1832 | 0 | -22.3285 | 24.6849 | 2021-08-10 04:21:27 | Botswana | ||||
653707 | 653707 | 2021-10-22 | Botswana | 184919 | 2396 | 0 | -22.3285 | 24.6849 | 2021-10-23 04:21:32 | Botswana | ||||
658026 | 658026 | 2022-05-13 | Botswana | 306324 | 2690 | 0 | -22.3285 | 24.6849 | 2022-05-14 04:20:48 | Botswana | ||||
670011 | 670011 | 2022-07-21 | Botswana | 325181 | 2763 | 0 | -22.3285 | 24.6849 | 2022-07-22 04:21:15 | Botswana | ||||
674027 | 674027 | 2022-07-30 | Botswana | 325470 | 2770 | 0 | -22.3285 | 24.6849 | 2022-07-31 04:21:02 | Botswana | ||||
682052 | 682052 | 2021-10-24 | Botswana | 184919 | 2396 | 0 | -22.3285 | 24.6849 | 2021-10-25 04:22:31 | Botswana |
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]);