Skip to content

Instantly share code, notes, and snippets.

@abitgone

abitgone/dw.date_publicholiday_uk.data.sql

Created December 22, 2025 16:18
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save abitgone/772c60549e5ea5f08152334ee6789350 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save abitgone/772c60549e5ea5f08152334ee6789350 to your computer and use it in GitHub Desktop.
Download ZIP
Creates a table, and seeds it with historic bank holiday dates from 1980 to 2028 (as at December 2025). Used in conjunction with an Azure Synapse Pipeline and Data Flow which loads UK Bank Holiday details from the public UK Bank Holidays feed at https://www.gov.uk/bank-holidays.json.
Raw
dw.date_publicholiday_uk.data.sql
WITH
BankHoliday AS (
(VALUES
-- 1980
('1980-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1980-01-01', 'New Year''s Day', 'scotland', NULL),
('1980-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1980-01-02', '2nd January', 'scotland', NULL),
('1980-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1980-04-04', 'Good Friday', 'england-and-wales', NULL),
('1980-04-04', 'Good Friday', 'scotland', NULL),
('1980-04-04', 'Good Friday', 'northern-ireland', NULL),
('1980-04-07', 'Easter Monday', 'england-and-wales', NULL),
('1980-04-07', 'Easter Monday', 'northern-ireland', NULL),
('1980-05-05', 'Early May bank holiday', 'england-and-wales', NULL),
('1980-05-05', 'Early May bank holiday', 'scotland', NULL),
('1980-05-05', 'Early May bank holiday', 'northern-ireland', NULL),
('1980-05-26', 'Spring bank holiday', 'england-and-wales', NULL),
('1980-05-26', 'Spring bank holiday', 'scotland', NULL),
('1980-05-26', 'Spring bank holiday', 'northern-ireland', NULL),
('1980-07-14', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', 'Substitute Day'),
('1980-08-04', 'Summer bank holiday', 'scotland', NULL),
('1980-08-25', 'Summer bank holiday', 'england-and-wales', NULL),
('1980-08-25', 'Summer bank holiday', 'northern-ireland', NULL),
('1980-12-01', 'St Andrew''s Day', 'scotland', 'Substitute Day'),
('1980-12-25', 'Christmas Day', 'england-and-wales', NULL),
('1980-12-25', 'Christmas Day', 'scotland', NULL),
('1980-12-25', 'Christmas Day', 'northern-ireland', NULL),
('1980-12-26', 'Boxing Day', 'england-and-wales', NULL),
('1980-12-26', 'Boxing Day', 'scotland', NULL),
('1980-12-26', 'Boxing Day', 'northern-ireland', NULL),
('1981-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1981-01-01', 'New Year''s Day', 'scotland', NULL),
('1981-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1981-01-02', '2nd January', 'scotland', NULL),
('1981-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1981-04-17', 'Good Friday', 'england-and-wales', NULL),
('1981-04-17', 'Good Friday', 'scotland', NULL),
('1981-04-17', 'Good Friday', 'northern-ireland', NULL),
('1981-04-20', 'Easter Monday', 'england-and-wales', NULL),
('1981-04-20', 'Easter Monday', 'northern-ireland', NULL),
('1981-05-04', 'Early May bank holiday', 'england-and-wales', NULL),
('1981-05-04', 'Early May bank holiday', 'scotland', NULL),
('1981-05-04', 'Early May bank holiday', 'northern-ireland', NULL),
('1981-05-25', 'Spring bank holiday', 'england-and-wales', NULL),
('1981-05-25', 'Spring bank holiday', 'scotland', NULL),
('1981-05-25', 'Spring bank holiday', 'northern-ireland', NULL),
('1981-07-13', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', 'Substitute Day'),
('1981-07-29', 'The wedding of Charles, Price of Wales, and Lady Diana Spencer', 'scotland', NULL),
('1981-07-29', 'The wedding of Charles, Price of Wales, and Lady Diana Spencer', 'england-and-wales', NULL),
('1981-07-29', 'The wedding of Charles, Price of Wales, and Lady Diana Spencer', 'northern-ireland', NULL),
('1981-08-03', 'Summer bank holiday', 'scotland', NULL),
('1981-08-31', 'Summer bank holiday', 'england-and-wales', NULL),
('1981-08-31', 'Summer bank holiday', 'northern-ireland', NULL),
('1981-11-30', 'St Andrew''s Day', 'scotland', 'Substitute Day'),
('1981-12-25', 'Christmas Day', 'england-and-wales', NULL),
('1981-12-25', 'Christmas Day', 'scotland', NULL),
('1981-12-25', 'Christmas Day', 'northern-ireland', NULL),
('1981-12-28', 'Boxing Day', 'england-and-wales', 'Substitute Day'),
('1981-12-28', 'Boxing Day', 'scotland', 'Substitute Day'),
('1981-12-28', 'Boxing Day', 'northern-ireland', 'Substitute Day'),
('1982-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1982-01-01', 'New Year''s Day', 'scotland', NULL),
('1982-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1982-01-04', '2nd January', 'scotland', 'Substitute Day'),
('1982-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1982-04-09', 'Good Friday', 'england-and-wales', NULL),
('1982-04-09', 'Good Friday', 'scotland', NULL),
('1982-04-09', 'Good Friday', 'northern-ireland', NULL),
('1982-04-12', 'Easter Monday', 'england-and-wales', NULL),
('1982-04-12', 'Easter Monday', 'northern-ireland', NULL),
('1982-05-03', 'Early May bank holiday', 'england-and-wales', NULL),
('1982-05-03', 'Early May bank holiday', 'scotland', NULL),
('1982-05-03', 'Early May bank holiday', 'northern-ireland', NULL),
('1982-05-31', 'Spring bank holiday', 'england-and-wales', NULL),
('1982-05-31', 'Spring bank holiday', 'scotland', NULL),
('1982-05-31', 'Spring bank holiday', 'northern-ireland', NULL),
('1982-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('1982-08-02', 'Summer bank holiday', 'scotland', NULL),
('1982-08-30', 'Summer bank holiday', 'england-and-wales', NULL),
('1982-08-30', 'Summer bank holiday', 'northern-ireland', NULL),
('1982-11-30', 'St Andrew''s Day', 'scotland', NULL),
('1982-12-27', 'Christmas Day', 'england-and-wales', 'Substitute Day'),
('1982-12-27', 'Christmas Day', 'scotland', 'Substitute Day'),
('1982-12-27', 'Christmas Day', 'northern-ireland', 'Substitute Day'),
('1982-12-28', 'Boxing Day', 'england-and-wales', 'Substitute Day'),
('1982-12-28', 'Boxing Day', 'scotland', 'Substitute Day'),
('1982-12-28', 'Boxing Day', 'northern-ireland', 'Substitute Day'),
('1983-01-03', 'New Year''s Day', 'england-and-wales', 'Substitute Day'),
('1983-01-03', 'New Year''s Day', 'scotland', 'Substitute Day'),
('1983-01-03', 'New Year''s Day', 'northern-ireland', 'Substitute Day'),
('1983-01-04', '2nd January', 'scotland', 'Substitute Day'),
('1983-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1983-04-01', 'Good Friday', 'england-and-wales', NULL),
('1983-04-01', 'Good Friday', 'scotland', NULL),
('1983-04-01', 'Good Friday', 'northern-ireland', NULL),
('1983-04-04', 'Easter Monday', 'england-and-wales', NULL),
('1983-04-04', 'Easter Monday', 'northern-ireland', NULL),
('1983-05-02', 'Early May bank holiday', 'england-and-wales', NULL),
('1983-05-02', 'Early May bank holiday', 'scotland', NULL),
('1983-05-02', 'Early May bank holiday', 'northern-ireland', NULL),
('1983-05-30', 'Spring bank holiday', 'england-and-wales', NULL),
('1983-05-30', 'Spring bank holiday', 'scotland', NULL),
('1983-05-30', 'Spring bank holiday', 'northern-ireland', NULL),
('1983-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('1983-08-01', 'Summer bank holiday', 'scotland', NULL),
('1983-08-29', 'Summer bank holiday', 'england-and-wales', NULL),
('1983-08-29', 'Summer bank holiday', 'northern-ireland', NULL),
('1983-11-30', 'St Andrew''s Day', 'scotland', 'Substitute Day'),
('1983-12-26', 'Boxing Day', 'england-and-wales', NULL),
('1983-12-26', 'Boxing Day', 'scotland', NULL),
('1983-12-26', 'Boxing Day', 'northern-ireland', NULL),
('1983-12-27', 'Christmas Day', 'england-and-wales', 'Substitute Day'),
('1983-12-27', 'Christmas Day', 'scotland', 'Substitute Day'),
('1983-12-27', 'Christmas Day', 'northern-ireland', 'Substitute Day'),
('1984-01-02', 'New Year''s Day', 'england-and-wales', 'Substitute Day'),
('1984-01-02', 'New Year''s Day', 'northern-ireland', 'Substitute Day'),
('1984-01-03', '2nd January', 'scotland', NULL),
('1984-01-03', 'New Year''s Day', 'scotland', 'Substitute Day'),
('1984-03-19', 'St Patrick''s Day', 'northern-ireland', NULL),
('1984-04-20', 'Good Friday', 'england-and-wales', NULL),
('1984-04-20', 'Good Friday', 'scotland', NULL),
('1984-04-20', 'Good Friday', 'northern-ireland', NULL),
('1984-04-23', 'Easter Monday', 'england-and-wales', NULL),
('1984-04-23', 'Easter Monday', 'northern-ireland', NULL),
('1984-05-07', 'Early May bank holiday', 'england-and-wales', NULL),
('1984-05-07', 'Early May bank holiday', 'scotland', NULL),
('1984-05-07', 'Early May bank holiday', 'northern-ireland', NULL),
('1984-05-28', 'Spring bank holiday', 'england-and-wales', NULL),
('1984-05-28', 'Spring bank holiday', 'scotland', NULL),
('1984-05-28', 'Spring bank holiday', 'northern-ireland', NULL),
('1984-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('1984-08-06', 'Summer bank holiday', 'scotland', NULL),
('1984-08-27', 'Summer bank holiday', 'england-and-wales', NULL),
('1984-08-27', 'Summer bank holiday', 'northern-ireland', NULL),
('1984-11-30', 'St Andrew''s Day', 'scotland', NULL),
('1984-12-25', 'Christmas Day', 'england-and-wales', NULL),
('1984-12-25', 'Christmas Day', 'scotland', NULL),
('1984-12-25', 'Christmas Day', 'northern-ireland', NULL),
('1984-12-26', 'Boxing Day', 'england-and-wales', NULL),
('1984-12-26', 'Boxing Day', 'scotland', NULL),
('1984-12-26', 'Boxing Day', 'northern-ireland', NULL),
('1985-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1985-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1985-01-01', 'New Year''s Day', 'scotland', NULL),
('1985-01-02', '2nd January', 'scotland', NULL),
('1985-03-18', 'St Patrick''s Day', 'northern-ireland', 'Substitute Day'),
('1985-04-05', 'Good Friday', 'england-and-wales', NULL),
('1985-04-05', 'Good Friday', 'scotland', NULL),
('1985-04-05', 'Good Friday', 'northern-ireland', NULL),
('1985-04-08', 'Easter Monday', 'england-and-wales', NULL),
('1985-04-08', 'Easter Monday', 'northern-ireland', NULL),
('1985-05-06', 'Early May bank holiday', 'england-and-wales', NULL),
('1985-05-06', 'Early May bank holiday', 'scotland', NULL),
('1985-05-06', 'Early May bank holiday', 'northern-ireland', NULL),
('1985-05-27', 'Spring bank holiday', 'england-and-wales', NULL),
('1985-05-27', 'Spring bank holiday', 'scotland', NULL),
('1985-05-27', 'Spring bank holiday', 'northern-ireland', NULL),
('1985-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('1985-08-05', 'Summer bank holiday', 'scotland', NULL),
('1985-08-26', 'Summer bank holiday', 'england-and-wales', NULL),
('1985-08-26', 'Summer bank holiday', 'northern-ireland', NULL),
('1985-12-02', 'St Andrew''s Day', 'scotland', 'Substitute Day'),
('1985-12-25', 'Christmas Day', 'england-and-wales', NULL),
('1985-12-25', 'Christmas Day', 'scotland', NULL),
('1985-12-25', 'Christmas Day', 'northern-ireland', NULL),
('1985-12-26', 'Boxing Day', 'england-and-wales', NULL),
('1985-12-26', 'Boxing Day', 'scotland', NULL),
('1985-12-26', 'Boxing Day', 'northern-ireland', NULL),
('1986-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1986-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1986-01-01', 'New Year''s Day', 'scotland', NULL),
('1986-01-02', '2nd January', 'scotland', NULL),
('1986-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1986-03-28', 'Good Friday', 'england-and-wales', NULL),
('1986-03-28', 'Good Friday', 'scotland', NULL),
('1986-03-28', 'Good Friday', 'northern-ireland', NULL),
('1986-03-31', 'Easter Monday', 'england-and-wales', NULL),
('1986-03-31', 'Easter Monday', 'northern-ireland', NULL),
('1986-05-05', 'Early May bank holiday', 'england-and-wales', NULL),
('1986-05-05', 'Early May bank holiday', 'scotland', NULL),
('1986-05-05', 'Early May bank holiday', 'northern-ireland', NULL),
('1986-05-26', 'Spring bank holiday', 'england-and-wales', NULL),
('1986-05-26', 'Spring bank holiday', 'scotland', NULL),
('1986-05-26', 'Spring bank holiday', 'northern-ireland', NULL),
('1986-07-14', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', 'Substitute Day'),
('1986-08-04', 'Summer bank holiday', 'scotland', NULL),
('1986-08-25', 'Summer bank holiday', 'england-and-wales', NULL),
('1986-08-25', 'Summer bank holiday', 'northern-ireland', NULL),
('1986-12-01', 'St Andrew''s Day', 'scotland', 'Substitute Day'),
('1986-12-25', 'Christmas Day', 'england-and-wales', NULL),
('1986-12-25', 'Christmas Day', 'scotland', NULL),
('1986-12-25', 'Christmas Day', 'northern-ireland', NULL),
('1986-12-26', 'Boxing Day', 'england-and-wales', NULL),
('1986-12-26', 'Boxing Day', 'scotland', NULL),
('1986-12-26', 'Boxing Day', 'northern-ireland', NULL),
('1987-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1987-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1987-01-01', 'New Year''s Day', 'scotland', NULL),
('1987-01-02', '2nd January', 'scotland', NULL),
('1987-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1987-04-17', 'Good Friday', 'england-and-wales', NULL),
('1987-04-17', 'Good Friday', 'scotland', NULL),
('1987-04-17', 'Good Friday', 'northern-ireland', NULL),
('1987-04-20', 'Easter Monday', 'england-and-wales', NULL),
('1987-04-20', 'Easter Monday', 'northern-ireland', NULL),
('1987-05-04', 'Early May bank holiday', 'england-and-wales', NULL),
('1987-05-04', 'Early May bank holiday', 'scotland', NULL),
('1987-05-04', 'Early May bank holiday', 'northern-ireland', NULL),
('1987-05-25', 'Spring bank holiday', 'england-and-wales', NULL),
('1987-05-25', 'Spring bank holiday', 'scotland', NULL),
('1987-05-25', 'Spring bank holiday', 'northern-ireland', NULL),
('1987-07-13', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', 'Substitute Day'),
('1987-08-03', 'Summer bank holiday', 'scotland', NULL),
('1987-08-31', 'Summer bank holiday', 'england-and-wales', NULL),
('1987-08-31', 'Summer bank holiday', 'northern-ireland', NULL),
('1987-11-30', 'St Andrew''s Day', 'scotland', NULL),
('1987-12-25', 'Christmas Day', 'england-and-wales', NULL),
('1987-12-25', 'Christmas Day', 'scotland', NULL),
('1987-12-25', 'Christmas Day', 'northern-ireland', NULL),
('1987-12-28', 'Boxing Day', 'england-and-wales', 'Substitute Day'),
('1987-12-28', 'Boxing Day', 'scotland', 'Substitute Day'),
('1987-12-28', 'Boxing Day', 'northern-ireland', 'Substitute Day'),
('1988-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1988-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1988-01-01', 'New Year''s Day', 'scotland', NULL),
('1988-01-04', '2nd January', 'scotland', 'Substitute Day'),
('1988-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1988-04-01', 'Good Friday', 'england-and-wales', NULL),
('1988-04-01', 'Good Friday', 'scotland', NULL),
('1988-04-01', 'Good Friday', 'northern-ireland', NULL),
('1988-04-04', 'Easter Monday', 'england-and-wales', NULL),
('1988-04-04', 'Easter Monday', 'northern-ireland', NULL),
('1988-05-02', 'Early May bank holiday', 'england-and-wales', NULL),
('1988-05-02', 'Early May bank holiday', 'scotland', NULL),
('1988-05-02', 'Early May bank holiday', 'northern-ireland', NULL),
('1988-05-30', 'Spring bank holiday', 'england-and-wales', NULL),
('1988-05-30', 'Spring bank holiday', 'scotland', NULL),
('1988-05-30', 'Spring bank holiday', 'northern-ireland', NULL),
('1988-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('1988-08-01', 'Summer bank holiday', 'scotland', NULL),
('1988-08-29', 'Summer bank holiday', 'england-and-wales', NULL),
('1988-08-29', 'Summer bank holiday', 'northern-ireland', NULL),
('1988-11-30', 'St Andrew''s Day', 'scotland', NULL),
('1988-12-26', 'Boxing Day', 'england-and-wales', NULL),
('1988-12-26', 'Boxing Day', 'scotland', NULL),
('1988-12-26', 'Boxing Day', 'northern-ireland', NULL),
('1988-12-27', 'Christmas Day', 'england-and-wales', 'Substitute Day'),
('1988-12-27', 'Christmas Day', 'scotland', 'Substitute Day'),
('1988-12-27', 'Christmas Day', 'northern-ireland', 'Substitute Day'),
('1989-01-02', 'New Year''s Day', 'england-and-wales', 'Substitute Day'),
('1989-01-02', 'New Year''s Day', 'northern-ireland', 'Substitute Day'),
('1989-01-02', '2nd January', 'scotland', NULL),
('1989-01-03', 'New Year''s Day', 'scotland', 'Substitute Day'),
('1989-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1989-04-24', 'Good Friday', 'england-and-wales', NULL),
('1989-04-24', 'Good Friday', 'scotland', NULL),
('1989-04-24', 'Good Friday', 'northern-ireland', NULL),
('1989-04-27', 'Easter Monday', 'england-and-wales', NULL),
('1989-04-27', 'Easter Monday', 'northern-ireland', NULL),
('1989-05-01', 'Early May bank holiday', 'england-and-wales', NULL),
('1989-05-01', 'Early May bank holiday', 'scotland', NULL),
('1989-05-01', 'Early May bank holiday', 'northern-ireland', NULL),
('1989-05-29', 'Spring bank holiday', 'england-and-wales', NULL),
('1989-05-29', 'Spring bank holiday', 'scotland', NULL),
('1989-05-29', 'Spring bank holiday', 'northern-ireland', NULL),
('1989-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('1989-08-07', 'Summer bank holiday', 'scotland', NULL),
('1989-08-28', 'Summer bank holiday', 'england-and-wales', NULL),
('1989-08-28', 'Summer bank holiday', 'northern-ireland', NULL),
('1989-11-30', 'St Andrew''s Day', 'scotland', NULL),
('1989-12-25', 'Christmas Day', 'england-and-wales', NULL),
('1989-12-25', 'Christmas Day', 'scotland', NULL),
('1989-12-25', 'Christmas Day', 'northern-ireland', NULL),
('1989-12-26', 'Boxing Day', 'england-and-wales', NULL),
('1989-12-26', 'Boxing Day', 'scotland', NULL),
('1989-12-26', 'Boxing Day', 'northern-ireland', NULL),
('1990-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1990-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1990-01-01', 'New Year''s Day', 'scotland', NULL),
('1990-01-02', '2nd January', 'scotland', NULL),
('1990-03-19', 'St Patrick''s Day', 'northern-ireland', 'Substitute Day'),
('1990-04-13', 'Good Friday', 'england-and-wales', NULL),
('1990-04-13', 'Good Friday', 'scotland', NULL),
('1990-04-13', 'Good Friday', 'northern-ireland', NULL),
('1990-04-16', 'Easter Monday', 'england-and-wales', NULL),
('1990-04-16', 'Easter Monday', 'northern-ireland', NULL),
('1990-05-07', 'Early May bank holiday', 'england-and-wales', NULL),
('1990-05-07', 'Early May bank holiday', 'scotland', NULL),
('1990-05-07', 'Early May bank holiday', 'northern-ireland', NULL),
('1990-05-28', 'Spring bank holiday', 'england-and-wales', NULL),
('1990-05-28', 'Spring bank holiday', 'scotland', NULL),
('1990-05-28', 'Spring bank holiday', 'northern-ireland', NULL),
('1990-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('1990-08-06', 'Summer bank holiday', 'scotland', NULL),
('1990-08-27', 'Summer bank holiday', 'england-and-wales', NULL),
('1990-08-27', 'Summer bank holiday', 'northern-ireland', NULL),
('1990-11-30', 'St Andrew''s Day', 'scotland', NULL),
('1990-12-25', 'Christmas Day', 'england-and-wales', NULL),
('1990-12-25', 'Christmas Day', 'scotland', NULL),
('1990-12-25', 'Christmas Day', 'northern-ireland', NULL),
('1990-12-26', 'Boxing Day', 'england-and-wales', NULL),
('1990-12-26', 'Boxing Day', 'scotland', NULL),
('1990-12-26', 'Boxing Day', 'northern-ireland', NULL),
('1991-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1991-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1991-01-01', 'New Year''s Day', 'scotland', NULL),
('1991-01-02', '2nd January', 'scotland', NULL),
('1991-03-18', 'St Patrick''s Day', 'northern-ireland', 'Substitute Day'),
('1991-03-29', 'Good Friday', 'england-and-wales', NULL),
('1991-03-29', 'Good Friday', 'scotland', NULL),
('1991-03-29', 'Good Friday', 'northern-ireland', NULL),
('1991-04-01', 'Easter Monday', 'england-and-wales', NULL),
('1991-04-01', 'Easter Monday', 'northern-ireland', NULL),
('1991-05-06', 'Early May bank holiday', 'england-and-wales', NULL),
('1991-05-06', 'Early May bank holiday', 'scotland', NULL),
('1991-05-06', 'Early May bank holiday', 'northern-ireland', NULL),
('1991-05-27', 'Spring bank holiday', 'england-and-wales', NULL),
('1991-05-27', 'Spring bank holiday', 'scotland', NULL),
('1991-05-27', 'Spring bank holiday', 'northern-ireland', NULL),
('1991-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('1991-08-05', 'Summer bank holiday', 'scotland', NULL),
('1991-08-26', 'Summer bank holiday', 'england-and-wales', NULL),
('1991-08-26', 'Summer bank holiday', 'northern-ireland', NULL),
('1991-12-02', 'St Andrew''s Day', 'scotland', 'Substitute Day'),
('1991-12-25', 'Christmas Day', 'england-and-wales', NULL),
('1991-12-25', 'Christmas Day', 'scotland', NULL),
('1991-12-25', 'Christmas Day', 'northern-ireland', NULL),
('1991-12-26', 'Boxing Day', 'england-and-wales', NULL),
('1991-12-26', 'Boxing Day', 'scotland', NULL),
('1991-12-26', 'Boxing Day', 'northern-ireland', NULL),
('1992-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1992-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1992-01-01', 'New Year''s Day', 'scotland', NULL),
('1992-01-02', '2nd January', 'scotland', NULL),
('1992-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1992-04-17', 'Good Friday', 'england-and-wales', NULL),
('1992-04-17', 'Good Friday', 'scotland', NULL),
('1992-04-17', 'Good Friday', 'northern-ireland', NULL),
('1992-04-20', 'Easter Monday', 'england-and-wales', NULL),
('1992-04-20', 'Easter Monday', 'northern-ireland', NULL),
('1992-05-04', 'Early May bank holiday', 'england-and-wales', NULL),
('1992-05-04', 'Early May bank holiday', 'scotland', NULL),
('1992-05-04', 'Early May bank holiday', 'northern-ireland', NULL),
('1992-05-25', 'Spring bank holiday', 'england-and-wales', NULL),
('1992-05-25', 'Spring bank holiday', 'scotland', NULL),
('1992-05-25', 'Spring bank holiday', 'northern-ireland', NULL),
('1992-07-13', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', 'Substitute Day'),
('1992-08-03', 'Summer bank holiday', 'scotland', NULL),
('1992-08-31', 'Summer bank holiday', 'england-and-wales', NULL),
('1992-08-31', 'Summer bank holiday', 'northern-ireland', NULL),
('1992-11-30', 'St Andrew''s Day', 'scotland', NULL),
('1992-12-25', 'Christmas Day', 'england-and-wales', NULL),
('1992-12-25', 'Christmas Day', 'scotland', NULL),
('1992-12-25', 'Christmas Day', 'northern-ireland', NULL),
('1992-12-28', 'Boxing Day', 'england-and-wales', 'Substitute Day'),
('1992-12-28', 'Boxing Day', 'scotland', 'Substitute Day'),
('1992-12-28', 'Boxing Day', 'northern-ireland', 'Substitute Day'),
('1993-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1993-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1993-01-01', 'New Year''s Day', 'scotland', NULL),
('1993-01-04', '2nd January', 'scotland', 'Substitute Day'),
('1993-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1993-04-09', 'Good Friday', 'england-and-wales', NULL),
('1993-04-09', 'Good Friday', 'scotland', NULL),
('1993-04-09', 'Good Friday', 'northern-ireland', NULL),
('1993-04-12', 'Easter Monday', 'england-and-wales', NULL),
('1993-04-12', 'Easter Monday', 'northern-ireland', NULL),
('1993-05-03', 'Early May bank holiday', 'england-and-wales', NULL),
('1993-05-03', 'Early May bank holiday', 'scotland', NULL),
('1993-05-03', 'Early May bank holiday', 'northern-ireland', NULL),
('1993-05-31', 'Spring bank holiday', 'england-and-wales', NULL),
('1993-05-31', 'Spring bank holiday', 'scotland', NULL),
('1993-05-31', 'Spring bank holiday', 'northern-ireland', NULL),
('1993-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('1993-08-02', 'Summer bank holiday', 'scotland', NULL),
('1993-08-30', 'Summer bank holiday', 'england-and-wales', NULL),
('1993-08-30', 'Summer bank holiday', 'northern-ireland', NULL),
('1993-11-30', 'St Andrew''s Day', 'scotland', NULL),
('1993-12-27', 'Christmas Day', 'england-and-wales', 'Substitute Day'),
('1993-12-27', 'Christmas Day', 'scotland', 'Substitute Day'),
('1993-12-27', 'Christmas Day', 'northern-ireland', 'Substitute Day'),
('1993-12-28', 'Boxing Day', 'england-and-wales', 'Substitute Day'),
('1993-12-28', 'Boxing Day', 'scotland', 'Substitute Day'),
('1993-12-28', 'Boxing Day', 'northern-ireland', 'Substitute Day'),
('1994-01-03', 'New Year''s Day', 'england-and-wales', 'Substitute Day'),
('1994-01-03', 'New Year''s Day', 'northern-ireland', 'Substitute Day'),
('1994-01-03', 'New Year''s Day', 'scotland', 'Substitute Day'),
('1994-01-04', '2nd January', 'scotland', 'Substitute Day'),
('1994-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1994-04-01', 'Good Friday', 'england-and-wales', NULL),
('1994-04-01', 'Good Friday', 'scotland', NULL),
('1994-04-01', 'Good Friday', 'northern-ireland', NULL),
('1994-04-04', 'Easter Monday', 'england-and-wales', NULL),
('1994-04-04', 'Easter Monday', 'northern-ireland', NULL),
('1994-05-02', 'Early May bank holiday', 'england-and-wales', NULL),
('1994-05-02', 'Early May bank holiday', 'scotland', NULL),
('1994-05-02', 'Early May bank holiday', 'northern-ireland', NULL),
('1994-05-30', 'Spring bank holiday', 'england-and-wales', NULL),
('1994-05-30', 'Spring bank holiday', 'scotland', NULL),
('1994-05-30', 'Spring bank holiday', 'northern-ireland', NULL),
('1994-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('1994-08-01', 'Summer bank holiday', 'scotland', NULL),
('1994-08-29', 'Summer bank holiday', 'england-and-wales', NULL),
('1994-08-29', 'Summer bank holiday', 'northern-ireland', NULL),
('1994-11-30', 'St Andrew''s Day', 'scotland', NULL),
('1994-12-26', 'Boxing Day', 'england-and-wales', NULL),
('1994-12-26', 'Boxing Day', 'scotland', NULL),
('1994-12-26', 'Boxing Day', 'northern-ireland', NULL),
('1994-12-27', 'Christmas Day', 'england-and-wales', 'Substitute Day'),
('1994-12-27', 'Christmas Day', 'scotland', 'Substitute Day'),
('1994-12-27', 'Christmas Day', 'northern-ireland', 'Substitute Day'),
('1995-01-02', 'New Year''s Day', 'england-and-wales', 'Substitute Day'),
('1995-01-02', 'New Year''s Day', 'northern-ireland', 'Substitute Day'),
('1995-01-02', '2nd January', 'scotland', NULL),
('1995-01-03', 'New Year''s Day', 'scotland', 'Substitute Day'),
('1995-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1995-04-14', 'Good Friday', 'england-and-wales', NULL),
('1995-04-14', 'Good Friday', 'scotland', NULL),
('1995-04-14', 'Good Friday', 'northern-ireland', NULL),
('1995-04-17', 'Easter Monday', 'england-and-wales', NULL),
('1995-04-17', 'Easter Monday', 'northern-ireland', NULL),
('1995-05-08', 'Early May bank holiday', 'england-and-wales', NULL),
('1995-05-08', 'Early May bank holiday', 'scotland', NULL),
('1995-05-08', 'Early May bank holiday', 'northern-ireland', NULL),
('1995-05-29', 'Spring bank holiday', 'england-and-wales', NULL),
('1995-05-29', 'Spring bank holiday', 'scotland', NULL),
('1995-05-29', 'Spring bank holiday', 'northern-ireland', NULL),
('1995-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('1995-08-07', 'Summer bank holiday', 'scotland', NULL),
('1995-08-28', 'Summer bank holiday', 'england-and-wales', NULL),
('1995-08-28', 'Summer bank holiday', 'northern-ireland', NULL),
('1995-11-30', 'St Andrew''s Day', 'scotland', NULL),
('1995-12-25', 'Christmas Day', 'england-and-wales', NULL),
('1995-12-25', 'Christmas Day', 'scotland', NULL),
('1995-12-25', 'Christmas Day', 'northern-ireland', NULL),
('1995-12-26', 'Boxing Day', 'england-and-wales', NULL),
('1995-12-26', 'Boxing Day', 'scotland', NULL),
('1995-12-26', 'Boxing Day', 'northern-ireland', NULL),
('1996-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1996-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1996-01-01', 'New Year''s Day', 'scotland', NULL),
('1996-01-02', '2nd January', 'scotland', NULL),
('1996-03-18', 'St Patrick''s Day', 'northern-ireland', 'Substitute Day'),
('1996-04-05', 'Good Friday', 'england-and-wales', NULL),
('1996-04-05', 'Good Friday', 'scotland', NULL),
('1996-04-05', 'Good Friday', 'northern-ireland', NULL),
('1996-04-08', 'Easter Monday', 'england-and-wales', NULL),
('1996-04-08', 'Easter Monday', 'northern-ireland', NULL),
('1996-05-06', 'Early May bank holiday', 'england-and-wales', NULL),
('1996-05-06', 'Early May bank holiday', 'scotland', NULL),
('1996-05-06', 'Early May bank holiday', 'northern-ireland', NULL),
('1996-05-27', 'Spring bank holiday', 'england-and-wales', NULL),
('1996-05-27', 'Spring bank holiday', 'scotland', NULL),
('1996-05-27', 'Spring bank holiday', 'northern-ireland', NULL),
('1996-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('1996-08-05', 'Summer bank holiday', 'scotland', NULL),
('1996-08-26', 'Summer bank holiday', 'england-and-wales', NULL),
('1996-08-26', 'Summer bank holiday', 'northern-ireland', NULL),
('1996-12-02', 'St Andrew''s Day', 'scotland', 'Substitute Day'),
('1996-12-25', 'Christmas Day', 'england-and-wales', NULL),
('1996-12-25', 'Christmas Day', 'scotland', NULL),
('1996-12-25', 'Christmas Day', 'northern-ireland', NULL),
('1996-12-26', 'Boxing Day', 'england-and-wales', NULL),
('1996-12-26', 'Boxing Day', 'scotland', NULL),
('1996-12-26', 'Boxing Day', 'northern-ireland', NULL),
('1997-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1997-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1997-01-01', 'New Year''s Day', 'scotland', NULL),
('1997-01-02', '2nd January', 'scotland', NULL),
('1997-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1997-03-28', 'Good Friday', 'england-and-wales', NULL),
('1997-03-28', 'Good Friday', 'scotland', NULL),
('1997-03-28', 'Good Friday', 'northern-ireland', NULL),
('1997-03-31', 'Easter Monday', 'england-and-wales', NULL),
('1997-03-31', 'Easter Monday', 'northern-ireland', NULL),
('1997-05-05', 'Early May bank holiday', 'england-and-wales', NULL),
('1997-05-05', 'Early May bank holiday', 'scotland', NULL),
('1997-05-05', 'Early May bank holiday', 'northern-ireland', NULL),
('1997-05-26', 'Spring bank holiday', 'england-and-wales', NULL),
('1997-05-26', 'Spring bank holiday', 'scotland', NULL),
('1997-05-26', 'Spring bank holiday', 'northern-ireland', NULL),
('1997-07-14', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', 'Substitute Day'),
('1997-08-04', 'Summer bank holiday', 'scotland', NULL),
('1997-08-25', 'Summer bank holiday', 'england-and-wales', NULL),
('1997-08-25', 'Summer bank holiday', 'northern-ireland', NULL),
('1997-12-01', 'St Andrew''s Day', 'scotland', 'Substitute Day'),
('1997-12-25', 'Christmas Day', 'england-and-wales', NULL),
('1997-12-25', 'Christmas Day', 'scotland', NULL),
('1997-12-25', 'Christmas Day', 'northern-ireland', NULL),
('1997-12-26', 'Boxing Day', 'england-and-wales', NULL),
('1997-12-26', 'Boxing Day', 'scotland', NULL),
('1997-12-26', 'Boxing Day', 'northern-ireland', NULL),
('1998-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1998-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1998-01-01', 'New Year''s Day', 'scotland', NULL),
('1998-01-02', '2nd January', 'scotland', NULL),
('1998-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1998-04-10', 'Good Friday', 'england-and-wales', NULL),
('1998-04-10', 'Good Friday', 'scotland', NULL),
('1998-04-10', 'Good Friday', 'northern-ireland', NULL),
('1998-04-13', 'Easter Monday', 'england-and-wales', NULL),
('1998-04-13', 'Easter Monday', 'northern-ireland', NULL),
('1998-05-04', 'Early May bank holiday', 'england-and-wales', NULL),
('1998-05-04', 'Early May bank holiday', 'scotland', NULL),
('1998-05-04', 'Early May bank holiday', 'northern-ireland', NULL),
('1998-05-25', 'Spring bank holiday', 'england-and-wales', NULL),
('1998-05-25', 'Spring bank holiday', 'scotland', NULL),
('1998-05-25', 'Spring bank holiday', 'northern-ireland', NULL),
('1998-07-13', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', 'Substitute Day'),
('1998-08-03', 'Summer bank holiday', 'scotland', NULL),
('1998-08-31', 'Summer bank holiday', 'england-and-wales', NULL),
('1998-08-31', 'Summer bank holiday', 'northern-ireland', NULL),
('1998-11-30', 'St Andrew''s Day', 'scotland', NULL),
('1998-12-25', 'Christmas Day', 'england-and-wales', NULL),
('1998-12-25', 'Christmas Day', 'scotland', NULL),
('1998-12-25', 'Christmas Day', 'northern-ireland', NULL),
('1998-12-28', 'Boxing Day', 'england-and-wales', 'Substitute Day'),
('1998-12-28', 'Boxing Day', 'scotland', 'Substitute Day'),
('1998-12-28', 'Boxing Day', 'northern-ireland', 'Substitute Day'),
('1999-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('1999-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('1999-01-01', 'New Year''s Day', 'scotland', NULL),
('1999-01-04', '2nd January', 'scotland', 'Substitute Day'),
('1999-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('1999-04-02', 'Good Friday', 'england-and-wales', NULL),
('1999-04-02', 'Good Friday', 'scotland', NULL),
('1999-04-02', 'Good Friday', 'northern-ireland', NULL),
('1999-04-05', 'Easter Monday', 'england-and-wales', NULL),
('1999-04-05', 'Easter Monday', 'northern-ireland', NULL),
('1999-05-03', 'Early May bank holiday', 'england-and-wales', NULL),
('1999-05-03', 'Early May bank holiday', 'scotland', NULL),
('1999-05-03', 'Early May bank holiday', 'northern-ireland', NULL),
('1999-05-31', 'Spring bank holiday', 'england-and-wales', NULL),
('1999-05-31', 'Spring bank holiday', 'scotland', NULL),
('1999-05-31', 'Spring bank holiday', 'northern-ireland', NULL),
('1999-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('1999-08-02', 'Summer bank holiday', 'scotland', NULL),
('1999-08-30', 'Summer bank holiday', 'england-and-wales', NULL),
('1999-08-30', 'Summer bank holiday', 'northern-ireland', NULL),
('1999-11-30', 'St Andrew''s Day', 'scotland', NULL),
('1999-12-27', 'Christmas Day', 'england-and-wales', 'Substitute Day'),
('1999-12-27', 'Christmas Day', 'scotland', 'Substitute Day'),
('1999-12-27', 'Christmas Day', 'northern-ireland', 'Substitute Day'),
('1999-12-28', 'Boxing Day', 'england-and-wales', 'Substitute Day'),
('1999-12-28', 'Boxing Day', 'scotland', 'Substitute Day'),
('1999-12-28', 'Boxing Day', 'northern-ireland', 'Substitute Day'),
('1999-12-31', 'The Millennium celebrations bank holiday', 'england-and-wales', NULL),
('1999-12-31', 'The Millennium celebrations bank holiday', 'scotland', NULL),
('1999-12-31', 'The Millennium celebrations bank holiday', 'northern-ireland', NULL),
('2000-01-03', 'New Year''s Day', 'england-and-wales', 'Substitute Day'),
('2000-01-03', 'New Year''s Day', 'northern-ireland', 'Substitute Day'),
('2000-01-03', 'New Year''s Day', 'scotland', 'Substitute Day'),
('2000-01-04', '2nd January', 'scotland', 'Substitute Day'),
('2000-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2000-04-21', 'Good Friday', 'england-and-wales', NULL),
('2000-04-21', 'Good Friday', 'scotland', NULL),
('2000-04-21', 'Good Friday', 'northern-ireland', NULL),
('2000-04-24', 'Easter Monday', 'england-and-wales', NULL),
('2000-04-24', 'Easter Monday', 'northern-ireland', NULL),
('2000-05-01', 'Early May bank holiday', 'england-and-wales', NULL),
('2000-05-01', 'Early May bank holiday', 'scotland', NULL),
('2000-05-01', 'Early May bank holiday', 'northern-ireland', NULL),
('2000-05-29', 'Spring bank holiday', 'england-and-wales', NULL),
('2000-05-29', 'Spring bank holiday', 'scotland', NULL),
('2000-05-29', 'Spring bank holiday', 'northern-ireland', NULL),
('2000-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2000-08-07', 'Summer bank holiday', 'scotland', NULL),
('2000-08-28', 'Summer bank holiday', 'england-and-wales', NULL),
('2000-08-28', 'Summer bank holiday', 'northern-ireland', NULL),
('2000-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2000-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2000-12-25', 'Christmas Day', 'scotland', NULL),
('2000-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2000-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2000-12-26', 'Boxing Day', 'scotland', NULL),
('2000-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2001-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2001-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2001-01-01', 'New Year''s Day', 'scotland', NULL),
('2001-01-02', '2nd January', 'scotland', NULL),
('2001-03-19', 'St Patrick''s Day', 'northern-ireland', 'Substitute Day'),
('2001-04-13', 'Good Friday', 'england-and-wales', NULL),
('2001-04-13', 'Good Friday', 'scotland', NULL),
('2001-04-13', 'Good Friday', 'northern-ireland', NULL),
('2001-04-16', 'Easter Monday', 'england-and-wales', NULL),
('2001-04-16', 'Easter Monday', 'northern-ireland', NULL),
('2001-05-07', 'Early May bank holiday', 'england-and-wales', NULL),
('2001-05-07', 'Early May bank holiday', 'scotland', NULL),
('2001-05-07', 'Early May bank holiday', 'northern-ireland', NULL),
('2001-05-28', 'Spring bank holiday', 'england-and-wales', NULL),
('2001-05-28', 'Spring bank holiday', 'scotland', NULL),
('2001-05-28', 'Spring bank holiday', 'northern-ireland', NULL),
('2001-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2001-08-06', 'Summer bank holiday', 'scotland', NULL),
('2001-08-27', 'Summer bank holiday', 'england-and-wales', NULL),
('2001-08-27', 'Summer bank holiday', 'northern-ireland', NULL),
('2001-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2001-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2001-12-25', 'Christmas Day', 'scotland', NULL),
('2001-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2001-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2001-12-26', 'Boxing Day', 'scotland', NULL),
('2001-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2002-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2002-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2002-01-01', 'New Year''s Day', 'scotland', NULL),
('2002-01-02', '2nd January', 'scotland', NULL),
('2002-03-18', 'St Patrick''s Day', 'northern-ireland', 'Substitute Day'),
('2002-03-29', 'Good Friday', 'england-and-wales', NULL),
('2002-03-29', 'Good Friday', 'scotland', NULL),
('2002-03-29', 'Good Friday', 'northern-ireland', NULL),
('2002-04-01', 'Easter Monday', 'england-and-wales', NULL),
('2002-04-01', 'Easter Monday', 'northern-ireland', NULL),
('2002-05-06', 'Early May bank holiday', 'england-and-wales', NULL),
('2002-05-06', 'Early May bank holiday', 'scotland', NULL),
('2002-05-06', 'Early May bank holiday', 'northern-ireland', NULL),
('2002-06-03', 'Golden Jubilee of Elizabeth II', 'england-and-wales', NULL),
('2002-06-03', 'Golden Jubilee of Elizabeth II', 'scotland', NULL),
('2002-06-03', 'Golden Jubilee of Elizabeth II', 'northern-ireland', NULL),
('2002-06-04', 'Spring bank Holiday', 'england-and-wales', NULL),
('2002-06-04', 'Spring bank Holiday', 'scotland', NULL),
('2002-06-04', 'Spring bank Holiday', 'northern-ireland', NULL),
('2002-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2002-08-05', 'Summer bank holiday', 'scotland', NULL),
('2002-08-26', 'Summer bank holiday', 'england-and-wales', NULL),
('2002-08-26', 'Summer bank holiday', 'northern-ireland', NULL),
('2002-12-02', 'St Andrew''s Day', 'scotland', 'Substitute Day'),
('2002-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2002-12-25', 'Christmas Day', 'scotland', NULL),
('2002-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2002-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2002-12-26', 'Boxing Day', 'scotland', NULL),
('2002-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2003-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2003-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2003-01-01', 'New Year''s Day', 'scotland', NULL),
('2003-01-02', '2nd January', 'scotland', NULL),
('2003-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2003-04-18', 'Good Friday', 'england-and-wales', NULL),
('2003-04-18', 'Good Friday', 'scotland', NULL),
('2003-04-18', 'Good Friday', 'northern-ireland', NULL),
('2003-04-21', 'Easter Monday', 'england-and-wales', NULL),
('2003-04-21', 'Easter Monday', 'northern-ireland', NULL),
('2003-05-05', 'Early May bank holiday', 'england-and-wales', NULL),
('2003-05-05', 'Early May bank holiday', 'scotland', NULL),
('2003-05-05', 'Early May bank holiday', 'northern-ireland', NULL),
('2003-05-26', 'Spring bank Holiday', 'england-and-wales', NULL),
('2003-05-26', 'Spring bank Holiday', 'scotland', NULL),
('2003-05-26', 'Spring bank Holiday', 'northern-ireland', NULL),
('2003-07-14', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', 'Substitute Day'),
('2003-08-04', 'Summer bank holiday', 'scotland', NULL),
('2003-08-25', 'Summer bank holiday', 'england-and-wales', NULL),
('2003-08-25', 'Summer bank holiday', 'northern-ireland', NULL),
('2003-12-01', 'St Andrew''s Day', 'scotland', 'Substitute Day'),
('2003-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2003-12-25', 'Christmas Day', 'scotland', NULL),
('2003-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2003-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2003-12-26', 'Boxing Day', 'scotland', NULL),
('2003-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2004-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2004-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2004-01-01', 'New Year''s Day', 'scotland', NULL),
('2004-01-02', '2nd January', 'scotland', NULL),
('2004-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2004-04-09', 'Good Friday', 'england-and-wales', NULL),
('2004-04-09', 'Good Friday', 'scotland', NULL),
('2004-04-09', 'Good Friday', 'northern-ireland', NULL),
('2004-04-12', 'Easter Monday', 'england-and-wales', NULL),
('2004-04-12', 'Easter Monday', 'northern-ireland', NULL),
('2004-05-03', 'Early May bank holiday', 'england-and-wales', NULL),
('2004-05-03', 'Early May bank holiday', 'scotland', NULL),
('2004-05-03', 'Early May bank holiday', 'northern-ireland', NULL),
('2004-05-31', 'Spring bank Holiday', 'england-and-wales', NULL),
('2004-05-31', 'Spring bank Holiday', 'scotland', NULL),
('2004-05-31', 'Spring bank Holiday', 'northern-ireland', NULL),
('2004-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2004-08-02', 'Summer bank holiday', 'scotland', NULL),
('2004-08-30', 'Summer bank holiday', 'england-and-wales', NULL),
('2004-08-30', 'Summer bank holiday', 'northern-ireland', NULL),
('2004-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2004-12-27', 'Christmas Day', 'england-and-wales', 'Substitute Day'),
('2004-12-27', 'Christmas Day', 'scotland', 'Substitute Day'),
('2004-12-27', 'Christmas Day', 'northern-ireland', 'Substitute Day'),
('2004-12-28', 'Boxing Day', 'england-and-wales', 'Substitute Day'),
('2004-12-28', 'Boxing Day', 'scotland', 'Substitute Day'),
('2004-12-28', 'Boxing Day', 'northern-ireland', 'Substitute Day'),
('2005-01-03', 'New Year''s Day', 'england-and-wales', 'Substitute Day'),
('2005-01-03', 'New Year''s Day', 'northern-ireland', 'Substitute Day'),
('2005-01-03', 'New Year''s Day', 'scotland', 'Substitute Day'),
('2005-01-04', '2nd January', 'scotland', 'Substitute Day'),
('2005-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2005-03-25', 'Good Friday', 'england-and-wales', NULL),
('2005-03-25', 'Good Friday', 'scotland', NULL),
('2005-03-25', 'Good Friday', 'northern-ireland', NULL),
('2005-03-28', 'Easter Monday', 'england-and-wales', NULL),
('2005-03-28', 'Easter Monday', 'northern-ireland', NULL),
('2005-05-02', 'Early May bank holiday', 'england-and-wales', NULL),
('2005-05-02', 'Early May bank holiday', 'scotland', NULL),
('2005-05-02', 'Early May bank holiday', 'northern-ireland', NULL),
('2005-05-30', 'Spring bank Holiday', 'england-and-wales', NULL),
('2005-05-30', 'Spring bank Holiday', 'scotland', NULL),
('2005-05-30', 'Spring bank Holiday', 'northern-ireland', NULL),
('2005-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2005-08-02', 'Summer bank holiday', 'scotland', NULL),
('2005-08-30', 'Summer bank holiday', 'england-and-wales', NULL),
('2005-08-30', 'Summer bank holiday', 'northern-ireland', NULL),
('2005-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2005-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2005-12-26', 'Boxing Day', 'scotland', NULL),
('2005-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2005-12-27', 'Christmas Day', 'england-and-wales', 'Substitute Day'),
('2005-12-27', 'Christmas Day', 'scotland', 'Substitute Day'),
('2005-12-27', 'Christmas Day', 'northern-ireland', 'Substitute Day'),
('2006-01-02', 'New Year''s Day', 'england-and-wales', 'Substitute Day'),
('2006-01-02', 'New Year''s Day', 'northern-ireland', 'Substitute Day'),
('2006-01-02', '2nd January', 'scotland', NULL),
('2006-01-03', 'New Year''s Day', 'scotland', 'Substitute Day'),
('2006-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2006-04-14', 'Good Friday', 'england-and-wales', NULL),
('2006-04-14', 'Good Friday', 'scotland', NULL),
('2006-04-14', 'Good Friday', 'northern-ireland', NULL),
('2006-04-17', 'Easter Monday', 'england-and-wales', NULL),
('2006-04-17', 'Easter Monday', 'northern-ireland', NULL),
('2006-05-01', 'Early May bank holiday', 'england-and-wales', NULL),
('2006-05-01', 'Early May bank holiday', 'scotland', NULL),
('2006-05-01', 'Early May bank holiday', 'northern-ireland', NULL),
('2006-05-29', 'Spring bank Holiday', 'england-and-wales', NULL),
('2006-05-29', 'Spring bank Holiday', 'scotland', NULL),
('2006-05-29', 'Spring bank Holiday', 'northern-ireland', NULL),
('2006-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2006-08-07', 'Summer bank holiday', 'scotland', NULL),
('2006-08-28', 'Summer bank holiday', 'england-and-wales', NULL),
('2006-08-28', 'Summer bank holiday', 'northern-ireland', NULL),
('2006-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2006-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2006-12-25', 'Christmas Day', 'scotland', NULL),
('2006-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2006-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2006-12-26', 'Boxing Day', 'scotland', NULL),
('2006-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2007-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2007-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2007-01-01', 'New Year''s Day', 'scotland', NULL),
('2007-01-02', '2nd January', 'scotland', NULL),
('2007-03-19', 'St Patrick''s Day', 'northern-ireland', 'Substitute Day'),
('2007-04-06', 'Good Friday', 'england-and-wales', NULL),
('2007-04-06', 'Good Friday', 'scotland', NULL),
('2007-04-06', 'Good Friday', 'northern-ireland', NULL),
('2007-04-09', 'Easter Monday', 'england-and-wales', NULL),
('2007-04-09', 'Easter Monday', 'northern-ireland', NULL),
('2007-05-07', 'Early May bank holiday', 'england-and-wales', NULL),
('2007-05-07', 'Early May bank holiday', 'scotland', NULL),
('2007-05-07', 'Early May bank holiday', 'northern-ireland', NULL),
('2007-05-28', 'Spring bank Holiday', 'england-and-wales', NULL),
('2007-05-28', 'Spring bank Holiday', 'scotland', NULL),
('2007-05-28', 'Spring bank Holiday', 'northern-ireland', NULL),
('2007-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2007-08-06', 'Summer bank holiday', 'scotland', NULL),
('2007-08-27', 'Summer bank holiday', 'england-and-wales', NULL),
('2007-08-27', 'Summer bank holiday', 'northern-ireland', NULL),
('2007-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2007-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2007-12-25', 'Christmas Day', 'scotland', NULL),
('2007-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2007-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2007-12-26', 'Boxing Day', 'scotland', NULL),
('2007-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2008-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2008-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2008-01-01', 'New Year''s Day', 'scotland', NULL),
('2008-01-02', '2nd January', 'scotland', NULL),
('2008-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2008-03-21', 'Good Friday', 'england-and-wales', NULL),
('2008-03-21', 'Good Friday', 'scotland', NULL),
('2008-03-21', 'Good Friday', 'northern-ireland', NULL),
('2008-03-24', 'Easter Monday', 'england-and-wales', NULL),
('2008-03-24', 'Easter Monday', 'northern-ireland', NULL),
('2008-05-05', 'Early May bank holiday', 'england-and-wales', NULL),
('2008-05-05', 'Early May bank holiday', 'scotland', NULL),
('2008-05-05', 'Early May bank holiday', 'northern-ireland', NULL),
('2008-05-26', 'Spring bank Holiday', 'england-and-wales', NULL),
('2008-05-26', 'Spring bank Holiday', 'scotland', NULL),
('2008-05-26', 'Spring bank Holiday', 'northern-ireland', NULL),
('2008-07-14', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', 'Substitute Day'),
('2008-08-04', 'Summer bank holiday', 'scotland', NULL),
('2008-08-25', 'Summer bank holiday', 'england-and-wales', NULL),
('2008-08-25', 'Summer bank holiday', 'northern-ireland', NULL),
('2008-12-01', 'St Andrew''s Day', 'scotland', 'Substitute Day'),
('2008-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2008-12-25', 'Christmas Day', 'scotland', NULL),
('2008-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2008-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2008-12-26', 'Boxing Day', 'scotland', NULL),
('2008-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2009-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2009-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2009-01-01', 'New Year''s Day', 'scotland', NULL),
('2009-01-02', '2nd January', 'scotland', NULL),
('2009-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2009-04-10', 'Good Friday', 'england-and-wales', NULL),
('2009-04-10', 'Good Friday', 'scotland', NULL),
('2009-04-10', 'Good Friday', 'northern-ireland', NULL),
('2009-04-13', 'Easter Monday', 'england-and-wales', NULL),
('2009-04-13', 'Easter Monday', 'northern-ireland', NULL),
('2009-05-04', 'Early May bank holiday', 'england-and-wales', NULL),
('2009-05-04', 'Early May bank holiday', 'scotland', NULL),
('2009-05-04', 'Early May bank holiday', 'northern-ireland', NULL),
('2009-05-25', 'Spring bank Holiday', 'england-and-wales', NULL),
('2009-05-25', 'Spring bank Holiday', 'scotland', NULL),
('2009-05-25', 'Spring bank Holiday', 'northern-ireland', NULL),
('2009-07-13', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', 'Substitute Day'),
('2009-08-03', 'Summer bank holiday', 'scotland', NULL),
('2009-08-31', 'Summer bank holiday', 'england-and-wales', NULL),
('2009-08-31', 'Summer bank holiday', 'northern-ireland', NULL),
('2009-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2009-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2009-12-25', 'Christmas Day', 'scotland', NULL),
('2009-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2009-12-28', 'Boxing Day', 'england-and-wales', 'Substitute Day'),
('2009-12-28', 'Boxing Day', 'scotland', 'Substitute Day'),
('2009-12-28', 'Boxing Day', 'northern-ireland', 'Substitute Day'),
('2010-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2010-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2010-01-01', 'New Year''s Day', 'scotland', NULL),
('2010-01-04', '2nd January', 'scotland', 'Substitute Day'),
('2010-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2010-04-02', 'Good Friday', 'england-and-wales', NULL),
('2010-04-02', 'Good Friday', 'scotland', NULL),
('2010-04-02', 'Good Friday', 'northern-ireland', NULL),
('2010-04-05', 'Easter Monday', 'england-and-wales', NULL),
('2010-04-05', 'Easter Monday', 'northern-ireland', NULL),
('2010-05-03', 'Early May bank holiday', 'england-and-wales', NULL),
('2010-05-03', 'Early May bank holiday', 'scotland', NULL),
('2010-05-03', 'Early May bank holiday', 'northern-ireland', NULL),
('2010-05-31', 'Spring bank Holiday', 'england-and-wales', NULL),
('2010-05-31', 'Spring bank Holiday', 'scotland', NULL),
('2010-05-31', 'Spring bank Holiday', 'northern-ireland', NULL),
('2010-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2010-08-02', 'Summer bank holiday', 'scotland', NULL),
('2010-08-30', 'Summer bank holiday', 'england-and-wales', NULL),
('2010-08-30', 'Summer bank holiday', 'northern-ireland', NULL),
('2010-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2010-12-27', 'Christmas Day', 'england-and-wales', 'Substitute Day'),
('2010-12-27', 'Christmas Day', 'scotland', 'Substitute Day'),
('2010-12-27', 'Christmas Day', 'northern-ireland', 'Substitute Day'),
('2010-12-28', 'Boxing Day', 'england-and-wales', 'Substitute Day'),
('2010-12-28', 'Boxing Day', 'scotland', 'Substitute Day'),
('2010-12-28', 'Boxing Day', 'northern-ireland', 'Substitute Day'),
('2011-01-03', 'New Year''s Day', 'england-and-wales', 'Substitute Day'),
('2011-01-03', 'New Year''s Day', 'northern-ireland', 'Substitute Day'),
('2011-01-03', 'New Year''s Day', 'scotland', 'Substitute Day'),
('2011-01-04', '2nd January', 'scotland', 'Substitute Day'),
('2011-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2011-04-22', 'Good Friday', 'england-and-wales', NULL),
('2011-04-22', 'Good Friday', 'scotland', NULL),
('2011-04-22', 'Good Friday', 'northern-ireland', NULL),
('2011-04-25', 'Easter Monday', 'england-and-wales', NULL),
('2011-04-25', 'Easter Monday', 'northern-ireland', NULL),
('2011-04-29', 'The wedding of Prince William and Catherine Middleton', 'england-and-wales', NULL),
('2011-04-29', 'The wedding of Prince William and Catherine Middleton', 'scotland', NULL),
('2011-04-29', 'The wedding of Prince William and Catherine Middleton', 'northern-ireland', NULL),
('2011-05-02', 'Early May bank holiday', 'england-and-wales', NULL),
('2011-05-02', 'Early May bank holiday', 'scotland', NULL),
('2011-05-02', 'Early May bank holiday', 'northern-ireland', NULL),
('2011-05-30', 'Spring bank Holiday', 'england-and-wales', NULL),
('2011-05-30', 'Spring bank Holiday', 'scotland', NULL),
('2011-05-30', 'Spring bank Holiday', 'northern-ireland', NULL),
('2011-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2011-08-01', 'Summer bank holiday', 'scotland', NULL),
('2011-08-29', 'Summer bank holiday', 'england-and-wales', NULL),
('2011-08-29', 'Summer bank holiday', 'northern-ireland', NULL),
('2011-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2011-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2011-12-26', 'Boxing Day', 'scotland', NULL),
('2011-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2011-12-27', 'Christmas Day', 'england-and-wales', 'Substitute Day'),
('2011-12-27', 'Christmas Day', 'scotland', 'Substitute Day'),
('2011-12-27', 'Christmas Day', 'northern-ireland', 'Substitute Day'),
('2012-01-02', 'New Year''s Day', 'england-and-wales', 'Substitute Day'),
('2012-01-02', 'New Year''s Day', 'northern-ireland', 'Substitute Day'),
('2012-01-02', '2nd January', 'scotland', NULL),
('2012-01-03', 'New Year''s Day', 'scotland', 'Substitute Day'),
('2012-03-19', 'St Patrick''s Day', 'northern-ireland', 'Substitute Day'),
('2012-04-06', 'Good Friday', 'england-and-wales', NULL),
('2012-04-06', 'Good Friday', 'scotland', NULL),
('2012-04-06', 'Good Friday', 'northern-ireland', NULL),
('2012-04-09', 'Easter Monday', 'england-and-wales', NULL),
('2012-04-09', 'Easter Monday', 'northern-ireland', NULL),
('2012-05-07', 'Early May bank holiday', 'england-and-wales', NULL),
('2012-05-07', 'Early May bank holiday', 'scotland', NULL),
('2012-05-07', 'Early May bank holiday', 'northern-ireland', NULL),
('2012-06-04', 'Spring bank Holiday', 'england-and-wales', NULL),
('2012-06-04', 'Spring bank Holiday', 'scotland', NULL),
('2012-06-04', 'Spring bank Holiday', 'northern-ireland', NULL),
('2012-06-05', 'Diamond Jubilee of Elizabeth II', 'england-and-wales', NULL),
('2012-06-05', 'Diamond Jubilee of Elizabeth II', 'scotland', NULL),
('2012-06-05', 'Diamond Jubilee of Elizabeth II', 'northern-ireland', NULL),
('2012-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2012-08-06', 'Summer bank holiday', 'scotland', NULL),
('2012-08-27', 'Summer bank holiday', 'england-and-wales', NULL),
('2012-08-27', 'Summer bank holiday', 'northern-ireland', NULL),
('2012-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2012-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2012-12-25', 'Christmas Day', 'scotland', NULL),
('2012-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2012-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2012-12-26', 'Boxing Day', 'scotland', NULL),
('2012-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2013-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2013-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2013-01-01', 'New Year''s Day', 'scotland', NULL),
('2013-01-02', '2nd January', 'scotland', NULL),
('2013-03-18', 'St Patrick''s Day', 'northern-ireland', 'Substitute Day'),
('2013-03-29', 'Good Friday', 'england-and-wales', NULL),
('2013-03-29', 'Good Friday', 'scotland', NULL),
('2013-03-29', 'Good Friday', 'northern-ireland', NULL),
('2013-04-01', 'Easter Monday', 'england-and-wales', NULL),
('2013-04-01', 'Easter Monday', 'northern-ireland', NULL),
('2013-05-06', 'Early May bank holiday', 'england-and-wales', NULL),
('2013-05-06', 'Early May bank holiday', 'scotland', NULL),
('2013-05-06', 'Early May bank holiday', 'northern-ireland', NULL),
('2013-05-27', 'Spring bank Holiday', 'england-and-wales', NULL),
('2013-05-27', 'Spring bank Holiday', 'scotland', NULL),
('2013-05-27', 'Spring bank Holiday', 'northern-ireland', NULL),
('2013-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2013-08-05', 'Summer bank holiday', 'scotland', NULL),
('2013-08-26', 'Summer bank holiday', 'england-and-wales', NULL),
('2013-08-26', 'Summer bank holiday', 'northern-ireland', NULL),
('2013-12-02', 'St Andrew''s Day', 'scotland', 'Substitute Day'),
('2013-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2013-12-25', 'Christmas Day', 'scotland', NULL),
('2013-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2013-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2013-12-26', 'Boxing Day', 'scotland', NULL),
('2013-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2014-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2014-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2014-01-01', 'New Year''s Day', 'scotland', NULL),
('2014-01-02', '2nd January', 'scotland', NULL),
('2014-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2014-04-18', 'Good Friday', 'england-and-wales', NULL),
('2014-04-18', 'Good Friday', 'scotland', NULL),
('2014-04-18', 'Good Friday', 'northern-ireland', NULL),
('2014-04-21', 'Easter Monday', 'england-and-wales', NULL),
('2014-04-21', 'Easter Monday', 'northern-ireland', NULL),
('2014-05-05', 'Early May bank holiday', 'england-and-wales', NULL),
('2014-05-05', 'Early May bank holiday', 'scotland', NULL),
('2014-05-05', 'Early May bank holiday', 'northern-ireland', NULL),
('2014-05-26', 'Spring bank Holiday', 'england-and-wales', NULL),
('2014-05-26', 'Spring bank Holiday', 'scotland', NULL),
('2014-05-26', 'Spring bank Holiday', 'northern-ireland', NULL),
('2014-07-14', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', 'Substitute Day'),
('2014-08-04', 'Summer bank holiday', 'scotland', NULL),
('2014-08-25', 'Summer bank holiday', 'england-and-wales', NULL),
('2014-08-25', 'Summer bank holiday', 'northern-ireland', NULL),
('2014-12-01', 'St Andrew''s Day', 'scotland', 'Substitute Day'),
('2014-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2014-12-25', 'Christmas Day', 'scotland', NULL),
('2014-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2014-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2014-12-26', 'Boxing Day', 'scotland', NULL),
('2014-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2015-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2015-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2015-01-01', 'New Year''s Day', 'scotland', NULL),
('2015-01-02', '2nd January', 'scotland', NULL),
('2015-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2015-04-03', 'Good Friday', 'england-and-wales', NULL),
('2015-04-03', 'Good Friday', 'scotland', NULL),
('2015-04-03', 'Good Friday', 'northern-ireland', NULL),
('2015-04-06', 'Easter Monday', 'england-and-wales', NULL),
('2015-04-06', 'Easter Monday', 'northern-ireland', NULL),
('2015-05-04', 'Early May bank holiday', 'england-and-wales', NULL),
('2015-05-04', 'Early May bank holiday', 'scotland', NULL),
('2015-05-04', 'Early May bank holiday', 'northern-ireland', NULL),
('2015-05-25', 'Spring bank Holiday', 'england-and-wales', NULL),
('2015-05-25', 'Spring bank Holiday', 'scotland', NULL),
('2015-05-25', 'Spring bank Holiday', 'northern-ireland', NULL),
('2015-07-13', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', 'Substitute Day'),
('2015-08-03', 'Summer bank holiday', 'scotland', NULL),
('2015-08-31', 'Summer bank holiday', 'england-and-wales', NULL),
('2015-08-31', 'Summer bank holiday', 'northern-ireland', NULL),
('2015-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2015-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2015-12-25', 'Christmas Day', 'scotland', NULL),
('2015-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2015-12-28', 'Boxing Day', 'england-and-wales', 'Substitute Day'),
('2015-12-28', 'Boxing Day', 'scotland', 'Substitute Day'),
('2015-12-28', 'Boxing Day', 'northern-ireland', 'Substitute Day'),
('2016-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2016-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2016-01-01', 'New Year''s Day', 'scotland', NULL),
('2016-01-04', '2nd January', 'scotland', 'Substitute Day'),
('2016-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2016-03-25', 'Good Friday', 'england-and-wales', NULL),
('2016-03-25', 'Good Friday', 'scotland', NULL),
('2016-03-25', 'Good Friday', 'northern-ireland', NULL),
('2016-03-28', 'Easter Monday', 'england-and-wales', NULL),
('2016-03-28', 'Easter Monday', 'northern-ireland', NULL),
('2016-05-02', 'Early May bank holiday', 'england-and-wales', NULL),
('2016-05-02', 'Early May bank holiday', 'scotland', NULL),
('2016-05-02', 'Early May bank holiday', 'northern-ireland', NULL),
('2016-05-30', 'Spring bank Holiday', 'england-and-wales', NULL),
('2016-05-30', 'Spring bank Holiday', 'scotland', NULL),
('2016-05-30', 'Spring bank Holiday', 'northern-ireland', NULL),
('2016-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2016-08-01', 'Summer bank holiday', 'scotland', NULL),
('2016-08-29', 'Summer bank holiday', 'england-and-wales', NULL),
('2016-08-29', 'Summer bank holiday', 'northern-ireland', NULL),
('2016-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2016-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2016-12-26', 'Boxing Day', 'scotland', NULL),
('2016-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2016-12-27', 'Christmas Day', 'england-and-wales', 'Subtitute Day'),
('2016-12-27', 'Christmas Day', 'scotland', 'Subtitute Day'),
('2016-12-27', 'Christmas Day', 'northern-ireland', 'Subtitute Day'),
('2017-01-02', 'New Year''s Day', 'england-and-wales', NULL),
('2017-01-02', 'New Year''s Day', 'northern-ireland', NULL),
('2017-01-02', '2nd January', 'scotland', NULL),
('2017-01-03', 'New Year''s Day', 'scotland', 'Substitute Day'),
('2017-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2017-04-14', 'Good Friday', 'england-and-wales', NULL),
('2017-04-14', 'Good Friday', 'scotland', NULL),
('2017-04-14', 'Good Friday', 'northern-ireland', NULL),
('2017-04-17', 'Easter Monday', 'england-and-wales', NULL),
('2017-04-17', 'Easter Monday', 'northern-ireland', NULL),
('2017-05-01', 'Early May bank holiday', 'england-and-wales', NULL),
('2017-05-01', 'Early May bank holiday', 'scotland', NULL),
('2017-05-01', 'Early May bank holiday', 'northern-ireland', NULL),
('2017-05-29', 'Spring bank Holiday', 'england-and-wales', NULL),
('2017-05-29', 'Spring bank Holiday', 'scotland', NULL),
('2017-05-29', 'Spring bank Holiday', 'northern-ireland', NULL),
('2017-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2017-08-07', 'Summer bank holiday', 'scotland', NULL),
('2017-08-28', 'Summer bank holiday', 'england-and-wales', NULL),
('2017-08-28', 'Summer bank holiday', 'northern-ireland', NULL),
('2017-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2017-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2017-12-25', 'Christmas Day', 'scotland', NULL),
('2017-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2017-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2017-12-26', 'Boxing Day', 'scotland', NULL),
('2017-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2018-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2018-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2018-01-01', 'New Year''s Day', 'scotland', NULL),
('2018-01-02', '2nd January', 'scotland', NULL),
('2018-03-19', 'St Patrick''s Day', 'northern-ireland', 'Substitute Day'),
('2018-03-30', 'Good Friday', 'england-and-wales', NULL),
('2018-03-30', 'Good Friday', 'scotland', NULL),
('2018-03-30', 'Good Friday', 'northern-ireland', NULL),
('2018-04-02', 'Easter Monday', 'england-and-wales', NULL),
('2018-04-02', 'Easter Monday', 'northern-ireland', NULL),
('2018-05-07', 'Early May bank holiday', 'england-and-wales', NULL),
('2018-05-07', 'Early May bank holiday', 'scotland', NULL),
('2018-05-07', 'Early May bank holiday', 'northern-ireland', NULL),
('2018-05-28', 'Spring bank Holiday', 'england-and-wales', NULL),
('2018-05-28', 'Spring bank Holiday', 'scotland', NULL),
('2018-05-28', 'Spring bank Holiday', 'northern-ireland', NULL),
('2018-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2018-08-06', 'Summer bank holiday', 'scotland', NULL),
('2018-08-27', 'Summer bank holiday', 'england-and-wales', NULL),
('2018-08-27', 'Summer bank holiday', 'northern-ireland', NULL),
('2018-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2018-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2018-12-25', 'Christmas Day', 'scotland', NULL),
('2018-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2018-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2018-12-26', 'Boxing Day', 'scotland', NULL),
('2018-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2019-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2019-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2019-01-01', 'New Year''s Day', 'scotland', NULL),
('2019-01-02', '2nd January', 'scotland', NULL),
('2019-03-18', 'St Patrick''s Day', 'northern-ireland', 'Substitute day'),
('2019-03-19', 'Good Friday', 'northern-ireland', NULL),
('2019-03-19', 'Good Friday', 'scotland', NULL),
('2019-04-19', 'Good Friday', 'england-and-wales', NULL),
('2019-04-22', 'Easter Monday', 'england-and-wales', NULL),
('2019-04-22', 'Easter Monday', 'northern-ireland', NULL),
('2019-05-06', 'Early May bank holiday', 'england-and-wales', NULL),
('2019-05-06', 'Early May bank holiday', 'northern-ireland', NULL),
('2019-05-06', 'Early May bank holiday', 'scotland', NULL),
('2019-05-27', 'Spring bank holiday', 'england-and-wales', NULL),
('2019-05-27', 'Spring bank holiday', 'northern-ireland', NULL),
('2019-05-27', 'Spring bank holiday', 'scotland', NULL),
('2019-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2019-08-05', 'Summer bank holiday', 'scotland', NULL),
('2019-08-26', 'Summer bank holiday', 'england-and-wales', NULL),
('2019-08-26', 'Summer bank holiday', 'northern-ireland', NULL),
('2019-12-02', 'St Andrew''s Day', 'scotland', 'Substitute day'),
('2019-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2019-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2019-12-25', 'Christmas Day', 'scotland', NULL),
('2019-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2019-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2019-12-26', 'Boxing Day', 'scotland', NULL),
('2020-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2020-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2020-01-01', 'New Year''s Day', 'scotland', NULL),
('2020-01-02', '2nd January', 'scotland', NULL),
('2020-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2020-04-10', 'Good Friday', 'england-and-wales', NULL),
('2020-04-10', 'Good Friday', 'northern-ireland', NULL),
('2020-04-10', 'Good Friday', 'scotland', NULL),
('2020-04-13', 'Easter Monday', 'england-and-wales', NULL),
('2020-04-13', 'Easter Monday', 'northern-ireland', NULL),
('2020-05-08', 'Early May bank holiday (VE Day)', 'england-and-wales', NULL),
('2020-05-08', 'Early May bank holiday (VE Day)', 'northern-ireland', NULL),
('2020-05-08', 'Early May bank holiday (VE Day)', 'scotland', NULL),
('2020-05-25', 'Spring bank holiday', 'england-and-wales', NULL),
('2020-05-25', 'Spring bank holiday', 'northern-ireland', NULL),
('2020-05-25', 'Spring bank holiday', 'scotland', NULL),
('2020-07-13', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', 'Substitute day'),
('2020-08-03', 'Summer bank holiday', 'scotland', NULL),
('2020-08-31', 'Summer bank holiday', 'england-and-wales', NULL),
('2020-08-31', 'Summer bank holiday', 'northern-ireland', NULL),
('2020-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2020-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2020-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2020-12-25', 'Christmas Day', 'scotland', NULL),
('2020-12-28', 'Boxing Day', 'england-and-wales', 'Substitute day'),
('2020-12-28', 'Boxing Day', 'northern-ireland', 'Substitute day'),
('2020-12-28', 'Boxing Day', 'scotland', 'Substitute day'),
('2021-01-01', 'New Year''s Day', 'england-and-wales', NULL),
('2021-01-01', 'New Year''s Day', 'northern-ireland', NULL),
('2021-01-01', 'New Year''s Day', 'scotland', NULL),
('2021-01-04', '2nd January', 'scotland', 'Substitute day'),
('2021-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2021-04-02', 'Good Friday', 'england-and-wales', NULL),
('2021-04-02', 'Good Friday', 'northern-ireland', NULL),
('2021-04-02', 'Good Friday', 'scotland', NULL),
('2021-04-05', 'Easter Monday', 'england-and-wales', NULL),
('2021-04-05', 'Easter Monday', 'northern-ireland', NULL),
('2021-05-03', 'Early May bank holiday', 'england-and-wales', NULL),
('2021-05-03', 'Early May bank holiday', 'northern-ireland', NULL),
('2021-05-03', 'Early May bank holiday', 'scotland', NULL),
('2021-05-31', 'Spring bank holiday', 'england-and-wales', NULL),
('2021-05-31', 'Spring bank holiday', 'northern-ireland', NULL),
('2021-05-31', 'Spring bank holiday', 'scotland', NULL),
('2021-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2021-08-02', 'Summer bank holiday', 'scotland', NULL),
('2021-08-30', 'Summer bank holiday', 'england-and-wales', NULL),
('2021-08-30', 'Summer bank holiday', 'northern-ireland', NULL),
('2021-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2021-12-27', 'Christmas Day', 'england-and-wales', 'Substitute day'),
('2021-12-27', 'Christmas Day', 'northern-ireland', 'Substitute day'),
('2021-12-27', 'Christmas Day', 'scotland', 'Substitute day'),
('2021-12-28', 'Boxing Day', 'england-and-wales', 'Substitute day'),
('2021-12-28', 'Boxing Day', 'northern-ireland', 'Substitute day'),
('2021-12-28', 'Boxing Day', 'scotland', 'Substitute day'),
('2022-01-03', 'New Year''s Day', 'england-and-wales', 'Substitute day'),
('2022-01-03', 'New Year''s Day', 'northern-ireland', 'Substitute day'),
('2022-01-03', 'New Year''s Day', 'scotland', 'Substitute day'),
('2022-01-04', '2nd January', 'scotland', 'Substitute day'),
('2022-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2022-04-15', 'Good Friday', 'england-and-wales', NULL),
('2022-04-15', 'Good Friday', 'northern-ireland', NULL),
('2022-04-15', 'Good Friday', 'scotland', NULL),
('2022-04-18', 'Easter Monday', 'england-and-wales', NULL),
('2022-04-18', 'Easter Monday', 'northern-ireland', NULL),
('2022-05-02', 'Early May bank holiday (VE Day)', 'england-and-wales', NULL),
('2022-05-02', 'Early May bank holiday', 'northern-ireland', NULL),
('2022-05-02', 'Early May bank holiday', 'scotland', NULL),
('2022-06-02', 'Spring bank holiday', 'england-and-wales', NULL),
('2022-06-02', 'Spring bank holiday', 'northern-ireland', NULL),
('2022-06-02', 'Spring bank holiday', 'scotland', NULL),
('2022-06-03', 'Platinum Jubilee bank holiday', 'england-and-wales', NULL),
('2022-06-03', 'Platinum Jubilee bank holiday', 'northern-ireland', NULL),
('2022-06-03', 'Platinum Jubilee bank holiday', 'scotland', NULL),
('2022-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2022-08-01', 'Summer bank holiday', 'scotland', NULL),
('2022-08-29', 'Summer bank holiday', 'england-and-wales', NULL),
('2022-08-29', 'Summer bank holiday', 'northern-ireland', NULL),
('2022-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2022-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2022-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2022-12-26', 'Boxing Day', 'scotland', NULL),
('2022-12-27', 'Christmas Day', 'england-and-wales', 'Substitute day'),
('2022-12-27', 'Christmas Day', 'northern-ireland', 'Substitute day'),
('2022-12-27', 'Christmas Day', 'scotland', 'Substitute day'),
('2023-01-02', 'New Year''s Day', 'england-and-wales', NULL),
('2023-01-02', 'New Year''s Day', 'northern-ireland', NULL),
('2023-01-02', '2nd January', 'scotland', NULL),
('2023-01-03', 'New Year''s Day', 'scotland', 'Substitute day'),
('2023-03-17', 'St Patrick''s Day', 'northern-ireland', NULL),
('2023-04-07', 'Good Friday', 'england-and-wales', NULL),
('2023-04-07', 'Good Friday', 'northern-ireland', NULL),
('2023-04-07', 'Good Friday', 'scotland', NULL),
('2023-04-10', 'Easter Monday', 'england-and-wales', NULL),
('2023-04-10', 'Easter Monday', 'northern-ireland', NULL),
('2023-05-01', 'Early May bank holiday', 'england-and-wales', NULL),
('2023-05-01', 'Early May bank holiday', 'northern-ireland', NULL),
('2023-05-01', 'Early May bank holiday', 'scotland', NULL),
('2023-05-08', 'King Charles III''s coronation holiday', 'england-and-wales', NULL),
('2023-05-08', 'King Charles III''s coronation holiday', 'northern-ireland', NULL),
('2023-05-08', 'King Charles III''s coronation holiday', 'scotland', NULL),
('2023-05-29', 'Spring bank holiday', 'england-and-wales', NULL),
('2023-05-29', 'Spring bank holiday', 'northern-ireland', NULL),
('2023-05-29', 'Spring bank holiday', 'scotland', NULL),
('2023-07-12', 'Battle of the Boyne (Orangemen''s Day)', 'northern-ireland', NULL),
('2023-08-07', 'Summer bank holiday', 'scotland', NULL),
('2023-08-28', 'Summer bank holiday', 'england-and-wales', NULL),
('2023-08-28', 'Summer bank holiday', 'northern-ireland', NULL),
('2023-11-30', 'St Andrew''s Day', 'scotland', NULL),
('2023-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2023-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2023-12-25', 'Christmas Day', 'scotland', NULL),
('2023-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2023-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2023-12-26', 'Boxing Day', 'scotland', NULL),
('2024-01-01', 'New Year’s Day', 'england-and-wales', NULL),
('2024-01-01', 'New Year’s Day', 'northern-ireland', NULL),
('2024-01-01', 'New Year’s Day', 'scotland', NULL),
('2024-01-02', '2nd January', 'scotland', NULL),
('2024-03-18', 'St Patrick’s Day', 'northern-ireland', 'Substitute day'),
('2024-03-29', 'Good Friday', 'england-and-wales', NULL),
('2024-03-29', 'Good Friday', 'northern-ireland', NULL),
('2024-03-29', 'Good Friday', 'scotland', NULL),
('2024-04-01', 'Easter Monday', 'england-and-wales', NULL),
('2024-04-01', 'Easter Monday', 'northern-ireland', NULL),
('2024-05-06', 'Early May bank holiday', 'england-and-wales', NULL),
('2024-05-06', 'Early May bank holiday', 'northern-ireland', NULL),
('2024-05-06', 'Early May bank holiday', 'scotland', NULL),
('2024-05-27', 'Spring bank holiday', 'england-and-wales', NULL),
('2024-05-27', 'Spring bank holiday', 'northern-ireland', NULL),
('2024-05-27', 'Spring bank holiday', 'scotland', NULL),
('2024-07-12', 'Battle of the Boyne (Orangemen’s Day)', 'northern-ireland', NULL),
('2024-08-05', 'Summer bank holiday', 'scotland', NULL),
('2024-08-26', 'Summer bank holiday', 'england-and-wales', NULL),
('2024-08-26', 'Summer bank holiday', 'northern-ireland', NULL),
('2024-12-02', 'St Andrew’s Day', 'scotland', 'Substitute day'),
('2024-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2024-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2024-12-25', 'Christmas Day', 'scotland', NULL),
('2024-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2024-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2024-12-26', 'Boxing Day', 'scotland', NULL),
('2025-01-01', 'New Year’s Day', 'england-and-wales', NULL),
('2025-01-01', 'New Year’s Day', 'northern-ireland', NULL),
('2025-01-01', 'New Year’s Day', 'scotland', NULL),
('2025-01-02', '2nd January', 'scotland', NULL),
('2025-03-17', 'St Patrick’s Day', 'northern-ireland', NULL),
('2025-04-18', 'Good Friday', 'england-and-wales', NULL),
('2025-04-18', 'Good Friday', 'northern-ireland', NULL),
('2025-04-18', 'Good Friday', 'scotland', NULL),
('2025-04-21', 'Easter Monday', 'england-and-wales', NULL),
('2025-04-21', 'Easter Monday', 'northern-ireland', NULL),
('2025-05-05', 'Early May bank holiday', 'england-and-wales', NULL),
('2025-05-05', 'Early May bank holiday', 'northern-ireland', NULL),
('2025-05-05', 'Early May bank holiday', 'scotland', NULL),
('2025-05-26', 'Spring bank holiday', 'england-and-wales', NULL),
('2025-05-26', 'Spring bank holiday', 'northern-ireland', NULL),
('2025-05-26', 'Spring bank holiday', 'scotland', NULL),
('2025-07-14', 'Battle of the Boyne (Orangemen’s Day)', 'northern-ireland', 'Substitute day'),
('2025-08-04', 'Summer bank holiday', 'scotland', NULL),
('2025-08-25', 'Summer bank holiday', 'england-and-wales', NULL),
('2025-08-25', 'Summer bank holiday', 'northern-ireland', NULL),
('2025-12-01', 'St Andrew’s Day', 'scotland', 'Substitute day'),
('2025-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2025-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2025-12-25', 'Christmas Day', 'scotland', NULL),
('2025-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2025-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2025-12-26', 'Boxing Day', 'scotland', NULL),
('2026-01-01', 'New Year’s Day', 'england-and-wales', NULL),
('2026-01-01', 'New Year’s Day', 'northern-ireland', NULL),
('2026-01-01', 'New Year’s Day', 'scotland', NULL),
('2026-01-02', '2nd January', 'scotland', NULL),
('2026-03-17', 'St Patrick’s Day', 'northern-ireland', NULL),
('2026-04-03', 'Good Friday', 'england-and-wales', NULL),
('2026-04-03', 'Good Friday', 'northern-ireland', NULL),
('2026-04-03', 'Good Friday', 'scotland', NULL),
('2026-04-06', 'Easter Monday', 'england-and-wales', NULL),
('2026-04-06', 'Easter Monday', 'northern-ireland', NULL),
('2026-05-04', 'Early May bank holiday', 'england-and-wales', NULL),
('2026-05-04', 'Early May bank holiday', 'northern-ireland', NULL),
('2026-05-04', 'Early May bank holiday', 'scotland', NULL),
('2026-05-25', 'Spring bank holiday', 'england-and-wales', NULL),
('2026-05-25', 'Spring bank holiday', 'northern-ireland', NULL),
('2026-05-25', 'Spring bank holiday', 'scotland', NULL),
('2026-07-13', 'Battle of the Boyne (Orangemen’s Day)', 'northern-ireland', 'Substitute day'),
('2026-08-03', 'Summer bank holiday', 'scotland', NULL),
('2026-08-31', 'Summer bank holiday', 'england-and-wales', NULL),
('2026-08-31', 'Summer bank holiday', 'northern-ireland', NULL),
('2026-11-30', 'St Andrew’s Day', 'scotland', NULL),
('2026-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2026-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2026-12-25', 'Christmas Day', 'scotland', NULL),
('2026-12-28', 'Boxing Day', 'england-and-wales', 'Substitute day'),
('2026-12-28', 'Boxing Day', 'northern-ireland', 'Substitute day'),
('2026-12-28', 'Boxing Day', 'scotland', 'Substitute day'),
('2027-01-01', 'New Year’s Day', 'england-and-wales', NULL),
('2027-01-01', 'New Year’s Day', 'northern-ireland', NULL),
('2027-01-01', 'New Year’s Day', 'scotland', NULL),
('2027-01-04', '2nd January', 'scotland', 'Substitute day'),
('2027-03-17', 'St Patrick’s Day', 'northern-ireland', NULL),
('2027-03-26', 'Good Friday', 'england-and-wales', NULL),
('2027-03-26', 'Good Friday', 'northern-ireland', NULL),
('2027-03-26', 'Good Friday', 'scotland', NULL),
('2027-03-29', 'Easter Monday', 'england-and-wales', NULL),
('2027-03-29', 'Easter Monday', 'northern-ireland', NULL),
('2027-05-03', 'Early May bank holiday', 'england-and-wales', NULL),
('2027-05-03', 'Early May bank holiday', 'northern-ireland', NULL),
('2027-05-03', 'Early May bank holiday', 'scotland', NULL),
('2027-05-31', 'Spring bank holiday', 'england-and-wales', NULL),
('2027-05-31', 'Spring bank holiday', 'northern-ireland', NULL),
('2027-05-31', 'Spring bank holiday', 'scotland', NULL),
('2027-07-12', 'Battle of the Boyne (Orangemen’s Day)', 'northern-ireland', NULL),
('2027-08-02', 'Summer bank holiday', 'scotland', NULL),
('2027-08-30', 'Summer bank holiday', 'england-and-wales', NULL),
('2027-08-30', 'Summer bank holiday', 'northern-ireland', NULL),
('2027-11-30', 'St Andrew’s Day', 'scotland', NULL),
('2027-12-27', 'Christmas Day', 'england-and-wales', 'Substitute day'),
('2027-12-27', 'Christmas Day', 'northern-ireland', 'Substitute day'),
('2027-12-27', 'Christmas Day', 'scotland', 'Substitute day'),
('2027-12-28', 'Boxing Day', 'england-and-wales', 'Substitute day'),
('2027-12-28', 'Boxing Day', 'northern-ireland', 'Substitute day'),
('2027-12-28', 'Boxing Day', 'scotland', 'Substitute day'),
('2028-01-03', 'New Year’s Day', 'england-and-wales', 'Substitute day'),
('2028-01-03', 'New Year’s Day', 'northern-ireland', 'Substitute day'),
('2028-01-03', 'New Year’s Day', 'scotland', 'Substitute day'),
('2028-01-04', '2nd January', 'scotland', 'Substitute day'),
('2028-03-17', 'St Patrick’s Day', 'northern-ireland', NULL),
('2028-04-14', 'Good Friday', 'england-and-wales', NULL),
('2028-04-14', 'Good Friday', 'northern-ireland', NULL),
('2028-04-14', 'Good Friday', 'scotland', NULL),
('2028-04-17', 'Easter Monday', 'england-and-wales', NULL),
('2028-04-17', 'Easter Monday', 'northern-ireland', NULL),
('2028-05-01', 'Early May bank holiday', 'england-and-wales', NULL),
('2028-05-01', 'Early May bank holiday', 'northern-ireland', NULL),
('2028-05-01', 'Early May bank holiday', 'scotland', NULL),
('2028-05-29', 'Spring bank holiday', 'england-and-wales', NULL),
('2028-05-29', 'Spring bank holiday', 'northern-ireland', NULL),
('2028-05-29', 'Spring bank holiday', 'scotland', NULL),
('2028-07-12', 'Battle of the Boyne (Orangemen’s Day)', 'northern-ireland', NULL),
('2028-08-07', 'Summer bank holiday', 'scotland', NULL),
('2028-08-28', 'Summer bank holiday', 'england-and-wales', NULL),
('2028-08-28', 'Summer bank holiday', 'northern-ireland', NULL),
('2028-11-30', 'St Andrew’s Day', 'scotland', NULL),
('2028-12-25', 'Christmas Day', 'england-and-wales', NULL),
('2028-12-25', 'Christmas Day', 'northern-ireland', NULL),
('2028-12-25', 'Christmas Day', 'scotland', NULL),
('2028-12-26', 'Boxing Day', 'england-and-wales', NULL),
('2028-12-26', 'Boxing Day', 'northern-ireland', NULL),
('2028-12-26', 'Boxing Day', 'scotland', NULL),
),
BankHolidayYear AS (
SELECT DISTINCT
Holiday_Date_Observed_Year = YEAR(Holiday_Date_Observed)
FROM
BankHoliday
)
MERGE
INTO
[dw].[dim_date_publicholiday_uk] AS [Target]
USING
BankHoliday AS [Source]
ON
[Source].[Holiday_Date_Observed] = [Target].[Holiday_Date_Observed] AND
[Source].[Holiday_Jurisdiction] = [Target].[Holiday_Jurisdiction]
WHEN MATCHED THEN
UPDATE SET
[Target].[Holiday_Name] = [Source].[Holiday_Name],
[Target].[Holiday_Notes] = [Source].[Holiday_Notes]
WHEN NOT MATCHED BY TARGET THEN
INSERT (
[Holiday_Date_Observed],
[Holiday_Name],
[Holiday_Jurisdiction],
[Holiday_Notes]
)
VALUES (
[Source].[Holiday_Date_Observed],
[Source].[Holiday_Name],
[Source].[Holiday_Jurisdiction],
[Source].[Holiday_Notes]
)
WHEN NOT MATCHED BY SOURCE AND YEAR([Target].[Holiday_Date_Observed]) IN (SELECT Holiday_Date_Observed_Year FROM BankHolidayYear) THEN
DELETE;
Raw
dw.date_publicholiday_uk.sql
CREATE TABLE
[dw].[date_publicholiday_uk] (
[Holiday_Id] INT IDENTITY(1,1) NOT NULL
[Holiday_Date_Observed] DATE NOT NULL,
[Holiday_Name] NVARCHAR(100) NOT NULL,
[Holiday_Jurisdiction] NVARCHAR(50) NOT NULL,
[Holiday_Notes] NVARCHAR(250) NULL
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment