Skip to contents

Run a SPARQL query

Source: R/sparql.R
ukh_sparql.Rd

Runs a SPARQL query against one of the supported endpoints and returns the result as a data frame. Useful for queries that aren't covered by the dedicated helpers, including custom HPI aggregations and Price Paid Data lookups by postcode.

Usage

ukh_sparql(
  query,
  endpoint = c("land-registry", "opendatacommunities"),
  timeout = 60L
)

Arguments

query

Character. A SPARQL query string.

endpoint

Character. One of "land-registry" (default), "opendatacommunities", or a full URL to any SPARQL endpoint.

timeout

Integer. Request timeout in seconds. Default 60.

Value

A data frame of bindings. Column names match the SELECT variables in the query.

Details

Both endpoints are free and require no authentication. The Land Registry endpoint covers HPI and Price Paid Data; the Open Data Communities endpoint covers 300+ housing-market datasets published by MHCLG.

See also

Other helpers: ukh_regions()

Examples

# \donttest{
op <- options(ukhousing.cache_dir = tempdir())

# All HPI observations for Westminster in January 2020
q <- '
PREFIX ukhpi: <http://landregistry.data.gov.uk/def/ukhpi/>
SELECT ?hpi ?avgPrice WHERE {
  <http://landregistry.data.gov.uk/data/ukhpi/region/city-of-westminster/month/2020-01>
    ukhpi:housePriceIndex ?hpi ;
    ukhpi:averagePrice    ?avgPrice .
}'
ukh_sparql(q)
#>     hpi avgPrice
#> 1 87.50  1072220

options(op)
# }