{"action":"created","issue":{"url":"https://api.github.com/repos/elifesciences/data-pipeline/issues/13","repository_url":"https://api.github.com/repos/elifesciences/data-pipeline","labels_url":"https://api.github.com/repos/elifesciences/data-pipeline/issues/13/labels{/name}","comments_url":"https://api.github.com/repos/elifesciences/data-pipeline/issues/13/comments","events_url":"https://api.github.com/repos/elifesciences/data-pipeline/issues/13/events","html_url":"https://github.com/elifesciences/data-pipeline/issues/13","id":336563223,"node_id":"MDU6SXNzdWUzMzY1NjMyMjM=","number":13,"title":"Define CSV to demonstrate SCD2 (address, email, ...)","user":{"login":"de-code","id":1016473,"node_id":"MDQ6VXNlcjEwMTY0NzM=","avatar_url":"https://avatars0.githubusercontent.com/u/1016473?v=4","gravatar_id":"","url":"https://api.github.com/users/de-code","html_url":"https://github.com/de-code","followers_url":"https://api.github.com/users/de-code/followers","following_url":"https://api.github.com/users/de-code/following{/other_user}","gists_url":"https://api.github.com/users/de-code/gists{/gist_id}","starred_url":"https://api.github.com/users/de-code/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/de-code/subscriptions","organizations_url":"https://api.github.com/users/de-code/orgs","repos_url":"https://api.github.com/users/de-code/repos","events_url":"https://api.github.com/users/de-code/events{/privacy}","received_events_url":"https://api.github.com/users/de-code/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"MatBailie","id":5878517,"node_id":"MDQ6VXNlcjU4Nzg1MTc=","avatar_url":"https://avatars3.githubusercontent.com/u/5878517?v=4","gravatar_id":"","url":"https://api.github.com/users/MatBailie","html_url":"https://github.com/MatBailie","followers_url":"https://api.github.com/users/MatBailie/followers","following_url":"https://api.github.com/users/MatBailie/following{/other_user}","gists_url":"https://api.github.com/users/MatBailie/gists{/gist_id}","starred_url":"https://api.github.com/users/MatBailie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MatBailie/subscriptions","organizations_url":"https://api.github.com/users/MatBailie/orgs","repos_url":"https://api.github.com/users/MatBailie/repos","events_url":"https://api.github.com/users/MatBailie/events{/privacy}","received_events_url":"https://api.github.com/users/MatBailie/received_events","type":"User","site_admin":false},"assignees":[{"login":"MatBailie","id":5878517,"node_id":"MDQ6VXNlcjU4Nzg1MTc=","avatar_url":"https://avatars3.githubusercontent.com/u/5878517?v=4","gravatar_id":"","url":"https://api.github.com/users/MatBailie","html_url":"https://github.com/MatBailie","followers_url":"https://api.github.com/users/MatBailie/followers","following_url":"https://api.github.com/users/MatBailie/following{/other_user}","gists_url":"https://api.github.com/users/MatBailie/gists{/gist_id}","starred_url":"https://api.github.com/users/MatBailie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MatBailie/subscriptions","organizations_url":"https://api.github.com/users/MatBailie/orgs","repos_url":"https://api.github.com/users/MatBailie/repos","events_url":"https://api.github.com/users/MatBailie/events{/privacy}","received_events_url":"https://api.github.com/users/MatBailie/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/elifesciences/data-pipeline/milestones/2","html_url":"https://github.com/elifesciences/data-pipeline/milestone/2","labels_url":"https://api.github.com/repos/elifesciences/data-pipeline/milestones/2/labels","id":3462632,"node_id":"MDk6TWlsZXN0b25lMzQ2MjYzMg==","number":2,"title":"Senior Editor Workloads report","description":"Report to show:\r\n\r\n* number of decisions of the last three months (first version of the initial submission)\r\n* percentage of rejected over the last three months\r\n* the chart should only show research types\r\n* the report sorts senior editor by number of decisions made in the last month (descending)","creator":{"login":"de-code","id":1016473,"node_id":"MDQ6VXNlcjEwMTY0NzM=","avatar_url":"https://avatars0.githubusercontent.com/u/1016473?v=4","gravatar_id":"","url":"https://api.github.com/users/de-code","html_url":"https://github.com/de-code","followers_url":"https://api.github.com/users/de-code/followers","following_url":"https://api.github.com/users/de-code/following{/other_user}","gists_url":"https://api.github.com/users/de-code/gists{/gist_id}","starred_url":"https://api.github.com/users/de-code/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/de-code/subscriptions","organizations_url":"https://api.github.com/users/de-code/orgs","repos_url":"https://api.github.com/users/de-code/repos","events_url":"https://api.github.com/users/de-code/events{/privacy}","received_events_url":"https://api.github.com/users/de-code/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":3,"state":"open","created_at":"2018-06-29T13:55:44Z","updated_at":"2018-06-29T14:19:00Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2018-06-28T10:26:09Z","updated_at":"2018-06-29T15:01:23Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"Propose CSV for person data to demonstrate SCD2.\r\n\r\nProposal so far:\r\n\r\n<created_date>_persons.csv\r\n\r\n- create_date\r\n- zip_name\r\n- xml_file_name\r\n- person_id\r\n- status\r\n- name fields: title, first_name, middle_name, last_name\r\n- email\r\n- secondary_email\r\n- profile_modified_date\r\n\r\n<created_date>_person_addresses.csv\r\n\r\n- create_date\r\n- zip_name\r\n- xml_file_name\r\n- person_id\r\n- address_start_date\r\n- address_end_date\r\n- address_type\r\n- address_county\r\n- address_city\r\n- address_state_province\r\n- address_zip_postal_code\r\n- address_department\r\n- address_street_address_1\r\n- address_street_address_2\r\n\r\n<created_date>_person_roles.csv\r\n\r\n- create_date\r\n- zip_name\r\n- xml_file_name\r\n- person_id\r\n- role\r\n"},"comment":{"url":"https://api.github.com/repos/elifesciences/data-pipeline/issues/comments/401381446","html_url":"https://github.com/elifesciences/data-pipeline/issues/13#issuecomment-401381446","issue_url":"https://api.github.com/repos/elifesciences/data-pipeline/issues/13","id":401381446,"node_id":"MDEyOklzc3VlQ29tbWVudDQwMTM4MTQ0Ng==","user":{"login":"seanwiseman","id":30619751,"node_id":"MDQ6VXNlcjMwNjE5NzUx","avatar_url":"https://avatars2.githubusercontent.com/u/30619751?v=4","gravatar_id":"","url":"https://api.github.com/users/seanwiseman","html_url":"https://github.com/seanwiseman","followers_url":"https://api.github.com/users/seanwiseman/followers","following_url":"https://api.github.com/users/seanwiseman/following{/other_user}","gists_url":"https://api.github.com/users/seanwiseman/gists{/gist_id}","starred_url":"https://api.github.com/users/seanwiseman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/seanwiseman/subscriptions","organizations_url":"https://api.github.com/users/seanwiseman/orgs","repos_url":"https://api.github.com/users/seanwiseman/repos","events_url":"https://api.github.com/users/seanwiseman/events{/privacy}","received_events_url":"https://api.github.com/users/seanwiseman/received_events","type":"User","site_admin":false},"created_at":"2018-06-29T15:01:23Z","updated_at":"2018-06-29T15:01:23Z","author_association":"CONTRIBUTOR","body":"@de If a `person-id` is not present for a `person` should it be skipped?"}}
{"actor":{"display_login":"seanwiseman"}}