legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
9 rows where name_nickname = "Tom" sorted by name_middle
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
H000206 | Thomas Harkin | H000206 | 300051 | 14230 | Tom Harkin | Q465617 | kg:/m/020ynq | Thomas | Harkin | 1939-11-19 | M | 14542 | Tom | Tom Harkin | 00501 | 2005 | 53294 | S172 | Tom Harkin | N00004207 | [ "S4IA00020", "P20000741" ] |
573 | |||||||
D000064 | Thomas Daschle | D000064 | 300031 | 14617 | Tom Daschle | Q443640 | kg:/m/07lv9 | Thomas | Daschle | 1947-12-09 | M | 11910 | A. | Tom | 00267 | S185 | N00004583 | ||||||||||||
D000217 | Thomas DeLay | D000217 | 400104 | 15094 | Tom DeLay | Q180390 | kg:/m/01fnd0 | Thomas | DeLay | 1947-04-08 | M | 12103 | Dale | Tom | 00282 | N00005892 | |||||||||||||
P000265 | Thomas Petri | P000265 | 400318 | 14675 | Tom Petri | Q969776 | kg:/m/024tmj | Thomas | Petri | 1940-05-28 | M | 19606 | E. | Tom | Tom Petri | 00912 | 3190 | 27139 | Thomas E. Petri | N00004426 | [ "H0WI06061" ] |
412 | |||||||
T000458 | Thomas Tancredo | T000458 | 400394 | 29907 | Tom Tancredo | Q159720 | kg:/m/024zgw | Thomas | Tancredo | 1945-12-20 | M | 23196 | G. | Tom | 01592 | 17030 | N00006103 | [ "H8CO06054" ] |
|||||||||||
A000357 | Thomas Allen | A000357 | 400007 | 29728 | Tom Allen (Maine politician) | Q1855866 | kg:/m/025k1c | Thomas | Allen | 1945-04-16 | M | 8751 | H. | Tom | 01461 | 380 | N00000469 | [ "H6ME01157" ] |
|||||||||||
D000136 | Thomas Davis | D000136 | 400098 | 29576 | Tom Davis (Virginia politician) | Q2425943 | kg:/m/05bh59 | Thomas | Davis | 1949-01-05 | M | 12002 | M. | Tom | III | 00274 | 21935 | N00002045 | [ "H4VA11020" ] |
||||||||||
C000684 | Thomas Connally | C000684 | 402810 | 1986 | Tom Connally | Q912806 | kg:/m/089hd7 | Thomas | Connally | 1877-08-19 | M | 11312 | Terry | Tom | |||||||||||||||
O000165 | Thomas Osborne | O000165 | 400303 | 20126 | Tom Osborne | Q2439945 | kg:/m/022j57 | Thomas | Osborne | 1937-02-23 | M | 19272 | William | Tom | 01658 | N00012970 |
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);