Name: Energy Usage From DOE Buildings
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Energy Usage From DOE Buildings

Energy data from a select portfolio of City-owned buildings (DOE)
Organization: City of New York
Last updated: 2020-11-10T17:04:11.601700
Tags: btu, building, data, doe, electricity, energy-usage-from-doe-buildings, heat, lifelong-learning, oil, steam, watts

Tables

Table 1

@usgov.city_of_new_york_energy_usage_from_doe_buildings.table_1

92.5 kB
153 rows
62 columns

CREATE TABLE table_1 (
  "building_address" VARCHAR,
  "borough" BIGINT,
  "measurement" VARCHAR,
  "n" DOUBLE  -- -,
  "n_02e762" DOUBLE,
  "n__fy_2009_7_1_2008" DOUBLE  -- (FY 2009) 7/1/2008,
  "aug_08" DOUBLE,
  "sep_08" DOUBLE,
  "oct_08" DOUBLE,
  "nov_08" DOUBLE,
  "dec_08" DOUBLE,
  "jan_09" DOUBLE,
  "feb_09" DOUBLE,
  "mar_09" DOUBLE,
  "apr_09" DOUBLE,
  "may_09" DOUBLE,
  "jun_09" DOUBLE,
  "n__fy_2010_7_1_2009" DOUBLE  -- (FY 2010)7/1/2009,
  "aug_09" DOUBLE,
  "sep_09" DOUBLE,
  "oct_09" DOUBLE,
  "nov_09" DOUBLE,
  "dec_09" DOUBLE,
  "jan_10" DOUBLE,
  "feb_10" DOUBLE,
  "mar_10" DOUBLE,
  "apr_10" DOUBLE,
  "may_10" DOUBLE,
  "jun_10" DOUBLE,
  "n__fy_2011_7_1_2010" DOUBLE  -- (FY 2011)7/1/2010,
  "aug_10" DOUBLE,
  "sep_10" DOUBLE,
  "oct_10" DOUBLE,
  "nov_10" DOUBLE,
  "dec_10" DOUBLE,
  "jan_11" DOUBLE,
  "feb_11" DOUBLE,
  "mar_11" DOUBLE,
  "apr_11" DOUBLE,
  "may_11" DOUBLE,
  "jun_11" DOUBLE,
  "n__fy_2012_7_1_2011" DOUBLE  -- (FY 2012)7/1/2011,
  "aug_11" DOUBLE,
  "sep_11" DOUBLE,
  "oct_11" DOUBLE,
  "nov_11" DOUBLE,
  "dec_11" DOUBLE,
  "jan_12" DOUBLE,
  "feb_12" DOUBLE,
  "mar_12" DOUBLE,
  "apr_12" DOUBLE,
  "may_12" VARCHAR,
  "jun_12" VARCHAR,
  "postcode" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" BIGINT,
  "council_district" BIGINT,
  "census_tract" BIGINT,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);