home / calcfi-open-data

Latest value per series

The most recent observation for every series, with the human title.

Custom SQL query returning 24 rows (hide)

SELECT s.title, o.date, o.value, o.unit
FROM observations o
JOIN sources s ON s.slug = o.slug
WHERE (o.slug, o.date) IN (
  SELECT slug, MAX(date) FROM observations GROUP BY slug
)
ORDER BY s.title

Edit SQL

This data as json, copyable, CSV

titledatevalueunit
10-Year Treasury Yield 2026-05-15 4.59 percent
15-Year Fixed Mortgage Rate 2026-05-14 5.71 percent
2-Year Treasury Yield 2026-05-15 4.09 percent
30-Year Fixed Mortgage Rate 2026-05-14 6.36 percent
Average Hourly Earnings (Private Sector) 2026-04-01 37.41 usd
Commercial Bank Credit Card Interest Rate 2026-02-01 21.0 percent
Consumer Price Index (CPI) 2026-04-01 332.407 index
Copper Price (Global Benchmark) 2026-03-01 12528.70954545455 usd
Corn Price (Global Benchmark) 2026-03-01 213.3041428571428 usd
Crude Oil Price (Brent) 2026-05-11 106.11 usd_per_barrel
Crude Oil Price (West Texas Intermediate) 2026-05-11 101.56 usd_per_barrel
Eurozone GDP Per Capita 2024-01-01 43304.9642561331 usd
Federal Funds Rate 2026-05-15 3.63 percent
Japanese Yen to US Dollar Exchange Rate 2026-05-15 158.69 ratio
Labor Force Participation Rate 2026-04-01 61.8 percent
PCE Price Index 2026-03-01 130.344 index
Personal Loan Rate (24-Month, Commercial Banks) 2026-02-01 11.4 percent
Prime Lending Rate 2026-05-08 6.75 percent
US Dollar to British Pound Exchange Rate 2026-05-15 1.3332 ratio
US Dollar to Euro Exchange Rate 2026-05-15 1.1627 ratio
US GDP Per Capita 2024-01-01 84534.0407841548 usd
US Regular Gas Price (Weekly National Average) 2026-05-18 4.49 usd_per_gallon
US Unemployment Rate 2026-04-01 4.3 percent
World Unemployment Rate 2025-01-01 4.79097241077406 percent
Powered by Datasette · Queries took 35.565ms