Energy Usage From DOE Buildings
City of New York
@usgov.city_of_new_york_energy_usage_from_doe_buildings
City of New York
@usgov.city_of_new_york_energy_usage_from_doe_buildings
CREATE TABLE table_1 (
"building_address" VARCHAR,
"borough" BIGINT,
"measurement" VARCHAR,
"n" DOUBLE,
"n_02e762" DOUBLE,
"n__fy_2009_7_1_2008" DOUBLE,
"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,
"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,
"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,
"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
);
Anyone who has the link will be able to view this.