Extracts and queries data from a SQLite (*.sqlite) database (Note: must use SQL syntax).

DBgetSQLite(states = NULL, outfolder = NULL)

Arguments

states

String. Vector of one or more state names.

outfolder

String. The output folder path. If NULL, outfolder is the working directory.

Value

Returns nothing.

Author

Tracey S. Frescino

Examples

if (FALSE) {
# Extract data from Washington state
DBgetSQLite(states = "WA")

# Extract data from Utah and California, save to an outfolder
DBgetSQLite(states = c("UT", "CA"),
            outfolder = tempdir()) 
}