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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, 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 | ||||
8062 | 8062 | 2020-10-25 | Botswana | 5923 | 21 | 927 | 4975 | -22.3285 | 24.6849 | 2020-10-26 04:25:02 | Botswana | |||
12068 | 12068 | 2021-01-26 | Botswana | 20658 | 124 | 16794 | 3740 | -22.3285 | 24.6849 | 2021-01-27 05:23:41 | Botswana | |||
16082 | 16082 | 2021-09-18 | Botswana | 172252 | 2343 | 0 | -22.3285 | 24.6849 | 2021-09-19 04:21:34 | Botswana | ||||
20097 | 20097 | 2021-05-28 | Botswana | 53771 | 831 | 50494 | 2446 | -22.3285 | 24.6849 | 2021-05-29 04:20:41 | 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 | ||||
36157 | 36157 | 2021-04-12 | Botswana | 43444 | 663 | 38923 | 3858 | -22.3285 | 24.6849 | 2021-04-13 04:20:37 | 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 | |||
50518 | 50518 | 2021-05-29 | Botswana | 53771 | 831 | 50494 | 2446 | -22.3285 | 24.6849 | 2021-05-30 04:20:55 | Botswana | |||
54532 | 54532 | 2021-03-07 | Botswana | 31746 | 359 | 26760 | 4627 | -22.3285 | 24.6849 | 2021-03-08 05:24:48 | Botswana | |||
62251 | 62251 | 2020-07-23 | Botswana | 592 | 1 | 48 | 543 | -22.3285 | 24.6849 | 2020-07-24 05:30:40 | 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 | ||||
74818 | 74818 | 2020-12-03 | Botswana | 11531 | 34 | 8978 | 2519 | -22.3285 | 24.6849 | 2020-12-04 05:27:27 | Botswana | |||
78818 | 78818 | 2020-10-14 | Botswana | 3515 | 20 | 853 | 2642 | -22.3285 | 24.6849 | 2020-10-15 04:24:28 | Botswana | |||
82822 | 82822 | 2021-05-25 | Botswana | 52865 | 809 | 49641 | 2415 | -22.3285 | 24.6849 | 2021-05-26 04:20:35 | 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 | ||||
98615 | 98615 | 2020-08-04 | Botswana | 804 | 2 | 63 | 739 | -22.3285 | 24.6849 | 2020-08-05 04:34:43 | 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 | ||||
107178 | 107178 | 2021-06-19 | Botswana | 63247 | 940 | 58541 | 3766 | -22.3285 | 24.6849 | 2021-06-20 04:21:48 | Botswana | |||
114222 | 114222 | 2020-05-08 | Botswana | 23 | 1 | 9 | 13 | -22.3285 | 24.6849 | 2020-05-09 02:32:35 | Botswana | |||
114463 | 114463 | 2022-09-06 | Botswana | 325911 | 2778 | 0 | -22.3285 | 24.6849 | 2022-09-07 04:20:59 | Botswana | ||||
122206 | 122206 | 2020-07-19 | Botswana | 522 | 1 | 48 | 473 | -22.3285 | 24.6849 | 2020-07-20 05:34:40 | Botswana | |||
122434 | 122434 | 2020-11-18 | Botswana | 9103 | 30 | 6801 | 2272 | -22.3285 | 24.6849 | 2020-11-19 05:25:23 | 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 | ||||
137446 | 137446 | 2020-04-29 | Botswana | 23 | 1 | 5 | 17 | -22.3285 | 24.6849 | 2020-04-30 02:32:27 | 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 | ||||
145703 | 145703 | 2020-08-15 | Botswana | 1214 | 3 | 120 | 1091 | -22.3285 | 24.6849 | 2020-08-16 04:27:42 | Botswana | |||
149695 | 149695 | 2021-11-29 | Botswana | 195068 | 2418 | 0 | -22.3285 | 24.6849 | 2021-11-30 04:22:53 | Botswana | ||||
153711 | 153711 | 2021-01-08 | Botswana | 16050 | 48 | 12927 | 3075 | -22.3285 | 24.6849 | 2021-01-09 05:22:18 | 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 | ||||
169771 | 169771 | 2021-04-16 | Botswana | 44075 | 671 | 39493 | 3911 | -22.3285 | 24.6849 | 2021-04-17 04:20:40 | Botswana | |||
177524 | 177524 | 2020-07-27 | Botswana | 739 | 2 | 63 | 674 | -22.3285 | 24.6849 | 2020-07-28 04:58:43 | Botswana | |||
177753 | 177753 | 2021-09-02 | Botswana | 159317 | 2276 | 0 | -22.3285 | 24.6849 | 2021-09-03 04:21:20 | Botswana | ||||
181767 | 181767 | 2021-02-21 | Botswana | 26524 | 254 | 22363 | 3907 | -22.3285 | 24.6849 | 2021-02-22 05:24:21 | Botswana | |||
185782 | 185782 | 2022-02-13 | Botswana | 259655 | 2597 | 0 | -22.3285 | 24.6849 | 2022-02-14 04:20:51 | Botswana | ||||
189797 | 189797 | 2021-01-11 | Botswana | 16768 | 59 | 13310 | 3399 | -22.3285 | 24.6849 | 2021-01-12 05:22:15 | Botswana | |||
193798 | 193798 | 2020-08-31 | Botswana | 1633 | 6 | 224 | 1403 | -22.3285 | 24.6849 | 2020-09-01 04:28:31 | Botswana | |||
197970 | 197970 | 2022-10-19 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-10-20 04:22:59 | Botswana | ||||
201985 | 201985 | 2020-12-25 | Botswana | 14025 | 40 | 11627 | 2358 | -22.3285 | 24.6849 | 2020-12-26 05:22:28 | Botswana | |||
205985 | 205985 | 2020-08-19 | Botswana | 1308 | 3 | 136 | 1169 | -22.3285 | 24.6849 | 2020-08-20 04:27:43 | Botswana | |||
209970 | 209970 | 2020-10-29 | Botswana | 6642 | 24 | 4676 | 1942 | -22.3285 | 24.6849 | 2020-10-30 04:24:49 | Botswana | |||
217461 | 217461 | 2020-06-08 | Botswana | 42 | 1 | 24 | 17 | -22.3285 | 24.6849 | 2020-06-09 03:33:03 | 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 | ||||
228699 | 228699 | 2020-04-30 | Botswana | 23 | 1 | 5 | 17 | -22.3285 | 24.6849 | 2020-05-01 02:32:28 | 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 | ||||
236969 | 236969 | 2021-01-18 | Botswana | 18630 | 88 | 14624 | 3918 | -22.3285 | 24.6849 | 2021-01-19 05:22:15 | Botswana | |||
240982 | 240982 | 2021-04-02 | Botswana | 40878 | 591 | 36958 | 3329 | -22.3285 | 24.6849 | 2021-04-03 04:20:44 | 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 | ||||
268460 | 268460 | 2020-05-21 | Botswana | 29 | 1 | 19 | 9 | -22.3285 | 24.6849 | 2020-05-22 02:36:51 | Botswana | |||
271660 | 271660 | 2020-04-28 | Botswana | 23 | 1 | 0 | 22 | -22.3285 | 24.6849 | 2020-04-29 02:32:29 | Botswana | |||
271885 | 271885 | 2020-11-10 | Botswana | 7835 | 27 | 5534 | 2274 | -22.3285 | 24.6849 | 2020-11-11 05:25:30 | Botswana | |||
275894 | 275894 | 2021-11-03 | Botswana | 187281 | 2407 | 0 | -22.3285 | 24.6849 | 2021-11-04 04:22:20 | Botswana | ||||
279910 | 279910 | 2021-02-24 | Botswana | 27721 | 300 | 22773 | 4648 | -22.3285 | 24.6849 | 2021-02-25 05:24:57 | Botswana | |||
287485 | 287485 | 2020-06-15 | Botswana | 60 | 1 | 24 | 35 | -22.3285 | 24.6849 | 2020-06-16 04:33:09 | 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 | ||||
295739 | 295739 | 2021-07-15 | Botswana | 86133 | 1274 | 73380 | 11479 | -22.3285 | 24.6849 | 2021-07-16 04:21:22 | Botswana | |||
303357 | 303357 | 2020-07-01 | Botswana | 227 | 1 | 28 | 198 | -22.3285 | 24.6849 | 2020-07-02 04:33:46 | 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 | ||||
327301 | 327301 | 2020-07-20 | Botswana | 522 | 1 | 48 | 473 | -22.3285 | 24.6849 | 2020-07-21 04:38:46 | Botswana | |||
327618 | 327618 | 2022-12-27 | Botswana | 327511 | 2794 | 0 | -22.3285 | 24.6849 | 2022-12-28 04:21:04 | Botswana | ||||
331633 | 331633 | 2021-08-04 | Botswana | 115220 | 1653 | 96964 | 16603 | -22.3285 | 24.6849 | 2021-08-05 04:21:51 | Botswana | |||
335648 | 335648 | 2022-03-18 | Botswana | 263950 | 2619 | 0 | -22.3285 | 24.6849 | 2022-03-19 04:20:47 | Botswana | ||||
340003 | 340003 | 2021-02-03 | Botswana | 22738 | 148 | 18468 | 4122 | -22.3285 | 24.6849 | 2021-02-04 05:22:26 | Botswana | |||
344006 | 344006 | 2020-09-14 | Botswana | 2463 | 11 | 575 | 1877 | -22.3285 | 24.6849 | 2020-09-15 03:22:50 | Botswana | |||
348008 | 348008 | 2022-12-14 | Botswana | 327061 | 2793 | 0 | -22.3285 | 24.6849 | 2022-12-15 04:20:58 | Botswana | ||||
352023 | 352023 | 2021-03-11 | Botswana | 34098 | 424 | 28882 | 4792 | -22.3285 | 24.6849 | 2021-03-12 05:26:50 | 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 | ||||
367705 | 367705 | 2020-07-16 | Botswana | 522 | 1 | 48 | 473 | -22.3285 | 24.6849 | 2020-07-17 04:34:50 | Botswana | |||
371680 | 371680 | 2020-08-08 | Botswana | 804 | 2 | 63 | 739 | -22.3285 | 24.6849 | 2020-08-09 04:34:54 | Botswana | |||
371908 | 371908 | 2022-09-13 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-14 04:20:44 | Botswana | ||||
375912 | 375912 | 2020-11-06 | Botswana | 7835 | 27 | 5534 | 2274 | -22.3285 | 24.6849 | 2020-11-07 05:24:52 | Botswana | |||
379920 | 379920 | 2021-04-30 | Botswana | 46934 | 712 | 44960 | 1262 | -22.3285 | 24.6849 | 2021-05-01 04:20:47 | Botswana | |||
383935 | 383935 | 2022-09-23 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-24 04:21:40 | Botswana | ||||
387950 | 387950 | 2021-04-04 | Botswana | 40878 | 591 | 36958 | 3329 | -22.3285 | 24.6849 | 2021-04-05 04:20:35 | Botswana | |||
391964 | 391964 | 2020-11-27 | Botswana | 10258 | 31 | 7717 | 2510 | -22.3285 | 24.6849 | 2020-11-28 05:25:50 | 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]);