Contracts

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id rsxa-ify5
Name Contracts
Attribution City of Chicago
Category Administration & Finance
Tags contracts, procurement
Created 2011-09-30T08:02:22Z
Publication Date 2015-09-14T20:32:56Z

Description

Contracts and modifications awarded by the City of Chicago since 1993. This data is currently maintained in the City?s Financial Management and Purchasing System (FMPS), which is used throughout the City for contract management and payment. Legacy System Records: Purchase Order/Contract Numbers that begin with alpha characters identify records imported from legacy systems. Records with a null value in the Contract Type field were imported from legacy systems. “Comptroller-Other” Contract Type: Some records where the Contract Type is “COMPTROLLER-OTHER” are ordinance-based agreements and may have start dates earlier than 1993. Depends Upon Requirements Contracts: If the contract Award Amount is $0, the contract is not cancelled, and the contract is a blanket contract, then the contract award total Depends Upon Requirements. A Depends Upon Requirements contract is an indefinite quantities contract in which the City places orders as needed and the vendor is not guaranteed any particular contract award amount.

Blanket vs. Standard Contracts: Only blanket contracts (contracts for repeated purchases) have FMPS end dates. Standard contracts (for example, construction contracts) terminate upon completion and acceptance of all deliverables. These dates are tracked outside of FMPS.

Negative Modifications: Some contracts are modified to delete scope and money from a contract. These reductions are indicated by negative numbers in the Award Amount field of this dataset.

Data Owner: Procurement Services. Time Period: 1993 to present. Frequency: Data is updated daily.

Columns

| Included | Schema Type    | Field Name                     | Name                             | Data Type     | Render Type   |
| ======== | ============== | ============================== | ================================ | ============= | ============= |
| Yes      | series tag     | purchase_order_description     | Purchase Order Description       | text          | text          |
| Yes      | series tag     | purchase_order_contract_number | Purchase Order (Contract) Number | text          | text          |
| Yes      | series tag     | revision_number                | Revision Number                  | text          | text          |
| Yes      | series tag     | specification_number           | Specification Number             | text          | text          |
| Yes      | series tag     | contract_type                  | Contract Type                    | text          | text          |
| No       |                | start_date                     | Start Date                       | calendar_date | calendar_date |
| No       |                | end_date                       | End Date                         | calendar_date | calendar_date |
| Yes      | time           | approval_date                  | Approval Date                    | calendar_date | calendar_date |
| Yes      | series tag     | department                     | Department                       | text          | text          |
| Yes      | series tag     | vendor_name                    | Vendor Name                      | text          | text          |
| Yes      | series tag     | vendor_id                      | Vendor ID                        | text          | text          |
| No       |                | address_1                      | Address 1                        | text          | text          |
| No       |                | address_2                      | Address 2                        | text          | text          |
| Yes      | series tag     | city                           | City                             | text          | text          |
| Yes      | series tag     | state                          | State                            | text          | text          |
| Yes      | series tag     | zip                            | Zip                              | text          | text          |
| Yes      | numeric metric | award_amount                   | Award Amount                     | money         | money         |
| Yes      | series tag     | procurement_type               | Procurement Type                 | text          | text          |
| Yes      | series tag     | contract_pdf                   | Contract PDF                     | url           | url           |

Time Field

Value = approval_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = end_date,start_date,address_1,address_2

Data Commands

series e:rsxa-ify5 d:2014-09-08T01:17:09.000Z t:zip=60632-3750 t:revision_number=0 t:purchase_order_description="JANITORIAL SUPPLIES" t:purchase_order_contract_number=T27497 t:state=IL t:specification_number=B74851001 t:vendor_id=15193295T t:vendor_name="IMM.M.M., INC" t:city=CHICAGO m:award_amount=0

series e:rsxa-ify5 d:2014-09-08T01:17:09.000Z t:zip=60622 t:revision_number=0 t:purchase_order_description=DEMOLITION t:purchase_order_contract_number=E011442 t:department="DEPARTMENT OF BUILDINGS" t:state=IL t:specification_number=E968020030 t:vendor_id=14878414T t:vendor_name="MIDWEST WRECKING COMPANY 01" t:city=CHICAGO m:award_amount=17500

series e:rsxa-ify5 d:2014-09-08T01:17:09.000Z t:zip=60604-3806 t:revision_number=0 t:purchase_order_description="JANITORIAL SUPPLIES" t:purchase_order_contract_number=T27500 t:state=IL t:specification_number=B74851001 t:vendor_id=22085024V t:vendor_name="CHICAGO UNITED INDUSTRIES, LIMITED" t:city=CHICAGO m:award_amount=0

Meta Commands

metric m:award_amount p:double l:"Award Amount" t:dataTypeName=money

entity e:rsxa-ify5 l:Contracts t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/rsxa-ify5

property e:rsxa-ify5 t:meta.view v:id=rsxa-ify5 v:category="Administration & Finance" v:attributionLink=http://www.cityofchicago.org/city/en/depts/dps/provdrs/contract.html v:averageRating=0 v:name=Contracts v:attribution="City of Chicago"

