Skip to contents

All functions

add_columns_if_missing()
Add Missing Columns
clean_value()
Clean Data Values
connect_hansard_database()
Connect to Hansard Database
create_database_triggers()
Create Database Triggers
create_fts_table_if_missing()
Create FTS Table If Missing
create_hansard_database()
Create Hansard Database
create_optimization_indexes()
Create Optimization Indexes
create_standard_schema()
Create Standard Schema
get_content_statistics()
Get Content Statistics
get_database_stats()
Get Database Statistics
get_hansard_tables()
Get Database Table References
get_top_speakers()
Get Top Speakers
hansard_sample_data()
Get Path to Sample Hansard Data
hansard_sample_info()
List Available Sample Data
import_hansard_batch()
Import Multiple Files
import_hansard_file()
Import Single CSV File to Database
import_hansard_year()
Import Year Directory
import_session_data()
Import Session Data
load_hansard_csv()
Load and Clean CSV File
optimize_hansard_database()
Optimize Existing Database
parse_session_date()
Parse Session Date from Filename
parse_time()
Parse Time Strings
process_debates()
Process Debates Data
process_members()
Process Members Data
process_speeches()
Process Speeches Data
search_speech_content()
Search Speech Content
search_speeches_advanced()
Search Speeches by Member and Content
validate_csv_batch()
Validate Multiple Files
validate_csv_structure()
Validate CSV File Structure