PSI Sci
New here? Follow the money and the votes · Not sure of your district? Find your U.S. House member · Find your state legislators

Follow the flow › Step 6 of 16 · Voting path

6. Elected officials

The winners take office. In Congress there are 435 House members (more for bigger states) and 100 Senators (2 per state). The President leads the agencies. Your state has its own legislature and governor, and your county and city have commissioners, council members and mayors.

Show sources for:

Who holds the money or the vote here?

Elected officials hold the public's trust and their votes on bills.

How often does it happen?

New Congress starts January 3 after each federal election; state and local terms vary.

Where the records come from

Federal data is the same for everyone. When you pick a state, the state and local rows are the places to look for your state. "Have now" means PSI Sci already collects it; "Planned" means we list the source but do not collect it yet.

Sources for step 6, Elected officials, by level of government
LevelSourceFormatHow oftenOn PSI Sci
Federalcongress-legislators (public domain, from official sources)
PSI Sci collects this (fed-legislators)
JSONweeklyHave now
FederalCongress.gov members / api.congress.govAPI (free key)dailyPlanned
StateOpen States people data (state legislators, all states)
PSI Sci collects this (st-legislators)
bulk CSVweeklyHave now
CountyCounty website: commissioners court / board of supervisors
tracked as todo rows us-county-websites
pageas changedPlanned
CityCity website: mayor and councilpageas changedPlanned
DistrictFind your representative (House) / your legislators (Open States)
linked from every page
pageas changedHave now
ZIPZIP to district lookup (Census ZCTA-to-district file)bulkafter redistrictingPlanned

See these sources as searchable records (rendered live).

See it on PSI Sci now

Variable names

Variable names we use for this step (prefix shows the level)
VariableFederalStateCountyCityDistrictZIP
member_idmember_idmember_idmember_idmember_idmember_idmember_id
bioguide_idbioguide_idbioguide_idbioguide_idbioguide_idbioguide_idbioguide_id
fec_candidate_idfec_candidate_idfec_candidate_idfec_candidate_idfec_candidate_idfec_candidate_idfec_candidate_id
officefed_officest_officecnty_officecty_officedist_officezip_office
partyfed_partyst_partycnty_partycty_partydist_partyzip_party
districtfed_districtst_districtcnty_districtcty_districtdist_districtzip_district
term_startfed_term_startst_term_startcnty_term_startcty_term_startdist_term_startzip_term_start
term_endfed_term_endst_term_endcnty_term_endcty_term_enddist_term_endzip_term_end

IDs (like bioguide_id, bill_id, piid, zcta) have no prefix because they already say what they point to.