NSW Crime and policing statistics - 2 and 10 year trends for 62 offence categories, by LGA

NSW Bureau of Crime Statistics and Research

2 and 10 year trends for 62 offence categories, by LGA

Download URL: https://bocsar.nsw.gov.au/content/dam/dcj/bocsar/documents/open-datasets/LGA_trends.xlsx

2 and 5 year trends for the 17 major offences by LGA

Details
Last updated	23/04/2026
Date Created	10/04/2019
File format	XLSX
Licence	Creative Commons Attribution

fullscreen Fullscreen

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

Download resource

Additional Information

Field	Value
Title	2 and 10 year trends for 62 offence categories, by LGA
Data last updated	23/04/2026
Metadata last updated	28/04/2026
Format	XLSX
License	Creative Commons Attribution
Original URL	https://bocsar.nsw.gov.au/content/dam/dcj/bocsar/documents/open-datasets/LGA_trends.xlsx

Data Dictionary

Label	Type	Description
Local Government Area	text
Offence type	text
Jan - Dec 2016	text
Jan - Dec 2017	text
Jan - Dec 2018	text
Jan - Dec 2019	text
Jan - Dec 2020	text
Jan - Dec 2021	text
Jan - Dec 2022	text
Jan - Dec 2023	text
Jan - Dec 2024	text
Jan - Dec 2025	text
Rate per 100,000 population Jan - Dec 2025	text
LGA Rank Jan - Dec 2025	text
2 year trend and annual percent change (Jan 2024-Dec 2025)	text
10 year trend and average annual percent change (Jan 2016-Dec 2	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://data.nsw.gov.au/data/api/action/datastore_search \
  -H"Authorization:$API_TOKEN" -d '
{
  "resource_id": "f69edb1e-a26d-4d5d-a963-593182ce55d8",
  "limit": 5,
  "q": "jones"
}'

const resp = await fetch(`https://data.nsw.gov.au/data/api/action/datastore_search`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({
        resource_id: 'f69edb1e-a26d-4d5d-a963-593182ce55d8',
        limit: 5,
        q: 'jones'
    })
})
await resp.json()

$json = @'
{
  "resource_id": "f69edb1e-a26d-4d5d-a963-593182ce55d8",
  "limit": 5,
  "q": "jones"
}
'@
$response = Invoke-RestMethod https://data.nsw.gov.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://data.nsw.gov.au/data/', apikey=API_TOKEN)
result = rc.action.datastore_search(
    resource_id="f69edb1e-a26d-4d5d-a963-593182ce55d8",
    limit=5,
    q="jones",
)
print(result['records'])

library(httr2)

req <- request("https://data.nsw.gov.au/data/api/action/datastore_search")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id = 'f69edb1e-a26d-4d5d-a963-593182ce55d8',
        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://data.nsw.gov.au/data/api/action/datastore_search \
-H"Authorization:$API_TOKEN" -d '
{
"resource_id": "f69edb1e-a26d-4d5d-a963-593182ce55d8",
  "filters": {
    "subject": ["watershed", "survey"],
    "stage": "active"
  }
}'

const resp = await fetch(`https://data.nsw.gov.au/data/api/action/datastore_search`, {
    method: 'POST',
    headers: {
        'content-type': 'application/json',
        authorization: API_TOKEN
    },
    body: JSON.stringify({resource_id: 'f69edb1e-a26d-4d5d-a963-593182ce55d8', filters: {
        subject: ['watershed', 'survey'],
        stage: 'active'
    }})})
await resp.json()

$json = @'
{
  "resource_id": "f69edb1e-a26d-4d5d-a963-593182ce55d8",
  "filters": {
    "subject": ["watershed", "survey"],
    "stage": "active"
  }
}
'@
$response = Invoke-RestMethod https://data.nsw.gov.au/data/api/action/datastore_search`
  -Method Post -Body $json -Headers @{"Authorization"="$API_TOKEN"}
$response.result.records

from ckanapi import RemoteCKAN

rc = RemoteCKAN('https://data.nsw.gov.au/data/', apikey=API_TOKEN)
result = rc.action.datastore_search(
    resource_id="f69edb1e-a26d-4d5d-a963-593182ce55d8",
    filters={
      "subject": ["watershed", "survey"],
      "stage": "active",
    },
)
print(result['records'])

library(httr2)

req <- request("https://data.nsw.gov.au/data/api/action/datastore_search")
result <- req %>% 
    req_headers(Authorization = API_TOKEN) %>% 
    req_body_json(list(
        resource_id='f69edb1e-a26d-4d5d-a963-593182ce55d8', 
        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://data.nsw.gov.au/data/api/action/datastore_search?resource_id=f69edb1e-a26d-4d5d-a963-593182ce55d8&limit=5

Query example (results containing 'jones')

https://data.nsw.gov.au/data/api/action/datastore_search?resource_id=f69edb1e-a26d-4d5d-a963-593182ce55d8&q=jones