Open Holidays data: public holidays by country, one row per holiday
A dip in orders on a Monday in May may be a public holiday, not a problem.
- Open source. OWOX Data Marts is open source: you can read the code that loads and models your data, and run it yourself.
- You own the data. Open Holidays tables load into your data warehouse, under your account. If you leave OWOX, they stay where they are.
- MCP-ready. Once the data is in, Claude or ChatGPT can work from your Data Marts through OWOX MCP.
Don't wire up Open Holidays by hand. Have your AI assistant load it into your data warehouse.
Your assistant sets up the Open Holidays connector with you and loads the tables you pick; OWOX keeps them in your data warehouse, ready to use.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /data-sources/open-holidays.md. The task: set up the Open Holidays connector in OWOX Data Marts, let me pick the tables I need, load them into my data warehouse and show me the first rows. Tag the links you give me with utm_campaign=ai-task and utm_term=data-source. Use what you know about my context and goals
Prefer to start on your own? Get started free
The Open Holidays data model
Think of the model as a calendar with one row per holiday.
- Join its date to the date column of any daily table and every day gains an answer to whether it was a holiday.
- Each row also says how far the holiday reaches: nationwide or only in some regions, for the whole day or half of it.
- The type is Public or Optional, because school holidays come from another endpoint of the API that this source does not load.
- The date is the day the holiday starts and the end date is not loaded, so the later days of a holiday are not in the table.
- Nothing in it names the country or the language, because a load covers one country in one language; keep one table per country and combine them in SQL.
Land it in your warehouse, and a Data Mart that left-joins it to your daily table gives every report the holiday flag.
Why keep the holiday calendar in your data warehouse
A holiday calendar is small, which is why it ends up pasted into a spreadsheet and forgotten. As a table in your data warehouse it joins every daily report you already have.
- Working day or day off. Join on date and a revenue or traffic table gains a holiday flag, so you can compare Mondays with Mondays instead of a holiday with a working day.
- Regional holidays stay regional. A regional or local holiday is marked as such, so a day off in one region does not pass for a national one. The table does not say which region, so keep that mapping in your own data.
- Nothing to sign in to. The source needs no key; setting it up is the country, the language and the fields you want.
- Ask about your own days. With the table behind an assistant, whether last Tuesday's dip was a holiday is answered from rows instead of from memory.
Open Holidays Endpoints
1 Open Holidays endpoints you can import. Each lands in its own table in your data warehouse.
Open Holidays Public Holidays schema
7 fieldsTime seriesSchema on GitHubopen_holidays_public_holidays
Contains public holidays data for different countries and languages
Questions this table answers
- Which holidays fall on a weekday next month?
- How many holidays of each type does the country have in the year?
- Which holidays are not nationwide, and what is their regional scope?
| Field | Type | Description |
|---|---|---|
idPK | STRING | Unique identifier for the holiday |
date | DATE | Date of the holiday |
name | STRING | Name of the holiday in the specified language |
type | STRING | Type of holiday (public, school, etc.) |
regionalScope | STRING | Regional scope of the holiday |
temporalScope | STRING | Temporal scope of the holiday |
nationwide | BOOLEAN | Whether the holiday is nationwide |
What Open Holidays data answers
What Open Holidays data answers
Across the tables
- Which days of the year are public holidays in the configured country?
- How do daily orders on public holidays compare with the days around them?
- Which holidays apply only in some regions and not nationwide?
Industry data models that use Open Holidays
Industry data models that use Open Holidays
- E-CommerceEcommerce12 data marts, 87 fields
- E-Commerce ExtendedEcommerce20 data marts, 125 fields
- E-commerce Subscription StoreEcommerce15 data marts, 189 fields
- FinanceFinance8 data marts, 66 fields
- HealthcareHealthcare8 data marts, 56 fields
- Healthcare Clinic AttributionHealthcare14 data marts, 132 fields
- Healthcare Clinic NetworkHealthcare10 data marts, 150 fields
- Retail ChainRetail10 data marts, 128 fields
- TradingFinance8 data marts, 168 fields
Where Open Holidays data goes
Data warehouses
AI assistants
Spreadsheets
Dashboards
Messages
API
The Data Partner You Can Trust
users
166K Source: Internal OWOX data as of 2026-11-15
Executives and data analysts across 20+ industries
Customers
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.