You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
{ "sample": { "is_sample": "TRUE", "limit_total": 400 }, "api": { "title": "Bank of America Locations", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/bank_of_america_locations/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/bank_of_america_locations/main/list/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/bank_of_america_locations/main/list/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 20, "limit_total": 400, "time": 0.006329999999999999689415108861112457816489040851593017578125 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 7033, "pages_total": 352 }, "struct": { "stem": { "0": "bank" }, "leaf": "bank.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "bank.id": 1, "bank.ts": "2017-08-19 21:09:54", "bank.title": "Apache Trail & Idaho Road", "bank.street_address": "185 W Apache Tr", "bank.locality": "Apache Junction", "bank.region": "AZ", "bank.postal_code": 85120, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "", "bank.city_x_bank_id": { "1": { "city_x_bank.id": 1, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "294": { "city_x_bank.id": 294, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "558": { "city_x_bank.id": 558, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1053": { "city_x_bank.id": 1053, "city.id": 23, "city.ts": "2017-08-18 04:45:55", "city.title": "Oro Valley", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1284": { "city_x_bank.id": 1284, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1760": { "city_x_bank.id": 1760, "city.id": 39, "city.ts": "2017-08-18 04:45:55", "city.title": "Tucson", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": {}, "bank.bank_x_financial_center_service_id": {} }, "2": { "bank.id": 2, "bank.ts": "2017-08-19 21:10:00", "bank.title": "Apache Junction", "bank.street_address": "3160 W Apache Trl", "bank.locality": "Apache Junction", "bank.region": "AZ", "bank.postal_code": 85120, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 827-6761", "bank.city_x_bank_id": { "2": { "city_x_bank.id": 2, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "292": { "city_x_bank.id": 292, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "552": { "city_x_bank.id": 552, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "615": { "city_x_bank.id": 615, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1002": { "city_x_bank.id": 1002, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1056": { "city_x_bank.id": 1056, "city.id": 23, "city.ts": "2017-08-18 04:45:55", "city.title": "Oro Valley", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1282": { "city_x_bank.id": 1282, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "1": { "bank_x_featured_product.id": 1, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "2": { "bank_x_featured_product.id": 2, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "3": { "bank_x_featured_product.id": 3, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "4": { "bank_x_featured_product.id": 4, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "5": { "bank_x_featured_product.id": 5, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "6": { "bank_x_featured_product.id": 6, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "7": { "bank_x_featured_product.id": 7, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "8": { "bank_x_featured_product.id": 8, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "9": { "bank_x_featured_product.id": 9, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "10": { "bank_x_featured_product.id": 10, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "1": { "bank_x_financial_center_service.id": 1, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "2": { "bank_x_financial_center_service.id": 2, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "3": { "bank_x_financial_center_service.id": 3, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "4": { "bank_x_financial_center_service.id": 4, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "5": { "bank_x_financial_center_service.id": 5, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "6": { "bank_x_financial_center_service.id": 6, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" } } }, "3": { "bank.id": 3, "bank.ts": "2017-08-19 21:10:06", "bank.title": "Mountain Vista Medical Cntr - Emrgncy Rm", "bank.street_address": "1301 S Crismon Rd", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85209, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "", "bank.city_x_bank_id": { "3": { "city_x_bank.id": 3, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "281": { "city_x_bank.id": 281, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "396": { "city_x_bank.id": 396, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "553": { "city_x_bank.id": 553, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "605": { "city_x_bank.id": 605, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "993": { "city_x_bank.id": 993, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1055": { "city_x_bank.id": 1055, "city.id": 23, "city.ts": "2017-08-18 04:45:55", "city.title": "Oro Valley", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1278": { "city_x_bank.id": 1278, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1761": { "city_x_bank.id": 1761, "city.id": 39, "city.ts": "2017-08-18 04:45:55", "city.title": "Tucson", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": {}, "bank.bank_x_financial_center_service_id": {} }, "4": { "bank.id": 4, "bank.ts": "2017-08-19 21:10:13", "bank.title": "Broadway Ellsworth", "bank.street_address": "435 S Ellsworth Rd", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85208, "bank.country": "US", "bank.atm": "Hours vary at this location", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 357-3021", "bank.city_x_bank_id": { "4": { "city_x_bank.id": 4, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "286": { "city_x_bank.id": 286, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "394": { "city_x_bank.id": 394, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "548": { "city_x_bank.id": 548, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "600": { "city_x_bank.id": 600, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "987": { "city_x_bank.id": 987, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1281": { "city_x_bank.id": 1281, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "11": { "bank_x_featured_product.id": 11, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "12": { "bank_x_featured_product.id": 12, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "13": { "bank_x_featured_product.id": 13, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "14": { "bank_x_featured_product.id": 14, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "15": { "bank_x_featured_product.id": 15, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "16": { "bank_x_featured_product.id": 16, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "17": { "bank_x_featured_product.id": 17, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "18": { "bank_x_featured_product.id": 18, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "19": { "bank_x_featured_product.id": 19, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "20": { "bank_x_featured_product.id": 20, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "7": { "bank_x_financial_center_service.id": 7, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "8": { "bank_x_financial_center_service.id": 8, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "9": { "bank_x_financial_center_service.id": 9, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "10": { "bank_x_financial_center_service.id": 10, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "11": { "bank_x_financial_center_service.id": 11, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" } } }, "5": { "bank.id": 5, "bank.ts": "2017-08-19 21:10:25", "bank.title": "Superstition Springs", "bank.street_address": "1210 S Power Rd", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85206, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 218-5148", "bank.city_x_bank_id": { "5": { "city_x_bank.id": 5, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "280": { "city_x_bank.id": 280, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "384": { "city_x_bank.id": 384, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "547": { "city_x_bank.id": 547, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "586": { "city_x_bank.id": 586, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "972": { "city_x_bank.id": 972, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1279": { "city_x_bank.id": 1279, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1595": { "city_x_bank.id": 1595, "city.id": 35, "city.ts": "2017-08-18 04:45:55", "city.title": "Sun Lakes", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "21": { "bank_x_featured_product.id": 21, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "22": { "bank_x_featured_product.id": 22, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "23": { "bank_x_featured_product.id": 23, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "24": { "bank_x_featured_product.id": 24, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "25": { "bank_x_featured_product.id": 25, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "26": { "bank_x_featured_product.id": 26, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "27": { "bank_x_featured_product.id": 27, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "28": { "bank_x_featured_product.id": 28, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "29": { "bank_x_featured_product.id": 29, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "30": { "bank_x_featured_product.id": 30, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "12": { "bank_x_financial_center_service.id": 12, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "15": { "bank_x_financial_center_service.id": 15, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "16": { "bank_x_financial_center_service.id": 16, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "18": { "bank_x_financial_center_service.id": 18, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "19": { "bank_x_financial_center_service.id": 19, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "20": { "bank_x_financial_center_service.id": 20, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "13": { "bank_x_financial_center_service.id": 13, "financial_center_service.id": 13, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Financial Solutions Advisor" }, "14": { "bank_x_financial_center_service.id": 14, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" }, "17": { "bank_x_financial_center_service.id": 17, "financial_center_service.id": 17, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Drive Up Teller Services" } } }, "6": { "bank.id": 6, "bank.ts": "2017-08-19 21:10:35", "bank.title": "Ridgeview Plaza", "bank.street_address": "2846 N Power Rd", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85215, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "", "bank.city_x_bank_id": { "6": { "city_x_bank.id": 6, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "395": { "city_x_bank.id": 395, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "524": { "city_x_bank.id": 524, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "601": { "city_x_bank.id": 601, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "977": { "city_x_bank.id": 977, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1293": { "city_x_bank.id": 1293, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": {}, "bank.bank_x_financial_center_service_id": {} }, "7": { "bank.id": 7, "bank.ts": "2017-08-19 21:10:47", "bank.title": "Recker/McKellips", "bank.street_address": "5807 E McKellips Rd", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85215, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 827-6816", "bank.city_x_bank_id": { "7": { "city_x_bank.id": 7, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "388": { "city_x_bank.id": 388, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "526": { "city_x_bank.id": 526, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "597": { "city_x_bank.id": 597, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "973": { "city_x_bank.id": 973, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1290": { "city_x_bank.id": 1290, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "31": { "bank_x_featured_product.id": 31, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "32": { "bank_x_featured_product.id": 32, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "33": { "bank_x_featured_product.id": 33, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "34": { "bank_x_featured_product.id": 34, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "35": { "bank_x_featured_product.id": 35, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "36": { "bank_x_featured_product.id": 36, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "37": { "bank_x_featured_product.id": 37, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "38": { "bank_x_featured_product.id": 38, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "39": { "bank_x_featured_product.id": 39, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "40": { "bank_x_featured_product.id": 40, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "21": { "bank_x_financial_center_service.id": 21, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "25": { "bank_x_financial_center_service.id": 25, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "26": { "bank_x_financial_center_service.id": 26, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "27": { "bank_x_financial_center_service.id": 27, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "28": { "bank_x_financial_center_service.id": 28, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "29": { "bank_x_financial_center_service.id": 29, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "22": { "bank_x_financial_center_service.id": 22, "financial_center_service.id": 13, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Financial Solutions Advisor" }, "23": { "bank_x_financial_center_service.id": 23, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" }, "24": { "bank_x_financial_center_service.id": 24, "financial_center_service.id": 24, "financial_center_service.ts": "2017-08-19 21:10:47", "financial_center_service.title": "Centralized Small Business Banker" } } }, "8": { "bank.id": 8, "bank.ts": "2017-08-19 21:10:53", "bank.title": "Power & Ray", "bank.street_address": "5114 S Power Rd", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85212, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 279-0628", "bank.city_x_bank_id": { "8": { "city_x_bank.id": 8, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "263": { "city_x_bank.id": 263, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "378": { "city_x_bank.id": 378, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "585": { "city_x_bank.id": 585, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "955": { "city_x_bank.id": 955, "city.id": 21, "city.ts": "2017-08-18 04:45:55", "city.title": "Maricopa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "979": { "city_x_bank.id": 979, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1048": { "city_x_bank.id": 1048, "city.id": 23, "city.ts": "2017-08-18 04:45:55", "city.title": "Oro Valley", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1271": { "city_x_bank.id": 1271, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1581": { "city_x_bank.id": 1581, "city.id": 35, "city.ts": "2017-08-18 04:45:55", "city.title": "Sun Lakes", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1754": { "city_x_bank.id": 1754, "city.id": 39, "city.ts": "2017-08-18 04:45:55", "city.title": "Tucson", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "41": { "bank_x_featured_product.id": 41, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "42": { "bank_x_featured_product.id": 42, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "43": { "bank_x_featured_product.id": 43, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "44": { "bank_x_featured_product.id": 44, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "45": { "bank_x_featured_product.id": 45, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "46": { "bank_x_featured_product.id": 46, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "47": { "bank_x_featured_product.id": 47, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "48": { "bank_x_featured_product.id": 48, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "49": { "bank_x_featured_product.id": 49, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "50": { "bank_x_featured_product.id": 50, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "30": { "bank_x_financial_center_service.id": 30, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "32": { "bank_x_financial_center_service.id": 32, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "33": { "bank_x_financial_center_service.id": 33, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "35": { "bank_x_financial_center_service.id": 35, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "36": { "bank_x_financial_center_service.id": 36, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "37": { "bank_x_financial_center_service.id": 37, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "31": { "bank_x_financial_center_service.id": 31, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" }, "34": { "bank_x_financial_center_service.id": 34, "financial_center_service.id": 34, "financial_center_service.ts": "2017-08-19 21:10:53", "financial_center_service.title": "Change Orders" } } }, "9": { "bank.id": 9, "bank.ts": "2017-08-19 21:10:56", "bank.title": "Broadway/Greenfield", "bank.street_address": "4343 E Broadway Rd", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85206, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 218-5162", "bank.city_x_bank_id": { "9": { "city_x_bank.id": 9, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "284": { "city_x_bank.id": 284, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "376": { "city_x_bank.id": 376, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "536": { "city_x_bank.id": 536, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "577": { "city_x_bank.id": 577, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "961": { "city_x_bank.id": 961, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1285": { "city_x_bank.id": 1285, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1593": { "city_x_bank.id": 1593, "city.id": 35, "city.ts": "2017-08-18 04:45:55", "city.title": "Sun Lakes", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "51": { "bank_x_featured_product.id": 51, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "52": { "bank_x_featured_product.id": 52, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "53": { "bank_x_featured_product.id": 53, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "54": { "bank_x_featured_product.id": 54, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "55": { "bank_x_featured_product.id": 55, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "56": { "bank_x_featured_product.id": 56, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "57": { "bank_x_featured_product.id": 57, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "58": { "bank_x_featured_product.id": 58, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "59": { "bank_x_featured_product.id": 59, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "60": { "bank_x_featured_product.id": 60, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "38": { "bank_x_financial_center_service.id": 38, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "41": { "bank_x_financial_center_service.id": 41, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "42": { "bank_x_financial_center_service.id": 42, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "43": { "bank_x_financial_center_service.id": 43, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "44": { "bank_x_financial_center_service.id": 44, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "45": { "bank_x_financial_center_service.id": 45, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "39": { "bank_x_financial_center_service.id": 39, "financial_center_service.id": 13, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Financial Solutions Advisor" }, "40": { "bank_x_financial_center_service.id": 40, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" } } }, "10": { "bank.id": 10, "bank.ts": "2017-08-19 21:11:06", "bank.title": "Higley & Elliot", "bank.street_address": "49 S Higley Rd", "bank.locality": "Gilbert", "bank.region": "AZ", "bank.postal_code": 85296, "bank.country": "US", "bank.atm": "Hours vary at this location", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 539-2951", "bank.city_x_bank_id": { "10": { "city_x_bank.id": 10, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "268": { "city_x_bank.id": 268, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "368": { "city_x_bank.id": 368, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "564": { "city_x_bank.id": 564, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "572": { "city_x_bank.id": 572, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "954": { "city_x_bank.id": 954, "city.id": 21, "city.ts": "2017-08-18 04:45:55", "city.title": "Maricopa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "969": { "city_x_bank.id": 969, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1274": { "city_x_bank.id": 1274, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1580": { "city_x_bank.id": 1580, "city.id": 35, "city.ts": "2017-08-18 04:45:55", "city.title": "Sun Lakes", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1762": { "city_x_bank.id": 1762, "city.id": 39, "city.ts": "2017-08-18 04:45:55", "city.title": "Tucson", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "61": { "bank_x_featured_product.id": 61, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "62": { "bank_x_featured_product.id": 62, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "63": { "bank_x_featured_product.id": 63, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "64": { "bank_x_featured_product.id": 64, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "65": { "bank_x_featured_product.id": 65, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "66": { "bank_x_featured_product.id": 66, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "67": { "bank_x_featured_product.id": 67, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "68": { "bank_x_featured_product.id": 68, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "69": { "bank_x_featured_product.id": 69, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "70": { "bank_x_featured_product.id": 70, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "46": { "bank_x_financial_center_service.id": 46, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "48": { "bank_x_financial_center_service.id": 48, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "49": { "bank_x_financial_center_service.id": 49, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "51": { "bank_x_financial_center_service.id": 51, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "52": { "bank_x_financial_center_service.id": 52, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "53": { "bank_x_financial_center_service.id": 53, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "47": { "bank_x_financial_center_service.id": 47, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" }, "50": { "bank_x_financial_center_service.id": 50, "financial_center_service.id": 34, "financial_center_service.ts": "2017-08-19 21:10:53", "financial_center_service.title": "Change Orders" } } }, "11": { "bank.id": 11, "bank.ts": "2017-08-19 21:11:12", "bank.title": "Rittenhouse and Ocotillo", "bank.street_address": "21004 E Ocotillo Rd", "bank.locality": "Queen Creek", "bank.region": "AZ", "bank.postal_code": 85142, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 987-2355", "bank.city_x_bank_id": { "11": { "city_x_bank.id": 11, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "256": { "city_x_bank.id": 256, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "391": { "city_x_bank.id": 391, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "609": { "city_x_bank.id": 609, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "951": { "city_x_bank.id": 951, "city.id": 21, "city.ts": "2017-08-18 04:45:55", "city.title": "Maricopa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1045": { "city_x_bank.id": 1045, "city.id": 23, "city.ts": "2017-08-18 04:45:55", "city.title": "Oro Valley", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1269": { "city_x_bank.id": 1269, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1588": { "city_x_bank.id": 1588, "city.id": 35, "city.ts": "2017-08-18 04:45:55", "city.title": "Sun Lakes", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1751": { "city_x_bank.id": 1751, "city.id": 39, "city.ts": "2017-08-18 04:45:55", "city.title": "Tucson", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "71": { "bank_x_featured_product.id": 71, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "72": { "bank_x_featured_product.id": 72, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "73": { "bank_x_featured_product.id": 73, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "74": { "bank_x_featured_product.id": 74, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "75": { "bank_x_featured_product.id": 75, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "76": { "bank_x_featured_product.id": 76, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "77": { "bank_x_featured_product.id": 77, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "78": { "bank_x_featured_product.id": 78, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "79": { "bank_x_featured_product.id": 79, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "80": { "bank_x_featured_product.id": 80, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "54": { "bank_x_financial_center_service.id": 54, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "55": { "bank_x_financial_center_service.id": 55, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "56": { "bank_x_financial_center_service.id": 56, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "58": { "bank_x_financial_center_service.id": 58, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "59": { "bank_x_financial_center_service.id": 59, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "60": { "bank_x_financial_center_service.id": 60, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "57": { "bank_x_financial_center_service.id": 57, "financial_center_service.id": 34, "financial_center_service.ts": "2017-08-19 21:10:53", "financial_center_service.title": "Change Orders" } } }, "12": { "bank.id": 12, "bank.ts": "2017-08-19 21:11:23", "bank.title": "Val Vista & Elliot", "bank.street_address": "1571 E Elliot Rd", "bank.locality": "Gilbert", "bank.region": "AZ", "bank.postal_code": 85234, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 539-5016", "bank.city_x_bank_id": { "12": { "city_x_bank.id": 12, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "269": { "city_x_bank.id": 269, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "358": { "city_x_bank.id": 358, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "567": { "city_x_bank.id": 567, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "570": { "city_x_bank.id": 570, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "946": { "city_x_bank.id": 946, "city.id": 21, "city.ts": "2017-08-18 04:45:55", "city.title": "Maricopa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "964": { "city_x_bank.id": 964, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1277": { "city_x_bank.id": 1277, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1572": { "city_x_bank.id": 1572, "city.id": 35, "city.ts": "2017-08-18 04:45:55", "city.title": "Sun Lakes", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "81": { "bank_x_featured_product.id": 81, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "82": { "bank_x_featured_product.id": 82, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "83": { "bank_x_featured_product.id": 83, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "84": { "bank_x_featured_product.id": 84, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "85": { "bank_x_featured_product.id": 85, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "86": { "bank_x_featured_product.id": 86, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "87": { "bank_x_featured_product.id": 87, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "88": { "bank_x_featured_product.id": 88, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "89": { "bank_x_featured_product.id": 89, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "90": { "bank_x_featured_product.id": 90, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "61": { "bank_x_financial_center_service.id": 61, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "64": { "bank_x_financial_center_service.id": 64, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "65": { "bank_x_financial_center_service.id": 65, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "66": { "bank_x_financial_center_service.id": 66, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "67": { "bank_x_financial_center_service.id": 67, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "68": { "bank_x_financial_center_service.id": 68, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "62": { "bank_x_financial_center_service.id": 62, "financial_center_service.id": 13, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Financial Solutions Advisor" }, "63": { "bank_x_financial_center_service.id": 63, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" } } }, "13": { "bank.id": 13, "bank.ts": "2017-08-19 21:11:31", "bank.title": "Power & Queen Creek", "bank.street_address": "8463 S Power Rd", "bank.locality": "Queen Creek", "bank.region": "AZ", "bank.postal_code": 85142, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 988-6900", "bank.city_x_bank_id": { "13": { "city_x_bank.id": 13, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "257": { "city_x_bank.id": 257, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "381": { "city_x_bank.id": 381, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "598": { "city_x_bank.id": 598, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "938": { "city_x_bank.id": 938, "city.id": 21, "city.ts": "2017-08-18 04:45:55", "city.title": "Maricopa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "998": { "city_x_bank.id": 998, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1047": { "city_x_bank.id": 1047, "city.id": 23, "city.ts": "2017-08-18 04:45:55", "city.title": "Oro Valley", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1270": { "city_x_bank.id": 1270, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1573": { "city_x_bank.id": 1573, "city.id": 35, "city.ts": "2017-08-18 04:45:55", "city.title": "Sun Lakes", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1752": { "city_x_bank.id": 1752, "city.id": 39, "city.ts": "2017-08-18 04:45:55", "city.title": "Tucson", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "91": { "bank_x_featured_product.id": 91, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "92": { "bank_x_featured_product.id": 92, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "93": { "bank_x_featured_product.id": 93, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "94": { "bank_x_featured_product.id": 94, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "95": { "bank_x_featured_product.id": 95, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "96": { "bank_x_featured_product.id": 96, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "97": { "bank_x_featured_product.id": 97, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "98": { "bank_x_featured_product.id": 98, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "99": { "bank_x_featured_product.id": 99, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "100": { "bank_x_featured_product.id": 100, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "69": { "bank_x_financial_center_service.id": 69, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "72": { "bank_x_financial_center_service.id": 72, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "73": { "bank_x_financial_center_service.id": 73, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "75": { "bank_x_financial_center_service.id": 75, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "76": { "bank_x_financial_center_service.id": 76, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "77": { "bank_x_financial_center_service.id": 77, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "70": { "bank_x_financial_center_service.id": 70, "financial_center_service.id": 13, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Financial Solutions Advisor" }, "71": { "bank_x_financial_center_service.id": 71, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" }, "74": { "bank_x_financial_center_service.id": 74, "financial_center_service.id": 34, "financial_center_service.ts": "2017-08-19 21:10:53", "financial_center_service.title": "Change Orders" } } }, "14": { "bank.id": 14, "bank.ts": "2017-08-19 21:11:41", "bank.title": "Lindsay/McKellips", "bank.street_address": "1904 N Lindsay Rd", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85213, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 733-4387", "bank.city_x_bank_id": { "14": { "city_x_bank.id": 14, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "300": { "city_x_bank.id": 300, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "383": { "city_x_bank.id": 383, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "527": { "city_x_bank.id": 527, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "587": { "city_x_bank.id": 587, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "965": { "city_x_bank.id": 965, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1296": { "city_x_bank.id": 1296, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1364": { "city_x_bank.id": 1364, "city.id": 30, "city.ts": "2017-08-18 04:45:55", "city.title": "Scottsdale", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1597": { "city_x_bank.id": 1597, "city.id": 35, "city.ts": "2017-08-18 04:45:55", "city.title": "Sun Lakes", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1700": { "city_x_bank.id": 1700, "city.id": 37, "city.ts": "2017-08-18 04:45:55", "city.title": "Tempe", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "101": { "bank_x_featured_product.id": 101, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "102": { "bank_x_featured_product.id": 102, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "103": { "bank_x_featured_product.id": 103, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "104": { "bank_x_featured_product.id": 104, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "105": { "bank_x_featured_product.id": 105, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "106": { "bank_x_featured_product.id": 106, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "107": { "bank_x_featured_product.id": 107, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "108": { "bank_x_featured_product.id": 108, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "109": { "bank_x_featured_product.id": 109, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "110": { "bank_x_featured_product.id": 110, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "78": { "bank_x_financial_center_service.id": 78, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "81": { "bank_x_financial_center_service.id": 81, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "82": { "bank_x_financial_center_service.id": 82, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "84": { "bank_x_financial_center_service.id": 84, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "85": { "bank_x_financial_center_service.id": 85, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "86": { "bank_x_financial_center_service.id": 86, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "79": { "bank_x_financial_center_service.id": 79, "financial_center_service.id": 13, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Financial Solutions Advisor" }, "80": { "bank_x_financial_center_service.id": 80, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" }, "83": { "bank_x_financial_center_service.id": 83, "financial_center_service.id": 34, "financial_center_service.ts": "2017-08-19 21:10:53", "financial_center_service.title": "Change Orders" } } }, "15": { "bank.id": 15, "bank.ts": "2017-08-19 21:11:53", "bank.title": "Santan Village", "bank.street_address": "2189 E Williams Field Rd", "bank.locality": "Gilbert", "bank.region": "AZ", "bank.postal_code": 85295, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 899-9161", "bank.city_x_bank_id": { "15": { "city_x_bank.id": 15, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "261": { "city_x_bank.id": 261, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "363": { "city_x_bank.id": 363, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "574": { "city_x_bank.id": 574, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "937": { "city_x_bank.id": 937, "city.id": 21, "city.ts": "2017-08-18 04:45:55", "city.title": "Maricopa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "974": { "city_x_bank.id": 974, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1049": { "city_x_bank.id": 1049, "city.id": 23, "city.ts": "2017-08-18 04:45:55", "city.title": "Oro Valley", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1273": { "city_x_bank.id": 1273, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1567": { "city_x_bank.id": 1567, "city.id": 35, "city.ts": "2017-08-18 04:45:55", "city.title": "Sun Lakes", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1757": { "city_x_bank.id": 1757, "city.id": 39, "city.ts": "2017-08-18 04:45:55", "city.title": "Tucson", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "111": { "bank_x_featured_product.id": 111, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "112": { "bank_x_featured_product.id": 112, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "113": { "bank_x_featured_product.id": 113, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "114": { "bank_x_featured_product.id": 114, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "115": { "bank_x_featured_product.id": 115, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "116": { "bank_x_featured_product.id": 116, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "117": { "bank_x_featured_product.id": 117, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "118": { "bank_x_featured_product.id": 118, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "119": { "bank_x_featured_product.id": 119, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "120": { "bank_x_featured_product.id": 120, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "87": { "bank_x_financial_center_service.id": 87, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "90": { "bank_x_financial_center_service.id": 90, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "91": { "bank_x_financial_center_service.id": 91, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "93": { "bank_x_financial_center_service.id": 93, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "94": { "bank_x_financial_center_service.id": 94, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "95": { "bank_x_financial_center_service.id": 95, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "88": { "bank_x_financial_center_service.id": 88, "financial_center_service.id": 13, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Financial Solutions Advisor" }, "89": { "bank_x_financial_center_service.id": 89, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" }, "92": { "bank_x_financial_center_service.id": 92, "financial_center_service.id": 34, "financial_center_service.ts": "2017-08-19 21:10:53", "financial_center_service.title": "Change Orders" } } }, "16": { "bank.id": 16, "bank.ts": "2017-08-19 21:11:55", "bank.title": "Gilbert & Guadalupe", "bank.street_address": "15 E Guadalupe Rd", "bank.locality": "Gilbert", "bank.region": "AZ", "bank.postal_code": 85234, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 539-5004", "bank.city_x_bank_id": { "16": { "city_x_bank.id": 16, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "274": { "city_x_bank.id": 274, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "355": { "city_x_bank.id": 355, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "559": { "city_x_bank.id": 559, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "568": { "city_x_bank.id": 568, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "942": { "city_x_bank.id": 942, "city.id": 21, "city.ts": "2017-08-18 04:45:55", "city.title": "Maricopa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "960": { "city_x_bank.id": 960, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1283": { "city_x_bank.id": 1283, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1571": { "city_x_bank.id": 1571, "city.id": 35, "city.ts": "2017-08-18 04:45:55", "city.title": "Sun Lakes", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1691": { "city_x_bank.id": 1691, "city.id": 37, "city.ts": "2017-08-18 04:45:55", "city.title": "Tempe", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "121": { "bank_x_featured_product.id": 121, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "122": { "bank_x_featured_product.id": 122, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "123": { "bank_x_featured_product.id": 123, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "124": { "bank_x_featured_product.id": 124, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "125": { "bank_x_featured_product.id": 125, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "126": { "bank_x_featured_product.id": 126, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "127": { "bank_x_featured_product.id": 127, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "128": { "bank_x_featured_product.id": 128, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "129": { "bank_x_featured_product.id": 129, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "130": { "bank_x_featured_product.id": 130, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "96": { "bank_x_financial_center_service.id": 96, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "98": { "bank_x_financial_center_service.id": 98, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "99": { "bank_x_financial_center_service.id": 99, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "100": { "bank_x_financial_center_service.id": 100, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "101": { "bank_x_financial_center_service.id": 101, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "102": { "bank_x_financial_center_service.id": 102, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "97": { "bank_x_financial_center_service.id": 97, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" } } }, "17": { "bank.id": 17, "bank.ts": "2017-08-19 21:12:03", "bank.title": "Fountain Hills", "bank.street_address": "16925 E Shea Blvd", "bank.locality": "Fountain Hills", "bank.region": "AZ", "bank.postal_code": 85268, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 827-6710", "bank.city_x_bank_id": { "17": { "city_x_bank.id": 17, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "234": { "city_x_bank.id": 234, "city.id": 5, "city.ts": "2017-08-18 04:45:55", "city.title": "Carefree", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "343": { "city_x_bank.id": 343, "city.id": 7, "city.ts": "2017-08-18 04:45:55", "city.title": "Cave Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "519": { "city_x_bank.id": 519, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1315": { "city_x_bank.id": 1315, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1410": { "city_x_bank.id": 1410, "city.id": 31, "city.ts": "2017-08-18 04:45:55", "city.title": "Sedona", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "131": { "bank_x_featured_product.id": 131, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "132": { "bank_x_featured_product.id": 132, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "133": { "bank_x_featured_product.id": 133, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "134": { "bank_x_featured_product.id": 134, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "135": { "bank_x_featured_product.id": 135, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "136": { "bank_x_featured_product.id": 136, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "137": { "bank_x_featured_product.id": 137, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "138": { "bank_x_featured_product.id": 138, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "139": { "bank_x_featured_product.id": 139, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "140": { "bank_x_featured_product.id": 140, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "103": { "bank_x_financial_center_service.id": 103, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "106": { "bank_x_financial_center_service.id": 106, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "107": { "bank_x_financial_center_service.id": 107, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "108": { "bank_x_financial_center_service.id": 108, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "109": { "bank_x_financial_center_service.id": 109, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "110": { "bank_x_financial_center_service.id": 110, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "104": { "bank_x_financial_center_service.id": 104, "financial_center_service.id": 13, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Financial Solutions Advisor" }, "105": { "bank_x_financial_center_service.id": 105, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" } } }, "18": { "bank.id": 18, "bank.ts": "2017-08-19 21:12:07", "bank.title": "Stapley Main", "bank.street_address": "1158 E Main St", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85203, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 827-6812", "bank.city_x_bank_id": { "18": { "city_x_bank.id": 18, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "287": { "city_x_bank.id": 287, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "370": { "city_x_bank.id": 370, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "539": { "city_x_bank.id": 539, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "575": { "city_x_bank.id": 575, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "957": { "city_x_bank.id": 957, "city.id": 21, "city.ts": "2017-08-18 04:45:55", "city.title": "Maricopa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "958": { "city_x_bank.id": 958, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1292": { "city_x_bank.id": 1292, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1357": { "city_x_bank.id": 1357, "city.id": 30, "city.ts": "2017-08-18 04:45:55", "city.title": "Scottsdale", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1585": { "city_x_bank.id": 1585, "city.id": 35, "city.ts": "2017-08-18 04:45:55", "city.title": "Sun Lakes", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1685": { "city_x_bank.id": 1685, "city.id": 37, "city.ts": "2017-08-18 04:45:55", "city.title": "Tempe", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "141": { "bank_x_featured_product.id": 141, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "142": { "bank_x_featured_product.id": 142, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "143": { "bank_x_featured_product.id": 143, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "144": { "bank_x_featured_product.id": 144, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "145": { "bank_x_featured_product.id": 145, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "146": { "bank_x_featured_product.id": 146, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "147": { "bank_x_featured_product.id": 147, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "148": { "bank_x_featured_product.id": 148, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "149": { "bank_x_featured_product.id": 149, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "150": { "bank_x_featured_product.id": 150, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "111": { "bank_x_financial_center_service.id": 111, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "112": { "bank_x_financial_center_service.id": 112, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "113": { "bank_x_financial_center_service.id": 113, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "114": { "bank_x_financial_center_service.id": 114, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "115": { "bank_x_financial_center_service.id": 115, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "116": { "bank_x_financial_center_service.id": 116, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" } } }, "19": { "bank.id": 19, "bank.ts": "2017-08-19 21:12:18", "bank.title": "Gilbert & Warner", "bank.street_address": "900 S Gilbert Rd", "bank.locality": "Gilbert", "bank.region": "AZ", "bank.postal_code": 85296, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 558-2380", "bank.city_x_bank_id": { "19": { "city_x_bank.id": 19, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "266": { "city_x_bank.id": 266, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "351": { "city_x_bank.id": 351, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "569": { "city_x_bank.id": 569, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "931": { "city_x_bank.id": 931, "city.id": 21, "city.ts": "2017-08-18 04:45:55", "city.title": "Maricopa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "968": { "city_x_bank.id": 968, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1280": { "city_x_bank.id": 1280, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1566": { "city_x_bank.id": 1566, "city.id": 35, "city.ts": "2017-08-18 04:45:55", "city.title": "Sun Lakes", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1697": { "city_x_bank.id": 1697, "city.id": 37, "city.ts": "2017-08-18 04:45:55", "city.title": "Tempe", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "151": { "bank_x_featured_product.id": 151, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "152": { "bank_x_featured_product.id": 152, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "153": { "bank_x_featured_product.id": 153, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "154": { "bank_x_featured_product.id": 154, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "155": { "bank_x_featured_product.id": 155, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "156": { "bank_x_featured_product.id": 156, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "157": { "bank_x_featured_product.id": 157, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "158": { "bank_x_featured_product.id": 158, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "159": { "bank_x_featured_product.id": 159, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "160": { "bank_x_featured_product.id": 160, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "117": { "bank_x_financial_center_service.id": 117, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "118": { "bank_x_financial_center_service.id": 118, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "119": { "bank_x_financial_center_service.id": 119, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "121": { "bank_x_financial_center_service.id": 121, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "122": { "bank_x_financial_center_service.id": 122, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "123": { "bank_x_financial_center_service.id": 123, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "120": { "bank_x_financial_center_service.id": 120, "financial_center_service.id": 34, "financial_center_service.ts": "2017-08-19 21:10:53", "financial_center_service.title": "Change Orders" } } }, "20": { "bank.id": 20, "bank.ts": "2017-08-19 21:12:25", "bank.title": "Stapley & Baseline", "bank.street_address": "1952 S Stapley Dr", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85204, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 635-3360", "bank.city_x_bank_id": { "20": { "city_x_bank.id": 20, "city.id": 1, "city.ts": "2017-08-18 04:45:55", "city.title": "Apache Junction", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "276": { "city_x_bank.id": 276, "city.id": 6, "city.ts": "2017-08-18 04:45:55", "city.title": "Casa Grande", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "357": { "city_x_bank.id": 357, "city.id": 8, "city.ts": "2017-08-18 04:45:55", "city.title": "Chandler", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "555": { "city_x_bank.id": 555, "city.id": 12, "city.ts": "2017-08-18 04:45:55", "city.title": "Fountain Hills", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "571": { "city_x_bank.id": 571, "city.id": 13, "city.ts": "2017-08-18 04:45:55", "city.title": "Gilbert", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "945": { "city_x_bank.id": 945, "city.id": 21, "city.ts": "2017-08-18 04:45:55", "city.title": "Maricopa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "959": { "city_x_bank.id": 959, "city.id": 22, "city.ts": "2017-08-18 04:45:55", "city.title": "Mesa", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1287": { "city_x_bank.id": 1287, "city.id": 29, "city.ts": "2017-08-18 04:45:55", "city.title": "Queen Creek", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1575": { "city_x_bank.id": 1575, "city.id": 35, "city.ts": "2017-08-18 04:45:55", "city.title": "Sun Lakes", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1684": { "city_x_bank.id": 1684, "city.id": 37, "city.ts": "2017-08-18 04:45:55", "city.title": "Tempe", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" } }, "bank.bank_x_featured_product_id": { "161": { "bank_x_featured_product.id": 161, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "162": { "bank_x_featured_product.id": 162, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "163": { "bank_x_featured_product.id": 163, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "164": { "bank_x_featured_product.id": 164, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "165": { "bank_x_featured_product.id": 165, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "166": { "bank_x_featured_product.id": 166, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "167": { "bank_x_featured_product.id": 167, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "168": { "bank_x_featured_product.id": 168, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "169": { "bank_x_featured_product.id": 169, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "170": { "bank_x_featured_product.id": 170, "featured_product.id": 10, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Mobile Banking" } }, "bank.bank_x_financial_center_service_id": { "124": { "bank_x_financial_center_service.id": 124, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "125": { "bank_x_financial_center_service.id": 125, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "126": { "bank_x_financial_center_service.id": 126, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "128": { "bank_x_financial_center_service.id": 128, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "129": { "bank_x_financial_center_service.id": 129, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "130": { "bank_x_financial_center_service.id": 130, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "127": { "bank_x_financial_center_service.id": 127, "financial_center_service.id": 34, "financial_center_service.ts": "2017-08-19 21:10:53", "financial_center_service.title": "Change Orders" } } } } } }