Employee Overtime and Supplemental Earnings 2012
Dataset
| Name | Value |
|---|---|
| Catalog | Link |
| Metadata | Link |
| Data: JSON | 100 Rows |
| Data: CSV | 100 Rows |
| Host | data.cityofchicago.org |
| Id | 92xk-4rg9 |
| Name | Employee Overtime and Supplemental Earnings 2012 |
| Attribution | City of Chicago |
| Category | Administration & Finance |
| Tags | budget, overtime, supplemental earnings |
| Created | 2011-07-14T23:11:28Z |
| Publication Date | 2015-12-04T17:50:29Z |
Description
Employee overtime and supplemental earnings by month and year-to-date. Data Owner: Budget & Management. Time Period: January 2012 to December 2012. 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_ot | Jan 2012 | money | money |
| Yes | numeric metric | feb_ot | Feb 2012 | money | money |
| Yes | numeric metric | mar_ot | Mar 2012 | money | money |
| Yes | numeric metric | apr_ot | Apr 2012 | money | money |
| Yes | numeric metric | may_ot | May 2012 | money | money |
| Yes | numeric metric | jun_ot | Jun 2012 | money | money |
| Yes | numeric metric | jul_ot | Jul 2012 | money | money |
| Yes | numeric metric | aug_ot | Aug 2012 | money | money |
| Yes | numeric metric | sept_ot | Sept 2012 | money | money |
| Yes | numeric metric | oct_2012 | Oct 2012 | money | money |
| Yes | numeric metric | nov_2012 | Nov 2012 | money | money |
| Yes | numeric metric | dec_2012 | Dec 2012 | money | money |
| Yes | numeric metric | 2012_total | 2012 Total | money | money |
Time Field
Value = 2012
Format & Zone = yyyy
Data Commands
series e:92xk-4rg9 d:2012-01-01T00:00:00.000Z t:title="ADMINISTRATIVE ASST II" t:department_name="Administrative Hearings" t:employee_name="WOODRIDGE, RACHENETTE" m:dec_2012=0 m:sept_ot=0 m:apr_ot=0 m:feb_ot=0 m:jun_ot=0 m:may_ot=0 m:aug_ot=0 m:oct_2012=0 m:nov_2012=445 m:mar_ot=0 m:jan_ot=0 m:jul_ot=0 m:2012_total=445
series e:92xk-4rg9 d:2012-01-01T00:00:00.000Z t:title="ANIMAL CARE AIDE II" t:department_name="Animal Care and Control" t:employee_name="HOLLOWAY, EFREM J" m:dec_2012=287 m:sept_ot=0 m:apr_ot=0 m:feb_ot=670 m:jun_ot=0 m:may_ot=0 m:aug_ot=0 m:oct_2012=0 m:nov_2012=0 m:mar_ot=1040 m:jan_ot=278 m:jul_ot=0 m:2012_total=2275
series e:92xk-4rg9 d:2012-01-01T00:00:00.000Z t:title="ANIMAL CONTROL OFFICER" t:department_name="Animal Care and Control" t:employee_name="EDGECOMBE, CHERYL K" m:dec_2012=514 m:sept_ot=257 m:apr_ot=0 m:feb_ot=0 m:jun_ot=637 m:may_ot=147 m:aug_ot=478 m:oct_2012=539 m:nov_2012=257 m:mar_ot=771 m:jan_ot=404 m:jul_ot=1114 m:2012_total=5118
Meta Commands
metric m:jan_ot p:double l:"Jan 2012" t:dataTypeName=money
metric m:feb_ot p:double l:"Feb 2012" t:dataTypeName=money
metric m:mar_ot p:double l:"Mar 2012" t:dataTypeName=money
metric m:apr_ot p:double l:"Apr 2012" t:dataTypeName=money
metric m:may_ot p:double l:"May 2012" t:dataTypeName=money
metric m:jun_ot p:double l:"Jun 2012" t:dataTypeName=money
metric m:jul_ot p:double l:"Jul 2012" t:dataTypeName=money
metric m:aug_ot p:double l:"Aug 2012" t:dataTypeName=money
metric m:sept_ot p:double l:"Sept 2012" t:dataTypeName=money
metric m:oct_2012 p:double l:"Oct 2012" t:dataTypeName=money
metric m:nov_2012 p:double l:"Nov 2012" t:dataTypeName=money
metric m:dec_2012 p:double l:"Dec 2012" t:dataTypeName=money
metric m:2012_total p:double l:"2012 Total" t:dataTypeName=money
entity e:92xk-4rg9 l:"Employee Overtime and Supplemental Earnings 2012" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/92xk-4rg9
property e:92xk-4rg9 t:meta.view v:id=92xk-4rg9 v:category="Administration & Finance" v:attributionLink=http://www.cityofchicago.org/city/en/depts/obm/provdrs/perf_mang/svcs/overtime_reports.html v:averageRating=0 v:name="Employee Overtime and Supplemental Earnings 2012" v:attribution="City of Chicago"
property e:92xk-4rg9 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:92xk-4rg9 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
| department_name | employee_name | title | jan_ot | feb_ot | mar_ot | apr_ot | may_ot | jun_ot | jul_ot | aug_ot | sept_ot | oct_2012 | nov_2012 | dec_2012 | 2012_total |
| ======================= | ========================== | =========================== | ====== | ====== | ====== | ====== | ====== | ====== | ====== | ====== | ======= | ======== | ======== | ======== | ========== |
| Administrative Hearings | WOODRIDGE, RACHENETTE | ADMINISTRATIVE ASST II | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 445 | 0.0 | 445 |
| Animal Care and Control | HOLLOWAY, EFREM J | ANIMAL CARE AIDE II | 278 | 670 | 1040 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 287 | 2275 |
| Animal Care and Control | EDGECOMBE, CHERYL K | ANIMAL CONTROL OFFICER | 404 | 0.0 | 771 | 0.0 | 147 | 637 | 1114 | 478 | 257 | 539 | 257 | 514 | 5118 |
| Animal Care and Control | RUGLIC, MARY S | ANIMAL CONTROL OFFICER | 0.0 | 147 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 147 |
| Animal Care and Control | WASHINGTON, MONTESE DAJUAN | VETERINARY ASST | 575 | 780 | 1135 | 492 | 657 | 913 | 1552 | 821 | 780 | 954 | 855 | 472 | 9985 |
| Animal Care and Control | CEHAJIC, TIHANA | SUPVSR OF ANIMAL CARE AIDES | 1950 | 1808 | 330 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4089 |
| Animal Care and Control | ZAVALA, VICTOR | ANIMAL CONTROL OFFICER | 0.0 | 0.0 | 1310 | 245 | 0.0 | 0.0 | 987 | 385 | 1355 | 736 | 385 | 0.0 | 5404 |
| Animal Care and Control | HAMILTON, ARTHUR | ANIMAL CARE AIDE II | 542 | 2392 | 665 | 250 | 286 | 512 | 1250 | 1190 | 637 | 250 | 0.0 | 643 | 8615 |
| Animal Care and Control | MCDONALD, KOLLEEN DENISE | ANIMAL CONTROL OFFICER | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 399 | 651 | 1862 | 1006 | 293 | 736 | 4948 |
| Animal Care and Control | MCDONALD, KOLLEEN DENISE | ANIMAL CARE AIDE II | 179 | 875 | 418 | 60 | 71 | 411 | 179 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2192 |