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

77q4-nkfhEnvironment256 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.4 / 100

From a 500-row sample across 255 columns.

completeness100/ 25% weight
consistency91/ 20% weight
accuracy92/ 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 2017 (Data for Calendar Year 2016)0.95
    joins ondifference_from_national_2occupancynational_median_energy_star+239

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_2citycountypostcode
2659942Commerce-Halsey, LLCNot Applicable: Standalone PropertyNot Applicable: Standalone Property2015-12-31T00:00:00.0002-03852-000120272862500 Halsey StreetNot AvailableBronxBronx10461

Columns

256 queryable · 256 profiled

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

FieldTypeDescriptionNullValues
property_idinteger—0%269124110524784137142
property_nametext—0%Club Quarters78 8th Avenue140 Broadway
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/77q4-nkfh
GET /api/datasets/77q4-nkfh/quality
GET /api/datasets/77q4-nkfh/related
GET /api/columns?dataset=77q4-nkfh
  • Energy and Water Data Disclosure for Local Law 84 2015 (Data for Calendar Year 2014)0.91
    joins ondifference_from_national_2occupancynational_median_energy_star+233
  • Energy and Water Data Disclosure for Local Law 84 2019 (Data for Calendar Year 2018)0.88
    joins onoccupancymultifamily_housing_governmentkerosene_use_kbtu+218
  • Energy and Water Data Disclosure for Local Law 84 2014 (Data for Calendar Year 2013)0.87
    joins onoccupancynational_median_energy_starmultifamily_housing_government+202
  • Energy and Water Data Disclosure for Local Law 84 2020 (Data for Calendar Year 2019)0.85
    joins onoccupancynational_median_energy_starmultifamily_housing_government+206
  • Energy and Water Data Disclosure for Local Law 84 2018 (Data for Calendar Year 2017)0.85
    joins onoccupancymultifamily_housing_governmentkerosene_use_kbtu+219
  • Energy and Water Data Disclosure for Local Law 84 2013 (Data for Calendar Year 2012)0.80
    joins onmultifamily_housing_governmentfuel_oil_5_6_use_kbtuelectricity_use_grid_purchase+107
  • Energy and Water Data Disclosure for Local Law 84 2012 (Data for Calendar Year 2011)0.76
    joins onmedical_office_number_ofdata_center_it_energymedical_office_gross_floor+30
    • 32870773075 Richmond TerraceNot Applicable: Standalone PropertyNot Applicable: Standalone Property2015-12-31T00:00:00.000501208000451576353035 Richmond TerraceNot AvailableStaten IslandRichmond10303
    2685891Omni Berkshire Place HotelNot Applicable: Standalone PropertyNot Applicable: Standalone Property2015-12-31T00:00:00.0001-01288-00111081151;108115221 EAST 52 STREETNot AvailableNEW YORKNew York10022
    2664118Sovereign - 425 East 58th StreetNot Applicable: Standalone PropertyNot Applicable: Standalone Property2015-12-31T00:00:00.0001-01370-00151040637425 East 58th StreetNot AvailableNew YorkNot Available10022
    2674133Lightstone - 98th St Beach Channel DriveNot Applicable: Standalone PropertyNot Applicable: Standalone Property2015-12-31T00:00:00.0004-16155-00214445407319 Beach 98th Street320 Beach 100th StreetQueensNot Available11694
    4035088Northridge Coop Section IINot Applicable: Standalone PropertyNot Applicable: Standalone Property2015-12-31T00:00:00.0004-01420-00014431373;4431374;4431375;4431376;4431377;443137890-08 32nd AvenueNot AvailableQueensNot Available11369
    4415002Bronx Parking - 20 East 161st StreetNot Applicable: Standalone PropertyNot Applicable: Standalone Property2015-12-31T00:00:00.0002-02499-0108283205420 East 161st StreetNot AvailableBronxNot Available10451
    4415003Bronx Parking - 71 East 153rd StreetNot Applicable: Standalone PropertyNot Applicable: Standalone Property2015-12-31T00:00:00.0002-02490-0001200301871 East 153rd StreetNot AvailableBronxNot Available10451
    4415004Bronx Parking - 951 River AvenueNot Applicable: Standalone PropertyNot Applicable: Standalone Property2015-12-31T00:00:00.0002-02493-00092116393951 River AvenueNot AvailableBronxNot Available10452
    4415005Bronx Parking - 950 River AvenueNot Applicable: Standalone PropertyNot Applicable: Standalone Property2015-12-31T00:00:00.0002-02485-00012002992950 River AvenueNot AvailableBronxNot Available10452

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

    year_endingdatetime—0%2015-12-31T00:00:00.000of 1
    nyc_borough_block_and_lottext—0%Not Available10197300014065170001
    nyc_building_identificationtext—0%Not Available00000004455438
    address_1text—0%ClassifiedRikers Island410 West 118th Street
    address_2text—0%Not AvailableMultiple Addresses-See U…Default Info
    citytext—0%New YorkBrooklynBronx
    countytext—0%Not AvailableNew YorkQueens
    postcodetext—0%100011001610022
    primary_property_type_selftext—0%Multifamily HousingOfficeK-12 School
    primary_property_type_epatext—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%700006000072000
    _2nd_largest_property_usetext—0%Not AvailableParkingRetail Store
    _2nd_largest_property_use_1text—0%Not Available05000
    _3rd_largest_property_usetext—0%Not AvailableRetail StoreOther
    _3rd_largest_property_use_1text—0%Not Available01000
    year_builtinteger—0%193119271930
    number_of_buildingstext—0%123
    occupancyinteger—0%1009590
    metered_areas_energycategorical—0%Whole BuildingCommon areas onlyNot Availableof 12
    metered_areas_watercategorical—0%Not AvailableWhole BuildingCombination of common an…of 6
    energy_star_scoretext—0%Not Available1001
    national_median_energy_starinteger—0%50of 1
    energy_star_certificationtext—0%Not Available20152014
    energy_star_certification_1date—0%Not Available11/24/201511/23/2015
    energy_star_certification_2categorical—0%NoYesof 2
    site_eui_kbtu_ftcoordinate—0%Not Available85.578.1
    weather_normalized_site_euicoordinate—0%Not Available80.777.5
    national_median_site_euicoordinate—0%Not Available59.667.3
    difference_from_nationalcoordinate—0%Not Available-2.4-12.4
    site_energy_use_kbtucoordinate—0%Not Available01263881.8
    weather_normalized_site_energycoordinate—0%Not Available01257080.7
    national_median_site_energycoordinate—0%Not Available1022860.41093787.4
    weather_normalized_sitecoordinate—0%Not Available3.94.1
    weather_normalized_site_1coordinate—0%Not Available00.6
    source_eui_kbtu_ftcoordinate—0%Not Available0128.4
    weather_normalized_sourcecoordinate—0%Not Available118116.6
    national_median_source_euicoordinate—0%127.9121.1123.1
    difference_from_national_1coordinate—0%Not Available-2.4-12.4
    source_energy_use_kbtucoordinate—0%Not Available01719065.6
    weather_normalized_source_1coordinate—0%Not Available01711924.4
    national_median_source_energycoordinate—0%Not Available1391240.81554351.8
    fuel_oil_1_use_kbtucategorical—0%Not Available1154561.84977078.1of 8
    fuel_oil_2_use_kbtutext—0%Not Available0276000
    fuel_oil_4_use_kbtutext—0%Not Available03775458
    fuel_oil_5_6_use_kbtutext—0%Not Available0749998.4
    diesel_2_use_kbtutext—0%Not Available05016576
    kerosene_use_kbtutext—0%Not Availableof 1
    propane_use_kbtutext—0%Not Availableof 1
    district_steam_use_kbtutext—0%Not Available9926820.10
    district_hot_water_use_kbtucategorical—0%Not Available3223629912330600.1of 3
    district_chilled_water_usecoordinate—0%Not Available8650163.911081.2
    natural_gas_use_kbtutext—0%Not Available01076327
    weather_normalized_site_2text—0%Not Available010695.3
    electricity_use_grid_purchasecoordinate—0%Not Available0187554.8
    weather_normalized_site_3text—0%Not Available054969.2
    electricity_use_grid_purchase_1text—0%Not Available0187554.8
    electricity_use_generatedtext—0%Not Available985351.51021559.6
    electricity_use_generated_1text—0%Not Available176600288790
    electricity_use_generated_2categorical—0%Not Available011082.7of 5
    green_power_onsite_kwhtext—0%Not Available0288790
    green_power_offsite_kwhcategorical—0%0Not Available426468of 9
    avoided_emissions_onsitecoordinate—0%Not Available073.8
    avoided_emissions_offsitecoordinate—0%0Not Available386.3of 9
    total_ghg_emissions_metriccoordinate—0%Not Available072.7
    direct_ghg_emissions_metriccoordinate—0%0Not Available57.2
    indirect_ghg_emissions_metriccoordinate—0%0Not Available81.4
    national_median_total_ghgcoordinate—0%Not Available58.963.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
    egrid_output_emissions_ratecoordinate—0%82.9Not Available178.3of 5
    net_emissions_metric_tonscoordinate—0%0Not Available72.7
    percent_of_electricity_thatcoordinate—0%0Not Available100
    percent_of_recs_retainedcategorical—0%Not Available1000of 4
    percent_of_total_electricitycoordinate—0%Not Available17.694392.12098
    difference_from_national_2coordinate—0%Not Available-3211of 12
    costar_property_idtext—0%Not Availableof 1
    leed_us_project_idcategorical—0%Not Available1000001164745440494141505of 8
    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 Available8500074105of 7
    ambulatory_surgical_centercategorical—0%Not Available534472238000of 3
    automobile_dealership_grosscategorical—0%Not Available750008331of 9
    bank_branch_gross_floor_areatext—0%Not Available50001000
    bank_branch_number_oftext—0%Not Available1510
    bar_nightclub_gross_floorcategorical—0%Not Available81845000of 5
    college_university_grosstext—0%Not Available5500011992
    college_university_numbertext—0%Not Available25050
    convenience_store_with_gastext—0%Not Availableof 1
    convenience_store_withouttext—0%Not Available1600021697
    convention_center_gross_floortext—0%Not Availableof 1
    courthouse_gross_floor_areatext—0%Not Available291589550000
    data_center_gross_floor_areatext—0%Not Available012000
    data_center_pdu_input_metercategorical—0%Not Available01481859.1of 5
    data_center_pdu_output_metercategorical—0%Not Available0of 2
    data_center_it_equipmentcategorical—0%Not Available0of 2
    data_center_it_site_energycoordinate—0%Not Available03096005.1
    data_center_it_source_energycoordinate—0%Not Available033169607.6
    data_center_puetext—0%Not Availableof 1
    data_center_national_mediancategorical—0%Not Available1.8of 2
    data_center_ups_output_metercoordinate—0%Not Available03096005.1
    data_center_cooling_equipmentcategorical—0%Not AvailableN+1Nof 9
    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 Available9000040302
    enclosed_mall_gross_floorcategorical—0%Not Available2662400725679of 9
    energy_power_station_grosscategorical—0%Not Available1600of 2
    fast_food_restaurant_grosstext—0%Not Available10001500
    financial_office_gross_floortext—0%Not Available50000
    financial_office_number_oftext—0%Not Available1012
    financial_office_number_of_1text—0%Not Available1020
    financial_office_weeklytext—0%Not Available6550
    fitness_center_health_clubtext—0%Not Available1300011201
    food_sales_gross_floor_areatext—0%Not Available25001300
    food_service_gross_floortext—0%Not Available50016695
    hospital_general_medicaltext—0%Not Available2950448
    hospital_general_medical_1coordinate—0%Not Available2.62.59998
    hospital_general_medical_2text—0%Not Available1134614700000
    hospital_general_medical_3categorical—0%Not AvailableNo100% Yesof 3
    hospital_general_medical_4text—0%Not Available1069483
    hospital_general_medical_5coordinate—0%Not Available0.690.69001
    hospital_general_medical_6categorical—0%Not Available56of 16
    hospital_general_medical_7coordinate—0%Not Available00.0058
    hospital_general_medical_8categorical—0%Not Available12of 7
    hospital_general_medical_9text—0%Not Available8030
    hospital_general_medical_10text—0%Not Available924100
    hospital_general_medical_11coordinate—0%Not Available1.321.32002
    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 Available10080of 3
    hospital_general_medical_15categorical—0%Not Available10080of 3
    hospital_general_medical_16coordinate—0%Not Available0.460.52881
    hospital_general_medical_17categorical—0%Not Available100% YesNoof 3
    medical_office_gross_floortext—0%Not Available20005000
    medical_office_mri_machinecoordinate—0%Not Available00.00496of 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 Available102571163000
    urgent_care_clinic_othertext—0%Not Available22002000
    k_12_school_gross_floor_areatext—0%Not Available106800110400
    laboratory_gross_floor_areacategorical—0%Not Available360423324505of 8
    library_gross_floor_areatext—0%Not Available1200025785
    mailing_center_post_officecategorical—0%Not Available100002372of 7
    manufacturing_industrialtext—0%Not Available7200052000
    movie_theater_gross_floorcategorical—0%Not Available6179870000of 11
    multifamily_housing_grosstext—0%Not Available7000060000
    multifamily_housing_governmentcategorical—0%Not AvailableNo100% Yesof 3
    multifamily_housing_numbertext—0%Not Available90100
    multifamily_housing_number_1text—0%Not Available010
    multifamily_housing_number_2text—0%Not Available04
    multifamily_housing_totaltext—0%Not Available6072
    multifamily_housing_percenttext—0%Not Available1000
    multifamily_housing_percent_1text—0%100Not Available90
    multifamily_housing_residentcategorical—0%Not AvailableNo specific resident pop…Dedicated Senior/Indepen…of 7
    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%Not Available060
    multifamily_housing_number_7coordinate—0%Not Available01.2
    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 Available01
    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_fttext—0%Not Available11000013022
    non_refrigerated_warehousetext—0%Not Available5000053000
    other_gross_floor_area_fttext—0%Not Available500010000
    other_weekly_operating_hourstext—0%Not Available0168
    other_number_of_computerstext—0%Not Available01
    other_number_of_workers_ontext—0%Not Available02
    performing_arts_gross_floortext—0%Not Available107229292620
    personal_services_healthtext—0%Not Available18751230
    pre_school_daycare_grosstext—0%Not Available2000027000
    race_track_gross_floor_areatext—0%Not Availableof 1
    refrigerated_warehouse_grosstext—0%Not Available14870021800
    repair_services_vehicle_shoetext—0%Not Available8000020000
    residence_hall_dormitorytext—0%Not Available5900060000
    restaurant_gross_floor_areatext—0%Not Available30004000
    self_storage_facility_grosstext—0%Not Available42000400
    senior_care_community_grosstext—0%Not Available9780096000
    social_meeting_hall_grosstext—0%Not Available300005640
    strip_mall_gross_floor_areacategorical—0%Not Available6486814735of 11
    supermarket_grocery_grosstext—0%Not Available10001500
    transportation_terminalcategorical—0%Not Available90200143000of 4
    veterinary_office_gross_floorcategorical—0%Not Available2050014077of 3
    vocational_school_gross_floorcategorical—0%Not Available18507596of 3
    wholesale_club_supercentercategorical—0%Not Available6500085082of 9
    worship_facility_gross_floortext—0%Not Available60000241550
    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.5
    retail_store_number_of_walkcategorical—0%Not Available01of 19
    retail_store_number_of_opentext—0%Not Available01
    parking_gross_floor_areatext—0%Not Available010000
    parking_open_parking_lottext—0%Not Available010000
    hotel_gross_floor_area_fttext—0%Not Available1500001
    hotel_gym_fitness_centertext—0%Not Available0800
    hotel_room_density_numbercoordinate—0%Not Available1.951.04822
    hotel_worker_density_numbercoordinate—0%Not Available0.320.5
    hotel_percent_that_can_becategorical—0%Not Available10090of 13
    estimated_data_flag_1text—0%Not Availableof 1
    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%OkUnable to Check (not eno…Possible Issueof 3
    alert_property_has_no_usescategorical—0%OkPossible Issueof 2
    data_quality_checker_runcategorical—0%falsetrueof 2
    data_quality_checker_datedate—0%Not Available2016-04-252016-04-26
    default_valuescategorical—0%NoYesUnable to Check (not eno…of 3
    estimated_values_energycategorical—0%NoYesUnable to Check (not eno…of 3
    temporary_valuescategorical—0%NoYesof 2
    estimated_values_watercategorical—0%NoUnable to Check (not eno…Yesof 3
    property_gfa_self_reportedtext—0%700006000072000
    property_gfa_epa_calculatedtext—0%700006000072000
    property_gfa_epa_calculated_1text—0%700006000072000
    property_gfa_epa_calculated_2text—0%Not Available100005000
    water_current_datedate—9%2015-12-31Not Available2012-12-31
    water_use_all_water_sourcescoordinate—0%Not Available01848.4
    indoor_water_use_all_watercoordinate—0%Not Available09301.6
    indoor_water_intensity_allcoordinate—0%Not Available037.45
    outdoor_water_use_all_watercoordinate—0%Not Available8775.81377.1
    municipally_supplied_potablecoordinate—0%Not Available04903.5
    municipally_supplied_potable_1coordinate—0%Not Available01848.4
    municipally_supplied_potable_2coordinate—0%Not Available037.73
    municipally_supplied_potable_3coordinate—0%Not Available6768.82800.5
    generation_datedatetime—0%2016-07-31T17:07:58.0002016-07-31T17:08:48.0002016-07-31T17:07:52.000
    release_datedatetime—0%2016-05-31T14:27:18.0002016-07-31T17:10:33.0002016-05-31T18:25:20.000
    boroughcategorical—5%MANHATTANBROOKLYNQUEENSof 5
    latitudefloat—5%40.79057640.80756740.578497
    longitudefloat—5%-73.881894-73.958787-73.9349
    community_boardinteger—5%105108107
    council_districtinteger—5%431
    census_tractinteger—5%199337
    ntatext—5%Midtown-Midtown SouthUpper East Side-Carnegie…Upper West Side