Database
7M Restaurants, Nightlife Bars, Pubs, Spas, Urban Life Data: Phone, Address, Lon & Lat
7,250,679 restaurants, nightlife bars, pubs, spas, urban life data: title, phone, star rating, address, lon & lat
Description: This is a fields-rich restaurants, nightlife bars database of 7,250,679 business records and 6,732,104 unique phone numbers in the world, classified by 24 categories (Restaurants, Shopping, Nightlife, Home Services, Automotive, Health & Spas, Health & Medical, Arts & Entertainment, etc.) This businesses database is filled with business location details, such as longitude and latitude, contact information such as phone numbers and detailed street addresses across 67 areas in the world. The whole restaurants, spas database consists of 13 tables.
Data Samples (JSON, CSV, XML, Excel):
http://n3.datasn.io/data/api/v1/n3a2/business_1/main/list/
Database Statistics
- Size: 5.66 GB
- Tables: 12
- Records: 7,250,679
- Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)
Database Categories
Images Statistics
- Images: 0.07T
- Dimensions: 1000 x 1000 on average
- Image formats: JPEG
- Images count: 2122668
- Reference field: image_name_field
Database Structure
| Table | Records | Fields |
|---|---|---|
| category_1 | 24 |
|
| category_2 | 1,382 |
|
| region | 67 |
|
| city | 219 |
|
| business | 7,250,679 |
|
| city_x_category_1 | 4,654 |
|
| city_x_category_1_x_category_2 | 230,318 |
|
| city_x_category_1_x_category_2_x_business | 18,028,910 |
|
| district | 1,852 |
|
| city_x_category_1_x_category_2_x_district | 1,908 |
|
| city_x_category_1_x_category_2_x_district_x_business | 9,338 |
|
| business_image | 2,122,668 |
|
Database Attachments
Images: This database is attached with 2122668 images. See them under the Attachments tab.
Content Scope
Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:
region
- ARGENTINA
- AUSTRALIA
- AUSTRIA
- BELGIUM
- BRAZIL
- CANADA
- CHILE
- CZECH REPUBLIC
- DENMARK
- FINLAND
- FRANCE
- GERMANY
- HONG KONG
- ITALY
- JAPAN
- MALAYSIA
- MEXICO
- NEW ZEALAND
- NORWAY
- PHILIPPINES
- POLAND
- PORTUGAL
- REPUBLIC OF IRELAND
- SINGAPORE
- SPAIN
- SWEDEN
- SWITZERLAND
- TAIWAN
- THE NETHERLANDS
- TURKEY
- UNITED KINGDOM
- AZ
- CA
- CO
- CT
- DC
- FL
- GA
- HI
- IA
- ID
- IL
- IN
- KY
- LA
- MA
- MD
- MI
- MN
- MO
- NC
- NJ
- NM
- NV
- NY
- OH
- OR
- PA
- RI
- SC
- TN
- TX
- UT
- VA
- VT
- WA
- WI
city
- Buenos Aires
- Adelaide
- Brisbane
- Melbourne
- Perth
- Sydney
- Wien
- Antwerpen
- Bruxelles
- Rio de Janeiro
- São Paulo
- Calgary
- Edmonton
- Halifax
- Montréal
- Ottawa
- Toronto
- Vancouver
- Santiago
- Praha
- København
- Helsinki
- Lyon
- Marseille
- Paris
- Berlin
- Frankfurt am Main
- Hamburg
- Köln
- München
- 香港
- Milano
- Roma
- 大阪市
- 東京
- Kuala Lumpur
- México, D.F.
- Auckland
- Oslo
- Manila
- Kraków
- Warszawa
- Lisboa
- Dublin
- Singapore
- Barcelona
- Madrid
- Stockholm
- Zürich
- 台北市
- Amsterdam
- İstanbul
- Belfast
- Brighton
- Bristol
- Cardiff
- Edinburgh
- Glasgow
- Leeds
- Liverpool
- London
- Manchester
- Phoenix
- Scottsdale
- Tempe
- Tucson
- Alameda
- Albany
- Alhambra
- Anaheim
- Belmont
- Berkeley
- Beverly Hills
- Big Sur
- Burbank
- Concord
- Costa Mesa
- Culver City
- Cupertino
- Daly City
- Davis
- Dublin
- Emeryville
- Foster City
- Fremont
- Glendale
- Hayward
- Healdsburg
- Huntington Beach
- Irvine
- La Jolla
- Livermore
- Long Beach
- Los Altos
- Los Angeles
- Los Gatos
- Marina del Rey
- Menlo Park
- Mill Valley
- Millbrae
category_1
- Food
- Nightlife
- Restaurants
- Shopping
- Active Life
- Arts & Entertainment
- Automotive
- Beauty & Spas
- Education
- Event Planning & Services
- Health & Medical
- Home Services
- Local Services
- Financial Services
- Hotels & Travel
- Local Flavor
- Mass Media
- Pets
- Professional Services
- Public Services & Government
- Real Estate
- Religious Organizations
- Bicycles
- Pubs
category_2
- Bagels
- Bakeries
- Beer, Wine & Spirits
- Breweries
- Butcher
- Candy Stores
- Cheese Shops
- Chocolatiers & Shops
- Churros
- Cideries
- Coffee & Tea
- Coffee Roasteries
- Convenience Stores
- Cupcakes
- Custom Cakes
- Delicatessen
- Desserts
- Distilleries
- Do-It-Yourself Food
- Donuts
- Empanadas
- Ethic Grocery
- Farmers Market
- Food Delivery Services
- Food Trucks
- Fruits & Veggies
- Grocery
- Health Markets
- Herbs & Spices
- Ice Cream & Frozen Yogurt
- Imported Food
- International Grocery
- Internet Cafes
- Juice Bars & Smoothies
- Kiosk
- Macarons
- Meat Shops
- Organic Stores
- Pasta Shops
- Patisserie/Cake Shop
- Salumerie
- Seafood Markets
- Shaved Ice
- Specialty Food
- Street Vendors
- Tea Rooms
- Wine Tasting Room
- Wineries
- Adult Entertainment
- Airport Lounges
- Bar Crawl
- Bars
- Beach Bars
- Beer Bar
- Champagne Bars
- Cocktail Bars
- Comedy Clubs
- Dance Clubs
- Dive Bars
- Gay Bars
- Hookah Bars
- Irish Pub
- Jazz & Blues
- Karaoke
- Lounges
- Music Venues
- Piano Bars
- Pool Halls
- Pubs
- Speakeasies
- Sports Bars
- Tiki Bars
- Vermouth Bars
- Whiskey Bars
- Wine Bars
- Afghan
- African
- American (Traditional)
- Arabian
- Argentine
- Armenian
- Asian Fusion
- Australian
- Austrian
- Bangladeshi
- Barbeque
- Basque
- Belgian
- Bistros
- Brazilian
- Breakfast & Brunch
- British
- Buffets
- Bulgarian
- Burgers
- Burmese
- Cafeteria
- Cajun/Creole
- Cambodian
- Cantonese
Lifetime Updates (fees may apply)
This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.
Other Formats upon Request
We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:
- Microsoft SQL Server
- Microsoft SQL Server Compact Edition
- Oracle
- PostgreSQL
- ODBC
- Interbase / Firebird
- WordPress
- Single Table (multiple tables are combined into one)
- Microsoft Word .DOC
Let us know and we'll see what we can do. Additional fees may apply.