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" }, "prev": { "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/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 20, "limit_total": 400, "time": 0.005340000000000000128508315100361869554035365581512451171875 }, "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": { "21": { "bank.id": 21, "bank.ts": "2017-08-19 21:12:26", "bank.title": "Mesa Main", "bank.street_address": "63 W Main St", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85201, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 827-6810", "bank.city_x_bank_id": { "21": { "city_x_bank.id": 21, "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" }, "289": { "city_x_bank.id": 289, "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" }, "369": { "city_x_bank.id": 369, "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" }, "544": { "city_x_bank.id": 544, "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" }, "578": { "city_x_bank.id": 578, "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" }, "953": { "city_x_bank.id": 953, "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" }, "962": { "city_x_bank.id": 962, "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" }, "1298": { "city_x_bank.id": 1298, "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" }, "1347": { "city_x_bank.id": 1347, "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" }, "1584": { "city_x_bank.id": 1584, "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" }, "1670": { "city_x_bank.id": 1670, "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": { "171": { "bank_x_featured_product.id": 171, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "172": { "bank_x_featured_product.id": 172, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "173": { "bank_x_featured_product.id": 173, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "174": { "bank_x_featured_product.id": 174, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "175": { "bank_x_featured_product.id": 175, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "176": { "bank_x_featured_product.id": 176, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "177": { "bank_x_featured_product.id": 177, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "178": { "bank_x_featured_product.id": 178, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "179": { "bank_x_featured_product.id": 179, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "180": { "bank_x_featured_product.id": 180, "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": { "131": { "bank_x_financial_center_service.id": 131, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "132": { "bank_x_financial_center_service.id": 132, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "133": { "bank_x_financial_center_service.id": 133, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "134": { "bank_x_financial_center_service.id": 134, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "135": { "bank_x_financial_center_service.id": 135, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "136": { "bank_x_financial_center_service.id": 136, "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.id": 22, "bank.ts": "2017-08-19 21:12:37", "bank.title": "Fountain Hills Plaza", "bank.street_address": "16625 E Palisades 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": "", "bank.city_x_bank_id": { "22": { "city_x_bank.id": 22, "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" }, "228": { "city_x_bank.id": 228, "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" }, "333": { "city_x_bank.id": 333, "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" }, "445": { "city_x_bank.id": 445, "city.id": 9, "city.ts": "2017-08-18 04:45:55", "city.title": "Cottonwood", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "518": { "city_x_bank.id": 518, "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" }, "1401": { "city_x_bank.id": 1401, "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": {}, "bank.bank_x_financial_center_service_id": {} }, "23": { "bank.id": 23, "bank.ts": "2017-08-19 21:12:39", "bank.title": "Gilbert & Germann", "bank.street_address": "3881 S Gilbert Rd", "bank.locality": "Gilbert", "bank.region": "AZ", "bank.postal_code": 85297, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 917-2243", "bank.city_x_bank_id": { "23": { "city_x_bank.id": 23, "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" }, "259": { "city_x_bank.id": 259, "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" }, "356": { "city_x_bank.id": 356, "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" }, "579": { "city_x_bank.id": 579, "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" }, "921": { "city_x_bank.id": 921, "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" }, "982": { "city_x_bank.id": 982, "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" }, "1050": { "city_x_bank.id": 1050, "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" }, "1275": { "city_x_bank.id": 1275, "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" }, "1560": { "city_x_bank.id": 1560, "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" }, "1756": { "city_x_bank.id": 1756, "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": { "181": { "bank_x_featured_product.id": 181, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "182": { "bank_x_featured_product.id": 182, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "183": { "bank_x_featured_product.id": 183, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "184": { "bank_x_featured_product.id": 184, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "185": { "bank_x_featured_product.id": 185, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "186": { "bank_x_featured_product.id": 186, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "187": { "bank_x_featured_product.id": 187, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "188": { "bank_x_featured_product.id": 188, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "189": { "bank_x_featured_product.id": 189, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "190": { "bank_x_featured_product.id": 190, "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": { "137": { "bank_x_financial_center_service.id": 137, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "140": { "bank_x_financial_center_service.id": 140, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "141": { "bank_x_financial_center_service.id": 141, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "143": { "bank_x_financial_center_service.id": 143, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "144": { "bank_x_financial_center_service.id": 144, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "145": { "bank_x_financial_center_service.id": 145, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "138": { "bank_x_financial_center_service.id": 138, "financial_center_service.id": 13, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Financial Solutions Advisor" }, "139": { "bank_x_financial_center_service.id": 139, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" }, "142": { "bank_x_financial_center_service.id": 142, "financial_center_service.id": 34, "financial_center_service.ts": "2017-08-19 21:10:53", "financial_center_service.title": "Change Orders" } } }, "24": { "bank.id": 24, "bank.ts": "2017-08-19 21:12:45", "bank.title": "Mesa Country Club", "bank.street_address": "455 N Country Club Dr", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85201, "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": { "24": { "city_x_bank.id": 24, "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" }, "293": { "city_x_bank.id": 293, "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" }, "373": { "city_x_bank.id": 373, "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" }, "540": { "city_x_bank.id": 540, "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" }, "583": { "city_x_bank.id": 583, "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" }, "956": { "city_x_bank.id": 956, "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" }, "963": { "city_x_bank.id": 963, "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" }, "1300": { "city_x_bank.id": 1300, "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" }, "1342": { "city_x_bank.id": 1342, "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" }, "1589": { "city_x_bank.id": 1589, "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" }, "1668": { "city_x_bank.id": 1668, "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": {}, "bank.bank_x_financial_center_service_id": {} }, "25": { "bank.id": 25, "bank.ts": "2017-08-19 21:12:52", "bank.title": "Crossroads Towne Center", "bank.street_address": "2608 E Germann Rd", "bank.locality": "Chandler", "bank.region": "AZ", "bank.postal_code": 85286, "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": { "25": { "city_x_bank.id": 25, "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" }, "260": { "city_x_bank.id": 260, "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" }, "354": { "city_x_bank.id": 354, "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" }, "580": { "city_x_bank.id": 580, "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" }, "920": { "city_x_bank.id": 920, "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" }, "983": { "city_x_bank.id": 983, "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" }, "1052": { "city_x_bank.id": 1052, "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" }, "1276": { "city_x_bank.id": 1276, "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" }, "1559": { "city_x_bank.id": 1559, "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" }, "1758": { "city_x_bank.id": 1758, "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": {} }, "26": { "bank.id": 26, "bank.ts": "2017-08-19 21:13:04", "bank.title": "Johnson Ranch", "bank.street_address": "520 E Hunt Hwy", "bank.locality": "Queen Creek", "bank.region": "AZ", "bank.postal_code": 85143, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 987-6010", "bank.city_x_bank_id": { "26": { "city_x_bank.id": 26, "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" }, "254": { "city_x_bank.id": 254, "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" }, "755": { "city_x_bank.id": 755, "city.id": 16, "city.ts": "2017-08-18 04:45:55", "city.title": "Green Valley", "state.id": 1, "state.ts": "2017-08-14 21:15:56", "state.title": "Arizona" }, "1044": { "city_x_bank.id": 1044, "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" }, "1272": { "city_x_bank.id": 1272, "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" }, "1602": { "city_x_bank.id": 1602, "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" }, "1750": { "city_x_bank.id": 1750, "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": { "191": { "bank_x_featured_product.id": 191, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "192": { "bank_x_featured_product.id": 192, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "193": { "bank_x_featured_product.id": 193, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "194": { "bank_x_featured_product.id": 194, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "195": { "bank_x_featured_product.id": 195, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "196": { "bank_x_featured_product.id": 196, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "197": { "bank_x_featured_product.id": 197, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "198": { "bank_x_featured_product.id": 198, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "199": { "bank_x_featured_product.id": 199, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "200": { "bank_x_featured_product.id": 200, "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": { "146": { "bank_x_financial_center_service.id": 146, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "147": { "bank_x_financial_center_service.id": 147, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "148": { "bank_x_financial_center_service.id": 148, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "150": { "bank_x_financial_center_service.id": 150, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "151": { "bank_x_financial_center_service.id": 151, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "152": { "bank_x_financial_center_service.id": 152, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "149": { "bank_x_financial_center_service.id": 149, "financial_center_service.id": 34, "financial_center_service.ts": "2017-08-19 21:10:53", "financial_center_service.title": "Change Orders" } } }, "27": { "bank.id": 27, "bank.ts": "2017-08-19 21:13:09", "bank.title": "Fry's - Alma School & Main", "bank.street_address": "1245 W Main", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85201, "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": { "27": { "city_x_bank.id": 27, "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" }, "290": { "city_x_bank.id": 290, "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" }, "371": { "city_x_bank.id": 371, "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" }, "550": { "city_x_bank.id": 550, "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" }, "584": { "city_x_bank.id": 584, "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" }, "947": { "city_x_bank.id": 947, "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" }, "967": { "city_x_bank.id": 967, "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" }, "1302": { "city_x_bank.id": 1302, "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" }, "1337": { "city_x_bank.id": 1337, "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" }, "1583": { "city_x_bank.id": 1583, "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" }, "1664": { "city_x_bank.id": 1664, "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": {}, "bank.bank_x_financial_center_service_id": {} }, "28": { "bank.id": 28, "bank.ts": "2017-08-19 21:13:12", "bank.title": "Financial Plaza", "bank.street_address": "1201 S Alma School Rd", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85210, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 610-4907", "bank.city_x_bank_id": { "28": { "city_x_bank.id": 28, "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" }, "282": { "city_x_bank.id": 282, "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" }, "365": { "city_x_bank.id": 365, "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" }, "556": { "city_x_bank.id": 556, "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" }, "576": { "city_x_bank.id": 576, "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" }, "940": { "city_x_bank.id": 940, "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" }, "966": { "city_x_bank.id": 966, "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" }, "1297": { "city_x_bank.id": 1297, "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" }, "1351": { "city_x_bank.id": 1351, "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" }, "1576": { "city_x_bank.id": 1576, "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" }, "1663": { "city_x_bank.id": 1663, "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": {}, "bank.bank_x_financial_center_service_id": {} }, "29": { "bank.id": 29, "bank.ts": "2017-08-19 21:13:25", "bank.title": "Alma School & Elliot", "bank.street_address": "2998 N Alma School Rd", "bank.locality": "Chandler", "bank.region": "AZ", "bank.postal_code": 85224, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 726-3619", "bank.city_x_bank_id": { "29": { "city_x_bank.id": 29, "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" }, "272": { "city_x_bank.id": 272, "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" }, "353": { "city_x_bank.id": 353, "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" }, "573": { "city_x_bank.id": 573, "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" }, "925": { "city_x_bank.id": 925, "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" }, "971": { "city_x_bank.id": 971, "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" }, "1291": { "city_x_bank.id": 1291, "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" }, "1563": { "city_x_bank.id": 1563, "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" }, "1667": { "city_x_bank.id": 1667, "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": { "201": { "bank_x_featured_product.id": 201, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "202": { "bank_x_featured_product.id": 202, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "203": { "bank_x_featured_product.id": 203, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "204": { "bank_x_featured_product.id": 204, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "205": { "bank_x_featured_product.id": 205, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "206": { "bank_x_featured_product.id": 206, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "207": { "bank_x_featured_product.id": 207, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "208": { "bank_x_featured_product.id": 208, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "209": { "bank_x_featured_product.id": 209, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "210": { "bank_x_featured_product.id": 210, "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": { "153": { "bank_x_financial_center_service.id": 153, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "154": { "bank_x_financial_center_service.id": 154, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "155": { "bank_x_financial_center_service.id": 155, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "156": { "bank_x_financial_center_service.id": 156, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "157": { "bank_x_financial_center_service.id": 157, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "158": { "bank_x_financial_center_service.id": 158, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" } } }, "30": { "bank.id": 30, "bank.ts": "2017-08-19 21:13:33", "bank.title": "Salt River Indian Reservation", "bank.street_address": "10005 E Osborn", "bank.locality": "Scottsdale", "bank.region": "AZ", "bank.postal_code": 85256, "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": { "30": { "city_x_bank.id": 30, "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" }, "390": { "city_x_bank.id": 390, "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" }, "529": { "city_x_bank.id": 529, "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" }, "604": { "city_x_bank.id": 604, "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" }, "981": { "city_x_bank.id": 981, "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" }, "1311": { "city_x_bank.id": 1311, "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" }, "1325": { "city_x_bank.id": 1325, "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" }, "1683": { "city_x_bank.id": 1683, "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": {}, "bank.bank_x_financial_center_service_id": {} }, "31": { "bank.id": 31, "bank.ts": "2017-08-19 21:13:34", "bank.title": "Baseline & Dobson", "bank.street_address": "1961 W Baseline Rd", "bank.locality": "Mesa", "bank.region": "AZ", "bank.postal_code": 85202, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 730-3444", "bank.city_x_bank_id": { "31": { "city_x_bank.id": 31, "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" }, "279": { "city_x_bank.id": 279, "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" }, "362": { "city_x_bank.id": 362, "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" }, "582": { "city_x_bank.id": 582, "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" }, "933": { "city_x_bank.id": 933, "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" }, "970": { "city_x_bank.id": 970, "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" }, "1299": { "city_x_bank.id": 1299, "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" }, "1354": { "city_x_bank.id": 1354, "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" }, "1570": { "city_x_bank.id": 1570, "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" }, "1661": { "city_x_bank.id": 1661, "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": { "211": { "bank_x_featured_product.id": 211, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "212": { "bank_x_featured_product.id": 212, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "213": { "bank_x_featured_product.id": 213, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "214": { "bank_x_featured_product.id": 214, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "215": { "bank_x_featured_product.id": 215, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "216": { "bank_x_featured_product.id": 216, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "217": { "bank_x_featured_product.id": 217, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "218": { "bank_x_featured_product.id": 218, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "219": { "bank_x_featured_product.id": 219, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "220": { "bank_x_featured_product.id": 220, "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": { "159": { "bank_x_financial_center_service.id": 159, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "161": { "bank_x_financial_center_service.id": 161, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "162": { "bank_x_financial_center_service.id": 162, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "163": { "bank_x_financial_center_service.id": 163, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "164": { "bank_x_financial_center_service.id": 164, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "165": { "bank_x_financial_center_service.id": 165, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "160": { "bank_x_financial_center_service.id": 160, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" } } }, "32": { "bank.id": 32, "bank.ts": "2017-08-19 21:13:42", "bank.title": "Chandler & Alma School", "bank.street_address": "198 N Alma School Rd", "bank.locality": "Chandler", "bank.region": "AZ", "bank.postal_code": 85224, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 726-3601", "bank.city_x_bank_id": { "32": { "city_x_bank.id": 32, "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" }, "262": { "city_x_bank.id": 262, "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" }, "352": { "city_x_bank.id": 352, "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" }, "581": { "city_x_bank.id": 581, "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" }, "917": { "city_x_bank.id": 917, "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" }, "978": { "city_x_bank.id": 978, "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" }, "1288": { "city_x_bank.id": 1288, "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" }, "1556": { "city_x_bank.id": 1556, "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" }, "1686": { "city_x_bank.id": 1686, "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": { "221": { "bank_x_featured_product.id": 221, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "222": { "bank_x_featured_product.id": 222, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "223": { "bank_x_featured_product.id": 223, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "224": { "bank_x_featured_product.id": 224, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "225": { "bank_x_featured_product.id": 225, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "226": { "bank_x_featured_product.id": 226, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "227": { "bank_x_featured_product.id": 227, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "228": { "bank_x_featured_product.id": 228, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "229": { "bank_x_featured_product.id": 229, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "230": { "bank_x_featured_product.id": 230, "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": { "166": { "bank_x_financial_center_service.id": 166, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "170": { "bank_x_financial_center_service.id": 170, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "171": { "bank_x_financial_center_service.id": 171, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "172": { "bank_x_financial_center_service.id": 172, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "173": { "bank_x_financial_center_service.id": 173, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "174": { "bank_x_financial_center_service.id": 174, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "167": { "bank_x_financial_center_service.id": 167, "financial_center_service.id": 13, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Financial Solutions Advisor" }, "168": { "bank_x_financial_center_service.id": 168, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" }, "169": { "bank_x_financial_center_service.id": 169, "financial_center_service.id": 24, "financial_center_service.ts": "2017-08-19 21:10:47", "financial_center_service.title": "Centralized Small Business Banker" } } }, "33": { "bank.id": 33, "bank.ts": "2017-08-19 21:13:45", "bank.title": "Ocotillo", "bank.street_address": "3075 S Alma School Rd", "bank.locality": "Chandler", "bank.region": "AZ", "bank.postal_code": 85248, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 726-3630", "bank.city_x_bank_id": { "33": { "city_x_bank.id": 33, "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" }, "258": { "city_x_bank.id": 258, "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" }, "361": { "city_x_bank.id": 361, "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" }, "593": { "city_x_bank.id": 593, "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" }, "912": { "city_x_bank.id": 912, "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" }, "995": { "city_x_bank.id": 995, "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" }, "1057": { "city_x_bank.id": 1057, "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" }, "1286": { "city_x_bank.id": 1286, "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" }, "1555": { "city_x_bank.id": 1555, "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" }, "1759": { "city_x_bank.id": 1759, "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": { "231": { "bank_x_featured_product.id": 231, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "232": { "bank_x_featured_product.id": 232, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "233": { "bank_x_featured_product.id": 233, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "234": { "bank_x_featured_product.id": 234, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "235": { "bank_x_featured_product.id": 235, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "236": { "bank_x_featured_product.id": 236, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "237": { "bank_x_featured_product.id": 237, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "238": { "bank_x_featured_product.id": 238, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "239": { "bank_x_featured_product.id": 239, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "240": { "bank_x_featured_product.id": 240, "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": { "175": { "bank_x_financial_center_service.id": 175, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "179": { "bank_x_financial_center_service.id": 179, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "180": { "bank_x_financial_center_service.id": 180, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "181": { "bank_x_financial_center_service.id": 181, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "182": { "bank_x_financial_center_service.id": 182, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "183": { "bank_x_financial_center_service.id": 183, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "176": { "bank_x_financial_center_service.id": 176, "financial_center_service.id": 13, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Financial Solutions Advisor" }, "177": { "bank_x_financial_center_service.id": 177, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" }, "178": { "bank_x_financial_center_service.id": 178, "financial_center_service.id": 24, "financial_center_service.ts": "2017-08-19 21:10:47", "financial_center_service.title": "Centralized Small Business Banker" } } }, "34": { "bank.id": 34, "bank.ts": "2017-08-19 21:13:56", "bank.title": "Southern/McClintock", "bank.street_address": "1801 E Southern Ave", "bank.locality": "Tempe", "bank.region": "AZ", "bank.postal_code": 85282, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 730-3423", "bank.city_x_bank_id": { "34": { "city_x_bank.id": 34, "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" }, "285": { "city_x_bank.id": 285, "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" }, "372": { "city_x_bank.id": 372, "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" }, "592": { "city_x_bank.id": 592, "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" }, "936": { "city_x_bank.id": 936, "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" }, "975": { "city_x_bank.id": 975, "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" }, "1305": { "city_x_bank.id": 1305, "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" }, "1344": { "city_x_bank.id": 1344, "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" }, "1578": { "city_x_bank.id": 1578, "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" }, "1656": { "city_x_bank.id": 1656, "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": { "241": { "bank_x_featured_product.id": 241, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "242": { "bank_x_featured_product.id": 242, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "243": { "bank_x_featured_product.id": 243, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "244": { "bank_x_featured_product.id": 244, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "245": { "bank_x_featured_product.id": 245, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "246": { "bank_x_featured_product.id": 246, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "247": { "bank_x_featured_product.id": 247, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "248": { "bank_x_featured_product.id": 248, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "249": { "bank_x_featured_product.id": 249, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "250": { "bank_x_featured_product.id": 250, "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": { "184": { "bank_x_financial_center_service.id": 184, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "185": { "bank_x_financial_center_service.id": 185, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "186": { "bank_x_financial_center_service.id": 186, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "187": { "bank_x_financial_center_service.id": 187, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "188": { "bank_x_financial_center_service.id": 188, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "189": { "bank_x_financial_center_service.id": 189, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" } } }, "35": { "bank.id": 35, "bank.ts": "2017-08-19 21:14:06", "bank.title": "Broadway & Mcclintock", "bank.street_address": "1707 E Broadway", "bank.locality": "Tempe", "bank.region": "AZ", "bank.postal_code": 85282, "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": { "35": { "city_x_bank.id": 35, "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" }, "291": { "city_x_bank.id": 291, "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" }, "375": { "city_x_bank.id": 375, "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" }, "561": { "city_x_bank.id": 561, "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" }, "594": { "city_x_bank.id": 594, "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" }, "939": { "city_x_bank.id": 939, "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" }, "976": { "city_x_bank.id": 976, "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" }, "1307": { "city_x_bank.id": 1307, "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" }, "1333": { "city_x_bank.id": 1333, "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" }, "1582": { "city_x_bank.id": 1582, "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" }, "1655": { "city_x_bank.id": 1655, "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": {}, "bank.bank_x_financial_center_service_id": {} }, "36": { "bank.id": 36, "bank.ts": "2017-08-19 21:14:09", "bank.title": "Mercado", "bank.street_address": "10075 E Via Linda Rd", "bank.locality": "Scottsdale", "bank.region": "AZ", "bank.postal_code": 85258, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 767-2002", "bank.city_x_bank_id": { "36": { "city_x_bank.id": 36, "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" }, "223": { "city_x_bank.id": 223, "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" }, "327": { "city_x_bank.id": 327, "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" }, "521": { "city_x_bank.id": 521, "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" }, "1335": { "city_x_bank.id": 1335, "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" }, "1411": { "city_x_bank.id": 1411, "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": { "251": { "bank_x_featured_product.id": 251, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "252": { "bank_x_featured_product.id": 252, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "253": { "bank_x_featured_product.id": 253, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "254": { "bank_x_featured_product.id": 254, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "255": { "bank_x_featured_product.id": 255, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "256": { "bank_x_featured_product.id": 256, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "257": { "bank_x_featured_product.id": 257, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "258": { "bank_x_featured_product.id": 258, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "259": { "bank_x_featured_product.id": 259, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "260": { "bank_x_featured_product.id": 260, "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": { "190": { "bank_x_financial_center_service.id": 190, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "194": { "bank_x_financial_center_service.id": 194, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "195": { "bank_x_financial_center_service.id": 195, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "196": { "bank_x_financial_center_service.id": 196, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "197": { "bank_x_financial_center_service.id": 197, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "198": { "bank_x_financial_center_service.id": 198, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "191": { "bank_x_financial_center_service.id": 191, "financial_center_service.id": 13, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Financial Solutions Advisor" }, "192": { "bank_x_financial_center_service.id": 192, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" }, "193": { "bank_x_financial_center_service.id": 193, "financial_center_service.id": 24, "financial_center_service.ts": "2017-08-19 21:10:47", "financial_center_service.title": "Centralized Small Business Banker" } } }, "37": { "bank.id": 37, "bank.ts": "2017-08-19 21:14:21", "bank.title": "Mcclintock & Guadalupe", "bank.street_address": "1702 E Guadalupe", "bank.locality": "Tempe", "bank.region": "AZ", "bank.postal_code": 85283, "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": { "37": { "city_x_bank.id": 37, "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" }, "277": { "city_x_bank.id": 277, "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" }, "366": { "city_x_bank.id": 366, "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" }, "590": { "city_x_bank.id": 590, "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" }, "924": { "city_x_bank.id": 924, "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" }, "980": { "city_x_bank.id": 980, "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" }, "1304": { "city_x_bank.id": 1304, "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" }, "1363": { "city_x_bank.id": 1363, "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" }, "1568": { "city_x_bank.id": 1568, "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" }, "1660": { "city_x_bank.id": 1660, "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": {}, "bank.bank_x_financial_center_service_id": {} }, "38": { "bank.id": 38, "bank.ts": "2017-08-19 21:14:31", "bank.title": "Chandler Fashion Center Mall - Escltr Ll", "bank.street_address": "3111 W Chandler Blvd", "bank.locality": "Chandler", "bank.region": "AZ", "bank.postal_code": 85226, "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": { "38": { "city_x_bank.id": 38, "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" }, "264": { "city_x_bank.id": 264, "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" }, "359": { "city_x_bank.id": 359, "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" }, "589": { "city_x_bank.id": 589, "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" }, "915": { "city_x_bank.id": 915, "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" }, "989": { "city_x_bank.id": 989, "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" }, "1294": { "city_x_bank.id": 1294, "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" }, "1557": { "city_x_bank.id": 1557, "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" }, "1680": { "city_x_bank.id": 1680, "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": {}, "bank.bank_x_financial_center_service_id": {} }, "39": { "bank.id": 39, "bank.ts": "2017-08-19 21:14:34", "bank.title": "Warner & McClintock", "bank.street_address": "1820 E Warner Rd", "bank.locality": "Tempe", "bank.region": "AZ", "bank.postal_code": 85284, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 730-3430", "bank.city_x_bank_id": { "39": { "city_x_bank.id": 39, "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" }, "271": { "city_x_bank.id": 271, "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" }, "364": { "city_x_bank.id": 364, "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" }, "588": { "city_x_bank.id": 588, "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" }, "919": { "city_x_bank.id": 919, "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" }, "985": { "city_x_bank.id": 985, "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" }, "1301": { "city_x_bank.id": 1301, "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" }, "1562": { "city_x_bank.id": 1562, "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" }, "1666": { "city_x_bank.id": 1666, "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": { "261": { "bank_x_featured_product.id": 261, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "262": { "bank_x_featured_product.id": 262, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "263": { "bank_x_featured_product.id": 263, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "264": { "bank_x_featured_product.id": 264, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "265": { "bank_x_featured_product.id": 265, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "266": { "bank_x_featured_product.id": 266, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "267": { "bank_x_featured_product.id": 267, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "268": { "bank_x_featured_product.id": 268, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "269": { "bank_x_featured_product.id": 269, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "270": { "bank_x_featured_product.id": 270, "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": { "199": { "bank_x_financial_center_service.id": 199, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "202": { "bank_x_financial_center_service.id": 202, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "203": { "bank_x_financial_center_service.id": 203, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "204": { "bank_x_financial_center_service.id": 204, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "205": { "bank_x_financial_center_service.id": 205, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "206": { "bank_x_financial_center_service.id": 206, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "200": { "bank_x_financial_center_service.id": 200, "financial_center_service.id": 13, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Financial Solutions Advisor" }, "201": { "bank_x_financial_center_service.id": 201, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" } } }, "40": { "bank.id": 40, "bank.ts": "2017-08-19 21:14:42", "bank.title": "Chandler Fashion Center", "bank.street_address": "3410 W Chandler Blvd", "bank.locality": "Chandler", "bank.region": "AZ", "bank.postal_code": 85226, "bank.country": "US", "bank.atm": "Open 24 hours", "bank.atm_language": "English, Spanish, Chinese, Korean, French, Russian, Portuguese", "bank.phone": "(480) 224-2021", "bank.city_x_bank_id": { "40": { "city_x_bank.id": 40, "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" }, "265": { "city_x_bank.id": 265, "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" }, "360": { "city_x_bank.id": 360, "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" }, "591": { "city_x_bank.id": 591, "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" }, "914": { "city_x_bank.id": 914, "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" }, "991": { "city_x_bank.id": 991, "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" }, "1295": { "city_x_bank.id": 1295, "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" }, "1558": { "city_x_bank.id": 1558, "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" }, "1679": { "city_x_bank.id": 1679, "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": { "271": { "bank_x_featured_product.id": 271, "featured_product.id": 1, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Savings Accounts" }, "272": { "bank_x_featured_product.id": 272, "featured_product.id": 2, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Auto Loans" }, "273": { "bank_x_featured_product.id": 273, "featured_product.id": 3, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Mortgages" }, "274": { "bank_x_featured_product.id": 274, "featured_product.id": 4, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Home Equity Lines of Credit" }, "275": { "bank_x_featured_product.id": 275, "featured_product.id": 5, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Checking Accounts" }, "276": { "bank_x_featured_product.id": 276, "featured_product.id": 6, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Business Credit Cards" }, "277": { "bank_x_featured_product.id": 277, "featured_product.id": 7, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Checking Accounts" }, "278": { "bank_x_featured_product.id": 278, "featured_product.id": 8, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Credit Cards" }, "279": { "bank_x_featured_product.id": 279, "featured_product.id": 9, "featured_product.ts": "2017-08-19 21:10:00", "featured_product.title": "Online Banking" }, "280": { "bank_x_featured_product.id": 280, "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": { "207": { "bank_x_financial_center_service.id": 207, "financial_center_service.id": 1, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Accepts appointments" }, "210": { "bank_x_financial_center_service.id": 210, "financial_center_service.id": 2, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Commercial Deposits Accepted" }, "211": { "bank_x_financial_center_service.id": 211, "financial_center_service.id": 3, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Night Deposit Accepted" }, "213": { "bank_x_financial_center_service.id": 213, "financial_center_service.id": 4, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Safe Deposit Box" }, "214": { "bank_x_financial_center_service.id": 214, "financial_center_service.id": 5, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "ATM Services Available" }, "215": { "bank_x_financial_center_service.id": 215, "financial_center_service.id": 6, "financial_center_service.ts": "2017-08-19 21:10:00", "financial_center_service.title": "Cash Non Customer Checks" }, "208": { "bank_x_financial_center_service.id": 208, "financial_center_service.id": 13, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Financial Solutions Advisor" }, "209": { "bank_x_financial_center_service.id": 209, "financial_center_service.id": 14, "financial_center_service.ts": "2017-08-19 21:10:25", "financial_center_service.title": "Home Loans Specialist" }, "212": { "bank_x_financial_center_service.id": 212, "financial_center_service.id": 34, "financial_center_service.ts": "2017-08-19 21:10:53", "financial_center_service.title": "Change Orders" } } } } } }