I'm putting outthere a
collection of public holiday data in SQL format,
to use in a data warehouse.
Data has mostly come from wikipedia, I've completed a small number of countries and the mistakes are all mine.
It covers a handful of countries, and foucses dates Jan 1970 - Jan 2038.
I'll keep expanding the list of countries and I'm hoping for some help from the internet to get it more complete.
The main output of this project is the SQL to update a dim_calendar table, which is why I've broken it down into those columns.
I've also knocked up a little django generated website to view the results.
It ain't pretty but ...