For my Coding Camp final project I will be exploring a dataset of active current city employees from the Chicago Data Portal. The purpose of exploring this data is to identify which jobs could I potentially focus on and apply for after leaving my current position at the City and County of San Francisco (SFPUC Water Conservation Section). Since there are many Chicago city positions at various departments, I would like to know about all desirable positions (examining part-time or full-time, and by pay) and to filter and visualize all I may have translatable job experience or availability for.

The data’s dedicated webpage with full summary is linked here: https://data.cityofchicago.org/Administration-Finance/Current-Employee-Names-Salaries-and-Position-Title/xzkq-xp2w. The data can be downloaded directly from here: https://data.cityofchicago.org/api/views/xzkq-xp2w/rows.csv?accessType=DOWNLOAD.

chicago_city_jobs <- read_csv(paste0("https://data.cityofchicago.org/api/views/xzkq-xp2w/rows.csv?accessType=DOWNLOAD"))
## Parsed with column specification:
## cols(
##   Name = col_character(),
##   `Job Titles` = col_character(),
##   Department = col_character(),
##   `Full or Part-Time` = col_character(),
##   `Salary or Hourly` = col_character(),
##   `Typical Hours` = col_double(),
##   `Annual Salary` = col_double(),
##   `Hourly Rate` = col_double()
## )
# Computing and displaying the dataset characteristics
dim(chicago_city_jobs)
## [1] 32928     8
colnames(chicago_city_jobs)
## [1] "Name"              "Job Titles"        "Department"       
## [4] "Full or Part-Time" "Salary or Hourly"  "Typical Hours"    
## [7] "Annual Salary"     "Hourly Rate"
for (c in colnames(chicago_city_jobs)) {
  typeof(chicago_city_jobs[[c]])
}
# After characterizing the dataset, let's explore its content

chicago_city_jobs_head <- head(chicago_city_jobs)
chicago_city_jobs_tail <- tail(chicago_city_jobs)

library(ggplot2)
chi_salary_viz <- qplot(x = `Job Titles`, y = `Annual Salary`, data = chicago_city_jobs)
chi_salary_viz
## Warning: Removed 7631 rows containing missing values (geom_point).

library(ggplot2)
chi_salary_viz <- qplot(x = `Job Titles`, y = `Hourly Rate`, data = chicago_city_jobs)
chi_salary_viz
## Warning: Removed 25297 rows containing missing values (geom_point).

Noticing here that there are very many city job titles, which makes the scatter plot a bit overwhelming and hard to pull useful information from. You can also tell that there are considerably more salaried city positions than hourly, which makes sense.

# Examine annual salary and hourly wages by Department
library(ggplot2)
chi_salary_viz <- qplot(x = `Department`, y = `Annual Salary`, data = chicago_city_jobs)
chi_salary_viz
## Warning: Removed 7631 rows containing missing values (geom_point).

library(ggplot2)
chi_salary_viz <- qplot(x = `Department`, y = `Hourly Rate`, data = chicago_city_jobs)
chi_salary_viz
## Warning: Removed 25297 rows containing missing values (geom_point).

Still, while there are less city departments than job title rows in the dataset, the plot remains busy. It may be useful to start taking a closer look at only a handful of jobs and departments

#  Determine unique values are present in Department column

all_chicago_depts <- (unique(chicago_city_jobs$Department))

print(all_chicago_depts)
##  [1] "POLICE"              "DAIS"                "WATER MGMNT"        
##  [4] "TRANSPORTN"          "OEMC"                "AVIATION"           
##  [7] "FIRE"                "FAMILY & SUPPORT"    "LAW"                
## [10] "STREETS & SAN"       "HEALTH"              "FINANCE"            
## [13] "BUSINESS AFFAIRS"    "HUMAN RESOURCES"     "PUBLIC LIBRARY"     
## [16] "CITY COUNCIL"        "CULTURAL AFFAIRS"    "COPA"               
## [19] "HOUSING"             "PROCUREMENT"         "BUILDINGS"          
## [22] "ANIMAL CONTRL"       "HOUSING & ECON DEV"  "BOARD OF ELECTION"  
## [25] "PUBLIC SAFETY ADMIN" "DISABILITIES"        "CITY CLERK"         
## [28] "INSPECTOR GEN"       "HUMAN RELATIONS"     "MAYOR'S OFFICE"     
## [31] "TREASURER"           "BUDGET & MGMT"       "BOARD OF ETHICS"    
## [34] "ADMIN HEARNG"        "POLICE BOARD"        "LICENSE APPL COMM"
#  Determine unique values are present in Job Titles columns
all_chicago_job_titles <- (unique(chicago_city_jobs$`Job Titles`))

# We observe the job title list is extensively longer than the departments. To avoid it fully running and taking space, we will use glimpse() here instead of print()

glimpse(all_chicago_job_titles)
##  chr [1:1107] "SERGEANT" "POLICE OFFICER (ASSIGNED AS DETECTIVE)" ...

