Skip to content
Dim Calendar public holiday data in SQL
PLpgSQL JavaScript CSS Python HTML PLSQL Shell
Branch: master
Clone or download

Latest commit

Fetching latest commit…
Cannot retrieve the latest commit at this time.

Files

Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
build
src/dimcal
.gitignore
.travis.yml
LICENSE.txt
README.md
requirements.txt

README.md

Dim Calendar Holidays.

A collection of public holiday data in SQL format, to use in a data warehouse.

Now available for PL/pgSQL and MySQL

Build Status

How to use dim_calendar

  • 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.sql if those columns are of interest
  • Apply the data.sql files for the countries you choose

European Union Countries

  • 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

More Countries

  • 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
You can’t perform that action at this time.