-- BaseYear_AgeDistribution_RecessionDipMover_20190820.sql
-- Author:  Allison DenBleyker, ERG.
-- 
-- Instructions: Set the base year and future year at line 9.
--     Rules (not enforced by script):
--       1.  2012 <= byear <=2041
--       2.  2012 <= fyear <=2041
--       3.  byear < fyear
SET @byear=2016, @fyear=2035;

-- Create temporary database
DROP DATABASE IF EXISTS tmp_agetool;
CREATE DATABASE tmp_agetool;
CREATE TABLE tmp_agetool.sourceTypeAgeDistribution_original LIKE sourceTypeAgeDistribution;
CREATE TABLE tmp_agetool.sourceTypeAgeDistribution_gapfill LIKE sourceTypeAgeDistribution;
CREATE TABLE tmp_agetool.sourceTypeAgeDistribution_final LIKE sourceTypeAgeDistribution;
CREATE TABLE tmp_agetool.recessionRatios (sourceTypeID INTEGER, baseYearID INTEGER, modelYearID INTEGER, ageID INTEGER, pctReduction DOUBLE, PRIMARY KEY (sourceTypeID, baseYearID, ageID))Engine=MyISAM;
CREATE TABLE tmp_agetool.mvs14b_natlpop (yearID INTEGER, modelYearID INTEGER, sourceTypeID INTEGER, nationwidePopulation FLOAT, PRIMARY KEY(yearID, modelYearID, sourceTypeID))Engine=MyISAM;
CREATE TABLE tmp_agetool.scrappageRatios (baseYearID INTEGER, futureYearID INTEGER, sourceTypeID INTEGER, modelYearID INTEGER, scrappageRatio DOUBLE, PRIMARY KEY(baseYearID, futureYearID, sourceTypeID, modelYearID))Engine=MyISAM;

