From a 500-row sample across 17 columns.
exam_nolist_nofirst_name+6exam_nolist_nofirst_name+17first_namelast_name| exam_no | list_no | first_name | mi | last_name | adj_fa | list_title_code | list_title_desc | group_no | list_agency_code | list_agency_desc | established_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2609 | 1 | JETON | T | ABDULOVSKI | 100 | 92245 | STRUCTURE MAINTAINER - GROUP B | 000 | 000 | OPEN COMPETITIVE | 2023-11-15T00:00:00.000 |
| 6073 |
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% | 660120604044 |
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% | MICHAELCHRISTOPHERANTHONY |
mi | text | A candidate’s middle initial (MI) as it appears on their application. | 49% | AMJ |
GET /api/datasets/vx8i-nprf GET /api/datasets/vx8i-nprf/quality GET /api/datasets/vx8i-nprf/related GET /api/columns?dataset=vx8i-nprf
first_namelast_name| 136 |
| MICHAEL |
| — |
| ZAMBINO |
| 100 |
| 92225 |
| MASON'S HELPER |
| 000 |
| 000 |
| OPEN COMPETITIVE |
| 2025-11-12T00:00:00.000 |
| 5121 | 41 | BELINDA | L | HAMLET - BENT | 100 | 54483 | SCHOOL FOOD SERVICE MANAGER | 000 | 000 | OPEN COMPETITIVE | 2025-08-27T00:00:00.000 |
| 2060 | 2124 | NICOLAS | A | SANCHEZ | 106 | 70112 | SANITATION WORKER | 000 | 000 | OPEN COMPETITIVE | 2024-02-28T00:00:00.000 |
| 2110 | 2373 | ALEXANDRA | — | BURGOS | 85 | 70210 | POLICE OFFICER | 000 | 000 | OPEN COMPETITIVE | 2022-07-06T00:00:00.000 |
| 6601 | 12776 | DANTE | W | EDMONDS | 91 | 91207 | CONDUCTOR | 000 | 000 | OPEN COMPETITIVE | 2018-02-14T00:00:00.000 |
| 2060 | 6202 | JAKE | M | LATONA | 103 | 70112 | SANITATION WORKER | 000 | 000 | OPEN COMPETITIVE | 2024-02-28T00:00:00.000 |
| 4044 | 6756 | BERNARDO | — | FLORES COREA | 97 | 70310 | FIREFIGHTER | 000 | 000 | OPEN COMPETITIVE | 2026-01-21T00:00:00.000 |
| 2060 | 17221 | HECTOR | L | ROMAN | 94 | 70112 | SANITATION WORKER | 000 | 000 | OPEN COMPETITIVE | 2024-02-28T00:00:00.000 |
| 8600 | 855 | KEMAR | — | SMITH | 95 | 90744 | TRACK WORKER | 000 | 000 | OPEN COMPETITIVE | 2020-01-08T00:00:00.000 |
Showing 12 of 16 columns. All of them are listed below.
last_name |
| text |
| A candidate’s last name as it appears on their application. |
| 0% |
WILLIAMSRODRIGUEZBROWN |
adj_fa | integer | The Adjusted Final Average (“Adj. FA” or “AFA”) is an eligible candidate’s test score in addition to any additional credits granted. | 0% | 1007090 |
list_title_code | text | A five (5) digit number that corresponds to and represents a civil service title. | 0% | 702109120770112 |
list_title_desc | text | A descriptive name that identifies a civil service title. | 0% | POLICE OFFICERCONDUCTORSANITATION 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% | 000001of 2 |
list_agency_code | text | A three (3) digit number used to identify an agency (For Promotion List Only). | 0% | 000998056 |
list_agency_desc | text | The name of an appointing Agency. | 0% | OPEN COMPETITIVEN.Y.C. TRANSIT AUTHORITYPOLICE DEPARTMENT |
list_div_code | text | The promotional division codes/descriptions within the New York City Transit Authority only. | 100% | — |
published_date | datetime | The date on which an eligible list is made available for review by the general public and appointing agencies. | 70% | 2023-07-12T00:00:00.0002026-05-06T00:00:00.0002022-07-06T00: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. | 8% | 2018-02-14T00:00:00.0002024-02-28T00:00:00.0002026-01-21T00:00:00.000 |
anniversary_date | datetime | The date on which an eligible list is scheduled to expire. | 8% | 2022-02-14T00:00:00.0002028-02-28T00:00:00.0002030-01-21T00:00:00.000 |
extension_date | datetime | The date on which a list will be extended beyond its original expiration date. | 77% | 2027-02-14T00:00:00.0002027-09-19T00:00:00.0002027-01-08T00: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. | 83% | Residency Creditof 1 |