Kusto Public Holidays CSV

Description

---

This is output from the Python Holidays module and made available here in CSV format.

Source

---

The superb https://pypi.org/project/holidays/.

Why should I use this data?

---

This dataset shows all the supported countries and their public holidays available from the Python package. It contains the previous year’s holidays as well as this year and the next four years. ie if downloaded in 2024 you will have data from 2023, 2024, 2025, 2026, 2027 and 2028.

Updates

---

Daily at around 0300UTC. The source data may or may not be updated as regularly. Although this dataset is generated daily it is expected that it will not have very many changes.

Perma Link

---

https://firewalliplists.gypthecat.com/lists/kusto/kusto-publicholidays.csv.zip

Schema

Column Name	Data Type	Notes
Country	string	Long hand country name, eg ‘France’
CountryCode	string	Short country code, eg ‘FR’
Date	datetime	yyyy-MM-dd
Occasion	string	eg ‘New Years Day’

Base Kusto Table

---

externaldata (Country:string, CountryCode:string, Date:datetime, Occasion:string) ['https://firewalliplists.gypthecat.com/lists/kusto/kusto-publicholidays.csv.zip'] with (ignoreFirstRecord=false)

Base Kusto Function

---

let PublicHolidays = (externaldata (Country:string, CountryCode:string, Date:datetime, Occasion:string) ['https://firewalliplists.gypthecat.com/lists/kusto/kusto-publicholidays.csv.zip'] with (ignoreFirstRecord=false));

Self Contained Kusto

---

// When are the next times I can celebrate a public holiday and where?
let PublicHolidays = (externaldata (Country:string, CountryCode:string, Date:datetime, Occasion:string) ['https://firewalliplists.gypthecat.com/lists/kusto/kusto-publicholidays.csv.zip'] with (ignoreFirstRecord=false));
PublicHolidays
| where Date >= floor(now(), 1d)
| summarize NextDay = min(Date)
| join (PublicHolidays) on $left.NextDay == $right.Date
| project-away NextDay

// What dates are holidays for the next 12 months in Thailand?
let PublicHolidays = (externaldata (Country:string, CountryCode:string, Date:datetime, Occasion:string) ['https://firewalliplists.gypthecat.com/lists/kusto/kusto-publicholidays.csv.zip'] with (ignoreFirstRecord=false));
PublicHolidays
| where Date between (floor(now(), 1d) .. floor(now(+365d), 1d))
| where Country == 'Thailand'
| order by Date asc

MDE Example

---

Coming soon.

Sentinel & Azure Log Analytics Example

---

Coming soon.