Supermarkets in US

Addresses, phone numbers and zip codes of supermarkets in United States

Data Structure

city [15,064]
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%)
state [50]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)
supermarket [91,054]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ title (100%)
varchar(150)
+ address (100%)
varchar(30)
+ phone (100%)
varchar(30)
+ zip_code (100%)

Description

You can easily find the addresses, phone numbers and zip codes of 91,054 supermarkets anywhere in the United States of America and the one which is situated near to where you live. All the supermarkets from this database are located in 15,064 cities from 50 states in the USA. In table supermarket, each record consists of its location city, address, phone number and zip code.

Data Profile

Size 36.02M
Tables 3
Last Commit 2016-09-07 01:13:03

Updates / Commits

Time Size Tables Columns Rows
2016-09-07 01:13:03 36.02M 3 18 106168

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 15,064 .001 15.064
state 50 .001 0.05
supermarket 91,054 .001 91.054
Total Credits 106.168 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.