get_statements_table {sejmRP} | R Documentation |
Importing statements table from a database
Description
Function get_statements_table
imports statements table from a database.
Usage
get_statements_table(dbname = 'sejmrp', user = 'reader',
password = 'qux94874', host = 'services.mini.pw.edu.pl',
sorted_by_id = TRUE, windows = .Platform$OS.type == 'windows')
Arguments
dbname |
name of database; default: 'sejmrp' |
user |
name of user; default: 'reader' |
password |
password of database; default: 'qux94874' |
host |
name of host; default: 'services.mini.pw.edu.pl' |
sorted_by_id |
information if table should be sorted by id; default: TRUE |
windows |
information of used operation system; default: .Platform$OS.type == 'windows' |
Details
Function get_statements_table
imports statements table from a database.
The result of this function is a data frame with statements' data. Because of
encoding issue on Windows operation system, you need to select if you use Windows.
Value
data frame
Note
Default parameters use privilages of 'reader'. It can only SELECT data from database.
All information is stored in PostgreSQL database.
Author(s)
Piotr Smuda
Examples
## Not run:
statements <- get_statements_table()
dim(statements)
# [1] 43432 6
names(statements)
# [1] 'id_statement' 'nr_term_of_office' 'surname_name'
# [4] 'date_statement' 'titles_order_points' 'statement'
## End(Not run)