| Field | Records | Percent | Type | Comment |
|---|
| id | 30,026 | 100% | int(11) | Unique Identifier |
| biz_name | 30,026 | 100% | varchar(150) | Business Name |
| e_address | 30,026 | 100% | varchar(100) | Physical Address |
| e_city | 30,026 | 100% | varchar(50) | Physical Address City |
| e_state | 30,026 | 100% | varchar(20) | Physical Address State / Province |
| e_postal | 30,026 | 100% | varchar(7) | Physical Address Postal Code |
| e_zip_full | 29,644 | 99% | varchar(10) | Zip +4 for US Physical Addresses |
| e_country | 30,026 | 100% | varchar(20) | Physical Address Country |
| loc_county | 30,018 | 100% | varchar(40) | Physical Address County |
| loc_area_code | 30,018 | 100% | varchar(3) | Physical Address Area Code |
| loc_FIPS | 30,018 | 100% | varchar(5) | Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html |
| loc_MSA | 1,217 | 4% | varchar(5) | Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html |
| loc_PMSA | 28,718 | 96% | varchar(5) | Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm |
| loc_TZ | 30,018 | 100% | varchar(6) | Location Time Zone |
| loc_DST | 30,026 | 100% | enum('Y','N','U') | Daylight Savings Time (Yes, No, Unknown) |
| loc_LAT_centroid | 30,018 | 100% | varchar(15) | Latitude (Centroid Based) |
| loc_LAT_poly | 30,021 | 100% | varchar(15) | Latitude (Precision Polygon Based) |
| loc_LONG_centroid | 30,018 | 100% | varchar(15) | Longitude (Centroid Based) |
| loc_LONG_poly | 30,021 | 100% | varchar(15) | Longitude (Precision Polygon Based) |
| biz_email | 14,289 | 48% | varchar(75) | Business Contact Email Address |
| biz_fax | 28,059 | 93% | varchar(20) | Business Fax Number |
| biz_phone | 30,024 | 100% | varchar(20) | Business Phone Number |
| web_url | 20,704 | 69% | varchar(255) | Website URL |
| web_meta_title | 166 | 1% | varchar(255) | Website Meta Title |
| web_meta_desc | 138 | 0% | varchar(255) | Website Meta Description |
| web_meta_keys | 137 | 0% | varchar(255) | Website Meta Keywords |
| cnt_employees | 30,024 | 100% | int(11) | Employee Count |
| con_president | 15,436 | 51% | varchar(255) | Contact Name - Company President |
| con_vp | 4,836 | 16% | varchar(255) | Contact Name - Vice-President |
| con_gen_mgr | 8,919 | 30% | varchar(255) | Contact Name - General Manager |
| con_ceo | 4,368 | 15% | varchar(255) | Contact Name - Chief Executive Officer |
| con_coo | 1,796 | 6% | varchar(255) | Contact Name - Chief Operating Officer |
| con_cto | 1,411 | 5% | varchar(255) | Contact Name - Chief Technical Officer |
| con_owner | 7,936 | 26% | varchar(255) | Contact Name - Company Owner |
| con_mktg_dir | 3,183 | 11% | varchar(255) | Contact Name - Marketing Director |
| con_mktg_sales | 5,689 | 19% | varchar(255) | Contact Name - Marketing Sales |
| con_sales_mgr | 4,193 | 14% | varchar(255) | Contact Name - Sales Manager |
| con_purch_mgr | 3,686 | 12% | varchar(255) | Contact Name - Purchasing Manager |
| con_eng_vp | 1,246 | 4% | varchar(255) | Contact Name - VP of Engineering |
| con_eng_dir | 783 | 3% | varchar(255) | Contact Name - Engineering Director |
| con_hr_dir | 4,760 | 16% | varchar(255) | Contact Name - Human Resources Director |
| con_fin_vp | 4,369 | 15% | varchar(255) | Contact Name - VP of Finance |
| con_fin_dir | 1,729 | 6% | varchar(255) | Contact Name - Finance Director |
| con_controller | 2,298 | 8% | varchar(255) | Contact Name - Chief Controller |
| con_mfg_vp | 526 | 2% | varchar(255) | Contact Name - VP of Manufacturing |
| con_mfg_dir | 637 | 2% | varchar(255) | Contact Name - Manufacturing Director |
| con_qa_mngr | 484 | 2% | varchar(255) | Contact Name - Quality Assurance Manager |
| con_factory_mngr | 2,884 | 10% | varchar(255) | Contact Name - Factory Manager |
