From a 500-row sample across 15 columns.
agency_namepublication_dateagency_name| publication_date | agency_code | agency_name | budget_function | budget_function_description | row_id | spending_type | spending_type_description | first_actual_fiscal_year | year_1_actual | year_2_actual | year_3_actual |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20260630 | 056 | POLICE DEPARTMENT | Administration | Includes executive and administrative personnel who provide the capacity for the agency to function. The offices/units include: Office of the Police Commissioner, Office of the First Deputy Commissioner (includes Risk Management Bureau), Deputy Commissioner of Operations, Deputy Commissioner of Public Information, Deputy Commissioner of Management and Budget, Office of Information and Technology, Deputy Commissioner of Legal Matters, Deputy Commissioner of Trials, Deputy Commissioner of Equal Employment Opportunity, Deputy Commissioner of Labor Relations, Deputy Commissioner of Administration, Deputy Commissioner of Collaborative Policing and Personnel Bureau. |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
publication_date | text | Date of data published. (e.g. 20170426) | 0% | 202306302023042620210630 |
agency_code | categorical | 3-digit code which identifies an agency (e.g. 056 is the Police Department). | 0% | 816069056of 15 |
agency_name | categorical | Descriptive name associated with the 3-digit code (e.g. "Mayoralty, Board of Elections, Law Department"). | 0% | DEPARTMENT OF HEALTH AND…DEPARTMENT OF SOCIAL SER…POLICE DEPARTMENTof 15 |
budget_function | text | Identifies the functional area of an agency mission. | 0% |
GET /api/datasets/gzfs-3h4m GET /api/datasets/gzfs-3h4m/quality GET /api/datasets/gzfs-3h4m/related GET /api/columns?dataset=gzfs-3h4m
agency_name| SPENDING |
| PERSONAL SERVICES |
| FRINGE BENEFITS |
| 2023 |
| 47338 |
| 48732 |
| 49217 |
| 20260630 | 056 | POLICE DEPARTMENT | Administration | Includes executive and administrative personnel who provide the capacity for the agency to function. The offices/units include: Office of the Police Commissioner, Office of the First Deputy Commissioner (includes Risk Management Bureau), Deputy Commissioner of Operations, Deputy Commissioner of Public Information, Deputy Commissioner of Management and Budget, Office of Information and Technology, Deputy Commissioner of Legal Matters, Deputy Commissioner of Trials, Deputy Commissioner of Equal Employment Opportunity, Deputy Commissioner of Labor Relations, Deputy Commissioner of Administration, Deputy Commissioner of Collaborative Policing and Personnel Bureau. | SPENDING | OTHER THAN PERSONAL SERVICES | OTHER SERVICES AND CHARGES | 2023 | 137757 | 148514 | 151081 |
| 20260630 | 056 | POLICE DEPARTMENT | Administration | Includes executive and administrative personnel who provide the capacity for the agency to function. The offices/units include: Office of the Police Commissioner, Office of the First Deputy Commissioner (includes Risk Management Bureau), Deputy Commissioner of Operations, Deputy Commissioner of Public Information, Deputy Commissioner of Management and Budget, Office of Information and Technology, Deputy Commissioner of Legal Matters, Deputy Commissioner of Trials, Deputy Commissioner of Equal Employment Opportunity, Deputy Commissioner of Labor Relations, Deputy Commissioner of Administration, Deputy Commissioner of Collaborative Policing and Personnel Bureau. | SPENDING | PERSONAL SERVICES | OTHER SALARIED | 2023 | 273 | 278 | 281 |
| 20260630 | 056 | POLICE DEPARTMENT | Administration | Includes executive and administrative personnel who provide the capacity for the agency to function. The offices/units include: Office of the Police Commissioner, Office of the First Deputy Commissioner (includes Risk Management Bureau), Deputy Commissioner of Operations, Deputy Commissioner of Public Information, Deputy Commissioner of Management and Budget, Office of Information and Technology, Deputy Commissioner of Legal Matters, Deputy Commissioner of Trials, Deputy Commissioner of Equal Employment Opportunity, Deputy Commissioner of Labor Relations, Deputy Commissioner of Administration, Deputy Commissioner of Collaborative Policing and Personnel Bureau. | SPENDING | PERSONAL SERVICES | ADDITIONAL GROSS PAY | 2023 | 93704 | 96878 | 74885 |
| 20260630 | 056 | POLICE DEPARTMENT | Administration | Includes executive and administrative personnel who provide the capacity for the agency to function. The offices/units include: Office of the Police Commissioner, Office of the First Deputy Commissioner (includes Risk Management Bureau), Deputy Commissioner of Operations, Deputy Commissioner of Public Information, Deputy Commissioner of Management and Budget, Office of Information and Technology, Deputy Commissioner of Legal Matters, Deputy Commissioner of Trials, Deputy Commissioner of Equal Employment Opportunity, Deputy Commissioner of Labor Relations, Deputy Commissioner of Administration, Deputy Commissioner of Collaborative Policing and Personnel Bureau. | SPENDING | OTHER THAN PERSONAL SERVICES | SUPPLIES AND MATERIALS | 2023 | 20888 | 21418 | 26209 |
| 20260630 | 056 | POLICE DEPARTMENT | Administration | Includes executive and administrative personnel who provide the capacity for the agency to function. The offices/units include: Office of the Police Commissioner, Office of the First Deputy Commissioner (includes Risk Management Bureau), Deputy Commissioner of Operations, Deputy Commissioner of Public Information, Deputy Commissioner of Management and Budget, Office of Information and Technology, Deputy Commissioner of Legal Matters, Deputy Commissioner of Trials, Deputy Commissioner of Equal Employment Opportunity, Deputy Commissioner of Labor Relations, Deputy Commissioner of Administration, Deputy Commissioner of Collaborative Policing and Personnel Bureau. | SPENDING | OTHER THAN PERSONAL SERVICES | PROPERTY AND EQUIPMENT | 2023 | 9366 | 5889 | 6918 |
| 20260630 | 056 | POLICE DEPARTMENT | Financial Plan Savings | Funds associated with financial plan savings. | HEADCOUNT | — | CIVILIAN | — | — | — | — |
| 20260630 | 056 | POLICE DEPARTMENT | Administration | Includes executive and administrative personnel who provide the capacity for the agency to function. The offices/units include: Office of the Police Commissioner, Office of the First Deputy Commissioner (includes Risk Management Bureau), Deputy Commissioner of Operations, Deputy Commissioner of Public Information, Deputy Commissioner of Management and Budget, Office of Information and Technology, Deputy Commissioner of Legal Matters, Deputy Commissioner of Trials, Deputy Commissioner of Equal Employment Opportunity, Deputy Commissioner of Labor Relations, Deputy Commissioner of Administration, Deputy Commissioner of Collaborative Policing and Personnel Bureau. | SPENDING | PERSONAL SERVICES | FULL TIME SALARIED | 2023 | 312448 | 336553 | 347293 |
| 20260630 | 056 | POLICE DEPARTMENT | Administration | Includes executive and administrative personnel who provide the capacity for the agency to function. The offices/units include: Office of the Police Commissioner, Office of the First Deputy Commissioner (includes Risk Management Bureau), Deputy Commissioner of Operations, Deputy Commissioner of Public Information, Deputy Commissioner of Management and Budget, Office of Information and Technology, Deputy Commissioner of Legal Matters, Deputy Commissioner of Trials, Deputy Commissioner of Equal Employment Opportunity, Deputy Commissioner of Labor Relations, Deputy Commissioner of Administration, Deputy Commissioner of Collaborative Policing and Personnel Bureau. | SPENDING | PERSONAL SERVICES | UNSALARIED | 2023 | 3216 | 3445 | 4105 |
| 20260630 | 056 | POLICE DEPARTMENT | Administration | Includes executive and administrative personnel who provide the capacity for the agency to function. The offices/units include: Office of the Police Commissioner, Office of the First Deputy Commissioner (includes Risk Management Bureau), Deputy Commissioner of Operations, Deputy Commissioner of Public Information, Deputy Commissioner of Management and Budget, Office of Information and Technology, Deputy Commissioner of Legal Matters, Deputy Commissioner of Trials, Deputy Commissioner of Equal Employment Opportunity, Deputy Commissioner of Labor Relations, Deputy Commissioner of Administration, Deputy Commissioner of Collaborative Policing and Personnel Bureau. | SPENDING | OTHER THAN PERSONAL SERVICES | CONTRACTUAL SERVICES | 2023 | 168135 | 170606 | 170839 |
Showing 12 of 15 columns. All of them are listed below.
General AdministrationAdministrationMental Hygiene- Mental H… |
budget_function_description | text | Detail description of the services provided within an agency budget function area . | 0% | Funding for central admi…Funding for administrati…Funding for the Bureau o… |
row_id | categorical | Identifies the type of data contained in the record either spending, funding or headcount information | 0% | SPENDINGFUNDINGHEADCOUNTof 3 |
spending_type | categorical | Identifies the type of spending either PS, OTPS or type of funding. | 9% | OTHER THAN PERSONAL SERV…PERSONAL SERVICESFEDERAL - OTHERof 10 |
spending_type_description | text | Classification of spending type or headcount. | 0% | CIVILIANCITY FUNDSFULL TIME SALARIED |
first_actual_fiscal_year | categorical | 4-digit year to define data in fiscal year 1 (e.g. 2015) | 49% | 202020192022of 9 |
year_1_actual | integer | Amount in fiscal year 1 (fiscal year 1, e.g. 2015) | 49% | 012 |
year_2_actual | integer | Amount in fiscal year 2 (fiscal year 1+1, e.g. 2016) | 49% | 012 |
year_3_actual | integer | Amount in fiscal year 2 (fiscal year 1+1, e.g. 2017) | 49% | 012 |
first_plan_fiscal_year | categorical | 4-digit year to define data in fiscal year 1 (e.g. 2019) | 0% | 202320222026of 9 |
plan_amount_year_1 | integer | Amount in fiscal year 1 (fiscal year 1, e.g. 2019) | 0% | 012 |
plan_amount_year_2 | integer | Amount in fiscal year 2 (fiscal year 1+1, e.g. 2020) | 0% | 012 |