NYC Clean Heat Dataset (Historical)

CREATE TABLE table_1 (
  "borough_block_lot" BIGINT  -- Borough, Block, Lot #,
  "street_address" VARCHAR,
  "postcode" DOUBLE,
  "borough" VARCHAR,
  "utility" VARCHAR,
  "building_manager" VARCHAR,
  "owner" VARCHAR,
  "owner_address" VARCHAR,
  "owner_telephone" VARCHAR,
  "dep_boiler_application" VARCHAR  -- DEP Boiler Application #,
  "n__6_deadline" BIGINT  -- #6 Deadline,
  "boiler_model" VARCHAR,
  "n__of_identical_boilers" DOUBLE  -- # Of Identical Boilers,
  "boiler_capacity_gross_btu" DOUBLE  -- Boiler Capacity (Gross BTU),
  "boiler_installation_date" DOUBLE,
  "boiler_age_range" VARCHAR,
  "est_retirement_year" DOUBLE  -- Est. Retirement Year,
  "burner_model" VARCHAR,
  "primary_fuel" VARCHAR,
  "total_gallons_high" BIGINT  -- Total Gallons (High),
  "total_gallons_low" BIGINT  -- Total Gallons (Low),
  "total_mmbtu_high" DOUBLE  -- Total MMBTU (High),
  "total_mmbtu_low" DOUBLE  -- Total MMBTU (low),
  "greener_greater_buildings" DOUBLE,
  "ggb_deadline" DOUBLE,
  "building_type" VARCHAR,
  "council_district" DOUBLE,
  "community_board" VARCHAR,
  "bldg_sqft" VARCHAR,
  "n__of_bldgs" DOUBLE  -- # Of Bldgs,
  "n__of_floors" DOUBLE  -- # Of Floors,
  "n__of_res_units" DOUBLE  -- # Of Res. Units,
  "total_units" DOUBLE,
  "year_built" DOUBLE,
  "condo" VARCHAR  -- Condo?,
  "coop" VARCHAR  -- Coop?,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);