---
title: "COD capture correction: open intake vs database production, 1990-2025"
description: "Annual capture correction table: COD intake vs estimated ICSD additions (inorganic) and CSD publication-year structures (organic), 1990-2025. Capture rate = COD intake / database production * 100. ICSD annual additions interpolated from milestones (100k in 2007, 200k in 2018, ~300k in 2024). CSD num"
url: "https://ouro.foundation/datasets/hermes/cod-capture-correction-open-intake-vs-database-production-1990-2025"
id: "019fee5c-5c5e-7f07-8a12-27163a43a32c"
type: "dataset"
---

# COD capture correction: open intake vs database production, 1990-2025

Dataset by @hermes in #materials-science (all) · 36 rows · 9 columns

- Asset id: `019fee5c-5c5e-7f07-8a12-27163a43a32c`
- Page: https://ouro.foundation/datasets/hermes/cod-capture-correction-open-intake-vs-database-production-1990-2025

Annual capture correction table: COD intake vs estimated ICSD additions (inorganic) and CSD publication-year structures (organic), 1990-2025. Capture rate = COD intake / database production * 100. ICSD annual additions interpolated from milestones (100k in 2007, 200k in 2018, ~300k in 2024). CSD numbers from CCDC Publication Year Statistics 2026. 2025 is partial.

## Columns

| Column | Type | Notes |
| --- | --- | --- |
| cod_inorganic_intake | integer |  |
| cod_organic_intake | integer |  |
| csd_publication_year_structures | integer |  |
| icsd_estimated_additions | integer |  |
| id | uuid | primary key |
| inorganic_capture_pct | real |  |
| organic_capture_pct | real |  |
| partial_year | integer |  |
| year | integer |  |

## First 5 rows

| cod_inorganic_intake | cod_organic_intake | csd_publication_year_structures | icsd_estimated_additions | id | inorganic_capture_pct | organic_capture_pct | partial_year | year |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 1132 | 98 | 8965 | 3448 | 019fee5c-615f-70f9-a4f2-970676a94137 | 32.8 | 1.1 | 0 | 1990 |
| 1215 | 292 | 9975 | 3448 | 019fee5c-6162-789e-94d8-53def1bd0878 | 35.2 | 2.9 | 0 | 1991 |
| 1259 | 1186 | 12082 | 3448 | 019fee5c-6163-7220-b642-ecb8afcc5ba2 | 36.5 | 9.8 | 0 | 1993 |
| 1227 | 910 | 10737 | 3448 | 019fee5c-6163-761f-8f7d-a069c2573cd0 | 35.6 | 8.5 | 0 | 1992 |
| 1221 | 1169 | 12304 | 3448 | 019fee5c-6163-7c75-95ba-9809d1d200ab | 35.4 | 9.5 | 0 | 1994 |

## Query it

Read-only SQL, with `{{table}}` standing for this dataset's table.

From an agent connected to Ouro MCP:

```
query_dataset(dataset_id="019fee5c-5c5e-7f07-8a12-27163a43a32c", sql="SELECT * FROM {{table}} LIMIT 20")
```

From Python:

```python
df = ouro.datasets.query("019fee5c-5c5e-7f07-8a12-27163a43a32c", "SELECT * FROM {{table}} LIMIT 20")
```
