Sample data: public datasets to try LakehouseBox with

The public catalog commons/pubdata holds open datasets (weather, holidays, countries, places, earthquakes, exchange rates and more) as Iceberg tables anyone can read. Use it to try LakehouseBox before you load anything of your own, or to join your tables with reference data. Each dataset has a page with its columns, source, licence and refresh schedule under Public data; the machine-readable list is registry.json.

Open it

Without an account, in DuckDB 1.5.5 or newer:

INSTALL iceberg; LOAD iceberg; INSTALL httpfs; LOAD httpfs;
ATTACH 'commons/pubdata' AS pubdata (TYPE iceberg, ENDPOINT 'https://public-catalog.lakehousebox.com', AUTHORIZATION_TYPE 'none');
SELECT * FROM pubdata.reference.countries LIMIT 10;   -- 249 rows in all (DuckDB 2.0.0, 2026-10-22)

With the CLI (any account), the whole catalog read-only, attached as commons_pubdata:

lhbox duckdb --catalog commons/pubdata

From an agent with the MCP server: open_public_catalog("commons/pubdata") lists its tables, and query reads them on the server as commons_pubdata.<namespace>.<table>, for example SELECT count(*) FROM commons_pubdata.reference.countries. See MCP.

The examples below use the alias pubdata of the keyless ATTACH; with lhbox duckdb or the MCP server, write commons_pubdata instead.

Prompts to give your agent

Paste one into Claude Code, or any agent connected to LakehouseBox:

  • "Open the public catalog commons/pubdata on LakehouseBox and tell me what is in it."
  • "Using commons/pubdata, how many days did it rain in Madrid in each month of the past year, and which was the hottest day?"
  • "Join my sales table with the public holidays in commons/pubdata and tell me whether holidays change daily revenue."

Starter queries

-- countries per World Bank region and income group
SELECT wb_region, wb_income_level, count(*) AS countries
FROM pubdata.reference.countries
WHERE wb_region IS NOT NULL
GROUP BY 1, 2 ORDER BY 1, 2;
-- attach a name and a region to your country codes
SELECT s.country_code, c.name, c.wb_region, sum(s.revenue) AS revenue
FROM my.sales AS s JOIN pubdata.reference.countries AS c USING (country_code)
GROUP BY 1, 2, 3;
-- the strongest earthquake per year
SELECT year(event_time) AS year, max(magnitude) AS max_magnitude
FROM pubdata.environment.earthquakes GROUP BY 1 ORDER BY 1;
-- events within ~300 km of your sites in the last year
SELECT s.site_id, count(*) AS quakes, max(e.magnitude) AS strongest
FROM my.sites AS s JOIN pubdata.environment.earthquakes AS e
  ON abs(e.latitude - s.lat) < 2.7 AND abs(e.longitude - s.lon) < 2.7 / cos(radians(s.lat))
WHERE e.event_time >= now() - INTERVAL 1 YEAR
GROUP BY 1;
-- national holidays of Spain and the United States in 2026
SELECT country_code, date, name
FROM pubdata.calendars.public_holidays
WHERE year = 2026 AND subdivision IS NULL AND country_code IN ('ES', 'US')
ORDER BY date;
-- your daily sales with a holiday flag
SELECT s.day, s.revenue, h.name AS holiday
FROM my.sales_daily AS s
LEFT JOIN pubdata.calendars.public_holidays AS h
  ON h.date = s.day AND h.country_code = s.country_code AND h.subdivision IS NULL;

Each query's second half joins the public table with one of yours (my.sales, my.sites): put your own catalog's name there.

Every dataset, and a question it answers

dataset table refresh a question to ask
Countries & regions places.admin_areas monthly Which first-level regions of Spain are the largest? Return their names, region codes and areas.
Air quality in Europe, daily environment.air_quality_daily weekly Which ten stations had the highest average PM2.5 over the last 30 days? Return the station name, country and value.
Airports transport.airports weekly Find the large airports with scheduled service in Spain. Return their names, IATA codes and coordinates.
Countries reference.countries monthly List the countries of South America with their capital, ISO codes and World Bank income group.
Earthquakes environment.earthquakes daily List the ten strongest earthquakes of the last five years with their place, depth and time.
Foreign exchange rates reference.fx_rates daily How have the Japanese Yen (JPY), British Pound (GBP) and Swiss Franc (CHF) moved against the Euro and US Dollar over the past 12 months?
Macroeconomic & interest rates population.macro_rates weekly How have the US Federal Funds Rate, the ECB Deposit Facility Rate and the US 10-Year Treasury Yield evolved since 2020?
NYC yellow taxi trips transport.nyc_taxi_trips monthly Which pickup and drop-off zone pairs in NYC generate the most yellow taxi trips and highest average fare?
Places of interest in Europe places.places monthly Which ten cities in Portugal have the most pharmacies? Return the city and the count.
Population grid (H3) population.grid_h3 monthly Where are the most densely populated H3 cells in the world, and how many people live within 100 km of Madrid?
Power plants environment.power_plants monthly How much installed solar, wind, hydro, nuclear and gas capacity does each European country have?
Public holidays calendars.public_holidays monthly Which public holidays do Spain and Germany share next year, and which of them fall on a weekday?
Rail network of Europe transport.rail_segments monthly How many kilometres of tram, metro and light rail does the table hold in each country of the Benelux? Use the countries and regions table for the borders.
World seaports transport.seaports monthly Which large seaports in the Mediterranean have a cargo pier depth of at least 15 metres?
US company financials (SEC EDGAR) population.sec_financials weekly Which 15 US public companies reported the highest net income and R&D spending in the latest full fiscal year?
Daily weather weather.daily weekly How many days did it rain in Madrid in each month of the past year, and which was the hottest day?
Weather forecast weather.forecast daily Which European capitals expect more than 10 mm of rain or temperatures below 0 °C in the next 7 days?
Population & economy population.world_bank_indicators monthly Which ten countries grew their population fastest since 2000? Show the population then and in the latest year.

Public catalogs in general (publishing your own, limits, what anyone can see): Public catalogs.