List of states, counties and zip codes of a country

My country, which is Spain, has several ways to name the same state, county or city. This is leading me to some issues when trying to create some graphs using maps, since QuickSight is not finding correctly the location.

I am asking where can I see a complete list of states/counties/cities per country in order to know how does QuickSight name those locations that have more than one possible option.

Hi @albmargar - Welcome to AWS QuickSight community and thanks for posting the question. I believe you are looking for the detail information how QuickSight determine the country,state for Spain in geo-map graph. Is my understanding correct?

I am not sure but tagging some experts who can help, @Koushik_Muthanna @eperts @David_Wong - Please advise.

Regards - Sanjeeb

Exactly @Sanjeeb2022 , I am particularly interested in Spain, but the question can be applied to any country.

Hi @albmargar - Take a look at this video which goes into great detail on the features of filled maps, hierarchies, and visualising data with filled maps.

TLDR: You can provide the data with the geo boundaries and state names you wish to use.

Hi @eperts, sorry for this late response. I already fixed the problem using a calculated field which translate some provinces from the Spanish to vasque langue since two of them are in vasque in QS: