NSW public schools master dataset

Download URL: https://uatweb.datansw.links.com.au/data/dataset/12ee4909-cd21-4105-9847-6cab1dfbfed4/resource/e40f428b-eec9-4d58-a404-17c932094ad7/download/master_dataset.csv

Details
Last updated	02/07/2025
Date Created	02/07/2025
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	NSW public schools master dataset
Data last updated	02/07/2025
Metadata last updated	04/07/2025
Format	CSV
License	Creative Commons Attribution
Size	1.22 MB

Data Dictionary

Label	Type	Description
School_code	text
AgeID	text
School_name	text
Street	text
Town_suburb	text
Postcode	text
Phone	text
School_Email	text
Website	text
Fax	text
latest_year_enrolment_FTE	text
Indigenous_pct	text
LBOTE_pct	text
ICSEA_value	text
Level_of_schooling	text
Selective_school	text
Opportunity_class	text
School_specialty_type	text
School_subtype	text
Support_classes	text
Preschool_ind	text
Distance_education	text
Intensive_english_centre	text
School_gender	text
Late_opening_school	text
Date_1st_teacher	text
LGA	text
electorate_from_2023	text
electorate_2015_2022	text
fed_electorate_from_2025	text
fed_electorate_2016_2024	text
Operational_directorate	text
Principal_network	text
Operational_directorate_office	text
Operational_directorate_office_phone	text
Operational_directorate_office_address	text
FACS_district	text
Local_health_district	text
AECG_region	text
ASGS_remoteness	text
Latitude	text
Longitude	text
Assets unit	text
SA4	text
FOEI_Value	text
Date_extracted	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": "e40f428b-eec9-4d58-a404-17c932094ad7",
  "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: 'e40f428b-eec9-4d58-a404-17c932094ad7',
        limit: 5,
        q: 'jones'
    })
})
await resp.json()

$json = @'
{
  "resource_id": "e40f428b-eec9-4d58-a404-17c932094ad7",
  "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="e40f428b-eec9-4d58-a404-17c932094ad7",
    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 = 'e40f428b-eec9-4d58-a404-17c932094ad7',
        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": "e40f428b-eec9-4d58-a404-17c932094ad7",
  "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: 'e40f428b-eec9-4d58-a404-17c932094ad7', filters: {
        subject: ['watershed', 'survey'],
        stage: 'active'
    }})})
await resp.json()

$json = @'
{
  "resource_id": "e40f428b-eec9-4d58-a404-17c932094ad7",
  "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="e40f428b-eec9-4d58-a404-17c932094ad7",
    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='e40f428b-eec9-4d58-a404-17c932094ad7', 
        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=e40f428b-eec9-4d58-a404-17c932094ad7&limit=5

Query example (results containing 'jones')

https://uatweb.datansw.links.com.au/data/api/action/datastore_search?resource_id=e40f428b-eec9-4d58-a404-17c932094ad7&q=jones