legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
9 rows where name_nickname = "Bob"
This data as json, copyable, CSV (advanced)
Suggested facets: name_first, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B000201 | Edward Bartlett | B000201 | 401200 | 486 | Bob Bartlett | Q719965 | kg:/m/01yrby | Edward | Bartlett | 1904-04-20 | M | 9032 | Lewis | Bob | |||||||||||||||
C000178 | Milton Carr | C000178 | 402325 | 14210 | Milton Robert Carr | Q731392 | kg:/m/03ycgn | Milton | Carr | 1943-03-27 | M | 10676 | Robert | Bob | 00180 | ||||||||||||||
C001070 | Robert Casey | C001070 | 412246 | 40703 | Bob Casey Jr. | Q887841 | kg:/m/047ymw | Robert | Casey | 1960-04-13 | M | P. | Bob | Bob Casey, Jr. | Jr. | 01828 | 47036 | 2541 | S309 | Robert P. Casey, Jr. | N00027503 | [ "S6PA00217" ] |
727 | ||||||
G000595 | Robert Good | G000595 | 456853 | Bob Good | Q103850475 | kg:/g/11fsfm06kc | Robert | Good | 1965-09-11 | M | G. | Bob | Bob Good | N00045557 | [ "H0VA05160" ] |
||||||||||||||
M000242 | Robert Mathias | M000242 | 407260 | 11031 | Bob Mathias | Q52627 | kg:/m/030bgh | Robert | Mathias | 1930-11-17 | M | 17623 | Bruce | Bob | 00746 | ||||||||||||||
M000639 | Robert Menendez | M000639 | 400272 | 29373 | Bob Menendez | Q888132 | kg:/m/033d3p | Robert | Menendez | 1954-01-01 | M | 18124 | Bob | Bob Menendez | [ { "last": "Menendez" } ] |
00791 | 29608 | 26961 | S306 | Robert Menendez | N00000699 | [ "H2NJ13075", "S6NJ00289" ] |
368 | ||||||
N000081 | Robert Ney | N000081 | 400293 | 29552 | Bob Ney | Q1385763 | kg:/m/039tvl | Robert | Ney | 1954-07-05 | M | 18935 | William | Bob | 00862 | N00003532 | |||||||||||||
S000606 | Robert Smith | S000606 | 300155 | 15116 | Bob Smith (New Hampshire politician) | Q6182103 | kg:/m/02lz3h | Robert | Smith | 1941-03-30 | M | 21883 | Bob | 01082 | S216 | ||||||||||||||
W000610 | Robert Wilson | W000610 | 411765 | 10249 | Bob Wilson (politician) | Q888328 | kg:/m/0986w2 | Robert | Wilson | 1916-04-05 | M | 23939 | Carlton | Bob | 01234 |
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);