{"action":"created","issue":{"url":"https://api.github.com/repos/iangow/wrds_pg/issues/22","repository_url":"https://api.github.com/repos/iangow/wrds_pg","labels_url":"https://api.github.com/repos/iangow/wrds_pg/issues/22/labels{/name}","comments_url":"https://api.github.com/repos/iangow/wrds_pg/issues/22/comments","events_url":"https://api.github.com/repos/iangow/wrds_pg/issues/22/events","html_url":"https://github.com/iangow/wrds_pg/issues/22","id":250446693,"number":22,"title":"Update audit data","user":{"login":"azakolyukina","id":16340409,"avatar_url":"https://avatars1.githubusercontent.com/u/16340409?v=4","gravatar_id":"","url":"https://api.github.com/users/azakolyukina","html_url":"https://github.com/azakolyukina","followers_url":"https://api.github.com/users/azakolyukina/followers","following_url":"https://api.github.com/users/azakolyukina/following{/other_user}","gists_url":"https://api.github.com/users/azakolyukina/gists{/gist_id}","starred_url":"https://api.github.com/users/azakolyukina/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/azakolyukina/subscriptions","organizations_url":"https://api.github.com/users/azakolyukina/orgs","repos_url":"https://api.github.com/users/azakolyukina/repos","events_url":"https://api.github.com/users/azakolyukina/events{/privacy}","received_events_url":"https://api.github.com/users/azakolyukina/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":21,"created_at":"2017-08-15T21:37:47Z","updated_at":"2017-09-06T18:41:30Z","closed_at":null,"author_association":"NONE","body":"@jingyujzhang (CC @iangow): \r\n\r\nCould you please fork this repository and update code for `audit` schema (see `audit` folder) and update data in `audit` schema on `aaz` machine for the following data:\r\n* Late filings in [AuditAnalytics - Non-timely Filer Information And Analysis](https://wrds-web.wharton.upenn.edu/wrds/ds/audit/nt/index.cfm?navId=2)\r\n* D&O change data in [AuditAnalytics - Director and Officer Changes](https://wrds-web.wharton.upenn.edu/wrds/ds/audit/diroffichange/index.cfm?navId=2)\r\n* Litigation [AuditAnalytics - Legal Case And Legal Parties](https://wrds-web.wharton.upenn.edu/wrds/ds/audit/auditlegal/index.cfm?navId=3)\r\n* Auditor changes [AuditAnalytics - Auditor Changes](https://wrds-web.wharton.upenn.edu/wrds/ds/audit/auditchange/index.cfm?navId=2)\r\n* Wells notices --- @azakolyukina ask Olya\r\n* Bankruptcy [AuditAnalytics - Bankruptcy Notification](https://wrds-web.wharton.upenn.edu/wrds/ds/audit/bankrupt/index.cfm?navId=3)\r\n* Internal control weaknesses [AuditAnalytics - SOX 302 Disclosure Controls](https://wrds-web.wharton.upenn.edu/wrds/ds/audit/auditsox302/index.cfm?navId=2)  and [AuditAnalytics - SOX 404 Internal Controls](https://wrds-web.wharton.upenn.edu/wrds/ds/audit/auditsox404/index.cfm?navId=2)\r\n\r\nSet ownership to `audit`"},"comment":{"url":"https://api.github.com/repos/iangow/wrds_pg/issues/comments/327576607","html_url":"https://github.com/iangow/wrds_pg/issues/22#issuecomment-327576607","issue_url":"https://api.github.com/repos/iangow/wrds_pg/issues/22","id":327576607,"user":{"login":"jingyujzhang","id":26939685,"avatar_url":"https://avatars3.githubusercontent.com/u/26939685?v=4","gravatar_id":"","url":"https://api.github.com/users/jingyujzhang","html_url":"https://github.com/jingyujzhang","followers_url":"https://api.github.com/users/jingyujzhang/followers","following_url":"https://api.github.com/users/jingyujzhang/following{/other_user}","gists_url":"https://api.github.com/users/jingyujzhang/gists{/gist_id}","starred_url":"https://api.github.com/users/jingyujzhang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jingyujzhang/subscriptions","organizations_url":"https://api.github.com/users/jingyujzhang/orgs","repos_url":"https://api.github.com/users/jingyujzhang/repos","events_url":"https://api.github.com/users/jingyujzhang/events{/privacy}","received_events_url":"https://api.github.com/users/jingyujzhang/received_events","type":"User","site_admin":false},"created_at":"2017-09-06T18:41:30Z","updated_at":"2017-09-06T18:41:30Z","author_association":"COLLABORATOR","body":"Sorry for that. I've got too many `wrds` repo in my local dir. I committed `update_audit.py` again. Running it takes some time.\r\n\r\nFor table `nt`, I deleted cols with `drop=\"matchfy: matchqu: priorfy: priorqu: http: nt: ac:\"` and this one works. So next I can just find ways to add back the these cols.\r\n\r\nThe `utf-8` version of `wrds_fetch.py` doesn't work for `nt`. Bytes like `0x92` exist in the file, these belong to `cp1252`. "}}
{"actor":{"display_login":"jingyujzhang"}}