Expense Budget Funding - All Source

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofnewyork.us
Id 39g5-gbp3
Name Expense Budget Funding - All Source
Attribution Mayor?s Office of Management & Budget (OMB)
Category City Government
Created 2016-05-04T14:45:28Z
Publication Date 2017-02-08T17:07:04Z

Description

This dataset contains expense agency data by unit of appropriation for the Adopted, Financial Plan and Modified conditions by funding source. The numbers within can be summarized to be consistent with data from either the Supporting Schedule, Departmental Estimate or the Expense, Revenue, Contact Budget.

Columns

| Included | Schema Type    | Field Name                                             | Name                                                   | Data Type | Render Type |
| ======== | ============== | ====================================================== | ====================================================== | ========= | =========== |
| Yes      | time           | publication_date                                       | Publication Date                                       | text      | text        |
| No       |                | fiscal_year                                            | Fiscal Year                                            | number    | number      |
| Yes      | series tag     | agency_number                                          | Agency Number                                          | text      | text        |
| Yes      | series tag     | agency_name                                            | Agency Name                                            | text      | text        |
| Yes      | series tag     | unit_appropriation_number                              | Unit Appropriation Number                              | text      | text        |
| Yes      | series tag     | unit_appropriation_name                                | Unit Appropriation Name                                | text      | text        |
| Yes      | series tag     | personal_service_other_than_personal_service_indicator | Personal Service/Other Than Personal Service Indicator | text      | text        |
| Yes      | numeric metric | total_financial_plan_amount                            | Total Financial Plan Amount                            | number    | number      |
| Yes      | numeric metric | total_adopted_budget_amount                            | Total Adopted Budget Amount                            | number    | number      |
| Yes      | numeric metric | total_current_budget_amount                            | Total Current Budget Amount                            | number    | number      |
| Yes      | numeric metric | federal_funds_financial_plan_amount                    | Federal Funds Financial Plan Amount                    | number    | number      |
| Yes      | numeric metric | federal_funds_adopted_budget_amount                    | Federal Funds Adopted Budget Amount                    | number    | number      |
| Yes      | numeric metric | federal_funds_current_budget_amount                    | Federal Funds Current Budget Amount                    | number    | number      |
| Yes      | numeric metric | state_funds_financial_plan_amount                      | State Funds Financial Plan Amount                      | number    | number      |
| Yes      | numeric metric | state_funds_adopted_budget_amount                      | State Funds Adopted Budget Amount                      | number    | number      |
| Yes      | numeric metric | state_funds_current_budget_amount                      | State Funds Current Budget Amount                      | number    | number      |
| Yes      | numeric metric | inter_fund_agreement_funds_financial_plan_amount       | Inter-Fund Agreement Funds Financial Plan Amount       | number    | number      |
| Yes      | numeric metric | inter_fund_agreement_funds_adopted_budget_amount       | Inter-Fund Agreement Funds Adopted Budget Amount       | number    | number      |
| Yes      | numeric metric | inter_fund_agreement_funds_current_budget_amount       | Inter-Fund Agreement Funds Current Budget Amount       | number    | number      |
| Yes      | numeric metric | intra_city_sales_funds_financial_plan_amount           | Intra-City Sales Funds Financial Plan Amount           | number    | number      |
| Yes      | numeric metric | intra_city_sales_funds_adopted_budget_amount           | Intra-City Sales Funds Adopted Budget Amount           | number    | number      |
| Yes      | numeric metric | intra_city_sales_funds_current_budget_amount           | Intra-City Sales Funds Current Budget Amount           | number    | number      |
| Yes      | numeric metric | other_categorical_funds_financial_plan_amount          | Other Categorical Funds Financial Plan Amount          | number    | number      |
| Yes      | numeric metric | other_categorical_funds_adopted_budget_amount          | Other Categorical Funds Adopted Budget Amount          | number    | number      |
| Yes      | numeric metric | other_categorical_funds_current_budget_amount          | Other Categorical Funds Current Budget Amount          | number    | number      |
| Yes      | numeric metric | community_development_funds_financial_plan_amount      | Community Development Funds Financial Plan Amount      | number    | number      |
| Yes      | numeric metric | community_development_funds_adopted_budget_amount      | Community Development Funds Adopted Budget Amount      | number    | number      |
| Yes      | numeric metric | community_development_funds_current_budget_amount      | Community Development Funds Current Budget Amount      | number    | number      |
| Yes      | numeric metric | city_funds_financial_plan_amount                       | City Funds Financial Plan Amount                       | number    | number      |
| Yes      | numeric metric | city_funds_adopted_budget_amount                       | City Funds Adopted Budget Amount                       | number    | number      |
| Yes      | numeric metric | city_funds_current_budget_amount                       | City Funds Current Budget Amount                       | number    | number      |

