prep_sql_query

Allows potential users of Scottish Health and Social Care Open Data
(<https://www.opendata.nhs.scot/>) to easily explore and extract the
available data.

James Hardy

odns

Access Scottish Health and Social Care Open Data

prep_sql_query function

<dl><dt>resource</dt>
<dd>a character string specifying resource id of the data set
to be returned.</dd>
<dt>fields</dt>
<dd>a character vector specifying the names of fields to be
included in the returned data.</dd>
<dt>limit</dt>
<dd>A numeric value specifying the maximum number of rows to be
returned.</dd>
<dt>offset</dt>
<dd>A numeric value specifying the number of rows to skip.</dd>
<dt>where</dt>
<dd>A character string containing the 'WHERE' element of a simple
SQL SELECT style query. Field names must be double quoted (<code>"}), non
numeric values must be single quoted (\code{"</code>), and both single and double
quotes must be delimited. Example; <code>where = "\"AgeGroup\" = 
 \'45-49 years\'"</code>.</dd></dl>

Arguments

Prepare an API query with SQL. — prep_sql_query

<dl>

<dt>resource</dt>
<dd>a character string specifying resource id of the data set
to be returned.</dd>


<dt>fields</dt>
<dd>a character vector specifying the names of fields to be
included in the returned data.</dd>


<dt>limit</dt>
<dd>A numeric value specifying the maximum number of rows to be
returned.</dd>


<dt>offset</dt>
<dd>A numeric value specifying the number of rows to skip.</dd>


<dt>where</dt>
<dd>A character string containing the 'WHERE' element of a simple
SQL SELECT style query. Field names must be double quoted (<code>"}), non
numeric values must be single quoted (\code{"</code>), and both single and double
quotes must be delimited. Example; <code>where = "\"AgeGroup\" = 
 \'45-49 years\'"</code>.</dd>

</dl>

prep_sql_query: Prepare an API query with SQL.

Description

Usage

Value

Arguments