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

4tys-3tzjEnvironment253 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 253 columns.

completeness100/ 25% weight
consistency89/ 20% weight
accuracy92/ 20% weight
timeliness33/ 15% weight
usability90/ 20% weight
  • · Very wide (253 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 2018 (Data for Calendar Year 2017)0.93
    joins onretail_store_percent_thathotel_percent_that_can_bealert_energy_meter_has+249

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
73651155Not Applicable: Standalone PropertyNot Applicable: Standalone Property2018-12-31T00:00:00.000100997002910226311155 Avenue of the AmericasNot AvailableManhattanNot Available

Columns

253 queryable · 253 profiled

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

FieldTypeDescriptionNullValues
property_idinteger—0%402123939578884128950
property_nametext—0%RXR- 470 Vanderbilt61 BroadwayRXR Realty LLC 450 Lexin…
parent_property_idtext—0%Not Applicable: Standalo…36126783616399
parent_property_nametext—0%Not Applicable: Standalo…Columbia University (mor…

Query this from your own app

GET /api/datasets/4tys-3tzj
GET /api/datasets/4tys-3tzj/quality
GET /api/datasets/4tys-3tzj/related
GET /api/columns?dataset=4tys-3tzj
  • Energy and Water Data Disclosure for Local Law 84 2020 (Data for Calendar Year 2019)0.90
    joins onretail_store_percent_thatalert_energy_meter_hastemporary_values+228
  • Energy and Water Data Disclosure for Local Law 84 2017 (Data for Calendar Year 2016)0.89
    joins onretail_store_percent_thathotel_percent_that_can_betemporary_values+233
  • Energy and Water Data Disclosure for Local Law 84 2016 (Data for Calendar Year 2015)0.88
    joins onretail_store_percent_thathotel_percent_that_can_betemporary_values+218
  • Energy and Water Data Disclosure for Local Law 84 2015 (Data for Calendar Year 2014)0.85
    joins onretail_store_percent_thathotel_percent_that_can_betemporary_values+204
  • Energy and Water Data Disclosure for Local Law 84 2014 (Data for Calendar Year 2013)0.83
    joins onretail_store_percent_thathotel_percent_that_can_beborough+178
  • Energy and Water Data Disclosure for Local Law 84 2013 (Data for Calendar Year 2012)0.78
    joins onretail_store_percent_thathotel_percent_that_can_beborough+104
  • Energy and Water Data Disclosure for Local Law 84 2012 (Data for Calendar Year 2011)0.75
    joins onboroughother_weekly_operating_hoursparking_gross_floor_area+30
    • 10036
    8139200Not Applicable: Standalone PropertyNot Applicable: Standalone Property2018-12-31T00:00:00.00010131500011037545200 East 42nd St.Not AvailableManhattanNot Available10017
    8604114Not Applicable: Standalone PropertyNot Applicable: Standalone Property2018-12-31T00:00:00.00010099900191022667114 West 47th stNot AvailableManhattanNot Available10036
    8841733Not Applicable: Standalone PropertyNot Applicable: Standalone Property2018-12-31T00:00:00.00010131900471037596733 Third AvenueNot AvailableManhattanNot Available10017
    11809Conde Nast BuildingNot Applicable: Standalone PropertyNot Applicable: Standalone Property2018-12-31T00:00:00.000100995000510856824 Times SquareNot AvailableManhattanNot Available10036
    13286201/20513286201/2052018-12-31T00:00:00.00010131600011037549201/205 East 42nd st.Not AvailableManhattanNot Available10017
    28400NYP Columbia (West Campus)28400NYP Columbia (West Campus)2018-12-31T00:00:00.0001021380040; 1021380030; 1021390001; 1021390085; 10213602451084198; 1084387;1084385; 1084386; 1084388; 1084389; 1807867; 1809824; 1063380; 1087281; 1076746; 1813204; 1063403; 1063347622 168th StreetNot AvailableNew YorkNew York10032
    28402NYP Cornell (East Campus)28402NYP Cornell (East Campus)2018-12-31T00:00:00.0001014800001; 10148200401084781; 1084780; 1081252525 East 68th StreetNot AvailableNew YorkNew York10021
    28404The Allen HospitalNot Applicable: Standalone PropertyNot Applicable: Standalone Property2018-12-31T00:00:00.0001-02244-010010650455141 BroadwayNot AvailableNew YorkNew York10034
    1045358320 Park AvenueNot Applicable: Standalone PropertyNot Applicable: Standalone Property2018-12-31T00:00:00.0001-01286-00351035464320 Park AvenueNot AvailableNew YorkNot Available10022

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

    New York University: Was…
    year_endingdatetime—0%2018-12-31T00:00:00.000of 1
    nyc_borough_block_and_lottext—0%Not Available10197300014076720002
    nyc_building_identificationtext—0%Not Available00000002000000
    address_1text—0%ClassifiedRikers Island410 West 118th Street
    address_2text—0%Not AvailableManhattanB-230
    citytext—0%New YorkBrooklynBronx
    countytext—0%Not AvailableNew YorkQueens
    postcodetext—0%104521122610011
    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%300006000036000
    _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 Available05000
    year_builtinteger—0%193119201930
    number_of_buildingsinteger—0%123
    occupancyinteger—0%1009590
    metered_areas_energycategorical—0%Whole BuildingNot AvailableAnother configurationof 11
    metered_areas_watercategorical—0%Not AvailableWhole BuildingAnother configurationof 6
    energy_star_scoretext—0%Not Available1001
    energy_star_certificationtext—0%Not Available20182018, 2017
    energy_star_certification_1date—0%Not Available08/09/201807/05/2018
    energy_star_certification_2categorical—0%NoYesNot Availableof 3
    site_eui_kbtu_ftcoordinate—0%Not Available72.482.7
    weather_normalized_site_euicoordinate—0%Not Available75.988.1
    national_median_site_euicoordinate—0%Not Available59.640.3
    difference_from_nationalcoordinate—0%Not Available0.85.9
    site_energy_use_kbtucoordinate—0%Not Available0899843.6
    weather_normalized_site_energycoordinate—0%Not Available0899843.6
    weather_normalized_sitecoordinate—0%Not Available3.94.2
    weather_normalized_site_1coordinate—0%0Not Available0.6
    source_eui_kbtu_ftcoordinate—0%Not Available157.4118.9
    weather_normalized_sourcecoordinate—0%Not Available108.5113.2
    national_median_source_euicoordinate—0%118.1112.989.3
    difference_from_national_1coordinate—0%Not Available0.85.9
    source_energy_use_adjustedcoordinate—0%Not Available020134153.5
    source_energy_use_kbtucoordinate—0%Not Available01242251.2
    weather_normalized_source_1coordinate—0%Not Available01242251.2
    fuel_oil_1_use_kbtucoordinate—0%Not Available05940305.6of 8
    fuel_oil_2_use_kbtutext—0%Not Available0276000
    fuel_oil_4_use_kbtutext—0%Not Available0292000
    fuel_oil_5_6_use_kbtutext—0%Not Available0150
    diesel_2_use_kbtutext—0%Not Available014322605.8
    kerosene_use_kbtutext—0%Not Availableof 1
    propane_use_kbtucategorical—0%Not Available016386670.8of 3
    district_steam_use_kbtucoordinate—0%Not Available011136473.5
    district_hot_water_use_kbtucoordinate—0%Not Available39537998.4247211817.5of 4
    district_chilled_water_usetext—0%Not Available11780.9545501
    natural_gas_use_kbtutext—0%Not Available0823300
    weather_normalized_site_2text—0%Not Available07298.9
    electricity_use_grid_purchasecoordinate—0%Not Available0169951.6
    electricity_use_grid_purchase_1text—0%Not Available049810
    weather_normalized_site_3text—0%Not Available049810
    electricity_use_grid_purchase_2text—0%Not Available0169951.6
    electricity_use_generatedcoordinate—0%Not Available34126824
    electricity_use_generated_1text—0%Not Available10002000
    electricity_use_generated_2text—0%Not Available037874.9
    annual_maximum_demand_kwtext—0%Not Available0200
    annual_maximum_demand_mmcategorical—0%Not Available09/201806/2018of 13
    annual_maximum_demand_metertext—0%Not Available483127163712018- Meter N…2403 SOUTHERN BLVD ENTM …
    green_power_onsite_kwhtext—0%Not Available10000
    green_power_offsite_kwhcategorical—0%0Not Available11280of 14
    avoided_emissions_onsitetext—0%Not Available00.5
    avoided_emissions_offsitecoordinate—0%0Not Available1402.7of 14
    total_ghg_emissions_metriccoordinate—0%Not Available053.2
    direct_ghg_emissions_metriccoordinate—0%0Not Available0.1
    indirect_ghg_emissions_metriccoordinate—0%0Not Available49.9
    national_median_total_ghgcoordinate—0%Not Available3.755
    estimated_data_flagcategorical—0%NoNot AvailableYesof 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%84.7Not Available215.7of 8
    net_emissions_metric_tonscoordinate—0%0Not Available53.2
    percent_of_electricity_thatcoordinate—0%0Not Available100
    percent_of_recs_retainedcategorical—0%Not Available1000of 3
    percent_of_total_electricitycoordinate—0%Not Available10.7405415.57495
    costar_property_idcategorical—0%Not Available157986of 2
    leed_us_project_idtext—0%Not Available10000388221000027489
    ambulatory_surgical_centercategorical—0%Not Available13490534472of 5
    automobile_dealership_grosscategorical—0%Not Available376108331of 17
    bank_branch_gross_floor_areatext—0%Not Available500010000
    bank_branch_number_oftext—0%Not Available1015
    college_university_grosstext—0%Not Available4800069781
    college_university_numbertext—0%Not Available10050
    convention_center_gross_floortext—0%Not Availableof 1
    courthouse_gross_floor_areatext—0%Not Available19395322300
    data_center_gross_floor_areatext—0%Not Available1450600
    data_center_pdu_input_metercategorical—0%Not Available01042296of 4
    data_center_pdu_output_metercategorical—0%Not Available0of 2
    data_center_it_equipmentcategorical—0%Not Available0of 2
    data_center_it_site_energycoordinate—0%Not Available195838.8182515.2
    data_center_it_source_energycoordinate—0%Not Available1743677.51870965.3
    data_center_puecoordinate—0%Not Available13.622.14of 4
    data_center_national_mediancategorical—0%Not Available21.9of 3
    data_center_ups_output_metercoordinate—0%Not Available0195838.8
    data_center_cooling_equipmentcategorical—0%Not AvailableN+1Nof 9
    data_center_it_energycategorical—0%Not AvailableUninterruptible Power Su…No IT Energy Configurati…of 8
    data_center_ups_systemcategorical—0%Not AvailableN+1Nof 10
    distribution_center_grosstext—0%Not Available3000026000
    enclosed_mall_gross_floorcategorical—0%Not Available536000723221of 12
    energy_power_station_grosscategorical—0%Not Available311000of 2
    financial_office_gross_floortext—0%Not Available50000
    financial_office_number_oftext—0%Not Available1012
    financial_office_number_of_1text—0%Not Available1015
    financial_office_weeklytext—0%Not Available6560
    financial_office_computercoordinate—0%Not Available24.21315
    fitness_center_health_clubtext—0%Not Available350013000
    food_sales_gross_floor_areatext—0%Not Available76501500
    food_service_gross_floortext—0%Not Available029601
    hospital_general_medicaltext—0%Not Available7458375
    hospital_general_medical_1coordinate—0%Not Available2.62.73324
    hospital_general_medical_2text—0%Not Available2971874137200
    hospital_general_medical_3categorical—0%Not Available100% YesNoof 3
    hospital_general_medical_4text—0%Not Available100844
    hospital_general_medical_5coordinate—0%Not Available0.690.69002
    hospital_general_medical_6coordinate—0%Not Available00.00729
    hospital_general_medical_7categorical—0%Not Available12of 9
    hospital_general_medical_8text—0%Not Available080
    hospital_general_medical_9coordinate—0%Not Available1.321.32002
    hospital_general_medical_10categorical—0%Not Available10080of 3
    hospital_general_medical_11categorical—0%Not Available10080of 3
    hospital_general_medical_12coordinate—0%Not Available0.460.45999
    medical_office_gross_floortext—0%Not Available50002000
    medical_office_number_ofcategorical—0%Not Available01of 8
    medical_office_number_of_1text—0%Not Available36
    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 Available22152540503
    urgent_care_clinic_othertext—0%Not Available22004000
    k_12_school_gross_floor_areatext—0%Not Available110400106800
    laboratory_gross_floor_areatext—0%Not Available33181132500
    mailing_center_post_officecategorical—0%Not Available25005400of 12
    manufacturing_industrialtext—0%Not Available3000037500
    movie_theater_gross_floortext—0%Not Available6179895300
    multifamily_housing_grosstext—0%Not Available3600032000
    multifamily_housing_governmentcategorical—0%Not AvailableNo100% Yesof 3
    multifamily_housing_numbertext—0%Not Available60100
    multifamily_housing_number_1text—0%Not Available05
    multifamily_housing_number_2text—0%Not Available04
    multifamily_housing_totaltext—0%Not Available4860
    multifamily_housing_percenttext—0%Not Available1000
    multifamily_housing_percent_1text—0%Not Available10090
    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.21
    multifamily_housing_number_4text—0%0Not Available60
    multifamily_housing_number_5coordinate—0%0Not Available0.80882
    multifamily_housing_number_6text—0%Not Available060
    multifamily_housing_number_7coordinate—0%Not Available01
    office_gross_floor_area_fttext—0%Not Available01000
    office_number_of_computerstext—0%Not Available010
    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
    museum_gross_floor_area_fttext—0%Not Available110000140000
    non_refrigerated_warehousetext—0%Not Available4000030000
    other_gross_floor_area_fttext—0%Not Available100004000
    other_weekly_operating_hourstext—0%Not Available060
    other_number_of_computerstext—0%Not Available01
    other_number_of_workers_ontext—0%Not Available05
    other_computer_density_numbercoordinate—0%Not Available01
    performing_arts_gross_floortext—0%Not Available4000095436
    pre_school_daycare_grosstext—0%Not Available250009000
    supermarket_grocery_grosstext—0%Not Available50001200
    refrigerated_warehouse_grosstext—0%Not Available7000025000
    repair_services_vehicle_shoetext—0%Not Available8000027000
    residence_hall_dormitorytext—0%Not Available2804840463
    restaurant_gross_floor_areatext—0%Not Available30002000
    self_storage_facility_grosstext—0%Not Available45000146860
    senior_care_community_grosstext—0%Not Available6426097800
    social_meeting_hall_grosstext—0%Not Available503250000
    wholesale_club_supercentercategorical—0%Not Available128995111000of 18
    worship_facility_gross_floortext—0%Not Available500040000
    retail_store_gross_floortext—0%Not Available500010000
    restaurant_worker_densitycoordinate—0%Not Available01
    restaurant_weekly_operatingtext—0%Not Available7080
    retail_store_walk_incoordinate—0%Not Available00.2
    retail_store_percent_thattext—0%Not Available10090
    retail_store_open_or_closedcoordinate—0%Not Available00.2
    retail_store_number_of_walkcategorical—0%Not Available01of 18
    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 Available20000060270
    hotel_gym_fitness_centertext—0%Not Available0400
    hotel_room_density_numbercoordinate—0%Not Available1.952.81512
    hotel_worker_density_numbercoordinate—0%Not Available0.320.31999
    hotel_percent_that_can_becategorical—0%Not Available10090of 10
    estimated_data_flag_1categorical—0%Not AvailableNoYesof 3
    alert_data_center_issue_withcategorical—0%OkPossible Issueof 2
    alert_gross_floor_area_iscategorical—0%OkUnable to Check (not eno…Possible Issueof 3
    alert_energy_meter_has_singlecategorical—0%OkPossible IssueUnable to Check (not eno…of 3
    alert_energy_meter_hascategorical—0%OkUnable to Check (not eno…Possible Issueof 3
    alert_energy_meter_has_gapscategorical—0%OkUnable to Check (not eno…Possible Issueof 3
    alert_energy_meter_has_lesscategorical—0%OkPossible IssueUnable to Check (not eno…of 3
    alert_energy_no_meterscategorical—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 Available2019-04-302019-05-01
    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_reportedinteger—0%300006000036000
    property_gfa_calculatedtext—0%300003600060000
    property_gfa_calculated_1text—0%300003600060000
    property_gfa_calculated_2text—0%Not Available500010000
    water_current_datedate—0%12/31/2018Not Available12/31/2017
    water_use_all_water_sourcestext—0%Not Available050
    indoor_water_use_all_watercoordinate—0%Not Available050
    indoor_water_use_intensitycoordinate—0%Not Available034.41
    outdoor_water_use_all_watercoordinate—0%Not Available529.51893.4of 13
    municipally_supplied_potablecoordinate—0%Not Available0517.9
    municipally_supplied_potable_1coordinate—0%Not Available050
    water_use_intensity_all_watercoordinate—0%Not Available00.03
    municipally_supplied_potable_2coordinate—0%Not Available0.727372.7of 10
    water_score_multifamily_onlytext—0%Not Available12
    irrigated_area_fttext—0%0Not Available200
    third_party_certificationdate—0%Not Available07/13/201504/21/2017of 8
    third_party_certification_1categorical—0%Not AvailableLEEDEcoRooms and EcoSuitesof 3
    third_party_certification_2date—0%Not Available07/19/201707/13/2015of 8
    supermarket_grocery_opencoordinate—0%Not Available01
    convenience_store_with_gastext—0%Not Availableof 1
    convenience_store_with_gas_1text—0%Not Availableof 1
    senior_care_community_livingcoordinate—0%Not Available1.5840
    last_modified_date_propertydate—0%04/09/2019 02:10 PM EDT04/09/2019 04:47 PM EDT04/11/2019 11:58 AM EDT
    last_modified_date_electricdate—0%Not Available04/09/2019 04:45 PM EDT04/09/2019 02:08 PM EDT
    last_modified_date_gas_metersdate—0%Not Available04/09/2019 04:46 PM EDT04/09/2019 02:09 PM EDT
    last_modified_date_nondate—0%Not Available04/09/2019 02:10 PM EDT04/09/2019 04:47 PM EDT
    last_modified_date_waterdate—0%Not Available04/24/2019 04:30 PM EDT04/29/2019 09:08 AM EDT
    generation_datedatetime—0%2019-05-01T15:12:13.0002019-05-01T15:12:31.0002019-05-01T15:12:18.000
    release_datedatetime—0%2019-05-01T15:32:48.0002019-05-01T16:14:22.0002019-05-01T20:36:32.000
    boroughcategorical—3%MANHATTANBROOKLYNBRONXof 5
    latitudefloat—3%40.79057640.80756740.714413
    longitudefloat—3%-73.881894-73.958787-73.981437
    community_boardinteger—3%105108112
    council_districtinteger—3%431
    census_tractinteger—3%3319921
    ntatext—3%Midtown-Midtown SouthHudson Yards-Chelsea-Fla…Upper West Side