|
|
|
| ||||
Last Loaded on Web: Thursday, May 01, 2008
Corporate Affiliations, a database produced by LexisNexis Group, a division of Reed Elsevier Inc., contains business profiles and corporate linkage ("who owns whom") for approximately 184,000 public and private companies worldwide.
Each record includes the name, address, telephone number, sales,number of employees, SIC codes, business description, executive names, director names, corporate family hierarchy, ticker symbol, stock exchanges, net worth, total assets, and total liabilities, where available.
USE FILE 513to find company ownership information. USE /CO OR CO=to find company names. USE /PARENT or /AFFILIATEto restrict retrieval to parent records or to affiliate records. USE FORMAT 6to view the number of affiliates. /p> |
The Corporate Affiliations database covers over 184,000 U.S. and non-U.S. companies in manufacturing, distribution, and service areas. This includes private as well as public companies, both parents and affiliates (subsidiatries and major divisions). All major domestic and international stock exchange listed companies (except investment instuments) are profiled.
U.S. privately held companies with annual sales in excess of $10 million and foreign privately held companies with annual sales in excess of $50 million are profiled.
Information for the Corporate Affiliations database is gathered by direct telephone contact and in-house research in an ongoing process throughout the year.
| Dates Covered: | Current edition |
|---|---|
| File Size: | 174,679 U.S. and international companies as of January 2006 |
| Update Frequency: | Quarterly reload |
| ACRONYM | CATEGORY NAME |
|---|---|
| ASIACO | Asia/Pacific Company Directories |
| CANADACO | Canadian Company Directories |
| CODIR | Company Directories |
| CORPHIER | Corporate Structure and Hierarchy |
| EUROPECO | European Company Directories |
| INTLCO | International Company Directories |
| JAPANCO | Japanese Company Directories |
| LATINCO | Latin American Company Directories |
| MIDEASTC | Middle Eastern/African Company Directories |
| OWNERS | Ownership |
| TICKERDI | Company Directories with Ticker Symbols |
| UKCO | United Kingdom Company Directories |
| USCO | U.S. Company Directories |
|
The Corporate Affiliations database is produced by the LexisNexis Group. Questions concerning file content should be directed to: Corporate Affiliations 121 Chanlon Road New Providence, NJ 07974
|
For Dialog's Redistribution and Archive Policy, enter HELP ERA online. The following terms and conditions also apply.
Copyright 2002 LexisNexis Group, a division of Reed Elsevier Inc. All rights reserved. Limited reproduction of output is permitted for distribution within the user's internal operation, contingent upon payment of multiplier fee. Licensor makes no representations or warranties, express or implied, including warranties of merchantability or fitness for a particular purpose. REED REFERENCE PUBLISHING SHALL HAVE NO LIABILITY FOR LOST PROFITS OR CONSEQUENTIAL DAMAGES RELATED TO THE USE OF (DATABASE) WHETHER SUCH DAMAGES ARE FORESEEABLE OR WHETHER SUCH DAMAGES ARE DEEMED TO RESULT FROM THE FAILURE OR INADEQUACY OF ANY EXCLUSION OR OTHER REMEDY. This database has been supplied under license by LexisNexis Group, a division of Reed Elsevier Inc., and copyright and other proprietary rights are owned by, or licensed exclusively through, LexisNexis Group. The Subscriber or subscriber to this database ("Subscriber") acknowledges that the database is the product of LexisNexis Group's extensive gathering and coordination of information, selection therefrom of information considered by LexisNexis Group to be relevant and useful, and original arrangement of selected information. Duplication, copying, storing, or down-loading in print or electronic format is not permitted without prior written authorization from LexisNexis Group except for reproduction of the results of discrete searches of the database which amount to only limited quantities of reasonable portions for use by the Subscriber and for use within the Subscriber's organization upon payment of a multiplier fee through the ERA Service for Dialog's or through payment of a transactional fee to the Copyright Clearance Center. The permission hereby granted for limited copying is conditioned on including on all copies the attribution of LexisNexis Group as the source of information, and a suitable notice of copyright. Under no circumstances may copies, in any media, be made for resale or redistribution. Subscriber acknowledges that the rate of user fees paid for access to the database, and the limitations of liability set out below, are based in part on the expectation that the Subscriber will bear the risk of any loss which might be incurred due to the use or reliance by the Subscriber or Subscriber's customers on information contained in the database.
| Sample Parent Record | |
| DIALOG(R)File 513: Corporate Affiliations | |
| (c)2004 LexisNexis Group. All rts. reserv. | |
| 01970728 | |
| /CO, CO= | Canon Inc |
| 30-2, Shimomaruko 3-chome Ohta-ku | |
| CY=, CN= | Tokyo 146-8501 Japan |
| Telephone: 03(348)2121 | |
| NO= | LNG Enterprise Number: 020465000 |
| TS=, EX= | Ticket Symbol: CAJ Stock Exchange: FR,FUKUOKA,KYOTO,NSE,NYSE,OSE,SAPPORO, TOKYO, |
| NF= | Number of NonUS Affiliates: 97 |
| NU= | Number of US Affiliates: 18 |
| NT= | Total Number of Affiliates: 115 |
| /DE | Business: Mfr. & Marketer of Cameras, |
| Business Machines & Precision Optical Equipment | |
| SIC Codes (Primary listed first): | |
| PC=,P2=,/DE | 3827 Optical instruments & lenses |
| S2=,/DE | 3571 Electronic computers |
| SC=,/DE | 3861 Photographic equipment & supplies 3577 Computer Peripheral Equipment, NEC |
| EM= | Number of Employees: 93,620 |
| SA= | Sales: $23,312,920,000 |
| TA= Total Assets: $22,809,245,000 | |
| TL= Total Liabilities: $9,660,816,000 | |
| NW= Net Worth: $13,148,438,000 | |
| SF= | This is a(n) Parent, NonUS Company, International Company |
| DS= | Numeric Field(s) Last Updated: 020611 |
| DU= | Textual Field(s) Last Updated): 020531 |
| Executives: | |
| NA= | President, Chief Executive Officer |
| Fujio Mitarai/Chief Executive Officer | |
| Managing Director | |
| Ichiro Endo/Managing Director | |
| Managing Director | |
| Toshizo Tanaka/Managing Director | |
| DO= | Board of Directors:Muneo Adachi; Yusuke Emura; Ichiro Endo; Jinji |
| Ichikawa; Fujio Mitarai; Yasuo Mitsuhashi; Akiyoshi Moroe; | |
| Takashi Saito; Ikuo Soma; Akira Tajima; Teruomi Takahashi; Toru | |
| Takahashi; Nobuyoshi Tanaka; Toshizo Tanaka; Hajime Tsurusoka; | |
| Corporate Family Hierarchy: | |
| =>Canon Inc 1970728<= | |
| Canon Aptex Inc. (Manufacturing Subsidiary:) 1970727 | |
| Canon Chemicals Inc. (Manufacturing Subsidiary:) 1970726 | |
| Canon Components, Inc. (Manufacturing Subsidiary:) 1970725 | |
| Canon Electronics Inc. (Manufacturing Subsidiary:) 197024 | |
| (. . .) | |
| Canon U.S.A., Inc. (Marketing Subsidiary:)1970694 | |
| Canon Information Technical Svc. Inc. (Division)1970693 | |
| Canon Business Solutions, Inc. (Subsidiary) 1970692 | |
Sample Affiliate Record | |
| 01970692 | |
| /CO, CO= | Canon Business Solutions, Inc. |
| 425 N Martingale Rd Ste 1400 | |
| CY=, ZP=, CN= | Schaumburg, IL 60173-2212 USA |
| Telephone: 847-706-3400 | |
| IN= | State of Incorporation: IL |
| NO= | NRPC Number: 020465007 |
| UP=, UO= | Ultimate Parent: Canon Inc, (Japan) 1970728 |
| IP=, IO= | Immediate Parent: Canon USA Inc, USA 1970694 |
| SH= | Ownership by Parent: 100 % |
| NF= | Number of NonUS Affiliates: 97 |
| NU= | Number of US Affiliates: 18 |
| NT= | Total Number of Affiliates: 115 |
| /DE | Business: Marketing & Distribution of Canon Products |
| SIC Codes (Primary listed first): | |
| SC=, PC=, S2=, P2= | 5045 Computers & computer peripheral equipment & |
| software-wholesale | |
| SF= | This is a(n) Affiliate, US, International Company |
| NA= | Executives: President, Chief Officer of Subsidiary, Administration/Operations |
| Emily Reynolds/Administration/Operations | |
| Corporate Family Hierarchy: | |
| Canon Inc 1970728 | |
| Canon U.S.A Inc. (Marketing Subsidiary:) 1970694 | |
| =>Canon Business Solutions, Inc. 1970694<= |
| SEARCH SUFFIX |
DISPLAY CODE |
REPORT (FIELD LENGTH) |
FIELD NAME |
INDEXING |
SELECT EXAMPLES |
|---|---|---|---|---|---|
| None | None | None | All Basic Index Fields | Word | S CAMERA?(S)MANUFACTUR? |
| /CO | CO | CO (32) | Company Name1,2 | Word | S CANON?/CO |
| /DE | DE | None | Description of Business and SIC Descriptions | Word | S BUSINESS(W)MACHINE?/DE |
2 Also searches former company name.
| SEARCH PREFIX |
DISPLAY CODE |
REPORT (FIELD LENGTH) |
FIELD NAME |
INDEXING |
SELECT EXAMPLES |
|---|---|---|---|---|---|
| None | AN | AN (9) | DIALOG Accession Number | ||
| CN= | CN | CN (29) | Country Name | Phrase | S CN=JAPAN |
| CO= | CO | CO (32) | Company Name2 | Phrase | S CO=CANON? |
| CY= | CY | CY (32) | City | Phrase | S CY=TOKYO |
| DO= | DO | None | Director Name4 | Phrase | S DO=MUNEO ADACHI |
| DS= | DS | None | Numeric Field(s) Last Updated | Phrase | S DS=020611 |
| DU= | DU | None | Textual Field(s) Last Updated | Phrase | S DU=020531 |
| EM= | EM | EM (12) | Number of Employees5 | Numeric | S EM>=40K |
| EX= | EX | None | Stock Exchange4 | Phrase | S EX=FR |
| None | HR | None | Corporate Family Hierarchy | ||
| IN= | IN | IN (8) | State of Incorporation | Phrase | S IN=IL |
| IO= | IO | IO (29) | Immediate Parent Country | Phrase | S IO=JAPAN |
| IP= | IP | IP (32) | Immediate Parent Company Name6 | Phrase | S IP=CANON U.S.A.? |
| NA= | NA | None | Executive Name | Phrase | S NA=TANAKA, T.? |
| NF= | NF | NF (8) | Number of Non-U.S. Affiliates5 | Numeric | S NF<100 |
| NO= | NO | NO (11) | LNG Enterprise Number7 | Phrase | S NO=020465000 S NO=020465 |
| NT= | NT | NT (8) | Number of Affiliates, Total5 | Numeric | S NT>=20 |
| NU= | NU | NU (8) | Number of U.S. Affiliates4,5 | Numeric | S NU=115 |
| NW= | NW | NW (19) | Net Worth4,5 | Numeric | S NW=10M:30M |
| P2= | None | None | 2-digit Primary SIC Code8 | Phrase | S P2=38:40 |
| PC= | PC | None | Primary SIC Code8 | Phrase | S PC=3827 |
| PO= | None | None | Position9 | Phrase | S PO=CONTROLLER? |
| PS= | None | None | Position Code10 | Phrase | S PS=011 |
| S2= | None | None | 2-digit SIC Code8 | Phrase | S S2=34 |
| SA= | SA | SA (19) | Sales in U.S. Dollars5 | Phrase | S SA=1B:10B |
| SC= | SC | None | Standard Industrial Classification (SIC) Code8 | Phrase | S SC=3577 |
| SF= | SF | None | Special Feature11 | Phrase | S SF=PARENT |
| SH= | SH | SH (9) | Ownership by Parent (%)5 | Numeric | S SH=100% |
| ST= | ST | ST (7) | State or Province | Phrase | S ST=IL |
| TA= | TA | TA (19) | Total Assets4,5 | Numeric | S TA=22b:25b |
| TE= | TE | TE (14) | Telephone Area Code2,12 | Phrase | S TE=847 |
| TL= | TL | TL (19) | Total Liabilities4,5 | Numeric | S TL=9b:10b |
| TS= | TS | TS (9) | Ticker Symbol4 | Phrase | S TS=CAJ |
| UO= | UO | UO (29) | Ultimate Parent Country | Phrase | S UO=JAPAN |
| UP= | UP | UP (32) | Ultimate Parent Company Name13 | Phrase | S UP=CANON, INC? |
| ZP= | ZP | ZP (12) | Zip Code | Phrase | S ZP=60173 |
4 Available for parent company records only.
5 Numeric entries are indexed as complete numbers, rounded down to the two left-most digits. Use numeric operators (:,>,<,=,etc.) to search a range of values, e.g., S SA>5B to find companies with sales over 5 billion.
6 Retrieves affiliate companies that report directly to the immediate parent. The immediate parent can be the ultimate parent or another affilate.
7 The first six digits of the LNG Enterprise number are also indexed with the NO=prefix. Searching on the six-digit number retrieves all companies in the corporate family, both parent and affiliate.
8 SIC codes are 1987 U.S. Codes.
9 EXPAND PO=A for a complete list of positions.
10 EXPAND PS=1 for a complte list of position codes.
11 These entries are searchable with SF=: AFFILIATE; PARENT;PRIVATE;U.S.; NONUS.
12 U.S. telephone area codes are searchabe using TE=. All telephone numbers may be displayed in a report, use TE.
13 Retrieves all affliate companies of the ultimate parent company.
| Sets and terms may be limited by Basic Index suffixes, i.e., /CO, /DE (e.g., SELECT S3/CO), as well as by the features listes below: | ||
| SUFFIX | FIELD NAME | EXAMPLES |
|---|---|---|
| /AFFILIATE | Affiliate company records | S S4/AFFILIATE |
| /NONUS | Companies not in the U.S. | S CANON/NONUS |
| /PARENT | Parent company records | S CANON/PARENT |
| /US | Companies located in the U.S. | S S1/US |
| SORTABLE FIELDS | EXAMPLES |
|---|---|
| CN, CO, CY, EM, IN, NW, PC, SA, ST, TA, TE, TL, TS, ZP | SORT S4/ALL/ST,CY PRINT S5/3/ALL/ST |
| RANK FIELDS | EXAMPLES |
|---|---|
| All phrase- and numeric-indexed fields in the Additional Indexes can be ranked. | RANK CO S3 |
| MAP FIELDS | EXAMPLES |
|---|---|
| CO, IP, NO, UP | MAP UP TEMP S1 |
| Output can be displayed in table format. REPORT codes with field lengths in parentheses are listed in the Search Options tables. Default table width is 72 characters; use SET H 132 to set maximum table width. | REPORT S2/CO,IP/ALL |
| User-defined formats may be specified using the display codes indicated in the Search Options tables. | TYPE S2/CO,EX,TS/1-5 |
| NO. |
DIALOGWEB FORMAT |
RECORD CONTENT |
|---|---|---|
| 1 | -- | DIALOG Accession Number |
| 2 | -- | Full Record except Executive/Director Names and Corporate Hierarchy |
| 3 | Medium | Company Name, Address, Telephone Number, LNG Enterprise Number, Ticker Symbol, Stock Exchange, Description of Business, and SIC Codes |
| 5 | Long | Full Record except Corporate Hierarchy |
| 6 | -- | Company name, LNG Enterprise Number, and Number of Affiliates |
| 7 | -- | Company Name, Address, LNG Enterprise Number, and Update Fields |
| 8 | Short | Company Name and Address |
| 10 | -- | National Address (excludes country) |
| 20 | Full | International Address (includes country) |
| K | -- | KWIC (Key Word In Context) displays a window of text; may be used alone or with other formats |
| FIELD NAME | EXAMPLES | ||
|---|---|---|---|
| DIALOG Accession Number | TYPE 1951420/5 DISPLAY 1951413/CO,UO PRINT 1951409/3 |
||
Rates For File: Corporate Affiliations[513]
Cost per DialUnit: $8.31
Cost per minute: $1.77
Report Elements $0.15
Rank Elements $0.00
Format Types Prints
1 $0.00 $0.00
2 $3.72 $3.72
3 $3.45 $3.45
5 $5.30 $5.30
6 $0.53 $0.53
7 $3.45 $3.45
8 $1.06 $1.06
9 $0.00 $0.00
10 $1.33 $1.33
11 $7.42 $7.42
12 $22.26 $22.26
13 $44.52 $44.52
14 $66.78 $66.78
15 $89.04 $89.04
16 $111.30 $111.30
17 $133.56 $133.56
18 $155.82 $155.82
19 $178.08 $178.08
20 $185.50 $185.50
KWIC95 $0.11 NA
KWIC96 $0.11 NA
REDIST/COPY Multiplier Table:
Range Multiplier
1-2 1.00
3-25 1.50
26-100 3.00
101-200 4.00
201-500 6.00
501-1000 8.00
1001 or more 10.00
ARCHIVE Multiplier Table:
Range Multiplier
1-25 1.50
26-200 3.00
201-500 6.00
501-1000 8.00
1001 or more 10.00
------------
Note:
Full record prices are based on the number of affiliates
in a corporate family hierarchy. Use Format 6 to view the
number of affiliates in a corporate family hierarchy. Full
record prices are as follows:
1-3 affiliates $7.00
4-10 affiliates $21.00
11-20 affiliates $42.00
21-30 affiliates $63.00
31-40 affiliates $84.00
41-50 affiliates $105.00
51-60 affiliates $126.00
61-70 affiliates $147.00
71-80 affiliates $168.00
81+ affiliates $175.00
