Data Dictionary

This data dictionary provides a comprehensive overview of the data fields used in the RealPage Collusion dashboards, visualizations, and analyses. It serves as a reference for understanding the structure and content of the data, which is essential for interpreting the results and insights presented in the dashboard. It includes descriptions of each field, its data type, and its significance in the context of the dashboard's functionality.

Rent Page & Comparison Data, Core-Based Statistical Area

Example Data Featured

Note: The examples below are made up for the purpose of demonstration.

Sample Row - Woodstone Village (RealPage Property)
  • Location & Basics: Located in Westminster, CO, zip code 80031, address “4941 W 81st Pl.”
  • Property Details: 2-story, Class C, built in 1984, 192 units, average unit size 746 sq ft.
  • Rent Metrics: Annual rent change of 2.13%, asking rent $1,441, rent per square foot 1.93.
  • Submarket Data: Submarket: Westminster. Additional historical submarket price band metrics may apply.
Sample Row - Brix Warehouse District ('Other' Property)
  • Location & Basics: Phoenix, AZ (85003), “402 W Lincoln St.”
  • Property Details: 4-story, Class A, built in 2023, 300 units, average unit size 941 sq ft.
  • Rent Metrics: 5.7% annual rent increase, asking rent $1,848, rent per square foot 1.964.
  • Submarket Data: Submarket: Central Phoenix. Additional historical submarket price band metrics may apply.

Download Scraped RealPage Data

CSV JSON
Field Descriptions
Field Name Type Description
propertyId Integer Unique identifier for each property.
propertyName Text Name of the property.
zipCode Text Postal code where the property is located.
address Text Street address of the property.
city Text City in which the property is situated.
state Text Two-letter state code representing the location.
averageSquareFootage Number Average square footage per unit at the property.
stories Number Number of stories in the property building.
stable Text Indicates whether the property’s operational status is stable.
class Text Classification rating of the property, typically represented by a letter (for example, “A,” “B,” or “C”).
latitude Number Geographic latitude of the property.
longitude Number Geographic longitude of the property.
imageHero Text File path or URL for the primary image associated with the property.
heroSource Text Source of the hero image; for example, the name of the image provider.
submarketName Text Submarket or subregion where the property is located.
unitcount Number Total number of residential or commercial units in the property.
yearBuilt Number The year the property was constructed.
siteStatus Text Current status of the property site (for example, “Stabilized”).
type Text Property type or building style (for example, “Conventional”).
MPF-ANN-RENT-CHG Number Annual change in rent, represented as a decimal value.
MPF-HIST-ASK-RENT Number Historical asking rent value; typically, the monthly rent amount in dollars.
MPF-HIST-AVG-ASK-RPSF Number Historical average asking rent per square foot.
MPF-HIST-CONC-RATIO Number or Text Historical concession ratio, indicating any adjustments made to rent (this value may be missing).
MPF-OCC Number Occupancy metric; likely represents the occupancy rate of the property.
MPF-RENT Number Current rent amount at the property.
MPF-RPSF Number Current rent per square foot.
data_index Number Index number assigned to the data row.
cbsa_code Number Core-based statistical area code representing the broader metropolitan area.

Comparables Workbooks – Rent Comparison Data by Core-Based Statistical Area

Example Data Featured

Note: The examples below are made up for the purpose of demonstration.

Sample Row – Santa Cruz–Watsonville, CA (Comparables Workbooks)
  • Area & Basics: Area name: Santa Cruz–Watsonville, CA; CBSA: 42100.
  • Rent Metrics: HUD Fair Market Rent: $3,388.65; RealPage Rent: $3,452.15; Zillow Rent: $3,016.74.
  • Market Share: RealPage market share: 9.30%.
  • Average Rent: Average of rents: $3,286.

Download Comparables Workbooks Data

Excel
Comparables Workbooks Field Descriptions
Field Name Type Description
HUD Metro Fair Market Rent Area Name Text Name of the metro area as defined by HUD.
CBSA Number Core-based statistical area code representing the broader metropolitan area.
HUD Number HUD-determined Fair Market Rent value.
Realpage Number Rent value as stated by RealPage.
Zillow Number Rent value listed on Zillow.
Realpage Market Share Number Market share percentage for RealPage.
Avg of Rents Number Average rent value computed from the available sources.

Zillow Rent Over Time – Analysis of Rent Trends Relative to RealPage Market Share

Example Data Featured

Sample Row – Austin, TX (Zillow Rent Over Time)
  • Region & Basics: Region name: Austin, TX; RealPage market share: 46.00%.
  • Rent Over Time: January 31, 2015: $1,092.69; February 28, 2015: $1,101.90; March 31, 2015: $1,105.17; April 30, 2015: $1,103.27.

Download Zillow Rent Over Time Data

EXCEL
Zillow Rent Over Time Field Descriptions
Field Name Type Description
RegionName Text Name of the region or city under analysis.
Realpage Market Share Number Market share percentage for RealPage in the region.
1/31/2015 Number Rent value on January 31, 2015.
2/28/2015 Number Rent value on February 28, 2015.
3/31/2015 Number Rent value on March 31, 2015.
Continued through 2025 Continued, all "numbers" Continued, Rent value at the end of each month