|
|
|
| ||||
Last Loaded on Web: Thursday, May 01, 2008
American Business Directory (File 531), produced by InfoUSA, contains company address, current address, telephone number, employment data, key contact and title, primary Standard Industrial Classification (SIC) code, yellow pages and brand/trade name information, actual and estimated financial data, and corporate linkages on over 12 million U.S. business establishments.
Data is compiled through a continuous updating cycle of compilation from print sources (including over 5,000 yellow-page books) and telephone interviews capturing additional data, such as primary line of business, key contacts, and actual employee size. Annual reports are used for public company data.
USE FILE 531to find directory information on U.S. businesses. USE /CO OR CO=to search for names of companies and businesses. USE SC=to find companies by SIC code. USE REPORTto arrange output in easy-to-read tabular format. /p> |
American Business Directory covers U.S. company locations and classifies them by SIC industry codes. The 4-digit SIC codes have been enhanced to 6 digits so that searches can be more specifically targeted to any telephone directory classification. Brand names and franchise descriptions are also available on many SIC codes, providing the ability to retrieve professionals by specialty and identify product brands and true franchises. Coverage includes:
| Dates Covered: | Current |
|---|---|
| File Size: | 12,682,362 records as of January 2006 |
| Update Frequency: | Monthly |
| ACRONYM | CATEGORY NAME |
|---|---|
| CODIR | Company Directories |
| TICKERDI | Company Directories with Ticker Symbols |
| USCO | U.S. Company Directories |
|
American Business Directory is produced by InfoUSA. Questions concerning file content should be directed to: The Knowledge Center 11000 Regency Parkway, Suite 10 Cary, NC 27511
|
Database copyrighted by InfoUSA. Data may not be duplicated in hard copy or machine-readable form without written authorization from the database supplier. For the Dialog's Redistribution and Archive Policy, enter HELP ERA online.
Customers may access and use information from File 531 for the purpose of general research ("Research") only. Such Research shall in no event include (a) telemarketing applications; (b) direct mail applications; (c) sales lead generation of any kind; or (d) the generation, enhancement or verification of directories or compilations of any kind.
Dialog Standard Terms & Conditions apply.
| DIALOG(R)File 531:Amer. Bus. Directory | |
| (c) 2004 InfoUSA. All rts. reserv. | |
| (Not actual data - this sample combines more than one record) | |
| 08498650 | |
| /CO, CO= | SHERWIN-WILLIAMS CO |
| 101 W PROSPECT AVE # 1500 | |
| CY=,ST=,ZP= | CLEVELAND, OH 44115-1075 |
| TE= | TELEPHONE: 216-566-2000 |
| CX= | COUNTY: CUYAHOGA |
| MC=,MN= | MSA: 1680 (CLEVELAND-LORAIN-ELYRIA, OHIO) |
| IN= | INDUSTRY: MANUFACTURING |
| PRIMARY SIC AND YELLOW PAGE PRODUCT LINE(S): | |
| PC=,P2=,SC= | 2851 (PAINTS VARNISHES LACQUERS & ENAMELS) |
| /DE | 285103 (PAINT-MANUFACTURERS) |
| SECONDARY SIC(S) AND YELLOW PAGE PRODUCT LINE(S): | |
| SC=,S2=,/DE | 2759 (COMMERCIAL PRINTING NEC) |
| 275998 (COMMERCIAL PRINTING NEC) | |
| 2891 (ADHESIVES & SEALANTS) | |
| 289198 (ADHESIVES & SEALANTS (MANUFACTURERS)) | |
| 3991 (BROOMS & BRUSHES) | |
| 399198 (BROOMS & BRUSHES (MANUFACTURERS)) | |
| 5231 (PAINT GLASS & WALLPAPER STORES) | |
| 523107 (PAINT-RETAIL) | |
| 5713 (FLOOR COVERING STORES) | |
| 571305 (CARPET & RUG DEALERS-NEW) | |
| ( . . . ) | |
| /TN, TN= | FRANCHISES: SHERWIN WILLIAMS |
| EH= | EMPLOYEES AT THIS LOCATION: 2,500 (ACTUAL) |
| SA= | LOCATION SALES($): 5,066,000,000 |
| TOTAL BUSINESS LOCATIONS: 2,650 | |
| TOTAL ESTIMATED CORPORATE SALES($): 5,066,000,000 | |
| EM= | TOTAL NUMBER OF EMPLOYEES: 25,789 |
| TOP EXECUTIVE (THIS LOCATION): CHRISTOPHER CONNOR / CEO | |
| IP=,PK= | IMMEDIATE PARENT: SHERWIN-WILLIAMS PAINT STORES (415537463) |
| UN=,UK= | ULTIMATE PARENT: SHERWIN-WILLIAMS CO (007533870) |
| TOTAL ESTIMATED CORPORATE SALES($): 4,881,103,000 | |
| NM= | TOP EXECUTIVE (THIS LOCATION): SCOTT CLOUDY / MANAGER |
| EXECUTIVES (THIS LOCATION): | |
| CHRISTOPHER CONNOR / CHAIRMAN | |
| JOSEPH M SCAMINACE / PRESIDENT | |
| JOSEPH M SCAMINACE / COO | |
| SEAN P HENNESSY / CFO | |
| SEAN P HENNESSY / TREASURER | |
| JOHN L AULT / CONTROLLER | |
| RICHARD M WEAVER / VP ADMIN | |
| CONWAY G IVY / VP CORP COMM | |
| ( . . . ) | |
| CK= | THIS LOCATION NUMBER: 007533870 |
| SF= | THIS IS A HEADQUARTERS. |
| TS= | THIS IS A PUBLIC COMPANY. STOCK EXCHANGE: NEW YORK TICKER SYMBOL:SHW |
| FO= | FORTUNE NUMBER: 0339 |
| PD=,PY= | LATEST UPDATE TO RECORD: 0109 |
| SEARCH SUFFIX |
DISPLAY CODE |
REPORT (FIELD LENGTH) |
FIELD NAME |
INDEXING |
SELECT EXAMPLES |
|---|---|---|---|---|---|
| None | None | None | All Basic Index Fields | Word | S PAINTS AND VARNISH? |
| /CO | CO | CO (32) | Company Name1 | Word | S SHERWIN(W)WILLIAMS/CO |
| /DE | DE | None | Standard Industrial Classification (SIC) Code Descriptions, Brand/Trade/Franchise Name2 | Word | S PAINT(W)GLASS(W)WALLPAPER/DE |
| /TN | TN | None | Brand/Trade/Franchise Name1 | Word | S SHERWIN(W)WILLIAMS/TN |
1 Searchable in the Basic Index and in the Additional Indexes.
2 Available only for selected SIC codes.
| SEARCH PREFIX |
DISPLAY CODE |
REPORT (FIELD LENGTH) |
FIELD NAME |
INDEXING |
SELECT EXAMPLES |
|---|---|---|---|---|---|
| None | A1 | A1 (32) | Street Address | ||
| AA= | AA | None | DIALOG Accession Number | Phrase | S AA=000004010 |
| CK= | CK | CK (11) | ABI Company Number | Phrase | S CK=166795039 |
| CN= | CN | None | Country Name | Phrase | S CN=USA |
| CO= | CO | CO (32) | Company Name1 | Phrase | S CO=SHERWIN-WILLIAMS? |
| CX= | CX | CX (22) | County Name | Phrase | S CX=LARAMIE |
| CY= | CY | CY (15) | City | Phrase | S CY=CHEYENNE |
| EH= | EH | EH (11) | Employees Here3,4 | Numeric | S EH=3:5 |
| EM= | EM | EM (11) | Employees Total3,4 | Numeric | S EM=20,000:25,000 |
| FO= | FO | FO (9) | Fortune Number | Phrase | S FO=0315 |
| IN= | IN | None | Industry | Phrase | S IN=RETAIL TRADE |
| IP= | IP | IP (32) | Immediate Parent | Phrase | S IP=SHERWIN-WILLIAMS? |
| MC= | MC | MC (6) | Metropolitan Statistical Area (MSA) Code | Phrase | S MC=1580 |
| MN= | MN | MN (32) | Metropolitan Statistical Area (MSA) Name | Phrase | S MN=CHEYENNE, WYOMING |
| NE= | NE | NE (9) | Number of Locations5 | Numeric | S NE>=2000 |
| NM= | NM | NM (32) | Executive Name5 | Word | S NM=(SCOTT(1N)CLOUDY) |
| P2= | None | None | 2-digit Primary SIC Code | Phrase | S P2=52 |
| PC= | PC | PC (9) | Primary SIC Code | Phrase | S PC=5231 |
| PD= | PD | None | Latest Update to Record | Phrase | S PD=200207? |
| PK= | PK | None | ABI Immediate Parent Company Number | Phrase | S PK=41537463 |
| PO= | None | PO (34) | Executive Postion | Phrase | S PO=MANAGER |
| PY= | PY | None | Publication Year | Phrase | S PY=2002 |
| S2= | None | None | 2-digit SIC Code | Phrase | S S2=50 |
| SA= | SA | SA (17) | Sales (Estimated)3 | Numeric | S SA>=500K |
| SC= | SC | None | Standard Industrial Classification (SIC) Code | Phrase | S SC=5085 S SC=508508 |
| SF= | SF | None | Special Feature6 | Phrase | S SF=BRANCH |
| ST= | ST | ST (10) | State | Phrase | S ST=WY |
| TE= | TE | TE (14) | Telephone Number Area Code | Phrase | S TE=307 |
| TN= | TN | None | Brand/Trade/Franchise Names1 | Phrase | S TN=SHERWIN WILLIAMS |
| TS= | TS | TS (7) | Ticker Symbol | Phrase | S TS=SHW |
| UD= | None | None | Update | Phrase | S UD=9999 |
| UK= | UK | UK (11) | ABI Ultimate (Corporate) Number7 | Phrase | S UK=007533870 |
| UN= | UN | UN (32) | Ultimate Parent Company Name | Phrase | S UN=SHERWIN-WILLIAMS? |
| ZP= | ZP | ZP (12) | Zip Code8 | Phrase | S ZP=82001 |
3 Numeric entries are indexed as complete numbers, rounded down to the two left-most digits. Negative numbers are preceded by a minus sign. Use numeric operators (>, <, <=, >=) to search a range of values, e.g., S SA>=10M to retrieve all records with sales of 10 million or higher.
4 For Parent and Subsidiary Companies only; no Ultimate parent companies included.
6 The following entries are searchable with SF=: BRANCH, HEADQUARTERS, PUBLIC, SUBSIDIARY.
7 To retrieve companies in the same corporate family, use the Ultimate Parent Company Number with the search prefix UK=. To retrieve the Ultimate Parent Location record, use the Ultimate Parent Company Number with the search prefix CK=.
8 Five-digit zip code searchable only. Full postal code displays.
| Sets and terms may be limited by Basic Index suffixes, i.e., /CO, /DE, /TN (e.g., S S5/DE), as well as by the following feature: | ||
| SUFFIX | FIELD NAME | EXAMPLES |
|---|---|---|
| /NAMES | At Least 1 Executive Name Available | S S3/NAMES |
| /UNDERTEN | Between 1 and 9 Employees at This Location | S S2/UNDERTEN |
| SORTABLE FIELDS | EXAMPLES |
|---|---|
| AA, CO, CX, CY, EH, EM, FO, IP, MN, NE, PC, PD, PK, SA, ST, TE, UK, UN, ZP | SORT S13/ALL/PC/SA,D PRINT S5/5/1-24/ZP |
| RANK FIELDS | EXAMPLES |
|---|---|
| All phrase- and numeric-indexed fields in the Additional Indexes can be ranked. | RANK MN S3 |
| MAP FIELDS | EXAMPLES |
|---|---|
| UK | MAP UK TEMP S5 |
| 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,EM,SA/ALL |
| User-defined formats may be specified using the display codes indicated in the Search Options tables. | TYPE S3/CO,PC/1-5 |
| NO. |
DIALOGWEB FORMAT |
RECORD CONTENT |
|---|---|---|
| 1 | -- | DIALOG Accession Number |
| 2 | -- | Company Name, Address, Telephone Number, SIC Description, Top Executive Name, and Sales |
| 3 | Medium | Company Name, Address, Telephone Number, SIC Description, and Top Executive Name |
| 4 | -- | Company Name, Address, Telephone Number, and Top Executive Name |
| 5 | -- | Full Record |
| 6 | -- | Company Name and Latest Update to Record |
| 7 | Long | Company Name, ABI Company Number, SIC Description, and Sales |
| 8 | Short | Company Name, ABI Company Number, SIC Description, and Address |
| 9 | Full | Full Record |
| 10 | -- | National Address (excludes country) |
| 20 | -- | International Address (includes country) |
| 30 | -- | National Address with Executive Name |
| 40 | -- | International Address with Executive Name |
| FIELD NAME | EXAMPLES | ||
|---|---|---|---|
| DIALOG Accession Number | TYPE 87865530/5 DISPLAY 7774483/CO,PC PRINT 7301964/5 |
||
Rates For File: American Business Directory[531]
Cost per DialUnit: $6.21
Cost per minute: $1.74
Report Elements $0.30
Rank Elements $0.02
Format Types Prints
1 $0.00 $0.00
2 $3.00 $3.00
3 $2.62 $2.62
4 $2.29 $2.29
5 $3.00 $3.00
6 $0.27 $0.27
7 $1.58 $1.58
8 $1.58 $1.58
9 $3.00 $3.00
10 $0.49 $0.49
20 $0.49 $0.49
30 $0.49 $0.49
40 $0.49 $0.49
66 $2.18 $2.18
KWIC95 $0.00 NA
KWIC96 $0.00 $0.00
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