Time Field

Value = publication_date
Format & Zone = yyyyMMdd

Series Fields

Excluded Fields = fiscal_year

Data Commands

series e:39g5-gbp3 d:2016-04-26T00:00:00.000Z t:unit_appropriation_name="OTHER THAN PERSONAL SERVICES" t:personal_service_other_than_personal_service_indicator=O t:unit_appropriation_number=002 t:agency_number=013 t:agency_name="BOROUGH PRESIDENT - QUEENS" m:city_funds_current_budget_amount=1246590 m:state_funds_current_budget_amount=115750 m:intra_city_sales_funds_financial_plan_amount=0 m:city_funds_adopted_budget_amount=2232590 m:community_development_funds_financial_plan_amount=0 m:other_categorical_funds_current_budget_amount=0 m:community_development_funds_adopted_budget_amount=0 m:federal_funds_financial_plan_amount=0 m:inter_fund_agreement_funds_current_budget_amount=0 m:state_funds_adopted_budget_amount=0 m:other_categorical_funds_financial_plan_amount=0 m:inter_fund_agreement_funds_adopted_budget_amount=0 m:federal_funds_adopted_budget_amount=0 m:federal_funds_current_budget_amount=0 m:total_adopted_budget_amount=2232590 m:total_financial_plan_amount=1300504 m:inter_fund_agreement_funds_financial_plan_amount=0 m:intra_city_sales_funds_current_budget_amount=0 m:intra_city_sales_funds_adopted_budget_amount=0 m:city_funds_financial_plan_amount=1300504 m:total_current_budget_amount=1362340 m:community_development_funds_current_budget_amount=0 m:other_categorical_funds_adopted_budget_amount=0 m:state_funds_financial_plan_amount=0

series e:39g5-gbp3 d:2016-04-26T00:00:00.000Z t:unit_appropriation_name="PERSONAL SERVICES" t:personal_service_other_than_personal_service_indicator=P t:unit_appropriation_number=001 t:agency_number=014 t:agency_name="BOROUGH PRESIDENT STATEN ISLAND" m:city_funds_current_budget_amount=3445213 m:state_funds_current_budget_amount=0 m:intra_city_sales_funds_financial_plan_amount=0 m:city_funds_adopted_budget_amount=3490907 m:community_development_funds_financial_plan_amount=0 m:other_categorical_funds_current_budget_amount=0 m:community_development_funds_adopted_budget_amount=0 m:federal_funds_financial_plan_amount=0 m:inter_fund_agreement_funds_current_budget_amount=0 m:state_funds_adopted_budget_amount=0 m:other_categorical_funds_financial_plan_amount=0 m:inter_fund_agreement_funds_adopted_budget_amount=0 m:federal_funds_adopted_budget_amount=0 m:federal_funds_current_budget_amount=0 m:total_adopted_budget_amount=3490907 m:total_financial_plan_amount=3593293 m:inter_fund_agreement_funds_financial_plan_amount=0 m:intra_city_sales_funds_current_budget_amount=0 m:intra_city_sales_funds_adopted_budget_amount=0 m:city_funds_financial_plan_amount=3593293 m:total_current_budget_amount=3445213 m:community_development_funds_current_budget_amount=0 m:other_categorical_funds_adopted_budget_amount=0 m:state_funds_financial_plan_amount=0

