Download and Extract Data from US EPA's ECOTOX Database
Process ECOTOX search results by converting character
to dates where...
Values represented by ECOTOX character
to dates
Values represented by ECOTOX character
to numeric
Text from the ECOTOX database to mixed_units
Build an SQLite database from zip archived tables downloaded from EPA ...
Functions for handling chemical abstract service (CAS) registry number...
Check whether a ECOTOX database exists locally
Check the locally build database for validity
Check if the locally build database is up to date
Cite the downloaded copy of the ECOTOX database
Open or close a connection to the local ECOTOX database
Download and extract ECOTOX database files and compose database
Package description
Get information on the local ECOTOX database when available
Get ECOTOX download URL from EPA website
The local path to the ECOTOX database (directory or sqlite file)
List the field names that are available from the ECOTOX database
Convert mixed units to a specific unit
Process ECOTOX search results by converting character
to numeric
w...
Process ECOTOX search results by converting character
to units where...
Search and retrieve toxicity records from the database
Search and retrieve substance information from [https://comptox.epa.go...
Search and retrieve toxicity records from the online database
The US EPA ECOTOX database is a freely available database with a treasure of aquatic and terrestrial ecotoxicological data. As the online search interface doesn't come with an API, this package provides the means to easily access and search the database in R. To this end, all raw tables are downloaded from the EPA website and stored in a local SQLite database <doi:10.1016/j.chemosphere.2024.143078>.
Useful links