rollup_FCC: Processing FCC data

In kdmulligan/processFCC: processFCC: cleaning Fixed Broadband Data from FCC Form 477

Processing FCC data

Description

Takes connection to SQLite database with FCC file and processes/ rolls up the data based on function inputs.

Usage

rollup_FCC(
  con,
  year,
  month,
  state = NULL,
  geogr = "cb",
  tech_exc = c("60", "70"),
  thresh_down = c(25, 25, 50, 100, 100),
  thresh_up = c(3, 5, 10, 10, 100),
  new_file_name = NULL
)

Arguments

con	A DBIConnection object, as returned by 'dbConnect'.
year	The year of the FCC data to process.
month	The month of the FCC data to process.
state	A vector of the state(s) to include in the final data. The default is NA in order to include all states and territories in the final data set.
geogr	Character representation of Census geography to roll up the final data set to There are 4 options of census geography, listed from smallest to largest: - cb = Census Block - cbg = Census Block Group - ct = Census Tract - county = County
tech_exc	Vector of technology codes to exclude from data when rolling up if you do not wish to exclude any technology codes input NA or c(NA).
thresh_down	Vector of download speeds thresholds. Should be the same length as 'thresh_up' because elements of the vectors will be matched to count the number of internet providers providing internet at the given download/upload speed combination within the specified 'geogr' region. See vingette for further explanation of the parameter.
thresh_up	Vector of upload speed thresholds. Should be the same length as 'thresh_down' because elements of the vectors will be matched to count the number of internet providers providing internet at the given download/upload speed combination within the specified 'geogr' region.
new_file_name	Name of csv file to output to working directory.

Value

processed csv file to working directory

kdmulligan/processFCC documentation built on Oct. 30, 2024, 7:43 p.m.