legislators
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_opensecrets, id_votesmart, id_fec, id_cspan, id_wikipedia, id_wikidata, id_google_entity_id, id_ballotpedia, id_house_history, id_maplight, name_official_full
79 rows
legislator_terms
legislator_id, type, state, start, end, class, party, district, how, party_affiliations, url, caucus, address, phone, fax, contact_form, office, state_rank, rss_url, end-type
44,551 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, name_nickname, id_ballotpedia, name_suffix, id_bioguide_previous, id_house_history_alternate, other_names, id_thomas, id_cspan, id_votesmart, id_lis, name_official_full, id_opensecrets, id_fec, id_maplight, leadership_roles, family
12,598 rows
offices
id, legislator_id, address, suite, city, state, zip, latitude, longitude, phone, fax, building, hours
1,163 rows
social_media
id, legislator_id, twitter, facebook, youtube_id, twitter_id, youtube, instagram, instagram_id
528 rows
Download SQLite DB: legislators.db 5.2 MB