admin_content
6 rows
This data as json, CSV (advanced)
Suggested facets: updated_by, updated_at (date)
| id ▼ | section | content | updated_at | updated_by |
|---|---|---|---|---|
| None | footer | {"content": "Made with ❤ by [EDGI](https://envirodatagov.org/) and [Public Environmental Data Partners](https://screening-tools.com/).", "odbl_text": "Data licensed under ODbL", "odbl_url": "https://opendatacommons.org/licenses/odbl/"} | 2025-07-15 06:43:07 | admin2 |
| None | title | {"content": "CAMPD (Clean Air Markets Program Data updated)"} | 2025-07-15 16:48:06 | admin |
| None | feature_cards | [{"title": "Emissions Data", "description": "Browse hourly and daily emissions data from power plants, including file descriptions and download links.", "url": "/CAMPD/emissions", "icon": "ri-bar-chart-line"}, {"title": "Data Archive", "description": "Access CAMPD emissions data on Zenodo to explore locally with Datasette or other tools.", "url": "https://zenodo.org/communities/edgi/records?q=campd", "icon": "ri-bar-chart-line"}, {"title": "CAM API Portal", "description": "Access CAMPD data programmatically via the EPA’s REST API.", "url": "https://www.epa.gov/power-sector/cam-api-portal", "icon": "ri-bar-chart-line"}] | 2025-07-15 16:53:49 | admin |
| None | header_image | {"image_url": "/static/header.jpg", "alt_text": "CAMPD Header by J. Alex Lang", "credit_url": "https://www.flickr.com/photos/jalexlang/21359307802/", "credit_text": "Image by J. Alex Lang. Used by permission udated."} | 2025-07-15 18:02:13 | admin |
| None | statistics | [{"label": "Total Files", "query": "SELECT COUNT(*) FROM emissions", "url": "/CAMPD/emissions"}, {"label": "Hourly Files", "query": "SELECT COUNT(*) FROM emissions WHERE unit = \"hourly\"", "url": "/CAMPD/emissions?unit=hourly"}, {"label": "Daily Files", "query": "SELECT COUNT(*) FROM emissions WHERE unit = \"daily\"", "url": "/CAMPD/emissions?unit=daily"}] | 2025-07-15 18:02:41 | admin |
| None | info | {"content": "Metadata from EPA's Clean Air Markets Program Data (CAMPD) emissions database.\nThis project, maintained by EDGI, serves as a virtual *backup* of CAMPD data, hosted on Zenodo and powered by Datasette. It includes hourly and daily emissions data, accessible for download or interactive exploration. The dataset is licensed under the [ODbL.](https://opendatacommons.org/licenses/odbl/)\nOur code is open source. The archived data and code can be found at [EDGI GitHub](https://github.com/willf/datasette-campd). Explore the data interactively at [Datasette](https://datasette.io/) or access the original data at [EPA Clean Air Markets Program Data (CAMPD)](https://campd.epa.gov/) and [Zenodo](https://zenodo.org/communities/edgi/records?q=campd).\nContact us at [contact@envirodatagov.org](mailto:contact@envirodatagov.org) for support or inquiries.\n"} | 2025-07-15 18:03:54 | admin |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE admin_content (
id TEXT PRIMARY KEY,
section TEXT NOT NULL UNIQUE,
content TEXT,
updated_at TEXT
, updated_by TEXT);