US Census And Election Results (2000-2020)
Predict U.S. Presidential Election Results via Rich County Census Data
@kaggle.minhbtnguyen_us_census_for_election_predictions_20002020
Predict U.S. Presidential Election Results via Rich County Census Data
@kaggle.minhbtnguyen_us_census_for_election_predictions_20002020
CREATE TABLE county_census_and_election_result (
"year" BIGINT,
"county_fips" BIGINT,
"inctot" DOUBLE,
"mortamt1" DOUBLE,
"avrg_age" DOUBLE,
"ftotinc" DOUBLE,
"foodstmp_1_freq" DOUBLE,
"foodstmp_2_freq" DOUBLE,
"sex_2_freq" DOUBLE,
"sex_1_freq" DOUBLE,
"marst_5_freq" DOUBLE,
"marst_6_freq" DOUBLE,
"marst_1_freq" DOUBLE,
"marst_4_freq" DOUBLE,
"marst_3_freq" DOUBLE,
"marst_2_freq" DOUBLE,
"race_1_freq" DOUBLE,
"race_2_freq" DOUBLE,
"race_7_freq" DOUBLE,
"race_8_freq" DOUBLE,
"race_5_freq" DOUBLE,
"race_6_freq" DOUBLE,
"race_3_freq" DOUBLE,
"race_4_freq" DOUBLE,
"race_9_freq" DOUBLE,
"ctz_stat_1_freq" DOUBLE,
"ctz_stat_3_freq" DOUBLE,
"ctz_stat_2_freq" DOUBLE,
"lang_1_freq" DOUBLE,
"lang_2_freq" DOUBLE,
"educ_attain_2_0_freq" DOUBLE,
"educ_attain_1_0_freq" DOUBLE,
"educ_attain_3_0_freq" DOUBLE,
"educ_attain_4_0_freq" DOUBLE,
"empstat_1_0_freq" DOUBLE,
"empstat_3_0_freq" DOUBLE,
"empstat_2_0_freq" DOUBLE,
"state_po" VARCHAR,
"county_name" VARCHAR,
"democrat" DOUBLE,
"green" DOUBLE,
"liberitarian" DOUBLE,
"other" DOUBLE,
"republican" DOUBLE,
"winner" DOUBLE
);
CREATE TABLE meta_data (
"column" VARCHAR,
"description" VARCHAR
);
Anyone who has the link will be able to view this.