Baselight

Capital Projects Dashboard - Citywide Budget Spend History And Variance

City of New York

@usgov.city_of_new_york_capital_projects_dashboard_budget_spe_beb2baf7

Loading...
Loading...

About this Dataset

Capital Projects Dashboard - Citywide Budget Spend History And Variance

This is the history all FMS reported budget-and-spend by budget line item and reported Year-Month. Each row is the snapshot of data recorded in each reported Year-Month. The earliest snapshot represents the 'original budget' of a project. The 'budget variance' is the difference between 'total budget' of each row and its prior reported Year-Month. This dataset is part of the Capital Projects Dashboard.
Organization: City of New York
Last updated: 2024-03-30T00:12:17.733116
Tags: budget, capital-projects, fms, spend

Tables

Table 1

@usgov.city_of_new_york_capital_projects_dashboard_budget_spe_beb2baf7.table_1
  • 520.42 KB
  • 35203 rows
  • 8 columns
Loading...

CREATE TABLE table_1 (
  "managing_agency" BIGINT,
  "fms_id" VARCHAR,
  "year_month_reported" BIGINT,
  "total_budget" BIGINT,
  "spend_to_date" DOUBLE,
  "spend_to_date_dddd19" DOUBLE,
  "budget_variance" DOUBLE,
  "budget_variance_c3404b" DOUBLE
);

Share link

Anyone who has the link will be able to view this.