Run a SoQL query against a Nova Scotia Open Data dataset. SoQL is SQL-like.
Key clauses (combine with &):
$select=col1,col2 — choose columns
$where=field='value' — filter rows (use single quotes for strings)
$where=field like '%val%' — partial match
$order=field DESC — sort
$limit=50 — row count (default 25, max 50000)
$offset=50 — pagination
$group=field — group by (use with aggregate functions)
$q=search term — full-text search
Aggregates: count(*), sum(col), avg(col), min(col), max(col)
Examples:
$where=year='2024'&$order=total DESC&$limit=10
$select=department,count(*)&$group=department&$order=count(*) DESC
$where=area like '%Halifax%'&$limit=5
Always call get_dataset_metadata first to find exact field names.
Connector