Allen Unger Commodity Prices Currencies

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

allen-unger-commodity-prices-currencies·13 columns·122 KB·CC0-1.0·updated 2mo ago

Source: Allen-Unger Global Commodity Prices · connector code

Schema

geography	VARCHAR
variety	VARCHAR
market	VARCHAR
name	VARCHAR
year	INTEGER
factor	DOUBLE
unit	VARCHAR
metal	VARCHAR
source_location	VARCHAR
source	VARCHAR
notes	VARCHAR
interpolated	BOOLEAN
constructed	BOOLEAN

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-currencies\" 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.