legislators
Data license: CC0 1.0 Universal · Data source: unitedstates/congress-legislators · About: simonw/congress-legislators-datasette
This data as json, copyable, CSV
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37938 | A000357 | rep | ME | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://tomallen.house.gov | ||||||||||||
37950 | B001258 | rep | KS | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://boyda.house.gov | ||||||||||||
37985 | C000868 | rep | AL | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://cramer.house.gov | ||||||||||||
38018 | E000287 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/emanuel | ||||||||||||
38108 | H000762 | rep | OR | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/hooley | ||||||||||||
38137 | J000070 | rep | LA | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/jefferson | ||||||||||||
38179 | L000043 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 22 | http://lampson.house.gov | ||||||||||||
38214 | M001164 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 16 | http://mahoney.house.gov | ||||||||||||
38235 | M000590 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 21 | http://www.house.gov/mcnulty | ||||||||||||
38393 | C001073 | rep | LA | 2008-05-06 | 2009-01-03 | Democrat | 6 | http://cazayoux.house.gov/ | ||||||||||||
38403 | A000014 | rep | HI | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/abercrombie | ||||||||||||
38406 | A000363 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 24 | http://arcuri.house.gov | ||||||||||||
38412 | B001229 | rep | WA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/baird | ||||||||||||
38419 | B001253 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://www.house.gov/bean | ||||||||||||
38426 | B000420 | rep | AR | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/berry | ||||||||||||
38433 | B000444 | sen | DE | 2003-01-07 | 2009-01-03 | 2 | Democrat | http://biden.senate.gov | ||||||||||||
38448 | B000657 | rep | VA | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://www.boucher.house.gov | ||||||||||||
38455 | B000716 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/boyd | ||||||||||||
38477 | C001065 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://carney.house.gov | ||||||||||||
38488 | C001074 | rep | MS | 2008-05-20 | 2009-01-03 | Democrat | 1 | http://www.childers.house.gov/ | ||||||||||||
38493 | D000602 | rep | AL | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://www.house.gov/arturdavis | ||||||||||||
38497 | D000599 | rep | TN | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/lincolndavis | ||||||||||||
38513 | D000210 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://www.house.gov/delahunt | ||||||||||||
38533 | E000063 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 17 | http://www.house.gov/edwards | ||||||||||||
38544 | E000289 | rep | IN | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://ellsworth.house.gov | ||||||||||||
38551 | E000226 | rep | NC | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/etheridge | ||||||||||||
38566 | G000309 | rep | TN | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://gordon.house.gov | ||||||||||||
38569 | H001039 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 19 | http://johnhall.house.gov | ||||||||||||
38572 | H001040 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 17 | http://hare.house.gov | ||||||||||||
38576 | H001037 | rep | SD | 2007-01-04 | 2009-01-03 | Democrat | 0 | http://www.house.gov/herseth | ||||||||||||
38581 | H001030 | rep | IN | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://baronhill.house.gov | ||||||||||||
38583 | H001043 | rep | NH | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://hodes.house.gov | ||||||||||||
38600 | K000365 | rep | WI | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://kagen.house.gov | ||||||||||||
38613 | K000008 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 11 | http://kanjorski.house.gov | ||||||||||||
38621 | K000113 | rep | RI | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://patrickkennedy.house.gov | ||||||||||||
38628 | K000180 | rep | MI | 2007-01-04 | 2009-01-03 | Democrat | 13 | http://www.house.gov/kilpatrick | ||||||||||||
38631 | K000366 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 22 | http://klein.house.gov | ||||||||||||
38647 | M001146 | rep | GA | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://jimmarshall.house.gov | ||||||||||||
38662 | M001148 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 17 | http://kendrickmeek.house.gov | ||||||||||||
38665 | M001161 | rep | LA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://melancon.house.gov | ||||||||||||
38668 | M001167 | rep | AZ | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://mitchell.house.gov | ||||||||||||
38682 | M000844 | rep | WV | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/mollohan | ||||||||||||
38688 | M001140 | rep | KS | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://moore.house.gov | ||||||||||||
38690 | M001168 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://patrickmurphy.house.gov | ||||||||||||
38709 | M001120 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 12 | http://www.house.gov/murtha | ||||||||||||
38728 | O000006 | rep | MN | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://oberstar.house.gov | ||||||||||||
38749 | O000007 | rep | WI | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://obey.house.gov | ||||||||||||
38763 | O000107 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 27 | http://ortiz.house.gov | ||||||||||||
38773 | P000422 | rep | ND | 2007-01-04 | 2009-01-03 | Democrat | 0 | http://www.house.gov/pomeroy | ||||||||||||
38792 | R000568 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 23 | http://rodriguez.house.gov | ||||||||||||
38795 | S001158 | rep | CO | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/salazar | ||||||||||||
38798 | S001169 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 7 | http://sestak.house.gov | ||||||||||||
38823 | S000465 | rep | MO | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/skelton | ||||||||||||
38830 | S000672 | rep | AR | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/snyder | ||||||||||||
38835 | S001153 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 32 | http://solis.house.gov | ||||||||||||
38845 | S001173 | rep | OH | 2007-01-04 | 2009-01-03 | Democrat | 18 | http://space.house.gov | ||||||||||||
38859 | S000749 | rep | SC | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/spratt | ||||||||||||
38868 | S001045 | rep | MI | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/stupak | ||||||||||||
38879 | T000038 | rep | TN | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://www.house.gov/tanner | ||||||||||||
38886 | T000057 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://www.house.gov/tauscher | ||||||||||||
38897 | T000074 | rep | MS | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/genetaylor | ||||||||||||
38919 | W000794 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 33 | http://www.house.gov/watson | ||||||||||||
38926 | W000314 | rep | FL | 2007-01-04 | 2009-01-03 | Democrat | 19 | http://wexler.house.gov | ||||||||||||
38928 | W000801 | rep | OH | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://charliewilson.house.gov | ||||||||||||
38939 | C001050 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 18 | http://www.house.gov/cardoza | ||||||||||||
38946 | G000554 | rep | AZ | 2007-01-04 | 2009-01-03 | Democrat | 8 | http://giffords.house.gov | ||||||||||||
38955 | H000213 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 36 | http://www.house.gov/harman | ||||||||||||
38963 | I000026 | rep | WA | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/inslee | ||||||||||||
38982 | P000149 | rep | NJ | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://www.house.gov/payne | ||||||||||||
38989 | W000792 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://www.house.gov/weiner | ||||||||||||
38996 | W000793 | rep | OR | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/wu | ||||||||||||
39005 | J000283 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/jackson/ | ||||||||||||
39015 | F000116 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 51 | http://www.house.gov/filner | ||||||||||||
39096 | A000022 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/ackerman | ||||||||||||
39106 | A000362 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://altmire.house.gov | ||||||||||||
39115 | B001234 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 43 | http://www.house.gov/baca | ||||||||||||
39140 | B001231 | rep | NV | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/berkley | ||||||||||||
39155 | B000410 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 28 | http://www.house.gov/berman | ||||||||||||
39181 | B001254 | rep | OK | 2007-01-04 | 2009-01-03 | Democrat | 2 | http://www.house.gov/boren | ||||||||||||
39189 | B000652 | rep | IA | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://boswell.house.gov | ||||||||||||
39210 | C001060 | rep | MO | 2007-01-04 | 2009-01-03 | Democrat | 3 | http://www.house.gov/carnahan | ||||||||||||
39215 | C001058 | rep | KY | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://chandler.house.gov | ||||||||||||
39229 | C000794 | rep | IL | 2007-01-04 | 2009-01-03 | Democrat | 12 | http://www.house.gov/costello | ||||||||||||
39250 | D000327 | rep | WA | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://www.house.gov/dicks | ||||||||||||
39282 | F000339 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/frank | ||||||||||||
39302 | G000544 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 20 | http://gonzalez.house.gov | ||||||||||||
39326 | H000627 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 22 | http://www.house.gov/hinchey | ||||||||||||
39336 | H000712 | rep | PA | 2007-01-04 | 2009-01-03 | Democrat | 17 | http://www.holden.house.gov | ||||||||||||
39360 | K000172 | rep | MI | 2007-01-04 | 2009-01-03 | Democrat | 5 | http://www.house.gov/kildee | ||||||||||||
39370 | K000336 | rep | OH | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://kucinich.house.gov | ||||||||||||
39425 | M001154 | rep | NC | 2007-01-04 | 2009-01-03 | Democrat | 13 | http://www.house.gov/bradmiller | ||||||||||||
39445 | O000085 | rep | MA | 2007-01-04 | 2009-01-03 | Democrat | 1 | http://www.house.gov/olver | ||||||||||||
39484 | R000170 | rep | TX | 2007-01-04 | 2009-01-03 | Democrat | 16 | http://wwwc.house.gov/reyes | ||||||||||||
39487 | R000581 | rep | CA | 2007-09-04 | 2009-01-03 | Democrat | 37 | http://richardson.house.gov/ | ||||||||||||
39494 | R000573 | rep | AR | 2007-01-04 | 2009-01-03 | Democrat | 4 | http://www.house.gov/ross | ||||||||||||
39502 | R000462 | rep | NJ | 2007-01-04 | 2009-01-03 | Democrat | 9 | http://rothman.house.gov | ||||||||||||
39510 | S001171 | rep | NC | 2007-01-04 | 2009-01-03 | Democrat | 11 | http://shuler.house.gov | ||||||||||||
39530 | S000810 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 13 | http://www.house.gov/stark | ||||||||||||
39551 | S001174 | rep | OH | 2007-01-04 | 2009-01-03 | Democrat | 13 | http://sutton.house.gov | ||||||||||||
39566 | T000326 | rep | NY | 2007-01-04 | 2009-01-03 | Democrat | 10 | http://www.house.gov/towns | ||||||||||||
39578 | W000738 | rep | CA | 2007-01-04 | 2009-01-03 | Democrat | 6 | http://woolsey.house.gov |