Flower Shops in US

Phone numbers, addresses and zip codes of florist shops in United States

Data Structure

city [27,185]
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%)
city_to_flower [2,421,736]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
bigint(20) unsigned
+ flower_id (100%)
flower [69,240]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ title (100%)
varchar(30)
+ zip_code (100%)
varchar(50)
+ phone (100%)
varchar(255)
+ address (100%)
text
+ description (0.4%)
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 flower shop database, there are 69,240 florist shops in 27,185 cities over 51 states of the United States. Each record consists of city, phone number, address, zip code and description. What's more, there are 69,208 unique phone numbers in table flower.

Data Profile

Size 272.62M
Tables 4
Last Commit 2016-09-07 01:19:48

Updates / Commits

Time Size Tables Columns Rows
2016-09-07 01:19:48 272.62M 4 24 2518212

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 27,185 .001 27.185
city_to_flower 2,421,736 .001 2421.736
flower 69,240 .001 69.24
state 51 .001 0.051
Total Credits 2518.212 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.