State Of Connecticut: Open Pension 2014 – Present by US Government | Demographics and Population Studies

About this Dataset

State Of Connecticut: Open Pension 2014 – Present

Pension data from 2012 through the present. Data used in the Open Pension application.
Organization: State of Connecticut
Last updated: 2020-11-12T14:57:29.498905
Tags: open-connecticut, open-pension, osc, pension

Tables

Table 1

@usgov.state_of_connecticut_state_of_connecticut_open_pension_4db58114.table_1

347.04 MB
7259059 rows
15 columns


CREATE TABLE table_1 (
  "ct_empl_id_rcd" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "middle_initial" VARCHAR,
  "bargaining_unit" DOUBLE,
  "union_descr" VARCHAR,
  "tier_descr" VARCHAR,
  "state" VARCHAR,
  "check_date" VARCHAR,
  "pay_end_date" VARCHAR,
  "balance_year" BIGINT,
  "pension_wage" DOUBLE,
  "position_type" VARCHAR,
  "retire_type" VARCHAR,
  "retire_type_descr" VARCHAR
);