Incorrect map location

I am not getting the following two cities to map correctly:

Springfield, Missouri, USA

Columbia, Missouri, USA

Regardless if I combine city, state, and country into a single field and categorize it as City, or have separate fields with their own respective categories, the locations are not being mapped correctly.

When combining them into a single field neither one shows up on the map.  Separate fields places Springfield in Illinois and Columbia in South Carolina.

After further testing, I was able to get the two cities to map correctly when combining city, state and country into a single field as shown above and setting the category to either Place or Continent.  Neither seems appropriate, but they worked.

do you add "U.S.A." to zip code for clarification purposes?  What data category do you use for zip, and/or zip, country?

thanks in advance.

I used zipcode and I'm getting a city in France showing up in Cali :(