License Database Purchase Options
USAGE RIGHTS $35.00 |
PUBLICATION RIGHTS $70.00 |
MASTER RIGHTS $140.00 |
|
Data Tracking Seeds | |||
Data Modification | |||
Importing | |||
Exporting | |||
Merge | |||
Web Usage | |||
Multiple PC's or Websites | |||
Mobile Development | |||
Updates Available | |||
All Data File Formats | |||
Custom File Formats | |||
Distribution | |||
Copyright Endorsement | |||
BUY NOW | BUY NOW | BUY NOW |
This database includes catering facilities, restaurants that provide catering services, Banquet Services, Wedding Receptions & Party centers, Catering Information Services, Wedding Caterers, Catering Equipment & Supplies Retail, and Catering Equipment & Supplies Rental businesses.
Table Schema Database Field Statistics
Field | Records | Percent | Type | Comment |
---|---|---|---|---|
id | 41,784 | 100% | int(11) | Unique Identifier |
biz_name | 41,784 | 100% | varchar(150) | Business Name |
biz_info | 0 | 0% | text | Business Information and Description |
cat_primary | 39,984 | 96% | varchar(75) | Business Primary Category |
cat_sub | 38,928 | 93% | varchar(75) | Business Secondary/Sub Category |
e_address | 40,739 | 97% | varchar(100) | Physical Address |
e_city | 41,782 | 100% | varchar(50) | Physical Address City |
e_state | 41,782 | 100% | varchar(20) | Physical Address State / Province |
e_postal | 41,784 | 100% | varchar(7) | Physical Address Postal Code |
e_zip_full | 0 | 0% | varchar(10) | Zip +4 for US Physical Addresses |
e_country | 41,784 | 100% | varchar(20) | Physical Address Country |
loc_county | 39,967 | 96% | varchar(40) | Physical Address County |
loc_area_code | 39,966 | 96% | varchar(3) | Physical Address Area Code |
loc_FIPS | 39,970 | 96% | varchar(5) | Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html |
loc_MSA | 18,288 | 44% | varchar(5) | Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html |
loc_PMSA | 14,563 | 35% | varchar(5) | Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm |
loc_TZ | 39,970 | 96% | varchar(6) | Location Time Zone |
loc_DST | 41,784 | 100% | enum('Y','N','U') | Daylight Savings Time (Yes, No, Unknown) |
loc_LAT_centroid | 39,967 | 96% | varchar(15) | Latitude (Centroid Based) |
loc_LAT_poly | 41,536 | 99% | varchar(15) | Latitude (Precision Polygon Based) |
loc_LONG_centroid | 39,967 | 96% | varchar(15) | Longitude (Centroid Based) |
loc_LONG_poly | 41,536 | 99% | varchar(15) | Longitude (Precision Polygon Based) |
biz_phone | 41,774 | 100% | varchar(20) | Business Phone Number |
biz_phone_ext | 0 | 0% | varchar(8) | Business Phone Number Extension |
biz_fax | 1,545 | 4% | varchar(20) | Business Fax Number |
biz_email | 677 | 2% | varchar(75) | Business Contact Email Address |
web_url | 22,239 | 53% | varchar(175) | Website URL |
web_meta_title | 697 | 2% | varchar(255) | Website Meta Title |
web_meta_desc | 566 | 1% | varchar(255) | Website Meta Description |
web_meta_keys | 530 | 1% | varchar(255) | Website Meta Keywords |
Catering and Party Services Records Information | |||
---|---|---|---|
USA | Alaska | 130 | Catering and Party Services |
USA | Alabama | 803 | Catering and Party Services |
USA | Arkansas | 535 | Catering and Party Services |
USA | Arizona | 677 | Catering and Party Services |
USA | California | 2,833 | Catering and Party Services |
USA | Colorado | 1,003 | Catering and Party Services |
USA | Connecticut | 966 | Catering and Party Services |
USA | District Of Columbia | 208 | Catering and Party Services |
USA | Delaware | 177 | Catering and Party Services |
USA | Florida | 1,622 | Catering and Party Services |
USA | Georgia | 1,301 | Catering and Party Services |
USA | Hawaii | 284 | Catering and Party Services |
USA | Iowa | 656 | Catering and Party Services |
USA | Idaho | 254 | Catering and Party Services |
USA | Illinois | 1,847 | Catering and Party Services |
USA | Indiana | 971 | Catering and Party Services |
USA | Kansas | 590 | Catering and Party Services |
USA | Kentucky | 534 | Catering and Party Services |
USA | Louisiana | 933 | Catering and Party Services |
USA | Massachusetts | 1,156 | Catering and Party Services |
USA | Maryland | 812 | Catering and Party Services |
USA | Maine | 239 | Catering and Party Services |
USA | Michigan | 1,373 | Catering and Party Services |
USA | Minnesota | 854 | Catering and Party Services |
USA | Missouri | 1,079 | Catering and Party Services |
USA | Mississippi | 445 | Catering and Party Services |
USA | Montana | 225 | Catering and Party Services |
USA | North Carolina | 1,202 | Catering and Party Services |
USA | North Dakota | 160 | Catering and Party Services |
USA | Nebraska | 445 | Catering and Party Services |
USA | New Hampshire | 248 | Catering and Party Services |
USA | New Jersey | 1,643 | Catering and Party Services |
USA | New Mexico | 321 | Catering and Party Services |
USA | Nevada | 378 | Catering and Party Services |
USA | New York | 2,161 | Catering and Party Services |
USA | Ohio | 1,493 | Catering and Party Services |
USA | Oklahoma | 632 | Catering and Party Services |
USA | Oregon | 635 | Catering and Party Services |
USA | Pennsylvania | 1,965 | Catering and Party Services |
USA | Rhode Island | 217 | Catering and Party Services |
USA | South Carolina | 813 | Catering and Party Services |
USA | South Dakota | 156 | Catering and Party Services |
USA | Tennessee | 891 | Catering and Party Services |
USA | Texas | 2,300 | Catering and Party Services |
USA | Utah | 298 | Catering and Party Services |
USA | Virginia | 879 | Catering and Party Services |
USA | Vermont | 152 | Catering and Party Services |
USA | Washington | 1,046 | Catering and Party Services |
USA | Wisconsin | 953 | Catering and Party Services |
USA | West Virginia | 189 | Catering and Party Services |
USA | Wyoming | 98 | Catering and Party Services |