get_statements_table: Importing statements table from a database

In sejmRP: An Information About Deputies and Votings in Polish Diet from Seventh to Eighth Term of Office

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)

sejmRP documentation built on May 2, 2019, 5:16 a.m.