Bakeries in US

Phone numbers, addresses, zip codes of United States bakeries

Data Structure

bakery [17,393]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(30)
+ zip_code (100%)
varchar(50)
+ phone (100%)
varchar(255)
+ address (100%)
text
+ discription (4.4%)
city [29,292]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ state_id (100%)
varchar(255)
+ title (100%)
int(11)
+ count (80.9%)
varchar(255)
+ slug (100%)
city_to_bakery [782,685]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
bigint(20) unsigned
+ bakery_id (100%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
char(4)
+ abbreviation (100%)
varchar(255)
+ slug (100%)

Description

In this database, there are 17,393 bakeries in 29,292 cities across 51 states of United States. In table bakery, there are zip code, phone number, address and description in each record, and 17,380 phone numbers are unique.

Data Profile

Size 93.88M
Tables 4
Last Commit 2016-09-07 01:18:57

Updates / Commits

Time Size Tables Columns Rows
2016-09-07 01:18:57 93.88M 4 23 829421

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
bakery 17,393 .001 17.393
city 29,292 .001 29.292
city_to_bakery 782,685 .001 782.685
state 51 .001 0.051
Total Credits 829.421 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.