Data source

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.

  1. Open source. OWOX Data Marts is open source: you can read the code that loads and models your data, and run it yourself.
  2. You own the data. Open Holidays tables load into your data warehouse, under your account. If you leave OWOX, they stay where they are.
  3. MCP-ready. Once the data is in, Claude or ChatGPT can work from your Data Marts through OWOX MCP.

Hand this to your AI

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

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

The Open Holidays data model

The Open Holidays data model

1 table7 fields0 joinsView on GitHub

Public Holidays7 fields0 relationships

Think of the model as a calendar with one row per holiday.

  1. Join its date to the date column of any daily table and every day gains an answer to whether it was a holiday.
  2. Each row also says how far the holiday reaches: nationwide or only in some regions, for the whole day or half of it.
  3. The type is Public or Optional, because school holidays come from another endpoint of the API that this source does not load.
  4. 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.
  5. 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 data warehouse, and a Data Mart that left-joins it to your daily table gives every report the holiday flag.

Explore on canvas →Import this model

Why OWOX

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 AI assistant, whether last Tuesday's dip was a holiday is answered from rows instead of from memory.

Endpoints

Open Holidays Endpoints

Documentation

1 Open Holidays endpoints you can import. Each lands in its own table in your data warehouse.

Public Holidays schema

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?
Open Holidays Public Holidays fields
FieldTypeDescription
idPKSTRINGUnique identifier for the holiday
dateDATEDate of the holiday
nameSTRINGName of the holiday in the specified language
typeSTRINGType of holiday (public, school, etc.)
regionalScopeSTRINGRegional scope of the holiday
temporalScopeSTRINGTemporal scope of the holiday
nationwideBOOLEANWhether 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

Where Open Holidays data goes

Recent updates

Other data sources

Trust

The Data Partner You Can Trust

users

166K Source: Internal OWOX data as of 2026-11-15

Executives and data analysts across 20+ industries

G2 rating

4.9★2

“A trusted data analytics partner” — verified review

npm installs

171K3

In Open Source We Trust

Customers