Difference in total COVID-19 cases between Excel (csv) and JSON download

Hi,
I’ve been downloading the COVID-19 cases data for NSW via CSV format for loading into our data cubes. It returns the right cases - 3082, as at 22/5/20.

I’m looking to better automate the process so did a JSON download instead. This returns 2938 cases. A difference of 142.

I think these look like cases where the full details aren’t currently available.

Could the JSON download be made to match the CSV download?

Thanks,
Shane

Hi shaneg,

You can call the dataset API (https://data.nsw.gov.au/data/api/1/util/snippet/api_info.html?resource_id=2776dbb8-f807-4fb2-b1ed-184a6fc2c8aa) to automate the ingestion. This data is identical to the csv download.

Please let us know if you have any further issues.

Regards,
Lance

Thanks Lance, I’ll give that a try.

Shane

© Data.NSW