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

4t62-jm4mEnvironment256 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

D62.4 / 100

From a 500-row sample across 239 columns.

completeness40/ 25% weight
consistency61/ 20% weight
accuracy87/ 20% weight
timeliness32/ 15% weight
usability90/ 20% weight
  • · Very wide (239 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.93
    joins onannual_maximum_demand_kwegrid_output_emissions_rateproperty_gfa_calculated_1+249

Geography

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

Open on the map →

Sample rows

property_idyear_endinggeneration_dateaccount_idproperty_id_1property_namenyc_borough_block_and_lotnyc_building_identificationaddress_1citypostcodeprimary_property_type_self
45935742017-12-31T00:00:00.0002018-02-14T00:00:00.0001298584593574The Argonaut Building10102875021024898224 West 57th StNew York10019Office

Columns

256 queryable · 256 profiled

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

FieldTypeDescriptionNullValues
property_idinteger—0%312239026907722271551
year_endingdatetime—0%2017-12-31T00:00:00.000of 1
generation_datedatetime—0%2018-05-29T00:00:00.0002019-02-14T00:00:00.0002019-02-15T00:00:00.000
account_idinteger—0%46451445651383
property_id_1

Query this from your own app

GET /api/datasets/4t62-jm4m
GET /api/datasets/4t62-jm4m/quality
GET /api/datasets/4t62-jm4m/related
GET /api/columns?dataset=4t62-jm4m
  • Energy and Water Data Disclosure for Local Law 84 2017 (Data for Calendar Year 2016)0.89
    joins onegrid_output_emissions_rateproperty_gfa_calculated_1postcode+234
  • Energy and Water Data Disclosure for Local Law 84 2016 (Data for Calendar Year 2015)0.85
    joins onegrid_output_emissions_ratepostcodemetered_areas_water+219
  • Energy and Water Data Disclosure for Local Law 84 2020 (Data for Calendar Year 2019)0.84
    joins onannual_maximum_demand_kwegrid_output_emissions_rateproperty_gfa_calculated_1+227
  • Energy and Water Data Disclosure for Local Law 84 2015 (Data for Calendar Year 2014)0.83
    joins onegrid_output_emissions_ratepostcodeenergy_star_certification_1+205
  • Energy and Water Data Disclosure for Local Law 84 2014 (Data for Calendar Year 2013)0.80
    joins onegrid_output_emissions_ratepostcodeenergy_star_certification_1+179
  • Energy and Water Data Disclosure for Local Law 84 2013 (Data for Calendar Year 2012)0.75
    joins onegrid_output_emissions_ratepostcodeenergy_star_certification_1+103
  • Energy and Water Data Disclosure for Local Law 84 2012 (Data for Calendar Year 2011)0.75
    joins onpostcodek_12_school_gross_floor_areaborough+29
    • 62243752017-12-31T00:00:00.0002018-02-14T00:00:00.000741756224375Operative Cakes2-00560-0062;2-05560-00622087721;2080293711-733 Brush AvenueBronx10465Non-Refrigerated Warehouse
    29677012017-12-31T00:00:00.0002018-02-14T00:00:00.00087602967701Cathedral Preparatory Seminary4-01872-0007404634056-25 92nd StreetFlushing11373K-12 School
    48985312017-12-31T00:00:00.0002018-02-14T00:00:00.00087604898531The Nomad Hotel1-00829-005010807101170 BroadwayNew York10001-7507Hotel
    29179392017-12-31T00:00:00.0002018-02-14T00:00:00.00012272291793910 West 27 Street Corp1-00828-005310156571155 BroadwayNew York10001Hotel
    38782052017-12-31T00:00:00.0002018-02-14T00:00:00.000122723878205Westbury Realty1-00065-0024100110524 John StreetNew York10038Hotel
    29204682017-12-31T00:00:00.0002018-02-14T00:00:00.000692242920468Union Temple3-01172-0006325931017 Eastern ParkwayBrooklyn11238Worship Facility
    26451182017-12-31T00:00:00.0002018-02-15T00:00:00.0001988102645118155 West 66th Street Condominium10113875031028838155 West 66th StreetNew York10023Hotel
    43762152017-12-31T00:00:00.0002018-02-15T00:00:00.000120249437621538-20 Bowne Street Flushing4-05020-0023411359538-20 Bowne StreetFlushing11354Multifamily Housing
    28157592017-12-31T00:00:00.0002018-02-15T00:00:00.000337302815759Queens- Queen Grand Realty402611010640590014710 Grand AveQueens11385Distribution Center

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

    integer
    —
    0%
    269071826910892811806
    property_nametext—0%East BuildingLibraryStudent Union
    parent_property_idinteger—94%361267849858583616399
    parent_property_nametext—94%Columbia University (mor…Original CampusNew York University: Was…
    nyc_borough_block_and_lottext—2%10197300013-01920-00011018860001
    nyc_building_identificationtext—4%033349603334961
    address_1text—0%410 West 118th StreetClassified530 Grand Street
    address_2text—99%B-230Multiple Addresses-See U…Manhattan
    citytext—0%New YorkBrooklynBronx
    countytext—91%New YorkKingsQueens
    postcodetext—0%100271045210003
    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 HousingOfficeK-12 School
    largest_property_use_typetext—0%Multifamily HousingOfficeK-12 School
    largest_property_use_type_1integer—0%500006000030000
    _2nd_largest_property_usetext—79%ParkingRetail StoreOther
    _2nd_largest_property_use_1integer—79%0500010000
    _3rd_largest_property_usetext—93%Retail StoreOfficeParking
    _3rd_largest_property_use_1integer—93%020001000
    year_builtinteger—0%193119201928
    number_of_buildingsinteger—0%120
    occupancyinteger—0%1009590
    metered_areas_energytext—8%Whole BuildingBâtiment completAnother configuration
    metered_areas_watercategorical—58%Whole BuildingBâtiment completTenant and/or common are…of 6
    energy_star_scoreinteger—26%10012
    energy_star_certificationinteger—99%201720172016201520172016
    energy_star_certification_1datetime—99%2017-10-19T00:00:00.0002017-09-11T00:00:00.0002017-08-31T00:00:00.000
    energy_star_certification_2categorical—0%NoYesNonof 3
    site_eui_kbtu_ftfloat—7%071.774.3
    weather_normalized_site_euifloat—17%087.985.3
    national_median_site_euifloat—1%59.667.337.6
    difference_from_nationalfloat—8%-100-0.9-9.8
    site_energy_use_kbtufloat—7%0299604.761352618.6
    weather_normalized_site_energyfloat—17%0299604.712389853.1
    national_median_site_energyfloat—1%795194.60484279.8
    weather_normalized_sitefloat—10%3.744.1
    weather_normalized_site_1float—18%00.70.6
    source_eui_kbtu_ftfloat—7%0114.5108.6
    weather_normalized_sourcefloat—17%0132.2128.6
    national_median_source_euifloat—1%118.1105.4127.9
    difference_from_national_1float—8%-100-0.9-9.8
    source_energy_use_adjustedfloat—26%04307691.919093240.5
    source_energy_use_kbtufloat—7%0483898.664438262.6
    weather_normalized_source_1float—17%0483898.627974348
    national_median_source_energyfloat—1%1284337.52534975.40
    fuel_oil_1_use_kbtutext—100%34763932667784601456.4
    fuel_oil_2_use_kbtufloat—83%0276000138000
    fuel_oil_4_use_kbtufloat—93%0219000888848.1
    fuel_oil_5_6_use_kbtufloat—99%0149.6300004.5
    diesel_2_use_kbtutext—100%02070001527770.4
    kerosene_use_kbtutext—100%—
    propane_use_kbtucoordinate—100%11919336.1of 1
    district_steam_use_kbtufloat—95%18312269.9111056483778625
    district_hot_water_use_kbtucoordinate—100%247211817.5250718854146337.9of 4
    district_chilled_water_usetext—100%709056367667634.110820
    natural_gas_use_kbtufloat—16%02028542221585.1
    weather_normalized_site_2float—18%02028.524169.4
    electricity_use_grid_purchasefloat—8%0405072796750.7
    electricity_use_grid_purchase_1float—8%0118720028356
    weather_normalized_site_3float—10%0118720028356
    electricity_use_grid_purchase_2float—8%04050726.496750.7
    electricity_use_generatedfloat—100%3402.76805.413610.7
    electricity_use_generated_1float—100%997.31994.53989.1
    electricity_use_generated_2categorical—100%068390176297.1of 3
    annual_maximum_demand_kwinteger—93%0288272
    annual_maximum_demand_mmdatetime—93%2017-06-01T00:00:00.0002017-01-01T00:00:00.0002017-10-01T00:00:00.000of 12
    annual_maximum_demand_metertext—93%Electric - Majestic 4941…Electric Grid Meter (491…Electric Grid Meter (398…
    green_power_onsite_kwhfloat—100%997.31994.53989.1
    green_power_offsite_kwhcategorical—8%01946.21498061of 14
    avoided_emissions_onsitefloat—100%0.511.9
    avoided_emissions_offsitecategorical—8%0495.60.7of 12
    total_ghg_emissions_metricfloat—4%0276.719
    direct_ghg_emissions_metricfloat—4%010.86.1
    indirect_ghg_emissions_metricfloat—4%053.145.9
    national_median_total_ghgfloat—2%216.8180.6139
    estimated_data_flagcategorical—4%NoYesNonof 3
    estimated_data_flag_naturalcategorical—12%NoYesNonof 4
    estimated_data_flag_fuelcategorical—78%NoYesNonof 3
    estimated_data_flag_fuel_1categorical—90%NoYesNonof 3
    estimated_data_flag_fuel_2categorical—93%NoYesNonof 3
    estimated_data_flag_districtcategorical—95%NoYesNonof 3
    egrid_output_emissions_ratecategorical—0%84.788.7237.4of 14
    net_emissions_metric_tonsfloat—3%0276.7256.1
    percent_of_electricity_thatfloat—8%00.6048170.9377454
    percent_of_recs_retainedcategorical—100%100094.63165of 3
    percent_of_total_electricityfloat—100%0.6048170.44648790.9377454
    costar_property_idtext—100%157986of 1
    leed_us_project_idinteger—100%100007410910000053671000018067
    ambulatory_surgical_centercategorical—100%23800013490534472of 3
    automobile_dealership_grosscategorical—100%6562513745691256of 12
    bank_branch_gross_floor_areainteger—99%60000127663700
    bank_branch_number_ofinteger—99%101514
    college_university_grosstext—98%900000125000339104
    college_university_numbertext—100%50100400
    convention_center_gross_floortext—100%—
    courthouse_gross_floor_areatext—100%1040011000014000
    data_center_gross_floor_areainteger—100%0150003600
    data_center_pdu_input_metercategorical—100%011056501502975.9of 3
    data_center_pdu_output_meterinteger—100%0of 1
    data_center_it_equipmentinteger—100%0of 1
    data_center_it_site_energyfloat—100%6691200.18029741105650
    data_center_it_source_energyfloat—100%71687376.88602806.70
    data_center_puefloat—100%10.085.070.22
    data_center_national_mediancategorical—100%21.81.9of 3
    data_center_ups_output_meterfloat—100%06691200.1802974
    data_center_cooling_equipmentcategorical—100%N+1NNone of the Aboveof 7
    data_center_it_energycategorical—100%Uninterruptible Power Su…Facility Has No UPSUPS, including non-IT lo…of 5
    data_center_ups_systemcategorical—100%N+1None of the Above2Nof 8
    distribution_center_grossinteger—100%480003040053000
    enclosed_mall_gross_floorcategorical—100%996990182121490of 11
    energy_power_station_grosstext—100%311000of 1
    financial_office_gross_floortext—99%500060122850
    financial_office_number_oftext—99%10128
    financial_office_number_of_1text—99%1087
    financial_office_weeklytext—99%654550
    fitness_center_health_clubtext—100%250001570013000
    food_sales_gross_floor_areainteger—100%112050001324
    food_service_gross_floortext—100%479255000832
    hospital_general_medicalfloat—100%80986.7258.77
    hospital_general_medical_1float—100%2.61.160232.73324
    hospital_general_medical_2integer—100%6895278620469730
    hospital_general_medical_3categorical—100%No100% Yesof 2
    hospital_general_medical_4float—100%056.31431.3
    hospital_general_medical_5float—100%0.6900.69007
    hospital_general_medical_6float—100%00.002560.00281
    hospital_general_medical_7categorical—100%120of 7
    hospital_general_medical_8float—100%080174.57
    hospital_general_medical_9float—100%1.321.305261.32001
    hospital_general_medical_10categorical—100%10080of 2
    hospital_general_medical_11categorical—100%10080of 2
    hospital_general_medical_12float—100%0.4600.38158
    medical_office_gross_floorinteger—98%200010005000
    medical_office_number_ofcategorical—99%012of 5
    medical_office_number_of_1float—98%652
    medical_office_percent_thatfloat—98%100090
    medical_office_percent_that_1float—98%1009050
    medical_office_weeklyfloat—98%654060
    outpatient_rehabilitationtext—100%102571524866000
    urgent_care_clinic_othertext—100%298520002200
    k_12_school_gross_floor_areainteger—95%1200007200065000
    laboratory_gross_floor_areacategorical—100%180000116189360423of 14
    mailing_center_post_officecategorical—100%160054006490of 10
    manufacturing_industrialinteger—99%659684000030201
    movie_theater_gross_floortext—100%250003998760780
    multifamily_housing_grossinteger—32%500006000054000
    multifamily_housing_governmentcategorical—53%No100% YesNonof 4
    multifamily_housing_numberinteger—32%6090100
    multifamily_housing_number_1integer—56%054
    multifamily_housing_number_2integer—55%046
    multifamily_housing_totalinteger—32%604842
    multifamily_housing_percentfloat—46%010090
    multifamily_housing_percent_1float—45%1009080
    multifamily_housing_residentcategorical—56%No specific resident pop…Dedicated Senior/Indepen…Other dedicated housingof 7
    multifamily_housing_number_3float—32%1.401.40004
    multifamily_housing_total_1float—32%1.210.83333
    multifamily_housing_number_4integer—32%04060
    multifamily_housing_number_5float—32%01.128780.99587
    multifamily_housing_number_6integer—32%01660
    multifamily_housing_number_7float—32%00.833331
    other_computer_density_numberfloat—98%012
    office_gross_floor_area_ftinteger—87%100003000
    office_number_of_computersinteger—87%012
    office_number_of_workersinteger—87%023
    office_percent_that_can_befloat—87%100025
    office_percent_that_can_be_1float—87%100033
    office_weekly_operating_hoursinteger—87%654060
    office_worker_density_numberfloat—87%2.302
    museum_gross_floor_area_ftinteger—100%1975095951140000
    non_refrigerated_warehouseinteger—98%5000045000120000
    other_gross_floor_area_ftinteger—95%1000050001500
    other_weekly_operating_hoursinteger—98%016840
    other_number_of_computersinteger—98%012
    other_number_of_workers_oninteger—98%0202
    performing_arts_gross_floortext—100%300803325036000
    pre_school_daycare_grosstext—99%250001000014290
    supermarket_grocery_grossinteger—99%500010001271
    refrigerated_warehouse_grossinteger—100%12000052323120200
    repair_services_vehicle_shoetext—100%800002700035000
    residence_hall_dormitorytext—98%280481629659000
    restaurant_gross_floor_areatext—99%120020003000
    self_storage_facility_grosstext—99%7970840035000
    senior_care_community_grosstext—99%7000061994272100
    social_meeting_hall_grosstext—100%9110024763950000
    wholesale_club_supercentercategorical—100%1350006500010565of 10
    worship_facility_gross_floorinteger—99%2003520000247079
    retail_store_gross_floorinteger—92%5000100006000
    restaurant_worker_densitycoordinate—99%1.52.50
    restaurant_weekly_operatingtext—99%806070
    retail_store_walk_infloat—92%00.166670.13333
    retail_store_percent_thatfloat—92%100090
    retail_store_open_or_closedfloat—92%00.20.5
    retail_store_number_of_walkcategorical—92%012of 17
    retail_store_number_of_openinteger—92%012
    parking_gross_floor_areainteger—93%0500010000
    parking_open_parking_lotinteger—93%0100005000
    hotel_gross_floor_area_ftinteger—98%20000011710285900
    hotel_gym_fitness_centerinteger—99%0300400
    hotel_room_density_numberfloat—98%1.952.869290
    hotel_worker_density_numberfloat—98%0.320.325960.32001
    hotel_percent_that_can_becategorical—98%100900of 10
    estimated_data_flag_1boolean—100%FalseTrueof 2
    alert_data_center_issue_withcategorical—0%OkOKPossible Issueof 3
    alert_gross_floor_area_iscategorical—0%OkOKUnable to Check (not eno…of 5
    alert_energy_meter_has_singlecategorical—0%OkPossible IssueUnable to Check (not eno…of 6
    alert_energy_meter_hascategorical—0%OkUnable to Check (not eno…OKof 5
    alert_energy_meter_has_gapscategorical—0%OkUnable to Check (not eno…OKof 6
    alert_energy_meter_has_lesscategorical—0%OkPossible IssueUnable to Check (not eno…of 6
    alert_energy_no_meterscategorical—0%OkOKPossible Issueof 4
    alert_property_has_no_usescategorical—0%OkOKPossible Issueof 3
    data_quality_checker_runcategorical—0%NoYesNonof 4
    data_quality_checker_datedatetime—75%2018-07-16T00:00:00.0002018-04-26T00:00:00.0002018-04-27T00:00:00.000
    default_valuescategorical—0%NoYesOuiof 5
    estimated_values_energycategorical—0%NoYesUnable to Check (not eno…of 6
    temporary_valuescategorical—0%NoYesNonof 4
    estimated_values_watercategorical—0%NoUnable to Check (not eno…Yesof 5
    property_gfa_self_reportedinteger—0%500006000030000
    property_gfa_calculatedinteger—0%500006000030000
    property_gfa_calculated_1integer—0%600005000030000
    property_gfa_calculated_2integer—93%10000500020000
    water_current_datedatetime—36%2017-12-31T00:00:00.0002012-12-31T00:00:00.0002016-12-31T00:00:00.000
    water_use_all_water_sourcesfloat—47%051.6300
    indoor_water_use_all_waterfloat—50%051.6300
    indoor_water_use_intensityfloat—50%022.17
    outdoor_water_use_all_watercategorical—100%13393.317803.5398.2of 19
    municipally_supplied_potablefloat—97%06793.51444.8
    municipally_supplied_potable_1float—50%051.6300
    water_use_intensity_all_waterfloat—47%022.17
    municipally_supplied_potable_2categorical—100%13393.31003.2398.2of 15
    water_score_multifamily_onlytext—78%123
    irrigated_area_ftinteger—52%01000100
    third_party_certificationdatetime—100%2017-09-05T00:00:00.0002012-02-27T00:00:00.0002012-11-01T00:00:00.000of 7
    third_party_certification_1categorical—100%LEEDEcoRooms and EcoSuitesof 2
    third_party_certification_2datetime—100%2017-09-05T00:00:00.0002012-02-27T00:00:00.0002012-11-01T00:00:00.000of 7
    supermarket_grocery_openfloat—99%010.2
    convenience_store_with_gastext—100%—
    convenience_store_with_gas_1text—100%—
    financial_office_computercoordinate—99%21.663342.86021
    senior_care_community_livingcoordinate—99%1.58400.06311
    last_modified_date_propertydate—1%04/18/2018 11:34 AM EDT04/10/2018 03:15 PM EDT04/18/2018 10:36 AM EDT
    last_modified_date_electricdate—5%04/18/2018 11:31 AM EDT04/18/2018 11:32 AM EDT04/18/2018 10:32 AM EDT
    last_modified_date_gas_metersdate—13%04/18/2018 11:33 AM EDT04/18/2018 09:57 AM EDT04/18/2018 10:35 AM EDT
    last_modified_date_nondate—66%04/18/2018 11:34 AM EDT04/18/2018 10:36 AM EDT04/18/2018 10:37 AM EDT
    last_modified_date_waterdate—43%02/13/2018 12:28 PM EST02/13/2018 12:06 PM EST02/13/2018 11:58 AM EST
    boroughcategorical—4%MANHATTANBROOKLYNBRONXof 5
    latitudefloat—4%40.80756740.71441340.691169
    longitudefloat—4%-73.958787-73.981437-73.963572
    community_boardinteger—4%105108112
    council_districtinteger—4%437
    census_tractinteger—4%193199203
    ntatext—4%Midtown-Midtown SouthMorningside HeightsWest Village