Employee Overtime and Supplemental Earnings 2013
Dataset
| Name | Value |
|---|---|
| Catalog | Link |
| Metadata | Link |
| Data: JSON | 100 Rows |
| Data: CSV | 100 Rows |
| Host | data.cityofchicago.org |
| Id | s9zb-nuc6 |
| Name | Employee Overtime and Supplemental Earnings 2013 |
| Attribution | City of Chicago |
| Category | Administration & Finance |
| Tags | budget, overtime, supplemental earnings |
| Created | 2013-07-15T04:44:33Z |
| Publication Date | 2014-02-04T00:10:56Z |
Description
Employee overtime and supplemental earnings by month and year-to-date. Data Owner: Budget & Management. Time Period: January 2013 to present. Frequency: Data is updated monthly
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 | jan_2013 | JAN 2013 | money | money |
| Yes | numeric metric | feb_2013 | FEB 2013 | money | money |
| Yes | numeric metric | mar_2013 | MAR 2013 | money | money |
| Yes | numeric metric | apr_2013 | APR 2013 | money | money |
| Yes | numeric metric | may_2013 | MAY 2013 | money | money |
| Yes | numeric metric | jun_2013 | JUN 2013 | money | money |
| Yes | numeric metric | jul_2013 | JUL 2013 | money | money |
| Yes | numeric metric | aug_2013 | AUG 2013 | money | money |
| Yes | numeric metric | sep_2013 | SEP 2013 | money | money |
| Yes | numeric metric | oct_2013 | OCT 2013 | money | money |
| Yes | numeric metric | nov_2013 | NOV 2013 | money | money |
| Yes | numeric metric | dec_2013 | DEC 2013 | money | money |
| Yes | numeric metric | grand_total | 2013 TOTAL | money | money |
Time Field
Value = 2013
Format & Zone = yyyy
Data Commands
series e:s9zb-nuc6 d:2013-01-01T00:00:00.000Z t:department_name="Animal Care and Control" t:employee_name="AGUILAR, ELMA M" t:title="ANIMAL CARE AIDE I" m:jun_2013=182.02 m:feb_2013=-22.75 m:jan_2013=887.34 m:nov_2013=500.55 m:aug_2013=1274.13 m:sep_2013=743.24 m:jul_2013=864.58 m:oct_2013=0 m:dec_2013=333.62 m:may_2013=182.02 m:mar_2013=318.53 m:apr_2013=500.55 m:grand_total=5763.83
series e:s9zb-nuc6 d:2013-01-01T00:00:00.000Z t:department_name="Animal Care and Control" t:employee_name="AGUILAR, RICARDO L" t:title="ANIMAL CONTROL OFFICER" m:jun_2013=689.4 m:feb_2013=1780.95 m:jan_2013=1531.96 m:nov_2013=2724.77 m:aug_2013=2220.03 m:sep_2013=1493.7 m:jul_2013=1612.71 m:oct_2013=2043.57 m:dec_2013=1887.64 m:may_2013=0 m:mar_2013=590.91 m:apr_2013=960.23 m:grand_total=17535.87
series e:s9zb-nuc6 d:2013-01-01T00:00:00.000Z t:department_name="Animal Care and Control" t:employee_name="ALLEN, TIMOTHY M" t:title="ANIMAL CONTROL OFFICER" m:jun_2013=0 m:feb_2013=189.14 m:jan_2013=0 m:nov_2013=189.14 m:aug_2013=0 m:sep_2013=189.14 m:jul_2013=189.14 m:oct_2013=0 m:dec_2013=189.14 m:may_2013=0 m:mar_2013=378.27 m:apr_2013=0 m:grand_total=1323.97
Meta Commands
metric m:jan_2013 p:double l:"JAN 2013" t:dataTypeName=money
metric m:feb_2013 p:double l:"FEB 2013" t:dataTypeName=money
metric m:mar_2013 p:double l:"MAR 2013" t:dataTypeName=money
metric m:apr_2013 p:double l:"APR 2013" t:dataTypeName=money
metric m:may_2013 p:double l:"MAY 2013" t:dataTypeName=money
metric m:jun_2013 p:double l:"JUN 2013" t:dataTypeName=money
metric m:jul_2013 p:double l:"JUL 2013" t:dataTypeName=money
metric m:aug_2013 p:double l:"AUG 2013" t:dataTypeName=money
metric m:sep_2013 p:double l:"SEP 2013" t:dataTypeName=money
metric m:oct_2013 p:double l:"OCT 2013" t:dataTypeName=money
metric m:nov_2013 p:double l:"NOV 2013" t:dataTypeName=money
metric m:dec_2013 p:double l:"DEC 2013" t:dataTypeName=money
metric m:grand_total p:double l:"2013 TOTAL" t:dataTypeName=money
entity e:s9zb-nuc6 l:"Employee Overtime and Supplemental Earnings 2013" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/s9zb-nuc6
property e:s9zb-nuc6 t:meta.view d:2017-09-25T07:31:37.270Z v:averageRating=0 v:name="Employee Overtime and Supplemental Earnings 2013" v:attribution="City of Chicago" v:attributionLink=http://www.cityofchicago.org v:id=s9zb-nuc6 v:category="Administration & Finance"
property e:s9zb-nuc6 t:meta.view.owner d:2017-09-25T07:31:37.270Z v:displayName="Tom Schenk Jr" v:lastNotificationSeenAt=1491330280 v:profileImageUrlLarge=/api/users/3qqc-w7ag/profile_images/LARGE v:profileImageUrlSmall=/api/users/3qqc-w7ag/profile_images/TINY v:id=3qqc-w7ag v:screenName="Tom Schenk Jr" v:profileImageUrlMedium=/api/users/3qqc-w7ag/profile_images/THUMB
property e:s9zb-nuc6 t:meta.view.tableauthor d:2017-09-25T07:31:37.270Z v:displayName="Tom Schenk Jr" v:lastNotificationSeenAt=1491330280 v:profileImageUrlLarge=/api/users/3qqc-w7ag/profile_images/LARGE v:roleName=administrator v:profileImageUrlSmall=/api/users/3qqc-w7ag/profile_images/TINY v:id=3qqc-w7ag v:screenName="Tom Schenk Jr" v:profileImageUrlMedium=/api/users/3qqc-w7ag/profile_images/THUMB
Top Records
| department_name | employee_name | title | jan_2013 | feb_2013 | mar_2013 | apr_2013 | may_2013 | jun_2013 | jul_2013 | aug_2013 | sep_2013 | oct_2013 | nov_2013 | dec_2013 | grand_total |
| ======================= | ======================= | ================================= | ======== | ======== | ======== | ======== | ======== | ======== | ======== | ======== | ======== | ======== | ======== | ======== | =========== |
| Animal Care and Control | AGUILAR, ELMA M | ANIMAL CARE AIDE I | 887.34 | -22.75 | 318.53 | 500.55 | 182.02 | 182.02 | 864.58 | 1274.13 | 743.24 | 0 | 500.55 | 333.62 | 5763.83 |
| Animal Care and Control | AGUILAR, RICARDO L | ANIMAL CONTROL OFFICER | 1531.96 | 1780.95 | 590.91 | 960.23 | 0 | 689.4 | 1612.71 | 2220.03 | 1493.7 | 2043.57 | 2724.77 | 1887.64 | 17535.87 |
| Animal Care and Control | ALLEN, TIMOTHY M | ANIMAL CONTROL OFFICER | 0 | 189.14 | 378.27 | 0 | 0 | 0 | 189.14 | 0 | 189.14 | 0 | 189.14 | 189.14 | 1323.97 |
| Animal Care and Control | AYALA, ARTHUR | ANIMAL CONTROL OFFICER | 375.47 | 0 | 189.13 | 0 | 0 | 0 | 189.14 | 972.71 | 0 | 0 | 0 | 999.73 | 2726.18 |
| Animal Care and Control | BATINICH, JACLYN M | VETERINARY ASST | 849.94 | 0 | 0 | 333.62 | 190.63 | 1139.87 | 190.64 | 285.96 | 190.64 | 0 | 381.28 | 873.77 | 4436.35 |
| Animal Care and Control | BRADFORD, MONA MICHELLE | ANIMAL CARE AIDE II | 1166.31 | 178.52 | 374.88 | 0 | 142.81 | 839.02 | 598.02 | 0 | 0 | 1262.07 | 0 | 0 | 4561.63 |
| Animal Care and Control | BRADY, DIANNE | ANIMAL CONTROL INSPECTOR | 1392.26 | 837.42 | 628.06 | 280.38 | 0 | 0 | 314.03 | 426.18 | 179.45 | 2138.41 | 2534.68 | 1516.89 | 10247.76 |
| Animal Care and Control | CALIN, MICHELLE | ANIMAL CONTROL OFFICER | 3756.27 | 0 | 1065.46 | 493.48 | 897.24 | 3566.51 | 1555.21 | 2684.22 | 2489.81 | 1749.61 | 1136.5 | 360.47 | 19754.78 |
| Animal Care and Control | CHRISTENSEN, ALTHEA | ANIMAL CARE AIDE II | 0 | 0 | 0 | 375.01 | 0 | 0 | 124.96 | 365.96 | 214.22 | 321.33 | 565.31 | 529.59 | 2496.38 |
| Animal Care and Control | CRAYTON, MARSTINE L | SUPVSR OF ANIMAL CONTROL OFFICERS | 3983.97 | 1621.4 | 1204.47 | 548.18 | 324.28 | 872.46 | 980.55 | 741.21 | 1335.71 | 2293.11 | 1814.41 | 324.28 | 16044.03 |