home / nyc_ll84

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

12,916 rows where Borough = "MANHATTAN" and Calendar Year = 2017 sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Fuel Oil #5 & 6 Use (kBtu), Diesel #2 Use (kBtu), District Chilled Water Use (kBtu), Green Power - Offsite (kWh)

Property Type >30

  • Multifamily Housing 8,033
  • Office 2,143
  • College/University 421
  • Hotel 420
  • Residence Hall/Dormitory 361
  • K-12 School 289
  • Other 119
  • Parking 90
  • Mixed Use Property 81
  • Immeuble à logements multiples 71
  • Performing Arts 58
  • Retail Store 58
  • Other - Specialty Hospital 52
  • Self-Storage Facility 47
  • Bureau 44
  • Library 42
  • Other - Education 40
  • Medical Office 35
  • Résidence/dortoir 32
  • Movie Theater 31
  • Worship Facility 29
  • Non-Refrigerated Warehouse 26
  • Other - Entertainment/Public Assembly 24
  • Hospital (General Medical & Surgical) 23
  • Repair Services (Vehicle, Shoe, Locksmith, etc.) 21
  • Financial Office 20
  • Police Station 20
  • Social/Meeting Hall 20
  • Urgent Care/Clinic/Other Outpatient 20
  • Museum 19
  • …

Calendar Year 1

  • 2017 · 12,916 ✖

