Employee Overtime and Supplemental Earnings 2015
Dataset
| Name | Value |
|---|---|
| Catalog | Link |
| Metadata | Link |
| Data: JSON | 100 Rows |
| Data: CSV | 100 Rows |
| Host | data.cityofchicago.org |
| Id | efd5-hyfi |
| Name | Employee Overtime and Supplemental Earnings 2015 |
| Attribution | City of Chicago |
| Category | Administration & Finance |
| Tags | budget |
| Created | 2015-07-03T01:02:40Z |
| Publication Date | 2016-03-25T22:28:45Z |
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 | employee_name | EMPLOYEE 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 = 2015
Format & Zone = yyyy
Data Commands
series e:efd5-hyfi d:2015-01-01T00:00:00.000Z t:title="Animal Care Aide I" t:department_name="Animal Care and Control" t:employee_name="Aguilar, Elma M" m:total=6670.1 m:december=388.59 m:november=388.59 m:february=997.63 m:june=439.68 m:january=1642.95 m:august=388.59 m:july=388.59 m:october=1147.27 m:september=888.21
series e:efd5-hyfi d:2015-01-01T00:00:00.000Z t:title="Animal Control Officer" t:department_name="Animal Care and Control" t:employee_name="Aguilar, Ricardo L" m:total=25432.49 m:december=2190.49 m:may=2186.62 m:november=2101.44 m:march=740.64 m:april=171.93 m:february=1190.3 m:june=1274.06 m:january=3012.89 m:august=5614.23 m:july=1313.39 m:october=2657.96 m:september=2978.54
series e:efd5-hyfi d:2015-01-01T00:00:00.000Z t:title="Animal Control Officer" t:department_name="Animal Care and Control" t:employee_name="Allen, Timothy M" m:total=1944.66 m:december=195.82 m:november=195.82 m:march=193.88 m:february=387.76 m:january=579.74 m:october=195.82 m:september=195.82
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:efd5-hyfi l:"Employee Overtime and Supplemental Earnings 2015" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/efd5-hyfi
property e:efd5-hyfi t:meta.view v:id=efd5-hyfi v:category="Administration & Finance" v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="Employee Overtime and Supplemental Earnings 2015" v:attribution="City of Chicago"
property e:efd5-hyfi 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:efd5-hyfi 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 | employee_name | title | january | february | march | april | may | june | july | august | september | october | november | december | total |
| ======================= | ======================= | ======================== | ======= | ======== | ======= | ====== | ======= | ======= | ======= | ======= | ========= | ======= | ======== | ======== | ======== |
| Animal Care and Control | Aguilar, Elma M | Animal Care Aide I | 1642.95 | 997.63 | | | | 439.68 | 388.59 | 388.59 | 888.21 | 1147.27 | 388.59 | 388.59 | 6670.10 |
| Animal Care and Control | Aguilar, Ricardo L | Animal Control Officer | 3012.89 | 1190.30 | 740.64 | 171.93 | 2186.62 | 1274.06 | 1313.39 | 5614.23 | 2978.54 | 2657.96 | 2101.44 | 2190.49 | 25432.49 |
| Animal Care and Control | Allen, Timothy M | Animal Control Officer | 579.74 | 387.76 | 193.88 | | | | | | 195.82 | 195.82 | 195.82 | 195.82 | 1944.66 |
| Animal Care and Control | Allison, John L | Animal Control Officer | 1129.37 | 337.36 | 168.68 | 156.63 | | 168.68 | 304.24 | 795.09 | 2008.01 | 1419.80 | 1277.82 | 669.34 | 8435.02 |
| Animal Care and Control | Ayala, Arthur | Animal Control Officer | 383.95 | 387.76 | | 387.76 | | 387.76 | 391.64 | 783.28 | | 685.37 | 195.82 | | 3603.34 |
| Animal Care and Control | Batinich, Jaclyn M | Veterinarian Assistant | 918.87 | 577.57 | 420.06 | 420.06 | 210.03 | 787.60 | 1210.87 | 905.94 | 813.14 | 1202.04 | 1714.67 | 371.22 | 9552.07 |
| Animal Care and Control | Bradford, Mona Michelle | Animal Care Aide II | 476.07 | 494.54 | 590.71 | | 2294.14 | | 596.66 | | 291.39 | 985.19 | 291.39 | 208.14 | 6228.23 |
| Animal Care and Control | Brady, Dianne | Animal Control Inspector | 2117.00 | 706.84 | 504.89 | 138.84 | 479.65 | 353.42 | | 1189.85 | 1801.77 | 905.13 | 1121.86 | 896.63 | 10215.88 |
| Animal Care and Control | Caballero, Jorge | Animal Control Officer | 234.21 | 384.77 | 895.01 | 724.92 | 1095.75 | 585.52 | 903.37 | 2141.34 | 677.46 | 481.80 | 306.60 | 1226.42 | 9657.17 |
| Animal Care and Control | Calin, Michelle | Animal Control Officer | 2518.39 | 1253.05 | 2072.38 | 771.12 | 1325.35 | 1783.20 | 1709.94 | 4462.26 | 2287.92 | 389.43 | 2190.57 | 2774.73 | 23538.34 |