The Primary SIC Code (Field # 39) is given in 6 digits. InfoUSA refines the standard 4 digit SIC code into 6 digits for finer grained classification. The NAICS Code (Field # 54) is given in 8 digits. Once again InfoUSA refines the standard 6 digit NAICS code into 8 digits for finer grained classification. The NAICS has no sector for Nonclassifiable Establishments (SIC Code 999) and hence these are left blank in the database. Each SIC and NAICS code has the description in the next column. Instances where more than one SIC code is present indicates that the establishment has multiple lines of business. For example, a gas station will only have one SIC code it that is the only business of the gas station. If it is also a convenience store then it will have two SIC codes, gas station, and convenience store. If a car wash is also present then it will have three SIC codes, gas, convenience, and car wash. A code book for the various fields is given in Appendix A.
As part of the data check, the 2 and 3 digit SIC codes were extracted from the data to review the distribution of employment by District and County. The following four employment categories were used to obtain the distribution of employment by place of work: Manufacturing Employment (SIC Code 20 to 51) Other Industrial Employment (SIC Code 01 to 19) Commercial Employment (SIC Code 52 to 59) Service Employment (SIC Code 60 to 67, 70 to 89, and 99)
---------------------------------------------------------
infoUSA Inc. Terms & Conditions We require the buyer to use this information in compliance with any and all applicable Federal and State laws, rules, and regulations, including but not limited to those concerning fax broadcasts, e-mail transmissions, and direct marketing. Any person violating such laws may be subject to civil and criminal penalties, which may exceed $500 for each transmission of an unsolicited facsimile. Buyers will abide by the current business practices respecting the privacy of consumers and will not imply to an individual that any specific information is known about that individual.
Buyers shall abide by the terms of the Security Policy Buyers may rent information for confidential use by the Buyer within one year from the date of rental to the Buyer. Except with written consent, the Buyer shall not:
Use or permit the use of the information for generating any statistical information which is sold, rented, published, furnished or in any manner provided to a third party;
Use or permit the use of the information to prepare any comparison to other information databases, which is sold, rented, published, furnished or in any manner provided to a third party; Use or permit the use of the information in connection with individual credit, employment or insurance applications.
Rerent the information or otherwise permit any use of the information by or for the benefit of any party other than Buyer;
Publish, distribute or permit disclosure of the information, other than to employees and agents of the Buyer for internal use in the Buyer's business;
Use or permit use of the information for the purpose of compiling, enhancing, verifying, supplementing adding to, or deleting from any mailing list, geographic or trade directories, business directories, classified directories, classified advertising, or other compilation of information which is sold, rented, published, furnished or in any manner provided to a third party.
We do not warrant the comprehensiveness, completeness, or accuracy of its databases or the lists. The databases and lists are provided to customer "as is" without guarantee, and we make no express or implied warranties, including without limitation, any express or implied warranties of merchantability or fitness for a particular purpose. We shall not be liable for any consequential, incidental, special damages, lost profits or any damages of a similar nature even if we have been advised of the possibility of such damages.
Changes to these Terms & Conditions This policy may be amended from time to time, consistent with the requirements of the terms & conditions. A notice will be posted on infoUSA's web page A notice will be posted on infoUSA's web page www.infousa.com
EFFECTIVE DATE: April 1, 2006
WARNING!! DO NOT USE THIS INFORMATION AFTER 12 MONTHS FROM PRODUCTION DATE
Our Business Database changes by over 40% in just one year. New companies start up, others go out of business, and many move or change their phone number. And key executive names can change even faster. Using this product after the Warning Date may result in wasted time and effort, since much of the information will be out of date. Please call us for an updated product.
A note about data scale:
Scale is an important factor in data usage. Certain scale datasets are not suitable for some project, analysis, or modeling purposes. Please be sure you are using the best available data.
1:24000 scale datasets are recommended for projects that are at the county level. 1:24000 data should NOT be used for high accuracy base mapping such as property parcel boundaries. 1:100000 scale datasets are recommended for projects that are at the multi-county or regional level. 1:125000 scale datasets are recommended for projects that are at the regional or state level or larger.
Vector datasets with no defined scale or accuracy should be considered suspect. Make sure you are familiar with your data before using it for projects or analysis. Every effort has been made to supply the user with data documentation. For additional information, see the References section and the Data Source Contact section of this documentation. For more information regarding scale and accuracy, see our webpage at: <http://geoplan.ufl.edu/education.html>
-------------------------------------
infoUSA, Inc. Corporate Headquarters 5711 South 86th Circle Omaha, NE 68127 Phone: 402.593.4500 Fax: 402.593.4671 www.infousa.com
------------------------------------- infoUSA, Inc. Database & Technology Center 1020 E 1st Street Papillion, NE 68046 Phone: 402.930.3500 Fax: 402.331.0176 www.infousa.com
Table 1. List of Variables in January 2005 InfoUSA Data
Field # NAME 1 CONTACT_NAME 2 Company_Name 3 Address 4 City 5 State 6 ZIP_Code 7 Zip_10 8 Carrier_Route_Code 9 State_Code 10 County_Code 11 Phone 12 FILLER 13 Selected_SIC_Code 14 Secondary_SIC_Desc_1 15 Franchise_Specialty_Codes 16 Ad_Size_Code 17 CREDIT_CREDIT 18 Population_Code 19 Individual_Firm_Code 20 Year_First_Appeared_In_Yellow_Pages 21 New_Add_Date 22 Last_Name 23 First_Name 24 Professional_Title 25 Title_Code 26 Gender 27 Location_Employment_Size_Code 28 Actual_Location_Employment_Size 29 Location_Sales_Volume_Code 30 Industry_Specific_Code 31 HQ_Branch_Code 32 Key_Code 33 Fax_Number 34 Office_Size_Code 35 CURRENT_DATE (MMDDYY) 36 Location_Number 37 infoUSA_Subsidiary_ID 38 infoUSA_Parent_ID 39 Primary_SIC_Code 40 SIC_DESCRIPTION 41 Secondary_SIC_Code_1 42 Secondary_SIC_Desc_2 43 Secondary_SIC_Code_2 44 Secondary_SIC_Desc_3 45 Secondary_SIC_Code_3 46 Secondary_SIC_Desc_4 47 Secondary_SIC_Code_4 48 Secondary_SIC_Desc_5 49 LATTITUDE 50 LONGITUDE 51 MATCH_LEVEL 52 CENSUS_TRACT 53 CENSUS_BLOCK_GROUP 54 NAICS_Code 55 NAICS_DESCRIPTION
Cambridge Systematics then added the spatial component by Geocoding the street addresses.
The dataset was projected to FGDL Albers HPGN.
The table was then restructured, as represented below.
Field # NAME (January 2005) NAME (October 2006) 1 CONTACT_NAME CONTACT 2 Company_Name NAME 3 Address ADDRESS 4 City CITY 6 ZIP_Code ZIPCODE 7 Zip_10 ZIPFULL 11 Phone PHONE 13 Selected_SIC_Code SIC_CODE 14 Secondary_SIC_Desc_1 SIC_CODE_D 15 Franchise_Specialty_Codes FRANCHISE 18 Population_Code POPULATION 19 Individual_Firm_Code INDIVIDUAL 20 Year_First_Appeared_In_Yellow_Pages FIRST_YEAR 27 Location_Employment_Size_Code L_EMPLOY 28 Actual_Location_Employment_Size A_EMPLOY 29 Location_Sales_Volume_Code SALE_VOL 30 Industry_Specific_Code INDUSTRY 31 HQ_Branch_Code HQ_BRANCH 34 Office_Size_Code OFFICE_SIZE 36 Location_Number LOC_NUMB 39 Primary_SIC_Code PRIM_SIC 40 SIC_DESCRIPTION PRIM_SIC_D 41 Secondary_SIC_Code_1 SEC_SIC 42 Secondary_SIC_Desc_2 SEC_SIC_D 43 Secondary_SIC_Code_2 TER_SIC 44 Secondary_SIC_Desc_3 TER_SIC_D 49 LATTITUDE LATTITUDE 50 LONGITUDE LONGITUDE 51 MATCH_LEVEL MATCH_LEVEL 54 NAICS_Code NAICS_CODE 55 NAICS_DESCRIPTION NAICS_DESC
Added DESCRIPT field based on field 'PRIM_SIC_D' Added EXISTING Added UPDATE_DAY Added FGDLAQDATE Added AUTOID
Hospitals (# of Beds) A 1 - 24 B 25 - 49 C 50 - 99 D 100 - 199 E 200 - 299 F 300 - 399 G 400 - 499 H 500 + Nursing Homes (# of Beds) A 1 - 19 B 20 - 99 C 100 - 249 D 250 - 499 E 500 + Hotels/Motels (# of Rooms) A 1 - 24 B 25 - 49 C 50 - 99 D 100 - 299 E 300 - 499 F 500 - 999 G 1000 + Schools/Colleges (Enrollment) A 1 - 299 B 300 - 499 C 500 - 999 D 1000 - 9999 E 10000 + Restaurants (Cuisine Codes) A Bistro B Brew Pub C Chinese D Deli E Barbecue F Indian G Cajun H Soul Food I Italian J Japanese K Korean L Caribbean M Irish P Pizza Q Swiss R Middle Eastern S Spanish T Thai U Continental V Mexican W Vietnamese Y Oriental Z Seafood 0 Steak House 1 French 9 Greek
---------------------------------------------------------------------------
PRIM_SIC_D COUNT EXISTING ----------------------------------- ------ ------------------- ADULT CARE FACILITIES 102 GC_SOCIALSERVICE AIRLINE COMPANIES 204 GC_INTERMODAL AIRPORT TRANSPORTATION SERVICE 244 GC_INTERMODAL AIRPORTS 121 GC_INTERMODAL ALCOHOLISM INFORMATION & TREATMENT CTRS 331 GC_HEALTH AMUSEMENT & RECREATION NEC 453 GC_CULTURECENTER AMUSEMENT PLACES 215 GC_CULTURECENTER ART INSTRUCTION & SCHOOLS 132 GC_SCHOOLS ASPHALT & ASPHALT PRODUCTS 146 ASPHSRC ASSOCIATIONS 2349 GC_COMMUNITYCENTER ATHLETIC ORGANIZATIONS 150 GC_COMMUNITYCENTER AUTOMOBILE LUBRICATION SERVICE 394 BROWNFIELDS BARS 1257 GC_BARS BED & BREAKFAST ACCOMMODATIONS 266 GC_HOTELS BICYCLES-DEALERS 321 OTHER BOWLING CENTERS 191 GC_CIVICCENTER BUS LINES 116 HURRICANE DATA BUSES-CHARTER & RENTAL 190 HURRICANE DATA CAMPGROUNDS 695 GC_PARKS CAMPS 185 GC_PARKS CEMETERIES 157 GC_CEMETERY CHAMBERS OF COMMERCE 289 GC_GOVBUILD CHILD CARE SERVICE 4426 GC_SOCIALSERVICE CHURCH ORGANIZATIONS 106 GC_RELIGION CHURCHES 16518 GC_RELIGION CITY GOVERNMENT-EXECUTIVE OFFICES 438 GC_GOVBUILD CITY GOVERNMENT-URBAN PLANNING & DEV 121 GC_GOVBUILD CITY GOVT-REGULATION/ADM-COMMS/UTIL 219 GC_GOVBUILD CLEANERS 2825 BROWNFIELDS CLERGY 273 GC_RELIGION CLINICS 2731 GC_HEALTH CONCRETE CONTRACTORS 1193 HURRICANE DATA CONDOMINIUMS 3633 GC_COMMUNITYCENTER CONSTRUCTION COMPANIES 298 HURRICANE DATA CONSTRUCTION MANAGEMENT 321 HURRICANE DATA CONSTRUCTION SITE CLEAN-UP SERVICES 128 HURRICANE DATA CONVENIENCE STORES 5445 HURRICANE DATA COUNSELING SERVICES 743 GC_SOCIALSERVICE COUNTY GOVERNMENT-COURTS 246 GC_GOVBUILD COUNTY GOVERNMENT-ENVIRONMENTAL PROGRAMS 123 GC_GOVBUILD COUNTY GOVERNMENT-FINANCE & TAXATION 164 GC_GOVBUILD COUNTY GOVERNMENT-PUBLIC HEALTH PROGRAMS 149 GC_GOVBUILD COUNTY GOVERNMENT-SOCIAL/HUMAN RESOURCES 180 GC_GOVBUILD DAY CARE CENTERS-ADULT 117 GC_SOCIALSERVICE DEMOLITION CONTRACTORS 128 HURRICANE DATA DENTISTS 6611 GC_HEALTH DRUG ABUSE & ADDICTION INFO & TREATMENT 231 GC_HEALTH EDUCATION CENTERS 157 GC_SCHOOLS ELECTRIC COMPANIES 232 HURRICANE DATA ENTERTAINMENT BUREAUS 359 GC_CULTURECENTER EVENTS-SPECIAL 284 GC_CIVICCENTER FARMS 641 OTHER FEDERAL GOVERNMENT-CONSERVATION DEPTS 136 GC_GOVBUILD FEDERAL GOVERNMENT-INTERNATIONAL AFFAIRS 109 GC_GOVBUILD FEDERAL GOVERNMENT-NATIONAL SECURITY 297 GC_GOVBUILD FIRE DEPARTMENTS 630 GC_FIRESTAT FRATERNAL ORGANIZATIONS 753 GC_COMMUNITYCENTER FUEL MANAGEMENT 852 HURRICANE DATA GARBAGE COLLECTION 356 HURRICANE DATA GAS COMPANIES 113 HURRICANE DATA GAS-LIQUEFIED PETRO-BTTLD/BULK (WHOL) 238 HURRICANE DATA GOLF COURSES-PRIVATE 398 GC_PARKS GOLF COURSES-PUBLIC 662 GC_PARKS GOVERNMENT OFFICES-CITY, VILLAGE & TWP 2419 GC_GOVBUILD GOVERNMENT OFFICES-COUNTY 3362 GC_GOVBUILD GOVERNMENT OFFICES-STATE 980 GC_GOVBUILD GOVERNMENT OFFICES-US 321 GC_GOVBUILD GROCERS-RETAIL 4010 HURRICANE DATA HALLS & AUDITORIUMS 138 GC_CIVICCENTER HEALTH SERVICES 771 GC_HEALTH HOME HEALTH SERVICE 1754 GC_HEALTH HOSPITALS 537 GC_HEALTH HOTELS & MOTELS 4617 GC_HOTELS HOUSING AUTHORITIES 196 GC_SOCIALSERVICE HUMAN SERVICES ORGANIZATIONS 164 GC_SOCIALSERVICE IMMIGRATION & NATURALIZATION SERVICES 232 GC_GOVBUILD LABOR ORGANIZATIONS 410 GC_COMMUNITYCENTER LIBRARIES-PUBLIC 595 GC_CULTURECENTER LUMBER-RETAIL 227 HURRICANE DATA MARINAS 526 GC_MARINAS MARRIAGE & FAMILY COUNSELORS 769 GC_SOCIALSERVICE MEDICAL & SURGICAL SVC ORGANIZATIONS 133 GC_COMMUNITYCENTER MENTAL HEALTH SERVICES 509 GC_HEALTH MOBILE HOMES-DEALERS 330 GC_MOBILEHOMES MOBILE HOMES-PARK DEVELOPERS 501 GC_MOBILEHOMES MOBILE HOMES-PARKS & COMMUNITIES 1072 GC_MOBILEHOMES MUSEUMS 284 GC_CULTURECENTER NURSES & NURSES' REGISTRIES 348 GC_HEALTH NURSING & CONVALESCENT HOMES 622 GC_HEALTH ORGANIZATIONS 406 GC_COMMUNITYCENTER PARKING AREA/LOTS MAINTENANCE & MARKING 327 HURRICANE DATA PARKING STATIONS & GARAGES 163 HURRICANE DATA PARKS 843 GC_PARKS PHARMACIES 2665 GC_HEALTH PHYSICIANS & SURGEONS 17170 GC_HEALTH POLICE DEPARTMENTS 558 GC_LAWENFORCE POLITICAL ORGANIZATIONS 120 GC_COMMUNITYCENTER POST OFFICES 887 GC_GOVBUILD RACE TRACKS 139 GC_CIVICCENTER RADIO STATIONS & BROADCASTING COMPANIES 513 HURRICANE DATA RANCHES 192 OTHER RECREATION CENTERS 261 GC_PARKS RELIGIOUS ORGANIZATIONS 722 GC_COMMUNITYCENTER RESIDENTIAL CARE HOMES 817 GC_SOCIALSERVICE RETIREMENT COMMUNITIES & HOMES 874 GC_SOCIALSERVICE SAND & GRAVEL (WHOLESALE) 172 HURRICANE DATA SCHOOLS 4864 GC_SCHOOLS SCHOOLS WITH SPECIAL ACADEMIC EDUCATION 133 GC_SCHOOLS SCHOOLS-BUSINESS & VOCATIONAL 188 GC_SCHOOLS SCHOOLS-NURSERY & KINDERGARTEN ACADEMIC 878 GC_SCHOOLS SCHOOLS-UNIVERSITIES & COLLEGES ACADEMIC 504 GC_SCHOOLS SENIOR CITIZENS SERVICE 223 GC_SOCIALSERVICE SERVICE STATIONS-GASOLINE & OIL 3076 GC_PETROLEUM SHERIFF 407 GC_LAWENFORCE SHOPPING CENTERS & MALLS 315 OTHER SOCIAL SERVICE & WELFARE ORGANIZATIONS 1870 GC_SOCIALSERVICE STATE GOVERNMENT-LEGAL COUNSEL 245 GC_GOVBUILD STATE GOVERNMENT-PUBLIC HEALTH PROGRAMS 301 GC_GOVBUILD STATE GOVERNMENT-SOCIAL/HUMAN RESOURCES 443 GC_GOVBUILD STATE GOVERNMENT-TRANSPORTATION PROGRAMS 268 GC_GOVBUILD STATE GOVT-CORRECTIONAL INSTITUTIONS 177 GC_GOVBUILD SWIMMING POOLS-PUBLIC 191 GC_PARKS SYNAGOGUES 301 GC_RELIGION TELECOMMUNICATIONS SERVICES 551 HURRICANE DATA TELEPHONE COMPANIES 374 HURRICANE DATA TELEVISION STATIONS & BROADCASTING CO 223 HURRICANE DATA TELEVISION-CABLE & CATV 249 HURRICANE DATA THEATRES-LIVE 195 GC_CULTURECENTER THEATRES-MOVIE 289 GC_CULTURECENTER TOWING-MARINE 201 HURRICANE DATA TRANSLATORS & INTERPRETERS 272 HURRICANE DATA TRANSPORTATION 321 HURRICANE DATA TRANSPORTATION SERVICES 180 HURRICANE DATA TREE SERVICE 1453 HURRICANE DATA TRUCKING-HEAVY HAULING 298 HURRICANE DATA UTILITY CONTRACTORS 298 HURRICANE DATA VETERANS' & MILITARY ORGANIZATIONS 407 GC_COMMUNITYCENTER VETERINARIANS 1428 GC_SOCIALSERVICE WATER & SEWAGE COMPANIES-UTILITY 185 HURRICANE DATA WATER COMPANIES-BOTTLED, BULK, ETC 188 HURRICANE DATA WATER WELL DRILLING & SERVICE 299 HURRICANE DATA WRECKER SERVICE 1184 HURRICANE DATA YOUTH ORGANIZATIONS & CENTERS 531 GC_COMMUNITYCENTER