Summary of currently loaded spend data for: Department for Work and Pensions

Lastfile: DWP_201912
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
DWP_201101.csv 402,137,550.89 16097 0 24,982.14 30,633,444.83 2011-01-04 2011-01-31 0    
DWP_201102.csv 380,910,223.03 15257 0 24,966.26 30,438,174.69 2011-02-01 2011-02-28 0    
DWP_201103.csv 522,514,198.12 21236 0 24,605.11 30,441,483.99 2011-03-01 2011-03-31 0    
DWP_201104.csv 420,600,380.45 16591 0 25,351.12 29,512,539.75 2011-04-01 2011-04-28 0    
DWP_201105.csv 333,959,205.07 16982 0 19,665.48 29,510,577.97 2011-05-03 2011-05-31 0    
DWP_201106.csv 351,656,501.00 20495 0 17,158.16 29,501,800.00 2011-06-01 2011-06-30 0    
DWP_201107.csv 420,248,772.63 22444 0 18,724.33 30,346,786.04 2011-07-01 2011-07-29 0    
DWP_201108.csv 365,310,936.00 19171 0 19,055.39 30,337,724.00 2011-08-01 2011-08-31 0    
DWP_201109.csv 321,040,663.00 23331 0 13,760.26 29,925,609.00 2011-09-01 2011-09-30 0    
DWP_201110.csv 338,096,698.62 17972 0 18,812.41 29,642,263.58 2011-10-03 2011-10-31 0    
DWP_201111.csv 367,960,097.00 26781 0 13,739.60 29,619,242.00 2011-11-01 2011-11-30 0    
DWP_201112.csv 285,990,205.00 19916 0 14,359.82 29,482,308.00 2011-12-01 2011-12-30 0    
DWP_201201.csv 352,111,953.96 20687 0 17,020.93 29,691,768.45 2012-01-03 2012-01-31 0    
DWP_201202.csv 285,883,857.00 23776 0 12,024.05 29,677,100.00 2012-02-01 2012-02-29 0    
DWP_201203.csv 568,040,910.00 26540 0 21,403.20 87,400,000.00 2012-03-01 2012-03-30 0    
DWP_201204.csv 342,149,077.00 21709 0 15,760.70 32,098,492.00 2012-04-02 2012-04-30 0    
DWP_201205.csv 346,847,283.71 25107 0 13,814.76 50,000,000.00 2012-05-01 2012-05-31 0    
DWP_201206.csv 364,537,801.00 22388 0 16,282.73 50,000,000.00 2012-06-01 2012-06-29 0    
DWP_201207.csv 395,093,618.00 27733 0 14,246.34 32,129,741.00 2012-07-02 2012-07-31 0    
DWP_201208.csv 680,080,160.00 56444 0 12,048.76 31,922,646.00 2012-08-01 2012-08-31 0    
DWP_201209.csv 317,637,316.00 27298 0 11,635.92 32,050,104.00 2012-09-03 2012-09-28 0    
DWP_201210.csv 411,603,024.22 33156 0 12,414.13 32,067,370.98 2012-10-01 2012-10-31 0    
DWP_201211.csv 321,641,663.00 26425 0 12,171.87 31,933,887.00 2012-11-01 2012-11-30 0    
DWP_201212.csv 342,776,901.00 31140 0 11,007.61 31,803,941.00 2012-12-03 2012-12-31 0    
DWP_201301.csv 633,089,246.20 32500 0 19,479.67 102,212,001.91 2013-01-02 2013-01-31 0    
DWP_201302.csv 373,090,860.00 34245 0 10,894.75 31,758,012.00 2013-02-01 2013-02-28 0    
DWP_201303.csv 459,737,238.00 32700 0 14,059.24 42,497,675.00 2013-03-01 2013-03-28 0    
DWP_201304.csv 640,776,501.00 37104 0 17,269.74 40,175,000.00 2013-04-02 2013-04-30 0    
DWP_201305.csv 323,409,647.00 31379 0 10,306.56 31,773,582.00 2013-05-01 2013-05-31 0    
DWP_201306.csv 308,421,632.00 34399 0 8,966.01 31,738,735.00 2013-06-03 2013-06-28 0    
DWP_201307.csv 422,584,296.00 40111 0 10,535.37 40,720,000.00 2013-07-01 2013-07-31 0    
DWP_201308.csv 354,918,399.33 33737 0 10,520.15 31,730,817.89 2013-08-01 2013-08-30 0    
DWP_201309.csv 344,959,055.00 34692 0 9,943.48 31,785,286.00 2013-09-02 2013-09-30 0    
DWP_201310.csv 395,521,544.00 38680 0 10,225.48 32,116,417.00 2013-10-01 2013-10-31 0    
DWP_201311.csv 336,926,853.00 37255 0 9,043.80 32,160,743.00 2013-11-01 2013-11-29 0    
DWP_201312.csv 334,375,021.00 34133 0 9,796.24 33,501,000.00 2013-12-02 2013-12-31 0    
DWP_201401.csv 343,138,691.00 38429 0 8,929.16 32,021,440.00 2014-01-02 2014-01-31 0    
DWP_201402.csv 307,106,056.00 36379 0 8,441.85 32,011,363.00 2014-02-03 2014-02-28 0    
DWP_201403.csv 406,899,479.00 35007 0 11,623.37 32,124,755.00 2014-03-03 2014-03-31 0    
DWP_201404.csv 466,910,837.00 36568 0 12,768.29 40,507,000.00 2014-04-01 2014-04-30 0    
DWP_201405.csv 372,693,307.00 36575 0 10,189.84 48,250,682.00 2014-05-01 2014-05-30 0    
DWP_201406.csv 381,871,505.00 35092 0 10,882.01 44,911,000.00 2014-06-02 2014-06-30 0    
DWP_201407.csv 415,431,482.00 38816 0 10,702.58 47,433,670.00 2014-07-01 2014-07-31 0    
DWP_201408.csv 298,039,480.00 30239 0 9,856.13 33,614,124.00 2014-08-01 2014-08-29 0    
DWP_201409.csv 320,277,719.06 37705 0 8,494.30 36,041,000.00 2014-09-01 2014-09-30 0    
DWP_201410.csv 544,686,292.32 38474 0 14,157.26 33,573,693.09 2014-10-01 2014-10-31 0    
DWP_201411.csv 313,503,936.55 33066 0 9,481.16 33,592,739.80 2014-11-03 2014-11-28 0    
DWP_201412.csv 343,648,882.25 35809 0 9,596.72 33,527,414.58 2014-12-01 2014-12-31 0    
DWP_201501.csv 380,297,836.81 32592 0 11,668.44 33,728,902.91 2015-01-02 2015-01-30 0    
DWP_201502.csv 304,891,545.81 35008 0 8,709.20 33,706,484.34 2015-02-02 2015-02-27 0    
DWP_201503.csv 482,820,485.15 38003 0 12,704.80 48,000,000.00 2015-03-02 2015-03-31 0    
DWP_201504.csv 461,702,091.78 31578 0 14,621.00 39,165,000.00 2015-04-01 2015-04-30 0    
DWP_201505.csv 299,470,557.64 29617 0 10,111.44 35,252,669.61 2015-05-01 2015-05-29 0    
DWP_201506.csv 333,520,143.53 34081 0 9,786.10 35,254,342.72 2015-06-01 2015-06-30 0    
DWP_201507.csv 463,561,743.12 35456 0 13,074.28 48,140,000.00 2015-07-01 2015-07-31 0    
DWP_201508.csv 498,487,778.00 29000 0 17,189.23 100,000,000.00 2015-08-03 2015-08-28 0    
DWP_201509.csv 277,464,273.17 27452 0 10,107.25 35,418,251.75 2015-09-01 2015-09-30 0    
DWP_201510.csv 401,430,567.92 36479 0 11,004.43 47,429,000.00 2015-10-01 2015-10-30 0    
DWP_201511.csv 375,114,874.41 30892 0 12,142.78 35,289,040.62 2015-11-02 2015-11-30 0    
DWP_201512.csv 368,313,678.80 29268 0 12,584.18 35,336,172.33 2015-12-01 2015-12-31 0    
DWP_201601.csv 281,231,167.59 27046 0 10,398.25 35,336,180.81 2016-01-04 2016-01-29 0    
DWP_201602.csv 307,593,070.56 31539 0 9,752.78 35,232,131.68 2016-02-01 2016-02-29 0    
DWP_201603.csv 433,365,025.46 32621 0 13,284.85 35,135,210.35 2016-03-01 2016-03-31 0    
DWP_201604.csv 419,808,045.00 30199 0 13,901.39 58,855,000.00 2016-04-01 2016-04-29 0    
DWP_201605.csv 307,311,408.00 26979 0 11,390.76 35,303,562.00 2016-05-03 2016-05-31 0    
DWP_201606.csv 339,978,106.00 27895 0 12,187.78 35,287,242.00 2016-06-01 2016-06-30 0    
DWP_201607.csv 355,757,892.00 30704 0 11,586.70 47,385,000.00 2016-07-01 2016-07-29 0    
DWP_201608.csv 320,205,975.00 28042 0 11,418.80 40,297,972.00 2016-08-01 2016-08-31 0    
DWP_201609.csv 248,887,392.00 29367 0 8,475.07 35,453,794.00 2016-09-01 2016-09-30 0    
DWP_201610.csv 361,082,887.00 29556 0 12,216.91 46,644,000.00 2016-10-03 2016-10-31 0    
DWP_201611.csv 294,905,868.67 28699 0 10,275.82 35,506,274.00 2016-11-01 2016-11-30 0    
DWP_201612.csv 313,018,601.00 27270 0 11,478.50 35,491,046.00 2016-12-01 2016-12-30 0    
DWP_201701.csv 285,644,588.00 22561 0 12,660.99 35,767,634.00 2017-01-03 2017-01-31 0    
DWP_201702.csv 292,621,164.00 25791 0 11,345.86 35,579,658.00 2017-02-02 2017-02-28 0    
DWP_201703.csv 309,635,746.00 28029 0 11,046.98 35,503,569.00 2017-03-01 2017-03-31 0    
DWP_201704.csv 398,942,270.00 19755 0 20,194.50 42,714,000.00 2017-04-03 2017-04-28 0    
DWP_201705.csv 287,082,574.00 16219 0 17,700.39 35,489,831.00 2017-05-02 2017-05-31 0    
DWP_201706.csv 136,769,140.00 463 0 295,397.71 53,000,000.00 2017-06-01 2017-06-01 0     Jump in AvgAmt
DWP_201707.csv 118,716,184.00 151 0 786,199.89 53,000,000.00 2017-07-01 2017-07-01 0     Jump in AvgAmt
DWP_201708.csv 226,340,491.00 2426 0 93,297.81 53,000,000.00 2017-08-01 2017-08-01 0     Drop in AvgAmt
DWP_201709.csv 236,818,585.00 2340 0 101,204.52 53,000,000.00 2017-09-01 2017-09-01 0    
DWP_201710.csv 194,295,425.00 1132 0 171,639.07 58,000,000.00 2017-10-01 2017-10-01 0    
DWP_201711.csv 247,436,412.00 2651 0 93,337.01 53,000,000.00 2017-11-01 2017-11-01 0    
DWP_201712.csv 144,255,172.00 3060 0 47,142.21 32,315,011.00 2017-12-01 2017-12-01 0    
DWP_201801.csv 180,389,358.00 964 0 187,125.89 53,000,000.00 2018-01-01 2018-01-01 0     Jump in AvgAmt
DWP_201802.csv 213,437,792.00 1958 0 109,008.07 32,198,884.00 2018-02-01 2018-02-01 0    
DWP_201803.csv 383,314,325.00 2186 0 175,349.65 40,000,000.00 2018-03-01 2018-03-01 0    
DWP_201804.csv 58,254,430.37 466 0 125,009.51 39,000,000.00 2018-04-01 2018-04-01 0     Large drop in TotalAmt.
DWP_201805.csv 345,845,337.65 4352 0 79,468.14 39,000,000.00 2018-05-01 2018-05-01 0     Large jump in TotalAmt.
DWP_201806.csv 408,170,400.00 4333 0 94,200.42 39,789,323.00 2018-06-01 2018-06-01 0    
DWP_201807.csv 370,614,843.00 4975 0 74,495.45 39,000,000.00 2018-07-01 2018-07-01 0    
DWP_201808.csv 360,417,389.00 4282 0 84,170.34 39,000,000.00 2018-08-01 2018-08-01 0    
DWP_201809.csv 343,533,717.00 3526 0 97,428.73 41,360,721.00 2018-09-01 2018-09-01 0    
DWP_201810.csv 553,588,884.00 4645 0 119,179.52 69,960,281.00 2018-10-01 2018-10-01 0    
DWP_201811.csv 418,164,975.00 4615 0 90,609.96 39,000,000.00 2018-11-01 2018-11-01 0    
DWP_201812.csv 449,963,857.52 2798 0 160,816.25 45,344,439.00 2018-12-01 2018-12-01 0    
DWP_201901.csv 350,358,229.00 42763 4186 8,193.02 39,000,000.00 2019-01-01 2019-01-01 0     Drop in AvgAmt
DWP_201902.csv 357,811,460.00 38994 2918 9,176.06 39,000,000.00 2019-02-01 2019-02-01 0    
DWP_201903.csv 49,510,946.08 6813 1099 7,267.13 20,600,000.00 2019-03-01 2019-03-01 0     Large drop in TotalAmt.
DWP_201904.csv 386,373,537.00 48868 3726 7,906.47 33,329,730.00 2019-04-01 2019-04-01 0     Large jump in TotalAmt.
DWP_201905.csv 148,459,787.00 53660 3977 2,766.68 42,955,667.00 2019-05-01 2019-05-01 0     Drop in TotalAmt.
DWP_201906.csv 201,541,569.00 49308 2987 4,087.40 80,869,610.00 2019-06-01 2019-06-01 0    
DWP_201907.csv 417,091,393.00 54503 4257 7,652.63 42,345,077.00 2019-07-01 2019-07-01 0     Jump in TotalAmt.
DWP_201908.csv 356,527,996.00 38658 4492 9,222.62 42,936,595.00 2019-08-01 2019-08-01 0    
DWP_201909.csv 302,107,068.00 55796 3138 5,414.49 42,899,132.00 2019-09-01 2019-09-01 0    
DWP_201910.csv 430,426,726.00 55416 4795 7,767.19 42,496,397.00 2019-10-01 2019-10-01 0    
DWP_201911.csv 309,493,717.00 52535 4050 5,891.19 42,203,418.00 2019-11-01 2019-11-01 0    
DWP_201912.csv 344,183,727.00 59227 3370 5,811.26 42,041,425.00 2019-12-01 2019-12-01 0    

Total amount : £37,929,207,184.45 in 2,377,786 records from 108 source files (mean= £351,196,363 and 22,016 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 months.
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.