{"action":"created","comment":{"url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/pulls/comments/63108236","id":63108236,"diff_hunk":"@@ -20,6 +21,25 @@ chi_pconcepts=schema.table_name\n chi_pcounts=schema.table_name\n chi_pats=schema.table_name\n \n+; SQL snippet that says which patterns in the ontology table correspond to \n+; branch nodes (folder nodes) of interest\n+; 'ICD9:___' and 'ICD9:___._' match ICD9 codes down to the first four digits \n+; (5th digit gets too granular and sparse). In UTHSCSA's i2b2, all '[_____]%' \n+; are drug categories (yours is likely different). In UTHSCSA's i2b2, \n+; procedure branch nodes have paths that end in '\\A________\\' whereas leaf \n+; nodes lack the leading 'A'. Your site is likely different.\n+chi_branchnodes=c_basecode like 'ICD9:___' or c_basecode like 'ICD9:___._' or c_name like '[_____]%' or c_fullname like '\\i2b2\\Procedures\\PRC\\Meta%\\A________\\'\n+\n+; SQL snippet that applies to further limit all the above results, probably not \n+; very site-specific. The c_totalnum restriction is to avoid the long tail of \n+; branch nodes too sparsely populated to be meaningfully interpreted anyway. \n+; The c_visualattributes explicitly filters for branch nodes (active, hidden,\n+; or inactive we don't care-- this is data MINING)\n+chi_allbranchnodes=c_totalnum > 10 and c_visualattributes like 'F%'\n+\n+; The name of the ontology table in metaschema to be used to find branch nodes\n+chi_termtable=i2b2\n+\n schema=i2b2demodata\n metaschema=i2b2metadata\n ","path":"chi2/config.ini.example","position":33,"original_position":33,"commit_id":"39f54b6ba65f7dcc2ecd84748dd222f7bb2c0022","original_commit_id":"39f54b6ba65f7dcc2ecd84748dd222f7bb2c0022","user":{"login":"bokov","id":5765730,"avatar_url":"https://avatars.githubusercontent.com/u/5765730?v=3","gravatar_id":"","url":"https://api.github.com/users/bokov","html_url":"https://github.com/bokov","followers_url":"https://api.github.com/users/bokov/followers","following_url":"https://api.github.com/users/bokov/following{/other_user}","gists_url":"https://api.github.com/users/bokov/gists{/gist_id}","starred_url":"https://api.github.com/users/bokov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bokov/subscriptions","organizations_url":"https://api.github.com/users/bokov/orgs","repos_url":"https://api.github.com/users/bokov/repos","events_url":"https://api.github.com/users/bokov/events{/privacy}","received_events_url":"https://api.github.com/users/bokov/received_events","type":"User","site_admin":false},"body":"TO test the effect of this on UI, try running with JSON option. Maybe make rollup a command-line flag?\r\n","created_at":"2016-05-12T22:30:05Z","updated_at":"2016-05-12T22:30:05Z","html_url":"https://github.com/UTHSCSA-CIRD/chinotype/pull/2#discussion_r63108236","pull_request_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/pulls/2","_links":{"self":{"href":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/pulls/comments/63108236"},"html":{"href":"https://github.com/UTHSCSA-CIRD/chinotype/pull/2#discussion_r63108236"},"pull_request":{"href":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/pulls/2"}}},"pull_request":{"url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/pulls/2","id":69916517,"html_url":"https://github.com/UTHSCSA-CIRD/chinotype/pull/2","diff_url":"https://github.com/UTHSCSA-CIRD/chinotype/pull/2.diff","patch_url":"https://github.com/UTHSCSA-CIRD/chinotype/pull/2.patch","issue_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/issues/2","number":2,"state":"open","locked":false,"title":"Afb rollup proto","user":{"login":"bokov","id":5765730,"avatar_url":"https://avatars.githubusercontent.com/u/5765730?v=3","gravatar_id":"","url":"https://api.github.com/users/bokov","html_url":"https://github.com/bokov","followers_url":"https://api.github.com/users/bokov/followers","following_url":"https://api.github.com/users/bokov/following{/other_user}","gists_url":"https://api.github.com/users/bokov/gists{/gist_id}","starred_url":"https://api.github.com/users/bokov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bokov/subscriptions","organizations_url":"https://api.github.com/users/bokov/orgs","repos_url":"https://api.github.com/users/bokov/repos","events_url":"https://api.github.com/users/bokov/events{/privacy}","received_events_url":"https://api.github.com/users/bokov/received_events","type":"User","site_admin":false},"body":"Second try, pull request to int. Rollups of ICD9, CPT, and Meds.","created_at":"2016-05-12T22:20:32Z","updated_at":"2016-05-12T22:30:05Z","closed_at":null,"merged_at":null,"merge_commit_sha":"d28e63e61f3b666992f4621c3d384afb5c34f17c","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/pulls/2/commits","review_comments_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/pulls/2/comments","review_comment_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/pulls/comments{/number}","comments_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/issues/2/comments","statuses_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/statuses/39f54b6ba65f7dcc2ecd84748dd222f7bb2c0022","head":{"label":"UTHSCSA-CIRD:afb_rollup_proto","ref":"afb_rollup_proto","sha":"39f54b6ba65f7dcc2ecd84748dd222f7bb2c0022","user":{"login":"UTHSCSA-CIRD","id":7718072,"avatar_url":"https://avatars.githubusercontent.com/u/7718072?v=3","gravatar_id":"","url":"https://api.github.com/users/UTHSCSA-CIRD","html_url":"https://github.com/UTHSCSA-CIRD","followers_url":"https://api.github.com/users/UTHSCSA-CIRD/followers","following_url":"https://api.github.com/users/UTHSCSA-CIRD/following{/other_user}","gists_url":"https://api.github.com/users/UTHSCSA-CIRD/gists{/gist_id}","starred_url":"https://api.github.com/users/UTHSCSA-CIRD/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/UTHSCSA-CIRD/subscriptions","organizations_url":"https://api.github.com/users/UTHSCSA-CIRD/orgs","repos_url":"https://api.github.com/users/UTHSCSA-CIRD/repos","events_url":"https://api.github.com/users/UTHSCSA-CIRD/events{/privacy}","received_events_url":"https://api.github.com/users/UTHSCSA-CIRD/received_events","type":"Organization","site_admin":false},"repo":{"id":39227801,"name":"chinotype","full_name":"UTHSCSA-CIRD/chinotype","owner":{"login":"UTHSCSA-CIRD","id":7718072,"avatar_url":"https://avatars.githubusercontent.com/u/7718072?v=3","gravatar_id":"","url":"https://api.github.com/users/UTHSCSA-CIRD","html_url":"https://github.com/UTHSCSA-CIRD","followers_url":"https://api.github.com/users/UTHSCSA-CIRD/followers","following_url":"https://api.github.com/users/UTHSCSA-CIRD/following{/other_user}","gists_url":"https://api.github.com/users/UTHSCSA-CIRD/gists{/gist_id}","starred_url":"https://api.github.com/users/UTHSCSA-CIRD/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/UTHSCSA-CIRD/subscriptions","organizations_url":"https://api.github.com/users/UTHSCSA-CIRD/orgs","repos_url":"https://api.github.com/users/UTHSCSA-CIRD/repos","events_url":"https://api.github.com/users/UTHSCSA-CIRD/events{/privacy}","received_events_url":"https://api.github.com/users/UTHSCSA-CIRD/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/UTHSCSA-CIRD/chinotype","description":"General purpose script for looking for over and under represented EHR facts in an i2b2 patient-set. Can be used for finding healthcare outcomes disparities, comorbidities, and who knows what else. The name is a portmanteau of Chi-squared and phenotype.","fork":false,"url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype","forks_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/forks","keys_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/keys{/key_id}","collaborators_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/teams","hooks_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/hooks","issue_events_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/issues/events{/number}","events_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/events","assignees_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/assignees{/user}","branches_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/branches{/branch}","tags_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/tags","blobs_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/git/refs{/sha}","trees_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/git/trees{/sha}","statuses_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/statuses/{sha}","languages_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/languages","stargazers_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/stargazers","contributors_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/contributors","subscribers_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/subscribers","subscription_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/subscription","commits_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/commits{/sha}","git_commits_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/git/commits{/sha}","comments_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/comments{/number}","issue_comment_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/issues/comments{/number}","contents_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/contents/{+path}","compare_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/compare/{base}...{head}","merges_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/merges","archive_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/downloads","issues_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/issues{/number}","pulls_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/pulls{/number}","milestones_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/milestones{/number}","notifications_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/labels{/name}","releases_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/releases{/id}","deployments_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/deployments","created_at":"2015-07-17T01:00:41Z","updated_at":"2016-01-26T18:34:53Z","pushed_at":"2016-05-12T22:20:33Z","git_url":"git://github.com/UTHSCSA-CIRD/chinotype.git","ssh_url":"git@github.com:UTHSCSA-CIRD/chinotype.git","clone_url":"https://github.com/UTHSCSA-CIRD/chinotype.git","svn_url":"https://github.com/UTHSCSA-CIRD/chinotype","homepage":"","size":175,"stargazers_count":2,"watchers_count":2,"language":"Python","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":0,"mirror_url":null,"open_issues_count":1,"forks":0,"open_issues":1,"watchers":2,"default_branch":"master"}},"base":{"label":"UTHSCSA-CIRD:integration","ref":"integration","sha":"4d0a3665c035db96ccd0a92bce47ed218c60de45","user":{"login":"UTHSCSA-CIRD","id":7718072,"avatar_url":"https://avatars.githubusercontent.com/u/7718072?v=3","gravatar_id":"","url":"https://api.github.com/users/UTHSCSA-CIRD","html_url":"https://github.com/UTHSCSA-CIRD","followers_url":"https://api.github.com/users/UTHSCSA-CIRD/followers","following_url":"https://api.github.com/users/UTHSCSA-CIRD/following{/other_user}","gists_url":"https://api.github.com/users/UTHSCSA-CIRD/gists{/gist_id}","starred_url":"https://api.github.com/users/UTHSCSA-CIRD/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/UTHSCSA-CIRD/subscriptions","organizations_url":"https://api.github.com/users/UTHSCSA-CIRD/orgs","repos_url":"https://api.github.com/users/UTHSCSA-CIRD/repos","events_url":"https://api.github.com/users/UTHSCSA-CIRD/events{/privacy}","received_events_url":"https://api.github.com/users/UTHSCSA-CIRD/received_events","type":"Organization","site_admin":false},"repo":{"id":39227801,"name":"chinotype","full_name":"UTHSCSA-CIRD/chinotype","owner":{"login":"UTHSCSA-CIRD","id":7718072,"avatar_url":"https://avatars.githubusercontent.com/u/7718072?v=3","gravatar_id":"","url":"https://api.github.com/users/UTHSCSA-CIRD","html_url":"https://github.com/UTHSCSA-CIRD","followers_url":"https://api.github.com/users/UTHSCSA-CIRD/followers","following_url":"https://api.github.com/users/UTHSCSA-CIRD/following{/other_user}","gists_url":"https://api.github.com/users/UTHSCSA-CIRD/gists{/gist_id}","starred_url":"https://api.github.com/users/UTHSCSA-CIRD/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/UTHSCSA-CIRD/subscriptions","organizations_url":"https://api.github.com/users/UTHSCSA-CIRD/orgs","repos_url":"https://api.github.com/users/UTHSCSA-CIRD/repos","events_url":"https://api.github.com/users/UTHSCSA-CIRD/events{/privacy}","received_events_url":"https://api.github.com/users/UTHSCSA-CIRD/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/UTHSCSA-CIRD/chinotype","description":"General purpose script for looking for over and under represented EHR facts in an i2b2 patient-set. Can be used for finding healthcare outcomes disparities, comorbidities, and who knows what else. The name is a portmanteau of Chi-squared and phenotype.","fork":false,"url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype","forks_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/forks","keys_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/keys{/key_id}","collaborators_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/teams","hooks_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/hooks","issue_events_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/issues/events{/number}","events_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/events","assignees_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/assignees{/user}","branches_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/branches{/branch}","tags_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/tags","blobs_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/git/refs{/sha}","trees_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/git/trees{/sha}","statuses_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/statuses/{sha}","languages_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/languages","stargazers_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/stargazers","contributors_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/contributors","subscribers_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/subscribers","subscription_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/subscription","commits_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/commits{/sha}","git_commits_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/git/commits{/sha}","comments_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/comments{/number}","issue_comment_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/issues/comments{/number}","contents_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/contents/{+path}","compare_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/compare/{base}...{head}","merges_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/merges","archive_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/downloads","issues_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/issues{/number}","pulls_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/pulls{/number}","milestones_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/milestones{/number}","notifications_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/labels{/name}","releases_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/releases{/id}","deployments_url":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/deployments","created_at":"2015-07-17T01:00:41Z","updated_at":"2016-01-26T18:34:53Z","pushed_at":"2016-05-12T22:20:33Z","git_url":"git://github.com/UTHSCSA-CIRD/chinotype.git","ssh_url":"git@github.com:UTHSCSA-CIRD/chinotype.git","clone_url":"https://github.com/UTHSCSA-CIRD/chinotype.git","svn_url":"https://github.com/UTHSCSA-CIRD/chinotype","homepage":"","size":175,"stargazers_count":2,"watchers_count":2,"language":"Python","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":0,"mirror_url":null,"open_issues_count":1,"forks":0,"open_issues":1,"watchers":2,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/pulls/2"},"html":{"href":"https://github.com/UTHSCSA-CIRD/chinotype/pull/2"},"issue":{"href":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/issues/2"},"comments":{"href":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/issues/2/comments"},"review_comments":{"href":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/pulls/2/comments"},"review_comment":{"href":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/pulls/2/commits"},"statuses":{"href":"https://api.github.com/repos/UTHSCSA-CIRD/chinotype/statuses/39f54b6ba65f7dcc2ecd84748dd222f7bb2c0022"}}}}