Download or re-download the public GHED workbook and rebuild SQLite.

Return local workbook and derived SQLite cache status.

Compare the local cache source document with the current GHED all-data file.

Return workbook version lines and cache provenance.

Explain how GHED variables are organized and how to choose the right series.

Curated GHED topic index mapping common user requests to variable codes.

Research patterns seen in GHED-using literature, with recommended variables.

Map a natural-language research question to likely GHED variables and cautions.

List GHED variable category counts from the Codebook.

List headline GHED indicators only (category_1 = INDICATORS).

List all GHED Codebook variables, optionally filtered by category.

Search headline GHED indicators by default; pass category_1=None for all variables.

Search all GHED Codebook variables, including detailed SHA series.

List countries and territories available in GHED, optionally by group.

country_group accepts curated codes (LAC, OECD, LDC, SSA, …) and intersects with region / income when more than one is set, so country_group="LAC", income="High" returns LAC HICs.

List GHED country grouping values by region and World Bank income class.

List Decilion's curated country groupings (WB regions, LDCs, OECD).

Returns groups beyond GHED's built-in WHO regions and World Bank income classes — World Bank geographic regions, the UN Least Developed Countries list, and OECD membership. Use the returned members lists with the countries parameter on data tools, or pass the group code to resolve_country_group_membership to get just the ISO3 list.

Resolve a curated group code to its ISO3 member list.

Accepts canonical codes (LAC, SSA, LDC, OECD, …), official WB region codes (LCN, SSF, …), and common spellings ("Latin America and Caribbean", "Sub-Saharan Africa", "Least Developed Countries").

Find ISO3 country codes by name, alias, or code fragment.

Return Codebook metadata for one GHED indicator.

Return source, data-type, and estimation notes from the Metadata sheet.

Summarize availability for indicators before building a research panel.

Return known additive child relationships for a GHED variable.

Explain whether a variable is a total, component, ratio/share, or context series.

Build and validate an additive breakdown for one country-year.

Build a tidy long panel for multiple GHED variables across countries and years.

country_group accepts curated codes ("LAC", "OECD", "LDC", "SSA", …) that resolve to ISO3 lists; combine freely with countries, region, and income (filters apply via SQL AND).

Build export-ready CSV data, codebook, and README text for a research extract.

Fetch one GHED indicator with optional country and year filters.

Spatial filters compose: country (singular), countries (list), and country_group (curated, e.g. "LAC") merge into a single country list, and region / income further constrain via SQL AND.

One GHED indicator across countries, returned as tidy rows or CSV.

Pass either an explicit countries list or a curated country_group (e.g. "LAC", "OECD", "LDC", "SSA") — or both, in which case they are merged. See list_curated_country_groups for available groups.

Compare one GHED indicator across a country group (curated, regional, or income-based).

Pass at least one of country_group (e.g. "LAC", "OECD", "LDC"), region, or income. Multiple filters compose via SQL AND, so country_group="LAC", income="High" returns LAC HICs.

Summarize an indicator within a country group (curated, regional, or income).

Pass at least one of country_group ("LAC", "OECD", "LDC", …), region, or income.

Compute country-level first/latest trends for one GHED indicator.

Compute first/latest trend summaries for multiple GHED indicators.

Rank countries by change in one indicator over the requested period.

Summarize metadata, availability, and cautions for an indicator/filter.

Latest headline health-expenditure values for one country.