Members of the United States Congress
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
Tables
executives
id, name, id_bioguide, id_govtrack, id_icpsr_prez, name_first, name_last, bio_birthday, bio_gender, id_icpsr, name_suffix, name_middle, id_thomas, name_nickname, id_lis, id_wikidata, id_wikipedia, id_cspan, id_opensecrets, id_votesmart, id_fec, id_google_entity_id, id_ballotpedia, id_house_history, id_maplight, name_official_full, id_pictorial
80 rows
legislator_terms
legislator_id, type, state, start, end, class, party, district, how, party_affiliations, caucus, url, address, phone, fax, contact_form, office, state_rank, rss_url, end-type
45,519 rows
legislators
id, name, id_bioguide, id_govtrack, id_icpsr, id_wikipedia, id_wikidata, id_google_entity_id, name_first, name_last, bio_birthday, bio_gender, id_house_history, name_middle, id_ballotpedia, name_nickname, name_suffix, id_bioguide_previous, id_house_history_alternate, other_names, id_thomas, id_cspan, id_votesmart, id_lis, id_fec, name_official_full, id_opensecrets, id_maplight, leadership_roles, family, id_pictorial
12,759 rows
offices
id, legislator_id, address, suite, city, state, zip, latitude, longitude, fax, phone, building, hours
1,290 rows
social_media
id, legislator_id, twitter, facebook, youtube_id, twitter_id, youtube, instagram, instagram_id, mastodon
528 rows
Download SQLite DB: legislators.db 5.5 MB