3 ms·
Instead of mining the bio guide, I would mine Wikipedia. There is a page listing all members of the current U.S. Congress [0], and that page links to each membe
by pash 10y ago
Instead of mining the bio guide, I would mine Wikipedia. There is a page listing all members of the current U.S. Congress [0], and that page links to each member's own Wikipedia page. Almost without exception, each current member's personal page names the universities the member graduated from in the info box.
So mine the membership list for the members' names and the URLs of their personal Wikipedia pages, then mine the info box on each personal page for university affiliations. The links will allow you to disambiguate universities with similar names.
Pages also exist listing the membership of almost all former U.S. Congresses, so you could repeat the process going back in time; it would be interesting to see how affiliations have changed and diversified (or not) over the years. A similar process would work for finding the academic affiliations of members of the U.S. Supreme Court and the president's cabinet, as well as of state governors; it might even work to find comparable information for some sets of foreign poliicians (e.g., British MPs or members of European Parliament).
(And I agree with arcanus; you should change your page to sort by the count of affiliated members of Congress, not U.S. News rank, as it's the former that is the information being presented, not the latter.)
0. https://en.m.wikipedia.org/wiki/114th_United_States_Congress https://en.m.wikipedia.org/wiki/114th_United_States_Congress
- danso 10y agoI haven't looked at extreme edge cases, but you're right, Wikipedia tends to have the right alma mater, included situations in which someone has only attended classes but isn't reported as actually matriculating. It wouldn't require a big traversal of Wikipedia (though I imagine that would be easy enough)...the unitedstates Github repo, which is a semi-automated crowdsourced repo of Congress data, has all the historical Congressmembers as structured YAML, including their Wikipedia page (though I haven't counted to see how many have that attribute filled): https://github.com/unitedstates/congress-legislators https://github.com/unitedstates/congress-legislators
- ZeroGravitas 10y agoI was going to suggest looking at http://everypolitician.org http://everypolitician.org but it seems like the US is ahead of the game in releasing this info. People from other countries that want to do similar might find it useful though.