A collection of public holiday data in SQL format, to use in a data warehouse.
Now available for PL/pgSQL and MySQL
- Wait for release v1.0.0. Pre-releases are working but not yet extensively tested.
- Download and extract the release tarball dim_calendar.tar.gz
- Create the dim_calendar table with
table.sql. You can add and remove any columns except for calendar_date - Populate dim_calendar primary keys with
common.sql - Optionally, apply
calculations.sqlif those columns are of interest - Apply the
data.sqlfiles for the countries you choose
- Austria
- Belgium
- Bulgaria
- Croatia
- Cyprus
- Czech Republic
- Denmark
- Estonia
- Finland
- France
- Germany - BW
- Germany - BY
- Germany - BE
- Germany - BB
- Germany - GDR
- Germany - HB
- Germany - HH
- Germany - HE
- Germany - MV
- Germany - NI
- Germany - NW
- Germany - RP
- Germany - SL
- Germany - SN
- Germany - ST
- Germany - SH
- Germany - TH
- Greece
- Hungary
- Ireland
- Italy
- Latvia
- Lithuania
- Luxembourg
- Malta
- Netherlands
- Poland
- Portugal
- Romania
- Slovenia
- Slovakia
- Spain - National
- Sweden
- United Kingdom - England & Wales
- United Kingdom - Northern Ireland
- United Kingdom - Scotland
- Canada - AB
- Canada - BC
- Canada - FED
- Canada - MB
- Canada - NAT
- Canada - NB
- Canada - NL
- Canada - NS
- Canada - NT
- Canada - NU
- Canada - ON
- Canada - PE
- Canada - QC
- Canada - SK
- Canada - YT
- Madagascar
- Panama
- South Africa
- Uruguay
- United States of America - Federal