CHAPTER XXXIII 1992 Census of Manufactures and Census of Mineral Industries Numerical List of Manufactured and Mineral Products Abstract.......................................XXXIII-3 Introduction...................................XXXIII-7 File Specifications............................XXXIII-11 Database Structures............................XXXIII-13 User Notes.....................................XXXIII-23 1992 CENSUS OF MANUFACTURES AND CENSUS OF MINERAL INDUSTRIES NUMERICAL LIST OF MANUFACTURED AND MINERAL PRODUCTS Abstract CONTENTS Citation--------------------XXXIII-3 Type of File----------------XXXIII-3 Universe Description--------XXXIII-3 Subject-Matter Description--XXXIII-3 Geographic Coverage---------XXXIII-3 Technical Description-------XXXIII-3 Reference Materials---------XXXIII-4 Related Printed Reports-----XXXIII-4 Related Machine-Readable Data Files----------------XXXIII-4 Availability----------------XXXIII-5 CITATION Census of Manufactures and Mineral Industries on CD-ROM, 1992: Numerical List of Manufactured and Mineral Products [machine-readable data file] / prepared by the Bureau of the Census. -Washington: The Bureau [producer and distributor], 1993. TYPE OF FILE Reference information. UNIVERSE DESCRIPTION Manufacturing is defined as the mechanical or chemical transformation of substances or materials into new products. Mining is defined as the extraction of minerals occurring naturally: solids such as coal and ores, liquids such as petroleum, and gases such as natural gas. SUBJECT-MATTER DESCRIPTION These files present the code lists shown in the printed report of the same name. They are designed to assist a manufacturer or mining company in assigning codes to manufactured or mineral products. They may have a secondary use in helping data users anticipate what product classifications will be shown in the Industry Series of the 1992 Census of Manufactures and the 1992 Census of Mineral Industries. (The user should understand, however, that some of these categories may be combined when the statistics are published, in order to reduce the impact of disclosure or data quality problems.) The primary file MN92NUM.dbf includes all product classifications used in the census and in those Current Industrial Reports related to ``tie-lines'' in the census. GEOGRAPHIC COVERAGE Since these files include only product codes and descriptions, there is no geographic dimension. TECHNICAL DESCRIPTION File Structure: dBASE III+ Most files also have dBASE ``.NDX'' index files and one or more label files that can be linked to them (e.g., with SIC titles). MN92NUM-Product Descriptions (Corresponds to Tables 10 to 39 and appendixes A, D, E, and F.) 1. File sequence: Records relating to products as collected in the census, sequenced by SIC and sequence number, followed by products as collected in Current Industrial Reports that relate to tielines in the 1992 Census of Manufactures (from Appendix A) grouped by CIR, followed by categories for receipts for work done for others (Appendix D) and for selected nonmanufacturing or nonmining activities (Appendixes E and F). 2. Available indexes: a. MN92NUMP By product code (census and CIR categories together) b. MN92NUMC First record for each source code (generally specific CIR reports) 3. Linkable label files: a. MN92NCIR Titles of specific CIR reports b. MC87SIC SIC titles (1st four digits of product code) c. DATCOL Categories of data collected (production, shipments, etc.) MN92NUB-Product Descriptions in Production-Only Current Industrial Reports (not related to tielines in the census) (Corresponds Appendix B) 1. File sequence: Products grouped by applicable Current Industrial Report designation. 2. Available indexes: a. MN92NUBP By product code 3. Linkable label files: a. MN92NCIR Titles of specific CIR reports b. MC87SIC SIC titles (1st four digits of product code) c. DATCOL Categories of data collected (production, shipments, etc.) MN92N_G-Selected Product Classes and Products Primary to More than One Industry (Corresponds to Appendix G.) 1. File sequence: Pairs or groups of records appear together to highlight related product codes. 2. No available indexes MN92N_H-Selected Product Codes that Relate to the U.S. International Trade Commission Report, ``Synthetic Organic Chemicals'' (Corresponds to Appendix H.) 1. File sequence: By product code 2. No available indexes MN92NCIR-Current Industrial Reports Titles (Corresponds to Appendix C.) 1. File sequence: Grouped by CIR, which are generally in sequence by 2-digit SIC group, with separate records for each 5-digit product class covered. 2. Available index: a. MN92NCIR First record for each CIR title MN92NCOM-Comparability of Product Classes and Product Codes: 1992 and 1987 (Corresponds to Appendixes I and J.) 1. File sequence: One record for each combination of 1992 and 1987 product codes, as collected in the censuses. 2. Available indexes: a. MN92NC92 By 1992 product code b. MN92NC87 By 1987 product code 3. Linkable label file: a. MN92NUM (1992 product descriptions) REFERENCE MATERIALS 1987 Economic Censuses CD-ROM 1E, Technical Documentation. This documentation has general information, glossaries, record layouts for all files, and other reference material. One copy accompanies each CD-ROM order. Additional copies are available for $10 from Customer Services, Bureau of the Census, Washington, DC 20233. Guide to the 1992 Economic Census and Related Statistics. Describes the scope, coverage, classification systems, data items, and data products for each of the economic censuses and related surveys. Data comparability and uses are also discussed. Single copies are free from Customer Services, Bureau of the Census, Washington, DC 20233. (To be published in 1994.) Standard Industrial Classification Manual, 1987. Prepared by the Executive Office of the President, Office of Management and Budget, and available from the Superintendent of Documents, U.S. Government Printing Office, Washington, DC 20402. Price is $24. RELATED PRINTED REPORTS 1992 Census of Manufactures and Census of Mineral Industries, Reference Series: Numerical List of Manufactured and Mineral Products. Presents the same reference information contained in these files. 1992 Census of Manufactures/Census of Mineral Industries: Preliminary Industry Series/Final Industry Series. These four series present statistics classified by the product categories defined in these files. (To be published in 1994 and 1995.) RELATED MACHINE-READABLE DATA FILES 1992 Economic Census CD-ROM Volume 1. CD-ROMs from the 1992 census will contain statistics classified by the product categories defined here, as part of the data files from the census of manufactures and the census of mineral industries. (To be issued, in groups of industries, beginning in mid 1994; preliminary data first (including only census categories) followed by final reports (including both census and CIR categories. AVAILABILITY All of these files are included on Economic Census CD-ROM 1E (price $150). 1992 CENSUS OF MANUFACTURES AND CENSUS OF MINERAL INDUSTRIES NUMERICAL LIST OF MANUFACTURED AND MINERAL PRODUCTS Introduction CONTENTS Purpose----------------------XXXIII-7 Product Coding System--------XXXIII-7 Comparability Between 1992 and 1987--------------XXXIII-7 Current Industrial Reports (CIR)--------------XXXIII-8 Format of Manual-------------XXXIII-8 Changes In Product Classes---XXXIII-8 Abbreviations----------------XXXIII-8 PURPOSE This numerical list includes the principal products and services of the manufacturing and mining industries in the United States. The data for these products and services were collected in the 1992 Census of Manufactures on 213 long forms (MC - 2001 through MC - 3912) and 78 short report forms (MC - 2071 through MC - 3975) and in the 1987 Census of Mineral Industries on 10 long (MC - 1001 through MC - 1403) and 2 short forms (MC - 1371 and MC - 1471). Each report form covers one industry or more and includes a product inquiry which lists the primary products of the industries as well as the chief secondary products frequently reported by establishments classified in the industries on that report form. Products and services are arrayed generally in ascending seven-digit numerical order followed by alphabetical characters within their respective five-digit codes (product classes), the product classes in order within their four-digit codes (industries), and the industries within their three- digit industry groups and two-digit major groups. Major groups, industry groups, and industries, as presented in this manual, are in accord with both title and content of the Standard Industrial Classification Manual: 1987 edition, published by the Office of Management and Budget. In addition to the more than 6,300 products for which information is collected primarily in the censuses of manufactures and mineral industries, there are over 4,500 products for which information is collected monthly, quarterly, and annually in the Census Bureau's Current Industrial Reports (CIR) program. Where CIR product detail is available, the census report requests only broad aggregates that can be ``tied in'' with the product detail in the CIR program. PRODUCT CODING SYSTEM Each product or service is assigned a seven-digit code. The product coding structure represents an extension by the Bureau of the Census of the four-digit industrial classification of the manufacturing and mining industries as defined in the Standard Industrial Classification (SIC) System. The SIC, developed under the direction of the Office of Management and Budget by the Technical Committee on Industrial Classification, classifies establishments to the four-digit industry level by their primary type of activity. The classification system operates so that the industrial coverage is progressively narrower with the successive addition of digits. This is illustrated as follows: SIC Code Level Description 20 Major group Food and kindred products 202 Industry group Dairy products 2022 Industry Cheese, natural, and processed 20225 Product class Cheese substitutes 20225 11 Product Products substituting for natural cheese COMPARABILITY BETWEEN 1992 AND 1987 This manual attempts to preserve the historical comparability between the 1992 and 1987 censuses for product classes and product codes in file MN92NCOM.dbf. In its original sequence or when used in conjunction with MN92NC92.ndx, file MN92NCOM.dbf presents the linkage from 1992 to 1987. When used with MN92NC87.ndx, the file provides the mirror-type linkage from 1987 to 1992. CURRENT INDUSTRIAL REPORTS (CIR) The 1992 Census of Manufactures, as in earlier censuses, utilizes the tieline product method for reporting summary information in the census where product detail is being reported for the same period in a CIR or, in a few instances, surveys conducted by other Federal Government agencies. The product detail that is collected monthly, quarterly, or annually in the CIR is not duplicated in the census of manufactures. Instead a single (tieline) code is collected in the census that corresponds to the sum of the detail appearing if the CIR is used. For tielines related to the CIR, the product detail covered in the commodity surveys comprises, additionally, more than 4,500 product lines, each coded to the seven-digit level. The products collected in the CIR are shown in files MN92NUM.dbf and MN92NUB.dbf, ``Product Descriptions in the 1992 Census of Manufactures and Current Industrial Reports that Relate to Tielines in 1992 Census of Manufactures'' and ``Product Descriptions in Production-Only Current Industrial Reports.'' The product coding used for the census and for the CIR constitutes a body of product codes slightly less than 11,000 items. FORMAT OF MANUAL In this numerical list, there is one product code column that corresponds to product codes used in the 1992 publications and are based on the 1987 SIC structure. Appended to each seven-digit product code is an eighth digit called the ``check digit'' used to verify the keying of product codes for computer processing. The check digit is developed from the seven-digit product code itself but is not part of the product code. The sixth and seventh digits of the product code taken together are unique and identify the product. Occasionally, the sixth digit will be similar for a group of related products within the product class but the sixth digit by itself is not significant. These products and services codes are arrayed (generally) in ascending numerical order followed by alphabetical characters within their respective five-digit product classes, the product classes within their four-digit industries, the industries within their three-digit industry groups, and the industry groups within their two-digit major groups. Major groups, industry groups, and industries are titled in accordance with the short SIC titles shown in Part II, Numerical List of Short Titles, Standard Industrial Classification Manual, 1987 edition. Titles and descriptions of the five-digit product classes and seven-digit products have been developed by the Bureau of the Census. The titles of the two- to five-digit levels are shown in capital letters. To the right of each four-digit industry title is the number of the report form used in the censuses to collect the information for products and services of that industry (for example, MC-1001). The product code, check digit, product description, unit of measure for quantity data collected, and kinds of data collected are given for each product. (See abbreviations section for key to the abbreviations used for unit of quantity and data collected.) This set includes six dBase files that correspond to the main body and ten appendixes shown in the hard-copy publication. File MN92NUM.dbf includes the product detail brought into the census by tielines to the CIR (from appendix A). File MN92NUB.dbf (from appendix B) includes the product detail from special production-related surveys of the CIR. File MN92CIR.dbf (from appendix C) relates these Current Industrial Reports to their Census tielines. Lines from appendixes D, E, and F are included at the end of the main file MN92NUM.dbf, and contain the codes for the contract and miscellaneous receipts reported by manufacturing and mining establishments. File MN92N_G.dbf shows those products that are primary to more than one industry; that is, produced elsewhere but by a different process. File MN92N_H.dbf provides the list of Census product codes that relate to the U.S. International Trade Commission Report, ``Synthetic Organic Chemicals.'' Finally, file MN92NCOM.dbf (from appendixes I and J) illustrate the relationship between the 1992 and 1987 product classifications. CHANGES IN PRODUCT CLASSES For the 1992 Census of Manufactures, data were collected on 1,462 product classes compared with 1,446 in the 1987 census. ABBREVIATIONS The phrase ``To be spec'' indicates that the unit of measure is specified by the reporting establishment. The abbreviation ``n.e.c.'' means not elsewhere classified. Unit of Measure bbls Barrel bd Board Btu British thermal unit co Consumed cu Cubic cwt Hundredweight doz Dozen equiv Equivalent fin Finished ft Feet gal Gallon hr Hour lum Lumber lb Pounds lin Linear mil Millions no Number oz Ounces qt Quarts sm Surface measure sngl Single sol Solids sq Square st Strength std Standard yd Yards Data Collected C Consumption CC Circulation copies I Inventory (stock) ISV Interplant shipments (value) P Production (quantity) PC Produced and consumed (quantity) PV Production (value) R Receipts (value) RA Receipts from advertising RAC Receipts from advertising and copy sales RC Receipts from single copy sales RQ Receipts (quantity) RS Receipts from subscriptions and sales RSB Receipts from subscriptions S Shipments (quantity and value) SQ Shipments (quantity) SV Shipments (value) UO Unfilled orders (value) UOQ Unfilled orders (quantity) VW Value of work done 1992 CENSUS OF MANUFACTURES AND CENSUS OF MINERAL INDUSTRIES NUMERICAL LIST OF MANUFACTURED AND MINERAL PRODUCTS File Specifications CONTENTS General Data Specifications--XXXIII-11 GENERAL DATA SPECIFICATIONS Data Fields. All files are recorded in dBase III+ format. Numeric data fields contain no alphabetic information. Index Files. Most of these data files have one or more index files that may be used to jump quickly to desired records (e.g., using the dBase FIND command) or to change the sequence of access. Available index files are listed in the abstract. Where noted in the abstract that an index is to the ``first record for'' a particular type of record, the index can be used during dBase FINDs, but the index must be shut off with SET INDEX TO in order to get access to records other than the first for each geographic area or SIC. DATABASE STRUCTURE Files MN92NUM and MN92NUB: 1992 Manufactured and Mineral Products from 1992 Census and CIRs --------------------------------------------------------------------------- Field Field Name Type Size Decimal Field Description --------------------------------------------------------------------------- SOURCE C 5 0 Census (-), CIR (series no.), or special appendix (D,E,F) PRODUCT C 7 0 1992 product class or product code CKDIG C 1 0 Check digit TEXT C 200 0 Description UNIT C 30 0 Unit of measure DATCOL C 5 0 Codes for data items collected SEQNUM C 8 0 Sequence number (separate numbers for census and CIRs) Record size: 257 1992 Census of Manufactures and Census of Mineral Industries Numerical List of Manufactured and Mineral Products DATABASE STRUCTURE File MN92N_G: 1992 Products Primary to More than One Industry --------------------------------------------------------------------------- Field Field Name Type Size Decimal Field Description --------------------------------------------------------------------------- PRODUCT C 7 0 1992 product class or product code TEXT C 121 0 Description Record size: 129 1992 Census of Manufactures and Census of Mineral Industries Numerical List of Manufactured and Mineral Products DATABASE STRUCTURE File MN92N_H: 1992 Products Related to US ITC "Synthetic Organic Chemicals" --------------------------------------------------------------------------- Field Field Name Type Size Decimal Field Description --------------------------------------------------------------------------- PRODUCT C 7 0 1992 product class or product code SECTION C 4 0 Section in the US ITC report TEXT C 75 0 Description Record size: 87 1992 Census of Manufactures and Census of Mineral Industries Numerical List of Manufactured and Mineral Products DATABASE STRUCTURE File MN92NCIR: Current Industrial Report Titles --------------------------------------------------------------------------- Field Field Name Type Size Decimal Field Description --------------------------------------------------------------------------- PRODUCT C 7 0 1992 product class or product code SOURCE C 5 0 Census (-), CIR (series no.), or special appendix (D,E,F) CIRSURVY C 61 0 Title Record size: 74 1992 Census of Manufactures and Census of Mineral Industries Numerical List of Manufactured and Mineral Products DATABASE STRUCTURE File MN92NCOM: Comparability of 1992 and 1987 Product Codes --------------------------------------------------------------------------- Field Field Name Type Size Decimal Field Description --------------------------------------------------------------------------- PRODUCT C 7 0 1992 product class or product code P C 1 0 1992 part indicator (p=part) PROD87 C 7 0 1987 product class or product code P87 C 1 0 1987 part indicator (p=part) Record size: 17 1992 CENSUS OF MANUFACTURES AND CENSUS OF MINERAL INDUSTRIES NUMERICAL LIST OF MANUFACTURED AND MINERAL PRODUCTS User Notes This section will contain information relevant to the 1992 Numerical List of Manufactured and Mineral Products that indicates specific problems with the data, or that becomes available after the file is released. The cover letter to the updated information should be filed behind this page. User Notes will be sent to all users who (1) purchased their file (or technical documentation) from the Census Bureau and (2) returned the coupon following the CD-ROM File Information.