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.