Name: FRED Category 32263
Creator: FRED
License: https://fred.stlouisfed.org/docs/api/terms_of_use.html

About this Dataset

FRED Category 32263

Each dataset in this collection contains the public time series from one FRED top-level category
(e.g., Prices, National Accounts) together with their full observation histories.

Tables included:

series: core series metadata (title, frequency, units, seasonal adjustment, notes, etc.).
observations: values over time for each series.

Notes

Values are provided both as the raw string from FRED (value_raw) and a parsed numeric (value).
Missing values in FRED (“.”) are preserved in value_raw and set to NULL in value.
Observation dates are stored as calendar dates.
For provenance, each row links to its series_id. Series notes are included to help analysts.
FRED Terms of Use apply to this dataset; see License link.

Disclaimer: This dataset uses the FRED® API but is not endorsed or certified by the Federal Reserve Bank of St. Louis.

Tables

FRED Observations

@fred.cat_32263.observations

344.46 MB
18,169,569 rows
4 columns

CREATE TABLE observations (
  "series_id" VARCHAR,
  "date" TIMESTAMP,
  "value_raw" DOUBLE,
  "value" DOUBLE
);

FRED Series (catalog)

@fred.cat_32263.series

11.36 MB
128,959 rows
16 columns

CREATE TABLE series (
  "series_id" VARCHAR,
  "title" VARCHAR,
  "observation_start" TIMESTAMP,
  "observation_end" TIMESTAMP,
  "frequency" VARCHAR,
  "frequency_short" VARCHAR,
  "units" VARCHAR,
  "units_short" VARCHAR,
  "seasonal_adjustment" VARCHAR,
  "seasonal_adjustment_short" VARCHAR,
  "last_updated" TIMESTAMP,
  "popularity" BIGINT,
  "group_popularity" BIGINT,
  "notes" VARCHAR,
  "category_ids" VARCHAR,
  "category_paths" VARCHAR
);