From a 500-row sample across 196 columns.
hotel_presence_of_cookingswimming_pool_sizeother_weekly_operating_hours+150Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
building_id_espm | text | — | 0% | 283118028311562364104 |
bbl10 | integer | — | 0% | 204712000140702100012047130001 |
facility_name | text | — | 0% | Pinnacle -SAMUEL (CIRANDOLPH |
rating | integer | — | 4% | 01001 |
bin_unique_building_identifier | text |
GET /api/datasets/k7nh-aufb GET /api/datasets/k7nh-aufb/quality GET /api/datasets/k7nh-aufb/related GET /api/columns?dataset=k7nh-aufb
hotel_number_of_roomsmedical_office_weeklyyear_built+31other_weekly_operating_hoursmedical_office_weeklydifference_from_national_1+30other_weekly_operating_hoursmedical_office_weeklydifference_from_national_1+30other_weekly_operating_hoursmedical_office_weeklydifference_from_national_1+30other_weekly_operating_hoursmedical_office_weeklyyear_built+27other_weekly_operating_hoursmedical_office_weeklydifference_from_national_1+29other_weekly_operating_hoursmedical_office_weeklydifference_from_national_1+30| — |
| 6% |
1060038;1060039;1060069;…1055159;1055160;1055161;…1076262 |
address_1 | text | — | 0% | NA109 W 144 ST ENT204 WEST 114TH STREET - … |
address_2 | text | — | 98% | Multiple Addresses-S2583 Francis Lewis BB-230 |
city | text | — | 0% | New YorkBrooklynBronx |
postcode | integer | — | 0% | 100011120110451 |
county | categorical | — | 0% | NEW YORKKINGSQUEENSof 10 |
total_floor_space_sq_ft | integer | — | 4% | 600000795415 |
year_built | integer | — | 0% | 190019281929 |
facility_type | text | — | 0% | Multifamily HousingOfficeOther |
last_modified_date | datetime | — | 0% | 2012-06-18T10:30:44.0002012-06-18T10:27:16.0002012-04-27T10:46:56.000 |
service_and_product_provider | text | — | 0% | NoneBright PowerMetropolitan Refunds |
metering_configuration | text | — | 0% | No Selection MadeWhole Facility Energy Co…Default energy data |
eligibility_for_energy_star | categorical | — | 0% | Not Eligible: Rating mus…EligibleNot Eligible: Current pe…of 9 |
energy_star_application_status | text | — | 0% | No Status AvailableApplication - Label Sent…Application - Label Sent… |
year_s_labeled | integer | — | 99% | 201120102012 |
approval_date_last_energy | datetime | — | 99% | 2011-12-09T16:01:45.0002008-11-20T09:43:34.0002009-02-11T12:01:59.000 |
current_rating_1_100 | integer | — | 0% | 01001 |
target_rating_1_100 | categorical | — | 10% | 07585of 15 |
energy_use_alerts | text | — | 66% | Data > 120 days old<br>Temporary values used fo…Data > 120 days old<br>T… |
space_use_alerts | text | — | 14% | "Multifamily Housing" sp…"Multifamily Housing" sp…"Multifamily Housing" sp… |
current_direct_ghg_emissions | float | — | 19% | 826.3212.1910.20 |
current_indirect_ghg_emissions | float | — | 11% | 134.153914.7939389.3 |
current_total_ghg_emissions | float | — | 10% | 960.4110.253914.79 |
emissions_factor_kg_co2e | categorical | — | 100% | 377.28946.04184.11of 9 |
current_energy_period_ending | datetime | — | 0% | 2011-12-31T00:00:00.0002012-03-31T00:00:00.0002012-01-31T00:00:00.000 |
current_water_period_ending | datetime | — | 0% | 2200-01-01T00:00:00.0002011-12-31T00:00:00.0002012-02-29T00:00:00.000 |
current_total_on_site | coordinate | — | 100% | 169785.8160686.00of 2 |
percent_of_electricity_from | coordinate | — | 100% | 0.2326.85of 2 |
total_avoided_ghg_emissions | coordinate | — | 100% | 2.98152.501650.27of 12 |
total_on_site_electric | text | — | 100% | — |
total_green_power_purchased | coordinate | — | 100% | 3.29286.44320.97of 13 |
total_renewable_energy_sold | text | — | 100% | — |
current_site_energy_intensity | float | — | 10% | 043.365.9 |
current_total_site_energy | float | — | 10% | 16960556.8138690.5377994838.8 |
national_median_site_eui | float | — | 78% | 70.068.0104.0 |
target_site_energy_intensity | float | — | 10% | 069.685.3 |
weather_normalized_site_eui | float | — | 10% | 065.941.4 |
electricity_use_kbtu | float | — | 10% | 01428256.84401930507.9 |
electricity_use_kwh | float | — | 10% | 0418598.1117799093.8 |
natural_gas_use_kbtu | float | — | 28% | 0.0015532300.00229100.00 |
natural_gas_use_therms | float | — | 29% | 155323.02291.08723620.9 |
district_steam_use_kbtu | float | — | 92% | 204921346.940.009717966.00 |
fuel_oil_2_use_kbtu | float | — | 90% | 0.00138690.5012298657.47 |
fuel_oil_4_use_kbtu | float | — | 91% | 0.004791479.39693452.50 |
fuel_oil_56_use_kbtu | float | — | 77% | 0.0029458791.023644065.53 |
diesel_2_use_kbtu | coordinate | — | 100% | 0.00347142.32458649.48of 17 |
chilled_water_absorption | integer | — | 100% | 0.00of 1 |
chilled_water_electric_driven | categorical | — | 100% | -228857016.000.00305599.92of 18 |
chilled_water_engine_driven | categorical | — | 100% | 0.0063119580.00of 2 |
chilled_water_other_kbtu | integer | — | 100% | 0.00of 1 |
district_hot_water_kbtu | text | — | 100% | — |
temporary_data_flag | categorical | — | 5% | NoYesof 2 |
temporary_data_flag_1 | text | — | 100% | Noof 1 |
temporary_data_flag_2 | text | — | 100% | — |
temporary_data_flag_natural | categorical | — | 24% | NoYesof 2 |
temporary_data_flag_district | categorical | — | 92% | NoYesof 2 |
temporary_data_flag_fuel | categorical | — | 90% | NoYesof 2 |
temporary_data_flag_fuel_1 | categorical | — | 91% | NoYesof 2 |
temporary_data_flag_fuel_2 | categorical | — | 76% | NoYesof 2 |
temporary_data_flag_diesel | text | — | 100% | Noof 1 |
temporary_data_flag_district_1 | text | — | 100% | — |
temporary_data_flag_district_2 | text | — | 100% | Noof 1 |
difference_from_national | float | — | 79% | 39.44.099.0 |
current_source_energy | float | — | 10% | 053.7121.3 |
current_total_source_energy | float | — | 10% | 21032695.9140077.41350102859 |
current_weather_normalized | float | — | 10% | 051.7126.3 |
national_median_source_eui | float | — | 78% | 127.0164.0244.0 |
difference_from_national_1 | float | — | 79% | 39.450.54.0 |
bank_financial_institution | integer | — | 98% | 884050003000 |
bank_financial_institution_1 | categorical | — | 98% | 100.0025.0096.95of 3 |
bank_financial_institution_2 | float | — | 98% | 2.201.702.19 |
bank_financial_institution_3 | integer | — | 98% | 655040 |
bank_financial_institution_4 | float | — | 98% | 2.302.152.29 |
bank_financial_institution_5 | integer | — | 98% | 10197 |
hospital_gross_floor_area | text | — | 99% | 29066609279821134614 |
hospital_laboratory_y_1_n | coordinate | — | 99% | 0.001.00of 2 |
hospital_laundry_facility | coordinate | — | 99% | 0.001.00of 2 |
hospital_maximum_number_of | categorical | — | 99% | 52014of 18 |
hospital_number_of_buildings | categorical | — | 100% | 1122of 9 |
full_time_equivalent_fte | text | — | 99% | 70992413169 |
number_of_staffed_beds | text | — | 99% | 0627894 |
number_of_mri_machines | categorical | — | 99% | 140of 4 |
hotel_gross_floor_area_sq | integer | — | 99% | 20000010000085000 |
hotel_floor_area_of_full | categorical | — | 99% | 012004500of 9 |
hotel_floor_area_of_gym | text | — | 99% | 01200800 |
hotel_average_occupancy | coordinate | — | 99% | 90.0085.0080.00 |
hotel_number_of_rooms | integer | — | 99% | 13512672 |
hotel_room_density | float | — | 99% | 1.951.421.37 |
hotel_onsite_laundry_short | categorical | — | 99% | No laundry facilityBoth linens and terryTerry only (e.g., towels…of 4 |
hotel_quantity_of_laundry | text | — | 100% | 022000036500 |
hotel_percent_cooled | categorical | — | 99% | 100.0090.0080.00of 10 |
hotel_presence_of_cooking | categorical | — | 99% | 10of 2 |
hotel_workers_density | float | — | 99% | 0.320.350.28 |
house_of_worship_gross_floor | integer | — | 100% | 9010015001070 |
house_of_worship_pc_density | categorical | — | 100% | 012of 3 |
house_of_worship_weekly | integer | — | 100% | 334056 |
house_of_worship_presence | categorical | — | 100% | 01of 2 |
k_12_school_gross_floor_area | integer | — | 99% | 428006500090000 |
k_12_school_high_school_y | categorical | — | 99% | 0.001.00of 2 |
k_12_school_open_weekends | categorical | — | 99% | 0.001.00of 2 |
k_12_school_pc_density | float | — | 99% | 1.751.401.88 |
k_12_school_percent_cooled | categorical | — | 99% | 1005090of 12 |
k_12_school_walk_in_refrig | categorical | — | 99% | 0.000.010.02of 17 |
k_12_school_presence_of | categorical | — | 99% | 1024of 3 |
medical_office_gross_floor | integer | — | 95% | 500010002000 |
medical_office_number_of | integer | — | 95% | 243 |
medical_office_percent_cooled | float | — | 95% | 100.000.0090.00 |
medical_office_weekly | integer | — | 95% | 654060 |
multifamily_home_gross_floor | integer | — | 26% | 79541539150036096 |
multifamily_home_dishwasher | integer | — | 37% | 0.0020.0060.00 |
multifamily_home_laundry | integer | — | 36% | 0.004.006.00 |
multifamily_home_laundry_1 | integer | — | 36% | 0.005.0010.00 |
multifamily_home_government | categorical | — | 26% | 0.001.00of 2 |
multifamily_home_number_of | integer | — | 34% | 675 |
multifamily_home_number_of_1 | integer | — | 32% | 606648 |
multifamily_home_percent | categorical | — | 36% | 0.00100.0090.00of 18 |
multifamily_home_percent_1 | integer | — | 43% | 15.0010.005.00 |
multifamily_home_total_number | integer | — | 36% | 0.0090.0072.00 |
multifamily_home_primary | categorical | — | 59% | Natural GasFuel Oil (No. 5 and No. …Fuel Oil (No. 4)of 16 |
multifamily_home_resident | categorical | — | 57% | No specific resident pop…Dedicated Senior/Indepen…Dedicated Studentof 18 |
office_gross_floor_area_sq | integer | — | 83% | 100050002000 |
office_office_air_conditioned | float | — | 83% | 100.000.0025.00 |
office_pc_density | float | — | 83% | 2.200.002.00 |
office_weekly_operating_hours | integer | — | 83% | 654050 |
office_workers_density | float | — | 83% | 2.300.002.57 |
other_space_type_name | text | — | 85% | OtherRetail (Misc)Restaurant/Cafeteria |
other_gross_floor_area_sq | integer | — | 85% | 30002756125000 |
other_number_of_pcs | integer | — | 93% | 021 |
other_weekly_operating_hours | integer | — | 93% | 6540168 |
other_workers_on_main_shift | integer | — | 93% | 043 |
parking_enclosed_floor_area | integer | — | 89% | 0500020000 |
parking_gross_floor_area | integer | — | 89% | 20000500010000 |
parking_non_enclosed_floor | integer | — | 89% | 087120020000 |
parking_open_floor_area_w | integer | — | 89% | 036224320000 |
parking_weekly_hours_of_access | integer | — | 89% | 1681120 |
residence_halls_dormitories | integer | — | 99% | 12804362200060000 |
residence_halls_dormitories_1 | categorical | — | 99% | 100.0062.3980.00of 17 |
residence_halls_dormitories_2 | categorical | — | 99% | 0.000.711.00of 5 |
residence_halls_dormitories_3 | categorical | — | 99% | 0.001.000.13of 7 |
residence_halls_dormitories_4 | integer | — | 99% | 28963350 |
retail_gross_floor_area_sq | integer | — | 85% | 5000100006000 |
retail_cash_register_density | float | — | 85% | 0.300.000.33 |
retail_exterior_entrance | categorical | — | 85% | 10of 2 |
retail_workers_density | float | — | 85% | 1.000.000.90 |
retail_weekly_operating_hours | integer | — | 85% | 656070 |
retail_walk_in_refrig_density | float | — | 85% | 0.000.070.13 |
retail_percent_cooled | float | — | 85% | 100.000.0080.00 |
retail_pc_density | float | — | 85% | 0.200.000.15 |
retail_open_closed_refrig | float | — | 85% | 0.000.370.13 |
retail_number_of_walk_in | categorical | — | 85% | 012of 17 |
retail_number_of_open_or | integer | — | 85% | 012 |
senior_care_facility_average | text | — | 99% | 295520265 |
senior_care_facility_gross | text | — | 99% | 11000097800115000 |
senior_care_facility_number | text | — | 99% | 6411 |
senior_care_facility_number_1 | categorical | — | 99% | 324of 15 |
senior_care_facility_number_2 | text | — | 99% | 5036100 |
senior_care_facility_number_3 | text | — | 99% | 085 |
senior_care_facility_number_4 | categorical | — | 99% | 074of 15 |
senior_care_facility_percent | categorical | — | 99% | 1009030of 6 |
senior_care_facility_total | text | — | 99% | 32020017 |
senior_care_facility_total_1 | text | — | 99% | 320240200 |
senior_care_facility_workers | text | — | 99% | 15092115 |
supermarkets_grocery_gross | integer | — | 98% | 337806001500 |
supermarkets_grocery_number | integer | — | 99% | 0501 |
supermarkets_grocery_number_1 | categorical | — | 99% | 120of 18 |
supermarkets_grocery_number_2 | categorical | — | 98% | 013of 17 |
supermarkets_grocery_percent | categorical | — | 98% | 100.0080.0060.00of 12 |
supermarkets_grocery_presence | categorical | — | 98% | 1.000.000.17of 3 |
supermarkets_grocery_walk | float | — | 98% | 0.250.000.09 |
supermarkets_grocery_weekly | integer | — | 98% | 105168117 |
supermarkets_grocery_workers | float | — | 98% | 1.001.333.13 |
swimming_pool_size | categorical | — | 100% | Recreational (20 yards x…Short Course (25 yards x…Olympic (50 meters x 25 …of 6 |
swimming_pool_indoor_outdoor | categorical | — | 100% | IndoorOutdoorIndoor, Outdoorof 3 |
swimming_pool_months_in_use | categorical | — | 100% | 1203of 6 |
warehouse_refrigerated_gross | text | — | 100% | 120200133000135000 |
warehouse_refrigerated_weekly | categorical | — | 100% | 60168100of 11 |
warehouse_refrigerated_workers | categorical | — | 100% | 102of 5 |
warehouse_unrefrigerated | text | — | 98% | 52000100000120000 |
warehouse_unrefrigerated_1 | categorical | — | 98% | 01of 2 |
warehouse_unrefrigerated_2 | coordinate | — | 98% | 100.0050.000.00 |
warehouse_unrefrigerated_3 | coordinate | — | 98% | 20.000.00100.00 |
warehouse_unrefrigerated_4 | text | — | 98% | 0of 1 |
warehouse_unrefrigerated_5 | text | — | 98% | 604050 |
warehouse_unrefrigerated_6 | categorical | — | 98% | 012of 6 |
current_data_center_source | text | — | 100% | — |
current_site_pdu_input_energy | coordinate | — | 100% | 70740.02250000.02471.0of 4 |
current_site_ups_output_energy | coordinate | — | 100% | 10144380.0135168.91874260.0of 18 |
current_source_it_energy | coordinate | — | 100% | 115606166.01540395.221359216.9 |
national_average_pue | float | — | 98% | 1.82of 1 |
data_center_gross_floor_area | integer | — | 98% | 5000020000 |
data_center_annual_it_energy | integer | — | 98% | 066117602739906497 |
data_center_it_energy | categorical | — | 98% | IT Energy is not current…Uninterruptible Power Su…Facility has no UPS.of 5 |
indoor_water_use_kgal | float | — | 84% | 0.01062.77219.4 |
indoor_water_use_per_sq_ft | float | — | 84% | 0.0018.720.56 |
outdoor_water_use_kgal | coordinate | — | 100% | 10442.8108.311959.8 |
other_water_use_kgal | float | — | 99% | 0.03111.04544.8 |
total_indoor_and_outdoor | float | — | 84% | 0.01062.77219.4 |
water_use_alerts | categorical | — | 93% | There is no water use fo…Less than 1 year of data…Overlapping meter entrie…of 8 |
release_date | datetime | — | 0% | 2012-04-30T08:06:30.0002012-06-27T16:15:48.0002012-07-31T11:11:05.000 |
borough | categorical | — | 8% | MANHATTANBROOKLYNQUEENSof 5 |
latitude | float | — | 8% | 40.81999640.72560140.758754 |
longitude | float | — | 8% | -73.937236-73.791694-73.978692 |
community_board | integer | — | 8% | 105108107 |
council_district | integer | — | 8% | 436 |
census_tract | integer | — | 8% | 3867199 |
nta | text | — | 8% | Midtown-Midtown SouthUpper East Side-Carnegie…Upper West Side |