id | Name | Location | Year_of_establishment | Number_of_employees | Average_meal_price |
---|---|---|---|---|---|
1 | Old Steak | New York | 1980 | 30 | 20.0 |
2 | Tenderloin Palace | Los Angeles | 2000 | 50 | 25.0 |
3 | Ribeye Ranch | Chicago | 2010 | 60 | 30.0 |
4 | Filet Mignon Manor | Miami | 1970 | 40 | 22.0 |
5 | Sirloin Shack | Dallas | 1990 | 20 | 15.0 |
id | Name | Location | Year_of_establishment | Number_of_employees | Specialty_dish |
---|---|---|---|---|---|
1 | Ocean Treasures | Boston | 1980 | 40 | Lobster Roll |
2 | Bay View Cafe | San Francisco | 2005 | 50 | Crab Cakes |
3 | Harbor Grill | Atlanta | 1990 | 60 | Shrimp Scampi |
4 | Seaside Shack | Washington DC | 2015 | 30 | Clam Chowder |
5 | Coastal Kitchen | Philadelphia | 1975 | 20 | Salmon |
id | Name | Location | Year_of_establishment | Number_of_rooms | Star_rating |
---|---|---|---|---|---|
1 | Grand Central Hotel | New York | 1980 | 300 | 5 |
2 | Times Square Inn | New York | 2000 | 200 | 3 |
3 | Chicago Hilton | Chicago | 2010 | 400 | 4 |
4 | South Beach Resort | Miami | 1970 | 250 | 4 |
5 | Northstar Lodge | Dallas | 1990 | 150 | 3 |
id | Name | Location | Year_of_establishment | Type_of_bar | Capacity |
---|---|---|---|---|---|
1 | The Roof Garden | New York | 1980 | Roof Bar | 200 |
2 | Speakeasy Spirits | New York | 2005 | Cocktail Bar | 100 |
3 | Windy City Pub | Chicago | 2010 | Irish Pub | 250 |
4 | Beachside Brewery | Miami | 1970 | Brewery | 150 |
5 | Whiskey Way Station | Dallas | 1990 | Whiskey Bar | 100 |
id | Name | Location | Year_of_establishment | Maximum_capacity | Types_of_events |
---|---|---|---|---|---|
1 | Metropolitan Ballroom | New York | 1980 | 500 | Conferences, Weddings, Parties |
2 | Union Hall | New York | 2000 | 300 | Corporate Events, Exhibitions, Concerts |
3 | Lakeview Pavilion | Chicago | 2010 | 600 | Outdoor Weddings, Festivals, Sporting Events |
4 | Palm Beach Convention Center | Miami | 1970 | 800 | Trade Shows, Banquets, Awards Ceremonies |
5 | Texas State Fairgrounds | Dallas | 1990 | 1000 | Agricultural Fairs, Music Festivals, Car Shows |