State of Connecticut

Close
Author
Tyler Kleykamp
Description
This data allows citizens to view who received payments from the state for goods or services and how much they received. The data can be explored by searching for specific payee names or by browsing by Government Function. The Open Checkbook app( http://opencheckbook.ct.gov) allows the user to drill down from aggregated spending accounts all the way down to each individual payment to a payee. The data is updated nightly and therefore reflects current spending activities more accurately than any other publicly available source. In general the data reflects all payments made up to 24 to 48 hours prior to view. 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
Tags
checkbook, expenditures, usodcensus
Rating
Current value: 0 out of 5
Data Provided By
State Comptroller
Source Link
http://www.osc.ct.gov
License
Public Domain
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Fiscal Year
fiscal_year
Fiscal Year Period
fiscal_year_period
Service
service
Department
department
Program
program
Account
account
Expense Category
expense_category
Fund Code
fund_code
Fund
fund
Fund Type
fund_type
Vendor
vendor
Vendor ID
vendor_id
Payment ID
payment_id
Payment Method
payment_method
Payment Status
payment_status
Payment Date
payment_date
Invoice ID
invoice_id
Invoice Line Number
invoice_line_number
Invoice Line Distribution Number
invoice_line_distribution_number
Invoice Date
invoice_date
Amount
amount
Description
description
Contract Number
contract_number
Purchase Order Number
purchase_order_number
Purchase Order Line Number
purchase_order_line_number
Vendor Type
vendor_type
Load DTTM
load_dttm

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.