{"action":"closed","issue":{"url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0/issues/84","repository_url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0","labels_url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0/issues/84/labels{/name}","comments_url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0/issues/84/comments","events_url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0/issues/84/events","html_url":"https://github.com/OHDSI/Vocabulary-v5.0/issues/84","id":163435401,"number":84,"title":"Retired Multilex?","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":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2016-07-01T16:56:57Z","updated_at":"2016-12-22T01:08:34Z","closed_at":"2016-12-22T01:08:34Z","body":"**v5.0 20-JUN-16**\n\nHave we retired Multilex?  When comparing 20160311 to 20160620 I see 77K Multilex CONCEPT_IDs that no longer exist.\n\n``` sql\nSELECT b.*\nFROM [VOCABULARY_20160311].[DBO].[CONCEPT] B /*PREVIOUS VOCAB*/\nWHERE CONCEPT_ID NOT IN (\n      SELECT A.CONCEPT_ID\n      FROM CONCEPT A    /*CURRENT VOCAB*/\n      INTERSECT\n      SELECT B.CONCEPT_ID\n      FROM [VOCABULARY_20160311].[DBO].[CONCEPT] B /*PREVIOUS VOCAB*/\n) \nAND VOCABULARY_ID = 'Multilex'\nORDER BY CONCEPT_ID\n```\n\nExample missing CONCEPT_IDs:\n\n``` text\nconcept_id  concept_name    domain_id   vocabulary_id   concept_class_id    standard_concept    concept_code    valid_start_date    valid_end_date  invalid_reason\n43056019    None known  Drug    Multilex    Ingredient  S   1   2012-12-20  2099-12-31  NULL\n43056020    pantothenic acid    Drug    Multilex    Ingredient  NULL    10  2012-12-20  2099-12-31  NULL\n43056021    aminoglutethimide   Drug    Multilex    Ingredient  NULL    100 2012-12-20  2099-12-31  NULL\n43056022    bambuterol  Drug    Multilex    Ingredient  NULL    1000    2012-12-20  2099-12-31  NULL\n43056023    lemon spirit    Drug    Multilex    Clinical Drug   S   10000004    2012-12-20  2099-12-31  NULL\n```\n"}}
{"actor":{"display_login":"cgreich"}}