Using the Nasdaq Data Link API for Housing Data
This document is a comprehensive guide to using the Nasdaq Data Link API to access our free house price data. If you haven’t already done so, we recommend reading Nasdaq Data Link’s general API documentation; the functionality will be a lot clearer if you do so.
Free Unlimited API for Housing Data
Nasdaq Data Link offers 30+ real estate market indicators for over 35,000 geographical areas across the United States. Nasdaq Data Link’s easy to use API gives access to housing prices and housing market data. With numerous software packages, including R and Python, Nasdaq Data Link 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 Nasdaq Data Link. The purpose of this help page is simply to explain the specific nomenclature we’re using for real estate indicators. For general help, see Getting Started with the Quandl API. For package specific help, start on the tools page.
To start using the Nasdaq Data Link API:
- Sign up for a free API key
- Find the data you need: use the list below or use our search page.
- 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://data.nasdaq.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 its 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 Time-Series Code like so:
Area Category = Z
Indicator code: SPY
Area Code: 90210
Time-Series Code: ZILL/Z90210_SPY
Then you could make the GET call to
http://data.nasdaq.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 Nasdaq Data Link datasets are also available through a number of tools.
Get Started Now!
To use Nasdaq Data Link API, please sign up for a free API key:
Get Your Free API Key Now
