Skip to contents

BigQuery mirror of the Chicago crime feed

Source: R/ingest_chicago.R
morie_ingest_chicago_crime_bigquery.Rd

Convenience wrapper around morie_ingest_bigquery_table that pulls bigquery-public-data.chicago_crime.crime - the Google BigQuery public-data mirror of the Socrata feed served by morie_ingest_chicago_crime. Use this path when you want SQL-side filtering or the full historical depth of the dataset without paging through SoQL.

Usage

morie_ingest_chicago_crime_bigquery(
  where = NULL,
  year = NULL,
  limit = NULL,
  select = "*",
  billing_project = NULL,
  page_size = 10000L,
  max_rows = Inf,
  quiet = TRUE
)

Arguments

where

Optional raw SQL WHERE clause (no leading WHERE).

year

Convenience shortcut: when where is NULL and year is set, applies year = <year>.

limit

Optional LIMIT.

select

Projection list (default "*").

billing_project, page_size, max_rows, quiet

Forwarded to morie_ingest_bigquery_table.

Value

A base R data.frame.

Details

Requires the optional bigrquery package and a billing project (billing_project arg or GCP_PROJECT env var); public datasets are billed to the caller's project, not the dataset owner's.

See also

morie_ingest_chicago_crime, morie_ingest_bigquery_table