{ "_id": "6a1ef561b401979e73416c38", "Package": "cansim", "Type": "Package", "Title": "Accessing Statistics Canada Data Table and Vectors", "Version": "0.4.4", "Authors@R": "c(\nperson(\"Jens\", \"von Bergmann\", email = \"jens@mountainmath.ca\", role = c(\"aut\",\"cre\")),\nperson(\"Dmitry\", \"Shkolnik\", email = \"shkolnikd@gmail.com\", role = c(\"aut\")))", "Maintainer": "Jens von Bergmann ", "Description": "Searches for, accesses, and retrieves Statistics Canada\ndata tables, as well as individual vectors, as tidy data\nframes. This package enriches the tables with metadata, deals\nwith encoding issues, allows for bilingual English or French\nlanguage data retrieval, and bundles convenience functions to\nmake it easier to work with retrieved table data. For more\nefficient data access the package allows for caching data in a\nlocal database and database level filtering, data manipulation\nand summarizing.", "License": "MIT + file LICENSE", "Encoding": "UTF-8", "ByteCompile": "yes", "NeedsCompilation": "no", "LazyData": "true", "RoxygenNote": "7.3.2", "URL": "https://github.com/mountainMath/cansim,\nhttps://mountainmath.github.io/cansim/,\nhttps://www.statcan.gc.ca/", "BugReports": "https://github.com/mountainMath/cansim/issues", "VignetteBuilder": "knitr", "Language": "en-CA", "Config/testthat/edition": "3", "Config/pak/sysreqs": "cmake libicu-dev libssl-dev libx11-dev", "Repository": "https://mountainmath.r-universe.dev", "Date/Publication": "2025-11-20 04:23:09 UTC", "RemoteUrl": "https://github.com/mountainmath/cansim", "RemoteRef": "HEAD", "RemoteSha": "b7cf6b542eb28f79984c2222e0cd93f22c45a3ee", "Packaged": { "Date": "2026-05-19 06:56:19 UTC", "User": "root" }, "Author": "Jens von Bergmann [aut, cre],\nDmitry Shkolnik [aut]", "MD5sum": "c5e67572bd145d214933db3410d1d566", "_user": "mountainmath", "_type": "src", "_file": "cansim_0.4.4.tar.gz", "_fileid": "147278d4a79d32d9f5a854892565d8c588450b43a41aa063792ac5b09a1468c3", "_filesize": 354700, "_sha256": "147278d4a79d32d9f5a854892565d8c588450b43a41aa063792ac5b09a1468c3", "_created": "2026-05-19T06:56:19.000Z", "_published": "2026-06-02T15:23:13.690Z", "_distro": "noble", "_jobs": [ { "job": 79106891705, "time": 151, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7076837683" }, { "job": 79106891779, "time": 153, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7076838142" }, { "job": 79106892150, "time": 116, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7076828473" }, { "job": 79106891790, "time": 82, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7076819606" }, { "job": 79106890842, "time": 203, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7076796715" }, { "job": 79106890620, "time": 125, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7362108157" }, { "job": 79106891755, "time": 88, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7076821059" }, { "job": 79106892229, "time": 111, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7076827199" }, { "job": 79106891533, "time": 105, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7076825500" } ], "_buildurl": "https://github.com/r-universe/mountainmath/actions/runs/26081333080", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/mountainmath/cansim", "_commit": { "id": "b7cf6b542eb28f79984c2222e0cd93f22c45a3ee", "author": "Jens von Bergmann ", "committer": "Jens von Bergmann ", "message": "change name of workflow\n", "time": 1763612589 }, "_maintainer": { "name": "Jens von Bergmann", "email": "jens@mountainmath.ca", "login": "mountainmath", "description": "", "uuid": 1395960 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1", "role": "Depends" }, { "package": "digest", "version": ">= 0.6", "role": "Imports" }, { "package": "dplyr", "version": ">= 1.1", "role": "Imports" }, { "package": "httr", "version": ">= 1.0.0", "role": "Imports" }, { "package": "tidyr", "version": ">= 1.3", "role": "Imports" }, { "package": "readr", "version": ">= 2.1", "role": "Imports" }, { "package": "rlang", "version": ">= 1.1", "role": "Imports" }, { "package": "stringr", "version": ">= 1.5", "role": "Imports" }, { "package": "purrr", "version": ">= 1.0", "role": "Imports" }, { "package": "tibble", "version": ">= 3.2", "role": "Imports" }, { "package": "arrow", "version": ">= 18.1", "role": "Imports" }, { "package": "DBI", "version": ">= 1.2", "role": "Imports" }, { "package": "RSQLite", "version": ">= 2.3", "role": "Imports" }, { "package": "utils", "version": ">= 4.3", "role": "Imports" }, { "package": "dbplyr", "version": ">= 2.5", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "ggplot2", "role": "Suggests" }, { "package": "scales", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" } ], "_owner": "mountainmath", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-22", "n": 1 }, { "week": "2025-34", "n": 1 }, { "week": "2025-47", "n": 2 } ], "_tags": [ { "name": "v0.4.3", "date": "2025-05-30" }, { "name": "v0.4.4", "date": "2025-08-19" } ], "_stars": 49, "_contributors": [ { "user": "mountainmath", "count": 355, "uuid": 1395960 }, { "user": "dshkol", "count": 58, "uuid": 5847527 }, { "user": "boshek", "count": 4, "uuid": 18472598 }, { "user": "lchski", "count": 1, "uuid": 343884 }, { "user": "stephhazlitt", "count": 1, "uuid": 7143861 } ], "_userbio": { "uuid": 1395960, "type": "user", "name": "Jens von Bergmann" }, "_downloads": { "count": 1091, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/cansim" }, "_devurl": "https://github.com/mountainmath/cansim", "_pkgdown": "https://mountainmath.github.io/cansim/", "_searchresults": 480, "_rbuild": "4.6.0", "_assets": [ "extra/cansim.html", "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/mountainmath/cansim", "_realowner": "mountainmath", "_cranurl": true, "_releases": [ { "version": "0.2.2", "date": "2018-12-18" }, { "version": "0.2.3", "date": "2019-01-07" }, { "version": "0.3.0", "date": "2019-07-18" }, { "version": "0.3.1", "date": "2019-08-19" }, { "version": "0.3.2", "date": "2019-08-26" }, { "version": "0.3.3", "date": "2019-10-16" }, { "version": "0.3.4", "date": "2020-03-05" }, { "version": "0.3.5", "date": "2020-03-13" }, { "version": "0.3.6", "date": "2021-05-08" }, { "version": "0.3.7", "date": "2021-05-10" }, { "version": "0.3.8", "date": "2021-05-27" }, { "version": "0.3.9", "date": "2021-07-29" }, { "version": "0.3.10", "date": "2021-09-27" }, { "version": "0.3.11", "date": "2022-05-10" }, { "version": "0.3.12", "date": "2022-07-12" }, { "version": "0.3.13", "date": "2022-11-07" }, { "version": "0.3.14", "date": "2023-01-20" }, { "version": "0.3.15", "date": "2023-10-11" }, { "version": "0.3.16", "date": "2024-03-12" }, { "version": "0.3.17", "date": "2024-11-06" }, { "version": "0.4", "date": "2025-02-24" }, { "version": "0.4.1", "date": "2025-03-15" }, { "version": "0.4.2", "date": "2025-05-12" }, { "version": "0.4.3", "date": "2025-05-30" }, { "version": "0.4.4", "date": "2025-08-19" } ], "_exports": [ "add_cansim_vectors_to_template", "add_provincial_abbreviations", "cansim_old_to_new", "cansim_repartition_cached_table", "categories_for_level", "collect_and_normalize", "disconnect_cansim_sqlite", "get_cansim", "get_cansim_changed_tables", "get_cansim_code_set", "get_cansim_column_categories", "get_cansim_column_list", "get_cansim_connection", "get_cansim_cube_metadata", "get_cansim_data_for_table_coord_periods", "get_cansim_key_release_schedule", "get_cansim_series_info_cube_coord", "get_cansim_sqlite", "get_cansim_table_info", "get_cansim_table_last_release_date", "get_cansim_table_notes", "get_cansim_table_overview", "get_cansim_table_short_notes", "get_cansim_table_subject", "get_cansim_table_survey", "get_cansim_table_template", "get_cansim_table_url", "get_cansim_vector", "get_cansim_vector_for_latest_periods", "get_cansim_vector_info", "list_cansim_cached_tables", "list_cansim_cubes", "list_cansim_sqlite_cached_tables", "list_cansim_tables", "normalize_cansim_values", "remove_cansim_cached_tables", "remove_cansim_sqlite_cached_table", "search_cansim_cubes", "search_cansim_tables", "set_cansim_cache_path", "show_cansim_cache_path", "view_cansim_webpage" ], "_datasets": [ { "name": "correspondence", "title": "The correspondence file for old to new StatCan table numbers is included in the package", "object": "correspondence", "class": [ "tbl_df", "tbl", "data.frame" ], "fields": [ "CANSIM_ID", "PRODUCT_ID" ], "rows": 4807, "table": true, "tojson": true } ], "_help": [ { "page": "add_cansim_vectors_to_template", "title": "Retrieve series info for given table id and coordinates", "topics": [ "add_cansim_vectors_to_template" ] }, { "page": "add_provincial_abbreviations", "title": "Add provincial abbreviations as factor", "topics": [ "add_provincial_abbreviations" ] }, { "page": "cansim_old_to_new", "title": "Translate deprecated CANSIM table number into new NDM-format table catalogue number", "topics": [ "cansim_old_to_new" ] }, { "page": "cansim_repartition_cached_table", "title": "Repartitions a cached cansim table to a new partitioning scheme", "topics": [ "cansim_repartition_cached_table" ] }, { "page": "categories_for_level", "title": "Use metadata to extract categories for column of specific level", "topics": [ "categories_for_level" ] }, { "page": "collect_and_normalize", "title": "Collect data from a parquet, feather or sqlite query and normalize cansim table output", "topics": [ "collect_and_normalize" ] }, { "page": "disconnect_cansim_sqlite", "title": "Disconnect from a cansim database connection", "topics": [ "disconnect_cansim_sqlite" ] }, { "page": "get_cansim", "title": "Retrieve a Statistics Canada data table using NDM catalogue number", "topics": [ "get_cansim" ] }, { "page": "get_cansim_changed_tables", "title": "Retrieve a list of modified tables since a given date", "topics": [ "get_cansim_changed_tables" ] }, { "page": "get_cansim_code_set", "title": "Get NDM code sets", "topics": [ "get_cansim_code_set" ] }, { "page": "get_cansim_column_categories", "title": "Retrieve Statistics Canada data table categories for a specific column", "topics": [ "get_cansim_column_categories" ] }, { "page": "get_cansim_column_list", "title": "Retrieve Statistics Canada data table column list", "topics": [ "get_cansim_column_list" ] }, { "page": "get_cansim_connection", "title": "Retrieve a Statistics Canada data table using NDM catalogue number as parquet, feather, or sqlite database connection", "topics": [ "get_cansim_connection" ] }, { "page": "get_cansim_cube_metadata", "title": "Retrieve table metadata from Statistics Canada API", "topics": [ "get_cansim_cube_metadata" ] }, { "page": "get_cansim_data_for_table_coord_periods", "title": "Retrieve data for specified Statistics Canada data product for last N periods for specific coordinates", "topics": [ "get_cansim_data_for_table_coord_periods" ] }, { "page": "get_cansim_key_release_schedule", "title": "Major economic indicator release schedule", "topics": [ "get_cansim_key_release_schedule" ] }, { "page": "get_cansim_series_info_cube_coord", "title": "Retrieve series info for given table id and coordinates", "topics": [ "get_cansim_series_info_cube_coord" ] }, { "page": "get_cansim_table_info", "title": "Retrieve Statistics Canada data table information", "topics": [ "get_cansim_table_info" ] }, { "page": "get_cansim_table_last_release_date", "title": "Get the latest release data for a StatCan table, if available", "topics": [ "get_cansim_table_last_release_date" ] }, { "page": "get_cansim_table_notes", "title": "Retrieve Statistics Canada data table notes and column categories", "topics": [ "get_cansim_table_notes" ] }, { "page": "get_cansim_table_overview", "title": "Retrieve Statistics Canada data table overview text", "topics": [ "get_cansim_table_overview" ] }, { "page": "get_cansim_table_short_notes", "title": "Retrieve Statistics Canada data table short notes", "topics": [ "get_cansim_table_short_notes" ] }, { "page": "get_cansim_table_subject", "title": "Retrieve Statistics Canada data table subject detail", "topics": [ "get_cansim_table_subject" ] }, { "page": "get_cansim_table_survey", "title": "Retrieve Statistics Canada data table survey detail", "topics": [ "get_cansim_table_survey" ] }, { "page": "get_cansim_table_template", "title": "Retrieve table template from Statistics Canada API", "topics": [ "get_cansim_table_template" ] }, { "page": "get_cansim_table_url", "title": "Retrieve a Statistics Canada data table URL given a table number", "topics": [ "get_cansim_table_url" ] }, { "page": "get_cansim_vector", "title": "Retrieve data for a Statistics Canada data vector released within a given time frame", "topics": [ "get_cansim_vector" ] }, { "page": "get_cansim_vector_for_latest_periods", "title": "Retrieve data for specified Statistics Canada data vector(s) for last N periods", "topics": [ "get_cansim_vector_for_latest_periods" ] }, { "page": "get_cansim_vector_info", "title": "Retrieve metadata for specified Statistics Canada data vectors", "topics": [ "get_cansim_vector_info" ] }, { "page": "list_cansim_cached_tables", "title": "List cached cansim arrow and SQlite databases", "topics": [ "list_cansim_cached_tables" ] }, { "page": "list_cansim_cubes", "title": "Get overview list for all Statistics Canada data cubes", "topics": [ "list_cansim_cubes" ] }, { "page": "remove_cansim_cached_tables", "title": "Remove cached cansim SQLite and parquet database", "topics": [ "remove_cansim_cached_tables" ] }, { "page": "search_cansim_cubes", "title": "Search through Statistics Canada data cubes", "topics": [ "search_cansim_cubes" ] }, { "page": "set_cansim_cache_path", "title": "Set persistent cansim cache location", "topics": [ "set_cansim_cache_path" ] }, { "page": "show_cansim_cache_path", "title": "View saved cache directory path", "topics": [ "show_cansim_cache_path" ] }, { "page": "view_cansim_webpage", "title": "View CANSIM table or vector information in browser", "topics": [ "view_cansim_webpage" ] } ], "_pkglogo": "https://mountainmath.github.io/cansim/logo.png", "_readme": "https://github.com/mountainmath/cansim/raw/HEAD/README.md", "_rundeps": [ "arrow", "askpass", "assertthat", "bit", "bit64", "blob", "cachem", "cli", "clipr", "cpp11", "crayon", "curl", "DBI", "dbplyr", "digest", "dplyr", "fastmap", "generics", "glue", "hms", "httr", "jsonlite", "lifecycle", "magrittr", "memoise", "mime", "openssl", "pillar", "pkgconfig", "prettyunits", "progress", "purrr", "R6", "readr", "rlang", "RSQLite", "stringi", "stringr", "sys", "tibble", "tidyr", "tidyselect", "tzdb", "utf8", "vctrs", "vroom", "withr" ], "_vignettes": [ { "source": "cansim.Rmd", "filename": "cansim.html", "title": "Getting started with the cansim package", "engine": "knitr::rmarkdown", "headings": [ "About", "Installing cansim", "Usage", "License", "Attribution" ], "created": "2018-09-28 05:34:38", "modified": "2025-08-19 23:41:31", "commits": 16 }, { "source": "partial_table_data_download.Rmd", "filename": "partial_table_data_download.html", "title": "Partial table data download", "engine": "knitr::rmarkdown", "headings": [ "Using vectors instead of coordinates" ], "created": "2025-05-12 18:55:34", "modified": "2025-05-30 19:51:29", "commits": 2 }, { "source": "working_with_large_tables.Rmd", "filename": "working_with_large_tables.html", "title": "Working with large tables", "engine": "knitr::rmarkdown", "headings": [ "Working with cached tables", "parquet", "feather", "sqlite", "Filtering and loading into memory", "traditional", "", "Working with the data", "Partitioning", "Repartitioning", "Keeping track of cached data", "Removing cached data" ], "created": "2021-05-10 06:00:01", "modified": "2025-08-19 23:41:31", "commits": 6 } ], "_score": 8.66453457309575, "_indexed": true, "_nocasepkg": "cansim", "_universes": [ "mountainmath" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.4.4", "date": "2026-05-19T06:58:45.000Z", "distro": "noble", "commit": "b7cf6b542eb28f79984c2222e0cd93f22c45a3ee", "fileid": "7bacd64563da4f421230a22f11a6a2f894dd508b9fc550f6f2f616c09ef55575", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mountainmath/actions/runs/26081333080" }, { "r": "4.6.0", "os": "linux", "version": "0.4.4", "date": "2026-05-19T06:58:47.000Z", "distro": "noble", "commit": "b7cf6b542eb28f79984c2222e0cd93f22c45a3ee", "fileid": "40d17022b11d8af571fba45cc6c3308e00d72aff83d324dca39dce131d62f49f", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mountainmath/actions/runs/26081333080" }, { "r": "4.5.3", "os": "mac", "version": "0.4.4", "date": "2026-05-19T06:58:15.000Z", "commit": "b7cf6b542eb28f79984c2222e0cd93f22c45a3ee", "fileid": "7f5148d34f91f033d47cbd96b43acff16bdbd40d246ffa3421cdf942861303c7", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mountainmath/actions/runs/26081333080" }, { "r": "4.6.0", "os": "mac", "version": "0.4.4", "date": "2026-05-19T06:57:47.000Z", "commit": "b7cf6b542eb28f79984c2222e0cd93f22c45a3ee", "fileid": "24d39e52a72b28048cdc2b9d75993353123e88fbf557f1eb1b1f97baf0fc9e33", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mountainmath/actions/runs/26081333080" }, { "r": "4.7.0", "os": "win", "version": "0.4.4", "date": "2026-05-19T06:57:39.000Z", "commit": "b7cf6b542eb28f79984c2222e0cd93f22c45a3ee", "fileid": "e354a715e652ce8143bd403a5918390fbe1bee99de83241272c1e1de9ba12c96", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mountainmath/actions/runs/26081333080" }, { "r": "4.5.3", "os": "win", "version": "0.4.4", "date": "2026-05-19T06:57:59.000Z", "commit": "b7cf6b542eb28f79984c2222e0cd93f22c45a3ee", "fileid": "7fb017ffe74f0f7c14b073e0c8d3c7934f35665cc186a30d5839669d0b274333", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mountainmath/actions/runs/26081333080" }, { "r": "4.6.0", "os": "win", "version": "0.4.4", "date": "2026-05-19T06:57:54.000Z", "commit": "b7cf6b542eb28f79984c2222e0cd93f22c45a3ee", "fileid": "3c57a5477178d1cf26bcc2c8fb5648861d4c9931e4ba44cb4479d54e18848cc6", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/mountainmath/actions/runs/26081333080" }, { "r": "4.6.0", "os": "wasm", "version": "0.4.4", "date": "2026-06-02T15:22:49.000Z", "commit": "b7cf6b542eb28f79984c2222e0cd93f22c45a3ee", "fileid": "4313a182b73651878af7c9543fc2d44e52132f82c03cf059057e64ce108fbf4c", "status": "success", "buildurl": "https://github.com/r-universe/mountainmath/actions/runs/26081333080" } ] }