series e:39g5-gbp3 d:2016-04-26T00:00:00.000Z t:unit_appropriation_name="OTHER THAN PERSONAL SERVICES" t:personal_service_other_than_personal_service_indicator=O t:unit_appropriation_number=002 t:agency_number=014 t:agency_name="BOROUGH PRESIDENT STATEN ISLAND" m:city_funds_current_budget_amount=891799 m:state_funds_current_budget_amount=0 m:intra_city_sales_funds_financial_plan_amount=0 m:city_funds_adopted_budget_amount=841799 m:community_development_funds_financial_plan_amount=0 m:other_categorical_funds_current_budget_amount=0 m:community_development_funds_adopted_budget_amount=0 m:federal_funds_financial_plan_amount=0 m:inter_fund_agreement_funds_current_budget_amount=0 m:state_funds_adopted_budget_amount=0 m:other_categorical_funds_financial_plan_amount=0 m:inter_fund_agreement_funds_adopted_budget_amount=0 m:federal_funds_adopted_budget_amount=0 m:federal_funds_current_budget_amount=0 m:total_adopted_budget_amount=841799 m:total_financial_plan_amount=816424 m:inter_fund_agreement_funds_financial_plan_amount=0 m:intra_city_sales_funds_current_budget_amount=0 m:intra_city_sales_funds_adopted_budget_amount=0 m:city_funds_financial_plan_amount=816424 m:total_current_budget_amount=891799 m:community_development_funds_current_budget_amount=0 m:other_categorical_funds_adopted_budget_amount=0 m:state_funds_financial_plan_amount=0

Meta Commands

metric m:total_financial_plan_amount p:long l:"Total Financial Plan Amount" t:dataTypeName=number

metric m:total_adopted_budget_amount p:long l:"Total Adopted Budget Amount" t:dataTypeName=number

metric m:total_current_budget_amount p:long l:"Total Current Budget Amount" t:dataTypeName=number

metric m:federal_funds_financial_plan_amount p:integer l:"Federal Funds Financial Plan Amount" t:dataTypeName=number

metric m:federal_funds_adopted_budget_amount p:integer l:"Federal Funds Adopted Budget Amount" t:dataTypeName=number

metric m:federal_funds_current_budget_amount p:integer l:"Federal Funds Current Budget Amount" t:dataTypeName=number

metric m:state_funds_financial_plan_amount p:long l:"State Funds Financial Plan Amount" t:dataTypeName=number

metric m:state_funds_adopted_budget_amount p:long l:"State Funds Adopted Budget Amount" t:dataTypeName=number

metric m:state_funds_current_budget_amount p:long l:"State Funds Current Budget Amount" t:dataTypeName=number

metric m:inter_fund_agreement_funds_financial_plan_amount p:integer l:"Inter-Fund Agreement Funds Financial Plan Amount" t:dataTypeName=number

metric m:inter_fund_agreement_funds_adopted_budget_amount p:integer l:"Inter-Fund Agreement Funds Adopted Budget Amount" t:dataTypeName=number

metric m:inter_fund_agreement_funds_current_budget_amount p:integer l:"Inter-Fund Agreement Funds Current Budget Amount" t:dataTypeName=number

metric m:intra_city_sales_funds_financial_plan_amount p:integer l:"Intra-City Sales Funds Financial Plan Amount" t:dataTypeName=number

metric m:intra_city_sales_funds_adopted_budget_amount p:integer l:"Intra-City Sales Funds Adopted Budget Amount" t:dataTypeName=number

metric m:intra_city_sales_funds_current_budget_amount p:integer l:"Intra-City Sales Funds Current Budget Amount" t:dataTypeName=number

metric m:other_categorical_funds_financial_plan_amount p:integer l:"Other Categorical Funds Financial Plan Amount" t:dataTypeName=number

metric m:other_categorical_funds_adopted_budget_amount p:integer l:"Other Categorical Funds Adopted Budget Amount" t:dataTypeName=number

metric m:other_categorical_funds_current_budget_amount p:integer l:"Other Categorical Funds Current Budget Amount" t:dataTypeName=number

metric m:community_development_funds_financial_plan_amount p:integer l:"Community Development Funds Financial Plan Amount" t:dataTypeName=number

metric m:community_development_funds_adopted_budget_amount p:integer l:"Community Development Funds Adopted Budget Amount" t:dataTypeName=number

metric m:community_development_funds_current_budget_amount p:integer l:"Community Development Funds Current Budget Amount" t:dataTypeName=number

