From a 500-row sample across 19 columns.
published_datemilist_div_code+17miexam_nofirst_name+6| exam_no | list_no | first_name | last_name | adj_fa | list_title_code | list_title_desc | group_no | list_agency_code | list_agency_desc | established_date | anniversary_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0514 | 49 | GIUSEPPE | BONDI | 83.89 | 31220 | ASSOCIATE PUBLIC HEALTH SANITARIAN | 000 | 816 | DEPARTMENT OF HEALTH AND MENTAL HYGIENE | 2021-05-26T00:00:00.000 | 2025-05-26T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
exam_no | text | A four (4) digit number that identifies a civil service examination. | 0% | 500170012000 |
list_no | integer | An eligible candidate’s placement on a given list as of the business day that the data set is populated. | 0% | 123 |
first_name | text | A candidate’s first name as it appears on their application. | 0% | MICHAELCHRISTOPHERJOSEPH |
mi | text | A candidate’s middle initial (MI) as it appears on their application. | 38% | AJM |
GET /api/datasets/qu8g-sxqf GET /api/datasets/qu8g-sxqf/quality GET /api/datasets/qu8g-sxqf/related GET /api/columns?dataset=qu8g-sxqf
| 7605 |
| 8 |
| RAVINDRA |
| MANGAL |
| 96.25 |
| 12216 |
| RAILROAD STOCK WORKER |
| 000 |
| 000 |
| — |
| 2018-12-12T00:00:00.000 |
| 2022-12-12T00:00:00.000 |
| 7605 | 43.5 | JAMIL | BERNARD | 91.25 | 12216 | RAILROAD STOCK WORKER | 000 | 000 | — | 2018-12-12T00:00:00.000 | 2022-12-12T00:00:00.000 |
| 9709 | 20 | CHRISTOPHER | JAMES | 74.46 | 91881 | MAINTENANCE SUPERVISOR (POWER DISTRIBUTION) | 000 | 998 | N.Y.C. TRANSIT AUTHORITY | 2021-04-14T00:00:00.000 | 2025-04-14T00:00:00.000 |
| 7605 | 54 | SAHARA | COX | 88.75 | 12216 | RAILROAD STOCK WORKER | 000 | 000 | — | 2018-12-12T00:00:00.000 | 2022-12-12T00:00:00.000 |
| 0514 | 118 | GLEN | WOODLEY | 77.2 | 31220 | ASSOCIATE PUBLIC HEALTH SANITARIAN | 000 | 816 | DEPARTMENT OF HEALTH AND MENTAL HYGIENE | 2021-05-26T00:00:00.000 | 2025-05-26T00:00:00.000 |
| 0514 | 1 | NICOLE | BLAKE | 88.48 | 31220 | ASSOCIATE PUBLIC HEALTH SANITARIAN | 000 | 826 | DEPARTMENT OF ENVIRONMENTAL PROTECTION | 2021-05-26T00:00:00.000 | 2025-05-26T00:00:00.000 |
| 9702 | 3 | GREGORY | DELISO | 83.89 | 91890 | MAINTENANCE SUPERVISOR (STRUCTURES-GROUP E-PLUMBING) | 000 | 998 | N.Y.C. TRANSIT AUTHORITY | 2019-12-26T00:00:00.000 | 2023-12-26T00:00:00.000 |
| 9709 | 4 | CLINTON | JACOBS | 83.03 | 91881 | MAINTENANCE SUPERVISOR (POWER DISTRIBUTION) | 000 | 998 | N.Y.C. TRANSIT AUTHORITY | 2021-04-14T00:00:00.000 | 2025-04-14T00:00:00.000 |
| 9702 | 14 | RUSTAM | MURATOV | 79.71 | 91890 | MAINTENANCE SUPERVISOR (STRUCTURES-GROUP E-PLUMBING) | 000 | 998 | N.Y.C. TRANSIT AUTHORITY | 2019-12-26T00:00:00.000 | 2023-12-26T00:00:00.000 |
Showing 12 of 15 columns. All of them are listed below.
last_name |
| text |
| A candidate’s last name as it appears on their application. |
| 0% |
WILLIAMSRODRIGUEZSMITH |
adj_fa | float | The Adjusted Final Average (“Adj. FA” or “AFA”) is an eligible candidate’s test score in addition to any additional credits granted. | 0% | 1007080 |
list_title_code | text | A five (5) digit number that corresponds to and represents a civil service title. | 0% | 703107021070112 |
list_title_desc | text | A descriptive name that identifies a civil service title. | 0% | FIREFIGHTERPOLICE OFFICERSANITATION WORKER |
group_no | categorical | 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). | 0% | 000001004of 6 |
list_agency_code | text | A three (3) digit number used to identify an agency (For Promotion List Only). | 0% | 000056998 |
list_agency_desc | text | The name of an appointing Agency. | 41% | FIRE DEPARTMENTN.Y.C. TRANSIT AUTHORITYPOLICE DEPARTMENT |
list_div_code | text | The promotional division codes/descriptions within the New York City Transit Authority only. | 100% | CPBBCC |
published_date | datetime | The date on which an eligible list is made available for review by the general public and appointing agencies. | 38% | 2015-09-23T00:00:00.0002012-10-03T00:00:00.0002009-08-12T00:00:00.000 |
established_date | datetime | The date on which an eligible list is made available for certification to agencies to consider an eligible candidate for appointment. | 0% | 2016-03-16T00:00:00.0002019-02-27T00:00:00.0002013-06-26T00:00:00.000 |
anniversary_date | datetime | The date on which an eligible list is scheduled to expire. | 0% | 2020-03-16T00:00:00.0002023-02-27T00:00:00.0002017-06-26T00:00:00.000 |
extension_date | datetime | The date on which a list will be extended beyond its original expiration date. | 51% | 2024-03-16T00:00:00.0002018-02-16T00:00:00.0002025-07-31T00:00:00.000 |
termination_date | datetime | The date on which a list is no longer available for use to make appointments. | 0% | 2024-02-28T00:00:00.0002025-05-27T00:00:00.0002017-06-26T00:00:00.000 |
veteran_credit | categorical | 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. | 98% | Veteran's CreditDisabled Veteran's Credi…of 2 |
parent_lgy_credit | text | 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). | 100% | Parent Legacy Creditof 1 |
sibling_lgy_credit | text | 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). | 100% | Sibling Legacy Creditof 1 |
residency_credit | text | 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. | 81% | Residency Creditof 1 |