API for Housing Data

By 0 , Permalink 0

Using the Quandl API for Housing Data

This document is a comprehensive guide to using the Quandl API to access our free house price data. If you haven’t already done so, we recommend reading Quandl’s general API documentation; the functionality will be a lot clearer if you do so.

Free Unlimited API for Housing Data

Quandl offers 30+ real estate market indicators for over 35,000 geographical areas across the United States. Quandl’s easy to use API gives access to housing prices and housing market data. With numerous software packages, including R and Python, Quandl is the easiest way to find and download historical house prices. This page is a tutorial on usage of the API to access housing data.

Accessing real estate data via the API is no different than the mechanism for all data on Quandl. The purpose of this help page is simply to explain the specific nomenclature we’re using for real estate indicators. For general help, see API. For package specific help, start on the tools page.

 

To start using the Quandl API:

  1. Sign up for a free API key
  2. Find the data you need: use the list below or use our search page.
  3. Start making calls: use our API reference page to learn the syntax.

 

Basic Housing API Usage

Code Format

All Zillow dataset codes follow the same format

ZILL/{AREA_CATEGORY}{AREA_CODE}_{INDICATOR_CODE}

With AREA_CODE found in the excel file below, AREA_CODE and INDICATOR_CODE are presented in the tables below.

Basic Example

Colorado’s median home prices:

http://www.quandl.com/api/v3/datasets/ZILL/S00022_A.csv

Available Geographical Areas

Each area category has a unique mapping between area and area code. Complete lists of these mappings can be found in pipe delimited csv files below. No file exists for Zip Code because for data by zip code, the zip code itself is the area code.

Area Categories

Code

Area

Area Code File

S

State

State Code File

CO

County

County Code File

M

Metropolitan

Metro Code File

H

Neighbourhood

Neighborhood Code File

C

City

City Code File

Z

Zip Code

Area

Area Code File

S

State Code File

CO

County Code File

M

Metro Code File

C

City Code File

H

Neighbourhood Code File

The format of each sheet is:

Area

Code

The Area header differs by file, with each files header outlining the components of it’s area. For example State Codes look like this:

Region,State,Metro,County

Code

New York,NY,New York,Queens

00001

Los Angeles,CA,Los Angeles,Los Angeles

00002

Housing Data Indicators

The area code can be found in the excel spreadsheet above.

Indicators

Indicator Code

Indicator Name

All Homes

A

Single Family Residences

SF

Condominiums

C

Price per Square Foot

MVSF

1 Bedroom

1B

2 Bedroom

2B

3 Bedroom

3B

4 Bedroom

4B

5 or More

5B

Bottom Tier

BT

Middle Tier

MT

Top Tier

TT

Median Rent, Homes Listed for Rent

RMP

Estimated Rent, All Homes in Region

RAH

Estimated Rent per Square Foot

RZSF

Price-to-Rent Ratio

PRR

Median List Price

MLP

Median Sale Price

MSP

Median List Price per Square Foot

MLPSF

Median Sale Price per Square Foot

MSPSF

Listings with Price Cut in Last 30 Days

LPC

Median Price Cut

MPC

Ratio of Sale Price to List Price

SLPR

Sold for Loss

SFL

Sold for Gain

SFG

Increasing Values

IV

Decreasing Values

DV

Turnover in Housing Market, Past 1 Year

SPY

Number of Homes for Rent

HR

Monthly Foreclosures per 10,000 Homes

HF

Percentage of Sales that were Foreclosures

FR

Basic Housing Market Example

Therefore if you wanted to find the home turnover in the past year in the 90210 zip code, you would construct the Quandl code like so:

Area Category = Z

Indicator code: SPY

Area Code: 90210

Quandl Code: ZILL/Z90210_SPY

Then you could make the GET call to

http://www.quandl.com/api/v3/datasets/ZILL/Z90210_SPY.csv

To receive a csv of the data.

Additional Resources

  • Additional information is available on our API reference page.
  • All of Quandl’s datasets are also available through a number of tools.

 

Get Started Now!

To use Quandl’s API, please sign up for a free API key:
Get Your Free API Key Now
 

Leave a Reply

Your email address will not be published. Required fields are marked *


No Comments Yet.