Baselight
Sign In

Electoral Donations In Brazil

Statistical analysis of Brazil in 2014

@kaggle.felipeleiteantunes_electoral_donations_brazil2014

Loading...
Loading...

About this Dataset

Electoral Donations In Brazil

Context

Brazil has elections every two years, but alternating between two different types of elections, each type occurring every four years. There are the municipal elections, where mayors and city council members are elected (the last one occurred in 2016) and general elections where president, governors, senators and congressmen (regional and national) are elected (the last one occurred in 2014). Brazil has 26 federal units plus the federal district. Each one of these units (regions) elects its senators, congressmen and governors.

For each federal unit, Brazil's TSE provides information on the donations declared by the three entities: candidates, parties and committees. The data comprises information describing every donation received. The donations can be divided in two categories with respect to the donor: they can come from legal persons (private citizens, identified by the CPF (CPF is an identification number used by the Brazilian tax revenue office. It is roughly the Brazilian analogue to a social security number. With the same purpose, companies are identified with a similar number called CNPJ number) or from legal entities (i.e. companies, identified by the CNPJ number). Also, some entities can make donations among them (the party can give part of the money from a given donation to a candidate). In this type of transaction, the information on the original donor is also specified in the declarations. From now on, these type of donations will be referred to as non-original donations. Apart from information concerning each Brazilian federal unit separately, one can also obtain the information declared by the parties and committees at national level and for the presidential campaign (which has national and not regional scope).

Related paper:

https://arxiv.org/pdf/1707.08826.pdf

Tables

Receitas Comites 2014 Brasil English

@kaggle.felipeleiteantunes_electoral_donations_brazil2014.receitas_comites_2014_brasil_english
  • 656.93 KB
  • 9173 rows
  • 30 columns
Loading... 

CREATE TABLE receitas_comites_2014_brasil_english (
  "unnamed_0" BIGINT,
  "id_election" BIGINT,
  "cat_election_description" VARCHAR,
  "dat_donation_date_time" TIMESTAMP,
  "id_accountant_cnpj" BIGINT,
  "sequencial_comite" BIGINT,
  "cat_election_state" VARCHAR,
  "tipo_comite" VARCHAR,
  "cat_party" VARCHAR,
  "tipo_do_documento" VARCHAR,
  "n_mero_do_documento" VARCHAR,
  "id_donator_cpf_cnpj" DOUBLE,
  "cat_donator_name" VARCHAR,
  "cat_donator_name2" VARCHAR,
  "cat_donator_state" VARCHAR,
  "id_donator_party" DOUBLE,
  "id_donator_number" VARCHAR,
  "id_donator_economic_sector" DOUBLE,
  "cat_donator_economic_sector" VARCHAR,
  "dat_donation_date" VARCHAR,
  "num_donation_ammount" DOUBLE,
  "cat_donation_type" VARCHAR,
  "cat_donation_source" VARCHAR,
  "esp_cie_recurso" VARCHAR,
  "descri_o_da_receita" VARCHAR,
  "id_original_donator_cpf_cnpj" DOUBLE,
  "cat_original_donator_name" VARCHAR,
  "cat_original_donator_type" VARCHAR,
  "cat_original_donator_economic_sector" VARCHAR,
  "cat_original_donator_name2" VARCHAR
);

Receitas Partidos 2014 Brasil English

@kaggle.felipeleiteantunes_electoral_donations_brazil2014.receitas_partidos_2014_brasil_english
  • 709.89 KB
  • 12247 rows
  • 30 columns
Loading... 

CREATE TABLE receitas_partidos_2014_brasil_english (
  "unnamed_0" BIGINT,
  "id_election" BIGINT,
  "cat_election_description" VARCHAR,
  "dat_donation_date_time" TIMESTAMP,
  "id_accountant_cnpj" BIGINT,
  "sequencial_diretorio" BIGINT,
  "cat_election_state" VARCHAR,
  "tipo_diretorio" VARCHAR,
  "cat_party" VARCHAR,
  "tipo_do_documento" VARCHAR,
  "n_mero_do_documento" VARCHAR,
  "id_donator_cpf_cnpj" DOUBLE,
  "cat_donator_name" VARCHAR,
  "cat_donator_name2" VARCHAR,
  "cat_donator_state" VARCHAR,
  "id_donator_party" DOUBLE,
  "id_donator_number" VARCHAR,
  "id_donator_economic_sector" DOUBLE,
  "cat_donator_economic_sector" VARCHAR,
  "dat_donation_date" VARCHAR,
  "num_donation_ammount" DOUBLE,
  "cat_donation_type" VARCHAR,
  "cat_donation_source" VARCHAR,
  "esp_cie_recurso" VARCHAR,
  "descri_o_da_receita" VARCHAR,
  "id_original_donator_cpf_cnpj" DOUBLE,
  "cat_original_donator_name" VARCHAR,
  "cat_original_donator_type" VARCHAR,
  "cat_original_donator_economic_sector" VARCHAR,
  "cat_original_donator_name2" VARCHAR
);

Receitas Candidatos 2014 Brasil English

@kaggle.felipeleiteantunes_electoral_donations_brazil2014.receitas_candidatos_2014_brasil_english
  • 33.26 MB
  • 427489 rows
  • 33 columns
Loading... 

CREATE TABLE receitas_candidatos_2014_brasil_english (
  "unnamed_0" BIGINT,
  "id_election" BIGINT,
  "cat_election_description" VARCHAR,
  "dat_donation_date_time" VARCHAR,
  "id_accountant_cnpj" BIGINT,
  "id_candidate_seq" BIGINT,
  "cat_election_state" VARCHAR,
  "cat_party" VARCHAR,
  "id_candidate_num" BIGINT,
  "cat_political_office" VARCHAR,
  "cat_candidate_name" VARCHAR,
  "id_candidate_cpf" BIGINT,
  "id_receipt_num" VARCHAR,
  "id_document_num" VARCHAR,
  "id_donator_cpf_cnpj" DOUBLE,
  "cat_donator_name" VARCHAR,
  "cat_donator_name2" VARCHAR,
  "cat_donator_state" VARCHAR,
  "id_donator_party" DOUBLE,
  "id_donator_number" BIGINT,
  "id_donator_economic_sector" DOUBLE,
  "cat_donator_economic_sector" VARCHAR,
  "dat_donation_date" VARCHAR,
  "num_donation_ammount" DOUBLE,
  "cat_donation_type" VARCHAR,
  "cat_donation_source" VARCHAR,
  "cat_donation_method" VARCHAR,
  "cat_donation_description" VARCHAR,
  "id_original_donator_cpf_cnpj" DOUBLE,
  "cat_original_donator_name" VARCHAR,
  "cat_original_donator_type" VARCHAR,
  "cat_original_donator_economic_sector" VARCHAR,
  "cat_original_donator_name2" VARCHAR
);

Votacao Brasil English

@kaggle.felipeleiteantunes_electoral_donations_brazil2014.votacao_brasil_english
  • 694.08 KB
  • 22764 rows
  • 10 columns
Loading... 

CREATE TABLE votacao_brasil_english (
  "id_candidate_seq" BIGINT,
  "id_candidate_num" BIGINT,
  "cat_candidate_name" VARCHAR,
  "cat_state" VARCHAR,
  "cat_party" VARCHAR,
  "cat_coalition" VARCHAR,
  "cat_composition" VARCHAR,
  "cat_eletion_result" VARCHAR,
  "num_turn" BIGINT,
  "num_votes" BIGINT
);

Share link

Anyone who has the link will be able to view this.