Layout of ea_pop07 file

(Note: there is a SAS version of the file and an ascii version, with different layouts)

 

Aug 1, 2012

 

Description of Supplementary Files for “An Alternative Theory of the Plant Size Distribution, with Geography and Intra- and International Trade”

by

Thomas J. Holmes (University of Minnesota, Federal Reserve Bank of Minneapolis, and NBER

and

John J. Stevens (Board of Governors of Federal Reserve System)

 

Note: The statistics reported in this file are all derived from public Census data

 

Description of SAS File (ea_pop07.sas7bdat)

The file contains Economic Area (EA) Level information for the 177 EAs including population and geographic coordinates.  We use the 2004 definition EA definition.  See 2004 definition, see Johnson and Kort (2004), as cited in the paper.  The EAs are aggregates of counties.

 

Variable

Description

ea

Economic Area code (ea) used by the BEA, going from 1 to 179

ea_index

A code we use for our project.  We delete Alaska and Hawaii, leaving us with 177 EAs.  We number the remaining EAs from 1 to 177

pop2007_US

US estimated population for 2007 across the 177 EAs (so excluding AK and HI).

pop2007

An estimate of ea level population for 2007.  The source of the county-level data is a file CO-EST2008-ALLDATA.csv downloaded from http://www.census.gov/popest/counties/.  This file provides county level population estimates for 2007.  We aggregate these up to the ea level.

 

 

Description of ASCII File (ea_pop07.asc)

This is just like above, except in ASCII format for reading into Gauss.  In particular, there is no header row there four columns of data, where the column are the following:

 

Column

Variable from Above

1

eaindex

2

ea

3

pop2007

4

pop2007_US