From a 500-row sample across 12 columns.
agency_namepublication_dateagency_namepublication_dateagency_namepublication_date| publication_date | agency_code | agency_name | ua_code | ua_name | title_code | title_code_name | minmum_salary | maxmum_salary | positions | mean_salary | annual_rate |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20200630 | 002 | MAYORALTY | 020 | OFFICE OF THE MAYOR-PS | 10146 | ADMINISTRATIVE ASSISTANT TO THE MAYOR | 105755 | 105755 | 1 | 105755 | 105755 |
| 20200630 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
publication_date | categorical | 8-digit number for date of publication. | 0% | 202602172026051220250116of 13 |
agency_code | text | 3-digit code which identifies an agency. | 0% | 040816056 |
agency_name | text | Descriptive name associated with the 3-digit code. | 0% | DEPARTMENT OF EDUCATIONDEPARTMENT OF HEALTH AND…POLICE DEPARTMENT |
ua_code | text | 3-digit code which represents the amount for a particular program, purpose, activity or institution in an agency's budget. The unit of appropriation ("U/A") is the most general level of detail within an agency's operating budget. It is at this funding level that the City Council approves and adopts the city's Expense Budget. |
GET /api/datasets/f4wx-5ve6 GET /api/datasets/f4wx-5ve6/quality GET /api/datasets/f4wx-5ve6/related GET /api/columns?dataset=f4wx-5ve6
agency_name| 002 |
| MAYORALTY |
| 020 |
| OFFICE OF THE MAYOR-PS |
| 30070 |
| ASSISTANT LEGISLATIVE REPRESENTATIVE |
| 83430 |
| 227738 |
| 8 |
| 110897 |
| 887179 |
| 20200630 | 002 | MAYORALTY | 020 | OFFICE OF THE MAYOR-PS | 6144 | ASSISTANT LEGISLATIVE REPRESENTATIVE (MA) | 79310 | 123600 | 2 | 101455 | 202910 |
| 20200630 | 002 | MAYORALTY | 020 | OFFICE OF THE MAYOR-PS | 5278 | ASSISTANT TO THE DEPUTY MAYOR (OFFICE OF THE MAYOR) | 69525 | 211150 | 3 | 151925 | 455775 |
| 20200630 | 002 | MAYORALTY | 020 | OFFICE OF THE MAYOR-PS | 13209 | ASSISTANT TO THE MAYOR | 156556 | 156556 | 1 | 156556 | 156556 |
| 20200630 | 002 | MAYORALTY | 020 | OFFICE OF THE MAYOR-PS | 5454 | ASST DIR OF INTERGVNMENTAL RELTNS FOR THE ALBANY OFFICE (MA) | 203996 | 203996 | 1 | 203996 | 203996 |
| 20200630 | 002 | MAYORALTY | 020 | OFFICE OF THE MAYOR-PS | 6558 | ASST DIRECTOR OF INTERGOVERMENTAL REL FOR CITY LEGIST AFFS | 180472 | 180472 | 1 | 180472 | 180472 |
| 20200630 | 002 | MAYORALTY | 020 | OFFICE OF THE MAYOR-PS | 6809 | CHIEF OF STAFF - MAYOR'S OFFICE | 243853 | 243853 | 1 | 243853 | 243853 |
| 20200630 | 002 | MAYORALTY | 020 | OFFICE OF THE MAYOR-PS | 6814 | CHIEF SERVICE OFFICER (MA) | 180250 | 180250 | 1 | 180250 | 180250 |
| 20200630 | 002 | MAYORALTY | 020 | OFFICE OF THE MAYOR-PS | 6813 | COMMISS OF THE OFF TO END DOMEST AND GEND BA VIOL (MA) | 227786 | 227786 | 1 | 227786 | 227786 |
| 0% |
001002003 |
ua_name | text | Descriptive name associated with the 3-digit code. | 0% | PERSONAL SERVICESADMINISTRATIONEXECUTIVE ADMINISTRATIVE |
title_code | text | 5-character code which identifies a title. | 0% | 560585605710124 |
title_code_name | text | Briefly describes the position held by an employee. | 0% | COMMUNITY COORDINATORCOMMUNITY ASSOCIATEPRINCIPAL ADMINISTRATIVE… |
minmum_salary | integer | Least paid full-time active position in the title description. | 0% | 942446564090000 |
maxmum_salary | integer | Highest paid full-time active position in the title description. | 0% | 15000090619125000 |
positions | integer | Number of full-time active employees in a title. | 0% | 123 |
mean_salary | integer | A mean salary estimate is calculated by summing the salaries of all employees in a given title and dividing the total by the number of employees. | 0% | 75690243171125000 |
annual_rate | integer | Sum of the salaries paid to the fulltime active employees in a title description. | 0% | 243171150000125000 |