Type PropertyFinl
Type category Entity
Description 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.
Fields
Name Type Filters Description
key id string(100)* = The unique identifier for property financial data.
annualization decimal{22,8} The factor by which flow financial items are multiplied to obtain an annualized figure.
link batch Batch* = The Batch for which this BatchRun is an instance.
link batchRun BatchRun* = The BatchRun in which the entity is sent.
capRateProperty decimal{5,1} The capitalization rate (yield) of property at period end as reported by the company. (Magnitude: %)
currencyBOPDate date The beginning of period date used for currency flow conversion.
link currencyId Currency* The alphabetic code used to identify currencies, pursuant to the International Organization for Standardization (ISO) 4217 standard.
dataSourcePeriod string(6) A unique identifier for a financial period within the data source, which, along with the Standard & Poor's (S&P) Cap IQ Company ID (KeyInstn) and restatement status, forms a unique key. It is typically a concatenation of the fiscal year and fiscal period values. For derived periods, it may be 'Last Twelve Months (LTM)' or another designation.
ebitdaRealEstate decimal{19,0} Earnings before interest, taxes, depreciation, and amortization. (Magnitude: $000)
fiscalQuarter string(1) The indicator for a financial period's position within the company's fiscal year. This can include fiscal quarters (e.g., 1 through 4), fiscal years, year-to-date periods, or other specific designations.
fiscalYear string(4) The company's fiscal year for the financial information.
gamingSlotCount long(-2147483648,2147483647) The aggregate count of slot machines at casinos that are owned or operated. (Magnitude: actual)
gamingTableCount long(-2147483648,2147483647) The aggregate count of gaming tables at casinos that are owned or operated. (Magnitude: actual)
hotelAvgDailyRate decimal{7,2} The average daily room rate. (Magnitude: $)
link measurementStandardId MeasurementStandard* A lookup key for measurement standards. If a lookup is not used, "0" represents United States Standard and "1" represents Metric.
mostRecentPeriod boolean Indicates that the record is the most recent one for a given period type
mostRecentSequence long(-32768,32767) A numerical rank indicating the recency of a record within its time series. A value of 1 denotes the most recent record, with increasing values (2, 3, etc.) representing progressively older records. The number of ranked records varies by entity, but a rank of 1 is always present.
mostRecentSequenceFiscalYears long(0,255) The identifier for the row that represents the most recent year-end.
mostRecentSequenceQuarter long(0,255) The identifier for the row that represents the most recent quarter.
multipleProperties boolean* Indicates that the property record contains information on more than one physical property due to limited disclosure by the company.
multiplePropertyCount long(-2147483648,2147483647) The number of physical properties a record comprises when it represents more than one property. (Magnitude: actual)
numberOfBuildings long(-2147483648,2147483647) The number of building structures the property comprises. (Magnitude: actual)
occupancyRate decimal{5,2} The reported occupancy rate of the property or properties. If an average occupancy is not available, an end-of-period measurement may be substituted. (Magnitude: %)
occupancyRateHotel decimal{5,2} The average reported occupancy for the company's owned hotel portfolio. (Magnitude: %)
priorPropertyFinl long(-2147483648,2147483647) The identifier for a prior property financial record.
propertyAcquisitionPrice long(-2147483648,2147483647) The historical cost basis assigned to the property by the acquirer. In the financial context, the value is currently on the financial statements, which may differ from the cost reported at the time of purchase. (Magnitude: $000)
propertyAcquisitionPriceBuild long(-2147483648,2147483647) The portion of the initial purchase price that is attributable to buildings and equipment or furnishings. (Magnitude: $000)
propertyAcquisitionPriceLand long(-2147483648,2147483647) The price paid for the land on which the property sits. (Magnitude: $000)
propertyAppraisalDate date The date at which the property was last appraised or revalued.
propertyAppraisalValue long(-2147483648,2147483647) The appraised value of the property. (Magnitude: $000)
propertyBaseRents long(-2147483648,2147483647) The annual base rents, where annualized figures may be substituted for actuals in some cases. (Magnitude: $000)
propertyCapRateTypeReported string(30) The type of capitalization rate (yield) as reported by the company.
propertyCarryValue long(-2147483648,2147483647) The initial cost of the property plus capitalized expenditures and land improvements, net of writedowns. (Magnitude: $000)
propertyCarryValueBldg long(-2147483648,2147483647) The book value of the property's improvements, representing the historical cost, before depreciation. (Magnitude: $000)
propertyCarryValueCapEx long(-2147483648,2147483647) The capitalized expenditures accounted for subsequent to the acquisition or construction of the property. (Magnitude: $000)
propertyCarryValueCapExLand long(-2147483648,2147483647) The capitalized improvements to land, additional land added to the property subsequent to purchase, or other change in land value. (Magnitude: $000)
propertyCarryValueLand long(-2147483648,2147483647) The book value of the land underlying the property, representing the historical cost before depreciation. (Magnitude: $000)
propertyCarryValueNet long(-2147483648,2147483647) The carrying value of the property, reflecting the historical cost of the property and improvements, net of accumulated depreciation. This represents the reported book value, fair value, market value, or tax assessment value for companies that do not depreciate their assets. (Magnitude: $000)
propertyCarryValueWritedown long(-2147483648,2147483647) The reductions to the carrying value of the property as a result of permanent impairments or changes to fair-market value. (Magnitude: $000)
propertyDepreciation long(-2147483648,2147483647) The accumulated depreciation of the property since acquisition or construction. (Magnitude: $000)
propertyFinlAsOf date* The date for which the property financial information is reported.
propertyFinlId long(-2147483648,2147483647)* The unique identifier for property financial data.
propertyNOI long(-2147483648,2147483647) The net operating income of the property, on an annualized basis. (Magnitude: $000)
link propertyOwnershipId PropertyOwnership* The unique identifier for property ownership data.
propertyRentPerArea decimal{10,2} The rental rate, which may be either the actual historic amount earned or the current offer rate, depending on the company's reporting practices. (Magnitude: $/sq ft/yr)
propertyRentPerSqFt decimal{22,8} The rental rate, which may be either the actual historic amount earned or the current offer rate, depending on the company's reporting practices. (Magnitude: $/sq ft/yr)
propertyRentPerSqFtMonthly decimal{22,8} The rental rate, which may be either the actual historic amount earned or the current offer rate, depending on the company's reporting practices. (Magnitude: $/sq ft/mo)
propertyRentPerUnit decimal{9,2} The average monthly property rent per dwelling unit. (Magnitude: $/unit/mo)
propertySalesPerArea decimal{10,2} The sales for the property, which may be either the actual historic sales or the current sales, depending on the company's reporting practices.
propertySalesPerSqFt decimal{22,8} The sales for the property, which may be either the actual historic sales or the current sales, depending on the company's reporting practices. (Magnitude: $/sq ft/yr)
propertySalesPerSqFtMonthly decimal{22,8} The sales for the property, which may be either the actual historic sales or the current sales, depending on the company's reporting practices.(Magnitude: $/sq ft/mo)
propertySizeArea long(-2147483648,2147483647) The total interior area of the building or buildings. (Magnitude: sq. ft.)
propertySizeBeds long(-2147483648,2147483647) The number of beds in a health-care or student housing facility. (Magnitude: actual)
propertySizeCasino decimal{22,8} The area of the casino portion of a property. (Magnitude: sq. ft.)
propertySizeCasinoArea long(-2147483648,2147483647) The area of the casino portion of a property. (Magnitude: sq. ft.)
propertySizeColdStorage decimal{22,8} The volume within the property or properties available for use as cold storage. (Magnitude: cubic ft)
propertySizeColdStorageVol long(-2147483648,2147483647) The volume within the property or properties available for use as cold storage. (Magnitude: cubic ft)
propertySizeConference decimal{22,8} The space available for conference-hosting. (Magnitude: sq. ft.)
propertySizeConferenceArea long(-2147483648,2147483647) The space available for conference-hosting. (Magnitude: sq. ft.)
propertySizeGLA decimal{22,8} The total area of the property as reported by the company. If total area is not reported by the company but owned gross leasable area is disclosed, the owned gross leasable area is presented if applicable. (Magnitude: sq. ft.)
propertySizeGolfHoles long(-2147483648,2147483647) The number of holes. (Magnitude: actual)
propertySizeGolfYards long(-2147483648,2147483647) The total yardage of golf courses. (Magnitude: yards)
propertySizeHotelSuites long(-2147483648,2147483647) The number of hotel suites, comprising more than one room. (Magnitude: actual)
propertySizeHotelUnclassified long(-2147483648,2147483647) The number of hotel rooms not classified as suites. (Magnitude: actual)
propertySizeLand decimal{22,8} The land area underlying the property. (Magnitude: acres)
propertySizeLandArea decimal{10,2} The land area underlying the property. (Magnitude: acres)
propertySizeMovieScreens long(-2147483648,2147483647) The number of movie screens. (Magnitude: actual)
propertySizeParking long(-2147483648,2147483647) The number of parking spaces. (Magnitude: actual)
propertySizePassengers long(-2147483648,2147483647) The maximum number of passengers allowed on a mode of transportation. (Magnitude: actual)
propertySizeRooms long(-2147483648,2147483647) The size of a hotel or hotels measured in number of rooms and suites. (Magnitude: rooms)
propertySizeSqFt decimal{22,8} The total interior area of the building or buildings. (Magnitude: sq. ft.)
propertySizeStorage decimal{22,8} The area of self-storage space as directly reported from the original data source. This value reflects the square footage provided by external parties or documents, without adjustment. (Magnitude: sq. ft.)
propertySizeStorageArea long(-2147483648,2147483647) The area of self-storage space calculated or derived through internal processes to ensure consistency and accuracy. This value may be based on standardized measurement methods, reconciled data, or internal calculations, and is expressed in square feet. (Magnitude: sq. ft.)
propertySizeStorageUnits long(-2147483648,2147483647) The number of self-storage units. (Magnitude: actual)
propertySizeTheaterSeats long(-2147483648,2147483647) The number of theater seats. (Magnitude: actual)
propertySizeTimber decimal{22,8} The area of timbered land comprising the property, as directly reported from the original data source. This value reflects the timber acreage as provided by external parties or documents, without adjustment. (Magnitude: acres)
propertySizeTimberArea long(-2147483648,2147483647) The area of timbered land comprising the property, calculated or derived through internal processes to ensure consistency and accuracy. (Magnitude: acres)
propertySizeUnits long(-2147483648,2147483647) The number of apartments or other dwelling units in the property. (Magnitude: units)
revenueGamingGames long(-2147483648,2147483647) The revenues earned from customer losses, net of house losses, at games of chance and from wager-book activities. (Magnitude: $000)
revenuePerAvailableRoom decimal{7,2} The revenue per available hotel room (includes only owned and leased properties in which the company has ownership interest). (Magnitude: $)
snpFiscalQuarter long(-2147483648,2147483647) The fiscal quarter within the company's fiscal year.
snpFiscalYear string(4) The company's fiscal year.
82 rows of 82 total
API Open API Specification