Summary of currently loaded spend data for: Ministry of Defence

Lastfile: MOD_201910
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
MOD_201101.csv 417,271,495.81 3399 0 122,763.02 16,910,358.16 2010-05-06 2011-01-31 270    
MOD_201102.csv 486,679,324.57 3591 0 135,527.52 29,504,167.48 2011-02-01 2011-02-28 27    
MOD_201103.csv 517,412,567.93 3837 0 134,848.21 18,378,654.21 2011-03-01 2011-03-31 30    
MOD_201104.csv 640,709,119.57 3010 0 212,860.17 38,719,600.00 2011-04-01 2011-04-30 29    
MOD_201105.csv 471,286,887.81 3465 0 136,013.53 9,513,274.34 2011-05-01 2011-05-31 30    
MOD_201106.csv 546,647,649.17 3179 0 171,955.85 38,869,631.66 2011-05-12 2011-06-30 49    
MOD_201107.csv 440,042,151.16 3342 0 131,670.30 19,732,446.39 2011-01-01 2011-07-29 209    
MOD_201108.csv 492,610,694.69 3031 0 162,524.15 38,179,600.00 2011-01-24 2011-08-31 219    
MOD_201109.csv 770,894,176.86 4091 0 188,436.61 48,055,557.50 2011-04-04 2011-09-30 179    
MOD_201110.csv 415,907,033.16 3108 0 133,818.22 37,719,600.00 2011-07-22 2011-10-31 101    
MOD_201111.csv 503,324,400.23 3701 0 135,996.87 19,814,155.80 2011-06-29 2011-11-30 154    
MOD_201112.csv 475,459,962.71 3574 0 133,033.01 39,630,955.50 2011-11-04 2011-12-30 56    
MOD_201201.csv 394,835,052.75 3568 0 110,660.05 20,334,018.72 2011-11-30 2012-12-19 385    
MOD_201202.csv 466,240,727.80 3593 0 129,763.63 40,259,600.00 2011-12-13 2012-02-29 78    
MOD_201203.csv 641,138,093.36 4618 0 138,834.58 39,616,320.12 2012-01-16 2012-03-31 75    
MOD_201204.csv 641,333,650.70 3848 0 166,666.75 23,367,876.23 2012-02-07 2012-04-30 83    
MOD_201205.csv 547,241,403.04 4053 0 135,021.32 38,719,600.00 2012-04-12 2012-05-31 49    
MOD_201206.csv 463,738,412.36 3416 0 135,754.80 39,616,215.20 2012-04-05 2012-06-30 86    
MOD_201207.csv 491,204,217.84 3671 0 133,806.65 38,719,600.00 2012-05-04 2012-07-31 88    
MOD_201208.csv 434,074,355.12 3743 0 115,969.64 23,464,996.72 2012-07-06 2012-08-31 56    
MOD_201209.csv 495,319,232.54 3239 0 152,923.50 39,614,015.25 2011-10-05 2012-09-30 361    
MOD_201210.csv 441,955,019.89 3922 0 112,686.13 37,406,178.00 2012-09-14 2012-10-31 47    
MOD_201211.csv 459,058,472.72 3595 0 127,693.59 23,134,314.98 2011-11-02 2012-11-30 394    
MOD_201212.csv 506,877,174.51 3015 0 168,118.47 40,536,064.77 2012-10-22 2012-12-31 70    
MOD_201301.csv 495,008,636.51 3240 0 152,780.44 38,719,600.00 2012-12-01 2013-01-31 61    
MOD_201302.csv 436,178,679.18 3622 0 120,424.81 23,474,589.47 2013-01-24 2013-02-28 35    
MOD_201303.csv 669,800,011.16 3987 0 167,995.99 40,432,795.70 2013-02-01 2013-03-31 58    
MOD_201304.csv 614,899,506.14 3432 0 179,166.52 25,116,933.93 2013-02-28 2013-04-30 61    
MOD_201305.csv 549,200,826.50 3863 0 142,169.51 38,719,600.00 2013-03-01 2013-05-31 91    
MOD_201306.csv 499,659,631.64 3312 0 150,863.42 40,417,730.83 2013-04-15 2013-06-30 76    
MOD_201307.csv 450,717,453.16 3709 0 121,519.94 38,719,600.00 2013-05-02 2013-07-31 90    
MOD_201308.csv 441,223,732.24 3055 0 144,426.75 23,016,498.21 2013-04-29 2013-08-31 124    
MOD_201309.csv 443,873,437.15 3218 0 137,934.57 40,287,108.95 2013-04-02 2013-09-30 181    
MOD_201310.csv 503,474,954.88 3509 0 143,481.04 38,719,600.00 2013-04-09 2013-11-08 213    
MOD_201311.csv 571,892,275.74 3717 0 153,858.56 50,849,825.72 2013-09-16 2014-09-16 365    
MOD_201312.csv 537,732,338.78 3378 0 159,186.60 40,269,338.90 2013-05-02 2013-12-31 243    
MOD_201401.csv 472,439,453.96 2876 0 164,269.63 38,719,600.00 2013-11-04 2014-01-31 88    
MOD_201402.csv 401,894,920.24 2722 0 147,646.92 23,600,882.25 2014-02-02 2014-02-28 26    
MOD_201403.csv 523,663,202.09 3143 0 166,612.54 40,211,109.15 2014-03-03 2014-03-28 25    
MOD_201404.csv 654,817,321.62 3131 0 209,139.99 24,396,389.07 2014-04-01 2014-04-30 29    
MOD_201405.csv 516,555,339.71 3278 0 157,582.47 23,875,432.50 2014-03-31 2014-05-30 60    
MOD_201406.csv 539,724,550.68 3456 0 156,170.30 39,986,324.21 2014-04-17 2014-06-30 74    
MOD_201407.csv 478,834,421.27 3040 0 157,511.32 23,649,999.19 2014-05-26 2014-07-31 66    
MOD_201408.csv 497,606,845.28 2796 0 177,970.97 38,719,600.00 2014-05-12 2014-08-29 109    
MOD_201409.csv 530,191,694.79 2864 0 185,122.80 39,971,067.03 2014-07-01 2014-09-30 91    
MOD_201410.csv 567,749,318.85 3511 0 161,705.87 38,719,600.00 2014-09-23 2014-10-31 38    
MOD_201411.csv 589,578,521.58 3258 0 180,963.33 72,299,558.40 2014-04-14 2014-12-08 238    
MOD_201412.csv 650,007,494.73 3429 0 189,561.82 41,415,897.01 2014-12-01 2014-12-31 30    
MOD_201501.csv 416,610,121.99 3014 0 138,224.99 13,800,000.00 2015-01-02 2015-02-04 33    
MOD_201502.csv 480,592,197.81 3922 0 122,537.53 38,719,600.00 2015-02-01 2015-03-11 38    
MOD_201503.csv 641,760,646.29 3450 0 186,017.58 41,288,056.60 2015-03-02 2015-04-07 36    
MOD_201504.csv 687,405,423.11 3467 0 198,270.96 30,475,000.00 2015-03-31 2015-05-28 58    
MOD_201505.csv 481,980,895.64 4640 0 103,875.19 26,104,383.79 2015-05-01 2015-05-29 28    
MOD_201506.csv 568,440,524.90 3598 0 157,987.92 41,312,549.95 2015-01-29 2015-06-30 152    
MOD_201507.csv 442,380,541.01 3404 0 129,959.03 23,836,177.16 2015-07-02 2015-07-31 29    
MOD_201508.csv 566,879,973.66 3004 0 188,708.38 30,475,000.00 2015-08-01 2015-08-31 30    
MOD_201509.csv 529,583,516.83 3339 0 158,605.43 41,276,951.86 2015-09-01 2015-09-30 29    
MOD_201510.csv 543,187,588.27 3484 0 155,909.18 23,845,278.38 2015-09-30 2015-10-30 30    
MOD_201511.csv 572,800,226.62 3447 0 166,173.55 30,475,000.00 2015-09-21 2015-12-01 71    
MOD_201512.csv 823,870,678.11 3590 0 229,490.44 57,269,185.21 2015-12-01 2015-12-31 30    
MOD_201601.csv 466,042,060.79 2800 0 166,443.59 30,475,000.00 2016-01-01 2016-01-29 28    
MOD_201602.csv 533,096,149.43 3594 0 148,329.48 24,290,245.48 2016-01-28 2016-02-29 32    
MOD_201603.csv 813,928,450.40 3982 0 204,401.92 42,686,645.64 2016-03-01 2016-03-31 30    
MOD_201604.csv 854,535,705.95 3700 0 230,955.60 33,902,474.21 2016-04-01 2016-04-29 28    
MOD_201605.csv 698,548,504.33 3053 0 228,807.24 24,687,054.31 2016-04-01 2016-05-31 60    
MOD_201606.csv 742,297,277.85 2868 0 258,820.53 42,699,283.63 2016-06-01 2016-06-30 29    
MOD_201607.csv 629,531,060.47 3278 0 192,047.30 24,488,759.08 2016-06-14 2016-07-31 47    
MOD_201608.csv 521,818,829.03 3230 0 161,553.82 17,304,154.42 2016-08-02 2016-08-31 29    
MOD_201609.csv 855,663,142.15 3128 0 273,549.60 47,224,528.96 2016-08-02 2016-09-30 59    
MOD_201610.csv 679,810,295.12 3737 0 181,913.38 21,368,849.33 2016-06-30 2016-11-04 127    
MOD_201612.csv 431,236,204.64 1597 0 270,028.93 94,874,206.41 2016-11-29 2016-12-30 31    
MOD_201701.csv 314,858,904.88 1905 0 165,280.27 18,691,103.28 2017-01-03 2017-01-31 28    
MOD_201702.csv 345,257,651.40 1689 0 204,415.42 23,297,420.44 2017-02-01 2017-02-28 27    
MOD_201703.csv 1,288,251,021.19 4820 0 267,272.00 38,681,349.00 2017-02-20 2017-03-31 39     Jump in TotalAmt.
MOD_201704.csv 585,622,590.98 2451 0 238,932.11 64,945,862.62 2017-03-30 2017-04-30 31    
MOD_201705.csv 675,372,491.06 2656 0 254,281.81 44,648,285.60 2017-03-30 2017-05-30 61    
MOD_201706.csv 748,860,639.50 2865 0 261,382.42 46,613,334.24 2017-05-01 2018-06-02 397    
MOD_201707.csv 550,216,402.19 2587 0 212,685.12 29,675,927.28 2017-07-03 2027-07-28 3677    
MOD_201708.csv 663,640,760.11 2489 0 266,629.47 38,481,945.42 2017-06-30 2017-08-30 61    
MOD_201709.csv 597,671,032.12 2307 0 259,068.50 21,905,508.20 2017-08-09 2017-09-29 51    
MOD_201710.csv 497,062,715.96 2517 0 197,482.21 22,320,039.06 2017-02-27 2017-11-08 254    
MOD_201711.csv 580,831,042.51 2492 0 233,078.27 36,389,752.23 2017-11-01 2017-11-30 29    
MOD_201712.csv 747,828,605.73 2352 0 317,954.34 31,402,741.22 2017-12-01 2017-12-28 27    
MOD_201801.csv 478,276,217.17 2404 0 198,950.17 25,080,501.48 2018-01-02 2018-01-31 29    
MOD_201802.csv 581,578,213.32 2818 0 206,379.78 26,637,093.95 2018-02-01 2018-02-28 27    
MOD_201803.csv 741,534,487.96 3140 0 236,157.48 35,691,334.53 2018-03-01 2018-03-29 28    
MOD_201804.csv 667,981,495.91 2772 0 240,974.57 51,898,247.17 2018-04-04 2019-04-27 388    
MOD_201805.csv 619,343,793.69 2826 0 219,159.16 25,485,863.92 2018-05-01 2018-06-06 36    
MOD_201806.csv 653,858,705.85 2230 0 293,210.18 24,487,075.54 2017-08-02 2019-06-15 682    
MOD_201807.csv 564,494,816.59 2248 0 251,109.79 30,899,607.11 2018-04-05 2018-07-31 117    
MOD_201808.csv 576,982,888.47 2536 0 227,516.91 27,754,782.91 2018-08-01 2018-08-30 29    
MOD_201809.csv 569,593,683.07 2184 0 260,802.97 28,305,336.96 2018-08-31 2018-09-28 28    
MOD_201810.csv 622,398,359.52 2755 0 225,915.92 33,741,291.47 2018-10-01 2018-10-31 30    
MOD_201811.csv 572,734,624.70 2252 0 254,322.66 39,707,189.62 2018-10-19 2018-11-30 42    
MOD_201812.csv 768,069,452.30 2234 0 343,809.07 60,420,983.04 2018-12-03 2018-12-28 25    
MOD_201901.csv 500,589,397.52 2561 0 195,466.38 25,806,386.63 2019-01-02 2019-01-31 29    
MOD_201902.csv 539,915,731.96 2493 0 216,572.70 25,792,047.59 2019-02-01 2019-02-28 27    
MOD_201903.csv 705,161,853.23 3130 0 225,291.33 26,799,064.99 2019-02-08 2019-03-27 47    
MOD_201904.csv 899,944,253.10 2876 0 312,915.25 80,373,545.62 2019-04-01 2019-04-29 28    
MOD_201905v2.csv 638,145,845.85 2869 0 222,427.97 23,823,896.66 2019-05-01 2019-05-31 30    
MOD_201906.csv 803,857,853.74 2627 0 305,998.42 63,517,287.63 2019-06-03 2019-06-28 25    
MOD_201907.csv 671,468,661.16 2785 0 241,101.85 40,917,276.43 2019-07-01 2019-07-30 29    
MOD_201908.csv 567,816,654.45 2373 0 239,282.20 27,488,888.83 2018-08-08 2019-08-30 387    
MOD_201909.csv 656,167,443.51 2666 0 246,124.32 26,722,725.42 2019-08-09 2019-09-30 52    
MOD_201910.csv 791,808,900.20 3056 0 259,099.77 55,237,361.00 2019-09-26 2019-10-31 35    

Total amount : £60,567,183,049.48 in 331,446 records from 105 source files (mean= £576,830,315 and 3,156 recs/mth) (Range=2011/01 - 2019/10)

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.