- query
- The StreetEasy search URL you submitted, repeated on every row that came from it.
- name
- The listing title - the street address with its unit designator, as in
80 Elizabeth Street #2K. Where a property has no unit, this matches address exactly. - price
- The asking price as a formatted string:
$820,000, with a dollar sign and thousands commas. Strip both before casting to a number - see the note below. - building_type
- The kind of building, as an enum. Observed:
CONDO, CO_OP, HOUSE, TWOFAMILY and UNKNOWN. Note the inconsistent naming, and treat the vocabulary as open - match the exact string. - bedrooms
- The bedroom count, as a string.
0 occurs, so do not treat a zero here as a missing value. - bathrooms
- The bathroom count, as a string. Carries halves -
1.5 and 2.5 both occur, so parse as a decimal rather than an integer. - size_sqft
- The interior size in square feet, as a string. Optional - plenty of listings do not publish one, across every building type.
- address
- The street address without the unit. Group on this when you want buildings rather than units.
- neighborhood
- StreetEasy's neighbourhood label for the property, such as
Little Italy or East New York. - region
- The state code the listing sits in. Worth checking rather than assuming - a search scoped to a city can still return listings across a state line.
- postcode
- The five-digit ZIP code.
- latitude
- The property's latitude, as a string. Cast it before you plot.
- longitude
- The property's longitude, as a string. Together with
latitude this makes the export mappable without a geocoding step. - url
- Link to the listing on StreetEasy. Two shapes occur: a
/sale/<id> permalink and a /building/<slug>/<unit> path. - image
- The listing's photo, on Zillow's image CDN - StreetEasy is a Zillow property, and the hostname shows it.
- position
- 1-based rank within the query, in the order StreetEasy returned the listing. JSON only - the CSV and XLSX exports stop at fifteen columns.