---
title: "Country-level JOIN of US Treasury holdings (TIC) and EU fund debt (SHS)"
method: GET
path: "/api/v1/cross/transatlantic/by-country"
tags: ["Hedge Fund Intelligence"]
---

# Country-level JOIN of US Treasury holdings (TIC) and EU fund debt (SHS)

`GET /api/v1/cross/transatlantic/by-country`

Leaderboard joining TIC TBL5 (foreign holdings of US Treasury securities, USD bn) with ECB SHS S124 (EU fund debt holdings by domicile, EUR bn) via a curated TIC-slug to ISO Alpha-2 mapping. Countries outside the curated map are excluded from rows. U2 (EU aggregate) is excluded from rows but reflected in `totals.eu_fund_debt_grand_total_eur_bn`. Sort: combined activity score (USD bn + EUR bn, no FX conversion) desc, ties broken by ISO country code asc.

## Query parameters

- `n` integer — Top-N rows. 1..50, default 20.

## Response `200`

Successful Response

- EnvelopeTransatlanticByCountry
  - `data` TransatlanticByCountry, required
    - `rows` TransatlanticByCountryRow[], required
      - `country` string, required — ISO 3166-1 Alpha-2.
      - `name` string, required
      - `domicile_role` string, required — `both`, `official_holder` (TIC only), or `fund_hub` (SHS only).
      - `us_treasury_holdings_usd_bn` number, nullable
      - `eu_fund_debt_holdings_eur_bn` number, nullable
    - `totals` TransatlanticByCountryTotals, required
      - `us_treasury_grand_total_usd_bn` number, nullable
      - `eu_fund_debt_grand_total_eur_bn` number, required
    - `row_count` integer, required
    - `data_time` TransatlanticByCountryDataTime, required
      - `us_treasury_tic` string, required
      - `ecb_shs` string, required
  - `meta` SugraMeta, required — Metadata attached to every /api/v1/* response envelope.
    - `endpoint` string, required — Requested endpoint path.
    - `data_time` string, required — ISO 8601 UTC timestamp of the source data, not of the request.
    - `response_time` string, required — ISO 8601 UTC timestamp when this response was produced.
    - `provider` string, required — API name and version.
    - `source` string, nullable — Identifier of the primary upstream source used for this response.
    - `attribution` string, nullable — Human-readable attribution mandated by an upstream source (e.g. a securities regulator or self-regulatory organization). Present only on responses whose source requires the owner and source to be clearly identified. Do not remove or alter it when using the response.
    - `fallback_used` boolean, nullable — True when the primary source failed and a fallback produced the data.
    - `fallback_chain` string[], nullable — Ordered list of sources attempted, in the order they were tried.
    - `cached` boolean, nullable — True when this response was served from the internal cache.
    - `stale` boolean, nullable — True when the cached response was returned after the upstream rate-limited or errored. Clients can use this to detect degraded data.

## Other responses

- `401` — Missing or invalid `x-api-key` header. JSON body with a stable `code` distinguishing `missing_api_key` (no header sent) from `invalid_api_key` (header sent, key not accepted); any other 401 source carries the generic `unauthorized` with its detail as `reason`. Plus `hint`. `plan` is always null on 401 - an unauthenticated request has no plan; quota exhaustion is 429, not 401.
- `422` — Validation Error
- `429` — Daily rate limit exceeded. Check `X-RateLimit-Reset` for the next window.
- `503` — Upstream source is temporarily unavailable. Retry after a short delay.

---

[API](https://skmtc.net/sugra/apis/sugra-api.md) · [All operations](https://skmtc.net/sugra/apis/sugra-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/sugra/sugra-api/versions/a0c7dc18e21b/schema)