NSW COVID-19 tests by location (discontinued) - COVID-19 tests by date and postcode, local health district, and local government area (discontinued).csv

COVID-19 tests by date and postcode, local health district, and local government area (discontinued).csv

Download URL: https://uatweb.datansw.links.com.au/data/dataset/209cc6ff-9f28-47c8-b440-5fb52ac0b23f/resource/a675ed8c-2baf-4685-8183-48c743257f3f/download/covid-19-tests-by-date-and-postcode-local-health-district-and-local-government-area.csv

COVID-19 tests by date and postcode, local health district, and local government area.

The data is for people tested for COVID-19 and is based on location of residence reported at the time of the test. A surge in total number of tests performed on a particular day may occur as the test results are updated in batches and new laboratories gain testing capacity.

The underlying dataset was assessed to measure the risk of identifying an individual and the level of sensitivity of the information gained if it was known that an individual was in the dataset. The dataset was then treated to mitigate these risks, including suppressing and aggregating data.

Details
Last updated	10/06/2020
Date Created	17/04/2020
File format	CSV
Licence	Creative Commons Attribution

Table

fullscreen Fullscreen

This resource view is not available at the moment. Click here for more information.

Download resource

Additional Information

Field	Value
Title	COVID-19 tests by date and postcode, local health district, and local government area (discontinued).csv
Data last updated	10/06/2020
Metadata last updated	14/12/2021
Format	CSV
License	Creative Commons Attribution
Size	30.41 MB

Data Dictionary

Label	Type	Description
test_date	timestamp
postcode	numeric
lhd_2010_code	text
lhd_2010_name	text
lga_code19	numeric
lga_name19	text

CKAN Data API

Access resource data via a web API with powerful query support. Further information in the main CKAN Data API and DataStore documentation.

Code examples:

curl JavaScript PowerShell Python R

Querying

Get 5 results containing "jones" in any field:

curl https://uatweb.datansw.links.com.au/data/api/action/datastore_search \
  -H"Authorization:$API_TOKEN" -d '
{
  "resource_id": "a675ed8c-2baf-4685-8183-48c743257f3f",
  "limit": 5,
  "q": "jones"
}'

const resp = await fetch(`https://uatweb.datansw.links.com.au/data/api/action/datastore_search`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({
        resource_id: 'a675ed8c-2baf-4685-8183-48c743257f3f',
        limit: 5,
        q: 'jones'
    })
})
await resp.json()

$json = @'
{
  "resource_id": "a675ed8c-2baf-4685-8183-48c743257f3f",
  "limit": 5,
  "q": "jones"
}
'@
$response = Invoke-RestMethod https://uatweb.datansw.links.com.au/data/api/action/datastore_search`
  -Method Post -Body $json -Headers @{"Authorization"="$API_TOKEN"}
$response.result.records

(using the ckanapi client library)

from ckanapi import RemoteCKAN

rc = RemoteCKAN('https://uatweb.datansw.links.com.au/data/', apikey=API_TOKEN)
result = rc.action.datastore_search(
    resource_id="a675ed8c-2baf-4685-8183-48c743257f3f",
    limit=5,
    q="jones",
)
print(result['records'])

library(httr2)

req <- request("https://uatweb.datansw.links.com.au/data/api/action/datastore_search")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id = 'a675ed8c-2baf-4685-8183-48c743257f3f',
        limit = 5,
        q = 'jones'))
    req_perform %>% 
    resp_body_json

Get results with either "watershed" or "survey" as subject and "active" as its stage:

curl https://uatweb.datansw.links.com.au/data/api/action/datastore_search \
-H"Authorization:$API_TOKEN" -d '
{
"resource_id": "a675ed8c-2baf-4685-8183-48c743257f3f",
  "filters": {
    "subject": ["watershed", "survey"],
    "stage": "active"
  }
}'

const resp = await fetch(`https://uatweb.datansw.links.com.au/data/api/action/datastore_search`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({resource_id: 'a675ed8c-2baf-4685-8183-48c743257f3f', filters: {
        subject: ['watershed', 'survey'],
        stage: 'active'
    }})})
await resp.json()

$json = @'
{
  "resource_id": "a675ed8c-2baf-4685-8183-48c743257f3f",
  "filters": {
    "subject": ["watershed", "survey"],
    "stage": "active"
  }
}
'@
$response = Invoke-RestMethod https://uatweb.datansw.links.com.au/data/api/action/datastore_search`
  -Method Post -Body $json -Headers @{"Authorization"="$API_TOKEN"}
$response.result.records

from ckanapi import RemoteCKAN

rc = RemoteCKAN('https://uatweb.datansw.links.com.au/data/', apikey=API_TOKEN)
result = rc.action.datastore_search(
    resource_id="a675ed8c-2baf-4685-8183-48c743257f3f",
    filters={
      "subject": ["watershed", "survey"],
      "stage": "active",
    },
)
print(result['records'])

library(httr2)

req <- request("https://uatweb.datansw.links.com.au/data/api/action/datastore_search")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id='a675ed8c-2baf-4685-8183-48c743257f3f', 
        filters = list(
            subject = list("watershed", "survey"), 
            stage = "active")))
    req_perform %>% 
    resp_body_json

Using the API with this Web Browser

Some API endpoints may be accessed using a GET query string.

Query example (first 5 results)

https://uatweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=a675ed8c-2baf-4685-8183-48c743257f3f&limit=5

Query example (results containing 'jones')

https://uatweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=a675ed8c-2baf-4685-8183-48c743257f3f&q=jones