Name: US Federal Holidays
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

US Federal Holidays

This dataset is in celebration of Juneteenth, the latest US federal holiday!

[Juneteenth National Independence Day] Commemorates the emancipation of enslaved people in the United States on the anniversary of the 1865 date when emancipation was announced in Galveston, Texas. Celebratory traditions often include readings of the Emancipation Proclamation, singing traditional songs, rodeos, street fairs, family reunions, cookouts, park parties, historical reenactments, and Miss Juneteenth contests.

Juneteenth became a federal holiday in the United States on June 17, 2021.
To commemorate this newest U.S. Federal Holiday, we're exploring the Wikipedia page about Federal holidays in the United States.

Which days of the week do federal holidays fall on this year?
What is the longest gap between holidays this year? Is it different in other years?

Data Dictionary

`federal_holidays.csv`

variable	class	description
date	character	The month and day or days when the holiday is celebrated.
date_definition	character	Whether the date is a "fixed date" or follows some other pattern.
official_name	character	The official name of the holiday.
year_established	numeric	The year in which the holiday was officially established as a federal holiday.
date_established	Date	The date on which the holiday was officially established as a federal holiday, if known.
details	character	Additional details about the holiday, from the Wikipedia article.

`proposed_federal_holidays.csv`

variable	class	description
date	character	The month and day or days when the holiday would be celebrated.
date_definition	character	Whether the date is a "fixed date" or follows some other pattern.
official_name	character	The proposed official name of the holiday.
details	character	Additional details about the holiday, from the Wikipedia article.

Tables

Federal Holidays

@kaggle.joebeachcapital_us_federal_holidays.federal_holidays

9.93 KB
11 rows
6 columns


CREATE TABLE federal_holidays (
  "date" VARCHAR,
  "date_definition" VARCHAR,
  "official_name" VARCHAR,
  "year_established" BIGINT,
  "date_established" TIMESTAMP,
  "details" VARCHAR
);

Proposed Federal Holidays

@kaggle.joebeachcapital_us_federal_holidays.proposed_federal_holidays

5.22 KB
9 rows
4 columns


CREATE TABLE proposed_federal_holidays (
  "date" VARCHAR,
  "date_definition" VARCHAR,
  "official_name" VARCHAR,
  "details" VARCHAR
);