Retrieving data

Retrieve data cubes, tables, and vectors from Statistics Canada

get_cansim()

Retrieve a Statistics Canada data table using NDM catalogue number

get_cansim_data_for_table_coord_periods()

Retrieve data for specified Statistics Canada data product for last N periods for specific coordinates

get_cansim_vector()

Retrieve data for a Statistics Canada data vector released within a given time frame

get_cansim_vector_for_latest_periods()

Retrieve data for specified Statistics Canada data vector(s) for last N periods

SQLite database

Managing data in local SQLite database

get_cansim_sqlite()

Retrieve a Statistics Canada data table using NDM catalogue number as SQLite database connection

disconnect_cansim_sqlite()

Disconnect from a cansim database connection

list_cansim_sqlite_cached_tables()

List cached cansim SQLite database

remove_cansim_sqlite_cached_table()

Remove cached cansim SQLite database

Locating data

list_cansim_cubes()

Get overview list for all Statistics Canada data cubes

search_cansim_cubes()

Search through Statistics Canada data cubes

get_cansim_changed_tables()

Retrieve a list of modified tables since a given date

get_cansim_table_last_release_date()

Get the latest release data for a StatCan table, if available

get_cansim_key_release_schedule()

Major economic indicator release schedule

Metadata and information

get_cansim_cube_metadata()

Retrieve table metadata from Statistics Canada API

get_cansim_table_info()

Retrieve Statistics Canada data table information

get_cansim_table_last_release_date()

Get the latest release data for a StatCan table, if available

get_cansim_table_notes()

Retrieve Statistics Canada data table notes and column categories

get_cansim_table_overview()

Retrieve Statistics Canada data table overview text

get_cansim_table_short_notes()

Retrieve Statistics Canada data table short notes

get_cansim_table_subject()

Retrieve Statistics Canada data table subject detail

get_cansim_table_survey()

Retrieve Statistics Canada data table survey detail

get_cansim_table_url()

Retrieve a Statistics Canada data table URL given a table number

get_cansim_vector_info()

Retrieve metadata for specified Statistics Canada data vectors

get_cansim_column_categories()

Retrieve Statistics Canada data table categories for a specific column

get_cansim_column_list()

Retrieve Statistics Canada data table column list

view_cansim_webpage()

View CANSIM table or vector information in browser

categories_for_level()

Use metadata to extract categories for column of specific level

Data transformation

normalize_cansim_values()

Normalize retrieved data table values to appropriate scales

collect_and_normalize()

Collect data from connection and normalize cansim table output

Miscellaneous

add_provincial_abbreviations()

Add provincial abbreviations as factor

cansim_old_to_new()

Translate deprecated CANSIM table number into new NDM-format table catalogue number

get_cansim_code_set()

Get NDM code sets