aggregate_cov_data {VancouvR}

Get aggregates from dataset from Vancouver Open Data Portal

Description

Get aggregates from dataset from Vancouver Open Data Portal

Usage

aggregate_cov_data(
  dataset_id,
  select = "count(*) as count",
  group_by = NULL,
  where = NULL,
  apikey = getOption("VancouverOpenDataApiKey"),
  refresh = FALSE
)

Arguments

dataset_id

Dataset id from the Vancouver Open Data catalogue

select

select string for aggregation, default is 'count(*) as count' It accepts ODSQL syntax.

group_by

grouping variables for the query It accepts ODSQL syntax.

where

Query parameter to filter data (default 'NULL' no filter) It accepts ODSQL syntax.

apikey

Vancouver Open Data API key, default 'getOption("VancouverOpenDataApiKey")'

refresh

refresh cached data, default 'FALSE“

Value

tibble format data table output

Examples

# Count all parking tickets that relate to fire hydrants by ticket status
## Not run: 
aggregate_cov_data("parking-tickets-2017-2019",
                   group_by = "status",
                   where = "infractiontext LIKE 'FIRE'")

## End(Not run)