Description

This tool imports the brazilian companies open data to a MySQL server.

Note: Python 3.6 or higher is required

Usage

This may take a while, since it downloads and extracts all files.

sh download.sh

You can import the data in your existing MySQL server, but you can also start a new one using docker:

docker run --name mysql-cnpj -p 3306:3306 -h localhost -e MYSQL_ROOT_PASSWORD=my-secret-pw -e MYSQL_DATABASE=cnpj -d mysql

After starting your MySQL server, run the following, replacing with your credentials:

python mysql_import.py <host> <port> <user> <password> <database>

Example:

python mysql_import.py localhost 3306 root my-secret-pw cnpj

The following table describes the defined schema:

Table name	Description
empresa	Basic company data.
estabelecimento	Detailed company data, each row represents a subsidiary company or the parent company itself.
socio	Basic info about the company partners.
optante_simples	References companies which use Simples Nacional tax regime.
cnae	List of all company activities, references `cnae_principal` and `cnae_secundaria` in `estabelecimento`.
motivo_situacao_cadastral	List of detailed company status info, references `motivo_situacao_cadastral` in `estabelecimento`.
municipio	List of all brazilian cities, references `endereco_codigo_municipio` in `estabelecimento`.
natureza_juridica	List of all company types, references `codigo_natureza_juridica` in `empresa`.
pais	List of countries.
qualificacao_socio	List of partner types, references `codigo_qualificacao` in `socio`.

Get all data from a specific company:

SELECT * FROM
    estabelecimento e
        JOIN
    empresa em ON em.id = e.id_empresa
WHERE
    e.cnpj = '00000000000191'