Expense Budget Funding - All Source
City of New York
@usgov.city_of_new_york_expense_budget_funding_all_source
City of New York
@usgov.city_of_new_york_expense_budget_funding_all_source
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. This dataset is updated three times per year after publication of the Preliminary, Executive and Adopted Budget, usually in January, April and June respectively.
Organization: City of New York
Last updated: 2020-11-10T17:00:27.780680
CREATE TABLE table_1 (
"publication_date" BIGINT,
"fiscal_year" BIGINT,
"agency_number" VARCHAR,
"agency_name" VARCHAR,
"unit_appropriation_number" BIGINT,
"unit_appropriation_name" VARCHAR,
"personal_service_other_than_personal_service_indicator" VARCHAR,
"total_financial_plan_amount" BIGINT,
"total_adopted_budget_amount" BIGINT,
"total_current_budget_amount" BIGINT,
"federal_funds_financial_plan_amount" BIGINT,
"federal_funds_adopted_budget_amount" BIGINT,
"federal_funds_current_budget_amount" BIGINT,
"state_funds_financial_plan_amount" BIGINT,
"state_funds_adopted_budget_amount" BIGINT,
"state_funds_current_budget_amount" BIGINT,
"inter_fund_agreement_funds_financial_plan_amount" BIGINT,
"inter_fund_agreement_funds_adopted_budget_amount" BIGINT,
"inter_fund_agreement_funds_current_budget_amount" BIGINT,
"intra_city_sales_funds_financial_plan_amount" BIGINT,
"intra_city_sales_funds_adopted_budget_amount" BIGINT,
"intra_city_sales_funds_current_budget_amount" BIGINT,
"other_categorical_funds_financial_plan_amount" BIGINT,
"other_categorical_funds_adopted_budget_amount" BIGINT,
"other_categorical_funds_current_budget_amount" BIGINT,
"community_development_funds_financial_plan_amount" BIGINT,
"community_development_funds_adopted_budget_amount" BIGINT,
"community_development_funds_current_budget_amount" BIGINT,
"city_funds_financial_plan_amount" BIGINT,
"city_funds_adopted_budget_amount" BIGINT,
"city_funds_current_budget_amount" BIGINT
);Anyone who has the link will be able to view this.