10/11/02 Data described here are no longer available as swl20hod.dat on tapes k01766 and k01767. Both of these tapes have become unreadable. Original data tape was requested of and received from Randy Hodson. Data described here were copied from this tape and are in SWLMSTER.DAT, located in /project/hauser/wls/ surv2003/frontload, and also on CD in Soc. Sci. Room 8102. This data file contains 9,137 records (lrecl=3,659, recfm=f in SAS). 10/02/02 data described here is in swl20hod.dat on tapes k01766 and k01767 COMPUTER OPERATIONS REQUEST #335 Replacement for March, 1982 - Page 1 Date: April, 1982 (originally prepared June 1980) Re: Coding of company and industry data used in The Social Impact of Industrial Structure of Working Conditions, 1980 dissertation by Randy Hodson. This information is in Appendix B of Randy Hodson's dissertation. Company names were originally coded in COR #307. The first two digits of the company code number range from 01(A) to 26(Z) and represent the first letter of the company name. Hodson's Data Master Tapes: Contents: Columns 1-2400 SWL20 data (1957 through 1975) Columns 2401-2560 Company data (index on p.2) See pp. 4-23 for the coding of company data. This information is from Appendix B, pp.423-442 of Hodson's dissertation. Company names were originally coded in COR #307. Columns 2561-3659 Industry data (index on p.3) See pp. 24-42 for the detailed codebook of industry data. This lnformation is from INDUSTRIAL STRUCTUTRE DATA SET CODEBOOK January, 1980 by Robert L. Kaufman, Randy Hodson, and Neil D. Fligstein. Page 2 of 42 COMPUTER OPERATIONS REQUEST #335 Codebook for the Company Data NOTE: The company data is in raw, untransformed form with missing values identified by fields of 9s. Hodson's Contents Data Columns (DATA IN COLUMNS 2401-2485 WERE CODED IN COR #307. ) 2401-2406 Company code number - The first two digits of the company code number range from 01(A) to 26(Z) and represent the first letter of the company name. 2407-2434 Company name 2435-2462 Company street address 2463-2477 Company city 2478-2480 Company state 2481-2485 IDOF01-Originally Respondent's Office ID number (also in cols. 7-11) used to merge the data from COR #307 with the SWL20 tape. This column is currently coded 00000.) (DATA IN COLUMNS 2493-2560 WERE CODED IN COR #335 AS DESCRIBED IN PAGES 4-23.) 2493 SUB - Subsidiary (owned by another company) 2494 SUB source 2495-2497 #D SUB - Number of domestic subsidiaries 2498 #D SUB - source 2499-2501 Number of foreign subsidiaries 2502 Number of foreign subsidiaries - source 2503 Plants outside local area 2504 Plants outside local area - source 2505-2510 Employment - Number of employees. 2511 Employment - source 2512-2519 Sales - Net sales in thousands of dollars. 2520 Sales - source 2521-2527 Net income - Profit in thousands of dollars. 2528 Net income - source 2529-2536 Assets - Total assets in thousands of dollars. 2537 Assets - source 2538-2545 Net worth - in thousands of dollars. 2546 Net worth - source 2547 FORTUNE Magazine - On the list of 1,000 largest U.S. companies. 2548-2556 Blank 2557-2560 Sequence number COMPUTER OPERATIONS REQUEST #335 Page 3 of 42 Codebook for the Industry Data The following columns were extracted from the INDUSTRY DATA SET and appended to the Sewell data (May, 1979). Note that all of the industry data is in raw, untransformed form. Industry Hodson's Data Data Source Columns Columns Width Contents DATA IN COLUMNS 2561-3659 WERE CODED AS DESCRIBED IN PAGES 24-42. 2561-2563 1-3 3 NOTE: The industry data used by 2564-2615 40-91 52 Hodson is extracted from the complete 2616-2623 258-265 8 industrial structure data set. The 2624-2631 274-281 8 industry data consists of 213 industries 2632-2847 782-997 216 15 records per industry and 250 2848-2957 1008-1117 110 characters per record. The source 2958-2964 1349-1355 7 column numbers used in this document 2965-2974 1489-1498 10 refer to a merged data set with 3750 2975-3124 1508-1657 150 characters per record. (See pages 3125-3131 1758-1764 7 24-42). 3132-3213 1798-1879 82 3214-3245 2038-2069 32 3246-3257 2270-2281 12 3258-3271 2288-2301 14 3272-3323 2598-2649 52 3324-3330 2758-2764 7 3331-3362 2881-2912 32 3363-3400 3062-3099 38 3401-3438 3334-3371 38 3439-3659 3508-3728 221 Source tapes: DE 395 - Industrial Structure Data Set as described in pp.24-42. IBM version, EBCDIC, 9 track, 1600 BAUD, 3750 characters/record, N=213, blocksize=_3752 (padded to an even multiple of 4). This tape is stored in CDE as a Hodson Master. DE 412 - Industrial Structure Data Set as described in pp.24-42. VAX version, ASCII copy of DE 395. This tape is stored in 8102 Social Science Bldg. as a Sewell-Hauser Project Master. NOTE: The industry data used by Hodson is extracted from the complete INDUSTRIAL STRUCTURE DATA SET. The industry data consists of 213 industries industries, 15 records per industry and 250 characters per record. TO: Company Data Coders FROM: Randy Hodson RE: Rules and Procedures for Coding Up Company Data 1. The Search: Using one source at a time, search the list of companies. When you find a company name that matches one on the list, record the data for that company. If you find that a company is owned by another company, write the name of the owning company in the space provided on the form and record the data for that owning company. Otherwise, if you cannot find a company, make a note above the company name that you tried unsuccessfully with that source. Along with each company name and address is information on what the company produces and the class of the worker who reported them as employer. The number of workers employed is also reported. This information is provided as hints to aid in verifying that you have located the correct company. The search is a very important and difficult stage. For some industry sets of companies we expect a low coverage rate. It is important to search multiple possible spellings and listings of a company name. Remember how fuzzy and arbitrary some of these spellings and listings may be! If you find a possible match to a company but then determine that this is not really our company, make a note of this so that we to not have to pursue the same dead-end lead again later. In general, make any helpful notes or hints you can think of about finding the company in the blank space above each company on the data form. 2. Variables on the Code Sheet: Each variable has a 'source code' to the right of its field. This is to be filled with the code number of the source from which the data is obtained. The sources and codes are as follows: 1 Moody's Industrial 2 Moody's OTC 3 Moody's Transportation 4 Moody's Public Utility 5 Moody's Bank and Finance 6 AHA Hospitals 7 Dept. Industry, Labor, and Human Relations Employment Data 8 Economic Information Service (EIS) A Wisconsin Business Directory B Standard & Poor C Dun and Bradstreet E Corporate Report F Baird G Dun and Bradstreet Credit Ratings J State Rest Home data (Dept. of Health) K Classified Directorv of Mfg. P Directory of Intercorporate Ownership R Best's Insurance Manual T Directory of Corporate Affiliates X McFadden Bank Book COR #335 - Rules and Procedures for Coding Up Company Data (continued) The Variables on the code sheet are (from left to right): SUB: "Subsidiary" Is the compnay owned by another company? 1 = yes 0 = no #D SUB: "Number of Domestic Subsidiaries" How many U.S. subsidiaries does the company have? #F SUB: "Number of Foreign Subsidiaries" How many foreign subsidiaries does the company have? OUT: "Outside Immediate Area" Does the company operate plants outside of one home city? 1 = yes O = no EMPLOYMENT: The number of people employed by the company. SALES: Net sales of the company. (In thousands of dollars.) NET INCOME: Net income of the company. Also sometimes called 'profit.' (In thousands of dollars.) ASSETS: Total assets of the company. (In thousands of dollars.) NET WORTH: Net worth of the company. (In thousands of dollars.) FORTUNE: Is the company listed on Fortune Magazine's list of 1,000 largest U.S. companies? 1 = yes O = no When filling in data for a company, always fill the entire field by using leading zeros. If you have no information on a variable, leave the entire field blank. COR #335 - Page 6 ADDENDUM I to "Rules and Procedures for Coding Up Company Data" TO: Company Data Coders FROM: Randy Hodson RE: Use of Moody's Manuals as a Data Source. Moody's is our source with the most extensive set of data about each company. Most other sources lack information on at least some of our variables. This set of instructions is relevant for all of the Moody's manuals with slight changes for Moody's Bank and Finance manual. It, therefore, covers: Moody's Industrial Manual Moody's OTC Manual Moody's Transportation Manual Moody's Public Utility Manual Moody's Bank and Finance Manual. The data you can get from this source is as follows: SUB: If in the index the company is referred to another company, then it is owned by that company and is a subsidiary of that company. If this is so, place a 1 in the SUB field and record the name of the owning company. #D SUB and #F SUB: These are listed in the early part of the company description. You must count them and record the tally. Be sure to distinguish between domestic and foreign subsidiaries which are sometimes, but not always, listed separately. If a company is owned 50% or more by another company, then it is counted as a subsidiary. OUT: Plants outside home city? If a company has subsidiaries, it is counted as operating outside the immediate area. Otherwise this information nay have to be gained by scanning the description of the company and its activities. EMPLOYMENT: This is generally listed as "No. of Employees." SALES: This is generally listed under the "INCOME ACCOUNTS" column and is titled "Net Sales." Record it in thousands of dollars. (Sometimes it is listed in thousands of dollars and sometimes in dollars so you'll have to be careful to look and see how it is reported.) NET INCOME: This is also generally listed under the "INCOME ACCOUNTS" column and is titled "Net Income." It is also to be reported in thousands of dollars. ASSETS: This is reported under the "BALANCE SHEETS" column and is titled "Total" as the last heading under assets. Generally, it appears as the last entry before liabilities. You may check this figure by noting that it should exactly equal total liabilities. Assets too is to be recorded in thousands of dollars. NOTE: We to not want "Total Current Assets." COR #335 - Page 7 NET NORTH: This is generally listed as "Stockholders Equity" under the "BALANCE SHEETS" heading. It appears near the end of this group and under the "Liabilities" subheading. If Stockholders Equity is not listed, you should estimate it by summing the following entries or whichever ones of them appear: 1) "Stock" or "Common Stock" or "Capital Stock" 2) "Surplus" or "Undivided Surplus" 3) "Retained Earnings" or "Undivided Profits" 4) "Paid-in Capital" 5) "Capital Surplus" All of these entries occur in the area near to where Stockholders Equity is supposed to be listed. One further note: If a company is listed as "controlled by' another company, this means it is owned by that company (is a subsidiary of it). Therefore, record the name of the owning company and go to it as your data source. If a company is "affiliated with" another company, this implies less than 50% ownership. Therefore, stick with the original company as your data source. (It should not be considered a subsidiary of the other company.) This issue occurs predominately in the "Public Utilities" manual. COR # 335 ADDENDUM 2 to "Rules and Procedures for Coding Up Company Data." TO: Company Data Coders FROM: Randy Hodson RE: Use of Moody's Bank and Finance Manual as a data source Some special considerations must be taken in using Moody's Bank and Finance manual. In general, the information is set up very similarly to the rest of the Hoody's series. Therefore, information for the variables SUB, #D SUB, #F SUB, OUT, and EMPLOYMENT is obtained in the sane fashion as before. However, for the following variables there are changes: SALES: This equals "Total operating income" or "Total operating earnings" and is frequently missing. NET INCOME: This equals "Net income" or "Net profit" and is also sometimes missing. TOTAL ASSETS: This equals "Total" under the "Assets" heading (as before). NET WORTH: This equals the sum of the following entries, or whichever ones of them appear: "Surplus" "Capital surplus" "Capital notes" "Capital stock" "Common stock" "Retained earnings" "Undivided profits". All of these entries occur under the "Liabilities" subheading of the "STATEMENT" or "CONSOLIDATED STATEMENT" column and generally appear as a group. Certain small banks are listed in a condensed format separately in this manual. For these banks, less information is available. You will only be able to get information on four variables: SUB: If the bank is referred in the index to another company, go to that company to code up the data and code SUB = 1 = yes. If the bank appears on the abbreviated list, assume it is not a subsidiary of a larger bank, and therefore code SUB = O = no. NET INCOME: This equals the difference between the last two years in "Surplus and Undivided Profits." TOTAL ASSETS: This equals the sum of NET WORTH (see below) and "Deposits." NET WORTH: This equals the sum of "Capital stock" and "Surplus and Univided Profits." COR #335 -Page 9 ADDENDUM 5 to "Rules and Procedures for Coding Up Company Data" TO: Company Data Coders FROM: Randy Hodson RE: Use of American Hospital Association's Guide to Health Care as a data source. In general, only four sets of variables can be secured from this source. These are: SUB, #D SUB, and OUT: If the hospital is listed separately (it is not part of a larger group of hospitals), code each of these 0. EMPLOYMENT: This is listed as "Personnel." SALES: This is listed as "Total Expenses." (The assumption here is that hospitals are non-profit, so total expenses--what money goes out--equals total sales-what money comes in.) ASSETS: We can approximate this by information on the number of beds in the hospital. For now, record number of beds in this field. Later, either by hand or on the computer, we will multiply this number by $61,670 (the approximate assets represented by each bed). In certain cases where a hospital is part of a group of commonly owned hospitals, we can gain additional information from this source: SUB: If the hospital is listed as being part of a larger hospital network, which includes multiple hospitals, code it as a subsidiary, i.e., SUB = 1. #D SUB: Record here the number of separate hospitals in the larger group, minus 1. OUT: If any of the hospitals in the group are outside the home city, code OUT = 1. If they are all in the same city, code OUT = 0. Also, if a hospital is part of a larger group, give it the EMPLOYMENT, SALES, and ASSETS data for the group summed as a whole. COR #335 - Page 10 ADDENDUM 4 to "Rules and Procedures for Coding Up Company Data" TO: Company Data Coders FROM: Randy Hodson RE: Use of EIS computer printout as a data source. The EIS data is divided into two parts: plant information and company information. The plant information is sorted by state and alphabetically by company name within states. 1he company information is sorted alphabetically by company name. The search procedure is as follows: l) Go to the appropriate state folder and try to locate the plant. 2) If the plant has an EIS #, it is part of a larger company. In this case, go to the parent company as your data source. 3) If the plant has no EIS #, it is a single plant company and you should code the data directly from the plant listing. The variables we can get Fran this source are as follows: SUB: If the plant is a single-plant company, code SUB = 0 = no. If it is part of a larger company which has a different name, code SUB = l = yes. #D SUB: Record the number of different named plants in the group minus 1. (Plants which are listed as "divisions" do not represent separate companies.) If the company is a single plant company or has only same-named plants, code #D SUB = 0. #F SUB: No information. Leave this field blank. OUT: If the company has plants in more than one city, code OUT = 1. Else, code OUT = O. EMPLOYMENT: Code the plant employment if it is a single plant company. Otherwise, code the company employment. SALES: As above, code plant or company sales, whichever is relevant. EIS reports sales in lOO,OOO's of dollars. Therefore, add two zeros to the reported figure before coding it onto our data collection forms. NET INCOME, ASSETS, and NET WORTH: No information. Leave these fields blank. COR #335 - Page 11 ADDENDUM 5 to "Rules and Procedures for Coding Up Company Data" TO: Company Data Coders FROM: Randy Hodson RE: New Notes ant Guidelines for Coding Company Data In the first week of operation we have run into several problems which require new guidelines: 1) In the calculation of NET WORTH from Moody's manuals "Reacquired Stock" is to be ignored; it should neither be added nor subtracted into the NET WORTH figure. 2) The letters 'd', 'dr', and 'cr' before dollar amounts in income and asset statements are to be read as debit (d, dr) and credit (cr). They should be subtracted or added respectively into appropriate totals. 3) If the company for which we are coding data is foreign based, count #D SUB = number of subsidiaries in the home country and #F SUB = number of subsidiaries in foreign countries (including those in the U.S.). For example, if someone works for a Canadian based company, #D SUB = number of Canadian subsidiaries and #F SUB = number of subsidiaries in countries other than Canada. 4) Note on SALES. In ADDENDUM 1 "Use of Moody's Manuals as a Data Source" I claim that SALES is generally listed as "Net Sales" under the "Income Accounts" grouping. This is true for small companies only. For larger companies, "Net Sales" may represent only a part of total income or revenue. In this case we want SALES to be recorded as "Total Sales" which may include such additional items as "Investment Income," "Operating Revenues," and "Other Income." If any of these items are listed but a "Total Sales" figure is not given, you will have to manually sum these items to get the appropriate SALES = "Total Sales" figure. 5) Special code for values which exceed the spaces provided: If it should ever happen (Heaven forbid!) that you get a dollar or employment figure which is larger than will fit in the spaces provided on the data form, give that field the special code value of all 8's. We will know that this, means it exceeded the maximum limit. 6) Note concerning the coding of data for franchises: If a place of business is a franchise from a larger company do not give it the data from the larger company. If we cannot find information for the franchise itself, we are simply out of luck. Franchises: True Value Stores Gas stations Auto Sales IGA (International Grocer's Association). ADDENDUM 5: (continued) COR #335 - Page 12 Company owned dealerships: (give these companies the owning company's data) McDonald's Standard Gas Stations of Ohio and of California Rexall (I think) As a related example, we have the problem of Avon representatives. These people should be given Avon Company data. Although they work on straight commission, they still work for the company rather than working on their own "franchise." By the way, straight sales commission work is not that rare-even Crazy TV Lenny's sales people work on straight commission! ADDENDUM 6 to "Rules and Procedures for Coding Up Company Data" TO: Company Data Coders FROM: Randy Hudson COR #335 - Page 13 RE: Use of Standard and Poor's Register and Dun & Bradstreet's Directories as a data source. Source code for S & P = B; D & B = C. We cannot secure acecss to these sources except as reserve materials in the Business Library (located in the basement of Bascom Hall). They are referenced as follows: Ref. HC 102 D8 2 Ref. HG 4057 A4 2 Dun and Bradstreet, Million Dollar Directory and Middle Market Directory. Standard & Poor's Register. Volume 1, Corporations, Directors, and Executives Use the 1978 issues if they are on hand. Otherwise, you'll have to use the 1979 issues. Use of Den and Bradstreet's Directories: SUB: If the listing says "(Suby of ... )", then the company is a subsidiary of another company and code SUB = 1. Otherwise code SUB = 0. #D SUB, #F SUB: No information; leave blank. OUT: If the company is a subsidiary, then code OUT = 1. Otherwise leave OUT blank. (In effect, we get no information on plants outside the immediate area from this source.) EMPLOYMENT: This is almost always recorded. Code it as given. SALES: This is usually reported and is given in millions of dollars. Therefore, record it using 3 extra zeros. For example, l5MM becomes 15,000. NET INCOME, ASSETS, NET WORTH: No information; leave blank. Note that Dun and Bradstreet's Directory is in two volumes. Each volume will have to be used in sequence. Standard and Poor's Register is set up almost exactly like Dun and Bradstreet's Directory. However, it has generally inferior coverage. We will not use it unless we near the end of our project and have lots of time and money on our hands (ha!). ADDENDUM 7 to "Rules and Procedures for Coding Up Company Data" TO: Company Data Coders FROM: Randy Hodson RE: Use of Dun and Bratstreet's Bank Credit Reference Book Source Code = G 1) The Search: COR #335 - Page 14 Use this source to fill in missing data for any company for which we do not have NET WORTH. Note that this includes all companies which we have not found with other sources, all companies with EIS data (since EIS didn't give us NET WORTH) and any other companies for which NET WORTH is missing. 2) The main variable we can get from this source is NET WORTH. Net worth size categories are indicated by the first two letters following a company's name. (The third digit indicates its credit rating.) Code these first two digits as is. You can look in the front of the book to see their meaning if you wish. Coding a legible "G" as the source code is especially important in using this source because I'll need to make a transformation of what you code into dollar amounts on the computer at a later date. We can also get information about plants outside the immediate area from this source. If the company is listed alone, code OUT = O = no plants outside city. If the listing says the company is a branch of another company in a different city, code OUT = 1. Sometimes, but not always, we can get information on subsidiary linkages. If the listing says "SUBY OF..." it is a subsidiary and code SUB = 1. Otherwise, leave SUB blank because in this source not all subsidiaries are referenced to their parent company. Therefore, from the mere fact that no link is mentioned, we cannot be positive that it is not a subsidiary. So we either code SUB = 1 or leave blank; never code SUB = O from this source. As always, when a higher ownership is mentioned (branch headquarters or subsidiary owner) go to that company for the data. If you can't get data there, return to the original site and code up what data you can get. To repeat, the variables we can get from Dun and Bradstreet's Reference Book May, 1975 are: NET WORTH: a two-digit code OUT = O if listed alone = 1 if linked to another branch or owning company. = 1 if referenced to a parent company. = blank otherwise. SUB COR #335 - Page 15 ADDENDUM 8 to "Rules and Procedures for Coding Up Company Data" TO: Company Data Coders FROM: Randy Hodson RE: Use of Wisconsin Department of Industry, Labor and Human Relations (DILHR) employment data. Source code = 7. This source is for Wisconsin only. You should search for all Wisconsin companies for which we do not have employment data. You can code up two variables on the basis of this search: EMPLOYMENT - as reported. OUT - 1 if there are additiona1 plants outside the city; O otherwise. The special codes, 00000 ant 40404, in the employment column mean "don't know' and you should simply leave the employment field blank if either of these figures is reported. The city reported is sometimes a headquarters address rather than a plant location (which will be what you are attempting to match). Therefore, to not consider a wrong city as a totally sufficient reason to reject a match. You'll have to play this one largely by ear. When several plants are listed, one is supposed to have been considered as headquarters (or so DILHR tells me). The employment data will have been summed into this entry. It generally appears as the first or the last entry of a group of plants. But, you'll have to check this for reliability. (See Badger Freight for an example of how this is supposed to work.) Note also that government and union places appear at the end of the listing in the X, Y, Z booklet. COR #335 - Page 16 ADDENDUM 9 to "Rules and Procedures for Coding Up Company Data" To: Company Data Coders FROM: Randy Hodson RE: Use of McFadden's American Bank Directory as a data source. Scurac code = X. HC (2 volumes) in Business Library 2441 A56 2 This source is for banks but covers all states. You can locate "banks" by scanning the reported industry on the printout for our respondents. The sort in McFadden's is by state and by city within state. You can code up two variables from this book: NET WORTH = Capital (CAP) + Surplus (SUR) + Undivided Profits and Reserves (UP & R) ASSETS = NET WORTH (above) + Deposits (DEP) Note that you will have to sum these by hand so be sure and take along some scratch paper. Note also that dollar amounts are reported in single dollar figures so you'll have to round off 3 digits. Basically, what we'll get from this source is ASSETS since we already have NET WORTH for almost all banks. But, sometimes we'll get to fill in a NET WORTH figure too. COR #335 - Page 17 ADDENDUM 10 to "Rules and Procedures for Coding Up Company Data" TO: Company Data Coders FROM: Randy Hodson RE: Use of the Classified Directory of Wisconsin Manufacturers as a data source. Source code = K. This source is for Wisconsin manufacturing companies only. It has an alphabetic index in the front so use this and be sure to write down the page number of the reference. We can get basically two pieces of information from this source: EMPLOYMENT and NET WORTH. Use this source if either of these two items is missing for any Wisconsin manufacturing company. The variables we can get from this source are: EMPLOYMENT: Record this as reported. NET WORTH: Reported in dollars; record it in thousands of dollars. OUT: "Other Wisconsin operations" are listed at the bottom of each company's entry. If there are none outside the same city, code OUT = 0; if there are plants in other cities, code OUT = 1. SUB: Sometimes a parent company is listed. If this is so, code SUB = 1. If no parent company is listed, code SUB = O. ADDENDUM 11 to "Rules and Procedures for Coding Up Company Data" TO: Company Data Coders FROM: Randy Hodson RE: Additional Notes and Guidelines for Coding Company Data COR #335 - Page 18 1) The notation "S.A." after a subsidiary listed in Moody's does not mean South America. Do not count such entries as foreign subsidiaries. 2) Preferred stock "Pfd" in Moody's is to be included in NET WORTH. 3) In Moody's, if there is no "Subsidiaries" paragraph, you should read the "History" paragraph and count the number of acquisitions in order to identify the number of domestic and foreign subsidiaries. 4) If you find that a company is a franchised dealership of a larger company, code SUB = 2 and do not code the data from the larger parent company. Also,please write "Franchise" in the "owned by " space above the company name. 5) Directory of Corporate Affiliates - Source code = T. Classified Directory of Wisconsin Manufacturers - Source code = K. 6) In both Dun and Bradstreet series (the Bank Credit queersome threesome and the Directories gruesome twosome) M = 1,000's of dollars and MM = 1,000,000's of dollars. It is very important to keep on the lookout for this distinction. Most of the listings in the Bank Credit books are M (l,000's) and most of the listings in the Directories are MM (1,000,000's) but be sure and always took carefully at the listing. (This is an easy thing to overlook but it throws our figures off by a factor of 1,000.) ADDENDUM 12 to "Rules and Procedures for Coding Up Company Data" TO: Company Data Coders FROM: Randy Hodson RE: Use of Baird's Financial Briefs as a data source. Source code = F. COR #335 - Page 19 Baird's Briefs only contains data on 117 companies and is only applicable to Wisconsin companies in Manufacturing and Mining and F.I.R.E. This source has an alphabetic index in the front for easy reference. We can get full information from this source so use it if any information is missing from one of our listings of a Wisconsin company. The variables we can get from this source are as follows: SUB, #D SUB, #F SUB, OUT: Read the paragraph of text at the top of each listing to determine the appropriate codes for these variables.. EMPLOYMENT: Listed at the bottom of each company's page. SALES, INCOME: Listed as "Net Sales" and "Net Profit" respectively. (Generally listed in thousands of dollars.) Record the value for 1974 to be consistent with our other sources. ASSETS: Listed as "Total Assets." Record the value for 1976 rather than the one for 1977. This is generally listed in dollars so truncate 3 digits. NET WORTH: Listed as "Net North." Again, record the 1976 value and truncate 3 digits if listed in single dollars. NOTE: There is no Addendum 13 ADDENDUM 14 to "Rules and Procedures for Coding Up Company Data" TO: Company Data Coders FROM: Randy Hodson COR #335 - Page 20 RE: Name Search Using Directory of Corporate Affiliations (Source code = T), and Directory of Intercorporate Ownership (Source code = P). These sources are potentially applicable to all companies in all industry groups. The point of the search is to discover a name link to some owning company for which we can get data. Search only those companies for which we have a blank in the SUB field. (If we know positively that the company is not a subsidiary, then there is no point looking further. And, if we know that the company is a subsidiary, presumably we also know the name of the owning company.) Corporate Affiliations is the better of these two sources so we will use it first. Subsidiaries, divisions, and affiliates are listed in the second part of this book. If you discover a link, record the name of the owning company in green pencil. Then flip to the first part of the book and search the parent company to see if our company is listed as a subsidiary or as a division. This information will enable you to code SUB = 1 if it is a subsidiary or SUB = O if it is a division. In either case, code OUT = 1. We can also count the number of domestic and foreign subsidiaries from the parent company listing. Corporate Affiliations sometimes lists SALES and EMPLOYMENT. If either of these is listed. for either the employing or the owning company, record whichever is larger. In sum, the information we can get from this source is: SUB, #D SUB, #F SUB, OUT, plus sometimes EMPLOYMENT and SALES. Business Reference HG Direcotry of Intercorporate Ownership 4057 (2 volumes) A156 2 The information we can get from this source is more limited than that from Corporate Affiliations; however, the search operation is almost identical. Look up the employing company in Volume 2 (Subsidiaries, Affiliates, and Divisions) and record the name of the owning company in green. Go to the parent company (Volume 1) and record SUB = 1 or 0, #D SUB, #F SUB, and OUT (which will always = 1). ADDENDUM 15 to "Rules and Procedures for Coding Up Company Data" TO: Company Data Coders FROM: Randy Hodson RE: Use of Wisconsin Business Directory as a data source. Source code = A COR #335 - 21 This source is for Wisconsin only but it contains information on all of our variables. Therefore, we should examine all Wisconsin companies for which we are missing any data. The only copy of this book which is available to us is on reserve at the City Library. As a result, the search operations we will employ will be different from that employed for earlier sources. We will search the companies using a photocopy of the Wisconsin Business Directory index and write down the companies for which we need data. Later, we will take this list to the City Library to secure the data. The point of this two-stage operation is to avoid having to drag our booklets down to the City Library and spend many hours of unsuccessful searching there. We might as well to the unsuccessful searching in our own office! When you record the name of a company for which we need data, be sure to also code which booklet it is in so we can find it when we go to fill in the data. ADDENDUM 16 to "Rules and Procedures for Coding Up Company Data" TO: Company Data Coders FROM: Randy Hodson RE: Final company by company search, data checking, and resolution of problem cases. COR #335 - 22 This procedure involves a change of face. Now, instead of going through a list of companies with a single source and looking for which ones we can find, we will go through a list of companies utilizing any or all of our sources to make a final resolution about what data we can get for that particular company. I anticipate that this step will take a fairly long time to complete. The reason for this in that each company must be examined and a final resolution must be made concerning its status. All those sticky problems we've been putting off and making notes about must now be faced. Several questions should be addressed in relation to each company: 1) Is the recorded data legible and are all the source codes filled in? 2) Are companies "duped" if they are the same company as the one immediately preceding them on the list? 3) Does each company listed have a sequence number? 4) Has each company been checked in all the appropriate sources? 5) Does a company which remains completely unlocated have a large reported employment? If so, this is suspicious. Perhaps the questionnaire should be pulled and examined for further information. In general, pull the questionnaire if you have any questions about the accuracy of the reported information. For example, perhaps the spelling of the company name looks funny or perhaps the industry reported doesn't match what the company name indicates about the type of work done there. 6) Search in Moody's Industrial or whatever sources are relevant for data on any new owning company names noted in green. 7) Examine all companies reported as "SELF" or refusal (7's). If there is anything suspicious about these companies, such as a reported employment figure greater than 100, pull the questionnaire and examine it for further information. 8) If some question or uncertainty is noted about the data for a company, attempt to make a final resolution concerning this question. Use whatever sources and materials we have available; reexamine the source books, pull the questionnaire, telephone long distance directory assistance, or whatever it takes. 9) Mark each company checked with an "OK." Do this even for companies for which we have no information at all if the final resolution is that we can find nothing on them. Also do this for "duped" companies. This is a learn-by-doing type task, and I really can't say exactly how we'll make a resolution on problem cases. We'll just have to do it one company at a time. Send any cases you can't resolve across my desk and we'll work on them together. COR #335 - Page 23 ADDENDUM 17 to "Rules and Procedures for Coding Up Company Data" TO: Company Data Coders FROM: Randy Hodson RE: Use of Fortune magazine's list of large corporations as a data source. This is the absolute last step before keypunching! We have waited to use this source until last so that we have had the maximum opportunity to identify ownership links before asking the question, "Is this company a member of the Fortune 500?" He have three separate lists of Fortune companies: the largest 500 industrials (code = 1), the second 500 largest industrials (code = 2), and the 50 largest companies from each of the categories: banking, insurance, finance, retail, transportation, ant utilities (code = 3). If a company is not on any of the Fortune lists, code FORTUNE = 0. In using this source we will operate on the assumption that anything not listed in Moody's manuals is not on the Fortune lists. Therefore, the search is relatively easy. If a company was not found in Moody's code, FORTUNE = 0. Moody's Manuals are indicated by source codes 1-5 and by the presence of relatively complete data. Of course, if you have some reason to suspect that a company may be on the Fortune list even though we didn't find it in Moody's, go ahead and look for it anyway and give FORTUNE the appropriate code if you find the company on a Fortune list. For companies which were found in Moody's manuals, search each of the three Fortune lists for a mention of the company and code the appropriate value: O = not on list 1 = Fortune's 500 largest industrial 2 = Fortune's second 500 largest industrial 3 = Fortune's top 50 largest firms from finance, trade, and so on... It is important to check each of the lists in every case because these huge companies operate in many industries and the industry reported by our respondent may be no indication of the primary activity of the firm. NOTE: We also have complete financial data on the Fortune companies. So, if some piece of information is missing for one of these companies, stop to look it up and fill it in from this source before going on. COR #335 - Page 24 of 42 INDUSTRIAL STRUCTURE DATA SET CODEBOOK January, 1980 Robert L. Kaufman, University of Wisconsin-Madison Randy Hodson, University of Wisconsin-Madison Neil D. Fligstein, University of Arizona-Tuscon COR #335 - Page 25 of 42 Column Format Data Record 1 1-3 3.0 1970 Census industry code 4-5 2.0 Source code = 1 (1967 Enterprise Statistics) 6-7 2.0 Recode code = 1 8-15 8.0 # companies 16-23 8.0 # establishments 24-31 8.0 # employees 32-39 8.0 Sales & receipts ($100,000) 40-41 2.0 Quality of data code 42-51 10.4 Employees/company 52-61 10.4 Employees/establishment 62-71 10.4 Sales & receipts/company ($100,000) 72-81 10.4 Sales & receipts/establishment ($100,000) 82-91 10.4 Establishments/company 92-250 159 filler Cor 335 - Page 26 of 42 Column Format Data Record 2 1-3 3.0 1970 Census industry code 4-5 2.0 Source Code = 2 (1972 Enterprise Statistics) 6-7 2.0 Record code = 1 8-15 8.0 # of companies 16-23 8.0 # of establishments 24-31 8.0 # of employees 32-39 8.0 Annual payroll ($ 100,000) 40-47 8.0 Sales & receipts ($ 100,000) 48-55 8.0 Value added ($ 100,000) 56-63 8.0 New capital expenditures ($ 100,000) 64-71 8.0 # of companies 72-79 8.0 # of employees 80-87 8.0 Sales & receipts ($ 100,000) 88-94 7.0 # of companies total 95-101 7.0 # of companies w/ no employees 102-108 7.0 # of companies w/ 1 - 4 emp. 109-115 7.0 # of companies w/ 5 - 9 emp. 116-122 7.0 # of companies w/ 10 - 19 emp. 123-129 7.0 # of companies w/ 20 - 49 emp. 130-136 7.0 # of companies w/ 50 - 99 emp. 137-143 7.0 # of companies w/ 100 - 249 emp. 144-150 7.0 # of companies w/ 250 - 499 emp. 151-158 8.0 # of companies w/ 500 - 999 emp. 159-165 7.0 # of companies w/ 1000 - 2499 emp. 166-172 7.0 # of companies w/ 2500 - 4999 emp. 173-179 7.0 # of companies w/ 5000 - 9999 emp. 180-186 7.0 # of companies w/ GE 10,000 emp. 187-193 7.0 # of employees total 194-200 7.0 # of employees in companies w/ no employees 201-207 7.0 # of employees in companies w/1 - 4 emp. 208-214 7.0 # of employees in companies w/5 - 9 emp. 215-221 7.0 # of employees in companies w/10 - 19 emp. 222-229 8.0 # of employees in companies w/20 - 49 emp. 230-236 7.0 # of employees in companies w/50 - 99 emp. 237-243 7.0 # of employees in companies w/100 - 249 emp. 244-250 7.0 # of employees in companies w/250 - 499 emp. COR #335 - Page 28 of 42 Column Format Data Record 4 1-3 3.0 1970 Census industry code 4-5 2.0 Source code = 2 (1972 Enterprise Statisticsj 6-7 2.0 Record code = 3 8-15 8.0 S & R in companies w/ S & R GE S250,000,000 16-23 8.0 # of companies 24-31 8.0 # of companies which are corporations 32-33 2.0 Quality of data code 34-41 8.3 4 firm equivalent employment concentration ratio 42-49 8.3 8 firm equivalent employment concentration ratio 50-57 8.3 20 firm equivalent employment concentration ratio 58-65 8.3 50 firm equivalent employment concentration ratio 66-73 8.3 4 firm equivalent sales and receipts concentration ratio 74-81 8.3 8 firm equivalent sales and receipts concentration ratio 82-89 8.3 20 firm equivalent sales and receipts concentration ratio 90-97 8.3 50 firm equivalent sales and receipts concentration ratio 98-107 10.4 % of companies w/ GE 100 employees 108-117 10.4 % of companies w/ GE 500 employees 118-127 10.4 % of companies w/ GE 10,000 employees 128-137 10.4 % of employees in companies w/ GE 100 emp. 138-147 10.4 % of employees in companies w/ GE 500 emp. 148-157 10.4 % of employees in companies w/ GE 10,000 emp. 158-167 10.4 % of companies w/ GE $1 million sales and receipts 168-177 10.4 % of companies w/ GE $25 million sales and receipts 178-187 10.4 % of companies w/ GE $250 million sales and receipts 188-197 10.4 % of S & R in companies w/ GE $1 million S & R 198-207 10.4 % of S & R in companies w/ GE $25 million S & R 208-217 10.4 % of S & R in companies w/ GE $250 million S & R 218-227 10.4 % of companies which are corporations 228-237 10.4 Payroll/company ($10 million) 238-247 10.4 Payroll/establishment ($10 million) 248-250 3 filler COR #335 - Page 29 of 42 Column Format Data Record 5 1-3 3.0 1970 Census industry code 4-5 2.0 Source code = 2 (1972 Enterprise Statistics) 6-7 2.0 Record code = 4 8-17 10.4 Sales and receipts/company ($100,000) 18-27 10.4 Sales ant receipts/establishment ($100,000) 28-37 10.4 Value added/company ($100,000) 38-47 10.4 New capital expenditures/company ($100,000) 48-57 10.4 Payroll/employee ($100,000) 58-67 10.4 Sales and receipts/employee (6100.000) 68-77 10.4 % of companies in same industry category 78-87 10.4 % of employees in same industry category 88-97 10.4 % of sales and receipts in same industry category 98-107 10.4 Payroll/sales and receipts 108-117 10.4 Establishments/company 118-250 133 filler COR #335 - Page 30 of 42 Column Format Data Record 6 1-3 3.0 1970 Census industry code 4-5 2.0 Source code = 3 (Internal Revenue Service, 64 categories) 6-7 2.0 Record code = 1 8-14 7.0 Total # of returns (ones) 15-21 7.0 # of returns w/ $0 assets 22-28 7.0 # of returns w/ $1 - 99,999 assets 29-35 7.0 # of returns w/ Sl00,000 - 249,999 assets 36-42 7.0 # of returns w/ $250,000 - 499,999 assets 43-49 7.0 # of returns w/ $500,000 - 999,999 assets 50-56 7.0 # of returns w/ $1,000,000 - 4,999,999 assets 57-63 7.0 # of returns w/ $5,000,000 - 9,999,999 assets 64-70 7.0 # of returns w/ $10,000,000 - 24,999,999 assets 71-77 7.0 # of returns w/ $25,000,000 - 49,999,999 assets 78-84 7.0 # of returns w/ $50,000,000 - 99,999,999 assets 85-91 7.0 # of returns w/ $100,000,000 - 249,999,999 assets 92-98 7.0 # of returns w/ GE $250,000,000 assets 99-105 7.0 Total assets ($ millions) 106-112 7.0 Total assets in range $0 113-119 7.0 Total assets in range $1 - 99,999 120-126 7.0 Total assets in range $100,000 - 249,999 127-133 7.0 Total assets in range $250,000 - 499,999 134-140 7.0 Total assets in range $500,000 - 999,999 141-147 7.0 Total assets in range S1,000,000 - 4,999,999 148-154 7.0 Total assets in range $5,000,000 - 9,999,999 155-161 7.0 Total assets in range S10,000,000 - 24,999,999 162-168 7.0 Total assets in range $25,000,000 - 49,999,999 169-175 7.0 Total assets in range $50,000,000 - 99,999,999 176-182 7.0 Total assets in range $100,000,000 - 249,999,999 183-189 7.0 Total assets in range GE $250,000,000 190-196 7.0 Dividends from foreign corp. ($ thousands) 197-204 8.0 Advertising ($ thousands) 205-209 5.0 Pensions,profit-sharing,stock bonus,annuity plans ($ millions) 210-214 5.0 Employee benefit programs ($ millions) 215-222 8.0 Cost of repairs 223-230 8.0 Depreciation 231-238 8.0 Depletion 239-246 8.0 Constant capital (repair + depreciation + depletion) 247-248 2.0 Quality of data code 249-250 2 filler COR #335 - Page 31 of 42 Column Format Data Record 7 1-3 3.0 1970 Census industry code 4-5 2.0 Source code = 3 (Internal Revenue Service, 64 categories) 6-7 2.0 Record code = 2 8-17 10.4 Dividends from foreign corp./return ($ hundreds) 18-27 10.4 Advertising/return ($ hundreds) 28-37 10.4 Pensions, etc./return ($100,000) 38-47 10.4 Employee benefits/return (S100,000) 48-57 10.4 % of returns with assets GE $1,000,000 (0-100) 58-67 10.4 % of returns with assets GE $25,000,000 (0-100) 68-77 10.4 % of returns with assets GE $250,000,000 (0-100) 78-87 10.4 % of assets in carp. w/ assets GE $1,000,000 (0-100) 88-97 10.4 % of assets in carp. w/ assets GE $25,000,000 (0-100) 98-107 10.4 % of assets in carp. w/ assets GE $250,000,000 (0-100) 108-117 10.4 4 firm equivalent assets concentration ratio (0-100) 118-127 10.4 8 firm equivalent assets concentration ratio (0-100) 128-137 10.4 20 firm equivalent assets concentration ratio (0-100) 138-147 10.4 50 firm equivalent assets concentration ratio (0-100) 148-157 10.4 Constant capital/return 158-250 93 filler COR #335 - Page 32 of 42 Column Format Data Record 8 1-3 3.0 1970 Census industry code 4-5 2.0 Source code = 3 (Internal Revenue Service, 215 categories) 6-7 2.0 Record code = 3 8-14 7.0 # of returns 15-21 7.0 Total receipts ($ millions) 22-27 6.0 Net income (S millions) 28-34 7.0 Foreign tax credits ($ thousands) 35-41 7.0 Total Assets ($ millions) 42-47 6.0 Net worth ($ millions) 48-49 2.0 Quality of data code 50-59 10.5 Receipts/return ($ millions) 60-69 10.5 Net income/return ($ millions) 70-79 10.5 Foreign tax credits/return ($ thousands) 80-89 10.5 Assets/return ($ millions) 90-99 10.5 Net worth/return ($ millions) 100-109 10.5 Net income/receipts 110-119 10.5 Net income/assets 120-129 10.5 Net income/net worth 130-250 121 filler COR #335 - Page 33 of 42 Column Format Data Record 9 1-3 3.0 1970 Census industry code 4-5 2.0 Source code = 4 (National Income and Product Accounts) 6-7 2.0 Record code = 1 8-13 6.0 Compensation ($ millions) 14-19 6.0 Wages & salaries ($ millions) 20-24 5.0 # of full & part-time employees (thousands) 25-29 5.0 # of full-time equivalent employees (thousands) 30-37 8.0 Net national product ($ millions) 38-39 2.0 Quality of data code 40-49 10.4 Compensation/full-time equivalent employee ($ thousands) 50-59 10.4 Wages & salaries/full-time equivalent employee ($ thousands) 60-69 10.4 Net national product/full-time equivalent employee ($thousands) 70-250 181 filler COR #335 - Page 34 of 42 Record 10 Column Format Data 1-3 3.0 1970 Census industry code 4-5 2.0 Source code = 5 (Census of Manufactures) 6-7 2.0 Record code = 1 8-13 6.0 # of companies 14-19 6.0 Value of shipments ($ millions) 20-22 3.0 4 firm (weighted ave.) value of shipments concentration ratio 23-25 3.0 8 firm (weighted ave.) value of shipments concentration ratio 26-28 3.0 20 firm (weighted ave.) value of shipments concentration ratio 29-31 3.0 50 firm (weighted ave.) value of shipments concentration ratio 32-37 6.0 Employment (hundreds) 38-40 3.0 4 firm (weighted ave.) employment concentration ratio 41-43 3.0 8 firm (weighted ave.) employment concentration ratio 44-46 3.0 20 firm (weighted ave.) employment concentration ratio 47-49 3.0 50 firm (weighted ave.) employment concentration ratio 50-51 2.0 Quality of data code 52-250 199 filler COR #335 - Page 35 of 42 Column Format Data Record 11 1-3 3.0 1970 Census industry code 4-5 2.0 Source code = 6 (Input-Output) 6-7 2.0 Record code = 1 8-17 10.0 Value added ($100,000) 18-27 10.0 Personal consumption expenditures ($100,000) 28-37 10.0 Gross private fixed capital formation ($100,000) 38-47 10.0 Nex exports ($100,000) 48-57 10.0 Federal purchases ($100,000) 58-67 10.0 State and local purchases ($100,000) 68-77 10.0 Sales to all other industries ($100,000) 78-87 10.0 Final demand (private consumption expenditures + all government purchases) ($100,000) 88-97 10.0 Total output (final demand + net exports + sales to all other industries) ($100,000) 98-99 2.0 Quality of data code 100-109 10.4 Value added/total output (0-100) 110-119 10.4 Gross private fixed capital formation/total output (0-100) 120-129 10.4 Nex exports/total output (0-100) 130-139 10.4 Federal purchases/total output (0-100) 140-149 10.4 State and local purchases/total output (0-100) 150-250 101 filler COR #335 - Page 36 of 42 Column Format Data Record 12 1-3 3.0 1970 Census industry code 4-5 2.0 Source code = 7 (Census of Population) 6-7 2.0 Record code = 1 8-14 7.0 Total employed 15-21 7.0 # of private workers (including self-emp., own corporation) 22-28 7.0 # of self-employed in own corporation 29-35 7.0 # of federal employed 36-42 7.0 # of state employed 43-49 7.0 # of local employed 50-56 7.0 # of self-employed, unincorporated 57-58 2.0 Quality of data for class of worker (0 in all cases) 59-66 8.0 # of males, l950 67-74 8.0 # of females, 1950 75-82 8.0 # of males, 1960 83-90 8.0 # of females, 1960 91-98 8.0 # of males, 1970 99-106 8.0 # of females, 1970 107-114 8.0 # total, 1950 115-122 8.0 # total, 1960 123-130 8.0 # total, 1970 131-132 2.0 Quality of data for industry employment 133-142 10.4 # total, 1970/# total, 1960 143-152 10.4 # total, 1970/# total, 1950 153-162 10.4 # total, 1960/# total, 1950 163-250 88 filler COR #335 - Page 37 of 42 Column Format Data Record 13 1-3 3.0 1970 Census industry code 4-5 2.0 Source code = 8 (Freeman and Medoff, BLS) 6-7 2.0 Record code = 1 8-13 6.0 Count of establishments in sample 14-25 12.2 Weighted count of office workers 26-37 12.2 Weighted count of non-office workers 38-49 12.2 Weighted count of office workers in estab. w/ agreements covering GE 50% of workers 50-61 12.2 Weighted count of non-office workers in estab. w/ agreements covering GE 50% of workers 62-63 2.0 Quality of data code 64-73 10.4 % of office workers in estate. w/ agreements covering GE 50 % of workers 74-83 10.4 % of non-office workers in estate. w/ agreements covering GE 50% of workers 84-93 10.4 % of all workers in estate. w/ agreements covering GE 50% of workers 94-95 2.0 Quality of data code for office workers 96-97 2.0 Quality of data code for non-office workers 98-99 2.0 Quality of data code for all workers 100-250 151 filler COR #335 - Page 38 of 42 Column Format Data Record 14 1-3 3.0 1970 Census industry code 4-5 2.0 Source code = 9 (Freeman and Medoff, CPS) 6-7 2.0 Record code = 1 8-13 6.0 Count of nonproduction workers 14-26 13.2 Weighted count of nonproduction workers 27-32 6.0 Count of production workers 33-45 13.2 Weighted count of production workers 46-51 6.0 Count of nonproduction union members 52-64 13.2 Weighted count of nonproduction union members 65-70 6.0 Count of production union members 71-83 13.2 Weighted count of production union members 84-85 2.0 Quality of data code 86-95 10.4 % of nonproduction workers unionized 96-105 10.4 % of production workers unionized 106-115 10.4 % of all workers unionized 116-117 2.0 Quality of data code for nonproduction workers 118-119 2.0 Quality of data code for production workers 120-121 2.0 Quality of data code for all workers 122-250 129 filler COR #335 - Page 39 of 42 Column Format Data Record 15 1-3 3.0 1970 Census industry code 4-5 2.0 Source code = 10 (cross source) 6-7 2.0 Record code = 1 8-17 10.4 Value added/firm (Input-OutPut & 1967 Ent. Stat.) 18-19 2.0 Q.O.D. code 20-29 10.4 Value added/employee (Input-Output & 1967 Ent. Stat.) 30-31 2.0 Q.O.D. code 32-41 10.4 Net exports/firm (Input-Output & 1967 Ent. Stat.) 42-43 2.0 Q.O.D. code 44-53 10.4 Federal purchases/firm (Input-Output & 1967 Ent. Stat.) 54-55 2.0 Q.O.D. code 56-65 10.4 State and local government purchases /firm (I-O & 1967 Ent. Stat) 66-67 2.0 Q.O.D. code 68-77 10.4 Net income/(value added - net income) (IRS detail & I-O) 78-79 2.0 Q.O.D. code 80-89 10.4 Value added - net income - payroll/(value added - net income) (I-O, IRS detail, & 1972 Ent. Stat.) 90-91 2.0 Q.O.D. code 92-101 10.4 # employees in 1972/# employees in 1967 (1972 & 1967 Ent.Stat.) 102-103 2.0 Q.O.D. code 104-113 10.4 Sales & receipts in 1972/sales & receipts in 1967 (1972 & 1967 Ent. Stat.) 114-115 2.0 Q.O.D. code 116-125 10.4 (# of employees/firm in 1972)/(# of employees/firm in 1967) (1972 & 1967 Ent. Stat.) 126-127 2.0 Q.O.D. code 128-137 10.4 Assets/employee (IRS detail & 1972 Ent. Stat.) 138-139 2.0 Q.O.D. code 140-149 10.4 Net income/payroll (IRS detail & 1972 Ent. Stat.) 150-151 2.0 Q.O.D. code 152-161 10.4 Payroll/assets (1972 Ent. Stat. IRS detail) 162-163 2.0 Q.O.D. code 164-173 10.4 # of full and part-time employees - & of full time equivalent employees/firm (NIPA & 1972 Ent. Stat.) 174-175 2.0 Q.O.D. code 176-185 10.4 Compensation/firm (NIPA & 1972 Ent. Stat.) 186-187 2.0 Q.O.D. code 188-197 10.4 Wages & salaries/firm (NIPA & 1972 Ent. Stat.) 198-199 2.0 Q.O.D. code 200-202 3.0 Regulation dummy (Scherer) 203-204 2.0 Q.O.D. code 205-214 10.4 Net income/(constant capital + compensation) (IRS detail & aggregate & NIPA) 215-216 2.0 Q.O.D. code 217-226 10.4 Constant capital/(constant capital + compensation) (IRS aggregate & NIPA) 227-228 2.0 Q.O.D. code 229-250 22 filler COR #335 - Page 40 of 42 NOTES 1) a: Non-missing data with a format of the form Fw.0 have no decimal points written on the tape. b: Non-missing data of the form Fw.d have decimal points written on the tape. c: Missing data are identified by fields of 9's which contain no decimal points. d: The exception to 'c' is for the cross source variables where missing data are identified by '99999.0000'. 2) Quality of data codes: 0 = clean 1 = split of aggregated 2 = missing 3 = alternative source used in calculation (cross source data only). 3) Data is meaningful only for variables which are rates or ratios, not for absolute numbers. This is because many of the data items have been either split or aggregated to match the 1970 Census Industry Classification. That is, if we had datum only for mining, that number was assigned to all the subcategories of mining. As a corollary, new variables can be created from absolute numbers only within sources. Sets of usable data are generally preceded by a Quality of data code which pertains to the data from which they were calculated. Exception: the data on Record 12 pertaining to class of worker for 1970 were collected in 1970 Census Industry Codes, and are, therefore, usable in raw form. 4) GT = greater than GE = greater than or equal to LT = less than LE = less than or equal to. 5) Record code in columns 6-7 is the within source record number. 6) The 4, 8, 20, and 50 firm equivalent concentration ratios for employment, sales, and assets were calculated in the following way. We summed the employment (or sales or assets) in the top size categories until the figures for enough companies had been added, interpolating within the last added size category if necessary, and divided this sum by the total industry employment (or sales or assets). 7)For futher information on the handling of data and the interpretation of variables see Kaufman (1980) or Hodson (1980). COR #335 - Page 41 of 42 8) Specific variable notes: Record 2 (1972 Enterprise Statistics), columns 8-63 are from Table 1, Total row. Record 2, columns 48-63 have some missing data (identified by fields of 9's) beyond that signaled by the Quality of data code. Record 2, columns 64-87 are from Table 1, Same Industry Category row. Record 2, columns 88-250 are from Table 5, All Companies column. Record 3 (1972 Enterprise Statistics), columns 8-42 are from Table 5, All Companies column. Record 3, columns 43-244 are from Table 6, All Companies column. Record 4 (1972 Enterprise Statistics), columns 8-15 are from Table 6. Record 4, columns 16-31 are from Table 7. Record 4, columns 34-227 are scaled 0-100. Record 5 (1972 Enterprise Statistics), columns 68-107 are scaled 0-100 Record 6 (Internal Revenue Service, 64 categories) columns 8-189 are from Table 6. Record 6, columns 190-214 are from Table 2. Record 9 (National Income and Product Accounts), columns 8-13 are from Table 6.5 for 1972. Record 9, columns 14-19 are from Table 6.6 for 1972. Record 9, columns 20-24 are from Table 6.7 for 1972. Record 9, columns 25-29 are from Table 6.8 for 1972. Record 9, columns 30-37 are from Table 6.3 for 1974. Record 10 (Census of Manufactures), data is from Table 8 for 1972. Record 10, Quality of data code is blank. Out of 83 possible observations in manufacturing, there are 76 valid observations. The 7 missing observations are 'not specified' industries. Record 10, the value of shipments concentration ratios are weighted by the value of shipments in each component industry. Record 10, the employment concentration ratios are weighted by the employment in each component industry. Record 12 (Census of Population), class of worker data is for 1970. Record 13 (Freeman and Medoff, BLS) columns 64-93 are scaled 0-100. Record 14 (Freeman and Medoff, CPS) columns 86-115 are scaled 0-100. Record 15 (cross source) all dollar amounts are in $100,000's. COR #335 - Page 42 of 42 DATA SOURCES Freeman, R.B. and J.L. Medoff 1979 "New Estimates of Private Sector Unionism in the United States." Industrial and Labor Relations Review 32:143-174. Scherer, Frederick 1970 Industrial Market Structure and Economic Performance. Chicago: Rand McNally. U.S., Bureau of the Census 1962 Census of Population, 1960. Subject Reports: Occupation by Industry. Washington, D.C.: U.S. Government Printing Office. U.S., Bureau of the Census l972 Census of Population, 1970. Subject Reports: Occupation by Industry . Washington, D.C.: U.S. Government Printing Office. U.S., Bureau of the Census 1972 Enterprise Statistics, 1967. Volume 1, General Report on Industrial Organization. Washington, D.C.: U.S. Government Printing Office. U.S., Bureau of the Census 1977 Enterprise Statistics, 1972. Volume 1, General Report on Industrial Organization. Washington, D.C.: U.S. Government Printing Office. U.S., Bureau of Economic Analysis 1976 The National Income and Product Accounts of the United States, 1929-74. Statistical Tables. Washington, D.C.: U.S. Government Printing Office. U.S., Bureau of Labor Statistics. 1972 Census of Manufactures. Washington, D.C.: U.S. Government Printing Office. U.S., Department of Commerce, Interindustry Economics Division 1967 Input-Output Study, 1967: Interindustry Transactions and Trade and Transportation Costs. (Machine readable data file). Washington, D.C.: U.S. Department of Commerce (producer). Madison, Wisconsin: Data and Program Library Service (distributor). U.S., Internal Revenue Service 1977 Statistics of Income, 1972. Volume 1, Coproration Income Tax Returns. Washington, D.C.: U.S. Government Printing Office.