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

utpj-74fzEnvironment262 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.5 / 100

From a 500-row sample across 261 columns.

completeness100/ 25% weight
consistency92/ 20% weight
accuracy91/ 20% weight
timeliness33/ 15% weight
usability90/ 20% weight
  • · Very wide (261 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 2016 (Data for Calendar Year 2015)0.95
    joins onmedical_office_gross_floorambulatory_surgical_centerestimated_data_flag_natural+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
6215439Spring Creek GardensNot Applicable: Standalone PropertyNot Applicable: Standalone Property2016-12-31T00:00:00.0003-04516-75013323063901-903 Drew StreetNot AvailableBrooklynNot Available

Columns

262 queryable · 262 profiled

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

FieldTypeDescriptionNullValues
property_idinteger—0%245017526043544956286
property_nametext—0%Chez 66629 Ocean Pkwy22 East 36th St
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/utpj-74fz
GET /api/datasets/utpj-74fz/quality
GET /api/datasets/utpj-74fz/related
GET /api/columns?dataset=utpj-74fz
  • Energy and Water Data Disclosure for Local Law 84 2019 (Data for Calendar Year 2018)0.89
    joins onmedical_office_gross_floorambulatory_surgical_centerestimated_data_flag_natural+233
  • Energy and Water Data Disclosure for Local Law 84 2018 (Data for Calendar Year 2017)0.89
    joins onmedical_office_gross_floorambulatory_surgical_centerestimated_data_flag_natural+234
  • Energy and Water Data Disclosure for Local Law 84 2015 (Data for Calendar Year 2014)0.87
    joins onmedical_office_gross_floorambulatory_surgical_centerestimated_data_flag_natural+223
  • Energy and Water Data Disclosure for Local Law 84 2014 (Data for Calendar Year 2013)0.86
    joins onmedical_office_gross_floorambulatory_surgical_centerestimated_data_flag_natural+192
  • Energy and Water Data Disclosure for Local Law 84 2020 (Data for Calendar Year 2019)0.85
    joins onmedical_office_gross_floorambulatory_surgical_centerestimated_data_flag_natural+216
  • Energy and Water Data Disclosure for Local Law 84 2013 (Data for Calendar Year 2012)0.80
    joins onmedical_office_gross_floorestimated_data_flag_naturalhospital_general_medical_4+107
  • Energy and Water Data Disclosure for Local Law 84 2012 (Data for Calendar Year 2011)0.76
    joins onmedical_office_gross_floorparking_gross_floor_areaweather_normalized_site_eui+30
    • 11208
    3619765Castle Hill AveNot Applicable: Standalone PropertyNot Applicable: Standalone Property2016-12-31T00:00:00.0001-03573-00252021926604 Castle Hill AveNot AvailableBronxNot Available10473
    6202283STB044283 St Barnabas Nursing Home 4428 3rd AveNot Applicable: Standalone PropertyNot Applicable: Standalone Property2016-12-31T00:00:00.0002-03064-001020942214428 3rd AveNot AvailableBronxNot Available10457
    6202292STB044003 St Barnabas Parking 4400 3rd AveNot Applicable: Standalone PropertyNot Applicable: Standalone Property2016-12-31T00:00:00.0002-03064-010021182364400 3rd AveNot AvailableBronxNot Available10457
    6202301STB044873 St Barnabas Clinic 4487 3rd AveNot Applicable: Standalone PropertyNot Applicable: Standalone Property2016-12-31T00:00:00.0002-03051-004520115944487 3rd AvenueNot AvailableBronxNot Available10457
    6213457STB00260E 260 E 188th StreetNot Applicable: Standalone PropertyNot Applicable: Standalone Property2016-12-31T00:00:00.0002-03147-00502013469260 East 188th StreetNot AvailableBronxNot Available10458
    62139423321 Bruckner BoulevardNot Applicable: Standalone PropertyNot Applicable: Standalone Property2016-12-31T00:00:00.0002-05403-002520749293321 Bruckner BoulevardNot AvailableBronxNot Available10461
    3114580Carnegie ParkNot Applicable: Standalone PropertyNot Applicable: Standalone Property2016-12-31T00:00:00.0001-01539-7502;1-01539-00081089344;1048916;1089343;1089342200 East 94th StreetNot AvailableNew YorkNot Available10128
    6172163Urban-SERS Sheffield, LLCNot Applicable: Standalone PropertyNot Applicable: Standalone Property2016-12-31T00:00:00.00030375300083336123360 Belmont AvenueNot AvailableBrooklynNot Available11207
    5819664Brookdale Center CardozoNot Applicable: Standalone PropertyNot Applicable: Standalone Property2016-12-31T00:00:00.0001-00570-7501100937355 Fifth AveNot Availablenew yorkNot Available10003

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

    year_endingdatetime—0%2016-12-31T00:00:00.000of 1
    nyc_borough_block_and_lottext—0%Not Available10197300013087600060
    nyc_building_identificationtext—0%Not Available00000004455379
    count_of_buildingstext—99%153
    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 YorkKings
    postcodetext—0%100011001610022
    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%700006000050000
    _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_buildingsinteger—0%123
    occupancyinteger—0%1009590
    metered_areas_energycategorical—0%Whole BuildingNot AvailableAnother configurationof 12
    metered_areas_watercategorical—0%Not AvailableWhole BuildingAnother configurationof 8
    energy_star_scoretext—0%Not Available1001
    national_median_energy_starinteger—0%50of 1
    energy_star_certificationtext—0%Not Available20162016, 2015
    energy_star_certification_1date—0%Not Available01/12/201510/12/2016
    energy_star_certification_2categorical—0%NoYesof 2
    site_eui_kbtu_fttext—0%Not Available90.769.4
    weather_normalized_site_euicoordinate—0%Not Available97.974.3
    national_median_site_euitext—0%Not Available59.667.3
    difference_from_nationalcoordinate—0%Not Available-18.7-14.4
    site_energy_use_kbtucoordinate—0%Not Available01140862.4
    weather_normalized_site_energytext—0%Not Available01233892
    source_energy_use_kbtucoordinate—0%Not Available01601397.5
    national_median_site_energycoordinate—0%Not Available991143.21069935.7
    weather_normalized_sitecoordinate—0%Not Available44.1
    weather_normalized_site_1coordinate—0%0Not Available0.6
    weather_normalized_sourcecoordinate—0%Not Available0128.7
    national_median_source_euicoordinate—0%127.9119.3123.1
    difference_from_national_1coordinate—0%Not Available-18.7-14.4
    source_energy_use_adjustedcoordinate—0%Not Available018862956.7
    weather_normalized_source_1coordinate—0%Not Available01688904.6
    national_median_source_energycoordinate—0%Not Available1391240.81554351.8
    fuel_oil_1_use_kbtucoordinate—0%Not Available01097539.9of 17
    fuel_oil_2_use_kbtutext—0%Not Available0276000
    fuel_oil_4_use_kbtucoordinate—0%Not Available0292000
    fuel_oil_5_6_use_kbtucoordinate—0%Not Available0450000
    diesel_2_use_kbtutext—0%Not Available0138000
    kerosene_use_kbtutext—0%Not Availableof 1
    propane_use_kbtutext—0%Not Availableof 1
    district_steam_use_kbtucoordinate—0%Not Available10208293.60
    district_hot_water_use_kbtucategorical—0%Not Available10680199.660474599.1of 3
    district_chilled_water_usecoordinate—0%Not Available8738124.1738000
    natural_gas_use_kbtutext—0%Not Available0947804
    weather_normalized_site_2text—0%Not Available010457
    electricity_use_grid_purchasecoordinate—0%Not Available0193058.4
    weather_normalized_site_3coordinate—0%Not Available055155.5
    electricity_use_grid_purchase_1coordinate—0%Not Available0193058.4
    electricity_use_generatedcoordinate—0%Not Available3509.37826.2
    electricity_use_generated_1text—0%Not Available1028.52293.7
    electricity_use_generated_2coordinate—0%Not Available0179132.1of 15
    green_power_onsite_kwhtext—0%Not Available01028.5
    green_power_offsite_kwhcategorical—0%0Not Available563216of 16
    avoided_emissions_onsitecoordinate—0%Not Available00.5
    avoided_emissions_offsitecoordinate—0%0Not Available207.6of 16
    total_ghg_emissions_metriccoordinate—0%Not Available068.3
    direct_ghg_emissions_metrictext—0%0Not Available50.3
    indirect_ghg_emissions_metriccoordinate—0%0Not Available103.7
    national_median_total_ghgcoordinate—0%Not Available59.365
    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%92.888.7Not Availableof 9
    net_emissions_metric_tonscoordinate—0%0Not Available68.3
    percent_of_electricity_thatcoordinate—0%0Not Available19.38122
    percent_of_recs_retainedcategorical—0%Not Available1000of 4
    percent_of_total_electricitycoordinate—0%Not Available1004.244281
    difference_from_national_2text—0%Not Availableof 1
    costar_property_idtext—0%Not Availableof 1
    leed_us_project_idtext—0%Not Available10000011641000058011
    date_property_last_modifieddate—0%08/07/2016 09:10 PM EDT08/07/2016 09:11 PM EDT08/07/2016 09:13 PM EDT
    adult_education_gross_floorcategorical—0%Not Available118003100of 10
    ambulatory_surgical_centercategorical—0%Not Available13490534472of 4
    automobile_dealership_grosscategorical—0%Not Available83318520of 8
    bank_branch_gross_floor_areatext—0%Not Available30003800
    bank_branch_number_oftext—0%Not Available1510
    college_university_grosstext—0%Not Available865001809
    college_university_numbertext—0%Not Available50250
    convenience_store_with_gastext—0%Not Availableof 1
    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 Available01315733of 4
    data_center_pdu_output_metercategorical—0%Not Available0of 2
    data_center_it_equipmentcategorical—0%Not Available0of 2
    data_center_it_site_energytext—0%Not Available01187246.8
    data_center_it_source_energytext—0%Not Available012719781.8
    data_center_puetext—0%Not Availableof 1
    data_center_national_mediancategorical—0%Not Available1.8of 2
    data_center_ups_output_metertext—0%Not Available017744292.8
    data_center_cooling_equipmentcategorical—0%Not AvailableN+1Nof 8
    data_center_it_energycategorical—0%Not AvailableUninterruptible Power Su…Facility Has No UPSof 7
    data_center_ups_systemcategorical—0%Not AvailableN+1Nof 10
    distribution_center_grosstext—0%Not Available10700048000
    enclosed_mall_gross_floorcategorical—0%Not Available5360002662400of 13
    energy_power_station_grosscategorical—0%Not Available1600of 2
    fast_food_restaurant_grosstext—0%Not Available10002000
    financial_office_gross_floortext—0%Not Available50000
    financial_office_number_oftext—0%Not Available1012
    financial_office_number_of_1text—0%Not Available108
    financial_office_weeklytext—0%Not Available6550
    fitness_center_health_clubtext—0%Not Available1300030054
    food_sales_gross_floor_areatext—0%Not Available50002500
    food_service_gross_floortext—0%Not Available180021524
    hospital_general_medicaltext—0%Not Available1119.77192.81
    hospital_general_medical_1coordinate—0%Not Available2.62.59999
    hospital_general_medical_2text—0%Not Available567517927982
    hospital_general_medical_3categorical—0%Not AvailableNo100% Yesof 3
    hospital_general_medical_4coordinate—0%Not Available297.1751.17
    hospital_general_medical_5coordinate—0%Not Available0.690.69001
    hospital_general_medical_6categorical—0%Not Available56of 16
    hospital_general_medical_7coordinate—0%Not Available00.00176
    hospital_general_medical_8categorical—0%Not Available12of 6
    hospital_general_medical_9text—0%Not Available198.11206
    hospital_general_medical_10coordinate—0%Not Available568.5408.31
    hospital_general_medical_11coordinate—0%Not Available1.321.32001
    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.45999
    hospital_general_medical_17categorical—0%Not Available100% YesNoof 3
    medical_office_gross_floortext—0%Not Available20005000
    medical_office_mri_machinecoordinate—0%Not Available00.1of 12
    medical_office_number_ofcategorical—0%Not Available01of 6
    medical_office_number_of_1text—0%Not Available23
    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 Available18152030
    urgent_care_clinic_othertext—0%Not Available22002000
    k_12_school_gross_floor_areatext—0%Not Available110400106800
    laboratory_gross_floor_areacategorical—0%Not Available180000517490of 11
    library_gross_floor_areatext—0%Not Available1200041938
    mailing_center_post_officecategorical—0%Not Available23721412of 9
    manufacturing_industrialtext—0%Not Available5200072000
    movie_theater_gross_floorcategorical—0%Not Available6179823400of 8
    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 Available6066
    multifamily_housing_percenttext—0%Not Available0100
    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.21
    multifamily_housing_number_4text—0%0Not Available60
    multifamily_housing_number_5coordinate—0%0Not Available0.99587
    multifamily_housing_number_6text—0%Not Available060
    multifamily_housing_number_7coordinate—0%Not Available01.2
    other_computer_density_numbercoordinate—0%Not Available01
    office_gross_floor_area_fttext—0%Not Available10000
    office_number_of_computerstext—0%Not Available02
    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 Available11000070000
    non_refrigerated_warehousetext—0%Not Available5000053000
    other_gross_floor_area_fttext—0%Not Available100003000
    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 Available292620685050
    pre_school_daycare_grosstext—0%Not Available2500027000
    supermarket_grocery_numbertext—0%Not Available10
    refrigerated_warehouse_grosstext—0%Not Available12000120200
    repair_services_vehicle_shoetext—0%Not Available2000080000
    residence_hall_dormitorytext—0%Not Available5900075000
    restaurant_gross_floor_areatext—0%Not Available30006000
    self_storage_facility_grosstext—0%Not Available4938042000
    senior_care_community_grosstext—0%Not Available288790273882
    social_meeting_hall_grosstext—0%Not Available3000036536
    supermarket_grocery_grosstext—0%Not Available10001200
    wholesale_club_supercentercategorical—0%Not Available6500010565of 11
    worship_facility_gross_floortext—0%Not Available15000028086
    retail_store_gross_floortext—0%Not Available500010000
    restaurant_worker_densitytext—0%Not Available02
    restaurant_weekly_operatingtext—0%Not Available6584
    retail_store_walk_incoordinate—0%Not Available00.2
    retail_store_percent_thattext—0%Not Available1000
    retail_store_open_or_closedcoordinate—0%Not Available00.5
    retail_store_number_of_walktext—0%Not Available01
    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 Available200000150000
    hotel_gym_fitness_centertext—0%Not Available0800
    hotel_room_density_numbercoordinate—0%Not Available1.952.20161
    hotel_worker_density_numbercoordinate—0%Not Available0.320.5
    hotel_percent_that_can_becategorical—0%Not Available10090of 11
    estimated_data_flag_1categorical—0%Not AvailableNoof 2
    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 IssueNot Availableof 4
    alert_meter_has_overlapscategorical—0%OkNot AvailableUnable to Check (not eno…of 4
    alert_meter_has_gapscategorical—0%OkNot AvailableUnable to Check (not eno…of 4
    alert_meter_has_less_thancategorical—0%OkPossible IssueNot Availableof 4
    alert_no_meters_are_associatedcategorical—0%OkPossible IssueNot Availableof 3
    alert_property_has_no_usescategorical—0%OkPossible Issueof 2
    data_quality_checker_runcategorical—0%NoYesof 2
    data_quality_checker_datedate—0%Not Available2017-04-282017-04-27
    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%700006000080000
    property_gfa_calculatedtext—0%700006000050000
    property_gfa_calculated_1text—0%700006000080000
    property_gfa_calculated_2text—0%Not Available100005000
    water_current_datedate—0%12/31/2016Not Available12/31/2012
    water_use_all_water_sourcescoordinate—0%Not Available01538.7
    indoor_water_use_all_watercoordinate—0%Not Available01538.7
    indoor_water_use_intensitycoordinate—0%Not Available00.04
    outdoor_water_use_all_watercoordinate—0%Not Available6987.6441.5
    municipally_supplied_potablecoordinate—0%Not Available06660.2
    municipally_supplied_potable_1coordinate—0%Not Available01538.7
    water_use_intensity_all_watercoordinate—0%Not Available00.04
    municipally_supplied_potable_2coordinate—0%Not Available1427.82577.7
    third_party_certificationdate—0%Not Available07/01/201105/16/2016of 6
    third_party_certification_1categorical—0%Not AvailableLEEDEcoRooms and EcoSuitesof 3
    third_party_certification_2date—0%Not Available07/01/201107/13/2015of 6
    supermarket_grocery_opencoordinate—0%Not Available00.25
    convenience_store_with_gas_1text—0%Not Availableof 1
    convenience_store_with_gas_2text—0%Not Availableof 1
    financial_office_computercoordinate—0%Not Available23
    senior_care_community_livingcoordinate—0%Not Available1.5841.16839
    source_eui_kbtu_ftcoordinate—0%Not Available147.30
    difference_from_national_3text—0%Not Availableof 1
    source_eui_adjusted_to_currentcoordinate—0%Not Available118.2107.7
    office_computer_density_numbertext—0%Not Available20
    generation_datedatetime—0%2017-05-01T14:56:25.0002017-05-01T14:56:30.0002017-05-01T14:56:20.000
    release_datedatetime—0%2017-05-01T11:58:23.0002017-05-01T14:58:14.0002017-05-01T19:43:09.000
    boroughcategorical—4%MANHATTANBROOKLYNQUEENSof 5
    latitudefloat—4%40.79057640.80756740.578497
    longitudefloat—4%-73.881894-73.958787-73.937404
    community_boardinteger—4%105108107
    council_districtinteger—4%431
    census_tractinteger—4%199337
    ntatext—4%Midtown-Midtown SouthHudson Yards-Chelsea-Fla…Upper East Side-Carnegie…