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

532.91 kB
35,203 rows
8 columns

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  -- Spend To Date %,
  "budget_variance" DOUBLE,
  "budget_variance_c3404b" DOUBLE  -- Budget Variance %
);