nzherald / nz-covid19-data Goto Github PK

South Canterbury isn't a Regional Council region (though it's a DHB). Should it be merged with Canterbury in the Region field?

Is that published anywhere? A.B. just said 9780 so far, if I heard correctly

Hi there!

I have been scraping the MOH, MSD and covid19.govt.nz sites for a few days now and making the data available via a web API in various formats:

https://nzcovid19api.xerra.nz/

You might find the code that does the scraping useful in an offline workflow (the command line tool can output CSV and JSON): https://github.com/simeonmiteff/nzcovid19cases

Some researchers have asked me for reported dates, and I have spent some time manually joining these with the MOH table in this Google Sheet (which pulls the table from the API's CSV feed using the IMPORTDATA() function that updates every 30 minutes):

https://docs.google.com/spreadsheets/d/1NJiDg2z7Y79RUkQ-a648fFD_EmziztYLLkQW_FOrLGo/edit#gid=576672848

Please let me know if I can help out in some way.

More generally, I know of at least one initiative to build a sensible data format for MOH to do their reporting, but I don't know if there is anyone on the ministry's end to take this on (especially given that I think they have bigger problems right now).

I also found that the MOH site gets overloaded once a day, and at other times has a nasty caching bug where it alternately serves the latest, and outdated versions of the COVID-19 case page. I've been trying to find out who the tech contact is there (to offer help), but no luck yet. Please let me know if you know someone who can connect me at MOH.

Regards,
Simeon.

https://github.com/lazd/coronadatascraper

I guess you folks have seen that MOH reworked the cases page now to show only case statistics.

Does someone who MOH takes seriously (NZ Herald?) know if they plan to publish individual case information at all?

Hi @vizowl

I did some poking around the arcgis.com dashboard linked from the MOH webste and found that it is pulling some tables that appear to be obtained from, or maintained by https://www.esr.cri.nz/. This gels with the intel @gizmoguy gathered earlier in the week (I suspect he looked at the author names in the spreadsheet metadata and tied that back to ESR).

I worked out that the right query string dumps these tables in JSON format:

• Daily_ESR_Update_Cases
• Daily_ESR_Update_DHB

Perhaps using these would be better than working with the spreadsheets?

Regards,
Simeon.

Hello,Your dataset was added to CoronaWhy (https://www.coronawhy.org/) Data Lake on Dataverse as a piece of common COVID-19 dataframe http://datasets.coronawhy.org/dataset.xhtml?persistentId=doi:10.5072/FK2/NC8TLY

Would you be willing to help with maintenance of your dataset in Dataverse, e.g. adding the relevant metadata and keeping the dataset up-to-date? That will help to make the dataset findable and accessible for medical science community.

I have made a request to MoH (through the feedback button) to add date of likely infection, swab date, and recovery/death date. You may have more away than me though.