Summary of currently loaded spend data for: Department for International Trade

Lastfile: DIT_201911
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
DIT_201607.csv 40,995,690.18 54 0 759,179.45 16,359,794.60 2016-07-01 2016-07-29 28    
DIT_201608.csv 10,480,083.60 56 0 187,144.35 2,841,666.43 2016-08-02 2016-08-31 29     Drop in TotalAmt.
DIT_201609.csv 10,140,508.11 51 0 198,833.49 2,547,634.20 2016-09-01 2016-09-30 29    
DIT_201610.csv 41,686,454.73 58 0 718,731.98 18,106,638.43 2016-10-03 2016-10-31 28     Large jump in TotalAmt. Jump in AvgAmt
DIT_201611.csv 9,369,485.42 37 0 253,229.34 2,716,207.83 2016-11-01 2016-11-30 29     Drop in TotalAmt.
DIT_201612.csv 8,711,768.73 57 0 152,838.05 2,770,470.33 2016-12-01 2016-12-28 27    
DIT_201701.csv 52,593,743.03 57 0 922,697.25 22,055,374.95 2017-01-03 2017-01-30 27     Large jump in TotalAmt. Jump in AvgAmt
DIT_201702.csv 9,750,601.54 68 0 143,391.20 3,375,975.06 2017-02-01 2017-02-28 27     Large drop in TotalAmt. Drop in AvgAmt
DIT_201703.csv 26,158,315.81 152 0 172,094.18 2,927,405.02 2017-03-01 2017-03-31 30     Jump in TotalAmt.
DIT_201704.csv 57,808,429.80 138 0 418,901.67 25,188,866.64 2017-04-03 2017-04-28 25     Jump in TotalAmt. Jump in AvgAmt
DIT_201705.csv 10,166,573.25 54 0 188,269.88 3,861,074.46 2017-05-02 2017-05-26 24     Large drop in TotalAmt.
DIT_201706.csv 18,498,830.72 73 0 253,408.64 4,508,719.14 2017-06-01 2017-06-30 29    
DIT_201707.csv 18,010,227.36 94 0 191,598.16 10,955,921.00 2017-07-03 2017-07-31 28    
DIT_201708.csv 8,435,486.48 106 0 79,580.06 749,129.82 2017-08-01 2017-08-31 30    
DIT_201709.csv 7,782,489.36 84 0 92,648.68 1,258,441.61 2017-09-01 2017-09-29 28    
DIT_201710.csv 19,115,165.09 119 0 160,631.64 10,986,588.75 2017-10-02 2017-10-31 29     Jump in TotalAmt.
DIT_201711.csv 9,964,790.42 138 0 72,208.63 768,307.94 2017-11-01 2017-11-30 29    
DIT_201712.csv 11,506,128.20 135 0 85,230.58 1,343,867.91 2017-12-01 2017-12-29 28    
DIT_201801.csv 20,477,181.88 134 0 152,814.79 10,966,375.75 2018-01-02 2018-01-31 29    
DIT_201802.csv 17,477,431.33 153 0 114,231.58 5,613,317.48 2018-02-01 2018-02-28 27    
DIT_201803.csv 19,763,629.16 277 0 71,348.84 2,143,882.57 2018-03-05 2018-03-29 24    
DIT_201804.csv 28,567,247.35 185 0 154,417.55 4,000,000.00 2018-04-03 2018-04-30 27     Jump in AvgAmt
DIT_201805.csv 8,154,270.45 100 0 81,542.70 2,185,507.42 2018-05-01 2018-05-31 30     Drop in TotalAmt.
DIT_201806.csv 21,531,613.14 76 0 283,310.70 13,162,678.28 2018-06-01 2018-06-29 28     Jump in TotalAmt. Jump in AvgAmt
DIT_201807.csv 20,637,839.62 77 0 268,023.89 13,162,678.28 2018-07-02 2018-07-31 29    
DIT_201808.csv 12,607,530.79 89 0 141,657.65 2,669,260.19 2018-08-01 2018-08-31 30    
DIT_201809.csv 10,726,093.54 103 0 104,136.83 1,895,989.77 2018-03-12 2018-09-28 200    
DIT_201810.csv 9,588,143.79 152 0 63,079.89 2,051,550.11 2018-10-01 2018-10-31 30    
DIT_201811.csv 22,311,493.73 101 0 220,905.88 13,183,094.28 2018-11-01 2018-11-30 29     Jump in TotalAmt. Jump in AvgAmt
DIT_201812.csv 8,899,039.96 70 0 127,129.14 2,704,973.81 2018-12-04 2018-12-27 23     Drop in TotalAmt.
DIT_201901.csv 16,934,885.91 100 0 169,348.86 5,948,553.06 2019-01-02 2019-01-31 29    
DIT_201902.csv 22,963,994.97 72 0 318,944.37 13,273,966.28 2019-02-01 2019-02-28 27    
DIT_201903.csv 18,651,842.78 199 0 93,727.85 2,479,283.51 2019-03-01 2019-03-29 28    
DIT_201904.csv 19,333,449.48 172 0 112,403.78 4,848,067.69 2019-04-01 2019-04-30 29    
DIT_201905.csv 8,167,923.77 98 0 83,346.16 2,256,344.08 2019-05-01 2019-05-31 30    
DIT_201906.csv 8,646,657.81 87 0 99,386.87 2,500,253.13 2019-06-03 2019-06-28 25    
DIT_201907.csv 10,755,808.87 104 0 103,421.24 2,558,449.09 2019-07-01 2019-07-31 30    
DIT_201908.csv 35,146,338.21 97 0 362,333.38 12,938,760.74 2019-08-01 2019-08-30 29     Jump in TotalAmt. Jump in AvgAmt
DIT_201909.csv 9,311,538.71 97 0 95,995.24 2,879,552.78 2019-09-02 2019-09-30 28     Drop in TotalAmt.
DIT_201910.csv 21,790,163.66 106 0 205,567.58 13,134,822.75 2019-10-01 2019-10-31 30     Jump in TotalAmt. Jump in AvgAmt
DIT_201911.csv 6,590,232.25 131 0 50,307.12 823,176.10 2019-11-01 2019-11-29 28     Drop in TotalAmt.

Total amount : £750,209,122.99 in 4,311 records from 41 source files (mean= £18,297,783 and 105 recs/mth) (Range=2016/07 - 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.