legislator_terms
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
487 rows where "start" is on date 1943-01-06 sorted by party
This data as json, copyable, CSV (advanced)
Link | rowid | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24301 | 24301 | Jerome Clark C000439 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24325 | 24325 | William Courtney C000810 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24330 | 24330 | William Cravens C000887 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24336 | 24336 | Thomas D’Alesandro D000007 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24346 | 24346 | John Delaney D000212 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24351 | 24351 | James Domengeaux D000406 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24366 | 24366 | Patrick Drewry D000496 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24373 | 24373 | Alfred Elliott E000119 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
24387 | 24387 | John Flannagan F000191 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
24392 | 24392 | John Folger F000241 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24452 | 24452 | Richard Harless H000212 | rep | AZ | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
24473 | 24473 | Joseph Hendricks H000492 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
24484 | 24484 | Peterson Jarman J000058 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
24548 | 24548 | Clarence Lea L000163 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24567 | 24567 | Louis Ludlow L000501 | rep | IN | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
24574 | 24574 | Carter Manasco M000094 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
24590 | 24590 | Joseph Mansfield M000112 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
24632 | 24632 | Emory Price P000524 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
24698 | 24698 | Robert Thomason T000189 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
24717 | 24717 | Milton West W000304 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
24725 | 24725 | Orville Zimmerman Z000009 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
24755 | 24755 | Schuyler Bland B000545 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24769 | 24769 | Sol Bloom B000565 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 19 | |||||||||||||
24785 | 24785 | Alfred Bulwinkle B001056 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 11 | |||||||||||||
24799 | 24799 | Virgil Chapman C000317 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
24838 | 24838 | Martin Gorski G000332 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24850 | 24850 | Samuel Hobbs H000663 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
24866 | 24866 | Edwin Johnson J000127 | sen | CO | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
24894 | 24894 | John Lesinski L000251 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 16 | |||||||||||||
24905 | 24905 | Walter Lynch L000537 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 22 | |||||||||||||
24920 | 24920 | Burnet Maybank M000279 | sen | SC | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
24960 | 24960 | Mary Norton N000153 | rep | NJ | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
24968 | 24968 | Stephen Pace P000002 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
24977 | 24977 | James Peterson P000261 | rep | FL | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
24985 | 24985 | Joseph Pfeifer P000285 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25014 | 25014 | George Sadowski S000011 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25036 | 25036 | Andrew Somers S000676 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
25082 | 25082 | Compton White W000361 | rep | ID | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25094 | 25094 | William Whittington W000430 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
25102 | 25102 | Francis Worley W000744 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 18 | |||||||||||||
25115 | 25115 | Asa Allen A000114 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
25133 | 25133 | Joseph Bates B000237 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
25174 | 25174 | William Byrne B001214 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 28 | |||||||||||||
25198 | 25198 | Edward Cox C000831 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
25229 | 25229 | Robert Doughton D000448 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
25280 | 25280 | Ed Gossett G000338 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
25286 | 25286 | Walter Granger G000379 | rep | UT | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25317 | 25317 | James Heffernan H000443 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
25343 | 25343 | John Kee K000039 | rep | WV | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
25358 | 25358 | John Kerr K000138 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
25363 | 25363 | Henry Larcade L000095 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
25397 | 25397 | John Murdock M001081 | rep | AZ | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
25416 | 25416 | Donald O’Toole O000133 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
25444 | 25444 | John Rankin R000056 | rep | MS | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
25472 | 25472 | Adolph Sabath S000001 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
25479 | 25479 | Lansdale Sasscer S000067 | rep | MD | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
25501 | 25501 | William Stigler S000923 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
25610 | 25610 | Joseph Bryson B000999 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
25626 | 25626 | Albert Camp C000070 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
25652 | 25652 | Robert Crosser C000932 | rep | OH | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
25700 | 25700 | Edward Hart H000284 | rep | NJ | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
25768 | 25768 | George O’Brien O000009 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 13 | |||||||||||||
25916 | 25916 | John Dingell D000354 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 15 | |||||||||||||
25953 | 25953 | Antonio Fernández F000085 | rep | NM | 1943-01-06 | 1945-01-03 | Democrat | 0 | |||||||||||||
25984 | 25984 | Theodore Green G000418 | sen | RI | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
26037 | 26037 | Arthur Klein K000261 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
26060 | 26060 | James Murray M001108 | sen | MT | 1943-01-06 | 1949-01-03 | 2 | Democrat | |||||||||||||
26086 | 26086 | James Priest P000536 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
26109 | 26109 | James Richards R000214 | rep | SC | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
26257 | 26257 | Jere Cooper C000755 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
26306 | 26306 | Martin Dies D000338 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
26313 | 26313 | Herman Eberharter E000029 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 31 | |||||||||||||
26326 | 26326 | Thomas Gordon G000316 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 8 | |||||||||||||
26337 | 26337 | Noble Gregory G000447 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
26370 | 26370 | Lawrence Hays H000405 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
26456 | 26456 | Augustine Kelley K000058 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 28 | |||||||||||||
26712 | 26712 | Graham Barden B000139 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
26753 | 26753 | Paul Brown B000940 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
26828 | 26828 | Carl Durham D000571 | rep | NC | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
26838 | 26838 | Clair Engle E000181 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
26851 | 26851 | Aime Forand F000255 | rep | RI | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
27114 | 27114 | Frank Boykin B000725 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 1 | |||||||||||||
27130 | 27130 | Overton Brooks B000884 | rep | LA | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
27278 | 27278 | Carey Kefauver K000044 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 3 | |||||||||||||
27289 | 27289 | Paul Kilday K000171 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 20 | |||||||||||||
27305 | 27305 | Thomas Lane L000065 | rep | MA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
27400 | 27400 | William Norrell N000137 | rep | AR | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
27420 | 27420 | Louis Rabaut R000001 | rep | MI | 1943-01-06 | 1945-01-03 | Democrat | 14 | |||||||||||||
27449 | 27449 | Samuel Rayburn R000082 | rep | TX | 1943-01-06 | 1945-01-03 | Democrat | 4 | |||||||||||||
27492 | 27492 | Absalom Robertson R000317 | rep | VA | 1943-01-06 | 1945-01-03 | Democrat | 7 | |||||||||||||
27539 | 27539 | Brent Spence S000717 | rep | KY | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
27667 | 27667 | Charles Buckley B001024 | rep | NY | 1943-01-06 | 1945-01-03 | Democrat | 23 | |||||||||||||
27689 | 27689 | Clarence Cannon C000117 | rep | MO | 1943-01-06 | 1945-01-03 | Democrat | 9 | |||||||||||||
27725 | 27725 | Clifford Davis D000094 | rep | TN | 1943-01-06 | 1945-01-03 | Democrat | 10 | |||||||||||||
27819 | 27819 | George Grant G000381 | rep | AL | 1943-01-06 | 1945-01-03 | Democrat | 2 | |||||||||||||
28025 | 28025 | Almer Monroney M000859 | rep | OK | 1943-01-06 | 1945-01-03 | Democrat | 5 | |||||||||||||
28056 | 28056 | Thomas O’Brien O000016 | rep | IL | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
28142 | 28142 | Harry Sheppard S000335 | rep | CA | 1943-01-06 | 1945-01-03 | Democrat | 21 | |||||||||||||
28218 | 28218 | Carl Vinson V000105 | rep | GA | 1943-01-06 | 1945-01-03 | Democrat | 6 | |||||||||||||
28237 | 28237 | Francis Walter W000108 | rep | PA | 1943-01-06 | 1945-01-03 | Democrat | 21 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [legislator_terms] ( [legislator_id] TEXT REFERENCES [legislators]([id]), [type] TEXT, [state] TEXT, [start] TEXT, [end] TEXT, [class] INTEGER, [party] TEXT , [district] INTEGER, [how] TEXT, [party_affiliations] TEXT, [url] TEXT, [caucus] TEXT, [address] TEXT, [phone] TEXT, [fax] TEXT, [contact_form] TEXT, [office] TEXT, [state_rank] TEXT, [rss_url] TEXT, [end-type] TEXT);