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.


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)
| top 10 by Date asc

MDE Example


Coming soon.

Sentinel & Azure Log Analytics Example


Coming soon.