List of Contractors Doing Business with the City Of Chicago

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id 5wd9-d675
Name List of Contractors Doing Business with the City Of Chicago
Attribution City of Chicago
Category Administration & Finance
Tags payments, vendors
Created 2014-08-13T22:03:12Z
Publication Date 2014-09-03T15:42:14Z

Description

In accordance with the Governmental Ethics Ordinance, the Department of Innovation & Technology provides the following list of current and former contractors who, during the preceding four reporting years, received from the City of Chicago payments totaling $10,000 or more in any 12 consecutive months period. The data source for this list is the Financial Management and Purchasing Systems (FMPS).

Columns

| Included | Schema Type | Field Name     | Name           | Data Type | Render Type |
| ======== | =========== | ============== | ============== | ========= | =========== |
| No       | time        | :updated_at    | updated_at     | meta_data | meta_data   |
| Yes      | series tag  | vendor_id      | VENDOR ID      | text      | text        |
| Yes      | series tag  | vendor         | VENDOR         | text      | text        |
| No       |             | address_line_1 | ADDRESS LINE 1 | text      | text        |
| No       |             | address_line_2 | ADDRESS LINE 2 | text      | text        |
| Yes      | series tag  | city           | CITY           | text      | text        |
| Yes      | series tag  | state          | STATE          | text      | text        |
| Yes      | series tag  | zip_code       | ZIP CODE       | text      | text        |

Time Field

Value = updated_at
Format & Zone = seconds

Series Fields

Excluded Fields = address_line_1,address_line_2

Data Commands

series e:5wd9-d675 d:2014-09-03T08:41:22.000Z t:zip_code=60416 t:vendor="""D"" CONSTRUCTION, INC." t:state=IL t:vendor_id=94192177E t:city="COAL CITY" m:row_number.5wd9-d675=1

series e:5wd9-d675 d:2014-09-03T08:41:22.000Z t:zip_code=60601 t:vendor="""READING IN MOTION""" t:state=IL t:vendor_id=93428432T t:city=CHICAGO m:row_number.5wd9-d675=2

series e:5wd9-d675 d:2014-09-03T08:41:22.000Z t:zip_code=60611 t:vendor="100 CLUB OF CHICAGO" t:state=IL t:vendor_id=50092043 t:city=CHICAGO m:row_number.5wd9-d675=3

Meta Commands

metric m:row_number.5wd9-d675 p:long l:"Row Number"

entity e:5wd9-d675 l:"List of Contractors Doing Business with the City Of Chicago" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/5wd9-d675

property e:5wd9-d675 t:meta.view v:id=5wd9-d675 v:category="Administration & Finance" v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="List of Contractors Doing Business with the City Of Chicago" v:attribution="City of Chicago"

property e:5wd9-d675 t:meta.view.owner v:id=3qqc-w7ag v:profileImageUrlMedium=/api/users/3qqc-w7ag/profile_images/THUMB v:profileImageUrlLarge=/api/users/3qqc-w7ag/profile_images/LARGE v:screenName="Tom Schenk Jr" v:profileImageUrlSmall=/api/users/3qqc-w7ag/profile_images/TINY v:lastNotificationSeenAt=1491330280 v:displayName="Tom Schenk Jr"

property e:5wd9-d675 t:meta.view.tableauthor v:id=3qqc-w7ag v:profileImageUrlMedium=/api/users/3qqc-w7ag/profile_images/THUMB v:profileImageUrlLarge=/api/users/3qqc-w7ag/profile_images/LARGE v:screenName="Tom Schenk Jr" v:profileImageUrlSmall=/api/users/3qqc-w7ag/profile_images/TINY v:roleName=administrator v:lastNotificationSeenAt=1491330280 v:displayName="Tom Schenk Jr"

Top Records

| :updated_at | vendor_id | vendor                            | address_line_1                   | address_line_2             | city      | state | zip_code | 
| =========== | ========= | ================================= | ================================ | ========================== | ========= | ===== | ======== | 
| 1409733682  | 94192177E | "D" CONSTRUCTION, INC.            | 1488 S BROADWAY                  |                            | COAL CITY | IL    | 60416    | 
| 1409733682  | 93428432T | "READING IN MOTION"               | 65 E WACKER DR 1800 EFT          |                            | CHICAGO   | IL    | 60601    | 
| 1409733682  | 50092043  | 100 CLUB OF CHICAGO               | 875 N MICHIGAN AVENUE SUITE 1351 |                            | CHICAGO   | IL    | 60611    | 
| 1409733682  | 1047177   | 1020 BUILDING PARTNERSHIP         | C/O DON GARFIELD                 | 9420 S. STONEY ISLAND AVE  | CHICAGO   | IL    | 60617    | 
| 1409733682  | 93744130Z | 104TH STREET LPSH                 | C/O MERCY HOUSING LAKEFRONT      | 120 S LA SALLE ST STE 1850 | CHICAGO   | IL    | 60603    | 
| 1409733682  | 94328711Z | 10GEN, INC.                       | 555 UNIVERSITY AVENUE EFT        |                            | PALO ALTO | CA    | 94301    | 
| 1409733682  | 85249964Z | 1140 NORTH BRANCH DEVELOPMENT LLC | 701 W ERIE ST                    |                            | CHICAGO   | IL    | 60610    | 
| 1409733682  | 55480108  | 1200 SAINT JAMES LLC.             | 4201 WEST 36TH STREET            |                            | CHICAGO   | IL    | 60632    | 
| 1409733682  | 54718021  | 1240 SOUTH WABASH CORP            | 2901 WEST ESTES                  |                            | CHICAGO   | IL    | 60645    | 
| 1409733682  | 85247677X | 1301 ELSTON LLC                   | 1250 W DIVISION ST               |                            | CHICAGO   | IL    | 60622    |