SPARQL Endpoint
Source: data.gov.uk (2018-02-26)

Help to Buy Equity Loan Scheme -Total Equity Loans & Equity Loans First Time Buyers. This data set contains Help to Buy: Equity Loan statistics at local authority level and includes total equity loans and equity loans to first time buyers . For data released from 5 March 2015 onwards, the Homes and Community Agency (HCA) have revised the completion date for the entire Help to Buy Equity Loan time series. The HCA have stopped counting payment date (when the money out is paid out by the HCA) and now report on the expected actual completion date. It is more accurate and is closer to the live situation, especially when HCA now recognise an asset based on a completion, rather than exchange and approved claim. As a result (and due to reinstating accounts) HCA have seen movement of actual completions dates. There should not be this level of difference moving forward, it was a one off activity.  

Information on the allocation of completed sales to postcode sectors is derived using the latest available information on the full postcode for each scheme, which may be subject to revision. 

For sales before 31 March 2014, properties are included under the local authority district to which they were initially allocated. In some cases, this differs from latest information, which forms the basis of the first column of local authority district figures. Figures for some local authorities may be subject to revisions later in the year. 

Although local authority information is validated against other geographic data at the time of data entry, detailed reconciliation of the data, conducted twice a year, may result in a small number of changes to these monthly releases, for example where a new development crosses a local authority boundary. 						

An equity loan is Government financial assistance given to eligible applicants to purchase an eligible home through a Government equity mortgage 
secured on the home. The Government equity mortgage is ranked second in priority behind an owner’s main mortgage lender. 

This scheme offers up to 20 per cent of the value as Government assistance to purchasers buying a new build home. The buyer must provide a cash deposit of
at least 5 per cent and a main mortgage lender must provide a loan of at least 75 per cent. 

The Government assistance to buy is made through an 
equity loan made by the Homes and Communities Agency (HCA) to the purchaser. 

Help to Buy equity loans are only available on new build homes and the maximum purchase price is £600,000. Equity loan assistance for purchasers is paid via house builders registered with the HCA to participate in the Help to Buy equity loan initiative. The payment is made to builders (via solicitors) at purchaser legal completion. 

The equity loan is provided without fees for the first five years of ownership. 

The property title is held by the home owner who can therefore sell their home at any time and upon sale should provide the government the value of the same equity share of the property when it is sold.

For further information see  
[Help to Buy (equity loan) scheme monthly statistics](https://www.gov.uk/government/statistics/help-to-buy-equity-loan-scheme-and-help-to-buy-newbuy-statistics-april-2013-to-30-june-2017).

JavaScript is disabled, so you're missing out on some features.

From March 2025, you will only be able to access the Energy Performance Certificates and the Index of Multiple Deprivation tools. All other datasets will no longer be supported. Fill out our survey (https://forms.office.com/e/F1hxFb71JJ) to let us know how this affects you.

Ministry of Housing, Communities & Local Government

open data
- Atlas (/atlas)
- Data (/data_home)
- Search (/data/search)
- Data Cart (/cart)
Explore

All datasets

By theme

By organisation

Tools

Your data cart

SPARQL Query

Vocabularies

Dereference URI

Cube utilities

Help

[this is a icon-] developer tool

SPARQL 1.1 Query: Endpoint

An endpoint that allows you to query the data store using the SPARQL 1.1 language.

Preview Try the beta of our improved SPARQL editor. (/sparql-beta)

Enter Query

html json csv xml text n-triples Turtle rdf/xml json xml text

Validate URIs

SPARQL API: The Basics

The most flexible way to access the data is by using SPARQL, a query language, analagous to SQL for relational databases, for retrieving and manipulating data from graph databases like ours. We support SPARQL 1.1 (http://www.w3.org/TR/sparql11-query/) query syntax. Many online tutorials (http://www.cambridgesemantics.com/semantic-university/sparql-by-example) are available.

To submit a SPARQL query from your code, you issue an HTTP GET or POST to our endpoint:http://opendatacommunities.org/sparql, with the query itself as a url-encoded parameter called query.

For example, to run the following simple SPARQL query and get the results as JSON:

SELECT * WHERE {?s ?p ?o} LIMIT 10

Option 1: POST (recommended)

Issue a POST to the endpoint, with the query in the body, and an Accept header of sparql-results+json:

POST http://opendatacommunities.org/sparql HTTP/1.1 Host: opendatacommunities.org Accept: application/sparql-results+json Content-Type: application/x-www-form-urlencoded query=SELECT+%2A+WHERE+%7B%3Fs+%3Fp+%3Fo%7D+LIMIT+10

Option 2: GET

Issue a GET to the following URL (note the .json extension - see the formats (#results_formats) section for more detail on this):

GET http://opendatacommunities.org/sparql.json?query=SELECT+%2A+WHERE+%7B%3Fs+%3Fp+%3Fo%7D+LIMIT+10

Scroll down to the end of this page for examples (#examples) of both of these methods in a few different languages.

Results formats

As with other aspects of our API, to get the data in different formats, you can use either (a) a format extension or (b) an HTTP Accept header. Available result formats depend on the type of SPARQL query. There are four main forms:

SELECT queries return tabular results, and the formats available reflect this:

CONSTRUCT and DESCRIBE queries return graph data, so the results are available in the same formats as our resource APIs:

ASK queries return a boolean result:

Results pagination

We accept page and per_page parameters for paginating the results of SELECT queries (we automatically modify your query to apply LIMIT and OFFSET clauses). For other query types (i.e. DESCRIBE, CONSTRUCT, ASK), pagination like this doesn’t make so much sense, so these parameters are ignored.

For requests made through the website (i.e. HTML format), the page size is defaulted to 20. For requests to our sparql endpoint for data formats (i.e. non-HTML), there will be no defaults for these parameters (i.e. results are unlimited. For performance reasons we generally advise LIMITing your query if possible).

Parameter Substitution

You can parameterise your SPARQL by including %{tokens} in your queries, and providing values for the tokens in the request parameters.

Note that the following tokens are reserved and cannot be used as parameters for substitution:
- controller
- action
- page
- per_page
- id
- commit
- utf8
- query
Cross Origin Resource Sharing

Our servers are configured to allow access from all domains. This means that if you’re writing JavaScript to request data from our server in to a web page hosted on another domain, your browser should check this header and allow it.

If you need to support very old browsers, you can additionally pass a callback parameter and the results will be wrapped in that function. For example:

This help topic (https://learn.jquery.com/ajax/working-with-jsonp/) on the jQuery website has more details.

Examples

Using cURL

Here’s a couple of examples running a query using the widely available cURL (http://curl.haxx.se/) command line program.

Request the results as XML, using a POST:

Request the results as JSON, using a GET:

Using JavaScript

This example HTML page uses jQuery to issue a POST to our SPARQL endpoint, requesting the results as JSON.

Linked Open Data from DLUHC. News (http://news.opendatacommunities.org) | Apps (http://apps.opendatacommunities.org) | Contact: xxx@xxx.xx (mailto:xxx@xxx.xx)

This site uses cookies (/policy#cookies), respects your privacy (/policy#privacy) and works hard to be accessible to everyone (/policy#accessibility).

Powered by PublishMyData ©2010-2026 TPXimpact (https://tpximpact.com).