Summary — Key Metrics (start here)

The 25 most important columns: property info, ENERGY STAR score, EUI, GHG emissions, GHGI (kgCO2e/m²), and fuel use by type. Filter using the column boxes or left-side facets. Export to CSV or JSON.

Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability

49 rows where Borough = "BROOKLYN" and Property Type = "Retail" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1, Postal Code, Floor Area (ft2), Year Built, ENERGY STAR Score, Total GHG (MtCO2e), GHGI (kgCO2e/m2), Indirect GHG (MtCO2e), Natural Gas Use (kBtu), BIN

Calendar Year 3

Property Type 1

  • Retail · 49 ✖

Borough 1

  • BROOKLYN · 49 ✖
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Postal Code Property Type Floor Area (ft2) Year Built Number of Buildings ENERGY STAR Score Site EUI (kBtu/ft2) Weather Norm Site EUI (kBtu/ft2) Source EUI (kBtu/ft2) Total GHG (MtCO2e) GHGI (kgCO2e/m2) Direct GHG (MtCO2e) Indirect GHG (MtCO2e) Electricity (kBtu) Natural Gas Use (kBtu) District Steam Use (kBtu) Fuel Oil #2 Use (kBtu) Fuel Oil #4 Use (kBtu) Fuel Oil #5 & 6 Use (kBtu) Water Use (kgal) BBL BIN
22846 22846 2012 1296055 10781-Ceasar's Bay BROOKLYN 8973 Bay Parkway Suite 1 11,214 Retail 133882 2004   62 66.8 67.8 188.2         6903977.28 2044700.0 0.0 0.0 0.0 0.0   3064910011 3345609
22926 22926 2012 1547924 GATEWAY (1401) BROOKLYN 519 GATEWAY DR 11,239 Retail 148939 2002   78 92.7 96.7 225.9         8369075.51 5439270.0 0.0 0.0 0.0 0.0   3044520520 3348833
23015 23015 2012 2037331 1143 BROOKLYN 5200 KINGS PLAZA 11,234 Retail 283387 1997   93 26.8 26.8 89.5         7589987.18 3000.0 0.0 0.0 0.0 0.0   3084700055 3326830
23017 23017 2012 2038302 1114 BROOKLYN 2307 BEVERLEY RD 11,226 Retail 187823 1932   77 55.3 56.7 138.3         6590530.49 3789300.0 0.0 0.0 0.0 0.0   3051330014 3117881
23018 23018 2012 2038302 1114 BROOKLYN 2307 BEVERLEY RD 11,226 Retail 187823 1932   81 52.8 59.0 130.0         6121383.9 3789300.0 0.0 0.0 0.0 0.0   3051330014 3117881
23036 23036 2012 2271555 Pratt Store BROOKLYN 550 Myrtle Ave 11,205 Retail 15000 2005   0 51.0 51.0 129.8         499516.8 265900.0 0.0 0.0 0.0 0.0   3019050120 3395391
23969 23969 2012 2640532 585 Dekalb BROOKLYN 585 Dekalb Avenue 11,205 Retail 162999 1999   40 95.1 96.0 267.4         11933121.46 3560415.83 0.0 0.0 0.0 0.0   3017640001 3049016
24264 24264 2012 2646603 (71002A) Brooklyn BROOKLYN 422 Fulton Street 11,201 Retail 1157000 1865   69 108.2 113.2 148.5         17776444.49 107433491.2 0.0 0.0 0.0 0.0   3001567502 3335899
26170 26170 2012 2687535 3861 Nostrand Ave BROOKLYN 3861 Nostrand Ave 11,235 Retail 80303 1960   0 95.3 93.7 237.2         4815580.79 2833300.0 0.0 0.0 0.0 0.0   3074460001 3204766
26649 26649 2012 2708994 486 NEPTUNE AVE PLP BROOKLYN 486 NEPTUNE AVE PLP 11,224 Retail 63522 1964   20 136.5 141.2 326.0         5070999.67 3602884.0 0.0 0.0 0.0 0.0   3072737501 3426198
29958 29958 2012 2810392 380 Fulton Street BROOKLYN 380 Fulton Street 11,201 Retail 57675 1915   0 68.8 63.5 184.2         2821188.21 1146300.0 0.0 0.0 0.0 0.0   3001540019 3329436
31713 31713 2012 2937892 Costco #318 Brooklyn BROOKLYN 976 Third Ave 11,232 Retail 143916 1996   9 222.0 227.3 551.3         20008604.91 11945533.33 0.0 0.0 0.0 0.0   3006990001 3337075
32368 32368 2012 3065257 Home Depot #6152 Starrett City BROOKLYN 579 Gateway Drive 11,239 Retail 125942 2002   53 76.4 76.8 217.7         7566184.24 2053988.35 0.0 0.0 0.0 0.0   3044520530 3348834
32373 32373 2012 3066775 Home Depot #1225 Brooklyn BROOKLYN 550 Hamilton Avenue 11,232 Retail 138741 1998   42 86.5 86.3 260.7         10296563.0 1705378.98 0.0 0.0 0.0 0.0   3006250065 3008889
32379 32379 2012 3068204 Home Depot # 1256 Cropsey BROOKLYN 2970 Cropsey Avenue 11,214 Retail 133137 2001   37 88.1 89.0 255.1         9456137.22 2271401.71 0.0 0.0 0.0 0.0   3069470500 3348838
33015 33015 2012 3114293 Gateway Center Brooklyn BROOKLYN 501 Gateway Drive 11,239 Retail 621445 2009   52 108.9 110.5 322.6         56530888.24 11162121.09 0.0 0.0 0.0 0.0   3044520520 3348833
33016 33016 2012 3114293 Gateway Center Brooklyn BROOKLYN 501 Gateway Drive 11,239 Retail 621445 2009   6 178.0 178.8 490.1         82315365.77 28303106.31 0.0 0.0 0.0 0.0   3044520520 3348833
33783 33783 2012 3128268 495 Flatbush Avenue BROOKLYN 495 Flatbush Avenue 11,225 Retail 80000 1925   76 57.1 63.1 92.3         1132902.07 3435348.78 0.0 0.0 0.0 0.0   3011970006 3029735
34826 34826 2012 3506236 Abeco Flushing Ave LL84 BROOKLYN 785 Flushing Ave 11,206 Retail 130000 1910   100 8.9 8.6 29.8         1157958.18 0.0 0.0 0.0 0.0 0.0   3031270001 3326062
35391 35391 2012 3531745 Kassin 2101 Church Ave. BROOKLYN 2101 Church Ave. 11,226 Retail 61000 1928   86 42.9 41.9 134.9         2395599.54 219100.0 0.0 0.0 0.0 0.0   3050820055 3116593
35476 35476 2012 3533706 Home Depot #6158 Mill Basin/Brooklyn BROOKLYN 5700 Avenue U 11,234 Retail 60944 2002   46 104.1 105.1 293.4         4901381.69 1442804.81 0.0 0.0 0.0 0.0   3084700143 3238576
14512 14512 2011 2038302 1114 BROOKLYN 2307 BEVERLEY RD 11,226 Retail 187,823 1932   77 60.7 63.6 145.7 880.49 50681.85 249.03 631.46 6.0 4.0         696.6 3051330014 3117881
16643 16643 2011 3102737 Abeco 785 BROOKLYN 785 Flushing Ave 11,206 Retail 130,000 1910   10 92.9 92.9 310.4 1.0 82.8   1.0 12.0             3031270001 3326062
18000 18000 2011 2646603 (71002A) B BROOKLYN 420 Fulton Street 11,201 Retail 1,157,000 1865   55 118.8 116.7 184.5 8.0 86111.2 5.0 2.0 30.0 107.0           3001560001  
18491 18491 2011 2640532 585 Dekalb BROOKLYN 585 Dekalb Avenue 11,205 Retail 162,999 1999   42 97.0 99.3 265.1 1.0 66.44 222.53 1.0 11.0 4.0           3017640001 3049016
18547 18547 2011 2271555 Pratt Stor BROOKLYN 550 Myrtle Ave 11,205 Retail 15,000 2005   0 60.9 60.9 149.8 71.52 51322.28 18.67 52.84 562.0 351.0           3019050120 3853174
18978 18978 2011 3114293 Gateway Ce BROOKLYN 501 Gateway Drive 11,239 Retail 638,991 2009   46 83.6 82.6 279.3 5.0 84.36   5.0 53.0             3044520500 3849660;3348826;3348827;3348828;3348829;3348830;3348831;3348833;3348834;3348837;3348832;3348836;3348835
18979 18979 2011 3114293 Gateway Ce BROOKLYN 501 Gateway Drive 11,239 Retail 638,991 2009   46 83.6 82.6 279.3 5.0 84.36   5.0 53.0             3044520530 3849660;3348826;3348827;3348828;3348829;3348830;3348831;3348833;3348834;3348837;3348832;3348836;3348835
18985 18985 2011 3114293 Gateway Ce BROOKLYN 501 Gateway Drive 11,239 Retail 638,991 2009   46 83.6 82.6 279.3 5.0 84.36   5.0 53.0             3044520540 3849660;3348826;3348827;3348828;3348829;3348830;3348831;3348833;3348834;3348837;3348832;3348836;3348835
18991 18991 2011 3114293 Gateway Ce BROOKLYN 501 Gateway Drive 11,239 Retail 638,991 2009   46 83.6 82.6 279.3 5.0 84.36   5.0 53.0             3044520510 3849660;3348826;3348827;3348828;3348829;3348830;3348831;3348833;3348834;3348837;3348832;3348836;3348835
18992 18992 2011 3114293 Gateway Ce BROOKLYN 501 Gateway Drive 11,239 Retail 638,991 2009   46 83.6 82.6 279.3 5.0 84.36   5.0 53.0             3044520550 3849660;3348826;3348827;3348828;3348829;3348830;3348831;3348833;3348834;3348837;3348832;3348836;3348835
18995 18995 2011 3114293 Gateway Ce BROOKLYN 501 Gateway Drive 11,239 Retail 638,991 2009   46 83.6 82.6 279.3 5.0 84.36   5.0 53.0             3044520450 3849660;3348826;3348827;3348828;3348829;3348830;3348831;3348833;3348834;3348837;3348832;3348836;3348835
18996 18996 2011 3114293 Gateway Ce BROOKLYN 501 Gateway Drive 11,239 Retail 638,991 2009   46 83.6 82.6 279.3 5.0 84.36   5.0 53.0             3044520460 3849660;3348826;3348827;3348828;3348829;3348830;3348831;3348833;3348834;3348837;3348832;3348836;3348835
18997 18997 2011 3114293 Gateway Ce BROOKLYN 501 Gateway Drive 11,239 Retail 638,991 2009   46 83.6 82.6 279.3 5.0 84.36   5.0 53.0             3044520470 3849660;3348826;3348827;3348828;3348829;3348830;3348831;3348833;3348834;3348837;3348832;3348836;3348835
18998 18998 2011 3114293 Gateway Ce BROOKLYN 501 Gateway Drive 11,239 Retail 638,991 2009   46 83.6 82.6 279.3 5.0 84.36   5.0 53.0             3044520480 3849660;3348826;3348827;3348828;3348829;3348830;3348831;3348833;3348834;3348837;3348832;3348836;3348835
18999 18999 2011 3114293 Gateway Ce BROOKLYN 501 Gateway Drive 11,239 Retail 638,991 2009   46 83.6 82.6 279.3 5.0 84.36   5.0 53.0             3044520490 3849660;3348826;3348827;3348828;3348829;3348830;3348831;3348833;3348834;3348837;3348832;3348836;3348835
19000 19000 2011 3114293 Gateway Ce BROOKLYN 501 Gateway Drive 11,239 Retail 638,991 2009   46 83.6 82.6 279.3 5.0 84.36   5.0 53.0             3044520520 3849660;3348826;3348827;3348828;3348829;3348830;3348831;3348833;3348834;3348837;3348832;3348836;3348835
19001 19001 2011 3114293 Gateway Ce BROOKLYN 501 Gateway Drive 11,239 Retail 638,991 2009   46 83.6 82.6 279.3 5.0 84.36   5.0 53.0             3044520560 3849660;3348826;3348827;3348828;3348829;3348830;3348831;3348833;3348834;3348837;3348832;3348836;3348835
19002 19002 2011 3114293 Gateway Ce BROOKLYN 501 Gateway Drive 11,239 Retail 638,991 2009   46 83.6 82.6 279.3 5.0 84.36   5.0 53.0             3044520570 3849660;3348826;3348827;3348828;3348829;3348830;3348831;3348833;3348834;3348837;3348832;3348836;3348835
19190 19190 2011 2900042 2101 churc BROOKLYN 2101 church ave 11,226 Retail 42,000 2003   1 2.0 2.0 3.0 6.0 1537.7 6.0 366.5 3.0 114.0           3050820005 bin#3116593
20256 20256 2011 2037331 1143 BROOKLYN 5200 KINGS PLAZA 11,234 Retail 283,387 1997   92 27.9 27.9 93.3 743.33 28272.54 0.36 742.97 7.0 6.0           3084700055 3326830
4784 4784 2010 2692289 Lowe's #1674-Brooklyn, NY BROOKLYN 118 2nd Avenue 11,215 Retail 159,379     49 80.2 79.2 258.5 1.0 67.7 34.65 1.0 12.0 651.0           3010070118 3022201
4856 4856 2010 2640532 585 Dekalb BROOKLYN 585 Dekalb Avenue 11,205 Retail 162,999     41 99.3 101.6 276.3 1.0 66.44 209.08 1.0 12.0 3.0           3017640001 3049016
4923 4923 2010 2646603 (71002A) Brooklyn BROOKLYN 420 Fulton Street 11,201 Retail 1,157,000     0                           13.0 3001560013 3000442
5976 5976 2010 1775094 Gateway Center Brooklyn BROOKLYN 501 Gateway Drive 11,239 Retail 637,985     4 82.9 80.0 276.8 4.0 67.59   4.0 52.0             3044520520 3348833
6829 6829 2010 2271555 Pratt Store BROOKLYN 550 Myrtle Ave 11,205 Retail 15,000     0 56.8 56.8 136.7 65.9 47289.4 18.51 47.39 504.0 348.0           3019050120 3395391
7715 7715 2010 2038302 1114 BROOKLYN 2307 BEVERLEY RD 11,226 Retail 187,823     80 59.6 62.5 141.1 857.94 49383.85 252.89 605.06 6.0 4.0           3051330014 3117881
7716 7716 2010 2037331 1143 BROOKLYN 5200 KINGS PLAZA 11,234 Retail 283,387     91 29.3 29.3 97.8 779.07 29631.91 0.24 778.84 8.0 4.0         1.0 3084700055 3326830
8689 8689 2010 2812379 Abeco 785 Flushing BROOKLYN 785 Flushing Ave 11,206 Retail 130,000     10 92.9 92.9 310.4 1.0 82.8   1.0 12.0             3031270001 3326062

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE summary(
  "Calendar Year" INT,
  "Property ID" TEXT,
  "Property Name" TEXT,
  Borough TEXT,
  "Address 1" TEXT,
  "Postal Code" TEXT,
  "Property Type" TEXT,
  "Floor Area (ft2)" TEXT,
  "Year Built" TEXT,
  "Number of Buildings" TEXT,
  "ENERGY STAR Score" TEXT,
  "Site EUI (kBtu/ft2)" REAL,
  "Weather Norm Site EUI (kBtu/ft2)" REAL,
  "Source EUI (kBtu/ft2)" REAL,
  "Total GHG (MtCO2e)" REAL,
  "GHGI (kgCO2e/m2)",
  "Direct GHG (MtCO2e)" REAL,
  "Indirect GHG (MtCO2e)" REAL,
  "Electricity (kBtu)" REAL,
  "Natural Gas Use (kBtu)" REAL,
  "District Steam Use (kBtu)" REAL,
  "Fuel Oil #2 Use (kBtu)" REAL,
  "Fuel Oil #4 Use (kBtu)" REAL,
  "Fuel Oil #5 & 6 Use (kBtu)" REAL,
  "Water Use (kgal)" REAL,
  BBL TEXT,
  BIN TEXT
);
CREATE INDEX "idx_summary_Calendar Year" ON [summary] ("Calendar Year");
CREATE INDEX "idx_summary_Property ID" ON [summary] ("Property ID");
CREATE INDEX "idx_summary_Borough" ON [summary] ("Borough");
CREATE INDEX "idx_summary_Property Type" ON [summary] ("Property Type");
CREATE INDEX "idx_summary_Postal Code" ON [summary] ("Postal Code");