load_sqlite: Load sqlite data

In southwick-associates/sadash: Prepare Agency Dashboard Data for state-level dashboards

Description

Load sqlite data

Usage

load_sqlite(db, query)

load_cust(db)

load_cust_standard(db)

load_sale(db, yrs)

load_sale_standard(db)

load_counties(
  db = "E:/SA/Data-production/Data-Dashboards/_Shared/census.sqlite3",
  state
)

load_pop(db, state)

load_lic_ids(db, group)

load_history(db, group, yrs)

Arguments

db	file path to sqlite database
query	DBI statement for sqlite connection
yrs	years to be included from sqlite table
state	2-character abbreviation of selected state
group	name of selected permission

Functions

• load_cust: Load customer data

• load_cust_standard: Load standard customer data

• load_sale: Load sales for selected years

• load_sale_standard: Load standard sale data

• load_counties: Load county fips-names for attaching to cust & pop_county

• load_pop: Load population for selected state (by county-age-sex)

• load_lic_ids: Load license IDs for selected permission

• load_history: Load license history for permission & join customers

southwick-associates/sadash documentation built on Jan. 6, 2022, 5:17 p.m.