Summary of currently loaded spend data for: Ministry of Housing, Communities and Local Government

Lastfile: DCLG_201908
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
DCLG_201101.csv 3,662,181,516.52 1842 0 1,988,155.00 1,812,496,952.00 2011-01-04 2011-01-31 27    
DCLG_201102.csv 4,356,229,455.32 3126 0 1,393,547.49 1,818,245,403.00 2011-02-01 2011-02-28 27    
DCLG_201103.csv 4,879,176,789.71 3979 0 1,226,231.91 1,003,115,411.00 2011-03-01 2011-03-31 30    
DCLG_201104.csv 4,595,995,799.18 4112 0 1,117,703.26 100,600,000.00 2011-04-01 2011-04-28 27    
DCLG_201105.csv 2,827,840,875.70 2361 0 1,197,730.15 1,420,096,898.00 2011-05-01 2011-05-31 30    
DCLG_201106.csv 3,333,930,512.61 2542 0 1,311,538.36 1,927,274,356.00 2011-06-01 2011-06-30 29    
DCLG_201107.csv 3,713,526,887.40 2512 0 1,478,314.84 1,926,146,260.00 2011-07-01 2011-07-29 28    
DCLG_201108.csv 3,513,856,536.98 2453 0 1,432,473.11 1,927,044,090.00 2011-08-01 2011-08-31 30    
DCLG_201109.csv 3,292,605,383.22 2221 0 1,482,487.79 1,924,602,348.00 2011-09-01 2011-09-30 29    
DCLG_201110.csv 3,249,504,755.70 2410 0 1,348,342.22 1,924,766,683.00 2011-10-03 2011-10-31 28    
DCLG_201111.csv 3,813,978,862.08 2639 0 1,445,236.40 1,926,461,961.00 2011-11-01 2011-11-29 28    
DCLG_201112.csv 3,566,895,909.87 3252 0 1,096,831.46 1,920,612,524.00 2011-12-01 2011-12-30 29    
DCLG_201201.csv 3,238,045,890.30 3209 0 1,009,051.38 1,916,495,328.00 2012-01-03 2012-01-31 28    
DCLG_201202.csv 4,780,151,292.25 3967 0 1,204,978.90 1,905,035,272.00 2012-02-01 2012-02-29 28    
DCLG_201203.csv 11,799,959,000.99 5570 0 2,118,484.56 6,603,036,459.45 2012-03-01 2012-03-31 30     Jump in TotalAmt.
DCLG_201204.csv 3,463,905,455.70 5214 0 664,347.04 823,991,000.00 2012-04-02 2012-04-30 28     Drop in TotalAmt.
DCLG_201205.csv 3,581,052,570.55 3431 0 1,043,734.35 1,493,039,402.00 2012-05-01 2012-05-31 30    
DCLG_201206.csv 4,083,947,912.27 3053 0 1,337,683.56 2,026,267,752.00 2012-06-01 2012-06-29 28    
DCLG_201207.csv 4,467,545,667.33 3671 0 1,216,983.29 2,026,030,903.00 2012-07-02 2012-07-31 29    
DCLG_201208.csv 4,075,998,495.68 3174 0 1,284,183.52 2,026,181,224.00 2012-08-01 2012-08-31 30    
DCLG_201209.csv 3,674,553,848.59 2931 0 1,253,686.06 2,023,271,785.00 2012-09-03 2012-09-28 25    
DCLG_201210.csv 4,413,613,198.45 3383 0 1,304,644.75 2,026,027,703.00 2012-10-01 2012-10-31 30    
DCLG_201211.csv 3,996,858,514.12 3993 0 1,000,966.32 2,025,913,831.00 2012-11-01 2012-11-30 29    
DCLG_201212.csv 4,220,948,867.80 3714 0 1,136,496.73 2,026,094,897.00 2012-12-03 2012-12-31 28    
DCLG_201301.csv 4,058,692,311.09 2917 0 1,391,392.63 2,026,094,892.00 2013-01-02 2013-01-31 29    
DCLG_201302.csv 2,818,976,322.00 3539 0 796,546.01 2,026,094,893.00 2013-02-01 2013-02-28 27    
DCLG_201303.csv 3,091,389,085.12 4245 0 728,242.42 1,172,924,666.00 2013-03-01 2013-03-28 27    
DCLG_201304.csv 9,408,228,310.27 4705 0 1,999,623.45 145,070,359.00 2013-04-01 2013-04-30 29     Jump in TotalAmt. Jump in AvgAmt
DCLG_201305.csv 2,003,018,850.49 3093 0 647,597.43 1,170,794,874.00 2013-05-01 2013-05-31 30     Drop in TotalAmt.
DCLG_201306.csv 1,766,718,988.86 2868 0 616,010.81 838,394,861.00 2013-06-01 2013-06-28 27    
DCLG_201307.csv 2,592,538,271.27 2314 0 1,120,370.90 1,140,350,937.00 2013-07-01 2013-07-31 30    
DCLG_201308.csv 2,567,925,623.27 2378 0 1,079,867.80 1,140,350,931.00 2013-08-01 2013-08-30 29    
DCLG_201309.csv 2,027,766,769.06 2511 0 807,553.47 1,140,350,921.00 2013-09-02 2013-09-30 28    
DCLG_201310.csv 1,876,769,289.30 2351 0 798,285.53 1,140,350,930.00 2013-10-01 2013-10-31 30    
DCLG_201311.csv 2,148,275,297.63 2470 0 869,747.08 1,140,350,931.00 2013-11-01 2013-11-29 28    
DCLG_201312.csv 2,202,927,275.15 3008 0 732,356.14 1,140,350,937.00 2013-12-02 2013-12-31 29    
DCLG_201401.csv 2,095,102,454.93 2307 0 908,150.18 1,140,350,923.00 2014-01-02 2014-01-31 29    
DCLG_201402.csv 5,955,089,665.98 2485 0 2,396,414.35 868,838,812.00 2014-02-03 2014-02-28 25     Jump in TotalAmt. Jump in AvgAmt
DCLG_201403.csv 2,618,248,192.48 4409 0 593,841.73 352,720,441.00 2014-03-03 2014-03-31 28    
DCLG_201404.csv 8,073,441,200.71 4331 0 1,864,105.56 224,279,750.00 2014-04-01 2014-04-30 29     Jump in TotalAmt. Jump in AvgAmt
DCLG_201405.csv 1,529,041,335.24 3050 0 501,325.03 894,972,393.00 2014-05-01 2014-05-30 29     Large drop in TotalAmt.
DCLG_201406.csv 2,141,328,380.18 4671 0 458,430.40 1,049,701,211.00 2014-06-02 2014-06-30 28    
DCLG_201407.csv 2,671,459,155.02 4437 0 602,086.81 1,206,958,474.00 2014-07-01 2014-07-31 30    
DCLG_201408.csv 2,087,906,215.13 3699 0 564,451.53 1,267,294,084.00 2014-08-01 2014-08-29 28    
DCLG_201409.csv 933,739,663.45 4202 0 222,213.15 189,909,776.00 2014-09-01 2014-09-30 29    
DCLG_201410.csv 939,303,795.70 4282 0 219,361.00 227,169,750.00 2014-10-01 2014-10-31 30    
DCLG_201411.csv 714,246,503.68 4449 0 160,540.91 122,055,937.00 2014-11-03 2014-11-28 25    
DCLG_201412.csv 1,232,365,559.26 5149 0 239,340.76 200,658,687.00 2014-12-01 2014-12-31 30    
DCLG_201501.csv 578,853,011.72 3745 0 154,566.89 167,824,774.00 2015-01-01 2015-01-30 29    
DCLG_201502.csv 4,575,097,703.24 4271 0 1,071,200.59 224,323,848.00 2015-02-01 2015-02-27 26     Large jump in TotalAmt. Jump in AvgAmt
DCLG_201503.csv 2,583,418,120.44 4857 0 531,895.85 428,140,456.00 2015-03-02 2015-03-31 29    
DCLG_201504.csv 5,670,428,176.67 5340 0 1,061,877.94 207,034,597.38 2015-04-01 2015-04-30 29     Jump in TotalAmt.
DCLG_201505.csv 1,339,839,905.08 4103 0 326,551.28 173,081,250.00 2015-05-01 2015-05-29 28     Drop in TotalAmt.
DCLG_201506.csv 1,235,031,396.93 3737 0 330,487.40 212,407,818.00 2015-06-01 2015-06-30 29    
DCLG_201507.csv 1,913,921,190.31 4423 0 432,720.14 179,529,410.00 2015-07-01 2015-07-31 30    
DCLG_201508.csv 901,859,226.05 3544 0 254,474.95 16,973,015.00 2015-08-03 2015-08-28 25    
DCLG_201509.csv 1,145,835,741.67 3770 0 303,935.21 116,393,258.00 2015-09-01 2015-09-30 29    
DCLG_201510.csv 1,451,715,154.87 4192 0 346,306.10 173,081,250.00 2015-10-01 2015-10-30 29    
DCLG_201511.csv 960,154,226.05 4173 0 230,087.28 148,445,488.00 2015-11-02 2015-11-30 28    
DCLG_201512.csv 1,268,407,571.06 4299 0 295,047.12 201,196,549.00 2015-12-01 2015-12-31 30    
DCLG_201601.csv 1,558,337,902.68 4125 0 377,778.89 181,965,637.00 2016-01-04 2016-01-29 25    
DCLG_201602.csv 1,022,169,256.66 3874 0 263,853.71 124,405,379.00 2016-02-01 2016-02-29 28    
DCLG_201603.csv 1,458,674,573.40 3951 0 369,191.24 294,579,886.00 2016-03-01 2016-03-31 30    
DCLG_201604.csv 3,422,773,941.51 2998 0 1,141,685.77 127,657,838.00 2016-02-22 2016-04-29 67     Jump in TotalAmt. Jump in AvgAmt
DCLG_201605.csv 1,150,415,444.97 3615 0 318,233.87 107,901,653.00 2016-05-03 2016-05-31 28     Drop in TotalAmt.
DCLG_201606.csv 1,523,817,008.30 3239 0 470,459.09 300,729,771.00 2016-06-01 2016-06-30 29    
DCLG_201607.csv 1,330,147,546.37 3132 0 424,695.90 199,570,505.00 2016-07-01 2016-07-29 28    
DCLG_201608.csv 823,192,029.86 2372 0 347,045.54 105,219,533.00 2016-08-01 2016-08-31 30    
DCLG_201609.csv 1,217,267,384.91 2763 0 440,560.04 213,574,240.00 2016-09-01 2016-09-30 29    
DCLG_201610.csv 1,265,545,095.71 3317 0 381,533.04 202,579,172.00 2016-10-03 2016-10-31 28    
DCLG_201611.csv 926,842,833.48 2644 0 350,545.70 193,073,773.00 2016-11-01 2016-11-30 29    
DCLG_201612.csv 1,496,632,979.72 3320 0 450,793.07 378,713,617.00 2016-12-01 2016-12-30 29    
DCLG_201701.csv 1,098,860,404.62 3429 0 320,460.89 18,126,952.00 2017-01-03 2017-01-31 28    
DCLG_201702.csv 944,350,016.56 3299 0 286,253.42 213,375,754.00 2017-02-01 2017-02-28 27    
DCLG_201703.csv 2,083,484,073.25 4952 0 420,735.88 452,932,504.00 2017-03-01 2017-03-31 30     Jump in TotalAmt.
DCLG_201704.csv 2,777,284,613.09 2165 0 1,282,810.44 139,890,347.00 2017-04-03 2017-04-28 25     Jump in AvgAmt
DCLG_201705.csv 2,036,815,624.99 3771 0 540,126.13 305,401,832.00 2017-05-02 2017-05-31 29    
DCLG_201706.csv 1,426,284,225.07 4093 0 348,469.15 371,483,171.00 2017-06-01 2017-06-30 29    
DCLG_201707.csv 1,400,919,031.69 4129 0 339,287.73 300,991,247.00 2017-07-03 2017-07-31 28    
DCLG_201708.csv 807,889,113.48 3221 0 250,819.35 144,627,204.00 2017-08-01 2017-08-31 30    
DCLG_201709.csv 1,387,718,796.04 4448 0 311,987.14 273,401,674.00 2017-09-01 2017-09-29 28    
DCLG_201710.csv 1,228,110,169.89 1915 0 641,310.79 257,723,487.00 2017-10-01 2017-10-01 0     Jump in AvgAmt
DCLG_201711.csv 943,576,119.36 1621 0 582,095.08 287,550,934.00 2017-11-01 2017-11-01 0    
DCLG_201712.csv 1,519,445,428.32 3152 0 482,057.56 443,210,619.00 2017-12-01 2017-12-01 0    
DCLG_201801.csv 1,149,862,071.00 2318 0 496,057.84 118,938,103.00 2018-01-01 2018-01-01 0    
DCLG_201802.csv 1,054,598,525.68 2785 0 378,670.92 320,100,305.00 2018-02-01 2018-02-01 0    
DCLG_201803.csv 2,375,180,047.36 3989 0 595,432.45 663,414,814.00 2018-03-01 2018-03-01 0     Jump in TotalAmt.
DCLG_201804.csv 3,016,570,495.09 2677 0 1,126,847.40 407,431,641.00 2018-04-01 2018-04-01 0    
DCLG_201805.csv 2,343,039,071.07 2904 0 806,831.64 407,431,623.00 2018-05-01 2018-05-01 0    
DCLG_201806.csv 1,835,646,633.57 2390 0 768,052.98 407,431,641.00 2018-06-01 2018-06-01 0    
DCLG_201807.csv 1,832,506,639.47 2387 0 767,702.82 407,431,632.00 2018-07-01 2018-07-01 0    
DCLG_201808.csv 1,339,734,243.98 1701 0 787,615.66 362,161,448.00 2018-08-01 2018-08-01 0    
DCLG_201809.csv 1,880,707,984.91 2065 0 910,754.47 362,161,466.00 2018-09-01 2018-09-01 0    
DCLG_201810.csv 1,506,267,181.35 2162 0 696,700.82 362,161,444.00 2018-10-01 2018-10-01 0    
DCLG_201811.csv 1,431,212,703.85 1896 0 754,859.02 384,971,385.00 2018-11-01 2018-11-01 0    
DCLG_201812.csv 1,895,883,585.57 2234 0 848,649.77 436,473,832.00 2018-12-01 2018-12-01 0    
DCLG_201901.csv 1,695,899,092.18 2642 0 641,899.73 362,161,456.00 2019-01-01 2019-01-01 0    
DCLG_201902.csv 1,458,838,682.13 2253 0 647,509.40 362,161,449.00 2019-02-01 2019-02-01 0    
DCLG_201903.csv 3,202,400,812.77 10643 0 300,892.68 666,512,097.00 2019-03-01 2019-03-29 28     Jump in TotalAmt.
DCLG_201904.csv 2,737,973,060.32 2460 0 1,112,997.18 650,000,000.00 2019-04-01 2019-04-30 29     Jump in AvgAmt
DCLG_201905.csv 2,814,108,015.47 6378 0 441,221.07 698,897,264.00 2019-05-01 2019-05-31 30    
DCLG_201906.csv 2,155,186,077.66 4560 0 472,628.53 674,448,646.00 2019-06-03 2019-06-28 25    
DCLG_201907.csv 2,057,650,243.37 4853 0 423,995.52 674,448,643.00 2019-07-01 2019-07-31 30    
DCLG_201908.csv 1,752,096,249.48 4462 0 392,670.61 599,509,898.00 2019-08-01 2019-08-30 29    

Total amount : £266,167,278,967.89 in 360,387 records from 104 source files (mean= £2,559,300,759 and 3,465 recs/mth) (Range=2011/01 - 2019/08)

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.