johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,030 rows where country_or_region = "South Africa" sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, day (date), last_update (date)
country_or_region 1
- South Africa · 1,030 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40276 | 40276 | 2020-03-05 | South Africa | 1 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-05T13:53:03 | |||||
62647 | 62647 | 2020-03-07 | South Africa | 1 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-06T15:43:02 | |||||
339706 | 339706 | 2020-03-21 | South Africa | 240 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-21T12:13:19 | |||||
657827 | 657827 | 2020-03-09 | South Africa | 3 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-08T10:23:04 | |||||
1176963 | 1176963 | 2020-03-18 | South Africa | 116 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-18T10:53:02 | |||||
1463556 | 1463556 | 2020-03-15 | South Africa | 51 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-15T18:20:18 | |||||
1526957 | 1526957 | 2020-03-19 | South Africa | 150 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-19T16:43:03 | |||||
1527340 | 1527340 | 2020-03-08 | South Africa | 3 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-08T10:23:04 | |||||
2111189 | 2111189 | 2020-03-14 | South Africa | 38 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-14T16:14:56 | |||||
2127536 | 2127536 | 2020-03-11 | South Africa | 13 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-11T10:33:03 | |||||
2255208 | 2255208 | 2020-03-16 | South Africa | 62 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-16T14:38:45 | |||||
2282969 | 2282969 | 2020-03-12 | South Africa | 17 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-12T09:13:24 | |||||
3177635 | 3177635 | 2020-03-06 | South Africa | 1 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-06T15:43:02 | |||||
3734002 | 3734002 | 2020-03-20 | South Africa | 202 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-20T14:43:04 | |||||
3752933 | 3752933 | 2020-03-10 | South Africa | 7 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-10T05:13:07 | |||||
3765426 | 3765426 | 2020-03-13 | South Africa | 24 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-11T20:00:00 | |||||
3891421 | 3891421 | 2020-03-17 | South Africa | 62 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-16T14:38:45 | |||||
615 | 615 | 2021-12-02 | South Africa | 2988148 | 89915 | 0 | -30.5595 | 22.9375 | 2021-12-03 04:23:05 | South Africa | ||||
4631 | 4631 | 2021-10-28 | South Africa | 2921114 | 89104 | 0 | -30.5595 | 22.9375 | 2021-10-29 04:22:03 | South Africa | ||||
8610 | 8610 | 2020-10-25 | South Africa | 715868 | 18968 | 646170 | 50730 | -30.5595 | 22.9375 | 2020-10-26 04:25:02 | South Africa | |||
12621 | 12621 | 2021-01-26 | South Africa | 1423578 | 41797 | 1254674 | 127107 | -30.5595 | 22.9375 | 2021-01-27 05:23:41 | South Africa | |||
16639 | 16639 | 2021-09-18 | South Africa | 2880349 | 86116 | 0 | -30.5595 | 22.9375 | 2021-09-19 04:21:34 | South Africa | ||||
20652 | 20652 | 2021-05-28 | South Africa | 1654551 | 56293 | 1551520 | 46738 | -30.5595 | 22.9375 | 2021-05-29 04:20:41 | South Africa | |||
24686 | 24686 | 2022-03-20 | South Africa | 3704218 | 99881 | 0 | -30.5595 | 22.9375 | 2022-03-21 04:20:50 | South Africa | ||||
28701 | 28701 | 2021-11-11 | South Africa | 2924978 | 89452 | 0 | -30.5595 | 22.9375 | 2021-11-12 04:22:01 | South Africa | ||||
32700 | 32700 | 2021-08-25 | South Africa | 2722202 | 80469 | 0 | -30.5595 | 22.9375 | 2021-08-26 04:21:28 | South Africa | ||||
36711 | 36711 | 2021-04-12 | South Africa | 1559113 | 53356 | 1484356 | 21401 | -30.5595 | 22.9375 | 2021-04-13 04:20:37 | South Africa | |||
43313 | 43313 | 2020-04-13 | South Africa | 2272 | 27 | 410 | 1835 | -30.5595 | 22.9375 | 2020-04-13 23:07:34 | South Africa | |||
43993 | 43993 | 2021-11-02 | South Africa | 2922391 | 89197 | 0 | -30.5595 | 22.9375 | 2021-11-03 06:22:09 | South Africa | ||||
50412 | 50412 | 2020-04-17 | South Africa | 2783 | 50 | 903 | 1830 | -30.5595 | 22.9375 | 2020-04-17 23:30:32 | South Africa | |||
51073 | 51073 | 2021-05-29 | South Africa | 1659070 | 56363 | 1554184 | 48523 | -30.5595 | 22.9375 | 2021-05-30 04:20:55 | South Africa | |||
55086 | 55086 | 2021-03-07 | South Africa | 1521068 | 50678 | 1440874 | 29516 | -30.5595 | 22.9375 | 2021-03-08 05:24:48 | South Africa | |||
62371 | 62371 | 2020-07-23 | South Africa | 408052 | 6093 | 236260 | 165699 | -30.5595 | 22.9375 | 2020-07-24 05:30:40 | South Africa | |||
63350 | 63350 | 2022-11-12 | South Africa | 4033182 | 102371 | 0 | -30.5595 | 22.9375 | 2022-11-13 04:21:14 | South Africa | ||||
67345 | 67345 | 2021-09-01 | South Africa | 2787203 | 82496 | 0 | -30.5595 | 22.9375 | 2021-09-02 04:21:15 | South Africa | ||||
71376 | 71376 | 2022-02-07 | South Africa | 3625190 | 96021 | 0 | -30.5595 | 22.9375 | 2022-02-08 04:21:15 | South Africa | ||||
75369 | 75369 | 2020-12-03 | South Africa | 800872 | 21803 | 739367 | 39702 | -30.5595 | 22.9375 | 2020-12-04 05:27:27 | South Africa | |||
79366 | 79366 | 2020-10-14 | South Africa | 696414 | 18151 | 626898 | 51365 | -30.5595 | 22.9375 | 2020-10-15 04:24:28 | South Africa | |||
83376 | 83376 | 2021-05-25 | South Africa | 1637848 | 55976 | 1543951 | 37921 | -30.5595 | 22.9375 | 2021-05-26 04:20:35 | South Africa | |||
87410 | 87410 | 2021-11-09 | South Africa | 2924317 | 89387 | 0 | -30.5595 | 22.9375 | 2021-11-10 04:21:38 | South Africa | ||||
91428 | 91428 | 2022-07-23 | South Africa | 4002133 | 101943 | 0 | -30.5595 | 22.9375 | 2022-07-24 04:20:47 | South Africa | ||||
98735 | 98735 | 2020-08-04 | South Africa | 521318 | 8884 | 363751 | 148683 | -30.5595 | 22.9375 | 2020-08-05 04:34:43 | South Africa | |||
99611 | 99611 | 2022-01-14 | South Africa | 3552043 | 93117 | 0 | -30.5595 | 22.9375 | 2022-01-15 04:21:07 | South Africa | ||||
103610 | 103610 | 2021-08-15 | South Africa | 2605586 | 77141 | 0 | -30.5595 | 22.9375 | 2021-08-16 04:21:31 | South Africa | ||||
107735 | 107735 | 2021-06-19 | South Africa | 1810164 | 58590 | 1640849 | 110725 | -30.5595 | 22.9375 | 2021-06-20 04:21:48 | South Africa | |||
114353 | 114353 | 2020-05-08 | South Africa | 8895 | 178 | 3153 | 5564 | -30.5595 | 22.9375 | 2020-05-09 02:32:35 | South Africa | |||
115038 | 115038 | 2022-09-06 | South Africa | 4012920 | 102108 | 0 | -30.5595 | 22.9375 | 2022-09-07 04:20:59 | South Africa | ||||
122326 | 122326 | 2020-07-19 | South Africa | 364328 | 5033 | 191059 | 168236 | -30.5595 | 22.9375 | 2020-07-20 05:34:40 | South Africa | |||
122984 | 122984 | 2020-11-18 | South Africa | 757144 | 20556 | 701534 | 35054 | -30.5595 | 22.9375 | 2020-11-19 05:25:23 | South Africa | |||
127018 | 127018 | 2022-01-09 | South Africa | 3526054 | 92453 | 0 | -30.5595 | 22.9375 | 2022-01-10 04:22:07 | South Africa | ||||
131038 | 131038 | 2022-10-04 | South Africa | 4019800 | 102185 | 0 | -30.5595 | 22.9375 | 2022-10-05 04:23:06 | South Africa | ||||
137576 | 137576 | 2020-04-29 | South Africa | 5350 | 103 | 2073 | 3174 | -30.5595 | 22.9375 | 2020-04-30 02:32:27 | South Africa | |||
138256 | 138256 | 2021-12-04 | South Africa | 3020569 | 89965 | 0 | -30.5595 | 22.9375 | 2021-12-05 04:22:25 | South Africa | ||||
142274 | 142274 | 2022-07-09 | South Africa | 3997269 | 101876 | 0 | -30.5595 | 22.9375 | 2022-07-10 04:20:54 | South Africa | ||||
146249 | 146249 | 2020-08-15 | South Africa | 583653 | 11677 | 466941 | 105035 | -30.5595 | 22.9375 | 2020-08-16 04:27:42 | South Africa | |||
150269 | 150269 | 2021-11-29 | South Africa | 2963679 | 89822 | 0 | -30.5595 | 22.9375 | 2021-11-30 04:22:53 | South Africa | ||||
154263 | 154263 | 2021-01-08 | South Africa | 1192570 | 32425 | 947919 | 212226 | -30.5595 | 22.9375 | 2021-01-09 05:22:18 | South Africa | |||
158298 | 158298 | 2022-03-29 | South Africa | 3715390 | 99976 | 0 | -30.5595 | 22.9375 | 2022-03-30 04:20:45 | South Africa | ||||
162313 | 162313 | 2021-11-19 | South Africa | 2928288 | 89562 | 0 | -30.5595 | 22.9375 | 2021-11-20 04:22:17 | South Africa | ||||
166331 | 166331 | 2022-06-21 | South Africa | 3986892 | 101640 | 0 | -30.5595 | 22.9375 | 2022-06-22 04:20:54 | South Africa | ||||
170325 | 170325 | 2021-04-16 | South Africa | 1564355 | 53663 | 1488572 | 22120 | -30.5595 | 22.9375 | 2021-04-17 04:20:40 | South Africa | |||
177644 | 177644 | 2020-07-27 | South Africa | 452529 | 7067 | 274925 | 170537 | -30.5595 | 22.9375 | 2020-07-28 04:58:43 | South Africa | |||
178310 | 178310 | 2021-09-02 | South Africa | 2796405 | 82914 | 0 | -30.5595 | 22.9375 | 2021-09-03 04:21:20 | South Africa | ||||
182321 | 182321 | 2021-02-21 | South Africa | 1503796 | 49053 | 1412015 | 42728 | -30.5595 | 22.9375 | 2021-02-22 05:24:21 | South Africa | |||
186356 | 186356 | 2022-02-13 | South Africa | 3641811 | 96993 | 0 | -30.5595 | 22.9375 | 2022-02-14 04:20:51 | South Africa | ||||
190349 | 190349 | 2021-01-11 | South Africa | 1246643 | 33579 | 973265 | 239799 | -30.5595 | 22.9375 | 2021-01-12 05:22:15 | South Africa | |||
194344 | 194344 | 2020-08-31 | South Africa | 627041 | 14149 | 540923 | 71969 | -30.5595 | 22.9375 | 2020-09-01 04:28:31 | South Africa | |||
198547 | 198547 | 2022-10-19 | South Africa | 4024553 | 102246 | 0 | -30.5595 | 22.9375 | 2022-10-20 04:22:59 | South Africa | ||||
202536 | 202536 | 2020-12-25 | South Africa | 983359 | 26276 | 830251 | 126832 | -30.5595 | 22.9375 | 2020-12-26 05:22:28 | South Africa | |||
206531 | 206531 | 2020-08-19 | South Africa | 596060 | 12423 | 491441 | 92196 | -30.5595 | 22.9375 | 2020-08-20 04:27:43 | South Africa | |||
210519 | 210519 | 2020-10-29 | South Africa | 721770 | 19164 | 649935 | 52671 | -30.5595 | 22.9375 | 2020-10-30 04:24:49 | South Africa | |||
217584 | 217584 | 2020-06-08 | South Africa | 50879 | 1080 | 26099 | 23700 | -30.5595 | 22.9375 | 2020-06-09 03:33:03 | South Africa | |||
218268 | 218268 | 2022-12-26 | South Africa | 4048281 | 102568 | 0 | -30.5595 | 22.9375 | 2022-12-27 04:21:07 | South Africa | ||||
222281 | 222281 | 2022-05-09 | South Africa | 3844625 | 100533 | 0 | -30.5595 | 22.9375 | 2022-05-10 04:20:50 | South Africa | ||||
228830 | 228830 | 2020-04-30 | South Africa | 5647 | 103 | 2073 | 3471 | -30.5595 | 22.9375 | 2020-05-01 02:32:28 | South Africa | |||
229513 | 229513 | 2022-05-31 | South Africa | 3957777 | 101190 | 0 | -30.5595 | 22.9375 | 2022-06-01 04:20:55 | South Africa | ||||
233528 | 233528 | 2022-02-11 | South Africa | 3637673 | 96851 | 0 | -30.5595 | 22.9375 | 2022-02-12 04:21:06 | South Africa | ||||
237521 | 237521 | 2021-01-18 | South Africa | 1346936 | 37449 | 1117452 | 192035 | -30.5595 | 22.9375 | 2021-01-19 05:22:15 | South Africa | |||
241536 | 241536 | 2021-04-02 | South Africa | 1550724 | 52946 | 1475398 | 22380 | -30.5595 | 22.9375 | 2021-04-03 04:20:44 | South Africa | |||
245553 | 245553 | 2021-08-17 | South Africa | 2624254 | 77993 | 0 | -30.5595 | 22.9375 | 2021-08-18 04:21:35 | South Africa | ||||
249567 | 249567 | 2021-09-04 | South Africa | 2814014 | 83343 | 0 | -30.5595 | 22.9375 | 2021-09-05 04:21:33 | South Africa | ||||
253600 | 253600 | 2022-09-08 | South Africa | 4013721 | 102129 | 0 | -30.5595 | 22.9375 | 2022-09-09 04:21:11 | South Africa | ||||
257618 | 257618 | 2022-12-10 | South Africa | 4045070 | 102550 | 0 | -30.5595 | 22.9375 | 2022-12-11 04:20:50 | South Africa | ||||
261818 | 261818 | 2022-03-15 | South Africa | 3696823 | 99727 | 0 | -30.5595 | 22.9375 | 2022-03-16 04:20:50 | South Africa | ||||
268587 | 268587 | 2020-05-21 | South Africa | 19137 | 369 | 8950 | 9818 | -30.5595 | 22.9375 | 2020-05-22 02:36:51 | South Africa | |||
271790 | 271790 | 2020-04-28 | South Africa | 4996 | 93 | 2073 | 2830 | -30.5595 | 22.9375 | 2020-04-29 02:32:29 | South Africa | |||
272434 | 272434 | 2020-11-10 | South Africa | 740254 | 19951 | 683194 | 37109 | -30.5595 | 22.9375 | 2020-11-11 05:25:30 | South Africa | |||
276468 | 276468 | 2021-11-03 | South Africa | 2922735 | 89220 | 0 | -30.5595 | 22.9375 | 2021-11-04 04:22:20 | South Africa | ||||
280464 | 280464 | 2021-02-24 | South Africa | 1507448 | 49523 | 1422622 | 35303 | -30.5595 | 22.9375 | 2021-02-25 05:24:57 | South Africa | |||
287606 | 287606 | 2020-06-15 | South Africa | 73533 | 1568 | 39867 | 32098 | -30.5595 | 22.9375 | 2020-06-16 04:33:09 | South Africa | |||
288281 | 288281 | 2021-10-31 | South Africa | 2922116 | 89177 | 0 | -30.5595 | 22.9375 | 2021-11-01 04:22:01 | South Africa | ||||
292301 | 292301 | 2022-11-15 | South Africa | 4035522 | 102371 | 0 | -30.5595 | 22.9375 | 2022-11-16 04:21:09 | South Africa | ||||
296296 | 296296 | 2021-07-15 | South Africa | 2253240 | 65972 | 1982122 | 205146 | -30.5595 | 22.9375 | 2021-07-16 04:21:22 | South Africa | |||
303478 | 303478 | 2020-07-01 | South Africa | 159333 | 2749 | 76025 | 80559 | -30.5595 | 22.9375 | 2020-07-02 04:33:46 | South Africa | |||
304154 | 304154 | 2022-04-16 | South Africa | 3740398 | 100144 | 0 | -30.5595 | 22.9375 | 2022-04-17 04:20:59 | South Africa | ||||
308173 | 308173 | 2022-12-13 | South Africa | 4045472 | 102550 | 0 | -30.5595 | 22.9375 | 2022-12-14 04:21:04 | South Africa | ||||
312189 | 312189 | 2022-11-13 | South Africa | 4033182 | 102371 | 0 | -30.5595 | 22.9375 | 2022-11-14 04:21:09 | South Africa | ||||
316202 | 316202 | 2022-02-12 | South Africa | 3640162 | 96985 | 0 | -30.5595 | 22.9375 | 2022-02-13 04:21:00 | South Africa | ||||
320221 | 320221 | 2022-10-30 | South Africa | 4028160 | 102311 | 0 | -30.5595 | 22.9375 | 2022-10-31 04:21:36 | South Africa | ||||
327421 | 327421 | 2020-07-20 | South Africa | 373628 | 5173 | 194865 | 173590 | -30.5595 | 22.9375 | 2020-07-21 04:38:46 | South Africa |
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]);