What table(s) store US cities and counties?
In order to show the names of the counties/cities that correspond to the numeric codes that are are stored in various Oracle tables, I need to know the name(s) of the table(s) that store this information. Better yet, if someone could provide me with SQL queries to pull this information (City/County codes and meaningful names), I would appreciate it.
For example, when running the below query for a particular person id, it returns numeric codes in CONTEXT_VALUE1 and CONTEXT_VALUE2. I know that CONTEXT_VALUE1 of 23 equates to US state MI (Michigan). However, I am trying to find the table that stores county codes and their meanings, as well as city codes and their meanings. In the below snip-it, I believe that CONTEXT_VALUE2 of 145 equates to "Saginaw", but I need to find the table that stores this information.