--- title: Occupational licences held by type and region, Queensland, latest count resource: https://publicdata.au/d/qld-fair-trading-licences-by-region/ publisher: Department of Justice licence: CC BY 3.0 AU licence_url: https://creativecommons.org/licenses/by/3.0/au/ version: 2026-05-07 rows: 14 fields: 12 source: https://www.data.qld.gov.au/dataset/3e8e365c-99a5-4641-87b8-0e6b8e345193/resource/fd217d88-7601-418c-9dcb-fb6ec36da933/download/6.-oft-register-macs-as-at-1-april-2026.csv source_sha256: 034e8cd9701c978af31aac4aa05d66bebfaa2476111318b1f24d425b6580453e language: en-AU operator: National Digital not_endorsed: true --- # Occupational licences held by type and region, Queensland, latest count The number of occupational and industry licences the Queensland Office of Fair Trading administers, by licence type and office region, on the newest count date. Published by Department of Justice under CC BY 3.0 AU and republished here in other formats, with cells typed and suppressed values made null. Department of Justice has not endorsed this site. Also called: Office of Fair Trading licence statistics, Number of real estate agents in Queensland, Licensed security providers Queensland by region. ## Download Latest version, redirects to `https://publicdata.au/d/qld-fair-trading-licences-by-region/v/2026-05-07/`: - csv: https://publicdata.au/d/qld-fair-trading-licences-by-region/latest/data.csv (963 B) - xlsx: https://publicdata.au/d/qld-fair-trading-licences-by-region/latest/data.xlsx (9.4 KB) - json: https://publicdata.au/d/qld-fair-trading-licences-by-region/latest/data.json (5.7 KB) - parquet: https://publicdata.au/d/qld-fair-trading-licences-by-region/latest/data.parquet (9.6 KB) - sqlite: https://publicdata.au/d/qld-fair-trading-licences-by-region/latest/data.sqlite (29 KB) - duckdb: https://publicdata.au/d/qld-fair-trading-licences-by-region/latest/data.duckdb (100 KB) - ndjson: https://publicdata.au/d/qld-fair-trading-licences-by-region/latest/data.ndjson (4.9 KB) - arrow: https://publicdata.au/d/qld-fair-trading-licences-by-region/latest/data.arrow (7.6 KB) - csv.gz: https://publicdata.au/d/qld-fair-trading-licences-by-region/latest/data.csv.gz (617 B) Pinned version 2026-05-07: `https://publicdata.au/d/qld-fair-trading-licences-by-region/v/2026-05-07/data.`. Dated versions never change. ## Query The query API returns only the rows you ask for, as JSON, NDJSON or CSV, from the same typed rows as the files. It needs no key. Rows: https://publicdata.au/api/v1/datasets/qld-fair-trading-licences-by-region/rows. Counts and sums: https://publicdata.au/api/v1/datasets/qld-fair-trading-licences-by-region/aggregate. - Rows: https://publicdata.au/api/v1/datasets/qld-fair-trading-licences-by-region/rows?licence_type=neq.Grand%20Total&limit=5 - Aggregate: https://publicdata.au/api/v1/datasets/qld-fair-trading-licences-by-region/aggregate?group=licence_type&metric=sum.all_regions&licence_type=neq.Grand%20Total Each filter is `field=operator.value` in the query string, and every filter must match. A number or date field compares as a number or date, and a text field compares as text. Values are case-sensitive except with `ilike`. Prefix `not.` to negate a filter, as `not.eq.value`. Operators: `eq.value`, `neq.value`, `gt.value`, `gte.value`, `lt.value`, `lte.value`, `like.*text*`, `ilike.*text*`, `in.(a,b,c)`, `is.null`. - `select`: Fields to return, comma-separated. Every field when absent. - `order`: `field.asc` or `field.desc`, comma-separated. The publisher's row order when absent. - `limit`: Rows per page, 1 to 10,000. 100 when absent. - `offset`: Rows to skip. The `next` URL in each answer sets it for you. - `group`: On `aggregate`, fields to group by, comma-separated. - `metric`: On `aggregate`, `count`, `sum.field`, `avg.field`, `min.field` or `max.field`, comma-separated. `count` when absent. - `format`: `json`, `ndjson` or `csv`. JSON carries the provenance header, and the others carry it in response headers. Without a version the API answers from the newest loaded version, and that answer changes when the publisher releases again. Put `versions//` before `rows` or `aggregate` for an answer that never changes. `/api/v1/datasets//versions` lists the loaded versions. The API allows 60 requests in 10 seconds from one address. Above that it answers 429 for 10 seconds with a `Retry-After` header, a `RateLimit-Policy` header and a JSON body that gives the limit. Every API answer carries the same `RateLimit-Policy`. A client should wait the `Retry-After` seconds, or read the files, which have no limit. OpenAPI for this dataset: https://publicdata.au/d/qld-fair-trading-licences-by-region/openapi.json ## Explore Charts and dashboards in the browser: https://publicdata.au/d/qld-fair-trading-licences-by-region/explore/. A dashboard can be shared as a link or embedded. ## Fields | field | type | publisher's header | note | |---|---|---|---| | `licence_type` | string | Row Labels | | | `brisbane` | integer | BRISBANE | | | `cairns` | integer | CAIRNS | | | `mackay` | integer | MACKAY | | | `rockhampton` | integer | ROCKHAMPTON | | | `southport` | integer | SOUTHPORT | | | `sunshine_coast` | integer | SUNSHINE COAST | | | `toowoomba` | integer | TOOWOOMBA | | | `townsville` | integer | TOWNSVILLE | | | `wide_bay` | integer | WIDE BAY | | | `other` | integer | OTHER | | | `all_regions` | integer | Grand Total | | Key: `licence_type`. ## Versions - 2026-05-07: 14 rows, 12 fields, sha256 034e8cd9701c. https://publicdata.au/d/qld-fair-trading-licences-by-region/v/2026-05-07/ Machine-readable: https://publicdata.au/d/qld-fair-trading-licences-by-region/versions.json, https://publicdata.au/d/qld-fair-trading-licences-by-region/changes.json, https://publicdata.au/d/qld-fair-trading-licences-by-region/datapackage.json, https://publicdata.au/d/qld-fair-trading-licences-by-region/schema.json, https://publicdata.au/d/qld-fair-trading-licences-by-region/history.tar.zst ## Part of Office of Fair Trading complaints, enforcement and registers, Queensland - [Consumer complaints received by the Office of Fair Trading, Queensland, latest period](https://publicdata.au/d/qld-consumer-complaints/) - [Office of Fair Trading legal and enforcement actions, Queensland, latest period](https://publicdata.au/d/qld-fair-trading-enforcement-actions/) - [Registered associations, charities and cooperatives by region, Queensland, latest count](https://publicdata.au/d/qld-registered-organisations-by-region/) ## Same subject, other publishers - [Automatic mutual recognition register, ACT](https://publicdata.au/d/act-mutual-recognition-register/) (ACT) - [Liquor licensed premises, New South Wales](https://publicdata.au/d/nsw-liquor-licence-premises/) (NSW) - [QBCC licensed builders and contractors register, Queensland](https://publicdata.au/d/qld-qbcc-licensed-contractors/) (Qld) - [Liquor and gaming licences, South Australia, September 2018](https://publicdata.au/d/sa-liquor-gaming-licences-2018/) (SA) - [Land transfer duty by postcode, Victoria, 2021-22](https://publicdata.au/d/vic-land-transfer-duty-by-postcode/) (Vic) - [Land tax by municipality, Victoria, 2024](https://publicdata.au/d/vic-land-tax-by-municipality/) (Vic) - [Unclaimed money claims processed by year, Victoria](https://publicdata.au/d/vic-unclaimed-money-claims/) (Vic) - [Vehicles registered by body type and fuel, ACT](https://publicdata.au/d/act-vehicles-registered/) (ACT) - [Taxable income, salary, rent, tax and super by postcode, Australia, 2023-24](https://publicdata.au/d/au-taxable-income-by-postcode-2023-24/) (Cth) - [Mineral production by commodity, Northern Territory, 2010-11 to 2018-19](https://publicdata.au/d/nt-mineral-production/) (NT) - [Coal exports by mine and destination country, Queensland](https://publicdata.au/d/qld-coal-exports-by-mine-and-country/) (Qld) - [Coal production by mine, Queensland](https://publicdata.au/d/qld-coal-production-by-mine/) (Qld) ## Attribution and citation Department of Justice, Queensland Government, Occupational and industry licensing statistics, Office of Fair Trading, sourced 3 October 2026, https://www.data.qld.gov.au/dataset/occupational-and-industry-licensing-statistics-office-of-fair-trading, licensed under CC BY 3.0 AU. The licence requires the publisher's attribution. We ask that you also name publicdata.au and link to the version you used. Plain text: Department of Justice, Queensland Government, Occupational and industry licensing statistics, Office of Fair Trading, sourced 3 October 2026, https://www.data.qld.gov.au/dataset/occupational-and-industry-licensing-statistics-office-of-fair-trading, licensed under CC BY 3.0 AU. Serialised and versioned by National Digital at publicdata.au, https://publicdata.au/d/qld-fair-trading-licences-by-region/v/2026-05-07/ Harvard: Department of Justice (2026) Occupational licences held by type and region, Queensland, latest count, version 2026-05-07 [data set], CC BY 3.0 AU, sourced 3 October 2026. Serialised and versioned by National Digital at publicdata.au. Available at: https://publicdata.au/d/qld-fair-trading-licences-by-region/v/2026-05-07/ Markdown: Data: [Office of Fair Trading complaints, enforcement and registers, Queensland](https://www.data.qld.gov.au/dataset/occupational-and-industry-licensing-statistics-office-of-fair-trading), Department of Justice, [CC BY 3.0 AU](https://creativecommons.org/licenses/by/3.0/au/), sourced 3 October 2026. Files: [publicdata.au](https://publicdata.au/d/qld-fair-trading-licences-by-region/v/2026-05-07/) by [National Digital](https://nationaldigital.com.au/). ## Questions ### How do I download Occupational licences held by type and region, Queensland as a CSV file? Open https://publicdata.au/d/qld-fair-trading-licences-by-region/latest/data.csv. It redirects to the newest dated version, which is https://publicdata.au/d/qld-fair-trading-licences-by-region/v/2026-05-07/data.csv today. The same path serves Excel, JSON, Parquet, SQLite, DuckDB, NDJSON, Arrow. A dated URL never changes, so use it when the file must stay the same. ### Can I open Occupational licences held by type and region, Queensland in Excel? Yes. https://publicdata.au/d/qld-fair-trading-licences-by-region/v/2026-05-07/data.xlsx is a workbook with the 14 rows on a records sheet, the field list on a second sheet and the provenance on a third. The CSV also opens in Excel. https://publicdata.au/d/qld-fair-trading-licences-by-region/v/2026-05-07/data.csv.gz is the CSV at about a tenth of the size. ### How often is Occupational licences held by type and region, Queensland updated? Justice releases it twice a year. This site checks the portal every week and adds a dated version when the file changes. ### Can I use Occupational licences held by type and region, Queensland commercially? Yes. CC BY 3.0 AU 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 Occupational licences held by type and region, Queensland? No. The publisher is Department of Justice, and its page is https://www.data.qld.gov.au/dataset/occupational-and-industry-licensing-statistics-office-of-fair-trading. This site republishes the publisher's file without changing its content. The original sits beside every version as source.csv with its SHA-256, so the two can be compared. ### What is in each row? One type of occupational or industry licence the Office of Fair Trading administers, such as real estate, motor dealer, security provider or tattoo industry, with the number of distinct licences in each office region on the count date and a Grand Total row and column. ### What does a blank cell mean? The office leaves a cell blank where a region has none of that licence type in its table. Those cells are null here. ### When is the count taken? The office counts licences on 1 April and 1 October each year. The first version here is the count as at 1 April 2026. ## 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.csv`. ## Improve this dataset This page is built from [register/qld-fair-trading-licences-by-region.yaml](https://github.com/National-Digital/publicdata.au/blob/main/register/qld-fair-trading-licences-by-region.yaml) on GitHub, and a fix to it is welcome as a pull request. https://publicdata.au/contribute/ explains how.