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 2020 (Data for Calendar Year 2019)

wcm8-aq5wEnvironment254 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.1 / 100

From a 500-row sample across 254 columns.

completeness100/ 25% weight
consistency90/ 20% weight
accuracy91/ 20% weight
timeliness33/ 15% weight
usability90/ 20% weight
  • · Very wide (254 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 2019 (Data for Calendar Year 2018)0.90
    joins onambulatory_surgical_centersite_eui_kbtu_ftyear_ending+228

Geography

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

Open on the map →

Sample rows

property_idproperty_nameparent_property_idparent_property_nameyear_endingnyc_borough_block_and_lotnyc_building_identificationaddress_1address_2citypostcodeprimary_property_type_self
73651155Not Applicable: Standalone PropertyNot Applicable: Standalone Property2019-12-31T00:00:00.000100997002910226311155 Avenue of the AmericasNot AvailableManhattan10036

Columns

254 queryable · 254 profiled

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

FieldTypeDescriptionNullValues
property_idinteger—0%261622157804902606279
property_nametext—0%1266 Olmstead AvenueBuilding 3Building 1
parent_property_idtext—0%Not Applicable: Standalo…124237233616399
parent_property_nametext—0%Not Applicable: Standalo…Columbia University Main…NYU: Washington Square C…

Query this from your own app

GET /api/datasets/wcm8-aq5w
GET /api/datasets/wcm8-aq5w/quality
GET /api/datasets/wcm8-aq5w/related
GET /api/columns?dataset=wcm8-aq5w
  • Energy and Water Data Disclosure for Local Law 84 2017 (Data for Calendar Year 2016)0.85
    joins onambulatory_surgical_centersite_eui_kbtu_ftyear_ending+216
  • Energy and Water Data Disclosure for Local Law 84 2016 (Data for Calendar Year 2015)0.85
    joins onambulatory_surgical_centersite_eui_kbtu_ftyear_ending+206
  • Energy and Water Data Disclosure for Local Law 84 2018 (Data for Calendar Year 2017)0.84
    joins onambulatory_surgical_centersite_eui_kbtu_ftyear_ending+227
  • Energy and Water Data Disclosure for Local Law 84 2015 (Data for Calendar Year 2014)0.82
    joins onambulatory_surgical_centersite_eui_kbtu_ftyear_ending+193
  • Energy and Water Data Disclosure for Local Law 84 2014 (Data for Calendar Year 2013)0.82
    joins onambulatory_surgical_centersite_eui_kbtu_ftyear_ending+168
  • Energy and Water Data Disclosure for Local Law 84 2021 (Data for Calendar Year 2020)0.79
    joins onsite_eui_kbtu_ftyear_endingconstruction_status+57
  • Energy and Water Data Disclosure for Local Law 84 2013 (Data for Calendar Year 2012)0.77
    joins onsite_eui_kbtu_ftyear_endingproperty_id+102
    • Office
    8139200Not Applicable: Standalone PropertyNot Applicable: Standalone Property2019-12-31T00:00:00.00010131500011037545200 East 42nd St.Not AvailableManhattan10017Office
    8604114Not Applicable: Standalone PropertyNot Applicable: Standalone Property2019-12-31T00:00:00.00010099900191022667114 West 47th stNot AvailableManhattan10036Financial Office
    8841733Not Applicable: Standalone PropertyNot Applicable: Standalone Property2019-12-31T00:00:00.00010131900471037596733 Third AvenueNot AvailableManhattan10017Office
    11809Conde Nast BuildingNot Applicable: Standalone PropertyNot Applicable: Standalone Property2019-12-31T00:00:00.000100995000510856824 Times SquareNot AvailableManhattan10036Office
    28400NYP Columbia (West Campus)28400NYP Columbia (West Campus)2019-12-31T00:00:00.0001-02138-0040; 1-02138-0030; 1-02139-0001; 1-02139-0085; 1-02136-02451084198; 1084387;1084385; 1084386; 1084388; 1084389; 1807867; 1809824; 1063380; 1087281; 1076746; 1813204; 1063403; 1063347622 168th StreetNot AvailableNew York10032Hospital (General Medical & Surgical)
    28402NYP Cornell (East Campus)28402NYP Cornell (East Campus)2019-12-31T00:00:00.0001-01480-0001; 1-01482-00401084781; 1084780; 1081252525 East 68th StreetNot AvailableNew York10021Hospital (General Medical & Surgical)
    28404The Allen HospitalNot Applicable: Standalone PropertyNot Applicable: Standalone Property2019-12-31T00:00:00.0001-02244-010010650455141 BroadwayNot AvailableNew York10034Hospital (General Medical & Surgical)
    1025339425 Lexington AvenueNot Applicable: Standalone PropertyNot Applicable: Standalone Property2019-12-31T00:00:00.00010129800231036162425 Lexington AveNot AvailableNew York10017Office
    1045358320 Park AvenueNot Applicable: Standalone PropertyNot Applicable: Standalone Property2019-12-31T00:00:00.0001-01286-00351035464320 Park AvenueNot AvailableNew York10022Financial Office

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

    year_endingdatetime—0%2019-12-31T00:00:00.000of 1
    nyc_borough_block_and_lottext—0%Not Available10197300013021810025
    nyc_building_identificationtext—0%Not Available00000002026596
    address_1text—0%Classified95 Ross Street5260 Fieldston Road Bron…
    address_2text—0%Not AvailableMultiple Addresses-See U…Manhattan
    citytext—0%New YorkBrooklynBronx
    postcodetext—0%100251122610011
    primary_property_type_selftext—0%Multifamily HousingOfficeK-12 School
    primary_property_typetext—0%Multifamily HousingOfficeK-12 School
    national_median_referencetext—0%Fannie Mae Industry Surv…CBECS - Office & Bank/Fi…CBECS - Elementary/Middl…
    list_of_all_property_usetext—0%Multifamily HousingK-12 SchoolOffice
    largest_property_use_typetext—0%Multifamily HousingOfficeK-12 School
    largest_property_use_type_1text—0%300003600032000
    _2nd_largest_property_usetext—0%Not AvailableParkingRetail Store
    _2nd_largest_property_use_1text—0%Not Available05000
    _3rd_largest_property_usetext—0%Not AvailableRetail StoreParking
    _3rd_largest_property_use_1text—0%Not Available05000
    year_builtinteger—0%193119201930
    construction_statuscategorical—0%ExistingTestDesignof 4
    number_of_buildingsinteger—0%123
    occupancyinteger—0%1009590
    metered_areas_energycategorical—0%Whole PropertyNot AvailableAnother configurationof 15
    metered_areas_watercategorical—0%Whole PropertyNot AvailableAnother configurationof 7
    energy_star_scoretext—0%Not Available1001
    national_median_energy_starinteger—0%50of 1
    energy_star_certificationtext—0%Not Available20182018, 2017
    energy_star_certification_1date—0%Not Available08/01/201811/26/2019
    energy_star_certification_2categorical—0%NoYesNonof 4
    site_eui_kbtu_ftcoordinate—0%Not Available83.476.7
    weather_normalized_site_euicoordinate—0%Not Available82.183.4
    national_median_site_euicoordinate—0%Not Available59.642.2
    difference_from_nationaltext—0%Not Available-9.91
    site_energy_use_kbtucoordinate—0%Not Available02643938.9
    weather_normalized_site_energycoordinate—0%Not Available02740436.7
    weather_normalized_sitecoordinate—0%Not Available43.6
    weather_normalized_site_1coordinate—0%0Not Available0.7
    source_eui_kbtu_fttext—0%Not Available113113.5
    weather_normalized_sourcetext—0%Not Available120.1113
    national_median_source_euicoordinate—0%118.1110.5Not Available
    difference_from_national_1text—0%Not Available-9.91
    source_energy_use_kbtucoordinate—0%Not Available03129911.6
    weather_normalized_source_1coordinate—0%Not Available03231234.4
    fuel_oil_1_use_kbtucategorical—0%Not Available03962153.5of 7
    fuel_oil_2_use_kbtutext—0%Not Available0276000
    fuel_oil_4_use_kbtutext—0%Not Available0219000
    fuel_oil_5_6_use_kbtutext—0%Not Available0150150
    diesel_2_use_kbtutext—0%Not Available0151983.5
    kerosene_use_kbtutext—0%Not Availableof 1
    propane_use_kbtucategorical—0%Not Available0744592.8of 4
    district_steam_use_kbtucoordinate—0%Not Available02390676.3
    district_hot_water_use_kbtucoordinate—0%Not Available2616070.28814200.6of 5
    district_chilled_water_usetext—0%Not Available353228011517.4
    natural_gas_use_kbtutext—0%Not Available02441781.3
    natural_gas_use_thermscoordinate—0%Not Available024417.81277
    weather_normalized_site_2text—0%Not Available025382.8
    electricity_use_grid_purchasetext—0%Not Available0197063.5
    electricity_use_grid_purchase_1text—0%Not Available059249
    weather_normalized_site_3text—0%Not Available059249
    electricity_use_grid_purchase_2coordinate—0%Not Available0197063.5
    electricity_use_grid_purchase_3text—0%Not Available057756
    electricity_use_generatedcoordinate—0%Not Available1665483.21604960.4
    electricity_use_generated_1text—0%Not Available488125.2470387
    electricity_use_generated_2text—0%Not Available488125.2470387
    electricity_use_generated_3coordinate—0%Not Available0618817.1
    annual_maximum_demand_kwtext—0%Not Available0192
    annual_maximum_demand_mmcategorical—0%Not Available09/201910/2019of 13
    annual_maximum_demand_metertext—0%Not Available0300383E (7943459)319 Beach 98th St Elec (…
    green_power_onsite_kwhtext—0%Not Available0488125.2
    green_power_offsite_kwhcategorical—0%0Not Available77113of 16
    green_power_onsite_and_offsitetext—0%0Not Available77113
    total_ghg_emissions_metrictext—0%0Not Available146.8
    direct_ghg_emissions_metriccoordinate—0%0Not Available0.1
    total_ghg_emissions_intensitycoordinate—0%4.85.15.2
    direct_ghg_emissions_intensitycoordinate—0%00.13.6
    indirect_ghg_emissions_metriccoordinate—0%0Not Available56.2
    net_emissions_metric_tonscoordinate—0%0Not Available146.8
    indirect_ghg_emissionscoordinate—0%1.21.11
    national_median_total_ghgcoordinate—0%Not Available260.720.5
    egrid_output_emissions_ratecoordinate—0%84.779.5Not Availableof 11
    avoided_emissions_onsitecoordinate—0%Not Available019.8
    avoided_emissions_offsitecoordinate—0%0Not Available25.5of 14
    avoided_emissions_onsite_1coordinate—0%0Not Available19.8
    percent_of_electricity_thatcoordinate—0%0Not Available100
    percent_of_recs_retainedcategorical—0%Not Available1000of 3
    percent_of_total_electricitycoordinate—0%Not Available7.205235100
    costar_property_idtext—0%Not Availableof 1
    leed_us_project_idtext—0%Not Available10000981941000024826
    adult_education_gross_floortext—0%Not Available1669445100
    ambulatory_surgical_centercategorical—0%Not Available19105674388of 10
    automobile_dealership_grosstext—0%Not Available28732135000
    bank_branch_gross_floor_areatext—0%Not Available50001500
    barracks_gross_floor_areatext—0%Not Availableof 1
    college_university_grosstext—0%Not Available69781184055
    convention_center_gross_floorcategorical—0%Not Available31680of 2
    courthouse_gross_floor_areatext—0%Not Available320535291589
    data_center_gross_floor_areatext—0%Not Available10002000
    data_center_ups_systemcategorical—0%Not AvailableN+1None of the Aboveof 11
    data_center_cooling_equipmentcategorical—0%Not AvailableN+1None of the Aboveof 9
    data_center_it_energycategorical—0%Not AvailableNo IT Energy Configurati…Uninterruptible Power Su…of 10
    data_center_energy_estimatescategorical—0%Not Available100% YesNoof 3
    data_center_ups_output_metertext—0%Not Available03453898.4
    data_center_pdu_input_metercategorical—0%Not Available0367149.7of 5
    data_center_pdu_output_metercategorical—0%Not Available0of 2
    data_center_it_equipmentcategorical—0%Not Available0of 2
    data_center_it_site_energytext—0%Not Available3453898.4205266.3
    data_center_it_source_energycoordinate—0%Not Available32997163.426839119.6
    data_center_puecoordinate—0%Not Available1.120.26of 4
    data_center_national_mediancategorical—0%Not Available21.8of 4
    distribution_center_grosstext—0%Not Available3000020800
    enclosed_mall_gross_floorcategorical—0%Not Available536000121490of 19
    energy_power_station_grosscategorical—0%Not Available31100035648of 10
    financial_office_gross_floortext—0%Not Available04000
    financial_office_number_oftext—0%Not Available1012
    financial_office_weeklytext—0%Not Available6550
    financial_office_number_of_1text—0%Not Available1510
    fitness_center_health_clubtext—0%Not Available50001500
    food_sales_gross_floor_areatext—0%Not Available15002250
    food_service_gross_floortext—0%Not Available20009456
    hospital_general_medicaltext—0%Not Available990375
    hospital_general_medical_1text—0%Not Available79760067925
    hospital_general_medical_2categorical—0%Not Available100% YesNoof 3
    hospital_general_medical_3text—0%Not Available100500
    hospital_general_medical_4categorical—0%Not Available12of 16
    hospital_general_medical_5coordinate—0%Not Available00.00324
    hospital_general_medical_6text—0%Not Available500726
    hospital_general_medical_7coordinate—0%Not Available0.460
    hospital_general_medical_8text—0%Not Available500275
    hospital_general_medical_9coordinate—0%Not Available1.321.32002
    hospital_general_medical_10coordinate—0%Not Available2.62.59999
    hospital_general_medical_11categorical—0%Not Available10080of 5
    hospital_general_medical_12categorical—0%Not Available10090of 4
    medical_office_gross_floortext—0%Not Available50009000
    medical_office_number_oftext—0%Not Available1020
    medical_office_number_of_1categorical—0%Not Available01of 11
    medical_office_number_of_2text—0%Not Available1020
    medical_office_percent_thatcategorical—0%Not Available10090of 14
    medical_office_percent_that_1categorical—0%Not Available10090of 15
    medical_office_weeklytext—0%Not Available6540
    outpatient_rehabilitationtext—0%Not Available10002100
    urgent_care_clinic_othertext—0%Not Available40002200
    hotel_gross_floor_area_fttext—0%Not Available7500030000
    hotel_gym_fitness_centertext—0%Not Available0400
    k_12_school_gross_floor_areatext—0%Not Available110400109200
    pre_school_daycare_grosstext—0%Not Available2500010000
    laboratory_gross_floor_areatext—0%Not Available50040162
    mailing_center_post_officetext—0%Not Available16005782
    movie_theater_gross_floortext—0%Not Available617982955
    manufacturing_industrialtext—0%Not Available300005037
    multifamily_housing_governmentcategorical—0%Not AvailableNo100% Yesof 4
    multifamily_housing_grosstext—0%Not Available3600032000
    multifamily_housing_numbertext—0%Not Available6050
    multifamily_housing_number_1coordinate—0%Not Available1.40.73496
    multifamily_housing_number_2text—0%Not Available05
    multifamily_housing_number_3text—0%Not Available04
    multifamily_housing_number_4text—0%0Not Available60
    multifamily_housing_totaltext—0%Not Available4860
    multifamily_housing_total_1coordinate—0%Not Available1.21
    multifamily_housing_number_5coordinate—0%0Not Available0.93585
    multifamily_housing_number_6text—0%Not Available048
    multifamily_housing_number_7coordinate—0%Not Available00.73496
    multifamily_housing_percenttext—0%Not Available90100
    multifamily_housing_percent_1text—0%Not Available10090
    multifamily_housing_residentcategorical—0%Not AvailableNo specific resident pop…Dedicated Senior/Indepen…of 9
    residence_hall_dormitorytext—0%Not Available2804875000
    non_refrigerated_warehousetext—0%Not Available4000050000
    office_gross_floor_area_fttext—0%Not Available10000
    office_number_of_computerstext—0%Not Available102
    office_number_of_workerstext—0%Not Available0100
    office_percent_that_can_becoordinate—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
    other_gross_floor_area_fttext—0%Not Available20004000
    museum_gross_floor_area_fttext—0%Not Available140000220000
    performing_arts_gross_floortext—0%Not Available1428040000
    parking_gross_floor_areatext—0%Not Available05000
    parking_completely_enclosedtext—0%Not Available05000
    parking_open_parking_lottext—0%Not Available05000
    parking_partially_enclosedtext—0%Not Available05000
    refrigerated_warehouse_grosstext—0%Not Available3000010000
    restaurant_gross_floor_areatext—0%Not Available30005000
    restaurant_weekly_operatingtext—0%Not Available7084
    restaurant_worker_densitytext—0%Not Available01
    retail_store_gross_floortext—0%Not Available500010000
    retail_store_number_of_walktext—0%Not Available01
    retail_store_number_of_opentext—0%Not Available02
    retail_store_percent_thattext—0%Not Available10090
    self_storage_facility_grosstext—0%Not Available87616523
    senior_care_community_grosstext—0%Not Available73115150010
    senior_care_community_livingcoordinate—0%Not Available1.5840
    social_meeting_hall_grosstext—0%Not Available6474422905
    supermarket_grocery_grosstext—0%Not Available500010000
    supermarket_grocery_numbertext—0%Not Available01
    supermarket_grocery_number_1text—0%Not Available01
    wholesale_club_supercentercategorical—0%Not Available13500038065of 15
    wastewater_treatment_plantcategorical—0%Not Available13062711417230of 16
    wholesale_club_supercenter_1categorical—0%Not Available100% YesNoof 3
    worship_facility_gross_floortext—0%Not Available1000040000
    estimated_data_flagcategorical—0%NoNot AvailableYesof 4
    estimated_data_flag_naturalcategorical—0%NoNot AvailableYesof 4
    estimated_data_flag_fuelcategorical—0%Not AvailableNoof 2
    estimated_data_flag_fuel_1categorical—0%Not AvailableNoYesof 3
    estimated_data_flag_fuel_2categorical—0%Not AvailableNoYesof 3
    estimated_data_flag_fuel_3categorical—0%Not AvailableNoof 2
    estimated_data_flag_districtcategorical—0%Not AvailableNoYesof 3
    estimated_data_flag_1categorical—0%Not AvailableNoYesof 4
    estimated_values_energycategorical—0%NoYesUnable to Check (not eno…of 4
    estimated_values_watercategorical—0%NoUnable to Check (not eno…Yesof 4
    alert_data_center_issue_withcategorical—0%OkPossible IssueOKof 3
    alert_gross_floor_area_iscategorical—0%OkUnable to Check (not eno…OKof 4
    alert_property_has_no_usescategorical—0%OkOKPossible Issueof 3
    alert_energy_meter_has_lesscategorical—0%OkUnable to Check (not eno…Possible Issueof 4
    alert_energy_meter_has_gapscategorical—0%OkUnable to Check (not eno…OKof 4
    alert_energy_meter_hascategorical—0%OkUnable to Check (not eno…Possible Issueof 4
    alert_energy_no_meterscategorical—0%OkPossible IssueOKof 3
    alert_energy_meter_has_singlecategorical—0%OkPossible IssueUnable to Check (not eno…of 4
    alert_water_meter_has_lesscategorical—0%OkUnable to Check (not eno…Possible Issueof 4
    default_valuescategorical—0%NoYesNonof 4
    temporary_valuescategorical—0%NoYesNonof 3
    data_quality_checker_datedate—0%Not Available2020-04-032020-04-27
    property_gfa_self_reportedinteger—0%300003600032000
    property_gfa_calculatedtext—0%300003600032000
    property_gfa_calculated_1text—0%300003600032000
    property_gfa_calculated_2text—0%Not Available500010000
    water_use_all_water_sourcestext—0%Not Available0374
    indoor_water_use_all_watertext—0%Not Available0374
    indoor_water_use_intensitycoordinate—0%Not Available00.04
    outdoor_water_use_all_watercategorical—0%Not Available010444of 10
    municipally_supplied_potablecoordinate—0%Not Available0168.4
    municipally_supplied_potable_1coordinate—0%Not Available0374
    municipally_supplied_potable_2text—0%Not Available0374
    municipally_supplied_potable_3categorical—0%Not Available010444of 8
    water_use_intensity_all_watercoordinate—0%Not Available00.04
    third_party_certificationcategorical—0%Not AvailableLEEDEcoRooms and EcoSuitesof 4
    third_party_certification_1date—0%Not Available12/19/201111/01/2015of 15
    third_party_certification_2date—0%Not Available12/19/201111/01/2015of 15
    last_modified_date_propertydate—0%08/11/2020 05:35 PM EDT08/12/2020 09:16 PM EDT08/18/2020 11:23 AM EDT
    last_modified_date_electricdate—0%Not Available08/18/2020 10:41 AM EDT04/21/2020 11:13 AM EDT
    last_modified_date_gas_metersdate—0%Not Available08/18/2020 10:57 AM EDT04/23/2020 04:18 PM EDT
    last_modified_date_nondate—0%Not Available08/18/2020 11:23 AM EDT04/10/2020 05:35 PM EDT
    last_modified_date_waterdate—0%Not Available08/18/2020 11:12 AM EDT03/03/2020 05:40 PM EST
    generation_datedatetime—0%2020-05-01T17:50:35.0002020-05-01T17:50:38.0002020-05-01T17:50:34.000
    release_datedatetime—0%2020-08-28T16:28:36.0002020-08-13T20:56:54.0002020-05-01T17:59:19.000
    boroughcategorical—4%MANHATTANBROOKLYNBRONXof 5
    latitudefloat—4%40.70420740.90002640.8332
    longitudefloat—4%-73.962786-73.901512-73.854481
    community_boardinteger—4%105108112
    council_districtinteger—4%431
    census_tractinteger—4%3319921
    ntatext—4%Midtown-Midtown SouthHudson Yards-Chelsea-Fla…Upper West Side