Usage & Publication License: database price dollar sign359.00

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

database structure screenshot of 7M Restaurants, Nightlife Bars, Pubs, Spas, Urban Life Data: Phone, 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, Excel):
http://n3.datasn.io/data/api/v1/n3a2/business_1/main/list/

Related DBs:

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
  1. id
  2. ts
  3. title
category_2 1,382
  1. id
  2. ts
  3. title
region 67
  1. id
  2. ts
  3. title
city 219
  1. id
  2. ts
  3. title
business 7,250,679
  1. id
  2. ts
  3. title
  4. neighborhood
  5. address
  6. phone
  7. star_rating
  8. latitude
  9. longitude
city_x_category_1 4,654
  1. id
  2. ts
city_x_category_1_x_category_2 230,318
  1. id
  2. ts
city_x_category_1_x_category_2_x_business 18,028,910
  1. id
  2. ts
district 1,852
  1. id
  2. ts
  3. title
city_x_category_1_x_category_2_x_district 1,908
  1. id
  2. ts
city_x_category_1_x_category_2_x_district_x_business 9,338
  1. id
  2. ts
business_image 2,122,668
  1. id
  2. ts
  3. source_content_type
  4. hash_file_content
  5. size
  6. path
  7. title
  8. access

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
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.


Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries. Email: [email protected]UsableDatabases.com

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. Which cannot float on water, boat or stone?

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!


Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.