Lobbyist Data - Historical - Lobbyist Categorized Expenditures Report - 2010

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id zugr-hsc5
Name Lobbyist Data - Historical - Lobbyist Categorized Expenditures Report - 2010
Attribution City of Chicago
Category Ethics
Tags lobbyists, historical
Created 2011-08-30T20:25:08Z
Publication Date 2011-08-30T20:25:08Z

Description

The lobbyist categorized expenditures report is part of the Lobbyist Activity Report, a notarized disclosure that lobbyists were required to file twice during 2010 (January 20th and July 20th). Lobbyists were required to report the total amount of lobbying-related expenditures paid by the lobbyist or charged to the client in each of the categories listed on Form C, Part 3 of 3, Section H, Question 3 (http://bit.ly/q2lRTh). Data for the 2010 reporting period is limited because previous policy did not require the Board of Ethics to prioritize the reporting of all data available from paper filings. / Data Owner: Board of Ethics [http://j.mp/mbH9BN] / Time Period: 2010/ Frequency: Data is updated daily / Related Applications: Registered Lobbyist List http://j.mp/l8LwAq

Columns

| Included | Schema Type    | Field Name             | Name                   | Data Type | Render Type |
| ======== | ============== | ====================== | ====================== | ========= | =========== |
| Yes      | series tag     | last_name              | LAST NAME              | text      | text        |
| Yes      | series tag     | first_name             | FIRST NAME             | text      | text        |
| Yes      | series tag     | middle_initial         | MIDDLE INITIAL         | text      | text        |
| Yes      | series tag     | client_name            | CLIENT NAME            | text      | text        |
| Yes      | numeric metric | office_expenses        | OFFICE EXPENSES        | number    | number      |
| Yes      | numeric metric | compensation_to_others | COMPENSATION TO OTHERS | number    | number      |
| Yes      | numeric metric | public_education       | PUBLIC EDUCATION       | number    | number      |
| Yes      | numeric metric | personal_sustenance    | PERSONAL SUSTENANCE    | number    | number      |
| Yes      | numeric metric | other_expenses         | OTHER EXPENSES         | number    | number      |
| Yes      | numeric metric | total_expenses         | TOTAL EXPENSES         | number    | number      |

Time Field

Value = 2010
Format & Zone = yyyy

Data Commands

series e:zugr-hsc5 d:2010-01-01T00:00:00.000Z t:first_name=Anthony t:middle_initial=B t:last_name=Abbinante t:client_name="Diageo NA" m:office_expenses=0 m:other_expenses=0 m:compensation_to_others=0 m:personal_sustenance=0 m:public_education=0 m:total_expenses=0

series e:zugr-hsc5 d:2010-01-01T00:00:00.000Z t:first_name=Anthony t:middle_initial=B t:last_name=Abbinante t:client_name="Diageo NA" m:office_expenses=0 m:other_expenses=0 m:compensation_to_others=0 m:personal_sustenance=0 m:public_education=0 m:total_expenses=0

series e:zugr-hsc5 d:2010-01-01T00:00:00.000Z t:first_name=Anthony t:middle_initial=L t:last_name=Abboud t:client_name="108 West Germania Place, LLC" m:office_expenses=0 m:other_expenses=0 m:compensation_to_others=0 m:personal_sustenance=0 m:public_education=0 m:total_expenses=0

Meta Commands

metric m:office_expenses p:double l:"OFFICE EXPENSES" t:dataTypeName=number

metric m:compensation_to_others p:integer l:"COMPENSATION TO OTHERS" t:dataTypeName=number

metric m:public_education p:float l:"PUBLIC EDUCATION" t:dataTypeName=number

metric m:personal_sustenance p:float l:"PERSONAL SUSTENANCE" t:dataTypeName=number

metric m:other_expenses p:double l:"OTHER EXPENSES" t:dataTypeName=number

metric m:total_expenses p:double l:"TOTAL EXPENSES" t:dataTypeName=number

entity e:zugr-hsc5 l:"Lobbyist Data - Historical - Lobbyist Categorized Expenditures Report - 2010" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/zugr-hsc5

property e:zugr-hsc5 t:meta.view v:id=zugr-hsc5 v:category=Ethics v:attributionLink=http://www.cityofchicago.org/city/en/depts/ethics/provdrs/lobby.html v:averageRating=0 v:name="Lobbyist Data - Historical - Lobbyist Categorized Expenditures Report - 2010" v:attribution="City of Chicago"

property e:zugr-hsc5 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:zugr-hsc5 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

| last_name | first_name | middle_initial | client_name                  | office_expenses | compensation_to_others | public_education | personal_sustenance | other_expenses | total_expenses | 
| ========= | ========== | ============== | ============================ | =============== | ====================== | ================ | =================== | ============== | ============== | 
| Abbinante | Anthony    | B              | Diageo NA                    | 0               | 0                      | 0                | 0                   | 0              | 0              | 
| Abbinante | Anthony    | B              | Diageo NA                    | 0               | 0                      | 0                | 0                   | 0              | 0              | 
| Abboud    | Anthony    | L              | 108 West Germania Place, LLC | 0               | 0                      | 0                | 0                   | 0              | 0              | 
| Abboud    | Anthony    | L              | 108 West Germania Place, LLC | 0               | 0                      | 0                | 0                   | 0              | 0              | 
| Abboud    | Anthony    | L              | Tracfone Wireless, Inc       | 0               | 0                      | 0                | 0                   | 0              | 0              | 
| Abboud    | Anthony    | L              | 108 West Germania Place, LLC | 0               | 0                      | 0                | 0                   | 0              | 0              | 
| Acosta    | Rolando    | R              | Logan Square Kitchen         | 0               | 0                      | 0                | 0                   | 0              | 0              | 
| Acosta    | Rolando    | R              | East Lake/West End, LLC      | 0               | 0                      | 0                | 0                   | 0              | 0              | 
| Acosta    | Rolando    | R              | East Lake/West End, LLC      | 0               | 0                      | 0                | 0                   | 0              | 0              | 
| Acosta    | Rolando    | R              | Lazo's Tacos Inc             | 0               | 0                      | 0                | 0                   | 0              | 0              |