login
Holden Web
What you'll need to know tomorrow

slgfs: the JSON

← slgfs

Exactly what edjas slgfs.xlsx slgfs.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": "Net Revenue Expenditure in 2024-25 by Subservice, £ thousands",
  "region": "Scotland",
  "header": [
    "Subservice",
    "Gross Service Expenditure - adjusted for LFR Purposes",
    "Gross Service Income - adjusted for LFR Purposes",
    "Net Revenue Expenditure"
  ],
  "rows": [
    [
      "Pre-Primary Education",
      1118181,
      45033,
      1073148
    ],
    [
      "Primary Education",
      2985657,
      177444,
      2808213
    ],
    [
      "Secondary Education",
      3035041,
      194191,
      2840850
    ],
    [
      "Special Education",
      957637,
      29212,
      928425
    ],
    [
      "Community Learning",
      131604,
      23637,
      107967
    ],
    [
      "Other Non-School Funding",
      27099,
      7706,
      19393
    ],
    [
      "Total Education",
      8255219,
      477223,
      7777996
    ],
    [
      "Museums and Galleries",
      56858,
      4175,
      52683
    ],
    [
      "Other Culture and Heritage",
      82099,
      15992,
      66107
    ],
    [
      "Library Service",
      113330,
      2944,
      110386
    ],
    [
      "Promotional Events",
      15044,
      4854,
      10190
    ],
    [
      "Other Tourism",
      14234,
      3907,
      10327
    ],
    [
      "Countryside Recreation and Management",
      30448,
      6356,
      24092
    ],
    [
      "Sport Facilities",
      234466,
      54726,
      179740
    ],
    [
      "Community Parks and Open Spaces",
      157549,
      27749,
      129800
    ],
    [
      "Other Recreation and Sport",
      85344,
      17927,
      67417
    ],
    [
      "Total Culture and Related Services",
      789372,
      138630,
      650742
    ],
    [
      "Service Strategy",
      71120,
      58164,
      12956
    ],
    [
      "Children's Hearings",
      732,
      222,
      510
    ],
    [
      "Children and Families",
      1210053,
      406664,
      803389
    ],
    [
      "Adult Social Care",
      4909617,
      4735415,
      174202
    ],
    [
      "Criminal Justice Social Work Services",
      164245,
      157171,
      7074
    ],
    [
      "Integration Joint Boards (IJBs)",
      3874998,
      0,
      3874998
    ],
    [
      "Total Social Work",
      10230765,
      5357636,
      4873129
    ],
    [
      "Roads: Construction",
      21467,
      18000,
      3467
    ],
    [
      "Roads: Winter Maintenance",
      82517,
      4439,
      78078
    ],
    [
      "Roads: Other Maintenance",
      270862,
      100415,
      170447
    ],
    [
      "Roads: Lighting",
      84050,
      3761,
      80289
    ],
    [
      "Network & Traffic Management: School Crossing Patrols",
      11522,
      11,
      11511
    ],
    [
      "Network & Traffic Management: Other",
      68561,
      31143,
      37418
    ],
    [
      "Parking Services",
      66650,
      136118,
      -69468
    ],
    [
      "Non-LA Public Transport: Concessionary Fares",
      7430,
      862,
      6568
    ],
    [
      "Non-LA Public Transport: Support to Operators & Voluntary Groups",
      115421,
      7716,
      107705
    ],
    [
      "Non-LA Public Transport: Co-ordination",
      84109,
      73367,
      10742
    ],
    [
      "LA Transport Undertakings",
      51117,
      49369,
      1748
    ],
    [
      "Road Bridges",
      2244,
      0,
      2244
    ],
    [
      "Total Roads and Transport",
      865950,
      425201,
      440749
    ],
    [
      "Cemetery, Cremation and Mortuary Services",
      54575,
      49754,
      4821
    ],
    [
      "Coast Protection",
      1673,
      1350,
      323
    ],
    [
      "Flood Defence and Land Drainage",
      14104,
      4066,
      10038
    ],
    [
      "Environmental Health",
      87708,
      15734,
      71974
    ],
    [
      "Trading Standards",
      42418,
      4827,
      37591
    ],
    [
      "Waste Management: Waste Collection",
      297799,
      61337,
      236462
    ],
    [
      "Waste Management: Waste Disposal",
      368099,
      60287,
      307812
    ],
    [
      "Waste Management: Other",
      133228,
      4084,
      129144
    ],
    [
      "Total Environmental Services",
      999604,
      201439,
      798165
    ],
    [
      "Building Standards",
      42330,
      43558,
      -1228
    ],
    [
      "Planning: Development Management",
      53890,
      47277,
      6613
    ],
    [
      "Planning: Planning Policy",
      36703,
      5072,
      31631
    ],
    [
      "Planning: Environmental Initiatives",
      31558,
      14596,
      16962
    ],
    [
      "Economic Development",
      546714,
      392646,
      154068
    ],
    [
      "Total Building, Planning & Development",
      711195,
      503149,
      208046
    ],
    [
      "Council Tax Collection",
      51562,
      38576,
      12986
    ],
    [
      "Council Tax Reduction Administration",
      29744.92,
      7080,
      22664.92
    ],
    [
      "Non-Domestic Rates Collection",
      21427,
      6688,
      14739
    ],
    [
      "Housing Benefit Administration",
      30591.08,
      14029,
      16562.08
    ],
    [
      "Registration of Births, Deaths and Marriages",
      15635,
      11274,
      4361
    ],
    [
      "Emergency Planning",
      4639,
      234,
      4405
    ],
    [
      "Licensing",
      20761,
      28920,
      -8159
    ],
    [
      "Conducting Elections",
      11983,
      6917,
      5066
    ],
    [
      "Registration of Electors",
      10654.3,
      1106,
      9548.3
    ],
    [
      "Council Tax Valuation",
      15356.73,
      605,
      14751.73
    ],
    [
      "Non-Domestic Lands Valuation",
      19310.97,
      532,
      18778.97
    ],
    [
      "Local Land Charges",
      35,
      1,
      34
    ],
    [
      "Non-Road Lighting",
      10273,
      4970,
      5303
    ],
    [
      "General Grants, Bequests and Donations",
      8366,
      1913,
      6453
    ],
    [
      "Corporate and Democratic Core Costs",
      143094,
      5706,
      137388
    ],
    [
      "Non-Distributed Costs",
      84643,
      10849,
      73794
    ],
    [
      "Other",
      270562,
      208673,
      61889
    ],
    [
      "Total Central Services",
      748638,
      348073,
      400565
    ],
    [
      "Private Sector Housing Renewal",
      82403,
      55875,
      26528
    ],
    [
      "Housing Benefits: Rent Allowances",
      748666,
      686531,
      62135
    ],
    [
      "Housing Benefits: Rent Rebate",
      532831,
      502553,
      30278
    ],
    [
      "Homelessness",
      409398,
      343386,
      66012
    ],
    [
      "Welfare Services",
      13334,
      1327,
      12007
    ],
    [
      "Administration of Housing Advances",
      30,
      32,
      -2
    ],
    [
      "Housing Support Services (Supporting People)",
      85471,
      21118,
      64353
    ],
    [
      "Other Non-HRA housing (exc. Admin of Housing Benefits)",
      281102,
      214509,
      66593
    ],
    [
      "Total Non-HRA Housing",
      2153235,
      1825331,
      327904
    ],
    [
      "Trading Services",
      75225,
      127434,
      -52209
    ],
    [
      "Total General Fund (GF)",
      24829203,
      9404116,
      15425087
    ],
    [
      "Housing Revenue Account (HRA)",
      1022670,
      1561007,
      -538337
    ],
    [
      "All Services (GF + HRA)",
      25851873,
      10965123,
      14886750
    ]
  ]
}

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