======================================================================== July 1994 updated April 2002 Baldwin-Green Study Canada-US Census of Industry 1867 - 1940 See Documentation held in Social Science Data Centre Documents Unit, Queen's University Kingston, Ontario K7L 5C4 Documentation Call No.: CA2 ON UQ 90C17 Vols 1 & 2 COMPARISON OF CANADIAN AND U.S. INDUSTRY: 2-DIGIT SIC CODES, 1867-1940 -- US DATA -- FILE NAME: MERGUS.txt CONTENTS: Documentation for the file "MERGUS.xls" (Microsoft Excel 2000) File resaved in MS-EXCEL 2000 format in April 2002 This file documents the column headings found in the spreadsheet files listed above. All files listed here are identical -- they have just been saved in different spreadsheet formats. OVERVIEW: "MERGUS.xls" is the final merged file for the UNITED STATES data from the Green-Baldwin SSHRC project conducted in the 1980's. These data represent the final merged file for the CANADA-US MANUFACTURING COMPARISON at the 2-digit SIC code level. Data span from 1900 to 1940. A series of historical price indices for various industries have been included, covering the period 1890 to 1940. These data were taken from THE HISTORICAL STATISTICS OF THE UNITED STATES (HSUS), VOLUME 1. The series used were E13-24. The 'NEW' series, as they are labeled, are the prices from the HSUS re-calibrated to have 1935-39=1.0. This was done to match the Canadian data. These price indices are found in the last few columns of the spreadsheet. FILE CREATION: Data were transferred from a SAS 82.3 print output dated 1987. The work of transferring these data was done by Mark Smith, a graduate student in Economics, in July 1994. ACKNOWLEDGEMENTS: The Baldwin-Green project was graciously supported by SSHRC Grant # 410-83-0439 R-1. For more complete information on matchings, sources and derivation of the numbers, see the 'Background' binders available from Queen's Professor Alan G. Green or the Queen's Documents Library. The corresponding paper written by Baldwin and Green, for the Belagio Conference in 1986, exists only in hard copy form, and may be available from Professor Green. A copy of this paper has been added to the data file documentation in the Documents Library. HEADINGS: Each industry has a similar set of headings, with different individual industry codes. Replace the asterisk with the appropriate industry code (see next section). 1) Number of establishments........... NEST*U 2) Number of employees................ NEMP*U 3) Salary and wages................... SAW*U 4) Gross Value of Production.......... GRPRO*U 5) Cost of materials used............. CMAT*U 6) Value added........................ VA*U 7) Average value added................ AVA*U = [VA*U/NEST*U] 8) Average value of gross production.. AGRPRO*U = [GRPRO*U/NEST*U] INDUSTRY CODES: Each US variable has an extra letter added to the end of the variable name, which relates it to its industry. A "U" has been added to the end of each variable, indicating "US", to differentiate these variables from those in the Canadian file. The following letter codes have been used: Industry Character example ------------------------------------------------------------ Wood W VAWU Tobacco products T NESTTU Food and Beverage F AVAFU Leather L GRPROLU Paper and allied industries P VAPU Petroleum and Coal Products O VAOU Rubber and plastics R AVARU Textiles X VAXU Printing and publishing B VABU Chemical products H VAHU Apparell and clothing C VACU Electrical E VAEU Instruments V VAVU Stone, Minerals and Glass G VAGU Furniture U VAUU {note: the following have only 2 years are entered, 1938 & 1940} Fabricated metal products D VADU Primary metal industries J VAJU Machinery (except elec.) Q VAQU Transportation Equipment S VASU COMMENTS: Matching records indicate that, at one time, census records matched for all the Canadian data. It is strange, therefore, that some of the files are incomplete, and major industries such as IRON AND STEEL have been excluded. Where do 'instruments' or 'glass' fit? Canadian entries for NON-METALLIC and NON-FERROUS seem to have no like entries here. Should 'KNITTING' be included with TEXTILES? Should FURNITURE be included with WOOD? These questions may be never answered. PRICE INDICES: The following price indices are included in the file: All comodities GENU Food products FOODU Farm products FARMU Hides and leather products LEATU Building materials BUILU fuel and lighting FUELU Chemical and allied products CHEMU Metals and metal products METAU House furnishing products HOUSU Textiles TEXTU These price indices are set with 1926 = 100. The following series use 1935-39 = 1.00 as a base, and are denoted 'NEW". NEWGENU NEWFUELU NEWTEXTU NEWCHEMU NEWFARMU NEWFOODU NEWMETAU NEWHOUSU NEWLEATU NEWBUILU