Answers.Body: <p>It sounds like you're not using the latest version of CiviCRM (4.7.30 at the time of writing).  It sounds like you're experiencing the bug that was described and fixed at <a href="https://issues.civicrm.org/jira/browse/CRM-19888" rel="nofollow noreferrer">CRM-19888</a>.  It's also related to this <a href="https://issues.civicrm.org/jira/browse/CRM-7597" rel="nofollow noreferrer">much older bug</a>.</p>
  
  <p>Please upgrade to 4.7.30 and try again?</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-02-10T19:29:29.750Z
Answers.LastActivityDate: 2018-02-10T19:29:29.750Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>I may not have quite understood you but if you have access to your database you can look in civicrm_state_province where you will see there is a Maryland MY in Liberia (1122) as well as a Maryland MD in the USA (1228)</p>
  
  <p><a href="https://i.sstatic.net/UpajJ.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/UpajJ.png" alt="enter image description here"></a></p>
  
  <p>When importing contacts with State/Province you may be better off if you either import the abbreviation (though even that might not be unique) or also import Country.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-02-09T22:40:07.657Z
Answers.Text: I can see in the database: 1019 - Maryland - 1228. Yet, during someone's import the database decided on its own to assign over 600 records this: 3497 - Maryland - 1228
  Thanks for sharing how this might have occurred.
Answers.UserDisplayName: fndtn357
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-02-10T19:06:19.553Z
Answers.Text: nw. i edited the Title/Question to try and better reflect the issue
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-02-09T20:24:06.673Z
Answers.LastActivityDate: 2018-02-09T20:24:06.673Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>How could a CiviCRM database have 2 Marylands with 2 different <code>state_province_code</code>s but both be identified with the same <code>country_code</code>?</p>
  
  <p>1019 = Maryland
  3497 = Maryland
  1228 = United States</p>
  
  <p>I only was alerted to this when my newly inherited client created a Smart Group to display all records with <code>postal_code</code> between 20601 and 21930. </p>
  
  <p>Is my CiviCRM instance corrupt or has a bad import caused this? Can I manually adjust the offending records without cascading problems? How would you suggest a fix for this?</p>
  
Tags: <database><data-import>
Title: How did my import result in the State for a different country to the one intended
ThreadText: # How did my import result in the State for a different country to the one intended
  
  (Asked by: username_0 on 2018-02-09)
  
  How could a CiviCRM database have 2 Marylands with 2 different `state_province_code`s but both be identified with the same `country_code`?
  
  1019 = Maryland
  3497 = Maryland
  1228 = United States
  
  I only was alerted to this when my newly inherited client created a Smart Group to display all records with `postal_code` between 20601 and 21930.
  
  Is my CiviCRM instance corrupt or has a bad import caused this? Can I manually adjust the offending records without cascading problems? How would you suggest a fix for this?
  
  **Tags:** database, data-import
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2018-02-10. Score: 2 | Accepted answer
  
  It sounds like you're not using the latest version of CiviCRM (4.7.30 at the time of writing). It sounds like you're experiencing the bug that was described and fixed at [CRM-19888](https://issues.civicrm.org/jira/browse/CRM-19888). It's also related to this [much older bug](https://issues.civicrm.org/jira/browse/CRM-7597).
  
  Please upgrade to 4.7.30 and try again?
  
  
  ---
  
  ### Answer by username_2 on 2018-02-09. Score: 2
  
  I may not have quite understood you but if you have access to your database you can look in civicrm\_state\_province where you will see there is a Maryland MY in Liberia (1122) as well as a Maryland MD in the USA (1228)
  
  [![enter image description here](https://i.sstatic.net/UpajJ.png)](https://i.sstatic.net/UpajJ.png)
  
  When importing contacts with State/Province you may be better off if you either import the abbreviation (though even that might not be unique) or also import Country.
  
  > **Comments:**
  > **username_0**: I can see in the database: 1019 - Maryland - 1228. Yet, during someone's import the database decided on its own to assign over 600 records this: 3497 - Maryland - 1228 Thanks for sharing how this might have occurred.  
  > **username_2**: nw. i edited the Title/Question to try and better reflect the issue  
  
  ---
  
  