Summary of currently loaded spend data for: Department for Education

Lastfile: DFE_201912
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
DFE_201101.csv 4,075,065,352.19 1051 0 3,877,321.93 727,034,000.00 2011-01-04 2011-01-31 27    
DFE_201102.csv 4,436,273,909.04 2426 0 1,828,637.23 661,290,000.00 2011-02-01 2011-02-28 27    
DFE_201103.csv 6,672,909,181.41 2357 0 2,831,102.75 1,385,500,000.00 2011-03-01 2011-03-31 30    
DFE_201104.csv 6,280,560,112.51 1601 0 3,922,898.26 1,217,919,000.00 2011-04-01 2011-04-28 27    
DFE_201105.csv 5,958,849,566.55 1501 0 3,969,919.76 961,704,000.00 2011-05-03 2011-05-26 23    
DFE_201106.csv 4,924,565,617.16 1501 0 3,280,856.51 885,234,000.00 2011-05-27 2011-06-30 34    
DFE_201107.csv 4,813,818,985.79 1211 0 3,975,077.61 803,484,000.00 2011-07-01 2011-07-29 28    
DFE_201108.csv 6,646,150,748.90 1416 0 4,693,609.29 1,314,398,000.00 2011-08-01 2011-08-31 30    
DFE_201109.csv 6,512,152,060.78 1431 0 4,550,770.13 1,261,761,000.00 2011-09-01 2011-09-30 29    
DFE_201110.csv 2,907,323,216.01 1196 0 2,430,872.25 1,117,863,000.00 2011-10-03 2011-10-31 28    
DFE_201111.csv 6,421,845,900.97 1680 0 3,822,527.32 1,005,115,000.00 2011-11-01 2011-11-30 29     Jump in TotalAmt.
DFE_201112.csv 4,580,721,204.56 1375 0 3,331,433.60 1,313,220,805.00 2011-12-01 2011-12-30 29    
DFE_201201.csv 4,706,865,436.40 1317 0 3,573,929.72 988,057,000.00 2012-01-03 2012-01-31 28    
DFE_201202.csv 6,127,605,580.66 1760 0 3,481,594.08 986,410,000.00 2012-02-01 2012-02-29 28    
DFE_201203.csv 4,433,737,087.09 1689 0 2,625,066.36 1,128,700,000.00 2012-03-01 2012-03-30 29    
DFE_201204.csv 6,133,578,596.69 19528 0 314,091.49 124,016,535.42 2012-04-02 2012-04-30 28     Drop in AvgAmt
DFE_201205.csv 5,861,027,050.23 19064 0 307,439.52 94,738,918.98 2012-05-01 2012-05-31 30    
DFE_201206.csv 5,186,916,851.00 16850 0 307,828.89 129,886,891.00 2012-06-01 2012-06-29 28    
DFE_201207.csv 5,473,851,811.00 29067 0 188,318.43 129,090,257.00 2012-07-02 2012-07-31 29    
DFE_201208.csv 5,942,138,917.00 26725 0 222,343.83 97,655,665.00 2012-08-01 2012-08-31 30    
DFE_201209.csv 5,063,796,725.00 22947 0 220,673.58 639,733,692.00 2012-09-03 2012-09-28 25    
DFE_201210.csv 4,738,320,657.00 23567 0 201,057.44 121,859,843.00 2012-10-01 2012-10-31 30    
DFE_201211.csv 8,726,754,984.00 26532 0 328,914.33 3,443,663,290.00 2012-11-01 2012-11-30 29    
DFE_201212.csv 10,042,606,892.00 28023 0 358,370.16 4,448,250,573.00 2012-12-03 2012-12-31 28    
DFE_201301.csv 7,651,093,968.00 24222 0 315,873.75 3,921,810,495.00 2013-01-02 2013-01-31 29    
DFE_201302.csv 8,568,270,540.48 28767 0 297,850.68 3,544,614,733.00 2013-02-01 2013-02-28 27    
DFE_201303.csv 10,985,324,125.81 27647 0 397,342.36 4,442,246,474.00 2013-03-01 2013-03-28 27    
DFE_201304.csv 10,207,018,161.05 29831 0 342,161.45 5,315,209,912.91 2013-03-04 2013-04-30 57    
DFE_201305.csv 10,484,013,071.00 23387 0 448,283.79 4,732,413,068.00 2013-05-01 2013-05-31 30    
DFE_201306.csv 9,581,097,654.00 27700 0 345,888.00 4,465,551,000.00 2013-06-03 2013-06-30 27    
DFE_201307.csv 9,269,213,951.00 26838 0 345,376.48 4,066,083,000.00 2013-07-01 2013-07-31 30    
DFE_201308.csv 11,461,162,750.00 34334 0 333,813.79 4,431,938,000.00 2013-08-01 2013-08-31 30    
DFE_201309.csv 13,204,153,337.00 36033 0 366,446.13 6,876,215,000.00 2013-05-01 2013-09-30 152    
DFE_201310.csv 8,093,810,119.00 36828 0 219,773.27 2,943,015,669.00 2013-10-01 2013-10-31 30    
DFE_201311.csv 8,535,601,255.00 32736 0 260,740.51 3,851,494,000.00 2013-11-01 2013-11-30 29    
DFE_201312.csv 10,525,982,491.00 35582 0 295,823.24 4,927,020,000.00 2013-12-02 2013-12-31 29    
DFE_201401.csv 8,913,611,390.24 34089 0 261,480.58 4,051,236,811.78 2014-01-01 2014-01-31 30    
DFE_201402.csv 8,227,055,917.32 37202 0 221,145.53 3,633,701,197.38 2014-02-03 2014-02-28 25    
DFE_201403.csv 9,206,357,481.49 37983 0 242,381.00 4,827,404,334.00 2014-03-03 2014-03-31 28    
DFE_201404.csv 8,219,221,023.03 38961 0 210,960.22 5,564,454,370.34 2014-04-01 2014-04-30 29    
DFE_201405.csv 7,996,358,992.20 35347 0 226,224.55 4,871,181,000.00 2014-05-01 2014-05-30 29    
DFE_201406.csv 7,684,743,647.21 38285 0 200,724.66 5,088,777,296.00 2014-06-02 2014-06-30 28    
DFE_201407.csv 6,841,867,815.32 38863 0 176,050.94 4,110,538,723.00 2014-07-01 2014-07-31 30    
DFE_201408.csv 7,284,162,083.79 38612 0 188,650.21 4,506,118,847.00 2014-08-01 2014-08-31 30    
DFE_201409.csv 9,077,299,642.50 37456 0 242,345.68 5,262,767,892.00 2014-09-01 2014-09-30 29    
DFE_201410.csv 7,437,807,643.70 44813 0 165,974.33 4,420,138,013.00 2014-10-01 2014-10-31 30    
DFE_201411.csv 4,900,827,475.48 1287 0 3,807,946.76 4,113,572,000.00 2014-11-03 2014-11-28 25     Jump in AvgAmt
DFE_201412.csv 5,766,097,777.84 1014 0 5,686,486.96 4,896,370,263.65 2014-12-01 2014-12-31 30    
DFE_201501.csv 5,100,113,387.60 764 0 6,675,541.08 4,225,574,556.77 2015-01-02 2015-01-31 29    
DFE_201502.csv 4,718,704,251.04 1328 0 3,553,241.15 3,885,733,993.56 2015-02-02 2015-02-28 26    
DFE_201503.csv 5,798,429,981.23 1490 0 3,891,563.75 4,942,373,921.11 2015-03-02 2015-03-31 29    
DFE_201504.csv 5,647,084,620.72 794 0 7,112,197.26 5,568,500,594.11 2015-04-01 2015-04-30 29    
DFE_201505.csv 4,909,085,347.86 849 0 5,782,197.11 4,823,809,469.19 2015-05-01 2015-05-31 30    
DFE_201506.csv 5,424,423,017.44 778 0 6,972,266.09 5,314,040,872.84 2015-06-01 2015-06-30 29    
DFE_201507.csv 4,643,262,410.08 952 0 4,877,376.48 4,548,135,278.91 2015-07-01 2015-07-31 30    
DFE_201508.csv 4,710,659,392.03 926 0 5,087,105.17 4,659,755,096.86 2015-08-03 2015-08-31 28    
DFE_201509.csv 5,048,670,431.44 713 0 7,080,884.20 4,945,733,064.00 2015-09-01 2015-09-30 29    
DFE_201510.csv 4,636,410,826.56 1229 0 3,772,506.78 4,563,355,745.11 2015-10-01 2015-10-31 30    
DFE_201511.csv 4,317,133,165.21 1112 0 3,882,314.00 4,224,385,587.61 2015-11-02 2015-11-30 28    
DFE_201512.csv 4,985,230,195.32 1023 0 4,873,147.80 4,856,746,132.82 2015-12-01 2015-12-31 30    
DFE_201601.csv 4,644,453,792.28 708 0 6,559,962.98 4,570,753,915.00 2016-01-04 2016-01-31 27    
DFE_201602.csv 3,688,688,693.56 1134 0 3,252,811.90 3,597,979,499.58 2016-02-01 2016-02-29 28    
DFE_201603.csv 4,886,430,157.86 932 0 5,242,950.81 4,743,738,745.06 2016-03-01 2016-03-31 30    
DFE_201604.csv 5,783,457,688.70 772 0 7,491,525.50 5,699,510,319.47 2016-04-01 2016-04-30 29    
DFE_201605.csv 4,965,790,206.85 1070 0 4,640,925.43 4,867,737,783.64 2016-05-03 2016-05-31 28    
DFE_201606.csv 4,997,618,498.70 883 0 5,659,817.10 4,891,651,820.52 2016-06-01 2016-06-30 29    
DFE_201607.csv 5,095,644,604.41 917 0 5,556,864.35 5,011,836,415.02 2016-07-01 2016-07-29 28    
DFE_201608.csv 4,928,083,452.61 1021 0 4,826,722.28 4,833,570,530.24 2016-08-01 2016-08-31 30    
DFE_201609.csv 5,101,178,003.99 955 0 5,341,547.65 4,988,681,600.00 2016-09-01 2016-09-30 29    
DFE_201610.csv 4,767,627,388.46 946 0 5,039,775.25 4,688,406,509.00 2016-10-03 2016-10-31 28    
DFE_201611.csv 4,322,005,604.22 1194 0 3,619,770.19 4,229,207,767.04 2016-11-01 2016-11-30 29    
DFE_201612.csv 8,919,218,071.96 11091 0 804,185.20 4,692,123,025.60 2016-12-01 2016-12-30 29     Jump in TotalAmt.
DFE_201701.csv 8,490,673,987.03 41776 0 203,242.87 4,451,380,000.00 2017-01-01 2017-01-31 30    
DFE_201702.csv 7,890,838,657.68 11904 0 662,872.87 3,992,043,854.71 2017-02-01 2017-02-28 27     Jump in AvgAmt
DFE_201703.csv 10,457,167,308.32 12674 0 825,088.16 4,900,911,788.63 2017-03-01 2017-03-31 30    
DFE_201704.csv 14,578,574,269.19 18242 0 799,176.31 5,839,224,790.00 2017-04-01 2017-04-30 29    
DFE_201705.csv 14,697,962,865.63 16188 0 907,954.22 4,816,512,700.00 2017-05-01 2017-05-31 30    
DFE_201706.csv 11,962,568,867.46 15857 0 754,403.03 5,692,029,253.00 2017-05-29 2017-06-30 32    
DFE_201707.csv 9,761,307,201.39 26381 0 370,012.78 4,734,728,711.00 2017-07-01 2017-07-31 30    
DFE_201708.csv 10,634,064,782.48 17151 0 620,025.93 4,904,232,167.00 2017-08-01 2017-08-31 30    
DFE_201709.csv 12,057,962,611.02 14532 0 829,752.45 5,186,188,793.00 2017-08-30 2017-09-30 31    
DFE_201710.csv 12,990,920,455.08 11612 0 1,118,749.61 5,460,698,429.00 2017-10-01 2017-10-01 0    
DFE_201711.csv 8,883,537,947.24 12579 0 706,219.73 4,117,628,352.00 2017-11-01 2017-11-01 0    
DFE_201712.csv 14,121,005,688.82 13251 0 1,065,655.85 5,062,516,132.65 2017-12-01 2017-12-01 0    
DFE_201801.csv 12,135,054,099.95 12762 0 950,874.01 4,735,642,297.28 2018-01-01 2018-01-01 0    
DFE_201802.csv 9,037,486,874.28 12691 0 712,117.79 4,303,051,278.14 2018-02-01 2018-02-01 0    
DFE_201803.csv 11,246,839,993.32 13023 0 863,613.61 5,504,031,714.75 2018-03-01 2018-03-01 0    
DFE_201804.csv 14,519,802,544.73 13083 0 1,109,822.10 6,204,834,978.58 2018-04-01 2018-04-01 0    
DFE_201805.csv 12,160,960,678.94 11452 0 1,061,907.15 5,012,095,940.71 2018-05-01 2018-05-01 0    
DFE_201806.csv 11,204,285,268.24 12746 0 879,043.25 5,542,501,758.89 2018-06-01 2018-06-01 0    
DFE_201807.csv 10,492,858,169.63 16816 0 623,980.62 5,424,744,287.93 2018-07-01 2018-07-01 0    
DFE_201808.csv 10,392,212,208.40 13393 0 775,943.57 4,951,153,080.62 2018-08-01 2018-08-01 0    
DFE_201809.csv 12,362,789,972.26 11708 0 1,055,926.71 5,305,862,708.49 2018-08-01 2018-09-01 31    
DFE_201810.csv 12,187,364,205.83 12343 0 987,390.76 5,238,785,816.37 2018-10-01 2018-10-01 0    
DFE_201811.csv 9,465,250,639.45 13591 0 696,435.19 4,816,172,385.04 2018-11-01 2018-11-01 0    
DFE_201812.csv 12,220,602,118.57 12133 0 1,007,220.15 7,102,407,104.74 2018-12-01 2018-12-01 0    
DFE_201901.csv 14,311,667,317.44 12108 0 1,182,000.93 4,961,537,127.02 2019-01-01 2019-01-01 0    
DFE_201902.csv 9,442,869,476.52 19166 12476 492,688.59 4,993,856,846.78 2019-02-01 2019-02-01 0    
DFE_201903.csv 10,494,730,523.67 15795 12603 664,433.71 5,673,406,500.05 2019-03-01 2019-03-01 0    
DFE_201904.csv 15,098,989,110.00 20488 13105 736,967.45 6,384,108,854.00 2019-04-01 2019-04-01 0    
DFE_201905.csv 14,910,193,286.47 15738 12814 947,400.77 5,286,532,164.66 2019-05-01 2019-05-01 0    
DFE_201906.csv 10,778,825,475.62 15586 12190 691,570.99 5,406,058,412.51 2019-06-01 2019-06-01 0    
DFE_201907.csv 10,674,275,073.88 23284 15606 458,438.20 5,759,968,219.89 2019-06-01 2019-07-01 30    
DFE_201908.csv 10,191,010,677.67 16049 12726 634,993.50 4,963,374,931.01 2019-08-01 2019-08-01 0    
DFE_201909.csv 12,470,435,171.21 15567 12660 801,081.47 5,474,056,988.41 2019-09-01 2019-09-01 0    
DFE_201910.csv 13,729,960,073.28 22436 13251 611,961.14 5,751,535,774.00 2019-09-01 2019-10-01 30    
DFE_201911.csv 10,372,006,036.82 25224 19735 411,195.93 5,260,037,571.74 2019-11-01 2019-11-01 0    
DFE_201912.csv 12,009,890,545.21 16734 12801 717,693.95 4,679,371,051.00 2019-12-01 2019-12-01 0    

Total amount : £887,265,936,130.26 in 1,547,176 records from 108 source files (mean= £8,215,425,335 and 14,325 recs/mth) (Range=2011/01 - 2019/12)

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.