I've enabled Social Accounts and Contacts in our org, and now I'd like to grab that image from Salesforce via API to display on our external website. I'm particularly interested in the Twitter image. Is this possible?
Take a look at this answer:
The gist of it is that you can't query for that object via SOQL right now, so you unfortunately can't pull any of that data for your own use.