{"templates":[{"template":"org_profile","description":"Master data for one organisation via an official identifier (cik | lei | ein | rssd) — one row, every linked register.","params":{"cik":{"required":false},"lei":{"required":false},"ein":{"required":false},"rssd":{"required":false}},"defaults":{},"max_rows":3},{"template":"search_org","description":"Find organisations by name (returns the identifiers for follow-up queries; for figures, use org_profile/…_financials next).","params":{"name":{"required":true},"limit":{"required":false}},"defaults":{"limit":10},"max_rows":20},{"template":"company_financials","description":"Curated SEC EDGAR metric for a listed company, per period. metric is an enum — the error response lists the permitted values.","params":{"cik":{"required":true},"metric":{"required":true,"allowed":["revenue","net_income","operating_income","pretax_income","profit_loss","operating_expenses","sga_expense","income_tax_expense","interest_expense","eps_basic","eps_diluted","shares_wavg_basic","shares_wavg_diluted","common_shares_outstanding","common_shares_issued","total_assets","total_liabilities","total_liabilities_and_equity","stockholders_equity","retained_earnings","cash_and_equivalents","current_assets","current_liabilities","ppe_net","long_term_debt","cashflow_operating","cashflow_investing","cashflow_financing","share_based_compensation","rd_expense","depreciation_amortization","inventory","cost_of_revenue","gross_profit"]},"year_from":{"required":false},"year_to":{"required":false},"period":{"required":false,"allowed":["annual","all"]}},"defaults":{"period":"annual"},"max_rows":200},{"template":"bank_metrics","description":"FFIEC Call Report metric for a US bank, per reporting date. period_kind separates point-in-time balances from year-to-date figures.","params":{"rssd":{"required":false},"fdic_cert":{"required":false},"metric":{"required":true,"allowed":["total_assets","total_liabilities","bank_total_deposits","bank_total_loans","bank_equity_capital","bank_tier1_capital","bank_total_capital","bank_risk_weighted_assets","bank_trading_assets","bank_securities_afs","bank_securities_htm","bank_loan_loss_allowance","bank_net_income","bank_interest_income","bank_interest_expense","bank_net_interest_income","bank_noninterest_income","bank_noninterest_expense","bank_pretax_income","bank_income_tax","bank_loan_loss_provision","bank_deposits_interest","bank_deposits_noninterest"]},"year_from":{"required":false},"year_to":{"required":false}},"defaults":{},"max_rows":120},{"template":"nonprofit_financials","description":"IRS Form 990 metric for a US tax-exempt organisation, per fiscal year.","params":{"ein":{"required":true},"metric":{"required":true,"allowed":["revenue","total_expenses","net_assets","total_assets","total_liabilities","contributions_and_grants","program_service_revenue","employee_count","volunteer_count","officer_compensation_total"]},"year_from":{"required":false},"year_to":{"required":false}},"defaults":{},"max_rows":60},{"template":"company_financials_eu","description":"Curated IFRS metric for a European or international issuer (ESEF filings, identified by LEI). Amounts are in the ORIGINAL CURRENCY (see the currency column) — nothing is converted.","params":{"lei":{"required":true},"metric":{"required":true,"allowed":["revenue","net_income","operating_income","pretax_income","income_tax_expense","total_assets","total_liabilities","stockholders_equity","current_assets","current_liabilities","cash_and_equivalents","ppe_net","cashflow_operating","cashflow_investing","cashflow_financing","eps_basic","eps_diluted"]},"year_from":{"required":false},"year_to":{"required":false}},"defaults":{},"max_rows":100},{"template":"peer_companies","description":"Peer group selection for benchmarking: US filers by SIC industry and revenue band (most recent fiscal year), sorted by revenue. Returns CIK + REVENUE + source reference per peer. NOT for margins or ratios — use peer_ratios — and not for other metrics — use metric_for_tickers/peer_percentiles.","params":{"sic":{"required":false},"sic_prefix":{"required":false},"revenue_min":{"required":false},"revenue_max":{"required":false}},"defaults":{},"max_rows":50},{"template":"peer_percentiles","description":"Percentile distribution of a metric across a SIC peer group (most recent full fiscal year per US filer). EVERY aggregate (p10/p25/median/p75/p90, mean, min/max) is computed by Postgres via percentile_cont — never by the language model. Optional own_value: your own figure is ranked as a percentile (0-100) in SQL.","params":{"sic":{"required":false},"sic_prefix":{"required":false},"metric":{"required":true,"allowed":["revenue","net_income","operating_income","pretax_income","profit_loss","operating_expenses","sga_expense","income_tax_expense","interest_expense","eps_basic","eps_diluted","shares_wavg_basic","shares_wavg_diluted","common_shares_outstanding","common_shares_issued","total_assets","total_liabilities","total_liabilities_and_equity","stockholders_equity","retained_earnings","cash_and_equivalents","current_assets","current_liabilities","ppe_net","long_term_debt","cashflow_operating","cashflow_investing","cashflow_financing","share_based_compensation","rd_expense","depreciation_amortization","inventory","cost_of_revenue","gross_profit"]},"revenue_min":{"required":false},"revenue_max":{"required":false},"own_value":{"required":false}},"defaults":{},"max_rows":1},{"template":"metric_for_tickers","description":"One metric for a LIST of companies (CIK list, max. 10) in a single call — for peer tables. ciks is comma-separated. We do not carry ticker symbols; resolve the CIK via search_org.","params":{"ciks":{"required":true},"metric":{"required":true,"allowed":["revenue","net_income","operating_income","pretax_income","profit_loss","operating_expenses","sga_expense","income_tax_expense","interest_expense","eps_basic","eps_diluted","shares_wavg_basic","shares_wavg_diluted","common_shares_outstanding","common_shares_issued","total_assets","total_liabilities","total_liabilities_and_equity","stockholders_equity","retained_earnings","cash_and_equivalents","current_assets","current_liabilities","ppe_net","long_term_debt","cashflow_operating","cashflow_investing","cashflow_financing","share_based_compensation","rd_expense","depreciation_amortization","inventory","cost_of_revenue","gross_profit"]},"year_from":{"required":false},"year_to":{"required":false},"period":{"required":false,"allowed":["annual","all"]}},"defaults":{"period":"annual"},"max_rows":300},{"template":"sector_summary","description":"Sector overview: for each 4-digit SIC code under a prefix (or for one exact code), the number of filers plus total and median revenue for the most recent fiscal year — all aggregated in SQL.","params":{"sic":{"required":false},"sic_prefix":{"required":false}},"defaults":{},"max_rows":100},{"template":"peer_ratios","description":"Ratio per peer (numerator metric / denominator metric, e.g. net_income/revenue = net margin) across a SIC peer group, both figures taken from the SAME fiscal year of each company, divided in SQL. Returns the peer table with source references.","params":{"sic":{"required":false},"sic_prefix":{"required":false},"metric_num":{"required":true,"allowed":["revenue","net_income","operating_income","pretax_income","profit_loss","operating_expenses","sga_expense","income_tax_expense","interest_expense","eps_basic","eps_diluted","shares_wavg_basic","shares_wavg_diluted","common_shares_outstanding","common_shares_issued","total_assets","total_liabilities","total_liabilities_and_equity","stockholders_equity","retained_earnings","cash_and_equivalents","current_assets","current_liabilities","ppe_net","long_term_debt","cashflow_operating","cashflow_investing","cashflow_financing","share_based_compensation","rd_expense","depreciation_amortization","inventory","cost_of_revenue","gross_profit"]},"metric_den":{"required":true,"allowed":["revenue","net_income","operating_income","pretax_income","profit_loss","operating_expenses","sga_expense","income_tax_expense","interest_expense","eps_basic","eps_diluted","shares_wavg_basic","shares_wavg_diluted","common_shares_outstanding","common_shares_issued","total_assets","total_liabilities","total_liabilities_and_equity","stockholders_equity","retained_earnings","cash_and_equivalents","current_assets","current_liabilities","ppe_net","long_term_debt","cashflow_operating","cashflow_investing","cashflow_financing","share_based_compensation","rd_expense","depreciation_amortization","inventory","cost_of_revenue","gross_profit"]}},"defaults":{},"max_rows":50},{"template":"peer_ratio_percentiles","description":"Percentile distribution of a RATIO (numerator/denominator, e.g. net_income/revenue) across a SIC peer group — division and percentile_cont entirely in SQL. own_value (decimal, 0.23 = 23%) is ranked as a percentile.","params":{"sic":{"required":false},"sic_prefix":{"required":false},"metric_num":{"required":true,"allowed":["revenue","net_income","operating_income","pretax_income","profit_loss","operating_expenses","sga_expense","income_tax_expense","interest_expense","eps_basic","eps_diluted","shares_wavg_basic","shares_wavg_diluted","common_shares_outstanding","common_shares_issued","total_assets","total_liabilities","total_liabilities_and_equity","stockholders_equity","retained_earnings","cash_and_equivalents","current_assets","current_liabilities","ppe_net","long_term_debt","cashflow_operating","cashflow_investing","cashflow_financing","share_based_compensation","rd_expense","depreciation_amortization","inventory","cost_of_revenue","gross_profit"]},"metric_den":{"required":true,"allowed":["revenue","net_income","operating_income","pretax_income","profit_loss","operating_expenses","sga_expense","income_tax_expense","interest_expense","eps_basic","eps_diluted","shares_wavg_basic","shares_wavg_diluted","common_shares_outstanding","common_shares_issued","total_assets","total_liabilities","total_liabilities_and_equity","stockholders_equity","retained_earnings","cash_and_equivalents","current_assets","current_liabilities","ppe_net","long_term_debt","cashflow_operating","cashflow_investing","cashflow_financing","share_based_compensation","rd_expense","depreciation_amortization","inventory","cost_of_revenue","gross_profit"]},"own_value":{"required":false}},"defaults":{},"max_rows":1},{"template":"peer_ebitda","description":"EBITDA per peer across a SIC peer group — CALCULATED as operating_income + depreciation_amortization (both as-filed, same fiscal year), plus EBITDA margin. EBITDA is not a reported XBRL line item, and the answer must say so.","params":{"sic":{"required":false},"sic_prefix":{"required":false}},"defaults":{},"max_rows":50},{"template":"peer_ebitda_margin_percentiles","description":"Percentile distribution of EBITDA margin ((operating_income + depreciation_amortization) / revenue, all as-filed, computed in SQL) across a SIC peer group. own_value = your own margin as a decimal (0.23 = 23%).","params":{"sic":{"required":false},"sic_prefix":{"required":false},"own_value":{"required":false}},"defaults":{},"max_rows":1},{"template":"peer_working_capital","description":"Working capital per peer (current_assets − current_liabilities at fiscal year end, CALCULATED in SQL) plus WC/revenue — across a SIC peer group. Working capital is not reported; its components are as-filed.","params":{"sic":{"required":false},"sic_prefix":{"required":false}},"defaults":{},"max_rows":50},{"template":"peer_wc_percentiles","description":"Percentile distribution of working capital / revenue across a SIC peer group (subtraction, division and percentile_cont in SQL). own_value = your own WC/revenue as a decimal.","params":{"sic":{"required":false},"sic_prefix":{"required":false},"own_value":{"required":false}},"defaults":{},"max_rows":1},{"template":"peer_growth","description":"Year-over-year growth of a metric per peer across a SIC peer group: most recent full fiscal year against the immediately preceding year of the same company, growth computed in SQL. Returns the peer table with both source references.","params":{"sic":{"required":false},"sic_prefix":{"required":false},"metric":{"required":true,"allowed":["revenue","net_income","operating_income","pretax_income","profit_loss","operating_expenses","sga_expense","income_tax_expense","interest_expense","eps_basic","eps_diluted","shares_wavg_basic","shares_wavg_diluted","common_shares_outstanding","common_shares_issued","total_assets","total_liabilities","total_liabilities_and_equity","stockholders_equity","retained_earnings","cash_and_equivalents","current_assets","current_liabilities","ppe_net","long_term_debt","cashflow_operating","cashflow_investing","cashflow_financing","share_based_compensation","rd_expense","depreciation_amortization","inventory","cost_of_revenue","gross_profit"]}},"defaults":{},"max_rows":50},{"template":"peer_growth_percentiles","description":"Percentile distribution of year-over-year growth of a metric across a SIC peer group — growth and percentile_cont entirely in SQL. own_value = your own growth as a decimal (0.12 = +12%).","params":{"sic":{"required":false},"sic_prefix":{"required":false},"metric":{"required":true,"allowed":["revenue","net_income","operating_income","pretax_income","profit_loss","operating_expenses","sga_expense","income_tax_expense","interest_expense","eps_basic","eps_diluted","shares_wavg_basic","shares_wavg_diluted","common_shares_outstanding","common_shares_issued","total_assets","total_liabilities","total_liabilities_and_equity","stockholders_equity","retained_earnings","cash_and_equivalents","current_assets","current_liabilities","ppe_net","long_term_debt","cashflow_operating","cashflow_investing","cashflow_financing","share_based_compensation","rd_expense","depreciation_amortization","inventory","cost_of_revenue","gross_profit"]},"own_value":{"required":false}},"defaults":{},"max_rows":1},{"template":"gov_top_recipients","description":"Ranking: which companies receive the most money from US FEDERAL awards (USAspending, true fiscal-year transaction values, consolidated across every registration belonging to a group). fiscal_year = federal fiscal year. NOTE on coverage: contracts only at present, no grants — see not_claimed.","params":{"fiscal_year":{"required":true,"allowed":["2025"]}},"defaults":{},"max_rows":25},{"template":"gov_dependency","description":"How dependent a company is on government money: SEC revenue against US federal obligations (true fiscal year), per fiscal year, consolidated. cik of the company — resolve it via search_org.","params":{"cik":{"required":true}},"defaults":{},"max_rows":10},{"template":"bank_percentiles","description":"Percentile distribution of a BANK metric (FFIEC Call Reports, own nomenclature: deposits, tier 1, net interest income …) across all US institutions — percentile_cont in SQL. Balance-sheet figures = most recent reporting date; income-statement figures = last FULL year (Q4 year-to-date). own_value ranks your own bank.","params":{"metric":{"required":true,"allowed":["total_assets","total_liabilities","bank_total_deposits","bank_total_loans","bank_equity_capital","bank_tier1_capital","bank_total_capital","bank_risk_weighted_assets","bank_trading_assets","bank_securities_afs","bank_securities_htm","bank_loan_loss_allowance","bank_net_income","bank_interest_income","bank_interest_expense","bank_net_interest_income","bank_noninterest_income","bank_noninterest_expense","bank_pretax_income","bank_income_tax","bank_loan_loss_provision","bank_deposits_interest","bank_deposits_noninterest"]},"own_value":{"required":false}},"defaults":{},"max_rows":1},{"template":"bank_ranking","description":"Ranking of US banks by an FFIEC metric (deposits, total assets, tier 1, net interest income …) — largest first, most recent reporting date or last full year.","params":{"metric":{"required":true,"allowed":["total_assets","total_liabilities","bank_total_deposits","bank_total_loans","bank_equity_capital","bank_tier1_capital","bank_total_capital","bank_risk_weighted_assets","bank_trading_assets","bank_securities_afs","bank_securities_htm","bank_loan_loss_allowance","bank_net_income","bank_interest_income","bank_interest_expense","bank_net_interest_income","bank_noninterest_income","bank_noninterest_expense","bank_pretax_income","bank_income_tax","bank_loan_loss_provision","bank_deposits_interest","bank_deposits_noninterest"]}},"defaults":{},"max_rows":25},{"template":"org_changes","description":"Change feed for one organisation: every fact newly recorded or changed since a given date (curated predicates), each referencing the previous value it superseded. Built on supersession chains — here, change detection is register content, not a diff.","params":{"cik":{"required":false},"lei":{"required":false},"ein":{"required":false},"rssd":{"required":false},"since":{"required":true}},"defaults":{},"max_rows":200},{"template":"nonprofit_profile","description":"Directory attributes of a tax-exempt organisation (501(c) status, NTEE classification, exemption date, address).","params":{"ein":{"required":true}},"defaults":{},"max_rows":3}],"usage":"GET /api/query/{template}?param=value — every answer is an envelope: result + executed_query + n + scope + not_claimed.","retrieved_at":"2026-10-18T07:43:17"}