{ "_id": "6a17f483acfb0bcc41da82e1", "Package": "ECOTOXr", "Type": "Package", "Title": "Download and Extract Data from US EPA's ECOTOX Database", "Version": "1.2.4", "Authors@R": "c(person(\"Pepijn\", \"de Vries\", role = c(\"aut\", \"cre\", \"dtc\"),\nemail = \"pepijn.devries@outlook.com\",\ncomment = c(ORCID = \"0000-0002-7961-6646\")))", "Author": "Pepijn de Vries [aut, cre, dtc] (0000-0002-7961-6646)", "Maintainer": "Pepijn de Vries ", "Description": "The US EPA ECOTOX database is a freely available database\nwith a treasure of aquatic and terrestrial ecotoxicological\ndata. As the online search interface doesn't come with an API,\nthis package provides the means to easily access and search the\ndatabase in R. To this end, all raw tables are downloaded from\nthe EPA website and stored in a local SQLite database\n.", "URL": "https://github.com/pepijn-devries/ECOTOXr,\nhttps://pepijn-devries.github.io/ECOTOXr/,\nhttps://doi.org/10.1016/j.chemosphere.2024.143078", "BugReports": "https://github.com/pepijn-devries/ECOTOXr/issues", "License": "GPL (>= 3)", "Encoding": "UTF-8", "RoxygenNote": "7.3.2", "Config/testthat/edition": "3", "Roxygen": "list(markdown = TRUE)", "VignetteBuilder": "knitr", "Collate": "'ECOTOXr-package.r' 'cas_handlers.r' 'database_access.r'\n'helpers.r' 'imports.r' 'init.r' 'online.r' 'process_date.r'\n'process_unit.r' 'process_numeric.r' 'wrappers.r'", "Config/pak/sysreqs": "libicu-dev libxml2-dev libssl-dev libudunits2-dev\nlibx11-dev", "Repository": "https://pepijn-devries.r-universe.dev", "Date/Publication": "2025-09-24 10:53:09 UTC", "RemoteUrl": "https://github.com/pepijn-devries/ECOTOXr", "RemoteRef": "main", "RemoteSha": "3145f3ede5692669634c0a566886f59759f2d27a", "NeedsCompilation": "no", "Packaged": { "Date": "2026-05-28 07:50:14 UTC", "User": "root" }, "MD5sum": "769e0c521cecfb03ad2b03d71f28b66f", "_user": "pepijn-devries", "_type": "src", "_file": "ECOTOXr_1.2.4.tar.gz", "_fileid": "abff2b92412240c36b5a223b2326623037c18278656730b395c04dd60685a70b", "_filesize": 622845, "_sha256": "abff2b92412240c36b5a223b2326623037c18278656730b395c04dd60685a70b", "_created": "2026-05-28T07:50:14.000Z", "_published": "2026-05-28T07:53:39.121Z", "_distro": "noble", "_jobs": [ { "job": 78247080674, "time": 172, "config": "linux-devel-x86_64", "r": "4.7.0", "check": "OK", "artifact": "7260542229" }, { "job": 78247080671, "time": 163, "config": "linux-release-x86_64", "r": "4.6.0", "check": "OK", "artifact": "7260539693" }, { "job": 78247080666, "time": 139, "config": "macos-oldrel-arm64", "r": "4.5.3", "check": "OK", "artifact": "7260531938" }, { "job": 78247080701, "time": 113, "config": "macos-release-arm64", "r": "4.6.0", "check": "OK", "artifact": "7260524129" }, { "job": 78246554648, "time": 209, "config": "source", "r": "4.6.0", "check": "OK", "artifact": "7260487736" }, { "job": 78247080687, "time": 121, "config": "wasm-release", "r": "4.6.0", "check": "OK", "artifact": "7260526261" }, { "job": 78247080681, "time": 135, "config": "windows-devel", "r": "4.7.0", "check": "OK", "artifact": "7260530842" }, { "job": 78247080677, "time": 108, "config": "windows-oldrel", "r": "4.5.3", "check": "OK", "artifact": "7260522346" }, { "job": 78247080672, "time": 110, "config": "windows-release", "r": "4.6.0", "check": "OK", "artifact": "7260522935" } ], "_buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/26561838100", "_status": "success", "_host": "GitHub-Actions", "_upstream": "https://github.com/pepijn-devries/ECOTOXr", "_commit": { "id": "3145f3ede5692669634c0a566886f59759f2d27a", "author": "pepijn-devries ", "committer": "GitHub ", "message": "Merge pull request #77 from pepijn-devries/work-in-progress\n\nfixed url", "time": 1758711189 }, "_maintainer": { "name": "Pepijn de Vries", "email": "pepijn.devries@outlook.com", "login": "pepijn-devries", "linkedin": "in/pepijn-de-vries-2509b664", "orcid": "0000-0002-7961-6646", "description": "", "uuid": 13707449 }, "_registered": true, "_dependencies": [ { "package": "R", "version": ">= 4.1.0", "role": "Depends" }, { "package": "RSQLite", "version": ">= 2.3.4", "role": "Depends" }, { "package": "crayon", "version": ">= 1.5.2", "role": "Imports" }, { "package": "dbplyr", "version": ">= 2.4.0", "role": "Imports" }, { "package": "dplyr", "version": ">= 1.1.4", "role": "Imports" }, { "package": "httr2", "version": ">= 1.0.0", "role": "Imports" }, { "package": "jsonlite", "version": ">= 1.8.8", "role": "Imports" }, { "package": "lifecycle", "version": ">= 1.0.4", "role": "Imports" }, { "package": "purrr", "version": ">= 1.0.2", "role": "Imports" }, { "package": "rappdirs", "version": ">= 0.3.3", "role": "Imports" }, { "package": "readr", "version": ">= 2.1.4", "role": "Imports" }, { "package": "readxl", "version": ">= 1.4.3", "role": "Imports" }, { "package": "rlang", "version": ">= 1.1.2", "role": "Imports" }, { "package": "rvest", "version": ">= 1.0.3", "role": "Imports" }, { "package": "stringr", "version": ">= 1.5.1", "role": "Imports" }, { "package": "tibble", "version": ">= 3.2.1", "role": "Imports" }, { "package": "tidyr", "version": ">= 1.3.0", "role": "Imports" }, { "package": "tidyselect", "version": ">= 1.2.0", "role": "Imports" }, { "package": "units", "version": ">= 0.8.5", "role": "Imports" }, { "package": "utils", "role": "Imports" }, { "package": "DBI", "role": "Suggests" }, { "package": "htmltools", "role": "Suggests" }, { "package": "kableExtra", "role": "Suggests" }, { "package": "knitr", "role": "Suggests" }, { "package": "rmarkdown", "role": "Suggests" }, { "package": "standartox", "role": "Suggests" }, { "package": "testthat", "version": ">= 3.0.0", "role": "Suggests" }, { "package": "webchem", "role": "Suggests" } ], "_owner": "pepijn-devries", "_selfowned": true, "_usedby": 0, "_updates": [ { "week": "2025-34", "n": 1 }, { "week": "2025-36", "n": 1 }, { "week": "2025-39", "n": 3 } ], "_tags": [], "_topics": [ "data", "database" ], "_stars": 15, "_contributors": [ { "user": "pepijn-devries", "count": 128, "uuid": 13707449 }, { "user": "hadley", "count": 1, "uuid": 4196 } ], "_userbio": { "uuid": 13707449, "type": "user", "name": "Pepijn de Vries" }, "_downloads": { "count": 344, "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/ECOTOXr" }, "_devurl": "https://github.com/pepijn-devries/ecotoxr", "_pkgdown": "https://pepijn-devries.github.io/ECOTOXr/", "_searchresults": 12, "_rbuild": "4.6.0", "_assets": [ "extra/citation.cff", "extra/citation.html", "extra/citation.json", "extra/citation.txt", "extra/contents.json", "extra/ECOTOXr.html", "extra/NEWS.html", "extra/NEWS.txt", "extra/readme.html", "extra/readme.md", "manual.pdf" ], "_homeurl": "https://github.com/pepijn-devries/ecotoxr", "_realowner": "pepijn-devries", "_cranurl": true, "_releases": [ { "version": "0.1.1", "date": "2021-10-05" }, { "version": "0.2.0", "date": "2022-11-17" }, { "version": "1.0.1", "date": "2023-01-08" }, { "version": "1.0.2", "date": "2023-06-18" }, { "version": "1.0.3", "date": "2023-08-21" }, { "version": "1.0.5", "date": "2023-10-09" }, { "version": "1.0.9", "date": "2024-01-08" }, { "version": "1.1.1", "date": "2024-09-20" }, { "version": "1.2.0", "date": "2025-03-22" }, { "version": "1.2.1", "date": "2025-04-08" }, { "version": "1.2.2", "date": "2025-08-19" }, { "version": "1.2.4", "date": "2025-09-24" } ], "_exports": [ "as_date_ecotox", "as_numeric_ecotox", "as_unit_ecotox", "as.cas", "build_ecotox_sqlite", "cas", "check_ecotox_availability", "check_ecotox_build", "check_ecotox_version", "cite_ecotox", "dbConnectEcotox", "dbDisconnectEcotox", "download_ecotox_data", "get_ecotox_info", "get_ecotox_path", "get_ecotox_sqlite_file", "get_ecotox_url", "is.cas", "list_ecotox_fields", "list_ecotox_web_fields", "mixed_to_single_unit", "process_ecotox_dates", "process_ecotox_numerics", "process_ecotox_units", "search_ecotox", "search_ecotox_lazy", "search_query_ecotox", "show.cas", "websearch_comptox", "websearch_ecotox" ], "_help": [ { "page": "as_date_ecotox", "title": "Values represented by ECOTOX 'character' to dates", "concept": [ "ecotox-sanitisers" ], "topics": [ "as_date_ecotox" ] }, { "page": "as_numeric_ecotox", "title": "Values represented by ECOTOX 'character' to 'numeric'", "concept": [ "ecotox-sanitisers" ], "topics": [ "as_numeric_ecotox" ] }, { "page": "as_unit_ecotox", "title": "Text from the ECOTOX database to 'mixed_units'", "concept": [ "ecotox-sanitisers" ], "topics": [ "as_unit_ecotox" ] }, { "page": "build_ecotox_sqlite", "title": "Build an SQLite database from zip archived tables downloaded from EPA website", "concept": [ "database-build-functions" ], "topics": [ "build_ecotox_sqlite" ] }, { "page": "cas", "title": "Functions for handling chemical abstract service (CAS) registry numbers", "concept": [ "cas-handlers" ], "topics": [ "as.cas", "as.character.cas", "as.data.frame.cas", "as.double.cas", "as.integer.cas", "as.list.cas", "c.cas", "cas", "format.cas", "is.cas", "print.cas", "show.cas", "[.cas", "[<-.cas", "[[.cas", "[[<-.cas" ] }, { "page": "check_ecotox_availability", "title": "Check whether a ECOTOX database exists locally", "concept": [ "database-access-functions" ], "topics": [ "check_ecotox_availability" ] }, { "page": "check_ecotox_build", "title": "Check the locally build database for validity", "concept": [ "database-access-functions", "database-build-functions" ], "topics": [ "check_ecotox_build" ] }, { "page": "check_ecotox_version", "title": "Check if the locally build database is up to date", "concept": [ "database-access-functions", "database-build-functions" ], "topics": [ "check_ecotox_version" ] }, { "page": "cite_ecotox", "title": "Cite the downloaded copy of the ECOTOX database", "concept": [ "database-access-functions" ], "topics": [ "cite_ecotox" ] }, { "page": "dbConnectEcotox", "title": "Open or close a connection to the local ECOTOX database", "concept": [ "database-access-functions" ], "topics": [ "dbConnectEcotox", "dbDisconnectEcotox" ] }, { "page": "download_ecotox_data", "title": "Download and extract ECOTOX database files and compose database", "concept": [ "database-build-functions", "online-functions" ], "topics": [ "download_ecotox_data" ] }, { "page": "get_ecotox_info", "title": "Get information on the local ECOTOX database when available", "concept": [ "database-access-functions" ], "topics": [ "get_ecotox_info" ] }, { "page": "get_path", "title": "The local path to the ECOTOX database (directory or sqlite file)", "concept": [ "database-access-functions" ], "topics": [ "get_ecotox_path", "get_ecotox_sqlite_file" ] }, { "page": "get_ecotox_url", "title": "Get ECOTOX download URL from EPA website", "concept": [ "database-build-functions", "online-functions" ], "topics": [ "get_ecotox_url" ] }, { "page": "list_ecotox_fields", "title": "List the field names that are available from the ECOTOX database", "concept": [ "database-access-functions" ], "topics": [ "list_ecotox_fields" ] }, { "page": "mixed_to_single_unit", "title": "Convert mixed units to a specific unit", "concept": [ "ecotox-sanitisers" ], "topics": [ "mixed_to_single_unit" ] }, { "page": "process_ecotox_dates", "title": "Process ECOTOX search results by converting 'character' to dates where relevant", "concept": [ "ecotox-sanitisers" ], "topics": [ "process_ecotox_dates" ] }, { "page": "process_ecotox_numerics", "title": "Process ECOTOX search results by converting 'character' to 'numeric' where relevant", "concept": [ "ecotox-sanitisers" ], "topics": [ "process_ecotox_numerics" ] }, { "page": "process_ecotox_units", "title": "Process ECOTOX search results by converting 'character' to units where relevant", "concept": [ "ecotox-sanitisers" ], "topics": [ "process_ecotox_units" ] }, { "page": "search_ecotox", "title": "Search and retrieve toxicity records from the database", "concept": [ "search-functions" ], "topics": [ "search_ecotox", "search_ecotox_lazy", "search_query_ecotox" ] }, { "page": "websearch_comptox", "title": "Search and retrieve substance information from ", "topics": [ "websearch_comptox" ] }, { "page": "websearch", "title": "Search and retrieve toxicity records from the online database", "concept": [ "online-functions", "search-functions" ], "topics": [ "list_ecotox_web_fields", "websearch_ecotox" ] } ], "_pkglogo": "https://github.com/pepijn-devries/ECOTOXr/raw/main/man/figures/logo.svg", "_readme": "https://github.com/pepijn-devries/ECOTOXr/raw/main/README.md", "_rundeps": [ "askpass", "bit", "bit64", "blob", "cachem", "cellranger", "cli", "clipr", "cpp11", "crayon", "curl", "DBI", "dbplyr", "dplyr", "fastmap", "generics", "glue", "hms", "httr", "httr2", "jsonlite", "lifecycle", "magrittr", "memoise", "mime", "openssl", "pillar", "pkgconfig", "prettyunits", "progress", "purrr", "R6", "rappdirs", "Rcpp", "readr", "readxl", "rematch", "rlang", "RSQLite", "rvest", "selectr", "stringi", "stringr", "sys", "tibble", "tidyr", "tidyselect", "tzdb", "units", "utf8", "vctrs", "vroom", "withr", "xml2" ], "_vignettes": [ { "source": "ecotox-schema.Rmd", "filename": "ecotox-schema.html", "title": "ECOTOX database schema", "engine": "knitr::rmarkdown", "headings": [ "The database's relational structure", "Setting up queries: some examples", "All test results for tests carried out with Insecta", "A random substance and random species", "Dose information", "Automatically generating queries", "Overview of tables and fields" ], "created": "2025-02-16 22:44:25", "modified": "2025-02-19 21:40:06", "commits": 3 }, { "source": "reproducibility.Rmd", "filename": "reproducibility.html", "title": "Reproducibility", "engine": "knitr::rmarkdown", "headings": [ "Rules of thumb" ], "created": "2025-02-19 21:40:06", "modified": "2025-02-19 21:40:06", "commits": 1 }, { "source": "sanitising-ecotox.Rmd", "filename": "sanitising-ecotox.html", "title": "Sanitising ECOTOX", "engine": "knitr::rmarkdown", "headings": [ "Sanitising units", "Consequences of unit sanitation", "Sanitising numerics", "Consequences of numeric sanitation", "Combining numerics with units", "Sanitising dates" ], "created": "2025-03-11 22:10:16", "modified": "2025-09-24 10:53:09", "commits": 4 }, { "source": "searching-ecotox.Rmd", "filename": "searching-ecotox.html", "title": "Searching ECOTOX", "engine": "knitr::rmarkdown", "headings": [ "Searching the local database", "Three ways of querying the local database", "The curious case of chemical CAS numbers", "Searching the online database" ], "created": "2025-02-12 22:57:12", "modified": "2025-08-18 14:18:27", "commits": 6 } ], "_score": 6.033423755486949, "_indexed": true, "_nocasepkg": "ecotoxr", "_universes": [ "pepijn-devries" ], "_binaries": [ { "r": "4.7.0", "os": "linux", "version": "1.2.4", "date": "2026-05-28T07:52:39.000Z", "distro": "noble", "commit": "3145f3ede5692669634c0a566886f59759f2d27a", "fileid": "775867c48b1a8fb454346c38411981bfb08f1c79f9fc57b6c62ef061de30f0c0", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/26561838100" }, { "r": "4.6.0", "os": "linux", "version": "1.2.4", "date": "2026-05-28T07:52:36.000Z", "distro": "noble", "commit": "3145f3ede5692669634c0a566886f59759f2d27a", "fileid": "6b41ddd557848f6789b1e6305074bf0b106d43600b9144d966016ab4039c5147", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/26561838100" }, { "r": "4.5.3", "os": "mac", "version": "1.2.4", "date": "2026-05-28T07:52:16.000Z", "commit": "3145f3ede5692669634c0a566886f59759f2d27a", "fileid": "8ea1a5ae13677ed90547e4f1b70fecb0a5fc02180a880413a4771ec511de2e35", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/26561838100" }, { "r": "4.6.0", "os": "mac", "version": "1.2.4", "date": "2026-05-28T07:51:56.000Z", "commit": "3145f3ede5692669634c0a566886f59759f2d27a", "fileid": "3ef4984d8abcbe0c02a7d37554707770fabf3d798a957e0302e8b72f04fb1726", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/26561838100" }, { "r": "4.6.0", "os": "wasm", "version": "1.2.4", "date": "2026-05-28T07:52:33.000Z", "commit": "3145f3ede5692669634c0a566886f59759f2d27a", "fileid": "c7a7575e648f7ab45b41ed549238e94093b8ee76fc1c19c66648ee64acd7959b", "status": "success", "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/26561838100" }, { "r": "4.7.0", "os": "win", "version": "1.2.4", "date": "2026-05-28T07:51:55.000Z", "commit": "3145f3ede5692669634c0a566886f59759f2d27a", "fileid": "7aab1ad116bfc02bb3fbbf5934c1768365f60df32148fb45aa9dfc83582caea8", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/26561838100" }, { "r": "4.5.3", "os": "win", "version": "1.2.4", "date": "2026-05-28T07:51:31.000Z", "commit": "3145f3ede5692669634c0a566886f59759f2d27a", "fileid": "c31ce29c2315b86709b824d7228533958b4562751746e7e592f57e75dc7d8f53", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/26561838100" }, { "r": "4.6.0", "os": "win", "version": "1.2.4", "date": "2026-05-28T07:51:32.000Z", "commit": "3145f3ede5692669634c0a566886f59759f2d27a", "fileid": "8c401db891acdf14bc691099a5a8cbf2eb91f19b01d251e2457e47c210c0a192", "status": "success", "check": "OK", "buildurl": "https://github.com/r-universe/pepijn-devries/actions/runs/26561838100" } ] }