{"action":"created","issue":{"url":"https://api.github.com/repos/etalab/ban-data/issues/9","labels_url":"https://api.github.com/repos/etalab/ban-data/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/etalab/ban-data/issues/9/comments","events_url":"https://api.github.com/repos/etalab/ban-data/issues/9/events","html_url":"https://github.com/etalab/ban-data/issues/9","id":62933547,"number":9,"title":"Version du COG de l'INSEE","user":{"login":"cquest","id":1202668,"avatar_url":"https://avatars.githubusercontent.com/u/1202668?v=3","gravatar_id":"","url":"https://api.github.com/users/cquest","html_url":"https://github.com/cquest","followers_url":"https://api.github.com/users/cquest/followers","following_url":"https://api.github.com/users/cquest/following{/other_user}","gists_url":"https://api.github.com/users/cquest/gists{/gist_id}","starred_url":"https://api.github.com/users/cquest/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cquest/subscriptions","organizations_url":"https://api.github.com/users/cquest/orgs","repos_url":"https://api.github.com/users/cquest/repos","events_url":"https://api.github.com/users/cquest/events{/privacy}","received_events_url":"https://api.github.com/users/cquest/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-03-19T09:50:53Z","updated_at":"2015-04-03T12:33:12Z","closed_at":null,"body":"Quelle est la version du COG de l'INSEE utilisé ?"},"comment":{"url":"https://api.github.com/repos/etalab/ban-data/issues/comments/89274997","html_url":"https://github.com/etalab/ban-data/issues/9#issuecomment-89274997","issue_url":"https://api.github.com/repos/etalab/ban-data/issues/9","id":89274997,"user":{"login":"cquest","id":1202668,"avatar_url":"https://avatars.githubusercontent.com/u/1202668?v=3","gravatar_id":"","url":"https://api.github.com/users/cquest","html_url":"https://github.com/cquest","followers_url":"https://api.github.com/users/cquest/followers","following_url":"https://api.github.com/users/cquest/following{/other_user}","gists_url":"https://api.github.com/users/cquest/gists{/gist_id}","starred_url":"https://api.github.com/users/cquest/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cquest/subscriptions","organizations_url":"https://api.github.com/users/cquest/orgs","repos_url":"https://api.github.com/users/cquest/repos","events_url":"https://api.github.com/users/cquest/events{/privacy}","received_events_url":"https://api.github.com/users/cquest/received_events","type":"User","site_admin":false},"created_at":"2015-04-03T12:33:12Z","updated_at":"2015-04-03T12:33:12Z","body":"Oups... désolé pour la requête qui mélangeait les codes restants et ceux disparus depuis le 1/1/2015.\r\n\r\nselect code_insee, nom_commune, count(*) from ban_all where code_insee~'14178|25034|28069|38024|60417|61031|61109|61177|61223|61249|61377|61410|61417|61511|61513|69221|71138|72069|72162|72207|72258|72318|73264|77166' group by 1,2;\r\n\r\nretourne 1 seule adresse (ADRNIVX_0000000273006377) sur l'ancienne commune de Roullée (72258), on y est presque !\r\n\r\nAttention, 71578 (Clux-Villeneuve) est une nouvelle commune, je l'ai donc retirée de la requête."}}