About this Dataset

Global Public Holidays And Calendar Events

The calendar dataset provides a unified structure for global time-based data that affects public life and operational planning.
It is designed to serve as a foundation for systems and analyses that depend on national calendars, societal rhythms, and temporal structures.
Starting with public holidays, the dataset is architected to grow over time to include related themes such as school breaks, daylight saving transitions, market closures, and religious observances.
This dataset is especially useful for organizations that operate across borders and time zones—helping them align their operations with the temporal nuances of each region.

Tables

Public Holidays By Country And Subdivision

@blt.calendar.public_holidays

5.56 MB
1,497,859 rows
7 columns

CREATE TABLE public_holidays (
  "date" TIMESTAMP,
  "name" VARCHAR,
  "country_code" VARCHAR,
  "country_name" VARCHAR,
  "subdivision_code" VARCHAR,
  "weekday" VARCHAR,
  "subdivision_name" VARCHAR
);