Energy — EUI and Fuel Use by Type

Site EUI, source EUI, electricity, natural gas, steam, oil, and renewables.

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

60 rows where Borough = "STATEN IS" and Property Type = "Museum" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1, Floor Area (ft2), Site EUI (kBtu/ft2), Weather Norm Site EUI (kBtu/ft2), National Median Site EUI (kBtu/ft2), Source EUI (kBtu/ft2), Weather Norm Source EUI (kBtu/ft2), Total Site Energy (kBtu), Electricity (kBtu), Electricity (kWh), Natural Gas Use (kBtu), Natural Gas Use (therms)

Calendar Year 10

Property Type 1

  • Museum · 60 ✖

Borough 1

  • STATEN IS · 60 ✖
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Property Type Floor Area (ft2) ENERGY STAR Score Site EUI (kBtu/ft2) Weather Norm Site EUI (kBtu/ft2) National Median Site EUI (kBtu/ft2) Source EUI (kBtu/ft2) Weather Norm Source EUI (kBtu/ft2) Total Site Energy (kBtu) Electricity (kBtu) Electricity (kWh) Natural Gas Use (kBtu) Natural Gas Use (therms) District Steam Use (kBtu) Fuel Oil #2 Use (kBtu) Fuel Oil #4 Use (kBtu) Fuel Oil #5 & 6 Use (kBtu) Diesel #2 Use (kBtu) District Hot Water Use (kBtu) District Chilled Water Use (kBtu) Green Power - Onsite (kWh) Green Power - Offsite (kWh)
328226 328226 2024 21354865 CIG > SHCC_10320_Snug Harbor: Bldg B - Staten Island Museum STATEN IS 1000 Richmond Ter Museum 19,200 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
328227 328227 2024 21354866 CIG > SHCC_11598_Snug Harbor: Bldg Q - Greenhouse STATEN IS 1000 Richmond Ter Museum 2,400 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
328228 328228 2024 21354867 CIG > SHCC_11599_Snug Harbor: Snug Harbor Barn STATEN IS 1000 Richmond Ter Museum 4,500 0.0 1610.3 1666.0 40.0 4509.0 4664.8 7246536.2 7246536.2 2123838.3 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
328230 328230 2024 21354869 CIG > SHCC_788_Snug Harbor: A-B Hyphen STATEN IS 1000A Richmond Ter Museum 1,600 0.0 2171.7 2171.7 41.0 5938.7 5938.7 3474657.8 3344864.8 980323.8 129793.0 1297.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
328232 328232 2024 21354871 CIG > SHCC_790_Snug Harbor: B-H Hyphen/SIM Lab STATEN IS 1000B Richmond Ter Museum 2,100 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
328233 328233 2024 21354872 CIG > SHCC_791_Snug Harbor: Bldg A - Staten Island Museum STATEN IS 1000 Richmond Ter Museum 30,284 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
328235 328235 2024 21354874 CIG > SHCC_793_Snug Harbor: Bldg D - Noble Collection STATEN IS 1000 Richmond Ter Museum 20,604 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
328241 328241 2024 21354880 CIG > SHCC_801_Snug Harbor: Bldg M - SI Children's Museum STATEN IS 1000 Richmond Ter Museum 20,000 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
328242 328242 2024 21354881 CIG > SHCC_802_Snug Harbor: Bldg N - 9-11 Education Center STATEN IS 1000 Richmond Ter Museum 1,500 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
328244 328244 2024 21354883 CIG > SHCC_804_Snug Harbor: M-O Connector/Staten Island Children's Museum STATEN IS 1000 Richmond Ter Museum 4,312 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
328995 328995 2024 21355715 CIG > SHCC_11594_Snug Harbor: Tuscan Garden Lemon House STATEN IS 1000 Richmond Ter Museum 800 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
328996 328996 2024 21355716 CIG > SHCC_11595_Snug Harbor: C-G Hyphen STATEN IS 1000 Richmond Ter Museum 736 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
328997 328997 2024 21355717 CIG > SHCC_11596_Snug Harbor: Bldg W - West Gate House STATEN IS 1000 Richmond Ter Museum 540 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
294793 294793 2023 21354865 CIG > SHCC_10320_Snug Harbor: Bldg B - Staten Island Museum STATEN IS 1000 Richmond Ter Museum 19,200 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
294794 294794 2023 21354866 CIG > SHCC_11598_Snug Harbor: Bldg Q - Greenhouse STATEN IS 1000 Richmond Ter Museum 2,400 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
294795 294795 2023 21354867 CIG > SHCC_11599_Snug Harbor: Snug Harbor Barn STATEN IS 1000 Richmond Ter Museum 4,500 0.0 1646.9 1662.6 40.0 4611.3 4655.2 7410943.2 7410943.2 2172023.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
294797 294797 2023 21354869 CIG > SHCC_788_Snug Harbor: A-B Hyphen STATEN IS 1000A Richmond Ter Museum 1,600 0.0 1816.6 1816.6 41.7 4883.8 4883.8 2906599.4 2721250.4 797552.8 185349.0 1853.5 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
294799 294799 2023 21354871 CIG > SHCC_790_Snug Harbor: B-H Hyphen/SIM Lab STATEN IS 1000B Richmond Ter Museum 2,100 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
294800 294800 2023 21354872 CIG > SHCC_791_Snug Harbor: Bldg A - Staten Island Museum STATEN IS 1000 Richmond Ter Museum 30,284 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
294802 294802 2023 21354874 CIG > SHCC_793_Snug Harbor: Bldg D - Noble Collection STATEN IS 1000 Richmond Ter Museum 20,604 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
294808 294808 2023 21354880 CIG > SHCC_801_Snug Harbor: Bldg M - SI Children's Museum STATEN IS 1000 Richmond Ter Museum 20,000 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
294809 294809 2023 21354881 CIG > SHCC_802_Snug Harbor: Bldg N - 9-11 Education Center STATEN IS 1000 Richmond Ter Museum 1,500 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
294811 294811 2023 21354883 CIG > SHCC_804_Snug Harbor: M-O Connector/Staten Island Children's Museum STATEN IS 1000 Richmond Ter Museum 4,312 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
295619 295619 2023 21355715 CIG > SHCC_11594_Snug Harbor: Tuscan Garden Lemon House STATEN IS 1000 Richmond Ter Museum 800 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
295620 295620 2023 21355716 CIG > SHCC_11595_Snug Harbor: C-G Hyphen STATEN IS 1000 Richmond Ter Museum 736 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
295621 295621 2023 21355717 CIG > SHCC_11596_Snug Harbor: Bldg W - West Gate House STATEN IS 1000 Richmond Ter Museum 540 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
270688 270688 2022 21354865 CIG > SHCC_10320_Snug Harbor: Bldg B - Staten Island Museum STATEN IS 1000 Richmond Ter Museum 19,200 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
270689 270689 2022 21354866 CIG > SHCC_11598_Snug Harbor: Bldg Q - Greenhouse STATEN IS 1000 Richmond Ter Museum 2,400 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
270690 270690 2022 21354867 CIG > SHCC_11599_Snug Harbor: Snug Harbor Barn STATEN IS 1000 Richmond Ter Museum 4,500 0.0 1592.4 1561.9 40.0 4458.7 4373.4 7165691.3 7165691.3 2100143.7 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
270692 270692 2022 21354869 CIG > SHCC_788_Snug Harbor: A-B Hyphen STATEN IS 1000A Richmond Ter Museum 1,600 0.0 1651.1 1672.8 40.9 4519.9 4580.8 2641695.7 2547467.7 746620.0 94228.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
270694 270694 2022 21354871 CIG > SHCC_790_Snug Harbor: B-H Hyphen/SIM Lab STATEN IS 1000B Richmond Ter Museum 2,100 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
270695 270695 2022 21354872 CIG > SHCC_791_Snug Harbor: Bldg A - Staten Island Museum STATEN IS 1000 Richmond Ter Museum 30,284 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
270697 270697 2022 21354874 CIG > SHCC_793_Snug Harbor: Bldg D - Noble Collection STATEN IS 1000 Richmond Ter Museum 20,604 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
270703 270703 2022 21354880 CIG > SHCC_801_Snug Harbor: Bldg M - SI Children's Museum STATEN IS 1000 Richmond Ter Museum 20,000 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
270704 270704 2022 21354881 CIG > SHCC_802_Snug Harbor: Bldg N - 9-11 Education Center STATEN IS 1000 Richmond Ter Museum 1,500 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
270706 270706 2022 21354883 CIG > SHCC_804_Snug Harbor: M-O Connector/Staten Island Children's Museum STATEN IS 1000 Richmond Ter Museum 4,312 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
271515 271515 2022 21355715 CIG > SHCC_11594_Snug Harbor: Tuscan Garden Lemon House STATEN IS 1000 Richmond Ter Museum 800 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
271516 271516 2022 21355716 CIG > SHCC_11595_Snug Harbor: C-G Hyphen STATEN IS 1000 Richmond Ter Museum 736 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
271517 271517 2022 21355717 CIG > SHCC_11596_Snug Harbor: Bldg W - West Gate House STATEN IS 1000 Richmond Ter Museum 540 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
223067 223067 2021 21354865 CIG > SHCC_10320_Snug Harbor: Bldg B - Staten Island Museum STATEN IS 1000 Richmond Ter Museum 19,200 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
223068 223068 2021 21354866 CIG > SHCC_11598_Snug Harbor: Bldg Q - Greenhouse STATEN IS 1000 Richmond Ter Museum 2,400 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
223069 223069 2021 21354867 CIG > SHCC_11599_Snug Harbor: Snug Harbor Barn STATEN IS 1000 Richmond Ter Museum 4,500 0.0 1739.8 1719.8 40.0 4871.4 4815.3 7829093.0 7829093.0 2294575.6 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
223071 223071 2021 21354869 CIG > SHCC_788_Snug Harbor: A-B Hyphen STATEN IS 1000A Richmond Ter Museum 1,600 0.0 1952.7 1994.7 41.5 5274.9 5392.7 3124282.6 2948220.6 864073.9 176062.0 1760.620022 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
223073 223073 2021 21354871 CIG > SHCC_790_Snug Harbor: B-H Hyphen/SIM Lab STATEN IS 1000B Richmond Ter Museum 2,100 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
223074 223074 2021 21354872 CIG > SHCC_791_Snug Harbor: Bldg A - Staten Island Museum STATEN IS 1000 Richmond Ter Museum 30,284 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
223076 223076 2021 21354874 CIG > SHCC_793_Snug Harbor: Bldg D - Noble Collection STATEN IS 1000 Richmond Ter Museum 20,604 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
223082 223082 2021 21354880 CIG > SHCC_801_Snug Harbor: Bldg M - SI Children's Museum STATEN IS 1000 Richmond Ter Museum 20,000 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
223083 223083 2021 21354881 CIG > SHCC_802_Snug Harbor: Bldg N - 9-11 Education Center STATEN IS 1000 Richmond Ter Museum 1,500 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
223085 223085 2021 21354883 CIG > SHCC_804_Snug Harbor: M-O Connector/Staten Island Children's Museum STATEN IS 1000 Richmond Ter Museum 4,312 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
223914 223914 2021 21355715 CIG > SHCC_11594_Snug Harbor: Tuscan Garden Lemon House STATEN IS 1000 Richmond Ter Museum 800 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
223915 223915 2021 21355716 CIG > SHCC_11595_Snug Harbor: C-G Hyphen STATEN IS 1000 Richmond Ter Museum 736 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
223916 223916 2021 21355717 CIG > SHCC_11596_Snug Harbor: Bldg W - West Gate House STATEN IS 1000 Richmond Ter Museum 540 0.0 0.0 0.0 56.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
198418 198418 2020 6297345 CIG - 5000088 - Staten Island Museum (LL84) STATEN IS 75 Stuyvesant Pl Museum 13022 0.0 49.3 53.7 70.7 78.1 82.4 641552.1 195866.1 57405.1 445686.0 4456.860271 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
208765 208765 2020 12344382 BBL 5-00076-0200: Snug Harbor, CIG (LL84) STATEN IS 1000 Richmond Ter Museum 348750 0.0 79.2 86.3 66.5 133.4 140.8 27618452.1 10006098.0 2932619.2 17612354.0 176123.5405 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
170998 170998 2019 6297345 CIG - 5000088 - Staten Island Museum (LL84) STATEN IS 75 Stuyvesant Pl Museum 13,022 0.0 49.7 51.0 68.7 81.1 82.4 647755.7 214644.7 62908.8 433111.0 4331.109957 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
183026 183026 2019 12344382 BBL 5-00076-0200: Snug Harbor, CIG (LL84) STATEN IS 1000 Richmond Ter Museum 354,058 0.0 103.0 105.2 69.3 166.4 168.1 36473064.8 11781188.8 3452868.5 24691876.0 246918.7603 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
146032 146032 2018 6297345 CIG - 5000088 - Staten Island Museum (LL84) STATEN IS 75 Stuyvesant Pl Museum 13,022 0.0 47.3 47.7 69.0 76.7 77.2 615344.5 201444.5 59040.0 413900.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
105320 105320 2017 6,297,345 CIG - 5000088 - Staten Island Museum (LL84) STATEN IS 75 Stuyvesant Pl Museum 13,022   48.5 51.2 42.9 96.2 99.1 631.0 282.0 82.0 348.0                   0.0
85497 85497 2016 4,629,747 CIG - 5000088 - Staten Island Museum (LL84) STATEN IS 75 Stuyvesant Pl Museum 13,022 0.0 56.0 59.6 43.1 110.5 114.1 728829.3 322229.3   406600.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0
75033 75033 2015 4629747 CIG - 5000088 - Staten Island Museum STATEN IS 75 Stuyvesant Pl Museum 13022 0.0 73.6 73.4 44.6 140.5 138.4 958944.8 393744.8   565200.0   0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE energy(
  "Calendar Year" INT,
  "Property ID" TEXT,
  "Property Name" TEXT,
  Borough TEXT,
  "Address 1" TEXT,
  "Property Type" TEXT,
  "Floor Area (ft2)" TEXT,
  "ENERGY STAR Score" REAL,
  "Site EUI (kBtu/ft2)" REAL,
  "Weather Norm Site EUI (kBtu/ft2)" REAL,
  "National Median Site EUI (kBtu/ft2)" REAL,
  "Source EUI (kBtu/ft2)" REAL,
  "Weather Norm Source EUI (kBtu/ft2)" REAL,
  "Total Site Energy (kBtu)" REAL,
  "Electricity (kBtu)" REAL,
  "Electricity (kWh)" REAL,
  "Natural Gas Use (kBtu)" REAL,
  "Natural Gas Use (therms)" 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,
  "Diesel #2 Use (kBtu)" REAL,
  "District Hot Water Use (kBtu)" REAL,
  "District Chilled Water Use (kBtu)" REAL,
  "Green Power - Onsite (kWh)" REAL,
  "Green Power - Offsite (kWh)" REAL
);
CREATE INDEX "idx_energy_Calendar Year" ON [energy] ("Calendar Year");
CREATE INDEX "idx_energy_Property ID" ON [energy] ("Property ID");
CREATE INDEX "idx_energy_Borough" ON [energy] ("Borough");
CREATE INDEX "idx_energy_Property Type" ON [energy] ("Property Type");