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

r6ub-zhffEnvironment201 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.6 / 100

From a 500-row sample across 201 columns.

completeness99/ 25% weight
consistency92/ 20% weight
accuracy92/ 20% weight
timeliness33/ 15% weight
usability90/ 20% weight
  • · Very wide (201 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 2014 (Data for Calendar Year 2013)0.84
    joins onpostcodeyear_builtprimary_property_type_self+113

Geography

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

Open on the map →

Sample rows

property_idproperty_nameyear_endingenergy_star_scorecustom_property_id_1_idaddress_1address_2citystate_provincepostcodecountyproperty_floor_area_buildings
736511552012-12-31T00:00:00.0009110226311155 Avenue of the AmericasNot AvailableManhattanNew York10036NEW YORK686902

Columns

201 queryable · 201 profiled

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

FieldTypeDescriptionNullValues
property_idinteger—0%268909628052932721895
property_nametext—0%PROG: 2970 West 27th Str…1267-69 Sheridan Realty …DEPM 2048 - Luna Park
year_endingdatetime—0%2012-12-31T00:00:00.000of 1
energy_star_scoretext—0%01001
custom_property_id_1_id

Query this from your own app

GET /api/datasets/r6ub-zhff
GET /api/datasets/r6ub-zhff/quality
GET /api/datasets/r6ub-zhff/related
GET /api/columns?dataset=r6ub-zhff
  • Energy and Water Data Disclosure for Local Law 84 2016 (Data for Calendar Year 2015)0.80
    joins onpostcodeyear_builtprimary_property_type_self+107
  • Energy and Water Data Disclosure for Local Law 84 2017 (Data for Calendar Year 2016)0.80
    joins onpostcodeyear_builtprimary_property_type_self+107
  • Energy and Water Data Disclosure for Local Law 84 2012 (Data for Calendar Year 2011)0.80
    joins onpostcodeyear_builtnational_median_source_eui+31
  • Energy and Water Data Disclosure for Local Law 84 2019 (Data for Calendar Year 2018)0.78
    joins onpostcodeyear_builtprimary_property_type_self+104
  • Energy and Water Data Disclosure for Local Law 84 2015 (Data for Calendar Year 2014)0.78
    joins onpostcodeyear_builtprimary_property_type_self+108
  • Energy and Water Data Disclosure for Local Law 84 2020 (Data for Calendar Year 2019)0.77
    joins onpostcodeyear_builtprimary_property_type_self+102
  • Energy and Water Data Disclosure for Local Law 84 2011 (Data for Calendar Year 2010)0.77
    joins onpostcodecityfuel_oil_4_use_kbtu+29
    • 8139
    200
    2012-12-31T00:00:00.000
    90
    1037545
    200 East 42nd St.
    Not Available
    Manhattan
    New York
    10017
    NEW YORK
    384432
    86041142012-12-31T00:00:00.000851022667114 West 47th stNot AvailableManhattanNew York10036NEW YORK572369
    88417332012-12-31T00:00:00.000731037596733 Third AvenueNot AvailableManhattanNew York10017NEW YORK362578
    11809Conde Nast Building2012-12-31T00:00:00.0007310856824 Times SquareNot AvailableManhattanNew York10036NEW YORK1601977
    13286201/2052012-12-31T00:00:00.000671037549; 1037550201/205 East 42nd st.Not AvailableManhattanNew York10017NEW YORK762051
    17506wyckoff heights medical center2012-12-31T00:00:00.00067Not Available374 stockholmNot AvailablebrooklynNew York11237KINGS520000
    1025339425 Lexington Avenue2012-12-31T00:00:00.000731036162425 Lexington AveNot AvailableNew YorkNew York10017NEW YORK712924
    104270333789-New York Marriott Marquis Hotel2012-12-31T00:00:00.0004210247271535 BroadwayNot AvailableNew York CityNew York10036NEW YORK2390114
    1045358320 Park Avenue2012-12-31T00:00:00.000791035464320 Park AvenueNot AvailableNew YorkNew York10022NEW YORK721979

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

    text
    —
    0%
    Not Available44394125106890
    address_1text—0%NA1919 Williamsbridge Road8000 Utopia Parkway
    address_2text—0%Not AvailableMultiple Addresses-SB-230
    citytext—0%New YorkBrooklynBronx
    state_provincetext—0%New Yorkof 1
    postcodeinteger—0%100011120110022
    countytext—0%NEW YORKKINGSQUEENS
    property_floor_area_buildingstext—0%06000070000
    year_builttext—0%192719281930
    primary_property_type_selftext—0%Multifamily HousingOfficeOther
    date_property_last_modifiedtext—0%26-APR-1323-APR-1329-APR-13
    service_and_product_providertext—0%NoneAurora Energy Advisors L…Bright Power
    energy_star_certificationcategorical—0%Not AvailableNoReviewed and Approvedof 5
    metered_areas_energytext—0%No Selection MadeWhole Facility Energy Co…Not Available
    energy_star_certification_1categorical—0%Not Eligible: Rating mus…Not AvailableEligibleof 11
    energy_star_certification_2text—0%No Status AvailableNot AvailableApplication - Label Sent…
    energy_star_certification_3text—0%Not Available20122011, 2012
    energy_star_certification_4text—0%Not Available14-SEP-1228-SEP-12
    target_energy_star_scorecategorical—0%0Not Available75of 18
    energy_alertstext—0%Not AvailableData > 120 days old<br>Less than 1 year of data…
    space_alertstext—0%"Multifamily Housing" sp…Not Available"Multifamily Housing" sp…
    direct_ghg_emissions_mtco2ecoordinate—0%Not Available10.20
    indirect_ghg_emissions_mtco2ecoordinate—0%Not Available3.8417.07
    total_ghg_emissions_mtco2ecoordinate—0%Not Available14.052670.37
    egrid_output_emissions_ratecoordinate—0%Not Available377.28184.11of 14
    energy_current_datetext—0%31-DEC-1231-JAN-1328-FEB-13
    water_current_datetext—0%31-DEC-1201-JAN-0031-MAR-13
    electricity_onsite_renewablecategorical—0%Not Available58845158690of 5
    electricity_sourced_fromcategorical—0%Not Available10028.36of 4
    avoided_emissions_offsitecoordinate—0%Not Available072.16
    onsite_renewable_systemcategorical—0%Not Available58845158690of 5
    green_power_offsite_kwhcoordinate—0%Not Available0151.88
    onsite_renewable_system_1text—0%Not Availableof 1
    site_eui_kbtu_ftcoordinate—0%Not Available074.8
    site_energy_use_kbtucoordinate—0%Not Available179634.546606142.8
    national_median_site_euitext—0%Not Available7068
    target_site_eui_kbtu_ftcoordinate—0%0Not Available46.7
    weather_normalized_site_euicoordinate—0%Not Available096.4
    electricity_use_grid_purchasetext—0%Not Available040944
    electricity_use_grid_purchase_1text—0%Not Available012000
    natural_gas_use_kbtutext—0%Not Available01968783
    natural_gas_use_thermstext—0%Not Available19687.821
    district_steam_use_kbtucoordinate—0%Not Available051270837.6
    fuel_oil_2_use_kbtucoordinate—0%Not Available0138690.5
    fuel_oil_4_use_kbtucoordinate—0%Not Available0138690.5
    fuel_oil_5_6_use_kbtucoordinate—0%Not Available01479518.45
    diesel_2_use_kbtucoordinate—0%Not Available0749067.39
    other_use_kbtutext—0%Not Available150772394681590
    district_chilled_water_usecategorical—0%0Not Available61580100of 3
    district_hot_water_use_kbtutext—0%Not Availableof 1
    estimated_data_flagcategorical—0%NoYesNot Availableof 5
    estimated_data_flag_1categorical—0%Not AvailableNoof 2
    estimated_data_flag_naturalcategorical—0%NoNot AvailableYesof 5
    estimated_data_flag_districtcategorical—0%Not AvailableNoYesof 4
    estimated_data_flag_fuelcategorical—0%Not AvailableNoYesof 5
    estimated_data_flag_fuel_1categorical—0%Not AvailableNoYesof 4
    estimated_data_flag_fuel_2categorical—0%Not AvailableNoYesof 4
    estimated_data_flag_dieselcategorical—0%Not AvailableNoof 2
    estimated_data_flag_othercategorical—0%Not AvailableNoYesof 3
    estimated_data_flag_district_1categorical—0%Not AvailableNoof 2
    estimated_data_flag_district_2categorical—0%Not AvailableNoof 2
    percent_better_than_nationalcoordinate—0%Not Available-24.9-24.2
    source_eui_kbtu_ftcoordinate—0%Not Available0119.4
    source_energy_use_kbtucoordinate—0%Not Available276830.448449801.6
    weather_normalized_sourcecoordinate—0%Not Available0120.1
    national_median_source_euitext—0%Not Available127164
    percent_better_than_national_1coordinate—0%Not Available-30.321.4
    bank_branch_gross_floor_areatext—0%Not Available50003000
    bank_branch_percent_thatcategorical—0%Not Available10025of 7
    bank_branch_computer_densitycoordinate—0%Not Available2.23.13
    bank_branch_weekly_operatingtext—0%Not Available6560
    bank_branch_worker_densitycoordinate—0%Not Available2.32.29
    bank_branch_number_of_workerstext—0%Not Available108
    hospital_general_medicaltext—0%Not Available65000647218
    hospital_general_medical_1categorical—0%Not Available01of 3
    hospital_general_medical_2categorical—0%Not Available01of 3
    hospital_general_medical_3text—0%Not Available515
    hospital_general_medical_4text—0%Not Available179987
    hospital_general_medical_5text—0%Not Available0200
    hospital_general_medical_6categorical—0%Not Available10of 6
    hotel_gross_floor_area_fttext—0%Not Available10000088000
    hotel_full_service_spa_floorcategorical—0%Not Available01200of 16
    hotel_gym_fitness_centertext—0%Not Available0400
    hotel_number_of_roomstext—0%Not Available135369
    hotel_room_density_numbercoordinate—0%Not Available1.951.42
    hotel_amount_of_laundrycategorical—0%Not AvailableNo laundry facilityBoth linens and terryof 6
    hotel_type_of_laundry_facilitytext—0%Not Available036500
    hotel_percent_that_can_becategorical—0%Not Available10090of 11
    hotel_cooking_facilitiescategorical—0%Not Available10of 4
    hotel_worker_density_numbercoordinate—0%Not Available0.320.35
    worship_facility_gross_floortext—0%Not Available600001021
    worship_facility_computercategorical—0%Not Available01of 5
    worship_facility_weeklytext—0%Not Available3340
    worship_facility_cookingcategorical—0%Not Available01of 3
    k_12_school_gross_floor_areatext—0%Not Available650008000
    k_12_school_high_schoolcategorical—0%Not Available01of 3
    k_12_school_weekend_operationcategorical—0%Not Available01of 3
    k_12_school_computer_densitycoordinate—0%Not Available1.750.63
    k_12_school_percent_thatcategorical—0%Not Available10090of 14
    k_12_school_refrigerationcoordinate—0%Not Available00.01of 18
    k_12_school_cooking_facilitiescategorical—0%Not Available10of 3
    medical_office_gross_floortext—0%Not Available50001000
    medical_office_number_oftext—0%Not Available24
    medical_office_percent_thattext—0%Not Available1000
    medical_office_weeklytext—0%Not Available6540
    multifamily_housing_grosstext—0%Not Available2744036096
    multifamily_housing_numbertext—0%Not Available020
    multifamily_housing_number_1text—0%Not Available06
    multifamily_housing_number_2text—0%0Not Available10
    multifamily_housing_governmentcategorical—0%0Not Available1of 10
    multifamily_housing_maximumtext—0%Not Available67
    multifamily_housing_number_3text—0%Not Available6066
    multifamily_housing_percenttext—0%Not Available0100
    multifamily_housing_percent_1text—0%Not Available1510
    multifamily_housing_number_4text—0%Not Available090
    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_gross_floor_area_fttext—0%Not Available10005000
    office_percent_that_can_betext—0%Not Available1000
    office_computer_density_numbercoordinate—0%Not Available2.20
    office_weekly_operating_hourstext—0%Not Available6540
    office_worker_density_numbercoordinate—0%Not Available2.30
    parking_completely_enclosedtext—0%Not Available05000
    parking_gross_floor_areatext—0%Not Available200005000
    parking_open_parking_lottext—0%Not Available03500
    parking_partially_enclosedtext—0%Not Available020000
    residence_hall_dormitorytext—0%Not Available5900060000
    residence_hall_dormitory_1categorical—0%Not Available1000of 18
    residence_hall_dormitory_2categorical—0%Not Available01of 8
    residence_hall_dormitory_3categorical—0%Not Available01of 11
    residence_hall_dormitory_4text—0%Not Available100200
    retail_store_gross_floortext—0%Not Available500010000
    retail_store_cash_registercoordinate—0%Not Available0.30
    retail_store_exterior_entrancecategorical—0%Not Available10of 4
    retail_store_worker_densitycoordinate—0%Not Available10
    retail_store_weekly_operatingtext—0%Not Available6560
    retail_store_walk_incoordinate—0%Not Available00.07
    retail_store_percent_thattext—0%Not Available1000
    retail_store_computer_densitycoordinate—0%Not Available0.20
    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
    senior_care_community_grosstext—0%Not Available20077697800
    senior_care_community_averagetext—0%Not Available200295
    senior_care_community_numbertext—0%Not Available65
    senior_care_community_number_1categorical—0%Not Available23of 17
    senior_care_community_number_2text—0%Not Available5020
    senior_care_community_number_3text—0%Not Available04
    senior_care_community_number_4text—0%Not Available04
    senior_care_community_percentcategorical—0%Not Available10090of 8
    senior_care_community_number_5text—0%Not Available200320
    senior_care_community_maximumtext—0%Not Available200240
    senior_care_community_number_6text—0%Not Available20250
    supermarket_grocery_grosstext—0%Not Available6001000
    supermarket_grocery_numbertext—0%Not Available015
    supermarket_grocery_number_1text—0%Not Available12
    supermarket_grocery_number_2text—0%Not Available01
    supermarket_grocery_percentcategorical—0%Not Available10070of 15
    supermarket_grocery_cookingcategorical—0%Not Available10of 5
    supermarket_grocery_walkcoordinate—0%Not Available0.250.19
    supermarket_grocery_weeklytext—0%Not Available168105
    supermarket_grocery_workercoordinate—0%Not Available10.75
    swimming_pool_approximatecategorical—0%Not AvailableRecreational (20 yards x…Short Course (25 yards x…of 6
    swimming_pool_location_ofcategorical—0%Not AvailableIndoorOutdoorof 4
    swimming_pool_months_in_usecategorical—0%Not Available120of 6
    refrigerated_warehouse_grosstext—0%Not Available80000952000
    refrigerated_warehouse_weeklycategorical—0%Not Available6040of 15
    refrigerated_warehouse_workercategorical—0%Not Available01of 7
    non_refrigerated_warehousetext—0%Not Available5000052000
    non_refrigerated_warehouse_1text—0%Not Available10050
    non_refrigerated_warehouse_2text—0%Not Available020
    non_refrigerated_warehouse_3categorical—0%Not Available00.01504of 4
    non_refrigerated_warehouse_4text—0%Not Available6040
    non_refrigerated_warehouse_5categorical—0%Not Available01of 11
    data_center_puetext—0%Not Availableof 1
    data_center_pdu_input_sitecategorical—0%Not Available142872575653.5of 6
    data_center_ups_output_sitecategorical—0%Not Available2286330.44024980.5of 19
    data_center_it_source_energycoordinate—0%Not Available1628180.726055204
    data_center_national_mediancategorical—0%Not Available1.82of 2
    data_center_gross_floor_areatext—0%Not Available05000
    data_center_it_site_energytext—0%Not Available01628181
    data_center_it_energycategorical—0%Not AvailableIT Energy is not current…Uninterruptible Power Su…of 7
    indoor_water_use_all_watertext—0%Not Available03772.3
    indoor_water_intensity_allcoordinate—0%Not Available054.91
    outdoor_water_use_all_watercoordinate—0%Not Available012196.9
    water_alertscategorical—0%Not AvailableThere is no water use fo…Less than 1 year of data…of 19
    generation_datedatetime—0%2013-05-31T10:04:11.0002013-04-21T13:51:51.0002013-05-31T22:52:03.000
    release_datedatetime—0%2013-06-10T04:39:48.0002013-06-17T07:12:30.0002013-05-30T05:49:08.000
    boroughcategorical—7%MANHATTANQUEENSBROOKLYNof 5
    latitudefloat—7%40.85279940.72560140.764149
    longitudefloat—7%-73.853325-73.791694-73.89144
    community_boardinteger—7%105108107
    council_districtinteger—7%436
    census_tractinteger—7%38633199
    bininteger—7%204855344624811000000
    bblinteger—7%204273002940702100012047120001
    ntatext—7%Midtown-Midtown SouthUpper East Side-Carnegie…Upper West Side