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 last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, recovered, day (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 | |||||
3177635 | 3177635 | 2020-03-06 | South Africa | 1 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-06T15:43:02 | |||||
657827 | 657827 | 2020-03-09 | South Africa | 3 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-08T10:23:04 | |||||
1527340 | 1527340 | 2020-03-08 | South Africa | 3 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-08T10:23:04 | |||||
3752933 | 3752933 | 2020-03-10 | South Africa | 7 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-10T05:13:07 | |||||
2127536 | 2127536 | 2020-03-11 | South Africa | 13 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-11T10:33:03 | |||||
3765426 | 3765426 | 2020-03-13 | South Africa | 24 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-11T20:00:00 | |||||
2282969 | 2282969 | 2020-03-12 | South Africa | 17 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-12T09:13:24 | |||||
2111189 | 2111189 | 2020-03-14 | South Africa | 38 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-14T16:14:56 | |||||
1463556 | 1463556 | 2020-03-15 | South Africa | 51 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-15T18:20:18 | |||||
2255208 | 2255208 | 2020-03-16 | South Africa | 62 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-16T14:38:45 | |||||
3891421 | 3891421 | 2020-03-17 | South Africa | 62 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-16T14:38:45 | |||||
1176963 | 1176963 | 2020-03-18 | South Africa | 116 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-18T10:53:02 | |||||
1526957 | 1526957 | 2020-03-19 | South Africa | 150 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-19T16:43:03 | |||||
3734002 | 3734002 | 2020-03-20 | South Africa | 202 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-20T14:43:04 | |||||
339706 | 339706 | 2020-03-21 | South Africa | 240 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-21T12:13:19 | |||||
2147249 | 2147249 | 2020-03-23 | South Africa | 402 | 0 | 4 | 398 | -30.5595 | 22.9375 | 2020-03-23 23:19:21 | South Africa | |||
1479195 | 1479195 | 2020-03-24 | South Africa | 554 | 0 | 4 | 550 | -30.5595 | 22.9375 | 2020-03-24 23:37:15 | South Africa | |||
1132691 | 1132691 | 2020-03-25 | South Africa | 709 | 0 | 12 | 697 | -30.5595 | 22.9375 | 2020-03-25 23:33:04 | South Africa | |||
919291 | 919291 | 2020-03-26 | South Africa | 927 | 0 | 12 | 915 | -30.5595 | 22.9375 | 2020-03-26 23:48:18 | South Africa | |||
809199 | 809199 | 2020-03-27 | South Africa | 1170 | 1 | 31 | 1138 | -30.5595 | 22.9375 | 2020-03-27 23:23:03 | South Africa | |||
3816029 | 3816029 | 2020-03-31 | South Africa | 1353 | 5 | 31 | 1317 | -30.5595 | 22.9375 | 2020-03-31 23:43:43 | South Africa | |||
3364936 | 3364936 | 2020-04-01 | South Africa | 1380 | 5 | 50 | 1325 | -30.5595 | 22.9375 | 2020-04-01 21:58:34 | South Africa | |||
3740703 | 3740703 | 2020-04-03 | South Africa | 1505 | 9 | 95 | 1401 | -30.5595 | 22.9375 | 2020-04-03 22:46:20 | South Africa | |||
589249 | 589249 | 2020-04-05 | South Africa | 1655 | 11 | 95 | 1549 | -30.5595 | 22.9375 | 2020-04-05 23:06:26 | South Africa | |||
3021880 | 3021880 | 2020-04-07 | South Africa | 1749 | 13 | 95 | 1641 | -30.5595 | 22.9375 | 2020-04-07 23:04:29 | South Africa | |||
3562205 | 3562205 | 2020-04-08 | South Africa | 1845 | 18 | 95 | 1732 | -30.5595 | 22.9375 | 2020-04-08 22:51:39 | South Africa | |||
3950098 | 3950098 | 2020-04-09 | South Africa | 1934 | 18 | 95 | 1821 | -30.5595 | 22.9375 | 2020-04-09 23:02:19 | South Africa | |||
1250361 | 1250361 | 2020-04-10 | South Africa | 2003 | 24 | 410 | 1569 | -30.5595 | 22.9375 | 2020-04-10 22:53:48 | South Africa | |||
2567176 | 2567176 | 2020-04-11 | South Africa | 2028 | 25 | 410 | 1593 | -30.5595 | 22.9375 | 2020-04-11 22:45:13 | South Africa | |||
2578339 | 2578339 | 2020-04-12 | South Africa | 2173 | 25 | 410 | 1738 | -30.5595 | 22.9375 | 2020-04-12 23:17:00 | 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 | |||
3338216 | 3338216 | 2020-04-14 | South Africa | 2415 | 27 | 410 | 1978 | -30.5595 | 22.9375 | 2020-04-14 23:33:12 | South Africa | |||
860300 | 860300 | 2020-04-15 | South Africa | 2506 | 34 | 410 | 2062 | -30.5595 | 22.9375 | 2020-04-15 22:56:32 | South Africa | |||
934406 | 934406 | 2020-04-16 | South Africa | 2605 | 48 | 903 | 1654 | -30.5595 | 22.9375 | 2020-04-16 23:30:31 | 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 | |||
418940 | 418940 | 2020-04-18 | South Africa | 3034 | 52 | 903 | 2079 | -30.5595 | 22.9375 | 2020-04-18 22:32:28 | South Africa | |||
1385252 | 1385252 | 2020-04-19 | South Africa | 3158 | 54 | 903 | 2201 | -30.5595 | 22.9375 | 2020-04-19 23:40:41 | South Africa | |||
2473560 | 2473560 | 2020-04-20 | South Africa | 3300 | 58 | 1055 | 2187 | -30.5595 | 22.9375 | 2020-04-20 23:36:27 | South Africa | |||
522478 | 522478 | 2020-04-21 | South Africa | 3465 | 58 | 1055 | 2352 | -30.5595 | 22.9375 | 2020-04-21 23:30:30 | South Africa | |||
1199412 | 1199412 | 2020-04-22 | South Africa | 3635 | 65 | 1055 | 2515 | -30.5595 | 22.9375 | 2020-04-22 23:30:32 | South Africa | |||
2524962 | 2524962 | 2020-04-23 | South Africa | 3953 | 75 | 1473 | 2405 | -30.5595 | 22.9375 | 2020-04-24 03:30:31 | South Africa | |||
1459373 | 1459373 | 2020-04-24 | South Africa | 4220 | 79 | 1473 | 2668 | -30.5595 | 22.9375 | 2020-04-25 06:30:33 | South Africa | |||
3502972 | 3502972 | 2020-04-25 | South Africa | 4361 | 86 | 1473 | 2802 | -30.5595 | 22.9375 | 2020-04-26 02:30:31 | South Africa | |||
3592623 | 3592623 | 2020-04-26 | South Africa | 4546 | 87 | 1473 | 2986 | -30.5595 | 22.9375 | 2020-04-27 02:30:33 | South Africa | |||
3589445 | 3589445 | 2020-04-27 | South Africa | 4793 | 90 | 1473 | 3230 | -30.5595 | 22.9375 | 2020-04-28 02:30:32 | 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 | |||
137576 | 137576 | 2020-04-29 | South Africa | 5350 | 103 | 2073 | 3174 | -30.5595 | 22.9375 | 2020-04-30 02:32:27 | 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 | |||
1184349 | 1184349 | 2020-05-01 | South Africa | 5951 | 116 | 2382 | 3453 | -30.5595 | 22.9375 | 2020-05-02 02:32:27 | South Africa | |||
2043455 | 2043455 | 2020-05-02 | South Africa | 6336 | 123 | 2549 | 3664 | -30.5595 | 22.9375 | 2020-05-03 02:32:28 | South Africa | |||
2278779 | 2278779 | 2020-05-03 | South Africa | 6783 | 131 | 2549 | 4103 | -30.5595 | 22.9375 | 2020-05-04 02:32:28 | South Africa | |||
3084920 | 3084920 | 2020-05-04 | South Africa | 7220 | 138 | 2746 | 4336 | -30.5595 | 22.9375 | 2020-05-05 02:32:34 | South Africa | |||
1932057 | 1932057 | 2020-05-05 | South Africa | 7572 | 148 | 2746 | 4678 | -30.5595 | 22.9375 | 2020-05-06 02:32:31 | South Africa | |||
2111017 | 2111017 | 2020-05-06 | South Africa | 7808 | 153 | 3153 | 4502 | -30.5595 | 22.9375 | 2020-05-07 02:32:28 | South Africa | |||
3295796 | 3295796 | 2020-05-07 | South Africa | 8232 | 161 | 3153 | 4918 | -30.5595 | 22.9375 | 2020-05-08 02:32:32 | 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 | |||
2899304 | 2899304 | 2020-05-09 | South Africa | 9420 | 186 | 3983 | 5251 | -30.5595 | 22.9375 | 2020-05-10 02:32:30 | South Africa | |||
3459763 | 3459763 | 2020-05-10 | South Africa | 10015 | 194 | 4173 | 5648 | -30.5595 | 22.9375 | 2020-05-11 02:32:30 | South Africa | |||
3331148 | 3331148 | 2020-05-11 | South Africa | 10652 | 206 | 4357 | 6089 | -30.5595 | 22.9375 | 2020-05-12 03:32:27 | South Africa | |||
2581614 | 2581614 | 2020-05-12 | South Africa | 11350 | 206 | 4357 | 6787 | -30.5595 | 22.9375 | 2020-05-13 03:32:26 | South Africa | |||
3847408 | 3847408 | 2020-05-13 | South Africa | 12074 | 219 | 4745 | 7110 | -30.5595 | 22.9375 | 2020-05-14 03:32:28 | South Africa | |||
1404646 | 1404646 | 2020-05-14 | South Africa | 12739 | 238 | 5676 | 6825 | -30.5595 | 22.9375 | 2020-05-15 02:33:02 | South Africa | |||
3276472 | 3276472 | 2020-05-15 | South Africa | 13524 | 247 | 6083 | 7194 | -30.5595 | 22.9375 | 2020-05-16 02:32:19 | South Africa | |||
1829756 | 1829756 | 2020-05-16 | South Africa | 14355 | 261 | 6478 | 7616 | -30.5595 | 22.9375 | 2020-05-17 02:32:32 | South Africa | |||
3416522 | 3416522 | 2020-05-17 | South Africa | 15515 | 264 | 7006 | 8245 | -30.5595 | 22.9375 | 2020-05-18 02:32:21 | South Africa | |||
3261128 | 3261128 | 2020-05-18 | South Africa | 16433 | 286 | 7298 | 8849 | -30.5595 | 22.9375 | 2020-05-19 02:32:18 | South Africa | |||
2390390 | 2390390 | 2020-05-19 | South Africa | 17200 | 312 | 7960 | 8928 | -30.5595 | 22.9375 | 2020-05-20 02:32:19 | South Africa | |||
1432170 | 1432170 | 2020-05-20 | South Africa | 18003 | 339 | 8950 | 8714 | -30.5595 | 22.9375 | 2020-05-21 02:32:48 | 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 | |||
1865081 | 1865081 | 2020-05-22 | South Africa | 20125 | 397 | 10104 | 9624 | -30.5595 | 22.9375 | 2020-05-23 02:32:42 | South Africa | |||
998058 | 998058 | 2020-05-23 | South Africa | 21343 | 407 | 10104 | 10832 | -30.5595 | 22.9375 | 2020-05-24 02:32:43 | South Africa | |||
875867 | 875867 | 2020-05-24 | South Africa | 22583 | 429 | 11100 | 11054 | -30.5595 | 22.9375 | 2020-05-25 02:32:44 | South Africa | |||
1105187 | 1105187 | 2020-05-25 | South Africa | 23615 | 481 | 11917 | 11217 | -30.5595 | 22.9375 | 2020-05-26 02:32:35 | South Africa | |||
1041457 | 1041457 | 2020-05-26 | South Africa | 24264 | 524 | 12741 | 10999 | -30.5595 | 22.9375 | 2020-05-27 02:32:31 | South Africa | |||
2548494 | 2548494 | 2020-05-27 | South Africa | 25937 | 552 | 13451 | 11934 | -30.5595 | 22.9375 | 2020-05-28 02:32:31 | South Africa | |||
2712575 | 2712575 | 2020-05-28 | South Africa | 27403 | 577 | 14370 | 12456 | -30.5595 | 22.9375 | 2020-05-29 02:32:50 | South Africa | |||
1790696 | 1790696 | 2020-05-29 | South Africa | 29240 | 611 | 15093 | 13536 | -30.5595 | 22.9375 | 2020-05-30 02:32:48 | South Africa | |||
3639156 | 3639156 | 2020-05-30 | South Africa | 30967 | 643 | 16116 | 14208 | -30.5595 | 22.9375 | 2020-05-31 02:32:45 | South Africa | |||
1794263 | 1794263 | 2020-05-31 | South Africa | 32683 | 683 | 16809 | 15191 | -30.5595 | 22.9375 | 2020-06-01 02:32:46 | South Africa | |||
805728 | 805728 | 2020-06-01 | South Africa | 34357 | 705 | 17291 | 16361 | -30.5595 | 22.9375 | 2020-06-02 02:33:08 | South Africa | |||
2556191 | 2556191 | 2020-06-02 | South Africa | 35812 | 755 | 18313 | 16744 | -30.5595 | 22.9375 | 2020-06-03 02:33:13 | South Africa | |||
3867149 | 3867149 | 2020-06-03 | South Africa | 37525 | 792 | 19682 | 17051 | -30.5595 | 22.9375 | 2020-06-04 02:33:14 | South Africa | |||
1281594 | 1281594 | 2020-06-04 | South Africa | 40792 | 848 | 21311 | 18633 | -30.5595 | 22.9375 | 2020-06-05 02:33:06 | South Africa | |||
1270134 | 1270134 | 2020-06-05 | South Africa | 43434 | 908 | 23088 | 19438 | -30.5595 | 22.9375 | 2020-06-06 02:33:00 | South Africa | |||
574437 | 574437 | 2020-06-06 | South Africa | 45973 | 952 | 24258 | 20763 | -30.5595 | 22.9375 | 2020-06-07 03:53:30 | South Africa | |||
2800381 | 2800381 | 2020-06-07 | South Africa | 48285 | 998 | 24364 | 22923 | -30.5595 | 22.9375 | 2020-06-08 03:33:22 | 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 | |||
1211157 | 1211157 | 2020-06-09 | South Africa | 52991 | 1162 | 29006 | 22823 | -30.5595 | 22.9375 | 2020-06-10 04:07:00 | South Africa | |||
2864338 | 2864338 | 2020-06-10 | South Africa | 55421 | 1210 | 31505 | 22706 | -30.5595 | 22.9375 | 2020-06-11 03:33:41 | South Africa | |||
1273899 | 1273899 | 2020-06-11 | South Africa | 58568 | 1284 | 33252 | 24032 | -30.5595 | 22.9375 | 2020-06-12 05:09:52 | South Africa | |||
737929 | 737929 | 2020-06-12 | South Africa | 61927 | 1354 | 35006 | 25567 | -30.5595 | 22.9375 | 2020-06-13 03:33:14 | South Africa | |||
3061609 | 3061609 | 2020-06-13 | South Africa | 65736 | 1423 | 36850 | 27463 | -30.5595 | 22.9375 | 2020-06-14 03:33:15 | South Africa | |||
1837557 | 1837557 | 2020-06-14 | South Africa | 70038 | 1480 | 38531 | 30027 | -30.5595 | 22.9375 | 2020-06-15 03:33:14 | 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 | |||
2387043 | 2387043 | 2020-06-16 | South Africa | 76334 | 1625 | 42063 | 32646 | -30.5595 | 22.9375 | 2020-06-17 04:33:21 | South Africa | |||
1196280 | 1196280 | 2020-06-17 | South Africa | 80412 | 1674 | 44331 | 34407 | -30.5595 | 22.9375 | 2020-06-18 04:33:18 | South Africa | |||
3683077 | 3683077 | 2020-06-18 | South Africa | 83890 | 1737 | 44920 | 37233 | -30.5595 | 22.9375 | 2020-06-19 04:33:17 | South Africa | |||
1691928 | 1691928 | 2020-06-19 | South Africa | 87715 | 1831 | 47825 | 38059 | -30.5595 | 22.9375 | 2020-06-20 04:33:19 | 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]);