Solid US Federal Holidays

Integrate solid holiday data into your data models fast.

<p><br/></p>

This comprehensive, materialized dataset lists all federal holidays in the US, from their first establishment in 1870 up to the year 2200. Each holiday record begins when it was first officially recognized and follows official OPM (Office of Personnel Management) guidelines.

<p><br/></p>

The table includes the actual and observed dates, accounting for weekends when holidays are observed on adjacent weekdays, and flags each holiday based on Federal Reserve bank holiday designations.

<p><br/></p>

Delivered as a view to automatically incorporate potential future establishments of holidays without requiring changes to your queries, pipelines or analyses.

<p><br/></p>

## What's included:

**Base Table** containing the full data according to the documentation.

**Semantic View** for easy integration into your data models.

**AI Agent** to conversationally query this dataset. The agent always displays the SQL code to easily add it to your projects:

- Give me a table of holidays over the last three years?
- What are the next three holidays?
- List of upcoming holidays observed on weekdays over the next five years?

<p><br/></p>

Source:<br/>[https://www.opm.gov/policy-data-oversight/pay-leave/federal-holidays/](https://www.opm.gov/policy-data-oversight/pay-leave/federal-holidays/)<br/>[https://www.frbservices.org/about/holiday-schedules/](https://www.frbservices.org/about/holiday-schedules/)

<p><br/></p>

Note: Inauguration Day is not included because it does not apply nationwide.