Creating and managing an impossibly large CGE database that is up-to-date

g-175.pdf - Published Version (191kB) | Preview
Available under license: Creative Commons Attribution

Horridge, Mark ORCID: 0000-0002-1070-5763 and Wittwer, Glyn (2008) Creating and managing an impossibly large CGE database that is up-to-date. Working Paper. Centre of Policy Studies (COPS).


Large-scale multi-regional CGE models of Australia, such as MMRF and TERM, underlie most CoPS consulting work. The regional detail, modelled in bottom-up fashion, greatly interests policy makers and is often needed to answer questions like: how would less rainfall in southern Australia affect the economy? To support this work, we have devised a variable disaggregation master database for any combination of over 1,400 statistical local areas (SLAs). Such a database may represent 172 sectors in over 100 regions. It would be slow to run simulations with so much detail, so we routinely aggregate the database before using it. Each aggregation is tailored to preserve the regional and sectoral detail that is pertinent to a particular policy issue. This paper describes the procedure used to generate a master database, starting from a published national 2001-2 input-output table, and various international trade and census data from other dates. A levels adjustment program is used to update the published input-output table from 2001-02 to 2005-06. This makes it easier to use regional data from national accounts and the 2006 census. The whole procedure is automated via a series of programs. This forms a basis for documentation and also allows us to repeat the whole procedure with different inputs. For example, we could reaggregate the SLAs to distinguish zones within each capital city, if desired. Some of our methods may be useful in global CGE models as practitioners modify databases to deal with policy issues. We have adapted the methodology of variable disaggregation to develop the first ever bottom-up representation of the Australian economy by its 150 federal electorates.

Additional Information

CoPS/IMPACT Working Paper Number G-175.
Later published version in: 'Bringing Regional Detail to a CGE Model using Census Data', Spatial Economic Analysis, Volume 5 Issue 2, pp 229-255, June 2010, Routledge

Item type Monograph (Working Paper)
Official URL
ISBN 0732615828
Subjects Historical > FOR Classification > 1403 Econometrics
Current > Division/Research > Centre of Policy Studies (CoPS)
Keywords C68; C81; R13; R15; regional modelling; CGE modelling; database development
Download/View statistics View download statistics for this item

Search Google Scholar

Repository staff login