## fiscalmonitordatabaseoct2017 — Dataset overview

## Source details

**Canonical URL:** [fiscalmonitordatabaseoct2017 — Dataset overview](https://www.imf.org/-/media/files/publications/fiscal-monitor/2017/october/data/fiscalmonitordatabaseoct2017.xlsx)

## Other formats

- [Markdown version](/-/media/files/publications/fiscal-monitor/2017/october/data/fiscalmonitordatabaseoct2017.xlsx.md)
- [Structured JSON version](/-/media/files/publications/fiscal-monitor/2017/october/data/fiscalmonitordatabaseoct2017.xlsx.json)

---

### Dataset scope and structure
- Excel workbook titled "Fiscal Monitor Database Oct. 2017" with multiple worksheets containing time series and cross‑country fiscal indicators, figures, annexes, and country tables.
- Worksheet types present in the file (examples from the supplied metadata): FM Database Oct. 2017; Table of Contents; Figures (e.g., "Figure 1.1." through "Figure 1.33."); Box Figures; Annex Figures and Annex Tables (e.g., "Annex Table 1.3.1.", "Annex Table 1.4.1.", "Annex Table 1.5.1."); Regional and country tables (e.g., "Table A1." through "Table A22."); Selected financing need and structural indicator tables (e.g., "Table A23.", "Table A24.", "Table A25.", "Table A26.", "Table A27."); Definition and coverage tables (Tables B., C., D.).
- Many worksheets contain multi‑year panels (commonly 2008–22 or 2017–19) and cover advanced economies, emerging market and middle‑income economies, and low‑income developing countries.
- Fiscal variables and formats observed in the worksheets include:
  - Overall government balances and primary balances (percent of GDP).
  - Cyclically adjusted balances (percent of potential GDP).
  - Revenue, expenditure (percent of GDP).
  - Gross debt, net debt (percent of GDP).
  - Gross financing need (percent of GDP), maturing debt, budget deficit.
  - Structural fiscal indicators (e.g., Pension Spending Change, Net Present Value of Pension Spending Change, Health Care Spending Change).
  - Coverage and accounting practice flags (examples: GG, CG, SG, LG, TG, SS; Accounting Practice codes: NC, C, Other).
- Some worksheets include country‑level metadata on coverage and valuation of debt (nominal, face).

### Notable sample data points and series (preserved exactly as in the file)
- Annex Table 1.6.1. Gross Fiscal Cost and Redistributive Impacts of Universal Basic Income: All Individuals (selected rows)
  - Brazil (2013): 4.6, 0.05, 19.0386, 11.6, "R$1,286"
  - Egypt (2012): 3.5000000000000004, 0.06, 18.5549, 10.4, "LE 725"
  - France (2010): 6.800000000000001, 0.04, 9.4882, 6.3, "€2,122"
  - Mexico (2012): 3.6999999999999997, 0.06, 19.6788, 12, "Mex$4,994"
  - Poland (2013): 4.9, 0.04, 10.6995, 6.9, "Zl 2,111"
  - South Africa (2012): 2.3, 0.05, 23.6545, 10.8, "R1,584"
  - United Kingdom (2013): 6.7, 0.04, 9.283, 6, "£1,839"

- Annex Table 1.6.2. Gross Fiscal Cost and Redistributive Impacts of Universal Basic Income: Children and the Elderly (selected rows)
  - Brazil (2013): Children Only — 1.3, 0.03, 5.5 ; Children and Elderly Only — 1.7000000000000002, 0.03, 6
  - Egypt (2012): Children Only — 1.3, 0.03, 5.6 ; Children and Elderly Only — 1.5, 0.03, 6.1
  - France (2010): Children Only — 1.5, 0.01, 2.7 ; Children and Elderly Only — 2.6, 0.02, 3.4
  - Mexico (2012): Children Only — 1.3, 0.03, 6.1 ; Children and Elderly Only — 1.5, 0.03, 6.7

- Annex Table 1.6.3. Calibration of Universal Basic Income to Current Noncontributory Transfers (selected rows)
  - Brazil (2013): Fiscal Envelope (percent of GDP) — 0.7000000000000001, Annual Amount (per person) — "R$183", Coverage Bottom Two Deciles (percent) — 55.00000000000001, Top Two Deciles (percent) — 5, Share of Total Spending Bottom Two Deciles (percent) — 39, Top Two Deciles (percent) — 7.000000000000001
  - Egypt (2012): Fiscal Envelope (percent of GDP) — 0.2, Annual Amount — "LE 51", Coverage Bottom Two Deciles — 16, Top Two Deciles — 6, Share of Total Spending Bottom Two Deciles — 28.000000000000004, Top Two Deciles — 17
  - France (2010): Fiscal Envelope (percent of GDP) — 2.3, Annual Amount — "€709", Coverage Bottom Two Deciles — 66, Top Two Deciles — 19, Share of Total Spending Bottom Two Deciles — 48, Top Two Deciles — 6

- Table A1. Advanced Economies: General Government Overall Balance, 2008–22 (sample country rows and values)
  - Australia (row sample): -1.1001151287978141, -4.553556053381074, -5.100831240577079, -4.4660539277916005, -3.44369788822711, -2.7787720520409565, -2.8889255621913477, -2.790160473618994, -2.557405257492605, -2.1974576494622586, -1.8148937381918089, -0.9757740272411598, -0.058946558379374195, 0.23323150866874534, 0.29440360718307257
  - Austria (row sample): -1.5309471024600385, -5.390452582983796, -4.472585053131479, -2.5896452811016935, -2.2219534815079234, -1.3670648404907064, -2.7386404356184415, -1.0777708475533694, -1.5543405173635294, -0.8871215398590916, -0.635270205589838, -0.38288269026126204, -0.3675701797351258, -0.5706239128775772, -0.6665787337910393
  - Belgium (row sample): -1.097817920952591, -5.377299795573727, -3.991783073130649, -4.123121237859596, -4.22658064516129, -3.1187217759125523, -3.056160600004491, -2.5126387582084893, -2.6216046981584964, -1.798204991158205, -1.8085872746007874, -1.9417601004048688, -1.905645876980715, -2.0002788270439895, -1.9801733832198145

- Table A7. Advanced Economies: General Government Gross Debt, 2008–22 (sample country rows and values)
  - Australia (row sample): 11.735572694976646, 16.73935659887299, 20.470320142040084, 24.191542886002846, 27.764449312872664, 30.74844476261221, 34.20109978390429, 37.87009132769356, 40.9813698630119, 41.91538981779447, 42.34760163662556, 41.75749815872224, 40.20877897666819, 37.95113718629175, 36.048698284218396
  - Belgium (row sample): 92.52738190054961, 99.53179789036673, 99.72199397425364, 102.5958439064536, 104.32490322580645, 105.60129272383345, 106.66621756150869, 105.98518937418038, 105.97990569528382, 104.28981097297122, 102.85192468086576, 101.51279185982732, 100.15554354213798, 98.75389506406052, 97.3633023921601

- Table A23. Selected Advanced Economies: Gross Financing Need, 2017–19 (sample rows)
  - Australia: 2017 — Maturing Debt 0.2776519116240685, Budget Deficit 2.1974576494622586, Total Financing Need 2.475109561086327; 2019 — Maturing Debt 2.544160545780291, Budget Deficit 0.9757740272411598, Total Financing Need 3.519934573021451
  - Austria: 2017 — Maturing Debt 2.9572607847690917, Budget Deficit 0.8871215398590916, Total Financing Need 3.8443823246281834; 2019 — Maturing Debt 7.365685592185461, Budget Deficit 0.38288269026126204, Total Financing Need 7.748568282446723
  - Belgium: 2017 — Maturing Debt 26.1, Budget Deficit 1.798204991158205, Total Financing Need 27.898204991158206; 2019 — Maturing Debt 25.5, Budget Deficit 1.9417601004048688, Total Financing Need 27.44176010040487

- Table A25 / A26 / A27 (Structural fiscal indicators) — sample entries show:
  - Pension Spending Change, 2015–30 and Net Present Value of Pension Spending Change, 2015–50 (percent and NPV entries preserved in worksheets).
  - Examples (exact entries as in source):
    - Table A25 (Australia row): Pension Spending Change, 2015–30 — 0.753631591796875; Net Present Value of Pension Spending Change, 2015–50 — 21.68626594543457; Gross Financing Need, 2017 — 2.475109561086327; Average Term to Maturity, 2017 (years) — 7.383561643835616; Projected Interest Rate–Growth Differential, 2017–22 (percent) — -1.4479977879993844; Nonresident Holding of General Government Debt, 2017 (percent of total) — 39.45282168371873
    - Table A26 (Brazil row): Pension Spending Change, 2015–30 — 5.9367677224291135; Net Present Value of Pension Spending Change, 2015–50 — 203.8420034377802; Gross Financing Need, 2017 — 12.578327178955078; Average Term to Maturity, 2017 (years) — 6.6; Projected Interest Rate–Growth Differential, 2017–22 (percent) — 3.460977396303292; Projected Overall Balance, 2017–22 — -8.408664267653878; Nonresident Holding (percent of total) — 8.7
  - Table A27 (Low‑income country sample: Bangladesh): Pension Spending Change, 2015–30 — 0.38489294052124023; Net Present Value of Pension Spending Change, 2015–50 — 17.934328079223633; Gross financing needs, 2015 — "…"; Average Term to Maturity, 2017 (years) — 4.810958904109589; Projected Interest Rate–Growth Differential, 2017–22 (percent) — -5.605805411604866; Nonresident Holding of General Government Debt, 2017 (percent of total) — 35.61411336440038

### Data formats and precision
- Numeric values are provided with high precision in many cells (for example, 3.5000000000000004, 0.7000000000000001, 3.6999999999999997).
- Time coverage is explicit in many tables (e.g., columns labeled 2008, 2009, 2010, …, 2022; panels for 2017–19).
- Currency labels are preserved exactly where present (e.g., "R$1,286", "LE 725", "€2,122", "Mex$4,994", "Zl 2,111", "R1,584", "£1,839").

### Practical notes for users and ingestion
- The workbook contains many large worksheets (examples: "Figure 1.7." with rowCount 3207; "Box Figure 1.1.1." with rowCount 728), so automated ingestion workflows should handle large tables and mixed content (numeric, rich text, cells with "…" placeholders).
- Accounting practice and coverage flags (e.g., NC, C, Other) and coverage codes (GG, CG, SG, LG, TG, SS) are present and should be mapped consistently when harmonizing across country groups.
- Several cells use richText fragments for labels and superscripts; ingestion should extract plain text while preserving superscripted footnote markers if needed.
- Missing or placeholder entries (e.g., "…", "...") appear in some time series and should be handled as missing values during analysis.

*Source: fiscalmonitordatabaseoct2017 (worksheet and sample cell values extracted from the supplied dataset).*

---


_Source: https://www.imf.org/-/media/files/publications/fiscal-monitor/2017/october/data/fiscalmonitordatabaseoct2017.xlsx_