legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
64 rows where name_first = "Frederick"
This data as json, copyable, CSV (advanced)
Suggested facets: bio_birthday (date), id_fec (array)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B000188 | Frederick Barry | B000188 | 401187 | 474 | Frederick G. Barry | Q958658 | kg:/m/02rtnf8 | Frederick | Barry | 1845-01-12 | M | 9014 | George | ||||||||||||||||
B000449 | Frederick Biermann | B000449 | 401434 | 700 | Fred Biermann | Q1452228 | kg:/m/02rk7dg | Frederick | Biermann | 1884-03-20 | M | 9355 | Elliott | ||||||||||||||||
B000657 | Frederick Boucher | B000657 | 400043 | 15010 | Rick Boucher | Q2151547 | kg:/m/01_k5m | Frederick | Boucher | 1946-08-01 | M | 9636 | C. | Rick | 00113 | 6736 | 27119 | N00002171 | [ "H2VA09010" ] |
||||||||||
B000742 | Frederick Bradley | B000742 | 401701 | 953 | Frederick Van Ness Bradley | Q1453040 | kg:/m/041qht | Frederick | Bradley | 1898-04-12 | M | 9738 | Van Ness | ||||||||||||||||
B000847 | Frederick Britten | B000847 | 401804 | 1048 | Frederick A. Britten | Q5497209 | kg:/m/02rkz6b | Frederick | Britten | 1871-11-18 | M | 9874 | Albert | ||||||||||||||||
B000864 | Frederick Bromberg | B000864 | 401821 | 1063 | Frederick George Bromberg | Q1452881 | kg:/m/02rk1lv | Frederick | Bromberg | 1837-06-19 | M | 9896 | George | ||||||||||||||||
C000680 | Frederick Conkling | C000680 | 402806 | 1983 | Frederick A. Conkling | Q980833 | kg:/m/026c2nv | Frederick | Conkling | 1816-08-22 | M | 11305 | Augustus | ||||||||||||||||
C000704 | Frederick Conrad | C000704 | 402829 | 2005 | Frederick Conrad | Q5497567 | kg:/m/026pyj9 | Frederick | Conrad | M | 11336 | ||||||||||||||||||
C000739 | Frederick Coolidge | C000739 | 402860 | 2034 | Frederick S. Coolidge | Q1452993 | kg:/m/02rhgdn | Frederick | Coolidge | 1841-12-07 | M | 11378 | Spaulding | ||||||||||||||||
D000012 | Frederick Dallinger | D000012 | 403155 | 2306 | Frederick W. Dallinger | Q1453049 | kg:/m/0bvdz7 | Frederick | Dallinger | 1871-10-02 | M | 11847 | William | ||||||||||||||||
D000070 | Frederick Davenport | D000070 | 403208 | 2352 | Frederick M. Davenport | Q1452956 | kg:/m/027vrdv | Frederick | Davenport | 1866-08-27 | M | 11918 | Morgan | ||||||||||||||||
D000201 | Frederick Deitrick | D000201 | 403354 | 2471 | Frederick Simpson Deitrick | Q1377337 | kg:/m/02rhgfp | Frederick | Deitrick | 1875-04-09 | M | 12080 | Simpson | ||||||||||||||||
D000408 | Frederick Dominick | D000408 | 403521 | 2651 | Frederick H. Dominick | Q1452893 | kg:/m/02qvl5g | Frederick | Dominick | 1877-02-20 | M | 12339 | Haskell | ||||||||||||||||
E000165 | Frederick Ely | E000165 | 403856 | 2953 | Frederick D. Ely | Q1452840 | kg:/m/02qr8hd | Frederick | Ely | 1838-09-24 | M | 12795 | David | ||||||||||||||||
E000219 | Frederick Essen | E000219 | 403905 | 2991 | Frederick Essen | Q1320592 | kg:/m/02rz62q | Frederick | Essen | 1863-04-22 | M | 12873 | |||||||||||||||||
F000194 | Frederick Fleetwood | F000194 | 404149 | 3210 | Frederick G. Fleetwood | Q976409 | kg:/m/02rhgd9 | Frederick | Fleetwood | 1868-09-27 | M | 13214 | Gleed | ||||||||||||||||
F000368 | Frederick Frelinghuysen | F000368 | 404314 | 3361 | Frederick Frelinghuysen (general) | Q5497813 | kg:/m/02_31t | Frederick | Frelinghuysen | 1753-04-13 | M | 13434 | |||||||||||||||||
F000369 | Frederick Frelinghuysen | F000369 | 404315 | 3362 | Frederick Theodore Frelinghuysen | Q709453 | kg:/m/0c7sy | Frederick | Frelinghuysen | 1817-08-04 | M | Theodore | |||||||||||||||||
G000201 | Frederick Gillett | G000201 | 404565 | 3599 | Frederick H. Gillett | Q450898 | kg:/m/047psf | Frederick | Gillett | 1851-10-16 | M | 13820 | Huntington | ||||||||||||||||
G000371 | Frederick Grandy | G000371 | 404723 | 15414 | Fred Grandy | Q653258 | kg:/m/025nwl | Frederick | Grandy | 1948-06-29 | M | 14031 | Lawrence | 00455 | |||||||||||||||
G000409 | Frederick Green | G000409 | 404758 | 3776 | Frederick W. Green (congressman) | Q5498950 | kg:/m/02rl_wc | Frederick | Green | 1816-02-18 | M | 14083 | William | ||||||||||||||||
H000031 | Frederick Hale | H000031 | 404916 | 3919 | Frederick Hale (U.S. senator) | Q1452897 | kg:/m/08f19f | Frederick | Hale | 1874-10-07 | M | ||||||||||||||||||
H000093 | Frederick Halterman | H000093 | 404975 | 3975 | Frederick Halterman | Q5497946 | kg:/m/0djt9b | Frederick | Halterman | 1831-10-22 | M | 14402 | |||||||||||||||||
H000564 | Frederick Hicks | H000564 | 405426 | 4385 | Frederick C. Hicks | Q111605 | kg:/m/026k8vw | Frederick | Hicks | 1872-03-06 | M | 14982 | Cocks | ||||||||||||||||
J000131 | Frederick Johnson | J000131 | 406030 | 4952 | Frederick A. Johnson | Q4121016 | kg:/m/02q6_qj | Frederick | Johnson | 1833-01-02 | M | 15857 | Avery | ||||||||||||||||
K000131 | Frederick Kern | K000131 | 406297 | 5200 | Fred J. Kern | Q5495563 | kg:/m/02rl0y9 | Frederick | Kern | 1864-09-02 | M | 16241 | John | ||||||||||||||||
L000051 | Frederick Landis | L000051 | 406560 | 5433 | Frederick Landis | Q1452934 | kg:/m/02rkfwr | Frederick | Landis | 1872-08-18 | M | 16648 | |||||||||||||||||
L000085 | Frederick Lansing | L000085 | 406594 | 5467 | Frederick Lansing | Q5498244 | kg:/m/02rkpgn | Frederick | Lansing | 1838-02-16 | M | 16698 | |||||||||||||||||
L000222 | Frederick Lehlbach | L000222 | 406726 | 5589 | Frederick R. Lehlbach | Q1452972 | kg:/m/0270zmm | Frederick | Lehlbach | 1876-01-31 | M | 16868 | Reimold | ||||||||||||||||
L000435 | Frederick Loofbourow | L000435 | 406926 | 5772 | Frederick C. Loofbourow | Q1452809 | kg:/m/02rm40f | Frederick | Loofbourow | 1874-02-08 | M | 17135 | Charles | ||||||||||||||||
L000440 | Frederick Lord | L000440 | 406931 | 5777 | Frederick William Lord | Q111965 | kg:/m/026m4jt | Frederick | Lord | 1800-12-11 | M | 17141 | William | ||||||||||||||||
L000469 | Frederick Low | L000469 | 406958 | 5804 | Frederick Low | Q879234 | kg:/m/038n23 | Frederick | Low | 1828-06-30 | M | 17179 | Ferdinand | ||||||||||||||||
L000515 | Frederick Lundin | L000515 | 407001 | 5840 | Frederick Lundin | Q5498322 | kg:/m/02rkz6p | Frederick | Lundin | 1868-05-18 | M | 17235 | |||||||||||||||||
M000055 | Frederick Magrady | M000055 | 407083 | 5915 | Frederick William Magrady | Q5499093 | kg:/m/0fqxqx | Frederick | Magrady | 1863-11-24 | M | 17397 | William | ||||||||||||||||
M000180 | Frederick Martin | M000180 | 407201 | 6024 | Frederick S. Martin | Q5498685 | kg:/m/02rkpg_ | Frederick | Martin | 1794-04-25 | M | 17546 | Stanley | ||||||||||||||||
M000704 | Frederick Miles | M000704 | 407687 | 6465 | Frederick Miles | Q1452951 | kg:/m/02q1x_d | Frederick | Miles | 1815-12-19 | M | 18210 | |||||||||||||||||
M001062 | Frederick Muhlenberg | M001062 | 408028 | 6780 | Frederick Augustus Muhlenberg | Q5497295 | kg:/m/0490vk | Frederick | Muhlenberg | 1887-09-25 | M | 18655 | Augustus | ||||||||||||||||
M001063 | Frederick Muhlenberg | M001063 | 408029 | 6781 | Frederick Muhlenberg | Q724629 | kg:/m/01d0wm | Frederick | Muhlenberg | 1750-01-01 | M | 18657 | Augustus Conrad | ||||||||||||||||
M001069 | Frederick Mulkey | M001069 | 408035 | 6787 | Frederick W. Mulkey | Q979758 | kg:/m/0d4xvw | Frederick | Mulkey | 1874-01-06 | M | William | |||||||||||||||||
N000104 | Frederick Niedringhaus | N000104 | 408188 | 6928 | Frederick G. Niedringhaus | Q215212 | kg:/m/02rz631 | Frederick | Niedringhaus | 1837-10-21 | M | 18961 | Gottlieb | ||||||||||||||||
P000150 | Frederick Payne | P000150 | 408554 | 7271 | Frederick G. Payne | Q883477 | kg:/m/02m4g5 | Frederick | Payne | 1904-07-24 | M | George | |||||||||||||||||
P000346 | Frederick Pike | P000346 | 408743 | 7448 | Frederick A. Pike | Q1452772 | kg:/m/02rv9mb | Frederick | Pike | 1816-12-09 | M | 19708 | Augustus | ||||||||||||||||
R000161 | Frederick Remann | R000161 | 409138 | 7821 | Frederick Remann | Q5498610 | kg:/m/02rk9k6 | Frederick | Remann | 1847-05-10 | M | 20284 | |||||||||||||||||
R000232 | Frederick Richmond | R000232 | 409208 | 14269 | Fred Richmond | Q2913204 | kg:/m/092gb6 | Frederick | Richmond | 1923-11-15 | M | 20371 | William | 00959 | |||||||||||||||
R000423 | Frederick Rooney | R000423 | 409388 | 10620 | Fred B. Rooney | Q11860005 | kg:/m/0dnsrc | Frederick | Rooney | 1925-11-06 | M | 20610 | Bernard | 00983 | |||||||||||||||
R000476 | Frederick Rowe | R000476 | 409437 | 8092 | Frederick W. Rowe | Q1103926 | kg:/m/02rkphp | Frederick | Rowe | 1863-03-19 | M | 20673 | William | ||||||||||||||||
S000086 | Frederick Sawyer | S000086 | 409598 | 8235 | Frederick A. Sawyer | Q5497222 | kg:/m/0d05sc | Frederick | Sawyer | 1822-12-12 | M | Adolphus | |||||||||||||||||
S000161 | Frederick Schwengel | S000161 | 409668 | 8288 | Fred Schwengel | Q1436443 | kg:/m/02rk7f4 | Frederick | Schwengel | 1906-05-28 | M | 21341 | Delbert | ||||||||||||||||
S000214 | Frederick Seaton | S000214 | 409719 | 8337 | Fred A. Seaton | Q371052 | kg:/m/01xs0l | Frederick | Seaton | 1909-12-11 | M | Andrew | |||||||||||||||||
S000455 | Frederick Sisson | S000455 | 409947 | 8550 | Fred Sisson | Q5496278 | kg:/m/0271cc3 | Frederick | Sisson | 1879-03-31 | M | 21705 | James | ||||||||||||||||
S000536 | Frederick Smith | S000536 | 410019 | 8619 | Frederick Cleveland Smith | Q5497549 | kg:/m/027m4z7 | Frederick | Smith | 1884-07-29 | M | 21801 | Cleveland | ||||||||||||||||
S000802 | Frederick Stanton | S000802 | 410268 | 8844 | Frederick Perry Stanton | Q1260074 | kg:/m/0d9htd | Frederick | Stanton | 1814-12-22 | M | 22131 | Perry | ||||||||||||||||
S000848 | Frederick Steiwer | S000848 | 410312 | 8880 | Frederick Steiwer | Q1261922 | kg:/m/0d8smn | Frederick | Steiwer | 1883-10-13 | M | ||||||||||||||||||
S000878 | Frederick Stevens | S000878 | 410340 | 8908 | Frederick Stevens (American politician) | Q182812 | kg:/m/0h18q0 | Frederick | Stevens | 1861-01-01 | M | 22225 | Clement | ||||||||||||||||
S000957 | Frederick Stone | S000957 | 410416 | 8979 | Frederick Stone | Q1778562 | kg:/m/08qtl1 | Frederick | Stone | 1820-02-07 | M | 22324 | |||||||||||||||||
T000030 | Frederick Tallmadge | T000030 | 410619 | 9170 | Frederick A. Tallmadge | Q759142 | kg:/m/026n0vl | Frederick | Tallmadge | 1792-08-29 | M | 22670 | Augustus | ||||||||||||||||
T000111 | Frederick Teese | T000111 | 410693 | 9242 | Frederick Halstead Teese | Q1450330 | kg:/m/02vn_6g | Frederick | Teese | 1823-10-21 | M | 22770 | Halstead | ||||||||||||||||
V000050 | Frederick Van Nuys | V000050 | 411092 | 9626 | Frederick Van Nuys | Q1453047 | kg:/m/0cxf70 | Frederick | Van Nuys | 1874-04-16 | M | ||||||||||||||||||
V000106 | Frederick Vinson | V000106 | 411161 | 9678 | Fred M. Vinson | Q460151 | kg:/m/02rhq2 | Frederick | Vinson | 1890-01-22 | M | 21002 | Moore | Frederick Vinson | |||||||||||||||
W000369 | Frederick White | W000369 | 411530 | 10022 | Frederick Edward White | Q1452857 | kg:/m/02rk7fh | Frederick | White | 1844-01-19 | M | 23652 | Edward | ||||||||||||||||
W000432 | Frederick Whittlesey | W000432 | 411591 | 10079 | Frederick Whittlesey | Q5499034 | kg:/m/02rkpj0 | Frederick | Whittlesey | 1799-06-12 | M | 23728 | |||||||||||||||||
W000707 | Frederick Woodard | W000707 | 411859 | 10337 | Frederick Augustus Woodard | Q946345 | kg:/m/05jzwx | Frederick | Woodard | 1854-02-12 | M | 24060 | Augustus | ||||||||||||||||
W000708 | Frederick Woodbridge | W000708 | 411860 | 10338 | Frederick E. Woodbridge | Q1452856 | kg:/m/02r5hs3 | Frederick | Woodbridge | 1818-08-29 | M | 24061 | Enoch | ||||||||||||||||
Z000007 | Frederick Zihlman | Z000007 | 412000 | 10467 | Frederick Nicholas Zihlman | Q2514458 | kg:/m/0dz63v | Frederick | Zihlman | 1879-10-02 | M | 21119 | Nicholas |
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);