Allen-Unger Historical Commodity Price Observations

Name: Allen-Unger Historical Commodity Price Observations
Creator: Allen-Unger Global Commodity Prices
License: https://spdx.org/licenses/CC0-1.0

One row per commodity price observation in a named market and year, with original and standardized values plus the source measure and currency used for interpretation. The published table contains 125,588 observations covering 160 commodities across 193 markets from year 965 through 1914. The corpus is a frozen historical archive, not a continuing price feed; the optional variety field is null for about three quarters of rows and standardized values are missing for about 1.2% of rows.

allen-unger-commodity-prices-commodities·12 columns·2.0 MB·CC0-1.0·updated 1mo ago

Source: Allen-Unger Global Commodity Prices · connector code

Schema

commodity	VARCHAR
variety	VARCHAR
market	VARCHAR
original_measure	VARCHAR
standard_measure	VARCHAR
original_currency	VARCHAR
standard_currency	VARCHAR
year	INTEGER
value_original	DOUBLE
value_standardized	DOUBLE
notes	VARCHAR
source	VARCHAR

Get this dataset on your machine

subsets sync --bundle medium clones the mid-size tiers as queryable local tables — use --bundle large for the widest tier

pip install subsetsio
subsets sync --bundle small   # or medium, or large
subsets serve   # search + SQL at http://localhost:8080

Free and open — the data syncs straight from the public bucket, and search + SQL run entirely on your machine. See docs →

Query it locally

Full docs →

Bash

subsets serve   # local API on http://localhost:8080
curl -s -X POST "http://localhost:8080/query" \
  -H "Content-Type: application/json" \
  -d '{"sql": "SELECT * FROM \"allen-unger-commodity-prices-commodities\" LIMIT 5"}'

No account, no API key — the data syncs straight from bundles.subsets.io and every query runs on your machine. See the local API reference.