New Zealand Open Data
Search 9,000+ New Zealand government datasets and query them in-browser with SQL.
Type at least 2 characters to search data.govt.nz.
Results open in the SQL editor — queries run entirely in your browser, no uploads.
About data.govt.nz
data.govt.nz is New Zealand's open data portal, indexing datasets from Stats NZ, ministries, local councils, and Crown agencies. SmartQueryTools lets you query CSV, JSON, and Parquet files directly without downloading them.
Popular topics
Census
Search data.govt.nz for census datasets
Environment
Search data.govt.nz for environment datasets
Transport
Search data.govt.nz for transport datasets
Health
Search data.govt.nz for health datasets
Māori
Search data.govt.nz for māori datasets
Education
Search data.govt.nz for education datasets
Economy
Search data.govt.nz for economy datasets
Climate
Search data.govt.nz for climate datasets
Frequently Asked Questions
How do I search data.govt.nz datasets?▼
Type at least two characters into the search box above. Results are pulled live from the New Zealand Open Data API and filtered to datasets with queryable file formats (CSV, JSON, Parquet, and similar). Each result shows the title, organisation, last-modified date, and available files.
Can I query data.govt.nz datasets without downloading them?▼
Yes — when you click "Load in Editor", the dataset URL is passed to SmartQueryTools' in-browser SQL engine, which fetches the file directly using HTTP range requests. The data never travels through our servers. Some data.govt.nz hosts don't expose CORS headers; in that case you can download the file from the source page and upload it via the "My Files" tab in the SQL editor.
What file formats can I query?▼
SmartQueryTools supports CSV, TSV, JSON, NDJSON (JSON Lines), Parquet, GeoJSON, and Excel. Search results are pre-filtered to datasets that include at least one of these formats — datasets that only ship PDF or ZIP files are hidden.
What licence is the data under?▼
Most data.govt.nz datasets are published under the Creative Commons BY 4.0, which permits commercial reuse with attribution. Always check the individual dataset page for any dataset-specific licence terms before using the data commercially.
Do I need an account or API key?▼
No. SmartQueryTools is free to use without an account, and data.govt.nz itself doesn't require an API key for public datasets. The optional $9/month subscription removes daily query limits and unlocks larger result exports.
Other open data sources
UK Government Open Data
Search and query 55,000+ UK government datasets directly in your browser.
Canada Open Government Data
Search 30,000+ Canadian federal government datasets and query them with SQL — no downloads.
Ireland Open Data
Search Irish government open data and run SQL on it instantly — no sign-up, no downloads.
NSW Government Open Data
Search 6,000+ NSW government datasets — transport, planning, health, environment — query them in your browser.
Queensland Government Open Data
Search Queensland Government open data — health, transport, environment, schools — and query it instantly with SQL.
NYC Open Data
Search 2,500+ NYC Open Data datasets — taxi trips, 311 calls, restaurants, real estate — and query them with SQL.
How it works: SmartQueryTools searches the live data.govt.nz catalogue and filters results to datasets with queryable file formats. Clicking Load in Editor opens the SQL editor with a pre-populated query that reads the dataset directly via HTTP range requests — only the rows your query touches are downloaded. All processing happens inside your browser using a full analytical SQL engine compiled to WebAssembly.