Summary of currently loaded spend data for: Department for Environment, Food & Rural Affairs

Lastfile: Defra_201911
File name TotalAmt£ OrigRecs AggRecs     AvgAmt£ MaxAmt£           MinDate       MaxDate     Diff     Comment
Defra_201101.csv 225,914,548.37 222 0 1,017,633.10 50,000,000.00 2011-01-04 2011-01-31 27    
Defra_201102.csv 338,479,754.39 266 0 1,272,480.28 66,000,000.00 2011-02-01 2011-02-28 27    
Defra_201103.csv 279,805.18 5 0 55,961.04 82,136.15 2011-03-04 2011-03-25 21     Large drop in TotalAmt. Drop in AvgAmt
Defra_201104.csv 183,003,706.65 251 0 729,098.43 55,012,000.00 2011-04-01 2011-04-28 27     Large jump in TotalAmt. Jump in AvgAmt
Defra_201105.csv 80,139,796.56 201 0 398,705.46 15,000,000.00 2011-05-03 2011-05-27 24    
Defra_201106.csv 121,753,942.27 209 0 582,554.75 28,000,000.00 2011-06-01 2011-06-30 29    
Defra_201107.csv 18,792,394.72 62 0 303,103.14 7,512,386.35 2011-07-04 2011-07-28 24     Large drop in TotalAmt.
Defra_201108.csv 106,148,255.59 208 0 510,328.15 29,000,000.00 2011-08-01 2011-08-30 29     Large jump in TotalAmt.
Defra_201109.csv 26,537,141.43 64 0 414,642.83 8,661,279.65 2011-09-01 2011-09-30 29     Drop in TotalAmt.
Defra_201110.csv 17,616,234.38 68 0 259,062.27 6,267,479.43 2011-10-04 2011-10-29 25    
Defra_201111.csv 16,517,285.03 57 0 289,776.93 6,277,936.76 2011-11-02 2011-11-30 28    
Defra_201112.csv 81,415.20 1 0 81,415.20 81,415.20 2011-12-12 2011-12-12 0     Large drop in TotalAmt.
Defra_201201.csv 187,353,905.97 232 0 807,559.94 56,000,000.00 2012-01-03 2012-01-30 27     Large jump in TotalAmt. Jump in AvgAmt
Defra_201202.csv 174,651,541.33 263 0 664,074.30 50,000,000.00 2012-02-01 2012-02-29 28    
Defra_201203.csv 689,700,792.22 363 0 1,900,002.18 258,199,000.00 2012-03-02 2012-03-30 28     Jump in TotalAmt. Jump in AvgAmt
Defra_201204.csv 140,745,479.24 250 0 562,981.92 39,936,000.00 2012-04-03 2012-04-27 24     Drop in TotalAmt.
Defra_201206.csv 114,232,091.15 144 0 793,278.41 20,000,000.00 2012-06-06 2012-06-29 23    
Defra_201207.csv 158,414,741.16 195 0 812,383.29 52,000,000.00 2012-07-02 2012-07-30 28    
Defra_201208.csv 105,826,754.66 191 0 554,066.78 45,000,000.00 2012-08-01 2012-08-31 30    
Defra_201209.csv 175,197,815.78 154 0 1,137,648.15 70,000,000.00 2012-09-04 2012-09-28 24     Jump in AvgAmt
Defra_201210.csv 256,995,186.59 655 0 392,359.06 55,000,000.00 2012-10-01 2012-10-31 30    
Defra_201211.csv 176,750,433.18 781 0 226,312.97 30,000,000.00 2012-05-11 2012-11-30 203    
Defra_201212.csv 254,848,959.04 647 0 393,893.29 90,000,000.00 2012-12-03 2013-12-14 376    
Defra_201301.csv 225,939,298.47 681 0 331,775.77 60,000,000.00 2012-07-09 2013-02-08 214    
Defra_201302.csv 207,479,014.63 886 0 234,174.96 50,000,000.00 2012-12-30 2013-03-18 78    
Defra_201303.csv 468,795,523.62 1503 0 311,906.54 175,090,000.00 2013-02-18 2013-03-28 38     Jump in TotalAmt.
Defra_201304.csv 293,422,823.20 980 0 299,411.04 60,000,000.00 2013-03-05 2013-04-30 56    
Defra_201305.csv 150,920,866.71 676 0 223,255.72 20,000,000.00 2013-03-11 2013-05-31 81    
Defra_201306.csv 169,656,858.84 578 0 293,523.98 19,624,878.00 2013-06-01 2013-06-28 27    
Defra_201307.csv 206,862,330.00 637 0 324,744.63 45,000,000.00 2013-07-01 2013-08-29 59    
Defra_201308.csv 180,940,972.06 598 0 302,576.88 45,000,000.00 2013-07-08 2013-09-08 62    
Defra_201309.csv 207,882,103.96 532 0 390,755.83 65,000,000.00 2013-09-02 2013-10-15 43    
Defra_201310.csv 256,505,556.37 645 0 397,683.03 65,000,000.00 2013-09-30 2013-10-31 31    
Defra_201311.csv 160,777,751.88 627 0 256,423.85 45,000,000.00 2013-11-01 2013-11-29 28    
Defra_201312.csv 240,779,337.36 660 0 364,817.18 80,000,000.00 2013-12-02 2013-12-31 29    
Defra_201401.csv 225,937,282.04 573 0 394,305.90 35,000,000.00 2013-01-13 2014-02-01 384    
Defra_201402.csv 300,114,970.75 691 0 434,319.78 80,000,000.00 2013-10-31 2014-03-03 123    
Defra_201403.csv 340,582,971.69 1076 0 316,526.93 92,154,000.00 2013-12-19 2014-04-02 104    
Defra_201404.csv 315,520,403.25 883 0 357,327.75 95,000,000.00 2014-04-01 2014-04-30 29    
Defra_201405.csv 148,511,750.83 574 0 258,731.27 30,000,000.00 2014-01-05 2014-06-04 150    
Defra_201406.csv 199,256,867.39 598 0 333,205.46 55,000,000.00 2014-03-11 2014-07-08 119    
Defra_201407.csv 229,554,416.93 585 0 392,400.71 60,000,000.00 2014-05-07 2014-07-31 85    
Defra_201408.csv 122,489,448.72 510 0 240,175.39 15,000,000.00 2014-03-14 2014-09-09 179    
Defra_201409.csv 250,247,742.52 521 0 480,321.96 75,000,000.00 2014-03-11 2014-09-30 203     Jump in TotalAmt.
Defra_201410.csv 310,825,752.25 645 0 481,900.39 90,000,000.00 2014-10-01 2014-10-31 30    
Defra_201411.csv 205,558,522.00 587 0 350,184.88 50,000,000.00 2014-11-03 2014-11-28 25    
Defra_201412.csv 270,381,493.04 711 0 380,283.39 95,000,000.00 2014-12-01 2014-12-31 30    
Defra_201501.csv 238,223,865.85 498 0 478,361.18 110,000,000.00 2015-01-02 2015-01-30 28    
Defra_201502.csv 225,771,527.74 661 0 341,560.56 80,000,000.00 2015-02-02 2015-02-27 25    
Defra_201503.csv 438,713,607.55 1552 0 282,676.29 62,500,000.00 2015-03-01 2015-03-31 30    
Defra_201504.csv 326,193,666.09 923 0 353,405.92 100,000,000.00 2015-04-01 2015-04-30 29    
Defra_201505.csv 123,416,608.74 544 0 226,868.77 14,000,000.00 2015-04-30 2015-05-29 29     Drop in TotalAmt.
Defra_201506.csv 235,512,134.56 565 0 416,835.64 36,712,635.00 2015-05-28 2015-06-30 33    
Defra_201507.csv 188,509,502.63 594 0 317,356.07 60,000,000.00 2015-06-18 2015-07-31 43    
Defra_201508.csv 187,050,345.97 485 0 385,670.82 85,000,000.00 2015-08-03 2015-08-28 25    
Defra_201509.csv 232,563,240.26 512 0 454,225.08 37,980,680.00 2015-09-01 2015-09-30 29    
Defra_201510.csv 143,328,303.61 361 0 397,031.31 50,000,000.00 2015-09-14 2015-10-30 46    
Defra_201511.csv 164,484,829.28 301 0 546,461.23 50,000,000.00 2015-11-02 2015-11-30 28    
Defra_201512.csv 183,862,354.23 318 0 578,183.50 85,000,000.00 2015-10-14 2016-12-21 434    
Defra_201601.csv 180,630,605.81 288 0 627,189.60 85,000,000.00 2016-01-04 2016-02-04 31    
Defra_201602.csv 127,424,532.46 307 0 415,063.62 60,000,000.00 2016-02-01 2016-02-29 28    
Defra_201603.csv 251,795,199.36 488 0 515,973.77 46,018,607.00 2016-02-25 2016-03-31 35    
Defra_201604.csv 172,812,757.70 363 0 476,068.20 50,000,000.00 2016-03-31 2016-04-29 29    
Defra_201605.csv 68,455,581.87 181 0 378,207.63 15,000,000.00 2016-04-19 2016-05-31 42     Drop in TotalAmt.
Defra_201606.csv 159,423,041.96 344 0 463,439.08 40,000,000.00 2016-04-13 2016-06-30 78     Jump in TotalAmt.
Defra_201607.csv 258,629,014.71 319 0 810,749.26 70,000,000.00 2016-05-06 2016-07-29 84    
Defra_201608.csv 231,264,738.40 289 0 800,224.01 100,000,000.00 2016-07-05 2016-08-31 57    
Defra_201609.csv 109,922,578.93 308 0 356,891.49 26,691,028.00 2016-08-08 2016-09-30 53    
Defra_201610.csv 174,920,819.46 325 0 538,217.91 78,138,000.00 2016-09-01 2016-10-31 60    
Defra_201611.csv 154,233,650.14 270 0 571,235.74 90,000,000.00 2016-10-04 2016-11-30 57    
Defra_201612.csv 245,841,992.19 288 0 853,618.03 130,000,000.00 2015-12-15 2016-12-30 381    
Defra_201701.csv 156,311,319.71 268 0 583,251.19 80,000,000.00 2016-12-29 2017-02-01 34    
Defra_201702.csv 1,151,162,936.79 282 0 4,082,138.07 1,000,000,000.00 2016-02-05 2017-02-28 389     Large jump in TotalAmt. Jump in AvgAmt
Defra_201703.csv 243,657,936.35 372 0 654,994.45 65,000,000.00 2017-03-01 2017-03-31 30     Drop in TotalAmt. Drop in AvgAmt
Defra_201704.csv 180,784,348.34 357 0 506,398.73 50,000,000.00 2016-09-15 2017-04-28 225    
Defra_201705.csv 108,744,249.04 336 0 323,643.60 40,000,000.00 2017-02-21 2017-05-31 99    
Defra_201706.csv 166,523,490.23 281 0 592,610.29 50,000,000.00 2017-04-26 2017-06-30 65    
Defra_201707.csv 134,263,918.41 284 0 472,760.28 45,000,000.00 2017-06-02 2017-07-31 59    
Defra_201708.csv 103,050,630.87 333 0 309,461.35 50,000,000.00 2017-06-30 2017-08-31 62    
Defra_201709.csv 179,819,185.01 234 0 768,458.06 90,000,000.00 2017-08-21 2017-09-29 39     Jump in AvgAmt
Defra_201710.csv 208,091,002.48 387 0 537,702.85 80,000,000.00 2017-08-22 2017-10-31 70    
Defra_201711.csv 107,684,782.52 265 0 406,357.67 60,000,000.00 2017-10-31 2017-11-30 30    
Defra_201712.csv 194,268,293.49 291 0 667,588.64 90,000,000.00 2017-11-30 2017-12-29 29    
Defra_201801.csv 187,807,768.09 336 0 558,951.69 80,000,000.00 2017-10-31 2018-01-31 92    
Defra_201802.csv 1,223,756,399.79 331 0 3,697,149.24 1,100,000,000.00 2018-02-01 2018-02-28 27     Large jump in TotalAmt. Jump in AvgAmt
Defra_201803.csv 298,845,247.22 472 0 633,146.71 120,000,000.00 2018-02-26 2018-03-31 33     Drop in TotalAmt. Drop in AvgAmt
Defra_201804.csv 227,170,575.66 406 0 559,533.44 90,000,000.00 2018-03-29 2018-04-30 32    
Defra_201805.csv 417,488,192.23 399 0 1,046,336.32 200,000,000.00 2018-05-01 2018-05-31 30    
Defra_201806.csv 165,194,107.79 324 0 509,858.36 60,000,000.00 2018-05-31 2018-06-29 29     Drop in TotalAmt.
Defra_201807.csv 163,787,745.87 361 0 453,705.67 75,000,000.00 2018-06-22 2018-07-31 39    
Defra_201808.csv 132,724,887.41 413 0 321,367.77 45,000,000.00 2018-08-01 2018-08-31 30    
Defra_201809.csv 180,444,823.32 297 0 607,558.33 75,000,000.00 2018-09-01 2018-09-28 27    
Defra_201810.csv 226,504,489.02 429 0 527,982.49 90,000,000.00 2018-10-01 2018-10-31 30    
Defra_201811.csv 108,418,584.72 325 0 333,595.65 45,000,000.00 2018-09-20 2018-11-30 71    
Defra_201812.csv 210,937,354.74 390 0 540,865.01 70,000,000.00 2018-09-20 2018-12-31 102    
Defra_201901.csv 162,268,421.58 341 0 475,860.47 75,000,000.00 2018-11-30 2019-01-31 62    
Defra_201902.csv 153,038,236.51 384 0 398,537.07 55,000,000.00 2018-12-03 2019-03-01 88    
Defra_201903.csv 236,561,309.19 522 0 453,182.58 120,000,000.00 2019-02-28 2019-03-29 29    
Defra_201904.csv 211,271,200.07 448 0 471,587.50 80,000,000.00 2019-04-01 2019-04-30 29    
Defra_201905.csv 135,732,720.45 413 0 328,650.65 50,000,000.00 2019-05-01 2019-05-31 30    
Defra_201906.csv 196,361,398.88 469 0 418,681.02 75,000,000.00 2019-06-03 2019-06-28 25    
Defra_201907.csv 156,936,993.25 433 0 362,441.09 40,000,000.00 2019-07-01 2019-07-31 30    
Defra_201908.csv 89,155,015.52 317 0 281,246.11 30,000,000.00 2019-08-01 2019-08-30 29    
Defra_201909.csv 177,257,413.56 381 0 465,242.56 60,000,000.00 2019-09-02 2019-09-30 28    
Defra_201910.csv 202,432,906.28 382 0 529,929.07 70,000,000.00 2019-10-01 2019-10-31 30    
Defra_201911.csv 200,506,331.84 377 0 531,847.03 115,000,000.00 2019-10-21 2019-12-02 42    

Total amount : £22,480,874,754.33 in 46,170 records from 106 source files (mean= £212,083,724 and 435 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.