Dataset: Complete Education Details (116th U.S. Congress)

About this Dataset

Complete Education Details (116th U.S. Congress)

Context

This dataset contains complete education details for members of the 116th United States Congress, including universities, degrees, and political affiliations. I hope that this dataset is helpful for anyone who may wish to further investigate the correlation of education and academic credentials with policy decisions made by members of our government.

Content

Data was gathered by reviewing Wikipedia pages for members of the U.S. 116th Congress via: https://en.wikipedia.org/wiki/116th_United_States_Congress

Acknowledgements

Thank you Wikipedia. You are a modern miracle.

Inspiration

This dataset can be used to answer questions like:

Is political affiliation correlated with education?
What is the most common degree type for U.S. Senators?
What percentage of U.S. Congressmen dropped out of college?
Which college has the most representation in the House of Representatives?
What percentage of Congressmen are scientists?

With some creative co-mingling, this dataset can be used to supplement research questions like:

Are policy decisions correlated with education?
Are there relationships associated with college affiliations and voting in Congress?
Can we find a relationship between hot button topics and education?
How is public sentiment influenced by education level?

Tables

Us Congress Education Data 2020–6–5

@kaggle.philmohun_complete_education_details_116th_us_congress.us_congress_education_data_2020_6_5

56.53 KB
540 rows
31 columns


CREATE TABLE us_congress_education_data_2020_6_5 (
  "name" VARCHAR,
  "state" VARCHAR,
  "political_party" VARCHAR,
  "house_or_senate" VARCHAR,
  "dob" VARCHAR,
  "highest_level_of_education" VARCHAR,
  "speciality_of_highest_degree" VARCHAR,
  "highest_degree_school" VARCHAR,
  "first_degree_type" VARCHAR,
  "speciality_of_first_degree" VARCHAR,
  "first_degree_school" VARCHAR,
  "jd" VARCHAR,
  "phd" VARCHAR,
  "mba" VARCHAR,
  "md" VARCHAR,
  "none" VARCHAR,
  "url" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR
);