This tool imports the brazilian companies open data to a MySQL server.
Note: Python 3.6 or higher is required
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'