Bytero Listings
The properties on offer right now, one row per advert: where the property is, what it is, what is asked for it and the attributes the advert states.
What a row is
One row is one advert of a property that is on offer: for sale or for rent, a flat, a house, land or a commercial property. It carries the place (country, region, district, town, postcode and a point where the advert gives one), the kind of property, the asking price in EUR and as stated, and the attributes: areas, rooms, floor, year built, condition and energy class.
How the values are made
Live. An advert is in the table while it was seen on offer in the last 14 days; FIRST_SEEN and LAST_SEEN are the first and the last day we saw it. The table is rebuilt every day.
Place. The region and the district are the administrative units the advert's point lies in; without a point they follow from the postcode or the town the advert states, and LOCATION_BASIS says which. The point itself is only ever the one the advert gives.
Price. Prices are converted to EUR at a fixed table of rates. Where an advert states a rent per m² and month, PRICE_EUR is that times the area and PRICE_BASIS says so.
One list of terms. Every country names kinds of property, conditions and energy classes in its own way. They are mapped to one English list each; a term that has no place in the list is left empty, never passed on as it stood.
Quality. No row is dropped; rows are flagged: a missing price, a price or an area far outside what its market asks, a missing place, and a duplicate. A property advertised more than once carries DUPLICATE_OF, the number of its fullest advert.
What it is not
Prices are asking prices, not sold prices. The table holds no advertiser names or contacts, no advert text, no photos, no links and no street addresses. Attributes are what the adverts state; they are not checked against a register.
Region boundaries: geoBoundaries. Postcode and town points: GeoNames.
Table MARKET.LISTINGS
32 columns
Bytero Listings: properties on offer right now, one row per advert, with the place, the kind of property, the price and the attributes the advert states. Asking prices. No advertiser, no advert text, no link.
LISTING_IDnumber- Our own number of the advert
COUNTRYtext- ISO 3166 code
REGIONtext- First-level administrative region the property lies in
DISTRICTtext- Second-level administrative unit; empty where the country publishes none
CITYtext- Town or city as the advert states it, in the local spelling
POSTCODEtext- Postcode, where the advert states one
LATnumber- Latitude of the point the advert gives (WGS84); empty where it gives none
LONnumber- Longitude of that point (WGS84)
LOCATION_BASIStext- How REGION and DISTRICT were found: point (the advert point lies inside), near (within 15 km of the boundary), postcode, town, name
ASSET_GROUPtext- Residential, Commercial, Land, Parking, Other
ASSET_CLASStext- Flat, House, Holiday home, Land, Parking, Office, Retail, Warehouse, Production, Hospitality, Investment property, Other commercial, Other
OFFERtext- Sale or Rent; a rent is per month
PRICE_EURnumber- Asking price in EUR (a rent: per month); empty where the advert states no price
PRICE_EUR_M2number- PRICE_EUR per m2 of AREA_M2 (land: per m2 of LAND_AREA_M2)
PRICE_LOCALnumber- Asking price as the advert states it, in CURRENCY
CURRENCYtext- ISO 4217 code of PRICE_LOCAL
PRICE_BASIStext- Total, or Per m2: the advert stated a rent per m2 and month, and PRICE_EUR is that times the area
AREA_M2number- Usable floor area, m2
LAND_AREA_M2number- Area of the land or plot, m2
ROOMSnumber- Number of rooms; 5 = five or more
FLOORnumber- Floor the property is on
STOREYSnumber- Storeys of the building
YEAR_BUILTnumber- Year built, as the advert states it
CONDITIONtext- New build, Under construction, Shell, Renovated, Partly renovated, Very good, Good, Average, Original condition, Needs renovation, For demolition; empty where the advert states none
ENERGY_CLASStext- Energy class letter A to G (A+ and finer classes count as their letter)
BY_AGENCYtrue / false- True where the advert names an agency as the advertiser
FIRST_SEENdate- Day we first saw the advert
LAST_SEENdate- Day we last saw the advert on offer
QUALITY_SCOREnumber- Share (0 to 100) of the attributes that apply to this kind of property that the advert fills
QUALITY_FLAGStext- price_missing, price_junk, price_outlier, area_outlier, no_geo, duplicate; empty = none. Rows are flagged, never dropped
DUPLICATE_OFnumber- For a property advertised more than once: the LISTING_ID of the fullest advert of it
SNAPSHOT_DATEdate- Day the table was built