Answers.Body: <p>You can amend this list directly in the DB if you want to. You can find the relevant data in the civicrm_state_province table. To see the values for the UK use:</p>
  
  <pre><code>select *  from civicrm_state_province csp where country_id = 1226
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-04-28T06:47:20.323Z
Answers.LastActivityDate: 2020-04-28T06:47:20.323Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>The drop down list of UK Counties does not seem to include Middlesex.  Can the drop down list be amended?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-04-27T14:40:41.523Z
Comments.Text: Welcome to SE! I suspect the answer to your question is no, but what is your purpose of using county? In addresses the Post Office no longer uses counties (just post town and postcode). There are also administrative counties, but Middlesex ceased to be one of those ages ago. I think the information at https://en.wikipedia.org/wiki/Counties_of_the_United_Kingdom is reasonably correct.
Comments.UserDisplayName: Mick Kahn
Tags: <contacts>
Title: UK Counties list not complete - can this be amended by user or does it need to be amended in the core program?
ThreadText: # UK Counties list not complete - can this be amended by user or does it need to be amended in the core program?
  
  (Asked by: username_0 on 2020-04-27)
  
  The drop down list of UK Counties does not seem to include Middlesex. Can the drop down list be amended?
  
  **Tags:** contacts
  
  > **Comments:**
  > **username_1**: Welcome to SE! I suspect the answer to your question is no, but what is your purpose of using county? In addresses the Post Office no longer uses counties (just post town and postcode). There are also administrative counties, but Middlesex ceased to be one of those ages ago. I think the information at https://en.wikipedia.org/wiki/Counties_of_the_United_Kingdom is reasonably correct.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2020-04-28. Score: 1
  
  You can amend this list directly in the DB if you want to. You can find the relevant data in the civicrm\_state\_province table. To see the values for the UK use:
  
  ```
  select *  from civicrm_state_province csp where country_id = 1226
  
  ```
  
  
  ---
  
  