Summary of currently loaded spend data for: Ministry of Justice

Lastfile: MOJ_201904
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
HMPPS_201901.csv 174,957,600.46 483 0 362,231.06 6,703,075.26 2019-01-02 2019-01-31 29    
HMPPS_201902.csv 175,941,817.39 474 0 371,185.27 7,455,137.16 2019-02-01 2019-02-28 27    
HMPPS_201903.csv 215,491,554.28 626 0 344,235.71 6,969,489.00 2019-03-01 2019-03-29 28    
HMPPS_201904.csv 179,447,880.52 514 0 349,120.39 8,914,027.43 2019-04-01 2019-04-30 29    
HMPPS_201905.csv 171,899,147.60 436 0 394,264.10 7,300,003.20 2019-05-01 2019-05-31 30    
MOJ_201101.csv 289,560,734.15 417 0 694,390.25 83,900,000.00 2011-01-04 2011-01-31 27    
MOJ_201102.csv 378,245,717.75 547 0 691,491.26 81,200,000.00 2011-02-01 2011-02-28 27    
MOJ_201103.csv 428,603,933.54 871 0 492,082.59 76,800,000.00 2011-03-01 2011-03-31 30    
MOJ_201104.csv 286,044,759.64 789 0 362,540.89 75,000,000.00 2011-04-01 2011-04-28 27    
MOJ_201105.csv 295,851,078.02 504 0 587,006.11 69,000,000.00 2011-05-03 2011-05-31 28    
MOJ_201106.csv 365,379,006.06 725 0 503,971.04 78,000,000.00 2011-06-01 2011-06-30 29    
MOJ_201107.csv 306,331,071.88 554 0 552,944.17 71,000,000.00 2011-07-01 2011-07-29 28    
MOJ_201108.csv 149,809,302.96 732 0 204,657.52 22,225,959.35 2011-08-01 2011-08-31 30    
MOJ_201109.csv 276,911,528.45 869 0 318,655.38 49,206,000.00 2011-09-01 2011-09-30 29    
MOJ_201110.csv 314,647,684.05 1419 0 221,739.03 43,010,000.00 2011-10-03 2011-10-31 28    
MOJ_201111.csv 317,324,340.01 1170 0 271,217.38 45,708,000.00 2011-11-01 2011-11-30 29    
MOJ_201112.csv 368,908,999.84 844 0 437,095.97 45,110,000.00 2011-12-01 2011-12-29 28    
MOJ_201201.csv 310,029,263.55 508 0 610,293.83 44,400,000.00 2012-01-03 2012-01-31 28    
MOJ_201202.csv 361,091,472.55 587 0 615,147.31 53,801,000.00 2012-02-01 2012-02-29 28    
MOJ_201203.csv 340,268,659.64 725 0 469,336.08 46,014,000.00 2012-03-01 2012-03-30 29    
MOJ_201204.csv 267,004,180.94 756 0 353,180.13 48,509,000.00 2012-04-02 2012-04-30 28    
MOJ_201205.csv 260,769,052.85 396 0 658,507.71 50,265,000.00 2012-05-01 2012-05-31 30    
MOJ_201206.csv 266,615,728.16 558 0 477,805.96 40,915,000.00 2012-06-01 2012-06-29 28    
MOJ_201207.csv 243,625,152.43 480 0 507,552.40 46,294,000.00 2012-07-02 2012-07-31 29    
MOJ_201208.csv 282,488,977.39 446 0 633,383.36 44,209,000.00 2012-08-01 2012-08-31 30    
MOJ_201209.csv 241,113,722.31 528 0 456,654.78 39,415,000.00 2012-09-03 2012-09-28 25    
MOJ_201210.csv 308,367,591.01 460 0 670,364.33 42,398,000.00 2012-10-01 2012-10-31 30    
MOJ_201211.csv 90,066,440.79 333 0 270,469.79 15,150,000.00 2012-11-01 2012-11-30 29     Drop in TotalAmt.
MOJ_201212.csv 125,628,113.07 367 0 342,310.93 15,000,000.00 2012-12-03 2012-12-31 28    
MOJ_201301.csv 115,191,248.66 212 0 543,354.95 35,500,000.00 2013-01-01 2013-01-31 30    
MOJ_201302.csv 311,257,186.71 547 0 569,025.94 49,000,000.00 2013-02-01 2013-02-28 27     Jump in TotalAmt.
MOJ_201303.csv 405,575,011.87 821 0 494,001.23 70,764,000.00 2013-03-01 2013-03-28 27    
MOJ_201304.csv 375,908,406.09 2210 0 170,094.30 43,878,000.00 2013-02-04 2013-12-04 303    
MOJ_201305.csv 299,937,491.96 838 0 357,920.63 42,800,000.00 2013-01-05 2013-10-05 273     Jump in AvgAmt
MOJ_201306.csv 351,420,025.64 1697 0 207,083.10 44,613,000.00 2013-06-03 2013-06-28 25    
MOJ_201307.csv 337,461,855.52 2026 0 166,565.58 43,839,000.00 2013-01-07 2013-10-07 273    
MOJ_201308.csv 140,260,453.74 1416 0 99,053.99 15,000,000.00 2013-05-08 2013-09-08 123    
MOJ_201309.csv 250,155,067.51 231 0 1,082,922.37 43,077,000.00 2013-09-02 2013-09-30 28     Jump in AvgAmt
MOJ_201310.csv 219,516,256.20 596 0 368,315.87 39,803,000.00 2013-10-01 2013-10-31 30    
MOJ_201311.csv 226,153,352.33 278 0 813,501.27 42,000,000.00 2013-11-01 2013-11-28 27     Jump in AvgAmt
MOJ_201312.csv 292,725,083.25 677 0 432,385.65 67,200,000.00 2013-12-02 2013-12-31 29    
MOJ_201401.csv 243,038,519.68 674 0 360,591.28 39,104,000.00 2013-12-04 2014-01-31 58    
MOJ_201402.csv 237,109,710.10 632 0 375,173.59 77,231,000.00 2014-02-03 2014-02-27 24    
MOJ_201403.csv 370,864,079.29 1247 0 297,405.04 75,000,000.00 2014-03-03 2014-04-01 29    
MOJ_201404.csv 229,819,715.84 391 0 587,774.21 59,180,000.00 2014-04-01 2014-04-30 29    
MOJ_201405.csv 259,668,041.18 595 0 436,416.88 57,121,000.00 2014-05-01 2014-05-29 28    
MOJ_201406.csv 327,338,398.99 1364 0 239,984.16 58,743,000.00 2014-06-02 2014-06-30 28    
MOJ_201407.csv 205,093,113.99 741 0 276,778.83 65,102,000.00 2014-07-01 2014-07-31 30    
MOJ_201408.csv 222,995,861.89 699 0 319,021.26 55,806,000.00 2014-08-01 2014-08-29 28    
MOJ_201409.csv 83,512,855.79 704 0 118,626.22 13,300,000.00 2014-09-01 2014-09-30 29     Drop in TotalAmt.
MOJ_201410.csv 98,865,439.69 779 0 126,913.27 24,000,000.00 2014-10-01 2014-10-31 30    
MOJ_201411.csv 91,342,140.43 744 0 122,771.69 15,000,000.00 2014-11-03 2014-11-28 25    
MOJ_201412.csv 110,630,215.64 1146 0 96,535.96 9,920,000.00 2014-11-03 2014-12-31 58    
MOJ_201501.csv 100,982,412.10 343 0 294,409.36 20,000,000.00 2015-01-01 2015-01-30 29     Jump in AvgAmt
MOJ_201502.csv 127,338,005.83 746 0 170,694.38 34,700,000.00 2015-02-02 2015-03-01 27    
MOJ_201503.csv 107,205,007.11 779 0 137,618.75 12,064,000.00 2015-03-02 2015-03-31 29    
MOJ_201504.csv 65,750,899.92 349 0 188,397.99 2,862,500.00 2015-04-16 2015-04-30 14    
MOJ_201505.csv 87,485,791.65 466 0 187,737.75 10,895,000.00 2015-05-01 2015-05-29 28    
MOJ_201506.csv 129,926,237.19 806 0 161,198.81 20,411,736.85 2015-06-01 2015-06-30 29    
MOJ_201507.csv 111,691,731.20 1031 0 108,333.40 13,600,000.00 2015-05-21 2015-07-31 71    
MOJ_201508.csv 53,398,288.80 725 0 73,652.81 8,506,000.00 2015-08-03 2015-08-28 25    
MOJ_201509.csv 134,568,605.34 662 0 203,275.84 18,760,000.00 2015-07-01 2015-09-28 89     Jump in TotalAmt. Jump in AvgAmt
MOJ_201510.csv 41,643,653.95 353 0 117,970.69 13,453,000.00 2015-10-01 2015-10-27 26     Drop in TotalAmt.
MOJ_201511.csv 141,800,287.04 1287 0 110,178.93 12,848,000.00 2015-09-01 2015-11-30 90     Jump in TotalAmt.
MOJ_201512.csv 93,527,646.19 722 0 129,539.68 9,529,000.00 2015-09-30 2015-12-31 92    
MOJ_201601.csv 112,204,462.36 282 0 397,888.16 17,800,000.00 2015-12-01 2016-01-29 59     Jump in AvgAmt
MOJ_201602.csv 53,679,475.35 549 0 97,776.82 11,544,000.00 2015-11-04 2016-02-29 117    
MOJ_201603.csv 146,768,419.50 666 0 220,373.00 24,980,000.00 2016-02-01 2016-03-31 59     Jump in TotalAmt. Jump in AvgAmt
MOJ_201604.csv 86,326,221.83 351 0 245,943.65 7,729,000.00 2016-03-29 2016-04-29 31    
MOJ_201605.csv 96,477,993.84 714 0 135,123.24 12,000,000.00 2016-04-01 2016-05-31 60    
MOJ_201606.csv 102,666,530.91 523 0 196,303.12 8,958,000.00 2016-06-01 2016-06-30 29    
MOJ_201607.csv 81,285,646.78 246 0 330,429.46 10,000,000.00 2016-05-25 2016-07-29 65    
MOJ_201608.csv 82,386,258.05 523 0 157,526.31 15,597,520.00 2016-08-01 2016-08-31 30    
MOJ_201609.csv 65,210,323.09 150 0 434,735.49 33,977,566.00 2016-08-02 2016-09-29 58     Jump in AvgAmt
MOJ_201610.csv 120,697,607.31 1085 0 111,242.03 18,184,916.58 2016-09-01 2016-10-31 60    
MOJ_201611.csv 74,913,692.10 281 0 266,596.77 25,237,415.63 2016-11-01 2016-11-30 29     Jump in AvgAmt
MOJ_201612.csv 133,868,383.45 846 0 158,236.86 18,470,638.00 2016-12-01 2016-12-30 29    
MOJ_201701.csv 23,815,813.92 130 0 183,198.57 2,351,389.60 2016-12-15 2017-01-11 27     Large drop in TotalAmt.
MOJ_201702.csv 765,451.89 9 0 85,050.21 295,566.96 2017-02-02 2017-02-27 25     Large drop in TotalAmt.
MOJ_201703.csv 10,520,903.94 45 0 233,797.87 2,982,409.82 2017-01-03 2017-10-03 273     Large jump in TotalAmt. Jump in AvgAmt
MOJ_201704.csv 5,284,351.75 17 0 310,844.22 1,800,000.00 2017-03-04 2017-12-04 275    
MOJ_201705.csv 100,223,866.73 419 0 239,197.77 8,907,000.00 2017-02-05 2017-12-05 303     Large jump in TotalAmt.
MOJ_201706.csv 102,141,300.26 464 0 220,132.11 9,126,742.85 2017-03-01 2017-06-30 121    
MOJ_201707.CSV 98,157,930.56 390 0 251,687.00 9,013,000.00 2017-03-06 2017-07-31 147    
MOJ_201708.CSV 78,403,001.93 219 0 358,004.58 9,065,000.00 2017-06-02 2017-08-31 90    
MOJ_201709.CSV 121,488,010.92 215 0 565,060.52 45,500,000.00 2017-02-23 2017-09-29 218    
MOJ_201710.csv 114,362,527.32 309 0 370,105.27 32,700,000.00 2017-10-02 2017-10-31 29    
MOJ_201711.csv 75,694,862.90 296 0 255,725.89 4,212,684.25 2017-11-01 2017-11-30 29    
MOJ_201712.csv 155,057,571.22 384 0 403,795.76 15,000,000.00 2017-01-11 2017-12-29 352     Jump in TotalAmt.
MOJ_201801.csv 94,145,002.55 248 0 379,616.95 10,363,000.00 2017-11-14 2018-01-31 78    
MOJ_201802.csv 64,600,991.71 199 0 324,628.10 11,706,000.00 2018-02-01 2018-02-28 27    
MOJ_201803.csv 102,365,059.50 264 0 387,746.44 11,446,000.00 2018-01-12 2018-03-29 76    
MOJ_201804.csv 82,482,608.50 258 0 319,700.03 9,938,000.00 2017-12-27 2018-04-30 124    
MOJ_201805.csv 50,010,608.28 139 0 359,788.55 10,084,000.00 2018-05-01 2018-05-31 30    
MOJ_201806.csv 149,296,887.21 324 0 460,792.86 10,919,500.43 2018-03-12 2018-06-29 109     Jump in TotalAmt.
MOJ_201807.csv 109,631,763.68 350 0 313,233.61 9,463,000.00 2018-07-02 2018-07-31 29    
MOJ_201808.csv 66,441,193.76 250 0 265,764.78 9,576,000.00 2018-07-09 2018-08-31 53    
MOJ_201809.csv 98,114,020.63 231 0 424,736.02 11,397,000.00 2018-08-07 2018-09-28 52    
MOJ_201810.csv 133,045,072.44 278 0 478,579.40 26,000,000.00 2018-09-04 2018-10-31 57    
MOJ_201811.csv 116,230,502.28 348 0 333,995.70 11,000,000.00 2018-09-18 2018-11-30 73    
MOJ_201812.csv 106,881,524.41 302 0 353,912.33 9,650,000.00 2018-12-03 2018-12-31 28    
MOJ_201901.csv 92,411,846.75 359 0 257,414.61 10,045,000.00 2018-12-03 2019-01-31 59    
MOJ_201902.csv 80,936,993.94 198 0 408,772.70 9,448,000.00 2018-12-03 2019-02-28 87    
MOJ_201903.csv 127,074,002.55 337 0 377,074.19 11,899,000.00 2019-03-01 2019-03-29 28    
MOJ_201904.csv 60,593,764.99 238 0 254,595.65 4,963,958.23 2019-04-01 2019-04-30 29    

Total amount : £18,370,245,060.69 in 61,088 records from 105 source files (mean= £174,954,715 and 581 recs/mth) (Range=2011/01 - 2019/04)

OrigRecs shows the number of records that were in the original source file.
AggRecs shows the number of records if aggregation has been used - similar transactions (eg for the same supplier in the same month with the same expenditure type etc) have been combined together to give a single record with a total amount and the date set to the first of the month. Typically this results in a 70% reduction in the number of records.
AvgAmt shows the average (mean) transaction value per original record in that file. One might expect this value to be roughly constant across files.
MaxAmt shows the value of the single largest transaction in that file. Note that errors may be reversed out by subsequent contrary transactions.
MinDate shows the earliest transaction date in that file. MaxDate shows the highest transaction date. Diff shows the difference in days.
Comment highlights significant potential anomalies - large increases/decreases in Total Amt or Avg Amt.


Acknowledgement: Spend data provided by this department has been re-used under the Open Government Licence.