Baselight

Government Finance Statistics (ECB And Eurostat) - GFS

European Central Bank

@ecb.government_finance_statistics_ecb_and_eurostat_gfs

Table 1
@ecb.government_finance_statistics_ecb_and_eurostat_gfs.table_1

  • 28.47 MB
  • 5928678 rows
  • 49 columns
key

KEY

freq

FREQ

adjustment

ADJUSTMENT

ref_area

REF AREA

counterpart_area

COUNTERPART AREA

ref_sector

REF SECTOR

counterpart_sector

COUNTERPART SECTOR

consolidation

CONSOLIDATION

accounting_entry

ACCOUNTING ENTRY

sto

STO

instr_asset

INSTR ASSET

maturity

MATURITY

expenditure

EXPENDITURE

unit_measure

UNIT MEASURE

currency_denom

CURRENCY DENOM

valuation

VALUATION

prices

PRICES

transformation

TRANSFORMATION

cust_breakdown

CUST BREAKDOWN

time_period

TIME PERIOD

obs_value

OBS VALUE

obs_status

OBS STATUS

conf_status

CONF STATUS

pre_break_value

PRE BREAK VALUE

comment_obs

COMMENT OBS

embargo_date

EMBARGO DATE

obs_edp_wbb

OBS EDP WBB

time_format

TIME FORMAT

coll_period

COLL PERIOD

comment_ts

COMMENT TS

compiling_org

COMPILING ORG

currency

CURRENCY

cust_breakdown_lb

CUST BREAKDOWN LB

data_comp

DATA COMP

decimals

DECIMALS

diss_org

DISS ORG

gfs_ecofunc

GFS ECOFUNC

gfs_taxcat

GFS TAXCAT

last_update

LAST UPDATE

ref_period_detail

REF PERIOD DETAIL

ref_year_price

REF YEAR PRICE

repyearend

REPYEAREND

repyearstart

REPYEARSTART

table_identifier

TABLE IDENTIFIER

time_per_collect

TIME PER COLLECT

title

TITLE

title_compl

TITLE COMPL

unit_mult

UNIT MULT

comment_dset

COMMENT DSET

GFS.A.N.AT.W0.S13.S1.C.L.LE.GD.T._Z.XDC._T.F.V.N._TANATW0S13S1CLLEGDT_ZXDC_TFVN_T1995120650AFP1YAustria - Closing balance sheet/Positions/Stocks - Maastricht debt - Liabilities (Net Incurrence of) - maturity: All original maturities - counterpart area: World (all entities, including reference area, including IO), counterpart sector: Total economy - Consolidated, Current prices, Face value - Do…B52E Government debt (consolidated)6
GFS.A.N.AT.W0.S13.S1.C.L.LE.GD.T._Z.XDC._T.F.V.N._TANATW0S13S1CLLEGDT_ZXDC_TFVN_T1996124597AFP1YAustria - Closing balance sheet/Positions/Stocks - Maastricht debt - Liabilities (Net Incurrence of) - maturity: All original maturities - counterpart area: World (all entities, including reference area, including IO), counterpart sector: Total economy - Consolidated, Current prices, Face value - Do…B52E Government debt (consolidated)6
GFS.A.N.AT.W0.S13.S1.C.L.LE.GD.T._Z.XDC._T.F.V.N._TANATW0S13S1CLLEGDT_ZXDC_TFVN_T1997119998AFP1YAustria - Closing balance sheet/Positions/Stocks - Maastricht debt - Liabilities (Net Incurrence of) - maturity: All original maturities - counterpart area: World (all entities, including reference area, including IO), counterpart sector: Total economy - Consolidated, Current prices, Face value - Do…B52E Government debt (consolidated)6
GFS.A.N.AT.W0.S13.S1.C.L.LE.GD.T._Z.XDC._T.F.V.N._TANATW0S13S1CLLEGDT_ZXDC_TFVN_T1998125650AFP1YAustria - Closing balance sheet/Positions/Stocks - Maastricht debt - Liabilities (Net Incurrence of) - maturity: All original maturities - counterpart area: World (all entities, including reference area, including IO), counterpart sector: Total economy - Consolidated, Current prices, Face value - Do…B52E Government debt (consolidated)6
GFS.A.N.AT.W0.S13.S1.C.L.LE.GD.T._Z.XDC._T.F.V.N._TANATW0S13S1CLLEGDT_ZXDC_TFVN_T1999136216AFP1YAustria - Closing balance sheet/Positions/Stocks - Maastricht debt - Liabilities (Net Incurrence of) - maturity: All original maturities - counterpart area: World (all entities, including reference area, including IO), counterpart sector: Total economy - Consolidated, Current prices, Face value - Do…B52E Government debt (consolidated)6
GFS.A.N.AT.W0.S13.S1.C.L.LE.GD.T._Z.XDC._T.F.V.N._TANATW0S13S1CLLEGDT_ZXDC_TFVN_T2000141543AFP1YAustria - Closing balance sheet/Positions/Stocks - Maastricht debt - Liabilities (Net Incurrence of) - maturity: All original maturities - counterpart area: World (all entities, including reference area, including IO), counterpart sector: Total economy - Consolidated, Current prices, Face value - Do…B52E Government debt (consolidated)6
GFS.A.N.AT.W0.S13.S1.C.L.LE.GD.T._Z.XDC._T.F.V.N._TANATW0S13S1CLLEGDT_ZXDC_TFVN_T2001147503AFP1YAustria - Closing balance sheet/Positions/Stocks - Maastricht debt - Liabilities (Net Incurrence of) - maturity: All original maturities - counterpart area: World (all entities, including reference area, including IO), counterpart sector: Total economy - Consolidated, Current prices, Face value - Do…B52E Government debt (consolidated)6
GFS.A.N.AT.W0.S13.S1.C.L.LE.GD.T._Z.XDC._T.F.V.N._TANATW0S13S1CLLEGDT_ZXDC_TFVN_T2002151800AFP1YAustria - Closing balance sheet/Positions/Stocks - Maastricht debt - Liabilities (Net Incurrence of) - maturity: All original maturities - counterpart area: World (all entities, including reference area, including IO), counterpart sector: Total economy - Consolidated, Current prices, Face value - Do…B52E Government debt (consolidated)6
GFS.A.N.AT.W0.S13.S1.C.L.LE.GD.T._Z.XDC._T.F.V.N._TANATW0S13S1CLLEGDT_ZXDC_TFVN_T2003153107AFP1YAustria - Closing balance sheet/Positions/Stocks - Maastricht debt - Liabilities (Net Incurrence of) - maturity: All original maturities - counterpart area: World (all entities, including reference area, including IO), counterpart sector: Total economy - Consolidated, Current prices, Face value - Do…B52E Government debt (consolidated)6
GFS.A.N.AT.W0.S13.S1.C.L.LE.GD.T._Z.XDC._T.F.V.N._TANATW0S13S1CLLEGDT_ZXDC_TFVN_T2004158546AFP1YAustria - Closing balance sheet/Positions/Stocks - Maastricht debt - Liabilities (Net Incurrence of) - maturity: All original maturities - counterpart area: World (all entities, including reference area, including IO), counterpart sector: Total economy - Consolidated, Current prices, Face value - Do…B52E Government debt (consolidated)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
);

Share link

Anyone who has the link will be able to view this.