login
Holden Web
What you'll need to know tomorrow

wales: the JSON

← wales

Exactly what edjas wales.xlsx wales.toml writes to standard output, from the unmodified workbook. Run at build time, not stored, so this is the current output of the current code.

{
  "title": "Local authority revenue and capital outturn expenditure: 2024-25",
  "subtitle": "Table 1: Revenue expenditure and financing [Note 1]",
  "contact": "stats.finance@gov.wales",
  "contents": [
    {
      "Worksheet name": "Table 1",
      "Worksheet title": "Table 1: Revenue expenditure and financing [Note 1]"
    },
    {
      "Worksheet name": "Table 2",
      "Worksheet title": "Table 2: Revenue expenditure by local authority [Note 1]"
    },
    {
      "Worksheet name": "Table 3",
      "Worksheet title": "Table 3: Capital expenditure by service"
    },
    {
      "Worksheet name": "Table 4",
      "Worksheet title": "Table 4: Capital receipts by service"
    },
    {
      "Worksheet name": "Table 5",
      "Worksheet title": "Table 5: Capital expenditure financing"
    },
    {
      "Worksheet name": "Table 6",
      "Worksheet title": "Table 6: Capital expenditure by authority and service, 2024-25"
    },
    {
      "Worksheet name": "Table 7",
      "Worksheet title": "Table 7: Capital expenditure and receipts, by detailed service, 2024-25"
    }
  ],
  "header": [
    "County and county borough council expenditure",
    "2023-24",
    "2024-25",
    "Change",
    "Percentage change ",
    "2024-25 £ per head [Note 2]"
  ],
  "rows": [
    [
      "  Education",
      3596313.7505437587,
      3907361.7793404893,
      311048.02879673056,
      8.649079317667999,
      1226.1925177299713
    ],
    [
      "  Social services",
      2847243.7440625327,
      3024548.911131456,
      177305.16706892336,
      6.227256357614787,
      949.1517432418809
    ],
    [
      "  Housing [Note 3]",
      987618.531373982,
      986468.4326674007,
      -1150.0987065812806,
      -0.11645171390022979,
      309.5695457505711
    ],
    [
      "  Local environmental services [Note 4]",
      514664.73376391066,
      523590.421435381,
      8925.68767147034,
      1.7342722525776888,
      164.3110347533551
    ],
    [
      "  Roads and transport",
      296218.6874289398,
      321071.03094398294,
      24852.343515043147,
      8.389863492661988,
      100.75721625905099
    ],
    [
      "  Libraries, culture, heritage, sport and recreation",
      258772.55995458146,
      252251.51607690996,
      -6521.043877671502,
      -2.5199904807588736,
      79.16055360805514
    ],
    [
      "  Planning, economic and community development",
      178025.27566937203,
      277506.5025675112,
      99481.2268981392,
      55.88039480578894,
      87.08597163151077
    ],
    [
      "  Council tax administration",
      52120.00709162084,
      63458.15467867202,
      11338.147587051179,
      21.75392564149128,
      19.91418221556961
    ],
    [
      "  Debt financing: counties",
      308354.16307999997,
      340760.5673176819,
      32406.40423768194,
      10.509475180743502,
      106.93610716868076
    ],
    [
      "  Central administration and other revenue: counties [Note 5] [Note 6]",
      407281.8097531421,
      377104.55786901544,
      -30177.251884126686,
      -7.4094278608753585,
      118.3414317316947
    ],
    [
      "All county and county borough council expenditure",
      9446613.26272184,
      10074121.874028498,
      627508.611306658,
      6.642683402557911,
      3161.42030409034
    ],
    [
      "Police [Note 6]",
      983964.3008799999,
      1048199.4555499998,
      64235.15466999996,
      6.5281997133993395,
      328.9417264303025
    ],
    [
      "Fire [Note 6]",
      200281.8345599999,
      210427.2133199997,
      10145.378759999789,
      5.065551143112015,
      66.0354195672414
    ],
    [
      "National parks [Note 6]",
      20092.922000000002,
      20405.09236,
      312.17035999999644,
      1.5536334635649132,
      6.403443803876317
    ],
    [
      "Gross revenue expenditure",
      10650952.32016184,
      11353153.635258498,
      702201.3150966577,
      6.592850047478081,
      3562.80089389176
    ],
    [
      "less specific and special government grants [Note 7]",
      2461198.0066799996,
      2857122.232809,
      395924.22612900054,
      16.08664662714713,
      896.6105781742251
    ],
    [
      "Net revenue expenditure",
      8189754.31348184,
      8496031.402449498,
      306277.08896765765,
      3.7397591825614267,
      2666.190315717535
    ],
    [
      "Putting to (+) / drawing from (-) reserves [Note 8]",
      -146794.36478727468,
      -20686.263013559557,
      126108.10177371513,
      -85.90799923175743,
      -6.491679644597001
    ],
    [
      "Council tax reduction scheme",
      278175.35224782396,
      292607.87011843204,
      14432.517870608077,
      5.188280612924425,
      91.82502190229341
    ],
    [
      "Budget requirement [Note 6]",
      8321135.300942389,
      8767953.00955437,
      446817.7086119801,
      5.369672435940044,
      2751.523657975231
    ],
    [
      "plus discretionary non-domestic rate relief",
      4764.3433,
      4587.704,
      -176.63930000000073,
      -3.707526701528849,
      1.4396947700372278
    ],
    [
      "less revenue support grant",
      4611358.655,
      4694994.063999999,
      83635.40899999905,
      1.8136825880874592,
      1473.3641052902778
    ],
    [
      "less police grant",
      319674.29,
      345515.387,
      25841.09700000001,
      8.08357062433767,
      108.42824550827359
    ],
    [
      "less redistributed non-domestic rates income",
      1022000.0125793448,
      1139000.0000099998,
      116999.98743065505,
      11.448139529408426,
      357.43638715287636
    ],
    [
      "Council tax requirement",
      2372866.686663044,
      2593031.2625443703,
      220164.5758813261,
      9.278421628942962,
      813.7346147938403
    ],
    [
      "of which: ",
      null,
      null,
      null,
      null,
      null
    ],
    [
      "  paid by council tax reduction scheme",
      278175.35224782396,
      292607.87011843204,
      14432.517870608077,
      5.188280612924425,
      91.82502190229341
    ],
    [
      "  paid directly by council tax payers",
      2094691.3344152202,
      2300423.392425938,
      205732.05801071785,
      9.821593025692854,
      721.9095928915468
    ]
  ]
}

The example page has the specification that produced this, and the report rendered from it.