legislator_terms

10 rows where legislator_id = "C001069"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: url, address, contact_form, office, start (date), end (date)

Link rowid ▼ legislator_id type state start end class party district how party_affiliations caucus url address phone fax contact_form office state_rank rss_url end-type
43078 43078 C001069 rep CT 2007-01-04 2009-01-03   Democrat 2       http://courtney.house.gov                
43079 43079 C001069 rep CT 2009-01-06 2011-01-03   Democrat 2       http://courtney.house.gov                
43080 43080 C001069 rep CT 2011-01-05 2013-01-03   Democrat 2       http://courtney.house.gov 215 Cannon HOB; Washington DC 20515-0702 202-225-2076 202-225-4977 http://courtney.house.gov/email/ 215 Cannon House Office Building      
43081 43081 C001069 rep CT 2013-01-03 2015-01-03   Democrat 2       http://courtney.house.gov 2348 Rayburn HOB; Washington DC 20515-0702 202-225-2076 202-225-4977 https://courtney.house.gov/email-joe1 2348 Rayburn House Office Building   http://courtney.house.gov/index.php?format=feed&type=rss  
43082 43082 C001069 rep CT 2015-01-06 2017-01-03   Democrat 2       http://courtney.house.gov 2348 Rayburn HOB; Washington DC 20515-0702 202-225-2076 202-225-4977 https://courtney.house.gov/email-joe1 2348 Rayburn House Office Building   http://courtney.house.gov/index.php?format=feed&type=rss  
43083 43083 C001069 rep CT 2017-01-03 2019-01-03   Democrat 2       https://courtney.house.gov 2348 Rayburn House Office Building; Washington DC 20515-0702 202-225-2076 202-225-4977   2348 Rayburn House Office Building   http://courtney.house.gov/index.php?format=feed&type=rss  
43084 43084 C001069 rep CT 2019-01-03 2021-01-03   Democrat 2       https://courtney.house.gov 2332 Rayburn House Office Building Washington DC 20515-0702 202-225-2076     2332 Rayburn House Office Building   http://courtney.house.gov/index.php?format=feed&type=rss  
43085 43085 C001069 rep CT 2021-01-03 2023-01-03   Democrat 2       https://courtney.house.gov 2449 Rayburn House Office Building Washington DC 20515-0702 202-225-2076     2449 Rayburn House Office Building   http://courtney.house.gov/index.php?format=feed&type=rss  
43086 43086 C001069 rep CT 2023-01-03 2025-01-03   Democrat 2       https://courtney.house.gov 2449 Rayburn House Office Building Washington DC 20515-0702 202-225-2076     2449 Rayburn House Office Building   http://courtney.house.gov/index.php?format=feed&type=rss  
43087 43087 C001069 rep CT 2025-01-03 2027-01-03   Democrat 2       https://courtney.house.gov 2449 Rayburn House Office Building Washington DC 20515-0702 202-225-2076     2449 Rayburn House Office Building   http://courtney.house.gov/index.php?format=feed&type=rss  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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, "caucus" TEXT, "url" TEXT, "address" TEXT, "phone" TEXT, "fax" TEXT, "contact_form" TEXT, "office" TEXT, "state_rank" TEXT, "rss_url" TEXT, "end-type" TEXT);