SunshineListOntario

Data & API

All data comes from the Government of Ontario's public Public Sector Salary Disclosure and is free to reuse. The same filters power the site search, a CSV export, and a public JSON API.

CSV export

Add an "Export CSV" on any people search, or call /api/export with the filters below (up to 10,000 rows). Example:

/api/export?q=nurse&year_min=2024&year_max=2024&sort=salary_desc

JSON API

GET /api/search returns { rows, total, page, perPage }. Example:

/api/search?q=smith&year_min=2024&sort=salary_desc&per_page=50

Autocomplete endpoints: /api/employers?q=… and /api/positions?q=… (return { results: [{ id, name, slug, count }] }).

Parameters

ParameterMeaning
qFull-text search across name, employer and position
year_min, year_maxRestrict to a year range (e.g. 2024)
sectorsComma-separated sector IDs
employer_idRestrict to one employer (numeric ID)
salary_min, salary_maxSalary range in dollars
sortsalary_desc (default), salary_asc, year_desc, year_asc, name
page, per_pagePagination for the JSON API (per_page ≤ 100)

Please attribute "SunshineList Ontario" and the Government of Ontario as the data source. Figures are informational — verify against the official source before relying on them.