Summary of currently loaded spend data for: Foreign & Commonwealth Office

Lastfile: FCO_201911
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
FCO_201101.csv 39,660,758.14 306 0 129,610.32 12,676,491.65 2011-01-04 2011-01-31 27    
FCO_201102.csv 192,332,535.57 196 0 981,288.45 245,699,563.00 2011-02-01 2011-02-28 27     Large jump in TotalAmt. Jump in AvgAmt
FCO_201103.csv 74,605,885.12 251 0 297,234.60 129,932,763.00 2011-03-01 2011-03-31 30     Drop in TotalAmt.
FCO_201104.csv 4,737,729.92 186 0 25,471.67 893,856.86 2011-04-01 2011-04-28 27     Large drop in TotalAmt. Drop in AvgAmt
FCO_201105.csv 17,527,503.18 222 0 78,952.72 3,574,144.28 2011-05-03 2011-05-31 28     Jump in TotalAmt. Jump in AvgAmt
FCO_201106.csv 10,427,403.43 269 0 38,763.58 3,374,245.73 2011-06-01 2011-06-30 29    
FCO_201107.csv 13,976,142.16 169 0 82,699.07 4,239,440.56 2011-07-01 2011-07-29 28     Jump in AvgAmt
FCO_201108.csv 6,444,296.89 159 0 40,530.17 658,000.00 2011-08-01 2011-08-31 30    
FCO_201109.csv 191,441,073.47 258 0 742,019.66 129,454,239.00 2011-09-01 2011-09-30 29     Large jump in TotalAmt. Jump in AvgAmt
FCO_201110.csv 3,635,279.47 334 0 10,884.07 166,189.00 2011-10-03 2011-10-31 28     Large drop in TotalAmt. Drop in AvgAmt
FCO_201111.csv 59,854,076.69 187 0 320,075.28 19,107,879.07 2011-11-01 2011-11-30 29     Large jump in TotalAmt. Jump in AvgAmt
FCO_201112.csv 10,672,549.99 359 0 29,728.55 4,186,807.52 2011-12-01 2011-12-29 28     Large drop in TotalAmt. Drop in AvgAmt
FCO_201201.csv 38,265,323.52 977 0 39,166.14 25,221,965.23 2012-01-03 2012-01-31 28     Jump in TotalAmt.
FCO_201202.csv 30,873,102.85 947 0 32,600.95 6,180,128.29 2012-02-01 2012-02-29 28    
FCO_201203.csv 87,992,841.60 1127 0 78,077.06 19,760,248.00 2012-03-01 2012-03-30 29     Jump in TotalAmt. Jump in AvgAmt
FCO_201204.csv 146,873,622.00 1458 0 100,736.37 73,842,389.76 2012-04-02 2012-04-30 28    
FCO_201205.csv 130,285,396.25 1217 0 107,054.56 19,752,479.34 2012-05-01 2012-05-31 30    
FCO_201206.csv 55,583,591.39 1022 0 54,387.08 18,500,000.00 2012-06-01 2012-06-29 28    
FCO_201207.csv 44,096,576.79 1065 0 41,405.24 18,200,000.00 2012-07-02 2012-07-31 29    
FCO_201208.csv 65,348,750.40 955 0 68,428.01 17,800,000.00 2012-08-01 2012-08-31 30    
FCO_201209.csv 140,975,419.06 1118 0 126,096.08 125,873,246.00 2012-09-04 2012-09-28 24     Jump in TotalAmt.
FCO_201210.csv 106,353,546.05 1443 0 73,703.08 26,071,011.62 2012-10-01 2012-10-31 30    
FCO_201211.csv 43,218,423.54 1462 0 29,561.17 17,600,000.00 2012-11-01 2012-11-30 29    
FCO_201212.csv 108,313,451.90 1643 0 65,924.19 20,000,000.00 2012-12-03 2012-12-31 28     Jump in TotalAmt. Jump in AvgAmt
FCO_201301.csv 97,137,000.84 1666 0 58,305.52 21,900,000.00 2013-01-02 2013-01-31 29    
FCO_201302.csv 184,756,112.33 1731 0 106,733.74 22,400,000.00 2013-02-01 2013-02-28 27    
FCO_201303.csv 115,083,187.52 693 0 166,065.21 26,700,000.00 2013-03-01 2013-04-02 32    
FCO_201304.csv 167,050,476.61 537 0 311,080.96 65,490,038.21 2013-04-02 2013-04-30 28    
FCO_201305.csv 105,701,790.01 3609 0 29,288.39 18,900,000.00 2013-05-01 2013-05-31 30     Drop in AvgAmt
FCO_201306.csv 23,652,261.40 243 0 97,334.41 1,305,004.00 2013-03-06 2013-12-06 275     Drop in TotalAmt. Jump in AvgAmt
FCO_201307.csv 31,641,895.89 303 0 104,428.70 1,319,051.00 2013-02-07 2013-12-07 303    
FCO_201308.csv 79,226,341.95 550 0 144,047.89 6,023,056.00 2013-08-04 2013-08-30 26     Jump in TotalAmt.
FCO_201309.csv 30,314,823.94 256 0 118,417.28 7,554,528.00 2013-03-09 2013-12-09 275     Drop in TotalAmt.
FCO_201310.csv 34,820,144.18 316 0 110,190.33 3,476,644.00 2013-02-10 2013-11-10 273    
FCO_201311.csv 26,584,442.53 257 0 103,441.41 1,510,906.00 2013-11-04 2013-11-29 25    
FCO_201312.csv 26,496,154.15 262 0 101,130.36 1,510,906.00 2013-02-12 2013-12-31 322    
FCO_201401.csv 43,139,889.11 333 0 129,549.22 3,394,751.00 2014-01-13 2014-10-01 261    
FCO_201402.csv 28,748,385.30 307 0 93,642.95 1,510,907.00 2014-02-13 2014-12-02 292    
FCO_201403.csv 48,048,062.50 471 0 102,012.87 2,120,010.00 2014-03-13 2014-12-03 265    
FCO_201404.csv 30,800,676.20 294 0 104,764.20 1,355,123.00 2014-01-04 2014-11-04 304    
FCO_201405.csv 38,575,543.18 281 0 137,279.51 2,500,000.00 2014-01-05 2014-12-05 334    
FCO_201406.csv 19,993,257.73 225 0 88,858.92 968,576.80 2014-03-06 2014-12-06 275    
FCO_201407.csv 25,537,214.87 236 0 108,208.54 1,445,833.00 2014-02-07 2014-11-07 273    
FCO_201408.csv 25,735,730.58 203 0 126,777.00 1,445,833.00 2014-04-08 2014-12-08 244    
FCO_201409.csv 41,563,356.03 237 0 175,372.81 7,898,941.00 2014-02-09 2014-12-09 303    
FCO_201410.csv 41,102,431.71 313 0 131,317.67 1,590,155.00 2014-03-10 2014-10-31 235    
FCO_201412.csv 48,160,394.34 404 0 119,208.90 1,763,755.00 2014-01-12 2014-12-31 353    
FCO_201501.csv 31,607,189.43 297 0 106,421.51 1,728,245.00 2015-01-13 2015-12-01 322    
FCO_201502.csv 33,611,309.17 326 0 103,102.18 2,832,400.00 2015-02-02 2015-12-02 303    
FCO_201503.csv 47,786,000.48 500 0 95,572.00 3,292,899.00 2015-03-03 2015-12-03 275    
FCO_201504.csv 32,468,605.25 236 0 137,578.84 2,722,790.00 2015-04-13 2015-10-04 174    
FCO_201505.csv 25,634,360.77 178 0 144,013.26 3,294,250.00 2015-05-05 2015-12-05 214    
FCO_201506.csv 25,922,319.54 229 0 113,197.90 1,166,567.00 2015-02-06 2015-12-06 303    
FCO_201507.csv 26,048,019.01 202 0 128,950.59 1,642,149.00 2015-02-07 2015-10-07 242    
FCO_201508.csv 23,410,401.99 170 0 137,708.25 4,769,197.00 2015-08-03 2015-08-27 24    
FCO_201509.csv 29,252,620.58 220 0 132,966.46 2,049,023.00 2015-09-02 2015-09-29 27    
FCO_201510.csv 36,471,080.09 295 0 123,630.78 1,649,740.00 2015-10-02 2015-10-28 26    
FCO_201511.csv 25,825,340.80 262 0 98,570.00 1,104,830.00 2015-11-02 2015-11-27 25    
FCO_201512.csv 40,057,165.20 261 0 153,475.73 5,908,371.00 2015-12-02 2015-12-31 29    
FCO_201601.csv 49,447,079.00 370 0 133,640.75 3,036,038.00 2016-01-04 2016-01-29 25    
FCO_201602.csv 26,591,640.62 288 0 92,332.09 1,641,592.00 2016-02-02 2016-02-26 24    
FCO_201603.csv 56,650,884.93 517 0 109,576.18 3,700,840.00 2016-03-02 2016-03-30 28     Jump in TotalAmt.
FCO_201604.csv 235,831,926.85 579 0 407,309.03 57,369,937.70 2016-04-01 2016-04-29 28     Large jump in TotalAmt. Jump in AvgAmt
FCO_201605.csv 103,007,576.14 495 0 208,096.11 13,150,000.00 2016-05-01 2016-05-31 30    
FCO_201606.csv 119,922,335.08 480 0 249,838.20 16,614,321.10 2016-06-01 2016-06-30 29    
FCO_201607.csv 90,602,858.76 445 0 203,601.93 13,150,000.00 2016-07-01 2016-07-29 28    
FCO_201608.csv 195,769,724.67 526 0 372,185.79 41,377,985.37 2016-08-01 2016-08-31 30     Jump in TotalAmt.
FCO_201609.csv 239,809,525.67 606 0 395,725.29 40,000,000.00 2016-09-01 2016-09-30 29    
FCO_201610.csv 119,546,551.10 630 0 189,756.43 13,150,000.00 2016-10-01 2016-10-31 30    
FCO_201611.csv 125,121,065.26 740 0 169,082.52 13,150,000.00 2016-11-01 2016-11-30 29    
FCO_201612.csv 248,010,482.93 961 0 258,075.42 70,000,000.00 2016-12-01 2016-12-30 29    
FCO_201701.csv 133,489,506.40 712 0 187,485.26 16,801,888.00 2017-01-01 2017-01-31 30    
FCO_201702.csv 419,039,604.17 664 0 631,083.74 300,000,000.00 2017-02-01 2017-02-28 27     Jump in TotalAmt. Jump in AvgAmt
FCO_201703.csv 386,798,556.51 1162 0 332,873.11 189,000,000.00 2017-03-01 2017-03-31 30    
FCO_201704.csv 126,253,601.22 511 0 247,071.63 14,286,228.29 2017-05-01 2017-05-31 30     Drop in TotalAmt.
FCO_201705.csv 123,701,168.64 508 0 243,506.24 14,286,228.29 2017-05-01 2017-05-31 30    
FCO_201706.csv 133,242,441.36 615 0 216,654.38 18,285,728.32 2017-06-01 2017-06-30 29    
FCO_201707.csv 107,648,196.18 531 0 202,727.30 13,400,000.00 2017-07-01 2017-07-31 30    
FCO_201708.csv 349,695,135.03 578 0 605,008.88 115,894,128.00 2017-08-01 2017-08-31 30     Jump in TotalAmt. Jump in AvgAmt
FCO_201709.csv 89,278,164.13 519 0 172,019.58 15,400,000.00 2017-09-01 2017-09-29 28     Drop in TotalAmt.
FCO_201710.csv 322,049,210.50 645 0 499,301.10 179,432,589.20 2017-10-01 2017-10-31 30     Jump in TotalAmt. Jump in AvgAmt
FCO_201711.csv 232,165,875.79 653 0 355,537.33 35,000,000.00 2017-11-01 2017-11-30 29    
FCO_201712.csv 154,909,534.14 791 0 195,840.12 16,900,000.00 2017-12-01 2017-12-29 28    
FCO_201801.csv 136,945,834.14 693 0 197,613.04 16,200,000.00 2018-01-01 2018-01-31 30    
FCO_201802.csv 278,087,340.26 731 0 380,420.44 120,357,150.54 2018-02-01 2018-02-28 27     Jump in TotalAmt.
FCO_201803.csv 315,587,910.14 1080 0 292,211.03 110,000,000.00 2018-03-01 2018-03-29 28    
FCO_201804.csv 179,506,539.67 716 0 250,707.46 12,119,635.49 2018-04-01 2018-04-30 29    
FCO_201805.csv 176,355,559.43 640 0 275,555.56 44,125,006.16 2018-05-01 2018-05-31 30    
FCO_201806.csv 136,013,351.79 732 0 185,810.59 13,700,000.00 2018-06-01 2018-06-29 28    
FCO_201807.csv 118,627,857.62 630 0 188,298.19 16,200,000.00 2018-07-01 2018-07-31 30    
FCO_201808.csv 433,646,368.87 664 0 653,081.88 199,343,502.97 2018-08-01 2018-08-31 30     Jump in TotalAmt. Jump in AvgAmt
FCO_201809.csv 138,277,608.14 601 0 230,079.21 18,500,000.00 2018-09-01 2018-09-28 27     Drop in TotalAmt.
FCO_201810.csv 134,535,495.16 814 0 165,277.02 10,000,000.00 2018-10-01 2018-10-31 30    
FCO_201811.csv 451,037,102.01 761 0 592,690.02 285,612,185.40 2018-11-01 2018-11-30 29     Jump in TotalAmt. Jump in AvgAmt
FCO_201812.csv 178,192,856.37 848 0 210,133.09 16,000,000.00 2018-12-01 2018-12-31 30     Drop in TotalAmt.
FCO_201901.csv 205,733,395.72 793 0 259,436.82 18,037,204.57 2019-01-01 2019-01-31 30    
FCO_201902.csv 273,358,437.44 789 0 346,461.90 144,070,492.64 2019-02-01 2019-02-28 27    
FCO_201903.csv 383,667,429.95 1539 0 249,296.58 70,000,000.00 2019-03-01 2019-03-29 28    
FCO_201904.csv 276,215,749.23 776 0 355,948.13 52,453,446.43 2019-04-01 2019-04-30 29    
FCO_201905.csv 115,027,181.64 667 0 172,454.55 12,500,000.00 2019-05-01 2019-05-31 30    
FCO_201906.csv 199,161,590.95 639 0 311,676.98 89,660,471.98 2019-06-01 2019-06-28 27    
FCO_201907.csv 107,759,397.45 663 0 162,533.03 15,600,000.00 2019-07-01 2019-07-31 30    
FCO_201908.csv 570,346,929.91 736 0 774,927.89 266,177,182.44 2019-08-01 2019-08-30 29     Large jump in TotalAmt. Jump in AvgAmt
FCO_201909.csv 133,005,345.21 706 0 188,392.84 18,000,000.00 2019-09-01 2019-09-30 29     Drop in TotalAmt.
FCO_201910.csv 185,473,544.17 832 0 222,924.93 20,000,000.00 2019-10-01 2019-10-31 30    
FCO_201911.csv 641,233,711.00 812 0 789,696.69 402,857,064.10 2019-11-01 2019-11-29 28     Jump in TotalAmt. Jump in AvgAmt

Total amount : £13,271,838,445.94 in 66,621 records from 106 source files (mean= £125,206,023 and 628 recs/mth) (Range=2011/01 - 2019/11)

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.