City Frequencies with Control Points

US scanner frequencies with control points, status, addresses, phone numbers

Data Structure

city [27,688]
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%)
control_point [1,879,729]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ scanner_frequency_id (100%)
varchar(255)
+ point (100%)
varchar(255)
+ address (100%)
varchar(255)
+ transmit_location (83.5%)
scanner_frequency [372,108]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ title (100%)
char(25)
+ status (100%)
varchar(255)
+ address (99.7%)
varchar(255)
+ zip_code (99.7%)
varchar(255)
+ attn (83.9%)
varchar(255)
+ phone (98.8%)
varchar(255)
+ fax (53.3%)
text
+ description (99.6%)
varchar(255)
+ slug (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 database lists 372,108 city frequencies coming with 1,879,729 control points across 27,688 cities in 51 states of US. Each scanner frequency record is comprised of status, address, zip code, attn., phone number, fax number and description. In table of scanner frequency, there are 214,314 unique phone numbers.

Data Profile

Size 748.22M
Tables 4
Last Commit 2016-09-08 03:47:28

Updates / Commits

Time Size Tables Columns Rows
2016-09-08 03:47:28 748.22M 4 29 2279576

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 27,688 .001 27.688
control_point 1,879,729 .001 1879.729
scanner_frequency 372,108 .001 372.108
state 51 .001 0.051
Total Credits 2279.576 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.