Layout of store_openings.cvs file

 

March 3, 2010

 

File used in paper The Diffusion of Wal-Mart and Economies of Density, Econometrica, Vol. 79, No. 1 (January, 2011), 253-302

 

by

Thomas J. Holmes

University of Minnesota, Federal Reserve Bank of Minneapolis, and NBER

holmes@umn.edu

 

Description of File:

Opening dates of Wal-Mart stores and Supercenters, 1962-Jan 31, 2006 (Alaska and Hawaii excluded)

As discussed in the appendix of the paper, this file was constructed as follows: In November 2005, Wal-Mart made public a file which listed for each Wal-Mart store the address, store number, store type (supercenter or regular store) and opening date. This data was combined with additional information posted at Wal-Mart's web site about openings through January 31, 2006 (the end of fiscal year 2006). The opening date mentioned above is the date of the original store opening, not the date of any later conversion to a supercenter. To get the date of supercenter conversions, I used two pieces of information. From annoucements at Wal-Mart's website, I determined the dates of conversions taking place in 2001 and after. To get the dates of conversions taking place before 2001, I used data collected by Emek Basker (see Basker (2005)) based on published directories.

 

Store Count: There are 3176 Wal-Mart stores in the data file. Of these, 1980 are supercenters and 1196 are regular Wal-Mart stores.

 

 

Variable Name

Description

OPENDATE

Opening date of original store

STRCITY

City of store (source Wal-Mart store alignment file and posted openings)

STREETADDR

Address of store (source Wal-Mart store alignment file and posted openings)

STRSTATE

State of store (source Wal-Mart store alignment file and posted openings)

ZIPCODE

Zip of store (source Wal-Mart store alignment file and posted openings)

conversion

=1 if supercenter through conversion of existing store, =0 if supercenter originally

county

FIPS code of county

date_super

Opening date of food business

st

FIPS code of state

storenum

Permanant store number assigned by Wal-Mart

type_store

Store type as of Jan 31, 2006