About this Dataset

State Of CT: Open Expenditures - Ledger (Historical)

This archived data allows citizens to view who received payments from the state for goods or services and how much they received for historical fiscal years beginning in state fiscal year 2011-2012. The data can be explored by searching for specific payee names or by browsing by Government Function. The Open Checkbook app allows the user to drill down from aggregated spending accounts all the way down to each individual payment to a payee for more recent fiscal years. The actively updated, most recent seven fiscal years are available here This data is appended annually with an additional year of historical data. Certain payee names have been removed in order to protect the privacy of individuals, in accordance with Health Insurance Portability and Accountability Act (HIPAA) regulations or where the information is otherwise protected by law. Redacted information includes: •Payees who are statutorily protected •Information that would lead to violating HIPAA laws •Information of Minors
Organization: State of Connecticut
Last updated: 2025-10-25T20:58:40.183950
Tags: checkbook, expenditures, open-connecticut, vendor-payments

Tables

Table 1

@usgov.state_of_connecticut_state_of_ct_open_expenditures_led_2f5d55f2.table_1

170.39 MB
6,222,933 rows
27 columns

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "fiscal_year_period" BIGINT,
  "service" VARCHAR,
  "department" VARCHAR,
  "program" VARCHAR,
  "account" BIGINT,
  "expense_category" VARCHAR,
  "fund_code" BIGINT,
  "fund" VARCHAR,
  "fund_type" VARCHAR,
  "vendor" VARCHAR,
  "vendor_id" VARCHAR,
  "payment_id" DOUBLE,
  "payment_method" VARCHAR,
  "payment_status" VARCHAR,
  "payment_date" VARCHAR,
  "invoice_id" VARCHAR,
  "invoice_line_number" BIGINT,
  "invoice_line_distribution_number" BIGINT,
  "invoice_date" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "contract_number" VARCHAR,
  "purchase_order_number" VARCHAR,
  "purchase_order_line_number" BIGINT,
  "vendor_type" VARCHAR,
  "load_dttm" TIMESTAMP
);