Learn R Programming

FIESTA (version 3.7.1)

DBgetSQLite: Database - Queries a SQLite database table.

Description

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

Usage

DBgetSQLite(states = NULL, outfolder = NULL)

Value

Returns nothing.

Arguments

states

String. Vector of one or more state names.

outfolder

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

Author

Tracey S. Frescino

Examples

Run this code
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()) 
}

Run the code above in your browser using DataLab