Expenditures of the Mayor's Proposed Budget for the 2017-18 and 2018-19 Fiscal Years. The 2016-17 Midcycle Budget and 2015-16 Audited Actuals are also included for context.
This dataset has the following 27 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| Fiscal Year | fiscal_year | text | 2015-2016 2017-2018 2018-2019 2016-2017 view top 100 |
| Request | request | text | Existing DeptReq27 BudOffReq09 BudOffReq40 BudOffReq32 view top 100 |
| DP-Department | dp_department | text | DP300 - Oakland Public Works Department DP1000 - Police Department DP750 - Human Services Department DP5000 - Oakland Parks and Recreation Department DP350 - Department of Transportation view top 100 |
| DV-Division | dv_division | text | DV302 - Design and Construction Services DV1080 - Bureau of Field Operations DV306 - Facilities Environment DV1020 - Bureau of Investigation DV502 - OPR: Area One view top 100 |
| BB DP-Dept | bb_dp_dept | text | DP21 - Oakland Public Works DP13 - Police Department DP17 - Human Services DP16 - Oakland Parks & Recreation DP22 - Transportation view top 100 |
| Department Name | department_name | text | Oakland Public Works Police Department Human Services Oakland Parks & Recreation Transportation view top 100 |
| BB SA Sort | bb_sa_sort | text | DV2110 DV2102 DV1302 DV1301 DV1304 view top 100 |
| Service Area | service_area | text | Administration Transportation Design & Construction Bureau of Field Operations 2 Bureau of Field Operations 1 view top 100 |
| OR Org Number | or_org_number | text | OR_30232 OR_78411 OR_89919 OR_89939 OR_30244 view top 100 |
| Org Number and Name | org_number_and_name | text | 30232 - Construction Mgmt and Material Testing 78411 - Community Housing Services 89919 - Admin: Housing and Community Development 89939 - Municipal Lending 30244 - Sanitary Sewer Design view top 100 |
| FD Fund Number | fd_fund_number | text | FD_1010 FD_7760 FD_2415 FD_3100 FD_1820 view top 100 |
| "Fund" Fund Numer | fund_fund_numer | text | Fund 1010 Fund 7760 Fund 2415 Fund 3100 Fund 1820 view top 100 |
| Fund Number | fund_number | text | 1010 7760 2415 3100 1820 view top 100 |
| Fund Name | fund_name | text | General Purpose Fund (GPF) Grant Clearing Development Service Fund Sewer Service Fund OPRCA Self Sustaining Revolving Fund view top 100 |
| Fund Number and Name | fund_number_and_name | text | 1010 - General Purpose Fund (GPF) 7760 - Grant Clearing 2415 - Development Service Fund 3100 - Sewer Service Fund 1820 - OPRCA Self Sustaining Revolving Fund view top 100 |
| "Fund" Fund Number and Name | fund_fund_number_and_name | text | Fund 1010 - General Purpose Fund (GPF) Fund 7760 - Grant Clearing Fund 2415 - Development Service Fund Fund 3100 - Sewer Service Fund Fund 1820 - OPRCA Self Sustaining Revolving Fund view top 100 |
| PJ Project | pj_project | text | PJ_1000008 PJ_1000010 PJ_1000012 PJ_1000013 PJ_1000007 view top 100 |
| Project - Name | project_name | text | 1000008 - DP1000 Administrative Project 1000010 - DP300 Administrative Project 1000012 - DP5000 Administrative Project 1000013 - DP610 Administrative Project 1000007 - DP080 Administrative Project view top 100 |
| PG Program Number | pg_program_number | text | PG_IN06 PG_NB03 PG_CONV PG_PS11 PG_IP59 view top 100 |
| Program Number and Name | program_number_and_name | text | IN06 - PROJECT DELIVERY NB03 - RECREATION, CULTURAL CIVIC PG_CONV PS11 - PATROL AREA 1 IP59 - FINANCIAL MANAGEMENT view top 100 |
| Order - Account Category | order_account_category | text | 14 - Internal Services & Work Orders 01 - Civilian Salaries 11 - Services & Supplies 09 - Allowances & Premiums 03 - Civilian Retirement view top 100 |
| Category Name | category_name | text | Internal Services & Work Orders Civilian Salaries Services & Supplies Allowances & Premiums Civilian Retirement view top 100 |
| Expenditure Type | expenditure_type | text | Non-Personnel Expenditures Personnel Expenditures view top 100 |
| Rev or Exp | rev_or_exp | text | Expense view top 100 |
| Acct Number and Name | acct_number_and_name | text | 51613 - Civilian: Fringe Benefits Accrual 51511 - Civilian: Paid Leave Charge 51611 - Civilian: Retirement Accrual 51111 - Civilian: Regular 56111 - Special Setups view top 100 |
| AC Account Number | ac_account_number | text | AC_51613 AC_51511 AC_51611 AC_51111 AC_56111 view top 100 |
| Value | value | number | 1000 500 5000 2000 800 view top 100 |