Slot Machines in US

Addresses, phone numbers of slot machines across United States

Data Structure

city [8,589]
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%)
slot_machine [38,440]
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 (87.7%)
varchar(255)
+ phone (100%)
varchar(255)
+ fax (5.8%)
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 38,440 slot machines throughout 8,589 cities in 51 states of US. Each slot machine record is comprised of address, zip code, phone number and fax number. In table slot machine, there are 38,341 unique phone numbers.

Data Profile

Size 14.70M
Tables 3
Last Commit 2016-09-07 01:10:39

Updates / Commits

Time Size Tables Columns Rows
2016-09-07 01:10:39 14.70M 3 19 47080

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 8,589 .001 8.589
slot_machine 38,440 .001 38.44
state 51 .001 0.051
Total Credits 47.08 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.