Borough 1

  • MANHATTAN · 12,916 ✖
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)
94814 94814 2017 4,593,574 The Argonaut Building MANHATTAN 224 West 57th St Office 169,416 90.0 53.8 56.2 98.5 138.4 141.0 9.0 6.0 1.0 1.0   1.0               1.0
94818 94818 2017 2,917,939 10 West 27 Street Corp MANHATTAN 1155 Broadway Hotel 50,000 27.0 76.5 80.8 62.1 163.0 167.9 3.0 1.0 579.0 1.0                   0.0
94819 94819 2017 3,878,205 Westbury Realty MANHATTAN 24 John Street Hotel 50,000 99.0 20.5 20.5 49.6 64.2 64.2 1.0 1.0 299.0                     0.0
94821 94821 2017 2,645,118 155 West 66th Street Condominium MANHATTAN 155 West 66th Street Hotel 142,088   117.7 120.1 78.3 243.4 244.6 16.0 7.0 2.0 1.0   7.0               0.0
94836 94836 2017 2,668,350 Fashion Tower MANHATTAN 135 W36 St. Office 107,209 94.0 49.0   103.6 112.2   5.0 3.0 925.0 396.8       2.0           0.0
94838 94838 2017 4,855,845 The Helux MANHATTAN 520 W. 43rd St. Multifamily Housing 319,967 76.0 81.2 85.4 97.3 110.8 114.7 25.0 3.0 1.0 22.0                   0.0
94842 94842 2017 1,390,799 650 Fifth Avenue MANHATTAN 650 Fifth Avenue Office 387,664 89.0 68.6 71.0 124.1 163.1 166.0 26.0 16.0 4.0     10.0               0.0
94843 94843 2017 1,560,916 UJA 732 Lexington Avenue MANHATTAN 732 Lexington Avenue Office 269,470 95.0 50.6 52.2 103.5 134.4 135.8 13.0 10.0 2.0     3.0               0.0
94847 94847 2017 2,664,118 Sovereign - 425 East 58th Street MANHATTAN 425 East 58th Street Multifamily Housing 915,329   129.7 129.7 81.4 203.8 203.8 118.0 29.0 8.0 86.0     2.0             0.0
94855 94855 2017 6,143,730 Jay Cee of New York Corp. MANHATTAN 35 WEST 31ST STREET Office 32,500 59.0 61.4   68.5 119.1   1.0 870.0 255.0 2.0     1.0             0.0
94856 94856 2017 6,143,720 New York Midtown Corp MANHATTAN 222 West 37th Street Office 39,655 52.0 64.0   65.7 131.0   2.0           358.0              
94857 94857 2017 5,067,717 11 Howard Hotel MANHATTAN 11 Howard Street Hotel 112,900 3.0 126.3 127.9 66.7 296.6 298.2 14.0 8.0 2.0 5.0                   0.0
94858 94858 2017 5,019,047 The Salem House MANHATTAN 520 East 81st Street Multifamily Housing 65,000   146.5   92.8 201.9   9.0 1.0 438.0 8.0                   0.0
94860 94860 2017 5,777,220 Whitney Museum of American Art MANHATTAN 99 Gansevoort Street Museum 220,000   170.2 175.5 41.9 345.7 351.9 37.0 17.0 5.0 19.0                   0.0
94861 94861 2017 2,605,457 madison square garden MANHATTAN 4 penn plaza Other - Entertainment/Public Assembly 1,102,735   122.4 125.7 34.2 304.4 308.4 134.0 89.0 26.0 6.0   38.0               0.0
94862 94862 2017 2,959,868 JOLLY HOTEL USA MANHATTAN 241 Madison Avenue Hotel 137,200 70.0 119.2 126.4 144.4 191.9 199.2 16.0 4.0 1.0         11.0           0.0
94868 94868 2017 3,296,567 university club of New York MANHATTAN 1 West 54th Street Hotel 200,000 59.0 72.7 73.1 79.0 207.0 207.9 14.0 12.0 3.0 2.0   18.0               0.0
94874 94874 2017 2,653,186 LEXINGTON PARC CONDOMINIUM MANHATTAN 127 EAST 30TH STREET Multifamily Housing 75,000 97.0 60.2 60.2 101.2 79.9 79.9 4.0 668.0 196.0 56.0       3.0           0.0
94886 94886 2017 6,187,624 150 East 35th MANHATTAN 150 East 35th st College/University 39,905   41.2 42.9 111.3 97.3 101.8 1.0 1.0 302.0 614.0                   0.0
94887 94887 2017 6,194,275 2436 LHT MANHATTAN 24-36 Laurel Hill Terrace Multifamily Housing 42,864 26.0 117.4 117.2 100.5 146.2 145.6 5.0 551.0 161.0 185.0       4.0           0.0
94889 94889 2017 6,187,157 Parking Garage E MANHATTAN 2469-77 Amsterdam Ave College/University 25,984   8.2 8.3 83.6 25.7 26.2 212.0 212.0 62.0                     0.0
94893 94893 2017 4,047,231 Justin - 115 West 30th Street MANHATTAN 115 West 35th Street Multifamily Housing 151,525       59.6                                
94902 94902 2017 2,638,321 155 West 81 MANHATTAN 155 West 81st Street Multifamily Housing 78,435       59.6       902.0 264.0 4.0                   0.0
94903 94903 2017 2,652,078 55th && 5th Avenue Corporation MANHATTAN 1 E 55th Street Office 310,000 87.0 63.4 64.2 108.4 178.5 179.5 19.0 16.0 4.0     3.0               0.0
94904 94904 2017 1,439,342 120 Broadway Holdings, LLC MANHATTAN 120 Broadway Office 1,910,503 86.0 66.3 69.3 110.4 164.7 168.1 126.0 83.0 24.0 2.0   40.0               0.0
94906 94906 2017 2,665,684 Episcopal Church Center MANHATTAN 815 Second Avenue Office 139,824 87.0 63.3 68.5 107.6 140.8 147.8 8.0 4.0 1.0     4.0               0.0
94907 94907 2017 5,870,281 Village Place Corporation MANHATTAN 35 East 12th Street Multifamily Housing 64,377 94.0 55.6 61.4 84.0 65.6 71.7 3.0 222.0 65.0 3.0                   0.0
94908 94908 2017 4,600,346 Wyndham Midtown 45 MANHATTAN 205 East 45th Street Hotel 140,105 7.0 103.8 103.2 63.1 191.1 189.6 14.0 5.0 1.0 9.0                   0.0
94909 94909 2017 6,187,159 Icon parking garage MANHATTAN 2479 amsterdam ave College/University 26,260   8.0 8.2 112.1 18.8 19.3 210.0 130.0 38.0 80.0                   0.0
94910 94910 2017 4,938,305 105 E 106th & 104 E 107th MANHATTAN 105 East 107th Street Other 180,300   87.4 90.3 50.4 213.5 216.0 15.0 10.0 3.0 1.0       4.0           0.0
94911 94911 2017 6,236,828 380 BROADWAY LLC MANHATTAN 380 BROADWAY Mixed Use Property 27,500   1.1 1.1 39.2 3.5 3.5 30.0 30.0 8.0                     0.0
94912 94912 2017 3,537,823 New York Academy of Medicine MANHATTAN 1216 Fifth Ave Office 200,000       67.3                                
94918 94918 2017 4,034,305 Jeffries Morris - 29 Broadway MANHATTAN 29 Broadway Office 300,954 86.0 72.0 76.1 119.8 155.8 160.0 21.0 10.0 3.0     10.0               0.0
94922 94922 2017 3,568,901 Park Lane Hotel MANHATTAN 36 Central Park South Hotel 442,000 30.0 136.3 136.5 114.3 236.6 235.8 60.0 16.0 4.0 1.0   41.0               0.0
94929 94929 2017 2,638,320 Kipling Arms MANHATTAN 145 West 96th Street Multifamily Housing 102,000 80.0 72.6   90.4 102.4   7.0 1.0 374.0 6.0                   0.0
94936 94936 2017 4,960,043 3 East 43rd Street MANHATTAN 3 East 43rd Street College/University 40,000   78.6 79.9 83.6 246.8 250.9 3.0 3.0 921.0                     0.0
94937 94937 2017 4,409,966 Berkeley 12 East 41st LLC MANHATTAN 12 E. 41st Street College/University 83,267   118.4 125.7 118.2 263.1 271.6 9.0 5.0 1.0     4.0               0.0
94938 94938 2017 4,401,809 ESRT - One Grand Central Place MANHATTAN 60 East 42nd Street Office 1,158,407 88.0 71.8 76.1 124.6 146.9 151.0 83.0 36.0 10.0 2.0   44.0               0.0
94939 94939 2017 4,401,675 ESRT - 250 West 57th Street MANHATTAN 250 West 57th Street Office 479,349 79.0 73.1 76.3 106.7 175.0 177.3 35.0 22.0 6.0 9.0     12.0             0.0
94940 94940 2017 4,943,395 Hotel Plaza Athenee MANHATTAN 37 East 64th Street Hotel 170,000 80.0 54.9 54.6 75.9 154.5 153.5 9.0 7.0 2.0 1.0                   0.0
94941 94941 2017 4,406,449 ESRT - 1400 Broadway MANHATTAN 1400 Broadway Office 818,729 81.0 75.3 79.2 113.7 179.4 182.9 61.0 39.0 11.0 37.0     21.0             0.0
94942 94942 2017 4,401,809 ESRT - One Grand Central Place MANHATTAN 60 East 42nd Street Office 1,158,407 88.0 71.8 76.1 124.6 146.9 151.0 83.0 36.0 10.0 2.0   44.0               0.0
94943 94943 2017 4,399,574 ESRT - 111 West 33rd Street MANHATTAN 111 West 33rd Street Office 670,212 88.0 55.1 56.1 96.1 129.5 130.6 36.0 21.0 6.0     15.0               0.0
94944 94944 2017 4,407,011 ESRT - 501 7th Ave* MANHATTAN 501 7th Avenue Office 455,058 75.0 75.9 79.3 103.0 182.1 184.7 34.0 22.0 6.0 1.0     10.0             0.0
94945 94945 2017 4,398,177 ESRT - Empire State Building MANHATTAN 350 Fifth Avenue Office 2,851,447 86.0 75.0 78.3 124.6 178.6 182.8 213.0 130.0 38.0 4.0   79.0               0.0
94946 94946 2017 6,196,009 35CPN MANHATTAN 35 Central Park North Multifamily Housing 60,000 46.0 93.9 99.9 91.9 126.3 131.9 5.0 881.0 258.0 200.0       4.0           0.0
94949 94949 2017 2,653,186 LEXINGTON PARC CONDOMINIUM MANHATTAN 127 EAST 30TH STREET Multifamily Housing 75,000 97.0 60.2 60.2 101.2 79.9 79.9 4.0 668.0 196.0 56.0       3.0           0.0
94950 94950 2017 1,025,339 425 Lexington Avenue MANHATTAN 425 Lexington Ave Office 675,086 87.0 71.8 73.5 117.0 187.0 188.3 48.0 35.0 10.0 994.0   12.0               0.0
94951 94951 2017 3,980,446 836 Broadway MANHATTAN 836 Broadway Office 60,000 67.0 73.4 78.3 90.3 152.0 157.2 4.0 2.0 642.0 35.0     2.0             0.0
94952 94952 2017 2,643,323 441-451 MANHATTAN 441-451 West End Avenue Multifamily Housing 240,040 59.0 78.0 85.5 82.6 108.7 116.2 18.0 3.0 985.0 520.0       14.0           0.0
94956 94956 2017 4,230,686 Kalikow - 101 Park Ave_SWA MANHATTAN 101 Park Avenue Office 1,240,084 73.0 70.3 72.2 92.4 184.6 186.8 87.0 64.0 18.0 661.0   22.0               0.0
94957 94957 2017 6,216,796 21 Bennett MANHATTAN 21 Bennett Av. Multifamily Housing 38,670 87.0 87.7 93.1 117.8 116.4 122.1 3.0 449.0 131.0 2.0                   0.0
94958 94958 2017 6,234,680 31 Bennett MANHATTAN 31 Bennett Ave. Multifamily Housing 40,206       59.6       558.0 163.0                     0.0
94959 94959 2017 6,234,685 41 Bennett MANHATTAN 41 Bennett Ave. Multifamily Housing 42,924 93.0 75.9 81.6 113.0 101.7 107.9 3.0 452.0 132.0 2.0                   0.0
94961 94961 2017 2,638,325 21 East 10 MANHATTAN 21 East 10th street Multifamily Housing 60,939   70.4   78.5 114.7   4.0 1.0 348.0 3.0                   0.0
94962 94962 2017 2,638,809 Wolk Properties MANHATTAN 740 West End Avenue Multifamily Housing 145,497       59.6       1.0 517.0 6.0                   0.0
94972 94972 2017 6,143,720 New York Midtown Corp MANHATTAN 222 West 37th Street Office 39,655 52.0 64.0   65.7 131.0   2.0           358.0              
94977 94977 2017 4,392,811 Lycee Francais LL84 MANHATTAN 505 E. 75th St K-12 School 181,120 75.0 58.0 61.1 74.6 136.4 139.6 10.0 6.0 1.0 3.0                 81.0 0.0
94980 94980 2017 4,047,232 Justin - 9-- Broadway MANHATTAN 900 Broadway Multifamily Housing 98,146       59.6                                
94984 94984 2017 4,928,744 159 E 30 Street - 37438 MANHATTAN 159 E 30 Street Multifamily Housing 61,000 3.0 124.2 131.9 78.9 196.3 202.8 7.0 1.0 563.0 5.0                   0.0
94986 94986 2017 1,582,233 1 United Nations Plaza MANHATTAN 1 United Nations Plaza Office 587,000 58.0 107.4 110.5 117.1 244.6 246.4 63.0 35.0 10.0 1.0   26.0               0.0
94987 94987 2017 1,582,252 2 United Nations Plaza MANHATTAN 2 United Nations Plaza Office 565,000 70.0 87.3 91.8 109.5 189.8 194.5 49.0 24.0 7.0     24.0               0.0
94999 94999 2017 1,230,813 Zuckerman MANHATTAN 415 E 68 St Laboratory 743,935   398.5 406.9 55.7 880.4 887.8 290.0 150.0 44.0 26.0   139.0               0.0
95000 95000 2017 1,230,818 Rockefeller Research Lab MANHATTAN 430 E 67 St Laboratory 327,993   382.4 392.1 57.0 826.5 831.9 125.0 62.0 18.0     63.0               0.0
95001 95001 2017 1,418,514 Kimmel MANHATTAN 351 E 68 St Medical Office 60,274   152.2 155.7 48.8 383.6 384.7 9.0 6.0 1.0     2.0               0.0
95002 95002 2017 2,382,101 Evelyn H. Lauder Breast and Imaging Center MANHATTAN 300 E 65 St Urgent Care/Clinic/Other Outpatient 238,341   216.8 220.4 55.3 483.2 487.5 51.0 27.0 8.0     24.0               0.0
95004 95004 2017 4,410,386 MSKCC Ambulatory Care: Josie Robertson Surgery Center MANHATTAN 1133 York Ave Ambulatory Surgical Center 238,000   237.2 239.3 83.7 439.7 440.5 56.0 21.0 6.0 34.0                   0.0
95005 95005 2017 4,926,122 Main Campus - Super Block MANHATTAN 1275 York Ave Other - Specialty Hospital 1,382,117   301.3 306.2 193.5 607.0 613.0 416.0 174.0 51.0     241.0               0.0
95006 95006 2017 4,929,323 Schwartz-Lot 01 MANHATTAN 1250 First Ave Other 197,916       78.8                                
95007 95007 2017 4,929,345 Main Campus - Lot 05 MANHATTAN 1275 York Ave Other - Specialty Hospital 1,184,201       78.8                                
95008 95008 2017 5,910,762 Lab Medicine MANHATTAN 327 E 64th St Laboratory 91,193   156.4   53.2 362.2   14.0 8.0 2.0                     0.0
95009 95009 2017 6,224,968 3rd Avenue MANHATTAN 2226 3rd Avenue Other - Mall 33,736   56.1 58.5 112.6 118.3 121.2 1.0 959.0 281.0 933.0                   0.0
95010 95010 2017 3,117,707 AMDA - Stratford Arms Hotel MANHATTAN 117 West 70th St Residence Hall/Dormitory 75,000 46.0 122.6 126.6 117.4 205.3 208.2 9.0 2.0 835.0 888.0     5.0             0.0
95011 95011 2017 5,819,523 Belfer Hall MANHATTAN 2495 amsterdam ave College/University 253,942   118.2 128.9 157.1 197.5 208.4 30.0 8.0 2.0 21.0                   0.0
95012 95012 2017 5,819,529 Furst Hall MANHATTAN 500 west 185th street College/University 105,698   92.0 101.6 169.9 142.2 152.5 9.0 2.0 716.0 13.0       7.0           0.0
95013 95013 2017 5,819,550 Glueck Center MANHATTAN 515 west 185th st College/University 59,675   98.8 104.9 122.9 211.1 216.1 5.0 3.0 898.0 2.0                   0.0
95014 95014 2017 5,819,566 Gottesman Library MANHATTAN 2520 Amsterdam Ave College/University 110,677   37.4 37.4 83.6 117.4 117.4 4.0 4.0 1.0                     0.0
95015 95015 2017 5,819,576 Morgenstern Residence Hall MANHATTAN 2525 amsterdam ave College/University 72,187   97.4 97.4 179.0 142.8 142.8 7.0 1.0 441.0 56.0       5.0           0.0
95016 95016 2017 5,819,586 Rubin Residence Hall MANHATTAN 2501 amsterdam ave College/University 102,095   185.4 185.4 150.6 323.3 323.3 18.0 6.0 1.0         12.0           0.0
95017 95017 2017 5,819,593 Zysman Hall MANHATTAN 2540 amsterdam ave College/University 119,715   67.2 67.4 88.1 200.3 200.5 8.0 7.0 2.0 610.0                   0.0
95018 95018 2017 5,858,542 zysman gottesman MANHATTAN 2540 amsterdam ave College/University 230,392   101.8 109.5 260.0 102.8 110.6 23.0           23.0              
95019 95019 2017 4,895,698 The Penn Club of New York MANHATTAN 30 W 44th Street Hotel 59,000 47.0 109.0 108.8 107.0 289.1 287.6 6.0 4.0 1.0 1.0                   0.0
95020 95020 2017 5,819,641 Schottenstein Residence Hall MANHATTAN 119 east 29th st College/University 52,604   87.1 87.1 142.8 160.1 160.1 4.0 1.0 506.0 2.0                   0.0
95022 95022 2017 4,960,043 3 East 43rd Street MANHATTAN 3 East 43rd Street College/University 40,000   78.6 79.9 83.6 246.8 250.9 3.0 3.0 921.0                     0.0
95023 95023 2017 4,409,966 Berkeley 12 East 41st LLC MANHATTAN 12 E. 41st Street College/University 83,267   118.4 125.7 118.2 263.1 271.6 9.0 5.0 1.0     4.0               0.0
95025 95025 2017 4,039,125 Jeffries Morris - 60 W 57th MANHATTAN 60 west 57th street Multifamily Housing 303,642 2.0 98.0 100.5 58.8 183.1 184.9 29.0 10.0 3.0 5.0   13.0               0.0
95026 95026 2017 4,401,809 ESRT - One Grand Central Place MANHATTAN 60 East 42nd Street Office 1,158,407 88.0 71.8 76.1 124.6 146.9 151.0 83.0 36.0 10.0 2.0   44.0               0.0
95027 95027 2017 4,410,272 Standard Hotel MANHATTAN 848 Washington Street Hotel 206,000 1.0 275.3 285.0 109.1 550.2 561.5 56.0 25.0 7.0 30.0                   0.0
95030 95030 2017 6,222,851 15 East 10th Street Owners MANHATTAN 15 East 10th Street Multifamily Housing 36,366 55.0 91.2   94.2 126.0   3.0 526.0 154.0 2.0                   0.0
95032 95032 2017 2,722,411 360 East 72nd Street MANHATTAN 360 East 72nd Street Multifamily Housing 588,551 26.0 95.1 93.7 81.3 154.1 152.4 55.0 14.0 4.0 30.0   11.0               0.0
95038 95038 2017 2,674,246 Churchill - 301 E 29th St MANHATTAN 301 East 29th Street K-12 School 71,000 36.0 90.4 95.8 79.8 202.4 207.6 6.0 3.0 1.0 2.0                   0.0
95044 95044 2017 6,250,440 408 West 34th Street MANHATTAN 408 West 34th Street Multifamily Housing 46,500   98.9   76.5 165.3   4.0 1.0 400.0 3.0                   0.0
95045 95045 2017 2,054,784 UNICEF HOUSE MANHATTAN 3 UN Plaza Office 208,203 85.0 90.4 93.7 139.8 234.0 238.0 18.0 13.0 3.0     5.0               0.0
95047 95047 2017 6,222,853 165 West 83rd Street MANHATTAN 165 West 83rd Street Multifamily Housing 36,512       59.6                                
95050 95050 2017 6,151,465 85 Broad Street MANHATTAN 85 Broad Street Office 1,180,000 90.0 50.7   91.7 144.4   59.0 50.0 14.0                     0.0
95055 95055 2017 5,985,966 WeCare Trading Company llc, d/b/a Cambria Hotel Suites New York - Chelsea MANHATTAN 123 West 28th St Hotel 55,411 65.0 92.8 95.8 107.4 222.9 228.3 5.0 3.0 975.0 1.0                   0.0
95056 95056 2017 4,038,133 360 Lexington Ave MANHATTAN 360 Lexington Avenue Office 255,544 90.0 61.3 64.7 111.0 146.2 149.9 15.0 9.0 2.0     6.0               0.0
95057 95057 2017 4,040,253 830 Third Ave MANHATTAN 830 Third Avenue Office 151,559 47.0 109.2 110.3 106.7 274.8 275.6 16.0 11.0 3.0 2.0   2.0               0.0
95058 95058 2017 6,235,436 Nunz Realty LLC MANHATTAN 508 West 112th Street Multifamily Housing 27,326 69.0 88.9 88.8 101.3 116.1 115.6 2.0 335.0 98.0 84.0     2.0             0.0
95059 95059 2017 6,151,477 3 Bryant Park MANHATTAN 3 Bryant Park Office 1,437,148 65.0 89.5 89.5 107.1 213.3 213.3 128.0 78.0 22.0     50.0               0.0

Next page

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");
Powered by Datasette · Queries took 3092.919ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability