{"action":"created","issue":{"url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0/issues/21","labels_url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0/issues/21/labels{/name}","comments_url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0/issues/21/comments","events_url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0/issues/21/events","html_url":"https://github.com/OHDSI/Vocabulary-v5.0/issues/21","id":56450878,"number":21,"title":"Duplicated CONCEPT_CODEs in MESH","user":{"login":"ericaVoss","id":6305439,"avatar_url":"https://avatars.githubusercontent.com/u/6305439?v=3","gravatar_id":"","url":"https://api.github.com/users/ericaVoss","html_url":"https://github.com/ericaVoss","followers_url":"https://api.github.com/users/ericaVoss/followers","following_url":"https://api.github.com/users/ericaVoss/following{/other_user}","gists_url":"https://api.github.com/users/ericaVoss/gists{/gist_id}","starred_url":"https://api.github.com/users/ericaVoss/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ericaVoss/subscriptions","organizations_url":"https://api.github.com/users/ericaVoss/orgs","repos_url":"https://api.github.com/users/ericaVoss/repos","events_url":"https://api.github.com/users/ericaVoss/events{/privacy}","received_events_url":"https://api.github.com/users/ericaVoss/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-02-03T22:51:43Z","updated_at":"2015-03-26T20:44:26Z","closed_at":null,"body":"for v5.0 2014-10-15\r\n\r\n```{sql}\r\nSELECT CONCEPT_CODE, VOCABULARY_ID, DOMAIN_ID, COUNT(*)\r\nFROM CONCEPT\r\nWHERE INVALID_REASON IS NULL\r\nAND VOCABULARY_ID NOT IN (\r\n    'MedDRA','SMQ','DRG'\r\n)\r\nAND CONCEPT_CODE NOT IN (\r\n    'OMOP generated'\r\n)\r\nGROUP BY CONCEPT_CODE, VOCABULARY_ID, DOMAIN_ID\r\nHAVING COUNT(*) > 1;\r\n```\r\n\r\n```{text}\r\nCONCEPT_CODE  VOCABULARY_ID       DOMAIN_ID              COUNT(*)\r\nD014508\tMesh\tDrug/Measurement\t2\r\nD014364\tMesh\tCondition/Drug\t2\r\nD001646\tMesh\tCondition/Drug\t2\r\n```\r\n\r\nThese Mesh CONCEPT_CODES get duplicated because they have this multi-domain (like \"Drug/Measurement\") but then they further break down later into their separate CONCEPT_CLASS_IDs.  It just feels odd and there are only 3 of them.\r\n"},"comment":{"url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0/issues/comments/86707997","html_url":"https://github.com/OHDSI/Vocabulary-v5.0/issues/21#issuecomment-86707997","issue_url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0/issues/21","id":86707997,"user":{"login":"ericaVoss","id":6305439,"avatar_url":"https://avatars.githubusercontent.com/u/6305439?v=3","gravatar_id":"","url":"https://api.github.com/users/ericaVoss","html_url":"https://github.com/ericaVoss","followers_url":"https://api.github.com/users/ericaVoss/followers","following_url":"https://api.github.com/users/ericaVoss/following{/other_user}","gists_url":"https://api.github.com/users/ericaVoss/gists{/gist_id}","starred_url":"https://api.github.com/users/ericaVoss/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ericaVoss/subscriptions","organizations_url":"https://api.github.com/users/ericaVoss/orgs","repos_url":"https://api.github.com/users/ericaVoss/repos","events_url":"https://api.github.com/users/ericaVoss/events{/privacy}","received_events_url":"https://api.github.com/users/ericaVoss/received_events","type":"User","site_admin":false},"created_at":"2015-03-26T20:44:26Z","updated_at":"2015-03-26T20:44:26Z","body":"Did we every decide if this is okay or not?\r\n"}}