{"templates":[{"template":"org_profile","description":"Stammdaten einer Organisation über einen amtlichen Anker (cik | lei | ein | rssd) — eine Zeile, alle verknüpften Register.","params":{"cik":{"required":false},"lei":{"required":false},"ein":{"required":false},"rssd":{"required":false}},"defaults":{},"max_rows":3},{"template":"search_org","description":"Organisationen per Namenssuche finden (liefert Anker zum Weiterfragen; für Kennzahlen danach org_profile/…_financials nutzen).","params":{"name":{"required":true},"limit":{"required":false}},"defaults":{"limit":10},"max_rows":20},{"template":"company_financials","description":"Kuratierte SEC-EDGAR-Kennzahl einer börsennotierten Firma je Periode. metric ist ein Enum (erlaubte Werte siehe Fehlerantwort).","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-Kennzahl einer US-Bank je Meldestichtag. period_kind unterscheidet Bestand (Stichtag) und year-to-date.","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-990-Kennzahl einer steuerbefreiten US-Organisation je Geschäftsjahr.","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":"Kuratierte IFRS-Kennzahl eines europäischen/internationalen Emittenten (ESEF-Filings, LEI-identifiziert). Beträge in ORIGINALWÄHRUNG (currency-Spalte) — keine Umrechnung.","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-Auswahl fürs Benchmarking: US-Filer nach SIC-Branche und Umsatzband (jüngstes Geschäftsjahr), sortiert nach Umsatz. Liefert je Peer CIK + UMSATZ + Fundstelle. NICHT für Margen/Verhältniskennzahlen (dafür peer_ratios) und nicht für andere Kennzahlen (dafür 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":"Perzentil-Verteilung einer Kennzahl über eine SIC-Peer-Group (jüngstes volles Geschäftsjahr je US-Filer). ALLE Aggregate (p10/p25/Median/p75/p90, Mittel, min/max) rechnet Postgres via percentile_cont — niemals das LLM. Optional own_value: die eigene Zahl wird in SQL als Perzentilrang (0-100) eingeordnet.","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":"Eine Kennzahl für eine LISTE von Firmen (CIK-Liste, max. 10) in einem Aufruf — für Peer-Tabellen. ciks kommagetrennt; Ticker führen wir nicht, CIK via search_org auflösen.","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":"Sektor-Übersicht: je 4-stelligem SIC-Code unter einem Präfix (oder für einen exakten Code) Anzahl Filer, Umsatzsumme und -median des jüngsten Geschäftsjahres — alles in SQL aggregiert.","params":{"sic":{"required":false},"sic_prefix":{"required":false}},"defaults":{},"max_rows":100},{"template":"peer_ratios","description":"Verhältniskennzahl je Peer (Zähler-Metrik / Nenner-Metrik, z.B. net_income/revenue = Nettomarge) über eine SIC-Peer-Group, je Firma aus DEMSELBEN Geschäftsjahr, Division in SQL. Liefert die Peer-Tabelle mit Belegen.","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":"Perzentil-Verteilung einer VERHÄLTNIS-Kennzahl (Zähler/Nenner, z.B. net_income/revenue) über eine SIC-Peer-Group — Division und percentile_cont komplett in SQL. own_value (Dezimal, 0.23=23%) wird als Perzentilrang eingeordnet.","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 je Peer über eine SIC-Peer-Group — GERECHNET als operating_income + depreciation_amortization (beides as-filed, dasselbe Geschäftsjahr), plus EBITDA-Marge. EBITDA ist keine gemeldete XBRL-Zeile — die Antwort muss das sagen.","params":{"sic":{"required":false},"sic_prefix":{"required":false}},"defaults":{},"max_rows":50},{"template":"peer_ebitda_margin_percentiles","description":"Perzentil-Verteilung der EBITDA-Marge ((operating_income + depreciation_amortization) / revenue, alles as-filed, in SQL gerechnet) über eine SIC-Peer-Group. own_value = eigene Marge als Dezimalzahl (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 je Peer (current_assets − current_liabilities zum Geschäftsjahresende, GERECHNET in SQL) plus WC/Umsatz — über eine SIC-Peer-Group. WC wird nicht gemeldet, die Bausteine sind as-filed.","params":{"sic":{"required":false},"sic_prefix":{"required":false}},"defaults":{},"max_rows":50},{"template":"peer_wc_percentiles","description":"Perzentil-Verteilung von Working Capital / Umsatz über eine SIC-Peer-Group (Differenz, Division und percentile_cont in SQL). own_value = eigenes WC/Umsatz als Dezimalzahl.","params":{"sic":{"required":false},"sic_prefix":{"required":false},"own_value":{"required":false}},"defaults":{},"max_rows":1},{"template":"peer_growth","description":"Jahreswachstum (YoY) einer Kennzahl je Peer über eine SIC-Peer-Group: jüngstes volles Geschäftsjahr vs. direktes Vorjahr derselben Firma, Wachstum in SQL gerechnet. Liefert die Peer-Tabelle mit beiden Fundstellen.","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":"Perzentil-Verteilung des Jahreswachstums (YoY) einer Kennzahl über eine SIC-Peer-Group — Wachstum und percentile_cont komplett in SQL. own_value = eigenes Wachstum als Dezimalzahl (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: welche Firmen erhalten am meisten Geld aus US-BUNDES-Awards (USAspending, FY-echte Transaktionswerte, konsolidiert über alle Registrierungen einer Gruppe). fiscal_year = Bundes-Fiskaljahr. ACHTUNG Ladestand: derzeit nur Verträge, keine Zuwendungen — siehe not_claimed.","params":{"fiscal_year":{"required":true,"allowed":["2025"]}},"defaults":{},"max_rows":25},{"template":"gov_dependency","description":"Staatsabhängigkeit einer Firma: SEC-Umsatz vs. US-Bundes-Obligations (FY-echt) je Fiskaljahr, konsolidiert. cik der Firma (via search_org auflösen).","params":{"cik":{"required":true}},"defaults":{},"max_rows":10},{"template":"bank_percentiles","description":"Perzentil-Verteilung einer BANK-Kennzahl (FFIEC Call Reports, eigene Nomenklatur: Einlagen, Tier-1, Zinsüberschuss …) über alle US-Institute — percentile_cont in SQL. Bestandsgrößen = jüngster Stichtag; GuV-Größen = letztes VOLLES Jahr (Q4-YTD). own_value ordnet die eigene Bank ein.","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 der US-Banken nach einer FFIEC-Kennzahl (Einlagen, Bilanzsumme, Tier-1, Zinsüberschuss …) — größte zuerst, jüngster Stichtag bzw. letztes volles Jahr.","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":"Änderungs-Feed einer Organisation: alle seit einem Datum neu erfassten oder geänderten Fakten (kuratierte Prädikate), mit Verweis auf den abgelösten Vorwert. Grundlage: Supersessions-Ketten — Änderungserkennung ist bei uns Registerinhalt, kein 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":"Verzeichnis-Attribute einer steuerbefreiten Organisation (501(c)-Status, NTEE-Klassifikation, Befreiungsdatum, Adresse).","params":{"ein":{"required":true}},"defaults":{},"max_rows":3}],"usage":"GET /api/query/{template}?param=wert — Antwort immer als Umschlag: result + executed_query + n + scope + not_claimed.","retrieved_at":"2026-08-30T23:58:54"}