About this Dataset

Campaign Contributions - Restricted Contractors

Under Cook County Ethics Code Section 2-585, campaign contributions to County elected officials are limited to $1,500 per calendar year if the contributor is currently doing or has done business with the County. The term "doing business" or "done business" is defined at "any one or any combination of sales, purchases, leases, or contracts to, from, or with the County or any County agency in excess of $10,000.00 in the previous four years."

This dataset lists all vendors currently affected by these campaign contributions limited due to their current or past work with the County. Contribution limits apply to the listed vendor, its subsidiaries, parent company, or otherwise affiliated companies. Please note that this dataset may include separate entries for different divisions of the same company, its subsidiaries, parent company, or otherwise affiliated companies. While listed separately, they are considered a single entity/vendor subject to the County's contribution limit.
Organization: Cook County of Illinois
Last updated: 2024-04-19T17:17:28.291902

Tables

Table 1

@usgov.cook_county_of_illinois_campaign_contributions_restric_6dfa5211.table_1

286.06 kB
3,996 rows
37 columns

CREATE TABLE table_1 (
  "vendor_name" VARCHAR,
  "total_paid_amount" DOUBLE,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "address_3" VARCHAR,
  "address_4" VARCHAR,
  "address_5" VARCHAR,
  "address_6" VARCHAR,
  "address_7" VARCHAR,
  "address_8" VARCHAR,
  "address_9" VARCHAR,
  "address_10" VARCHAR,
  "address_11" VARCHAR,
  "address_12" VARCHAR,
  "address_13" VARCHAR,
  "address_14" VARCHAR,
  "address_15" VARCHAR,
  "address_16" VARCHAR,
  "address_17" VARCHAR,
  "address_18" VARCHAR,
  "address_19" VARCHAR,
  "address_20" VARCHAR,
  "address_21" VARCHAR,
  "address_22" VARCHAR,
  "address_23" VARCHAR,
  "address_24" VARCHAR,
  "address_25" VARCHAR,
  "address_26" VARCHAR,
  "address_27" VARCHAR,
  "address_28" VARCHAR,
  "address_29" VARCHAR,
  "address_30" VARCHAR,
  "address_31" VARCHAR,
  "address_32" VARCHAR,
  "address_33" VARCHAR,
  "address_34" VARCHAR,
  "address_35" VARCHAR
);