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

yr5p-wjerEnvironment255 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

B83.7 / 100

From a 500-row sample across 255 columns.

completeness100/ 25% weight
consistency89/ 20% weight
accuracy90/ 20% weight
timeliness33/ 15% weight
usability90/ 20% weight
  • · Very wide (255 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 2015 (Data for Calendar Year 2014)0.90
    joins oncouncil_districtparking_gross_floor_areaenergy_cost_intensity_ft+221

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_lotcustom_property_id_1_namecustom_property_id_1_idaddress_1address_2city
73651155Not Applicable: Standalone PropertyNot Applicable: Standalone Property2013-12-31T00:00:00.00010226311009970029Unique Building Identifier10226311155 Avenue of the Americas

Columns

255 queryable · 255 profiled

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

FieldTypeDescriptionNullValues
property_idinteger—0%350330131086183529389
property_nametext—0%Kings Village CorpParking GarageClub 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/yr5p-wjer
GET /api/datasets/yr5p-wjer/quality
GET /api/datasets/yr5p-wjer/related
GET /api/columns?dataset=yr5p-wjer
  • Energy and Water Data Disclosure for Local Law 84 2016 (Data for Calendar Year 2015)0.87
    joins oncouncil_districtparking_gross_floor_areaborough+202
  • Energy and Water Data Disclosure for Local Law 84 2017 (Data for Calendar Year 2016)0.86
    joins oncouncil_districtparking_gross_floor_areaborough+192
  • Energy and Water Data Disclosure for Local Law 84 2013 (Data for Calendar Year 2012)0.84
    joins oncouncil_districtparking_gross_floor_areaborough+113
  • Energy and Water Data Disclosure for Local Law 84 2019 (Data for Calendar Year 2018)0.83
    joins oncouncil_districtparking_gross_floor_areaborough+178
  • Energy and Water Data Disclosure for Local Law 84 2020 (Data for Calendar Year 2019)0.82
    joins oncouncil_districtparking_gross_floor_areaborough+168
  • Energy and Water Data Disclosure for Local Law 84 2018 (Data for Calendar Year 2017)0.80
    joins oncouncil_districtparking_gross_floor_areaborough+179
  • Energy and Water Data Disclosure for Local Law 84 2011 (Data for Calendar Year 2010)0.75
    joins oncouncil_districtparking_gross_floor_areaborough+24
    • Not Available
    Manhattan
    8139200Not Applicable: Standalone PropertyNot Applicable: Standalone Property2013-12-31T00:00:00.00010375451013150001Unique Building Identifier1037545200 East 42nd St.Not AvailableManhattan
    8604114Not Applicable: Standalone PropertyNot Applicable: Standalone Property2013-12-31T00:00:00.00010226671009990019Unique Building Identifier1022667114 West 47th stNot AvailableManhattan
    8841733Not Applicable: Standalone PropertyNot Applicable: Standalone Property2013-12-31T00:00:00.00010375961013190047Unique Building Identifier1037596733 Third AvenueNot AvailableManhattan
    11809Conde Nast BuildingNot Applicable: Standalone PropertyNot Applicable: Standalone Property2013-12-31T00:00:00.00010856821009950005Unique Building Identifier10856824 Times SquareNot AvailableManhattan
    13286201/205Not Applicable: Standalone PropertyNot Applicable: Standalone Property2013-12-31T00:00:00.0001037549; 10375501013160001Unique Building Identifier1037549; 1037550201/205 East 42nd st.Not AvailableManhattan
    28400Columbia Presbyterian Medical CenterNot Applicable: Standalone PropertyNot Applicable: Standalone Property2013-12-31T00:00:00.0001084386100-02138-00040Not AvailableNot Available622 168th StreetNot AvailableNew York City
    28402Weill Cornell Medical CenterNot Applicable: Standalone PropertyNot Applicable: Standalone Property2013-12-31T00:00:00.0001084781100-01480-00001Not AvailableNot Available525 East 68th StreetNot AvailableNew York
    28404The Allen HospitalNot Applicable: Standalone PropertyNot Applicable: Standalone Property2013-12-31T00:00:00.00010650451-02244-100Unique Building Identifier10650455141 BroadwayNot AvailableNew York
    1025339425 Lexington AvenueNot Applicable: Standalone PropertyNot Applicable: Standalone Property2013-12-31T00:00:00.00010361621012980023Unique Building Identifier1036162425 Lexington AveNot AvailableNew York

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

    year_endingdatetime—0%2013-12-31T00:00:00.000of 1
    nyc_building_identificationtext—0%Not Available44394125106890
    nyc_borough_block_and_lottext—0%Not Available2-14748-36474070210001
    custom_property_id_1_nametext—0%Unique Building Identifi…Not AvailableBIN
    custom_property_id_1_idtext—0%Not Available44394125106890
    address_1text—0%NA8000 Utopia Parkway1919 Williamsbridge Road
    address_2text—0%Not AvailableDefault InfoMultiple Addresses-See U…
    citytext—0%New YorkBrooklynBronx
    countytext—0%Not AvailableNew YorkQueens
    postcodetext—0%100011002210016
    primary_property_type_selftext—0%Multifamily HousingOfficeOther
    primary_property_type_epatext—0%Multifamily HousingOfficeOther
    property_floor_area_buildingtext—0%Not Available6000070000
    national_median_referencetext—0%NACBECS combination - 2, B…PBA - 91, Other
    year_builtinteger—0%192719281929
    number_of_buildingstext—0%102
    occupancycategorical—0%1009095of 19
    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 Available20132013, 2012
    energy_star_certification_1date—0%Not Available01/06/201411/29/2013
    energy_star_certification_2date—0%Not Available08/31/201408/31/2013
    energy_star_certification_3categorical—0%NoYesof 2
    energy_star_certification_4categorical—0%Not AvailableUnder ReviewSubmittedof 3
    energy_star_certification_5categorical—0%NoYesof 2
    site_eui_kbtu_ftcoordinate—0%Not Available14071.6
    weather_normalized_site_euicoordinate—0%Not Available14077.1
    site_energy_use_kbtutext—0%Not Available0118495150
    weather_normalized_site_energycoordinate—0%Not Available0118495150
    national_median_site_energytext—0%Not Available9844661.89072000
    national_median_site_euicoordinate—0%Not Available39.283.6
    percent_better_than_nationalcoordinate—0%Not Available-28.6-23.9
    source_eui_kbtu_ftcoordinate—0%Not Available218.6229.6
    weather_normalized_sourcecoordinate—0%Not Available218.6107.6
    source_energy_use_kbtucoordinate—0%Not Available0129378192.1
    national_median_source_energytext—0%Not Available66474007386000
    national_median_source_euicoordinate—0%Not Available123.1148.1
    percent_better_than_national_1coordinate—0%Not Available-100-27.7
    natural_gas_use_kbtutext—0%Not Available01158099.1
    fuel_oil_2_use_kbtutext—0%Not Available0276000
    fuel_oil_4_use_kbtutext—0%Not Available0292000
    fuel_oil_5_6_use_kbtutext—0%Not Available0220500
    district_steam_use_kbtucoordinate—3%Not Available08451800.6
    electricity_use_grid_purchasecoordinate—0%Not Available02068318
    electricity_use_grid_purchase_1coordinate—0%Not Available02068317.9
    electricity_use_generatedcoordinate—0%Not Available693349.11341403.9of 5
    electricity_use_generated_1categorical—0%Not Available016153.3of 3
    electricity_use_generated_2categorical—0%Not Available195375.5393143of 5
    weather_normalized_sitetext—0%Not Available011581
    weather_normalized_site_1text—0%Not Available0600025.5
    energy_alertstext—0%Not AvailableThe most recent bill for…One or more of the meter…
    property_use_detail_alertstext—0%More than 50% of the gro…More than 50% of the gro…More than 50% of the gro…
    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 Available0549.3
    direct_ghg_emissions_metriccoordinate—0%0Not Available61.5
    indirect_ghg_emissions_metriccoordinate—0%Not Available053.3
    egrid_output_emissions_ratecoordinate—0%81.3610849681.4179.9748629of 10
    net_emissions_metric_tonscoordinate—0%Not Available0549.3
    national_median_total_ghgcoordinate—0%Not Available394.3169.4
    green_power_offsite_kwhcategorical—0%0Not Available23074.3of 9
    green_power_onsite_kwhcategorical—0%Not Available195375.50of 5
    percent_of_electricity_thatcategorical—3%0Not Available100of 9
    percent_of_recs_retainedcategorical—0%Not Available1000of 3
    percent_of_total_electricitycoordinate—0%Not Available42.1047535.39295of 5
    municipally_supplied_potablecoordinate—3%Not Available04222.7
    municipally_supplied_potable_1coordinate—0%Not Available047.03
    other_water_sources_combinedcoordinate—3%Not Available010169
    water_alertstext—0%Not AvailableThis property does not h…The meter <b>Water</b> d…
    percent_better_than_national_2text—0%Not Availableof 1
    weather_normalized_source_1coordinate—0%Not Available0129378192.1
    adult_education_gross_floorcategorical—0%Not Available111800of 3
    ambulatory_surgical_centertext—0%Not Availableof 1
    aquarium_gross_floor_areatext—0%Not Availableof 1
    automobile_dealership_grosscategorical—0%Not Available7500089000of 11
    bank_branch_gross_floor_areatext—0%Not Available50006000
    bank_branch_number_oftext—0%Not Available1510
    bar_nightclub_gross_floorcategorical—0%Not Available200001000of 4
    bowling_alley_gross_floortext—0%Not Availableof 1
    casino_gross_floor_area_fttext—0%Not Availableof 1
    college_university_grosstext—0%Not Available030000
    college_university_numbertext—0%Not Available250120
    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 Available92292729205of 3
    data_center_pdu_input_sitecategorical—0%Not Available323843.22470319.8of 5
    data_center_pdu_output_sitetext—0%Not Availableof 1
    data_center_it_equipmenttext—0%Not Availableof 1
    data_center_it_site_energycoordinate—0%Not Available04758012.1
    data_center_it_source_energycoordinate—0%Not Available0910801
    data_center_puetext—0%Not Availableof 1
    data_center_national_mediantext—0%Not Availableof 1
    data_center_cooling_equipmentcategorical—0%Not AvailableN+1None of the Aboveof 19
    data_center_gross_floor_areatext—0%Not Available05000
    data_center_it_energycategorical—0%Not AvailableUninterruptible Power Su…Uninterruptible Power Su…of 14
    data_center_ups_systemtext—0%Not AvailableN+1None of the Above
    distribution_center_grosstext—0%Not Available20000010000
    enclosed_mall_gross_floorcategorical—0%Not Available133864690182of 4
    energy_power_station_grosstext—0%Not Availableof 1
    fast_food_restaurant_grosstext—0%Not Available10002000
    financial_office_gross_floortext—0%Not Available50002000
    financial_office_number_oftext—0%Not Available1012
    financial_office_number_of_1text—0%Not Available1020
    financial_office_weeklytext—0%Not Available6550
    fitness_center_health_clubcategorical—0%Not Available175007500of 6
    food_sales_gross_floor_areatext—0%Not Available7501300
    food_service_gross_floortext—0%Not Available9503000
    hospital_general_medicaltext—0%Not Available1100200
    hospital_general_medical_1coordinate—0%Not Available2.63.23383
    hospital_general_medical_2text—0%Not Available65000340154
    hospital_general_medical_3categorical—0%Not Available100% YesNoof 3
    hospital_general_medical_4coordinate—0%Not Available286.44.5
    hospital_general_medical_5coordinate—0%Not Available0.690.84197
    hospital_general_medical_6categorical—0%Not Available56of 16
    hospital_general_medical_7coordinate—0%Not Available00.01538
    hospital_general_medical_8categorical—0%Not Available12of 6
    hospital_general_medical_9text—0%Not Available30200
    hospital_general_medical_10text—0%Not Available547.81137
    hospital_general_medical_11coordinate—0%Not Available1.321.31993
    hospital_general_medical_12categorical—0%Not AvailableNo100% Yesof 3
    hospital_general_medical_13categorical—0%Not AvailableNon ProfitFor Profitof 3
    hospital_general_medical_14categorical—0%Not Available100of 2
    hospital_general_medical_15categorical—0%Not Available100of 2
    hospital_general_medical_16coordinate—0%Not Available0.460.52917
    hospital_general_medical_17categorical—0%Not Available100% YesNoof 3
    medical_office_gross_floortext—0%Not Available20005000
    medical_office_mri_machinecategorical—0%Not Available00.0542of 6
    medical_office_number_ofcategorical—0%Not Available01of 4
    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 Available47001815
    urgent_care_clinic_othertext—0%Not Available20002200
    ice_curling_rink_gross_floortext—0%Not Availableof 1
    indoor_arena_gross_floortext—0%Not Availableof 1
    k_12_school_gross_floor_areatext—0%Not Available90000100000
    laboratory_gross_floor_areacategorical—0%Not Available54000of 2
    laboratory_number_of_computerscategorical—0%Not Available125of 2
    library_gross_floor_areatext—0%Not Available187397750
    lifestyle_center_gross_floorcategorical—0%Not Available458536of 2
    mailing_center_post_officecategorical—0%Not Available2500of 2
    manufacturing_industrialcategorical—0%Not Available63000493362of 19
    movie_theater_gross_floorcategorical—0%Not Available325492955of 7
    multifamily_housing_governmentcategorical—0%NoNot Available100% Yesof 4
    multifamily_housing_grosstext—0%Not Available5000060000
    multifamily_housing_maximumtext—0%Not Available67
    multifamily_housing_numbertext—0%Not Available90100
    multifamily_housing_number_1text—0%Not Available020
    multifamily_housing_number_2text—0%Not Available02
    multifamily_housing_number_3text—0%Not Available05
    multifamily_housing_number_4text—0%0Not Available10
    multifamily_housing_number_5text—0%Not Available06
    multifamily_housing_totaltext—0%Not Available6066
    multifamily_housing_percenttext—0%Not Available1015
    multifamily_housing_percent_1text—0%Not Available1000
    multifamily_housing_percent_2text—0%100Not Available90
    multifamily_housing_primarytext—0%Not AvailableNatural GasFuel Oil (No. 5 and No. …
    multifamily_housing_residenttext—0%Not AvailableNo specific resident pop…Dedicated Senior/Indepen…
    office_computer_density_numbertext—0%Not Available20
    office_gross_floor_area_fttext—0%Not Available10005000
    office_number_of_computerstext—0%Not Available12
    office_number_of_workerstext—0%Not Available10
    office_percent_that_can_betext—0%Not Available1000
    office_percent_that_can_be_1coordinate—0%Not Available1000
    office_weekly_operating_hourstext—0%Not Available6540
    office_worker_density_numbertext—0%Not Available2.30
    museum_gross_floor_area_ftcategorical—0%Not Available3020585000of 8
    non_refrigerated_warehousetext—0%Not Available5000063000
    other_gross_floor_area_fttext—0%Not Available50001500
    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 Available19537292620of 11
    personal_services_healthcategorical—0%Not Available25009000of 11
    pre_school_daycare_grosscategorical—0%Not Available709362046of 5
    race_track_gross_floor_areatext—0%Not Availableof 1
    refrigerated_warehouse_grosstext—0%Not Available52323160000
    repair_services_vehicle_shoecategorical—0%Not Available832of 2
    residence_hall_dormitorytext—0%Not Available5900022000
    restaurant_gross_floor_areatext—0%Not Available30001500
    roller_rink_gross_floor_areatext—0%Not Availableof 1
    self_storage_facility_grosstext—0%Not Available4938085000
    senior_care_community_grosstext—0%Not Available1182308122
    social_meeting_hall_grosstext—0%Not Available4774128063
    stadium_closed_gross_floortext—0%Not Availableof 1
    stadium_open_gross_floortext—0%Not Availableof 1
    strip_mall_gross_floor_areacategorical—0%Not Available15697500196of 8
    supermarket_grocery_grosstext—0%Not Available10001500
    transportation_terminaltext—0%Not Availableof 1
    veterinary_office_gross_floorcategorical—0%Not Available68806of 2
    vocational_school_gross_floorcategorical—0%Not Available7596of 2
    wholesale_club_supercentercategorical—0%Not Available8508275373of 8
    worship_facility_gross_floortext—0%Not Available178504200
    zoo_gross_floor_area_fttext—0%Not Availableof 1
    energy_costcoordinate—0%0Not Available1601740.27
    energy_cost_intensity_ftcoordinate—0%0Not Available3.33925
    national_median_energy_costcoordinate—0%Not Available0115510.01
    investment_in_energy_projectscategorical—0%0763384416191of 10
    investment_in_energy_projects_1coordinate—0%0Not Available1.75of 11
    estimated_savings_from_energycategorical—0%010932411880of 4
    estimated_savings_from_energy_1categorical—0%0Not Available0.34of 5
    electricity_grid_purchasecoordinate—0%0Not Available130456.0933
    natural_gas_costcoordinate—0%0Not Available1429137.469
    fuel_oil_no_2_costcoordinate—0%Not Available03219.77012
    fuel_oil_no_4_costcoordinate—0%Not Available042146.71
    fuel_oil_no_5_and_no_6_costcoordinate—0%Not Available030413.389
    district_steam_costcoordinate—3%Not Available0260279.3917
    water_wastewater_investmenttext—0%Not Availableof 1
    water_wastewater_estimatedtext—0%Not Availableof 1
    municipally_supplied_potable_2coordinate—3%Not Available030670.79911
    other_water_sources_combined_1coordinate—3%Not Available025108.2952
    municipally_supplied_potable_3coordinate—0%Not Available00.7120507
    municipally_supplied_potable_4coordinate—0%Not Available089766.2
    water_use_all_water_sourcestext—0%Not Available089766.2
    indoor_water_use_all_watercoordinate—0%Not Available089766.2
    costar_property_idcoordinate—0%Not Available059805.39864of 12
    leed_us_project_idcoordinate—0%Not Available01.13304of 13
    date_property_last_modifieddate—0%09/15/2013 04:30 PM EDT09/15/2013 04:31 PM EDT02/06/2014 06:31 AM EST
    retail_store_gross_floortext—0%Not Available500010000
    retail_store_cash_registercoordinate—3%Not Available0.30
    retail_store_worker_densitytext—3%Not Available10
    retail_store_weekly_operatingtext—3%Not Available6560
    retail_store_walk_incoordinate—3%Not Available00.2
    retail_store_percent_thattext—3%Not Available1000
    retail_store_computer_densitycoordinate—3%Not Available0.20
    retail_store_open_or_closedcoordinate—3%Not Available00.2
    retail_store_number_of_walktext—3%Not Available01
    retail_store_number_of_opentext—3%Not Available01
    parking_gross_floor_areatext—0%Not Available05000
    parking_open_parking_lottext—0%Not Available020000
    hotel_gross_floor_area_fttext—0%Not Available100000396870
    hotel_gym_fitness_centertext—3%Not Available0800
    hotel_room_density_numbercoordinate—3%Not Available1.950
    hotel_worker_density_numbercoordinate—3%Not Available0.320.55556
    hotel_percent_that_can_becategorical—3%Not Available10090of 11
    generation_datedatetime—0%2014-08-01T15:34:48.0002014-07-30T15:30:33.0002014-08-01T15:34:47.000
    release_datedatetime—0%2014-04-30T22:25:12.0002014-05-01T22:53:17.0002014-05-01T23:17:57.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