Holidays

Hypothesis

Add US holidays to your date table with one join. Every holiday and observance from 1900 to 2099 is in a single table.

About this dataset

The table has one row for each US holiday from 1900 to 2099. Each row has the holiday’s date, name, type and start and end times, plus the rule that sets the date. Join it to your date table to mark every holiday.

Analysts marking holidays in a date dimension
Forecasting teams who use holidays as a model input
Data teams who don’t want to maintain their own holiday list

Table

One table, holidays, with one row per holiday.

Column	What it holds
country_code	Country, as an ISO 3166 code (US)
date	Date of the holiday
started_at, ended_at	Start and end, as timestamps
holiday_name	Name, such as Independence Day
holiday_type	Type, such as public, optional or observance
rule_text	Rule that sets the date

Sample queries

Join on the date, keep the types you need and allow for days with more than one holiday.

Join it to your dates
Left join it to your date table on date. Days without a holiday stay in the result.
Pick the types you need
Filter holiday_type to public for the days most offices close, or keep observances too.
Allow for shared dates
Some dates have more than one holiday. Group by date when you need one row per day.

SQL

-- Every day, with its public holidays (Snowflake)
select d.date, listagg(h.holiday_name, ', ') as holidays
from dim_dates d
left join holidays h
    on h.date = d.date and h.holiday_type = 'public'
group by d.date
order by d.date;

Pricing

One monthly plan covers the whole table. It’s billed through Snowflake Marketplace or AWS Data Exchange, on your existing Snowflake or AWS bill.

Changelog

[DATE] · First release: US holidays from 1900 to 2099.

More from Zym Labs Data

Holidays | Zym Labs