© 2024 Move, Inc. All rights reserved. Do not copy or distribute.

How to analyze freely-available real estate data to tell your community’s story

​

​

NICAR

Baltimore

March 7, 2024

Email: evan.wyloge@realtor.com

Twitter: @evanwyloge

Link to these slides: bit.ly/rdc_nicar24_slides

© 2024 Move, Inc. All rights reserved. Do not copy or distribute.

What are we going to cover?

​

• Examples of work we’ve done, discussion of methods
• Look at Realtor.com data
• Demo using Realtor.com data for (relatively) easy story generation
• Technical skills: Google Sheets, Pivot Tables, Datawrapper

​

​

© 2024 Move, Inc. All rights reserved. Do not copy or distribute.

What are we going to cover?

​

• Examples of work we’ve done, discussion of methods
• Look at Realtor.com data
• Demo using Realtor.com data for (relatively) easy story generation
• Technical skills: Google Sheets, Pivot Tables, Datawrapper

​

But first…

Tell me what you’re most interested in

​

© 2023 Move, Inc. All rights reserved. Do not copy or distribute.

Examples of data-driven journalism at Realtor.com

Affordability challenges caused by interest rates

• Data used:
• Median home listing price over time
• Mortgage rates over time

The Monthly Payment for a Starter Home Is How Much?! See America’s Home Affordability Crisis, Metro by Metro

• Data used:
• Listing prices by price tier (not available publicly/freely)
• Combined with mortgage payment calculator

© 2023 Move, Inc. All rights reserved. Do not copy or distribute.

Examples of data-driven journalism at Realtor.com

Mom-and-Pop Real Estate Investors Are Pulling Way Back. Here’s Where—and Why It Matters

• Deed data indicating investor purchases

​

14 Great Ski Towns You’ve Never Heard Of (That Are Affordable for Buying a Home)

• Data used:
• Median home prices, by city (census designated places). This was calculated, but could have used ZIP codes
• Ski locations

© 2023 Move, Inc. All rights reserved. Do not copy or distribute.

Examples of data-driven journalism at Realtor.com

How Much Do You Need To Earn To Buy a Starter Home Across the Country?

• Data used:
• “Starter home” prices (Method: 2-bedroom, 25th/30th percentile)
• Mortgage rates
• MSA-level median “starter home” prices x mortgage rates, and affordability calculator

Starter Home Prices Are Soaring and Luxury Is in a Slump—What’s Going On?

• Listing data for “starter homes” and for luxury homes (95th percentile)

Getting into the data

Let’s look at the data RDC Public data portal (realtor.com/research/data)

Reports/Visualizations using both public + internal data:

realtor.com/research/reports/

​

​

Here’s a link to some exports of this data that we can look at and use:

bit.ly/rdc_nicar24_files

MONTHLY INVENTORY FILE

MONTHLY “HOTNESS” FILE

• Most current, but limited in measurements
• Year-over-year changes, but not levels
• Only one flavor: National-level only

​

• More than what’s available in the weekly file (level, month-over-month, year-over-year)
• Updated at the beginning of every month
• Every flavor: Available at zip, county, metro, state and national-level

​

• Like the monthly inventory file, but with some different measurements
• Supply score, Demand score, “hotness” score
• Limited flavors: County, metro and zip-level

​

​

WEEKLY INVENTORY FILE

7

Get previews of upcoming research/releases:

​

• monthly housing reports
• best time to buy
• best time to sell
• hottest zips report
• housing supply report
• investor report
• survey data

​

We send the narrative release preview, and data if requested

​

Sign up for Realtor.com data & research releases

8

www.realtor.com/research

8

Email: evan.wyloge@realtor.com

Twitter: @evanwyloge

Link to these slides: bit.ly/rdc_nicar24_slides

​

​

Thank you

​

Questions?

9

9