About this Dataset

Current And Historical Connecticut State Legislators

This database contains basic information about current and historical members of the Connecticut General Assembly. The data contained within is a work in progress, so gaps and/or inconsistencies in the data may be present. If you would like to inform us of errors or missing data, please feel free to contact the database owner. Please also note, that If an individual served in more than one chamber of the CGA, they should have two rows, one to represent their service in each chamber, also the database is updated quarterly or as needed, so current events and/or elections may not yet be reflected.
Organization: State of Connecticut
Last updated: 2025-03-29T15:42:25.019687
Tags: csl, ct-state-library, legislation, legislators

Tables

Table 1

@usgov.state_of_connecticut_current_and_historical_connecticu_493c0c14.table_1

224.6 kB
16,493 rows
9 columns

CREATE TABLE table_1 (
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "middle_name_initial" VARCHAR,
  "suffix_prefix_honorifics" VARCHAR,
  "town" VARCHAR,
  "chamber" VARCHAR,
  "political_affiliation" VARCHAR,
  "years_served_m_may_term_o_october_term_house_had_6_mon_74dc7b46" VARCHAR  -- Years Served M=May Term O=October Term(House Had 6 Month Terms From 1636-1818),
  "date_of_death" VARCHAR
);