The shipping information is stored in the Orders table with each order. You can join in that table using the userID to get all shipping addresses used for any orders associated with that user.
We don't use a DB table for the list of states I don't think. You could just update the list to have the values you want to use in DW. If it does come from the DB you could just add it to the DB.