CHAPTER XXVII Census of Mineral Industries Geographic Area Series Abstract.......................................XXVII-3 Introduction...................................XXVII-5 Glossary.......................................XXVII-9 File Specifications............................XXVII-13 Database Structures............................XXVII-15 User Notes.....................................XXVII-17 CENSUS OF MINERAL INDUSTRIES GEOGRAPHIC AREA SERIES Abstract CONTENTS Citation-------------------------------XXVII 3 Type of File---------------------------XXVII 3 Universe Description-------------------XXVII 3 Subject-Matter Description-------------XXVII 3 Geographic Coverage--------------------XXVII 3 Technical Description------------------XXVII 3 Reference Materials--------------------XXVII 4 Related Printed Reports----------------XXVII 4 Related Machine-Readable Data Files----XXVII 4 Availability---------------------------XXVII 4 CITATION Census of Mineral Industries on CD-ROM, 1987: Geographic Area Series [machine-readable data file] / prepared by the Bureau of the Census. Washington: The Bureau [producer and distributor], 1993. TYPE OF FILE Summary statistics UNIVERSE DESCRIPTION The universe of these files is establishments with one or more paid employees primarily engaged in mining. 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 data are exactly the same as shown in tables 2a and 5 of the printed Geographic Area Series reports, plus corresponding data for the U.S. from the General Summary report in the Subject Series. There are no files corresponding to other tables in the Geographic Area, Subject, or Industry Series reports from the 1987 Census of Mineral Industries. This file provides the number of establishments, number of employees, payroll, value of shipments, value added, cost of materials, and capital expenditures, classified by the 2-, 3-, and 4-digit SIC in which they are primarily engaged. GEOGRAPHIC COVERAGE Data are provided for the U.S., States, and counties with 100 or more employees in mineral industries. (County data are limited to 2- and 3-digit SIC detail.) Pseudo-county records (COUNTY code = 886) are provided for offshore areas associated with several States (AK, CA, LA, TX) as well as for three offshore areas not associated with any State (Atlantic, Northern Gulf of Mexico, and Pacific). TECHNICAL DESCRIPTION File Structure: dBASE III+ MN87A1 General Statistics for U.S., States, and Counties, 1987 1. File sequence: U.S. records, followed by records for each State and county. States are sequenced alphabetically within the U.S., and counties appear in alphabetic sequence within State. 2. Available indexes: a. MN87A1CO: First record for each State and county b. MN87A1SI: By SIC by State by county 3. Linkable label files: a. MN87SIC (SIC titles) b. MSA (full titles for MSA's, CMSA's, and PMSA's note codes appear on records but there are no MSA summaries in MN87A1.dbf) c. MC87MISC (record type labels, and % of shipments estimated) d. STCODE (state names) e. STCOUNTY (county names) 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 1987 Economic Censuses 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. 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 1987 Census of Mineral Industries, Geographic Area Series. Data for the 50 States and the District of Columbia were issued in nine reports, one for each of the nine census divisions (groups of States). Additional detail not included in this file appears in the reports. RELATED MACHINE-READABLE DATA FILES None. AVAILABILITY All of these files are included on Economic Census CD-ROM 1E (price $150). CENSUS OF MINERAL INDUSTRIES GEOGRAPHIC AREA SERIES Introduction CONTENTS General------------------------------------XXVII 5 Scope of Census and Definition of Mineral Industries-----------------------XXVII 5 Establishment Basis of Reporting-----------XXVII 5 Use of Administrative Records--------------XXVII 6 Auxiliaries--------------------------------XXVII 6 Industry Classification of Establishments--XXVII 6 GENERAL This report, from the 1987 Census of Mineral Industries, is one of a series of nine geographic division reports, each of which provides statistics for individual States within a defined geographic area. Additional separate reports are issued for individual industries or groups of related industries and for special subjects, such as fuels and electric energy consumed. The introduction to the General Summary discusses, at greater length, many of the subjects described in this introduction. For example, the General Summary text will discuss the economic significance of the mining sector, the relation of value added by mining to value added by manufacture, some of the changes in statistical concepts over the history of the census, and the valuation problems arising from intracompany transfers between mining establishments, manufacturing plants, and sales offices and sales branches of a company. SCOPE OF CENSUS AND DEFINITION OF MINERAL INDUSTRIES The 1987 Census of Mineral Industries covers all establishments with one paid employee or more primarily engaged in mining as defined in the 1987 Standard Industrial Classification (SIC) Manual1. This is the system of industrial classification developed by experts on classification in Government and private industry under the guidance of the Office of Information and Regulatory Affairs, Office of Management and Budget. This classification system is used by Government agencies as well as many organizations outside the Government. The SIC Manual defines mining in the broad sense to include the extraction of minerals occurring naturally: solids such as coal and ores, liquids such as crude petroleum, and gases such as natural gas. The term ``mining'' is used in the broad sense to include quarrying, well operation, milling (crushing, screening, washing, flotation, etc.), and other preparations needed to make minerals marketable. Exploration is included as is the development of minerals properties. Services performed on a contract, fee, or other basis in the exploration and development of mineral properties are classified separately but within this division. Mining operations are classified by industry on the basis of the principal mineral produced or, if there is no production, on the basis of the principal mineral for which exploration or development work is in progress. The recovery of material from culm banks, ore dumps, and other waste mineral piles is classified in the appropriate mining industry according to the mineral products recovered. The crushing, grinding, or other treatment of certain earths, rocks, and other nonmetallic minerals not in conjunction with mining activities is not included in this division but is classified as manufacturing. Hauling and other transportation beyond the mine property and contract hauling (except out of open pits in conjunction with mining) also are excluded. Mining operations carried on as secondary activities at manufacturing establishments (such as clay pits at clay products plants or sand and gravel operations at ready-mixed concrete plants) are not within the scope of this census. However, selected data (production workers' wages and hours; total cost of supplies, fuels, electric energy, and contract work; and quantity of production for mined products) on such mining activities have been obtained in the 1987 Census of Manufactures and are included in the mining reports. They are clearly specified wherever included. ESTABLISHMENT BASIS OF REPORTING The census of mineral industries covers each mining establishment of firms with one paid employee or more operating in the United States. A company operating more than one establishment is required to file a separate report for each location. A mineral establishment is defined as a single physical location where mineral operations are conducted. For oil and gas field operations and for contract services, the basis for reporting is different from the ``establishment'' basis used for other types of mining. Firms operating oil and gas wells, drilling wells, or exploring for oil and gas for their own account were required to submit a separate report for each State or offshore area adjacent to a State in which it conducted such activities. Firms that performed contract services for oil and gas field operations or for mining establishments were required to submit one report covering all such activities in the United States and to include information on receipts for services and production-worker wages and hours, by State. These consolidated reports were then allocated to State establishments based on the data reported at the State level. The 1987 figures for establishments include the summation of operations for each State allocated from these nationwide reports. USE OF ADMINISTRATIVE RECORDS From a mailout universe of about 34,000 mining establishments, approximately 12,000 small single- establishment companies were not mailed a questionnaire. For these establishments, some employment, payroll, and receipts data were obtained from the administrative records of other agencies. Selection of the small establishment non-mail cases was done on an industry-by-industry basis, and a variable cutoff was used to determine those establishments for which administrative records were to be used in place of a census report. This information was then used in conjunction with industry averages and other information to estimate the statistics for administrative- record and nonresponse establishments. The first column in tables 2a and 5 provides an indication of the extent that these establishments account for the figures shown. The value of shipments and receipts and cost of supplies were generally not distributed among specific products and supplies were generally not distributed among specific products and supplies for establishments, but were included in the products and supply ``not specified by kind'' categories. Overall, establishments for which administrative-record data were used accounted for less than 2 percent of total value of shipments and receipts. The industry classification codes included in the administrative-record files were used for those establishments excused from filing census forms. Generally, these codes were assigned on the basis of brief description of the general activity of the establishments. Where the description was incomplete, or where there were relatively fine lines of demarcation among industries or between mining and nonmining activities, the code assigned to an establishment could differ from that which would have been assigned on the basis of more complete product or activity information. Therefore, the total establishment count should be viewed as an approximate measure. The counts for establishments with 20 employees or more are far more reliable. In the 1987 census, as in the 1982, 1977, and 1972 censuses, data for single-unit firms without paid employees were excluded. This exclusion has only a slight effect on industry aggregates for most industries. Data for firms without employees were included in the 1963, 1958, and 1954 censuses if they reported more than $5500 in (1) value of shipments and receipts (2) cost of supplies and purchased machinery, or (3) capital expenditures. AUXILIARIES Statistics for employment and payroll for individual industries and industry groups also include employment and payroll figures for administrative offices, warehouses, storage facilities, and other auxiliary establishments servicing mining establishments. As in previous censuses, respondents were asked to file separate reports (form ES- 9200) for any separately operated auxiliary establishments. Classification of employment and payroll data at such auxiliary establishments was based on the mining establishments served. INDUSTRY CLASSIFICATION OF ESTABLISHMENTS Each of the establishments covered in the census was classified in 1 of 31 mineral industries in accordance with the industry definitions in the 1987 SIC manual. The 1987 edition of this manual represents a major revision for mineral industries from the 1972 edition and its 1977 supplement. Appendix A of the 1987 manual notes the revisions in the four-digit industry levels between 1972/77 and 1987. An industry is generally defined as a group of establishments producing the same product or closely related group of products. The resulting group of establishments must be significant in terms of its number, value added by mining, value of shipments and receipts, number of employees, and payroll. Application of these criteria led to formulation of 31 mining industries for 1987, and each was assigned a four-digit code. This represents a reduction of four-digit industries from 42 in 1972/77. The classification system also provides broader groups of industries, with 20 three-digit groups and 4 two-digit groups. Within industries, the system provides for seven- digit products and five-digit product classes. Products are considered primary to an industry if the first four digits of the product codes are the same as the industry code. Products whose first four code numbers differ from the industry code are called secondary products. To determine the industry classification of an establishment, the seven- digit products are grouped together according to the first four digits of the product code. The first four digits of the group of products with the largest value of production become the industry code for the establishment. (For mineral service industries, the classification is on the basis of receipts for services performed.) In most industries, establishments making products falling into the same industry category use a variety of processes. Separate statistics are provided on the various types of operation. Whenever possible, separate figures are shown for establishments with mines only, mines with preparation plants, and preparation plants only. Separate figures are provided by type of mine (underground, open pit, and combination). Separate statistics also are provided on producing and nonproducing operations, an establishment being defined as nonproducing if no mineral products were shipped during the year. Statistics usually are provided on the production of minerals mined and used in the same establishment for producing prepared minerals or used at the producing establishment for fuel. Differences in the integration of production processes and type of operation should be considered when relating the general items (employment, payrolls, value added, etc.) to the product and material data. 1. Standard Industrial Classification Manual: 1987. For sale by Superintendent of Documents, U.S. Government Printing office, Washington, DC 20402. Stock No. 041-001- 00314-2. CENSUS OF MINERAL INDUSTRIES GEOGRAPHIC AREA SERIES Glossary CONTENTS Employment and related Items---------XXVII-9 Payroll------------------------------XXVII-10 Production-, development-, and exploration-worker hours-----------XXVII-10 Supplemental labor costs-------------XXVII-10 Value added by mining----------------XXVII-10 Cost of supplies used, purchased machinery installed, etc.----------XXVII-11 Value of shipment and receipts-------XXVII-11 Capital expenditure------------------XXVII-11 Rental payments----------------------XXVII-11 Current account expenditures---------XXVII-12 Inventories--------------------------XXVII-12 Employment and related items The report forms requested separate information on production, development, and exploration workers for a specific payroll period within each quarter of the year and on other employees as of the payroll period which included the 12th of March. All employees This item includes all full-time and part- time employees on the payrolls of mining establishments during any part of the pay period which included the 12th of the months specified on the report form. Included are all persons on paid sick leave, paid holidays, and paid vacations during these pay periods. Also included are employees working for miners paid on a per ton , car, or yard basis. Excluded are employees at the mine but on the payroll of another employer (such as employees of contractors) and employees at company stores, boarding houses, bunk houses, and recreational centers. Also excluded are members of the Armed Forces and pensioners carried on the active rolls but not working during the period. Officers of corporations are included as employees; proprietors and partners of unincorporated firms are excluded. Production, development, and exploration workers This item included employees (up through the working-supervisor level) engaged in manual work (using tools, operating machines, hauling materials, loading and hauling products out of the mine in mine cars or trucks, and caring for mines, plants, mills, shops, or yards). Included are exploration work, mine development, storage, shipping, maintenance, repair, janitorial, and guard services, auxiliary production for use at establishments (such as power plant), record keeping, and other services closely associated with these production and development operations at the establishment covered by the report. Gang and straw bosses and supervisors who performed manual labor are included, as are employees paid on either a time- or piece-rate basis. Also included are miners paid on a per ton, car, or yard basis and persons engaged by them and paid out of the total amount received by these miners. In addition, other employees at the establishment but not on its payroll are included if paid directly through its own employees, such as superintendents and supervisors. The payments received by these types of employees are included if paid directly through its own employees, such as superintendents and supervisors. The payments received by these types of employees are included as part of the establishments payroll. Employees above the working-supervisor level are excluded from this category. All other employees This item covers nonproduction employees of the establishment including those engaged in the following activities: supervision above the work- supervisor levels, sales, highway trucking (by employees not entering mines or pits), advertising, credit, collection, clerical and routine office functions, executive, purchasing, financial, legal, personnel (including cafeteria and medical), professional (such as engineers and geologists), and technical activities. Also included are employees on the payroll of the establishment engaged in the construction of major additions or alterations to the plant and utilized as a separate work force. (Workers engaged in regular maintenance and repair operations are not included here but are classified as production, development, and exploration workers.) Separately operated auxiliary establishments employees This items includes employment at separate central administrative offices or auxiliary units of multiestablishment companies and at those offices or units servicing more than one establishment during the payroll period which included March 12. Establishments are classified on the basis of the industry or principal industry serviced. Employees at an office located at or near the mining establishment are usually included in the mine report. All employees, average for year The 1987 census report form requested employment figures for production, development, and exploration workers for four selected pay periods (mid-March, May, August, and November). For all other employees, only a mid-March figure was requested. The annual average is an average of the four monthly figures for production, development, and exploration workers plus the March figure for all other employees. This approach was used to simplify the schedule format and lighten the reporting burden of respondents, since it was found that the average of these selected pay periods closely approximates, for most industries, the average employment for the year that would be obtained from 12 monthly pay periods. Payroll This item includes the gross earnings of all employees on the payroll of mining establishments paid in the calendar year 1987. Respondents were told that in reporting they could follow the definition of payroll used for calculating the Federal withholding tax. It includes all forms of compensation such as salaries, wages, commissions, payments received on a ton, car, or yard basis, dismissal pay, bonuses, vacation and sick leave pay, and compensation in kind, prior to such deductions as employees' Social Security contributions, withholding taxes, group insurance, union dues, and savings bonds. The total includes salaries of officers of corporations; it excludes payments to the proprietor or partners of unincorporated concerns, and payments to members of Armed Forces and pensioners carried on the active payroll of mining establishments. Also excluded are royalty payments to unions and costs of smithing, explosives, fuses, electric cap lamps, and mine supplies used in production and development work but charged to employees and deducted from their wages. As in the case of employment and establishment figures, the annual payrolls of separate auxiliary establishments of multiestablishment companies are included in the totals for individual industries and for States. Production-, development-, and exploration-worker hours This item represents all hours that production, development, and exploration workers worked, both on active days during which there was production or development work and on inactive days when only security guards, inspectors, repair persons, and other maintenance persons were on duty. It includes all hours worked or paid for at the mining operations, except hours paid for vacations, holidays, or sick leave, when the employee was not at the establishment. Included are actual overtime hours, not straight time equivalent hours. Hours of working proprietors or partners are excluded. Supplemental labor costs This item represents employer's cost for fringe benefits not included in payrolls. Legally required expenditures, including Social Security contributions This cost includes employer contributions for all programs required under Federal and State legislation, such as Federal Old Age and Survivors' Insurance, unemployment compensation, and worker's compensation. Also included are legally required State temporary disability payments. Payments for voluntary programs Included in this cost are payments resulting from union negotiated contracts and all employer payments of insurance premiums on hospital and medical plans, life insurance premiums, and premiums on supplementary accident and sickness insurance. For programs supported by joint employer-employee contributions, only the employee payments are included. Also included are payments allocations on all pension plans regardless of method of administration, supplemental unemployment compensation plans, welfare plans, stock purchase plans which the employer payment is not subject to withholding tax and deferred profit sharing plans. Value added by mining This measure of mining activity is derived by subtracting the cost of supplies minerals received for preparation, purchased machinery installed, purchased fuel, purchased electricity, and contract work from the sum of the value of shipments (mining products plus receipts for services rendered) and total capital expenditures. This statistic avoids the duplication in value of shipments and receipts which results from the use of products of some establishments as supplies, energy sources, or materials by others. Moreover, it provides a measure of value added not only in mineral production but also in the development of mineral properties. For these reasons, it is considered to be the best value measure for comparing the relative economic importance of mining among industries and geographic areas. Cost of supplies used, purchased machinery installed, etc. Besides supplies used and purchased machinery installed, this cost includes fuels and electric energy used and contract work done by others for each establishment. It includes charges to both the current and capital accounts. It also includes the cost of items used during 1987 whether they were purchased, withdrawn from inventories, or received from other establishments of the company. For selected supplies and fuels and for electric energy, both quantity and cost data were requested. The cost data refer to direct charges actually paid or payable (after discounts) for items used during the year. Freight charges and other direct charges incurred by the establishment in acquiring the item are included. Companies whose records did not show actual amounts used were asked to approximate use by adding purchases (or receipts) during the year to opening inventory and subtracting closing inventory. Separate figures were requested for (1) selected supplies used, minerals received for preparation, and purchased machinery installed; (2) electric energy purchased; (3) purchased fuels used for heat, power, or the generation of electricity; (4) contract work done by others; and (5) products bought and resold in the same condition. Supplies and equipment used in mine development, plant expansion, and capitalized repairs, which are chargeable to fixed assets accounts, are included in this item, as are supplies furnished without charge to contractors for use at the mining operation and supplies sold to employees for use at the establishment. Excluded are such costs as advertising, insurance, telephone, and research and consulting services of other establishments or such overhead costs as depreciation charges, rent, interest, and royalties. Value of shipments and receipts The amounts shown as value of shipments and receipts for each industry and State are the net selling values, f.o.b.. mine or plant after discounts and allowances, excluding freight charges. Shipments includes all products physically shipped from the establishment during 1987, including material withdrawn from stockpiles and products shipped on consignment, whether or not sold in 1987. Prepared material or concentrates includes preparation from ores mined at the same establishment, purchased, received from other operations of the same company, or received for milling on a custom or toll basis. For products transferred to other establishments of the same company or prepared on a custom basis, companies were requested to report the estimated value, not merely the cost of producing the items. Multiestablishment companies were asked to report value information for each establishment as if it were a separate economic unit. They were instructed to report the value of all products transferred to other plants of the company at their full economic value; to include, in addition to direct cost of production, a reasonable proportion of company overhead and profits. For all establishments classified in an industry, value of shipments and receipts includes (1) the value of all primary products of the industry, (2) the value of secondary products which are primary to other industries, (3) the receipts for contract work done for others, except custom milling, and (4) the value of products purchased and resold without further processing. Receipts for custom milling are not included to avoid duplication with the value of custom milled ores included in an industry's primary and secondary products. Some duplication exists in industry and industry group totals because of the inclusion of materials transferred from one establishment to another for mineral preparation or resale. Capital expenditures This item covers expenditures made during the year for development and exploration of mineral properties, for new construction, and for purchased machinery chargeable to fixed assets accounts of the mineral establishment. They are the type for which depreciation, depletion, or Office of Minerals Exploration accounts are ordinarily maintained. Capital expenditures during 1987 were determined as ``additions completed during the year plus construction in progress at the end of the year minus construction in progress at the beginning of the year.'' Reported capital expenditures includes work done on contract, as well as by the mine forces. Expenditures for machinery and equipment includes those made for replacement purposes, as well as those for additions to capacity. Excluded from these expenditures were costs of maintenance and repairs charged as current operating expense and expenditures for land and mineral rights. Whenever applicable, separate figures were provided for expenditures for development and exploration of mineral property, construction of preparation plants and other construction, new machinery and equipment, used plant, and used equipment acquired from others. Rental payments This item consists of rental payments made to other companies for use of such depreciable assets as buildings, other structures, machinery, and equipment. It does not include payments made to the parent company or another subsidiary of the parent company for the use of buildings and equipment owned by the parent company or its subsidiary. The value of such company-owned assets is included in the gross value of depreciable assets. For 1987, a clarification was made to the instructions for rental payments to indicate that the equipment should be reported according to the type of lease negotiated with the lessor. If the lease qualified as an ``operating lease'' the periodic payments made to the producer or the lessor should be reported in the rental section. However, if the leasing arrangement met the criteria set down by the Financial Accounting Standards Board for a ``capital lease''. the original cost or market value of the equipment or building was to be reported as a value of fixed assets and not as rental payments. Current account expenditures This item includes all expenses for mineral properties, exploration, and development charged to current accounts. This includes all supplies, machinery, equipment, parts, fuels, power, etc., used for development or exploration and charged to current operating expenses. Also included are royalty payments, acquisition costs for mineral land and rights which were not capitalized, and the cost of maintenance and repairs associated with exploration or development activity and charged to current accounts. Inventories This item includes inventories of mined or quarried products and supplies, parts, fuels, etc. , at the beginning and end of the year. Included as mined or quarried products are stockpiles of products ready for shipment and stocks of raw products awaiting treatment or beneficiation. Beginning in the 1982 Census of Mineral Industries, all respondents were requested to report their inventories at (the lower of) cost or market prior to adjustment to LIFO cost. This is a change from the 1977 census in which respondents were permitted to value their inventories using any generally accepted accounting method. The inventory figures for 1987 and 1982, therefore, will not be comparable to prior census data because of the change in reporting instructions. CENSUS OF MINERAL INDUSTRIES GEOGRAPHIC AREA SERIES File Specifications CONTENTS General Data Specifications-XXVII 13 File Layout-----------------XXVII 13 GENERAL DATA SPECIFICATIONS Data Fields. All files are recorded in dBase III+ format. Numeric data fields contain no alphabetic information. A few fields have explicit decimals. On the other hand, many data items are scaled in thousands or millions, and this is noted only in the file layouts. Any data field which is subject to any special conditions (e.g., suppression to avoid disclosure, not applicable) is preceded by an information flag field which contains explanatory codes. Standard Industrial Classification Titles. Records in the files are specific to a particular SIC classification, as identified by the SIC code. Titles for each manufacturing SIC are shown in the file MC87SIC.dbf on the CD-ROM. Titles for each of these labelled variables may be linked to data files using the dBase SET RELATION command, although only one relation can be defined at one time. EXTRACT's ``Add Labels'' function serves the same purpose. 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. FILE LAYOUT Most data items have an associated ``flag'' to describe any special conditions applicable. Flag 0 indicates normal data. Flags 1 and 5 indicate the absence of data (e.g., due to disclosure) and the corresponding data cells contain zeroes. Flag 7 and 8 give proxy figures where precise employment figures have been withheld to avoid disclosure, but where ranges can be shown. Flag 7 indicates that the figure in the data cell is the midpoint of a range, while flag 8 denotes that the figure in the data cell is the lower bound of the range ``2500 or more employees''. EMPLOYEF EMPLOYE Value 7 .2 100 to 249 employees 7 .4 250 to 499 employees 7 .7 500 to 999 employees 7 1.7 1,000 to 2,500 employees 8 2.5 2,500 employees or more Census of Mineral Industries Geographic Area Series on CD- ROM DATABASE STRUCTURE File MN87A1: US, States, Counties by SIC ------------------------------------------------------------ ----------------------------------------------------------- Field Field Name Type Size Decimal Field Description ------------------------------------------------------------ ----------------------------------------------------------- RECTYPE C 2 0 Record Type (01=U.S.,02=State,06=County) ST C 2 0 FIPS State Code (00=U.S.,81=Atlantic offshore, 82=Northern Gulf of Mexico offshore, 83=Pacific offshore) COUNTY C 3 0 FIPS County Code (886=offshore) MSA C 4 0 MSA or CMSA Code (9999=not in MSA, 0000 in New England) PMSA C 4 0 PMSA Code (9999=not in PMSA) SIC C 4 0 1987 Standard Industrial Classification code E C 1 0 % of SHIPMTS estimated from admin. data (0=0-9%, 1=10-19%) ESTAB N 5 0 Number of establishments, 1987 EST20E N 5 0 Number of establishments with 20+ employees EMPLOYEF N 1 0 Flag for EMPLOYE (0=data, 7=range midpoint, 8=low bound) EMPLOYEF EMPLOYE 7 .2 100 to 249 employees 7 .4 250 to 499 employees 7 .7 500 to 999 employees 7 1.7 1,000 to 2,500 employees 8 2.5 2,500 employees or more EMPLOYE N 6 1 Number of paid employees for pay period including Mar 12 PAYROLLF N 1 0 Flag for PAYROLL PAYROLL N 8 1 Payroll entire year ($1,000), 1987 WORKERSF N 1 0 Flag for WORKERS WORKERS N 8 1 Number of production workers (thousands) HOURSF N 1 0 Flag for HOURS HOURS N 8 1 Production worker hours (millions) WAGESF N 1 0 Flag for WAGES WAGES N 8 1 Production worker wages ($ million) VALADDF N 1 0 Flag for VALADD VALADD N 8 1 Value added by mining ($ million) MATERLSF N 1 0 Flag for MATERLS MATERLS N 8 1 Cost of materials ($ million) SHIPMTSF N 1 0 Flag for SHIPMTS SHIPMTS N 8 1 Value of shipments ($ million) CAPEXPF N 1 0 Flag for CAPEXP CAPEXP N 7 1 New capital expenditures ($ million) EMPLO82F N 1 0 Flag for EMPLO82 EMPLO82 N 6 1 Number of paid employees for period including Mar 12, 1982 (NA for counties) VALAD82F N 1 0 Flag for VALAD82 VALAD82 N 8 1 Value added by mining ($ million), 1982 (NA for counties) Record size: 125 CENSUS OF MINERAL INDUSTRIES GEOGRAPHIC AREA SERIES User Notes This section will contain information relevant to the 1987 Census of Mineral Industries on CD-ROM 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.