NYC Clean Heat Dataset (Historical)

CREATE TABLE table_1 (
  "borough_block_lot" BIGINT,
  "street_address" VARCHAR,
  "postcode" DOUBLE,
  "borough" VARCHAR,
  "utility" VARCHAR,
  "building_manager" VARCHAR,
  "owner" VARCHAR,
  "owner_address" VARCHAR,
  "owner_telephone" VARCHAR,
  "dep_boiler_application" VARCHAR,
  "n__6_deadline" BIGINT,
  "boiler_model" VARCHAR,
  "n__of_identical_boilers" DOUBLE,
  "boiler_capacity_gross_btu" DOUBLE,
  "boiler_installation_date" DOUBLE,
  "boiler_age_range" VARCHAR,
  "est_retirement_year" DOUBLE,
  "burner_model" VARCHAR,
  "primary_fuel" VARCHAR,
  "total_gallons_high" BIGINT,
  "total_gallons_low" BIGINT,
  "total_mmbtu_high" DOUBLE,
  "total_mmbtu_low" DOUBLE,
  "greener_greater_buildings" DOUBLE,
  "ggb_deadline" DOUBLE,
  "building_type" VARCHAR,
  "council_district" DOUBLE,
  "community_board" VARCHAR,
  "bldg_sqft" VARCHAR,
  "n__of_bldgs" DOUBLE,
  "n__of_floors" DOUBLE,
  "n__of_res_units" DOUBLE,
  "total_units" DOUBLE,
  "year_built" DOUBLE,
  "condo" VARCHAR,
  "coop" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);