delete from line_name;
Rows deleted: 997
replace line_name values ("Seniors","10","0","10","s","Pensions, disability, health care"), ("Sickness and disability","A1","0","11","s",""), ("Old age","A2","0","12","s",""), ("Medical service (Seniors)","77","0","13","s",""), ("Education","30","0","20","s","K-12, college, training"), ("Pre primary thru secondary education","91","0","21","s",""), ("Tertiary education","94","0","24","s",""), ("Education not definable by level","95","0","25","s",""), ("Subsidiary services to education","96","0","26","s",""), ("R and D Education","97","0","27","s",""), ("Education n.e.c.","98","0","28","s",""), ("Welfare","20","0","30","s","Cash welfare, food stamps, unemployment benefits, workers compensation, housing, health care"), ("Medical service","73","0","31","s",""), ("Public health services","74","0","32","s",""), ("R and D Health","75","0","33","s",""), ("Health n.e.c.","76","0","34","s",""), ("Family and children","A4","0","35","s",""), ("Unemployment","A5","0","36","s",""), ("Unemployment trust","AA","0","37","s",""), ("Workers compensation","A1","0","38","s",""), ("Housing","A6","0","39","s",""), ("Social exclusion n.e.c.","A7","0","3A","s",""), ("R and D Social protection","A8","0","3B","s",""), ("Social protection n.e.c.","A9","0","3C","s",""), ("Vendor Payments (Medical)","78","0","3D","s",""), ("Defense","40","0","40","s","Military, foreign policy, veterans, foreign aid"), ("Military defense","21","0","41","s",""), ("Civil defense","22","0","42","s",""), ("Veterans","26","0","43","s",""), ("Foreign military aid","23","0","44","s",""), ("Foreign economic aid","12","0","45","s",""), ("R and D Defence","24","0","46","s",""), ("Defence n.e.c.","25","0","47","s",""), ("Protection","50","0","50","s","Police, fire, law courts, prisons"), ("Police services","31","0","51","s",""), ("Fire protection services","32","0","52","s",""), ("Law courts","33","0","53","s",""), ("Prisons","34","0","54","s",""), ("R and D Public order and safety","35","0","55","s",""), ("Public order and safety n.e.c.","36","0","56","s",""), ("Transportation","60","0","60","s","Road, rail, airports"), ("Transport","45","0","65","s",""), ("Transit","4A","0","66","s",""), ("General Government","70","0","70","s","Legislative, executive, finance"), ("Executive and legislative organs, financ","11","0","71","s",""), ("General services","13","0","73","s",""), ("R and D General public services","15","0","75","s",""), ("General public services n.e.c.","16","0","76","s",""), ("Transfers of a general character between","18","0","78","s",""), ("Other Spending","80","0","80","s","Research, economic development, agriculture, energy, environment"), ("Basic research","14","0","81","s",""), ("General economic, commercial and labour ","41","0","82","s",""), ("Agriculture, forestry, fishing and hunti","42","0","83","s",""), ("Fuel and energy","43","0","84","s",""), ("Mining, manufacturing and construction","44","0","85","s",""), ("Communication","46","0","86","s",""), ("Other industries","47","0","87","s",""), ("R and D Economic affairs","48","0","88","s",""), ("Economic affairs n.e.c.","49","0","89","s",""), ("Waste management","51","0","8A","s",""), ("Waste water management","52","0","8B","s",""), ("Pollution abatement","53","0","8C","s",""), ("Protection of biodiversity and landscape","54","0","8D","s",""), ("R and D Environmental protection","55","0","8E","s",""), ("Environmental protection n.e.c.","56","0","8F","s",""), ("Housing development","61","0","8G","s",""), ("Community development","62","0","8H","s",""), ("Water supply","63","0","8I","s",""), ("Street lighting","64","0","8J","s",""), ("R and D Housing and community amenities","65","0","8K","s",""), ("Housing and community amenities n.e.c.","66","0","8L","s",""), ("Recreational and sporting services","81","0","8M","s",""), ("Cultural services","82","0","8N","s",""), ("Broadcasting and publishing services","83","0","8O","s",""), ("Religious and other community services","84","0","8P","s",""), ("R and D Recreation, culture and religion","85","0","8Q","s",""), ("Recreation, culture and religion n.e.c.","86","0","8R","s",""), ("Interest","90","0","90","s","Interest on government debt"), ("Public debt transactions","17","0","97","s",""), ("Balance","E0","0","E0","s",""), ("Total Spending","F0","0","F0","s",""), ("Total","F1","0","F1","s",""), ("Federal Deficit","G0","0","G0","s",""), ("Total Spending","G1","0","G1","s",""), ("Total Revenue","G2","0","G2","s",""), ("Gross Public Debt","H0","0","H0","s",""), ("Debt held by public (except monetized)","H1","0","H1","s",""), ("Debt held by government","H2","0","H2","s",""), ("Monetized debt","H3","0","H3","s",""), ("Pensions","10","1","00","s","Pensions, disability"), ("Sickness and disability","A3","1","01","s",""), ("Old age","A2","1","02","s",""), ("Health Care","00","1","10","s","Health care"), ("Medical service (Seniors)","77","1","12","s",""), ("Medical service","73","1","13","s",""), ("Public health services","74","1","14","s",""), ("R and D Health","75","1","15","s",""), ("Health n.e.c.","76","1","16","s",""), ("Vendor Payments (Medical)","78","1","17","s",""), ("Education","30","1","20","s","K-12, college, training"), ("Pre primary thru secondary education","91","1","21","s",""), ("Tertiary education","94","1","24","s","")
replace line_name values ("Education not definable by level","95","1","25","s",""), ("Subsidiary services to education","96","1","26","s",""), ("R and D Education","97","1","27","s",""), ("Education n.e.c.","98","1","28","s",""), ("Welfare","20","1","40","s","Cash welfare, food stamps, unemployment benefits, workers compensation, housing, excluding health care"), ("Family and children","A4","1","41","s",""), ("Unemployment","A5","1","42","s",""), ("Unemployment trust","AA","1","43","s",""), ("Workers compensation","A1","1","44","s",""), ("Housing","A6","1","46","s",""), ("Social exclusion n.e.c.","A7","1","47","s",""), ("R and D Social protection","A8","1","48","s",""), ("Social protection n.e.c.","A9","1","49","s",""), ("Defense","40","1","30","s","Military, foreign policy, veterans, foreign aid"), ("Military defense","21","1","31","s",""), ("Civil defense","22","1","32","s",""), ("Veterans","26","1","33","s",""), ("Foreign military aid","23","1","34","s",""), ("Foreign economic aid","12","1","35","s",""), ("R and D Defence","24","1","36","s",""), ("Defence n.e.c.","25","1","37","s",""), ("Protection","50","1","50","s","Police, fire, law courts, prisons"), ("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 and D Public order and safety","35","1","55","s",""), ("Public order and safety n.e.c.","36","1","56","s",""), ("Transportation","60","1","60","s","Road, rail, airports"), ("Transport","45","1","65","s",""), ("Transit","4A","1","66","s",""), ("General Government","70","1","70","s","Legislative, executive, finance"), ("Executive and legislative organs, financ","11","1","71","s",""), ("General services","13","1","73","s",""), ("Other Spending","80","1","80","s","Research, economic development, agriculture, energy, environment"), ("Basic research","14","1","81","s",""), ("General economic, commercial and labour ","41","1","82","s",""), ("Agriculture, forestry, fishing and hunti","42","1","83","s",""), ("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 and 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 landscape","54","1","8D","s",""), ("R and 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 and 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 and D Recreation, culture and religion","85","1","8Q","s",""), ("Recreation, culture and religion n.e.c.","86","1","8R","s",""), ("R and D General public services","15","1","8S","s",""), ("General public services n.e.c.","16","1","8T","s",""), ("Transfers of a general character between","18","1","8U","s",""), ("Interest","90","1","90","s","Interest on government debt"), ("Public debt transactions","17","1","97","s",""), ("Balance","E0","1","E0","s",""), ("Total Spending","F0","1","F0","s","Federal: total outlays including grants to state and local. State and local: direct spending on programs"), ("Total","F1","1","F1","s",""), ("Federal Deficit","G0","1","G0","s",""), ("Total Spending","G1","1","G1","s",""), ("Total Revenue","G2","1","G2","s",""), ("Gross Public Debt","H0","1","H0","s",""), ("Debt held by public (except monetized)","H1","1","H1","s",""), ("Debt held by government","H2","1","H2","s",""), ("Monetized debt","H3","1","H3","s",""), ("Other Borrowing","I0","1","I0","s",""), ("Borrowings from Govt. Accounts","I1","1","I1","s",""), ("Other Liability Increase","I2","1","I2","s",""), ("Agency GSE Debt","J0","1","J0","s",""), ("GSE Debt Issues","J1","1","J1","s",""), ("Agency GSE Mortgage Pools","J2","1","J2","s",""), ("Grants","K0","1","K0","s",""), ("Pensions Grants","K1","1","K1","s",""), ("Healthcare Grants","K2","1","K2","s",""), ("Medicaid Grants","K3","1","K3","s",""), ("Education Grants","K4","1","K4","s",""), ("Defense Grants","K5","1","K5","s",""), ("Welfare Grants","K6","1","K6","s",""), ("Protection Grants","K7","1","K7","s",""), ("Transportation Grants","K8","1","K8","s",""), ("General Government Grants","K9","1","K9","s",""), ("Other Spending Grants","KA","1","KA","s",""), ("Pensions","10","2","00","s","Pensions, disability"), ("Sickness and disability","C1","2","01","s",""), ("Old age","C2","2","02","s",""), ("Health Care","00","2","10","s","Health care"), ("Medical service (Seniors)","C3","2","12","s",""), ("Medical service","73","2","13","s",""), ("Public health services","74","2","14","s",""), ("R and D Health","75","2","15","s","")
replace line_name values ("Health n.e.c.","76","2","16","s",""), ("Vendor Payments (Medical)","78","2","17","s",""), ("Education","30","2","20","s","K-12, college, training"), ("Pre primary thru secondary education","91","2","21","s",""), ("Tertiary education","94","2","24","s",""), ("Education not definable by level","95","2","25","s",""), ("Subsidiary services to education","96","2","26","s",""), ("R and D Education","97","2","27","s",""), ("Education n.e.c.","98","2","28","s",""), ("Welfare","20","2","40","s","Cash welfare, food stamps, unemployment benefits, workers compensation, housing, excluding health care"), ("Family and children","A4","2","41","s",""), ("Unemployment","A5","2","42","s",""), ("Unemployment trust","AA","2","43","s",""), ("Housing","A6","2","46","s",""), ("Social exclusion n.e.c.","A7","2","47","s",""), ("R and D Social protection","A8","2","48","s",""), ("Social protection n.e.c.","A9","2","49","s",""), ("Defense","40","2","30","s","Military, foreign policy, veterans, foreign aid"), ("Military defense","21","2","31","s",""), ("Civil defense","22","2","32","s",""), ("Veterans","26","2","33","s",""), ("Foreign military aid","23","2","34","s",""), ("Foreign economic aid","12","2","35","s",""), ("R and D Defence","24","2","36","s",""), ("Defence n.e.c.","25","2","37","s",""), ("Protection","50","2","50","s","Police, fire, law courts, prisons"), ("Police services","31","2","51","s",""), ("Fire protection services","32","2","52","s",""), ("Prisons","34","2","54","s",""), ("R and D Public order and safety","35","2","55","s",""), ("Public order and safety n.e.c.","36","2","56","s",""), ("Transportation","60","2","60","s","Road, rail, airports"), ("Transport","45","2","65","s",""), ("Transit","4A","2","66","s",""), ("General Government","70","2","70","s","Legislative, executive, finance"), ("Executive and legislative organs, financ","11","2","71","s",""), ("Law courts","33","2","72","s",""), ("General services","13","2","73","s",""), ("Other Spending","80","2","80","s","Research, economic development, agriculture, energy, environment"), ("Basic research","14","2","81","s",""), ("General economic, commercial and labour ","41","2","82","s",""), ("Agriculture, forestry, fishing and hunti","42","2","83","s",""), ("Fuel and energy","43","2","84","s",""), ("Mining, manufacturing and construction","44","2","85","s",""), ("Communication","46","2","86","s",""), ("Other industries","47","2","87","s",""), ("R and D Economic affairs","48","2","88","s",""), ("Economic affairs n.e.c.","49","2","89","s",""), ("Waste management","51","2","8A","s",""), ("Waste water management","52","2","8B","s",""), ("Pollution abatement","53","2","8C","s",""), ("Protection of biodiversity and landscape","54","2","8D","s",""), ("R and D Environmental protection","55","2","8E","s",""), ("Environmental protection n.e.c.","56","2","8F","s",""), ("Housing development","61","2","8G","s",""), ("Community development","62","2","8H","s",""), ("Water supply","63","2","8I","s",""), ("Street lighting","64","2","8J","s",""), ("R and D Housing and community amenities","65","2","8K","s",""), ("Housing and community amenities n.e.c.","66","2","8L","s",""), ("Recreational and sporting services","81","2","8M","s",""), ("Cultural services","82","2","8N","s",""), ("Broadcasting and publishing services","83","2","8O","s",""), ("Religious and other community services","84","2","8P","s",""), ("R and D Recreation, culture and religion","85","2","8Q","s",""), ("Recreation, culture and religion n.e.c.","86","2","8R","s",""), ("R and D General public services","15","2","8S","s",""), ("General public services n.e.c.","16","2","8T","s",""), ("Transfers of a general character between","18","2","8U","s",""), ("Interest","90","2","90","s","Interest on government debt"), ("Public debt transactions","17","2","97","s",""), ("Balance","E0","2","E0","s",""), ("Total Spending","F0","2","F0","s","Federal: total outlays including grants to state and local. State and local: direct spending on programs"), ("Total","F1","2","F1","s",""), ("Federal Deficit","G0","2","G0","s",""), ("Total Spending","G1","2","G1","s",""), ("Total Revenue","G2","2","G2","s",""), ("Other Borrowing","I0","2","I0","s",""), ("Borrowings from Govt. Accounts","I1","2","I1","s",""), ("Other Liability Increase","I2","2","I2","s",""), ("Gross Public Debt","H0","2","H0","s",""), ("Debt held by public (except monetized)","H1","2","H1","s",""), ("Debt held by government","H2","2","H2","s",""), ("Monetized debt","H3","2","H3","s",""), ("Agency GSE Debt","J0","2","J0","s",""), ("GSE Debt Issues","J1","2","J1","s",""), ("Agency GSE Mortgage Pools","J2","2","J2","s",""), ("Grants","K0","2","K0","s",""), ("Pensions Grants","K1","2","K1","s",""), ("Healthcare Grants","K2","2","K2","s",""), ("Medicaid Grants","K3","2","K3","s",""), ("Education Grants","K4","2","K4","s",""), ("Defense Grants","K5","2","K5","s",""), ("Welfare Grants","K6","2","K6","s",""), ("Protection Grants","K7","2","K7","s",""), ("Transportation Grants","K8","2","K8","s",""), ("General Government Grants","K9","2","K9","s",""), ("Other Spending Grants","KA","2","KA","s",""), ("Gross Domestic Product","P0","2","P0","s",""), ("Gross Domestic Product","P1","2","P1","s",""), ("Inflation","Q0","1","Q0","s",""), ("Inflation","Q1","1","Q1","s","")
replace line_name values ("Justice for Seniors","10","3","10","s","Pensions, disability, health care"), ("Sickness and disability","A3","3","11","s",""), ("Old age","A2","3","12","s",""), ("Medical service (Seniors)","77","3","13","s",""), ("Free Education","30","3","20","s","K-12, college, training"), ("Pre primary thru secondary education","91","3","21","s",""), ("Tertiary education","94","3","24","s",""), ("Education not definable by level","95","3","25","s",""), ("Subsidiary services to education","96","3","26","s",""), ("R and D Education","97","3","27","s",""), ("Education n.e.c.","98","3","28","s",""), ("Justice for the Poor","20","3","30","s","Cash welfare, food stamps, unemployment benefits, workers compensation, housing, excluding health care"), ("Medical service","73","3","31","s",""), ("Public health services","74","3","32","s",""), ("R and D Health","75","3","33","s",""), ("Health n.e.c.","76","3","34","s",""), ("Family and children","A4","3","35","s",""), ("Unemployment","A5","3","36","s",""), ("Unemployment trust","AA","3","37","s",""), ("Workers compensation","A1","3","38","s",""), ("Housing","A6","3","39","s",""), ("Social exclusion n.e.c.","A7","3","3A","s",""), ("R and D Social protection","A8","3","3B","s",""), ("Social protection n.e.c.","A9","3","3C","s",""), ("Vendor Payments (Medical)","78","3","3D","s",""), ("Imperialist Forces","40","3","40","s","Military, foreign policy, veterans, foreign aid"), ("Military defense","21","3","41","s",""), ("Civil defense","22","3","42","s",""), ("Veterans","26","3","43","s",""), ("Foreign military aid","23","3","44","s",""), ("Foreign economic aid","12","3","45","s",""), ("R and D Defence","24","3","46","s",""), ("Defence n.e.c.","25","3","47","s",""), ("Domestic Repression","50","3","50","s","Police, fire, law courts, prisons"), ("Police services","31","3","51","s",""), ("Fire protection services","32","3","52","s",""), ("Law courts","33","3","53","s",""), ("Prisons","34","3","54","s",""), ("R and D Public order and safety","35","3","55","s",""), ("Public order and safety n.e.c.","36","3","56","s",""), ("Affordable Transportation","60","3","60","s","Road, rail, airports"), ("Transport","45","3","65","s",""), ("Transit","4A","3","66","s",""), ("Public Servants","70","3","70","s","Legislative, executive, finance"), ("Executive and legislative organs, financ","11","3","71","s",""), ("General services","13","3","73","s",""), ("R and D General public services","15","3","75","s",""), ("General public services n.e.c.","16","3","76","s",""), ("Transfers of a general character between","18","3","78","s",""), ("Other Public Services","80","3","80","s","Research, economic development, agriculture, energy, environment"), ("Basic research","14","3","81","s",""), ("General economic, commercial and labour ","41","3","82","s",""), ("Agriculture, forestry, fishing and hunti","42","3","83","s",""), ("Fuel and energy","43","3","84","s",""), ("Mining, manufacturing and construction","44","3","85","s",""), ("Communication","46","3","86","s",""), ("Other industries","47","3","87","s",""), ("R and D Economic affairs","48","3","88","s",""), ("Economic affairs n.e.c.","49","3","89","s",""), ("Waste management","51","3","8A","s",""), ("Waste water management","52","3","8B","s",""), ("Pollution abatement","53","3","8C","s",""), ("Protection of biodiversity and landscape","54","3","8D","s",""), ("R and D Environmental protection","55","3","8E","s",""), ("Environmental protection n.e.c.","56","3","8F","s",""), ("Housing development","61","3","8G","s",""), ("Community development","62","3","8H","s",""), ("Water supply","63","3","8I","s",""), ("Street lighting","64","3","8J","s",""), ("R and D Housing and community amenities","65","3","8K","s",""), ("Housing and community amenities n.e.c.","66","3","8L","s",""), ("Recreational and sporting services","81","3","8M","s",""), ("Cultural services","82","3","8N","s",""), ("Broadcasting and publishing services","83","3","8O","s",""), ("Religious and other community services","84","3","8P","s",""), ("R and D Recreation, culture and religion","85","3","8Q","s",""), ("Recreation, culture and religion n.e.c.","86","3","8R","s",""), ("Interest","90","3","90","s","Interest on government debt"), ("Public debt transactions","17","3","97","s",""), ("Balance","E0","3","E0","s",""), ("Total Public Services","F0","3","F0","s","Federal: total outlays including grants to state and local. State and local: direct spending on programs"), ("Total","F1","3","F1","s",""), ("Federal Deficit","G0","3","G0","s",""), ("Total Spending","G1","3","G1","s",""), ("Total Revenue","G2","3","G2","s",""), ("Gross Public Debt","H0","3","H0","s",""), ("Debt held by public (except monetized)","H1","3","H1","s",""), ("Debt held by government","H2","3","H2","s",""), ("Monetized debt","H3","3","H3","s",""), ("Agency GSE Debt","J0","3","J0","s",""), ("GSE Debt Issues","J1","3","J1","s",""), ("Agency GSE Mortgage Pools","J2","3","J2","s",""), ("Education","30","4","00","s","K-12, college, training"), ("Pre primary thru secondary education","91","4","01","s",""), ("Tertiary education","94","4","04","s",""), ("Education not definable by level","95","4","05","s",""), ("Subsidiary services to education","96","4","06","s",""), ("R and D Education","97","4","07","s",""), ("Education n.e.c.","98","4","08","s",""), ("Social services and income maintenance","20","4","10","s","Pensions, disability, health care, cash welfare, food stamps, unemployment benefits, workers compensation"), ("Family and children","A4","4","14","s",""), ("Unemployment","A5","4","15","s","")
replace line_name values ("Social exclusion n.e.c.","A7","4","17","s",""), ("R and D Social protection","A8","4","18","s",""), ("Medical service (Seniors)","77","4","1A","s",""), ("Medical service","73","4","1B","s",""), ("Public health services","74","4","1C","s",""), ("R and D Health","75","4","1D","s",""), ("Health n.e.c.","76","4","1E","s",""), ("Vendor Payments (Medical)","78","4","1F","s",""), ("Veterans","26","4","1G","s",""), ("Transportation","60","4","20","s","Road, rail, airports"), ("Transportation","45","4","27","s",""), ("Public safety","80","4","30","s","Police, fire, prisons"), ("Police services","31","4","31","s",""), ("Fire protection services","32","4","32","s",""), ("Prisons","34","4","34","s",""), ("R and D Public order and safety","35","4","35","s",""), ("Public order and safety n.e.c.","36","4","36","s",""), ("Environment and housing","40","4","40","s","Environment, housing"), ("Waste management","51","4","41","s",""), ("Waste water management","52","4","42","s",""), ("Pollution abatement","53","4","43","s",""), ("Protection of biodiversity and landscape","54","4","44","s",""), ("R and D Environmental protection","55","4","45","s",""), ("Environmental protection n.e.c.","56","4","46","s",""), ("Housing","A6","4","47","s",""), ("Housing development","61","4","48","s",""), ("Community development","62","4","49","s",""), ("Natural Resources","42","4","4A","s",""), ("R and D Housing and community amenities","65","4","4B","s",""), ("Housing and community amenities n.e.c.","66","4","4C","s",""), ("Recreational and sporting services","81","4","4D","s",""), ("Cultural services","82","4","4E","s",""), ("Broadcasting and publishing services","83","4","4F","s",""), ("Religious and other community services","84","4","4G","s",""), ("R and D Recreation, culture and religion","85","4","4H","s",""), ("Recreation, culture and religion n.e.c.","86","4","4I","s",""), ("Governmental administration","40","4","50","s","Legislative, executive, finance, law courts"), ("Executive and legislative organs, financ","11","4","57","s",""), ("Law courts","33","4","58","s",""), ("General services","13","4","59","s",""), ("Interest","90","4","60","s","Interest on government debt"), ("Public debt transactions","17","4","67","s",""), ("General expenditure n.e.c","40","4","70","s","Military, foreign policy, veterans, foreign aid, research, economic development, agriculture"), ("Military defense","21","4","71","s",""), ("Civil defense","22","4","72","s",""), ("Foreign military aid","23","4","74","s",""), ("Foreign economic aid","12","4","75","s",""), ("R and D Defence","24","4","76","s",""), ("Defence n.e.c.","25","4","77","s",""), ("Basic research","14","4","78","s",""), ("General economic, commercial and labour ","41","4","79","s",""), ("Mining, manufacturing and construction","44","4","7B","s",""), ("Communication","46","4","7C","s",""), ("R and D Economic affairs","48","4","7E","s",""), ("Economic affairs n.e.c.","49","4","7F","s",""), ("R and D General public services","15","4","7G","s",""), ("General public services n.e.c.","16","4","7H","s",""), ("Transfers of a general character between","18","4","7I","s",""), ("Utilities","10","4","80","s","Electric, water, energy, street lighting, transit"), ("Fuel and energy","43","4","81","s",""), ("Water supply","63","4","82","s",""), ("Street lighting","64","4","83","s",""), ("Transit","4A","4","84","s",""), ("Liquor Stores","10","4","90","s","Liquor"), ("Liquor stores","47","4","91","s",""), ("Insurance trust","10","4","A0","s","Unemployment, retirement, workers comp"), ("Unemployment trust","AA","4","A1","s",""), ("Employee retirement","A2","4","A2","s",""), ("Workers compensation","A1","4","A3","s",""), ("Other","A9","4","A4","s",""), ("Balance","E0","4","E0","s",""), ("Total Public Spending","F0","4","F0","s","Federal: total outlays including grants to state and local. State and local: direct spending on programs"), ("Total Public Spending","F1","4","F1","s",""), ("Federal Deficit","G0","4","G0","s",""), ("Total Spending","G1","4","G1","s",""), ("Total Revenue","G2","4","G2","s",""), ("Gross Public Debt","H0","4","H0","s",""), ("Debt held by public (except monetized)","H1","4","H1","s",""), ("Debt held by government","H2","4","H2","s",""), ("Monetized debt","H3","4","H3","s",""), ("Agency GSE Debt","J0","4","J0","s",""), ("GSE Debt Issues","J1","4","J1","s",""), ("Agency GSE Mortgage Pools","J2","4","J2","s",""), ("Government Pensions","10","5","00","s","Pensions, disability"), ("Sickness and disability","A3","5","01","s",""), ("Old age","A2","5","02","s",""), ("Government Health Care","00","5","10","s","Health care"), ("Medical service (Seniors)","77","5","12","s",""), ("Medical service","73","5","13","s",""), ("Public health services","74","5","14","s",""), ("R and D Health","75","5","15","s",""), ("Health n.e.c.","76","5","16","s",""), ("Vendor Payments (Medical)","78","5","17","s",""), ("Government Education","30","5","20","s","K-12, college, training"), ("Pre primary thru secondary education","91","5","21","s",""), ("Tertiary education","94","5","24","s",""), ("Education not definable by level","95","5","25","s",""), ("Subsidiary services to education","96","5","26","s",""), ("R and D Education","97","5","27","s",""), ("Education n.e.c.","98","5","28","s",""), ("Government Welfare","20","5","40","s","Cash welfare, food stamps, unemployment benefits, workers compensation, housing, excluding health care"), ("Family and children","A4","5","44","s","")
replace line_name values ("Unemployment","A5","5","45","s",""), ("Unemployment trust","AA","5","46","s",""), ("Housing","A6","5","47","s",""), ("Social exclusion n.e.c.","A7","5","48","s",""), ("R and D Social protection","A8","5","49","s",""), ("Social protection n.e.c.","A9","5","4A","s",""), ("National Defense","40","5","30","s","Military, foreign policy, veterans, foreign aid"), ("Military defense","21","5","31","s",""), ("Civil defense","22","5","32","s",""), ("Veterans","26","5","33","s",""), ("Foreign military aid","23","5","34","s",""), ("Foreign economic aid","12","5","35","s",""), ("R and D Defence","24","5","36","s",""), ("Defence n.e.c.","25","5","37","s",""), ("All Other Spending","80","5","80","s","Police, fire, law courts, prisons; Road, rail, airports; Legislative, executive, finance; Research, economic development, agriculture, energy, environment; Interest on government debt"), ("Basic research","14","5","81","s",""), ("General economic, commercial and labour ","41","5","82","s",""), ("Agriculture, forestry, fishing and hunti","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 and 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 landscape","54","5","8D","s",""), ("R and 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",""), ("Water supply","63","5","8I","s",""), ("Street lighting","64","5","8J","s",""), ("R and 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 and D Recreation, culture and religion","85","5","8Q","s",""), ("Recreation, culture and religion n.e.c.","86","5","8R","s",""), ("R and D General public services","15","5","8S","s",""), ("General public services n.e.c.","16","5","8T","s",""), ("Transfers of a general character between","18","5","8U","s",""), ("Police services","31","5","8V","s",""), ("Fire protection services","32","5","8W","s",""), ("Law courts","33","5","8X","s",""), ("Prisons","34","5","8Y","s",""), ("R and D Public order and safety","35","5","8Z","s",""), ("Public order and safety n.e.c.","36","5","8a","s",""), ("Transport","45","5","8b","s",""), ("Transit","4A","5","8c","s",""), ("Executive and legislative organs, financ","11","5","8d","s",""), ("General services","13","5","8e","s",""), ("Public debt transactions","17","5","8f","s",""), ("Total Government Spending","F0","5","F0","s","Federal: total outlays including grants to state and local. State and local: direct spending on programs"), ("Total","F1","5","F1","s",""), ("Federal Deficit","G0","5","G0","s",""), ("Total Spending","G1","5","G1","s",""), ("Total Revenue","G2","5","G2","s",""), ("Social Security","10","6","00","s","Old Age Survivor Insurance, Disability Insurance"), ("Old Age Survivor Ins (OASI)","B1","6","01","s",""), ("Disability Ins (DI)","B2","6","02","s",""), ("Other","B3","6","03","s",""), ("Medicare (Net)","00","6","10","s","Net health care for seniors, after substracting premiums and contributions"), ("Part A (Hospital Insurance)","B6","6","11","s",""), ("Part B (Suppl. Med. Ins.)","B7","6","12","s",""), ("Part C (Medicare Advantage)","BA","6","13","s",""), ("Part D (Sup. Med. Ins. Drug)","B8","6","14","s",""), ("Other","B9","6","15","s",""), ("Medicaid","B0","6","20","s","Health care for the poor"), ("Medicaid","71","6","21","s",""), ("Other Welfare","C0","6","30","s","Cash welfare, food stamps, unemployment benefits, workers compensation, housing, excluding health care"), ("Family and children","A4","6","31","s",""), ("Unemployment","A5","6","32","s",""), ("Unemployment trust","AA","6","33","s",""), ("Workmens compensation","A1","6","34","s",""), ("Housing","A6","6","35","s",""), ("Social exclusion n.e.c.","A7","6","36","s",""), ("R and D Social protection","A8","6","37","s",""), ("Social protection n.e.c.","A9","6","38","s",""), ("Gov. Employee Pensions (Net)","x0","6","40","s","Government employee pensions net cost"), ("Employee pensions","B5","6","41","s",""), ("Defense","50","6","50","s","Military, foreign policy, veterans, foreign aid"), ("Military defense","21","6","51","s",""), ("Civil defense","22","6","52","s",""), ("Veterans","26","6","53","s",""), ("Foreign military aid","23","6","54","s",""), ("Foreign economic aid","12","6","55","s",""), ("All Other Spending","D0","6","60","s","Health care (not Medicare or Medicaid); education; Police, fire, law courts, prisons; Road, rail, airports; Legislative, executive, finance; Research, economic development, agriculture, energy, environment; Interest on government debt"), ("Medical service","72","6","61","s",""), ("Public health services","74","6","62","s",""), ("R and D Health","75","6","63","s",""), ("Pre primary thru secondary education","91","6","64","s",""), ("Tertiary education","94","6","65","s",""), ("Education not definable by level","95","6","66","s",""), ("Basic research","14","6","6A","s",""), ("General economic, commercial and labour ","41","6","6a","s",""), ("Agriculture, forestry, fishing and hunti","42","6","6B","s",""), ("Fuel and energy","43","6","6c","s",""), ("Mining, manufacturing and construction","44","6","6D","s","")
replace line_name values ("Communication","46","6","6d","s",""), ("Other industries","47","6","6E","s",""), ("R and D Economic affairs","48","6","6e","s",""), ("Economic affairs n.e.c.","49","6","6F","s",""), ("Waste management","51","6","6f","s",""), ("Waste water management","52","6","6G","s",""), ("Pollution abatement","53","6","6g","s",""), ("Protection of biodiversity and landscape","54","6","6H","s",""), ("R and D Environmental protection","55","6","6h","s",""), ("Environmental protection n.e.c.","56","6","6I","s",""), ("Housing development","61","6","6i","s",""), ("Community development","62","6","6J","s",""), ("Water supply","63","6","6j","s",""), ("Street lighting","64","6","6K","s",""), ("R and D Housing and community amenities","65","6","6k","s",""), ("Housing and community amenities n.e.c.","66","6","6L","s",""), ("Recreational and sporting services","81","6","6l","s",""), ("General public services n.e.c.","16","6","6M","s",""), ("Transfers of a general character between","18","6","6m","s",""), ("Police services","31","6","6N","s",""), ("Fire protection services","32","6","6n","s",""), ("Law courts","33","6","6O","s",""), ("Prisons","34","6","6o","s",""), ("R and D Public order and safety","35","6","6P","s",""), ("Public order and safety n.e.c.","36","6","6p","s",""), ("Transport","45","6","6Q","s",""), ("Transit","4A","6","6q","s",""), ("Executive and legislative organs, financ","11","6","6R","s",""), ("General services","13","6","6r","s",""), ("Public debt transactions","17","6","6S","s",""), ("Balance","E0","6","E0","s",""), ("Total Government Spending","F0","6","F0","s","Federal: total outlays including grants to state and local. State and local: direct spending on programs"), ("Total","F1","6","F1","s",""), ("Federal Deficit","G0","6","G0","s",""), ("Total Spending","G1","6","G1","s",""), ("Total Revenue","G2","6","G2","s",""), ("Gross Public Debt","H0","6","H0","s",""), ("Debt held by public (except monetized)","H1","6","H1","s",""), ("Debt held by government","H2","6","H2","s",""), ("Monetized debt","H3","6","H3","s",""), ("Agency GSE Debt","J0","6","J0","s",""), ("GSE Debt Issues","J1","6","J1","s",""), ("Agency GSE Mortgage Pools","J2","6","J2","s",""), ("Social Security","10","7","00","s","Old Age Survivor Insurance, Disability Insurance"), ("Old Age Survivor Ins (OASI)","B1","7","01","s",""), ("Disability Ins (DI)","B2","7","02","s",""), ("Other","B3","7","03","s",""), ("Medicare (Gross)","00","7","10","s","Health care for seniors gross cost"), ("Part A (Hospital Insurance)","C6","7","11","s",""), ("Part B (Suppl. Med. Ins.)","C7","7","12","s",""), ("Part C (Medicare Advantage)","CA","7","13","s",""), ("Part D (Sup. Med. Ins. Drug)","C8","7","14","s",""), ("Other","C9","7","15","s",""), ("Medicaid","B0","7","20","s","Health care for the poor"), ("Medicaid","71","7","21","s",""), ("Other Welfare","C0","7","30","s","Cash welfare, food stamps, unemployment benefits, workers compensation, housing, excluding health care"), ("Family and children","A4","7","31","s",""), ("Unemployment","A5","7","32","s",""), ("Unemployment trust","AA","7","33","s",""), ("Workmens compensation","A1","7","34","s",""), ("Housing","A6","7","35","s",""), ("Social exclusion n.e.c.","A7","7","36","s",""), ("R and D Social protection","A8","7","37","s",""), ("Social protection n.e.c.","A9","7","38","s",""), ("Gov. Employee Pensions (Gross)","x0","7","40","s","Government employee pensions"), ("Employee pensions","B4","7","41","s",""), ("Defense","50","7","50","s","Military, foreign policy, veterans, foreign aid"), ("Military defense","21","7","51","s",""), ("Civil defense","22","7","52","s",""), ("Veterans","26","7","53","s",""), ("Foreign military aid","23","7","54","s",""), ("Foreign economic aid","12","7","55","s",""), ("All Other Spending","D0","7","60","s","Health care (not Medicare or Medicaid); education; Police, fire, law courts, prisons; Road, rail, airports; Legislative, executive, finance; Research, economic development, agriculture, energy, environment; Interest on government debt"), ("Medical service","72","7","61","s",""), ("Public health services","74","7","62","s",""), ("R and D Health","75","7","63","s",""), ("Pre primary thru secondary education","91","7","64","s",""), ("Tertiary education","94","7","65","s",""), ("Education not definable by level","95","7","66","s",""), ("Basic research","14","7","6A","s",""), ("General economic, commercial and labour ","41","7","6a","s",""), ("Agriculture, forestry, fishing and hunti","42","7","6B","s",""), ("Fuel and energy","43","7","6c","s",""), ("Mining, manufacturing and construction","44","7","6D","s",""), ("Communication","46","7","6d","s",""), ("Other industries","47","7","6E","s",""), ("R and D Economic affairs","48","7","6e","s",""), ("Economic affairs n.e.c.","49","7","6F","s",""), ("Waste management","51","7","6f","s",""), ("Waste water management","52","7","6G","s",""), ("Pollution abatement","53","7","6g","s",""), ("Protection of biodiversity and landscape","54","7","6H","s",""), ("R and D Environmental protection","55","7","6h","s",""), ("Environmental protection n.e.c.","56","7","6I","s",""), ("Housing development","61","7","6i","s",""), ("Community development","62","7","6J","s",""), ("Water supply","63","7","6j","s",""), ("Street lighting","64","7","6K","s",""), ("R and D Housing and community amenities","65","7","6k","s",""), ("Housing and community amenities n.e.c.","66","7","6L","s",""), ("Recreational and sporting services","81","7","6l","s",""), ("General public services n.e.c.","16","7","6M","s","")
replace line_name values ("Transfers of a general character between","18","7","6m","s",""), ("Police services","31","7","6N","s",""), ("Fire protection services","32","7","6n","s",""), ("Law courts","33","7","6O","s",""), ("Prisons","34","7","6o","s",""), ("R and D Public order and safety","35","7","6P","s",""), ("Public order and safety n.e.c.","36","7","6p","s",""), ("Transport","45","7","6Q","s",""), ("Transit","4A","7","6q","s",""), ("Executive and legislative organs, financ","11","7","6R","s",""), ("General services","13","7","6r","s",""), ("Public debt transactions","17","7","6S","s",""), ("Negative Spending","00","7","70","s","Medicare and government employee pension contributions"), ("Medicare Contributions","D5","7","71","s",""), ("Pension Contributions","D6","7","72","s",""), ("Balance","E0","7","E0","s",""), ("Total Government Spending","F0","7","F0","s","Federal: total outlays including grants to state and local. State and local: direct spending on programs"), ("Total","F1","7","F1","s",""), ("Federal Deficit","G0","7","G0","s",""), ("Total Spending","G1","7","G1","s",""), ("Total Revenue","G2","7","G2","s",""), ("Gross Public Debt","H0","7","H0","s",""), ("Debt held by public (except monetized)","H1","7","H1","s",""), ("Debt held by government","H2","7","H2","s",""), ("Monetized debt","H3","7","H3","s",""), ("Agency GSE Debt","J0","7","J0","s",""), ("GSE Debt Issues","J1","7","J1","s",""), ("Agency GSE Mortgage Pools","J2","7","J2","s",""), ("Social Security","10","8","00","s","Old Age Survivor Insurance, Disability Insurance"), ("Old Age Survivor Ins (OASI)","B1","8","01","s",""), ("Disability Ins (DI)","B2","8","02","s",""), ("Other","B3","8","03","s",""), ("Medicare (Net)","00","8","10","s","Health care for seniors, net of premiums and contributions"), ("Part A (Hospital Insurance)","D1","8","11","s",""), ("Part B (Suppl. Med. Ins.)","D2","8","12","s",""), ("Part D (Sup. Med. Ins. Drug)","D3","8","14","s",""), ("Other","D4","8","15","s",""), ("Medicaid","B0","8","20","s","Health care for the poor"), ("Medicaid","71","8","21","s",""), ("Other Welfare","C0","8","30","s","Cash welfare, food stamps, unemployment benefits, workers compensation, housing, excluding health care"), ("Family and children","A4","8","31","s",""), ("Unemployment","A5","8","32","s",""), ("Unemployment trust","AA","8","33","s",""), ("Workmens compensation","A1","8","34","s",""), ("Housing","A6","8","35","s",""), ("Social exclusion n.e.c.","A7","8","36","s",""), ("R and D Social protection","A8","8","37","s",""), ("Social protection n.e.c.","A9","8","38","s",""), ("Gov. Employee Pensions","x0","8","40","s","Government employee pensions net cost"), ("Employee pensions","B5","8","41","s",""), ("Defense","50","8","50","s","Military, foreign policy, veterans, foreign aid"), ("Military defense","21","8","51","s",""), ("Civil defense","22","8","52","s",""), ("Veterans","26","8","53","s",""), ("Foreign military aid","23","8","54","s",""), ("Foreign economic aid","12","8","55","s",""), ("All Other Spending","D0","8","60","s","Health care (not Medicare or Medicaid); education; Police, fire, law courts, prisons; Road, rail, airports; Legislative, executive, finance; Research, economic development, agriculture, energy, environment; Interest on government debt"), ("Medical service","72","8","61","s",""), ("Public health services","74","8","62","s",""), ("R and D Health","75","8","63","s",""), ("Pre primary thru secondary education","91","8","64","s",""), ("Tertiary education","94","8","65","s",""), ("Education not definable by level","95","8","66","s",""), ("Basic research","14","8","6A","s",""), ("General economic, commercial and labour ","41","8","6a","s",""), ("Agriculture, forestry, fishing and hunti","42","8","6B","s",""), ("Fuel and energy","43","8","6c","s",""), ("Mining, manufacturing and construction","44","8","6D","s",""), ("Communication","46","8","6d","s",""), ("Other industries","47","8","6E","s",""), ("R and D Economic affairs","48","8","6e","s",""), ("Economic affairs n.e.c.","49","8","6F","s",""), ("Waste management","51","8","6f","s",""), ("Waste water management","52","8","6G","s",""), ("Pollution abatement","53","8","6g","s",""), ("Protection of biodiversity and landscape","54","8","6H","s",""), ("R and D Environmental protection","55","8","6h","s",""), ("Environmental protection n.e.c.","56","8","6I","s",""), ("Housing development","61","8","6i","s",""), ("Community development","62","8","6J","s",""), ("Water supply","63","8","6j","s",""), ("Street lighting","64","8","6K","s",""), ("R and D Housing and community amenities","65","8","6k","s",""), ("Housing and community amenities n.e.c.","66","8","6L","s",""), ("Recreational and sporting services","81","8","6l","s",""), ("General public services n.e.c.","16","8","6M","s",""), ("Transfers of a general character between","18","8","6m","s",""), ("Police services","31","8","6N","s",""), ("Fire protection services","32","8","6n","s",""), ("Law courts","33","8","6O","s",""), ("Prisons","34","8","6o","s",""), ("R and D Public order and safety","35","8","6P","s",""), ("Public order and safety n.e.c.","36","8","6p","s",""), ("Transport","45","8","6Q","s",""), ("Transit","4A","8","6q","s",""), ("Executive and legislative organs, financ","11","8","6R","s",""), ("General services","13","8","6r","s",""), ("Public debt transactions","17","8","6S","s",""), ("Balance","E0","8","E0","s",""), ("Total Government Spending","F0","8","F0","s","Federal: total outlays including grants to state and local. State and local: direct spending on programs"), ("Total","F1","8","F1","s",""), ("Federal Deficit","G0","8","G0","s","")
replace line_name values ("Total Spending","G1","8","G1","s",""), ("Total Revenue","G2","8","G2","s",""), ("Gross Public Debt","H0","8","H0","s",""), ("Debt held by public (except monetized)","H1","8","H1","s",""), ("Debt held by government","H2","8","H2","s",""), ("Monetized debt","H3","8","H3","s",""), ("Agency GSE Debt","J0","8","J0","s",""), ("GSE Debt Issues","J1","8","J1","s",""), ("Agency GSE Mortgage Pools","J2","8","J2","s",""), ("1. General public services","10","9","10","s","Executive and legislative, foreign economic aid, general services, research, interest on debt, transfers"), ("1.1 Executive and legislative organs, fi","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 and 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 bet","18","9","18","s",""), ("2. Defence","20","9","20","s","Military, military aid, veterans"), ("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 and D Defence","24","9","24","s",""), ("2.5 Defence n.e.c.","25","9","25","s",""), ("Veterans","26","9","26","s",""), ("3. Public order and safety","30","9","30","s","Police, fire, law courts, prisons"), ("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 and 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","Economic development, fuel and enervy, mining, transport, communications, rail"), ("4.1 General economic, commercial and lab","41","9","41","s",""), ("4.2 Agriculture, forestry, fishing and h","42","9","42","s",""), ("4.3 Fuel and energy","43","9","43","s",""), ("4.4 Mining, manufacturing and constructi","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 and D Economic affairs","48","9","48","s",""), ("4.9 Economic affairs n.e.c.","49","9","49","s",""), ("4.A Rail Transport","4A","9","4A","s",""), ("5. Environmental protection","50","9","50","s","Waste, wastewater, pollution abatement, biodiversity"), ("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 lands","54","9","54","s",""), ("5.5 R and 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","Housing, community development, water supply, street lighting"), ("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 and D Housing and community amenit","65","9","65","s",""), ("6.6 Housing and community amenities n.e.","66","9","66","s",""), ("7. Health","70","9","70","s","Health care , public health"), ("Medical service","73","9","73","s",""), ("7.4 Public health services","74","9","74","s",""), ("7.5 R and D Health","75","9","75","s",""), ("7.6 Health n.e.c.","76","9","76","s",""), ("Medical service (Seniors)","77","9","77","s",""), ("Vendor Payments (Medical)","78","9","78","s",""), ("8. Recreation, culture and religion","80","9","80","s","Recreaton, broadcasting, religion"), ("8.1 Recreational and sporting services","81","9","81","s",""), ("8.2 Cultural services","82","9","82","s",""), ("8.3 Broadcasting and publishing services","83","9","83","s",""), ("8.4 Religious and other community servic","84","9","84","s",""), ("8.5 R and D Recreation, culture and reli","85","9","85","s",""), ("8.6 Recreation, culture and religion n.e","86","9","86","s",""), ("9. Education","90","9","90","s","Pre-primary thru secondary education, tertiary education, training, services to education"), ("Pre primary thru secondary education","91","9","91","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 and D Education","97","9","97","s",""), ("9.8 Education n.e.c.","98","9","98","s",""), ("10. Social protection","A0","9","A0","s","Pensions, disability, welfare, unemployment, housing, social exclusion"), ("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 and D Social protection","A8","9","A8","s",""), ("10.9 Social protection n.e.c.","A9","9","A9","s",""), ("Unemployment trust","AA","9","AA","s",""), ("Balance","E0","9","E0","s",""), ("Total Public Spending","F0","9","F0","s","Federal: total outlays including grants to state and local. State and local: direct spending on programs"), ("Total Public Spending","F1","9","F1","s",""), ("Federal Deficit","G0","9","G0","s",""), ("Total Spending","G1","9","G1","s",""), ("Total Revenue","G2","9","G2","s",""), ("Gross Public Debt","H0","9","H0","s",""), ("Debt held by public (except monetized)","H1","9","H1","s",""), ("Debt held by government","H2","9","H2","s",""), ("Monetized debt","H3","9","H3","s",""), ("Agency GSE Debt","J0","9","J0","s",""), ("GSE Debt Issues","J1","9","J1","s",""), ("Agency GSE Mortgage Pools","J2","9","J2","s","")
last buff
replace line_name values
("Income Taxes","10","1","10","r","Individual and corporate income taxes"),
("Individual Income Tax","11","1","11","r",""),
("Corporate Income Tax","12","1","12","r",""),
("Social Insurance Taxes","30","1","30","r","FICA taxes, unemployment, disability taxes"),
("Old Age Survivors Insurance","31","1","31","r",""),
("Disability Insurance","32","1","32","r",""),
("Hospital Insurance","33","1","33","r",""),
("Unemployment Insurance","34","1","34","r",""),
("Employee Retirement Insurance","35","1","35","r",""),
("Railroad Retirement Insurance","36","1","36","r",""),
("Other","39","1","39","r",""),
("Ad valorem Taxes","40","1","40","r","Sales, excise and property taxes, licenses"),
("Excise Taxes","41","1","41","r",""),
("Sales 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","Education, health, transportation, natural resources charges"),
("Fees and Charges","50","1","50","r","Fees for government services other than taxes"),
("Education","51","1","51","r",""),
("Health","52","1","52","r",""),
("Transportation","53","1","53","r",""),
("Natural Resources","54","1","54","r",""),
("Utilities","55","1","55","r",""),
("Other","59","1","59","r",""),
("Business and Other Revenue","60","1","60","r","Revenue from government businesses such as liquor stores and utilities"),
("Utility and Liquor Store","61","1","61","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 raised by federal, state, or local government. Does not include intergovernmental revenue such as federal grants"),
("Total Revenue","F1","1","F1","r",""),
("Intergovernmental Revenue","F2","1","F2","r",""),
("Federal Deficit","G0","1","G0","r",""),
("Total Spending","G1","1","G1","r",""),
("Total Revenue","G2","1","G2","r",""),
("Gross Public Debt","H0","1","H0","r",""),
("Debt held by public (excpt monetized)","H1","1","H1","r",""),
("Debt held by government","H2","1","H2","r",""),
("Monetized debt","H3","1","H3","r",""),
("Taxes","10","4","10","r","Income, excise, sales, property, transportation taxes and licenses"),
("Individual Income Tax","11","4","11","r",""),
("Corporate Income Tax","12","4","12","r",""),
("Excise Taxes","41","4","13","r",""),
("Sales Taxes","42","4","14","r",""),
("Property Taxes","43","4","15","r",""),
("Transportation","44","4","16","r",""),
("License","45","4","17","r",""),
("Other","46","4","18","r",""),
("Charges and misc. revenue","50","4","50","r","Education, health, transportation, natural resources charges"),
("Education","51","4","51","r",""),
("Health","52","4","52","r",""),
("Transportation","53","4","53","r",""),
("Natural Resources","54","4","54","r",""),
("Other charges","59","4","56","r",""),
("Other revenue","63","4","57","r",""),
("Utility and liquor store","60","4","60","r","Utility and liquor store revenue"),
("Utility and Liquor Store","61","4","61","r",""),
("Other Utilities","55","4","62","r",""),
("Insurance trust revenue","70","4","70","r","Pension, disabiltiy, hospital, unemployment, retirement insurance"),
("Old Age Survivors Insurance","31","4","71","r",""),
("Disability Insurance","32","4","72","r",""),
("Hospital Insurance","33","4","73","r",""),
("Unemployment Insurance","34","4","74","r",""),
("Employee Retirement Insurance","35","4","75","r",""),
("Railroad Retirement Insurance","36","4","76","r",""),
("Other","39","4","77","r",""),
("Balance","E0","4","E0","r",""),
("Balance","E1","4","E1","r",""),
("Total Direct Revenue","F0","4","F0","r","Total Revenue raised by federal, state, or local government. Does not include intergovernmental revenue such as federal grants"),
("Total Revenue","F1","4","F1","r",""),
("Intergovernmental Revenue","F2","4","F2","r",""),
("Federal Deficit","G0","4","G0","r",""),
("Total Spending","G1","4","G1","r",""),
("Total Revenue","G2","4","G2","r",""),
("Gross Public Debt","H0","4","H0","r",""),
("Debt held by public (excpt monetized)","H1","4","H1","r",""),
("Debt held by government","H2","4","H2","r",""),
("Monetized debt","H3","4","H3","r","")
Done