Banks in US

Addresses, phone numbers, website URLs of banks in United States

Data Structure

bank [2,210]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ streetaddress (95.8%)
varchar(255)
+ address (100%)
varchar(255)
+ zip_code (99.3%)
varchar(255)
+ phone (99.8%)
varchar(255)
+ warranty (31.9%)
varchar(255)
+ contact (53%)
text
+ business_description (57%)
varchar(255)
+ senior_discount (26.5%)
text
+ excluded_service (9.3%)
varchar(255)
+ service (100%)
varchar(255)
+ website (73.6%)
varchar(255)
+ service_area (37.7%)
varchar(255)
+ office_hour (65.1%)
varchar(255)
+ licensed (100%)
varchar(255)
+ city_served (84.6%)
city [13,793]
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%)
city_to_bank [124,227]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
bigint(20) unsigned
+ bank_id (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 is a database with 2,210 records of banks located in 13,793 cities over 51 states of the United States. Each bank record consists of address, street address, zip code, phone number, warranty, contact, business description, senior discount, excluded service, service, website URL, service area, office hour, licensed and city served. In table bank, there are 2,128 unique phone numbers.

Data Profile

Size 20.06M
Tables 4
Last Commit 2016-09-08 03:46:20

Updates / Commits

Time Size Tables Columns Rows
2016-09-08 03:46:20 20.06M 4 33 140281

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
bank 2,210 .001 2.21
city 13,793 .001 13.793
city_to_bank 124,227 .001 124.227
state 51 .001 0.051
Total Credits 140.281 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.