Based on previous work experience (LinkedIn: https://www.linkedin.com/in/earnestsalgado/) it looks like I can go for positions in Water and Human Resources. Let’s filter to these two departments and see if there are any desirable positions.

# Filtering for water department jobs

chicago_water_jobs <- chicago_city_jobs %>%
  filter(`Department` == "WATER MGMNT") %>%
  select(`Job Titles`, Department, `Annual Salary`, `Typical Hours`, `Hourly Rate`, `Full or Part-Time`) %>% 
  arrange(-`Annual Salary`)

print(chicago_water_jobs$`Job Titles`)
##    [1] "COMMISSIONER OF WATER MGMT"                   
##    [2] "FIRST DEPUTY COMMISSIONER"                    
##    [3] "MANAGING DEPUTY COMMISSIONER"                 
##    [4] "MANAGING DEPUTY COMMISSIONER"                 
##    [5] "CHIEF PLUMBING INSPECTOR"                     
##    [6] "CHIEF PROGRAMMER/ANALYST"                     
##    [7] "DIRECTOR OF LEGAL SERVICES"                   
##    [8] "DEPUTY COMMISSIONER"                          
##    [9] "DEPUTY COMMISSIONER"                          
##   [10] "SUPT OF CONSTRUCTION AND MAINTENANCE"         
##   [11] "DEPUTY COMMISSIONER"                          
##   [12] "DEPUTY COMMISSIONER"                          
##   [13] "CHIEF OPERATING ENGINEER"                     
##   [14] "CHIEF OPERATING ENGINEER"                     
##   [15] "CHIEF OPERATING ENGINEER"                     
##   [16] "CHIEF OPERATING ENGINEER"                     
##   [17] "CHIEF OPERATING ENGINEER"                     
##   [18] "CHIEF OPERATING ENGINEER"                     
##   [19] "CHIEF OPERATING ENGINEER"                     
##   [20] "CHIEF OPERATING ENGINEER"                     
##   [21] "CHIEF OPERATING ENGINEER"                     
##   [22] "ENGINEER OF WATER PUMPING"                    
##   [23] "COORDINATING ENGINEER II"                     
##   [24] "DEPUTY COMMISSIONER"                          
##   [25] "CHIEF ENGINEER OF SEWERS"                     
##   [26] "CHIEF WATER ENGINEER"                         
##   [27] "FILTRATION ENGINEER V"                        
##   [28] "FILTRATION ENGINEER V"                        
##   [29] "CHIEF WATER CHEMIST"                          
##   [30] "FILTRATION ENGINEER V"                        
##   [31] "FILTRATION ENGINEER V"                        
##   [32] "FILTRATION ENGINEER V"                        
##   [33] "FILTRATION ENGINEER V"                        
##   [34] "FILTRATION ENGINEER V"                        
##   [35] "SUPT OF CONSTRUCTION AND MAINTENANCE"         
##   [36] "MANAGER OF AUDIT AND INTERNAL CONTROLS"       
##   [37] "ENGINEER OF WATER PURIFICATION"               
##   [38] "DEPUTY COMMISSIONER"                          
##   [39] "DEPUTY COMMISSIONER"                          
##   [40] "ASST CHIEF PLUMBING INSPECTOR"                
##   [41] "CHIEF MICROBIOLOGIST"                         
##   [42] "GEN SUPT OF WATER MANAGEMENT"                 
##   [43] "GEN SUPT OF WATER MANAGEMENT"                 
##   [44] "GEN SUPT OF WATER MANAGEMENT"                 
##   [45] "GEN SUPT OF WATER MANAGEMENT"                 
##   [46] "ASST ENGINEER OF WATER PUMPING"               
##   [47] "GEN SUPT OF WATER MANAGEMENT"                 
##   [48] "GEN SUPT OF WATER MANAGEMENT"                 
##   [49] "GEN SUPT OF WATER MANAGEMENT"                 
##   [50] "ENGINEER OF ELECTRIC PUMPING STATIONS"        
##   [51] "DIR OF WATER PURIFICATION LABORATORIES"       
##   [52] "ASST DISTRICT SUPERINTENDENT"                 
##   [53] "ASST DISTRICT SUPERINTENDENT"                 
##   [54] "ASST DISTRICT SUPERINTENDENT"                 
##   [55] "ASST DISTRICT SUPERINTENDENT"                 
##   [56] "ASST DISTRICT SUPERINTENDENT"                 
##   [57] "ASST DISTRICT SUPERINTENDENT"                 
##   [58] "ASST DISTRICT SUPERINTENDENT"                 
##   [59] "ASST DISTRICT SUPERINTENDENT"                 
##   [60] "ASST DISTRICT SUPERINTENDENT"                 
##   [61] "ASST DISTRICT SUPERINTENDENT"                 
##   [62] "ASST DISTRICT SUPERINTENDENT"                 
##   [63] "ASST DISTRICT SUPERINTENDENT"                 
##   [64] "ASST DISTRICT SUPERINTENDENT"                 
##   [65] "ASST DISTRICT SUPERINTENDENT"                 
##   [66] "ASST DISTRICT SUPERINTENDENT"                 
##   [67] "ENGINEERING TECHNICIAN VI"                    
##   [68] "CHIEF CONTRACT EXPEDITER"                     
##   [69] "ENGINEERING TECHNICIAN VI"                    
##   [70] "ENGINEERING TECHNICIAN VI"                    
##   [71] "GENERAL FOREMAN OF HOISTING ENGINEERS"        
##   [72] "ASST COMMISSIONER"                            
##   [73] "CIVIL ENGINEER IV"                            
##   [74] "CIVIL ENGINEER IV"                            
##   [75] "FILTRATION ENGINEER IV"                       
##   [76] "FILTRATION ENGINEER IV"                       
##   [77] "CIVIL ENGINEER IV"                            
##   [78] "CIVIL ENGINEER IV"                            
##   [79] "CIVIL ENGINEER IV"                            
##   [80] "CIVIL ENGINEER IV"                            
##   [81] "MECHANICAL ENGINEER IV"                       
##   [82] "MANAGING ENGINEER - WATER MANAGEMENT"         
##   [83] "DIR OF WATER QUALITY SURVEILLANCE"            
##   [84] "MANAGING ENGINEER - WATER MANAGEMENT"         
##   [85] "GENERAL FOREMAN OF ELECTRICAL MECHANICS"      
##   [86] "GENERAL FOREMAN OF ELECTRICAL MECHANICS"      
##   [87] "GENERAL FOREMAN OF ELECTRICAL MECHANICS"      
##   [88] "FINANCIAL OFFICER"                            
##   [89] "COORDINATING ENGINEER II"                     
##   [90] "COORD OF TUGBOAT OPERATIONS"                  
##   [91] "CHIEF MASON INSPECTOR"                        
##   [92] "SUPERINTENDENT OF WATER METERS"               
##   [93] "DIR OF PUBLIC AFFAIRS"                        
##   [94] "DIR OF NEWS AFFAIRS"                          
##   [95] "SUPERVISING HOUSE DRAIN INSPECTOR"            
##   [96] "PLUMBING INSPECTOR I/C"                       
##   [97] "PLUMBING INSPECTOR I/C"                       
##   [98] "GENERAL FOREMAN OF CARPENTERS"                
##   [99] "ASST COMMISSIONER"                            
##  [100] "DISTRICT SUPERINTENDENT OF WATER DISTRIBUTION"
##  [101] "HOUSE DRAIN INSPECTOR"                        
##  [102] "PLUMBING INSPECTOR"                           
##  [103] "HOUSE DRAIN INSPECTOR"                        
##  [104] "PLUMBING INSPECTOR"                           
##  [105] "PLUMBING INSPECTOR"                           
##  [106] "PLUMBING INSPECTOR"                           
##  [107] "PLUMBING INSPECTOR"                           
##  [108] "PLUMBING INSPECTOR"                           
##  [109] "PLUMBING INSPECTOR"                           
##  [110] "PLUMBING INSPECTOR"                           
##  [111] "PLUMBING INSPECTOR"                           
##  [112] "HOUSE DRAIN INSPECTOR"                        
##  [113] "HOUSE DRAIN INSPECTOR"                        
##  [114] "PLUMBING INSPECTOR"                           
##  [115] "PLUMBING INSPECTOR"                           
##  [116] "PLUMBING INSPECTOR"                           
##  [117] "PLUMBING INSPECTOR"                           
##  [118] "PLUMBING INSPECTOR"                           
##  [119] "PLUMBING INSPECTOR"                           
##  [120] "PLUMBING INSPECTOR"                           
##  [121] "PLUMBING INSPECTOR"                           
##  [122] "PLUMBING INSPECTOR"                           
##  [123] "PLUMBING INSPECTOR"                           
##  [124] "PLUMBING INSPECTOR"                           
##  [125] "PLUMBING INSPECTOR"                           
##  [126] "PLUMBING INSPECTOR"                           
##  [127] "HOUSE DRAIN INSPECTOR"                        
##  [128] "PLUMBING INSPECTOR"                           
##  [129] "HOUSE DRAIN INSPECTOR"                        
##  [130] "PLUMBING INSPECTOR"                           
##  [131] "HOUSE DRAIN INSPECTOR"                        
##  [132] "HOUSE DRAIN INSPECTOR"                        
##  [133] "PLUMBING INSPECTOR"                           
##  [134] "HOUSE DRAIN INSPECTOR"                        
##  [135] "PLUMBING INSPECTOR"                           
##  [136] "COORDINATING ENGINEER I"                      
##  [137] "COORDINATING ENGINEER I"                      
##  [138] "COORDINATING ENGINEER I"                      
##  [139] "COORDINATING ENGINEER I"                      
##  [140] "COORDINATING ENGINEER I"                      
##  [141] "ASST COMMISSIONER"                            
##  [142] "FILTRATION ENGINEER IV"                       
##  [143] "WATER CONSERVATION ENGINEER"                  
##  [144] "MASON INSPECTOR"                              
##  [145] "MASON INSPECTOR"                              
##  [146] "MASON INSPECTOR"                              
##  [147] "MASON INSPECTOR"                              
##  [148] "MASON INSPECTOR"                              
##  [149] "MASON INSPECTOR"                              
##  [150] "MASON INSPECTOR"                              
##  [151] "MASON INSPECTOR"                              
##  [152] "MASON INSPECTOR"                              
##  [153] "MASON INSPECTOR"                              
##  [154] "MASON INSPECTOR"                              
##  [155] "ENGINEERING TECHNICIAN V"                     
##  [156] "ENGINEERING TECHNICIAN VI"                    
##  [157] "ENGINEERING TECHNICIAN V"                     
##  [158] "ENGINEERING TECHNICIAN V"                     
##  [159] "ASST COMMISSIONER"                            
##  [160] "CIVIL ENGINEER III"                           
##  [161] "MICROBIOLOGIST IV"                            
##  [162] "CIVIL ENGINEER III"                           
##  [163] "SANITARY ENGINEER III"                        
##  [164] "CIVIL ENGINEER III"                           
##  [165] "CIVIL ENGINEER III"                           
##  [166] "WATER CHEMIST IV"                             
##  [167] "WATER CHEMIST IV"                             
##  [168] "CIVIL ENGINEER III"                           
##  [169] "FILTRATION ENGINEER III"                      
##  [170] "MECHANICAL ENGINEER III"                      
##  [171] "CIVIL ENGINEER III"                           
##  [172] "CIVIL ENGINEER III"                           
##  [173] "FILTRATION ENGINEER III"                      
##  [174] "WATER CHEMIST IV"                             
##  [175] "ASSISTANT DIRECTOR OF FINANCE"                
##  [176] "ASST TO THE COMMISSIONER"                     
##  [177] "ENGINEERING TECHNICIAN V"                     
##  [178] "SUPVSR OF WATER RATE TAKERS"                  
##  [179] "DISTRICT SUPERINTENDENT OF WATER DISTRIBUTION"
##  [180] "ASST TO THE COMMISSIONER"                     
##  [181] "CIVIL ENGINEER V"                             
##  [182] "PROJECTS ADMINISTRATOR"                       
##  [183] "ASST SUPT OF WATER METERS"                    
##  [184] "STAFF ASST"                                   
##  [185] "SUPVSR OF COST CONTROL"                       
##  [186] "ENGINEERING TECHNICIAN IV"                    
##  [187] "SAFETY SPECIALIST - WATER MGMT"               
##  [188] "SAFETY SPECIALIST - WATER MGMT"               
##  [189] "WATER RATE TAKER"                             
##  [190] "WATER RATE TAKER"                             
##  [191] "WATER RATE TAKER"                             
##  [192] "SUPVSR OF WATER RATE TAKERS"                  
##  [193] "WATER RATE TAKER"                             
##  [194] "WATER RATE TAKER"                             
##  [195] "CIVIL ENGINEER II"                            
##  [196] "WATER CHEMIST III"                            
##  [197] "WATER CHEMIST III"                            
##  [198] "FILTRATION ENGINEER II"                       
##  [199] "CIVIL ENGINEER II"                            
##  [200] "MICROBIOLOGIST III"                           
##  [201] "MICROBIOLOGIST III"                           
##  [202] "MICROBIOLOGIST III"                           
##  [203] "WATER CHEMIST III"                            
##  [204] "FILTRATION ENGINEER IV"                       
##  [205] "CIVIL ENGINEER IV"                            
##  [206] "FILTRATION ENGINEER IV"                       
##  [207] "ASST COMMISSIONER"                            
##  [208] "ASST COMMISSIONER"                            
##  [209] "ASST COMMISSIONER"                            
##  [210] "FINANCIAL ANALYST"                            
##  [211] "ASST TO THE COMMISSIONER"                     
##  [212] "SAFETY SPECIALIST - WATER MGMT"               
##  [213] "SUPVSR OF ACCOUNTING"                         
##  [214] "CONTRACTS ADMINISTRATOR"                      
##  [215] "FILTRATION ENGINEER IV"                       
##  [216] "FILTRATION ENGINEER IV"                       
##  [217] "PROJECTS ADMINISTRATOR"                       
##  [218] "CIVIL ENGINEER V"                             
##  [219] "WATER CHEMIST II"                             
##  [220] "WATER CHEMIST II"                             
##  [221] "WATER CHEMIST II"                             
##  [222] "MICROBIOLOGIST II"                            
##  [223] "WATER CHEMIST II"                             
##  [224] "WATER CHEMIST II"                             
##  [225] "WATER CHEMIST II"                             
##  [226] "WATER CHEMIST II"                             
##  [227] "WATER CHEMIST II"                             
##  [228] "WATER CHEMIST II"                             
##  [229] "ADMINISTRATIVE ASST III"                      
##  [230] "ACCOUNTING TECHNICIAN III"                    
##  [231] "SUPERVISING CLERK"                            
##  [232] "ADMINISTRATIVE ASST III"                      
##  [233] "ADMINISTRATIVE ASST III"                      
##  [234] "ENGINEERING TECHNICIAN IV"                    
##  [235] "WATER RATE TAKER"                             
##  [236] "WATER METER ASSESSOR"                         
##  [237] "SAFETY SPECIALIST - WATER MGMT"               
##  [238] "WATER RATE TAKER"                             
##  [239] "WATER RATE TAKER"                             
##  [240] "SAFETY SPECIALIST - WATER MGMT"               
##  [241] "WATER RATE TAKER"                             
##  [242] "WATER RATE TAKER"                             
##  [243] "WATER RATE TAKER"                             
##  [244] "ATTORNEY"                                     
##  [245] "ELECTRICAL ENGINEER IV"                       
##  [246] "PROJECTS ADMINISTRATOR"                       
##  [247] "PROJECTS ADMINISTRATOR"                       
##  [248] "ADMINISTRATIVE ASST III"                      
##  [249] "SAFETY SPECIALIST - WATER MGMT"               
##  [250] "FILTRATION ENGINEER IV"                       
##  [251] "FILTRATION ENGINEER IV"                       
##  [252] "ADMINISTRATIVE ASST III"                      
##  [253] "CLERK IV - TIMEKEEPER"                        
##  [254] "CLERK IV - TIMEKEEPER"                        
##  [255] "PROCUREMENT CONTROL OFFICER"                  
##  [256] "LABORATORY TECHNICIAN III"                    
##  [257] "CLERK IV - TIMEKEEPER"                        
##  [258] "CLERK IV - TIMEKEEPER"                        
##  [259] "CLERK IV - TIMEKEEPER"                        
##  [260] "STAFF ASST"                                   
##  [261] "SANITARY ENGINEER III"                        
##  [262] "ADMIN SERVICES OFFICER I-EXCLUDED"            
##  [263] "ASST CHIEF DISPATCHER"                        
##  [264] "ADMIN SERVICES OFFICER I-EXCLUDED"            
##  [265] "ASST TO THE COMMISSIONER"                     
##  [266] "CLERK IV - TIMEKEEPER"                        
##  [267] "ADMINISTRATIVE ASST III"                      
##  [268] "STAFF ASST"                                   
##  [269] "ASST TO THE COMMISSIONER"                     
##  [270] "WATER CHEMIST III"                            
##  [271] "WATER CHEMIST III"                            
##  [272] "ADMIN SERVICES OFFICER I-EXCLUDED"            
##  [273] "STAFF ASSISTANT - EXCLUDED"                   
##  [274] "CONTRACTS COORD"                              
##  [275] "ADMINISTRATIVE ASST III"                      
##  [276] "ADMINISTRATIVE ASST II"                       
##  [277] "ADMINISTRATIVE ASST II"                       
##  [278] "PROCUREMENT CONTROL OFFICER"                  
##  [279] "CLERK IV"                                     
##  [280] "CLERK IV"                                     
##  [281] "SANITARY ENGINEER III"                        
##  [282] "PERSONAL COMPUTER OPERATOR III"               
##  [283] "SANITARY ENGINEER III"                        
##  [284] "FILTRATION ENGINEER III"                      
##  [285] "SANITARY ENGINEER III"                        
##  [286] "ADMINISTRATIVE ASST II"                       
##  [287] "CIVIL ENGINEER III"                           
##  [288] "ACCOUNTING TECHNICIAN I"                      
##  [289] "ADMINISTRATIVE ASST II"                       
##  [290] "CLERK IV - TIMEKEEPER"                        
##  [291] "ADMINISTRATIVE ASST II"                       
##  [292] "ADMINISTRATIVE ASST II"                       
##  [293] "CLERK IV - TIMEKEEPER"                        
##  [294] "FILTRATION ENGINEER II"                       
##  [295] "WATER CHEMIST II"                             
##  [296] "WATER CHEMIST II"                             
##  [297] "SANITARY ENGINEER II"                         
##  [298] "WATER CHEMIST II"                             
##  [299] "FILTRATION ENGINEER II"                       
##  [300] "PROJECTS ADMINISTRATOR"                       
##  [301] "STAFF ASSISTANT - EXCLUDED"                   
##  [302] "HEAD STOREKEEPER"                             
##  [303] "SANITARY ENGINEER II"                         
##  [304] "SANITARY ENGINEER II"                         
##  [305] "PERSONAL COMPUTER OPERATOR II"                
##  [306] "PERSONAL COMPUTER OPERATOR II"                
##  [307] "CLERK IV"                                     
##  [308] "DISTRICT CLERK"                               
##  [309] "PROJECT COORD"                                
##  [310] "SANITARY ENGINEER II"                         
##  [311] "FILTRATION ENGINEER II"                       
##  [312] "SANITARY ENGINEER II"                         
##  [313] "SANITARY ENGINEER II"                         
##  [314] "SANITARY ENGINEER II"                         
##  [315] "SANITARY ENGINEER II"                         
##  [316] "FILTRATION ENGINEER II"                       
##  [317] "FILTRATION ENGINEER II"                       
##  [318] "SANITARY ENGINEER II"                         
##  [319] "SANITARY ENGINEER II"                         
##  [320] "FILTRATION ENGINEER II"                       
##  [321] "SAFETY SPECIALIST - WATER MGMT"               
##  [322] "WATER QUALITY INSPECTOR"                      
##  [323] "WATER RATE TAKER"                             
##  [324] "WATER RATE TAKER"                             
##  [325] "WATER METER ASSESSOR"                         
##  [326] "WATER RATE TAKER"                             
##  [327] "WATER RATE TAKER"                             
##  [328] "WATER RATE TAKER"                             
##  [329] "WATER RATE TAKER"                             
##  [330] "WATER METER ASSESSOR"                         
##  [331] "WATER CHEMIST II"                             
##  [332] "WATER CHEMIST II"                             
##  [333] "DATA ENTRY OPERATOR"                          
##  [334] "CLERK III"                                    
##  [335] "DATA ENTRY OPERATOR"                          
##  [336] "CLERK III"                                    
##  [337] "COORD OF SECURITY SERVICES"                   
##  [338] "STAFF ASST"                                   
##  [339] "WATER CHEMIST II"                             
##  [340] "WATER CHEMIST II"                             
##  [341] "WATER CHEMIST II"                             
##  [342] "ASSOCIATE STAFF ATTORNEY"                     
##  [343] "SENIOR DATA ENTRY OPERATOR"                   
##  [344] "ADMINISTRATIVE ASST III"                      
##  [345] "WATER METER ASSESSOR"                         
##  [346] "FOREMAN OF STATION LABORERS"                  
##  [347] "DATA ENTRY OPERATOR"                          
##  [348] "DATA ENTRY OPERATOR"                          
##  [349] "EXEC ADMINISTRATIVE ASST I"                   
##  [350] "DISTRICT CLERK"                               
##  [351] "DISTRICT CLERK"                               
##  [352] "DISTRICT CLERK"                               
##  [353] "ADMIN SERVICES OFFICER I-EXCLUDED"            
##  [354] "DISTRICT CLERK"                               
##  [355] "DISTRICT CLERK"                               
##  [356] "ADMINISTRATIVE ASST II"                       
##  [357] "STATION LABORER"                              
##  [358] "STATION LABORER"                              
##  [359] "STATION LABORER"                              
##  [360] "ADMINISTRATIVE ASST II"                       
##  [361] "DISTRICT CLERK"                               
##  [362] "ADMINISTRATIVE ASST II"                       
##  [363] "OPERATING ENGINEER-GROUP C"                   
##  [364] "SEWER BRICKLAYER"                             
##  [365] "FOREMAN OF WATER PIPE CONSTRUCTION"           
##  [366] "STEAMFITTER"                                  
##  [367] "CONSTRUCTION LABORER"                         
##  [368] "LABORER - APPRENTICE"                         
##  [369] "CONSTRUCTION LABORER"                         
##  [370] "CONSTRUCTION LABORER"                         
##  [371] "CONSTRUCTION LABORER"                         
##  [372] "FOREMAN OF WATER PIPE CONSTRUCTION"           
##  [373] "LABORER - APPRENTICE"                         
##  [374] "HOISTING ENGINEER"                            
##  [375] "CONSTRUCTION LABORER"                         
##  [376] "OPERATING ENGINEER-GROUP A"                   
##  [377] "MOTOR TRUCK DRIVER"                           
##  [378] "OPERATING ENGINEER-GROUP A"                   
##  [379] "HOISTING ENGINEER"                            
##  [380] "PAINTER"                                      
##  [381] "CONSTRUCTION LABORER"                         
##  [382] "POOL MOTOR TRUCK DRIVER"                      
##  [383] "OPERATING ENGINEER-GROUP A"                   
##  [384] "MOTOR TRUCK DRIVER"                           
##  [385] "MOTOR TRUCK DRIVER"                           
##  [386] "SEWER BRICKLAYER"                             
##  [387] "CONSTRUCTION LABORER"                         
##  [388] "OPERATING ENGINEER-GROUP A"                   
##  [389] "HOISTING ENGINEER"                            
##  [390] "MOTOR TRUCK DRIVER"                           
##  [391] "OPERATING ENGINEER-GROUP A"                   
##  [392] "EMERGENCY CREW DISPATCHER"                    
##  [393] "CONSTRUCTION LABORER"                         
##  [394] "CONSTRUCTION LABORER"                         
##  [395] "CONSTRUCTION LABORER"                         
##  [396] "CONSTRUCTION LABORER"                         
##  [397] "MOTOR TRUCK DRIVER"                           
##  [398] "CONSTRUCTION LABORER"                         
##  [399] "HOISTING ENGINEER"                            
##  [400] "CONSTRUCTION LABORER"                         
##  [401] "MOTOR TRUCK DRIVER"                           
##  [402] "CONSTRUCTION LABORER"                         
##  [403] "ELECTRICAL MECHANIC"                          
##  [404] "CARPENTER"                                    
##  [405] "CONSTRUCTION LABORER"                         
##  [406] "MOTOR TRUCK DRIVER"                           
##  [407] "CONSTRUCTION LABORER"                         
##  [408] "CONSTRUCTION LABORER"                         
##  [409] "CONSTRUCTION LABORER"                         
##  [410] "MOTOR TRUCK DRIVER"                           
##  [411] "CONSTRUCTION LABORER"                         
##  [412] "CONSTRUCTION LABORER"                         
##  [413] "EMERGENCY CREW DISPATCHER"                    
##  [414] "CONSTRUCTION LABORER"                         
##  [415] "MOTOR TRUCK DRIVER"                           
##  [416] "WATCHMAN"                                     
##  [417] "FOREMAN OF PLUMBERS"                          
##  [418] "ELECTRICAL MECHANIC"                          
##  [419] "POOL MOTOR TRUCK DRIVER"                      
##  [420] "CONSTRUCTION LABORER"                         
##  [421] "ELECTRICAL MECHANIC"                          
##  [422] "ELECTRICAL MECHANIC"                          
##  [423] "CONSTRUCTION LABORER"                         
##  [424] "OPERATING ENGINEER-GROUP A"                   
##  [425] "STATIONARY FIREMAN"                           
##  [426] "HOISTING ENGINEER"                            
##  [427] "CONSTRUCTION LABORER"                         
##  [428] "ASST CHIEF OPERATING ENGINEER"                
##  [429] "OPERATING ENGINEER-GROUP C"                   
##  [430] "HOISTING ENGINEER"                            
##  [431] "MOTOR TRUCK DRIVER"                           
##  [432] "POOL MOTOR TRUCK DRIVER"                      
##  [433] "OPERATING ENGINEER-GROUP A"                   
##  [434] "CONSTRUCTION LABORER"                         
##  [435] "MOTOR TRUCK DRIVER"                           
##  [436] "ELECTRICAL MECHANIC"                          
##  [437] "EMERGENCY CREW DISPATCHER"                    
##  [438] "PLUMBER"                                      
##  [439] "CONSTRUCTION LABORER"                         
##  [440] "CONSTRUCTION LABORER"                         
##  [441] "CONSTRUCTION LABORER"                         
##  [442] "PLUMBER"                                      
##  [443] "CONSTRUCTION LABORER"                         
##  [444] "LABORER - APPRENTICE"                         
##  [445] "CONSTRUCTION LABORER"                         
##  [446] "CONSTRUCTION LABORER"                         
##  [447] "STATIONARY FIREMAN"                           
##  [448] "OPERATING ENGINEER-GROUP C"                   
##  [449] "HOISTING ENGINEER"                            
##  [450] "CONSTRUCTION LABORER"                         
##  [451] "LABORER - APPRENTICE"                         
##  [452] "CONSTRUCTION LABORER"                         
##  [453] "OPERATING ENGINEER-GROUP C"                   
##  [454] "MOTOR TRUCK DRIVER"                           
##  [455] "CONSTRUCTION LABORER"                         
##  [456] "CONSTRUCTION LABORER"                         
##  [457] "MOTOR TRUCK DRIVER"                           
##  [458] "CONSTRUCTION LABORER"                         
##  [459] "LABORER - APPRENTICE"                         
##  [460] "OPERATING ENGINEER-GROUP A"                   
##  [461] "POOL MOTOR TRUCK DRIVER"                      
##  [462] "CONSTRUCTION LABORER"                         
##  [463] "OPERATING ENGINEER-GROUP C"                   
##  [464] "PLUMBER"                                      
##  [465] "MACHINIST"                                    
##  [466] "ELECTRICAL MECHANIC"                          
##  [467] "CONSTRUCTION LABORER"                         
##  [468] "HOISTING ENGINEER"                            
##  [469] "HOISTING ENGINEER"                            
##  [470] "MOTOR TRUCK DRIVER"                           
##  [471] "PLUMBER"                                      
##  [472] "PLUMBER"                                      
##  [473] "ELECTRICAL MECHANIC"                          
##  [474] "PLUMBER"                                      
##  [475] "LABORER - APPRENTICE"                         
##  [476] "CONSTRUCTION LABORER"                         
##  [477] "CONSTRUCTION LABORER"                         
##  [478] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
##  [479] "CONSTRUCTION LABORER"                         
##  [480] "FOREMAN OF CONSTRUCTION LABORERS"             
##  [481] "HOISTING ENGINEER"                            
##  [482] "MOTOR TRUCK DRIVER"                           
##  [483] "PLUMBER"                                      
##  [484] "PLUMBER"                                      
##  [485] "CONSTRUCTION LABORER"                         
##  [486] "WATCHMAN"                                     
##  [487] "MOTOR TRUCK DRIVER"                           
##  [488] "PLUMBER"                                      
##  [489] "MOTOR TRUCK DRIVER"                           
##  [490] "MOTOR TRUCK DRIVER"                           
##  [491] "POOL MOTOR TRUCK DRIVER"                      
##  [492] "CONSTRUCTION LABORER"                         
##  [493] "OPERATING ENGINEER-GROUP A"                   
##  [494] "MOTOR TRUCK DRIVER"                           
##  [495] "CONSTRUCTION LABORER"                         
##  [496] "CONSTRUCTION LABORER"                         
##  [497] "CONSTRUCTION LABORER"                         
##  [498] "POOL MOTOR TRUCK DRIVER"                      
##  [499] "ELECTRICAL MECHANIC"                          
##  [500] "MOTOR TRUCK DRIVER"                           
##  [501] "CEMENT FINISHER"                              
##  [502] "OPERATING ENGINEER-GROUP A"                   
##  [503] "CONSTRUCTION LABORER"                         
##  [504] "CONSTRUCTION LABORER"                         
##  [505] "ELECTRICAL MECHANIC"                          
##  [506] "OPERATING ENGINEER-GROUP C"                   
##  [507] "MOTOR TRUCK DRIVER"                           
##  [508] "MOTOR TRUCK DRIVER"                           
##  [509] "PLUMBER"                                      
##  [510] "LABORER - APPRENTICE"                         
##  [511] "PLUMBER"                                      
##  [512] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
##  [513] "POOL MOTOR TRUCK DRIVER"                      
##  [514] "CONSTRUCTION LABORER"                         
##  [515] "LABORER - APPRENTICE"                         
##  [516] "PLUMBER"                                      
##  [517] "CONSTRUCTION LABORER"                         
##  [518] "WATCHMAN"                                     
##  [519] "PLUMBER"                                      
##  [520] "CONSTRUCTION LABORER"                         
##  [521] "ELECTRICAL MECHANIC"                          
##  [522] "CONSTRUCTION LABORER"                         
##  [523] "STATIONARY FIREMAN"                           
##  [524] "CONSTRUCTION LABORER"                         
##  [525] "CONSTRUCTION LABORER"                         
##  [526] "CONSTRUCTION LABORER"                         
##  [527] "CONSTRUCTION LABORER"                         
##  [528] "POOL MOTOR TRUCK DRIVER"                      
##  [529] "OPERATING ENGINEER-GROUP C"                   
##  [530] "OPERATING ENGINEER-GROUP A"                   
##  [531] "MOTOR TRUCK DRIVER"                           
##  [532] "CONSTRUCTION LABORER"                         
##  [533] "OPERATING ENGINEER-GROUP C"                   
##  [534] "CONSTRUCTION LABORER"                         
##  [535] "ASST CHIEF OPERATING ENGINEER"                
##  [536] "ELECTRICAL MECHANIC"                          
##  [537] "CUSTODIAL WORKER"                             
##  [538] "OPERATING ENGINEER-GROUP C"                   
##  [539] "CONSTRUCTION LABORER"                         
##  [540] "PLUMBER"                                      
##  [541] "WATCHMAN"                                     
##  [542] "CONSTRUCTION LABORER"                         
##  [543] "CONSTRUCTION LABORER"                         
##  [544] "CONSTRUCTION LABORER"                         
##  [545] "CONSTRUCTION LABORER"                         
##  [546] "EMERGENCY CREW DISPATCHER"                    
##  [547] "CONSTRUCTION LABORER"                         
##  [548] "LABORER - APPRENTICE"                         
##  [549] "PIPE LOCATING MACHINE OPERATOR"               
##  [550] "CONSTRUCTION LABORER"                         
##  [551] "FOREMAN OF WATER PIPE CONSTRUCTION"           
##  [552] "STEAMFITTER"                                  
##  [553] "MOTOR TRUCK DRIVER"                           
##  [554] "OPERATING ENGINEER-GROUP A"                   
##  [555] "MACHINIST"                                    
##  [556] "ASST CHIEF OPERATING ENGINEER"                
##  [557] "CONSTRUCTION LABORER"                         
##  [558] "PLUMBER"                                      
##  [559] "CONSTRUCTION LABORER"                         
##  [560] "MACHINIST"                                    
##  [561] "FOREMAN OF PIPE / SALVAGE YARDS"              
##  [562] "HOISTING ENGINEER"                            
##  [563] "HOISTING ENGINEER"                            
##  [564] "WATCHMAN"                                     
##  [565] "HOISTING ENGINEER"                            
##  [566] "STEAMFITTER"                                  
##  [567] "FOREMAN OF WATER PIPE CONSTRUCTION"           
##  [568] "SEWER BRICKLAYER"                             
##  [569] "WATER METER MACHINIST"                        
##  [570] "CONSTRUCTION LABORER"                         
##  [571] "OPERATING ENGINEER-GROUP A"                   
##  [572] "LABORER - APPRENTICE"                         
##  [573] "CONSTRUCTION LABORER"                         
##  [574] "HOISTING ENGINEER"                            
##  [575] "ASST CHIEF OPERATING ENGINEER"                
##  [576] "CONSTRUCTION LABORER"                         
##  [577] "SEWER BRICKLAYER"                             
##  [578] "STATIONARY FIREMAN"                           
##  [579] "FOREMAN OF MACHINISTS"                        
##  [580] "OPERATING ENGINEER-GROUP A"                   
##  [581] "CONSTRUCTION LABORER"                         
##  [582] "CONSTRUCTION LABORER"                         
##  [583] "HOISTING ENGINEER"                            
##  [584] "CONSTRUCTION LABORER"                         
##  [585] "CONSTRUCTION LABORER"                         
##  [586] "PLUMBER"                                      
##  [587] "MOTOR TRUCK DRIVER"                           
##  [588] "SEWER BRICKLAYER"                             
##  [589] "HOISTING ENGINEER"                            
##  [590] "OPERATING ENGINEER-GROUP C"                   
##  [591] "PLUMBER"                                      
##  [592] "LABORER - APPRENTICE"                         
##  [593] "MOTOR TRUCK DRIVER"                           
##  [594] "HOISTING ENGINEER"                            
##  [595] "CONSTRUCTION LABORER"                         
##  [596] "WATER METER MACHINIST"                        
##  [597] "SEWER BRICKLAYER"                             
##  [598] "MOTOR TRUCK DRIVER"                           
##  [599] "PLUMBER"                                      
##  [600] "PLUMBER"                                      
##  [601] "ASST CHIEF OPERATING ENGINEER"                
##  [602] "PLUMBER"                                      
##  [603] "FOREMAN OF CONSTRUCTION LABORERS"             
##  [604] "CONSTRUCTION LABORER"                         
##  [605] "PLUMBER"                                      
##  [606] "PAINTER"                                      
##  [607] "OPERATING ENGINEER-GROUP C"                   
##  [608] "CONSTRUCTION LABORER"                         
##  [609] "HOISTING ENGINEER"                            
##  [610] "CONSTRUCTION LABORER"                         
##  [611] "CONSTRUCTION LABORER"                         
##  [612] "HOISTING ENGINEER"                            
##  [613] "HOISTING ENGINEER"                            
##  [614] "HOISTING ENGINEER"                            
##  [615] "OPERATING ENGINEER-GROUP C"                   
##  [616] "ELECTRICAL MECHANIC"                          
##  [617] "CONSTRUCTION LABORER"                         
##  [618] "CONSTRUCTION LABORER"                         
##  [619] "CONSTRUCTION LABORER"                         
##  [620] "STEAMFITTER"                                  
##  [621] "CONSTRUCTION LABORER"                         
##  [622] "HOISTING ENGINEER"                            
##  [623] "CONSTRUCTION LABORER"                         
##  [624] "ASST CHIEF OPERATING ENGINEER"                
##  [625] "CONSTRUCTION LABORER"                         
##  [626] "CONSTRUCTION LABORER"                         
##  [627] "ELECTRICAL MECHANIC"                          
##  [628] "HOISTING ENGINEER"                            
##  [629] "CONSTRUCTION LABORER"                         
##  [630] "FOREMAN OF CONSTRUCTION LABORERS"             
##  [631] "MOTOR TRUCK DRIVER"                           
##  [632] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
##  [633] "OPERATING ENGINEER-GROUP C"                   
##  [634] "CONSTRUCTION LABORER"                         
##  [635] "CONSTRUCTION LABORER"                         
##  [636] "CONSTRUCTION LABORER"                         
##  [637] "CONSTRUCTION LABORER"                         
##  [638] "HOISTING ENGINEER"                            
##  [639] "CONSTRUCTION LABORER"                         
##  [640] "CONSTRUCTION LABORER"                         
##  [641] "CONSTRUCTION LABORER"                         
##  [642] "OPERATING ENGINEER-GROUP A"                   
##  [643] "OPERATING ENGINEER-GROUP C"                   
##  [644] "PLUMBER"                                      
##  [645] "SEWER BRICKLAYER"                             
##  [646] "CONSTRUCTION LABORER"                         
##  [647] "CONSTRUCTION LABORER"                         
##  [648] "CONSTRUCTION LABORER"                         
##  [649] "PAINTER"                                      
##  [650] "CONSTRUCTION LABORER"                         
##  [651] "SEWER BRICKLAYER"                             
##  [652] "HOISTING ENGINEER"                            
##  [653] "ASST CHIEF OPERATING ENGINEER"                
##  [654] "CONSTRUCTION LABORER"                         
##  [655] "CONSTRUCTION LABORER"                         
##  [656] "PLUMBER"                                      
##  [657] "PLUMBER"                                      
##  [658] "CONSTRUCTION LABORER"                         
##  [659] "PLUMBER"                                      
##  [660] "FOREMAN OF SEWER BRICKLAYERS"                 
##  [661] "CONSTRUCTION LABORER"                         
##  [662] "ASST CHIEF OPERATING ENGINEER"                
##  [663] "CONSTRUCTION LABORER"                         
##  [664] "MOTOR TRUCK DRIVER"                           
##  [665] "WATCHMAN"                                     
##  [666] "WATCHMAN"                                     
##  [667] "CONSTRUCTION LABORER"                         
##  [668] "FOREMAN OF SEWER CLEANING"                    
##  [669] "SEWER BRICKLAYER"                             
##  [670] "ELECTRICAL MECHANIC"                          
##  [671] "MOTOR TRUCK DRIVER"                           
##  [672] "LABORER - APPRENTICE"                         
##  [673] "CONSTRUCTION LABORER"                         
##  [674] "MOTOR TRUCK DRIVER"                           
##  [675] "OPERATING ENGINEER-GROUP C"                   
##  [676] "PLUMBER"                                      
##  [677] "PLUMBER"                                      
##  [678] "HOISTING ENGINEER"                            
##  [679] "OPERATING ENGINEER-GROUP A"                   
##  [680] "OPERATING ENGINEER-GROUP A"                   
##  [681] "HOISTING ENGINEER"                            
##  [682] "FOREMAN OF WATER PIPE CONSTRUCTION"           
##  [683] "CONSTRUCTION LABORER"                         
##  [684] "ASST CHIEF OPERATING ENGINEER"                
##  [685] "MOTOR TRUCK DRIVER"                           
##  [686] "HOISTING ENGINEER"                            
##  [687] "ELECTRICAL MECHANIC"                          
##  [688] "PLUMBER"                                      
##  [689] "WATCHMAN"                                     
##  [690] "OPERATING ENGINEER-GROUP C"                   
##  [691] "CONSTRUCTION LABORER"                         
##  [692] "ELECTRICAL MECHANIC"                          
##  [693] "FOREMAN OF WATER PIPE CONSTRUCTION"           
##  [694] "CONSTRUCTION LABORER"                         
##  [695] "OPERATING ENGINEER-GROUP A"                   
##  [696] "OPERATING ENGINEER-GROUP C"                   
##  [697] "FOREMAN OF WATER PIPE CONSTRUCTION"           
##  [698] "OPERATING ENGINEER-GROUP A"                   
##  [699] "CONSTRUCTION LABORER"                         
##  [700] "OPERATING ENGINEER-GROUP C"                   
##  [701] "ELECTRICAL MECHANIC"                          
##  [702] "CONSTRUCTION LABORER"                         
##  [703] "MOTOR TRUCK DRIVER"                           
##  [704] "CONSTRUCTION LABORER"                         
##  [705] "HOISTING ENGINEER"                            
##  [706] "STEAMFITTER"                                  
##  [707] "OPERATING ENGINEER-GROUP C"                   
##  [708] "OPERATING ENGINEER-GROUP C"                   
##  [709] "PLUMBER"                                      
##  [710] "PLUMBER"                                      
##  [711] "OPERATING ENGINEER-GROUP A"                   
##  [712] "LABORER - APPRENTICE"                         
##  [713] "ASST CHIEF OPERATING ENGINEER"                
##  [714] "CUSTODIAL WORKER"                             
##  [715] "CONSTRUCTION LABORER"                         
##  [716] "MOTOR TRUCK DRIVER"                           
##  [717] "STEAMFITTER"                                  
##  [718] "CONSTRUCTION LABORER"                         
##  [719] "MACHINIST"                                    
##  [720] "ELECTRICAL MECHANIC"                          
##  [721] "MOTOR TRUCK DRIVER"                           
##  [722] "OPERATING ENGINEER-GROUP C"                   
##  [723] "MOTOR TRUCK DRIVER"                           
##  [724] "CONSTRUCTION LABORER"                         
##  [725] "MOTOR TRUCK DRIVER"                           
##  [726] "MOTOR TRUCK DRIVER"                           
##  [727] "HOISTING ENGINEER"                            
##  [728] "CONSTRUCTION LABORER"                         
##  [729] "HOISTING ENGINEER"                            
##  [730] "HOISTING ENGINEER"                            
##  [731] "PLUMBER"                                      
##  [732] "MOTOR TRUCK DRIVER"                           
##  [733] "CONSTRUCTION LABORER"                         
##  [734] "MOTOR TRUCK DRIVER"                           
##  [735] "HOISTING ENGINEER"                            
##  [736] "OPERATING ENGINEER-GROUP C"                   
##  [737] "PLUMBER"                                      
##  [738] "EMERGENCY CREW DISPATCHER"                    
##  [739] "ELECTRICAL MECHANIC"                          
##  [740] "OPERATING ENGINEER-GROUP C"                   
##  [741] "STATIONARY FIREMAN"                           
##  [742] "CEMENT FINISHER"                              
##  [743] "FOREMAN OF SEWER BRICKLAYERS"                 
##  [744] "MACHINIST"                                    
##  [745] "MOTOR TRUCK DRIVER"                           
##  [746] "CONSTRUCTION LABORER"                         
##  [747] "MOTOR TRUCK DRIVER"                           
##  [748] "OPERATING ENGINEER-GROUP C"                   
##  [749] "LABORER - APPRENTICE"                         
##  [750] "WATCHMAN"                                     
##  [751] "MOTOR TRUCK DRIVER"                           
##  [752] "CONSTRUCTION LABORER"                         
##  [753] "CONSTRUCTION LABORER"                         
##  [754] "PLUMBER"                                      
##  [755] "POOL MOTOR TRUCK DRIVER"                      
##  [756] "HOISTING ENGINEER"                            
##  [757] "HOISTING ENGINEER"                            
##  [758] "PLUMBER"                                      
##  [759] "CONSTRUCTION LABORER"                         
##  [760] "LABORER - APPRENTICE"                         
##  [761] "PLUMBER"                                      
##  [762] "MACHINIST"                                    
##  [763] "STATIONARY FIREMAN"                           
##  [764] "ASST CHIEF OPERATING ENGINEER"                
##  [765] "PLUMBER"                                      
##  [766] "HOISTING ENGINEER"                            
##  [767] "OPERATING ENGINEER-GROUP C"                   
##  [768] "CONSTRUCTION LABORER"                         
##  [769] "PLUMBER"                                      
##  [770] "HOISTING ENGINEER"                            
##  [771] "HOISTING ENGINEER"                            
##  [772] "MARINE ENGINEER"                              
##  [773] "OPERATING ENGINEER-GROUP C"                   
##  [774] "CONSTRUCTION LABORER"                         
##  [775] "CONSTRUCTION LABORER"                         
##  [776] "PAINTER"                                      
##  [777] "PLUMBER"                                      
##  [778] "EMERGENCY CREW DISPATCHER"                    
##  [779] "OPERATING ENGINEER-GROUP C"                   
##  [780] "WATCHMAN"                                     
##  [781] "HOISTING ENGINEER"                            
##  [782] "STATIONARY FIREMAN"                           
##  [783] "FOREMAN OF WATER PIPE CONSTRUCTION"           
##  [784] "HOISTING ENGINEER"                            
##  [785] "OPERATING ENGINEER-GROUP C"                   
##  [786] "OPERATING ENGINEER-GROUP C"                   
##  [787] "CONSTRUCTION LABORER"                         
##  [788] "CONSTRUCTION LABORER"                         
##  [789] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
##  [790] "CEMENT FINISHER"                              
##  [791] "CONSTRUCTION LABORER"                         
##  [792] "CAULKER"                                      
##  [793] "PLUMBER"                                      
##  [794] "CONSTRUCTION LABORER"                         
##  [795] "CONSTRUCTION LABORER"                         
##  [796] "MOTOR TRUCK DRIVER"                           
##  [797] "CONSTRUCTION LABORER"                         
##  [798] "HOISTING ENGINEER"                            
##  [799] "PLUMBER"                                      
##  [800] "HOISTING ENGINEER"                            
##  [801] "HOISTING ENGINEER"                            
##  [802] "WATCHMAN"                                     
##  [803] "OPERATING ENGINEER-GROUP A"                   
##  [804] "FOREMAN OF WATER PIPE CONSTRUCTION"           
##  [805] "CONSTRUCTION LABORER"                         
##  [806] "MOTOR TRUCK DRIVER"                           
##  [807] "MOTOR TRUCK DRIVER"                           
##  [808] "FOREMAN OF PLUMBERS"                          
##  [809] "CONSTRUCTION LABORER"                         
##  [810] "CONSTRUCTION LABORER"                         
##  [811] "CONSTRUCTION LABORER"                         
##  [812] "OPERATING ENGINEER-GROUP C"                   
##  [813] "HOISTING ENGINEER"                            
##  [814] "FOREMAN OF WATER PIPE CONSTRUCTION"           
##  [815] "STATIONARY FIREMAN"                           
##  [816] "SEWER BRICKLAYER"                             
##  [817] "HOISTING ENGINEER"                            
##  [818] "ELECTRICAL MECHANIC"                          
##  [819] "FOREMAN OF MACHINISTS"                        
##  [820] "ASST CHIEF OPERATING ENGINEER"                
##  [821] "HOISTING ENGINEER"                            
##  [822] "CONSTRUCTION LABORER"                         
##  [823] "PLUMBER"                                      
##  [824] "STEAMFITTER"                                  
##  [825] "HOISTING ENGINEER"                            
##  [826] "POOL MOTOR TRUCK DRIVER"                      
##  [827] "WATER METER MACHINIST"                        
##  [828] "FOREMAN OF ELECTRICAL MECHANICS"              
##  [829] "HOISTING ENGINEER"                            
##  [830] "STEAMFITTER"                                  
##  [831] "CARPENTER"                                    
##  [832] "WATER METER MACHINIST"                        
##  [833] "OPERATING ENGINEER-GROUP A"                   
##  [834] "OPERATING ENGINEER-GROUP C"                   
##  [835] "CAULKER"                                      
##  [836] "WATCHMAN"                                     
##  [837] "WATER METER MACHINIST"                        
##  [838] "CUSTODIAL WORKER"                             
##  [839] "PAINTER"                                      
##  [840] "HOISTING ENGINEER"                            
##  [841] "CONSTRUCTION LABORER"                         
##  [842] "LABORER - APPRENTICE"                         
##  [843] "POOL MOTOR TRUCK DRIVER"                      
##  [844] "OPERATING ENGINEER-GROUP C"                   
##  [845] "CONSTRUCTION LABORER"                         
##  [846] "MOTOR TRUCK DRIVER"                           
##  [847] "CONSTRUCTION LABORER"                         
##  [848] "PLUMBER"                                      
##  [849] "OPERATING ENGINEER-GROUP A"                   
##  [850] "STEAMFITTER"                                  
##  [851] "CONSTRUCTION LABORER"                         
##  [852] "CONSTRUCTION LABORER"                         
##  [853] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
##  [854] "CONSTRUCTION LABORER"                         
##  [855] "ASST CHIEF OPERATING ENGINEER"                
##  [856] "STATIONARY FIREMAN"                           
##  [857] "CONSTRUCTION LABORER"                         
##  [858] "CONSTRUCTION LABORER"                         
##  [859] "ASST CHIEF OPERATING ENGINEER"                
##  [860] "MOTOR TRUCK DRIVER"                           
##  [861] "HOISTING ENGINEER"                            
##  [862] "OPERATING ENGINEER-GROUP A"                   
##  [863] "CEMENT FINISHER"                              
##  [864] "CUSTODIAL WORKER"                             
##  [865] "CONSTRUCTION LABORER"                         
##  [866] "OPERATING ENGINEER-GROUP C"                   
##  [867] "CONSTRUCTION LABORER"                         
##  [868] "MOTOR TRUCK DRIVER"                           
##  [869] "ELECTRICAL MECHANIC"                          
##  [870] "CONSTRUCTION LABORER"                         
##  [871] "OPERATING ENGINEER-GROUP A"                   
##  [872] "MOTOR TRUCK DRIVER"                           
##  [873] "CONSTRUCTION LABORER"                         
##  [874] "MOTOR TRUCK DRIVER"                           
##  [875] "LABORER - APPRENTICE"                         
##  [876] "ELECTRICAL MECHANIC"                          
##  [877] "ELECTRICAL MECHANIC"                          
##  [878] "OPERATING ENGINEER-GROUP C"                   
##  [879] "MOTOR TRUCK DRIVER"                           
##  [880] "CONSTRUCTION LABORER"                         
##  [881] "CONSTRUCTION LABORER"                         
##  [882] "CONSTRUCTION LABORER"                         
##  [883] "PLUMBER"                                      
##  [884] "PLUMBER"                                      
##  [885] "OPERATING ENGINEER-GROUP C"                   
##  [886] "CONSTRUCTION LABORER"                         
##  [887] "WATCHMAN"                                     
##  [888] "CONSTRUCTION LABORER"                         
##  [889] "CONSTRUCTION LABORER"                         
##  [890] "MOTOR TRUCK DRIVER"                           
##  [891] "CONSTRUCTION LABORER"                         
##  [892] "CONSTRUCTION LABORER"                         
##  [893] "CONSTRUCTION LABORER"                         
##  [894] "ASST CHIEF OPERATING ENGINEER"                
##  [895] "MOTOR TRUCK DRIVER"                           
##  [896] "HOISTING ENGINEER"                            
##  [897] "WATCHMAN"                                     
##  [898] "FOREMAN OF CONSTRUCTION LABORERS"             
##  [899] "OPERATING ENGINEER-GROUP C"                   
##  [900] "HOISTING ENGINEER"                            
##  [901] "MOTOR TRUCK DRIVER"                           
##  [902] "OPERATING ENGINEER-GROUP C"                   
##  [903] "OPERATING ENGINEER-GROUP C"                   
##  [904] "OPERATING ENGINEER-GROUP C"                   
##  [905] "PLUMBER"                                      
##  [906] "OPERATING ENGINEER-GROUP C"                   
##  [907] "CONSTRUCTION LABORER"                         
##  [908] "CONSTRUCTION LABORER"                         
##  [909] "CAULKER"                                      
##  [910] "WATCHMAN"                                     
##  [911] "CONSTRUCTION LABORER"                         
##  [912] "EMERGENCY CREW DISPATCHER"                    
##  [913] "EMERGENCY CREW DISPATCHER"                    
##  [914] "OPERATING ENGINEER-GROUP A"                   
##  [915] "OPERATING ENGINEER-GROUP C"                   
##  [916] "OPERATING ENGINEER-GROUP C"                   
##  [917] "CONSTRUCTION LABORER"                         
##  [918] "CONSTRUCTION LABORER"                         
##  [919] "OPERATING ENGINEER-GROUP C"                   
##  [920] "OPERATING ENGINEER-GROUP A"                   
##  [921] "CONSTRUCTION LABORER"                         
##  [922] "HOISTING ENGINEER"                            
##  [923] "OPERATING ENGINEER-GROUP A"                   
##  [924] "CONSTRUCTION LABORER"                         
##  [925] "WATER METER MACHINIST"                        
##  [926] "CONSTRUCTION LABORER"                         
##  [927] "MOTOR TRUCK DRIVER"                           
##  [928] "CONSTRUCTION LABORER"                         
##  [929] "SEWER BRICKLAYER"                             
##  [930] "WATCHMAN"                                     
##  [931] "OPERATING ENGINEER-GROUP C"                   
##  [932] "OPERATING ENGINEER-GROUP A"                   
##  [933] "ELECTRICAL MECHANIC"                          
##  [934] "CONSTRUCTION LABORER"                         
##  [935] "CUSTODIAL WORKER"                             
##  [936] "MOTOR TRUCK DRIVER"                           
##  [937] "OPERATING ENGINEER-GROUP C"                   
##  [938] "ASST CHIEF OPERATING ENGINEER"                
##  [939] "LABORER - APPRENTICE"                         
##  [940] "SEWER BRICKLAYER"                             
##  [941] "WATCHMAN"                                     
##  [942] "CONSTRUCTION LABORER"                         
##  [943] "ELECTRICAL MECHANIC"                          
##  [944] "FOREMAN OF WATER PIPE CONSTRUCTION"           
##  [945] "OPERATING ENGINEER-GROUP A"                   
##  [946] "HOISTING ENGINEER"                            
##  [947] "OPERATING ENGINEER-GROUP C"                   
##  [948] "PLUMBER"                                      
##  [949] "OPERATING ENGINEER-GROUP C"                   
##  [950] "WATCHMAN"                                     
##  [951] "CONSTRUCTION LABORER"                         
##  [952] "PLUMBER"                                      
##  [953] "EMERGENCY CREW DISPATCHER"                    
##  [954] "CONSTRUCTION LABORER"                         
##  [955] "CONSTRUCTION LABORER"                         
##  [956] "WATCHMAN"                                     
##  [957] "MOTOR TRUCK DRIVER"                           
##  [958] "PLUMBER"                                      
##  [959] "CONSTRUCTION LABORER"                         
##  [960] "HOISTING ENGINEER"                            
##  [961] "HOISTING ENGINEER"                            
##  [962] "CONSTRUCTION LABORER"                         
##  [963] "WATCHMAN"                                     
##  [964] "CONSTRUCTION LABORER"                         
##  [965] "PLUMBER"                                      
##  [966] "MOTOR TRUCK DRIVER"                           
##  [967] "CONSTRUCTION LABORER"                         
##  [968] "PLUMBER"                                      
##  [969] "CONSTRUCTION LABORER"                         
##  [970] "OPERATING ENGINEER-GROUP C"                   
##  [971] "LABORER - APPRENTICE"                         
##  [972] "WATER METER MACHINIST"                        
##  [973] "CONSTRUCTION LABORER"                         
##  [974] "MOTOR TRUCK DRIVER"                           
##  [975] "CUSTODIAL WORKER"                             
##  [976] "LABORER - APPRENTICE"                         
##  [977] "LABORER - APPRENTICE"                         
##  [978] "CONSTRUCTION LABORER"                         
##  [979] "CONSTRUCTION LABORER"                         
##  [980] "FOREMAN OF WATER PIPE CONSTRUCTION"           
##  [981] "WATCHMAN"                                     
##  [982] "OPERATING ENGINEER-GROUP A"                   
##  [983] "WATER METER MACHINIST"                        
##  [984] "CONSTRUCTION LABORER"                         
##  [985] "MOTOR TRUCK DRIVER"                           
##  [986] "CONSTRUCTION LABORER"                         
##  [987] "CONSTRUCTION LABORER"                         
##  [988] "ASST CHIEF OPERATING ENGINEER"                
##  [989] "HOISTING ENGINEER"                            
##  [990] "CONSTRUCTION LABORER"                         
##  [991] "CONSTRUCTION LABORER"                         
##  [992] "MOTOR TRUCK DRIVER"                           
##  [993] "ASST CHIEF OPERATING ENGINEER"                
##  [994] "CAULKER"                                      
##  [995] "HOISTING ENGINEER"                            
##  [996] "WATER METER MACHINIST"                        
##  [997] "MOTOR TRUCK DRIVER"                           
##  [998] "PLUMBER"                                      
##  [999] "FOREMAN OF MACHINISTS"                        
## [1000] "CONSTRUCTION LABORER"                         
## [1001] "CONSTRUCTION LABORER"                         
## [1002] "WATER METER MACHINIST"                        
## [1003] "CONSTRUCTION LABORER"                         
## [1004] "CONSTRUCTION LABORER"                         
## [1005] "LABORER - APPRENTICE"                         
## [1006] "SEWER BRICKLAYER"                             
## [1007] "PLUMBER"                                      
## [1008] "MOTOR TRUCK DRIVER"                           
## [1009] "MOTOR TRUCK DRIVER"                           
## [1010] "CONSTRUCTION LABORER"                         
## [1011] "STEAMFITTER"                                  
## [1012] "ASST CHIEF OPERATING ENGINEER"                
## [1013] "STEAMFITTER"                                  
## [1014] "MOTOR TRUCK DRIVER"                           
## [1015] "HOISTING ENGINEER"                            
## [1016] "MOTOR TRUCK DRIVER"                           
## [1017] "FOREMAN OF WATER PIPE CONSTRUCTION"           
## [1018] "CONSTRUCTION LABORER"                         
## [1019] "CONSTRUCTION LABORER"                         
## [1020] "POOL MOTOR TRUCK DRIVER"                      
## [1021] "STEAMFITTER"                                  
## [1022] "CONSTRUCTION LABORER"                         
## [1023] "PLUMBER"                                      
## [1024] "OPERATING ENGINEER-GROUP A"                   
## [1025] "CONSTRUCTION LABORER"                         
## [1026] "HOISTING ENGINEER"                            
## [1027] "ELECTRICAL MECHANIC"                          
## [1028] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
## [1029] "FOREMAN OF SEWER BRICKLAYERS"                 
## [1030] "ELECTRICAL MECHANIC"                          
## [1031] "PLUMBER"                                      
## [1032] "HOISTING ENGINEER"                            
## [1033] "HOISTING ENGINEER"                            
## [1034] "OPERATING ENGINEER-GROUP C"                   
## [1035] "OPERATING ENGINEER-GROUP C"                   
## [1036] "HOISTING ENGINEER"                            
## [1037] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
## [1038] "CONSTRUCTION LABORER"                         
## [1039] "OPERATING ENGINEER-GROUP C"                   
## [1040] "FOREMAN OF SEWER BRICKLAYERS"                 
## [1041] "CONSTRUCTION LABORER"                         
## [1042] "CARPENTER"                                    
## [1043] "HOISTING ENGINEER"                            
## [1044] "OPERATING ENGINEER-GROUP C"                   
## [1045] "HOISTING ENGINEER"                            
## [1046] "CONSTRUCTION LABORER"                         
## [1047] "MOTOR TRUCK DRIVER"                           
## [1048] "ASST CHIEF OPERATING ENGINEER"                
## [1049] "WATER METER MACHINIST"                        
## [1050] "MACHINIST"                                    
## [1051] "MOTOR TRUCK DRIVER"                           
## [1052] "CONSTRUCTION LABORER"                         
## [1053] "MOTOR TRUCK DRIVER"                           
## [1054] "SEWER BRICKLAYER"                             
## [1055] "EMERGENCY CREW DISPATCHER"                    
## [1056] "HOISTING ENGINEER"                            
## [1057] "FOREMAN OF MACHINISTS"                        
## [1058] "CONSTRUCTION LABORER"                         
## [1059] "PLUMBER"                                      
## [1060] "CONSTRUCTION LABORER"                         
## [1061] "WATER METER MACHINIST"                        
## [1062] "MOTOR TRUCK DRIVER"                           
## [1063] "MACHINIST"                                    
## [1064] "ELECTRICAL MECHANIC"                          
## [1065] "CONSTRUCTION LABORER"                         
## [1066] "OPERATING ENGINEER-GROUP A"                   
## [1067] "SEWER BRICKLAYER"                             
## [1068] "SEWER BRICKLAYER"                             
## [1069] "OPERATING ENGINEER-GROUP C"                   
## [1070] "MOTOR TRUCK DRIVER"                           
## [1071] "MOTOR TRUCK DRIVER"                           
## [1072] "MOTOR TRUCK DRIVER"                           
## [1073] "MOTOR TRUCK DRIVER"                           
## [1074] "OPERATING ENGINEER-GROUP A"                   
## [1075] "OPERATING ENGINEER-GROUP A"                   
## [1076] "ASST CHIEF OPERATING ENGINEER"                
## [1077] "OPERATING ENGINEER-GROUP A"                   
## [1078] "SEWER BRICKLAYER"                             
## [1079] "OPERATING ENGINEER-GROUP C"                   
## [1080] "CONSTRUCTION LABORER"                         
## [1081] "OPERATING ENGINEER-GROUP C"                   
## [1082] "MOTOR TRUCK DRIVER"                           
## [1083] "CONSTRUCTION LABORER"                         
## [1084] "CONSTRUCTION LABORER"                         
## [1085] "PLUMBER"                                      
## [1086] "STATIONARY FIREMAN"                           
## [1087] "CONSTRUCTION LABORER"                         
## [1088] "STEAMFITTER"                                  
## [1089] "CONSTRUCTION LABORER"                         
## [1090] "ELECTRICAL MECHANIC"                          
## [1091] "CONSTRUCTION LABORER"                         
## [1092] "ELECTRICAL MECHANIC"                          
## [1093] "PLUMBER"                                      
## [1094] "FOREMAN OF ELECTRICAL MECHANICS"              
## [1095] "HOISTING ENGINEER"                            
## [1096] "PLUMBER"                                      
## [1097] "MOTOR TRUCK DRIVER"                           
## [1098] "OPERATING ENGINEER-GROUP C"                   
## [1099] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
## [1100] "CONSTRUCTION LABORER"                         
## [1101] "MOTOR TRUCK DRIVER"                           
## [1102] "MOTOR TRUCK DRIVER"                           
## [1103] "MOTOR TRUCK DRIVER"                           
## [1104] "OPERATING ENGINEER-GROUP A"                   
## [1105] "HOISTING ENGINEER"                            
## [1106] "MOTOR TRUCK DRIVER"                           
## [1107] "HOISTING ENGINEER"                            
## [1108] "CONSTRUCTION LABORER"                         
## [1109] "CONSTRUCTION LABORER"                         
## [1110] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
## [1111] "OPERATING ENGINEER-GROUP A"                   
## [1112] "CONSTRUCTION LABORER"                         
## [1113] "OPERATING ENGINEER-GROUP A"                   
## [1114] "OPERATING ENGINEER-GROUP A"                   
## [1115] "CONSTRUCTION LABORER"                         
## [1116] "CONSTRUCTION LABORER"                         
## [1117] "SEWER BRICKLAYER"                             
## [1118] "WATCHMAN"                                     
## [1119] "OPERATING ENGINEER-GROUP A"                   
## [1120] "MOTOR TRUCK DRIVER"                           
## [1121] "CONSTRUCTION LABORER"                         
## [1122] "CONSTRUCTION LABORER"                         
## [1123] "HOISTING ENGINEER"                            
## [1124] "MOTOR TRUCK DRIVER"                           
## [1125] "STATION LABORER"                              
## [1126] "CONSTRUCTION LABORER"                         
## [1127] "CONSTRUCTION LABORER"                         
## [1128] "OPERATING ENGINEER-GROUP C"                   
## [1129] "SEWER BRICKLAYER"                             
## [1130] "MOTOR TRUCK DRIVER"                           
## [1131] "OPERATING ENGINEER-GROUP C"                   
## [1132] "OPERATING ENGINEER-GROUP C"                   
## [1133] "OPERATING ENGINEER-GROUP C"                   
## [1134] "CONSTRUCTION LABORER"                         
## [1135] "MOTOR TRUCK DRIVER"                           
## [1136] "MACHINIST"                                    
## [1137] "OPERATING ENGINEER-GROUP C"                   
## [1138] "FOREMAN OF WATER PIPE CONSTRUCTION"           
## [1139] "HOISTING ENGINEER"                            
## [1140] "ELECTRICAL MECHANIC"                          
## [1141] "PLUMBER"                                      
## [1142] "FOREMAN OF STEAMFITTERS"                      
## [1143] "SEWER BRICKLAYER"                             
## [1144] "PLUMBER"                                      
## [1145] "PLUMBER"                                      
## [1146] "OPERATING ENGINEER-GROUP A"                   
## [1147] "PLUMBER"                                      
## [1148] "POOL MOTOR TRUCK DRIVER"                      
## [1149] "ELECTRICAL MECHANIC"                          
## [1150] "OPERATING ENGINEER-GROUP A"                   
## [1151] "WATCHMAN"                                     
## [1152] "CONSTRUCTION LABORER"                         
## [1153] "CONSTRUCTION LABORER"                         
## [1154] "BRICKLAYER"                                   
## [1155] "OPERATING ENGINEER-GROUP A"                   
## [1156] "ASST CHIEF OPERATING ENGINEER"                
## [1157] "MOTOR TRUCK DRIVER"                           
## [1158] "ELECTRICAL MECHANIC"                          
## [1159] "OPERATING ENGINEER-GROUP C"                   
## [1160] "FOREMAN OF SEWER BRICKLAYERS"                 
## [1161] "HOISTING ENGINEER"                            
## [1162] "OPERATING ENGINEER-GROUP A"                   
## [1163] "CONSTRUCTION LABORER"                         
## [1164] "MACHINIST"                                    
## [1165] "MOTOR TRUCK DRIVER"                           
## [1166] "ASST CHIEF OPERATING ENGINEER"                
## [1167] "WATER METER MACHINIST"                        
## [1168] "MOTOR TRUCK DRIVER"                           
## [1169] "CONSTRUCTION LABORER"                         
## [1170] "CONSTRUCTION LABORER"                         
## [1171] "HOISTING ENGINEER"                            
## [1172] "SEWER BRICKLAYER"                             
## [1173] "PAINTER"                                      
## [1174] "FOREMAN OF PIPE / SALVAGE YARDS"              
## [1175] "MOTOR TRUCK DRIVER"                           
## [1176] "CONSTRUCTION LABORER"                         
## [1177] "PLUMBER"                                      
## [1178] "CONSTRUCTION LABORER"                         
## [1179] "LABORER - APPRENTICE"                         
## [1180] "STEAMFITTER"                                  
## [1181] "CONSTRUCTION LABORER"                         
## [1182] "ASST CHIEF OPERATING ENGINEER"                
## [1183] "CONSTRUCTION LABORER"                         
## [1184] "MOTOR TRUCK DRIVER"                           
## [1185] "PLUMBER"                                      
## [1186] "HOISTING ENGINEER"                            
## [1187] "HOISTING ENGINEER"                            
## [1188] "HOISTING ENGINEER"                            
## [1189] "CONSTRUCTION LABORER"                         
## [1190] "MOTOR TRUCK DRIVER"                           
## [1191] "LABORER - APPRENTICE"                         
## [1192] "SEWER BRICKLAYER"                             
## [1193] "CONSTRUCTION LABORER"                         
## [1194] "MACHINIST"                                    
## [1195] "HOISTING ENGINEER"                            
## [1196] "SEWER BRICKLAYER"                             
## [1197] "HOISTING ENGINEER"                            
## [1198] "ELECTRICAL MECHANIC"                          
## [1199] "MOTOR TRUCK DRIVER"                           
## [1200] "EMERGENCY CREW DISPATCHER"                    
## [1201] "ELECTRICAL MECHANIC"                          
## [1202] "MOTOR TRUCK DRIVER"                           
## [1203] "OPERATING ENGINEER-GROUP C"                   
## [1204] "HOISTING ENGINEER"                            
## [1205] "OPERATING ENGINEER-GROUP C"                   
## [1206] "FOREMAN OF SEWER BRICKLAYERS"                 
## [1207] "CONSTRUCTION LABORER"                         
## [1208] "MOTOR TRUCK DRIVER"                           
## [1209] "HOISTING ENGINEER"                            
## [1210] "HOISTING ENGINEER"                            
## [1211] "OPERATING ENGINEER-GROUP A"                   
## [1212] "OPERATING ENGINEER-GROUP C"                   
## [1213] "HOISTING ENGINEER"                            
## [1214] "SEWER BRICKLAYER"                             
## [1215] "ASST CHIEF OPERATING ENGINEER"                
## [1216] "CONSTRUCTION LABORER"                         
## [1217] "CONSTRUCTION LABORER"                         
## [1218] "FOREMAN OF WATER PIPE CONSTRUCTION"           
## [1219] "MARINE PILOT"                                 
## [1220] "CONSTRUCTION LABORER"                         
## [1221] "CONSTRUCTION LABORER"                         
## [1222] "OPERATING ENGINEER-GROUP A"                   
## [1223] "SEWER BRICKLAYER"                             
## [1224] "FOREMAN OF PIPE / SALVAGE YARDS"              
## [1225] "STEAMFITTER"                                  
## [1226] "CONSTRUCTION LABORER"                         
## [1227] "SEWER BRICKLAYER"                             
## [1228] "FOREMAN OF WATER PIPE CONSTRUCTION"           
## [1229] "OPERATING ENGINEER-GROUP C"                   
## [1230] "ASST CHIEF OPERATING ENGINEER"                
## [1231] "CONSTRUCTION LABORER"                         
## [1232] "MOTOR TRUCK DRIVER"                           
## [1233] "OPERATING ENGINEER-GROUP C"                   
## [1234] "OPERATING ENGINEER-GROUP A"                   
## [1235] "CONSTRUCTION LABORER"                         
## [1236] "MOTOR TRUCK DRIVER"                           
## [1237] "CONSTRUCTION LABORER"                         
## [1238] "STEAMFITTER"                                  
## [1239] "FOREMAN OF CONSTRUCTION LABORERS"             
## [1240] "HOISTING ENGINEER"                            
## [1241] "FOREMAN OF MOTOR TRUCK DRIVERS"               
## [1242] "MOTOR TRUCK DRIVER"                           
## [1243] "CONSTRUCTION LABORER"                         
## [1244] "FOREMAN OF SEWER BRICKLAYERS"                 
## [1245] "CONSTRUCTION LABORER"                         
## [1246] "PLUMBER"                                      
## [1247] "MOTOR TRUCK DRIVER"                           
## [1248] "CONSTRUCTION LABORER"                         
## [1249] "CONSTRUCTION LABORER"                         
## [1250] "CONSTRUCTION LABORER"                         
## [1251] "CONSTRUCTION LABORER"                         
## [1252] "CONSTRUCTION LABORER"                         
## [1253] "FOREMAN OF WATER PIPE CONSTRUCTION"           
## [1254] "CONSTRUCTION LABORER"                         
## [1255] "LABORER - APPRENTICE"                         
## [1256] "LABORER - APPRENTICE"                         
## [1257] "ASST CHIEF OPERATING ENGINEER"                
## [1258] "MACHINIST"                                    
## [1259] "OPERATING ENGINEER-GROUP C"                   
## [1260] "OPERATING ENGINEER-GROUP C"                   
## [1261] "LABORER - APPRENTICE"                         
## [1262] "STEAMFITTER"                                  
## [1263] "SEWER BRICKLAYER"                             
## [1264] "SEWER BRICKLAYER"                             
## [1265] "ELECTRICAL MECHANIC"                          
## [1266] "CONSTRUCTION LABORER"                         
## [1267] "ELECTRICAL MECHANIC"                          
## [1268] "OPERATING ENGINEER-GROUP C"                   
## [1269] "ASST CHIEF OPERATING ENGINEER"                
## [1270] "ASST CHIEF OPERATING ENGINEER"                
## [1271] "ASST CHIEF OPERATING ENGINEER"                
## [1272] "MOTOR TRUCK DRIVER"                           
## [1273] "PLUMBER"                                      
## [1274] "WATCHMAN"                                     
## [1275] "CONSTRUCTION LABORER"                         
## [1276] "MOTOR TRUCK DRIVER"                           
## [1277] "HOISTING ENGINEER"                            
## [1278] "HOISTING ENGINEER"                            
## [1279] "MOTOR TRUCK DRIVER"                           
## [1280] "OPERATING ENGINEER-GROUP C"                   
## [1281] "CONSTRUCTION LABORER"                         
## [1282] "CONSTRUCTION LABORER"                         
## [1283] "EMERGENCY CREW DISPATCHER"                    
## [1284] "MOTOR TRUCK DRIVER"                           
## [1285] "OPERATING ENGINEER-GROUP C"                   
## [1286] "HOISTING ENGINEER"                            
## [1287] "CONSTRUCTION LABORER"                         
## [1288] "CAULKER"                                      
## [1289] "HOISTING ENGINEER"                            
## [1290] "FOREMAN OF WATER PIPE CONSTRUCTION"           
## [1291] "MOTOR TRUCK DRIVER"                           
## [1292] "CONSTRUCTION LABORER"                         
## [1293] "CONSTRUCTION LABORER"                         
## [1294] "LABORER AS ESTIMATOR"                         
## [1295] "STEAMFITTER"                                  
## [1296] "CONSTRUCTION LABORER"                         
## [1297] "CONSTRUCTION LABORER"                         
## [1298] "OPERATING ENGINEER-GROUP A"                   
## [1299] "OPERATING ENGINEER-GROUP A"                   
## [1300] "OPERATING ENGINEER-GROUP C"                   
## [1301] "CONSTRUCTION LABORER"                         
## [1302] "CONSTRUCTION LABORER"                         
## [1303] "CONSTRUCTION LABORER"                         
## [1304] "HOISTING ENGINEER"                            
## [1305] "CONSTRUCTION LABORER"                         
## [1306] "FOREMAN OF SEWER CLEANING"                    
## [1307] "ELECTRICAL MECHANIC"                          
## [1308] "OPERATING ENGINEER-GROUP C"                   
## [1309] "ELECTRICAL MECHANIC"                          
## [1310] "MOTOR TRUCK DRIVER"                           
## [1311] "OPERATING ENGINEER-GROUP A"                   
## [1312] "STATIONARY FIREMAN"                           
## [1313] "MOTOR TRUCK DRIVER"                           
## [1314] "OPERATING ENGINEER-GROUP C"                   
## [1315] "ASST CHIEF OPERATING ENGINEER"                
## [1316] "FOREMAN OF SEWER BRICKLAYERS"                 
## [1317] "OPERATING ENGINEER-GROUP A"                   
## [1318] "CONSTRUCTION LABORER"                         
## [1319] "CONSTRUCTION LABORER"                         
## [1320] "ELECTRICAL MECHANIC"                          
## [1321] "PLUMBER"                                      
## [1322] "CONSTRUCTION LABORER"                         
## [1323] "MACHINIST"                                    
## [1324] "STATIONARY FIREMAN"                           
## [1325] "WATCHMAN"                                     
## [1326] "CONSTRUCTION LABORER"                         
## [1327] "FOREMAN OF MOTOR TRUCK DRIVERS"               
## [1328] "CARPENTER"                                    
## [1329] "PAINTER"                                      
## [1330] "FOREMAN OF SEWER BRICKLAYERS"                 
## [1331] "WATCHMAN"                                     
## [1332] "CONSTRUCTION LABORER"                         
## [1333] "CONSTRUCTION LABORER"                         
## [1334] "MOTOR TRUCK DRIVER"                           
## [1335] "STATIONARY FIREMAN"                           
## [1336] "CONSTRUCTION LABORER"                         
## [1337] "WATCHMAN"                                     
## [1338] "PLUMBER"                                      
## [1339] "SEWER BRICKLAYER"                             
## [1340] "CONSTRUCTION LABORER"                         
## [1341] "EMERGENCY CREW DISPATCHER"                    
## [1342] "HOISTING ENGINEER"                            
## [1343] "EMERGENCY CREW DISPATCHER"                    
## [1344] "OPERATING ENGINEER-GROUP A"                   
## [1345] "PLUMBER"                                      
## [1346] "HOISTING ENGINEER"                            
## [1347] "WATCHMAN"                                     
## [1348] "WATER METER MACHINIST"                        
## [1349] "OPERATING ENGINEER-GROUP A"                   
## [1350] "MOTOR TRUCK DRIVER"                           
## [1351] "OPERATING ENGINEER-GROUP C"                   
## [1352] "OPERATING ENGINEER-GROUP A"                   
## [1353] "WATER METER MACHINIST"                        
## [1354] "STEAMFITTER"                                  
## [1355] "OPERATING ENGINEER-GROUP C"                   
## [1356] "HOISTING ENGINEER"                            
## [1357] "ASST CHIEF OPERATING ENGINEER"                
## [1358] "PLUMBER"                                      
## [1359] "MACHINIST"                                    
## [1360] "WATCHMAN"                                     
## [1361] "ASST CHIEF OPERATING ENGINEER"                
## [1362] "CONSTRUCTION LABORER"                         
## [1363] "HOISTING ENGINEER"                            
## [1364] "CONSTRUCTION LABORER"                         
## [1365] "CONSTRUCTION LABORER"                         
## [1366] "FOREMAN OF PLUMBERS"                          
## [1367] "CONSTRUCTION LABORER"                         
## [1368] "MOTOR TRUCK DRIVER"                           
## [1369] "ELECTRICAL MECHANIC"                          
## [1370] "STATION LABORER"                              
## [1371] "CONSTRUCTION LABORER"                         
## [1372] "SEWER BRICKLAYER"                             
## [1373] "SEWER BRICKLAYER"                             
## [1374] "HOISTING ENGINEER"                            
## [1375] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
## [1376] "PLUMBER"                                      
## [1377] "CONSTRUCTION LABORER"                         
## [1378] "PLUMBER"                                      
## [1379] "LABORER - APPRENTICE"                         
## [1380] "FOREMAN OF PAINTERS"                          
## [1381] "CONSTRUCTION LABORER"                         
## [1382] "CONSTRUCTION LABORER"                         
## [1383] "MOTOR TRUCK DRIVER"                           
## [1384] "WATCHMAN"                                     
## [1385] "LABORER - APPRENTICE"                         
## [1386] "MOTOR TRUCK DRIVER"                           
## [1387] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
## [1388] "CONSTRUCTION LABORER"                         
## [1389] "CONSTRUCTION LABORER"                         
## [1390] "MOTOR TRUCK DRIVER"                           
## [1391] "PLUMBER"                                      
## [1392] "CONSTRUCTION LABORER"                         
## [1393] "SEWER BRICKLAYER"                             
## [1394] "ASST CHIEF OPERATING ENGINEER"                
## [1395] "GENERAL FOREMAN OF BRICKLAYERS"               
## [1396] "OPERATING ENGINEER-GROUP A"                   
## [1397] "MOTOR TRUCK DRIVER"                           
## [1398] "FOREMAN OF HOISTING ENGINEERS"                
## [1399] "OPERATING ENGINEER-GROUP C"                   
## [1400] "OPERATING ENGINEER-GROUP A"                   
## [1401] "MOTOR TRUCK DRIVER"                           
## [1402] "CONSTRUCTION LABORER"                         
## [1403] "CONSTRUCTION LABORER"                         
## [1404] "CONSTRUCTION LABORER"                         
## [1405] "PLUMBER"                                      
## [1406] "PAINTER"                                      
## [1407] "SEWER BRICKLAYER"                             
## [1408] "MOTOR TRUCK DRIVER"                           
## [1409] "CONSTRUCTION LABORER"                         
## [1410] "HOISTING ENGINEER"                            
## [1411] "CONSTRUCTION LABORER"                         
## [1412] "OPERATING ENGINEER-GROUP C"                   
## [1413] "ELECTRICAL MECHANIC"                          
## [1414] "OPERATING ENGINEER-GROUP C"                   
## [1415] "WATER METER MACHINIST"                        
## [1416] "CONSTRUCTION LABORER"                         
## [1417] "CONSTRUCTION LABORER"                         
## [1418] "POOL MOTOR TRUCK DRIVER"                      
## [1419] "ELECTRICAL MECHANIC"                          
## [1420] "CONSTRUCTION LABORER"                         
## [1421] "ELECTRICAL MECHANIC"                          
## [1422] "OPERATING ENGINEER-GROUP C"                   
## [1423] "MACHINIST"                                    
## [1424] "FOREMAN OF WATER PIPE CONSTRUCTION"           
## [1425] "SEWER BRICKLAYER"                             
## [1426] "PLUMBER"                                      
## [1427] "FOREMAN OF CUSTODIAL WORKERS"                 
## [1428] "POOL MOTOR TRUCK DRIVER"                      
## [1429] "MOTOR TRUCK DRIVER"                           
## [1430] "CONSTRUCTION LABORER"                         
## [1431] "CONSTRUCTION LABORER"                         
## [1432] "MOTOR TRUCK DRIVER"                           
## [1433] "OPERATING ENGINEER-GROUP A"                   
## [1434] "EMERGENCY CREW DISPATCHER"                    
## [1435] "WATER METER MACHINIST"                        
## [1436] "OPERATING ENGINEER-GROUP A"                   
## [1437] "OPERATING ENGINEER-GROUP A"                   
## [1438] "CONSTRUCTION LABORER"                         
## [1439] "HOISTING ENGINEER"                            
## [1440] "CONSTRUCTION LABORER"                         
## [1441] "CONSTRUCTION LABORER"                         
## [1442] "OPERATING ENGINEER-GROUP A"                   
## [1443] "MOTOR TRUCK DRIVER"                           
## [1444] "CAULKER"                                      
## [1445] "PLUMBER"                                      
## [1446] "STATION LABORER"                              
## [1447] "CONSTRUCTION LABORER"                         
## [1448] "CONSTRUCTION LABORER"                         
## [1449] "ELECTRICAL MECHANIC"                          
## [1450] "CONSTRUCTION LABORER"                         
## [1451] "CONSTRUCTION LABORER"                         
## [1452] "HOISTING ENGINEER"                            
## [1453] "OPERATING ENGINEER-GROUP C"                   
## [1454] "MOTOR TRUCK DRIVER"                           
## [1455] "LABORER - APPRENTICE"                         
## [1456] "CONSTRUCTION LABORER"                         
## [1457] "CONSTRUCTION LABORER"                         
## [1458] "SEWER BRICKLAYER"                             
## [1459] "ASST CHIEF OPERATING ENGINEER"                
## [1460] "CONSTRUCTION LABORER"                         
## [1461] "CONSTRUCTION LABORER"                         
## [1462] "CONSTRUCTION LABORER"                         
## [1463] "CONSTRUCTION LABORER"                         
## [1464] "ASST CHIEF OPERATING ENGINEER"                
## [1465] "OPERATING ENGINEER-GROUP A"                   
## [1466] "CONSTRUCTION LABORER"                         
## [1467] "EMERGENCY CREW DISPATCHER"                    
## [1468] "ELECTRICAL MECHANIC"                          
## [1469] "PLUMBER"                                      
## [1470] "ELECTRICAL MECHANIC"                          
## [1471] "CAULKER"                                      
## [1472] "CONSTRUCTION LABORER"                         
## [1473] "POOL MOTOR TRUCK DRIVER"                      
## [1474] "EMERGENCY CREW DISPATCHER"                    
## [1475] "CONSTRUCTION LABORER"                         
## [1476] "OPERATING ENGINEER-GROUP A"                   
## [1477] "OPERATING ENGINEER-GROUP C"                   
## [1478] "HOISTING ENGINEER"                            
## [1479] "ELECTRICAL MECHANIC"                          
## [1480] "MOTOR TRUCK DRIVER"                           
## [1481] "MOTOR TRUCK DRIVER"                           
## [1482] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
## [1483] "CONSTRUCTION LABORER"                         
## [1484] "CONSTRUCTION LABORER"                         
## [1485] "ASST CHIEF OPERATING ENGINEER"                
## [1486] "LABORER AS ESTIMATOR"                         
## [1487] "MACHINIST"                                    
## [1488] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
## [1489] "OPERATING ENGINEER-GROUP C"                   
## [1490] "OPERATING ENGINEER-GROUP A"                   
## [1491] "OPERATING ENGINEER-GROUP A"                   
## [1492] "MOTOR TRUCK DRIVER"                           
## [1493] "CONSTRUCTION LABORER"                         
## [1494] "CONSTRUCTION LABORER"                         
## [1495] "CONSTRUCTION LABORER"                         
## [1496] "CONSTRUCTION LABORER"                         
## [1497] "OPERATING ENGINEER-GROUP C"                   
## [1498] "LABORER - APPRENTICE"                         
## [1499] "MACHINIST"                                    
## [1500] "CONSTRUCTION LABORER"                         
## [1501] "EMERGENCY CREW DISPATCHER"                    
## [1502] "LABORER - APPRENTICE"                         
## [1503] "PLUMBER"                                      
## [1504] "ELECTRICAL MECHANIC"                          
## [1505] "MOTOR TRUCK DRIVER"                           
## [1506] "CONSTRUCTION LABORER"                         
## [1507] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
## [1508] "MOTOR TRUCK DRIVER"                           
## [1509] "MOTOR TRUCK DRIVER"                           
## [1510] "CONSTRUCTION LABORER"                         
## [1511] "OPERATING ENGINEER-GROUP C"                   
## [1512] "OPERATING ENGINEER-GROUP A"                   
## [1513] "CONSTRUCTION LABORER"                         
## [1514] "HOISTING ENGINEER"                            
## [1515] "MOTOR TRUCK DRIVER"                           
## [1516] "CONSTRUCTION LABORER"                         
## [1517] "CONSTRUCTION LABORER"                         
## [1518] "HOISTING ENGINEER"                            
## [1519] "CONSTRUCTION LABORER"                         
## [1520] "CONSTRUCTION LABORER"                         
## [1521] "PAINTER"                                      
## [1522] "CONSTRUCTION LABORER"                         
## [1523] "CONSTRUCTION LABORER"                         
## [1524] "HOISTING ENGINEER"                            
## [1525] "POOL MOTOR TRUCK DRIVER"                      
## [1526] "CONSTRUCTION LABORER"                         
## [1527] "CONSTRUCTION LABORER"                         
## [1528] "CEMENT FINISHER"                              
## [1529] "OPERATING ENGINEER-GROUP C"                   
## [1530] "CONSTRUCTION LABORER"                         
## [1531] "CONSTRUCTION LABORER"                         
## [1532] "CONSTRUCTION LABORER"                         
## [1533] "HOISTING ENGINEER"                            
## [1534] "HOISTING ENGINEER"                            
## [1535] "HOISTING ENGINEER"                            
## [1536] "HOISTING ENGINEER"                            
## [1537] "HOISTING ENGINEER"                            
## [1538] "FOREMAN OF CONSTRUCTION LABORERS"             
## [1539] "OPERATING ENGINEER-GROUP C"                   
## [1540] "HOISTING ENGINEER"                            
## [1541] "CONSTRUCTION LABORER"                         
## [1542] "MOTOR TRUCK DRIVER"                           
## [1543] "SEWER BRICKLAYER"                             
## [1544] "MACHINIST"                                    
## [1545] "OPERATING ENGINEER-GROUP A"                   
## [1546] "ASST CHIEF OPERATING ENGINEER"                
## [1547] "CONSTRUCTION LABORER"                         
## [1548] "MOTOR TRUCK DRIVER"                           
## [1549] "PAINTER"                                      
## [1550] "CONSTRUCTION LABORER"                         
## [1551] "MOTOR TRUCK DRIVER"                           
## [1552] "CONSTRUCTION LABORER"                         
## [1553] "CONSTRUCTION LABORER"                         
## [1554] "MOTOR TRUCK DRIVER"                           
## [1555] "MOTOR TRUCK DRIVER"                           
## [1556] "CONSTRUCTION LABORER"                         
## [1557] "OPERATING ENGINEER-GROUP A"                   
## [1558] "OPERATING ENGINEER-GROUP C"                   
## [1559] "OPERATING ENGINEER-GROUP C"                   
## [1560] "OPERATING ENGINEER-GROUP C"                   
## [1561] "HOISTING ENGINEER"                            
## [1562] "SEWER BRICKLAYER"                             
## [1563] "CONSTRUCTION LABORER"                         
## [1564] "CONSTRUCTION LABORER"                         
## [1565] "MOTOR TRUCK DRIVER"                           
## [1566] "CONSTRUCTION LABORER"                         
## [1567] "MOTOR TRUCK DRIVER"                           
## [1568] "HOISTING ENGINEER"                            
## [1569] "CONSTRUCTION LABORER"                         
## [1570] "MOTOR TRUCK DRIVER"                           
## [1571] "ELECTRICAL MECHANIC"                          
## [1572] "MACHINIST"                                    
## [1573] "MOTOR TRUCK DRIVER"                           
## [1574] "OPERATING ENGINEER-GROUP C"                   
## [1575] "PLUMBER"                                      
## [1576] "OPERATING ENGINEER-GROUP C"                   
## [1577] "PAINTER"                                      
## [1578] "OPERATING ENGINEER-GROUP C"                   
## [1579] "PLUMBER"                                      
## [1580] "MOTOR TRUCK DRIVER"                           
## [1581] "HOISTING ENGINEER"                            
## [1582] "SEWER BRICKLAYER"                             
## [1583] "LABORER - APPRENTICE"                         
## [1584] "CONSTRUCTION LABORER"                         
## [1585] "HOISTING ENGINEER"                            
## [1586] "CONSTRUCTION LABORER"                         
## [1587] "OPERATING ENGINEER-GROUP C"                   
## [1588] "ELECTRICAL MECHANIC"                          
## [1589] "HOISTING ENGINEER"                            
## [1590] "CONSTRUCTION LABORER"                         
## [1591] "CONSTRUCTION LABORER"                         
## [1592] "OPERATING ENGINEER-GROUP A"                   
## [1593] "MOTOR TRUCK DRIVER"                           
## [1594] "CAULKER"                                      
## [1595] "PLUMBER"                                      
## [1596] "MOTOR TRUCK DRIVER"                           
## [1597] "CEMENT FINISHER"                              
## [1598] "PAINTER"                                      
## [1599] "CONSTRUCTION LABORER"                         
## [1600] "CONSTRUCTION LABORER"                         
## [1601] "HOISTING ENGINEER"                            
## [1602] "OPERATING ENGINEER-GROUP C"                   
## [1603] "ELECTRICAL MECHANIC"                          
## [1604] "OPERATING ENGINEER-GROUP C"                   
## [1605] "FOREMAN OF SEWER CLEANING"                    
## [1606] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
## [1607] "HOISTING ENGINEER"                            
## [1608] "EMERGENCY CREW DISPATCHER"                    
## [1609] "MOTOR TRUCK DRIVER"                           
## [1610] "HOISTING ENGINEER"                            
## [1611] "HOISTING ENGINEER"                            
## [1612] "PLUMBER"                                      
## [1613] "SEWER BRICKLAYER"                             
## [1614] "FOREMAN OF PIPE / SALVAGE YARDS"              
## [1615] "FOREMAN OF HOISTING ENGINEERS"                
## [1616] "ASST CHIEF OPERATING ENGINEER"                
## [1617] "CONSTRUCTION LABORER"                         
## [1618] "CONSTRUCTION LABORER"                         
## [1619] "CONSTRUCTION LABORER"                         
## [1620] "OPERATING ENGINEER-GROUP C"                   
## [1621] "CONSTRUCTION LABORER"                         
## [1622] "MOTOR TRUCK DRIVER"                           
## [1623] "FOREMAN OF MOTOR TRUCK DRIVERS"               
## [1624] "FOREMAN OF SEWER BRICKLAYERS"                 
## [1625] "CONSTRUCTION LABORER"                         
## [1626] "LABORER - APPRENTICE"                         
## [1627] "CONSTRUCTION LABORER"                         
## [1628] "LABORER - APPRENTICE"                         
## [1629] "CONSTRUCTION LABORER"                         
## [1630] "MOTOR TRUCK DRIVER"                           
## [1631] "STEAMFITTER"                                  
## [1632] "MOTOR TRUCK DRIVER"                           
## [1633] "SEWER BRICKLAYER"                             
## [1634] "CONSTRUCTION LABORER"                         
## [1635] "PLUMBER"                                      
## [1636] "LABORER - APPRENTICE"                         
## [1637] "SEWER BRICKLAYER"                             
## [1638] "CONSTRUCTION LABORER"                         
## [1639] "CONSTRUCTION LABORER"                         
## [1640] "SEWER BRICKLAYER"                             
## [1641] "ASST CHIEF OPERATING ENGINEER"                
## [1642] "CONSTRUCTION LABORER"                         
## [1643] "SEWER BRICKLAYER"                             
## [1644] "MOTOR TRUCK DRIVER"                           
## [1645] "MACHINIST"                                    
## [1646] "CONSTRUCTION LABORER"                         
## [1647] "HOISTING ENGINEER"                            
## [1648] "MOTOR TRUCK DRIVER"                           
## [1649] "MOTOR TRUCK DRIVER"                           
## [1650] "HOISTING ENGINEER"                            
## [1651] "MOTOR TRUCK DRIVER"                           
## [1652] "HOISTING ENGINEER"                            
## [1653] "CONSTRUCTION LABORER"                         
## [1654] "OPERATING ENGINEER-GROUP C"                   
## [1655] "OPERATING ENGINEER-GROUP A"                   
## [1656] "FOREMAN OF WATER PIPE CONSTRUCTION"           
## [1657] "CONSTRUCTION LABORER"                         
## [1658] "CONSTRUCTION LABORER"                         
## [1659] "CONSTRUCTION LABORER"                         
## [1660] "CONSTRUCTION LABORER"                         
## [1661] "PLUMBER"                                      
## [1662] "CARPENTER"                                    
## [1663] "MOTOR TRUCK DRIVER"                           
## [1664] "WATCHMAN"                                     
## [1665] "HOISTING ENGINEER"                            
## [1666] "MOTOR TRUCK DRIVER"                           
## [1667] "CONSTRUCTION LABORER"                         
## [1668] "LABORER - APPRENTICE"                         
## [1669] "WATER METER MACHINIST"                        
## [1670] "WATCHMAN"                                     
## [1671] "POOL MOTOR TRUCK DRIVER"                      
## [1672] "OPERATING ENGINEER-GROUP A"                   
## [1673] "OPERATING ENGINEER-GROUP C"                   
## [1674] "OPERATING ENGINEER-GROUP A"                   
## [1675] "CONSTRUCTION LABORER"                         
## [1676] "CONSTRUCTION LABORER"                         
## [1677] "HOISTING ENGINEER"                            
## [1678] "HOISTING ENGINEER"                            
## [1679] "HOISTING ENGINEER"                            
## [1680] "OPERATING ENGINEER-GROUP A"                   
## [1681] "OPERATING ENGINEER-GROUP C"                   
## [1682] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
## [1683] "FOREMAN OF CONSTRUCTION LABORERS"             
## [1684] "EMERGENCY CREW DISPATCHER"                    
## [1685] "MOTOR TRUCK DRIVER"                           
## [1686] "PLUMBER"                                      
## [1687] "OPERATING ENGINEER-GROUP C"                   
## [1688] "MOTOR TRUCK DRIVER"                           
## [1689] "CONSTRUCTION LABORER"                         
## [1690] "CONSTRUCTION LABORER"                         
## [1691] "MOTOR TRUCK DRIVER"                           
## [1692] "CONSTRUCTION LABORER"                         
## [1693] "MOTOR TRUCK DRIVER"                           
## [1694] "LABORER - APPRENTICE"                         
## [1695] "OPERATING ENGINEER-GROUP C"                   
## [1696] "CEMENT FINISHER"                              
## [1697] "FOREMAN OF ELECTRICAL MECHANICS"              
## [1698] "EQUIPMENT DISPATCHER"                         
## [1699] "PAINTER"                                      
## [1700] "CONSTRUCTION LABORER"                         
## [1701] "CONSTRUCTION LABORER"                         
## [1702] "OPERATING ENGINEER-GROUP C"                   
## [1703] "CONSTRUCTION LABORER"                         
## [1704] "CONSTRUCTION LABORER"                         
## [1705] "CONSTRUCTION LABORER"                         
## [1706] "HOISTING ENGINEER"                            
## [1707] "CONSTRUCTION LABORER (SUB-FOREMAN)"           
## [1708] "CEMENT FINISHER"                              
## [1709] "CONSTRUCTION LABORER"                         
## [1710] "MOTOR TRUCK DRIVER"                           
## [1711] "HOISTING ENGINEER"                            
## [1712] "OPERATING ENGINEER-GROUP C"                   
## [1713] "HOISTING ENGINEER"                            
## [1714] "HOISTING ENGINEER"                            
## [1715] "CONSTRUCTION LABORER"                         
## [1716] "CONSTRUCTION LABORER"                         
## [1717] "OPERATING ENGINEER-GROUP C"                   
## [1718] "OPERATING ENGINEER-GROUP C"                   
## [1719] "OPERATING ENGINEER-GROUP A"                   
## [1720] "CONSTRUCTION LABORER"                         
## [1721] "OPERATING ENGINEER-GROUP C"                   
## [1722] "EMERGENCY CREW DISPATCHER"                    
## [1723] "ELECTRICAL MECHANIC"                          
## [1724] "OPERATING ENGINEER-GROUP C"                   
## [1725] "SEWER BRICKLAYER"                             
## [1726] "MOTOR TRUCK DRIVER"                           
## [1727] "PLUMBER"                                      
## [1728] "CONSTRUCTION LABORER"                         
## [1729] "CONSTRUCTION LABORER"                         
## [1730] "CONSTRUCTION LABORER"                         
## [1731] "CONSTRUCTION LABORER"                         
## [1732] "HOISTING ENGINEER"                            
## [1733] "CONSTRUCTION LABORER"                         
## [1734] "STEAMFITTER"                                  
## [1735] "WATCHMAN"                                     
## [1736] "PLUMBER"                                      
## [1737] "OPERATING ENGINEER-GROUP A"                   
## [1738] "FOREMAN OF SEWER BRICKLAYERS"                 
## [1739] "OPERATING ENGINEER-GROUP A"                   
## [1740] "ASST CHIEF OPERATING ENGINEER"                
## [1741] "CONSTRUCTION LABORER"                         
## [1742] "SEWER BRICKLAYER"                             
## [1743] "ELECTRICAL MECHANIC"                          
## [1744] "PAINTER"                                      
## [1745] "STATIONARY FIREMAN"                           
## [1746] "OPERATING ENGINEER-GROUP A"                   
## [1747] "OPERATING ENGINEER-GROUP C"                   
## [1748] "MOTOR TRUCK DRIVER"                           
## [1749] "ASST CHIEF OPERATING ENGINEER"                
## [1750] "CONSTRUCTION LABORER"                         
## [1751] "HOISTING ENGINEER"                            
## [1752] "PLUMBER"                                      
## [1753] "PLUMBER"                                      
## [1754] "PIPE LOCATING MACHINE OPERATOR"               
## [1755] "CONSTRUCTION LABORER"                         
## [1756] "HOISTING ENGINEER"                            
## [1757] "PLUMBER"                                      
## [1758] "CONSTRUCTION LABORER"                         
## [1759] "PLUMBER"                                      
## [1760] "OPERATING ENGINEER-GROUP A"                   
## [1761] "CONSTRUCTION LABORER"                         
## [1762] "OPERATING ENGINEER-GROUP C"                   
## [1763] "OPERATING ENGINEER-GROUP A"                   
## [1764] "OPERATING ENGINEER-GROUP A"                   
## [1765] "CONSTRUCTION LABORER"                         
## [1766] "ELECTRICAL MECHANIC"                          
## [1767] "FOREMAN OF WATER PIPE CONSTRUCTION"           
## [1768] "LABORER - APPRENTICE"                         
## [1769] "CONSTRUCTION LABORER"                         
## [1770] "CONSTRUCTION LABORER"                         
## [1771] "FOREMAN OF HOISTING ENGINEERS"                
## [1772] "MOTOR TRUCK DRIVER"                           
## [1773] "STATIONARY FIREMAN"                           
## [1774] "MOTOR TRUCK DRIVER"                           
## [1775] "PLUMBER"                                      
## [1776] "MOTOR TRUCK DRIVER"                           
## [1777] "CUSTODIAL WORKER"                             
## [1778] "LABORER - APPRENTICE"                         
## [1779] "CUSTODIAL WORKER"                             
## [1780] "HOISTING ENGINEER"                            
## [1781] "OPERATING ENGINEER-GROUP A"                   
## [1782] "OPERATING ENGINEER-GROUP C"                   
## [1783] "HOISTING ENGINEER"                            
## [1784] "SEWER BRICKLAYER"                             
## [1785] "ELECTRICAL MECHANIC"                          
## [1786] "OPERATING ENGINEER-GROUP C"                   
## [1787] "CONSTRUCTION LABORER"                         
## [1788] "MOTOR TRUCK DRIVER"                           
## [1789] "CONSTRUCTION LABORER"                         
## [1790] "CONSTRUCTION LABORER"                         
## [1791] "CONSTRUCTION LABORER"                         
## [1792] "SEWER BRICKLAYER"                             
## [1793] "FOREMAN OF HOISTING ENGINEERS"                
## [1794] "CONSTRUCTION LABORER"                         
## [1795] "LABORER - APPRENTICE"                         
## [1796] "CONSTRUCTION LABORER"                         
## [1797] "STATIONARY FIREMAN"                           
## [1798] "EMERGENCY CREW DISPATCHER"                    
## [1799] "CONSTRUCTION LABORER"                         
## [1800] "CONSTRUCTION LABORER"                         
## [1801] "WATER METER MACHINIST"                        
## [1802] "OPERATING ENGINEER-GROUP C"                   
## [1803] "CONSTRUCTION LABORER"                         
## [1804] "WATCHMAN"                                     
## [1805] "WATCHMAN"                                     
## [1806] "MOTOR TRUCK DRIVER"                           
## [1807] "HOISTING ENGINEER"                            
## [1808] "CAULKER"                                      
## [1809] "CONSTRUCTION LABORER"                         
## [1810] "CONSTRUCTION LABORER"                         
## [1811] "OPERATING ENGINEER-GROUP C"                   
## [1812] "CONSTRUCTION LABORER"                         
## [1813] "OPERATING ENGINEER-GROUP C"                   
## [1814] "CONSTRUCTION LABORER"                         
## [1815] "ELECTRICAL MECHANIC"                          
## [1816] "CONSTRUCTION LABORER"                         
## [1817] "WATCHMAN"                                     
## [1818] "OPERATING ENGINEER-GROUP C"                   
## [1819] "STEAMFITTER"                                  
## [1820] "CONSTRUCTION LABORER"                         
## [1821] "CONSTRUCTION LABORER"                         
## [1822] "CONSTRUCTION LABORER"                         
## [1823] "CONSTRUCTION LABORER"                         
## [1824] "ASST CHIEF OPERATING ENGINEER"                
## [1825] "MOTOR TRUCK DRIVER"                           
## [1826] "SEWER BRICKLAYER"                             
## [1827] "PLUMBER"                                      
## [1828] "CONSTRUCTION LABORER"                         
## [1829] "MOTOR TRUCK DRIVER"                           
## [1830] "CONSTRUCTION LABORER"                         
## [1831] "HOISTING ENGINEER"                            
## [1832] "HOISTING ENGINEER"                            
## [1833] "DECK HAND"                                    
## [1834] "MOTOR TRUCK DRIVER"                           
## [1835] "CONSTRUCTION LABORER"                         
## [1836] "MOTOR TRUCK DRIVER"                           
## [1837] "CONSTRUCTION LABORER"                         
## [1838] "MOTOR TRUCK DRIVER"                           
## [1839] "CONSTRUCTION LABORER"                         
## [1840] "OPERATING ENGINEER-GROUP C"                   
## [1841] "SEWER BRICKLAYER"                             
## [1842] "LABORER - APPRENTICE"                         
## [1843] "CONSTRUCTION LABORER"                         
## [1844] "ELECTRICAL MECHANIC"                          
## [1845] "CONSTRUCTION LABORER"                         
## [1846] "HOISTING ENGINEER"                            
## [1847] "CONSTRUCTION LABORER"                         
## [1848] "CONSTRUCTION LABORER"                         
## [1849] "CONSTRUCTION LABORER"                         
## [1850] "CONSTRUCTION LABORER"                         
## [1851] "ASST CHIEF OPERATING ENGINEER"                
## [1852] "SEWER BRICKLAYER"                             
## [1853] "PLUMBER"                                      
## [1854] "CONSTRUCTION LABORER"                         
## [1855] "CONSTRUCTION LABORER"                         
## [1856] "PLUMBER"                                      
## [1857] "CONSTRUCTION LABORER"                         
## [1858] "MOTOR TRUCK DRIVER"                           
## [1859] "OPERATING ENGINEER-GROUP A"                   
## [1860] "CONSTRUCTION LABORER"                         
## [1861] "MOTOR TRUCK DRIVER"                           
## [1862] "PLUMBER"                                      
## [1863] "CONSTRUCTION LABORER"
library(ggplot2)
chi_water_salary_viz <- qplot(x = `Job Titles`, y = `Annual Salary`, data = chicago_water_jobs)
chi_water_salary_viz
## Warning: Removed 1501 rows containing missing values (geom_point).

library(ggplot2)
chi_water_salary_viz <- qplot(x = `Job Titles`, y = `Hourly Rate`, data = chicago_water_jobs)
chi_water_salary_viz
## Warning: Removed 362 rows containing missing values (geom_point).

Here we can start to see a clearer distribution of annual salary and hourly wage by considering only the water department. We can do the same for HR below

# Filtering for human resources jobs

chicago_hr_jobs <- chicago_city_jobs %>%
  filter(`Department` == "HUMAN RESOURCES") %>%
  select(`Job Titles`, Department, `Annual Salary`, `Typical Hours`, `Hourly Rate`, `Full or Part-Time`) %>% 
  arrange(-`Annual Salary`)

print(chicago_hr_jobs$`Job Titles`)
##  [1] "FIRST DEPUTY COMMISSIONER"            
##  [2] "MANAGING DEPUTY COMMISSIONER"         
##  [3] "DEPUTY COMMISSIONER"                  
##  [4] "DEPUTY COMMISSIONER"                  
##  [5] "DEPUTY COMMISSIONER"                  
##  [6] "RECRUITER"                            
##  [7] "RECRUITER"                            
##  [8] "RECRUITER"                            
##  [9] "RECRUITER"                            
## [10] "RECRUITER"                            
## [11] "RECRUITER"                            
## [12] "RECRUITER"                            
## [13] "ADMINISTRATIVE SERVICES OFFICER II"   
## [14] "RECRUITER"                            
## [15] "CLASSIFICATION & COMPENSATION ANALYST"
## [16] "ASST COMMISSIONER"                    
## [17] "TESTING MANAGER"                      
## [18] "SR PROGRAMMER/ANALYST - EXCLD"        
## [19] "SR PROGRAMMER/ANALYST - EXCLD"        
## [20] "SR PROGRAMMER/ANALYST - EXCLD"        
## [21] "DISABILITY OFFICER"                   
## [22] "EQUAL EMPLOYMENT OPPORTUNITY OFFICER" 
## [23] "RECRUITER"                            
## [24] "RECRUITER"                            
## [25] "RECRUITER"                            
## [26] "TRAINING & DEVELOPMENT ANALYST"       
## [27] "TRAINING & DEVELOPMENT ANALYST"       
## [28] "TRAINING & DEVELOPMENT ANALYST"       
## [29] "RECRUITER"                            
## [30] "HR GENERALIST - DHR"                  
## [31] "RECRUITER"                            
## [32] "RECRUITER"                            
## [33] "RECRUITER"                            
## [34] "CLASSIFICATION & COMPENSATION ANALYST"
## [35] "TESTING SPECIALIST"                   
## [36] "CLINICAL THERAPIST III - EXCLD"       
## [37] "TESTING ADMINISTRATOR"                
## [38] "TESTING ADMINISTRATOR"                
## [39] "EXEC ADMINISTRATIVE ASST II"          
## [40] "HR RECORDS ADMINISTRATION MANAGER"    
## [41] "ADMINISTRATIVE MANAGER"               
## [42] "TESTING SPECIALIST"                   
## [43] "TESTING SPECIALIST"                   
## [44] "EEO INVESTIGATOR"                     
## [45] "TESTING ADMINISTRATOR"                
## [46] "EEO INVESTIGATOR"                     
## [47] "EEO INVESTIGATOR"                     
## [48] "EEO INVESTIGATOR"                     
## [49] "EEO INVESTIGATOR"                     
## [50] "TRAINING & DEVELOPMENT ANALYST"       
## [51] "COMPLIANCE OFFICER"                   
## [52] "EEO INVESTIGATOR"                     
## [53] "ADMINISTRATIVE ASST III"              
## [54] "EXEC ADMINISTRATIVE ASST II"          
## [55] "HR RECORDS SPECIALIST"                
## [56] "HR GENERALIST - DHR"                  
## [57] "HR GENERALIST - DHR"                  
## [58] "ASSOC CLASSIFICATION & COMP ANALYST"  
## [59] "ASSOC CLASSIFICATION & COMP ANALYST"  
## [60] "EXEC ADMINISTRATIVE ASST I"           
## [61] "ADMINISTRATIVE ASST II"               
## [62] "PROJECT COORD"                        
## [63] "HR RECORDS SPECIALIST"                
## [64] "ADMINISTRATIVE ASST II"               
## [65] "HR RECORDS SPECIALIST"                
## [66] "TESTING ADMINISTRATOR"                
## [67] "HR RECORDS SPECIALIST"                
## [68] "HR RECORDS SPECIALIST"                
## [69] "INQUIRY AIDE III"                     
## [70] "ADMINISTRATIVE ASST III - EXCLUDED"   
## [71] "ADMINISTRATIVE ASST II"               
## [72] "CLERK III - EXCLD"
library(ggplot2)
chi_hr_salary_viz <- qplot(x = `Job Titles`, y = `Annual Salary`, data = chicago_hr_jobs)
chi_hr_salary_viz

Filtering departments each by water and human resources provides a clearer look into the current positions and their pay. Let’s try being more deliberate in our search.

# Filtering for water analyst and/or administrative jobs (essentially jobs I may have transferable job experience for)
library(stringr)

meet_minqual_water_jobs <-
  chicago_water_jobs %>%
  mutate(
    admin_water = str_detect(`Job Titles`, "ADMINISTRATIVE"), 
    analyst_water = str_detect(`Job Titles`, "ANALYST"),
    water_all = str_detect(`Job Titles`, "WATER")
    ) %>%
  filter(admin_water | analyst_water | water_all)

# After examining the data, there may be only one "ideal" position based on my previous work experience for SFPUC Water Conservation. I will revise my above code to single it out:

meet_minqual_water_jobs_revised <-
  chicago_water_jobs %>%
  mutate(
    admin_water = str_detect(`Job Titles`, "ADMINISTRATIVE"), 
    analyst_water = str_detect(`Job Titles`, "ANALYST"),
    water_all = str_detect(`Job Titles`, "WATER"),
    water_conservation = str_detect(`Job Titles`, "CONSERVATION")
    ) %>%
  filter(water_conservation)

It looks like we can stop here. However, what if we wanted to consider a part-time position while attending Harris? This would surely open up our possibilities to much more departments. Let’s go back to our original city dataset and create a ranking that considers all factors of my job search.

# Replace NA Typical Hours for Salaried jobs to 40
chicago_city_jobs_clean <- chicago_city_jobs %>%
  mutate(`Typical Hours` = `Typical Hours` %>%
           is.na %>%
           ifelse("40", `Typical Hours`))

# Replace NA Hourly Rates with equivalent hourly wage from Annual Salary
chicago_city_jobs_clean <- chicago_city_jobs_clean %>%
  mutate(`Hourly Rate` = `Hourly Rate` %>%
           is.na %>%
           ifelse((`Annual Salary`/2080), `Hourly Rate`)) %>%
  arrange(-`Hourly Rate`)

# Replace hard to read F and P with Full and Part for Full or Part Time
chicago_city_jobs_clean <- chicago_city_jobs_clean %>%
  mutate(`Full or Part-Time` = case_when(
    `Full or Part-Time` == "F" ~ "Full",
    `Full or Part-Time` == "P" ~ "Part",
    TRUE ~ `Full or Part-Time`
  ))

# Include our code to identify all desirable position factors
chicago_city_jobs_clean <- chicago_city_jobs_clean %>%
  mutate(Admin_position = str_detect(`Job Titles`, "ADMINISTRATIVE")) %>%
  mutate(Analyst_position = str_detect(`Job Titles`, "ANALYST")) %>%
  mutate(Water_position = str_detect(`Department`, "WATER")) %>%
  mutate(hr_position = str_detect(`Department`, "HUMAN")) %>%
  mutate(conservation_position = str_detect(`Job Titles`, "CONSERVATION")) %>%
  mutate(Part_Time_Over_20perhour = ifelse(`Full or Part-Time` == "Part" & `Hourly Rate` > 20, TRUE, FALSE)) %>%
  mutate(Full_Time_Over_40perhour = ifelse(`Full or Part-Time` == "Full" & `Hourly Rate` > 40, TRUE, FALSE)) %>% 
  mutate(num_desirable_job_traits = Admin_position + Analyst_position + Water_position + hr_position + conservation_position + Part_Time_Over_20perhour + Full_Time_Over_40perhour,
         rank = case_when(num_desirable_job_traits == 5 ~ "1",
                          num_desirable_job_traits == 4 ~ "2",
                          num_desirable_job_traits == 3 ~ "3",
                          num_desirable_job_traits == 2 ~ "4",
                          num_desirable_job_traits == 1 ~ "5",
                          num_desirable_job_traits == 0 ~ "Unranked")) %>%
  arrange(rank)
#Grouping top ranked data  
library(plotly)
## 
## Attaching package: 'plotly'
## The following object is masked from 'package:ggplot2':
## 
##     last_plot
## The following object is masked from 'package:stats':
## 
##     filter
## The following object is masked from 'package:graphics':
## 
##     layout
x <- chicago_city_jobs_clean 

y <- head(x,5)

options(repr.plot.width=8, repr.plot.height=3)
ggplot(y, aes(x = `Job Titles`, y = `Hourly Rate`, main="Desired City Jobs")) +
         geom_bar(stat = "identity") +
         coord_flip() + scale_y_continuous(name="Hourly Rate, dollars") +
  scale_x_discrete(name="Job Titles") +
theme(axis.text.x = element_text(face="bold", color="#008000",
                           size=8, angle=0),
          axis.text.y = element_text(face="bold", color="#008000",
                           size=8, angle=0))