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)
country_or_region 1
- Botswana · 905 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
686068 | 686068 | 2021-11-13 | Botswana | 193701 | 2411 | 0 | -22.3285 | 24.6849 | 2021-11-14 04:21:31 | Botswana | ||||
690085 | 690085 | 2022-12-23 | Botswana | 327511 | 2794 | 0 | -22.3285 | 24.6849 | 2022-12-24 04:21:02 | Botswana | ||||
694101 | 694101 | 2022-03-17 | Botswana | 263950 | 2619 | 0 | -22.3285 | 24.6849 | 2022-03-18 04:20:55 | Botswana | ||||
698116 | 698116 | 2021-11-04 | Botswana | 187281 | 2407 | 0 | -22.3285 | 24.6849 | 2021-11-05 04:21:54 | Botswana | ||||
706146 | 706146 | 2021-09-29 | Botswana | 178050 | 2367 | 0 | -22.3285 | 24.6849 | 2021-09-30 04:21:20 | Botswana | ||||
710162 | 710162 | 2022-11-01 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-11-02 04:22:09 | Botswana | ||||
714177 | 714177 | 2021-11-12 | Botswana | 193701 | 2411 | 0 | -22.3285 | 24.6849 | 2021-11-13 04:21:38 | Botswana | ||||
718194 | 718194 | 2022-12-04 | Botswana | 326633 | 2790 | 0 | -22.3285 | 24.6849 | 2022-12-05 04:20:58 | Botswana | ||||
722209 | 722209 | 2021-11-20 | Botswana | 194445 | 2416 | 0 | -22.3285 | 24.6849 | 2021-11-21 04:22:13 | Botswana | ||||
730239 | 730239 | 2021-12-27 | Botswana | 212482 | 2439 | 0 | -22.3285 | 24.6849 | 2021-12-28 04:21:47 | Botswana | ||||
746056 | 746056 | 2022-04-23 | Botswana | 305859 | 2688 | 0 | -22.3285 | 24.6849 | 2022-04-24 04:20:56 | Botswana | ||||
758039 | 758039 | 2021-11-26 | Botswana | 194909 | 2416 | 0 | -22.3285 | 24.6849 | 2021-11-27 04:22:45 | Botswana | ||||
770060 | 770060 | 2021-10-23 | Botswana | 184919 | 2396 | 0 | -22.3285 | 24.6849 | 2021-10-24 04:21:22 | Botswana | ||||
782102 | 782102 | 2021-12-13 | Botswana | 196090 | 2421 | 0 | -22.3285 | 24.6849 | 2021-12-14 04:22:38 | Botswana | ||||
794126 | 794126 | 2022-10-24 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-10-25 04:21:53 | Botswana | ||||
798141 | 798141 | 2021-12-22 | Botswana | 204701 | 2425 | 0 | -22.3285 | 24.6849 | 2021-12-23 04:21:21 | Botswana | ||||
809303 | 809303 | 2021-09-20 | Botswana | 173788 | 2354 | 0 | -22.3285 | 24.6849 | 2021-09-21 04:21:26 | Botswana | ||||
833339 | 833339 | 2022-12-02 | Botswana | 326633 | 2790 | 0 | -22.3285 | 24.6849 | 2022-12-03 04:21:02 | Botswana | ||||
849311 | 849311 | 2022-11-02 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-11-03 04:22:05 | Botswana | ||||
853327 | 853327 | 2022-09-30 | Botswana | 326308 | 2789 | 0 | -22.3285 | 24.6849 | 2022-10-01 04:23:01 | Botswana | ||||
860170 | 860170 | 2020-04-15 | Botswana | 13 | 1 | 0 | 12 | -22.3285 | 24.6849 | 2020-04-15 22:56:32 | Botswana | |||
868511 | 868511 | 2022-12-11 | Botswana | 326800 | 2793 | 0 | -22.3285 | 24.6849 | 2022-12-12 04:21:01 | Botswana | ||||
875976 | 875976 | 2022-03-27 | Botswana | 263950 | 2619 | 0 | -22.3285 | 24.6849 | 2022-03-28 04:20:33 | Botswana | ||||
879992 | 879992 | 2022-08-05 | Botswana | 325724 | 2772 | 0 | -22.3285 | 24.6849 | 2022-08-06 04:20:56 | Botswana | ||||
895859 | 895859 | 2022-07-24 | Botswana | 325181 | 2763 | 0 | -22.3285 | 24.6849 | 2022-07-25 04:20:51 | Botswana | ||||
899875 | 899875 | 2022-07-22 | Botswana | 325181 | 2763 | 0 | -22.3285 | 24.6849 | 2022-07-23 04:20:53 | Botswana | ||||
903890 | 903890 | 2021-11-24 | Botswana | 194652 | 2416 | 0 | -22.3285 | 24.6849 | 2021-11-25 04:22:33 | Botswana | ||||
911920 | 911920 | 2022-10-29 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-10-30 04:22:14 | Botswana | ||||
919396 | 919396 | 2022-03-08 | Botswana | 263950 | 2619 | 0 | -22.3285 | 24.6849 | 2022-03-09 04:20:59 | Botswana | ||||
934276 | 934276 | 2020-04-16 | Botswana | 15 | 1 | 0 | 14 | -22.3285 | 24.6849 | 2020-04-16 23:30:31 | Botswana | |||
934512 | 934512 | 2021-10-16 | Botswana | 181856 | 2386 | 0 | -22.3285 | 24.6849 | 2021-10-17 04:21:29 | Botswana | ||||
938529 | 938529 | 2022-06-25 | Botswana | 318528 | 2719 | 0 | -22.3285 | 24.6849 | 2022-06-26 04:21:02 | Botswana | ||||
942545 | 942545 | 2022-02-28 | Botswana | 263950 | 2619 | 0 | -22.3285 | 24.6849 | 2022-03-01 04:21:09 | Botswana | ||||
946561 | 946561 | 2022-06-14 | Botswana | 314242 | 2709 | 0 | -22.3285 | 24.6849 | 2022-06-15 04:20:54 | Botswana | ||||
950577 | 950577 | 2022-03-12 | Botswana | 263950 | 2619 | 0 | -22.3285 | 24.6849 | 2022-03-13 04:20:49 | Botswana | ||||
958607 | 958607 | 2022-07-19 | Botswana | 324841 | 2760 | 0 | -22.3285 | 24.6849 | 2022-07-20 04:20:59 | Botswana | ||||
962623 | 962623 | 2022-09-09 | Botswana | 325931 | 2786 | 0 | -22.3285 | 24.6849 | 2022-09-10 04:21:10 | Botswana | ||||
970631 | 970631 | 2022-06-01 | Botswana | 308126 | 2697 | 0 | -22.3285 | 24.6849 | 2022-06-02 05:20:39 | Botswana | ||||
978660 | 978660 | 2022-02-01 | Botswana | 253036 | 2581 | 0 | -22.3285 | 24.6849 | 2022-02-02 04:21:09 | Botswana | ||||
986690 | 986690 | 2021-10-04 | Botswana | 179220 | 2368 | 0 | -22.3285 | 24.6849 | 2021-10-05 04:21:27 | Botswana | ||||
990706 | 990706 | 2022-08-16 | Botswana | 325824 | 2774 | 0 | -22.3285 | 24.6849 | 2022-08-17 04:20:59 | Botswana | ||||
1014045 | 1014045 | 2021-11-21 | Botswana | 194445 | 2416 | 0 | -22.3285 | 24.6849 | 2021-11-22 04:22:20 | Botswana | ||||
1018062 | 1018062 | 2022-12-24 | Botswana | 327511 | 2794 | 0 | -22.3285 | 24.6849 | 2022-12-25 04:21:04 | Botswana | ||||
1022078 | 1022078 | 2022-11-04 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-11-05 04:21:52 | Botswana | ||||
1030087 | 1030087 | 2021-12-06 | Botswana | 195552 | 2420 | 0 | -22.3285 | 24.6849 | 2021-12-07 04:22:34 | Botswana | ||||
1049550 | 1049550 | 2022-11-06 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-11-07 04:21:26 | Botswana | ||||
1057561 | 1057561 | 2022-02-23 | Botswana | 262652 | 2614 | 0 | -22.3285 | 24.6849 | 2022-02-24 04:21:14 | Botswana | ||||
1065589 | 1065589 | 2022-07-28 | Botswana | 325470 | 2770 | 0 | -22.3285 | 24.6849 | 2022-07-29 04:20:45 | Botswana | ||||
1069605 | 1069605 | 2022-08-07 | Botswana | 325724 | 2772 | 0 | -22.3285 | 24.6849 | 2022-08-08 04:21:08 | Botswana | ||||
1073621 | 1073621 | 2022-12-28 | Botswana | 327511 | 2794 | 0 | -22.3285 | 24.6849 | 2022-12-29 04:21:01 | Botswana | ||||
1077636 | 1077636 | 2021-12-09 | Botswana | 196090 | 2421 | 0 | -22.3285 | 24.6849 | 2021-12-10 04:22:28 | Botswana | ||||
1085787 | 1085787 | 2022-08-09 | Botswana | 325724 | 2772 | 0 | -22.3285 | 24.6849 | 2022-08-10 04:20:57 | Botswana | ||||
1097830 | 1097830 | 2022-08-03 | Botswana | 325470 | 2770 | 0 | -22.3285 | 24.6849 | 2022-08-04 04:20:58 | Botswana | ||||
1109286 | 1109286 | 2022-05-21 | Botswana | 306614 | 2692 | 0 | -22.3285 | 24.6849 | 2022-05-22 04:20:52 | Botswana | ||||
1113301 | 1113301 | 2022-01-11 | Botswana | 232432 | 2497 | 0 | -22.3285 | 24.6849 | 2022-01-12 04:21:44 | Botswana | ||||
1117317 | 1117317 | 2021-08-06 | Botswana | 122574 | 1704 | 0 | -22.3285 | 24.6849 | 2021-08-07 04:21:30 | Botswana | ||||
1140624 | 1140624 | 2022-01-23 | Botswana | 243946 | 2544 | 0 | -22.3285 | 24.6849 | 2022-01-24 04:21:12 | Botswana | ||||
1144640 | 1144640 | 2021-12-01 | Botswana | 195068 | 2418 | 0 | -22.3285 | 24.6849 | 2021-12-02 04:22:37 | Botswana | ||||
1148657 | 1148657 | 2022-12-12 | Botswana | 327061 | 2793 | 0 | -22.3285 | 24.6849 | 2022-12-13 04:21:01 | Botswana | ||||
1156864 | 1156864 | 2022-04-29 | Botswana | 305984 | 2688 | 0 | -22.3285 | 24.6849 | 2022-04-30 04:21:05 | Botswana | ||||
1160880 | 1160880 | 2022-08-18 | Botswana | 325850 | 2777 | 0 | -22.3285 | 24.6849 | 2022-08-19 04:20:54 | Botswana | ||||
1168910 | 1168910 | 2022-05-20 | Botswana | 306614 | 2692 | 0 | -22.3285 | 24.6849 | 2022-05-21 04:20:58 | Botswana | ||||
1184457 | 1184457 | 2022-05-18 | Botswana | 306614 | 2692 | 0 | -22.3285 | 24.6849 | 2022-05-19 04:20:54 | Botswana | ||||
1199282 | 1199282 | 2020-04-22 | Botswana | 22 | 1 | 0 | 21 | -22.3285 | 24.6849 | 2020-04-22 23:30:32 | Botswana | |||
1199519 | 1199519 | 2022-07-06 | Botswana | 323327 | 2752 | 0 | -22.3285 | 24.6849 | 2022-07-07 04:20:55 | Botswana | ||||
1211264 | 1211264 | 2022-07-11 | Botswana | 324154 | 2753 | 0 | -22.3285 | 24.6849 | 2022-07-12 04:20:51 | Botswana | ||||
1215279 | 1215279 | 2022-01-08 | Botswana | 229855 | 2475 | 0 | -22.3285 | 24.6849 | 2022-01-09 04:21:46 | Botswana | ||||
1223310 | 1223310 | 2022-04-14 | Botswana | 305859 | 2688 | 0 | -22.3285 | 24.6849 | 2022-04-15 04:20:57 | Botswana | ||||
1227325 | 1227325 | 2022-01-24 | Botswana | 245904 | 2565 | 0 | -22.3285 | 24.6849 | 2022-01-25 04:21:05 | Botswana | ||||
1231341 | 1231341 | 2021-11-28 | Botswana | 194909 | 2416 | 0 | -22.3285 | 24.6849 | 2021-11-29 04:22:30 | Botswana | ||||
1235357 | 1235357 | 2021-09-27 | Botswana | 178050 | 2367 | 0 | -22.3285 | 24.6849 | 2021-09-28 04:21:28 | Botswana | ||||
1239373 | 1239373 | 2022-11-28 | Botswana | 326373 | 2790 | 0 | -22.3285 | 24.6849 | 2022-11-29 04:21:05 | Botswana | ||||
1250231 | 1250231 | 2020-04-10 | Botswana | 13 | 1 | 0 | 12 | -22.3285 | 24.6849 | 2020-04-10 22:53:48 | Botswana | |||
1250469 | 1250469 | 2022-08-23 | Botswana | 325850 | 2777 | 0 | -22.3285 | 24.6849 | 2022-08-24 04:20:46 | Botswana | ||||
1254484 | 1254484 | 2021-12-20 | Botswana | 204701 | 2425 | 0 | -22.3285 | 24.6849 | 2021-12-21 03:21:27 | Botswana | ||||
1258500 | 1258500 | 2021-12-18 | Botswana | 199864 | 2425 | 0 | -22.3285 | 24.6849 | 2021-12-19 04:21:11 | Botswana | ||||
1262516 | 1262516 | 2021-09-09 | Botswana | 163665 | 2325 | 0 | -22.3285 | 24.6849 | 2021-09-10 04:21:20 | Botswana | ||||
1274000 | 1274000 | 2021-10-03 | Botswana | 179220 | 2368 | 0 | -22.3285 | 24.6849 | 2021-10-04 04:21:31 | Botswana | ||||
1281701 | 1281701 | 2022-01-05 | Botswana | 222053 | 2452 | 0 | -22.3285 | 24.6849 | 2022-01-06 04:22:09 | Botswana | ||||
1285717 | 1285717 | 2022-01-04 | Botswana | 222053 | 2452 | 0 | -22.3285 | 24.6849 | 2022-01-05 04:21:59 | Botswana | ||||
1293747 | 1293747 | 2022-02-05 | Botswana | 256041 | 2585 | 0 | -22.3285 | 24.6849 | 2022-02-06 04:21:00 | Botswana | ||||
1297764 | 1297764 | 2022-02-17 | Botswana | 261913 | 2608 | 0 | -22.3285 | 24.6849 | 2022-02-18 04:21:04 | Botswana | ||||
1313911 | 1313911 | 2022-05-27 | Botswana | 307126 | 2695 | 0 | -22.3285 | 24.6849 | 2022-05-28 04:21:07 | Botswana | ||||
1317926 | 1317926 | 2022-01-26 | Botswana | 245904 | 2565 | 0 | -22.3285 | 24.6849 | 2022-01-27 04:21:19 | Botswana | ||||
1321942 | 1321942 | 2021-11-14 | Botswana | 193701 | 2411 | 0 | -22.3285 | 24.6849 | 2021-11-15 04:21:36 | Botswana | ||||
1325959 | 1325959 | 2022-04-26 | Botswana | 305859 | 2688 | 0 | -22.3285 | 24.6849 | 2022-04-27 04:20:52 | Botswana | ||||
1333988 | 1333988 | 2021-09-28 | Botswana | 178050 | 2367 | 0 | -22.3285 | 24.6849 | 2021-09-29 04:21:45 | Botswana | ||||
1342017 | 1342017 | 2021-08-11 | Botswana | 130771 | 1832 | 0 | -22.3285 | 24.6849 | 2021-08-12 04:21:25 | Botswana | ||||
1346032 | 1346032 | 2022-08-10 | Botswana | 325724 | 2772 | 0 | -22.3285 | 24.6849 | 2022-08-11 04:20:49 | Botswana | ||||
1358048 | 1358048 | 2021-11-27 | Botswana | 194909 | 2416 | 0 | -22.3285 | 24.6849 | 2021-11-28 04:22:43 | Botswana | ||||
1362064 | 1362064 | 2022-02-08 | Botswana | 257167 | 2593 | 0 | -22.3285 | 24.6849 | 2022-02-09 04:21:04 | Botswana | ||||
1366189 | 1366189 | 2022-10-28 | Botswana | 326344 | 2790 | 0 | -22.3285 | 24.6849 | 2022-10-29 04:21:13 | Botswana | ||||
1370205 | 1370205 | 2022-09-21 | Botswana | 326127 | 2787 | 0 | -22.3285 | 24.6849 | 2022-09-22 04:22:56 | Botswana | ||||
1374220 | 1374220 | 2021-09-15 | Botswana | 165644 | 2337 | 0 | -22.3285 | 24.6849 | 2021-09-16 04:22:19 | Botswana | ||||
1385122 | 1385122 | 2020-04-19 | Botswana | 20 | 1 | 0 | 19 | -22.3285 | 24.6849 | 2020-04-19 23:40:41 | Botswana | |||
1385358 | 1385358 | 2021-09-13 | Botswana | 165644 | 2337 | 0 | -22.3285 | 24.6849 | 2021-09-14 04:21:41 | Botswana | ||||
1389372 | 1389372 | 2022-01-07 | Botswana | 229855 | 2475 | 0 | -22.3285 | 24.6849 | 2022-01-08 04:21:53 | Botswana | ||||
1393389 | 1393389 | 2022-09-02 | Botswana | 325864 | 2778 | 0 | -22.3285 | 24.6849 | 2022-09-03 04:21:04 | Botswana | ||||
1397405 | 1397405 | 2022-05-06 | Botswana | 306200 | 2690 | 0 | -22.3285 | 24.6849 | 2022-05-07 04:21:09 | Botswana | ||||
1404755 | 1404755 | 2022-08-02 | Botswana | 325470 | 2770 | 0 | -22.3285 | 24.6849 | 2022-08-03 04:20:59 | 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]);