Summary of currently loaded spend data for: Department for Culture Media and Sport

Lastfile: DCMS_201910
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
DCMS_201101.csv 471,336,659.89 212 0 2,223,286.13 139,200,000.00 2011-01-04 2011-01-31 27    
DCMS_201102.csv 493,200,611.44 213 0 2,315,495.83 139,200,000.00 2011-02-01 2011-02-28 27    
DCMS_201103.csv 447,908,120.88 272 0 1,646,721.03 139,200,000.00 2011-03-01 2011-03-31 30    
DCMS_201104-201203.csv 5,469,880,738.03 849 0 6,442,733.50 140,292,000.00 2011-04-01 2012-03-30 364     Large jump in TotalAmt. Jump in AvgAmt
DCMS_201204-201303.csv 5,701,530,852.06 1222 0 4,665,737.19 140,000,000.00 2012-04-02 2013-03-28 360    
DCMS_201304.csv 455,473,842.07 84 0 5,422,307.64 141,822,000.00 2013-04-02 2013-04-30 28     Large drop in TotalAmt.
DCMS_201305.csv 413,852,886.78 65 0 6,366,967.49 141,822,000.00 2013-05-01 2013-05-31 30    
DCMS_201306.csv 383,329,736.34 76 0 5,043,812.32 141,822,000.00 2013-06-03 2013-06-28 25    
DCMS_201307.csv 428,620,160.25 67 0 6,397,315.82 141,822,000.00 2013-07-01 2013-07-30 29    
DCMS_201308.csv 412,546,060.07 80 0 5,156,825.75 141,822,000.00 2013-08-01 2013-08-30 29    
DCMS_201309.csv 384,496,593.20 80 0 4,806,207.42 141,115,000.00 2013-09-02 2013-09-30 28    
DCMS_201310.csv 424,701,116.76 74 0 5,739,204.28 141,115,000.00 2013-10-01 2013-10-31 30    
DCMS_201311.csv 155,348,275.31 77 0 2,017,510.07 32,000,000.00 2013-11-01 2013-11-29 28     Drop in TotalAmt.
DCMS_201312.csv 387,819,964.57 71 0 5,462,253.02 141,115,000.00 2013-12-02 2013-12-31 29     Jump in TotalAmt. Jump in AvgAmt
DCMS_201401.csv 436,592,887.01 77 0 5,670,037.49 141,115,000.00 2014-01-02 2014-01-30 28    
DCMS_201402.csv 408,675,057.66 67 0 6,099,627.73 141,115,000.00 2014-02-03 2014-02-28 25    
DCMS_201403.csv 448,420,876.24 122 0 3,675,580.95 141,115,000.00 2014-03-03 2014-03-31 28    
DCMS_201404.csv 447,536,500.88 76 0 5,888,638.17 142,380,000.00 2014-04-01 2014-04-24 23    
DCMS_201405.csv 444,780,386.12 86 0 5,171,864.95 142,380,000.00 2014-05-01 2014-05-30 29    
DCMS_201406.csv 413,165,899.43 92 0 4,490,933.69 142,380,000.00 2014-06-02 2014-06-30 28    
DCMS_201407.csv 459,703,856.71 107 0 4,296,297.73 142,380,000.00 2014-07-01 2014-07-31 30    
DCMS_201408.csv 357,548,589.73 93 0 3,844,608.49 142,380,000.00 2014-08-01 2014-08-29 28    
DCMS_201409.csv 394,689,721.00 111 0 3,555,763.25 141,683,333.00 2014-09-01 2014-09-30 29    
DCMS_201410.csv 437,598,231.65 103 0 4,248,526.52 141,683,333.00 2014-10-01 2014-10-31 30    
DCMS_201411.csv 128,588,033.52 87 0 1,478,023.37 32,000,000.00 2014-11-03 2014-11-28 25     Drop in TotalAmt.
DCMS_201412.csv 477,671,611.88 146 0 3,271,723.37 141,683,333.00 2014-12-01 2014-12-31 30     Jump in TotalAmt. Jump in AvgAmt
DCMS_201501.csv 380,731,832.25 110 0 3,461,198.48 141,683,333.00 2015-01-02 2015-01-30 28    
DCMS_201502.csv 408,531,590.37 124 0 3,294,609.60 141,683,333.00 2015-02-02 2015-02-27 25    
DCMS_201503.csv 557,842,721.12 260 0 2,145,548.93 141,683,333.00 2015-03-02 2015-03-31 29    
DCMS_201504.csv 456,097,349.33 137 0 3,329,177.73 141,480,000.00 2015-04-01 2015-04-29 28    
DCMS_201505.csv 394,917,210.46 98 0 4,029,767.45 141,480,000.00 2015-05-01 2015-05-28 27    
DCMS_201506.csv 417,004,131.32 141 0 2,957,476.11 141,480,000.00 2015-06-01 2015-06-30 29    
DCMS_201507.csv 428,273,793.12 125 0 3,426,190.34 141,480,000.00 2015-07-01 2015-07-31 30    
DCMS_201508.csv 364,617,602.02 106 0 3,439,788.70 141,480,000.00 2015-08-03 2015-08-28 25    
DCMS_201509.csv 406,120,974.12 137 0 2,964,386.67 141,100,000.00 2015-09-01 2015-09-30 29    
DCMS_201510.csv 452,008,919.68 131 0 3,450,449.77 141,100,000.00 2015-10-01 2015-10-30 29    
DCMS_201511.csv 127,368,180.92 79 0 1,612,255.45 30,000,000.00 2015-11-02 2015-11-27 25     Drop in TotalAmt.
DCMS_201512.csv 422,371,142.82 128 0 3,299,774.55 141,100,000.00 2015-12-01 2015-12-31 30     Jump in TotalAmt. Jump in AvgAmt
DCMS_201601.csv 438,150,507.17 91 0 4,814,840.74 141,100,000.00 2016-01-04 2016-01-29 25    
DCMS_201602.csv 417,791,593.88 149 0 2,803,970.43 141,100,000.00 2016-02-01 2016-02-29 28    
DCMS_201603.csv 466,391,401.08 201 0 2,320,355.23 141,100,000.00 2016-03-01 2016-03-31 30    
DCMS_201604.csv 433,222,121.84 131 0 3,307,039.10 140,130,000.00 2016-04-01 2016-04-29 28    
DCMS_201605.csv 423,976,035.99 107 0 3,962,392.86 140,130,000.00 2016-05-03 2016-05-31 28    
DCMS_201606.csv 380,465,207.92 90 0 4,227,391.20 140,130,000.00 2016-06-01 2016-06-30 29    
DCMS_201607.csv 382,076,651.06 84 0 4,548,531.56 140,130,000.00 2016-07-01 2016-07-29 28    
DCMS_201608.csv 412,971,536.91 96 0 4,301,786.84 140,130,000.00 2016-08-01 2016-08-31 30    
DCMS_201609.csv 370,485,951.57 93 0 3,983,719.91 140,225,000.00 2016-09-01 2016-09-30 29    
DCMS_201610.csv 472,551,930.41 110 0 4,295,926.64 140,225,000.00 2016-10-03 2016-10-31 28    
DCMS_201611.csv 254,091,153.55 121 0 2,099,926.89 35,056,250.00 2016-11-01 2016-11-29 28    
DCMS_201612.csv 409,348,553.36 73 0 5,607,514.43 140,225,000.00 2016-12-08 2016-12-23 15     Jump in AvgAmt
DCMS_201701.csv 270,062,138.56 38 0 7,106,898.38 140,225,000.00 2017-01-03 2017-01-31 28    
DCMS_201702.csv 402,551,578.54 86 0 4,680,832.31 140,225,000.00 2017-02-01 2017-02-28 27    
DCMS_201703.csv 558,028,269.54 116 0 4,810,588.53 140,225,000.00 2017-03-01 2017-03-31 30    
DCMS_201704.csv 582,776,904.92 76 0 7,668,117.17 434,240,767.00 2017-04-03 2017-04-28 25    
DCMS_201705.csv 404,065,069.32 63 0 6,413,731.26 249,968,351.00 2017-05-01 2017-05-30 29    
DCMS_201706.csv 361,188,815.71 92 0 3,925,965.39 249,968,351.00 2017-06-01 2017-06-30 29    
DCMS_201707.csv 759,236,981.86 125 0 6,073,895.85 249,968,351.00 2017-07-03 2017-08-18 46     Jump in TotalAmt.
DCMS_201708.csv 385,984,857.92 73 0 5,287,463.81 249,968,351.00 2017-08-01 2017-08-31 30    
DCMS_201709.csv 361,043,760.94 88 0 4,102,770.01 250,120,692.00 2017-09-01 2017-09-29 28    
DCMS_201710.csv 423,229,679.73 88 0 4,809,428.18 250,120,692.00 2017-10-02 2017-10-31 29    
DCMS_201711.csv 343,391,286.49 100 0 3,433,912.86 248,557,187.00 2017-11-01 2017-11-29 28    
DCMS_201712.csv 368,373,268.15 106 0 3,475,219.51 250,621,815.00 2017-12-01 2017-12-22 21    
DCMS_201801.csv 418,614,621.38 98 0 4,271,577.77 250,621,815.00 2018-01-02 2018-01-31 29    
DCMS_201802.csv 409,931,009.38 105 0 3,904,104.85 250,621,815.00 2018-02-01 2018-02-28 27    
DCMS_201803.csv 427,122,144.30 163 0 2,620,381.25 238,728,987.00 2018-03-01 2018-03-29 28    
DCMS_201804.csv 460,103,859.49 79 0 5,824,099.49 292,995,000.00 2018-04-03 2018-04-30 27     Jump in AvgAmt
DCMS_201805.csv 451,520,490.33 58 0 7,784,836.04 292,995,000.00 2018-05-01 2018-05-30 29    
DCMS_201806.csv 420,023,235.75 60 0 7,000,387.26 292,995,000.00 2018-06-01 2018-06-29 28    
DCMS_201807.csv 474,641,410.26 90 0 5,273,793.45 292,995,000.00 2018-07-02 2018-07-31 29    
DCMS_201808.csv 401,275,134.73 68 0 5,901,104.92 292,995,000.00 2018-08-01 2018-08-31 30    
DCMS_201809.xlsx 374,900,435.18 58 0 6,463,800.61 255,789,285.71 2018-09-03 2018-09-28 25    
DCMS_201810.csv 393,469,666.91 92 0 4,276,844.21 255,789,285.70 2018-10-01 2018-10-31 30    
DCMS_201811.csv 365,720,045.99 72 0 5,079,445.08 255,789,285.70 2018-11-01 2018-11-30 29    
DCMS_201812.csv 393,623,691.19 56 0 7,028,994.49 255,789,285.70 2018-12-03 2018-12-24 21    
DCMS_201901.csv 414,465,231.04 76 0 5,453,489.88 255,789,285.71 2019-01-02 2019-01-31 29    
DCMS_201902.csv 393,283,818.08 79 0 4,978,276.18 255,789,285.71 2019-02-01 2019-02-27 26    
DCMS_201903.csv 450,476,886.50 121 0 3,722,949.48 229,789,286.00 2019-03-01 2019-03-29 28    
DCMS_201904.csv 451,382,268.66 73 0 6,183,318.75 299,295,000.00 2019-04-01 2019-04-30 29    
DCMS_201905.xlsx 387,511,888.33 63 0 6,150,982.35 299,295,000.00 2019-05-01 2019-05-31 30    
DCMS_201906.csv 373,427,292.45 52 0 7,181,294.09 299,295,000.00 2019-06-03 2019-06-26 23    
DCMS_201907.csv 433,361,819.63 87 0 4,981,170.34 299,295,000.00 2019-07-01 2019-07-30 29    
DCMS_201908.csv 407,454,014.86 59 0 6,906,000.25 299,295,000.00 2019-08-01 2019-08-30 29    
DCMS_201909.csv 372,325,016.88 65 0 5,728,077.18 261,289,285.71 2019-09-02 2019-09-27 25    
DCMS_201910.csv 408,861,856.45 83 0 4,926,046.46 261,289,285.70 2019-10-01 2019-10-30 29    

Total amount : £44,865,853,811.20 in 10,339 records from 84 source files (mean= £534,117,307 and 123 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.