3K Projects By School

CREATE TABLE table_1 (
  "sited" VARCHAR,
  "leased" VARCHAR,
  "district" BIGINT,
  "project" VARCHAR,
  "school" VARCHAR,
  "boro" VARCHAR,
  "forecast_capacity" BIGINT,
  "design_start" VARCHAR,
  "construction_start" VARCHAR,
  "actual_est_comp" VARCHAR,
  "total_est_comp" DOUBLE,
  "previous_appropriations" DOUBLE,
  "funding_req_d_fy_20_24" DOUBLE,
  "needed_to_complete" DOUBLE
);