From a 500-row sample across 17 columns.
fundingfiscal_yearinit_type+10fiscal_yearagency_nameagency_cdagency_namepub_dateagency_name| pub_date | agency_cd | agency_name | init_type | init_grp | funding | fiscal_year | num_yrs_prsnt | fy1_amt | fy2_amt | fy3_amt | fy4_amt |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20190619 | 056 | Police Department | BAS | Baseline Per April 2019 Plan | C | 2019 | 5 | 5311555 | 5245790 | 5243013 | 5247129 |
| 20190619 | 056 |
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% | 201804262024063020210630 |
agency_cd | text | 3-digit code which identifies an agency (e.g. 056 is the Police Department). | 0% | 098069040 |
agency_name | text | Descriptive name associated with the 3-digit code (e.g. "Mayoralty, Board of Elections, Law Department"). | 0% | MiscellaneousDepartment of Social Ser…Department of Education |
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 CSPR = Total Citywide Savings Program from Revenue" |
GET /api/datasets/e64w-ctmw GET /api/datasets/e64w-ctmw/quality GET /api/datasets/e64w-ctmw/related GET /api/columns?dataset=e64w-ctmw
fiscal_yearagency_nameagency_namefiscal_yearagency_name| Police Department |
| CIS |
| Council Initiatives |
| C |
| 2019 |
| 5 |
| -7 |
| 85 |
| 0 |
| 0 |
| 20190619 | 056 | Police Department | EIRS | Expenditure Increases/Re-estimates | C | 2019 | 5 | 9608 | 9641 | 5672 | 5718 |
| 20190619 | 056 | Police Department | CI | Council Initiatives | C | 2019 | 5 | -7 | 0 | 0 | 0 |
| 20190619 | 056 | Police Department | CI | Council Initiatives | C | 2019 | 5 | 0 | 73 | 0 | 0 |
| 20190619 | 056 | Police Department | CI | Council Initiatives | C | 2019 | 5 | 0 | 12 | 0 | 0 |
| 20190619 | 056 | Police Department | EIR | Expenditure Increases/Re-estimates | C | 2019 | 5 | 0 | 6485 | 4775 | 4821 |
| 20190619 | 056 | Police Department | EIR | Expenditure Increases/Re-estimates | C | 2019 | 5 | 10000 | 0 | 0 | 0 |
| 20190619 | 056 | Police Department | EIR | Expenditure Increases/Re-estimates | C | 2019 | 5 | 392 | 864 | 897 | 897 |
| 20190619 | 056 | Police Department | EIR | Expenditure Increases/Re-estimates | C | 2019 | 5 | -2292 | 2292 | 0 | 0 |
Showing 12 of 15 columns. All of them are listed below.
| 0% |
EIRSAVBASof 11 |
init_grp | text | Descriptive name associated with the INIT_TYPE code. | 0% | Expenditure Increases/Re…Council InitiativesCitywide Savings Program |
record_id | text | Unique record key. | 25% | ADPC846Q30002EXEB014A330000EXEC903X130000 |
init_nm | text | Name of initiative | 25% | Heat, Light and PowerLease AdjustmentLocal Initiatives |
init_desc | text | Description of initiative | 92% | Hiring and Attrition Man…Vacancy Reduction.OJs and Managers Collect… |
init_sav_type | categorical | Type of Savings Initiative e.g. efficency or reestimate. | 86% | Expense Re-estimateEfficiencyUnderspending/ Expense R…of 16 |
init_sav_grp_nm | text | Explanation of efficency savings. | 99% | People and Space: Staffi…People and SpaceReimbursement |
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 year to define data in fiscal year 1 (e.g. 2019) | 0% | 202420212019of 9 |
num_yrs_prsnt | categorical | Specify number of years presented for a specific published date | 0% | 54of 2 |
fy1_amt | integer | Amount in fiscal year 1 (fiscal year 1, e.g. 2019) | 0% | 012 |
fy2_amt | integer | Amount in fiscal year 2 (fiscal year 1+1, e.g. 2020) | 0% | 011000 |
fy3_amt | integer | Amount in fiscal year 3 (fiscal year 1+2, e.g. 2021) | 0% | 012 |
fy4_amt | integer | Amount in fiscal year 4 (fiscal year 1+3, e.g. 2022) | 0% | 012 |
fy5_amt | integer | Amount in fiscal year 5 (fiscal year 1+4, e.g. 2023) | 19% | 012 |