Simplify AnalyticsFRED / ALFRED vintages
core.fred_observations
MIXED LICENCE. Holds the ICE BofA credit spreads, which may not be redistributed, alongside the ALFRED Tier A macro series, which may. Export is filtered per row on `source`; browsing is not.
This table holds sources under different licences. The CSV contains 111,461 of 115,494 rows; fred_ice_oas is excluded. Browsing here is not redistribution — exporting is.
Sources in this table
fred_ice_oas4,033 rowsrestricted — hover for the licencefred_tier_a111,461 rowsexportable
active:value_raw = 1.9×
observation_date leads no index, so this sort reads every matching row and keeps only the top 50 in a heap (the page LIMIT), under a 5s statement timeout.
| series_idtext | observation_date ↓date | realtime_startdate | realtime_enddate | valuenumeric | value_rawtext | sourcetext | endpointtext | request_paramsjsonb | as_ofdate | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|---|---|
| EFFR | 2019-10-16 | 2019-10-17 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"EFFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| EFFR | 2019-10-15 | 2019-10-16 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"EFFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| EFFR | 2019-09-30 | 2019-10-01 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"EFFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| EFFR | 2019-09-25 | 2019-09-26 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"EFFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| EFFR | 2019-09-24 | 2019-09-25 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"EFFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| EFFR | 2019-09-23 | 2019-09-24 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"EFFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| EFFR | 2019-09-20 | 2019-09-23 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"EFFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| EFFR | 2019-09-19 | 2019-09-20 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"EFFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-08-22 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-08-21 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-08-20 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-08-17 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-08-10 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-07-26 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-07-24 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-07-19 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-07-18 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-07-13 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-07-12 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-06-27 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-06-26 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-06-18 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| EFFR | 2018-06-18 | 2018-06-19 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"EFFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| EFFR | 2018-06-15 | 2018-06-18 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"EFFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| SOFR | 2018-06-14 | 2019-03-29 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"SOFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |
| EFFR | 2018-06-14 | 2018-06-15 | 9999-12-31 | 1.900000 | 1.9 | fred_tier_a | /fred/series/observations | {"series_id":"EFFR","full_vintage":true} | 2026-09-16 | 2026-09-16 06:00 | 2026-09-16 06:00 |