-- Populate the table containing MOVES2014b nationwide source type populations for the model years 2009, 2010, and 2011
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2009,11,485168);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2009,21,5454800);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2009,31,2859800);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2009,32,774282);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2009,41,616.19);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2009,42,2561.09);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2009,43,27967.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2009,51,6144.12);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2009,52,135742);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2009,53,4345.56);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2009,54,50238.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2009,61,25357.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2009,62,62494.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2010,11,468441);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2010,21,5988060);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2010,31,3753230);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2010,32,1004330);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2010,41,734.996);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2010,42,2503.75);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2010,43,23479.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2010,51,4631.27);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2010,52,126690);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2010,53,3695.63);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2010,54,59924.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2010,61,19555.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2010,62,47154);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2011,11,497463);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2011,21,5329420);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2011,31,4230840);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2011,32,1160750);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2011,41,832.485);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2011,42,4090.09);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2011,43,21478.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2011,51,5844.93);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2011,52,205748);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2011,53,5858.25);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2011,54,67873.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2011,61,26132.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2012,2011,62,59682.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2009,11,455243);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2009,21,5428280);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2009,31,2808370);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2009,32,760355);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2009,41,616.162);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2009,42,2561.09);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2009,43,27967.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2009,51,6144.11);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2009,52,135742);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2009,53,4345.57);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2009,54,50238.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2009,61,25357.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2009,62,62494.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2010,11,439547);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2010,21,5973930);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2010,31,3711400);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2010,32,993132);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2010,41,734.964);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2010,42,2503.75);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2010,43,23479.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2010,51,4631.26);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2010,52,126690);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2010,53,3695.64);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2010,54,59925);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2010,61,19555.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2010,62,47154);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2011,11,486725);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2011,21,5317200);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2011,31,4184210);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2011,32,1147960);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2011,41,832.448);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2011,42,4090.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2011,43,21478.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2011,51,5844.93);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2011,52,205748);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2011,53,5858.25);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2011,54,67873.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2011,61,26132.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2013,2011,62,59682.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2009,11,420415);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2009,21,5380650);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2009,31,2726050);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2009,32,738069);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2009,41,612.667);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2009,42,2546.59);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2009,43,27809);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2009,51,6110.57);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2009,52,135000);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2009,53,4321.84);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2009,54,49964.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2009,61,25235.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2009,62,62194.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2010,11,405920);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2010,21,5937960);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2010,31,3630530);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2010,32,971491);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2010,41,734.96);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2010,42,2503.77);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2010,43,23479.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2010,51,4631.27);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2010,52,126690);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2010,53,3695.64);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2010,54,59924.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2010,61,19555.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2010,62,47154);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2011,11,449488);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2011,21,5301650);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2011,31,4127700);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2011,32,1132450);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2011,41,832.444);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2011,42,4090.14);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2011,43,21478.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2011,51,5844.94);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2011,52,205748);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2011,53,5858.26);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2011,54,67873.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2011,61,26132.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2014,2011,62,59682.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2009,11,388889);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2009,21,5314650);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2009,31,2622430);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2009,32,710015);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2009,41,608.46);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2009,42,2528.97);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2009,43,27616.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2009,51,6056.83);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2009,52,133814);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2009,53,4283.83);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2009,54,49524.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2009,61,25123.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2009,62,61917.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2010,11,375481);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2010,21,5885640);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2010,31,3522500);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2010,32,942585);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2010,41,732.454);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2010,42,2495.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2010,43,23398);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2010,51,4610.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2010,52,126133);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2010,53,3679.39);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2010,54,59661.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2010,61,19511.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2010,62,47049);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2011,11,415782);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2011,21,5269590);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2011,31,4036400);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2011,32,1107400);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2011,41,832.484);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2011,42,4090.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2011,43,21478.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2011,51,5844.92);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2011,52,205748);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2011,53,5858.24);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2011,54,67873.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2011,61,26132.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2015,2011,62,59682.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2009,11,361847);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2009,21,5232240);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2009,31,2504000);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2009,32,677949);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2009,41,604.243);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2009,42,2511.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2009,43,27426);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2009,51,5995.88);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2009,52,132467);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2009,53,4240.73);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2009,54,49026.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2009,61,25016.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2009,62,61655.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2010,11,349371);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2010,21,5816710);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2010,31,3393540);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2010,32,908078);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2010,41,727.378);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2010,42,2477.87);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2010,43,23236.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2010,51,4564.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2010,52,124864);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2010,53,3642.37);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2010,54,59061.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2010,61,19429.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2010,62,46849.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2011,11,386870);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2011,21,5225270);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2011,31,3920730);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2011,32,1075670);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2011,41,829.589);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2011,42,4075.98);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2011,43,21404.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2011,51,5815.51);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2011,52,204713);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2011,53,5828.77);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2011,54,67531.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2011,61,26077.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2016,2011,62,59556.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2009,11,336987);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2009,21,5127020);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2009,31,2368890);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2009,32,641371);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2009,41,594.445);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2009,42,2470.77);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2009,43,26981.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2009,51,5864.14);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2009,52,129556);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2009,53,4147.56);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2009,54,47949.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2009,61,24699.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2009,62,60874.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2010,11,325368);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2010,21,5724680);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2010,31,3241300);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2010,32,867339);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2010,41,719.515);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2010,42,2451.07);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2010,43,22985.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2010,51,4497.64);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2010,52,123034);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2010,53,3589.02);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2010,54,58196);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2010,61,19264.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2010,62,46454.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2011,11,360291);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2011,21,5162820);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2011,31,3778140);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2011,32,1036550);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2011,41,820.621);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2011,42,4031.91);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2011,43,21173.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2011,51,5730.33);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2011,52,201714);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2011,53,5743.39);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2011,54,66542.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2011,61,25856.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2017,2011,62,59053.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2009,11,313701);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2009,21,4994810);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2009,31,2214130);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2009,32,599468);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2009,41,581.925);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2009,42,2418.77);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2009,43,26413.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2009,51,5695.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2009,52,125834);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2009,53,4028.42);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2009,54,46571.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2009,61,24278.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2009,62,59836.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2010,11,302885);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2010,21,5604690);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2010,31,3060500);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2010,32,818960);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2010,41,704.361);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2010,42,2399.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2010,43,22501.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2010,51,4368.45);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2010,52,119500);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2010,53,3485.92);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2010,54,56524.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2010,61,18936.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2010,62,45662.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2011,11,335394);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2011,21,5077700);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2011,31,3602910);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2011,32,988473);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2011,41,809.093);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2011,42,3975.34);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2011,43,20876.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2011,51,5620.61);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2011,52,197852);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2011,53,5633.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2011,54,65268.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2011,61,25563);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2018,2011,62,58382.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2009,11,292309);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2009,21,4837510);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2009,31,2052360);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2009,32,555668);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2009,41,569.147);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2009,42,2365.64);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2009,43,25833.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2009,51,5521.08);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2009,52,121977);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2009,53,3904.91);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2009,54,45144.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2009,61,23861.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2009,62,58807.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2010,11,282231);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2010,21,5457270);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2010,31,2865020);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2010,32,766648);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2010,41,688.895);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2010,42,2346.78);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2010,43,22007);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2010,51,4234.53);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2010,52,115837);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2010,53,3379.05);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2010,54,54791.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2010,61,18610.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2010,62,44876.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2011,11,312523);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2011,21,4969130);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2011,31,3406420);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2011,32,934566);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2011,41,791.327);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2011,42,3888.01);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2011,43,20417.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2011,51,5448.29);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2011,52,191786);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2011,53,5460.69);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2011,54,63267.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2011,61,25123.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2019,2011,62,57378.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2009,11,272530);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2009,21,4655710);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2009,31,1885960);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2009,32,510616);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2009,41,551.887);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2009,42,2293.92);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2009,43,25050);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2009,51,5295.35);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2009,52,116990);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2009,53,3745.26);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2009,54,43298.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2009,61,23318.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2009,62,57470.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2010,11,263133);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2010,21,5280760);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2010,31,2657920);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2010,32,711231);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2010,41,673.224);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2010,42,2293.42);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2010,43,21506.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2010,51,4104.68);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2010,52,112285);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2010,53,3275.44);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2010,54,53111.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2010,61,18293.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2010,62,44112.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2011,11,291376);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2011,21,4834890);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2011,31,3191150);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2011,32,875508);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2011,41,773.327);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2011,42,3799.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2011,43,19953.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2011,51,5281.23);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2011,52,185906);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2011,53,5293.25);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2011,54,61327.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2011,61,24695.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2020,2011,62,56400.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2009,11,254355);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2009,21,4450330);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2009,31,1716950);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2009,32,464859);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2009,41,535.952);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2009,42,2227.67);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2009,43,24326.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2009,51,5079.76);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2009,52,112227);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2009,53,3592.78);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2009,54,41535.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2009,61,22797.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2009,62,56185.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2010,11,245585);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2010,21,5077170);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2010,31,2442330);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2010,32,653541);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2010,41,653.786);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2010,42,2227.18);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2010,43,20885.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2010,51,3937.57);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2010,52,107714);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2010,53,3142.08);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2010,54,50948.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2010,61,17884.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2010,62,43125.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2011,11,271945);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2011,21,4674460);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2011,31,2960390);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2011,32,812194);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2011,41,756.581);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2011,42,3717.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2011,43,19521.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2011,51,5119.96);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2011,52,180229);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2011,53,5131.63);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2011,54,59454.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2011,61,24280.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2021,2011,62,55454.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2009,11,237408);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2009,21,4061840);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2009,31,1549490);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2009,32,419520);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2009,41,516.611);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2009,42,2147.28);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2009,43,23448.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2009,51,4812.04);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2009,52,106313);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2009,53,3403.43);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2009,54,39346.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2009,61,22155.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2009,62,54602.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2010,11,229222);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2010,21,4842790);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2010,31,2223420);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2010,32,594964);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2010,41,634.912);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2010,42,2162.89);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2010,43,20282.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2010,51,3771.54);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2010,52,103172);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2010,53,3009.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2010,54,48800.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2010,61,17481.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2010,62,42153.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2011,11,253826);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2011,21,4485880);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2011,31,2720220);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2011,32,746302);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2011,41,734.74);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2011,42,3609.99);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2011,43,18957.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2011,51,4904.08);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2011,52,172630);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2011,53,4915.26);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2011,54,56948);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2011,61,23733.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2022,2011,62,54204.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2009,11,221776);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2009,21,3452890);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2009,31,1387420);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2009,32,375640);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2009,41,497.228);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2009,42,2066.71);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2009,43,22569);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2009,51,4549.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2009,52,100520);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2009,53,3218.02);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2009,54,37203.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2009,61,21530.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2009,62,53063.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2010,11,214130);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2010,21,4401790);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2010,31,2008910);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2010,32,537562);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2010,41,611.09);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2010,42,2081.74);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2010,43,19521.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2010,51,3566.08);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2010,52,97551.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2010,53,2845.65);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2010,54,46142.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2010,61,16988.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2010,62,40965.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2011,11,237113);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2011,21,4269860);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2011,31,2479030);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2011,32,680133);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2011,41,712.685);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2011,42,3501.63);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2011,43,18388.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2011,51,4690.37);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2011,52,165107);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2011,53,4701.06);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2011,54,54466);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2011,61,23198.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2023,2011,62,52982.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2009,11,207375);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2009,21,2830560);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2009,31,1211840);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2009,32,328103);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2009,41,476.936);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2009,42,1982.32);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2009,43,21647.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2009,51,4282.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2009,52,94615.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2009,53,3028.98);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2009,54,35017.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2009,61,20885.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2009,62,51472.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2010,11,200224);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2010,21,3714980);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2010,31,1800770);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2010,32,481867);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2010,41,586.152);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2010,42,1996.74);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2010,43,18724.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2010,51,3356.58);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2010,52,91820.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2010,53,2678.48);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2010,54,43431.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2010,61,16479.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2010,62,39737);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2011,11,221715);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2011,21,3865190);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2011,31,2242120);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2011,32,615134);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2011,41,683.601);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2011,42,3358.64);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2011,43,17637.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2011,51,4414.81);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2011,52,155407);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2011,53,4424.88);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2011,54,51266.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2011,61,22502.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2024,2011,62,51393.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2009,11,193895);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2009,21,2236910);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2009,31,1049380);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2009,32,284115);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2009,41,452.743);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2009,42,1881.83);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2009,43,20549.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2009,51,3978.06);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2009,52,87887.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2009,53,2813.58);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2009,54,32527.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2009,61,20166.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2009,62,49701.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2010,11,187210);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2010,21,3013380);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2010,31,1573760);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2010,32,421122);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2010,41,561.371);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2010,42,1912.37);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2010,43,17933.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2010,51,3157.67);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2010,52,86379.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2010,53,2519.76);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2010,54,40857.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2010,61,16006.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2010,62,38597.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2011,11,207303);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2011,21,3233240);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2011,31,2010720);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2011,32,551647);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2011,41,654.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2011,42,3216.75);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2011,43,16892.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2011,51,4153.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2011,52,146197);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2011,53,4162.67);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2011,54,48228.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2011,61,21857.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2025,2011,62,49920.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2009,11,181227);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2009,21,1725390);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2009,31,900486);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2009,32,243804);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2009,41,429.447);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2009,42,1785);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2009,43,19492.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2009,51,3682.36);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2009,52,81354.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2009,53,2604.44);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2009,54,30109.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2009,61,19461.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2009,62,47964.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2010,11,174979);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2010,21,2373900);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2010,31,1362190);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2010,32,364507);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2010,41,532.486);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2010,42,1813.97);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2010,43,17010.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2010,51,2922.95);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2010,52,79958.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2010,53,2332.45);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2010,54,37820.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2010,61,15447.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2010,62,37248.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2011,11,193760);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2011,21,2615400);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2011,31,1756530);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2011,32,481913);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2011,41,626.628);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2011,42,3078.82);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2011,43,16168);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2011,51,3895.93);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2011,52,137141);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2011,53,3904.81);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2011,54,45240.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2011,61,21221);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2026,2011,62,48466.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2009,11,169436);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2009,21,1302650);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2009,31,768915);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2009,32,208182);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2009,41,400.778);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2009,42,1665.81);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2009,43,18190.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2009,51,3320.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2009,52,73366.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2009,53,2348.73);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2009,54,27153.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2009,61,18593.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2009,62,45825.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2010,11,163594);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2010,21,1823430);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2010,31,1171960);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2010,32,313605);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2010,41,502.017);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2010,42,1710.16);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2010,43,16037.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2010,51,2676.97);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2010,52,73229.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2010,53,2136.16);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2010,54,34637.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2010,61,14856.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2010,62,35824.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2011,11,181153);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2011,21,2052580);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2011,31,1524110);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2011,32,418147);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2011,41,590.773);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2011,42,2902.61);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2011,43,15242.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2011,51,3568.05);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2011,52,125600);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2011,53,3576.19);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2011,54,41433.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2011,61,20410);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2027,2011,62,46613.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2009,11,158557);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2009,21,972615);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2009,31,654756);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2009,32,177273);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2009,41,372.04);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2009,42,1546.37);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2009,43,16886.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2009,51,2980.13);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2009,52,65840.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2009,53,2107.78);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2009,54,24367.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2009,61,17671.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2009,62,43551.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2010,11,153090);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2010,21,1379000);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2010,31,1004390);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2010,32,268764);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2010,41,466.02);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2010,42,1587.54);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2010,43,14887.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2010,51,2402.34);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2010,52,65717);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2010,53,1917.01);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2010,54,31084.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2010,61,14119.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2010,62,34046.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2011,11,169521);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2011,21,1579100);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2011,31,1315830);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2011,32,361004);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2011,41,554.463);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2011,42,2724.22);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2011,43,14306);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2011,51,3254.31);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2011,52,114555);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2011,53,3261.73);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2011,54,37790.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2011,61,19541.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2028,2011,62,44630.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2009,11,148399);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2009,21,719261);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2009,31,555245);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2009,32,150331);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2009,41,340.514);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2009,42,1415.31);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2009,43,15455.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2009,51,2608.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2009,52,57636.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2009,53,1845.14);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2009,54,21331.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2009,61,16645.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2009,62,41023.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2010,11,143283);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2010,21,1030960);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2010,31,856908);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2010,32,229300);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2010,41,431.467);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2010,42,1469.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2010,43,13783.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2010,51,2140.42);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2010,52,58552);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2010,53,1708.01);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2010,54,27695.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2010,61,13402.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2010,62,32317.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2011,11,158662);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2011,21,1195690);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2011,31,1129760);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2011,32,309953);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2011,41,513.351);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2011,42,2522.18);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2011,43,13245);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2011,51,2899.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2011,52,102065);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2011,53,2906.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2011,54,33669.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2011,61,18549.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2029,2011,62,42363.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2009,11,138985);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2009,21,529323);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2009,31,469735);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2009,32,127180);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2009,41,311.897);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2009,42,1296.37);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2009,43,14156.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2009,51,2298.15);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2009,52,50773.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2009,53,1625.42);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2009,54,18791.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2009,61,15700.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2009,62,38695.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2010,11,134193);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2010,21,764429);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2010,31,728352);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2010,32,194900);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2010,41,395.207);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2010,42,1346.28);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2010,43,12624.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2010,51,1885.55);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2010,52,51579.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2010,53,1504.63);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2010,54,24397.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2010,61,12641.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2010,62,30483.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2011,11,148597);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2011,21,896189);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2011,31,966003);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2011,32,265027);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2011,41,475.603);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2011,42,2336.73);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2011,43,12271.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2011,51,2597.39);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2011,52,91431.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2011,53,2603.32);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2011,54,30161.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2011,61,17628.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2030,2011,62,40260.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2009,11,130424);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2009,21,389527);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2009,31,396716);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2009,32,107410);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2009,41,284.737);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2009,42,1183.48);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2009,43,12923.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2009,51,2019.23);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2009,52,44610.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2009,53,1428.15);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2009,54,16510.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2009,61,14799.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2009,62,36473.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2010,11,125927);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2010,21,565526);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2010,31,618081);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2010,32,165392);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2010,41,360.792);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2010,42,1229.05);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2010,43,11525.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2010,51,1656.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2010,52,45319.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2010,53,1322.01);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2010,54,21436.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2010,61,11916);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2010,62,28733.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2011,11,139443);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2011,21,667902);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2011,31,823532);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2011,32,225939);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2011,41,434.188);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2011,42,2133.24);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2011,43,11202.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2011,51,2282.16);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2011,52,80334.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2011,53,2287.35);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2011,54,26501.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2011,61,16616);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2031,2011,62,37948.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2009,11,122603);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2009,21,286049);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2009,31,334677);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2009,32,90612.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2009,41,254.308);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2009,42,1057.03);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2009,43,11542.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2009,51,1710.62);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2009,52,37792.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2009,53,1209.88);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2009,54,13987.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2009,61,13712.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2009,62,33795.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2010,11,118376);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2010,21,417484);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2010,31,523072);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2010,32,139969);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2010,41,326.517);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2010,42,1112.32);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2010,43,10430.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2010,51,1431.63);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2010,52,39162.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2010,53,1142.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2010,54,18524.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2010,61,11138.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2010,62,26858.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2011,11,131081);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2011,21,495645);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2011,31,700239);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2011,32,192114);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2011,41,392.94);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2011,42,1930.64);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2011,43,10138.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2011,51,1972.11);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2011,52,69420.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2011,53,1976.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2011,54,22900.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2011,61,15531.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2032,2011,62,35472.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2009,11,115395);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2009,21,209608);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2009,31,281501);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2009,32,76215.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2009,41,227.088);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2009,42,943.895);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2009,43,10307.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2009,51,1451.08);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2009,52,32058.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2009,53,1026.32);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2009,54,11865.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2009,61,12631.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2009,62,31130.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2010,11,111416);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2010,21,307114);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2010,31,441835);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2010,32,118231);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2010,41,291.569);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2010,42,993.27);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2010,43,9314.43);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2010,51,1214.43);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2010,52,33221.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2010,53,969.082);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2010,54,15713.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2010,61,10259.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2010,62,24740);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2011,11,123375);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2011,21,366521);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2011,31,593343);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2011,32,162786);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2011,41,355.555);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2011,42,1746.97);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2011,43,9173.97);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2011,51,1706.15);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2011,52,60058.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2011,53,1710.04);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2011,54,19812.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2011,61,14442.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2033,2011,62,32985.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2009,11,108577);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2009,21,152681);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2009,31,235817);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2009,32,63846.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2009,41,203.376);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2009,42,845.324);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2009,43,9231.06);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2009,51,1238.75);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2009,52,27367.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2009,53,876.133);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2009,54,10128.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2009,61,11654);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2009,62,28721.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2010,11,104834);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2010,21,223740);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2010,31,371076);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2010,32,99296);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2010,41,261.124);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2010,42,889.542);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2010,43,8341.74);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2010,51,1036.72);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2010,52,28359.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2010,53,827.276);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2010,54,13414.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2010,61,9466.11);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2010,62,22826);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2011,11,116087);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2011,21,268085);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2011,31,500459);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2011,32,137303);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2011,41,318.429);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2011,42,1564.53);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2011,43,8215.94);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2011,51,1456.49);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2011,52,51270.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2011,53,1459.81);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2011,54,16913.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2011,61,13325.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2034,2011,62,30433.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2009,11,102202);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2009,21,110431);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2009,31,196924);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2009,32,53316.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2009,41,179.345);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2009,42,745.442);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2009,43,8140.31);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2009,51,1032.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2009,52,22813);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2009,53,730.325);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2009,54,8443.19);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2009,61,10615.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2009,62,26163.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2010,11,98678);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2010,21,162507);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2010,31,310522);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2010,32,83092.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2010,41,233.356);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2010,42,794.947);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2010,43,7454.64);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2010,51,881.438);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2010,52,24112.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2010,53,703.368);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2010,54,11405.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2010,61,8707.13);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2010,62,20995.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2011,11,109270);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2011,21,194746);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2011,31,419867);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2011,32,115192);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2011,41,284.567);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2011,42,1398.16);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2011,43,7342.23);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2011,51,1238.33);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2011,52,43590.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2011,53,1241.15);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2011,54,14380);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2011,61,12257);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2035,2011,62,27993.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2009,11,96263.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2009,21,79642);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2009,31,163760);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2009,32,44337.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2009,41,157.657);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2009,42,655.297);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2009,43,7155.96);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2009,51,857.418);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2009,52,18942.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2009,53,606.428);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2009,54,7010.83);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2009,61,9704.93);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2009,62,23918.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2010,11,92944.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2010,21,117236);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2010,31,259065);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2010,32,69323);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2010,41,205.136);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2010,42,698.816);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2010,43,6553.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2010,51,731.907);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2010,52,20021.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2010,53,584.043);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2010,54,9470.29);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2010,61,7960.05);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2010,62,19194.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2011,11,102921);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2011,21,141090);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2011,31,351027);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2011,32,96305.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2011,41,253.595);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2011,42,1245.98);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2011,43,6543.17);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2011,51,1049.27);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2011,52,36935.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2011,53,1051.65);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2011,54,12184.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2011,61,11310.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2036,2011,62,25831.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2009,11,90719.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2009,21,57182.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2009,31,135889);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2009,32,36791.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2009,41,138.172);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2009,42,574.306);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2009,43,6271.53);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2009,51,709.898);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2009,52,15683.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2009,53,502.092);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2009,54,5804.62);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2009,61,8872.27);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2009,62,21866.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2010,11,87591.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2010,21,84295.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2010,31,215185);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2010,32,57581.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2010,41,179.784);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2010,42,612.446);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2010,43,5743.27);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2010,51,605.981);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2010,52,16576.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2010,53,483.559);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2010,54,7840.92);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2010,61,7277.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2010,62,17547.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2011,11,96993.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2011,21,101479);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2011,31,292524);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2011,32,80255.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2011,41,222.253);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2011,42,1091.99);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2011,43,5734.47);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2011,51,868.739);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2011,52,30580.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2011,53,870.718);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2011,54,10088.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2011,61,10340.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2037,2011,62,23615.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2009,11,85497.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2009,21,40902.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2009,31,112345);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2009,32,30417.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2009,41,118.52);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2009,42,492.614);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2009,43,5379.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2009,51,571.81);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2009,52,12633);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2009,53,404.426);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2009,54,4675.52);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2009,61,8055.21);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2009,62,19852.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2010,11,82549.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2010,21,60393.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2010,31,178372);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2010,32,47730.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2010,41,156.536);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2010,42,533.249);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2010,43,5000.55);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2010,51,498.823);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2010,52,13645.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2010,53,398.049);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2010,54,6454.38);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2010,61,6667.86);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2010,62,16078.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2011,11,91409.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2011,21,72809.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2011,31,242720);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2011,32,66591.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2011,41,193.516);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2011,42,950.78);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2011,43,4992.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2011,51,715.116);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2011,52,25172.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2011,53,716.745);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2011,54,8304.16);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2011,61,9474.43);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2038,2011,62,21638.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2009,11,152625);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2009,21,38401.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2009,31,98911.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2009,32,26823);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2009,41,108.409);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2009,42,452.004);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2009,43,4860.58);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2009,51,456.039);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2009,52,10075.3);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2009,53,322.544);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2009,54,3728.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2009,61,13451.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2009,62,31674.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2010,11,77786.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2010,21,42996.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2010,31,147209);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2010,32,39391.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2010,41,133.097);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2010,42,453.404);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2010,43,4251.82);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2010,51,397.829);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2010,52,10882.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2010,53,317.458);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2010,54,5147.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2010,61,5935.46);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2010,62,14312.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2011,11,86135.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2011,21,51921.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2011,31,200848);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2011,32,55103.5);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2011,41,167.173);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2011,42,821.359);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2011,43,4313.27);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2011,51,583.492);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2011,52,20539.7);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2011,53,584.822);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2011,54,6775.71);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2011,61,8528.35);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2039,2011,62,19477.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2010,11,114382);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2010,21,36972.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2010,31,122645);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2010,32,32824.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2010,41,115.617);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2010,42,396.055);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2010,43,3730.53);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2010,51,315.826);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2010,52,8639.53);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2010,53,252.021);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2010,54,4086.54);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2010,61,8532.93);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2010,62,20388.6);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2011,11,80757.8);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2011,21,36703.1);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2011,31,165078);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2011,32,45289.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2011,41,141.599);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2011,42,695.717);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2011,43,3653.48);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2011,51,463.218);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2011,52,16305.9);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2011,53,464.274);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2011,54,5379.04);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2011,61,7517.07);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2040,2011,62,17168);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2041,2011,11,106608);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2041,2011,21,33634.2);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2041,2011,31,143031);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2041,2011,32,39197.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2041,2011,41,124.234);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2041,2011,42,604.295);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2041,2011,43,3231.86);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2041,2011,51,370.143);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2041,2011,52,13029.4);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2041,2011,53,370.985);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2041,2011,54,4298.21);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2041,2011,61,8563.61);
INSERT INTO tmp_agetool.mvs14b_natlpop VALUES (2041,2011,62,19764.7);

