[Feature] Hospital and district data for visualisation about covid19za HOT 18 CLOSED

You might also want to dig into https://opendataza.gitbook.io/toolkit/open-data-resources/healthcare-data-resources

@elolelo and @MikeMcMalace

from covid19za.

The data on that link is from WIkiData. So wikidata would have to be updated. We have a volunteer from Codebridge who says they will update during the week.

from covid19za.

Think now getting per hospital ICU is next

Also thanks @elolelo

from covid19za.

Thank you @elolelo, this is great!

from covid19za.

See https://w.wiki/Ksn

from covid19za.

Yes. Unfortunately, there are some issues in the data (unless they updated it within the last day). The biggest problem is district information and bed capacity. Each district hospital (according to the South African DoH) is categorised as either small, medium or large. In addition to this, each district has its own capacity (or estimated capacity). The hospital data have been updated, and thank you @elolelo for your valuable contribution into this matter. The problem right now is we want to have certain information on a map, that details the hospital, what it can and cannot do, and have information about the district included in it.

Something similar to this: https://codebridge-za.github.io/seeking-shelter/index.html

but with the details of this: https://www.healthestablishments.org.za/Home/Facility

and with the added district data and information about the hospital capacity.

The reason for this is we know which hospitals are COVID-19 ready. We also have amazing tools like the links here, which are very useful, but not if you have a medical emergency other than COVID-19, or COVID-19. When doing this search, I was shocked at how much digging one needs to do, not just for South Africa, but in general in Africa to find this information. The idea is to consolidate information in a way that is useful and usable to a person who is not a tech enthusiast, and who just has a cellphone.

from covid19za.

Please view the current KZN data below
16_03_2020_KZNHospitalDatabase.xlsx

from covid19za.

See health_system_za_public* files in data/

populating with a few examples is needed.

from covid19za.

The Department of Health for each South African province has this data, but it is scattered and there is not consistent format between the different departments. Consolidating this information as a dataset will be valuable for visualisation as well as for analytics related to capacity and systems.

from covid19za.

See

General: https://github.com/dsfsi/covid19za/blob/master/data/health_system_za_public_hospitals.csv
Detailed: https://github.com/dsfsi/covid19za/blob/master/data/health_system_za_public_hospitals_extended_details.csv
Contacts: https://github.com/dsfsi/covid19za/blob/master/data/health_system_za_public_hospitals_contacts.csv

from covid19za.

@MikeMcMalace See latest commit to branch Hospital_data

from covid19za.

Hey @MikeMcMalace how are we doing here?

from covid19za.

Her @vukosim , currently with regard to the district data we have 351 hospitals, with complete data except for 2 with missing geodata. Unfortunately, name changes etc. complicate this a bit.
20_03_2020_CurrentHospitalData_12_05pm.xlsx

from covid19za.

@MikeMcMalace please see the Hospital Data branch. I would suggest you work on that as it also has info on where the data came from as per @elolelo

from covid19za.

Fantastic! Is this linked?
I see now that it contains 202 points - the cases? Should we superimpose the geodata to this?

from covid19za.

and apologies if you already have this, but there's quite detailed descriptions of each facility (down to the ward level? not sure about capacity) here on the NIDS site:
https://dd.dhmis.org/orgunits.html?file=NIDS%20Integrated&source=nids

from covid19za.

@MikeMcMalace Hey Mike, did you get a chance to check this out?

from covid19za.

This is being addressed in #115

from covid19za.