UK Government Open Data
Search and query 55,000+ UK government datasets directly in your browser.
Type at least 2 characters to search data.gov.uk.
Results open in the SQL editor — queries run entirely in your browser, no uploads.
About data.gov.uk
data.gov.uk is the United Kingdom's national open data portal, publishing datasets from every central government department, devolved administration, and public body. SmartQueryTools lets you search the catalogue and run SQL queries against any compatible CSV, JSON, or Parquet file without downloading anything.
Popular topics
Health
Search data.gov.uk for health datasets
Transport
Search data.gov.uk for transport datasets
Crime
Search data.gov.uk for crime datasets
Education
Search data.gov.uk for education datasets
Environment
Search data.gov.uk for environment datasets
Housing
Search data.gov.uk for housing datasets
Economy
Search data.gov.uk for economy datasets
Population
Search data.gov.uk for population datasets
Frequently Asked Questions
How do I search data.gov.uk datasets?▼
Type at least two characters into the search box above. Results are pulled live from the UK Government 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.gov.uk 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.gov.uk 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.gov.uk datasets are published under the Open Government Licence v3.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.gov.uk 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
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.
New Zealand Open Data
Search 9,000+ New Zealand government datasets and query them in-browser with SQL.
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.gov.uk 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.