Open Data Catalog
Search across 100,000+ government datasets from seven open data portals, plus a curated set of global datasets. Click any result to query it directly with SQL — entirely in your browser.
Search every source at once
One query, seven open data portals — results stream in live from each source.
Browse by source
UK Government Open Data
Search and query 55,000+ UK government datasets directly in your browser.
Source: data.gov.uk
Canada Open Government Data
Search 30,000+ Canadian federal government datasets and query them with SQL — no downloads.
Source: open.canada.ca
Ireland Open Data
Search Irish government open data and run SQL on it instantly — no sign-up, no downloads.
Source: data.gov.ie
New Zealand Open Data
Search 9,000+ New Zealand government datasets and query them in-browser with SQL.
Source: data.govt.nz
NSW Government Open Data
Search 6,000+ NSW government datasets — transport, planning, health, environment — query them in your browser.
Source: data.nsw.gov.au
Queensland Government Open Data
Search Queensland Government open data — health, transport, environment, schools — and query it instantly with SQL.
Source: data.qld.gov.au
NYC Open Data
Search 2,500+ NYC Open Data datasets — taxi trips, 311 calls, restaurants, real estate — and query them with SQL.
Source: data.cityofnewyork.us
Curated featured datasets
Hand-picked datasets that load reliably in the browser — every URL is CORS-verified and ready to query immediately.
Transport
World Airport Codes
CSVEvery airport, heliport, seaplane base, and airstrip in the world with IATA/ICAO codes, type, elevation, country, region, municipality, and GPS coordinates. Sourced from OurAirports.
World Cities
CSVOver 47,000 cities worldwide with country, subcountry (state/province), and GeoNames ID. Useful for geocoding, enriching datasets with location data, and geographic analysis.
Economics
GDP per Capita (1820–present)
CSVGDP per capita in international dollars, adjusted for inflation and purchasing power parity, for all countries from 1820 to the present.
Global Trade Openness
CSVExports and imports as a share of GDP for all countries — a measure of how integrated each economy is with global trade.
Environment
CO₂ & Greenhouse Gas Emissions
CSVCountry-level CO₂ emissions, energy consumption, and other climate indicators from 1750 to the present. Updated annually by Our World in Data.
Global Energy Consumption
CSVPrimary energy consumption by source and country — coal, oil, gas, nuclear, renewables — from 1965 to present.
Health
COVID-19 Global Data
CSVDaily COVID-19 cases, deaths, vaccinations, hospitalizations, and testing data for every country from January 2020 onwards. Maintained by Our World in Data.
Global Life Expectancy
CSVLife expectancy at birth by country and year, from 1543 to the present. One of the longest-running demographic time series available.
Demographics
World Population (10,000 BCE–2100)
CSVHistorical and projected world population by country, from 10,000 BCE to 2100. Combines historical estimates with UN future projections.
Global Urbanisation
CSVShare of population living in urban areas by country from 1500 to 2050. Tracks one of the defining shifts in human settlement patterns.
Government
Democracy & Political Regimes
CSVClassifies every country by regime type — liberal democracy, electoral democracy, electoral autocracy, or closed autocracy — from 1789 to 2022.
Military Expenditure
CSVMilitary spending as a share of GDP and in absolute terms for all countries from 1960 to the present. Source: SIPRI Military Expenditure Database.
About the SmartQueryTools Open Data Catalog
The SmartQueryTools Open Data Catalog is a unified search interface for the world's major government open data portals. Each search runs against the live API of every source — data.gov.uk, open.canada.ca, data.gov.ie, data.govt.nz, data.nsw.gov.au, data.qld.gov.au, and NYC Open Data — and surfaces only datasets with queryable file formats (CSV, JSON, Parquet, NDJSON, GeoJSON, TSV).
Clicking any result opens the SmartQueryTools SQL editor with a pre-populated query that reads the dataset directly from its original host using HTTP range requests. The data never travels through our servers — it goes from the source straight to your browser, where a full analytical SQL engine compiled to WebAssembly runs the query locally.
For datasets you query repeatedly or want to share, the curated featured collection below lists 13 hand-picked datasets with CORS-verified URLs that load reliably in-browser — covering global CO₂ emissions, COVID-19, GDP, world population, life expectancy, and more.
Frequently Asked Questions
How does the cross-source search work?▼
When you type a query, the search box dispatches a parallel request to every source API and merges the results as they arrive. Each section shows the top three matches for that source plus a link to the full source page where you can browse all results for the query.
Why do some "Load in Editor" buttons say "Try in Editor" instead?▼
Some government data hosts do not send CORS headers, which prevents your browser from fetching the file directly. The "Try" label is a warning that direct loading might fail. If it does, click the source link, download the file, and upload it via the "My Files" tab in the SQL editor.
Do I need an account or API key?▼
No. SmartQueryTools is free to use, and none of the seven government portals indexed here require an API key for public data. The optional $9/month subscription removes daily query limits and unlocks larger result exports.
Can I join datasets from different sources in one query?▼
Yes. The SQL editor supports queries that read from multiple URLs at once using read_csv_auto() or read_parquet(). Join a UK Government dataset against an NYC Open Data dataset against a Canadian dataset all in the same SELECT.
How fresh is the data?▼
The catalog itself is fetched live from each source on every search (with a one-hour edge cache). Individual datasets are fetched on demand from the original source when you run a query, so you always get the current version published by the government agency.
More Power Tools
SQL Query Tool
Write SQL queries against any loaded file. Join, aggregate, filter across multiple files.
Data Profiler
Profile any file — row counts, column types, null rates, and statistics.
Join Files
Join two files with INNER, LEFT, RIGHT, or FULL OUTER joins on any key column.
Find Duplicates
Find duplicate rows across any column combination and export the results.
Pivot Table
Build pivot tables from any data file — rows, columns, values, and aggregation.
Chart Builder
Visualize any data file as a bar chart, line chart, scatter plot, or histogram.