Questions  /  Working with Data  /  SQL

I cannot geocode my country names dataset, although my column only has very few unique values

Learn a workaround to geocode more than 500 rows of country names with SQL and Builder analysis.

CARTO country geocoder analysis has a 500 rows limit. If your dataset has more than 500 rows but very few unique country name values there is a workaround for your use case:

Create a master table with unique country names

  • Open the original dataset and switch to SQL mode
  • Run the following query:
SELECT DISTINCT country FROM table