Employee Overtime and Supplemental Earnings 2016

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id tsqz-67gi
Name Employee Overtime and Supplemental Earnings 2016
Attribution City of Chicago
Category Administration & Finance
Tags budget
Created 2016-07-02T02:25:41Z
Publication Date 2017-03-18T02:26:31Z

Description

Employee overtime and supplemental earnings by month and year-to-date

Columns

| Included | Schema Type    | Field Name      | Name            | Data Type | Render Type |
| ======== | ============== | =============== | =============== | ========= | =========== |
| Yes      | series tag     | department_name | DEPARTMENT NAME | text      | text        |
| Yes      | series tag     | name            | NAME            | text      | text        |
| Yes      | series tag     | title           | TITLE           | text      | text        |
| Yes      | numeric metric | january         | JANUARY         | money     | money       |
| Yes      | numeric metric | february        | FEBRUARY        | money     | money       |
| Yes      | numeric metric | march           | MARCH           | money     | money       |
| Yes      | numeric metric | april           | APRIL           | money     | money       |
| Yes      | numeric metric | may             | MAY             | money     | money       |
| Yes      | numeric metric | june            | JUNE            | money     | money       |
| Yes      | numeric metric | july            | JULY            | money     | money       |
| Yes      | numeric metric | august          | AUGUST          | money     | money       |
| Yes      | numeric metric | september       | SEPTEMBER       | money     | money       |
| Yes      | numeric metric | october         | OCTOBER         | money     | money       |
| Yes      | numeric metric | november        | NOVEMBER        | money     | money       |
| Yes      | numeric metric | december        | DECEMBER        | money     | money       |
| Yes      | numeric metric | total           | TOTAL           | money     | money       |

Time Field

Value = 2016
Format & Zone = yyyy

Data Commands

series e:tsqz-67gi d:2016-01-01T00:00:00.000Z t:title="Animal Control Officer" t:name="Loza, Ernesto" t:department_name="Animal Care and Control" m:total=16364.37 m:december=1291.2 m:may=633.4 m:november=2669.2 m:march=234.59 m:april=1008.75 m:february=1391.92 m:june=1345 m:january=2406.4 m:august=1333.28 m:july=1548.31 m:october=1298.08 m:september=1204.24

series e:tsqz-67gi d:2016-01-01T00:00:00.000Z t:title="Animal Care Aide I" t:name="Aguilar, Elma M" t:department_name="Animal Care and Control" m:total=3629.67 m:december=396.42 m:may=186.89 m:november=226.52 m:march=616.74 m:april=560.67 m:february=532.63 m:june=0 m:january=392.47 m:august=141.58 m:july=0 m:october=198.21 m:september=377.54

series e:tsqz-67gi d:2016-01-01T00:00:00.000Z t:title="Animal Control Officer" t:name="Williams Jr, Eli" t:department_name="Animal Care and Control" m:total=1293.28 m:december=519.36 m:may=0 m:november=259.68 m:march=0 m:april=0 m:february=257.12 m:june=0 m:january=257.12 m:august=0 m:july=0 m:october=0 m:september=0

Meta Commands

metric m:january p:double l:JANUARY t:dataTypeName=money

metric m:february p:double l:FEBRUARY t:dataTypeName=money

metric m:march p:double l:MARCH t:dataTypeName=money

metric m:april p:double l:APRIL t:dataTypeName=money

metric m:may p:double l:MAY t:dataTypeName=money

metric m:june p:double l:JUNE t:dataTypeName=money

metric m:july p:double l:JULY t:dataTypeName=money

metric m:august p:double l:AUGUST t:dataTypeName=money

metric m:september p:double l:SEPTEMBER t:dataTypeName=money

metric m:october p:double l:OCTOBER t:dataTypeName=money

metric m:november p:double l:NOVEMBER t:dataTypeName=money

metric m:december p:double l:DECEMBER t:dataTypeName=money

metric m:total p:double l:TOTAL t:dataTypeName=money

entity e:tsqz-67gi l:"Employee Overtime and Supplemental Earnings 2016" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/tsqz-67gi

property e:tsqz-67gi t:meta.view v:id=tsqz-67gi v:category="Administration & Finance" v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="Employee Overtime and Supplemental Earnings 2016" v:attribution="City of Chicago"

property e:tsqz-67gi 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:tsqz-67gi 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

| department_name         | name                | title                    | january | february | march  | april   | may     | june    | july    | august  | september | october | november | december | total    | 
| ======================= | =================== | ======================== | ======= | ======== | ====== | ======= | ======= | ======= | ======= | ======= | ========= | ======= | ======== | ======== | ======== | 
| Animal Care and Control | Loza, Ernesto       | Animal Control Officer   | 2406.40 | 1391.92  | 234.59 | 1008.75 | 633.40  | 1345    | 1548.31 | 1333.28 | 1204.24   | 1298.08 | 2669.20  | 1291.20  | 16364.37 | 
| Animal Care and Control | Aguilar, Elma M     | Animal Care Aide I       | 392.47  | 532.63   | 616.74 | 560.67  | 186.89  | 0       | 0       | 141.58  | 377.54    | 198.21  | 226.52   | 396.42   | 3629.67  | 
| Animal Care and Control | Williams Jr, Eli    | Animal Control Officer   | 257.12  | 257.12   | 0      | 0       | 0       | 0       | 0       | 0       | 0         | 0       | 259.68   | 519.36   | 1293.28  | 
| Animal Care and Control | Howard, Maryann J   | Animal Control Inspector | 340.75  | 729.26   | 0      | 0       | 0       | 0       | 0       | 0       | 0         | 0       | 0        | 208.09   | 1278.10  | 
| Animal Care and Control | Eldridge, Michael E | Animal Control Officer   | 0       | 0        | 0      | 0       | 0       | 0       | 0       | 0       | 0         | 0       | 0        | 1342.53  | 1342.53  | 
| Animal Care and Control | Allison, John L     | Animal Control Officer   | 0       | 344.15   | 344.15 | 344.15  | 1765.79 | 704.69  | 1857.32 | 0       | 1549.52   | 884.21  | 861.80   | 2106.89  | 10762.67 | 
| Animal Care and Control | Allen, Timothy M    | Animal Control Officer   | 197.79  | 197.79   | 197.79 | 0       | 0       | 197.79  | 197.79  | 0       | 197.79    | 197.79  | 0        | 199.77   | 1584.30  | 
| Animal Care and Control | Tuider, Colleen T   | Dispatch Clerk           | 307.94  | 307.94   | 307.94 | 0       | 571.89  | 351.93  | 819.06  | 925.56  | 310.98    | 1362.41 | 488.69   | 1451.26  | 7205.60  | 
| Animal Care and Control | Hernandez, Miguel   | Animal Control Officer   | 653.61  | 328.43   | 0      | 0       | 437.91  | 0       | 0       | 0       | 0         | 0       | 247.67   | 173.80   | 1841.42  | 
| Animal Care and Control | Brady, Dianne       | Animal Control Inspector | 360.55  | 502.19   | 360.55 | 373.43  | 965.77  | 1068.78 | 746.86  | 824.13  | 862.75    | 476.44  | 1218.18  | 572.24   | 8331.87  |