Every validated row in EcoSense is freely available for academic and research use — as a flat CSV, as geographic features, or as a programmatic stream. Licence terms default to CC-BY with per-source overrides honoured where upstream conditions apply.
Both formats share the same schema. Pick whichever your toolchain prefers.
Comma-separated values. Compatible with Excel, Google Sheets, R, Python pandas, and virtually any data tool.
Geographic JSON with Point geometries. Ready for QGIS, Mapbox, Leaflet, and any GIS application.
The exports are served by the EcoSense API. Both endpoints stream; no auth is required for read access. Rate limits apply.
# CSV — full dataset
$ curl -L https://api.ecosense.earth/api/export/csv > ecosense.csv
# GeoJSON — full dataset
$ curl -L https://api.ecosense.earth/api/export/geojson > ecosense.geojson
# Python — pandas
>>> import pandas as pd
>>> df = pd.read_csv("https://api.ecosense.earth/api/export/csv")
>>> df.shape
(…, 19)
# R — tidyverse
> library(readr)
> df <- read_csv("https://api.ecosense.earth/api/export/csv")| Column | Type | Description |
|---|---|---|
| doi | string | Digital Object Identifier of the source paper |
| paper_title | string | Title of the source publication |
| location_name | string | Human-readable name of the sampling location |
| country | string | ISO 3166-1 country name |
| lat | float | Latitude (WGS84) of the sampling point |
| lon | float | Longitude (WGS84) of the sampling point |
| matrix | string | Environmental matrix: water, soil, air, sediment, or biota |
| compound | string | Chemical compound name (e.g. PFOA, Cadmium, PCB-153) |
| value | float | Measured concentration value |
| unit | string | Measurement unit (e.g. ng/L, mg/kg, ug/m3) |
| sample_year | int | Year the sample was collected |
| below_lod | bool | Whether the value is below the limit of detection |
| confidence | string | Council confidence level: high, medium, or low |
| council_score | float | Council consensus score (0-10) |
| qa_verdict | string | Quality assurance verdict: accept, flag, or reject |
| method | string | Analytical method used (e.g. LC-MS/MS, ICP-MS) |
| dtxsid | string | EPA DSSTox substance ID — linked via CompoundCanonical |
| cas | string | CAS registry number |
| half_life_bin | int | EPA predicted human half-life bin: 1 (<12h), 2 (12h–1w), 3 (1w–2m), 4 (>2m) |