Pizza Shops in US

Phone numbers, addresses, zip codes of US pizza shops

Data Structure

city [9,816]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ state_id (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)
pizza [46,271]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ title (100%)
varchar(255)
+ address (100%)
varchar(255)
+ city_zip_code (100%)
int(11)
+ zip_code (100%)
varchar(255)
+ phone (100%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)

Description

This pizza database contains of 46,271 pizza shops in 9,816 cities across 51 states in the United States. In table pizza, there are address, phone number, city and zip code in each record.

Data Profile

Size 17.34M
Tables 3
Last Commit 2016-09-05 04:40:07

Updates / Commits

Time Size Tables Columns Rows
2016-09-05 04:40:07 17.34M 3 19 56138

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 9,816 .001 9.816
pizza 46,271 .001 46.271
state 51 .001 0.051
Total Credits 56.138 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.