Open data: festival and vrat dates
Every festival of 2026–2027, and every Ekadashi, Purnima and Amavasya, with its timings and the rule that fixed it, in two small CSV files computed by our own engine for New Delhi. Use them for anything; just credit the source with a link.
Files
Hindu festivals, jayantis and vrats 2026–2027
hindu-festivals-2026-2027-new-delhi.csv
164 rows · 18 columns · CSV
DownloadEkadashi, Purnima and Amavasya 2026–2027
ekadashi-purnima-amavasya-2026-2027-new-delhi.csv
99 rows · 17 columns · CSV
Download
Licence: CC BY 4.0
You may copy, adapt and publish these files, commercially too, provided you credit the source with a link to this page. For example: creativecommons.org/licenses/by/4.0
Source: Satmarg Astro (https://satmargastro.com/data), CC BY 4.0
How the dates are computed
- Each date is its classical rule applied by our engine: the amanta lunar month, the tithi, and the part of the day the tithi must touch (sunrise, madhyahna, pradosh, nishita); sankranti festivals follow the Sun's sidereal ingress (Lahiri). Each festival page states its rule.
- Place: New Delhi (28.6356° N, 77.2244° E, Asia/Kolkata). Sunrise and sunset by the upper limb with 34′ refraction. In another city a festival or vrat can fall a day apart; city timings are on our festival pages.
- Ekadashi follows the Smarta rule (the date column); the Vaishnava day has its own column where it differs (10 of 49 in 2025–2026).
- Checked: for 2025 and 2026, 441 of the 441 dates Drik Panchang published match ours. 2027 uses the same rules but has not yet been compared with a published list.
- The files are rebuilt from the engine every day; an engine change can move a date, so cite the date you downloaded them.
Last verified: · 441 of 441 published Drik Panchang dates for 2025–2026 match · How accurate we are
Format
UTF-8, comma-separated, a header row of column names (RFC 4180). Times are ISO 8601 with the Indian offset (+05:30). Hindi names are in Devanagari; in Excel use “Data → From Text/CSV” and choose UTF-8.
Columns: Hindu festivals, jayantis and vrats 2026–2027
| Column | Meaning |
|---|---|
| date | The day (YYYY-MM-DD, New Delhi) |
| weekday | Weekday of that date |
| key | Stable engine key (e.g. diwali, devutthana) |
| name_en | Name in English |
| name_hi | Name in Hindi (Devanagari) |
| end_date | Last day, for festivals that span days (Navratri, Pitru Paksha) |
| tithi | The tithi that fixes the day (blank for solar festivals) |
| tithi_start | When that tithi begins (ISO 8601, IST) |
| tithi_end | When it ends |
| month_amanta | Lunar month, amanta (new-moon) reckoning |
| month_purnimanta | Lunar month, purnimanta (full-moon) reckoning, used in North India |
| adhik | true if the month is adhik (extra) |
| muhurat | The festival's main window, by name (e.g. Lakshmi Puja muhurat) |
| muhurat_start | Its start (ISO 8601, IST) |
| muhurat_end | Its end |
| fallback | true when the tithi touched the required part of the day on neither day and the fallback rule chose it |
| rule | The rule that fixed the date, in words |
| url | The page on satmargastro.com with this festival's timings |
First rows
date,weekday,key,name_en,name_hi,end_date,tithi,tithi_start,tithi_end,month_amanta,month_purnimanta,adhik,muhurat,muhurat_start,muhurat_end,fallback,rule,url 2026-01-13,Tuesday,lohri,Lohri,लोहड़ी,,,,,,,,,,,false,The evening before Makar Sankranti: the day before the Sun’s entry into sidereal Capricorn as our calendar fixes it. The bonfire is lit after sunset.,https://satmargastro.com/festivals/lohri 2026-01-14,Wednesday,makar_sankranti,Makar Sankranti,मकर संक्रांति,,,,,,,,Punya kaal,2026-01-14T15:07:20+05:30,2026-01-14T17:45:17+05:30,false,"The day the Sun enters sidereal Capricorn (Makara). If the ingress is after sunset, the festival and its punya kaal move to the next day.",https://satmargastro.com/festivals/makar-sankranti 2026-01-14,Wednesday,pongal,Pongal,पोंगल,2026-01-16,,,,,,,,,,false,"The first day of the Tamil solar month Thai: the day the Sun enters sidereal Capricorn if the entry is before sunset, else the next day. Bhogi is the day before; Mattu and Kaanum Pongal follow.",https://satmargastro.com/festivals/pongal
Columns: Ekadashi, Purnima and Amavasya 2026–2027
| Column | Meaning |
|---|---|
| date | The day (YYYY-MM-DD, New Delhi) |
| weekday | Weekday of that date |
| key | Stable engine key (e.g. diwali, devutthana) |
| name_en | Name in English |
| name_hi | Name in Hindi (Devanagari) |
| type | ekadashi | purnima | amavasya |
| tithi | The tithi that fixes the day (blank for solar festivals) |
| tithi_start | When that tithi begins (ISO 8601, IST) |
| tithi_end | When it ends |
| month_amanta | Lunar month, amanta (new-moon) reckoning |
| month_purnimanta | Lunar month, purnimanta (full-moon) reckoning, used in North India |
| adhik | true if the month is adhik (extra) |
| alt_date | Ekadashi: the gauna (second) day; Purnima: the vrat (fast) day; Amavasya: the darsha day — when different from date |
| vaishnava_date | Ekadashi only: the Vaishnava day when Dashami touches arunodaya |
| parana_start | Ekadashi only: when the fast may be broken (ISO 8601, IST) |
| parana_end | Ekadashi only: end of the parana window |
| url | The page on satmargastro.com for this day |
First rows
date,weekday,key,name_en,name_hi,type,tithi,tithi_start,tithi_end,month_amanta,month_purnimanta,adhik,alt_date,vaishnava_date,parana_start,parana_end,url 2026-01-03,Saturday,purnima,Pausha Purnima,पौष पूर्णिमा,purnima,Purnima,2026-01-02T18:53:59+05:30,2026-01-03T15:32:54+05:30,Pausha,Pausha,false,,,,,https://satmargastro.com/vrat/purnima/pausha-purnima-2026 2026-01-14,Wednesday,shattila,Shattila Ekadashi,षटतिला एकादशी,ekadashi,Krishna Ekadashi,2026-01-13T15:18:25+05:30,2026-01-14T17:53:15+05:30,Pausha,Magha,false,,,2026-01-15T07:14:56+05:30,2026-01-15T09:21:10+05:30,https://satmargastro.com/vrat/ekadashi/shattila-ekadashi-2026 2026-01-18,Sunday,amavasya,Magha Amavasya,माघ अमावस्या,amavasya,Amavasya,2026-01-18T00:04:26+05:30,2026-01-19T01:21:57+05:30,Pausha,Magha,false,,,,,https://satmargastro.com/vrat/amavasya/magha-amavasya-2026
For another city or year (1900–2100) see the same figures on our festival calendar pages, or write to us.