aggregate_cov_data | R Documentation |
Get aggregates from dataset from Vancouver Open Data Portal
aggregate_cov_data(
dataset_id,
select = "count(*) as count",
group_by = NULL,
where = NULL,
apikey = getOption("VancouverOpenDataApiKey"),
refresh = FALSE
)
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ā |
tibble format data table output
# 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)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.