# Soil E. coli Survival and Transfer to Cucumbers under Poultry Litter Amendments and Plastic Mulch: 2018 and 2019 Field Trials, Delaware (USDA ARS; Food AI Nexus Curation)

## Facts

- Provider: Manan Sharma, Pushpinder K. Litt, Bryan T. Vinyard and Kali E. Kniel (USDA ARS and University of Delaware); Food AI Nexus curation
- License: Public Domain (US Government work) (https://api.figshare.com/v2/articles/24665826)
- Size: 16 files
- Format: CSV, Parquet (in sampled files)
- Stored at: Hugging Face, https://huggingface.co/datasets/food-ai-nexus/soil-ecoli-cucumber-transfer
- Access: public, readable without an account
- DOI: https://doi.org/10.15482/USDA.ADC/1520517
- Category: Agriculture & Environment
- Source: https://huggingface.co/datasets/food-ai-nexus/soil-ecoli-cucumber-transfer
- Page: https://scigantic.com/archive/0ed74f68-25d4-5f50-816f-34091180e7dc
- Keywords: Agriculture & Environment, CSV, Parquet, Hugging Face

## About

Tabular data from a two-season (2018 and 2019) field trial at the University of Delaware research farm on how a nonpathogenic, rifampicin-resistant E. coli surrogate (TVS 355) survives in soil and transfers to cucumbers. Plots were amended with poultry litter, composted poultry litter, heat-treated poultry pellets or chemical fertilizer, either covered with plastic mulch or left bare, and each study lasted 120 days. Subsets: cucumber_transfer (one row per plot and harvest day, E. coli log MPN per cucumber), soil_survival (soil E. coli counts and fitted sigmoidal decline curves), soil_plots (soil moisture, total nitrogen, nitrate, total and soluble carbon, soluble salts and weather with days to a 4-log decline, dpi4log), plus daily temperature and rainfall. Parquet with a column map; load with datasets.load_dataset. These are surrogate counts, not pathogen measurements. Source: Ag Data Commons DOI 10.15482/USDA.ADC/1520517. U.S. Public Domain; cite Sharma, Litt, Vinyard and Kniel, Applied and Environmental Microbiology (2021), doi 10.1128/AEM.02418-20.

## Load the data

```python
import pandas as pd
df = pd.read_csv("hf://datasets/food-ai-nexus/soil-ecoli-cucumber-transfer/column_map.csv")
df.head()
```

## Data structure

File types in sampled files: CSV, Parquet

Example file: `column_map.csv`

## Open it

- In a hosted notebook with the data mounted: https://scigantic.com/archive/0ed74f68-25d4-5f50-816f-34091180e7dc
- Full record as JSON (schema card included): https://api.scigantic.com/api/archives/0ed74f68-25d4-5f50-816f-34091180e7dc
- Over MCP: `get_schema_card` with id `0ed74f68-25d4-5f50-816f-34091180e7dc` at https://api.scigantic.com/mcp

## Related topics

- [Parquet datasets](https://scigantic.com/topics/parquet)
- [CSV datasets](https://scigantic.com/topics/csv)
- [Agriculture & Environment datasets](https://scigantic.com/topics/agriculture-and-environment)
