Appendix D — Data codes for retrieval

Table D.1: ECB’s SDW codes for data retrieval (fiscal series)
Name Retrieval code
Total revenue GFS.Q.N.*.W0.S13.S1.P.C.OTR._Z._Z._Z.XDC._Z.S.V.N._T
Current taxes on income, wealth, etc. (Direct taxes) GFS.Q.N.*.W0.S13.S1.N.C.D5._Z._Z._Z.XDC._Z.S.V.N._T
Taxes on production and imports (Indirect taxes) GFS.Q.N.*.W0.S13.S1.N.C.D2._Z._Z._Z.XDC._Z.S.V.N._T
Net social contributions (Social contributions) GFS.Q.N.*.W0.S13.S1.N.C.D61._Z._Z._Z.XDC._Z.S.V.N._T
Other current revenue = Market output, output for own final use and payments for other non-market output + Other subsidies on production + Property income + Other current transfers GFS.Q.N.*.W0.S13.S1.N.C.P1O._Z._Z._Z.XDC._Z.S.V.N._T + GFS.Q.N.*.W0.S13.S1.N.C.D39._Z._Z._Z.XDC._Z.S.V.N._T + GFS.Q.N.*.W0.S13.S1.P.C.D4._Z._Z._Z.XDC._Z.S.V.N._T + GFS.Q.N.*.W0.S13.S1.P.C.D7._Z._Z._Z.XDC._Z.S.V.N._T
Capital transfers (Capital revenue) GFS.Q.N.*.W0.S13.S1.P.C.D9._Z._Z._Z.XDC._Z.S.V.N._T
Total expenditure GFS.Q.N.*.W0.S13.S1.P.D.OTE._Z._Z._T.XDC._Z.S.V.N._T
Social benefits other than social transfers in kind (Social transfers) GFS.Q.N.*.W0.S13.S1.N.D.D62._Z._Z._T.XDC._Z.S.V.N._T
Purchases = Social transfers in kind - purchased market production + Intermediate consumption GFS.Q.N.*.W0.S13.S1.N.D.D632._Z._Z._T.XDC._Z.S.V.N._T + GFS.Q.N.*.W0.S13.S1.N.D.P2._Z._Z._T.XDC._Z.S.V.N._T
Interest (Interest payments) GFS.Q.N.*.W0.S13.S1.C.D.D41._Z._Z._T.XDC._Z.S.V.N._T
Compensation of employees (Gov. compensation) GFS.Q.N.*.W0.S13.S1.N.D.D1._Z._Z._T.XDC._Z.S.V.N._T
Other current expenditure = Property income other than interest + Other taxes on production + Current taxes on income, wealth, etc. + Other current transfers + Adjustment for the change in pension entitlements GFS.Q.N.*.W0.S13.S1.N.D.D4N._Z._Z._T.XDC._Z.S.V.N._T + GFS.Q.N.*.W0.S13.S1.N.D.D29._Z._Z._T.XDC._Z.S.V.N._T + GFS.Q.N.*.W0.S13.S1.N.D.D5._Z._Z._T.XDC._Z.S.V.N._T + GFS.Q.N.*.W0.S13.S1.P.D.D7._Z._Z._T.XDC._Z.S.V.N._T + GFS.Q.N.*.W0.S13.S1.N.D.D8._Z._Z._T.XDC._Z.S.V.N._T
Gross fixed capital formation (Gov. investment) GFS.Q.N.*.W0.S13.S1.N.D.P51G._Z._Z._T.XDC._Z.S.V.N._T
Other capital expenditure = Changes in inventories and acquisition less disposals of valuables + Acquisitions less disposals of non-produced assets + Capital transfers GFS.Q.N.*.W0.S13.S1.N.D.P5M._Z._Z._T.XDC._Z.S.V.N._T + GFS.Q.N.*.W0.S13.S1.N.D.NP._Z._Z._T.XDC._Z.S.V.N._T + GFS.Q.N.*.W0.S13.S1.C.D.D9._Z._Z._T.XDC._Z.S.V.N._T
Note: The items in brown are not explicitly considered in our analysis.
Table D.2: ECB’s SDW codes for data retrieval (macro series)
Name Retrieval code
GDP MNA.Q.N.*.W2.S1.S1.B.B1GQ._Z._Z._Z.EUR.V.N
Private consumption MNA.Q.N.*.W0.S1M.S1.D.P31._Z._Z._T.EUR.V.N
Total investment MNA.Q.N.*.W0.S1.S1.D.P5.N1G._T._Z.EUR.V.N
Exports MNA.Q.N.*.W1.S1.S1.D.P6._Z._Z._Z.EUR.V.N
Gov. consumption MNA.Q.N.*.W0.S13.S1.D.P3._Z._Z._T.EUR.V.N
Compensation of employees MNA.Q.N.*.W2.S1.S1.D.D1._Z._T._Z.EUR.V.N