property e:rsxa-ify5 t:meta.view.owner v:id=scy9-9wg4 v:profileImageUrlMedium=/api/users/scy9-9wg4/profile_images/THUMB v:profileImageUrlLarge=/api/users/scy9-9wg4/profile_images/LARGE v:screenName=cocadmin v:profileImageUrlSmall=/api/users/scy9-9wg4/profile_images/TINY v:displayName=cocadmin v:privilegesDisabled=false

property e:rsxa-ify5 t:meta.view.tableauthor v:id=scy9-9wg4 v:profileImageUrlMedium=/api/users/scy9-9wg4/profile_images/THUMB v:profileImageUrlLarge=/api/users/scy9-9wg4/profile_images/LARGE v:screenName=cocadmin v:profileImageUrlSmall=/api/users/scy9-9wg4/profile_images/TINY v:roleName=administrator v:displayName=cocadmin v:privilegesDisabled=false

Top Records

| purchase_order_description                     | purchase_order_contract_number | revision_number | specification_number | contract_type | start_date          | end_date            | approval_date | department              | vendor_name                        | vendor_id | address_1                | address_2      | city       | state | zip        | award_amount | procurement_type | contract_pdf | 
| ============================================== | ============================== | =============== | ==================== | ============= | =================== | =================== | ============= | ======================= | ================================== | ========= | ======================== | ============== | ========== | ===== | ========== | ============ | ================ | ============ | 
| JANITORIAL SUPPLIES                            | T27497                         | 0               | B74851001            |               | 1997-12-01T00:00:00 | 1999-11-30T00:00:00 |               |                         | IMM.M.M., INC                      | 15193295T | 5262 S KOLMAR AVE        |                | CHICAGO    | IL    | 60632-3750 | 0            |                  | [null, null] | 
| DEMOLITION                                     | E011442                        | 0               | E968020030           |               |                     |                     |               | DEPARTMENT OF BUILDINGS | MIDWEST WRECKING COMPANY 01        | 14878414T | 1950 W HUBBARD ST        |                | CHICAGO    | IL    | 60622      | 17500        |                  | [null, null] | 
| JANITORIAL SUPPLIES                            | T27500                         | 0               | B74851001            |               | 1997-12-01T00:00:00 | 1999-11-30T00:00:00 |               |                         | CHICAGO UNITED INDUSTRIES, LIMITED | 22085024V | 53 W JACKSON BLVD # 1450 |                | CHICAGO    | IL    | 60604-3806 | 0            |                  | [null, null] | 
| MASTER AGREEMENT FOR DEMOLITION SERVICES       | C02163                         | 0               | B89683203            |               |                     |                     |               | DEPARTMENT OF BUILDINGS | DEMOLITION & DEVELOPMENT, LIMITED. | 22414299V | P.0. BOX 10263           |                | CHICAGO    | IL    | 60610      | 7000         |                  | [null, null] | 
| MASTER AGREEMENT FOR DEMOLITION SERVICES       | C02106                         | 0               | B89683203            |               |                     |                     |               | DEPARTMENT OF BUILDINGS | DEMOLITION & DEVELOPMENT, LIMITED. | 22414299V | P.0. BOX 10263           |                | CHICAGO    | IL    | 60610      | 8200         |                  | [null, null] | 
| MIDWAY AIRPORT PARKING STRUCTURE               | P011339                        | 0               | PM50169701           |               |                     |                     |               | DEPT OF AVIATION        | MCHUGH/RITEWAY (JV)                | 25956572X | 1737 S MICHIGAN AVE      |                | CHICAGO    | IL    | 60616      | 42840000     |                  | [null, null] | 
| PARTS & SERVICE FOR TARGET CONCRETE SAWS       | T25387                         | 0               | B74455802            |               |                     |                     |               |                         | JULIE & STEVE'S ACQUISITION        | 23105142M | PORTABLE TOOL SALES&SRVS | 3228 S WOOD ST | CHICAGO    | IL    | 60608      | 22220        |                  | [null, null] | 
| PARTS, & SERVICE, HOMELITE EQUIPMENT           | T25483                         | 0               | B79364802            |               |                     |                     |               |                         | JULIE & STEVE'S ACQUISITION        | 23105142M | PORTABLE TOOL SALES&SRVS | 3228 S WOOD ST | CHICAGO    | IL    | 60608      | 68100        |                  | [null, null] | 
| RENTAL, MACHINERY & HEAVY EQUIPMENT - CITYWIDE | T25327                         | 0               | B69756601            |               |                     |                     |               |                         | JULIE & STEVE'S ACQUISITION        | 23105142M | PORTABLE TOOL SALES&SRVS | 3228 S WOOD ST | CHICAGO    | IL    | 60608      | 100000       |                  | [null, null] | 
| EMS INCIDENT REPORT DATA SYSTEM                | T27465                         | 0               | B72051107            |               |                     |                     |               |                         | ZOLL MEDICAL CORP                  | 31286790H | 32 SECOND AVE            |                | BURLINGTON | MA    |            | 1258514      |                  | [null, null] |