Find clusters of politicians spending with companies owned by each others relatives

[Irio]

According to "ATO DA MESA Nº 43, DE 21/5/2009 Art. 4º § 13", no expense can be reimbursed if made with companies where the applicant (politician) is owner, partner or relative (maximum of third degree).

Politicians may know about this and have groups to "exchange expenses" to cheat the law. e.g. Politician A pays for Politician B's relatives; Politician B pays for Politician A's relatives.

[danielbdias]

Hi, guys ! Maybe one datasource which could help us is: http://proprietariosdobrasil.org.br/
In this site we have the relationship between companies and show who owns that companies.

Unfortunately, this site is offline today. =/ I will check again later or contact the owner of this website.

[thiagobrito]

Here we have tree situations:

1. The congressman spent the money on his own company.
   This case we just need to collect the CNPJ from the company, get the information from https://www.receitaws.com.br/v1/cnpj/{CNPJ} and check if he is one of the owner this one is easy.

I'm working on this.

2. The congressman spent the money in a company that belongs to a partner:
   This case is harder, because we don't have the full database of CNPJs to correlate and know who are his partners. In this case we have the web site www.consultasocio.com that give us this information, but we need to figure out how to get this without have our IP banned. I tried to contact the administrator in order to get some help.

I'm trying to figure out how to collect this information.

3. The congressman spent the money in a company that belongs to a relative:
   This case hard, we don't have a database of relatives yet (only parents), we have the issue Develop an algorithm to give the probability of a certain partner be a relative of the congressperson  #98 that tries to identify the possibility of a person be a relative. But I think that we really need a database with this information and spend some time to create it.

Any ideas about, how todo this fast?

[cuducos]

That's what we're trying to do ; )

I'm trying to figure out how to collect this information.

Any ideas about, how todo this fast? #21

Any ideas about, how todo this fast?

No, but you might want to check #15 and #98 (and yet PR #119)