Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Energy and Water Data Disclosure for Local Law 84 2011 (Data for Calendar Year 2010)

kswi-37bpEnvironment164 columns
Data and metrics on water and energy consumption in privately owned buildings over 25,000 ft2 and in City-owned buildings over 10,000 ft2.
View on NYC Open Data↗

Quality

D63.7 / 100

From a 500-row sample across 126 columns.

completeness43/ 25% weight
consistency56/ 20% weight
accuracy94/ 20% weight
timeliness33/ 15% weight
usability90/ 20% weight
  • · Very wide (126 columns) — hard to consume directly
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Energy and Water Data Disclosure for Local Law 84 2012 (Data for Calendar Year 2011)0.87
    joins onaddress_1supermarkets_grocery_workerscouncil_district+150

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

building_idfacility_nameperiod_ending_dateratingaddress_1address_2citystatepostcodecountytotal_floor_space_sq_ftfacility_type
2602938103 East 125th Street Realty Corp.2010-12-31T00:00:00.000811825 Park AvenueSuite 1107New YorkNew York10035NEW YORK117000Office
2552010

Columns

164 queryable · 164 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
building_idinteger—0%263093525925272631034
facility_nametext—0%Sample Facility621 Lefferts Avenue145 Lincoln Road
period_ending_datedatetime—0%2010-12-31T00:00:00.000of 1
ratinginteger—3%0571
address_1text—

Query this from your own app

