home / nyc_ll84

GHG — Emissions and Intensity

Total, direct, indirect, and net GHG emissions. Includes GHGI (kgCO2e/m²) calculated for all years.

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

198 rows where Calendar Year = 2019 and Property Type = "Worship Facility" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Grid Emissions Rate (kgCO2e/MBtu), Avoided GHG Onsite (MtCO2e), Avoided GHG Offsite (MtCO2e)

Borough 5

  • BROOKLYN 67
  • MANHATTAN 61
  • QUEENS 31
  • BRONX 19
  • STATEN IS 10

Property Type 1

  • Worship Facility · 198 ✖

Calendar Year 1

  • 2019 · 198 ✖
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Property Type Floor Area (ft2) Total GHG (MtCO2e) GHGI (kgCO2e/m2) Direct GHG (MtCO2e) Indirect GHG (MtCO2e) Net GHG (MtCO2e) Grid Emissions Rate (kgCO2e/MBtu) Avoided GHG Onsite (MtCO2e) Avoided GHG Offsite (MtCO2e) National Median GHG (MtCO2e) ENERGY STAR Score Site EUI (kBtu/ft2)
159368 159368 2019 2793010 Bethel Gospel Assembly, Inc. MANHATTAN 1832 Madison Avenue Worship Facility 135,264 190.3 15173.11 35.4 154.9 190.3 84.7 0.0 0.0   0.0 18.5
161119 161119 2019 3102345 CHRISTIAN CULTURAL CENTER INC BROOKLYN 12040 FLATLANDS AVE Worship Facility 90,100 873.8 104505.51 407.9 465.9 873.8 84.7 0.0 0.0   1.0 146.3
161227 161227 2019 3111333 Manhattan Beach Jewish Center BROOKLYN 60 West End Avenue Worship Facility 107,000 487.0 48990.83 326.5 160.5 487.0 84.7 0.0 0.0   38.0 75.2
161296 161296 2019 3113515 Assembly Hall of Jehovah's Witnesses, Inc. BROOKLYN 973 Flatbush Avenue Worship Facility 98,300 283.6 31149.41 81.2 202.4 283.6 84.7 0.0 0.0   29.0 39.9
161351 161351 2019 3114643 St. Pauls Chapel MANHATTAN 1160 Amsterdam Ave Worship Facility 20,035 0.0 0.0 0.0 0.0 0.0 79.5 0.0 0.0   0.0 0.0
161577 161577 2019 3121128 Christ Church Methodist MANHATTAN 524 Park Avenue Worship Facility 68,559 295.3 46743.82 0.0 295.3 295.3 84.7 0.0 0.0   29.0 57.7
161783 161783 2019 3136028 Saint Thomas Church MANHATTAN 1 West 53rd Street Worship Facility 64,937 327.2 55030.44 11.3 316.0 327.2 84.7 0.0 0.0   26.0 70.7
161802 161802 2019 3173308 Tabernacle 165-11 Jamaica Ave. QUEENS 165-11 Jamaica Ave. Worship Facility 60,986 169.6 30425.96 130.8 38.8 169.6 84.7 0.0 0.0   48.0 47.9
161913 161913 2019 3268613 Hanson Place Central UMC BROOKLYN 144 St. Felix Street Worship Facility 60,000 18.1 3247.11 0.0 18.1 18.1 79.5 0.0 0.0   100.0 3.8
161933 161933 2019 3298499 Brooklyn Tabernacle BROOKLYN 392 Fulton St. Worship Facility 130,000 765.2 63357.97 201.8 563.4 765.2 84.7 0.0 0.0   8.0 80.4
162735 162735 2019 3570265 St. Bartholomew's Church MANHATTAN 109 E 50th St. Worship Facility 133,080 837.9 67812.57 58.0 779.8 837.9 84.7 0.0 0.0   9.0 95.6
162796 162796 2019 3667918 Rego Park Jewish Center QUEENS 97-30 Queens Blvd. Worship Facility 68,516 222.8 35267.6 162.7 60.1 222.8 84.7 0.0 0.0   69.0 43.8
162803 162803 2019 3760844 89-00 23rd Avenue QUEENS 89-00 23rd Avenue Worship Facility 92,403 143.9 16836.14 62.9 81.0 143.9 84.7 0.0 0.0   72.0 23.2
162861 162861 2019 3884400 Highland Church, Attn;JOHN ZENGOTITA   160-20 Highland aveune Worship Facility 69,522 127.7 19921.01 68.2 59.5 127.7 79.5 0.0 0.0   75.0 29.2
163603 163603 2019 4046917 HSA: 4 West 43rd Street MANHATTAN 4 West 43rd Street Worship Facility 77,648 119.0 16635.12 119.0 0.0 119.0 84.7 0.0 0.0   83.0 28.8
164887 164887 2019 4423363 Lafayette Ave Presbyterian Church 77 South Oxford BROOKLYN 77 South Oxford St Worship Facility 66,820 186.3 30383.55 140.8 45.5 186.3 84.7 0.0 0.0   57.0 47.7
165020 165020 2019 4494771 305 East 21st Street BROOKLYN 305 East 21 St Worship Facility 64,064 193.9 32611.25 147.7 46.2 193.9 84.7 0.0 0.0   60.0 51.9
166245 166245 2019 4992977 Rocklyn: 7200 Douglaston of Brooklyn ICC QUEENS 72-45 Douglaston Parkway Worship Facility 287,295 989.4 37107.33 593.8 395.6 989.4 84.7 0.0 0.0   0.0 55.2
166333 166333 2019 5038333 SEPHARDIC COMMUNITY: 1901 OCEAN PARKWAY BROOKLYN 1901 OCEAN PARKWAY Worship Facility 88,338 1352.4 165421.57 787.5 565.0 1352.4 84.7 0.0 0.0   1.0 243.3
166376 166376 2019 5045100 Chabad 509 MANHATTAN 509 5th Ave Worship Facility 55,474 99.1 19394.59 0.0 99.1 99.1 84.7 0.0 0.0   67.0 21.1
166992 166992 2019 5852996 39-53 East 83rd Street MANHATTAN 39-53 East 83rd Street Worship Facility 150,000 356.8 25603.73 54.8 302.0 356.8 84.7 0.0 0.0   57.0 30.6
167058 167058 2019 5858537 701 Ft Washington Avenue MANHATTAN 701 Ft Washington Avenue Worship Facility 110,000 869.1 85044.6 449.5 419.7 869.1 84.7 0.0 0.0   2.0 100.4
167152 167152 2019 5865116 0034 - Our Lady of Pompeii Church MANHATTAN 25 Carmine Street Worship Facility 76,888 329.1 46610.52 277.2 52.0 329.1 84.7 0.0 0.0   50.0 75.9
167153 167153 2019 5865116 0034 - Our Lady of Pompeii Church MANHATTAN 25 Carmine Street Worship Facility 76,888 329.1 46610.52 277.2 52.0 329.1 84.7 0.0 0.0   49.0 75.9
167463 167463 2019 5983675 Energy Plus NY: 401 Park Ave BROOKLYN 401 Park Ave Worship Facility 62,991 106.7 18524.32 52.0 54.7 106.7 84.7 0.0 0.0   68.0 25.8
167612 167612 2019 6097774 KDS: 130-30 31st Ave QUEENS 130-30 31st Ave Worship Facility 141,697 699.4 53392.0 263.9 435.5 699.4 84.7 0.0 0.0   7.0 71.4
167613 167613 2019 6098048 The Jewish Center MANHATTAN 131 West 86th Street Worship Facility 47,200 260.7 59705.29 153.3 107.4 260.7 79.5 0.0 0.0   29.0 72.1
167729 167729 2019 6159979 QCAC QUEENS 13516 35th Ave Worship Facility 29,700 57.8 21453.57 28.9 28.9 57.8 84.7 0.0 0.0   78.0 29.8
168094 168094 2019 6202484 St John the Baptist Parish BROOKLYN 333 Hart St Worship Facility 29,184 160.8 59683.97 100.2 60.6 160.8 84.7 0.0 0.0   15.0 89.2
168130 168130 2019 6212030 Calvary Assembly of God QUEENS 102-05 Rockaway Blvd Worship Facility 35,400 59.0 18144.86 27.4 31.7 59.0 84.7 0.0 0.0   76.0 25.1
168484 168484 2019 6236782 The Unity Center of New York City MANHATTAN 213 W 58th Street Worship Facility 29,890 42.7 15848.91 26.6 16.0 42.7 84.7 0.0 0.0   82.0 23.1
168501 168501 2019 6237931 Congregation Rodeph Sholom MANHATTAN 7 West 83rd street Worship Facility 47,140 291.7 66804.89 235.4 56.3 291.7 84.7 0.0 0.0   23.0 108.1
168534 168534 2019 6242524 Young Israel of Bedford Bay, Inc. BROOKLYN 2114 Brown Street Worship Facility 27,610 167.4 66736.18 114.1 53.3 167.4 84.7 0.0 0.0   9.0 93.1
168746 168746 2019 6261009 Shellbank Jewish Center - 2121 Bragg Street BROOKLYN 2121 BRAGG ST Worship Facility 25,100 90.5 38965.32 40.7 49.7 90.5 84.7 0.0 0.0   25.0 54.0
168758 168758 2019 6261068 1531 48th Street BROOKLYN 1533 48 ST Worship Facility 31,000 210.6 73125.08 95.2 115.5 210.6 84.7 0.0 0.0   9.0 101.8
168783 168783 2019 6262278 Young Israel of Hillcrest QUEENS 169-07 Jewel Avenue Worship Facility 25,200 59.8 25747.25 26.2 33.6 59.8 84.7 0.0 0.0   71.0 35.3
168950 168950 2019 6271000 Temple Israel of The City of New York MANHATTAN 112 East 75th street Worship Facility 37,000 157.9 45935.67 2.2 155.7 157.9 84.7 0.0 0.0   17.0 50.8
169092 169092 2019 6275344 Tabernacle of Prayer For All People QUEENS 165-11 Jamaica Avenue Worship Facility 54,210 169.6 33806.62 130.8 38.8 169.6 84.7 0.0 0.0   30.0 53.9
169871 169871 2019 6284172 Fifth Avenue Presbyterian Church MANHATTAN 7 West 55th Street Worship Facility 45,315 293.8 70276.31 4.5 289.3 293.8 84.7 0.0 0.0   3.0 85.6
169947 169947 2019 6287890 443 East 115th Street MANHATTAN 443 East 115th Street Worship Facility 334,463 343.2 11060.39 115.2 228.0 343.2 79.5 0.0 0.0   83.0 15.1
169993 169993 2019 6289224 THE UNIVERSAL CHURCH-1091 FULTON STREET BROOKLYN 1091 FULTON STREET Worship Facility 38,400 166.1 47049.57 107.3 58.9 166.1 79.5 0.0 0.0   19.0 71.9
170007 170007 2019 6289440 THE UNIVERSAL CHURCH-490 EAST 138 STREET BRONX 490 EAST 138 STREET Worship Facility 25,811 135.7 58426.45 111.3 24.4 135.7 79.5 0.0 0.0   20.0 93.1
170012 170012 2019 6289481 0310 - Church of the Sacred Heart STATEN IS 981 Castleton Ave. Worship Facility 26,000 123.7 51211.32 104.7 18.9 123.7 84.7 0.0 0.0   17.0 84.4
170065 170065 2019 6290934 THE UNIVERSAL CHURCH-47 4TH AVENUE BROOKLYN 47 4TH AVENUE Worship Facility 31,500 136.0 47222.27 30.2 105.9 136.0 79.5 0.0 0.0   13.0 60.3
171420 171420 2019 6306108 Greenwood Baptist Church BROOKLYN 461 Sixth Street Worship Facility 28,125 125.8 48360.66 120.9 4.9 125.8 84.7 0.0 0.0   46.0 62.0
171520 171520 2019 6310446 St. Matthew and St. Timothy MANHATTAN 26 W 84th St Worship Facility 28,741 142.3 54703.68 100.4 41.9 142.3 84.7 0.0 0.0   20.0 83.0
171627 171627 2019 6312314 New Life Fellowship QUEENS 82-10 Queens Blvd Worship Facility 53,500 329.2 66858.04 272.0 57.2 329.2 84.7 0.0 0.0   28.0 80.2
171746 171746 2019 6316150 Chung Te Buddhist Association of NY MANHATTAN 152 Henry Street Worship Facility 37,565 88.3 25687.9 41.5 46.8 88.3 84.7 0.0 0.0   47.0 35.5
171803 171803 2019 6321238 0017 - Church of the Incarnation MANHATTAN 1294 St. Nicholas Avenue Worship Facility 69,920 349.2 54474.69 286.8 62.4 349.2 84.7 0.0 0.0   0.0 87.8
171804 171804 2019 6321238 0017 - Church of the Incarnation MANHATTAN 1294 St. Nicholas Avenue Worship Facility 69,920 349.2 54474.69 286.8 62.4 349.2 84.7 0.0 0.0   0.0 87.8
171921 171921 2019 6348044 NEW COVENANT FAITH & MIRACLE ARENA, INC BRONX 1175 BOSTON ROAD Worship Facility 26,650 124.3 51459.72 84.4 39.9 124.3 84.7 0.0 0.0   20.0 77.3
171928 171928 2019 6351949 526 59th Street BROOKLYN 5901 6th Avenue Worship Facility 353,342 936.9 28568.55 936.9 0.0 936.9 84.7 0.0 0.0   76.0 35.9
172025 172025 2019 6366805 0031 - Our Lady MT Carmel (SEE NOTES) MANHATTAN 448 E 116 Street Worship Facility 334,463 12.9 415.73 0.4 12.5 12.9 79.5 0.0 0.0   0.0 0.5
172027 172027 2019 6368186 0059 - RC St. Charles Borromeo   211 Worship Facility 32,799 10.2 3430.99 3.6 6.6 10.2 84.7 0.0 0.0   99.0 4.4
172258 172258 2019 6400321 0280- St. Mary School BRONX 3960 Carpenter Avenue Worship Facility 34,355 39.9 12631.75 4.6 35.3 39.9 84.7 0.0 0.0   80.0 14.6
172435 172435 2019 6422908 0093 - All Saints Church MANHATTAN 47 East 129th Street Worship Facility 55,300 23.3 4559.98 8.1 15.2 23.3 84.7 0.0 0.0   0.0 6.0
172510 172510 2019 6437822 Temple Beth El of Manhattan Beach Brooklyn, N.Y. 11235 BROOKLYN 111 West End Ave Worship Facility 45,400 167.1 39969.95 72.0 95.1 167.1 84.7 0.0 0.0   35.0 54.6
172803 172803 2019 6553924 38-20 Parson Boulevard   38-20 Parson Boulevard Worship Facility 34,560 68.7 21749.41 39.8 28.8 68.7 84.7 0.0 0.0   70.0 31.5
172957 172957 2019 6573452 Stephen Wise Free Synagogue MANHATTAN 30 West 68 Street Worship Facility 33,357 227.8 74303.53 148.8 79.0 227.8 84.7 0.0 0.0   18.0 112.0
172999 172999 2019 6579171 0213-Our Lady of Mount Carmel - Church and Rectory BRONX 627 East 187th Street Worship Facility 29,720 158.8 58941.63 139.9 18.8 158.8 79.5 0.0 0.0   40.0 72.5
173010 173010 2019 6579351 Church Of St Clare - 110 Nelson ave STATEN IS 110 Nelson ave Worship Facility 55,000 48.0 9393.95 20.3 27.6 48.0 84.7 0.0 0.0   0.0 12.9
173033 173033 2019 6580934 0011 - Church of the Holy Family MANHATTAN 315 East 47th Street Worship Facility 30,317 155.3 55721.12 87.1 68.3 155.3 84.7 0.0 0.0   18.0 80.6
173053 173053 2019 6582576 Holy Child Church - 4747 Amboy Road STATEN IS 4747 Amboy Road Worship Facility 26,800 243.6 100849.46 144.3 99.3 243.6 84.7 0.0 0.0   0.0 145.1
173289 173289 2019 6601379 0248 - St Margaret Cortona Church and Rectory BRONX 6010 - 6024 Riverdale Ave Worship Facility 31,463 331.5 115104.29 275.5 56.0 331.5 79.5 0.0 0.0   0.0 142.1
173335 173335 2019 6604155 0258 - St. Raymond Mgr Church and Elementary   2380 East Tremont Worship Facility 115,156 619.9 58022.1 619.9 0.0 619.9 79.5 0.0 0.0   56.0 77.3
173403 173403 2019 6616793 Cathedral of Joy Christian Center BROOKLYN 31 George Street Worship Facility 25,000 27.8 11969.46 18.3 9.5 27.8 84.7 0.0 0.0   80.0 18.3
173448 173448 2019 6621685 Orthodox Cathedral of the Holy Virgin Protection MANHATTAN 59 East 2nd Street Worship Facility 26,282 103.4 42807.2 95.9 7.5 103.4 79.5 0.0 0.0   45.0 53.3
173542 173542 2019 6629459 IMMACULATE CONCEPTION ACADEMY QUEENS 179-14 Dalny Rd Worship Facility 34,644 159.7 50558.67 121.8 37.9 159.7 84.7 0.0 0.0   14.0 79.1
173543 173543 2019 6629460 Immaculate Conception Church: 86-45 Edgerton Blvd QUEENS 86-45 Edgerton Blvd Worship Facility 231,701 298.4 13904.54 272.5 25.9 298.4 84.7 0.0 0.0   93.0 17.3
173545 173545 2019 6629462 Rocklyn: 2602 E 19th St BROOKLYN 2602 E 19th St Worship Facility 42,763 54.2 13890.56 0.0 54.2 54.2 84.7 0.0 0.0   68.0 15.0
173546 173546 2019 6629463 Rocklyn: 16-1 150th Pl QUEENS 16-1 150th Pl Worship Facility 47,187 198.0 45345.79 125.7 72.4 198.0 84.7 0.0 0.0   17.0 68.2
173547 173547 2019 6629464 Rocklyn: 129 E 4th St BROOKLYN 129 E 4th St Worship Facility 50,161 116.0 24972.25 96.2 19.9 116.0 84.7 0.0 0.0   59.0 40.8
173548 173548 2019 6629465 Rocklyn: 6120 Bay Pkwy BROOKLYN 6120 Bay Pkwy Worship Facility 30,073 175.4 62932.94 109.6 65.7 175.4 84.7 0.0 0.0   10.0 74.9
173552 173552 2019 6629469 Rocklyn: 2245 Kimball St BROOKLYN 2245 Kimball St Worship Facility 33,009 127.7 41653.03 83.7 44.0 127.7 84.7 0.0 0.0   62.0 63.5
173556 173556 2019 6629473 Rocklyn: 309 Central Ave BROOKLYN 309 Central Ave Worship Facility 40,360 92.4 24864.61 80.2 12.2 92.4 84.7 0.0 0.0   76.0 30.3
173558 173558 2019 6629475 Rocklyn: 11 Catherine St BROOKLYN 11 Catherine St Worship Facility 34,668 88.3 27954.48 57.1 31.3 88.3 84.7 0.0 0.0   47.0 41.6
173559 173559 2019 6629476 Rocklyn: 46-14 Parsons Blvd QUEENS 46-14 Parsons Blvd Worship Facility 29,831 109.3 40568.77 88.8 20.5 109.3 84.7 0.0 0.0   30.0 64.1
173561 173561 2019 6629478 Rocklyn: 45-21 194th St QUEENS 45-21 194th St Worship Facility 27,713 143.2 57088.54 118.1 25.2 143.2 84.7 0.0 0.0   0.0 69.8
173563 173563 2019 6629480 Rocklyn: 39-56 56th St QUEENS 39-56 56th St Worship Facility 41,088 312.1 81936.91 210.8 101.3 312.1 84.7 0.0 0.0   2.0 125.7
173729 173729 2019 6649689 1227 Webster Avenue BRONX 1227 Webster Avenue Worship Facility 34,742 79.7 25231.85 24.0 55.8 79.7 84.7 0.0 0.0   68.0 31.9
173992 173992 2019 6664935 Rocklyn: 306 Vanderbilt BROOKLYN 300 Vanderbilt Ave Worship Facility 88,810 210.5 25747.74 187.2 23.2 210.5 84.7 0.0 0.0   0.0 34.6
174080 174080 2019 6668501 Bobover Yeshiva Bnei Zion - 4206-10 15th Avenue BROOKLYN 4208 15TH AVE Worship Facility 25,500 131.8 56747.28 41.0 90.8 131.8 84.7 0.0 0.0   18.0 72.3
174119 174119 2019 6669837 200 Boscombe Avenue STATEN IS 200 Boscombe Avenue Worship Facility 75,000 166.9 23953.27 140.8 26.1 166.9 84.7 219.2 0.0   67.0 60.1
174189 174189 2019 6671717 Rocklyn: 52-29 83rd St QUEENS 5217 83 ST Worship Facility 156,044 0.0 0.0 0.0 39.7 0.0 84.7 0.0 0.0   0.0 0.0
174190 174190 2019 6671718 Rocklyn: 130 Montrose Ave BROOKLYN 140 Montrose Ave Worship Facility 113,405 41.9 3991.22 13.7 28.2 41.9 84.7 0.0 0.0   100.0 5.2
174220 174220 2019 6672401 110-39 Springfield Boulevard QUEENS 110-39 Springfield Boulevard Worship Facility 63,986 302.6 51700.89 246.5 56.1 302.6 84.7 0.0 0.0   25.0 82.9
174221 174221 2019 6672401 110-39 Springfield Boulevard QUEENS 110-39 Springfield Boulevard Worship Facility 63,986 302.6 51700.89 246.5 56.1 302.6 84.7 0.0 0.0   25.0 82.9
174233 174233 2019 6672788 Cong Yeshiva Shearith BROOKLYN 1420 50 ST Worship Facility 26,413 297.4 123122.46 173.7 123.7 297.4 84.7 0.0 0.0   3.0 179.1
174823 174823 2019 6687109 Bukharian Jewish Community Center Inc QUEENS 10616 70 Ave Worship Facility 36,000 190.6 56988.87 63.6 127.1 190.6 84.7 0.0 0.0   26.0 74.9
175030 175030 2019 6690978 Rocklyn: 5724 13th Ave BROOKLYN 5724 13th Ave Worship Facility 30,334 101.9 36561.38 89.3 12.6 101.9 84.7 0.0 0.0   38.0 60.3
175032 175032 2019 6690980 Rocklyn: 1677 Canarsie Rd BROOKLYN 1677 Canarsie Rd Worship Facility 37,642 66.9 19462.29 41.6 25.2 66.9 84.7 0.0 0.0   65.0 28.7
175033 175033 2019 6690981 Rocklyn: 433 Sackett St BROOKLYN 433 Sackett St Worship Facility 35,015 17.4 5351.2 0.0 17.4 17.4 84.7 0.0 0.0   96.0 5.9
175342 175342 2019 6696101 0202-Holy Cross Church BRONX 1845 Randall Ave Worship Facility 43,931 0.0 0.0 0.0 21.3 0.0 84.7 0.0 0.0   0.0 0.0
175400 175400 2019 6696672 French Speaking Baptist Church BROOKLYN 209 CLERMONT AVE. Worship Facility 41,000 98.5 25859.61 80.8 17.7 98.5 84.7 0.0 0.0   59.0 42.2
175684 175684 2019 6700194 Flatbush Tompkins BROOKLYN 424 East 19th Street Worship Facility 39,600 144.3 39826.43 134.6 9.7 144.3 79.5 0.0 0.0   43.0 67.1
175838 175838 2019 6701068 2810 Nostrand Avenue BROOKLYN 2810 Nostrand Avenue Worship Facility 44,550 419.4 102599.54 267.5 151.9 419.4 84.7 0.0 0.0   2.0 153.3
175839 175839 2019 6701068 2810 Nostrand Avenue BROOKLYN 2810 Nostrand Avenue Worship Facility 44,550 419.4 102599.54 267.5 151.9 419.4 84.7 0.0 0.0   2.0 153.3
175860 175860 2019 6701696 0043 - Sacred Heart   451 West 51 Worship Facility 66,362 89.6 14612.81 48.6 41.0 89.6 84.7 0.0 0.0   0.0 21.1
175954 175954 2019 6702330 Antioch Baptist Church BROOKLYN 828 Greene Avenue Worship Facility 27,075 79.5 31693.71 67.5 11.9 79.5 84.7 0.0 0.0   65.0 52.2
176257 176257 2019 6735578 0058 - St Cecilia Church MANHATTAN 120 East 106th Street Worship Facility 46,890 97.2 22744.59 77.5 19.7 97.2 84.7 0.0 0.0   73.0 30.0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE ghg(
  "Calendar Year" INT,
  "Property ID" TEXT,
  "Property Name" TEXT,
  Borough TEXT,
  "Address 1" TEXT,
  "Property Type" TEXT,
  "Floor Area (ft2)" TEXT,
  "Total GHG (MtCO2e)" REAL,
  "GHGI (kgCO2e/m2)",
  "Direct GHG (MtCO2e)" REAL,
  "Indirect GHG (MtCO2e)" REAL,
  "Net GHG (MtCO2e)" REAL,
  "Grid Emissions Rate (kgCO2e/MBtu)" REAL,
  "Avoided GHG Onsite (MtCO2e)" REAL,
  "Avoided GHG Offsite (MtCO2e)" REAL,
  "National Median GHG (MtCO2e)" REAL,
  "ENERGY STAR Score" REAL,
  "Site EUI (kBtu/ft2)" REAL
);
CREATE INDEX "idx_ghg_Calendar Year" ON [ghg] ("Calendar Year");
CREATE INDEX "idx_ghg_Property ID" ON [ghg] ("Property ID");
CREATE INDEX "idx_ghg_Borough" ON [ghg] ("Borough");
CREATE INDEX "idx_ghg_Property Type" ON [ghg] ("Property Type");
Powered by Datasette · Queries took 3323.947ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability