Get series data
get_seriesFetch one series' data: timeseries, tabular, or COMPOUND:: all work.
Returns title, units, frequency, notes and data points, with source metadata.
transform="yoy_pct" (percent change) or "yoy_diff" (difference, for rates)
adds a column with the change versus the same period one year earlier,
matched by calendar date — use it for inflation or growth from one series
instead of a LAG(value, 12) query, which goes wrong after any missing
month. The cell is null where the prior-year period is absent, and
transform.periods_without_prior lists those periods.
If the result carries a coverage_note, the series has periods with no
observation (listed in missing_periods): say so in the answer, leave them
blank rather than interpolating, and label any aggregate that spans them
as partial.
SEC-backed results include row_sources keyed by result_index; each entry
identifies the supporting filing, accession/form/publication date, whether
the observation is reported or derived, and its standardized source_link.
Cite that row's source URL beside any figure and label derived observations
as derived. A document-precision link does not open an exact passage.
IMF (imf schema) results also carry projections_start_after (the last
year the IMF counts as actual; later years are IMF staff projections),
release_label (the IMF publication, e.g. "Fiscal Monitor (October
2026)") and, when either is known, a projection_note. Say which years
are projections when you use them. Both fields are null when the IMF
gives no such fact for the series.
At most 50 points come back; if the series is longer the result is flagged
"truncated": true — narrow it with from_year/to_year, or pull the series
through run_sql with an aggregation (e.g. monthly/quarterly via
date_trunc) rather than trying to fetch every point.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | Yes | ||
| to_year | No | ||
| from_year | No | ||
| series_id | Yes | ||
| transform | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||