truestar inc.
Summary
- PODB
- BETA
This is a dataset of Japanese calendar processed by truestar based on the “National Holidays” data released by the Cabinet Office.
Data is available from January 1, 2010 to December 31, 2024.
Update time: Around March every year
PODB_JAPAN_CALENDAR: A table with column names that are easy to handle for analysis using SQL or system integration.
E_JAPAN_CALENDAR: A view with English column names that are easy to use with BI tools such as Tableau.
J_JAPAN_CALENDAR: A view with Japanese column names that are easy to use with BI tools such as Tableau.
J_JAPAN_CALENDAR_TXTFLG: A view in which Boolean columns with Japanese column names are replaced with VARCHAR type.
This is a dataset of Japanese calendar processed by truestar based on the “National Holidays” data released by the Cabinet Office.
Update time: Around March every year
Sample Data
- PODB
- BETA
Features/Usages
In addition to date and day information, the data contains information on national holidays and substitute holidays, weekends, weekdays, GW, year-end and New Year holidays, and days before holidays.
By being pre-flagged with viewpoints that affect marketing activities for various businesses, the data is processed into a form that can be immediately used in machine learning and other data analysis using daily data.
Data Fields
- PODB
- BETA
RAW_NAME: Column names for PODB_JAPAN_CALENDAR
E_NAME: Column names for E_JAPAN_CALENDAR
J_NAME: Column names for J_JAPAN_CALENDAR
| DATE |
|
| WEEKDAY_CODE | ※Definition: Sequential numbers with Monday as 1 and Sunday as 7 |
| WEEKDAY | |
| IS_HOLIDAY | ※Reference: Cabinet Office “National Holidays” |
| HOLIDAY_NAME | ※Reference: Cabinet Office “National Holidays” |
| IS_SAT_SUN | |
| IS_SAT_SUN_HOL | ※Reference: Cabinet Office “National Holidays” |
| IS_SUN_HOL | |
| IS_SUBSTITUTE_HOL | ※Reference: Cabinet Office “National Holidays” |
| IS_DAY_BEFORE_HOL | ※Definition: Day before Sundays or holidays |
| IS_WEEKDAY_BEFORE_SAT_HOL | |
| IS_GW |
※Definition: Three or more consecutive holidays including Saturdays from late April to early May |
| IS_GW_LONG | |
| IS_YEAR_END_AND_NEW_YEAR_HOL |
※Definition: Days from December 29th to January 3 and consecutive Saturdays and Sundays |
| IS_CONSECUTIVE_DAYS_OFF |
※Definition: Saturdays, Sundays, and holidays that are also Saturdays, Sundays, and holidays on the following day |
| NUMBER_OF_CONSEC_HOL_INCL_TODAY |
※Definition: Number of consecutive Saturdays, Sundays, and holidays counted from the day |
| NUMBER_OF_CONSEC_HOL_EXCL_TODAY |
※Definition: Number of consecutive Saturdays, Sundays, and holidays counted from the next day |
| IS_WEEKDAY | ※Definition: Weekdays other than Saturdays, Sundays and holidays |
| IS_WEEKDAY_AFTER_SUN_HOL |
References
Edited by truestar based on the data of “National Holidays” provided by Cabinet Office
Update History
2022/11: Japan Calendar Ver2 released as BETA version.
2023/03/13: Latest version of Japan Calendar added to PODB schema and officially released.
2023/09: Japan Calendar and JAPAN_CALENDAR_VER2 in BETA schema to be closed.