Securities Holdings Statistics - SHSS
European Central Bank
@ecb.securities_holdings_statistics_shss
Table 1
@ecb.securities_holdings_statistics_shss.table_1
- 21.19 MB
- 1297283 rows
- 49 columns
keyKEY | freqFREQ | adjustmentADJUSTMENT | ref_areaREF AREA | counterpart_areaCOUNTERPART AREA | ref_sectorREF SECTOR | counterpart_sectorCOUNTERPART SECTOR | consolidationCONSOLIDATION | accounting_entryACCOUNTING ENTRY | stoSTO | instr_assetINSTR ASSET | maturityMATURITY | expenditureEXPENDITURE | unit_measureUNIT MEASURE | currency_denomCURRENCY DENOM | valuationVALUATION | pricesPRICES | transformationTRANSFORMATION | cust_breakdownCUST BREAKDOWN | time_periodTIME PERIOD | obs_valueOBS VALUE | obs_statusOBS STATUS | conf_statusCONF STATUS | pre_break_valuePRE BREAK VALUE | comment_obsCOMMENT OBS | embargo_dateEMBARGO DATE | obs_edp_wbbOBS EDP WBB | time_formatTIME FORMAT | coll_periodCOLL PERIOD | comment_tsCOMMENT TS | compiling_orgCOMPILING ORG | currencyCURRENCY | cust_breakdown_lbCUST BREAKDOWN LB | data_compDATA COMP | decimalsDECIMALS | diss_orgDISS ORG | gfs_ecofuncGFS ECOFUNC | gfs_taxcatGFS TAXCAT | last_updateLAST UPDATE | ref_period_detailREF PERIOD DETAIL | ref_year_priceREF YEAR PRICE | repyearendREPYEAREND | repyearstartREPYEARSTART | table_identifierTABLE IDENTIFIER | time_per_collectTIME PER COLLECT | titleTITLE | title_complTITLE COMPL | unit_multUNIT MULT | comment_dsetCOMMENT DSET |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SHSS.Q.N.AT.W0.S1.S13.N.A.F.F3.L._Z.XDC._T.M.V.N._T | Q | N | AT | W0 | S1 | S13 | N | A | F | F3 | L | _Z | XDC | _T | M | V | N | _T | 2021-Q1 | 6499.53570056 | A | F | P3M | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity) , Transactions in financial assets a… | 2 | S | Debt securities held by Austria issued by World (all entities, including reference area, including IO) | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity), Transactions in financial assets an… | 6 | |||||||||||||||||||
| SHSS.Q.N.AT.W0.S1.S13.N.A.F.F3.L._Z.XDC._T.M.V.N._T | Q | N | AT | W0 | S1 | S13 | N | A | F | F3 | L | _Z | XDC | _T | M | V | N | _T | 2021-Q2 | 9191.39073675 | A | F | P3M | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity) , Transactions in financial assets a… | 2 | S | Debt securities held by Austria issued by World (all entities, including reference area, including IO) | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity), Transactions in financial assets an… | 6 | |||||||||||||||||||
| SHSS.Q.N.AT.W0.S1.S13.N.A.F.F3.L._Z.XDC._T.M.V.N._T | Q | N | AT | W0 | S1 | S13 | N | A | F | F3 | L | _Z | XDC | _T | M | V | N | _T | 2021-Q3 | 2356.28021784 | A | F | P3M | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity) , Transactions in financial assets a… | 2 | S | Debt securities held by Austria issued by World (all entities, including reference area, including IO) | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity), Transactions in financial assets an… | 6 | |||||||||||||||||||
| SHSS.Q.N.AT.W0.S1.S13.N.A.F.F3.L._Z.XDC._T.M.V.N._T | Q | N | AT | W0 | S1 | S13 | N | A | F | F3 | L | _Z | XDC | _T | M | V | N | _T | 2021-Q4 | 4448.13110102 | A | F | P3M | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity) , Transactions in financial assets a… | 2 | S | Debt securities held by Austria issued by World (all entities, including reference area, including IO) | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity), Transactions in financial assets an… | 6 | |||||||||||||||||||
| SHSS.Q.N.AT.W0.S1.S13.N.A.F.F3.L._Z.XDC._T.M.V.N._T | Q | N | AT | W0 | S1 | S13 | N | A | F | F3 | L | _Z | XDC | _T | M | V | N | _T | 2022-Q1 | 12137.86800288 | A | F | P3M | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity) , Transactions in financial assets a… | 2 | S | Debt securities held by Austria issued by World (all entities, including reference area, including IO) | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity), Transactions in financial assets an… | 6 | |||||||||||||||||||
| SHSS.Q.N.AT.W0.S1.S13.N.A.F.F3.L._Z.XDC._T.M.V.N._T | Q | N | AT | W0 | S1 | S13 | N | A | F | F3 | L | _Z | XDC | _T | M | V | N | _T | 2022-Q2 | 5229.91929337 | A | F | P3M | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity) , Transactions in financial assets a… | 2 | S | Debt securities held by Austria issued by World (all entities, including reference area, including IO) | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity), Transactions in financial assets an… | 6 | |||||||||||||||||||
| SHSS.Q.N.AT.W0.S1.S13.N.A.F.F3.L._Z.XDC._T.M.V.N._T | Q | N | AT | W0 | S1 | S13 | N | A | F | F3 | L | _Z | XDC | _T | M | V | N | _T | 2022-Q3 | -737.02248668 | A | F | P3M | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity) , Transactions in financial assets a… | 2 | S | Debt securities held by Austria issued by World (all entities, including reference area, including IO) | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity), Transactions in financial assets an… | 6 | |||||||||||||||||||
| SHSS.Q.N.AT.W0.S1.S13.N.A.F.F3.L._Z.XDC._T.M.V.N._T | Q | N | AT | W0 | S1 | S13 | N | A | F | F3 | L | _Z | XDC | _T | M | V | N | _T | 2022-Q4 | -4838.1916363 | A | F | P3M | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity) , Transactions in financial assets a… | 2 | S | Debt securities held by Austria issued by World (all entities, including reference area, including IO) | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity), Transactions in financial assets an… | 6 | |||||||||||||||||||
| SHSS.Q.N.AT.W0.S1.S13.N.A.F.F3.L._Z.XDC._T.M.V.N._T | Q | N | AT | W0 | S1 | S13 | N | A | F | F3 | L | _Z | XDC | _T | M | V | N | _T | 2023-Q1 | 5008.43920811 | A | F | P3M | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity) , Transactions in financial assets a… | 2 | S | Debt securities held by Austria issued by World (all entities, including reference area, including IO) | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity), Transactions in financial assets an… | 6 | |||||||||||||||||||
| SHSS.Q.N.AT.W0.S1.S13.N.A.F.F3.L._Z.XDC._T.M.V.N._T | Q | N | AT | W0 | S1 | S13 | N | A | F | F3 | L | _Z | XDC | _T | M | V | N | _T | 2023-Q2 | 2738.73605482 | A | F | P3M | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity) , Transactions in financial assets a… | 2 | S | Debt securities held by Austria issued by World (all entities, including reference area, including IO) | Holder area Austria , Issuer area World (all entities, including reference area, including IO) , Holder sector Total economy , Issuer sector General government , Instrument Debt securities , Maturity Long-term original maturity (over 1 year or no stated maturity), Transactions in financial assets an… | 6 |
CREATE TABLE table_1 (
"key" VARCHAR,
"freq" VARCHAR,
"adjustment" VARCHAR,
"ref_area" VARCHAR,
"counterpart_area" VARCHAR,
"ref_sector" VARCHAR,
"counterpart_sector" VARCHAR,
"consolidation" VARCHAR,
"accounting_entry" VARCHAR,
"sto" VARCHAR,
"instr_asset" VARCHAR,
"maturity" VARCHAR,
"expenditure" VARCHAR,
"unit_measure" VARCHAR,
"currency_denom" VARCHAR,
"valuation" VARCHAR,
"prices" VARCHAR,
"transformation" VARCHAR,
"cust_breakdown" VARCHAR,
"time_period" VARCHAR,
"obs_value" DOUBLE,
"obs_status" VARCHAR,
"conf_status" VARCHAR,
"pre_break_value" VARCHAR,
"comment_obs" VARCHAR,
"embargo_date" VARCHAR,
"obs_edp_wbb" VARCHAR,
"time_format" VARCHAR,
"coll_period" VARCHAR,
"comment_ts" VARCHAR,
"compiling_org" VARCHAR,
"currency" VARCHAR,
"cust_breakdown_lb" VARCHAR,
"data_comp" VARCHAR,
"decimals" BIGINT,
"diss_org" VARCHAR,
"gfs_ecofunc" VARCHAR,
"gfs_taxcat" VARCHAR,
"last_update" VARCHAR,
"ref_period_detail" VARCHAR,
"ref_year_price" VARCHAR,
"repyearend" VARCHAR,
"repyearstart" VARCHAR,
"table_identifier" VARCHAR,
"time_per_collect" VARCHAR,
"title" VARCHAR,
"title_compl" VARCHAR,
"unit_mult" BIGINT,
"comment_dset" VARCHAR
);