- address
- The address exactly as you submitted it. Confirmed - filled in all four runs.
- lat
- Latitude of the resolved address, as a string. Confirmed - filled in all four runs.
- lon
- Longitude of the resolved address, as a string. Confirmed - filled in all four runs.
- matched_address
- The address normalised to a full postal form - street, neighbourhood, city, county, state, postcode, country. Confirmed - filled in all four runs.
- residents
- The people listed at the address. Declared only - empty in all four runs; see the
status column for why. - status
- What happened to this lookup. Confirmed - filled in all four runs. Values seen:
no public residents and residents unavailable on free pool - needs residential proxy. - query
- The address echoed back. Confirmed in the wide shape; absent from the narrow one.
- building_type
- The kind of building at the address. Declared only - empty in all runs we hold.
- full_address
- The same normalised address as
matched_address. Confirmed in the wide shape - the two carried identical values in every wide run. - residents_count
- How many people are listed. Declared only - empty in all runs we hold.
- property_context
- The
@context of the property record - the vocabulary the property_* columns are expressed in. Declared only. - property_type
- The
@type of the property record. Declared only. - property_address_type
- The type of the property's address object. Declared only.
- property_address_street_address
- Street line of the property address. Declared only.
- property_address_postal_code
- Postcode of the property address. Declared only.
- property_address_address_locality
- Town or city of the property address. Declared only.
- property_address_address_country
- Country of the property address. Declared only.
- property_contained_in_place_type
- Type of the larger place the property sits inside - the containing neighbourhood or municipality. Declared only.
- property_contained_in_place_name
- Name of that containing place. Declared only.
- property_contained_in_place_address_type
- Type of the containing place's address object. Declared only.
- property_contained_in_place_address_address_region
- Region or state of the containing place. Declared only.
- property_contained_in_place_address_postal_code
- Postcode of the containing place. Declared only.
- property_contained_in_place_address_address_country
- Country of the containing place. Declared only.
- property_name
- Name of the property record. Declared only.
- property_geo_type
- Type of the property's geo object. Declared only.
- property_geo_latitude
- Latitude from the property record - distinct from the top-level
lat. Declared only. - property_geo_longitude
- Longitude from the property record - distinct from the top-level
lon. Declared only. - property_floor_size_type
- Type of the floor-area measurement. Declared only.
- property_floor_size_value
- Floor area as a number. Declared only.
- property_floor_size_unit_code
- The unit that number is in - a UN/CEFACT code such as
FTK for square foot or MTK for square metre. Read it before you compare two rows. Declared only. - property_year_built
- Year of construction. Declared only.
- property_identifier
- The property record's own identifier. Declared only.
- property_description
- Free-text description of the property. Declared only.