daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,030 rows where country_or_region = "South Africa" sorted by day
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, day (date), last_update (date)
country_or_region 1
- South Africa · 1,030 ✖
province_or_state 0
day ▼ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-05 | South Africa | 1 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-05T13:53:03 | |||||
2020-03-06 | South Africa | 1 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-06T15:43:02 | |||||
2020-03-07 | South Africa | 1 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-06T15:43:02 | |||||
2020-03-08 | South Africa | 3 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-08T10:23:04 | |||||
2020-03-09 | South Africa | 3 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-08T10:23:04 | |||||
2020-03-10 | South Africa | 7 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-10T05:13:07 | |||||
2020-03-11 | South Africa | 13 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-11T10:33:03 | |||||
2020-03-12 | South Africa | 17 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-12T09:13:24 | |||||
2020-03-13 | South Africa | 24 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-11T20:00:00 | |||||
2020-03-14 | South Africa | 38 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-14T16:14:56 | |||||
2020-03-15 | South Africa | 51 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-15T18:20:18 | |||||
2020-03-16 | South Africa | 62 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-16T14:38:45 | |||||
2020-03-17 | South Africa | 62 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-16T14:38:45 | |||||
2020-03-18 | South Africa | 116 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-18T10:53:02 | |||||
2020-03-19 | South Africa | 150 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-19T16:43:03 | |||||
2020-03-20 | South Africa | 202 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-20T14:43:04 | |||||
2020-03-21 | South Africa | 240 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-21T12:13:19 | |||||
2020-03-22 | South Africa | 274 | 0 | 2 | 272 | -30.5595 | 22.9375 | 3/22/20 23:45 | South Africa | |||
2020-03-23 | South Africa | 402 | 0 | 4 | 398 | -30.5595 | 22.9375 | 2020-03-23 23:19:21 | South Africa | |||
2020-03-24 | South Africa | 554 | 0 | 4 | 550 | -30.5595 | 22.9375 | 2020-03-24 23:37:15 | South Africa | |||
2020-03-25 | South Africa | 709 | 0 | 12 | 697 | -30.5595 | 22.9375 | 2020-03-25 23:33:04 | South Africa | |||
2020-03-26 | South Africa | 927 | 0 | 12 | 915 | -30.5595 | 22.9375 | 2020-03-26 23:48:18 | South Africa | |||
2020-03-27 | South Africa | 1170 | 1 | 31 | 1138 | -30.5595 | 22.9375 | 2020-03-27 23:23:03 | South Africa | |||
2020-03-28 | South Africa | 1187 | 1 | 31 | 1155 | -30.5595 | 22.9375 | 3/28/20 23:05 | South Africa | |||
2020-03-29 | South Africa | 1280 | 2 | 31 | 1247 | -30.5595 | 22.9375 | 3/29/20 23:08 | South Africa | |||
2020-03-30 | South Africa | 1326 | 3 | 31 | 1292 | -30.5595 | 22.9375 | 3/30/20 22:52 | South Africa | |||
2020-03-31 | South Africa | 1353 | 5 | 31 | 1317 | -30.5595 | 22.9375 | 2020-03-31 23:43:43 | South Africa | |||
2020-04-01 | South Africa | 1380 | 5 | 50 | 1325 | -30.5595 | 22.9375 | 2020-04-01 21:58:34 | South Africa | |||
2020-04-02 | South Africa | 1462 | 5 | 50 | 1407 | -30.5595 | 22.9375 | 4/2/20 23:25 | South Africa | |||
2020-04-03 | South Africa | 1505 | 9 | 95 | 1401 | -30.5595 | 22.9375 | 2020-04-03 22:46:20 | South Africa | |||
2020-04-04 | South Africa | 1585 | 9 | 95 | 1481 | -30.5595 | 22.9375 | 4/4/20 23:34 | South Africa | |||
2020-04-05 | South Africa | 1655 | 11 | 95 | 1549 | -30.5595 | 22.9375 | 2020-04-05 23:06:26 | South Africa | |||
2020-04-06 | South Africa | 1686 | 12 | 95 | 1579 | -30.5595 | 22.9375 | 4/6/20 23:21 | South Africa | |||
2020-04-07 | South Africa | 1749 | 13 | 95 | 1641 | -30.5595 | 22.9375 | 2020-04-07 23:04:29 | South Africa | |||
2020-04-08 | South Africa | 1845 | 18 | 95 | 1732 | -30.5595 | 22.9375 | 2020-04-08 22:51:39 | South Africa | |||
2020-04-09 | South Africa | 1934 | 18 | 95 | 1821 | -30.5595 | 22.9375 | 2020-04-09 23:02:19 | South Africa | |||
2020-04-10 | South Africa | 2003 | 24 | 410 | 1569 | -30.5595 | 22.9375 | 2020-04-10 22:53:48 | South Africa | |||
2020-04-11 | South Africa | 2028 | 25 | 410 | 1593 | -30.5595 | 22.9375 | 2020-04-11 22:45:13 | South Africa | |||
2020-04-12 | South Africa | 2173 | 25 | 410 | 1738 | -30.5595 | 22.9375 | 2020-04-12 23:17:00 | South Africa | |||
2020-04-13 | South Africa | 2272 | 27 | 410 | 1835 | -30.5595 | 22.9375 | 2020-04-13 23:07:34 | South Africa | |||
2020-04-14 | South Africa | 2415 | 27 | 410 | 1978 | -30.5595 | 22.9375 | 2020-04-14 23:33:12 | South Africa | |||
2020-04-15 | South Africa | 2506 | 34 | 410 | 2062 | -30.5595 | 22.9375 | 2020-04-15 22:56:32 | South Africa | |||
2020-04-16 | South Africa | 2605 | 48 | 903 | 1654 | -30.5595 | 22.9375 | 2020-04-16 23:30:31 | South Africa | |||
2020-04-17 | South Africa | 2783 | 50 | 903 | 1830 | -30.5595 | 22.9375 | 2020-04-17 23:30:32 | South Africa | |||
2020-04-18 | South Africa | 3034 | 52 | 903 | 2079 | -30.5595 | 22.9375 | 2020-04-18 22:32:28 | South Africa | |||
2020-04-19 | South Africa | 3158 | 54 | 903 | 2201 | -30.5595 | 22.9375 | 2020-04-19 23:40:41 | South Africa | |||
2020-04-20 | South Africa | 3300 | 58 | 1055 | 2187 | -30.5595 | 22.9375 | 2020-04-20 23:36:27 | South Africa | |||
2020-04-21 | South Africa | 3465 | 58 | 1055 | 2352 | -30.5595 | 22.9375 | 2020-04-21 23:30:30 | South Africa | |||
2020-04-22 | South Africa | 3635 | 65 | 1055 | 2515 | -30.5595 | 22.9375 | 2020-04-22 23:30:32 | South Africa | |||
2020-04-23 | South Africa | 3953 | 75 | 1473 | 2405 | -30.5595 | 22.9375 | 2020-04-24 03:30:31 | South Africa | |||
2020-04-24 | South Africa | 4220 | 79 | 1473 | 2668 | -30.5595 | 22.9375 | 2020-04-25 06:30:33 | South Africa | |||
2020-04-25 | South Africa | 4361 | 86 | 1473 | 2802 | -30.5595 | 22.9375 | 2020-04-26 02:30:31 | South Africa | |||
2020-04-26 | South Africa | 4546 | 87 | 1473 | 2986 | -30.5595 | 22.9375 | 2020-04-27 02:30:33 | South Africa | |||
2020-04-27 | South Africa | 4793 | 90 | 1473 | 3230 | -30.5595 | 22.9375 | 2020-04-28 02:30:32 | South Africa | |||
2020-04-28 | South Africa | 4996 | 93 | 2073 | 2830 | -30.5595 | 22.9375 | 2020-04-29 02:32:29 | South Africa | |||
2020-04-29 | South Africa | 5350 | 103 | 2073 | 3174 | -30.5595 | 22.9375 | 2020-04-30 02:32:27 | South Africa | |||
2020-04-30 | South Africa | 5647 | 103 | 2073 | 3471 | -30.5595 | 22.9375 | 2020-05-01 02:32:28 | South Africa | |||
2020-05-01 | South Africa | 5951 | 116 | 2382 | 3453 | -30.5595 | 22.9375 | 2020-05-02 02:32:27 | South Africa | |||
2020-05-02 | South Africa | 6336 | 123 | 2549 | 3664 | -30.5595 | 22.9375 | 2020-05-03 02:32:28 | South Africa | |||
2020-05-03 | South Africa | 6783 | 131 | 2549 | 4103 | -30.5595 | 22.9375 | 2020-05-04 02:32:28 | South Africa | |||
2020-05-04 | South Africa | 7220 | 138 | 2746 | 4336 | -30.5595 | 22.9375 | 2020-05-05 02:32:34 | South Africa | |||
2020-05-05 | South Africa | 7572 | 148 | 2746 | 4678 | -30.5595 | 22.9375 | 2020-05-06 02:32:31 | South Africa | |||
2020-05-06 | South Africa | 7808 | 153 | 3153 | 4502 | -30.5595 | 22.9375 | 2020-05-07 02:32:28 | South Africa | |||
2020-05-07 | South Africa | 8232 | 161 | 3153 | 4918 | -30.5595 | 22.9375 | 2020-05-08 02:32:32 | South Africa | |||
2020-05-08 | South Africa | 8895 | 178 | 3153 | 5564 | -30.5595 | 22.9375 | 2020-05-09 02:32:35 | South Africa | |||
2020-05-09 | South Africa | 9420 | 186 | 3983 | 5251 | -30.5595 | 22.9375 | 2020-05-10 02:32:30 | South Africa | |||
2020-05-10 | South Africa | 10015 | 194 | 4173 | 5648 | -30.5595 | 22.9375 | 2020-05-11 02:32:30 | South Africa | |||
2020-05-11 | South Africa | 10652 | 206 | 4357 | 6089 | -30.5595 | 22.9375 | 2020-05-12 03:32:27 | South Africa | |||
2020-05-12 | South Africa | 11350 | 206 | 4357 | 6787 | -30.5595 | 22.9375 | 2020-05-13 03:32:26 | South Africa | |||
2020-05-13 | South Africa | 12074 | 219 | 4745 | 7110 | -30.5595 | 22.9375 | 2020-05-14 03:32:28 | South Africa | |||
2020-05-14 | South Africa | 12739 | 238 | 5676 | 6825 | -30.5595 | 22.9375 | 2020-05-15 02:33:02 | South Africa | |||
2020-05-15 | South Africa | 13524 | 247 | 6083 | 7194 | -30.5595 | 22.9375 | 2020-05-16 02:32:19 | South Africa | |||
2020-05-16 | South Africa | 14355 | 261 | 6478 | 7616 | -30.5595 | 22.9375 | 2020-05-17 02:32:32 | South Africa | |||
2020-05-17 | South Africa | 15515 | 264 | 7006 | 8245 | -30.5595 | 22.9375 | 2020-05-18 02:32:21 | South Africa | |||
2020-05-18 | South Africa | 16433 | 286 | 7298 | 8849 | -30.5595 | 22.9375 | 2020-05-19 02:32:18 | South Africa | |||
2020-05-19 | South Africa | 17200 | 312 | 7960 | 8928 | -30.5595 | 22.9375 | 2020-05-20 02:32:19 | South Africa | |||
2020-05-20 | South Africa | 18003 | 339 | 8950 | 8714 | -30.5595 | 22.9375 | 2020-05-21 02:32:48 | South Africa | |||
2020-05-21 | South Africa | 19137 | 369 | 8950 | 9818 | -30.5595 | 22.9375 | 2020-05-22 02:36:51 | South Africa | |||
2020-05-22 | South Africa | 20125 | 397 | 10104 | 9624 | -30.5595 | 22.9375 | 2020-05-23 02:32:42 | South Africa | |||
2020-05-23 | South Africa | 21343 | 407 | 10104 | 10832 | -30.5595 | 22.9375 | 2020-05-24 02:32:43 | South Africa | |||
2020-05-24 | South Africa | 22583 | 429 | 11100 | 11054 | -30.5595 | 22.9375 | 2020-05-25 02:32:44 | South Africa | |||
2020-05-25 | South Africa | 23615 | 481 | 11917 | 11217 | -30.5595 | 22.9375 | 2020-05-26 02:32:35 | South Africa | |||
2020-05-26 | South Africa | 24264 | 524 | 12741 | 10999 | -30.5595 | 22.9375 | 2020-05-27 02:32:31 | South Africa | |||
2020-05-27 | South Africa | 25937 | 552 | 13451 | 11934 | -30.5595 | 22.9375 | 2020-05-28 02:32:31 | South Africa | |||
2020-05-28 | South Africa | 27403 | 577 | 14370 | 12456 | -30.5595 | 22.9375 | 2020-05-29 02:32:50 | South Africa | |||
2020-05-29 | South Africa | 29240 | 611 | 15093 | 13536 | -30.5595 | 22.9375 | 2020-05-30 02:32:48 | South Africa | |||
2020-05-30 | South Africa | 30967 | 643 | 16116 | 14208 | -30.5595 | 22.9375 | 2020-05-31 02:32:45 | South Africa | |||
2020-05-31 | South Africa | 32683 | 683 | 16809 | 15191 | -30.5595 | 22.9375 | 2020-06-01 02:32:46 | South Africa | |||
2020-06-01 | South Africa | 34357 | 705 | 17291 | 16361 | -30.5595 | 22.9375 | 2020-06-02 02:33:08 | South Africa | |||
2020-06-02 | South Africa | 35812 | 755 | 18313 | 16744 | -30.5595 | 22.9375 | 2020-06-03 02:33:13 | South Africa | |||
2020-06-03 | South Africa | 37525 | 792 | 19682 | 17051 | -30.5595 | 22.9375 | 2020-06-04 02:33:14 | South Africa | |||
2020-06-04 | South Africa | 40792 | 848 | 21311 | 18633 | -30.5595 | 22.9375 | 2020-06-05 02:33:06 | South Africa | |||
2020-06-05 | South Africa | 43434 | 908 | 23088 | 19438 | -30.5595 | 22.9375 | 2020-06-06 02:33:00 | South Africa | |||
2020-06-06 | South Africa | 45973 | 952 | 24258 | 20763 | -30.5595 | 22.9375 | 2020-06-07 03:53:30 | South Africa | |||
2020-06-07 | South Africa | 48285 | 998 | 24364 | 22923 | -30.5595 | 22.9375 | 2020-06-08 03:33:22 | South Africa | |||
2020-06-08 | South Africa | 50879 | 1080 | 26099 | 23700 | -30.5595 | 22.9375 | 2020-06-09 03:33:03 | South Africa | |||
2020-06-09 | South Africa | 52991 | 1162 | 29006 | 22823 | -30.5595 | 22.9375 | 2020-06-10 04:07:00 | South Africa | |||
2020-06-10 | South Africa | 55421 | 1210 | 31505 | 22706 | -30.5595 | 22.9375 | 2020-06-11 03:33:41 | South Africa | |||
2020-06-11 | South Africa | 58568 | 1284 | 33252 | 24032 | -30.5595 | 22.9375 | 2020-06-12 05:09:52 | South Africa | |||
2020-06-12 | South Africa | 61927 | 1354 | 35006 | 25567 | -30.5595 | 22.9375 | 2020-06-13 03:33:14 | South Africa |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;