From a 500-row sample across 23 columns.
current_modified_budget_amountagency_numberagency_name+3revenue_source_namefps_groupfps_group_name+12revenue_categoryfiscal_yearpublication_datefiscal_year| publication_date | fiscal_year | fundind_source_name | fps_group | fps_group_name | agency_number | agency_name | revenue_category | revenue_category_name | revenue_class_code | revenue_class_name | budget_code |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2016 04 26 | 2017 | City Funds | 1 | Real Property | 002 | Mayoralty | 20 | TAXES | 001 | GENERAL PROPERTY TAXES | 0421 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
publication_date | text | The date when data is made available for the public view as legally required. | 0% | 2016 06 142017 6 062016 04 26 |
fiscal_year | categorical | The period of twelve months which begins July 1 and ends the following June 30. | 0% | 201720192018of 10 |
fundind_source_name | categorical | 1 or 2-characters code which identifies the funding (e.g. C is City Funds, F is Federal funds, IF is Inter Fund Agreements, OC is Other Categorical Grants etc). | 0% | Federal GrantsCity FundsState Grantsof 7 |
fps_group | integer | 2-digit code which identifies the Financial Plan Publication Grouping. |
GET /api/datasets/ugzk-a6x4 GET /api/datasets/ugzk-a6x4/quality GET /api/datasets/ugzk-a6x4/related GET /api/columns?dataset=ugzk-a6x4
| 2016 04 26 |
| 2017 |
| City Funds |
| 1 |
| Real Property |
| 002 |
| Mayoralty |
| 20 |
| TAXES |
| 001 |
| GENERAL PROPERTY TAXES |
| 0421 |
| 2016 04 26 | 2017 | City Funds | 1 | Real Property | 002 | Mayoralty | 20 | TAXES | 001 | GENERAL PROPERTY TAXES | 0421 |
| 2016 04 26 | 2017 | City Funds | 1 | Real Property | 002 | Mayoralty | 20 | TAXES | 001 | GENERAL PROPERTY TAXES | 0421 |
| 2016 04 26 | 2017 | City Funds | 1 | Real Property | 002 | Mayoralty | 20 | TAXES | 001 | GENERAL PROPERTY TAXES | 0421 |
| 2016 04 26 | 2017 | City Funds | 1 | Real Property | 002 | Mayoralty | 20 | TAXES | 001 | GENERAL PROPERTY TAXES | 0421 |
| 2016 04 26 | 2017 | City Funds | 1 | Real Property | 002 | Mayoralty | 20 | TAXES | 001 | GENERAL PROPERTY TAXES | 0421 |
| 2016 04 26 | 2017 | City Funds | 2 | Personal Income | 002 | Mayoralty | 20 | TAXES | 004 | INCOME TAXES | 0421 |
| 2016 04 26 | 2017 | City Funds | 2 | Personal Income | 002 | Mayoralty | 20 | TAXES | 004 | INCOME TAXES | 0421 |
| 2016 04 26 | 2017 | City Funds | 3 | General Corporation | 002 | Mayoralty | 20 | TAXES | 004 | INCOME TAXES | 0421 |
Showing 12 of 23 columns. All of them are listed below.
| 0% |
352430 |
fps_group_name | text | Descriptive name associated with the 2-digit code (e.g. 01 is Real Property, 02 is for Personal Income, 17 is Licenses, Permits & Franchises ). | 0% | Other - FederalIntra-City RevenueOther Categorical Grants |
agency_number | text | 3-digit code which identifies an agency (e.g. 056 is the Police Department). | 0% | 816806056 |
agency_name | text | Descriptive name associated with the 3-digit code (e.g. "Mayoralty, Board of Elections, Law Department"). | 0% | Department of Health and…Housing Preservation and…Police Department |
revenue_category | categorical | 2-digit code which identifies a rollup level for the revenue source | 0% | 252226of 13 |
revenue_category_name | categorical | — | 0% | Federal Grants and Contr…CHARGES FOR SERVICESState Grants and Contrac…of 15 |
revenue_class_code | text | — | 0% | 013039293 |
revenue_class_name | text | — | 0% | INTRA-CITY CHARGESNONGOVT GRANTS-OTHERHealth and Human Service… |
budget_code | text | — | 0% | 042103020031 |
revenue_source | text | — | 0% | 005954390000470 |
revenue_source_name | text | Descripted Name associated with 5-character code which classifies Revenues pursuant to the Chart of Accounts issued by the City Comptroller (e.g. 04244 is Urban Area Security Initiative). | 0% | OTHER SERVICES/FEESPRIVATE GRANTSOTHER SERVICES AND FEES |
revenue_structure_description | text | Descripted Name associated with the combination of 3 digit agency number, 4 digit budget code and 5-digit revenue source code which represents a particular funding program (e.g. 04244 is FFY15 Urban Area Security Initiative). | 6% | OTHER SERVICES/FEESOther Services/FeesSARA GRANT - LGRMIF |
adopted_budget_amount | integer | Financial plan for the City and its agencies for a fiscal year, setting forth estimated revenues as authorized by the City Council. | 0% | 0500001000000 |
current_modified_budget_amount | integer | The Adopted Budget as revised through modification and approval in accordance with the City Charter. | 0% | 010000050000 |
yr1_fy | categorical | — | 0% | 201920172018of 11 |
year_1_revenue_amount | integer | Fiscal Year 1 $ amount | 0% | 010000050000 |
year_2_revenue_amount | integer | Fiscal Year 2 $ amount | 0% | 0500001000000 |
year_3_revenue_amount | integer | Fiscal Year 3 $ amount | 0% | 0500001000000 |
year_4_revenue_amount | integer | Fiscal Year 4 $ amount | 0% | 0500001000000 |
year_5_revenue_amount | integer | Fiscal Year 5 $ amount | 0% | 0500001000000 |