Help with hovering field data
A view with an exposed filter is what you are looking for.

Create a view with the fields that you want to show, and select the state code field as an exposed filter. Then the view will display only the content related to the state code selected by the user. The view may contain only one field, or many. If the relevant fields are in different entity/content types, you will need to define a Relationship in the view to connect them using an entity or node reference field.

Using Views you can get almost everything that you want if all the data involved is related. If you give us more concrete details about what you want to achieve, I could give you precise details of how to configure the View that will solve your problem.