login
Holden Web
What you'll need to know tomorrow

cra: the JSON

← cra

Exactly what edjas cra.xlsx cra.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": "Table B.1 Total identifiable expenditure on services in England by sub-function (1), 2019-20 to 2023-24",
  "unit": "£ million",
  "header": [
    null,
    "2019-20\noutturn",
    "2020-21\noutturn",
    "2021-22\noutturn",
    "2022-23\noutturn",
    "2023-24\noutturn"
  ],
  "rows": [
    [
      "1. General public services",
      null,
      null,
      null,
      null,
      null
    ],
    [
      "1.1 Executive and legislative organs, financial and fiscal affairs, external affairs",
      2454,
      2553,
      2595,
      2784,
      2836
    ],
    [
      "1.2 Foreign economic aid",
      "-",
      "-",
      "-",
      "-",
      "-"
    ],
    [
      "1.3 General services",
      1038,
      1930,
      1776,
      1653,
      1829
    ],
    [
      "1.4 Basic research",
      "-",
      "-",
      "-",
      "-",
      "-"
    ],
    [
      "1.5 R&D general public services",
      5,
      4,
      6,
      10,
      14
    ],
    [
      "1.6 General public services n.e.c.",
      2383,
      3470,
      3364,
      2752,
      3072
    ],
    [
      "Total general public services",
      5880,
      7958,
      7741,
      7198,
      7751
    ],
    [
      "2. Defence",
      null,
      null,
      null,
      null,
      null
    ],
    [
      "2.1 Military defence",
      "-",
      "-",
      "-",
      "-",
      "-"
    ],
    [
      "2.2 Civil defence",
      48,
      134,
      119,
      80,
      69
    ],
    [
      "2.3 Foreign miltary aid",
      "-",
      "-",
      "-",
      "-",
      "-"
    ],
    [
      "2.4 R&D defence",
      "-",
      "-",
      "-",
      "-",
      "-"
    ],
    [
      "2.5 Defence n.e.c.",
      "-",
      "-",
      "-",
      "-",
      "-"
    ],
    [
      "Total defence",
      48,
      134,
      119,
      80,
      69
    ],
    [
      "3. Public order and safety",
      null,
      null,
      null,
      null,
      null
    ],
    [
      "3.1 Police services",
      13879,
      14694,
      16030,
      16968,
      18205
    ],
    [
      " of which: immigration and citizenship ",
      "-",
      "-",
      8,
      20,
      18
    ],
    [
      " of which: other police services ",
      13879,
      14694,
      16022,
      16948,
      18187
    ],
    [
      "3.2 Fire-protection services",
      2316,
      2333,
      2422,
      2633,
      2879
    ],
    [
      "3.3 Law courts",
      5839,
      5869,
      6662,
      6783,
      7304
    ],
    [
      "3.4 Prisons",
      3629,
      4665,
      4499,
      5149,
      5837
    ],
    [
      "3.5 R&D public order and safety",
      "-",
      "-",
      "-",
      "-",
      "-"
    ],
    [
      "3.6 Public order and safety n.e.c.",
      1041,
      1541,
      660,
      949,
      939
    ],
    [
      "Total public order and safety",
      26703,
      29103,
      30273,
      32482,
      35164
    ],
    [
      "4. Economic affairs",
      null,
      null,
      null,
      null,
      null
    ],
    [
      "4.1 General economic, commercial and labour affairs",
      11736,
      118044,
      32041,
      18033,
      15441
    ],
    [
      "4.2 Agriculture, forestry, fishing and hunting",
      3808,
      4183,
      3900,
      4093,
      4972
    ],
    [
      " of which: market support",
      1976,
      2010,
      1873,
      1844,
      2907
    ],
    [
      " of which: other agriculture, food and fisheries policy",
      1790,
      2108,
      1954,
      2144,
      1893
    ],
    [
      " of which: forestry",
      42,
      64,
      73,
      105,
      172
    ],
    [
      "4.3 Fuel and energy",
      910,
      937,
      1363,
      35837,
      6042
    ],
    [
      "4.4 Mining, manufacturing and construction",
      2372,
      1079,
      951,
      636,
      405
    ],
    [
      "4.5 Transport",
      27378,
      41430,
      36861,
      37165,
      39980
    ],
    [
      " of which: national roads",
      4689,
      5041,
      4316,
      4695,
      5112
    ],
    [
      " of which: local roads",
      4242,
      5423,
      4415,
      4566,
      5391
    ],
    [
      " of which: local public transport",
      1982,
      6517,
      4325,
      3495,
      3817
    ],
    [
      " of which: railway",
      15418,
      23378,
      22458,
      23509,
      24908
    ],
    [
      " of which: other transport",
      1047,
      1071,
      1347,
      900,
      751
    ],
    [
      "4.6 Communication",
      114,
      111,
      139,
      125,
      249
    ],
    [
      "4.7 Other industries",
      107,
      97,
      106,
      136,
      101
    ],
    [
      "4.8 R&D economic affairs",
      5345,
      5645,
      5591,
      6061,
      7843
    ],
    [
      "4.9 Economic affairs n.e.c.",
      405,
      473,
      477,
      510,
      624
    ],
    [
      "Total economic affairs",
      52175,
      171999,
      81428,
      102596,
      75657
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Table B.1 Total identifiable expenditure on services in England by sub-function (1), 2019-20 to 2023-24 (continued)",
      null,
      null,
      null,
      null,
      null
    ],
    [
      null,
      null,
      null,
      null,
      null,
      "£ million"
    ],
    [
      null,
      "National Statistics",
      null,
      null,
      null,
      null
    ],
    [
      null,
      "2019-20\noutturn",
      "2020-21\noutturn",
      "2021-22\noutturn",
      "2022-23\noutturn",
      "2023-24\noutturn"
    ],
    [
      "5. Environment protection",
      null,
      null,
      null,
      null,
      null
    ],
    [
      "5.1 Waste management",
      6999,
      7454,
      7768,
      8387,
      9038
    ],
    [
      "5.2 Waste water management",
      "-",
      "-",
      "-",
      "-",
      "-"
    ],
    [
      "5.3 Pollution abatement",
      157,
      259,
      725,
      396,
      612
    ],
    [
      "5.4 Protection of biodiversity and landscape",
      200,
      243,
      296,
      356,
      433
    ],
    [
      "5.5 R&D environment protection",
      144,
      154,
      144,
      266,
      333
    ],
    [
      "5.6 Environment protection n.e.c.",
      1579,
      1860,
      1938,
      2060,
      2339
    ],
    [
      "Total environment protection",
      9079,
      9971,
      10871,
      11465,
      12755
    ],
    [
      "6. Housing and community amenities",
      null,
      null,
      null,
      null,
      null
    ],
    [
      "6.1 Housing development",
      6164,
      5727,
      6606,
      8160,
      10776
    ],
    [
      " of which: local authority housing",
      4611,
      4494,
      5482,
      6837,
      8728
    ],
    [
      " of which: other social housing",
      1553,
      1233,
      1124,
      1323,
      2048
    ],
    [
      "6.2 Community development",
      3007,
      3072,
      3023,
      3083,
      3705
    ],
    [
      "6.3 Water supply",
      7,
      6,
      7,
      8,
      8
    ],
    [
      "6.4 Street lighting",
      674,
      677,
      724,
      846,
      918
    ],
    [
      "6.5 R&D housing and community amenities",
      "-",
      "-",
      "-",
      "-",
      "-"
    ],
    [
      "6.6 Housing and community amenities n.e.c.",
      220,
      200,
      280,
      203,
      343
    ],
    [
      "Total housing and community amenities",
      10073,
      9681,
      10641,
      12300,
      15750
    ],
    [
      "7. Health (2)",
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Medical services",
      132503,
      155356,
      160451,
      165401,
      182260
    ],
    [
      "Health research",
      1366,
      1422,
      1521,
      1441,
      1537
    ],
    [
      "Central and other health services",
      2813,
      26154,
      17247,
      8916,
      3312
    ],
    [
      "Total health",
      136682,
      182932,
      179219,
      175758,
      187109
    ],
    [
      "8. Recreation, culture and religion",
      null,
      null,
      null,
      null,
      null
    ],
    [
      "8.1 Recreational and sporting services",
      2166,
      2593,
      3008,
      3050,
      2744
    ],
    [
      "8.2 Cultural services",
      3084,
      3993,
      3351,
      3501,
      3482
    ],
    [
      "8.3 Broadcasting and publishing services",
      188,
      188,
      187,
      270,
      242
    ],
    [
      "8.4 Religious and other community services",
      17,
      8,
      17,
      131,
      128
    ],
    [
      "8.5 R&D recreation, culture and religion",
      77,
      103,
      61,
      55,
      54
    ],
    [
      "8.6 Recreation, culture and religion n.e.c.",
      58,
      57,
      22,
      104,
      108
    ],
    [
      "Total recreation, culture and religion",
      5589,
      6942,
      6646,
      7111,
      6758
    ],
    [
      "9. Education",
      null,
      null,
      null,
      null,
      null
    ],
    [
      "9.1 Pre-primary and primary education",
      24616,
      24980,
      25791,
      27230,
      29168
    ],
    [
      " of which: under fives",
      3393,
      3599,
      3478,
      3638,
      3944
    ],
    [
      " of which: primary education",
      21223,
      21381,
      22313,
      23592,
      25223
    ],
    [
      "9.2 Secondary education (3)",
      38730,
      40642,
      43485,
      46960,
      47451
    ],
    [
      "9.3 Post-secondary non-tertiary education",
      529,
      571,
      634,
      730,
      855
    ],
    [
      "9.4 Tertiary education",
      2272,
      2368,
      2433,
      2502,
      5156
    ],
    [
      "9.5 Education not definable by level",
      634,
      757,
      594,
      915,
      789
    ],
    [
      "9.6 Subsidiary services to education",
      3438,
      3729,
      4147,
      4780,
      5539
    ],
    [
      "9.7 R&D education",
      2323,
      2698,
      2608,
      2972,
      2754
    ],
    [
      "9.8 Education n.e.c.",
      1546,
      1395,
      1573,
      2028,
      1791
    ],
    [
      "Total education",
      74088,
      77139,
      81264,
      88118,
      93503
    ],
    [
      null,
      null,
      null,
      null,
      null,
      null
    ],
    [
      "Table B.1 Total identifiable expenditure on services in England by sub-function (1), 2019-20 to 2023-234 (continued)",
      null,
      null,
      null,
      null,
      null
    ],
    [
      null,
      null,
      null,
      null,
      null,
      "£ million"
    ],
    [
      null,
      "National Statistics",
      null,
      null,
      null,
      null
    ],
    [
      null,
      "2019-20\noutturn",
      "2020-21\noutturn",
      "2021-22\noutturn",
      "2022-23\noutturn",
      "2023-24\noutturn"
    ],
    [
      "10. Social protection",
      null,
      null,
      null,
      null,
      null
    ],
    [
      " of which: personal social services",
      28899,
      31546,
      32518,
      35672,
      40674
    ],
    [
      "10.1 Sickness and disability",
      45416,
      47750,
      48286,
      51445,
      59399
    ],
    [
      " of which: personal social services",
      9179,
      10308,
      10368,
      10992,
      12458
    ],
    [
      " of which: incapacity, disability and injury benefits",
      36238,
      37442,
      37918,
      40453,
      46941
    ],
    [
      "10.2 Old age",
      98297,
      99483,
      101458,
      108577,
      123589
    ],
    [
      " of which: personal social services",
      8835,
      9470,
      9592,
      10282,
      11669
    ],
    [
      " of which: pensions",
      89462,
      90013,
      91866,
      98295,
      111920
    ],
    [
      "10.3 Survivors ",
      788,
      787,
      809,
      925,
      926
    ],
    [
      "10.4  Family and children",
      21457,
      21810,
      22450,
      24093,
      26629
    ],
    [
      " of which: personal social services",
      9889,
      10526,
      11248,
      12764,
      14424
    ],
    [
      " of which: family benefits, income support and tax credits",
      11568,
      11284,
      11202,
      11329,
      12205
    ],
    [
      "10.5 Unemployment",
      980,
      1298,
      659,
      506,
      685
    ],
    [
      " of which: personal social services",
      "-",
      "-",
      "-",
      "-",
      "-"
    ],
    [
      " of which: other unemployment benefits",
      980,
      1298,
      659,
      506,
      685
    ],
    [
      "10.6 Housing",
      16781,
      15902,
      14804,
      17415,
      14323
    ],
    [
      "10.7 Social exclusion n.e.c.",
      34910,
      50542,
      48749,
      50254,
      57847
    ],
    [
      " of which: personal social services",
      996,
      1242,
      1310,
      1634,
      2123
    ],
    [
      " of which: family benefits, income support and tax credits",
      33913,
      49300,
      47438,
      48619,
      55724
    ],
    [
      "10.8 R&D social protection",
      "-",
      "-",
      "-",
      "-",
      "-"
    ],
    [
      "10.9 Social protection n.e.c.",
      3652,
      4180,
      4455,
      8911,
      10446
    ],
    [
      "Total social protection",
      222282,
      241751,
      241671,
      262125,
      293844
    ],
    [
      "Total Expenditure on Services in England",
      542600,
      737609,
      649873,
      699233,
      728359
    ]
  ]
}

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