Name: Legislator Database
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Legislator Database

A listing of State Representatives and State Senators. For more information see: http://www.cga.ct.gov/asp/menu/legdownload.asp
Organization: State of Connecticut
Last updated: 2020-11-12T14:57:28.369783
Tags: cga, districts, legislator-database, legislature, representatives, senate

Tables

Table 1

@usgov.state_of_connecticut_legislator_database.table_1

49.01 kB
187 rows
33 columns

CREATE TABLE table_1 (
  "district" BIGINT,
  "office_code" VARCHAR,
  "district_number" VARCHAR,
  "designator_code" VARCHAR,
  "first_name" VARCHAR,
  "middle_initial" VARCHAR,
  "last_name" VARCHAR,
  "suffix" VARCHAR,
  "commonly_used_name" VARCHAR,
  "home_street_address" VARCHAR,
  "home_city" VARCHAR,
  "home_state" VARCHAR,
  "home_zip_code" VARCHAR,
  "home_phone_number" VARCHAR,
  "capitol_street_address" VARCHAR,
  "capitol_city" VARCHAR,
  "capitol_phone" VARCHAR,
  "room" VARCHAR,
  "room_number" DOUBLE,
  "committees_chaired" VARCHAR,
  "committees_vice_chaired" VARCHAR,
  "ranking_member" VARCHAR,
  "committee_member" VARCHAR,
  "senator_representative" VARCHAR,
  "party" VARCHAR,
  "title" VARCHAR,
  "gender" VARCHAR,
  "business_phone" VARCHAR,
  "email" VARCHAR,
  "fax" VARCHAR,
  "prison" BIGINT,
  "url" VARCHAR,
  "committee_codes" VARCHAR
);