Electoral Donations In Brazil
Statistical analysis of Brazil in 2014
@kaggle.felipeleiteantunes_electoral_donations_brazil2014
Statistical analysis of Brazil in 2014
@kaggle.felipeleiteantunes_electoral_donations_brazil2014
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
);
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
);
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
);
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
);
Anyone who has the link will be able to view this.