It looks like it ripped off a number of the solder pads on the board. From what I see of the board I would imagine the connector came off intact and the biggest problem is going to be re-establishing solder pads on the board tied in with the traces. Might end up being a multi stage process. I will work on getting you a name for your connector. They should be available through Digikey, Mouser, Newark, etc... If you are planning on attaching a connector to what is on the board You are going to need a stereo microscope and a 1/64" conical tip on your soldering iron to do the work. I would suggest you take this to the local TV repair shop. Pay them the $50 to solder it in. You are only going to get about 1 shot at repairing this. Can you post a picture top and bottom of what is left of the connector to get an idea if it can be used again?
Here is a link to the spreadsheet I mentioned in my comment.