-- Calculate "Scrappage Ratios"
INSERT INTO tmp_agetool.scrappageRatios 
	SELECT @byear as baseYearID, @fyear as futureYearID, a.sourceTypeID, a.modelYearID, a.nationwidePopulation/b.nationwidePopulation
    FROM tmp_agetool.mvs14b_natlpop a 
    LEFT JOIN tmp_agetool.mvs14b_natlpop b ON (a.sourceTypeID=b.sourceTypeID AND a.modelYearID=b.modelYearID)
    WHERE a.yearID=@fyear AND b.yearID=@byear
    ORDER BY a.sourceTypeID, a.modelYearID;

INSERT INTO tmp_agetool.sourceTypeAgeDistribution_original 
	SELECT * FROM sourceTypeAgeDistribution
	ORDER BY sourceTypeID, ageID;

-- Gap fill the "Recession Dip" in the Base Year using a linear interpolation method.
-- Restrict the gap filling to just the LDV sourceTypeIDs (21, 31, 32).
INSERT INTO tmp_agetool.sourcetypeagedistribution_gapfill 
	SELECT * FROM tmp_agetool.sourcetypeagedistribution_original;
UPDATE tmp_agetool.sourcetypeagedistribution_gapfill g, tmp_agetool.sourcetypeagedistribution_gapfill mdy2008, tmp_agetool.sourcetypeagedistribution_gapfill mdy2012  
	SET g.ageFraction = (g.ageID - mdy2012.ageID)/(mdy2008.ageID - mdy2012.ageID) * (mdy2008.ageFraction - mdy2012.ageFraction) + mdy2012.ageFraction
    	WHERE g.sourceTypeID IN (21, 31, 32) 
      	  AND @byear-g.ageID IN (2009, 2010, 2011) 
	  AND mdy2012.ageID=@byear-2012 AND mdy2008.ageID=@byear-2008 
      	  AND g.sourceTypeID=mdy2012.sourceTypeID AND g.sourceTypeID=mdy2008.sourceTypeID;

