Summary of currently loaded spend data for: Department for Transport

Lastfile: DFT_201911
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
DFT_201101.csv 884,060,593.83 2458 0 359,666.64 261,182,574.40 2010-11-23 2011-02-18 87    
DFT_201102.csv 954,285,740.23 2813 0 339,241.29 261,182,574.36 2011-01-13 2011-03-29 75    
DFT_201103.csv 1,548,533,369.28 3683 0 420,454.35 261,182,574.36 2011-01-20 2011-03-31 70    
DFT_201104.csv 1,840,925,606.70 7216 0 255,117.18 275,532,923.10 2010-12-07 2011-04-30 144    
DFT_201105.csv 1,029,631,596.55 6653 0 154,762.00 275,532,923.07 2010-12-08 2011-11-04 331    
DFT_201106.csv 1,195,218,690.99 6854 0 174,382.65 275,532,923.07 2010-12-14 2011-07-05 203    
DFT_201107.csv 1,025,917,113.75 4813 0 213,155.44 275,532,923.10 2011-04-18 2011-07-31 104    
DFT_201108.csv 870,919,527.83 7838 0 111,115.02 275,532,923.10 2011-04-26 2011-08-31 127    
DFT_201109.csv 1,398,928,464.10 8381 0 166,916.65 275,532,923.07 2011-06-06 2011-10-03 119    
DFT_201110.csv 1,157,502,976.42 7962 0 145,378.42 275,532,923.07 2010-09-23 2011-11-11 414    
DFT_201111.csv 992,801,718.67 7905 0 125,591.62 275,532,923.10 2011-09-06 2011-11-30 85    
DFT_201112.xls 1,494,708,993.38 7517 0 198,843.82 275,532,923.07 2011-07-29 2012-01-19 174    
DFT_201201.csv 1,264,127,724.03 7936 0 159,290.29 275,532,923.07 2011-01-13 2012-11-20 677    
DFT_201202.csv 896,669,080.75 8641 0 103,769.13 275,532,923.07 2011-12-29 2012-02-29 62    
DFT_201203.csv 1,458,503,432.44 11403 0 127,905.24 275,532,923.10 2011-07-26 2012-04-04 253    
DFT_201204.csv 1,899,712,486.47 6723 0 282,569.16 301,250,000.00 2012-03-12 2012-05-08 57     Jump in AvgAmt
DFT_201205.csv 1,054,953,585.41 7985 0 132,116.92 284,308,307.70 2012-02-24 2012-11-05 255    
DFT_201206.csv 1,340,733,152.76 7579 0 176,901.06 301,250,000.00 2012-04-27 2012-07-02 66    
DFT_201207.csv 1,133,501,936.90 8972 0 126,337.71 284,308,307.70 2012-05-25 2012-08-06 73    
DFT_201208.csv 931,565,580.91 8131 0 114,569.62 284,308,307.70 2012-05-08 2012-09-11 126    
DFT_201209.csv 1,241,727,804.50 7084 0 175,286.25 301,250,000.00 2012-07-26 2012-10-12 78    
DFT_201210.csv 1,503,674,901.10 8441 0 178,139.43 284,308,307.69 2012-07-31 2012-11-02 94    
DFT_201211.csv 1,058,184,094.04 7845 0 134,886.44 284,308,307.70 2010-11-23 2012-12-03 741    
DFT_201212.csv 1,536,028,530.10 7423 0 206,928.27 301,250,000.00 2012-05-30 2021-12-19 3490    
DFT_201301.csv 1,237,918,467.23 7970 0 155,322.27 284,308,307.70 2012-04-30 2013-02-21 297    
DFT_201302.csv 929,263,747.76 7879 0 117,941.84 284,308,307.70 2012-09-24 2013-03-29 186    
DFT_201303.csv 1,742,185,219.79 10746 0 162,124.07 284,308,307.70 2012-05-30 2013-03-31 305    
DFT_201304.csv 1,394,152,661.26 8191 0 170,205.43 268,631,822.20 2012-04-10 2013-05-03 388    
DFT_201305.csv 873,066,722.18 8010 0 108,997.09 268,631,822.20 2013-03-26 2013-10-05 193    
DFT_201306.csv 1,396,198,471.12 8214 0 169,977.90 280,694,078.00 2013-04-27 2013-07-01 65    
DFT_201307.csv 1,205,419,083.25 8393 0 143,621.96 268,631,822.20 2013-04-02 2013-09-07 158    
DFT_201308.csv 904,153,907.82 9403 0 96,155.90 268,631,822.20 2013-06-17 2013-09-05 80    
DFT_201309.csv 1,297,047,080.25 8117 0 159,793.90 280,694,078.00 2013-06-12 2013-11-09 150    
DFT_201310.csv 1,287,462,354.10 9791 0 131,494.47 268,631,822.20 2013-02-10 2013-11-18 281    
DFT_201311.csv 1,084,740,437.59 9118 0 118,966.93 268,631,822.20 2013-10-01 2013-12-03 63    
DFT_201312.csv 1,619,738,804.78 7994 0 202,619.32 280,694,078.00 2013-11-05 2014-01-07 63    
DFT_201401.csv 1,085,619,367.03 9517 0 114,071.59 268,631,822.20 2013-11-01 2014-02-05 96    
DFT_201402.csv 871,621,790.23 8613 0 101,198.40 268,631,822.20 2013-12-19 2014-04-06 108    
DFT_201403.csv 1,990,231,827.57 11703 0 170,061.68 287,493,147.80 2013-06-12 2014-04-03 295     Jump in TotalAmt.
DFT_201404.csv 1,389,148,708.13 8552 0 162,435.54 287,493,147.80 2013-05-19 2014-05-13 359    
DFT_201405.csv 998,428,452.16 9209 0 108,418.77 287,493,147.80 2014-01-31 2014-06-02 122    
DFT_201406.csv 1,465,023,922.31 8800 0 166,479.99 287,493,147.80 2013-09-12 2014-07-01 292    
DFT_201407.csv 2,267,636,725.63 10259 0 221,038.77 450,000,000.00 2014-01-13 2014-08-04 203    
DFT_201408.csv 932,593,115.60 9621 0 96,933.08 287,493,147.80 2014-03-13 2014-11-24 256    
DFT_201409.csv 1,745,659,970.89 9382 0 186,064.80 287,493,147.80 2014-04-08 2014-10-02 177    
DFT_201410.csv 1,898,034,065.54 9727 0 195,130.47 287,493,147.80 2014-07-31 2014-10-31 92    
DFT_201411.csv 1,412,607,252.82 9925 0 142,328.19 287,493,147.80 2014-05-02 2014-12-11 223    
DFT_201412.csv 4,791,332,353.10 8371 0 572,372.76 900,000,000.00 2012-01-01 2015-01-06 1101     Jump in TotalAmt. Jump in AvgAmt
DFT_201501.csv 1,311,428,985.13 9287 0 141,211.26 287,493,147.80 2014-10-02 2015-02-05 126     Drop in TotalAmt.
DFT_201502.csv 1,234,440,183.12 8659 0 142,561.52 287,493,147.80 2014-03-04 2015-09-01 546    
DFT_201503.csv 2,669,519,856.39 14865 0 179,584.25 355,900,000.00 2014-04-09 2015-12-03 603     Jump in TotalAmt.
DFT_201504.csv 1,913,586,927.72 8930 0 214,287.45 295,019,785.50 2014-06-18 2015-10-04 473    
DFT_201505.csv 2,758,014,870.74 9353 0 294,880.24 400,000,000.00 2014-03-06 2015-06-10 461    
DfT_201506.csv 2,128,627,278.43 10374 0 205,188.67 295,019,785.50 2014-05-16 2015-12-06 569    
DfT_201507.csv 1,727,020,050.32 9749 0 177,148.43 295,019,785.50 2015-03-02 2015-10-07 219    
DFT_201508.csv 1,651,425,718.51 8888 0 185,803.97 312,800,000.00 2015-03-12 2016-08-21 528    
DFT_201509.csv 1,901,009,478.61 8524 0 223,018.47 295,019,785.53 2015-08-26 2015-10-09 44    
DFT_201510.csv 2,853,098,896.44 8987 0 317,469.56 295,019,785.53 2015-09-29 2015-10-31 32    
DFT_201511.csv 1,841,681,749.62 8534 0 215,805.22 317,800,000.00 2015-11-01 2016-11-03 368    
DFT_201512.csv 2,155,162,252.39 8632 0 249,671.25 295,019,785.50 2015-10-07 2016-01-07 92    
DFT_201601.csv 2,093,397,999.50 8151 0 256,827.14 305,000,000.00 2016-01-01 2016-01-31 30    
DFT_201602.csv 2,934,206,745.81 8320 0 352,669.08 307,000,000.00 2016-02-01 2016-02-29 28    
DFT_201603.csv 2,489,391,603.74 9588 0 259,636.17 350,000,000.00 2016-03-01 2016-03-31 30    
DFT_201604.csv 1,940,176,722.27 9417 0 206,029.17 301,237,923.66 2016-04-01 2016-04-30 29    
DFT_201605.csv 1,465,046,129.58 8687 0 168,648.11 301,237,923.66 2016-02-02 2016-06-03 122    
DFT_201606.csv 1,751,053,690.15 8870 0 197,413.04 301,237,923.70 2016-03-19 2016-07-11 114    
DFT_201607.csv 1,684,461,944.44 8841 0 190,528.44 301,237,923.66 2016-03-17 2016-07-31 136    
DFT_201608.csv 1,790,385,468.50 8578 0 208,718.29 301,237,923.70 2016-04-29 2016-08-31 124    
DFT_201609.xlsx 1,689,075,724.64 9473 0 178,304.20 301,237,923.66 2016-07-11 2016-09-30 81    
DFT_201610.xlsx 1,605,542,546.39 9184 0 174,819.53 301,237,923.66 2016-07-18 2016-10-31 105    
DFT_201611.xlsx 3,223,636,787.91 9068 0 355,495.90 325,000,000.00 2016-07-18 2016-11-30 135     Jump in TotalAmt. Jump in AvgAmt
DFT_201612.xlsx 2,351,783,604.17 8710 0 270,009.60 301,237,923.66 2012-12-30 2016-12-31 1462    
DFT_201701.xlsx 1,539,320,617.17 8222 0 187,219.73 301,237,923.66 2016-11-30 2017-01-31 62    
DFT_201702.xlsx 1,620,379,162.30 10074 0 160,847.64 345,000,000.00 2016-04-08 2017-02-28 326    
DFT_201703.xlsx 2,562,624,772.54 12395 0 206,746.65 400,000,000.00 2016-10-19 2017-04-04 167    
DFT_201704.xlsx 2,611,688,413.40 8084 0 323,068.83 350,000,000.00 2017-01-25 2017-05-02 97    
DFT_201705.xlsx 1,853,524,148.73 7989 0 232,009.53 340,000,000.00 2017-03-15 2017-05-31 77    
DFT_201706.csv 1,971,995,212.77 8213 0 240,106.56 425,000,000.00 2017-03-14 2017-06-30 108    
DFT_201707.csv 1,950,083,728.26 10258 0 190,103.70 311,871,621.72 2017-03-31 2017-07-31 122    
DFT_201708.csv 2,451,727,862.29 3380 0 725,363.27 900,000,000.00 2017-03-01 2017-09-01 184     Jump in AvgAmt
DFT_201709.csv 2,157,254,110.92 3633 0 593,794.14 340,000,000.00 2017-05-01 2017-10-01 153    
DFT_201710.csv 1,580,180,409.20 8533 0 185,184.63 311,871,621.70 2017-05-10 2017-11-08 182    
DFT_201711.csv 2,728,307,160.24 3876 0 703,897.62 375,000,000.00 2017-05-01 2017-12-01 214     Jump in AvgAmt
DFT_201712.csv 2,265,263,304.11 4665 0 485,586.99 311,871,621.70 2017-01-01 2018-01-01 365    
DFT_201801.csv 1,415,301,160.52 5811 0 243,555.53 311,871,621.70 2017-01-01 2018-02-01 396    
DFT_201802.csv 1,372,670,588.32 5772 0 237,815.42 325,000,000.00 2017-10-01 2018-02-01 123    
DFT_201803.csv 3,297,364,362.90 5998 0 549,743.98 345,000,000.00 2017-10-01 2018-04-01 182     Jump in TotalAmt. Jump in AvgAmt
DFT_201804.csv 3,047,075,941.31 5641 0 540,165.92 395,000,000.00 2018-01-01 2018-04-01 90    
DFT_201805.csv 1,988,991,864.90 6033 0 329,685.37 470,000,000.00 2017-09-01 2018-06-01 273    
DFT_201806.csv 1,647,533,621.13 2669 0 617,284.98 350,000,000.00 2018-03-30 2018-07-09 101    
DFT_201807.csv 1,755,430,768.09 4919 0 356,867.41 313,000,000.00 2018-05-31 2018-07-31 61    
DFT_201808.csv 1,822,557,175.48 1682 0 1,083,565.50 370,000,000.00 2018-03-30 2018-08-31 154     Jump in AvgAmt
DFT_201809.csv 1,987,850,116.99 1520 0 1,307,796.13 320,000,000.00 2018-03-30 2018-09-30 184    
DFT_201810.csv 1,800,464,340.52 1848 0 974,277.24 291,222,189.18 2018-03-30 2018-10-31 215    
DFT_201811.csv 2,793,352,956.73 2040 0 1,369,290.67 390,000,000.00 2018-03-30 2018-11-30 245    
DFT_201812.csv 2,693,114,586.12 1810 0 1,487,908.61 350,000,000.00 2018-11-09 2018-12-31 52    
DFT_201901.csv 1,588,238,504.17 1845 0 860,833.88 291,222,189.18 2018-04-04 2019-01-31 302    
DFT_201902.csv 1,824,394,734.01 1654 0 1,103,019.79 360,000,000.00 2018-09-25 2019-02-28 156    
DFT_201903.csv 2,450,276,767.12 2585 0 947,882.70 425,000,000.00 2017-12-14 2020-02-28 806    
DFT_201904.csv 2,735,697,527.59 2203 0 1,241,805.51 527,000,000.00 2019-03-15 2019-04-30 46    
DFT_201905.csv 2,382,034,890.27 1836 0 1,297,404.62 390,000,000.00 2019-04-18 2019-05-31 43    
DFT_201906.csv 2,079,572,564.86 1612 0 1,290,057.42 315,967,000.00 2019-04-02 2019-06-30 89    
DFT_201907.csv 1,164,711,291.27 1527 0 762,744.79 590,028,860.00 2019-06-21 2019-07-31 40    
DFT_201908.csv 941,613,270.09 1672 0 563,165.83 72,000,000.00 2019-06-06 2019-08-31 86    
DFT_201909.csv 2,171,158,821.23 1819 0 1,193,600.23 440,000,000.00 2018-09-13 2019-09-30 382     Jump in TotalAmt. Jump in AvgAmt
DFT_201910.csv 2,767,826,326.38 1966 0 1,407,846.55 299,000,000.00 2019-04-10 2019-10-31 204    
DFT_201911.csv 2,092,148,681.25 1323 0 1,581,367.11 460,000,000.00 2019-09-10 2019-11-30 81    

Total amount : £187,807,006,186.98 in 766,537 records from 107 source files (mean= £1,755,205,665 and 7,163 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.