Skip to content

calendar

One row per day from 2018-01-01 to 2025-12-31, with holidays, school breaks and the ticket price that applied. One row is one day.

One row is
one day
Columns
15
Rows in Sample
2,922
Rows in Standard
2,922
Rows in Full
2,922

This table describes the company, not individual guests, so it is identical in all three sizes.

Columns

ColumnTypeWhat it holdsValues or range
datekeydateThe day.
yearintegerCalendar year.2018 to 2025
quarterinteger1 to 4.1 to 4
monthinteger1 to 12.1 to 12
month_nametextJanuary to December.April; August; December; February; January; July; June; March; May; November; October; September
day_of_weekinteger1 Monday to 7 Sunday.1 to 7
day_nametextMonday to Sunday.Friday; Monday; Saturday; Sunday; Thursday; Tuesday; Wednesday
is_weekendtrue/falseTrue on Saturday and Sunday.
holiday_nametextName of the public holiday, if any. Can be empty.Christmas Day; Easter; Independence Day; Labor Day; Martin Luther King Jr. Day; Memorial Day; New Year's Day; Presidents Day; Thanksgiving
holiday_periodtextNamed busy period around a holiday, if any. Can be empty.Easter week; July 4 week; Labor weekend; MLK weekend; Memorial weekend; Presidents weekend; Thanksgiving week; Winter holidays
school_breaktextNamed school break, if any. Can be empty.Spring break; Summer break; Thanksgiving break; Winter break
ticket_pricing_modeltextHow one-day tickets were priced that day: one flat price, or a price that depends on the date.date-based; flat
ticket_price_tiertextPrice tier for the date. Empty while pricing was flat. Can be empty.peak; regular; value
adult_one_day_pricedecimalGate price of an adult one-day ticket that day, in dollars.82 to 150
resort_closedtrue/falseTrue on days the whole resort was shut.

How it connects

First five rows

Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.

dateyearquartermonthmonth_nameday_of_weekday_nameis_weekendholiday_nameholiday_periodschool_breakticket_pricing_modelticket_price_tieradult_one_day_priceresort_closed
2018-01-01201811January1MondayfalseNew Year's DayWinter holidaysWinter breakflat92false
2018-01-02201811January2TuesdayfalseWinter holidaysWinter breakflat92false
2018-01-03201811January3WednesdayfalseWinter breakflat92false
2018-01-04201811January4Thursdayfalseflat92false
2018-01-05201811January5Fridayfalseflat92false

Download from Kaggle