From a 500-row sample across 19 columns.
init_nminit_sav_grp_nminit_sav_type+10agency_cdpub_dateagency_nameagency_namefiscal_yearagency_namefiscal_year| pub_date | agency_cd | agency_name | init_type | init_grp | funding | fiscal_year | num_yrs_prsnt | psl_typ | fy1_hc | fy2_hc | fy3_hc |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20180201 | 56 | Police Department | BAS | Baseline Per November 2017 Plan | C | 2018 | 5 | U | 35914 | 35914 | 35914 |
| 20180201 | 56 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
pub_date | integer | Date of data published. (e.g. 20170426) | 0% | 202605122018042620200416 |
agency_cd | text | 3-digit code which identifies an agency (e.g. 056 is the Police Department). | 0% | 82781640 |
agency_name | text | Descriptive name associated with the 3-digit code (e.g. "Mayoralty, Board of Elections, Law Department"). | 0% | Department of EducationDepartment of SanitationMayoralty |
init_type | categorical | "3-letter to identify the type of a initiative. BAS = Baseline for agency SAV = Savings EIR = Expenditure Increases / Re-estimates EIRS = Total Expenditure Increases / Re-estimates CSP = Total Citywide Savings Program " | 0% |
GET /api/datasets/d33y-i2m7 GET /api/datasets/d33y-i2m7/quality GET /api/datasets/d33y-i2m7/related GET /api/columns?dataset=d33y-i2m7
agency_nameagency_namefiscal_year| Police Department |
| BAS |
| Baseline Per November 2017 Plan |
| C |
| 2018 |
| 5 |
| C |
| 15967 |
| 15807 |
| 15807 |
| 20180201 | 56 | Police Department | EIRS | Expenditure Increases / Re-estimates | C | 2018 | 5 | U | 4 | 27 | 27 |
| 20180201 | 56 | Police Department | EIR | Expenditure Increases/Re-estimates | C | 2018 | 5 | U | 4 | 27 | 27 |
| 20180201 | 57 | Fire Department | BAS | Baseline Per November 2017 Plan | C | 2018 | 5 | U | 10906 | 10938 | 10938 |
| 20180201 | 57 | Fire Department | BAS | Baseline Per November 2017 Plan | C | 2018 | 5 | C | 6149 | 6142 | 6142 |
| 20180201 | 57 | Fire Department | EIRS | Expenditure Increases / Re-estimates | C | 2018 | 5 | C | 63 | 64 | 64 |
| 20180201 | 57 | Fire Department | EIR | Expenditure Increases/Re-estimates | C | 2018 | 5 | C | 4 | 6 | 6 |
| 20180201 | 57 | Fire Department | EIR | Expenditure Increases/Re-estimates | C | 2018 | 5 | C | 1 | 1 | 1 |
| 20180201 | 57 | Fire Department | EIR | Expenditure Increases/Re-estimates | C | 2018 | 5 | C | 15 | 15 | 15 |
Showing 12 of 17 columns. All of them are listed below.
BASEIREIRSof 8 |
init_grp | text | Descriptive name associated with the INIT_TYPE code. | 0% | Expenditure Increases/Re…Citywide Savings ProgramSavings initiatives in P… |
record_id | text | Unique record key. | 66% | EXEB827Z20001NOVC846A10001EXEB057A30001 |
init_nm | text | Name of initiative | 66% | Financial Plan Headcount…Vacancy ReductionVacancy Reductions |
init_desc | text | Description of initiative | 94% | Vacancy ReductionVacancy Reduction.Hiring and Attrition Man… |
init_sav_type | categorical | Type of Savings Initiative e.g. efficiency or reestimate. | 90% | EfficiencyReestimateRe-estimateof 11 |
init_sav_grp_nm | categorical | Explanantion of efficency savings. | 99% | People and SpacePeople and Space: Staffi…People and Space: Insour…of 4 |
funding | text | Indicator to identify funding source of the record (e.g. C for city fund, S for State fund) | 0% | Cof 1 |
fiscal_year | categorical | 4-digit to define fiscal year 1 (e.g. 2019) | 0% | 201920262023of 9 |
num_yrs_prsnt | categorical | Specify number of years presented for a specific published date | 0% | 54of 2 |
psl_typ | categorical | 1-letter to identify personnel type of headcount record (e.g. C for Civilian, U for Uniformed, P for Pedagogical) | 17% | CUPof 3 |
fy1_hc | integer | 4-digit year to define data in fiscal year 1 (e.g. 2019) | 0% | 01-1 |
fy2_hc | integer | Amount in fiscal year 2 (fiscal year 1+1, e.g. 2020) | 0% | 01-1 |
fy3_hc | integer | Amount in fiscal year 3 (fiscal year 1+2, e.g. 2021) | 0% | 01-1 |
fy4_hc | integer | Amount in fiscal year 4 (fiscal year 1+3, e.g. 2022) | 0% | 01-1 |
fy5_hc | integer | Amount in fiscal year 5 (fiscal year 1+4, e.g. 2023) | 24% | 01-1 |