metric m:city_funds_financial_plan_amount p:long l:"City Funds Financial Plan Amount" t:dataTypeName=number

metric m:city_funds_adopted_budget_amount p:long l:"City Funds Adopted Budget Amount" t:dataTypeName=number

metric m:city_funds_current_budget_amount p:long l:"City Funds Current Budget Amount" t:dataTypeName=number

entity e:39g5-gbp3 l:"Expense Budget Funding - All Source" t:attribution="Mayor?s Office of Management & Budget (OMB)" t:url=https://data.cityofnewyork.us/api/views/39g5-gbp3

property e:39g5-gbp3 t:meta.view v:id=39g5-gbp3 v:category="City Government" v:averageRating=0 v:name="Expense Budget Funding - All Source" v:attribution="Mayor?s Office of Management & Budget (OMB)"

property e:39g5-gbp3 t:meta.view.owner v:id=5fuc-pqz2 v:screenName="NYC OpenData" v:lastNotificationSeenAt=1491336998 v:displayName="NYC OpenData"

property e:39g5-gbp3 t:meta.view.tableauthor v:id=5fuc-pqz2 v:screenName="NYC OpenData" v:roleName=administrator v:lastNotificationSeenAt=1491336998 v:displayName="NYC OpenData"

Top Records

| publication_date | fiscal_year | agency_number | agency_name                     | unit_appropriation_number | unit_appropriation_name      | personal_service_other_than_personal_service_indicator | total_financial_plan_amount | total_adopted_budget_amount | total_current_budget_amount | federal_funds_financial_plan_amount | federal_funds_adopted_budget_amount | federal_funds_current_budget_amount | state_funds_financial_plan_amount | state_funds_adopted_budget_amount | state_funds_current_budget_amount | inter_fund_agreement_funds_financial_plan_amount | inter_fund_agreement_funds_adopted_budget_amount | inter_fund_agreement_funds_current_budget_amount | intra_city_sales_funds_financial_plan_amount | intra_city_sales_funds_adopted_budget_amount | intra_city_sales_funds_current_budget_amount | other_categorical_funds_financial_plan_amount | other_categorical_funds_adopted_budget_amount | other_categorical_funds_current_budget_amount | community_development_funds_financial_plan_amount | community_development_funds_adopted_budget_amount | community_development_funds_current_budget_amount | city_funds_financial_plan_amount | city_funds_adopted_budget_amount | city_funds_current_budget_amount | 
| ================ | =========== | ============= | =============================== | ========================= | ============================ | ====================================================== | =========================== | =========================== | =========================== | =================================== | =================================== | =================================== | ================================= | ================================= | ================================= | ================================================ | ================================================ | ================================================ | ============================================ | ============================================ | ============================================ | ============================================= | ============================================= | ============================================= | ================================================= | ================================================= | ================================================= | ================================ | ================================ | ================================ | 
| 20160426         | 2017        | 013           | BOROUGH PRESIDENT - QUEENS      | 002                       | OTHER THAN PERSONAL SERVICES | O                                                      | 1300504                     | 2232590                     | 1362340                     | 0                                   | 0                                   | 0                                   | 0                                 | 0                                 | 115750                            | 0                                                | 0                                                | 0                                                | 0                                            | 0                                            | 0                                            | 0                                             | 0                                             | 0                                             | 0                                                 | 0                                                 | 0                                                 | 1300504                          | 2232590                          | 1246590                          | 
| 20160426         | 2017        | 014           | BOROUGH PRESIDENT STATEN ISLAND | 001                       | PERSONAL SERVICES            | P                                                      | 3593293                     | 3490907                     | 3445213                     | 0                                   | 0                                   | 0                                   | 0                                 | 0                                 | 0                                 | 0                                                | 0                                                | 0                                                | 0                                            | 0                                            | 0                                            | 0                                             | 0                                             | 0                                             | 0                                                 | 0                                                 | 0                                                 | 3593293                          | 3490907                          | 3445213                          | 
| 20160426         | 2017        | 014           | BOROUGH PRESIDENT STATEN ISLAND | 002                       | OTHER THAN PERSONAL SERVICES | O                                                      | 816424                      | 841799                      | 891799                      | 0                                   | 0                                   | 0                                   | 0                                 | 0                                 | 0                                 | 0                                                | 0                                                | 0                                                | 0                                            | 0                                            | 0                                            | 0                                             | 0                                             | 0                                             | 0                                                 | 0                                                 | 0                                                 | 816424                           | 841799                           | 891799                           | 
| 20160426         | 2017        | 015           | OFFICE OF THE COMPTROLLER       | 001                       | EXECUTIVE MANAGEMENT-PS      | P                                                      | 3902686                     | 3786765                     | 3791052                     | 0                                   | 0                                   | 0                                   | 0                                 | 0                                 | 0                                 | 0                                                | 0                                                | 0                                                | 0                                            | 0                                            | 0                                            | 0                                             | 0                                             | 0                                             | 0                                                 | 0                                                 | 0                                                 | 3902686                          | 3786765                          | 3791052                          | 
| 20160426         | 2017        | 015           | OFFICE OF THE COMPTROLLER       | 002                       | FIRST DEPUTY COMPT-PS        | P                                                      | 36155146                    | 34448458                    | 34611249                    | 0                                   | 0                                   | 0                                   | 0                                 | 0                                 | 0                                 | 8150140                                          | 7282541                                          | 7296778                                          | 212854                                       | 212854                                       | 212854                                       | 0                                             | 0                                             | 0                                             | 0                                                 | 0                                                 | 0                                                 | 27792152                         | 26953063                         | 27101617                         | 
| 20160426         | 2017        | 015           | OFFICE OF THE COMPTROLLER       | 003                       | SECOND DEPUTY COMPT-PS       | P                                                      | 13454693                    | 13062934                    | 13105936                    | 0                                   | 0                                   | 0                                   | 0                                 | 0                                 | 0                                 | 4011289                                          | 3898971                                          | 3904418                                          | 0                                            | 0                                            | 0                                            | 0                                             | 0                                             | 0                                             | 0                                                 | 0                                                 | 0                                                 | 9443404                          | 9163963                          | 9201518                          | 
| 20160426         | 2017        | 015           | OFFICE OF THE COMPTROLLER       | 004                       | THIRD DEPUTY COMPT-PS        | P                                                      | 14031384                    | 13746960                    | 13785457                    | 0                                   | 0                                   | 0                                   | 0                                 | 0                                 | 0                                 | 0                                                | 0                                                | 0                                                | 0                                            | 0                                            | 0                                            | 8058169                                       | 7930327                                       | 7944844                                       | 0                                                 | 0                                                 | 0                                                 | 5973215                          | 5816633                          | 5840613                          | 
| 20160426         | 2017        | 015           | OFFICE OF THE COMPTROLLER       | 005                       | FIRST DEPUTY COMPT-OTPS      | O                                                      | 9123316                     | 9176185                     | 9176185                     | 0                                   | 0                                   | 0                                   | 0                                 | 0                                 | 0                                 | 0                                                | 0                                                | 0                                                | 0                                            | 0                                            | 0                                            | 0                                             | 0                                             | 0                                             | 0                                                 | 0                                                 | 0                                                 | 9123316                          | 9176185                          | 9176185                          | 
| 20160426         | 2017        | 015           | OFFICE OF THE COMPTROLLER       | 006                       | EXECUTIVE MANAGEMENT-OTPS    | O                                                      | 130916                      | 130916                      | 130916                      | 0                                   | 0                                   | 0                                   | 0                                 | 0                                 | 0                                 | 0                                                | 0                                                | 0                                                | 0                                            | 0                                            | 0                                            | 0                                             | 0                                             | 0                                             | 0                                                 | 0                                                 | 0                                                 | 130916                           | 130916                           | 130916                           | 
| 20160426         | 2017        | 015           | OFFICE OF THE COMPTROLLER       | 007                       | SECOND DEPUTY COMPT-OTPS     | O                                                      | 3807492                     | 3807492                     | 3807492                     | 0                                   | 0                                   | 0                                   | 0                                 | 0                                 | 0                                 | 0                                                | 0                                                | 0                                                | 0                                            | 0                                            | 0                                            | 0                                             | 0                                             | 0                                             | 0                                                 | 0                                                 | 0                                                 | 3807492                          | 3807492                          | 3807492                          |