legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
5 rows where name_first = "William" and name_suffix = "III"
This data as json, copyable, CSV (advanced)
Suggested facets: name_middle, bio_birthday (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B000851 | William Brock | B000851 | 401808 | 10571 | Bill Brock | Q456582 | kg:/m/042dhg | William | Brock | 1930-11-23 | M | 9879 | Emerson | III | 01291 | ||||||||||||||
G000402 | William Gray | G000402 | 404752 | 14629 | William H. Gray III | Q3511361 | kg:/m/03wvx6z | William | Gray | 1941-08-20 | M | 14072 | Herbert | III | 00460 | ||||||||||||||
H000906 | William Hudnut | H000906 | 405752 | 14024 | William H. Hudnut III | Q2579080 | kg:/m/027wdpm | William | Hudnut | 1932-10-17 | M | 15404 | Herbert | III | 00570 | ||||||||||||||
L000025 | William Laird | L000025 | 406535 | 5411 | William Laird III | Q2580324 | kg:/m/0cxds6 | William | Laird | 1916-06-02 | M | Ramsey | III | ||||||||||||||||
M000923 | William Moore | M000923 | 407894 | 14259 | Henson Moore | Q1607589 | kg:/m/09jzs0 | William | Moore | 1939-10-04 | M | 18489 | Henson | III | 00829 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [legislators] ( [id] TEXT PRIMARY KEY, [name] TEXT, [id_bioguide] TEXT, [id_govtrack] INTEGER, [id_icpsr] INTEGER, [id_wikipedia] TEXT, [id_wikidata] TEXT, [id_google_entity_id] TEXT, [name_first] TEXT, [name_last] TEXT, [bio_birthday] TEXT, [bio_gender] TEXT , [id_house_history] INTEGER, [name_middle] TEXT, [name_nickname] TEXT, [id_ballotpedia] TEXT, [name_suffix] TEXT, [id_bioguide_previous] TEXT, [id_house_history_alternate] INTEGER, [other_names] TEXT, [id_thomas] TEXT, [id_cspan] INTEGER, [id_votesmart] INTEGER, [id_lis] TEXT, [name_official_full] TEXT, [id_opensecrets] TEXT, [id_fec] TEXT, [id_maplight] INTEGER, [leadership_roles] TEXT, [family] TEXT);