Name Real Estate Property
Version 1.18
Description This dataset contains essential information for evaluating the quality and performance of assets held by real estate companies across North America, Europe, Asia, and Emerging Markets. It encompasses details about property types, geographical locations, acquisition and disposition, and development pipelines, including enhancements. The data also includes tenant information, size attributes, financial metrics, book values, encumbrances, and vital Green Property Certifications such as Leadership in Energy and Environmental Design (LEED), Energy Star, and United Kingdom (UK) Energy Performance Certificates (EPC). This comprehensive resource supports clients, including Investment Managers, Investment Banks, Corporates, and Academics, in assessing the risks and operational performance of real estate companies and their portfolios.
Types
Name Category Services Description Count
Address entity linknext_weekspeaker_phone Contains detailed address information, including street, city, region, and postal code, for various entities. This data is utilized exclusively for internal S&P Global operations and systems. 27.0 M
Batch entity linkspeaker_phone Definition of a batch, representing a set of updates linked to a particular condition. <1K
BatchRun entity linkspeaker_phone Defines an instance of a Batch. Where a Batch has a fixed definition over time, a BatchRun represents a specific Version of the Batch on a specific asOf. 4.6 K
CensusTract entity linknext_weekspeaker_phone The geographic subdivision of a county that is used for United States (U.S.) Census statistical data. 100.1 K
CentroidBasis entity linknext_weekspeaker_phone The type of geographic area from which the centroid was derived. <1K
CentroidType entity linknext_weekspeaker_phone The geographic applicability of centroids, distinguishing between United States (U.S.) and non-United States (U.S.) locations. <1K
CityAsReported entity linknext_weekspeaker_phone The reported name of the city. 740.1 K
ConstructionCostShareType entity linknext_weekspeaker_phone The type of share for construction costs. <1K
Country entity linknext_weekspeaker_phone A country, defined primarily by International Organization for Standardization 3166 (ISO 3166) codes, with exceptions for territories or other similar dependent entities. <1K
CountryDivision entity linknext_weekspeaker_phone Administrative subdivisions of countries as defined by Market Intelligence. While originally based on International Organization for Standardization 3166-2 (ISO 3166-2 ) and International Organization for Standardization 3166-1 (ISO 3166-1) standards, this definition has diverged over time. 4.2 K
County entity linknext_weekspeaker_phone The counties or other primary political divisions of United States (U.S.) and Territories. 3.3 K
Currency entity linknext_weekspeaker_phone The default measurement standard for the associated currency, compliant with the International Organization for Standardization 4217 (ISO 4217) standard. <1K
EncumbranceType entity linknext_weekspeaker_phone Details the encumbrance status of properties with respect to lines of credit. <1K
EnergyStarCertLevel entity linknext_weekspeaker_phone The certification levels awarded by Energy Star. <1K
EnergyStarVersion entity linknext_weekspeaker_phone The Energy Star scores for existing buildings, determined by evaluating energy management factors and efficiencies. <1K
FiscalPeriod entity linknext_weekspeaker_phone The fiscal periods used to describe financial information. <1K
FiscalPeriodGAAP entity linknext_weekspeaker_phone The relationships between Generally Accepted Accounting Principles (GAAP) flow data and financial periods. <1K
GRESBAssessmentType entity linknext_weekspeaker_phone The assessment types provided by Global Real Estate Sustainability Benchmark (GRESB). <1K
GRESBDisclosureLevel entity linknext_weekspeaker_phone The Global Real Estate Sustainability Benchmark (GRESB) Public Disclosure, which measures the level of environmental, social, and governance (ESG) disclosure by listed property companies and Real Estate Investment Trusts (REITs) that are aligned with the GRESB Real Estate Assessment. <1K
GRESBDisclosureTopic entity linknext_weekspeaker_phone The disclosure topic and its average score across all companies. <1K
GRESBInstnDisclosure entity linknext_weekspeaker_phone The level of disclosure score awarded to a company by Global Real Estate Sustainability Benchmark (GRESB) for a specific disclosure topic. 3.3 K
GRESBPeriodAverage entity linknext_weekspeaker_phone The Global Real Estate Sustainability Benchmark (GRESB) average scores. This data is limited to a single row because S&P Global's current contractual obligations prevent the display of historical data within the S&P Global Platform. <1K
GRESBTrend entity linknext_weekspeaker_phone The trends provided by the Global Real Estate Sustainability Benchmark (GRESB) that are applied to a company and aspect. <1K
GroundLease entity linknext_weekspeaker_phone The ways in which a ground lease can affect property ownership. <1K
InstitutionGRESB entity linknext_weekspeaker_phone The Global Real Estate Sustainability Benchmark (GRESB) data collected for companies. Due to S&P Global's current contractual obligations, historical Global Real Estate Sustainability Benchmark (GRESB) data is not retained; instead, prior year data is updated when current year data becomes available for an institution. <1K
LEEDCertificationLevel entity linknext_weekspeaker_phone The certification levels obtained by Leadership in Energy and Environmental Design (LEED). <1K
LEEDVersion entity linknext_weekspeaker_phone The version of the Leadership in Energy and Environmental Design (LEED) building certification a property has been validated through, as provided by the United States (U.S.) Green Building Council. <1K
MINameSpace entity linknext_weekspeaker_phone Defines the source of the data. <1K
MSA2003 entity linknext_weekspeaker_phone The Metropolitan Statistical Areas (MSA) as defined by the United States (U.S.) Office of Management and Budget (OMB). 1.1 K
MSAType entity linknext_weekspeaker_phone The types of Metropolitan Statistical Areas (MSA) as defined under the United States (U.S.) Office of Management and Budget's (OMB) 2003 revisions. <1K
MarketRank entity linknext_weekspeaker_phone The ranking of markets. <1K
MeasurementStandard entity linknext_weekspeaker_phone The measurement standards. <1K
Property entity linknext_weekspeaker_phone The real estate properties. 75.2 K
PropertyAcquisitionGroup entity linknext_weekspeaker_phone The method by which a property was acquired, such as a merger, a portfolio acquisition, or a stand-alone deal. <1K
PropertyAggregateDate entity linknext_weekspeaker_phone Contains property aggregate data, specifying the date and company for which the various aggregates are measured. 34.6 K
PropertyAggregateEOPFlat entity linknext_weekspeaker_phone The aggregate end-of-period information for real estate property portfolios. 54.4 K
PropertyAggregateFinl entity linknext_weekspeaker_phone The aggregate flow information for real estate property portfolios. 97.6 K
PropertyAggregateMarket entity linknext_weekspeaker_phone Contains property aggregate data categorized by geographic area. These areas are company-defined, preventing mapping to standard geographic keys and comparability across companies. All income data pertains to the quarter preceding the indicated date. 233.0 K
PropertyAggregateTenant entity linknext_weekspeaker_phone Contains aggregate property data, categorized by tenant. The tenant is identified by its S&P Capital IQ Company ID. 305.9 K
PropertyEvent entity linknext_weekspeaker_phone The milestones in the lifecycle of a property. 309.1 K
PropertyFinl entity linknext_weekspeaker_phone Contains financial information and other details, such as size, for real estate properties. This data is updated annually and is uniquely identified by property ownership, as some information varies depending on the owner. 3.5 M
PropertyFinlEncumbrance entity linknext_weekspeaker_phone The encumbrance information for real estate properties, as of a financial period. 676.7 K
PropertyImprovement entity linknext_weekspeaker_phone The improvements, such as expansions and renovations, on real estate properties. 57.6 K
PropertyOperatingStatus entity linknext_weekspeaker_phone The operational status of a property, which includes whether it is opened for tenant use, has ceased to be active, or is under development. A deferred project is currently on hold with a likely future resumption of construction, while an abandoned project is one with no likely activity within a year. <1K
PropertyOwnerImprovement entity linknext_weekspeaker_phone The relationship between a property owner and a property improvement for the purpose of capturing each owners' share of an improvement's cost. 1.6 K
PropertyOwnership entity linknext_weekspeaker_phone The ownership of real estate properties. 322.7 K
PropertyPortfolioEOP entity linknext_weekspeaker_phone Contains portfolios of properties. This read-only data includes dates for the currency conversion of prior period financial items. 4.1 K
PropertyPortfolioFinl entity linknext_weekspeaker_phone The periods available for portfolios of properties. This read-only version contains dates for the currency conversion of prior period financial items. 5.3 K
PropertyPortfolioSegmentEOP entity linknext_weekspeaker_phone The reported segments of a property portfolio. 44.7 K
PropertyPortfolioSegmentFinl entity linknext_weekspeaker_phone The data collected periodically for individual segments of a property portfolio is based on information reported by the source. 59.1 K
PropertyPortfolioTransaction entity linknext_weekspeaker_phone The transactions related to a portfolio of properties. 23.2 K
PropertySales entity linknext_weekspeaker_phone Contains property sale and transfer data, with each record directly associated with an individual property. This includes transactions resulting from mergers and acquisitions (M&A). The deal value represents the total portfolio price. 323.6 K
PropertySourced entity linknext_weekspeaker_phone The real estate properties as provided by vendors. 4.4 K
PropertySourcedBuilding entity linknext_weekspeaker_phone The buildings that are part of a real estate property. 21.5 K
PropertySourcedBuildingEnergyStar entity linknext_weekspeaker_phone The scores recorded for a specific building in a particular year. 66.3 K
PropertySourcedBuildingLEED entity linknext_weekspeaker_phone The Leadership in Energy and Environmental Design (LEED) certifications for a specific building in a particular year. 7.3 K
PropertySourcedEnergyStar entity linknext_weekspeaker_phone The Energy Star certifications for a specific property in a particular year. 32.2 K
PropertySourcedLEED entity linknext_weekspeaker_phone The Leadership in Energy and Environmental Design (LEED) certifications for a specific property in a particular year. 5.9 K
PropertyTenants entity linknext_weekspeaker_phone The tenants of real estate properties. 183.5 K
PropertyTenureType entity linknext_weekspeaker_phone The type of ownership of the property, including the underlying land. <1K
PropertyTransaction entity linknext_weekspeaker_phone The historical property sales transaction data. 511.9 K
PropertyType entity linknext_weekspeaker_phone The types of real estate properties, as determined by tenant use. <1K
RCAFinlAll entity linknext_weekspeaker_phone Contains property market data from the third-party provider Real Capital Analytics (RCA). This data includes both annual and quarterly information. 70.3 K
RCAMarket entity linknext_weekspeaker_phone A proprietary geographic area developed by the third-party provider Real Capital Analytics (RCA). <1K
RCAPropertyType entity linknext_weekspeaker_phone The property types as defined by the third-party provider Real Capital Analytics (RCA). <1K
RacetrackTypes entity linknext_weekspeaker_phone The types of racetracks, categorized by the vehicles or animals that race on them. This is distinct from a property subtype, as various property types can have an affiliated track. <1K
SnlDataItemMaster entity linknext_weekspeaker_phone Metadata for all data points captured under the dataset, like definitions, magnitude and other details. <1K
SnlIndustry entity linknext_weekspeaker_phone Industries associated with each data point within the dataset. <1K
State entity linknext_weekspeaker_phone The United States (U.S.) and Territories. <1K
TenantRank entity linknext_weekspeaker_phone The ranking of tenants. <1K
UKEPCACInspectionStatus entity linknext_weekspeaker_phone The commissioned air conditioning inspection status. <1K
UKEPCBuilding entity linknext_weekspeaker_phone The buildings or units that are part of a real estate property, sourced from the United Kingdom (UK). Address information is captured within this entity, rather than a separate address table, due to the low fidelity of data provided by the United Kingdom government (UK.gov) energy performance certificate (EPC). 27.3 K
UKEPCBuildingEnvironment entity linknext_weekspeaker_phone The building's environment that contributes the largest proportion of its carbon dioxide (CO2) emissions. <1K
UKEPCBuildingLevel entity linknext_weekspeaker_phone The building complexity level, based on the Energy Assessor National Occupation Standards. <1K
UKEPCBuildingRank entity linknext_weekspeaker_phone The buildings contained within a specific property, ranked by their last certification date. <1K
UKEPCDataSet entity linknext_weekspeaker_phone The United Kingdom (UK) Energy Performance Certificate (EPC) data sets. <1K
UKEPCDisplayEnergyCertification entity linknext_weekspeaker_phone The Display Energy Certificate (DEC) certifications for a specific building in a particular year. Due to the low fidelity of data from the United Kingdom (UK), square footage is included in the uniqueness criteria to differentiate between buildings within a single property when unique building identifiers are unavailable. 2.5 K
UKEPCMainHeatingFuel entity linknext_weekspeaker_phone The types of fuel that deliver thermal output for space or water heating for buildings. <1K
UKEPCNonDomesticCertification entity linknext_weekspeaker_phone The Non-Domestic Energy Performance Certificate (EPC) certifications for a specific commercial building in a particular year. 55.3 K
UKEPCNonDomesticPropertyType entity linknext_weekspeaker_phone The property type for non-domestic (commercial) buildings or individual units. <1K
UKEPCOccupancyLevel entity linknext_weekspeaker_phone The occupancy level during the hours of operation of the building. <1K
UKEPCPropertyBuildingRank entity linknext_weekspeaker_phone The buildings contained within a specific property, ranked by their last certification date. 23.4 K
UKEPCRatingBand entity linknext_weekspeaker_phone The energy bands or grades, represented by a linear scale from A+ to G, where A+ signifies the most energy efficient and G the least energy efficient. <1K
UKEPCRenewableSource entity linknext_weekspeaker_phone The on-site renewable energy sources, as detailed in the Recommendations Report. <1K
UKEPCSpecialEnergyUse entity linknext_weekspeaker_phone The energy uses that are atypical for the building type and are excluded from the ratings or total emissions. <1K
UKEPCTransactionType entity linknext_weekspeaker_phone The type of transaction that triggered the Energy Performance Certificate (EPC). <1K
ZipCodes entity linknext_weekspeaker_phone The United States (U.S.) Postal Service Zone Improvement Plan (ZIP) Codes. 44.2 K
87 rows of 87 total
Diagrams
Class
Entity Relationship