chinese-calendar-database

All Chinese Calendar Days In One SQLite Database ( 1901 ~ 2100 )

All data from HongKong Observatory, this repository is just collect and convert to SQLite database.

How to use

You can import the database file chinese-calendar.db to your project and do whatever you want.

The database table name is days, all Chinese text in database is Traditional Chinese,the table structure is below:

Field	Type	Description
id	INTEGER	Primary Key
year	INTEGER	Year in Gregorian calendar
month	INTEGER	Month in Gregorian calendar, starts from 1
day	INTEGER	Day in Gregorian calendar
weekday	INTEGER	Weekday, 1 means Sunday, 2 means Monday
lunar_year	INTEGER	Lunar Year
lunar_month	INTEGER	Lunar Month, starts from 1
lunar_day	INTEGER	Lunar Day
is_leap_month	INTEGER	Is Lunar Leap Month
lunar_year_name	TEXT	Lunar year name in Traditional Chinese
lunar_month_name	TEXT	Lunar month name in Traditional Chinese
lunar_day_name	TEXT	Lunar day name in Traditional Chinese
solar_term	INTEGER	Solar Term
solar_term_name	TEXT	Solar Term name in Traditional Chinese
zodiac	INTEGER	Zodiac
zodiac_name	TEXT	Zodiac name in Traditional Chinese
raw	TEXT	Original content in text file

If you want to generate the database file by yourself, you can follow the steps below.

Clone this repository
Run pip install -r requirements.txt in command line
Execute src/01_download_chinese_calendar_text.py to download the data from HongKong Observatory
You will find some text files in data/txt folder
Execute src/02_generate_database_from_chinese_calendar_text.py to convert the text file to SQLite database
You will find the database file chinese_calendar.db in data/db folder, enjoy it!