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 2015 (Data for Calendar Year 2014)

nbun-wekjEnvironment259 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

B84.0 / 100

From a 500-row sample across 259 columns.

completeness100/ 25% weight
consistency89/ 20% weight
accuracy91/ 20% weight
timeliness33/ 15% weight
usability90/ 20% weight
  • · Very wide (259 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 2016 (Data for Calendar Year 2015)0.91
    joins onindoor_water_use_all_waterhospital_general_medicalpercent_of_recs_retained+233

Geography

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

Open on the map →

Sample rows

property_idproperty_nameparent_property_idparent_property_nameyear_endingnyc_building_identificationnyc_borough_block_and_lotaddress_1address_2citycountypostcode
73651155Not Applicable: Standalone PropertyNot Applicable: Standalone Property2014-12-31T00:00:00.000102263110099700291155 Avenue of the AmericasNot AvailableManhattanNot Available

Columns

259 queryable · 259 profiled

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

FieldTypeDescriptionNullValues
property_idinteger—0%104535830912502684949
property_nametext—0%Kings Village CorpSample FacilityClub Quarters
parent_property_idtext—0%Not Applicable: Standalo…36126783616399
parent_property_nametext—0%Not Applicable: Standalo…Columbia University (mor…New York University: Was…

Query this from your own app

GET /api/datasets/nbun-wekj
GET /api/datasets/nbun-wekj/quality
GET /api/datasets/nbun-wekj/related
GET /api/columns?dataset=nbun-wekj
  • Energy and Water Data Disclosure for Local Law 84 2014 (Data for Calendar Year 2013)0.90
    joins onindoor_water_use_all_waterhospital_general_medicalpercent_of_recs_retained+221
  • Energy and Water Data Disclosure for Local Law 84 2017 (Data for Calendar Year 2016)0.87
    joins onindoor_water_use_all_waterhospital_general_medicalpercent_of_recs_retained+223
  • Energy and Water Data Disclosure for Local Law 84 2019 (Data for Calendar Year 2018)0.85
    joins onindoor_water_use_all_waterhospital_general_medicalpercent_of_recs_retained+204
  • Energy and Water Data Disclosure for Local Law 84 2018 (Data for Calendar Year 2017)0.83
    joins onindoor_water_use_all_waterhospital_general_medicalpercent_of_recs_retained+205
  • Energy and Water Data Disclosure for Local Law 84 2020 (Data for Calendar Year 2019)0.82
    joins onindoor_water_use_all_waterhospital_general_medicalpercent_of_recs_retained+193
  • Energy and Water Data Disclosure for Local Law 84 2013 (Data for Calendar Year 2012)0.78
    joins onindoor_water_use_all_waterhospital_general_medicaladdress_1+108
  • Energy and Water Data Disclosure for Local Law 84 2011 (Data for Calendar Year 2010)0.75
    joins onaddress_1parking_gross_floor_areak_12_school_gross_floor_area+26
    • 10036
    8139200Not Applicable: Standalone PropertyNot Applicable: Standalone Property2014-12-31T00:00:00.00010375451013150001200 East 42nd St.Not AvailableManhattanNot Available10017
    8604114Not Applicable: Standalone PropertyNot Applicable: Standalone Property2014-12-31T00:00:00.00010226671009990019114 West 47th stNot AvailableManhattanNot Available10036
    8841733Not Applicable: Standalone PropertyNot Applicable: Standalone Property2014-12-31T00:00:00.00010375961013190047733 Third AvenueNot AvailableManhattanNot Available10017
    11809Conde Nast BuildingNot Applicable: Standalone PropertyNot Applicable: Standalone Property2014-12-31T00:00:00.000108568210099500054 Times SquareNot AvailableManhattanNot Available10036
    13286201/205Not Applicable: Standalone PropertyNot Applicable: Standalone Property2014-12-31T00:00:00.0001037549; 10375501013160001201/205 East 42nd st.Not AvailableManhattanNot Available10017
    28400Columbia Presbyterian Medical CenterNot Applicable: Standalone PropertyNot Applicable: Standalone Property2014-12-31T00:00:00.0001084386100-02138-00040622 168th StreetNot AvailableNew York CityNot Available10032
    28402Weill Cornell Medical CenterNot Applicable: Standalone PropertyNot Applicable: Standalone Property2014-12-31T00:00:00.0001084781100-01480-00001525 East 68th StreetNot AvailableNew YorkNot Available10021
    28404The Allen HospitalNot Applicable: Standalone PropertyNot Applicable: Standalone Property2014-12-31T00:00:00.00010650451-02244-1005141 BroadwayNot AvailableNew YorkNot Available10034
    1025339425 Lexington AvenueNot Applicable: Standalone PropertyNot Applicable: Standalone Property2014-12-31T00:00:00.00010361621012980023425 Lexington AveNot AvailableNew YorkNot Available10017

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

    year_endingdatetime—0%2014-12-31T00:00:00.000of 1
    nyc_building_identificationtext—0%Not Available44394125106890
    nyc_borough_block_and_lottext—0%Not Available40702100011019730001
    address_1text—0%NA8000 Utopia Parkway1919 Williamsbridge Road
    address_2text—0%Not AvailableMultiple Addresses-See U…Default Info
    citytext—0%New YorkBrooklynBronx
    countytext—0%Not AvailableNew YorkQueens
    postcodetext—0%100011002211201
    primary_property_type_selftext—0%Multifamily HousingOfficeOther
    primary_property_type_epatext—0%Multifamily HousingOfficeHotel
    property_floor_area_buildingtext—0%600007000050000
    national_median_referencetext—0%Fannie Mae Industry Surv…CBECS - Office & Bank/Fi…CBECS - Other
    year_builtinteger—0%192719281929
    number_of_buildingstext—0%102
    occupancyinteger—0%1009095
    metered_areas_energytext—0%Whole BuildingNot AvailableCommon areas only
    energy_star_scoretext—0%Not Available1001
    national_median_energy_starinteger—0%50of 1
    energy_star_certificationtext—0%Not Available20142013
    energy_star_certification_1date—0%Not Available01/12/201511/29/2013
    energy_star_certification_2date—0%Not Available08/31/201507/31/2014
    energy_star_certification_3categorical—0%NoYesof 2
    energy_star_certification_4categorical—0%Not AvailableRevised Application Requ…of 2
    energy_star_certification_5categorical—0%NoYesof 2
    site_eui_kbtu_ftcoordinate—0%Not Available880
    weather_normalized_site_euicoordinate—0%Not Available92.376.2
    national_median_site_euicoordinate—0%59.6Not Available67.3
    difference_from_nationalcoordinate—0%Not Available-17-10.5
    site_energy_use_kbtucoordinate—0%Not Available01637760
    weather_normalized_site_energycoordinate—0%Not Available01637760
    national_median_site_energytext—0%Not Available724362.9648349.5
    weather_normalized_sitecoordinate—0%Not Available4.23.9
    weather_normalized_site_1coordinate—0%Not Available00.1
    source_eui_kbtu_ftcoordinate—0%Not Available0123
    weather_normalized_sourcecoordinate—0%Not Available138.10
    national_median_source_euicoordinate—0%127.9119.8123.1
    difference_from_national_1coordinate—0%Not Available-17-10.5
    source_energy_use_kbtucoordinate—0%Not Available05142566.5
    weather_normalized_source_1coordinate—0%Not Available05142566.5
    national_median_source_energycoordinate—0%Not Available1391240.81554351.8
    fuel_oil_1_use_kbtucoordinate—0%Not Available5258707.61946277.7of 9
    fuel_oil_2_use_kbtutext—0%Not Available0276000
    fuel_oil_4_use_kbtutext—0%Not Available0584000
    fuel_oil_5_6_use_kbtucoordinate—0%Not Available0749998.4
    diesel_2_use_kbtutext—0%Not Available0134274
    kerosene_use_kbtutext—0%Not Availableof 1
    propane_use_kbtutext—0%Not Availableof 1
    liquid_propane_use_kbtutext—0%Not Availableof 1
    district_steam_use_kbtucoordinate—0%Not Available010937422
    district_hot_water_use_kbtutext—0%Not Availableof 1
    district_chilled_water_usecoordinate—0%Not Available6374220.419185792.6
    natural_gas_use_kbtutext—0%Not Available01221286
    weather_normalized_site_2text—0%Not Available011920
    electricity_use_grid_purchasecoordinate—0%Not Available0169628.9
    weather_normalized_site_3text—0%Not Available049715.4
    electricity_use_grid_purchase_1text—0%Not Available0169628.9
    electricity_use_generatedcoordinate—0%Not Available113278.41014718.6of 12
    electricity_use_generated_1categorical—0%Not Available017541.5of 6
    electricity_use_generated_2categorical—0%Not Available21200220356.5of 12
    avoided_emissions_onsitecategorical—0%Not Available0130of 11
    avoided_emissions_offsitecategorical—0%0Not Available172.4of 9
    estimated_data_flagcategorical—0%NoYesNot Availableof 3
    estimated_data_flag_naturalcategorical—0%NoNot AvailableYesof 3
    estimated_data_flag_fuelcategorical—0%Not AvailableNoYesof 3
    estimated_data_flag_fuel_1categorical—0%Not AvailableNoYesof 3
    estimated_data_flag_fuel_2categorical—0%Not AvailableNoYesof 3
    estimated_data_flag_districtcategorical—0%Not AvailableNoYesof 3
    total_ghg_emissions_metrictext—0%Not Available0301.5
    direct_ghg_emissions_metriccoordinate—0%0Not Available64.9
    indirect_ghg_emissions_metriccoordinate—0%Not Available063.7
    egrid_output_emissions_ratecoordinate—0%82.9Not Available178.3of 8
    net_emissions_metric_tonscoordinate—0%0Not Available301.5
    national_median_total_ghgcoordinate—0%Not Available283.6309.5
    green_power_offsite_kwhcategorical—0%0Not Available132841.1of 9
    green_power_onsite_kwhcategorical—0%Not Available0487412of 11
    percent_of_electricity_thatcoordinate—0%0Not Available0.3567626of 18
    percent_of_recs_retainedcategorical—0%Not Available1000of 3
    percent_of_total_electricitycoordinate—0%Not Available7.9774111.270551of 12
    municipally_supplied_potablecoordinate—0%Not Available0468955.65
    difference_from_national_2text—0%Not Availableof 1
    energy_costcoordinate—0%Not Available0547537.6
    energy_cost_intensity_ftcoordinate—0%Not Available00.68
    national_median_energy_costcoordinate—0%Not Available017297.7
    investment_in_energy_projectscategorical—0%07868021900of 13
    investment_in_energy_projects_1coordinate—0%0Not Available0.44of 14
    estimated_savings_from_energycategorical—0%020500011544of 6
    estimated_savings_from_energy_1coordinate—0%0Not Available0.46of 7
    electricity_grid_purchasecoordinate—0%Not Available02389741.94
    natural_gas_costcoordinate—0%Not Available0115.7
    fuel_oil_no_2_costcoordinate—0%Not Available0147224.12
    fuel_oil_no_4_costcoordinate—0%Not Available050358.55
    fuel_oil_no_5_and_no_6_costcoordinate—0%Not Available046553.18
    district_steam_costcoordinate—0%Not Available0531091.75
    water_wastewater_investmenttext—0%Not Availableof 1
    water_wastewater_estimatedtext—0%Not Availableof 1
    municipally_supplied_potable_1coordinate—0%Not Available00.01
    municipally_supplied_potable_2coordinate—0%Not Available01514.8
    municipally_supplied_potable_3coordinate—0%Not Available044.95
    water_use_all_water_sourcescoordinate—0%Not Available03654.7
    indoor_water_use_all_watercoordinate—0%Not Available01514.8
    costar_property_idtext—0%Not Availableof 1
    leed_us_project_idcategorical—0%Not Available10000053671000027689of 3
    date_property_last_modifieddate—0%09/03/2014 11:21 PM EDT09/03/2014 11:20 PM EDT09/03/2014 11:23 PM EDT
    adult_education_gross_floorcategorical—0%Not Available4849611800of 4
    ambulatory_surgical_centercategorical—0%Not Available66000of 2
    automobile_dealership_grosscategorical—0%Not Available47000330000of 11
    bank_branch_gross_floor_areatext—0%Not Available30005000
    bank_branch_number_oftext—0%Not Available1015
    bar_nightclub_gross_floorcategorical—0%Not Available818420000of 4
    college_university_grosstext—0%Not Available55000641800
    college_university_numbertext—0%Not Available25050
    convenience_store_with_gastext—0%Not Availableof 1
    convenience_store_withouttext—0%Not Available1120895
    convention_center_gross_floortext—0%Not Availableof 1
    courthouse_gross_floor_areacategorical—0%Not Available2920569500of 5
    data_center_pdu_input_metercategorical—0%Not Available2505360of 2
    data_center_pdu_output_metertext—0%Not Availableof 1
    data_center_it_equipmenttext—0%Not Availableof 1
    data_center_it_site_energycoordinate—0%Not Available01386656.6
    data_center_it_source_energycoordinate—0%Not Available014856195.4
    data_center_puetext—0%Not Availableof 1
    data_center_national_mediancategorical—0%Not Available1.8of 2
    data_center_cooling_equipmentcategorical—0%Not AvailableN+1None of the Aboveof 8
    data_center_gross_floor_areatext—0%Not Available012000
    data_center_it_energycategorical—0%Not AvailableUninterruptible Power Su…Facility Has No UPSof 7
    data_center_ups_systemcategorical—0%Not AvailableN+1None of the Aboveof 10
    distribution_center_grosstext—0%Not Available20000020000
    enclosed_mall_gross_floorcategorical—0%Not Available32188615000of 4
    energy_power_station_grosstext—0%Not Availableof 1
    fast_food_restaurant_grosstext—0%Not Available15002000
    financial_office_gross_floortext—0%Not Available50003000
    financial_office_number_oftext—0%Not Available1012
    financial_office_number_of_1text—0%Not Available108
    financial_office_weeklytext—0%Not Available6550
    fitness_center_health_clubcategorical—0%Not Available1750018000of 9
    food_sales_gross_floor_areatext—0%Not Available22002500
    food_service_gross_floortext—0%Not Available1285713200
    hospital_general_medicaltext—0%Not Available200800
    hospital_general_medical_1coordinate—0%Not Available2.62.66772
    hospital_general_medical_2text—0%Not Available299881112500
    hospital_general_medical_3categorical—0%Not Available100% YesNoof 3
    hospital_general_medical_4coordinate—0%Not Available106945
    hospital_general_medical_5coordinate—0%Not Available0.690.69004
    hospital_general_medical_6categorical—0%Not Available56of 15
    hospital_general_medical_7coordinate—0%Not Available00.00045
    hospital_general_medical_8categorical—0%Not Available12of 7
    hospital_general_medical_9text—0%Not Available30667
    hospital_general_medical_10categorical—0%Not AvailableNo100% Yesof 3
    hospital_general_medical_11categorical—0%Not AvailableNon ProfitFor Profitof 3
    hospital_general_medical_12categorical—0%Not Available100of 2
    hospital_general_medical_13categorical—0%Not Available100of 2
    hospital_general_medical_14coordinate—0%Not Available0.460.68694
    hospital_general_medical_15categorical—0%Not Available100% YesNoof 3
    medical_office_gross_floortext—0%Not Available20005000
    medical_office_mri_machinecoordinate—0%Not Available00.06667of 11
    medical_office_number_ofcategorical—0%Not Available01of 6
    medical_office_number_of_1text—0%Not Available32
    medical_office_percent_thattext—0%Not Available10090
    medical_office_percent_that_1text—0%Not Available10090
    medical_office_weeklytext—0%Not Available6540
    outpatient_rehabilitationtext—0%Not Available10257110400
    urgent_care_clinic_othertext—0%Not Available20002200
    k_12_school_gross_floor_areatext—0%Not Available650008000
    laboratory_gross_floor_areacategorical—0%Not Available30100054000of 4
    library_gross_floor_areatext—0%Not Available407247750
    mailing_center_post_officecategorical—0%Not Available1784002500of 6
    manufacturing_industrialtext—0%Not Available1030001900
    movie_theater_gross_floorcategorical—0%Not Available19060022092of 8
    multifamily_housing_governmentcategorical—0%NoNot Available100% Yesof 4
    multifamily_housing_grosstext—0%Not Available6000072000
    multifamily_housing_numbertext—0%Not Available10090
    multifamily_housing_number_1text—0%0Not Available5
    multifamily_housing_number_2text—0%Not Available06
    multifamily_housing_totaltext—0%Not Available6072
    multifamily_housing_percenttext—0%Not Available0100
    multifamily_housing_percent_1text—0%100Not Available90
    multifamily_housing_residentcategorical—0%Not AvailableNo specific resident pop…Dedicated Senior/Indepen…of 6
    multifamily_housing_number_3coordinate—0%Not Available1.40
    multifamily_housing_total_1coordinate—0%Not Available1.20.83333
    multifamily_housing_number_4text—0%0Not Available60
    multifamily_housing_number_5coordinate—0%0Not Available1.2
    multifamily_housing_number_6text—0%0Not Available60
    multifamily_housing_number_7coordinate—0%0Not Available0.83333
    office_computer_density_numbertext—0%Not Available20
    office_gross_floor_area_fttext—0%Not Available10005000
    office_number_of_computerstext—0%Not Available21
    office_number_of_workerstext—0%Not Available10
    office_percent_that_can_becoordinate—0%Not Available1000
    office_percent_that_can_be_1coordinate—0%Not Available10033
    office_weekly_operating_hourstext—0%Not Available6540
    office_worker_density_numbertext—0%Not Available2.30
    museum_gross_floor_area_ftcategorical—0%Not Available3020585000of 9
    non_refrigerated_warehousetext—0%Not Available5000063000
    other_gross_floor_area_fttext—0%Not Available500010000
    other_weekly_operating_hourstext—0%Not Available065
    other_number_of_computerstext—0%Not Available01
    other_number_of_workers_ontext—0%Not Available02
    performing_arts_gross_floorcategorical—0%Not Available95436181503of 12
    personal_services_healthcategorical—0%Not Available10001300of 15
    pre_school_daycare_grosscategorical—0%Not Available1000019370of 6
    race_track_gross_floor_areatext—0%Not Availableof 1
    refrigerated_warehouse_grosstext—0%Not Available10000104200
    repair_services_vehicle_shoecategorical—0%Not Available50001110of 6
    residence_hall_dormitorytext—0%Not Available2200059000
    restaurant_gross_floor_areatext—0%Not Available30007000
    self_storage_facility_grosstext—0%Not Available4200049380
    senior_care_community_grosstext—0%Not Available9780066462
    social_meeting_hall_grosstext—0%Not Available360032253
    strip_mall_gross_floor_areacategorical—0%Not Available1452514644of 10
    supermarket_grocery_grosstext—0%Not Available10001500
    transportation_terminaltext—0%Not Availableof 1
    veterinary_office_gross_floortext—0%Not Availableof 1
    vocational_school_gross_floorcategorical—0%Not Available18507596of 3
    wholesale_club_supercentercategorical—0%Not Available199682193707of 8
    worship_facility_gross_floortext—0%Not Available2328710700
    retail_store_gross_floortext—0%Not Available500010000
    restaurant_worker_densitytext—0%Not Available20
    restaurant_weekly_operatingtext—0%Not Available6580
    retail_store_walk_incoordinate—0%Not Available00.16667
    retail_store_percent_thattext—0%Not Available1000
    retail_store_open_or_closedcoordinate—0%Not Available00.2
    retail_store_number_of_walktext—0%Not Available01
    retail_store_number_of_opentext—0%Not Available01
    parking_gross_floor_areatext—0%Not Available05000
    parking_open_parking_lottext—0%Not Available010000
    hotel_gross_floor_area_fttext—0%Not Available150000100000
    hotel_gym_fitness_centertext—0%Not Available0300
    hotel_room_density_numbercoordinate—0%Not Available1.951.75486
    hotel_worker_density_numbercoordinate—0%Not Available0.320.5
    hotel_percent_that_can_becategorical—0%Not Available10090of 11
    estimated_data_flag_1categorical—0%Not AvailableNoof 2
    alert_data_center_does_notcategorical—0%OkPossible Issueof 2
    alert_gross_floor_area_iscategorical—0%OkUnable to Check (not eno…Possible Issueof 3
    alert_individual_monthlycategorical—0%OkPossible IssueUnable to Check (not eno…of 3
    alert_meter_has_overlapscategorical—0%OkUnable to Check (not eno…Possible Issueof 3
    alert_meter_has_gapscategorical—0%OkUnable to Check (not eno…Possible Issueof 3
    alert_meter_has_less_thancategorical—0%OkPossible IssueUnable to Check (not eno…of 3
    alert_no_meters_are_associatedcategorical—0%OkPossible Issueof 2
    alert_property_has_no_usescategorical—0%OkPossible Issueof 2
    data_quality_checker_runcategorical—0%NoYesof 2
    data_quality_checker_datedate—0%Not Available2015-04-302015-05-01
    default_valuescategorical—0%NoYesUnable to Check (not eno…of 3
    estimated_valuescategorical—0%NoYesof 2
    temporary_valuescategorical—0%NoYesof 2
    retail_store_cash_registercoordinate—0%Not Available0.30
    retail_store_computer_densitycoordinate—0%Not Available0.20
    generation_datedatetime—0%2015-04-24T11:55:05.0002015-04-30T22:10:35.0002015-05-01T18:19:59.000
    release_datedatetime—0%2015-05-01T21:53:31.0002015-07-31T15:12:54.0002015-05-01T09:56:23.000
    boroughcategorical—6%MANHATTANBROOKLYNQUEENSof 5
    latitudefloat—6%40.72560140.85279940.807567
    longitudefloat—6%-73.791694-73.853325-73.958787
    community_boardinteger—6%105108107
    council_districtinteger—6%436
    census_tractinteger—6%199733
    ntatext—6%Midtown-Midtown SouthUpper East Side-Carnegie…Upper West Side