Restaurant Details Database v.1.0.10

447,372 Restaurant Profiles

This content database features restaurant listing in the U.S. Additional record fields are available aside from the standard contact information for each restaurant in the database making this download database very attractive. Information such as Hours of Operation, Payment Forms, Parking Flag, Dress Codes, Cuisines, Special Features and Restaurant Atmosphere will allow a great deal of control and search operations over the data in this business database.

License Database Purchase Options

	USAGE RIGHTS $200.00	PUBLICATION RIGHTS $400.00	MASTER RIGHTS $800.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

Table Schema Database Field Statistics

Field	Records	Percent	Type	Comment
id	447,372	100%	int(11)	Unique Identifier
biz_name	447,372	100%	varchar(150)	Business Name
cat_primary	447,372	100%	varchar(75)	Business Primary Category
cat_sub	298,196	67%	varchar(75)	Cuisine 1
cat_sub2	88,377	20%	varchar(75)	Cuisine 2
cat_sub3	29,430	7%	varchar(75)	Cuisine 3
web_url	197,437	44%	varchar(255)	Website URL
e_address	447,372	100%	varchar(100)	Physical Address
e_city	447,372	100%	varchar(50)	Physical Address City
e_state	447,372	100%	varchar(20)	Physical Address State / Province
e_postal	447,370	100%	varchar(11)	Physical Address Postal Code
e_country	447,372	100%	varchar(20)	Physical Address Country
loc_county	282,007	63%	varchar(40)	Physical Address County
loc_area_code	282,007	63%	varchar(3)	Physical Address Area Code
loc_FIPS	282,007	63%	varchar(5)	Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html
loc_MSA	119,048	27%	varchar(5)	Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html
loc_PMSA	131,926	29%	varchar(5)	Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm
loc_TZ	282,000	63%	varchar(6)	Location Time Zone
loc_DST	447,372	100%	enum('Y','N','U')	Daylight Savings Time (Yes, No, Unknown)
loc_LAT_centroid	282,007	63%	varchar(15)	Latitude (Centroid Based)
loc_LAT_poly	231,598	52%	varchar(15)	Latitude (Precision Polygon Based)
loc_LONG_centroid	282,007	63%	varchar(15)	Longitude (Centroid Based)
loc_LONG_poly	231,598	52%	varchar(15)	Longitude (Precision Polygon Based)
biz_popularity	447,372	100%	int(11)	Popularity (1 - 5)
biz_atmosphere	5,648	1%	varchar(255)	General Atmosphere if not covered in categorization
biz_hours	19,604	4%	varchar(255)	Hours of Operation
biz_price	447,372	100%	varchar(10)	Average Price Level
flag_outdoorseating	447,372	100%	enum('Y','N','U')	Outdoor Seating Flag
biz_phone	437,195	98%	varchar(20)	Business Phone Number
biz_info	28,637	6%	varchar(250)	Additional Information

Restaurant Profiles Records Information

United States Restaurant Profiles

239 Alaska Restaurant Profiles
3,068 Alabama Restaurant Profiles
2,002 Arkansas Restaurant Profiles
8,708 Arizona Restaurant Profiles
65,017 California Restaurant Profiles
8,247 Colorado Restaurant Profiles
2,797 Connecticut Restaurant Profiles
2,013 District Of Columbia Restaurant Profiles
1,362 Delaware Restaurant Profiles
31,899 Florida Restaurant Profiles
14,742 Georgia Restaurant Profiles
635 Hawaii Restaurant Profiles
2,177 Iowa Restaurant Profiles
1,092 Idaho Restaurant Profiles
22,446 Illinois Restaurant Profiles
8,865 Indiana Restaurant Profiles
3,459 Kansas Restaurant Profiles
3,828 Kentucky Restaurant Profiles
5,817 Louisiana Restaurant Profiles
12,572 Massachusetts Restaurant Profiles
9,516 Maryland Restaurant Profiles
789 Maine Restaurant Profiles
14,885 Michigan Restaurant Profiles
7,932 Minnesota Restaurant Profiles
10,570 Missouri Restaurant Profiles
1,786 Mississippi Restaurant Profiles
499 Montana Restaurant Profiles
12,238 North Carolina Restaurant Profiles
435 North Dakota Restaurant Profiles
1,478 Nebraska Restaurant Profiles
1,578 New Hampshire Restaurant Profiles
15,649 New Jersey Restaurant Profiles
1,347 New Mexico Restaurant Profiles
4,397 Nevada Restaurant Profiles
34,300 New York Restaurant Profiles
20,980 Ohio Restaurant Profiles
2,760 Oklahoma Restaurant Profiles
6,082 Oregon Restaurant Profiles
21,416 Pennsylvania Restaurant Profiles
4 Puerto Rico Restaurant Profiles
1,945 Rhode Island Restaurant Profiles
3,993 South Carolina Restaurant Profiles
532 South Dakota Restaurant Profiles
6,694 Tennessee Restaurant Profiles
31,120 Texas Restaurant Profiles
4,296 Utah Restaurant Profiles
7,977 Virginia Restaurant Profiles
221 Vermont Restaurant Profiles
11,647 Washington Restaurant Profiles
7,554 Wisconsin Restaurant Profiles
1,376 West Virginia Restaurant Profiles
391 Wyoming Restaurant Profiles