From a 500-row sample across 29 columns.
| job_id | agency | posting_type | number_of_positions | business_title | civil_service_title | title_classification | title_code_no | level | job_category | full_time_part_time_indicator | career_level |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 801875 | DISTRICT ATTORNEY RICHMOND COU | Internal | 5 | Criminal Court Assistant | COMMUNITY ASSOCIATE | Non-Competitive-5 | 56057 | 00 | Legal Affairs | F | Entry-Level |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
job_id | text | Job Opening ID. | 0% | 792963793034795428 |
agency | text | Name of the City agency where the vacancy exists. | 0% | DEPT OF HEALTH/MENTAL HY…DEPT OF ENVIRONMENT PROT…DEPT OF DESIGN & CONSTRU… |
posting_type | categorical | Internal or External job posting. | 0% | ExternalInternalof 2 |
number_of_positions | text | Number of vacancies to be filled. | 0% | 123 |
GET /api/datasets/kpav-sd4t GET /api/datasets/kpav-sd4t/quality GET /api/datasets/kpav-sd4t/related GET /api/columns?dataset=kpav-sd4t
| 793589 | DEPT OF DESIGN & CONSTRUCTION | External | 1 | Project Manager | ASSISTANT URBAN DESIGNER | Competitive-1 | 22092 | 00 | Engineering, Architecture, & Planning | F | Experienced (non-manager) |
| 783450 | HRA/DEPT OF SOCIAL SERVICES | External | 1 | REGIONAL LIAISON | ASSOCIATE BENEFITS OPPORTUNITY | Competitive-1 | 56316 | 03 | Social Services | F | Experienced (non-manager) |
| 800066 | DEPT OF DESIGN & CONSTRUCTION | Internal | 1 | Auditor | ASSOCIATE PROJECT MANAGER | Competitive-1 | 22427 | 01 | Engineering, Architecture, & Planning | F | Experienced (non-manager) |
| 790499 | BRONX DISTRICT ATTORNEY | External | 1 | Labor Relations Specialist | COMMUNITY COORDINATOR | Non-Competitive-5 | 56058 | 00 | Administration & Human Resources Legal Affairs | F | Experienced (non-manager) |
| 803016 | DEPT OF ENVIRONMENT PROTECTION | Internal | 1 | PERMIT COORDINATOR | ASSISTANT ENVIRONMENTAL ENGINE | Competitive-1 | 20617 | 00 | Engineering, Architecture, & Planning Policy, Research & Analysis | F | Experienced (non-manager) |
| 795895 | DEPT OF HEALTH/MENTAL HYGIENE | Internal | 1 | Bioinformatics Scientist , Bureau of the Public Health Laboratory | CITY RESEARCH SCIENTIST | Non-Competitive-5 | 21744 | 03 | Health Policy, Research & Analysis | F | Experienced (non-manager) |
| 797684 | BRONX DISTRICT ATTORNEY | Internal | 5 | Therapist - Crime Victims Assistance Bureau | COMMUNITY COORDINATOR | Non-Competitive-5 | 56058 | 00 | Constituent Services & Community Programs Mental Health Legal Affairs Social Services | F | Experienced (non-manager) |
| 803054 | DEPT OF ENVIRONMENT PROTECTION | Internal | 1 | ASSISTANT PROJECT MANAGER | PROJECT MANAGER | Competitive-1 | 22426 | 00 | Engineering, Architecture, & Planning Public Safety, Inspections, & Enforcement | F | Entry-Level |
| 796646 | DEPT OF HEALTH/MENTAL HYGIENE | External | 1 | Agency Attorney, Bureau of Environmental Surveillance and Policy | AGENCY ATTORNEY | Non-Competitive-5 | 30087 | 02 | Legal Affairs | F | Experienced (non-manager) |
Showing 12 of 28 columns. All of them are listed below.
business_title | text | Business title | 0% | Project ManagerACCOUNTABLE MANAGERASSISTANT PROJECT MANAGE… |
civil_service_title | text | Civil Service title | 0% | COMMUNITY COORDINATORCITY RESEARCH SCIENTISTCOMMUNITY ASSOCIATE |
title_classification | categorical | The civil service title jurisdiction classification that corresponds to the civil service title posted. The civil service title classification. | 0% | Competitive-1Non-Competitive-5Pending Classification-2of 6 |
title_code_no | text | Civil Service title Code | 0% | 560582174456057 |
level | text | Civil Service title level | 0% | 000201 |
job_category | text | The occupational group in which the posted job belongs. | 0% | Engineering, Architectur…Legal AffairsHealth |
full_time_part_time_indicator | categorical | "This denotes whether the job is a full time or part time employment. " | 0% | FPof 2 |
career_level | categorical | This denotes the career level of the job. The possible career levels. | 0% | Experienced (non-manager…Entry-LevelManagerof 5 |
salary_range_from | text | Proposed salary from: range. (Can be 0) | 0% | 663306286878740 |
salary_range_to | text | Proposed salary to: range. (Can be 0) | 0% | 762797229899528 |
salary_frequency | categorical | Proposed salary frequency | 0% | AnnualHourlyDailyof 3 |
work_location | text | Agency location. | 0% | 30-30 Thomson Ave L I Ci…42-09 28th Street96-05 Horace Harding Exp… |
division_work_unit | text | Department/Division within the hiring agency. | 0% | PROJECT MANAGEMENT AND C…Support StaffFIA Operations-NM |
job_description | text | Description of the job responsibilities for this position. | 0% | The Department of Social…The NYC Department of En…Updated New York State E… |
minimum_qual_requirements | text | Minimum qualifications required for position. | 1% | 1. A baccalaureate degre…1. For Assignment Level…Qualification Requiremen… |
preferred_skills | text | Preferred skills for this position. | 47% | Candidates should have t…Candidates should have a…• In depth knowledge of … |
additional_information | text | Additional information provided by the hiring agency. | 68% | The Human Resources Admi…The Human Resources Admi…The Human Resources Admi… |
to_apply | text | Instructions on how to apply for this postion. | 54% | Click "Apply Now" ButtonClick the "Apply" button…To apply for this positi… |
hours_shift | text | Working hours and shift information. | 85% | 8:00AM - 4:00PM/Monday -…35hrs35 hours per week |
work_location_1 | text | Specific work location for this opening. | 0% | 30-30 Thomson Ave L I Ci…42-09 28th Street96-05 Horace Harding Exp… |
recruitment_contact | text | Recruitment contact information. | 100% | — |
residency_requirement | text | Residency requirements for this position. | 0% | New York City residency …New York City Residency …New York City Residency … |
posting_date | datetime | Date that the position was posted. | 0% | 2026-09-24T00:00:00.0002026-09-25T00:00:00.0002026-09-23T00:00:00.000 |
post_until | text | Date Posting will be removed. (Blank means post until filled) | 1% | 11-OCT-202616-OCT-202622-NOV-2026 |
posting_updated | datetime | Last Modification Date. | 0% | 2026-10-02T00:00:00.0002026-09-25T00:00:00.0002026-10-05T00:00:00.000 |
process_date | datetime | Dataset created date. | 0% | 2026-10-06T00:00:00.000of 1 |