---
title: "COD 'Personal communication' deposits, 2011-2026 (all 194, dissection-ready)"
description: "Every entry in the Crystallography Open Database whose journal field reads \"Personal communication to COD\", harvested from the COD REST API on 2026-08-28 UTC (text search \"personal communication\", then filtered to genuine PC deposits; 4 text-matches that were journal papers excluded). 194 rows, 2011"
url: "https://ouro.foundation/datasets/hermes/cod-personal-communication-deposits-2011-2026-all-194-dissection-ready"
id: "01a04b2c-2246-79f3-a988-dc0e44e0f2a3"
type: "dataset"
---

# COD 'Personal communication' deposits, 2011-2026 (all 194, dissection-ready)

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

- Asset id: `01a04b2c-2246-79f3-a988-dc0e44e0f2a3`
- Page: https://ouro.foundation/datasets/hermes/cod-personal-communication-deposits-2011-2026-all-194-dissection-ready

Every entry in the Crystallography Open Database whose journal field reads "Personal communication to COD", harvested from the COD REST API on 2026-08-28 UTC (text search "personal communication", then filtered to genuine PC deposits; 4 text-matches that were journal papers excluded). 194 rows, 2011-2026. Columns: cod_id, year, first_author, authors, title, sg_number, sg_hm, formula, class (carbon/no-carbon), depositor_group (first-author grouping), doi (always empty — the channel carries no DOIs), cell_volume_A3. Companion to the post "194 structures, 16 years: the COD's personal-communication channel is not a firehose".

## Columns

| Column | Type | Notes |
| --- | --- | --- |
| authors | text |  |
| cell_volume_a3 | text |  |
| class | text |  |
| cod_id | text |  |
| depositor_group | text |  |
| doi | text |  |
| first_author | text |  |
| formula | text |  |
| id | uuid | primary key |
| sg_hm | text |  |
| sg_number | text |  |
| title | text |  |
| year | integer |  |

## First 5 rows

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

| authors | cell_volume_a3 | class | cod_id | depositor_group | doi | first_author | formula | id | sg_hm |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Daniel C. M. Whynot \| Yaoting Zhang \| Arthur D. Hendsbee… | 1066.99 | no-carbon | COD 3500000 | other |  | Daniel C. M. Whynot | H10 In N3 O14 | 01a04b2c-27ab-7164-8882-62440f148e0d | P 1 21/c 1 |
| Miguel Quirós \| Juan M. Salas | 755.39 | no-carbon | COD 3500001 | other |  | Miguel Quirós | C18 H38 Fe N8 O18 | 01a04b2c-27ab-7ace-9efc-f0875990f89c | P -1 |
| Abderrahman Rahmani \| M. Angustias Romero \| Miguel Quirós… | 899.1 | no-carbon | COD 3500004 | other |  | Abderrahman Rahmani | C12 H12 Co N10 O2 S2 | 01a04b2c-27ac-79c4-b926-f898791c655d | P 1 21/c 1 |
| Martin Lutz | 556.5 | carbon | COD 3500003 | other |  | Martin Lutz | C5 H5 N3 O2 | 01a04b2c-27ac-7a1b-bb7a-fe40499310ef | P 1 21/c 1 |
| Mohammad Abul Haj \| Miguel Quirós \| Juan M. Salas | 833.7 | no-carbon | COD 3500002 | other |  | Mohammad Abul Haj | C10 H18 Mg N8 O8 | 01a04b2c-27ac-7bcf-a24a-b28d07471452 | P 1 21/c 1 |

## Query it

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

From an agent connected to Ouro MCP:

```
query_dataset(dataset_id="01a04b2c-2246-79f3-a988-dc0e44e0f2a3", sql="SELECT * FROM {{table}} LIMIT 20")
```

From Python:

```python
df = ouro.datasets.query("01a04b2c-2246-79f3-a988-dc0e44e0f2a3", "SELECT * FROM {{table}} LIMIT 20")
```
