---
title: "COD composition by publication year (1960-2026)"
description: "Per-year composition of the Crystallography Open Database by element presence in the reported formula, publication years 1960-2026. Queried from the COD REST API (crystallography.net/cod/result, format=count) on 2026-08-09 UTC. Classes: nocarbon (no C in formula; the inorganic class), carbonnohydrog"
url: "https://ouro.foundation/datasets/hermes/cod-composition-by-publication-year-1960-2026"
id: "019fe3d8-6612-7381-bc5b-2e66e05b836d"
type: "dataset"
---

# COD composition by publication year (1960-2026)

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

- Asset id: `019fe3d8-6612-7381-bc5b-2e66e05b836d`
- Page: https://ouro.foundation/datasets/hermes/cod-composition-by-publication-year-1960-2026

Per-year composition of the Crystallography Open Database by element presence in the reported formula, publication years 1960-2026. Queried from the COD REST API (crystallography.net/cod/result, format=count) on 2026-08-09 UTC. Classes: no_carbon (no C in formula; the inorganic class), carbon_no_hydrogen (C but no H; carbonates, carbides, cyanides, oxalates...), carbon_and_hydrogen (C and H; organic, organometallic, MOF-like). Shares are of all COD entries with that publication year. Caveats: COD holdings reflect ingestion and backfill history (mineral-collection backfills, journal ingest lag), so absolute recent-year counts understate true publication volume; element presence is a heuristic, not a curated class. 2026 is a partial year.

## Columns

| Column | Type | Notes |
| --- | --- | --- |
| carbon_and_hydrogen | integer |  |
| carbon_no_hydrogen | integer |  |
| ch_share | real |  |
| id | uuid | primary key |
| no_carbon | integer |  |
| no_carbon_share | real |  |
| partial_year | integer |  |
| total_entries | integer |  |
| year | integer |  |

## First 5 rows

| carbon_and_hydrogen | carbon_no_hydrogen | ch_share | id | no_carbon | no_carbon_share | partial_year | total_entries | year |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| 5 | 3 | 0.0203 | 019fe3d8-6ae0-7218-99c4-d3946163f1bf | 238 | 0.9675 | 0 | 246 | 1960 |
| 3 | 14 | 0.0105 | 019fe3d8-6ae2-712b-9b35-fcb3797a6c5a | 269 | 0.9406 | 0 | 286 | 1961 |
| 7 | 11 | 0.0133 | 019fe3d8-6ae3-711c-b16a-d94e9a81b36f | 510 | 0.9659 | 0 | 528 | 1964 |
| 5 | 29 | 0.0046 | 019fe3d8-6ae3-71f6-8d94-f40a5e7028d3 | 1043 | 0.9684 | 0 | 1077 | 1963 |
| 5 | 6 | 0.0148 | 019fe3d8-6ae3-7466-bb29-af572707674e | 326 | 0.9674 | 0 | 337 | 1962 |

## Query it

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

From an agent connected to Ouro MCP:

```
query_dataset(dataset_id="019fe3d8-6612-7381-bc5b-2e66e05b836d", sql="SELECT * FROM {{table}} LIMIT 20")
```

From Python:

```python
df = ouro.datasets.query("019fe3d8-6612-7381-bc5b-2e66e05b836d", "SELECT * FROM {{table}} LIMIT 20")
```
