What is Civil Service?
Civil Service is essentially working for the government rather than a private or public business. It is "the permanent professional branches of a government's administration" excluding military and judicial branches and elected politicians. If you choose a civil service job you are working for the government of a city or state. In order to work in Civil Service, you have to pass one or more tests.
What is in the data set you will be working with?
Above is a REAL DATA SET. It is every person in New York City who has passed a Civil Service Exam since 2012. More than 58000 rows of data. These are real names and real test scores. Below are explanations of each column of the dataset.
Column Name |
Description |
Exam No |
A four (4) digit number that identifies a civil service examination. |
List No |
An eligible candidate’s placement on a given list as of the business day that the data set is populated. |
First Name |
A candidate’s first name as it appears on their application. |
MI |
Middle initial |
Last Name |
A candidate’s last name as it appears on their application |
Adj. FA |
The Adjusted Final Average (“Adj. FA” or “AFA”) is an eligible candidate’s test score in addition to any additional credits granted. |
List Test Code |
A five (5) digit number that corresponds to and represents a civil service title. |
List Title Disc |
A descriptive name that identifies a civil service title. |
Group No |
Represents the certification order for a list. (e.g. – eligible candidates on a list with a 01 group number may be considered for appointment before an eligible candidate on primary list with a 00 group number). |
List Agency Code |
A three (3) digit number used to identify an agency (For Promotion List Only) |
List Agency Desc |
The name of an appointing Agency |
List Div Code |
The promotional division codes/descriptions within the New York City Transit Authority only |
Published Date |
The date on which an eligible list is made available for review by the general public and appointing agencies. |
Established Date |
The date on which an eligible list is made available for certification to agencies to consider an eligible candidate for appointment |
Anniversary Date |
The date on which an eligible list is scheduled to expire. |
Extension Date |
The date on which a list will be extended beyond its original expiration date |
Veteran Credit |
An additional credit given to a Veteran (5 points) or disabled veteran (10 points) when s/he accepts a permanent position from an eligible list |
Parent LGY Credit |
A “Parent Legacy credit” is an additional credit given on an exam (10 points) to a candidate who lost a parent (FDNY, NYPD, or a First Responder, during or as a result of 911). |
Sibling LGY Credit |
A “Sibling Legacy Credit” is additional credit given on an exam (10 points) to a candidate who lost a sibling (FDNY, NYPD, or a First Responder, during or as a result of 911) |
Residency Credit |
An additional credit given on an exam to a candidate who maintains a continuous period of residency in New York City as described in the Notice of Examination for a specific title |
What do you need to figure out and show me?
1.) Tell me how many different job types there are.
2.) Give me a tally of how many candidates there are for each job type.
3.) Give me an average score for each exam.
4.) What year do the largest number of exams expire?
5.) The police department needs a new commissioner and leadership team. With the LIMITED data you have, nominate a person on the list for Police Commissioner and four more for leadership team.
2.) Give me a tally of how many candidates there are for each job type.
3.) Give me an average score for each exam.
4.) What year do the largest number of exams expire?
5.) The police department needs a new commissioner and leadership team. With the LIMITED data you have, nominate a person on the list for Police Commissioner and four more for leadership team.