{"action":"opened","number":15,"pull_request":{"url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/pulls/15","id":225661561,"node_id":"MDExOlB1bGxSZXF1ZXN0MjI1NjYxNTYx","html_url":"https://github.com/c4ra/kaken_parse_grants_masterxml/pull/15","diff_url":"https://github.com/c4ra/kaken_parse_grants_masterxml/pull/15.diff","patch_url":"https://github.com/c4ra/kaken_parse_grants_masterxml/pull/15.patch","issue_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/issues/15","number":15,"state":"open","locked":false,"title":"Update parse_grantaward_field.ipynb for kaken5","user":{"login":"hiraikatsuyuki","id":32083298,"node_id":"MDQ6VXNlcjMyMDgzMjk4","avatar_url":"https://avatars2.githubusercontent.com/u/32083298?v=4","gravatar_id":"","url":"https://api.github.com/users/hiraikatsuyuki","html_url":"https://github.com/hiraikatsuyuki","followers_url":"https://api.github.com/users/hiraikatsuyuki/followers","following_url":"https://api.github.com/users/hiraikatsuyuki/following{/other_user}","gists_url":"https://api.github.com/users/hiraikatsuyuki/gists{/gist_id}","starred_url":"https://api.github.com/users/hiraikatsuyuki/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hiraikatsuyuki/subscriptions","organizations_url":"https://api.github.com/users/hiraikatsuyuki/orgs","repos_url":"https://api.github.com/users/hiraikatsuyuki/repos","events_url":"https://api.github.com/users/hiraikatsuyuki/events{/privacy}","received_events_url":"https://api.github.com/users/hiraikatsuyuki/received_events","type":"User","site_admin":false},"body":"科研費分析ツールKAKEN5のために、grantaward_fieldテーブルに若手Bの複数細目選択課題を区別するsaimokusentakusuu（細目選択数）のカラムを追加します。\r\n\r\nほんとは、複数細目選択課題のみ課題番号が書いてあるテーブルを作って、KAKEN5側でSQLを書くときにOUTER JOINするほうがテーブルの設計的には美しいと思うのですが、目先のスピード重視と、正しいか間違っているかというと間違ってはいないので、こういうコードになっています。いつか時間ができたときに修正するということで、この場はこれでいきたいと思います。","created_at":"2018-10-25T08:10:57Z","updated_at":"2018-10-25T08:10:57Z","closed_at":null,"merged_at":null,"merge_commit_sha":null,"assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/pulls/15/commits","review_comments_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/pulls/15/comments","review_comment_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/pulls/comments{/number}","comments_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/issues/15/comments","statuses_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/statuses/eff251536ac4aee7cd3c6d1053f554bcb1e96745","head":{"label":"c4ra:forkaken5-1025","ref":"forkaken5-1025","sha":"eff251536ac4aee7cd3c6d1053f554bcb1e96745","user":{"login":"c4ra","id":40521796,"node_id":"MDEyOk9yZ2FuaXphdGlvbjQwNTIxNzk2","avatar_url":"https://avatars1.githubusercontent.com/u/40521796?v=4","gravatar_id":"","url":"https://api.github.com/users/c4ra","html_url":"https://github.com/c4ra","followers_url":"https://api.github.com/users/c4ra/followers","following_url":"https://api.github.com/users/c4ra/following{/other_user}","gists_url":"https://api.github.com/users/c4ra/gists{/gist_id}","starred_url":"https://api.github.com/users/c4ra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/c4ra/subscriptions","organizations_url":"https://api.github.com/users/c4ra/orgs","repos_url":"https://api.github.com/users/c4ra/repos","events_url":"https://api.github.com/users/c4ra/events{/privacy}","received_events_url":"https://api.github.com/users/c4ra/received_events","type":"Organization","site_admin":false},"repo":{"id":138627624,"node_id":"MDEwOlJlcG9zaXRvcnkxMzg2Mjc2MjQ=","name":"kaken_parse_grants_masterxml","full_name":"c4ra/kaken_parse_grants_masterxml","private":false,"owner":{"login":"c4ra","id":40521796,"node_id":"MDEyOk9yZ2FuaXphdGlvbjQwNTIxNzk2","avatar_url":"https://avatars1.githubusercontent.com/u/40521796?v=4","gravatar_id":"","url":"https://api.github.com/users/c4ra","html_url":"https://github.com/c4ra","followers_url":"https://api.github.com/users/c4ra/followers","following_url":"https://api.github.com/users/c4ra/following{/other_user}","gists_url":"https://api.github.com/users/c4ra/gists{/gist_id}","starred_url":"https://api.github.com/users/c4ra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/c4ra/subscriptions","organizations_url":"https://api.github.com/users/c4ra/orgs","repos_url":"https://api.github.com/users/c4ra/repos","events_url":"https://api.github.com/users/c4ra/events{/privacy}","received_events_url":"https://api.github.com/users/c4ra/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/c4ra/kaken_parse_grants_masterxml","description":"KAKENデータベースからXMLファイルをダウンロードして、課題ごとに必要な項目をローカルのデータベースに保存します。","fork":false,"url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml","forks_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/forks","keys_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/keys{/key_id}","collaborators_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/teams","hooks_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/hooks","issue_events_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/issues/events{/number}","events_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/events","assignees_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/assignees{/user}","branches_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/branches{/branch}","tags_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/tags","blobs_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/git/refs{/sha}","trees_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/git/trees{/sha}","statuses_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/statuses/{sha}","languages_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/languages","stargazers_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/stargazers","contributors_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/contributors","subscribers_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/subscribers","subscription_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/subscription","commits_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/commits{/sha}","git_commits_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/git/commits{/sha}","comments_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/comments{/number}","issue_comment_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/issues/comments{/number}","contents_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/contents/{+path}","compare_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/compare/{base}...{head}","merges_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/merges","archive_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/downloads","issues_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/issues{/number}","pulls_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/pulls{/number}","milestones_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/milestones{/number}","notifications_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/labels{/name}","releases_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/releases{/id}","deployments_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/deployments","created_at":"2018-06-25T17:24:16Z","updated_at":"2018-10-25T06:55:12Z","pushed_at":"2018-10-25T08:06:44Z","git_url":"git://github.com/c4ra/kaken_parse_grants_masterxml.git","ssh_url":"git@github.com:c4ra/kaken_parse_grants_masterxml.git","clone_url":"https://github.com/c4ra/kaken_parse_grants_masterxml.git","svn_url":"https://github.com/c4ra/kaken_parse_grants_masterxml","homepage":"https://sites.google.com/view/c4ra/","size":156,"stargazers_count":3,"watchers_count":3,"language":"Jupyter Notebook","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":2,"license":{"key":"gpl-3.0","name":"GNU General Public License v3.0","spdx_id":"GPL-3.0","url":"https://api.github.com/licenses/gpl-3.0","node_id":"MDc6TGljZW5zZTk="},"forks":0,"open_issues":2,"watchers":3,"default_branch":"master"}},"base":{"label":"c4ra:master","ref":"master","sha":"8ee45e00c5d0e4cb3658e0db5d7f6d944a755feb","user":{"login":"c4ra","id":40521796,"node_id":"MDEyOk9yZ2FuaXphdGlvbjQwNTIxNzk2","avatar_url":"https://avatars1.githubusercontent.com/u/40521796?v=4","gravatar_id":"","url":"https://api.github.com/users/c4ra","html_url":"https://github.com/c4ra","followers_url":"https://api.github.com/users/c4ra/followers","following_url":"https://api.github.com/users/c4ra/following{/other_user}","gists_url":"https://api.github.com/users/c4ra/gists{/gist_id}","starred_url":"https://api.github.com/users/c4ra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/c4ra/subscriptions","organizations_url":"https://api.github.com/users/c4ra/orgs","repos_url":"https://api.github.com/users/c4ra/repos","events_url":"https://api.github.com/users/c4ra/events{/privacy}","received_events_url":"https://api.github.com/users/c4ra/received_events","type":"Organization","site_admin":false},"repo":{"id":138627624,"node_id":"MDEwOlJlcG9zaXRvcnkxMzg2Mjc2MjQ=","name":"kaken_parse_grants_masterxml","full_name":"c4ra/kaken_parse_grants_masterxml","private":false,"owner":{"login":"c4ra","id":40521796,"node_id":"MDEyOk9yZ2FuaXphdGlvbjQwNTIxNzk2","avatar_url":"https://avatars1.githubusercontent.com/u/40521796?v=4","gravatar_id":"","url":"https://api.github.com/users/c4ra","html_url":"https://github.com/c4ra","followers_url":"https://api.github.com/users/c4ra/followers","following_url":"https://api.github.com/users/c4ra/following{/other_user}","gists_url":"https://api.github.com/users/c4ra/gists{/gist_id}","starred_url":"https://api.github.com/users/c4ra/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/c4ra/subscriptions","organizations_url":"https://api.github.com/users/c4ra/orgs","repos_url":"https://api.github.com/users/c4ra/repos","events_url":"https://api.github.com/users/c4ra/events{/privacy}","received_events_url":"https://api.github.com/users/c4ra/received_events","type":"Organization","site_admin":false},"html_url":"https://github.com/c4ra/kaken_parse_grants_masterxml","description":"KAKENデータベースからXMLファイルをダウンロードして、課題ごとに必要な項目をローカルのデータベースに保存します。","fork":false,"url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml","forks_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/forks","keys_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/keys{/key_id}","collaborators_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/teams","hooks_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/hooks","issue_events_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/issues/events{/number}","events_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/events","assignees_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/assignees{/user}","branches_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/branches{/branch}","tags_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/tags","blobs_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/git/refs{/sha}","trees_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/git/trees{/sha}","statuses_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/statuses/{sha}","languages_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/languages","stargazers_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/stargazers","contributors_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/contributors","subscribers_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/subscribers","subscription_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/subscription","commits_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/commits{/sha}","git_commits_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/git/commits{/sha}","comments_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/comments{/number}","issue_comment_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/issues/comments{/number}","contents_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/contents/{+path}","compare_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/compare/{base}...{head}","merges_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/merges","archive_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/downloads","issues_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/issues{/number}","pulls_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/pulls{/number}","milestones_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/milestones{/number}","notifications_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/labels{/name}","releases_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/releases{/id}","deployments_url":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/deployments","created_at":"2018-06-25T17:24:16Z","updated_at":"2018-10-25T06:55:12Z","pushed_at":"2018-10-25T08:06:44Z","git_url":"git://github.com/c4ra/kaken_parse_grants_masterxml.git","ssh_url":"git@github.com:c4ra/kaken_parse_grants_masterxml.git","clone_url":"https://github.com/c4ra/kaken_parse_grants_masterxml.git","svn_url":"https://github.com/c4ra/kaken_parse_grants_masterxml","homepage":"https://sites.google.com/view/c4ra/","size":156,"stargazers_count":3,"watchers_count":3,"language":"Jupyter Notebook","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":2,"license":{"key":"gpl-3.0","name":"GNU General Public License v3.0","spdx_id":"GPL-3.0","url":"https://api.github.com/licenses/gpl-3.0","node_id":"MDc6TGljZW5zZTk="},"forks":0,"open_issues":2,"watchers":3,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/pulls/15"},"html":{"href":"https://github.com/c4ra/kaken_parse_grants_masterxml/pull/15"},"issue":{"href":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/issues/15"},"comments":{"href":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/issues/15/comments"},"review_comments":{"href":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/pulls/15/comments"},"review_comment":{"href":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/pulls/15/commits"},"statuses":{"href":"https://api.github.com/repos/c4ra/kaken_parse_grants_masterxml/statuses/eff251536ac4aee7cd3c6d1053f554bcb1e96745"}},"author_association":"CONTRIBUTOR","merged":false,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":null,"comments":0,"review_comments":0,"maintainer_can_modify":false,"commits":1,"additions":1,"deletions":47,"changed_files":1}}
{"actor":{"display_login":"hiraikatsuyuki"}}