INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('c2f6','past','c2f6-historical.tar.gz','gz',41482629,(select id from ghgasfilenamelabel where filenamelabel = 'c2f6' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('c3f8','past','c3f8-historical.tar.gz','gz',32231681,(select id from ghgasfilenamelabel where filenamelabel = 'c3f8' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('c4f10','past','c4f10-historical.tar.gz','gz',31984115,(select id from ghgasfilenamelabel where filenamelabel = 'c4f10' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('c5f12','past','c5f12-historical.tar.gz','gz',32291394,(select id from ghgasfilenamelabel where filenamelabel = 'c5f12' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('c6f14','past','c6f14-historical.tar.gz','gz',32345683,(select id from ghgasfilenamelabel where filenamelabel = 'c6f14' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('c7f16','past','c7f16-historical.tar.gz','gz',32343079,(select id from ghgasfilenamelabel where filenamelabel = 'c7f16' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('c8f18','past','c8f18-historical.tar.gz','gz',31849668,(select id from ghgasfilenamelabel where filenamelabel = 'c8f18' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('carbon-dioxide','past','carbon-dioxide-historical.tar.gz','gz',150659208,(select id from ghgasfilenamelabel where filenamelabel = 'carbon-dioxide' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('carbon-tetrachloride','past','carbon-tetrachloride-historical.tar.gz','gz',156038594,(select id from ghgasfilenamelabel where filenamelabel = 'carbon-tetrachloride' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('c-c4f8','past','c-c4f8-historical.tar.gz','gz',32414475,(select id from ghgasfilenamelabel where filenamelabel = 'c-c4f8' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('cf4','past','cf4-historical.tar.gz','gz',43166690,(select id from ghgasfilenamelabel where filenamelabel = 'cf4' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('cfc113','past','cfc113-historical.tar.gz','gz',34650288,(select id from ghgasfilenamelabel where filenamelabel = 'cfc113' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('cfc114','past','cfc114-historical.tar.gz','gz',33817815,(select id from ghgasfilenamelabel where filenamelabel = 'cfc114' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('cfc115','past','cfc115-historical.tar.gz','gz',32165866,(select id from ghgasfilenamelabel where filenamelabel = 'cfc115' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('cfc11eq','past','cfc11eq-historical.tar.gz','gz',147188049,(select id from ghgasfilenamelabel where filenamelabel = 'cfc11eq' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('cfc11','past','cfc11-historical.tar.gz','gz',281126792,(select id from ghgasfilenamelabel where filenamelabel = 'cfc11' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('cfc12eq','past','cfc12eq-historical.tar.gz','gz',146823220,(select id from ghgasfilenamelabel where filenamelabel = 'cfc12eq' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('cfc12','past','cfc12-historical.tar.gz','gz',180045595,(select id from ghgasfilenamelabel where filenamelabel = 'cfc12' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('ch2cl2','past','ch2cl2-historical.tar.gz','gz',166635411,(select id from ghgasfilenamelabel where filenamelabel = 'ch2cl2' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('ch3ccl3','past','ch3ccl3-historical.tar.gz','gz',32912055,(select id from ghgasfilenamelabel where filenamelabel = 'ch3ccl3' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('chcl3','past','chcl3-historical.tar.gz','gz',152166137,(select id from ghgasfilenamelabel where filenamelabel = 'chcl3' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('halon1211','past','halon1211-historical.tar.gz','gz',142387078,(select id from ghgasfilenamelabel where filenamelabel = 'halon1211' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('halon1301','past','halon1301-historical.tar.gz','gz',32724791,(select id from ghgasfilenamelabel where filenamelabel = 'halon1301' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('halon2402','past','halon2402-historical.tar.gz','gz',32627255,(select id from ghgasfilenamelabel where filenamelabel = 'halon2402' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hcfc141b','past','hcfc141b-historical.tar.gz','gz',30321809,(select id from ghgasfilenamelabel where filenamelabel = 'hcfc141b' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hcfc142b','past','hcfc142b-historical.tar.gz','gz',31686173,(select id from ghgasfilenamelabel where filenamelabel = 'hcfc142b' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hcfc22','past','hcfc22-historical.tar.gz','gz',34169743,(select id from ghgasfilenamelabel where filenamelabel = 'hcfc22' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hfc125','past','hfc125-historical.tar.gz','gz',32118205,(select id from ghgasfilenamelabel where filenamelabel = 'hfc125' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hfc134aeq','past','hfc134aeq-historical.tar.gz','gz',45526810,(select id from ghgasfilenamelabel where filenamelabel = 'hfc134aeq' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hfc134a','past','hfc134a-historical.tar.gz','gz',75935672,(select id from ghgasfilenamelabel where filenamelabel = 'hfc134a' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hfc143a','past','hfc143a-historical.tar.gz','gz',31803412,(select id from ghgasfilenamelabel where filenamelabel = 'hfc143a' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hfc152a','past','hfc152a-historical.tar.gz','gz',31597896,(select id from ghgasfilenamelabel where filenamelabel = 'hfc152a' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hfc227ea','past','hfc227ea-historical.tar.gz','gz',48799970,(select id from ghgasfilenamelabel where filenamelabel = 'hfc227ea' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hfc236fa','past','hfc236fa-historical.tar.gz','gz',31653623,(select id from ghgasfilenamelabel where filenamelabel = 'hfc236fa' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hfc23','past','hfc23-historical.tar.gz','gz',66764925,(select id from ghgasfilenamelabel where filenamelabel = 'hfc23' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hfc245fa','past','hfc245fa-historical.tar.gz','gz',29557704,(select id from ghgasfilenamelabel where filenamelabel = 'hfc245fa' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hfc32','past','hfc32-historical.tar.gz','gz',49625587,(select id from ghgasfilenamelabel where filenamelabel = 'hfc32' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hfc365mfc','past','hfc365mfc-historical.tar.gz','gz',30392766,(select id from ghgasfilenamelabel where filenamelabel = 'hfc365mfc' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('hfc4310mee','past','hfc4310mee-historical.tar.gz','gz',30915292,(select id from ghgasfilenamelabel where filenamelabel = 'hfc4310mee' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('methane','past','methane-historical.tar.gz','gz',155910216,(select id from ghgasfilenamelabel where filenamelabel = 'methane' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('methyl-bromide','past','methyl-bromide-historical.tar.gz','gz',149017846,(select id from ghgasfilenamelabel where filenamelabel = 'methyl-bromide' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('methyl-chloride','past','methyl-chloride-historical.tar.gz','gz',136022646,(select id from ghgasfilenamelabel where filenamelabel = 'methyl-chloride' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('nf3','past','nf3-historical.tar.gz','gz',31986224,(select id from ghgasfilenamelabel where filenamelabel = 'nf3' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('nitrous-oxide','past','nitrous-oxide-historical.tar.gz','gz',145420563,(select id from ghgasfilenamelabel where filenamelabel = 'nitrous-oxide' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('sf6','past','sf6-historical.tar.gz','gz',33187520,(select id from ghgasfilenamelabel where filenamelabel = 'sf6' limit 1));
INSERT INTO filesizes (ghgfilenamelabel, tense,filename, filetype, filesize, ghg) VALUES ('so2f2','past','so2f2-historical.tar.gz','gz',49624907,(select id from ghgasfilenamelabel where filenamelabel = 'so2f2' limit 1));
