[CRP Data Analytic] Project Covid-19
Amin Khasyim Azuz Putra
Intro
On 11 March 2020, WHO declared outbreaks as pandemic, after the case surpassed 100,000 rapidly and spread throughout the globe by today which the project begin are already over 4 million confirmed cases throughout the globe.
The project it self focus in indonesia, right now the confirm case in indonesia are 14,032 and 34 provinces have been affected by Covid-19 with the prediction that every day positive cases will continue to grow.
The way for the government to reduce the number of cases is by implementing the PSBB (Large-Scale Social Restriction) and now there are 2 provinces and 18 cities that apply the PSBB.
How i get the data
The project start at 7 may 2020 gather the data in a various source such as Google News, Bnpb and local online media. To get the real time data i go to bnpb website, search by typing the keyword and download it.
After it, i start filtering and search for uncorrelated data, cleaning it to make the data understandable get to use it all and visualize it to make a better understandment for a viewer how the data is.
The project it self to know, how the Covid trendline until 7 may 2020 and also use the recently data to make a comparison until the project ended.
Confirm Case per Province
By the 7 may 2020, there is 12754 confirmed case at indonesia itself, with the most cases are at DKI Jakarta with 4855 cases (38,1%), West Java with 1381 cases (10,8%) and East Java with 1267 cases (9,9%). The lowest case are at East Nusa Tenggara with 12 cases (0,1%), Bengkulu with 14 cases (0,1%) and Aceh with 17 cases (0,1%).
Cured Cases per Province
The total cured cases by the 7 may 2020 are 2381 cases with the most cases are at DKI Jakarta with 745 cases (31,3%), South Sulawesi with 238 cases (10,0%) and East Java with 208 cases (8,7%). The lowest case are at West Papua are still 0 cases, Bengkulu and Jambi is still at 1 case of cured case (0,0%).
Dead Cases per Province
The total dead cases by the 7 may 2020 are 930 cases, with the most cases are at DKI Jakarta with 423 cases (45,5%), East Java with 133 cases ( 14,3%) and West Java with 90 cases (9,7%). The lowest cases are at Jambi, Maluku and North Maluku have a same number which is 0 case or there is not any dead report yet in those province.
79%
With confirm case are growing and within each day still far from over especially in Indonesia, what a community can do is keep hygiene, eat a nutritious food and follow the government instruction.
Average Number Cases per Day
Since the start of the first case of Covid-19 which at 2 March 2020, the graph shown increased number especially at 4 May 2020 the new confirmed case with 484 case will be likely grown if there is no significant attempt to stop the exposure. The total of confirmed case per 7 May 2020 are 12776 cases, cured cases with 2381 cases, dead cases with 930 cases and Number of cases treated with 9465 cases.
Cases of Patients Died and Recovered
Within timeline until 7 May 2020 as seen on the graph, cases of patients recovering were seen to be significantly increased, namely on April 16, 2020 with 10% of patients recovering from treatment and dropping significantly with a percentage rate of 1% the following day. But on the graph the case of patients who died looks more stable, this began on 8 March 2020 the death rate rose 8% and the following day rose 1% and fell back to 7% on 4 May 2020.
The number of patients and cases examined
The graph shown the number of patients and case per day start 2 march 2020 and end at 7 may 2020 with the highest number of cases were examined daily for new specimens with 7111 cases examined at 12 April 2020 with a negative case until 7 May 2020 1,437,640 negative exposure for covid-19
Comparison confirmed case for Covid-19 (7 May 2020 and 12 May 2020)
Comparison cured case for Covid-19 (7 May 2020 and 12 May 2020)
Comparison death case for Covid-19 (7 May 2020 and 12 May 2020)
Comparison total case for Covid-19 (7 May 2020 and 12 May 2020)
At the end of the project which at 12th May 2020, the number of ODP status figures dropped by 4%, which means the patient's status has changed to PDP or Covid-19 negative. **The number are not fixed and will continuously change since that the data received by real time from official government website.
Summary
The Covid-19 is not only a national issue but is a international issue and already effected an economy around the world. As a large a communities what we can do is follow government instruction such as personal hygine, wear a mask if going out, eat a nutritious food and pray this matter will come to end soon.
As the issue not shown decreasing of confirmed case, what a community can do is follow government instruction for cleaning safety and eat nutritious.