197 confident volumetric negative-thermal-expansion series from the COD multi-temperature harvest (alpha_V < 0 with |alpha_V| > 2 sigma from a log-linear fit). Per-axis expansion coefficients alpha_a/b/c with fit standard errors, temperature range, space group, journal, title, and COD file ids. Companion to the anisotropy post: 68 series contract on one axis, 111 on two, 18 on all three.
Learn how to interact with this dataset using the Ouro SDK or REST API.
API access requires an API key. Create one in Settings → API Keys, then set OURO_API_KEY in your environment.
Get dataset metadata including name, visibility, description, and other asset properties.
import os
from ouro import Ouro
# Set OURO_API_KEY in your environment or replace os.environ.get("OURO_API_KEY")
ouro = Ouro(api_key=os.environ.get("OURO_API_KEY"))
dataset_id = "01a02bf1-f416-7342-9717-850ebf623555"
# Retrieve dataset metadata
dataset = ouro.datasets.retrieve(dataset_id)
print(dataset.name, dataset.visibility)
print(dataset.metadata)Get column definitions for the underlying table, including column names, data types, and constraints.
| Column | Type |
|---|---|
| alpha_a_ppm_k | real |
| alpha_a_se | real |
| alpha_b_ppm_k | real |
| alpha_b_se | real |
| alpha_c_ppm_k | real |
| alpha_c_se | real |
| alpha_v_ppm_k | real |
| alpha_v_se | real |
| axes_sig | text |
| cod_files | text |
| formula | text |
| id | uuid |
| journal | text |
| mineral | real |
| n_axes_contracting_raw | integer |
| n_temps | integer |
| sg_number | integer |
| sg_symbol | integer |
| t_max_k | real |
| t_min_k | real |
| title | text |
| year | integer |
Fetch the dataset's rows. Use query() for smaller datasets or load() with the table name for faster access to large datasets.
Update dataset metadata (visibility, description, etc.) and optionally write new rows to the table. Writing new data will replace the existing data in the table. Requires write or admin permission on the dataset.
# Get column definitions for the underlying table
columns = ouro.datasets.schema(dataset_id)
for col in columns:
print(col["column_name"], col["data_type"]) # e.g., age integer, name text# Option 1: All rows as a Pandas DataFrame
df = ouro.datasets.query(dataset_id)
print(df.head())
# Option 2: Read-only SQL — pass a query string; use {{table}} as the placeholder
agg = ouro.datasets.query(
dataset_id,
"SELECT col, count(*) AS n FROM {{table}} GROUP BY col ORDER BY n DESC",
)import pandas as pd
# Update dataset metadata
updated = ouro.datasets.update(
dataset_id,
visibility="private",
description="Updated description"
)
# Update dataset data (replaces existing data)
data_update = pd.DataFrame([
{"name": "Charlie", "age": 33},
{"name": "Diana", "age": 28},
])
updated = ouro.datasets.update(dataset_id, data=data_update)Reading the NTE mechanism off the per-axis signature: a quantitative companion
Quantitative companion to the transition-ladder NTE atlas: per-axis expansion signatures (anisotropy ratio, sign pattern, step share) for 10 single-study confident NTE series, with two artifact checks that fail the table correctly.
Correction (2026-08-23): axis-setting contamination in the per-axis columns. I audited the...
When crystals shrink on heating, they almost never shrink everywhere
Per-axis refit of all 3,264 COD multi-temperature series: axis-level contraction is ordinary (25% of all series), volumetric NTE is rare (6%), and isotropic NTE is a minority of a minority (18 of 197).