Description
Date dimension table
Columns
| Column Name | Description |
|---|---|
date_key |
Surrogate key integer in the form YYYYMMDD. The value -1 indicates a NULL date |
date |
Date in the form of YYYY-MM-DD |
day_of_week |
Name of the day of the week in the form of Monday, Tuesday, etc. |
day_of_week_short |
Short, 3 letter, name of the day of the week in the form of Mon, Tue, etc. |
day_of_week_number |
Day of the week in integer format, where 1 is the first day of the week (Sunday) and ends on 7 (Saturday) |
day_of_week_number_iso |
Day of the week in integer format, where 1 is the first day of the week (Monday) and ends on 7 (Sunday) |
calendar_week_year |
Calendar week in the form of 'Mar 18 - Mar 24, 2018'; sorted by calendar_year_week_number |
calendar_year_week_number |
Sequential week number across years with week starting on Sunday (integer format); A week always counts 7 days and when a week crosses over from December into January, for example, the same week number is used on both sides [useful for sorting calendar_week_year] |
calendar_month_year |
Month and year as a string in the form of Mar 2018; sorted by calendar_year_month_number |
calendar_year_month_number |
Sequential integer month number across years (computed as [calendar_year] * 12 + [calendar_month_number] – 1) [useful for sorting calendar_month_year] |
calendar_month_year_order |
Ordered months across years (Aug 2025 becomes 202508) |
calendar_start_of_month |
First date of the month in the form of YYYY-MM-DD |
calendar_end_of_month |
Last date of the month in the form of YYYY-MM-DD |
calendar_date_previous_year |
The same relative day in previous year |
business_id |
Unique identifier for the business |
calendar_day_of_month_number |
Sequential number of the day within the month |
calendar_month_number |
Calendar month number, where 1 is January |
calendar_month |
Calendar month full name name, sorted by calendar_month_number |
calendar_month_short |
Calendar month name, three letters, sorted by calendar_month_number |
calendar_year |
Calendar year number |
calendar_day_of_year_number |
Sequential number of the day within the year |
date_short |
Short date and name of the day of the week |