service_id,date,holiday_name,exception_type
BOP00_Excpetion_Calendar_0,20201226,Boxing Day,1
BOP00_Excpetion_Calendar_0,20201225,Christmas Day,1
BOP00_Excpetion_Calendar_0,20201026,Labour Day,1
BOP00_Excpetion_Calendar_0,20200601,Queen's Birthday,1
BOP00_Excpetion_Calendar_0,20200427,ANZAC Day,1
BOP00_Excpetion_Calendar_0,20200413,Easter Monday,1
BOP00_Excpetion_Calendar_0,20200410,Good Friday,1
BOP00_Excpetion_Calendar_0,20200206,Waitangi Day,1
BOP00_Excpetion_Calendar_0,20200127,Auckland Anniversary Day,1
BOP00_Excpetion_Calendar_0,20200102,Day after New Years Day,1
BOP00_Excpetion_Calendar_0,20200101,New Years Day,1
BOP00_Excpetion_Calendar_0,20191226,Boxing Day,1
BOP00_Excpetion_Calendar_0,20191225,Christmas Day,1
BOP00_Excpetion_Calendar_0,20191028,Labour 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_Excpetion_Calendar_1,20200206,Waitangi Day,1
BOP00_Excpetion_Calendar_1,20200127,Auckland Anniversary Day,1
BOP00_Excpetion_Calendar_1,20200102,Day after New Years Day,1
BOP00_Excpetion_Calendar_1,20200101,New Years Day,1
BOP00_Excpetion_Calendar_1,20191226,Boxing Day,1
BOP00_Excpetion_Calendar_1,20191028,Labour Day,1
BOP00_SSu_20181210_20211231,20201226,Boxing Day,2
BOP00_Th_20181210_20211231,20200206,Waitangi Day,2
BOP00_Th_20181210_20211231,20200102,Day after New Years Day,2
BOP00_Th_20181210_20211231,20191226,Boxing Day,2
BOP00_MTWThFS_20181210_20211231,20201226,Boxing Day,2
BOP00_MTWThFS_20181210_20211231,20201225,Christmas Day,2
BOP00_MTWThFS_20181210_20211231,20201026,Labour Day,2
BOP00_MTWThFS_20181210_20211231,20200601,Queen's Birthday,2
BOP00_MTWThFS_20181210_20211231,20200427,ANZAC Day,2
BOP00_MTWThFS_20181210_20211231,20200413,Easter Monday,2
BOP00_MTWThFS_20181210_20211231,20200410,Good Friday,2
BOP00_MTWThFS_20181210_20211231,20200206,Waitangi Day,2
BOP00_MTWThFS_20181210_20211231,20200127,Auckland Anniversary Day,2
BOP00_MTWThFS_20181210_20211231,20200102,Day after New Years Day,2
BOP00_MTWThFS_20181210_20211231,20200101,New Years Day,2
BOP00_MTWThFS_20181210_20211231,20191226,Boxing Day,2
BOP00_MTWThFS_20181210_20211231,20191225,Christmas Day,2
BOP00_MTWThFS_20181210_20211231,20191028,Labour Day,2
BOP00_MW_20181210_20211231,20201026,Labour Day,2
BOP00_MW_20181210_20211231,20200601,Queen's Birthday,2
BOP00_MW_20181210_20211231,20200427,ANZAC Day,2
BOP00_MW_20181210_20211231,20200413,Easter Monday,2
BOP00_MW_20181210_20211231,20200127,Auckland Anniversary Day,2
BOP00_MW_20181210_20211231,20200101,New Years Day,2
BOP00_MW_20181210_20211231,20191225,Christmas Day,2
BOP00_MW_20181210_20211231,20191028,Labour Day,2
BOP00_TThS_20181210_20211231,20201226,Boxing Day,2
BOP00_TThS_20181210_20211231,20200206,Waitangi Day,2
BOP00_TThS_20181210_20211231,20200102,Day after New Years Day,2
BOP00_TThS_20181210_20211231,20191226,Boxing Day,2
BOP00_ThS_20181210_20211231,20201226,Boxing Day,2
BOP00_ThS_20181210_20211231,20200206,Waitangi Day,2
BOP00_ThS_20181210_20211231,20200102,Day after New Years Day,2
BOP00_ThS_20181210_20211231,20191226,Boxing Day,2
BOP00_W_20181210_20211231,20200101,New Years Day,2
BOP00_W_20181210_20211231,20191225,Christmas Day,2
BOP00_S_20181210_20211231,20201226,Boxing Day,2
BOP00_MTWThF_20181210_20211231,20201225,Christmas Day,2
BOP00_MTWThF_20181210_20211231,20201026,Labour Day,2
BOP00_MTWThF_20181210_20211231,20200601,Queen's Birthday,2
BOP00_MTWThF_20181210_20211231,20200427,ANZAC Day,2
BOP00_MTWThF_20181210_20211231,20200413,Easter Monday,2
BOP00_MTWThF_20181210_20211231,20200410,Good Friday,2
BOP00_MTWThF_20181210_20211231,20200206,Waitangi Day,2
BOP00_MTWThF_20181210_20211231,20200127,Auckland Anniversary Day,2
BOP00_MTWThF_20181210_20211231,20200102,Day after New Years Day,2
BOP00_MTWThF_20181210_20211231,20200101,New Years Day,2
BOP00_MTWThF_20181210_20211231,20191226,Boxing Day,2
BOP00_MTWThF_20181210_20211231,20191225,Christmas Day,2
BOP00_MTWThF_20181210_20211231,20191028,Labour Day,2
BOP00_MTF_20181210_20211231,20201225,Christmas Day,2
BOP00_MTF_20181210_20211231,20201026,Labour Day,2
BOP00_MTF_20181210_20211231,20200601,Queen's Birthday,2
BOP00_MTF_20181210_20211231,20200427,ANZAC Day,2
BOP00_MTF_20181210_20211231,20200413,Easter Monday,2
BOP00_MTF_20181210_20211231,20200410,Good Friday,2
BOP00_MTF_20181210_20211231,20200127,Auckland Anniversary Day,2
BOP00_MTF_20181210_20211231,20191028,Labour Day,2
BOP00_F_20181210_20211231,20201225,Christmas Day,2
BOP00_F_20181210_20211231,20200410,Good Friday,2
BOP00_TTh_20181210_20211231,20200206,Waitangi Day,2
BOP00_TTh_20181210_20211231,20200102,Day after New Years Day,2
BOP00_TTh_20181210_20211231,20191226,Boxing 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_20200926_20201011,20200127,Auckland Anniversary Day,2
BOP00_MTWThF_20200926_20201011,20200102,Day after New Years Day,2
BOP00_MTWThF_20200926_20201011,20200101,New Years Day,2
BOP00_MTWThF_20200926_20201011,20191226,Boxing Day,2
BOP00_MTWThF_20200926_20201011,20191225,Christmas Day,2
BOP00_MTWThF_20191221_20200202,20201225,Christmas Day,2
BOP00_MTWThF_20191221_20200202,20200427,ANZAC Day,2
BOP00_MTWThF_20191221_20200202,20200413,Easter Monday,2
BOP00_MTWThF_20191221_20200202,20200410,Good Friday,2
BOP00_MTWThF_20191221_20200202,20200127,Auckland Anniversary Day,2
BOP00_MTWThF_20191221_20200202,20200102,Day after New Years Day,2
BOP00_MTWThF_20191221_20200202,20200101,New Years Day,2
BOP00_MTWThF_20191221_20200202,20191226,Boxing Day,2
BOP00_MTWThF_20191221_20200202,20191225,Christmas 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_20201219_20210131,20200127,Auckland Anniversary Day,2
BOP00_MTWThF_20201219_20210131,20200102,Day after New Years Day,2
BOP00_MTWThF_20201219_20210131,20200101,New Years Day,2
BOP00_MTWThF_20201219_20210131,20191226,Boxing Day,2
BOP00_MTWThF_20201219_20210131,20191225,Christmas Day,2
BOP00_MTWThF_20190928_20191013,20201225,Christmas Day,2
BOP00_MTWThF_20190928_20191013,20200427,ANZAC Day,2
BOP00_MTWThF_20190928_20191013,20200413,Easter Monday,2
BOP00_MTWThF_20190928_20191013,20200410,Good Friday,2
BOP00_MTWThF_20190928_20191013,20200127,Auckland Anniversary Day,2
BOP00_MTWThF_20190928_20191013,20200102,Day after New Years Day,2
BOP00_MTWThF_20190928_20191013,20200101,New Years Day,2
BOP00_MTWThF_20190928_20191013,20191226,Boxing Day,2
BOP00_MTWThF_20190928_20191013,20191225,Christmas 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_MTWThF_20200704_20200719,20200127,Auckland Anniversary Day,2
BOP00_MTWThF_20200704_20200719,20200102,Day after New Years Day,2
BOP00_MTWThF_20200704_20200719,20200101,New Years Day,2
BOP00_MTWThF_20200704_20200719,20191226,Boxing Day,2
BOP00_MTWThF_20200704_20200719,20191225,Christmas Day,2
BOP00_MTWThF_20200410_20200427,20201225,Christmas Day,2
BOP00_MTWThF_20200410_20200427,20200427,ANZAC Day,2
BOP00_MTWThF_20200410_20200427,20200413,Easter Monday,2
BOP00_MTWThF_20200410_20200427,20200410,Good Friday,2
BOP00_MTWThF_20200410_20200427,20200127,Auckland Anniversary Day,2
BOP00_MTWThF_20200410_20200427,20200102,Day after New Years Day,2
BOP00_MTWThF_20200410_20200427,20200101,New Years Day,2
BOP00_MTWThF_20200410_20200427,20191226,Boxing Day,2
BOP00_MTWThF_20200410_20200427,20191225,Christmas Day,2
BOP00_MTWThF_20200428_20200703,20201026,Labour Day,2
BOP00_MTWThF_20200428_20200703,20200601,Queen's Birthday,2
BOP00_MTWThF_20200428_20200703,20200206,Waitangi Day,2
BOP00_MTWThF_20200428_20200703,20191028,Labour Day,2
BOP00_MTWThF_20200720_20200925,20201026,Labour Day,2
BOP00_MTWThF_20200720_20200925,20200601,Queen's Birthday,2
BOP00_MTWThF_20200720_20200925,20200206,Waitangi Day,2
BOP00_MTWThF_20200720_20200925,20191028,Labour Day,2
BOP00_MTWThF_20201012_20201218,20201026,Labour Day,2
BOP00_MTWThF_20201012_20201218,20200601,Queen's Birthday,2
BOP00_MTWThF_20201012_20201218,20200206,Waitangi Day,2
BOP00_MTWThF_20201012_20201218,20191028,Labour Day,2
BOP00_MTWThF_20200203_20200409,20201026,Labour Day,2
BOP00_MTWThF_20200203_20200409,20200601,Queen's Birthday,2
BOP00_MTWThF_20200203_20200409,20200206,Waitangi Day,2
BOP00_MTWThF_20200203_20200409,20191028,Labour Day,2
BOP00_MTWThF_20191014_20191220_1,20201026,Labour Day,2
BOP00_MTWThF_20191014_20191220_1,20200601,Queen's Birthday,2
BOP00_MTWThF_20191014_20191220_1,20200206,Waitangi Day,2
BOP00_MTWThF_20191014_20191220_1,20191028,Labour Day,2
BOP00_MTWThF_20190722_20190927,20201026,Labour Day,2
BOP00_MTWThF_20190722_20190927,20200601,Queen's Birthday,2
BOP00_MTWThF_20190722_20190927,20200206,Waitangi Day,2
BOP00_MTWThF_20190722_20190927,20191028,Labour Day,2