Restaurants (US)

Phone numbers, addresses, cuisines of restaurants in United States

Data Structure

city [29,712]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ state_id (100%)
varchar(100)
+ title (100%)
int(11)
+ count (38.2%)
varchar(10)
+ abbreviation (100%)
varchar(255)
+ slug (100%)
restaurant [196,673]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ title (100%)
varchar(255)
+ cuisine (99.2%)
varchar(255)
+ address (99.9%)
varchar(255)
+ city_state_postcode (100%)
varchar(255)
+ phone (100%)
varchar(255)
+ zip_code (99.9%)
varchar(30)
+ fax (3.3%)
varchar(255)
+ website (10.8%)
varchar(100)
+ index_id (100%)
state [52]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ abbreviation (100%)

Description

The database includes 196,673 restaurants in 29,712 cities from all over the United States. In table restaurant, each record consists of cuisine, address, location city/state/postcode, phone number, zip code, fax number and website URL. The cuisine type contains pizza, American, fast food, hamburgers, sandwiches, salads, seafood, barbecue, southern, Mexican, Italian, Chinese and many other categories.

Data Profile

Size 54.19M
Tables 3
Last Commit 2016-12-07 00:28:57

Updates / Commits

Time Size Tables Columns Rows
2016-12-07 00:28:57 54.19M 3 24 226437
2016-09-07 01:23:04 54.19M 3 24 226437

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 29,712 .001 29.712
restaurant 196,673 .001 196.673
state 52 .001 0.052
Total Credits 226.437 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.