{ "_id": "6a310bd53efcd9bda43579b5", "Package": "etl", "Type": "Package", "Title": "Extract-Transform-Load Framework for Medium Data", "Version": "0.4.3", "Authors@R": "c(\nperson(\"Benjamin S.\", \"Baumer\", email = \"ben.baumer@gmail.com\",\nrole = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0002-3279-0516\")),\nperson(\"Carson\", \"Sievert\", email = \"cpsievert1@gmail.com\", role = \"ctb\"),\nperson(\"Natalia\", \"Iannucci\", role = \"ctb\")\n)", "Maintainer": "Benjamin S. Baumer ", "Description": "A predictable and pipeable framework for performing ETL\n(extract-transform-load) operations on publicly-accessible\nmedium-sized data set. This package sets up the method\nstructure and implements generic functions. Packages that\ndepend on this package download specific data sets from the\nInternet, clean them up, and import them into a local or remote\nrelational database management system.", "License": "CC0", "URL": "https://github.com/beanumber/etl", "BugReports": "https://github.com/beanumber/etl/issues", "RoxygenNote": "7.3.3", "Roxygen": "list(markdown = TRUE)", "Encoding": "UTF-8", "VignetteBuilder": "knitr, rmarkdown, ggplot2, dplyr, dbplyr", "Config/pak/sysreqs": "cmake git make libgit2-dev libicu-dev libuv1-dev\nlibxml2-dev libssl-dev libx11-dev", "Repository": "https://beanumber.r-universe.dev", "Date/Publication": "2026-02-16 20:11:20 UTC", "RemoteUrl": "https://github.com/beanumber/etl", "RemoteRef": "HEAD", "RemoteSha": "a6f568e81d41a065ae3779394614b7b82ccd9062", "NeedsCompilation": "no", "Packaged": { "Date": "2026-06-16 08:36:42 UTC", "User": "root" }, "Author": "Benjamin S. Baumer [aut, cre] (ORCID:\n),\nCarson Sievert [ctb],\nNatalia Iannucci [ctb]", "MD5sum": "c2bc73ce93a8541ba7f621d9dfec40b1", "_user": "beanumber", "_type": "src", "_file": "etl_0.4.3.tar.gz", "_fileid": "b2f6ac11fb1435c16cb48b9769ac9f8112667176cb19562557e7bcf622b5582d", "_filesize": 191321, "_sha256": "b2f6ac11fb1435c16cb48b9769ac9f8112667176cb19562557e7bcf622b5582d", "_created": "2026-06-16T08:36:42.000Z", "_published": "2026-06-16T08:39:49.587Z", "_distro": "noble", "_jobs": [ { "job": 81615083804, "time": 144, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7661543477" }, { "job": 81615083827, "time": 158, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7661548455" }, { "job": 81615083811, "time": 91, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7661523194" }, { "job": 81615083820, "time": 100, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7661526826" }, { "job": 81614397247, "time": 217, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7661488019" }, { "job": 81615083758, "time": 128, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7661536272" }, { "job": 81615083807, "time": 112, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7661532612" }, { "job": 81615083802, "time": 137, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7661540331" }, { "job": 81615083813, "time": 102, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7661527843" } ], "_buildurl": "https://github.com/r-universe/beanumber/actions/runs/27604884758", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/beanumber/etl", "_commit": { "id": "a6f568e81d41a065ae3779394614b7b82ccd9062", "author": "Ben Baumer ", "committer": "Ben Baumer ", "message": "update cran-comments.md\n", "time": 1771272680 }, "_maintainer": { "name": "Benjamin S. Baumer", "email": "ben.baumer@gmail.com", "login": "beanumber", "orcid": "0000-0002-3279-0516", "description": "Professor of Statistical & Data Sciences, Smith College", "uuid": 2774211 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.2", "role": "Depends" }, { "package": "dplyr", "role": "Depends" }, { "package": "DBI", "role": "Imports" }, { "package": "dbplyr", "role": "Imports" }, { "package": "datasets", "role": "Imports" }, { "package": "downloader", "role": "Imports" }, { "package": "fs", "role": "Imports" }, { "package": "janitor", "role": "Imports" }, { "package": "lubridate", "role": "Imports" }, { "package": "methods", "role": "Imports" }, { "package": "readr", "role": "Imports" }, { "package": "rlang", "role": "Imports" }, { "package": "rvest", "role": "Imports" }, { "package": "tibble", "role": "Imports" }, { "package": "usethis", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "xml2", "role": "Imports" }, { "package": "knitr", "role": "Suggests" }, { "package": "RSQLite", "role": "Suggests" }, { "package": "RPostgres", "role": "Suggests" }, { "package": "RMariaDB", "role": "Suggests" }, { "package": "ggplot2", "role": "Suggests" }, { "package": "testthat", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" } ], "_owner": "beanumber", "_selfowned": true, "_usedby": 1, "_updates": [ { "week": "2025-30", "n": 7 }, { "week": "2026-08", "n": 4 } ], "_tags": [ { "name": "v0.4.2", "date": "2025-07-24" } ], "_stars": 134, "_contributors": [ { "user": "beanumber", "count": 218, "uuid": 2774211 }, { "user": "davisvaughan", "count": 1, "uuid": 19150088 }, { "user": "niannucci", "count": 1, "uuid": 47400676 } ], "_userbio": { "uuid": 2774211, "type": "user", "name": "Ben Baumer", "followers": 254, "description": "Professor of Statistical & Data Sciences, Smith College" }, "_downloads": { "count": 368, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/etl" }, "_devurl": "https://github.com/beanumber/etl", "_searchresults": 44, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/etl.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/beanumber/etl", "_realowner": "beanumber", "_cranurl": true, "_releases": [ { "version": "0.3.1", "date": "2016-06-07" }, { "version": "0.3.3", "date": "2016-07-27" }, { "version": "0.3.3.1", "date": "2016-09-26" }, { "version": "0.3.4", "date": "2016-11-15" }, { "version": "0.3.5", "date": "2016-11-29" }, { "version": "0.3.6", "date": "2017-07-21" }, { "version": "0.3.7", "date": "2017-09-27" }, { "version": "0.3.8", "date": "2019-12-18" }, { "version": "0.3.9", "date": "2020-06-02" }, { "version": "0.4.0", "date": "2021-05-17" }, { "version": "0.4.1", "date": "2023-10-12" }, { "version": "0.4.2", "date": "2025-07-24" }, { "version": "0.4.3", "date": "2026-02-17" } ], "_exports": [ "create_etl_package", "db_type", "dbRunScript", "dbWipe", "etl", "etl_cleanup", "etl_create", "etl_extract", "etl_init", "etl_load", "etl_transform", "etl_update", "extract_date_from_filename", "find_schema", "is.etl", "match_files_by_year_months", "smart_download", "smart_upload", "src_mysql_cnf", "valid_year_month" ], "_help": [ { "page": "create_etl_package", "title": "Create an ETL package skeleton", "topics": [ "create_etl_package" ] }, { "page": "db_type", "title": "Return the database type for an ETL or DBI connection", "topics": [ "db_type", "db_type.DBIConnection", "db_type.src_dbi" ] }, { "page": "dbRunScript", "title": "Execute an SQL script", "topics": [ "dbRunScript" ] }, { "page": "dbWipe", "title": "Wipe out all tables in a database", "topics": [ "dbWipe" ] }, { "page": "etl", "title": "Initialize an 'etl' object", "topics": [ "etl", "etl.default", "is.etl", "print.etl", "summary.etl" ] }, { "page": "etl_create", "title": "ETL functions for working with medium sized data", "topics": [ "etl_cleanup", "etl_cleanup.default", "etl_create", "etl_create.default", "etl_extract", "etl_extract.default", "etl_extract.etl_cities", "etl_extract.etl_mtcars", "etl_load", "etl_load.default", "etl_transform", "etl_transform.default", "etl_transform.etl_cities", "etl_update", "etl_update.default" ] }, { "page": "etl_init", "title": "Initialize a database using a defined schema", "topics": [ "etl_init", "etl_init.default", "find_schema" ] }, { "page": "match_files_by_year_months", "title": "Match year and month vectors to filenames", "topics": [ "extract_date_from_filename", "match_files_by_year_months" ] }, { "page": "smart_download", "title": "Download only those files that don't already exist", "topics": [ "smart_download" ] }, { "page": "smart_upload", "title": "Upload a list of files to the DB", "topics": [ "smart_upload" ] }, { "page": "src_mysql_cnf", "title": "Connect to local MySQL Server using ~/.my.cnf", "topics": [ "src_mysql_cnf" ] }, { "page": "valid_year_month", "title": "Ensure that years and months are within a certain time span", "topics": [ "valid_year_month" ] } ], "_readme": "https://github.com/beanumber/etl/raw/HEAD/README.md", "_rundeps": [ "askpass", "bit", "bit64", "blob", "cli", "clipr", "cpp11", "crayon", "credentials", "curl", "DBI", "dbplyr", "desc", "digest", "downloader", "dplyr", "fs", "generics", "gert", "gitcreds", "glue", "hms", "httr", "httr2", "ini", "janitor", "jsonlite", "lifecycle", "lubridate", "magrittr", "mime", "openssl", "pillar", "pkgconfig", "prettyunits", "progress", "purrr", "R6", "rappdirs", "readr", "rlang", "rprojroot", "rstudioapi", "rvest", "selectr", "snakecase", "stringi", "stringr", "sys", "tibble", "tidyr", "tidyselect", "timechange", "tzdb", "usethis", "utf8", "vctrs", "vroom", "whisker", "withr", "xml2", "yaml", "zip" ], "_vignettes": [ { "source": "extending_etl.Rmd", "filename": "extending_etl.html", "title": "Extending etl", "author": "Ben Baumer", "engine": "knitr::rmarkdown", "headings": [ "The basics", "The details", "Main etl methods", "Other etl methods", "etl_foo object attributes", "References" ], "created": "2017-08-07 15:13:10", "modified": "2025-07-24 16:16:56", "commits": 11 }, { "source": "using_etl.Rmd", "filename": "using_etl.html", "title": "Using etl", "author": "Ben Baumer", "engine": "knitr::rmarkdown", "headings": [ "Using etl", "Connect to a local or remote database", "Extract", "Transform", "Load", "Do it all at once", "Step-by-step", "Do Your Analysis", "Extending etl", "Create your own ETL packages", "Use other ETL packages" ], "created": "2017-08-07 16:08:56", "modified": "2026-02-16 18:54:23", "commits": 6 } ], "_score": 7.84973872089862, "_indexed": true, "_nocasepkg": "etl", "_universes": [ "beanumber" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "0.4.3", "date": "2026-06-16T08:38:58.000Z", "distro": "noble", "commit": "a6f568e81d41a065ae3779394614b7b82ccd9062", "fileid": "d56a8c5f737b6eb23ac34d073261d0c4f1ea2303a2ff394e0f28e2050bf984dd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/beanumber/actions/runs/27604884758" }, { "r": "4.6.0", "os": "linux", "version": "0.4.3", "date": "2026-06-16T08:39:07.000Z", "distro": "noble", "commit": "a6f568e81d41a065ae3779394614b7b82ccd9062", "fileid": "4c423903d94e8b4aab6663875782eed54bb933fdf9d885f92c83a5d9a8945f3c", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/beanumber/actions/runs/27604884758" }, { "r": "4.5.3", "os": "mac", "version": "0.4.3", "date": "2026-06-16T08:38:11.000Z", "commit": "a6f568e81d41a065ae3779394614b7b82ccd9062", "fileid": "d7396c0d3c6f921c3d44b4ab21a5f404a383ebcb791f1a99f1259f1599aa6fec", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/beanumber/actions/runs/27604884758" }, { "r": "4.6.0", "os": "mac", "version": "0.4.3", "date": "2026-06-16T08:38:19.000Z", "commit": "a6f568e81d41a065ae3779394614b7b82ccd9062", "fileid": "582d21cf5e5fc276467edbfe7d2053b043de5ff63595bdf0f45df72baf3d09fc", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/beanumber/actions/runs/27604884758" }, { "r": "4.6.0", "os": "wasm", "version": "0.4.3", "date": "2026-06-16T08:39:03.000Z", "commit": "a6f568e81d41a065ae3779394614b7b82ccd9062", "fileid": "860412b8fae1e3e36ea7b30d8ee2ab5bc9b443b7838a426bd930bf7a42a712b4", "status": "success", "buildurl": "https://github.com/r-universe/beanumber/actions/runs/27604884758" }, { "r": "4.7.0", "os": "win", "version": "0.4.3", "date": "2026-06-16T08:38:04.000Z", "commit": "a6f568e81d41a065ae3779394614b7b82ccd9062", "fileid": "7e67d6d53f2a5aa6737b7981add4afafa92d9f994c24ce34ec37c9965499ef95", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/beanumber/actions/runs/27604884758" }, { "r": "4.5.3", "os": "win", "version": "0.4.3", "date": "2026-06-16T08:38:01.000Z", "commit": "a6f568e81d41a065ae3779394614b7b82ccd9062", "fileid": "e0d7c19a48c2b760bc9bdfca656c879eedfd7eb6a55a4f8c69ca5e4cd4f370fd", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/beanumber/actions/runs/27604884758" }, { "r": "4.6.0", "os": "win", "version": "0.4.3", "date": "2026-06-16T08:37:51.000Z", "commit": "a6f568e81d41a065ae3779394614b7b82ccd9062", "fileid": "a5cc3f26a6dc0e182a4e904546c501375ac199ab8a4f83b393a38b0470ec7dd8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/beanumber/actions/runs/27604884758" } ] }