-- Calculate "Recession Ratios" as percent change from the gap-filled line to the original recession dip for model years 2009, 2010, and 2011.
INSERT INTO tmp_agetool.recessionratios
	SELECT a.sourceTypeID, @byear as baseYearID, @byear-a.ageID as modelYearID, a.ageID, (b.ageFraction-a.ageFraction)/a.ageFraction as pctReduction
    	FROM tmp_agetool.sourcetypeagedistribution_gapfill a, tmp_agetool.sourcetypeagedistribution_original b
    	WHERE a.ageID IN (@byear-2009, @byear-2010, @byear-2011) 
      	  AND a.sourceTypeID IN (21, 31, 32)
      	  AND a.sourceTypeID=b.sourceTypeID
      	  AND a.ageID=b.ageID;

-- Add the scrappage-dampened recession dip into the gap-filled age distribution, then re-normalize.
INSERT INTO tmp_agetool.sourcetypeagedistribution_final SELECT sourceTypeID, @fyear as yearID, ageID, ageFraction FROM tmp_agetool.sourcetypeagedistribution_gapfill;
UPDATE tmp_agetool.sourcetypeagedistribution_final f, tmp_agetool.recessionratios r, tmp_agetool.scrappageratios s
	SET f.ageFraction = f.ageFraction * (1 + r.pctReduction * s.scrappageRatio)
    		WHERE f.sourceTypeID IN (21, 31, 32)
      		 AND f.sourceTypeID=r.sourceTypeID 
      		 AND f.ageID=r.ageID+@fyear-@byear AND r.modelYearID=s.modelYearID
      		 AND f.sourceTypeID=s.sourceTypeID ;
-- Re-normalize.
CREATE TABLE tmp_agetool.sourcetypeagedistribution_final_denominators (sourceTypeID INTEGER, yearID INTEGER, sumOfAgeFraction DOUBLE);
INSERT INTO tmp_agetool.sourcetypeagedistribution_final_denominators
	SELECT sourceTypeID, yearID, sum(ageFraction)
    	FROM tmp_agetool.sourcetypeagedistribution_final
    	GROUP BY sourceTypeID, yearID;
UPDATE tmp_agetool.sourcetypeagedistribution_final f, tmp_agetool.sourcetypeagedistribution_final_denominators d
	SET f.ageFraction=f.ageFraction/d.sumOfAgeFraction
    	WHERE f.sourceTypeID=d.sourceTypeID AND f.yearID=d.yearID;

-- Place the updated age distribution in the CDB.
TRUNCATE sourceTypeAgeDistribution;
INSERT INTO sourceTypeAgeDistribution SELECT * FROM tmp_agetool.sourceTypeAgeDistribution_final ORDER BY sourceTypeID, ageID;

-- Drop the temporary database. Uncomment this if desired for QA purposes.
DROP DATABASE tmp_agetool;

