zillow_homes | Notion

Gets the inventory of zillow.com for USA and Canada (the only two nations in which Zillow currently operates).

Metadata

Frequency (UTC)	Tolerance	Earliest Collection Date	Source
15 12 * * 2			zillow.com

Data Dictionary

Column Name	Description	Type	Mode
bathrooms	number of bathrooms in the property	number	NULLABLE
bedrooms	number of bedrooms in the property	number	NULLABLE
buildingID	id of the building the property is in	string	NULLABLE
city	city the property is located in	string	NULLABLE
country	country the property is located in	string	REQUIRED
currency	currency of the price	string	REQUIRED
daysOnZillow	number of days the property has been listed on Zillow	number	NULLABLE
zpid	unique identifier for the property	string	REQUIRED
latitude	latitude of the property's location	number	NULLABLE
listingStatus	status of the listing (e.g. for sale, for rent, etc.)	string	NULLABLE
livingArea	living area of the property in number	number	NULLABLE
longitude	longitude of the property's location	number	NULLABLE
matchingHomeCount	number of properties available (i.e. for apartments)	number	NULLABLE
price	price of the property	number	NULLABLE
pricePerSquareFoot	price per square foot of the property	number	NULLABLE
state	state the property is located in	string	REQUIRED
streetAddress	street address of the property	string	REQUIRED
title	title of the property	string	NULLABLE
yearBuilt	year the property was built	number	NULLABLE
zestimate	Zillow's estimated value of the property	number	NULLABLE
rentZestimate	Zillow's estimated rent value of the property	number	NULLABLE
zipcode	zipcode of the property's location	string	NULLABLE
zillowOwnedProperty	whether the property is owned by Zillow	boolean	NULLABLE
dateCollected	The date that the data was snapshotted. This is not necessarily the date in which the data was collected, i.e. this could be from archive.	timestamp	REQUIRED
dateRepresented	The date that the data in this row represents. This is not necessarily the date the data was collected.	timestamp	REQUIRED
attemptID	The attemptID of the task that produced this row	string	REQUIRED
invocationID	Also known as run ID. The invocationID is associated with a write to BQ. This corresponds to the id of a successful run_feed message	string	REQUIRED
taskID	The unique identifier of the task that produced this row. Can be from a chain or write task.	string	REQUIRED

Notes

As of now Zillow operates in the US and Canada, we obtain all inventory for both regions.
It is possible to get inventory that is not on the market. We are not currently collecting this.
Zillow divides it’s property discovery into 3 categories - rent, for sale and recently sold. It’s possible for there to be overlap between these. We were originally only collecting rent and are now also collecting for sale.
We found 3 different endpoints that provide nearly the same data, with slight variances.
To get some of the items in the additional fields section we would likely have to 75x the number of requests we make to Zillow (requesting per property).
There is an isUnmappable flag which could potentially yield different results.
There are regions defined for American Samoa, Puerto Rico and Northern Mariana Islands as well. Only PR actually had data.
Earlier historical data is available for rentals continental USA + Canada.
We also collect regional totals as validation against the results of our row-level extraction.

Additional Fields

Column Name	Description	Type	Mode
annualHomeownersInsurance	annual cost of homeowners insurance for the property	number	NULLABLE
brokerName	name of the broker selling the property	string	NULLABLE
brokerPhoneNumber	phone number of the broker selling the property	string	NULLABLE
comingSoonOnMarketDate	date when the property will be available for sale	Date	NULLABLE
county	county the property is located in	string	NULLABLE
description	description of the property	string	REQUIRED
forSaleByAgent	whether the property is for sale by agent	boolean	REQUIRED
forSaleByOwner	whether the property is for sale by owner	boolean	REQUIRED
homeStatus	status of the property (e.g. for sale, sold, etc.)	string	NULLABLE
homeType	type of the property (e.g. house, apartment, etc.)	string	NULLABLE
isBankOwned	whether the property is bank-owned	boolean	REQUIRED
isComingSoon	whether the property is coming soon	boolean	REQUIRED
isForAuction	whether the property is for auction	boolean	REQUIRED
isOpenHouse	whether the property is open for house viewing	boolean	REQUIRED
isPending	whether the property is pending	boolean	REQUIRED
isPremierBuilder	whether the property is built by a premier builder	boolean	REQUIRED
isRentalsLeadCapMet	whether the property has met the rentals lead cap	boolean	REQUIRED
lastSoldPrice	price the property was last sold for	number	NULLABLE
listingDataSource	source of the property listing	string	REQUIRED
livingAreaUnits	units of the living area (e.g. sqft, sqm, etc.)	string	NULLABLE
lotAreaUnits	units of the lot area (e.g. sqft, sqm, etc.)	string	NULLABLE
lotAreaValue	area of the lot the property is on	number	NULLABLE
lotSize	size of the lot the property is on	number	NULLABLE
neighborhood	neighborhood the property is located in	string	NULLABLE
pageViewCount	number of times the property's page has been viewed	number	REQUIRED
regionString	region the property is located in - this is defined but always empty in the sample	string	REQUIRED
sellingSoon	percentage of how soon the property is selling	number	NULLABLE