service_id,date,holiday_name,exception_type
BOP00_MTWThFS_20200324_20200513,20210405,Easter Monday,2
BOP00_MTWThFS_20200324_20200513,20210402,Good Friday,2
BOP00_MTWThFS_20200324_20200513,20210201,Auckland Anniversary Day,2
BOP00_MTWThFS_20200324_20200513,20210101,New Years Day,2
BOP00_MTWThFS_20200324_20200513,20201226,Boxing Day,2
BOP00_MTWThFS_20200324_20200513,20201225,Christmas Day,2
BOP00_MTWThFS_20200324_20200513,20201026,Labour Day,2
BOP00_MTWThFS_20200324_20200513,20200601,Queen's Birthday,2
BOP00_Excpetion_Calendar_0,20210405,Easter Monday,2
BOP00_Excpetion_Calendar_0,20210201,Auckland Anniversary Day,2
BOP00_Excpetion_Calendar_0,20201026,Labour Day,2
BOP00_Excpetion_Calendar_0,20200601,Queen's Birthday,2
BOP00_Excpetion_Calendar_1,20201226,Boxing Day,2
BOP00_Excpetion_Calendar_2,20201226,Boxing Day,2
BOP00_Excpetion_Calendar_3,20201226,Boxing Day,2
BOP00_MTWThF_20200324_20200513,20210405,Easter Monday,2
BOP00_MTWThF_20200324_20200513,20210402,Good Friday,2
BOP00_MTWThF_20200324_20200513,20210201,Auckland Anniversary Day,2
BOP00_MTWThF_20200324_20200513,20210101,New Years Day,2
BOP00_MTWThF_20200324_20200513,20201225,Christmas Day,2
BOP00_MTWThF_20200324_20200513,20201026,Labour Day,2
BOP00_MTWThF_20200324_20200513,20200601,Queen's Birthday,2
BOP00_Excpetion_Calendar_4,20210405,Easter Monday,2
BOP00_Excpetion_Calendar_4,20210402,Good Friday,2
BOP00_Excpetion_Calendar_4,20210201,Auckland Anniversary Day,2
BOP00_Excpetion_Calendar_4,20210101,New Years Day,2
BOP00_Excpetion_Calendar_4,20201225,Christmas Day,2
BOP00_Excpetion_Calendar_4,20201026,Labour Day,2
BOP00_Excpetion_Calendar_4,20200601,Queen's Birthday,2
BOP00_Excpetion_Calendar_5,20210402,Good Friday,2
BOP00_Excpetion_Calendar_5,20210101,New Years Day,2
BOP00_Excpetion_Calendar_5,20201225,Christmas Day,2
BOP00_MTWThF_20200720_20200925,20201026,Labour Day,2
BOP00_MTWThF_20200720_20200925,20200601,Queen's Birthday,2
BOP00_MTWThF_20200615_20200703,20201026,Labour Day,2
BOP00_MTWThF_20200615_20200703,20200601,Queen's Birthday,2
BOP00_MTWThF_20201012_20201218,20201026,Labour Day,2
BOP00_MTWThF_20201012_20201218,20200601,Queen's Birthday,2
BOP00_MTWThF_20200926_20201011,20210201,Auckland Anniversary Day,2
BOP00_MTWThF_20200926_20201011,20210101,New Years Day,2
BOP00_MTWThF_20200926_20201011,20201225,Christmas Day,2
BOP00_MTWThF_20201219_20210131,20210201,Auckland Anniversary Day,2
BOP00_MTWThF_20201219_20210131,20210101,New Years Day,2
BOP00_MTWThF_20201219_20210131,20201225,Christmas Day,2
BOP00_MTWThF_20200704_20200719,20210201,Auckland Anniversary Day,2
BOP00_MTWThF_20200704_20200719,20210101,New Years Day,2
BOP00_MTWThF_20200704_20200719,20201225,Christmas Day,2
BOP00_MTWThF_20200518_20201218,20210405,Easter Monday,2
BOP00_MTWThF_20200518_20201218,20210402,Good Friday,2
BOP00_Excpetion_Calendar_6,20201225,Christmas Day,1
BOP00_Excpetion_Calendar_7,20210405,Easter Monday,1
BOP00_Excpetion_Calendar_7,20210201,Auckland Anniversary Day,1
BOP00_Excpetion_Calendar_7,20210101,New Years Day,1
BOP00_Excpetion_Calendar_7,20201226,Boxing Day,1
BOP00_Excpetion_Calendar_7,20201026,Labour Day,1
BOP00_Excpetion_Calendar_7,20200601,Queen's Birthday,1
BOP00_MTWThFS_20200514_20210531,20210405,Easter Monday,2
BOP00_MTWThFS_20200514_20210531,20210402,Good Friday,2
BOP00_MTWThFS_20200514_20210531,20210201,Auckland Anniversary Day,2
BOP00_MTWThFS_20200514_20210531,20210101,New Years Day,2
BOP00_MTWThFS_20200514_20210531,20201226,Boxing Day,2
BOP00_MTWThFS_20200514_20210531,20201225,Christmas Day,2
BOP00_MTWThFS_20200514_20210531,20201026,Labour Day,2
BOP00_MTWThFS_20200514_20210531,20200601,Queen's Birthday,2
BOP00_MW_20200514_20210531,20210405,Easter Monday,2
BOP00_MW_20200514_20210531,20210201,Auckland Anniversary Day,2
BOP00_MW_20200514_20210531,20201026,Labour Day,2
BOP00_MW_20200514_20210531,20200601,Queen's Birthday,2
BOP00_TThS_20200514_20210531,20201226,Boxing Day,2
BOP00_ThS_20200514_20210531,20201226,Boxing Day,2
BOP00_S_20200514_20210531,20201226,Boxing Day,2
BOP00_MTWThF_20200514_20210531,20210405,Easter Monday,2
BOP00_MTWThF_20200514_20210531,20210402,Good Friday,2
BOP00_MTWThF_20200514_20210531,20210201,Auckland Anniversary Day,2
BOP00_MTWThF_20200514_20210531,20210101,New Years Day,2
BOP00_MTWThF_20200514_20210531,20201225,Christmas Day,2
BOP00_MTWThF_20200514_20210531,20201026,Labour Day,2
BOP00_MTWThF_20200514_20210531,20200601,Queen's Birthday,2
BOP00_MTF_20200514_20210531,20210405,Easter Monday,2
BOP00_MTF_20200514_20210531,20210402,Good Friday,2
BOP00_MTF_20200514_20210531,20210201,Auckland Anniversary Day,2
BOP00_MTF_20200514_20210531,20210101,New Years Day,2
BOP00_MTF_20200514_20210531,20201225,Christmas Day,2
BOP00_MTF_20200514_20210531,20201026,Labour Day,2
BOP00_MTF_20200514_20210531,20200601,Queen's Birthday,2
BOP00_F_20200514_20210531,20210402,Good Friday,2
BOP00_F_20200514_20210531,20210101,New Years Day,2
BOP00_F_20200514_20210531,20201225,Christmas Day,2
BOP00_Excpetion_Calendar_8,20210405,Easter Monday,1
BOP00_Excpetion_Calendar_8,20210402,Good Friday,1