Summary of currently loaded spend data for: Cabinet Office

Lastfile: CO_201912
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
CO_201101.csv 27,161,119.79 145 0 187,318.07 7,173,212.86 2011-01-04 2011-01-31 27    
CO_201102.csv 24,730,129.00 127 0 194,725.43 3,866,666.66 2011-02-01 2011-02-28 27    
CO_201103.csv 39,258,572.61 126 0 311,575.97 7,628,856.61 2011-03-01 2011-03-31 30    
CO_201104.csv 92,629,295.63 118 0 784,994.03 60,000,000.00 2011-04-01 2011-04-28 27     Jump in TotalAmt. Jump in AvgAmt
CO_201105.csv 18,147,808.12 94 0 193,061.79 2,854,902.26 2011-05-03 2011-05-31 28     Large drop in TotalAmt.
CO_201106.csv 28,532,598.19 86 0 331,774.40 5,081,305.29 2011-06-01 2011-06-30 29    
CO_201107.csv 49,059,717.95 105 0 467,235.41 25,000,000.00 2011-07-01 2011-07-29 28    
CO_201108.csv 15,445,592.70 72 0 214,522.12 3,948,769.00 2011-08-01 2011-08-31 30     Drop in TotalAmt.
CO_201109.csv 20,206,911.51 80 0 252,586.39 5,738,000.00 2011-09-01 2011-09-29 28    
CO_201110.csv 18,423,961.74 119 0 154,823.21 3,704,181.00 2011-10-03 2011-10-31 28    
CO_201111.csv 16,107,515.51 78 0 206,506.61 2,537,000.00 2011-11-01 2011-11-30 29    
CO_201112.csv 16,271,626.91 102 0 159,525.75 3,799,417.00 2011-12-01 2011-12-29 28    
CO_201201.csv 15,744,061.87 90 0 174,934.02 2,919,750.00 2012-01-03 2012-01-31 28    
CO_201202.csv 29,017,531.71 111 0 261,419.20 2,337,000.00 2012-02-01 2012-02-29 28    
CO_201203.csv 69,770,224.67 145 0 481,173.96 16,622,166.00 2012-03-01 2012-03-30 29     Jump in TotalAmt.
CO_201204.csv 30,827,835.40 126 0 244,665.36 7,338,970.00 2012-04-02 2012-04-30 28    
CO_201205.csv 39,457,031.96 96 0 411,010.75 8,500,000.00 2012-05-01 2012-05-31 30    
CO_201206.csv 15,195,626.36 88 0 172,677.57 1,913,091.00 2012-06-01 2012-06-29 28     Drop in TotalAmt.
CO_201207.csv 42,441,894.90 106 0 400,395.23 7,837,402.00 2012-07-02 2012-07-31 29     Jump in TotalAmt. Jump in AvgAmt
CO_201208.csv 27,178,301.21 114 0 238,406.15 3,000,000.00 2012-08-01 2012-08-31 30    
CO_201209.csv 17,892,700.05 90 0 198,807.78 2,892,372.69 2012-09-03 2012-09-28 25    
CO_201210.csv 18,906,335.50 119 0 158,876.77 1,735,833.11 2012-10-01 2012-10-31 30    
CO_201211.csv 22,747,222.32 108 0 210,622.43 3,000,000.00 2012-11-01 2012-11-30 29    
CO_201212.csv 18,697,767.64 88 0 212,474.63 3,899,869.00 2012-12-03 2012-12-31 28    
CO_201301.csv 24,859,520.00 127 0 195,744.25 4,924,068.00 2013-01-02 2013-01-31 29    
CO_201302.csv 41,999,463.90 129 0 325,577.24 6,795,751.58 2013-02-01 2013-02-28 27    
CO_201303.csv 51,866,998.92 148 0 350,452.70 9,787,937.00 2013-03-01 2013-03-28 27    
CO_201304.csv 49,124,393.37 179 0 274,437.95 8,888,000.00 2013-04-02 2013-04-30 28    
CO_201305.csv 18,706,312.74 101 0 185,211.02 2,489,681.32 2013-05-01 2013-05-31 30     Drop in TotalAmt.
CO_201306.csv 27,066,095.18 117 0 231,334.15 3,144,871.00 2013-06-03 2013-06-28 25    
CO_201307.csv 45,732,852.30 141 0 324,346.47 12,000,000.00 2013-07-01 2013-07-31 30    
CO_201308.csv 41,900,567.37 114 0 367,548.84 6,138,000.00 2013-08-01 2013-08-30 29    
CO_201309.csv 29,410,685.76 121 0 243,063.52 4,000,000.00 2013-09-02 2013-09-30 28    
CO_201310.csv 36,225,215.15 131 0 276,528.36 6,979,393.00 2013-10-01 2013-10-31 30    
CO_201311.csv 45,102,769.47 137 0 329,217.30 15,430,467.00 2013-11-01 2013-11-29 28    
CO_201312.csv 32,926,603.28 120 0 274,388.36 5,967,305.68 2013-12-02 2013-12-30 28    
CO_201401.csv 44,765,445.65 136 0 329,157.69 13,130,294.00 2014-01-02 2014-01-31 29    
CO_201402.csv 39,951,771.07 150 0 266,345.14 10,441,379.96 2014-02-03 2014-02-28 25    
CO_201403.csv 59,173,980.10 230 0 257,278.17 5,706,052.00 2014-03-03 2014-03-28 25    
CO_201404.csv 60,080,545.34 452 0 132,921.56 4,062,500.00 2014-04-01 2014-04-30 29    
CO_201405.csv 49,393,471.85 149 0 331,499.81 28,832,252.00 2014-05-01 2014-05-30 29     Jump in AvgAmt
CO_201406.csv 50,899,769.10 278 0 183,092.69 2,944,547.41 2014-06-02 2014-06-30 28    
CO_201407.csv 78,638,026.22 170 0 462,576.62 35,630,470.00 2014-07-01 2014-07-31 30     Jump in AvgAmt
CO_201408.csv 26,306,417.19 121 0 217,408.41 3,920,728.80 2014-08-01 2014-08-29 28     Drop in TotalAmt.
CO_201409.csv 30,240,639.90 109 0 277,437.06 4,062,500.00 2014-09-01 2014-09-30 29    
CO_201410.csv 32,670,288.53 196 0 166,685.15 2,944,547.41 2014-10-01 2014-10-31 30    
CO_201411.csv 42,749,756.40 115 0 371,737.01 25,422,537.00 2014-11-03 2014-11-28 25     Jump in AvgAmt
CO_201412.csv 30,260,673.31 145 0 208,694.30 3,463,293.89 2014-12-01 2014-12-31 30    
CO_201501.csv 35,946,490.19 219 0 164,139.22 4,062,500.00 2015-01-02 2015-01-30 28    
CO_201502.csv 61,192,577.56 150 0 407,950.52 26,998,777.00 2015-02-02 2015-02-27 25     Jump in AvgAmt
CO_201503.csv 107,841,047.54 296 0 364,327.86 36,000,000.00 2015-03-02 2015-03-31 29    
CO_201504.csv 35,114,256.06 402 0 87,348.90 3,523,313.50 2015-04-01 2015-04-30 29     Drop in TotalAmt.
CO_201505.csv 20,381,512.36 122 0 167,061.58 2,726,832.54 2015-05-01 2015-05-29 28    
CO_201506.csv 27,278,306.96 200 0 136,391.53 2,726,832.54 2015-06-01 2015-06-30 29    
CO_201507.csv 18,274,560.74 135 0 135,367.12 3,011,894.49 2015-07-01 2015-07-31 30    
CO_201508.csv 33,768,665.37 135 0 250,138.26 5,230,200.01 2015-08-03 2015-08-28 25    
CO_201509.csv 25,327,308.67 128 0 197,869.60 6,960,864.24 2015-09-01 2015-09-30 29    
CO_201510.csv 54,812,819.95 199 0 275,441.31 30,994,830.00 2015-10-01 2015-10-29 28     Jump in TotalAmt.
CO_201511.csv 20,678,473.25 130 0 159,065.18 3,369,583.00 2015-11-02 2015-11-30 28     Drop in TotalAmt.
CO_201512.csv 37,936,868.24 157 0 241,636.10 16,660,512.00 2015-12-01 2015-12-31 30    
CO_201601.csv 22,714,448.15 125 0 181,715.59 5,000,000.00 2016-01-04 2016-01-29 25    
CO_201602.csv 20,859,563.17 147 0 141,901.79 4,310,688.42 2016-02-01 2016-02-29 28    
CO_201603.csv 51,093,527.01 225 0 227,082.34 7,350,000.00 2016-03-01 2016-03-31 30     Jump in TotalAmt.
CO_201604.xlsx 113,520,612.25 558 0 203,441.96 38,800,000.00 2016-04-01 2016-04-29 28     Jump in TotalAmt.
CO_201605.xlsx 38,202,310.71 195 0 195,909.29 10,508,928.00 2016-05-03 2016-05-31 28     Drop in TotalAmt.
CO_201606.csv 41,190,756.00 189 0 217,940.51 10,508,928.00 2016-06-01 2016-06-30 29    
CO_201607.csv 81,266,344.99 303 0 268,205.76 47,000,000.00 2016-07-01 2016-07-29 28    
CO_201608.csv 25,482,512.76 189 0 134,828.11 3,885,916.82 2016-08-01 2016-08-31 30     Drop in TotalAmt.
CO_201609.csv 21,109,794.35 132 0 159,922.68 2,841,815.11 2016-09-01 2016-09-30 29    
CO_201610.csv 87,672,673.72 208 0 421,503.24 49,900,000.00 2016-10-03 2016-10-31 28     Large jump in TotalAmt. Jump in AvgAmt
CO_201611.csv 36,213,185.53 162 0 223,538.18 5,500,000.00 2016-11-01 2016-11-30 29    
CO_201612.csv 73,941,217.57 185 0 399,682.26 41,476,033.00 2016-12-01 2016-12-30 29     Jump in TotalAmt.
CO_201701.csv 27,720,681.74 150 0 184,804.54 4,200,000.00 2017-01-03 2017-01-31 28     Drop in TotalAmt.
CO_201702.csv 29,245,787.92 202 0 144,781.13 3,549,000.00 2017-02-01 2017-02-28 27    
CO_201703.csv 43,926,705.69 314 0 139,893.97 2,744,063.57 2017-03-01 2017-03-31 30    
CO_201704.csv 30,438,017.74 187 0 162,770.15 3,500,000.00 2017-04-03 2017-04-28 25    
CO_201705.csv 12,059,916.93 89 0 135,504.68 2,585,816.30 2017-05-02 2017-05-24 22     Drop in TotalAmt.
CO_201706.csv 21,847,629.66 150 0 145,650.86 3,102,979.56 2017-06-01 2017-06-30 29    
CO_201707.csv 32,648,707.84 134 0 243,647.07 3,102,979.56 2017-07-03 2017-07-31 28    
CO_201708.csv 18,098,712.99 182 0 99,443.48 1,688,729.47 2017-08-01 2017-08-31 30    
CO_201709.csv 39,697,032.96 303 0 131,013.31 3,167,037.55 2017-09-01 2017-09-29 28     Jump in TotalAmt.
CO_201710.xlsx 36,860,393.06 375 0 98,294.38 4,841,000.00 2017-10-02 2017-10-31 29    
CO_201711.csv 21,588,620.77 316 0 68,318.42 3,054,162.00 2017-11-01 2017-11-30 29    
CO_201712.csv 37,271,964.00 183 0 203,671.93 5,431,406.00 2017-12-01 2017-12-29 28     Jump in AvgAmt
CO_201801.csv 27,271,893.73 145 0 188,082.03 3,120,536.00 2018-01-02 2018-01-31 29    
CO_201802.csv 31,619,847.00 163 0 193,986.79 7,811,144.00 2018-02-01 2018-02-28 27    
CO_201803.csv 262,092,823.18 398 0 658,524.68 150,000,000.00 2018-03-01 2018-03-29 28     Large jump in TotalAmt. Jump in AvgAmt
CO_201804.csv 46,003,160.32 198 0 232,339.19 10,326,404.00 2018-04-03 2018-04-30 27     Large drop in TotalAmt.
CO_201805.csv 25,477,492.71 170 0 149,867.60 7,075,002.00 2018-05-01 2018-05-31 30    
CO_201806.csv 36,371,665.37 178 0 204,335.20 3,614,147.00 2018-06-01 2018-06-29 28    
CO_201807.csv 39,699,690.18 334 0 118,861.35 3,195,578.91 2018-07-02 2018-07-31 29    
CO_201808.csv 18,479,180.42 120 0 153,993.17 1,992,681.40 2018-08-01 2018-08-31 30    
CO_201809.csv 17,497,299.00 201 0 87,051.24 2,403,673.55 2018-08-01 2018-09-28 58    
CO_201810.csv 78,470,362.48 526 0 149,183.20 2,403,673.55 2018-02-16 2018-11-01 258     Large jump in TotalAmt.
CO_201811.csv 45,245,502.68 259 0 174,693.06 3,216,000.15 2018-11-01 2018-11-30 29    
CO_201812.csv 46,635,421.16 277 0 168,358.92 2,364,696.00 2018-11-29 2018-12-31 32    
CO_201901.csv 44,408,171.47 293 0 151,563.73 3,269,289.00 2019-01-02 2019-01-31 29    
CO_201902.csv 29,506,619.84 219 0 134,733.42 2,813,263.27 2019-02-01 2019-02-28 27    
CO_201903.csv 137,534,258.40 452 0 304,279.33 80,877,144.09 2019-02-28 2019-03-29 29     Large jump in TotalAmt. Jump in AvgAmt
CO_201904.csv 98,650,600.50 294 0 335,546.26 26,359,034.50 2019-04-01 2019-04-30 29    
CO_201905.csv 59,069,770.47 360 0 164,082.70 5,070,710.75 2019-03-20 2019-05-31 72    
CO_201906.csv 48,558,342.20 342 0 141,983.46 2,168,114.41 2019-06-03 2019-06-28 25    
CO_201907.csv 32,256,356.49 223 0 144,647.34 2,168,114.41 2019-07-01 2019-07-31 30    
CO_201908.csv 47,565,418.85 346 0 137,472.31 6,158,000.00 2019-08-01 2019-08-30 29    
CO_201909.csv 52,079,506.75 394 0 132,181.49 1,111,956.52 2019-09-02 2019-09-30 28    
CO_201910.csv 65,198,083.64 257 0 253,689.04 26,359,034.50 2019-10-01 2019-10-31 30    
CO_201911.csv 44,453,108.64 226 0 196,695.17 2,704,957.26 2019-11-01 2019-11-29 28    
CO_201912.csv 64,030,010.13 465 0 137,698.95 2,168,114.41 2019-12-02 2019-12-31 29    

Total amount : £4,545,302,235.36 in 20,665 records from 108 source files (mean= £42,086,132 and 191 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.