Accessing Statistics Canada Data Table and Vectors
Retrieve series info for given table id and coordinates
Add provincial abbreviations as factor
Translate deprecated CANSIM table number into new NDM-format table cat...
Repartitions a cached cansim table to a new partitioning scheme
Use metadata to extract categories for column of specific level
Collect data from a parquet, feather or sqlite query and normalize can...
create database index
convert csv to arrow
convert csv to sqlite adapted from https://rdrr.io/github/coolbutusele...
Disconnect from a cansim database connection
Fold in metadata and for selected columns
Retrieve a list of modified tables since a given date
Get NDM code sets
Retrieve Statistics Canada data table categories for a specific column
Retrieve Statistics Canada data table column list
Retrieve a Statistics Canada data table using NDM catalogue number as ...
Retrieve table metadata from Statistics Canada API
Retrieve data for specified Statistics Canada data product for last N ...
Major economic indicator release schedule
Retrieve series info for given table id and coordinates
Retrieve a Statistics Canada data table using NDM catalogue number as ...
Retrieve Statistics Canada data table information
Get the latest release data for a StatCan table, if available
Retrieve Statistics Canada data table notes and column categories
Retrieve Statistics Canada data table overview text
Retrieve Statistics Canada data table short notes
Retrieve Statistics Canada data table subject detail
Retrieve Statistics Canada data table survey detail
Retrieve table template from Statistics Canada API
Retrieve a Statistics Canada data table URL given a table number
Retrieve data for specified Statistics Canada data vector(s) for last ...
Retrieve metadata for specified Statistics Canada data vectors
Retrieve data for a Statistics Canada data vector released within a gi...
Retrieve a Statistics Canada data table using NDM catalogue number
Get column names de-duplicated and in the correct order
List cached cansim arrow and SQlite databases
Get overview list for all Statistics Canada data cubes
List cached cansim SQLite database
Get overview list for all Statistics Canada data tables (deprecated)
Normalize retrieved data table values to appropriate scales
Parse metadata
Remove cached cansim SQLite and parquet database
Remove cached cansim SQLite database
Search through Statistics Canada data cubes
Search through Statistics Canada data tables (deprecated)
View CANSIM table or vector information in browser
Searches for, accesses, and retrieves Statistics Canada data tables, as well as individual vectors, as tidy data frames. This package enriches the tables with metadata, deals with encoding issues, allows for bilingual English or French language data retrieval, and bundles convenience functions to make it easier to work with retrieved table data. For more efficient data access the package allows for caching data in a local database and database level filtering, data manipulation and summarizing.
Useful links