Skip to main content
U.S. flag

An official website of the United States government

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Skip to content

Data from: Temporal and agricultural factors influence E. coli survival in soil and transfer to cucumbers

Metadata Updated: April 21, 2025

Escherichia coli survival in soils containing either composted poultry litter (CPL), heat-treated poultry pellets (HTPP), poultry litter (PL) or unamended (chemical fertilizer). Test plots were either covered with plastic mulch (M) or not mulched (NoM). The study was conducted in 2018 and 2019 during cucumber growing seasons at the University of Delaware research farm and each study lasted 120 days. Data from the current study were collected to examine the survival of non-pathogenic Escherichia coli and transfer to cucumbers grown in same field in two separate years. Soil moisture, total nitrogen, nitrate, total carbon, soluble carbon, soluble solids, rainfall, soil temperature and air temperature, along with the number of days needed for E. coli to decline by 4 log CFU/gdw, were included in random forest models used to a) predict 4-log declines of E. coli inoculated to soils and b) transfer of E. coli to cucumbers from soils with different biological soil amendments. The data included here are specifically for other investigators to use to make different forms or versions of three different statistical models used in the submitted manuscript. Data for three models are included: 1) Dpi4log, the number of days needed for E. coli levels in various combinations of year, amendment and mulch, were calculated by applying sigmoidal (single, double, triple, or quadruple) model to E. coli data collected over time. 2) A random forest model using soil and weather data was used to determine which factors listed above best predicted dpi4log values. This model accounted for 98% of the observed variance. 3) A random forest model using soil and weather data, along with dpi4log, was used to predict transfer of E. coli to soils from cucumbers (log MPN/cucumber). This model accounted for approximately 63% of the variance in the study. Resources in this dataset:Resource Title: Graph of E. coli levels over 120 days in soils under various conditions. File Name: Graphs of Fitted Sigmoidal Regression Models onto Observed gEclog vs DPI.pdfResource Description: Graph of E. coli levels in 24 different combinations of year, amendment, and mulch status over 120 days Resource Title: Comparison of actual model-generated log CFU/gdw data . File Name: Observed and Sigmoidal Model Predicted gEcLog values - Daily Increment.csvResource Description: Comparison of sigmoidal model-generated log CFU/gdw vs observed data Resource Title: Soil temperature, Air temperature and Cumulative Rainfall observed in 2018 and 2019. File Name: Soil air temp cumulative rainfall 2018 2019.xlsxResource Description: These are the climate data used to inform and predict E. coli survival in soils containing biological and chemical fertilizerResource Title: Data set used in Random Forest model to predict transfer of E. coli from soils to cucumber fruits . File Name: UD ARS Cucumber Study Consolidated Data Version 2 Single Transference Column Original Data Scale.csvResource Description: This data set includes the sigmoidal model-estimated values of dpi4log (the number of days needed to achieve 4 log decline in E. coli levels) in this model Resource Title: Dataset used in Random Forest model to identify variables and factors which predict dpi4log values of E. coli in soils containing biological soil amendment of animal origin. File Name: Formatted Soil Data for Random Forest Analysis.xlsxResource Description: Dataset used in the Random Forest model to identify variables and factors which predict dpi4log values - the number of days needed to observe a 4 log reduction, estimated by sigmoidal modeling of collected E. coli data - of E. coli in soils containing biological soil amendment of animal origin

Access & Use Information

Public: This dataset is intended for public access and use. License: us-pd

Downloads & Resources

Dates

Metadata Created Date March 30, 2024
Metadata Updated Date April 21, 2025

Metadata Source

Harvested from USDA JSON

Additional Metadata

Resource Type Dataset
Metadata Created Date March 30, 2024
Metadata Updated Date April 21, 2025
Publisher Agricultural Research Service
Maintainer
Identifier 10.15482/USDA.ADC/1520517
Data Last Modified 2024-07-09
Public Access Level public
Bureau Code 005:18
Metadata Context https://project-open-data.cio.gov/v1.1/schema/catalog.jsonld
Schema Version https://project-open-data.cio.gov/v1.1/schema
Catalog Describedby https://project-open-data.cio.gov/v1.1/schema/catalog.json
Harvest Object Id b704afd0-1773-48f8-9833-2696caf1a1d0
Harvest Source Id d3fafa34-0cb9-48f1-ab1d-5b5fdc783806
Harvest Source Title USDA JSON
License https://www.usa.gov/publicdomain/label/1.0/
Old Spatial {"type": "Polygon", "coordinates": -75.751419054286, 39.660874985531, -75.751419054286, 39.669684495524, -75.739402757899, 39.669684495524, -75.739402757899, 39.660874985531, -75.751419054286, 39.660874985531}
Program Code 005:040
Source Datajson Identifier True
Source Hash 712fa92b7510eac618eb6fd9ada4c78d1bb8eb286d43523a691008e73dbc63a0
Source Schema Version 1.1
Spatial {"type": "Polygon", "coordinates": -75.751419054286, 39.660874985531, -75.751419054286, 39.669684495524, -75.739402757899, 39.669684495524, -75.739402757899, 39.660874985531, -75.751419054286, 39.660874985531}
Temporal 2018-06-14/2019-10-14

Didn't find what you're looking for? Suggest a dataset here.