Public Data Catalog
Query real-world datasets directly in your browser — no download, no sign-up. Click any dataset to open it in the SQL editor and start exploring immediately.
All queries run locally in your browser. Data is fetched directly from the original source using HTTP range requests — only the rows you query are transferred.
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 Data Catalog
The SmartQueryTools Data Catalog is a curated collection of free, publicly available datasets you can query directly in your browser using SQL — no account, no download, no server. Each dataset is fetched on demand from its original source using HTTP range requests, so only the data your query needs is transferred.
All processing happens inside your browser using a full analytical SQL engine compiled to WebAssembly. You can join catalog datasets against your own uploaded files, aggregate millions of rows in seconds, and export the results in any format.
Frequently Asked Questions
Do I need to download the datasets before querying them?
No. The SQL engine can read remote Parquet and CSV files directly over HTTPS using HTTP range requests. Only the row groups your query touches are fetched — you never download the full file unless your query requires a full scan.
Can I join a catalog dataset with my own uploaded file?
Yes. Open the SQL editor, load your own file using the "My Files" tab, then reference the catalog dataset via read_parquet() or read_csv_auto() in the same query. The engine handles both sources natively.
Are these datasets free to use?
All datasets in the catalog are published under open licences (Creative Commons, public domain, or open government licences). Always check the original source for the specific licence terms before using data commercially.
How fresh is the data?
Each dataset is fetched live from its original source, so you always get the current version. Update frequency varies — NYC taxi data is published monthly, Our World in Data datasets are updated annually or more frequently.
Can I download the query results?
Yes. After running a query in the SQL editor, export the results as CSV or JSON using the download buttons below the results table.
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.
Mock Data Generator
Generate realistic sample data — names, emails, dates, numbers, and more.
Chart Builder
Visualize any data file as a bar chart, line chart, scatter plot, or histogram.
Lookup Tool
Add a column by looking up values from a reference table — like Excel VLOOKUP.
XML to CSV
Convert XML files to CSV, JSON, Parquet, and more — no upload required.
SQL Importer
Import a SQL dump and export the data as CSV, Parquet, or JSON.
Excel Sheet Extractor
Extract any sheet from a multi-sheet Excel workbook and convert to CSV or Parquet.