{"action":"created","issue":{"url":"https://api.github.com/repos/OHDSI/KnowledgeBase/issues/79","repository_url":"https://api.github.com/repos/OHDSI/KnowledgeBase","labels_url":"https://api.github.com/repos/OHDSI/KnowledgeBase/issues/79/labels{/name}","comments_url":"https://api.github.com/repos/OHDSI/KnowledgeBase/issues/79/comments","events_url":"https://api.github.com/repos/OHDSI/KnowledgeBase/issues/79/events","html_url":"https://github.com/OHDSI/KnowledgeBase/issues/79","id":135152226,"number":79,"title":"SPL/Evidence Mis-Assigning","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":2,"created_at":"2016-02-21T03:15:32Z","updated_at":"2016-02-21T16:25:02Z","closed_at":null,"body":"I was looking at this piece of evidence:\r\n```{SQL}\r\nSELECT *\r\nFROM DRUG_HOI_RELATIONSHIP dr\r\n                JOIN DRUG_HOI_EVIDENCE de\r\n                                ON dr.ID = de.DRUG_HOI_RELATIONSHIP\r\nWHERE dr.ID = '40164715-4219484'\r\n```\r\n\r\nWhich is for the combo drug \"Hydrocodone Bitartrate 7.5 MG / Ibuprofen 200 MG Oral Tablet\" and HOI “Suicide attempt”.  Suicide is associated to hydrocodone bitartrate not ibuprofen but because of how we deal with combo drugs I wasn’t worried at this point.  But I wanted to find the label.\r\n\r\nWhen I resolve the link out I get \r\nhttp://dbmi-icode-01.dbmi.pitt.edu/l/index.php?id=splicer-50961\r\n\r\nWhich resolves to:\r\n```{text}\r\nhttp://virtuoso.ohdsi.org:8890/sparql?default-graph-uri=&query=%23+drill+down+query+for+a+drug+and+HOI+in+the+SPLICER+ADRAnnotation+graph+joined+with+LinkedSPLs%0D%0APREFIX+ohdsi%3A%3Chttp%3A%2F%2Fpurl.org%2Fnet%2Fohdsi%23%3E%0D%0APREFIX+oa%3A%3Chttp%3A%2F%2Fwww.w3.org%2Fns%2Foa%23%3E%0D%0APREFIX+meddra%3A%3Chttp%3A%2F%2Fpurl.bioontology.org%2Fontology%2FMEDDRA%2F%3E%0D%0APREFIX+ncbit%3A+%3Chttp%3A%2F%2Fncicb.nci.nih.gov%2Fxml%2Fowl%2FEVS%2FThesaurus.owl%23%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+linkedspls_vocabulary%3A+%3Chttp%3A%2F%2Fbio2rdf.org%2Flinkedspls_vocabulary%3A%3E%0D%0A%0D%0ASELECT+*%0D%0AWHERE+{%0D%0A+GRAPH+%3Chttp%3A%2F%2Fpurl.org%2Fnet%2Fnlprepository%2Fohdsi-adr-splicer-poc%3E+{%0D%0A++%3Fan+a+ohdsi%3AADRAnnotation%3B%0D%0A+++oa%3AhasBody+%3Fbody%3B%0D%0A+++oa%3AhasTarget+%3Ftarget.%0D%0A%0D%0A+++%3Fbody+ohdsi%3AImedsDrug+ohdsi%3A40164715.%0D%0A+++%3Fbody+ohdsi%3AImedsHoi+ohdsi%3A36919236.%0D%0A%0D%0A+++%3Ftarget+oa%3AhasSource+%3FsourceURL.%0D%0A+++%3Ftarget+oa%3AhasSelector+%3Fselector.%0D%0A%0D%0A+++%3Fselector+linkedspls_vocabulary%3AsplSection+%3Chttp://www.hipaaspace.com/Medical_Billing/Coding/Logical.Observation.Identifiers.Names.and.Codes/34084-4%3E.%0D%0A++}%0D%0A+GRAPH+%3Chttp%3A%2F%2Fpurl.org%2Fnet%2Fnlprepository%2Fspl-core%3E+{%0D%0A++%3Fspl+a+ncbit%3ALabel%3B%0D%0A+++foaf%3Ahomepage+%3FsourceURL%3B%0D%0A+++%3Chttp://www.hipaaspace.com/Medical_Billing/Coding/Logical.Observation.Identifiers.Names.and.Codes/34084-4%3E+%3Ftext.%0D%0A+}%0D%0A}%0D%0A&format=HTML&timeout=0&debug=on\r\n```\r\n\r\nWhich I think is pointing me to this SPL:\r\nhttp://dailymed.nlm.nih.gov/dailymed/lookup.cfm?setid=c192f7bf-f38c-0f11-bd14-61f3e8e3bc28\r\n\r\nWhich is “BUPROPION HYDROCHLORIDE - bupropion hydrochloride tablet, film coated, extended release”.  Something got mis-assigned here."},"comment":{"url":"https://api.github.com/repos/OHDSI/KnowledgeBase/issues/comments/186854188","html_url":"https://github.com/OHDSI/KnowledgeBase/issues/79#issuecomment-186854188","issue_url":"https://api.github.com/repos/OHDSI/KnowledgeBase/issues/79","id":186854188,"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":"2016-02-21T16:25:02Z","updated_at":"2016-02-21T16:25:02Z","body":"@cgreich - I think it is on the LAERTES side not the Vocab.  "}}