Solid Global Holidays

The fast and easy way to add holiday data to your data models.

<p><br/></p>

This dataset provides a comprehensive, materialized calendar of holidays worldwide, covering 200 years from 1900 through 2100. It includes 247 country codes along with their respective subdivisions, such as U.S. states, Finnish regions, or Argentinian provinces.

<p><br/></p>

It includes public and government holidays, as well as cultural and unofficial observances like Groundhog Day and Valentine’s Day, in addition to religious holidays.

<p><br/></p>

The data is delivered as a flat table, accessible by country and subdivision, to be immediately ready for use in your projects, without the need for external applications, complex dimensional models, or additional processing layers.

<p><br/></p>

Views:<br/>PUBLIC_HOLIDAYS - default view for the latest data on public holidays.<br/>HOLIDAYS - latest data with all categories.<br/>

Tables:<br/>HOLIDAYS_ARCHIVE - Complete record of all releases of the dataset. This table preserves the full evolution of the dataset over time, storing every holiday record as it appeared in each release.

<p><br/></p>

## What's included:

**Tables and Views** containing the full data according to the documentation.

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

**AI Agent** to conversationally query this dataset:

- Give me a list of days off in California this year?
- What are the next three holidays in Germany?
- Which Indian state has the most public holidays per year?

<p><br/></p>

<p><br/></p>

The dataset is continuously maintained, with regular updates adding new regions and confirming previously estimated dates. In line with Solid Data principles, all data is immutable: updates are released as new versions in the _archive table and never overwrite existing records.

<p><br/></p>

You keep full control over your development, testing, and production timelines without unexpected and intransparent data changes. For production use, we recommend pinning a specific release_date, while the main view always reflects the most recent release.

原始信息汇总

数据集概述：Solid Global Holidays

提供方： Solid Data LLC

简介： 一个全面、物化的全球节假日日历数据集，覆盖1900年至2100年的200年数据，包含247个国家代码及其各自的行政区划（如美国州、芬兰地区、阿根廷省份）。数据包含公共假日、政府假日、文化及非官方节日（如土拨鼠日、情人节）以及宗教节日。

核心特性：

• 数据格式： 扁平表格，可直接按国家和行政区划使用，无需外部应用或复杂处理。
• 数据对象：
  • 视图：
    • PUBLIC_HOLIDAYS: 公共假日最新数据默认视图。
    • HOLIDAYS: 包含所有类别的最新数据。
  • 表：
    • HOLIDAYS_ARCHIVE: 所有版本发布的完整记录，保留每次发布时的数据快照，支持数据不可变。
• 智能功能： 提供语义视图便于集成，以及AI Agent用于对话式查询（例如：“列出今年加利福尼亚的休息日”）。

数据维护与更新：

• 持续维护，定期更新，添加新区域并确认预计日期。
• 数据不可变：更新以新版本发布在归档表中，不会覆盖已有记录。建议生产使用固定特定发布日期，主视图则始终反映最新版本。

业务价值：

• 适用于全球业务中的薪资处理、供应链调度、面向客户的应用程序及财务系统。
• 无需合同或审批流程，立即可用于临时分析、时间序列工作、排程、财务报告或运营规划。

使用示例：

• 查询特定国家、州、类别和年份的节假日。
• 查询全国范围的公共假日。
• 列出数据中可用的国家和行政区划。

试用与交付：

• 试用： 30天无限试用。
• 刷新： 每月。
• 时间覆盖： 按天。
• 法律条款： 标准。
• 交付方式： 安全共享。

分类标签： Cortex AI Ready、查找表、真实世界数据（RWD）。