ATM Locations in US

Addresses, phone numbers of ATM locations in United States

Data Structure

atm_location [158,990]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ state_id (100%)
bigint(20) unsigned
+ city_id (100%)
varchar(255)
+ title (100%)
varchar(255)
+ phone (60.2%)
varchar(255)
+ zip_code (100%)
varchar(255)
+ website (32.7%)
varchar(255)
+ street (100%)
varchar(255)
+ address (100%)
varchar(255)
+ latitude (93.4%)
varchar(255)
+ longitude (93.4%)
city [4,380]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ state_id (100%)
varchar(255)
+ title (100%)
int(11)
+ count (97.8%)
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%)

Description

This ATM database contains 158,990 Automated Teller Machine locations across 4,380 cities in 50 states of the United States. Each ATM location record is comprised of title, phone number, zip code, website URL, street, address, latitude and longitude. In the table of ATM_location, there are 17,771 unique phone numbers.

Data Profile

Size 43.25M
Tables 3
Last Commit 2016-09-05 04:30:13

Updates / Commits

Time Size Tables Columns Rows
2016-09-05 04:30:13 43.25M 3 23 163420

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
atm_location 158,990 .001 158.99
city 4,380 .001 4.38
state 50 .001 0.05
Total Credits 163.42 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.