PrepperPrepper Open Data Bank

JAPAN_CALENDAR

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

https://www8.cao.go.jp/chosei/shukujitsu/gaiyou.html

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.

2024/3: Relased data up to 2025.