GET /api/datasets/kswi-37bp
GET /api/datasets/kswi-37bp/quality
GET /api/datasets/kswi-37bp/related
GET /api/columns?dataset=kswi-37bp
  • Energy and Water Data Disclosure for Local Law 84 2013 (Data for Calendar Year 2012)0.77
    joins onaddress_1council_districtborough+29
  • Energy and Water Data Disclosure for Local Law 84 2016 (Data for Calendar Year 2015)0.75
    joins onaddress_1council_districtborough+26
  • Energy and Water Data Disclosure for Local Law 84 2014 (Data for Calendar Year 2013)0.75
    joins onaddress_1council_districtborough+24
  • Energy and Water Data Disclosure for Local Law 84 2017 (Data for Calendar Year 2016)0.75
    joins onaddress_1council_districtborough+26
  • Energy and Water Data Disclosure for Local Law 84 2015 (Data for Calendar Year 2014)0.75
    joins onaddress_1council_districtborough+26
  • Energy and Water Data Disclosure for Local Law 84 2019 (Data for Calendar Year 2018)0.74
    joins onaddress_1council_districtborough+26
  • Energy and Water Data Disclosure for Local Law 84 2020 (Data for Calendar Year 2019)0.72
    joins onaddress_1council_districtborough+25
    • Watson Boulevard
    2010-12-31T00:00:00.000
    0
    1265 Gerard Avenue
    —
    Bronx
    New York
    10452
    BRONX
    67724
    Multifamily Housing
    2552023420 W. 206th St. Owners Corp2010-12-31T00:00:00.0000420 West 206th Street—New YorkNew York10034NEW YORK77967Multifamily Housing
    2550379930 St. Nicholas Owners Corp.2010-12-31T00:00:00.0000930 Saint Nicholas Avenue—New YorkNew York10032NEW YORK52542Multifamily Housing
    2552028Bronxwood Towers, Inc2010-12-31T00:00:00.0000855 East 233rd Street—BronxNew York10466BRONX120534Multifamily Housing
    2551968Jerome Avenue2010-12-31T00:00:00.0000941 Jerome Ave—BronxNew York10452BRONX114941Multifamily Housing
    2551979Kingsbridge Arms, Inc2010-12-31T00:00:00.00002865 Kingsbridge Terrace—BronxNew York10468BRONX111300Multifamily Housing
    2551614Sherman Terrace Cooperative, Inc.2010-12-31T00:00:00.00001010 Sherman Avenue—BronxNew York10456BRONX80009Multifamily Housing
    25519821235 Concourse Tenants Corp2010-12-31T00:00:00.00001235 Grand Concourse—BronxNew York10452BRONX181700Multifamily Housing
    2681985Yellow Brick Loft2010-12-31T00:00:00.00001916-1938 Park Avenue—New YorkNew York10037NEW YORK124500Office

    Showing 12 of 70 columns. All of them are listed below.

    1%
    8000 Utopia Parkway1919 Williamsbridge Road525 East 68th Street
    address_2text—99%Multiple Addresses-S508 East 78th Street317 Avenue C
    citytext—0%New YorkBrooklynBronx
    statecategorical—0%New YorkVirginiaNew Jerseyof 16
    postcodeinteger—0%100221001610025
    countytext—1%NEW YORKQUEENSKINGS
    total_floor_space_sq_ftinteger—3%0150004000
    facility_typetext—1%Multifamily HousingOfficeOther
    last_modified_datedatetime—1%2011-07-28T00:00:00.0002011-07-27T00:00:00.0002011-07-29T00:00:00.000
    building_profile_statuscategorical—100%Reviewed and ApprovedDraftApproved for Web Manager…of 4
    eligibility_for_energy_starcategorical—0%Not Eligible: Rating mus…Not Eligible: Current pe…Eligibleof 9
    energy_star_application_statustext—0%No Status AvailableApplication - Label Sent…Application - Label Sent…
    year_s_labeledtext—99%20102009, 20102009
    current_rating_1_100integer—0%0571
    target_rating_1_100categorical—9%07585of 15
    current_direct_ghg_emissionsfloat—22%10.204.264.00
    current_indirect_ghg_emissionsfloat—12%3.7791.6491.72
    current_total_ghg_emissionsfloat—11%3.7710.2091.64
    current_energy_period_endingdatetime—0%2010-12-31T00:00:00.0002010-11-30T00:00:00.0002011-01-31T00:00:00.000
    current_water_period_endingdatetime—0%2200-01-01T00:00:00.0002010-12-31T00:00:00.0002010-11-30T00:00:00.000
    current_total_on_sitecoordinate—100%153125.00199945.8856733.75of 3
    percent_of_electricity_fromcoordinate—100%38.6414.57of 2
    total_avoided_ghg_emissionscoordinate—100%484.17171.457911.02of 13
    total_on_site_electriccoordinate—100%325592.00of 1
    total_green_power_purchasedcoordinate—100%0.681019.0011191.78of 15
    current_site_energy_intensityfloat—9%0.040.910.1
    current_total_site_energyfloat—9%40203.6138690.5612907.8
    national_average_site_euifloat—76%104.077.00.0
    target_site_energy_intensityfloat—9%0.068.770.4
    weather_normalized_site_euifloat—9%0.040.810.5
    electricity_use_kbtufloat—9%0.0040203.60612907.80
    electricity_use_kwhfloat—9%0.011783.0179633.0
    natural_gas_use_kbtufloat—34%80000.000.0075200.00
    natural_gas_use_thermsfloat—34%800.0752.06904.0
    district_steam_use_kbtufloat—91%3232499.488652726.9614212211.27
    fuel_oil_2_use_kbtufloat—91%0.00138690.5055476.20
    fuel_oil_4_use_kbtufloat—92%138690.500.004790924.63
    fuel_oil_56_use_kbtufloat—75%0.001821284.311794489.71
    diesel_2_use_kbtucoordinate—100%0.0010697.34115251.81of 18
    difference_from_nationalfloat—78%0.0-8.11.0
    current_source_energyfloat—9%0.033.6136.5
    current_total_source_energyfloat—9%134280.0140077.42047112.0
    current_weather_normalizedfloat—9%0.035.2136.3
    national_average_source_euifloat—76%213.0182.00.0
    bank_financial_institutioninteger—98%300050008000
    bank_financial_institution_1categorical—98%100.0025.0096.78of 6
    bank_financial_institution_2float—98%2.203.193.33
    bank_financial_institution_3integer—98%654060
    bank_financial_institution_4float—98%2.300.002.50
    bank_financial_institution_5integer—98%10129
    hospital_gross_floor_areatext—99%187635873000230000
    hospital_laboratory_y_1_ncoordinate—99%0.001.00of 2
    hospital_laundry_facilitycoordinate—99%0.001.00of 2
    hospital_maximum_number_ofcategorical—99%5146of 16
    hospital_number_of_buildingscategorical—100%1214of 9
    hospital_number_of_licensedtext—99%0312606
    hotel_gross_floor_area_sqinteger—98%17500015000075000
    hotel_number_of_roomsinteger—98%226139128
    hotel_onsite_laundry_shortcategorical—99%No laundry facilityBoth linens and terryTerry only (e.g., towels…of 4
    hotel_percent_cooledcategorical—98%100.0090.0080.00of 8
    hotel_presence_of_cookingcategorical—98%10of 2
    house_of_worship_gross_floortext—100%15001041199300
    house_of_worship_pc_densitycategorical—100%012of 3
    house_of_worship_presencecategorical—100%33040of 17
    house_of_worship_weeklycategorical—100%01633of 9
    k_12_school_gross_floor_areainteger—99%1020006500078000
    k_12_school_high_school_ycategorical—99%0.001.00of 2
    k_12_school_open_weekendscategorical—99%0.001.00of 2
    k_12_school_pc_densityfloat—99%1.750.820.78
    k_12_school_percent_cooledcategorical—99%1009050of 11
    k_12_school_walk_in_refrigcategorical—99%0.010.000.02of 14
    k_12_school_presence_ofcategorical—99%0124of 3
    medical_office_gross_floorinteger—95%100050002000
    medical_office_number_ofinteger—95%243
    medical_office_percent_cooledfloat—95%100.0090.0080.00
    medical_office_weeklyinteger—95%654050
    multifamily_home_gross_floorinteger—27%4000600037824
    multifamily_home_dishwashersinteger—44%0.0020.0060.00
    multifamily_home_laundryinteger—44%0.004.006.00
    multifamily_home_laundry_1integer—44%0.005.0010.00
    multifamily_home_market_ratecategorical—48%Market RateBoth Affordable and Mark…Affordable Housingof 4
    multifamily_home_number_ofinteger—41%670
    multifamily_home_number_of_1integer—40%06048
    multifamily_home_percentfloat—44%0.00100.0090.00
    multifamily_home_percent_1float—45%15.0010.005.00
    multifamily_home_total_numberinteger—44%0.00120.004.00
    office_gross_floor_area_sqinteger—80%1500010003000
    office_office_air_conditionedfloat—80%100.0025.000.00
    office_pc_densityfloat—80%2.202.130.00
    office_weekly_operating_hoursinteger—80%655540
    office_workers_densityfloat—80%2.302.330.00
    other_space_type_nametext—86%OtherRetail (Misc)Restaurant/Cafeteria
    other_gross_floor_area_sqinteger—86%200030001500
    other_number_of_pcsinteger—94%012
    other_weekly_operating_hoursinteger—93%4065168
    other_workers_on_main_shiftinteger—94%042
    parking_enclosed_floor_areainteger—89%0500010000
    parking_gross_floor_areainteger—89%5000200005280
    parking_non_enclosed_floorinteger—89%0600010000
    parking_open_floor_area_winteger—89%0100005000
    parking_weekly_hours_of_accessinteger—89%16811224
    residence_halls_dormitoriestext—99%590006000090000
    residence_halls_dormitories_1coordinate—99%100.0080.0090.00of 14
    residence_halls_dormitories_2coordinate—99%0.001.00of 2
    residence_halls_dormitories_3coordinate—99%0.001.000.65of 4
    residence_halls_dormitories_4text—99%10020050
    retail_gross_floor_area_sqinteger—84%5000100006000
    retail_cash_register_densityfloat—84%0.300.000.40
    retail_exterior_entrancecategorical—84%10of 2
    retail_workers_densityfloat—84%1.000.001.33
    retail_weekly_operating_hoursinteger—84%656070
    retail_walk_in_refrig_densityfloat—84%0.000.070.14
    retail_percent_cooledfloat—84%100.000.0080.00
    retail_pc_densityfloat—84%0.200.000.10
    retail_open_closed_refrigfloat—84%0.000.200.13
    retail_number_of_walk_incategorical—84%012of 17
    retail_number_of_open_orinteger—84%012
    supermarkets_grocery_grossinteger—98%60010005000
    supermarkets_grocery_numbertext—99%014
    supermarkets_grocery_number_1integer—99%124
    supermarkets_grocery_number_2categorical—98%012of 18
    supermarkets_grocery_percentcategorical—98%100.0090.0080.00of 14
    supermarkets_grocery_presencecategorical—98%1.000.000.89of 3
    supermarkets_grocery_walkfloat—98%0.250.000.19
    supermarkets_grocery_weeklyinteger—98%105168126
    supermarkets_grocery_workersfloat—98%1.001.671.60
    swimming_pool_sizecategorical—100%Recreational (20 yards x…Short Course (25 yards x…Olympic (50 meters x 25 …of 6
    swimming_pool_indoor_outdoorcategorical—100%IndoorOutdoorIndoor, Outdoorof 3
    swimming_pool_months_in_usecategorical—100%1203of 4
    warehouse_refrigerated_grosscategorical—100%14870016553426511of 13
    warehouse_refrigerated_weeklycategorical—100%10016845of 10
    warehouse_unrefrigeratedcategorical—99%100.000.0050.00of 13
    warehouse_refrigerated_workerstext—99%107000500074323
    warehouse_unrefrigerated_1categorical—98%01of 2
    warehouse_unrefrigerated_2float—98%100.0050.000.00
    warehouse_unrefrigerated_3float—98%0.0010.0020.00
    warehouse_unrefrigerated_4integer—98%0of 1
    warehouse_unrefrigerated_5integer—98%406050
    warehouse_unrefrigerated_6categorical—98%012of 7
    current_data_center_sourcetext—100%—
    current_site_pdu_input_energycoordinate—100%70740.02250000.0102032.0of 5
    current_site_ups_output_energycoordinate—100%638136.02016849.07545744.0of 17
    current_source_it_energycoordinate—100%22984172.67272248.885991902.3
    national_average_puecoordinate—98%1.92of 1
    data_center_gross_floor_areatext—98%60080020000
    data_center_annual_it_energytext—98%02298417385991902
    data_center_it_energycategorical—98%IT Energy is not current…Uninterruptible Power Su…UPS includes non-IT load…of 5
    indoor_water_use_kgalfloat—94%0.014757.3690.2
    indoor_water_use_per_sq_ftfloat—94%0.0015.3327.62
    total_indoor_and_outdoorfloat—94%0.03068.96647.7
    release_datedatetime—0%2011-06-09T11:45:13.0002011-07-21T17:19:11.0002011-07-29T09:51:40.000
    boroughcategorical—7%MANHATTANQUEENSBROOKLYNof 5
    latitudefloat—7%40.72560140.85279940.764149
    longitudefloat—7%-73.791694-73.853325-73.955251
    community_boardinteger—7%105108107
    council_districtinteger—7%436
    census_tractinteger—7%386545113
    bininteger—8%446248110000002048553
    bblinteger—8%302168750140702100012047120001
    ntatext—7%Midtown-Midtown SouthUpper East Side-Carnegie…Upper West Side