About this Dataset

CCP Invoice Register

This dataset provides a cumulative record of payment and invoice details for County suppliers, vendors and other payees. Data is from December 1, 2016 to present. Payment data prior to December 1, 2016 is archived in the Cook County Check Register here: https://datacatalog.cookcountyil.gov/Finance-Administration/Cook-County-Check-Register/gywr-fjeh
Organization: Cook County of Illinois
Last updated: 2020-11-10T16:57:28.910364

Tables

Table 1

@usgov.cook_county_of_illinois_ccp_invoice_register.table_1

39.34 MB
2,008,813 rows
21 columns

CREATE TABLE table_1 (
  "fund" VARCHAR,
  "fund_name" VARCHAR,
  "office" VARCHAR,
  "office_name" VARCHAR,
  "program" VARCHAR,
  "program_name" VARCHAR,
  "object_account" VARCHAR,
  "account_name" VARCHAR,
  "payee_number" DOUBLE,
  "payee_vendor_name" VARCHAR,
  "contract_number" VARCHAR,
  "purchase_order" VARCHAR,
  "po_release_number" VARCHAR,
  "unspsc_code" VARCHAR,
  "unspsc_description" VARCHAR,
  "item_number" DOUBLE,
  "item_description" VARCHAR,
  "invoice_number" VARCHAR,
  "payment_number" DOUBLE,
  "payment_date" TIMESTAMP,
  "payment_amount" DOUBLE
);