service_id,date,holiday_name,exception_type
BOP00_MTWThF_20200720_20200925,20201026,Labour Day,2
BOP00_MTWThF_20200720_20200925,20200601,Queen's Birthday,2
BOP00_MTWThF_20200506_20200703,20201026,Labour Day,2
BOP00_MTWThF_20200506_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_20200926_20201011,20200427,ANZAC Day,2
BOP00_MTWThF_20200926_20201011,20200413,Easter Monday,2
BOP00_MTWThF_20200926_20201011,20200410,Good Friday,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_20201219_20210131,20200427,ANZAC Day,2
BOP00_MTWThF_20201219_20210131,20200413,Easter Monday,2
BOP00_MTWThF_20201219_20210131,20200410,Good Friday,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_20200704_20200719,20200427,ANZAC Day,2
BOP00_MTWThF_20200704_20200719,20200413,Easter Monday,2
BOP00_MTWThF_20200704_20200719,20200410,Good Friday,2
BOP00_Excpetion_Calendar_0,20201225,Christmas Day,1
BOP00_Excpetion_Calendar_1,20210201,Auckland Anniversary Day,1
BOP00_Excpetion_Calendar_1,20210101,New Years Day,1
BOP00_Excpetion_Calendar_1,20201226,Boxing Day,1
BOP00_Excpetion_Calendar_1,20201026,Labour Day,1
BOP00_Excpetion_Calendar_1,20200601,Queen's Birthday,1
BOP00_Excpetion_Calendar_1,20200427,ANZAC Day,1
BOP00_Excpetion_Calendar_1,20200413,Easter Monday,1
BOP00_MTWThFS_20191014_20211231,20210201,Auckland Anniversary Day,2
BOP00_MTWThFS_20191014_20211231,20210101,New Years Day,2
BOP00_MTWThFS_20191014_20211231,20201226,Boxing Day,2
BOP00_MTWThFS_20191014_20211231,20201225,Christmas Day,2
BOP00_MTWThFS_20191014_20211231,20201026,Labour Day,2
BOP00_MTWThFS_20191014_20211231,20200601,Queen's Birthday,2
BOP00_MTWThFS_20191014_20211231,20200427,ANZAC Day,2
BOP00_MTWThFS_20191014_20211231,20200413,Easter Monday,2
BOP00_MTWThFS_20191014_20211231,20200410,Good Friday,2
BOP00_MW_20191014_20211231,20210201,Auckland Anniversary Day,2
BOP00_MW_20191014_20211231,20201026,Labour Day,2
BOP00_MW_20191014_20211231,20200601,Queen's Birthday,2
BOP00_MW_20191014_20211231,20200427,ANZAC Day,2
BOP00_MW_20191014_20211231,20200413,Easter Monday,2
BOP00_TThS_20191014_20211231,20201226,Boxing Day,2
BOP00_ThS_20191014_20211231,20201226,Boxing Day,2
BOP00_S_20191014_20211231,20201226,Boxing Day,2
BOP00_MTWThF_20191014_20211231,20210201,Auckland Anniversary Day,2
BOP00_MTWThF_20191014_20211231,20210101,New Years Day,2
BOP00_MTWThF_20191014_20211231,20201225,Christmas Day,2
BOP00_MTWThF_20191014_20211231,20201026,Labour Day,2
BOP00_MTWThF_20191014_20211231,20200601,Queen's Birthday,2
BOP00_MTWThF_20191014_20211231,20200427,ANZAC Day,2
BOP00_MTWThF_20191014_20211231,20200413,Easter Monday,2
BOP00_MTWThF_20191014_20211231,20200410,Good Friday,2
BOP00_MTF_20191014_20211231,20210201,Auckland Anniversary Day,2
BOP00_MTF_20191014_20211231,20210101,New Years Day,2
BOP00_MTF_20191014_20211231,20201225,Christmas Day,2
BOP00_MTF_20191014_20211231,20201026,Labour Day,2
BOP00_MTF_20191014_20211231,20200601,Queen's Birthday,2
BOP00_MTF_20191014_20211231,20200427,ANZAC Day,2
BOP00_MTF_20191014_20211231,20200413,Easter Monday,2
BOP00_MTF_20191014_20211231,20200410,Good Friday,2
BOP00_F_20191014_20211231,20210101,New Years Day,2
BOP00_F_20191014_20211231,20201225,Christmas Day,2
BOP00_F_20191014_20211231,20200410,Good Friday,2
BOP00_Excpetion_Calendar_2,20200427,ANZAC Day,1
BOP00_Excpetion_Calendar_2,20200413,Easter Monday,1
BOP00_Excpetion_Calendar_2,20200410,Good Friday,1
BOP00_MTWThF_20200410_20200427,20200427,ANZAC Day,2
BOP00_MTWThF_20200410_20200427,20200413,Easter Monday,2
BOP00_MTWThF_20200410_20200427,20200410,Good Friday,2