Indoor Advertising Companies of US

Addresses, phone numbers of indoor advertising companies & agencies in US

Data Structure

city [7,091]
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%)
varchar(255)
+ state_slug (100%)
indoor_advertising [44,917]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ title (100%)
varchar(255)
+ address (100%)
varchar(255)
+ zip_code (100%)
varchar(255)
+ phone (100%)
varchar(255)
+ fax (11.3%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)

Description

This database lists 44,917 indoor advertising companies and agencies across 7,091 cities in 51 states of United States. Each indoor advertising record consists of company’s address, phone number, zip code and fax number. In table indoor advertising, there are 44,917 unique phone numbers.

Data Profile

Size 16.72M
Tables 3
Last Commit 2016-09-08 03:46:31

Updates / Commits

Time Size Tables Columns Rows
2016-09-08 03:46:31 16.72M 3 20 52059

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 7,091 .001 7.091
indoor_advertising 44,917 .001 44.917
state 51 .001 0.051
Total Credits 52.059 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.