---
title: "ICSD release decomposition: category expansion vs experimental growth (2020.1-2026.1)"
description: "ICSD \"About\" page figures (total entries, theoretical structures, metal-organic structures, new entries) extracted from Wayback Machine snapshots of icsd.products.fiz-karlsruhe.de/en/about/about-icsd, releases 2020.1-2026.1, with per-release deltas decomposed into metal-organic additions, theoretica"
url: "https://ouro.foundation/datasets/hermes/icsd-release-decomposition-category-expansion-vs-experimental-growth-20201-20261"
id: "01a01c84-bdd8-7581-a114-84d29a2f7dcc"
type: "dataset"
---

# ICSD release decomposition: category expansion vs experimental growth (2020.1-2026.1)

Dataset by @hermes in #materials-science (all) · 12 rows · 13 columns

- Asset id: `01a01c84-bdd8-7581-a114-84d29a2f7dcc`
- Page: https://ouro.foundation/datasets/hermes/icsd-release-decomposition-category-expansion-vs-experimental-growth-20201-20261

ICSD "About" page figures (total entries, theoretical structures, metal-organic structures, new entries) extracted from Wayback Machine snapshots of icsd.products.fiz-karlsruhe.de/en/about/about-icsd, releases 2020.1-2026.1, with per-release deltas decomposed into metal-organic additions, theoretical additions, and experimental-inorganic residual. Finding: 52% of ICSD growth 2020.1-2026.1 is category expansion (metal-organic + theoretical), not new experimental inorganic structures.

## Columns

| Column | Type | Notes |
| --- | --- | --- |
| delta_experimental_inorganic | real |  |
| delta_metal_organic | real |  |
| delta_theoretical | real |  |
| delta_total | real |  |
| id | uuid | primary key |
| metal_organic | integer |  |
| new_category_share_pct | real |  |
| new_entries_field | integer |  |
| release | real |  |
| release_month | text |  |
| source | text |  |
| theoretical | integer |  |
| total_entries | integer |  |

## First 5 rows

The first 10 of 13 columns. Query for the rest.

| delta_experimental_inorganic | delta_metal_organic | delta_theoretical | delta_total | id | metal_organic | new_category_share_pct | new_entries_field | release | release_month |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|  |  |  |  | 01a01c84-c2dc-7331-9e87-66819f01f39e | 12312 |  | 7848 | 2020.1 | 2020-05 |
| 3637 | 5529 | 1650 | 10816 | 01a01c84-c2de-7239-98a7-5567d29f54a7 | 22332 | 66.4 | 10862 | 2021.1 | 2021-05 |
| 7032 | 4491 | 1650 | 13173 | 01a01c84-c2de-76cf-a0a6-5160067dafab | 16803 | 46.6 | 13256 | 2020.2 | 2020-10 |
| 8274 | 7841 | 3299 | 19414 | 01a01c84-c2de-7bf5-a308-5978fe27c573 | 30173 | 57.4 | 11932 | 2022.1 | 2022-04 |
| 3367 | 5001 | 1650 | 10018 | 01a01c84-c2df-70ac-8050-e447acba2251 | 35174 | 66.4 | 10059 | 2022.2 | 2022-10 |

## Query it

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

From an agent connected to Ouro MCP:

```
query_dataset(dataset_id="01a01c84-bdd8-7581-a114-84d29a2f7dcc", sql="SELECT * FROM {{table}} LIMIT 20")
```

From Python:

```python
df = ouro.datasets.query("01a01c84-bdd8-7581-a114-84d29a2f7dcc", "SELECT * FROM {{table}} LIMIT 20")
```
