--- title: Recorded criminal incidents by council area and month, NSW resource: https://publicdata.au/d/nsw-recorded-crime-by-lga/ publisher: NSW Bureau of Crime Statistics and Research licence: CC BY 4.0 licence_url: https://creativecommons.org/licenses/by/4.0/ version: 2026-09-16 rows: 3070116 fields: 5 source: https://bocsarblob.blob.core.windows.net/bocsar-open-data/RCI_offencebymonth.xlsm source_sha256: 9b13b9e878875b01a80d27703dc858c385ae693b5c929539079e135202e9484f language: en-AU operator: National Digital not_endorsed: true --- # Recorded criminal incidents by council area and month, NSW Criminal incidents recorded by NSW Police in each council area, month by month since January 1995, for 21 offence categories and their subcategories. Published by NSW Bureau of Crime Statistics and Research under CC BY 4.0 and republished here without change to the content. NSW Bureau of Crime Statistics and Research has not endorsed this site. Also called: BOCSAR recorded crime statistics, NSW recorded criminal incidents by LGA, NSW crime data by local government area, BOCSAR RCI offence by month. ## Download Latest version, redirects to `https://publicdata.au/d/nsw-recorded-crime-by-lga/v/2026-09-16/`: - parquet: https://publicdata.au/d/nsw-recorded-crime-by-lga/latest/data.parquet (1.8 MB) - json: https://publicdata.au/d/nsw-recorded-crime-by-lga/latest/data.json (399 MB) - csv: https://publicdata.au/d/nsw-recorded-crime-by-lga/latest/data.csv (200 MB) - sqlite: https://publicdata.au/d/nsw-recorded-crime-by-lga/latest/data.sqlite (409 MB) - ndjson: https://publicdata.au/d/nsw-recorded-crime-by-lga/latest/data.ndjson (396 MB) - arrow: https://publicdata.au/d/nsw-recorded-crime-by-lga/latest/data.arrow (27 MB) - csv.gz: https://publicdata.au/d/nsw-recorded-crime-by-lga/latest/data.csv.gz (12 MB) Pinned version 2026-09-16: `https://publicdata.au/d/nsw-recorded-crime-by-lga/v/2026-09-16/data.`. Dated versions never change. ## Smaller files - by `lga`: https://publicdata.au/d/nsw-recorded-crime-by-lga/v/2026-09-16/by/lga/index.json lists 131 files ## Fields | field | type | publisher's header | note | |---|---|---|---| | `lga` | string | LGA | Local government area as BOCSAR names it. | | `offence_category` | string | Offence category | | | `subcategory` | string | Subcategory | Blank where the category has no subcategories. An asterisk on a name is BOCSAR's own. | | `month` | date | (column header) | First day of the month the incidents were recorded in. | | `incidents` | integer | (cell) | Criminal incidents recorded by NSW Police in that month. | Key: `lga, offence_category, subcategory, month`. ## Versions - 2026-09-16: 3070116 rows, 5 fields, sha256 9b13b9e87887. https://publicdata.au/d/nsw-recorded-crime-by-lga/v/2026-09-16/ Machine-readable: https://publicdata.au/d/nsw-recorded-crime-by-lga/versions.json, https://publicdata.au/d/nsw-recorded-crime-by-lga/changes.json, https://publicdata.au/d/nsw-recorded-crime-by-lga/datapackage.json, https://publicdata.au/d/nsw-recorded-crime-by-lga/schema.json, https://publicdata.au/d/nsw-recorded-crime-by-lga/history.tar.zst ## Attribution and citation NSW Bureau of Crime Statistics and Research, Recorded criminal incidents by month by LGA, https://data.nsw.gov.au/data/dataset/nsw-crime-and-policing-statistics, accessed 28 September 2026, licensed under CC BY 4.0. The licence requires the publisher's attribution. We ask that you also name publicdata.au and link to the version you used. Plain text: NSW Bureau of Crime Statistics and Research, Recorded criminal incidents by month by LGA, https://data.nsw.gov.au/data/dataset/nsw-crime-and-policing-statistics, accessed 28 September 2026, licensed under CC BY 4.0. Serialised and versioned by National Digital at publicdata.au, https://publicdata.au/d/nsw-recorded-crime-by-lga/v/2026-09-16/ Markdown: Data: [Recorded criminal incidents by council area and month, NSW](https://data.nsw.gov.au/data/dataset/nsw-crime-and-policing-statistics), NSW Bureau of Crime Statistics and Research, [CC BY 4.0](https://creativecommons.org/licenses/by/4.0/), sourced 28 September 2026. Files: [publicdata.au](https://publicdata.au/d/nsw-recorded-crime-by-lga/v/2026-09-16/) by [National Digital](https://nationaldigital.com.au/). ## Questions ### How do I download Recorded criminal incidents by council area and month as a CSV file? Open https://publicdata.au/d/nsw-recorded-crime-by-lga/latest/data.csv. It redirects to the newest dated version, which is https://publicdata.au/d/nsw-recorded-crime-by-lga/v/2026-09-16/data.csv today. The same path serves Parquet, JSON, SQLite, NDJSON, Arrow. A dated URL never changes, so use it when the file must stay the same. ### Can I open Recorded criminal incidents by council area and month in Excel? Not as a workbook. Excel stops at 1,048,576 rows and this table has 3,070,116, so there is no data.xlsx. Load the CSV or the Parquet file with Power Query, or take one partition file at a time. https://publicdata.au/d/nsw-recorded-crime-by-lga/v/2026-09-16/data.csv.gz is the CSV at about a tenth of the size. ### What years does Recorded criminal incidents by council area and month cover? The current version covers 1995. Each release from BOCSAR becomes a new dated version here, and earlier versions stay online. ### How often is Recorded criminal incidents by council area and month updated? BOCSAR releases it quarterly. This site checks the portal every week and adds a dated version when the file changes. ### Can I use Recorded criminal incidents by council area and month commercially? Yes. CC BY 4.0 allows commercial use, redistribution and derived works as long as the attribution is kept. The attribution string is in this page's side column and inside every file. ### Is this the official source for Recorded criminal incidents by council area and month? No. The publisher is NSW Bureau of Crime Statistics and Research, and its page is https://data.nsw.gov.au/data/dataset/nsw-crime-and-policing-statistics. This site republishes the publisher's file without changing its content. The original sits beside every version as source.xlsm with its SHA-256, so the two can be compared. ### How do I get only the rows for one lga? Every version has one JSON file per value of lga, 131 files in the current version, listed with row counts at https://publicdata.au/d/nsw-recorded-crime-by-lga/v/2026-09-16/by/lga/index.json. For example https://publicdata.au/d/nsw-recorded-crime-by-lga/v/2026-09-16/by/lga/albury.json holds the 23,436 rows where lga is Albury. ### Why is this one row per month when the publisher's file has one column per month? The publisher's workbook has a column for every month since January 1995 and gains three columns each quarter. Each cell here is one row, with its council area, offence category, subcategory and month, so a new release adds rows instead of columns and every version has the same fields. No count is changed. ### Are these counts of offences or of people? They are criminal incidents recorded by NSW Police in each month. One incident can involve more than one person and more than one offence category. The publisher's notes on the portal explain how incidents are counted. ### How often is it updated? BOCSAR releases this dataset every quarter. Recent months can change when police records are updated, so a later version can revise an earlier month. ## What this site did to the data Cells were typed, headers were renamed to snake_case and the encoding was made UTF-8. Rows were left alone. Nothing is derived. The publisher's file is beside every version as `source.xlsm`.