Q4 2020

Wrap up of all releases and updates from October to December 2020 (Q4).

DoordaProperty, Commercial Locations

New Variable - Postcode centroids added to the following API endpoints:

• https://api.doorda.com/commercial_location/eaw/commercial_rating/
• https://api.doorda.com/commercial_location/eaw/commercial_rating/udprn/{udprn}
• https://api.doorda.com/commercial_location/eaw/commercial_rating/uarn/{uarn}
• https://api.doorda.com/commercial_location/eaw/commercial_rating/ba_urn/{ba_urn}
• https://api.doorda.com/commercial_location/eaw/commercial_rating/company_number/{company_number}

New Variable - Postcode centroids added to the following table in DoordaHost:

• commercial_rating

Deprecation - Following tables deprecated from DoordaHost:

• commercial_occupant
• commercial_rate_additional_item
• commercial_rate_line_item
• commercial_rate_parking_space
• commercial_rate_plant_and_machinery
• commercial_rate_summary

New Tables - New commercial rates set added to DoordaHost to replace deprecated tables:

• commercial_rating
• commercial_rating_content
• commercial_rating_ratepayer

Deprecation - Following API endpoints have been deprecated:

• https://api.doorda.com/commercial_location/eaw/commercial_occupant/udprn/{udprn}
• https://api.doorda.com/commercial_location/eaw/commercial_occupant/location_id/{location_id}
• https://api.doorda.com/commercial_location/eaw/commercial_occupant/company_number/{company_number}
• https://api.doorda.com/commercial_location/eaw/commercial_rate_summary/udprn/{udprn}
• https://api.doorda.com/commercial_location/eaw/commercial_rate_summary/location_id/{location_id}
• https://api.doorda.com/commercial_location/eaw/commercial_rate_parking_space/udprn/{udprn}
• https://api.doorda.com/commercial_location/eaw/commercial_rate_parking_space/location_id/{location_id}
• https://api.doorda.com/commercial_location/eaw/commercial_rate_line_item/udprn/{udprn}
• https://api.doorda.com/commercial_location/eaw/commercial_rate_line_item/location_id/{location_id}
• https://api.doorda.com/commercial_location/eaw/commercial_rate_additional_item/udprn/{udprn}
• https://api.doorda.com/commercial_location/eaw/commercial_rate_additional_item/location_id/{location_id}
• https://api.doorda.com/commercial_location/eaw/commercial_rate_plant_and_machinery/udprn/{udprn}
• https://api.doorda.com/commercial_location/eaw/commercial_rate_plant_and_machinery/location_id/{location_id}

New API endpoints - Following API endpoints added to replace the deprecated content:

• https://api.doorda.com/commercial_location/eaw/commercial_rating/{postcode}
• https://api.doorda.com/commercial_location/eaw/commercial_rating/udprn/{udprn}
• https://api.doorda.com/commercial_location/eaw/commercial_rating/uarn/{uarn}
• https://api.doorda.com/commercial_location/eaw/commercial_rating/ba_urn/{ba_urn}
• https://api.doorda.com/commercial_location/eaw/commercial_rating/company_number/{company_number}
• https://api.doorda.com/commercial_location/eaw/commercial_rating_content/ba_urn/{ba_urn}
• https://api.doorda.com/commercial_location/eaw/commercial_rating_content/uarn/{uarn}
• https://api.doorda.com/commercial_location/eaw/commercial_rating_content/udprn/{udprn}
• https://api.doorda.com/commercial_location/eaw/commercial_rating_content/company_number/{company_number}
• https://api.doorda.com/commercial_location/eaw/commercial_rating_ratepayer/company_number/{company_number}
• https://api.doorda.com/commercial_location/eaw/commercial_rating_ratepayer/ba_urn/{ba_urn}
• https://api.doorda.com/commercial_location/eaw/commercial_rating_ratepayer/udprn/{udprn}

New Variables - Addresses without a corresponding UDPRN now available in:

• cqc_location_inspection
• food_hygiene
• gambling_premise tables

DoordatStats

New Tables - Two new residential property price tables added to Host

• residential_property_average_price - All English and Welsh average property sale prices by type, monthly refresh
• residential_property_price_band - All English and Welsh property sales grouped into bands, monthly refresh

New API endpoints - Two new endpoints added to API

• https://api.doorda.com/stats_v2/eaw/residential_property_average_price/{postcode} - All English and Welsh average property sale prices, monthly refresh
• https://api.doorda.com/stats_v2/eaw/residential_property_price_band/{postcode} - All English and Welsh property sales grouped into bands, monthly refresh

Deprecation - The following endpoints will be deprecated 

• https://api.doorda.com/stats/eng/area_property_price_all/{postcode}
• https://api.doorda.com/stats/eng/area_property_price_bands_all/{postcode}
• https://api.doorda.com/stats/eng/area_property_price_bands_detached/{postcode}
• https://api.doorda.com/stats/eng/area_property_price_bands_flat/{postcode}
• https://api.doorda.com/stats/eng/area_property_price_bands_semi/{postcode}
• https://api.doorda.com/stats/eng/area_property_price_bands_terraced/{postcode}
• https://api.doorda.com/stats/eng/area_property_price_detached/{postcode}
• https://api.doorda.com/stats/eng/area_property_price_flat/{postcode}
• https://api.doorda.com/stats/eng/area_property_price_semi/{postcode}
• https://api.doorda.com/stats/eng/area_property_price_terraced/{postcode}
• https://api.doorda.com/stats/wls/area_property_price_all/{postcode}
• https://api.doorda.com/stats/wls/area_property_price_bands_all/{postcode}
• https://api.doorda.com/stats/wls/area_property_price_bands_detached/{postcode}
• https://api.doorda.com/stats/wls/area_property_price_bands_flat/{postcode}
• https://api.doorda.com/stats/wls/area_property_price_bands_semi/{postcode}
• https://api.doorda.com/stats/wls/area_property_price_bands_terraced/{postcode}
• https://api.doorda.com/stats/wls/area_property_price_detached/{postcode}
• https://api.doorda.com/stats/wls/area_property_price_flat/{postcode}
• https://api.doorda.com/stats/wls/area_property_price_semi/{postcode}
• https://api.doorda.com/stats/wls/area_property_price_terraced/{postcode}

Misc -

• Latest release of DoordaMatch applied to address matching
• Department, Organisation and Residential columns added to CAF table
• Formatting issue in PAF which resulted in some road and flat numbers appearing in the same field resolved and applied to the CAF table.
• Addresses without a corresponding UDPRN now available in
  • Company_Address
  • Company_Appointment
  • Residental_Energy_Performance
  • Residential_Property_Sales.
  • Company_Appointments table can now be linked to Register_Company_Appointment in DoordaBiz on URN.