{"action":"reopened","issue":{"url":"https://api.github.com/repos/crowdcover/congo-mines-app/issues/31","labels_url":"https://api.github.com/repos/crowdcover/congo-mines-app/issues/31/labels{/name}","comments_url":"https://api.github.com/repos/crowdcover/congo-mines-app/issues/31/comments","events_url":"https://api.github.com/repos/crowdcover/congo-mines-app/issues/31/events","html_url":"https://github.com/crowdcover/congo-mines-app/issues/31","id":74096028,"number":31,"title":"Incorrect Categories","user":{"login":"jameslaneconkling","id":4389360,"avatar_url":"https://avatars.githubusercontent.com/u/4389360?v=3","gravatar_id":"","url":"https://api.github.com/users/jameslaneconkling","html_url":"https://github.com/jameslaneconkling","followers_url":"https://api.github.com/users/jameslaneconkling/followers","following_url":"https://api.github.com/users/jameslaneconkling/following{/other_user}","gists_url":"https://api.github.com/users/jameslaneconkling/gists{/gist_id}","starred_url":"https://api.github.com/users/jameslaneconkling/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jameslaneconkling/subscriptions","organizations_url":"https://api.github.com/users/jameslaneconkling/orgs","repos_url":"https://api.github.com/users/jameslaneconkling/repos","events_url":"https://api.github.com/users/jameslaneconkling/events{/privacy}","received_events_url":"https://api.github.com/users/jameslaneconkling/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/crowdcover/congo-mines-app/labels/data","name":"data","color":"eb6420"},{"url":"https://api.github.com/repos/crowdcover/congo-mines-app/labels/priority","name":"priority","color":"5319e7"}],"state":"open","locked":false,"assignee":{"login":"markmcdonald51","id":39400,"avatar_url":"https://avatars.githubusercontent.com/u/39400?v=3","gravatar_id":"","url":"https://api.github.com/users/markmcdonald51","html_url":"https://github.com/markmcdonald51","followers_url":"https://api.github.com/users/markmcdonald51/followers","following_url":"https://api.github.com/users/markmcdonald51/following{/other_user}","gists_url":"https://api.github.com/users/markmcdonald51/gists{/gist_id}","starred_url":"https://api.github.com/users/markmcdonald51/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/markmcdonald51/subscriptions","organizations_url":"https://api.github.com/users/markmcdonald51/orgs","repos_url":"https://api.github.com/users/markmcdonald51/repos","events_url":"https://api.github.com/users/markmcdonald51/events{/privacy}","received_events_url":"https://api.github.com/users/markmcdonald51/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/crowdcover/congo-mines-app/milestones/3","html_url":"https://github.com/crowdcover/congo-mines-app/milestones/data%20input","labels_url":"https://api.github.com/repos/crowdcover/congo-mines-app/milestones/3/labels","id":1100807,"number":3,"title":"data input","description":"","creator":{"login":"jameslaneconkling","id":4389360,"avatar_url":"https://avatars.githubusercontent.com/u/4389360?v=3","gravatar_id":"","url":"https://api.github.com/users/jameslaneconkling","html_url":"https://github.com/jameslaneconkling","followers_url":"https://api.github.com/users/jameslaneconkling/followers","following_url":"https://api.github.com/users/jameslaneconkling/following{/other_user}","gists_url":"https://api.github.com/users/jameslaneconkling/gists{/gist_id}","starred_url":"https://api.github.com/users/jameslaneconkling/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jameslaneconkling/subscriptions","organizations_url":"https://api.github.com/users/jameslaneconkling/orgs","repos_url":"https://api.github.com/users/jameslaneconkling/repos","events_url":"https://api.github.com/users/jameslaneconkling/events{/privacy}","received_events_url":"https://api.github.com/users/jameslaneconkling/received_events","type":"User","site_admin":false},"open_issues":11,"closed_issues":21,"state":"open","created_at":"2015-05-07T19:26:05Z","updated_at":"2015-05-27T18:35:33Z","due_on":"2015-05-20T04:00:00Z","closed_at":null},"comments":2,"created_at":"2015-05-07T19:17:03Z","updated_at":"2015-05-27T18:35:33Z","closed_at":null,"body":"It looks like some categories missed the scrape, and as a result are showing as companies.\r\n\r\nThese should be added to the categories table and removed from the drc_companies table.\r\n\r\nFor a complete list of categories, see [site_categories.gdoc](https://docs.google.com/document/d/1QN-GcYBcfCC66-SiO5k2HtkHtPdeXeGBoISsiQQrSR0/edit)\r\n\r\nExample documents with miscategorized categories:\r\n* http://188.166.93.154/reports/656\r\n\r\n\r\nI've gone through the companies table and found the following entries that should be categories:\r\n* Revisitation Des Contrats Miniers\r\n* Budget\r\n* Rétrocession\r\n* Guides Et Manuels\r\n* Lois, Normes Et Règlements\r\n* Allocation Des Titres Miniers\r\n* Aperçu Du Secteur Minier\r\n* Emploi\r\n* Exploitation Et Exportation\r\n* Fiscalité Minière\r\n* Histoire Du Secteur Minier\r\n* Législation Minière\r\n* Mines Et Environnement\r\n* Secteur Artisanal\r\n* Recettes Du Secteur Minier\r\n* Gestion Des Entreprises étatiques\r\n* Transparence Des Industries Extractives\r\n* Géologie Et Exploration\r\n* Mines, Communautés Locales Et Droits Humains\r\n* Projets Minerais & Infrastructures\r\n* Traçabilité\r\n* Listes, Tableaux Et Statistiques\r\n* Contrats Et Avenants **(merge w/ Type de document: Contrats\r\n* Synthèses Et Résumés\r\n* Statuts Et Actes De Constitution\r\n* Documents D'entreprises Et Publications Boursières\r\n* Revision Du Code Minier\r\n\r\n\r\n\r\n\r\n"}}