delete from uk_line_name;
Rows deleted: 294
replace uk_line_name values ("Pensions","10","1","00","s"), ("Sickness and disability","A1","1","01","s"), ("Old age","A2","1","02","s"), ("Survivors","A3","1","03","s"), ("Pensions n.e.c.","AA","1","04","s"), ("Health Care","00","1","10","s"), ("Medical service","73","1","13","s"), ("Public health services","74","1","14","s"), ("R&D Health","75","1","15","s"), ("Health n.e.c.","76","1","16","s"), ("Education","30","1","20","s"), ("Pre-primary and primary education","91","1","21","s"), ("Secondary education","92","1","22","s"), ("Post-secondary non-tertiary education","93","1","23","s"), ("Tertiary education","94","1","24","s"), ("Education not definable by level","95","1","25","s"), ("Subsidiary services to education","96","1","26","s"), ("R&D Education","97","1","27","s"), ("Education n.e.c.","98","1","28","s"), ("Welfare","20","1","40","s"), ("Family and children","A4","1","44","s"), ("Unemployment","A5","1","45","s"), ("Housing","A6","1","46","s"), ("Social exclusion n.e.c.","A7","1","47","s"), ("R&D Social protection","A8","1","48","s"), ("Social protection n.e.c.","A9","1","49","s"), ("Defence","40","1","30","s"), ("Military defence","21","1","31","s"), ("Civil defence","22","1","32","s"), ("Foreign military aid","23","1","33","s"), ("Foreign economic aid","12","1","34","s"), ("R&D Defence","24","1","35","s"), ("Defence n.e.c.","25","1","36","s"), ("Protection","50","1","50","s"), ("Police services","31","1","51","s"), ("Fire-protection services","32","1","52","s"), ("Law courts","33","1","53","s"), ("Prisons","34","1","54","s"), ("R&D Public order and safety","35","1","55","s"), ("Public order and safety n.e.c.","36","1","56","s"), ("Transport","60","1","60","s"), ("Transport","45","1","65","s"), ("General Government","70","1","70","s"), ("Executive and legislative organs, finan","11","1","71","s"), ("General services","13","1","73","s"), ("R&D General public services","15","1","75","s"), ("General public services n.e.c.","16","1","76","s"), ("Transfers of a general character betwee","18","1","78","s"), ("Other Spending","80","1","80","s"), ("Basic research","14","1","81","s"), ("General economic, commercial and labour","41","1","82","s"), ("Agriculture, forestry, fishing and hunt","42","1","83","s")
replace uk_line_name values ("Fuel and energy","43","1","84","s"), ("Mining, manufacturing and construction","44","1","85","s"), ("Communication","46","1","86","s"), ("Other industries","47","1","87","s"), ("R&D Economic affairs","48","1","88","s"), ("Economic affairs n.e.c.","49","1","89","s"), ("Waste management","51","1","8a","s"), ("Waste water management","52","1","8b","s"), ("Pollution abatement","53","1","8c","s"), ("Protection of biodiversity and landscap","54","1","8d","s"), ("R&D Environmental protection","55","1","8e","s"), ("Environmental protection n.e.c.","56","1","8f","s"), ("Housing development","61","1","8g","s"), ("Community development","62","1","8h","s"), ("Water supply","63","1","8i","s"), ("Street lighting","64","1","8j","s"), ("R&D Housing and community amenities","65","1","8k","s"), ("Housing and community amenities n.e.c.","66","1","8l","s"), ("Recreational and sporting services","81","1","8m","s"), ("Cultural services","82","1","8n","s"), ("Broadcasting and publishing services","83","1","8o","s"), ("Religious and other community services","84","1","8p","s"), ("R&D Recreation, culture and religion","85","1","8q","s"), ("Recreation, culture and religion n.e.c.","86","1","8r","s"), ("Other Spending","B1","1","8s","s"), ("Interest","90","1","90","s"), ("Public debt transactions","17","1","97","s"), ("Balance","E0","1","E0","s"), ("Total Spending","F0","1","F0","s"), ("Total","F1","1","F1","s"), ("Public Net Debt","G0","1","G0","s"), ("Public Net Debt","G1","1","G1","s"), ("Current Budget Deficit","H0","1","H0","s"), ("Current Budget Deficit","H1","1","H1","s"), ("Gross Domestic Product","P0","1","P0","s"), ("Gross Domestic Product","P1","1","P1","s"), ("Inflation","Q0","1","Q0","s"), ("Inflation","Q1","1","Q1","s"), ("Public Pensions","10","5","00","s"), ("Sickness and disability","A1","5","01","s"), ("Old age","A2","5","02","s"), ("Survivors","A3","5","03","s"), ("Pensions n.e.c.","AA","5","04","s"), ("National Health Care","00","5","10","s"), ("Medical service","73","5","13","s"), ("Public health services","74","5","14","s"), ("R&D Health","75","5","15","s"), ("Health n.e.c.","76","5","16","s"), ("State Education","30","5","20","s"), ("Pre-primary and primary education","91","5","21","s"), ("Secondary education","92","5","22","s"), ("Post-secondary non-tertiary education","93","5","23","s")
replace uk_line_name values ("Tertiary education","94","5","24","s"), ("Education not definable by level","95","5","25","s"), ("Subsidiary services to education","96","5","26","s"), ("R&D Education","97","5","27","s"), ("Education n.e.c.","98","5","28","s"), ("Social Security","20","5","40","s"), ("Family and children","A4","5","44","s"), ("Unemployment","A5","5","45","s"), ("Housing","A6","5","46","s"), ("Social exclusion n.e.c.","A7","5","47","s"), ("R&D Social protection","A8","5","48","s"), ("Social protection n.e.c.","A9","5","49","s"), ("Defence","40","5","30","s"), ("Military defence","21","5","31","s"), ("Civil defence","22","5","32","s"), ("Foreign military aid","23","5","33","s"), ("Foreign economic aid","12","5","34","s"), ("R&D Defence","24","5","35","s"), ("Defence n.e.c.","25","5","36","s"), ("State Protection","50","5","50","s"), ("Police services","31","5","51","s"), ("Fire-protection services","32","5","52","s"), ("Law courts","33","5","53","s"), ("Prisons","34","5","54","s"), ("R&D Public order and safety","35","5","55","s"), ("Public order and safety n.e.c.","36","5","56","s"), ("Transport","60","5","60","s"), ("Transport","45","5","65","s"), ("General Government","70","5","70","s"), ("Executive and legislative organs, finan","11","5","71","s"), ("General services","13","5","73","s"), ("R&D General public services","15","5","75","s"), ("General public services n.e.c.","16","5","76","s"), ("Transfers of a general character betwee","18","5","78","s"), ("Other Public Services","80","5","80","s"), ("Basic research","14","5","81","s"), ("General economic, commercial and labour","41","5","82","s"), ("Agriculture, forestry, fishing and hunt","42","5","83","s"), ("Fuel and energy","43","5","84","s"), ("Mining, manufacturing and construction","44","5","85","s"), ("Communication","46","5","86","s"), ("Other industries","47","5","87","s"), ("R&D Economic affairs","48","5","88","s"), ("Economic affairs n.e.c.","49","5","89","s"), ("Waste management","51","5","8a","s"), ("Waste water management","52","5","8b","s"), ("Pollution abatement","53","5","8c","s"), ("Protection of biodiversity and landscap","54","5","8d","s"), ("R&D Environmental protection","55","5","8e","s"), ("Environmental protection n.e.c.","56","5","8f","s"), ("Housing development","61","5","8g","s"), ("Community development","62","5","8h","s")
replace uk_line_name values ("Water supply","63","5","8i","s"), ("Street lighting","64","5","8j","s"), ("R&D Housing and community amenities","65","5","8k","s"), ("Housing and community amenities n.e.c.","66","5","8l","s"), ("Recreational and sporting services","81","5","8m","s"), ("Cultural services","82","5","8n","s"), ("Broadcasting and publishing services","83","5","8o","s"), ("Religious and other community services","84","5","8p","s"), ("R&D Recreation, culture and religion","85","5","8q","s"), ("Recreation, culture and religion n.e.c.","86","5","8r","s"), ("Other Spending","B1","5","8s","s"), ("Public Sector Interest","90","5","90","s"), ("Public debt transactions","17","5","97","s"), ("Total Spending","F0","5","F0","s"), ("Total","F1","5","F1","s"), ("1. General public services","10","9","10","s"), ("1.1 Executive and legislative organs, f","11","9","11","s"), ("1.2 Foreign economic aid","12","9","12","s"), ("1.3 General services","13","9","13","s"), ("1.4 Basic research","14","9","14","s"), ("1.5 R&D General public services","15","9","15","s"), ("1.6 General public services n.e.c.","16","9","16","s"), ("1.7 Public debt transactions","17","9","17","s"), ("1.8 Transfers of a general character be","18","9","18","s"), ("2. Defence","20","9","20","s"), ("2.1 Military defence","21","9","21","s"), ("2.2 Civil defence","22","9","22","s"), ("2.3 Foreign military aid","23","9","23","s"), ("2.4 R&D Defence","24","9","24","s"), ("2.5 Defence n.e.c.","25","9","25","s"), ("3. Public order and safety","30","9","30","s"), ("3.1 Police services","31","9","31","s"), ("3.2 Fire-protection services","32","9","32","s"), ("3.3 Law courts","33","9","33","s"), ("3.4 Prisons","34","9","34","s"), ("3.5 R&D Public order and safety","35","9","35","s"), ("3.6 Public order and safety n.e.c.","36","9","36","s"), ("4. Economic affairs","40","9","40","s"), ("4.1 General economic, commercial and la","41","9","41","s"), ("4.2 Agriculture, forestry, fishing and ","42","9","42","s"), ("4.3 Fuel and energy","43","9","43","s"), ("4.4 Mining, manufacturing and construct","44","9","44","s"), ("4.5 Transport","45","9","45","s"), ("4.6 Communication","46","9","46","s"), ("4.7 Other industries","47","9","47","s"), ("4.8 R&D Economic affairs","48","9","48","s"), ("4.9 Economic affairs n.e.c.","49","9","49","s"), ("5. Environmental protection","50","9","50","s"), ("5.1 Waste management","51","9","51","s"), ("5.2 Waste water management","52","9","52","s"), ("5.3 Pollution abatement","53","9","53","s"), ("5.4 Protection of biodiversity and land","54","9","54","s")
replace uk_line_name values ("5.5 R&D Environmental protection","55","9","55","s"), ("5.6 Environmental protection n.e.c.","56","9","56","s"), ("6. Housing and community amenities","60","9","60","s"), ("6.1 Housing development","61","9","61","s"), ("6.2 Community development","62","9","62","s"), ("6.3 Water supply","63","9","63","s"), ("6.4 Street lighting","64","9","64","s"), ("6.5 R&D Housing and community amenities","65","9","65","s"), ("6.6 Housing and community amenities n.e","66","9","66","s"), ("7. Health","70","9","70","s"), ("Medical service","73","9","73","s"), ("7.4 Public health services","74","9","74","s"), ("7.5 R&D Health","75","9","75","s"), ("7.6 Health n.e.c.","76","9","76","s"), ("8. Recreation, culture and religion","80","9","80","s"), ("8.1 Recreational and sporting services","81","9","81","s"), ("8.2 Cultural services","82","9","82","s"), ("8.3 Broadcasting and publishing service","83","9","83","s"), ("8.4 Religious and other community servi","84","9","84","s"), ("8.5 R&D Recreation, culture and religio","85","9","85","s"), ("8.6 Recreation, culture and religion n.","86","9","86","s"), ("9. Education","90","9","90","s"), ("9.1 Pre-primary and primary education","91","9","91","s"), ("9.2 Secondary education","92","9","92","s"), ("9.3 Post-secondary non-tertiary educati","93","9","93","s"), ("9.4 Tertiary education","94","9","94","s"), ("9.5 Education not definable by level","95","9","95","s"), ("9.6 Subsidiary services to education","96","9","96","s"), ("9.7 R&D Education","97","9","97","s"), ("9.8 Education n.e.c.","98","9","98","s"), ("10. Social protection","A0","9","A0","s"), ("10.1 Sickness and disability","A1","9","A1","s"), ("10.2 Old age","A2","9","A2","s"), ("10.3 Survivors","A3","9","A3","s"), ("10.4 Family and children","A4","9","A4","s"), ("10.5 Unemployment","A5","9","A5","s"), ("10.6 Housing","A6","9","A6","s"), ("10.7 Social exclusion n.e.c.","A7","9","A7","s"), ("10.8 R&D Social protection","A8","9","A8","s"), ("10.9 Social protection n.e.c.","A9","9","A9","s"), ("10.10 Pensions n.e.c.","AA","9","AA","s"), ("Other Spending","B0","9","B0","s"), ("Other Spending","B1","9","B1","s"), ("Balance","E0","9","E0","s"), ("Total Public Spending","F0","9","F0","s"), ("Total Public Spending","F1","9","F1","s"), ("Public Net Debt","G0","9","G0","s"), ("Public Net Debt","G1","9","G1","s"), ("Deficit","H0","9","H0","s"), ("Current Budget Deficit","H1","9","H1","s"), ("Income and Capital Taxes","10","1","10","r"), ("Income","11","1","11","r")
last buff
replace uk_line_name values
("Capital","12","1","12","r"),
("National Insurance","30","1","30","r"),
("Other","39","1","39","r"),
("Indirect Taxes","40","1","40","r"),
("Excise Taxes","41","1","41","r"),
("Sales/Value Added Taxes","42","1","42","r"),
("Property Taxes","43","1","43","r"),
("Transportation","44","1","44","r"),
("License","45","1","45","r"),
("Other","46","1","46","r"),
("Business and Other Revenue","60","1","60","r"),
("Other","63","1","63","r"),
("Balance","E0","1","E0","r"),
("Balance","E1","1","E1","r"),
("Total Direct Revenue","F0","1","F0","r"),
("Total Revenue","F1","1","F1","r"),
("Net Public Debt","G0","1","G0","r"),
("Public Debt","G1","1","G1","r"),
("Income and Capital Taxes","10","5","10","r"),
("Income","11","5","11","r"),
("Capital","12","5","12","r"),
("National Insurance","30","5","30","r"),
("Other","39","5","39","r"),
("Indirect Taxes","40","5","40","r"),
("Excise Taxes","41","5","41","r"),
("Sales/Value Added Taxes","42","5","42","r"),
("Property Taxes","43","5","43","r"),
("Transportation","44","5","44","r"),
("License","45","5","45","r"),
("Other","46","5","46","r"),
("Business and Other Revenue","60","5","60","r"),
("Other","63","5","63","r"),
("Total Direct Revenue","F0","5","F0","r"),
("Total Revenue","F1","5","F1","r")
Done